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 ...Get MariaDB High Performance now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
