Re: Help with large database import

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.

-- 
Matthew Montgomery, Support Engineer
San Antonio, TX
MySQL Inc, www.mysql.com


-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com