[OSM-dev] OSM Database Infrastructure

[SteveC]

Stefan

someone (me?) put up an anonymised apache log with a sample of the  
queries the db receives, I think its on the wiki

an updated version of that should give you a representative sample to  
use



On 14 Jan 2008, at 16:36, Stefan de Konink wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA512
>
> SteveC schreef:
>> I think the single-server still works very well. It does so by
>> ignoring doctrine on postgis and gis extensions and a bunch of  
>> scary C
>> extensions thought up by Nick Hill and implemented by TomH. jburgess
>> is doing similarly scary things with apache modules for shipping out
>> tiles.
>
>
> I asked this before, but I would like to do some benchmark on another
> single database server implementation. Could any of you provide the  
> slow
> queries currently in MySQL, the top (10?) queries mostly done, and
> provide some figures how long they take?
>
>
>
> Yours Sincerely,
>
> Stefan de Konink
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v2.0.7 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFHi4+aYH1+F2Rqwn0RCrm8AJ9lXran7YBnBApLxSjvHXDfFxvH5QCaAjyn
> GgYHQR8HZGWXk6z5++0lbXM=
> =uKAO
> -----END PGP SIGNATURE-----
>

have fun,

SteveC | steve at asklater.com | http://www.asklater.com/steve/