(mysql.info.gz) ARCHIVE storage engine

Info Catalog

(mysql.info.gz) FEDERATED storage engine

(mysql.info.gz) Storage engines

(mysql.info.gz) CSV storage engine

 
 14.7 The `ARCHIVE' Storage Engine
 =================================
 
 The `ARCHIVE' storage engine was added in MySQL 4.1.3.  It is used for
 storing large amounts of data without indexes in a very small footprint.
 
 To enable this storage engine, use the `--with-archive-storage-engine'
 option to `configure' when you build MySQL.
 
 When you create an `ARCHIVE' table, the server creates a table
 definition file in the database directory. The file begins with the
 table name and has an `.frm' extension.  The storage engine creates
 other files, all having names beginning with the table name.  The data
 and metadata files have extensions of `.ARZ' and `.ARM'. An `.ARN' file
 may appear during optimization operations.
 
 The `ARCHIVE' engine supports only `INSERT' and `SELECT'.  (No deletes,
 replaces, or updates.)  A `SELECT' performs a complete table scan.
 Records are compressed as they are inserted.  Use of `OPTIMIZE TABLE'
 can analyze the table and pack it into a smaller format.
 
 The `ARCHIVE' engine uses row-level locking.
 

Info Catalog

(mysql.info.gz) FEDERATED storage engine

(mysql.info.gz) Storage engines

(mysql.info.gz) CSV storage engine