List:Cluster« Previous MessageNext Message »
From:Sean Lee Date:August 18 2010 1:35pm
Subject:why my cluster's number of partitions is not equal to the number of
ndb nodes?
View as plain text  
Hi all,

When I check the ndb_desc output, I find the FragmentCount: is 4 but
my cluster only have 2 ndb nodes? How can this happens? Is it a bug?
Or this will effect on cluster performance?

for example the ndb_desc output is:


ndb_desc -c localhost request_histories -d report_production -p -n
-- request_histories --
Version: 16777218
Fragment type: 9
K Value: 6
Min load factor: 78
Max load factor: 80
Temporary table: no
Number of attributes: 35
Number of primary keys: 1
Length of frm data: 850
Row Checksum: 1
Row GCI: 1
SingleUserMode: 0
ForceVarPart: 1
FragmentCount: 4
TableStatus: Retrieved
-- Attributes --
id Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY AUTO_INCR
m Varchar(60;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
uuid Int NULL AT=FIXED ST=MEMORY
sc Varchar(45;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
vs Varchar(45;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
vd Varchar(45;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
e Varchar(45;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
d Varchar(45;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
sph Varchar(45;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
si Varchar(60;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
vl Varchar(45;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
v Smallint NULL AT=FIXED ST=DISK
suc Smallint NULL AT=FIXED ST=DISK
pk Varchar(60;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
spc Smallint NULL AT=FIXED ST=DISK
ms Varchar(60;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
ec Varchar(30;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
at Varchar(12;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
ons Smallint NULL AT=FIXED ST=DISK
sg Smallint NULL AT=FIXED ST=DISK
sv Tinyint NULL AT=FIXED ST=DISK
plan_sp_group Smallint NULL AT=FIXED ST=DISK
plan_sp_version Tinyint NULL AT=FIXED ST=DISK
charge_point_code Tinyint NULL AT=FIXED ST=DISK
charge_mode Tinyint NULL AT=FIXED ST=DISK
plan_amount Smallint NULL AT=FIXED ST=DISK
request_time Datetime NULL AT=FIXED ST=MEMORY
param_uuid Int NULL AT=FIXED ST=DISK
unknow_params Varchar(96;utf8_unicode_ci) NULL AT=SHORT_VAR ST=DISK
c86c Smallint NULL AT=FIXED ST=DISK
tsc Smallint NULL AT=FIXED ST=DISK
mnc Tinyint NULL AT=FIXED ST=DISK
mcc Smallint NULL AT=FIXED ST=DISK
lac Int NULL AT=FIXED ST=DISK
ci Int NULL AT=FIXED ST=DISK

-- Indexes --
PRIMARY KEY(id) - UniqueHashIndex
PRIMARY(id) - OrderedIndex
index_request_histories_on_uuid(uuid) - OrderedIndex
index_request_histories_on_request_time(request_time) - OrderedIndex

-- Per partition info --
Partition	Row count	Commit count	Frag fixed memory	Frag varsized
memory	Extent_space	Free extent_space	Nodes
1        	1638658  	1638658     	85655552         	0
 	1377828864  	1005192          	3,2
3        	1636267  	1636267     	85524480         	0
 	1375731712  	918252           	3,2
0         	1635867  	1635867     	85524480         	0
  	1374683136  	216108           	2,3
2        	1640334  	1640334     	85753856         	0
 	1378877440  	650808           	2,3


and my ndb_mgm -e show output is :

Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)]	2 node(s)
id=2	@192.168.12.111  (mysql-5.1.44 ndb-7.1.4, Nodegroup: 0, Master)
id=3	@192.168.12.112  (mysql-5.1.44 ndb-7.1.4, Nodegroup: 0)

[ndb_mgmd(MGM)]	1 node(s)
id=1	@192.168.12.110  (mysql-5.1.44 ndb-7.1.4)

[mysqld(API)]	4 node(s)
id=6	@192.168.12.111  (mysql-5.1.44 ndb-7.1.4)
id=7	@192.168.12.112  (mysql-5.1.44 ndb-7.1.4)
id=8 (not connected, accepting connect from 192.168.12.110)
id=9 (not connected, accepting connect from 192.168.12.110)

Anyone can give me a explaining?  Any suggestions appreciated !

Thanks in advance for your help.

BR

Sean Lee
Thread
why my cluster's number of partitions is not equal to the number ofndb nodes?Sean Lee18 Aug
  • Re: why my cluster's number of partitions is not equal to the numberof ndb nodes?Andrew Hutchings18 Aug
    • Re: why my cluster's number of partitions is not equal to the numberof ndb nodes?Sean Lee19 Aug