hostname_max column is empty about anemometer

[akuzminsky]

@vachanda , we'll have a look

[krzykawski]

I'm sure vachanda above already has fixed this. For others that are having the same issue, the pt-query-digest command line need the hostname specified as described in https://github.com/box/Anemometer/blob/master/README.md

i.e, my function in my collect script run across all db's is:
`
digest() {

    LOG "Running pt-query-digest and saving metrics in database $STOREDB - file: $1"

    pt-query-digest \
    --user=${DBUSER} \
    --password=${DBPASS} \
    --review h=${STOREDB},D=slow_query_log,t=global_query_review,P=${STOREDBPORT} \
    --history h=${STOREDB},D=slow_query_log,t=global_query_review_history,P=${STOREDBPORT} \
    --no-report \
    --limit=0% \
    --filter=" \$event->{Bytes} = length(\$event->{arg}) and \$event->{hostname}=\"$HOSTNAME:$MYPORT\"" $1 >> $SESSIONLOGFILE

EXIT=$?

}
`

Note $HOSTNAME and $MYPORT. The latter is picked up from the local my.cnf file like: MYPORT=$(cat /etc/my.cnf|grep port|head -1|sed 's/[^0-9]//g'). The former is a bash default var, but if you're on an older bash, you can populate it like HOSTNAME=$(hostname)

[Jonathanliu525]

I have the same problem when I use the percona-toolkit 2.2.13,although I specify the host by using --filter=" \$event->{Bytes} = length(\$event->{arg}) and \$event->{hostname}=\"$HOSTNAME\""
I solve it after changing to percona-toolkit 3.0.2.
know more about the hostname_max. You can read this

https://www.percona.com/blog/2012/08/28/hidden-columns-of-query_review_history/