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
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
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.
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
>
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
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
...@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
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.
>
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
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
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
11 matches
Mail list logo