How to edit MySQL system variables in Managed Database

Posted July 28, 2020
DigitalOcean Managed MySQL Database

Hey!

I was looking into how I could change the behavior of AUTO_INCREMENT in our database, specifically innodb_autoinc_lock_mode 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!

Boohi

Boohi • July 28, 2020

Woops auto formatting. The variable I was looking to change is innodb_autoinc_lock_mode

Submit an answer

You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

Priyanka Malik • July 28, 2020

Hi there

I understand you want to change the variable innodb_autoinc_lock_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.

https://dev.mysql.com/doc/refman/5.7/en/innodb-auto-increment-handling.html

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.

Regards DigitalOcean Support

Join the DigitalOcean Community