maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

Hi, Vincent!

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

Regards,
Sergei