[google-cloud-sql-discuss] Re: CPU control

Hey Anton,

I believe that the RAM changes between instance-tiers should only help the query up to a certain point. After that, the main optimization is CPU, which doesn't appear to be different between the tiers. I have to ask to sanity-check, and it seems as though you are reporting the actual DB query time, but is ~40ms including network transfer? It seems not, but just worth asking. 

You could also create a MySQL server box using Compute Engine, selecting a highcpu instance to see a faster query. I think there'd be no harm in making a Cloud Platform Public Issue Tracker feature request for Cloud SQL instance tiers to either allow increased CPU or at least specify CPU in the docs.

Best wishes,

Nick

On Friday, September 4, 2015 at 7:02:41 PM UTC-4, Anton Astashov wrote:

Hi!

I started to use Google Cloud SQL, and noticed that it's pretty slow on my database. I have 25GB database, most of it is just one table - about 100 million records.

It takes ~40ms in average to insert a record into that table (though on my Macbook Pro 2013 it takes ~0.2ms). The tier almost doesn't affect the insertion times (after D8 the difference is neglectable).

What CPU do these instances have? Is there any way to use more powerful instances? It seems like I only can choose RAM there...

Thanks!

--
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/2fc30bd5-a56a-4087-b14c-858dacce6988%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.