[Tilesathome] Mysql Stats
Andrew McCarthy
me at andrewmccarthy.ie
Tue May 27 15:30:46 BST 2008
On Tue, May 13, 2008 at 09:16:09AM +0200, Raphael Studer wrote:
> Hi,
>
> I've been looking at the Mysql stats for tah.osm
> (http://munin.openstreetmap.org/openstreetmap/tah.openstreetmap-mysql_queries.html).
> Most of the time, the server is deleting something.
> What's the job of the server?
I suspect this is when the server updates the blank tiles database. My
understanding of the code is that each blank tile entry is deleted in an
individual "delete" statement, but all the new blank tile data is loaded
in a single "replace" statement, throwing the stats heavily towards
"delete". Have a look at the SaveBlankTiles() function at lines 257–331:
http://trac.openstreetmap.org/browser/sites/other/tilesAtHome/Upload/Run/index.php
Andrew
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20080527/768b59ae/attachment.pgp>
More information about the Tilesathome
mailing list