Page MenuHomePhabricator
Create Task
Maniphest T284221

Schema change for adding oi_timestamp on oldimage table
Closed, ResolvedPublic
Actions

Description

Context: T279982: Add index on oi_timestamp

  1. ALTERs to run: https://gerrit.wikimedia.org/r/c/mediawiki/core/+/682233/5/maintenance/archives/patch-oldimage-oi_timestamp.sql
  2. Where to run those changes: all.dblist
  3. When to run those changes: At any time
  4. If the schema change is backwards compatible: Yes
  5. If the schema change has been tested already on some of the test/beta wikis: Tested in beta cluster.
  6. if the data should be made available on the labs replicas and/or dumps: public, replicated to the cloud

Progress

  • labswiki
  • labtestwiki

Related Objects

Event Timeline

Ladsgroup created this task.Jun 3 2021, 1:35 PM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 3 2021, 1:35 PM
Ladsgroup renamed this task from SChema change for adding oi_timestamp on oldimage table to Schema change for adding oi_timestamp on oldimage table.Jun 3 2021, 1:36 PM
Ladsgroup mentioned this in T279982: Add index on oi_timestamp.Jun 3 2021, 1:41 PM
Marostegui claimed this task.Jun 4 2021, 5:15 AM
Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to In progress on the DBA board.
Marostegui moved this task from Backlog to In progress on the Schema-change-in-production board.
Marostegui updated the task description. (Show Details)Jun 4 2021, 5:17 AM
Marostegui added a comment.EditedJun 4 2021, 5:22 AM

Deployed on s6 codfw and on db1096:3316 and db1098:3316
Let's wait a few days to make sure there're no regressions on the optimizer decisions when querying this table.

s6 eqiad

  • dbstore1005
  • db1180
  • db1173
  • db1168
  • db1165
  • db1155
  • db1140
  • db1131
  • db1113
  • db1098
  • db1096
  • clouddb1021
  • clouddb1019
  • clouddb1015
Marostegui updated the task description. (Show Details)Jun 4 2021, 5:22 AM
Marostegui updated the task description. (Show Details)Jun 7 2021, 5:46 AM

s6 is fully done - waiting a few days before proceeding with the next section to make sure no optimizer changes are present (I couldn't find anything related on db1096/db1098) after the weekend.

Marostegui updated the task description. (Show Details)Jun 7 2021, 6:34 AM
Marostegui updated the task description. (Show Details)Jun 9 2021, 10:42 AM
Marostegui added a comment.EditedJun 9 2021, 10:49 AM

s5 progress

  • dbstore1003
  • db1161
  • db1154
  • db1150
  • db1145
  • db1144
  • db1130
  • db1113
  • db1110
  • db1100
  • db1096
  • clouddb1021
  • clouddb1020
  • clouddb1016
Marostegui updated the task description. (Show Details)Jun 9 2021, 11:28 AM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.Jun 9 2021, 11:31 AM

s2 eqiad

  • dbstore1007
  • dbstore1004
  • db1182
  • db1171
  • db1170
  • db1162
  • db1156
  • db1155
  • db1146
  • db1129
  • db1122
  • db1105
  • db1102
  • clouddb1021
  • clouddb1018
  • clouddb1014
Marostegui updated the task description. (Show Details)Jun 9 2021, 11:32 AM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.Jun 9 2021, 11:35 AM

s8 eqiad

  • dbstore1005
  • db1178
  • db1177
  • db1172
  • db1167
  • db1154
  • db1126
  • db1116
  • db1114
  • db1111
  • db1109
  • db1104
  • db1101
  • db1099
  • clouddb1021
  • clouddb1020
  • clouddb1016
Marostegui updated the task description. (Show Details)Jun 9 2021, 11:35 AM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.Jun 9 2021, 11:39 AM

s7 eqiad

  • dbstore1003
  • db1181
  • db1174
  • db1170
  • db1158
  • db1155
  • db1136
  • db1127
  • db1116
  • db1101
  • db1098
  • clouddb1021
  • clouddb1018
  • clouddb1014
Marostegui updated the task description. (Show Details)Jun 9 2021, 11:40 AM
Marostegui updated the task description. (Show Details)Jun 9 2021, 11:42 AM
Marostegui added a comment.EditedJun 9 2021, 11:50 AM

s4 eqiad

  • dbstore1007
  • dbstore1004
  • db1160
  • db1155
  • db1150
  • db1149
  • db1148
  • db1147
  • db1146
  • db1145
  • db1144
  • db1143
  • db1142
  • db1141
  • db1138
  • db1121
  • clouddb1021
  • clouddb1019
  • clouddb1015
Marostegui updated the task description. (Show Details)Jun 9 2021, 11:59 AM
Marostegui updated the task description. (Show Details)Jun 9 2021, 12:21 PM
Marostegui updated the task description. (Show Details)
Marostegui added a comment.Jun 9 2021, 12:26 PM

s1 eqiad

  • dbstore1003
  • db1184
  • db1169
  • db1164
  • db1163
  • db1154
  • db1140
  • db1139
  • db1135
  • db1134
  • db1133
  • db1119
  • db1118
  • db1106
  • db1105
  • db1099
  • clouddb1021
  • clouddb1017
  • clouddb1013
Marostegui updated the task description. (Show Details)Jun 9 2021, 12:26 PM
Marostegui updated the task description. (Show Details)Jun 9 2021, 12:30 PM
Marostegui added a comment.EditedJun 9 2021, 12:39 PM

s3 eqiad

  • dbstore1007
  • dbstore1004
  • db1179
  • db1175
  • db1171
  • db1166
  • db1157
  • db1154
  • db1123
  • db1112
  • db1102
  • clouddb1021
  • clouddb1017
  • clouddb1013
Marostegui updated the task description. (Show Details)Jun 9 2021, 1:42 PM
Marostegui added a comment.Jun 10 2021, 5:07 AM

All done

Marostegui closed this task as Resolved.Jun 10 2021, 5:07 AM
Marostegui updated the task description. (Show Details)
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL