maria-discuss team mailing list archive

[Brian Evans <grknight@xxxxxxxxxxxxxx>]

 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.