https://bugzilla.wikimedia.org/show_bug.cgi?id=3311
--- Comment #68 from Bawolff (Brian Wolff) <bawolff...@gmail.com> ---
Re comment 66:
If I have more than a single category in the IN condition when doing that, I
get a filesort:
mysql> describe SELECT /* CategoryViewer::doCategoryQuery Bawolff */
page_id,page_title,page_namespace,page_len,page_is_redirect,cl_sortkey,cat_id,cat_title,cat_subcats,cat_pages,cat_files,cl_sortkey_prefix,cl_collation
FROM `page` INNER JOIN `categorylinks` FORCE INDEX (cl_sortkey) ON ((cl_from =
page_id) AND cl_to in ('Foo', 'se') and cl_type = 'page') LEFT JOIN `category`
ON ((cat_title = page_title) AND page_namespace = '14') ORDER BY cl_sortkey
LIMIT 2\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: categorylinks
type: range
possible_keys: cl_sortkey
key: cl_sortkey
key_len: 258
ref: NULL
rows: 559
Extra: Using where; Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: page
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: wikidb.categorylinks.cl_from
rows: 1
Extra:
*************************** 3. row ***************************
id: 1
select_type: SIMPLE
table: category
type: eq_ref
possible_keys: cat_title
key: cat_title
key_len: 257
ref: wikidb.page.page_title
rows: 1
Extra:
3 rows in set (0.00 sec)
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
