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 !
Thanks for the answer !
--Andy
