Google Cloud SQL速度很慢 [英] Google Cloud SQL is slow
问题描述
我有一个D0大小的Cloud SQL实例.当我运行一个简单的
I have a D0 size Cloud SQL instance. When I run a simple
select * from table
大约有500行，平均执行时间为100毫秒(如SQL Prompt所报告).而在我的MySQL 5.5本地实例上，只需要1毫秒.我的开发机具有2.9GHz双核Intel Core i7和8GB 1600MHz内存.我已经阅读了常见问题解答，该数据库的性能取决于大小-较大的实例具有更多的RAM和CPU.
which has around 500 rows, it takes on average 100 ms to execute (as reported by SQL Prompt). Whereas on my local instance of MySQL 5.5, it takes only 1 ms. My dev machine has 2.9GHz dual-core Intel Core i7 and 8GB 1600MHz memory. I've read in an FAQ that performance of db depends on the size - larger instances have more RAM and CPU.
用更大的实例大小解决性能问题是否合理?还是我在这里想念其他东西?
Is this reasonable to expect performance issues resolved with larger instance size? Or am I missing something else here?
推荐答案
这是我们于2019年1月发布的更新.
Here's our update in January/2019.
将Google Cloud SQL SECOND GENERATION与4vcpu + 15GB RAM实例中的46GB数据库一起使用，我们发现即使与运行默认mysql安装且仅分配125MB内存的dev macbook pro相比，它的运行速度仍然非常可笑:
Using Google Cloud SQL SECOND GENERATION with a 46GB database in a 4vcpu + 15GB RAM instance, we found it can be ridiculously slow even when compared to a dev macbook pro running the default mysql install with only 125MB of memory allocated to it:
