ERROR 1878 (HY000): temporary error writing file in mysql

Question

When I run the Alter command in mysql to add a new column to an existing table. I ran into this error.

ERROR 1878 (HY000): Temporary file write failure.

Any idea on this? Please guide.

Many thanks.

Answer 1

This error is most likely due to the fact that the MySQL temporary directory is too small (as other comments mention). In many cases, modifying a table in MySQL will result in a duplicate table, and you will need at least as much free space in the temporary directory as the modified table uses.

my.cnf tmpdir. my.cnf /etc/mysql/my.cnf Ubuntu, ( , ). , tmpdir ( ), , .

Ubuntu, , df -h .

Answer 2

/DATA/mysql/<log-file-name>.err ( show variables like 'log%';)