Created
March 6, 2018 00:17
-
-
Save vadimtk/ab6bc493830a99424ab90a6a11dafa8e to your computer and use it in GitHub Desktop.
SHOW ENGINE ROCKSDB STATUS - 2
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
*************************** 1. row *************************** | |
Type: STATISTICS | |
Name: rocksdb | |
Status: rocksdb.block.cache.miss COUNT : 30080389 | |
rocksdb.block.cache.hit COUNT : 3767387750 | |
rocksdb.block.cache.add COUNT : 18272154 | |
rocksdb.block.cache.add.failures COUNT : 0 | |
rocksdb.block.cache.index.miss COUNT : 16322 | |
rocksdb.block.cache.index.hit COUNT : 2010940986 | |
rocksdb.block.cache.index.add COUNT : 16322 | |
rocksdb.block.cache.index.bytes.insert COUNT : 1028881429 | |
rocksdb.block.cache.index.bytes.evict COUNT : 861696900 | |
rocksdb.block.cache.filter.miss COUNT : 14176 | |
rocksdb.block.cache.filter.hit COUNT : 1083842139 | |
rocksdb.block.cache.filter.add COUNT : 9608 | |
rocksdb.block.cache.filter.bytes.insert COUNT : 3514022184 | |
rocksdb.block.cache.filter.bytes.evict COUNT : 3357832821 | |
rocksdb.block.cache.data.miss COUNT : 30049891 | |
rocksdb.block.cache.data.hit COUNT : 672604625 | |
rocksdb.block.cache.data.add COUNT : 18246224 | |
rocksdb.block.cache.data.bytes.insert COUNT : 295245521602 | |
rocksdb.block.cache.bytes.read COUNT : 685199085180634 | |
rocksdb.block.cache.bytes.write COUNT : 299788425215 | |
rocksdb.bloom.filter.useful COUNT : 2574073911 | |
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 : 25844953 | |
rocksdb.memtable.miss COUNT : 473167116 | |
rocksdb.l0.hit COUNT : 4518064 | |
rocksdb.l1.hit COUNT : 0 | |
rocksdb.l2andup.hit COUNT : 279901960 | |
rocksdb.compaction.key.drop.new COUNT : 96439882 | |
rocksdb.compaction.key.drop.obsolete COUNT : 4483424 | |
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 : 303977082 | |
rocksdb.number.keys.read COUNT : 499012069 | |
rocksdb.number.keys.updated COUNT : 0 | |
rocksdb.bytes.written COUNT : 34199620505 | |
rocksdb.bytes.read COUNT : 91666804168 | |
rocksdb.number.db.seek COUNT : 26658599 | |
rocksdb.number.db.next COUNT : 259749308 | |
rocksdb.number.db.prev COUNT : 0 | |
rocksdb.number.db.seek.found COUNT : 26658597 | |
rocksdb.number.db.next.found COUNT : 246871109 | |
rocksdb.number.db.prev.found COUNT : 0 | |
rocksdb.db.iter.bytes.read COUNT : 12931510297 | |
rocksdb.no.file.closes COUNT : 0 | |
rocksdb.no.file.opens COUNT : 16257 | |
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 : 0 | |
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 : 48082882 | |
rocksdb.bloom.filter.prefix.useful COUNT : 47082415 | |
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 : 2709646 | |
rocksdb.wal.bytes COUNT : 34199620505 | |
rocksdb.write.self COUNT : 2710066 | |
rocksdb.write.other COUNT : 9358141 | |
rocksdb.write.timeout COUNT : 0 | |
rocksdb.write.wal COUNT : 24136414 | |
rocksdb.compact.read.bytes COUNT : 195375350420 | |
rocksdb.compact.write.bytes COUNT : 410200020553 | |
rocksdb.flush.write.bytes COUNT : 32949905937 | |
rocksdb.number.direct.load.table.properties COUNT : 0 | |
rocksdb.number.superversion_acquires COUNT : 183672 | |
rocksdb.number.superversion_releases COUNT : 7622 | |
rocksdb.number.superversion_cleanups COUNT : 1015 | |
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 : 223732497806 | |
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 : 0 | |
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 : 19.313859 95 : 33.745622 99 : 74.701367 100 : 60512.000000 | |
rocksdb.db.write.micros statistics Percentiles :=> 50 : 1558.979812 95 : 11381.694621 99 : 70218.520675 100 : 934356.000000 | |
rocksdb.compaction.times.micros statistics Percentiles :=> 50 : 1742119.565217 95 : 9035422.535211 99 : 18963750.000000 100 : 21299975.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 : 236315.789474 95 : 364685.606061 99 : 377725.000000 100 : 387979.000000 | |
rocksdb.compaction.outfile.sync.micros statistics Percentiles :=> 50 : 71771.382418 95 : 379778.821737 99 : 533176.461769 100 : 935131.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 : 236.795866 95 : 2281.707317 99 : 64625.000000 100 : 250181.000000 | |
rocksdb.table.open.io.micros statistics Percentiles :=> 50 : 184.252472 95 : 16439.000000 99 : 16439.000000 100 : 16439.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 : 30.176822 95 : 739.052670 99 : 1714.968987 100 : 60472.000000 | |
rocksdb.write.raw.block.micros statistics Percentiles :=> 50 : 4.287769 95 : 8.962096 99 : 963.148390 100 : 121341.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 : 1.714167 99 : 4.993962 100 : 6.000000 | |
rocksdb.db.seek.micros statistics Percentiles :=> 50 : 57.679288 95 : 168.038350 99 : 268.047555 100 : 40513.000000 | |
rocksdb.db.write.stall statistics Percentiles :=> 50 : 0.000000 95 : 0.000000 99 : 0.000000 100 : 0.000000 | |
rocksdb.sst.read.micros statistics Percentiles :=> 50 : 9.965182 95 : 426.075218 99 : 1159.344926 100 : 73850.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.451100 95 : 379.992738 99 : 654.000000 100 : 654.000000 | |
rocksdb.bytes.per.write statistics Percentiles :=> 50 : 8810.962755 95 : 36608.012805 99 : 74478.022363 100 : 143494.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.85 95 : 19.11 99 : 1486.05 100 : 3303.84 | |
rocksdb.is_write_stopped COUNT : 0 | |
rocksdb.actual_delayed_write_rate COUNT : 0 | |
*************************** 2. row *************************** | |
Type: DBSTATS | |
Name: rocksdb | |
Status: | |
** DB Stats ** | |
Uptime(secs): 3612.2 total, 556.8 interval | |
Cumulative writes: 12M writes, 303M keys, 2710K commit groups, 4.5 writes per commit group, ingest: 31.85 GB, 9.03 MB/s | |
Cumulative WAL: 12M writes, 0 syncs, 12068207.00 writes per sync, written: 31.85 GB, 9.03 MB/s | |
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent | |
Interval writes: 1804K writes, 45M keys, 408K commit groups, 4.4 writes per commit group, ingest: 4881.11 MB, 8.77 MB/s | |
Interval WAL: 1804K writes, 0 syncs, 1804383.00 writes per sync, written: 4.77 MB, 8.77 MB/s | |
Interval stall: 00:00:0.000 H:M:S, 0.0 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 6.4 0 8 0.002 0 0 | |
L6 1/0 24.65 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.4 18.9 5.8 0 2 0.004 1720 934 | |
Sum 1/0 24.65 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.4 6.2 6.2 0 10 0.003 1720 934 | |
Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.6 9.9 4.6 0 2 0.004 898 505 | |
Uptime(secs): 3612.2 total, 556.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.0 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: 50 Average: 2.5800 StdDev: 1.97 | |
Min: 1 Median: 1.5000 Max: 10 | |
Percentiles: P50: 1.50 P75: 2.10 P99: 9.50 P99.9: 9.95 P99.99: 9.99 | |
------------------------------------------------------ | |
[ 0, 1 ] 13 26.000% 26.000% ##### | |
( 1, 2 ] 24 48.000% 74.000% ########## | |
( 2, 3 ] 5 10.000% 84.000% ## | |
( 4, 6 ] 4 8.000% 92.000% ## | |
( 6, 10 ] 4 8.000% 100.000% ## | |
** Level 6 read latency histogram (micros): | |
Count: 18 Average: 12.5000 StdDev: 37.28 | |
Min: 1 Median: 2.5000 Max: 166 | |
Percentiles: P50: 2.50 P75: 4.50 P99: 159.20 P99.9: 166.00 P99.99: 166.00 | |
------------------------------------------------------ | |
[ 0, 1 ] 2 11.111% 11.111% ## | |
( 1, 2 ] 4 22.222% 33.333% #### | |
( 2, 3 ] 6 33.333% 66.667% ####### | |
( 3, 4 ] 1 5.556% 72.222% # | |
( 4, 6 ] 2 11.111% 83.333% ## | |
( 6, 10 ] 2 11.111% 94.444% ## | |
( 110, 170 ] 1 5.556% 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 4/0 385.09 MB 1.0 0.0 0.0 0.0 30.7 30.7 0.0 1.0 0.0 91.6 343 323 1.062 0 0 | |
L3 14/0 456.26 MB 0.9 63.1 30.3 32.8 62.5 29.6 0.0 2.1 59.3 58.6 1091 67 16.287 760M 3779K | |
L4 29/6 909.65 MB 1.0 40.2 22.8 17.4 40.0 22.6 6.9 1.8 69.2 68.8 595 566 1.051 381M 688K | |
L5 310/37 7.93 GB 1.0 148.5 29.0 119.5 146.3 26.8 0.2 5.0 64.6 63.6 2354 928 2.537 1482M 7779K | |
L6 2468/0 72.16 GB 0.0 148.6 25.4 123.2 132.7 9.5 0.0 5.2 59.8 53.4 2546 866 2.940 1649M 84M | |
Sum 2825/43 81.80 GB 0.0 400.4 107.5 292.9 412.2 119.2 7.1 13.4 59.2 60.9 6930 2750 2.520 4274M 96M | |
Int 0/0 0.00 KB 0.0 66.3 16.6 49.6 67.2 17.5 1.0 14.5 56.5 57.3 1200 439 2.733 730M 18M | |
Uptime(secs): 3612.2 total, 556.8 interval | |
Flush(GB): cumulative 30.687, interval 4.648 | |
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: 412.17 GB write, 116.85 MB/s write, 400.40 GB read, 113.51 MB/s read, 6929.9 seconds | |
Interval compaction: 67.17 GB write, 123.53 MB/s write, 66.26 GB read, 121.85 MB/s read, 1199.9 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 [default] ** | |
** Level 0 read latency histogram (micros): | |
Count: 2161381 Average: 16.0127 StdDev: 94.35 | |
Min: 1 Median: 10.8928 Max: 23199 | |
Percentiles: P50: 10.89 P75: 13.60 P99: 59.99 P99.9: 1251.00 P99.99: 3698.43 | |
------------------------------------------------------ | |
[ 0, 1 ] 199 0.009% 0.009% | |
( 1, 2 ] 381 0.018% 0.027% | |
( 2, 3 ] 792 0.037% 0.063% | |
( 3, 4 ] 32668 1.511% 1.575% | |
( 4, 6 ] 158069 7.313% 8.888% # | |
( 6, 10 ] 710362 32.866% 41.754% ####### | |
( 10, 15 ] 998079 46.178% 87.932% ######### | |
( 15, 22 ] 213328 9.870% 97.802% ## | |
( 22, 34 ] 16200 0.750% 98.552% | |
( 34, 51 ] 7899 0.365% 98.917% | |
( 51, 76 ] 4976 0.230% 99.147% | |
( 76, 110 ] 2876 0.133% 99.280% | |
( 110, 170 ] 2994 0.139% 99.419% | |
( 170, 250 ] 2424 0.112% 99.531% | |
( 250, 380 ] 2525 0.117% 99.648% | |
( 380, 580 ] 2251 0.104% 99.752% | |
( 580, 870 ] 1895 0.088% 99.840% | |
( 870, 1300 ] 1469 0.068% 99.908% | |
( 1300, 1900 ] 991 0.046% 99.954% | |
( 1900, 2900 ] 649 0.030% 99.984% | |
( 2900, 4400 ] 259 0.012% 99.996% | |
( 4400, 6600 ] 89 0.004% 100.000% | |
( 6600, 9900 ] 18 0.001% 100.001% | |
( 9900, 14000 ] 1 0.000% 100.001% | |
( 14000, 22000 ] 7 0.000% 100.001% | |
( 22000, 33000 ] 2 0.000% 100.001% | |
** Level 3 read latency histogram (micros): | |
Count: 4186836 Average: 13.0859 StdDev: 81.44 | |
Min: 1 Median: 8.2646 Max: 24582 | |
Percentiles: P50: 8.26 P75: 11.51 P99: 36.96 P99.9: 1057.97 P99.99: 2773.10 | |
------------------------------------------------------ | |
[ 0, 1 ] 1882 0.045% 0.045% | |
( 1, 2 ] 4728 0.113% 0.158% | |
( 2, 3 ] 36026 0.860% 1.018% | |
( 3, 4 ] 324673 7.755% 8.773% ## | |
( 4, 6 ] 788888 18.842% 27.615% #### | |
( 6, 10 ] 1655429 39.539% 67.154% ######## | |
( 10, 15 ] 1088684 26.003% 93.157% ##### | |
( 15, 22 ] 222936 5.325% 98.481% # | |
( 22, 34 ] 19941 0.476% 98.957% | |
( 34, 51 ] 10224 0.244% 99.202% | |
( 51, 76 ] 5335 0.127% 99.329% | |
( 76, 110 ] 3194 0.076% 99.405% | |
( 110, 170 ] 3308 0.079% 99.484% | |
( 170, 250 ] 3207 0.077% 99.561% | |
( 250, 380 ] 3168 0.076% 99.637% | |
( 380, 580 ] 4495 0.107% 99.744% | |
( 580, 870 ] 5232 0.125% 99.869% | |
( 870, 1300 ] 2972 0.071% 99.940% | |
( 1300, 1900 ] 1437 0.034% 99.974% | |
( 1900, 2900 ] 754 0.018% 99.992% | |
( 2900, 4400 ] 282 0.007% 99.999% | |
( 4400, 6600 ] 72 0.002% 100.001% | |
( 6600, 9900 ] 18 0.000% 100.001% | |
( 9900, 14000 ] 7 0.000% 100.001% | |
( 14000, 22000 ] 10 0.000% 100.002% | |
( 22000, 33000 ] 5 0.000% 100.002% | |
** Level 4 read latency histogram (micros): | |
Count: 2663563 Average: 14.3662 StdDev: 150.58 | |
Min: 0 Median: 7.9882 Max: 28659 | |
Percentiles: P50: 7.99 P75: 10.96 P99: 41.51 P99.9: 1119.58 P99.99: 3932.53 | |
------------------------------------------------------ | |
[ 0, 1 ] 1174 0.044% 0.044% | |
( 1, 2 ] 2679 0.101% 0.145% | |
( 2, 3 ] 13704 0.514% 0.659% | |
( 3, 4 ] 204578 7.681% 8.340% ## | |
( 4, 6 ] 571197 21.445% 29.785% #### | |
( 6, 10 ] 1083282 40.670% 70.455% ######## | |
( 10, 15 ] 630657 23.677% 94.132% ##### | |
( 15, 22 ] 117378 4.407% 98.539% # | |
( 22, 34 ] 9885 0.371% 98.910% | |
( 34, 51 ] 5419 0.203% 99.114% | |
( 51, 76 ] 2790 0.105% 99.218% | |
( 76, 110 ] 985 0.037% 99.255% | |
( 110, 170 ] 1215 0.046% 99.301% | |
( 170, 250 ] 3241 0.122% 99.423% | |
( 250, 380 ] 3416 0.128% 99.551% | |
( 380, 580 ] 3924 0.147% 99.698% | |
( 580, 870 ] 4031 0.151% 99.850% | |
( 870, 1300 ] 2318 0.087% 99.937% | |
( 1300, 1900 ] 899 0.034% 99.970% | |
( 1900, 2900 ] 410 0.015% 99.986% | |
( 2900, 4400 ] 168 0.006% 99.992% | |
( 4400, 6600 ] 52 0.002% 99.994% | |
( 6600, 9900 ] 46 0.002% 99.996% | |
( 9900, 14000 ] 36 0.001% 99.997% | |
( 14000, 22000 ] 94 0.004% 100.001% | |
( 22000, 33000 ] 18 0.001% 100.001% | |
** Level 5 read latency histogram (micros): | |
Count: 9689950 Average: 28.2137 StdDev: 314.84 | |
Min: 0 Median: 8.7782 Max: 44175 | |
Percentiles: P50: 8.78 P75: 12.36 P99: 544.27 P99.9: 1752.76 P99.99: 15500.37 | |
------------------------------------------------------ | |
[ 0, 1 ] 5239 0.054% 0.054% | |
( 1, 2 ] 13923 0.144% 0.198% | |
( 2, 3 ] 122071 1.260% 1.458% | |
( 3, 4 ] 828937 8.555% 10.012% ## | |
( 4, 6 ] 1545349 15.948% 25.960% ### | |
( 6, 10 ] 3353942 34.613% 60.573% ####### | |
( 10, 15 ] 2956363 30.510% 91.082% ###### | |
( 15, 22 ] 530706 5.477% 96.559% # | |
( 22, 34 ] 43779 0.452% 97.011% | |
( 34, 51 ] 25989 0.268% 97.279% | |
( 51, 76 ] 14388 0.148% 97.428% | |
( 76, 110 ] 4213 0.043% 97.471% | |
( 110, 170 ] 7008 0.072% 97.543% | |
( 170, 250 ] 54488 0.562% 98.106% | |
( 250, 380 ] 46783 0.483% 98.589% | |
( 380, 580 ] 48544 0.501% 99.089% | |
( 580, 870 ] 46217 0.477% 99.566% | |
( 870, 1300 ] 25393 0.262% 99.829% | |
( 1300, 1900 ] 9181 0.095% 99.923% | |
( 1900, 2900 ] 3290 0.034% 99.957% | |
( 2900, 4400 ] 1120 0.012% 99.969% | |
( 4400, 6600 ] 524 0.005% 99.974% | |
( 6600, 9900 ] 573 0.006% 99.980% | |
( 9900, 14000 ] 687 0.007% 99.987% | |
( 14000, 22000 ] 1461 0.015% 100.002% | |
( 22000, 33000 ] 361 0.004% 100.006% | |
( 33000, 50000 ] 5 0.000% 100.006% | |
** Level 6 read latency histogram (micros): | |
Count: 11416300 Average: 195.5820 StdDev: 289.99 | |
Min: 0 Median: 12.4306 Max: 73850 | |
Percentiles: P50: 12.43 P75: 136.31 P99: 1704.98 P99.9: 18935.61 P99.99: 27910.27 | |
------------------------------------------------------ | |
[ 0, 1 ] 7158 0.063% 0.063% | |
( 1, 2 ] 41672 0.365% 0.428% | |
( 2, 3 ] 189784 1.662% 2.090% | |
( 3, 4 ] 380425 3.332% 5.422% # | |
( 4, 6 ] 601550 5.269% 10.692% # | |
( 6, 10 ] 2461871 21.565% 32.256% #### | |
( 10, 15 ] 4167008 36.501% 68.757% ####### | |
( 15, 22 ] 499453 4.375% 73.132% # | |
( 22, 34 ] 63582 0.557% 73.689% | |
( 34, 51 ] 70841 0.621% 74.309% | |
( 51, 76 ] 55725 0.488% 74.797% | |
( 76, 110 ] 4478 0.039% 74.836% | |
( 110, 170 ] 42595 0.373% 75.209% | |
( 170, 250 ] 811929 7.112% 82.322% # | |
( 250, 380 ] 549854 4.816% 87.138% # | |
( 380, 580 ] 532161 4.661% 91.799% # | |
( 580, 870 ] 488073 4.275% 96.075% # | |
( 870, 1300 ] 270963 2.373% 98.448% | |
( 1300, 1900 ] 93361 0.818% 99.266% | |
( 1900, 2900 ] 29538 0.259% 99.525% | |
( 2900, 4400 ] 9378 0.082% 99.607% | |
( 4400, 6600 ] 4977 0.044% 99.650% | |
( 6600, 9900 ] 7125 0.062% 99.713% | |
( 9900, 14000 ] 9019 0.079% 99.792% | |
( 14000, 22000 ] 20040 0.176% 99.967% | |
( 22000, 33000 ] 4836 0.042% 100.010% | |
( 33000, 50000 ] 123 0.001% 100.011% | |
( 50000, 75000 ] 10 0.000% 100.011% | |
*************************** 5. row *************************** | |
Type: MEMORY_STATS | |
Name: rocksdb | |
Status: | |
MemTable Total: 626199784 | |
MemTable Unflushed: 48790040 | |
Table Readers Total: 0 | |
Cache Total: 107371963992 | |
Default Cache Capacity: 0 | |
*************************** 6. row *************************** | |
Type: BG_THREADS | |
Name: 140141721003776 | |
Status: | |
thread_type: High Pri | |
cf_name: | |
operation_type: | |
operation_stage: | |
elapsed_time_ms: | |
state_type: | |
*************************** 7. row *************************** | |
Type: BG_THREADS | |
Name: 140141729396480 | |
Status: | |
thread_type: High Pri | |
cf_name: | |
operation_type: | |
operation_stage: | |
elapsed_time_ms: | |
state_type: | |
*************************** 8. row *************************** | |
Type: BG_THREADS | |
Name: 140141737789184 | |
Status: | |
thread_type: Low Pri | |
cf_name: default | |
operation_type: Compaction | |
operation_stage: CompactionJob::ProcessKeyValueCompaction | |
elapsed_time_ms: 1843.673 ms | |
BaseInputLevel: 4 | |
BytesRead: 88660485 | |
BytesWritten: 163056053 | |
IsDeletion: 0 | |
IsManual: 0 | |
IsTrivialMove: 0 | |
JobID: 3001 | |
OutputLevel: 5 | |
TotalInputBytes: 237216371 | |
state_type: | |
*************************** 9. row *************************** | |
Type: BG_THREADS | |
Name: 140141746181888 | |
Status: | |
thread_type: Low Pri | |
cf_name: default | |
operation_type: Compaction | |
operation_stage: CompactionJob::ProcessKeyValueCompaction | |
elapsed_time_ms: 2790.400 ms | |
BaseInputLevel: 4 | |
BytesRead: 72487280 | |
BytesWritten: 71591742 | |
IsDeletion: 0 | |
IsManual: 0 | |
IsTrivialMove: 0 | |
JobID: 3000 | |
OutputLevel: 5 | |
TotalInputBytes: 254820283 | |
state_type: | |
*************************** 10. row *************************** | |
Type: BG_THREADS | |
Name: 140141754574592 | |
Status: | |
thread_type: Low Pri | |
cf_name: default | |
operation_type: Compaction | |
operation_stage: CompactionJob::ProcessKeyValueCompaction | |
elapsed_time_ms: 2869.241 ms | |
BaseInputLevel: 4 | |
BytesRead: 117868706 | |
BytesWritten: 237183157 | |
IsDeletion: 0 | |
IsManual: 0 | |
IsTrivialMove: 0 | |
JobID: 2998 | |
OutputLevel: 5 | |
TotalInputBytes: 241659821 | |
state_type: | |
*************************** 11. row *************************** | |
Type: BG_THREADS | |
Name: 140141845448448 | |
Status: | |
thread_type: Low Pri | |
cf_name: default | |
operation_type: Compaction | |
operation_stage: CompactionJob::ProcessKeyValueCompaction | |
elapsed_time_ms: 334.924 ms | |
BaseInputLevel: 4 | |
BytesRead: 19181279 | |
BytesWritten: 21977313 | |
IsDeletion: 0 | |
IsManual: 0 | |
IsTrivialMove: 0 | |
JobID: 3006 | |
OutputLevel: 5 | |
TotalInputBytes: 199770665 | |
state_type: | |
*************************** 12. row *************************** | |
Type: BG_THREADS | |
Name: 140141853841152 | |
Status: | |
thread_type: Low Pri | |
cf_name: default | |
operation_type: Compaction | |
operation_stage: CompactionJob::ProcessKeyValueCompaction | |
elapsed_time_ms: 577.132 ms | |
BaseInputLevel: 4 | |
BytesRead: 15064235 | |
BytesWritten: 48267425 | |
IsDeletion: 0 | |
IsManual: 0 | |
IsTrivialMove: 0 | |
JobID: 3004 | |
OutputLevel: 5 | |
TotalInputBytes: 123810958 | |
state_type: | |
*************************** 13. row *************************** | |
Type: BG_THREADS | |
Name: 140141862233856 | |
Status: | |
thread_type: Low Pri | |
cf_name: default | |
operation_type: Compaction | |
operation_stage: CompactionJob::ProcessKeyValueCompaction | |
elapsed_time_ms: 574.945 ms | |
BaseInputLevel: 4 | |
BytesRead: 17292973 | |
BytesWritten: 44120412 | |
IsDeletion: 0 | |
IsManual: 0 | |
IsTrivialMove: 0 | |
JobID: 3005 | |
OutputLevel: 5 | |
TotalInputBytes: 174297401 | |
state_type: |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment