Mastering MariaDB

Summary

In this chapter, we discussed the main MariaDB buffers. The most important ones are the caches used by the storage engine. We dedicated much space to the InnoDB buffer pool, because it is more complex and, usually, InnoDB is the most used storage engine. Also, while the InnoDB buffer pool caches both data and indexes, MyISAM and Aria only cache indexes.

The query cache is sometimes a useful solution, because it allows us to instantly return the results of a query. Similarly, the subquery cache is used to instantly return the results of a subquery. However, on a typical OLTP workload, data is invalidated too often for these caches to be useful. We have learned when this cache is useful and when it is not even though usually a DBA should ...