TiDB tidb服务进程CPU使用率突然连续暴增

Curiouser · 2022 年10 月 17 日 02:34

这是查询出来的慢SQL。

SELECT
	DB AS '数据库',
	`Query` AS 'SQL语句',
	Query_time AS '执行耗时Query_time',
	Time AS '执行时间',
	`User` AS '执行用户',
	`Host` AS '主机',
	Total_keys AS '扫描总Key个数Total_keys',
	Index_names AS '涉及索引名'
FROM
	INFORMATION_SCHEMA.SLOW_QUERY 
ORDER BY
	Query_time DESC 
	LIMIT 100;