Thursday, August 23, 2012

How to purge old binary logs on a master

Overview

Note: never delete the binlogs manually

How to purge old binlogs in MySQL

mysql –e “purge master logs before sysdate() – Number_of_days

How to add a parameter to automatically purge old bin logs older than x days

expire_logs_days=x

No comments:

Post a Comment