MySQL DBA - Tips and Techniques Magazine

11 Nov 2014

Purge Master Logs

Used to remove older purge logs.


1) ls –ltr < where the bin logs are kept>… you should see loads of bin logs


2) Connect to mysql


3) show master logs;   shows master logs and the last one is current.


4) purge master logs to "<last one in the list>";


5) show master logs;  should only show 1 bin log


6) exit and ls –ttr.     You should have reclaimed the space now.



No comments:

Post a Comment