Wednesday, October 15, 2008
How MySQL Handles a Full Disk
When a disk-full condition occurs, MySQL does the following :
- It checks once every minute to see whether there is enough space to write the current row. If there is enough space, it continues as if nothing had happened.
- Every 10 minutes it writes an entry to the log file, warning about the disk-full condition.
To alleviate the problem, you can take the following actions :
- To continue, you only have to free enough disk space to insert all records.
- To abort the thread, you must use mysqladmin kill. The thread is aborted the next time it checks the disk (in one minute).
- Other threads might be waiting for the table that caused the disk-full condition. If you have several “locked” threads, killing the one thread that is waiting on the disk-full condition allows the other threads to continue.
From MySQL Documentation