how to change innodb_autoinc_lock_mode = 0
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?
Subject
Views
Written By
Posted
how to change innodb_autoinc_lock_mode = 0
1697
April 09, 2021 02:32AM
772
April 09, 2021 10:34AM
633
April 09, 2021 10:51AM
597
April 14, 2021 10:45AM
Sorry, you can't reply to this topic. It has been closed.
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.