Help:Reduce size of the database

From lensowiki

  It may be possible to reduce the size of the database.

Contents 1 Compress old revisions 2 Permanently remove the history of deleted pages 3 Permanently remove old revisions 3.1 < Mediawiki 1.5beta3 3.2 >= Mediawiki 1.5beta3 4 Mediawiki 1.6.7.

Compress old revisions

cd /path/to/wiki/maintenance
php compressOld.php

In MediaWiki 1.2 and 1.3, this will reduce the size of the old table (which is typically the bulk of the database) by about 50%. In MediaWiki 1.4, it will typically reduce the size of the old table by about 85%, but at the expense of making it difficult to delete existing articles.

(Q: "difficult" as in you'll have to do some sql manipulation? or difficult as in computationally expensive?)

Permanently remove the history of deleted pages

To permanently remove the history of deleted pages, first delete the pages using the normal page deletion feature.

Then clear out the archive table, where deleted revisions are stored, at the database level:

DELETE FROM archive;

or (which is sometimes MUCH faster)

TRUNCATE TABLE archive;

Of course, it will then no longer be possible to view and restore deleted pages and their history.

Permanently remove old revisions

< Mediawiki 1.5beta3

To permanently remove the histories of all current pages clear out the old table, where old revisions are stored, at the database level:

DELETE FROM old;

or (which is sometimes MUCH faster)

TRUNCATE TABLE old;

Be absolutely sure you don't want any of your pages' histories, though, as that information will be completely and permanently blown away by this. All prior versions will be gone entirely; they will not appear in 'History', will not appear in 'User contributions', cannot be viewed, diffed, or reverted to.

If you insist on doing this it is very strongly recommended to back up your database first in case you need to reference an older version later (or you just make a mistake!).

You can rebuild the index of recent changes to ensure that old entries no longer appear in Special:Recentchanges.

php rebuildrecentchanges.php

>= Mediawiki 1.5beta3

• How to do it in this case?
  • Currently reported as Bug 3612
    • The "old" table does not exist any more! How is it possible to remove the whole history. This would be very important, since it would reduce the size of the database significantly. Does a SQL query exist for this task?
      • It's not possible and won't be available in future, because "Wikimedia Foundation tends to need to keep all old revisions for various [judicial] reasons, including GFDL issues (Rob Church)". That's a pity, because it costs much money for new servers to keep up this unnecessary service.
        • External storage space is free for Wikimedia. We have many terabytes of apache hard drive space that we have no other use for. -- Tim Starling 02:22, 26 February 2006 (UTC)
    • Yes, but still it must be possible to remove the old version by a sql query or a php script. Has anyone an idea? Thanks!
      • I opened it as Enhancement Request 4748, I would be interested in this feature very much. The only thing you can use for this is Special:Export and Special:Import with setting it to actual version, but you need to specify any article and category you want to export, and after import - in some cases - you need to purge the page. This is a complicated way. --Wissenslogistiker 15:26, 25 January 2006 (UTC)

Looking into providing a script. Rob Church ^Talk 15:23, 25 January 2006 (UTC)

A script is available at the bug entry 4748. Be careful, save your database before testing it ! Zaijian 17:11, 5 February 2006 (UTC)

• There is a better solution even: an official deleteOldRevisions.php in current CVS by mediawiki developer. It reduced size of wiki db from about 60 MB to 15 MB now! I just closed 4748. But saving your database is a good advice here too. Use following to activate it after setting password in adminsettings.php.

php deleteOldRevisions.php --delete

--Wissenslogistiker 23:35, 5 February 2006 (UTC)

Mediawiki 1.6.7.

Use SpecialDeleteOldRevisions.