On Thu, 28 Dec 2006 07:23:43 -0800, The GOsh! wrote:

> Hello To all...
>
> I'd like to know if there is a method or a way to auto-kill zombies
> process, I don't know.. let's see auto-kill if a process has a longer
> time that 300 seconds.... Is that posible?

You need to create your own auto-kill.
I hang one just like it on cron. Every hour it executes a MySQL "SHOW
PROCESSLIST". It looks at each item and if an idle *process* is older
than x seconds, I execute "KILL {PID}" on it.

Thomas Bartkus

>
> I am using an old DB.. mysql 3.23 (that's is only in my job.. I use the
> 5.0) with Centos 3.3.