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