[05:52:48] 10DBA, 13Patch-For-Review: run pt-table-checksum on s2 (WAS: run pt-table-checksum before decommissioning db1015, db1035,db1044,db1038) - https://phabricator.wikimedia.org/T154485#3166510 (10Marostegui) That is great, one step further to be able to decommission those hosts finally :-) [09:19:33] 07Blocked-on-schema-change, 10Wikidata, 03Wikidata-Sprint: Deploy schema change for adding term_full_entity_id column to wb_terms table - https://phabricator.wikimedia.org/T162539#3166532 (10Ladsgroup) [09:21:44] 07Blocked-on-schema-change, 10Wikidata, 03Wikidata-Sprint: Deploy schema change for adding term_full_entity_id column to wb_terms table - https://phabricator.wikimedia.org/T162539#3166546 (10Ladsgroup) [17:48:25] 10DBA, 10Wikidata, 07Performance, 15User-Daniel: DispatchChanges: Avoid long-lasting connections to the master DB - https://phabricator.wikimedia.org/T151681#3166880 (10hoo) [17:48:29] 10DBA, 10Wikidata, 13Patch-For-Review, 07Performance, and 3 others: Implement ChangeDispatchCoordinator based on RedisLockManager - https://phabricator.wikimedia.org/T151993#3166878 (10hoo) 05Open>03Resolved Closing this particular task (which only holds some of the things we need to do in order to act... [18:31:15] 10DBA, 10Wikidata, 07Performance, 15User-Daniel: Consider only updating wb_changes_dispatch after a successful run - https://phabricator.wikimedia.org/T162556#3166925 (10hoo) [18:43:41] 10DBA, 10Wikidata, 07Performance, 15User-Daniel: Use replica for reading the last dispatch position (chd_seen) - https://phabricator.wikimedia.org/T162557#3166941 (10hoo) [18:45:13] 10DBA, 10Wikidata, 07Performance, 15User-Daniel: Use replica for reading the last dispatch position (chd_seen) - https://phabricator.wikimedia.org/T162557#3166941 (10hoo) [18:50:39] 10DBA, 10Wikidata, 07Performance, 15User-Daniel: Use memcached (or something similar) to keep the latest chd_seen state, only flush to table every once in a while - https://phabricator.wikimedia.org/T162558#3166957 (10hoo) [20:13:50] 10DBA, 10Wikidata, 13Patch-For-Review, 07Technical-Debt: [Task] Use uppercase entity ID in wb_changes table. - https://phabricator.wikimedia.org/T109825#3167050 (10hoo) a:03hoo [20:31:25] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10MediaWiki-extensions-WikibaseRepository, 10Wikidata: Choose a field length for entity id columns and stick to it - https://phabricator.wikimedia.org/T162562#3167056 (10hoo) [21:14:56] 10DBA, 10Wikimedia-Site-requests, 13Patch-For-Review: Recreate a wiki for Wikimedia Portugal - https://phabricator.wikimedia.org/T126832#3167090 (10waldyrious) Just pinging to make sure this hasn't fallen off the radar :) is there anything blocking the scheduling? [21:29:47] 10DBA, 10Wikidata, 07Performance, 15User-Daniel: Use memcached (or something similar) to keep the latest chd_seen state, only flush to table every once in a while - https://phabricator.wikimedia.org/T162558#3167093 (10daniel) This basically proposes a write buffer. We should try hard to always flush when a... [21:54:29] 10DBA, 10MediaWiki-Maintenance-scripts: How to re-run claimed jobs? - https://phabricator.wikimedia.org/T162565#3167127 (10Zoglun)