Andy, On Tue, Feb 9, 2010 at 10:27 AM, andy knasinski <a...@nrgsoft.com> 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
