Re: Help with large database import - Matthew Montgomery - com.mysql.lists.cluster

9 messages in com.mysql.lists.clusterRe: Help with large database import

From	Sent On	Attachments
Anders D. Hansen	01 Mar 2007 07:35
Anders D.Hansen	01 Mar 2007 12:50
Anders D. Hansen	01 Mar 2007 13:38
Pradeep Chandru	15 Oct 2007 00:56
Matthew Montgomery	15 Oct 2007 11:24
Pradeep Chandru	16 Oct 2007 22:56
Matthew Montgomery	19 Oct 2007 10:36
Matthew Montgomery	20 Oct 2007 13:40
Matthew Montgomery	22 Oct 2007 22:34

Subject:	Re: Help with large database import
From:	Matthew Montgomery (mmon...@mysql.com)
Date:	10/20/2007 01:40:12 PM
List:	com.mysql.lists.cluster

On Sat, 2007-10-20 at 01:44 +0530, chandru wrote:

Mathew,

how is this estimate of 6-8 GB calculated for checkpoints compared to the DBsize.?

A local check point is a complete copy of datamemory to disk. In your case Roughly 2GB. The REDO logs must be sufficiently large to handle 3 local checkpoints to disk before rotation occurs. Tables stored in the NDB engine will typically require more space than their MyISAM counterparts. So I counted in an additional 2GB of checkpoint space to deal with this difference.