Sunday, 15 February 2015

mysql - PHP pdo - to many Connections -


I have a Mozilla Js application, which is used with many views of the use of PHP-PDO data from a MySQL database. In addition, a nodjs application is bringing data every 30 seconds. From the same MySQL database.

While launching IIS to run angular and node apps on a Windows server, TCP connections are increasing for more than 100, with all the status "TIME_WAIT".

Is there a chance to reduce the waiting time to reuse connections or destroy the socket connection completely?

Connecting to each request is slow, you want constant connection and use of a connection pool In this way, the connection can be reused from one request on the next. There are fewer connections and faster response times than this.

There is more information about this.


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)