Shulou(Shulou.com)06/01 Report--

This article mainly introduces how to solve the problem of 10055 error in mysql. It is very detailed and has a certain reference value. Interested friends must finish reading it!

The solution to the 10055 error in mysql: first check how many connections and wait connections there are in netstat, disconnect the software, then check the range of available dynamic ports, and finally configure it with the command.

The solution to a 10055 error in mysql:

When the software accesses the database frequently, the system dynamically allocates a port for each connection. By default, windows can allocate 16383 ports (65535-49152). In the case of large concurrency, the ports are used up.

First check how many connections netstat has and wait for connections, and then turn off the software and disconnect.

Take a look at the range of available dynamic ports:

Netsh int ipv4 show dynamicport tcpnetsh int ipv4 show dynamicport udpnetsh int ipv6 show dynamicport tcpnetsh int ipv6 show dynamicport udp

Configure through the command:

Netsh int set dynamic start= num=

The minimum value of start is 1025 num. The minimum value is 255. the maximum value is start+num.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.