Comment 0 for bug 1402776

Revision history for this message
Ovais Tariq (ovais-tariq) wrote :

When parsing a tcpdump file created with MySQL 5.6 with pt-query-digest the "use database" statements are parsed incorrectly.

The database name is appended with a null character and the string "mysql_native_password".

The Percona toolkit version used is 2.2.11.

The tcpdump command line used is the following:
/usr/sbin/tcpdump -i eth0 -s 65535 -x -n -q -tttt 'port 3306 and tcp[1] & 7 == 2 and tcp[3] & 7 == 2'

The pt-query-digest command line used is the following:
    /usr/bin/pt-query-digest --type tcpdump /tmp/mysql.tcp.out \
        --output slowlog --no-report \
        --filter '($event->{fingerprint} =~ m/^select/i) && ($event->{arg} !~ m/for update/i) && ($event->{fingerprint} !~ m/some_table_name_to_ignore/i)' \
        > /tmp/slow.log.out 2> /dev/null