[OSM-dev] MySQL on dev
Raphaël Jacquot
sxpert at sxpert.org
Wed May 16 14:48:31 BST 2007
Frederik Ramm wrote:
> Hi,
>
>> Still, I get a bit curious when I learn from the Munin graphs [1]
>> that a MySQL server on "dev" processes 90 "replace" queries per
>> *second*.
>
> Tile upload, most likely. Remember that for every rendering request
> dispatched, there will be in the region of 2,000 tiles uploaded (two
> layers, one from zoom 12-17, one from zoom 12-16). Tile meta data is
> kept in the MySQL data base.
>
> From Upload/tile2.php:
>
[ snip loop code ]
can you run that thing in a transaction instead ?
More information about the dev
mailing list