From: Daevid Vincent
Date: July 13 2010 8:08pm
Subject: RE: finding exact query being run
List-Archive: http://lists.mysql.com/mysql/222195
Message-Id: <0C6F8FD289A54CDABE611CD7FD8BFAA9@mascorp.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Well, you should be using a wrapper around your DB library class already
right? Like you don't use PEAR:DB directly, you have a wrapper class to
handle making a connection, doing the query, handling the error, etc.
Otherwise you're wasting a LOT of code/time. Not to mention it makes it
trivial to swap out the calls to another database library without chaning
all of YOUR code.

So all I did is wedge a logger/profiler into my sql_query() routine. This
has various levels of logging and saving the start/end times, etc. 

> -----Original Message-----
> From: vegivamp@stripped [mailto:vegivamp@stripped] On 
> Behalf Of Johan De Meersman
> Sent: Tuesday, July 13, 2010 1:17 AM
> To: Daevid Vincent
> Cc: Machiel Richards; mysql@stripped
> Subject: Re: finding exact query being run
> 
> Which will still not be particularly helpful for subsecond queries :-)
> 
> Either turn on the full query log (beware of I/O 
> implications, use separate
> spindles if possible) or use mk-query-analyzer with tcpdump 
> to get a running
> analysis of what passes the line.
> 
> The addition of tcpdump support is my all-time favourite 
> feature of maatkit
> :-D
> 
> 
> On Tue, Jul 13, 2010 at 12:05 AM, Daevid Vincent 
> <daevid@stripped> wrote:
> 
> > get "mytop"
> >
> >
> >  _____
> >
> > From: Machiel Richards [mailto:machielr@stripped]
> > Sent: Monday, July 12, 2010 8:40 AM
> > To: mysql@stripped
> > Subject: finding exact query being run
> >
> >
> >
> > Hi All
> >
> >
> >
> >                I am trying to find out how to see the exact 
> query being
> > run.
> >
> >
> >
> >                When running show processlit, I get a lot of 
> processes that
> > have been running for a VERY long time.
> >
> >
> >
> >                I a trying to find out exactly what query it 
> is that is
> > being run , any ideas?
> >
> >
> >
> >                I tried the slow query log but it is not 
> showing up in
> > there.
> >
> >
> >
> >                All the queries are showing "sleep"
> >
> >
> >
> >                Not sure if this means anything....
> >
> >
> >
> > Machiel Richards
> >
> > MySQL DBA
> >
> > Relational Database Consulting
> >
> >
> >
> > RDC_Logo
> >
> >
> >
> >
> 
> 
> -- 
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
>