[2024-11-17 00:55:32.865129] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-11-17 00:55:32.865276] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1199821 ] Set seed to 1731801332861677 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-17 00:55:32.949736] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-17 00:55:32.991082] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-17 00:55:32.991132] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1199821' to capture a snapshot of events at runtime. [2024-11-17 00:55:32.991142] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-17 00:55:32.991152] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-17 00:55:32.991160] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1199821 for offline analysis/debug. [2024-11-17 00:55:32.991245] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Nov 17 00:55:37 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/17-00:55:39 ... thread 0: (1000000,1000000) ops and (360120.3,360120.3) ops/second in (2.776850,2.776850) 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 352.6 2.32 2.10 12 0.194 0 0 0.0 0.0 L1 3/3 188.89 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 255.9 255.8 0.74 0.71 1 0.738 191K 72 0.0 0.0 L2 2/1 125.97 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 11/0 867.38 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.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 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.3 1.4 87.5 315.2 3.60 3.33 14 0.257 319K 113 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.3 1.4 87.5 315.2 3.60 3.33 14 0.257 319K 113 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.3 0.2 0.1 0.3 0.2 0.0 0.0 247.1 247.0 1.27 1.23 2 0.637 319K 113 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 352.6 2.32 2.10 12 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): 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, 381.18 MB/s write, 0.31 GB read, 105.89 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 408.16 MB/s write, 0.31 GB read, 113.38 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: 113416 Average: 1.8055 StdDev: 12.35 Min: 0 Median: 1.1642 Max: 3088 Percentiles: P50: 1.16 P75: 1.63 P99: 4.29 P99.9: 10.23 P99.99: 264.26 ------------------------------------------------------ [ 0, 1 ] 46791 41.256% 41.256% ######## ( 1, 2 ] 60389 53.246% 94.502% ########### ( 2, 3 ] 3495 3.082% 97.583% # ( 3, 4 ] 1491 1.315% 98.898% ( 4, 6 ] 826 0.728% 99.626% ( 6, 10 ] 310 0.273% 99.899% ( 10, 15 ] 77 0.068% 99.967% ( 15, 22 ] 11 0.010% 99.977% ( 22, 34 ] 5 0.004% 99.981% ( 51, 76 ] 1 0.001% 99.982% ( 110, 170 ] 6 0.005% 99.988% ( 170, 250 ] 5 0.004% 99.992% ( 250, 380 ] 6 0.005% 99.997% ( 380, 580 ] 2 0.002% 99.999% ( 870, 1300 ] 2 0.002% 100.001% ( 1300, 1900 ] 2 0.002% 100.003% ( 2900, 4400 ] 1 0.001% 100.004% ** Level 1 read latency histogram (micros): Count: 26947 Average: 1.7607 StdDev: 5.04 Min: 1 Median: 1.1981 Max: 664 Percentiles: P50: 1.20 P75: 1.65 P99: 3.92 P99.9: 9.63 P99.99: 194.42 ------------------------------------------------------ [ 0, 1 ] 10518 39.032% 39.032% ######## ( 1, 2 ] 14921 55.372% 94.404% ########### ( 2, 3 ] 930 3.451% 97.855% # ( 3, 4 ] 334 1.239% 99.095% ( 4, 6 ] 178 0.661% 99.755% ( 6, 10 ] 43 0.160% 99.915% ( 10, 15 ] 14 0.052% 99.967% ( 15, 22 ] 5 0.019% 99.985% ( 110, 170 ] 1 0.004% 99.989% ( 170, 250 ] 1 0.004% 99.993% ( 250, 380 ] 1 0.004% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 4523 Average: 6.7736 StdDev: 104.12 Min: 1 Median: 1.9755 Max: 4714 Percentiles: P50: 1.98 P75: 3.10 P99: 11.33 P99.9: 718.33 P99.99: 4714.00 ------------------------------------------------------ [ 0, 1 ] 254 5.616% 5.616% # ( 1, 2 ] 2058 45.501% 51.117% ######### ( 2, 3 ] 1037 22.927% 74.044% ##### ( 3, 4 ] 430 9.507% 83.551% ## ( 4, 6 ] 474 10.480% 94.031% ## ( 6, 10 ] 216 4.776% 98.806% # ( 10, 15 ] 33 0.730% 99.536% ( 15, 22 ] 6 0.133% 99.668% ( 22, 34 ] 2 0.044% 99.713% ( 76, 110 ] 1 0.022% 99.735% ( 250, 380 ] 4 0.088% 99.823% ( 380, 580 ] 3 0.066% 99.889% ( 580, 870 ] 1 0.022% 99.912% ( 1300, 1900 ] 1 0.022% 99.934% ( 2900, 4400 ] 2 0.044% 99.978% ( 4400, 6600 ] 1 0.022% 100.000% ** Level 3 read latency histogram (micros): Count: 45 Average: 1613.3778 StdDev: 1467.74 Min: 280 Median: 791.9231 Max: 5753 Percentiles: P50: 791.92 P75: 2475.00 P99: 5753.00 P99.9: 5753.00 P99.99: 5753.00 ------------------------------------------------------ ( 250, 380 ] 5 11.111% 11.111% ## ( 380, 580 ] 8 17.778% 28.889% #### ( 580, 870 ] 13 28.889% 57.778% ###### ( 870, 1300 ] 1 2.222% 60.000% ( 1300, 1900 ] 1 2.222% 62.222% ( 1900, 2900 ] 10 22.222% 84.444% #### ( 2900, 4400 ] 3 6.667% 91.111% # ( 4400, 6600 ] 4 8.889% 100.000% ## ** Level 4 read latency histogram (micros): Count: 25 Average: 1691.6400 StdDev: 1454.69 Min: 108 Median: 1138.7500 Max: 5793 Percentiles: P50: 1138.75 P75: 2483.33 P99: 5793.00 P99.9: 5793.00 P99.99: 5793.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 110, 170 ] 1 4.000% 8.000% # ( 170, 250 ] 2 8.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 5 20.000% 40.000% #### ( 870, 1300 ] 4 16.000% 56.000% ### ( 1300, 1900 ] 3 12.000% 68.000% ## ( 1900, 2900 ] 3 12.000% 80.000% ## ( 2900, 4400 ] 4 16.000% 96.000% ### ( 4400, 6600 ] 1 4.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, 330.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:0.192 H:M:S, 6.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 354.15 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.192 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-00:55:43 ... thread 0: (1000000,2000000) ops and (326568.8,342524.9) ops/second in (3.062142,5.838992) 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 1.29 GB 75.5 0.6 0.0 0.6 2.3 1.8 0.0 1.3 77.1 325.4 7.35 6.76 28 0.263 575K 664 0.0 0.0 L1 1/0 3.35 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.5 248.6 248.3 2.28 2.20 2 1.140 575K 575 0.0 0.0 L2 2/2 117.61 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 75/32 1.22 GB 0.3 0.5 0.4 0.1 0.5 0.4 0.1 1.3 181.3 181.2 2.73 2.29 2 1.364 502K 342 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 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/42 97.92 GB 0.0 1.7 0.8 0.9 3.5 2.6 0.7 2.0 136.0 277.5 12.90 11.77 33 0.391 1781K 1622 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.8 0.9 3.5 2.6 0.7 2.0 136.0 277.5 12.90 11.77 33 0.391 1781K 1622 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.7 0.8 0.9 1.7 0.8 0.0 0.0 227.1 226.9 7.73 7.15 7 1.104 1781K 1622 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.1 5.17 4.62 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.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.50 GB write, 593.01 MB/s write, 1.71 GB read, 290.66 MB/s read, 12.9 seconds Interval compaction: 3.50 GB write, 612.97 MB/s write, 1.71 GB read, 300.44 MB/s read, 12.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 357518 Average: 2.1837 StdDev: 11.18 Min: 0 Median: 1.4609 Max: 3088 Percentiles: P50: 1.46 P75: 1.86 P99: 5.74 P99.9: 11.39 P99.99: 20.07 ------------------------------------------------------ [ 0, 1 ] 76763 21.471% 21.471% #### ( 1, 2 ] 221300 61.899% 83.370% ############ ( 2, 3 ] 33756 9.442% 92.812% ## ( 3, 4 ] 13580 3.798% 96.610% # ( 4, 6 ] 9798 2.741% 99.351% # ( 6, 10 ] 1854 0.519% 99.869% ( 10, 15 ] 396 0.111% 99.980% ( 15, 22 ] 50 0.014% 99.994% ( 22, 34 ] 11 0.003% 99.997% ( 34, 51 ] 1 0.000% 99.997% ( 51, 76 ] 3 0.001% 99.998% ( 110, 170 ] 9 0.003% 100.001% ( 170, 250 ] 12 0.003% 100.004% ( 250, 380 ] 12 0.003% 100.008% ( 380, 580 ] 5 0.001% 100.009% ( 580, 870 ] 3 0.001% 100.010% ( 870, 1300 ] 8 0.002% 100.012% ( 1300, 1900 ] 4 0.001% 100.013% ( 1900, 2900 ] 2 0.001% 100.014% ( 2900, 4400 ] 1 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 119470 Average: 2.3516 StdDev: 7.86 Min: 1 Median: 1.5978 Max: 2115 Percentiles: P50: 1.60 P75: 2.01 P99: 5.87 P99.9: 12.24 P99.99: 52.32 ------------------------------------------------------ [ 0, 1 ] 15641 13.092% 13.092% ### ( 1, 2 ] 73766 61.744% 74.836% ############ ( 2, 3 ] 18983 15.889% 90.726% ### ( 3, 4 ] 5540 4.637% 95.363% # ( 4, 6 ] 4651 3.893% 99.256% # ( 6, 10 ] 702 0.588% 99.843% ( 10, 15 ] 151 0.126% 99.970% ( 15, 22 ] 22 0.018% 99.988% ( 22, 34 ] 2 0.002% 99.990% ( 51, 76 ] 1 0.001% 99.991% ( 76, 110 ] 1 0.001% 99.992% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 2 0.002% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31899 Average: 2.9847 StdDev: 39.25 Min: 1 Median: 1.6623 Max: 4714 Percentiles: P50: 1.66 P75: 2.23 P99: 7.68 P99.9: 14.37 P99.99: 1786.06 ------------------------------------------------------ [ 0, 1 ] 2589 8.116% 8.116% ## ( 1, 2 ] 20173 63.240% 71.356% ############# ( 2, 3 ] 5122 16.057% 87.413% ### ( 3, 4 ] 1893 5.934% 93.348% # ( 4, 6 ] 1635 5.126% 98.473% # ( 6, 10 ] 400 1.254% 99.727% ( 10, 15 ] 63 0.197% 99.925% ( 15, 22 ] 9 0.028% 99.953% ( 22, 34 ] 2 0.006% 99.959% ( 76, 110 ] 1 0.003% 99.962% ( 250, 380 ] 4 0.013% 99.975% ( 380, 580 ] 3 0.009% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 1300, 1900 ] 1 0.003% 99.991% ( 2900, 4400 ] 2 0.006% 99.997% ( 4400, 6600 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 173422 Average: 3.6193 StdDev: 38.66 Min: 0 Median: 1.6909 Max: 5753 Percentiles: P50: 1.69 P75: 2.34 P99: 9.30 P99.9: 225.07 P99.99: 634.69 ------------------------------------------------------ [ 0, 1 ] 14023 8.086% 8.086% ## ( 1, 2 ] 105208 60.666% 68.752% ############ ( 2, 3 ] 31573 18.206% 86.958% #### ( 3, 4 ] 9712 5.600% 92.558% # ( 4, 6 ] 8506 4.905% 97.463% # ( 6, 10 ] 3230 1.863% 99.325% ( 10, 15 ] 469 0.270% 99.596% ( 15, 22 ] 98 0.057% 99.652% ( 22, 34 ] 63 0.036% 99.689% ( 34, 51 ] 22 0.013% 99.701% ( 51, 76 ] 6 0.003% 99.705% ( 76, 110 ] 73 0.042% 99.747% ( 110, 170 ] 205 0.118% 99.865% ( 170, 250 ] 88 0.051% 99.916% ( 250, 380 ] 65 0.037% 99.953% ( 380, 580 ] 58 0.033% 99.987% ( 580, 870 ] 30 0.017% 100.004% ( 870, 1300 ] 8 0.005% 100.009% ( 1300, 1900 ] 4 0.002% 100.011% ( 1900, 2900 ] 10 0.006% 100.017% ( 2900, 4400 ] 3 0.002% 100.018% ( 4400, 6600 ] 4 0.002% 100.021% ** Level 4 read latency histogram (micros): Count: 25 Average: 1691.6400 StdDev: 1454.69 Min: 108 Median: 1138.7500 Max: 5793 Percentiles: P50: 1138.75 P75: 2483.33 P99: 5793.00 P99.9: 5793.00 P99.99: 5793.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 110, 170 ] 1 4.000% 8.000% # ( 170, 250 ] 2 8.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 5 20.000% 40.000% #### ( 870, 1300 ] 4 16.000% 56.000% ### ( 1300, 1900 ] 3 12.000% 68.000% ## ( 1900, 2900 ] 3 12.000% 80.000% ## ( 2900, 4400 ] 4 16.000% 96.000% ### ( 4400, 6600 ] 1 4.000% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 326.05 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.574 H:M:S, 9.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.41 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.382 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/17-00:55:46 ... thread 0: (1000000,3000000) ops and (334503.0,339808.5) ops/second in (2.989510,8.828502) 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/4 2.27 GB 201.4 1.7 0.0 1.7 4.4 2.8 0.0 1.6 116.9 311.7 14.55 13.56 46 0.316 1727K 1880 0.0 0.0 L1 1/0 3.35 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.5 248.6 248.3 2.28 2.20 2 1.140 575K 575 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 21/0 917.81 MB 0.9 1.5 0.5 1.0 1.5 0.5 0.1 3.0 214.9 214.7 7.08 6.31 4 1.771 1515K 1487 0.0 0.0 L4 169/0 9.73 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 181.8 181.8 0.73 0.60 1 0.727 110K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1249/4 98.90 GB 0.0 4.0 1.0 2.9 6.7 3.8 1.3 2.4 160.8 273.3 25.17 23.19 54 0.466 4056K 3983 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.0 2.9 6.7 3.8 1.3 2.4 160.8 273.3 25.17 23.19 54 0.466 4056K 3983 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.0 1.0 2.9 3.9 1.0 0.0 0.0 235.1 234.9 17.22 16.09 14 1.230 4056K 3983 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 356.3 7.96 7.10 40 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): 9.0 total, 8.8 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.72 GB write, 762.12 MB/s write, 3.95 GB read, 448.52 MB/s read, 25.2 seconds Interval compaction: 6.72 GB write, 779.10 MB/s write, 3.95 GB read, 458.51 MB/s read, 25.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: 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: 601769 Average: 2.1549 StdDev: 10.42 Min: 0 Median: 1.4530 Max: 3088 Percentiles: P50: 1.45 P75: 1.85 P99: 5.66 P99.9: 10.43 P99.99: 19.06 ------------------------------------------------------ [ 0, 1 ] 130620 21.706% 21.706% #### ( 1, 2 ] 375866 62.460% 84.166% ############ ( 2, 3 ] 54460 9.050% 93.216% ## ( 3, 4 ] 22191 3.688% 96.904% # ( 4, 6 ] 15163 2.520% 99.424% # ( 6, 10 ] 2821 0.469% 99.892% ( 10, 15 ] 550 0.091% 99.984% ( 15, 22 ] 67 0.011% 99.995% ( 22, 34 ] 14 0.002% 99.997% ( 34, 51 ] 3 0.000% 99.998% ( 51, 76 ] 4 0.001% 99.998% ( 110, 170 ] 12 0.002% 100.000% ( 170, 250 ] 23 0.004% 100.004% ( 250, 380 ] 19 0.003% 100.007% ( 380, 580 ] 9 0.001% 100.009% ( 580, 870 ] 8 0.001% 100.010% ( 870, 1300 ] 11 0.002% 100.012% ( 1300, 1900 ] 6 0.001% 100.013% ( 1900, 2900 ] 2 0.000% 100.013% ( 2900, 4400 ] 2 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 142939 Average: 2.3798 StdDev: 7.20 Min: 1 Median: 1.6182 Max: 2115 Percentiles: P50: 1.62 P75: 2.08 P99: 5.90 P99.9: 11.99 P99.99: 21.92 ------------------------------------------------------ [ 0, 1 ] 16616 11.625% 11.625% ## ( 1, 2 ] 88732 62.077% 73.701% ############ ( 2, 3 ] 23446 16.403% 90.104% ### ( 3, 4 ] 7088 4.959% 95.063% # ( 4, 6 ] 5914 4.137% 99.200% # ( 6, 10 ] 932 0.652% 99.852% ( 10, 15 ] 171 0.120% 99.972% ( 15, 22 ] 26 0.018% 99.990% ( 22, 34 ] 2 0.001% 99.992% ( 51, 76 ] 1 0.001% 99.992% ( 76, 110 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 170, 250 ] 1 0.001% 99.994% ( 250, 380 ] 3 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 2 0.001% 99.999% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 265293 Average: 3.3561 StdDev: 32.33 Min: 0 Median: 1.6683 Max: 5753 Percentiles: P50: 1.67 P75: 2.26 P99: 8.92 P99.9: 210.75 P99.99: 598.37 ------------------------------------------------------ [ 0, 1 ] 22702 8.557% 8.557% ## ( 1, 2 ] 164509 62.010% 70.568% ############ ( 2, 3 ] 45817 17.270% 87.838% ### ( 3, 4 ] 14328 5.401% 93.239% # ( 4, 6 ] 12128 4.572% 97.810% # ( 6, 10 ] 4318 1.628% 99.438% ( 10, 15 ] 610 0.230% 99.668% ( 15, 22 ] 112 0.042% 99.710% ( 22, 34 ] 65 0.025% 99.735% ( 34, 51 ] 22 0.008% 99.743% ( 51, 76 ] 7 0.003% 99.746% ( 76, 110 ] 100 0.038% 99.783% ( 110, 170 ] 244 0.092% 99.875% ( 170, 250 ] 129 0.049% 99.924% ( 250, 380 ] 91 0.034% 99.958% ( 380, 580 ] 82 0.031% 99.989% ( 580, 870 ] 39 0.015% 100.004% ( 870, 1300 ] 11 0.004% 100.008% ( 1300, 1900 ] 4 0.002% 100.009% ( 1900, 2900 ] 10 0.004% 100.013% ( 2900, 4400 ] 3 0.001% 100.014% ( 4400, 6600 ] 4 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 110 Average: 393.7909 StdDev: 988.70 Min: 0 Median: 2.6000 Max: 5793 Percentiles: P50: 2.60 P75: 93.00 P99: 4362.50 P99.9: 5793.00 P99.99: 5793.00 ------------------------------------------------------ [ 0, 1 ] 40 36.364% 36.364% ####### ( 1, 2 ] 12 10.909% 47.273% ## ( 2, 3 ] 5 4.545% 51.818% # ( 3, 4 ] 3 2.727% 54.545% # ( 4, 6 ] 4 3.636% 58.182% # ( 6, 10 ] 1 0.909% 59.091% ( 10, 15 ] 10 9.091% 68.182% ## ( 15, 22 ] 6 5.455% 73.636% # ( 22, 34 ] 1 0.909% 74.545% ( 76, 110 ] 1 0.909% 75.455% ( 110, 170 ] 2 1.818% 77.273% ( 170, 250 ] 4 3.636% 80.909% # ( 380, 580 ] 1 0.909% 81.818% ( 580, 870 ] 5 4.545% 86.364% # ( 870, 1300 ] 4 3.636% 90.000% # ( 1300, 1900 ] 3 2.727% 92.727% # ( 1900, 2900 ] 3 2.727% 95.455% # ( 2900, 4400 ] 4 3.636% 99.091% # ( 4400, 6600 ] 1 0.909% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 899.5000 StdDev: 1095.23 Min: 132 Median: 336.6667 Max: 4019 Percentiles: P50: 336.67 P75: 1300.00 P99: 4019.00 P99.9: 4019.00 P99.99: 4019.00 ------------------------------------------------------ ( 110, 170 ] 4 20.000% 20.000% #### ( 170, 250 ] 4 20.000% 40.000% #### ( 250, 380 ] 3 15.000% 55.000% ### ( 380, 580 ] 3 15.000% 70.000% ### ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 327.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.938 H:M:S, 10.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.364 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-00:55:48 ... thread 0: (1000000,4000000) ops and (339699.6,339781.3) ops/second in (2.943777,11.772279) 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/4 3.26 GB 302.1 2.8 0.0 2.8 6.5 3.7 0.0 1.7 131.8 310.2 21.52 20.17 64 0.336 2878K 3133 0.0 0.0 L1 1/0 3.35 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.5 248.6 248.3 2.28 2.20 2 1.140 575K 575 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 21/0 917.81 MB 0.9 1.5 0.5 1.0 1.5 0.5 0.1 3.0 214.9 214.7 7.08 6.31 4 1.771 1515K 1487 0.0 0.0 L4 169/0 9.73 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 181.8 181.8 0.73 0.60 1 0.727 110K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/4 99.88 GB 0.0 5.1 1.0 4.0 8.8 4.8 1.3 2.3 161.2 280.6 32.14 29.80 72 0.446 5207K 5236 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 1.0 4.0 8.8 4.8 1.3 2.3 161.2 280.6 32.14 29.80 72 0.446 5207K 5236 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.1 1.0 4.0 5.1 1.0 0.0 0.0 241.7 241.5 21.44 20.24 18 1.191 5207K 5236 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 359.0 10.71 9.57 54 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): 12.0 total, 11.8 interval Flush(GB): cumulative 3.753, interval 3.753 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.81 GB write, 753.53 MB/s write, 5.06 GB read, 432.96 MB/s read, 32.1 seconds Interval compaction: 8.81 GB write, 766.12 MB/s write, 5.06 GB read, 440.19 MB/s read, 32.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 860435 Average: 2.0899 StdDev: 11.12 Min: 0 Median: 1.4129 Max: 4065 Percentiles: P50: 1.41 P75: 1.82 P99: 5.54 P99.9: 10.17 P99.99: 18.50 ------------------------------------------------------ [ 0, 1 ] 210700 24.488% 24.488% ##### ( 1, 2 ] 531647 61.788% 86.276% ############ ( 2, 3 ] 68555 7.967% 94.243% ## ( 3, 4 ] 27217 3.163% 97.406% # ( 4, 6 ] 17761 2.064% 99.471% ( 6, 10 ] 3670 0.427% 99.897% ( 10, 15 ] 756 0.088% 99.985% ( 15, 22 ] 88 0.010% 99.995% ( 22, 34 ] 16 0.002% 99.997% ( 34, 51 ] 4 0.000% 99.998% ( 51, 76 ] 6 0.001% 99.998% ( 110, 170 ] 20 0.002% 100.001% ( 170, 250 ] 29 0.003% 100.004% ( 250, 380 ] 25 0.003% 100.007% ( 380, 580 ] 11 0.001% 100.008% ( 580, 870 ] 15 0.002% 100.010% ( 870, 1300 ] 13 0.002% 100.011% ( 1300, 1900 ] 7 0.001% 100.012% ( 1900, 2900 ] 5 0.001% 100.013% ( 2900, 4400 ] 3 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 142939 Average: 2.3798 StdDev: 7.20 Min: 1 Median: 1.6182 Max: 2115 Percentiles: P50: 1.62 P75: 2.08 P99: 5.90 P99.9: 11.99 P99.99: 21.92 ------------------------------------------------------ [ 0, 1 ] 16616 11.625% 11.625% ## ( 1, 2 ] 88732 62.077% 73.701% ############ ( 2, 3 ] 23446 16.403% 90.104% ### ( 3, 4 ] 7088 4.959% 95.063% # ( 4, 6 ] 5914 4.137% 99.200% # ( 6, 10 ] 932 0.652% 99.852% ( 10, 15 ] 171 0.120% 99.972% ( 15, 22 ] 26 0.018% 99.990% ( 22, 34 ] 2 0.001% 99.992% ( 51, 76 ] 1 0.001% 99.992% ( 76, 110 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 170, 250 ] 1 0.001% 99.994% ( 250, 380 ] 3 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 2 0.001% 99.999% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 265293 Average: 3.3561 StdDev: 32.33 Min: 0 Median: 1.6683 Max: 5753 Percentiles: P50: 1.67 P75: 2.26 P99: 8.92 P99.9: 210.75 P99.99: 598.37 ------------------------------------------------------ [ 0, 1 ] 22702 8.557% 8.557% ## ( 1, 2 ] 164509 62.010% 70.568% ############ ( 2, 3 ] 45817 17.270% 87.838% ### ( 3, 4 ] 14328 5.401% 93.239% # ( 4, 6 ] 12128 4.572% 97.810% # ( 6, 10 ] 4318 1.628% 99.438% ( 10, 15 ] 610 0.230% 99.668% ( 15, 22 ] 112 0.042% 99.710% ( 22, 34 ] 65 0.025% 99.735% ( 34, 51 ] 22 0.008% 99.743% ( 51, 76 ] 7 0.003% 99.746% ( 76, 110 ] 100 0.038% 99.783% ( 110, 170 ] 244 0.092% 99.875% ( 170, 250 ] 129 0.049% 99.924% ( 250, 380 ] 91 0.034% 99.958% ( 380, 580 ] 82 0.031% 99.989% ( 580, 870 ] 39 0.015% 100.004% ( 870, 1300 ] 11 0.004% 100.008% ( 1300, 1900 ] 4 0.002% 100.009% ( 1900, 2900 ] 10 0.004% 100.013% ( 2900, 4400 ] 3 0.001% 100.014% ( 4400, 6600 ] 4 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 110 Average: 393.7909 StdDev: 988.70 Min: 0 Median: 2.6000 Max: 5793 Percentiles: P50: 2.60 P75: 93.00 P99: 4362.50 P99.9: 5793.00 P99.99: 5793.00 ------------------------------------------------------ [ 0, 1 ] 40 36.364% 36.364% ####### ( 1, 2 ] 12 10.909% 47.273% ## ( 2, 3 ] 5 4.545% 51.818% # ( 3, 4 ] 3 2.727% 54.545% # ( 4, 6 ] 4 3.636% 58.182% # ( 6, 10 ] 1 0.909% 59.091% ( 10, 15 ] 10 9.091% 68.182% ## ( 15, 22 ] 6 5.455% 73.636% # ( 22, 34 ] 1 0.909% 74.545% ( 76, 110 ] 1 0.909% 75.455% ( 110, 170 ] 2 1.818% 77.273% ( 170, 250 ] 4 3.636% 80.909% # ( 380, 580 ] 1 0.909% 81.818% ( 580, 870 ] 5 4.545% 86.364% # ( 870, 1300 ] 4 3.636% 90.000% # ( 1300, 1900 ] 3 2.727% 92.727% # ( 1900, 2900 ] 3 2.727% 95.455% # ( 2900, 4400 ] 4 3.636% 99.091% # ( 4400, 6600 ] 1 0.909% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 899.5000 StdDev: 1095.23 Min: 132 Median: 336.6667 Max: 4019 Percentiles: P50: 336.67 P75: 1300.00 P99: 4019.00 P99.9: 4019.00 P99.99: 4019.00 ------------------------------------------------------ ( 110, 170 ] 4 20.000% 20.000% #### ( 170, 250 ] 4 20.000% 40.000% #### ( 250, 380 ] 3 15.000% 55.000% ### ( 380, 580 ] 3 15.000% 70.000% ### ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.0 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 328.88 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.276 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, 334.33 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.338 H:M:S, 11.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-00:55:52 ... thread 0: (1000000,5000000) ops and (278644.5,325497.9) ops/second in (3.588802,15.361081) 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/18 4.18 GB 6.3 3.8 0.0 3.8 8.5 4.7 0.0 1.8 139.2 309.7 28.06 26.37 83 0.338 3965K 4201 0.0 0.0 L1 1/1 3.35 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.5 248.6 248.3 2.28 2.20 2 1.140 575K 575 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 0.4 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 21/0 917.81 MB 0.9 1.5 0.5 1.0 1.5 0.5 0.1 3.0 214.9 214.7 7.08 6.31 4 1.771 1515K 1487 0.0 0.0 L4 169/0 9.73 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.3 1.0 181.8 181.8 0.73 0.60 1 0.727 110K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1254/19 100.81 GB 0.0 6.1 1.0 5.1 10.8 5.7 1.3 2.3 161.7 285.2 38.68 36.00 91 0.425 6295K 6304 0.0 0.0 Int 0/0 0.00 KB 0.0 6.1 1.0 5.1 10.8 5.7 1.3 2.3 161.7 285.2 38.68 36.00 91 0.425 6295K 6304 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.1 1.0 5.1 6.1 1.0 0.0 0.0 246.1 245.9 25.41 24.13 22 1.155 6295K 6304 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 360.6 13.28 11.87 69 0.192 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.6 total, 15.4 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.78 GB write, 709.22 MB/s write, 6.11 GB read, 401.92 MB/s read, 38.7 seconds Interval compaction: 10.78 GB write, 718.30 MB/s write, 6.11 GB read, 407.07 MB/s read, 38.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, 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: 7, total-stops: 10, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1144841 Average: 2.0616 StdDev: 11.00 Min: 0 Median: 1.3743 Max: 4065 Percentiles: P50: 1.37 P75: 1.79 P99: 5.42 P99.9: 11.37 P99.99: 131.23 ------------------------------------------------------ [ 0, 1 ] 311810 27.236% 27.236% ##### ( 1, 2 ] 696299 60.821% 88.057% ############ ( 2, 3 ] 79597 6.953% 95.009% # ( 3, 4 ] 31680 2.767% 97.777% # ( 4, 6 ] 19681 1.719% 99.496% ( 6, 10 ] 4393 0.384% 99.879% ( 10, 15 ] 860 0.075% 99.954% ( 15, 22 ] 110 0.010% 99.964% ( 22, 34 ] 17 0.001% 99.966% ( 34, 51 ] 6 0.001% 99.966% ( 51, 76 ] 12 0.001% 99.967% ( 76, 110 ] 218 0.019% 99.986% ( 110, 170 ] 123 0.011% 99.997% ( 170, 250 ] 46 0.004% 100.001% ( 250, 380 ] 37 0.003% 100.004% ( 380, 580 ] 21 0.002% 100.006% ( 580, 870 ] 24 0.002% 100.008% ( 870, 1300 ] 16 0.001% 100.010% ( 1300, 1900 ] 10 0.001% 100.010% ( 1900, 2900 ] 5 0.000% 100.011% ( 2900, 4400 ] 4 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 142940 Average: 2.3809 StdDev: 7.22 Min: 1 Median: 1.6182 Max: 2115 Percentiles: P50: 1.62 P75: 2.08 P99: 5.90 P99.9: 12.02 P99.99: 26.24 ------------------------------------------------------ [ 0, 1 ] 16616 11.624% 11.624% ## ( 1, 2 ] 88732 62.076% 73.701% ############ ( 2, 3 ] 23446 16.403% 90.104% ### ( 3, 4 ] 7088 4.959% 95.062% # ( 4, 6 ] 5914 4.137% 99.200% # ( 6, 10 ] 932 0.652% 99.852% ( 10, 15 ] 171 0.120% 99.971% ( 15, 22 ] 26 0.018% 99.990% ( 22, 34 ] 2 0.001% 99.991% ( 51, 76 ] 1 0.001% 99.992% ( 76, 110 ] 1 0.001% 99.992% ( 110, 170 ] 2 0.001% 99.994% ( 170, 250 ] 1 0.001% 99.994% ( 250, 380 ] 3 0.002% 99.997% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 2 0.001% 99.999% ( 870, 1300 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 265293 Average: 3.3561 StdDev: 32.33 Min: 0 Median: 1.6683 Max: 5753 Percentiles: P50: 1.67 P75: 2.26 P99: 8.92 P99.9: 210.75 P99.99: 598.37 ------------------------------------------------------ [ 0, 1 ] 22702 8.557% 8.557% ## ( 1, 2 ] 164509 62.010% 70.568% ############ ( 2, 3 ] 45817 17.270% 87.838% ### ( 3, 4 ] 14328 5.401% 93.239% # ( 4, 6 ] 12128 4.572% 97.810% # ( 6, 10 ] 4318 1.628% 99.438% ( 10, 15 ] 610 0.230% 99.668% ( 15, 22 ] 112 0.042% 99.710% ( 22, 34 ] 65 0.025% 99.735% ( 34, 51 ] 22 0.008% 99.743% ( 51, 76 ] 7 0.003% 99.746% ( 76, 110 ] 100 0.038% 99.783% ( 110, 170 ] 244 0.092% 99.875% ( 170, 250 ] 129 0.049% 99.924% ( 250, 380 ] 91 0.034% 99.958% ( 380, 580 ] 82 0.031% 99.989% ( 580, 870 ] 39 0.015% 100.004% ( 870, 1300 ] 11 0.004% 100.008% ( 1300, 1900 ] 4 0.002% 100.009% ( 1900, 2900 ] 10 0.004% 100.013% ( 2900, 4400 ] 3 0.001% 100.014% ( 4400, 6600 ] 4 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 110 Average: 393.7909 StdDev: 988.70 Min: 0 Median: 2.6000 Max: 5793 Percentiles: P50: 2.60 P75: 93.00 P99: 4362.50 P99.9: 5793.00 P99.99: 5793.00 ------------------------------------------------------ [ 0, 1 ] 40 36.364% 36.364% ####### ( 1, 2 ] 12 10.909% 47.273% ## ( 2, 3 ] 5 4.545% 51.818% # ( 3, 4 ] 3 2.727% 54.545% # ( 4, 6 ] 4 3.636% 58.182% # ( 6, 10 ] 1 0.909% 59.091% ( 10, 15 ] 10 9.091% 68.182% ## ( 15, 22 ] 6 5.455% 73.636% # ( 22, 34 ] 1 0.909% 74.545% ( 76, 110 ] 1 0.909% 75.455% ( 110, 170 ] 2 1.818% 77.273% ( 170, 250 ] 4 3.636% 80.909% # ( 380, 580 ] 1 0.909% 81.818% ( 580, 870 ] 5 4.545% 86.364% # ( 870, 1300 ] 4 3.636% 90.000% # ( 1300, 1900 ] 3 2.727% 92.727% # ( 1900, 2900 ] 3 2.727% 95.455% # ( 2900, 4400 ] 4 3.636% 99.091% # ( 4400, 6600 ] 1 0.909% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 899.5000 StdDev: 1095.23 Min: 132 Median: 336.6667 Max: 4019 Percentiles: P50: 336.67 P75: 1300.00 P99: 4019.00 P99.9: 4019.00 P99.99: 4019.00 ------------------------------------------------------ ( 110, 170 ] 4 20.000% 20.000% #### ( 170, 250 ] 4 20.000% 40.000% #### ( 250, 380 ] 3 15.000% 55.000% ### ( 380, 580 ] 3 15.000% 70.000% ### ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.6 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 316.28 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.285 H:M:S, 14.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 274.24 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.009 H:M:S, 28.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-00:56:15 ... thread 0: (1000000,6000000) ops and (43031.7,155441.4) ops/second in (23.238679,38.599760) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/11 1.05 GB 0.0 4.1 0.0 4.1 9.7 5.7 0.0 1.7 122.1 292.3 34.04 29.96 97 0.351 4221K 4459 0.0 0.0 L1 5/5 258.71 MB 0.0 4.7 4.5 0.2 4.6 4.4 0.1 1.0 224.4 220.4 21.33 19.43 3 7.111 4860K 85K 0.0 0.0 L2 1/0 65.86 MB 0.7 0.1 0.1 0.1 0.1 0.1 4.2 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 15/1 1.05 GB 0.9 1.6 0.6 1.0 1.6 0.6 3.7 2.6 200.9 200.6 8.30 7.02 6 1.383 1531K 1487 0.0 0.0 L4 155/3 9.65 GB 1.0 3.6 2.8 0.8 3.6 2.8 1.2 1.3 115.9 115.5 31.93 17.34 23 1.388 3089K 9337 0.0 0.0 L5 1088/0 89.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1275/20 101.69 GB 0.0 14.1 8.0 6.1 19.7 13.6 13.2 3.5 150.2 209.4 96.14 74.27 130 0.740 13M 100K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.1 8.0 6.1 19.7 13.6 13.2 3.5 150.2 209.4 96.14 74.27 130 0.740 13M 100K 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.1 8.0 6.1 14.0 7.9 0.0 0.0 185.6 184.2 77.81 59.74 48 1.621 13M 100K 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 316.2 18.33 14.53 82 0.224 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 38.8 total, 38.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: 19.66 GB write, 518.81 MB/s write, 14.10 GB read, 372.18 MB/s read, 96.1 seconds Interval compaction: 19.66 GB write, 521.45 MB/s write, 14.10 GB read, 374.08 MB/s read, 96.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 34, interval: 47 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2429539 Average: 2.8884 StdDev: 35.14 Min: 0 Median: 1.3393 Max: 20958 Percentiles: P50: 1.34 P75: 1.77 P99: 6.51 P99.9: 160.67 P99.99: 723.26 ------------------------------------------------------ [ 0, 1 ] 732252 30.140% 30.140% ###### ( 1, 2 ] 1422236 58.539% 88.679% ############ ( 2, 3 ] 140155 5.769% 94.448% # ( 3, 4 ] 61061 2.513% 96.961% # ( 4, 6 ] 48114 1.980% 98.941% ( 6, 10 ] 11209 0.461% 99.403% ( 10, 15 ] 2064 0.085% 99.488% ( 15, 22 ] 399 0.016% 99.504% ( 22, 34 ] 26 0.001% 99.505% ( 34, 51 ] 12 0.000% 99.506% ( 51, 76 ] 152 0.006% 99.512% ( 76, 110 ] 6137 0.253% 99.764% ( 110, 170 ] 3901 0.161% 99.925% ( 170, 250 ] 559 0.023% 99.948% ( 250, 380 ] 462 0.019% 99.967% ( 380, 580 ] 439 0.018% 99.985% ( 580, 870 ] 243 0.010% 99.995% ( 870, 1300 ] 78 0.003% 99.998% ( 1300, 1900 ] 56 0.002% 100.001% ( 1900, 2900 ] 57 0.002% 100.003% ( 2900, 4400 ] 72 0.003% 100.006% ( 4400, 6600 ] 12 0.000% 100.006% ( 6600, 9900 ] 2 0.000% 100.007% ( 14000, 22000 ] 2 0.000% 100.007% ** Level 1 read latency histogram (micros): Count: 966185 Average: 7.3585 StdDev: 115.91 Min: 1 Median: 1.9309 Max: 25633 Percentiles: P50: 1.93 P75: 2.90 P99: 9.30 P99.9: 23.13 P99.99: 438.01 ------------------------------------------------------ [ 0, 1 ] 28204 2.919% 2.919% # ( 1, 2 ] 488681 50.578% 53.498% ########## ( 2, 3 ] 231281 23.938% 77.435% ##### ( 3, 4 ] 95922 9.928% 87.363% ## ( 4, 6 ] 94702 9.802% 97.165% ## ( 6, 10 ] 21505 2.226% 99.390% ( 10, 15 ] 4374 0.453% 99.843% ( 15, 22 ] 548 0.057% 99.900% ( 22, 34 ] 30 0.003% 99.903% ( 34, 51 ] 3 0.000% 99.903% ( 51, 76 ] 12 0.001% 99.904% ( 76, 110 ] 47 0.005% 99.909% ( 110, 170 ] 161 0.017% 99.926% ( 170, 250 ] 170 0.018% 99.944% ( 250, 380 ] 309 0.032% 99.976% ( 380, 580 ] 484 0.050% 100.026% ( 580, 870 ] 525 0.054% 100.080% ( 870, 1300 ] 427 0.044% 100.124% ( 1300, 1900 ] 274 0.028% 100.153% ( 1900, 2900 ] 299 0.031% 100.184% ( 2900, 4400 ] 355 0.037% 100.220% ( 4400, 6600 ] 95 0.010% 100.230% ( 6600, 9900 ] 25 0.003% 100.233% ( 9900, 14000 ] 1 0.000% 100.233% ( 14000, 22000 ] 2 0.000% 100.233% ( 22000, 33000 ] 1 0.000% 100.233% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 337174 Average: 9.3243 StdDev: 127.24 Min: 0 Median: 1.7183 Max: 21964 Percentiles: P50: 1.72 P75: 2.45 P99: 14.30 P99.9: 1286.20 P99.99: 3322.74 ------------------------------------------------------ [ 0, 1 ] 24726 7.333% 7.333% # ( 1, 2 ] 200283 59.400% 66.734% ############ ( 2, 3 ] 61864 18.348% 85.082% #### ( 3, 4 ] 22648 6.717% 91.799% # ( 4, 6 ] 17429 5.169% 96.968% # ( 6, 10 ] 6041 1.792% 98.759% ( 10, 15 ] 944 0.280% 99.039% ( 15, 22 ] 158 0.047% 99.086% ( 22, 34 ] 66 0.020% 99.106% ( 34, 51 ] 24 0.007% 99.113% ( 51, 76 ] 9 0.003% 99.116% ( 76, 110 ] 127 0.038% 99.153% ( 110, 170 ] 441 0.131% 99.284% ( 170, 250 ] 364 0.108% 99.392% ( 250, 380 ] 384 0.114% 99.506% ( 380, 580 ] 500 0.148% 99.654% ( 580, 870 ] 522 0.155% 99.809% ( 870, 1300 ] 317 0.094% 99.903% ( 1300, 1900 ] 152 0.045% 99.948% ( 1900, 2900 ] 110 0.033% 99.981% ( 2900, 4400 ] 111 0.033% 100.014% ( 4400, 6600 ] 20 0.006% 100.020% ( 6600, 9900 ] 2 0.001% 100.020% ( 14000, 22000 ] 4 0.001% 100.021% ** Level 4 read latency histogram (micros): Count: 142361 Average: 16.1640 StdDev: 195.51 Min: 0 Median: 1.9729 Max: 23438 Percentiles: P50: 1.97 P75: 2.97 P99: 213.04 P99.9: 2489.92 P99.99: 3766.24 ------------------------------------------------------ [ 0, 1 ] 2630 1.847% 1.847% ( 1, 2 ] 70458 49.492% 51.340% ########## ( 2, 3 ] 34601 24.305% 75.645% ##### ( 3, 4 ] 15539 10.915% 86.560% ## ( 4, 6 ] 13723 9.640% 96.200% ## ( 6, 10 ] 3058 2.148% 98.348% ( 10, 15 ] 627 0.440% 98.788% ( 15, 22 ] 73 0.051% 98.840% ( 22, 34 ] 16 0.011% 98.851% ( 34, 51 ] 7 0.005% 98.856% ( 51, 76 ] 1 0.001% 98.856% ( 76, 110 ] 29 0.020% 98.877% ( 110, 170 ] 93 0.065% 98.942% ( 170, 250 ] 155 0.109% 99.051% ( 250, 380 ] 192 0.135% 99.186% ( 380, 580 ] 265 0.186% 99.372% ( 580, 870 ] 288 0.202% 99.574% ( 870, 1300 ] 235 0.165% 99.739% ( 1300, 1900 ] 150 0.105% 99.845% ( 1900, 2900 ] 135 0.095% 99.940% ( 2900, 4400 ] 126 0.089% 100.028% ( 4400, 6600 ] 17 0.012% 100.040% ( 6600, 9900 ] 5 0.004% 100.044% ( 9900, 14000 ] 1 0.001% 100.044% ( 14000, 22000 ] 2 0.001% 100.046% ( 22000, 33000 ] 1 0.001% 100.046% ** Level 5 read latency histogram (micros): Count: 240 Average: 1700.7792 StdDev: 1586.09 Min: 118 Median: 1085.0000 Max: 7362 Percentiles: P50: 1085.00 P75: 2694.12 P99: 7362.00 P99.9: 7362.00 P99.99: 7362.00 ------------------------------------------------------ ( 110, 170 ] 11 4.583% 4.583% # ( 170, 250 ] 21 8.750% 13.333% ## ( 250, 380 ] 21 8.750% 22.083% ## ( 380, 580 ] 29 12.083% 34.167% ## ( 580, 870 ] 29 12.083% 46.250% ## ( 870, 1300 ] 18 7.500% 53.750% ## ( 1300, 1900 ] 24 10.000% 63.750% ## ( 1900, 2900 ] 34 14.167% 77.917% ### ( 2900, 4400 ] 38 15.833% 93.750% ### ( 4400, 6600 ] 11 4.583% 98.333% # ( 6600, 9900 ] 4 1.667% 100.000% ** DB Stats ** Uptime(secs): 38.8 total, 23.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 152.20 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.424 H:M:S, 57.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 42.35 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:20.139 H:M:S, 86.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/17-00:56:19 ... thread 0: (1000000,7000000) ops and (272622.7,165610.6) ops/second in (3.668073,42.267833) 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/9 1.60 GB 37.8 5.0 0.0 5.0 11.6 6.6 0.0 1.8 124.3 286.2 41.57 36.36 112 0.371 5245K 5732 0.0 0.0 L1 1/1 60.08 MB 0.0 5.3 4.9 0.4 5.2 4.8 0.1 1.1 208.0 204.7 26.07 22.41 4 6.517 5244K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 4.8 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 16/0 934.37 MB 0.9 2.9 1.1 1.8 2.9 1.1 3.8 2.7 194.6 194.2 15.33 12.95 12 1.277 2867K 5665 0.0 0.0 L4 154/0 9.73 GB 1.0 4.4 3.5 0.9 4.4 3.5 1.3 1.3 120.5 120.0 37.33 21.03 31 1.204 3890K 12K 0.0 0.0 L5 1096/0 90.31 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 1278/10 102.60 GB 0.0 17.8 9.5 8.3 24.2 16.0 14.7 3.7 150.6 205.4 120.84 93.27 160 0.755 17M 109K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.8 9.5 8.3 24.2 16.0 14.7 3.7 150.6 205.4 120.84 93.27 160 0.755 17M 109K 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 17.8 9.5 8.3 17.7 9.4 0.0 0.0 183.3 182.1 99.25 76.29 66 1.504 17M 109K 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 312.3 21.58 16.98 94 0.230 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): 42.5 total, 42.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: 24.24 GB write, 584.45 MB/s write, 17.77 GB read, 428.48 MB/s read, 120.8 seconds Interval compaction: 24.24 GB write, 587.17 MB/s write, 17.77 GB read, 430.47 MB/s read, 120.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 42, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 42, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2762128 Average: 2.8619 StdDev: 33.92 Min: 0 Median: 1.3808 Max: 20958 Percentiles: P50: 1.38 P75: 1.80 P99: 6.43 P99.9: 155.65 P99.99: 625.43 ------------------------------------------------------ [ 0, 1 ] 761006 27.551% 27.551% ###### ( 1, 2 ] 1628474 58.957% 86.509% ############ ( 2, 3 ] 194081 7.027% 93.535% # ( 3, 4 ] 82771 2.997% 96.532% # ( 4, 6 ] 66653 2.413% 98.945% ( 6, 10 ] 14160 0.513% 99.458% ( 10, 15 ] 2455 0.089% 99.546% ( 15, 22 ] 437 0.016% 99.562% ( 22, 34 ] 28 0.001% 99.563% ( 34, 51 ] 16 0.001% 99.564% ( 51, 76 ] 155 0.006% 99.569% ( 76, 110 ] 6145 0.222% 99.792% ( 110, 170 ] 3923 0.142% 99.934% ( 170, 250 ] 577 0.021% 99.955% ( 250, 380 ] 479 0.017% 99.972% ( 380, 580 ] 452 0.016% 99.989% ( 580, 870 ] 254 0.009% 99.998% ( 870, 1300 ] 83 0.003% 100.001% ( 1300, 1900 ] 57 0.002% 100.003% ( 1900, 2900 ] 63 0.002% 100.005% ( 2900, 4400 ] 75 0.003% 100.008% ( 4400, 6600 ] 13 0.000% 100.008% ( 6600, 9900 ] 3 0.000% 100.008% ( 14000, 22000 ] 2 0.000% 100.008% ** Level 1 read latency histogram (micros): Count: 1312691 Average: 6.7812 StdDev: 105.10 Min: 1 Median: 1.9319 Max: 25633 Percentiles: P50: 1.93 P75: 2.89 P99: 9.21 P99.9: 90.16 P99.99: 411.75 ------------------------------------------------------ [ 0, 1 ] 32249 2.457% 2.457% ( 1, 2 ] 669732 51.020% 53.476% ########## ( 2, 3 ] 316872 24.139% 77.616% ##### ( 3, 4 ] 130497 9.941% 87.557% ## ( 4, 6 ] 126654 9.648% 97.205% ## ( 6, 10 ] 29325 2.234% 99.439% ( 10, 15 ] 5273 0.402% 99.841% ( 15, 22 ] 679 0.052% 99.893% ( 22, 34 ] 36 0.003% 99.895% ( 34, 51 ] 8 0.001% 99.896% ( 51, 76 ] 15 0.001% 99.897% ( 76, 110 ] 92 0.007% 99.904% ( 110, 170 ] 254 0.019% 99.923% ( 170, 250 ] 279 0.021% 99.945% ( 250, 380 ] 486 0.037% 99.982% ( 380, 580 ] 685 0.052% 100.034% ( 580, 870 ] 715 0.054% 100.088% ( 870, 1300 ] 536 0.041% 100.129% ( 1300, 1900 ] 334 0.025% 100.155% ( 1900, 2900 ] 350 0.027% 100.181% ( 2900, 4400 ] 376 0.029% 100.210% ( 4400, 6600 ] 100 0.008% 100.218% ( 6600, 9900 ] 31 0.002% 100.220% ( 9900, 14000 ] 2 0.000% 100.220% ( 14000, 22000 ] 2 0.000% 100.220% ( 22000, 33000 ] 1 0.000% 100.220% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 471317 Average: 8.5892 StdDev: 117.57 Min: 0 Median: 1.7900 Max: 21964 Percentiles: P50: 1.79 P75: 2.65 P99: 11.30 P99.9: 968.95 P99.99: 1769.56 ------------------------------------------------------ [ 0, 1 ] 26262 5.572% 5.572% # ( 1, 2 ] 265051 56.236% 61.808% ########### ( 2, 3 ] 96341 20.441% 82.249% #### ( 3, 4 ] 37858 8.032% 90.281% ## ( 4, 6 ] 32497 6.895% 97.176% # ( 6, 10 ] 8218 1.744% 98.920% ( 10, 15 ] 1453 0.308% 99.228% ( 15, 22 ] 201 0.043% 99.271% ( 22, 34 ] 76 0.016% 99.287% ( 34, 51 ] 27 0.006% 99.293% ( 51, 76 ] 9 0.002% 99.295% ( 76, 110 ] 144 0.031% 99.325% ( 110, 170 ] 491 0.104% 99.429% ( 170, 250 ] 428 0.091% 99.520% ( 250, 380 ] 479 0.102% 99.622% ( 380, 580 ] 624 0.132% 99.754% ( 580, 870 ] 602 0.128% 99.882% ( 870, 1300 ] 368 0.078% 99.960% ( 1300, 1900 ] 180 0.038% 99.998% ( 1900, 2900 ] 146 0.031% 100.029% ( 2900, 4400 ] 147 0.031% 100.060% ( 4400, 6600 ] 24 0.005% 100.066% ( 6600, 9900 ] 3 0.001% 100.066% ( 14000, 22000 ] 4 0.001% 100.067% ** Level 4 read latency histogram (micros): Count: 164106 Average: 16.1210 StdDev: 195.29 Min: 0 Median: 1.9905 Max: 23438 Percentiles: P50: 1.99 P75: 3.01 P99: 249.26 P99.9: 2444.71 P99.99: 3810.91 ------------------------------------------------------ [ 0, 1 ] 2840 1.731% 1.731% ( 1, 2 ] 79970 48.731% 50.461% ########## ( 2, 3 ] 40164 24.474% 74.936% ##### ( 3, 4 ] 18238 11.114% 86.049% ## ( 4, 6 ] 16272 9.916% 95.965% ## ( 6, 10 ] 3710 2.261% 98.226% ( 10, 15 ] 733 0.447% 98.672% ( 15, 22 ] 86 0.052% 98.725% ( 22, 34 ] 20 0.012% 98.737% ( 34, 51 ] 7 0.004% 98.741% ( 51, 76 ] 1 0.001% 98.742% ( 76, 110 ] 55 0.034% 98.775% ( 110, 170 ] 147 0.090% 98.865% ( 170, 250 ] 224 0.136% 99.001% ( 250, 380 ] 280 0.171% 99.172% ( 380, 580 ] 349 0.213% 99.385% ( 580, 870 ] 350 0.213% 99.598% ( 870, 1300 ] 260 0.158% 99.756% ( 1300, 1900 ] 158 0.096% 99.853% ( 1900, 2900 ] 143 0.087% 99.940% ( 2900, 4400 ] 136 0.083% 100.023% ( 4400, 6600 ] 18 0.011% 100.034% ( 6600, 9900 ] 7 0.004% 100.038% ( 9900, 14000 ] 2 0.001% 100.039% ( 14000, 22000 ] 3 0.002% 100.041% ( 22000, 33000 ] 1 0.001% 100.041% ** Level 5 read latency histogram (micros): Count: 280 Average: 1623.5714 StdDev: 1563.06 Min: 84 Median: 951.9048 Max: 7362 Percentiles: P50: 951.90 P75: 2584.21 P99: 7362.00 P99.9: 7362.00 P99.99: 7362.00 ------------------------------------------------------ ( 76, 110 ] 2 0.714% 0.714% ( 110, 170 ] 15 5.357% 6.071% # ( 170, 250 ] 26 9.286% 15.357% ## ( 250, 380 ] 26 9.286% 24.643% ## ( 380, 580 ] 34 12.143% 36.786% ## ( 580, 870 ] 33 11.786% 48.571% ## ( 870, 1300 ] 21 7.500% 56.071% ## ( 1300, 1900 ] 27 9.643% 65.714% ## ( 1900, 2900 ] 38 13.571% 79.286% ### ( 2900, 4400 ] 42 15.000% 94.286% ### ( 4400, 6600 ] 12 4.286% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 42.5 total, 3.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 162.23 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:23.181 H:M:S, 54.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 268.32 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.757 H:M:S, 20.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-00:56:22 ... thread 0: (1000000,8000000) ops and (323054.0,176354.0) ops/second in (3.095458,45.363291) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/7 1.66 GB 31.5 5.9 0.0 5.9 13.5 7.6 0.0 1.8 126.5 288.5 47.80 42.21 129 0.371 6140K 6687 0.0 0.0 L1 10/10 1000.10 MB 0.0 6.3 5.8 0.5 6.2 5.7 0.1 1.1 209.9 206.9 30.62 26.70 5 6.125 6263K 89K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 4.8 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 16/0 934.37 MB 0.9 2.9 1.1 1.8 2.9 1.1 3.8 2.7 194.6 194.2 15.33 12.95 12 1.277 2867K 5665 0.0 0.0 L4 154/0 9.73 GB 1.0 4.4 3.5 0.9 4.4 3.5 1.3 1.3 120.5 120.0 37.33 21.03 31 1.204 3890K 12K 0.0 0.0 L5 1096/0 90.31 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 1287/17 103.58 GB 0.0 19.6 10.4 9.2 27.1 17.9 14.7 3.6 152.6 210.5 131.61 103.42 178 0.739 19M 113K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.6 10.4 9.2 27.1 17.9 14.7 3.6 152.6 210.5 131.61 103.42 178 0.739 19M 113K 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 19.6 10.4 9.2 19.5 10.3 0.0 0.0 187.4 186.3 107.15 83.87 70 1.531 19M 113K 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 316.8 24.46 19.55 108 0.226 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): 45.6 total, 45.4 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: 27.06 GB write, 608.15 MB/s write, 19.61 GB read, 440.76 MB/s read, 131.6 seconds Interval compaction: 27.06 GB write, 610.78 MB/s write, 19.61 GB read, 442.67 MB/s read, 131.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 46, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3091398 Average: 2.7948 StdDev: 32.26 Min: 0 Median: 1.3949 Max: 20958 Percentiles: P50: 1.39 P75: 1.81 P99: 6.14 P99.9: 149.67 P99.99: 532.96 ------------------------------------------------------ [ 0, 1 ] 815021 26.364% 26.364% ##### ( 1, 2 ] 1850480 59.859% 86.223% ############ ( 2, 3 ] 227232 7.350% 93.574% # ( 3, 4 ] 93690 3.031% 96.604% # ( 4, 6 ] 73508 2.378% 98.982% ( 6, 10 ] 16119 0.521% 99.504% ( 10, 15 ] 2800 0.091% 99.594% ( 15, 22 ] 487 0.016% 99.610% ( 22, 34 ] 29 0.001% 99.611% ( 34, 51 ] 18 0.001% 99.611% ( 51, 76 ] 155 0.005% 99.616% ( 76, 110 ] 6155 0.199% 99.815% ( 110, 170 ] 3952 0.128% 99.943% ( 170, 250 ] 597 0.019% 99.963% ( 250, 380 ] 491 0.016% 99.979% ( 380, 580 ] 464 0.015% 99.994% ( 580, 870 ] 266 0.009% 100.002% ( 870, 1300 ] 88 0.003% 100.005% ( 1300, 1900 ] 57 0.002% 100.007% ( 1900, 2900 ] 64 0.002% 100.009% ( 2900, 4400 ] 76 0.002% 100.011% ( 4400, 6600 ] 13 0.000% 100.012% ( 6600, 9900 ] 3 0.000% 100.012% ( 14000, 22000 ] 2 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 1343520 Average: 6.7029 StdDev: 103.98 Min: 0 Median: 1.9178 Max: 25633 Percentiles: P50: 1.92 P75: 2.87 P99: 9.21 P99.9: 119.97 P99.99: 419.04 ------------------------------------------------------ [ 0, 1 ] 39273 2.923% 2.923% # ( 1, 2 ] 689134 51.293% 54.216% ########## ( 2, 3 ] 319297 23.766% 77.982% ##### ( 3, 4 ] 131285 9.772% 87.754% ## ( 4, 6 ] 127267 9.473% 97.226% ## ( 6, 10 ] 29717 2.212% 99.438% ( 10, 15 ] 5311 0.395% 99.834% ( 15, 22 ] 681 0.051% 99.884% ( 22, 34 ] 36 0.003% 99.887% ( 34, 51 ] 8 0.001% 99.888% ( 51, 76 ] 15 0.001% 99.889% ( 76, 110 ] 99 0.007% 99.896% ( 110, 170 ] 322 0.024% 99.920% ( 170, 250 ] 302 0.022% 99.942% ( 250, 380 ] 502 0.037% 99.980% ( 380, 580 ] 700 0.052% 100.032% ( 580, 870 ] 727 0.054% 100.086% ( 870, 1300 ] 539 0.040% 100.126% ( 1300, 1900 ] 334 0.025% 100.151% ( 1900, 2900 ] 350 0.026% 100.177% ( 2900, 4400 ] 377 0.028% 100.205% ( 4400, 6600 ] 100 0.007% 100.213% ( 6600, 9900 ] 31 0.002% 100.215% ( 9900, 14000 ] 2 0.000% 100.215% ( 14000, 22000 ] 2 0.000% 100.215% ( 22000, 33000 ] 1 0.000% 100.215% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 471317 Average: 8.5892 StdDev: 117.57 Min: 0 Median: 1.7900 Max: 21964 Percentiles: P50: 1.79 P75: 2.65 P99: 11.30 P99.9: 968.95 P99.99: 1769.56 ------------------------------------------------------ [ 0, 1 ] 26262 5.572% 5.572% # ( 1, 2 ] 265051 56.236% 61.808% ########### ( 2, 3 ] 96341 20.441% 82.249% #### ( 3, 4 ] 37858 8.032% 90.281% ## ( 4, 6 ] 32497 6.895% 97.176% # ( 6, 10 ] 8218 1.744% 98.920% ( 10, 15 ] 1453 0.308% 99.228% ( 15, 22 ] 201 0.043% 99.271% ( 22, 34 ] 76 0.016% 99.287% ( 34, 51 ] 27 0.006% 99.293% ( 51, 76 ] 9 0.002% 99.295% ( 76, 110 ] 144 0.031% 99.325% ( 110, 170 ] 491 0.104% 99.429% ( 170, 250 ] 428 0.091% 99.520% ( 250, 380 ] 479 0.102% 99.622% ( 380, 580 ] 624 0.132% 99.754% ( 580, 870 ] 602 0.128% 99.882% ( 870, 1300 ] 368 0.078% 99.960% ( 1300, 1900 ] 180 0.038% 99.998% ( 1900, 2900 ] 146 0.031% 100.029% ( 2900, 4400 ] 147 0.031% 100.060% ( 4400, 6600 ] 24 0.005% 100.066% ( 6600, 9900 ] 3 0.001% 100.066% ( 14000, 22000 ] 4 0.001% 100.067% ** Level 4 read latency histogram (micros): Count: 164106 Average: 16.1210 StdDev: 195.29 Min: 0 Median: 1.9905 Max: 23438 Percentiles: P50: 1.99 P75: 3.01 P99: 249.26 P99.9: 2444.71 P99.99: 3810.91 ------------------------------------------------------ [ 0, 1 ] 2840 1.731% 1.731% ( 1, 2 ] 79970 48.731% 50.461% ########## ( 2, 3 ] 40164 24.474% 74.936% ##### ( 3, 4 ] 18238 11.114% 86.049% ## ( 4, 6 ] 16272 9.916% 95.965% ## ( 6, 10 ] 3710 2.261% 98.226% ( 10, 15 ] 733 0.447% 98.672% ( 15, 22 ] 86 0.052% 98.725% ( 22, 34 ] 20 0.012% 98.737% ( 34, 51 ] 7 0.004% 98.741% ( 51, 76 ] 1 0.001% 98.742% ( 76, 110 ] 55 0.034% 98.775% ( 110, 170 ] 147 0.090% 98.865% ( 170, 250 ] 224 0.136% 99.001% ( 250, 380 ] 280 0.171% 99.172% ( 380, 580 ] 349 0.213% 99.385% ( 580, 870 ] 350 0.213% 99.598% ( 870, 1300 ] 260 0.158% 99.756% ( 1300, 1900 ] 158 0.096% 99.853% ( 1900, 2900 ] 143 0.087% 99.940% ( 2900, 4400 ] 136 0.083% 100.023% ( 4400, 6600 ] 18 0.011% 100.034% ( 6600, 9900 ] 7 0.004% 100.038% ( 9900, 14000 ] 2 0.001% 100.039% ( 14000, 22000 ] 3 0.002% 100.041% ( 22000, 33000 ] 1 0.001% 100.041% ** Level 5 read latency histogram (micros): Count: 280 Average: 1623.5714 StdDev: 1563.06 Min: 84 Median: 951.9048 Max: 7362 Percentiles: P50: 951.90 P75: 2584.21 P99: 7362.00 P99.9: 7362.00 P99.99: 7362.00 ------------------------------------------------------ ( 76, 110 ] 2 0.714% 0.714% ( 110, 170 ] 15 5.357% 6.071% # ( 170, 250 ] 26 9.286% 15.357% ## ( 250, 380 ] 26 9.286% 24.643% ## ( 380, 580 ] 34 12.143% 36.786% ## ( 580, 870 ] 33 11.786% 48.571% ## ( 870, 1300 ] 21 7.500% 56.071% ## ( 1300, 1900 ] 27 9.643% 65.714% ## ( 1900, 2900 ] 38 13.571% 79.286% ### ( 2900, 4400 ] 42 15.000% 94.286% ### ( 4400, 6600 ] 12 4.286% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 45.6 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 172.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:23.610 H:M:S, 51.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.95 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.429 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-00:56:25 ... thread 0: (1000000,9000000) ops and (324301.2,185770.6) ops/second in (3.083553,48.446844) 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/7 2.58 GB 125.9 6.7 0.0 6.7 15.2 8.5 0.0 1.8 128.0 290.0 53.63 47.70 145 0.370 6972K 7504 0.0 0.0 L1 10/10 1000.10 MB 0.0 6.3 5.8 0.5 6.2 5.7 0.1 1.1 209.9 206.9 30.62 26.70 5 6.125 6263K 89K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 4.8 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 16/0 934.37 MB 0.9 2.9 1.1 1.8 2.9 1.1 3.8 2.7 194.6 194.2 15.33 12.95 12 1.277 2867K 5665 0.0 0.0 L4 154/0 9.73 GB 1.0 4.4 3.5 0.9 4.4 3.5 1.3 1.3 120.5 120.0 37.33 21.03 31 1.204 3890K 12K 0.0 0.0 L5 1096/0 90.31 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 1291/17 104.51 GB 0.0 20.4 10.4 10.0 28.8 18.8 14.7 3.4 152.1 214.4 137.45 108.90 194 0.709 20M 114K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.4 10.4 10.0 28.8 18.8 14.7 3.4 152.1 214.4 137.45 108.90 194 0.709 20M 114K 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 20.4 10.4 10.0 20.3 10.3 0.0 0.0 189.5 188.4 110.31 86.96 73 1.511 20M 114K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 320.3 27.14 21.94 121 0.224 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.6 total, 48.4 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.78 GB write, 605.84 MB/s write, 20.41 GB read, 429.66 MB/s read, 137.4 seconds Interval compaction: 28.78 GB write, 608.30 MB/s write, 20.41 GB read, 431.40 MB/s read, 137.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 49, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 49, interval: 62 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3401803 Average: 2.7429 StdDev: 30.86 Min: 0 Median: 1.4067 Max: 20958 Percentiles: P50: 1.41 P75: 1.82 P99: 5.97 P99.9: 144.68 P99.99: 487.58 ------------------------------------------------------ [ 0, 1 ] 863530 25.384% 25.384% ##### ( 1, 2 ] 2058800 60.521% 85.905% ############ ( 2, 3 ] 262638 7.721% 93.626% ## ( 3, 4 ] 104551 3.073% 96.699% # ( 4, 6 ] 79470 2.336% 99.035% ( 6, 10 ] 17295 0.508% 99.544% ( 10, 15 ] 2926 0.086% 99.630% ( 15, 22 ] 508 0.015% 99.645% ( 22, 34 ] 34 0.001% 99.646% ( 34, 51 ] 19 0.001% 99.646% ( 51, 76 ] 157 0.005% 99.651% ( 76, 110 ] 6159 0.181% 99.832% ( 110, 170 ] 4004 0.118% 99.950% ( 170, 250 ] 620 0.018% 99.968% ( 250, 380 ] 499 0.015% 99.983% ( 380, 580 ] 470 0.014% 99.996% ( 580, 870 ] 277 0.008% 100.005% ( 870, 1300 ] 92 0.003% 100.007% ( 1300, 1900 ] 59 0.002% 100.009% ( 1900, 2900 ] 65 0.002% 100.011% ( 2900, 4400 ] 76 0.002% 100.013% ( 4400, 6600 ] 13 0.000% 100.013% ( 6600, 9900 ] 3 0.000% 100.014% ( 14000, 22000 ] 2 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 1413306 Average: 6.5027 StdDev: 101.43 Min: 0 Median: 1.8937 Max: 25633 Percentiles: P50: 1.89 P75: 2.84 P99: 9.17 P99.9: 126.47 P99.99: 420.30 ------------------------------------------------------ [ 0, 1 ] 49045 3.470% 3.470% # ( 1, 2 ] 735793 52.062% 55.532% ########## ( 2, 3 ] 327743 23.190% 78.722% ##### ( 3, 4 ] 133496 9.446% 88.168% ## ( 4, 6 ] 128684 9.105% 97.273% ## ( 6, 10 ] 30815 2.180% 99.453% ( 10, 15 ] 5341 0.378% 99.831% ( 15, 22 ] 683 0.048% 99.879% ( 22, 34 ] 38 0.003% 99.882% ( 34, 51 ] 8 0.001% 99.883% ( 51, 76 ] 15 0.001% 99.884% ( 76, 110 ] 126 0.009% 99.893% ( 110, 170 ] 385 0.027% 99.920% ( 170, 250 ] 332 0.023% 99.943% ( 250, 380 ] 518 0.037% 99.980% ( 380, 580 ] 708 0.050% 100.030% ( 580, 870 ] 731 0.052% 100.082% ( 870, 1300 ] 539 0.038% 100.120% ( 1300, 1900 ] 334 0.024% 100.143% ( 1900, 2900 ] 351 0.025% 100.168% ( 2900, 4400 ] 377 0.027% 100.195% ( 4400, 6600 ] 100 0.007% 100.202% ( 6600, 9900 ] 31 0.002% 100.204% ( 9900, 14000 ] 2 0.000% 100.204% ( 14000, 22000 ] 2 0.000% 100.205% ( 22000, 33000 ] 1 0.000% 100.205% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 471317 Average: 8.5892 StdDev: 117.57 Min: 0 Median: 1.7900 Max: 21964 Percentiles: P50: 1.79 P75: 2.65 P99: 11.30 P99.9: 968.95 P99.99: 1769.56 ------------------------------------------------------ [ 0, 1 ] 26262 5.572% 5.572% # ( 1, 2 ] 265051 56.236% 61.808% ########### ( 2, 3 ] 96341 20.441% 82.249% #### ( 3, 4 ] 37858 8.032% 90.281% ## ( 4, 6 ] 32497 6.895% 97.176% # ( 6, 10 ] 8218 1.744% 98.920% ( 10, 15 ] 1453 0.308% 99.228% ( 15, 22 ] 201 0.043% 99.271% ( 22, 34 ] 76 0.016% 99.287% ( 34, 51 ] 27 0.006% 99.293% ( 51, 76 ] 9 0.002% 99.295% ( 76, 110 ] 144 0.031% 99.325% ( 110, 170 ] 491 0.104% 99.429% ( 170, 250 ] 428 0.091% 99.520% ( 250, 380 ] 479 0.102% 99.622% ( 380, 580 ] 624 0.132% 99.754% ( 580, 870 ] 602 0.128% 99.882% ( 870, 1300 ] 368 0.078% 99.960% ( 1300, 1900 ] 180 0.038% 99.998% ( 1900, 2900 ] 146 0.031% 100.029% ( 2900, 4400 ] 147 0.031% 100.060% ( 4400, 6600 ] 24 0.005% 100.066% ( 6600, 9900 ] 3 0.001% 100.066% ( 14000, 22000 ] 4 0.001% 100.067% ** Level 4 read latency histogram (micros): Count: 164106 Average: 16.1210 StdDev: 195.29 Min: 0 Median: 1.9905 Max: 23438 Percentiles: P50: 1.99 P75: 3.01 P99: 249.26 P99.9: 2444.71 P99.99: 3810.91 ------------------------------------------------------ [ 0, 1 ] 2840 1.731% 1.731% ( 1, 2 ] 79970 48.731% 50.461% ########## ( 2, 3 ] 40164 24.474% 74.936% ##### ( 3, 4 ] 18238 11.114% 86.049% ## ( 4, 6 ] 16272 9.916% 95.965% ## ( 6, 10 ] 3710 2.261% 98.226% ( 10, 15 ] 733 0.447% 98.672% ( 15, 22 ] 86 0.052% 98.725% ( 22, 34 ] 20 0.012% 98.737% ( 34, 51 ] 7 0.004% 98.741% ( 51, 76 ] 1 0.001% 98.742% ( 76, 110 ] 55 0.034% 98.775% ( 110, 170 ] 147 0.090% 98.865% ( 170, 250 ] 224 0.136% 99.001% ( 250, 380 ] 280 0.171% 99.172% ( 380, 580 ] 349 0.213% 99.385% ( 580, 870 ] 350 0.213% 99.598% ( 870, 1300 ] 260 0.158% 99.756% ( 1300, 1900 ] 158 0.096% 99.853% ( 1900, 2900 ] 143 0.087% 99.940% ( 2900, 4400 ] 136 0.083% 100.023% ( 4400, 6600 ] 18 0.011% 100.034% ( 6600, 9900 ] 7 0.004% 100.038% ( 9900, 14000 ] 2 0.001% 100.039% ( 14000, 22000 ] 3 0.002% 100.041% ( 22000, 33000 ] 1 0.001% 100.041% ** Level 5 read latency histogram (micros): Count: 280 Average: 1623.5714 StdDev: 1563.06 Min: 84 Median: 951.9048 Max: 7362 Percentiles: P50: 951.90 P75: 2584.21 P99: 7362.00 P99.9: 7362.00 P99.99: 7362.00 ------------------------------------------------------ ( 76, 110 ] 2 0.714% 0.714% ( 110, 170 ] 15 5.357% 6.071% # ( 170, 250 ] 26 9.286% 15.357% ## ( 250, 380 ] 26 9.286% 24.643% ## ( 380, 580 ] 34 12.143% 36.786% ## ( 580, 870 ] 33 11.786% 48.571% ## ( 870, 1300 ] 21 7.500% 56.071% ## ( 1300, 1900 ] 27 9.643% 65.714% ## ( 1900, 2900 ] 38 13.571% 79.286% ### ( 2900, 4400 ] 42 15.000% 94.286% ### ( 4400, 6600 ] 12 4.286% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 48.6 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 182.09 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.041 H:M:S, 49.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.17 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.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-00:56:30 ... thread 0: (1000000,10000000) ops and (230514.5,189447.9) ops/second in (4.338122,52.784966) 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/7 3.63 GB 232.9 7.8 0.0 7.8 17.3 9.5 0.0 1.8 130.7 291.3 60.75 54.38 165 0.368 8059K 8577 0.0 0.0 L1 10/10 1000.10 MB 0.0 6.3 5.8 0.5 6.2 5.7 0.1 1.1 209.9 206.9 30.62 26.70 5 6.125 6263K 89K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 4.8 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 16/0 934.37 MB 0.9 2.9 1.1 1.8 2.9 1.1 3.8 2.7 194.6 194.2 15.33 12.95 12 1.277 2867K 5665 0.0 0.0 L4 154/0 9.73 GB 1.0 4.4 3.5 0.9 4.4 3.5 1.3 1.3 120.5 120.0 37.33 21.03 31 1.204 3890K 12K 0.0 0.0 L5 1096/0 90.31 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 1295/17 105.55 GB 0.0 21.5 10.4 11.1 30.9 19.8 14.7 3.2 152.0 218.7 144.56 115.59 214 0.676 21M 115K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.5 10.4 11.1 30.9 19.8 14.7 3.2 152.0 218.7 144.56 115.59 214 0.676 21M 115K 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 21.5 10.4 11.1 21.3 10.3 0.0 0.0 192.1 191.0 114.36 90.93 77 1.485 21M 115K 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 323.2 30.21 24.66 137 0.220 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): 53.0 total, 52.8 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.87 GB write, 596.64 MB/s write, 21.46 GB read, 414.69 MB/s read, 144.6 seconds Interval compaction: 30.87 GB write, 598.87 MB/s write, 21.46 GB read, 416.24 MB/s read, 144.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 50, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3822104 Average: 2.6893 StdDev: 29.39 Min: 0 Median: 1.4177 Max: 20958 Percentiles: P50: 1.42 P75: 1.83 P99: 5.94 P99.9: 138.88 P99.99: 447.39 ------------------------------------------------------ [ 0, 1 ] 933056 24.412% 24.412% ##### ( 1, 2 ] 2341508 61.262% 85.674% ############ ( 2, 3 ] 307248 8.039% 93.713% ## ( 3, 4 ] 118197 3.092% 96.806% # ( 4, 6 ] 86607 2.266% 99.072% ( 6, 10 ] 19582 0.512% 99.584% ( 10, 15 ] 3175 0.083% 99.667% ( 15, 22 ] 536 0.014% 99.681% ( 22, 34 ] 36 0.001% 99.682% ( 34, 51 ] 22 0.001% 99.682% ( 51, 76 ] 161 0.004% 99.687% ( 76, 110 ] 6194 0.162% 99.849% ( 110, 170 ] 4072 0.107% 99.955% ( 170, 250 ] 644 0.017% 99.972% ( 250, 380 ] 517 0.014% 99.986% ( 380, 580 ] 495 0.013% 99.999% ( 580, 870 ] 286 0.007% 100.006% ( 870, 1300 ] 98 0.003% 100.009% ( 1300, 1900 ] 64 0.002% 100.010% ( 1900, 2900 ] 69 0.002% 100.012% ( 2900, 4400 ] 77 0.002% 100.014% ( 4400, 6600 ] 13 0.000% 100.014% ( 6600, 9900 ] 3 0.000% 100.015% ( 14000, 22000 ] 2 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 1514252 Average: 6.2339 StdDev: 98.04 Min: 0 Median: 1.8620 Max: 25633 Percentiles: P50: 1.86 P75: 2.79 P99: 9.11 P99.9: 124.19 P99.99: 420.33 ------------------------------------------------------ [ 0, 1 ] 64645 4.269% 4.269% # ( 1, 2 ] 803377 53.054% 57.323% ########### ( 2, 3 ] 338877 22.379% 79.703% #### ( 3, 4 ] 136448 9.011% 88.714% ## ( 4, 6 ] 130745 8.634% 97.348% ## ( 6, 10 ] 32202 2.127% 99.474% ( 10, 15 ] 5371 0.355% 99.829% ( 15, 22 ] 688 0.045% 99.875% ( 22, 34 ] 40 0.003% 99.877% ( 34, 51 ] 8 0.001% 99.878% ( 51, 76 ] 21 0.001% 99.879% ( 76, 110 ] 212 0.014% 99.893% ( 110, 170 ] 443 0.029% 99.922% ( 170, 250 ] 352 0.023% 99.946% ( 250, 380 ] 528 0.035% 99.981% ( 380, 580 ] 717 0.047% 100.028% ( 580, 870 ] 733 0.048% 100.076% ( 870, 1300 ] 539 0.036% 100.112% ( 1300, 1900 ] 334 0.022% 100.134% ( 1900, 2900 ] 352 0.023% 100.157% ( 2900, 4400 ] 377 0.025% 100.182% ( 4400, 6600 ] 100 0.007% 100.189% ( 6600, 9900 ] 31 0.002% 100.191% ( 9900, 14000 ] 2 0.000% 100.191% ( 14000, 22000 ] 2 0.000% 100.191% ( 22000, 33000 ] 1 0.000% 100.191% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 471317 Average: 8.5892 StdDev: 117.57 Min: 0 Median: 1.7900 Max: 21964 Percentiles: P50: 1.79 P75: 2.65 P99: 11.30 P99.9: 968.95 P99.99: 1769.56 ------------------------------------------------------ [ 0, 1 ] 26262 5.572% 5.572% # ( 1, 2 ] 265051 56.236% 61.808% ########### ( 2, 3 ] 96341 20.441% 82.249% #### ( 3, 4 ] 37858 8.032% 90.281% ## ( 4, 6 ] 32497 6.895% 97.176% # ( 6, 10 ] 8218 1.744% 98.920% ( 10, 15 ] 1453 0.308% 99.228% ( 15, 22 ] 201 0.043% 99.271% ( 22, 34 ] 76 0.016% 99.287% ( 34, 51 ] 27 0.006% 99.293% ( 51, 76 ] 9 0.002% 99.295% ( 76, 110 ] 144 0.031% 99.325% ( 110, 170 ] 491 0.104% 99.429% ( 170, 250 ] 428 0.091% 99.520% ( 250, 380 ] 479 0.102% 99.622% ( 380, 580 ] 624 0.132% 99.754% ( 580, 870 ] 602 0.128% 99.882% ( 870, 1300 ] 368 0.078% 99.960% ( 1300, 1900 ] 180 0.038% 99.998% ( 1900, 2900 ] 146 0.031% 100.029% ( 2900, 4400 ] 147 0.031% 100.060% ( 4400, 6600 ] 24 0.005% 100.066% ( 6600, 9900 ] 3 0.001% 100.066% ( 14000, 22000 ] 4 0.001% 100.067% ** Level 4 read latency histogram (micros): Count: 164106 Average: 16.1210 StdDev: 195.29 Min: 0 Median: 1.9905 Max: 23438 Percentiles: P50: 1.99 P75: 3.01 P99: 249.26 P99.9: 2444.71 P99.99: 3810.91 ------------------------------------------------------ [ 0, 1 ] 2840 1.731% 1.731% ( 1, 2 ] 79970 48.731% 50.461% ########## ( 2, 3 ] 40164 24.474% 74.936% ##### ( 3, 4 ] 18238 11.114% 86.049% ## ( 4, 6 ] 16272 9.916% 95.965% ## ( 6, 10 ] 3710 2.261% 98.226% ( 10, 15 ] 733 0.447% 98.672% ( 15, 22 ] 86 0.052% 98.725% ( 22, 34 ] 20 0.012% 98.737% ( 34, 51 ] 7 0.004% 98.741% ( 51, 76 ] 1 0.001% 98.742% ( 76, 110 ] 55 0.034% 98.775% ( 110, 170 ] 147 0.090% 98.865% ( 170, 250 ] 224 0.136% 99.001% ( 250, 380 ] 280 0.171% 99.172% ( 380, 580 ] 349 0.213% 99.385% ( 580, 870 ] 350 0.213% 99.598% ( 870, 1300 ] 260 0.158% 99.756% ( 1300, 1900 ] 158 0.096% 99.853% ( 1900, 2900 ] 143 0.087% 99.940% ( 2900, 4400 ] 136 0.083% 100.023% ( 4400, 6600 ] 18 0.011% 100.034% ( 6600, 9900 ] 7 0.004% 100.038% ( 9900, 14000 ] 2 0.001% 100.039% ( 14000, 22000 ] 3 0.002% 100.041% ( 22000, 33000 ] 1 0.001% 100.041% ** Level 5 read latency histogram (micros): Count: 280 Average: 1623.5714 StdDev: 1563.06 Min: 84 Median: 951.9048 Max: 7362 Percentiles: P50: 951.90 P75: 2584.21 P99: 7362.00 P99.9: 7362.00 P99.99: 7362.00 ------------------------------------------------------ ( 76, 110 ] 2 0.714% 0.714% ( 110, 170 ] 15 5.357% 6.071% # ( 170, 250 ] 26 9.286% 15.357% ## ( 250, 380 ] 26 9.286% 24.643% ## ( 380, 580 ] 34 12.143% 36.786% ## ( 580, 870 ] 33 11.786% 48.571% ## ( 870, 1300 ] 21 7.500% 56.071% ## ( 1300, 1900 ] 27 9.643% 65.714% ## ( 1900, 2900 ] 38 13.571% 79.286% ### ( 2900, 4400 ] 42 15.000% 94.286% ### ( 4400, 6600 ] 12 4.286% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 53.0 total, 4.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 185.76 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:25.644 H:M:S, 48.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 226.87 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.602 H:M:S, 36.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-00:56:36 ... thread 0: (1000000,11000000) ops and (160624.4,186407.0) ops/second in (6.225704,59.010670) 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/12 3.13 GB 0.0 9.4 0.0 9.4 19.7 10.4 0.0 1.9 134.1 283.1 71.38 63.10 181 0.394 9721K 11K 0.0 0.0 L1 13/12 1.16 GB 0.0 8.6 7.1 1.5 8.5 7.0 0.1 1.2 213.7 211.0 41.23 36.85 6 6.871 8685K 111K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.1 0.1 0.1 5.9 2.0 234.9 234.8 0.54 0.52 1 0.536 127K 41 0.0 0.0 L3 26/9 1.57 GB 0.9 4.3 2.1 2.2 4.3 2.1 4.0 2.1 191.7 191.1 22.92 19.38 17 1.348 4300K 13K 0.0 0.0 L4 162/22 10.20 GB 0.9 5.2 3.9 1.3 5.2 3.9 1.3 1.3 123.3 122.7 43.19 24.90 38 1.137 4723K 20K 0.0 0.0 L5 1096/0 90.31 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 1309/55 106.37 GB 0.0 27.6 13.2 14.4 37.8 23.4 16.0 3.6 157.5 216.0 179.25 144.75 243 0.738 27M 157K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.6 13.2 14.4 37.8 23.4 16.0 3.6 157.5 216.0 179.25 144.75 243 0.738 27M 157K 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.6 13.2 14.4 27.4 13.0 0.0 0.0 194.4 193.3 145.22 117.75 94 1.545 27M 157K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.4 10.4 0.0 0.0 0.0 312.8 34.03 27.00 149 0.228 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): 59.2 total, 59.0 interval Flush(GB): cumulative 10.397, interval 10.397 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: 37.81 GB write, 653.83 MB/s write, 27.57 GB read, 476.84 MB/s read, 179.3 seconds Interval compaction: 37.81 GB write, 656.01 MB/s write, 27.57 GB read, 478.43 MB/s read, 179.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 59, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 59, interval: 82 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4315335 Average: 2.7464 StdDev: 30.64 Min: 0 Median: 1.4441 Max: 20958 Percentiles: P50: 1.44 P75: 1.85 P99: 5.97 P99.9: 135.50 P99.99: 487.86 ------------------------------------------------------ [ 0, 1 ] 985201 22.830% 22.830% ##### ( 1, 2 ] 2640246 61.183% 84.013% ############ ( 2, 3 ] 382643 8.867% 92.880% ## ( 3, 4 ] 151008 3.499% 96.379% # ( 4, 6 ] 115021 2.665% 99.045% # ( 6, 10 ] 24185 0.560% 99.605% ( 10, 15 ] 3935 0.091% 99.697% ( 15, 22 ] 595 0.014% 99.710% ( 22, 34 ] 38 0.001% 99.711% ( 34, 51 ] 25 0.001% 99.712% ( 51, 76 ] 165 0.004% 99.716% ( 76, 110 ] 6217 0.144% 99.860% ( 110, 170 ] 4096 0.095% 99.955% ( 170, 250 ] 675 0.016% 99.970% ( 250, 380 ] 552 0.013% 99.983% ( 380, 580 ] 559 0.013% 99.996% ( 580, 870 ] 358 0.008% 100.004% ( 870, 1300 ] 158 0.004% 100.008% ( 1300, 1900 ] 100 0.002% 100.010% ( 1900, 2900 ] 93 0.002% 100.012% ( 2900, 4400 ] 92 0.002% 100.015% ( 4400, 6600 ] 18 0.000% 100.015% ( 6600, 9900 ] 5 0.000% 100.015% ( 14000, 22000 ] 2 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 1836382 Average: 5.8074 StdDev: 90.52 Min: 0 Median: 1.8626 Max: 25633 Percentiles: P50: 1.86 P75: 2.79 P99: 9.07 P99.9: 106.19 P99.99: 369.71 ------------------------------------------------------ [ 0, 1 ] 76502 4.166% 4.166% # ( 1, 2 ] 975753 53.135% 57.300% ########### ( 2, 3 ] 411907 22.430% 79.731% #### ( 3, 4 ] 164966 8.983% 88.714% ## ( 4, 6 ] 159105 8.664% 97.378% ## ( 6, 10 ] 38753 2.110% 99.488% ( 10, 15 ] 6411 0.349% 99.837% ( 15, 22 ] 797 0.043% 99.881% ( 22, 34 ] 47 0.003% 99.883% ( 34, 51 ] 10 0.001% 99.884% ( 51, 76 ] 22 0.001% 99.885% ( 76, 110 ] 307 0.017% 99.902% ( 110, 170 ] 604 0.033% 99.935% ( 170, 250 ] 437 0.024% 99.959% ( 250, 380 ] 627 0.034% 99.993% ( 380, 580 ] 802 0.044% 100.036% ( 580, 870 ] 784 0.043% 100.079% ( 870, 1300 ] 568 0.031% 100.110% ( 1300, 1900 ] 347 0.019% 100.129% ( 1900, 2900 ] 374 0.020% 100.149% ( 2900, 4400 ] 393 0.021% 100.171% ( 4400, 6600 ] 101 0.005% 100.176% ( 6600, 9900 ] 31 0.002% 100.178% ( 9900, 14000 ] 2 0.000% 100.178% ( 14000, 22000 ] 2 0.000% 100.178% ( 22000, 33000 ] 1 0.000% 100.178% ** Level 2 read latency histogram (micros): Count: 60303 Average: 3.0215 StdDev: 31.36 Min: 1 Median: 1.5829 Max: 4714 Percentiles: P50: 1.58 P75: 1.97 P99: 8.23 P99.9: 161.42 P99.99: 1078.49 ------------------------------------------------------ [ 0, 1 ] 7186 11.916% 11.916% ## ( 1, 2 ] 39398 65.333% 77.250% ############# ( 2, 3 ] 7821 12.970% 90.219% ### ( 3, 4 ] 2769 4.592% 94.811% # ( 4, 6 ] 2063 3.421% 98.232% # ( 6, 10 ] 830 1.376% 99.609% ( 10, 15 ] 82 0.136% 99.745% ( 15, 22 ] 11 0.018% 99.763% ( 22, 34 ] 2 0.003% 99.766% ( 76, 110 ] 1 0.002% 99.768% ( 110, 170 ] 93 0.154% 99.922% ( 170, 250 ] 13 0.022% 99.944% ( 250, 380 ] 12 0.020% 99.964% ( 380, 580 ] 13 0.022% 99.985% ( 580, 870 ] 2 0.003% 99.988% ( 870, 1300 ] 2 0.003% 99.992% ( 1300, 1900 ] 2 0.003% 99.995% ( 2900, 4400 ] 2 0.003% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 813926 Average: 7.3641 StdDev: 103.39 Min: 0 Median: 1.8860 Max: 21964 Percentiles: P50: 1.89 P75: 2.84 P99: 9.80 P99.9: 694.43 P99.99: 1147.48 ------------------------------------------------------ [ 0, 1 ] 30227 3.714% 3.714% # ( 1, 2 ] 425223 52.243% 55.957% ########## ( 2, 3 ] 185366 22.774% 78.731% ##### ( 3, 4 ] 76301 9.374% 88.106% ## ( 4, 6 ] 73654 9.049% 97.155% ## ( 6, 10 ] 15788 1.940% 99.095% ( 10, 15 ] 3053 0.375% 99.470% ( 15, 22 ] 380 0.047% 99.517% ( 22, 34 ] 85 0.010% 99.527% ( 34, 51 ] 38 0.005% 99.532% ( 51, 76 ] 15 0.002% 99.534% ( 76, 110 ] 212 0.026% 99.560% ( 110, 170 ] 602 0.074% 99.634% ( 170, 250 ] 544 0.067% 99.700% ( 250, 380 ] 583 0.072% 99.772% ( 380, 580 ] 756 0.093% 99.865% ( 580, 870 ] 725 0.089% 99.954% ( 870, 1300 ] 455 0.056% 100.010% ( 1300, 1900 ] 232 0.029% 100.038% ( 1900, 2900 ] 204 0.025% 100.064% ( 2900, 4400 ] 222 0.027% 100.091% ( 4400, 6600 ] 38 0.005% 100.095% ( 6600, 9900 ] 7 0.001% 100.096% ( 14000, 22000 ] 4 0.000% 100.097% ** Level 4 read latency histogram (micros): Count: 427205 Average: 15.0854 StdDev: 192.51 Min: 0 Median: 2.1089 Max: 23438 Percentiles: P50: 2.11 P75: 3.21 P99: 14.29 P99.9: 1589.99 P99.99: 2615.64 ------------------------------------------------------ [ 0, 1 ] 5203 1.218% 1.218% ( 1, 2 ] 196575 46.014% 47.232% ######### ( 2, 3 ] 108546 25.408% 72.641% ##### ( 3, 4 ] 49116 11.497% 84.138% ## ( 4, 6 ] 49837 11.666% 95.803% ## ( 6, 10 ] 11693 2.737% 98.541% # ( 10, 15 ] 2291 0.536% 99.077% ( 15, 22 ] 261 0.061% 99.138% ( 22, 34 ] 40 0.009% 99.147% ( 34, 51 ] 24 0.006% 99.153% ( 51, 76 ] 11 0.003% 99.155% ( 76, 110 ] 70 0.016% 99.172% ( 110, 170 ] 200 0.047% 99.219% ( 170, 250 ] 327 0.077% 99.295% ( 250, 380 ] 476 0.111% 99.407% ( 380, 580 ] 678 0.159% 99.565% ( 580, 870 ] 723 0.169% 99.735% ( 870, 1300 ] 557 0.130% 99.865% ( 1300, 1900 ] 312 0.073% 99.938% ( 1900, 2900 ] 312 0.073% 100.011% ( 2900, 4400 ] 390 0.091% 100.102% ( 4400, 6600 ] 83 0.019% 100.122% ( 6600, 9900 ] 32 0.007% 100.129% ( 9900, 14000 ] 4 0.001% 100.130% ( 14000, 22000 ] 6 0.001% 100.132% ( 22000, 33000 ] 2 0.000% 100.132% ** Level 5 read latency histogram (micros): Count: 280 Average: 1623.5714 StdDev: 1563.06 Min: 84 Median: 951.9048 Max: 7362 Percentiles: P50: 951.90 P75: 2584.21 P99: 7362.00 P99.9: 7362.00 P99.99: 7362.00 ------------------------------------------------------ ( 76, 110 ] 2 0.714% 0.714% ( 110, 170 ] 15 5.357% 6.071% # ( 170, 250 ] 26 9.286% 15.357% ## ( 250, 380 ] 26 9.286% 24.643% ## ( 380, 580 ] 34 12.143% 36.786% ## ( 580, 870 ] 33 11.786% 48.571% ## ( 870, 1300 ] 21 7.500% 56.071% ## ( 1300, 1900 ] 27 9.643% 65.714% ## ( 1900, 2900 ] 38 13.571% 79.286% ### ( 2900, 4400 ] 42 15.000% 94.286% ### ( 4400, 6600 ] 12 4.286% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 59.2 total, 6.2 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 182.85 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:28.796 H:M:S, 48.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 158.08 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.152 H:M:S, 50.6 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 : 5.328 micros/op 187676 ops/sec 60.002 seconds 11260999 operations; 181.8 MB/s Microseconds per write: Count: 11260999 Average: 5.3283 StdDev: 515.94 Min: 1 Median: 1.7501 Max: 884773 Percentiles: P50: 1.75 P75: 2.76 P99: 7.13 P99.9: 1051.85 P99.99: 2732.99 ------------------------------------------------------ [ 0, 1 ] 1375291 12.213% 12.213% ## ( 1, 2 ] 5673027 50.378% 62.591% ########## ( 2, 3 ] 1841330 16.351% 78.942% ### ( 3, 4 ] 1605381 14.256% 93.198% ### ( 4, 6 ] 630319 5.597% 98.795% # ( 6, 10 ] 81458 0.723% 99.519% ( 10, 15 ] 18819 0.167% 99.686% ( 15, 22 ] 6721 0.060% 99.746% ( 22, 34 ] 1963 0.017% 99.763% ( 34, 51 ] 244 0.002% 99.765% ( 51, 76 ] 41 0.000% 99.766% ( 76, 110 ] 7630 0.068% 99.833% ( 110, 170 ] 3407 0.030% 99.864% ( 170, 250 ] 306 0.003% 99.866% ( 250, 380 ] 89 0.001% 99.867% ( 380, 580 ] 28 0.000% 99.867% ( 580, 870 ] 30 0.000% 99.868% ( 870, 1300 ] 8640 0.077% 99.944% ( 1300, 1900 ] 31 0.000% 99.945% ( 1900, 2900 ] 6144 0.055% 99.999% ( 2900, 4400 ] 55 0.000% 100.000% ( 4400, 6600 ] 10 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 4 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 5 0.000% 100.000% ( 170000, 250000 ] 13 0.000% 100.000% ( 250000, 380000 ] 3 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 193470 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 : 11260999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11621350968 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 : 655 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 29078754 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 : 31626372956 rocksdb.compact.write.bytes COUNT : 31422493310 rocksdb.flush.write.bytes COUNT : 11493945566 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 : 81 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 : 386 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 : 11401313280 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4463616 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 : 31741316349 rocksdb.non.last.level.read.count COUNT : 7661098 rocksdb.block.checksum.compute.count COUNT : 7659869 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.418172 P95 : 3.854395 P99 : 5.904499 P100 : 884766.000000 COUNT : 11260999 SUM : 54953735 rocksdb.compaction.times.micros P50 : 1145000.000000 P95 : 3495000.000000 P99 : 13874000.000000 P100 : 19053198.000000 COUNT : 103 SUM : 157430874 rocksdb.compaction.times.cpu_micros P50 : 875454.545455 P95 : 3197500.000000 P99 : 13874000.000000 P100 : 17229882.000000 COUNT : 103 SUM : 125718425 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 : 719.562500 P95 : 6123.333333 P99 : 207600.000000 P100 : 520729.000000 COUNT : 153 SUM : 954532 rocksdb.compaction.outfile.sync.micros P50 : 1105.476190 P95 : 93375.000000 P99 : 289866.666667 P100 : 308423.000000 COUNT : 416 SUM : 6737164 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 : 108.210526 P95 : 1820.000000 P99 : 4220.000000 P100 : 20480.000000 COUNT : 296 SUM : 123662 rocksdb.table.open.io.micros P50 : 1388.392857 P95 : 8852.027027 P99 : 17066.666667 P100 : 22579.000000 COUNT : 655 SUM : 1512823 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.674317 P95 : 8.029301 P99 : 11.766681 P100 : 25637.000000 COUNT : 7658046 SUM : 52419099 rocksdb.read.block.get.micros P50 : 401.848739 P95 : 3742.592593 P99 : 6090.000000 P100 : 11994.000000 COUNT : 1310 SUM : 1206128 rocksdb.write.raw.block.micros P50 : 0.513748 P95 : 0.976122 P99 : 2.983135 P100 : 26706.000000 COUNT : 10398798 SUM : 22678149 rocksdb.numfiles.in.singlecompaction P50 : 3.304762 P95 : 5.257143 P99 : 20.320000 P100 : 24.000000 COUNT : 172 SUM : 677 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.564154 P95 : 1281.491651 P99 : 2691.653259 P100 : 884571.000000 COUNT : 130104 SUM : 29086926 rocksdb.sst.read.micros P50 : 1.619012 P95 : 4.848499 P99 : 8.771835 P100 : 25633.000000 COUNT : 7661446 SUM : 36823457 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 : 11260999 SUM : 11621350968 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 : 212083.333333 P95 : 489681.818182 P99 : 1026345.000000 P100 : 1026345.000000 COUNT : 153 SUM : 35272684 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 : 423 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