How much does google charge for inserting info into a Cloud SQL table?

[pedrocano]

I've created an instance with a MySQL database, and I would like to know how much money is going to cost the insertion of 100 rows. I've noticed that the instance has a cost per month, but I don't how to check how much it will cost me for inserting 100 rows into the database.

[GlebO]

Hi,

Cloud SQL pricing is compute (CPU), memory, storage and network. It doesn’t charge per rows inserts. Ingress is free but since usually you have two way communications then some bytes from database will travel through egress. The egress traffic is hard to estimate but for an insert it is not supposed to be significant. 

All the pricing is listed here - https://cloud.google.com/sql/pricing

Hope that help,

Gleb

[anjelisa]

Hi @pedrocano,

That's not really how the MySQL database pricing works. 

Cloud SQL Pricing is broken down with the following charges:

• CPU and memory pricing
• Storage and networking pricing
• Instance pricing

You may check each link for more info or see this Cloud SQL pricing for MySQL. You may also refer to this pricing examples page to see how you can calculate your potential costs. 

Google Cloud also has a pricing calculator you can use that can help you with your estimation. You can input the number and type of instances, location, storage, and average hour per day/week the database will be running. 
Hope this helps.