Web lists-archives.com

Re: server-side logging of query errors?




You could log all queries using the audit plugin, 15% hit..

On Tue, Jun 23, 2015 at 4:54 AM, Johan De Meersman <vegivamp@xxxxxxxxx>
wrote:

> ----- Original Message -----
> > From: "Tomasz Chmielewski" <mangoo@xxxxxxxx>
>
> >> It would be a mild security risk; a malicious
> >> (or just stupid, see Hanlon's razor) user could spam your server with
> >> malformed requests until the logging disk runs full, at which point
> >> the daemon would suspend operations until space is freed.
> >
> > I don't think it's a valid argument - the same is true right now for
> > "general query log". Any stupid/malicious user can produce loads of
> > queries and fill the disk if one has "general query log" enabled.
> >
> > In short, anyone enabling any logging should consider what limitations
> > it brings.
>
> Including quite a bit of overhead, which is why its use is discouraged in
> production :-)
>
>
> --
> Unhappiness is discouraged and will be corrected with kitten pictures.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>