Subscribe to the
Percona Newsletter

Subscribe Now!
  Wednesday, April 3, 2013    Stephane Combaudon

Percona Toolkit is a must-have set of tools that can help serious MySQL administrators perform tasks that are common but difficult to do manually. Years of deployments by tens of thousands of users including some of the best-known Internet sites, have proven the reliability of the Percona Toolkit tools for MySQL.

In this presentation, you will learn how you can use some of these tools to solve typical, real-world MySQL database administration challenges, such as:

·         Selecting which queries you should try to optimize to get better response times

·         How to efficiently purge data from a huge table without putting too much load on your server

·         How to check which tables are affected when someone accidentally wrote to a replica and fix the problem without rebuilding the tables

·         How to gather data for performance problems that happen randomly and last only a few seconds

·         How to run ALTER TABLE on your largest tables without downtime

Join Stephane Combaudon as he demonstrates how to use Percona Toolkit's pt-query digest, pt-archiver, pt-table-checksum, pt-stalk, and pt-online-schema-change to address these MySQL challenges and more in all MySQL platforms including MySQL 5.6. 

About the Author

Stephane Combaudon

Stéphane joined Percona in July 2012, after working as a MySQL DBA for leading French companies. In real life, he lives in Paris with his wife and their twin daughters. When not in front of a computer or not spending time with his family, he likes playing chess and hiking.