Survey of Percona Toolkit: Command-line Tools for MySQL

Short Form


Percona Toolkit is a collection of more then 30 command-line tools for MySQL that automate a variety of MySQL and system tasks. If you use MySQL and haven't tried Percona Toolkit, come learn about some free, widely-used and mature tools that could make your job a lot easier.


Percona Toolkit is a collection of more then 30 command-line tools for MySQL that automate a variety of MySQL and system tasks. With so many choices, it can be difficult knowing where to start: is pt-archiver safe? what is the relationship between pt-table-checksum and pt-table-sync? how does pt-online-schema-change work? etc.

This session will survey 9 of the most popular tools in Percona Toolkit: pt-archiver, pt-duplicate-key-checker, pt-mysql-summary, pt-online-schema-change, pt-query-digest, pt-stalk, pt-summary, pt-table-checksum, and pt-table-sync. The main purpose of each of these tools will be explained and briefly demonstrated.

If you have never heard of Percona Toolkit, or if you have but are still new to it, this session will provide you with a starting point from which you can learn more about the particular tools that spark your interest.

Speaking experience

I am the lead developer of Percona Toolkit, and I have been developing MySQL tools for nearly 10 years. I am presenting this talk about the MySQL Conference & Expo 2013.


  • Daniel Nichter

    Test Noir


    Daniel Nichter is the founder and creator of Test Noir, the web service that simplifies multi-environment software testing by centralizing, organizing, and analyzing your test results. He’s also the lead MySQL tools developer Percona, the oldest and largest independent MySQL consulting company. Daniel has been programming and developing with Perl and MySQL for 10 years.


      • Title: Quick Cure for the Shame of Untested Software
      • Track: Cooking
      • Room: B301
      • Time: 4:455:30pm
      • Excerpt:

        As the founder of a company focused on software testing, I speak often to developers who admit in private: “Yes, testing is important… but we don’t test.” Reasons vary, but the basic problem is that testing is seen as too difficult and time-consuming with no apparent value for the effort. In this talk I hope to convince you that this problem is a false dilemma and show you how to get started testing software quickly and easily.

      • Speakers: Daniel Nichter
      • Title: Pro Bash Development; Way Beyond Shell Scripting
      • Track: Hacks
      • Room: B302/303
      • Time: 2:303:15pm
      • Excerpt:

        All Unix/Linux users know a little shell scripting, even if they’re unaware of it. Pipes, for example, are a part of the Bash/sh language. Bash/sh, i.e. shell scripting, is usually treated as just that: shell scripting. But if you’re crazy enough, you can develop full-blown profession, modular, and tested (yes, tested!) programs in Bash. It takes a little finesse, but I’ll show you how, and you just might think twice about using Bash—really using it—in the future.

      • Speakers: Daniel Nichter