如果你系统上线了,哪天突然想看看每天执行sql语句都有哪些?然后需要对哪些语句进行优化,那你怎么设置呢?
1、开启日志
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
注意:根据你自己mysql配置文件的路径
2、在 [mysqld] 添加/开启
general_log_file = /var/log/mysql/mysql.log
general_log = 1
3、如果你遇到下面这样的报错,一般需要给 日志文件 开启权限
报错信息:
2020-08-09T03:06:10.856674Z 0 [ERROR] Could not use /var/log/mysql/mysql.log for logging (error 13 - Permission denied). Turning logging off for the server process. To turn it on again: fix the cause, the n either restart the query logging by using "SET GLOBAL GENERAL_LOG=ON" or restart the MySQL server.
2020-08-09T03:06:10.858466Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory
sudo chown mysql:adm /var/log/mysql/mysql.log
具体操作权限看环境需要,思路是这样
4、重启mysql
service mysql restart
5、查看日志内容
cat /var/log/mysql/mysql.log
本博客源码Github地址:
请随手给个star,谢谢!