https://giteecode.feishu.cn/wiki/FhISwfnuHia41xk5mzvcfdoMnYc

SELECT 
    sum(rows) AS `总行数`,
    formatReadableSize(sum(data_uncompressed_bytes)) AS `原始大小`,
    formatReadableSize(sum(data_compressed_bytes)) AS `压缩大小`,
    round((sum(data_compressed_bytes) / sum(data_uncompressed_bytes)) * 100, 0) AS `压缩率`
FROM system.parts

https://giteecode.feishu.cn/wiki/BytWw9Sq0iK3fIkUk5ocChC0n1f



echo 65535 > /proc/sys/net/core/somaxconn
echo 1 > /proc/sys/vm/overcommit_memory

sysctl -w net.core.somaxconn=65535
sysctl -w vm.overcommit_memory=1
echo "net.core.somaxconn = 65535" | tee -a /etc/sysctl.d/99-redis.conf
echo "vm.overcommit_memory = 1" | tee -a /etc/sysctl.d/99-redis.conf


sysctl -w kernel.threads-max=262144
sysctl -w kernel.task_delayacct=1
sysctl -w vm.swappiness=1

cat >/etc/sysctl.d/99-clickhouse.conf<<EOF
vm.swappiness=1
kernel.task_delayacct = 1
kernel.threads-max = 262144
EOF




id redis || useradd -u 6379 redis -s /sbin/nologin -M


install -d /data/redis/DATA \
           /data/redis/LOGS \
           -o redis \
           -g redis



SELECT name AS table_name, formatReadableSize(total_bytes) AS total_size, formatReadableSize(total_rows) AS rows_size,total_rows AS rows_count FROM system.tables WHERE database = 'opera_log' ORDER BY total_bytes DESC;


SELECT database, formatReadableSize(sum(bytes_on_disk)) AS size FROM system.parts WHERE active GROUP BY database ORDER BY sum(bytes_on_disk) DESC;



ALTER TABLE system.trace_log MODIFY TTL event_date + INTERVAL 7 DAY;



<yandex>
  <trace_log remove="1" />
</yandex>




SELECT formatReadableSize(sum(bytes_on_disk)) AS size, min(event_time) AS oldest_log, max(event_time) AS newest_log FROM system.parts WHERE database = 'system' AND table = 'trace_log' AND active;



-- 查看 trace_log 当前占用空间
SELECT formatReadableSize(sum(bytes)) AS size, min(event_time) AS oldest_log, max(event_time) AS newest_log, count() AS entries FROM system.parts WHERE database = 'system' AND table = 'trace_log';

-- 删除所有 trace_log 数据（紧急清理）
ALTER TABLE system.trace_log DELETE WHERE 1=1;

-- 或者删除指定时间前的数据
ALTER TABLE system.trace_log DELETE 
WHERE event_time < now() - INTERVAL 7 DAY;

-- 强制合并，立即释放磁盘空间
OPTIMIZE TABLE system.trace_log FINAL;




-- 删除7天前的日志
ALTER TABLE system.text_log DELETE 
WHERE event_time < now() - INTERVAL 7 DAY;

-- 删除指定级别以外的日志（例如只保留ERROR级别）
ALTER TABLE system.text_log DELETE 
WHERE event_time < now() - INTERVAL 3 DAY AND level != 'Error';

-- 删除所有text_log数据（紧急情况）
ALTER TABLE system.text_log DELETE WHERE 1=1;



-- 为text_log表添加TTL（自动过期7天前的数据）
ALTER TABLE system.text_log 
MODIFY TTL event_date + INTERVAL 7 DAY;

-- 或者基于event_time字段
ALTER TABLE system.text_log 
MODIFY TTL event_time + INTERVAL 7 DAY;





cat >${conf_dir}/policy.json<<EOF
{
  "default": [
    {
      "type": "insecureAcceptAnything"
    }
  ],
  "transports": {
    "docker": {
      "registry.access.redhat.com": [
        {
          "type": "signedBy",
          "keyType": "GPGKeys",
          "keyPath": "/etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release"
        }
      ],
      "registry.redhat.io/redhat/redhat-operator-index": [
        {
          "type": "insecureAcceptAnything"
        }
      ],
      "registry.redhat.io": [
        {
          "type": "signedBy",
          "keyType": "GPGKeys",
          "keyPath": "/etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release"
        }
      ]
    },
    "docker-daemon": {
      "": [
        {
          "type": "insecureAcceptAnything"
        }
      ]
    }
  }
}
EOF