Re: Problematic Query identification at the time of load on server

[Aftab Khan]

you can use mysqldumpslow to parse MySQL slow query log file to get what quer(ies) have been stressing your database the most and optimize the slowest query first that runs often, try using this command and share its output with us:

mysqldumpslow -s t -t 10 /path/to/slow_query_log

http://dev.mysql.com/doc/refman/5.1/en/mysqldumpslow.html

You can try using pk-query-digest (percona toolkit)
http://www.percona.com/doc/percona-toolkit/2.1/pt-query-digest.html


Aftab

http://mysqlopt.blogspot.co.uk