Share via

Azure App Service slow performance when connected to MYSQL Database

Sneha Rao 60 Reputation points
2024-07-25T18:45:42.3366667+00:00

I am hosting a PHP 8.2 on Linux Azure App Service (plan B2). My webapp name is fairytaleprod. The database is MySQL 8.0 running on Azure Database for MySQL flexible server(General Purpose, D2ads_v5, 2 vCores, 8 GiB RAM, 32 GiB storage). Both App Service and database are in the same region. App Service is set to 'Always On'.

When user loggin takes 2 to 3 minutes to load.

My question is: what is/are the cause(s) of this performance issue? Are those two recommendations really the causes of this problem?

I hope the connection from App Service to Azure DB, causing slow performance.

Previously my plan was Premium v3 P1V3 but it was still taking 2 to 3 min to load that specific page.

Thanks.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
846 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,900 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.