[OSM-dev] [OT] Robustness of MySQL
steve at asklater.com
Tue Nov 14 22:19:31 GMT 2006
* @ 14/11/06 07:49:12 PM nick at hogweed.org wrote:
> Since I put a slippy map on free-map.org.uk I've been having a lot of problems
> with MySQL crashing. For example, it crashed today after transferring the
> Freemap-NPE stuff over from the dev server.
> TBH I'm surprised that - even with a slippy map and a Bytemark VM - MySQL
> wouldn't be robust enough to cope with a dataset containing just 60300 nodes,
> 54074 segments and 6154 ways - representing UK footpaths from the latest
> planet.osm. Maybe it's because I've got other data (pre-OSM Freemap) on the
> machine too. I sincerely hope that the environment can cope with what can
> certainly be considered a pretty small database.
> I'll try clearing out other stuff from the database to see if it makes any
> difference. Meantime, can any mysql gurus offer any tips?
My bet is that you're running this on a bytemark machine with too little
memory and possibly without proper indexes. Maybe apache, exim and a
bunch of other things?
If so, the VM just doesn't have enough memory to run that much stuff.
What does `dmesg` say?
SteveC steve at asklater.com http://www.asklater.com/steve/
More information about the dev