补充十八:查看MySQL最近执行的语句

先查看一下二进制的记录日志是否打开:general_log

mysql> show variables where Variable_name="general_log";
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| general_log   | OFF   |
+---------------+-------+

如果是OFF。则需要打开这个选项:

set global general_log=on;

然后确认一下默认的log产生在哪里:

mysql> show variables where Variable_name="general_log_file";
+------------------+----------------------------+
| Variable_name    | Value                      |
+------------------+----------------------------+
| general_log_file | /var/run/mysqld/mysqld.log |
+------------------+----------------------------+

然后搜索一下它,得到日志路径,日志文件:

vim /var/run/mysqld/mysqld.log

 

posted on 2018-10-14 17:56  myworldworld  阅读(77)  评论(0)    收藏  举报

导航