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