INNODB buffer pool stats


One of my mysql db’s innodb buffer size always 100%

How do we reduce it

InnoDB will always use 100% of the buffer pool. That is how caching works. What are you expecting? If you set buffer pool = 50GB, then InnoDB will always fill that up to 100% as part of normal operation.

1 Like

Hi Matthewb,

Thanks for replying,
How do we reduce the 100% .


1 Like

I don’t understand what you are asking. InnoDB’s buffer pool is a cache. It is supposed to be 100% all the time, filled with cached data. That’s the purpose. I don’t understand why you want to reduce it?

1 Like