slow_apiqueryallpages
No One
Actions

Authored By

	• demon
	May 1 2015, 4:26 PM

Size

1 KB

Referenced Files

None

Subscribers

None

slow_apiqueryallpages
View Options

	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)

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 155019
Default Alt Text: slow_apiqueryallpages (1 KB)

Event Timeline