Map of database maintenance

Here you can follow maintenance on our databases. This is useful to spot potential causes for issues in production or avoid interfering with another maintenance work.

A script parses dbctl SAL logs and add entries here. Furthermore, DBAs can add manual entries in this list by logging SAL. It is important that SAL must contain the word "dbmaint", a phabricator ticket id, a section name and name of the datacenter. For example: "!log dbmaint on s2@codfw (T12345)"

Yesterday (2022-07-05)

eqiad

Section	Work
s1	Investigate mariadb 10.6 performance regression during spikes/high load (T311106) (ladsgroup)
s6	Fix mismatching field type of page.page_touched on wmf wikis (T298557) (marostegui) Switchover s6 master db1131 -> db1173 (T311522) (marostegui)

Last seven days

eqiad

Section	Work
s1	Make user_editcount unsigned in production (T309311) (ladsgroup) Investigate mariadb 10.6 performance regression during spikes/high load (T311106) (ladsgroup)
s3	Fix mismatching field type of user table for columns user_newpassword, user_password, user_email on wmf wikis (T307525) (ladsgroup) Make user_editcount unsigned in production (T309311) (ladsgroup)
s5	Add lu_attachment_method column to localuser table (T305300) (ladsgroup) Fix enwikivoyage drifts on pagelinks (T312027) (ladsgroup)
s6	Fix mismatching field type of page.page_touched on wmf wikis (T298557) (marostegui) Switchover s6 master db1131 -> db1173 (T311522) (marostegui)
s8	Make user_editcount unsigned in production (T309311) (ladsgroup)
x1	Switchover x1 master (db1103 -> db1120) (T300472) (marostegui)