Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am testing an AWS Medium Instance with CentOS (AWS AMI) and comparing it with Hetzner's EX40-SSD (http://www.hetzner.de/hosting/produkte_rootserver/ex40ssd). Software setup on both is comparable( Same OS, Same version of MySQL 5.6.14). CPU Speed of AWS was 2Ghz and CPU Speed of Hetzner was 3.4GHZ. mysql my.cnf was exactly same for both the servers. Have a large abc.sql file which has dump from another server (2GB Size) copied locally onto both the above servers. I ran the following command on both the machines date > StartTime ; mysql -pxyz < abc.sql ; date >> StartTime &

Strangely, the AWS Small instance completed the task in 12 mins where as the Hetzner instance took more than 40 mins to complete the task.

There are no other servers/apps running on Hetzner machine (Clean machine with only MySQL). AWS Machine has other software running like SugarCRM, Piwik, Nginx, but not loaded.

What could be the reason why the AWS outperformed the Hetzner ? Logically, Hetzner should be faster as it has SSD (Faster IO), faster CPU (3.4Ghz) and operating as Dedicated Machine and not a VM instance. How to debug and trace the root cause for such strange behavior.

share|improve this question
    
Side Question: Do you have MySQL's binary logging enabled on the Hetzner machine ??? –  RolandoMySQLDBA Oct 25 '13 at 16:14
    
You are running the mysql client remotely from both machines, right? (Obviously "yes" for RDS since there is no shell access on RDS, but I don't know about the other). If yes, then the available bandwidth and (to a lesser extent) round-trip time between you and the MySQL server can be a big factor. I would suggest testing again, supplying the --compress option to the mysql client to enable use of the compressed client/server protocol, which could cause a notable difference if this is the issue. –  Michael - sqlbot Oct 25 '13 at 17:35
    
RolandoMySQLDBSA: Yes Binary logging enabled on both the servers: –  Subramanyam Oct 26 '13 at 7:51
    
Michael-sqlbot: Am not using RDS. I am running an EC2 Instance with Linux and MySQL. No, The Mysql client is not running remotely. For both the servers the Mysql client is running on the specific server only. There is no Network related variable. –  Subramanyam Oct 26 '13 at 7:52
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.