Thursday 8 July 2021

ArangoDB: Get storage engine statistics

'db._engineStats()' method return the statistics related to storage engine.

127.0.0.1:8529@_system> db._engineStats()
{ 
  "rocksdb.num-files-at-level0" : 0, 
  "rocksdb.compression-ratio-at-level0" : 0, 
  "rocksdb.num-files-at-level1" : 0, 
  "rocksdb.compression-ratio-at-level1" : 0, 
  "rocksdb.num-files-at-level2" : 0, 
  "rocksdb.compression-ratio-at-level2" : 0, 
  "rocksdb.num-files-at-level3" : 0, 
  "rocksdb.compression-ratio-at-level3" : 0, 
  "rocksdb.num-files-at-level4" : 0, 
  "rocksdb.compression-ratio-at-level4" : 0, 
  "rocksdb.num-files-at-level5" : 0, 
  "rocksdb.compression-ratio-at-level5" : 0, 
  "rocksdb.num-files-at-level6" : 4, 
  "rocksdb.compression-ratio-at-level6" : 2, 
  "rocksdb.num-immutable-mem-table" : 0, 
  "rocksdb.num-immutable-mem-table-flushed" : 4, 
  "rocksdb.mem-table-flush-pending" : 0, 
  "rocksdb.compaction-pending" : 0, 
  "rocksdb.background-errors" : 0, 
  "rocksdb.cur-size-active-mem-table" : 101912568, 
  "rocksdb.cur-size-all-mem-tables" : 101912568, 
  "rocksdb.size-all-mem-tables" : 210383048, 
  "rocksdb.num-entries-active-mem-table" : 2261, 
  "rocksdb.num-entries-imm-mem-tables" : 0, 
  "rocksdb.num-deletes-active-mem-table" : 154, 
  "rocksdb.num-deletes-imm-mem-tables" : 0, 
  "rocksdb.estimate-num-keys" : 4138, 
  "rocksdb.estimate-table-readers-mem" : 7721, 
  "rocksdb.num-snapshots" : 0, 
  "rocksdb.oldest-snapshot-time" : 0, 
  "rocksdb.num-live-versions" : 7, 
  "rocksdb.min-log-number-to-keep" : 57, 
  "rocksdb.estimate-live-data-size" : 1486478, 
  "rocksdb.live-sst-files-size" : 1486478, 
  "rocksdb.dbstats" : "\n** DB Stats **\nUptime(secs): 20643.1 total, 278.4 interval\nCumulative writes: 4455 writes, 15K keys, 4455 commit groups, 1.0 writes per commit group, ingest: 0.08 GB, 0.00 MB/s\nCumulative WAL: 4455 writes, 0 syncs, 4455.00 writes per sync, written: 0.08 G...", 
  "rocksdb.sstables" : "--- level 0 --- version# 30 ---\n--- level 1 --- version# 30 ---\n--- level 2 --- version# 30 ---\n--- level 3 --- version# 30 ---\n--- level 4 --- version# 30 ---\n--- level 5 --- version# 30 ---\n--- level 6 --- version# 30 ---\n 59:363955[0 .. 0]['300000000000...", 
  "rocksdb.num-running-compactions" : 0, 
  "rocksdb.num-running-flushes" : 0, 
  "rocksdb.is-file-deletions-enabled" : 1, 
  "rocksdb.estimate-pending-compaction-bytes" : 0, 
  "rocksdb.base-level" : 6, 
  "rocksdb.block-cache-capacity" : 4509715660, 
  "rocksdb.block-cache-usage" : 317618, 
  "rocksdb.block-cache-pinned-usage" : 0, 
  "rocksdb.total-sst-files-size" : 1486478, 
  "rocksdb.actual-delayed-write-rate" : 0, 
  "rocksdb.is-write-stopped" : 0, 
  "cache.limit" : 3758096384, 
  "cache.allocated" : 1091928, 
  "cache.hit-rate-lifetime" : 0, 
  "cache.hit-rate-recent" : 0, 
  "columnFamilies" : { 
    "definitions" : { 
      "dbstats" : "\n** Compaction Stats [default] **\nLevel    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop\n--------------------------------------------------...", 
      "memory" : 21465684 
    }, 
    "documents" : { 
      "dbstats" : "\n** Compaction Stats [Documents] **\nLevel    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop\n------------------------------------------------...", 
      "memory" : 1246663 
    }, 
    "primary" : { 
      "dbstats" : "\n** Compaction Stats [PrimaryIndex] **\nLevel    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop\n---------------------------------------------...", 
      "memory" : 30929 
    }, 
    "edge" : { 
      "dbstats" : "\n** Compaction Stats [EdgeIndex] **\nLevel    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop\n------------------------------------------------...", 
      "memory" : 0 
    }, 
    "vpack" : { 
      "dbstats" : "\n** Compaction Stats [VPackIndex] **\nLevel    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop\n-----------------------------------------------...", 
      "memory" : 27479 
    }, 
    "geo" : { 
      "dbstats" : "\n** Compaction Stats [GeoIndex] **\nLevel    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop\n-------------------------------------------------...", 
      "memory" : 0 
    }, 
    "fulltext" : { 
      "dbstats" : "\n** Compaction Stats [FulltextIndex] **\nLevel    Files   Size     Score Read(GB)  Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop\n--------------------------------------------...", 
      "memory" : 0 
    } 
  }, 
  "rocksdbengine.throttle.bps" : 0

 

 

 

Previous                                                    Next                                                    Home

No comments:

Post a Comment