Book Image

MariaDB High Performance

By : Pierre Mavro
Book Image

MariaDB High Performance

By: Pierre Mavro

Overview of this book

Table of Contents (18 chapters)
MariaDB High Performance
About the Author
About the Reviewers

Percona Toolkits

Percona Toolkits is a suite of tools for MySQL and MariaDB. They are very useful in many situations and well documented (the main website is To install them, you can add the repository:

> aptitude install python-software-properties
> apt-key adv --keyserver --recv-keys 1C4CBDCDCD2EFD2A
> add-apt-repository 'deb wheezy main'

Then, configure APT-Pining to avoid the Percona repository overriding MariaDB's repository and conflict some packages. So, create this file at /etc/apt/preferences.d/00percona.pref and add the following content to it:

Package: *
Pin: release o=Percona Development Team
Pin-Priority: 100

You're now ready for the installation of the package:

> aptitude update
> aptitude install percona-toolkit

That's it! Several binaries starting with pt- are now available on your system.


The pt-query-digest tool will help you analyze the MariaDB slow queries...