Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Aug 102010

Change the maximum allowed binary log file size in MySQL


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

max_binlog_size 4294967296

Restart MySQL to take effect.

# /sbin/service mysqld restart

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

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>