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
You can see on the query rank number 2 an empty Item.
Why ?
Thank you