Azure mysql server portal shows 150 GB extra used space than actual db sizeMySQL: How do I get my “Maximum possible memory usage” down?How to bind MySQL server to more than one IP address?Why is MySQL table_cache full but never usedScaling MySQL DatabaseMySQL Tuning — High Memory Usagemysqltuner script to optimize my mysql databasePostgres DB HDD needs expandingMS Azure cannot find webspace for subscriptionAzure web apps recycled at randomSigning in to Service Fabric Explorer fails with 'AADSTS65005: Invalid resource'
Where is Jon going?
These Two Cubes are The Only Ones That Are All Pure Prime..name them
What is Orcus doing with Mind Flayers in the art on the last page of Volo's Guide to Monsters?
The disk image is 497GB smaller than the target device
Complications of displaced core material?
Why was this character made Grand Maester?
Status of proof by contradiction and excluded middle throughout the history of mathematics?
How to teach an undergraduate course without having taken that course formally before?
To exponential digit growth and beyond!
Why is the Eisenstein ideal paper so great?
What could be my risk mitigation strategies if my client wants to contract UAT?
Is it safe to redirect stdout and stderr to the same file without file descriptor copies?
Is there a simple example that empirical evidence is misleading?
Why A=2 and B=1 in the call signs for Spirit and Opportunity?
Flatten not working
Is keeping the forking link on a true fork necessary (Github/GPL)?
Time complexity of an algorithm: Is it important to state the base of the logarithm?
Why does the painters tape have to be blue?
Why do the i8080 I/O instructions take a byte-sized operand to determine the port?
How to write numbers and percentage?
Fill area of x^2+y^2>1 and x^2+y^2>4 using patterns and tikzpicture
Is it normal to "extract a paper" from a master thesis?
Are PMR446 walkie-talkies legal in Switzerland?
Navigating a quick return to previous employer
Azure mysql server portal shows 150 GB extra used space than actual db size
MySQL: How do I get my “Maximum possible memory usage” down?How to bind MySQL server to more than one IP address?Why is MySQL table_cache full but never usedScaling MySQL DatabaseMySQL Tuning — High Memory Usagemysqltuner script to optimize my mysql databasePostgres DB HDD needs expandingMS Azure cannot find webspace for subscriptionAzure web apps recycled at randomSigning in to Service Fabric Explorer fails with 'AADSTS65005: Invalid resource'
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
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 ?
mysql azure azure-sql
asked May 9 at 9:16
Aki LanAki Lan
1
add a comment |
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 ?
mysql azure azure-sql
asked May 9 at 9:16
Aki LanAki Lan
1
4. They want you to pay for more RAM?
– Rick James
May 10 at 0: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 at 0:52
add a comment |
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 ?
mysql azure azure-sql
asked May 9 at 9:16
Aki LanAki Lan
1
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 ?
mysql azure azure-sql
mysql azure azure-sql
asked May 9 at 9:16
Aki LanAki Lan
1
asked May 9 at 9:16
Aki LanAki Lan
1
asked May 9 at 9:16
Aki LanAki Lan
1
asked May 9 at 9:16
Aki LanAki Lan
1
asked May 9 at 9:16
Aki LanAki Lan
1
1
4. They want you to pay for more RAM?
– Rick James
May 10 at 0: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 at 0:52
add a comment |
4. They want you to pay for more RAM?
– Rick James
May 10 at 0: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 at 0:52
4. They want you to pay for more RAM?
– Rick James
May 10 at 0:50
4. They want you to pay for more RAM?
– Rick James
May 10 at 0: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 at 0:52
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 at 0:52
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "2"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f966528%2fazure-mysql-server-portal-shows-150-gb-extra-used-space-than-actual-db-size%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f966528%2fazure-mysql-server-portal-shows-150-gb-extra-used-space-than-actual-db-size%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
4. They want you to pay for more RAM?
– Rick James
May 10 at 0: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 at 0:52