Andreas Vierengel wrote:
>
> Tonu Samuel wrote:
> >
> > Andreas Vierengel wrote:
> >
> > > I'm using 3.22.27, compiled from source with gcc-2.95.2 under Linux Redhat
> 6.1
> > > my tables are normalised.
> > > all selects use index.
> > > Normally they are fast as hell, but sometimes an update got stuck in state
> > > "locked" (mysqladmin processlist) and stays here between 30-70 seconds
> (!).
> > > Can anybody give me a hint, how to track down the problem ??
> >
> > Can you try to upgrade? Last stable is fixed against some bugs
> > including glibc bug which can produce errors like this. Are you using
> > INSERT DELAYED somewhere?
>
> No insert-delayed or locks or something else in the whole database(s).
> I'm currently testing under 3.22.32....
> In a few days I will know more !
Apparently it was the glibc problem. Our SMP-Systems now work like charm after
upgrading to 3.22.32.
In peak-times > 400 queries per second with usr+sys < 25%
Wow!!
--Andy
