https://bugzilla.wikimedia.org/show_bug.cgi?id=62617
Bug ID: 62617
Summary: Adjust the flow_tree_descendant_id_revisions index
overhead
Product: Wikimedia
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: General/Unknown
Assignee: wikibugs-l@lists.wikimedia.org
Reporter: ebernhard...@wikimedia.org
Web browser: ---
Mobile Platform: ---
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/
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
