MySQL Archive: Difference between revisions

Revision as of 04:14, 10 October 2013

Revision as of 18:46, 19 February 2014

Line 21:

| website = http://mysql.bkbits.com

}}

'''MySQL Archive''' is a storage engine for the [[MySQL]] [[relational database management system]]. Users can use this analytic storage engine to create a table that is “archive” only. Data cannot be deleted from this table, only added. The Archive engine uses a compression strategy based on the [[zlib]] library and it packs the rows using a bit header to represent nulls and removes all whitespace for character type fields. When completed, the row is inserted into the compression buffer and flushed to disk by an explicit flush table, a read, or the closing of the table.

Line 43 ⟶ 44:

The MySQL Archive Storage Engine was authored and is maintained by [[Brian Aker]]. It was introduced in 2004 with MySQL 4.1.

==References==

{{Reflist}}

== External links ==

* [http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html MySQL Documentation on Archive Storage Engine]

== External links ==

* [http://dev.mysql.com/doc/refman/5.1/en/archive-storage-engine.html MySQL Documentation on Archive Storage Engine]

{{database-software-stub}}

{{MySQL}}

Line 56 ⟶ 55:

[[Category:Database engines]]

[[Category:MySQL]]

{{database-software-stub}}