Skip to content

Mysql: remove binlogs and set expare_logs_days

cpx June 11, 2013 1 min read Mysql/MYSQLD/3306
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)

 

Be the first to comment

protected · no tracking

0 comments