Watch DB traffic

[aneto]

Hi,

I would like to know if there is any way to watch all the queries, inserts, updates, deletes, etc, been executed against a MySql Server.

Thanks!

[akucharski]

Not sure exactly what it is that you are meaning by traffic, or how you want to see it but one way is to use MySQL Administrator (download from mysql site).

Go to the Health and then select either teh memory Health or Status Variables tab. You may create your own custom graphs or use this client to view system variables normally viewable through system queries.

[aneto]

Well, I actually wanted to see the SQL statements executed by the server.

[greenman]

There are 2 logs that may be useful - the binary log (for all update, delete and insert statements), and the general query log (for all statements). See theMySQL manual for details.

[aneto]

Thanks!!