[google-cloud-sql-discuss] Re: Google pricing for SQL

Hi Anthony, 

I can see you're using the `db-n1-standard-1` Instance from your screenshot. And you've used it for 96 hours. That instance is priced at $0.1158 USD per hour[1](for MySQL), therefore for 96 hours it'll be ~ $ 11.12 USD which will explain your € 7.08 charges. For a month (24 * 30 = 720h), as you can see from the documentation[1], the `Sustained Use Price` is lower per hour, therefore you will only be charged 0.0811 per hour, which would keep the price within the estimated price from the calculator.

Cloud SQL does offer smaller machine types: `db-f1-micro` and `db-g1-small` if the price is a concern for you at the moment.

The `movement` you see in the graph for Storage is related to the Instance doing the automatic backups.

[1] https://cloud.google.com/sql/pricing#2nd-gen-instance-pricing 

On Thursday, February 6, 2020 at 4:17:04 AM UTC-5, Anthony Griffith wrote:

Hi David 

Thanks for the reply. I had a look at the pricing, I have a screen grab of what the pricing should be as they state, and what I have set up. However the charge of 7e makes no sense as at that rate I am going to be charged 140e not 50e. I only spun up an instance and did a migration, with no data. There is hardly any Egress (I am the only one using it as testing). I also should be on micro not standard so that should reduce the price somewhat.

Also please look at the graph, (SQL storage used) how could be at 1.222G (or over) when all I have done is create an instance and put 3 tables in there and no data. Does this graph represent keeping the instance always on? Does this mean traffic? Its always climbing, despite inactivity. What storage could I possible have used? (That storage dip is when I created a new instance, but once again it rises without any activity)

Best regards

On Wednesday, February 5, 2020 at 11:21:43 PM UTC+2, Anthony Griffith wrote:

Hi there, 

I am trying to understand how the google pricing works for SQL. I am quite surprised by the charges I got and working out if I have done something wrong. 

I just set up an instance, did some migrations, seeding etc and noticed the pricing I got and data in the chart. I attached some images.

Also, the chart shows 1.245G of usage, is this for keeping a connection? 

So far its 7e for just that? I am one person who is using it at the moment. This is only for 2 days or so. 

Is this right? What if I get 100 or 1000 users using it regularly? is that going to be 7000e per day? 

Best regards

 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/27e92b29-bd52-4234-8c1a-df7e35a0205f%40googlegroups.com.