Databases
StackOverflow2013
Postsdbo
POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
    primarykey
    data
    text
    <p>I'm running nginx with php-fpm on a high traffic site. I let nginx communicate with php-fpm over tcp/ip, both nginx and the php-fpm pools running on the same server.</p> <p>When I use tcp/ip to let nginx and php-fpm pools communicate with eachother, the loading of pages takes a few (5-10) seconds before it does anything at all, and when it finally gets going, it takes no time at all for the loading to finish. Since the statuspage of php-fpm shows that the listen backlog is full, I assume it takes some time before the request is handled. Netstat shows a lot (20k+) connections in the TIME_WAIT status, don't know if this is related but it seemed relevant.</p> <p>When I try to let nginx and php-fpm communicate over a UNIX socket, the time before the page actually loads is reduced to almost nothing, and the time before the finished page is in my browser is 1000x less. Only problem with the UNIX sockets is that it gives me a LOT of errors in the logs:</p> <pre><code>*3377 connect() to unix:/dev/shm/.php-fpm1.sock failed (11: Resource temporarily unavailable) while connecting to upstream, client: 122.173.178.150, server: nottherealserver.fake, request: "GET somerandomphpfile HTTP/1.1", upstream: "fastcgi://unix:/dev/shm/.php-fpm1.sock:", host: "nottherealserver.fake", referrer: "nottherealserver.fake" </code></pre> <p>My two questions are:</p> <p>does anybody know why the tcp/ip method has such a large wait before it actually seems to connect to the php-fpm backend?</p> <p>why do the UNIX sockets cause problems when using this instead of tcp/ip?</p> <p>What I tried:</p> <p>set <code>net.ipv4.tcp_tw_recycle</code> and <code>net.ipv4.tcp_tw_reuse</code> to 1 when trying to decrease the number of TIME_WAIT connections (went down from 30k+ to 20k+)</p> <p>increased the <code>net.core.somaxconn</code> value from the default 128 to 1024 (tried higher too but still the same error when using the UNIX sockets)</p> <p>increased the max number of open files</p> <p>What is probably also quite relevant: tried using lighttpd + fastcgi, has the same problem with the long time before a connection finally gets handled. MySQL is not too busy, shouldnt be the cause of the long waiting times. Disk wait time is 0% (SSD disk), so a busy disk doesn't seem to be the culprit either.</p> <p>Hope that somebody found a fix for this problem, and is willing to share :)</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USWouter
    1. USWouter
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
      1. USaversag
      1. VTFavorite
    1. COUsing a name or an IP? Maybe a DNS resolution issue?
      singulars
      1. POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
      1. USAlex Howansky
    2. COusing 127.0.0.1
      singulars
      1. POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
      1. USWouter
    3. COWhat if you do `telnet 127.0.0.1 9000` from a shell prompt? Do you get the same delay before it connects?
      singulars
      1. POnginx <=> php-fpm: unix socket gives error, tcp connection is slow
      1. USAlex Howansky
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload