Server load very high

[rinku2012]

Hello Everybody ,

my server config

Intel Dual core 3.0
2 GB RAM

my site runs on IPB 2.3.6

i have almost 45 K members and 120 K posts . my sql process are as follows

mysql		58.33	5.70	0.0

Top Process	%CPU 99.3	/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/dns2.sanindia.net.pid --skip-external-locking --port3306 --socket/var/lib/mysql/mysql.sock

Top Process	%CPU 93.5	/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/dns2.sanindia.net.pid --skip-external-locking --port3306 --socket/var/lib/mysql/mysql.sock

Top Process	%CPU 85.7	/usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/dns2.sanindia.net.pid --skip-external-locking --port3306 --socket/var/lib/mysql/mysql.sock

MYSQL is taking much load from last few weeks . my host said i need to upgrade my server . but is my server cant handle this site

[Bono]

This info doesn't help much, how many simultaneous users do you have on your board.
Have your tried installing caching software like xcache?
Login to mysql and do: \s and paste me here how many QPS do you have.

Something like this:
Uptime: 25 days 19 hours 34 min 0 sec
Threads: 23 Questions: 23785088 Slow queries: 117 Opens: 8662 Flush tables: 1 Open tables: 64 Queries per second avg: 10.664

[rinku2012]

can you please tell me how can i look into those things . i dint installed xcache

[Bono]

login to shell, type mysql and then enter \s

[rinku2012]

its is saying

temp@tolly.com [~]# mysql
ERROR 1045 (28000): Access denied for user 'temp'@'localhost' (using password: NO)

[Lindsey_]

Login in with the root account :-)

[Bono]

mysql -u root -p and enter your password.

root= replace it with your user name.