From: Daevid Vincent
Date: July 12 2010 10:05pm
Subject: RE: finding exact query being run
List-Archive: http://lists.mysql.com/mysql/222170
Message-Id: <5AB33B07A42A415B8503D68DE7092D2D@mascorp.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0120_01CB21D3.B0432E80"

------=_NextPart_000_0120_01CB21D3.B0432E80
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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

 


------=_NextPart_000_0120_01CB21D3.B0432E80--