Mysql get locked again

Hi,

Mysql get locked again on my Linux 9 again (Dual Xeon,1GB ram,36GB SCSI)

When mysql grow to ~40MB, soon it will locked the connection ! (Connection limited to 100)
This happen for the second time..

ANy idea??

>$top
19:51:43 up 4 days, 14:57, 1 user, load average: 0.27, 0.27, 0.32
363 processes: 362 sleeping, 1 running, 0 zombie, 0 stopped
CPU0 states: 0.1% user 0.5% system 0.0% nice 0.0% iowait 99.0% idle
CPU1 states: 4.0% user 0.4% system 0.0% nice 0.0% iowait 95.2% idle
CPU2 states: 2.1% user 2.1% system 0.0% nice 0.0% iowait 95.4% idle
CPU3 states: 0.0% user 0.1% system 0.0% nice 0.0% iowait 99.5% idle
Mem: 1030244k av, 1019504k used, 10740k free, 0k shrd, 19812k buff
677940k actv, 0k in_d, 20020k in_c
Swap: 1048552k av, 274348k used, 774204k free 459412k cached

3161 mysql 15 0 47544 5448 652 S 0.0 0.5 1120m 2 mysqld
12094 user 21 0 5348 5348 136 S 0.0 0.5 0:00 0 data.cgi
11905 user 15 0 5284 5284 48 S 0.0 0.5 0:00 3 data.cgi
11673 user 15 0 5272 5272 40 S 0.0 0.5 0:00 3 data.cgi
11676 user 15 0 5272 5272 40 S 0.0 0.5 0:00 2 data.cgi
11684 user 15 0 5272 5272 40 S 0.0 0.5 0:00 1 data.cgi
11896 user 15 0 5272 5272 44 S 0.0 0.5 0:00 0 data.cgi
11683 user 15 0 5264 5264 36 S 0.0 0.5 0:00 3 data.cgi
11783 user 15 0 5272 5264 40 S 0.0 0.5 0:00 3 data.cgi
11887 user 16 0 5264 5264 36 S 0.0 0.5 0:00 2 data.cgi

>$mytop
MySQL on localhost (3.23.58) up 4+14:56:23 [19:52:01]
Queries: 5.9M qps: 16 Slow: 115.0 Se/In/Up/De(%): 72/02/10/01
qps now: 0 Slow qps: 0.0 Threads: 100 ( 100/ 1) 00/00/00/00
Key Efficiency: 100.0% Bps in/out: 1.6k/ 6.9k Now in/out: 21.3/11.9k

 

 

 

 

Top