bt_debug.c revision 1.5 1 1.5 cgd /* $NetBSD: bt_debug.c,v 1.5 1995/02/27 13:20:12 cgd Exp $ */
2 1.5 cgd
3 1.1 cgd /*-
4 1.4 cgd * Copyright (c) 1990, 1993, 1994
5 1.1 cgd * The Regents of the University of California. All rights reserved.
6 1.1 cgd *
7 1.1 cgd * This code is derived from software contributed to Berkeley by
8 1.1 cgd * Mike Olson.
9 1.1 cgd *
10 1.1 cgd * Redistribution and use in source and binary forms, with or without
11 1.1 cgd * modification, are permitted provided that the following conditions
12 1.1 cgd * are met:
13 1.1 cgd * 1. Redistributions of source code must retain the above copyright
14 1.1 cgd * notice, this list of conditions and the following disclaimer.
15 1.1 cgd * 2. Redistributions in binary form must reproduce the above copyright
16 1.1 cgd * notice, this list of conditions and the following disclaimer in the
17 1.1 cgd * documentation and/or other materials provided with the distribution.
18 1.1 cgd * 3. All advertising materials mentioning features or use of this software
19 1.1 cgd * must display the following acknowledgement:
20 1.1 cgd * This product includes software developed by the University of
21 1.1 cgd * California, Berkeley and its contributors.
22 1.1 cgd * 4. Neither the name of the University nor the names of its contributors
23 1.1 cgd * may be used to endorse or promote products derived from this software
24 1.1 cgd * without specific prior written permission.
25 1.1 cgd *
26 1.1 cgd * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
27 1.1 cgd * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
28 1.1 cgd * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
29 1.1 cgd * ARE DISCLAIMED. IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE
30 1.1 cgd * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
31 1.1 cgd * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
32 1.1 cgd * OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
33 1.1 cgd * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
34 1.1 cgd * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
35 1.1 cgd * OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
36 1.1 cgd * SUCH DAMAGE.
37 1.1 cgd */
38 1.1 cgd
39 1.1 cgd #if defined(LIBC_SCCS) && !defined(lint)
40 1.5 cgd #if 0
41 1.4 cgd static char sccsid[] = "@(#)bt_debug.c 8.3 (Berkeley) 5/31/94";
42 1.5 cgd #else
43 1.5 cgd static char rcsid[] = "$NetBSD: bt_debug.c,v 1.5 1995/02/27 13:20:12 cgd Exp $";
44 1.5 cgd #endif
45 1.1 cgd #endif /* LIBC_SCCS and not lint */
46 1.1 cgd
47 1.1 cgd #include <sys/param.h>
48 1.1 cgd
49 1.1 cgd #include <stdio.h>
50 1.1 cgd #include <stdlib.h>
51 1.1 cgd #include <string.h>
52 1.1 cgd
53 1.1 cgd #include <db.h>
54 1.1 cgd #include "btree.h"
55 1.1 cgd
56 1.1 cgd #ifdef DEBUG
57 1.1 cgd /*
58 1.1 cgd * BT_DUMP -- Dump the tree
59 1.1 cgd *
60 1.1 cgd * Parameters:
61 1.1 cgd * dbp: pointer to the DB
62 1.1 cgd */
63 1.1 cgd void
64 1.1 cgd __bt_dump(dbp)
65 1.1 cgd DB *dbp;
66 1.1 cgd {
67 1.1 cgd BTREE *t;
68 1.1 cgd PAGE *h;
69 1.1 cgd pgno_t i;
70 1.1 cgd char *sep;
71 1.1 cgd
72 1.1 cgd t = dbp->internal;
73 1.1 cgd (void)fprintf(stderr, "%s: pgsz %d",
74 1.1 cgd ISSET(t, B_INMEM) ? "memory" : "disk", t->bt_psize);
75 1.1 cgd if (ISSET(t, R_RECNO))
76 1.1 cgd (void)fprintf(stderr, " keys %lu", t->bt_nrecs);
77 1.1 cgd #undef X
78 1.1 cgd #define X(flag, name) \
79 1.1 cgd if (ISSET(t, flag)) { \
80 1.1 cgd (void)fprintf(stderr, "%s%s", sep, name); \
81 1.1 cgd sep = ", "; \
82 1.1 cgd }
83 1.1 cgd if (t->bt_flags) {
84 1.1 cgd sep = " flags (";
85 1.1 cgd X(B_DELCRSR, "DELCRSR");
86 1.1 cgd X(R_FIXLEN, "FIXLEN");
87 1.1 cgd X(B_INMEM, "INMEM");
88 1.1 cgd X(B_NODUPS, "NODUPS");
89 1.1 cgd X(B_RDONLY, "RDONLY");
90 1.1 cgd X(R_RECNO, "RECNO");
91 1.1 cgd X(B_SEQINIT, "SEQINIT");
92 1.1 cgd X(B_METADIRTY,"METADIRTY");
93 1.1 cgd (void)fprintf(stderr, ")\n");
94 1.1 cgd }
95 1.1 cgd #undef X
96 1.1 cgd
97 1.1 cgd for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
98 1.1 cgd __bt_dpage(h);
99 1.1 cgd (void)mpool_put(t->bt_mp, h, 0);
100 1.1 cgd }
101 1.1 cgd }
102 1.1 cgd
103 1.1 cgd /*
104 1.1 cgd * BT_DMPAGE -- Dump the meta page
105 1.1 cgd *
106 1.1 cgd * Parameters:
107 1.1 cgd * h: pointer to the PAGE
108 1.1 cgd */
109 1.1 cgd void
110 1.1 cgd __bt_dmpage(h)
111 1.1 cgd PAGE *h;
112 1.1 cgd {
113 1.1 cgd BTMETA *m;
114 1.1 cgd char *sep;
115 1.1 cgd
116 1.1 cgd m = (BTMETA *)h;
117 1.1 cgd (void)fprintf(stderr, "magic %lx\n", m->m_magic);
118 1.1 cgd (void)fprintf(stderr, "version %lu\n", m->m_version);
119 1.1 cgd (void)fprintf(stderr, "psize %lu\n", m->m_psize);
120 1.1 cgd (void)fprintf(stderr, "free %lu\n", m->m_free);
121 1.1 cgd (void)fprintf(stderr, "nrecs %lu\n", m->m_nrecs);
122 1.1 cgd (void)fprintf(stderr, "flags %lu", m->m_flags);
123 1.1 cgd #undef X
124 1.1 cgd #define X(flag, name) \
125 1.1 cgd if (m->m_flags & flag) { \
126 1.1 cgd (void)fprintf(stderr, "%s%s", sep, name); \
127 1.1 cgd sep = ", "; \
128 1.1 cgd }
129 1.1 cgd if (m->m_flags) {
130 1.1 cgd sep = " (";
131 1.1 cgd X(B_NODUPS, "NODUPS");
132 1.1 cgd X(R_RECNO, "RECNO");
133 1.1 cgd (void)fprintf(stderr, ")");
134 1.1 cgd }
135 1.1 cgd }
136 1.1 cgd
137 1.1 cgd /*
138 1.1 cgd * BT_DNPAGE -- Dump the page
139 1.1 cgd *
140 1.1 cgd * Parameters:
141 1.1 cgd * n: page number to dump.
142 1.1 cgd */
143 1.1 cgd void
144 1.1 cgd __bt_dnpage(dbp, pgno)
145 1.1 cgd DB *dbp;
146 1.1 cgd pgno_t pgno;
147 1.1 cgd {
148 1.1 cgd BTREE *t;
149 1.1 cgd PAGE *h;
150 1.1 cgd
151 1.1 cgd t = dbp->internal;
152 1.1 cgd if ((h = mpool_get(t->bt_mp, pgno, 0)) != NULL) {
153 1.1 cgd __bt_dpage(h);
154 1.1 cgd (void)mpool_put(t->bt_mp, h, 0);
155 1.1 cgd }
156 1.1 cgd }
157 1.1 cgd
158 1.1 cgd /*
159 1.1 cgd * BT_DPAGE -- Dump the page
160 1.1 cgd *
161 1.1 cgd * Parameters:
162 1.1 cgd * h: pointer to the PAGE
163 1.1 cgd */
164 1.1 cgd void
165 1.1 cgd __bt_dpage(h)
166 1.1 cgd PAGE *h;
167 1.1 cgd {
168 1.1 cgd BINTERNAL *bi;
169 1.1 cgd BLEAF *bl;
170 1.1 cgd RINTERNAL *ri;
171 1.1 cgd RLEAF *rl;
172 1.1 cgd indx_t cur, top;
173 1.1 cgd char *sep;
174 1.1 cgd
175 1.1 cgd (void)fprintf(stderr, " page %d: (", h->pgno);
176 1.1 cgd #undef X
177 1.1 cgd #define X(flag, name) \
178 1.1 cgd if (h->flags & flag) { \
179 1.1 cgd (void)fprintf(stderr, "%s%s", sep, name); \
180 1.1 cgd sep = ", "; \
181 1.1 cgd }
182 1.1 cgd sep = "";
183 1.1 cgd X(P_BINTERNAL, "BINTERNAL") /* types */
184 1.1 cgd X(P_BLEAF, "BLEAF")
185 1.1 cgd X(P_RINTERNAL, "RINTERNAL") /* types */
186 1.1 cgd X(P_RLEAF, "RLEAF")
187 1.1 cgd X(P_OVERFLOW, "OVERFLOW")
188 1.1 cgd X(P_PRESERVE, "PRESERVE");
189 1.1 cgd (void)fprintf(stderr, ")\n");
190 1.1 cgd #undef X
191 1.1 cgd
192 1.1 cgd (void)fprintf(stderr, "\tprev %2d next %2d", h->prevpg, h->nextpg);
193 1.1 cgd if (h->flags & P_OVERFLOW)
194 1.1 cgd return;
195 1.1 cgd
196 1.1 cgd top = NEXTINDEX(h);
197 1.1 cgd (void)fprintf(stderr, " lower %3d upper %3d nextind %d\n",
198 1.1 cgd h->lower, h->upper, top);
199 1.1 cgd for (cur = 0; cur < top; cur++) {
200 1.1 cgd (void)fprintf(stderr, "\t[%03d] %4d ", cur, h->linp[cur]);
201 1.1 cgd switch(h->flags & P_TYPE) {
202 1.1 cgd case P_BINTERNAL:
203 1.1 cgd bi = GETBINTERNAL(h, cur);
204 1.1 cgd (void)fprintf(stderr,
205 1.1 cgd "size %03d pgno %03d", bi->ksize, bi->pgno);
206 1.1 cgd if (bi->flags & P_BIGKEY)
207 1.1 cgd (void)fprintf(stderr, " (indirect)");
208 1.1 cgd else if (bi->ksize)
209 1.1 cgd (void)fprintf(stderr,
210 1.1 cgd " {%.*s}", (int)bi->ksize, bi->bytes);
211 1.1 cgd break;
212 1.1 cgd case P_RINTERNAL:
213 1.1 cgd ri = GETRINTERNAL(h, cur);
214 1.1 cgd (void)fprintf(stderr, "entries %03d pgno %03d",
215 1.1 cgd ri->nrecs, ri->pgno);
216 1.1 cgd break;
217 1.1 cgd case P_BLEAF:
218 1.1 cgd bl = GETBLEAF(h, cur);
219 1.1 cgd if (bl->flags & P_BIGKEY)
220 1.1 cgd (void)fprintf(stderr,
221 1.1 cgd "big key page %lu size %u/",
222 1.1 cgd *(pgno_t *)bl->bytes,
223 1.4 cgd *(u_int32_t *)(bl->bytes + sizeof(pgno_t)));
224 1.1 cgd else if (bl->ksize)
225 1.1 cgd (void)fprintf(stderr, "%s/", bl->bytes);
226 1.1 cgd if (bl->flags & P_BIGDATA)
227 1.1 cgd (void)fprintf(stderr,
228 1.1 cgd "big data page %lu size %u",
229 1.1 cgd *(pgno_t *)(bl->bytes + bl->ksize),
230 1.4 cgd *(u_int32_t *)(bl->bytes + bl->ksize +
231 1.1 cgd sizeof(pgno_t)));
232 1.1 cgd else if (bl->dsize)
233 1.1 cgd (void)fprintf(stderr, "%.*s",
234 1.1 cgd (int)bl->dsize, bl->bytes + bl->ksize);
235 1.1 cgd break;
236 1.1 cgd case P_RLEAF:
237 1.1 cgd rl = GETRLEAF(h, cur);
238 1.1 cgd if (rl->flags & P_BIGDATA)
239 1.1 cgd (void)fprintf(stderr,
240 1.1 cgd "big data page %lu size %u",
241 1.1 cgd *(pgno_t *)rl->bytes,
242 1.4 cgd *(u_int32_t *)(rl->bytes + sizeof(pgno_t)));
243 1.1 cgd else if (rl->dsize)
244 1.1 cgd (void)fprintf(stderr,
245 1.1 cgd "%.*s", (int)rl->dsize, rl->bytes);
246 1.1 cgd break;
247 1.1 cgd }
248 1.1 cgd (void)fprintf(stderr, "\n");
249 1.1 cgd }
250 1.1 cgd }
251 1.1 cgd #endif
252 1.1 cgd
253 1.1 cgd #ifdef STATISTICS
254 1.1 cgd /*
255 1.1 cgd * BT_STAT -- Gather/print the tree statistics
256 1.1 cgd *
257 1.1 cgd * Parameters:
258 1.1 cgd * dbp: pointer to the DB
259 1.1 cgd */
260 1.1 cgd void
261 1.1 cgd __bt_stat(dbp)
262 1.1 cgd DB *dbp;
263 1.1 cgd {
264 1.4 cgd extern u_long bt_cache_hit, bt_cache_miss, bt_pfxsaved, bt_rootsplit;
265 1.4 cgd extern u_long bt_sortsplit, bt_split;
266 1.1 cgd BTREE *t;
267 1.1 cgd PAGE *h;
268 1.1 cgd pgno_t i, pcont, pinternal, pleaf;
269 1.1 cgd u_long ifree, lfree, nkeys;
270 1.1 cgd int levels;
271 1.1 cgd
272 1.1 cgd t = dbp->internal;
273 1.1 cgd pcont = pinternal = pleaf = 0;
274 1.1 cgd nkeys = ifree = lfree = 0;
275 1.1 cgd for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
276 1.1 cgd switch(h->flags & P_TYPE) {
277 1.1 cgd case P_BINTERNAL:
278 1.1 cgd case P_RINTERNAL:
279 1.1 cgd ++pinternal;
280 1.1 cgd ifree += h->upper - h->lower;
281 1.1 cgd break;
282 1.1 cgd case P_BLEAF:
283 1.1 cgd case P_RLEAF:
284 1.1 cgd ++pleaf;
285 1.1 cgd lfree += h->upper - h->lower;
286 1.1 cgd nkeys += NEXTINDEX(h);
287 1.1 cgd break;
288 1.1 cgd case P_OVERFLOW:
289 1.1 cgd ++pcont;
290 1.1 cgd break;
291 1.1 cgd }
292 1.1 cgd (void)mpool_put(t->bt_mp, h, 0);
293 1.1 cgd }
294 1.1 cgd
295 1.1 cgd /* Count the levels of the tree. */
296 1.1 cgd for (i = P_ROOT, levels = 0 ;; ++levels) {
297 1.1 cgd h = mpool_get(t->bt_mp, i, 0);
298 1.1 cgd if (h->flags & (P_BLEAF|P_RLEAF)) {
299 1.1 cgd if (levels == 0)
300 1.1 cgd levels = 1;
301 1.1 cgd (void)mpool_put(t->bt_mp, h, 0);
302 1.1 cgd break;
303 1.1 cgd }
304 1.1 cgd i = ISSET(t, R_RECNO) ?
305 1.1 cgd GETRINTERNAL(h, 0)->pgno :
306 1.1 cgd GETBINTERNAL(h, 0)->pgno;
307 1.1 cgd (void)mpool_put(t->bt_mp, h, 0);
308 1.1 cgd }
309 1.1 cgd
310 1.1 cgd (void)fprintf(stderr, "%d level%s with %ld keys",
311 1.1 cgd levels, levels == 1 ? "" : "s", nkeys);
312 1.1 cgd if (ISSET(t, R_RECNO))
313 1.1 cgd (void)fprintf(stderr, " (%ld header count)", t->bt_nrecs);
314 1.1 cgd (void)fprintf(stderr,
315 1.1 cgd "\n%lu pages (leaf %ld, internal %ld, overflow %ld)\n",
316 1.1 cgd pinternal + pleaf + pcont, pleaf, pinternal, pcont);
317 1.1 cgd (void)fprintf(stderr, "%ld cache hits, %ld cache misses\n",
318 1.1 cgd bt_cache_hit, bt_cache_miss);
319 1.1 cgd (void)fprintf(stderr, "%ld splits (%ld root splits, %ld sort splits)\n",
320 1.1 cgd bt_split, bt_rootsplit, bt_sortsplit);
321 1.1 cgd pleaf *= t->bt_psize - BTDATAOFF;
322 1.1 cgd if (pleaf)
323 1.1 cgd (void)fprintf(stderr,
324 1.1 cgd "%.0f%% leaf fill (%ld bytes used, %ld bytes free)\n",
325 1.1 cgd ((double)(pleaf - lfree) / pleaf) * 100,
326 1.1 cgd pleaf - lfree, lfree);
327 1.1 cgd pinternal *= t->bt_psize - BTDATAOFF;
328 1.1 cgd if (pinternal)
329 1.1 cgd (void)fprintf(stderr,
330 1.1 cgd "%.0f%% internal fill (%ld bytes used, %ld bytes free\n",
331 1.1 cgd ((double)(pinternal - ifree) / pinternal) * 100,
332 1.1 cgd pinternal - ifree, ifree);
333 1.1 cgd if (bt_pfxsaved)
334 1.1 cgd (void)fprintf(stderr, "prefix checking removed %lu bytes.\n",
335 1.1 cgd bt_pfxsaved);
336 1.1 cgd }
337 1.1 cgd #endif
338