Hi, i am using the newest portable version of HeidiSQL (11.3) with a mariaDB, also relatively new (10.6). When a table holds no rows, i cannot set an Auto increment value. Everytime i save it it reverts to an empty field. Furthermore if i create rows, it lets me set and autoincrementing value, but always changes it by itself. creating a new row causes the primary key to be auto incremented by 3. Viewing the auto increment option also show the nex value instead of the amount the value should be incremented by.
Autoincrementing primary Key
WOW i connected to my 2 node cluster and now autoincrement always increments by 2! So somehow the cluster size affects the autoincrementing value. Is that expected/by-design or unwanted? BTW if you want to reproduce that i can make you a user account on my clusters, the are globally reachable.
I suspect your cluster nodes have a non-1 setting for
Here's an explanation why that's a good idea.
Please login to leave a reply, or register at first.