mysql 日志

show variables like 'general_log_file';

mysql> show variables like 'general_log_file';
+------------------+--------------------------------+
| Variable_name    | Value                          |
+------------------+--------------------------------+
| general_log_file | /mnt/DataBase/iZ28na4xi3rZ.log |
+------------------+--------------------------------+
1 row in set (0.00 sec)

所在位置：

mysql> show variables like 'log_%';
+---------------------------------+------------------------------+
| Variable_name                   | Value                        |
+---------------------------------+------------------------------+
| log_bin                         | ON                           |
| log_bin_trust_function_creators | OFF                          |
| log_error                       | /alidata/log/mysql/error.log |
| log_output                      | FILE                         |
| log_queries_not_using_indexes   | OFF                          |
| log_slave_updates               | OFF                          |
| log_slow_queries                | OFF                          |
| log_warnings                    | 1                            |
+---------------------------------+------------------------------+
8 rows in set (0.00 sec)