Well as usual this turned out to be fairly simple - once the reason was
found.
Staring at the process list until this occured again revealed the following
situation:
1. An RSS subscription to an infrequently used list results in a very heavy
query (worst case almost 200 seconds), that has to do a
Hjalmar Gislason wrote:
Now, from time to time (even several times per hour) one of my tables seems
to "hang" for 30 - 180 seconds, and as this is a key table in the
application it basically brings everything to a halt. The interesting thing
is that I can not see a pattern in the web server logs of
What does the show processlist look like?
Have you ran top/vmstat/iostat when the `hanging` occurs?
Hjalmar Gislason wrote:
Hi there,
I've been having some trouble with an application that I'm running
(www.spurl.net).
I have a database that consists of about 20 tables. The largest tables are a
litt
