Be aware that by default InnoDB uses a file called ibdata1 to do all of
it's data storage.
When you remove data from the database InnoDB does not shrink ibdata1 down.
So even if you reduce your 3GB database down <1GB and you have room for
2GB of content to be added before ibdata1 grows again.
The actual size on disk that your database takes up will likely remain at
3GB.
So if you really want to reduce on-disk size exporting and re-importing at
least your raw database at some point becomes necessary since InnoDB will
never give you that disk space back.
On Fri, 24 Aug 2012 08:54:26 -0700, Yury Katkov <katkov.juriy(a)gmail.com>
wrote:
http://www.mediawiki.org/wiki/Manual:Reduce_size_of_the_database and
here is the manual on how to purge the archive database! Thanks John,
that's a perfect solution!
-----
Yury Katkov
On Fri, Aug 24, 2012 at 7:51 PM, John <phoenixoverride(a)gmail.com> wrote:
> 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(a)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(a)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(a)lists.wikimedia.org
>>>
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
>>
>> _______________________________________________
>> Wikitech-l mailing list
>> Wikitech-l(a)lists.wikimedia.org
>>
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
>
> _______________________________________________
> Wikitech-l mailing list
> Wikitech-l(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
--
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [
http://daniel.friesen.name]