I have a mediawiki installation with 731 content pages and only a single user (there are no talk pages used, for example).
Given each page of text can only be in the order of up to 50kb at most, I cannot understand why the size of my “text” table shows as 116 MiB in phpMyAdmin??
I understand that the large size of text tables can often be down to the number of old revisions — and it turns out the number of page edits since I began my wiki is indeed 29,697. So I ran all the following scripts, including deleting all the old revisions, and yet the “text” table remains stubbornly at 116 MiB…
- deleteOldRevisions.php --delete
- deleteArchivedRevisions.php --delete
- purgeOldText.php (I realise this is invoked as part of the above scripts but I ran it again just in case — 0 inactive text records were found, just as expected)
- php refreshLinks.php --dfn-only
- rebuildall.php (this massively reduced size of the “searchindex” and “revision” tables)
Can anyone help? Or does 116 MiB sound about right for a wiki with 731 content pages?
(I did previously have a spam attack from bots when my wiki was first set-up but since then I have deleted all the user accounts and external links they spammed my wiki with)
Thanks