CODEWITHSUNDEEP
mysqlmysql-workbenchamazon-rds
Manish Sapkal
Manish Sapkal

Reputation: 6241

MySql localhost vs Amazon RDS instance

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.

I can not understand this behavior of mysql.

Upvotes: 2

Views: 1044

Answers (2)

spacediver
spacediver

Reputation: 1493

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.

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

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 :)

Upvotes: 3

Mike Lischke
Mike Lischke

Reputation: 53417

The query SELECT 1 nearly requires no parsing and no table access so its execution is quick. For remote servers however there's also the time to transmit the request and shared resources like RDS are not real-time resources, so it might take a millisecond or two to get the task executed. If there's no bigger difference then just ignore this little extra time.

Upvotes: 2

Related Questions