Am I correct in assuming that your application does connection pooling?  If so, then these long lasting, idle threads are normal.<div><br></div><div>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.</div>
<div><br></div><div> - md<br><br><div class="gmail_quote">On Mon, Jul 12, 2010 at 11:44 AM, Machiel Richards <span dir="ltr">&lt;<a href="mailto:machielr@rdc.co.za">machielr@rdc.co.za</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">










<div lang="EN-ZA" link="blue" vlink="purple">

<div>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">I had a look and all of these just say sleep as the command.</span></p><div class="im">

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Comic Sans MS&quot;;color:#1F497D">Machiel Richards</span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Comic Sans MS&quot;;color:#1F497D">MySQL DBA</span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Comic Sans MS&quot;;color:#1F497D">Relational Database Consulting </span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><img width="323" height="117" src="cid:image001.jpg@01CB21E9.D2F43F30" alt="RDC_Logo"></span></p>

<p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span></p>

</div><div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">

<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt">From:</span></b><span lang="EN-US" style="font-size:10.0pt"> Michael Dykman [mailto:<a href="mailto:mdykman@gmail.com" target="_blank">mdykman@gmail.com</a>] <br>

<b>Sent:</b> 12 July 2010 5:43 PM<br>
<b>To:</b> Machiel Richards<br>
<b>Cc:</b> <a href="mailto:mysql@lists.mysql.com" target="_blank">mysql@lists.mysql.com</a><br>
<b>Subject:</b> Re: finding exact query being run</span></p>

</div><div class="im">

<p class="MsoNormal"> </p>

<div>

<p class="MsoNormal">SHOW FULL RPOCESSLIST</p>

</div>

<div>

<p class="MsoNormal"> </p>

</div>

<div>

<p class="MsoNormal">will show you the full text of the running queries.</p>

</div>

<p class="MsoNormal"><br>
 - md</p>

</div><div>

<p class="MsoNormal"> </p>

<div><div class="im">

<p class="MsoNormal">On Mon, Jul 12, 2010 at 11:39 AM, Machiel Richards &lt;<a href="mailto:machielr@rdc.co.za" target="_blank">machielr@rdc.co.za</a>&gt; wrote:</p>

</div><div>

<div><div class="im">

<p class="MsoNormal">Hi
All</p>

<p class="MsoNormal"> </p>

<p class="MsoNormal">               
I am trying to find out how to see the exact query being run.</p>

<p class="MsoNormal"> </p>

<p class="MsoNormal">               
When running show processlit, I get a lot of processes that have been running
for a VERY long time.</p>

<p class="MsoNormal"> </p>

<p class="MsoNormal">               
I a trying to find out exactly what query it is that is being run , any ideas?</p>

<p class="MsoNormal"> </p>

<p class="MsoNormal">               
I tried the slow query log but it is not showing up in there.</p>

<p class="MsoNormal"> </p>

<p class="MsoNormal">               
All the queries are showing “sleep”</p>

<p class="MsoNormal"> </p>

<p class="MsoNormal">               
Not sure if this means anything....</p>

<p class="MsoNormal"> </p>

<p class="MsoNormal"><span style="font-family:&quot;Comic Sans MS&quot;">Machiel Richards</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Comic Sans MS&quot;">MySQL DBA</span></p>

<p class="MsoNormal"><span style="font-family:&quot;Comic Sans MS&quot;">Relational Database Consulting </span></p>

<p class="MsoNormal"> </p>

</div><p class="MsoNormal"><b><span lang="EN-US">Error! Filename not specified.</span></b></p>

<p class="MsoNormal"> </p>

</div>

</div>

</div><div class="im">

<p class="MsoNormal"><br>
<br clear="all">
<br>
-- <br>
 - michael dykman<br>
 - <a href="mailto:mdykman@gmail.com" target="_blank">mdykman@gmail.com</a><br>
<br>
 May the Source be with you.</p>

</div></div>

</div>

</div>


</blockquote></div><br><br clear="all"><br>-- <br> - michael dykman<br> - <a href="mailto:mdykman@gmail.com">mdykman@gmail.com</a><br><br> May the Source be with you.<br>
</div>