[00:55:23] 10DBA, 10Analytics, 10Analytics-EventLogging, 06Research-and-Data: Queries on PageContentSaveComplete are starting to pileup - https://phabricator.wikimedia.org/T144278#2596549 (10Jdforrester-WMF) Please don't kill the scripts for good, but it's OK to disable them for a bit. [04:03:02] 10DBA, 10Beta-Cluster-Infrastructure, 06Release-Engineering-Team, 13Patch-For-Review, 07WorkType-Maintenance: Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10 - https://phabricator.wikimedia.org/T138778#2596718 (10dduvall) Scratch that @jcrespo. I had a conflict after al... [10:15:16] 10DBA, 07Performance: Spiky write pattern on core db masters - https://phabricator.wikimedia.org/T144382#2597766 (10jcrespo) [10:22:43] 10DBA, 07Performance: Spiky write pattern on core db masters - https://phabricator.wikimedia.org/T144382#2597785 (10jcrespo) [10:43:48] 10DBA, 10Wikidata, 07Performance: Spiky write pattern on core db masters - https://phabricator.wikimedia.org/T144382#2597796 (10jcrespo) An unreliable, heuristic approach seems to point to old knowns: LinksUpdate and, less probably, Wikibase\Client\Usage\Sql\EntityUsageTable. Maybe its job execution could b... [10:48:28] 10DBA, 10Wikidata, 07Performance: Spiky write pattern on core db masters - https://phabricator.wikimedia.org/T144382#2597752 (10hoo) Wikibase jobs //should// come in more regular/ often and in smaller batches than this. [12:44:04] 10DBA, 06Labs, 06Operations, 07Tracking: Database replication services (tracking) - https://phabricator.wikimedia.org/T50930#2597985 (10jcrespo) [12:44:06] 10DBA, 06Editing-Analysis, 06Labs: Replicate editor_month table from analytics-store to Labs - https://phabricator.wikimedia.org/T143955#2597983 (10jcrespo) 05Open>03stalled You are asking an implementation "Replicate editor_month table from analytics-store to Labs", but not what you need to do on labs.... [14:03:21] 10DBA, 10Analytics, 10Analytics-EventLogging, 06Research-and-Data: Queries on PageContentSaveComplete are starting to pileup - https://phabricator.wikimedia.org/T144278#2598171 (10DarTar) I paused all the cronjobs for the ee-dashboards and will help @HJiang-WMF and @Milimetric cherry-pick those that need t... [14:03:45] 10DBA, 10Analytics, 10Analytics-EventLogging: Queries on PageContentSaveComplete are starting to pileup - https://phabricator.wikimedia.org/T144278#2598172 (10DarTar) [14:04:42] 10DBA, 10Analytics, 10Analytics-EventLogging: Queries on PageContentSaveComplete are starting to pileup - https://phabricator.wikimedia.org/T144278#2598178 (10jcrespo) Can I kill already-running jobs? [16:40:52] 10DBA, 10Analytics, 10Analytics-EventLogging: Queries on PageContentSaveComplete are starting to pileup - https://phabricator.wikimedia.org/T144278#2598801 (10DarTar) >>! In T144278#2598178, @jcrespo wrote: > Can I kill already-running jobs? You can definitely kill this one. Please do not kill all queries b... [17:09:31] 10DBA, 10Analytics, 10Analytics-EventLogging: Queries on PageContentSaveComplete are starting to pileup - https://phabricator.wikimedia.org/T144278#2598900 (10jcrespo) 05Open>03Resolved >>! In T144278#2598801, @DarTar wrote: >>>! In T144278#2598178, @jcrespo wrote: >> Can I kill already-running jobs? >... [18:06:41] 10DBA, 10MediaWiki-Database, 10MediaWiki-Watchlist, 06TCB-Team, and 3 others: Add a wl_id field to the watchlist table - https://phabricator.wikimedia.org/T125990#2002318 (10kaldari) @jcrespo: Just wondering if you had an updated ETA on rolling this out on production. [18:21:19] 10DBA, 10MediaWiki-Database, 10MediaWiki-Watchlist, 06TCB-Team, and 3 others: Add a wl_id field to the watchlist table - https://phabricator.wikimedia.org/T125990#2002318 (10aaron) >>! In T125990#2125460, @jcrespo wrote: > According to https://www.mediawiki.org/wiki/Manual:Watchlist_table that table used t... [19:14:21] 10Blocked-on-schema-change, 10DBA, 10Expiring-Watchlist-Items, 10MediaWiki-Watchlist, 06TCB-Team: Add wl_id to watchlist tables on production dbs - https://phabricator.wikimedia.org/T130067#2124305 (10kaldari) According to an update from jamie at T125990#2599365 (sorry I asked on the wrong ticket), this... [19:14:31] 10DBA, 06Editing-Analysis, 06Labs, 05Security: Replicate editor_month table from analytics-store to Labs - https://phabricator.wikimedia.org/T143955#2599417 (10jcrespo) I think it would be easier if you created a public dump, then created a tool with database access and made it public, importing it every s... [19:23:01] 10DBA, 10MediaWiki-Database, 10MediaWiki-Watchlist, 06TCB-Team, and 3 others: Add a wl_id field to the watchlist table - https://phabricator.wikimedia.org/T125990#2599485 (10jcrespo) > Isn't the first UNIQUE index the PRIMARY KEY if none is explicitly otherwise assigned? No that is used internally by Inno... [19:27:26] jynus: ahh, I didn't know that it uses it physically but doesn't expose it. Interesting subtlety. [19:28:12] you were right, but sql and engine are separate [19:28:21] not a big deal [19:28:32] but better define it explicitly [19:28:52] other engines directly break, like tokudb I think with tag_somthing [19:29:23] and then pt-online-schema or pt-table-checksum sometimes work, sometimes don't [19:29:34] so better have it explicitly [22:50:53] 10DBA, 06Editing-Analysis, 06Labs, 05Security: Replicate editor_month table from analytics-store to Labs - https://phabricator.wikimedia.org/T143955#2584567 (10Bawolff) That has a column for deleted edits. Isnt the number of deleted edits somebody makes usually secret? [23:07:18] 10DBA, 06Editing-Analysis, 06Labs, 05Security: Replicate editor_month table from analytics-store to Labs - https://phabricator.wikimedia.org/T143955#2600386 (10jcrespo) Privacy is a certainly a very complex issue; even replicating the number of watchers of a page required a non-trivial amount of filtering....