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