maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #00862
Re: Silencing "Unsafe statement written to the binary log" log warnings
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/
Attachment:
signature.asc
Description: OpenPGP digital signature
References