[Toolserver-l] performance issues

[Magnus Manske]

On Sat, Oct 29, 2011 at 2:18 PM, DaB. <WP at 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