[07:48:19] 10DBA, 10Wikimedia-Site-requests: Rename user Darwinius to DarwIn - https://phabricator.wikimedia.org/T173159#3520102 (10MarcoAurelio) [11:34:51] 10DBA, 10Wikimedia-Site-requests: Rename user Darwinius to DarwIn - https://phabricator.wikimedia.org/T173159#3520381 (10MarcoAurelio) [13:03:17] 10DBA, 10MediaWiki-Database, 10MediaWiki-Logging, 10Performance, 10Schema-change: Logging needs an index to optimize searching by log_title - https://phabricator.wikimedia.org/T68961#3520447 (10Huji) @aaron this requires your attention. If @jcrespo 's analysis is correct, then we do not need a new index... [13:11:11] 10DBA, 10MediaWiki-Database, 10MediaWiki-Logging, 10Performance, 10Schema-change: Logging needs an index to optimize searching by log_title - https://phabricator.wikimedia.org/T68961#3520450 (10jcrespo) Please note my suggestion was just that, a suggestion, we were still discussing it -we may or may not... [13:17:42] 10DBA, 10MediaWiki-Database, 10MediaWiki-Logging, 10Performance, 10Schema-change: Logging needs an index to optimize searching by log_title - https://phabricator.wikimedia.org/T68961#3520452 (10Huji) >>! In T68961#3520450, @jcrespo wrote: > Please note my suggestion was just that, a suggestion, we were s... [14:37:26] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata, 10Patch-For-Review, and 2 others: Usage tracking: record which statement group is used - https://phabricator.wikimedia.org/T151717#3520617 (10hoo) [15:45:11] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata: Investigate separating wbc_entity_usage out to a separate DB shard - https://phabricator.wikimedia.org/T173189#3520755 (10hoo) [15:46:13] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata: Investigate separating wbc_entity_usage out to a separate mariadb shard - https://phabricator.wikimedia.org/T173189#3520771 (10hoo) [17:28:40] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata: Investigate separating wbc_entity_usage out to a separate mariadb shard - https://phabricator.wikimedia.org/T173189#3520755 (10Marostegui) What do you exactly mean with a "database shard"? Could you provide some more context for this proposal? [17:46:47] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata: Investigate separating wbc_entity_usage out to a separate mariadb shard - https://phabricator.wikimedia.org/T173189#3521125 (10hoo) >>! In T173189#3521059, @Marostegui wrote: > What do you exactly mean with a "database shard"? > Could you provide some... [17:57:21] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata: Investigate separating wbc_entity_usage out to a separate mariadb shard - https://phabricator.wikimedia.org/T173189#3521140 (10jcrespo) Yes, a dedicated database service for this //could// make sense to separate writes if tracking changes starts takin... [18:10:00] 10DBA, 10MediaWiki-extensions-WikibaseClient, 10Wikidata: Investigate separating wbc_entity_usage out to a separate mariadb shard - https://phabricator.wikimedia.org/T173189#3521164 (10Marostegui) Thanks Jaime! @hoo and myself just synced in person here :-) All clear! [22:56:20] 10DBA, 10Data-Services: Prepare and check storage layer for hi.wikiversity - https://phabricator.wikimedia.org/T171829#3477438 (10Urbanecm) Poke.