xref: /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/ndb/r/ndb_fragment_count_addnode.result

create table t1 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t1' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
create table t2 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t2' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
create table t3 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t3' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
2	0	1
2	2	2
2	4	3
2	6	4
3	1	1
3	3	2
3	5	3
3	7	4
4	1	1
4	3	2
4	5	3
4	7	4
create table t4 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t4' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
2	0	1
2	2	2
3	1	1
3	3	2
4	1	1
4	3	2
create table t5 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t5' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	3
2	0	3
3	1	3
4	1	3
create table t6 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM_X_2";
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t6' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
create table t7 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM_X_3";
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t7' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
1	16	1
1	18	2
1	20	3
1	22	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
2	16	1
2	18	2
2	20	3
2	22	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
3	17	1
3	19	2
3	21	3
3	23	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
4	17	1
4	19	2
4	21	3
4	23	4
create table t8 (id int NOT NULL PRIMARY KEY, data char(8)) engine=ndb
comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM_X_4";
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t8' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
1	16	1
1	18	2
1	20	3
1	22	4
1	24	1
1	26	2
1	28	3
1	30	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
2	16	1
2	18	2
2	20	3
2	22	4
2	24	1
2	26	2
2	28	3
2	30	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
3	17	1
3	19	2
3	21	3
3	23	4
3	25	1
3	27	2
3	29	3
3	31	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
4	17	1
4	19	2
4	21	3
4	23	4
4	25	1
4	27	2
4	29	3
4	31	4
select count(*) into @cnt_t1_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't1';
select count(*) into @cnt_t2_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't2';
select count(*) into @cnt_t3_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't3';
select count(*) into @cnt_t4_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't4';
select count(*) into @cnt_t5_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't5';
select count(*) into @cnt_t6_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't6';
select count(*) into @cnt_t7_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't7';
select count(*) into @cnt_t8_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't8';
select @cnt_t1_0 = @cnt_t2_0;
@cnt_t1_0 = @cnt_t2_0
1
select @cnt_t2_0 > @cnt_t3_0;
@cnt_t2_0 > @cnt_t3_0
1
select @cnt_t3_0 > @cnt_t4_0;
@cnt_t3_0 > @cnt_t4_0
1
select @cnt_t4_0 > @cnt_t5_0;
@cnt_t4_0 > @cnt_t5_0
1
select @cnt_t6_0 = 2 * @cnt_t3_0;
@cnt_t6_0 = 2 * @cnt_t3_0
1
select @cnt_t7_0 = 3 * @cnt_t3_0;
@cnt_t7_0 = 3 * @cnt_t3_0
1
select @cnt_t8_0 = 4 * @cnt_t3_0;
@cnt_t8_0 = 4 * @cnt_t3_0
1
Creating nodegroup
alter table t1 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t1' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
5	16	1
5	17	2
5	18	3
5	19	4
5	20	1
5	21	2
5	22	3
5	23	4
6	16	1
6	17	2
6	18	3
6	19	4
6	20	1
6	21	2
6	22	3
6	23	4
alter table t2 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t2' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
5	16	1
5	17	2
5	18	3
5	19	4
5	20	1
5	21	2
5	22	3
5	23	4
6	16	1
6	17	2
6	18	3
6	19	4
6	20	1
6	21	2
6	22	3
6	23	4
alter table t3 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t3' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
2	0	1
2	2	2
2	4	3
2	6	4
3	1	1
3	3	2
3	5	3
3	7	4
4	1	1
4	3	2
4	5	3
4	7	4
5	8	1
5	9	2
5	10	3
5	11	4
6	8	1
6	9	2
6	10	3
6	11	4
alter table t4 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t4' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
2	0	1
2	2	2
3	1	1
3	3	2
4	1	1
4	3	2
5	4	1
5	5	2
6	4	1
6	5	2
alter table t5 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t5' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	3
2	0	3
3	1	3
4	1	3
5	2	3
6	2	3
alter table t6 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t6' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
5	16	1
5	17	2
5	18	3
5	19	4
5	20	1
5	21	2
5	22	3
5	23	4
6	16	1
6	17	2
6	18	3
6	19	4
6	20	1
6	21	2
6	22	3
6	23	4
alter table t7 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t7' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
1	16	1
1	18	2
1	20	3
1	22	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
2	16	1
2	18	2
2	20	3
2	22	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
3	17	1
3	19	2
3	21	3
3	23	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
4	17	1
4	19	2
4	21	3
4	23	4
5	24	1
5	25	2
5	26	3
5	27	4
5	28	1
5	29	2
5	30	3
5	31	4
5	32	1
5	33	2
5	34	3
5	35	4
6	24	1
6	25	2
6	26	3
6	27	4
6	28	1
6	29	2
6	30	3
6	31	4
6	32	1
6	33	2
6	34	3
6	35	4
alter table t8 algorithm=inplace, reorganize partition;
select node_id, fragment_num, block_instance from ndbinfo.memory_per_fragment
where fq_name = 'test/def/t8' order by node_id, fragment_num, block_instance;
node_id	fragment_num	block_instance
1	0	1
1	2	2
1	4	3
1	6	4
1	8	1
1	10	2
1	12	3
1	14	4
1	16	1
1	18	2
1	20	3
1	22	4
1	24	1
1	26	2
1	28	3
1	30	4
2	0	1
2	2	2
2	4	3
2	6	4
2	8	1
2	10	2
2	12	3
2	14	4
2	16	1
2	18	2
2	20	3
2	22	4
2	24	1
2	26	2
2	28	3
2	30	4
3	1	1
3	3	2
3	5	3
3	7	4
3	9	1
3	11	2
3	13	3
3	15	4
3	17	1
3	19	2
3	21	3
3	23	4
3	25	1
3	27	2
3	29	3
3	31	4
4	1	1
4	3	2
4	5	3
4	7	4
4	9	1
4	11	2
4	13	3
4	15	4
4	17	1
4	19	2
4	21	3
4	23	4
4	25	1
4	27	2
4	29	3
4	31	4
5	32	1
5	33	2
5	34	3
5	35	4
5	36	1
5	37	2
5	38	3
5	39	4
5	40	1
5	41	2
5	42	3
5	43	4
5	44	1
5	45	2
5	46	3
5	47	4
6	32	1
6	33	2
6	34	3
6	35	4
6	36	1
6	37	2
6	38	3
6	39	4
6	40	1
6	41	2
6	42	3
6	43	4
6	44	1
6	45	2
6	46	3
6	47	4
select count(*) into @cnt_t1_1
from information_schema.partitions
where table_schema = 'test' and table_name = 't1';
select count(*) into @cnt_t2_1
from information_schema.partitions
where table_schema = 'test' and table_name = 't2';
select count(*) into @cnt_t3_1
from information_schema.partitions
where table_schema = 'test' and table_name = 't3';
select count(*) into @cnt_t4_1
from information_schema.partitions
where table_schema = 'test' and table_name = 't4';
select count(*) into @cnt_t5_1
from information_schema.partitions
where table_schema = 'test' and table_name = 't5';
select count(*) into @cnt_t6_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't6';
select count(*) into @cnt_t7_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't7';
select count(*) into @cnt_t8_0
from information_schema.partitions
where table_schema = 'test' and table_name = 't8';
select @cnt_t1_1 = @cnt_t2_1;
@cnt_t1_1 = @cnt_t2_1
1
select @cnt_t2_1 > @cnt_t3_1;
@cnt_t2_1 > @cnt_t3_1
1
select @cnt_t3_1 > @cnt_t4_1;
@cnt_t3_1 > @cnt_t4_1
1
select @cnt_t4_1 > @cnt_t5_1;
@cnt_t4_1 > @cnt_t5_1
1
select @cnt_t6_1 = 2 * @cnt_t3_1;
@cnt_t6_1 = 2 * @cnt_t3_1
NULL
select @cnt_t7_1 = 3 * @cnt_t3_1;
@cnt_t7_1 = 3 * @cnt_t3_1
NULL
select @cnt_t8_1 = 4 * @cnt_t3_1;
@cnt_t8_1 = 4 * @cnt_t3_1
NULL
select @cnt_t1_1 > @cnt_t1_0;
@cnt_t1_1 > @cnt_t1_0
1
select @cnt_t2_1 > @cnt_t2_0;
@cnt_t2_1 > @cnt_t2_0
1
select @cnt_t3_1 > @cnt_t3_0;
@cnt_t3_1 > @cnt_t3_0
1
select @cnt_t4_1 > @cnt_t4_0;
@cnt_t4_1 > @cnt_t4_0
1
select @cnt_t5_1 > @cnt_t5_0;
@cnt_t5_1 > @cnt_t5_0
1
select @cnt_t6_1 > @cnt_t6_0;
@cnt_t6_1 > @cnt_t6_0
NULL
select @cnt_t7_1 > @cnt_t7_0;
@cnt_t7_1 > @cnt_t7_0
NULL
select @cnt_t8_1 > @cnt_t8_0;
@cnt_t8_1 > @cnt_t8_0
NULL
-- t1 --
Version: Any
Fragment type: HashMapPartition
K Value: 6
Min load factor: 78
Max load factor: 80
Temporary table: no
Number of attributes: 2
Number of primary keys: 1
Length of frm data: XXX
Max Rows: 0
Row Checksum: 1
Row GCI: 1
SingleUserMode: 0
ForceVarPart: 1
PartitionCount: 24
FragmentCount: 24
PartitionBalance: FOR_RP_BY_LDM
ExtraRowGciBits: 0
ExtraRowAuthorBits: 0
TableStatus: Retrieved
Table options:
HashMap: HASHMAP-3840-16-24
-- Attributes --
id Int PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
data Char(32;utf8mb4_0900_ai_ci) NULL AT=FIXED ST=MEMORY
-- Indexes --
PRIMARY KEY(id) - UniqueHashIndex
PRIMARY(id) - OrderedIndex
-- Per partition info --
Partition	Row count	Commit count	Frag fixed memory	Frag varsized memory	Extent_space	Free extent_space
0 ...
1 ...
2 ...
3 ...
4 ...
5 ...
6 ...
7 ...
8 ...
9 ...
10 ...
11 ...
12 ...
13 ...
14 ...
15 ...
16 ...
17 ...
18 ...
19 ...
20 ...
21 ...
22 ...
23 ...


NDBT_ProgramExit: 0 - OK

drop table t1,t2,t3,t4,t5,t6,t7,t8;