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     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

> 



-- 
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]

Reply via email to