[Maps-l] ptolemy performance

[Tim Alder]

Hello,
if downtime would also effect the delivery of existing tiles, we could  
close the map in german geohack for this time, because it's seems the  
smallest lost for users and a lot of requests comes from there.

If downtime would only influence the rendering, a downtime over european night
seem no bigger problem for me. Mostly we rendering only dirty files  
and have also fallback to OSM.org tiles.

I'm not sure what with the comparison with osm.org, because it's  
difficult to compare the different renderd/tirex  statistics.

Greetings Kolossos


Zitat von River Tarnell <river.tarnell at wikimedia.de>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi,
>
> As I understand it, our database/tile server (ptolemy) is higher  
> spec than the
> equivalent hardware at OSM.org, yet it performs much worse (e.g. at rendering
> tiles).  Is this correct?
>
> If so, has anyone compared the indices on ptolemy's database to OSM's?
>
> If that is not the problem, I would like to test performance without VxVM
> between the filesystem and the disk.  While Vx doesn't hurt performance with
> MySQL, I noticed during testing that it significantly reduced import
> performance with Postgres.  I believe that was fixed by putting pg_xlog on a
> separate (non-Vx) disk, but it may still be hurting read performance.
>
> Testing this will require some downtime for conversion; based on the  
> amount of
> data, I would estimate about 8 hours to copy the data off and back again.
>
> 	- river.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.16 (FreeBSD)
>
> iEYEARECAAYFAkzmWEkACgkQIXd7fCuc5vLqAQCguzjEGzMXZTcRfQFKKISsw0hI
> 8ggAoMDmU+HOp4VPZBIp9SBuWrdY/Ua7
> =TpV4
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> Maps-l mailing list
> Maps-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/maps-l
>
>