Home | History | Annotate | Line # | Download | only in btree
bt_debug.c revision 1.7.14.1
      1  1.7.14.1   nathanw /*	$NetBSD: bt_debug.c,v 1.7.14.1 2002/01/28 20:50:21 nathanw 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.7  christos #include <sys/cdefs.h>
     40       1.1       cgd #if defined(LIBC_SCCS) && !defined(lint)
     41       1.5       cgd #if 0
     42       1.6       cgd static char sccsid[] = "@(#)bt_debug.c	8.5 (Berkeley) 8/17/94";
     43       1.5       cgd #else
     44  1.7.14.1   nathanw __RCSID("$NetBSD: bt_debug.c,v 1.7.14.1 2002/01/28 20:50:21 nathanw Exp $");
     45       1.5       cgd #endif
     46       1.1       cgd #endif /* LIBC_SCCS and not lint */
     47       1.1       cgd 
     48       1.1       cgd #include <stdio.h>
     49       1.1       cgd #include <stdlib.h>
     50       1.1       cgd #include <string.h>
     51       1.1       cgd 
     52       1.1       cgd #include <db.h>
     53       1.1       cgd #include "btree.h"
     54       1.1       cgd 
     55       1.1       cgd #ifdef DEBUG
     56       1.1       cgd /*
     57       1.1       cgd  * BT_DUMP -- Dump the tree
     58       1.1       cgd  *
     59       1.1       cgd  * Parameters:
     60       1.1       cgd  *	dbp:	pointer to the DB
     61       1.1       cgd  */
     62       1.1       cgd void
     63       1.1       cgd __bt_dump(dbp)
     64       1.1       cgd 	DB *dbp;
     65       1.1       cgd {
     66       1.1       cgd 	BTREE *t;
     67       1.1       cgd 	PAGE *h;
     68       1.1       cgd 	pgno_t i;
     69       1.1       cgd 	char *sep;
     70       1.1       cgd 
     71       1.1       cgd 	t = dbp->internal;
     72       1.1       cgd 	(void)fprintf(stderr, "%s: pgsz %d",
     73       1.6       cgd 	    F_ISSET(t, B_INMEM) ? "memory" : "disk", t->bt_psize);
     74       1.6       cgd 	if (F_ISSET(t, R_RECNO))
     75  1.7.14.1   nathanw 		(void)fprintf(stderr, " keys %lu", (u_long) t->bt_nrecs);
     76       1.1       cgd #undef X
     77       1.1       cgd #define	X(flag, name) \
     78       1.6       cgd 	if (F_ISSET(t, flag)) { \
     79       1.1       cgd 		(void)fprintf(stderr, "%s%s", sep, name); \
     80       1.1       cgd 		sep = ", "; \
     81       1.1       cgd 	}
     82       1.6       cgd 	if (t->flags != 0) {
     83       1.1       cgd 		sep = " flags (";
     84       1.1       cgd 		X(R_FIXLEN,	"FIXLEN");
     85       1.1       cgd 		X(B_INMEM,	"INMEM");
     86       1.1       cgd 		X(B_NODUPS,	"NODUPS");
     87       1.1       cgd 		X(B_RDONLY,	"RDONLY");
     88       1.1       cgd 		X(R_RECNO,	"RECNO");
     89       1.1       cgd 		X(B_METADIRTY,"METADIRTY");
     90       1.1       cgd 		(void)fprintf(stderr, ")\n");
     91       1.1       cgd 	}
     92       1.1       cgd #undef X
     93       1.1       cgd 
     94       1.1       cgd 	for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
     95       1.1       cgd 		__bt_dpage(h);
     96       1.1       cgd 		(void)mpool_put(t->bt_mp, h, 0);
     97       1.1       cgd 	}
     98       1.1       cgd }
     99       1.1       cgd 
    100       1.1       cgd /*
    101       1.1       cgd  * BT_DMPAGE -- Dump the meta page
    102       1.1       cgd  *
    103       1.1       cgd  * Parameters:
    104       1.1       cgd  *	h:	pointer to the PAGE
    105       1.1       cgd  */
    106       1.1       cgd void
    107       1.1       cgd __bt_dmpage(h)
    108       1.1       cgd 	PAGE *h;
    109       1.1       cgd {
    110       1.1       cgd 	BTMETA *m;
    111       1.1       cgd 	char *sep;
    112       1.1       cgd 
    113       1.1       cgd 	m = (BTMETA *)h;
    114  1.7.14.1   nathanw 	(void)fprintf(stderr, "magic %lx\n", (u_long) m->magic);
    115  1.7.14.1   nathanw 	(void)fprintf(stderr, "version %lu\n", (u_long) m->version);
    116  1.7.14.1   nathanw 	(void)fprintf(stderr, "psize %lu\n", (u_long) m->psize);
    117  1.7.14.1   nathanw 	(void)fprintf(stderr, "free %lu\n", (u_long) m->free);
    118  1.7.14.1   nathanw 	(void)fprintf(stderr, "nrecs %lu\n", (u_long) m->nrecs);
    119  1.7.14.1   nathanw 	(void)fprintf(stderr, "flags %lu", (u_long) m->flags);
    120       1.1       cgd #undef X
    121       1.1       cgd #define	X(flag, name) \
    122       1.6       cgd 	if (m->flags & flag) { \
    123       1.1       cgd 		(void)fprintf(stderr, "%s%s", sep, name); \
    124       1.1       cgd 		sep = ", "; \
    125       1.1       cgd 	}
    126       1.6       cgd 	if (m->flags) {
    127       1.1       cgd 		sep = " (";
    128       1.1       cgd 		X(B_NODUPS,	"NODUPS");
    129       1.1       cgd 		X(R_RECNO,	"RECNO");
    130       1.1       cgd 		(void)fprintf(stderr, ")");
    131       1.1       cgd 	}
    132       1.1       cgd }
    133       1.1       cgd 
    134       1.1       cgd /*
    135       1.1       cgd  * BT_DNPAGE -- Dump the page
    136       1.1       cgd  *
    137       1.1       cgd  * Parameters:
    138       1.1       cgd  *	n:	page number to dump.
    139       1.1       cgd  */
    140       1.1       cgd void
    141       1.1       cgd __bt_dnpage(dbp, pgno)
    142       1.1       cgd 	DB *dbp;
    143       1.1       cgd 	pgno_t pgno;
    144       1.1       cgd {
    145       1.1       cgd 	BTREE *t;
    146       1.1       cgd 	PAGE *h;
    147       1.1       cgd 
    148       1.1       cgd 	t = dbp->internal;
    149       1.1       cgd 	if ((h = mpool_get(t->bt_mp, pgno, 0)) != NULL) {
    150       1.1       cgd 		__bt_dpage(h);
    151       1.1       cgd 		(void)mpool_put(t->bt_mp, h, 0);
    152       1.1       cgd 	}
    153       1.1       cgd }
    154       1.1       cgd 
    155       1.1       cgd /*
    156       1.1       cgd  * BT_DPAGE -- Dump the page
    157       1.1       cgd  *
    158       1.1       cgd  * Parameters:
    159       1.1       cgd  *	h:	pointer to the PAGE
    160       1.1       cgd  */
    161       1.1       cgd void
    162       1.1       cgd __bt_dpage(h)
    163       1.1       cgd 	PAGE *h;
    164       1.1       cgd {
    165       1.1       cgd 	BINTERNAL *bi;
    166       1.1       cgd 	BLEAF *bl;
    167       1.1       cgd 	RINTERNAL *ri;
    168       1.1       cgd 	RLEAF *rl;
    169       1.1       cgd 	indx_t cur, top;
    170       1.1       cgd 	char *sep;
    171       1.1       cgd 
    172       1.1       cgd 	(void)fprintf(stderr, "    page %d: (", h->pgno);
    173       1.1       cgd #undef X
    174       1.1       cgd #define	X(flag, name) \
    175       1.1       cgd 	if (h->flags & flag) { \
    176       1.1       cgd 		(void)fprintf(stderr, "%s%s", sep, name); \
    177       1.1       cgd 		sep = ", "; \
    178       1.1       cgd 	}
    179       1.1       cgd 	sep = "";
    180       1.1       cgd 	X(P_BINTERNAL,	"BINTERNAL")		/* types */
    181       1.1       cgd 	X(P_BLEAF,	"BLEAF")
    182       1.1       cgd 	X(P_RINTERNAL,	"RINTERNAL")		/* types */
    183       1.1       cgd 	X(P_RLEAF,	"RLEAF")
    184       1.1       cgd 	X(P_OVERFLOW,	"OVERFLOW")
    185       1.1       cgd 	X(P_PRESERVE,	"PRESERVE");
    186       1.1       cgd 	(void)fprintf(stderr, ")\n");
    187       1.1       cgd #undef X
    188       1.1       cgd 
    189       1.1       cgd 	(void)fprintf(stderr, "\tprev %2d next %2d", h->prevpg, h->nextpg);
    190       1.1       cgd 	if (h->flags & P_OVERFLOW)
    191       1.1       cgd 		return;
    192       1.1       cgd 
    193       1.1       cgd 	top = NEXTINDEX(h);
    194       1.1       cgd 	(void)fprintf(stderr, " lower %3d upper %3d nextind %d\n",
    195       1.1       cgd 	    h->lower, h->upper, top);
    196       1.1       cgd 	for (cur = 0; cur < top; cur++) {
    197       1.1       cgd 		(void)fprintf(stderr, "\t[%03d] %4d ", cur, h->linp[cur]);
    198       1.6       cgd 		switch (h->flags & P_TYPE) {
    199       1.1       cgd 		case P_BINTERNAL:
    200       1.1       cgd 			bi = GETBINTERNAL(h, cur);
    201       1.1       cgd 			(void)fprintf(stderr,
    202       1.1       cgd 			    "size %03d pgno %03d", bi->ksize, bi->pgno);
    203       1.1       cgd 			if (bi->flags & P_BIGKEY)
    204       1.1       cgd 				(void)fprintf(stderr, " (indirect)");
    205       1.1       cgd 			else if (bi->ksize)
    206       1.1       cgd 				(void)fprintf(stderr,
    207       1.1       cgd 				    " {%.*s}", (int)bi->ksize, bi->bytes);
    208       1.1       cgd 			break;
    209       1.1       cgd 		case P_RINTERNAL:
    210       1.1       cgd 			ri = GETRINTERNAL(h, cur);
    211       1.1       cgd 			(void)fprintf(stderr, "entries %03d pgno %03d",
    212       1.1       cgd 				ri->nrecs, ri->pgno);
    213       1.1       cgd 			break;
    214       1.1       cgd 		case P_BLEAF:
    215       1.1       cgd 			bl = GETBLEAF(h, cur);
    216       1.1       cgd 			if (bl->flags & P_BIGKEY)
    217       1.1       cgd 				(void)fprintf(stderr,
    218       1.1       cgd 				    "big key page %lu size %u/",
    219  1.7.14.1   nathanw 				    (u_long) *(pgno_t *)bl->bytes,
    220       1.4       cgd 				    *(u_int32_t *)(bl->bytes + sizeof(pgno_t)));
    221       1.1       cgd 			else if (bl->ksize)
    222       1.1       cgd 				(void)fprintf(stderr, "%s/", bl->bytes);
    223       1.1       cgd 			if (bl->flags & P_BIGDATA)
    224       1.1       cgd 				(void)fprintf(stderr,
    225       1.1       cgd 				    "big data page %lu size %u",
    226  1.7.14.1   nathanw 				    (u_long) *(pgno_t *)(bl->bytes + bl->ksize),
    227       1.4       cgd 				    *(u_int32_t *)(bl->bytes + bl->ksize +
    228       1.1       cgd 				    sizeof(pgno_t)));
    229       1.1       cgd 			else if (bl->dsize)
    230       1.1       cgd 				(void)fprintf(stderr, "%.*s",
    231       1.1       cgd 				    (int)bl->dsize, bl->bytes + bl->ksize);
    232       1.1       cgd 			break;
    233       1.1       cgd 		case P_RLEAF:
    234       1.1       cgd 			rl = GETRLEAF(h, cur);
    235       1.1       cgd 			if (rl->flags & P_BIGDATA)
    236       1.1       cgd 				(void)fprintf(stderr,
    237       1.1       cgd 				    "big data page %lu size %u",
    238  1.7.14.1   nathanw 				    (u_long) *(pgno_t *)rl->bytes,
    239       1.4       cgd 				    *(u_int32_t *)(rl->bytes + sizeof(pgno_t)));
    240       1.1       cgd 			else if (rl->dsize)
    241       1.1       cgd 				(void)fprintf(stderr,
    242       1.1       cgd 				    "%.*s", (int)rl->dsize, rl->bytes);
    243       1.1       cgd 			break;
    244       1.1       cgd 		}
    245       1.1       cgd 		(void)fprintf(stderr, "\n");
    246       1.1       cgd 	}
    247       1.1       cgd }
    248       1.1       cgd #endif
    249       1.1       cgd 
    250       1.1       cgd #ifdef STATISTICS
    251       1.1       cgd /*
    252       1.1       cgd  * BT_STAT -- Gather/print the tree statistics
    253       1.1       cgd  *
    254       1.1       cgd  * Parameters:
    255       1.1       cgd  *	dbp:	pointer to the DB
    256       1.1       cgd  */
    257       1.1       cgd void
    258       1.1       cgd __bt_stat(dbp)
    259       1.1       cgd 	DB *dbp;
    260       1.1       cgd {
    261       1.4       cgd 	extern u_long bt_cache_hit, bt_cache_miss, bt_pfxsaved, bt_rootsplit;
    262       1.4       cgd 	extern u_long bt_sortsplit, bt_split;
    263       1.1       cgd 	BTREE *t;
    264       1.1       cgd 	PAGE *h;
    265       1.1       cgd 	pgno_t i, pcont, pinternal, pleaf;
    266       1.1       cgd 	u_long ifree, lfree, nkeys;
    267       1.1       cgd 	int levels;
    268       1.1       cgd 
    269       1.1       cgd 	t = dbp->internal;
    270       1.1       cgd 	pcont = pinternal = pleaf = 0;
    271       1.1       cgd 	nkeys = ifree = lfree = 0;
    272       1.1       cgd 	for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
    273       1.6       cgd 		switch (h->flags & P_TYPE) {
    274       1.1       cgd 		case P_BINTERNAL:
    275       1.1       cgd 		case P_RINTERNAL:
    276       1.1       cgd 			++pinternal;
    277       1.1       cgd 			ifree += h->upper - h->lower;
    278       1.1       cgd 			break;
    279       1.1       cgd 		case P_BLEAF:
    280       1.1       cgd 		case P_RLEAF:
    281       1.1       cgd 			++pleaf;
    282       1.1       cgd 			lfree += h->upper - h->lower;
    283       1.1       cgd 			nkeys += NEXTINDEX(h);
    284       1.1       cgd 			break;
    285       1.1       cgd 		case P_OVERFLOW:
    286       1.1       cgd 			++pcont;
    287       1.1       cgd 			break;
    288       1.1       cgd 		}
    289       1.1       cgd 		(void)mpool_put(t->bt_mp, h, 0);
    290       1.1       cgd 	}
    291       1.1       cgd 
    292       1.1       cgd 	/* Count the levels of the tree. */
    293       1.1       cgd 	for (i = P_ROOT, levels = 0 ;; ++levels) {
    294       1.1       cgd 		h = mpool_get(t->bt_mp, i, 0);
    295       1.1       cgd 		if (h->flags & (P_BLEAF|P_RLEAF)) {
    296       1.1       cgd 			if (levels == 0)
    297       1.1       cgd 				levels = 1;
    298       1.1       cgd 			(void)mpool_put(t->bt_mp, h, 0);
    299       1.1       cgd 			break;
    300       1.1       cgd 		}
    301       1.6       cgd 		i = F_ISSET(t, R_RECNO) ?
    302       1.1       cgd 		    GETRINTERNAL(h, 0)->pgno :
    303       1.1       cgd 		    GETBINTERNAL(h, 0)->pgno;
    304       1.1       cgd 		(void)mpool_put(t->bt_mp, h, 0);
    305       1.1       cgd 	}
    306       1.1       cgd 
    307       1.1       cgd 	(void)fprintf(stderr, "%d level%s with %ld keys",
    308       1.1       cgd 	    levels, levels == 1 ? "" : "s", nkeys);
    309       1.6       cgd 	if (F_ISSET(t, R_RECNO))
    310       1.1       cgd 		(void)fprintf(stderr, " (%ld header count)", t->bt_nrecs);
    311       1.1       cgd 	(void)fprintf(stderr,
    312       1.1       cgd 	    "\n%lu pages (leaf %ld, internal %ld, overflow %ld)\n",
    313       1.1       cgd 	    pinternal + pleaf + pcont, pleaf, pinternal, pcont);
    314       1.1       cgd 	(void)fprintf(stderr, "%ld cache hits, %ld cache misses\n",
    315       1.1       cgd 	    bt_cache_hit, bt_cache_miss);
    316       1.1       cgd 	(void)fprintf(stderr, "%ld splits (%ld root splits, %ld sort splits)\n",
    317       1.1       cgd 	    bt_split, bt_rootsplit, bt_sortsplit);
    318       1.1       cgd 	pleaf *= t->bt_psize - BTDATAOFF;
    319       1.1       cgd 	if (pleaf)
    320       1.1       cgd 		(void)fprintf(stderr,
    321       1.1       cgd 		    "%.0f%% leaf fill (%ld bytes used, %ld bytes free)\n",
    322       1.1       cgd 		    ((double)(pleaf - lfree) / pleaf) * 100,
    323       1.1       cgd 		    pleaf - lfree, lfree);
    324       1.1       cgd 	pinternal *= t->bt_psize - BTDATAOFF;
    325       1.1       cgd 	if (pinternal)
    326       1.1       cgd 		(void)fprintf(stderr,
    327       1.1       cgd 		    "%.0f%% internal fill (%ld bytes used, %ld bytes free\n",
    328       1.1       cgd 		    ((double)(pinternal - ifree) / pinternal) * 100,
    329       1.1       cgd 		    pinternal - ifree, ifree);
    330       1.1       cgd 	if (bt_pfxsaved)
    331       1.1       cgd 		(void)fprintf(stderr, "prefix checking removed %lu bytes.\n",
    332       1.1       cgd 		    bt_pfxsaved);
    333       1.1       cgd }
    334       1.1       cgd #endif
    335