背景

线上服务某些条件下的列表查询失败，报系统异常，查询线上日志发现报了排序缓冲区溢出

### 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 server sort buffer size; nested exception is java.sql.SQLException: Out of sort memory, consider increasing server sort buffer size

资料查找

mysql - Error "1038 Out of sort memory, consider increasing sort buffer size - Stack Overflow