How much memory using for adaptive hash indexes in MariaDB?
0
votes
1
answer
344
views
I'm reading about [
adaptive hash indexes
](https://dev.mysql.com/doc/refman/5.7/en/innodb-adaptive-hash.html) in MariaDB. It is created in memory, so it will be logically to know how much memory usually used for the index table.
For example, my local development database has only 2GB of RAM. Is it possible theoretically that adaptive index table will use > 50% of total memory?
I tried to search how much memory is usually used for AHI. But here is no info in the internet about memory and how to limit it. The only info I found is [innodb-adaptive-hash-index-parts
](https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_adaptive_hash_index_parts) . However here is no explanation about what means a specific partition
and what is size of it?
Asked by rzlvmp
(111 rep)
Jul 26, 2023, 01:04 AM
Last activity: May 23, 2025, 12:01 AM
Last activity: May 23, 2025, 12:01 AM