For each auto-increment column, a globally visible key-value pair is used to record the maximum ID that has been assigned. In a distributed environment, communication between nodes has some overhead.

I have a problem when using Bulk Insert to insert a large number of entities into a MySQL database. After a certain amount of entities have been inserted (in my case over 200) the MySQL database skips ...