Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have a table that is a read-only table (real-time view), I used Aria based on the recommendation for read-heavy workload.
Based on this What are the main differences between InnoDB and MyISAM?
When it comes to cache is Aria like MyISAM or like InnoDB? meaning, Can I cache only indexes or can I also cache the data? (under the assumption I have large enough RAM)
As for now
We plan to also add CACHE INDEX for Aria tables if there is a need for this.
And as you can see that it is written in https://mariadb.com/kb/en/cache-index/ so that it would be more like the MyISAM, but as development and theory grows in time, we will see and wait, what they actually want to do qand implement.
The syntax of CACHE INDEX enables you to specify that only particular indexes from a table should be assigned to the cache.they are not equal
As I stated in my answer to What are the main differences between InnoDB and MyISAM?, MyISAM only cache indexes. There is only one setting for the global key cache. It is called key_buffer_size. MyISAM also features the use of dedicated key caches (I have many posts on this).
I see you are inquiring about MariaDB's Aria storage engine. There is a global key buffer for Aria but its option for the key cache is called aria_pagecache_buffer_size. Documentation here says
The size of the buffer used for index blocks for Aria tables. Increase this to get better index handling (for all reads and multiple writes) to as much as you can afford.
I don't know if Aria has dedicated key caches. I will leave that as homework for you.
