pt-query-digest and tcpdump == Empty line

KoHeadKoHead ContributorInactive User Role Advisor
Hi everybody,

I'm using pt-query-digest morning on my mysql-server and i saw a strange ligne :

Command :

tcpdump -i eth0 port 3306 -s 65535 -c 10000 -x -n -q -tttt | pt-query-digest --type tcpdump --report-format=profile --limit=10

Result:


tcpdump: verbose output suppressed, use -v or -vv for full protocol decodelistening on eth0, link-type EN10MB (Ethernet), capture size 65535 bytes10000 packets captured10001 packets received by filter0 packets dropped by kernel# Profile# Rank Query ID Response time Calls R/Call Apdx V/M Item# ==== ================== ============= ===== ====== ==== ===== ==========# 1 0x5D51E5F01B88B79E 0.7121 77.7% 11 0.0647 1.00 0.02 ADMIN CONNECT# 2 0x6C099B0B73EA7633 0.1081 11.8% 2291 0.0000 1.00 0.00 # 3 0x2D7D2D3645B889BC 0.0845 9.2% 2226 0.0000 1.00 0.00 SELECT calcul_bid.resume</pre>


You can see on the query rank number 2 an empty Item.

Why ?

Thank you

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.