Re: cluster takes enormous room to store data

On Fri, 2007-07-06 at 17:52 +0200, Gaël Marmillod wrote:
> I was hoping this would allow to import a DB of around 1.3Gigs of Data from
> a "classic" mysql server and am very surprised by the results.

use ndb_size.pl (grab the version from the latest 5.1... it still gives you 5.0 results too... and likely more accurate ones) for an idea of what is using up space.

> I have an other strange observation: Although I have nearly the whole 4Gigs
> of RAM free for it on my servers, ndbd won't start with more than 2500M of
> DataMemory, claiming to be unable to allocate the memory, with this error:
>
> Node 2: Forced node shutdown completed. Occured during startphase 0. Caused
> by error 2327: 'Memory allocation failure, please decrease some
> configuration parameters(Configuration error). Permanent error, external
> action needed'. - Unknown error code: Unknown result: Unknown error code

This will be because of running 32bit somewhere. Run 64bit binaries on 64 bit OS (of course, on 64bit hardware).

Or you can get around this and run more than one data node per machine... but there can be a performance penalty.

-- 
Stewart Smith, Senior Software Engineer
MySQL AB, www.mysql.com
Office: +14082136540 Ext: 6616
VoIP: 6616@sip.us.mysql.com
Mobile: +61 4 3 8844 332

Jumpstart your cluster:
http://www.mysql.com/consulting/packaged/cluster.html


application/pgp-signature attachment: This is a digitally signed message part