[OSM-dev] Too many slow queries in db

Tom Hughes tom at compton.nu
Mon Sep 3 23:15:32 BST 2007


In message <b11426350709031400m72e7b730sadecfd803a0235b8 at mail.gmail.com>
          "Francisco R. Santos" <frsantos at gmail.com> wrote:

> Since this saturday, mysql has incremented the number of slow queries up to
> 100/s and higher [1], making impossible to do any edits. Can anyone with
> access to db look at those queries, and see if it can be fixed?

Yeah sure. My magic query accelerator will sort it all out.

Seriously, if you've got a magic way to make a database query
a 100 million row table in the blink of an eyelid I'll be only
to happy to deploy it.

For now I've disabled GPX imports again until things calm down.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/




More information about the dev mailing list