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?
--
+----------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Tõnu Samuel |
| /*/ /*/ /*/ \*\_ |*| |*||*| tonu@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Tallinn, Estonia |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------+
