ClickHouse
Tomato Data Stats
2025-01-22 Table Size┌─database─┬─table───────────────────┬─size───────┬───────rows─┬───bytes_si...
Manual
Table Engine
The MergeTree engine and other engines of the MergeTree family (e.g. ReplacingMergeTree, Aggregat...
Table TTL
https://clickhouse.com/docs/sql-reference/functions/date-time-functions Precise TTL TTL is relat...
Disk Usage SQL
Disk Info SELECT name, path, formatReadableSize(free_space) AS free, formatRead...
Mutations and Processes
Syatem.mutations Get Recently SELECT * FROM system.mutations WHERE is_done = 0 ORDER BY create_t...
Truncate Table
TRUNCATE TABLE default.jaeger_span; It will report error Reason: 1. Size (51.37 GB) is greater t...
Shard & Replicas
Data Sharding
数据分片定义 数据分片（Sharding） 是一种将大数据集拆分成多个小数据集并存储在不同服务器上的方法，常用于数据库、分布式存储、对象存储等系统，以提高性能、可扩展性和数据管理效率。 简单来...