[OSM-dev] mysql configuration

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


SQL is here:

http://trac.openstreetmap.org/browser/sites/rails_port/db/create_database.sql

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
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFGPkvKW7HC4i2jZ7cRArm/AJ9/OreZp7Z2AesDzq+PztpbxNVjRACdH095
> xRY7huY7NFpQjIIXXim5MBU=
> =2LLh
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>
>


-- 
Nick Black
--------------------------------
http://www.blacksworld.net
-------------- 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