From: machiel.richards Date: July 12 2010 3:51pm Subject: RE: finding exact query being run List-Archive: http://lists.mysql.com/mysql/222164 Message-Id: <4c3b3a1b.0ca7640a.27de.ffff8464@mx.google.com> MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_0074_01CB21EA.E8CE01F0" ------=_NextPart_000_0074_01CB21EA.E8CE01F0 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0075_01CB21EA.E8CE01F0" ------=_NextPart_001_0075_01CB21EA.E8CE01F0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit mmm... I am not sure about the connection pooling... Fairly new to the site. What I do know is that they run a couple of web servers that connect to the MySQL database and are currently experiencing some performance and connection problems. There are a lot of processes that have been running for more than 25000 seconds and all of them seem to be coming from the web server / host. I am trying to find out whether this can be the cause of the problem and if o if we can simply kill these processes. Machiel Richards herbalife_logo From: Michael Dykman [mailto:mdykman@stripped] Sent: 12 July 2010 5:47 PM To: Machiel Richards Cc: mysql@stripped Subject: Re: finding exact query being run 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 wrote: 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 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. ------=_NextPart_001_0075_01CB21EA.E8CE01F0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

mmm... I am not sure about the connection pooling... = Fairly new to the site.

 

What I do know is that they run a couple of web servers = that connect to the MySQL database and are currently experiencing some = performance and connection problems.

 

There are a lot of processes that have been running for = more than 25000 seconds and all of them seem to be coming from the web server = / host.

 

I am trying to find out whether this can be the cause of = the problem and if o if we can simply kill these = processes.

 

 

 

Machiel Richards

3D"herbalife_logo"

 

From: Michael Dykman = [mailto:mdykman@stripped]
Sent: 12 July 2010 5:47 PM
To: Machiel Richards
Cc: mysql@stripped
Subject: Re: finding exact query being run

 

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

 

3D"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

 <= /o:p>

SHOW FULL RPOCESSLIST

 <= /o:p>

will show you the full text of the running queries.


 - md

 <= /o:p>

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

Hi All

 <= /o:p>

  =             &= nbsp; I am trying to find out how to see the exact query being = run.

 <= /o:p>

  =             &= nbsp; When running show processlit, I get a lot of processes that have been = running for a VERY long time.

 <= /o:p>

  =             &= nbsp; I a trying to find out exactly what query it is that is being run , any = ideas?

 <= /o:p>

  =             &= nbsp; I tried the slow query log but it is not showing up in = there.

 <= /o:p>

  =             &= nbsp; All the queries are showing “sleep”

 <= /o:p>

  =             &= nbsp; Not sure if this means anything....

 <= /o:p>

Machiel = Richards

MySQL DBA

Relational Database Consulting =

 <= /o:p>

Error! Filename not specified.

 <= /o:p>




--
 - michael dykman
 - mdykman@stripped

 May the Source be with you.




--
 - michael dykman
 - mdykman@stripped

 May the Source be with you.

------=_NextPart_001_0075_01CB21EA.E8CE01F0-- ------=_NextPart_000_0074_01CB21EA.E8CE01F0--