MySQL Purge Binary Logs: Difference between revisions
From WikiMLT
m (Стадий: 6 [Фаза:Утвърждаване, Статус:Утвърден]; Категория:Databases) |
mNo edit summary |
||
| Line 23: | Line 23: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
References: | Also you can remove the <code>automysql</code> backups older than 7 days by the following command.<syntaxhighlight lang="shell" line="1"> | ||
sudo find /var/lib/automysqlbackup/ -mtime +7 -type f -delete | |||
</syntaxhighlight>References: | |||
* [https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html MySQL 8.0 Reference Manual: 13.4.1.1 PURGE BINARY LOGS Statement] | * [https://dev.mysql.com/doc/refman/8.0/en/purge-binary-logs.html MySQL 8.0 Reference Manual: 13.4.1.1 PURGE BINARY LOGS Statement] | ||
* [https://www.christophe-casalegno.com/mysql-how-to-purge-binary-logs-when-you-have-no-space-left-on-device/ Christophe Casalegno: MySQL - how to purge binary logs when you have no space left on device?] | * [https://www.christophe-casalegno.com/mysql-how-to-purge-binary-logs-when-you-have-no-space-left-on-device/ Christophe Casalegno: MySQL - how to purge binary logs when you have no space left on device?] | ||
Revision as of 09:06, 30 September 2022
If you are using VPS with limited space probably it is a good idea to free up some space time to time. One way is by purging the binary logs of MySQL. Here are the relevant commands to do that at Ubuntu 20.04 with MySQL 8 and the default socket authentication.
sudo mysql
mysql> PURGE BINARY LOGS BEFORE '2021-03-07 23:00:00';
Query OK, 0 rows affected (0.05 sec)
mysql> exit
Bye
In addition you could modify the binlog expire time as follow (restart the MySQL service after that):
cat /etc/mysql/mysql.conf.d/mysql.binlog.cnf
# SZS: setup binlog expire time - one week in seconds
[mysqld]
binlog_expire_logs_seconds = 604800
Also you can remove the automysql backups older than 7 days by the following command.
sudo find /var/lib/automysqlbackup/ -mtime +7 -type f -delete
References:
- MySQL 8.0 Reference Manual: 13.4.1.1 PURGE BINARY LOGS Statement
- Christophe Casalegno: MySQL – how to purge binary logs when you have no space left on device?
- Database Administrators: Is it safe to delete mysql-bin files?
- Mydbops: Binlog expiry now in seconds (MySQL 8.0)
