https://bugzilla.wikimedia.org/show_bug.cgi?id=27938
Reedy <s...@reedyboy.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Special:Fewestrevisions |Special:Fewestrevisions has
|takes nearly a minute to |a very expensive query that
|execute on TW |filesorts and uses a
| |temporary table
--- Comment #1 from Reedy <s...@reedyboy.net> 2011-03-08 17:01:10 UTC ---
mysql> describe SELECT page_namespace AS namespace,page_title AS
title,COUNT(*) AS value,page_is_redirect AS redirect FROM
`mw_revision`,`mw_page` WHERE page_namespace = '0' AND (page_id = rev_page)
GROUP BY page_namespace, page_title, page_is_redirect HAVING COUNT(*) > 1 ORDER
BY value LIMIT 50\G
+----+-------------+-------------+------+----------------------------+-------------+---------+------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key
| key_len | ref | rows | Extra
|
+----+-------------+-------------+------+----------------------------+-------------+---------+------------------------+------+----------------------------------------------+
| 1 | SIMPLE | mw_page | ref | PRIMARY,name_title |
name_title | 4 | const | 3 | Using where; Using
temporary; Using filesort |
| 1 | SIMPLE | mw_revision | ref | rev_page_id,page_timestamp |
rev_page_id | 4 | wikidb.mw_page.page_id | 1 | Using index
|
+----+-------------+-------------+------+----------------------------+-------------+---------+------------------------+------+----------------------------------------------+
2 rows in set (0.00 sec)
It's using temporary and filesorting...
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
