Re: server-side logging of query errors?
- Date: Tue, 23 Jun 2015 09:52:04 -0400
- From: Singer Wang <wang@xxxxxxxxxxxxxx>
- Subject: 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>
> ----- 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