[04:04:19] [[Tech]]; Revi C.; /* "uncollapsing" various auto-collapse in Contribs area */ new section; https://meta.wikimedia.org/w/index.php?diff=29365163&oldid=29363862&rcid=36972189 [15:02:42] if i need to run an sql query against the production database, what's the right place to do that these days? I can't reach the maintenance servers anymore... [15:03:55] You probably need to increase the number by one :P [15:04:04] and/or the bastion you're using is out of date too [15:04:20] https://wikitech.wikimedia.org/wiki/Bastion [15:04:29] https://wikitech.wikimedia.org/wiki/SRE/Production_access#SSH_configuration [15:04:45] https://wikitech.wikimedia.org/wiki/Maintenance_server [15:05:36] duesen: analytics-mysql on the stats hosts (e.g. stat1011)? [15:06:41] or `sql testwiki` on deployment.eqiad.wmnet [15:07:27] >This page is about the mwmaint servers, which can no longer be used used to run maintenance scripts as of June 2025, and will soon be decommissioned. [15:07:30] Reedy: hm ok - the wiki page says that maintenance servers will soon go away, so I figured that may have happend with the dc switch. [15:07:31] That'd explain it [15:07:55] Yeah, you can run sql queries from the deployment hosts... but generally not long running stuff [15:08:03] Lucas_WMDE: the deployment host works for me, thanks. [15:08:39] analytics-mysql is a replica that doesn't serve production traffic? [15:09:14] yeah [15:09:21] I think it might also have more “powerful” servers? but not sure [15:09:24] but I generally go there [15:09:29] Reedy: i'm investigating a query that is slow for no apparent reason. Just running a bunch of EXPLAIN queries. [15:09:39] especially if I want to do ridiculously long-running queries or full table scans and stuff like that [15:09:43] you may want to do it from deploy hosts then tbh [15:09:49] ok for that using the real deploy hosts sounds better, +1 [15:09:51] just for specific maria version explains... [15:10:10] actually, maybe I should try both, and see if the results are different, [15:10:27] maybe table stats got wacky [15:10:37] thanks :) [15:10:38] we are running 10.6 and 10.11 [15:10:42] so there can be some variance there too [15:10:49] ah, good to know [15:11:08] https://orchestrator.wikimedia.org/web/clusters [15:51:48] [[Tech]]; Rayinclover; /* SARK */ new section; https://meta.wikimedia.org/w/index.php?diff=29366936&oldid=29365163&rcid=36976004 [16:01:24] [[Tech]]; Johannnes89; Reverted change by [[Special:Contributions/Rayinclover|Rayinclover]] ([[User talk:Rayinclover|talk]]) to last version by Revi C.; https://meta.wikimedia.org/w/index.php?diff=29367035&oldid=29366936&rcid=36976133