How to limit binary logs in MariaDB

MariaDb binarny log size is depended on number of days to store on hard drive.

You can change this limit without rebooting server.

See example below how to set limit of 10 days.

First check you are satisfied with date period:

mysql> select date(now()) + interval 0 second - interval 10 day;
+---------------------------------------------------+
| date(now()) + interval 0 second - interval 10 day |
+---------------------------------------------------+
| 2016-12-20 00:00:00 |
+---------------------------------------------------+
1 row in set (0.00 sec)
mysql>

Continue reading “How to limit binary logs in MariaDB”