At 11:11 12/01/2004 -0800, you wrote:
We really, really need to move the database back to a machine with a decent hard drive. The wikis are very sluggish, and a fair chunk of it's from waiting on the database.
Ursula's sitting around with a 90% idle CPU, but everything's blocked on disk I/O to the point it's got a load average of about 16. At any given time from 8-20 processes are blocked and waiting. Operations that hit a lot of rows like history and watchlist are particularly badly hit since they don't play as well with caching.
If Geoffrin's not going to be up soon, and Pliny's still emitting spurious disk errors, what are our options out of the available machines?
For a small amount of money put a raid array in a machine to speed up access time and / or split the db accros a few boxes
-- brion vibber (brion @ pobox.com)
Dave Caroline aka archivist
Wikitech-l mailing list Wikitech-l@Wikipedia.org http://mail.wikipedia.org/mailman/listinfo/wikitech-l