云数据库 GAUSSDB(FOR MYSQL)-执行select order by查询报Out of sort memory:场景描述

时间:2024-07-03 10:43:49

场景描述

执行以下查询报Out of sort memory,调大sort_buffer_size仍然报错,排查表数量较小

SELECT * FROM `t1` WHERE num = 4250 ORDER BY rank desc; 执行失败,失败原因:(conn=24259576) Out of sort memory, consider increasing server sort buffer size
support.huaweicloud.com/trouble-gaussdbformysql/gaussdbformysql_trouble_0514.html