Change the maximum allowed binary log file size in MySQL

Change the maximum allowed binary log file size in MySQL

Answer:

By default, the MySQL's maximum binary log file is 1073741824 bytes (1GB).

If you want to change it, edit the MySQL configurations, e.g. /etc/my.cnf

[mysqld]
...
...
max_binlog_size 4294967296

Restart MySQL to take effect.

# /sbin/service mysqld restart

Now the new maximum binary log file is set to 4GB.

Related posts:

1. Set the maximum allowed number of connections in MySQL
2. Change the PHP’s maximum allowed form post size
3. Setting the MySQL’s Binary Log Format
4. Auto remove expired binary log in MySQL
5. Enable MySQL binary log (bin log)