From: Machiel Richards Date: July 12 2010 3:44pm Subject: RE: finding exact query being run List-Archive: http://lists.mysql.com/mysql/222162 Message-Id: <006201cb21d9$11cd05e0$356711a0$@co.za> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_0063_01CB21E9.D555D5E0" ------=_NextPart_000_0063_01CB21E9.D555D5E0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0064_01CB21E9.D555D5E0" ------=_NextPart_001_0064_01CB21E9.D555D5E0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I had a look and all of these just say sleep as the command. Machiel Richards MySQL DBA Relational Database Consulting RDC_Logo From: Michael Dykman [mailto:mdykman@stripped] Sent: 12 July 2010 5:43 PM To: Machiel Richards Cc: mysql@stripped Subject: Re: finding exact query being run SHOW FULL RPOCESSLIST will show you the full text of the running queries. - md On Mon, Jul 12, 2010 at 11:39 AM, Machiel Richards wrote: 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 Error! Filename not specified. -- - michael dykman - mdykman@stripped May the Source be with you. ------=_NextPart_001_0064_01CB21E9.D555D5E0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I had a look and all of these just say sleep as the = command.

 

Machiel Richards

MySQL DBA

Relational Database Consulting

 

3D"RDC_Logo"

 

From: Michael Dykman = [mailto:mdykman@stripped]
Sent: 12 July 2010 5:43 PM
To: Machiel Richards
Cc: mysql@stripped
Subject: Re: finding exact query being run

 

SHOW FULL RPOCESSLIST

 

will show you the full text of the running = queries.


 - md

 

On Mon, Jul 12, 2010 at 11:39 AM, Machiel Richards = <machielr@stripped> = wrote:

Hi All

 <= /o:p>

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

 <= /o:p>

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

 <= /o:p>

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

 <= /o:p>

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

 <= /o:p>

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

 <= /o:p>

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

 <= /o:p>

Machiel = Richards

MySQL DBA

Relational Database Consulting =

 <= /o:p>

Error! Filename not specified.

 <= /o:p>




--
 - michael dykman
 - mdykman@stripped

 May the Source be with you.

------=_NextPart_001_0064_01CB21E9.D555D5E0-- ------=_NextPart_000_0063_01CB21E9.D555D5E0--