| blob | b2c0ddcb6d057abf9e74f49d623013ae408419ab |
1 Case 1: With -d option before table creation:
2 ============================================
3 <Database Usage Statistics>
4 <DatabaseStatistics>
5 <Database Name> SYSTEMDB </Database Name>
6 <Max Size> 1048576 </Max Size>
7 <First Page> 17d7c000 </First Page>
8 <Total Pages> 112 </Total Pages>
9 <Used Normal Pages> 13 </Used Normal Pages>
10 <Used Merged Pages> 2 </Used Merged Pages>
11 <Chunks Used> 15 </Chunks Used>
12 </DatabaseStatistics>
13 <ProcTable>
14 <UsedSlots> 1 </UsedSlots>
15 <FreeSlots> 99 </FreeSlots>
16 </ProcTable>
17 <TransactionTable>
18 <UsedSlots> 0 </UsedSlots>
19 <FreeSlots> 100 </FreeSlots>
20 <UndoLogs>
21 <TotalNodes> 0 </TotalNodes>
22 </UndoLogs>
23 </TransactionTable>
24 <LockTable>
25 <TotalBuckets> 2048 </TotalBuckets>
26 <UsedBuckets> 0 </UsedBuckets>
27 <TotalLockNodes> 0 </TotalLockNodes>
28 </LockTable>
29 <DatabaseStatistics>
30 <Database Name> userdb </Database Name>
31 <Max Size> 10485760 </Max Size>
32 <First Page> 17e7a000 </First Page>
33 <Total Pages> 1279 </Total Pages>
34 <Used Normal Pages> 0 </Used Normal Pages>
35 <Used Merged Pages> 0 </Used Merged Pages>
36 <Chunks Used> 0 </Chunks Used>
37 </DatabaseStatistics>
38 </Database Usage Statistics>
39 Case 2: With -D chunk option after table creation:
40 ============================================
41 <Chunk information>
42 <System Chunk >
43 <Chunk Id> 0 </Chunk Id>
44 <TotalPages> 1 </TotalPages>
45 <ChunkName > UserChunkTableId </ChunkName>
46 <TotalDataNodes> 4 </TotalDataNodes>
47 <SizeOfDataNodes> 136 </SizeOfDataNodes>
48 <Allocation Type> FixedSizeAllocator </Allocation Type>
49 <Chunk Id> 1 </Chunk Id>
50 <TotalPages> 1 </TotalPages>
51 <ChunkName > LockTableHashBucketId </ChunkName>
52 <TotalDataNodes> 1 </TotalDataNodes>
53 <SizeOfDataNodes> 65544 </SizeOfDataNodes>
54 <Allocation Type> FixedSizeAllocator </Allocation Type>
55 <Chunk Id> 2 </Chunk Id>
56 <TotalPages> 1 </TotalPages>
57 <ChunkName > LockTableMutexId </ChunkName>
58 <TotalDataNodes> 0 </TotalDataNodes>
59 <SizeOfDataNodes> 49160 </SizeOfDataNodes>
60 <Allocation Type> FixedSizeAllocator </Allocation Type>
61 <Chunk Id> 3 </Chunk Id>
62 <TotalPages> 1 </TotalPages>
63 <ChunkName > LockTableId </ChunkName>
64 <TotalDataNodes> 0 </TotalDataNodes>
65 <SizeOfDataNodes> 40 </SizeOfDataNodes>
66 <Allocation Type> FixedSizeAllocator </Allocation Type>
67 <Chunk Id> 4 </Chunk Id>
68 <TotalPages> 1 </TotalPages>
69 <ChunkName > TransHasTableId </ChunkName>
70 <TotalDataNodes> 0 </TotalDataNodes>
71 <SizeOfDataNodes> 24 </SizeOfDataNodes>
72 <Allocation Type> FixedSizeAllocator </Allocation Type>
73 <Chunk Id> 5 </Chunk Id>
74 <TotalPages> 1 </TotalPages>
75 <ChunkName > UndoLogTableId </ChunkName>
76 <TotalDataNodes> 0 </TotalDataNodes>
77 <SizeOfDataNodes> 0 </SizeOfDataNodes>
78 <Allocation Type> VariableSizeAllocator </Allocation Type>
79 <Chunk Id> 10 </Chunk Id>
80 <TotalPages> 1 </TotalPages>
81 <ChunkName > DatabaseTableId </ChunkName>
82 <TotalDataNodes> 0 </TotalDataNodes>
83 <SizeOfDataNodes> 96 </SizeOfDataNodes>
84 <Allocation Type> FixedSizeAllocator </Allocation Type>
85 <Chunk Id> 11 </Chunk Id>
86 <TotalPages> 1 </TotalPages>
87 <ChunkName > UserTableId </ChunkName>
88 <TotalDataNodes> 2 </TotalDataNodes>
89 <SizeOfDataNodes> 136 </SizeOfDataNodes>
90 <Allocation Type> FixedSizeAllocator </Allocation Type>
91 <Chunk Id> 12 </Chunk Id>
92 <TotalPages> 1 </TotalPages>
93 <ChunkName > TableTableId </ChunkName>
94 <TotalDataNodes> 1 </TotalDataNodes>
95 <SizeOfDataNodes> 112 </SizeOfDataNodes>
96 <Allocation Type> FixedSizeAllocator </Allocation Type>
97 <Chunk Id> 13 </Chunk Id>
98 <TotalPages> 1 </TotalPages>
99 <ChunkName > FieldTableId </ChunkName>
100 <TotalDataNodes> 3 </TotalDataNodes>
101 <SizeOfDataNodes> 168 </SizeOfDataNodes>
102 <Allocation Type> FixedSizeAllocator </Allocation Type>
103 <Chunk Id> 14 </Chunk Id>
104 <TotalPages> 1 </TotalPages>
105 <ChunkName > AccessTableId </ChunkName>
106 <TotalDataNodes> 0 </TotalDataNodes>
107 <SizeOfDataNodes> 136 </SizeOfDataNodes>
108 <Allocation Type> FixedSizeAllocator </Allocation Type>
109 <Chunk Id> 15 </Chunk Id>
110 <TotalPages> 1 </TotalPages>
111 <ChunkName > IndexTableId </ChunkName>
112 <TotalDataNodes> 2 </TotalDataNodes>
113 <SizeOfDataNodes> 136 </SizeOfDataNodes>
114 <Allocation Type> FixedSizeAllocator </Allocation Type>
115 <Chunk Id> 16 </Chunk Id>
116 <TotalPages> 1 </TotalPages>
117 <ChunkName > IndexFieldTableId </ChunkName>
118 <TotalDataNodes> 2 </TotalDataNodes>
119 <SizeOfDataNodes> 40 </SizeOfDataNodes>
120 <Allocation Type> FixedSizeAllocator </Allocation Type>
121 <Chunk Id> 17 </Chunk Id>
122 <TotalPages> 1 </TotalPages>
123 <ChunkName > ForeignKeyTableId </ChunkName>
124 <TotalDataNodes> 0 </TotalDataNodes>
125 <SizeOfDataNodes> 88 </SizeOfDataNodes>
126 <Allocation Type> FixedSizeAllocator </Allocation Type>
127 <Chunk Id> 18 </Chunk Id>
128 <TotalPages> 1 </TotalPages>
129 <ChunkName > ForeignKeyFieldTableId </ChunkName>
130 <TotalDataNodes> 0 </TotalDataNodes>
131 <SizeOfDataNodes> 32 </SizeOfDataNodes>
132 <Allocation Type> FixedSizeAllocator </Allocation Type>
133 </System Chunk >
134 <User Chunk >
135 <Chunk Id> 101 </Chunk Id>
136 <TotalPages> 1248 </TotalPages>
137 <ChunkName > t1 </ChunkName>
138 <TotalDataNodes> 4992 </TotalDataNodes>
139 <SizeOfDataNodes> 2024 </SizeOfDataNodes>
140 <Allocation Type> FixedSizeAllocator </Allocation Type>
141 <Chunk Id> 102 </Chunk Id>
142 <TotalPages> 1 </TotalPages>
143 <ChunkName > t1_idx1_Primary </ChunkName>
144 <TotalDataNodes> 1 </TotalDataNodes>
145 <SizeOfDataNodes> 32296 </SizeOfDataNodes>
146 <Allocation Type> FixedSizeAllocator </Allocation Type>
147 <Chunk Id> 103 </Chunk Id>
148 <TotalPages> 20 </TotalPages>
149 <ChunkName > t1_idx1_Primary </ChunkName>
150 <TotalDataNodes> 4992 </TotalDataNodes>
151 <SizeOfDataNodes> 32 </SizeOfDataNodes>
152 <Allocation Type> FixedSizeAllocator </Allocation Type>
153 <Chunk Id> 104 </Chunk Id>
154 <TotalPages> 6 </TotalPages>
155 <ChunkName > </ChunkName>
156 <TotalDataNodes> 6 </TotalDataNodes>
157 <SizeOfDataNodes> 8152 </SizeOfDataNodes>
158 <Allocation Type> FixedSizeAllocator </Allocation Type>
159 </User Chunk >
160 </Chunk information>
161 Statement Executed: Rows Affected = 3999
162 Case 3: With -D chunk option after record deleted:
163 ===================================================
164 <Chunk information>
165 <System Chunk >
166 <Chunk Id> 0 </Chunk Id>
167 <TotalPages> 1 </TotalPages>
168 <ChunkName > UserChunkTableId </ChunkName>
169 <TotalDataNodes> 4 </TotalDataNodes>
170 <SizeOfDataNodes> 136 </SizeOfDataNodes>
171 <Allocation Type> FixedSizeAllocator </Allocation Type>
172 <Chunk Id> 1 </Chunk Id>
173 <TotalPages> 1 </TotalPages>
174 <ChunkName > LockTableHashBucketId </ChunkName>
175 <TotalDataNodes> 1 </TotalDataNodes>
176 <SizeOfDataNodes> 65544 </SizeOfDataNodes>
177 <Allocation Type> FixedSizeAllocator </Allocation Type>
178 <Chunk Id> 2 </Chunk Id>
179 <TotalPages> 1 </TotalPages>
180 <ChunkName > LockTableMutexId </ChunkName>
181 <TotalDataNodes> 0 </TotalDataNodes>
182 <SizeOfDataNodes> 49160 </SizeOfDataNodes>
183 <Allocation Type> FixedSizeAllocator </Allocation Type>
184 <Chunk Id> 3 </Chunk Id>
185 <TotalPages> 1 </TotalPages>
186 <ChunkName > LockTableId </ChunkName>
187 <TotalDataNodes> 0 </TotalDataNodes>
188 <SizeOfDataNodes> 40 </SizeOfDataNodes>
189 <Allocation Type> FixedSizeAllocator </Allocation Type>
190 <Chunk Id> 4 </Chunk Id>
191 <TotalPages> 1 </TotalPages>
192 <ChunkName > TransHasTableId </ChunkName>
193 <TotalDataNodes> 0 </TotalDataNodes>
194 <SizeOfDataNodes> 24 </SizeOfDataNodes>
195 <Allocation Type> FixedSizeAllocator </Allocation Type>
196 <Chunk Id> 5 </Chunk Id>
197 <TotalPages> 1 </TotalPages>
198 <ChunkName > UndoLogTableId </ChunkName>
199 <TotalDataNodes> 0 </TotalDataNodes>
200 <SizeOfDataNodes> 0 </SizeOfDataNodes>
201 <Allocation Type> VariableSizeAllocator </Allocation Type>
202 <Chunk Id> 10 </Chunk Id>
203 <TotalPages> 1 </TotalPages>
204 <ChunkName > DatabaseTableId </ChunkName>
205 <TotalDataNodes> 0 </TotalDataNodes>
206 <SizeOfDataNodes> 96 </SizeOfDataNodes>
207 <Allocation Type> FixedSizeAllocator </Allocation Type>
208 <Chunk Id> 11 </Chunk Id>
209 <TotalPages> 1 </TotalPages>
210 <ChunkName > UserTableId </ChunkName>
211 <TotalDataNodes> 2 </TotalDataNodes>
212 <SizeOfDataNodes> 136 </SizeOfDataNodes>
213 <Allocation Type> FixedSizeAllocator </Allocation Type>
214 <Chunk Id> 12 </Chunk Id>
215 <TotalPages> 1 </TotalPages>
216 <ChunkName > TableTableId </ChunkName>
217 <TotalDataNodes> 1 </TotalDataNodes>
218 <SizeOfDataNodes> 112 </SizeOfDataNodes>
219 <Allocation Type> FixedSizeAllocator </Allocation Type>
220 <Chunk Id> 13 </Chunk Id>
221 <TotalPages> 1 </TotalPages>
222 <ChunkName > FieldTableId </ChunkName>
223 <TotalDataNodes> 3 </TotalDataNodes>
224 <SizeOfDataNodes> 168 </SizeOfDataNodes>
225 <Allocation Type> FixedSizeAllocator </Allocation Type>
226 <Chunk Id> 14 </Chunk Id>
227 <TotalPages> 1 </TotalPages>
228 <ChunkName > AccessTableId </ChunkName>
229 <TotalDataNodes> 0 </TotalDataNodes>
230 <SizeOfDataNodes> 136 </SizeOfDataNodes>
231 <Allocation Type> FixedSizeAllocator </Allocation Type>
232 <Chunk Id> 15 </Chunk Id>
233 <TotalPages> 1 </TotalPages>
234 <ChunkName > IndexTableId </ChunkName>
235 <TotalDataNodes> 2 </TotalDataNodes>
236 <SizeOfDataNodes> 136 </SizeOfDataNodes>
237 <Allocation Type> FixedSizeAllocator </Allocation Type>
238 <Chunk Id> 16 </Chunk Id>
239 <TotalPages> 1 </TotalPages>
240 <ChunkName > IndexFieldTableId </ChunkName>
241 <TotalDataNodes> 2 </TotalDataNodes>
242 <SizeOfDataNodes> 40 </SizeOfDataNodes>
243 <Allocation Type> FixedSizeAllocator </Allocation Type>
244 <Chunk Id> 17 </Chunk Id>
245 <TotalPages> 1 </TotalPages>
246 <ChunkName > ForeignKeyTableId </ChunkName>
247 <TotalDataNodes> 0 </TotalDataNodes>
248 <SizeOfDataNodes> 88 </SizeOfDataNodes>
249 <Allocation Type> FixedSizeAllocator </Allocation Type>
250 <Chunk Id> 18 </Chunk Id>
251 <TotalPages> 1 </TotalPages>
252 <ChunkName > ForeignKeyFieldTableId </ChunkName>
253 <TotalDataNodes> 0 </TotalDataNodes>
254 <SizeOfDataNodes> 32 </SizeOfDataNodes>
255 <Allocation Type> FixedSizeAllocator </Allocation Type>
256 </System Chunk >
257 <User Chunk >
258 <Chunk Id> 101 </Chunk Id>
259 <TotalPages> 1248 </TotalPages>
260 <ChunkName > t1 </ChunkName>
261 <TotalDataNodes> 993 </TotalDataNodes>
262 <SizeOfDataNodes> 2024 </SizeOfDataNodes>
263 <Allocation Type> FixedSizeAllocator </Allocation Type>
264 <Chunk Id> 102 </Chunk Id>
265 <TotalPages> 1 </TotalPages>
266 <ChunkName > t1_idx1_Primary </ChunkName>
267 <TotalDataNodes> 1 </TotalDataNodes>
268 <SizeOfDataNodes> 32296 </SizeOfDataNodes>
269 <Allocation Type> FixedSizeAllocator </Allocation Type>
270 <Chunk Id> 103 </Chunk Id>
271 <TotalPages> 20 </TotalPages>
272 <ChunkName > t1_idx1_Primary </ChunkName>
273 <TotalDataNodes> 993 </TotalDataNodes>
274 <SizeOfDataNodes> 32 </SizeOfDataNodes>
275 <Allocation Type> FixedSizeAllocator </Allocation Type>
276 <Chunk Id> 104 </Chunk Id>
277 <TotalPages> 6 </TotalPages>
278 <ChunkName > </ChunkName>
279 <TotalDataNodes> 3 </TotalDataNodes>
280 <SizeOfDataNodes> 8152 </SizeOfDataNodes>
281 <Allocation Type> FixedSizeAllocator </Allocation Type>
282 </User Chunk >
283 </Chunk information>
284 Statement Executed: Rows Affected = 0
285 Case 4: With -D chunk option after compact statement :
286 =======================================
287 <Chunk information>
288 <System Chunk >
289 <Chunk Id> 0 </Chunk Id>
290 <TotalPages> 1 </TotalPages>
291 <ChunkName > UserChunkTableId </ChunkName>
292 <TotalDataNodes> 4 </TotalDataNodes>
293 <SizeOfDataNodes> 136 </SizeOfDataNodes>
294 <Allocation Type> FixedSizeAllocator </Allocation Type>
295 <Chunk Id> 1 </Chunk Id>
296 <TotalPages> 1 </TotalPages>
297 <ChunkName > LockTableHashBucketId </ChunkName>
298 <TotalDataNodes> 1 </TotalDataNodes>
299 <SizeOfDataNodes> 65544 </SizeOfDataNodes>
300 <Allocation Type> FixedSizeAllocator </Allocation Type>
301 <Chunk Id> 2 </Chunk Id>
302 <TotalPages> 1 </TotalPages>
303 <ChunkName > LockTableMutexId </ChunkName>
304 <TotalDataNodes> 0 </TotalDataNodes>
305 <SizeOfDataNodes> 49160 </SizeOfDataNodes>
306 <Allocation Type> FixedSizeAllocator </Allocation Type>
307 <Chunk Id> 3 </Chunk Id>
308 <TotalPages> 1 </TotalPages>
309 <ChunkName > LockTableId </ChunkName>
310 <TotalDataNodes> 0 </TotalDataNodes>
311 <SizeOfDataNodes> 40 </SizeOfDataNodes>
312 <Allocation Type> FixedSizeAllocator </Allocation Type>
313 <Chunk Id> 4 </Chunk Id>
314 <TotalPages> 1 </TotalPages>
315 <ChunkName > TransHasTableId </ChunkName>
316 <TotalDataNodes> 0 </TotalDataNodes>
317 <SizeOfDataNodes> 24 </SizeOfDataNodes>
318 <Allocation Type> FixedSizeAllocator </Allocation Type>
319 <Chunk Id> 5 </Chunk Id>
320 <TotalPages> 1 </TotalPages>
321 <ChunkName > UndoLogTableId </ChunkName>
322 <TotalDataNodes> 0 </TotalDataNodes>
323 <SizeOfDataNodes> 0 </SizeOfDataNodes>
324 <Allocation Type> VariableSizeAllocator </Allocation Type>
325 <Chunk Id> 10 </Chunk Id>
326 <TotalPages> 1 </TotalPages>
327 <ChunkName > DatabaseTableId </ChunkName>
328 <TotalDataNodes> 0 </TotalDataNodes>
329 <SizeOfDataNodes> 96 </SizeOfDataNodes>
330 <Allocation Type> FixedSizeAllocator </Allocation Type>
331 <Chunk Id> 11 </Chunk Id>
332 <TotalPages> 1 </TotalPages>
333 <ChunkName > UserTableId </ChunkName>
334 <TotalDataNodes> 2 </TotalDataNodes>
335 <SizeOfDataNodes> 136 </SizeOfDataNodes>
336 <Allocation Type> FixedSizeAllocator </Allocation Type>
337 <Chunk Id> 12 </Chunk Id>
338 <TotalPages> 1 </TotalPages>
339 <ChunkName > TableTableId </ChunkName>
340 <TotalDataNodes> 1 </TotalDataNodes>
341 <SizeOfDataNodes> 112 </SizeOfDataNodes>
342 <Allocation Type> FixedSizeAllocator </Allocation Type>
343 <Chunk Id> 13 </Chunk Id>
344 <TotalPages> 1 </TotalPages>
345 <ChunkName > FieldTableId </ChunkName>
346 <TotalDataNodes> 3 </TotalDataNodes>
347 <SizeOfDataNodes> 168 </SizeOfDataNodes>
348 <Allocation Type> FixedSizeAllocator </Allocation Type>
349 <Chunk Id> 14 </Chunk Id>
350 <TotalPages> 1 </TotalPages>
351 <ChunkName > AccessTableId </ChunkName>
352 <TotalDataNodes> 0 </TotalDataNodes>
353 <SizeOfDataNodes> 136 </SizeOfDataNodes>
354 <Allocation Type> FixedSizeAllocator </Allocation Type>
355 <Chunk Id> 15 </Chunk Id>
356 <TotalPages> 1 </TotalPages>
357 <ChunkName > IndexTableId </ChunkName>
358 <TotalDataNodes> 2 </TotalDataNodes>
359 <SizeOfDataNodes> 136 </SizeOfDataNodes>
360 <Allocation Type> FixedSizeAllocator </Allocation Type>
361 <Chunk Id> 16 </Chunk Id>
362 <TotalPages> 1 </TotalPages>
363 <ChunkName > IndexFieldTableId </ChunkName>
364 <TotalDataNodes> 2 </TotalDataNodes>
365 <SizeOfDataNodes> 40 </SizeOfDataNodes>
366 <Allocation Type> FixedSizeAllocator </Allocation Type>
367 <Chunk Id> 17 </Chunk Id>
368 <TotalPages> 1 </TotalPages>
369 <ChunkName > ForeignKeyTableId </ChunkName>
370 <TotalDataNodes> 0 </TotalDataNodes>
371 <SizeOfDataNodes> 88 </SizeOfDataNodes>
372 <Allocation Type> FixedSizeAllocator </Allocation Type>
373 <Chunk Id> 18 </Chunk Id>
374 <TotalPages> 1 </TotalPages>
375 <ChunkName > ForeignKeyFieldTableId </ChunkName>
376 <TotalDataNodes> 0 </TotalDataNodes>
377 <SizeOfDataNodes> 32 </SizeOfDataNodes>
378 <Allocation Type> FixedSizeAllocator </Allocation Type>
379 </System Chunk >
380 <User Chunk >
381 <Chunk Id> 101 </Chunk Id>
382 <TotalPages> 250 </TotalPages>
383 <ChunkName > t1 </ChunkName>
384 <TotalDataNodes> 993 </TotalDataNodes>
385 <SizeOfDataNodes> 2024 </SizeOfDataNodes>
386 <Allocation Type> FixedSizeAllocator </Allocation Type>
387 <Chunk Id> 102 </Chunk Id>
388 <TotalPages> 1 </TotalPages>
389 <ChunkName > t1_idx1_Primary </ChunkName>
390 <TotalDataNodes> 1 </TotalDataNodes>
391 <SizeOfDataNodes> 32296 </SizeOfDataNodes>
392 <Allocation Type> FixedSizeAllocator </Allocation Type>
393 <Chunk Id> 103 </Chunk Id>
394 <TotalPages> 6 </TotalPages>
395 <ChunkName > t1_idx1_Primary </ChunkName>
396 <TotalDataNodes> 993 </TotalDataNodes>
397 <SizeOfDataNodes> 32 </SizeOfDataNodes>
398 <Allocation Type> FixedSizeAllocator </Allocation Type>
399 <Chunk Id> 104 </Chunk Id>
400 <TotalPages> 4 </TotalPages>
401 <ChunkName > </ChunkName>
402 <TotalDataNodes> 3 </TotalDataNodes>
403 <SizeOfDataNodes> 8152 </SizeOfDataNodes>
404 <Allocation Type> FixedSizeAllocator </Allocation Type>
405 </User Chunk >
406 </Chunk information>
407 echo drop table t1;
408 Statement Executed