[OSM-dev] MySQL on dev

[Frederik Ramm]

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:

   # Each element in TileList is a snippet of values  
(x,y,z,type,size) for each tile
   foreach($TileList as $SqlSnippet){

     $Fields = "x, y, z, type, size, date, user, version";
     $Values = sprintf("%s, now(), %d, %d", $SqlSnippet, $UserID,  
$VersionID);

     $SQL = sprintf("replace into `tiles_meta` (%s) values (%s);",  
$Fields, $Values);
     mysql_query($SQL);
   }

Bye
Frederik

-- 
Frederik Ramm  ##  eMail frederik at remote.org  ##  N49°00.09' E008°23.33'