Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-1703

Overflow statistic inaccurate

    • Type: Icon: Task Task
    • Resolution: Done
    • None
    • Affects Version/s: None
    • Component/s: None

      I've created a row store with overflow records and statistics are reporting that we don't have overflow items. A script to generate the table and gather statistics follows.

      cd build_posix
      ../configure > /dev/null && make -j 12 > /dev/null
      
      DBDIR=./WT_TEST
      WT=./wt
      
      rm -rf $DBDIR
      mkdir -p $DBDIR
      
      $WT -h $DBDIR create  -c "key_format=S,value_format=S,internal_page_max=4KB,leaf_page_max=4KB" table:test
      
      value=`seq -s ' ' 1 10000`
      $WT -h $DBDIR write table:test fill_2__b_27 "$value"
      $WT -h $DBDIR write table:test fill_2__b_28 "$value"
      echo "Reporting table statistics for overflow items"
      $WT -h $DBDIR stat table:test | grep overflow
      echo "Reporting overflow information from block dump"
      $WT -h $DBDIR verify -d dump_blocks table:test | grep ovf
      

      Generates the following:

      Reporting table statistics for overflow items
      btree: overflow pages=0
      cache: overflow values cached in memory=0
      cache: overflow pages read into cache=0
      reconciliation: internal-page overflow keys=0
      reconciliation: leaf-page overflow keys=0
      reconciliation: overflow values written=0
      Reporting overflow information from block dump
      	value/ovfl: len 7, ovfl [4096-53248, 49152, 2123498883]
      	value/ovfl: len 7, ovfl [65536-114688, 49152, 1832075221]
      

            Assignee:
            Unassigned Unassigned
            Reporter:
            alexander.gorrod@mongodb.com Alexander Gorrod
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: