but it will stop incrementing the datafile
On Tue, Feb 26, 2013 at 12:40 PM, Platonides <Platonides(a)gmail.com> wrote:
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.
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l