On Sun 12 Sep 2004, James Green jkg@earth.li wrote:
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. [...] 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 - http://search.cpan.org/src/KAKE/CGI-Wiki-0.54/lib/CGI/Wiki/Setup/MySQL.pm
The relevant line is CREATE INDEX metadata_index ON metadata(node, version, metadata_type, metadata_value(10))
The MySQL docs at http://dev.mysql.com/doc/mysql/en/index.html 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.
Kake