TOP10 SQL语句

top 10
select schema_name,digest_text,count_star,sys.format_time(sum_timer_wait) as sum_time,
sys.format_time(min_timer_wait) as min_time,sys.foRmat_time(avg_timer_wait) as avg_time,
sys.format_time(max_timer_wait) as max_time,sys.format_time(sum_lock_time) as sum_lock_time,
sum_rows_affected,sum_rows_sent,sum_rows_examined from performance_schema.events_statements_summary_by_digest
where schema_name is not null order by count_star desc limit 10

在events_statements_summary_by_digest表中不记录具体的 错误信息,只做错误语句统计。所以,如果需要查询具体的错误信息(例 如:具体的错误代码、具体的错误提示信息以及具体的错误SQL语句文本 等),还需要查询events_statements_history表或者events_statements_history_long 表。

TOP10 SQL语句

上一篇:MongoDB的启动与停止


下一篇:Docker安装PostgreSQL