mysql-监控日志

最新推荐文章于 2022-09-04 21:56:18 发布

wodestudy

最新推荐文章于 2022-09-04 21:56:18 发布

阅读量1.7k

点赞数 1

分类专栏： Mysql

本文链接：https://blog.csdn.net/wodestudy/article/details/17187729

版权

Mysql 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

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)