EmergencyEMERGENCY? Get 24/7 Help Now!

Announcing Percona Playback 0.4 (now with packages!)

 | September 13, 2012 |  Posted In: Percona Software


We are glad to announce the availability of Percona Playback 0.4, the first release where we’ve released binary packages alongside our source release.

Binary packages for RHEL/CentOS 6 are available with Debian/Ubuntu packages soon to come (we are ensuring our dependencies are correct before publishing). Packages and source may be downloaded from here and are available in our EXPERIMENTAL repositories.

Changes in this release (since 0.3):

  • Produce binary packages for CentOS/RHEL and Debian/Ubuntu.
  • Initial libdrizzle based database client (can be used instead of libmysqlclient).
  • Fix #1021577, improve accurate mode of tcpdump playback.
  • We now build on CentOS/RHEL 5 (with appropriate libraries)
  • Documentation updates
Stewart Smith

Stewart Smith has a deep background in database internals including MySQL, MySQL Cluster, Drizzle, InnoDB and HailDB. he is also one of the founding core developers of the Drizzle database server. He served at Percona from 2011-2014. He is a former Percona employee.


  • It’s a tool for replaying database load.

    You can capture load via the slow query log or a tcpdump capture of network traffic, and then ask Percona Playback to attempt to play back this load against a different database server.

    It can be used for constructing “real world” benchmarks, testing patches etc.

  • Hello Stewart ,
    playback the tcpdump file is not stable.


    wait for you answer.


  • Hi! I’ve created a bug for it, it would be excellent if you could flesh out the details: sample tcpdump that causes the problem (perhaps a smaller one can suffice, or generate one with other load generation tools), server version, OS platform.

  • HI, we have found the reason caused the problem in file named inet_hashtables.c. The function __inet_check_established caused spin_lock.

    We modify /etc/sysctl.conf, add:

    net.ipv4.tcp_syncookies = 1
    net.ipv4.tcp_tw_reuse = 1
    net.ipv4.tcp_tw_recycle = 1
    net.ipv4.tcp_fin_timeout = 30

    Now we can playback the tcpdump file continuously.

    thank you very much for your reply.
    Now we are testing the great playback tool.

    PS: the tcpdump-mode fast may not work so effective in our experiments.

Leave a Reply