Description of problem: It seems recently when we create new bug report, bug number seems to increase by 10, not one? Example A: bug 380081 and bug 380091 . Bug reports says that I created the latter bug 0 seconds after the former... Example B. I checked bug 400001 - 400011 and bug 400002 through 400010 does not exist, however 400011 exists. Additional info: Around bug 200000, bug number seems to increase by one.
With our new move to a replicated MySQL server environment, we had to change the increment value to 20. This allows future growth when dealing with master to master server replication. So this would explain what you are seeing. This link explains some of the reason it must be configured this way. http://www.onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html It is also well documented in the MySQL documentation but I can't find the link at the moment. We plan to have multiple masters spread around geographically in the future. The gaps you have in your primary keys determine how many masters you can have so currently this would limit us to 10. We used to have this set to 20 and since lowered it to 10.