我是查询的 慢日志, 上图是查询的结果
SELECT
DATE_FORMAT( Time, '%Y年 %m月 %d日 %H:%i' ) AS '发生日期',
Query_time AS '执行语句花费的时间(秒)',
DB AS 'DB',
`Query` AS 'SQL语句',
Mem_max / 1024 / 1024 AS 'sql 使用的内存(MB)',
Request_count AS 'Request_count [语句发送的 Coprocessor 请求的数量]',
Process_keys AS 'Process Keys [Coprocessor 处理的 key 的数量, 数量越多越占用TiKV资源]',
Process_time AS 'Process_time [SQL在TiKV的 处理时间之和(秒)]',
Wait_time AS 'Wait_time [SQL在TiKV中, Coprocessor 请求排队等待时间之和(秒), ]',
Backoff_time AS 'Backoff_time [语句遇到错误, 在重试前等待的时间(秒)]',
CONCAT( `User`, '@', `HOST` ) AS '谁执行的',
( CASE succ WHEN '1' THEN '成功' ELSE '失败' END ) AS '是否执行成功',
Stats AS '统计信息时间戳, 是否显示为 pseudo'
FROM
information_schema.`slow_query`
WHERE
`is_internal` = FALSE
AND time > DATE_SUB( NOW( ), INTERVAL 1 HOUR ) -- 查询最近一小时的
ORDER BY
Process_keys DESC,
`Mem_max` DESC
LIMIT 1000;