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?