Tagged Questions
2
votes
1answer
94 views
Why is InnoDB auto_increment column skipping over large blocks of unused values?
We have an active and important InnoDB table with about 8M rows. We just noticed that for several months, the primary key value (a BIGINT) has been jumping by hundreds at a time.
I turned on query ...
3
votes
1answer
375 views
Getting duplicate primary key for auto increment coloumn
I have a MySQL Innodb table with 'id' as auto increment primary key coloumn.
My Scripts are doing following operations:
insert ignore into tablename set x='a', y='b'
update ignore tablename set ...
