Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the case of high mysql active connections, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

[problem phenomenon] what happened at around 4:15 this morning in MySQL? the application requests the database to see the connection timed out.

[problem summary] in this instance, the active_session active session suddenly increased from 4 to 957 at 04:14:40, although it did not reach the max_connections threshold of 16000, but the cpu utilization reached 100% in 04:15:09 seconds, which affected the new session session login in a short time. It is recommended to investigate the reasons for the sudden increase in sessions and optimize the obvious slow sql.

There is a logic in this. Although your session suddenly increases, the subsequent connection is not limited by your max_connections, but the cpu is suddenly full, causing the new connection to get stuck.

After reading the above, do you have any further understanding of the case of high mysql active connections? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.