Re: MySQL 4.0.23a defunct

2005-08-08 Thread Gleb Paharenko
Hello. I think that mysqld zombies appear due to death of some MySQL threads, but we don't see any sensible records about it in the error log. I suggest you to switch to official binaries of the latest release from: http://dev.mysql.com/downloads and check if the weird behavior stil

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Arek H
Gleb Paharenko wrote: Hello. Are there any error messages and stack trace before 'Memory status' line in the error log? This is what it shows Status information: Current dir: /var/lib/mysql/ Running threads: 0 Stack size: 196608 Current locks: key_cache status: blocks used:

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Gleb Paharenko
Hello. Are there any error messages and stack trace before 'Memory status' line in the error log? Arek H <[EMAIL PROTECTED]> wrote: > Hi > > Im running a stock install of Slackware 10.1 with the default setup of > mysql. Whats happening is when I hit the reload button severa

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Arek H
Nuno Pereira wrote: You don't have any MySQL process in this case. Try to replicate the case when you got the defunct processes, and post the output like this, in tree, so we can see how lost hist child. Ok managed to capture it. 0 1 0 0 ? -1 S0 0:04 in

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Nuno Pereira
Arek H wrote: Nuno Pereira wrote: Post here the result of a ps ajxf, but it seems to me that you didn't started properly mysql. You should start MySQL with mysqld_safe, not with mysqld. Here it is PPID PID PGID SID TTY TPGID STAT UID TIME COMMAND 0 1 0 0 ?

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Arek H
Nuno Pereira wrote: Post here the result of a ps ajxf, but it seems to me that you didn't started properly mysql. You should start MySQL with mysqld_safe, not with mysqld. Here it is PPID PID PGID SID TTY TPGID STAT UID TIME COMMAND 0 1 0 0 ? -1 S

Re: MySQL 4.0.23a defunct

2005-08-05 Thread Nuno Pereira
Arek H wrote: Hi Im running a stock install of Slackware 10.1 with the default setup of mysql. Whats happening is when I hit the reload button several times on a page that uses php and accesses mysql I get defunct and zombies start showing when viewing top. I also get this when I run a web

MySQL 4.0.23a defunct

2005-08-04 Thread Arek H
Hi Im running a stock install of Slackware 10.1 with the default setup of mysql. Whats happening is when I hit the reload button several times on a page that uses php and accesses mysql I get defunct and zombies start showing when viewing top. I also get this when I run a web based apache be