[2024-07-25 00:58:15.859839] Starting SPDK v24.05.1-pre git sha1 241d0f3c9 / DPDK 23.11.0 initialization... [2024-07-25 00:58:15.860092] [ 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_pid1985345 ] Set seed to 1721861895853468 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-25 00:58:15.969912] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-25 00:58:16.011289] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-25 00:58:16.011339] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1985345' to capture a snapshot of events at runtime. [2024-07-25 00:58:16.011350] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-25 00:58:16.011360] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-25 00:58:16.011367] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1985345 for offline analysis/debug. [2024-07-25 00:58:16.011459] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Jul 25 00:58:20 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/25-00:58:23 ... thread 0: (1000000,1000000) ops and (358677.2,358677.2) ops/second in (2.788022,2.788022) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/8 504.02 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 354.2 2.31 2.09 12 0.193 0 0 0.0 0.0 L1 3/3 188.90 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 267.3 267.2 0.71 0.68 1 0.707 191K 71 0.0 0.0 L2 2/1 125.96 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.2 2.0 237.1 237.0 0.53 0.51 1 0.531 127K 38 0.0 0.0 L3 11/0 930.39 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/12 96.94 GB 0.0 0.3 0.2 0.1 1.1 1.0 0.4 1.4 88.7 319.3 3.55 3.29 14 0.254 319K 109 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.3 1.4 88.7 319.3 3.55 3.29 14 0.254 319K 109 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.3 0.2 0.1 0.3 0.2 0.0 0.0 254.3 254.2 1.24 1.20 2 0.619 319K 109 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 354.2 2.31 2.09 12 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.11 GB write, 378.47 MB/s write, 0.31 GB read, 105.13 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 406.43 MB/s write, 0.31 GB read, 112.90 MB/s read, 3.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 114899 Average: 1.9262 StdDev: 23.32 Min: 0 Median: 1.2060 Max: 3902 Percentiles: P50: 1.21 P75: 1.65 P99: 4.18 P99.9: 10.76 P99.99: 178.16 ------------------------------------------------------ [ 0, 1 ] 44232 38.496% 38.496% ######## ( 1, 2 ] 64157 55.838% 94.334% ########### ( 2, 3 ] 3897 3.392% 97.726% # ( 3, 4 ] 1391 1.211% 98.936% ( 4, 6 ] 818 0.712% 99.648% ( 6, 10 ] 276 0.240% 99.889% ( 10, 15 ] 93 0.081% 99.970% ( 15, 22 ] 13 0.011% 99.981% ( 22, 34 ] 1 0.001% 99.982% ( 34, 51 ] 1 0.001% 99.983% ( 51, 76 ] 2 0.002% 99.984% ( 110, 170 ] 7 0.006% 99.990% ( 170, 250 ] 5 0.004% 99.995% ( 250, 380 ] 3 0.003% 99.997% ( 380, 580 ] 1 0.001% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ( 1300, 1900 ] 1 0.001% 100.001% ( 1900, 2900 ] 1 0.001% 100.002% ( 2900, 4400 ] 4 0.003% 100.005% ** Level 1 read latency histogram (micros): Count: 26869 Average: 2.0742 StdDev: 24.96 Min: 1 Median: 1.2334 Max: 2741 Percentiles: P50: 1.23 P75: 1.67 P99: 4.03 P99.9: 10.53 P99.99: 1152.32 ------------------------------------------------------ [ 0, 1 ] 9806 36.496% 36.496% ####### ( 1, 2 ] 15548 57.866% 94.362% ############ ( 2, 3 ] 912 3.394% 97.756% # ( 3, 4 ] 332 1.236% 98.991% ( 4, 6 ] 170 0.633% 99.624% ( 6, 10 ] 72 0.268% 99.892% ( 10, 15 ] 20 0.074% 99.967% ( 110, 170 ] 2 0.007% 99.974% ( 250, 380 ] 1 0.004% 99.978% ( 380, 580 ] 1 0.004% 99.981% ( 580, 870 ] 1 0.004% 99.985% ( 870, 1300 ] 2 0.007% 99.993% ( 1900, 2900 ] 2 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 6012 Average: 2.8353 StdDev: 12.09 Min: 1 Median: 1.6985 Max: 865 Percentiles: P50: 1.70 P75: 2.44 P99: 9.51 P99.9: 16.73 P99.99: 695.65 ------------------------------------------------------ [ 0, 1 ] 492 8.184% 8.184% ## ( 1, 2 ] 3602 59.914% 68.097% ############ ( 2, 3 ] 949 15.785% 83.882% ### ( 3, 4 ] 462 7.685% 91.567% ## ( 4, 6 ] 328 5.456% 97.023% # ( 6, 10 ] 139 2.312% 99.335% ( 10, 15 ] 36 0.599% 99.933% ( 15, 22 ] 4 0.067% 100.000% ( 51, 76 ] 1 0.017% 100.017% ( 250, 380 ] 1 0.017% 100.033% ( 580, 870 ] 1 0.017% 100.050% ** Level 3 read latency histogram (micros): Count: 50 Average: 1540.4800 StdDev: 1356.32 Min: 132 Median: 977.5000 Max: 5670 Percentiles: P50: 977.50 P75: 2150.00 P99: 5670.00 P99.9: 5670.00 P99.99: 5670.00 ------------------------------------------------------ ( 110, 170 ] 1 2.000% 2.000% ( 170, 250 ] 1 2.000% 4.000% ( 380, 580 ] 7 14.000% 18.000% ### ( 580, 870 ] 14 28.000% 46.000% ###### ( 870, 1300 ] 8 16.000% 62.000% ### ( 1300, 1900 ] 5 10.000% 72.000% ## ( 1900, 2900 ] 6 12.000% 84.000% ## ( 2900, 4400 ] 5 10.000% 94.000% ## ( 4400, 6600 ] 3 6.000% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1651.5200 StdDev: 1507.69 Min: 105 Median: 1146.4286 Max: 5573 Percentiles: P50: 1146.43 P75: 1862.50 P99: 5573.00 P99.9: 5573.00 P99.99: 5573.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 110, 170 ] 1 4.000% 8.000% # ( 250, 380 ] 2 8.000% 16.000% ## ( 580, 870 ] 4 16.000% 32.000% ### ( 870, 1300 ] 7 28.000% 60.000% ###### ( 1300, 1900 ] 4 16.000% 76.000% ### ( 1900, 2900 ] 2 8.000% 84.000% ## ( 2900, 4400 ] 1 4.000% 88.000% # ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 328.48 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.204 H:M:S, 6.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.67 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.204 H:M:S, 7.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/25-00:58:26 ... thread 0: (1000000,2000000) ops and (325203.4,341121.1) ops/second in (3.074999,5.863021) 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/4 1.29 GB 100.7 0.9 0.0 0.9 2.6 1.8 0.0 1.5 102.8 315.5 8.58 7.96 29 0.296 895K 1025 0.0 0.0 L1 1/0 3.57 MB 0.4 0.6 0.4 0.2 0.6 0.4 0.1 1.5 249.8 249.5 2.27 2.21 2 1.135 575K 526 0.0 0.0 L2 1/1 1.23 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.1 237.0 0.53 0.51 1 0.531 127K 38 0.0 0.0 L3 21/11 1.29 GB 0.4 0.2 0.2 0.0 0.2 0.2 0.4 1.1 213.7 213.7 1.19 1.07 2 0.593 257K 60 0.0 0.0 L4 174/0 9.71 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 108.0 108.1 1.04 0.67 1 1.039 113K 0 0.0 0.0 L5 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1246/16 97.92 GB 0.0 1.9 0.8 1.1 3.7 2.6 1.0 2.1 142.6 276.7 13.61 12.43 35 0.389 1970K 1649 0.0 0.0 Int 0/0 0.00 KB 0.0 1.9 0.8 1.1 3.7 2.6 0.9 2.1 142.6 276.7 13.61 12.43 35 0.389 1970K 1649 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.9 0.8 1.1 1.9 0.8 0.0 0.0 229.9 229.7 8.44 7.82 9 0.938 1970K 1649 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 353.4 5.17 4.61 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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.68 GB write, 620.30 MB/s write, 1.90 GB read, 319.66 MB/s read, 13.6 seconds Interval compaction: 3.68 GB write, 642.11 MB/s write, 1.90 GB read, 330.90 MB/s read, 13.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 382315 Average: 2.2597 StdDev: 16.06 Min: 0 Median: 1.4966 Max: 3902 Percentiles: P50: 1.50 P75: 1.89 P99: 5.76 P99.9: 11.93 P99.99: 20.34 ------------------------------------------------------ [ 0, 1 ] 71912 18.810% 18.810% #### ( 1, 2 ] 240133 62.810% 81.620% ############# ( 2, 3 ] 42022 10.991% 92.611% ## ( 3, 4 ] 15248 3.988% 96.600% # ( 4, 6 ] 10453 2.734% 99.334% # ( 6, 10 ] 1968 0.515% 99.849% ( 10, 15 ] 512 0.134% 99.982% ( 15, 22 ] 39 0.010% 99.993% ( 22, 34 ] 9 0.002% 99.995% ( 34, 51 ] 6 0.002% 99.997% ( 51, 76 ] 5 0.001% 99.998% ( 110, 170 ] 14 0.004% 100.002% ( 170, 250 ] 11 0.003% 100.004% ( 250, 380 ] 7 0.002% 100.006% ( 380, 580 ] 4 0.001% 100.007% ( 580, 870 ] 7 0.002% 100.009% ( 870, 1300 ] 4 0.001% 100.010% ( 1300, 1900 ] 3 0.001% 100.011% ( 1900, 2900 ] 3 0.001% 100.012% ( 2900, 4400 ] 5 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 77524 Average: 2.4027 StdDev: 17.03 Min: 1 Median: 1.5472 Max: 2741 Percentiles: P50: 1.55 P75: 1.95 P99: 5.81 P99.9: 12.23 P99.99: 651.80 ------------------------------------------------------ [ 0, 1 ] 12487 16.107% 16.107% ### ( 1, 2 ] 48021 61.943% 78.051% ############ ( 2, 3 ] 10095 13.022% 91.072% ### ( 3, 4 ] 3581 4.619% 95.692% # ( 4, 6 ] 2833 3.654% 99.346% # ( 6, 10 ] 384 0.495% 99.841% ( 10, 15 ] 102 0.132% 99.973% ( 15, 22 ] 6 0.008% 99.981% ( 110, 170 ] 2 0.003% 99.983% ( 250, 380 ] 4 0.005% 99.988% ( 380, 580 ] 1 0.001% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 4 0.005% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 31855 Average: 2.4418 StdDev: 5.34 Min: 1 Median: 1.6338 Max: 865 Percentiles: P50: 1.63 P75: 2.09 P99: 7.05 P99.9: 13.15 P99.99: 31.77 ------------------------------------------------------ [ 0, 1 ] 2850 8.947% 8.947% ## ( 1, 2 ] 20635 64.778% 73.725% ############# ( 2, 3 ] 4582 14.384% 88.109% ### ( 3, 4 ] 2072 6.504% 94.613% # ( 4, 6 ] 1309 4.109% 98.722% # ( 6, 10 ] 338 1.061% 99.783% ( 10, 15 ] 59 0.185% 99.969% ( 15, 22 ] 6 0.019% 99.987% ( 22, 34 ] 1 0.003% 99.991% ( 51, 76 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 172884 Average: 3.6265 StdDev: 38.91 Min: 0 Median: 1.6804 Max: 5670 Percentiles: P50: 1.68 P75: 2.31 P99: 9.36 P99.9: 216.08 P99.99: 628.72 ------------------------------------------------------ [ 0, 1 ] 15876 9.183% 9.183% ## ( 1, 2 ] 103711 59.989% 69.172% ############ ( 2, 3 ] 31999 18.509% 87.681% #### ( 3, 4 ] 9328 5.396% 93.076% # ( 4, 6 ] 7478 4.325% 97.402% # ( 6, 10 ] 3291 1.904% 99.305% ( 10, 15 ] 565 0.327% 99.632% ( 15, 22 ] 111 0.064% 99.696% ( 22, 34 ] 25 0.014% 99.711% ( 34, 51 ] 5 0.003% 99.714% ( 51, 76 ] 4 0.002% 99.716% ( 76, 110 ] 61 0.035% 99.751% ( 110, 170 ] 208 0.120% 99.872% ( 170, 250 ] 87 0.050% 99.922% ( 250, 380 ] 63 0.036% 99.958% ( 380, 580 ] 50 0.029% 99.987% ( 580, 870 ] 34 0.020% 100.007% ( 870, 1300 ] 12 0.007% 100.014% ( 1300, 1900 ] 11 0.006% 100.020% ( 1900, 2900 ] 6 0.003% 100.024% ( 2900, 4400 ] 5 0.003% 100.027% ( 4400, 6600 ] 3 0.002% 100.028% ** Level 4 read latency histogram (micros): Count: 315 Average: 136.3619 StdDev: 615.76 Min: 1 Median: 2.4345 Max: 5573 Percentiles: P50: 2.43 P75: 3.87 P99: 4175.00 P99.9: 5573.00 P99.99: 5573.00 ------------------------------------------------------ [ 0, 1 ] 26 8.254% 8.254% ## ( 1, 2 ] 95 30.159% 38.413% ###### ( 2, 3 ] 84 26.667% 65.079% ##### ( 3, 4 ] 36 11.429% 76.508% ## ( 4, 6 ] 23 7.302% 83.810% # ( 6, 10 ] 17 5.397% 89.206% # ( 10, 15 ] 7 2.222% 91.429% ( 76, 110 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 2 0.635% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 1 0.317% 99.048% ( 4400, 6600 ] 3 0.952% 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, 324.22 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.599 H:M:S, 9.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.06 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.395 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-00:58:29 ... thread 0: (1000000,3000000) ops and (330793.5,337607.6) ops/second in (3.023034,8.886055) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/12 2.27 GB 37.8 1.7 0.0 1.7 4.4 2.8 0.0 1.6 116.9 311.5 14.56 13.55 46 0.316 1727K 1854 0.0 0.0 L1 1/1 3.57 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.5 249.8 249.5 2.27 2.21 2 1.135 575K 526 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.1 237.0 0.53 0.51 1 0.531 127K 38 0.0 0.0 L3 17/0 801.53 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.9 235.9 235.6 5.02 4.59 3 1.675 1203K 1305 0.0 0.0 L4 174/0 9.53 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.5 1.0 108.0 108.1 1.04 0.67 1 1.039 113K 0 0.0 0.0 L5 1048/0 86.31 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 1254/13 98.90 GB 0.0 3.6 0.8 2.8 6.4 3.5 2.2 2.3 157.6 278.5 23.42 21.53 53 0.442 3748K 3723 0.0 0.0 Int 0/0 0.00 KB 0.0 3.6 0.8 2.8 6.4 3.5 2.1 2.3 157.6 278.5 23.42 21.53 53 0.442 3748K 3723 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.6 0.8 2.8 3.6 0.8 0.0 0.0 239.2 239.0 15.43 14.41 13 1.187 3748K 3723 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 354.7 7.99 7.13 40 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.37 GB write, 717.20 MB/s write, 3.60 GB read, 405.90 MB/s read, 23.4 seconds Interval compaction: 6.37 GB write, 733.83 MB/s write, 3.60 GB read, 415.31 MB/s read, 23.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 669253 Average: 2.2391 StdDev: 14.23 Min: 0 Median: 1.5004 Max: 3902 Percentiles: P50: 1.50 P75: 1.89 P99: 5.65 P99.9: 11.42 P99.99: 19.99 ------------------------------------------------------ [ 0, 1 ] 116977 17.479% 17.479% ### ( 1, 2 ] 434969 64.993% 82.472% ############# ( 2, 3 ] 73351 10.960% 93.432% ## ( 3, 4 ] 24431 3.650% 97.083% # ( 4, 6 ] 15554 2.324% 99.407% ( 6, 10 ] 3080 0.460% 99.867% ( 10, 15 ] 783 0.117% 99.984% ( 15, 22 ] 59 0.009% 99.993% ( 22, 34 ] 12 0.002% 99.994% ( 34, 51 ] 6 0.001% 99.995% ( 51, 76 ] 6 0.001% 99.996% ( 76, 110 ] 8 0.001% 99.997% ( 110, 170 ] 32 0.005% 100.002% ( 170, 250 ] 21 0.003% 100.005% ( 250, 380 ] 12 0.002% 100.007% ( 380, 580 ] 9 0.001% 100.009% ( 580, 870 ] 14 0.002% 100.011% ( 870, 1300 ] 9 0.001% 100.012% ( 1300, 1900 ] 5 0.001% 100.013% ( 1900, 2900 ] 5 0.001% 100.013% ( 2900, 4400 ] 6 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 105833 Average: 2.4835 StdDev: 16.13 Min: 1 Median: 1.5267 Max: 2741 Percentiles: P50: 1.53 P75: 1.92 P99: 6.18 P99.9: 79.94 P99.99: 610.21 ------------------------------------------------------ [ 0, 1 ] 17614 16.643% 16.643% ### ( 1, 2 ] 67025 63.331% 79.974% ############# ( 2, 3 ] 12564 11.872% 91.846% ## ( 3, 4 ] 4325 4.087% 95.932% # ( 4, 6 ] 3208 3.031% 98.963% # ( 6, 10 ] 847 0.800% 99.764% ( 10, 15 ] 130 0.123% 99.887% ( 15, 22 ] 6 0.006% 99.892% ( 51, 76 ] 4 0.004% 99.896% ( 76, 110 ] 36 0.034% 99.930% ( 110, 170 ] 37 0.035% 99.965% ( 170, 250 ] 5 0.005% 99.970% ( 250, 380 ] 16 0.015% 99.985% ( 380, 580 ] 5 0.005% 99.990% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31985 Average: 2.4537 StdDev: 5.69 Min: 1 Median: 1.6348 Max: 865 Percentiles: P50: 1.63 P75: 2.09 P99: 7.07 P99.9: 13.22 P99.99: 71.04 ------------------------------------------------------ [ 0, 1 ] 2850 8.910% 8.910% ## ( 1, 2 ] 20702 64.724% 73.635% ############# ( 2, 3 ] 4636 14.494% 88.129% ### ( 3, 4 ] 2075 6.487% 94.616% # ( 4, 6 ] 1311 4.099% 98.715% # ( 6, 10 ] 341 1.066% 99.781% ( 10, 15 ] 59 0.184% 99.966% ( 15, 22 ] 6 0.019% 99.984% ( 22, 34 ] 1 0.003% 99.987% ( 51, 76 ] 1 0.003% 99.991% ( 250, 380 ] 2 0.006% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239751 Average: 3.4428 StdDev: 34.00 Min: 0 Median: 1.6448 Max: 5670 Percentiles: P50: 1.64 P75: 2.18 P99: 9.22 P99.9: 212.40 P99.99: 630.93 ------------------------------------------------------ [ 0, 1 ] 23974 10.000% 10.000% ## ( 1, 2 ] 148733 62.036% 72.036% ############ ( 2, 3 ] 40093 16.723% 88.759% ### ( 3, 4 ] 11980 4.997% 93.756% # ( 4, 6 ] 9017 3.761% 97.517% # ( 6, 10 ] 4422 1.844% 99.361% ( 10, 15 ] 657 0.274% 99.635% ( 15, 22 ] 114 0.048% 99.683% ( 22, 34 ] 25 0.010% 99.693% ( 34, 51 ] 5 0.002% 99.695% ( 51, 76 ] 7 0.003% 99.698% ( 76, 110 ] 103 0.043% 99.741% ( 110, 170 ] 315 0.131% 99.872% ( 170, 250 ] 125 0.052% 99.925% ( 250, 380 ] 77 0.032% 99.957% ( 380, 580 ] 73 0.030% 99.987% ( 580, 870 ] 40 0.017% 100.004% ( 870, 1300 ] 14 0.006% 100.010% ( 1300, 1900 ] 11 0.005% 100.014% ( 1900, 2900 ] 6 0.003% 100.017% ( 2900, 4400 ] 5 0.002% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 315 Average: 136.3619 StdDev: 615.76 Min: 1 Median: 2.4345 Max: 5573 Percentiles: P50: 2.43 P75: 3.87 P99: 4175.00 P99.9: 5573.00 P99.99: 5573.00 ------------------------------------------------------ [ 0, 1 ] 26 8.254% 8.254% ## ( 1, 2 ] 95 30.159% 38.413% ###### ( 2, 3 ] 84 26.667% 65.079% ##### ( 3, 4 ] 36 11.429% 76.508% ## ( 4, 6 ] 23 7.302% 83.810% # ( 6, 10 ] 17 5.397% 89.206% # ( 10, 15 ] 7 2.222% 91.429% ( 76, 110 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 2 0.635% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 1 0.317% 99.048% ( 4400, 6600 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.2500 StdDev: 1143.22 Min: 93 Median: 250.0000 Max: 4139 Percentiles: P50: 250.00 P75: 1450.00 P99: 4139.00 P99.9: 4139.00 P99.99: 4139.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 9 22.500% 42.500% ##### ( 170, 250 ] 3 7.500% 50.000% ## ( 250, 380 ] 2 5.000% 55.000% # ( 380, 580 ] 4 10.000% 65.000% ## ( 580, 870 ] 2 5.000% 70.000% # ( 870, 1300 ] 1 2.500% 72.500% # ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.67 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.030 H:M:S, 11.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.56 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.431 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-00:58:32 ... thread 0: (1000000,4000000) ops and (329970.1,335665.3) ops/second in (3.030578,11.916633) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/12 3.20 GB 125.9 2.5 0.0 2.5 6.1 3.7 0.0 1.7 124.2 310.5 20.28 18.95 62 0.327 2558K 2686 0.0 0.0 L1 1/1 3.57 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.5 249.8 249.5 2.27 2.21 2 1.135 575K 526 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.1 237.0 0.53 0.51 1 0.531 127K 38 0.0 0.0 L3 17/0 801.53 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.9 235.9 235.6 5.02 4.59 3 1.675 1203K 1305 0.0 0.0 L4 174/0 9.53 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.5 1.0 108.0 108.1 1.04 0.67 1 1.039 113K 0 0.0 0.0 L5 1048/0 86.31 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 1258/13 99.82 GB 0.0 4.4 0.8 3.6 8.1 4.5 2.2 2.2 154.7 284.3 29.15 26.93 69 0.422 4579K 4555 0.0 0.0 Int 0/0 0.00 KB 0.0 4.4 0.8 3.6 8.1 4.5 2.1 2.2 154.7 284.3 29.15 26.93 69 0.422 4579K 4555 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.4 0.8 3.6 4.4 0.8 0.0 0.0 244.2 243.9 18.47 17.39 16 1.155 4579K 4555 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 354.1 10.67 9.54 53 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): 12.1 total, 11.9 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.09 GB write, 683.34 MB/s write, 4.40 GB read, 371.99 MB/s read, 29.1 seconds Interval compaction: 8.09 GB write, 695.16 MB/s write, 4.40 GB read, 378.42 MB/s read, 29.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 12, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1077764 Average: 2.2460 StdDev: 12.68 Min: 0 Median: 1.5115 Max: 3902 Percentiles: P50: 1.51 P75: 1.89 P99: 5.67 P99.9: 11.21 P99.99: 18.55 ------------------------------------------------------ [ 0, 1 ] 173140 16.065% 16.065% ### ( 1, 2 ] 715068 66.347% 82.412% ############# ( 2, 3 ] 120943 11.222% 93.634% ## ( 3, 4 ] 38411 3.564% 97.198% # ( 4, 6 ] 23241 2.156% 99.354% ( 6, 10 ] 5590 0.519% 99.873% ( 10, 15 ] 1214 0.113% 99.985% ( 15, 22 ] 99 0.009% 99.995% ( 22, 34 ] 12 0.001% 99.996% ( 34, 51 ] 8 0.001% 99.996% ( 51, 76 ] 10 0.001% 99.997% ( 76, 110 ] 37 0.003% 100.001% ( 110, 170 ] 74 0.007% 100.008% ( 170, 250 ] 46 0.004% 100.012% ( 250, 380 ] 26 0.002% 100.014% ( 380, 580 ] 17 0.002% 100.016% ( 580, 870 ] 20 0.002% 100.018% ( 870, 1300 ] 14 0.001% 100.019% ( 1300, 1900 ] 8 0.001% 100.020% ( 1900, 2900 ] 6 0.001% 100.020% ( 2900, 4400 ] 7 0.001% 100.021% ** Level 1 read latency histogram (micros): Count: 105833 Average: 2.4835 StdDev: 16.13 Min: 1 Median: 1.5267 Max: 2741 Percentiles: P50: 1.53 P75: 1.92 P99: 6.18 P99.9: 79.94 P99.99: 610.21 ------------------------------------------------------ [ 0, 1 ] 17614 16.643% 16.643% ### ( 1, 2 ] 67025 63.331% 79.974% ############# ( 2, 3 ] 12564 11.872% 91.846% ## ( 3, 4 ] 4325 4.087% 95.932% # ( 4, 6 ] 3208 3.031% 98.963% # ( 6, 10 ] 847 0.800% 99.764% ( 10, 15 ] 130 0.123% 99.887% ( 15, 22 ] 6 0.006% 99.892% ( 51, 76 ] 4 0.004% 99.896% ( 76, 110 ] 36 0.034% 99.930% ( 110, 170 ] 37 0.035% 99.965% ( 170, 250 ] 5 0.005% 99.970% ( 250, 380 ] 16 0.015% 99.985% ( 380, 580 ] 5 0.005% 99.990% ( 580, 870 ] 4 0.004% 99.993% ( 870, 1300 ] 4 0.004% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31985 Average: 2.4537 StdDev: 5.69 Min: 1 Median: 1.6348 Max: 865 Percentiles: P50: 1.63 P75: 2.09 P99: 7.07 P99.9: 13.22 P99.99: 71.04 ------------------------------------------------------ [ 0, 1 ] 2850 8.910% 8.910% ## ( 1, 2 ] 20702 64.724% 73.635% ############# ( 2, 3 ] 4636 14.494% 88.129% ### ( 3, 4 ] 2075 6.487% 94.616% # ( 4, 6 ] 1311 4.099% 98.715% # ( 6, 10 ] 341 1.066% 99.781% ( 10, 15 ] 59 0.184% 99.966% ( 15, 22 ] 6 0.019% 99.984% ( 22, 34 ] 1 0.003% 99.987% ( 51, 76 ] 1 0.003% 99.991% ( 250, 380 ] 2 0.006% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239751 Average: 3.4428 StdDev: 34.00 Min: 0 Median: 1.6448 Max: 5670 Percentiles: P50: 1.64 P75: 2.18 P99: 9.22 P99.9: 212.40 P99.99: 630.93 ------------------------------------------------------ [ 0, 1 ] 23974 10.000% 10.000% ## ( 1, 2 ] 148733 62.036% 72.036% ############ ( 2, 3 ] 40093 16.723% 88.759% ### ( 3, 4 ] 11980 4.997% 93.756% # ( 4, 6 ] 9017 3.761% 97.517% # ( 6, 10 ] 4422 1.844% 99.361% ( 10, 15 ] 657 0.274% 99.635% ( 15, 22 ] 114 0.048% 99.683% ( 22, 34 ] 25 0.010% 99.693% ( 34, 51 ] 5 0.002% 99.695% ( 51, 76 ] 7 0.003% 99.698% ( 76, 110 ] 103 0.043% 99.741% ( 110, 170 ] 315 0.131% 99.872% ( 170, 250 ] 125 0.052% 99.925% ( 250, 380 ] 77 0.032% 99.957% ( 380, 580 ] 73 0.030% 99.987% ( 580, 870 ] 40 0.017% 100.004% ( 870, 1300 ] 14 0.006% 100.010% ( 1300, 1900 ] 11 0.005% 100.014% ( 1900, 2900 ] 6 0.003% 100.017% ( 2900, 4400 ] 5 0.002% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 315 Average: 136.3619 StdDev: 615.76 Min: 1 Median: 2.4345 Max: 5573 Percentiles: P50: 2.43 P75: 3.87 P99: 4175.00 P99.9: 5573.00 P99.99: 5573.00 ------------------------------------------------------ [ 0, 1 ] 26 8.254% 8.254% ## ( 1, 2 ] 95 30.159% 38.413% ###### ( 2, 3 ] 84 26.667% 65.079% ##### ( 3, 4 ] 36 11.429% 76.508% ## ( 4, 6 ] 23 7.302% 83.810% # ( 6, 10 ] 17 5.397% 89.206% # ( 10, 15 ] 7 2.222% 91.429% ( 76, 110 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 2 0.635% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 1 0.317% 99.048% ( 4400, 6600 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.2500 StdDev: 1143.22 Min: 93 Median: 250.0000 Max: 4139 Percentiles: P50: 250.00 P75: 1450.00 P99: 4139.00 P99.9: 4139.00 P99.99: 4139.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 9 22.500% 42.500% ##### ( 170, 250 ] 3 7.500% 50.000% ## ( 250, 380 ] 2 5.000% 55.000% # ( 380, 580 ] 4 10.000% 65.000% ## ( 580, 870 ] 2 5.000% 70.000% # ( 870, 1300 ] 1 2.500% 72.500% # ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.69 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.439 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.409 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-00:58:35 ... thread 0: (1000000,5000000) ops and (269416.1,319931.1) ops/second in (3.711731,15.628364) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/8 2.52 GB 207.7 3.3 0.0 3.3 8.0 4.7 0.0 1.7 128.9 310.1 26.40 24.71 80 0.330 3454K 3705 0.0 0.0 L1 14/0 1.65 GB 169.0 2.2 2.0 0.2 2.2 2.0 0.1 1.1 239.5 238.1 9.48 9.18 3 3.159 2304K 13K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.1 237.0 0.53 0.51 1 0.531 127K 38 0.0 0.0 L3 17/0 801.53 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.9 235.9 235.6 5.02 4.59 3 1.675 1203K 1305 0.0 0.0 L4 174/0 9.53 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.5 1.0 108.0 108.1 1.04 0.67 1 1.039 113K 0 0.0 0.0 L5 1048/0 86.31 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 1269/8 100.79 GB 0.0 6.9 2.4 4.5 11.6 7.1 2.2 2.5 167.0 279.3 42.47 39.67 88 0.483 7204K 18K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 2.4 4.5 11.6 7.1 2.1 2.5 167.0 279.3 42.47 39.67 88 0.483 7204K 18K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.9 2.4 4.5 6.9 2.4 0.0 0.0 244.8 244.2 28.98 27.61 20 1.449 7204K 18K 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 354.8 13.50 12.06 68 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): 15.8 total, 15.6 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.59 GB write, 749.16 MB/s write, 6.93 GB read, 448.01 MB/s read, 42.5 seconds Interval compaction: 11.59 GB write, 759.04 MB/s write, 6.93 GB read, 453.92 MB/s read, 42.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 6, total-stops: 14, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1477258 Average: 2.2362 StdDev: 12.15 Min: 0 Median: 1.4971 Max: 3902 Percentiles: P50: 1.50 P75: 1.87 P99: 5.69 P99.9: 11.48 P99.99: 78.09 ------------------------------------------------------ [ 0, 1 ] 251785 17.044% 17.044% ### ( 1, 2 ] 979425 66.300% 83.344% ############# ( 2, 3 ] 156819 10.616% 93.960% ## ( 3, 4 ] 49773 3.369% 97.329% # ( 4, 6 ] 29174 1.975% 99.304% ( 6, 10 ] 8325 0.564% 99.868% ( 10, 15 ] 1632 0.110% 99.978% ( 15, 22 ] 136 0.009% 99.987% ( 22, 34 ] 14 0.001% 99.988% ( 34, 51 ] 13 0.001% 99.989% ( 51, 76 ] 11 0.001% 99.990% ( 76, 110 ] 86 0.006% 99.996% ( 110, 170 ] 157 0.011% 100.006% ( 170, 250 ] 70 0.005% 100.011% ( 250, 380 ] 49 0.003% 100.014% ( 380, 580 ] 37 0.003% 100.017% ( 580, 870 ] 35 0.002% 100.019% ( 870, 1300 ] 17 0.001% 100.020% ( 1300, 1900 ] 13 0.001% 100.021% ( 1900, 2900 ] 8 0.001% 100.022% ( 2900, 4400 ] 7 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 106808 Average: 2.7956 StdDev: 22.84 Min: 0 Median: 1.5266 Max: 2741 Percentiles: P50: 1.53 P75: 1.92 P99: 6.64 P99.9: 147.30 P99.99: 1195.21 ------------------------------------------------------ [ 0, 1 ] 17795 16.661% 16.661% ### ( 1, 2 ] 67617 63.307% 79.968% ############# ( 2, 3 ] 12623 11.818% 91.786% ## ( 3, 4 ] 4347 4.070% 95.856% # ( 4, 6 ] 3220 3.015% 98.871% # ( 6, 10 ] 862 0.807% 99.678% ( 10, 15 ] 131 0.123% 99.801% ( 15, 22 ] 6 0.006% 99.806% ( 51, 76 ] 8 0.007% 99.814% ( 76, 110 ] 58 0.054% 99.868% ( 110, 170 ] 55 0.051% 99.919% ( 170, 250 ] 16 0.015% 99.934% ( 250, 380 ] 30 0.028% 99.963% ( 380, 580 ] 13 0.012% 99.975% ( 580, 870 ] 8 0.007% 99.982% ( 870, 1300 ] 11 0.010% 99.993% ( 1300, 1900 ] 6 0.006% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31985 Average: 2.4537 StdDev: 5.69 Min: 1 Median: 1.6348 Max: 865 Percentiles: P50: 1.63 P75: 2.09 P99: 7.07 P99.9: 13.22 P99.99: 71.04 ------------------------------------------------------ [ 0, 1 ] 2850 8.910% 8.910% ## ( 1, 2 ] 20702 64.724% 73.635% ############# ( 2, 3 ] 4636 14.494% 88.129% ### ( 3, 4 ] 2075 6.487% 94.616% # ( 4, 6 ] 1311 4.099% 98.715% # ( 6, 10 ] 341 1.066% 99.781% ( 10, 15 ] 59 0.184% 99.966% ( 15, 22 ] 6 0.019% 99.984% ( 22, 34 ] 1 0.003% 99.987% ( 51, 76 ] 1 0.003% 99.991% ( 250, 380 ] 2 0.006% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239751 Average: 3.4428 StdDev: 34.00 Min: 0 Median: 1.6448 Max: 5670 Percentiles: P50: 1.64 P75: 2.18 P99: 9.22 P99.9: 212.40 P99.99: 630.93 ------------------------------------------------------ [ 0, 1 ] 23974 10.000% 10.000% ## ( 1, 2 ] 148733 62.036% 72.036% ############ ( 2, 3 ] 40093 16.723% 88.759% ### ( 3, 4 ] 11980 4.997% 93.756% # ( 4, 6 ] 9017 3.761% 97.517% # ( 6, 10 ] 4422 1.844% 99.361% ( 10, 15 ] 657 0.274% 99.635% ( 15, 22 ] 114 0.048% 99.683% ( 22, 34 ] 25 0.010% 99.693% ( 34, 51 ] 5 0.002% 99.695% ( 51, 76 ] 7 0.003% 99.698% ( 76, 110 ] 103 0.043% 99.741% ( 110, 170 ] 315 0.131% 99.872% ( 170, 250 ] 125 0.052% 99.925% ( 250, 380 ] 77 0.032% 99.957% ( 380, 580 ] 73 0.030% 99.987% ( 580, 870 ] 40 0.017% 100.004% ( 870, 1300 ] 14 0.006% 100.010% ( 1300, 1900 ] 11 0.005% 100.014% ( 1900, 2900 ] 6 0.003% 100.017% ( 2900, 4400 ] 5 0.002% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 315 Average: 136.3619 StdDev: 615.76 Min: 1 Median: 2.4345 Max: 5573 Percentiles: P50: 2.43 P75: 3.87 P99: 4175.00 P99.9: 5573.00 P99.99: 5573.00 ------------------------------------------------------ [ 0, 1 ] 26 8.254% 8.254% ## ( 1, 2 ] 95 30.159% 38.413% ###### ( 2, 3 ] 84 26.667% 65.079% ##### ( 3, 4 ] 36 11.429% 76.508% ## ( 4, 6 ] 23 7.302% 83.810% # ( 6, 10 ] 17 5.397% 89.206% # ( 10, 15 ] 7 2.222% 91.429% ( 76, 110 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 2 0.635% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 1 0.317% 99.048% ( 4400, 6600 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.2500 StdDev: 1143.22 Min: 93 Median: 250.0000 Max: 4139 Percentiles: P50: 250.00 P75: 1450.00 P99: 4139.00 P99.9: 4139.00 P99.99: 4139.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 9 22.500% 42.500% ##### ( 170, 250 ] 3 7.500% 50.000% ## ( 250, 380 ] 2 5.000% 55.000% # ( 380, 580 ] 4 10.000% 65.000% ## ( 580, 870 ] 2 5.000% 70.000% # ( 870, 1300 ] 1 2.500% 72.500% # ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 15.8 total, 3.7 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 310.73 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.504 H:M:S, 15.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 265.16 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.065 H:M:S, 28.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/25-00:58:38 ... thread 0: (1000000,6000000) ops and (335459.9,322418.6) ops/second in (2.980982,18.609346) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/4 3.50 GB 327.2 4.4 0.0 4.4 10.0 5.7 0.0 1.8 134.5 308.7 33.25 31.18 98 0.339 4541K 4817 0.0 0.0 L1 14/0 1.65 GB 169.0 2.2 2.0 0.2 2.2 2.0 0.1 1.1 239.5 238.1 9.48 9.18 3 3.159 2304K 13K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.5 2.0 237.1 237.0 0.53 0.51 1 0.531 127K 38 0.0 0.0 L3 17/0 801.53 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.9 235.9 235.6 5.02 4.59 3 1.675 1203K 1305 0.0 0.0 L4 174/0 9.53 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.5 1.0 108.0 108.1 1.04 0.67 1 1.039 113K 0 0.0 0.0 L5 1048/0 86.31 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 1271/4 101.78 GB 0.0 8.0 2.4 5.5 13.6 8.1 2.2 2.4 165.6 282.7 49.32 46.13 106 0.465 8291K 19K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.0 2.4 5.5 13.6 8.1 2.1 2.4 165.6 282.7 49.32 46.13 106 0.465 8291K 19K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.0 2.4 5.5 8.0 2.4 0.0 0.0 246.8 246.2 33.09 31.61 24 1.379 8291K 19K 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 357.1 16.23 14.52 82 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): 18.8 total, 18.6 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.61 GB write, 740.89 MB/s write, 7.97 GB read, 433.95 MB/s read, 49.3 seconds Interval compaction: 13.61 GB write, 749.10 MB/s write, 7.97 GB read, 438.76 MB/s read, 49.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, 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: 6, total-stops: 18, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1721923 Average: 2.1906 StdDev: 11.94 Min: 0 Median: 1.4732 Max: 3902 Percentiles: P50: 1.47 P75: 1.85 P99: 5.61 P99.9: 11.32 P99.99: 77.11 ------------------------------------------------------ [ 0, 1 ] 326128 18.940% 18.940% #### ( 1, 2 ] 1130268 65.640% 84.580% ############# ( 2, 3 ] 169341 9.834% 94.414% ## ( 3, 4 ] 53892 3.130% 97.544% # ( 4, 6 ] 31138 1.808% 99.352% ( 6, 10 ] 8952 0.520% 99.872% ( 10, 15 ] 1831 0.106% 99.978% ( 15, 22 ] 155 0.009% 99.987% ( 22, 34 ] 15 0.001% 99.988% ( 34, 51 ] 14 0.001% 99.989% ( 51, 76 ] 14 0.001% 99.990% ( 76, 110 ] 86 0.005% 99.995% ( 110, 170 ] 168 0.010% 100.005% ( 170, 250 ] 73 0.004% 100.009% ( 250, 380 ] 56 0.003% 100.012% ( 380, 580 ] 41 0.002% 100.014% ( 580, 870 ] 40 0.002% 100.017% ( 870, 1300 ] 18 0.001% 100.018% ( 1300, 1900 ] 16 0.001% 100.019% ( 1900, 2900 ] 9 0.001% 100.019% ( 2900, 4400 ] 8 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 106808 Average: 2.7956 StdDev: 22.84 Min: 0 Median: 1.5266 Max: 2741 Percentiles: P50: 1.53 P75: 1.92 P99: 6.64 P99.9: 147.30 P99.99: 1195.21 ------------------------------------------------------ [ 0, 1 ] 17795 16.661% 16.661% ### ( 1, 2 ] 67617 63.307% 79.968% ############# ( 2, 3 ] 12623 11.818% 91.786% ## ( 3, 4 ] 4347 4.070% 95.856% # ( 4, 6 ] 3220 3.015% 98.871% # ( 6, 10 ] 862 0.807% 99.678% ( 10, 15 ] 131 0.123% 99.801% ( 15, 22 ] 6 0.006% 99.806% ( 51, 76 ] 8 0.007% 99.814% ( 76, 110 ] 58 0.054% 99.868% ( 110, 170 ] 55 0.051% 99.919% ( 170, 250 ] 16 0.015% 99.934% ( 250, 380 ] 30 0.028% 99.963% ( 380, 580 ] 13 0.012% 99.975% ( 580, 870 ] 8 0.007% 99.982% ( 870, 1300 ] 11 0.010% 99.993% ( 1300, 1900 ] 6 0.006% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31985 Average: 2.4537 StdDev: 5.69 Min: 1 Median: 1.6348 Max: 865 Percentiles: P50: 1.63 P75: 2.09 P99: 7.07 P99.9: 13.22 P99.99: 71.04 ------------------------------------------------------ [ 0, 1 ] 2850 8.910% 8.910% ## ( 1, 2 ] 20702 64.724% 73.635% ############# ( 2, 3 ] 4636 14.494% 88.129% ### ( 3, 4 ] 2075 6.487% 94.616% # ( 4, 6 ] 1311 4.099% 98.715% # ( 6, 10 ] 341 1.066% 99.781% ( 10, 15 ] 59 0.184% 99.966% ( 15, 22 ] 6 0.019% 99.984% ( 22, 34 ] 1 0.003% 99.987% ( 51, 76 ] 1 0.003% 99.991% ( 250, 380 ] 2 0.006% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 239751 Average: 3.4428 StdDev: 34.00 Min: 0 Median: 1.6448 Max: 5670 Percentiles: P50: 1.64 P75: 2.18 P99: 9.22 P99.9: 212.40 P99.99: 630.93 ------------------------------------------------------ [ 0, 1 ] 23974 10.000% 10.000% ## ( 1, 2 ] 148733 62.036% 72.036% ############ ( 2, 3 ] 40093 16.723% 88.759% ### ( 3, 4 ] 11980 4.997% 93.756% # ( 4, 6 ] 9017 3.761% 97.517% # ( 6, 10 ] 4422 1.844% 99.361% ( 10, 15 ] 657 0.274% 99.635% ( 15, 22 ] 114 0.048% 99.683% ( 22, 34 ] 25 0.010% 99.693% ( 34, 51 ] 5 0.002% 99.695% ( 51, 76 ] 7 0.003% 99.698% ( 76, 110 ] 103 0.043% 99.741% ( 110, 170 ] 315 0.131% 99.872% ( 170, 250 ] 125 0.052% 99.925% ( 250, 380 ] 77 0.032% 99.957% ( 380, 580 ] 73 0.030% 99.987% ( 580, 870 ] 40 0.017% 100.004% ( 870, 1300 ] 14 0.006% 100.010% ( 1300, 1900 ] 11 0.005% 100.014% ( 1900, 2900 ] 6 0.003% 100.017% ( 2900, 4400 ] 5 0.002% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 315 Average: 136.3619 StdDev: 615.76 Min: 1 Median: 2.4345 Max: 5573 Percentiles: P50: 2.43 P75: 3.87 P99: 4175.00 P99.9: 5573.00 P99.99: 5573.00 ------------------------------------------------------ [ 0, 1 ] 26 8.254% 8.254% ## ( 1, 2 ] 95 30.159% 38.413% ###### ( 2, 3 ] 84 26.667% 65.079% ##### ( 3, 4 ] 36 11.429% 76.508% ## ( 4, 6 ] 23 7.302% 83.810% # ( 6, 10 ] 17 5.397% 89.206% # ( 10, 15 ] 7 2.222% 91.429% ( 76, 110 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 2 0.635% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 1 0.317% 99.048% ( 4400, 6600 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.2500 StdDev: 1143.22 Min: 93 Median: 250.0000 Max: 4139 Percentiles: P50: 250.00 P75: 1450.00 P99: 4139.00 P99.9: 4139.00 P99.99: 4139.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 9 22.500% 42.500% ##### ( 170, 250 ] 3 7.500% 50.000% ## ( 250, 380 ] 2 5.000% 55.000% # ( 380, 580 ] 4 10.000% 65.000% ## ( 580, 870 ] 2 5.000% 70.000% # ( 870, 1300 ] 1 2.500% 72.500% # ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 18.8 total, 3.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 313.81 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.897 H:M:S, 15.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.16 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.393 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/25-00:59:08 ... thread 0: (1000000,7000000) ops and (34036.0,145863.7) ops/second in (29.380664,47.990010) 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 5/5 692.48 MB 0.0 5.4 0.0 5.4 12.1 6.6 0.0 1.8 138.5 308.2 40.04 37.59 118 0.339 5628K 5897 0.0 0.0 L1 7/7 514.56 MB 0.0 7.7 5.8 1.8 7.5 5.7 0.1 1.3 221.7 217.5 35.45 31.82 4 8.863 7982K 152K 0.0 0.0 L2 37/36 4.46 GB 0.8 0.1 0.1 0.1 0.1 0.1 5.4 2.0 237.1 237.0 0.53 0.51 1 0.531 127K 38 0.0 0.0 L3 21/3 1.14 GB 0.9 1.5 0.6 0.9 1.5 0.6 0.4 2.6 232.8 232.4 6.79 6.30 4 1.699 1606K 2863 0.0 0.0 L4 174/0 9.53 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.5 1.0 108.0 108.1 1.04 0.67 1 1.039 113K 0 0.0 0.0 L5 1048/0 86.31 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 1292/51 102.62 GB 0.0 14.9 6.6 8.3 21.4 13.1 7.0 3.2 181.6 260.8 83.85 76.89 128 0.655 15M 161K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.9 6.6 8.3 21.4 13.1 6.9 3.2 181.6 260.8 83.85 76.89 128 0.655 15M 161K 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.9 6.6 8.3 14.7 6.4 0.0 0.0 234.8 232.3 64.84 59.88 30 2.161 15M 161K 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 357.9 19.01 17.01 98 0.194 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): 48.2 total, 48.0 interval Flush(GB): cumulative 6.644, interval 6.644 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.36 GB write, 453.71 MB/s write, 14.87 GB read, 315.89 MB/s read, 83.9 seconds Interval compaction: 21.36 GB write, 455.66 MB/s write, 14.87 GB read, 317.24 MB/s read, 83.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: 18, pending-compaction-bytes-delays: 3, pending-compaction-bytes-stops: 0, total-delays: 22, total-stops: 18, interval: 40 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3059205 Average: 2.9661 StdDev: 18.07 Min: 0 Median: 1.4193 Max: 4055 Percentiles: P50: 1.42 P75: 1.81 P99: 8.69 P99.9: 164.97 P99.99: 448.97 ------------------------------------------------------ [ 0, 1 ] 713620 23.327% 23.327% ##### ( 1, 2 ] 1946168 63.617% 86.944% ############# ( 2, 3 ] 226288 7.397% 94.341% # ( 3, 4 ] 79006 2.583% 96.923% # ( 4, 6 ] 50421 1.648% 98.571% ( 6, 10 ] 19470 0.636% 99.208% ( 10, 15 ] 3238 0.106% 99.314% ( 15, 22 ] 365 0.012% 99.326% ( 22, 34 ] 23 0.001% 99.326% ( 34, 51 ] 15 0.000% 99.327% ( 51, 76 ] 1197 0.039% 99.366% ( 76, 110 ] 9404 0.307% 99.673% ( 110, 170 ] 7565 0.247% 99.921% ( 170, 250 ] 1092 0.036% 99.956% ( 250, 380 ] 805 0.026% 99.983% ( 380, 580 ] 644 0.021% 100.004% ( 580, 870 ] 180 0.006% 100.010% ( 870, 1300 ] 32 0.001% 100.011% ( 1300, 1900 ] 28 0.001% 100.012% ( 1900, 2900 ] 17 0.001% 100.012% ( 2900, 4400 ] 20 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 944255 Average: 2.9982 StdDev: 18.65 Min: 0 Median: 1.5367 Max: 3928 Percentiles: P50: 1.54 P75: 1.97 P99: 8.47 P99.9: 122.64 P99.99: 160.25 ------------------------------------------------------ [ 0, 1 ] 180814 19.149% 19.149% #### ( 1, 2 ] 542768 57.481% 76.630% ########### ( 2, 3 ] 111896 11.850% 88.480% ## ( 3, 4 ] 50935 5.394% 93.874% # ( 4, 6 ] 41190 4.362% 98.236% # ( 6, 10 ] 11657 1.235% 99.471% ( 10, 15 ] 1635 0.173% 99.644% ( 15, 22 ] 181 0.019% 99.663% ( 22, 34 ] 6 0.001% 99.664% ( 34, 51 ] 4 0.000% 99.664% ( 51, 76 ] 161 0.017% 99.681% ( 76, 110 ] 1780 0.189% 99.870% ( 110, 170 ] 1356 0.144% 100.014% ( 170, 250 ] 237 0.025% 100.039% ( 250, 380 ] 220 0.023% 100.062% ( 380, 580 ] 150 0.016% 100.078% ( 580, 870 ] 75 0.008% 100.086% ( 870, 1300 ] 38 0.004% 100.090% ( 1300, 1900 ] 28 0.003% 100.093% ( 1900, 2900 ] 4 0.000% 100.093% ( 2900, 4400 ] 4 0.000% 100.094% ** Level 2 read latency histogram (micros): Count: 31985 Average: 2.4537 StdDev: 5.69 Min: 1 Median: 1.6348 Max: 865 Percentiles: P50: 1.63 P75: 2.09 P99: 7.07 P99.9: 13.22 P99.99: 71.04 ------------------------------------------------------ [ 0, 1 ] 2850 8.910% 8.910% ## ( 1, 2 ] 20702 64.724% 73.635% ############# ( 2, 3 ] 4636 14.494% 88.129% ### ( 3, 4 ] 2075 6.487% 94.616% # ( 4, 6 ] 1311 4.099% 98.715% # ( 6, 10 ] 341 1.066% 99.781% ( 10, 15 ] 59 0.184% 99.966% ( 15, 22 ] 6 0.019% 99.984% ( 22, 34 ] 1 0.003% 99.987% ( 51, 76 ] 1 0.003% 99.991% ( 250, 380 ] 2 0.006% 99.997% ( 580, 870 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 254120 Average: 3.5970 StdDev: 35.20 Min: 0 Median: 1.6573 Max: 5670 Percentiles: P50: 1.66 P75: 2.23 P99: 9.32 P99.9: 243.14 P99.99: 714.13 ------------------------------------------------------ [ 0, 1 ] 24215 9.529% 9.529% ## ( 1, 2 ] 156458 61.569% 71.098% ############ ( 2, 3 ] 43377 17.069% 88.167% ### ( 3, 4 ] 13354 5.255% 93.422% # ( 4, 6 ] 10263 4.039% 97.461% # ( 6, 10 ] 4716 1.856% 99.316% ( 10, 15 ] 718 0.283% 99.599% ( 15, 22 ] 120 0.047% 99.646% ( 22, 34 ] 25 0.010% 99.656% ( 34, 51 ] 5 0.002% 99.658% ( 51, 76 ] 7 0.003% 99.661% ( 76, 110 ] 103 0.041% 99.701% ( 110, 170 ] 365 0.144% 99.845% ( 170, 250 ] 153 0.060% 99.905% ( 250, 380 ] 97 0.038% 99.943% ( 380, 580 ] 95 0.037% 99.981% ( 580, 870 ] 51 0.020% 100.001% ( 870, 1300 ] 18 0.007% 100.008% ( 1300, 1900 ] 13 0.005% 100.013% ( 1900, 2900 ] 6 0.002% 100.015% ( 2900, 4400 ] 6 0.002% 100.018% ( 4400, 6600 ] 3 0.001% 100.019% ** Level 4 read latency histogram (micros): Count: 315 Average: 136.3619 StdDev: 615.76 Min: 1 Median: 2.4345 Max: 5573 Percentiles: P50: 2.43 P75: 3.87 P99: 4175.00 P99.9: 5573.00 P99.99: 5573.00 ------------------------------------------------------ [ 0, 1 ] 26 8.254% 8.254% ## ( 1, 2 ] 95 30.159% 38.413% ###### ( 2, 3 ] 84 26.667% 65.079% ##### ( 3, 4 ] 36 11.429% 76.508% ## ( 4, 6 ] 23 7.302% 83.810% # ( 6, 10 ] 17 5.397% 89.206% # ( 10, 15 ] 7 2.222% 91.429% ( 76, 110 ] 1 0.317% 91.746% ( 110, 170 ] 1 0.317% 92.063% ( 170, 250 ] 1 0.317% 92.381% ( 250, 380 ] 2 0.635% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 1 0.317% 99.048% ( 4400, 6600 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.2500 StdDev: 1143.22 Min: 93 Median: 250.0000 Max: 4139 Percentiles: P50: 250.00 P75: 1450.00 P99: 4139.00 P99.9: 4139.00 P99.99: 4139.00 ------------------------------------------------------ ( 76, 110 ] 8 20.000% 20.000% #### ( 110, 170 ] 9 22.500% 42.500% ##### ( 170, 250 ] 3 7.500% 50.000% ## ( 250, 380 ] 2 5.000% 55.000% # ( 380, 580 ] 4 10.000% 65.000% ## ( 580, 870 ] 2 5.000% 70.000% # ( 870, 1300 ] 1 2.500% 72.500% # ( 1300, 1900 ] 4 10.000% 82.500% ## ( 1900, 2900 ] 4 10.000% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 48.2 total, 29.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 142.94 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:29.008 H:M:S, 60.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 33.50 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:26.111 H:M:S, 88.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/25-00:59:16 ... thread 0: (1000000,8000000) ops and (117652.2,141618.9) ops/second in (8.499632,56.489642) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/4 944.17 MB 18.9 6.0 0.0 6.0 13.6 7.6 0.0 1.8 133.9 301.7 46.12 42.63 133 0.347 6268K 6617 0.0 0.0 L1 8/8 487.45 MB 0.0 8.9 6.5 2.3 8.7 6.4 0.1 1.3 218.6 214.8 41.49 37.15 5 8.298 8686K 152K 0.0 0.0 L2 1/1 105.28 MB 0.0 0.3 0.1 0.1 0.3 0.1 6.0 2.2 179.7 179.2 1.47 1.18 2 0.735 268K 653 0.0 0.0 L3 63/10 4.94 GB 4.2 7.9 5.7 2.2 7.8 5.6 0.4 1.4 197.9 197.2 40.74 35.36 14 2.910 6690K 17K 0.0 0.0 L4 178/7 9.78 GB 1.0 1.0 0.9 0.1 1.0 0.9 0.9 1.1 146.2 146.0 7.33 5.04 10 0.733 1068K 0 0.0 0.0 L5 1060/0 87.29 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1317/30 103.51 GB 0.0 24.1 13.2 10.8 31.4 20.6 9.1 4.2 179.6 234.7 137.15 121.36 164 0.836 22M 176K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.1 13.2 10.8 31.4 20.6 8.9 4.2 179.6 234.7 137.15 121.36 164 0.836 22M 176K 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 24.1 13.2 10.8 23.9 13.0 0.0 0.0 214.5 212.8 114.85 101.83 53 2.167 22M 176K 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 347.6 22.29 19.53 111 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): 56.7 total, 56.5 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: 31.44 GB write, 567.80 MB/s write, 24.06 GB read, 434.55 MB/s read, 137.1 seconds Interval compaction: 31.44 GB write, 569.88 MB/s write, 24.06 GB read, 436.14 MB/s read, 137.1 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: 21, pending-compaction-bytes-delays: 26, pending-compaction-bytes-stops: 0, total-delays: 45, total-stops: 21, interval: 66 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3370673 Average: 3.1461 StdDev: 22.00 Min: 0 Median: 1.4540 Max: 13358 Percentiles: P50: 1.45 P75: 1.85 P99: 9.08 P99.9: 180.81 P99.99: 540.74 ------------------------------------------------------ [ 0, 1 ] 724156 21.484% 21.484% #### ( 1, 2 ] 2117200 62.812% 84.296% ############# ( 2, 3 ] 291974 8.662% 92.959% ## ( 3, 4 ] 106643 3.164% 96.122% # ( 4, 6 ] 76411 2.267% 98.389% ( 6, 10 ] 26695 0.792% 99.181% ( 10, 15 ] 4800 0.142% 99.324% ( 15, 22 ] 549 0.016% 99.340% ( 22, 34 ] 31 0.001% 99.341% ( 34, 51 ] 17 0.001% 99.341% ( 51, 76 ] 1200 0.036% 99.377% ( 76, 110 ] 9537 0.283% 99.660% ( 110, 170 ] 7904 0.234% 99.895% ( 170, 250 ] 1371 0.041% 99.935% ( 250, 380 ] 1082 0.032% 99.967% ( 380, 580 ] 953 0.028% 99.996% ( 580, 870 ] 363 0.011% 100.006% ( 870, 1300 ] 113 0.003% 100.010% ( 1300, 1900 ] 52 0.002% 100.011% ( 1900, 2900 ] 27 0.001% 100.012% ( 2900, 4400 ] 24 0.001% 100.013% ( 9900, 14000 ] 1 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 2232552 Average: 4.2563 StdDev: 52.13 Min: 0 Median: 1.7488 Max: 20047 Percentiles: P50: 1.75 P75: 2.60 P99: 9.30 P99.9: 144.36 P99.99: 283.76 ------------------------------------------------------ [ 0, 1 ] 197007 8.824% 8.824% ## ( 1, 2 ] 1227692 54.991% 63.815% ########### ( 2, 3 ] 419093 18.772% 82.587% #### ( 3, 4 ] 174970 7.837% 90.424% ## ( 4, 6 ] 156227 6.998% 97.422% # ( 6, 10 ] 42708 1.913% 99.335% ( 10, 15 ] 8324 0.373% 99.707% ( 15, 22 ] 935 0.042% 99.749% ( 22, 34 ] 51 0.002% 99.752% ( 34, 51 ] 20 0.001% 99.753% ( 51, 76 ] 182 0.008% 99.761% ( 76, 110 ] 1972 0.088% 99.849% ( 110, 170 ] 1988 0.089% 99.938% ( 170, 250 ] 899 0.040% 99.978% ( 250, 380 ] 1004 0.045% 100.023% ( 380, 580 ] 1000 0.045% 100.068% ( 580, 870 ] 818 0.037% 100.105% ( 870, 1300 ] 418 0.019% 100.123% ( 1300, 1900 ] 180 0.008% 100.132% ( 1900, 2900 ] 130 0.006% 100.137% ( 2900, 4400 ] 109 0.005% 100.142% ( 4400, 6600 ] 15 0.001% 100.143% ( 6600, 9900 ] 6 0.000% 100.143% ( 9900, 14000 ] 3 0.000% 100.143% ( 14000, 22000 ] 3 0.000% 100.143% ** Level 2 read latency histogram (micros): Count: 50786 Average: 5.4146 StdDev: 64.03 Min: 1 Median: 1.7525 Max: 4727 Percentiles: P50: 1.75 P75: 2.57 P99: 9.40 P99.9: 872.97 P99.99: 3176.42 ------------------------------------------------------ [ 0, 1 ] 3073 6.051% 6.051% # ( 1, 2 ] 29662 58.406% 64.457% ############ ( 2, 3 ] 9468 18.643% 83.100% #### ( 3, 4 ] 4061 7.996% 91.096% ## ( 4, 6 ] 3315 6.527% 97.623% # ( 6, 10 ] 824 1.622% 99.246% ( 10, 15 ] 183 0.360% 99.606% ( 15, 22 ] 18 0.035% 99.642% ( 22, 34 ] 1 0.002% 99.644% ( 51, 76 ] 1 0.002% 99.646% ( 76, 110 ] 4 0.008% 99.653% ( 110, 170 ] 11 0.022% 99.675% ( 170, 250 ] 12 0.024% 99.699% ( 250, 380 ] 27 0.053% 99.752% ( 380, 580 ] 41 0.081% 99.833% ( 580, 870 ] 35 0.069% 99.902% ( 870, 1300 ] 31 0.061% 99.963% ( 1300, 1900 ] 6 0.012% 99.974% ( 1900, 2900 ] 8 0.016% 99.990% ( 2900, 4400 ] 5 0.010% 100.000% ( 4400, 6600 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 792433 Average: 6.1052 StdDev: 77.71 Min: 0 Median: 1.8895 Max: 19887 Percentiles: P50: 1.89 P75: 2.85 P99: 9.98 P99.9: 504.61 P99.99: 814.22 ------------------------------------------------------ [ 0, 1 ] 28760 3.629% 3.629% # ( 1, 2 ] 413109 52.132% 55.761% ########## ( 2, 3 ] 178478 22.523% 78.284% ##### ( 3, 4 ] 75398 9.515% 87.799% ## ( 4, 6 ] 70492 8.896% 96.694% ## ( 6, 10 ] 18343 2.315% 99.009% ( 10, 15 ] 4157 0.525% 99.534% ( 15, 22 ] 576 0.073% 99.606% ( 22, 34 ] 51 0.006% 99.613% ( 34, 51 ] 13 0.002% 99.614% ( 51, 76 ] 21 0.003% 99.617% ( 76, 110 ] 166 0.021% 99.638% ( 110, 170 ] 631 0.080% 99.718% ( 170, 250 ] 497 0.063% 99.780% ( 250, 380 ] 529 0.067% 99.847% ( 380, 580 ] 675 0.085% 99.932% ( 580, 870 ] 568 0.072% 100.004% ( 870, 1300 ] 358 0.045% 100.049% ( 1300, 1900 ] 171 0.022% 100.071% ( 1900, 2900 ] 142 0.018% 100.089% ( 2900, 4400 ] 109 0.014% 100.102% ( 4400, 6600 ] 12 0.002% 100.104% ( 6600, 9900 ] 2 0.000% 100.104% ( 9900, 14000 ] 1 0.000% 100.104% ( 14000, 22000 ] 2 0.000% 100.104% ** Level 4 read latency histogram (micros): Count: 29169 Average: 37.9560 StdDev: 223.90 Min: 1 Median: 2.2624 Max: 5573 Percentiles: P50: 2.26 P75: 3.58 P99: 1062.92 P99.9: 3165.05 P99.99: 4358.32 ------------------------------------------------------ [ 0, 1 ] 275 0.943% 0.943% ( 1, 2 ] 12476 42.771% 43.714% ######### ( 2, 3 ] 6988 23.957% 67.671% ##### ( 3, 4 ] 3694 12.664% 80.335% ### ( 4, 6 ] 3391 11.625% 91.961% ## ( 6, 10 ] 824 2.825% 94.786% # ( 10, 15 ] 217 0.744% 95.530% ( 15, 22 ] 23 0.079% 95.608% ( 22, 34 ] 4 0.014% 95.622% ( 51, 76 ] 5 0.017% 95.639% ( 76, 110 ] 26 0.089% 95.728% ( 110, 170 ] 76 0.261% 95.989% ( 170, 250 ] 121 0.415% 96.404% ( 250, 380 ] 152 0.521% 96.925% ( 380, 580 ] 246 0.843% 97.768% ( 580, 870 ] 279 0.956% 98.725% ( 870, 1300 ] 179 0.614% 99.338% ( 1300, 1900 ] 108 0.370% 99.709% ( 1900, 2900 ] 50 0.171% 99.880% ( 2900, 4400 ] 33 0.113% 99.993% ( 4400, 6600 ] 5 0.017% 100.010% ** Level 5 read latency histogram (micros): Count: 100 Average: 934.8600 StdDev: 1106.73 Min: 77 Median: 354.0000 Max: 4139 Percentiles: P50: 354.00 P75: 1480.00 P99: 4139.00 P99.9: 4139.00 P99.99: 4139.00 ------------------------------------------------------ ( 76, 110 ] 11 11.000% 11.000% ## ( 110, 170 ] 20 20.000% 31.000% #### ( 170, 250 ] 11 11.000% 42.000% ## ( 250, 380 ] 10 10.000% 52.000% ## ( 380, 580 ] 8 8.000% 60.000% ## ( 580, 870 ] 10 10.000% 70.000% ## ( 870, 1300 ] 2 2.000% 72.000% ( 1300, 1900 ] 10 10.000% 82.000% ## ( 1900, 2900 ] 10 10.000% 92.000% ## ( 2900, 4400 ] 8 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 56.7 total, 8.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 138.87 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:34.695 H:M:S, 61.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 115.79 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:5.687 H:M:S, 66.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 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 : 7.078 micros/op 141281 ops/sec 60.241 seconds 8510999 operations; 136.9 MB/s Microseconds per write: Count: 8510999 Average: 7.0780 StdDev: 466.50 Min: 1 Median: 1.7521 Max: 718034 Percentiles: P50: 1.75 P75: 2.72 P99: 9.07 P99.9: 1951.81 P99.99: 2822.05 ------------------------------------------------------ [ 0, 1 ] 1059685 12.451% 12.451% ## ( 1, 2 ] 4249152 49.925% 62.376% ########## ( 2, 3 ] 1482220 17.415% 79.792% ### ( 3, 4 ] 1147583 13.484% 93.275% ### ( 4, 6 ] 416543 4.894% 98.169% # ( 6, 10 ] 92185 1.083% 99.252% ( 10, 15 ] 25677 0.302% 99.554% ( 15, 22 ] 6219 0.073% 99.627% ( 22, 34 ] 1403 0.016% 99.644% ( 34, 51 ] 152 0.002% 99.645% ( 51, 76 ] 28 0.000% 99.646% ( 76, 110 ] 6276 0.074% 99.719% ( 110, 170 ] 2006 0.024% 99.743% ( 170, 250 ] 231 0.003% 99.746% ( 250, 380 ] 97 0.001% 99.747% ( 380, 580 ] 18 0.000% 99.747% ( 580, 870 ] 29 0.000% 99.747% ( 870, 1300 ] 12426 0.146% 99.893% ( 1300, 1900 ] 102 0.001% 99.895% ( 1900, 2900 ] 8802 0.103% 99.998% ( 2900, 4400 ] 110 0.001% 99.999% ( 4400, 6600 ] 25 0.000% 100.000% ( 6600, 9900 ] 7 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 11 0.000% 100.000% ( 570000, 860000 ] 3 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 205297 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 : 8510999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 8783350968 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 : 526 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 36865804 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 : 31248697238 rocksdb.compact.write.bytes COUNT : 31034758105 rocksdb.flush.write.bytes COUNT : 8719445738 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 : 29 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 : 220 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 : 8649226240 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3443712 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 : 31325819421 rocksdb.non.last.level.read.count COUNT : 7573116 rocksdb.block.checksum.compute.count COUNT : 7572094 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.413052 P95 : 3.855880 P99 : 7.615288 P100 : 718032.000000 COUNT : 8510999 SUM : 56285884 rocksdb.compaction.times.micros P50 : 989736.842105 P95 : 5730000.000000 P99 : 23430000.000000 P100 : 25973635.000000 COUNT : 87 SUM : 145361902 rocksdb.compaction.times.cpu_micros P50 : 567738.095238 P95 : 5730000.000000 P99 : 22633749.000000 P100 : 22633749.000000 COUNT : 87 SUM : 118895460 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 : 680.220588 P95 : 6847.500000 P99 : 19660.000000 P100 : 21969.000000 COUNT : 117 SUM : 169689 rocksdb.compaction.outfile.sync.micros P50 : 1052.750000 P95 : 29786.842105 P99 : 59083.333333 P100 : 124585.000000 COUNT : 391 SUM : 2220578 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 106.851852 P95 : 1813.333333 P99 : 3835.000000 P100 : 4280.000000 COUNT : 226 SUM : 88027 rocksdb.table.open.io.micros P50 : 1480.000000 P95 : 5947.857143 P99 : 9603.000000 P100 : 11208.000000 COUNT : 526 SUM : 1021879 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.717853 P95 : 8.482646 P99 : 13.970331 P100 : 35833.000000 COUNT : 7570815 SUM : 57891608 rocksdb.read.block.get.micros P50 : 453.600000 P95 : 2981.818182 P99 : 4505.600000 P100 : 6783.000000 COUNT : 1052 SUM : 857542 rocksdb.write.raw.block.micros P50 : 0.514273 P95 : 0.977118 P99 : 2.880348 P100 : 35883.000000 COUNT : 9632416 SUM : 19995713 rocksdb.numfiles.in.singlecompaction P50 : 2.428571 P95 : 9.600000 P99 : 21.090000 P100 : 31.000000 COUNT : 126 SUM : 461 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.566963 P95 : 1296.074394 P99 : 2707.592761 P100 : 717853.000000 COUNT : 182349 SUM : 36881326 rocksdb.sst.read.micros P50 : 1.655779 P95 : 5.130216 P99 : 9.885213 P100 : 35829.000000 COUNT : 7573629 SUM : 42274836 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 : 8510999 SUM : 8783350968 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 : 206417.910448 P95 : 373500.000000 P99 : 835350.000000 P100 : 904078.000000 COUNT : 117 SUM : 25954584 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 : 346 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