I've got 256GB RAM. InnoDB pool buffer size is 128GB, and InnoDB data + indexes in all databases are about 105GB. Most of that data is frequently queried so, correct me if I am wrong, it should reside in buffer_pool?
I thought that innodb_buffer_pool resides in RAM, but top
command shows:
MiB Mem : 257873.0 total, 747.0 free, 74239.4 used, 182886.6 buff/cache
Most of users complain about high RAM usage, and in my case it seems that MariaDB is not using all the RAM it should?
ulimit -v
says 'unlimited'.
Is that ok? Can I force putting entire innodb_buffer_pool in RAM, and if so, then how?