SLTechnology News&Howtos › Database ›

Mysql opens general_log record sql execution record

Shulou Source: shulou.com Published: 2022-06-01 21:29:49 10月23日 Update

Method 1: change the my.cnf configuration file

Vi / usr/local/kkmail/config/mysql/my.cnf uncomment the following two lines and restart mysql#general_log = 1#general_log_file = / tmp/kkmail_mysql.log

# set general log save path

# it seems that you can only save to / tmp or / var folder.

Method 2: operate in the mysql command console

# root user is required to have access to this file mysql > show global variables like'% general%' +-- + | Variable_name | Value | +- +-- + | general_log | OFF | | general_log_file | / usr/local/kkmail/data/mysql/default/localhost.log | +- -+-+ 2 rows in set (0.00 sec) mysql > set global general_log_file='/tmp/kkmail_mysql.log' Query OK, 0 rows affected (0.00 sec) mysql > set global general_log=on;Query OK, 0 rows affected (0.05 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | ON | | general_log_ File | / tmp/kkmail_mysql.log | +-+-- + 2 rows in set (0.00 sec) mysql > set global general_log=off Query OK, 0 rows affected (0.00 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | OFF | | general_log_file | | / tmp/kkmail_mysql.log | +-+-- + 2 rows in set (0.00 sec) |

Method 3: save the log in the general_log table of the mysql database

Mysql > set global log_output='table';Query OK, 0 rows affected (0.00 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | OFF | | general_log_file | | / tmp/kkmail_mysql.log | +-+-+ 2 rows in set (0.00 sec) mysql > set global general_log=on | Query OK, 0 rows affected (0.00 sec) mysql > show global variables like'% general%' +-+-+ | Variable_name | Value | +-+-+ | general_log | ON | | general_log_ File | / tmp/kkmail_mysql.log | +-+-+ 2 rows in set (0.01sec) mysql > use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with-ADatabase changedmysql > select * from general_log