MySql本地主机与Amazon RDS实例 [英] MySql localhost vs Amazon RDS instance

问题描述

我对某些mysql性能感到惊讶. 当我运行简单查询"SELECT 1;"时在使用工作台的本地主机(mysql 5.6.x)上，它的执行时间为0.000s，但是我在Amazon RDS(中等mysql 5.5.x)上运行的同一查询花费了将近0.094s.

I have surprise with some of mysql performance. When I run simple query 'SELECT 1;' on my local host (mysql 5.6.x) using workbench, its execute in 0.000s, but the same query I ran on Amazon RDS (medium mysql 5.5.x) it tooks almost 0.094s.

我无法理解mysql的这种行为.

I can not understand this behavior of mysql.

推荐答案

我建议您现在就在性能上简化维护和可扩展性(RDS显然比本地MySQL更好).

I would propose that you go for simplicity of maintenance and scalability (which RDS apparently provides much better than local MySQL) over performance for now.

后来，当您获得的产出不足以支付给Amazon的美元时，您可以开始仔细衡量以发现瓶颈.

Later on, when you get insufficient output for dollar paid for Amazon, you could start measuring carefully to find bottlenecks.

尽管如此，如果您习惯于维护紧密包装的私有VPS服务器-本地MySQL维护起来可能更加简单，那么您应该只在更长时间之后才使用外部服务:)

Nonetheless, if you are used to maintain private tightly packed VPS servers — local MySQL could be more simple to maintain, and you should only go for external services much later :)

这篇关于MySql本地主机与Amazon RDS实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！