On Jul 19, Davi Arnaut wrote:
> On 7/18/09 1:52 PM, Luis Soares wrote:
>> 3024 Luis Soares 2009-07-18
>> BUG#42851: Spurious "Statement is not safe to log in statement
>> format." warnings
>> Several warnings are printed when using statement based logging
>> and unsafe operations are logged to the binlog. For example, this
>> is the case for statements using LIMIT + ORDER BY PK. As a
>> consequence, this would rapidly increase mysqld error log size,
>> in some cases to several gigabytes, causing a maintenance
>> This patch proposes a mechanism to selectively and voluntarily
>> suppress warnings from mysqld error log. It adds a dynamic server
>> variable "suppress_log_warnings", which can be used to set/reset
>> warning filtering from mysqld error log. Its details are the
> Excuse my ignore, what part of this patch can't be done by piping the
> error log through a filter script? AFAIR, its possible to have a pipe
> as a logging target.
> Also, wouldn't it be much simpler to just rate limit messages?
And we have --log-warnings=N switch already.
The simplest solution would be to log this "Statement is not safe to log
in statement format." only when N>0, for example.
Regards / Mit vielen Grüßen,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <serg@stripped>
/ /|_/ / // /\ \/ /_/ / /__ Principal Software Engineer/Server Architect
/_/ /_/\_, /___/\___\_\___/ Sun Microsystems GmbH, HRB München 161028
<___/ Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring