You are here: Re: FastCGI and DB connections / global variables? « PHP Programming Language « IT news, forums, messages
Re: FastCGI and DB connections / global variables?

Posted by Jerry Stuckle on 07/26/06 11:21

Joshua Ruppert wrote:
> Jerry Stuckle wrote:
>
>>Joshua Ruppert wrote:
>>
>>>With that said I'm not sure what my problem is. I have a website that
>>>has already been developed running Win2K and PHP 4, that I tried to
>>>switch over to FastCGI. When I did this every thing ran fine for a
>>>while, until we had a spike in traffic. (Since FastCGI was tried we
>>>have moved to Win2K3.)
>>>
>>>The root cause of the problems seems to be the response time of the DB
>>>servers but I'm not certain. When the database servers became loaded,
>>>the PHP processes seemed to hang while waiting for the database to
>>>respond. Eventually this effected each of the PHP processes started by
>>>FastCGI, completely taking down the site.
>>>
>>>The only way I found to restart the PHP processes is to reboot the
>>>machine, because task manager did let me kill the processes that were
>>>started by FastCGI.
>>>
>>>Is there anything that you could see (slow DB connections or otherwise)
>>>that would cause this kind of behavior?
>>>
>>>I used the PHPLens.com EasyWindows PHP Installer, but I'm having
>>>trouble finding resources to help me fine tune FastCGI opperation.
>>>
>>>Any suggestions are greatly appreciated.
>>>
>>>
>>
>>Is it possible you're getting into a deadlock situation? These are more
>>likely to show up when the database is busy, and you probably wouldn't
>>be able to cancel the task.
>>
>>P.S. - please don't top post. Thanks.
>>
>>--
>>==================
>>Remove the "x" from my email address
>>Jerry Stuckle
>>JDS Computer Training Corp.
>>jstucklex@attglobal.net
>>==================
>
>
> What do you mean by "top post"? Replying above the previous posts?
>

Yep. This is perfect. Thanks!

> No, I have not observed a deadlock. The site is 99% read only, so that
> greatly reduces the risk also. Isn't FastCGI suppose to clean up dead
> processes?
>


OK, are you sure you're closing your connections at the end of the
script? Waiting for PHP's gc to do it may take a little time.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация