$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?

已提問 2 年前檢視次數 3473 次
10 個答案
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.

AWS
已回答 2 年前
  • 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."

3

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
已回答 2 年前
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?

已回答 1 年前
2

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

已回答 1 年前
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.

AWS
專家
Gokul
已回答 2 年前
  • 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
已回答 1 年前
0

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

已回答 1 年前
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.

已回答 1 年前
0

Has anyone turned it off and how?

已回答 1 年前
0

See the comment above by rePost-User-1104845. The issue is that the "Free" tier defaults set the allocated storage to 10 times the actual free tier amount. The only way around this we could work out was to:

  • create a new free tier instance, reduce it to 20 GiB from the default of 200 GiB

  • mysqldump the original database that was set at 200 GiB and could not be reduced

  • restore the mysqldump to the newly created free tier instance

  • delete the original database.

Fairly annoying, but doable.

Sitnos
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南