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