Saari Development

Ali Rizvi's Technical Blog as a Professional Software Development Engineer

MySQL : Saving a ton of space on old tables

with one comment

Here is a nice article about using MySQL (> 5) archive engine.
The MySQL 5.0 Archive Storage Engine

If you have some tables that has mostly read-only for data retention purposes then you can do something like this to drastically reduce the disk spaced used by that table:

alter table MY_OLD_TABLE drop primary key, engine=archive;

note the archive table does not have primary key and dropping the primary key in this way prevents from rebuilding the table twice (compared to the case where you issue two alter table, one to drop key and second to switch engine.

Advertisements

Written by imsaar

January 10, 2008 at 1:15 am

Posted in mysql

Tagged with , , , ,

One Response

Subscribe to comments with RSS.

  1. Great work, man!

    Arsalan

    January 21, 2008 at 12:51 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: