Active connections when database not open to public access

Mark Buckley 20 Reputation points
2024-06-04T16:34:22.6366667+00:00

I have an Azure MySQL database which is currently running a high daily cost just in IO operations, even on days when I'm not using the database.

I'm trying to cut costs and I noticed that I have an average of 100 select queries being run every 5 minutes even though I'm not using it, I tried to disable public access but its still showing as having 4 active connections and 100 select queries every 5 minutes

I'm wondering is there any services being run on the database that I can disable to reduce costs?

I would appreciate any tips on keeping costs down as well!

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
    2024-06-04T21:35:01.1066667+00:00

    @Mark Buckley Welcome to Microsoft Q&A thanks for posting your question.

    If your compute resources are underutilized, consider scaling down your compute tier or size (vCores). If your workload doesn't require continuous full compute capacity, switching to the Burstable compute tier might be more cost-effective.

    Use Azure Advisor to get recommendations on server right-sizing and other cost optimization strategies. It provides daily checks and suggestions based on your server's performance history

    https://video2.skills-academy.com/en-us/azure/mysql/flexible-server/concepts-service-tiers-storage

    https://video2.skills-academy.com/en-us/azure/mysql/flexible-server/concepts-azure-advisor-recommendations

    Regards

    Geetha

    0 comments