Re: MySQL 4.0.23a mysqld defunct
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 still exists. Arek H [EMAIL PROTECTED] wrote: 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:11 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key:0 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 0 Open tables:0 Open files: 0 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 1 Next alarm time: 0 050731 15:57:09 /usr/libexec/mysqld: Normal shutdown Regards Arek -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.23a mysqld defunct
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 a web based apache bench on my server with the Requests set to 25 and Concurrency set to 5. I checked my domains error logs and there is nothing there. I looked in the error log located at /var/lib/mysql/ano.err and here are the last few lines of it. Im new to linux so this is the only error log I could find for mysql . Memory status: Non-mmapped space allocated from system: 5204056 Number of free chunks: 15 Number of fastbin blocks:0 Number of mmapped regions: 11 Space in mmapped regions:22401024 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 4901384 Total free space:302672 Top-most, releasable space: 131176 Estimated memory (with thread stack):27605080 050731 15:57:12 mysqld ended 050731 16:35:00 mysqld started 050731 16:35:02 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.23a' socket: '/var/run/mysql/mysql.sock' port: 0 Source distribution 050731 16:40:59 /usr/libexec/mysqld: Normal shutdown 050731 16:40:59 InnoDB: Starting shutdown... 050731 16:41:00 InnoDB: Shutdown completed 050731 16:41:00 /usr/libexec/mysqld: Shutdown Complete 050731 16:41:00 mysqld ended 050731 16:42:17 mysqld started 050731 16:42:19 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.23a' socket: '/var/run/mysql/mysql.sock' port: 0 Source distribution Also here is what top shows 20797 root 12 0 1060 1060 824 R 1.3 0.2 0:18.60 top 20993 mysql 11 0 000 Z 1.0 0.0 0:00.03 mysqld defunct 20999 mysql 10 0 15612 15m 3020 S 0.6 3.1 0:00.02 mysqld 21007 mysql 11 0 000 Z 0.6 0.0 0:00.02 mysqld defunct 21017 mysql 13 0 15632 15m 3020 S 0.6 3.1 0:00.02 mysqld 1000 mysql 17 0 15592 15m 3020 R 0.3 3.1 0:01.89 mysqld 20991 mysql 9 0 000 Z 0.3 0.0 0:00.01 mysqld defunct 21013 mysql 10 0 15632 15m 3020 S 0.3 3.1 0:00.01 mysqld 21015 mysql 11 0 15632 15m 3020 S 0.3 3.1 0:00.01 mysqld 1 root 8 0 228 228 200 S 0.0 0.0 0:04.86 init 2 root 9 0 000 S 0.0 0.0 0:00.05 keventd 3 root 19 19 000 S 0.0 0.0 0:00.00 ksoftirqd_CPU0 4 root 9 0 000 S 0.0 0.0 0:00.00 kswapd 5 root 9 0 000 S 0.0 0.0 0:00.00 bdflush 6 root 9 0 000 S 0.0 0.0 0:00.02 kupdated 10 root -1 -20 000 S 0.0 0.0 0:00.00 mdrecoveryd 11 root 9 0 000 S 0.0 0.0 0:00.06 kjournald 44 root 9 0 000 S 0.0 0.0 0:00.16 kjournald 45 root 9 0 000 S 0.0 0.0 0:00.26 kjournald Thanks Arek 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. -- Nuno Pereira -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.23a mysqld defunct
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 S0 0:04 init [3] 1 2 1 1 ? -1 S0 0:00 [keventd] 1 3 1 1 ? -1 SN 0 0:00 [ksoftirqd_CPU0] 1 4 1 1 ? -1 S0 0:00 [kswapd] 1 5 1 1 ? -1 S0 0:00 [bdflush] 1 6 1 1 ? -1 S0 0:00 [kupdated] 110 1 1 ? -1 S 0 0:00 [mdrecoveryd] 111 1 1 ? -1 S0 0:00 [kjournald] 144 1 1 ? -1 S0 0:00 [kjournald] 145 1 1 ? -1 S0 0:00 [kjournald] 146 1 1 ? -1 S0 0:00 [kjournald] 147 1 1 ? -1 S0 0:00 [kjournald] 148 1 1 ? -1 S0 0:00 [kjournald] 1696969 ? -1 Ss 0 0:02 /usr/sbin/syslogd 1727272 ? -1 Ss 0 0:00 /usr/sbin/klogd -c 3 -x 1 132 132 132 ? -1 Ss 0 0:00 udevd 1 233 1 1 ? -1 S0 0:00 [khubd] 1 696 696 696 ? -1 Ss 0 0:00 /sbin/dhcpcd -d -t 10 eth0 1 943 943 943 ? -1 Ss 0 0:00 /usr/sbin/inetd 1 947 947 947 ? -1 Ss 0 0:06 /usr/sbin/sshd 947 16144 16144 16144 ? -1 Ss 0 0:00 \_ sshd: arek [priv] 16144 16147 16144 16144 ? -1 S 1000 0:06 | \_ sshd: [EMAIL PROTECTED]/0 16147 16148 16148 16148 pts/021532 Ss1000 0:00 | \_ -bash 16148 16881 16881 16148 pts/021532 S0 0:00 | \_ bash 16881 21532 21532 16148 pts/021532 R+ 0 0:00 | \_ ps ajxf 947 21108 21108 21108 ? -1 Ss 0 0:00 \_ sshd: arek [priv] 21108 2 21108 21108 ? -1 S 1000 0:00 \_ sshd: [EMAIL PROTECTED]/1 2 21112 21112 21112 pts/121132 Ss1000 0:00 \_ -bash 21112 21123 21123 21112 pts/121132 S0 0:00 \_ bash 21123 21132 21132 21112 pts/121132 S+ 0 0:00 \_ tail -f syslog 1 958 957 957 ? -1 S0 0:00 /usr/sbin/crond -l10 1 960 960 960 ? -1 Ss 2 0:00 /usr/sbin/atd -b 15 -l 1 1 963 963 963 ? -1 Ss 0 0:00 sendmail: accepting connections 1 966 966 966 ? -1 Ss 25 0:00 sendmail: Queue [EMAIL PROTECTED]:25:00 for /var/spool/clientmqueue 1 9726161 ? -1 S0 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var 972 9996161 ? -1 S 27 0:02 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --use 999 10006161 ? -1 S 27 0:01 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql - 1000 10016161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10026161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10036161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10046161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10056161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10066161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10076161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10086161 ? -1 S 27 0:02 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1 976 976 976 ? -1 Ss 0 0:00 /usr/sbin/gpm -m /dev/mouse -t ps2 1 1010 1010 1010 tty1 1010 Ss+ 0 0:00 -bash 1 1011 1011 1011 tty2 1011 Ss+ 0 0:00 /sbin/agetty 38400 tty2 linux 1 1012 1012 1012 tty3 1012 Ss+ 0 0:00 /sbin/agetty 38400 tty3 linux 1 1013 1013 1013 tty4 1013 Ss+ 0 0:00 /sbin/agetty 38400 tty4 linux 1 1014 1014 1014 tty5 1014 Ss+ 0 0:00 /sbin/agetty 38400 tty5 linux 1 1015 1015 1015 tty6 1015 Ss+ 0 0:00 /sbin/agetty 38400 tty6 linux 1 17378 17378 17378 ? -1 Ss 0 0:00 /usr/sbin/httpd 17378 17379 17378 17378 ? -1 S 99 0:27 \_ /usr/sbin/httpd 17378
Re: MySQL 4.0.23a mysqld defunct
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 ? -1 S0 0:04 init [3] 1 2 1 1 ? -1 S0 0:00 [keventd] 1 3 1 1 ? -1 SN 0 0:00 [ksoftirqd_CPU0] 1 4 1 1 ? -1 S0 0:00 [kswapd] 1 5 1 1 ? -1 S0 0:00 [bdflush] 1 6 1 1 ? -1 S0 0:00 [kupdated] 110 1 1 ? -1 S 0 0:00 [mdrecoveryd] 111 1 1 ? -1 S0 0:00 [kjournald] 144 1 1 ? -1 S0 0:00 [kjournald] 145 1 1 ? -1 S0 0:00 [kjournald] 146 1 1 ? -1 S0 0:00 [kjournald] 147 1 1 ? -1 S0 0:00 [kjournald] 148 1 1 ? -1 S0 0:00 [kjournald] 1696969 ? -1 Ss 0 0:02 /usr/sbin/syslogd 1727272 ? -1 Ss 0 0:00 /usr/sbin/klogd -c 3 -x 1 132 132 132 ? -1 Ss 0 0:00 udevd 1 233 1 1 ? -1 S0 0:00 [khubd] 1 696 696 696 ? -1 Ss 0 0:00 /sbin/dhcpcd -d -t 10 eth0 1 943 943 943 ? -1 Ss 0 0:00 /usr/sbin/inetd 1 947 947 947 ? -1 Ss 0 0:06 /usr/sbin/sshd 947 16144 16144 16144 ? -1 Ss 0 0:00 \_ sshd: arek [priv] 16144 16147 16144 16144 ? -1 S 1000 0:06 | \_ sshd: [EMAIL PROTECTED]/0 16147 16148 16148 16148 pts/021532 Ss1000 0:00 | \_ -bash 16148 16881 16881 16148 pts/021532 S0 0:00 | \_ bash 16881 21532 21532 16148 pts/021532 R+ 0 0:00 | \_ ps ajxf 947 21108 21108 21108 ? -1 Ss 0 0:00 \_ sshd: arek [priv] 21108 2 21108 21108 ? -1 S 1000 0:00 \_ sshd: [EMAIL PROTECTED]/1 2 21112 21112 21112 pts/121132 Ss1000 0:00 \_ -bash 21112 21123 21123 21112 pts/121132 S0 0:00 \_ bash 21123 21132 21132 21112 pts/121132 S+ 0 0:00 \_ tail -f syslog 1 958 957 957 ? -1 S0 0:00 /usr/sbin/crond -l10 1 960 960 960 ? -1 Ss 2 0:00 /usr/sbin/atd -b 15 -l 1 1 963 963 963 ? -1 Ss 0 0:00 sendmail: accepting connections 1 966 966 966 ? -1 Ss 25 0:00 sendmail: Queue [EMAIL PROTECTED]:25:00 for /var/spool/clientmqueue 1 9726161 ? -1 S0 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var 972 9996161 ? -1 S 27 0:02 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --use 999 10006161 ? -1 S 27 0:01 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql - 1000 10016161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10026161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10036161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10046161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10056161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10066161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10076161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10086161 ? -1 S 27 0:02 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1 976 976 976 ? -1 Ss 0 0:00 /usr/sbin/gpm -m /dev/mouse -t ps2 1 1010 1010 1010 tty1 1010 Ss+ 0 0:00 -bash 1 1011 1011 1011 tty2 1011 Ss+ 0 0:00 /sbin/agetty 38400 tty2 linux 1 1012 1012 1012 tty3 1012 Ss+ 0 0:00 /sbin/agetty 38400 tty3 linux 1 1013 1013 1013 tty4 1013 Ss+ 0 0:00 /sbin/agetty 38400 tty4 linux 1 1014 1014 1014 tty5 1014 Ss+ 0 0:00 /sbin/agetty 38400 tty5 linux 1 1015 1015 1015 tty6 1015 Ss+ 0 0:00 /sbin/agetty 38400 tty6 linux 1 17378 17378 17378 ? -1 Ss 0 0:00 /usr/sbin/httpd 17378 17379 17378 17378 ? -1 S 99 0:27 \_
Re: MySQL 4.0.23a mysqld defunct
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 0:04 init [3] 1 2 1 1 ? -1 S0 0:00 [keventd] 1 3 1 1 ? -1 RN 0 0:00 [ksoftirqd_CPU0] 1 4 1 1 ? -1 S0 0:00 [kswapd] 1 5 1 1 ? -1 S0 0:00 [bdflush] 1 6 1 1 ? -1 S0 0:00 [kupdated] 110 1 1 ? -1 S 0 0:00 [mdrecoveryd] 111 1 1 ? -1 S0 0:00 [kjournald] 144 1 1 ? -1 S0 0:00 [kjournald] 145 1 1 ? -1 S0 0:00 [kjournald] 146 1 1 ? -1 S0 0:00 [kjournald] 147 1 1 ? -1 S0 0:00 [kjournald] 148 1 1 ? -1 S0 0:00 [kjournald] 1696969 ? -1 Ss 0 0:02 /usr/sbin/syslogd 1727272 ? -1 Ss 0 0:00 /usr/sbin/klogd -c 3 -x 1 132 132 132 ? -1 Ss 0 0:00 udevd 1 233 1 1 ? -1 S0 0:00 [khubd] 1 696 696 696 ? -1 Ss 0 0:00 /sbin/dhcpcd -d -t 10 eth0 1 943 943 943 ? -1 Ss 0 0:00 /usr/sbin/inetd 1 947 947 947 ? -1 Ss 0 0:06 /usr/sbin/sshd 947 16144 16144 16144 ? -1 Ss 0 0:00 \_ sshd: arek [priv] 16144 16147 16144 16144 ? -1 S 1000 0:07 | \_ sshd: [EMAIL PROTECTED]/0 16147 16148 16148 16148 pts/06 Ss1000 0:00 | \_ -bash 16148 16881 16881 16148 pts/06 S0 0:01 | \_ bash 16881 6 6 16148 pts/06 R+ 0 0:00 | \_ ps ajxf 947 21108 21108 21108 ? -1 Ss 0 0:00 \_ sshd: arek [priv] 21108 2 21108 21108 ? -1 S 1000 0:00 \_ sshd: [EMAIL PROTECTED]/1 2 21112 21112 21112 pts/121573 Ss1000 0:00 \_ -bash 21112 21123 21123 21112 pts/121573 S0 0:00 \_ bash 21123 21573 21573 21112 pts/121573 S+ 0 0:03 \_ top 1 958 957 957 ? -1 S0 0:00 /usr/sbin/crond -l10 1 960 960 960 ? -1 Ss 2 0:00 /usr/sbin/atd -b 15 -l 1 1 963 963 963 ? -1 Ss 0 0:00 sendmail: rejecting connections on daemon MSA: load average: 12 1 966 966 966 ? -1 Ss 25 0:00 sendmail: Queue [EMAIL PROTECTED]:25:00 for /var/spool/clientmqueue 1 9726161 ? -1 S0 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var 972 9996161 ? -1 S 27 0:02 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --use 999 10006161 ? -1 R 27 0:02 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql - 1000 10016161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10026161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10036161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10046161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10056161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10066161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10076161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 10086161 ? -1 S 27 0:02 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 222196161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 06161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 16161 ? -1 Z 27 0:00 \_ [mysqld] defunct 1000 26161 ? -1 S 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 36161 ? -1 Z 27 0:00 \_ [mysqld] defunct 1000 46161 ? -1 R 27 0:00 \_ /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys 1000 56161 ? -1 R 27 0:00
Re: MySQL 4.0.23a mysqld defunct
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 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 apache bench on my server with the Requests set to 25 and Concurrency set to 5. I checked my domains error logs and there is nothing there. I looked in the error log located at /var/lib/mysql/ano.err and here are the last few lines of it. Im new to linux so this is the only error log I could find for mysql . Memory status: Non-mmapped space allocated from system: 5204056 Number of free chunks: 15 Number of fastbin blocks:0 Number of mmapped regions: 11 Space in mmapped regions:22401024 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 4901384 Total free space:302672 Top-most, releasable space: 131176 Estimated memory (with thread stack):27605080 050731 15:57:12 mysqld ended 050731 16:35:00 mysqld started 050731 16:35:02 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.23a' socket: '/var/run/mysql/mysql.sock' port: 0 Source distribution 050731 16:40:59 /usr/libexec/mysqld: Normal shutdown 050731 16:40:59 InnoDB: Starting shutdown... 050731 16:41:00 InnoDB: Shutdown completed 050731 16:41:00 /usr/libexec/mysqld: Shutdown Complete 050731 16:41:00 mysqld ended 050731 16:42:17 mysqld started 050731 16:42:19 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.23a' socket: '/var/run/mysql/mysql.sock' port: 0 Source distribution Also here is what top shows 20797 root 12 0 1060 1060 824 R 1.3 0.2 0:18.60 top 20993 mysql 11 0 000 Z 1.0 0.0 0:00.03 mysqld defunct 20999 mysql 10 0 15612 15m 3020 S 0.6 3.1 0:00.02 mysqld 21007 mysql 11 0 000 Z 0.6 0.0 0:00.02 mysqld defunct 21017 mysql 13 0 15632 15m 3020 S 0.6 3.1 0:00.02 mysqld 1000 mysql 17 0 15592 15m 3020 R 0.3 3.1 0:01.89 mysqld 20991 mysql 9 0 000 Z 0.3 0.0 0:00.01 mysqld defunct 21013 mysql 10 0 15632 15m 3020 S 0.3 3.1 0:00.01 mysqld 21015 mysql 11 0 15632 15m 3020 S 0.3 3.1 0:00.01 mysqld 1 root 8 0 228 228 200 S 0.0 0.0 0:04.86 init 2 root 9 0 000 S 0.0 0.0 0:00.05 keventd 3 root 19 19 000 S 0.0 0.0 0:00.00 ksoftirqd_CPU0 4 root 9 0 000 S 0.0 0.0 0:00.00 kswapd 5 root 9 0 000 S 0.0 0.0 0:00.00 bdflush 6 root 9 0 000 S 0.0 0.0 0:00.02 kupdated 10 root -1 -20 000 S 0.0 0.0 0:00.00 mdrecoveryd 11 root 9 0 000 S 0.0 0.0 0:00.06 kjournald 44 root 9 0 000 S 0.0 0.0 0:00.16 kjournald 45 root 9 0 000 S 0.0 0.0 0:00.26 kjournald Thanks Arek -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.0.23a mysqld defunct
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:11 not flushed: 0 w_requests: 0 writes: 0 r_requests: 0 reads: 0 handler status: read_key:0 read_next: 0 read_rnd 0 read_first: 0 write: 0 delete 0 update: 0 Table status: Opened tables: 0 Open tables:0 Open files: 0 Open streams: 0 Alarm status: Active alarms: 0 Max used alarms: 1 Next alarm time: 0 050731 15:57:09 /usr/libexec/mysqld: Normal shutdown Regards Arek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL 4.0.23a mysqld defunct
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 apache bench on my server with the Requests set to 25 and Concurrency set to 5. I checked my domains error logs and there is nothing there. I looked in the error log located at /var/lib/mysql/ano.err and here are the last few lines of it. Im new to linux so this is the only error log I could find for mysql . Memory status: Non-mmapped space allocated from system: 5204056 Number of free chunks: 15 Number of fastbin blocks:0 Number of mmapped regions: 11 Space in mmapped regions:22401024 Maximum total allocated space: 0 Space available in freed fastbin blocks: 0 Total allocated space: 4901384 Total free space:302672 Top-most, releasable space: 131176 Estimated memory (with thread stack):27605080 050731 15:57:12 mysqld ended 050731 16:35:00 mysqld started 050731 16:35:02 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.23a' socket: '/var/run/mysql/mysql.sock' port: 0 Source distribution 050731 16:40:59 /usr/libexec/mysqld: Normal shutdown 050731 16:40:59 InnoDB: Starting shutdown... 050731 16:41:00 InnoDB: Shutdown completed 050731 16:41:00 /usr/libexec/mysqld: Shutdown Complete 050731 16:41:00 mysqld ended 050731 16:42:17 mysqld started 050731 16:42:19 InnoDB: Started /usr/libexec/mysqld: ready for connections. Version: '4.0.23a' socket: '/var/run/mysql/mysql.sock' port: 0 Source distribution Also here is what top shows 20797 root 12 0 1060 1060 824 R 1.3 0.2 0:18.60 top 20993 mysql 11 0 000 Z 1.0 0.0 0:00.03 mysqld defunct 20999 mysql 10 0 15612 15m 3020 S 0.6 3.1 0:00.02 mysqld 21007 mysql 11 0 000 Z 0.6 0.0 0:00.02 mysqld defunct 21017 mysql 13 0 15632 15m 3020 S 0.6 3.1 0:00.02 mysqld 1000 mysql 17 0 15592 15m 3020 R 0.3 3.1 0:01.89 mysqld 20991 mysql 9 0 000 Z 0.3 0.0 0:00.01 mysqld defunct 21013 mysql 10 0 15632 15m 3020 S 0.3 3.1 0:00.01 mysqld 21015 mysql 11 0 15632 15m 3020 S 0.3 3.1 0:00.01 mysqld 1 root 8 0 228 228 200 S 0.0 0.0 0:04.86 init 2 root 9 0 000 S 0.0 0.0 0:00.05 keventd 3 root 19 19 000 S 0.0 0.0 0:00.00 ksoftirqd_CPU0 4 root 9 0 000 S 0.0 0.0 0:00.00 kswapd 5 root 9 0 000 S 0.0 0.0 0:00.00 bdflush 6 root 9 0 000 S 0.0 0.0 0:00.02 kupdated 10 root -1 -20 000 S 0.0 0.0 0:00.00 mdrecoveryd 11 root 9 0 000 S 0.0 0.0 0:00.06 kjournald 44 root 9 0 000 S 0.0 0.0 0:00.16 kjournald 45 root 9 0 000 S 0.0 0.0 0:00.26 kjournald Thanks Arek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]