I have mysql installed on a physical server (name it Mysql A) and importing 1 MB .sql (from mysqldump) Magento file could take more than 5 minutes, and dropping database slow as well.
whereas importing the same .sql file into a mysql server that is installed on a VMware Virtual machine (name it Mysql B), it just takes 3 seconds.
the disk write/read test results on both physical and vm machine are equal.
Here is the settings on MySQL A (physical): http://pastebin.com/3qAxCJxz
and MySQL B (vm): http://pastebin.com/PqZePH8Z
both settings are default ubuntu mysql installations.
Any help on why it takes dramatically slower when importing/dropping database on my physical server? It's a HP Proliant ML-10 with 16GB of RAM, and Intel(R) Xeon(R) CPU E3-1220 V2 @ 3.10GHz and the VM's host machine specs and performance has the same benchmark results as the server #A