[2024-12-13 16:14:17.371256] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 23.11.0 initialization... [2024-12-13 16:14:17.371522] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1455051 ] Set seed to 1734102857364604 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-13 16:14:17.479765] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-13 16:14:17.521300] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-13 16:14:17.521348] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1455051' to capture a snapshot of events at runtime. [2024-12-13 16:14:17.521359] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-13 16:14:17.521370] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-13 16:14:17.521377] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1455051 for offline analysis/debug. [2024-12-13 16:14:17.521470] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 13 16:14:21 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/13-16:14:24 ... thread 0: (1000000,1000000) ops and (332758.4,332758.4) ops/second in (3.005183,3.005183) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/6 503.99 MB 6.3 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 339.7 2.60 2.34 12 0.216 0 0 0.0 0.0 L1 3/3 188.89 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 241.9 241.7 0.78 0.75 1 0.782 191K 118 0.0 0.0 L2 1/0 1.92 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.2 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 21/0 1.15 GB 1.2 0.2 0.2 0.0 0.2 0.2 0.1 1.0 223.3 223.3 0.84 0.77 1 0.837 189K 0 0.0 0.0 L4 116/0 9.54 GB 1.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 0.0 0.0 L5 1040/0 85.63 GB 0.9 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 0.0 0.0 Sum 1188/9 97.00 GB 0.0 0.6 0.5 0.1 1.4 1.4 0.5 1.6 113.5 290.6 4.98 4.59 15 0.332 573K 191 0.0 0.0 Int 0/0 0.00 KB 0.0 0.6 0.5 0.1 1.4 1.4 0.4 1.6 113.5 290.6 4.98 4.59 15 0.332 573K 191 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.6 0.5 0.1 0.6 0.5 0.0 0.0 237.2 237.1 2.38 2.25 3 0.794 573K 191 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 339.7 2.60 2.34 12 0.216 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 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: 1.41 GB write, 448.35 MB/s write, 0.55 GB read, 175.07 MB/s read, 5.0 seconds Interval compaction: 1.41 GB write, 481.09 MB/s write, 0.55 GB read, 187.86 MB/s read, 5.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 101375 Average: 1.8776 StdDev: 19.77 Min: 1 Median: 1.1880 Max: 3614 Percentiles: P50: 1.19 P75: 1.64 P99: 3.91 P99.9: 9.65 P99.99: 290.35 ------------------------------------------------------ [ 0, 1 ] 40247 39.701% 39.701% ######## ( 1, 2 ] 55542 54.789% 94.490% ########### ( 2, 3 ] 3499 3.452% 97.941% # ( 3, 4 ] 1179 1.163% 99.104% ( 4, 6 ] 626 0.618% 99.722% ( 6, 10 ] 198 0.195% 99.917% ( 10, 15 ] 49 0.048% 99.965% ( 15, 22 ] 7 0.007% 99.972% ( 22, 34 ] 1 0.001% 99.973% ( 51, 76 ] 3 0.003% 99.976% ( 110, 170 ] 6 0.006% 99.982% ( 170, 250 ] 6 0.006% 99.988% ( 250, 380 ] 6 0.006% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 2 0.002% 99.997% ( 2900, 4400 ] 3 0.003% 100.000% ** Level 1 read latency histogram (micros): Count: 2257 Average: 7.9145 StdDev: 131.62 Min: 1 Median: 1.1933 Max: 4430 Percentiles: P50: 1.19 P75: 1.65 P99: 4.10 P99.9: 2643.00 P99.99: 4430.00 ------------------------------------------------------ [ 0, 1 ] 888 39.344% 39.344% ######## ( 1, 2 ] 1244 55.117% 94.462% ########### ( 2, 3 ] 82 3.633% 98.095% # ( 3, 4 ] 20 0.886% 98.981% ( 4, 6 ] 9 0.399% 99.380% ( 6, 10 ] 4 0.177% 99.557% ( 10, 15 ] 1 0.044% 99.601% ( 170, 250 ] 1 0.044% 99.646% ( 380, 580 ] 2 0.089% 99.734% ( 580, 870 ] 1 0.044% 99.778% ( 870, 1300 ] 2 0.089% 99.867% ( 1900, 2900 ] 1 0.044% 99.911% ( 2900, 4400 ] 1 0.044% 99.956% ( 4400, 6600 ] 1 0.044% 100.000% ** Level 2 read latency histogram (micros): Count: 47472 Average: 1.8889 StdDev: 4.95 Min: 1 Median: 1.3038 Max: 893 Percentiles: P50: 1.30 P75: 1.72 P99: 5.50 P99.9: 11.30 P99.99: 25.03 ------------------------------------------------------ [ 0, 1 ] 15094 31.796% 31.796% ###### ( 1, 2 ] 28444 59.917% 91.713% ############ ( 2, 3 ] 2112 4.449% 96.162% # ( 3, 4 ] 909 1.915% 98.077% ( 4, 6 ] 586 1.234% 99.311% ( 6, 10 ] 265 0.558% 99.869% ( 10, 15 ] 56 0.118% 99.987% ( 15, 22 ] 1 0.002% 99.989% ( 22, 34 ] 1 0.002% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 100 Average: 983.2800 StdDev: 1211.22 Min: 1 Median: 460.0000 Max: 4997 Percentiles: P50: 460.00 P75: 1750.00 P99: 4997.00 P99.9: 4997.00 P99.99: 4997.00 ------------------------------------------------------ [ 0, 1 ] 24 24.000% 24.000% ##### ( 1, 2 ] 10 10.000% 34.000% ## ( 3, 4 ] 4 4.000% 38.000% # ( 6, 10 ] 2 2.000% 40.000% ( 110, 170 ] 1 1.000% 41.000% ( 170, 250 ] 1 1.000% 42.000% ( 250, 380 ] 4 4.000% 46.000% # ( 380, 580 ] 10 10.000% 56.000% ## ( 580, 870 ] 4 4.000% 60.000% # ( 870, 1300 ] 12 12.000% 72.000% ## ( 1300, 1900 ] 4 4.000% 76.000% # ( 1900, 2900 ] 15 15.000% 91.000% ### ( 2900, 4400 ] 7 7.000% 98.000% # ( 4400, 6600 ] 2 2.000% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1892.7000 StdDev: 1554.92 Min: 352 Median: 1300.0000 Max: 5184 Percentiles: P50: 1300.00 P75: 2566.67 P99: 5184.00 P99.9: 5184.00 P99.99: 5184.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 4 20.000% 35.000% #### ( 870, 1300 ] 3 15.000% 50.000% ### ( 1300, 1900 ] 3 15.000% 65.000% ### ( 1900, 2900 ] 3 15.000% 80.000% ### ( 2900, 4400 ] 1 5.000% 85.000% # ( 4400, 6600 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 305.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.436 H:M:S, 13.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.436 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-16:14:27 ... thread 0: (1000000,2000000) ops and (327980.6,330352.2) ops/second in (3.048961,6.054144) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/4 1007.32 MB 75.5 0.6 0.0 0.6 2.3 1.8 0.0 1.3 76.0 321.0 7.46 6.86 27 0.276 575K 613 0.0 0.0 L1 2/0 113.03 MB 11.3 0.8 0.6 0.2 0.8 0.6 0.2 1.3 231.6 231.0 3.54 3.44 2 1.768 831K 1782 0.0 0.0 L2 1/0 1.92 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 15/0 897.22 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 223.3 223.3 0.84 0.77 1 0.837 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 135.7 135.8 1.24 0.85 1 1.239 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1247/4 97.92 GB 0.0 1.9 1.1 0.8 3.7 2.9 2.7 2.1 139.5 271.4 13.83 12.65 32 0.432 1959K 2468 0.0 0.0 Int 0/0 0.00 KB 0.0 1.9 1.1 0.8 3.7 2.9 2.6 2.1 139.5 271.4 13.83 12.65 32 0.432 1959K 2468 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.9 1.1 0.8 1.9 1.1 0.0 0.0 225.6 225.3 8.55 7.92 7 1.222 1959K 2468 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 346.2 5.28 4.73 25 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.1 interval Flush(GB): cumulative 1.784, interval 1.784 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: 3.67 GB write, 598.24 MB/s write, 1.88 GB read, 307.54 MB/s read, 13.8 seconds Interval compaction: 3.67 GB write, 619.94 MB/s write, 1.88 GB read, 318.69 MB/s read, 13.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 400799 Average: 2.0932 StdDev: 14.44 Min: 1 Median: 1.4191 Max: 3637 Percentiles: P50: 1.42 P75: 1.82 P99: 5.42 P99.9: 10.16 P99.99: 14.57 ------------------------------------------------------ [ 0, 1 ] 94837 23.662% 23.662% ##### ( 1, 2 ] 251866 62.841% 86.503% ############# ( 2, 3 ] 33573 8.377% 94.879% ## ( 3, 4 ] 11467 2.861% 97.741% # ( 4, 6 ] 7106 1.773% 99.513% ( 6, 10 ] 1537 0.383% 99.897% ( 10, 15 ] 409 0.102% 99.999% ( 15, 22 ] 21 0.005% 100.004% ( 22, 34 ] 4 0.001% 100.005% ( 34, 51 ] 2 0.000% 100.006% ( 51, 76 ] 6 0.001% 100.007% ( 110, 170 ] 10 0.002% 100.010% ( 170, 250 ] 13 0.003% 100.013% ( 250, 380 ] 13 0.003% 100.016% ( 380, 580 ] 4 0.001% 100.017% ( 580, 870 ] 3 0.001% 100.018% ( 870, 1300 ] 2 0.000% 100.018% ( 1300, 1900 ] 2 0.000% 100.019% ( 1900, 2900 ] 1 0.000% 100.019% ( 2900, 4400 ] 6 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 48000 Average: 2.5480 StdDev: 31.21 Min: 1 Median: 1.4931 Max: 4430 Percentiles: P50: 1.49 P75: 1.87 P99: 5.53 P99.9: 10.34 P99.99: 1231.20 ------------------------------------------------------ [ 0, 1 ] 8346 17.387% 17.387% ### ( 1, 2 ] 31748 66.142% 83.529% ############# ( 2, 3 ] 5066 10.554% 94.083% ## ( 3, 4 ] 1603 3.340% 97.423% # ( 4, 6 ] 987 2.056% 99.479% ( 6, 10 ] 200 0.417% 99.896% ( 10, 15 ] 29 0.060% 99.956% ( 34, 51 ] 1 0.002% 99.958% ( 170, 250 ] 2 0.004% 99.963% ( 250, 380 ] 4 0.008% 99.971% ( 380, 580 ] 3 0.006% 99.977% ( 580, 870 ] 2 0.004% 99.981% ( 870, 1300 ] 5 0.010% 99.992% ( 1300, 1900 ] 1 0.002% 99.994% ( 1900, 2900 ] 1 0.002% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47472 Average: 1.8889 StdDev: 4.95 Min: 1 Median: 1.3038 Max: 893 Percentiles: P50: 1.30 P75: 1.72 P99: 5.50 P99.9: 11.30 P99.99: 25.03 ------------------------------------------------------ [ 0, 1 ] 15094 31.796% 31.796% ###### ( 1, 2 ] 28444 59.917% 91.713% ############ ( 2, 3 ] 2112 4.449% 96.162% # ( 3, 4 ] 909 1.915% 98.077% ( 4, 6 ] 586 1.234% 99.311% ( 6, 10 ] 265 0.558% 99.869% ( 10, 15 ] 56 0.118% 99.987% ( 15, 22 ] 1 0.002% 99.989% ( 22, 34 ] 1 0.002% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42798 Average: 4.6935 StdDev: 75.31 Min: 1 Median: 1.6669 Max: 4997 Percentiles: P50: 1.67 P75: 2.21 P99: 6.22 P99.9: 667.15 P99.99: 3911.47 ------------------------------------------------------ [ 0, 1 ] 3455 8.073% 8.073% ## ( 1, 2 ] 26907 62.870% 70.943% ############# ( 2, 3 ] 8228 19.225% 90.168% #### ( 3, 4 ] 1940 4.533% 94.701% # ( 4, 6 ] 1822 4.257% 98.958% # ( 6, 10 ] 331 0.773% 99.731% ( 10, 15 ] 51 0.119% 99.850% ( 15, 22 ] 4 0.009% 99.860% ( 110, 170 ] 1 0.002% 99.862% ( 170, 250 ] 1 0.002% 99.864% ( 250, 380 ] 4 0.009% 99.874% ( 380, 580 ] 10 0.023% 99.897% ( 580, 870 ] 4 0.009% 99.907% ( 870, 1300 ] 12 0.028% 99.935% ( 1300, 1900 ] 4 0.009% 99.944% ( 1900, 2900 ] 15 0.035% 99.979% ( 2900, 4400 ] 7 0.016% 99.995% ( 4400, 6600 ] 2 0.005% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 128.8656 StdDev: 614.32 Min: 0 Median: 1.6213 Max: 5184 Percentiles: P50: 1.62 P75: 5.10 P99: 4325.00 P99.9: 5184.00 P99.99: 5184.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 136 44.590% 66.885% ######### ( 2, 3 ] 20 6.557% 73.443% # ( 3, 4 ] 2 0.656% 74.098% ( 4, 6 ] 5 1.639% 75.738% ( 6, 10 ] 46 15.082% 90.820% ### ( 10, 15 ] 6 1.967% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 580, 870 ] 4 1.311% 95.738% ( 870, 1300 ] 3 0.984% 96.721% ( 1300, 1900 ] 3 0.984% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 1 0.328% 99.016% ( 4400, 6600 ] 3 0.984% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 704.0250 StdDev: 943.04 Min: 76 Median: 150.0000 Max: 3426 Percentiles: P50: 150.00 P75: 870.00 P99: 3426.00 P99.9: 3426.00 P99.99: 3426.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 13 32.500% 35.000% ####### ( 110, 170 ] 9 22.500% 57.500% ##### ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 1 2.500% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.3 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 313.65 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.871 H:M:S, 13.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.80 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.435 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-16:14:30 ... thread 0: (1000000,3000000) ops and (331009.4,330571.0) ops/second in (3.021062,9.075206) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 1.97 GB 56.6 1.4 0.0 1.4 4.1 2.8 0.0 1.5 103.1 313.9 13.44 12.51 44 0.305 1407K 1512 0.0 0.0 L1 2/2 113.03 MB 0.0 0.8 0.6 0.2 0.8 0.6 0.2 1.3 231.6 231.0 3.54 3.44 2 1.768 831K 1782 0.0 0.0 L2 1/0 1.92 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 15/0 897.22 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 223.3 223.3 0.84 0.77 1 0.837 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 135.7 135.8 1.24 0.85 1 1.239 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/13 98.90 GB 0.0 2.7 1.1 1.6 5.4 3.8 2.7 2.0 138.7 281.6 19.82 18.30 49 0.404 2791K 3367 0.0 0.0 Int 0/0 0.00 KB 0.0 2.7 1.1 1.6 5.4 3.8 2.6 2.0 138.7 281.6 19.82 18.30 49 0.404 2791K 3367 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.7 1.1 1.6 2.7 1.1 0.0 0.0 235.0 234.7 11.70 11.02 10 1.170 2791K 3367 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 349.3 8.12 7.29 39 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 interval Flush(GB): cumulative 2.768, interval 2.768 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: 5.45 GB write, 600.24 MB/s write, 2.68 GB read, 295.69 MB/s read, 19.8 seconds Interval compaction: 5.45 GB write, 614.76 MB/s write, 2.68 GB read, 302.84 MB/s read, 19.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 728993 Average: 2.1022 StdDev: 14.55 Min: 0 Median: 1.4330 Max: 5756 Percentiles: P50: 1.43 P75: 1.82 P99: 5.38 P99.9: 9.95 P99.99: 14.17 ------------------------------------------------------ [ 0, 1 ] 162114 22.238% 22.238% #### ( 1, 2 ] 467394 64.115% 86.353% ############# ( 2, 3 ] 62368 8.555% 94.908% ## ( 3, 4 ] 21289 2.920% 97.829% # ( 4, 6 ] 12350 1.694% 99.523% ( 6, 10 ] 2783 0.382% 99.905% ( 10, 15 ] 746 0.102% 100.007% ( 15, 22 ] 47 0.006% 100.013% ( 22, 34 ] 7 0.001% 100.014% ( 34, 51 ] 4 0.001% 100.015% ( 51, 76 ] 6 0.001% 100.016% ( 110, 170 ] 16 0.002% 100.018% ( 170, 250 ] 18 0.002% 100.020% ( 250, 380 ] 19 0.003% 100.023% ( 380, 580 ] 9 0.001% 100.024% ( 580, 870 ] 7 0.001% 100.025% ( 870, 1300 ] 5 0.001% 100.026% ( 1300, 1900 ] 4 0.001% 100.026% ( 1900, 2900 ] 1 0.000% 100.027% ( 2900, 4400 ] 8 0.001% 100.028% ( 4400, 6600 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 48001 Average: 2.5481 StdDev: 31.21 Min: 1 Median: 1.4931 Max: 4430 Percentiles: P50: 1.49 P75: 1.87 P99: 5.53 P99.9: 10.34 P99.99: 1231.19 ------------------------------------------------------ [ 0, 1 ] 8346 17.387% 17.387% ### ( 1, 2 ] 31748 66.140% 83.527% ############# ( 2, 3 ] 5066 10.554% 94.081% ## ( 3, 4 ] 1604 3.342% 97.423% # ( 4, 6 ] 987 2.056% 99.479% ( 6, 10 ] 200 0.417% 99.896% ( 10, 15 ] 29 0.060% 99.956% ( 34, 51 ] 1 0.002% 99.958% ( 170, 250 ] 2 0.004% 99.963% ( 250, 380 ] 4 0.008% 99.971% ( 380, 580 ] 3 0.006% 99.977% ( 580, 870 ] 2 0.004% 99.981% ( 870, 1300 ] 5 0.010% 99.992% ( 1300, 1900 ] 1 0.002% 99.994% ( 1900, 2900 ] 1 0.002% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47472 Average: 1.8889 StdDev: 4.95 Min: 1 Median: 1.3038 Max: 893 Percentiles: P50: 1.30 P75: 1.72 P99: 5.50 P99.9: 11.30 P99.99: 25.03 ------------------------------------------------------ [ 0, 1 ] 15094 31.796% 31.796% ###### ( 1, 2 ] 28444 59.917% 91.713% ############ ( 2, 3 ] 2112 4.449% 96.162% # ( 3, 4 ] 909 1.915% 98.077% ( 4, 6 ] 586 1.234% 99.311% ( 6, 10 ] 265 0.558% 99.869% ( 10, 15 ] 56 0.118% 99.987% ( 15, 22 ] 1 0.002% 99.989% ( 22, 34 ] 1 0.002% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42798 Average: 4.6935 StdDev: 75.31 Min: 1 Median: 1.6669 Max: 4997 Percentiles: P50: 1.67 P75: 2.21 P99: 6.22 P99.9: 667.15 P99.99: 3911.47 ------------------------------------------------------ [ 0, 1 ] 3455 8.073% 8.073% ## ( 1, 2 ] 26907 62.870% 70.943% ############# ( 2, 3 ] 8228 19.225% 90.168% #### ( 3, 4 ] 1940 4.533% 94.701% # ( 4, 6 ] 1822 4.257% 98.958% # ( 6, 10 ] 331 0.773% 99.731% ( 10, 15 ] 51 0.119% 99.850% ( 15, 22 ] 4 0.009% 99.860% ( 110, 170 ] 1 0.002% 99.862% ( 170, 250 ] 1 0.002% 99.864% ( 250, 380 ] 4 0.009% 99.874% ( 380, 580 ] 10 0.023% 99.897% ( 580, 870 ] 4 0.009% 99.907% ( 870, 1300 ] 12 0.028% 99.935% ( 1300, 1900 ] 4 0.009% 99.944% ( 1900, 2900 ] 15 0.035% 99.979% ( 2900, 4400 ] 7 0.016% 99.995% ( 4400, 6600 ] 2 0.005% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 128.8656 StdDev: 614.32 Min: 0 Median: 1.6213 Max: 5184 Percentiles: P50: 1.62 P75: 5.10 P99: 4325.00 P99.9: 5184.00 P99.99: 5184.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 136 44.590% 66.885% ######### ( 2, 3 ] 20 6.557% 73.443% # ( 3, 4 ] 2 0.656% 74.098% ( 4, 6 ] 5 1.639% 75.738% ( 6, 10 ] 46 15.082% 90.820% ### ( 10, 15 ] 6 1.967% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 580, 870 ] 4 1.311% 95.738% ( 870, 1300 ] 3 0.984% 96.721% ( 1300, 1900 ] 3 0.984% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 1 0.328% 99.016% ( 4400, 6600 ] 3 0.984% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 704.0250 StdDev: 943.04 Min: 76 Median: 150.0000 Max: 3426 Percentiles: P50: 150.00 P75: 870.00 P99: 3426.00 P99.9: 3426.00 P99.99: 3426.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 13 32.500% 35.000% ####### ( 110, 170 ] 9 22.500% 57.500% ##### ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 1 2.500% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.3 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 317.59 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:1.307 H:M:S, 14.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.78 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.436 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-16:14:33 ... thread 0: (1000000,4000000) ops and (331432.9,330786.1) ops/second in (3.017202,12.092408) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/10 1.78 GB 0.0 2.2 0.0 2.2 5.8 3.7 0.0 1.6 113.6 308.3 19.40 18.12 60 0.323 2238K 2341 0.0 0.0 L1 11/11 1.21 GB 0.0 2.0 1.7 0.3 2.0 1.7 0.2 1.2 230.2 229.2 8.97 8.73 3 2.991 2096K 8443 0.0 0.0 L2 1/0 1.92 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 15/0 897.22 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 223.3 223.3 0.84 0.77 1 0.837 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 135.7 135.8 1.24 0.85 1 1.239 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/21 99.82 GB 0.0 4.7 2.2 2.5 8.4 5.9 2.7 2.3 154.2 274.9 31.22 29.21 66 0.473 4887K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 2.2 2.5 8.4 5.9 2.6 2.3 154.2 274.9 31.22 29.21 66 0.473 4887K 10K 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.7 2.2 2.5 4.7 2.2 0.0 0.0 236.5 236.0 20.35 19.47 14 1.454 4887K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 347.9 10.86 9.73 52 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.3 total, 12.1 interval Flush(GB): cumulative 3.691, interval 3.691 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: 8.38 GB write, 696.98 MB/s write, 4.70 GB read, 390.94 MB/s read, 31.2 seconds Interval compaction: 8.38 GB write, 709.63 MB/s write, 4.70 GB read, 398.04 MB/s read, 31.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 19, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1058911 Average: 2.1219 StdDev: 13.61 Min: 0 Median: 1.4502 Max: 5756 Percentiles: P50: 1.45 P75: 1.83 P99: 5.39 P99.9: 9.93 P99.99: 14.05 ------------------------------------------------------ [ 0, 1 ] 218525 20.637% 20.637% #### ( 1, 2 ] 690580 65.216% 85.853% ############# ( 2, 3 ] 94464 8.921% 94.774% ## ( 3, 4 ] 32127 3.034% 97.808% # ( 4, 6 ] 18168 1.716% 99.523% ( 6, 10 ] 4063 0.384% 99.907% ( 10, 15 ] 1086 0.103% 100.010% ( 15, 22 ] 64 0.006% 100.016% ( 22, 34 ] 10 0.001% 100.017% ( 34, 51 ] 6 0.001% 100.017% ( 51, 76 ] 7 0.001% 100.018% ( 76, 110 ] 15 0.001% 100.019% ( 110, 170 ] 22 0.002% 100.021% ( 170, 250 ] 26 0.002% 100.024% ( 250, 380 ] 23 0.002% 100.026% ( 380, 580 ] 13 0.001% 100.027% ( 580, 870 ] 12 0.001% 100.028% ( 870, 1300 ] 9 0.001% 100.029% ( 1300, 1900 ] 7 0.001% 100.030% ( 1900, 2900 ] 2 0.000% 100.030% ( 2900, 4400 ] 10 0.001% 100.031% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 79398 Average: 2.5436 StdDev: 29.16 Min: 0 Median: 1.4746 Max: 4430 Percentiles: P50: 1.47 P75: 1.85 P99: 5.40 P99.9: 11.29 P99.99: 1427.21 ------------------------------------------------------ [ 0, 1 ] 14459 18.211% 18.211% #### ( 1, 2 ] 53185 66.985% 85.196% ############# ( 2, 3 ] 7567 9.530% 94.727% ## ( 3, 4 ] 2454 3.091% 97.817% # ( 4, 6 ] 1340 1.688% 99.505% ( 6, 10 ] 303 0.382% 99.887% ( 10, 15 ] 45 0.057% 99.943% ( 15, 22 ] 4 0.005% 99.948% ( 22, 34 ] 1 0.001% 99.950% ( 34, 51 ] 1 0.001% 99.951% ( 170, 250 ] 3 0.004% 99.955% ( 250, 380 ] 7 0.009% 99.963% ( 380, 580 ] 10 0.013% 99.976% ( 580, 870 ] 4 0.005% 99.981% ( 870, 1300 ] 7 0.009% 99.990% ( 1300, 1900 ] 5 0.006% 99.996% ( 1900, 2900 ] 2 0.003% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ( 4400, 6600 ] 1 0.001% 100.001% ** Level 2 read latency histogram (micros): Count: 47472 Average: 1.8889 StdDev: 4.95 Min: 1 Median: 1.3038 Max: 893 Percentiles: P50: 1.30 P75: 1.72 P99: 5.50 P99.9: 11.30 P99.99: 25.03 ------------------------------------------------------ [ 0, 1 ] 15094 31.796% 31.796% ###### ( 1, 2 ] 28444 59.917% 91.713% ############ ( 2, 3 ] 2112 4.449% 96.162% # ( 3, 4 ] 909 1.915% 98.077% ( 4, 6 ] 586 1.234% 99.311% ( 6, 10 ] 265 0.558% 99.869% ( 10, 15 ] 56 0.118% 99.987% ( 15, 22 ] 1 0.002% 99.989% ( 22, 34 ] 1 0.002% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42798 Average: 4.6935 StdDev: 75.31 Min: 1 Median: 1.6669 Max: 4997 Percentiles: P50: 1.67 P75: 2.21 P99: 6.22 P99.9: 667.15 P99.99: 3911.47 ------------------------------------------------------ [ 0, 1 ] 3455 8.073% 8.073% ## ( 1, 2 ] 26907 62.870% 70.943% ############# ( 2, 3 ] 8228 19.225% 90.168% #### ( 3, 4 ] 1940 4.533% 94.701% # ( 4, 6 ] 1822 4.257% 98.958% # ( 6, 10 ] 331 0.773% 99.731% ( 10, 15 ] 51 0.119% 99.850% ( 15, 22 ] 4 0.009% 99.860% ( 110, 170 ] 1 0.002% 99.862% ( 170, 250 ] 1 0.002% 99.864% ( 250, 380 ] 4 0.009% 99.874% ( 380, 580 ] 10 0.023% 99.897% ( 580, 870 ] 4 0.009% 99.907% ( 870, 1300 ] 12 0.028% 99.935% ( 1300, 1900 ] 4 0.009% 99.944% ( 1900, 2900 ] 15 0.035% 99.979% ( 2900, 4400 ] 7 0.016% 99.995% ( 4400, 6600 ] 2 0.005% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 128.8656 StdDev: 614.32 Min: 0 Median: 1.6213 Max: 5184 Percentiles: P50: 1.62 P75: 5.10 P99: 4325.00 P99.9: 5184.00 P99.99: 5184.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 136 44.590% 66.885% ######### ( 2, 3 ] 20 6.557% 73.443% # ( 3, 4 ] 2 0.656% 74.098% ( 4, 6 ] 5 1.639% 75.738% ( 6, 10 ] 46 15.082% 90.820% ### ( 10, 15 ] 6 1.967% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 580, 870 ] 4 1.311% 95.738% ( 870, 1300 ] 3 0.984% 96.721% ( 1300, 1900 ] 3 0.984% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 1 0.328% 99.016% ( 4400, 6600 ] 3 0.984% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 704.0250 StdDev: 943.04 Min: 76 Median: 150.0000 Max: 3426 Percentiles: P50: 150.00 P75: 870.00 P99: 3426.00 P99.9: 3426.00 P99.99: 3426.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 13 32.500% 35.000% ####### ( 110, 170 ] 9 22.500% 57.500% ##### ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 1 2.500% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.3 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 319.70 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:1.734 H:M:S, 14.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.19 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.427 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-16:14:37 ... thread 0: (1000000,5000000) ops and (313259.1,327125.5) ops/second in (3.192246,15.284654) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 2.83 GB 81.8 2.7 0.0 2.7 7.4 4.7 0.0 1.6 112.6 309.5 24.62 22.98 76 0.324 2814K 2960 0.0 0.0 L1 11/11 1.21 GB 0.0 2.0 1.7 0.3 2.0 1.7 0.2 1.2 230.2 229.2 8.97 8.73 3 2.991 2096K 8443 0.0 0.0 L2 1/0 1.92 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 15/0 897.22 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 223.3 223.3 0.84 0.77 1 0.837 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 135.7 135.8 1.24 0.85 1 1.239 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/25 100.86 GB 0.0 5.3 2.2 3.1 10.0 6.9 2.7 2.1 147.7 280.6 36.43 34.06 82 0.444 5463K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 2.2 3.1 10.0 6.9 2.6 2.1 147.7 280.6 36.43 34.06 82 0.444 5463K 11K 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.3 2.2 3.1 5.2 2.2 0.0 0.0 238.8 238.2 22.54 21.62 16 1.409 5463K 11K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 349.2 13.89 12.45 66 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.5 total, 15.3 interval Flush(GB): cumulative 4.737, interval 4.737 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: 9.98 GB write, 659.08 MB/s write, 5.25 GB read, 347.02 MB/s read, 36.4 seconds Interval compaction: 9.98 GB write, 668.54 MB/s write, 5.25 GB read, 352.01 MB/s read, 36.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 25, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1339896 Average: 2.1517 StdDev: 13.27 Min: 0 Median: 1.4574 Max: 5756 Percentiles: P50: 1.46 P75: 1.84 P99: 5.45 P99.9: 10.21 P99.99: 14.49 ------------------------------------------------------ [ 0, 1 ] 269386 20.105% 20.105% #### ( 1, 2 ] 875784 65.362% 85.467% ############# ( 2, 3 ] 122839 9.168% 94.635% ## ( 3, 4 ] 41242 3.078% 97.713% # ( 4, 6 ] 23734 1.771% 99.484% ( 6, 10 ] 5513 0.411% 99.896% ( 10, 15 ] 1411 0.105% 100.001% ( 15, 22 ] 78 0.006% 100.007% ( 22, 34 ] 14 0.001% 100.008% ( 34, 51 ] 6 0.000% 100.008% ( 51, 76 ] 10 0.001% 100.009% ( 76, 110 ] 36 0.003% 100.012% ( 110, 170 ] 74 0.006% 100.017% ( 170, 250 ] 63 0.005% 100.022% ( 250, 380 ] 43 0.003% 100.025% ( 380, 580 ] 24 0.002% 100.027% ( 580, 870 ] 16 0.001% 100.028% ( 870, 1300 ] 17 0.001% 100.029% ( 1300, 1900 ] 10 0.001% 100.030% ( 1900, 2900 ] 3 0.000% 100.030% ( 2900, 4400 ] 11 0.001% 100.031% ( 4400, 6600 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 147950 Average: 2.5253 StdDev: 22.68 Min: 0 Median: 1.4647 Max: 4430 Percentiles: P50: 1.46 P75: 1.85 P99: 6.43 P99.9: 101.80 P99.99: 944.02 ------------------------------------------------------ [ 0, 1 ] 28848 19.498% 19.498% #### ( 1, 2 ] 97119 65.643% 85.142% ############# ( 2, 3 ] 13505 9.128% 94.270% ## ( 3, 4 ] 4333 2.929% 97.198% # ( 4, 6 ] 2533 1.712% 98.910% ( 6, 10 ] 1227 0.829% 99.740% ( 10, 15 ] 163 0.110% 99.850% ( 15, 22 ] 13 0.009% 99.859% ( 22, 34 ] 3 0.002% 99.861% ( 34, 51 ] 2 0.001% 99.862% ( 51, 76 ] 9 0.006% 99.868% ( 76, 110 ] 62 0.042% 99.910% ( 110, 170 ] 48 0.032% 99.943% ( 170, 250 ] 23 0.016% 99.958% ( 250, 380 ] 10 0.007% 99.965% ( 380, 580 ] 25 0.017% 99.982% ( 580, 870 ] 11 0.007% 99.989% ( 870, 1300 ] 7 0.005% 99.994% ( 1300, 1900 ] 5 0.003% 99.997% ( 1900, 2900 ] 2 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 47472 Average: 1.8889 StdDev: 4.95 Min: 1 Median: 1.3038 Max: 893 Percentiles: P50: 1.30 P75: 1.72 P99: 5.50 P99.9: 11.30 P99.99: 25.03 ------------------------------------------------------ [ 0, 1 ] 15094 31.796% 31.796% ###### ( 1, 2 ] 28444 59.917% 91.713% ############ ( 2, 3 ] 2112 4.449% 96.162% # ( 3, 4 ] 909 1.915% 98.077% ( 4, 6 ] 586 1.234% 99.311% ( 6, 10 ] 265 0.558% 99.869% ( 10, 15 ] 56 0.118% 99.987% ( 15, 22 ] 1 0.002% 99.989% ( 22, 34 ] 1 0.002% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42798 Average: 4.6935 StdDev: 75.31 Min: 1 Median: 1.6669 Max: 4997 Percentiles: P50: 1.67 P75: 2.21 P99: 6.22 P99.9: 667.15 P99.99: 3911.47 ------------------------------------------------------ [ 0, 1 ] 3455 8.073% 8.073% ## ( 1, 2 ] 26907 62.870% 70.943% ############# ( 2, 3 ] 8228 19.225% 90.168% #### ( 3, 4 ] 1940 4.533% 94.701% # ( 4, 6 ] 1822 4.257% 98.958% # ( 6, 10 ] 331 0.773% 99.731% ( 10, 15 ] 51 0.119% 99.850% ( 15, 22 ] 4 0.009% 99.860% ( 110, 170 ] 1 0.002% 99.862% ( 170, 250 ] 1 0.002% 99.864% ( 250, 380 ] 4 0.009% 99.874% ( 380, 580 ] 10 0.023% 99.897% ( 580, 870 ] 4 0.009% 99.907% ( 870, 1300 ] 12 0.028% 99.935% ( 1300, 1900 ] 4 0.009% 99.944% ( 1900, 2900 ] 15 0.035% 99.979% ( 2900, 4400 ] 7 0.016% 99.995% ( 4400, 6600 ] 2 0.005% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 128.8656 StdDev: 614.32 Min: 0 Median: 1.6213 Max: 5184 Percentiles: P50: 1.62 P75: 5.10 P99: 4325.00 P99.9: 5184.00 P99.99: 5184.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 136 44.590% 66.885% ######### ( 2, 3 ] 20 6.557% 73.443% # ( 3, 4 ] 2 0.656% 74.098% ( 4, 6 ] 5 1.639% 75.738% ( 6, 10 ] 46 15.082% 90.820% ### ( 10, 15 ] 6 1.967% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 580, 870 ] 4 1.311% 95.738% ( 870, 1300 ] 3 0.984% 96.721% ( 1300, 1900 ] 3 0.984% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 1 0.328% 99.016% ( 4400, 6600 ] 3 0.984% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 704.0250 StdDev: 943.04 Min: 76 Median: 150.0000 Max: 3426 Percentiles: P50: 150.00 P75: 870.00 P99: 3426.00 P99.9: 3426.00 P99.99: 3426.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 13 32.500% 35.000% ####### ( 110, 170 ] 9 22.500% 57.500% ##### ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 1 2.500% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.5 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 317.35 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:2.342 H:M:S, 15.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 308.31 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.608 H:M:S, 19.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-16:14:44 ... thread 0: (1000000,6000000) ops and (137553.9,266021.9) ops/second in (7.269879,22.554533) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/10 3.75 GB 201.3 4.4 0.0 4.4 10.0 5.7 0.0 1.8 132.6 304.3 33.72 31.70 96 0.351 4541K 5604 0.0 0.0 L1 11/11 1.21 GB 0.0 2.0 1.7 0.3 2.0 1.7 0.2 1.2 230.2 229.2 8.97 8.73 3 2.991 2096K 8443 0.0 0.0 L2 1/0 1.92 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.7 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 15/0 897.22 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.6 1.0 223.3 223.3 0.84 0.77 1 0.837 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.6 1.0 135.7 135.8 1.24 0.85 1 1.239 170K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/21 101.78 GB 0.0 6.9 2.2 4.7 12.6 7.8 2.7 2.2 155.5 282.5 45.53 42.79 102 0.446 7190K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 2.2 4.7 12.6 7.8 2.6 2.2 155.5 282.5 45.53 42.79 102 0.446 7190K 14K 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.9 2.2 4.7 6.9 2.2 0.0 0.0 244.8 244.3 28.93 27.92 21 1.378 7190K 14K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 349.0 16.61 14.87 81 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 22.8 total, 22.6 interval Flush(GB): cumulative 5.660, interval 5.660 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: 12.56 GB write, 564.74 MB/s write, 6.92 GB read, 310.92 MB/s read, 45.5 seconds Interval compaction: 12.56 GB write, 570.24 MB/s write, 6.92 GB read, 313.95 MB/s read, 45.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 25, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 25, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2000897 Average: 2.1586 StdDev: 12.66 Min: 0 Median: 1.4505 Max: 5756 Percentiles: P50: 1.45 P75: 1.83 P99: 5.45 P99.9: 10.71 P99.99: 81.81 ------------------------------------------------------ [ 0, 1 ] 405031 20.242% 20.242% #### ( 1, 2 ] 1321609 66.051% 86.293% ############# ( 2, 3 ] 171802 8.586% 94.880% ## ( 3, 4 ] 59076 2.952% 97.832% # ( 4, 6 ] 32165 1.608% 99.440% ( 6, 10 ] 8953 0.447% 99.887% ( 10, 15 ] 1841 0.092% 99.979% ( 15, 22 ] 145 0.007% 99.986% ( 22, 34 ] 17 0.001% 99.987% ( 34, 51 ] 9 0.000% 99.988% ( 51, 76 ] 25 0.001% 99.989% ( 76, 110 ] 140 0.007% 99.996% ( 110, 170 ] 236 0.012% 100.008% ( 170, 250 ] 123 0.006% 100.014% ( 250, 380 ] 81 0.004% 100.018% ( 380, 580 ] 61 0.003% 100.021% ( 580, 870 ] 38 0.002% 100.023% ( 870, 1300 ] 25 0.001% 100.024% ( 1300, 1900 ] 14 0.001% 100.025% ( 1900, 2900 ] 4 0.000% 100.025% ( 2900, 4400 ] 14 0.001% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 306130 Average: 2.4452 StdDev: 17.03 Min: 0 Median: 1.4613 Max: 4430 Percentiles: P50: 1.46 P75: 1.84 P99: 7.12 P99.9: 108.28 P99.99: 608.73 ------------------------------------------------------ [ 0, 1 ] 59094 19.304% 19.304% #### ( 1, 2 ] 203731 66.550% 85.854% ############# ( 2, 3 ] 25732 8.406% 94.260% ## ( 3, 4 ] 8495 2.775% 97.035% # ( 4, 6 ] 5139 1.679% 98.713% ( 6, 10 ] 3128 1.022% 99.735% ( 10, 15 ] 255 0.083% 99.818% ( 15, 22 ] 24 0.008% 99.826% ( 22, 34 ] 6 0.002% 99.828% ( 34, 51 ] 2 0.001% 99.829% ( 51, 76 ] 9 0.003% 99.832% ( 76, 110 ] 220 0.072% 99.904% ( 110, 170 ] 152 0.050% 99.953% ( 170, 250 ] 46 0.015% 99.968% ( 250, 380 ] 28 0.009% 99.977% ( 380, 580 ] 37 0.012% 99.990% ( 580, 870 ] 14 0.005% 99.994% ( 870, 1300 ] 9 0.003% 99.997% ( 1300, 1900 ] 5 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 99.999% ( 2900, 4400 ] 1 0.000% 100.000% ( 4400, 6600 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 47472 Average: 1.8889 StdDev: 4.95 Min: 1 Median: 1.3038 Max: 893 Percentiles: P50: 1.30 P75: 1.72 P99: 5.50 P99.9: 11.30 P99.99: 25.03 ------------------------------------------------------ [ 0, 1 ] 15094 31.796% 31.796% ###### ( 1, 2 ] 28444 59.917% 91.713% ############ ( 2, 3 ] 2112 4.449% 96.162% # ( 3, 4 ] 909 1.915% 98.077% ( 4, 6 ] 586 1.234% 99.311% ( 6, 10 ] 265 0.558% 99.869% ( 10, 15 ] 56 0.118% 99.987% ( 15, 22 ] 1 0.002% 99.989% ( 22, 34 ] 1 0.002% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42798 Average: 4.6935 StdDev: 75.31 Min: 1 Median: 1.6669 Max: 4997 Percentiles: P50: 1.67 P75: 2.21 P99: 6.22 P99.9: 667.15 P99.99: 3911.47 ------------------------------------------------------ [ 0, 1 ] 3455 8.073% 8.073% ## ( 1, 2 ] 26907 62.870% 70.943% ############# ( 2, 3 ] 8228 19.225% 90.168% #### ( 3, 4 ] 1940 4.533% 94.701% # ( 4, 6 ] 1822 4.257% 98.958% # ( 6, 10 ] 331 0.773% 99.731% ( 10, 15 ] 51 0.119% 99.850% ( 15, 22 ] 4 0.009% 99.860% ( 110, 170 ] 1 0.002% 99.862% ( 170, 250 ] 1 0.002% 99.864% ( 250, 380 ] 4 0.009% 99.874% ( 380, 580 ] 10 0.023% 99.897% ( 580, 870 ] 4 0.009% 99.907% ( 870, 1300 ] 12 0.028% 99.935% ( 1300, 1900 ] 4 0.009% 99.944% ( 1900, 2900 ] 15 0.035% 99.979% ( 2900, 4400 ] 7 0.016% 99.995% ( 4400, 6600 ] 2 0.005% 100.000% ** Level 4 read latency histogram (micros): Count: 305 Average: 128.8656 StdDev: 614.32 Min: 0 Median: 1.6213 Max: 5184 Percentiles: P50: 1.62 P75: 5.10 P99: 4325.00 P99.9: 5184.00 P99.99: 5184.00 ------------------------------------------------------ [ 0, 1 ] 68 22.295% 22.295% #### ( 1, 2 ] 136 44.590% 66.885% ######### ( 2, 3 ] 20 6.557% 73.443% # ( 3, 4 ] 2 0.656% 74.098% ( 4, 6 ] 5 1.639% 75.738% ( 6, 10 ] 46 15.082% 90.820% ### ( 10, 15 ] 6 1.967% 92.787% ( 170, 250 ] 1 0.328% 93.115% ( 250, 380 ] 2 0.656% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 580, 870 ] 4 1.311% 95.738% ( 870, 1300 ] 3 0.984% 96.721% ( 1300, 1900 ] 3 0.984% 97.705% ( 1900, 2900 ] 3 0.984% 98.689% ( 2900, 4400 ] 1 0.328% 99.016% ( 4400, 6600 ] 3 0.984% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 704.0250 StdDev: 943.04 Min: 76 Median: 150.0000 Max: 3426 Percentiles: P50: 150.00 P75: 870.00 P99: 3426.00 P99.9: 3426.00 P99.99: 3426.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 13 32.500% 35.000% ####### ( 110, 170 ] 9 22.500% 57.500% ##### ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 1 2.500% 77.500% # ( 1300, 1900 ] 3 7.500% 85.000% ## ( 1900, 2900 ] 4 10.000% 95.000% ## ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 22.8 total, 7.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 259.27 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:6.923 H:M:S, 30.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 135.38 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.580 H:M:S, 63.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-16:14:51 ... thread 0: (1000000,7000000) ops and (133535.3,232997.9) ops/second in (7.488655,30.043188) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/12 2.89 GB 25.2 5.1 0.0 5.1 11.7 6.6 0.0 1.8 130.9 299.6 39.93 37.06 113 0.353 5308K 6364 0.0 0.0 L1 17/17 1.95 GB 0.0 5.0 3.5 1.5 5.0 3.5 0.2 1.4 225.8 223.7 22.72 21.93 4 5.679 5208K 46K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 1.7 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 25/4 1.16 GB 1.0 1.9 1.2 0.7 1.9 1.2 0.6 1.6 211.4 210.6 9.13 8.39 5 1.826 1960K 7359 0.0 0.0 L4 176/4 9.74 GB 1.0 0.7 0.7 0.0 0.7 0.7 0.8 1.0 121.5 121.4 5.70 3.40 10 0.570 700K 847 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1287/37 102.66 GB 0.0 12.9 5.5 7.4 19.4 12.0 4.6 2.9 168.3 253.7 78.24 71.50 133 0.588 13M 60K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.9 5.5 7.4 19.4 12.0 4.5 2.9 168.3 253.7 78.24 71.50 133 0.588 13M 60K 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.9 5.5 7.4 12.8 5.4 0.0 0.0 225.0 224.0 58.53 54.18 38 1.540 13M 60K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 342.0 19.71 17.32 95 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 30.3 total, 30.0 interval Flush(GB): cumulative 6.583, interval 6.583 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: 19.38 GB write, 655.84 MB/s write, 12.86 GB read, 435.14 MB/s read, 78.2 seconds Interval compaction: 19.38 GB write, 660.63 MB/s write, 12.86 GB read, 438.32 MB/s read, 78.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 32, pending-compaction-bytes-delays: 7, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 32, interval: 52 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2514269 Average: 2.3178 StdDev: 18.20 Min: 0 Median: 1.4731 Max: 9870 Percentiles: P50: 1.47 P75: 1.85 P99: 5.75 P99.9: 13.01 P99.99: 169.95 ------------------------------------------------------ [ 0, 1 ] 474589 18.876% 18.876% #### ( 1, 2 ] 1654037 65.786% 84.662% ############# ( 2, 3 ] 231330 9.201% 93.863% ## ( 3, 4 ] 85175 3.388% 97.250% # ( 4, 6 ] 50182 1.996% 99.246% ( 6, 10 ] 14934 0.594% 99.840% ( 10, 15 ] 2506 0.100% 99.940% ( 15, 22 ] 194 0.008% 99.947% ( 22, 34 ] 22 0.001% 99.948% ( 34, 51 ] 12 0.000% 99.949% ( 51, 76 ] 54 0.002% 99.951% ( 76, 110 ] 426 0.017% 99.968% ( 110, 170 ] 558 0.022% 99.990% ( 170, 250 ] 287 0.011% 100.001% ( 250, 380 ] 184 0.007% 100.009% ( 380, 580 ] 181 0.007% 100.016% ( 580, 870 ] 104 0.004% 100.020% ( 870, 1300 ] 44 0.002% 100.022% ( 1300, 1900 ] 19 0.001% 100.023% ( 1900, 2900 ] 11 0.000% 100.023% ( 2900, 4400 ] 21 0.001% 100.024% ( 4400, 6600 ] 2 0.000% 100.024% ( 6600, 9900 ] 3 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 751176 Average: 2.8662 StdDev: 32.39 Min: 0 Median: 1.5690 Max: 11782 Percentiles: P50: 1.57 P75: 1.95 P99: 8.00 P99.9: 106.88 P99.99: 391.57 ------------------------------------------------------ [ 0, 1 ] 96965 12.908% 12.908% ### ( 1, 2 ] 489713 65.193% 78.101% ############# ( 2, 3 ] 94051 12.521% 90.622% ### ( 3, 4 ] 33273 4.429% 95.051% # ( 4, 6 ] 24509 3.263% 98.314% # ( 6, 10 ] 10285 1.369% 99.683% ( 10, 15 ] 1060 0.141% 99.824% ( 15, 22 ] 82 0.011% 99.835% ( 22, 34 ] 11 0.001% 99.837% ( 34, 51 ] 2 0.000% 99.837% ( 51, 76 ] 47 0.006% 99.843% ( 76, 110 ] 470 0.063% 99.906% ( 110, 170 ] 368 0.049% 99.955% ( 170, 250 ] 157 0.021% 99.976% ( 250, 380 ] 101 0.013% 99.989% ( 380, 580 ] 119 0.016% 100.005% ( 580, 870 ] 65 0.009% 100.014% ( 870, 1300 ] 41 0.005% 100.019% ( 1300, 1900 ] 19 0.003% 100.022% ( 1900, 2900 ] 6 0.001% 100.022% ( 2900, 4400 ] 10 0.001% 100.024% ( 4400, 6600 ] 4 0.001% 100.024% ( 6600, 9900 ] 3 0.000% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ** Level 2 read latency histogram (micros): Count: 47960 Average: 2.2167 StdDev: 11.84 Min: 1 Median: 1.3067 Max: 941 Percentiles: P50: 1.31 P75: 1.73 P99: 5.74 P99.9: 150.13 P99.99: 599.72 ------------------------------------------------------ [ 0, 1 ] 15197 31.687% 31.687% ###### ( 1, 2 ] 28639 59.714% 91.401% ############ ( 2, 3 ] 2197 4.581% 95.982% # ( 3, 4 ] 925 1.929% 97.911% ( 4, 6 ] 601 1.253% 99.164% ( 6, 10 ] 275 0.573% 99.737% ( 10, 15 ] 56 0.117% 99.854% ( 15, 22 ] 1 0.002% 99.856% ( 22, 34 ] 1 0.002% 99.858% ( 76, 110 ] 8 0.017% 99.875% ( 110, 170 ] 18 0.038% 99.912% ( 170, 250 ] 20 0.042% 99.954% ( 250, 380 ] 10 0.021% 99.975% ( 380, 580 ] 7 0.015% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 255944 Average: 3.9244 StdDev: 63.38 Min: 0 Median: 1.8259 Max: 8019 Percentiles: P50: 1.83 P75: 2.72 P99: 8.30 P99.9: 14.18 P99.99: 94.33 ------------------------------------------------------ [ 0, 1 ] 8578 3.352% 3.352% # ( 1, 2 ] 144557 56.480% 59.831% ########### ( 2, 3 ] 54216 21.183% 81.014% #### ( 3, 4 ] 23362 9.128% 90.142% ## ( 4, 6 ] 20416 7.977% 98.119% ## ( 6, 10 ] 3927 1.534% 99.653% ( 10, 15 ] 756 0.295% 99.948% ( 15, 22 ] 78 0.030% 99.979% ( 22, 34 ] 6 0.002% 99.981% ( 34, 51 ] 1 0.000% 99.982% ( 51, 76 ] 2 0.001% 99.982% ( 76, 110 ] 36 0.014% 99.996% ( 110, 170 ] 90 0.035% 100.032% ( 170, 250 ] 43 0.017% 100.048% ( 250, 380 ] 39 0.015% 100.064% ( 380, 580 ] 51 0.020% 100.084% ( 580, 870 ] 21 0.008% 100.092% ( 870, 1300 ] 22 0.009% 100.100% ( 1300, 1900 ] 7 0.003% 100.103% ( 1900, 2900 ] 20 0.008% 100.111% ( 2900, 4400 ] 21 0.008% 100.119% ( 4400, 6600 ] 3 0.001% 100.120% ( 6600, 9900 ] 7 0.003% 100.123% ** Level 4 read latency histogram (micros): Count: 7071 Average: 76.0699 StdDev: 335.00 Min: 0 Median: 2.0198 Max: 5184 Percentiles: P50: 2.02 P75: 3.39 P99: 1488.17 P99.9: 4871.53 P99.99: 5184.00 ------------------------------------------------------ [ 0, 1 ] 242 3.422% 3.422% # ( 1, 2 ] 3264 46.160% 49.583% ######### ( 2, 3 ] 1493 21.114% 70.697% #### ( 3, 4 ] 771 10.904% 81.601% ## ( 4, 6 ] 420 5.940% 87.541% # ( 6, 10 ] 203 2.871% 90.412% # ( 10, 15 ] 35 0.495% 90.907% ( 15, 22 ] 5 0.071% 90.977% ( 51, 76 ] 1 0.014% 90.991% ( 76, 110 ] 13 0.184% 91.175% ( 110, 170 ] 42 0.594% 91.769% ( 170, 250 ] 45 0.636% 92.406% ( 250, 380 ] 80 1.131% 93.537% ( 380, 580 ] 123 1.739% 95.276% ( 580, 870 ] 143 2.022% 97.299% ( 870, 1300 ] 109 1.542% 98.840% ( 1300, 1900 ] 36 0.509% 99.349% ( 1900, 2900 ] 24 0.339% 99.689% ( 2900, 4400 ] 13 0.184% 99.873% ( 4400, 6600 ] 9 0.127% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 953.3750 StdDev: 1298.68 Min: 76 Median: 424.4444 Max: 7964 Percentiles: P50: 424.44 P75: 1375.00 P99: 7260.00 P99.9: 7964.00 P99.99: 7964.00 ------------------------------------------------------ ( 51, 76 ] 1 1.250% 1.250% ( 76, 110 ] 15 18.750% 20.000% #### ( 110, 170 ] 17 21.250% 41.250% #### ( 170, 250 ] 2 2.500% 43.750% # ( 250, 380 ] 3 3.750% 47.500% # ( 380, 580 ] 9 11.250% 58.750% ## ( 580, 870 ] 7 8.750% 67.500% ## ( 870, 1300 ] 5 6.250% 73.750% # ( 1300, 1900 ] 8 10.000% 83.750% ## ( 1900, 2900 ] 6 7.500% 91.250% ## ( 2900, 4400 ] 5 6.250% 97.500% # ( 4400, 6600 ] 1 1.250% 98.750% ( 6600, 9900 ] 1 1.250% 100.000% ** DB Stats ** Uptime(secs): 30.3 total, 7.5 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 227.63 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:11.659 H:M:S, 38.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 131.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.737 H:M:S, 63.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/12/13-16:14:54 ... thread 0: (1000000,8000000) ops and (320842.9,241254.7) ops/second in (3.116790,33.159978) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/12 3.87 GB 132.2 6.0 0.0 6.0 13.5 7.6 0.0 1.8 131.8 298.8 46.36 43.00 130 0.357 6204K 7351 0.0 0.0 L1 17/17 1.95 GB 0.0 5.0 3.5 1.5 5.0 3.5 0.2 1.4 225.8 223.7 22.72 21.93 4 5.679 5208K 46K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 1.7 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 21/0 970.13 MB 1.0 1.9 1.2 0.7 1.9 1.2 0.6 1.6 211.4 210.6 9.13 8.39 5 1.826 1960K 7359 0.0 0.0 L4 176/0 9.64 GB 1.0 0.9 0.9 0.0 0.9 0.9 0.8 1.0 132.4 132.2 6.97 4.48 14 0.498 933K 1235 0.0 0.0 L5 1060/0 87.23 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1292/29 103.64 GB 0.0 13.9 5.7 8.3 21.5 13.2 4.9 2.8 166.2 255.6 85.94 78.53 154 0.558 14M 62K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.9 5.7 8.3 21.5 13.2 4.8 2.8 166.2 255.6 85.94 78.53 154 0.558 14M 62K 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.9 5.7 8.3 13.9 5.6 0.0 0.0 225.9 224.9 63.22 58.63 45 1.405 14M 62K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 341.1 22.72 19.90 109 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 33.4 total, 33.2 interval Flush(GB): cumulative 7.567, interval 7.567 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: 21.45 GB write, 658.04 MB/s write, 13.95 GB read, 427.80 MB/s read, 85.9 seconds Interval compaction: 21.45 GB write, 662.40 MB/s write, 13.95 GB read, 430.63 MB/s read, 85.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 7, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 36, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2815412 Average: 2.3341 StdDev: 18.05 Min: 0 Median: 1.4782 Max: 9870 Percentiles: P50: 1.48 P75: 1.86 P99: 5.76 P99.9: 13.14 P99.99: 171.52 ------------------------------------------------------ [ 0, 1 ] 520748 18.496% 18.496% #### ( 1, 2 ] 1854821 65.881% 84.377% ############# ( 2, 3 ] 262982 9.341% 93.718% ## ( 3, 4 ] 97757 3.472% 97.190% # ( 4, 6 ] 57758 2.051% 99.242% ( 6, 10 ] 16828 0.598% 99.840% ( 10, 15 ] 2714 0.096% 99.936% ( 15, 22 ] 213 0.008% 99.943% ( 22, 34 ] 27 0.001% 99.944% ( 34, 51 ] 15 0.001% 99.945% ( 51, 76 ] 54 0.002% 99.947% ( 76, 110 ] 516 0.018% 99.965% ( 110, 170 ] 691 0.025% 99.990% ( 170, 250 ] 341 0.012% 100.002% ( 250, 380 ] 212 0.008% 100.009% ( 380, 580 ] 211 0.007% 100.017% ( 580, 870 ] 114 0.004% 100.021% ( 870, 1300 ] 53 0.002% 100.023% ( 1300, 1900 ] 22 0.001% 100.024% ( 1900, 2900 ] 13 0.000% 100.024% ( 2900, 4400 ] 22 0.001% 100.025% ( 4400, 6600 ] 3 0.000% 100.025% ( 6600, 9900 ] 3 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 842680 Average: 2.8396 StdDev: 30.95 Min: 0 Median: 1.5696 Max: 11782 Percentiles: P50: 1.57 P75: 1.95 P99: 8.04 P99.9: 106.40 P99.99: 402.15 ------------------------------------------------------ [ 0, 1 ] 107678 12.778% 12.778% ### ( 1, 2 ] 550716 65.353% 78.131% ############# ( 2, 3 ] 105308 12.497% 90.628% ## ( 3, 4 ] 37183 4.412% 95.040% # ( 4, 6 ] 27335 3.244% 98.284% # ( 6, 10 ] 11805 1.401% 99.685% ( 10, 15 ] 1185 0.141% 99.826% ( 15, 22 ] 100 0.012% 99.837% ( 22, 34 ] 13 0.002% 99.839% ( 34, 51 ] 2 0.000% 99.839% ( 51, 76 ] 51 0.006% 99.845% ( 76, 110 ] 516 0.061% 99.906% ( 110, 170 ] 412 0.049% 99.955% ( 170, 250 ] 168 0.020% 99.975% ( 250, 380 ] 110 0.013% 99.988% ( 380, 580 ] 124 0.015% 100.003% ( 580, 870 ] 73 0.009% 100.012% ( 870, 1300 ] 42 0.005% 100.017% ( 1300, 1900 ] 19 0.002% 100.019% ( 1900, 2900 ] 8 0.001% 100.020% ( 2900, 4400 ] 10 0.001% 100.021% ( 4400, 6600 ] 4 0.000% 100.022% ( 6600, 9900 ] 3 0.000% 100.022% ( 9900, 14000 ] 1 0.000% 100.022% ** Level 2 read latency histogram (micros): Count: 47960 Average: 2.2167 StdDev: 11.84 Min: 1 Median: 1.3067 Max: 941 Percentiles: P50: 1.31 P75: 1.73 P99: 5.74 P99.9: 150.13 P99.99: 599.72 ------------------------------------------------------ [ 0, 1 ] 15197 31.687% 31.687% ###### ( 1, 2 ] 28639 59.714% 91.401% ############ ( 2, 3 ] 2197 4.581% 95.982% # ( 3, 4 ] 925 1.929% 97.911% ( 4, 6 ] 601 1.253% 99.164% ( 6, 10 ] 275 0.573% 99.737% ( 10, 15 ] 56 0.117% 99.854% ( 15, 22 ] 1 0.002% 99.856% ( 22, 34 ] 1 0.002% 99.858% ( 76, 110 ] 8 0.017% 99.875% ( 110, 170 ] 18 0.038% 99.912% ( 170, 250 ] 20 0.042% 99.954% ( 250, 380 ] 10 0.021% 99.975% ( 380, 580 ] 7 0.015% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 310558 Average: 3.7960 StdDev: 58.63 Min: 0 Median: 1.8541 Max: 8019 Percentiles: P50: 1.85 P75: 2.77 P99: 8.24 P99.9: 13.58 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 9005 2.900% 2.900% # ( 1, 2 ] 171253 55.144% 58.043% ########### ( 2, 3 ] 68349 22.008% 80.052% #### ( 3, 4 ] 29576 9.524% 89.575% ## ( 4, 6 ] 26615 8.570% 98.145% ## ( 6, 10 ] 4739 1.526% 99.671% ( 10, 15 ] 991 0.319% 99.990% ( 15, 22 ] 96 0.031% 100.021% ( 22, 34 ] 7 0.002% 100.024% ( 34, 51 ] 1 0.000% 100.024% ( 51, 76 ] 2 0.001% 100.024% ( 76, 110 ] 36 0.012% 100.036% ( 110, 170 ] 90 0.029% 100.065% ( 170, 250 ] 43 0.014% 100.079% ( 250, 380 ] 39 0.013% 100.091% ( 380, 580 ] 51 0.016% 100.108% ( 580, 870 ] 21 0.007% 100.115% ( 870, 1300 ] 22 0.007% 100.122% ( 1300, 1900 ] 8 0.003% 100.124% ( 1900, 2900 ] 21 0.007% 100.131% ( 2900, 4400 ] 23 0.007% 100.138% ( 4400, 6600 ] 3 0.001% 100.139% ( 6600, 9900 ] 7 0.002% 100.142% ** Level 4 read latency histogram (micros): Count: 10011 Average: 63.3556 StdDev: 292.83 Min: 0 Median: 1.9993 Max: 5184 Percentiles: P50: 2.00 P75: 3.35 P99: 1247.70 P99.9: 4291.68 P99.99: 5184.00 ------------------------------------------------------ [ 0, 1 ] 313 3.127% 3.127% # ( 1, 2 ] 4696 46.908% 50.035% ######### ( 2, 3 ] 2117 21.147% 71.182% #### ( 3, 4 ] 1078 10.768% 81.950% ## ( 4, 6 ] 606 6.053% 88.003% # ( 6, 10 ] 270 2.697% 90.700% # ( 10, 15 ] 45 0.450% 91.150% ( 15, 22 ] 5 0.050% 91.200% ( 51, 76 ] 1 0.010% 91.210% ( 76, 110 ] 31 0.310% 91.519% ( 110, 170 ] 96 0.959% 92.478% ( 170, 250 ] 92 0.919% 93.397% ( 250, 380 ] 116 1.159% 94.556% ( 380, 580 ] 177 1.768% 96.324% ( 580, 870 ] 166 1.658% 97.982% ( 870, 1300 ] 116 1.159% 99.141% ( 1300, 1900 ] 37 0.370% 99.511% ( 1900, 2900 ] 26 0.260% 99.770% ( 2900, 4400 ] 14 0.140% 99.910% ( 4400, 6600 ] 9 0.090% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 886.8700 StdDev: 1226.71 Min: 75 Median: 380.0000 Max: 7964 Percentiles: P50: 380.00 P75: 1228.33 P99: 6600.00 P99.9: 7964.00 P99.99: 7964.00 ------------------------------------------------------ ( 51, 76 ] 2 2.000% 2.000% ( 76, 110 ] 21 21.000% 23.000% #### ( 110, 170 ] 19 19.000% 42.000% #### ( 170, 250 ] 3 3.000% 45.000% # ( 250, 380 ] 5 5.000% 50.000% # ( 380, 580 ] 12 12.000% 62.000% ## ( 580, 870 ] 8 8.000% 70.000% ## ( 870, 1300 ] 6 6.000% 76.000% # ( 1300, 1900 ] 9 9.000% 85.000% ## ( 1900, 2900 ] 7 7.000% 92.000% # ( 2900, 4400 ] 6 6.000% 98.000% # ( 4400, 6600 ] 1 1.000% 99.000% ( 6600, 9900 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 33.4 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 235.86 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:12.075 H:M:S, 36.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 315.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.416 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-16:15:16 ... thread 0: (1000000,9000000) ops and (47020.3,165357.9) ops/second in (21.267405,54.427383) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/11 2.51 GB 0.0 8.1 0.0 8.1 16.6 8.5 0.0 1.9 134.0 275.9 61.56 54.35 145 0.425 8377K 18K 0.0 0.0 L1 1/1 28.27 KB 0.0 9.3 5.8 3.5 9.2 5.7 0.2 1.6 219.4 216.7 43.37 40.95 5 8.674 9205K 46K 0.0 0.0 L2 3/2 386.34 MB 1.3 0.2 0.1 0.1 0.2 0.1 5.9 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 36/8 2.43 GB 2.0 6.5 4.4 2.1 6.5 4.4 1.2 1.5 155.5 154.6 42.83 30.67 21 2.039 6240K 32K 0.0 0.0 L4 177/4 10.30 GB 1.1 3.5 3.1 0.4 3.5 3.1 1.0 1.1 133.0 132.6 26.85 16.88 37 0.726 3577K 8174 0.0 0.0 L5 1080/0 88.89 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1308/26 104.50 GB 0.0 27.5 13.5 14.0 35.9 21.8 11.5 4.2 160.7 209.6 175.38 143.59 209 0.839 27M 105K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.5 13.5 14.0 35.9 21.8 11.4 4.2 160.7 209.6 175.38 143.59 209 0.839 27M 105K 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 27.5 13.5 14.0 27.3 13.3 0.0 0.0 190.2 189.0 148.17 120.89 88 1.684 27M 105K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 321.8 27.21 22.71 121 0.225 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 54.6 total, 54.4 interval Flush(GB): cumulative 8.551, interval 8.551 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: 35.89 GB write, 672.55 MB/s write, 27.52 GB read, 515.75 MB/s read, 175.4 seconds Interval compaction: 35.89 GB write, 675.26 MB/s write, 27.52 GB read, 517.83 MB/s read, 175.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 48, pending-compaction-bytes-delays: 35, pending-compaction-bytes-stops: 0, total-delays: 49, total-stops: 48, interval: 97 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3899539 Average: 2.8402 StdDev: 27.23 Min: 0 Median: 1.5079 Max: 13483 Percentiles: P50: 1.51 P75: 1.90 P99: 7.24 P99.9: 143.10 P99.99: 416.29 ------------------------------------------------------ [ 0, 1 ] 696410 17.859% 17.859% #### ( 1, 2 ] 2467658 63.281% 81.140% ############# ( 2, 3 ] 407475 10.449% 91.589% ## ( 3, 4 ] 159791 4.098% 95.687% # ( 4, 6 ] 118974 3.051% 98.738% # ( 6, 10 ] 32916 0.844% 99.582% ( 10, 15 ] 5394 0.138% 99.720% ( 15, 22 ] 656 0.017% 99.737% ( 22, 34 ] 39 0.001% 99.738% ( 34, 51 ] 83 0.002% 99.740% ( 51, 76 ] 234 0.006% 99.746% ( 76, 110 ] 3886 0.100% 99.846% ( 110, 170 ] 3853 0.099% 99.944% ( 170, 250 ] 1007 0.026% 99.970% ( 250, 380 ] 661 0.017% 99.987% ( 380, 580 ] 623 0.016% 100.003% ( 580, 870 ] 344 0.009% 100.012% ( 870, 1300 ] 165 0.004% 100.016% ( 1300, 1900 ] 70 0.002% 100.018% ( 1900, 2900 ] 63 0.002% 100.020% ( 2900, 4400 ] 63 0.002% 100.021% ( 4400, 6600 ] 14 0.000% 100.022% ( 6600, 9900 ] 4 0.000% 100.022% ( 9900, 14000 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 2287416 Average: 4.6886 StdDev: 68.26 Min: 0 Median: 1.7056 Max: 11782 Percentiles: P50: 1.71 P75: 2.52 P99: 9.00 P99.9: 134.18 P99.99: 430.98 ------------------------------------------------------ [ 0, 1 ] 246958 10.796% 10.796% ## ( 1, 2 ] 1270895 55.560% 66.357% ########### ( 2, 3 ] 383150 16.750% 83.107% ### ( 3, 4 ] 171790 7.510% 90.617% ## ( 4, 6 ] 159134 6.957% 97.574% # ( 6, 10 ] 43441 1.899% 99.473% ( 10, 15 ] 6780 0.296% 99.770% ( 15, 22 ] 1017 0.044% 99.814% ( 22, 34 ] 69 0.003% 99.817% ( 34, 51 ] 36 0.002% 99.819% ( 51, 76 ] 180 0.008% 99.827% ( 76, 110 ] 1139 0.050% 99.876% ( 110, 170 ] 1339 0.059% 99.935% ( 170, 250 ] 471 0.021% 99.956% ( 250, 380 ] 580 0.025% 99.981% ( 380, 580 ] 817 0.036% 100.017% ( 580, 870 ] 787 0.034% 100.051% ( 870, 1300 ] 595 0.026% 100.077% ( 1300, 1900 ] 282 0.012% 100.089% ( 1900, 2900 ] 263 0.011% 100.101% ( 2900, 4400 ] 314 0.014% 100.115% ( 4400, 6600 ] 80 0.003% 100.118% ( 6600, 9900 ] 16 0.001% 100.119% ( 9900, 14000 ] 1 0.000% 100.119% ** Level 2 read latency histogram (micros): Count: 47960 Average: 2.2167 StdDev: 11.84 Min: 1 Median: 1.3067 Max: 941 Percentiles: P50: 1.31 P75: 1.73 P99: 5.74 P99.9: 150.13 P99.99: 599.72 ------------------------------------------------------ [ 0, 1 ] 15197 31.687% 31.687% ###### ( 1, 2 ] 28639 59.714% 91.401% ############ ( 2, 3 ] 2197 4.581% 95.982% # ( 3, 4 ] 925 1.929% 97.911% ( 4, 6 ] 601 1.253% 99.164% ( 6, 10 ] 275 0.573% 99.737% ( 10, 15 ] 56 0.117% 99.854% ( 15, 22 ] 1 0.002% 99.856% ( 22, 34 ] 1 0.002% 99.858% ( 76, 110 ] 8 0.017% 99.875% ( 110, 170 ] 18 0.038% 99.912% ( 170, 250 ] 20 0.042% 99.954% ( 250, 380 ] 10 0.021% 99.975% ( 380, 580 ] 7 0.015% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 1100196 Average: 6.7058 StdDev: 95.24 Min: 0 Median: 1.9828 Max: 9567 Percentiles: P50: 1.98 P75: 3.00 P99: 9.41 P99.9: 324.27 P99.99: 658.51 ------------------------------------------------------ [ 0, 1 ] 16386 1.489% 1.489% ( 1, 2 ] 543040 49.358% 50.848% ########## ( 2, 3 ] 265338 24.117% 74.965% ##### ( 3, 4 ] 125309 11.390% 86.355% ## ( 4, 6 ] 119745 10.884% 97.239% ## ( 6, 10 ] 22731 2.066% 99.305% ( 10, 15 ] 5158 0.469% 99.774% ( 15, 22 ] 608 0.055% 99.829% ( 22, 34 ] 45 0.004% 99.833% ( 34, 51 ] 17 0.002% 99.835% ( 51, 76 ] 22 0.002% 99.837% ( 76, 110 ] 79 0.007% 99.844% ( 110, 170 ] 175 0.016% 99.860% ( 170, 250 ] 235 0.021% 99.881% ( 250, 380 ] 369 0.034% 99.915% ( 380, 580 ] 646 0.059% 99.973% ( 580, 870 ] 687 0.062% 100.036% ( 870, 1300 ] 529 0.048% 100.084% ( 1300, 1900 ] 275 0.025% 100.109% ( 1900, 2900 ] 280 0.025% 100.134% ( 2900, 4400 ] 269 0.024% 100.159% ( 4400, 6600 ] 61 0.006% 100.164% ( 6600, 9900 ] 25 0.002% 100.167% ** Level 4 read latency histogram (micros): Count: 109161 Average: 31.7622 StdDev: 228.01 Min: 0 Median: 1.9479 Max: 7326 Percentiles: P50: 1.95 P75: 2.99 P99: 942.76 P99.9: 3496.57 P99.99: 4605.59 ------------------------------------------------------ [ 0, 1 ] 2281 2.090% 2.090% ( 1, 2 ] 55176 50.546% 52.635% ########## ( 2, 3 ] 24540 22.481% 75.116% #### ( 3, 4 ] 11347 10.395% 85.510% ## ( 4, 6 ] 9348 8.563% 94.074% ## ( 6, 10 ] 2654 2.431% 96.505% ( 10, 15 ] 432 0.396% 96.901% ( 15, 22 ] 48 0.044% 96.945% ( 22, 34 ] 4 0.004% 96.949% ( 34, 51 ] 1 0.001% 96.949% ( 51, 76 ] 1 0.001% 96.950% ( 76, 110 ] 49 0.045% 96.995% ( 110, 170 ] 172 0.158% 97.153% ( 170, 250 ] 261 0.239% 97.392% ( 250, 380 ] 401 0.367% 97.759% ( 380, 580 ] 573 0.525% 98.284% ( 580, 870 ] 689 0.631% 98.915% ( 870, 1300 ] 546 0.500% 99.416% ( 1300, 1900 ] 274 0.251% 99.667% ( 1900, 2900 ] 192 0.176% 99.842% ( 2900, 4400 ] 158 0.145% 99.987% ( 4400, 6600 ] 33 0.030% 100.017% ( 6600, 9900 ] 2 0.002% 100.019% ** Level 5 read latency histogram (micros): Count: 200 Average: 1285.8100 StdDev: 1521.91 Min: 75 Median: 672.2727 Max: 8965 Percentiles: P50: 672.27 P75: 1829.41 P99: 6600.00 P99.9: 8965.00 P99.99: 8965.00 ------------------------------------------------------ ( 51, 76 ] 2 1.000% 1.000% ( 76, 110 ] 22 11.000% 12.000% ## ( 110, 170 ] 22 11.000% 23.000% ## ( 170, 250 ] 6 3.000% 26.000% # ( 250, 380 ] 18 9.000% 35.000% ## ( 380, 580 ] 23 11.500% 46.500% ## ( 580, 870 ] 22 11.000% 57.500% ## ( 870, 1300 ] 20 10.000% 67.500% ## ( 1300, 1900 ] 17 8.500% 76.000% ## ( 1900, 2900 ] 17 8.500% 84.500% ## ( 2900, 4400 ] 21 10.500% 95.000% ## ( 4400, 6600 ] 8 4.000% 99.000% # ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 54.6 total, 21.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 162.08 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:29.752 H:M:S, 54.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 46.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:17.677 H:M:S, 83.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/13-16:15:20 ... thread 0: (1000000,10000000) ops and (239045.6,170617.4) ops/second in (4.183303,58.610686) seconds ** 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 Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/7 3.43 GB 132.1 9.3 0.0 9.3 18.8 9.5 0.0 2.0 134.4 270.4 71.20 62.19 161 0.442 9720K 20K 0.0 0.0 L1 1/1 28.27 KB 0.0 9.3 5.8 3.5 9.2 5.7 0.2 1.6 219.4 216.7 43.37 40.95 5 8.674 9205K 46K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 5.9 1.5 247.7 247.6 0.76 0.73 1 0.763 191K 73 0.0 0.0 L3 17/0 986.76 MB 1.0 7.2 4.8 2.4 7.1 4.8 1.2 1.5 154.7 153.9 47.55 33.93 24 1.981 6818K 34K 0.0 0.0 L4 166/0 9.49 GB 1.0 5.3 4.8 0.5 5.3 4.8 1.1 1.1 128.9 128.6 41.91 25.74 56 0.748 5379K 8174 0.0 0.0 L5 1112/0 91.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1307/8 105.42 GB 0.0 31.3 15.6 15.7 40.6 24.9 14.3 4.3 156.4 202.9 204.79 163.56 247 0.829 31M 108K 0.0 0.0 Int 0/0 0.00 KB 0.0 31.3 15.6 15.7 40.6 24.9 14.1 4.3 156.4 202.9 204.79 163.56 247 0.829 31M 108K 0.0 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 Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 31.3 15.6 15.7 31.1 15.4 0.0 0.0 184.4 183.3 173.73 138.33 114 1.524 31M 108K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 312.3 31.07 25.23 133 0.234 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 58.8 total, 58.6 interval Flush(GB): cumulative 9.474, interval 9.474 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: 40.57 GB write, 706.14 MB/s write, 31.29 GB read, 544.56 MB/s read, 204.8 seconds Interval compaction: 40.57 GB write, 708.79 MB/s write, 31.29 GB read, 546.60 MB/s read, 204.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 64, pending-compaction-bytes-delays: 35, pending-compaction-bytes-stops: 0, total-delays: 49, total-stops: 64, interval: 113 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4327622 Average: 2.9393 StdDev: 31.84 Min: 0 Median: 1.5334 Max: 13483 Percentiles: P50: 1.53 P75: 1.93 P99: 7.44 P99.9: 137.19 P99.99: 391.66 ------------------------------------------------------ [ 0, 1 ] 718675 16.607% 16.607% ### ( 1, 2 ] 2709231 62.603% 79.210% ############# ( 2, 3 ] 497933 11.506% 90.716% ## ( 3, 4 ] 192542 4.449% 95.165% # ( 4, 6 ] 151544 3.502% 98.667% # ( 6, 10 ] 39937 0.923% 99.590% ( 10, 15 ] 6609 0.153% 99.742% ( 15, 22 ] 800 0.018% 99.761% ( 22, 34 ] 49 0.001% 99.762% ( 34, 51 ] 88 0.002% 99.764% ( 51, 76 ] 236 0.005% 99.769% ( 76, 110 ] 3886 0.090% 99.859% ( 110, 170 ] 3894 0.090% 99.949% ( 170, 250 ] 1042 0.024% 99.973% ( 250, 380 ] 685 0.016% 99.989% ( 380, 580 ] 656 0.015% 100.004% ( 580, 870 ] 377 0.009% 100.013% ( 870, 1300 ] 209 0.005% 100.018% ( 1300, 1900 ] 105 0.002% 100.020% ( 1900, 2900 ] 98 0.002% 100.023% ( 2900, 4400 ] 106 0.002% 100.025% ( 4400, 6600 ] 24 0.001% 100.026% ( 6600, 9900 ] 10 0.000% 100.026% ( 9900, 14000 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 2356100 Average: 4.8095 StdDev: 70.74 Min: 0 Median: 1.7128 Max: 11782 Percentiles: P50: 1.71 P75: 2.54 P99: 9.04 P99.9: 139.66 P99.99: 470.96 ------------------------------------------------------ [ 0, 1 ] 247625 10.510% 10.510% ## ( 1, 2 ] 1305342 55.403% 65.913% ########### ( 2, 3 ] 399918 16.974% 82.886% ### ( 3, 4 ] 179108 7.602% 90.488% ## ( 4, 6 ] 166156 7.052% 97.540% # ( 6, 10 ] 45316 1.923% 99.464% ( 10, 15 ] 7134 0.303% 99.767% ( 15, 22 ] 1051 0.045% 99.811% ( 22, 34 ] 72 0.003% 99.814% ( 34, 51 ] 38 0.002% 99.816% ( 51, 76 ] 180 0.008% 99.823% ( 76, 110 ] 1140 0.048% 99.872% ( 110, 170 ] 1343 0.057% 99.929% ( 170, 250 ] 473 0.020% 99.949% ( 250, 380 ] 590 0.025% 99.974% ( 380, 580 ] 832 0.035% 100.009% ( 580, 870 ] 810 0.034% 100.044% ( 870, 1300 ] 618 0.026% 100.070% ( 1300, 1900 ] 298 0.013% 100.083% ( 1900, 2900 ] 319 0.014% 100.096% ( 2900, 4400 ] 356 0.015% 100.111% ( 4400, 6600 ] 88 0.004% 100.115% ( 6600, 9900 ] 16 0.001% 100.116% ( 9900, 14000 ] 1 0.000% 100.116% ** Level 2 read latency histogram (micros): Count: 47960 Average: 2.2167 StdDev: 11.84 Min: 1 Median: 1.3067 Max: 941 Percentiles: P50: 1.31 P75: 1.73 P99: 5.74 P99.9: 150.13 P99.99: 599.72 ------------------------------------------------------ [ 0, 1 ] 15197 31.687% 31.687% ###### ( 1, 2 ] 28639 59.714% 91.401% ############ ( 2, 3 ] 2197 4.581% 95.982% # ( 3, 4 ] 925 1.929% 97.911% ( 4, 6 ] 601 1.253% 99.164% ( 6, 10 ] 275 0.573% 99.737% ( 10, 15 ] 56 0.117% 99.854% ( 15, 22 ] 1 0.002% 99.856% ( 22, 34 ] 1 0.002% 99.858% ( 76, 110 ] 8 0.017% 99.875% ( 110, 170 ] 18 0.038% 99.912% ( 170, 250 ] 20 0.042% 99.954% ( 250, 380 ] 10 0.021% 99.975% ( 380, 580 ] 7 0.015% 99.990% ( 580, 870 ] 3 0.006% 99.996% ( 870, 1300 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 1596960 Average: 7.1775 StdDev: 107.10 Min: 0 Median: 1.9855 Max: 11314 Percentiles: P50: 1.99 P75: 2.99 P99: 9.39 P99.9: 221.85 P99.99: 621.25 ------------------------------------------------------ [ 0, 1 ] 20767 1.300% 1.300% ( 1, 2 ] 789178 49.418% 50.718% ########## ( 2, 3 ] 390669 24.463% 75.181% ##### ( 3, 4 ] 180312 11.291% 86.472% ## ( 4, 6 ] 171943 10.767% 97.239% ## ( 6, 10 ] 33219 2.080% 99.319% ( 10, 15 ] 7799 0.488% 99.808% ( 15, 22 ] 902 0.056% 99.864% ( 22, 34 ] 62 0.004% 99.868% ( 34, 51 ] 21 0.001% 99.869% ( 51, 76 ] 22 0.001% 99.871% ( 76, 110 ] 90 0.006% 99.876% ( 110, 170 ] 206 0.013% 99.889% ( 170, 250 ] 267 0.017% 99.906% ( 250, 380 ] 446 0.028% 99.934% ( 380, 580 ] 773 0.048% 99.982% ( 580, 870 ] 874 0.055% 100.037% ( 870, 1300 ] 720 0.045% 100.082% ( 1300, 1900 ] 422 0.026% 100.108% ( 1900, 2900 ] 501 0.031% 100.140% ( 2900, 4400 ] 528 0.033% 100.173% ( 4400, 6600 ] 125 0.008% 100.181% ( 6600, 9900 ] 48 0.003% 100.184% ( 9900, 14000 ] 1 0.000% 100.184% ** Level 4 read latency histogram (micros): Count: 126483 Average: 43.0033 StdDev: 294.33 Min: 0 Median: 1.9570 Max: 11510 Percentiles: P50: 1.96 P75: 3.03 P99: 1241.09 P99.9: 4076.76 P99.99: 5765.75 ------------------------------------------------------ [ 0, 1 ] 2633 2.082% 2.082% ( 1, 2 ] 63330 50.070% 52.152% ########## ( 2, 3 ] 28556 22.577% 74.729% ##### ( 3, 4 ] 13275 10.495% 85.224% ## ( 4, 6 ] 10510 8.309% 93.534% ## ( 6, 10 ] 3042 2.405% 95.939% ( 10, 15 ] 507 0.401% 96.339% ( 15, 22 ] 57 0.045% 96.384% ( 22, 34 ] 11 0.009% 96.393% ( 34, 51 ] 3 0.002% 96.396% ( 51, 76 ] 1 0.001% 96.396% ( 76, 110 ] 68 0.054% 96.450% ( 110, 170 ] 222 0.176% 96.626% ( 170, 250 ] 331 0.262% 96.887% ( 250, 380 ] 473 0.374% 97.261% ( 380, 580 ] 695 0.549% 97.811% ( 580, 870 ] 869 0.687% 98.498% ( 870, 1300 ] 736 0.582% 99.080% ( 1300, 1900 ] 427 0.338% 99.417% ( 1900, 2900 ] 343 0.271% 99.688% ( 2900, 4400 ] 341 0.270% 99.958% ( 4400, 6600 ] 65 0.051% 100.009% ( 6600, 9900 ] 10 0.008% 100.017% ( 9900, 14000 ] 1 0.001% 100.018% ** Level 5 read latency histogram (micros): Count: 360 Average: 1400.6361 StdDev: 1809.31 Min: 75 Median: 708.8889 Max: 15675 Percentiles: P50: 708.89 P75: 2089.19 P99: 8140.00 P99.9: 15675.00 P99.99: 15675.00 ------------------------------------------------------ ( 51, 76 ] 2 0.556% 0.556% ( 76, 110 ] 29 8.056% 8.611% ## ( 110, 170 ] 40 11.111% 19.722% ## ( 170, 250 ] 15 4.167% 23.889% # ( 250, 380 ] 40 11.111% 35.000% ## ( 380, 580 ] 38 10.556% 45.556% ## ( 580, 870 ] 36 10.000% 55.556% ## ( 870, 1300 ] 34 9.444% 65.000% ## ( 1300, 1900 ] 29 8.056% 73.056% ## ( 1900, 2900 ] 37 10.278% 83.333% ## ( 2900, 4400 ] 43 11.944% 95.278% ## ( 4400, 6600 ] 12 3.333% 98.611% # ( 6600, 9900 ] 3 0.833% 99.444% ( 9900, 14000 ] 1 0.278% 99.722% ( 14000, 22000 ] 1 0.278% 100.000% ** DB Stats ** Uptime(secs): 58.8 total, 4.2 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 167.29 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:31.096 H:M:S, 52.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 235.27 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.344 H:M:S, 32.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.748 micros/op 173963 ops/sec 60.001 seconds 10437999 operations; 168.6 MB/s Microseconds per write: Count: 10437999 Average: 5.7484 StdDev: 492.10 Min: 0 Median: 1.7336 Max: 727798 Percentiles: P50: 1.73 P75: 2.74 P99: 8.77 P99.9: 1112.96 P99.99: 2640.20 ------------------------------------------------------ [ 0, 1 ] 1447515 13.868% 13.868% ### ( 1, 2 ] 5141009 49.253% 63.121% ########## ( 2, 3 ] 1672864 16.027% 79.147% ### ( 3, 4 ] 1436186 13.759% 92.906% ### ( 4, 6 ] 561847 5.383% 98.289% # ( 6, 10 ] 107095 1.026% 99.315% ( 10, 15 ] 31427 0.301% 99.616% ( 15, 22 ] 7717 0.074% 99.690% ( 22, 34 ] 1754 0.017% 99.707% ( 34, 51 ] 226 0.002% 99.709% ( 51, 76 ] 30 0.000% 99.709% ( 76, 110 ] 7092 0.068% 99.777% ( 110, 170 ] 2983 0.029% 99.806% ( 170, 250 ] 347 0.003% 99.809% ( 250, 380 ] 140 0.001% 99.811% ( 380, 580 ] 25 0.000% 99.811% ( 580, 870 ] 33 0.000% 99.811% ( 870, 1300 ] 16408 0.157% 99.968% ( 1300, 1900 ] 101 0.001% 99.969% ( 1900, 2900 ] 2913 0.028% 99.997% ( 2900, 4400 ] 209 0.002% 99.999% ( 4400, 6600 ] 33 0.000% 100.000% ( 6600, 9900 ] 10 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 5 0.000% 100.000% ( 75000, 110000 ] 4 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 3 0.000% 100.000% ( 570000, 860000 ] 3 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 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 : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 200356 rocksdb.compaction.key.drop.obsolete COUNT : 0 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.compaction.cancelled COUNT : 0 rocksdb.number.keys.written COUNT : 10437999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10772014968 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 627 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31351204 rocksdb.db.mutex.wait.micros COUNT : 0 rocksdb.number.multiget.get COUNT : 0 rocksdb.number.multiget.keys.read COUNT : 0 rocksdb.number.multiget.bytes.read COUNT : 0 rocksdb.number.merge.failures COUNT : 0 rocksdb.bloom.filter.prefix.checked COUNT : 0 rocksdb.bloom.filter.prefix.useful COUNT : 0 rocksdb.number.reseeks.iteration COUNT : 0 rocksdb.getupdatessince.calls COUNT : 0 rocksdb.wal.synced COUNT : 0 rocksdb.wal.bytes COUNT : 0 rocksdb.write.self COUNT : 0 rocksdb.write.other COUNT : 0 rocksdb.write.wal COUNT : 0 rocksdb.compact.read.bytes COUNT : 35715990594 rocksdb.compact.write.bytes COUNT : 35513586231 rocksdb.flush.write.bytes COUNT : 10635015676 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 80 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 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 : 0 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 COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size 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.relocated 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.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 293 rocksdb.error.handler.bg.errro.count COUNT : 0 rocksdb.error.handler.bg.io.errro.count COUNT : 0 rocksdb.error.handler.bg.retryable.io.errro.count COUNT : 0 rocksdb.error.handler.autoresume.count COUNT : 0 rocksdb.error.handler.autoresume.retry.total.count COUNT : 0 rocksdb.error.handler.autoresume.success.count COUNT : 0 rocksdb.memtable.payload.bytes.at.flush COUNT : 10549556224 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4365312 rocksdb.secondary.cache.hits COUNT : 0 rocksdb.verify_checksum.read.bytes COUNT : 0 rocksdb.backup.read.bytes COUNT : 0 rocksdb.backup.write.bytes COUNT : 0 rocksdb.remote.compact.read.bytes COUNT : 0 rocksdb.remote.compact.write.bytes COUNT : 0 rocksdb.hot.file.read.bytes COUNT : 0 rocksdb.warm.file.read.bytes COUNT : 0 rocksdb.cold.file.read.bytes COUNT : 0 rocksdb.hot.file.read.count COUNT : 0 rocksdb.warm.file.read.count COUNT : 0 rocksdb.cold.file.read.count COUNT : 0 rocksdb.last.level.read.bytes COUNT : 0 rocksdb.last.level.read.count COUNT : 0 rocksdb.non.last.level.read.bytes COUNT : 35825473350 rocksdb.non.last.level.read.count COUNT : 8653641 rocksdb.block.checksum.compute.count COUNT : 8652467 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.micros P50 : 1.382449 P95 : 3.892993 P99 : 7.152334 P100 : 727796.000000 COUNT : 10437999 SUM : 55220494 rocksdb.compaction.times.micros P50 : 1034473.684211 P95 : 4850000.000000 P99 : 13370000.000000 P100 : 20652895.000000 COUNT : 115 SUM : 174912104 rocksdb.compaction.times.cpu_micros P50 : 781923.076923 P95 : 4437500.000000 P99 : 13370000.000000 P100 : 19027835.000000 COUNT : 115 SUM : 139499278 rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.sync.micros P50 : 710.316456 P95 : 6682.500000 P99 : 20440.000000 P100 : 26138.000000 COUNT : 139 SUM : 191536 rocksdb.compaction.outfile.sync.micros P50 : 1133.009709 P95 : 105722.222222 P99 : 190266.666667 P100 : 1223478.000000 COUNT : 424 SUM : 8524737 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 126.428571 P95 : 2305.555556 P99 : 4213.571429 P100 : 5523.000000 COUNT : 287 SUM : 135285 rocksdb.table.open.io.micros P50 : 1681.521739 P95 : 8829.857143 P99 : 13211.352941 P100 : 33719.000000 COUNT : 627 SUM : 1572563 rocksdb.db.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.block.compaction.micros P50 : 3.701713 P95 : 8.189642 P99 : 12.036853 P100 : 16861.000000 COUNT : 8650993 SUM : 59657159 rocksdb.read.block.get.micros P50 : 524.262295 P95 : 3840.588235 P99 : 6165.739130 P100 : 15745.000000 COUNT : 1254 SUM : 1282901 rocksdb.write.raw.block.micros P50 : 0.515015 P95 : 0.978529 P99 : 2.924549 P100 : 23435.000000 COUNT : 11179343 SUM : 23727537 rocksdb.numfiles.in.singlecompaction P50 : 2.875000 P95 : 4.566667 P99 : 17.590000 P100 : 25.000000 COUNT : 163 SUM : 554 rocksdb.db.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.stall P50 : 0.558055 P95 : 1135.843089 P99 : 2324.060543 P100 : 727606.000000 COUNT : 189125 SUM : 31367784 rocksdb.sst.read.micros P50 : 1.657814 P95 : 5.000536 P99 : 8.950172 P100 : 15675.000000 COUNT : 8654357 SUM : 42180720 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 10437999 SUM : 10772014968 rocksdb.bytes.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.compressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.decompressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.compression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.decompression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.num.merge_operands P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.key.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.value.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.next.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.prev.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.read.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.compression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.decompression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.flush.micros P50 : 217920.792079 P95 : 444916.666667 P99 : 803450.000000 P100 : 876323.000000 COUNT : 139 SUM : 32424146 rocksdb.sst.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.index.and.filter.blocks.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.sst.read.per.level P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.error.handler.autoresume.retry.count P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.poll.wait.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.prefetched.bytes.discarded P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 397 SUM : 0 rocksdb.multiget.io.batch.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.num.level.read.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.async.prefetch.abort.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.open.prefetch.tail.read.bytes P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0