O.k., I've enabled this and glanced through it a bit. It's pretty
interesting, even though I only have a small handful of values in it.
I think what I'll do is leave it on overnight, and then gzip it for
everyone to download tomorrow. (Or perhaps I'll just gzip the output
of mysqldumpslow, which summarizes it a bit. Or perhaps I'll slap together
a quick perl script to boil it down to the essentials for our context.)
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.
Also, here's a fun looking query:
SELECT * FROM cur WHERE (cur_title NOT LIKE "S") AND ( (cur_title LIKE
"S" OR
cur_title LIKE "S") AND (cur_title LIKE "S" OR cur_title LIKE
"S") AND (cur_titl
e LIKE "S" OR cur_title LIKE "S") AND (cur_title LIKE "S" OR
cur_title LIKE "S")
AND (cur_title LIKE "S" OR cur_title LIKE "S") ) ORDER BY cur_title
I'm no database expert, but that doesn't look so sensible to me. :-)
Show replies by date