INNODB buffer pool stats

General Questions
1

Hi,

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

How do we reduce it

2

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
3

Hi Matthewb,

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

Regards,
Viraj

1 Like
4

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