[Mediawiki-l] Conserving Storage Space and Removing History

[Brion Vibber]

AlphabetDP at aol.com wrote:
> It never occurred 
> to us that 'wikipedia' was storing full copies of all versions of an 
> article based on the 590MB May 22, 2004 number and considering the high 
> number of articles the db had. We must have been reading the wrong 
> statistics.

That sounds like the table of current revisions. The old revisions table 
  for en.wikipedia.org is over 10GB.

> Do the 'wikipedia' administrators remove history from their wiki in 
> order to preserve space? If so, how is this done? Is there some sort of 
> 'export only the lastest version of each article, etc.' option, clear 
> the db, and then import the lastest version back?

No.

> Our administrator has set the "$wgCompressRevisions = true;" since your 
> message (above) -- will that take care of only the revisions since the 
> flag was turned on or will there be compression of the previous 
> revisions as well?

That only affects newly saved revisions. There is a 'compressOld.php' 
script in the maintenance directory which will go through and get the rest.

-- brion vibber (brion @ pobox.com)
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 253 bytes
Desc: OpenPGP digital signature
Url : http://lists.wikimedia.org/pipermail/mediawiki-l/attachments/20040625/bced4d47/attachment.pgp