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
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Optimizing storage engines


In this section, you will learn how to get maximum benefit from using the storage engines. They are all working differently and all have different kinds of optimizations.

Entering each engine and seeing all the advanced features really goes beyond the scope of this book. So, here we will see the most common engines optimizations that can enhance performance. In addition, as some MariaDB engines are still not fully implemented, we'll cover the most used engines that you generally have in production.

Summarizing your databases

To get your database, index, and table sizes, run the following command:

MariaDB [(none)]> SELECT TABLE_SCHEMA,ENGINE,SUM(TABLE_ROWS),SUM(DATA_LENGTH),SUM(INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES GROUP BY ENGINE,TABLE_SCHEMA ORDER BY TABLE_SCHEMA;

The output of this command is shown in the following screenshot:

As you can see here, we've got a lot of different engines and interesting information:

  • SUM(DATA_LENGTH): Data size without indexes...