Question

Change innodb_buffer_pool_size in a managed database cluster?

Posted September 20, 2021 86 views
MySQLDigitalOceanDatabases

How can I change innodbbufferpool_size in a managed database cluster since all users in a cluster don’t have the privileges to that and you can’t access the cluster as root? Thank you!

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

Hi @gilie,

The innodbbufferpool_size variable is currently set dynamically depending on plan size. Setting it to custom value is not supported.

Regards,
Rajkishore