Hi,
First of all I discourage you to use --processlist, I don't think it is
enough an accurate method to analyse queries.
You can dynamically enable the Slow Query Log with long_query_time=0 and
get a way better data.
Check the syntax for SET GLOBAL variables.
Remember to disable it afterwards.
N
- Original Message -
> From: "Claudio Nanni"
>
> You can dynamically enable the Slow Query Log with long_query_time=0
Except when you have persistent connections on a stock mysqld. The recent
Percona ones do have a way to change the settings of existing connections, iirc.
--
Unhappin
Hi Claudio,
Thanks for reply. Great. I was sure you can't enable slow log
dynamically on 5.0 and 5.1.
That solves my issue for 5.1 at least.
Many thanks,
Igor
On 06/06/13 13:06, Claudio Nanni wrote:
Hi,
First of all I discourage you to use --processlist, I don't think it
is enough an accur
