Adjust the flow_tree_descendant_id_revisions index overhead
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	EBernhardson
	Mar 13 2014, 8:25 PM

Description

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.

Version: unspecified
Severity: normal

		Status	Subtype	Assigned	Task
		Invalid		None	T51188 [DO NOT USE] Schema changes for Wikimedia wikis (tracking) [superseded by #Blocked-on-schema-change]
		Resolved		• Springle	T64617 Adjust the flow_tree_descendant_id_revisions index overhead

• bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 3:07 AM

• bzimport set Reference to bz62617.