Wednesday, March 18, 2015

MySQL - How to Set expire_logs_days On The Fly


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: