Last modified: 2014-03-14 01:01:00 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 T64617, the corresponding Phabricator task for complete and up-to-date bug report information.

Bug 62617 - Adjust the flow_tree_descendant_id_revisions index overhead


Summary:	Adjust the flow_tree_descendant_id_revisions index overhead

Status:	RESOLVED FIXED

Product:	Wikimedia
Classification:	Unclassified
Component:	General/Unknown (Other open bugs)
Version:	unspecified
Hardware:	All All

Importance:	Unprioritized normal (vote)
Target Milestone:	---
Assigned To:	Sean Pringle

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:	49188
	Show dependency tree / graph

Reported:	2014-03-13 20:25 UTC by Erik Bernhardson
Modified:	2014-03-14 01:01 UTC (History)
CC List:	0 users

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

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

Description Erik Bernhardson 2014-03-13 20:25:55 UTC

Short description:

tree_rev_id is a primary key which is already unique, it would cause
extra overhead to enforce unique on (tree_rev_descendant_id, tree_rev_id)

Which wikis are affected:

flowdb on the external(non-wiki) cluster

Which tables:

flow_tree_revision

What is the change to those tables:

DROP INDEX /*i*/flow_tree_descendant_id_revisions ON /*_*/flow_tree_revision;
CREATE INDEX /*i*/flow_tree_descendant_rev_id
    ON /*_*/flow_tree_revision ( tree_rev_descendant_id, tree_rev_id );

Links to gerrit changes and/or other related bug reports.

https://gerrit.wikimedia.org/r/#/c/116226/

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

Wikimedia Bugzilla is closed!

Search

Personal tools

Navigation

Links