首页 > 数据库技术 > 详细

How to see log files in MySQL?

时间:2021-02-19 23:37:28      阅读:33      评论:0      收藏:0      [点我收藏+]

原文链接: https://stackoverflow.com/questions/5441972/how-to-see-log-files-in-mysql

 

To enable error log add following

[mysqld_safe]
log_error=/var/log/mysql/mysql_error.log

[mysqld]
log_error=/var/log/mysql/mysql_error.log

To enable general query log add following

general_log_file        = /var/log/mysql/mysql.log
general_log             = 1

To enable Slow Query Log add following

log_slow_queries       = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes

How to see log files in MySQL?

原文:https://www.cnblogs.com/oxsir/p/14417538.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!