[23:02:08] <AaronSchulz>	 jynus: I wonder what's up with errors like <<AFComputedVariable::compute	10.64.32.21	2013	Lost connection to MySQL server during query (10.64.32.21)	SELECT rev_user_text FROM (SELECT  rev_user_text,rev_timestamp  FROM `revision`   WHERE rev_page = '36395484' AND (rev_timestamp < '20151025072035')  ORDER BY rev_timestamp DESC LIMIT 100  ) AS tmp GROUP BY
[23:02:08] <AaronSchulz>	 rev_user_text ORDER BY MAX(rev_timestamp) DESC LIMIT 10>>
[23:02:26] <AaronSchulz>	 it seems to be randomly slow sometimes, though never when I run them myself
[23:09:07] <AaronSchulz>	 seems to be hurting page save time
[23:16:55] <Krenair>	 randomly slow?
[23:23:15] <Krenair>	 AaronSchulz, does it depend on which db server the query hits?
[23:24:44] <Krenair>	 The first time I ran that query on db1066 I got 1 min 23.94 sec, after that it was quick
[23:26:13] <Krenair>	 a couple of other servers behaved similarly
[23:28:08] <AaronSchulz>	 hmm, I haven't run them lately but it recall it being fast months ago
[23:28:38] <AaronSchulz>	 I don't see a server correlation in the logs (just the 2 high load ones showing, which doesn't mean anything)
[23:42:03] <AaronSchulz>	 Krenair: including 24h it seems to affect the two API DB servers mostly
[23:42:36] <AaronSchulz>	 I don't know if that the servers or just the pages where edits tend to use the API
[23:43:13] <AaronSchulz>	 https://logstash.wikimedia.org/#dashboard/temp/AVChYj1fptxhN1Xa5gkU