[OSM-dev] mysql configuration

Nick Black nickblack1 at gmail.com
Mon May 7 11:00:27 BST 2007

SQL is here:


On 5/6/07, Celso González <celso at mitago.net> wrote:
> 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
> Version: GnuPG v1.4.6 (GNU/Linux)
> iD8DBQFGPkvKW7HC4i2jZ7cRArm/AJ9/OreZp7Z2AesDzq+PztpbxNVjRACdH095
> xRY7huY7NFpQjIIXXim5MBU=
> =2LLh
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev

Nick Black
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070507/6ff94371/attachment.html>

More information about the dev mailing list