Bug #3978 wait_timeout and interactive_timeout cann't work in linux NPTL
Submitted: 3 Jun 2004 5:11 Modified: 28 Jan 2006 6:10
Reporter: kang hongjiu Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.20 OS:Linux (fedora core 1.0)
Assigned to: Assigned Account CPU Architecture:Any

[3 Jun 2004 5:11] kang hongjiu
Description:
  I set wait_timeout=30 and interactive_timeout=30 in /etc/my.cnf file. After some time, I use phpmyadmin show the mysql thread ,I found a lot of thread with Time > 30 second.But I kill one thread use phpmyadmin then all thread with time>30 will killed auto.

How to repeat:
   compile mysql in fedora core 1.0 system.
        see Description

Suggested fix:
add  
export LD_ASSUME_KERNEL=2.4.1 
in the  mysql.server shell file to disable linux NPTL.
[3 Jun 2004 20:04] Dean Ellis
I cannot repeat this; after the timeout is exceeded the connection is terminated.

Please check to see if whatever you are using to connect is changing the timeouts.  Alternatively, connect from the mysql command-line client, verify the timeouts and then idle beyond those to see if the connections are properly terminated.
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[28 Jan 2006 6:10] Aleksey Kishkin
duplicate of bug #11897