mysql Sort aborted: Error writing file /home/mysql/log/tmp/MYFo1tXI No space left on device

Viewed 1
database mysql

mysql error Sort aborted: Error writing file /home/mysql/log/tmp/MYFo1tXI No space left on device

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

root81
1 Answers

Solution: Expand the size of the temporary directory, taking "/home/mysql/log/tmp" as an example, simply expand it.

root81
Related Questions
mySQL RROR 2006 (HY000) at line XX MySQL server has gone away
1 answers
How to set foreign key constraints in MySQL?
1 answers
How to install Redis in Docker?
1 answers
mysql error：Your password has expired
1 answers
How to enable remote access for users in MySQL database
1 answers
ERROR : MySQL server has gone away
1 answers