Mysql: remove binlogs and set expare_logs_days
shell> mysql -u username -p mysql> PURGE BINARY LOGS TO 'mysql-bin.000015';
Alternatively, you can remove the binary older than a specific date.
shell> mysql -u username -p mysql> PURGE BINARY LOGS BEFORE '2009-11-01 00:00:00';
expare_logs_days = 10
mysql> show variables like "expire_logs_days"; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | expire_logs_days | 10 | +------------------+-------+ 1 row in set (0.00 sec)
mysql> show binary logs; +------------------+------------+ | Log_name | File_size | +------------------+------------+ | mysql-bin.000034 | 1073742367 | | mysql-bin.000035 | 1073743703 | | mysql-bin.000036 | 560142385 | | mysql-bin.000037 | 77971806 | +------------------+------------+ 4 rows in set (0.00 sec)
Login
0 Comments
Oldest