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