Running out of disk space is something which, of course, should
never happen as we all setup monitoring and alerting and only run
well behaved applications. But when it does happen we want things
to fail gracefully.
So what happens when mysqld runs out of disk space?
The answer is: It depends
- It might start to wait until disk space becomes available.
- It might crash intentionally after a 'long semaphore wait'
- It might return an error to the client (e.g. 'table full')
- It might skip writing to the binlog (see
What actually happens might depend on the filesystem and
Fixing the disk space issue can be done by adding more space or cleaning up some space. The later can often be …