MySQL Forums :: Backup :: why mysql binlog creating new log file daily
why mysql binlog creating new log file daily
Posted by: Usman Ghani
Date: February 13, 2014 12:59AM
I have started binary logging on MySQL server on my Ubuntu. It start creating log files in /var/log/mysql. My my.cnf configuration is as follows:
When I check logs folder a new file appears daily. Which is created at around 6:45AM to 7:00AM IST i.e 1:30AM to 1:45 GMT. But According to official documentation of MySQL on Binary Logging says:
The server creates a new file in the series each time it starts or flushes the logs. The server also creates a new binary log file automatically after the current log's size reaches max_binlog_size.
Why new log file is created daily as:
My system is not rebooted from last 10days which I checked with uptime command in terminal.
The max_binlog_size is given 50M in configuration and my logs reached only 2-3M.
I have not used FLUSH logs.
I have no CRON which do some task auto magically.
I have googled this query but didn't find the reason.
Can anyone help me to know the reason. Thanks in advance
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.