Milimetric has submitted this change and it was merged.
Change subject: Add index on wiki_user
......................................................................
Add index on wiki_user
Improving performance of user name lookups by user id,
cohort and project.
Bug: 71255
Change-Id: I2a0003b3ad7d90b1bcc3eddf36f524961ff6abb5
---
A database_migrations/versions/483df9b9a389_add_index_to_wiki_user.py
1 file changed, 28 insertions(+), 0 deletions(-)
Approvals:
Milimetric: Verified; Looks good to me, approved
diff --git
a/database_migrations/versions/483df9b9a389_add_index_to_wiki_user.py
b/database_migrations/versions/483df9b9a389_add_index_to_wiki_user.py
new file mode 100644
index 0000000..b8a1a69
--- /dev/null
+++ b/database_migrations/versions/483df9b9a389_add_index_to_wiki_user.py
@@ -0,0 +1,28 @@
+"""empty message
+
+Revision ID: 483df9b9a389
+Revises: 1ba1b62367d4
+Create Date: 2014-10-17 00:15:40.976133
+
+"""
+
+# revision identifiers, used by Alembic.
+revision = '483df9b9a389'
+down_revision = '1ba1b62367d4'
+
+from alembic import op
+import sqlalchemy as sa
+from sqlalchemy.dialects import mysql
+
+
+def downgrade():
+ ### commands auto generated by Alembic - please adjust! ###
+ op.drop_index('ix_wiki_user_project', table_name='wiki_user')
+ ### end Alembic commands ###
+
+
+def upgrade():
+ ### commands auto generated by Alembic - please adjust! ###
+ op.create_index('ix_wiki_user_project', 'wiki_user',
+ ['project', 'mediawiki_userid', 'validating_cohort'],
unique=True)
+ ### end Alembic commands ###
--
To view, visit https://gerrit.wikimedia.org/r/167134
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I2a0003b3ad7d90b1bcc3eddf36f524961ff6abb5
Gerrit-PatchSet: 7
Gerrit-Project: analytics/wikimetrics
Gerrit-Branch: master
Gerrit-Owner: Nuria <[email protected]>
Gerrit-Reviewer: Mforns <[email protected]>
Gerrit-Reviewer: Milimetric <[email protected]>
Gerrit-Reviewer: Nuria <[email protected]>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
