[OSM-dev] First post, &some questions :)

[Yann]

Hello list!

So, please let me introduce myself before I get completely flamed ;)

I am Yann Hamon, used to be really involved in Ubuntu, especially the French
local community team. We managed to get a nice infrastructure (
http://ubuntu-eu.org/?page_id=3) to host our website for very little money,
that way we have no advertisements. I would really love to help
openstreetmap to get servers and hosting facilities, and/or help for an
eventual fund raising in French speaking countries, and/or contribute my
sysadmin skills to help manage the servers. I don't know how good you guys
are, maybe you are absolutely fine without me... so please don't be too
harsh in making me understand that :P

I am half French/half German, living in Oxford for a few months now; please
excuse my English, it's still not perfect (although firefox's dictionary
helps a lot ;) )

One of my friends pointed me to http://munin.openstreetmap.org/ , it brought
some questions to my mind which you may be able to answer.
On the main db server:
http://munin.openstreetmap.org/openstreetmap/db.openstreetmap-mysql_queries-week.png
the cache_hits have disappeared, is this intentional?
You have a lot of slow queries, do you sometimes have a look at
/var/log/mysql/mysql-slow.log? Could you maybe upload that file somewhere,
so I can get a look at it?
Could you execute that command on this server: du -shc
/var/lib/mysql/*/*.MYI  | fgrep total  (should give the size of the indexes
of your database) and this one: fgrep key_buffer_size /etc/mysql/my.cnf   ?

Concerning db2.openstreetmap.org:
What is this server? A dual core with 4GB RAM... looks pretty good :) why is
it not used? On Ubuntu-fr our DB is also myisam, but we get it replicated on
another server, which is going to run the search queries in a near future.

Concerning dev.openstreetmap.org :
How big are the disks? You should *definitely* consider using SCSI on that
servers.http://munin.openstreetmap.org/openstreetmap/dev.openstreetmap-
cpu-day.png
I/O operations use over 80% of the CPU, all the time... :(  That server is
also swapping ..

Concerning tile.openstreetmap.org:
What programs are niced there? Why is this server using Apache instead of
Lighttpd as the main www?
Your max_spare_servers seems rather low, so apache is forking pretty often..
Have you tried raising it a little bit? What is its current value?


The wiki configuration looks fine to me, only the CPU graphs looks really
odd, never seen that before :P

The www is swapping a LOT, which can usually be avoided with HTTP servers; I
don't know lighttpd too much, if it was running Apache i would say you
should lower down the max_processes value... the "applications" memory usage
seems rather high, no?

That's for my few questions... Again, maybe the servers are configured fine
right now, you can't tell everything just by looking at the graphs, and I
don't know exactly what is running on each of these servers neither...

Are most of the devs based in the UK, and also coming to the State Of The
Map conference?
Anyway, you can contact me on IRC, yann2 on freenode.net... and also
yann.hamon at gmail.com on jabber!


Yann
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070703/f1fe0016/attachment.html>