views:

36

answers:

2

Is there any easy way to track/monitor all the SQL of the queries, executed by an MySQL server (on a Windows machine)?

Update: I am asking about the free tool.

A: 

You could download a 30-day trial of: MONyog. If it's the tool for you, I suggest you buy it.

Ruel
yep, I know about it. I am looking for a free tool (question updated).
BreakPhreak
A: 
  1. Send this command to the server: set global general_log=1;
  2. Find the log file (the default on Win7 it resides in C:\ProgramData\MySQL\MySQL Server 5.1\data) and has a name just like the computer.
  3. Examine the log :)
  4. Set the general_log back to 0 to return the DB server performance back to normal.
BreakPhreak