MySQL Forums
Forum List  »  Replication

mysql-relay-binlog is not purge in master
Posted by: Will Khoo
Date: April 29, 2021 12:36AM

I have tons of mysql-relay-binlog files not purge in my master server.
The oldest date is oct 2020...
I have enabled a task scheduler job to flush the log and purge the binary log.
But it doesn't remove the old one, any idea where I am missing?

mysql> SELECT @@global.relay_log_purge;
+--------------------------+
| @@global.relay_log_purge |
+--------------------------+
| 1 |
+--------------------------+
1 row in set (0.00 sec)

mysql> show variables like 'relay_log_purge';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| relay_log_purge | ON |
+-----------------+-------+
1 row in set (0.00 sec)


Scripts:

mysql --user=xx_user --password=xx_pwd flush-logs


mysql -uxx_user -pxx_pwd -e PURGE BINARY LOGS BEFORE NOW() - INTERVAL 1 day;

Options: ReplyQuote


Subject
Views
Written By
Posted
mysql-relay-binlog is not purge in master
597
April 29, 2021 12:36AM


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.