MySQL Bugs: #35721: Sleep processes does not get killed.

Bug #35721	Sleep processes does not get killed.
Submitted:	31 Mar 2008 21:55	Modified:	7 May 2008 10:55
Reporter:	Anu Amit	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S5 (Performance)
Version:	4.1.22	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
Hello,

This is similar to bug# 16995. Mysql process remain in sleep state even if the timeouts are set in /etc/my.cnf file. The variable mysql.allow_persistent is set to Off. 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Mysql version: mysql  Ver 14.7 Distrib 4.1.22, for pc-linux-gnu (i686) using readline 4.3
Linux kernel: 2.6.24.2.dn.p4 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I searched for a fix but could not find any. Please help.

Regards,
Anu

How to repeat:
Steps to recreate the issue:
mysql>
set global wait_timeout=10;
set global interactive_timeout=10;
mysql> show processlist;

Once you find that there are processes that remain in sleep state for more that 10 seconds, kill one of the processes

mysql> kill <PID>;
mysql> show processlist;

Now you can see that all the other processes that were in sleep state have got removed.

Many thanks for writing a bug report.
MySQL 4.1.22 is quite old. Please try our newest version MySQL 5.0.51a or even 4.1.23 and let us know if you still run into this problem.

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".