groovyjon
asked on
"Error Code : 1037 - Out of memory; restart server and try again" when using order by clause
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.