25 Jun
2013
25 Jun
'13
6:36 p.m.
Am 25.06.2013 18:19, schrieb Sergei Golubchik:
On Jun 25, Vincent Pelletier wrote:
Hi.
We get 500k such lines per day:
130517 0:00:02 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted. Statement: UPDATE [...]
Is there a way to silence them ? Intuitively, I would expect a companion option to innodb_locks_unsafe_for_binlog, but couldn't find one in the documentation.
Try --log-warnings=0
"binlog-format=MIXED" would be smarter https://kb.askmonty.org/en/binary-log-formats/