InnoDB size
Posted by: Sasi Tovi
Date: February 03, 2019 06:48AM

Hi,

I have a MySql RDS service on AWS.
My Innodb_buffer_pool_size is 24G and the machine total RAM is 32G.
When I tuned the memory and I look into the Cloudewatch of AWS, I can see that the innodb buffer pool is taking only half of his memory that dedicated for him (only ~12G instead of 24G).

I understand that the LRU Algorithm remove old pages from the Cache, but is there a way to force hime to use all the memory (load more data and indexes to the cache? but I'm not referring to use MIsam or Memory engine)

IF not, Should I reduce the size of the InnoDb_Bufferpool_size?

extra details:
innodb_buffer_pool_instances = 8
innodb_buffer_pool_chunk_size = 128M

Thanks,
Sasi

Options: ReplyQuote


Subject
Written By
Posted
InnoDB size
February 03, 2019 06:48AM
February 03, 2019 09:40AM
February 04, 2019 02:40AM
February 04, 2019 11:22AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.