MySQL Forums
Forum List  »  InnoDB

how to change innodb_autoinc_lock_mode = 0
Posted by: matthew Baynham
Date: April 09, 2021 02:32AM

I need to change innodb_autoinc_lock_mode to 0 because my auto incrementing is skipping values.

I cannot find any .cnf file that sets the innodb_autoinc_lock_mode value. The only .cnf files I can find are relatively empty.

I've tried restarting the server with the flag --innodb_autoinc_lock_mode = 0 but that doesn't do anything.

I'm completely clue less, how do I set my innodb_autoinc_lock_mode value?

Options: ReplyQuote


Subject
Views
Written By
Posted
how to change innodb_autoinc_lock_mode = 0
92
April 09, 2021 02:32AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.