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.
On 06/06/13 13:06, Claudio Nanni wrote:
> 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?