MySQL Forums
Forum List  »  NDB clusters

Re: problen in mysql manual
Posted by: Mikael Ronström
Date: July 08, 2005 02:04PM

Hi,


power wang wrote:
> I nedd help.
> When i read the mysql reference manual,i have
> trouble to know what does this means.
> In chapter 16.4.4.5,it said:
> 1. MaxNoOfTables
> A table object is allocated for each table,
> unique hash index, and ordered index. This
> parameter sets the maximum number of table objects
> for the cluster as a whole.
>
> The default value of this parameter is 128. The
> minimum is 8 and the maximum is 1600. Each table
> object consumes approximately 20KB per node.
>
> I want to know 20KB per node means what?Is it says
> that each node will spend 20kb memory to contain
> this content object?

Each ndbd node will preallocate 20 kB for each of those table objects.
Thus setting it to will add around 18 MB of space to the size of the
ndbd binary after being started.

>
>
> 2.MaxNoOfAttributes
> Defines the number of attributes that can be
> defined in the cluster.
>
> I am confused that attributes means what?All
> columns?


This means the maximum number of columns that can be stored in all tables
in the cluster. So if you have 1000 tables with each 25 attributes you need to
set this parameter to at least 25.000

Rgrds Mikael

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2476
July 07, 2005 09:55PM
Re: problen in mysql manual
1651
July 08, 2005 02:04PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.