[2024-12-14 05:11:52.551852] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-14 05:11:52.551995] [ 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_pid1208815 ] Set seed to 1734149512548414 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-14 05:11:52.637679] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-14 05:11:52.679239] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-14 05:11:52.679285] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1208815' to capture a snapshot of events at runtime. [2024-12-14 05:11:52.679295] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-14 05:11:52.679306] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-14 05:11:52.679314] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1208815 for offline analysis/debug. [2024-12-14 05:11:52.679417] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 14 05:11:56 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/14-05:11:59 ... thread 0: (1000000,1000000) ops and (368169.4,368169.4) ops/second in (2.716141,2.716141) 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.03 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 359.8 2.28 2.06 12 0.190 0 0 0.0 0.0 L1 1/0 2.44 MB 0.2 0.2 0.2 0.1 0.2 0.2 0.1 1.3 249.3 249.1 1.01 0.98 1 1.011 255K 214 0.0 0.0 L2 3/2 298.24 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.2 1.8 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 19/12 944.31 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 194.8 194.8 0.32 0.26 1 0.320 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 104.8 306.2 4.06 3.74 15 0.271 432K 238 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 104.8 306.2 4.06 3.74 15 0.271 432K 238 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 238.2 238.0 1.79 1.68 3 0.596 432K 238 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 359.8 2.28 2.06 12 0.190 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): 2.9 total, 2.7 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, 430.64 MB/s write, 0.42 GB read, 147.33 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 457.98 MB/s write, 0.42 GB read, 156.68 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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 110703 Average: 1.7895 StdDev: 11.35 Min: 0 Median: 1.1697 Max: 2938 Percentiles: P50: 1.17 P75: 1.63 P99: 4.22 P99.9: 9.91 P99.99: 267.27 ------------------------------------------------------ [ 0, 1 ] 45166 40.799% 40.799% ######## ( 1, 2 ] 60036 54.232% 95.031% ########### ( 2, 3 ] 3099 2.799% 97.830% # ( 3, 4 ] 1213 1.096% 98.926% ( 4, 6 ] 756 0.683% 99.609% ( 6, 10 ] 331 0.299% 99.908% ( 10, 15 ] 60 0.054% 99.962% ( 15, 22 ] 13 0.012% 99.974% ( 22, 34 ] 5 0.005% 99.978% ( 34, 51 ] 1 0.001% 99.979% ( 110, 170 ] 10 0.009% 99.988% ( 170, 250 ] 2 0.002% 99.990% ( 250, 380 ] 7 0.006% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 2718 Average: 3.9272 StdDev: 24.65 Min: 1 Median: 2.1018 Max: 854 Percentiles: P50: 2.10 P75: 3.05 P99: 9.36 P99.9: 508.20 P99.99: 830.59 ------------------------------------------------------ [ 0, 1 ] 69 2.539% 2.539% # ( 1, 2 ] 1216 44.739% 47.277% ######### ( 2, 3 ] 737 27.116% 74.393% ##### ( 3, 4 ] 348 12.804% 87.196% ### ( 4, 6 ] 252 9.272% 96.468% ## ( 6, 10 ] 83 3.054% 99.522% # ( 10, 15 ] 8 0.294% 99.816% ( 15, 22 ] 1 0.037% 99.853% ( 34, 51 ] 1 0.037% 99.890% ( 380, 580 ] 2 0.074% 99.963% ( 580, 870 ] 2 0.074% 100.037% ** Level 2 read latency histogram (micros): Count: 28152 Average: 2.2915 StdDev: 27.11 Min: 1 Median: 1.2281 Max: 3740 Percentiles: P50: 1.23 P75: 1.68 P99: 6.00 P99.9: 64.74 P99.99: 1124.73 ------------------------------------------------------ [ 0, 1 ] 10539 37.436% 37.436% ####### ( 1, 2 ] 15504 55.072% 92.509% ########### ( 2, 3 ] 1191 4.231% 96.739% # ( 3, 4 ] 320 1.137% 97.876% ( 4, 6 ] 317 1.126% 99.002% ( 6, 10 ] 180 0.639% 99.641% ( 10, 15 ] 21 0.075% 99.716% ( 15, 22 ] 7 0.025% 99.741% ( 34, 51 ] 41 0.146% 99.886% ( 51, 76 ] 7 0.025% 99.911% ( 76, 110 ] 7 0.025% 99.936% ( 110, 170 ] 1 0.004% 99.940% ( 170, 250 ] 9 0.032% 99.972% ( 380, 580 ] 2 0.007% 99.979% ( 580, 870 ] 2 0.007% 99.986% ( 870, 1300 ] 2 0.007% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 5450 Average: 19.7361 StdDev: 184.32 Min: 1 Median: 1.7668 Max: 4387 Percentiles: P50: 1.77 P75: 2.57 P99: 426.53 P99.9: 3491.50 P99.99: 4309.15 ------------------------------------------------------ [ 0, 1 ] 425 7.798% 7.798% ## ( 1, 2 ] 3000 55.046% 62.844% ########### ( 2, 3 ] 1157 21.229% 84.073% #### ( 3, 4 ] 316 5.798% 89.872% # ( 4, 6 ] 289 5.303% 95.174% # ( 6, 10 ] 118 2.165% 97.339% ( 10, 15 ] 16 0.294% 97.633% ( 15, 22 ] 6 0.110% 97.743% ( 22, 34 ] 3 0.055% 97.798% ( 76, 110 ] 23 0.422% 98.220% ( 110, 170 ] 24 0.440% 98.661% ( 170, 250 ] 7 0.128% 98.789% ( 250, 380 ] 9 0.165% 98.954% ( 380, 580 ] 15 0.275% 99.229% ( 580, 870 ] 7 0.128% 99.358% ( 870, 1300 ] 13 0.239% 99.596% ( 1300, 1900 ] 8 0.147% 99.743% ( 1900, 2900 ] 6 0.110% 99.853% ( 2900, 4400 ] 9 0.165% 100.018% ** Level 4 read latency histogram (micros): Count: 20 Average: 1690.8500 StdDev: 795.62 Min: 696 Median: 1420.0000 Max: 3623 Percentiles: P50: 1420.00 P75: 2233.33 P99: 3623.00 P99.9: 3623.00 P99.99: 3623.00 ------------------------------------------------------ ( 580, 870 ] 2 10.000% 10.000% ## ( 870, 1300 ] 7 35.000% 45.000% ####### ( 1300, 1900 ] 5 25.000% 70.000% ##### ( 1900, 2900 ] 3 15.000% 85.000% ### ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 2.9 total, 2.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 340.53 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.165 H:M:S, 5.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 362.05 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.165 H:M:S, 6.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/14-05:12:02 ... thread 0: (1000000,2000000) ops and (328613.1,347268.5) ops/second in (3.043092,5.759233) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/11 1.48 GB 0.0 0.9 0.0 0.9 2.7 1.8 0.0 1.5 107.9 316.4 8.76 8.16 29 0.302 959K 1222 0.0 0.0 L1 1/1 2.44 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 249.3 249.1 1.01 0.98 1 1.011 255K 214 0.0 0.0 L2 2/1 169.48 MB 1.2 0.1 0.1 0.0 0.1 0.1 0.2 1.8 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 76/11 1.05 GB 0.2 0.2 0.2 0.1 0.2 0.2 0.0 1.3 140.9 140.9 1.76 1.30 2 0.878 251K 74 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 1246/24 97.92 GB 0.0 1.5 0.4 1.1 3.3 2.2 0.4 1.9 129.9 282.3 11.98 10.88 33 0.363 1579K 1534 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.4 1.1 3.3 2.2 0.4 1.9 129.9 282.3 11.98 10.88 33 0.363 1579K 1534 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.5 0.4 1.1 1.5 0.4 0.0 0.0 227.6 227.4 6.83 6.27 7 0.976 1579K 1534 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 355.2 5.14 4.61 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 5.9 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.30 GB write, 569.87 MB/s write, 1.52 GB read, 262.21 MB/s read, 12.0 seconds Interval compaction: 3.30 GB write, 586.94 MB/s write, 1.52 GB read, 270.06 MB/s read, 12.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 365613 Average: 2.1904 StdDev: 9.91 Min: 0 Median: 1.4806 Max: 3093 Percentiles: P50: 1.48 P75: 1.88 P99: 5.74 P99.9: 10.28 P99.99: 18.66 ------------------------------------------------------ [ 0, 1 ] 73076 19.987% 19.987% #### ( 1, 2 ] 228325 62.450% 82.437% ############ ( 2, 3 ] 38336 10.485% 92.923% ## ( 3, 4 ] 13418 3.670% 96.593% # ( 4, 6 ] 10120 2.768% 99.361% # ( 6, 10 ] 1956 0.535% 99.896% ( 10, 15 ] 326 0.089% 99.985% ( 15, 22 ] 41 0.011% 99.996% ( 22, 34 ] 9 0.002% 99.998% ( 34, 51 ] 1 0.000% 99.999% ( 51, 76 ] 3 0.001% 99.999% ( 110, 170 ] 16 0.004% 100.004% ( 170, 250 ] 7 0.002% 100.006% ( 250, 380 ] 17 0.005% 100.010% ( 380, 580 ] 4 0.001% 100.011% ( 580, 870 ] 4 0.001% 100.013% ( 870, 1300 ] 5 0.001% 100.014% ( 1300, 1900 ] 3 0.001% 100.015% ( 2900, 4400 ] 2 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 32704 Average: 2.7569 StdDev: 7.23 Min: 1 Median: 1.7979 Max: 854 Percentiles: P50: 1.80 P75: 2.62 P99: 8.10 P99.9: 14.07 P99.99: 452.96 ------------------------------------------------------ [ 0, 1 ] 1485 4.541% 4.541% # ( 1, 2 ] 18632 56.972% 61.512% ########### ( 2, 3 ] 7143 21.841% 83.354% #### ( 3, 4 ] 2456 7.510% 90.864% ## ( 4, 6 ] 2406 7.357% 98.220% # ( 6, 10 ] 485 1.483% 99.703% ( 10, 15 ] 79 0.242% 99.945% ( 15, 22 ] 11 0.034% 99.979% ( 22, 34 ] 2 0.006% 99.985% ( 34, 51 ] 1 0.003% 99.988% ( 380, 580 ] 2 0.006% 99.994% ( 580, 870 ] 2 0.006% 100.000% ** Level 2 read latency histogram (micros): Count: 28274 Average: 2.2947 StdDev: 27.05 Min: 1 Median: 1.2316 Max: 3740 Percentiles: P50: 1.23 P75: 1.69 P99: 6.00 P99.9: 64.31 P99.99: 1122.11 ------------------------------------------------------ [ 0, 1 ] 10539 37.275% 37.275% ####### ( 1, 2 ] 15533 54.937% 92.212% ########### ( 2, 3 ] 1265 4.474% 96.686% # ( 3, 4 ] 333 1.178% 97.864% ( 4, 6 ] 322 1.139% 99.003% ( 6, 10 ] 181 0.640% 99.643% ( 10, 15 ] 21 0.074% 99.717% ( 15, 22 ] 7 0.025% 99.742% ( 34, 51 ] 41 0.145% 99.887% ( 51, 76 ] 7 0.025% 99.912% ( 76, 110 ] 7 0.025% 99.936% ( 110, 170 ] 1 0.004% 99.940% ( 170, 250 ] 9 0.032% 99.972% ( 380, 580 ] 2 0.007% 99.979% ( 580, 870 ] 2 0.007% 99.986% ( 870, 1300 ] 2 0.007% 99.993% ( 1300, 1900 ] 1 0.004% 99.996% ( 2900, 4400 ] 1 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 206778 Average: 3.5083 StdDev: 34.62 Min: 1 Median: 1.6299 Max: 4387 Percentiles: P50: 1.63 P75: 2.15 P99: 9.13 P99.9: 208.35 P99.99: 808.62 ------------------------------------------------------ [ 0, 1 ] 23735 11.478% 11.478% ## ( 1, 2 ] 126456 61.155% 72.634% ############ ( 2, 3 ] 32371 15.655% 88.289% ### ( 3, 4 ] 10892 5.267% 93.556% # ( 4, 6 ] 8264 3.997% 97.553% # ( 6, 10 ] 3824 1.849% 99.402% ( 10, 15 ] 335 0.162% 99.564% ( 15, 22 ] 102 0.049% 99.614% ( 22, 34 ] 60 0.029% 99.643% ( 34, 51 ] 12 0.006% 99.648% ( 51, 76 ] 47 0.023% 99.671% ( 76, 110 ] 163 0.079% 99.750% ( 110, 170 ] 269 0.130% 99.880% ( 170, 250 ] 86 0.042% 99.922% ( 250, 380 ] 58 0.028% 99.950% ( 380, 580 ] 51 0.025% 99.974% ( 580, 870 ] 41 0.020% 99.994% ( 870, 1300 ] 17 0.008% 100.002% ( 1300, 1900 ] 10 0.005% 100.007% ( 1900, 2900 ] 7 0.003% 100.011% ( 2900, 4400 ] 10 0.005% 100.015% ** Level 4 read latency histogram (micros): Count: 20 Average: 1690.8500 StdDev: 795.62 Min: 696 Median: 1420.0000 Max: 3623 Percentiles: P50: 1420.00 P75: 2233.33 P99: 3623.00 P99.9: 3623.00 P99.99: 3623.00 ------------------------------------------------------ ( 580, 870 ] 2 10.000% 10.000% ## ( 870, 1300 ] 7 35.000% 45.000% ####### ( 1300, 1900 ] 5 25.000% 70.000% ##### ( 1900, 2900 ] 3 15.000% 85.000% ### ( 2900, 4400 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 5.9 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 331.76 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.565 H:M:S, 9.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.43 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.400 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/14-05:12:05 ... thread 0: (1000000,3000000) ops and (327878.5,340555.3) ops/second in (3.049910,8.809143) 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/15 2.40 GB 62.9 1.4 0.0 1.4 4.1 2.7 0.0 1.5 107.8 313.9 13.44 12.51 44 0.305 1471K 1754 0.0 0.0 L1 1/1 2.44 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 249.3 249.1 1.01 0.98 1 1.011 255K 214 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 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 21/0 961.78 MB 1.0 1.4 0.4 1.0 1.4 0.4 0.0 3.9 212.0 211.9 6.59 5.78 4 1.647 1390K 656 0.0 0.0 L4 170/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 153.9 153.9 0.80 0.62 1 0.798 124K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1254/16 98.84 GB 0.0 3.3 0.7 2.5 6.0 3.4 0.9 2.2 149.5 273.7 22.29 20.33 51 0.437 3355K 2648 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 0.7 2.5 6.0 3.4 0.9 2.2 149.5 273.7 22.29 20.33 51 0.437 3355K 2648 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.3 0.7 2.5 3.3 0.7 0.0 0.0 230.4 230.2 14.46 13.33 12 1.205 3355K 2648 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 354.1 7.83 7.00 39 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.8 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.96 GB write, 679.18 MB/s write, 3.25 GB read, 370.93 MB/s read, 22.3 seconds Interval compaction: 5.96 GB write, 692.48 MB/s write, 3.25 GB read, 378.19 MB/s read, 22.3 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: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 743577 Average: 2.2826 StdDev: 8.95 Min: 0 Median: 1.5422 Max: 3093 Percentiles: P50: 1.54 P75: 1.93 P99: 5.79 P99.9: 10.47 P99.99: 14.91 ------------------------------------------------------ [ 0, 1 ] 109888 14.778% 14.778% ### ( 1, 2 ] 483026 64.960% 79.738% ############# ( 2, 3 ] 92238 12.405% 92.143% ## ( 3, 4 ] 30543 4.108% 96.250% # ( 4, 6 ] 22808 3.067% 99.318% # ( 6, 10 ] 4259 0.573% 99.890% ( 10, 15 ] 754 0.101% 99.992% ( 15, 22 ] 89 0.012% 100.004% ( 22, 34 ] 12 0.002% 100.005% ( 34, 51 ] 4 0.001% 100.006% ( 51, 76 ] 6 0.001% 100.007% ( 76, 110 ] 19 0.003% 100.009% ( 110, 170 ] 37 0.005% 100.014% ( 170, 250 ] 21 0.003% 100.017% ( 250, 380 ] 32 0.004% 100.021% ( 380, 580 ] 13 0.002% 100.023% ( 580, 870 ] 13 0.002% 100.025% ( 870, 1300 ] 7 0.001% 100.026% ( 1300, 1900 ] 4 0.001% 100.026% ( 1900, 2900 ] 2 0.000% 100.027% ( 2900, 4400 ] 2 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 63298 Average: 2.5312 StdDev: 5.25 Min: 1 Median: 1.6912 Max: 854 Percentiles: P50: 1.69 P75: 2.32 P99: 7.08 P99.9: 12.74 P99.99: 28.68 ------------------------------------------------------ [ 0, 1 ] 4334 6.847% 6.847% # ( 1, 2 ] 39518 62.432% 69.279% ############ ( 2, 3 ] 11308 17.865% 87.143% #### ( 3, 4 ] 3964 6.262% 93.406% # ( 4, 6 ] 3349 5.291% 98.697% # ( 6, 10 ] 708 1.119% 99.815% ( 10, 15 ] 98 0.155% 99.970% ( 15, 22 ] 11 0.017% 99.987% ( 22, 34 ] 3 0.005% 99.992% ( 34, 51 ] 1 0.002% 99.994% ( 380, 580 ] 2 0.003% 99.997% ( 580, 870 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 294783 Average: 3.3093 StdDev: 30.02 Min: 1 Median: 1.6407 Max: 4387 Percentiles: P50: 1.64 P75: 2.17 P99: 8.88 P99.9: 189.16 P99.99: 805.99 ------------------------------------------------------ [ 0, 1 ] 30312 10.283% 10.283% ## ( 1, 2 ] 182732 61.989% 72.271% ############ ( 2, 3 ] 47461 16.100% 88.372% ### ( 3, 4 ] 15524 5.266% 93.638% # ( 4, 6 ] 12212 4.143% 97.781% # ( 6, 10 ] 4993 1.694% 99.475% ( 10, 15 ] 498 0.169% 99.643% ( 15, 22 ] 137 0.046% 99.690% ( 22, 34 ] 63 0.021% 99.711% ( 34, 51 ] 13 0.004% 99.716% ( 51, 76 ] 48 0.016% 99.732% ( 76, 110 ] 170 0.058% 99.790% ( 110, 170 ] 296 0.100% 99.890% ( 170, 250 ] 122 0.041% 99.931% ( 250, 380 ] 73 0.025% 99.956% ( 380, 580 ] 59 0.020% 99.976% ( 580, 870 ] 52 0.018% 99.994% ( 870, 1300 ] 23 0.008% 100.002% ( 1300, 1900 ] 10 0.003% 100.005% ( 1900, 2900 ] 7 0.002% 100.007% ( 2900, 4400 ] 10 0.003% 100.011% ** Level 4 read latency histogram (micros): Count: 150 Average: 237.5333 StdDev: 643.32 Min: 0 Median: 1.8148 Max: 3623 Percentiles: P50: 1.81 P75: 12.66 P99: 3623.00 P99.9: 3623.00 P99.99: 3623.00 ------------------------------------------------------ [ 0, 1 ] 31 20.667% 20.667% #### ( 1, 2 ] 54 36.000% 56.667% ####### ( 2, 3 ] 6 4.000% 60.667% # ( 3, 4 ] 7 4.667% 65.333% # ( 4, 6 ] 4 2.667% 68.000% # ( 6, 10 ] 2 1.333% 69.333% ( 10, 15 ] 16 10.667% 80.000% ## ( 15, 22 ] 7 4.667% 84.667% # ( 170, 250 ] 1 0.667% 85.333% ( 250, 380 ] 1 0.667% 86.000% ( 580, 870 ] 3 2.000% 88.000% ( 870, 1300 ] 7 4.667% 92.667% # ( 1300, 1900 ] 5 3.333% 96.000% # ( 1900, 2900 ] 3 2.000% 98.000% ( 2900, 4400 ] 3 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 840.4000 StdDev: 861.92 Min: 88 Median: 380.0000 Max: 2821 Percentiles: P50: 380.00 P75: 1300.00 P99: 2821.00 P99.9: 2821.00 P99.99: 2821.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 1 5.000% 20.000% # ( 170, 250 ] 4 20.000% 40.000% #### ( 250, 380 ] 2 10.000% 50.000% ## ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 328.68 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.949 H:M:S, 10.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.69 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.385 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/14-05:12:08 ... thread 0: (1000000,4000000) ops and (325640.3,336699.9) ops/second in (3.070873,11.880016) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/4 2.15 GB 195.1 2.5 0.0 2.5 6.2 3.7 0.0 1.7 125.3 308.5 20.61 19.28 63 0.327 2622K 2926 0.0 0.0 L1 11/0 1.23 GB 125.5 1.5 1.4 0.1 1.5 1.4 0.1 1.0 229.4 228.4 6.60 6.38 2 3.298 1536K 6583 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 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 21/0 961.78 MB 1.0 1.4 0.4 1.0 1.4 0.4 0.0 3.9 212.0 211.9 6.59 5.78 4 1.647 1390K 656 0.0 0.0 L4 170/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 153.9 153.9 0.80 0.62 1 0.798 124K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1260/4 99.82 GB 0.0 5.6 1.9 3.6 9.3 5.6 0.9 2.5 163.4 270.9 35.05 32.51 71 0.494 5787K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 1.9 3.6 9.3 5.6 0.9 2.5 163.4 270.9 35.05 32.51 71 0.494 5787K 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 5.6 1.9 3.6 5.6 1.9 0.0 0.0 234.3 233.9 24.44 23.04 17 1.438 5787K 10K 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 356.1 10.61 9.47 54 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): 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.27 GB write, 787.83 MB/s write, 5.59 GB read, 475.13 MB/s read, 35.1 seconds Interval compaction: 9.27 GB write, 799.27 MB/s write, 5.59 GB read, 482.03 MB/s read, 35.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, 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: 2, total-stops: 14, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1099559 Average: 2.2709 StdDev: 10.15 Min: 0 Median: 1.5211 Max: 3093 Percentiles: P50: 1.52 P75: 1.90 P99: 5.77 P99.9: 10.19 P99.99: 16.40 ------------------------------------------------------ [ 0, 1 ] 176255 16.030% 16.030% ### ( 1, 2 ] 716815 65.191% 81.221% ############# ( 2, 3 ] 127974 11.639% 92.859% ## ( 3, 4 ] 41419 3.767% 96.626% # ( 4, 6 ] 29479 2.681% 99.307% # ( 6, 10 ] 6479 0.589% 99.897% ( 10, 15 ] 1005 0.091% 99.988% ( 15, 22 ] 115 0.010% 99.998% ( 22, 34 ] 17 0.002% 100.000% ( 34, 51 ] 7 0.001% 100.001% ( 51, 76 ] 10 0.001% 100.001% ( 76, 110 ] 73 0.007% 100.008% ( 110, 170 ] 88 0.008% 100.016% ( 170, 250 ] 51 0.005% 100.021% ( 250, 380 ] 53 0.005% 100.026% ( 380, 580 ] 31 0.003% 100.028% ( 580, 870 ] 23 0.002% 100.030% ( 870, 1300 ] 12 0.001% 100.032% ( 1300, 1900 ] 6 0.001% 100.032% ( 1900, 2900 ] 5 0.000% 100.033% ( 2900, 4400 ] 4 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 63972 Average: 2.9630 StdDev: 17.80 Min: 1 Median: 1.6923 Max: 1655 Percentiles: P50: 1.69 P75: 2.33 P99: 7.58 P99.9: 129.27 P99.99: 846.96 ------------------------------------------------------ [ 0, 1 ] 4378 6.844% 6.844% # ( 1, 2 ] 39878 62.337% 69.180% ############ ( 2, 3 ] 11431 17.869% 87.049% #### ( 3, 4 ] 3993 6.242% 93.291% # ( 4, 6 ] 3368 5.265% 98.556% # ( 6, 10 ] 721 1.127% 99.683% ( 10, 15 ] 99 0.155% 99.837% ( 15, 22 ] 11 0.017% 99.855% ( 22, 34 ] 4 0.006% 99.861% ( 34, 51 ] 1 0.002% 99.862% ( 76, 110 ] 16 0.025% 99.887% ( 110, 170 ] 25 0.039% 99.927% ( 170, 250 ] 5 0.008% 99.934% ( 250, 380 ] 14 0.022% 99.956% ( 380, 580 ] 17 0.027% 99.983% ( 580, 870 ] 5 0.008% 99.991% ( 870, 1300 ] 3 0.005% 99.995% ( 1300, 1900 ] 3 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 294783 Average: 3.3093 StdDev: 30.02 Min: 1 Median: 1.6407 Max: 4387 Percentiles: P50: 1.64 P75: 2.17 P99: 8.88 P99.9: 189.16 P99.99: 805.99 ------------------------------------------------------ [ 0, 1 ] 30312 10.283% 10.283% ## ( 1, 2 ] 182732 61.989% 72.271% ############ ( 2, 3 ] 47461 16.100% 88.372% ### ( 3, 4 ] 15524 5.266% 93.638% # ( 4, 6 ] 12212 4.143% 97.781% # ( 6, 10 ] 4993 1.694% 99.475% ( 10, 15 ] 498 0.169% 99.643% ( 15, 22 ] 137 0.046% 99.690% ( 22, 34 ] 63 0.021% 99.711% ( 34, 51 ] 13 0.004% 99.716% ( 51, 76 ] 48 0.016% 99.732% ( 76, 110 ] 170 0.058% 99.790% ( 110, 170 ] 296 0.100% 99.890% ( 170, 250 ] 122 0.041% 99.931% ( 250, 380 ] 73 0.025% 99.956% ( 380, 580 ] 59 0.020% 99.976% ( 580, 870 ] 52 0.018% 99.994% ( 870, 1300 ] 23 0.008% 100.002% ( 1300, 1900 ] 10 0.003% 100.005% ( 1900, 2900 ] 7 0.002% 100.007% ( 2900, 4400 ] 10 0.003% 100.011% ** Level 4 read latency histogram (micros): Count: 150 Average: 237.5333 StdDev: 643.32 Min: 0 Median: 1.8148 Max: 3623 Percentiles: P50: 1.81 P75: 12.66 P99: 3623.00 P99.9: 3623.00 P99.99: 3623.00 ------------------------------------------------------ [ 0, 1 ] 31 20.667% 20.667% #### ( 1, 2 ] 54 36.000% 56.667% ####### ( 2, 3 ] 6 4.000% 60.667% # ( 3, 4 ] 7 4.667% 65.333% # ( 4, 6 ] 4 2.667% 68.000% # ( 6, 10 ] 2 1.333% 69.333% ( 10, 15 ] 16 10.667% 80.000% ## ( 15, 22 ] 7 4.667% 84.667% # ( 170, 250 ] 1 0.667% 85.333% ( 250, 380 ] 1 0.667% 86.000% ( 580, 870 ] 3 2.000% 88.000% ( 870, 1300 ] 7 4.667% 92.667% # ( 1300, 1900 ] 5 3.333% 96.000% # ( 1900, 2900 ] 3 2.000% 98.000% ( 2900, 4400 ] 3 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 840.4000 StdDev: 861.92 Min: 88 Median: 380.0000 Max: 2821 Percentiles: P50: 380.00 P75: 1300.00 P99: 2821.00 P99.9: 2821.00 P99.99: 2821.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 1 5.000% 20.000% # ( 170, 250 ] 4 20.000% 40.000% #### ( 250, 380 ] 2 10.000% 50.000% ## ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 12.1 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 326.59 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.386 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, 320.49 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.437 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-05:12:11 ... thread 0: (1000000,5000000) ops and (334084.7,336173.6) ops/second in (2.993253,14.873269) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/4 3.13 GB 289.5 3.6 0.0 3.6 8.2 4.7 0.0 1.8 133.2 307.6 27.43 25.72 81 0.339 3710K 4022 0.0 0.0 L1 11/0 1.23 GB 125.5 1.5 1.4 0.1 1.5 1.4 0.1 1.0 229.4 228.4 6.60 6.38 2 3.298 1536K 6583 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 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 21/0 961.78 MB 1.0 1.4 0.4 1.0 1.4 0.4 0.0 3.9 212.0 211.9 6.59 5.78 4 1.647 1390K 656 0.0 0.0 L4 170/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 153.9 153.9 0.80 0.62 1 0.798 124K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/4 100.80 GB 0.0 6.6 1.9 4.7 11.3 6.6 0.9 2.4 162.4 276.5 41.86 38.94 89 0.470 6875K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.6 1.9 4.7 11.3 6.6 0.9 2.4 162.4 276.5 41.86 38.94 89 0.470 6875K 11K 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.6 1.9 4.7 6.6 1.9 0.0 0.0 238.8 238.4 28.47 26.99 21 1.356 6875K 11K 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 357.4 13.39 11.95 68 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): 15.0 total, 14.9 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.30 GB write, 769.19 MB/s write, 6.64 GB read, 451.79 MB/s read, 41.9 seconds Interval compaction: 11.30 GB write, 778.11 MB/s write, 6.64 GB read, 457.03 MB/s read, 41.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 18, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1346139 Average: 2.2082 StdDev: 11.78 Min: 0 Median: 1.4824 Max: 5656 Percentiles: P50: 1.48 P75: 1.87 P99: 5.68 P99.9: 10.22 P99.99: 17.35 ------------------------------------------------------ [ 0, 1 ] 255196 18.958% 18.958% #### ( 1, 2 ] 866165 64.344% 83.302% ############# ( 2, 3 ] 139513 10.364% 93.666% ## ( 3, 4 ] 45673 3.393% 97.059% # ( 4, 6 ] 31087 2.309% 99.368% ( 6, 10 ] 7105 0.528% 99.896% ( 10, 15 ] 1215 0.090% 99.986% ( 15, 22 ] 150 0.011% 99.997% ( 22, 34 ] 21 0.002% 99.999% ( 34, 51 ] 7 0.001% 99.999% ( 51, 76 ] 15 0.001% 100.001% ( 76, 110 ] 73 0.005% 100.006% ( 110, 170 ] 95 0.007% 100.013% ( 170, 250 ] 57 0.004% 100.017% ( 250, 380 ] 58 0.004% 100.022% ( 380, 580 ] 35 0.003% 100.024% ( 580, 870 ] 28 0.002% 100.026% ( 870, 1300 ] 15 0.001% 100.027% ( 1300, 1900 ] 10 0.001% 100.028% ( 1900, 2900 ] 5 0.000% 100.029% ( 2900, 4400 ] 4 0.000% 100.029% ( 4400, 6600 ] 2 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 63972 Average: 2.9630 StdDev: 17.80 Min: 1 Median: 1.6923 Max: 1655 Percentiles: P50: 1.69 P75: 2.33 P99: 7.58 P99.9: 129.27 P99.99: 846.96 ------------------------------------------------------ [ 0, 1 ] 4378 6.844% 6.844% # ( 1, 2 ] 39878 62.337% 69.180% ############ ( 2, 3 ] 11431 17.869% 87.049% #### ( 3, 4 ] 3993 6.242% 93.291% # ( 4, 6 ] 3368 5.265% 98.556% # ( 6, 10 ] 721 1.127% 99.683% ( 10, 15 ] 99 0.155% 99.837% ( 15, 22 ] 11 0.017% 99.855% ( 22, 34 ] 4 0.006% 99.861% ( 34, 51 ] 1 0.002% 99.862% ( 76, 110 ] 16 0.025% 99.887% ( 110, 170 ] 25 0.039% 99.927% ( 170, 250 ] 5 0.008% 99.934% ( 250, 380 ] 14 0.022% 99.956% ( 380, 580 ] 17 0.027% 99.983% ( 580, 870 ] 5 0.008% 99.991% ( 870, 1300 ] 3 0.005% 99.995% ( 1300, 1900 ] 3 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 294783 Average: 3.3093 StdDev: 30.02 Min: 1 Median: 1.6407 Max: 4387 Percentiles: P50: 1.64 P75: 2.17 P99: 8.88 P99.9: 189.16 P99.99: 805.99 ------------------------------------------------------ [ 0, 1 ] 30312 10.283% 10.283% ## ( 1, 2 ] 182732 61.989% 72.271% ############ ( 2, 3 ] 47461 16.100% 88.372% ### ( 3, 4 ] 15524 5.266% 93.638% # ( 4, 6 ] 12212 4.143% 97.781% # ( 6, 10 ] 4993 1.694% 99.475% ( 10, 15 ] 498 0.169% 99.643% ( 15, 22 ] 137 0.046% 99.690% ( 22, 34 ] 63 0.021% 99.711% ( 34, 51 ] 13 0.004% 99.716% ( 51, 76 ] 48 0.016% 99.732% ( 76, 110 ] 170 0.058% 99.790% ( 110, 170 ] 296 0.100% 99.890% ( 170, 250 ] 122 0.041% 99.931% ( 250, 380 ] 73 0.025% 99.956% ( 380, 580 ] 59 0.020% 99.976% ( 580, 870 ] 52 0.018% 99.994% ( 870, 1300 ] 23 0.008% 100.002% ( 1300, 1900 ] 10 0.003% 100.005% ( 1900, 2900 ] 7 0.002% 100.007% ( 2900, 4400 ] 10 0.003% 100.011% ** Level 4 read latency histogram (micros): Count: 150 Average: 237.5333 StdDev: 643.32 Min: 0 Median: 1.8148 Max: 3623 Percentiles: P50: 1.81 P75: 12.66 P99: 3623.00 P99.9: 3623.00 P99.99: 3623.00 ------------------------------------------------------ [ 0, 1 ] 31 20.667% 20.667% #### ( 1, 2 ] 54 36.000% 56.667% ####### ( 2, 3 ] 6 4.000% 60.667% # ( 3, 4 ] 7 4.667% 65.333% # ( 4, 6 ] 4 2.667% 68.000% # ( 6, 10 ] 2 1.333% 69.333% ( 10, 15 ] 16 10.667% 80.000% ## ( 15, 22 ] 7 4.667% 84.667% # ( 170, 250 ] 1 0.667% 85.333% ( 250, 380 ] 1 0.667% 86.000% ( 580, 870 ] 3 2.000% 88.000% ( 870, 1300 ] 7 4.667% 92.667% # ( 1300, 1900 ] 5 3.333% 96.000% # ( 1900, 2900 ] 3 2.000% 98.000% ( 2900, 4400 ] 3 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 840.4000 StdDev: 861.92 Min: 88 Median: 380.0000 Max: 2821 Percentiles: P50: 380.00 P75: 1300.00 P99: 2821.00 P99.9: 2821.00 P99.99: 2821.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 1 5.000% 20.000% # ( 170, 250 ] 4 20.000% 40.000% #### ( 250, 380 ] 2 10.000% 50.000% ## ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 15.0 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 327.03 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.754 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.81 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.368 H:M:S, 12.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-05:12:23 ... thread 0: (1000000,6000000) ops and (86693.0,227202.0) ops/second in (11.534951,26.408220) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/17 4.12 GB 50.4 4.6 0.0 4.6 10.3 5.7 0.0 1.8 137.9 306.9 34.26 32.18 100 0.343 4797K 5073 0.0 0.0 L1 11/11 1.23 GB 0.0 1.5 1.4 0.1 1.5 1.4 0.1 1.0 229.4 228.4 6.60 6.38 2 3.298 1536K 6583 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 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 21/0 961.78 MB 1.0 1.4 0.4 1.0 1.4 0.4 0.0 3.9 212.0 211.9 6.59 5.78 4 1.647 1390K 656 0.0 0.0 L4 170/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 0.2 1.0 153.9 153.9 0.80 0.62 1 0.798 124K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1265/28 101.78 GB 0.0 7.7 1.9 5.7 13.3 7.6 0.9 2.4 161.6 280.3 48.70 45.40 108 0.451 7962K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.7 1.9 5.7 13.3 7.6 0.9 2.4 161.6 280.3 48.70 45.40 108 0.451 7962K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.7 1.9 5.7 7.7 1.9 0.0 0.0 242.0 241.6 32.52 30.97 25 1.301 7962K 12K 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 358.1 16.18 14.43 83 0.195 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): 26.6 total, 26.4 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.33 GB write, 513.58 MB/s write, 7.68 GB read, 296.03 MB/s read, 48.7 seconds Interval compaction: 13.33 GB write, 516.93 MB/s write, 7.68 GB read, 297.96 MB/s read, 48.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 19, interval: 29 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2046976 Average: 2.1426 StdDev: 11.60 Min: 0 Median: 1.4298 Max: 5656 Percentiles: P50: 1.43 P75: 1.82 P99: 5.53 P99.9: 11.63 P99.99: 108.90 ------------------------------------------------------ [ 0, 1 ] 459550 22.450% 22.450% #### ( 1, 2 ] 1311990 64.094% 86.544% ############# ( 2, 3 ] 169524 8.282% 94.826% ## ( 3, 4 ] 56879 2.779% 97.605% # ( 4, 6 ] 37364 1.825% 99.430% ( 6, 10 ] 9024 0.441% 99.871% ( 10, 15 ] 1830 0.089% 99.960% ( 15, 22 ] 297 0.015% 99.975% ( 22, 34 ] 23 0.001% 99.976% ( 34, 51 ] 7 0.000% 99.976% ( 51, 76 ] 22 0.001% 99.977% ( 76, 110 ] 270 0.013% 99.990% ( 110, 170 ] 319 0.016% 100.006% ( 170, 250 ] 121 0.006% 100.012% ( 250, 380 ] 101 0.005% 100.017% ( 380, 580 ] 59 0.003% 100.020% ( 580, 870 ] 42 0.002% 100.022% ( 870, 1300 ] 26 0.001% 100.023% ( 1300, 1900 ] 12 0.001% 100.024% ( 1900, 2900 ] 6 0.000% 100.024% ( 2900, 4400 ] 9 0.000% 100.024% ( 4400, 6600 ] 2 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 215565 Average: 2.3431 StdDev: 11.68 Min: 1 Median: 1.3928 Max: 1655 Percentiles: P50: 1.39 P75: 1.81 P99: 6.13 P99.9: 114.35 P99.99: 529.57 ------------------------------------------------------ [ 0, 1 ] 56870 26.382% 26.382% ##### ( 1, 2 ] 129599 60.121% 86.502% ############ ( 2, 3 ] 15541 7.209% 93.712% # ( 3, 4 ] 5768 2.676% 96.388% # ( 4, 6 ] 5583 2.590% 98.978% # ( 6, 10 ] 1470 0.682% 99.659% ( 10, 15 ] 247 0.115% 99.774% ( 15, 22 ] 72 0.033% 99.807% ( 22, 34 ] 5 0.002% 99.810% ( 34, 51 ] 2 0.001% 99.811% ( 51, 76 ] 7 0.003% 99.814% ( 76, 110 ] 175 0.081% 99.895% ( 110, 170 ] 144 0.067% 99.962% ( 170, 250 ] 21 0.010% 99.972% ( 250, 380 ] 20 0.009% 99.981% ( 380, 580 ] 26 0.012% 99.993% ( 580, 870 ] 8 0.004% 99.997% ( 870, 1300 ] 4 0.002% 99.999% ( 1300, 1900 ] 3 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 294783 Average: 3.3093 StdDev: 30.02 Min: 1 Median: 1.6407 Max: 4387 Percentiles: P50: 1.64 P75: 2.17 P99: 8.88 P99.9: 189.16 P99.99: 805.99 ------------------------------------------------------ [ 0, 1 ] 30312 10.283% 10.283% ## ( 1, 2 ] 182732 61.989% 72.271% ############ ( 2, 3 ] 47461 16.100% 88.372% ### ( 3, 4 ] 15524 5.266% 93.638% # ( 4, 6 ] 12212 4.143% 97.781% # ( 6, 10 ] 4993 1.694% 99.475% ( 10, 15 ] 498 0.169% 99.643% ( 15, 22 ] 137 0.046% 99.690% ( 22, 34 ] 63 0.021% 99.711% ( 34, 51 ] 13 0.004% 99.716% ( 51, 76 ] 48 0.016% 99.732% ( 76, 110 ] 170 0.058% 99.790% ( 110, 170 ] 296 0.100% 99.890% ( 170, 250 ] 122 0.041% 99.931% ( 250, 380 ] 73 0.025% 99.956% ( 380, 580 ] 59 0.020% 99.976% ( 580, 870 ] 52 0.018% 99.994% ( 870, 1300 ] 23 0.008% 100.002% ( 1300, 1900 ] 10 0.003% 100.005% ( 1900, 2900 ] 7 0.002% 100.007% ( 2900, 4400 ] 10 0.003% 100.011% ** Level 4 read latency histogram (micros): Count: 150 Average: 237.5333 StdDev: 643.32 Min: 0 Median: 1.8148 Max: 3623 Percentiles: P50: 1.81 P75: 12.66 P99: 3623.00 P99.9: 3623.00 P99.99: 3623.00 ------------------------------------------------------ [ 0, 1 ] 31 20.667% 20.667% #### ( 1, 2 ] 54 36.000% 56.667% ####### ( 2, 3 ] 6 4.000% 60.667% # ( 3, 4 ] 7 4.667% 65.333% # ( 4, 6 ] 4 2.667% 68.000% # ( 6, 10 ] 2 1.333% 69.333% ( 10, 15 ] 16 10.667% 80.000% ## ( 15, 22 ] 7 4.667% 84.667% # ( 170, 250 ] 1 0.667% 85.333% ( 250, 380 ] 1 0.667% 86.000% ( 580, 870 ] 3 2.000% 88.000% ( 870, 1300 ] 7 4.667% 92.667% # ( 1300, 1900 ] 5 3.333% 96.000% # ( 1900, 2900 ] 3 2.000% 98.000% ( 2900, 4400 ] 3 2.000% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 840.4000 StdDev: 861.92 Min: 88 Median: 380.0000 Max: 2821 Percentiles: P50: 380.00 P75: 1300.00 P99: 2821.00 P99.9: 2821.00 P99.99: 2821.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 1 5.000% 20.000% # ( 170, 250 ] 4 20.000% 40.000% #### ( 250, 380 ] 2 10.000% 50.000% ## ( 380, 580 ] 1 5.000% 55.000% # ( 580, 870 ] 2 10.000% 65.000% ## ( 870, 1300 ] 2 10.000% 75.000% ## ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 26.6 total, 11.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 222.15 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.318 H:M:S, 38.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 85.32 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:8.564 H:M:S, 74.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-05:12:41 ... thread 0: (1000000,7000000) ops and (53548.0,155269.0) ops/second in (18.674820,45.083040) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/9 1.41 GB 44.0 5.0 0.0 5.0 11.6 6.6 0.0 1.8 124.2 288.0 41.10 36.24 113 0.364 5181K 5585 0.0 0.0 L1 6/6 380.97 MB 0.0 6.3 5.0 1.3 6.2 4.9 0.1 1.2 215.2 211.2 30.12 27.24 3 10.040 6581K 119K 0.0 0.0 L2 1/0 77.63 MB 0.8 0.1 0.1 0.0 0.1 0.1 4.6 1.8 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 13/0 992.51 MB 1.0 1.4 0.4 1.0 1.4 0.4 4.2 3.4 201.5 201.3 7.33 6.16 5 1.465 1395K 656 0.0 0.0 L4 153/0 9.51 GB 1.0 4.2 3.5 0.8 4.2 3.4 1.1 1.2 118.4 118.1 36.68 20.68 28 1.310 3599K 7996 0.0 0.0 L5 1096/0 90.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1280/15 102.59 GB 0.0 17.1 9.0 8.1 23.6 15.4 14.6 3.6 151.4 208.5 115.68 90.76 150 0.771 16M 133K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.1 9.0 8.1 23.6 15.4 14.6 3.6 151.4 208.5 115.68 90.76 150 0.771 16M 133K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.1 9.0 8.1 17.0 8.9 0.0 0.0 185.5 184.1 94.39 73.75 55 1.716 16M 133K 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 316.5 21.30 17.00 95 0.224 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.3 total, 45.1 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: 23.55 GB write, 532.88 MB/s write, 17.10 GB read, 386.96 MB/s read, 115.7 seconds Interval compaction: 23.55 GB write, 534.91 MB/s write, 17.10 GB read, 388.44 MB/s read, 115.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 55, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2823942 Average: 3.0806 StdDev: 28.43 Min: 0 Median: 1.4403 Max: 5919 Percentiles: P50: 1.44 P75: 1.84 P99: 8.06 P99.9: 161.93 P99.99: 462.59 ------------------------------------------------------ [ 0, 1 ] 639759 22.655% 22.655% ##### ( 1, 2 ] 1754007 62.112% 84.767% ############ ( 2, 3 ] 237198 8.400% 93.166% ## ( 3, 4 ] 85879 3.041% 96.207% # ( 4, 6 ] 70297 2.489% 98.697% ( 6, 10 ] 16609 0.588% 99.285% ( 10, 15 ] 3225 0.114% 99.399% ( 15, 22 ] 510 0.018% 99.417% ( 22, 34 ] 31 0.001% 99.418% ( 34, 51 ] 11 0.000% 99.419% ( 51, 76 ] 392 0.014% 99.433% ( 76, 110 ] 8230 0.291% 99.724% ( 110, 170 ] 5744 0.203% 99.927% ( 170, 250 ] 896 0.032% 99.959% ( 250, 380 ] 643 0.023% 99.982% ( 380, 580 ] 556 0.020% 100.002% ( 580, 870 ] 239 0.008% 100.010% ( 870, 1300 ] 77 0.003% 100.013% ( 1300, 1900 ] 47 0.002% 100.014% ( 1900, 2900 ] 64 0.002% 100.017% ( 2900, 4400 ] 67 0.002% 100.019% ( 4400, 6600 ] 15 0.001% 100.020% ** Level 1 read latency histogram (micros): Count: 1293041 Average: 7.7289 StdDev: 124.82 Min: 1 Median: 1.7858 Max: 10992 Percentiles: P50: 1.79 P75: 2.72 P99: 9.18 P99.9: 78.68 P99.99: 111.15 ------------------------------------------------------ [ 0, 1 ] 129828 10.041% 10.041% ## ( 1, 2 ] 657546 50.853% 60.893% ########## ( 2, 3 ] 254722 19.699% 80.593% #### ( 3, 4 ] 106230 8.216% 88.808% ## ( 4, 6 ] 111675 8.637% 97.445% ## ( 6, 10 ] 25305 1.957% 99.402% ( 10, 15 ] 5499 0.425% 99.827% ( 15, 22 ] 732 0.057% 99.884% ( 22, 34 ] 44 0.003% 99.887% ( 34, 51 ] 15 0.001% 99.888% ( 51, 76 ] 54 0.004% 99.892% ( 76, 110 ] 1244 0.096% 99.989% ( 110, 170 ] 924 0.071% 100.060% ( 170, 250 ] 273 0.021% 100.081% ( 250, 380 ] 378 0.029% 100.110% ( 380, 580 ] 597 0.046% 100.157% ( 580, 870 ] 561 0.043% 100.200% ( 870, 1300 ] 441 0.034% 100.234% ( 1300, 1900 ] 316 0.024% 100.259% ( 1900, 2900 ] 429 0.033% 100.292% ( 2900, 4400 ] 571 0.044% 100.336% ( 4400, 6600 ] 197 0.015% 100.351% ( 6600, 9900 ] 51 0.004% 100.355% ( 9900, 14000 ] 3 0.000% 100.355% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 330977 Average: 10.1167 StdDev: 130.87 Min: 1 Median: 1.6717 Max: 8610 Percentiles: P50: 1.67 P75: 2.30 P99: 12.30 P99.9: 1942.12 P99.99: 4248.34 ------------------------------------------------------ [ 0, 1 ] 30958 9.354% 9.354% ## ( 1, 2 ] 200285 60.513% 69.867% ############ ( 2, 3 ] 55948 16.904% 86.771% ### ( 3, 4 ] 19570 5.913% 92.683% # ( 4, 6 ] 14796 4.470% 97.154% # ( 6, 10 ] 5808 1.755% 98.909% ( 10, 15 ] 657 0.199% 99.107% ( 15, 22 ] 162 0.049% 99.156% ( 22, 34 ] 64 0.019% 99.175% ( 34, 51 ] 14 0.004% 99.180% ( 51, 76 ] 50 0.015% 99.195% ( 76, 110 ] 183 0.055% 99.250% ( 110, 170 ] 370 0.112% 99.362% ( 170, 250 ] 225 0.068% 99.430% ( 250, 380 ] 261 0.079% 99.509% ( 380, 580 ] 381 0.115% 99.624% ( 580, 870 ] 407 0.123% 99.747% ( 870, 1300 ] 301 0.091% 99.838% ( 1300, 1900 ] 200 0.060% 99.898% ( 1900, 2900 ] 143 0.043% 99.941% ( 2900, 4400 ] 179 0.054% 99.995% ( 4400, 6600 ] 46 0.014% 100.009% ( 6600, 9900 ] 6 0.002% 100.011% ** Level 4 read latency histogram (micros): Count: 167955 Average: 14.1175 StdDev: 149.86 Min: 0 Median: 1.9546 Max: 8684 Percentiles: P50: 1.95 P75: 2.94 P99: 166.15 P99.9: 1671.42 P99.99: 2813.38 ------------------------------------------------------ [ 0, 1 ] 2283 1.359% 1.359% ( 1, 2 ] 85584 50.957% 52.316% ########## ( 2, 3 ] 40566 24.153% 76.469% ##### ( 3, 4 ] 17572 10.462% 86.931% ## ( 4, 6 ] 16125 9.601% 96.532% ## ( 6, 10 ] 3214 1.914% 98.445% ( 10, 15 ] 691 0.411% 98.857% ( 15, 22 ] 101 0.060% 98.917% ( 22, 34 ] 15 0.009% 98.926% ( 34, 51 ] 3 0.002% 98.928% ( 51, 76 ] 6 0.004% 98.931% ( 76, 110 ] 20 0.012% 98.943% ( 110, 170 ] 102 0.061% 99.004% ( 170, 250 ] 169 0.101% 99.105% ( 250, 380 ] 213 0.127% 99.231% ( 380, 580 ] 308 0.183% 99.415% ( 580, 870 ] 413 0.246% 99.661% ( 870, 1300 ] 290 0.173% 99.833% ( 1300, 1900 ] 181 0.108% 99.941% ( 1900, 2900 ] 90 0.054% 99.995% ( 2900, 4400 ] 112 0.067% 100.061% ( 4400, 6600 ] 18 0.011% 100.072% ( 6600, 9900 ] 5 0.003% 100.075% ** Level 5 read latency histogram (micros): Count: 280 Average: 1680.0857 StdDev: 1643.60 Min: 85 Median: 888.6957 Max: 9699 Percentiles: P50: 888.70 P75: 2981.82 P99: 6490.00 P99.9: 9438.00 P99.99: 9699.00 ------------------------------------------------------ ( 76, 110 ] 11 3.929% 3.929% # ( 110, 170 ] 10 3.571% 7.500% # ( 170, 250 ] 12 4.286% 11.786% # ( 250, 380 ] 36 12.857% 24.643% ### ( 380, 580 ] 33 11.786% 36.429% ## ( 580, 870 ] 37 13.214% 49.643% ### ( 870, 1300 ] 23 8.214% 57.857% ## ( 1300, 1900 ] 18 6.429% 64.286% # ( 1900, 2900 ] 27 9.643% 73.929% ## ( 2900, 4400 ] 55 19.643% 93.571% #### ( 4400, 6600 ] 16 5.714% 99.286% # ( 6600, 9900 ] 2 0.714% 100.000% ** DB Stats ** Uptime(secs): 45.3 total, 18.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 152.23 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:25.645 H:M:S, 56.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 52.70 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:15.327 H:M:S, 82.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-05:12:45 ... thread 0: (1000000,8000000) ops and (271424.9,164044.3) ops/second in (3.684261,48.767301) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/10 1.72 GB 0.0 5.8 0.0 5.8 13.4 7.6 0.0 1.8 124.3 285.2 48.13 42.33 129 0.373 6076K 6514 0.0 0.0 L1 7/7 610.67 MB 0.0 7.4 5.7 1.7 7.3 5.6 0.1 1.3 205.9 202.5 36.69 32.15 4 9.172 7284K 119K 0.0 0.0 L2 1/0 72.72 MB 0.7 0.1 0.1 0.0 0.1 0.1 5.1 1.8 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 17/0 934.48 MB 0.9 2.1 0.7 1.4 2.1 0.7 4.4 3.1 185.4 185.1 11.38 9.14 9 1.265 1961K 3417 0.0 0.0 L4 155/0 9.64 GB 1.0 4.9 3.9 1.0 4.8 3.9 1.2 1.2 123.0 122.7 40.46 23.63 32 1.264 4244K 9357 0.0 0.0 L5 1100/0 90.61 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/17 103.56 GB 0.0 20.3 10.3 9.9 27.7 17.7 15.8 3.7 151.2 206.7 137.12 107.68 175 0.784 19M 138K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.3 10.3 9.9 27.7 17.7 15.8 3.7 151.2 206.7 137.12 107.68 175 0.784 19M 138K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.3 10.3 9.9 20.1 10.2 0.0 0.0 184.3 183.0 112.50 88.06 67 1.679 19M 138K 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 314.7 24.62 19.62 108 0.228 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 48.9 total, 48.8 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.68 GB write, 579.06 MB/s write, 20.25 GB read, 423.74 MB/s read, 137.1 seconds Interval compaction: 27.68 GB write, 581.11 MB/s write, 20.25 GB read, 425.24 MB/s read, 137.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 65, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 65, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3103182 Average: 3.0504 StdDev: 28.00 Min: 0 Median: 1.4564 Max: 5919 Percentiles: P50: 1.46 P75: 1.86 P99: 7.82 P99.9: 159.94 P99.99: 461.35 ------------------------------------------------------ [ 0, 1 ] 672934 21.685% 21.685% #### ( 1, 2 ] 1925284 62.042% 83.728% ############ ( 2, 3 ] 279930 9.021% 92.748% ## ( 3, 4 ] 101114 3.258% 96.007% # ( 4, 6 ] 84296 2.716% 98.723% # ( 6, 10 ] 18836 0.607% 99.330% ( 10, 15 ] 3646 0.117% 99.448% ( 15, 22 ] 542 0.017% 99.465% ( 22, 34 ] 39 0.001% 99.466% ( 34, 51 ] 13 0.000% 99.467% ( 51, 76 ] 393 0.013% 99.479% ( 76, 110 ] 8240 0.266% 99.745% ( 110, 170 ] 5782 0.186% 99.931% ( 170, 250 ] 927 0.030% 99.961% ( 250, 380 ] 662 0.021% 99.982% ( 380, 580 ] 577 0.019% 100.001% ( 580, 870 ] 257 0.008% 100.009% ( 870, 1300 ] 96 0.003% 100.012% ( 1300, 1900 ] 51 0.002% 100.014% ( 1900, 2900 ] 76 0.002% 100.017% ( 2900, 4400 ] 70 0.002% 100.019% ( 4400, 6600 ] 15 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 1580952 Average: 7.5222 StdDev: 118.69 Min: 1 Median: 1.8094 Max: 10992 Percentiles: P50: 1.81 P75: 2.74 P99: 9.22 P99.9: 69.33 P99.99: 114.70 ------------------------------------------------------ [ 0, 1 ] 136133 8.611% 8.611% ## ( 1, 2 ] 808387 51.133% 59.744% ########## ( 2, 3 ] 324614 20.533% 80.277% #### ( 3, 4 ] 131827 8.338% 88.615% ## ( 4, 6 ] 137923 8.724% 97.339% ## ( 6, 10 ] 32642 2.065% 99.404% ( 10, 15 ] 6831 0.432% 99.836% ( 15, 22 ] 903 0.057% 99.893% ( 22, 34 ] 52 0.003% 99.896% ( 34, 51 ] 18 0.001% 99.897% ( 51, 76 ] 56 0.004% 99.901% ( 76, 110 ] 1323 0.084% 99.985% ( 110, 170 ] 1083 0.069% 100.053% ( 170, 250 ] 363 0.023% 100.076% ( 250, 380 ] 502 0.032% 100.108% ( 380, 580 ] 773 0.049% 100.157% ( 580, 870 ] 753 0.048% 100.204% ( 870, 1300 ] 592 0.037% 100.242% ( 1300, 1900 ] 419 0.027% 100.268% ( 1900, 2900 ] 493 0.031% 100.300% ( 2900, 4400 ] 633 0.040% 100.340% ( 4400, 6600 ] 209 0.013% 100.353% ( 6600, 9900 ] 52 0.003% 100.356% ( 9900, 14000 ] 3 0.000% 100.356% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 379987 Average: 9.5446 StdDev: 123.50 Min: 1 Median: 1.6880 Max: 8610 Percentiles: P50: 1.69 P75: 2.35 P99: 11.18 P99.9: 1721.73 P99.99: 4006.16 ------------------------------------------------------ [ 0, 1 ] 32208 8.476% 8.476% ## ( 1, 2 ] 229344 60.356% 68.832% ############ ( 2, 3 ] 66721 17.559% 86.391% #### ( 3, 4 ] 23453 6.172% 92.563% # ( 4, 6 ] 17902 4.711% 97.274% # ( 6, 10 ] 6381 1.679% 98.953% ( 10, 15 ] 754 0.198% 99.152% ( 15, 22 ] 176 0.046% 99.198% ( 22, 34 ] 66 0.017% 99.215% ( 34, 51 ] 14 0.004% 99.219% ( 51, 76 ] 50 0.013% 99.232% ( 76, 110 ] 185 0.049% 99.281% ( 110, 170 ] 404 0.106% 99.387% ( 170, 250 ] 262 0.069% 99.456% ( 250, 380 ] 307 0.081% 99.537% ( 380, 580 ] 444 0.117% 99.654% ( 580, 870 ] 455 0.120% 99.773% ( 870, 1300 ] 332 0.087% 99.861% ( 1300, 1900 ] 212 0.056% 99.917% ( 1900, 2900 ] 147 0.039% 99.955% ( 2900, 4400 ] 179 0.047% 100.002% ( 4400, 6600 ] 46 0.012% 100.014% ( 6600, 9900 ] 6 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 216240 Average: 12.3301 StdDev: 134.86 Min: 0 Median: 1.9407 Max: 8684 Percentiles: P50: 1.94 P75: 2.91 P99: 18.09 P99.9: 1435.75 P99.99: 2398.72 ------------------------------------------------------ [ 0, 1 ] 2889 1.336% 1.336% ( 1, 2 ] 111860 51.730% 53.066% ########## ( 2, 3 ] 51919 24.010% 77.075% ##### ( 3, 4 ] 21885 10.121% 87.196% ## ( 4, 6 ] 20335 9.404% 96.600% ## ( 6, 10 ] 4317 1.996% 98.596% ( 10, 15 ] 820 0.379% 98.976% ( 15, 22 ] 119 0.055% 99.031% ( 22, 34 ] 16 0.007% 99.038% ( 34, 51 ] 3 0.001% 99.039% ( 51, 76 ] 6 0.003% 99.042% ( 76, 110 ] 35 0.016% 99.058% ( 110, 170 ] 145 0.067% 99.126% ( 170, 250 ] 218 0.101% 99.226% ( 250, 380 ] 272 0.126% 99.352% ( 380, 580 ] 371 0.172% 99.524% ( 580, 870 ] 459 0.212% 99.736% ( 870, 1300 ] 312 0.144% 99.880% ( 1300, 1900 ] 189 0.087% 99.968% ( 1900, 2900 ] 97 0.045% 100.012% ( 2900, 4400 ] 115 0.053% 100.066% ( 4400, 6600 ] 18 0.008% 100.074% ( 6600, 9900 ] 5 0.002% 100.076% ** Level 5 read latency histogram (micros): Count: 300 Average: 1626.7733 StdDev: 1624.37 Min: 82 Median: 847.1053 Max: 9699 Percentiles: P50: 847.11 P75: 2866.67 P99: 6462.50 P99.9: 9405.00 P99.99: 9699.00 ------------------------------------------------------ ( 76, 110 ] 13 4.333% 4.333% # ( 110, 170 ] 12 4.000% 8.333% # ( 170, 250 ] 20 6.667% 15.000% # ( 250, 380 ] 37 12.333% 27.333% ## ( 380, 580 ] 33 11.000% 38.333% ## ( 580, 870 ] 38 12.667% 51.000% ### ( 870, 1300 ] 23 7.667% 58.667% ## ( 1300, 1900 ] 20 6.667% 65.333% # ( 1900, 2900 ] 30 10.000% 75.333% ## ( 2900, 4400 ] 56 18.667% 94.000% #### ( 4400, 6600 ] 16 5.333% 99.333% # ( 6600, 9900 ] 2 0.667% 100.000% ** DB Stats ** Uptime(secs): 48.9 total, 3.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 160.88 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:26.602 H:M:S, 54.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 267.13 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.957 H:M:S, 26.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-05:12:48 ... thread 0: (1000000,9000000) ops and (329358.2,173733.4) ops/second in (3.036208,51.803509) 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.70 GB 100.7 6.6 0.0 6.6 15.2 8.5 0.0 1.8 125.6 287.2 54.16 47.98 146 0.371 6908K 7366 0.0 0.0 L1 7/7 610.67 MB 0.0 7.4 5.7 1.7 7.3 5.6 0.1 1.3 205.9 202.5 36.69 32.15 4 9.172 7284K 119K 0.0 0.0 L2 1/0 72.72 MB 0.7 0.1 0.1 0.0 0.1 0.1 5.1 1.8 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 17/0 934.48 MB 0.9 2.1 0.7 1.4 2.1 0.7 4.4 3.1 185.4 185.1 11.38 9.14 9 1.265 1961K 3417 0.0 0.0 L4 155/0 9.64 GB 1.0 4.9 3.9 1.0 4.8 3.9 1.2 1.2 123.0 122.7 40.46 23.63 32 1.264 4244K 9357 0.0 0.0 L5 1100/0 90.61 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/17 104.54 GB 0.0 21.1 10.3 10.7 29.5 18.7 15.8 3.4 150.6 210.7 143.15 113.34 192 0.746 20M 139K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.1 10.3 10.7 29.5 18.7 15.8 3.4 150.6 210.7 143.15 113.34 192 0.746 20M 139K 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.1 10.3 10.7 20.9 10.2 0.0 0.0 186.3 185.1 115.68 91.17 70 1.653 20M 139K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 318.8 27.46 22.16 122 0.225 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 52.0 total, 51.8 interval Flush(GB): cumulative 8.551, interval 8.551 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.46 GB write, 580.37 MB/s write, 21.05 GB read, 414.74 MB/s read, 143.1 seconds Interval compaction: 29.46 GB write, 582.30 MB/s write, 21.05 GB read, 416.12 MB/s read, 143.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 68, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 68, interval: 83 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3487010 Average: 2.9658 StdDev: 26.70 Min: 0 Median: 1.4656 Max: 5919 Percentiles: P50: 1.47 P75: 1.86 P99: 7.40 P99.9: 154.77 P99.99: 395.64 ------------------------------------------------------ [ 0, 1 ] 726400 20.832% 20.832% #### ( 1, 2 ] 2184502 62.647% 83.478% ############# ( 2, 3 ] 327516 9.392% 92.871% ## ( 3, 4 ] 113638 3.259% 96.130% # ( 4, 6 ] 92642 2.657% 98.787% # ( 6, 10 ] 21196 0.608% 99.394% ( 10, 15 ] 3990 0.114% 99.509% ( 15, 22 ] 568 0.016% 99.525% ( 22, 34 ] 45 0.001% 99.526% ( 34, 51 ] 16 0.000% 99.527% ( 51, 76 ] 394 0.011% 99.538% ( 76, 110 ] 8278 0.237% 99.776% ( 110, 170 ] 5814 0.167% 99.942% ( 170, 250 ] 944 0.027% 99.969% ( 250, 380 ] 672 0.019% 99.989% ( 380, 580 ] 592 0.017% 100.006% ( 580, 870 ] 264 0.008% 100.013% ( 870, 1300 ] 100 0.003% 100.016% ( 1300, 1900 ] 55 0.002% 100.018% ( 1900, 2900 ] 78 0.002% 100.020% ( 2900, 4400 ] 71 0.002% 100.022% ( 4400, 6600 ] 15 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 1580952 Average: 7.5222 StdDev: 118.69 Min: 1 Median: 1.8094 Max: 10992 Percentiles: P50: 1.81 P75: 2.74 P99: 9.22 P99.9: 69.33 P99.99: 114.70 ------------------------------------------------------ [ 0, 1 ] 136133 8.611% 8.611% ## ( 1, 2 ] 808387 51.133% 59.744% ########## ( 2, 3 ] 324614 20.533% 80.277% #### ( 3, 4 ] 131827 8.338% 88.615% ## ( 4, 6 ] 137923 8.724% 97.339% ## ( 6, 10 ] 32642 2.065% 99.404% ( 10, 15 ] 6831 0.432% 99.836% ( 15, 22 ] 903 0.057% 99.893% ( 22, 34 ] 52 0.003% 99.896% ( 34, 51 ] 18 0.001% 99.897% ( 51, 76 ] 56 0.004% 99.901% ( 76, 110 ] 1323 0.084% 99.985% ( 110, 170 ] 1083 0.069% 100.053% ( 170, 250 ] 363 0.023% 100.076% ( 250, 380 ] 502 0.032% 100.108% ( 380, 580 ] 773 0.049% 100.157% ( 580, 870 ] 753 0.048% 100.204% ( 870, 1300 ] 592 0.037% 100.242% ( 1300, 1900 ] 419 0.027% 100.268% ( 1900, 2900 ] 493 0.031% 100.300% ( 2900, 4400 ] 633 0.040% 100.340% ( 4400, 6600 ] 209 0.013% 100.353% ( 6600, 9900 ] 52 0.003% 100.356% ( 9900, 14000 ] 3 0.000% 100.356% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 379987 Average: 9.5446 StdDev: 123.50 Min: 1 Median: 1.6880 Max: 8610 Percentiles: P50: 1.69 P75: 2.35 P99: 11.18 P99.9: 1721.73 P99.99: 4006.16 ------------------------------------------------------ [ 0, 1 ] 32208 8.476% 8.476% ## ( 1, 2 ] 229344 60.356% 68.832% ############ ( 2, 3 ] 66721 17.559% 86.391% #### ( 3, 4 ] 23453 6.172% 92.563% # ( 4, 6 ] 17902 4.711% 97.274% # ( 6, 10 ] 6381 1.679% 98.953% ( 10, 15 ] 754 0.198% 99.152% ( 15, 22 ] 176 0.046% 99.198% ( 22, 34 ] 66 0.017% 99.215% ( 34, 51 ] 14 0.004% 99.219% ( 51, 76 ] 50 0.013% 99.232% ( 76, 110 ] 185 0.049% 99.281% ( 110, 170 ] 404 0.106% 99.387% ( 170, 250 ] 262 0.069% 99.456% ( 250, 380 ] 307 0.081% 99.537% ( 380, 580 ] 444 0.117% 99.654% ( 580, 870 ] 455 0.120% 99.773% ( 870, 1300 ] 332 0.087% 99.861% ( 1300, 1900 ] 212 0.056% 99.917% ( 1900, 2900 ] 147 0.039% 99.955% ( 2900, 4400 ] 179 0.047% 100.002% ( 4400, 6600 ] 46 0.012% 100.014% ( 6600, 9900 ] 6 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 216240 Average: 12.3301 StdDev: 134.86 Min: 0 Median: 1.9407 Max: 8684 Percentiles: P50: 1.94 P75: 2.91 P99: 18.09 P99.9: 1435.75 P99.99: 2398.72 ------------------------------------------------------ [ 0, 1 ] 2889 1.336% 1.336% ( 1, 2 ] 111860 51.730% 53.066% ########## ( 2, 3 ] 51919 24.010% 77.075% ##### ( 3, 4 ] 21885 10.121% 87.196% ## ( 4, 6 ] 20335 9.404% 96.600% ## ( 6, 10 ] 4317 1.996% 98.596% ( 10, 15 ] 820 0.379% 98.976% ( 15, 22 ] 119 0.055% 99.031% ( 22, 34 ] 16 0.007% 99.038% ( 34, 51 ] 3 0.001% 99.039% ( 51, 76 ] 6 0.003% 99.042% ( 76, 110 ] 35 0.016% 99.058% ( 110, 170 ] 145 0.067% 99.126% ( 170, 250 ] 218 0.101% 99.226% ( 250, 380 ] 272 0.126% 99.352% ( 380, 580 ] 371 0.172% 99.524% ( 580, 870 ] 459 0.212% 99.736% ( 870, 1300 ] 312 0.144% 99.880% ( 1300, 1900 ] 189 0.087% 99.968% ( 1900, 2900 ] 97 0.045% 100.012% ( 2900, 4400 ] 115 0.053% 100.066% ( 4400, 6600 ] 18 0.008% 100.074% ( 6600, 9900 ] 5 0.002% 100.076% ** Level 5 read latency histogram (micros): Count: 300 Average: 1626.7733 StdDev: 1624.37 Min: 82 Median: 847.1053 Max: 9699 Percentiles: P50: 847.11 P75: 2866.67 P99: 6462.50 P99.9: 9405.00 P99.99: 9699.00 ------------------------------------------------------ ( 76, 110 ] 13 4.333% 4.333% # ( 110, 170 ] 12 4.000% 8.333% # ( 170, 250 ] 20 6.667% 15.000% # ( 250, 380 ] 37 12.333% 27.333% ## ( 380, 580 ] 33 11.000% 38.333% ## ( 580, 870 ] 38 12.667% 51.000% ### ( 870, 1300 ] 23 7.667% 58.667% ## ( 1300, 1900 ] 20 6.667% 65.333% # ( 1900, 2900 ] 30 10.000% 75.333% ## ( 2900, 4400 ] 56 18.667% 94.000% #### ( 4400, 6600 ] 16 5.333% 99.333% # ( 6600, 9900 ] 2 0.667% 100.000% ** DB Stats ** Uptime(secs): 52.0 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 170.41 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:27.001 H:M:S, 51.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.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.399 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-05:12:51 ... thread 0: (1000000,10000000) ops and (306357.5,181594.8) ops/second in (3.264160,55.067669) 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/10 3.63 GB 195.1 7.5 0.0 7.5 17.0 9.5 0.0 1.8 127.3 289.0 60.36 53.82 163 0.370 7803K 8341 0.0 0.0 L1 7/7 610.67 MB 0.0 7.4 5.7 1.7 7.3 5.6 0.1 1.3 205.9 202.5 36.69 32.15 4 9.172 7284K 119K 0.0 0.0 L2 1/0 72.72 MB 0.7 0.1 0.1 0.0 0.1 0.1 5.1 1.8 243.8 243.8 0.46 0.44 1 0.457 113K 24 0.0 0.0 L3 17/0 934.48 MB 0.9 2.1 0.7 1.4 2.1 0.7 4.4 3.1 185.4 185.1 11.38 9.14 9 1.265 1961K 3417 0.0 0.0 L4 155/0 9.64 GB 1.0 4.9 3.9 1.0 4.8 3.9 1.2 1.2 123.0 122.7 40.46 23.63 32 1.264 4244K 9357 0.0 0.0 L5 1100/0 90.61 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1299/17 105.47 GB 0.0 21.9 10.3 11.6 31.3 19.7 15.8 3.3 150.2 214.6 149.34 119.18 209 0.715 21M 140K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.9 10.3 11.6 31.3 19.7 15.8 3.3 150.2 214.6 149.34 119.18 209 0.715 21M 140K 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 10.3 11.6 21.8 10.2 0.0 0.0 188.5 187.3 119.02 94.45 73 1.630 21M 140K 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 322.0 30.32 24.72 136 0.223 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): 55.2 total, 55.1 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.30 GB write, 580.27 MB/s write, 21.91 GB read, 406.20 MB/s read, 149.3 seconds Interval compaction: 31.30 GB write, 582.08 MB/s write, 21.91 GB read, 407.47 MB/s read, 149.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 72, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 72, interval: 89 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3863462 Average: 2.9020 StdDev: 25.61 Min: 0 Median: 1.4732 Max: 5919 Percentiles: P50: 1.47 P75: 1.87 P99: 7.12 P99.9: 150.63 P99.99: 365.82 ------------------------------------------------------ [ 0, 1 ] 777846 20.133% 20.133% #### ( 1, 2 ] 2438612 63.120% 83.253% ############# ( 2, 3 ] 373665 9.672% 92.925% ## ( 3, 4 ] 126348 3.270% 96.195% # ( 4, 6 ] 101708 2.633% 98.828% # ( 6, 10 ] 23756 0.615% 99.443% ( 10, 15 ] 4331 0.112% 99.555% ( 15, 22 ] 591 0.015% 99.570% ( 22, 34 ] 50 0.001% 99.571% ( 34, 51 ] 18 0.000% 99.572% ( 51, 76 ] 401 0.010% 99.582% ( 76, 110 ] 8312 0.215% 99.797% ( 110, 170 ] 5850 0.151% 99.949% ( 170, 250 ] 973 0.025% 99.974% ( 250, 380 ] 691 0.018% 99.992% ( 380, 580 ] 603 0.016% 100.008% ( 580, 870 ] 272 0.007% 100.015% ( 870, 1300 ] 107 0.003% 100.017% ( 1300, 1900 ] 56 0.001% 100.019% ( 1900, 2900 ] 81 0.002% 100.021% ( 2900, 4400 ] 72 0.002% 100.023% ( 4400, 6600 ] 15 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1645785 Average: 7.3404 StdDev: 116.36 Min: 1 Median: 1.7978 Max: 10992 Percentiles: P50: 1.80 P75: 2.72 P99: 9.20 P99.9: 79.91 P99.99: 120.80 ------------------------------------------------------ [ 0, 1 ] 142482 8.657% 8.657% ## ( 1, 2 ] 852906 51.824% 60.481% ########## ( 2, 3 ] 333476 20.262% 80.743% #### ( 3, 4 ] 133921 8.137% 88.881% ## ( 4, 6 ] 139628 8.484% 97.365% ## ( 6, 10 ] 33648 2.044% 99.409% ( 10, 15 ] 6864 0.417% 99.826% ( 15, 22 ] 911 0.055% 99.882% ( 22, 34 ] 53 0.003% 99.885% ( 34, 51 ] 18 0.001% 99.886% ( 51, 76 ] 67 0.004% 99.890% ( 76, 110 ] 1438 0.087% 99.977% ( 110, 170 ] 1158 0.070% 100.048% ( 170, 250 ] 382 0.023% 100.071% ( 250, 380 ] 518 0.031% 100.102% ( 380, 580 ] 786 0.048% 100.150% ( 580, 870 ] 760 0.046% 100.196% ( 870, 1300 ] 592 0.036% 100.232% ( 1300, 1900 ] 419 0.025% 100.258% ( 1900, 2900 ] 493 0.030% 100.288% ( 2900, 4400 ] 633 0.038% 100.326% ( 4400, 6600 ] 209 0.013% 100.339% ( 6600, 9900 ] 52 0.003% 100.342% ( 9900, 14000 ] 3 0.000% 100.342% ** Level 2 read latency histogram (micros): Count: 40583 Average: 2.3027 StdDev: 22.58 Min: 1 Median: 1.3646 Max: 3740 Percentiles: P50: 1.36 P75: 1.79 P99: 5.89 P99.9: 47.44 P99.99: 861.55 ------------------------------------------------------ [ 0, 1 ] 11577 28.527% 28.527% ###### ( 1, 2 ] 23904 58.902% 87.428% ############ ( 2, 3 ] 2972 7.323% 94.751% # ( 3, 4 ] 996 2.454% 97.206% ( 4, 6 ] 772 1.902% 99.108% ( 6, 10 ] 251 0.618% 99.726% ( 10, 15 ] 31 0.076% 99.803% ( 15, 22 ] 7 0.017% 99.820% ( 34, 51 ] 41 0.101% 99.921% ( 51, 76 ] 7 0.017% 99.938% ( 76, 110 ] 7 0.017% 99.956% ( 110, 170 ] 1 0.002% 99.958% ( 170, 250 ] 9 0.022% 99.980% ( 380, 580 ] 2 0.005% 99.985% ( 580, 870 ] 2 0.005% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 379987 Average: 9.5446 StdDev: 123.50 Min: 1 Median: 1.6880 Max: 8610 Percentiles: P50: 1.69 P75: 2.35 P99: 11.18 P99.9: 1721.73 P99.99: 4006.16 ------------------------------------------------------ [ 0, 1 ] 32208 8.476% 8.476% ## ( 1, 2 ] 229344 60.356% 68.832% ############ ( 2, 3 ] 66721 17.559% 86.391% #### ( 3, 4 ] 23453 6.172% 92.563% # ( 4, 6 ] 17902 4.711% 97.274% # ( 6, 10 ] 6381 1.679% 98.953% ( 10, 15 ] 754 0.198% 99.152% ( 15, 22 ] 176 0.046% 99.198% ( 22, 34 ] 66 0.017% 99.215% ( 34, 51 ] 14 0.004% 99.219% ( 51, 76 ] 50 0.013% 99.232% ( 76, 110 ] 185 0.049% 99.281% ( 110, 170 ] 404 0.106% 99.387% ( 170, 250 ] 262 0.069% 99.456% ( 250, 380 ] 307 0.081% 99.537% ( 380, 580 ] 444 0.117% 99.654% ( 580, 870 ] 455 0.120% 99.773% ( 870, 1300 ] 332 0.087% 99.861% ( 1300, 1900 ] 212 0.056% 99.917% ( 1900, 2900 ] 147 0.039% 99.955% ( 2900, 4400 ] 179 0.047% 100.002% ( 4400, 6600 ] 46 0.012% 100.014% ( 6600, 9900 ] 6 0.002% 100.016% ** Level 4 read latency histogram (micros): Count: 216240 Average: 12.3301 StdDev: 134.86 Min: 0 Median: 1.9407 Max: 8684 Percentiles: P50: 1.94 P75: 2.91 P99: 18.09 P99.9: 1435.75 P99.99: 2398.72 ------------------------------------------------------ [ 0, 1 ] 2889 1.336% 1.336% ( 1, 2 ] 111860 51.730% 53.066% ########## ( 2, 3 ] 51919 24.010% 77.075% ##### ( 3, 4 ] 21885 10.121% 87.196% ## ( 4, 6 ] 20335 9.404% 96.600% ## ( 6, 10 ] 4317 1.996% 98.596% ( 10, 15 ] 820 0.379% 98.976% ( 15, 22 ] 119 0.055% 99.031% ( 22, 34 ] 16 0.007% 99.038% ( 34, 51 ] 3 0.001% 99.039% ( 51, 76 ] 6 0.003% 99.042% ( 76, 110 ] 35 0.016% 99.058% ( 110, 170 ] 145 0.067% 99.126% ( 170, 250 ] 218 0.101% 99.226% ( 250, 380 ] 272 0.126% 99.352% ( 380, 580 ] 371 0.172% 99.524% ( 580, 870 ] 459 0.212% 99.736% ( 870, 1300 ] 312 0.144% 99.880% ( 1300, 1900 ] 189 0.087% 99.968% ( 1900, 2900 ] 97 0.045% 100.012% ( 2900, 4400 ] 115 0.053% 100.066% ( 4400, 6600 ] 18 0.008% 100.074% ( 6600, 9900 ] 5 0.002% 100.076% ** Level 5 read latency histogram (micros): Count: 300 Average: 1626.7733 StdDev: 1624.37 Min: 82 Median: 847.1053 Max: 9699 Percentiles: P50: 847.11 P75: 2866.67 P99: 6462.50 P99.9: 9405.00 P99.99: 9699.00 ------------------------------------------------------ ( 76, 110 ] 13 4.333% 4.333% # ( 110, 170 ] 12 4.000% 8.333% # ( 170, 250 ] 20 6.667% 15.000% # ( 250, 380 ] 37 12.333% 27.333% ## ( 380, 580 ] 33 11.000% 38.333% ## ( 580, 870 ] 38 12.667% 51.000% ### ( 870, 1300 ] 23 7.667% 58.667% ## ( 1300, 1900 ] 20 6.667% 65.333% # ( 1900, 2900 ] 30 10.000% 75.333% ## ( 2900, 4400 ] 56 18.667% 94.000% #### ( 4400, 6600 ] 16 5.333% 99.333% # ( 6600, 9900 ] 2 0.667% 100.000% ** DB Stats ** Uptime(secs): 55.2 total, 3.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 178.16 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:27.625 H:M:S, 50.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.52 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.624 H:M:S, 19.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 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.517 micros/op 181244 ops/sec 60.085 seconds 10889999 operations; 175.6 MB/s Microseconds per write: Count: 10889999 Average: 5.5174 StdDev: 441.79 Min: 0 Median: 1.7323 Max: 695741 Percentiles: P50: 1.73 P75: 2.73 P99: 9.16 P99.9: 1108.03 P99.99: 2737.82 ------------------------------------------------------ [ 0, 1 ] 1481633 13.605% 13.605% ### ( 1, 2 ] 5412409 49.701% 63.306% ########## ( 2, 3 ] 1738628 15.965% 79.272% ### ( 3, 4 ] 1480226 13.593% 92.864% ### ( 4, 6 ] 570202 5.236% 98.100% # ( 6, 10 ] 124089 1.139% 99.240% ( 10, 15 ] 42455 0.390% 99.629% ( 15, 22 ] 10695 0.098% 99.728% ( 22, 34 ] 1853 0.017% 99.745% ( 34, 51 ] 261 0.002% 99.747% ( 51, 76 ] 27 0.000% 99.747% ( 76, 110 ] 7524 0.069% 99.816% ( 110, 170 ] 2993 0.027% 99.844% ( 170, 250 ] 314 0.003% 99.847% ( 250, 380 ] 187 0.002% 99.848% ( 380, 580 ] 22 0.000% 99.849% ( 580, 870 ] 30 0.000% 99.849% ( 870, 1300 ] 10046 0.092% 99.941% ( 1300, 1900 ] 21 0.000% 99.941% ( 1900, 2900 ] 6320 0.058% 99.999% ( 2900, 4400 ] 30 0.000% 100.000% ( 4400, 6600 ] 3 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 177870 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 : 10889999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11238478968 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 : 577 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30178355 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 : 27403826689 rocksdb.compact.write.bytes COUNT : 27219139637 rocksdb.flush.write.bytes COUNT : 11229565941 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 : 68 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 : 360 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 : 11139212288 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4510720 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 : 27510326415 rocksdb.non.last.level.read.count COUNT : 6638689 rocksdb.block.checksum.compute.count COUNT : 6637603 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.381766 P95 : 3.897673 P99 : 7.630093 P100 : 695732.000000 COUNT : 10889999 SUM : 55049384 rocksdb.compaction.times.micros P50 : 1179393.939394 P95 : 4520000.000000 P99 : 23525345.000000 P100 : 23525345.000000 COUNT : 78 SUM : 132504109 rocksdb.compaction.times.cpu_micros P50 : 926111.111111 P95 : 4410000.000000 P99 : 15760000.000000 P100 : 20850996.000000 COUNT : 78 SUM : 107406813 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 : 681.325301 P95 : 1284.642857 P99 : 42068.000000 P100 : 42068.000000 COUNT : 150 SUM : 259221 rocksdb.compaction.outfile.sync.micros P50 : 1029.516129 P95 : 71634.615385 P99 : 116750.000000 P100 : 156026.000000 COUNT : 355 SUM : 3946540 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 : 104.333333 P95 : 1577.500000 P99 : 3961.666667 P100 : 4336.000000 COUNT : 263 SUM : 86301 rocksdb.table.open.io.micros P50 : 1327.835052 P95 : 9159.857143 P99 : 14306.666667 P100 : 20338.000000 COUNT : 577 SUM : 1313172 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.656919 P95 : 7.780568 P99 : 12.308461 P100 : 11431.000000 COUNT : 6635883 SUM : 45206296 rocksdb.read.block.get.micros P50 : 391.009174 P95 : 3744.642857 P99 : 5556.222222 P100 : 9836.000000 COUNT : 1154 SUM : 1028081 rocksdb.write.raw.block.micros P50 : 0.513212 P95 : 0.975102 P99 : 2.924503 P100 : 12260.000000 COUNT : 9311931 SUM : 19569852 rocksdb.numfiles.in.singlecompaction P50 : 3.364130 P95 : 7.000000 P99 : 31.900000 P100 : 35.000000 COUNT : 135 SUM : 590 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.568723 P95 : 1279.146070 P99 : 2688.317965 P100 : 695536.000000 COUNT : 136348 SUM : 30194663 rocksdb.sst.read.micros P50 : 1.567578 P95 : 4.539112 P99 : 8.920812 P100 : 10992.000000 COUNT : 6638809 SUM : 31537418 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 : 10889999 SUM : 11238478968 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 : 211165.048544 P95 : 376388.888889 P99 : 823750.000000 P100 : 897111.000000 COUNT : 150 SUM : 33022674 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 : 364 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