general_log 问题处理1

普通日志（general log） 可以提供一种机制，能将打开日志期间所有的语句记录下来，由于开销比较大，所以正常情况下是关闭的，只在进行深度分析时打开

General query log A type of log used for diagnosis and troubleshooting of SQL statements processed by the MySQL server. Can be stored in a file or in a database table. You must enable this feature through the general_log configuration option to use it. You can disable it for a specific connection through the sql_log_off configuration option. Records a broader range of queries than the slow query log. Unlike the binary log, which is used for replication, the general query log contains SELECT statements and does not maintain strict ordering

mysql> show variables like "%general%";
+------------------+-----------------------------------+
| Variable_name    | Value                             |
+------------------+-----------------------------------+
| general_log      | OFF                               |
| general_log_file | /var/lib/mysql/general.log        |
+------------------+-----------------------------------+
2 rows in set (0.00 sec)

mysql> 

如果 log_output 设定为 FILE ，则会记录到 general_log_file 中去

mysql> show variables like "%log_output%";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_output    | FILE  |
+---------------+-------+
1 row in set (0.00 sec)

mysql> 

如果为 TABLE 则会写到 mysql.general_log 中，关于general_log的详细机制，可以参考附录中的相关资料