$0.115 per GB-month of provisioned gp2 storage running MySQL | I have created only 3 tables in my database and it doesn't contain any data at all. My bill shows 169GB of usage just for 12 Days. HELP!

4

I am using RDS free tier instance with MySQL engine. I chose the t2.micro instance and the storage space is 20GB and the limit is 1000GB. I have created only a few tables so far and the bill (169GB-Month - $12.87) is so high that doesn't add up to the actual usage (Could be less than 10 MB). How can I see the RAW data for my total usage? or how the storage is calculated and billed? What does include in the GB-Month? Can someone please help me understand and suggest another cloud service as I am not satisfied with AWS services (including customer support). How can a few tables with no data at all consume 169GB in 12 days of time?

asked 8 months ago1393 views
8 Answers
3

According to DB instance billing for Amazon RDS, "GB-Month" refers to Backup storage:

Backup storage (per GiB per month) – Backup storage is the storage that is associated with automated database backups and any active database snapshots that you have taken. Increasing your backup retention period or taking additional database snapshots increases the backup storage consumed by your database. Per second billing doesn't apply to backup storage (metered in GB-month).

If you go to "Modify" your RDS DB instance, you can modify the retention period to anything between 0 days to 35 days.

yann
answered 8 months ago
  • Hello, Thank you for your reply. But, I have used at most 10MB of storage space. And, I haven't opted for any other services other than the free trial options. How come it will reach 169GB? My backup retention period is for 7 days, and how will it increase the storage drastically from less than 10MB usage to 169GB? Can you tell me how and where to check the backup storage usage? I checked the monitoring tab in the dashboard and the bar in the 'Free Storage Space' section is at 20000.

  • I think the number you want to look at is not the amount of storage space used but the amount of storage space provisioned. For example, let's say I provision an RDS instance with the default of 100 GiB of storage and I don't use any of that storage. Then I will have used 0 GiB of storage but I'm paying for the 100 GiB of storage that I provisioned, because no one else can use that space while I've provisioned it. And you can find your backups in the left-hand menu under "Automated Backups."

2

Same Issue here. I created a MYSQL DB with free tier configuration.

At the start, the automatic backup was enabled with a retention of 7 days. But when I saw that it was generating costs I disabled this. Now I have no backups configured or saved and my costs are getting higher daily.

What else I can do instead of not using RDS for my project? I am testing a solution now and these hiding costs that have RDS are telling me that I should use RDS?

answered a month ago
2

Hello!

I'm experiencing the same issue. As it is mentioned here, I have 0 days configured for the backup retention period. However, the storage still increasing at a rate of 1.5 GB per day.

Just to clarify, I have configured all the services to be within the free tier. I have no clue what's going on and I don't even know what to do to stop the consumption.

Apart from that, I also don't know which storage is the one that has been increasing (data or backup storage) because the AWS platform only says that the increasing is in the RDS Storage (it doesn't distinguish between both types of storages).

Thank you in advance!

techdep
answered 4 months ago
1

Hi - From the FAQs: https://aws.amazon.com/rds/faqs/

The AWS Free Tier for Amazon RDS offer provides free use of Single-AZ Micro DB instances running MySQL, MariaDB, PostgreSQL, Oracle ("Bring-Your-Own-License (BYOL)" licensing model) and SQL Server Express Edition. The free usage tier is capped at 750 instance hours per month. Customers also receive 20 GB of General Purpose (SSD) database storage and 20 GB of backup storage for free per month.

Backup storage is the storage associated with your automated database backups and any customer-initiated DB snapshots you have in a region. Increasing your backup retention period or taking DB snapshots increases the backup storage consumed by your account.

Important points to take in consideration: https://aws.amazon.com/rds/mysql/pricing/?pg=pr&loc=2

  • Backup storage is allocated by region. Total backup storage space is equivalent to the sum of the storage for all backups in that region.
  • Moving a DB snapshot to another region increases backup storage in the destination region. You can move a DB Snapshot to another region manually by using DB Snapshot Copy or automatically by enabling Cross Region Automated Backups.
  • Multi-AZ and Single-AZ configurations are treated the same from a backup storage perspective.
  • After the DB instance is terminated, backup storage is billed at $0.095 per GiB-month.
  • Additional backup storage is $0.095 per GiB-month.

As you can see on the last 2 points above, the back up storage is billed $0.0095 per GiB-month after a DB instance is terminated. This means that the 20 GB free back up storage of the free tier will be applied as free as long as the back up storage is attached to a running instance.

Adjusting your Backup retention period and cleaning up the backup storage after terminating your DB instance will reduce your storage cost.

EXPERT
Gokul
answered 8 months ago
  • Hello @Gokul, Thank you for your reply. But, I have used at most 10MB of storage space. And, I haven't opted for any other services other than the free trial options. How come it will reach 169GB? My backup retention period is for 7 days, and how will it increase the storage drastically from less than 10MB usage to 169GB? Can you tell me how and where to check the backup storage usage? I checked the monitoring tab in the dashboard and the bar in the 'Free Storage Space' section is at 20000.

  • Hi - Please try navigating to the Account Activity page in Billing and Cost Management console using the steps outlined in https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/invoice.html. On the Bills page, select the month from the Date list and view the summary and details of your charges for that month. Here you should be seeing which region, service and the reason for the charges. You can probably start your investigation from the Bills page.

0

I'm having the exactly same issue. Has anyone found a solution to this?

Thank you

ggmed
answered a month ago
0

I have the same problem. Exploiting charges by generating unfamiliar usage while claiming to be free is equivalent to fraud.

answered a month ago
0

I'm having the exactly same issue. Has anyone found a solution to this? It's really smells like a fraud

answered a month ago
0

Hi,all.

I found the underlying problem.

When trying to create an RDS in MySQL, I found that the "Allocating storage" is set to 200 (GiB) by default. This is clearly a setting that is maliciously bullying the free tier.

And I found that the DB needs to be recreated because I can't make the allocation smaller on the change screen.

answered a month ago

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