Content deleted Content added
Line 27:
It differs from the other MySQL analytical engine [[MyISAM]] by being a row level locking engine and by the fact that it keeps a constant version snapshot throughout a single query (making it [[MVCC]]). This means that Archive will not lock for concurrent bulk inserts. For bulk inserts it performs an interlaced INSERT, so unlike MyISAM order is not guaranteed.
The tool archive_reader is provided that allows for a user to take an online snapshot of a table. It can also be used to change the characteristics of an archive file.
To create an Archive table, one has to specify the engine string:
| |||