From: Machiel Richards Date: July 12 2010 3:39pm Subject: finding exact query being run List-Archive: http://lists.mysql.com/mysql/222159 Message-Id: <004a01cb21d8$7b8ecdc0$72ac6940$@co.za> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_004B_01CB21E9.3F179DC0" ------=_NextPart_000_004B_01CB21E9.3F179DC0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_004C_01CB21E9.3F179DC0" ------=_NextPart_001_004C_01CB21E9.3F179DC0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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_001_004C_01CB21E9.3F179DC0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi All

 

         &= nbsp;      I am trying to find out how to see = the exact query being run.

 

         &= nbsp;      When running show processlit, I get = a lot of processes that have been running for a VERY long time.

 

         &= nbsp;      I a trying to find out exactly what = query it is that is being run , any ideas?

 

         &= nbsp;      I tried the slow query log but it is = not showing up in there.

 

         &= nbsp;      All the queries are showing = “sleep”

 

         &= nbsp;      Not sure if this means = anything....

 

Machiel = Richards

MySQL = DBA

Relational Database Consulting

 

3D"RDC_Logo"

 

------=_NextPart_001_004C_01CB21E9.3F179DC0-- ------=_NextPart_000_004B_01CB21E9.3F179DC0--