On Mon, Aug 15, 2011 at 11:39 PM, K. Peachey <p858snake(a)gmail.com> wrote:
On Tue, Aug 16, 2011 at 7:03 AM, Maarten Dammers
<maarten(a)mdammers.nl> wrote:
Ah, you are the one who killed the categorization
bot. Thanks for
announcing that beforehand (not!). It's very annoying that you suddenly
just decide to deploy a new toy the screws up our tools.
Maarten
It was re-enabling a service that has been around for a long time that
[accidently] broke at one stage and because of the TS performance not
being degraded was never really noticed or cared about.
Recently a TS box went down and caused major issues (Replag was easily
over 2 days at one stage for those databases) for the backup box
handling the effected databases, DaB was monitoring this by hand and
manually killing the processes to keep this somewhat saner then
re-wrote and brought the tool back online to handle this when they
noticed it was [the tool] was not functioning.
This was a tool that was already meant to be running but by [your]
"luck" wasn't, and was already documented on wiki as DaB pointed out
over a year ago.
Perhaps you should consider apologizing to DaB in regards to the tone
of your email.
While it's wrong do insult DaB (or anyone here :-) I feel the
annoyance. It doesn't really matter if it was "supposed to" be running
but wasn't for some reason we mere mortals can't comprehend - queries
were fine, and then they suddenly they were not. I understand there
are reasons behind this (hardware failure, miser mode), but they
weren't obvious from the original mail.
So now I (and others, I suspect) are inserting /* SLOW_OK */ into
queries. That doesn't make the queries less or faster, but it returns
service to normal (for the tool writers, and the tool users). German
speakers might be familiar with the phrase "wenn's denn der
Wahrheitsfindung dient..."
Should we (the tool authors) make our queries faster? Absolutely. Can
we? Sometimes, maybe. Usually not. That might be due to personal
qualification, or system constraints. The local version of the "work
smarter, not harder" mantra is unlikely to improve the situation.
Cheers,
Magnus