https://bugzilla.wikimedia.org/show_bug.cgi?id=57176
Web browser: ---
Bug ID: 57176
Summary: ApiQueryExtLinksUsage::run query has crazy limit
Product: MediaWiki
Version: 1.21.3
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Mobile Platform: ---
Crazy limit offsets like this are showing up in slow query logs for enwiki:
SELECT /* ApiQueryExtLinksUsage::run */
page_id,page_namespace,page_title,el_to FROM `page`,`externallinks` WHERE
(page_id=el_from) AND (el_index LIKE 'http://gov.nih.nlm.ncbi.%' ) LIMIT
768500,501;
By itself it's not too bad, < 10 seconds, but they're appearing in spikes
presumably from something automated and causing concurrency issues.
Suggest disallowing such page offsets or redesigning the pagination method.
--
You are receiving this mail because:
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
