Jump to content

Nova Resource:Analytics/Slave database indexes

From Wikitech

This page documents custom indexes that have been added to the analytics slave databases.

  • s1-analytics-slave.eqiad.wmnet
    • enwiki
      • CREATE INDEX usertext_timestamp ON revision (rev_user_text, rev_timestamp, rev_user, rev_deleted, rev_minor_edit, rev_text_id, rev_comment;)
      • CREATE INDEX user_text_timestamp ON revision (rev_user, rev_user_text, rev_timestamp);
      • CREATE INDEX rev_timestamp_user ON revision (rev_timestamp, rev_user);
      • CREATE INDEX user_timestamp ON archive (ar_user, ar_timestamp);
        /* Matches user_timestamp on revision. Allows high performance joins with user. */
      • CREATE INDEX page_timestamp ON archive (ar_page_id, ar_timestamp);
  • s5-analytics-slave.eqiad.wmnet
    • dewiki
      • CREATE INDEX user_timestamp ON archive (ar_user, ar_timestamp);
        /* Matches user_timestamp on revision. Allows high performance joins with user. */
Retrieved from "https://wikitech.wikimedia.org/w/index.php?title=Nova_Resource:Analytics/Slave_database_indexes&oldid=109645"