mysql server load getting retarded

Over the weekend we deployed phpads on a high traffic server.
The server is dedicated and only running our one site.

Server load is around 140. Its a dual 2.4ghz machine with 1200mb of ram.

It seems that phpads is making myself connections, but not closing them, simply moving them to "Sleep". Does anyone have an ideas to close to connection with mysql vs puttit it to sleep?

The server seems to be sending pages fine right now, however half of the ads are not being shown. It randomly shows them, or doesnt show them.

Our top readout is;

11:15:42 up 51 min, 1 user, load average: 146.31, 150.37, 124.80
1100 processes: 1006 sleeping, 88 running, 1 zombie, 5 stopped
CPU states: cpu user nice system irq softirq iowait idle
total 85.4% 0.0% 11.4% 0.1% 2.9% 0.0% 0.0%
cpu00 80.0% 0.0% 10.5% 0.5% 8.7% 0.0% 0.0%
cpu01 88.8% 0.0% 10.6% 0.0% 0.4% 0.0% 0.0%
cpu02 86.9% 0.0% 11.6% 0.0% 1.4% 0.0% 0.0%
cpu03 85.7% 0.0% 13.0% 0.0% 1.2% 0.0% 0.0%
Mem: 1538828k av, 1445064k used, 93764k free, 0k shrd, 35760k buff
1003984k actv, 226972k in_d, 23544k in_c
Swap: 2040244k av, 60404k used, 1979840k free 352124k cached
Unknown command `[' -- hit `h' for help
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND
12953 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 3 mysqld
12954 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12955 mysql 16 0 49092 47M 2472 R 0.0 3.1 0:00 0 mysqld
12956 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12957 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12958 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12959 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 3 mysqld
12960 mysql 16 0 49092 47M 2472 R 0.0 3.1 0:00 1 mysqld
12961 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12962 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12963 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12964 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12966 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12967 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12968 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12969 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12970 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12971 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12972 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12973 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12974 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12975 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12976 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12977 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12978 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12979 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12980 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 3 mysqld
12981 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 3 mysqld
12982 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12984 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 3 mysqld
12985 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12986 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 2 mysqld
12987 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12988 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld
12989 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 1 mysqld
12990 mysql 15 0 49092 47M 2472 S 0.0 3.1 0:00 0 mysqld


any ideas?

 

 

 

 

Top