How to see log files in MySQL?
2021-02-19 18:21 卡车司机 阅读(58) 评论(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