[2024-11-19 13:32:20.129834] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 23.11.0 initialization... [2024-11-19 13:32:20.130099] [ 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_pid3935399 ] Set seed to 1732019540123153 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 13:32:20.243037] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 13:32:20.285213] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 13:32:20.285262] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3935399' to capture a snapshot of events at runtime. [2024-11-19 13:32:20.285273] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 13:32:20.285284] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 13:32:20.285292] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3935399 for offline analysis/debug. [2024-11-19 13:32:20.285380] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 13:32:24 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-13:32:27 ... thread 0: (1000000,1000000) ops and (360135.1,360135.1) ops/second in (2.776736,2.776736) 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/6 504.02 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 353.5 2.32 2.10 12 0.193 0 0 0.0 0.0 L1 1/0 2.42 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 246.8 246.6 1.02 0.99 1 1.021 255K 233 0.0 0.0 L2 3/2 298.06 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.2 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 19/12 944.32 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.3 198.3 0.31 0.26 1 0.315 63K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1187/20 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 102.9 300.9 4.13 3.79 15 0.276 432K 266 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.4 1.5 102.9 300.9 4.13 3.79 15 0.276 432K 266 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 234.1 233.9 1.82 1.69 3 0.606 432K 266 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 353.5 2.32 2.10 12 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.22 GB write, 419.30 MB/s write, 0.42 GB read, 143.42 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 447.90 MB/s write, 0.42 GB read, 153.20 MB/s read, 4.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: 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: 109897 Average: 1.7720 StdDev: 13.41 Min: 0 Median: 1.1578 Max: 3996 Percentiles: P50: 1.16 P75: 1.62 P99: 3.91 P99.9: 9.52 P99.99: 250.17 ------------------------------------------------------ [ 0, 1 ] 45635 41.525% 41.525% ######## ( 1, 2 ] 59009 53.695% 95.220% ########### ( 2, 3 ] 3109 2.829% 98.049% # ( 3, 4 ] 1145 1.042% 99.091% ( 4, 6 ] 664 0.604% 99.695% ( 6, 10 ] 258 0.235% 99.930% ( 10, 15 ] 38 0.035% 99.965% ( 15, 22 ] 9 0.008% 99.973% ( 22, 34 ] 5 0.005% 99.977% ( 34, 51 ] 3 0.003% 99.980% ( 110, 170 ] 9 0.008% 99.988% ( 170, 250 ] 4 0.004% 99.992% ( 250, 380 ] 8 0.007% 99.999% ( 380, 580 ] 1 0.001% 100.000% ( 1300, 1900 ] 1 0.001% 100.001% ( 2900, 4400 ] 1 0.001% 100.002% ** Level 1 read latency histogram (micros): Count: 2940 Average: 3.4939 StdDev: 21.73 Min: 0 Median: 1.7985 Max: 874 Percentiles: P50: 1.80 P75: 2.73 P99: 9.09 P99.9: 392.00 P99.99: 874.00 ------------------------------------------------------ [ 0, 1 ] 174 5.918% 5.918% # ( 1, 2 ] 1623 55.204% 61.122% ########### ( 2, 3 ] 560 19.048% 80.170% #### ( 3, 4 ] 292 9.932% 90.102% ## ( 4, 6 ] 216 7.347% 97.449% # ( 6, 10 ] 59 2.007% 99.456% ( 10, 15 ] 8 0.272% 99.728% ( 15, 22 ] 3 0.102% 99.830% ( 22, 34 ] 1 0.034% 99.864% ( 250, 380 ] 1 0.034% 99.898% ( 380, 580 ] 1 0.034% 99.932% ( 580, 870 ] 1 0.034% 99.966% ( 870, 1300 ] 1 0.034% 100.000% ** Level 2 read latency histogram (micros): Count: 28107 Average: 2.3906 StdDev: 17.67 Min: 1 Median: 1.2163 Max: 1540 Percentiles: P50: 1.22 P75: 1.67 P99: 5.94 P99.9: 232.25 P99.99: 822.98 ------------------------------------------------------ [ 0, 1 ] 10731 38.179% 38.179% ######## ( 1, 2 ] 15362 54.655% 92.835% ########### ( 2, 3 ] 1299 4.622% 97.456% # ( 3, 4 ] 247 0.879% 98.335% ( 4, 6 ] 193 0.687% 99.022% ( 6, 10 ] 158 0.562% 99.584% ( 10, 15 ] 25 0.089% 99.673% ( 15, 22 ] 2 0.007% 99.680% ( 22, 34 ] 3 0.011% 99.690% ( 34, 51 ] 27 0.096% 99.787% ( 51, 76 ] 11 0.039% 99.826% ( 76, 110 ] 5 0.018% 99.843% ( 110, 170 ] 5 0.018% 99.861% ( 170, 250 ] 14 0.050% 99.911% ( 250, 380 ] 15 0.053% 99.964% ( 380, 580 ] 3 0.011% 99.975% ( 580, 870 ] 5 0.018% 99.993% ( 870, 1300 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 5393 Average: 21.8882 StdDev: 219.35 Min: 1 Median: 1.8137 Max: 5659 Percentiles: P50: 1.81 P75: 2.81 P99: 435.82 P99.9: 3763.81 P99.99: 5471.18 ------------------------------------------------------ [ 0, 1 ] 523 9.698% 9.698% ## ( 1, 2 ] 2672 49.546% 59.243% ########## ( 2, 3 ] 1050 19.470% 78.713% #### ( 3, 4 ] 409 7.584% 86.297% ## ( 4, 6 ] 393 7.287% 93.584% # ( 6, 10 ] 170 3.152% 96.737% # ( 10, 15 ] 37 0.686% 97.423% ( 15, 22 ] 13 0.241% 97.664% ( 22, 34 ] 5 0.093% 97.756% ( 34, 51 ] 1 0.019% 97.775% ( 76, 110 ] 24 0.445% 98.220% ( 110, 170 ] 26 0.482% 98.702% ( 170, 250 ] 7 0.130% 98.832% ( 250, 380 ] 7 0.130% 98.962% ( 380, 580 ] 11 0.204% 99.166% ( 580, 870 ] 15 0.278% 99.444% ( 870, 1300 ] 10 0.185% 99.629% ( 1300, 1900 ] 4 0.074% 99.703% ( 1900, 2900 ] 7 0.130% 99.833% ( 2900, 4400 ] 8 0.148% 99.981% ( 4400, 6600 ] 3 0.056% 100.037% ** Level 4 read latency histogram (micros): Count: 20 Average: 1644.9000 StdDev: 1328.11 Min: 405 Median: 1013.3333 Max: 4900 Percentiles: P50: 1013.33 P75: 2566.67 P99: 4900.00 P99.9: 4900.00 P99.99: 4900.00 ------------------------------------------------------ ( 380, 580 ] 3 15.000% 15.000% ### ( 580, 870 ] 6 30.000% 45.000% ###### ( 870, 1300 ] 3 15.000% 60.000% ### ( 1300, 1900 ] 1 5.000% 65.000% # ( 1900, 2900 ] 3 15.000% 80.000% ### ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.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, 331.62 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.199 H:M:S, 6.7 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.199 H:M:S, 7.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-13:32:30 ... thread 0: (1000000,2000000) ops and (321310.7,339616.9) ops/second in (3.112252,5.888988) 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/10 1.48 GB 6.3 0.9 0.0 0.9 2.7 1.8 0.0 1.5 106.0 310.8 8.92 8.28 29 0.307 959K 1182 0.0 0.0 L1 1/1 2.42 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 246.8 246.6 1.02 0.99 1 1.021 255K 233 0.0 0.0 L2 1/1 48.75 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.2 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 51/11 1.17 GB 0.3 0.4 0.3 0.1 0.4 0.3 0.0 1.3 163.8 163.8 2.45 1.98 3 0.818 379K 87 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1220/23 97.92 GB 0.0 1.7 0.6 1.1 3.5 2.3 0.4 1.9 132.8 274.6 12.87 11.70 34 0.379 1708K 1535 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.6 1.1 3.5 2.3 0.4 1.9 132.8 274.6 12.87 11.70 34 0.379 1708K 1535 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.6 1.1 1.7 0.5 0.0 0.0 223.9 223.6 7.64 7.04 8 0.955 1708K 1535 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 349.1 5.23 4.66 26 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.45 GB write, 581.48 MB/s write, 1.67 GB read, 281.26 MB/s read, 12.9 seconds Interval compaction: 3.45 GB write, 600.18 MB/s write, 1.67 GB read, 290.31 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: 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: 383826 Average: 2.2351 StdDev: 12.08 Min: 0 Median: 1.5012 Max: 3996 Percentiles: P50: 1.50 P75: 1.90 P99: 5.77 P99.9: 11.01 P99.99: 20.36 ------------------------------------------------------ [ 0, 1 ] 72274 18.830% 18.830% #### ( 1, 2 ] 238696 62.189% 81.018% ############ ( 2, 3 ] 42328 11.028% 92.046% ## ( 3, 4 ] 15998 4.168% 96.214% # ( 4, 6 ] 12094 3.151% 99.365% # ( 6, 10 ] 1975 0.515% 99.880% ( 10, 15 ] 382 0.100% 99.979% ( 15, 22 ] 53 0.014% 99.993% ( 22, 34 ] 6 0.002% 99.995% ( 34, 51 ] 7 0.002% 99.997% ( 51, 76 ] 1 0.000% 99.997% ( 110, 170 ] 13 0.003% 100.000% ( 170, 250 ] 12 0.003% 100.003% ( 250, 380 ] 15 0.004% 100.007% ( 380, 580 ] 5 0.001% 100.009% ( 580, 870 ] 5 0.001% 100.010% ( 870, 1300 ] 2 0.001% 100.010% ( 1300, 1900 ] 2 0.001% 100.011% ( 1900, 2900 ] 1 0.000% 100.011% ( 2900, 4400 ] 3 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 63306 Average: 2.5715 StdDev: 4.83 Min: 0 Median: 1.7223 Max: 874 Percentiles: P50: 1.72 P75: 2.40 P99: 6.48 P99.9: 13.31 P99.99: 21.83 ------------------------------------------------------ [ 0, 1 ] 3017 4.766% 4.766% # ( 1, 2 ] 39643 62.621% 67.387% ############# ( 2, 3 ] 12122 19.148% 86.535% #### ( 3, 4 ] 4256 6.723% 93.258% # ( 4, 6 ] 3569 5.638% 98.896% # ( 6, 10 ] 551 0.870% 99.766% ( 10, 15 ] 128 0.202% 99.968% ( 15, 22 ] 14 0.022% 99.991% ( 22, 34 ] 2 0.003% 99.994% ( 250, 380 ] 1 0.002% 99.995% ( 380, 580 ] 1 0.002% 99.997% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 28219 Average: 2.3924 StdDev: 17.63 Min: 1 Median: 1.2193 Max: 1540 Percentiles: P50: 1.22 P75: 1.68 P99: 5.94 P99.9: 231.61 P99.99: 822.33 ------------------------------------------------------ [ 0, 1 ] 10731 38.028% 38.028% ######## ( 1, 2 ] 15404 54.587% 92.615% ########### ( 2, 3 ] 1355 4.802% 97.417% # ( 3, 4 ] 253 0.897% 98.313% ( 4, 6 ] 200 0.709% 99.022% ( 6, 10 ] 159 0.563% 99.585% ( 10, 15 ] 25 0.089% 99.674% ( 15, 22 ] 2 0.007% 99.681% ( 22, 34 ] 3 0.011% 99.692% ( 34, 51 ] 27 0.096% 99.787% ( 51, 76 ] 11 0.039% 99.826% ( 76, 110 ] 5 0.018% 99.844% ( 110, 170 ] 5 0.018% 99.862% ( 170, 250 ] 14 0.050% 99.911% ( 250, 380 ] 15 0.053% 99.965% ( 380, 580 ] 3 0.011% 99.975% ( 580, 870 ] 5 0.018% 99.993% ( 870, 1300 ] 1 0.004% 99.996% ( 1300, 1900 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 215209 Average: 3.5491 StdDev: 37.92 Min: 1 Median: 1.6623 Max: 5659 Percentiles: P50: 1.66 P75: 2.29 P99: 9.20 P99.9: 207.10 P99.99: 561.37 ------------------------------------------------------ [ 0, 1 ] 22071 10.256% 10.256% ## ( 1, 2 ] 129149 60.011% 70.267% ############ ( 2, 3 ] 35448 16.471% 86.738% ### ( 3, 4 ] 12638 5.872% 92.610% # ( 4, 6 ] 10323 4.797% 97.407% # ( 6, 10 ] 4288 1.992% 99.400% ( 10, 15 ] 469 0.218% 99.618% ( 15, 22 ] 129 0.060% 99.678% ( 22, 34 ] 56 0.026% 99.704% ( 34, 51 ] 10 0.005% 99.708% ( 51, 76 ] 19 0.009% 99.717% ( 76, 110 ] 90 0.042% 99.759% ( 110, 170 ] 250 0.116% 99.875% ( 170, 250 ] 116 0.054% 99.929% ( 250, 380 ] 68 0.032% 99.961% ( 380, 580 ] 70 0.033% 99.993% ( 580, 870 ] 32 0.015% 100.008% ( 870, 1300 ] 15 0.007% 100.015% ( 1300, 1900 ] 5 0.002% 100.017% ( 1900, 2900 ] 8 0.004% 100.021% ( 2900, 4400 ] 8 0.004% 100.025% ( 4400, 6600 ] 3 0.001% 100.026% ** Level 4 read latency histogram (micros): Count: 20 Average: 1644.9000 StdDev: 1328.11 Min: 405 Median: 1013.3333 Max: 4900 Percentiles: P50: 1013.33 P75: 2566.67 P99: 4900.00 P99.9: 4900.00 P99.99: 4900.00 ------------------------------------------------------ ( 380, 580 ] 3 15.000% 15.000% ### ( 580, 870 ] 6 30.000% 45.000% ###### ( 870, 1300 ] 3 15.000% 60.000% ### ( 1300, 1900 ] 1 5.000% 65.000% # ( 1900, 2900 ] 3 15.000% 80.000% ### ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 323.75 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.581 H:M:S, 9.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 316.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:0.382 H:M:S, 12.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/19-13:32:33 ... thread 0: (1000000,3000000) ops and (331882.2,336998.9) ops/second in (3.013117,8.902105) 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/10 2.40 GB 100.7 1.7 0.0 1.7 4.4 2.7 0.0 1.6 119.0 305.7 14.83 13.84 45 0.330 1791K 1994 0.0 0.0 L1 1/1 2.42 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 246.8 246.6 1.02 0.99 1 1.021 255K 233 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.2 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 22/0 961.49 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.7 208.3 208.1 6.40 5.62 4 1.600 1325K 629 0.0 0.0 L4 169/0 9.56 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 163.2 163.2 0.75 0.60 1 0.754 124K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1251/11 98.84 GB 0.0 3.5 0.7 2.8 6.2 3.4 0.8 2.3 152.6 270.4 23.49 21.50 52 0.452 3610K 2889 0.0 0.0 Int 0/0 0.00 KB 0.0 3.5 0.7 2.8 6.2 3.4 0.8 2.3 152.6 270.4 23.49 21.50 52 0.452 3610K 2889 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.5 0.7 2.8 3.5 0.7 0.0 0.0 229.9 229.7 15.59 14.46 13 1.199 3610K 2889 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 350.9 7.90 7.04 39 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.20 GB write, 698.52 MB/s write, 3.50 GB read, 394.01 MB/s read, 23.5 seconds Interval compaction: 6.20 GB write, 713.38 MB/s write, 3.50 GB read, 402.40 MB/s read, 23.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 776578 Average: 2.2520 StdDev: 10.54 Min: 0 Median: 1.5294 Max: 3996 Percentiles: P50: 1.53 P75: 1.91 P99: 5.70 P99.9: 9.84 P99.99: 14.14 ------------------------------------------------------ [ 0, 1 ] 119773 15.423% 15.423% ### ( 1, 2 ] 507239 65.317% 80.740% ############# ( 2, 3 ] 90152 11.609% 92.349% ## ( 3, 4 ] 32645 4.204% 96.553% # ( 4, 6 ] 22299 2.871% 99.424% # ( 6, 10 ] 3851 0.496% 99.920% ( 10, 15 ] 656 0.084% 100.005% ( 15, 22 ] 71 0.009% 100.014% ( 22, 34 ] 9 0.001% 100.015% ( 34, 51 ] 7 0.001% 100.016% ( 51, 76 ] 2 0.000% 100.016% ( 110, 170 ] 29 0.004% 100.020% ( 170, 250 ] 23 0.003% 100.023% ( 250, 380 ] 27 0.003% 100.026% ( 380, 580 ] 8 0.001% 100.027% ( 580, 870 ] 13 0.002% 100.029% ( 870, 1300 ] 6 0.001% 100.030% ( 1300, 1900 ] 3 0.000% 100.030% ( 1900, 2900 ] 2 0.000% 100.031% ( 2900, 4400 ] 4 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 63306 Average: 2.5715 StdDev: 4.83 Min: 0 Median: 1.7223 Max: 874 Percentiles: P50: 1.72 P75: 2.40 P99: 6.48 P99.9: 13.31 P99.99: 21.83 ------------------------------------------------------ [ 0, 1 ] 3017 4.766% 4.766% # ( 1, 2 ] 39643 62.621% 67.387% ############# ( 2, 3 ] 12122 19.148% 86.535% #### ( 3, 4 ] 4256 6.723% 93.258% # ( 4, 6 ] 3569 5.638% 98.896% # ( 6, 10 ] 551 0.870% 99.766% ( 10, 15 ] 128 0.202% 99.968% ( 15, 22 ] 14 0.022% 99.991% ( 22, 34 ] 2 0.003% 99.994% ( 250, 380 ] 1 0.002% 99.995% ( 380, 580 ] 1 0.002% 99.997% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 278520 Average: 3.4601 StdDev: 34.63 Min: 1 Median: 1.6657 Max: 5659 Percentiles: P50: 1.67 P75: 2.28 P99: 9.02 P99.9: 211.62 P99.99: 595.19 ------------------------------------------------------ [ 0, 1 ] 26244 9.423% 9.423% ## ( 1, 2 ] 169768 60.954% 70.376% ############ ( 2, 3 ] 46804 16.805% 87.181% ### ( 3, 4 ] 16016 5.750% 92.931% # ( 4, 6 ] 13065 4.691% 97.622% # ( 6, 10 ] 5090 1.828% 99.450% ( 10, 15 ] 539 0.194% 99.643% ( 15, 22 ] 133 0.048% 99.691% ( 22, 34 ] 58 0.021% 99.712% ( 34, 51 ] 11 0.004% 99.716% ( 51, 76 ] 19 0.007% 99.722% ( 76, 110 ] 120 0.043% 99.766% ( 110, 170 ] 298 0.107% 99.873% ( 170, 250 ] 147 0.053% 99.925% ( 250, 380 ] 90 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.989% ( 580, 870 ] 41 0.015% 100.004% ( 870, 1300 ] 18 0.006% 100.010% ( 1300, 1900 ] 8 0.003% 100.013% ( 1900, 2900 ] 8 0.003% 100.016% ( 2900, 4400 ] 8 0.003% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 145 Average: 231.7034 StdDev: 750.35 Min: 1 Median: 1.9000 Max: 4900 Percentiles: P50: 1.90 P75: 11.75 P99: 4175.00 P99.9: 4900.00 P99.99: 4900.00 ------------------------------------------------------ [ 0, 1 ] 32 22.069% 22.069% #### ( 1, 2 ] 45 31.034% 53.103% ###### ( 2, 3 ] 12 8.276% 61.379% ## ( 3, 4 ] 4 2.759% 64.138% # ( 4, 6 ] 5 3.448% 67.586% # ( 6, 10 ] 9 6.207% 73.793% # ( 10, 15 ] 5 3.448% 77.241% # ( 15, 22 ] 12 8.276% 85.517% ## ( 110, 170 ] 1 0.690% 86.207% ( 380, 580 ] 3 2.069% 88.276% ( 580, 870 ] 6 4.138% 92.414% # ( 870, 1300 ] 3 2.069% 94.483% ( 1300, 1900 ] 1 0.690% 95.172% ( 1900, 2900 ] 3 2.069% 97.241% ( 2900, 4400 ] 3 2.069% 99.310% ( 4400, 6600 ] 1 0.690% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 712.1500 StdDev: 736.44 Min: 95 Median: 315.0000 Max: 2434 Percentiles: P50: 315.00 P75: 1300.00 P99: 2434.00 P99.9: 2434.00 P99.99: 2434.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 3 15.000% 25.000% ### ( 170, 250 ] 4 20.000% 45.000% #### ( 250, 380 ] 2 10.000% 55.000% ## ( 380, 580 ] 3 15.000% 70.000% ### ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.70 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.958 H:M:S, 10.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.63 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.377 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-13:32:36 ... thread 0: (1000000,4000000) ops and (329998.8,335221.2) ops/second in (3.030314,11.932419) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/11 2.21 GB 18.9 2.5 0.0 2.5 6.2 3.7 0.0 1.7 124.0 305.3 20.83 19.49 62 0.336 2622K 2836 0.0 0.0 L1 10/10 1.16 GB 0.0 1.4 1.4 0.1 1.4 1.3 0.1 1.0 232.3 231.3 6.24 6.04 2 3.121 1472K 5954 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.2 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 22/0 961.49 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.7 208.3 208.1 6.40 5.62 4 1.600 1325K 629 0.0 0.0 L4 169/0 9.56 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 163.2 163.2 0.75 0.60 1 0.754 124K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1259/21 99.82 GB 0.0 5.5 1.9 3.6 9.2 5.6 0.8 2.5 161.3 269.9 34.71 32.19 70 0.496 5658K 9452 0.0 0.0 Int 0/0 0.00 KB 0.0 5.5 1.9 3.6 9.2 5.6 0.8 2.5 161.3 269.9 34.71 32.19 70 0.496 5658K 9452 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.5 1.9 3.6 5.5 1.9 0.0 0.0 233.8 233.4 23.95 22.58 17 1.409 5658K 9452 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 351.2 10.76 9.61 53 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.15 GB write, 772.87 MB/s write, 5.47 GB read, 461.91 MB/s read, 34.7 seconds Interval compaction: 9.15 GB write, 785.14 MB/s write, 5.47 GB read, 469.24 MB/s read, 34.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1060080 Average: 2.2254 StdDev: 10.45 Min: 0 Median: 1.5017 Max: 3996 Percentiles: P50: 1.50 P75: 1.88 P99: 5.67 P99.9: 9.94 P99.99: 15.22 ------------------------------------------------------ [ 0, 1 ] 180635 17.040% 17.040% ### ( 1, 2 ] 696397 65.693% 82.733% ############# ( 2, 3 ] 111416 10.510% 93.243% ## ( 3, 4 ] 39631 3.738% 96.981% # ( 4, 6 ] 25696 2.424% 99.405% ( 6, 10 ] 5324 0.502% 99.907% ( 10, 15 ] 872 0.082% 99.990% ( 15, 22 ] 96 0.009% 99.999% ( 22, 34 ] 11 0.001% 100.000% ( 34, 51 ] 11 0.001% 100.001% ( 51, 76 ] 5 0.000% 100.001% ( 76, 110 ] 27 0.003% 100.004% ( 110, 170 ] 89 0.008% 100.012% ( 170, 250 ] 58 0.005% 100.018% ( 250, 380 ] 44 0.004% 100.022% ( 380, 580 ] 29 0.003% 100.025% ( 580, 870 ] 19 0.002% 100.026% ( 870, 1300 ] 11 0.001% 100.027% ( 1300, 1900 ] 4 0.000% 100.028% ( 1900, 2900 ] 2 0.000% 100.028% ( 2900, 4400 ] 5 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 76093 Average: 2.9201 StdDev: 16.67 Min: 0 Median: 1.6504 Max: 1718 Percentiles: P50: 1.65 P75: 2.20 P99: 7.27 P99.9: 149.90 P99.99: 955.43 ------------------------------------------------------ [ 0, 1 ] 7252 9.530% 9.530% ## ( 1, 2 ] 47344 62.219% 71.749% ############ ( 2, 3 ] 12446 16.356% 88.105% ### ( 3, 4 ] 4380 5.756% 93.861% # ( 4, 6 ] 3696 4.857% 98.719% # ( 6, 10 ] 674 0.886% 99.604% ( 10, 15 ] 134 0.176% 99.781% ( 15, 22 ] 14 0.018% 99.799% ( 22, 34 ] 3 0.004% 99.803% ( 76, 110 ] 36 0.047% 99.850% ( 110, 170 ] 57 0.075% 99.925% ( 170, 250 ] 14 0.018% 99.943% ( 250, 380 ] 17 0.022% 99.966% ( 380, 580 ] 11 0.014% 99.980% ( 580, 870 ] 6 0.008% 99.988% ( 870, 1300 ] 7 0.009% 99.997% ( 1300, 1900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 278520 Average: 3.4601 StdDev: 34.63 Min: 1 Median: 1.6657 Max: 5659 Percentiles: P50: 1.67 P75: 2.28 P99: 9.02 P99.9: 211.62 P99.99: 595.19 ------------------------------------------------------ [ 0, 1 ] 26244 9.423% 9.423% ## ( 1, 2 ] 169768 60.954% 70.376% ############ ( 2, 3 ] 46804 16.805% 87.181% ### ( 3, 4 ] 16016 5.750% 92.931% # ( 4, 6 ] 13065 4.691% 97.622% # ( 6, 10 ] 5090 1.828% 99.450% ( 10, 15 ] 539 0.194% 99.643% ( 15, 22 ] 133 0.048% 99.691% ( 22, 34 ] 58 0.021% 99.712% ( 34, 51 ] 11 0.004% 99.716% ( 51, 76 ] 19 0.007% 99.722% ( 76, 110 ] 120 0.043% 99.766% ( 110, 170 ] 298 0.107% 99.873% ( 170, 250 ] 147 0.053% 99.925% ( 250, 380 ] 90 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.989% ( 580, 870 ] 41 0.015% 100.004% ( 870, 1300 ] 18 0.006% 100.010% ( 1300, 1900 ] 8 0.003% 100.013% ( 1900, 2900 ] 8 0.003% 100.016% ( 2900, 4400 ] 8 0.003% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 145 Average: 231.7034 StdDev: 750.35 Min: 1 Median: 1.9000 Max: 4900 Percentiles: P50: 1.90 P75: 11.75 P99: 4175.00 P99.9: 4900.00 P99.99: 4900.00 ------------------------------------------------------ [ 0, 1 ] 32 22.069% 22.069% #### ( 1, 2 ] 45 31.034% 53.103% ###### ( 2, 3 ] 12 8.276% 61.379% ## ( 3, 4 ] 4 2.759% 64.138% # ( 4, 6 ] 5 3.448% 67.586% # ( 6, 10 ] 9 6.207% 73.793% # ( 10, 15 ] 5 3.448% 77.241% # ( 15, 22 ] 12 8.276% 85.517% ## ( 110, 170 ] 1 0.690% 86.207% ( 380, 580 ] 3 2.069% 88.276% ( 580, 870 ] 6 4.138% 92.414% # ( 870, 1300 ] 3 2.069% 94.483% ( 1300, 1900 ] 1 0.690% 95.172% ( 1900, 2900 ] 3 2.069% 97.241% ( 2900, 4400 ] 3 2.069% 99.310% ( 4400, 6600 ] 1 0.690% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 712.1500 StdDev: 736.44 Min: 95 Median: 315.0000 Max: 2434 Percentiles: P50: 315.00 P75: 1300.00 P99: 2434.00 P99.9: 2434.00 P99.99: 2434.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 3 15.000% 25.000% ### ( 170, 250 ] 4 20.000% 45.000% #### ( 250, 380 ] 2 10.000% 55.000% ## ( 380, 580 ] 3 15.000% 70.000% ### ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.72 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.394 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.78 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.436 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-13:32:40 ... thread 0: (1000000,5000000) ops and (259990.1,316882.5) ops/second in (3.846301,15.778720) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 3.26 GB 125.9 3.6 0.0 3.6 8.3 4.7 0.0 1.8 130.8 304.2 27.94 26.20 82 0.341 3710K 3874 0.0 0.0 L1 10/10 1.16 GB 0.0 1.4 1.4 0.1 1.4 1.3 0.1 1.0 232.3 231.3 6.24 6.04 2 3.121 1472K 5954 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.2 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 22/0 961.49 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.7 208.3 208.1 6.40 5.62 4 1.600 1325K 629 0.0 0.0 L4 169/0 9.56 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 163.2 163.2 0.75 0.60 1 0.754 124K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1263/21 100.86 GB 0.0 6.5 1.9 4.6 11.2 6.6 0.8 2.4 159.5 275.2 41.82 38.90 90 0.465 6745K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 1.9 4.6 11.2 6.6 0.8 2.4 159.5 275.2 41.82 38.90 90 0.465 6745K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.5 1.9 4.6 6.5 1.9 0.0 0.0 238.1 237.7 28.02 26.58 21 1.334 6745K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 351.4 13.80 12.32 69 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.0 total, 15.8 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.24 GB write, 720.78 MB/s write, 6.51 GB read, 417.72 MB/s read, 41.8 seconds Interval compaction: 11.24 GB write, 729.44 MB/s write, 6.51 GB read, 422.74 MB/s read, 41.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 14, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1467921 Average: 2.2371 StdDev: 11.33 Min: 0 Median: 1.5004 Max: 3996 Percentiles: P50: 1.50 P75: 1.88 P99: 5.61 P99.9: 9.87 P99.99: 19.21 ------------------------------------------------------ [ 0, 1 ] 246022 16.760% 16.760% ### ( 1, 2 ] 975005 66.421% 83.181% ############# ( 2, 3 ] 153013 10.424% 93.604% ## ( 3, 4 ] 52675 3.588% 97.193% # ( 4, 6 ] 33050 2.251% 99.444% ( 6, 10 ] 6909 0.471% 99.915% ( 10, 15 ] 1032 0.070% 99.985% ( 15, 22 ] 115 0.008% 99.993% ( 22, 34 ] 15 0.001% 99.994% ( 34, 51 ] 13 0.001% 99.995% ( 51, 76 ] 9 0.001% 99.996% ( 76, 110 ] 92 0.006% 100.002% ( 110, 170 ] 153 0.010% 100.012% ( 170, 250 ] 102 0.007% 100.019% ( 250, 380 ] 66 0.004% 100.024% ( 380, 580 ] 51 0.003% 100.027% ( 580, 870 ] 31 0.002% 100.029% ( 870, 1300 ] 18 0.001% 100.031% ( 1300, 1900 ] 5 0.000% 100.031% ( 1900, 2900 ] 4 0.000% 100.031% ( 2900, 4400 ] 8 0.001% 100.032% ** Level 1 read latency histogram (micros): Count: 154079 Average: 2.7069 StdDev: 14.45 Min: 0 Median: 1.5872 Max: 2261 Percentiles: P50: 1.59 P75: 1.97 P99: 7.67 P99.9: 129.48 P99.99: 695.75 ------------------------------------------------------ [ 0, 1 ] 18020 11.695% 11.695% ## ( 1, 2 ] 100508 65.231% 76.927% ############# ( 2, 3 ] 21150 13.727% 90.653% ### ( 3, 4 ] 6627 4.301% 94.955% # ( 4, 6 ] 5474 3.553% 98.507% # ( 6, 10 ] 1823 1.183% 99.690% ( 10, 15 ] 174 0.113% 99.803% ( 15, 22 ] 22 0.014% 99.818% ( 22, 34 ] 3 0.002% 99.820% ( 76, 110 ] 96 0.062% 99.882% ( 110, 170 ] 86 0.056% 99.938% ( 170, 250 ] 31 0.020% 99.958% ( 250, 380 ] 27 0.018% 99.975% ( 380, 580 ] 19 0.012% 99.988% ( 580, 870 ] 9 0.006% 99.994% ( 870, 1300 ] 7 0.005% 99.998% ( 1300, 1900 ] 2 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 278520 Average: 3.4601 StdDev: 34.63 Min: 1 Median: 1.6657 Max: 5659 Percentiles: P50: 1.67 P75: 2.28 P99: 9.02 P99.9: 211.62 P99.99: 595.19 ------------------------------------------------------ [ 0, 1 ] 26244 9.423% 9.423% ## ( 1, 2 ] 169768 60.954% 70.376% ############ ( 2, 3 ] 46804 16.805% 87.181% ### ( 3, 4 ] 16016 5.750% 92.931% # ( 4, 6 ] 13065 4.691% 97.622% # ( 6, 10 ] 5090 1.828% 99.450% ( 10, 15 ] 539 0.194% 99.643% ( 15, 22 ] 133 0.048% 99.691% ( 22, 34 ] 58 0.021% 99.712% ( 34, 51 ] 11 0.004% 99.716% ( 51, 76 ] 19 0.007% 99.722% ( 76, 110 ] 120 0.043% 99.766% ( 110, 170 ] 298 0.107% 99.873% ( 170, 250 ] 147 0.053% 99.925% ( 250, 380 ] 90 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.989% ( 580, 870 ] 41 0.015% 100.004% ( 870, 1300 ] 18 0.006% 100.010% ( 1300, 1900 ] 8 0.003% 100.013% ( 1900, 2900 ] 8 0.003% 100.016% ( 2900, 4400 ] 8 0.003% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 145 Average: 231.7034 StdDev: 750.35 Min: 1 Median: 1.9000 Max: 4900 Percentiles: P50: 1.90 P75: 11.75 P99: 4175.00 P99.9: 4900.00 P99.99: 4900.00 ------------------------------------------------------ [ 0, 1 ] 32 22.069% 22.069% #### ( 1, 2 ] 45 31.034% 53.103% ###### ( 2, 3 ] 12 8.276% 61.379% ## ( 3, 4 ] 4 2.759% 64.138% # ( 4, 6 ] 5 3.448% 67.586% # ( 6, 10 ] 9 6.207% 73.793% # ( 10, 15 ] 5 3.448% 77.241% # ( 15, 22 ] 12 8.276% 85.517% ## ( 110, 170 ] 1 0.690% 86.207% ( 380, 580 ] 3 2.069% 88.276% ( 580, 870 ] 6 4.138% 92.414% # ( 870, 1300 ] 3 2.069% 94.483% ( 1300, 1900 ] 1 0.690% 95.172% ( 1900, 2900 ] 3 2.069% 97.241% ( 2900, 4400 ] 3 2.069% 99.310% ( 4400, 6600 ] 1 0.690% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 712.1500 StdDev: 736.44 Min: 95 Median: 315.0000 Max: 2434 Percentiles: P50: 315.00 P75: 1300.00 P99: 2434.00 P99.9: 2434.00 P99.99: 2434.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 3 15.000% 25.000% ### ( 170, 250 ] 4 20.000% 45.000% #### ( 250, 380 ] 2 10.000% 55.000% ## ( 380, 580 ] 3 15.000% 70.000% ### ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 16.0 total, 3.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 308.14 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.527 H:M:S, 15.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 255.88 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.133 H:M:S, 29.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-13:32:49 ... thread 0: (1000000,6000000) ops and (106622.5,238496.5) ops/second in (9.378883,25.157603) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 4.17 GB 194.4 5.6 0.0 5.6 11.2 5.6 0.0 2.0 147.5 296.4 38.86 36.38 101 0.385 5819K 11K 0.0 0.0 L1 10/10 1.16 GB 0.0 1.4 1.4 0.1 1.4 1.3 0.1 1.0 232.3 231.3 6.24 6.04 2 3.121 1472K 5954 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.2 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 22/0 961.49 MB 1.0 1.3 0.4 0.9 1.3 0.4 0.0 3.7 208.3 208.1 6.40 5.62 4 1.600 1325K 629 0.0 0.0 L4 169/0 9.56 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 163.2 163.2 0.75 0.60 1 0.754 124K 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/25 101.78 GB 0.0 8.5 1.9 6.7 14.2 7.5 0.8 2.5 165.9 275.4 52.73 49.08 109 0.484 8855K 18K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.5 1.9 6.7 14.2 7.5 0.8 2.5 165.9 275.4 52.73 49.08 109 0.484 8855K 18K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.5 1.9 6.7 8.5 1.9 0.0 0.0 241.6 241.1 36.21 34.33 25 1.448 8855K 18K 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 350.7 16.53 14.75 84 0.197 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): 25.3 total, 25.2 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: 14.19 GB write, 573.03 MB/s write, 8.54 GB read, 345.13 MB/s read, 52.7 seconds Interval compaction: 14.19 GB write, 577.35 MB/s write, 8.54 GB read, 347.73 MB/s read, 52.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 14, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2348164 Average: 2.5630 StdDev: 14.43 Min: 0 Median: 1.4883 Max: 3996 Percentiles: P50: 1.49 P75: 1.86 P99: 5.90 P99.9: 131.84 P99.99: 245.03 ------------------------------------------------------ [ 0, 1 ] 407312 17.346% 17.346% ### ( 1, 2 ] 1570388 66.877% 84.223% ############# ( 2, 3 ] 225139 9.588% 93.811% ## ( 3, 4 ] 76826 3.272% 97.083% # ( 4, 6 ] 47356 2.017% 99.100% ( 6, 10 ] 13614 0.580% 99.679% ( 10, 15 ] 1574 0.067% 99.746% ( 15, 22 ] 346 0.015% 99.761% ( 22, 34 ] 27 0.001% 99.762% ( 34, 51 ] 16 0.001% 99.763% ( 51, 76 ] 69 0.003% 99.766% ( 76, 110 ] 2231 0.095% 99.861% ( 110, 170 ] 2521 0.107% 99.968% ( 170, 250 ] 544 0.023% 99.991% ( 250, 380 ] 404 0.017% 100.009% ( 380, 580 ] 298 0.013% 100.021% ( 580, 870 ] 112 0.005% 100.026% ( 870, 1300 ] 34 0.001% 100.028% ( 1300, 1900 ] 8 0.000% 100.028% ( 1900, 2900 ] 10 0.000% 100.028% ( 2900, 4400 ] 11 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 338715 Average: 2.7168 StdDev: 12.94 Min: 0 Median: 1.5378 Max: 2261 Percentiles: P50: 1.54 P75: 1.91 P99: 8.11 P99.9: 144.90 P99.99: 544.76 ------------------------------------------------------ [ 0, 1 ] 47570 14.044% 14.044% ### ( 1, 2 ] 226445 66.854% 80.898% ############# ( 2, 3 ] 38576 11.389% 92.287% ## ( 3, 4 ] 11598 3.424% 95.711% # ( 4, 6 ] 8978 2.651% 98.362% # ( 6, 10 ] 4089 1.207% 99.569% ( 10, 15 ] 283 0.084% 99.653% ( 15, 22 ] 79 0.023% 99.676% ( 22, 34 ] 4 0.001% 99.677% ( 51, 76 ] 10 0.003% 99.680% ( 76, 110 ] 582 0.172% 99.852% ( 110, 170 ] 279 0.082% 99.934% ( 170, 250 ] 82 0.024% 99.959% ( 250, 380 ] 74 0.022% 99.981% ( 380, 580 ] 39 0.012% 99.992% ( 580, 870 ] 15 0.004% 99.996% ( 870, 1300 ] 8 0.002% 99.999% ( 1300, 1900 ] 3 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 278520 Average: 3.4601 StdDev: 34.63 Min: 1 Median: 1.6657 Max: 5659 Percentiles: P50: 1.67 P75: 2.28 P99: 9.02 P99.9: 211.62 P99.99: 595.19 ------------------------------------------------------ [ 0, 1 ] 26244 9.423% 9.423% ## ( 1, 2 ] 169768 60.954% 70.376% ############ ( 2, 3 ] 46804 16.805% 87.181% ### ( 3, 4 ] 16016 5.750% 92.931% # ( 4, 6 ] 13065 4.691% 97.622% # ( 6, 10 ] 5090 1.828% 99.450% ( 10, 15 ] 539 0.194% 99.643% ( 15, 22 ] 133 0.048% 99.691% ( 22, 34 ] 58 0.021% 99.712% ( 34, 51 ] 11 0.004% 99.716% ( 51, 76 ] 19 0.007% 99.722% ( 76, 110 ] 120 0.043% 99.766% ( 110, 170 ] 298 0.107% 99.873% ( 170, 250 ] 147 0.053% 99.925% ( 250, 380 ] 90 0.032% 99.958% ( 380, 580 ] 88 0.032% 99.989% ( 580, 870 ] 41 0.015% 100.004% ( 870, 1300 ] 18 0.006% 100.010% ( 1300, 1900 ] 8 0.003% 100.013% ( 1900, 2900 ] 8 0.003% 100.016% ( 2900, 4400 ] 8 0.003% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 145 Average: 231.7034 StdDev: 750.35 Min: 1 Median: 1.9000 Max: 4900 Percentiles: P50: 1.90 P75: 11.75 P99: 4175.00 P99.9: 4900.00 P99.99: 4900.00 ------------------------------------------------------ [ 0, 1 ] 32 22.069% 22.069% #### ( 1, 2 ] 45 31.034% 53.103% ###### ( 2, 3 ] 12 8.276% 61.379% ## ( 3, 4 ] 4 2.759% 64.138% # ( 4, 6 ] 5 3.448% 67.586% # ( 6, 10 ] 9 6.207% 73.793% # ( 10, 15 ] 5 3.448% 77.241% # ( 15, 22 ] 12 8.276% 85.517% ## ( 110, 170 ] 1 0.690% 86.207% ( 380, 580 ] 3 2.069% 88.276% ( 580, 870 ] 6 4.138% 92.414% # ( 870, 1300 ] 3 2.069% 94.483% ( 1300, 1900 ] 1 0.690% 95.172% ( 1900, 2900 ] 3 2.069% 97.241% ( 2900, 4400 ] 3 2.069% 99.310% ( 4400, 6600 ] 1 0.690% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 712.1500 StdDev: 736.44 Min: 95 Median: 315.0000 Max: 2434 Percentiles: P50: 315.00 P75: 1300.00 P99: 2434.00 P99.9: 2434.00 P99.99: 2434.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 3 15.000% 25.000% ### ( 170, 250 ] 4 20.000% 45.000% #### ( 250, 380 ] 2 10.000% 55.000% ## ( 380, 580 ] 3 15.000% 70.000% ### ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 3 15.000% 90.000% ### ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 25.3 total, 9.4 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 232.96 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:9.223 H:M:S, 36.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 104.94 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.695 H:M:S, 71.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-13:32:53 ... thread 0: (1000000,7000000) ops and (268193.7,242329.8) ops/second in (3.728649,28.886252) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/11 3.07 GB 31.5 6.3 0.0 6.3 12.9 6.6 0.0 2.0 146.0 297.4 44.44 41.63 118 0.377 6587K 12K 0.0 0.0 L1 22/22 2.14 GB 0.0 4.6 3.4 1.2 4.6 3.3 0.1 1.3 219.2 216.8 21.53 20.26 3 7.178 4792K 50K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.2 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 14/0 932.84 MB 0.9 1.3 0.4 0.9 1.3 0.4 1.0 3.7 208.3 208.1 6.40 5.62 4 1.600 1325K 629 0.0 0.0 L4 172/0 9.61 GB 1.0 0.3 0.2 0.0 0.3 0.2 1.1 1.1 177.9 177.6 1.50 1.25 2 0.748 270K 421 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1277/33 102.66 GB 0.0 12.6 4.0 8.6 19.1 10.6 4.7 2.9 173.7 263.5 74.35 69.20 128 0.581 13M 64K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.6 4.0 8.6 19.1 10.6 4.7 2.9 173.7 263.5 74.35 69.20 128 0.581 13M 64K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.6 4.0 8.6 12.6 4.0 0.0 0.0 234.4 233.2 55.10 52.01 30 1.837 13M 64K 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 350.3 19.24 17.19 98 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 29.1 total, 28.9 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: 19.13 GB write, 673.82 MB/s write, 12.61 GB read, 444.23 MB/s read, 74.3 seconds Interval compaction: 19.13 GB write, 678.24 MB/s write, 12.61 GB read, 447.15 MB/s read, 74.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 3, pending-compaction-bytes-stops: 0, total-delays: 24, total-stops: 16, interval: 40 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2688161 Average: 2.5499 StdDev: 14.46 Min: 0 Median: 1.4865 Max: 3996 Percentiles: P50: 1.49 P75: 1.86 P99: 5.89 P99.9: 129.31 P99.99: 247.80 ------------------------------------------------------ [ 0, 1 ] 467941 17.407% 17.407% ### ( 1, 2 ] 1801017 66.998% 84.406% ############# ( 2, 3 ] 256191 9.530% 93.936% ## ( 3, 4 ] 86629 3.223% 97.159% # ( 4, 6 ] 52317 1.946% 99.105% ( 6, 10 ] 15866 0.590% 99.695% ( 10, 15 ] 1755 0.065% 99.760% ( 15, 22 ] 369 0.014% 99.774% ( 22, 34 ] 30 0.001% 99.775% ( 34, 51 ] 18 0.001% 99.776% ( 51, 76 ] 82 0.003% 99.779% ( 76, 110 ] 2392 0.089% 99.868% ( 110, 170 ] 2690 0.100% 99.968% ( 170, 250 ] 612 0.023% 99.991% ( 250, 380 ] 446 0.017% 100.007% ( 380, 580 ] 355 0.013% 100.020% ( 580, 870 ] 150 0.006% 100.026% ( 870, 1300 ] 43 0.002% 100.028% ( 1300, 1900 ] 10 0.000% 100.028% ( 1900, 2900 ] 11 0.000% 100.028% ( 2900, 4400 ] 12 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 399546 Average: 2.8541 StdDev: 18.13 Min: 0 Median: 1.5351 Max: 3307 Percentiles: P50: 1.54 P75: 1.91 P99: 8.19 P99.9: 162.81 P99.99: 831.77 ------------------------------------------------------ [ 0, 1 ] 57171 14.309% 14.309% ### ( 1, 2 ] 266481 66.696% 81.005% ############# ( 2, 3 ] 45321 11.343% 92.348% ## ( 3, 4 ] 13611 3.407% 95.755% # ( 4, 6 ] 10241 2.563% 98.318% # ( 6, 10 ] 4969 1.244% 99.562% ( 10, 15 ] 348 0.087% 99.649% ( 15, 22 ] 88 0.022% 99.671% ( 22, 34 ] 6 0.002% 99.672% ( 51, 76 ] 11 0.003% 99.675% ( 76, 110 ] 609 0.152% 99.827% ( 110, 170 ] 330 0.083% 99.910% ( 170, 250 ] 119 0.030% 99.940% ( 250, 380 ] 94 0.024% 99.963% ( 380, 580 ] 81 0.020% 99.983% ( 580, 870 ] 30 0.008% 99.991% ( 870, 1300 ] 21 0.005% 99.996% ( 1300, 1900 ] 12 0.003% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 282153 Average: 3.6027 StdDev: 35.19 Min: 1 Median: 1.6634 Max: 5659 Percentiles: P50: 1.66 P75: 2.27 P99: 9.15 P99.9: 242.44 P99.99: 663.23 ------------------------------------------------------ [ 0, 1 ] 26962 9.556% 9.556% ## ( 1, 2 ] 172023 60.968% 70.524% ############ ( 2, 3 ] 47096 16.692% 87.215% ### ( 3, 4 ] 16100 5.706% 92.922% # ( 4, 6 ] 13108 4.646% 97.567% # ( 6, 10 ] 5130 1.818% 99.385% ( 10, 15 ] 547 0.194% 99.579% ( 15, 22 ] 134 0.047% 99.627% ( 22, 34 ] 58 0.021% 99.647% ( 34, 51 ] 11 0.004% 99.651% ( 51, 76 ] 20 0.007% 99.658% ( 76, 110 ] 149 0.053% 99.711% ( 110, 170 ] 359 0.127% 99.838% ( 170, 250 ] 192 0.068% 99.906% ( 250, 380 ] 112 0.040% 99.946% ( 380, 580 ] 108 0.038% 99.984% ( 580, 870 ] 55 0.019% 100.004% ( 870, 1300 ] 18 0.006% 100.010% ( 1300, 1900 ] 8 0.003% 100.013% ( 1900, 2900 ] 8 0.003% 100.016% ( 2900, 4400 ] 8 0.003% 100.019% ( 4400, 6600 ] 3 0.001% 100.020% ** Level 4 read latency histogram (micros): Count: 160 Average: 220.5750 StdDev: 717.32 Min: 1 Median: 1.8958 Max: 4900 Percentiles: P50: 1.90 P75: 14.00 P99: 4100.00 P99.9: 4900.00 P99.99: 4900.00 ------------------------------------------------------ [ 0, 1 ] 37 23.125% 23.125% ##### ( 1, 2 ] 48 30.000% 53.125% ###### ( 2, 3 ] 12 7.500% 60.625% ## ( 3, 4 ] 5 3.125% 63.750% # ( 4, 6 ] 5 3.125% 66.875% # ( 6, 10 ] 9 5.625% 72.500% # ( 10, 15 ] 5 3.125% 75.625% # ( 15, 22 ] 12 7.500% 83.125% ## ( 110, 170 ] 4 2.500% 85.625% # ( 250, 380 ] 2 1.250% 86.875% ( 380, 580 ] 3 1.875% 88.750% ( 580, 870 ] 7 4.375% 93.125% # ( 870, 1300 ] 3 1.875% 95.000% ( 1300, 1900 ] 1 0.625% 95.625% ( 1900, 2900 ] 3 1.875% 97.500% ( 2900, 4400 ] 3 1.875% 99.375% ( 4400, 6600 ] 1 0.625% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 720.3500 StdDev: 853.49 Min: 81 Median: 287.1429 Max: 3304 Percentiles: P50: 287.14 P75: 1054.29 P99: 3304.00 P99.9: 3304.00 P99.99: 3304.00 ------------------------------------------------------ ( 76, 110 ] 10 12.500% 12.500% ### ( 110, 170 ] 15 18.750% 31.250% #### ( 170, 250 ] 13 16.250% 47.500% ### ( 250, 380 ] 7 8.750% 56.250% ## ( 380, 580 ] 9 11.250% 67.500% ## ( 580, 870 ] 3 3.750% 71.250% # ( 870, 1300 ] 7 8.750% 80.000% ## ( 1300, 1900 ] 8 10.000% 90.000% ## ( 1900, 2900 ] 4 5.000% 95.000% # ( 2900, 4400 ] 4 5.000% 100.000% # ** DB Stats ** Uptime(secs): 29.1 total, 3.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 236.93 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:10.325 H:M:S, 35.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 263.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:1.102 H:M:S, 29.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-13:33:16 ... thread 0: (1000000,8000000) ops and (44178.4,155274.2) ops/second in (22.635498,51.521750) 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 3/1 1.59 GB 12.6 8.9 0.0 8.9 16.5 7.5 0.0 2.2 155.4 286.8 58.77 54.23 137 0.429 9272K 23K 0.0 0.0 L1 12/12 1.23 GB 0.0 9.2 5.8 3.4 9.1 5.7 0.1 1.6 217.6 214.6 43.32 40.33 4 10.829 8911K 50K 0.0 0.0 L2 2/0 197.83 MB 2.0 0.1 0.1 0.0 0.1 0.1 4.5 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 37/10 3.11 GB 2.3 2.4 0.8 1.6 2.4 0.8 3.6 2.9 152.5 151.4 16.23 10.94 9 1.803 2484K 17K 0.0 0.0 L4 180/13 10.50 GB 1.1 1.2 1.1 0.1 1.2 1.1 1.1 1.1 120.4 120.1 10.27 5.89 10 1.027 1255K 3216 0.0 0.0 L5 1056/0 86.92 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/36 103.54 GB 0.0 21.9 7.9 14.0 29.3 15.3 10.6 3.9 173.4 232.1 129.07 111.83 161 0.802 22M 94K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.9 7.9 14.0 29.3 15.3 10.6 3.9 173.4 232.1 129.07 111.83 161 0.802 22M 94K 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.9 7.9 14.0 21.7 7.7 0.0 0.0 210.0 208.4 106.56 92.01 49 2.175 22M 94K 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 344.4 22.50 19.82 112 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 51.7 total, 51.5 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.25 GB write, 579.23 MB/s write, 21.85 GB read, 432.72 MB/s read, 129.1 seconds Interval compaction: 29.25 GB write, 581.36 MB/s write, 21.85 GB read, 434.31 MB/s read, 129.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 22, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 23, interval: 66 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3945611 Average: 3.0400 StdDev: 26.94 Min: 0 Median: 1.4863 Max: 9730 Percentiles: P50: 1.49 P75: 1.86 P99: 7.63 P99.9: 164.66 P99.99: 381.67 ------------------------------------------------------ [ 0, 1 ] 705079 17.870% 17.870% #### ( 1, 2 ] 2606805 66.068% 83.938% ############# ( 2, 3 ] 369136 9.356% 93.294% ## ( 3, 4 ] 127497 3.231% 96.525% # ( 4, 6 ] 86047 2.181% 98.706% ( 6, 10 ] 28486 0.722% 99.428% ( 10, 15 ] 3135 0.079% 99.508% ( 15, 22 ] 619 0.016% 99.523% ( 22, 34 ] 45 0.001% 99.524% ( 34, 51 ] 63 0.002% 99.526% ( 51, 76 ] 232 0.006% 99.532% ( 76, 110 ] 7372 0.187% 99.719% ( 110, 170 ] 7850 0.199% 99.918% ( 170, 250 ] 1681 0.043% 99.960% ( 250, 380 ] 1164 0.030% 99.990% ( 380, 580 ] 893 0.023% 100.012% ( 580, 870 ] 360 0.009% 100.022% ( 870, 1300 ] 94 0.002% 100.024% ( 1300, 1900 ] 32 0.001% 100.025% ( 1900, 2900 ] 44 0.001% 100.026% ( 2900, 4400 ] 57 0.001% 100.027% ( 4400, 6600 ] 19 0.000% 100.028% ( 6600, 9900 ] 7 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 1494274 Average: 4.3669 StdDev: 70.88 Min: 0 Median: 1.6018 Max: 11758 Percentiles: P50: 1.60 P75: 2.15 P99: 8.79 P99.9: 108.53 P99.99: 154.79 ------------------------------------------------------ [ 0, 1 ] 228057 15.262% 15.262% ### ( 1, 2 ] 862559 57.724% 72.986% ############ ( 2, 3 ] 198601 13.291% 86.277% ### ( 3, 4 ] 89162 5.967% 92.244% # ( 4, 6 ] 83401 5.581% 97.825% # ( 6, 10 ] 25138 1.682% 99.508% ( 10, 15 ] 3375 0.226% 99.734% ( 15, 22 ] 639 0.043% 99.776% ( 22, 34 ] 33 0.002% 99.779% ( 34, 51 ] 12 0.001% 99.779% ( 51, 76 ] 161 0.011% 99.790% ( 76, 110 ] 1718 0.115% 99.905% ( 110, 170 ] 1702 0.114% 100.019% ( 170, 250 ] 461 0.031% 100.050% ( 250, 380 ] 460 0.031% 100.081% ( 380, 580 ] 442 0.030% 100.110% ( 580, 870 ] 321 0.021% 100.132% ( 870, 1300 ] 210 0.014% 100.146% ( 1300, 1900 ] 136 0.009% 100.155% ( 1900, 2900 ] 113 0.008% 100.162% ( 2900, 4400 ] 161 0.011% 100.173% ( 4400, 6600 ] 80 0.005% 100.179% ( 6600, 9900 ] 22 0.001% 100.180% ( 9900, 14000 ] 3 0.000% 100.180% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 406781 Average: 5.1824 StdDev: 61.59 Min: 1 Median: 1.7562 Max: 7249 Percentiles: P50: 1.76 P75: 2.58 P99: 9.29 P99.9: 386.98 P99.99: 675.89 ------------------------------------------------------ [ 0, 1 ] 28193 6.931% 6.931% # ( 1, 2 ] 231681 56.955% 63.885% ########### ( 2, 3 ] 77470 19.045% 82.930% #### ( 3, 4 ] 32012 7.870% 90.800% ## ( 4, 6 ] 27493 6.759% 97.558% # ( 6, 10 ] 7130 1.753% 99.311% ( 10, 15 ] 1022 0.251% 99.562% ( 15, 22 ] 189 0.046% 99.609% ( 22, 34 ] 62 0.015% 99.624% ( 34, 51 ] 14 0.003% 99.628% ( 51, 76 ] 22 0.005% 99.633% ( 76, 110 ] 163 0.040% 99.673% ( 110, 170 ] 420 0.103% 99.776% ( 170, 250 ] 269 0.066% 99.842% ( 250, 380 ] 225 0.055% 99.898% ( 380, 580 ] 293 0.072% 99.970% ( 580, 870 ] 252 0.062% 100.032% ( 870, 1300 ] 153 0.038% 100.069% ( 1300, 1900 ] 64 0.016% 100.085% ( 1900, 2900 ] 36 0.009% 100.094% ( 2900, 4400 ] 36 0.009% 100.103% ( 4400, 6600 ] 11 0.003% 100.105% ( 6600, 9900 ] 1 0.000% 100.106% ** Level 4 read latency histogram (micros): Count: 9353 Average: 47.1068 StdDev: 250.33 Min: 1 Median: 1.9919 Max: 6561 Percentiles: P50: 1.99 P75: 3.35 P99: 1100.39 P99.9: 3719.32 P99.99: 5914.11 ------------------------------------------------------ [ 0, 1 ] 307 3.282% 3.282% # ( 1, 2 ] 4405 47.097% 50.380% ######### ( 2, 3 ] 1918 20.507% 70.886% #### ( 3, 4 ] 1090 11.654% 82.540% ## ( 4, 6 ] 728 7.784% 90.324% ## ( 6, 10 ] 262 2.801% 93.125% # ( 10, 15 ] 33 0.353% 93.478% ( 15, 22 ] 22 0.235% 93.713% ( 22, 34 ] 3 0.032% 93.745% ( 34, 51 ] 2 0.021% 93.767% ( 51, 76 ] 1 0.011% 93.777% ( 76, 110 ] 10 0.107% 93.884% ( 110, 170 ] 48 0.513% 94.398% ( 170, 250 ] 64 0.684% 95.082% ( 250, 380 ] 86 0.919% 96.001% ( 380, 580 ] 126 1.347% 97.348% ( 580, 870 ] 110 1.176% 98.525% ( 870, 1300 ] 83 0.887% 99.412% ( 1300, 1900 ] 20 0.214% 99.626% ( 1900, 2900 ] 18 0.192% 99.818% ( 2900, 4400 ] 14 0.150% 99.968% ( 4400, 6600 ] 3 0.032% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 720.3500 StdDev: 853.49 Min: 81 Median: 287.1429 Max: 3304 Percentiles: P50: 287.14 P75: 1054.29 P99: 3304.00 P99.9: 3304.00 P99.99: 3304.00 ------------------------------------------------------ ( 76, 110 ] 10 12.500% 12.500% ### ( 110, 170 ] 15 18.750% 31.250% #### ( 170, 250 ] 13 16.250% 47.500% ### ( 250, 380 ] 7 8.750% 56.250% ## ( 380, 580 ] 9 11.250% 67.500% ## ( 580, 870 ] 3 3.750% 71.250% # ( 870, 1300 ] 7 8.750% 80.000% ## ( 1300, 1900 ] 8 10.000% 90.000% ## ( 1900, 2900 ] 4 5.000% 95.000% # ( 2900, 4400 ] 4 5.000% 100.000% # ** DB Stats ** Uptime(secs): 51.7 total, 22.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 152.25 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:29.843 H:M:S, 57.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 43.48 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:19.518 H:M:S, 86.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/19-13:33:20 ... thread 0: (1000000,9000000) ops and (229841.4,161080.8) ops/second in (4.350827,55.872577) 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/5 2.51 GB 81.8 9.6 0.0 9.6 18.1 8.5 0.0 2.1 150.3 282.8 65.39 59.49 151 0.433 9976K 24K 0.0 0.0 L1 12/12 1.23 GB 0.0 9.2 5.8 3.4 9.1 5.7 0.1 1.6 217.6 214.6 43.32 40.33 4 10.829 8911K 50K 0.0 0.0 L2 1/0 98.79 MB 1.0 0.1 0.1 0.0 0.1 0.1 4.5 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 14/0 942.50 MB 0.9 2.6 0.9 1.7 2.6 0.9 3.6 2.8 152.4 151.3 17.73 11.99 10 1.773 2716K 20K 0.0 0.0 L4 166/0 9.75 GB 1.0 4.0 3.4 0.5 3.9 3.4 1.1 1.2 128.8 128.5 31.42 19.12 31 1.013 4111K 10K 0.0 0.0 L5 1092/0 89.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1293/17 104.45 GB 0.0 25.5 10.2 15.3 33.8 18.5 13.7 4.0 164.9 218.6 158.33 131.38 197 0.804 25M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.5 10.2 15.3 33.8 18.5 13.7 4.0 164.9 218.6 158.33 131.38 197 0.804 25M 106K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.5 10.2 15.3 25.3 10.1 0.0 0.0 197.7 196.3 132.04 109.04 73 1.809 25M 106K 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 330.7 26.29 22.34 124 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 56.1 total, 55.9 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: 33.81 GB write, 617.49 MB/s write, 25.50 GB read, 465.71 MB/s read, 158.3 seconds Interval compaction: 33.81 GB write, 619.58 MB/s write, 25.50 GB read, 467.29 MB/s read, 158.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 22, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 35, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4327434 Average: 3.1308 StdDev: 32.19 Min: 0 Median: 1.5078 Max: 9730 Percentiles: P50: 1.51 P75: 1.89 P99: 7.76 P99.9: 162.81 P99.99: 383.64 ------------------------------------------------------ [ 0, 1 ] 725760 16.771% 16.771% ### ( 1, 2 ] 2831646 65.435% 82.206% ############# ( 2, 3 ] 448882 10.373% 92.579% ## ( 3, 4 ] 151298 3.496% 96.075% # ( 4, 6 ] 111210 2.570% 98.645% # ( 6, 10 ] 34954 0.808% 99.453% ( 10, 15 ] 3978 0.092% 99.545% ( 15, 22 ] 702 0.016% 99.561% ( 22, 34 ] 54 0.001% 99.562% ( 34, 51 ] 72 0.002% 99.564% ( 51, 76 ] 233 0.005% 99.569% ( 76, 110 ] 7380 0.171% 99.740% ( 110, 170 ] 7882 0.182% 99.922% ( 170, 250 ] 1727 0.040% 99.962% ( 250, 380 ] 1206 0.028% 99.990% ( 380, 580 ] 947 0.022% 100.011% ( 580, 870 ] 407 0.009% 100.021% ( 870, 1300 ] 136 0.003% 100.024% ( 1300, 1900 ] 64 0.001% 100.026% ( 1900, 2900 ] 83 0.002% 100.027% ( 2900, 4400 ] 107 0.002% 100.030% ( 4400, 6600 ] 33 0.001% 100.031% ( 6600, 9900 ] 10 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 1789149 Average: 5.2400 StdDev: 86.27 Min: 0 Median: 1.6579 Max: 11758 Percentiles: P50: 1.66 P75: 2.38 P99: 8.98 P99.9: 119.76 P99.99: 194.20 ------------------------------------------------------ [ 0, 1 ] 231136 12.919% 12.919% ### ( 1, 2 ] 1008355 56.359% 69.278% ########### ( 2, 3 ] 270241 15.104% 84.383% ### ( 3, 4 ] 121683 6.801% 91.184% # ( 4, 6 ] 115359 6.448% 97.632% # ( 6, 10 ] 32829 1.835% 99.466% ( 10, 15 ] 4720 0.264% 99.730% ( 15, 22 ] 798 0.045% 99.775% ( 22, 34 ] 44 0.002% 99.777% ( 34, 51 ] 15 0.001% 99.778% ( 51, 76 ] 165 0.009% 99.787% ( 76, 110 ] 1733 0.097% 99.884% ( 110, 170 ] 1733 0.097% 99.981% ( 170, 250 ] 526 0.029% 100.011% ( 250, 380 ] 595 0.033% 100.044% ( 380, 580 ] 624 0.035% 100.079% ( 580, 870 ] 526 0.029% 100.108% ( 870, 1300 ] 402 0.022% 100.131% ( 1300, 1900 ] 250 0.014% 100.144% ( 1900, 2900 ] 251 0.014% 100.159% ( 2900, 4400 ] 313 0.017% 100.176% ( 4400, 6600 ] 140 0.008% 100.184% ( 6600, 9900 ] 36 0.002% 100.186% ( 9900, 14000 ] 3 0.000% 100.186% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 643681 Average: 6.3132 StdDev: 85.10 Min: 1 Median: 1.8269 Max: 7871 Percentiles: P50: 1.83 P75: 2.75 P99: 9.22 P99.9: 479.28 P99.99: 791.74 ------------------------------------------------------ [ 0, 1 ] 30934 4.806% 4.806% # ( 1, 2 ] 351805 54.655% 59.461% ########### ( 2, 3 ] 133818 20.789% 80.250% #### ( 3, 4 ] 59644 9.266% 89.517% ## ( 4, 6 ] 52507 8.157% 97.674% ## ( 6, 10 ] 10606 1.648% 99.322% ( 10, 15 ] 1850 0.287% 99.609% ( 15, 22 ] 283 0.044% 99.653% ( 22, 34 ] 68 0.011% 99.663% ( 34, 51 ] 17 0.003% 99.666% ( 51, 76 ] 22 0.003% 99.670% ( 76, 110 ] 167 0.026% 99.696% ( 110, 170 ] 450 0.070% 99.765% ( 170, 250 ] 319 0.050% 99.815% ( 250, 380 ] 316 0.049% 99.864% ( 380, 580 ] 466 0.072% 99.936% ( 580, 870 ] 472 0.073% 100.010% ( 870, 1300 ] 301 0.047% 100.057% ( 1300, 1900 ] 141 0.022% 100.078% ( 1900, 2900 ] 118 0.018% 100.097% ( 2900, 4400 ] 143 0.022% 100.119% ( 4400, 6600 ] 28 0.004% 100.123% ( 6600, 9900 ] 8 0.001% 100.125% ** Level 4 read latency histogram (micros): Count: 107273 Average: 14.9453 StdDev: 153.55 Min: 1 Median: 1.9152 Max: 7647 Percentiles: P50: 1.92 P75: 2.91 P99: 255.91 P99.9: 1880.36 P99.99: 3285.45 ------------------------------------------------------ [ 0, 1 ] 1737 1.619% 1.619% ( 1, 2 ] 56710 52.865% 54.484% ########### ( 2, 3 ] 24117 22.482% 76.966% #### ( 3, 4 ] 11578 10.793% 87.759% ## ( 4, 6 ] 9552 8.904% 96.664% ## ( 6, 10 ] 1905 1.776% 98.439% ( 10, 15 ] 307 0.286% 98.726% ( 15, 22 ] 55 0.051% 98.777% ( 22, 34 ] 12 0.011% 98.788% ( 34, 51 ] 4 0.004% 98.792% ( 51, 76 ] 2 0.002% 98.794% ( 76, 110 ] 18 0.017% 98.811% ( 110, 170 ] 64 0.060% 98.870% ( 170, 250 ] 132 0.123% 98.993% ( 250, 380 ] 160 0.149% 99.142% ( 380, 580 ] 250 0.233% 99.375% ( 580, 870 ] 259 0.241% 99.617% ( 870, 1300 ] 207 0.193% 99.810% ( 1300, 1900 ] 100 0.093% 99.903% ( 1900, 2900 ] 74 0.069% 99.972% ( 2900, 4400 ] 75 0.070% 100.042% ( 4400, 6600 ] 16 0.015% 100.057% ( 6600, 9900 ] 1 0.001% 100.058% ** Level 5 read latency histogram (micros): Count: 260 Average: 1168.1500 StdDev: 1335.02 Min: 81 Median: 574.2857 Max: 7618 Percentiles: P50: 574.29 P75: 1654.55 P99: 6160.00 P99.9: 7618.00 P99.99: 7618.00 ------------------------------------------------------ ( 76, 110 ] 12 4.615% 4.615% # ( 110, 170 ] 29 11.154% 15.769% ## ( 170, 250 ] 30 11.538% 27.308% ## ( 250, 380 ] 25 9.615% 36.923% ## ( 380, 580 ] 35 13.462% 50.385% ### ( 580, 870 ] 28 10.769% 61.154% ## ( 870, 1300 ] 23 8.846% 70.000% ## ( 1300, 1900 ] 22 8.462% 78.462% ## ( 1900, 2900 ] 22 8.462% 86.923% ## ( 2900, 4400 ] 25 9.615% 96.538% ## ( 4400, 6600 ] 8 3.077% 99.615% # ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 56.1 total, 4.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 157.99 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:31.456 H:M:S, 56.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 226.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.613 H:M:S, 37.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-13:33:23 ... thread 0: (1000000,10000000) ops and (300509.4,168918.2) ops/second in (3.327683,59.200260) 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/1 3.49 GB 207.7 10.3 0.0 10.3 19.8 9.4 0.0 2.1 148.4 284.1 71.30 65.05 167 0.427 10M 25K 0.0 0.0 L1 12/12 1.23 GB 0.0 9.2 5.8 3.4 9.1 5.7 0.1 1.6 217.6 214.6 43.32 40.33 4 10.829 8911K 50K 0.0 0.0 L2 1/0 98.79 MB 1.0 0.1 0.1 0.0 0.1 0.1 4.5 1.8 230.4 230.3 0.48 0.45 1 0.483 112K 33 0.0 0.0 L3 14/0 942.50 MB 0.9 2.6 0.9 1.7 2.6 0.9 3.6 2.8 152.4 151.3 17.73 11.99 10 1.773 2716K 20K 0.0 0.0 L4 166/0 9.75 GB 1.0 4.0 3.4 0.5 3.9 3.4 1.1 1.2 128.8 128.5 31.42 19.12 31 1.013 4111K 10K 0.0 0.0 L5 1092/0 89.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1297/13 105.43 GB 0.0 26.2 10.2 16.0 35.5 19.5 13.7 3.8 163.6 221.5 164.25 136.94 213 0.771 26M 107K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.2 10.2 16.0 35.5 19.5 13.7 3.8 163.6 221.5 164.25 136.94 213 0.771 26M 107K 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 26.2 10.2 16.0 26.1 10.1 0.0 0.0 199.1 197.7 134.97 111.90 76 1.776 26M 107K 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 331.3 29.28 25.04 137 0.214 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 59.4 total, 59.2 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 35.53 GB write, 612.58 MB/s write, 26.24 GB read, 452.35 MB/s read, 164.2 seconds Interval compaction: 35.53 GB write, 614.54 MB/s write, 26.24 GB read, 453.79 MB/s read, 164.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 21, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 21, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 22, pending-compaction-bytes-stops: 0, total-delays: 43, total-stops: 40, interval: 83 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4568013 Average: 3.0806 StdDev: 31.42 Min: 0 Median: 1.5075 Max: 9730 Percentiles: P50: 1.51 P75: 1.89 P99: 7.59 P99.9: 161.10 P99.99: 379.06 ------------------------------------------------------ [ 0, 1 ] 761595 16.672% 16.672% ### ( 1, 2 ] 2999898 65.672% 82.344% ############# ( 2, 3 ] 473027 10.355% 92.699% ## ( 3, 4 ] 158538 3.471% 96.170% # ( 4, 6 ] 114867 2.515% 98.685% # ( 6, 10 ] 36239 0.793% 99.478% ( 10, 15 ] 4102 0.090% 99.568% ( 15, 22 ] 717 0.016% 99.583% ( 22, 34 ] 55 0.001% 99.585% ( 34, 51 ] 73 0.002% 99.586% ( 51, 76 ] 237 0.005% 99.591% ( 76, 110 ] 7381 0.162% 99.753% ( 110, 170 ] 7886 0.173% 99.926% ( 170, 250 ] 1735 0.038% 99.964% ( 250, 380 ] 1215 0.027% 99.990% ( 380, 580 ] 951 0.021% 100.011% ( 580, 870 ] 412 0.009% 100.020% ( 870, 1300 ] 138 0.003% 100.023% ( 1300, 1900 ] 66 0.001% 100.024% ( 1900, 2900 ] 83 0.002% 100.026% ( 2900, 4400 ] 108 0.002% 100.029% ( 4400, 6600 ] 33 0.001% 100.029% ( 6600, 9900 ] 10 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 1936314 Average: 5.0292 StdDev: 82.97 Min: 0 Median: 1.6429 Max: 11758 Percentiles: P50: 1.64 P75: 2.31 P99: 8.92 P99.9: 121.39 P99.99: 200.25 ------------------------------------------------------ [ 0, 1 ] 254205 13.128% 13.128% ### ( 1, 2 ] 1110437 57.348% 70.476% ########### ( 2, 3 ] 283808 14.657% 85.133% ### ( 3, 4 ] 125506 6.482% 91.615% # ( 4, 6 ] 117495 6.068% 97.683% # ( 6, 10 ] 34888 1.802% 99.485% ( 10, 15 ] 4810 0.248% 99.733% ( 15, 22 ] 813 0.042% 99.775% ( 22, 34 ] 45 0.002% 99.778% ( 34, 51 ] 15 0.001% 99.778% ( 51, 76 ] 171 0.009% 99.787% ( 76, 110 ] 1827 0.094% 99.882% ( 110, 170 ] 1890 0.098% 99.979% ( 170, 250 ] 559 0.029% 100.008% ( 250, 380 ] 610 0.032% 100.040% ( 380, 580 ] 637 0.033% 100.072% ( 580, 870 ] 532 0.027% 100.100% ( 870, 1300 ] 402 0.021% 100.121% ( 1300, 1900 ] 250 0.013% 100.134% ( 1900, 2900 ] 251 0.013% 100.147% ( 2900, 4400 ] 313 0.016% 100.163% ( 4400, 6600 ] 140 0.007% 100.170% ( 6600, 9900 ] 36 0.002% 100.172% ( 9900, 14000 ] 3 0.000% 100.172% ** Level 2 read latency histogram (micros): Count: 40485 Average: 2.3855 StdDev: 15.88 Min: 1 Median: 1.3469 Max: 1540 Percentiles: P50: 1.35 P75: 1.77 P99: 5.74 P99.9: 165.84 P99.99: 809.19 ------------------------------------------------------ [ 0, 1 ] 11964 29.552% 29.552% ###### ( 1, 2 ] 23867 58.953% 88.504% ############ ( 2, 3 ] 2880 7.114% 95.618% # ( 3, 4 ] 864 2.134% 97.752% ( 4, 6 ] 581 1.435% 99.187% ( 6, 10 ] 203 0.501% 99.689% ( 10, 15 ] 30 0.074% 99.763% ( 15, 22 ] 2 0.005% 99.768% ( 22, 34 ] 3 0.007% 99.775% ( 34, 51 ] 27 0.067% 99.842% ( 51, 76 ] 11 0.027% 99.869% ( 76, 110 ] 6 0.015% 99.884% ( 110, 170 ] 7 0.017% 99.901% ( 170, 250 ] 14 0.035% 99.936% ( 250, 380 ] 15 0.037% 99.973% ( 380, 580 ] 3 0.007% 99.980% ( 580, 870 ] 5 0.012% 99.993% ( 870, 1300 ] 2 0.005% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 643681 Average: 6.3132 StdDev: 85.10 Min: 1 Median: 1.8269 Max: 7871 Percentiles: P50: 1.83 P75: 2.75 P99: 9.22 P99.9: 479.28 P99.99: 791.74 ------------------------------------------------------ [ 0, 1 ] 30934 4.806% 4.806% # ( 1, 2 ] 351805 54.655% 59.461% ########### ( 2, 3 ] 133818 20.789% 80.250% #### ( 3, 4 ] 59644 9.266% 89.517% ## ( 4, 6 ] 52507 8.157% 97.674% ## ( 6, 10 ] 10606 1.648% 99.322% ( 10, 15 ] 1850 0.287% 99.609% ( 15, 22 ] 283 0.044% 99.653% ( 22, 34 ] 68 0.011% 99.663% ( 34, 51 ] 17 0.003% 99.666% ( 51, 76 ] 22 0.003% 99.670% ( 76, 110 ] 167 0.026% 99.696% ( 110, 170 ] 450 0.070% 99.765% ( 170, 250 ] 319 0.050% 99.815% ( 250, 380 ] 316 0.049% 99.864% ( 380, 580 ] 466 0.072% 99.936% ( 580, 870 ] 472 0.073% 100.010% ( 870, 1300 ] 301 0.047% 100.057% ( 1300, 1900 ] 141 0.022% 100.078% ( 1900, 2900 ] 118 0.018% 100.097% ( 2900, 4400 ] 143 0.022% 100.119% ( 4400, 6600 ] 28 0.004% 100.123% ( 6600, 9900 ] 8 0.001% 100.125% ** Level 4 read latency histogram (micros): Count: 107273 Average: 14.9453 StdDev: 153.55 Min: 1 Median: 1.9152 Max: 7647 Percentiles: P50: 1.92 P75: 2.91 P99: 255.91 P99.9: 1880.36 P99.99: 3285.45 ------------------------------------------------------ [ 0, 1 ] 1737 1.619% 1.619% ( 1, 2 ] 56710 52.865% 54.484% ########### ( 2, 3 ] 24117 22.482% 76.966% #### ( 3, 4 ] 11578 10.793% 87.759% ## ( 4, 6 ] 9552 8.904% 96.664% ## ( 6, 10 ] 1905 1.776% 98.439% ( 10, 15 ] 307 0.286% 98.726% ( 15, 22 ] 55 0.051% 98.777% ( 22, 34 ] 12 0.011% 98.788% ( 34, 51 ] 4 0.004% 98.792% ( 51, 76 ] 2 0.002% 98.794% ( 76, 110 ] 18 0.017% 98.811% ( 110, 170 ] 64 0.060% 98.870% ( 170, 250 ] 132 0.123% 98.993% ( 250, 380 ] 160 0.149% 99.142% ( 380, 580 ] 250 0.233% 99.375% ( 580, 870 ] 259 0.241% 99.617% ( 870, 1300 ] 207 0.193% 99.810% ( 1300, 1900 ] 100 0.093% 99.903% ( 1900, 2900 ] 74 0.069% 99.972% ( 2900, 4400 ] 75 0.070% 100.042% ( 4400, 6600 ] 16 0.015% 100.057% ( 6600, 9900 ] 1 0.001% 100.058% ** Level 5 read latency histogram (micros): Count: 260 Average: 1168.1500 StdDev: 1335.02 Min: 81 Median: 574.2857 Max: 7618 Percentiles: P50: 574.29 P75: 1654.55 P99: 6160.00 P99.9: 7618.00 P99.99: 7618.00 ------------------------------------------------------ ( 76, 110 ] 12 4.615% 4.615% # ( 110, 170 ] 29 11.154% 15.769% ## ( 170, 250 ] 30 11.538% 27.308% ## ( 250, 380 ] 25 9.615% 36.923% ## ( 380, 580 ] 35 13.462% 50.385% ### ( 580, 870 ] 28 10.769% 61.154% ## ( 870, 1300 ] 23 8.846% 70.000% ## ( 1300, 1900 ] 22 8.462% 78.462% ## ( 1900, 2900 ] 22 8.462% 86.923% ## ( 2900, 4400 ] 25 9.615% 96.538% ## ( 4400, 6600 ] 8 3.077% 99.615% # ( 6600, 9900 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 59.4 total, 3.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 165.71 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:32.172 H:M:S, 54.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 295.77 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.716 H:M:S, 21.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.829 micros/op 171541 ops/sec 60.003 seconds 10292999 operations; 166.2 MB/s Microseconds per write: Count: 10292999 Average: 5.8295 StdDev: 377.45 Min: 0 Median: 1.7336 Max: 723994 Percentiles: P50: 1.73 P75: 2.74 P99: 8.15 P99.9: 1153.51 P99.99: 2691.66 ------------------------------------------------------ [ 0, 1 ] 1420070 13.796% 13.796% ### ( 1, 2 ] 5079475 49.349% 63.145% ########## ( 2, 3 ] 1658964 16.117% 79.263% ### ( 3, 4 ] 1430247 13.895% 93.158% ### ( 4, 6 ] 551955 5.362% 98.520% # ( 6, 10 ] 91981 0.894% 99.414% ( 10, 15 ] 19389 0.188% 99.602% ( 15, 22 ] 6935 0.067% 99.670% ( 22, 34 ] 1873 0.018% 99.688% ( 34, 51 ] 214 0.002% 99.690% ( 51, 76 ] 21 0.000% 99.690% ( 76, 110 ] 6972 0.068% 99.758% ( 110, 170 ] 3056 0.030% 99.788% ( 170, 250 ] 336 0.003% 99.791% ( 250, 380 ] 78 0.001% 99.792% ( 380, 580 ] 32 0.000% 99.792% ( 580, 870 ] 24 0.000% 99.792% ( 870, 1300 ] 16811 0.163% 99.956% ( 1300, 1900 ] 36 0.000% 99.956% ( 1900, 2900 ] 4422 0.043% 99.999% ( 2900, 4400 ] 61 0.001% 100.000% ( 4400, 6600 ] 15 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 5 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 196724 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 : 10292999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10622374968 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 : 539 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32205411 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 : 30546856694 rocksdb.compact.write.bytes COUNT : 30351472392 rocksdb.flush.write.bytes COUNT : 10437065020 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 : 60 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 : 224 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 : 10352890880 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4005888 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 : 30645366748 rocksdb.non.last.level.read.count COUNT : 7402483 rocksdb.block.checksum.compute.count COUNT : 7401465 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.382207 P95 : 3.862378 P99 : 6.431610 P100 : 723992.000000 COUNT : 10292999 SUM : 55339832 rocksdb.compaction.times.micros P50 : 1157500.000000 P95 : 5620000.000000 P99 : 18960000.000000 P100 : 21783670.000000 COUNT : 76 SUM : 134965911 rocksdb.compaction.times.cpu_micros P50 : 945000.000000 P95 : 5180000.000000 P99 : 18960000.000000 P100 : 20070094.000000 COUNT : 76 SUM : 111897700 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 : 697.048193 P95 : 1222.852941 P99 : 28490.000000 P100 : 94368.000000 COUNT : 141 SUM : 225854 rocksdb.compaction.outfile.sync.micros P50 : 990.937500 P95 : 155000.000000 P99 : 332642.857143 P100 : 416883.000000 COUNT : 355 SUM : 7625616 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 : 105.033708 P95 : 947.400000 P99 : 2760.000000 P100 : 3502.000000 COUNT : 242 SUM : 58184 rocksdb.table.open.io.micros P50 : 1296.532258 P95 : 7266.600000 P99 : 11000.166667 P100 : 14725.000000 COUNT : 539 SUM : 1095227 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.620496 P95 : 7.529429 P99 : 11.258284 P100 : 11763.000000 COUNT : 7399979 SUM : 45300520 rocksdb.read.block.get.micros P50 : 418.095238 P95 : 3383.962264 P99 : 5334.352941 P100 : 7698.000000 COUNT : 1078 SUM : 894843 rocksdb.write.raw.block.micros P50 : 0.513118 P95 : 0.974925 P99 : 2.950513 P100 : 16969.000000 COUNT : 9891187 SUM : 19242776 rocksdb.numfiles.in.singlecompaction P50 : 3.284722 P95 : 5.900000 P99 : 26.500000 P100 : 33.000000 COUNT : 125 SUM : 525 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.558783 P95 : 1155.905861 P99 : 2460.317316 P100 : 723816.000000 COUNT : 203388 SUM : 32218531 rocksdb.sst.read.micros P50 : 1.570153 P95 : 4.403401 P99 : 8.684123 P100 : 11758.000000 COUNT : 7402776 SUM : 30206112 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 : 10292999 SUM : 10622374968 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 : 210000.000000 P95 : 370250.000000 P99 : 741100.000000 P100 : 863176.000000 COUNT : 141 SUM : 30026623 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 : 343 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