[Again in the saga of me trying to query the revision and logging tables against comment text and usernames...]
Am I dreaming or is the timeout on DB queries today something like 2 minutes? Is it a temporary measure? Is a query killer particularly aggressive due to some overload? Should we expect this to last?
This query works:
MariaDB [enwiki_p]> select count(*) from revision where rev_id > 950000000 AND rev_comment_id = 1334144;
+----------+ | count(*) | +----------+ | 174 | +----------+ 1 row in set (1 min 57.35 sec)
A slightly bigger one times out pretty quick:
MariaDB [enwiki_p]> select count(*) from revision where rev_id > 930000000 AND rev_comment_id = 1334144; ERROR 2013 (HY000): Lost connection to MySQL server during query
Federico