RE: finding exact query being run

2010-07-13 Thread Daevid Vincent
om [mailto:vegiv...@gmail.com] On > Behalf Of Johan De Meersman > Sent: Tuesday, July 13, 2010 1:17 AM > To: Daevid Vincent > Cc: Machiel Richards; mysql@lists.mysql.com > Subject: Re: finding exact query being run > > Which will still not be particularly helpful for subsecond que

Re: finding exact query being run

2010-07-13 Thread Johan De Meersman
all-time favourite feature of maatkit :-D On Tue, Jul 13, 2010 at 12:05 AM, Daevid Vincent wrote: > get "mytop" > > > _ > > From: Machiel Richards [mailto:machi...@rdc.co.za] > Sent: Monday, July 12, 2010 8:40 AM > To: mysql@lists.mysql.com > S

RE: finding exact query being run

2010-07-12 Thread Daevid Vincent
get "mytop" _ From: Machiel Richards [mailto:machi...@rdc.co.za] Sent: Monday, July 12, 2010 8:40 AM To: mysql@lists.mysql.com Subject: finding exact query being run Hi All I am trying to find out how to see the exact query being run.

Re: finding exact query being run

2010-07-12 Thread Prabhat Kumar
In my.cnf, check wait_timeout value , default is 4800. Make it to wait_timeout = 60 Thus, the connections will automatically be closed after waiting for 60 seconds. On Mon, Jul 12, 2010 at 11:51 PM, John Daisley wrote: > If you have lots of sleeping processes the chances are you have a poorly >

Re: finding exact query being run

2010-07-12 Thread John Daisley
If you have lots of sleeping processes the chances are you have a poorly written app that is not closing its database connections. Those sleeping processes are just connections waiting for another command from the application or whatever else initiated them. The sleeping processes will not show up

Re: finding exact query being run

2010-07-12 Thread Michael Dykman
gt; *Sent:* 12 July 2010 5:47 PM > > *To:* Machiel Richards > *Cc:* mysql@lists.mysql.com > *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 nor

RE: finding exact query being run

2010-07-12 Thread machiel.richards
...@gmail.com] Sent: 12 July 2010 5:47 PM To: Machiel Richards Cc: mysql@lists.mysql.com 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

Re: finding exact query being run

2010-07-12 Thread Michael Dykman
o: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. >

RE: finding exact query being run

2010-07-12 Thread Machiel Richards
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:mdyk...@gmail.com] Sent: 12 July 2010 5:43 PM To: Machiel Richards Cc: mysql@lists.mysql.com Subject: Re: finding exact query

Re: finding exact query being run

2010-07-12 Thread Michael Dykman
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

finding exact query being run

2010-07-12 Thread Machiel Richards
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 , an