← Back to team overview

maria-discuss team mailing list archive

Re: What is the log_bin and log_bin_index config for?


 On 8/10/2010 5:25 AM, Joshua Partogi wrote:
Hi all,

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 recorded.