MySQL appears errcode:28 error prompt solution

Problem one, the log log is too large will lead to MySQL prompts error writing file ' xxx ' (errcode:28) error, the solution is very simple.

1, clean up the disk, free space;
2, SQL statement query the original table data is too large, optimizing SQL query statements;
3, the issue of permissions, resulting in read and write errors, viewing folder read and write permissions;

Question Two,

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= ' blogs ' ORDER by date DESC LIM IT 1
Error writing file ' C:windowstempmy9b6f.tmp ' (errcode:28)

Workaround:

1. Free c:windowstemp Space

2. Because the original table is too large, the temporary table generated at the query is too large to make an error.
Solutions. Restart MySQL, then add a where to the three-paragraph query to avoid full table scans.

Question three,

Error writing file '/TMP/MYIS0UPV ' (errcode:28), there may be no more space in MySQL's temp directory.

You can use DF-LH to view the disk usage.

Try to change the path of My.ini Tmp_dir, restart MySQL, the problem should be solved.