Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2008
    Posts
    55

    Unanswered: ORDER BY causing disk space error

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    how many rows are in each table?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Mar 2008
    Posts
    55
    db is very small at 67k.

  4. #4
    Join Date
    Mar 2008
    Posts
    6
    Not sure if this will help, but did you try creating an index on the column(s) you are ordering on?

  5. #5
    Join Date
    Mar 2008
    Location
    Tacoma, WA
    Posts
    11
    Quote Originally Posted by CyberEveryday.com
    Not sure if this will help, but did you try creating an index on the column(s) you are ordering on?
    That will help because otherwise it has to do a full table scan.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •