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.
Are there any server or sql parameters that were modified on the german and english wikipedias, but not on the spanish one?
AstroNomer
__________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
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)
wikitech-l@lists.wikimedia.org