MySQL Open the General log method

MySQL Open general log method after MySQL opens the general log, all query statements can be read in the general log file in a readable manner, but the general log file will be very large, so the default is closed.  Sometimes in order to check the wrong reasons, or need to temporarily open the general log. www.2cto.com [email protected] (none) >show global variables like "%genera%"; +------------------+------------------ ------------+| variable_name | Value |+------------------+------------------------------+| General_log | OFF | | General_log_file | /data1/mysql9999/etch171.log |+------------------+------------------------------+2 rows in Set (0.00 sec) [Email Protected] (None) >set global general_log=on; Query OK, 0 rows affected (0.02 sec) [email protected] (none) >set global general_log=off; Query OK, 0 rows Affected (0.00 sec)