mysql查看log文件

# MySQL 5.7及以上版本
sudo tail -f /var/log/mysql/error.log

# MySQL 5.6及以下版本
sudo tail -f /var/lib/mysql/hostname.err

SET GLOBAL general_log = 'ON';
SET GLOBAL log_output = 'FILE';
SET GLOBAL general_log_file = '/var/log/mysql/query.log';

sudo tail -f /var/log/mysql/query.log

SET GLOBAL slow_query_log = 'ON';
SET GLOBAL long_query_time = 2; -- 设置慢查询时间阈值，单位为秒
SET GLOBAL slow_query_log_file = '/var/log/mysql/slow-query.log';

sudo tail -f /var/log/mysql/slow-query.log

# 查看当前二进制日志文件列表
SHOW BINARY LOGS;

# 查看某个二进制日志文件的内容
mysqlbinlog /var/lib/mysql/binlog.000001

# 示例：配置日志文件轮转
sudo nano /etc/logrotate.d/mysql

sudo chown mysql:mysql /var/log/mysql/error.log
sudo chmod 640 /var/log/mysql/error.log

sudo nano /etc/mysql/my.cnf

log-error=/var/log/mysql/error.log
general-log-file=/var/log/mysql/query.log
slow-query-log-file=/var/log/mysql/slow-query.log

sudo systemctl restart mysql