Skip to content

Mysql: remove binlogs and set expare_logs_days

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

 

0 0 votes
Article Rating
guest

0 Comments
Oldest
Newest Most Voted
0
Would love your thoughts, please comment.x
()
x