Tweeted twitter.com/#!/StackDBAs/status/151398321976655872
2 added 25 characters in body; edited tags
source | link

We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)

According to the mysql manual (http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#sysvar_binlog_formatMySQL Documentation), the binary log should contain sqlSQL statements only, but we still see BINLOG rows in our binlogs, as the first statement in each binlog.

whyWhy is that?

We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)

According to the mysql manual (http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#sysvar_binlog_format) the binary log should contain sql statements only, but we still see BINLOG rows in our binlogs, as the first statement in each binlog.

why is that?

We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)

According to the MySQL Documentation, the binary log should contain SQL statements only, but we still see BINLOG rows in our binlogs, as the first statement in each binlog.

Why is that?

1
source | link

mysql emits BINLOG rows even though binlog_­format=­STATEMENT

We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)

According to the mysql manual (http://dev.mysql.com/doc/refman/5.5/en/replication-options-binary-log.html#sysvar_binlog_format) the binary log should contain sql statements only, but we still see BINLOG rows in our binlogs, as the first statement in each binlog.

why is that?