150990Sbostic /*-
261194Sbostic * Copyright (c) 1990, 1993
361194Sbostic * The Regents of the University of California. All rights reserved.
450990Sbostic *
550990Sbostic * This code is derived from software contributed to Berkeley by
650990Sbostic * Mike Olson.
750990Sbostic *
850990Sbostic * %sccs.include.redist.c%
950990Sbostic */
1050990Sbostic
1150990Sbostic #if defined(LIBC_SCCS) && !defined(lint)
12*66192Sbostic static char sccsid[] = "@(#)bt_debug.c 8.2 (Berkeley) 02/21/94";
1350990Sbostic #endif /* LIBC_SCCS and not lint */
1450990Sbostic
1550990Sbostic #include <sys/param.h>
1656739Sbostic
1750990Sbostic #include <stdio.h>
1850990Sbostic #include <stdlib.h>
1950990Sbostic #include <string.h>
2056739Sbostic
2157932Sbostic #include <db.h>
2250990Sbostic #include "btree.h"
2350990Sbostic
2450990Sbostic #ifdef DEBUG
2550990Sbostic /*
2650990Sbostic * BT_DUMP -- Dump the tree
2750990Sbostic *
2850990Sbostic * Parameters:
2950990Sbostic * dbp: pointer to the DB
3050990Sbostic */
3150990Sbostic void
__bt_dump(dbp)3250990Sbostic __bt_dump(dbp)
3350990Sbostic DB *dbp;
3450990Sbostic {
3550990Sbostic BTREE *t;
3650990Sbostic PAGE *h;
3750990Sbostic pgno_t i;
3850990Sbostic char *sep;
3950990Sbostic
4050990Sbostic t = dbp->internal;
4151102Sbostic (void)fprintf(stderr, "%s: pgsz %d",
4260049Sbostic ISSET(t, B_INMEM) ? "memory" : "disk", t->bt_psize);
4360049Sbostic if (ISSET(t, R_RECNO))
4450990Sbostic (void)fprintf(stderr, " keys %lu", t->bt_nrecs);
4551102Sbostic #undef X
4650990Sbostic #define X(flag, name) \
4750990Sbostic if (ISSET(t, flag)) { \
4850990Sbostic (void)fprintf(stderr, "%s%s", sep, name); \
4950990Sbostic sep = ", "; \
5050990Sbostic }
5150990Sbostic if (t->bt_flags) {
5250990Sbostic sep = " flags (";
5360049Sbostic X(B_DELCRSR, "DELCRSR");
5460049Sbostic X(R_FIXLEN, "FIXLEN");
5560049Sbostic X(B_INMEM, "INMEM");
5660049Sbostic X(B_NODUPS, "NODUPS");
5760049Sbostic X(B_RDONLY, "RDONLY");
5860049Sbostic X(R_RECNO, "RECNO");
5960049Sbostic X(B_SEQINIT, "SEQINIT");
6060049Sbostic X(B_METADIRTY,"METADIRTY");
6150990Sbostic (void)fprintf(stderr, ")\n");
6250990Sbostic }
6350990Sbostic #undef X
6450990Sbostic
6550990Sbostic for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
6650990Sbostic __bt_dpage(h);
6750990Sbostic (void)mpool_put(t->bt_mp, h, 0);
6850990Sbostic }
6950990Sbostic }
7050990Sbostic
7150990Sbostic /*
7251102Sbostic * BT_DMPAGE -- Dump the meta page
7351102Sbostic *
7451102Sbostic * Parameters:
7551102Sbostic * h: pointer to the PAGE
7651102Sbostic */
7751102Sbostic void
__bt_dmpage(h)7851102Sbostic __bt_dmpage(h)
7951102Sbostic PAGE *h;
8051102Sbostic {
8151102Sbostic BTMETA *m;
8251102Sbostic char *sep;
8351102Sbostic
8451102Sbostic m = (BTMETA *)h;
8551102Sbostic (void)fprintf(stderr, "magic %lx\n", m->m_magic);
8651102Sbostic (void)fprintf(stderr, "version %lu\n", m->m_version);
8751102Sbostic (void)fprintf(stderr, "psize %lu\n", m->m_psize);
8851102Sbostic (void)fprintf(stderr, "free %lu\n", m->m_free);
8951102Sbostic (void)fprintf(stderr, "nrecs %lu\n", m->m_nrecs);
9051102Sbostic (void)fprintf(stderr, "flags %lu", m->m_flags);
9151102Sbostic #undef X
9251102Sbostic #define X(flag, name) \
9351102Sbostic if (m->m_flags & flag) { \
9451102Sbostic (void)fprintf(stderr, "%s%s", sep, name); \
9551102Sbostic sep = ", "; \
9651102Sbostic }
9751102Sbostic if (m->m_flags) {
9851102Sbostic sep = " (";
9960049Sbostic X(B_NODUPS, "NODUPS");
10060049Sbostic X(R_RECNO, "RECNO");
10151102Sbostic (void)fprintf(stderr, ")");
10251102Sbostic }
10351102Sbostic }
10451102Sbostic
10551102Sbostic /*
10656994Sbostic * BT_DNPAGE -- Dump the page
10756994Sbostic *
10856994Sbostic * Parameters:
10956994Sbostic * n: page number to dump.
11056994Sbostic */
11156994Sbostic void
__bt_dnpage(dbp,pgno)11256994Sbostic __bt_dnpage(dbp, pgno)
11356994Sbostic DB *dbp;
11456994Sbostic pgno_t pgno;
11556994Sbostic {
11656994Sbostic BTREE *t;
11756994Sbostic PAGE *h;
11856994Sbostic
11956994Sbostic t = dbp->internal;
12056994Sbostic if ((h = mpool_get(t->bt_mp, pgno, 0)) != NULL) {
12156994Sbostic __bt_dpage(h);
12256994Sbostic (void)mpool_put(t->bt_mp, h, 0);
12356994Sbostic }
12456994Sbostic }
12556994Sbostic
12656994Sbostic /*
12750990Sbostic * BT_DPAGE -- Dump the page
12850990Sbostic *
12950990Sbostic * Parameters:
13050990Sbostic * h: pointer to the PAGE
13150990Sbostic */
13250990Sbostic void
__bt_dpage(h)13350990Sbostic __bt_dpage(h)
13450990Sbostic PAGE *h;
13550990Sbostic {
13650990Sbostic BINTERNAL *bi;
13750990Sbostic BLEAF *bl;
13850990Sbostic RINTERNAL *ri;
13950990Sbostic RLEAF *rl;
14057989Sbostic indx_t cur, top;
14150990Sbostic char *sep;
14250990Sbostic
14350990Sbostic (void)fprintf(stderr, " page %d: (", h->pgno);
14451102Sbostic #undef X
14550990Sbostic #define X(flag, name) \
14650990Sbostic if (h->flags & flag) { \
14750990Sbostic (void)fprintf(stderr, "%s%s", sep, name); \
14850990Sbostic sep = ", "; \
14950990Sbostic }
15050990Sbostic sep = "";
15150990Sbostic X(P_BINTERNAL, "BINTERNAL") /* types */
15250990Sbostic X(P_BLEAF, "BLEAF")
15350990Sbostic X(P_RINTERNAL, "RINTERNAL") /* types */
15450990Sbostic X(P_RLEAF, "RLEAF")
15550990Sbostic X(P_OVERFLOW, "OVERFLOW")
15650990Sbostic X(P_PRESERVE, "PRESERVE");
15750990Sbostic (void)fprintf(stderr, ")\n");
15850990Sbostic #undef X
15950990Sbostic
16050990Sbostic (void)fprintf(stderr, "\tprev %2d next %2d", h->prevpg, h->nextpg);
16150990Sbostic if (h->flags & P_OVERFLOW)
16250990Sbostic return;
16350990Sbostic
16450990Sbostic top = NEXTINDEX(h);
16550990Sbostic (void)fprintf(stderr, " lower %3d upper %3d nextind %d\n",
16650990Sbostic h->lower, h->upper, top);
16750990Sbostic for (cur = 0; cur < top; cur++) {
16850990Sbostic (void)fprintf(stderr, "\t[%03d] %4d ", cur, h->linp[cur]);
16950990Sbostic switch(h->flags & P_TYPE) {
17050990Sbostic case P_BINTERNAL:
17150990Sbostic bi = GETBINTERNAL(h, cur);
17250990Sbostic (void)fprintf(stderr,
17357446Sbostic "size %03d pgno %03d", bi->ksize, bi->pgno);
17450990Sbostic if (bi->flags & P_BIGKEY)
17550990Sbostic (void)fprintf(stderr, " (indirect)");
17650990Sbostic else if (bi->ksize)
17757446Sbostic (void)fprintf(stderr,
17860049Sbostic " {%.*s}", (int)bi->ksize, bi->bytes);
17950990Sbostic break;
18050990Sbostic case P_RINTERNAL:
18150990Sbostic ri = GETRINTERNAL(h, cur);
18257446Sbostic (void)fprintf(stderr, "entries %03d pgno %03d",
18350990Sbostic ri->nrecs, ri->pgno);
18450990Sbostic break;
18550990Sbostic case P_BLEAF:
18650990Sbostic bl = GETBLEAF(h, cur);
18750990Sbostic if (bl->flags & P_BIGKEY)
18850990Sbostic (void)fprintf(stderr,
18950990Sbostic "big key page %lu size %u/",
19050990Sbostic *(pgno_t *)bl->bytes,
19150990Sbostic *(size_t *)(bl->bytes + sizeof(pgno_t)));
19250990Sbostic else if (bl->ksize)
19350990Sbostic (void)fprintf(stderr, "%s/", bl->bytes);
19450990Sbostic if (bl->flags & P_BIGDATA)
19550990Sbostic (void)fprintf(stderr,
19650990Sbostic "big data page %lu size %u",
19750990Sbostic *(pgno_t *)(bl->bytes + bl->ksize),
19850990Sbostic *(size_t *)(bl->bytes + bl->ksize +
19950990Sbostic sizeof(pgno_t)));
20050990Sbostic else if (bl->dsize)
20160049Sbostic (void)fprintf(stderr, "%.*s",
20260049Sbostic (int)bl->dsize, bl->bytes + bl->ksize);
20350990Sbostic break;
20450990Sbostic case P_RLEAF:
20550990Sbostic rl = GETRLEAF(h, cur);
20650990Sbostic if (rl->flags & P_BIGDATA)
20750990Sbostic (void)fprintf(stderr,
20850990Sbostic "big data page %lu size %u",
20950990Sbostic *(pgno_t *)rl->bytes,
21050990Sbostic *(size_t *)(rl->bytes + sizeof(pgno_t)));
21150990Sbostic else if (rl->dsize)
21257446Sbostic (void)fprintf(stderr,
21360049Sbostic "%.*s", (int)rl->dsize, rl->bytes);
21450990Sbostic break;
21550990Sbostic }
21650990Sbostic (void)fprintf(stderr, "\n");
21750990Sbostic }
21850990Sbostic }
21950990Sbostic #endif
22050990Sbostic
22150990Sbostic #ifdef STATISTICS
22250990Sbostic /*
22350990Sbostic * BT_STAT -- Gather/print the tree statistics
22450990Sbostic *
22550990Sbostic * Parameters:
22650990Sbostic * dbp: pointer to the DB
22750990Sbostic */
22850990Sbostic void
__bt_stat(dbp)22950990Sbostic __bt_stat(dbp)
23050990Sbostic DB *dbp;
23150990Sbostic {
232*66192Sbostic extern u_long bt_cache_hit, bt_cache_miss, bt_pfxsaved, bt_rootsplit;
233*66192Sbostic extern u_long bt_sortsplit, bt_split;
23450990Sbostic BTREE *t;
23550990Sbostic PAGE *h;
23650990Sbostic pgno_t i, pcont, pinternal, pleaf;
23750990Sbostic u_long ifree, lfree, nkeys;
23850990Sbostic int levels;
23950990Sbostic
24050990Sbostic t = dbp->internal;
24150990Sbostic pcont = pinternal = pleaf = 0;
24250990Sbostic nkeys = ifree = lfree = 0;
24350990Sbostic for (i = P_ROOT; (h = mpool_get(t->bt_mp, i, 0)) != NULL; ++i) {
24450990Sbostic switch(h->flags & P_TYPE) {
24550990Sbostic case P_BINTERNAL:
24650990Sbostic case P_RINTERNAL:
24750990Sbostic ++pinternal;
24850990Sbostic ifree += h->upper - h->lower;
24950990Sbostic break;
25050990Sbostic case P_BLEAF:
25150990Sbostic case P_RLEAF:
25250990Sbostic ++pleaf;
25350990Sbostic lfree += h->upper - h->lower;
25450990Sbostic nkeys += NEXTINDEX(h);
25550990Sbostic break;
25650990Sbostic case P_OVERFLOW:
25750990Sbostic ++pcont;
25850990Sbostic break;
25950990Sbostic }
26050990Sbostic (void)mpool_put(t->bt_mp, h, 0);
26150990Sbostic }
26250990Sbostic
26350990Sbostic /* Count the levels of the tree. */
26450990Sbostic for (i = P_ROOT, levels = 0 ;; ++levels) {
26550990Sbostic h = mpool_get(t->bt_mp, i, 0);
26650990Sbostic if (h->flags & (P_BLEAF|P_RLEAF)) {
26750990Sbostic if (levels == 0)
26850990Sbostic levels = 1;
26950990Sbostic (void)mpool_put(t->bt_mp, h, 0);
27050990Sbostic break;
27150990Sbostic }
27260049Sbostic i = ISSET(t, R_RECNO) ?
27350990Sbostic GETRINTERNAL(h, 0)->pgno :
27450990Sbostic GETBINTERNAL(h, 0)->pgno;
27550990Sbostic (void)mpool_put(t->bt_mp, h, 0);
27650990Sbostic }
27750990Sbostic
27850990Sbostic (void)fprintf(stderr, "%d level%s with %ld keys",
27950990Sbostic levels, levels == 1 ? "" : "s", nkeys);
28060049Sbostic if (ISSET(t, R_RECNO))
28150990Sbostic (void)fprintf(stderr, " (%ld header count)", t->bt_nrecs);
28250990Sbostic (void)fprintf(stderr,
28350990Sbostic "\n%lu pages (leaf %ld, internal %ld, overflow %ld)\n",
28450990Sbostic pinternal + pleaf + pcont, pleaf, pinternal, pcont);
28550990Sbostic (void)fprintf(stderr, "%ld cache hits, %ld cache misses\n",
28650990Sbostic bt_cache_hit, bt_cache_miss);
28750990Sbostic (void)fprintf(stderr, "%ld splits (%ld root splits, %ld sort splits)\n",
28850990Sbostic bt_split, bt_rootsplit, bt_sortsplit);
28950990Sbostic pleaf *= t->bt_psize - BTDATAOFF;
29050990Sbostic if (pleaf)
29150990Sbostic (void)fprintf(stderr,
29250990Sbostic "%.0f%% leaf fill (%ld bytes used, %ld bytes free)\n",
29350990Sbostic ((double)(pleaf - lfree) / pleaf) * 100,
29450990Sbostic pleaf - lfree, lfree);
29550990Sbostic pinternal *= t->bt_psize - BTDATAOFF;
29650990Sbostic if (pinternal)
29750990Sbostic (void)fprintf(stderr,
29850990Sbostic "%.0f%% internal fill (%ld bytes used, %ld bytes free\n",
29950990Sbostic ((double)(pinternal - ifree) / pinternal) * 100,
30050990Sbostic pinternal - ifree, ifree);
30150990Sbostic if (bt_pfxsaved)
30250990Sbostic (void)fprintf(stderr, "prefix checking removed %lu bytes.\n",
30350990Sbostic bt_pfxsaved);
30450990Sbostic }
30550990Sbostic #endif
306