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 <machi...@rdc.co.za>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:mdyk...@gmail.com] > *Sent:* 12 July 2010 5:43 PM > *To:* Machiel Richards > *Cc:* mysql@lists.mysql.com > *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 <machi...@rdc.co.za> > 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 > - mdyk...@gmail.com > > May the Source be with you. > -- - michael dykman - mdyk...@gmail.com May the Source be with you.