Home >Database >Mysql Tutorial >mysql-There is a delay in local MySQL response, but the network and IO are normal. Is it an operating system problem? (win10)
mysql delay network win10
The software reads and writes the database an average of 500 times per second. A delay of 0 to 2 seconds occurs after it starts running. The delay seems to be periodic, as if the database only responds every two seconds.
Generally, you will definitely think that there is a problem with the software or the database settings, but there are two strange things.
1. With the exact same database and network, a computer with similar configuration will run perfectly without any problems. And native performance is not an issue at all.
2. There is a one-tenth chance that there will be no delay after starting the software, but we have not found the commonality every time. It is possible in various environments.
Another point is that when the computer is connected to the Internet, the delay will increase to about 3 seconds. Please tell me how to troubleshoot.
I suspect it may be a problem with win10. The problems with win10 that I have personally experienced so far include: 1. SQLServer cannot be installed correctly, 2. There are problems with the rendering of some websites, some js codes cannot run normally, etc., so I think this problem It may also be caused by win10. In fact, win7 is easier to use