September 2014
Intermediate to advanced
298 pages
6h 13m
English
Content preview from MariaDB High PerformanceBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...