Last modified: 2014-01-21 01:14:06 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T60418, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 58418 - pagelinks table could use additional index to speed up Special:MostLinkedPages
pagelinks table could use additional index to speed up Special:MostLinkedPages
Status: NEW
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.23.0
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
: performance
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2013-12-12 22:54 UTC by jclbugz
Modified: 2014-01-21 01:14 UTC (History)
3 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description jclbugz 2013-12-12 22:54:26 UTC 
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.
Comment 1 MZMcBride 2014-01-21 01:14:06 UTC 
I believe Special:MostLinkedPages is disabled on Wikimedia wikis due to performance considerations. It would be nice to at least get an estimate of the cost involved (additional indices, space on disk, etc.) in making it work well enough for a large site. Of course the "pagelinks" tables are probably some of the largest.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links