MySQL Forums
Forum List  »  Performance

Re: Writing at 847 MB/sec ???
Posted by: Rick James
Date: April 15, 2015 11:03PM

I, too, would expect a non-trivial improvement in performance in the 'restore'.

Well, let's start by checking on some issues that might be interfering with the performance.
Was it restoring from a mysqldump?
Was the dump file on the same drive?
How many tables? How big are the tables? How many indexes? (They probably need rebuilding, and we need to see how that was done.)
What version of MySQL? (Some performance improvements have been made.)
What operating system? What file system? (These may or may not be relevant.)

As I understand it, the RAID-10 (4x1TB) in the link would be only 2x faster than a single drive. (That, of course, only adds to the performance puzzle.)

Options: ReplyQuote


Subject
Views
Written By
Posted
1407
April 11, 2015 05:50AM
Re: Writing at 847 MB/sec ???
798
April 15, 2015 11:03PM
781
April 17, 2015 08:45AM
704
April 19, 2015 01:38PM
762
April 20, 2015 01:00AM


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.