Last modified: 2007-01-16 16:21:39 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 6440 - Change existing indexes to significantly increase query performance
Change existing indexes to significantly increase query performance
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.7.x
PC Windows XP
: Normal enhancement with 1 vote (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-06-26 04:18 UTC by Yuri Astrakhan
Modified: 2007-01-16 16:21 UTC (History)
0 users

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


Attachments

Description Yuri Astrakhan 2006-06-26 04:18:54 UTC
To substantially improve the performance of the queries that retrieve
backlink/template/image information, I would like to propose an index change to
these tables:

pagelinks:     pl_namespace index: add pl_from
templatelinks: tl_namespace index: add tl_from
imagelinks:    il_to index:        add il_from

The additional field will allow multi-page queries to limit results and have an
easy way to continue the query without using filesort.

Additionally, I suspect that because the *_from fields are needed in the output,
having it as part of the index removes the need to actually read the table, but
rather MySQL will get all fields from the index itself. Since every “what points
to X / where is X embedded”  query uses the *_from field, it would be of benefit
as well.
Comment 1 Yuri Astrakhan 2006-08-23 23:50:43 UTC
All proposed DB changes are now at
http://meta.wikimedia.org/wiki/Proposed_Database_Schema_Changes
Comment 2 Rob Church 2007-01-15 10:26:20 UTC
These all appear to have been added some time ago.
Comment 3 Yuri Astrakhan 2007-01-16 16:21:39 UTC
Please confirm these have been applied to the mediawiki servers. The code has
been checked in a while back.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links