I recently had one of my proxy servers run at 99% disk space. The proxy server is using mysql and because its proxy its pulling metrics -> the metrics get sucked off from the main server and then those records on the proxy get removed. My mysql had binary logs turned on... so the .bin files found in /var/lib/mysql was filling up all the space, so I edited the /etc/mysql/mysql.conf.d/mysqld.conf file to remove bin logging, it is not needed for this database and then purged the old bin files.
PURGE BINARY LOGS BEFORE '2022-04-29 00:00:00';
I am now only using 22% of my disk space. Which is mostly the OS. :D
Top comments (0)