https://bugzilla.wikimedia.org/show_bug.cgi?id=23720

Reedy <s...@reedyboy.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |s...@reedyboy.net,
                   |                            |simetrical+wikib...@gmail.c
                   |                            |om

--- Comment #2 from Reedy <s...@reedyboy.net> 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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to