why mysql binlog creating new log file daily
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:
log-bin="/var/log/mysql/"
expire_logs_days=10
max_binlog_size=50M
binlog-ignore-db="phpmyadmin"
<b>Problem:</b>
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
Usman Ghani
www.grasphub.com
Subject
Views
Written By
Posted
why mysql binlog creating new log file daily
6271
February 13, 2014 12:59AM
1431
February 14, 2014 08:30PM
Sorry, you can't reply to this topic. It has been closed.
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.