https://bugzilla.wikimedia.org/show_bug.cgi?id=29287
--- Comment #8 from Reedy <[email protected]> 2011-06-07 13:41:45 UTC --- mysql> describe select distinct cp_path from mw_code_paths repo_path where cp_repo_id = 1 AND cp_path LIKE '/trunk/%' +----+-------------+-----------+------+-------------------+---------+---------+-------+--------+-------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------+------+-------------------+---------+---------+-------+--------+-------------------------------------------+ | 1 | SIMPLE | repo_path | ref | PRIMARY,repo_path | PRIMARY | 4 | const | 640157 | Using where; Using index; Using temporary | +----+-------------+-----------+------+-------------------+---------+---------+-------+--------+-------------------------------------------+ 1 row in set (0.00 sec) mysql> describe select distinct cp_path from mw_code_paths force index (repo_path) where cp_repo_id = 1 AND cp_path LIKE '/trunk/%' +----+-------------+---------------+-------+---------------+-----------+---------+------+--------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+-------+---------------+-----------+---------+------+--------+--------------------------+ | 1 | SIMPLE | mw_code_paths | range | repo_path | repo_path | 261 | NULL | 640157 | Using where; Using index | +----+-------------+---------------+-------+---------------+-----------+---------+------+--------+--------------------------+ Yay, that looks better as it kills the temporary. Will commit it! :) -- 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 [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
