Page MenuHomePhabricator
Paste P5259

ew, Special:Tags causes a filesort
ActivePublic

Authored by demon on Apr 12 2017, 7:10 PM.
Tags
None
Referenced Files
F7511307: ew, Special:Tags causes a filesort
Apr 12 2017, 7:10 PM
Subscribers
None
mysql:wikiadmin@db1051 [enwiki]> EXPLAIN SELECT ct_tag,count(*) AS `hitcount` FROM `change_tag` GROUP BY ct_tag ORDER BY hitcount DESC;
+------+-------------+------------+-------+---------------+--------+---------+------+----------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+------+-------------+------------+-------+---------------+--------+---------+------+----------+----------------------------------------------+
| 1 | SIMPLE | change_tag | index | NULL | ct_tag | 272 | NULL | 24735709 | Using index; Using temporary; Using filesort |
+------+-------------+------------+-------+---------------+--------+---------+------+----------+----------------------------------------------+
1 row in set (0.00 sec)