Could you please assist me in understanding the nature of errors in report
and how they are critical.
Here is what I have at the moment:
I’ve collected tcpdump
sudo tcpdump -s 65535 -x -nn -q -tttt -i any -c 2000000 port 3306 >/tmp/mysql_dump_2704_0555.txt
then analyzed it
pt-query-digest --type tcpdump /tmp/mysql_dump_2704_0555.txt >/tmp/mysql_dump_digest_2704_0555.txt
TCP errors session were reported to /tmp/pt-query-digest-errors.qvGoT9E
There are a lot of
reason_for_failure => ‘no server OK to previous command’,
state => ‘awaiting_reply’,
reason_for_failure => ‘got server response before full buffer’,
and sometimes non-empty server_retransmissions
I haven’t found good explanation for them.
Should I worry about them? Are they critical and affect my DB?
Can you point me out for description and further troubleshooting steps?
P.S. I have 2.2.14 pt-query-digest and Percona-Server-server-56-5.6.32