Category: azure database for mysql
zeelo on Sun, 24 Jun 2018 23:46:36
Recently switched to Azure MySQL DB. Loaded about 7 GB's of test data to see how it performed. Dropped DB, which reduced my actual DB size to only a few Mb's. It has been a few days and the Azure dashboard is still showing a 20% storage usage out of 52GB's. I have spent a lot of time looking for a better way of seeing specifically what Azure is measuring or counting as used storage. Searching through the Docs it looked like I did everything correctly. My concern is that Azure improperly tracks my usage and switches my DB to read-only mode while it is in production.
MohitGarg_MSFT on Mon, 25 Jun 2018 23:16:38
The storage used by the service includes the database files, transaction logs, and the server logs. The server is marked read-only when the amount of free storage reaches less than 5 GB or 5% of provisioned storage, whichever is less. Also as backup of Azure MySQL DB is done automatically that will ensure that transaction log size is reduced.
The server is marked read-only when the amount of free storage reaches less than 5 GB or 5% of provisioned storage, whichever is less. I do not think you need to worry about database going to read only mode. Further, you can create alerts based on storage usage metrics and have an option to scale storage as online operation with no downtime.
In case you are still bothered about how the size is showing more than you expected, it will require you to create Azure Support Ticket with server name and region so that engineer can take further look at the logs to help on it.
zeelo on Mon, 25 Jun 2018 23:24:48
Thank you Mohit. Is there a procedure to force Azure to recalculate the database size? Where do I create that ticket at? Do I need to buy a service agreement?
zeelo on Tue, 26 Jun 2018 00:09:25
Thank you, I signed up for support and submitted a ticket.