MySQL General Log

1: View version

SELECT VERSION ();

　　

2: See how the current log is saved

mysql> SHOW VARIABLES like '%log_output% '; +---------------+-------+| variable_name | Value |+---------------+-------+| Log_output    | TABLE |+---------------+-------+1 row in Set (0.00 sec)

　　

3: See if General log is currently turned on

mysql> SHOW VARIABLES like '%general_log% '; +------------------+----------------------------+| Variable_name    | Value                      |+------------------+----------------------------+| general_log      | On                         | | general_log_file |/var/run/mysqld/mysqld.log |+------------------+----------------------------+2 rows in Set (0.00 sec)

　　

4: Close Open General log

mysql> SET GLOBAL general_log = on; Query OK, 0 rows Affected (0.00 sec) mysql> SET GLOBAL general_log_file = '/tmp/general.log '; Query OK, 0 rows Affected (0.00 sec) mysql> SET GLOBAL general_log = OFF; Query OK, 0 rows Affected (0.00 sec)

　　

5: Set the output format of the log

mysql> SHOW VARIABLES like '%log_output% '; +---------------+-------+| variable_name | Value |+---------------+-------+| Log_output    | FILE  |+---------------+-------+1 row in Set (0.00 sec) mysql> Set GLOBAL log_output = ' TABLE '; Query OK, 0 rows Affected (0.00 sec)

　　

MySQL General Log