Register and ask your own question!
combination of log-bin true and innodb_autoinc_lock_mode set to 2 (is default) will skip ID's
I am trying to find how I can avoid skipping ID on entry's.
A few days ago I didn't use the log-bin option: on mysql 5.7 it standard set to off. After I changed this setting in my.cnf the binlog worked, but the result was that very new project I created had a ID which was 3 ID after the former one.
Setting the innodb_autoinc_lock_mode = 1 or 0 is not possible.
We are using the ID as part of an title in our project tool. SO, it's a bit inconvenient.
Any help ?