nginx blocking during long running PHP request?

[mike]

I would suggest it's due to needing more fastcgi processes available -  
php max children etc. Also I would recommend trying to refactor the  
code and batch the job, denormalize the data or something else to get  
that load time down :)

On Feb 25, 2009, at 6:17 PM, Rt Ibmer <rtibmx at yahoo.com> wrote:

> I use nginx to frontend fastcgi and PHP.  I have a PHP page that  
> accesses a mySQL db and executes a query which takes about 30  
> seconds to execute.
>
> During that time, if I hit another php page on my site, the browser  
> just spins and does not load the php page until the other php page  
> finishes executing the query.
>
> I am not sure if it is nginx blocking somehow, or perhaps PHP can  
> only execute one page at a time (which would be a major bottleneck  
> when we go to production - right now we are just testing).
>
> Here is my location block that handles the PHP request:
>
> location ~ .*\.php$ {
>        include fastcgi;
>        fastcgi_read_timeout 180s;
>        fastcgi_pass  127.0.0.1:8888;
>        fastcgi_index index.php;
>        fastcgi_intercept_errors  on;
>        error_page  404         /404.php;
>        root    html;
>    }
>
> Am I missing a setting somewhere that is preventing nginx and/or PHP  
> from executing on multiple requests simultaneously?  What other  
> troubleshooting steps can I take?
>
> Thank you!
>
>
>
>
>
>