https://bugzilla.wikimedia.org/show_bug.cgi?id=24479
--- Comment #15 from Reedy <[email protected]> 2010-12-31 20:01:59 UTC --- mysql> describe SELECT cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_tags`,`mw_code_rev` LEFT JOIN `mw_code_comment` ON ((cc_repo_id = cr_repo_id AND cc_rev_id = cr_id)) WHERE cr_repo_id = ct_repo_id AND (ct_repo_id = '3') AND (cr_id=ct_rev_id) AND ct_tag = 'api' GROUP BY cr_id ORDER BY cr_id DESC LIMIT 51; +----+-------------+-----------------+--------+-----------------------------------------+------------+---------+--------------------------------------------------------+------+-----------------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------------+--------+-----------------------------------------+------------+---------+--------------------------------------------------------+------+-----------------------------------------------------------+ | 1 | SIMPLE | mw_code_tags | ref | PRIMARY,ct_repo_id | PRIMARY | 4 | const | 1 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | mw_code_rev | eq_ref | PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 8 | const,wikidb.mw_code_tags.ct_rev_id | 1 | Using where | | 1 | SIMPLE | mw_code_comment | ref | cc_repo_id,cc_repo_time | cc_repo_id | 8 | wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index | +----+-------------+-----------------+--------+-----------------------------------------+------------+---------+--------------------------------------------------------+------+-----------------------------------------------------------+ 3 rows in set (0.00 sec) mysql> describe SELECT cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_tags` FORCE INDEX (ct_repo_id),`mw_code_rev` LEFT JOIN `mw_code_comment` ON ((cc_repo_id = cr_repo_id AND cc_rev_id = cr_id)) WHERE cr_repo_id = ct_repo_id AND (ct_repo_id = '3') AND (cr_id=ct_rev_id) AND ct_tag = 'api' GROUP BY cr_id ORDER BY cr_id DESC LIMIT 51; +----+-------------+-----------------+--------+-----------------------------------------+------------+---------+--------------------------------------------------------+------+-----------------------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------------+--------+-----------------------------------------+------------+---------+--------------------------------------------------------+------+-----------------------------------------------------------+ | 1 | SIMPLE | mw_code_tags | ref | ct_repo_id | ct_repo_id | 261 | const,const | 1 | Using where; Using index; Using temporary; Using filesort | | 1 | SIMPLE | mw_code_rev | eq_ref | PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 8 | const,wikidb.mw_code_tags.ct_rev_id | 1 | Using where | | 1 | SIMPLE | mw_code_comment | ref | cc_repo_id,cc_repo_time | cc_repo_id | 8 | wikidb.mw_code_rev.cr_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index | +----+-------------+-----------------+--------+-----------------------------------------+------------+---------+--------------------------------------------------------+------+-----------------------------------------------------------+ 3 rows in set (0.00 sec) No improvement unfortunately :( -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
