Question

SamK135 on Wed, 04 Jul 2018 23:30:02


All of a sudden, I started receiving the below error message. After further investigation, it seems like Azure is telling me that I am running out of storage. However when I checked, the size of my mySQL database is only few MBs large. I have assigned close to 100 GBs to the mySQL database server and I am still running out of space. Azure is showing me that the size is increasing exponentially but when I check the size of my databases, it hasn't changed.

Any leads on where to look for will be greatly appreciated.  

Error:  "The MySQL server is running with the --read-only option so it cannot execute this statement" 

 

Replies

Mike Ubezzi (Azure) on Mon, 09 Jul 2018 20:20:11


Hi SamK135,

Please review this thread, as it discusses this specific scenario.

It contains a link to documentation about what is occurring and how to address the issue. 

How much space do you have allocated and how much space is being consumed? Please include details. 

Thanks,

Mike

SamK135 on Mon, 16 Jul 2018 03:30:30


After working with MS support I still haven't got a satisfactory answer about why the storage increased so dramatically and where was this storage used. My databases were empty with less than <5MB in size. Microsoft base support plan on Azure is a joke. MS Support did not respond for days. The only way I got their attention was to reach out to them on twitter and complain publicly about it. The solution to most issues which the support suggests is to restore the DB to a new database which I believe is unacceptable. 

In my opinion, Microsoft's Azure MySQL PaaS offering is not ready for prime time. Avoid it for a production consumer facing application. Smaller workloads may work fine.