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.