[MYSQL PURGE BINLOG] MySQL Purge binlogs #mysql #purge #delete #binlog

mysql-purge-binlog.md

List all binary logs

SHOW BINARY LOGS;

Delete binary logs older than 3 days

PURGE BINARY LOGS BEFORE DATE(NOW() - INTERVAL 3 DAY);

Drop old tables / rebuild tables

mysql> DELETE tbl_name WHERE id < 100000; -- remove 100K rows
mysql> OPTIMIZE TABLE tbl_name;

Force rebuild after alter statement

mysql> ALTER TABLE tbl_name FORCE;
mysql> ALTER TABLE tbl_name; -- a.k.a "null" rebuild