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
733
April 29, 2021 12:36AM
349
April 29, 2021 10:39AM
347
April 29, 2021 06:27PM
349
April 29, 2021 07:49PM
413
April 29, 2021 07:52PM
408
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.