[10:51:02] I've been continuing to work on my overloaded database, and I'm noticing an odd query dominating the database in terms of QPS. https://pastebin.com/AHUDT0RU This is literally accounting for 67% of my total queries over the past 12 or so hours. That seems odd, especially considering the massive set we're checking against with the properties there. [10:51:31] My PMM service doesn't even show the full query because that list is so large. [11:26:29] most curious! what extensions do you have installed? [11:31:20] Oh jeez, a ton. Here, I'll get a pastebin in just a minute. [11:35:01] Here we go: https://pastebin.com/AMv4VMd9 [11:35:14] ashley:^ forgot to tag you [11:36:05] There's a few custom extensions as well, but I personally worked on all of them, and I don't see anything that would implicate them as responsible for this. [11:36:11] a quick codesearch discovers WikiSEO as the source of those hreflang_% properties [11:36:35] yeah, that was my thinking, based on a quick MW.org search :D per https://www.mediawiki.org/wiki/Extension:WikiSEO#Hreflang_Attributes [12:00:37] I went ahead and just disabled the extension for that particular site. We run 3 wikis in one, and that one doesn't really need it. Here's hoping that fixes the problem. [12:00:47] (It's a file repository)