As with the post on innotop, I will only be discussing the installation of Percona Toolkit and will do a more complete set of examples with each utility within the next few weeks. I suppose I should spend a bit of time discussing what exactly is Percona Toolkit. Well the kit consists of many advanced tools for doing common tasks such as verifying data consistency in replicated environments, query log aggregation, summarizing MySQL server settings, locating duplicate indices, table alterations without locking the entire table, and many more. A full list of each tool and what it does can be found on the Percona Toolkit v2.1 Documentation.

Installation

$ wget http://www.percona.com/get/percona-toolkit.tar.gz
$ tar -zxvf percona-toolkit-2.1.3.tar.gz
$ cd percona-toolkit-2.1.3
$ perl Makefile.PL
$ make
$ make install

Published by Anthony Stramer

Technical Product Manager, technologist, Scrum Master and serial problem solver. The rest of the time I'm just another opinionated internet ninja.

Tags: , , , , ,

1 Comment

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.