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.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License