If you don't care about keeping old revisions and deleted revisions around (or are not obligated to keep revision around due to your wiki license), you should probably run these two scripts every so often:
https://www.mediawiki.org/wiki/Manual:DeleteArchivedRevisions.php https://www.mediawiki.org/wiki/Manual:DeleteOldRevisions.php
This can hammer down the size of your database quite a bit if you have many pages with a lot of revisions.
If you have server access, have deleted pictures, and don't care to retrieve them later, you can always permanently delete those to recover some more space.
If you have a copy of PHPMyAdmin running and you uninstalled some extensions that left some database tables with lots of leftover data you never plan to use, you can delete those to free up some more space, though I'd back up your database before doing so.
Date: Wed, 4 Sep 2013 12:18:13 -0700 From: roger@rogerchrisman.com To: mediawiki-l@lists.wikimedia.org Subject: Re: [MediaWiki-l] Database size ballooning?
Are there any maintenance scripts I should routinely run, maybe once a months?
Roger
MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l