Results 1 to 9 of 9
Apr 4, 2008, 10:10 #1
- Join Date
- Apr 2008
- 0 Post(s)
- 0 Thread(s)
MySQL Memory Problems When Sorting Multiple Columns
I am running MySQL Server 5.0.37 on a Windows 2003 Server.
I have a table that I want sorted by three columns (column1, then column2, then column3).
I can sort one column just fine. But, if the recordset is large, sorting by two (or more) columns crashes the MySQL Server Service.
Through research it looks like I am having a memory problem as the following error message is written to the MySQL error log:
080325 14:27:10 ERROR C:\SWsoft\Plesk\Databases\MySQL\bin\mysqld-nt.exe: Out of memory; restart server and try again (needed 32776 bytes)
sort buffer size 32,776
I am also concerned that if I successfuly increase the buffer sizes too big, I will have problems if I have a large number of users running this query at the same time.
Any help on how I can resolve this would be greatly appreciated.