clickhouse日常維護

1.查詢正在執行的sql

select query_id, user, address, query  FROM system.processes ORDER BY query_id;

終止查詢:

kill query where query_id = 'query_id'

2.查詢mutations

SELECT 和 INSERT 之外，在 ClickHouse 中還存在一類被稱作 Mutation 的操作，也就是 ALTER DELETE 和 ALTER UPDATE

SELECT database, table, mutation_id, command, create_time, is_done FROM system.mutations;

終止mutation

kill mutation where mutation_id = 'mutation_id';

3.各資料庫占用空間統計

4.檢視字段壓縮比

5.慢查詢

6.表壓縮大小