List:General Discussion« Previous MessageNext Message »
From:Machiel Richards Date:July 12 2010 3:44pm
Subject:RE: finding exact query being run
View as plain text  
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 <machielr@stripped>
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.


Attachment: [text/html]
Attachment: [text/html]
Attachment: [text/html]
Thread
finding exact query being runMachiel Richards12 Jul
  • Re: finding exact query being runMichael Dykman12 Jul
    • RE: finding exact query being runMachiel Richards12 Jul
      • Re: finding exact query being runMichael Dykman12 Jul
        • RE: finding exact query being runmachiel.richards12 Jul
          • Re: finding exact query being runMichael Dykman12 Jul
  • Re: finding exact query being runJohn Daisley12 Jul
    • Re: finding exact query being runPrabhat Kumar12 Jul
  • RE: finding exact query being runDaevid Vincent13 Jul
    • Re: finding exact query being runJohan De Meersman13 Jul
      • RE: finding exact query being runDaevid Vincent13 Jul