如何在 Windows 上监控 MySQL 查询

How to monitor MySQL queries on Windows

提问by BreakPhreak

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

是否有任何简单的方法来跟踪/监视由 MySQL 服务器（在 Windows 机器上）执行的所有 SQL 查询？

Update: I am asking about the free tool.

更新：我问的是免费工具。

采纳答案by BreakPhreak

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_logback to 0to return the DB server performance back to normal.

1. 将此命令发送到服务器： set global general_log=1;
2. 找到日志文件（它驻留在 Win7 上的默认值C:\ProgramData\MySQL\MySQL Server 5.1\data）并具有与计算机一样的名称。
3. 检查日志:)
4. 设置general_logback to0使 DB 服务器性能恢复正常。

回答by serge.k

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

在 MYSQL 5.6 的本地 Windows 7 x64 安装上对我有用的是：

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

  Long query log

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

  Set General Log

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

• Save file and restart the service

• 打开您的 my.ini 文件并确保您有以下几行：

  长查询日志

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

  设置一般日志

  
  general_log=1
  general_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.

要关闭常规查询日志，请将 general_log 值设置为 0 并重新启动。并且不要忘记更改日志文件的路径以匹配您的系统。

回答by Ruel

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

您可以下载MONyog的 30 天试用版。如果它是适合您的工具，我建议您购买它。