[2024-11-18 03:23:29.292473] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-11-18 03:23:29.292751] [ 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_pid1202844 ] Set seed to 1731896609285743 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-18 03:23:29.389749] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-18 03:23:29.431129] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-18 03:23:29.431178] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1202844' to capture a snapshot of events at runtime. [2024-11-18 03:23:29.431189] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-18 03:23:29.431215] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-18 03:23:29.431224] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1202844 for offline analysis/debug. [2024-11-18 03:23:29.431308] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Nov 18 03:23:33 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/18-03:23:36 ... thread 0: (1000000,1000000) ops and (356437.5,356437.5) ops/second in (2.805541,2.805541) 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/8 504.04 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 348.5 2.35 2.11 12 0.196 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.1 1.0 255.1 255.0 0.74 0.71 1 0.741 191K 72 0.0 0.0 L2 2/1 125.97 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.2 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 11/0 993.27 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 112/0 9.41 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.75 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 1176/12 96.94 GB 0.0 0.3 0.2 0.1 1.1 1.0 0.5 1.4 86.7 312.1 3.63 3.34 14 0.260 319K 113 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.3 1.4 86.7 312.1 3.63 3.34 14 0.260 319K 113 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.3 0.2 0.1 0.3 0.2 0.0 0.0 245.5 245.4 1.28 1.23 2 0.642 319K 113 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 348.5 2.35 2.11 12 0.196 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.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 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.11 GB write, 373.99 MB/s write, 0.31 GB read, 103.89 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 403.90 MB/s write, 0.31 GB read, 112.20 MB/s read, 3.6 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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 116856 Average: 1.9293 StdDev: 23.15 Min: 0 Median: 1.1908 Max: 3926 Percentiles: P50: 1.19 P75: 1.65 P99: 3.95 P99.9: 9.37 P99.99: 239.03 ------------------------------------------------------ [ 0, 1 ] 46189 39.526% 39.526% ######## ( 1, 2 ] 64130 54.880% 94.406% ########### ( 2, 3 ] 3912 3.348% 97.754% # ( 3, 4 ] 1540 1.318% 99.072% ( 4, 6 ] 712 0.609% 99.681% ( 6, 10 ] 305 0.261% 99.942% ( 10, 15 ] 31 0.027% 99.968% ( 15, 22 ] 12 0.010% 99.979% ( 22, 34 ] 3 0.003% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 110, 170 ] 5 0.004% 99.987% ( 170, 250 ] 5 0.004% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 1 0.001% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 3 0.003% 99.999% ( 1900, 2900 ] 2 0.002% 100.001% ( 2900, 4400 ] 3 0.003% 100.003% ** Level 1 read latency histogram (micros): Count: 22483 Average: 2.2094 StdDev: 36.90 Min: 0 Median: 1.2236 Max: 4176 Percentiles: P50: 1.22 P75: 1.66 P99: 3.90 P99.9: 9.57 P99.99: 1193.23 ------------------------------------------------------ [ 0, 1 ] 8363 37.197% 37.197% ####### ( 1, 2 ] 12872 57.252% 94.449% ########### ( 2, 3 ] 747 3.323% 97.772% # ( 3, 4 ] 308 1.370% 99.142% ( 4, 6 ] 125 0.556% 99.698% ( 6, 10 ] 51 0.227% 99.924% ( 10, 15 ] 8 0.036% 99.960% ( 110, 170 ] 1 0.004% 99.964% ( 170, 250 ] 1 0.004% 99.969% ( 250, 380 ] 1 0.004% 99.973% ( 380, 580 ] 1 0.004% 99.978% ( 580, 870 ] 2 0.009% 99.987% ( 870, 1300 ] 1 0.004% 99.991% ( 2900, 4400 ] 2 0.009% 100.000% ** Level 2 read latency histogram (micros): Count: 7434 Average: 3.4656 StdDev: 54.85 Min: 1 Median: 1.5719 Max: 4172 Percentiles: P50: 1.57 P75: 1.94 P99: 5.97 P99.9: 28.79 P99.99: 3284.90 ------------------------------------------------------ [ 0, 1 ] 831 11.178% 11.178% ## ( 1, 2 ] 5046 67.877% 79.056% ############## ( 2, 3 ] 806 10.842% 89.898% ## ( 3, 4 ] 365 4.910% 94.808% # ( 4, 6 ] 316 4.251% 99.058% # ( 6, 10 ] 55 0.740% 99.798% ( 10, 15 ] 6 0.081% 99.879% ( 15, 22 ] 1 0.013% 99.892% ( 22, 34 ] 1 0.013% 99.906% ( 250, 380 ] 1 0.013% 99.919% ( 380, 580 ] 1 0.013% 99.933% ( 580, 870 ] 3 0.040% 99.973% ( 1300, 1900 ] 1 0.013% 99.987% ( 2900, 4400 ] 1 0.013% 100.000% ** Level 3 read latency histogram (micros): Count: 45 Average: 1573.2667 StdDev: 1399.07 Min: 158 Median: 779.3750 Max: 4704 Percentiles: P50: 779.38 P75: 2858.33 P99: 4704.00 P99.9: 4704.00 P99.99: 4704.00 ------------------------------------------------------ ( 110, 170 ] 2 4.444% 4.444% # ( 170, 250 ] 3 6.667% 11.111% # ( 250, 380 ] 2 4.444% 15.556% # ( 380, 580 ] 10 22.222% 37.778% #### ( 580, 870 ] 8 17.778% 55.556% #### ( 870, 1300 ] 2 4.444% 60.000% # ( 1300, 1900 ] 1 2.222% 62.222% ( 1900, 2900 ] 6 13.333% 75.556% ### ( 2900, 4400 ] 8 17.778% 93.333% #### ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1662.4400 StdDev: 1481.64 Min: 206 Median: 1192.5000 Max: 5985 Percentiles: P50: 1192.50 P75: 2275.00 P99: 5985.00 P99.9: 5985.00 P99.99: 5985.00 ------------------------------------------------------ ( 170, 250 ] 1 4.000% 4.000% # ( 250, 380 ] 1 4.000% 8.000% # ( 380, 580 ] 1 4.000% 12.000% # ( 580, 870 ] 8 32.000% 44.000% ###### ( 870, 1300 ] 2 8.000% 52.000% ## ( 1300, 1900 ] 5 20.000% 72.000% #### ( 1900, 2900 ] 2 8.000% 80.000% ## ( 2900, 4400 ] 3 12.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 324.60 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.232 H:M:S, 7.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.47 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.232 H:M:S, 8.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-03:23:39 ... thread 0: (1000000,2000000) ops and (326992.8,341080.9) ops/second in (3.058171,5.863712) 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 15/15 1.23 GB 0.0 0.2 0.0 0.2 2.0 1.8 0.0 1.1 40.8 336.1 6.18 5.62 27 0.229 255K 242 0.0 0.0 L1 5/5 440.13 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.6 242.2 2.60 2.51 2 1.298 639K 799 0.0 0.0 L2 1/0 1.29 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.2 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 14/0 627.64 MB 0.6 0.1 0.1 0.0 0.1 0.1 0.2 1.0 224.9 224.9 0.55 0.51 1 0.554 126K 0 0.0 0.0 L4 170/0 9.58 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.0 100.7 100.7 1.12 0.70 1 1.116 114K 0 0.0 0.0 L5 1044/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1249/20 97.92 GB 0.0 1.2 0.7 0.5 3.0 2.5 1.1 1.7 113.2 279.3 10.99 9.86 32 0.344 1264K 1082 0.0 0.0 Int 0/0 0.00 KB 0.0 1.2 0.7 0.5 3.0 2.5 1.0 1.7 113.2 279.3 10.99 9.86 32 0.344 1264K 1082 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.2 0.7 0.5 1.2 0.7 0.0 0.0 216.2 216.0 5.76 5.17 6 0.960 1264K 1082 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 349.0 5.23 4.69 26 0.201 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.1 total, 5.9 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.00 GB write, 504.24 MB/s write, 1.22 GB read, 204.43 MB/s read, 11.0 seconds Interval compaction: 3.00 GB write, 523.54 MB/s write, 1.22 GB read, 212.26 MB/s read, 11.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 324663 Average: 2.0953 StdDev: 17.35 Min: 0 Median: 1.3920 Max: 3926 Percentiles: P50: 1.39 P75: 1.80 P99: 5.22 P99.9: 9.53 P99.99: 18.64 ------------------------------------------------------ [ 0, 1 ] 83556 25.736% 25.736% ##### ( 1, 2 ] 200967 61.900% 87.636% ############ ( 2, 3 ] 24980 7.694% 95.331% ## ( 3, 4 ] 8840 2.723% 98.053% # ( 4, 6 ] 5018 1.546% 99.599% ( 6, 10 ] 1108 0.341% 99.940% ( 10, 15 ] 148 0.046% 99.986% ( 15, 22 ] 26 0.008% 99.994% ( 22, 34 ] 7 0.002% 99.996% ( 34, 51 ] 1 0.000% 99.996% ( 51, 76 ] 3 0.001% 99.997% ( 76, 110 ] 1 0.000% 99.998% ( 110, 170 ] 11 0.003% 100.001% ( 170, 250 ] 11 0.003% 100.004% ( 250, 380 ] 9 0.003% 100.007% ( 380, 580 ] 3 0.001% 100.008% ( 580, 870 ] 3 0.001% 100.009% ( 870, 1300 ] 3 0.001% 100.010% ( 1300, 1900 ] 6 0.002% 100.012% ( 1900, 2900 ] 3 0.001% 100.013% ( 2900, 4400 ] 5 0.002% 100.014% ** Level 1 read latency histogram (micros): Count: 86575 Average: 2.1224 StdDev: 19.92 Min: 0 Median: 1.3975 Max: 4176 Percentiles: P50: 1.40 P75: 1.79 P99: 5.11 P99.9: 9.23 P99.99: 514.25 ------------------------------------------------------ [ 0, 1 ] 21562 24.906% 24.906% ##### ( 1, 2 ] 54657 63.133% 88.038% ############# ( 2, 3 ] 6514 7.524% 95.562% ## ( 3, 4 ] 2265 2.616% 98.178% # ( 4, 6 ] 1281 1.480% 99.658% ( 6, 10 ] 259 0.299% 99.957% ( 10, 15 ] 19 0.022% 99.979% ( 22, 34 ] 1 0.001% 99.980% ( 110, 170 ] 2 0.002% 99.983% ( 170, 250 ] 2 0.002% 99.985% ( 250, 380 ] 3 0.003% 99.988% ( 380, 580 ] 2 0.002% 99.991% ( 580, 870 ] 4 0.005% 99.995% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31665 Average: 2.5895 StdDev: 26.60 Min: 1 Median: 1.5934 Max: 4172 Percentiles: P50: 1.59 P75: 1.96 P99: 5.87 P99.9: 9.91 P99.99: 757.24 ------------------------------------------------------ [ 0, 1 ] 3080 9.727% 9.727% ## ( 1, 2 ] 21489 67.864% 77.590% ############## ( 2, 3 ] 3824 12.076% 89.667% ## ( 3, 4 ] 1703 5.378% 95.045% # ( 4, 6 ] 1337 4.222% 99.267% # ( 6, 10 ] 205 0.647% 99.915% ( 10, 15 ] 17 0.054% 99.968% ( 15, 22 ] 1 0.003% 99.972% ( 22, 34 ] 1 0.003% 99.975% ( 51, 76 ] 1 0.003% 99.978% ( 250, 380 ] 1 0.003% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 3 0.009% 99.994% ( 1300, 1900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28612 Average: 5.1983 StdDev: 85.70 Min: 1 Median: 1.8213 Max: 4704 Percentiles: P50: 1.82 P75: 2.54 P99: 8.55 P99.9: 594.07 P99.99: 4501.79 ------------------------------------------------------ [ 0, 1 ] 2133 7.455% 7.455% # ( 1, 2 ] 14821 51.800% 59.255% ########## ( 2, 3 ] 8345 29.166% 88.421% ###### ( 3, 4 ] 1383 4.834% 93.255% # ( 4, 6 ] 1380 4.823% 98.078% # ( 6, 10 ] 414 1.447% 99.525% ( 10, 15 ] 79 0.276% 99.801% ( 15, 22 ] 7 0.024% 99.825% ( 22, 34 ] 2 0.007% 99.832% ( 110, 170 ] 2 0.007% 99.839% ( 170, 250 ] 4 0.014% 99.853% ( 250, 380 ] 3 0.010% 99.864% ( 380, 580 ] 10 0.035% 99.899% ( 580, 870 ] 8 0.028% 99.927% ( 870, 1300 ] 2 0.007% 99.934% ( 1300, 1900 ] 1 0.003% 99.937% ( 1900, 2900 ] 6 0.021% 99.958% ( 2900, 4400 ] 9 0.031% 99.990% ( 4400, 6600 ] 3 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 315 Average: 135.2159 StdDev: 612.66 Min: 0 Median: 2.1400 Max: 5985 Percentiles: P50: 2.14 P75: 3.65 P99: 3825.00 P99.9: 5985.00 P99.99: 5985.00 ------------------------------------------------------ [ 0, 1 ] 38 12.063% 12.063% ## ( 1, 2 ] 109 34.603% 46.667% ####### ( 2, 3 ] 75 23.810% 70.476% ##### ( 3, 4 ] 22 6.984% 77.460% # ( 4, 6 ] 20 6.349% 83.810% # ( 6, 10 ] 18 5.714% 89.524% # ( 10, 15 ] 7 2.222% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 1 0.317% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 8 2.540% 95.556% # ( 870, 1300 ] 2 0.635% 96.190% ( 1300, 1900 ] 5 1.587% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 623.4000 StdDev: 761.79 Min: 76 Median: 250.0000 Max: 3258 Percentiles: P50: 250.00 P75: 1013.33 P99: 3258.00 P99.9: 3258.00 P99.99: 3258.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 3 15.000% 20.000% ### ( 110, 170 ] 5 25.000% 45.000% ##### ( 170, 250 ] 1 5.000% 50.000% # ( 380, 580 ] 4 20.000% 70.000% #### ( 870, 1300 ] 3 15.000% 85.000% ### ( 1300, 1900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 323.20 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.641 H:M:S, 10.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.82 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.409 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-03:23:42 ... thread 0: (1000000,3000000) ops and (328470.3,336771.1) ops/second in (3.044415,8.908127) 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 19/15 2.15 GB 94.4 1.0 0.0 1.0 3.8 2.7 0.0 1.4 88.8 318.4 12.06 11.13 43 0.281 1087K 1117 0.0 0.0 L1 5/5 440.13 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 242.6 242.2 2.60 2.51 2 1.298 639K 799 0.0 0.0 L2 1/0 1.29 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.2 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 14/0 627.64 MB 0.6 0.1 0.1 0.0 0.1 0.1 0.2 1.0 224.9 224.9 0.55 0.51 1 0.554 126K 0 0.0 0.0 L4 170/0 9.58 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.4 1.0 100.7 100.7 1.12 0.70 1 1.116 114K 0 0.0 0.0 L5 1044/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/20 98.84 GB 0.0 2.0 0.7 1.3 4.7 3.4 1.1 1.7 122.3 286.5 16.87 15.37 48 0.352 2095K 1957 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 0.7 1.3 4.7 3.4 1.0 1.7 122.3 286.5 16.87 15.37 48 0.352 2095K 1957 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.0 0.7 1.3 2.0 0.7 0.0 0.0 231.6 231.3 8.91 8.24 9 0.990 2095K 1957 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 348.2 7.96 7.13 39 0.204 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.1 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 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: 4.72 GB write, 529.19 MB/s write, 2.02 GB read, 225.96 MB/s read, 16.9 seconds Interval compaction: 4.72 GB write, 542.52 MB/s write, 2.02 GB read, 231.65 MB/s read, 16.9 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: 664770 Average: 2.1546 StdDev: 14.00 Min: 0 Median: 1.4646 Max: 3926 Percentiles: P50: 1.46 P75: 1.85 P99: 5.39 P99.9: 9.55 P99.99: 14.06 ------------------------------------------------------ [ 0, 1 ] 132243 19.893% 19.893% #### ( 1, 2 ] 430754 64.797% 84.690% ############# ( 2, 3 ] 65344 9.830% 94.520% ## ( 3, 4 ] 21000 3.159% 97.679% # ( 4, 6 ] 12659 1.904% 99.583% ( 6, 10 ] 2373 0.357% 99.940% ( 10, 15 ] 407 0.061% 100.002% ( 15, 22 ] 53 0.008% 100.009% ( 22, 34 ] 11 0.002% 100.011% ( 34, 51 ] 4 0.001% 100.012% ( 51, 76 ] 4 0.001% 100.012% ( 76, 110 ] 1 0.000% 100.012% ( 110, 170 ] 15 0.002% 100.015% ( 170, 250 ] 19 0.003% 100.018% ( 250, 380 ] 14 0.002% 100.020% ( 380, 580 ] 6 0.001% 100.021% ( 580, 870 ] 8 0.001% 100.022% ( 870, 1300 ] 6 0.001% 100.023% ( 1300, 1900 ] 8 0.001% 100.024% ( 1900, 2900 ] 3 0.000% 100.024% ( 2900, 4400 ] 7 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 157931 Average: 2.1349 StdDev: 14.77 Min: 0 Median: 1.4628 Max: 4176 Percentiles: P50: 1.46 P75: 1.84 P99: 5.28 P99.9: 9.14 P99.99: 146.21 ------------------------------------------------------ [ 0, 1 ] 31065 19.670% 19.670% #### ( 1, 2 ] 103511 65.542% 85.212% ############# ( 2, 3 ] 15280 9.675% 94.887% ## ( 3, 4 ] 4636 2.935% 97.822% # ( 4, 6 ] 2916 1.846% 99.669% ( 6, 10 ] 465 0.294% 99.963% ( 10, 15 ] 36 0.023% 99.986% ( 15, 22 ] 2 0.001% 99.987% ( 22, 34 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 76, 110 ] 1 0.001% 99.989% ( 110, 170 ] 2 0.001% 99.991% ( 170, 250 ] 2 0.001% 99.992% ( 250, 380 ] 3 0.002% 99.994% ( 380, 580 ] 2 0.001% 99.995% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 2900, 4400 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31665 Average: 2.5895 StdDev: 26.60 Min: 1 Median: 1.5934 Max: 4172 Percentiles: P50: 1.59 P75: 1.96 P99: 5.87 P99.9: 9.91 P99.99: 757.24 ------------------------------------------------------ [ 0, 1 ] 3080 9.727% 9.727% ## ( 1, 2 ] 21489 67.864% 77.590% ############## ( 2, 3 ] 3824 12.076% 89.667% ## ( 3, 4 ] 1703 5.378% 95.045% # ( 4, 6 ] 1337 4.222% 99.267% # ( 6, 10 ] 205 0.647% 99.915% ( 10, 15 ] 17 0.054% 99.968% ( 15, 22 ] 1 0.003% 99.972% ( 22, 34 ] 1 0.003% 99.975% ( 51, 76 ] 1 0.003% 99.978% ( 250, 380 ] 1 0.003% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 3 0.009% 99.994% ( 1300, 1900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28612 Average: 5.1983 StdDev: 85.70 Min: 1 Median: 1.8213 Max: 4704 Percentiles: P50: 1.82 P75: 2.54 P99: 8.55 P99.9: 594.07 P99.99: 4501.79 ------------------------------------------------------ [ 0, 1 ] 2133 7.455% 7.455% # ( 1, 2 ] 14821 51.800% 59.255% ########## ( 2, 3 ] 8345 29.166% 88.421% ###### ( 3, 4 ] 1383 4.834% 93.255% # ( 4, 6 ] 1380 4.823% 98.078% # ( 6, 10 ] 414 1.447% 99.525% ( 10, 15 ] 79 0.276% 99.801% ( 15, 22 ] 7 0.024% 99.825% ( 22, 34 ] 2 0.007% 99.832% ( 110, 170 ] 2 0.007% 99.839% ( 170, 250 ] 4 0.014% 99.853% ( 250, 380 ] 3 0.010% 99.864% ( 380, 580 ] 10 0.035% 99.899% ( 580, 870 ] 8 0.028% 99.927% ( 870, 1300 ] 2 0.007% 99.934% ( 1300, 1900 ] 1 0.003% 99.937% ( 1900, 2900 ] 6 0.021% 99.958% ( 2900, 4400 ] 9 0.031% 99.990% ( 4400, 6600 ] 3 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 315 Average: 135.2159 StdDev: 612.66 Min: 0 Median: 2.1400 Max: 5985 Percentiles: P50: 2.14 P75: 3.65 P99: 3825.00 P99.9: 5985.00 P99.99: 5985.00 ------------------------------------------------------ [ 0, 1 ] 38 12.063% 12.063% ## ( 1, 2 ] 109 34.603% 46.667% ####### ( 2, 3 ] 75 23.810% 70.476% ##### ( 3, 4 ] 22 6.984% 77.460% # ( 4, 6 ] 20 6.349% 83.810% # ( 6, 10 ] 18 5.714% 89.524% # ( 10, 15 ] 7 2.222% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 1 0.317% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 8 2.540% 95.556% # ( 870, 1300 ] 2 0.635% 96.190% ( 1300, 1900 ] 5 1.587% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 623.4000 StdDev: 761.79 Min: 76 Median: 250.0000 Max: 3258 Percentiles: P50: 250.00 P75: 1013.33 P99: 3258.00 P99.9: 3258.00 P99.99: 3258.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 3 15.000% 20.000% ### ( 110, 170 ] 5 25.000% 45.000% ##### ( 170, 250 ] 1 5.000% 50.000% # ( 380, 580 ] 4 20.000% 70.000% #### ( 870, 1300 ] 3 15.000% 85.000% ### ( 1300, 1900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 323.23 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.052 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.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:0.411 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/18-03:23:45 ... thread 0: (1000000,4000000) ops and (333867.5,336040.5) ops/second in (2.995200,11.903327) 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 17/14 2.46 GB 44.1 1.8 0.0 1.8 5.5 3.7 0.0 1.5 105.7 316.9 17.88 16.61 60 0.298 1918K 2011 0.0 0.0 L1 6/6 612.50 MB 0.0 1.7 1.1 0.6 1.7 1.1 0.1 1.5 239.1 238.2 7.37 7.16 3 2.458 1789K 5908 0.0 0.0 L2 1/0 1.29 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.7 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 14/0 827.77 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.7 1.0 224.9 224.9 0.55 0.51 1 0.554 126K 0 0.0 0.0 L4 170/0 9.58 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.7 1.0 100.7 100.7 1.12 0.70 1 1.116 114K 0 0.0 0.0 L5 1048/0 86.37 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 1256/20 99.82 GB 0.0 3.9 1.4 2.5 7.6 5.1 2.8 2.1 146.2 283.5 27.47 25.50 66 0.416 4077K 7960 0.0 0.0 Int 0/0 0.00 KB 0.0 3.9 1.4 2.5 7.6 5.1 2.6 2.1 146.2 283.5 27.47 25.50 66 0.416 4077K 7960 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 3.9 1.4 2.5 3.9 1.4 0.0 0.0 240.6 240.1 16.69 15.83 13 1.284 4077K 7960 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 350.7 10.78 9.66 53 0.203 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.1 total, 11.9 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: 7.60 GB write, 642.01 MB/s write, 3.92 GB read, 331.07 MB/s read, 27.5 seconds Interval compaction: 7.60 GB write, 654.12 MB/s write, 3.92 GB read, 337.32 MB/s read, 27.5 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: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 21, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 949360 Average: 2.1276 StdDev: 13.73 Min: 0 Median: 1.4495 Max: 3926 Percentiles: P50: 1.45 P75: 1.83 P99: 5.30 P99.9: 9.57 P99.99: 14.21 ------------------------------------------------------ [ 0, 1 ] 197072 20.758% 20.758% #### ( 1, 2 ] 617590 65.053% 85.812% ############# ( 2, 3 ] 86951 9.159% 94.971% ## ( 3, 4 ] 27859 2.935% 97.905% # ( 4, 6 ] 16015 1.687% 99.592% ( 6, 10 ] 3281 0.346% 99.938% ( 10, 15 ] 593 0.062% 100.000% ( 15, 22 ] 66 0.007% 100.007% ( 22, 34 ] 12 0.001% 100.008% ( 34, 51 ] 5 0.001% 100.009% ( 51, 76 ] 6 0.001% 100.009% ( 76, 110 ] 13 0.001% 100.011% ( 110, 170 ] 30 0.003% 100.014% ( 170, 250 ] 31 0.003% 100.017% ( 250, 380 ] 21 0.002% 100.019% ( 380, 580 ] 11 0.001% 100.021% ( 580, 870 ] 11 0.001% 100.022% ( 870, 1300 ] 9 0.001% 100.023% ( 1300, 1900 ] 8 0.001% 100.024% ( 1900, 2900 ] 6 0.001% 100.024% ( 2900, 4400 ] 9 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 159790 Average: 2.2186 StdDev: 17.18 Min: 0 Median: 1.4646 Max: 4176 Percentiles: P50: 1.46 P75: 1.85 P99: 5.30 P99.9: 9.31 P99.99: 581.52 ------------------------------------------------------ [ 0, 1 ] 31218 19.537% 19.537% #### ( 1, 2 ] 104779 65.573% 85.110% ############# ( 2, 3 ] 15523 9.715% 94.824% ## ( 3, 4 ] 4743 2.968% 97.793% # ( 4, 6 ] 2978 1.864% 99.656% ( 6, 10 ] 471 0.295% 99.951% ( 10, 15 ] 38 0.024% 99.975% ( 15, 22 ] 2 0.001% 99.976% ( 22, 34 ] 1 0.001% 99.977% ( 51, 76 ] 1 0.001% 99.977% ( 76, 110 ] 1 0.001% 99.978% ( 110, 170 ] 2 0.001% 99.979% ( 170, 250 ] 2 0.001% 99.981% ( 250, 380 ] 9 0.006% 99.986% ( 380, 580 ] 6 0.004% 99.990% ( 580, 870 ] 4 0.003% 99.992% ( 870, 1300 ] 6 0.004% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 2900, 4400 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31665 Average: 2.5895 StdDev: 26.60 Min: 1 Median: 1.5934 Max: 4172 Percentiles: P50: 1.59 P75: 1.96 P99: 5.87 P99.9: 9.91 P99.99: 757.24 ------------------------------------------------------ [ 0, 1 ] 3080 9.727% 9.727% ## ( 1, 2 ] 21489 67.864% 77.590% ############## ( 2, 3 ] 3824 12.076% 89.667% ## ( 3, 4 ] 1703 5.378% 95.045% # ( 4, 6 ] 1337 4.222% 99.267% # ( 6, 10 ] 205 0.647% 99.915% ( 10, 15 ] 17 0.054% 99.968% ( 15, 22 ] 1 0.003% 99.972% ( 22, 34 ] 1 0.003% 99.975% ( 51, 76 ] 1 0.003% 99.978% ( 250, 380 ] 1 0.003% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 3 0.009% 99.994% ( 1300, 1900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28612 Average: 5.1983 StdDev: 85.70 Min: 1 Median: 1.8213 Max: 4704 Percentiles: P50: 1.82 P75: 2.54 P99: 8.55 P99.9: 594.07 P99.99: 4501.79 ------------------------------------------------------ [ 0, 1 ] 2133 7.455% 7.455% # ( 1, 2 ] 14821 51.800% 59.255% ########## ( 2, 3 ] 8345 29.166% 88.421% ###### ( 3, 4 ] 1383 4.834% 93.255% # ( 4, 6 ] 1380 4.823% 98.078% # ( 6, 10 ] 414 1.447% 99.525% ( 10, 15 ] 79 0.276% 99.801% ( 15, 22 ] 7 0.024% 99.825% ( 22, 34 ] 2 0.007% 99.832% ( 110, 170 ] 2 0.007% 99.839% ( 170, 250 ] 4 0.014% 99.853% ( 250, 380 ] 3 0.010% 99.864% ( 380, 580 ] 10 0.035% 99.899% ( 580, 870 ] 8 0.028% 99.927% ( 870, 1300 ] 2 0.007% 99.934% ( 1300, 1900 ] 1 0.003% 99.937% ( 1900, 2900 ] 6 0.021% 99.958% ( 2900, 4400 ] 9 0.031% 99.990% ( 4400, 6600 ] 3 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 315 Average: 135.2159 StdDev: 612.66 Min: 0 Median: 2.1400 Max: 5985 Percentiles: P50: 2.14 P75: 3.65 P99: 3825.00 P99.9: 5985.00 P99.99: 5985.00 ------------------------------------------------------ [ 0, 1 ] 38 12.063% 12.063% ## ( 1, 2 ] 109 34.603% 46.667% ####### ( 2, 3 ] 75 23.810% 70.476% ##### ( 3, 4 ] 22 6.984% 77.460% # ( 4, 6 ] 20 6.349% 83.810% # ( 6, 10 ] 18 5.714% 89.524% # ( 10, 15 ] 7 2.222% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 1 0.317% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 8 2.540% 95.556% # ( 870, 1300 ] 2 0.635% 96.190% ( 1300, 1900 ] 5 1.587% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 681.6000 StdDev: 821.65 Min: 76 Median: 315.0000 Max: 3566 Percentiles: P50: 315.00 P75: 1128.00 P99: 3566.00 P99.9: 3566.00 P99.99: 3566.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 6 15.000% 17.500% ### ( 110, 170 ] 10 25.000% 42.500% ##### ( 170, 250 ] 2 5.000% 47.500% # ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 5 12.500% 65.000% ### ( 580, 870 ] 1 2.500% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 5 12.500% 92.500% ### ( 1900, 2900 ] 1 2.500% 95.000% # ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.55 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.470 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.59 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.418 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-03:23:50 ... thread 0: (1000000,5000000) ops and (192986.7,292653.8) ops/second in (5.181704,17.085031) 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 3.50 GB 94.4 3.1 0.0 3.1 7.9 4.7 0.0 1.7 124.2 311.7 25.86 24.17 81 0.319 3262K 3408 0.0 0.0 L1 6/6 612.50 MB 0.0 1.7 1.1 0.6 1.7 1.1 0.1 1.5 239.1 238.2 7.37 7.16 3 2.458 1789K 5908 0.0 0.0 L2 1/0 1.29 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.7 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 14/0 827.77 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.7 1.0 224.9 224.9 0.55 0.51 1 0.554 126K 0 0.0 0.0 L4 170/0 9.58 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.7 1.0 100.7 100.7 1.12 0.70 1 1.116 114K 0 0.0 0.0 L5 1048/0 86.37 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 1257/20 100.86 GB 0.0 5.2 1.4 3.8 9.9 6.1 2.8 2.1 150.6 287.2 35.45 33.06 87 0.407 5420K 9357 0.0 0.0 Int 0/0 0.00 KB 0.0 5.2 1.4 3.8 9.9 6.1 2.6 2.1 150.6 287.2 35.45 33.06 87 0.407 5420K 9357 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.2 1.4 3.8 5.2 1.4 0.0 0.0 247.4 247.0 21.58 20.64 18 1.199 5420K 9357 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.7 13.87 12.42 69 0.201 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): 17.3 total, 17.1 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.94 GB write, 588.04 MB/s write, 5.21 GB read, 308.40 MB/s read, 35.4 seconds Interval compaction: 9.94 GB write, 595.76 MB/s write, 5.21 GB read, 312.45 MB/s read, 35.4 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: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 22, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1489864 Average: 2.1915 StdDev: 13.81 Min: 0 Median: 1.4660 Max: 3926 Percentiles: P50: 1.47 P75: 1.85 P99: 5.40 P99.9: 9.90 P99.99: 32.11 ------------------------------------------------------ [ 0, 1 ] 287073 19.268% 19.268% #### ( 1, 2 ] 982437 65.941% 85.210% ############# ( 2, 3 ] 143317 9.619% 94.829% ## ( 3, 4 ] 44397 2.980% 97.809% # ( 4, 6 ] 25297 1.698% 99.507% ( 6, 10 ] 6010 0.403% 99.911% ( 10, 15 ] 1036 0.070% 99.980% ( 15, 22 ] 134 0.009% 99.989% ( 22, 34 ] 19 0.001% 99.990% ( 34, 51 ] 7 0.000% 99.991% ( 51, 76 ] 10 0.001% 99.991% ( 76, 110 ] 101 0.007% 99.998% ( 110, 170 ] 153 0.010% 100.009% ( 170, 250 ] 93 0.006% 100.015% ( 250, 380 ] 61 0.004% 100.019% ( 380, 580 ] 48 0.003% 100.022% ( 580, 870 ] 29 0.002% 100.024% ( 870, 1300 ] 15 0.001% 100.025% ( 1300, 1900 ] 13 0.001% 100.026% ( 1900, 2900 ] 12 0.001% 100.027% ( 2900, 4400 ] 11 0.001% 100.027% ** Level 1 read latency histogram (micros): Count: 245216 Average: 2.3481 StdDev: 16.09 Min: 0 Median: 1.4764 Max: 4176 Percentiles: P50: 1.48 P75: 1.86 P99: 5.73 P99.9: 14.73 P99.99: 575.26 ------------------------------------------------------ [ 0, 1 ] 45945 18.737% 18.737% #### ( 1, 2 ] 160920 65.624% 84.360% ############# ( 2, 3 ] 24621 10.041% 94.401% ## ( 3, 4 ] 7138 2.911% 97.312% # ( 4, 6 ] 4794 1.955% 99.267% ( 6, 10 ] 1445 0.589% 99.856% ( 10, 15 ] 114 0.046% 99.903% ( 15, 22 ] 18 0.007% 99.910% ( 22, 34 ] 1 0.000% 99.910% ( 34, 51 ] 1 0.000% 99.911% ( 51, 76 ] 1 0.000% 99.911% ( 76, 110 ] 44 0.018% 99.929% ( 110, 170 ] 76 0.031% 99.960% ( 170, 250 ] 30 0.012% 99.972% ( 250, 380 ] 22 0.009% 99.981% ( 380, 580 ] 22 0.009% 99.990% ( 580, 870 ] 9 0.004% 99.994% ( 870, 1300 ] 8 0.003% 99.997% ( 1300, 1900 ] 4 0.002% 99.999% ( 1900, 2900 ] 1 0.000% 99.999% ( 2900, 4400 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31665 Average: 2.5895 StdDev: 26.60 Min: 1 Median: 1.5934 Max: 4172 Percentiles: P50: 1.59 P75: 1.96 P99: 5.87 P99.9: 9.91 P99.99: 757.24 ------------------------------------------------------ [ 0, 1 ] 3080 9.727% 9.727% ## ( 1, 2 ] 21489 67.864% 77.590% ############## ( 2, 3 ] 3824 12.076% 89.667% ## ( 3, 4 ] 1703 5.378% 95.045% # ( 4, 6 ] 1337 4.222% 99.267% # ( 6, 10 ] 205 0.647% 99.915% ( 10, 15 ] 17 0.054% 99.968% ( 15, 22 ] 1 0.003% 99.972% ( 22, 34 ] 1 0.003% 99.975% ( 51, 76 ] 1 0.003% 99.978% ( 250, 380 ] 1 0.003% 99.981% ( 380, 580 ] 1 0.003% 99.984% ( 580, 870 ] 3 0.009% 99.994% ( 1300, 1900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28612 Average: 5.1983 StdDev: 85.70 Min: 1 Median: 1.8213 Max: 4704 Percentiles: P50: 1.82 P75: 2.54 P99: 8.55 P99.9: 594.07 P99.99: 4501.79 ------------------------------------------------------ [ 0, 1 ] 2133 7.455% 7.455% # ( 1, 2 ] 14821 51.800% 59.255% ########## ( 2, 3 ] 8345 29.166% 88.421% ###### ( 3, 4 ] 1383 4.834% 93.255% # ( 4, 6 ] 1380 4.823% 98.078% # ( 6, 10 ] 414 1.447% 99.525% ( 10, 15 ] 79 0.276% 99.801% ( 15, 22 ] 7 0.024% 99.825% ( 22, 34 ] 2 0.007% 99.832% ( 110, 170 ] 2 0.007% 99.839% ( 170, 250 ] 4 0.014% 99.853% ( 250, 380 ] 3 0.010% 99.864% ( 380, 580 ] 10 0.035% 99.899% ( 580, 870 ] 8 0.028% 99.927% ( 870, 1300 ] 2 0.007% 99.934% ( 1300, 1900 ] 1 0.003% 99.937% ( 1900, 2900 ] 6 0.021% 99.958% ( 2900, 4400 ] 9 0.031% 99.990% ( 4400, 6600 ] 3 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 315 Average: 135.2159 StdDev: 612.66 Min: 0 Median: 2.1400 Max: 5985 Percentiles: P50: 2.14 P75: 3.65 P99: 3825.00 P99.9: 5985.00 P99.99: 5985.00 ------------------------------------------------------ [ 0, 1 ] 38 12.063% 12.063% ## ( 1, 2 ] 109 34.603% 46.667% ####### ( 2, 3 ] 75 23.810% 70.476% ##### ( 3, 4 ] 22 6.984% 77.460% # ( 4, 6 ] 20 6.349% 83.810% # ( 6, 10 ] 18 5.714% 89.524% # ( 10, 15 ] 7 2.222% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 1 0.317% 92.698% ( 380, 580 ] 1 0.317% 93.016% ( 580, 870 ] 8 2.540% 95.556% # ( 870, 1300 ] 2 0.635% 96.190% ( 1300, 1900 ] 5 1.587% 97.778% ( 1900, 2900 ] 2 0.635% 98.413% ( 2900, 4400 ] 3 0.952% 99.365% ( 4400, 6600 ] 2 0.635% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 681.6000 StdDev: 821.65 Min: 76 Median: 315.0000 Max: 3566 Percentiles: P50: 315.00 P75: 1128.00 P99: 3566.00 P99.9: 3566.00 P99.99: 3566.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 6 15.000% 17.500% ### ( 110, 170 ] 10 25.000% 42.500% ##### ( 170, 250 ] 2 5.000% 47.500% # ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 5 12.500% 65.000% ### ( 580, 870 ] 1 2.500% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 5 12.500% 92.500% ### ( 1900, 2900 ] 1 2.500% 95.000% # ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 17.3 total, 5.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 284.26 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:4.052 H:M:S, 23.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 189.94 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:2.582 H:M:S, 49.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-03:23:56 ... thread 0: (1000000,6000000) ops and (170925.3,261602.7) ops/second in (5.850508,22.935539) 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 15/13 2.64 GB 18.9 4.2 0.0 4.2 9.8 5.7 0.0 1.7 129.8 305.1 33.01 30.64 96 0.344 4348K 6088 0.0 0.0 L1 12/12 1.35 GB 0.0 4.1 2.9 1.2 4.1 2.9 0.1 1.4 233.9 232.1 17.96 17.33 4 4.489 4265K 32K 0.0 0.0 L2 2/1 257.56 MB 1.3 0.1 0.1 0.1 0.1 0.1 1.7 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 34/9 1.39 GB 1.0 1.6 0.8 0.9 1.6 0.7 0.8 2.1 201.6 200.8 8.23 7.34 7 1.175 1684K 7123 0.0 0.0 L4 172/6 9.75 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.8 1.0 100.7 100.7 1.12 0.70 1 1.116 114K 0 0.0 0.0 L5 1048/0 86.37 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 1283/41 101.75 GB 0.0 10.1 3.8 6.3 15.8 9.4 4.1 2.8 170.6 265.1 60.85 56.52 109 0.558 10M 45K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.1 3.8 6.3 15.8 9.4 3.9 2.8 170.6 265.1 60.85 56.52 109 0.558 10M 45K 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 10.1 3.8 6.3 10.1 3.8 0.0 0.0 236.5 235.5 43.89 41.60 27 1.625 10M 45K 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 341.7 16.96 14.92 82 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): 23.2 total, 22.9 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: 15.75 GB write, 696.40 MB/s write, 10.14 GB read, 448.18 MB/s read, 60.9 seconds Interval compaction: 15.75 GB write, 703.22 MB/s write, 10.14 GB read, 452.56 MB/s read, 60.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 29, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 29, interval: 40 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1968448 Average: 2.3482 StdDev: 15.72 Min: 0 Median: 1.4917 Max: 3926 Percentiles: P50: 1.49 P75: 1.87 P99: 5.67 P99.9: 12.23 P99.99: 175.22 ------------------------------------------------------ [ 0, 1 ] 348432 17.701% 17.701% #### ( 1, 2 ] 1293103 65.691% 83.392% ############# ( 2, 3 ] 206431 10.487% 93.879% ## ( 3, 4 ] 66367 3.372% 97.251% # ( 4, 6 ] 41356 2.101% 99.352% ( 6, 10 ] 10038 0.510% 99.862% ( 10, 15 ] 1693 0.086% 99.948% ( 15, 22 ] 222 0.011% 99.959% ( 22, 34 ] 28 0.001% 99.960% ( 34, 51 ] 9 0.000% 99.961% ( 51, 76 ] 22 0.001% 99.962% ( 76, 110 ] 209 0.011% 99.973% ( 110, 170 ] 332 0.017% 99.990% ( 170, 250 ] 171 0.009% 99.998% ( 250, 380 ] 163 0.008% 100.007% ( 380, 580 ] 136 0.007% 100.013% ( 580, 870 ] 121 0.006% 100.020% ( 870, 1300 ] 60 0.003% 100.023% ( 1300, 1900 ] 30 0.002% 100.024% ( 1900, 2900 ] 17 0.001% 100.025% ( 2900, 4400 ] 11 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 656047 Average: 3.0536 StdDev: 21.17 Min: 0 Median: 1.6644 Max: 4176 Percentiles: P50: 1.66 P75: 2.27 P99: 8.15 P99.9: 29.96 P99.99: 240.38 ------------------------------------------------------ [ 0, 1 ] 63517 9.682% 9.682% ## ( 1, 2 ] 398120 60.685% 70.366% ############ ( 2, 3 ] 111013 16.922% 87.288% ### ( 3, 4 ] 38015 5.795% 93.083% # ( 4, 6 ] 33625 5.125% 98.208% # ( 6, 10 ] 9659 1.472% 99.680% ( 10, 15 ] 1264 0.193% 99.873% ( 15, 22 ] 168 0.026% 99.898% ( 22, 34 ] 15 0.002% 99.901% ( 34, 51 ] 4 0.001% 99.901% ( 51, 76 ] 10 0.002% 99.903% ( 76, 110 ] 189 0.029% 99.932% ( 110, 170 ] 239 0.036% 99.968% ( 170, 250 ] 163 0.025% 99.993% ( 250, 380 ] 163 0.025% 100.018% ( 380, 580 ] 161 0.025% 100.042% ( 580, 870 ] 86 0.013% 100.055% ( 870, 1300 ] 52 0.008% 100.063% ( 1300, 1900 ] 24 0.004% 100.067% ( 1900, 2900 ] 8 0.001% 100.068% ( 2900, 4400 ] 3 0.000% 100.069% ** Level 2 read latency histogram (micros): Count: 47991 Average: 4.1548 StdDev: 38.59 Min: 1 Median: 1.6929 Max: 4172 Percentiles: P50: 1.69 P75: 2.37 P99: 9.04 P99.9: 526.73 P99.99: 1540.18 ------------------------------------------------------ [ 0, 1 ] 3361 7.003% 7.003% # ( 1, 2 ] 29778 62.049% 69.053% ############ ( 2, 3 ] 7773 16.197% 85.249% ### ( 3, 4 ] 3198 6.664% 91.913% # ( 4, 6 ] 2861 5.962% 97.875% # ( 6, 10 ] 710 1.479% 99.354% ( 10, 15 ] 120 0.250% 99.604% ( 15, 22 ] 13 0.027% 99.631% ( 22, 34 ] 3 0.006% 99.637% ( 51, 76 ] 1 0.002% 99.640% ( 76, 110 ] 4 0.008% 99.648% ( 110, 170 ] 29 0.060% 99.708% ( 170, 250 ] 27 0.056% 99.765% ( 250, 380 ] 43 0.090% 99.854% ( 380, 580 ] 30 0.063% 99.917% ( 580, 870 ] 27 0.056% 99.973% ( 870, 1300 ] 7 0.015% 99.987% ( 1300, 1900 ] 3 0.006% 99.994% ( 1900, 2900 ] 2 0.004% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 126661 Average: 3.9282 StdDev: 46.39 Min: 1 Median: 1.8719 Max: 4704 Percentiles: P50: 1.87 P75: 2.71 P99: 8.63 P99.9: 177.85 P99.99: 664.59 ------------------------------------------------------ [ 0, 1 ] 4145 3.273% 3.273% # ( 1, 2 ] 67880 53.592% 56.864% ########### ( 2, 3 ] 32471 25.636% 82.501% ##### ( 3, 4 ] 10156 8.018% 90.519% ## ( 4, 6 ] 9504 7.503% 98.022% ## ( 6, 10 ] 1885 1.488% 99.511% ( 10, 15 ] 388 0.306% 99.817% ( 15, 22 ] 39 0.031% 99.848% ( 22, 34 ] 5 0.004% 99.852% ( 34, 51 ] 2 0.002% 99.853% ( 51, 76 ] 2 0.002% 99.855% ( 76, 110 ] 16 0.013% 99.867% ( 110, 170 ] 39 0.031% 99.898% ( 170, 250 ] 34 0.027% 99.925% ( 250, 380 ] 36 0.028% 99.953% ( 380, 580 ] 38 0.030% 99.983% ( 580, 870 ] 32 0.025% 100.009% ( 870, 1300 ] 8 0.006% 100.015% ( 1300, 1900 ] 4 0.003% 100.018% ( 1900, 2900 ] 9 0.007% 100.025% ( 2900, 4400 ] 10 0.008% 100.033% ( 4400, 6600 ] 3 0.002% 100.036% ** Level 4 read latency histogram (micros): Count: 345 Average: 200.6638 StdDev: 655.31 Min: 0 Median: 2.3400 Max: 5985 Percentiles: P50: 2.34 P75: 5.47 P99: 3856.25 P99.9: 5985.00 P99.99: 5985.00 ------------------------------------------------------ [ 0, 1 ] 38 11.014% 11.014% ## ( 1, 2 ] 109 31.594% 42.609% ###### ( 2, 3 ] 75 21.739% 64.348% #### ( 3, 4 ] 22 6.377% 70.725% # ( 4, 6 ] 20 5.797% 76.522% # ( 6, 10 ] 18 5.217% 81.739% # ( 10, 15 ] 7 2.029% 83.768% ( 110, 170 ] 2 0.580% 84.348% ( 170, 250 ] 4 1.159% 85.507% ( 250, 380 ] 5 1.449% 86.957% ( 380, 580 ] 6 1.739% 88.696% ( 580, 870 ] 14 4.058% 92.754% # ( 870, 1300 ] 5 1.449% 94.203% ( 1300, 1900 ] 11 3.188% 97.391% # ( 1900, 2900 ] 3 0.870% 98.261% ( 2900, 4400 ] 4 1.159% 99.420% ( 4400, 6600 ] 2 0.580% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 681.6000 StdDev: 821.65 Min: 76 Median: 315.0000 Max: 3566 Percentiles: P50: 315.00 P75: 1128.00 P99: 3566.00 P99.9: 3566.00 P99.99: 3566.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 6 15.000% 17.500% ### ( 110, 170 ] 10 25.000% 42.500% ##### ( 170, 250 ] 2 5.000% 47.500% # ( 250, 380 ] 2 5.000% 52.500% # ( 380, 580 ] 5 12.500% 65.000% ### ( 580, 870 ] 1 2.500% 67.500% # ( 870, 1300 ] 5 12.500% 80.000% ### ( 1300, 1900 ] 5 12.500% 92.500% ### ( 1900, 2900 ] 1 2.500% 95.000% # ( 2900, 4400 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 23.2 total, 5.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 254.95 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:7.174 H:M:S, 31.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 168.22 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:3.121 H:M:S, 53.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 9 num-running-flushes: 1 2024/11/18-03:24:00 ... thread 0: (1000000,7000000) ops and (291746.3,265521.9) ops/second in (3.427636,26.363175) 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 19/13 3.56 GB 119.6 5.0 0.0 5.0 11.6 6.6 0.0 1.8 129.6 298.6 39.85 36.47 112 0.356 5244K 7073 0.0 0.0 L1 12/12 1.35 GB 0.0 4.1 2.9 1.2 4.1 2.9 0.1 1.4 233.9 232.1 17.96 17.33 4 4.489 4265K 32K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 1.7 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 25/0 955.71 MB 1.0 2.2 1.0 1.2 2.2 1.0 0.8 2.2 200.7 199.8 11.20 9.94 9 1.244 2282K 10K 0.0 0.0 L4 175/0 9.47 GB 1.0 0.8 0.8 0.0 0.8 0.8 0.8 1.0 119.0 118.9 7.26 4.25 17 0.427 868K 663 0.0 0.0 L5 1060/0 87.35 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 1291/25 102.67 GB 0.0 12.3 4.8 7.5 18.8 11.3 5.0 2.9 164.1 251.2 76.81 68.50 143 0.537 12M 50K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.3 4.8 7.5 18.8 11.3 4.9 2.9 164.1 251.2 76.81 68.50 143 0.537 12M 50K 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.3 4.8 7.5 12.3 4.7 0.0 0.0 222.2 221.3 56.71 51.16 48 1.181 12M 50K 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 335.4 20.10 17.35 95 0.212 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): 26.6 total, 26.4 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: 18.84 GB write, 725.55 MB/s write, 12.31 GB read, 473.97 MB/s read, 76.8 seconds Interval compaction: 18.84 GB write, 731.73 MB/s write, 12.31 GB read, 478.01 MB/s read, 76.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 45, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 45, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2371442 Average: 2.4439 StdDev: 18.77 Min: 0 Median: 1.5211 Max: 6798 Percentiles: P50: 1.52 P75: 1.91 P99: 5.84 P99.9: 12.77 P99.99: 162.46 ------------------------------------------------------ [ 0, 1 ] 383809 16.185% 16.185% ### ( 1, 2 ] 1538873 64.892% 81.076% ############# ( 2, 3 ] 275143 11.602% 92.679% ## ( 3, 4 ] 91373 3.853% 96.532% # ( 4, 6 ] 63640 2.684% 99.215% # ( 6, 10 ] 14874 0.627% 99.843% ( 10, 15 ] 2456 0.104% 99.946% ( 15, 22 ] 296 0.012% 99.959% ( 22, 34 ] 32 0.001% 99.960% ( 34, 51 ] 12 0.001% 99.961% ( 51, 76 ] 24 0.001% 99.962% ( 76, 110 ] 291 0.012% 99.974% ( 110, 170 ] 439 0.019% 99.992% ( 170, 250 ] 226 0.010% 100.002% ( 250, 380 ] 191 0.008% 100.010% ( 380, 580 ] 186 0.008% 100.018% ( 580, 870 ] 143 0.006% 100.024% ( 870, 1300 ] 72 0.003% 100.027% ( 1300, 1900 ] 35 0.001% 100.028% ( 1900, 2900 ] 22 0.001% 100.029% ( 2900, 4400 ] 26 0.001% 100.030% ( 6600, 9900 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 702303 Average: 3.1748 StdDev: 30.33 Min: 0 Median: 1.6745 Max: 8487 Percentiles: P50: 1.67 P75: 2.31 P99: 8.27 P99.9: 80.80 P99.99: 283.04 ------------------------------------------------------ [ 0, 1 ] 64970 9.251% 9.251% ## ( 1, 2 ] 424294 60.415% 69.666% ############ ( 2, 3 ] 121479 17.297% 86.963% ### ( 3, 4 ] 41492 5.908% 92.871% # ( 4, 6 ] 36953 5.262% 98.133% # ( 6, 10 ] 10740 1.529% 99.662% ( 10, 15 ] 1432 0.204% 99.866% ( 15, 22 ] 183 0.026% 99.892% ( 22, 34 ] 16 0.002% 99.894% ( 34, 51 ] 5 0.001% 99.895% ( 51, 76 ] 10 0.001% 99.896% ( 76, 110 ] 189 0.027% 99.923% ( 110, 170 ] 244 0.035% 99.958% ( 170, 250 ] 179 0.025% 99.983% ( 250, 380 ] 184 0.026% 100.010% ( 380, 580 ] 175 0.025% 100.034% ( 580, 870 ] 99 0.014% 100.049% ( 870, 1300 ] 60 0.009% 100.057% ( 1300, 1900 ] 25 0.004% 100.061% ( 1900, 2900 ] 12 0.002% 100.062% ( 2900, 4400 ] 8 0.001% 100.064% ( 4400, 6600 ] 2 0.000% 100.064% ( 6600, 9900 ] 3 0.000% 100.064% ** Level 2 read latency histogram (micros): Count: 47991 Average: 4.1548 StdDev: 38.59 Min: 1 Median: 1.6929 Max: 4172 Percentiles: P50: 1.69 P75: 2.37 P99: 9.04 P99.9: 526.73 P99.99: 1540.18 ------------------------------------------------------ [ 0, 1 ] 3361 7.003% 7.003% # ( 1, 2 ] 29778 62.049% 69.053% ############ ( 2, 3 ] 7773 16.197% 85.249% ### ( 3, 4 ] 3198 6.664% 91.913% # ( 4, 6 ] 2861 5.962% 97.875% # ( 6, 10 ] 710 1.479% 99.354% ( 10, 15 ] 120 0.250% 99.604% ( 15, 22 ] 13 0.027% 99.631% ( 22, 34 ] 3 0.006% 99.637% ( 51, 76 ] 1 0.002% 99.640% ( 76, 110 ] 4 0.008% 99.648% ( 110, 170 ] 29 0.060% 99.708% ( 170, 250 ] 27 0.056% 99.765% ( 250, 380 ] 43 0.090% 99.854% ( 380, 580 ] 30 0.063% 99.917% ( 580, 870 ] 27 0.056% 99.973% ( 870, 1300 ] 7 0.015% 99.987% ( 1300, 1900 ] 3 0.006% 99.994% ( 1900, 2900 ] 2 0.004% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 345345 Average: 4.1853 StdDev: 62.67 Min: 1 Median: 1.9683 Max: 7627 Percentiles: P50: 1.97 P75: 2.90 P99: 8.33 P99.9: 13.75 P99.99: 16.83 ------------------------------------------------------ [ 0, 1 ] 6567 1.902% 1.902% ( 1, 2 ] 171551 49.675% 51.577% ########## ( 2, 3 ] 89989 26.058% 77.635% ##### ( 3, 4 ] 34859 10.094% 87.729% ## ( 4, 6 ] 35768 10.357% 98.086% ## ( 6, 10 ] 5426 1.571% 99.657% ( 10, 15 ] 1121 0.325% 99.981% ( 15, 22 ] 113 0.033% 100.014% ( 22, 34 ] 7 0.002% 100.016% ( 34, 51 ] 2 0.001% 100.017% ( 51, 76 ] 3 0.001% 100.018% ( 76, 110 ] 26 0.008% 100.025% ( 110, 170 ] 77 0.022% 100.047% ( 170, 250 ] 54 0.016% 100.063% ( 250, 380 ] 68 0.020% 100.083% ( 380, 580 ] 59 0.017% 100.100% ( 580, 870 ] 49 0.014% 100.114% ( 870, 1300 ] 20 0.006% 100.120% ( 1300, 1900 ] 10 0.003% 100.123% ( 1900, 2900 ] 13 0.004% 100.127% ( 2900, 4400 ] 46 0.013% 100.140% ( 4400, 6600 ] 13 0.004% 100.144% ( 6600, 9900 ] 4 0.001% 100.145% ** Level 4 read latency histogram (micros): Count: 8289 Average: 104.5186 StdDev: 414.15 Min: 0 Median: 2.2914 Max: 9166 Percentiles: P50: 2.29 P75: 3.80 P99: 1816.66 P99.9: 4387.25 P99.99: 6788.21 ------------------------------------------------------ [ 0, 1 ] 168 2.027% 2.027% ( 1, 2 ] 3443 41.537% 43.564% ######## ( 2, 3 ] 1831 22.090% 65.653% #### ( 3, 4 ] 974 11.751% 77.404% ## ( 4, 6 ] 547 6.599% 84.003% # ( 6, 10 ] 195 2.353% 86.355% ( 10, 15 ] 44 0.531% 86.886% ( 15, 22 ] 7 0.084% 86.971% ( 76, 110 ] 24 0.290% 87.260% ( 110, 170 ] 94 1.134% 88.394% ( 170, 250 ] 103 1.243% 89.637% ( 250, 380 ] 143 1.725% 91.362% ( 380, 580 ] 208 2.509% 93.871% # ( 580, 870 ] 233 2.811% 96.682% # ( 870, 1300 ] 137 1.653% 98.335% ( 1300, 1900 ] 64 0.772% 99.107% ( 1900, 2900 ] 32 0.386% 99.493% ( 2900, 4400 ] 34 0.410% 99.903% ( 4400, 6600 ] 7 0.084% 99.988% ( 6600, 9900 ] 3 0.036% 100.024% ** Level 5 read latency histogram (micros): Count: 100 Average: 835.9100 StdDev: 1025.48 Min: 76 Median: 356.3636 Max: 3606 Percentiles: P50: 356.36 P75: 1138.75 P99: 3606.00 P99.9: 3606.00 P99.99: 3606.00 ------------------------------------------------------ ( 51, 76 ] 1 1.000% 1.000% ( 76, 110 ] 17 17.000% 18.000% ### ( 110, 170 ] 14 14.000% 32.000% ### ( 170, 250 ] 9 9.000% 41.000% ## ( 250, 380 ] 11 11.000% 52.000% ## ( 380, 580 ] 9 9.000% 61.000% ## ( 580, 870 ] 9 9.000% 70.000% ## ( 870, 1300 ] 8 8.000% 78.000% ## ( 1300, 1900 ] 7 7.000% 85.000% # ( 1900, 2900 ] 5 5.000% 90.000% # ( 2900, 4400 ] 10 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 26.6 total, 3.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 259.10 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:7.804 H:M:S, 29.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 287.13 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.630 H:M:S, 18.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-03:24:10 ... thread 0: (1000000,8000000) ops and (100212.5,220131.2) ops/second in (9.978793,36.341968) 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/13 4.60 GB 225.9 7.3 0.0 7.3 14.9 7.6 0.0 2.0 144.1 294.0 52.01 47.88 133 0.391 7609K 14K 0.0 0.0 L1 12/12 1.35 GB 0.0 4.1 2.9 1.2 4.1 2.9 0.1 1.4 233.9 232.1 17.96 17.33 4 4.489 4265K 32K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 1.7 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 25/0 955.71 MB 1.0 2.2 1.0 1.2 2.2 1.0 0.8 2.2 200.7 199.8 11.20 9.94 9 1.244 2282K 10K 0.0 0.0 L4 175/0 9.47 GB 1.0 0.8 0.8 0.0 0.8 0.8 0.8 1.0 119.0 118.9 7.26 4.25 17 0.427 868K 663 0.0 0.0 L5 1060/0 87.35 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 1290/25 103.71 GB 0.0 14.6 4.8 9.8 22.2 12.3 5.0 2.9 167.8 255.0 88.97 79.92 164 0.543 15M 58K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.6 4.8 9.8 22.2 12.3 4.9 2.9 167.8 255.0 88.97 79.92 164 0.543 15M 58K 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 14.6 4.8 9.8 14.5 4.7 0.0 0.0 226.9 226.0 65.81 59.84 53 1.242 15M 58K 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 337.3 23.16 20.08 111 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): 36.6 total, 36.3 interval Flush(GB): cumulative 7.629, interval 7.629 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: 22.15 GB write, 620.35 MB/s write, 14.58 GB read, 408.34 MB/s read, 89.0 seconds Interval compaction: 22.15 GB write, 624.18 MB/s write, 14.58 GB read, 410.87 MB/s read, 89.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 46, interval: 67 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3217350 Average: 2.5920 StdDev: 18.69 Min: 0 Median: 1.5143 Max: 6798 Percentiles: P50: 1.51 P75: 1.90 P99: 5.96 P99.9: 110.10 P99.99: 260.23 ------------------------------------------------------ [ 0, 1 ] 524277 16.295% 16.295% ### ( 1, 2 ] 2108518 65.536% 81.831% ############# ( 2, 3 ] 358109 11.131% 92.962% ## ( 3, 4 ] 118226 3.675% 96.636% # ( 4, 6 ] 77726 2.416% 99.052% ( 6, 10 ] 21417 0.666% 99.718% ( 10, 15 ] 3235 0.101% 99.818% ( 15, 22 ] 372 0.012% 99.830% ( 22, 34 ] 38 0.001% 99.831% ( 34, 51 ] 13 0.000% 99.832% ( 51, 76 ] 68 0.002% 99.834% ( 76, 110 ] 2131 0.066% 99.900% ( 110, 170 ] 2281 0.071% 99.971% ( 170, 250 ] 582 0.018% 99.989% ( 250, 380 ] 461 0.014% 100.003% ( 380, 580 ] 383 0.012% 100.015% ( 580, 870 ] 218 0.007% 100.022% ( 870, 1300 ] 85 0.003% 100.025% ( 1300, 1900 ] 37 0.001% 100.026% ( 1900, 2900 ] 23 0.001% 100.026% ( 2900, 4400 ] 34 0.001% 100.027% ( 6600, 9900 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 1000354 Average: 3.0264 StdDev: 26.14 Min: 0 Median: 1.6243 Max: 8487 Percentiles: P50: 1.62 P75: 2.10 P99: 8.27 P99.9: 119.95 P99.99: 308.96 ------------------------------------------------------ [ 0, 1 ] 109399 10.936% 10.936% ## ( 1, 2 ] 625948 62.573% 73.509% ############# ( 2, 3 ] 153331 15.328% 88.836% ### ( 3, 4 ] 50553 5.054% 93.890% # ( 4, 6 ] 42821 4.281% 98.170% # ( 6, 10 ] 14626 1.462% 99.633% ( 10, 15 ] 1623 0.162% 99.795% ( 15, 22 ] 200 0.020% 99.815% ( 22, 34 ] 18 0.002% 99.817% ( 34, 51 ] 5 0.000% 99.817% ( 51, 76 ] 42 0.004% 99.821% ( 76, 110 ] 676 0.068% 99.889% ( 110, 170 ] 673 0.067% 99.956% ( 170, 250 ] 241 0.024% 99.980% ( 250, 380 ] 216 0.022% 100.002% ( 380, 580 ] 205 0.020% 100.022% ( 580, 870 ] 114 0.011% 100.034% ( 870, 1300 ] 63 0.006% 100.040% ( 1300, 1900 ] 26 0.003% 100.043% ( 1900, 2900 ] 12 0.001% 100.044% ( 2900, 4400 ] 8 0.001% 100.045% ( 4400, 6600 ] 2 0.000% 100.045% ( 6600, 9900 ] 3 0.000% 100.045% ** Level 2 read latency histogram (micros): Count: 47991 Average: 4.1548 StdDev: 38.59 Min: 1 Median: 1.6929 Max: 4172 Percentiles: P50: 1.69 P75: 2.37 P99: 9.04 P99.9: 526.73 P99.99: 1540.18 ------------------------------------------------------ [ 0, 1 ] 3361 7.003% 7.003% # ( 1, 2 ] 29778 62.049% 69.053% ############ ( 2, 3 ] 7773 16.197% 85.249% ### ( 3, 4 ] 3198 6.664% 91.913% # ( 4, 6 ] 2861 5.962% 97.875% # ( 6, 10 ] 710 1.479% 99.354% ( 10, 15 ] 120 0.250% 99.604% ( 15, 22 ] 13 0.027% 99.631% ( 22, 34 ] 3 0.006% 99.637% ( 51, 76 ] 1 0.002% 99.640% ( 76, 110 ] 4 0.008% 99.648% ( 110, 170 ] 29 0.060% 99.708% ( 170, 250 ] 27 0.056% 99.765% ( 250, 380 ] 43 0.090% 99.854% ( 380, 580 ] 30 0.063% 99.917% ( 580, 870 ] 27 0.056% 99.973% ( 870, 1300 ] 7 0.015% 99.987% ( 1300, 1900 ] 3 0.006% 99.994% ( 1900, 2900 ] 2 0.004% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 345345 Average: 4.1853 StdDev: 62.67 Min: 1 Median: 1.9683 Max: 7627 Percentiles: P50: 1.97 P75: 2.90 P99: 8.33 P99.9: 13.75 P99.99: 16.83 ------------------------------------------------------ [ 0, 1 ] 6567 1.902% 1.902% ( 1, 2 ] 171551 49.675% 51.577% ########## ( 2, 3 ] 89989 26.058% 77.635% ##### ( 3, 4 ] 34859 10.094% 87.729% ## ( 4, 6 ] 35768 10.357% 98.086% ## ( 6, 10 ] 5426 1.571% 99.657% ( 10, 15 ] 1121 0.325% 99.981% ( 15, 22 ] 113 0.033% 100.014% ( 22, 34 ] 7 0.002% 100.016% ( 34, 51 ] 2 0.001% 100.017% ( 51, 76 ] 3 0.001% 100.018% ( 76, 110 ] 26 0.008% 100.025% ( 110, 170 ] 77 0.022% 100.047% ( 170, 250 ] 54 0.016% 100.063% ( 250, 380 ] 68 0.020% 100.083% ( 380, 580 ] 59 0.017% 100.100% ( 580, 870 ] 49 0.014% 100.114% ( 870, 1300 ] 20 0.006% 100.120% ( 1300, 1900 ] 10 0.003% 100.123% ( 1900, 2900 ] 13 0.004% 100.127% ( 2900, 4400 ] 46 0.013% 100.140% ( 4400, 6600 ] 13 0.004% 100.144% ( 6600, 9900 ] 4 0.001% 100.145% ** Level 4 read latency histogram (micros): Count: 8289 Average: 104.5186 StdDev: 414.15 Min: 0 Median: 2.2914 Max: 9166 Percentiles: P50: 2.29 P75: 3.80 P99: 1816.66 P99.9: 4387.25 P99.99: 6788.21 ------------------------------------------------------ [ 0, 1 ] 168 2.027% 2.027% ( 1, 2 ] 3443 41.537% 43.564% ######## ( 2, 3 ] 1831 22.090% 65.653% #### ( 3, 4 ] 974 11.751% 77.404% ## ( 4, 6 ] 547 6.599% 84.003% # ( 6, 10 ] 195 2.353% 86.355% ( 10, 15 ] 44 0.531% 86.886% ( 15, 22 ] 7 0.084% 86.971% ( 76, 110 ] 24 0.290% 87.260% ( 110, 170 ] 94 1.134% 88.394% ( 170, 250 ] 103 1.243% 89.637% ( 250, 380 ] 143 1.725% 91.362% ( 380, 580 ] 208 2.509% 93.871% # ( 580, 870 ] 233 2.811% 96.682% # ( 870, 1300 ] 137 1.653% 98.335% ( 1300, 1900 ] 64 0.772% 99.107% ( 1900, 2900 ] 32 0.386% 99.493% ( 2900, 4400 ] 34 0.410% 99.903% ( 4400, 6600 ] 7 0.084% 99.988% ( 6600, 9900 ] 3 0.036% 100.024% ** Level 5 read latency histogram (micros): Count: 100 Average: 835.9100 StdDev: 1025.48 Min: 76 Median: 356.3636 Max: 3606 Percentiles: P50: 356.36 P75: 1138.75 P99: 3606.00 P99.9: 3606.00 P99.99: 3606.00 ------------------------------------------------------ ( 51, 76 ] 1 1.000% 1.000% ( 76, 110 ] 17 17.000% 18.000% ### ( 110, 170 ] 14 14.000% 32.000% ### ( 170, 250 ] 9 9.000% 41.000% ## ( 250, 380 ] 11 11.000% 52.000% ## ( 380, 580 ] 9 9.000% 61.000% ## ( 580, 870 ] 9 9.000% 70.000% ## ( 870, 1300 ] 8 8.000% 78.000% ## ( 1300, 1900 ] 7 7.000% 85.000% # ( 1900, 2900 ] 5 5.000% 90.000% # ( 2900, 4400 ] 10 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 36.6 total, 10.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 215.31 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:14.804 H:M:S, 40.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 98.63 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:7.001 H:M:S, 70.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-03:24:17 ... thread 0: (1000000,9000000) ops and (135912.2,205951.3) ops/second in (7.357689,43.699657) 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 16/12 3.31 GB 44.1 7.8 0.0 7.8 16.3 8.5 0.0 1.9 141.5 295.1 56.52 52.06 148 0.382 8121K 15K 0.0 0.0 L1 19/19 2.17 GB 0.0 7.6 5.0 2.6 7.5 5.0 0.1 1.5 225.4 222.9 34.53 32.56 5 6.906 7902K 83K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 3.0 2.0 232.3 232.2 0.54 0.52 1 0.543 127K 41 0.0 0.0 L3 19/0 922.88 MB 0.9 4.3 2.1 2.2 4.3 2.1 1.0 2.1 187.9 186.7 23.67 19.89 18 1.315 4517K 27K 0.0 0.0 L4 175/0 9.71 GB 1.0 2.3 2.1 0.2 2.3 2.1 0.8 1.1 152.6 152.2 15.49 11.04 32 0.484 2372K 3517 0.0 0.0 L5 1072/0 88.40 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/31 104.50 GB 0.0 22.2 9.3 12.9 30.5 17.7 7.5 3.6 173.8 239.2 130.75 116.07 204 0.641 23M 129K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.2 9.3 12.9 30.5 17.7 7.4 3.6 173.8 239.2 130.75 116.07 204 0.641 23M 129K 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 22.2 9.3 12.9 22.1 9.2 0.0 0.0 216.3 215.0 105.04 93.73 80 1.313 23M 129K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 338.1 25.71 22.34 124 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): 43.9 total, 43.7 interval Flush(GB): cumulative 8.490, interval 8.490 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: 30.55 GB write, 712.09 MB/s write, 22.19 GB read, 517.19 MB/s read, 130.8 seconds Interval compaction: 30.55 GB write, 715.75 MB/s write, 22.19 GB read, 519.85 MB/s read, 130.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 49, pending-compaction-bytes-delays: 25, pending-compaction-bytes-stops: 0, total-delays: 47, total-stops: 49, interval: 96 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3715688 Average: 2.6713 StdDev: 19.79 Min: 0 Median: 1.5377 Max: 6798 Percentiles: P50: 1.54 P75: 1.92 P99: 6.46 P99.9: 110.80 P99.99: 312.01 ------------------------------------------------------ [ 0, 1 ] 567815 15.282% 15.282% ### ( 1, 2 ] 2399029 64.565% 79.846% ############# ( 2, 3 ] 451118 12.141% 91.987% ## ( 3, 4 ] 147695 3.975% 95.962% # ( 4, 6 ] 109430 2.945% 98.907% # ( 6, 10 ] 29745 0.801% 99.708% ( 10, 15 ] 4181 0.113% 99.820% ( 15, 22 ] 492 0.013% 99.834% ( 22, 34 ] 41 0.001% 99.835% ( 34, 51 ] 17 0.000% 99.835% ( 51, 76 ] 87 0.002% 99.837% ( 76, 110 ] 2291 0.062% 99.899% ( 110, 170 ] 2435 0.066% 99.965% ( 170, 250 ] 681 0.018% 99.983% ( 250, 380 ] 546 0.015% 99.998% ( 380, 580 ] 503 0.014% 100.011% ( 580, 870 ] 319 0.009% 100.020% ( 870, 1300 ] 127 0.003% 100.023% ( 1300, 1900 ] 46 0.001% 100.024% ( 1900, 2900 ] 32 0.001% 100.025% ( 2900, 4400 ] 40 0.001% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1403518 Average: 3.3688 StdDev: 29.02 Min: 0 Median: 1.6862 Max: 8487 Percentiles: P50: 1.69 P75: 2.37 P99: 8.70 P99.9: 118.07 P99.99: 296.64 ------------------------------------------------------ [ 0, 1 ] 129519 9.228% 9.228% ## ( 1, 2 ] 833871 59.413% 68.641% ############ ( 2, 3 ] 238074 16.963% 85.604% ### ( 3, 4 ] 87979 6.268% 91.872% # ( 4, 6 ] 82715 5.893% 97.766% # ( 6, 10 ] 25643 1.827% 99.593% ( 10, 15 ] 2908 0.207% 99.800% ( 15, 22 ] 429 0.031% 99.830% ( 22, 34 ] 28 0.002% 99.832% ( 34, 51 ] 6 0.000% 99.833% ( 51, 76 ] 68 0.005% 99.838% ( 76, 110 ] 753 0.054% 99.891% ( 110, 170 ] 903 0.064% 99.956% ( 170, 250 ] 355 0.025% 99.981% ( 250, 380 ] 353 0.025% 100.006% ( 380, 580 ] 412 0.029% 100.035% ( 580, 870 ] 275 0.020% 100.055% ( 870, 1300 ] 180 0.013% 100.068% ( 1300, 1900 ] 61 0.004% 100.072% ( 1900, 2900 ] 29 0.002% 100.074% ( 2900, 4400 ] 12 0.001% 100.075% ( 4400, 6600 ] 2 0.000% 100.075% ( 6600, 9900 ] 3 0.000% 100.076% ** Level 2 read latency histogram (micros): Count: 47991 Average: 4.1548 StdDev: 38.59 Min: 1 Median: 1.6929 Max: 4172 Percentiles: P50: 1.69 P75: 2.37 P99: 9.04 P99.9: 526.73 P99.99: 1540.18 ------------------------------------------------------ [ 0, 1 ] 3361 7.003% 7.003% # ( 1, 2 ] 29778 62.049% 69.053% ############ ( 2, 3 ] 7773 16.197% 85.249% ### ( 3, 4 ] 3198 6.664% 91.913% # ( 4, 6 ] 2861 5.962% 97.875% # ( 6, 10 ] 710 1.479% 99.354% ( 10, 15 ] 120 0.250% 99.604% ( 15, 22 ] 13 0.027% 99.631% ( 22, 34 ] 3 0.006% 99.637% ( 51, 76 ] 1 0.002% 99.640% ( 76, 110 ] 4 0.008% 99.648% ( 110, 170 ] 29 0.060% 99.708% ( 170, 250 ] 27 0.056% 99.765% ( 250, 380 ] 43 0.090% 99.854% ( 380, 580 ] 30 0.063% 99.917% ( 580, 870 ] 27 0.056% 99.973% ( 870, 1300 ] 7 0.015% 99.987% ( 1300, 1900 ] 3 0.006% 99.994% ( 1900, 2900 ] 2 0.004% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 885794 Average: 4.4178 StdDev: 54.10 Min: 1 Median: 1.9703 Max: 7692 Percentiles: P50: 1.97 P75: 2.95 P99: 8.56 P99.9: 13.93 P99.99: 20.55 ------------------------------------------------------ [ 0, 1 ] 15104 1.705% 1.705% ( 1, 2 ] 440894 49.774% 51.479% ########## ( 2, 3 ] 218883 24.710% 76.189% ##### ( 3, 4 ] 94071 10.620% 86.809% ## ( 4, 6 ] 97360 10.991% 97.801% ## ( 6, 10 ] 16584 1.872% 99.673% ( 10, 15 ] 2559 0.289% 99.962% ( 15, 22 ] 316 0.036% 99.997% ( 22, 34 ] 17 0.002% 99.999% ( 34, 51 ] 3 0.000% 100.000% ( 51, 76 ] 32 0.004% 100.003% ( 76, 110 ] 59 0.007% 100.010% ( 110, 170 ] 136 0.015% 100.025% ( 170, 250 ] 158 0.018% 100.043% ( 250, 380 ] 248 0.028% 100.071% ( 380, 580 ] 324 0.037% 100.108% ( 580, 870 ] 328 0.037% 100.145% ( 870, 1300 ] 190 0.021% 100.166% ( 1300, 1900 ] 84 0.009% 100.176% ( 1900, 2900 ] 33 0.004% 100.179% ( 2900, 4400 ] 67 0.008% 100.187% ( 4400, 6600 ] 19 0.002% 100.189% ( 6600, 9900 ] 6 0.001% 100.190% ** Level 4 read latency histogram (micros): Count: 53465 Average: 32.5807 StdDev: 207.16 Min: 0 Median: 2.0017 Max: 9166 Percentiles: P50: 2.00 P75: 3.19 P99: 816.91 P99.9: 2973.13 P99.99: 4361.16 ------------------------------------------------------ [ 0, 1 ] 1063 1.988% 1.988% ( 1, 2 ] 25649 47.973% 49.962% ########## ( 2, 3 ] 12376 23.148% 73.110% ##### ( 3, 4 ] 5446 10.186% 83.296% ## ( 4, 6 ] 4741 8.867% 92.163% ## ( 6, 10 ] 1337 2.501% 94.664% # ( 10, 15 ] 161 0.301% 94.965% ( 15, 22 ] 26 0.049% 95.014% ( 22, 34 ] 6 0.011% 95.025% ( 51, 76 ] 5 0.009% 95.034% ( 76, 110 ] 152 0.284% 95.318% ( 110, 170 ] 413 0.772% 96.091% ( 170, 250 ] 333 0.623% 96.714% ( 250, 380 ] 376 0.703% 97.417% ( 380, 580 ] 482 0.902% 98.319% ( 580, 870 ] 446 0.834% 99.153% ( 870, 1300 ] 254 0.475% 99.628% ( 1300, 1900 ] 99 0.185% 99.813% ( 1900, 2900 ] 44 0.082% 99.895% ( 2900, 4400 ] 52 0.097% 99.993% ( 4400, 6600 ] 12 0.022% 100.015% ( 6600, 9900 ] 3 0.006% 100.021% ** Level 5 read latency histogram (micros): Count: 160 Average: 857.9125 StdDev: 1071.87 Min: 76 Median: 329.1304 Max: 4513 Percentiles: P50: 329.13 P75: 1192.50 P99: 4343.75 P99.9: 4513.00 P99.99: 4513.00 ------------------------------------------------------ ( 51, 76 ] 1 0.625% 0.625% ( 76, 110 ] 22 13.750% 14.375% ### ( 110, 170 ] 27 16.875% 31.250% ### ( 170, 250 ] 16 10.000% 41.250% ## ( 250, 380 ] 23 14.375% 55.625% ### ( 380, 580 ] 12 7.500% 63.125% ## ( 580, 870 ] 13 8.125% 71.250% ## ( 870, 1300 ] 8 5.000% 76.250% # ( 1300, 1900 ] 11 6.875% 83.125% # ( 1900, 2900 ] 10 6.250% 89.375% # ( 2900, 4400 ] 16 10.000% 99.375% ## ( 4400, 6600 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 43.9 total, 7.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 201.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:19.406 H:M:S, 44.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 133.76 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.601 H:M:S, 62.5 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 : 6.390 micros/op 156488 ops/sec 60.183 seconds 9417999 operations; 151.6 MB/s Microseconds per write: Count: 9417999 Average: 6.3902 StdDev: 295.31 Min: 0 Median: 1.7381 Max: 329508 Percentiles: P50: 1.74 P75: 2.75 P99: 8.84 P99.9: 1239.33 P99.99: 2780.43 ------------------------------------------------------ [ 0, 1 ] 1249343 13.265% 13.265% ### ( 1, 2 ] 4687316 49.770% 63.035% ########## ( 2, 3 ] 1504597 15.976% 79.011% ### ( 3, 4 ] 1314045 13.952% 92.963% ### ( 4, 6 ] 505888 5.372% 98.335% # ( 6, 10 ] 88060 0.935% 99.270% ( 10, 15 ] 27780 0.295% 99.565% ( 15, 22 ] 7447 0.079% 99.644% ( 22, 34 ] 1765 0.019% 99.663% ( 34, 51 ] 211 0.002% 99.665% ( 51, 76 ] 27 0.000% 99.665% ( 76, 110 ] 6372 0.068% 99.733% ( 110, 170 ] 2769 0.029% 99.762% ( 170, 250 ] 286 0.003% 99.765% ( 250, 380 ] 111 0.001% 99.767% ( 380, 580 ] 15 0.000% 99.767% ( 580, 870 ] 15 0.000% 99.767% ( 870, 1300 ] 14593 0.155% 99.922% ( 1300, 1900 ] 64 0.001% 99.923% ( 1900, 2900 ] 7216 0.077% 99.999% ( 2900, 4400 ] 39 0.000% 100.000% ( 4400, 6600 ] 15 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 12 0.000% 100.000% ( 250000, 380000 ] 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 : 223581 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 : 9417999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9719374968 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 : 486 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34526166 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 : 31021935140 rocksdb.compact.write.bytes COUNT : 30815959624 rocksdb.flush.write.bytes COUNT : 9710431080 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 : 41 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 : 214 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 : 9632095232 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3708928 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 : 31105427159 rocksdb.non.last.level.read.count COUNT : 7520788 rocksdb.block.checksum.compute.count COUNT : 7519857 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.378259 P95 : 3.880004 P99 : 7.127426 P100 : 329506.000000 COUNT : 9417999 SUM : 55797723 rocksdb.compaction.times.micros P50 : 977692.307692 P95 : 4886666.666667 P99 : 15280000.000000 P100 : 16570249.000000 COUNT : 84 SUM : 112932398 rocksdb.compaction.times.cpu_micros P50 : 921818.181818 P95 : 4886666.666667 P99 : 15232151.000000 P100 : 15232151.000000 COUNT : 84 SUM : 101465690 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 : 674.054054 P95 : 1237.454545 P99 : 5896.000000 P100 : 10041.000000 COUNT : 132 SUM : 103312 rocksdb.compaction.outfile.sync.micros P50 : 973.518519 P95 : 43766.666667 P99 : 89816.666667 P100 : 90547.000000 COUNT : 346 SUM : 2265160 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 : 100.067416 P95 : 704.285714 P99 : 1660.000000 P100 : 2563.000000 COUNT : 240 SUM : 44857 rocksdb.table.open.io.micros P50 : 1244.516129 P95 : 5897.692308 P99 : 9663.500000 P100 : 10897.000000 COUNT : 486 SUM : 861904 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.625999 P95 : 7.434489 P99 : 9.990316 P100 : 12134.000000 COUNT : 7518445 SUM : 40204746 rocksdb.read.block.get.micros P50 : 387.272727 P95 : 3104.255319 P99 : 4345.106383 P100 : 6054.000000 COUNT : 972 SUM : 721020 rocksdb.write.raw.block.micros P50 : 0.512753 P95 : 0.974231 P99 : 2.945607 P100 : 14498.000000 COUNT : 9815221 SUM : 18200094 rocksdb.numfiles.in.singlecompaction P50 : 3.094340 P95 : 5.600000 P99 : 21.580000 P100 : 27.000000 COUNT : 112 SUM : 412 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.558010 P95 : 1204.049623 P99 : 2614.737791 P100 : 329307.000000 COUNT : 211517 SUM : 34541080 rocksdb.sst.read.micros P50 : 1.592455 P95 : 4.438265 P99 : 8.178256 P100 : 9166.000000 COUNT : 7520903 SUM : 24912107 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 : 9417999 SUM : 9719374968 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 : 212352.941176 P95 : 348800.000000 P99 : 486400.000000 P100 : 547623.000000 COUNT : 132 SUM : 27341671 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 : 322 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