I am using a primary key column defined like:
event_order BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
The ids are being auto generated something like this:
1, 2, 3, 30001, 4, 30002, 5, 6
It seems like two different number sequences are being interleaved. I would have expected the ids to be generated in numerical order like 1, 2, 3, 4, 5, 6, 7, 8. Is there any explanation for this? Is the database somehow pulling from two different sequences in the database? It seems like this would have a potential for a collision. Also, it makes it impossible for me to order the rows by id, because the id does not reflect the insertion order.