Is it safe to assume that auto_increment is atomic during select operations?
example, If I insert 1000 rows instantly (hypothetically), okay, I know that auto_increment will increment one by one. but can I be sure that ALL select operations during, before, after this insert will always show auto_increment (10) before auto_increment (20) ?
Like for some arbitrary optimization reason, even though a row with auto_increment (1) exists, the select operation will get 1,2,3..9,11,20
before a millisecond later 1,2,3,9,10,11,20 ?
Or will this never occur?