Hi,
we just migrated our DB from Amazon RDS to Google SQL. On Amazon our instance was a (db.r3.large 2 CPU 15GB of RAM) on Google SQL we have selected the D32 with 16GB of RAM.The migration worked ok and we transferred 40GB of data from AWS to Google Cloud. The two DBs have been set up with the same flags (innodb_flush_log_at_trx_commit=2,innodb_file_per_table=ON, etc.)
The problem is that we are experiencing very slow data fetch. The issue in not in executing the queries, almost all our queries can use indexes and are very quick to execute.
The issue in in the fetching, some time a query need 23 seconds of fetch time, if we re-run the same query the second time is very fast less than a second (I assume because data have been loaded in memory).
On Amazon RS we did not have this kind of issue, however we did have the Provisioned IOPS option which was probably helping a lot.
How can we improve the fetch time? Is it possible to have a SQL instance with Provisioned IOPS or running on SSD disks?
Thanks
Elia
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/14a98048-024d-4776-961a-4b698bcd0f69%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment