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.
Subject
Views
Written By
Posted
11043
February 02, 2005 10:26AM
5819
February 03, 2005 09:04PM
4346
February 04, 2005 07:49AM
3568
February 04, 2005 12:22PM
4170
February 04, 2005 11:57AM
Re: Innodb vs. myisam storage usage *shocked*
4665
February 04, 2005 12:30PM
7321
February 05, 2005 02:40AM
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.