How to trace mysql server


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


Check this page :

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