Why is innodb_dedicated_server set to OFF on the managed databases?

Posted November 20, 2019 1.1k views

I’ve created a 2gb and 4gb managed database for testing, both on mysql 8.0.17
The 2gb had a default innodbbufferpoolsize of 128 mb
The 4gd had a default innodb
bufferpoolsize of 1536 mb

Both seem a bit on the low end to me, especially on the 2gb instance.
On both servers, the setting “innodbdedicatedserver” 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

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

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!