补充十八:查看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) 收藏 举报