How to monitor MySQL queries on Windows

Send this command to the server:set global general_log=1;
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.
Examine the log :)
Set the general_log back to 0 to return the DB server performance back to normal.

What worked for me on local windows 7 x64 installation of MYSQL 5.6 was:

Open your my.ini file and make sure you have these lines:

Long query log

long_query_time = 1slow_query_log = 1slow_query_log_file = "C:\Zend\MySQL5.6\slowquery.log"

general_log=1general_log_file = "C:\Zend\MySQL5.6\genquery.log"

To switch off general query logs, set general_log value to 0 and restart.And do not forget to change the paths of log files to match your system.

sql mysql windows mysql-management

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