Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question

Question

How to edit MySQL system variables in Managed Database

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

Hey!

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!

Add a comment
Boohi
By:
Boohi

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
WordPress database error: [Expression #1 of ORDER BY clause is not in SELECT list... Question Question
Private connection to Managed DB not working from within same region droplet. Question Question
Add a comment
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
priyankamalik July 28, 2020

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.

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

Reply Report

Related

Looking for something else?

Ask a new question Search for more help