[Without knowing the internals...] I believe the order will be random.
In particular, two slaves might differ for identical queries. Why?
Statement based replication requires each slave to independently decide
how and where to insert things. Normally diff slaves would make the
same choice. But, if they are tuned differently, or their caches were
refilled at different times (eg, due to restarting), or someone did an
OPTIMIZE, or ..., the decisions could be different.
> -----Original Message-----
> From: Kathryn Steinbrink [mailto:krs@stripped]
> Sent: Tuesday, April 15, 2008 7:29 AM
> To: internals@stripped
> Cc: bmiezejewski@stripped; matwood@stripped
> Subject: ordering of duplicate keys
> When processing key operations in the presence of duplicates,
> does MySQL
> care about the order of the duplicates? For example, is there
> some kind of
> FIFO or LIFO type ordering of the rows that should be honored when
> returning duplicate keys?
> Kathy Steinbrink
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe: