[05:57:22] <wikibugs>	 10DBA, 10Patch-For-Review: Remove partitions from revision table - https://phabricator.wikimedia.org/T239453 (10Marostegui)
[06:18:42] <wikibugs>	 10DBA, 10Expiring-Watchlist-Items, 10Community-Tech (Kanban-Q3-2019-20), 10Core Platform Team Workboards (Clinic Duty Team): Create required table for new Watchlist Expiry feature - https://phabricator.wikimedia.org/T240094 (10Marostegui) >>! In T240094#5724068, @aezell wrote: > I think there are also perf...
[13:32:57] <wikibugs>	 10DBA: Productionize es1020-es1025, es2020-es2025 - https://phabricator.wikimedia.org/T243052 (10Marostegui) Grants are a bit of mess, I have cleaned them up a bit and left this on codfw hosts (and will do the same with eqiad ones):  ` root@es2020.codfw.wmnet[(none)]> select user,host from mysql.user where user...
[13:33:53] <wikibugs>	 10DBA: Productionize es1020-es1025, es2020-es2025 - https://phabricator.wikimedia.org/T243052 (10Marostegui) I think we should also remove `'wikiadmin'@'10.%` and change it by 10.64.% and 10.192.%
[13:34:39] <wikibugs>	 10DBA: Productionize es1020-es1025, es2020-es2025 - https://phabricator.wikimedia.org/T243052 (10Marostegui) And probably the same for `root` user, 10.64 and 10.192.%
[13:47:01] <wikibugs>	 10DBA: Clean up wikiadmin2 user from es hosts - https://phabricator.wikimedia.org/T243512 (10Marostegui)
[13:57:18] <wikibugs>	 10DBA: Clean up wikiadmin2 user from es hosts - https://phabricator.wikimedia.org/T243512 (10Marostegui) It exists on:  es1: es2013 es2012 es1018 es1016 es1012  es2: es2016.codfw.wmnet es2015.codfw.wmnet es2014.codfw.wmnet es1015.eqiad.wmnet es1013.eqiad.wmnet es1011.eqiad.wmnet  es3 es2019.codfw.wmnet es2018.co...
[13:57:28] <wikibugs>	 10DBA: Clean up wikiadmin2 user from core hosts - https://phabricator.wikimedia.org/T243512 (10Marostegui)
[14:04:55] <wikibugs>	 10DBA: Clean up wikiadmin2 user from core hosts - https://phabricator.wikimedia.org/T243512 (10Marostegui)
[14:18:30] <wikibugs>	 10DBA: Clean up wikiadmin2 user from core hosts - https://phabricator.wikimedia.org/T243512 (10Marostegui)
[14:27:23] <jynus>	 does dbstore1005 has perf issues? https://grafana.wikimedia.org/d/000000273/mysql?orgId=1&fullscreen&panelId=6&from=1579572384357&to=1579789597800&var-dc=eqiad%20prometheus%2Fops&var-server=dbstore1005&var-port=13318
[14:27:34] <marostegui>	 no, there are heavy queries
[14:27:38] <marostegui>	 against wikidata
[14:27:41] <marostegui>	 from research
[14:27:44] <jynus>	 is there a migration?
[14:27:49] <jynus>	 ah, reads you mean?
[14:28:04] <marostegui>	 yeah, reads
[14:34:54] <wikibugs>	 10DBA, 10Wikimedia-Rdbms, 10Core Platform Team Workboards (Clinic Duty Team): Sync understanding of MediaWiki rdbms 'weight' behaviour with DBAs - https://phabricator.wikimedia.org/T239900 (10Marostegui) Ideally I would love to see old and read-only hosts (es1, es2) not being treated as a replication topolog...
[15:19:20] <wikibugs>	 10DBA: il_from not always the same size - https://phabricator.wikimedia.org/T243519 (10Milimetric)
[15:19:53] <wikibugs>	 10DBA: il_from not always the same size - https://phabricator.wikimedia.org/T243519 (10Milimetric)
[15:20:29] <wikibugs>	 10DBA: il_from not always the same size - https://phabricator.wikimedia.org/T243519 (10Marostegui) The value is just a display value, it doesn't affect the real operation or data under it.
[15:24:23] <wikibugs>	 10DBA: il_from not always the same size - https://phabricator.wikimedia.org/T243519 (10jcrespo) Please note that `int(8) unsigned` and `int(10) unsigned` are all the exact same actual data type (4 byte integer, from 0 to 4294967295). https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html  > the dis...
[18:51:06] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: (Needed by 31st January) eqiad: rack/setup/install  es102[0-5].eqiad.wmnet - https://phabricator.wikimedia.org/T241359 (10Cmjohnson) @marostegui I do not know yet, there are several racking/setup tasks that I am trying to get through.  I need to check with @Jclark-ctr and se...
[20:27:55] <wikibugs>	 10DBA: Compress new Wikibase tables - https://phabricator.wikimedia.org/T232446 (10bd808)
[20:47:01] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad: (Needed by 31st January) eqiad: rack/setup/install  es102[0-5].eqiad.wmnet - https://phabricator.wikimedia.org/T241359 (10Marostegui) >>! In T241359#5827691, @Cmjohnson wrote: > @marostegui I do not know yet, there are several racking/setup tasks that I am trying to get thro...