查找执行次数最多的前三条SQL语句

最新推荐文章于 2023-02-08 16:05:13 发布

一直在努力学习的菜鸟

最新推荐文章于 2023-02-08 16:05:13 发布

阅读量1.4k

点赞数

分类专栏： Linux运维

本文链接：https://blog.csdn.net/weixin_51867896/article/details/122813491

版权

SQL查询数据库日志统计分析执行频率性能优化

关键词由CSDN通过智能技术生成

Linux运维专栏收录该内容

245 篇文章 16 订阅

订阅专栏

MariaDB [mysql]> select argument,count(argument) num from mysql.general_log group by argument order by num desc limit3;
+--------------------------------------------------------------------------------------------------------+-----+
| argument                                                                                               | num |
+--------------------------------------------------------------------------------------------------------+-----+
| select argument,count(argument) num from mysql.general_log group by argument order by num desc limit 3 |   6 |
| select * from general_log                                                                              |   3 |
| show table status like 'general_log'                                                                   |   3 |
+--------------------------------------------------------------------------------------------------------+-----+
3 rows in set (0.003 sec)