List:General Discussion« Previous MessageNext Message »
From:nixofortune Date:June 6 2013 4:13pm
Subject:Re: pt-query-digest --processlist
View as plain text  
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


Thread
pt-query-digest --processlistnixofortune6 Jun
  • Re: pt-query-digest --processlistClaudio Nanni6 Jun
    • Re: pt-query-digest --processlistJohan De Meersman6 Jun
    • Re: pt-query-digest --processlistnixofortune6 Jun