Hello everybody i am using a linux server 12 Gb Ram intel i7 720 8 core i am currently encoutring a problem of CPU load caused by Mysql i think. the server recieve same times more then 2500 simultaneous user an exemple of running process : CPU load averages: 5.50 (1 mins) , 19.47 (5 mins) , 18.08 (15 mins) CPU type: Intel(R) Core(TM) i7 CPU 920 @ 2.67GHz , 8 cores ID Owner CPU Command 20472 mysql 140 % /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-f ... 9106 apache 6.0 % /usr/sbin/httpd 9090 apache 4.0 % /usr/sbin/httpd 9100 apache 4.0 % /usr/sbin/httpd 9103 apache 3.5 % /usr/sbin/httpd 9081 apache 3.1 % /usr/sbin/httpd 9097 apache 3.0 % /usr/sbin/httpd 9102 apache 3.0 % /usr/sbin/httpd 9111 apache 3.0 % /usr/sbin/httpd 9080 apache 2.7 % /usr/sbin/httpd 9088 apache 2.6 % /usr/sbin/httpd 9105 apache 2.5 % /usr/sbin/httpd 9093 apache 2.3 % /usr/sbin/httpd ... any help or suggestion or advice will be grateful
You can try to optimize MySQL and Apache: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html http://www.howtoforge.com/configuring_apache_for_maximum_performance
