This are env for php-fcgi: PHP_FCGI_CHILDREN = 5 PHP_FCGI_MAX_REQUESTS = 2000
mysql max connections are 1500. I'm runing APC cache and IO wait isn't a problem. As Javier point, while maintenance script is running importan tables from openx are locked (MYISAM in mysql... openx didn't recomend InnoDB... I always ask why didn't use pgsql!?) so php can't respond and mysql request are queued. In this situation cherokee-worker get all CPU, not php... may be cherokee are getting a lot petitions that php don't respont to. I will try to strace cherokee-worker that eat all cpu. All this is in a new server where maintenance scripts get only 4min to finish. In the old server with apache2-prefork + mod_php5 maintenance script need more than 30min to finish! with a lot IO wait problems and never get this kind of problem. I'll have to try new cheroke version :) it seem to solve issues in fcgi. Obviously this problem isn't from cherokee, the problem came from how openx work with mysq with high load, but cherokee implementation of fcgi should be more tolerant to this kind of problems and if don't get respond from fcgi don't eat all cpu. Although, thank to cherokee, I've discover a big problem with openx and mysql. Two solutions: - Migrate to postgres: difficult task - Alter mysql engine from myisam to innodb: easy, but... how will affect performance... _______________________________________________ Cherokee mailing list [email protected] http://lists.octality.com/listinfo/cherokee
