Hello all,
the last days when the replag on s3 was high, I looked for long-running-querys from time to time. I noticed, that many queries which are run from inside of webtools (like editcounters) had no LIMIT (see [1]). This is bad – no user waits 5000s or more for a result and he/she is long go when the query still needs resources (and at the end the result is abject). So please use a LIMIT for your querys – even if they are fast for normal (the LIMIT doesn't hurt then). Please don't confuse this with the SQL-command LIMIT (which you should also use if possibe ;-)).
Sincerly, DaB.
[1] https://wiki.toolserver.org/view/Database_access#Query_time_limits
toolserver-l@lists.wikimedia.org