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]
