卡死瞬间执行(1 条命令定位肇事 SQL)
select
q.session_id, q.query, q.start_time,
m.mem, m.peak_mem, m.process
from
information_schema.cluster_tiflash_queries q
join information_schema.cluster_tiflash_memory_usage m
where
q.session_id = m.session_id
order by m.peak_mem desc limit 10;
这条能直接看到:谁占内存最大、跑了多久、SQL 文本。