您可以非常轻松地将每个查询记录到日志文件中:
mysql> SHOW VARIABLES LIKE "general_log%";
+------------------+----------------------------+
| Variable_name | Value |
+------------------+----------------------------+
| general_log | OFF |
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+
mysql> SET GLOBAL general_log = 'ON';
进行查询(在任何数据库上)。Grep或其他检查/var/run/mysqld/mysqld.log
那别忘了
mysql> SET GLOBAL general_log = 'OFF';
否则性能将直线下降,您的磁盘将满!