MySQL Forums
Forum List  »  Newbie

mysql import database from dump takes a lot of time
Posted by: Tomasz Pajor
Date: April 23, 2010 06:31AM

Hello,

Should pushing 3gb dump take 75 minutes?
Can I push to the db faster without hardware upgrade?
How can I profile what is the bottleneck?


mysql version is 5.1.45
FreeBSD 9.0-CURRENT #4: Wed Apr 14 21:09:31 CEST 2010 i386

CPU: Intel(R) Core(TM)2 Duo CPU E7300 @ 2.66GHz (2666.69-MHz 686-class CPU)
real memory = 2147483648 (2048 MB)
avail memory = 1946615808 (1856 MB)
ad4: 238475MB <SAMSUNG HD252HJ 1AC01113> at ata2-master UDMA100 SATA 3Gb/s

Options: ReplyQuote


Subject
Written By
Posted
mysql import database from dump takes a lot of time
April 23, 2010 06:31AM


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.