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