List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:July 12 2010 3:46pm
Subject:Re: finding exact query being run
View as plain text  
Am I correct in assuming that your application does connection pooling?  If
so, then these long lasting, idle threads are normal.

If there is no connection pooling, then this might be a symptom of a problem
with your application server not letting go of processes properly.

 - md

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

>  I had a look and all of these just say sleep as the command.
>
>
>
> Machiel Richards
>
> MySQL DBA
>
> Relational Database Consulting
>
>
>
> [image: 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.
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.

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