Is the server waiting on I/O? Perhaps an issue with php not cacheing your scripts and having to read from disk with every request? Try putting the files in a ramdisk. For any other reason, it seems odd that PHP is eating up CPU time and not MySQLd, under any circumstances. You might try to strace a process and examine the dump.
Something you could try is increasing max mysql connections and see if the problem gets better. How are you connecting to mysql - a pipe or TCP? Try a pipe if the latter. If that doesn't work and you don't feel like stracing (I normally save that for a last resort), try to make a simple test-case. Pare down or draft a PHP script that will cause this issue. Test with apache-bench or wget or something so you have good control. put a die() in the script and move it up line by line until the issue goes away and you will have found the culprit. Ryan McIntosh On Wed, Feb 25, 2009 at 6:13 AM, Javier De Posada <[email protected]> wrote: > 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 > > _______________________________________________ Cherokee mailing list [email protected] http://lists.octality.com/listinfo/cherokee
