P
Переделали логику на вставку через Buffer-таблицу - стало збс.
Size: a a a
P
S
S
P
clickhouse-router.ringostat.net :) SELECT * FROM system.metrics WHERE metric = 'DistributedFilesToInsert';
SELECT *
FROM system.metrics
WHERE metric = 'DistributedFilesToInsert'
┌─metric───────────────────┬──value─┬─description───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ DistributedFilesToInsert │ 906970 │ Number of pending files to process for asynchronous insertion into Distributed tables. Number of files for every shard is summed. │
└──────────────────────────┴────────┴───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
1 rows in set. Elapsed: 0.132 sec.
K
DP
IS
DT
IS
IS
DT
select * from system.merges;
IS
select * from system.merges;
DT
IS
select * from system.merges;
DT
SYSTEM RESTART REPLICA db.table;
DT
IS
SYSTEM RESTART REPLICA db.table;
DT
IS
DC