mysql show variables like_通过show variables like ‘general_log%’可以看查询日志

mysql> show variables like 'general_log%';

+------------------+-----------------------------+

| Variable_name | Value |

+------------------+-----------------------------+

| general_log | OFF |

| general_log_file | /data1/mysql/monitor-44.log |

+------------------+-----------------------------+

2 rows in set (0.00 sec)

mysql> set global general_log=ON;

Query OK, 0 rows affected (0.00 sec)

mysql> SHOW warnings;

Empty set (0.00 sec)

mysql> show variables like 'general_log%';

+------------------+-----------------------------+

| Variable_name | Value |

+------------------+-----------------------------+

| general_log | ON |

| general_log_file | /data1/mysql/monitor-44.log |

+------------------+-----------------------------+

2 rows in set (0.00 sec)