I am currently debugging an application where there is a two second lag. I used tcpdump to capture the database activities and use pt-query-digest to produce output.
tcpdump -s 65535 -x -nn -q -tttt -i any -c 400000 port 3306 > mysqltcp.txt
pt-query-digest --type tcpdump mysqltcp.txt > tcpdigest.out
The output is useful but I want to display the tcpdigest in the order of time. Currently the data is aggregated. We want to see the play-by-play of the query execution during the two second. Is it possible?