[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