They are in MyISAM. Maybe mysql querie are been queued but, should cherokee get into high cpu load with this circumstance ?,I think cherokee should try this without consuming all the cpu.
El 25/02/2009, a las 12:15, Javier De Posada escribió: > do you have MyISAM or InnoDB in your openx tables? Perhaps your high > cpu usage corresponds to oa_data_raw_ad_impression being locked by > the cleanup script and mysql queries being queued. > > > 2009/2/25 Antonio <[email protected]> > Hi all, > > this is my first post to this mailing list, I've just installed > cherokee under a production enviorenment and it work great with very > low memory usage compared to apache2 prefork + mod_php. The same setup > with apache get near 1.5G, memory with cherokee plus fcgi it take only > 160M !!, really great! The server is for openx with a high load. > > I have only find two problems, one of them a minor one but the other > one a littel more difficult to resolve. > > - First the easy one: its seem that with fcgi php don't set PHP_SELF > correctly and duplicate the url path to script: example: > > URI: /aplicacion/index.php > PHP_SELF: /aplicacion/aplicacion/index.php > > In my setup with openx this is not a problem but may cause problems > with other phpscripts. Is this a problem related to cherokee or to > php ? Searching in google I've seem similar problems with other webs > servers and php developers point the problem to the webserver. > > - Now the difficult one, HIGH CPU usage: openx have a maintenance > script that run in a cron jobs, I have it setup to be executed once > per hour. It's executed from cli and it's a very intensive script with > a high load to database (mysql) this is ok, but when this happen > cherokee get full cpu usage... ?? I think its a problem with > communication with php fcgi, under high database load, mysql didn't > respond enough fast and slow php5 cgi response, but cherokee is > getting a lot petitions and can't get response from php fcgi... may be > this the problem ? Under normal load all is ok. Apache with mod_php > didn't have this problem. Any sugestion ? > > I forget, my setup is a debian lenny into a linux-vserver with > cherokee from debian sid. > > Finally, thanks. Cherokee seem a great web server. > Regards. > > Antonio. > > _______________________________________________ > Cherokee mailing list > [email protected] > http://lists.octality.com/listinfo/cherokee > _______________________________________________ Cherokee mailing list [email protected] http://lists.octality.com/listinfo/cherokee
