Debian Codegraph @

mysql-test/suite/ndb/r/ndb_no_rb_fragment_count_desc.result

raw
1 create table t1 (a bigint, primary key (a)) engine=ndb;
2 create table t2 (a bigint, primary key (a)) engine=ndb
3 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_LDM";
4 create table t3 (a bigint, primary key (a)) engine=ndb
5 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_LDM";
6 create table t4 (a bigint, primary key (a)) engine=ndb
7 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RP_BY_NODE";
8 create table t5 (a bigint, primary key (a)) engine=ndb
9 comment="NDB_TABLE=PARTITION_BALANCE=FOR_RA_BY_NODE";
10 -- t1 --
11 Version: Any
12 Fragment type: HashMapPartition
13 K Value: 6
14 Min load factor: 78
15 Max load factor: 80
16 Temporary table: no
17 Number of attributes: 1
18 Number of primary keys: 1
19 Length of frm data: XXX
20 Max Rows: 0
21 Row Checksum: 1
22 Row GCI: 1
23 SingleUserMode: 0
24 ForceVarPart: 1
25 PartitionCount: 8
26 FragmentCount: 8
27 PartitionBalance: FOR_RP_BY_LDM
28 ExtraRowGciBits: 0
29 ExtraRowAuthorBits: 0
30 TableStatus: Retrieved
31 Table options:
32 HashMap: DEFAULT-HASHMAP-3840-8
33 -- Attributes --
34 a Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
35 -- Indexes --
36 PRIMARY KEY(a) - UniqueHashIndex
37 PRIMARY(a) - OrderedIndex
38 -- t2 --
39 Version: Any
40 Fragment type: HashMapPartition
41 K Value: 6
42 Min load factor: 78
43 Max load factor: 80
44 Temporary table: no
45 Number of attributes: 1
46 Number of primary keys: 1
47 Length of frm data: XXX
48 Max Rows: 0
49 Row Checksum: 1
50 Row GCI: 1
51 SingleUserMode: 0
52 ForceVarPart: 1
53 PartitionCount: 8
54 FragmentCount: 8
55 PartitionBalance: FOR_RP_BY_LDM
56 ExtraRowGciBits: 0
57 ExtraRowAuthorBits: 0
58 TableStatus: Retrieved
59 Table options:
60 HashMap: DEFAULT-HASHMAP-3840-8
61 -- Attributes --
62 a Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
63 -- Indexes --
64 PRIMARY KEY(a) - UniqueHashIndex
65 PRIMARY(a) - OrderedIndex
66 -- t3 --
67 Version: Any
68 Fragment type: HashMapPartition
69 K Value: 6
70 Min load factor: 78
71 Max load factor: 80
72 Temporary table: no
73 Number of attributes: 1
74 Number of primary keys: 1
75 Length of frm data: XXX
76 Max Rows: 0
77 Row Checksum: 1
78 Row GCI: 1
79 SingleUserMode: 0
80 ForceVarPart: 1
81 PartitionCount: 4
82 FragmentCount: 4
83 PartitionBalance: FOR_RA_BY_LDM
84 ExtraRowGciBits: 0
85 ExtraRowAuthorBits: 0
86 TableStatus: Retrieved
87 Table options:
88 HashMap: DEFAULT-HASHMAP-3840-4
89 -- Attributes --
90 a Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
91 -- Indexes --
92 PRIMARY KEY(a) - UniqueHashIndex
93 PRIMARY(a) - OrderedIndex
94 -- t4 --
95 Version: Any
96 Fragment type: HashMapPartition
97 K Value: 6
98 Min load factor: 78
99 Max load factor: 80
100 Temporary table: no
101 Number of attributes: 1
102 Number of primary keys: 1
103 Length of frm data: XXX
104 Max Rows: 0
105 Row Checksum: 1
106 Row GCI: 1
107 SingleUserMode: 0
108 ForceVarPart: 1
109 PartitionCount: 2
110 FragmentCount: 2
111 PartitionBalance: FOR_RP_BY_NODE
112 ExtraRowGciBits: 0
113 ExtraRowAuthorBits: 0
114 TableStatus: Retrieved
115 Table options:
116 HashMap: DEFAULT-HASHMAP-3840-2
117 -- Attributes --
118 a Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
119 -- Indexes --
120 PRIMARY KEY(a) - UniqueHashIndex
121 PRIMARY(a) - OrderedIndex
122 -- t5 --
123 Version: Any
124 Fragment type: HashMapPartition
125 K Value: 6
126 Min load factor: 78
127 Max load factor: 80
128 Temporary table: no
129 Number of attributes: 1
130 Number of primary keys: 1
131 Length of frm data: XXX
132 Max Rows: 0
133 Row Checksum: 1
134 Row GCI: 1
135 SingleUserMode: 0
136 ForceVarPart: 1
137 PartitionCount: 1
138 FragmentCount: 1
139 PartitionBalance: FOR_RA_BY_NODE
140 ExtraRowGciBits: 0
141 ExtraRowAuthorBits: 0
142 TableStatus: Retrieved
143 Table options:
144 HashMap: DEFAULT-HASHMAP-3840-1
145 -- Attributes --
146 a Bigint PRIMARY KEY DISTRIBUTION KEY AT=FIXED ST=MEMORY
147 -- Indexes --
148 PRIMARY KEY(a) - UniqueHashIndex
149 PRIMARY(a) - OrderedIndex
150 drop table t1, t2, t3, t4, t5;