0

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)

Bill Karwin
  • 16,963
  • 3
  • 31
  • 45
Ido Shilon
  • 101
  • 1

2 Answers2

0

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.

nbk
  • 8,699
  • 6
  • 14
  • 27
0

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.

RolandoMySQLDBA
  • 185,223
  • 33
  • 326
  • 536