MySql性能监控performance_schema数据库常用查询语句
这里写自定义目录标题
–1、哪类SQL执行最多
select DIGEST_TEXT,COUNT_STAR,FIRST_SEEN,LAST_SEEN FROM events_statements_summary_by_digest ORDER BY COUNT_STAR DESC
–2、哪类SQL的平均响应时间最多
SELECT DIGEST_TEXT,AVG_TIMER_WAIT FROM events_statements_summary_by_digest ORDER BY COUNT_STAR D
原创
2021-03-24 16:19:43 ·
291 阅读 ·
0 评论