MySQL Forums
Forum List  »  InnoDB

Re: Innodb vs. myisam storage usage *shocked*
Posted by: James Day
Date: February 04, 2005 12:30PM

The MediaWiki software used by Wikipedia and others supports gzip compressed text fields for the encyclopedia article old versions. That reduces their size from on disk 80GB to 40GB for the English encyclopedia. The latest version also supports concatenating several versions together. That's expected to reduce the size to about 15GB when the run is complete.

That's a very specific situation but I expect that there are other users who are already using compression, so if it is not already in your plans you might want to consider how it may be possible to tell InnoDB on a per table or per column level that compression will be unnecessary work.

Options: ReplyQuote

Written By
February 02, 2005 10:26AM
Re: Innodb vs. myisam storage usage *shocked*
February 04, 2005 12:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.