"Error Code : 1037 - Out of memory; restart server and try again" when using order by clause
Posted on 2006-11-19
I've just re-installed mysql and now certain queries cause my app to fail.
Specifically, the query "select distinct * from mytable order by name" causes the following error:
Error Code : 1037 Out of memory; restart server and try again (needed 65528 bytes)
If I remove the "order by" clause then it runs just fine so I'm guessing that the memory issue is a red herring? If not, then how do you determine what an acceptable memory value should be?