hydy的博客

背景线上服务某些条件下的列表查询失败，报系统异常，查询线上日志发现报了排序缓冲区溢出### Cause: java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size; uncategorized SQLException; SQL state [HY001]; error code [1038]; Out of sort memory, consider increasing serv

开启# 开启set global slow_query_log ='ON';# 设置慢SQL日志文件路径set global slow_query_log_file = '/var/log/mysql-slow-query.log';# 设置慢SQL阈值(单位:秒)set global long_query_time = 1;查看配置情况# 查看慢SQL相关配置SHOW VARIABLES like '%slow%';# 查看慢SQL阈值SHOW VARIABLES like