Hello Why i have so much server load? I am using Cpanel server with nginx plugin as proxy and back i am using Apache and csf firewall + ddos deflate script. Nginx in front of apache and i use as php handler the fcgi. 2x quad xeon cpu raid 10 sas disks and 16gb ram Only one forum on the server, Any ideas?
170-290% CPU by mysql? Have you optimized your mysql? Try doing so with mysqltuner and tuning primer. Old articles but might be useful as instructions to get them running: http://www.howtoforge.com/tuning-mysql-performance-with-mysqltuner [mysqltuner] http://www.day32.com/MySQL/ [tuning primer] It's basically optimizing with trials. Don't change any values just like that, increase/decrease slowly. Also, since it's a forum, you might want to adjust the timeouts to something lower as well and configure the nginx/fcgi worker and child values.
Sql is optimized. I think Apache or Php configuration is wrong for performance for dynamic content. But i don;t know what setup will give me best performance....