Tag - innodb_buffer_pool_size

Using Cgroups to Limit MySQL and MongoDB memory usage

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I […]

Read more

innodb_buffer_pool_size – Is 80% of RAM the right amount?

innodb_buffer_pool_size

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? […]

Read more