Hiya.
The Nottingham OpenGuide[1] takes a considerable time to load the front
page; if the machine it's on is using its CPU for anything else, at the
time, it takes even longer. While it's loading, mysqld is taking up ~90%
of the CPU time according to 'top', running (as far as I can tell) the
query that generates the list of recent changes.
I had just put it down a One Of Those Things, but I noticed that the
other, larger guides such as Oxford and London *don't* have this
problem. So, I'm left thinking it's something I've not configured
properly -- has anyone got any clues what that might be? People have
mentioned MySQL indexes to me, but my understanding of what's going on
with them is roughly nil.
Any suggestions are very welcome indeed...
Cheers,
James.
[1]
http://nottingham.openguides.org/
--
PGP fingerprint 3E85 0C7A FE11 42E9 A599 094D AE16 90F0 81AE 16FF, ID 81AE16FF
Go not to the IRC for counsel, for they will say both yes and no.
-- (with apologies to JRR Tolkien)