By Ozcar
I’ve created a 2gb and 4gb managed database for testing, both on mysql 8.0.17 The 2gb had a default innodb_buffer_pool_size of 128 mb The 4gd had a default innodb_buffer_pool_size of 1536 mb
Both seem a bit on the low end to me, especially on the 2gb instance. On both servers, the setting “innodb_dedicated_server” was set to OFF, which when set to ON would autoscale the buffer pool size and the log file size based on system available memory.
I’d love to get a better understanding of the chosen default settings
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Hey @Ozcar -
This is a really good question.
As noted, the “innodbdedicatedserver” setting means “let mysql autoscale memory usage”. In order to offer databases as a managed service, we have services that enable features like automatic backup, high availability, and metrics collection running in the underlying infrastructure. We have prevented MySQL from allocating memory to itself in order to ensure that all complementary services have the resources required to run.
Hope this helps!
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.