RE: time taken by mysqldump

2007-05-24 Thread Tim Lucia
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, >

Re: time taken by mysqldump

2007-05-24 Thread Ananda Kumar
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

Re: time taken by mysqldump

2007-05-24 Thread B. Keith Murphy
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

time taken by mysqldump

2007-05-24 Thread Ananda Kumar
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