Re: server-side logging of query errors?

2015-06-25 Thread Andrew Moore
hing including > >> bad queries (eg. select fark from fark from fark fark fark from frak). > >> You should be able to write a JSON parser that extracts what you want > >> based on the log (eg. STATUS, COMMAND, NAME). > >> > >> On Wed, Jun 24, 2015 at 11:05

Re: server-side logging of query errors?

2015-06-24 Thread Singer Wang
from frak). >> You should be able to write a JSON parser that extracts what you want >> based on the log (eg. STATUS, COMMAND, NAME). >> >> On Wed, Jun 24, 2015 at 11:05 AM, Johan De Meersman >> wrote: >> >> - >>> >>

Re: server-side logging of query errors?

2015-06-24 Thread Tomasz Chmielewski
at 11:05 AM, Johan De Meersman wrote: - FROM: "Singer X.J. Wang" SUBJECT: Re: server-side logging of query errors? You could log all queries using the audit plugin, 15% hit.. Fair point, though: maybe one of the different audit plugins has the cap

Re: server-side logging of query errors?

2015-06-24 Thread Singer Wang
(eg. STATUS, COMMAND, NAME). On Wed, Jun 24, 2015 at 11:05 AM, Johan De Meersman wrote: > > -- > > *From: *"Singer X.J. Wang" > *Subject: *Re: server-side logging of query errors? > > You could log all queries using the audit plugin, 1

Re: server-side logging of query errors?

2015-06-24 Thread Johan De Meersman
> From: "Singer X.J. Wang" > Subject: Re: server-side logging of query errors? > You could log all queries using the audit plugin, 15% hit.. Fair point, though: maybe one of the different audit plugins has the capability to specifically log faulty requests. Have a look thro

Re: server-side logging of query errors?

2015-06-23 Thread Singer Wang
You could log all queries using the audit plugin, 15% hit.. On Tue, Jun 23, 2015 at 4:54 AM, Johan De Meersman wrote: > - Original Message - > > From: "Tomasz Chmielewski" > > >> It would be a mild security risk; a malicious > >> (or just stupid, see Hanlon's razor) user could spam your

Re: server-side logging of query errors?

2015-06-23 Thread Johan De Meersman
- Original Message - > From: "Tomasz Chmielewski" >> 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 s

Re: server-side logging of query errors?

2015-06-23 Thread Tomasz Chmielewski
On 2015-06-23 17:29, Johan De Meersman wrote: None that I'm aware of. It's a pity! This could ease debugging in many cases, without the need to change the client (i.e. PHP/Perl/Python code which sends the queries, and we suspect that some of them are bogus). It would be a mild security ri

Re: server-side logging of query errors?

2015-06-23 Thread Johan De Meersman
he proxies out there has support for such logging, I'm not really familiar with any of them. - Original Message - > From: "Tomasz Chmielewski" > To: "MySql" > Sent: Tuesday, 23 June, 2015 09:35:46 > Subject: server-side logging of query errors? &

server-side logging of query errors?

2015-06-23 Thread Tomasz Chmielewski
Suppose I run a query which has a syntax error: mysql> blah; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blah' at line 1 How can I get mysql server to log this error? According to