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
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 mysqld defunct and
zombies start showing when viewing top. I also get this when I run
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
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 ?
Nuno Pereira wrote:
You don't have any Defunct 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
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 several
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
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 mysqld defunct and
zombies start showing when viewing top. I also get this when I run a web
based