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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
