MySQL error 1665 (HY000) case

1.1.1. ERROR 1665 (HY000)

"Environment description"

msyql5.6.14

"Error Message"

Error executing SQL statement:

ERROR 1665 (HY000): Cannot executestatement:impossible to write to binary log since Binlog_format = Statementand at least One table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation the level is readcommitted or READ uncommitted.

"Cause of the error"

When the INNODB transaction isolation level is read commited or read uncommited mode, the statement mode is not available for Binlog.

"Workaround"

Workaround for not restarting the MySQL instance:

Set Global binlog_format=mixed

Binlog format changes to mixed mode in the re-established session sessions.

This column more highlights: http://www.bianceng.cn/database/MySQL/