Re: pt-query-digest --processlist

2013-06-06 Thread Claudio Nanni
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 >

Re: pt-query-digest --processlist

2013-06-06 Thread Johan De Meersman
- 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

Re: pt-query-digest --processlist

2013-06-06 Thread nixofortune
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

pt-query-digest --processlist

2013-06-06 Thread nixofortune
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