MySQL Forums
Forum List  »  Backup

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:

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

Options: ReplyQuote


Subject
Views
Written By
Posted
why mysql binlog creating new log file daily
6080
February 13, 2014 12:59AM


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.