[OSM-dev] Planet dump today delayed (ie not today) :-(

[Jon Burgess]

On Wed, 2007-08-22 at 17:16 +0200, Sebastian Spaeth wrote:
> It seems todays planet dump got stuck at 4.7GB and is not moving anymore.
> The file seems to be modified every now and then (like ever 30 minutes) but doesn't grow significantly.
> 
> TomH had changed some database access restrictions, perhaps the mysql server didn't like that. Perhaps it's full moon, I don't know. I killed the dump and restarted it. That means that the planet dump will not appear the next 14 hours or so.
> 
> Sorry for that.
> 
> spaetz

Looking at the IO graphs I believe the planet.rb script is moving very
slowly because DB is completely IO bound. I suspect the 30 minute CPU
blips occur each time the planet.rb successfully fetches another page of
500,000 entries.

I guess it will start moving more rapidly again when the other DB/API
users start to drop off after midnight.

I'll try to find some time to see if the planet.rb script or SQL queries
can be made more IO efficient.

	Jon