Azure mysql server portal shows 150 GB extra used space than actual db size

Asked May 09 '19 at 09:16

Active May 09 '19 at 09:16

Viewed 111 times

I'm using azure mysql database, Azure portal shows total of 350 GB of used space but when I analyzed using schema inspector the total size used is 205 GB. what might be cause of extra storage.

My assumption are,

Azure redundancy
Server parameter value set to high
Due to cached data

If it's due to server parameter, what are the parameter values I need to reconsider ?

asked May 09 '19 at 09:16

Aki Lan

4. They want you to pay for more RAM? – Rick James May 10 '19 at 00:50
Can you see the disk space being used for the various logs? Still, 145GB is much too high unless something is going wrong and spitting out lots of stuff. Get access to the logs. – Rick James May 10 '19 at 00:52

Azure mysql server portal shows 150 GB extra used space than actual db size

0 Answers0