M
M
My_Second_Nickname2022-04-07 18:21:09
MySQL
My_Second_Nickname, 2022-04-07 18:21:09

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

2 answer(s)
B
Boris Syomov, 2022-04-07
@My_Second_Nickname

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

T
TheAndrey7, 2022-04-07
@TheAndrey7

View disk partition status
$ df -h

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question