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