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

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)

上一篇:虚拟化环境下对公司业务服务器实现NLB+SQL高可用(一)


下一篇:六十年前的上古编程语言教程登上GitHub榜首,退休老程序员如何焕发第二春?