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