By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

I don't know why "$ per gb-month of provisioned gp2 storage running mysql". Please help me...

0

I'm using the rds free tier, and I think I've set up all the billing-related options properly. I've disabled auto-scaling storage, set the backup retention period to 0 days, and also turned off Multi-AZ. I also deleted all snapshots... Also, from the time of creation, I checked the general-purpose SSD and checked the minimum capacity of 200 GiB. I changed those options because there was a charge on 10/22 and I was expecting that there would be no charge on 10/23, but the charge was still occurring. Enter image description here "per gb-month of provisioned gp2 storage running mysql" Why is this happening? There is currently nothing in the table, just creating an rds instance, no ec2 instance.

  1. I have a MySQL workbench connected, is that a problem?
  2. Or do I still incur charges this month even if I modify the option because I already exceeded the free tier allowance once this month? In this case, will it be okay from next month?
  3. And it came out that there are 3 services in total, but I think I am using only one rds. Which menu should I go into to see the full range of services in use...

Any help would be greatly appreciated...

Topics
Migration & ModernizationAnalyticsDatabaseStorageCloud Financial Management
Tags
Amazon Relational Database ServiceAmazon AuroraStorageAWS BillingOracle to MySQL
Language
English
rePost-User-8275831
asked 2 years ago1639 views
1 Answer
2
Accepted Answer

Hi THere

RDS Free tier provides you with 20GB of General Purpose gp2 (SSD) Storage for free. [1]

In your screenshot, it shows that you have an additional 14.098 GB of gp2 storage which is why you are being charged. You have used a total of 34.098 GB of gp2 storage. If you reduce it back to 20GB, you wont continue to be charged, but the existing 1.85 will not go away. If you are only using 20GB starting next month, you wont be charged above the free tier.

Also, you mentioned

There is currently nothing in the table

You are charged for the amount of storage that you PROVISION, not for the amount of data in the database. So if you provision 20GB and have empty tables, you are still using 20GB.

[1] https://aws.amazon.com/rds/free/

profile pictureAWS
EXPERT
Matt-B
answered 2 years ago
profile picture
EXPERT
Giovanni Lauria
reviewed 21 days ago
  • rePost-User-8275831
    a year ago

    Thank you so much for letting me know!!! However, I have set up a general-purpose SSD, but I don't know why 20GB is provisioned... To be honest, I don't understand provisioning due to lack of study. Is it because I left the Enable auto-adjustment option on and then turned it off later?

  • Matt-B EXPERT
    a year ago

    Hi, yes its possible that storage auto-scaling increased your storage beyond the 20GB free tier. You can decrease the size but you will need to find out why there is an unexpected amount of data in your database.

    Take a look at this video for checking for unexpected data in MySQL: https://www.youtube.com/watch?v=dN7qxWl8g4I

    Then, take a look at this video for a walk-through of how you can decrease the size back to 20GB: https://www.youtube.com/watch?v=S-UfwHakF-Y

    Remember, the 20GB storage free-tier is calculated across ALL of your RDS instances in your account.

  • rePost-User-8275831
    a year ago

    Thank you so much for your help. It really helped a lot. have a good day!!!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content