What to do if 10055 error occurs in mysql

The solution to the 10055 error in mysql: first check how many connections and waiting connections there are in netstat, and disconnect the software; then check the available dynamic port range; and finally configure it through commands.

Solution to the 10055 error in mysql:

When the software frequently accesses the database, the system will Dynamically allocate a port. Windows can allocate 16383 ports by default (65535-49152). In case of large concurrency, the ports will be occupied.

First check the number of connections and waiting connections in netstat, close the software and disconnect the connection

Look at the available dynamic port range:

netsh int ipv4 show dynamicport tcp
netsh int ipv4 show dynamicport udp
netsh int ipv6 show dynamicport tcp
netsh int ipv6 show dynamicport udp

Configure through the command:

netsh int <ipv4|ipv6> set dynamic <tcp|udp> start=<n> num=<n>

The minimum value of start is 1025, the minimum value of num is 255, and the maximum value is start num<65536

More related free learning recommendations: mysql tutorial(Video)

The above is the detailed content of What to do if 10055 error occurs in mysql. For more information, please follow other related articles on the PHP Chinese website!