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.
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 ...