On Sun, Sep 01, 2002 at 08:41:39AM -0700, Steven Roussey wrote:
>
> My assertion was that there might be a race condition. Hitting it
> may be statistically low. Higher QPS increases your chances in a
> nonlinear way. We have 3000 QPS midday and we tend to hit all
> problems. YMMV. I'm curious what people with a much higher QPS have
> to say. Maybe they don't use insert delayed. I don't know.
I'm under the impressiong that delayed insrets are not a commonly used
feature.
> Even if its not a race condition, looking through the code for it
> will likely help you find whatever is actually wrong. Right now I
> have my hands full with finding out why all the new versions of
> MySQL go nuts under any load at all for us. But that is another
> thread...
Pre-compiled, or built form source?
I've been having zero problems with 4.0.x and 3.23.5x compiled from
source.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
MySQL 3.23.51: up 26 days, processed 541,278,310 queries (232/sec. avg)
