survey of percona toolkit - command-line tools for mysql
DESCRIPTION
The presentation provides you with a brief ovreview of all the essential Command-line tools used for MySQL. Percona provides an in-depth review of your database and recommends appropriate changes by performing a complete MySQL health check in which we identify inefficiencies, find problems before they occur, and ensure that your MySQL database is in the best condition.TRANSCRIPT
Survey of Percona Toolkit - Command-line Tools for MySQL
Daniel Nichter - June 17, 2013
Overview
• What is Percona Toolkit?• Survey of 9 tools• Summary
Company Confidential December 2010
-2-
Overview
• What is Percona Toolkit?• Survey of 9 tools• Summary
Company Confidential December 2010
-3-
What is Percona Toolkit?
• Collection of command-line tools for MySQL, Percona Server, and MariaDB– For a wide range of MySQL DBA tasks
• Professionally developed, supported, and maintained by Percona
• 5 years mature, thousands of tests, 20 testing environments, 2 full-time developers
• Free, open-source percona.com/software/percona-toolkit
Company Confidential December 2010
-4-
Overview
• What is Percona Toolkit?• Survey of 9 tools• Summary
Company Confidential December 2010
-5-
pt-archiver (1)
• “Archive rows from a MySQL table into another table or a file”– Remove useless data, safely and slowly
• Benefits:– Faster queries
– Easier backups
Company Confidential December 2010
-6-
pt-duplicate-key-checker (2)
• “Find duplicate indexes and foreign keys on MySQL tables”– Remove useless indexes, safely
• Benefits:– Simpler tables
– Faster INSERTs
Company Confidential December 2010
-7-
pt-mysql-summary (3)
• “Summarize MySQL information nicely”– MySQL tricorder
• Benefits:– Easily learn about a MySQL server
Company Confidential December 2010
-8-
I detect high levels of awesome.
pt-mysql-summary (3)
• “Summarize MySQL information nicely”– MySQL tricorder
• Benefits:– Easily learn about a MySQL server
Company Confidential December 2010
-10-
pt-summary (4)
• “Summarize system information nicely”– System tricorder
• Benefits:– Easily learn about a system
Company Confidential December 2010
-11-
pt-online-schema-change (5)
• “ALTER tables without locking them”– Hot online ALTER TABLE
• Benefits:– Zero downtime
– Low impact
– Tries and retries
Company Confidential December 2010
-12-
pt-query-digest (6)
• “Analyze MySQL queries from logs, processlist, and tcpdump”– Find slow queries
• Benefits:– #1 performance optimization task: find and fix slow
queries
– Track and review queries
Company Confidential December 2010
-13-
pt-stalk (7)
• “Collect forensic data about MySQL when problems occur”– Postmortem analysis of MySQL problem
• Benefits:– Never sleeps, so you can
– Collects a lot of vital data
Company Confidential December 2010
-14-
A warrior always verifies replication integrity
pt-table-checksum (8)
• “Verify MySQL replication integrity”– Find slaves with incorrect data
• Benefits:– Important knowledge for very little effort
– Knowing a problem exists is the first step towards fixing it
Company Confidential December 2010
-16-
pt-table-sync (9)
• “Synchronize MySQL table data efficiently”– Fix slaves with incorrect data
• Benefits: – Easily fix problems found by pt-table-checksum
Company Confidential December 2010
-17-
Overview
• What is Percona Toolkit?• Survey of 9 tools• Summary
Company Confidential December 2010
-18-
Summary
1. pt-archiver: Remove useless data
2. pt-duplicate-key-checkers: Remove useless indexes
3. pt-mysql-summary: Learn about a MySQL server
4. pt-summary: Learn about a system
5. pt-online-schema-change: Hot online ALTER TABLE
6. pt-query-digest: Find slow queries
7. pt-stalk: Collect vital data for postmortem analysis
8. pt-table-checksum: Find slaves with incorrect data
9. pt-table-sync: Fix slaves with incorrect data
Company Confidential December 2010
-19-
Thank You
percona.com/software/percona-toolkit
launchpad.net/percona-toolkit
Company Confidential December 2010
-20-