I used to run this command:
tcpdump -i lo port 3306 -s 65535 -x -n -q -tttt > pt.log; pt-query-digest --type=tcpdump pt.log
But it stopped working for me. I cannot put my finger on the problem because I experience it on different Debian versions and different percona server versions, different percona-toolkit version and I can even reproduce with mariadb.
The error I get:
Pipeline process 4 (MySQLProtocolParser) caused an error: Argument “” isn’t numeric in multiplication () at /usr/bin/pt-que
ry-digest line 4505, <$fh> line 8.
Will retry pipeline process 3 (MySQLProtocolParser) 100 more times.
Pipeline process 4 (MySQLProtocolParser) caused an error: Argument “” isn’t numeric in multiplication () at /usr/bin/pt-que
ry-digest line 4505, <$fh> line 10.
Will retry pipeline process 3 (MySQLProtocolParser) 99 more times.
…
Will retry pipeline process 3 (MySQLProtocolParser) 1 more time.
The pipeline caused an error: Pipeline process 4 (MySQLProtocolParser) caused an error: Argument “” isn’t numeric in multipl
ication (*) at /usr/bin/pt-query-digest line 4505, <$fh> line 210.
Terminating pipeline because process 3 (MySQLProtocolParser) caused too many errors.
What is wrong?