CODEWITHSUNDEEP
mysqlmediawiki
Jim
Jim

Reputation: 851

How to reduce the size of a MediaWiki 'text' table

I administer a small MediaWiki wiki that has recently been subject to quite a lot of spam. I've deleted all of the spam accounts and pages and, thanks to the help provided at How to permanently delete a page from a MediaWiki wiki?, I've been able to clear out the 'archive' table in the wiki's database so that it's not full of all of the spam pages that I've deleted.

The database is still huge, though, relative to the actual size of the wiki. The 'text' table is running in at 2.7GB, and the 'searchindex' table is a sizeable 302.9MB. What's the best way to go about reducing the size of these tables, particularly the 'text' table? I'd be open to the idea of exporting all of the public-facing parts of the wiki and importing them into a clean install, if this is necessary.

Upvotes: 3

Views: 961

Answers (2)

Nemo
Nemo

Reputation: 2544

Just run php maintenance/deleteArchivedRevisions.php --delete.

Upvotes: 1

Jim
Jim

Reputation: 851

I solved this (practically, at least) by optimizing the offending table. This reduced its size to between 200 and 300 MB. This still seems large, considering the amount of data present in the wiki, but at least it's manageable.

Upvotes: 0

Related Questions