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
539
April 29, 2021 12:36AM
235
April 29, 2021 10:39AM
253
April 29, 2021 06:27PM
250
April 29, 2021 07:49PM
269
April 29, 2021 07:52PM
296
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.