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:
Category:MySQL Server Severity:S5 (Performance)
Version:4.1.22 OS:Linux
Assigned to: CPU Architecture:Any

[31 Mar 2008 21:55] Anu Amit

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: 

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


How to repeat:
Steps to recreate the issue:
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.
[7 Apr 2008 10:55] Susanne Ebrecht
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.
[7 May 2008 23:00] 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".