List:Commits« Previous MessageNext Message »
From:Luís Soares Date:July 20 2009 9:49am
Subject:Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)
Bug#42851
View as plain text  
On Sun, 2009-07-19 at 00:24 -0300, Davi Arnaut wrote:
> On 7/18/09 1:52 PM, Luis Soares wrote:
> > #At file:///home/lsoares/Workspace/mysql-server/bugfix/b42851/mysql-5.1-bugteam/
> based on revid:joro@stripped
> >
> >   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
> >        nightmare.
> >
> >        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
> >        following:
> 
> [..]
> 
> 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?

Hi Davi,

  I have replied to these questions on the mail I sent to Sergei.

Regards,
Luís

-- 
Luís

Thread
bzr commit into mysql-5.1-bugteam branch (luis.soares:3024) Bug#42851Luis Soares18 Jul
  • Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)Bug#42851Davi Arnaut19 Jul
    • Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)Bug#42851Sergei Golubchik19 Jul
      • Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)Bug#42851Luís Soares20 Jul
        • Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)Bug#42851Davi Arnaut20 Jul
          • Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)Bug#42851Konstantin Osipov20 Jul
          • Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)Bug#42851Mark Leith23 Jul
    • Re: bzr commit into mysql-5.1-bugteam branch (luis.soares:3024)Bug#42851Luís Soares20 Jul