slow apiqueryallpages
ActivePublic
Actions

Authored by • demon on May 1 2015, 4:26 PM.

Tags

None

Referenced Files

	F159315: slow_apiqueryallpages
	May 1 2015, 4:26 PM

Subscribers

None

	mysql:wikiadmin@db1052 [enwiki]> explain SELECT /* ApiQueryAllPages::run Pywikibot-test / /! STRAIGHT_JOIN */ page_namespace,page_title,page_id,page_content_model,page_restrictions,page_is_redirect,page_is_new,page_touched,page_latest,page_len FROM `page`,`langlinks` WHERE page_namespace = '0' AND (page_title>='!') AND (page_id=ll_from) GROUP BY page_title,page_id ORDER BY page_title LIMIT 6;
	+------+-------------+-----------+------+--------------------+------------+---------+---------------------+----------+------------------------------------+
	\| id \| select_type \| table \| type \| possible_keys \| key \| key_len \| ref \| rows \| Extra \|
	+------+-------------+-----------+------+--------------------+------------+---------+---------------------+----------+------------------------------------+
	\| 1 \| SIMPLE \| page \| ref \| PRIMARY,name_title \| name_title \| 4 \| const \| 18727509 \| Using index condition; Using where \|
	\| 1 \| SIMPLE \| langlinks \| ref \| ll_from \| ll_from \| 4 \| enwiki.page.page_id \| 2 \| Using index \|
	+------+-------------+-----------+------+--------------------+------------+---------+---------------------+----------+------------------------------------+
	2 rows in set (0.08 sec)

Event Timeline

• demon edited the content of this paste. (Show Details)May 1 2015, 4:26 PM

• demon changed the title of this paste from untitled to slow apiqueryallpages.

• demon updated the paste's language from autodetect to autodetect.

• demon mentioned this in T97797: ApiQueryAllPages is slow on langlinks edgecase.May 1 2015, 5:00 PM