[2024-12-13 21:31:45.907364] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-13 21:31:45.907463] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid958478 ] Set seed to 1734121905904959 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-13 21:31:46.004439] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-13 21:31:46.040787] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-13 21:31:46.040829] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 958478' to capture a snapshot of events at runtime. [2024-12-13 21:31:46.040841] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid958478 for offline analysis/debug. [2024-12-13 21:31:46.040864] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 13 21:31:50 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/13-21:31:53 ... thread 0: (1000000,1000000) ops and (352855.7,352855.7) ops/second in (2.834020,2.834020) 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 9/6 567.04 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 345.5 2.37 2.14 12 0.198 0 0 0.0 0.0 L2 3/2 251.72 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 11/0 993.45 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1036/0 85.51 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1175/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.5 96.7 306.3 3.91 3.63 14 0.279 383K 205 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 96.7 306.3 3.91 3.63 14 0.279 383K 205 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.2 0.2 0.4 0.2 0.0 0.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 345.5 2.37 2.14 12 0.198 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.1 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 390.08 MB/s write, 0.37 GB read, 123.19 MB/s read, 3.9 seconds Interval compaction: 1.17 GB write, 421.87 MB/s write, 0.37 GB read, 133.22 MB/s read, 3.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 99502 Average: 1.9118 StdDev: 20.47 Min: 1 Median: 1.2061 Max: 3108 Percentiles: P50: 1.21 P75: 1.65 P99: 3.85 P99.9: 9.14 P99.99: 349.12 ------------------------------------------------------ [ 0, 1 ] 38184 38.375% 38.375% ######## ( 1, 2 ] 56129 56.410% 94.785% ########### ( 2, 3 ] 3076 3.091% 97.876% # ( 3, 4 ] 1314 1.321% 99.197% ( 4, 6 ] 567 0.570% 99.767% ( 6, 10 ] 170 0.171% 99.938% ( 10, 15 ] 27 0.027% 99.965% ( 15, 22 ] 10 0.010% 99.975% ( 34, 51 ] 2 0.002% 99.977% ( 110, 170 ] 9 0.009% 99.986% ( 170, 250 ] 2 0.002% 99.988% ( 250, 380 ] 4 0.004% 99.992% ( 380, 580 ] 1 0.001% 99.993% ( 580, 870 ] 1 0.001% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1900, 2900 ] 4 0.004% 99.999% ( 2900, 4400 ] 2 0.002% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 1037.6000 StdDev: 886.88 Min: 64 Median: 977.5000 Max: 2549 Percentiles: P50: 977.50 P75: 1246.25 P99: 2549.00 P99.9: 2549.00 P99.99: 2549.00 ------------------------------------------------------ ( 51, 76 ] 1 20.000% 20.000% #### ( 170, 250 ] 1 20.000% 40.000% #### ( 870, 1300 ] 2 40.000% 80.000% ######## ( 1900, 2900 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 50199 Average: 1.9867 StdDev: 21.66 Min: 0 Median: 1.2334 Max: 3137 Percentiles: P50: 1.23 P75: 1.67 P99: 4.39 P99.9: 9.39 P99.99: 722.11 ------------------------------------------------------ [ 0, 1 ] 18364 36.582% 36.582% ####### ( 1, 2 ] 28854 57.479% 94.062% ########### ( 2, 3 ] 1640 3.267% 97.329% # ( 3, 4 ] 760 1.514% 98.843% ( 4, 6 ] 407 0.811% 99.653% ( 6, 10 ] 146 0.291% 99.944% ( 10, 15 ] 11 0.022% 99.966% ( 15, 22 ] 5 0.010% 99.976% ( 34, 51 ] 1 0.002% 99.978% ( 170, 250 ] 1 0.002% 99.980% ( 250, 380 ] 3 0.006% 99.986% ( 380, 580 ] 1 0.002% 99.988% ( 580, 870 ] 2 0.004% 99.992% ( 1300, 1900 ] 2 0.004% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 45 Average: 1865.6889 StdDev: 1677.89 Min: 129 Median: 1049.1667 Max: 5532 Percentiles: P50: 1049.17 P75: 3358.33 P99: 5532.00 P99.9: 5532.00 P99.99: 5532.00 ------------------------------------------------------ ( 110, 170 ] 1 2.222% 2.222% ( 170, 250 ] 2 4.444% 6.667% # ( 250, 380 ] 3 6.667% 13.333% # ( 380, 580 ] 10 22.222% 35.556% #### ( 580, 870 ] 4 8.889% 44.444% ## ( 870, 1300 ] 6 13.333% 57.778% ### ( 1300, 1900 ] 2 4.444% 62.222% # ( 1900, 2900 ] 3 6.667% 68.889% # ( 2900, 4400 ] 9 20.000% 88.889% #### ( 4400, 6600 ] 5 11.111% 100.000% ## ** Level 4 read latency histogram (micros): Count: 25 Average: 1594.7600 StdDev: 1130.67 Min: 127 Median: 1600.0000 Max: 4188 Percentiles: P50: 1600.00 P75: 2493.75 P99: 4188.00 P99.9: 4188.00 P99.99: 4188.00 ------------------------------------------------------ ( 110, 170 ] 3 12.000% 12.000% ## ( 170, 250 ] 1 4.000% 16.000% # ( 380, 580 ] 2 8.000% 24.000% ## ( 580, 870 ] 4 16.000% 40.000% ### ( 870, 1300 ] 1 4.000% 44.000% # ( 1300, 1900 ] 3 12.000% 56.000% ## ( 1900, 2900 ] 8 32.000% 88.000% ###### ( 2900, 4400 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.1 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 320.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:0.247 H:M:S, 8.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 346.91 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.247 H:M:S, 8.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-21:31:56 ... thread 0: (1000000,2000000) ops and (324954.2,338330.6) ops/second in (3.077357,5.911377) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.17 GB 62.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 76.3 321.9 7.44 6.85 28 0.266 575K 579 0.0 0.0 L1 1/0 3.81 MB 0.4 0.4 0.4 0.0 0.4 0.4 0.2 1.0 232.1 231.8 1.63 1.58 1 1.628 383K 568 0.0 0.0 L2 2/1 52.65 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 17/7 964.37 MB 0.3 0.2 0.2 0.0 0.2 0.2 0.5 1.0 231.6 231.6 1.08 1.00 1 1.076 253K 0 0.0 0.0 L4 169/0 9.57 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 148.5 148.5 1.51 1.12 1 1.508 227K 0 0.0 0.0 L5 1044/0 86.18 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 1244/16 97.92 GB 0.0 1.8 1.0 0.7 3.5 2.8 2.3 2.0 136.2 274.7 13.18 12.03 33 0.400 1823K 1352 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.5 2.8 2.2 2.0 136.2 274.7 13.18 12.03 33 0.400 1823K 1352 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.8 1.0 0.7 1.8 1.0 0.0 0.0 225.9 225.7 7.95 7.34 7 1.136 1823K 1352 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 349.1 5.23 4.69 26 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.54 GB write, 589.34 MB/s write, 1.75 GB read, 292.26 MB/s read, 13.2 seconds Interval compaction: 3.54 GB write, 612.37 MB/s write, 1.75 GB read, 303.69 MB/s read, 13.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 390153 Average: 2.1877 StdDev: 16.04 Min: 0 Median: 1.4526 Max: 4312 Percentiles: P50: 1.45 P75: 1.85 P99: 5.63 P99.9: 9.56 P99.99: 14.31 ------------------------------------------------------ [ 0, 1 ] 83718 21.458% 21.458% #### ( 1, 2 ] 246049 63.065% 84.522% ############# ( 2, 3 ] 32322 8.284% 92.807% ## ( 3, 4 ] 15330 3.929% 96.736% # ( 4, 6 ] 10857 2.783% 99.519% # ( 6, 10 ] 1669 0.428% 99.947% ( 10, 15 ] 196 0.050% 99.997% ( 15, 22 ] 25 0.006% 100.003% ( 22, 34 ] 4 0.001% 100.004% ( 34, 51 ] 4 0.001% 100.005% ( 51, 76 ] 3 0.001% 100.006% ( 110, 170 ] 10 0.003% 100.009% ( 170, 250 ] 14 0.004% 100.012% ( 250, 380 ] 11 0.003% 100.015% ( 380, 580 ] 2 0.001% 100.016% ( 580, 870 ] 3 0.001% 100.016% ( 870, 1300 ] 3 0.001% 100.017% ( 1300, 1900 ] 2 0.001% 100.018% ( 1900, 2900 ] 7 0.002% 100.019% ( 2900, 4400 ] 4 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 30 Average: 303.8333 StdDev: 554.34 Min: 1 Median: 3.0000 Max: 2549 Percentiles: P50: 3.00 P75: 347.50 P99: 2549.00 P99.9: 2549.00 P99.99: 2549.00 ------------------------------------------------------ [ 0, 1 ] 9 30.000% 30.000% ###### ( 1, 2 ] 5 16.667% 46.667% ### ( 2, 3 ] 1 3.333% 50.000% # ( 3, 4 ] 1 3.333% 53.333% # ( 4, 6 ] 1 3.333% 56.667% # ( 51, 76 ] 1 3.333% 60.000% # ( 110, 170 ] 1 3.333% 63.333% # ( 170, 250 ] 2 6.667% 70.000% # ( 250, 380 ] 2 6.667% 76.667% # ( 380, 580 ] 1 3.333% 80.000% # ( 580, 870 ] 2 6.667% 86.667% # ( 870, 1300 ] 3 10.000% 96.667% ## ( 1900, 2900 ] 1 3.333% 100.000% # ** Level 2 read latency histogram (micros): Count: 96039 Average: 2.2120 StdDev: 16.92 Min: 0 Median: 1.3729 Max: 3137 Percentiles: P50: 1.37 P75: 1.78 P99: 5.53 P99.9: 13.19 P99.99: 514.90 ------------------------------------------------------ [ 0, 1 ] 26206 27.287% 27.287% ##### ( 1, 2 ] 58499 60.912% 88.199% ############ ( 2, 3 ] 5988 6.235% 94.434% # ( 3, 4 ] 2967 3.089% 97.523% # ( 4, 6 ] 1851 1.927% 99.450% ( 6, 10 ] 410 0.427% 99.877% ( 10, 15 ] 36 0.037% 99.915% ( 15, 22 ] 7 0.007% 99.922% ( 34, 51 ] 1 0.001% 99.923% ( 110, 170 ] 38 0.040% 99.963% ( 170, 250 ] 11 0.011% 99.974% ( 250, 380 ] 11 0.011% 99.985% ( 380, 580 ] 8 0.008% 99.994% ( 580, 870 ] 3 0.003% 99.997% ( 1300, 1900 ] 2 0.002% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 3 read latency histogram (micros): Count: 168768 Average: 3.4675 StdDev: 43.35 Min: 1 Median: 1.6740 Max: 5532 Percentiles: P50: 1.67 P75: 2.28 P99: 8.94 P99.9: 161.34 P99.99: 543.36 ------------------------------------------------------ [ 0, 1 ] 13911 8.243% 8.243% ## ( 1, 2 ] 104553 61.951% 70.193% ############ ( 2, 3 ] 29378 17.407% 87.601% ### ( 3, 4 ] 9192 5.447% 93.047% # ( 4, 6 ] 8101 4.800% 97.847% # ( 6, 10 ] 2644 1.567% 99.414% ( 10, 15 ] 526 0.312% 99.726% ( 15, 22 ] 85 0.050% 99.776% ( 22, 34 ] 20 0.012% 99.788% ( 34, 51 ] 4 0.002% 99.790% ( 51, 76 ] 7 0.004% 99.794% ( 76, 110 ] 67 0.040% 99.834% ( 110, 170 ] 130 0.077% 99.911% ( 170, 250 ] 53 0.031% 99.943% ( 250, 380 ] 45 0.027% 99.969% ( 380, 580 ] 43 0.025% 99.995% ( 580, 870 ] 19 0.011% 100.006% ( 870, 1300 ] 9 0.005% 100.011% ( 1300, 1900 ] 5 0.003% 100.014% ( 1900, 2900 ] 3 0.002% 100.016% ( 2900, 4400 ] 9 0.005% 100.021% ( 4400, 6600 ] 5 0.003% 100.024% ** Level 4 read latency histogram (micros): Count: 310 Average: 136.6161 StdDev: 539.20 Min: 0 Median: 2.2632 Max: 4188 Percentiles: P50: 2.26 P75: 7.27 P99: 2887.50 P99.9: 4188.00 P99.99: 4188.00 ------------------------------------------------------ [ 0, 1 ] 62 20.000% 20.000% #### ( 1, 2 ] 78 25.161% 45.161% ##### ( 2, 3 ] 57 18.387% 63.548% #### ( 3, 4 ] 18 5.806% 69.355% # ( 4, 6 ] 14 4.516% 73.871% # ( 6, 10 ] 11 3.548% 77.419% # ( 10, 15 ] 19 6.129% 83.548% # ( 15, 22 ] 15 4.839% 88.387% # ( 22, 34 ] 6 1.935% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 4 1.290% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 1 0.323% 92.903% ( 380, 580 ] 3 0.968% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 1 0.323% 95.484% ( 1300, 1900 ] 3 0.968% 96.452% ( 1900, 2900 ] 8 2.581% 99.032% # ( 2900, 4400 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 705.7250 StdDev: 696.91 Min: 98 Median: 430.0000 Max: 2681 Percentiles: P50: 430.00 P75: 1013.33 P99: 2681.00 P99.9: 2681.00 P99.99: 2681.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 6 15.000% 25.000% ### ( 170, 250 ] 5 12.500% 37.500% ### ( 250, 380 ] 4 10.000% 47.500% ## ( 380, 580 ] 4 10.000% 57.500% ## ( 580, 870 ] 6 15.000% 72.500% ### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 320.31 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.655 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.81 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.408 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-21:31:59 ... thread 0: (1000000,3000000) ops and (329489.7,335331.4) ops/second in (3.034996,8.946373) 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/11 2.09 GB 44.1 1.4 0.0 1.4 4.1 2.7 0.0 1.5 104.4 313.0 13.28 12.35 44 0.302 1407K 1476 0.0 0.0 L1 1/1 3.81 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 232.1 231.8 1.63 1.58 1 1.628 383K 568 0.0 0.0 L2 1/0 50.18 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 15/0 965.29 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.5 3.4 225.0 224.6 3.85 3.62 2 1.927 880K 1567 0.0 0.0 L4 169/0 9.57 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 148.5 148.5 1.51 1.12 1 1.508 227K 0 0.0 0.0 L5 1044/0 86.18 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 1245/12 98.84 GB 0.0 3.2 1.0 2.1 5.9 3.7 2.3 2.2 148.3 275.2 21.81 20.15 50 0.436 3282K 3816 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 1.0 2.1 5.9 3.7 2.2 2.2 148.3 275.2 21.81 20.15 50 0.436 3282K 3816 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.2 1.0 2.1 3.2 1.0 0.0 0.0 233.6 233.4 13.84 13.01 11 1.258 3282K 3816 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 347.9 7.97 7.13 39 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.86 GB write, 653.69 MB/s write, 3.16 GB read, 352.17 MB/s read, 21.8 seconds Interval compaction: 5.86 GB write, 670.57 MB/s write, 3.16 GB read, 361.27 MB/s read, 21.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 700170 Average: 2.1351 StdDev: 13.48 Min: 0 Median: 1.4459 Max: 4312 Percentiles: P50: 1.45 P75: 1.83 P99: 5.50 P99.9: 9.48 P99.99: 14.10 ------------------------------------------------------ [ 0, 1 ] 146996 20.994% 20.994% #### ( 1, 2 ] 455420 65.044% 86.039% ############# ( 2, 3 ] 54653 7.806% 93.844% ## ( 3, 4 ] 24201 3.456% 97.301% # ( 4, 6 ] 15817 2.259% 99.560% ( 6, 10 ] 2742 0.392% 99.951% ( 10, 15 ] 333 0.048% 99.999% ( 15, 22 ] 33 0.005% 100.004% ( 22, 34 ] 9 0.001% 100.005% ( 34, 51 ] 6 0.001% 100.006% ( 51, 76 ] 4 0.001% 100.006% ( 110, 170 ] 15 0.002% 100.008% ( 170, 250 ] 21 0.003% 100.011% ( 250, 380 ] 14 0.002% 100.013% ( 380, 580 ] 6 0.001% 100.014% ( 580, 870 ] 8 0.001% 100.015% ( 870, 1300 ] 7 0.001% 100.016% ( 1300, 1900 ] 4 0.001% 100.017% ( 1900, 2900 ] 8 0.001% 100.018% ( 2900, 4400 ] 5 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 28361 Average: 3.0133 StdDev: 25.04 Min: 1 Median: 1.5278 Max: 2549 Percentiles: P50: 1.53 P75: 1.89 P99: 8.55 P99.9: 168.40 P99.99: 1180.16 ------------------------------------------------------ [ 0, 1 ] 3903 13.762% 13.762% ### ( 1, 2 ] 19473 68.661% 82.423% ############## ( 2, 3 ] 2954 10.416% 92.839% ## ( 3, 4 ] 883 3.113% 95.952% # ( 4, 6 ] 571 2.013% 97.966% ( 6, 10 ] 461 1.625% 99.591% ( 10, 15 ] 27 0.095% 99.686% ( 15, 22 ] 7 0.025% 99.711% ( 51, 76 ] 1 0.004% 99.714% ( 76, 110 ] 3 0.011% 99.725% ( 110, 170 ] 51 0.180% 99.905% ( 170, 250 ] 7 0.025% 99.929% ( 250, 380 ] 6 0.021% 99.951% ( 380, 580 ] 6 0.021% 99.972% ( 580, 870 ] 3 0.011% 99.982% ( 870, 1300 ] 3 0.011% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 168793 Average: 3.5056 StdDev: 43.70 Min: 1 Median: 1.6740 Max: 5532 Percentiles: P50: 1.67 P75: 2.28 P99: 8.96 P99.9: 165.94 P99.99: 566.61 ------------------------------------------------------ [ 0, 1 ] 13921 8.247% 8.247% ## ( 1, 2 ] 104556 61.943% 70.191% ############ ( 2, 3 ] 29380 17.406% 87.597% ### ( 3, 4 ] 9192 5.446% 93.042% # ( 4, 6 ] 8101 4.799% 97.842% # ( 6, 10 ] 2644 1.566% 99.408% ( 10, 15 ] 526 0.312% 99.720% ( 15, 22 ] 85 0.050% 99.770% ( 22, 34 ] 20 0.012% 99.782% ( 34, 51 ] 4 0.002% 99.784% ( 51, 76 ] 7 0.004% 99.788% ( 76, 110 ] 67 0.040% 99.828% ( 110, 170 ] 130 0.077% 99.905% ( 170, 250 ] 53 0.031% 99.937% ( 250, 380 ] 50 0.030% 99.966% ( 380, 580 ] 43 0.025% 99.992% ( 580, 870 ] 21 0.012% 100.004% ( 870, 1300 ] 12 0.007% 100.011% ( 1300, 1900 ] 5 0.003% 100.014% ( 1900, 2900 ] 3 0.002% 100.016% ( 2900, 4400 ] 9 0.005% 100.021% ( 4400, 6600 ] 5 0.003% 100.024% ** Level 4 read latency histogram (micros): Count: 310 Average: 136.6161 StdDev: 539.20 Min: 0 Median: 2.2632 Max: 4188 Percentiles: P50: 2.26 P75: 7.27 P99: 2887.50 P99.9: 4188.00 P99.99: 4188.00 ------------------------------------------------------ [ 0, 1 ] 62 20.000% 20.000% #### ( 1, 2 ] 78 25.161% 45.161% ##### ( 2, 3 ] 57 18.387% 63.548% #### ( 3, 4 ] 18 5.806% 69.355% # ( 4, 6 ] 14 4.516% 73.871% # ( 6, 10 ] 11 3.548% 77.419% # ( 10, 15 ] 19 6.129% 83.548% # ( 15, 22 ] 15 4.839% 88.387% # ( 22, 34 ] 6 1.935% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 4 1.290% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 1 0.323% 92.903% ( 380, 580 ] 3 0.968% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 1 0.323% 95.484% ( 1300, 1900 ] 3 0.968% 96.452% ( 1900, 2900 ] 8 2.581% 99.032% # ( 2900, 4400 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 705.7250 StdDev: 696.91 Min: 98 Median: 430.0000 Max: 2681 Percentiles: P50: 430.00 P75: 1013.33 P99: 2681.00 P99.9: 2681.00 P99.99: 2681.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 6 15.000% 25.000% ### ( 170, 250 ] 5 12.500% 37.500% ### ( 250, 380 ] 4 10.000% 47.500% ## ( 380, 580 ] 4 10.000% 57.500% ## ( 580, 870 ] 6 15.000% 72.500% ### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.2 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 321.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.073 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.418 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-21:32:02 ... thread 0: (1000000,4000000) ops and (305382.7,327306.7) ops/second in (3.274580,12.220953) 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/11 3.07 GB 144.7 2.5 0.0 2.5 6.2 3.7 0.0 1.7 123.8 304.7 20.87 19.52 61 0.342 2622K 2748 0.0 0.0 L1 1/1 3.81 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 232.1 231.8 1.63 1.58 1 1.628 383K 568 0.0 0.0 L2 1/0 50.18 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 15/0 965.29 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.5 3.4 225.0 224.6 3.85 3.62 2 1.927 880K 1567 0.0 0.0 L4 169/0 9.57 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 148.5 148.5 1.51 1.12 1 1.508 227K 0 0.0 0.0 L5 1044/0 86.18 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 1246/12 99.82 GB 0.0 4.3 1.0 3.3 8.0 4.7 2.3 2.2 150.7 279.1 29.40 27.32 67 0.439 4498K 5088 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.0 3.3 8.0 4.7 2.2 2.2 150.7 279.1 29.40 27.32 67 0.439 4498K 5088 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.3 1.0 3.3 4.3 1.0 0.0 0.0 240.2 239.9 18.44 17.51 15 1.229 4498K 5088 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 345.1 10.95 9.81 52 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): 12.5 total, 12.2 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.01 GB write, 658.74 MB/s write, 4.33 GB read, 355.68 MB/s read, 29.4 seconds Interval compaction: 8.01 GB write, 671.20 MB/s write, 4.33 GB read, 362.41 MB/s read, 29.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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1150519 Average: 2.1839 StdDev: 12.36 Min: 0 Median: 1.4710 Max: 4312 Percentiles: P50: 1.47 P75: 1.85 P99: 5.57 P99.9: 9.61 P99.99: 14.29 ------------------------------------------------------ [ 0, 1 ] 216751 18.839% 18.839% #### ( 1, 2 ] 761113 66.154% 84.993% ############# ( 2, 3 ] 98810 8.588% 93.582% ## ( 3, 4 ] 41232 3.584% 97.165% # ( 4, 6 ] 26861 2.335% 99.500% ( 6, 10 ] 5106 0.444% 99.944% ( 10, 15 ] 620 0.054% 99.998% ( 15, 22 ] 60 0.005% 100.003% ( 22, 34 ] 14 0.001% 100.004% ( 34, 51 ] 7 0.001% 100.005% ( 51, 76 ] 7 0.001% 100.005% ( 76, 110 ] 43 0.004% 100.009% ( 110, 170 ] 75 0.007% 100.016% ( 170, 250 ] 53 0.005% 100.020% ( 250, 380 ] 35 0.003% 100.023% ( 380, 580 ] 18 0.002% 100.025% ( 580, 870 ] 18 0.002% 100.026% ( 870, 1300 ] 14 0.001% 100.028% ( 1300, 1900 ] 5 0.000% 100.028% ( 1900, 2900 ] 12 0.001% 100.029% ( 2900, 4400 ] 5 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 28361 Average: 3.0133 StdDev: 25.04 Min: 1 Median: 1.5278 Max: 2549 Percentiles: P50: 1.53 P75: 1.89 P99: 8.55 P99.9: 168.40 P99.99: 1180.16 ------------------------------------------------------ [ 0, 1 ] 3903 13.762% 13.762% ### ( 1, 2 ] 19473 68.661% 82.423% ############## ( 2, 3 ] 2954 10.416% 92.839% ## ( 3, 4 ] 883 3.113% 95.952% # ( 4, 6 ] 571 2.013% 97.966% ( 6, 10 ] 461 1.625% 99.591% ( 10, 15 ] 27 0.095% 99.686% ( 15, 22 ] 7 0.025% 99.711% ( 51, 76 ] 1 0.004% 99.714% ( 76, 110 ] 3 0.011% 99.725% ( 110, 170 ] 51 0.180% 99.905% ( 170, 250 ] 7 0.025% 99.929% ( 250, 380 ] 6 0.021% 99.951% ( 380, 580 ] 6 0.021% 99.972% ( 580, 870 ] 3 0.011% 99.982% ( 870, 1300 ] 3 0.011% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 168793 Average: 3.5056 StdDev: 43.70 Min: 1 Median: 1.6740 Max: 5532 Percentiles: P50: 1.67 P75: 2.28 P99: 8.96 P99.9: 165.94 P99.99: 566.61 ------------------------------------------------------ [ 0, 1 ] 13921 8.247% 8.247% ## ( 1, 2 ] 104556 61.943% 70.191% ############ ( 2, 3 ] 29380 17.406% 87.597% ### ( 3, 4 ] 9192 5.446% 93.042% # ( 4, 6 ] 8101 4.799% 97.842% # ( 6, 10 ] 2644 1.566% 99.408% ( 10, 15 ] 526 0.312% 99.720% ( 15, 22 ] 85 0.050% 99.770% ( 22, 34 ] 20 0.012% 99.782% ( 34, 51 ] 4 0.002% 99.784% ( 51, 76 ] 7 0.004% 99.788% ( 76, 110 ] 67 0.040% 99.828% ( 110, 170 ] 130 0.077% 99.905% ( 170, 250 ] 53 0.031% 99.937% ( 250, 380 ] 50 0.030% 99.966% ( 380, 580 ] 43 0.025% 99.992% ( 580, 870 ] 21 0.012% 100.004% ( 870, 1300 ] 12 0.007% 100.011% ( 1300, 1900 ] 5 0.003% 100.014% ( 1900, 2900 ] 3 0.002% 100.016% ( 2900, 4400 ] 9 0.005% 100.021% ( 4400, 6600 ] 5 0.003% 100.024% ** Level 4 read latency histogram (micros): Count: 310 Average: 136.6161 StdDev: 539.20 Min: 0 Median: 2.2632 Max: 4188 Percentiles: P50: 2.26 P75: 7.27 P99: 2887.50 P99.9: 4188.00 P99.99: 4188.00 ------------------------------------------------------ [ 0, 1 ] 62 20.000% 20.000% #### ( 1, 2 ] 78 25.161% 45.161% ##### ( 2, 3 ] 57 18.387% 63.548% #### ( 3, 4 ] 18 5.806% 69.355% # ( 4, 6 ] 14 4.516% 73.871% # ( 6, 10 ] 11 3.548% 77.419% # ( 10, 15 ] 19 6.129% 83.548% # ( 15, 22 ] 15 4.839% 88.387% # ( 22, 34 ] 6 1.935% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 4 1.290% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 1 0.323% 92.903% ( 380, 580 ] 3 0.968% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 1 0.323% 95.484% ( 1300, 1900 ] 3 0.968% 96.452% ( 1900, 2900 ] 8 2.581% 99.032% # ( 2900, 4400 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 705.7250 StdDev: 696.91 Min: 98 Median: 430.0000 Max: 2681 Percentiles: P50: 430.00 P75: 1013.33 P99: 2681.00 P99.9: 2681.00 P99.99: 2681.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 6 15.000% 25.000% ### ( 170, 250 ] 5 12.500% 37.500% ### ( 250, 380 ] 4 10.000% 47.500% ## ( 380, 580 ] 4 10.000% 57.500% ## ( 580, 870 ] 6 15.000% 72.500% ### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.5 total, 3.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 316.08 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.685 H:M:S, 13.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 300.55 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.613 H:M:S, 18.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-21:32:05 ... thread 0: (1000000,5000000) ops and (335645.6,328941.2) ops/second in (2.979333,15.200286) 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/11 2.70 GB 18.9 3.4 0.0 3.4 8.1 4.7 0.0 1.7 128.4 305.6 26.99 25.30 78 0.346 3518K 3712 0.0 0.0 L1 12/12 1.35 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 228.7 227.5 7.73 7.48 2 3.863 1793K 8719 0.0 0.0 L2 1/0 50.18 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 15/0 965.29 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.5 3.4 225.0 224.6 3.85 3.62 2 1.927 880K 1567 0.0 0.0 L4 169/0 9.57 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 148.5 148.5 1.51 1.12 1 1.508 227K 0 0.0 0.0 L5 1044/0 86.18 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 1255/23 100.80 GB 0.0 6.5 2.4 4.2 11.2 7.0 2.3 2.4 161.0 275.7 41.62 39.01 85 0.490 6803K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.4 4.2 11.2 7.0 2.2 2.4 161.0 275.7 41.62 39.01 85 0.490 6803K 14K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.5 2.4 4.2 6.5 2.4 0.0 0.0 240.4 239.9 27.87 26.68 19 1.467 6803K 14K 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 348.1 13.75 12.33 66 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.4 total, 15.2 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: 11.20 GB write, 743.38 MB/s write, 6.54 GB read, 434.12 MB/s read, 41.6 seconds Interval compaction: 11.20 GB write, 754.69 MB/s write, 6.54 GB read, 440.72 MB/s read, 41.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 1405883 Average: 2.1647 StdDev: 12.50 Min: 0 Median: 1.4517 Max: 4312 Percentiles: P50: 1.45 P75: 1.83 P99: 5.52 P99.9: 9.69 P99.99: 20.33 ------------------------------------------------------ [ 0, 1 ] 286022 20.345% 20.345% #### ( 1, 2 ] 922957 65.650% 85.994% ############# ( 2, 3 ] 113410 8.067% 94.061% ## ( 3, 4 ] 47075 3.348% 97.410% # ( 4, 6 ] 29480 2.097% 99.506% ( 6, 10 ] 5998 0.427% 99.933% ( 10, 15 ] 741 0.053% 99.986% ( 15, 22 ] 78 0.006% 99.991% ( 22, 34 ] 17 0.001% 99.993% ( 34, 51 ] 8 0.001% 99.993% ( 51, 76 ] 8 0.001% 99.994% ( 76, 110 ] 73 0.005% 99.999% ( 110, 170 ] 156 0.011% 100.010% ( 170, 250 ] 75 0.005% 100.015% ( 250, 380 ] 51 0.004% 100.019% ( 380, 580 ] 29 0.002% 100.021% ( 580, 870 ] 25 0.002% 100.023% ( 870, 1300 ] 21 0.001% 100.024% ( 1300, 1900 ] 5 0.000% 100.025% ( 1900, 2900 ] 13 0.001% 100.026% ( 2900, 4400 ] 7 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 37769 Average: 3.6897 StdDev: 32.74 Min: 1 Median: 1.4831 Max: 2549 Percentiles: P50: 1.48 P75: 1.86 P99: 9.33 P99.9: 328.24 P99.99: 1686.77 ------------------------------------------------------ [ 0, 1 ] 6887 18.235% 18.235% #### ( 1, 2 ] 24833 65.750% 83.984% ############# ( 2, 3 ] 3340 8.843% 92.827% ## ( 3, 4 ] 1195 3.164% 95.991% # ( 4, 6 ] 642 1.700% 97.691% ( 6, 10 ] 593 1.570% 99.261% ( 10, 15 ] 34 0.090% 99.351% ( 15, 22 ] 11 0.029% 99.380% ( 22, 34 ] 1 0.003% 99.383% ( 51, 76 ] 2 0.005% 99.388% ( 76, 110 ] 46 0.122% 99.510% ( 110, 170 ] 118 0.312% 99.823% ( 170, 250 ] 19 0.050% 99.873% ( 250, 380 ] 17 0.045% 99.918% ( 380, 580 ] 11 0.029% 99.947% ( 580, 870 ] 7 0.019% 99.966% ( 870, 1300 ] 6 0.016% 99.981% ( 1300, 1900 ] 5 0.013% 99.995% ( 1900, 2900 ] 2 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 168793 Average: 3.5056 StdDev: 43.70 Min: 1 Median: 1.6740 Max: 5532 Percentiles: P50: 1.67 P75: 2.28 P99: 8.96 P99.9: 165.94 P99.99: 566.61 ------------------------------------------------------ [ 0, 1 ] 13921 8.247% 8.247% ## ( 1, 2 ] 104556 61.943% 70.191% ############ ( 2, 3 ] 29380 17.406% 87.597% ### ( 3, 4 ] 9192 5.446% 93.042% # ( 4, 6 ] 8101 4.799% 97.842% # ( 6, 10 ] 2644 1.566% 99.408% ( 10, 15 ] 526 0.312% 99.720% ( 15, 22 ] 85 0.050% 99.770% ( 22, 34 ] 20 0.012% 99.782% ( 34, 51 ] 4 0.002% 99.784% ( 51, 76 ] 7 0.004% 99.788% ( 76, 110 ] 67 0.040% 99.828% ( 110, 170 ] 130 0.077% 99.905% ( 170, 250 ] 53 0.031% 99.937% ( 250, 380 ] 50 0.030% 99.966% ( 380, 580 ] 43 0.025% 99.992% ( 580, 870 ] 21 0.012% 100.004% ( 870, 1300 ] 12 0.007% 100.011% ( 1300, 1900 ] 5 0.003% 100.014% ( 1900, 2900 ] 3 0.002% 100.016% ( 2900, 4400 ] 9 0.005% 100.021% ( 4400, 6600 ] 5 0.003% 100.024% ** Level 4 read latency histogram (micros): Count: 310 Average: 136.6161 StdDev: 539.20 Min: 0 Median: 2.2632 Max: 4188 Percentiles: P50: 2.26 P75: 7.27 P99: 2887.50 P99.9: 4188.00 P99.99: 4188.00 ------------------------------------------------------ [ 0, 1 ] 62 20.000% 20.000% #### ( 1, 2 ] 78 25.161% 45.161% ##### ( 2, 3 ] 57 18.387% 63.548% #### ( 3, 4 ] 18 5.806% 69.355% # ( 4, 6 ] 14 4.516% 73.871% # ( 6, 10 ] 11 3.548% 77.419% # ( 10, 15 ] 19 6.129% 83.548% # ( 15, 22 ] 15 4.839% 88.387% # ( 22, 34 ] 6 1.935% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 4 1.290% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 1 0.323% 92.903% ( 380, 580 ] 3 0.968% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 1 0.323% 95.484% ( 1300, 1900 ] 3 0.968% 96.452% ( 1900, 2900 ] 8 2.581% 99.032% # ( 2900, 4400 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 705.7250 StdDev: 696.91 Min: 98 Median: 430.0000 Max: 2681 Percentiles: P50: 430.00 P75: 1013.33 P99: 2681.00 P99.9: 2681.00 P99.99: 2681.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 6 15.000% 25.000% ### ( 170, 250 ] 5 12.500% 37.500% ### ( 250, 380 ] 4 10.000% 47.500% ## ( 380, 580 ] 4 10.000% 57.500% ## ( 580, 870 ] 6 15.000% 72.500% ### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 15.4 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 318.83 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.062 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.34 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.376 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-21:32:09 ... thread 0: (1000000,6000000) ops and (274185.7,318345.5) ops/second in (3.647163,18.847449) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 3.69 GB 94.4 4.2 0.0 4.2 9.9 5.7 0.0 1.7 130.9 305.2 33.21 31.17 95 0.350 4413K 4686 0.0 0.0 L1 12/12 1.35 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 228.7 227.5 7.73 7.48 2 3.863 1793K 8719 0.0 0.0 L2 1/0 50.18 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 15/0 965.29 MB 1.0 0.8 0.2 0.6 0.8 0.2 0.5 3.4 225.0 224.6 3.85 3.62 2 1.927 880K 1567 0.0 0.0 L4 169/0 9.57 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 148.5 148.5 1.51 1.12 1 1.508 227K 0 0.0 0.0 L5 1044/0 86.18 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 1260/27 101.78 GB 0.0 7.4 2.4 5.0 13.0 8.0 2.3 2.3 158.5 279.3 47.84 44.88 102 0.469 7698K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.4 2.4 5.0 13.0 8.0 2.2 2.3 158.5 279.3 47.84 44.88 102 0.469 7698K 15K 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 7.4 2.4 5.0 7.4 2.4 0.0 0.0 243.0 242.5 31.20 29.96 22 1.418 7698K 15K 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 348.4 16.63 14.91 80 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.1 total, 18.8 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.05 GB write, 700.28 MB/s write, 7.40 GB read, 397.36 MB/s read, 47.8 seconds Interval compaction: 13.05 GB write, 708.87 MB/s write, 7.40 GB read, 402.24 MB/s read, 47.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 18, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1803723 Average: 2.1706 StdDev: 12.52 Min: 0 Median: 1.4578 Max: 4312 Percentiles: P50: 1.46 P75: 1.84 P99: 5.51 P99.9: 9.68 P99.99: 19.51 ------------------------------------------------------ [ 0, 1 ] 355788 19.725% 19.725% #### ( 1, 2 ] 1192882 66.134% 85.860% ############# ( 2, 3 ] 148846 8.252% 94.112% ## ( 3, 4 ] 60359 3.346% 97.458% # ( 4, 6 ] 36851 2.043% 99.501% ( 6, 10 ] 7816 0.433% 99.935% ( 10, 15 ] 940 0.052% 99.987% ( 15, 22 ] 94 0.005% 99.992% ( 22, 34 ] 17 0.001% 99.993% ( 34, 51 ] 11 0.001% 99.993% ( 51, 76 ] 9 0.000% 99.994% ( 76, 110 ] 85 0.005% 99.999% ( 110, 170 ] 207 0.011% 100.010% ( 170, 250 ] 95 0.005% 100.015% ( 250, 380 ] 60 0.003% 100.019% ( 380, 580 ] 37 0.002% 100.021% ( 580, 870 ] 33 0.002% 100.023% ( 870, 1300 ] 28 0.002% 100.024% ( 1300, 1900 ] 7 0.000% 100.025% ( 1900, 2900 ] 14 0.001% 100.025% ( 2900, 4400 ] 10 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 109704 Average: 3.0275 StdDev: 25.65 Min: 1 Median: 1.5136 Max: 3826 Percentiles: P50: 1.51 P75: 1.88 P99: 8.63 P99.9: 191.87 P99.99: 1194.09 ------------------------------------------------------ [ 0, 1 ] 16681 15.205% 15.205% ### ( 1, 2 ] 74320 67.746% 82.951% ############## ( 2, 3 ] 10772 9.819% 92.771% ## ( 3, 4 ] 3527 3.215% 95.986% # ( 4, 6 ] 2159 1.968% 97.954% ( 6, 10 ] 1744 1.590% 99.543% ( 10, 15 ] 120 0.109% 99.653% ( 15, 22 ] 16 0.015% 99.667% ( 22, 34 ] 1 0.001% 99.668% ( 34, 51 ] 3 0.003% 99.671% ( 51, 76 ] 2 0.002% 99.673% ( 76, 110 ] 81 0.074% 99.747% ( 110, 170 ] 159 0.145% 99.892% ( 170, 250 ] 34 0.031% 99.923% ( 250, 380 ] 35 0.032% 99.954% ( 380, 580 ] 22 0.020% 99.974% ( 580, 870 ] 11 0.010% 99.985% ( 870, 1300 ] 8 0.007% 99.992% ( 1300, 1900 ] 5 0.005% 99.996% ( 1900, 2900 ] 3 0.003% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 168793 Average: 3.5056 StdDev: 43.70 Min: 1 Median: 1.6740 Max: 5532 Percentiles: P50: 1.67 P75: 2.28 P99: 8.96 P99.9: 165.94 P99.99: 566.61 ------------------------------------------------------ [ 0, 1 ] 13921 8.247% 8.247% ## ( 1, 2 ] 104556 61.943% 70.191% ############ ( 2, 3 ] 29380 17.406% 87.597% ### ( 3, 4 ] 9192 5.446% 93.042% # ( 4, 6 ] 8101 4.799% 97.842% # ( 6, 10 ] 2644 1.566% 99.408% ( 10, 15 ] 526 0.312% 99.720% ( 15, 22 ] 85 0.050% 99.770% ( 22, 34 ] 20 0.012% 99.782% ( 34, 51 ] 4 0.002% 99.784% ( 51, 76 ] 7 0.004% 99.788% ( 76, 110 ] 67 0.040% 99.828% ( 110, 170 ] 130 0.077% 99.905% ( 170, 250 ] 53 0.031% 99.937% ( 250, 380 ] 50 0.030% 99.966% ( 380, 580 ] 43 0.025% 99.992% ( 580, 870 ] 21 0.012% 100.004% ( 870, 1300 ] 12 0.007% 100.011% ( 1300, 1900 ] 5 0.003% 100.014% ( 1900, 2900 ] 3 0.002% 100.016% ( 2900, 4400 ] 9 0.005% 100.021% ( 4400, 6600 ] 5 0.003% 100.024% ** Level 4 read latency histogram (micros): Count: 310 Average: 136.6161 StdDev: 539.20 Min: 0 Median: 2.2632 Max: 4188 Percentiles: P50: 2.26 P75: 7.27 P99: 2887.50 P99.9: 4188.00 P99.99: 4188.00 ------------------------------------------------------ [ 0, 1 ] 62 20.000% 20.000% #### ( 1, 2 ] 78 25.161% 45.161% ##### ( 2, 3 ] 57 18.387% 63.548% #### ( 3, 4 ] 18 5.806% 69.355% # ( 4, 6 ] 14 4.516% 73.871% # ( 6, 10 ] 11 3.548% 77.419% # ( 10, 15 ] 19 6.129% 83.548% # ( 15, 22 ] 15 4.839% 88.387% # ( 22, 34 ] 6 1.935% 90.323% ( 76, 110 ] 1 0.323% 90.645% ( 110, 170 ] 4 1.290% 91.935% ( 170, 250 ] 2 0.645% 92.581% ( 250, 380 ] 1 0.323% 92.903% ( 380, 580 ] 3 0.968% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 1 0.323% 95.484% ( 1300, 1900 ] 3 0.968% 96.452% ( 1900, 2900 ] 8 2.581% 99.032% # ( 2900, 4400 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 705.7250 StdDev: 696.91 Min: 98 Median: 430.0000 Max: 2681 Percentiles: P50: 430.00 P75: 1013.33 P99: 2681.00 P99.9: 2681.00 P99.99: 2681.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 6 15.000% 25.000% ### ( 170, 250 ] 5 12.500% 37.500% ### ( 250, 380 ] 4 10.000% 47.500% ## ( 380, 580 ] 4 10.000% 57.500% ## ( 580, 870 ] 6 15.000% 72.500% ### ( 870, 1300 ] 3 7.500% 80.000% ## ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 19.1 total, 3.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 309.47 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:3.029 H:M:S, 15.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.85 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.968 H:M:S, 26.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-21:32:27 ... thread 0: (1000000,7000000) ops and (54088.8,187488.8) ops/second in (18.488124,37.335573) 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/8 2.09 GB 56.7 5.0 0.0 5.0 11.6 6.6 0.0 1.8 128.2 297.5 39.79 36.57 111 0.358 5181K 5395 0.0 0.0 L1 11/11 1.29 GB 0.0 5.6 4.2 1.4 5.5 4.2 0.2 1.3 223.1 220.2 25.66 24.28 3 8.555 5815K 75K 0.0 0.0 L2 8/6 1.01 GB 2.6 0.4 0.2 0.2 0.4 0.2 3.1 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 25/6 1.24 GB 0.9 2.7 1.8 0.9 2.7 1.8 0.5 1.5 213.2 212.6 13.19 12.23 6 2.198 2855K 7587 0.0 0.0 L4 169/1 9.53 GB 1.0 1.0 1.0 0.0 1.0 1.0 0.8 1.0 122.2 121.9 8.77 5.12 13 0.675 1064K 1019 0.0 0.0 L5 1060/0 87.48 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1285/32 102.63 GB 0.0 14.7 7.2 7.5 21.2 13.7 6.6 3.2 169.7 244.4 88.95 79.67 135 0.659 15M 89K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.7 7.2 7.5 21.2 13.7 6.5 3.2 169.7 244.4 88.95 79.67 135 0.659 15M 89K 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.7 7.2 7.5 14.6 7.1 0.0 0.0 219.8 218.5 68.65 62.22 42 1.634 15M 89K 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 332.0 20.30 17.45 93 0.218 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): 37.6 total, 37.3 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.23 GB write, 578.67 MB/s write, 14.74 GB read, 401.68 MB/s read, 88.9 seconds Interval compaction: 21.23 GB write, 582.25 MB/s write, 14.74 GB read, 404.16 MB/s read, 88.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 30, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 30, interval: 48 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2670983 Average: 2.5167 StdDev: 16.56 Min: 0 Median: 1.4525 Max: 6091 Percentiles: P50: 1.45 P75: 1.84 P99: 5.97 P99.9: 116.90 P99.99: 314.41 ------------------------------------------------------ [ 0, 1 ] 562394 21.056% 21.056% #### ( 1, 2 ] 1708409 63.962% 85.018% ############# ( 2, 3 ] 212469 7.955% 92.972% ## ( 3, 4 ] 92538 3.465% 96.437% # ( 4, 6 ] 69536 2.603% 99.040% # ( 6, 10 ] 17774 0.665% 99.706% ( 10, 15 ] 2002 0.075% 99.781% ( 15, 22 ] 427 0.016% 99.797% ( 22, 34 ] 37 0.001% 99.798% ( 34, 51 ] 12 0.000% 99.798% ( 51, 76 ] 44 0.002% 99.800% ( 76, 110 ] 2433 0.091% 99.891% ( 110, 170 ] 2062 0.077% 99.968% ( 170, 250 ] 405 0.015% 99.983% ( 250, 380 ] 351 0.013% 99.997% ( 380, 580 ] 325 0.012% 100.009% ( 580, 870 ] 172 0.006% 100.015% ( 870, 1300 ] 74 0.003% 100.018% ( 1300, 1900 ] 21 0.001% 100.019% ( 1900, 2900 ] 25 0.001% 100.020% ( 2900, 4400 ] 13 0.000% 100.020% ( 4400, 6600 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 984506 Average: 3.6781 StdDev: 49.11 Min: 1 Median: 1.6137 Max: 10149 Percentiles: P50: 1.61 P75: 2.17 P99: 8.82 P99.9: 133.83 P99.99: 308.86 ------------------------------------------------------ [ 0, 1 ] 136838 13.899% 13.899% ### ( 1, 2 ] 579169 58.828% 72.728% ############ ( 2, 3 ] 130584 13.264% 85.991% ### ( 3, 4 ] 58900 5.983% 91.974% # ( 4, 6 ] 57418 5.832% 97.806% # ( 6, 10 ] 16648 1.691% 99.497% ( 10, 15 ] 2248 0.228% 99.726% ( 15, 22 ] 361 0.037% 99.762% ( 22, 34 ] 24 0.002% 99.765% ( 34, 51 ] 7 0.001% 99.765% ( 51, 76 ] 40 0.004% 99.770% ( 76, 110 ] 942 0.096% 99.865% ( 110, 170 ] 865 0.088% 99.953% ( 170, 250 ] 250 0.025% 99.978% ( 250, 380 ] 253 0.026% 100.004% ( 380, 580 ] 231 0.023% 100.028% ( 580, 870 ] 181 0.018% 100.046% ( 870, 1300 ] 95 0.010% 100.056% ( 1300, 1900 ] 51 0.005% 100.061% ( 1900, 2900 ] 44 0.004% 100.065% ( 2900, 4400 ] 67 0.007% 100.072% ( 4400, 6600 ] 17 0.002% 100.074% ( 6600, 9900 ] 5 0.001% 100.074% ( 9900, 14000 ] 1 0.000% 100.074% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 444239 Average: 4.1457 StdDev: 47.98 Min: 1 Median: 1.8443 Max: 6554 Percentiles: P50: 1.84 P75: 2.81 P99: 8.84 P99.9: 100.41 P99.99: 227.54 ------------------------------------------------------ [ 0, 1 ] 19516 4.393% 4.393% # ( 1, 2 ] 239973 54.019% 58.412% ########### ( 2, 3 ] 91258 20.543% 78.955% #### ( 3, 4 ] 40797 9.184% 88.138% ## ( 4, 6 ] 42506 9.568% 97.706% ## ( 6, 10 ] 8088 1.821% 99.527% ( 10, 15 ] 1350 0.304% 99.831% ( 15, 22 ] 179 0.040% 99.871% ( 22, 34 ] 41 0.009% 99.880% ( 34, 51 ] 8 0.002% 99.882% ( 51, 76 ] 12 0.003% 99.885% ( 76, 110 ] 93 0.021% 99.906% ( 110, 170 ] 229 0.052% 99.957% ( 170, 250 ] 201 0.045% 100.003% ( 250, 380 ] 194 0.044% 100.046% ( 380, 580 ] 185 0.042% 100.088% ( 580, 870 ] 111 0.025% 100.113% ( 870, 1300 ] 60 0.014% 100.127% ( 1300, 1900 ] 21 0.005% 100.131% ( 1900, 2900 ] 15 0.003% 100.135% ( 2900, 4400 ] 30 0.007% 100.141% ( 4400, 6600 ] 10 0.002% 100.144% ** Level 4 read latency histogram (micros): Count: 13294 Average: 73.8657 StdDev: 403.65 Min: 0 Median: 1.9888 Max: 7860 Percentiles: P50: 1.99 P75: 3.37 P99: 2002.71 P99.9: 5416.82 P99.99: 7337.66 ------------------------------------------------------ [ 0, 1 ] 531 3.994% 3.994% # ( 1, 2 ] 6185 46.525% 50.519% ######### ( 2, 3 ] 2691 20.242% 70.761% #### ( 3, 4 ] 1505 11.321% 82.082% ## ( 4, 6 ] 1068 8.034% 90.116% ## ( 6, 10 ] 298 2.242% 92.357% ( 10, 15 ] 87 0.654% 93.012% ( 15, 22 ] 28 0.211% 93.223% ( 22, 34 ] 8 0.060% 93.283% ( 34, 51 ] 1 0.008% 93.290% ( 76, 110 ] 13 0.098% 93.388% ( 110, 170 ] 40 0.301% 93.689% ( 170, 250 ] 71 0.534% 94.223% ( 250, 380 ] 107 0.805% 95.028% ( 380, 580 ] 195 1.467% 96.495% ( 580, 870 ] 165 1.241% 97.736% ( 870, 1300 ] 99 0.745% 98.481% ( 1300, 1900 ] 63 0.474% 98.954% ( 1900, 2900 ] 59 0.444% 99.398% ( 2900, 4400 ] 57 0.429% 99.827% ( 4400, 6600 ] 21 0.158% 99.985% ( 6600, 9900 ] 3 0.023% 100.008% ** Level 5 read latency histogram (micros): Count: 120 Average: 988.7000 StdDev: 1010.79 Min: 89 Median: 594.5000 Max: 4764 Percentiles: P50: 594.50 P75: 1480.00 P99: 4350.00 P99.9: 4764.00 P99.99: 4764.00 ------------------------------------------------------ ( 76, 110 ] 9 7.500% 7.500% ## ( 110, 170 ] 13 10.833% 18.333% ## ( 170, 250 ] 8 6.667% 25.000% # ( 250, 380 ] 13 10.833% 35.833% ## ( 380, 580 ] 16 13.333% 49.167% ### ( 580, 870 ] 20 16.667% 65.833% ### ( 870, 1300 ] 8 6.667% 72.500% # ( 1300, 1900 ] 10 8.333% 80.833% ## ( 1900, 2900 ] 16 13.333% 94.167% ### ( 2900, 4400 ] 6 5.000% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 37.6 total, 18.5 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 183.38 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:18.095 H:M:S, 48.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 53.23 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:15.066 H:M:S, 81.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/12/13-21:32:31 ... thread 0: (1000000,8000000) ops and (249477.3,193498.7) ops/second in (4.008381,41.343954) 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/12 3.07 GB 125.9 5.7 0.0 5.7 13.2 7.6 0.0 1.7 124.4 290.5 46.61 42.05 126 0.370 5884K 6309 0.0 0.0 L1 11/11 1.29 GB 0.0 5.6 4.2 1.4 5.5 4.2 0.2 1.3 223.1 220.2 25.66 24.28 3 8.555 5815K 75K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.1 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 19/0 963.76 MB 1.0 4.2 2.8 1.4 4.2 2.8 0.5 1.5 194.0 193.5 22.18 18.95 11 2.017 4370K 11K 0.0 0.0 L4 173/0 9.47 GB 1.0 2.4 2.3 0.1 2.4 2.3 0.8 1.1 137.7 137.4 18.00 11.66 33 0.545 2469K 3404 0.0 0.0 L5 1076/0 88.83 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1298/23 103.61 GB 0.0 18.2 9.5 8.7 25.7 17.0 8.0 3.4 163.9 231.0 113.98 98.43 175 0.651 18M 96K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.2 9.5 8.7 25.7 17.0 7.8 3.4 163.9 231.0 113.98 98.43 175 0.651 18M 96K 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 18.2 9.5 8.7 18.1 9.4 0.0 0.0 207.8 206.7 89.92 78.28 69 1.303 18M 96K 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 322.0 24.07 20.15 106 0.227 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): 41.6 total, 41.3 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: 25.71 GB write, 633.29 MB/s write, 18.24 GB read, 449.32 MB/s read, 114.0 seconds Interval compaction: 25.71 GB write, 636.83 MB/s write, 18.24 GB read, 451.83 MB/s read, 114.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 51, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 51, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2986966 Average: 2.5976 StdDev: 18.29 Min: 0 Median: 1.4783 Max: 6091 Percentiles: P50: 1.48 P75: 1.87 P99: 6.35 P99.9: 116.86 P99.99: 344.92 ------------------------------------------------------ [ 0, 1 ] 588854 19.714% 19.714% #### ( 1, 2 ] 1891273 63.318% 83.032% ############# ( 2, 3 ] 262882 8.801% 91.833% ## ( 3, 4 ] 117306 3.927% 95.760% # ( 4, 6 ] 94817 3.174% 98.934% # ( 6, 10 ] 22774 0.762% 99.697% ( 10, 15 ] 2770 0.093% 99.789% ( 15, 22 ] 495 0.017% 99.806% ( 22, 34 ] 48 0.002% 99.808% ( 34, 51 ] 15 0.001% 99.808% ( 51, 76 ] 45 0.002% 99.810% ( 76, 110 ] 2457 0.082% 99.892% ( 110, 170 ] 2135 0.071% 99.963% ( 170, 250 ] 487 0.016% 99.980% ( 250, 380 ] 425 0.014% 99.994% ( 380, 580 ] 392 0.013% 100.007% ( 580, 870 ] 213 0.007% 100.014% ( 870, 1300 ] 101 0.003% 100.018% ( 1300, 1900 ] 35 0.001% 100.019% ( 1900, 2900 ] 34 0.001% 100.020% ( 2900, 4400 ] 20 0.001% 100.020% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1228299 Average: 3.7916 StdDev: 50.70 Min: 1 Median: 1.6491 Max: 10149 Percentiles: P50: 1.65 P75: 2.31 P99: 8.95 P99.9: 140.83 P99.99: 365.53 ------------------------------------------------------ [ 0, 1 ] 146650 11.939% 11.939% ## ( 1, 2 ] 720273 58.640% 70.579% ############ ( 2, 3 ] 176850 14.398% 84.977% ### ( 3, 4 ] 78425 6.385% 91.362% # ( 4, 6 ] 77418 6.303% 97.665% # ( 6, 10 ] 22239 1.811% 99.475% ( 10, 15 ] 3193 0.260% 99.735% ( 15, 22 ] 441 0.036% 99.771% ( 22, 34 ] 39 0.003% 99.774% ( 34, 51 ] 12 0.001% 99.775% ( 51, 76 ] 40 0.003% 99.779% ( 76, 110 ] 982 0.080% 99.859% ( 110, 170 ] 990 0.081% 99.939% ( 170, 250 ] 338 0.028% 99.967% ( 250, 380 ] 322 0.026% 99.993% ( 380, 580 ] 311 0.025% 100.018% ( 580, 870 ] 236 0.019% 100.037% ( 870, 1300 ] 121 0.010% 100.047% ( 1300, 1900 ] 62 0.005% 100.052% ( 1900, 2900 ] 67 0.005% 100.058% ( 2900, 4400 ] 91 0.007% 100.065% ( 4400, 6600 ] 23 0.002% 100.067% ( 6600, 9900 ] 6 0.000% 100.068% ( 9900, 14000 ] 1 0.000% 100.068% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 830196 Average: 4.1633 StdDev: 52.80 Min: 1 Median: 1.8897 Max: 8014 Percentiles: P50: 1.89 P75: 2.90 P99: 8.61 P99.9: 14.85 P99.99: 155.44 ------------------------------------------------------ [ 0, 1 ] 26694 3.215% 3.215% # ( 1, 2 ] 436534 52.582% 55.797% ########### ( 2, 3 ] 177440 21.373% 77.171% #### ( 3, 4 ] 82981 9.995% 87.166% ## ( 4, 6 ] 88483 10.658% 97.824% ## ( 6, 10 ] 14936 1.799% 99.623% ( 10, 15 ] 2369 0.285% 99.909% ( 15, 22 ] 287 0.035% 99.943% ( 22, 34 ] 55 0.007% 99.950% ( 34, 51 ] 12 0.001% 99.951% ( 51, 76 ] 16 0.002% 99.953% ( 76, 110 ] 100 0.012% 99.965% ( 110, 170 ] 272 0.033% 99.998% ( 170, 250 ] 260 0.031% 100.029% ( 250, 380 ] 260 0.031% 100.061% ( 380, 580 ] 257 0.031% 100.092% ( 580, 870 ] 170 0.020% 100.112% ( 870, 1300 ] 109 0.013% 100.125% ( 1300, 1900 ] 44 0.005% 100.130% ( 1900, 2900 ] 49 0.006% 100.136% ( 2900, 4400 ] 67 0.008% 100.144% ( 4400, 6600 ] 14 0.002% 100.146% ( 6600, 9900 ] 5 0.001% 100.147% ** Level 4 read latency histogram (micros): Count: 32387 Average: 61.5725 StdDev: 331.40 Min: 0 Median: 1.9866 Max: 7860 Percentiles: P50: 1.99 P75: 3.35 P99: 1493.12 P99.9: 4362.31 P99.99: 6580.55 ------------------------------------------------------ [ 0, 1 ] 1282 3.958% 3.958% # ( 1, 2 ] 15114 46.667% 50.625% ######### ( 2, 3 ] 6585 20.332% 70.957% #### ( 3, 4 ] 3734 11.529% 82.487% ## ( 4, 6 ] 2581 7.969% 90.456% ## ( 6, 10 ] 686 2.118% 92.574% ( 10, 15 ] 193 0.596% 93.170% ( 15, 22 ] 42 0.130% 93.300% ( 22, 34 ] 8 0.025% 93.324% ( 34, 51 ] 2 0.006% 93.331% ( 76, 110 ] 53 0.164% 93.494% ( 110, 170 ] 127 0.392% 93.886% ( 170, 250 ] 209 0.645% 94.532% ( 250, 380 ] 281 0.868% 95.399% ( 380, 580 ] 434 1.340% 96.739% ( 580, 870 ] 406 1.254% 97.993% ( 870, 1300 ] 283 0.874% 98.867% ( 1300, 1900 ] 134 0.414% 99.281% ( 1900, 2900 ] 108 0.333% 99.614% ( 2900, 4400 ] 95 0.293% 99.907% ( 4400, 6600 ] 27 0.083% 99.991% ( 6600, 9900 ] 3 0.009% 100.000% ** Level 5 read latency histogram (micros): Count: 200 Average: 1079.9300 StdDev: 1125.09 Min: 89 Median: 580.0000 Max: 4764 Percentiles: P50: 580.00 P75: 1660.00 P99: 4400.00 P99.9: 4764.00 P99.99: 4764.00 ------------------------------------------------------ ( 76, 110 ] 14 7.000% 7.000% # ( 110, 170 ] 16 8.000% 15.000% ## ( 170, 250 ] 22 11.000% 26.000% ## ( 250, 380 ] 21 10.500% 36.500% ## ( 380, 580 ] 27 13.500% 50.000% ### ( 580, 870 ] 26 13.000% 63.000% ### ( 870, 1300 ] 15 7.500% 70.500% ## ( 1300, 1900 ] 15 7.500% 78.000% ## ( 1900, 2900 ] 25 12.500% 90.500% ### ( 2900, 4400 ] 17 8.500% 99.000% ## ( 4400, 6600 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 41.6 total, 4.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 189.37 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:19.229 H:M:S, 46.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 245.53 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.134 H:M:S, 28.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-21:32:37 ... thread 0: (1000000,9000000) ops and (170148.5,190592.5) ops/second in (5.877219,47.221173) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/5 2.58 GB 157.3 7.0 0.0 7.0 15.6 8.6 0.0 1.8 130.0 290.9 54.76 49.78 148 0.370 7227K 7638 0.0 0.0 L1 11/0 1.28 GB 131.0 8.4 5.8 2.6 8.3 5.7 0.2 1.4 215.7 213.0 39.96 37.05 4 9.991 7413K 75K 0.0 0.0 L2 13/10 980.68 MB 1.6 0.4 0.2 0.2 0.4 0.2 4.6 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 30/8 1.50 GB 1.0 4.2 2.8 1.4 4.2 2.8 1.0 1.5 194.0 193.5 22.18 18.95 11 2.017 4370K 11K 0.0 0.0 L4 173/0 9.47 GB 1.0 2.4 2.3 0.1 2.4 2.3 0.8 1.1 137.7 137.4 18.00 11.66 33 0.545 2469K 3404 0.0 0.0 L5 1076/0 88.83 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1316/23 104.62 GB 0.0 22.4 11.1 11.3 30.8 19.6 10.0 3.6 167.8 231.5 136.44 118.94 198 0.689 21M 98K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.4 11.1 11.3 30.8 19.6 9.9 3.6 167.8 231.5 136.44 118.94 198 0.689 21M 98K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.4 11.1 11.3 22.2 10.9 0.0 0.0 209.5 208.3 109.28 96.03 75 1.457 21M 98K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 324.7 27.16 22.91 123 0.221 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): 47.5 total, 47.2 interval Flush(GB): cumulative 8.613, interval 8.613 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.84 GB write, 665.53 MB/s write, 22.36 GB read, 482.48 MB/s read, 136.4 seconds Interval compaction: 30.84 GB write, 668.79 MB/s write, 22.36 GB read, 484.84 MB/s read, 136.4 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: 51, pending-compaction-bytes-delays: 11, pending-compaction-bytes-stops: 0, total-delays: 30, total-stops: 51, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3444291 Average: 2.5541 StdDev: 17.64 Min: 0 Median: 1.4754 Max: 6091 Percentiles: P50: 1.48 P75: 1.87 P99: 6.05 P99.9: 110.90 P99.99: 330.57 ------------------------------------------------------ [ 0, 1 ] 675709 19.618% 19.618% #### ( 1, 2 ] 2201086 63.905% 83.524% ############# ( 2, 3 ] 298167 8.657% 92.180% ## ( 3, 4 ] 131775 3.826% 96.006% # ( 4, 6 ] 102779 2.984% 98.990% # ( 6, 10 ] 25093 0.729% 99.719% ( 10, 15 ] 3007 0.087% 99.806% ( 15, 22 ] 527 0.015% 99.822% ( 22, 34 ] 50 0.001% 99.823% ( 34, 51 ] 19 0.001% 99.824% ( 51, 76 ] 48 0.001% 99.825% ( 76, 110 ] 2554 0.074% 99.899% ( 110, 170 ] 2312 0.067% 99.966% ( 170, 250 ] 535 0.016% 99.982% ( 250, 380 ] 464 0.013% 99.995% ( 380, 580 ] 429 0.012% 100.008% ( 580, 870 ] 231 0.007% 100.014% ( 870, 1300 ] 103 0.003% 100.017% ( 1300, 1900 ] 39 0.001% 100.018% ( 1900, 2900 ] 36 0.001% 100.020% ( 2900, 4400 ] 22 0.001% 100.020% ( 4400, 6600 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1462109 Average: 3.6378 StdDev: 47.15 Min: 1 Median: 1.6239 Max: 10149 Percentiles: P50: 1.62 P75: 2.17 P99: 8.88 P99.9: 145.08 P99.99: 404.17 ------------------------------------------------------ [ 0, 1 ] 181124 12.388% 12.388% ## ( 1, 2 ] 881388 60.282% 72.670% ############ ( 2, 3 ] 198361 13.567% 86.237% ### ( 3, 4 ] 85585 5.854% 92.090% # ( 4, 6 ] 82302 5.629% 97.719% # ( 6, 10 ] 26039 1.781% 99.500% ( 10, 15 ] 3440 0.235% 99.735% ( 15, 22 ] 462 0.032% 99.767% ( 22, 34 ] 43 0.003% 99.770% ( 34, 51 ] 13 0.001% 99.771% ( 51, 76 ] 47 0.003% 99.774% ( 76, 110 ] 1138 0.078% 99.852% ( 110, 170 ] 1209 0.083% 99.934% ( 170, 250 ] 389 0.027% 99.961% ( 250, 380 ] 382 0.026% 99.987% ( 380, 580 ] 354 0.024% 100.011% ( 580, 870 ] 257 0.018% 100.029% ( 870, 1300 ] 153 0.010% 100.039% ( 1300, 1900 ] 68 0.005% 100.044% ( 1900, 2900 ] 67 0.005% 100.049% ( 2900, 4400 ] 92 0.006% 100.055% ( 4400, 6600 ] 23 0.002% 100.057% ( 6600, 9900 ] 6 0.000% 100.057% ( 9900, 14000 ] 1 0.000% 100.057% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 830276 Average: 4.1954 StdDev: 52.95 Min: 1 Median: 1.8898 Max: 8014 Percentiles: P50: 1.89 P75: 2.90 P99: 8.64 P99.9: 15.21 P99.99: 168.33 ------------------------------------------------------ [ 0, 1 ] 26694 3.215% 3.215% # ( 1, 2 ] 436534 52.577% 55.792% ########### ( 2, 3 ] 177440 21.371% 77.163% #### ( 3, 4 ] 82981 9.994% 87.158% ## ( 4, 6 ] 88483 10.657% 97.815% ## ( 6, 10 ] 14936 1.799% 99.614% ( 10, 15 ] 2369 0.285% 99.899% ( 15, 22 ] 287 0.035% 99.934% ( 22, 34 ] 55 0.007% 99.940% ( 34, 51 ] 12 0.001% 99.942% ( 51, 76 ] 16 0.002% 99.944% ( 76, 110 ] 106 0.013% 99.956% ( 110, 170 ] 288 0.035% 99.991% ( 170, 250 ] 274 0.033% 100.024% ( 250, 380 ] 278 0.033% 100.057% ( 380, 580 ] 274 0.033% 100.090% ( 580, 870 ] 175 0.021% 100.112% ( 870, 1300 ] 113 0.014% 100.125% ( 1300, 1900 ] 44 0.005% 100.130% ( 1900, 2900 ] 49 0.006% 100.136% ( 2900, 4400 ] 67 0.008% 100.144% ( 4400, 6600 ] 14 0.002% 100.146% ( 6600, 9900 ] 5 0.001% 100.147% ** Level 4 read latency histogram (micros): Count: 32387 Average: 61.5725 StdDev: 331.40 Min: 0 Median: 1.9866 Max: 7860 Percentiles: P50: 1.99 P75: 3.35 P99: 1493.12 P99.9: 4362.31 P99.99: 6580.55 ------------------------------------------------------ [ 0, 1 ] 1282 3.958% 3.958% # ( 1, 2 ] 15114 46.667% 50.625% ######### ( 2, 3 ] 6585 20.332% 70.957% #### ( 3, 4 ] 3734 11.529% 82.487% ## ( 4, 6 ] 2581 7.969% 90.456% ## ( 6, 10 ] 686 2.118% 92.574% ( 10, 15 ] 193 0.596% 93.170% ( 15, 22 ] 42 0.130% 93.300% ( 22, 34 ] 8 0.025% 93.324% ( 34, 51 ] 2 0.006% 93.331% ( 76, 110 ] 53 0.164% 93.494% ( 110, 170 ] 127 0.392% 93.886% ( 170, 250 ] 209 0.645% 94.532% ( 250, 380 ] 281 0.868% 95.399% ( 380, 580 ] 434 1.340% 96.739% ( 580, 870 ] 406 1.254% 97.993% ( 870, 1300 ] 283 0.874% 98.867% ( 1300, 1900 ] 134 0.414% 99.281% ( 1900, 2900 ] 108 0.333% 99.614% ( 2900, 4400 ] 95 0.293% 99.907% ( 4400, 6600 ] 27 0.083% 99.991% ( 6600, 9900 ] 3 0.009% 100.000% ** Level 5 read latency histogram (micros): Count: 200 Average: 1079.9300 StdDev: 1125.09 Min: 89 Median: 580.0000 Max: 4764 Percentiles: P50: 580.00 P75: 1660.00 P99: 4400.00 P99.9: 4764.00 P99.99: 4764.00 ------------------------------------------------------ ( 76, 110 ] 14 7.000% 7.000% # ( 110, 170 ] 16 8.000% 15.000% ## ( 170, 250 ] 22 11.000% 26.000% ## ( 250, 380 ] 21 10.500% 36.500% ## ( 380, 580 ] 27 13.500% 50.000% ### ( 580, 870 ] 26 13.000% 63.000% ### ( 870, 1300 ] 15 7.500% 70.500% ## ( 1300, 1900 ] 15 7.500% 78.000% ## ( 1900, 2900 ] 25 12.500% 90.500% ### ( 2900, 4400 ] 17 8.500% 99.000% ## ( 4400, 6600 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 47.5 total, 5.9 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 186.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.294 H:M:S, 47.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 167.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:3.066 H:M:S, 52.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 0 2024/12/13-21:32:42 ... thread 0: (1000000,10000000) ops and (198272.0,191333.5) ops/second in (5.043577,52.264750) 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/4 3.44 GB 320.5 8.6 0.0 8.6 18.0 9.5 0.0 1.9 133.5 281.2 65.58 58.58 163 0.402 8890K 12K 0.0 0.0 L1 11/0 1.28 GB 131.0 8.4 5.8 2.6 8.3 5.7 0.2 1.4 215.7 213.0 39.96 37.05 4 9.991 7413K 75K 0.0 0.0 L2 1/0 51.98 MB 0.5 0.4 0.2 0.2 0.4 0.2 4.6 2.0 246.0 245.9 1.54 1.49 2 0.768 383K 205 0.0 0.0 L3 20/0 988.72 MB 1.0 5.8 3.7 2.1 5.7 3.6 1.1 1.6 179.7 179.1 32.82 26.41 18 1.823 5988K 20K 0.0 0.0 L4 173/0 9.54 GB 1.0 4.3 3.7 0.6 4.3 3.7 0.9 1.1 141.4 141.0 31.05 20.69 51 0.609 4314K 3404 0.0 0.0 L5 1092/0 90.18 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1312/4 105.46 GB 0.0 27.4 13.3 14.0 36.7 22.7 11.4 3.9 164.0 219.9 170.95 144.21 238 0.718 26M 111K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.4 13.3 14.0 36.7 22.7 11.3 3.9 164.0 219.9 170.95 144.21 238 0.718 26M 111K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 27.4 13.3 14.0 27.2 13.2 0.0 0.0 200.3 199.2 139.99 118.99 103 1.359 26M 111K 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 313.4 30.96 25.22 135 0.229 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): 52.5 total, 52.3 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 36.70 GB write, 715.91 MB/s write, 27.38 GB read, 534.07 MB/s read, 170.9 seconds Interval compaction: 36.70 GB write, 719.08 MB/s write, 27.38 GB read, 536.43 MB/s read, 170.9 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: 69, pending-compaction-bytes-delays: 23, pending-compaction-bytes-stops: 0, total-delays: 42, total-stops: 69, interval: 111 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3831327 Average: 2.6201 StdDev: 20.30 Min: 0 Median: 1.4944 Max: 6367 Percentiles: P50: 1.49 P75: 1.89 P99: 6.49 P99.9: 107.79 P99.99: 349.36 ------------------------------------------------------ [ 0, 1 ] 721113 18.821% 18.821% #### ( 1, 2 ] 2416354 63.068% 81.890% ############# ( 2, 3 ] 352581 9.203% 91.092% ## ( 3, 4 ] 163102 4.257% 95.349% # ( 4, 6 ] 136090 3.552% 98.902% # ( 6, 10 ] 31109 0.812% 99.713% ( 10, 15 ] 4010 0.105% 99.818% ( 15, 22 ] 616 0.016% 99.834% ( 22, 34 ] 56 0.001% 99.836% ( 34, 51 ] 23 0.001% 99.836% ( 51, 76 ] 49 0.001% 99.838% ( 76, 110 ] 2561 0.067% 99.904% ( 110, 170 ] 2333 0.061% 99.965% ( 170, 250 ] 569 0.015% 99.980% ( 250, 380 ] 497 0.013% 99.993% ( 380, 580 ] 466 0.012% 100.005% ( 580, 870 ] 277 0.007% 100.013% ( 870, 1300 ] 138 0.004% 100.016% ( 1300, 1900 ] 50 0.001% 100.017% ( 1900, 2900 ] 50 0.001% 100.019% ( 2900, 4400 ] 42 0.001% 100.020% ( 4400, 6600 ] 2 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1684007 Average: 4.1443 StdDev: 58.23 Min: 1 Median: 1.6623 Max: 10149 Percentiles: P50: 1.66 P75: 2.35 P99: 9.08 P99.9: 164.32 P99.99: 587.16 ------------------------------------------------------ [ 0, 1 ] 185275 11.002% 11.002% ## ( 1, 2 ] 991643 58.886% 69.888% ############ ( 2, 3 ] 247396 14.691% 84.579% ### ( 3, 4 ] 108786 6.460% 91.039% # ( 4, 6 ] 109355 6.494% 97.533% # ( 6, 10 ] 32047 1.903% 99.436% ( 10, 15 ] 4805 0.285% 99.721% ( 15, 22 ] 601 0.036% 99.757% ( 22, 34 ] 51 0.003% 99.760% ( 34, 51 ] 20 0.001% 99.761% ( 51, 76 ] 55 0.003% 99.764% ( 76, 110 ] 1151 0.068% 99.832% ( 110, 170 ] 1257 0.075% 99.907% ( 170, 250 ] 453 0.027% 99.934% ( 250, 380 ] 458 0.027% 99.961% ( 380, 580 ] 476 0.028% 99.989% ( 580, 870 ] 389 0.023% 100.013% ( 870, 1300 ] 245 0.015% 100.027% ( 1300, 1900 ] 126 0.007% 100.035% ( 1900, 2900 ] 154 0.009% 100.044% ( 2900, 4400 ] 175 0.010% 100.054% ( 4400, 6600 ] 38 0.002% 100.056% ( 6600, 9900 ] 10 0.001% 100.057% ( 9900, 14000 ] 1 0.000% 100.057% ** Level 2 read latency histogram (micros): Count: 111906 Average: 2.2289 StdDev: 15.68 Min: 0 Median: 1.4037 Max: 3137 Percentiles: P50: 1.40 P75: 1.81 P99: 5.78 P99.9: 12.99 P99.99: 475.23 ------------------------------------------------------ [ 0, 1 ] 28040 25.057% 25.057% ##### ( 1, 2 ] 69146 61.789% 86.846% ############ ( 2, 3 ] 7855 7.019% 93.865% # ( 3, 4 ] 3637 3.250% 97.115% # ( 4, 6 ] 2372 2.120% 99.235% ( 6, 10 ] 704 0.629% 99.864% ( 10, 15 ] 67 0.060% 99.924% ( 15, 22 ] 8 0.007% 99.931% ( 34, 51 ] 1 0.001% 99.932% ( 51, 76 ] 1 0.001% 99.933% ( 110, 170 ] 38 0.034% 99.967% ( 170, 250 ] 11 0.010% 99.977% ( 250, 380 ] 11 0.010% 99.987% ( 380, 580 ] 8 0.007% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1378904 Average: 5.0722 StdDev: 73.13 Min: 1 Median: 1.9313 Max: 8024 Percentiles: P50: 1.93 P75: 2.98 P99: 8.94 P99.9: 14.99 P99.99: 177.50 ------------------------------------------------------ [ 0, 1 ] 35918 2.605% 2.605% # ( 1, 2 ] 701747 50.892% 53.496% ########## ( 2, 3 ] 302224 21.918% 75.414% #### ( 3, 4 ] 144722 10.495% 85.910% ## ( 4, 6 ] 160245 11.621% 97.531% ## ( 6, 10 ] 27548 1.998% 99.529% ( 10, 15 ] 5131 0.372% 99.901% ( 15, 22 ] 619 0.045% 99.946% ( 22, 34 ] 79 0.006% 99.951% ( 34, 51 ] 22 0.002% 99.953% ( 51, 76 ] 27 0.002% 99.955% ( 76, 110 ] 127 0.009% 99.964% ( 110, 170 ] 326 0.024% 99.988% ( 170, 250 ] 332 0.024% 100.012% ( 250, 380 ] 391 0.028% 100.040% ( 380, 580 ] 446 0.032% 100.073% ( 580, 870 ] 393 0.029% 100.101% ( 870, 1300 ] 265 0.019% 100.120% ( 1300, 1900 ] 171 0.012% 100.133% ( 1900, 2900 ] 176 0.013% 100.145% ( 2900, 4400 ] 252 0.018% 100.164% ( 4400, 6600 ] 43 0.003% 100.167% ( 6600, 9900 ] 15 0.001% 100.168% ** Level 4 read latency histogram (micros): Count: 148555 Average: 27.8091 StdDev: 211.20 Min: 0 Median: 1.9842 Max: 7947 Percentiles: P50: 1.98 P75: 3.30 P99: 757.28 P99.9: 2839.82 P99.99: 3941.00 ------------------------------------------------------ [ 0, 1 ] 4639 3.123% 3.123% # ( 1, 2 ] 70755 47.629% 50.752% ########## ( 2, 3 ] 31020 20.881% 71.633% #### ( 3, 4 ] 16939 11.403% 83.035% ## ( 4, 6 ] 15590 10.494% 93.530% ## ( 6, 10 ] 4147 2.792% 96.321% # ( 10, 15 ] 901 0.607% 96.928% ( 15, 22 ] 144 0.097% 97.025% ( 22, 34 ] 19 0.013% 97.037% ( 34, 51 ] 8 0.005% 97.043% ( 51, 76 ] 8 0.005% 97.048% ( 76, 110 ] 135 0.091% 97.139% ( 110, 170 ] 304 0.205% 97.344% ( 170, 250 ] 492 0.331% 97.675% ( 250, 380 ] 598 0.403% 98.077% ( 380, 580 ] 860 0.579% 98.656% ( 580, 870 ] 835 0.562% 99.218% ( 870, 1300 ] 563 0.379% 99.597% ( 1300, 1900 ] 269 0.181% 99.779% ( 1900, 2900 ] 192 0.129% 99.908% ( 2900, 4400 ] 176 0.118% 100.026% ( 4400, 6600 ] 46 0.031% 100.057% ( 6600, 9900 ] 4 0.003% 100.060% ** Level 5 read latency histogram (micros): Count: 280 Average: 1042.6536 StdDev: 1144.50 Min: 75 Median: 537.5758 Max: 5552 Percentiles: P50: 537.58 P75: 1613.04 P99: 5060.00 P99.9: 5552.00 P99.99: 5552.00 ------------------------------------------------------ ( 51, 76 ] 2 0.714% 0.714% ( 76, 110 ] 30 10.714% 11.429% ## ( 110, 170 ] 30 10.714% 22.143% ## ( 170, 250 ] 25 8.929% 31.071% ## ( 250, 380 ] 27 9.643% 40.714% ## ( 380, 580 ] 33 11.786% 52.500% ## ( 580, 870 ] 30 10.714% 63.214% ## ( 870, 1300 ] 21 7.500% 70.714% ## ( 1300, 1900 ] 23 8.214% 78.929% ## ( 1900, 2900 ] 33 11.786% 90.714% ## ( 2900, 4400 ] 22 7.857% 98.571% ## ( 4400, 6600 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 52.5 total, 5.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 187.47 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:24.389 H:M:S, 46.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 195.14 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.095 H:M:S, 41.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 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.750 micros/op 173911 ops/sec 60.082 seconds 10448999 operations; 168.5 MB/s Microseconds per write: Count: 10448999 Average: 5.7498 StdDev: 437.88 Min: 0 Median: 1.7463 Max: 680470 Percentiles: P50: 1.75 P75: 2.77 P99: 9.16 P99.9: 1132.67 P99.99: 2712.92 ------------------------------------------------------ [ 0, 1 ] 1383077 13.236% 13.236% ### ( 1, 2 ] 5147352 49.262% 62.498% ########## ( 2, 3 ] 1697498 16.246% 78.744% ### ( 3, 4 ] 1441886 13.799% 92.543% ### ( 4, 6 ] 580754 5.558% 98.101% # ( 6, 10 ] 118910 1.138% 99.239% ( 10, 15 ] 38403 0.368% 99.606% ( 15, 22 ] 9170 0.088% 99.694% ( 22, 34 ] 2049 0.020% 99.714% ( 34, 51 ] 224 0.002% 99.716% ( 51, 76 ] 41 0.000% 99.716% ( 76, 110 ] 7055 0.068% 99.784% ( 110, 170 ] 3004 0.029% 99.813% ( 170, 250 ] 342 0.003% 99.816% ( 250, 380 ] 201 0.002% 99.818% ( 380, 580 ] 31 0.000% 99.818% ( 580, 870 ] 29 0.000% 99.818% ( 870, 1300 ] 13954 0.134% 99.952% ( 1300, 1900 ] 42 0.000% 99.952% ( 1900, 2900 ] 4837 0.046% 99.999% ( 2900, 4400 ] 97 0.001% 100.000% ( 4400, 6600 ] 12 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 2 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 : 182844 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 : 10448999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10783366968 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 : 595 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30964894 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 : 31640420514 rocksdb.compact.write.bytes COUNT : 31456718872 rocksdb.flush.write.bytes COUNT : 10767185223 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 : 65 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 : 372 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 : 10680572928 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4340736 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 : 31743029488 rocksdb.non.last.level.read.count COUNT : 7666205 rocksdb.block.checksum.compute.count COUNT : 7665080 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.405855 P95 : 3.916719 P99 : 7.650857 P100 : 680467.000000 COUNT : 10448999 SUM : 55215882 rocksdb.compaction.times.micros P50 : 904074.074074 P95 : 3716666.666667 P99 : 17800000.000000 P100 : 17938464.000000 COUNT : 105 SUM : 142150485 rocksdb.compaction.times.cpu_micros P50 : 823750.000000 P95 : 2691666.666667 P99 : 13790000.000000 P100 : 16791861.000000 COUNT : 105 SUM : 121109492 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 : 702.974684 P95 : 3825.000000 P99 : 64250.000000 P100 : 210145.000000 COUNT : 143 SUM : 429513 rocksdb.compaction.outfile.sync.micros P50 : 1028.160920 P95 : 60000.000000 P99 : 140800.000000 P100 : 185067.000000 COUNT : 392 SUM : 3539829 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 : 103.818182 P95 : 1400.000000 P99 : 3500.000000 P100 : 4858.000000 COUNT : 280 SUM : 80189 rocksdb.table.open.io.micros P50 : 1502.941176 P95 : 7066.304348 P99 : 11560.500000 P100 : 12802.000000 COUNT : 595 SUM : 1232519 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.661352 P95 : 8.058841 P99 : 11.168279 P100 : 10154.000000 COUNT : 7663517 SUM : 45580817 rocksdb.read.block.get.micros P50 : 447.768595 P95 : 3374.264706 P99 : 4586.153846 P100 : 6380.000000 COUNT : 1190 SUM : 1028455 rocksdb.write.raw.block.micros P50 : 0.513745 P95 : 0.976115 P99 : 2.898251 P100 : 29731.000000 COUNT : 10226564 SUM : 21158316 rocksdb.numfiles.in.singlecompaction P50 : 3.084615 P95 : 5.662500 P99 : 25.000000 P100 : 25.000000 COUNT : 147 SUM : 532 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.565452 P95 : 1198.860609 P99 : 2572.199834 P100 : 680271.000000 COUNT : 163703 SUM : 30981437 rocksdb.sst.read.micros P50 : 1.590592 P95 : 4.859110 P99 : 8.448232 P100 : 10149.000000 COUNT : 7666637 SUM : 29746205 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 : 10448999 SUM : 10783366968 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 : 216538.461538 P95 : 412300.000000 P99 : 721766.666667 P100 : 845251.000000 COUNT : 143 SUM : 32559595 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 : 372 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