红联Linux门户
Linux帮助

mysql开启slow_query_log

发布时间:2017-05-11 10:08:05来源:linux网站作者:Achiberx
1.打开MySQL的配置文件
cd /etc/mysql/mysql.conf.d
sudo vi mysqld.cnf
2.然后修改:
Here you can see queries with especially long duration
log_slow_queries    = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
3.保存,然后sudo service mysql restart报错!
 
解决方法:
1.打开mysql的日志文件
cd /var/log/mysql
vi error.log
2.看到里面有:
2017-05-10T11:43:18.326126Z 0 [Note] Plugin 'FEDERATED' is disabled.
2017-05-10T11:43:18.329371Z 0 [ERROR] unknown variable 'log_slow_queries=/var/log/mysql/mysql-slow.log'
2017-05-10T11:43:18.329384Z 0 [ERROR] Aborting
3.推测应该是log_slow_queries变量没找到。
4.搜索:unknown variable ‘log_slow_queries=/var/log/mysql/mysql-slow.log’找到了答案:
mysql开启slow_query_log
需要把“log_slow_queries“改为“slow_query_log”
5.然后保存,重启成功!
 
思考:遇到问题,需要去读一读错误日志,如果仍有疑问去搜索一下!
mysql的日志目录:/var/log/mysql/error.log
 
本文永久更新地址:http://www.linuxdiyf.com/linux/30689.html