On Fri, 14 May 2004 04:55:00 -0700 Delirium delirium@hackish.org wrote:
My apologies if this has come up before; I couldn't find anything in the archives so thought I'd ask.
Is there something that makes the smaller Wikipedias really really slow? I've been noticing "edit this page" on el: often takes on the order of 20-40 seconds, even during times when it's around 2-5 seconds on en:. Editing is the most egregious case, but even viewing pages can take 10-20 seconds on el: but rarely more than 3 or 4 on en:, and page loads time out maybe 3-5% of the time on el:, which almost never happens these days on en: (for me, anyway). It's not entirely consistent, but it's a fairly noticeable difference. I thought this might be something to do with less-frequently-accessed wikipedias not having their database tables in RAM as often, but it seems to happen even if I try editing the same page 2-3 times in a row, after which I would've guessed the tables should be loaded into memory (but I could be wrong on that). In any case, it makes editing or reading el: a lot more unpleasant than editing or reading en:, which doesn't help with getting a small project going.
Small wikis are less often cached than big wikis as you said. And actually on our db server, we use only 1,6GB of memory on 4G we could use, because we use a 32bits linux instead of a 64bits. And the system disk is slow for our use, a raid5 with 3 disks. It's a bit faster since Jimmy put the new drives in db server.
The new db server, should resolve this problem.
Shaihulud