List:General Discussion« Previous MessageNext Message »
From:Nuno Pereira Date:August 5 2005 10:31am
Subject:Re: MySQL 4.0.23a <mysqld> defunct
View as plain text  
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     0    0    0 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     0    0    0 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     0    0    0 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     0    0    0 S  0.0  0.0   0:00.05 keventd
>    3 root      19  19     0    0    0 S  0.0  0.0   0:00.00 ksoftirqd_CPU0
>    4 root       9   0     0    0    0 S  0.0  0.0   0:00.00 kswapd
>    5 root       9   0     0    0    0 S  0.0  0.0   0:00.00 bdflush
>    6 root       9   0     0    0    0 S  0.0  0.0   0:00.02 kupdated
>   10 root      -1 -20     0    0    0 S  0.0  0.0   0:00.00 mdrecoveryd
>   11 root       9   0     0    0    0 S  0.0  0.0   0:00.06 kjournald
>   44 root       9   0     0    0    0 S  0.0  0.0   0:00.16 kjournald
>   45 root       9   0     0    0    0 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
Thread
MySQL 4.0.23a <mysqld> defunctArek H5 Aug
  • Re: MySQL 4.0.23a <mysqld> defunctNuno Pereira5 Aug
    • Re: MySQL 4.0.23a <mysqld> defunctArek H5 Aug
      • Re: MySQL 4.0.23a <mysqld> defunctNuno Pereira5 Aug
        • Re: MySQL 4.0.23a <mysqld> defunctArek H5 Aug
  • Re: MySQL 4.0.23a <mysqld> defunctGleb Paharenko5 Aug
    • Re: MySQL 4.0.23a <mysqld> defunctArek H5 Aug
      • Re: MySQL 4.0.23a <mysqld> defunctGleb Paharenko8 Aug