Well, i get about 1000 queued connections in about 2 minutes when I run some repair or optimize on that table. Perhaps it's the way php deals with mysql connections when running in fcgi mode?
2009/2/25 Antonio <[email protected]> > 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 >
_______________________________________________ Cherokee mailing list [email protected] http://lists.octality.com/listinfo/cherokee
