[00:03:02] 10DBA, 06Editing-Analysis, 06Labs: Replicate editor month table to Labs - https://phabricator.wikimedia.org/T143955#2584669 (10AlexMonk-WMF) I don't think anything from analytics databases ever gets replicated to labs... [00:04:15] 10DBA, 06Editing-Analysis, 06Labs: Replicate editor_month table from analytics-store to Labs - https://phabricator.wikimedia.org/T143955#2584676 (10AlexMonk-WMF) [01:21:20] 10DBA, 06Editing-Analysis, 06Labs: Replicate editor_month table from analytics-store to Labs - https://phabricator.wikimedia.org/T143955#2584567 (10Neil_P._Quinn_WMF) p:05Triage>03Normal [07:33:43] 10DBA: Fix dbstore2001 and dbstore2002 - https://phabricator.wikimedia.org/T130128#2585137 (10jcrespo) [07:39:44] 10DBA, 06Labs, 06Operations, 07Tracking: Database replication services (tracking) - https://phabricator.wikimedia.org/T50930#2585146 (10jcrespo) [07:39:47] 10DBA, 06Labs: s2 replag currently 8 hours - https://phabricator.wikimedia.org/T143934#2585143 (10jcrespo) 05Open>03Resolved a:03jcrespo s2 was under maintenance on production; This will happen several times on one shard at a time in order to propagate a production schema change. There is very little we... [07:43:19] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 3 others: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2585157 (10jcrespo) First of all, I would avoid any change until I finish the deployment of: T139090, then we can see what w... [08:11:01] 10DBA, 06Labs, 10Labs-Infrastructure, 06Operations: Enable access to Wikipedia Tulu (tcywiki) on labs replicas - https://phabricator.wikimedia.org/T142223#2585214 (10AlexMonk-WMF) [08:11:05] 10DBA, 06Labs, 10Labs-Infrastructure: Add pp_propname/pp_value index to Labs replica - https://phabricator.wikimedia.org/T140609#2585215 (10AlexMonk-WMF) [08:11:08] 10DBA, 06Labs, 10Labs-Infrastructure, 13Patch-For-Review: maintain-replicas.pl unmaintained, unmaintainable - https://phabricator.wikimedia.org/T138450#2585217 (10AlexMonk-WMF) [08:11:12] 10DBA, 06Labs: Wrong page title in labs database replica enwiki page table - https://phabricator.wikimedia.org/T136618#2585218 (10AlexMonk-WMF) [08:11:16] 10DBA, 10Fundraising-Backlog, 06Labs, 10MediaWiki-extensions-CentralNotice: Replicate CentralNotice tables to Labs - https://phabricator.wikimedia.org/T135405#2585219 (10AlexMonk-WMF) [08:11:27] 10DBA, 06Labs: Data missing from June 11/12 on s3.labsdb - https://phabricator.wikimedia.org/T115517#2585225 (10AlexMonk-WMF) [08:11:29] 10DBA, 06Labs, 06Operations, 10Tool-Labs: Replicate wikimania2017wiki to labs - https://phabricator.wikimedia.org/T126096#2585224 (10AlexMonk-WMF) [08:11:33] 10DBA, 06Labs, 10Labs-Infrastructure: rev_len should be available also for deleted revisions in database replicas - https://phabricator.wikimedia.org/T101631#2585227 (10AlexMonk-WMF) [08:11:44] 10DBA, 06Labs, 06Operations, 07Tracking: Database replication services (tracking) - https://phabricator.wikimedia.org/T50930#2585212 (10AlexMonk-WMF) [08:15:31] 10DBA, 06Labs, 06Operations, 10Tool-Labs: Replicate wikimania2017wiki to labs - https://phabricator.wikimedia.org/T126096#2004612 (10AlexMonk-WMF) Needs a maintain-replicas run [08:16:47] 10DBA, 10Fundraising-Backlog, 06Labs, 10MediaWiki-extensions-CentralNotice: Replicate CentralNotice tables to Labs - https://phabricator.wikimedia.org/T135405#2297843 (10AlexMonk-WMF) I suppose some views just need to be added to maintain-replicas for these [08:17:57] the patch is low quality, and should probably not use regular slaves in the first place [08:25:21] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 3 others: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2583671 (10hashar) Context of deployment from the IRC log http://bots.wmflabs.org/~wm-bot/logs/%23wikimedia-operations/20160... [08:41:13] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 3 others: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2585284 (10jcrespo) ``` also dcausse I am very willing to give reviews about anything regarding the db I am... [09:12:28] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 3 others: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2585319 (10jcrespo) So yes, this generated 1-hour queries: ``` Hits Tmax Tavg Tsum Hosts Users Schemas 4 3,056 3,023... [11:25:59] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 3 others: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2585480 (10hashar) https://gerrit.wikimedia.org/r/306899 has been pushed to the cluster. The job RedirectsAndIncomingLinks... [14:05:48] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 3 others: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2585899 (10EBernhardson) > The issue is that using perfect indexes when there are 1000 items on the IN/OR is difficult (in t... [14:10:51] 10DBA, 10CirrusSearch, 06Discovery, 06Discovery-Search (Current work), and 3 others: MySQL chooses poor query plan for link counting query - https://phabricator.wikimedia.org/T143932#2585919 (10jcrespo) Yes, that was more or less my idea to move this forward, simplify a bit the query, and document the issu... [15:08:42] 10DBA, 06Operations: mysql boxes not in ganglia - https://phabricator.wikimedia.org/T87209#2586204 (10jcrespo) This will probably end up being a "Won't fix" if https://grafana.wikimedia.org/dashboard/db/mysql ends up being successful. [15:23:49] 10DBA, 06Labs, 10Tool-Labs: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#2586262 (10Stevietheman) It has been over 4 months since the most recent popular pages updates, and the pages in projects in which I'm a member are getting stale. I... [15:43:01] 10DBA, 06Labs, 10Tool-Labs: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#2586356 (10valhallasw) @Stevietheman: Please create a seperate bug for that issue. [16:53:55] 10DBA, 06Labs, 10Tool-Labs: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#2586595 (10Stevietheman) I thought this was the bug. Also, what would my bug state and where would it go? [17:59:55] 10DBA, 06Labs, 10Tool-Labs: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#2586956 (10kaldari) @Stevietheman: The bug already exists: T141154. [18:43:15] 10DBA, 06Labs, 10Tool-Labs: p50380g50816__pop_stats (popularpages) using 53G on labsdb1001 (enwiki) - https://phabricator.wikimedia.org/T133326#2587092 (10Stevietheman) >>! In T133326#2586956, @kaldari wrote: > @Stevietheman: The bug already exists: T141154. Thanks!