Error Reported During Pagination Query

Scenario

The following error is reported during pagination query of an RDS for MySQL instance: ERROR 1038 (HY001): Out of sort memory, consider increasing server sort buffer size.

Solution

Set the sort_buffer_size parameter to a value greater than the default value 256 KB.

sort_buffer_size is a MySQL server system variable that may affect your query performance. It is defined on a per-session basis and affects MySQL memory consumption.