vendredi 27 février 2015

mysql import failed caused by overgrown general log file


I have a table about 70G in size. I took a backup using mysqldump.


In the new server, I performed a restoration.


time mysql -uroot -p TDB < TDB.sql Enter password: ERROR 3 (HY000) at line 58155: Error writing file '/app/mysql/admin/tmp/MLLVx92e' (Errcode: 28 - No space left on device)


Further checked, showed that the general log file in /app has increased tremendously.


show variables 'general_log_file' general_log_file | /app/mysql/admin/mysql.log


Does importing using mysql causes general log file to grow exponentially?





Aucun commentaire:

Enregistrer un commentaire