[root@ecosd1 db]# ceph-kvstore-tool rocksdb . stats 2019-10-30 09:27:38.992 7f985d615f80 1 rocksdb: do_open column families: [default] db_statistics { "rocksdb_compaction_statistics": "", "": "", "": "** 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) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop", "": "----------------------------------------------------------------------------------------------------------------------------------------------------------------------------", "": " L0 7/7 49.28 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0", "": " L1 13/13 178.47 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0", "": " L2 90/0 1.35 GB 0.6 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0", "": " L3 241/0 3.56 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0", "": " Sum 351/20 5.13 GB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0", "": " Int 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0", "": "", "": "** Compaction Stats [default] **", "": "Priority 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", "": "-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------", "": "Uptime(secs): 0.0 total, 0.0 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 [default] **", "": "** Level 0 read latency histogram (micros):", "": "Count: 44 Average: 58.6818 StdDev: 160.49", "": "Min: 0 Median: 2.6000 Max: 912", "": "Percentiles: P50: 2.60 P75: 12.50 P99: 912.00 P99.9: 912.00 P99.99: 912.00", "": "------------------------------------------------------", "": "[ 0, 1 ] 7 15.909% 15.909% ###", "": "( 1, 2 ] 12 27.273% 43.182% #####", "": "( 2, 3 ] 5 11.364% 54.545% ##", "": "( 3, 4 ] 2 4.545% 59.091% #", "": "( 4, 6 ] 4 9.091% 68.182% ##", "": "( 6, 10 ] 2 4.545% 72.727% #", "": "( 10, 15 ] 2 4.545% 77.273% #", "": "( 15, 22 ] 2 4.545% 81.818% #", "": "( 76, 110 ] 3 6.818% 88.636% #", "": "( 170, 250 ] 2 4.545% 93.182% #", "": "( 250, 380 ] 1 2.273% 95.455% ", "": "( 380, 580 ] 1 2.273% 97.727% ", "": "( 870, 1300 ] 1 2.273% 100.000% ", "": "", "": "** Level 1 read latency histogram (micros):", "": "Count: 63 Average: 4.1746 StdDev: 13.77", "": "Min: 0 Median: 1.6905 Max: 112", "": "Percentiles: P50: 1.69 P75: 2.66 P99: 112.00 P99.9: 112.00 P99.99: 112.00", "": "------------------------------------------------------", "": "[ 0, 1 ] 17 26.984% 26.984% #####", "": "( 1, 2 ] 21 33.333% 60.317% #######", "": "( 2, 3 ] 14 22.222% 82.540% ####", "": "( 3, 4 ] 4 6.349% 88.889% #", "": "( 4, 6 ] 4 6.349% 95.238% #", "": "( 6, 10 ] 2 3.175% 98.413% #", "": "( 110, 170 ] 1 1.587% 100.000% ", "": "", "": "** Level 2 read latency histogram (micros):", "": "Count: 270 Average: 1.5037 StdDev: 0.83", "": "Min: 0 Median: 0.9060 Max: 7", "": "Percentiles: P50: 0.91 P75: 1.55 P99: 3.43 P99.9: 7.00 P99.99: 7.00", "": "------------------------------------------------------", "": "[ 0, 1 ] 149 55.185% 55.185% ###########", "": "( 1, 2 ] 97 35.926% 91.111% #######", "": "( 2, 3 ] 20 7.407% 98.519% #", "": "( 3, 4 ] 3 1.111% 99.630% ", "": "( 6, 10 ] 1 0.370% 100.000% ", "": "", "": "** Level 3 read latency histogram (micros):", "": "Count: 723 Average: 1.4896 StdDev: 0.78", "": "Min: 0 Median: 0.9341 Max: 4", "": "Percentiles: P50: 0.93 P75: 1.57 P99: 2.98 P99.9: 3.88 P99.99: 3.99", "": "------------------------------------------------------", "": "[ 0, 1 ] 387 53.527% 53.527% ###########", "": "( 1, 2 ] 270 37.344% 90.871% #######", "": "( 2, 3 ] 60 8.299% 99.170% ##", "": "( 3, 4 ] 6 0.830% 100.000% ", "": "", "": "", "": "** DB Stats **", "": "Uptime(secs): 0.0 total, 0.0 interval", "": "Cumulative writes: 0 writes, 0 keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.00 GB, 0.00 MB/s", "": "Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s", "": "Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent", "": "Interval writes: 0 writes, 0 keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.00 MB, 0.00 MB/s", "": "Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 MB, 0.00 MB/s", "": "Interval stall: 00:00:0.000 H:M:S, 0.0 percent" }