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
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: bin/pt- query-digest --type tcpdump /tmp/mysql.tcp.out \ >{fingerprint} =~ m/^select/i) && ($event->{arg} !~ m/for update/i) && ($event- >{fingerprint} !~ m/some_ table_name_ to_ignore/ i)' \
/usr/
--output slowlog --no-report \
--filter '($event-
> /tmp/slow.log.out 2> /dev/null