innodb_buffer_pool_size – Is 80% of RAM the right amount?

It seems these days if anyone knows anything about tuning InnoDB, it’s that you MUST tune your innodb_buffer_pool_size to 80% of your physical memory. This is such prolific tuning advice, it seems ingrained in many a DBA’s minds. ┬áThe MySQL manual to this day refers to this rule, so who can blame the DBA? ┬áThe … Continue reading innodb_buffer_pool_size – Is 80% of RAM the right amount?