MENU
ARCHIVE
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. Rows are compressed as they are inserted. On retrieval, rows are uncompressed on-the-fly.It supports INSERT and SELECT, but not DELETE, REPLACE, or UPDATE. It does support ORDER BY operations, BLOB columns, and basically all but spatial data types. It uses row-level locking. It supports the AUTO_INCREMENT column attribute.
| Storage Limits | None |
| Transactions | No |
| Locking granularity | Table |
| MVCC | No |
| Geospatial data type support | Yes |
| Geospatial indexing support | No |
| B-tree indexes | No |
| T-tree indexes | No |
| Hash indexes | No |
| Full-text search indexes | No |
| Clustered indexes | No |
| Data caches | No |
| Index caches | No |
| Compressed data | Yes |
| Encrypted data | Yes |
| Cluster database support | No |
| Replication support | Yes |
| Foreign key support | No |
| Backup/ Point-in-time recovery | Yes |
| Query cache support | Yes |
| Update statistics for data dictionary | Yes |