>From here: http://dev.mysql.com/doc/refman/5.0/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT<http://dev.mysql.com/doc/refman/5.0/en/insert.html> and SELECT <http://dev.mysql.com/doc/refman/5.0/en/select.html>, but not DELETE <http://dev.mysql.com/doc/refman/5.0/en/delete.html>, REPLACE<http://dev.mysql.com/doc/refman/5.0/en/replace.html>, or UPDATE <http://dev.mysql.com/doc/refman/5.0/en/update.html>. It does support ORDER BY operations, BLOB<http://dev.mysql.com/doc/refman/5.0/en/blob.html> columns, and basically all but spatial data types (see Section 12.16.4.1, “MySQL Spatial Data Types”<http://dev.mysql.com/doc/refman/5.0/en/mysql-spatial-datatypes.html>). The ARCHIVE engine uses row-level locking. *Storage:* Rows are compressed as they are inserted. The ARCHIVE engine uses zlib lossless data compression (see http://www.zlib.net/). You can use OPTIMIZE TABLE <http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html> to analyze the table and pack it into a smaller format (for a reason to use OPTIMIZE TABLE <http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html>, see later in this section). Beginning with MySQL 5.0.15, the engine also supports CHECK TABLE<http://dev.mysql.com/doc/refman/5.0/en/check-table.html>. There are several types of insertions that are used: You tell my why a customer who wants to place AUDIT information in a table might want that? Keith Murphy http://www.paragon-cs.com -- (c) 850-637-3877 On Tue, Sep 17, 2013 at 10:19 AM, Wayne Leutwyler <wleut...@columbus.rr.com>wrote: > Hello List, > > I have a customer who is wanting to use the Archive Engine. I have no > experience with this engine, other than what I am been reading. Why would I > want to use Archive over InnoDB. They are only going to be placing audit > information in the table. > > Walter "Wayne" Leutwyler, RHCT > Sr. MySQL Database Administrator > Mobile: 614 519 5672 > Office: 614 889 4956 > E-mail: wayne.leutwy...@gmail.com > E-mail: wleut...@columbus.rr.com > Website: http://penguin-workshop.dyndns.org > > "Courage is being scared to death, but saddling up anyway." --John Wayne > >
