[2024-12-07 07:29:21.621542] Starting SPDK v25.01-pre git sha1 a2f5e1c2d / DPDK 23.11.0 initialization... [2024-12-07 07:29:21.621814] [ 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_pid186737 ] Set seed to 1733552961614901 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-07 07:29:21.740700] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-07 07:29:21.763844] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-07 07:29:21.763889] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 186737' to capture a snapshot of events at runtime. [2024-12-07 07:29:21.763899] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-07 07:29:21.763910] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-07 07:29:21.763918] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid186737 for offline analysis/debug. [2024-12-07 07:29:21.764482] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 7 07:29:26 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/07-07:29:29 ... thread 0: (1000000,1000000) ops and (330200.6,330200.6) ops/second in (3.028462,3.028462) 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 6/4 440.96 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 343.9 2.56 2.31 12 0.214 0 0 0.0 0.0 L1 3/0 249.85 MB 25.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.3 248.0 1.01 0.98 1 1.015 255K 242 0.0 0.0 L2 3/2 190.75 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 9/0 741.42 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 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 L5 1044/0 85.88 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 1181/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 1.0 1.5 101.7 303.6 4.37 4.04 15 0.291 451K 325 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.9 1.5 101.7 303.6 4.37 4.04 15 0.291 451K 325 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.4 0.4 0.1 0.4 0.4 0.0 0.0 246.4 246.2 1.80 1.73 3 0.601 451K 325 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 343.9 2.56 2.31 12 0.214 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.3 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.29 GB write, 406.19 MB/s write, 0.43 GB read, 136.10 MB/s read, 4.4 seconds Interval compaction: 1.29 GB write, 437.53 MB/s write, 0.43 GB read, 146.61 MB/s read, 4.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 157159 Average: 1.9729 StdDev: 17.66 Min: 1 Median: 1.3067 Max: 4623 Percentiles: P50: 1.31 P75: 1.73 P99: 5.15 P99.9: 9.79 P99.99: 17.50 ------------------------------------------------------ [ 0, 1 ] 50294 32.002% 32.002% ###### ( 1, 2 ] 92213 58.675% 90.677% ############ ( 2, 3 ] 8345 5.310% 95.987% # ( 3, 4 ] 3624 2.306% 98.293% ( 4, 6 ] 1935 1.231% 99.524% ( 6, 10 ] 623 0.396% 99.920% ( 10, 15 ] 105 0.067% 99.987% ( 15, 22 ] 12 0.008% 99.995% ( 22, 34 ] 2 0.001% 99.996% ( 34, 51 ] 1 0.001% 99.997% ( 51, 76 ] 1 0.001% 99.997% ( 110, 170 ] 7 0.004% 100.002% ( 170, 250 ] 3 0.002% 100.004% ( 250, 380 ] 6 0.004% 100.008% ( 380, 580 ] 2 0.001% 100.009% ( 580, 870 ] 1 0.001% 100.010% ( 870, 1300 ] 1 0.001% 100.010% ( 1900, 2900 ] 2 0.001% 100.011% ( 2900, 4400 ] 1 0.001% 100.012% ( 4400, 6600 ] 1 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 499 Average: 8.9559 StdDev: 59.48 Min: 1 Median: 2.4914 Max: 1034 Percentiles: P50: 2.49 P75: 3.45 P99: 170.80 P99.9: 1034.00 P99.99: 1034.00 ------------------------------------------------------ [ 0, 1 ] 8 1.603% 1.603% ( 1, 2 ] 156 31.263% 32.866% ###### ( 2, 3 ] 174 34.870% 67.735% ####### ( 3, 4 ] 81 16.232% 83.968% ### ( 4, 6 ] 52 10.421% 94.389% ## ( 6, 10 ] 17 3.407% 97.796% # ( 10, 15 ] 4 0.802% 98.597% ( 51, 76 ] 1 0.200% 98.798% ( 110, 170 ] 1 0.200% 98.998% ( 170, 250 ] 1 0.200% 99.198% ( 250, 380 ] 1 0.200% 99.399% ( 380, 580 ] 2 0.401% 99.800% ( 870, 1300 ] 1 0.200% 100.000% ** Level 2 read latency histogram (micros): Count: 40289 Average: 2.6042 StdDev: 31.27 Min: 1 Median: 1.5390 Max: 4621 Percentiles: P50: 1.54 P75: 1.90 P99: 6.13 P99.9: 13.16 P99.99: 865.79 ------------------------------------------------------ [ 0, 1 ] 5157 12.800% 12.800% ### ( 1, 2 ] 27806 69.016% 81.816% ############## ( 2, 3 ] 4053 10.060% 91.876% ## ( 3, 4 ] 1789 4.440% 96.317% # ( 4, 6 ] 1071 2.658% 98.975% # ( 6, 10 ] 337 0.836% 99.811% ( 10, 15 ] 58 0.144% 99.955% ( 15, 22 ] 5 0.012% 99.968% ( 34, 51 ] 1 0.002% 99.970% ( 51, 76 ] 2 0.005% 99.975% ( 76, 110 ] 1 0.002% 99.978% ( 110, 170 ] 1 0.002% 99.980% ( 250, 380 ] 2 0.005% 99.985% ( 380, 580 ] 1 0.002% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 3 0.007% 100.000% ( 1900, 2900 ] 2 0.005% 100.005% ( 4400, 6600 ] 1 0.002% 100.007% ** Level 3 read latency histogram (micros): Count: 54 Average: 1761.7778 StdDev: 1477.95 Min: 65 Median: 1138.7500 Max: 5241 Percentiles: P50: 1138.75 P75: 2685.71 P99: 5241.00 P99.9: 5241.00 P99.99: 5241.00 ------------------------------------------------------ ( 51, 76 ] 1 1.852% 1.852% ( 110, 170 ] 2 3.704% 5.556% # ( 170, 250 ] 3 5.556% 11.111% # ( 250, 380 ] 5 9.259% 20.370% ## ( 380, 580 ] 4 7.407% 27.778% # ( 580, 870 ] 7 12.963% 40.741% ### ( 870, 1300 ] 8 14.815% 55.556% ### ( 1300, 1900 ] 5 9.259% 64.815% ## ( 1900, 2900 ] 7 12.963% 77.778% ### ( 2900, 4400 ] 9 16.667% 94.444% ### ( 4400, 6600 ] 4 7.407% 101.852% # ** Level 4 read latency histogram (micros): Count: 15 Average: 1570.9333 StdDev: 1561.11 Min: 222 Median: 652.5000 Max: 4790 Percentiles: P50: 652.50 P75: 2650.00 P99: 4790.00 P99.9: 4790.00 P99.99: 4790.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 2 13.333% 26.667% ### ( 380, 580 ] 3 20.000% 46.667% #### ( 580, 870 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 498.3500 StdDev: 720.18 Min: 82 Median: 150.0000 Max: 2547 Percentiles: P50: 150.00 P75: 580.00 P99: 2547.00 P99.9: 2547.00 P99.99: 2547.00 ------------------------------------------------------ ( 76, 110 ] 6 30.000% 30.000% ###### ( 110, 170 ] 6 30.000% 60.000% ###### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 2 10.000% 85.000% ## ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.3 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 301.50 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.432 H:M:S, 13.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.69 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.432 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-07:29:31 ... thread 0: (1000000,2000000) ops and (357564.7,343338.3) ops/second in (2.796697,5.825159) 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 14/12 1.35 GB 31.5 0.5 0.0 0.5 2.3 1.8 0.0 1.3 71.4 330.1 7.06 6.49 28 0.252 511K 502 0.0 0.0 L1 3/3 249.85 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 248.3 248.0 1.01 0.98 1 1.015 255K 242 0.0 0.0 L2 1/0 3.29 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 18/0 928.89 MB 0.9 0.2 0.2 0.0 0.2 0.2 0.1 1.0 216.1 216.1 0.87 0.79 1 0.867 190K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 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 L5 1044/0 85.88 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 1196/15 97.92 GB 0.0 1.1 0.6 0.6 2.9 2.3 1.0 1.6 116.7 304.4 9.73 9.01 32 0.304 1153K 827 0.0 0.0 Int 0/0 0.00 KB 0.0 1.1 0.6 0.6 2.9 2.3 0.9 1.6 116.7 304.4 9.73 9.01 32 0.304 1153K 827 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.1 0.6 0.6 1.1 0.6 0.0 0.0 250.3 250.1 4.54 4.36 6 0.756 1153K 827 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 351.8 5.19 4.65 26 0.200 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.8 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: 2.89 GB write, 488.69 MB/s write, 1.11 GB read, 187.39 MB/s read, 9.7 seconds Interval compaction: 2.89 GB write, 508.30 MB/s write, 1.11 GB read, 194.91 MB/s read, 9.7 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: 421492 Average: 2.0679 StdDev: 13.19 Min: 0 Median: 1.4126 Max: 4623 Percentiles: P50: 1.41 P75: 1.81 P99: 5.41 P99.9: 9.98 P99.99: 14.89 ------------------------------------------------------ [ 0, 1 ] 100489 23.841% 23.841% ##### ( 1, 2 ] 267210 63.396% 87.237% ############# ( 2, 3 ] 33279 7.896% 95.133% ## ( 3, 4 ] 11701 2.776% 97.909% # ( 4, 6 ] 6533 1.550% 99.459% ( 6, 10 ] 1870 0.444% 99.903% ( 10, 15 ] 378 0.090% 99.992% ( 15, 22 ] 37 0.009% 100.001% ( 22, 34 ] 10 0.002% 100.004% ( 34, 51 ] 3 0.001% 100.004% ( 51, 76 ] 1 0.000% 100.005% ( 110, 170 ] 12 0.003% 100.007% ( 170, 250 ] 12 0.003% 100.010% ( 250, 380 ] 12 0.003% 100.013% ( 380, 580 ] 6 0.001% 100.014% ( 580, 870 ] 4 0.001% 100.015% ( 870, 1300 ] 4 0.001% 100.016% ( 1900, 2900 ] 3 0.001% 100.017% ( 2900, 4400 ] 2 0.000% 100.018% ( 4400, 6600 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 50823 Average: 2.0810 StdDev: 6.00 Min: 1 Median: 1.4551 Max: 1034 Percentiles: P50: 1.46 P75: 1.83 P99: 5.21 P99.9: 9.91 P99.99: 165.06 ------------------------------------------------------ [ 0, 1 ] 10124 19.920% 19.920% #### ( 1, 2 ] 33589 66.090% 86.010% ############# ( 2, 3 ] 4723 9.293% 95.303% ## ( 3, 4 ] 1424 2.802% 98.105% # ( 4, 6 ] 750 1.476% 99.581% ( 6, 10 ] 166 0.327% 99.908% ( 10, 15 ] 38 0.075% 99.982% ( 51, 76 ] 3 0.006% 99.988% ( 110, 170 ] 1 0.002% 99.990% ( 170, 250 ] 1 0.002% 99.992% ( 250, 380 ] 1 0.002% 99.994% ( 380, 580 ] 2 0.004% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47974 Average: 2.5432 StdDev: 28.66 Min: 1 Median: 1.5460 Max: 4621 Percentiles: P50: 1.55 P75: 1.91 P99: 5.96 P99.9: 12.86 P99.99: 754.38 ------------------------------------------------------ [ 0, 1 ] 5957 12.417% 12.417% ## ( 1, 2 ] 33020 68.829% 81.246% ############## ( 2, 3 ] 5282 11.010% 92.256% ## ( 3, 4 ] 2023 4.217% 96.473% # ( 4, 6 ] 1236 2.576% 99.049% # ( 6, 10 ] 372 0.775% 99.825% ( 10, 15 ] 63 0.131% 99.956% ( 15, 22 ] 7 0.015% 99.971% ( 34, 51 ] 1 0.002% 99.973% ( 51, 76 ] 2 0.004% 99.977% ( 76, 110 ] 1 0.002% 99.979% ( 110, 170 ] 1 0.002% 99.981% ( 250, 380 ] 2 0.004% 99.985% ( 380, 580 ] 1 0.002% 99.987% ( 580, 870 ] 2 0.004% 99.992% ( 870, 1300 ] 3 0.006% 99.998% ( 1900, 2900 ] 2 0.004% 100.002% ( 4400, 6600 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 99 Average: 981.8687 StdDev: 1391.62 Min: 0 Median: 277.8571 Max: 5241 Percentiles: P50: 277.86 P75: 1264.17 P99: 5241.00 P99.9: 5241.00 P99.99: 5241.00 ------------------------------------------------------ [ 0, 1 ] 21 21.212% 21.212% #### ( 1, 2 ] 13 13.131% 34.343% ### ( 2, 3 ] 1 1.010% 35.354% ( 3, 4 ] 4 4.040% 39.394% # ( 6, 10 ] 2 2.020% 41.414% ( 51, 76 ] 1 1.010% 42.424% ( 110, 170 ] 3 3.030% 45.455% # ( 170, 250 ] 3 3.030% 48.485% # ( 250, 380 ] 7 7.071% 55.556% # ( 380, 580 ] 4 4.040% 59.596% # ( 580, 870 ] 7 7.071% 66.667% # ( 870, 1300 ] 9 9.091% 75.758% ## ( 1300, 1900 ] 5 5.051% 80.808% # ( 1900, 2900 ] 7 7.071% 87.879% # ( 2900, 4400 ] 9 9.091% 96.970% ## ( 4400, 6600 ] 4 4.040% 101.010% # ** Level 4 read latency histogram (micros): Count: 15 Average: 1570.9333 StdDev: 1561.11 Min: 222 Median: 652.5000 Max: 4790 Percentiles: P50: 652.50 P75: 2650.00 P99: 4790.00 P99.9: 4790.00 P99.99: 4790.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 2 13.333% 26.667% ### ( 380, 580 ] 3 20.000% 46.667% #### ( 580, 870 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 498.3500 StdDev: 720.18 Min: 82 Median: 150.0000 Max: 2547 Percentiles: P50: 150.00 P75: 580.00 P99: 2547.00 P99.9: 2547.00 P99.99: 2547.00 ------------------------------------------------------ ( 76, 110 ] 6 30.000% 30.000% ###### ( 110, 170 ] 6 30.000% 60.000% ###### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 2 10.000% 85.000% ## ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.77 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.624 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.92 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.192 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/07-07:29:34 ... thread 0: (1000000,3000000) ops and (323478.0,336452.7) ops/second in (3.091400,8.916559) 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 12/4 1.84 GB 157.3 1.6 0.0 1.6 4.4 2.8 0.0 1.6 114.7 313.1 14.28 13.29 46 0.310 1663K 1762 0.0 0.0 L1 3/0 236.17 MB 23.6 1.0 0.7 0.2 1.0 0.7 0.2 1.3 239.1 238.5 4.21 4.10 2 2.103 1021K 2433 0.0 0.0 L2 5/4 518.36 MB 1.3 0.2 0.1 0.1 0.2 0.1 0.6 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 18/10 928.89 MB 0.1 0.2 0.2 0.0 0.2 0.2 0.1 1.0 216.1 216.1 0.87 0.79 1 0.867 190K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 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 L5 1044/0 85.88 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 1198/18 98.90 GB 0.0 3.0 1.0 1.9 5.7 3.8 1.5 2.1 150.1 290.6 20.14 18.94 51 0.395 3069K 4278 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 1.0 1.9 5.7 3.8 1.4 2.1 150.1 290.6 20.14 18.94 51 0.395 3069K 4278 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.0 1.0 1.9 2.9 1.0 0.0 0.0 249.9 249.5 12.10 11.76 11 1.100 3069K 4278 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 352.5 8.04 7.18 40 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): 9.2 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.72 GB write, 639.59 MB/s write, 2.95 GB read, 330.33 MB/s read, 20.1 seconds Interval compaction: 5.72 GB write, 656.36 MB/s write, 2.95 GB read, 339.00 MB/s read, 20.1 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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 693279 Average: 2.1839 StdDev: 12.47 Min: 0 Median: 1.4815 Max: 4623 Percentiles: P50: 1.48 P75: 1.87 P99: 5.64 P99.9: 10.25 P99.99: 14.69 ------------------------------------------------------ [ 0, 1 ] 130287 18.793% 18.793% #### ( 1, 2 ] 449326 64.812% 83.605% ############# ( 2, 3 ] 68228 9.841% 93.446% ## ( 3, 4 ] 25745 3.714% 97.159% # ( 4, 6 ] 15541 2.242% 99.401% ( 6, 10 ] 3424 0.494% 99.895% ( 10, 15 ] 702 0.101% 99.996% ( 15, 22 ] 58 0.008% 100.005% ( 22, 34 ] 14 0.002% 100.007% ( 34, 51 ] 3 0.000% 100.007% ( 51, 76 ] 2 0.000% 100.007% ( 110, 170 ] 13 0.002% 100.009% ( 170, 250 ] 22 0.003% 100.012% ( 250, 380 ] 18 0.003% 100.015% ( 380, 580 ] 10 0.001% 100.016% ( 580, 870 ] 10 0.001% 100.018% ( 870, 1300 ] 9 0.001% 100.019% ( 1300, 1900 ] 2 0.000% 100.019% ( 1900, 2900 ] 4 0.001% 100.020% ( 2900, 4400 ] 3 0.000% 100.020% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 159321 Average: 2.3926 StdDev: 7.42 Min: 1 Median: 1.6166 Max: 1141 Percentiles: P50: 1.62 P75: 2.01 P99: 5.87 P99.9: 12.31 P99.99: 251.47 ------------------------------------------------------ [ 0, 1 ] 16092 10.100% 10.100% ## ( 1, 2 ] 103098 64.711% 74.811% ############# ( 2, 3 ] 25243 15.844% 90.655% ### ( 3, 4 ] 7924 4.974% 95.629% # ( 4, 6 ] 5742 3.604% 99.233% # ( 6, 10 ] 964 0.605% 99.838% ( 10, 15 ] 216 0.136% 99.974% ( 15, 22 ] 19 0.012% 99.986% ( 22, 34 ] 2 0.001% 99.987% ( 51, 76 ] 4 0.003% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 6 0.004% 99.994% ( 380, 580 ] 3 0.002% 99.996% ( 580, 870 ] 1 0.001% 99.997% ( 870, 1300 ] 6 0.004% 100.001% ** Level 2 read latency histogram (micros): Count: 48554 Average: 2.6370 StdDev: 29.47 Min: 1 Median: 1.5493 Max: 4621 Percentiles: P50: 1.55 P75: 1.91 P99: 5.98 P99.9: 13.73 P99.99: 885.54 ------------------------------------------------------ [ 0, 1 ] 5974 12.304% 12.304% ## ( 1, 2 ] 33323 68.631% 80.935% ############## ( 2, 3 ] 5465 11.256% 92.190% ## ( 3, 4 ] 2061 4.245% 96.435% # ( 4, 6 ] 1256 2.587% 99.022% # ( 6, 10 ] 378 0.779% 99.800% ( 10, 15 ] 65 0.134% 99.934% ( 15, 22 ] 7 0.014% 99.949% ( 34, 51 ] 1 0.002% 99.951% ( 51, 76 ] 2 0.004% 99.955% ( 76, 110 ] 2 0.004% 99.959% ( 110, 170 ] 4 0.008% 99.967% ( 170, 250 ] 1 0.002% 99.969% ( 250, 380 ] 3 0.006% 99.975% ( 380, 580 ] 3 0.006% 99.981% ( 580, 870 ] 4 0.008% 99.990% ( 870, 1300 ] 4 0.008% 99.998% ( 1900, 2900 ] 2 0.004% 100.002% ( 4400, 6600 ] 1 0.002% 100.004% ** Level 3 read latency histogram (micros): Count: 154768 Average: 4.0104 StdDev: 46.96 Min: 0 Median: 1.7027 Max: 5241 Percentiles: P50: 1.70 P75: 2.34 P99: 9.27 P99.9: 313.78 P99.99: 1032.08 ------------------------------------------------------ [ 0, 1 ] 8437 5.451% 5.451% # ( 1, 2 ] 98122 63.399% 68.851% ############# ( 2, 3 ] 27964 18.068% 86.919% #### ( 3, 4 ] 8711 5.628% 92.548% # ( 4, 6 ] 7635 4.933% 97.481% # ( 6, 10 ] 2872 1.856% 99.336% ( 10, 15 ] 358 0.231% 99.568% ( 15, 22 ] 44 0.028% 99.596% ( 22, 34 ] 2 0.001% 99.597% ( 51, 76 ] 10 0.006% 99.604% ( 76, 110 ] 104 0.067% 99.671% ( 110, 170 ] 222 0.143% 99.815% ( 170, 250 ] 92 0.059% 99.874% ( 250, 380 ] 82 0.053% 99.927% ( 380, 580 ] 59 0.038% 99.965% ( 580, 870 ] 34 0.022% 99.987% ( 870, 1300 ] 12 0.008% 99.995% ( 1300, 1900 ] 6 0.004% 99.999% ( 1900, 2900 ] 7 0.005% 100.003% ( 2900, 4400 ] 10 0.006% 100.010% ( 4400, 6600 ] 4 0.003% 100.012% ** Level 4 read latency histogram (micros): Count: 15 Average: 1570.9333 StdDev: 1561.11 Min: 222 Median: 652.5000 Max: 4790 Percentiles: P50: 652.50 P75: 2650.00 P99: 4790.00 P99.9: 4790.00 P99.99: 4790.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 2 13.333% 26.667% ### ( 380, 580 ] 3 20.000% 46.667% #### ( 580, 870 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 498.3500 StdDev: 720.18 Min: 82 Median: 150.0000 Max: 2547 Percentiles: P50: 150.00 P75: 580.00 P99: 2547.00 P99.9: 2547.00 P99.99: 2547.00 ------------------------------------------------------ ( 76, 110 ] 6 30.000% 30.000% ###### ( 110, 170 ] 6 30.000% 60.000% ###### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 2 10.000% 85.000% ## ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 322.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:1.007 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.36 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.383 H:M:S, 12.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/07-07:29:37 ... thread 0: (1000000,4000000) ops and (331972.6,335321.3) ops/second in (3.012297,11.928856) 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/8 2.77 GB 226.5 2.5 0.0 2.5 6.1 3.7 0.0 1.7 123.7 309.1 20.37 19.02 62 0.329 2558K 2780 0.0 0.0 L1 3/0 236.17 MB 23.6 1.0 0.7 0.2 1.0 0.7 0.2 1.3 239.1 238.5 4.21 4.10 2 2.103 1021K 2433 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 39/0 978.45 MB 1.0 1.6 0.7 0.9 1.6 0.7 0.1 2.3 205.2 204.7 8.05 7.23 4 2.012 1641K 4094 0.0 0.0 L4 144/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/8 99.82 GB 0.0 5.2 1.6 3.7 8.9 5.2 2.3 2.4 160.7 273.5 33.41 31.10 70 0.477 5416K 9390 0.0 0.0 Int 0/0 0.00 KB 0.0 5.2 1.6 3.7 8.9 5.2 2.2 2.4 160.7 273.5 33.41 31.10 70 0.477 5416K 9390 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.6 3.7 5.2 1.5 0.0 0.0 236.6 236.2 22.69 21.54 17 1.335 5416K 9390 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 352.6 10.72 9.56 53 0.202 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.2 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: 8.92 GB write, 751.29 MB/s write, 5.24 GB read, 441.38 MB/s read, 33.4 seconds Interval compaction: 8.92 GB write, 766.02 MB/s write, 5.24 GB read, 450.03 MB/s read, 33.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 15, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 948421 Average: 2.1750 StdDev: 11.92 Min: 0 Median: 1.4759 Max: 4623 Percentiles: P50: 1.48 P75: 1.86 P99: 5.63 P99.9: 10.70 P99.99: 14.75 ------------------------------------------------------ [ 0, 1 ] 184014 19.402% 19.402% #### ( 1, 2 ] 609796 64.296% 83.698% ############# ( 2, 3 ] 92554 9.759% 93.457% ## ( 3, 4 ] 35357 3.728% 97.185% # ( 4, 6 ] 21128 2.228% 99.412% ( 6, 10 ] 4476 0.472% 99.884% ( 10, 15 ] 1056 0.111% 99.996% ( 15, 22 ] 101 0.011% 100.006% ( 22, 34 ] 16 0.002% 100.008% ( 34, 51 ] 5 0.001% 100.009% ( 51, 76 ] 3 0.000% 100.009% ( 110, 170 ] 14 0.001% 100.010% ( 170, 250 ] 32 0.003% 100.014% ( 250, 380 ] 26 0.003% 100.017% ( 380, 580 ] 12 0.001% 100.018% ( 580, 870 ] 12 0.001% 100.019% ( 870, 1300 ] 14 0.001% 100.021% ( 1300, 1900 ] 4 0.000% 100.021% ( 1900, 2900 ] 6 0.001% 100.022% ( 2900, 4400 ] 3 0.000% 100.022% ( 4400, 6600 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 194743 Average: 2.4791 StdDev: 10.96 Min: 1 Median: 1.6302 Max: 3108 Percentiles: P50: 1.63 P75: 2.07 P99: 5.91 P99.9: 13.17 P99.99: 413.90 ------------------------------------------------------ [ 0, 1 ] 18095 9.292% 9.292% ## ( 1, 2 ] 125802 64.599% 73.891% ############# ( 2, 3 ] 31944 16.403% 90.294% ### ( 3, 4 ] 9985 5.127% 95.421% # ( 4, 6 ] 7280 3.738% 99.159% # ( 6, 10 ] 1266 0.650% 99.809% ( 10, 15 ] 278 0.143% 99.952% ( 15, 22 ] 26 0.013% 99.966% ( 22, 34 ] 3 0.002% 99.967% ( 51, 76 ] 4 0.002% 99.969% ( 110, 170 ] 18 0.009% 99.978% ( 170, 250 ] 11 0.006% 99.984% ( 250, 380 ] 10 0.005% 99.989% ( 380, 580 ] 9 0.005% 99.994% ( 580, 870 ] 4 0.002% 99.996% ( 870, 1300 ] 7 0.004% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 77125 Average: 2.9757 StdDev: 26.30 Min: 1 Median: 1.6018 Max: 4621 Percentiles: P50: 1.60 P75: 1.97 P99: 7.87 P99.9: 163.55 P99.99: 852.78 ------------------------------------------------------ [ 0, 1 ] 7442 9.649% 9.649% ## ( 1, 2 ] 51714 67.052% 76.701% ############# ( 2, 3 ] 10487 13.597% 90.299% ### ( 3, 4 ] 3704 4.803% 95.101% # ( 4, 6 ] 2567 3.328% 98.430% # ( 6, 10 ] 941 1.220% 99.650% ( 10, 15 ] 104 0.135% 99.785% ( 15, 22 ] 10 0.013% 99.798% ( 34, 51 ] 1 0.001% 99.799% ( 51, 76 ] 2 0.003% 99.802% ( 76, 110 ] 25 0.032% 99.834% ( 110, 170 ] 57 0.074% 99.908% ( 170, 250 ] 23 0.030% 99.938% ( 250, 380 ] 15 0.019% 99.957% ( 380, 580 ] 14 0.018% 99.975% ( 580, 870 ] 12 0.016% 99.991% ( 870, 1300 ] 6 0.008% 99.999% ( 1900, 2900 ] 2 0.003% 100.001% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 212194 Average: 3.7888 StdDev: 41.25 Min: 0 Median: 1.7136 Max: 5241 Percentiles: P50: 1.71 P75: 2.37 P99: 9.22 P99.9: 258.39 P99.99: 801.45 ------------------------------------------------------ [ 0, 1 ] 11059 5.212% 5.212% # ( 1, 2 ] 133172 62.760% 67.971% ############# ( 2, 3 ] 40081 18.889% 86.860% #### ( 3, 4 ] 11917 5.616% 92.476% # ( 4, 6 ] 10568 4.980% 97.457% # ( 6, 10 ] 4069 1.918% 99.374% ( 10, 15 ] 504 0.238% 99.612% ( 15, 22 ] 70 0.033% 99.645% ( 22, 34 ] 9 0.004% 99.649% ( 34, 51 ] 20 0.009% 99.658% ( 51, 76 ] 27 0.013% 99.671% ( 76, 110 ] 118 0.056% 99.727% ( 110, 170 ] 254 0.120% 99.846% ( 170, 250 ] 108 0.051% 99.897% ( 250, 380 ] 90 0.042% 99.940% ( 380, 580 ] 77 0.036% 99.976% ( 580, 870 ] 39 0.018% 99.994% ( 870, 1300 ] 16 0.008% 100.002% ( 1300, 1900 ] 9 0.004% 100.006% ( 1900, 2900 ] 7 0.003% 100.009% ( 2900, 4400 ] 10 0.005% 100.014% ( 4400, 6600 ] 4 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 15 Average: 1570.9333 StdDev: 1561.11 Min: 222 Median: 652.5000 Max: 4790 Percentiles: P50: 652.50 P75: 2650.00 P99: 4790.00 P99.9: 4790.00 P99.99: 4790.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 2 13.333% 26.667% ### ( 380, 580 ] 3 20.000% 46.667% #### ( 580, 870 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 687.5250 StdDev: 854.45 Min: 82 Median: 315.0000 Max: 3315 Percentiles: P50: 315.00 P75: 870.00 P99: 3315.00 P99.9: 3315.00 P99.99: 3315.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 7 17.500% 37.500% #### ( 170, 250 ] 2 5.000% 42.500% # ( 250, 380 ] 6 15.000% 57.500% ### ( 380, 580 ] 4 10.000% 67.500% ## ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 3 7.500% 82.500% ## ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.2 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 323.62 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.390 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.72 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.383 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-07:29:41 ... thread 0: (1000000,5000000) ops and (280895.0,322811.7) ops/second in (3.560049,15.488905) 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/17 3.75 GB 50.3 3.5 0.0 3.5 8.2 4.7 0.0 1.7 132.0 307.8 27.21 25.49 81 0.336 3646K 3886 0.0 0.0 L1 3/3 236.17 MB 0.0 1.0 0.7 0.2 1.0 0.7 0.2 1.3 239.1 238.5 4.21 4.10 2 2.103 1021K 2433 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 39/0 978.45 MB 1.0 1.6 0.7 0.9 1.6 0.7 0.1 2.3 205.2 204.7 8.05 7.23 4 2.012 1641K 4094 0.0 0.0 L4 144/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/20 100.80 GB 0.0 6.3 1.6 4.7 11.0 6.2 2.3 2.3 160.0 278.7 40.25 37.57 89 0.452 6503K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.3 1.6 4.7 11.0 6.2 2.2 2.3 160.0 278.7 40.25 37.57 89 0.452 6503K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.3 1.6 4.7 6.3 1.5 0.0 0.0 241.0 240.6 26.73 25.50 21 1.273 6503K 10K 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 353.9 13.53 12.06 68 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.7 total, 15.5 interval Flush(GB): cumulative 4.676, interval 4.676 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: 10.95 GB write, 713.34 MB/s write, 6.29 GB read, 409.56 MB/s read, 40.3 seconds Interval compaction: 10.95 GB write, 724.10 MB/s write, 6.29 GB read, 415.74 MB/s read, 40.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 16, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1321146 Average: 2.1923 StdDev: 11.58 Min: 0 Median: 1.4704 Max: 4623 Percentiles: P50: 1.47 P75: 1.86 P99: 5.63 P99.9: 11.73 P99.99: 84.54 ------------------------------------------------------ [ 0, 1 ] 257748 19.509% 19.509% #### ( 1, 2 ] 856268 64.813% 84.322% ############# ( 2, 3 ] 125723 9.516% 93.838% ## ( 3, 4 ] 46588 3.526% 97.364% # ( 4, 6 ] 26508 2.006% 99.371% ( 6, 10 ] 6473 0.490% 99.861% ( 10, 15 ] 1493 0.113% 99.974% ( 15, 22 ] 147 0.011% 99.985% ( 22, 34 ] 22 0.002% 99.987% ( 34, 51 ] 7 0.001% 99.987% ( 51, 76 ] 5 0.000% 99.988% ( 76, 110 ] 127 0.010% 99.997% ( 110, 170 ] 133 0.010% 100.007% ( 170, 250 ] 68 0.005% 100.012% ( 250, 380 ] 44 0.003% 100.016% ( 380, 580 ] 34 0.003% 100.018% ( 580, 870 ] 26 0.002% 100.020% ( 870, 1300 ] 19 0.001% 100.022% ( 1300, 1900 ] 5 0.000% 100.022% ( 1900, 2900 ] 7 0.001% 100.023% ( 2900, 4400 ] 4 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 194744 Average: 2.4812 StdDev: 11.00 Min: 1 Median: 1.6302 Max: 3108 Percentiles: P50: 1.63 P75: 2.07 P99: 5.91 P99.9: 13.19 P99.99: 430.51 ------------------------------------------------------ [ 0, 1 ] 18095 9.292% 9.292% ## ( 1, 2 ] 125802 64.599% 73.890% ############# ( 2, 3 ] 31944 16.403% 90.293% ### ( 3, 4 ] 9985 5.127% 95.421% # ( 4, 6 ] 7280 3.738% 99.159% # ( 6, 10 ] 1266 0.650% 99.809% ( 10, 15 ] 278 0.143% 99.952% ( 15, 22 ] 26 0.013% 99.965% ( 22, 34 ] 3 0.002% 99.967% ( 51, 76 ] 4 0.002% 99.969% ( 110, 170 ] 18 0.009% 99.978% ( 170, 250 ] 11 0.006% 99.984% ( 250, 380 ] 10 0.005% 99.989% ( 380, 580 ] 10 0.005% 99.994% ( 580, 870 ] 4 0.002% 99.996% ( 870, 1300 ] 7 0.004% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 77125 Average: 2.9757 StdDev: 26.30 Min: 1 Median: 1.6018 Max: 4621 Percentiles: P50: 1.60 P75: 1.97 P99: 7.87 P99.9: 163.55 P99.99: 852.78 ------------------------------------------------------ [ 0, 1 ] 7442 9.649% 9.649% ## ( 1, 2 ] 51714 67.052% 76.701% ############# ( 2, 3 ] 10487 13.597% 90.299% ### ( 3, 4 ] 3704 4.803% 95.101% # ( 4, 6 ] 2567 3.328% 98.430% # ( 6, 10 ] 941 1.220% 99.650% ( 10, 15 ] 104 0.135% 99.785% ( 15, 22 ] 10 0.013% 99.798% ( 34, 51 ] 1 0.001% 99.799% ( 51, 76 ] 2 0.003% 99.802% ( 76, 110 ] 25 0.032% 99.834% ( 110, 170 ] 57 0.074% 99.908% ( 170, 250 ] 23 0.030% 99.938% ( 250, 380 ] 15 0.019% 99.957% ( 380, 580 ] 14 0.018% 99.975% ( 580, 870 ] 12 0.016% 99.991% ( 870, 1300 ] 6 0.008% 99.999% ( 1900, 2900 ] 2 0.003% 100.001% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 212194 Average: 3.7888 StdDev: 41.25 Min: 0 Median: 1.7136 Max: 5241 Percentiles: P50: 1.71 P75: 2.37 P99: 9.22 P99.9: 258.39 P99.99: 801.45 ------------------------------------------------------ [ 0, 1 ] 11059 5.212% 5.212% # ( 1, 2 ] 133172 62.760% 67.971% ############# ( 2, 3 ] 40081 18.889% 86.860% #### ( 3, 4 ] 11917 5.616% 92.476% # ( 4, 6 ] 10568 4.980% 97.457% # ( 6, 10 ] 4069 1.918% 99.374% ( 10, 15 ] 504 0.238% 99.612% ( 15, 22 ] 70 0.033% 99.645% ( 22, 34 ] 9 0.004% 99.649% ( 34, 51 ] 20 0.009% 99.658% ( 51, 76 ] 27 0.013% 99.671% ( 76, 110 ] 118 0.056% 99.727% ( 110, 170 ] 254 0.120% 99.846% ( 170, 250 ] 108 0.051% 99.897% ( 250, 380 ] 90 0.042% 99.940% ( 380, 580 ] 77 0.036% 99.976% ( 580, 870 ] 39 0.018% 99.994% ( 870, 1300 ] 16 0.008% 100.002% ( 1300, 1900 ] 9 0.004% 100.006% ( 1900, 2900 ] 7 0.003% 100.009% ( 2900, 4400 ] 10 0.005% 100.014% ( 4400, 6600 ] 4 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 15 Average: 1570.9333 StdDev: 1561.11 Min: 222 Median: 652.5000 Max: 4790 Percentiles: P50: 652.50 P75: 2650.00 P99: 4790.00 P99.9: 4790.00 P99.99: 4790.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 2 13.333% 26.667% ### ( 380, 580 ] 3 20.000% 46.667% #### ( 580, 870 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 687.5250 StdDev: 854.45 Min: 82 Median: 315.0000 Max: 3315 Percentiles: P50: 315.00 P75: 870.00 P99: 3315.00 P99.9: 3315.00 P99.99: 3315.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 7 17.500% 37.500% #### ( 170, 250 ] 2 5.000% 42.500% # ( 250, 380 ] 6 15.000% 57.500% ### ( 380, 580 ] 4 10.000% 67.500% ## ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 3 7.500% 82.500% ## ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.7 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 312.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.320 H:M:S, 14.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 276.45 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.930 H:M:S, 26.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-07:29:50 ... thread 0: (1000000,6000000) ops and (111440.1,245275.1) ops/second in (8.973428,24.462333) 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 4.73 GB 175.8 5.5 0.0 5.5 11.2 5.7 0.0 2.0 149.9 302.9 37.82 35.67 102 0.371 5755K 9542 0.0 0.0 L1 3/3 236.17 MB 0.0 1.0 0.7 0.2 1.0 0.7 0.2 1.3 239.1 238.5 4.21 4.10 2 2.103 1021K 2433 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 39/0 978.45 MB 1.0 1.6 0.7 0.9 1.6 0.7 0.1 2.3 205.2 204.7 8.05 7.23 4 2.012 1641K 4094 0.0 0.0 L4 144/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/16 101.78 GB 0.0 8.3 1.6 6.8 14.0 7.2 2.3 2.5 167.5 281.1 50.86 47.74 110 0.462 8613K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.3 1.6 6.8 14.0 7.2 2.2 2.5 167.5 281.1 50.86 47.74 110 0.462 8613K 16K 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 8.3 1.6 6.8 8.3 1.5 0.0 0.0 247.5 247.0 34.42 33.08 26 1.324 8613K 16K 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 352.6 16.44 14.67 84 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): 24.7 total, 24.5 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: 13.96 GB write, 578.88 MB/s write, 8.32 GB read, 344.89 MB/s read, 50.9 seconds Interval compaction: 13.96 GB write, 584.41 MB/s write, 8.32 GB read, 348.19 MB/s read, 50.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 16, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2328476 Average: 2.1746 StdDev: 10.26 Min: 0 Median: 1.4654 Max: 4623 Percentiles: P50: 1.47 P75: 1.84 P99: 5.57 P99.9: 11.25 P99.99: 105.37 ------------------------------------------------------ [ 0, 1 ] 444457 19.088% 19.088% #### ( 1, 2 ] 1546543 66.419% 85.507% ############# ( 2, 3 ] 208632 8.960% 94.467% ## ( 3, 4 ] 74661 3.206% 97.673% # ( 4, 6 ] 39335 1.689% 99.362% ( 6, 10 ] 12010 0.516% 99.878% ( 10, 15 ] 2042 0.088% 99.966% ( 15, 22 ] 212 0.009% 99.975% ( 22, 34 ] 28 0.001% 99.976% ( 34, 51 ] 10 0.000% 99.977% ( 51, 76 ] 11 0.000% 99.977% ( 76, 110 ] 351 0.015% 99.992% ( 110, 170 ] 335 0.014% 100.006% ( 170, 250 ] 134 0.006% 100.012% ( 250, 380 ] 81 0.003% 100.016% ( 380, 580 ] 68 0.003% 100.019% ( 580, 870 ] 47 0.002% 100.021% ( 870, 1300 ] 26 0.001% 100.022% ( 1300, 1900 ] 6 0.000% 100.022% ( 1900, 2900 ] 10 0.000% 100.022% ( 2900, 4400 ] 5 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 222926 Average: 2.4881 StdDev: 11.34 Min: 1 Median: 1.6061 Max: 3108 Percentiles: P50: 1.61 P75: 1.99 P99: 5.95 P99.9: 13.89 P99.99: 501.34 ------------------------------------------------------ [ 0, 1 ] 23806 10.679% 10.679% ## ( 1, 2 ] 144614 64.871% 75.550% ############# ( 2, 3 ] 34046 15.272% 90.822% ### ( 3, 4 ] 10710 4.804% 95.626% # ( 4, 6 ] 7697 3.453% 99.079% # ( 6, 10 ] 1607 0.721% 99.800% ( 10, 15 ] 287 0.129% 99.929% ( 15, 22 ] 28 0.013% 99.941% ( 22, 34 ] 3 0.001% 99.943% ( 51, 76 ] 4 0.002% 99.944% ( 76, 110 ] 8 0.004% 99.948% ( 110, 170 ] 49 0.022% 99.970% ( 170, 250 ] 21 0.009% 99.979% ( 250, 380 ] 14 0.006% 99.986% ( 380, 580 ] 16 0.007% 99.993% ( 580, 870 ] 7 0.003% 99.996% ( 870, 1300 ] 8 0.004% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 77125 Average: 2.9757 StdDev: 26.30 Min: 1 Median: 1.6018 Max: 4621 Percentiles: P50: 1.60 P75: 1.97 P99: 7.87 P99.9: 163.55 P99.99: 852.78 ------------------------------------------------------ [ 0, 1 ] 7442 9.649% 9.649% ## ( 1, 2 ] 51714 67.052% 76.701% ############# ( 2, 3 ] 10487 13.597% 90.299% ### ( 3, 4 ] 3704 4.803% 95.101% # ( 4, 6 ] 2567 3.328% 98.430% # ( 6, 10 ] 941 1.220% 99.650% ( 10, 15 ] 104 0.135% 99.785% ( 15, 22 ] 10 0.013% 99.798% ( 34, 51 ] 1 0.001% 99.799% ( 51, 76 ] 2 0.003% 99.802% ( 76, 110 ] 25 0.032% 99.834% ( 110, 170 ] 57 0.074% 99.908% ( 170, 250 ] 23 0.030% 99.938% ( 250, 380 ] 15 0.019% 99.957% ( 380, 580 ] 14 0.018% 99.975% ( 580, 870 ] 12 0.016% 99.991% ( 870, 1300 ] 6 0.008% 99.999% ( 1900, 2900 ] 2 0.003% 100.001% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 212194 Average: 3.7888 StdDev: 41.25 Min: 0 Median: 1.7136 Max: 5241 Percentiles: P50: 1.71 P75: 2.37 P99: 9.22 P99.9: 258.39 P99.99: 801.45 ------------------------------------------------------ [ 0, 1 ] 11059 5.212% 5.212% # ( 1, 2 ] 133172 62.760% 67.971% ############# ( 2, 3 ] 40081 18.889% 86.860% #### ( 3, 4 ] 11917 5.616% 92.476% # ( 4, 6 ] 10568 4.980% 97.457% # ( 6, 10 ] 4069 1.918% 99.374% ( 10, 15 ] 504 0.238% 99.612% ( 15, 22 ] 70 0.033% 99.645% ( 22, 34 ] 9 0.004% 99.649% ( 34, 51 ] 20 0.009% 99.658% ( 51, 76 ] 27 0.013% 99.671% ( 76, 110 ] 118 0.056% 99.727% ( 110, 170 ] 254 0.120% 99.846% ( 170, 250 ] 108 0.051% 99.897% ( 250, 380 ] 90 0.042% 99.940% ( 380, 580 ] 77 0.036% 99.976% ( 580, 870 ] 39 0.018% 99.994% ( 870, 1300 ] 16 0.008% 100.002% ( 1300, 1900 ] 9 0.004% 100.006% ( 1900, 2900 ] 7 0.003% 100.009% ( 2900, 4400 ] 10 0.005% 100.014% ( 4400, 6600 ] 4 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 15 Average: 1570.9333 StdDev: 1561.11 Min: 222 Median: 652.5000 Max: 4790 Percentiles: P50: 652.50 P75: 2650.00 P99: 4790.00 P99.9: 4790.00 P99.99: 4790.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 2 13.333% 26.667% ### ( 380, 580 ] 3 20.000% 46.667% #### ( 580, 870 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 687.5250 StdDev: 854.45 Min: 82 Median: 315.0000 Max: 3315 Percentiles: P50: 315.00 P75: 870.00 P99: 3315.00 P99.9: 3315.00 P99.99: 3315.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 7 17.500% 37.500% #### ( 170, 250 ] 2 5.000% 42.500% # ( 250, 380 ] 6 15.000% 57.500% ### ( 380, 580 ] 4 10.000% 67.500% ## ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 3 7.500% 82.500% ## ( 1300, 1900 ] 1 2.500% 85.000% # ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 24.7 total, 9.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 239.09 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:8.371 H:M:S, 33.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 109.68 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:6.051 H:M:S, 67.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-07:29:57 ... thread 0: (1000000,7000000) ops and (140161.4,221540.3) ops/second in (7.134634,31.596967) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/9 2.64 GB 12.6 6.8 0.0 6.8 13.4 6.6 0.0 2.0 144.7 284.0 48.31 43.61 118 0.409 7098K 12K 0.0 0.0 L1 16/16 961.18 MB 0.0 4.2 3.7 0.5 4.2 3.7 0.2 1.1 224.6 221.8 19.25 18.33 3 6.418 4391K 54K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.8 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 14/0 920.13 MB 0.9 2.0 1.0 1.0 2.0 1.0 2.0 2.0 144.4 143.9 14.47 10.69 11 1.315 2072K 6831 0.0 0.0 L4 168/0 9.64 GB 1.0 1.5 1.2 0.4 1.5 1.2 1.9 1.3 116.6 115.9 13.39 7.69 15 0.893 1586K 9919 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1284/25 102.64 GB 0.0 14.8 6.1 8.7 21.3 12.6 9.9 3.2 157.6 226.8 96.21 81.07 149 0.646 15M 83K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.8 6.1 8.7 21.3 12.6 9.8 3.2 157.6 226.8 96.21 81.07 149 0.646 15M 83K 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.8 6.1 8.7 14.7 6.0 0.0 0.0 200.6 199.5 75.57 63.79 52 1.453 15M 83K 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 326.5 20.64 17.29 97 0.213 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): 31.8 total, 31.6 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: 21.31 GB write, 685.36 MB/s write, 14.81 GB read, 476.27 MB/s read, 96.2 seconds Interval compaction: 21.31 GB write, 690.44 MB/s write, 14.81 GB read, 479.79 MB/s read, 96.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 34, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2869945 Average: 2.5189 StdDev: 34.78 Min: 0 Median: 1.4780 Max: 12726 Percentiles: P50: 1.48 P75: 1.86 P99: 5.86 P99.9: 42.54 P99.99: 225.17 ------------------------------------------------------ [ 0, 1 ] 531048 18.504% 18.504% #### ( 1, 2 ] 1891209 65.897% 84.401% ############# ( 2, 3 ] 268471 9.355% 93.755% ## ( 3, 4 ] 97678 3.403% 97.159% # ( 4, 6 ] 56766 1.978% 99.137% ( 6, 10 ] 18792 0.655% 99.792% ( 10, 15 ] 2762 0.096% 99.888% ( 15, 22 ] 304 0.011% 99.898% ( 22, 34 ] 33 0.001% 99.900% ( 34, 51 ] 26 0.001% 99.900% ( 51, 76 ] 29 0.001% 99.901% ( 76, 110 ] 1027 0.036% 99.937% ( 110, 170 ] 1243 0.043% 99.981% ( 170, 250 ] 393 0.014% 99.994% ( 250, 380 ] 269 0.009% 100.004% ( 380, 580 ] 231 0.008% 100.012% ( 580, 870 ] 127 0.004% 100.016% ( 870, 1300 ] 69 0.002% 100.019% ( 1300, 1900 ] 23 0.001% 100.019% ( 1900, 2900 ] 25 0.001% 100.020% ( 2900, 4400 ] 28 0.001% 100.021% ( 4400, 6600 ] 20 0.001% 100.022% ( 6600, 9900 ] 22 0.001% 100.023% ( 9900, 14000 ] 6 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 642307 Average: 4.6332 StdDev: 70.51 Min: 1 Median: 1.7683 Max: 10951 Percentiles: P50: 1.77 P75: 2.61 P99: 8.71 P99.9: 15.59 P99.99: 167.11 ------------------------------------------------------ [ 0, 1 ] 41285 6.428% 6.428% # ( 1, 2 ] 364290 56.716% 63.143% ########### ( 2, 3 ] 124863 19.440% 82.583% #### ( 3, 4 ] 49349 7.683% 90.266% ## ( 4, 6 ] 48183 7.502% 97.768% ## ( 6, 10 ] 11672 1.817% 99.585% ( 10, 15 ] 2000 0.311% 99.896% ( 15, 22 ] 270 0.042% 99.939% ( 22, 34 ] 23 0.004% 99.942% ( 34, 51 ] 4 0.001% 99.943% ( 51, 76 ] 11 0.002% 99.944% ( 76, 110 ] 130 0.020% 99.965% ( 110, 170 ] 171 0.027% 99.991% ( 170, 250 ] 125 0.019% 100.011% ( 250, 380 ] 168 0.026% 100.037% ( 380, 580 ] 205 0.032% 100.069% ( 580, 870 ] 181 0.028% 100.097% ( 870, 1300 ] 137 0.021% 100.118% ( 1300, 1900 ] 83 0.013% 100.131% ( 1900, 2900 ] 64 0.010% 100.141% ( 2900, 4400 ] 82 0.013% 100.154% ( 4400, 6600 ] 31 0.005% 100.159% ( 6600, 9900 ] 5 0.001% 100.160% ( 9900, 14000 ] 1 0.000% 100.160% ** Level 2 read latency histogram (micros): Count: 77125 Average: 2.9757 StdDev: 26.30 Min: 1 Median: 1.6018 Max: 4621 Percentiles: P50: 1.60 P75: 1.97 P99: 7.87 P99.9: 163.55 P99.99: 852.78 ------------------------------------------------------ [ 0, 1 ] 7442 9.649% 9.649% ## ( 1, 2 ] 51714 67.052% 76.701% ############# ( 2, 3 ] 10487 13.597% 90.299% ### ( 3, 4 ] 3704 4.803% 95.101% # ( 4, 6 ] 2567 3.328% 98.430% # ( 6, 10 ] 941 1.220% 99.650% ( 10, 15 ] 104 0.135% 99.785% ( 15, 22 ] 10 0.013% 99.798% ( 34, 51 ] 1 0.001% 99.799% ( 51, 76 ] 2 0.003% 99.802% ( 76, 110 ] 25 0.032% 99.834% ( 110, 170 ] 57 0.074% 99.908% ( 170, 250 ] 23 0.030% 99.938% ( 250, 380 ] 15 0.019% 99.957% ( 380, 580 ] 14 0.018% 99.975% ( 580, 870 ] 12 0.016% 99.991% ( 870, 1300 ] 6 0.008% 99.999% ( 1900, 2900 ] 2 0.003% 100.001% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 330641 Average: 12.4911 StdDev: 229.22 Min: 0 Median: 1.7412 Max: 32533 Percentiles: P50: 1.74 P75: 2.50 P99: 14.86 P99.9: 1352.79 P99.99: 5317.13 ------------------------------------------------------ [ 0, 1 ] 19056 5.763% 5.763% # ( 1, 2 ] 197333 59.682% 65.445% ############ ( 2, 3 ] 62569 18.924% 84.369% #### ( 3, 4 ] 23248 7.031% 91.400% # ( 4, 6 ] 17576 5.316% 96.716% # ( 6, 10 ] 6652 2.012% 98.728% ( 10, 15 ] 926 0.280% 99.008% ( 15, 22 ] 127 0.038% 99.046% ( 22, 34 ] 18 0.005% 99.052% ( 34, 51 ] 22 0.007% 99.058% ( 51, 76 ] 28 0.008% 99.067% ( 76, 110 ] 196 0.059% 99.126% ( 110, 170 ] 477 0.144% 99.270% ( 170, 250 ] 373 0.113% 99.383% ( 250, 380 ] 450 0.136% 99.519% ( 380, 580 ] 583 0.176% 99.695% ( 580, 870 ] 441 0.133% 99.829% ( 870, 1300 ] 227 0.069% 99.897% ( 1300, 1900 ] 95 0.029% 99.926% ( 1900, 2900 ] 82 0.025% 99.951% ( 2900, 4400 ] 91 0.028% 99.979% ( 4400, 6600 ] 91 0.028% 100.006% ( 6600, 9900 ] 51 0.015% 100.021% ( 9900, 14000 ] 29 0.009% 100.030% ( 14000, 22000 ] 12 0.004% 100.034% ( 22000, 33000 ] 3 0.001% 100.035% ** Level 4 read latency histogram (micros): Count: 225 Average: 257.7067 StdDev: 747.47 Min: 1 Median: 2.3500 Max: 6501 Percentiles: P50: 2.35 P75: 210.95 P99: 4212.50 P99.9: 6352.50 P99.99: 6501.00 ------------------------------------------------------ [ 0, 1 ] 35 15.556% 15.556% ### ( 1, 2 ] 67 29.778% 45.333% ###### ( 2, 3 ] 30 13.333% 58.667% ### ( 3, 4 ] 7 3.111% 61.778% # ( 4, 6 ] 9 4.000% 65.778% # ( 6, 10 ] 3 1.333% 67.111% ( 10, 15 ] 2 0.889% 68.000% ( 76, 110 ] 2 0.889% 68.889% ( 110, 170 ] 3 1.333% 70.222% ( 170, 250 ] 21 9.333% 79.556% ## ( 250, 380 ] 11 4.889% 84.444% # ( 380, 580 ] 11 4.889% 89.333% # ( 580, 870 ] 6 2.667% 92.000% # ( 870, 1300 ] 8 3.556% 95.556% # ( 1300, 1900 ] 2 0.889% 96.444% ( 1900, 2900 ] 4 1.778% 98.222% ( 2900, 4400 ] 2 0.889% 99.111% ( 4400, 6600 ] 2 0.889% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1151.5833 StdDev: 1231.34 Min: 82 Median: 609.0000 Max: 5635 Percentiles: P50: 609.00 P75: 1723.53 P99: 5635.00 P99.9: 5635.00 P99.99: 5635.00 ------------------------------------------------------ ( 76, 110 ] 14 7.778% 7.778% ## ( 110, 170 ] 15 8.333% 16.111% ## ( 170, 250 ] 12 6.667% 22.778% # ( 250, 380 ] 22 12.222% 35.000% ## ( 380, 580 ] 25 13.889% 48.889% ### ( 580, 870 ] 20 11.111% 60.000% ## ( 870, 1300 ] 15 8.333% 68.333% ## ( 1300, 1900 ] 17 9.444% 77.778% ## ( 1900, 2900 ] 19 10.556% 88.333% ## ( 2900, 4400 ] 16 8.889% 97.222% ## ( 4400, 6600 ] 5 2.778% 100.000% # ** DB Stats ** Uptime(secs): 31.8 total, 7.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 216.42 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.466 H:M:S, 39.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 137.95 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.095 H:M:S, 57.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-07:30:00 ... thread 0: (1000000,8000000) ops and (324555.2,230693.1) ops/second in (3.081140,34.678107) 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 3.62 GB 81.8 7.4 0.0 7.4 14.9 7.6 0.0 2.0 141.8 286.9 53.30 48.26 134 0.398 7674K 13K 0.0 0.0 L1 16/16 961.18 MB 0.0 4.2 3.7 0.5 4.2 3.7 0.2 1.1 224.6 221.8 19.25 18.33 3 6.418 4391K 54K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.8 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 14/0 920.13 MB 0.9 2.0 1.0 1.0 2.0 1.0 2.0 2.0 144.4 143.9 14.47 10.69 11 1.315 2072K 6831 0.0 0.0 L4 168/0 9.64 GB 1.0 1.5 1.2 0.4 1.5 1.2 1.9 1.3 116.6 115.9 13.39 7.69 15 0.893 1586K 9919 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1292/29 103.62 GB 0.0 15.4 6.1 9.3 22.8 13.5 9.9 3.0 155.4 231.1 101.21 85.73 165 0.613 15M 84K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.4 6.1 9.3 22.8 13.5 9.8 3.0 155.4 231.1 101.21 85.73 165 0.613 15M 84K 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 15.4 6.1 9.3 15.3 6.0 0.0 0.0 202.4 201.3 77.70 65.88 54 1.439 15M 84K 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 329.6 23.51 19.85 111 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): 34.9 total, 34.7 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.84 GB write, 669.97 MB/s write, 15.36 GB read, 450.47 MB/s read, 101.2 seconds Interval compaction: 22.84 GB write, 674.49 MB/s write, 15.36 GB read, 453.51 MB/s read, 101.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 38, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3290501 Average: 2.4897 StdDev: 32.65 Min: 0 Median: 1.4892 Max: 12726 Percentiles: P50: 1.49 P75: 1.87 P99: 5.87 P99.9: 14.71 P99.99: 181.02 ------------------------------------------------------ [ 0, 1 ] 582091 17.690% 17.690% #### ( 1, 2 ] 2173331 66.049% 83.739% ############# ( 2, 3 ] 326094 9.910% 93.649% ## ( 3, 4 ] 113638 3.454% 97.102% # ( 4, 6 ] 66901 2.033% 99.136% ( 6, 10 ] 22212 0.675% 99.811% ( 10, 15 ] 3126 0.095% 99.906% ( 15, 22 ] 344 0.010% 99.916% ( 22, 34 ] 36 0.001% 99.917% ( 34, 51 ] 28 0.001% 99.918% ( 51, 76 ] 32 0.001% 99.919% ( 76, 110 ] 1031 0.031% 99.950% ( 110, 170 ] 1254 0.038% 99.988% ( 170, 250 ] 406 0.012% 100.001% ( 250, 380 ] 276 0.008% 100.009% ( 380, 580 ] 235 0.007% 100.016% ( 580, 870 ] 136 0.004% 100.020% ( 870, 1300 ] 73 0.002% 100.023% ( 1300, 1900 ] 23 0.001% 100.023% ( 1900, 2900 ] 27 0.001% 100.024% ( 2900, 4400 ] 29 0.001% 100.025% ( 4400, 6600 ] 20 0.001% 100.026% ( 6600, 9900 ] 22 0.001% 100.026% ( 9900, 14000 ] 6 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 642307 Average: 4.6332 StdDev: 70.51 Min: 1 Median: 1.7683 Max: 10951 Percentiles: P50: 1.77 P75: 2.61 P99: 8.71 P99.9: 15.59 P99.99: 167.11 ------------------------------------------------------ [ 0, 1 ] 41285 6.428% 6.428% # ( 1, 2 ] 364290 56.716% 63.143% ########### ( 2, 3 ] 124863 19.440% 82.583% #### ( 3, 4 ] 49349 7.683% 90.266% ## ( 4, 6 ] 48183 7.502% 97.768% ## ( 6, 10 ] 11672 1.817% 99.585% ( 10, 15 ] 2000 0.311% 99.896% ( 15, 22 ] 270 0.042% 99.939% ( 22, 34 ] 23 0.004% 99.942% ( 34, 51 ] 4 0.001% 99.943% ( 51, 76 ] 11 0.002% 99.944% ( 76, 110 ] 130 0.020% 99.965% ( 110, 170 ] 171 0.027% 99.991% ( 170, 250 ] 125 0.019% 100.011% ( 250, 380 ] 168 0.026% 100.037% ( 380, 580 ] 205 0.032% 100.069% ( 580, 870 ] 181 0.028% 100.097% ( 870, 1300 ] 137 0.021% 100.118% ( 1300, 1900 ] 83 0.013% 100.131% ( 1900, 2900 ] 64 0.010% 100.141% ( 2900, 4400 ] 82 0.013% 100.154% ( 4400, 6600 ] 31 0.005% 100.159% ( 6600, 9900 ] 5 0.001% 100.160% ( 9900, 14000 ] 1 0.000% 100.160% ** Level 2 read latency histogram (micros): Count: 77125 Average: 2.9757 StdDev: 26.30 Min: 1 Median: 1.6018 Max: 4621 Percentiles: P50: 1.60 P75: 1.97 P99: 7.87 P99.9: 163.55 P99.99: 852.78 ------------------------------------------------------ [ 0, 1 ] 7442 9.649% 9.649% ## ( 1, 2 ] 51714 67.052% 76.701% ############# ( 2, 3 ] 10487 13.597% 90.299% ### ( 3, 4 ] 3704 4.803% 95.101% # ( 4, 6 ] 2567 3.328% 98.430% # ( 6, 10 ] 941 1.220% 99.650% ( 10, 15 ] 104 0.135% 99.785% ( 15, 22 ] 10 0.013% 99.798% ( 34, 51 ] 1 0.001% 99.799% ( 51, 76 ] 2 0.003% 99.802% ( 76, 110 ] 25 0.032% 99.834% ( 110, 170 ] 57 0.074% 99.908% ( 170, 250 ] 23 0.030% 99.938% ( 250, 380 ] 15 0.019% 99.957% ( 380, 580 ] 14 0.018% 99.975% ( 580, 870 ] 12 0.016% 99.991% ( 870, 1300 ] 6 0.008% 99.999% ( 1900, 2900 ] 2 0.003% 100.001% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 330641 Average: 12.4911 StdDev: 229.22 Min: 0 Median: 1.7412 Max: 32533 Percentiles: P50: 1.74 P75: 2.50 P99: 14.86 P99.9: 1352.79 P99.99: 5317.13 ------------------------------------------------------ [ 0, 1 ] 19056 5.763% 5.763% # ( 1, 2 ] 197333 59.682% 65.445% ############ ( 2, 3 ] 62569 18.924% 84.369% #### ( 3, 4 ] 23248 7.031% 91.400% # ( 4, 6 ] 17576 5.316% 96.716% # ( 6, 10 ] 6652 2.012% 98.728% ( 10, 15 ] 926 0.280% 99.008% ( 15, 22 ] 127 0.038% 99.046% ( 22, 34 ] 18 0.005% 99.052% ( 34, 51 ] 22 0.007% 99.058% ( 51, 76 ] 28 0.008% 99.067% ( 76, 110 ] 196 0.059% 99.126% ( 110, 170 ] 477 0.144% 99.270% ( 170, 250 ] 373 0.113% 99.383% ( 250, 380 ] 450 0.136% 99.519% ( 380, 580 ] 583 0.176% 99.695% ( 580, 870 ] 441 0.133% 99.829% ( 870, 1300 ] 227 0.069% 99.897% ( 1300, 1900 ] 95 0.029% 99.926% ( 1900, 2900 ] 82 0.025% 99.951% ( 2900, 4400 ] 91 0.028% 99.979% ( 4400, 6600 ] 91 0.028% 100.006% ( 6600, 9900 ] 51 0.015% 100.021% ( 9900, 14000 ] 29 0.009% 100.030% ( 14000, 22000 ] 12 0.004% 100.034% ( 22000, 33000 ] 3 0.001% 100.035% ** Level 4 read latency histogram (micros): Count: 225 Average: 257.7067 StdDev: 747.47 Min: 1 Median: 2.3500 Max: 6501 Percentiles: P50: 2.35 P75: 210.95 P99: 4212.50 P99.9: 6352.50 P99.99: 6501.00 ------------------------------------------------------ [ 0, 1 ] 35 15.556% 15.556% ### ( 1, 2 ] 67 29.778% 45.333% ###### ( 2, 3 ] 30 13.333% 58.667% ### ( 3, 4 ] 7 3.111% 61.778% # ( 4, 6 ] 9 4.000% 65.778% # ( 6, 10 ] 3 1.333% 67.111% ( 10, 15 ] 2 0.889% 68.000% ( 76, 110 ] 2 0.889% 68.889% ( 110, 170 ] 3 1.333% 70.222% ( 170, 250 ] 21 9.333% 79.556% ## ( 250, 380 ] 11 4.889% 84.444% # ( 380, 580 ] 11 4.889% 89.333% # ( 580, 870 ] 6 2.667% 92.000% # ( 870, 1300 ] 8 3.556% 95.556% # ( 1300, 1900 ] 2 0.889% 96.444% ( 1900, 2900 ] 4 1.778% 98.222% ( 2900, 4400 ] 2 0.889% 99.111% ( 4400, 6600 ] 2 0.889% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1151.5833 StdDev: 1231.34 Min: 82 Median: 609.0000 Max: 5635 Percentiles: P50: 609.00 P75: 1723.53 P99: 5635.00 P99.9: 5635.00 P99.99: 5635.00 ------------------------------------------------------ ( 76, 110 ] 14 7.778% 7.778% ## ( 110, 170 ] 15 8.333% 16.111% ## ( 170, 250 ] 12 6.667% 22.778% # ( 250, 380 ] 22 12.222% 35.000% ## ( 380, 580 ] 25 13.889% 48.889% ### ( 580, 870 ] 20 11.111% 60.000% ## ( 870, 1300 ] 15 8.333% 68.333% ## ( 1300, 1900 ] 17 9.444% 77.778% ## ( 1900, 2900 ] 19 10.556% 88.333% ## ( 2900, 4400 ] 16 8.889% 97.222% ## ( 4400, 6600 ] 5 2.778% 100.000% # ** DB Stats ** Uptime(secs): 34.9 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 225.51 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:12.890 H:M:S, 36.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.39 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.424 H:M:S, 13.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/07-07:30:03 ... thread 0: (1000000,9000000) ops and (327098.6,238503.5) ops/second in (3.057182,37.735289) 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/9 4.54 GB 207.7 8.5 0.0 8.5 17.0 8.5 0.0 2.0 144.1 287.9 60.33 54.94 151 0.400 8825K 14K 0.0 0.0 L1 16/16 961.18 MB 0.0 4.2 3.7 0.5 4.2 3.7 0.2 1.1 224.6 221.8 19.25 18.33 3 6.418 4391K 54K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.8 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 14/0 920.13 MB 0.9 2.0 1.0 1.0 2.0 1.0 2.0 2.0 144.4 143.9 14.47 10.69 11 1.315 2072K 6831 0.0 0.0 L4 168/0 9.64 GB 1.0 1.5 1.2 0.4 1.5 1.2 1.9 1.3 116.6 115.9 13.39 7.69 15 0.893 1586K 9919 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1293/25 104.54 GB 0.0 16.5 6.1 10.4 24.9 14.5 9.9 2.9 155.8 235.3 108.24 92.41 182 0.595 17M 85K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.5 6.1 10.4 24.9 14.5 9.8 2.9 155.8 235.3 108.24 92.41 182 0.595 17M 85K 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 16.5 6.1 10.4 16.4 6.0 0.0 0.0 205.5 204.4 82.06 70.15 58 1.415 17M 85K 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 332.0 26.18 22.26 124 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 38.0 total, 37.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: 24.87 GB write, 670.74 MB/s write, 16.47 GB read, 444.07 MB/s read, 108.2 seconds Interval compaction: 24.87 GB write, 674.90 MB/s write, 16.47 GB read, 446.82 MB/s read, 108.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 41, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 41, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3684154 Average: 2.4706 StdDev: 30.99 Min: 0 Median: 1.4952 Max: 12726 Percentiles: P50: 1.50 P75: 1.87 P99: 5.87 P99.9: 14.21 P99.99: 166.24 ------------------------------------------------------ [ 0, 1 ] 634671 17.227% 17.227% ### ( 1, 2 ] 2438147 66.179% 83.406% ############# ( 2, 3 ] 376170 10.210% 93.617% ## ( 3, 4 ] 127527 3.462% 97.078% # ( 4, 6 ] 75556 2.051% 99.129% ( 6, 10 ] 25517 0.693% 99.822% ( 10, 15 ] 3425 0.093% 99.915% ( 15, 22 ] 377 0.010% 99.925% ( 22, 34 ] 39 0.001% 99.926% ( 34, 51 ] 33 0.001% 99.927% ( 51, 76 ] 34 0.001% 99.928% ( 76, 110 ] 1075 0.029% 99.957% ( 110, 170 ] 1299 0.035% 99.992% ( 170, 250 ] 432 0.012% 100.004% ( 250, 380 ] 298 0.008% 100.012% ( 380, 580 ] 251 0.007% 100.019% ( 580, 870 ] 145 0.004% 100.023% ( 870, 1300 ] 79 0.002% 100.025% ( 1300, 1900 ] 25 0.001% 100.026% ( 1900, 2900 ] 28 0.001% 100.026% ( 2900, 4400 ] 29 0.001% 100.027% ( 4400, 6600 ] 20 0.001% 100.028% ( 6600, 9900 ] 22 0.001% 100.028% ( 9900, 14000 ] 6 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 642307 Average: 4.6332 StdDev: 70.51 Min: 1 Median: 1.7683 Max: 10951 Percentiles: P50: 1.77 P75: 2.61 P99: 8.71 P99.9: 15.59 P99.99: 167.11 ------------------------------------------------------ [ 0, 1 ] 41285 6.428% 6.428% # ( 1, 2 ] 364290 56.716% 63.143% ########### ( 2, 3 ] 124863 19.440% 82.583% #### ( 3, 4 ] 49349 7.683% 90.266% ## ( 4, 6 ] 48183 7.502% 97.768% ## ( 6, 10 ] 11672 1.817% 99.585% ( 10, 15 ] 2000 0.311% 99.896% ( 15, 22 ] 270 0.042% 99.939% ( 22, 34 ] 23 0.004% 99.942% ( 34, 51 ] 4 0.001% 99.943% ( 51, 76 ] 11 0.002% 99.944% ( 76, 110 ] 130 0.020% 99.965% ( 110, 170 ] 171 0.027% 99.991% ( 170, 250 ] 125 0.019% 100.011% ( 250, 380 ] 168 0.026% 100.037% ( 380, 580 ] 205 0.032% 100.069% ( 580, 870 ] 181 0.028% 100.097% ( 870, 1300 ] 137 0.021% 100.118% ( 1300, 1900 ] 83 0.013% 100.131% ( 1900, 2900 ] 64 0.010% 100.141% ( 2900, 4400 ] 82 0.013% 100.154% ( 4400, 6600 ] 31 0.005% 100.159% ( 6600, 9900 ] 5 0.001% 100.160% ( 9900, 14000 ] 1 0.000% 100.160% ** Level 2 read latency histogram (micros): Count: 77125 Average: 2.9757 StdDev: 26.30 Min: 1 Median: 1.6018 Max: 4621 Percentiles: P50: 1.60 P75: 1.97 P99: 7.87 P99.9: 163.55 P99.99: 852.78 ------------------------------------------------------ [ 0, 1 ] 7442 9.649% 9.649% ## ( 1, 2 ] 51714 67.052% 76.701% ############# ( 2, 3 ] 10487 13.597% 90.299% ### ( 3, 4 ] 3704 4.803% 95.101% # ( 4, 6 ] 2567 3.328% 98.430% # ( 6, 10 ] 941 1.220% 99.650% ( 10, 15 ] 104 0.135% 99.785% ( 15, 22 ] 10 0.013% 99.798% ( 34, 51 ] 1 0.001% 99.799% ( 51, 76 ] 2 0.003% 99.802% ( 76, 110 ] 25 0.032% 99.834% ( 110, 170 ] 57 0.074% 99.908% ( 170, 250 ] 23 0.030% 99.938% ( 250, 380 ] 15 0.019% 99.957% ( 380, 580 ] 14 0.018% 99.975% ( 580, 870 ] 12 0.016% 99.991% ( 870, 1300 ] 6 0.008% 99.999% ( 1900, 2900 ] 2 0.003% 100.001% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 330641 Average: 12.4911 StdDev: 229.22 Min: 0 Median: 1.7412 Max: 32533 Percentiles: P50: 1.74 P75: 2.50 P99: 14.86 P99.9: 1352.79 P99.99: 5317.13 ------------------------------------------------------ [ 0, 1 ] 19056 5.763% 5.763% # ( 1, 2 ] 197333 59.682% 65.445% ############ ( 2, 3 ] 62569 18.924% 84.369% #### ( 3, 4 ] 23248 7.031% 91.400% # ( 4, 6 ] 17576 5.316% 96.716% # ( 6, 10 ] 6652 2.012% 98.728% ( 10, 15 ] 926 0.280% 99.008% ( 15, 22 ] 127 0.038% 99.046% ( 22, 34 ] 18 0.005% 99.052% ( 34, 51 ] 22 0.007% 99.058% ( 51, 76 ] 28 0.008% 99.067% ( 76, 110 ] 196 0.059% 99.126% ( 110, 170 ] 477 0.144% 99.270% ( 170, 250 ] 373 0.113% 99.383% ( 250, 380 ] 450 0.136% 99.519% ( 380, 580 ] 583 0.176% 99.695% ( 580, 870 ] 441 0.133% 99.829% ( 870, 1300 ] 227 0.069% 99.897% ( 1300, 1900 ] 95 0.029% 99.926% ( 1900, 2900 ] 82 0.025% 99.951% ( 2900, 4400 ] 91 0.028% 99.979% ( 4400, 6600 ] 91 0.028% 100.006% ( 6600, 9900 ] 51 0.015% 100.021% ( 9900, 14000 ] 29 0.009% 100.030% ( 14000, 22000 ] 12 0.004% 100.034% ( 22000, 33000 ] 3 0.001% 100.035% ** Level 4 read latency histogram (micros): Count: 225 Average: 257.7067 StdDev: 747.47 Min: 1 Median: 2.3500 Max: 6501 Percentiles: P50: 2.35 P75: 210.95 P99: 4212.50 P99.9: 6352.50 P99.99: 6501.00 ------------------------------------------------------ [ 0, 1 ] 35 15.556% 15.556% ### ( 1, 2 ] 67 29.778% 45.333% ###### ( 2, 3 ] 30 13.333% 58.667% ### ( 3, 4 ] 7 3.111% 61.778% # ( 4, 6 ] 9 4.000% 65.778% # ( 6, 10 ] 3 1.333% 67.111% ( 10, 15 ] 2 0.889% 68.000% ( 76, 110 ] 2 0.889% 68.889% ( 110, 170 ] 3 1.333% 70.222% ( 170, 250 ] 21 9.333% 79.556% ## ( 250, 380 ] 11 4.889% 84.444% # ( 380, 580 ] 11 4.889% 89.333% # ( 580, 870 ] 6 2.667% 92.000% # ( 870, 1300 ] 8 3.556% 95.556% # ( 1300, 1900 ] 2 0.889% 96.444% ( 1900, 2900 ] 4 1.778% 98.222% ( 2900, 4400 ] 2 0.889% 99.111% ( 4400, 6600 ] 2 0.889% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1151.5833 StdDev: 1231.34 Min: 82 Median: 609.0000 Max: 5635 Percentiles: P50: 609.00 P75: 1723.53 P99: 5635.00 P99.9: 5635.00 P99.99: 5635.00 ------------------------------------------------------ ( 76, 110 ] 14 7.778% 7.778% ## ( 110, 170 ] 15 8.333% 16.111% ## ( 170, 250 ] 12 6.667% 22.778% # ( 250, 380 ] 22 12.222% 35.000% ## ( 380, 580 ] 25 13.889% 48.889% ### ( 580, 870 ] 20 11.111% 60.000% ## ( 870, 1300 ] 15 8.333% 68.333% ## ( 1300, 1900 ] 17 9.444% 77.778% ## ( 1900, 2900 ] 19 10.556% 88.333% ## ( 2900, 4400 ] 16 8.889% 97.222% ## ( 4400, 6600 ] 5 2.778% 100.000% # ** DB Stats ** Uptime(secs): 38.0 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 233.28 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:13.293 H:M:S, 35.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.96 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.403 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-07:30:16 ... thread 0: (1000000,10000000) ops and (79673.9,198860.7) ops/second in (12.551157,50.286446) 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/12 3.31 GB 25.2 10.5 0.0 10.5 20.0 9.5 0.0 2.1 148.0 281.9 72.77 65.68 170 0.428 10M 21K 0.0 0.0 L1 11/11 1.07 GB 0.0 7.4 6.0 1.4 7.3 5.9 0.2 1.2 222.7 219.9 34.16 32.28 4 8.541 6749K 54K 0.0 0.0 L2 1/0 96.73 MB 1.0 0.2 0.1 0.1 0.2 0.1 4.9 1.5 244.0 243.9 0.79 0.76 2 0.394 195K 83 0.0 0.0 L3 18/2 1.13 GB 0.9 3.1 1.5 1.7 3.1 1.5 3.6 2.1 140.6 139.6 22.91 15.94 16 1.432 3221K 22K 0.0 0.0 L4 169/13 10.08 GB 1.0 4.0 2.9 1.1 4.0 2.9 1.9 1.4 127.8 127.0 32.10 19.68 36 0.892 4165K 24K 0.0 0.0 L5 1092/0 89.81 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/38 105.51 GB 0.0 25.3 10.6 14.7 34.7 19.9 14.8 3.6 159.1 218.1 162.74 134.34 228 0.714 25M 122K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.3 10.6 14.7 34.7 19.9 14.7 3.6 159.1 218.1 162.74 134.34 228 0.714 25M 122K 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 25.3 10.6 14.7 25.1 10.4 0.0 0.0 194.6 193.3 133.09 109.29 89 1.495 25M 122K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 329.3 29.65 25.05 139 0.213 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): 50.5 total, 50.3 interval Flush(GB): cumulative 9.536, interval 9.536 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: 34.66 GB write, 702.53 MB/s write, 25.29 GB read, 512.52 MB/s read, 162.7 seconds Interval compaction: 34.66 GB write, 705.80 MB/s write, 25.29 GB read, 514.90 MB/s read, 162.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 44, pending-compaction-bytes-delays: 33, pending-compaction-bytes-stops: 0, total-delays: 57, total-stops: 44, interval: 101 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4555525 Average: 2.7477 StdDev: 31.77 Min: 0 Median: 1.5140 Max: 12726 Percentiles: P50: 1.51 P75: 1.90 P99: 6.65 P99.9: 124.48 P99.99: 319.63 ------------------------------------------------------ [ 0, 1 ] 746956 16.397% 16.397% ### ( 1, 2 ] 2978127 65.374% 81.771% ############# ( 2, 3 ] 495193 10.870% 92.641% ## ( 3, 4 ] 171120 3.756% 96.397% # ( 4, 6 ] 112517 2.470% 98.867% ( 6, 10 ] 37458 0.822% 99.689% ( 10, 15 ] 4762 0.105% 99.794% ( 15, 22 ] 549 0.012% 99.806% ( 22, 34 ] 53 0.001% 99.807% ( 34, 51 ] 37 0.001% 99.808% ( 51, 76 ] 72 0.002% 99.809% ( 76, 110 ] 3242 0.071% 99.881% ( 110, 170 ] 3665 0.080% 99.961% ( 170, 250 ] 967 0.021% 99.982% ( 250, 380 ] 658 0.014% 99.997% ( 380, 580 ] 595 0.013% 100.010% ( 580, 870 ] 360 0.008% 100.018% ( 870, 1300 ] 182 0.004% 100.022% ( 1300, 1900 ] 67 0.001% 100.023% ( 1900, 2900 ] 48 0.001% 100.024% ( 2900, 4400 ] 50 0.001% 100.025% ( 4400, 6600 ] 23 0.001% 100.026% ( 6600, 9900 ] 23 0.001% 100.026% ( 9900, 14000 ] 6 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1376969 Average: 4.8433 StdDev: 69.17 Min: 1 Median: 1.7975 Max: 10951 Percentiles: P50: 1.80 P75: 2.70 P99: 9.15 P99.9: 94.08 P99.99: 160.66 ------------------------------------------------------ [ 0, 1 ] 84035 6.103% 6.103% # ( 1, 2 ] 757967 55.046% 61.149% ########### ( 2, 3 ] 270693 19.659% 80.808% #### ( 3, 4 ] 111420 8.092% 88.899% ## ( 4, 6 ] 114563 8.320% 97.219% ## ( 6, 10 ] 31168 2.264% 99.483% ( 10, 15 ] 4540 0.330% 99.812% ( 15, 22 ] 666 0.048% 99.861% ( 22, 34 ] 39 0.003% 99.864% ( 34, 51 ] 14 0.001% 99.865% ( 51, 76 ] 69 0.005% 99.870% ( 76, 110 ] 786 0.057% 99.927% ( 110, 170 ] 1032 0.075% 100.002% ( 170, 250 ] 429 0.031% 100.033% ( 250, 380 ] 500 0.036% 100.069% ( 380, 580 ] 508 0.037% 100.106% ( 580, 870 ] 410 0.030% 100.136% ( 870, 1300 ] 280 0.020% 100.156% ( 1300, 1900 ] 165 0.012% 100.168% ( 1900, 2900 ] 138 0.010% 100.178% ( 2900, 4400 ] 185 0.013% 100.192% ( 4400, 6600 ] 54 0.004% 100.196% ( 6600, 9900 ] 15 0.001% 100.197% ( 9900, 14000 ] 1 0.000% 100.197% ** Level 2 read latency histogram (micros): Count: 77125 Average: 2.9757 StdDev: 26.30 Min: 1 Median: 1.6018 Max: 4621 Percentiles: P50: 1.60 P75: 1.97 P99: 7.87 P99.9: 163.55 P99.99: 852.78 ------------------------------------------------------ [ 0, 1 ] 7442 9.649% 9.649% ## ( 1, 2 ] 51714 67.052% 76.701% ############# ( 2, 3 ] 10487 13.597% 90.299% ### ( 3, 4 ] 3704 4.803% 95.101% # ( 4, 6 ] 2567 3.328% 98.430% # ( 6, 10 ] 941 1.220% 99.650% ( 10, 15 ] 104 0.135% 99.785% ( 15, 22 ] 10 0.013% 99.798% ( 34, 51 ] 1 0.001% 99.799% ( 51, 76 ] 2 0.003% 99.802% ( 76, 110 ] 25 0.032% 99.834% ( 110, 170 ] 57 0.074% 99.908% ( 170, 250 ] 23 0.030% 99.938% ( 250, 380 ] 15 0.019% 99.957% ( 380, 580 ] 14 0.018% 99.975% ( 580, 870 ] 12 0.016% 99.991% ( 870, 1300 ] 6 0.008% 99.999% ( 1900, 2900 ] 2 0.003% 100.001% ( 4400, 6600 ] 1 0.001% 100.003% ** Level 3 read latency histogram (micros): Count: 727804 Average: 9.3492 StdDev: 166.84 Min: 0 Median: 1.8810 Max: 32533 Percentiles: P50: 1.88 P75: 2.87 P99: 9.78 P99.9: 712.46 P99.99: 1070.45 ------------------------------------------------------ [ 0, 1 ] 24770 3.403% 3.403% # ( 1, 2 ] 384929 52.889% 56.292% ########### ( 2, 3 ] 156675 21.527% 77.820% #### ( 3, 4 ] 71730 9.856% 87.675% ## ( 4, 6 ] 67773 9.312% 96.987% ## ( 6, 10 ] 15488 2.128% 99.115% ( 10, 15 ] 2054 0.282% 99.398% ( 15, 22 ] 276 0.038% 99.435% ( 22, 34 ] 32 0.004% 99.440% ( 34, 51 ] 24 0.003% 99.443% ( 51, 76 ] 51 0.007% 99.450% ( 76, 110 ] 222 0.031% 99.481% ( 110, 170 ] 582 0.080% 99.561% ( 170, 250 ] 521 0.072% 99.632% ( 250, 380 ] 673 0.092% 99.725% ( 380, 580 ] 914 0.126% 99.850% ( 580, 870 ] 793 0.109% 99.959% ( 870, 1300 ] 481 0.066% 100.025% ( 1300, 1900 ] 201 0.028% 100.053% ( 1900, 2900 ] 136 0.019% 100.072% ( 2900, 4400 ] 159 0.022% 100.093% ( 4400, 6600 ] 112 0.015% 100.109% ( 6600, 9900 ] 57 0.008% 100.117% ( 9900, 14000 ] 29 0.004% 100.121% ( 14000, 22000 ] 12 0.002% 100.122% ( 22000, 33000 ] 3 0.000% 100.123% ** Level 4 read latency histogram (micros): Count: 219509 Average: 9.7228 StdDev: 119.81 Min: 1 Median: 1.9868 Max: 7669 Percentiles: P50: 1.99 P75: 3.05 P99: 13.02 P99.9: 1009.41 P99.99: 1788.39 ------------------------------------------------------ [ 0, 1 ] 3872 1.764% 1.764% ( 1, 2 ] 107298 48.881% 50.645% ########## ( 2, 3 ] 52329 23.839% 74.484% ##### ( 3, 4 ] 22975 10.467% 84.951% ## ( 4, 6 ] 24505 11.164% 96.114% ## ( 6, 10 ] 5812 2.648% 98.762% # ( 10, 15 ] 866 0.395% 99.156% ( 15, 22 ] 71 0.032% 99.189% ( 22, 34 ] 15 0.007% 99.195% ( 34, 51 ] 4 0.002% 99.197% ( 51, 76 ] 21 0.010% 99.207% ( 76, 110 ] 116 0.053% 99.260% ( 110, 170 ] 207 0.094% 99.354% ( 170, 250 ] 260 0.118% 99.472% ( 250, 380 ] 276 0.126% 99.598% ( 380, 580 ] 315 0.144% 99.742% ( 580, 870 ] 282 0.128% 99.870% ( 870, 1300 ] 202 0.092% 99.962% ( 1300, 1900 ] 75 0.034% 99.996% ( 1900, 2900 ] 60 0.027% 100.024% ( 2900, 4400 ] 83 0.038% 100.062% ( 4400, 6600 ] 24 0.011% 100.072% ( 6600, 9900 ] 7 0.003% 100.076% ** Level 5 read latency histogram (micros): Count: 260 Average: 1089.8769 StdDev: 1188.36 Min: 82 Median: 556.4706 Max: 5635 Percentiles: P50: 556.47 P75: 1613.04 P99: 5456.00 P99.9: 5635.00 P99.99: 5635.00 ------------------------------------------------------ ( 76, 110 ] 19 7.308% 7.308% # ( 110, 170 ] 25 9.615% 16.923% ## ( 170, 250 ] 22 8.462% 25.385% ## ( 250, 380 ] 34 13.077% 38.462% ### ( 380, 580 ] 34 13.077% 51.538% ### ( 580, 870 ] 27 10.385% 61.923% ## ( 870, 1300 ] 22 8.462% 70.385% ## ( 1300, 1900 ] 23 8.846% 79.231% ## ( 1900, 2900 ] 24 9.231% 88.462% ## ( 2900, 4400 ] 25 9.615% 98.077% ## ( 4400, 6600 ] 5 1.923% 100.000% ** DB Stats ** Uptime(secs): 50.5 total, 12.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 194.80 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:22.708 H:M:S, 44.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 78.41 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:9.415 H:M:S, 75.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.523 micros/op 181070 ops/sec 60.054 seconds 10873999 operations; 175.4 MB/s Microseconds per write: Count: 10873999 Average: 5.5227 StdDev: 372.39 Min: 0 Median: 1.7434 Max: 816353 Percentiles: P50: 1.74 P75: 2.76 P99: 9.70 P99.9: 1107.66 P99.99: 2504.82 ------------------------------------------------------ [ 0, 1 ] 1421690 13.074% 13.074% ### ( 1, 2 ] 5401495 49.673% 62.748% ########## ( 2, 3 ] 1755362 16.143% 78.890% ### ( 3, 4 ] 1476575 13.579% 92.469% ### ( 4, 6 ] 571766 5.258% 97.728% # ( 6, 10 ] 149589 1.376% 99.103% ( 10, 15 ] 51427 0.473% 99.576% ( 15, 22 ] 11449 0.105% 99.681% ( 22, 34 ] 2004 0.018% 99.700% ( 34, 51 ] 312 0.003% 99.703% ( 51, 76 ] 41 0.000% 99.703% ( 76, 110 ] 7348 0.068% 99.771% ( 110, 170 ] 3112 0.029% 99.799% ( 170, 250 ] 357 0.003% 99.803% ( 250, 380 ] 240 0.002% 99.805% ( 380, 580 ] 23 0.000% 99.805% ( 580, 870 ] 18 0.000% 99.805% ( 870, 1300 ] 18667 0.172% 99.977% ( 1300, 1900 ] 80 0.001% 99.978% ( 1900, 2900 ] 2243 0.021% 99.998% ( 2900, 4400 ] 136 0.001% 99.999% ( 4400, 6600 ] 31 0.000% 100.000% ( 6600, 9900 ] 10 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 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 : 214503 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 : 10873999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11221966968 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 : 573 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 29773711 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 : 32177386765 rocksdb.compact.write.bytes COUNT : 31968895097 rocksdb.flush.write.bytes COUNT : 11163739955 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 : 67 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 : 282 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 : 11073698816 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4281344 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 : 32283597815 rocksdb.non.last.level.read.count COUNT : 7798085 rocksdb.block.checksum.compute.count COUNT : 7797006 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.393617 P95 : 3.937333 P99 : 8.360110 P100 : 816351.000000 COUNT : 10873999 SUM : 54860241 rocksdb.compaction.times.micros P50 : 1057045.454545 P95 : 3687500.000000 P99 : 15048612.000000 P100 : 15048612.000000 COUNT : 95 SUM : 141160895 rocksdb.compaction.times.cpu_micros P50 : 899230.769231 P95 : 3687500.000000 P99 : 14235354.000000 P100 : 14235354.000000 COUNT : 95 SUM : 116834203 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 : 689.521277 P95 : 1182.576923 P99 : 17920.000000 P100 : 66033.000000 COUNT : 151 SUM : 203733 rocksdb.compaction.outfile.sync.micros P50 : 978.827160 P95 : 160812.500000 P99 : 235653.333333 P100 : 444464.000000 COUNT : 369 SUM : 8988448 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 : 106.465347 P95 : 1020.500000 P99 : 3445.000000 P100 : 4521.000000 COUNT : 291 SUM : 79005 rocksdb.table.open.io.micros P50 : 1314.851485 P95 : 7008.157895 P99 : 12237.000000 P100 : 14102.000000 COUNT : 573 SUM : 1174951 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.643141 P95 : 7.627035 P99 : 10.532970 P100 : 32536.000000 COUNT : 7795393 SUM : 46485693 rocksdb.read.block.get.micros P50 : 463.333333 P95 : 3311.000000 P99 : 5504.631579 P100 : 10441.000000 COUNT : 1146 SUM : 955154 rocksdb.write.raw.block.micros P50 : 0.514080 P95 : 0.976752 P99 : 3.156756 P100 : 137911.000000 COUNT : 10446393 SUM : 22168132 rocksdb.numfiles.in.singlecompaction P50 : 3.176136 P95 : 5.780000 P99 : 18.010000 P100 : 21.000000 COUNT : 171 SUM : 609 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.558429 P95 : 1122.713700 P99 : 2062.305282 P100 : 816162.000000 COUNT : 203141 SUM : 29795926 rocksdb.sst.read.micros P50 : 1.588242 P95 : 4.499178 P99 : 8.299909 P100 : 32533.000000 COUNT : 7798293 SUM : 30528015 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 : 10873999 SUM : 11221966968 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 : 212123.893805 P95 : 354361.111111 P99 : 943300.000000 P100 : 958958.000000 COUNT : 151 SUM : 32156060 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 : 366 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