Answer the question
In order to leave comments, you need to log in
Why is MySQL running out of space?
Good day. I have a Debian machine with MySQL on it. Which periodically falls, when trying to restart, giving an error:
"[FAIL] /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! ... failed!"
There is still 24 GB of space on the disk. The question is why does he not have enough space? Where to dig? There are no particularly large files in that directory, only ibdata1 is 2.5 gigabytes, plus ib_logfile1 and ib_logfile2 are about 5 mb each. The rest of the files are not even up to 10mb
Answer the question
In order to leave comments, you need to log in
Your partition is fully occupied, as can be seen from the posted results of df.
Part of the file system space is reserved for the root user, and cannot be used by mysql. The default is 5% if my memory serves me right. This can be changed during installation, and can be managed afterwards with:
tune2fs -m
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question