Page MenuHomePhabricator

Add `gemm_mentee_is_active` column to growthexperiments_mentor_mentee x1 table
Closed, ResolvedPublic

Description

Part of T318457.

  1. ALTERs to run: DROP INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee; ALTER TABLE /*_*/growthexperiments_mentor_mentee ADD gemm_mentee_is_active TINYINT(1) DEFAULT 1 NOT NULL; CREATE INDEX gemm_mentor ON /*_*/growthexperiments_mentor_mentee ( gemm_mentor_id, gemm_mentee_is_active );, see patch
  2. Where to run those changes: growthexperiments.dblist, per-wiki x1 databases
  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: Schema change is deployed at beta wikis, but the accompanying feature is in-development (see parent task).
  6. if the data should be made available on the labs replicas and/or dumps: The table only contains public data. It is included in dumps, and the new column should be included there as well.

Event Timeline

Tagging with team-specific tags for (internal) visibility.

Marostegui triaged this task as Medium priority.
Marostegui moved this task from Triage to In progress on the DBA board.
Marostegui subscribed.

This requires switching x1 to SBR for a bit. I will work on it

Wikis:

1abwiki
2acewiki
3adywiki
4afwiki
5akwiki
6alswiki
7altwiki
8amiwiki
9amwiki
10angwiki
11anwiki
12arcwiki
13arwiki
14arywiki
15arzwiki
16astwiki
17aswiki
18atjwiki
19avkwiki
20avwiki
21awawiki
22aywiki
23azbwiki
24azwiki
25banwiki
26barwiki
27bat_smgwiki
28bawiki
29bclwiki
30be_x_oldwiki
31bewiki
32bgwiki
33bhwiki
34biwiki
35bjnwiki
36bmwiki
37bnwiki
38bowiki
39bpywiki
40brwiki
41bswiki
42bugwiki
43bxrwiki
44cawiki
45cbk_zamwiki
46cdowiki
47cebwiki
48cewiki
49chrwiki
50chwiki
51chywiki
52ckbwiki
53cowiki
54crhwiki
55crwiki
56csbwiki
57cswiki
58cuwiki
59cvwiki
60cywiki
61dagwiki
62dawiki
63dewiki
64dinwiki
65diqwiki
66dsbwiki
67dtywiki
68dvwiki
69dzwiki
70eewiki
71elwiki
72emlwiki
73enwiki
74eowiki
75eswiki
76etwiki
77euwiki
78extwiki
79fawiki
80ffwiki
81fiu_vrowiki
82fiwiki
83fjwiki
84fowiki
85frpwiki
86frrwiki
87frwiki
88frwiktionary
89furwiki
90fywiki
91gagwiki
92ganwiki
93gawiki
94gcrwiki
95gdwiki
96glkwiki
97glwiki
98gnwiki
99gomwiki
100gorwiki
101gotwiki
102guwiki
103gvwiki
104hakwiki
105hawiki
106hawwiki
107hewiki
108hifwiki
109hiwiki
110hrwiki
111hsbwiki
112htwiki
113huwiki
114hywiki
115hywwiki
116iawiki
117idwiki
118iewiki
119igwiki
120ikwiki
121ilowiki
122inhwiki
123iowiki
124iswiki
125itwiki
126iuwiki
127jamwiki
128jawiki
129jbowiki
130jvwiki
131kaawiki
132kabwiki
133kawiki
134kbdwiki
135kbpwiki
136kgwiki
137kiwiki
138kkwiki
139klwiki
140kmwiki
141knwiki
142koiwiki
143kowiki
144krcwiki
145kshwiki
146kswiki
147kuwiki
148kvwiki
149kwwiki
150kywiki
151ladwiki
152lawiki
153lbewiki
154lbwiki
155lezwiki
156lfnwiki
157lgwiki
158lijwiki
159liwiki
160lldwiki
161lmowiki
162lnwiki
163lowiki
164ltgwiki
165ltwiki
166lvwiki
167madwiki
168maiwiki
169map_bmswiki
170mdfwiki
171mgwiki
172mhrwiki
173minwiki
174miwiki
175mkwiki
176mlwiki
177mniwiki
178mnwiki
179mnwwiki
180mrjwiki
181mrwiki
182mswiki
183mtwiki
184mwlwiki
185myvwiki
186mywiki
187mznwiki
188nahwiki
189napwiki
190nawiki
191nds_nlwiki
192ndswiki
193newiki
194newwiki
195niawiki
196nlwiki
197nnwiki
198novwiki
199nowiki
200nqowiki
201nrmwiki
202nsowiki
203nvwiki
204nywiki
205ocwiki
206olowiki
207omwiki
208orwiki
209oswiki
210pagwiki
211pamwiki
212papwiki
213pawiki
214pcdwiki
215pdcwiki
216pflwiki
217pihwiki
218piwiki
219plwiki
220pmswiki
221pnbwiki
222pntwiki
223pswiki
224ptwiki
225pwnwiki
226quwiki
227rmwiki
228rmywiki
229rnwiki
230roa_rupwiki
231roa_tarawiki
232rowiki
233ruewiki
234ruwiki
235rwwiki
236sahwiki
237satwiki
238sawiki
239scnwiki
240scowiki
241scwiki
242sdwiki
243sewiki
244sgwiki
245shiwiki
246shnwiki
247shwiki
248simplewiki
249siwiki
250skrwiki
251skwiki
252slwiki
253smnwiki
254smwiki
255snwiki
256sowiki
257sqwiki
258srnwiki
259srwiki
260sswiki
261stqwiki
262stwiki
263suwiki
264svwiki
265swwiki
266szlwiki
267szywiki
268tawiki
269taywiki
270tcywiki
271test2wiki
272testwiki
273tetwiki
274tewiki
275tgwiki
276thwiki
277tiwiki
278tkwiki
279tlwiki
280tnwiki
281towiki
282tpiwiki
283trvwiki
284trwiki
285tswiki
286ttwiki
287tumwiki
288twwiki
289tyvwiki
290tywiki
291udmwiki
292ugwiki
293ukwiki
294urwiki
295uzwiki
296vecwiki
297vepwiki
298vewiki
299viwiki
300vlswiki
301vowiki
302warwiki
303wawiki
304wowiki
305wuuwiki
306xalwiki
307xhwiki
308xmfwiki
309yiwiki
310yowiki
311zawiki
312zeawiki
313zh_classicalwiki
314zh_min_nanwiki
315zh_yuewiki
316zhwiki
317zuwiki

Change 849548 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] mariadb: Switch x1 to STATEMENT

https://gerrit.wikimedia.org/r/849548

Change 849548 merged by Marostegui:

[operations/puppet@production] mariadb: Switch x1 to STATEMENT

https://gerrit.wikimedia.org/r/849548

Mentioned in SAL (#wikimedia-operations) [2022-10-27T05:28:25Z] <marostegui> dbmaint Switch x1 to SBR T318518

Mentioned in SAL (#wikimedia-operations) [2022-10-27T05:35:08Z] <marostegui> Deploy schema change on x1 T318518

This is all done.
I am going to revert x1 back to RBR

Thanks! The column looks as expected & intended.