[OSM-dev] server

John McKerrell john at mckerrell.net
Mon Apr 16 08:28:24 BST 2007


I'm sure I saw someone ask if we had slow query logging turned on and  
they didn't get an answer, so is it? Uncommenting the following line  
in my.cnf should do it:

log-slow-queries   = /var/log/mysql/mysql-slow.log

John

On 16 Apr 2007, at 08:12, Andreas Brauchli wrote:

> On Sat, 2007-04-14 at 10:06 +0100, Nick Whitelegg wrote:
>
>> Could it be some bot trying to do an unfeasibly large query? I'm  
>> sure that was
>> the reason Freemap kept falling over a few months ago - a bot was  
>> trying to
>> do lots of queries on an old version of the site which was still  
>> up. I
>> removed the old version and it seemed to stop happening.
> you could check the mysql access log (if there is one) when it
> stops/stopped responding -> the last queries would give a clue to this
> (if this is indeed the case)..
>
>
>
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev





More information about the dev mailing list