1
|
[root@ecosd1 db]# ceph-kvstore-tool rocksdb . stats
|
2
|
2019-10-30 09:27:38.992 7f985d615f80 1 rocksdb: do_open column families: [default]
|
3
|
db_statistics {
|
4
|
"rocksdb_compaction_statistics": "",
|
5
|
"": "",
|
6
|
"": "** Compaction Stats [default] **",
|
7
|
"": "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",
|
8
|
"": "----------------------------------------------------------------------------------------------------------------------------------------------------------------------------",
|
9
|
"": " 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",
|
10
|
"": " 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",
|
11
|
"": " 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",
|
12
|
"": " 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",
|
13
|
"": " 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",
|
14
|
"": " 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",
|
15
|
"": "",
|
16
|
"": "** Compaction Stats [default] **",
|
17
|
"": "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",
|
18
|
"": "-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------",
|
19
|
"": "Uptime(secs): 0.0 total, 0.0 interval",
|
20
|
"": "Flush(GB): cumulative 0.000, interval 0.000",
|
21
|
"": "AddFile(GB): cumulative 0.000, interval 0.000",
|
22
|
"": "AddFile(Total Files): cumulative 0, interval 0",
|
23
|
"": "AddFile(L0 Files): cumulative 0, interval 0",
|
24
|
"": "AddFile(Keys): cumulative 0, interval 0",
|
25
|
"": "Cumulative compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds",
|
26
|
"": "Interval compaction: 0.00 GB write, 0.00 MB/s write, 0.00 GB read, 0.00 MB/s read, 0.0 seconds",
|
27
|
"": "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",
|
28
|
"": "",
|
29
|
"": "** File Read Latency Histogram By Level [default] **",
|
30
|
"": "** Level 0 read latency histogram (micros):",
|
31
|
"": "Count: 44 Average: 58.6818 StdDev: 160.49",
|
32
|
"": "Min: 0 Median: 2.6000 Max: 912",
|
33
|
"": "Percentiles: P50: 2.60 P75: 12.50 P99: 912.00 P99.9: 912.00 P99.99: 912.00",
|
34
|
"": "------------------------------------------------------",
|
35
|
"": "[ 0, 1 ] 7 15.909% 15.909% ###",
|
36
|
"": "( 1, 2 ] 12 27.273% 43.182% #####",
|
37
|
"": "( 2, 3 ] 5 11.364% 54.545% ##",
|
38
|
"": "( 3, 4 ] 2 4.545% 59.091% #",
|
39
|
"": "( 4, 6 ] 4 9.091% 68.182% ##",
|
40
|
"": "( 6, 10 ] 2 4.545% 72.727% #",
|
41
|
"": "( 10, 15 ] 2 4.545% 77.273% #",
|
42
|
"": "( 15, 22 ] 2 4.545% 81.818% #",
|
43
|
"": "( 76, 110 ] 3 6.818% 88.636% #",
|
44
|
"": "( 170, 250 ] 2 4.545% 93.182% #",
|
45
|
"": "( 250, 380 ] 1 2.273% 95.455% ",
|
46
|
"": "( 380, 580 ] 1 2.273% 97.727% ",
|
47
|
"": "( 870, 1300 ] 1 2.273% 100.000% ",
|
48
|
"": "",
|
49
|
"": "** Level 1 read latency histogram (micros):",
|
50
|
"": "Count: 63 Average: 4.1746 StdDev: 13.77",
|
51
|
"": "Min: 0 Median: 1.6905 Max: 112",
|
52
|
"": "Percentiles: P50: 1.69 P75: 2.66 P99: 112.00 P99.9: 112.00 P99.99: 112.00",
|
53
|
"": "------------------------------------------------------",
|
54
|
"": "[ 0, 1 ] 17 26.984% 26.984% #####",
|
55
|
"": "( 1, 2 ] 21 33.333% 60.317% #######",
|
56
|
"": "( 2, 3 ] 14 22.222% 82.540% ####",
|
57
|
"": "( 3, 4 ] 4 6.349% 88.889% #",
|
58
|
"": "( 4, 6 ] 4 6.349% 95.238% #",
|
59
|
"": "( 6, 10 ] 2 3.175% 98.413% #",
|
60
|
"": "( 110, 170 ] 1 1.587% 100.000% ",
|
61
|
"": "",
|
62
|
"": "** Level 2 read latency histogram (micros):",
|
63
|
"": "Count: 270 Average: 1.5037 StdDev: 0.83",
|
64
|
"": "Min: 0 Median: 0.9060 Max: 7",
|
65
|
"": "Percentiles: P50: 0.91 P75: 1.55 P99: 3.43 P99.9: 7.00 P99.99: 7.00",
|
66
|
"": "------------------------------------------------------",
|
67
|
"": "[ 0, 1 ] 149 55.185% 55.185% ###########",
|
68
|
"": "( 1, 2 ] 97 35.926% 91.111% #######",
|
69
|
"": "( 2, 3 ] 20 7.407% 98.519% #",
|
70
|
"": "( 3, 4 ] 3 1.111% 99.630% ",
|
71
|
"": "( 6, 10 ] 1 0.370% 100.000% ",
|
72
|
"": "",
|
73
|
"": "** Level 3 read latency histogram (micros):",
|
74
|
"": "Count: 723 Average: 1.4896 StdDev: 0.78",
|
75
|
"": "Min: 0 Median: 0.9341 Max: 4",
|
76
|
"": "Percentiles: P50: 0.93 P75: 1.57 P99: 2.98 P99.9: 3.88 P99.99: 3.99",
|
77
|
"": "------------------------------------------------------",
|
78
|
"": "[ 0, 1 ] 387 53.527% 53.527% ###########",
|
79
|
"": "( 1, 2 ] 270 37.344% 90.871% #######",
|
80
|
"": "( 2, 3 ] 60 8.299% 99.170% ##",
|
81
|
"": "( 3, 4 ] 6 0.830% 100.000% ",
|
82
|
"": "",
|
83
|
"": "",
|
84
|
"": "** DB Stats **",
|
85
|
"": "Uptime(secs): 0.0 total, 0.0 interval",
|
86
|
"": "Cumulative writes: 0 writes, 0 keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.00 GB, 0.00 MB/s",
|
87
|
"": "Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s",
|
88
|
"": "Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent",
|
89
|
"": "Interval writes: 0 writes, 0 keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.00 MB, 0.00 MB/s",
|
90
|
"": "Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 MB, 0.00 MB/s",
|
91
|
"": "Interval stall: 00:00:0.000 H:M:S, 0.0 percent"
|
92
|
}
|