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 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.
Now to your question,
pt-query-digest version 2.2.2
I run to connect to remote node:
pt-query-digest --processlist h=192.168.1.111,u=user -p PASSWORD
--print --no-report --run-time 60 > SERVER-`date +%Y%m%d-%H`
I get:
Unknown option: print
Maybe because such option does not exist?
Cheers
Claudio