Skip to content

Instantly share code, notes, and snippets.

@TomCan

TomCan/live-capture mysql: tcpdump + pt-query-digest

Created April 24, 2017 14:01
Show Gist options
  • Save TomCan/b6b332ada994fcb2f500bdbd1ae6438a to your computer and use it in GitHub Desktop.
Save TomCan/b6b332ada994fcb2f500bdbd1ae6438a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
live-capture mysql: tcpdump + pt-query-digest
# this requires that MySQL is accessed through TCP/IP, not the unix socket.
# run tcpdump for 30 seconds capturing traffic on port 3306
timeout 30 tcpdump -s 65535 -x -nn -q -tttt -i any port 3306 > mysql.tcp.txt
# run pt-query-digest on collected file
pt-query-digest --type tcpdump mysql.tcp.txt >pt.out
@TomCan
Copy link
Author

TomCan commented Jan 22, 2020

https://github.com/percona/percona-toolkit/pull/434/files

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment