https://bugzilla.wikimedia.org/show_bug.cgi?id=23720
Reedy <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected], | |[email protected] | |om --- Comment #2 from Reedy <[email protected]> 2010-12-31 20:33:36 UTC --- mysql> describe SELECT cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_paths` INNER JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id = cp_rev_id)) LEFT JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND cc_rev_id = cp_rev_id)) WHERE cp_repo_id = '3' AND (cp_path LIKE '/trunk/extensions/Cite/cite\_text%' ) AND (cp_rev_id > 58352) GROUP BY cp_rev_id ORDER BY cp_rev_id; +----+-------------+-----------------+-------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+----------------------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------------+-------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+----------------------------------------------+ | 1 | SIMPLE | mw_code_rev | range | PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 8 | NULL | 21804 | Using where; Using temporary; Using filesort | | 1 | SIMPLE | mw_code_paths | ref | PRIMARY | PRIMARY | 8 | const,wikidb.mw_code_rev.cr_id | 2 | Using where; Using index | | 1 | SIMPLE | mw_code_comment | ref | cc_repo_id,cc_repo_time | cc_repo_id | 8 | wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index | +----+-------------+-----------------+-------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+----------------------------------------------+ 3 rows in set (0.00 sec) mysql> describe SELECT cp_rev_id,cr_id,cr_repo_id,cr_status,COUNT(DISTINCT cc_id) AS comments,cr_path,cr_message,cr_author,cr_timestamp FROM `mw_code_paths` INNER JOIN `mw_code_rev` ON ((cr_repo_id = cp_repo_id AND cr_id = cp_rev_id)) LEFT JOIN `mw_code_comment` ON ((cc_repo_id = cp_repo_id AND cc_rev_id = cp_rev_id)) WHERE cp_repo_id = '3' AND (cp_path LIKE '/trunk/extensions/Cite/cite\_text%' ) GROUP BY cp_rev_id ORDER BY cp_rev_id; +----+-------------+-----------------+------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+---------------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------------+------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+---------------------------------+ | 1 | SIMPLE | mw_code_rev | ref | PRIMARY,cr_repo_id,cr_repo_author,cr_id | PRIMARY | 4 | const | 49838 | Using temporary; Using filesort | | 1 | SIMPLE | mw_code_paths | ref | PRIMARY | PRIMARY | 8 | const,wikidb.mw_code_rev.cr_id | 2 | Using where; Using index | | 1 | SIMPLE | mw_code_comment | ref | cc_repo_id,cc_repo_time | cc_repo_id | 8 | wikidb.mw_code_paths.cp_repo_id,wikidb.mw_code_rev.cr_id | 1 | Using index | +----+-------------+-----------------+------+-----------------------------------------+------------+---------+----------------------------------------------------------+-------+---------------------------------+ 3 rows in set (0.00 sec) -- 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
