On Sun 12 Sep 2004, James Green <jkg(a)earth.li> wrote:
The Nottingham OpenGuide 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. [...] People have
mentioned MySQL indexes to me, but my understanding of what's going on
with them is roughly nil.
Could be indexes - see the SQL in CGI::Wiki::Setup::MySQL -
The relevant line is
CREATE INDEX metadata_index ON metadata(node, version, metadata_type,
The MySQL docs at
might be of help. In particular, depending on when you ran cgi-wiki-setupdb,
you may not actually have the index there; I can't remember when I added it
to the SQL.