这篇文章主要为大家展示了“Mysql中PerfORMance_schema sql执行统计的示例分析”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“mysql中P
这篇文章主要为大家展示了“Mysql中PerfORMance_schema sql执行统计的示例分析”,内容简而易懂,条理清晰,希望能够帮助大家解决疑惑,下面让小编带领大家一起研究并学习一下“mysql中Performance_schema SQL执行统计的示例分析”这篇文章吧。
查看执行最频繁TOP SQL:
可以解决问题:
1.SQL的执行次数
2.全表扫描
3.临时表
select digest_text as sql_text,count_star as exec_count,if(sum_no_Good_index_used > 0 or sum_no_index_used > 0, '*', '') as full_scan,sum_created_tmp_tables as tmp_tables,
sum_created_tmp_disk_tables as tmp_disk_tables,
sum_sort_rows as rows_sorted from events_statements_summary_by_digest where schema_name='ticket' and digest_text like 'select%' order by count_star desc limit 10;
生成mysql sql 执行性能报告
开启SQL的性能收集
use performance_schema;
update setup_consumers set enabled='YES' where name IN ('events_statements_history','events_statements_current','statements_digest');
清空SQL性能数据
truncate table events_statements_current;
truncate table events_statements_history;
truncate table events_statements_summary_by_digest;
do sleep(60);
统计SQL的执行比例
select now(),(count_star/(select sum(count_star) FROM events_statements_summary_by_digest) * 100) as pct, count_star as sql_exec, left(digest_text,150) as stmt, digest from events_statements_summary_by_digest order by 2 desc;
关闭SQL的性能收集:
update setup_consumers set enabled='NO' where name IN ('events_statements_history','events_statements_current','statements_digest');
以上是“Mysql中Performance_schema SQL执行统计的示例分析”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注编程网数据库频道!
--结束END--
本文标题: Mysql中Performance_schema SQL执行统计的示例分析
本文链接: https://www.lsjlt.com/news/62312.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-16
2024-05-16
2024-05-16
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
2024-05-15
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0