# How to trace mysql server

**URL:** <https://forums.percona.com/t/how-to-trace-mysql-server/253>\
**Category:** Other MySQL® Questions\
**Created:** [March 22, 2007, 4:30am UTC](https://forums.percona.com/t/how-to-trace-mysql-server/253 "2007-03-22T04:30:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![julian](https://avatars.discourse-cdn.com/v4/letter/j/74df32/32.png) [@julian](https://forums.percona.com/u/julian)\
**Post date:** [March 22, 2007, 4:30am UTC](https://forums.percona.com/t/how-to-trace-mysql-server/253/1 "2007-03-22T04:30:50Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![tanj](https://avatars.discourse-cdn.com/v4/letter/t/e5b9ba/32.png) [@tanj](https://forums.percona.com/u/tanj)\
**Post date:** [March 22, 2007, 8:17am UTC](https://forums.percona.com/t/how-to-trace-mysql-server/253/2 "2007-03-22T08:17:41Z")

</div>

Check this page :

[URL][http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html[/URL]](http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html%5B/URL%5D)

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