Project

General

Profile

ceph-kvstore-tool_rocksdb_stats.txt

as per filename - Marcin W, 10/30/2019 09:31 AM

Download (6.58 KB)

 
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
}