On 26/02/13 11:57, Petr Bena wrote:
Hi, this is more related to mediawiki rather than wikimedia, but this list is being watched a bit more I guess.
Is there any extension that allows permanent removal of deleted pages (or eventually selected deleted pages) from database and removal of blocked users from database?
Imagine you have a mediawiki wiki that has 20 gb database, where 19.99gb of database is spam and indefinitely blocked users. I think lot of wikis has this problem, making extension to deal with this would be useful for many small wikis.
What is exact procedure of properly removing page from database so that it doesn't break anything? What needs to be deleted and in which order?
maintenance/deleteArchivedRevisions.php permanently removes the content of deleted pages from the db.
For removing those users, see http://www.mediawiki.org/wiki/Extension:User_Merge_and_Delete
Also remember that due to the way mysql works, it may not release those 20GB back to the filesystem.