MySQL: The ARCHIVE Storage Engine, store large amounts of unindexed DATA

MySQL also supported ARCHIVE Storage Engine which is basically used for storing large amounts of unindexed DATA.
It does not support any type of Indexes, Foreign keys, Concurrency Control and Transactions.

The performance of ARCHIVE Storage Engine is excellent for storing and supporting billions of data.
For any RDBMS system, Bulk Insertion and other Bulk Operations are common.
To increase the performance of BULK Operation, DBA can disable the indexes, can remove the constraints, can compress the table.

But this all are the default settings of the MySQL ARCHIVE Storage Engine.
When you create an ARCHIVE table, the server creates a table format 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 file has an extension of .ARZ. And .ARN file may appear during optimization operations.

The ARCHIVE engine also uses zlib lossless data compression, so rows are compressed as they are inserted.
We can use OPTIMIZE TABLE to analyze the table and pack it into a smaller format.

Create a sample table using ARCHIVE Storage Engine:

Insert few sample records:

Check the result:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of