Great performance difference importing a dump
Hi,
I'm trying to import a dump of about 3 MB into a mysql 5.6 server. It's installed over Debian 7.2 64 bit in Kvm virtual environment through the deb package available on mysql site. It took about 5 minutes to complete the import. In the dump, there are about 100 tables with a very few number of rows for each table.
I have another Debian 7.2 64 bit virtual machine (same hardware configuration) over the same physical machine but with MySQL 5.5 installed through apt-get command. It took just few seconds (about 10) to load the same dump. I tried to check all the configuration variables and I tried to have two identical setup, but I cannot understand why there is this difference in import process...
I'm sure it's something about the configuration, but I cannot figure out what..
Could you help me?
Thank you very much!
Subject
Views
Written By
Posted
Great performance difference importing a dump
1825
November 24, 2013 11:46AM
980
November 25, 2013 09:38AM
889
November 25, 2013 04:24PM
819
November 26, 2013 04:56PM
829
November 27, 2013 03:37AM
946
November 28, 2013 12:50AM
803
December 02, 2013 06:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.