MySQL - Storage Engine - ARCHIVE
The ARCHIVE storage engine provides an efficient way to store large amount of data when you don't need indexes and need to minimize the amount of disk space used.
ARCHIVE supports only SELECT and INSERT operations. SELECT scans the entire table, and INSERT performs compressed inserts. (Written records are cached until a read occurs, and then they are compressed and flushed to disk. This is done because you get better compression if you compress several rows at a time rather than individually.)
To analyze and recompress an ARCHIVE table, use OPTIMIZE TABLE statement.
Each ARCHIVE table is represented on disk by an .frm format file, an .ARZ data file, and an .ARM metadata file.
page revision: 0, last edited: 30 Jan 2009 01:10