At times it’s necessary to know which queries the server runs right now.
Of course, you can try this statement:
but if you need a more poweful tool, try
Although it’s still an alpha version, it’s a handy tool to monitor, filter and manipulate your queries since there is Lua scripting language interpreter supported which is quite obvious in usage.
The MySQL Proxy (as can be understood from its title) can help you to see communication between a few MySQL servers and a few clients.
My usage pattern is that the Proxy listens to 4040 port on my local machine, and if I change the port setting in connection string of any application (my job project or even PhpMyAdmin), I can see the queries logged in a console window.
You can track lots of characteristics of queries — just take a look at example Lua scripts in the package that you’ve downloaded.