User "Brion VIBBER" changed the status of MediaWiki.r102785. Old Status: fixme New Status: resolved
User "Brion VIBBER" also posted a comment on MediaWiki.r102785. Full URL: http://www.mediawiki.org/wiki/Special:Code/MediaWiki/102785#c26364 Commit summary: * applyed the patch from bug 26393 (please comment on the bug page) Comment: With the above things fixed, looking good! Queries appear to actually be nicely const-indexed: mysql> explain SELECT /* ShortPagesPage::reallyDoQuery 192.168.38.113 */ page_namespace AS namespace,page_title AS title,page_len AS value FROM `page` FORCE INDEX (page_redirect_namespace_len) WHERE page_namespace = '0' AND page_is_redirect = '0' ORDER BY page_len LIMIT 50; {|class=wikitable | id || select_type || table || type || possible_keys || key || key_len || ref || rows || Extra |- | 1 || SIMPLE || page || ref || page_redirect_namespace_len || page_redirect_namespace_len || 5 || const,const || 71 || Using where |} 1 row in set (0.00 sec) mysql> explain SELECT /* LongPagesPage::reallyDoQuery 192.168.38.113 */ page_namespace AS namespace,page_title AS title,page_len AS value FROM `page` FORCE INDEX (page_redirect_namespace_len) WHERE page_namespace = '0' AND page_is_redirect = '0' ORDER BY page_len DESC LIMIT 50 ; {|class=wikitable | id || select_type || table || type || possible_keys || key || key_len || ref || rows || Extra |- | 1 || SIMPLE || page || ref || page_redirect_namespace_len || page_redirect_namespace_len || 5 || const,const || 71 || Using where |} 1 row in set (0.00 sec) _______________________________________________ MediaWiki-CodeReview mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-codereview
