4

I have a table in MySql at the moment, 7.3 million rows, 1.5GB in size if I run this query:

How to get the sizes of the tables of a mysql database?

I'm trying to get a handle on what a full table scan of that in AWS Aurora would cost me?

AWS lists it as:

I/O Rate - $0.200 per 1 million requests

But how do I possible translate that into "what will this cost me"?

Community
  • 1
  • 1
Kong
  • 8,230
  • 15
  • 63
  • 94

1 Answers1

0

See also https://stackoverflow.com/a/6927400/122441

As an example, a medium sized website database might be 100 GB in size and expect to average 100 I/Os per second over the course of a month. This would translate to $10 per month in storage costs (100 GB x $0.10/month), and approximately $26 per month in request costs (~2.6 million seconds/month x 100 I/O per second * $0.10 per million I/O).

Hendy Irawan
  • 19,112
  • 10
  • 100
  • 110