# MySQL Profiler

**URL:** <https://forums.percona.com/t/mysql-profiler/62>\
**Category:** Other MySQL® Questions\
**Created:** [August 15, 2006, 3:57am UTC](https://forums.percona.com/t/mysql-profiler/62 "2006-08-15T03:57:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![safari](https://avatars.discourse-cdn.com/v4/letter/s/838e76/32.png) [@safari](https://forums.percona.com/u/safari)\
**Post date:** [August 15, 2006, 3:57am UTC](https://forums.percona.com/t/mysql-profiler/62/1 "2006-08-15T03:57:57Z")

</div>

Anyone could advise me a tool for MySQL which similar to MS SQL Server Profiler?

Sorry for any inconvenient but I don’t know anywhere else to ask.

---

<div class="post-metadata">

**Author:** ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)\
**Post date:** [August 15, 2006, 7:55am UTC](https://forums.percona.com/t/mysql-profiler/62/2 "2006-08-15T07:55:14Z")

</div>

I am not familiar with MS SQL Server Profiler.  
What does this tool do ?

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [August 15, 2006, 3:22pm UTC](https://forums.percona.com/t/mysql-profiler/62/3 "2006-08-15T15:22:07Z")

</div>

Honestly I do not know.  
I’m not big fan of GUI tools, especially as they are frequently unavailable with remote installations.

Generally I would not expect something with same functionality as MySQL does not provide similar amount of information. Ie there is simply no info on how much phyisical IOs query did etc.

---

<div class="post-metadata">

**Author:** ![yejr](https://avatars.discourse-cdn.com/v4/letter/y/aeb1de/32.png) [@yejr](https://forums.percona.com/u/yejr)\
**Post date:** [August 15, 2006, 7:25pm UTC](https://forums.percona.com/t/mysql-profiler/62/4 "2006-08-15T19:25:17Z")

</div>

execute

show full processlist;

or

show status;

---

<div class="post-metadata">

**Author:** ![safari](https://avatars.discourse-cdn.com/v4/letter/s/838e76/32.png) [@safari](https://forums.percona.com/u/safari)\
**Post date:** [August 15, 2006, 9:12pm UTC](https://forums.percona.com/t/mysql-profiler/62/5 "2006-08-15T21:12:21Z")

</div>

A brief description of MS SQL Profiler:  
“SQL Profiler can help you diagnose and fix SQL Server performance issues. This tool lets you trace events and play back the results, which can help you determine application and/or query problems.”  
   
Do you think such a tool needed for MySQL?

BTW, thanks all for your quick replies.

---

<div class="post-metadata">

**Author:** ![Peter](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/peter/32/2_2.png) [@Peter](https://forums.percona.com/u/Peter)\
**Post date:** [August 16, 2006, 4:52am UTC](https://forums.percona.com/t/mysql-profiler/62/6 "2006-08-16T04:52:29Z")

</div>

There is no event tracing functionality available in MySQL at this point. Best you have is slow query log, SHOW STATUS, SHOW MUTEX STATUS, SHOW INNODB STATUS.

It is planned to have such functionality but it will take time before it is made available.