expire_logs_days

世代の変更

set 7 generation

my.cnf

code:conf

expire_logs_days = 7

online

code:mysql

mysql> set global expire_logs_days = 7;

Query OK, 0 rows affected (2.59 sec)

mysql> show variables like 'expire_logs_days';

+------------------+-------+

| Variable_name | Value |

+------------------+-------+

| expire_logs_days | 7 |

+------------------+-------+

1 row in set (0.01 sec)