mysql慢日志优化

-- 开启慢日志
SET GLOBAL slow_query_log = 'ON';

-- 设置慢查询阈值（单位：秒）
SET GLOBAL long_query_time = 2;

-- 设置慢日志文件路径
SET GLOBAL slow_query_log_file = '/var/log/mysql/slow-query.log';

# 删除慢日志文件
rm /var/log/mysql/slow-query.log

# 清空慢日志文件
echo "" > /var/log/mysql/slow-query.log

[mysqld]
slow_query_log = ON
slow_query_log_file = /var/log/mysql/slow-query.log
long_query_time = 2
logrotate = /etc/logrotate.d/mysql

/var/log/mysql/slow-query.log {
    daily
    rotate 7
    compress
    delaycompress
    missingok
    notifempty
    create 640 mysql mysql
}

# 使用mysqldumpslow分析慢日志
mysqldumpslow /var/log/mysql/slow-query.log

# 使用pt-query-digest分析慢日志
pt-query-digest /var/log/mysql/slow-query.log

-- 添加索引示例
CREATE INDEX idx_name ON table_name (column_name);