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;
Subject
Views
Written By
Posted
mysql-relay-binlog is not purge in master
791
April 29, 2021 12:36AM
376
April 29, 2021 10:39AM
378
April 29, 2021 06:27PM
376
April 29, 2021 07:49PM
462
April 29, 2021 07:52PM
443
April 30, 2021 06:05PM
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.