1
vote
AUTO_INCREMENT value is incremented by one after a restart of MariaDB
The only guarantee for AUTO_INCREMENT is that the values will be distinct.
In your example, either "3" or "4" is valid; live with it.
There are numerous cases where ids are "...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
innodb × 2249mysql × 2009
performance × 250
mariadb × 238
myisam × 211
mysql-5.5 × 149
index × 148
mysql-5.7 × 118
mysql-5.6 × 116
locking × 82
optimization × 80
deadlock × 72
backup × 71
mysqldump × 68
replication × 59
mysql-8.0 × 58
database-design × 55
memory × 53
recovery × 53
query-performance × 47
foreign-key × 44
transaction × 44
buffer-pool × 44
percona × 42
amazon-rds × 40