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


Percona’s widely read Percona Database Performance blog highlights our expertise in enterprise-class software, support, consulting and managed services solutions for both MySQL® and MongoDB® across traditional and cloud-based platforms. The decades of experience represented by our consultants is found daily in numerous and relevant blog posts.

Besides specific database help, the blog also provides notices on upcoming events and webinars.
Want to get weekly updates listing the latest blog posts? Subscribe to our blog now! Submit your email address below and we’ll send you an update every Friday at 1pm ET.

No, thank you. Please do not ask me again.