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.ju...@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 <phoenixoverr...@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.ju...@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 <phoenixoverr...@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
_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
--
~Daniel Friesen (Dantman, Nadir-Seen-Fire) [http://daniel.friesen.name]
_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l
