How to edit MySQL system variables in Managed Database

Posted July 28, 2020 1.3k views
DigitalOcean Managed MySQL Database


I was looking into how I could change the behavior of AUTOINCREMENT in our database, specifically innodbautoinclockmode from 2 to 0. I cannot any way to make this change, does anyone know how I can apply this change to my cluster/database? Help is much appreciated!

1 comment

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 there

I understand you want to change the variable innodbautoinclock_mode from 2 to 0 for managed database. Unfortunately, we do not currently support that configuration change as there are some implications(mentioned in below link) which needs to analyse first before implementing this change.

But we have created a feature request ticket in our backlog for our engineering team to add it and you will be informed with any updates.

Please let us know if you have additional questions/concerns.

DigitalOcean Support