MySQL Forums
Forum List  »  Newbie

/var/lib/mysql grows indefinitely in size
Posted by: Andrea Grillini
Date: June 05, 2023 07:46PM

Having the need to upgrade from Ubuntu Bionic to Ubuntu Focal, I made an upgrade from server 5.7 - deduced afterwards - to 8.0 by simply inheriting the original /var/lib/mysql directory, that is I left those files where they were (after making a backup of that directory). To get rid of some incompatibility found in the original configuration file (my.cnf) I purged everything of the old package and started the new 8 server with the configuration shipped with its package.

Apparently the server was working fine, that is I didn't find any particular complain in /var/log/mysql/error.log and websites were finding their expected data.

But after a few days I found the disk space was totally or almost exhausted. I freed some space and noticed /var/lib/mysql has grown from about 38G to more than 100G (I issued the command "du -sh *" in /var/lib), and was still growing.

What did I wrong? Perhaps I made a big mistake in upgrading the server in the way I mentioned?

Thanks in advance!


Options: ReplyQuote

Written By
/var/lib/mysql grows indefinitely in size
June 05, 2023 07:46PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.