Go to the first, previous, next, last section, table of contents.
On a disk full condition MySQL does the following:
It checks once every minute if there is enough space to write the
current row. If there is enough disk it continues as if nothing had
happened.
-
Every 6 minutes it writes a entry to the log file warning about disk
full.
-
To continue you have only to free enough free space to insert all
records.
-
To abort the thread you have to send a
mysqladmin kill to the thread.
The thread will be aborted when it checks the disk next time (in 1 minute).
-
Note that other threads may be waiting for the table that caused 'disk full'.
If you have a lot of 'locked' threads killing the one thread that waits for
disk full will allow the other threads to continue.
Go to the first, previous, next, last section, table of contents.