mysql overload , RAM reach 85%

Please help.

How to tune mysql.cnf if meet cpu load like below:

Top Process %CPU 96.2 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/rh.xxx.com.pid --skip-locking
Top Process %CPU 96.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/rh.xxx.com.pid --skip-locking
Top Process %CPU 17.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/rh.xxx.com.pid --skip-locking

My server:
DUAL XEON 3.06
RAm 2 GB
RHE + php4.3.10 + mysql 4.0.22

regards
Robert Xtra

 

 

 

 

Top