MySQL query very slow on Amazon RDS but really fast on my laptop?

Posted by Luc on Server Fault See other posts from Server Fault or by Luc
Published on 2011-09-27T10:24:48Z Indexed on 2012/10/26 11:04 UTC
Read the original article Hit count: 314

I would love to know if anybody knows why this is happening. i've just migrated over to Amazon RDS for our website and our biggest query which takes .2 seconds to execute on my macbook takes 1.3 seconds to execute on the most expensive RDS instance.

Obviously i've disabled query cache (and tested this) on my local computer and both databases are exactly the same. InnoDB, both have the same indexes etc. It's costing us a fortune ($2000 per month) for the fastest RDS instance and i'm losing faith quickly. any ideas?

© Server Fault or respective owner

Related posts about mysql

Related posts about amazon-web-services