Re: Great performance difference importing a dump
Posted by:
Rick James
Date: November 26, 2013 04:56PM
How much RAM, etc, is allocated to your VM?
SHOW VARIABLES LIKE '%buffer%';
If 3MB is the size of the file you are loading, it is hard to imagine the sluggishness. Even considering 100 tables -- that would be 3 seconds per table.
Could it be that the rest of the server is hogging the disk, or something?
Subject
Views
Written By
Posted
1824
November 24, 2013 11:46AM
979
November 25, 2013 09:38AM
889
November 25, 2013 04:24PM
Re: Great performance difference importing a dump
818
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.