rinku2012 Posted November 12, 2008 Share Posted November 12, 2008 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 followsmysql 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 More sharing options...
Bono Posted November 12, 2008 Share Posted November 12, 2008 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 More sharing options...
rinku2012 Posted November 16, 2008 Share Posted November 16, 2008 can you please tell me how can i look into those things . i dint installed xcache Link to comment Share on other sites More sharing options...
Bono Posted November 16, 2008 Share Posted November 16, 2008 login to shell, type mysql and then enter \s Link to comment Share on other sites More sharing options...
rinku2012 Posted November 17, 2008 Share Posted November 17, 2008 its is saying temp@tolly.com [~]# mysql ERROR 1045 (28000): Access denied for user 'temp'@'localhost' (using password: NO) Link to comment Share on other sites More sharing options...
Lindsey_ Posted November 17, 2008 Share Posted November 17, 2008 Login in with the root account :-) Link to comment Share on other sites More sharing options...
Bono Posted December 8, 2008 Share Posted December 8, 2008 mysql -u root -p and enter your password. root= replace it with your user name. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.