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

Reply via email to