List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:February 11 2010 7:01pm
Subject:Re: logging of BAD queries
View as plain text  
Andy,

On Tue, Feb 9, 2010 at 10:27 AM, andy knasinski <ajk@stripped> wrote:
> I've used the general and slow query log in the past, but I am trying to
> track down some queries from a compiled app that never seem to be hitting
> the DB server.
>
> My guess is that the SQL syntax is bad and never get executed, but I don't
> see any related queries in the general query log. Does the general log
> include invalid SQL?

Yes, it does.  If you're not able to debug the application itself, I
would sniff the TCP traffic.  Use wireshark or mk-query-digest.

Baron
Thread
logging of BAD queriesandy knasinski9 Feb
  • Re: logging of BAD queriesmos9 Feb
    • Re: logging of BAD queriesandy knasinski9 Feb
      • Re: logging of BAD queriesKyong Kim10 Feb
  • Re: logging of BAD queriesSebastian Mendel10 Feb
  • Re: logging of BAD queriesBaron Schwartz11 Feb