2014/06/11

mysql Cannot execute statement: impossible to write to binary log

since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.
InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.


==>isolation level is READ COMMITTED or READ UNCOMMITTED なる程。。

・mysql binlog-format
  Row-based: always safe, possibly very slow and inefficient in time and space
    Statement-based: not always safe, but may be much faster
    Mixed-mode: best of both worlds in theory, but could possibly get it wrong resulting in either slow performance, or wrong data depending on which way it gets it wrong!