https://bugzilla.wikimedia.org/show_bug.cgi?id=58418
Web browser: ---
Bug ID: 58418
Summary: pagelinks table could use additional index to speed up
Special:MostLinkedPages
Product: MediaWiki
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Mobile Platform: ---
The query used to generate Special:MostLinkedPages takes a very long time to
run when the pagelinks table is large. (On my system, with 3 million rows, the
query takes over 30 seconds, resulting in 502s to our load balancer.) Adding an
index on (pl_namespace, pl_title) cuts that by around 60% (10 seconds on my
system). It was suggested on IRC that this would also benefit
Special:Whatlinkshere.
--
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
