Azure / Azure/azure-mysql

Azure MySQL Flexible crashing with Max Active Connections

Open
#286 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
PHP
Stars
53
Forks
88
PR merge metrics
No merged PRs in 30d

Description

Hello,

I'm using WordPress on the App Service created by Azure Market Place 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 show consumption that justifies this sudden increase in active connections

WebApp = PremiumV3 (P2v3)

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

Currently the max_connections parameter is 1365

The number of active connections ~54, which is much lower than 1365

What could be the root cause of this problem? Since it is not high consumption of the application? Any backup of the bank server? The bank logs on the dashboard don't show much.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reviewing Azure App Service and Flexible MySQL metrics and the database dashboard logs for the period when active connections reached about 54 and CPU reached 100%. Compare the connection, CPU, and application behavior to identify a reproducible root cause; done means documenting the cause and an actionable mitigation.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, mysql, wordpress
Domain
backend, cloud, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.