On Thu, 20 Jan 2005, Jim wrote:
On Sat, 15 Jan 2005, Neal Richter wrote:
Question #1)
Could you download a fresh copy of BDB 3.0.55 from http://www.sleepycat.com/download/index.shtml
It's easy to build, I am most interested in the results when you run db_stat on the uncompressed files and report back the fill-factor. This is a measure of wasted space in the BDB pages. This won't work on the compressed index.
How exactly do I obtain this information? In the entire package I see only one place that references fill-factor (diskspace.html) and all it says is that you can obtain it with db_stat. However I don't see anything called fill-factor in the db_stat output. What options are needed to extract this info? Or is it a value that needs to be computed from other output?
Jim: The 'xx% ff' below is the 'fill factor'
db_stat -d db.words.db 53162 Btree magic number. 7 Btree version number. Flags: 2 Minimum keys per-page. 1024 Underlying database page size. 4 Number of levels in the tree. 170348 Number of keys in the tree. 328 Number of tree internal pages. 109792 Number of bytes free in tree internal pages (67% ff). 7019 Number of tree leaf pages. 2541354 Number of bytes free in tree leaf pages (65% ff). 0 Number of tree duplicate pages. 0 Number of bytes free in tree duplicate pages (0% ff). 0 Number of tree overflow pages. 0 Number of bytes free in tree overflow pages (0% ff). 0 Number of pages on the free list.
Thanks
--
Neal Richter Knowledgebase Developer
RightNow Technologies, Inc.
Customer Service for Every Web Site
Office: 406-522-1485
------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ ht://Dig Developer mailing list: htdig-dev@lists.sourceforge.net List information (subscribe/unsubscribe, etc.) https://lists.sourceforge.net/lists/listinfo/htdig-dev
