Out of Sort Memory
On This Page
|Applies To||All MySQL Sources|
|Error Message Text(s)||Out of sort memory, consider increasing server sort buffer size.|
- This error occurs when the buffer size required for executing a query is larger than the
sort_buffer_sizevalue configured for the MySQL server.
Use indexed tables. Indices help in querying the table faster, by reducing the number of rows to be scanned. Creating indices is preferred over increasing the
sort_buffer_sizeas the latter may slow down your queries.
If you have indexed tables but still face the error, increase
Navigate to your MySQL Server install directory.
Open the config file:
my.iniin the case of Windows.
my.cnfin the case of Linux.
Search for the
sort_buffer_sizeparameter in the file or add it if it does not exist.
Set the required buffer size as shown below:
sort_buffer_size = <required_size>
For example, to set the value to 1 gigabyte, use one of the following:
sort_buffer_size = 1073741824 sort_buffer_size = 1G
Restart your MySQL server for the changes to take effect.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|