archive differs from the other mysql analytical engine, myisam, by being a row level locking engine and by keeping a constant version snapshot throughout a single query (making it mvcc). this means that archive does not lock for concurrent bulk inserts. for bulk inserts it performs an interlaced insert, so unlike myisam, order is not guaranteed.