+1-208-473-2904 (USA - Sales)
The main purpose of this plugin is to parse MySQL queries from tcpdump files. Currently this plugin doesn’t support work with prepare and execute statements. Also it doesn’t parse MySQL threads_id because they are passed only during handshake, but tcpdump tool can be started in the middle of the session. That’s why thread_id which can be seen in the report of report plugins is some hash from client ip-port pair. Currently only parsing of ipv4 connections is implemented.
$ tcpdump -i eth0 port 3306 -w example.dump
Percona Playback currently doesn’t support any as and tcpdump interface option. If “-i any” is used for capturing tcpdump parser works wrong.
$ percona-playback --input-plugin=tcpdump --tcpdump-file=example.dump --tcpdump-mode=accurate \ --db-plugin=libmysqlclient --mysql-host=10.8.2.10 --mysql-username=root \ --mysql-password=passW0rd --mysql-schema=imdb
Report ------ Executed 22 queries Spent 00:00:32.844442 executing queries versus an expected 00:00:00.503753 time. 1 queries were quicker than expected, 21 were slower A total of 0 queries had errors. Expected 30298 rows, got 30298 (a difference of 0) Number of queries where number of rows differed: 0. Average of 22.00 queries per connection (1 connections).