> Subject: Re: Question about [mysql <defunct>] processes > Ken Sorensen <[EMAIL PROTECTED]> wrote: > > > I am stumped. I have a very busy MySQL db that we've run for > > about 3 years with no problems. A couple of months ago we upgraded > > the system to RH-3AS with RedHat's distro mysql-server 3.23.58-1.9. > > Recently I've started getting zombie processes ([mysql <defunct>]). > > Remove the RedHat's distro mysql-server and install properly built > MySQL binary version in RPM format. Download it from www.mysql.com. > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.net http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Egor Egorov > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net > <___/ www.mysql.com > > ------------------------------------------------------------------------ Hi Egor, Thanks for your reply. I realized after I posted, I was to ambiguous with my question. Sorry for that. I did change out the MySQL Distro., and as I suspected MySQL is not the problem! Neither was the OS. I cannot use a statically compiled Distro. because we've added functions to this implementation. This system does about 28 queries per second from DBD->Mysql, ODBC, remote mysql connections, etc. About any way you can connect to it, some process does. I used 'lsof' on the command line and found the processes in question were linked to pipes from MySQL to the OS. I found my defunct process! When we first built this implementation, we added a function that interacted with the OS. This added function worked from any query I sent it, but it intermittently threw out <defunct> processes. I recompiled this function using the current OS compilers and added it again to MySQL. When I tried to remove the function from MySQL, I received errors. I had to remove it from the mysql.func table directly. I added the function shared lib to my OS, used 'ldconfig', and used the 'CREATE function ...' in MySQL. That function is used about 100+ times a day in certain queries, and so far, I have no more <defunct> processes. It has been almost a week now under normal operating conditions. I consider this problem solved. Thanks Egor for your post, and your willingness to help me. Ken
-- _________________________________ Ken Sorensen <[EMAIL PROTECTED]> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
