On Sat, Oct 29, 2011 at 2:18 PM, DaB. <WP(a)daniel.baur4.info> wrote:
Hello,
At Saturday 29 October 2011 15:04:30 DaB. wrote:
This queries, and others like it, have not caused
problems for the
last one (two? I can't remember) years they've been in place.
Something has changed for the far, far worse.
have you ever thought about the possiblity that maybe there are more users on
the TS and more people who use the toolserver now than 2 years ago?
Unless there was an enormous influx of users in the last 12 hours or
so, this is not really an explanation.
Or maybe
it is just people like you, who let a query for a WEBTOOL run for 71 minutes!
If you look at the rather simple query, you'll see that it's not so
much that my tool needs 71 minutes to run. The issue is rather that
the database server takes 71 minutes for a query that shouldn't even
take 71 seconds.
We are just short on hardware at the moment, and the
situation will not change
for some time, so we all have to live with the things we have and if a tool
breaks because it consumes too much resources, then the dev. has to look if
he/she can optimize it or it breaks!
The "work smarter, not harder" approach is neither helpful nor winning
many sympathies.
I am aware that the toolserver needs both hardware and admin
attention. I was not complaining about a lack of either. I was merely
commenting on a very recent change for the worse, which might have an
unrelated cause (a disk filled up, some configuration changed), and
might thus have an easy fix. Yelling at people who mention a new and
acute issue is not the way forward.
Magnus