Details
-
Improvement
-
Resolution: Done
-
Minor - P4
-
None
-
2.8.0-rc2
-
Fully Compatible
Description
Running db.collection.validate(
{full:true}) for 2.8 mmapv1 gives empty "indexDetails" stats in the resulting document while for 2.8 WT, it gives the non-empty results for "indexDetails" stats.
- In 2.8 WT:
> db.foo.validate({full:true}){"ns" : "test.foo","nrecords" : 10000,"wiredTiger" : {"uri" : "statistics:table:collection-2-632245492128970716","LSM" : {"bloom filters in the LSM tree" : 0,"bloom filter false positives" : 0,"bloom filter hits" : 0,"bloom filter misses" : 0,"bloom filter pages evicted from cache" : 0,"bloom filter pages read into cache" : 0,"total size of bloom filters" : 0,"sleep for LSM checkpoint throttle" : 0,"chunks in the LSM tree" : 0,"highest merge generation in the LSM tree" : 0,"queries that could have benefited from a Bloom filter that did not exist" : 0,"sleep for LSM merge throttle" : 0},"block-manager" : {"file allocation unit size" : 4096,"blocks allocated" : 9,"checkpoint size" : 32768,"allocations requiring file extension" : 6,"blocks freed" : 3,"file magic number" : 120897,"file major version number" : 1,"minor version number" : 0,"file bytes available for reuse" : 16384,"file size in bytes" : 61440},"btree" : {"column-store variable-size deleted values" : 0,"column-store fixed-size leaf pages" : 0,"column-store internal pages" : 0,"column-store variable-size leaf pages" : 0,"pages rewritten by compaction" : 0,"number of key/value pairs" : 0,"fixed-record size" : 0,"maximum tree depth" : 3,"maximum internal page item size" : 384,"maximum internal page size" : 4096,"maximum leaf page item size" : 3072,"maximum leaf page size" : 32768,"overflow pages" : 0,"row-store internal pages" : 0,"row-store leaf pages" : 0},"cache" : {"bytes read into cache" : 0,"bytes written from cache" : 46021,"checkpoint blocked page eviction" : 0,"unmodified pages evicted" : 0,"modified pages evicted" : 0,"data source pages selected for eviction unable to be evicted" : 0,"hazard pointer blocked page eviction" : 0,"internal pages evicted" : 0,"in-memory page splits" : 0,"overflow values cached in memory" : 0,"pages read into cache" : 0,"overflow pages read into cache" : 0,"pages written from cache" : 7},"compression" : {"raw compression call failed, no additional data available" : 0,"raw compression call failed, additional data available" : 0,"raw compression call succeeded" : 0,"compressed pages read" : 0,"compressed pages written" : 6,"page written failed to compress" : 0,"page written was too small to compress" : 1},"cursor" : {"create calls" : 3,"insert calls" : 10000,"bulk-loaded cursor-insert calls" : 0,"cursor-insert key and value bytes inserted" : 351426,"next calls" : 10001,"prev calls" : 1,"remove calls" : 0,"cursor-remove key bytes removed" : 0,"reset calls" : 20001,"search calls" : 10000,"search near calls" : 0,"update calls" : 0,"cursor-update value bytes updated" : 0},"reconciliation" : {"dictionary matches" : 0,"internal page multi-block writes" : 0,"leaf page multi-block writes" : 2,"maximum blocks required for a page" : 3,"internal-page overflow keys" : 0,"leaf-page overflow keys" : 0,"overflow values written" : 0,"pages deleted" : 0,"page checksum matches" : 0,"page reconciliation calls" : 3,"page reconciliation calls for eviction" : 0,"leaf page key bytes discarded using prefix compression" : 0,"internal page key bytes discarded using suffix compression" : 4},"session" : {"object compaction" : 0,"open cursor count" : 3},"transaction" : {"update conflicts" : 0}},"nIndexes" : 1,"keysPerIndex" : {"test.foo.$_id_" : 10000},"indexDetails" : {"test.foo.$_id_" : {"uri" : "statistics:table:index-3-632245492128970716","LSM" : {"bloom filters in the LSM tree" : 0,"bloom filter false positives" : 0,"bloom filter hits" : 0,"bloom filter misses" : 0,"bloom filter pages evicted from cache" : 0,"bloom filter pages read into cache" : 0,"total size of bloom filters" : 0,"sleep for LSM checkpoint throttle" : 0,"chunks in the LSM tree" : 0,"highest merge generation in the LSM tree" : 0,"queries that could have benefited from a Bloom filter that did not exist" : 0,"sleep for LSM merge throttle" : 0},"block-manager" : {"file allocation unit size" : 4096,"blocks allocated" : 8,"checkpoint size" : 32768,"allocations requiring file extension" : 5,"blocks freed" : 2,"file magic number" : 120897,"file major version number" : 1,"minor version number" : 0,"file bytes available for reuse" : 12288,"file size in bytes" : 57344},"btree" : {"column-store variable-size deleted values" : 0,"column-store fixed-size leaf pages" : 0,"column-store internal pages" : 0,"column-store variable-size leaf pages" : 0,"pages rewritten by compaction" : 0,"number of key/value pairs" : 0,"fixed-record size" : 0,"maximum tree depth" : 3,"maximum internal page item size" : 384,"maximum internal page size" : 4096,"maximum leaf page item size" : 1536,"maximum leaf page size" : 16384,"overflow pages" : 0,"row-store internal pages" : 0,"row-store leaf pages" : 0},"cache" : {"bytes read into cache" : 0,"bytes written from cache" : 49474,"checkpoint blocked page eviction" : 0,"unmodified pages evicted" : 0,"modified pages evicted" : 0,"data source pages selected for eviction unable to be evicted" : 0,"hazard pointer blocked page eviction" : 0,"internal pages evicted" : 0,"in-memory page splits" : 0,"overflow values cached in memory" : 0,"pages read into cache" : 0,"overflow pages read into cache" : 0,"pages written from cache" : 6},"compression" : {"raw compression call failed, no additional data available" : 0,"raw compression call failed, additional data available" : 0,"raw compression call succeeded" : 0,"compressed pages read" : 0,"compressed pages written" : 0,"page written failed to compress" : 0,"page written was too small to compress" : 0},"cursor" : {"create calls" : 2,"insert calls" : 10000,"bulk-loaded cursor-insert calls" : 0,"cursor-insert key and value bytes inserted" : 270000,"next calls" : 10000,"prev calls" : 0,"remove calls" : 0,"cursor-remove key bytes removed" : 0,"reset calls" : 10000,"search calls" : 0,"search near calls" : 1,"update calls" : 0,"cursor-update value bytes updated" : 0},"reconciliation" : {"dictionary matches" : 0,"internal page multi-block writes" : 0,"leaf page multi-block writes" : 2,"maximum blocks required for a page" : 2,"internal-page overflow keys" : 0,"leaf-page overflow keys" : 0,"overflow values written" : 0,"pages deleted" : 0,"page checksum matches" : 0,"page reconciliation calls" : 3,"page reconciliation calls for eviction" : 0,"leaf page key bytes discarded using prefix compression" : 64043,"internal page key bytes discarded using suffix compression" : 0},"session" : {"object compaction" : 0,"open cursor count" : 2},"transaction" : {"update conflicts" : 0}}},"valid" : true,"errors" : [ ],"ok" : 1}
- In 2.8 mmapv1:
{"ns" : "test.foo","datasize" : 4800080,"nrecords" : 100000,"lastExtentSize" : 8388608,"firstExtent" : "0:6000 ns:test.foo","lastExtent" : "0:550000 ns:test.foo","extentCount" : 6,"extents" : [{"loc" : "0:6000","xnext" : "0:28000","xprev" : "null","nsdiag" : "test.foo","size" : 8192,"firstRecord" : "0:60b0","lastRecord" : "0:7fb0"},{"loc" : "0:28000","xnext" : "0:30000","xprev" : "0:6000","nsdiag" : "test.foo","size" : 32768,"firstRecord" : "0:280b0","lastRecord" : "0:2ffb0"},{"loc" : "0:30000","xnext" : "0:50000","xprev" : "0:28000","nsdiag" : "test.foo","size" : 131072,"firstRecord" : "0:300b0","lastRecord" : "0:4ffb0"},{"loc" : "0:50000","xnext" : "0:150000","xprev" : "0:30000","nsdiag" : "test.foo","size" : 524288,"firstRecord" : "0:500b0","lastRecord" : "0:cffb0"},{"loc" : "0:150000","xnext" : "0:550000","xprev" : "0:50000","nsdiag" : "test.foo","size" : 2097152,"firstRecord" : "0:1500b0","lastRecord" : "0:34ffb0"},{"loc" : "0:550000","xnext" : "null","xprev" : "0:150000","nsdiag" : "test.foo","size" : 8388608,"firstRecord" : "0:5500b0","lastRecord" : "0:8c0c30"}],"firstExtentDetails" : {"loc" : "0:6000","xnext" : "0:28000","xprev" : "null","nsdiag" : "test.foo","size" : 8192,"firstRecord" : "0:60b0","lastRecord" : "0:7fb0"},"lastExtentDetails" : {"loc" : "0:550000","xnext" : "null","xprev" : "0:150000","nsdiag" : "test.foo","size" : 8388608,"firstRecord" : "0:5500b0","lastRecord" : "0:8c0c30"},"objectsFound" : 100000,"invalidObjects" : 0,"nQuantizedSize" : 99995,"bytesWithHeaders" : 6400080,"bytesWithoutHeaders" : 4800080,"bytesBson" : 3300000,"deletedCount" : 1,"deletedSize" : 4780944,"delBucketSizes" : [0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0],"nIndexes" : 1,"keysPerIndex" : {"test.foo.$_id_" : 100000},"indexDetails" : {"test.foo.$_id_" : {}},"valid" : true,"errors" : [ ],"ok" : 1}