[OSM-talk] www.openstreetmap.org down?

[Jan-Benedict Glaw]

On Sun, 2006-05-14 21:37:33 +0100, Nick Hill <nick at nickhill.co.uk> wrote:
> Something hammered www which in turn hammered db. DB was at 100% till 
> after 18:00. I re-started mysql on db.

I guess that there are far more SELECTs than INSERTs, right?  Maybe
it's possible to proxy the SELECTs and spread them over a number of
machines, issueing INSERTs on all of them?

> We'll need to set the maximum servers on www to a level below where 
> swapping will occur.

I'd like to see some the actual usage pattern (-> several `ps axflwww'
outputs during high load, `vmstat 1' and the query log), filesystems
and mount options, maybe I can come up with a good concept?

>From personal experience, sometimes tile generation as well as
getting the GPX trackpoints as well as the node/segment/street
information takes quite long, which in turn may result in frustration
during the editing session.

MfG, JBG

-- 
Jan-Benedict Glaw       jbglaw at lug-owl.de    . +49-172-7608481             _ O _
"Eine Freie Meinung in  einem Freien Kopf    | Gegen Zensur | Gegen Krieg  _ _ O
 für einen Freien Staat voll Freier Bürger"  | im Internet! |   im Irak!   O O O
ret = do_actions((curr | FREE_SPEECH) & ~(NEW_COPYRIGHT_LAW | DRM | TCPA));
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/talk/attachments/20060515/dafcb8fc/attachment.pgp>