How to monitor MySQL queries on Windows

sql mysql windows mysql-management
BreakPhreak picture BreakPhreak · Oct 4, 2010 · Viewed 9.7k times · Source

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.

Answer

BreakPhreak picture BreakPhreak · Oct 4, 2010
  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.

Related questions

Import SQL file into mysql

I have a database called nitm. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is nitm.sql which is in C:\ drive. This file has …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More