Shulou(Shulou.com)06/01 Report--

1. Delete the binlog before a certain period of time

Primary server execution

PURGE MASTER LOGS BEFORE '2019-05-10 00 purl 0000'

Time is not necessarily the time above. If the definition depends on the current time, you can also change the parameter time to the binlog file name.

2. Modify the number of days saved in binlog

Master-slave server execution

The temporary modification time is three days, and the default value is 15 after restarting the service.

Mysql > show variables like'% expire_logs_days%'

+-+ +

| | Variable_name | Value |

+-+ +

| | expire_logs_days | 15 |

+-+ +

View

Mysql > set global expire_logs_days=3

Modify the configuration file, and the configuration remains unchanged after reboot

# vi / etc/my.cnf

Expire_logs_days=3

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.