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.