Revision as of 10:32, 19 April 2021 edit NaTRenKO (talk \| contribs) Extended confirmed users 2,819 edits m Updating Infobox (Removing unknown parameter 'status') Tag: 2017 wikitext editor ← Previous edit		Revision as of 18:50, 9 February 2023 edit undo Frap (talk \| contribs) Extended confirmed users, File movers, Pending changes reviewers, Rollbackers 35,593 edits m Add hyphen Next edit →
Line 29: Despite the use of [[zlib]], archive files are not compatible with [[gzio]], the basis of the [[gzip]] tools. It uses its own azio system that is a fork of gzio. 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 [[Multiversion concurrency control\|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. Users can use the archive_reader tool to take an online snapshot of a table and to change the characteristics of an archive file.

MySQL Archive: Difference between revisions