Share via

Azure MySQL Flexible crashing with Max Active Connections

Uziel Silva 71 Reputation points
2024-06-20T14:47:48.3666667+00:00

Hello,

I'm using WordPress on the App Service and whenever I reach ~54 active connections, the CPU starts to increase reaching 100% usage and the application becomes unavailable.

The App Service plan does not have high consumption.

WebApp = PremiumV3 (P2v3)

MySQL Flexible: Standard_D4ads_v5 (4 vCores, 16 GiB memory, 1000

iops)

Currently the max_connections parameter is 1365

What could be happening for the quantity of ~54, which is much lower than 1365, to cause this problem?

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
756 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,258 questions
0 comments
Accepted answer
  1. Oury Ba-MSFT 17,631 Reputation points Microsoft Employee
    2024-06-21T19:28:07.76+00:00

    @Uziel Silva

    Thank you for reaching out and for posting your question on Microsoft Q&A.

    During the occurrence of CPU spikes, troubleshooting can be performed to identify the processes that were active. Additionally, we have a public document available. The below doc should help.

    Troubleshoot high CPU utilization in Azure Database for MySQL - Flexible Server

    Regards,

    Oury

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest