Percona Toolkit 1.0.1 released

Daniel and I and the Percona release engineering team are proud to announce version 1.0.1 of Percona Toolkit. This toolkit is Percona’s suite of DBA and sysadmin productivity tools for MySQL. It is the successor to the popular Maatkit and Aspersa toolkits. Percona Toolkit is available for immediate download at

Helpful links:

Share this post

Comments (13)

  • hrvojem Reply

    Really nice to hear this, great work! Any plans for adding it to official Percona repository?

    September 7, 2011 at 7:19 am
  • Michal Reply

    Will be nice to install it as simple as apt-get install percona-toolkit

    September 7, 2011 at 8:51 am
  • Shlomi Noach Reply

    Looking at the list it appears as though the vast majority, if not all, tools from Maatkit & Aspersa made it through to Percona Toolkit. Is that the case?

    I have a particular interest in pt-online-schema-change: how far has it been used+tested on your customers production servers?

    September 7, 2011 at 10:29 am
  • George Reply

    Awesome thanks Baron and Daniel.

    Daniel glad to see some form of mysqlreport in form of pt-mysql-summary suggestion from my comment (now gone) from made it into Percona Toolkit 🙂

    September 7, 2011 at 12:44 pm
  • Henrik Ingo Reply

    Hi Baron

    Could you elaborate on the relationship between this and Aspersa/Maatkit? Earlier you announced percona-toolkit as a fork of the two upstream projects (adding that you were excited about it). From my point of view Maatkit and Aspersa were yours and Daniel’s projects anyway, so at most I see it as a re-branding.

    Or is this a distribution of tools that could potentially include also something else than Aspersa and Maatkit? Does it mean you would work on those projects as upstream and the function of Percona Toolkit is just to provide a selection you recommend in a convenient package? I see you’ve renamed the command line tools, so maybe no?

    If this is a fork, should anyone expect Maatkit and Aspersa to live on a separate life?

    September 7, 2011 at 11:44 pm
  • Tim Chadwick Reply


    This is excellent news. Congratulations and many thanks. As we move our installations over to Percona, being confident in our toolset will help us reach our goals. My take on the timeline for Maatkit and Aspersa was that they should work with Percona just like they would the MySQL distribution, however having it served here only adds confidence in our choice MySQL branch.

    Thanks again, the Debian package is particularly appreciated.

    September 8, 2011 at 5:22 am
  • Baron Schwartz Reply

    Thanks for all the comments.

    We will add it to the repositories; I thought it was there already, actually, but I’m not that smart about repositories. I’ll ask the RelEng team to take care of that.

    Most of the Maatkit + Aspersa tools are here, but we omitted ones that were solutions in search of a problem, or turned out not to be a good fit (e.g. mk-loadavg), or ones that aren’t really helpful to us in our work with customers. In our next release we’ll also remove stuff from tools that isn’t relevant. For example, it’s nice that mk-query-digest can parse Postgres log files, but we want to make pt-query-digest simpler, and yanking out that code will help.

    pt-online-schema-change hasn’t been extensively tested in the real world and I am not confident in it myself, because I haven’t used it personally. But it seems important enough that we included it, even though its production/beta/incubation status is a bit gray-zone.

    I don’t intend to do any further upstream work on Maatkit or Aspersa, and I’ve updated their websites to say so. The feature request and bug lists on those tools is just so huge that it’s unmanageable, so I expect that some people will be unhappy that no one is going to fix bugs in features that we’ll remove entirely in the PT tools, for example. But that is life. We can’t focus in two places at once, and this fork-and-go approach is actually trying to solve that problem by providing one clear focus and priority for development.

    September 8, 2011 at 7:30 am
  • Rachid Reply

    Awesome thanks Baron and Daniel.

    The pt-checksum-filter is missing


    September 8, 2011 at 8:30 am
  • Baron Schwartz Reply

    Rachid, that tool is excluded intentionally. pt-table-checksum is going to be rewritten completely and there will be no purpose for a helper application like that.

    September 8, 2011 at 12:27 pm
  • Michael Mior Reply

    Loving the toolset so far. It’s already been quite helpful to me this week. Great work as usual 🙂 A small thing, but I love that the tools are available at Huge timesaver when you end up troubleshooting on foreign servers.

    September 9, 2011 at 2:46 pm
  • dlo Reply

    I’d think you should remove pt-table-checksum *after* it’s obsolete, not before, eh? 🙂 To save other people the trouble, here’s a link directly into the old code base for the file, which worked for what I needed:

    October 12, 2011 at 11:34 am
  • dlo Reply

    Oops, I meant “you should remove pt-checksum-filter *after* it’s obsolete”

    October 12, 2011 at 11:37 am
  • Baron Schwartz Reply

    It’s much simpler than that:

    October 12, 2011 at 7:18 pm

Leave a Reply