selectdb 高CPU占用sql抓取

sunxunyong

已于 2024-12-19 08:27:49 修改

阅读量124

点赞数 2

CC 4.0 BY-SA版权

文章标签： sql 数据库 mysql

于 2024-12-19 08:26:46 首次发布

本文链接：https://blog.youkuaiyun.com/sunxunyong/article/details/144574224

use information_schema;

select 
t1.query_id as be_query_id,
t1.query_type,
t2.query_id,
t2.workload_group_id,
t2.`database`,
t1.cpu_time,
t2.`sql`
from
(select query_id, query_type,sum(task_cpu_time_ms) as cpu_time from backend_active_tasks group by query_id, query_type) 
t1 left join active_queries t2
on t1.query_id = t2.query_id
order by cpu_time desc limit 10;