I can give you a rough estimate: My /data partition is 67G. The gzipped output of mysqldump is 20G. It takes about 53 minutes. Extrapolating to 100G would give (50% more) about 78 minutes.
On a Dell 2950 running Xeon 5160/3GHz (4 cores), 8Gb memory, RAID 10 15K rpm drives (Perc 5/I SAS I believe.) BTW, we run the dump off the slave only. HTH, Tim > -----Original Message----- > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 24, 2007 3:49 AM > To: B. Keith Murphy > Cc: MySQL General > Subject: Re: time taken by mysqldump > > Hi Keith, > I will be doing this from my slave database. > Any rough estimate of time for 100gb mysqldump. > > regards > anandkl > > > On 5/24/07, B. Keith Murphy <[EMAIL PROTECTED]> wrote: > > > > Have you considered replicating to a backup server and then dumping from > > it? > > > > No matter your processors with a 100gb db it is going to take a > > significant amount of time. > > > > Keith > > > > > > Ananda Kumar wrote: > > > Hi All, > > > We have database of around 100GB, and planning to take dump using > > > mysqldump. > > > Can you please let how much time it would take for 100GB. > > > > > > We have 8GB RAM and 4 intel latest processor. The mysql db is running > on > > > linux. > > > > > > regards > > > anandkl > > > > > > ---------------------------------------------------------------------- > -- > > > > > > No virus found in this incoming message. > > > Checked by AVG Free Edition. > > > Version: 7.5.467 / Virus Database: 269.7.7/816 - Release Date: > 5/23/2007 > > 3:59 PM > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
