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