maria-discuss team mailing list archive
Mailing list archive
Re: What is the log_bin and log_bin_index config for?
Brian Evans <grknight@xxxxxxxxxxxxxx>
Tue, 10 Aug 2010 08:33:49 -0400
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:18.104.22.168) Gecko/20100802 Thunderbird/3.1.2
On 8/10/2010 5:25 AM, Joshua Partogi wrote:
Can anyone advise what is the log_bin and log_bin_index configuration
in my.cnf for?
log_bin is for binary logging. This is used for replication and,
sometimes, for backup systems because you can replay the log.
If you don't need either of these, you can just turn off binary logging
since it will log every data manipulation or table change.
More info is here: http://dev.mysql.com/doc/refman/5.1/en/binary-log.html
When I enable both of this config and did and alter table on a table
with PBXT engine, I encounter this error:
MariaDB [bar]> alter table foo rename to tmp;
ERROR 1598 (HY000): Binary logging not possible. Message:
Statement-based format required for this statement, but not allowed by
this combination of engines
I use PBXT and set "binlog-format=MIXED" so that all statements get