[08:24:51] <wikibugs>	 10DBA, 10Operations, 10ops-eqiad, 10Patch-For-Review: db1114 crashed - https://phabricator.wikimedia.org/T214720 (10jcrespo) db1114 is repooled.
[08:53:04] <wikibugs>	 10DBA, 10AbuseFilter, 10Stewards-and-global-tools: Addition of last hit date to Special:AbuseFilter table - https://phabricator.wikimedia.org/T93564 (10Daimona) So I looked at this again. All improvements that I could think of wouldn't really increase the performance of the query. The only concrete boost wou...
[10:01:52] <wikibugs>	 10DBA, 10AbuseFilter, 10Stewards-and-global-tools: Addition of last hit date to Special:AbuseFilter table - https://phabricator.wikimedia.org/T93564 (10Daimona) I'm almost there. A couple of notes:  - As opposed to what I said above, the `ORDER BY` in the subquery is not necessary: the last hit column only s...
[10:05:48] <wikibugs>	 10DBA, 10AbuseFilter, 10Stewards-and-global-tools, 10Patch-For-Review: Addition of last hit date to Special:AbuseFilter table - https://phabricator.wikimedia.org/T93564 (10Daimona) a:05Glaisher→03Daimona @jcrespo Could you please check the query from my last comment and see how it goes?