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