Jump to content

Server load very high

Featured Replies

Posted

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

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

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

login to shell, type mysql and then enter \s

its is saying

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

Login in with the root account :-)

  • 3 weeks later...

mysql -u root -p and enter your password.

root= replace it with your user name.

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.