[OSM-talk] Problem Solved WAS: Re: Server slowness

[Andy Robinson]

Nice one Nick, the improvements in the time taken to grab data and upload
edits has made a big difference, Much more productive for me.

Cheers

Andy

Andy Robinson
Andy_J_Robinson at blueyonder.co.uk 

>-----Original Message-----
>From: talk-bounces at openstreetmap.org [mailto:talk-
>bounces at openstreetmap.org] On Behalf Of Nick Hill
>Sent: 15 January 2007 10:33 AM
>To: talk at openstreetmap.org
>Subject: [OSM-talk] Problem Solved WAS: Re: Server slowness
>
>The problem we have been experiencing seems to be caused by large numbers
>of RSS
>feed queries.
>
>An RSS feed query covers a 0.4x0.4 degree tile. Extracts all nodes, sorts
>them,
>then takes the top 40. These are then keyed against the users table.
>Naturally,
>the users table is locked whilst the query is performed. This made it look
>like
>a users table problem.
>
>Since I disabled RSS at midnight, the database load has dropped by at least
>80%.
>
>http://www.openstreetmap.org/munin/openstreetmap/db.openstreetmap-cpu.html
>
>Nick Hill wrote:
>> I have been pouring over the SQL passing through Mysql today. Queries
>which seem
>> to be taking ages peel off top 40 nodes with user IDs. I guess these are
>RSS
>> feed queries.
>>
>> I have therefore just broken the RSS system in the apache conf of www to
>check
>> this is the culprit.
>
>_______________________________________________
>talk mailing list
>talk at openstreetmap.org
>http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/talk