PhpmysqlErrcode: 28 The ultimate solution. Perror28Errorcode28: NospaceleftondeviceSQL statement execution error: SELECTtitle, gidFROMblog_blogWHEREdate1246200383andhidenandtypeblogORDERBYdateDESCLIMI perror 28
Error code 28: No space left on device
SQL statement execution error: SELECT title, gid FROM blog_blog WHERE date <1246200383 and hide = 'n' and type = 'blog 'ORDER BY date DESC LIMIT 1
Error writing file 'C: \ WINDOWS \ TEMP \ MY9B6F. tmp '(Errcode: 28)
Solution:
1. release C: \ WINDOWS \ TEMP \ space
2. because the original table is too large, the temporary table generated during query is too large, so an error occurs.
Solution. Restart mysql and add the where clause to the query to avoid full table scan.
Test results: the first one is useful, and the second one is reasonable. it has not been tested. after the first one, it will be solved. The second one will be well studied later.
Http://www.bkjia.com/PHPjc/320326.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/320326.htmlTechArticleperror 28 Error code 28: No space left on device SQL statement execution Error: SELECT title, gid FROM blog_blog WHERE date 1246200383 and hide = 'n' and type = 'blog 'Order BY date desc limi...