Well, the (boolean) search seems to fly and the most-wanted page seems to run smoothly, but the orphans-page get a time-out because it takes more than 30 seconds to compute. I'm baffled by this because on my little PC the most-wanted pages takes about 5 times as long as the orphans page. Is there a way for me to get access to the database to see what's going on? Perhaps someone could check if all the indexes for linked are actually defined? I also would like to know if there are perhaps a big amount of duplicates there. I would like to know what the results of
SELECT COUNT(*) FROM linked;
and
SELECT COUNT(*) FROM linkes GROUP BY linked_from, linked_to ;
to see if they are very different. Perhaps a new log of the slow queries would also be helpful.
-- Jan Hidders
wikitech-l@lists.wikimedia.org