rinku2012 Posted November 12, 2008 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
Bono Posted November 12, 2008 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
rinku2012 Posted November 16, 2008 Posted November 16, 2008 can you please tell me how can i look into those things . i dint installed xcache
rinku2012 Posted November 17, 2008 Posted November 17, 2008 its is saying temp@tolly.com [~]# mysql ERROR 1045 (28000): Access denied for user 'temp'@'localhost' (using password: NO)
Bono Posted December 8, 2008 Posted December 8, 2008 mysql -u root -p and enter your password. root= replace it with your user name.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.