Survey of Percona Toolkit: Command-line Tools for MySQL

Tools
4 December 15:20 - 16:10 @ Sentosa 5-8

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.

Speakers

Bill Karwin
Principal Trainer, Percona, Inc
Speaker Biography: 
Bill Karwin has been a software engineer for over twenty years, developing and supporting applications, libraries, and servers such as Zend Framework for PHP 5, the InterBase relational database, and the Enhydra Java application server. Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems. Bill authored the book "SQL Antipatterns", collecting frequent blunders and showing better solutions.


Slides