wards.
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
>
- 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
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
Hi guys,
I'm trying to use pt-query-digest on one of our Prod servers.
The problem our slow log is disabled, no tcpdump is installed and I
decided to use --processlist parameter which I never tried before.
pt-query-digest version 2.2.2
I run to connect to remote node:
pt-query-d