Comment 1 for bug 1425528

Revision history for this message
Mario Splivalo (mariosplivalo) wrote :

Configuring innodb_buffer_pool_size based on the dataset size is pointless - the automatic configuration should relay on the available amount of RAM. (Otherwise you could say your dataset would be 100GB, and you're deploying on 32GB machine, which would make mysql use more RAM than there is available).

So, a proper way to calculate innodb_buffer_pool_size would be in the percentage of the RAM you have available on the box.