Today, when executing an SQL statement, I encountered an error java.sql.SQLException:Error writing file '/tmp/mykn6jq8 ' (errcode:28). Search, this problem should be caused by the lack of space in the temporary directory indicated in the error prompt.
This error if you want to see its phenomenon, you must monitor the size of the temporary folder at the SQL runtime, you can see that MySQL created a temporary file in/tmp, the size of the temporary file depends on the SQL statement and the size of the table.
I have about 290,000 rows of data in my table, about 30 columns, using INSERT into M (...) Select ... from MP where Contentlen < 3145729 GROUP BY concat (...) , MySQL will be in the temporary directory to create a near 6G of temporary files, I have only 5G disk, so the MySQL reported to write file errors.
MapReduce imports MySQL data into HDFs issues