[OSM-dev] mysql configuration

[Celso González]

Hi

I have been watching the mysql configuration as
its published on 
http://wiki.openstreetmap.org/index.php/Database
and i wanted to add some things about configuration

Our database is mainly for reading, i dont have the
exact data, but we are having a hit cache ratio very low
mainly because we are using a very small query_cache_size
64M.

I read on the irc that we are migrating some tables to
innodb so we should lower the key_buffer_size (its only used 
for myisam tables) and create innodb_buffer_pool_size variable

I also saw that we are using the binlog facilities, if we are
not replicating and we are not taking care about that logs
we can increase performance disabling the logs.

And thats all for the moment, i hope it helps and sure i
can give more hints with more real data.

Btw, is there in any place the mysql schema we are using?
I checked all the svn and i was not able to find it.

Best regards

-- 
Celso González (aka PerroVerd)  GPG key 0x2DA367B7
http://mitago.net
-------------- 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/dev/attachments/20070506/6ab94583/attachment.pgp>