Mforns has uploaded a new change for review. https://gerrit.wikimedia.org/r/190404
Change subject: Add SQL script to create indexes in EL Edit tables ...................................................................... Add SQL script to create indexes in EL Edit tables Bug: T89256 Change-Id: Ic0147336e88429c234b3c9f6d99fd504ae1b6d3e --- A analytics-store/log/Edit_12345_indeces.sql 1 file changed, 14 insertions(+), 0 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/data-warehouse refs/changes/04/190404/1 diff --git a/analytics-store/log/Edit_12345_indeces.sql b/analytics-store/log/Edit_12345_indeces.sql new file mode 100644 index 0000000..bf9ba23 --- /dev/null +++ b/analytics-store/log/Edit_12345_indeces.sql @@ -0,0 +1,14 @@ +-- This script creates indeces for EventLogging Edit tables +-- to speed up scheduled queries, including funnel data extraction. +-- See related task: https://phabricator.wikimedia.org/T89256. + +-- Note the fake numbers in the index and table names, +-- replace them with your table version. + +CREATE INDEX ix_Edit_12345_event_action + ON Edit_12345 (event_action) + USING HASH; + +CREATE INDEX ix_Edit_12345_event_editingSessionId + ON Edit_12345 (event_editingSessionId) + USING HASH; -- To view, visit https://gerrit.wikimedia.org/r/190404 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ic0147336e88429c234b3c9f6d99fd504ae1b6d3e Gerrit-PatchSet: 1 Gerrit-Project: analytics/data-warehouse Gerrit-Branch: master Gerrit-Owner: Mforns <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
