SELECT * FROM cur WHERE (cur_title NOT LIKE "S") AND (cur_text LIKE "S" ) ORDER BY cur_title
seems to be a big offender. That's the special_dosearch query, I think.
Yes. That searches linearly through the whole database to search for a string. That's a killer. It's like our old UseMod search before Jimbo wrote an indexed one. A FULLTEXT index, together with MATCH instead of LIKE, should give a major improvement.
Axel
wikitech-l@lists.wikimedia.org