MYSQL has a phenomenon similar to self-protection in the face of a large number of page links. Originally, for an operation such as insert xx, there may be more than 100 connections to insert in one second, and then the database will suppress these 100 inserts. Not executed.
Then, for example, after an interval of about 15 seconds, all the previous ones are suddenly executed, which is very strange!!
The CUP usage chart is as follows:
*
*
*
It is a strange phenomenon that suddenly reaches a peak and then returns to 1%....
How can I make the database execute every operation normally...instead of gathering together and suddenly executing...(Suddenly executing a large number, It gets stuck directly, the web page gets stuck, everything gets stuck.... Is this the self-protection function of MYSQL?)
*The php page has closed this connection. I don’t know what’s going on.
*In netstat -an in cmd, I don’t see the program linking 3306, but there are connections to 49157, and the number is pitifully small. It doesn’t look like this A lot of time_wait.
*mysql configuration has been modified many times, such as improving cache, changing huge, etc. I feel that increasing the cache will only prolong the interval and will not achieve the effect.
*The maximum connection set is 500
