MySQL set binlog log expiration date auto-Recycle

Set log retention days and automatically delete after expiration

View current journal days saved:

Show variables like '%expire_logs_days% ';

The default is 0, which never expires.

Modify by setting Global parameters:

Set global expire_logs_days=30;

Set to save for 30 days

or modify the MY.CNF or My.ini in the

Expire_logs_days = 30

If not, add the

Restart after the effective!

This article is from the "Little Rookie" blog, please be sure to keep this source http://baishuchao.blog.51cto.com/12918589/1940140

MySQL set binlog log expiration date auto-Recycle