[06:03:22] 10Blocked-on-schema-change, 10DBA: Schema change to rename user_newtalk indexes - https://phabricator.wikimedia.org/T234066 (10Marostegui) [06:06:48] 10Blocked-on-schema-change, 10DBA: Schema change to rename user_newtalk indexes - https://phabricator.wikimedia.org/T234066 (10Marostegui) [06:07:00] 10Blocked-on-schema-change, 10DBA: Schema change to rename user_newtalk indexes - https://phabricator.wikimedia.org/T234066 (10Marostegui) 05Open→03Resolved All done [06:15:58] 10DBA, 10Patch-For-Review: Decommission db2062.codfw.wmnet - https://phabricator.wikimedia.org/T238726 (10ops-monitoring-bot) cookbooks.sre.hosts.decommission executed by marostegui@cumin1001 for hosts: `db2062.codfw.wmnet` - db2062.codfw.wmnet (**PASS**) - Downtimed host on Icinga - Downtimed management... [06:19:10] 10DBA, 10Operations: Decommission db2043-db2070 - https://phabricator.wikimedia.org/T228258 (10Marostegui) [06:49:14] 10DBA: Compress new Wikibase tables - https://phabricator.wikimedia.org/T232446 (10Marostegui) [07:10:36] 10DBA: Remove partitions from revision table - https://phabricator.wikimedia.org/T239453 (10Marostegui) [07:10:48] 10DBA: Remove partitions from revision table - https://phabricator.wikimedia.org/T239453 (10Marostegui) p:05Triage→03Normal [07:13:09] 10DBA, 10Core Platform Team, 10MW-1.34-notes (1.34.0-wmf.24; 2019-09-24), 10Performance Issue, 10mariadb-optimizer-bug: Review special replica partitioning of certain tables by `xx_user` - https://phabricator.wikimedia.org/T223151 (10Marostegui) Nothing has showed up with db1089, so I believe we should s... [08:34:54] 10DBA: Remove partitions from revision table - https://phabricator.wikimedia.org/T239453 (10Marostegui) [09:17:12] 10DBA: Remove partitions from revision table - https://phabricator.wikimedia.org/T239453 (10Marostegui) I have put the ALTERs in separate transactions, because I am finding something weird when testing it on my lab. I have reported it to MariaDB just in case: https://jira.mariadb.org/browse/MDEV-21176 [09:20:53] 10Blocked-on-schema-change, 10DBA, 10Core Platform Team: Schema change for refactored actor and comment storage - https://phabricator.wikimedia.org/T233135 (10Marostegui) [09:44:31] 10DBA: Remove ar_comment from sanitarium triggers - https://phabricator.wikimedia.org/T234704 (10Marostegui) [11:03:13] 10DBA, 10TechCom-RFC: MediaWiki database policy and/or guidelines (2019) - https://phabricator.wikimedia.org/T220056 (10daniel) Looks good to me. This isn't really written like a policy, but it'll serve the purpose. If the wording causes problems in practice, we can amend. [13:41:14] 10DBA: Remove partitions from revision table - https://phabricator.wikimedia.org/T239453 (10Marostegui) MariaDB confirmed it is a bug: https://jira.mariadb.org/browse/MDEV-21176?focusedCommentId=138891&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-138891 [18:25:04] 10Blocked-on-schema-change, 10DBA, 10Core Platform Team: Schema change for refactored actor and comment storage - https://phabricator.wikimedia.org/T233135 (10Marostegui)