To access a recording of this webinar, visit: http://www.percona.com/webinars/5-percona-toolkit-tools-mysql-could-save-your-day.
Percona Toolkit is a must-have set of tools that can help serious MySQL administrators perform tasks that are common but difficult t.o do manually. Over 4,000 tests and several years of deployment, including some of the Internet's best-known sites, have proven the reliability of the tools in Percona Toolkit for MySQL. In this presentation, you will learn how you can use some of these tools to solve typical real-world database administration challenges, such as: Which queries should you try to optimize to get better response times? How can you efficiently purge data from a huge table without putting too much load on your server? When someone has accidentally written to a replica, how can you check which tables are affected and fix problems without rebuilding it? How can you gather data for performance problems that happen randomly and last only a few seconds? How can you 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 problems and more.