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
Which will still not be particularly helpful for subsecond queries :-) Either turn on the full query log (beware of I/O implications, use separate spindles if possible) or use mk-query-analyzer with tcpdump to get a running analysis of what passes the line. The addition of tcpdump support is my a

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. When runn

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
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:* Machi

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