Bug ID: 62617
           Summary: Adjust the flow_tree_descendant_id_revisions index
           Product: Wikimedia
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: General/Unknown
       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:


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.

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

Reply via email to