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
