To avoid the nasty mess because of a full hard drive, make sure your log files are in control. Things run really wild without diskspace!
If you’re running MySQL replication, run “PURGE MASTER LOGS TO ‘yourbinlogname-bin.00x’” or “PURGE MASTER LOGS BEFORE ‘2007-05-30 10:10:10’;” to safely remove the logs before X. Make sure it’s a number at or before the active log file shown in “SHOW MASTER STATUS”. You can run this safely with active replication.
Leave a Reply