MySQL Grinding the Server Down?

We have had our server crashing a couple of times a day. Now we asked the hosts to check it out.

They have tweaked it as much as they can and sent us this report. They say that possibly some our scripts are not compatible with mysql4.

Ill post the log they sent, does not mean much to me maybe someone can comment. Mostly we just have vbulletin and adcycle and whatever the hosted sites are running.

7:47pm up 2:38, 1 user, load average: 115.33, 110.59, 79.29
2130 processes: 2123 sleeping, 2 running, 4 zombie, 1 stopped
CPU states: 16.0% user, 20.9% system, 0.0% nice, 63.0% idle
Mem: 2054676K av, 2043424K used, 11252K free, 0K shrd, 10880K
buff
Swap: 2048276K av, 1716500K used, 331776K free 299700K
cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
19635 mysql 9 0 48948 8500 668 S 0.0 0.4 0:00 mysqld
19654 mysql 9 0 48948 8500 668 S 0.0 0.4 0:00 mysqld
19660 mysql 9 0 48948 8500 668 S 0.0 0.4 0:00 mysqld
19670 mysql 9 0 48948 8500 668 S 0.0 0.4 0:00 mysqld
19681 mysql 14 0 48948 8500 668 R 0.0 0.4 0:00 mysqld
19611 mysql 9 0 48944 8488 668 S 0.0 0.4 0:00 mysqld
19597 mysql 9 0 48928 8448 668 S 0.0 0.4 0:00 mysqld
2133 mysql 9 0 48860 8308 668 D 0.0 0.4 0:01 mysqld
16890 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16895 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16897 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16901 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16904 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16905 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16921 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16924 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16925 mysql 9 0 48880 7732 668 D 0.0 0.3 0:00 mysqld
16928 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16929 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16930 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16933 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16934 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16935 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16936 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16938 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16939 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16941 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16943 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16944 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16946 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16949 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16959 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16970 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16976 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16979 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16980 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16981 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16982 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16983 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16984 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16985 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16990 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16997 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16998 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
16999 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17001 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17003 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17004 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17007 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17008 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17011 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17012 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17013 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld
17015 mysql 9 0 48880 7732 668 S 0.0 0.3 0:00 mysqld

Any ideas?

THanks!

 

 

 

 

Top