High CPU usage for Azure Database for MySQL servers despite very low infrequent use

Suhail Chander 20 Reputation points
2024-06-03T15:05:27+00:00

My Azure Database for MySQL server is showing high Host CPU percent despite very low infrequent load from us. We are using a Standard_B1s instance and our CPU credits keep running out. We have investigated what could be using up the CPU, but the server side code for our application is not making requests which correlate to the CPU usage spikes. We also know nobody else is directly making queries on the mysql instance when some of the spikes in CPU usage occur (for example at 3am). Additionally, we looked at the troubleshooting documentation for high CPU usage and confirmed it is not any of the issues listed such as a spike in active connections. The active connections and CPU usage don't show any correlation either.

How can we further investigate this problem? We have enabled server side logs but don't see any insightful logs. Is there a way to track what exactly is causing the high CPU usage? Could this be an issue with the hardware which we cannot control? Any advice would be appreciated!

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
757 questions
Azure Startups
Azure Startups
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Startups: Companies that are in their initial stages of business and typically developing a business model and seeking financing.
236 questions
0 comments
Accepted answer
  1. GeethaThatipatri-MSFT 29,007 Reputation points Microsoft Employee
    2024-06-03T15:36:42.6133333+00:00

    @Suhail Chander Welcome to Microsoft Q&A thanks for posting your question.

    Please refer to the answer provided by Rahul on this thread https://video2.skills-academy.com/en-us/answers/questions/1642061/azure-database-for-mysql-flexible-high-cpu-no-incr

    It appears that the high CPU usage issue you're experiencing with the Azure Database for MySQL servers, particularly with the Burstable B1s or B1ms instances, is indeed related to the CPU credit consumption

    As per the product team, the recommendation is, for production workloads, transitioning to either the General Purpose or Business Critical tiers. Please review performance limitations of burstable series instances  The Burstable tier is ideally more suited for non-production environments. To specifically address CPU-related issues, advise transitioning from the B1s/B1ms size to the B2s or B2ms, or a higher SKU.

    Regards

    Geetha

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest