Nick Reinking wrote:
This is typical
and should be a comfortable level. Slowness on the wikis
from pliny right now is probably due to either Apache problems or database
locking issues. I'm open to suggestions.
-- brion vibber (brion @
pobox.com)
Get more, bigger hardware, and put the databases and web servers on
different machines. Or did you mean constructive suggestions?
Well, there are a lot of options out there:
I suppose that we first need a short term solution
1) Try PostgreSQL
:-( need time to port the software
2) Seperate Web Server & Database
Is not already the case?
3) Try switching to a new OS that handles better under
excessive load
(FBSD?)
:-( need time to port the software
4) Try a 2.5 kernel? (ugh?)
Is it possible to
try this on test (it's a separate machine no?)
5) Get faster hardware
:-( Need time and money
The problem, really, is that strange things happen under load that
heavy. When it gets to that point, it becomes very difficult to
pinpoint the bottlenecks. It certainly isn't helpful that the database
and web server are probably causing cyclical problems between each
other. Is there a reason why we can't put all the web servers on one
machine, and the database on the other? Is the CPU strain from the web
servers on larousse too much for pliny sans database? Or is the memory
strain from the database on pliny too much for larousse sans web server?
-- Looxix