On Wed, 17 Sep 2003, Luc Van Oostenryck wrote:
Just to be sure, Larousse is the Web server and
Pliny the machine running the DB?
Mostly. :) Larousse is the web server, but right now it's only serving the
English and test sites, because it's so overloaded we never finished
moving the others over. To complicate things, Larousse also has a
local copy of the search table for the english wiki which is not being
updated and has enough fields added to it that it doesn't join against
the main article database. This seems to help vis-a-vis keeping things
from locking.
Pliny is the database server, but it's also still serving web pages for
everything but English and test sites.
Have you an idea about the excessive context
switch in the previous 'vmstat 5' output?
I can even hardly believe that 173000 cs is even possible and what can cause this?
I suspect that some counter overflows in extreme circumstances, but I
really don't know for sure.
Possible but an overflow of what?
There was also some values of 45000 and 12000;
I think it was the true value and a symptom of the real problem.
But just now it run very well ...