Java教程

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

本文主要是介绍查找执行次数最多的前三条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)

这篇关于查找执行次数最多的前三条SQL语句的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！
您可能喜欢
栏目导航