1*f14fb602SLionel Sambuc /* $NetBSD: bt_debug.c,v 1.16 2011/07/17 20:47:39 christos Exp $ */
22639ae9bSBen Gras
32639ae9bSBen Gras /*-
42639ae9bSBen Gras * Copyright (c) 1990, 1993, 1994
52639ae9bSBen Gras * The Regents of the University of California. All rights reserved.
62639ae9bSBen Gras *
72639ae9bSBen Gras * This code is derived from software contributed to Berkeley by
82639ae9bSBen Gras * Mike Olson.
92639ae9bSBen Gras *
102639ae9bSBen Gras * Redistribution and use in source and binary forms, with or without
112639ae9bSBen Gras * modification, are permitted provided that the following conditions
122639ae9bSBen Gras * are met:
132639ae9bSBen Gras * 1. Redistributions of source code must retain the above copyright
142639ae9bSBen Gras * notice, this list of conditions and the following disclaimer.
152639ae9bSBen Gras * 2. Redistributions in binary form must reproduce the above copyright
162639ae9bSBen Gras * notice, this list of conditions and the following disclaimer in the
172639ae9bSBen Gras * documentation and/or other materials provided with the distribution.
182639ae9bSBen Gras * 3. Neither the name of the University nor the names of its contributors
192639ae9bSBen Gras * may be used to endorse or promote products derived from this software
202639ae9bSBen Gras * without specific prior written permission.
212639ae9bSBen Gras *
222639ae9bSBen Gras * THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND
232639ae9bSBen Gras * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
242639ae9bSBen Gras * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
252639ae9bSBen Gras * ARE DISCLAIMED. IN NO EVENT SHALL THE REGENTS OR CONTRIBUTORS BE LIABLE
262639ae9bSBen Gras * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
272639ae9bSBen Gras * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
282639ae9bSBen Gras * OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
292639ae9bSBen Gras * HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
302639ae9bSBen Gras * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
312639ae9bSBen Gras * OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
322639ae9bSBen Gras * SUCH DAMAGE.
332639ae9bSBen Gras */
342639ae9bSBen Gras
352639ae9bSBen Gras #if HAVE_NBTOOL_CONFIG_H
362639ae9bSBen Gras #include "nbtool_config.h"
372639ae9bSBen Gras #endif
382639ae9bSBen Gras
392639ae9bSBen Gras #include <sys/cdefs.h>
40*f14fb602SLionel Sambuc __RCSID("$NetBSD: bt_debug.c,v 1.16 2011/07/17 20:47:39 christos Exp $");
412639ae9bSBen Gras
422639ae9bSBen Gras #include <assert.h>
432639ae9bSBen Gras #include <stdio.h>
442639ae9bSBen Gras #include <stdlib.h>
452639ae9bSBen Gras #include <string.h>
462639ae9bSBen Gras
472639ae9bSBen Gras #include <db.h>
482639ae9bSBen Gras #include "btree.h"
492639ae9bSBen Gras
502639ae9bSBen Gras #ifdef DEBUG
512639ae9bSBen Gras /*
522639ae9bSBen Gras * BT_DUMP -- Dump the tree
532639ae9bSBen Gras *
542639ae9bSBen Gras * Parameters:
552639ae9bSBen Gras * dbp: pointer to the DB
562639ae9bSBen Gras */
572639ae9bSBen Gras void
__bt_dump(DB * dbp)582639ae9bSBen Gras __bt_dump(DB *dbp)
592639ae9bSBen Gras {
602639ae9bSBen Gras BTREE *t;
612639ae9bSBen Gras PAGE *h;
622639ae9bSBen Gras pgno_t i;
632639ae9bSBen Gras const char *sep;
642639ae9bSBen Gras
652639ae9bSBen Gras t = dbp->internal;
662639ae9bSBen Gras (void)fprintf(stderr, "%s: pgsz %d",
672639ae9bSBen Gras F_ISSET(t, B_INMEM) ? "memory" : "disk", t->bt_psize);
682639ae9bSBen Gras if (F_ISSET(t, R_RECNO))
692639ae9bSBen Gras (void)fprintf(stderr, " keys %lu", (unsigned long) t->bt_nrecs);
702639ae9bSBen Gras #undef X
712639ae9bSBen Gras #define X(flag, name) \
722639ae9bSBen Gras if (F_ISSET(t, flag)) { \
732639ae9bSBen Gras (void)fprintf(stderr, "%s%s", sep, name); \
742639ae9bSBen Gras sep = ", "; \
752639ae9bSBen Gras }
762639ae9bSBen Gras if (t->flags != 0) {
772639ae9bSBen Gras sep = " flags (";
782639ae9bSBen Gras X(R_FIXLEN, "FIXLEN");
792639ae9bSBen Gras X(B_INMEM, "INMEM");
802639ae9bSBen Gras X(B_NODUPS, "NODUPS");
812639ae9bSBen Gras X(B_RDONLY, "RDONLY");
822639ae9bSBen Gras X(R_RECNO, "RECNO");
832639ae9bSBen Gras X(B_METADIRTY,"METADIRTY");
842639ae9bSBen Gras (void)fprintf(stderr, ")\n");
852639ae9bSBen Gras }
862639ae9bSBen Gras #undef X
872639ae9bSBen Gras
882639ae9bSBen Gras for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
892639ae9bSBen Gras __bt_dpage(h);
902639ae9bSBen Gras (void)mpool_put(t->bt_mp, h, 0);
912639ae9bSBen Gras }
922639ae9bSBen Gras }
932639ae9bSBen Gras
942639ae9bSBen Gras /*
952639ae9bSBen Gras * BT_DMPAGE -- Dump the meta page
962639ae9bSBen Gras *
972639ae9bSBen Gras * Parameters:
982639ae9bSBen Gras * h: pointer to the PAGE
992639ae9bSBen Gras */
1002639ae9bSBen Gras void
__bt_dmpage(PAGE * h)1012639ae9bSBen Gras __bt_dmpage(PAGE *h)
1022639ae9bSBen Gras {
1032639ae9bSBen Gras BTMETA *m;
1042639ae9bSBen Gras const char *sep;
1052639ae9bSBen Gras
1062639ae9bSBen Gras m = (BTMETA *)(void *)h;
1072639ae9bSBen Gras (void)fprintf(stderr, "magic %lx\n", (unsigned long) m->magic);
1082639ae9bSBen Gras (void)fprintf(stderr, "version %lu\n", (unsigned long) m->version);
1092639ae9bSBen Gras (void)fprintf(stderr, "psize %lu\n", (unsigned long) m->psize);
1102639ae9bSBen Gras (void)fprintf(stderr, "free %lu\n", (unsigned long) m->free);
1112639ae9bSBen Gras (void)fprintf(stderr, "nrecs %lu\n", (unsigned long) m->nrecs);
1122639ae9bSBen Gras (void)fprintf(stderr, "flags %lu", (unsigned long) m->flags);
1132639ae9bSBen Gras #undef X
1142639ae9bSBen Gras #define X(flag, name) \
1152639ae9bSBen Gras if (m->flags & flag) { \
1162639ae9bSBen Gras (void)fprintf(stderr, "%s%s", sep, name); \
1172639ae9bSBen Gras sep = ", "; \
1182639ae9bSBen Gras }
1192639ae9bSBen Gras if (m->flags) {
1202639ae9bSBen Gras sep = " (";
1212639ae9bSBen Gras X(B_NODUPS, "NODUPS");
1222639ae9bSBen Gras X(R_RECNO, "RECNO");
1232639ae9bSBen Gras (void)fprintf(stderr, ")");
1242639ae9bSBen Gras }
1252639ae9bSBen Gras }
1262639ae9bSBen Gras
127*f14fb602SLionel Sambuc static pgno_t
__bt_pgno_t(const void * m)128*f14fb602SLionel Sambuc __bt_pgno_t(const void *m)
129*f14fb602SLionel Sambuc {
130*f14fb602SLionel Sambuc pgno_t r;
131*f14fb602SLionel Sambuc memcpy(&r, m, sizeof(r));
132*f14fb602SLionel Sambuc return r;
133*f14fb602SLionel Sambuc }
134*f14fb602SLionel Sambuc
135*f14fb602SLionel Sambuc static uint32_t
__bt_uint32_t(const void * m)136*f14fb602SLionel Sambuc __bt_uint32_t(const void *m)
137*f14fb602SLionel Sambuc {
138*f14fb602SLionel Sambuc uint32_t r;
139*f14fb602SLionel Sambuc memcpy(&r, m, sizeof(r));
140*f14fb602SLionel Sambuc return r;
141*f14fb602SLionel Sambuc }
142*f14fb602SLionel Sambuc
1432639ae9bSBen Gras /*
1442639ae9bSBen Gras * BT_DNPAGE -- Dump the page
1452639ae9bSBen Gras *
1462639ae9bSBen Gras * Parameters:
1472639ae9bSBen Gras * n: page number to dump.
1482639ae9bSBen Gras */
1492639ae9bSBen Gras void
__bt_dnpage(DB * dbp,pgno_t pgno)1502639ae9bSBen Gras __bt_dnpage(DB *dbp, pgno_t pgno)
1512639ae9bSBen Gras {
1522639ae9bSBen Gras BTREE *t;
1532639ae9bSBen Gras PAGE *h;
1542639ae9bSBen Gras
1552639ae9bSBen Gras t = dbp->internal;
1562639ae9bSBen Gras if ((h = mpool_get(t->bt_mp, pgno, 0)) != NULL) {
1572639ae9bSBen Gras __bt_dpage(h);
1582639ae9bSBen Gras (void)mpool_put(t->bt_mp, h, 0);
1592639ae9bSBen Gras }
1602639ae9bSBen Gras }
1612639ae9bSBen Gras
1622639ae9bSBen Gras /*
1632639ae9bSBen Gras * BT_DPAGE -- Dump the page
1642639ae9bSBen Gras *
1652639ae9bSBen Gras * Parameters:
1662639ae9bSBen Gras * h: pointer to the PAGE
1672639ae9bSBen Gras */
1682639ae9bSBen Gras void
__bt_dpage(PAGE * h)1692639ae9bSBen Gras __bt_dpage(PAGE *h)
1702639ae9bSBen Gras {
1712639ae9bSBen Gras BINTERNAL *bi;
1722639ae9bSBen Gras BLEAF *bl;
1732639ae9bSBen Gras RINTERNAL *ri;
1742639ae9bSBen Gras RLEAF *rl;
1752639ae9bSBen Gras indx_t cur, top;
1762639ae9bSBen Gras const char *sep;
1772639ae9bSBen Gras
1782639ae9bSBen Gras (void)fprintf(stderr, " page %d: (", h->pgno);
1792639ae9bSBen Gras #undef X
1802639ae9bSBen Gras #define X(flag, name) \
1812639ae9bSBen Gras if (h->flags & flag) { \
1822639ae9bSBen Gras (void)fprintf(stderr, "%s%s", sep, name); \
1832639ae9bSBen Gras sep = ", "; \
1842639ae9bSBen Gras }
1852639ae9bSBen Gras sep = "";
1862639ae9bSBen Gras X(P_BINTERNAL, "BINTERNAL") /* types */
1872639ae9bSBen Gras X(P_BLEAF, "BLEAF")
1882639ae9bSBen Gras X(P_RINTERNAL, "RINTERNAL") /* types */
1892639ae9bSBen Gras X(P_RLEAF, "RLEAF")
1902639ae9bSBen Gras X(P_OVERFLOW, "OVERFLOW")
1912639ae9bSBen Gras X(P_PRESERVE, "PRESERVE");
1922639ae9bSBen Gras (void)fprintf(stderr, ")\n");
1932639ae9bSBen Gras #undef X
1942639ae9bSBen Gras
1952639ae9bSBen Gras (void)fprintf(stderr, "\tprev %2d next %2d", h->prevpg, h->nextpg);
1962639ae9bSBen Gras if (h->flags & P_OVERFLOW)
1972639ae9bSBen Gras return;
1982639ae9bSBen Gras
1992639ae9bSBen Gras top = NEXTINDEX(h);
2002639ae9bSBen Gras (void)fprintf(stderr, " lower %3d upper %3d nextind %d\n",
2012639ae9bSBen Gras h->lower, h->upper, top);
2022639ae9bSBen Gras for (cur = 0; cur < top; cur++) {
2032639ae9bSBen Gras (void)fprintf(stderr, "\t[%03d] %4d ", cur, h->linp[cur]);
2042639ae9bSBen Gras switch (h->flags & P_TYPE) {
2052639ae9bSBen Gras case P_BINTERNAL:
2062639ae9bSBen Gras bi = GETBINTERNAL(h, cur);
2072639ae9bSBen Gras (void)fprintf(stderr,
2082639ae9bSBen Gras "size %03d pgno %03d", bi->ksize, bi->pgno);
2092639ae9bSBen Gras if (bi->flags & P_BIGKEY)
2102639ae9bSBen Gras (void)fprintf(stderr, " (indirect)");
2112639ae9bSBen Gras else if (bi->ksize)
2122639ae9bSBen Gras (void)fprintf(stderr,
2132639ae9bSBen Gras " {%.*s}", (int)bi->ksize, bi->bytes);
2142639ae9bSBen Gras break;
2152639ae9bSBen Gras case P_RINTERNAL:
2162639ae9bSBen Gras ri = GETRINTERNAL(h, cur);
2172639ae9bSBen Gras (void)fprintf(stderr, "entries %03d pgno %03d",
2182639ae9bSBen Gras ri->nrecs, ri->pgno);
2192639ae9bSBen Gras break;
2202639ae9bSBen Gras case P_BLEAF:
2212639ae9bSBen Gras bl = GETBLEAF(h, cur);
2222639ae9bSBen Gras if (bl->flags & P_BIGKEY)
2232639ae9bSBen Gras (void)fprintf(stderr,
2242639ae9bSBen Gras "big key page %lu size %u/",
225*f14fb602SLionel Sambuc (unsigned long) __bt_pgno_t(bl->bytes),
226*f14fb602SLionel Sambuc __bt_uint32_t(bl->bytes + sizeof(pgno_t)));
2272639ae9bSBen Gras else if (bl->ksize)
2282639ae9bSBen Gras (void)fprintf(stderr, "%s/", bl->bytes);
2292639ae9bSBen Gras if (bl->flags & P_BIGDATA)
2302639ae9bSBen Gras (void)fprintf(stderr,
2312639ae9bSBen Gras "big data page %lu size %u",
232*f14fb602SLionel Sambuc (unsigned long)
233*f14fb602SLionel Sambuc __bt_pgno_t(bl->bytes + bl->ksize),
234*f14fb602SLionel Sambuc __bt_uint32_t(bl->bytes + bl->ksize +
2352639ae9bSBen Gras sizeof(pgno_t)));
2362639ae9bSBen Gras else if (bl->dsize)
2372639ae9bSBen Gras (void)fprintf(stderr, "%.*s",
2382639ae9bSBen Gras (int)bl->dsize, bl->bytes + bl->ksize);
2392639ae9bSBen Gras break;
2402639ae9bSBen Gras case P_RLEAF:
2412639ae9bSBen Gras rl = GETRLEAF(h, cur);
2422639ae9bSBen Gras if (rl->flags & P_BIGDATA)
2432639ae9bSBen Gras (void)fprintf(stderr,
2442639ae9bSBen Gras "big data page %lu size %u",
245*f14fb602SLionel Sambuc (unsigned long) __bt_pgno_t(rl->bytes),
246*f14fb602SLionel Sambuc __bt_uint32_t(rl->bytes + sizeof(pgno_t)));
2472639ae9bSBen Gras else if (rl->dsize)
2482639ae9bSBen Gras (void)fprintf(stderr,
2492639ae9bSBen Gras "%.*s", (int)rl->dsize, rl->bytes);
2502639ae9bSBen Gras break;
2512639ae9bSBen Gras }
2522639ae9bSBen Gras (void)fprintf(stderr, "\n");
2532639ae9bSBen Gras }
2542639ae9bSBen Gras }
2552639ae9bSBen Gras #endif
2562639ae9bSBen Gras
2572639ae9bSBen Gras #ifdef STATISTICS
2582639ae9bSBen Gras /*
2592639ae9bSBen Gras * BT_STAT -- Gather/print the tree statistics
2602639ae9bSBen Gras *
2612639ae9bSBen Gras * Parameters:
2622639ae9bSBen Gras * dbp: pointer to the DB
2632639ae9bSBen Gras */
2642639ae9bSBen Gras void
__bt_stat(DB * dbp)2652639ae9bSBen Gras __bt_stat(DB *dbp)
2662639ae9bSBen Gras {
2672639ae9bSBen Gras extern unsigned long bt_cache_hit, bt_cache_miss, bt_pfxsaved, bt_rootsplit;
2682639ae9bSBen Gras extern unsigned long bt_sortsplit, bt_split;
2692639ae9bSBen Gras BTREE *t;
2702639ae9bSBen Gras PAGE *h;
2712639ae9bSBen Gras pgno_t i, pcont, pinternal, pleaf;
2722639ae9bSBen Gras unsigned long ifree, lfree, nkeys;
2732639ae9bSBen Gras int levels;
2742639ae9bSBen Gras
2752639ae9bSBen Gras t = dbp->internal;
2762639ae9bSBen Gras pcont = pinternal = pleaf = 0;
2772639ae9bSBen Gras nkeys = ifree = lfree = 0;
2782639ae9bSBen Gras for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
2792639ae9bSBen Gras switch (h->flags & P_TYPE) {
2802639ae9bSBen Gras case P_BINTERNAL:
2812639ae9bSBen Gras case P_RINTERNAL:
2822639ae9bSBen Gras ++pinternal;
2832639ae9bSBen Gras ifree += h->upper - h->lower;
2842639ae9bSBen Gras break;
2852639ae9bSBen Gras case P_BLEAF:
2862639ae9bSBen Gras case P_RLEAF:
2872639ae9bSBen Gras ++pleaf;
2882639ae9bSBen Gras lfree += h->upper - h->lower;
2892639ae9bSBen Gras nkeys += NEXTINDEX(h);
2902639ae9bSBen Gras break;
2912639ae9bSBen Gras case P_OVERFLOW:
2922639ae9bSBen Gras ++pcont;
2932639ae9bSBen Gras break;
2942639ae9bSBen Gras }
2952639ae9bSBen Gras (void)mpool_put(t->bt_mp, h, 0);
2962639ae9bSBen Gras }
2972639ae9bSBen Gras
2982639ae9bSBen Gras /* Count the levels of the tree. */
2992639ae9bSBen Gras for (i = P_ROOT, levels = 0 ;; ++levels) {
3002639ae9bSBen Gras h = mpool_get(t->bt_mp, i, 0);
3012639ae9bSBen Gras if (h->flags & (P_BLEAF|P_RLEAF)) {
3022639ae9bSBen Gras if (levels == 0)
3032639ae9bSBen Gras levels = 1;
3042639ae9bSBen Gras (void)mpool_put(t->bt_mp, h, 0);
3052639ae9bSBen Gras break;
3062639ae9bSBen Gras }
3072639ae9bSBen Gras i = F_ISSET(t, R_RECNO) ?
3082639ae9bSBen Gras GETRINTERNAL(h, 0)->pgno :
3092639ae9bSBen Gras GETBINTERNAL(h, 0)->pgno;
3102639ae9bSBen Gras (void)mpool_put(t->bt_mp, h, 0);
3112639ae9bSBen Gras }
3122639ae9bSBen Gras
3132639ae9bSBen Gras (void)fprintf(stderr, "%d level%s with %ld keys",
3142639ae9bSBen Gras levels, levels == 1 ? "" : "s", nkeys);
3152639ae9bSBen Gras if (F_ISSET(t, R_RECNO))
3162639ae9bSBen Gras (void)fprintf(stderr, " (%ld header count)", (long)t->bt_nrecs);
3172639ae9bSBen Gras (void)fprintf(stderr,
3182639ae9bSBen Gras "\n%lu pages (leaf %ld, internal %ld, overflow %ld)\n",
3192639ae9bSBen Gras (long)pinternal + pleaf + pcont, (long)pleaf, (long)pinternal,
3202639ae9bSBen Gras (long)pcont);
3212639ae9bSBen Gras (void)fprintf(stderr, "%ld cache hits, %ld cache misses\n",
3222639ae9bSBen Gras bt_cache_hit, bt_cache_miss);
3232639ae9bSBen Gras (void)fprintf(stderr, "%ld splits (%ld root splits, %ld sort splits)\n",
3242639ae9bSBen Gras bt_split, bt_rootsplit, bt_sortsplit);
3252639ae9bSBen Gras pleaf *= t->bt_psize - BTDATAOFF;
3262639ae9bSBen Gras if (pleaf)
3272639ae9bSBen Gras (void)fprintf(stderr,
3282639ae9bSBen Gras "%.0f%% leaf fill (%ld bytes used, %ld bytes free)\n",
3292639ae9bSBen Gras ((double)(pleaf - lfree) / pleaf) * 100,
3302639ae9bSBen Gras pleaf - lfree, lfree);
3312639ae9bSBen Gras pinternal *= t->bt_psize - BTDATAOFF;
3322639ae9bSBen Gras if (pinternal)
3332639ae9bSBen Gras (void)fprintf(stderr,
3342639ae9bSBen Gras "%.0f%% internal fill (%ld bytes used, %ld bytes free\n",
3352639ae9bSBen Gras ((double)(pinternal - ifree) / pinternal) * 100,
3362639ae9bSBen Gras pinternal - ifree, ifree);
3372639ae9bSBen Gras if (bt_pfxsaved)
3382639ae9bSBen Gras (void)fprintf(stderr, "prefix checking removed %lu bytes.\n",
3392639ae9bSBen Gras bt_pfxsaved);
3402639ae9bSBen Gras }
3412639ae9bSBen Gras #endif
342