[OSM-dev] Reducing size on mediawiki server
jochen at remote.org
Thu Apr 12 12:23:04 BST 2007
Doesn't Mediawiki use transactions? I don't know enough about Mediawiki
but would expect it to use transactions which MyIsam doesn't support.
Can't find anything on it quickly, but there is a setting for this:
So maybe it works ok without transactions if this is not set. I feel
rather uneasy though when using any kind of database application without
transactions if the application doesn't explicitly says it can work
On Thu, Apr 12, 2007 at 11:48:41AM +0100, Nick Hill wrote:
> Date: Thu, 12 Apr 2007 11:48:41 +0100
> From: Nick Hill <nick at nickhill.co.uk>
> To: OSM-Dev Openstreetmap <dev at openstreetmap.org>
> Subject: Re: [OSM-dev] Reducing size on mediawiki server
> I converted the tables on wiki to MyIsam at 1am this morning and disabled InnoDB
> on the wiki server.
> The application memory footprint has dropped from an average of around 130Mb to
> around 40Mb. More importantly, it no longer rises over time. I am hopeful the
> wiki virtual server will be much more reliable, so long as we suppress the urge
> to load more services onto it.
> I have also added a basic captcha system (a reverse turing test) to stop
> vandalbots creating accounts on wiki. This test is very simple, and not
> particularly difficult for a machine to complete. If that gets broken, i'll add
> an image based captcha, and/or we could require verification by email before
> allowing edits.
> Nick Hill wrote:
> > Given we have trouble with services quitting on mediawiki, presumably through an
> > out of memory condition on the virtual server instance, anything we can do to
> > reduce the memory footprint of the services supporting the wiki should improve
> > reliability.
> dev mailing list
> dev at openstreetmap.org
Jochen Topf jochen at remote.org http://www.remote.org/jochen/ +49-721-388298
More information about the dev