Closed
Bug 825296
Opened 11 years ago
Closed 11 years ago
query analysis for bugzilla query checksum 9041743092363122909
Categories
(Data & BI Services Team :: DB: MySQL, task)
Tracking
(Not tracked)
RESOLVED
INVALID
People
(Reporter: scabral, Unassigned)
References
Details
checksum: 9041743092363122909 sample: SELECT bugs.bug_id AS bug_id, bugs.bug_severity AS bug_severity, bugs.priority AS priority, bugs.bug_status AS bug_status, bugs.resolution AS resolution, map_products.name AS product, bugs.op_sys AS op_sys, map_assigned_to.login_name AS assigned_to, bugs.short_desc AS short_desc FROM bugs INNER JOIN profiles AS map_assigned_to ON (bugs.assigned_to = map_assigned_to.userid) INNER JOIN products AS map_products ON (bugs.product_id = map_products.id) LEFT JOIN bug_group_map ON bug_group_map.bug_id = bugs.bug_id AND bug_group_map.group_id NOT IN (20,19,10,9,69,84,35,74,32,6,42,26,76) LEFT JOIN cc ON cc.bug_id = bugs.bug_id AND cc.who = 432445 WHERE (( bugs.bug_status IN ('NEW','ASSIGNED','REOPENED','UNCONFIRMED') ) AND (bugs.assigned_to IN (SELECT userid FROM profiles WHERE INSTR(profiles.login_name, 'xxxxxxx@mozilla.com') > 0))) AND bugs.creation_ts IS NOT NULL AND ((bug_group_map.group_id IS NULL) OR (bugs.reporter_accessible = 1 AND bugs.reporter = 432445) OR (bugs.cclist_accessible = 1 AND cc.who IS NOT NULL) OR (bugs.assigned_to = 432445) OR (bugs.qa_contact = 432445) ) GROUP BY bugs.bug_id ORDER BY bug_id LIMIT 10001
Reporter | ||
Comment 1•11 years ago
|
||
Similar to bug 825283 and bug 825261, although a bit less crazy: *************************** 1. row *************************** id: 1 select_type: PRIMARY table: map_products type: index possible_keys: PRIMARY key: products_name_idx key_len: 194 ref: NULL rows: 93 Extra: Using index; Using temporary; Using filesort *************************** 2. row *************************** id: 1 select_type: PRIMARY table: bugs type: ref possible_keys: bugs_reporter_idx,bugs_product_id_idx,bugs_creation_ts_idx,bugs_assigned_to_idx,bu gs_qa_contact_idx,bugs_bug_status_idx key: bugs_product_id_idx key_len: 2 ref: bugs.map_products.id rows: 1343 Extra: Using where *************************** 3. row *************************** id: 1 select_type: PRIMARY table: bug_group_map type: ref possible_keys: bug_group_map_bug_id_idx,bug_group_map_group_id_idx key: bug_group_map_bug_id_idx key_len: 3 ref: bugs.bugs.bug_id rows: 1 Extra: Using where; Using index *************************** 4. row *************************** id: 1 select_type: PRIMARY table: cc type: eq_ref possible_keys: cc_bug_id_idx,cc_who_idx key: cc_bug_id_idx key_len: 6 ref: bugs.bugs.bug_id,const rows: 1 Extra: Using where; Using index *************************** 5. row *************************** id: 1 select_type: PRIMARY table: map_assigned_to type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: bugs.bugs.assigned_to rows: 1 Extra: *************************** 6. row *************************** id: 2 select_type: DEPENDENT SUBQUERY table: profiles type: unique_subquery possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: func rows: 1 Extra: Using where 6 rows in set (0.08 sec) See Also: https://bugzilla.mozilla.org/show_bug.cgi?id=825261, https://bugzilla.mozilla.org/show_bug.cgi?id=825283
Reporter | ||
Comment 2•11 years ago
|
||
resolving invalid in bugzilla 4.2, which we upgraded to in March.
Status: NEW → RESOLVED
Closed: 11 years ago
Resolution: --- → INVALID
Updated•10 years ago
|
Product: mozilla.org → Data & BI Services Team
You need to log in
before you can comment on or make changes to this bug.
Description
•