How much memory using for adaptive hash indexes in MariaDB?

Question

I'm reading about adaptive hash indexes 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. However here is no explanation about what means a specific partition and what is size of it?

Answer 1

The main cache in RAM is innodb_buffer_pool. On a tiny 2GB machine, that should be limited to maybe 500M. And some other settings should be lowered, not raised.

It is probably best to let the engine decide how much to allocate for it.

And I doubt seriously that changing the default setting (8) for innodb_adaptive_hash_index_parts will matter much.

MariaDB shows Innodb_mem_adaptive_hash in the BUFFER POOL AND MEMORY section of the SHOW ENGINE INNODB STATUS; output. Also in SHOW GLOBAL STATUS;