mysql-监控日志

mysql general log 开启

set global general_log=1;

show variables like "%general_log%";

mysql> show variables like "%general_log%";
+------------------+---------------------------------------+
| Variable_name | Value |
+------------------+---------------------------------------+
| general_log | OFF |
| general_log_file | /data0/mysql/3307/data/mysqlslave.log |
+------------------+---------------------------------------+
2 rows in set (0.00 sec)

mysql> set global general_log=1;
Query OK, 0 rows affected (0.02 sec)

mysql> show variables like "%general_log%";
+------------------+---------------------------------------+
| Variable_name | Value |
+------------------+---------------------------------------+
| general_log | ON |
| general_log_file | /data0/mysql/3307/data/mysqlslave.log |
+------------------+---------------------------------------+
2 rows in set (0.00 sec)