How to trace mysql server

MySQL & MariaDB Other MySQL® Questions
1

Hi

Is there any tool for mysql server to trace and identify the slow query(ie the query which takes more time to run) like sql profiler in sql server.

I want to identify the query in VB and optimize that. If there is any way to identify the slow query, pls reply

thanks

2

Check this page :

[URL]http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html[/URL]

I recommend you use the mysqldumpslow command to process the log. It can sort by many parameters.