From mysql command line:
mysql> select @@expire_logs_days; +-------------------- | @@expire_logs_days | +--------------------+ | 1 | +--------------------+ 1 row in set (0.00 sec) mysql> set global expire_logs_days=2; mysql> select @@expire_logs_days; +--------------------+ | @@expire_logs_days | +--------------------+ | 2 | +--------------------+ 1 row in set (0.00 sec)Then udpate "expire_logs_days" in my.cnf file. No need to restart MySQL process.
No comments:
Post a Comment