<html><body bgcolor="#FFFFFF"><div>Are you using something that runs php -b or spawn-fcgi? Obviously not php-fpm. <br><br>On Feb 25, 2009, at 6:56 PM, Merlin <<a href="mailto:merlin@mahalo.com">merlin@mahalo.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div>You may need to look at your fastcgi setup and see how many children and requests you have available. <br><br># more /etc/default/php-fastcgi <br># Should php-fastcgi run automatically on startup? (default: no)<br>START=yes<br>
<br># Which user runs PHP? (default: www-data)<br>EXEC_AS_USER=www-data<br><br># Host and TCP port for FASTCGI-Listener (default: localhost:9000)<br>FCGI_HOST=localhost<br>FCGI_PORT=9000<br><br># Environment variables, which are processed by PHP<br>
PHP_FCGI_CHILDREN=4<br>PHP_FCGI_MAX_REQUESTS=1024<br><br><br><div class="gmail_quote">On Wed, Feb 25, 2009 at 6:17 PM, Rt Ibmer <span dir="ltr"><<a href="mailto:rtibmx@yahoo.com"><a href="mailto:rtibmx@yahoo.com">rtibmx@yahoo.com</a></a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">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.<br>
<br>
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.<br>
<br>
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).<br>
<br>
Here is my location block that handles the PHP request:<br>
<br>
location ~ .*\.php$ {<br>
include fastcgi;<br>
fastcgi_read_timeout 180s;<br>
fastcgi_pass <a href="http://127.0.0.1:8888" target="_blank">127.0.0.1:8888</a>;<br>
fastcgi_index index.php;<br>
fastcgi_intercept_errors on;<br>
error_page 404 /404.php;<br>
root html;<br>
}<br>
<br>
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?<br>
<br>
Thank you!<br>
<br>
<br>
<br>
<br>
<br>
<br>
</blockquote></div><br>
</div></blockquote></body></html>