We have a dedicated DB box with with 8 GB of RAM and running Redhat linux 64 bit OS. Our MySQL Data + Index size almost 7.8 GB. About setting
innodb_buffer_pool_size, I have read 2 suggestions
- Set it to 80% of RAM available on a dedicated DB server.
- Set at-least 10% above the size of Data + Indexes.
We cannot satisfy the second condition in my case. So will it have negative effect on Database performance?
innodb_buffer_pool_size of like 6GB affect the performance?