倚天杖
您可以非常轻松地将每个查询记录到日志文件中: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';否则性能将直线下降,您的磁盘将满!