On Wed, 2002-12-18 at 15:54, wiki pedista wrote:
I have been experiencing horrible lags and stalling on the spanish wikipedia. I have checked the english and german at the same time to see if there are problems there too, but they worked fine. es.wikipedia is a very low traffic wiki, so i don't understand this.
There are basically two types of situations that can cause lag: 1) A really slow query runs on one of the main tables; other things try to write to the table, but the entire table is locked by the slow query and anything else trying to access that table has to wait for it. This directly affects only one language under our current setup.
2) There are so many backed up waiting connections from 1) that we hit the connection limit and *the entire site* has to wait for the first query to finish. At the moment this mainly means the English site blocking the others.
So, if slow queries were hitting the Spanish site _specifically_, that wouldn't stop the other wikis from running.
-- brion vibber (brion @ pobox.com)