This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Hello,
I recently setup an Azure mySQL Database. It is type Standard_B1s (small yes). I have not created any databases at all. The only thing in there is the default database mySQL comes with. There are no users, no-one connecting to it. Looking at the CPU metric, sometime yesterday the CPU hit 100% when I sleeping and has been lingering there for no apparent reason.
I checked "trx_rseg_history_len" and it came back 0. HLL = 0. There are no backups running and connected users is just me while troubleshooting and "azure_superuser" user
I can't figure out why the host CPU is 100% when I don't even have a database on it yet.
Any help appreciated.
Thanks
Thank you for reaching out.
I would suggest to first review your workload and considering using a different tier from Standard_B1s if you need stable performance all the time:
Azure Database for MySQL - Flexible Server service tiers
Regards,
Oury
There is NO workload. NO user databases. Nothing to review.
Seems like the above answer was not helpful. Please allow me sometimes to dig further into this issue and get back shortly.
Regards,
Oury
Thank you for being patient while checking on this. Could you please create a support ticket so we can look further into this. Looks like this would need some troubleshooting.
Please let me know if yo don't have a support plan.
Regards,
Oury
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
It's unusual to see a sudden spike in CPU usage on the Empty MySQL Flexible server. Please take a look at the document 'Troubleshoot high CPU utilization in Azure Database for MySQL - Flexible Server.'
It provides queries that can help you identify the current workload and any background processes that might be causing the issue.
Thank You!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
He says and i quote "There is NO workload. NO user databases. Nothing to review." The queries are not useful. Can you spend a minute to understand the issue? Read this too please before responding.
https://learn.microsoft.com/en-us/answers/questions/1651773/whats-going-on-with-the-flexible-mysql-database
Hi @Jason Bennett,
It seems that the issue is related to some Burstable B1s or B1ms MySQL flexible servers, where CPU usage is high. Using 1 vcore with MySQLFS consumed CPU Credit and CPU can be heavily utilized.
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, we advise transitioning from the B1s/B1ms size to the B2s or B2ms, or a higher SKU.
Thank You!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 57.99999999999999%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
@RahulRandive If you're suggesting that it's expected that a burstable server will randomly go to 100% CPU and sit there when there is no user data or traffic on it, then why offer the product? You can't sell something that knowingly doesn't work, and there's laws in many countries that will tell you that.
Hi Phillip Parr,
Please feel free to open a support ticket to validate your server and determine the exact cause of the CPU spikes. The support experts can check the backend logs and provide you with the root cause of the increased CPU usage and can help in mitigating an issue.
Thank You!
@Oury Ba-MSFT Just waiting for my internal team to let me know who my internal MS contacts are, then I absolutely will 😊
Sounds good. Thank you
Ok so after having a Teams meeting with your support guys the answer is: You don't support the minimum tier, you won't look into why it's unstable, and your only advice is to upgrade to a General Purpose vs Burstable tier.
Given the price of the General Purpose tier, Azure is not a product I'd ever recommend to a small business. But, since I work for a corporation, I decided to test out another burstable compute size.
I moved from B1s 1 vCore 1GiB ($8.07/m) to B2s 2v Cores 4GiB ($48.84/m) and saw an immediate resolution to the issues. No longer was the CPU all over the place when under no load, but instead it is a fairly solid 2 - 3% when idle, except for a process that seems to be running for 1 hour every 8 hours which consumes 10%; no idea what this is, presumably it's an Azure process as it's not me.
Based on the simple difference of these two levels, I believe that your B1s offering for MySQL flexible server is fundamentally broken at this time, and it is frustrating that you will not look to resolve it.
Here's some graphs showing the minimum and maximum CPU usage, and the inserts / selects on the database. See if you can work out when I upgraded.