mysqlsla: To view n number of top most executed queries
by rajesh[ Edit ] 2013-07-01 04:11:52
To view more than 10 top executed or most executed queries, we can use --top option
mysqlsla -lt general /var/log/mysql/mysql-queries.log --top 20
The above will provide the top 20 queries instead on the default 10.