cesarcesar Posted March 4, 2008 Share Posted March 4, 2008 The following query is causing a mysql error The Error number is 28, which means low disk space. So I clear some space, retry and get the error again after a few times querying. After playing with query i find that the ORDER BY statement is what make it fail. If i remove it the script runs. So my question is, is there something about an ORDER BY statement that takes up a lot of disk space? I can sort in PHP, but if MySQL has the ability then i prefer it to sort with. Thanks for all the suggestions. SELECT data.datasize AS size, data.dataid AS id, data.datatype, data.dataname, data.datadescription AS description, data.engineerid AS owner, datalog.usability AS usability,datalog.easeofdownload AS easeofdownload, datalog.docaccuracy AS accuracy, datalog.timesdownloaded AS timesd, datalog.ratings AS ratings from data, datalog where data.datatype = 'AE Training video' AND data.dataid = datalog.dataid ORDER BY data.dataname Quote Link to comment Share on other sites More sharing options...
fenway Posted March 4, 2008 Share Posted March 4, 2008 You shouldn't ever have low disk space! On a DB server? Quote Link to comment Share on other sites More sharing options...
cesarcesar Posted March 4, 2008 Author Share Posted March 4, 2008 You shouldn't ever have low disk space! On a DB server? Yes Si-fu Quote Link to comment Share on other sites More sharing options...
fenway Posted March 5, 2008 Share Posted March 5, 2008 Anyway, order by makes a temporary table, which is likely your issue... depending on your memory situation, you might be able to increase the temporary table size. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.