Has anyone else experienced this bug?
http://bugs.mysql.com/bug.php?id=868
We've been seeing this problem on several of our servers (see the last comment to the bug). MySQL just hangs occasionally, it happens about 3-4 times per month. We have 13 database servers, so that unfortunately increases our odds.
I just wondered how many other people have seen it, and if the suggested "export LD_ASSUME_KERNEL=2.2.5; mysqld_safe &" has worked for anyone. In order to turn that on, I will need to take our site down completely, which is (of course) not desirable.
Steve:
I have not heard much good about NPTL threads when used with MySQL at least :-) If LD_ASSUME_KERNEL trick does not do the job, I would recommend compiling a virgin 2.4 kernel from kernel.org and putting it on all of your servers. That might actually be a good idea anyway even if the trick does work. In three years of doing MySQL support I have learned this simple formula:
RH kernel from 7.0 and newer + MySQL + high load = highly probable instability
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
