Resolved mysqli - Cannot assign requested address between two server

[Dumitru]

Hello I have two servers with Plesk Onyx
One server for files , second for mysql (more the 1K request per /s)

If I have online visitor more then 700 it give me some error

PHP message: PHP Warning: mysqli::__construct(): (HY000/2002): Cannot assign requested address
.. while reading response header from upstream
And the request did't send

(the same site working well on plesk 12 with 2 servers)

Also I try to change on both server tcp_fin_timeout 60 to 30 -did not help
also on both server ip_local_port_range change to 1024 65000 - did not help

Other idea ?

 

[Dumitru]

Problem was solver:
#netstat -anlp | grep :3306 | grep TIME_WAIT -wc
before was - 60K now 400 wating

Add etc/sysctl.d/yourconfig.conf
net.ipv4.tcp_tw_recycle=1