[04:50:30] 10DBA, 10MediaWiki-API, 10Performance: list=logevents slow for users with last log action long time ago - https://phabricator.wikimedia.org/T71222 (10Marostegui) This weird query plan still happens with the new release 10.1.39 [05:08:21] 10DBA, 10Goal, 10Patch-For-Review: Productionize db2[103-120] - https://phabricator.wikimedia.org/T222772 (10Marostegui) [05:18:06] 10DBA, 10Goal, 10Patch-For-Review: Productionize db11[26-38] - https://phabricator.wikimedia.org/T222682 (10Marostegui) [05:39:49] 10DBA, 10Goal, 10Patch-For-Review: Implement database binary backups into the production infrastructure - https://phabricator.wikimedia.org/T206203 (10Marostegui) >>! In T206203#5172971, @jcrespo wrote: > Things pending I would like to work on: > > * Proper documentation > * Identify failures after X amount... [06:08:28] 10DBA: Compress and defragment tables on labsdb hosts - https://phabricator.wikimedia.org/T222978 (10Marostegui) Compressing the following tables on all wikis will probably make a big difference already, as they are pretty big and they are not compressed: ` slots revision_actor_temp revision_comment_temp comment... [09:30:43] 10DBA, 10Goal, 10Patch-For-Review: Productionize db2[103-120] - https://phabricator.wikimedia.org/T222772 (10Marostegui) [15:33:34] 10DBA, 10MediaWiki-Configuration, 10Operations, 10Patch-For-Review, and 2 others: Create tool to handle the state of database configuration in MediaWiki in etcd - https://phabricator.wikimedia.org/T197126 (10CDanis) Here's my tentative plan for moving forward with this, including a rollout procedure: [ ]... [15:36:26] 10DBA, 10MediaWiki-Configuration, 10Operations, 10Patch-For-Review, and 2 others: Create tool to handle the state of database configuration in MediaWiki in etcd - https://phabricator.wikimedia.org/T197126 (10CDanis) a:05Joe→03CDanis [16:19:47] 10DBA, 10MediaWiki-Configuration, 10Operations, 10Patch-For-Review, and 2 others: Create tool to handle the state of database configuration in MediaWiki in etcd - https://phabricator.wikimedia.org/T197126 (10CDanis) >>! In T197126#5177169, @jcrespo wrote: > It would be nice to have a mockup of the API to t... [17:50:32] 10DBA, 10Core Platform Team Backlog (Watching / External): Review special replica partitioning of certain tables by `xx_user` - https://phabricator.wikimedia.org/T223151 (10Anomie) [19:59:04] 10DBA, 10Core Platform Team Backlog (Watching / External): Review special replica partitioning of certain tables by `xx_user` - https://phabricator.wikimedia.org/T223151 (10Marostegui) Thanks for raising this. Keep in mind that `revision` or `logging` are partitioned, as you pointed out, only on the special sl... [21:55:37] 10DBA, 10Jade, 10Operations, 10TechCom-RFC, and 2 others: Introduce a new namespace for collaborative judgements about wiki entities - https://phabricator.wikimedia.org/T200297 (10Harej) It is my understanding that outstanding issues with Jade have been addressed. As requested I have moved this to the Inbo...