Jump to content

Server load very high

Guest Idreamssrikarv

Recommended Posts

Hello Everybody ,

my server config

Intel Dual core 3.0

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 3 weeks later...


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

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...