Azure database for MySQL: what is the metric io_consumption_percent (IO percent) relative to?

Question

Azure database for MySQL: what is the metric io_consumption_percent (IO percent) relative to?

Gianluca Gippetto 41

Is this percentage relative to the maximum IOPS the VM supports or to the current maximum IOPS one is paying for? Thanks.

Accepted answer

0 additional answers

Your answer

Answer 1

Anurag Sharma 17,631

Hi @Gianluca Gippetto , welcome to Microsoft Q&A forum.

IO_Concumption_percent refers to the IOPS in use. This metric tells us at what point of time what was the IO consumption of our Azure MySQL Server relative to the maximum IOPS configured for server.

As an example for Single Server General Purpose tier 3 IOPS per GB is configured. So if we select a storage size of 100 GB then max IOPS will be 300. The metric IO Percent will then show the IO Percent in use keeping 300 as 100%. That means if IOPS is 150 for any interval it should be shown as 50% on the graph.

Azure Database for MySQL pricing tiers

Max IOPS configuration is little different in Flexible Server but the metric will be shown in similar way discussed above:

Compute and storage options in Azure Database for MySQL - Flexible Server

If we need more IOPS than the max IOPS based on compute then you need to scale your server's compute.

Please let us know if this helps or else we can discuss further.

Gianluca Gippetto 41 Reputation points

2022-06-13T12:07:09.52+00:00

Sorry, it's still not clear to me. My question is about flexible server. If I use a VM that supports max 3200 IOPS but I set IOPS limit to 1000 (from the UI), the percentage is relative to 3200 or 1000? Thanks.
Anurag Sharma 17,631 Reputation points

2022-06-13T13:27:10.92+00:00

Thanks for replying back.

Could you please clarify if you are using Azure Database for MySQL (PaaS) or you have installed MySQL Server on Azure VM? If possible, please provide the screenshot about how you are changing the IOPS.

If you are using Azure MySQL PaaS then your IOPS depends on tier you configure for Azure MySQL server and by changing storage we can increase/decrease it.

However I can provide exact details based on the above information I asked.
Gianluca Gippetto 41 Reputation points

2022-06-13T13:31:12.827+00:00

I'm using Azure Database for MySQL.
Anurag Sharma 17,631 Reputation points

2022-06-13T13:40:28.59+00:00

Thanks for the quick response. Whatever we configure through the IOPS slider, that will be considered in the percentage calculation. In your case if you set up 1000 IOPS, then that will be used for percentage calculation, not the max IOPS (3200 in this case).

Every compute size has the max IOPS available but not everyone needs to use the maximum value (less IOPS will incur less bill) and they can change it as per their needs. The value we configure is the value thats used in all the metrics.

Please let us know if this helps or else we can continue the discussion.
Gianluca Gippetto 41 Reputation points

2022-06-13T16:58:07.477+00:00

I deleted my last message, you can ignore it if you happened to read it.
Anurag Sharma 17,631 Reputation points

2022-06-15T11:29:53.167+00:00

No issues @Gianluca Gippetto , please let me know if you have any further queries.

If answer helped, you can mark it 'Accept Answer'

Share via

Azure database for MySQL: what is the metric io_consumption_percent (IO percent) relative to?

0 additional answers

Your answer