Book Image

Mastering MariaDB

By : Federico Razzoli
Book Image

Mastering MariaDB

By: Federico Razzoli

Overview of this book

Table of Contents (19 chapters)
Mastering MariaDB
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Aria page cache


Aria caches the index pages in a data structure called the page cache. It is very similar to the MyISAM key cache but has fewer features.

Note

All the ideas behind the page cache and the key cache will not be explained in this section, so the reader needs to read the previous section first.

This section explains the differences between the two data structures and how to use the page cache.

Similar to MyISAM, Aria indexes are organized in blocks. The size of the blocks is determined by the aria_block_size server variable. This variable affects both the index files and the page cache, because all blocks must have the same size. If this variable is changed, all Aria tables need to be recreated. The steps to change this value are as follows:

  1. Dump existing Aria tables (as explained in Chapter 8, Backup and Disaster Recovery).

  2. Stop the server.

  3. Set the new value in the configuration file.

  4. Restart the server.

  5. Drop or empty all Aria tables.

  6. Restore the dumped data.

The Aria page cache always...