[OSM-dev] [OT] Robustness of MySQL

Dubravko Penezic dpenezic at gmail.com
Wed Nov 15 15:02:09 GMT 2006


On 11/14/06, Nick Whitelegg <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

It is child play for MySQL, i use it for database which have every day
600000 records, with 6-10 request per second without any problem. And
size of all files are more then 25 GB .

Very probably you run MySQL on system without enought RAM and very
slow hardisk system.

Dubravko




More information about the dev mailing list