Skip to content

Instantly share code, notes, and snippets.

@vadimtk

vadimtk/gist:889fcd407031a68710ae63023c34b041

Created March 5, 2018 19:56
Show Gist options
  • Save vadimtk/889fcd407031a68710ae63023c34b041 to your computer and use it in GitHub Desktop.
Save vadimtk/889fcd407031a68710ae63023c34b041 to your computer and use it in GitHub Desktop.
Download ZIP
SHOW ENGINE ROCKSDB STATUS
Raw
gistfile1.txt
*************************** 1. row ***************************
Type: STATISTICS
Name: rocksdb
Status: rocksdb.block.cache.miss COUNT : 25225466
rocksdb.block.cache.hit COUNT : 3401832090
rocksdb.block.cache.add COUNT : 16256677
rocksdb.block.cache.add.failures COUNT : 0
rocksdb.block.cache.index.miss COUNT : 22893
rocksdb.block.cache.index.hit COUNT : 1826162136
rocksdb.block.cache.index.add COUNT : 22893
rocksdb.block.cache.index.bytes.insert COUNT : 1540661683
rocksdb.block.cache.index.bytes.evict COUNT : 1367701856
rocksdb.block.cache.filter.miss COUNT : 22338
rocksdb.block.cache.filter.hit COUNT : 855296704
rocksdb.block.cache.filter.add COUNT : 14948
rocksdb.block.cache.filter.bytes.insert COUNT : 6295604980
rocksdb.block.cache.filter.bytes.evict COUNT : 6136068269
rocksdb.block.cache.data.miss COUNT : 25180235
rocksdb.block.cache.data.hit COUNT : 720373250
rocksdb.block.cache.data.add COUNT : 16218836
rocksdb.block.cache.data.bytes.insert COUNT : 262419910575
rocksdb.block.cache.bytes.read COUNT : 584483217424273
rocksdb.block.cache.bytes.write COUNT : 270256177238
rocksdb.bloom.filter.useful COUNT : 3951157263
rocksdb.persistent.cache.hit COUNT : 0
rocksdb.persistent.cache.miss COUNT : 0
rocksdb.sim.block.cache.hit COUNT : 0
rocksdb.sim.block.cache.miss COUNT : 0
rocksdb.memtable.hit COUNT : 26790969
rocksdb.memtable.miss COUNT : 443852014
rocksdb.l0.hit COUNT : 4742109
rocksdb.l1.hit COUNT : 0
rocksdb.l2andup.hit COUNT : 261127729
rocksdb.compaction.key.drop.new COUNT : 78437142
rocksdb.compaction.key.drop.obsolete COUNT : 3141845
rocksdb.compaction.key.drop.range_del COUNT : 0
rocksdb.compaction.key.drop.user COUNT : 0
rocksdb.compaction.range_del.drop.obsolete COUNT : 0
rocksdb.compaction.optimized.del.drop.obsolete COUNT : 0
rocksdb.number.keys.written COUNT : 286674416
rocksdb.number.keys.read COUNT : 470642983
rocksdb.number.keys.updated COUNT : 0
rocksdb.bytes.written COUNT : 32248755917
rocksdb.bytes.read COUNT : 86437689511
rocksdb.number.db.seek COUNT : 25150815
rocksdb.number.db.next COUNT : 245095135
rocksdb.number.db.prev COUNT : 0
rocksdb.number.db.seek.found COUNT : 25150813
rocksdb.number.db.next.found COUNT : 232936015
rocksdb.number.db.prev.found COUNT : 0
rocksdb.db.iter.bytes.read COUNT : 12193706759
rocksdb.no.file.closes COUNT : 0
rocksdb.no.file.opens COUNT : 22983
rocksdb.no.file.errors COUNT : 0
rocksdb.l0.slowdown.micros COUNT : 0
rocksdb.memtable.compaction.micros COUNT : 0
rocksdb.l0.num.files.stall.micros COUNT : 0
rocksdb.stall.micros COUNT : 1769779
rocksdb.db.mutex.wait.micros COUNT : 0
rocksdb.rate.limit.delay.millis COUNT : 0
rocksdb.num.iterators COUNT : 0
rocksdb.number.multiget.get COUNT : 0
rocksdb.number.multiget.keys.read COUNT : 0
rocksdb.number.multiget.bytes.read COUNT : 0
rocksdb.number.deletes.filtered COUNT : 0
rocksdb.number.merge.failures COUNT : 0
rocksdb.bloom.filter.prefix.checked COUNT : 73314829
rocksdb.bloom.filter.prefix.useful COUNT : 72012338
rocksdb.number.reseeks.iteration COUNT : 0
rocksdb.getupdatessince.calls COUNT : 0
rocksdb.block.cachecompressed.miss COUNT : 0
rocksdb.block.cachecompressed.hit COUNT : 0
rocksdb.block.cachecompressed.add COUNT : 0
rocksdb.block.cachecompressed.add.failures COUNT : 0
rocksdb.wal.synced COUNT : 2576960
rocksdb.wal.bytes COUNT : 32248755917
rocksdb.write.self COUNT : 2577516
rocksdb.write.other COUNT : 8794753
rocksdb.write.timeout COUNT : 0
rocksdb.write.wal COUNT : 22744538
rocksdb.compact.read.bytes COUNT : 159580666520
rocksdb.compact.write.bytes COUNT : 328169740754
rocksdb.flush.write.bytes COUNT : 30992694980
rocksdb.number.direct.load.table.properties COUNT : 0
rocksdb.number.superversion_acquires COUNT : 153654
rocksdb.number.superversion_releases COUNT : 12798
rocksdb.number.superversion_cleanups COUNT : 1152
rocksdb.number.block.compressed COUNT : 0
rocksdb.number.block.decompressed COUNT : 0
rocksdb.number.block.not_compressed COUNT : 0
rocksdb.merge.operation.time.nanos COUNT : 0
rocksdb.filter.operation.time.nanos COUNT : 165166231497
rocksdb.row.cache.hit COUNT : 0
rocksdb.row.cache.miss COUNT : 0
rocksdb.read.amp.estimate.useful.bytes COUNT : 0
rocksdb.read.amp.total.read.bytes COUNT : 0
rocksdb.number.rate_limiter.drains COUNT : 33572
rocksdb.number.iter.skip COUNT : 0
rocksdb.blobdb.num.put COUNT : 0
rocksdb.blobdb.num.write COUNT : 0
rocksdb.blobdb.num.get COUNT : 0
rocksdb.blobdb.num.multiget COUNT : 0
rocksdb.blobdb.num.seek COUNT : 0
rocksdb.blobdb.num.next COUNT : 0
rocksdb.blobdb.num.prev COUNT : 0
rocksdb.blobdb.num.keys.written COUNT : 0
rocksdb.blobdb.num.keys.read COUNT : 0
rocksdb.blobdb.bytes.written COUNT : 0
rocksdb.blobdb.bytes.read COUNT : 0
rocksdb.blobdb.write.inlined COUNT : 0
rocksdb.blobdb.write.inlined.ttl COUNT : 0
rocksdb.blobdb.write.blob COUNT : 0
rocksdb.blobdb.write.blob.ttl COUNT : 0
rocksdb.blobdb.blob.file.bytes.written COUNT : 0
rocksdb.blobdb.blob.file,bytes.read COUNT : 0
rocksdb.blobdb.blob.file.synced COUNT : 0
rocksdb.blobdb.blob.index.expired COUNT : 0
rocksdb.blobdb.gc.num.files COUNT : 0
rocksdb.blobdb.gc.num.new.files COUNT : 0
rocksdb.blobdb.gc.failures COUNT : 0
rocksdb.blobdb.gc.num.keys.overwritten COUNT : 0
rocksdb.blobdb.gc.num.keys.expired COUNT : 0
rocksdb.blobdb.gc.num.keys.relocated COUNT : 0
rocksdb.blobdb.gc.bytes.overwritten COUNT : 0
rocksdb.blobdb.gc.bytes.expired COUNT : 0
rocksdb.blobdb.gc.bytes.relocated COUNT : 0
rocksdb.blobdb.fifo.num.files.evicted COUNT : 0
rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0
rocksdb.blobdb.fifo.bytes.evicted COUNT : 0
rocksdb.db.get.micros statistics Percentiles :=> 50 : 20.776908 95 : 34.710233 99 : 515.500307 100 : 211268.000000
rocksdb.db.write.micros statistics Percentiles :=> 50 : 1546.695678 95 : 14009.573668 99 : 28871.233059 100 : 278648.000000
rocksdb.compaction.times.micros statistics Percentiles :=> 50 : 8484031.413613 95 : 20377235.772358 99 : 65050000.000000 100 : 162858862.000000
rocksdb.subcompaction.setup.times.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.table.sync.micros statistics Percentiles :=> 50 : 9240.000000 95 : 87250.000000 99 : 102896.000000 100 : 102896.000000
rocksdb.compaction.outfile.sync.micros statistics Percentiles :=> 50 : 8101.996528 95 : 90628.393051 99 : 104809.000000 100 : 104809.000000
rocksdb.wal.file.sync.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.manifest.file.sync.micros statistics Percentiles :=> 50 : 289.810030 95 : 6311.250000 99 : 48810.000000 100 : 245637.000000
rocksdb.table.open.io.micros statistics Percentiles :=> 50 : 5865.552178 95 : 20027.300060 99 : 25600.231023 100 : 58454.000000
rocksdb.db.multiget.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.read.block.compaction.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.read.block.get.micros statistics Percentiles :=> 50 : 305.482305 95 : 6247.862311 99 : 13008.096108 100 : 198350.000000
rocksdb.write.raw.block.micros statistics Percentiles :=> 50 : 4.854838 95 : 8.912164 99 : 16290.477876 100 : 295301.000000
rocksdb.l0.slowdown.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.memtable.compaction.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.num.files.stall.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.hard.rate.limit.delay.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.soft.rate.limit.delay.count statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.numfiles.in.singlecompaction statistics Percentiles :=> 50 : 1.000000 95 : 2.411364 99 : 5.030500 100 : 21.000000
rocksdb.db.seek.micros statistics Percentiles :=> 50 : 70.530759 95 : 315.538667 99 : 1162.768887 100 : 234832.000000
rocksdb.db.write.stall statistics Percentiles :=> 50 : 0.500906 95 : 0.951721 99 : 0.991793 100 : 29391.000000
rocksdb.sst.read.micros statistics Percentiles :=> 50 : 279.689078 95 : 6292.196756 99 : 13031.535437 100 : 198319.000000
rocksdb.num.subcompactions.scheduled statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.bytes.per.read statistics Percentiles :=> 50 : 253.433309 95 : 379.983304 99 : 654.000000 100 : 654.000000
rocksdb.bytes.per.write statistics Percentiles :=> 50 : 8139.156354 95 : 39864.635958 99 : 87158.145087 100 : 142967.000000
rocksdb.bytes.per.multiget statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.bytes.compressed statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.bytes.decompressed statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.compression.times.nanos statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.decompression.times.nanos statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.read.num.merge_operands statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.key.size statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.value.size statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.write.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.get.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.multiget.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.seek.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.next.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.prev.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.blob.file.write.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.blob.file.read.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.blob.file.sync.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.gc.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.compression.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.blobdb.decompression.micros statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000
rocksdb.commit_latency statistics Percentiles :=> 50 : 1.58 95 : 12.82 99 : 1560.45 100 : 6163.09
rocksdb.is_write_stopped COUNT : 0
rocksdb.actual_delayed_write_rate COUNT : 0
*************************** 2. row ***************************
Type: DBSTATS
Name: rocksdb
Status:
** DB Stats **
Uptime(secs): 3611.9 total, 554.8 interval
Cumulative writes: 11M writes, 286M keys, 2577K commit groups, 4.4 writes per commit group, ingest: 30.03 GB, 8.51 MB/s
Cumulative WAL: 11M writes, 0 syncs, 11372269.00 writes per sync, written: 30.03 GB, 8.51 MB/s
Cumulative stall: 00:00:1.770 H:M:S, 0.0 percent
Interval writes: 1666K writes, 42M keys, 390K commit groups, 4.3 writes per commit group, ingest: 4511.99 MB, 8.13 MB/s
Interval WAL: 1666K writes, 0 syncs, 1666682.00 writes per sync, written: 4.41 MB, 8.13 MB/s
Interval stall: 00:00:1.315 H:M:S, 0.2 percent
*************************** 3. row ***************************
Type: CF_COMPACTION
Name: __system__
Status:
** Compaction Stats [__system__] **
Level 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) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------
L0 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 1.5 0 8 0.009 0 0
L6 1/0 24.65 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.4 13.6 4.2 0 2 0.006 1708 922
Sum 1/0 24.65 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.4 1.8 1.8 0 10 0.009 1708 922
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.7 9.3 4.4 0 2 0.004 893 500
Uptime(secs): 3611.9 total, 554.8 interval
Flush(GB): cumulative 0.000, interval 0.000
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.1 seconds
Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds
Stalls(count): 0 level0_slowdown, 0 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 0 total count
** File Read Latency Histogram By Level [__system__] **
** Level 0 read latency histogram (micros):
Count: 26 Average: 849.4231 StdDev: 3395.72
Min: 36 Median: 90.5714 Max: 17762
Percentiles: P50: 90.57 P75: 180.00 P99: 17762.00 P99.9: 17762.00 P99.99: 17762.00
------------------------------------------------------
( 34, 51 ] 3 11.538% 11.538% ##
( 51, 76 ] 7 26.923% 38.462% #####
( 76, 110 ] 7 26.923% 65.385% #####
( 110, 170 ] 2 7.692% 73.077% ##
( 170, 250 ] 4 15.385% 88.462% ###
( 250, 380 ] 1 3.846% 92.308% #
( 1300, 1900 ] 1 3.846% 96.154% #
( 14000, 22000 ] 1 3.846% 100.000% #
** Level 6 read latency histogram (micros):
Count: 10 Average: 1212.9000 StdDev: 2842.29
Min: 103 Median: 250.0000 Max: 9726
Percentiles: P50: 250.00 P75: 480.00 P99: 9570.00 P99.9: 9726.00 P99.99: 9726.00
------------------------------------------------------
( 76, 110 ] 1 10.000% 10.000% ##
( 110, 170 ] 3 30.000% 40.000% ######
( 170, 250 ] 1 10.000% 50.000% ##
( 250, 380 ] 2 20.000% 70.000% ####
( 380, 580 ] 1 10.000% 80.000% ##
( 580, 870 ] 1 10.000% 90.000% ##
( 6600, 9900 ] 1 10.000% 100.000% ##
*************************** 4. row ***************************
Type: CF_COMPACTION
Name: default
Status:
** Compaction Stats [default] **
Level 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) Comp(cnt) Avg(sec) KeyIn KeyDrop
----------------------------------------------------------------------------------------------------------------------------------------------------------
L0 5/4 1.40 GB 0.2 20.0 0.0 20.0 48.6 28.6 0.0 1.7 7.8 18.9 2632 352 7.476 189M 1860K
L3 39/39 1.23 GB 0.0 50.5 27.2 23.3 50.0 26.6 0.0 1.8 18.3 18.1 2829 31 91.268 506M 2434K
L4 49/5 1.51 GB 1.9 23.6 15.3 8.3 23.4 15.1 10.6 1.5 17.0 16.9 1422 276 5.152 259M 473K
L5 289/15 7.43 GB 1.0 102.3 24.5 77.8 100.5 22.7 0.3 4.1 16.3 16.0 6433 781 8.237 1077M 6510K
L6 2455/0 71.59 GB 0.0 124.6 21.9 102.7 111.6 8.9 0.0 5.1 17.7 15.9 7208 741 9.727 1369M 67M
Sum 2837/63 83.15 GB 0.0 321.0 88.9 232.1 334.1 102.0 10.9 11.6 16.0 16.7 20524 2181 9.410 3402M 78M
Int 0/0 0.00 KB 0.0 53.7 14.4 39.3 54.1 14.8 2.1 12.7 15.5 15.6 3547 349 10.163 517M 16M
Uptime(secs): 3611.9 total, 554.8 interval
Flush(GB): cumulative 28.864, interval 4.256
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction: 334.13 GB write, 94.73 MB/s write, 321.01 GB read, 91.01 MB/s read, 20524.1 seconds
Interval compaction: 54.09 GB write, 99.83 MB/s write, 53.66 GB read, 99.03 MB/s read, 3546.8 seconds
Stalls(count): 497 level0_slowdown, 497 level0_slowdown_with_compaction, 0 level0_numfiles, 0 level0_numfiles_with_compaction, 0 stop for pending_compaction_bytes, 0 slowdown for pending_compaction_bytes, 0 memtable_compaction, 0 memtable_slowdown, interval 142 total count
** File Read Latency Histogram By Level [default] **
** Level 0 read latency histogram (micros):
Count: 2776162 Average: 1168.4531 StdDev: 1469.41
Min: 138 Median: 247.9379 Max: 198319
Percentiles: P50: 247.94 P75: 554.06 P99: 13264.27 P99.9: 20436.35 P99.99: 26536.16
------------------------------------------------------
( 110, 170 ] 32890 1.185% 1.185%
( 170, 250 ] 1391047 50.107% 51.292% ##########
( 250, 380 ] 487719 17.568% 68.860% ####
( 380, 580 ] 195873 7.056% 75.915% #
( 580, 870 ] 133838 4.821% 80.736% #
( 870, 1300 ] 134606 4.849% 85.585% #
( 1300, 1900 ] 63469 2.286% 87.871%
( 1900, 2900 ] 57790 2.082% 89.953%
( 2900, 4400 ] 71440 2.573% 92.526% #
( 4400, 6600 ] 44320 1.596% 94.122%
( 6600, 9900 ] 65562 2.362% 96.484%
( 9900, 14000 ] 85121 3.066% 99.550% #
( 14000, 22000 ] 12070 0.435% 99.985%
( 22000, 33000 ] 338 0.012% 99.997%
( 33000, 50000 ] 54 0.002% 99.999%
( 50000, 75000 ] 35 0.001% 100.000%
( 75000, 110000 ] 8 0.000% 100.001%
( 110000, 170000 ] 5 0.000% 100.001%
( 170000, 250000 ] 2 0.000% 100.001%
** Level 3 read latency histogram (micros):
Count: 1491583 Average: 1205.3909 StdDev: 568.39
Min: 99 Median: 277.4846 Max: 198255
Percentiles: P50: 277.48 P75: 600.86 P99: 13405.85 P99.9: 21240.82 P99.99: 72404.40
------------------------------------------------------
( 76, 110 ] 3 0.000% 0.000%
( 110, 170 ] 12026 0.806% 0.806%
( 170, 250 ] 667923 44.779% 45.586% #########
( 250, 380 ] 311416 20.878% 66.464% ####
( 380, 580 ] 121581 8.151% 74.615% ##
( 580, 870 ] 79758 5.347% 79.962% #
( 870, 1300 ] 77021 5.164% 85.126% #
( 1300, 1900 ] 37370 2.505% 87.632% #
( 1900, 2900 ] 34142 2.289% 89.921%
( 2900, 4400 ] 41488 2.781% 92.702% #
( 4400, 6600 ] 23286 1.561% 94.263%
( 6600, 9900 ] 32389 2.171% 96.435%
( 9900, 14000 ] 44749 3.000% 99.435% #
( 14000, 22000 ] 7667 0.514% 99.949%
( 22000, 33000 ] 328 0.022% 99.971%
( 33000, 50000 ] 156 0.010% 99.981%
( 50000, 75000 ] 146 0.010% 99.991%
( 75000, 110000 ] 102 0.007% 99.998%
( 110000, 170000 ] 26 0.002% 100.000%
( 170000, 250000 ] 12 0.001% 100.000%
** Level 4 read latency histogram (micros):
Count: 518725 Average: 1203.1949 StdDev: 2702.63
Min: 48 Median: 277.8736 Max: 82731
Percentiles: P50: 277.87 P75: 617.81 P99: 13402.08 P99.9: 21040.70 P99.99: 40641.86
------------------------------------------------------
( 34, 51 ] 1 0.000% 0.000%
( 51, 76 ] 4 0.001% 0.001%
( 76, 110 ] 4 0.001% 0.002%
( 110, 170 ] 4724 0.911% 0.912%
( 170, 250 ] 231592 44.646% 45.559% #########
( 250, 380 ] 107445 20.713% 66.272% ####
( 380, 580 ] 41538 8.008% 74.280% ##
( 580, 870 ] 28656 5.524% 79.804% #
( 870, 1300 ] 27087 5.222% 85.026% #
( 1300, 1900 ] 13182 2.541% 87.567% #
( 1900, 2900 ] 11980 2.310% 89.877%
( 2900, 4400 ] 14078 2.714% 92.591% #
( 4400, 6600 ] 8175 1.576% 94.167%
( 6600, 9900 ] 11558 2.228% 96.395%
( 9900, 14000 ] 15821 3.050% 99.445% #
( 14000, 22000 ] 2683 0.517% 99.962%
( 22000, 33000 ] 124 0.024% 99.986%
( 33000, 50000 ] 47 0.009% 99.995%
( 50000, 75000 ] 20 0.004% 99.999%
( 75000, 110000 ] 6 0.001% 100.000%
** Level 5 read latency histogram (micros):
Count: 3501146 Average: 1170.2952 StdDev: 929.11
Min: 56 Median: 248.5275 Max: 174800
Percentiles: P50: 248.53 P75: 578.35 P99: 13298.50 P99.9: 20500.36 P99.99: 24574.84
------------------------------------------------------
( 51, 76 ] 7 0.000% 0.000%
( 76, 110 ] 11 0.000% 0.001%
( 110, 170 ] 48289 1.379% 1.380%
( 170, 250 ] 1734185 49.532% 50.912% ##########
( 250, 380 ] 582449 16.636% 67.548% ###
( 380, 580 ] 263085 7.514% 75.062% ##
( 580, 870 ] 189334 5.408% 80.470% #
( 870, 1300 ] 173430 4.954% 85.423% #
( 1300, 1900 ] 83205 2.377% 87.800%
( 1900, 2900 ] 77712 2.220% 90.019%
( 2900, 4400 ] 92644 2.646% 92.665% #
( 4400, 6600 ] 55456 1.584% 94.249%
( 6600, 9900 ] 77954 2.227% 96.476%
( 9900, 14000 ] 106615 3.045% 99.521% #
( 14000, 22000 ] 16330 0.466% 99.987%
( 22000, 33000 ] 384 0.011% 99.998%
( 33000, 50000 ] 81 0.002% 100.001%
( 50000, 75000 ] 31 0.001% 100.002%
( 75000, 110000 ] 6 0.000% 100.002%
( 110000, 170000 ] 2 0.000% 100.002%
( 170000, 250000 ] 1 0.000% 100.002%
** Level 6 read latency histogram (micros):
Count: 7971093 Average: 1014.8699 StdDev: 443.30
Min: 45 Median: 307.9991 Max: 189892
Percentiles: P50: 308.00 P75: 692.48 P99: 12540.85 P99.9: 19760.23 P99.99: 21931.86
------------------------------------------------------
( 34, 51 ] 1 0.000% 0.000%
( 51, 76 ] 11 0.000% 0.000%
( 76, 110 ] 26 0.000% 0.000%
( 110, 170 ] 76998 0.966% 0.966%
( 170, 250 ] 3255655 40.843% 41.810% ########
( 250, 380 ] 1463320 18.358% 60.168% ####
( 380, 580 ] 921707 11.563% 71.731% ##
( 580, 870 ] 671889 8.429% 80.160% ##
( 870, 1300 ] 461436 5.789% 85.949% #
( 1300, 1900 ] 243921 3.060% 89.009% #
( 1900, 2900 ] 233087 2.924% 91.933% #
( 2900, 4400 ] 236482 2.967% 94.900% #
( 4400, 6600 ] 107818 1.353% 96.252%
( 6600, 9900 ] 123632 1.551% 97.803%
( 9900, 14000 ] 148110 1.858% 99.661%
( 14000, 22000 ] 26428 0.332% 99.993%
( 22000, 33000 ] 638 0.008% 100.001%
( 33000, 50000 ] 134 0.002% 100.003%
( 50000, 75000 ] 96 0.001% 100.004%
( 75000, 110000 ] 31 0.000% 100.004%
( 110000, 170000 ] 16 0.000% 100.004%
( 170000, 250000 ] 4 0.000% 100.004%
*************************** 5. row ***************************
Type: MEMORY_STATS
Name: rocksdb
Status:
MemTable Total: 595505784
MemTable Unflushed: 154868224
Table Readers Total: 0
Cache Total: 107373319755
Default Cache Capacity: 0
*************************** 6. row ***************************
Type: BG_THREADS
Name: 140569313539840
Status:
thread_type: High Pri
cf_name: default
operation_type: Flush
operation_stage: FlushJob::WriteLevel0Table
elapsed_time_ms: 385.595 ms
BytesMemtables: 136784168
BytesWritten: 6291456
JobID: 2629
state_type:
*************************** 7. row ***************************
Type: BG_THREADS
Name: 140569934272256
Status:
thread_type: High Pri
cf_name:
operation_type:
operation_stage:
elapsed_time_ms:
state_type:
*************************** 8. row ***************************
Type: BG_THREADS
Name: 140569942664960
Status:
thread_type: Low Pri
cf_name: default
operation_type: Compaction
operation_stage: CompactionJob::ProcessKeyValueCompaction
elapsed_time_ms: 1393.736 ms
BaseInputLevel: 4
BytesRead: 18216519
BytesWritten: 18874368
IsDeletion: 0
IsManual: 0
IsTrivialMove: 0
JobID: 2627
OutputLevel: 5
TotalInputBytes: 118588209
state_type:
*************************** 9. row ***************************
Type: BG_THREADS
Name: 140569951057664
Status:
thread_type: Low Pri
cf_name: default
operation_type: Compaction
operation_stage: CompactionJob::FinishCompactionOutputFile
elapsed_time_ms: 5696.498 ms
BaseInputLevel: 4
BytesRead: 53284673
BytesWritten: 99683328
IsDeletion: 0
IsManual: 0
IsTrivialMove: 0
JobID: 2624
OutputLevel: 5
TotalInputBytes: 102673975
state_type:
*************************** 10. row ***************************
Type: BG_THREADS
Name: 140569959450368
Status:
thread_type: Low Pri
cf_name: default
operation_type: Compaction
operation_stage: CompactionJob::ProcessKeyValueCompaction
elapsed_time_ms: 1496.002 ms
BaseInputLevel: 4
BytesRead: 32660647
BytesWritten: 30408704
IsDeletion: 0
IsManual: 0
IsTrivialMove: 0
JobID: 2626
OutputLevel: 5
TotalInputBytes: 101804835
state_type:
*************************** 11. row ***************************
Type: BG_THREADS
Name: 140569967843072
Status:
thread_type: Low Pri
cf_name: default
operation_type: Compaction
operation_stage: CompactionJob::ProcessKeyValueCompaction
elapsed_time_ms: 1097.173 ms
BaseInputLevel: 4
BytesRead: 11558504
BytesWritten: 14680064
IsDeletion: 0
IsManual: 0
IsTrivialMove: 0
JobID: 2628
OutputLevel: 5
TotalInputBytes: 119076115
state_type:
*************************** 12. row ***************************
Type: BG_THREADS
Name: 140569976235776
Status:
thread_type: Low Pri
cf_name: default
operation_type: Compaction
operation_stage: CompactionJob::ProcessKeyValueCompaction
elapsed_time_ms: 2203.560 ms
BaseInputLevel: 4
BytesRead: 29801254
BytesWritten: 42156544
IsDeletion: 0
IsManual: 0
IsTrivialMove: 0
JobID: 2625
OutputLevel: 5
TotalInputBytes: 101304838
state_type:
*************************** 13. row ***************************
Type: BG_THREADS
Name: 140569984628480
Status:
thread_type: Low Pri
cf_name: default
operation_type: Compaction
operation_stage: CompactionJob::ProcessKeyValueCompaction
elapsed_time_ms: 10.602 sec
BaseInputLevel: 0
BytesRead: 129042431
BytesWritten: 176974336
IsDeletion: 0
IsManual: 0
IsTrivialMove: 0
JobID: 2619
OutputLevel: 3
TotalInputBytes: 2721214946
state_type:
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment