What can be done after mass deleting is to purge the archive database table which should reduce the database size significantly. If you take a look at the the example where I cleaned up an existing site I reduced the database size by about 90%
On Fri, Aug 24, 2012 at 11:47 AM, Yury Katkov katkov.juriy@gmail.com wrote:
Hi everyone! I agree with everyone in this thread, but the main problem is that even if I create a bot of use extensions that removes pages, the actual database records won't be deleted. If I understand correctly, the MediaWiki philosophy tells us that we cannot just drop the page or an account from the database - all the deletions means only that we will hide those nasty spam pages.
Consequently after the deletions the size of my database won't shrink to original 100 Mb, it remains around 3Gb which is a problem for hosting.
The proposed solution of exporting all the pages to a brand new wiki solves this problem. Are there any other solutions where the dropping of my old spammed database does not involved?
Yury Katkov
On Fri, Aug 24, 2012 at 4:13 PM, John phoenixoverride@gmail.com wrote:
Given enough facts it would be rather easy for me to write a script that nukes said spam I did something similar on http://manual.fireman.com.br/wiki/Especial:Registro/Betacommand
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