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


mysqltuner is a tool that helps you quickly analyze a running MariaDB instance and gives you basic information to optimize it. Take care about the suggestions; the tool doesn't really know what you're doing with your application. However, it's generally a good way to start the first analysis.

The current Debian version (available in the default Debian repository) is unfortunately not yet MariaDB 10 compatible. That's why you should take the latest version, which is partially MariaDB 10 compatible, for the moment (version 1.3.0). To install it, run the following commands:

> wget -O /usr/bin/mysqltuner
> chmod 755 /usr/bin/mysqltuner

Now, you can launch it and see the recommendations made by the tool. Run the following commands:

> mysqltuner
 >>  MySQLTuner 1.3.0 - Major Hayden <[email protected]>
 >>  Bug reports, feature requests, and downloads at