[2024-11-19 11:12:52.705627] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-19 11:12:52.705912] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid762221 ] Set seed to 1732011172698949 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 11:12:52.808251] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 11:12:52.846430] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 11:12:52.846477] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 762221' to capture a snapshot of events at runtime. [2024-11-19 11:12:52.846489] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid762221 for offline analysis/debug. [2024-11-19 11:12:52.846512] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 11:12:56 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-11:12:59 ... thread 0: (1000000,1000000) ops and (362183.0,362183.0) ops/second in (2.761035,2.761035) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/8 629.96 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 360.3 2.27 2.08 12 0.189 0 0 0.0 0.0 L1 1/1 62.99 MB 0.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L2 1/0 1.02 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 244.5 244.5 0.52 0.50 1 0.515 127K 38 0.0 0.0 L3 18/0 929.30 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.1 1.0 239.7 239.7 0.52 0.48 1 0.521 126K 0 0.0 0.0 L4 116/0 9.54 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 1044/0 85.82 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 1189/9 96.94 GB 0.0 0.2 0.2 0.1 1.0 1.0 0.4 1.3 75.8 323.3 3.31 3.06 14 0.236 254K 38 0.0 0.0 Int 0/0 0.00 KB 0.0 0.2 0.2 0.1 1.0 1.0 0.4 1.3 75.8 323.3 3.31 3.06 14 0.236 254K 38 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.2 0.2 0.1 0.2 0.2 0.0 0.0 242.1 242.1 1.04 0.98 2 0.518 254K 38 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 360.3 2.27 2.08 12 0.189 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.04 GB write, 360.61 MB/s write, 0.25 GB read, 84.58 MB/s read, 3.3 seconds Interval compaction: 1.04 GB write, 387.22 MB/s write, 0.25 GB read, 90.82 MB/s read, 3.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 122246 Average: 1.8423 StdDev: 8.52 Min: 1 Median: 1.2388 Max: 1851 Percentiles: P50: 1.24 P75: 1.68 P99: 4.44 P99.9: 9.45 P99.99: 21.39 ------------------------------------------------------ [ 0, 1 ] 44501 36.403% 36.403% ####### ( 1, 2 ] 69608 56.941% 93.344% ########### ( 2, 3 ] 4567 3.736% 97.080% # ( 3, 4 ] 2116 1.731% 98.811% ( 4, 6 ] 1050 0.859% 99.670% ( 6, 10 ] 329 0.269% 99.939% ( 10, 15 ] 52 0.043% 99.981% ( 15, 22 ] 14 0.011% 99.993% ( 22, 34 ] 1 0.001% 99.993% ( 34, 51 ] 2 0.002% 99.995% ( 51, 76 ] 2 0.002% 99.997% ( 110, 170 ] 10 0.008% 100.005% ( 250, 380 ] 6 0.005% 100.010% ( 380, 580 ] 5 0.004% 100.014% ( 870, 1300 ] 1 0.001% 100.015% ( 1300, 1900 ] 2 0.002% 100.016% ** Level 2 read latency histogram (micros): Count: 31735 Average: 2.0792 StdDev: 26.11 Min: 1 Median: 1.1869 Max: 3173 Percentiles: P50: 1.19 P75: 1.63 P99: 3.30 P99.9: 9.66 P99.99: 1262.70 ------------------------------------------------------ [ 0, 1 ] 12501 39.392% 39.392% ######## ( 1, 2 ] 18014 56.764% 96.156% ########### ( 2, 3 ] 835 2.631% 98.787% # ( 3, 4 ] 223 0.703% 99.490% ( 4, 6 ] 90 0.284% 99.773% ( 6, 10 ] 44 0.139% 99.912% ( 10, 15 ] 12 0.038% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 250, 380 ] 3 0.009% 99.972% ( 380, 580 ] 1 0.003% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 80 Average: 721.3375 StdDev: 985.18 Min: 0 Median: 282.5000 Max: 3724 Percentiles: P50: 282.50 P75: 870.00 P99: 3724.00 P99.9: 3724.00 P99.99: 3724.00 ------------------------------------------------------ [ 0, 1 ] 23 28.750% 28.750% ###### ( 1, 2 ] 9 11.250% 40.000% ## ( 2, 3 ] 3 3.750% 43.750% # ( 4, 6 ] 2 2.500% 46.250% # ( 6, 10 ] 1 1.250% 47.500% ( 76, 110 ] 1 1.250% 48.750% ( 250, 380 ] 4 5.000% 53.750% # ( 380, 580 ] 6 7.500% 61.250% ## ( 580, 870 ] 11 13.750% 75.000% ### ( 870, 1300 ] 1 1.250% 76.250% ( 1300, 1900 ] 5 6.250% 82.500% # ( 1900, 2900 ] 12 15.000% 97.500% ### ( 2900, 4400 ] 2 2.500% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 1622.4000 StdDev: 923.71 Min: 270 Median: 1600.0000 Max: 4424 Percentiles: P50: 1600.00 P75: 2400.00 P99: 4424.00 P99.9: 4424.00 P99.99: 4424.00 ------------------------------------------------------ ( 250, 380 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 7 23.333% 30.000% ##### ( 870, 1300 ] 3 10.000% 40.000% ## ( 1300, 1900 ] 6 20.000% 60.000% #### ( 1900, 2900 ] 9 30.000% 90.000% ###### ( 2900, 4400 ] 2 6.667% 96.667% # ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 331.71 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.178 H:M:S, 6.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 356.14 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.178 H:M:S, 6.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-11:13:02 ... thread 0: (1000000,2000000) ops and (334454.2,347766.8) ops/second in (2.989946,5.750981) 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/4 1.35 GB 107.0 0.9 0.0 0.9 2.6 1.8 0.0 1.5 106.3 326.3 8.30 7.76 29 0.286 895K 1039 0.0 0.0 L1 1/0 2.62 MB 0.3 0.3 0.2 0.1 0.3 0.2 0.2 1.2 256.3 256.0 1.23 1.20 1 1.229 319K 400 0.0 0.0 L2 2/0 55.39 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.4 2.0 244.5 244.5 0.52 0.50 1 0.515 127K 38 0.0 0.0 L3 47/0 995.08 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 196.8 196.7 2.51 2.14 2 1.257 502K 305 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1248/4 97.92 GB 0.0 1.8 0.7 1.1 3.6 2.5 0.8 2.0 144.8 290.1 12.56 11.60 33 0.380 1845K 1782 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.7 1.1 3.6 2.5 0.8 2.0 144.8 290.1 12.56 11.60 33 0.380 1845K 1782 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 0.7 1.1 1.8 0.7 0.0 0.0 240.9 240.7 7.55 7.06 7 1.078 1845K 1782 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 364.6 5.01 4.53 26 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.56 GB write, 611.52 MB/s write, 1.78 GB read, 305.14 MB/s read, 12.6 seconds Interval compaction: 3.56 GB write, 633.20 MB/s write, 1.78 GB read, 315.96 MB/s read, 12.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 381383 Average: 1.9608 StdDev: 7.02 Min: 1 Median: 1.3424 Max: 1851 Percentiles: P50: 1.34 P75: 1.76 P99: 5.28 P99.9: 9.57 P99.99: 18.84 ------------------------------------------------------ [ 0, 1 ] 111829 29.322% 29.322% ###### ( 1, 2 ] 230300 60.385% 89.707% ############ ( 2, 3 ] 21562 5.654% 95.361% # ( 3, 4 ] 10020 2.627% 97.988% # ( 4, 6 ] 6025 1.580% 99.568% ( 6, 10 ] 1422 0.373% 99.941% ( 10, 15 ] 168 0.044% 99.985% ( 15, 22 ] 38 0.010% 99.995% ( 22, 34 ] 10 0.003% 99.998% ( 34, 51 ] 4 0.001% 99.999% ( 51, 76 ] 7 0.002% 100.001% ( 76, 110 ] 1 0.000% 100.001% ( 110, 170 ] 20 0.005% 100.006% ( 170, 250 ] 2 0.001% 100.007% ( 250, 380 ] 11 0.003% 100.009% ( 380, 580 ] 16 0.004% 100.014% ( 580, 870 ] 2 0.001% 100.014% ( 870, 1300 ] 4 0.001% 100.015% ( 1300, 1900 ] 3 0.001% 100.016% ** Level 1 read latency histogram (micros): Count: 65398 Average: 2.2626 StdDev: 5.53 Min: 1 Median: 1.5473 Max: 923 Percentiles: P50: 1.55 P75: 1.92 P99: 5.78 P99.9: 12.07 P99.99: 32.38 ------------------------------------------------------ [ 0, 1 ] 8832 13.505% 13.505% ### ( 1, 2 ] 43612 66.687% 80.192% ############# ( 2, 3 ] 7555 11.552% 91.744% ## ( 3, 4 ] 2789 4.265% 96.009% # ( 4, 6 ] 2192 3.352% 99.361% # ( 6, 10 ] 319 0.488% 99.849% ( 10, 15 ] 81 0.124% 99.972% ( 15, 22 ] 8 0.012% 99.985% ( 22, 34 ] 4 0.006% 99.991% ( 110, 170 ] 1 0.002% 99.992% ( 250, 380 ] 3 0.005% 99.997% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31735 Average: 2.0792 StdDev: 26.11 Min: 1 Median: 1.1869 Max: 3173 Percentiles: P50: 1.19 P75: 1.63 P99: 3.30 P99.9: 9.66 P99.99: 1262.70 ------------------------------------------------------ [ 0, 1 ] 12501 39.392% 39.392% ######## ( 1, 2 ] 18014 56.764% 96.156% ########### ( 2, 3 ] 835 2.631% 98.787% # ( 3, 4 ] 223 0.703% 99.490% ( 4, 6 ] 90 0.284% 99.773% ( 6, 10 ] 44 0.139% 99.912% ( 10, 15 ] 12 0.038% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 250, 380 ] 3 0.009% 99.972% ( 380, 580 ] 1 0.003% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28872 Average: 4.2731 StdDev: 64.30 Min: 0 Median: 1.5351 Max: 3724 Percentiles: P50: 1.54 P75: 1.92 P99: 5.98 P99.9: 636.10 P99.99: 2826.07 ------------------------------------------------------ [ 0, 1 ] 4293 14.869% 14.869% ### ( 1, 2 ] 18954 65.648% 80.517% ############# ( 2, 3 ] 3242 11.229% 91.746% ## ( 3, 4 ] 1220 4.226% 95.972% # ( 4, 6 ] 884 3.062% 99.034% # ( 6, 10 ] 155 0.537% 99.571% ( 10, 15 ] 26 0.090% 99.661% ( 15, 22 ] 27 0.094% 99.754% ( 22, 34 ] 20 0.069% 99.823% ( 34, 51 ] 2 0.007% 99.830% ( 76, 110 ] 1 0.003% 99.834% ( 110, 170 ] 1 0.003% 99.837% ( 170, 250 ] 4 0.014% 99.851% ( 250, 380 ] 5 0.017% 99.868% ( 380, 580 ] 7 0.024% 99.893% ( 580, 870 ] 11 0.038% 99.931% ( 870, 1300 ] 1 0.003% 99.934% ( 1300, 1900 ] 5 0.017% 99.952% ( 1900, 2900 ] 12 0.042% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 1622.4000 StdDev: 923.71 Min: 270 Median: 1600.0000 Max: 4424 Percentiles: P50: 1600.00 P75: 2400.00 P99: 4424.00 P99.9: 4424.00 P99.99: 4424.00 ------------------------------------------------------ ( 250, 380 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 7 23.333% 30.000% ##### ( 870, 1300 ] 3 10.000% 40.000% ## ( 1300, 1900 ] 6 20.000% 60.000% #### ( 1900, 2900 ] 9 30.000% 90.000% ###### ( 2900, 4400 ] 2 6.667% 96.667% # ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 330.43 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.559 H:M:S, 9.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.16 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.382 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-11:13:05 ... thread 0: (1000000,3000000) ops and (337565.0,344298.4) ops/second in (2.962392,8.713373) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/4 2.34 GB 207.7 2.0 0.0 2.0 4.7 2.8 0.0 1.7 132.3 318.2 15.24 14.33 47 0.324 2046K 2207 0.0 0.0 L1 1/0 2.62 MB 0.3 0.3 0.2 0.1 0.3 0.2 0.2 1.2 256.3 256.0 1.23 1.20 1 1.229 319K 400 0.0 0.0 L2 2/0 55.39 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.4 2.0 244.5 244.5 0.52 0.50 1 0.515 127K 38 0.0 0.0 L3 47/0 995.08 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 196.8 196.7 2.51 2.14 2 1.257 502K 305 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1250/4 98.90 GB 0.0 2.9 0.7 2.2 5.6 3.4 0.8 2.0 151.4 296.7 19.49 18.17 51 0.382 2996K 2950 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 0.7 2.2 5.6 3.4 0.8 2.0 151.4 296.7 19.49 18.17 51 0.382 2996K 2950 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 2.9 0.7 2.2 2.9 0.7 0.0 0.0 251.6 251.3 11.73 11.16 11 1.067 2996K 2950 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 365.2 7.76 7.01 40 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.7 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.65 GB write, 648.41 MB/s write, 2.88 GB read, 330.93 MB/s read, 19.5 seconds Interval compaction: 5.65 GB write, 663.59 MB/s write, 2.88 GB read, 338.67 MB/s read, 19.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 644921 Average: 1.9406 StdDev: 8.53 Min: 1 Median: 1.3262 Max: 3070 Percentiles: P50: 1.33 P75: 1.74 P99: 5.17 P99.9: 9.51 P99.99: 17.64 ------------------------------------------------------ [ 0, 1 ] 195506 30.315% 30.315% ###### ( 1, 2 ] 389236 60.354% 90.669% ############ ( 2, 3 ] 33683 5.223% 95.892% # ( 3, 4 ] 14802 2.295% 98.187% ( 4, 6 ] 8956 1.389% 99.575% ( 6, 10 ] 2389 0.370% 99.946% ( 10, 15 ] 264 0.041% 99.987% ( 15, 22 ] 57 0.009% 99.996% ( 22, 34 ] 17 0.003% 99.998% ( 34, 51 ] 6 0.001% 99.999% ( 51, 76 ] 11 0.002% 100.001% ( 76, 110 ] 1 0.000% 100.001% ( 110, 170 ] 27 0.004% 100.005% ( 170, 250 ] 6 0.001% 100.006% ( 250, 380 ] 17 0.003% 100.009% ( 380, 580 ] 23 0.004% 100.012% ( 580, 870 ] 7 0.001% 100.013% ( 870, 1300 ] 10 0.002% 100.015% ( 1300, 1900 ] 3 0.000% 100.016% ( 2900, 4400 ] 2 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 65398 Average: 2.2626 StdDev: 5.53 Min: 1 Median: 1.5473 Max: 923 Percentiles: P50: 1.55 P75: 1.92 P99: 5.78 P99.9: 12.07 P99.99: 32.38 ------------------------------------------------------ [ 0, 1 ] 8832 13.505% 13.505% ### ( 1, 2 ] 43612 66.687% 80.192% ############# ( 2, 3 ] 7555 11.552% 91.744% ## ( 3, 4 ] 2789 4.265% 96.009% # ( 4, 6 ] 2192 3.352% 99.361% # ( 6, 10 ] 319 0.488% 99.849% ( 10, 15 ] 81 0.124% 99.972% ( 15, 22 ] 8 0.012% 99.985% ( 22, 34 ] 4 0.006% 99.991% ( 110, 170 ] 1 0.002% 99.992% ( 250, 380 ] 3 0.005% 99.997% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31735 Average: 2.0792 StdDev: 26.11 Min: 1 Median: 1.1869 Max: 3173 Percentiles: P50: 1.19 P75: 1.63 P99: 3.30 P99.9: 9.66 P99.99: 1262.70 ------------------------------------------------------ [ 0, 1 ] 12501 39.392% 39.392% ######## ( 1, 2 ] 18014 56.764% 96.156% ########### ( 2, 3 ] 835 2.631% 98.787% # ( 3, 4 ] 223 0.703% 99.490% ( 4, 6 ] 90 0.284% 99.773% ( 6, 10 ] 44 0.139% 99.912% ( 10, 15 ] 12 0.038% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 250, 380 ] 3 0.009% 99.972% ( 380, 580 ] 1 0.003% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28872 Average: 4.2731 StdDev: 64.30 Min: 0 Median: 1.5351 Max: 3724 Percentiles: P50: 1.54 P75: 1.92 P99: 5.98 P99.9: 636.10 P99.99: 2826.07 ------------------------------------------------------ [ 0, 1 ] 4293 14.869% 14.869% ### ( 1, 2 ] 18954 65.648% 80.517% ############# ( 2, 3 ] 3242 11.229% 91.746% ## ( 3, 4 ] 1220 4.226% 95.972% # ( 4, 6 ] 884 3.062% 99.034% # ( 6, 10 ] 155 0.537% 99.571% ( 10, 15 ] 26 0.090% 99.661% ( 15, 22 ] 27 0.094% 99.754% ( 22, 34 ] 20 0.069% 99.823% ( 34, 51 ] 2 0.007% 99.830% ( 76, 110 ] 1 0.003% 99.834% ( 110, 170 ] 1 0.003% 99.837% ( 170, 250 ] 4 0.014% 99.851% ( 250, 380 ] 5 0.017% 99.868% ( 380, 580 ] 7 0.024% 99.893% ( 580, 870 ] 11 0.038% 99.931% ( 870, 1300 ] 1 0.003% 99.934% ( 1300, 1900 ] 5 0.017% 99.952% ( 1900, 2900 ] 12 0.042% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 1622.4000 StdDev: 923.71 Min: 270 Median: 1600.0000 Max: 4424 Percentiles: P50: 1600.00 P75: 2400.00 P99: 4424.00 P99.9: 4424.00 P99.99: 4424.00 ------------------------------------------------------ ( 250, 380 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 7 23.333% 30.000% ##### ( 870, 1300 ] 3 10.000% 40.000% ## ( 1300, 1900 ] 6 20.000% 60.000% #### ( 1900, 2900 ] 9 30.000% 90.000% ###### ( 2900, 4400 ] 2 6.667% 96.667% # ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 331.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:0.931 H:M:S, 10.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.24 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.372 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-11:13:08 ... thread 0: (1000000,4000000) ops and (364467.6,349128.5) ops/second in (2.743728,11.457101) 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 17/4 3.26 GB 302.1 2.8 0.0 2.8 6.5 3.7 0.0 1.7 136.3 317.9 20.80 19.58 64 0.325 2878K 3092 0.0 0.0 L1 1/0 2.62 MB 0.3 0.3 0.2 0.1 0.3 0.2 0.2 1.2 256.3 256.0 1.23 1.20 1 1.229 319K 400 0.0 0.0 L2 2/0 55.39 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.4 2.0 244.5 244.5 0.52 0.50 1 0.515 127K 38 0.0 0.0 L3 47/0 995.08 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 196.8 196.7 2.51 2.14 2 1.257 502K 305 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1255/4 99.82 GB 0.0 3.7 0.7 3.0 7.4 4.4 0.8 2.0 150.5 301.2 25.06 23.42 68 0.368 3828K 3835 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 0.7 3.0 7.4 4.4 0.8 2.0 150.5 301.2 25.06 23.42 68 0.368 3828K 3835 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.7 0.7 3.0 3.7 0.7 0.0 0.0 255.4 255.1 14.76 14.13 14 1.054 3828K 3835 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 367.2 10.29 9.29 54 0.191 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): 11.7 total, 11.5 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: 7.37 GB write, 647.04 MB/s write, 3.68 GB read, 323.30 MB/s read, 25.1 seconds Interval compaction: 7.37 GB write, 658.55 MB/s write, 3.68 GB read, 329.05 MB/s read, 25.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: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 878895 Average: 1.9216 StdDev: 8.50 Min: 0 Median: 1.3180 Max: 3222 Percentiles: P50: 1.32 P75: 1.73 P99: 5.02 P99.9: 9.46 P99.99: 17.10 ------------------------------------------------------ [ 0, 1 ] 270321 30.757% 30.757% ###### ( 1, 2 ] 531816 60.510% 91.267% ############ ( 2, 3 ] 43405 4.939% 96.205% # ( 3, 4 ] 18978 2.159% 98.364% ( 4, 6 ] 10972 1.248% 99.613% ( 6, 10 ] 2922 0.332% 99.945% ( 10, 15 ] 370 0.042% 99.987% ( 15, 22 ] 77 0.009% 99.996% ( 22, 34 ] 19 0.002% 99.998% ( 34, 51 ] 8 0.001% 99.999% ( 51, 76 ] 12 0.001% 100.001% ( 76, 110 ] 1 0.000% 100.001% ( 110, 170 ] 35 0.004% 100.005% ( 170, 250 ] 11 0.001% 100.006% ( 250, 380 ] 22 0.003% 100.008% ( 380, 580 ] 32 0.004% 100.012% ( 580, 870 ] 11 0.001% 100.013% ( 870, 1300 ] 12 0.001% 100.015% ( 1300, 1900 ] 3 0.000% 100.015% ( 2900, 4400 ] 3 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 65398 Average: 2.2626 StdDev: 5.53 Min: 1 Median: 1.5473 Max: 923 Percentiles: P50: 1.55 P75: 1.92 P99: 5.78 P99.9: 12.07 P99.99: 32.38 ------------------------------------------------------ [ 0, 1 ] 8832 13.505% 13.505% ### ( 1, 2 ] 43612 66.687% 80.192% ############# ( 2, 3 ] 7555 11.552% 91.744% ## ( 3, 4 ] 2789 4.265% 96.009% # ( 4, 6 ] 2192 3.352% 99.361% # ( 6, 10 ] 319 0.488% 99.849% ( 10, 15 ] 81 0.124% 99.972% ( 15, 22 ] 8 0.012% 99.985% ( 22, 34 ] 4 0.006% 99.991% ( 110, 170 ] 1 0.002% 99.992% ( 250, 380 ] 3 0.005% 99.997% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31735 Average: 2.0792 StdDev: 26.11 Min: 1 Median: 1.1869 Max: 3173 Percentiles: P50: 1.19 P75: 1.63 P99: 3.30 P99.9: 9.66 P99.99: 1262.70 ------------------------------------------------------ [ 0, 1 ] 12501 39.392% 39.392% ######## ( 1, 2 ] 18014 56.764% 96.156% ########### ( 2, 3 ] 835 2.631% 98.787% # ( 3, 4 ] 223 0.703% 99.490% ( 4, 6 ] 90 0.284% 99.773% ( 6, 10 ] 44 0.139% 99.912% ( 10, 15 ] 12 0.038% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 250, 380 ] 3 0.009% 99.972% ( 380, 580 ] 1 0.003% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28872 Average: 4.2731 StdDev: 64.30 Min: 0 Median: 1.5351 Max: 3724 Percentiles: P50: 1.54 P75: 1.92 P99: 5.98 P99.9: 636.10 P99.99: 2826.07 ------------------------------------------------------ [ 0, 1 ] 4293 14.869% 14.869% ### ( 1, 2 ] 18954 65.648% 80.517% ############# ( 2, 3 ] 3242 11.229% 91.746% ## ( 3, 4 ] 1220 4.226% 95.972% # ( 4, 6 ] 884 3.062% 99.034% # ( 6, 10 ] 155 0.537% 99.571% ( 10, 15 ] 26 0.090% 99.661% ( 15, 22 ] 27 0.094% 99.754% ( 22, 34 ] 20 0.069% 99.823% ( 34, 51 ] 2 0.007% 99.830% ( 76, 110 ] 1 0.003% 99.834% ( 110, 170 ] 1 0.003% 99.837% ( 170, 250 ] 4 0.014% 99.851% ( 250, 380 ] 5 0.017% 99.868% ( 380, 580 ] 7 0.024% 99.893% ( 580, 870 ] 11 0.038% 99.931% ( 870, 1300 ] 1 0.003% 99.934% ( 1300, 1900 ] 5 0.017% 99.952% ( 1900, 2900 ] 12 0.042% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 1622.4000 StdDev: 923.71 Min: 270 Median: 1600.0000 Max: 4424 Percentiles: P50: 1600.00 P75: 2400.00 P99: 4424.00 P99.9: 4424.00 P99.99: 4424.00 ------------------------------------------------------ ( 250, 380 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 7 23.333% 30.000% ##### ( 870, 1300 ] 3 10.000% 40.000% ## ( 1300, 1900 ] 6 20.000% 60.000% #### ( 1900, 2900 ] 9 30.000% 90.000% ###### ( 2900, 4400 ] 2 6.667% 96.667% # ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 11.7 total, 2.7 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 337.54 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.099 H:M:S, 9.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 358.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:0.168 H:M:S, 6.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-11:13:12 ... thread 0: (1000000,5000000) ops and (229125.0,316025.1) ops/second in (4.364429,15.821530) 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/17 4.30 GB 25.2 4.1 0.0 4.1 8.9 4.7 0.0 1.9 146.8 315.4 28.75 27.16 85 0.338 4285K 4547 0.0 0.0 L1 1/1 2.62 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.2 1.2 256.3 256.0 1.23 1.20 1 1.229 319K 400 0.0 0.0 L2 2/0 55.39 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.4 2.0 244.5 244.5 0.52 0.50 1 0.515 127K 38 0.0 0.0 L3 47/0 995.08 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 196.8 196.7 2.51 2.14 2 1.257 502K 305 0.0 0.0 L4 144/0 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1256/18 100.87 GB 0.0 5.0 0.7 4.4 9.8 5.4 0.8 2.1 156.2 303.0 33.00 31.00 89 0.371 5235K 5290 0.0 0.0 Int 0/0 0.00 KB 0.0 5.0 0.7 4.4 9.8 5.4 0.8 2.1 156.2 303.0 33.00 31.00 89 0.371 5235K 5290 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.0 0.7 4.4 5.0 0.7 0.0 0.0 260.2 259.9 19.82 19.12 19 1.043 5235K 5290 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 367.9 13.18 11.89 70 0.188 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 16.0 total, 15.8 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.77 GB write, 624.04 MB/s write, 5.04 GB read, 321.73 MB/s read, 33.0 seconds Interval compaction: 9.77 GB write, 632.08 MB/s write, 5.04 GB read, 325.88 MB/s read, 33.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, 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: 5, total-stops: 14, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1283117 Average: 1.9602 StdDev: 8.26 Min: 0 Median: 1.3313 Max: 3222 Percentiles: P50: 1.33 P75: 1.74 P99: 5.04 P99.9: 9.72 P99.99: 111.97 ------------------------------------------------------ [ 0, 1 ] 380301 29.639% 29.639% ###### ( 1, 2 ] 788499 61.452% 91.091% ############ ( 2, 3 ] 65604 5.113% 96.204% # ( 3, 4 ] 27774 2.165% 98.368% ( 4, 6 ] 15579 1.214% 99.582% ( 6, 10 ] 4382 0.342% 99.924% ( 10, 15 ] 584 0.046% 99.969% ( 15, 22 ] 106 0.008% 99.978% ( 22, 34 ] 23 0.002% 99.979% ( 34, 51 ] 10 0.001% 99.980% ( 51, 76 ] 78 0.006% 99.986% ( 76, 110 ] 44 0.003% 99.990% ( 110, 170 ] 143 0.011% 100.001% ( 170, 250 ] 76 0.006% 100.007% ( 250, 380 ] 46 0.004% 100.010% ( 380, 580 ] 49 0.004% 100.014% ( 580, 870 ] 20 0.002% 100.016% ( 870, 1300 ] 15 0.001% 100.017% ( 1300, 1900 ] 3 0.000% 100.017% ( 1900, 2900 ] 1 0.000% 100.017% ( 2900, 4400 ] 3 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 65399 Average: 2.2652 StdDev: 5.57 Min: 1 Median: 1.5473 Max: 923 Percentiles: P50: 1.55 P75: 1.92 P99: 5.79 P99.9: 12.14 P99.99: 123.80 ------------------------------------------------------ [ 0, 1 ] 8832 13.505% 13.505% ### ( 1, 2 ] 43612 66.686% 80.191% ############# ( 2, 3 ] 7555 11.552% 91.743% ## ( 3, 4 ] 2789 4.265% 96.008% # ( 4, 6 ] 2192 3.352% 99.359% # ( 6, 10 ] 319 0.488% 99.847% ( 10, 15 ] 81 0.124% 99.971% ( 15, 22 ] 8 0.012% 99.983% ( 22, 34 ] 4 0.006% 99.989% ( 110, 170 ] 2 0.003% 99.992% ( 250, 380 ] 3 0.005% 99.997% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31735 Average: 2.0792 StdDev: 26.11 Min: 1 Median: 1.1869 Max: 3173 Percentiles: P50: 1.19 P75: 1.63 P99: 3.30 P99.9: 9.66 P99.99: 1262.70 ------------------------------------------------------ [ 0, 1 ] 12501 39.392% 39.392% ######## ( 1, 2 ] 18014 56.764% 96.156% ########### ( 2, 3 ] 835 2.631% 98.787% # ( 3, 4 ] 223 0.703% 99.490% ( 4, 6 ] 90 0.284% 99.773% ( 6, 10 ] 44 0.139% 99.912% ( 10, 15 ] 12 0.038% 99.950% ( 15, 22 ] 2 0.006% 99.956% ( 51, 76 ] 2 0.006% 99.962% ( 250, 380 ] 3 0.009% 99.972% ( 380, 580 ] 1 0.003% 99.975% ( 580, 870 ] 3 0.009% 99.984% ( 870, 1300 ] 2 0.006% 99.991% ( 1300, 1900 ] 1 0.003% 99.994% ( 1900, 2900 ] 1 0.003% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28872 Average: 4.2731 StdDev: 64.30 Min: 0 Median: 1.5351 Max: 3724 Percentiles: P50: 1.54 P75: 1.92 P99: 5.98 P99.9: 636.10 P99.99: 2826.07 ------------------------------------------------------ [ 0, 1 ] 4293 14.869% 14.869% ### ( 1, 2 ] 18954 65.648% 80.517% ############# ( 2, 3 ] 3242 11.229% 91.746% ## ( 3, 4 ] 1220 4.226% 95.972% # ( 4, 6 ] 884 3.062% 99.034% # ( 6, 10 ] 155 0.537% 99.571% ( 10, 15 ] 26 0.090% 99.661% ( 15, 22 ] 27 0.094% 99.754% ( 22, 34 ] 20 0.069% 99.823% ( 34, 51 ] 2 0.007% 99.830% ( 76, 110 ] 1 0.003% 99.834% ( 110, 170 ] 1 0.003% 99.837% ( 170, 250 ] 4 0.014% 99.851% ( 250, 380 ] 5 0.017% 99.868% ( 380, 580 ] 7 0.024% 99.893% ( 580, 870 ] 11 0.038% 99.931% ( 870, 1300 ] 1 0.003% 99.934% ( 1300, 1900 ] 5 0.017% 99.952% ( 1900, 2900 ] 12 0.042% 99.993% ( 2900, 4400 ] 2 0.007% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 1622.4000 StdDev: 923.71 Min: 270 Median: 1600.0000 Max: 4424 Percentiles: P50: 1600.00 P75: 2400.00 P99: 4424.00 P99.9: 4424.00 P99.99: 4424.00 ------------------------------------------------------ ( 250, 380 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 7 23.333% 30.000% ##### ( 870, 1300 ] 3 10.000% 40.000% ## ( 1300, 1900 ] 6 20.000% 60.000% #### ( 1900, 2900 ] 9 30.000% 90.000% ###### ( 2900, 4400 ] 2 6.667% 96.667% # ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 16.0 total, 4.4 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 307.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:2.859 H:M:S, 17.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 225.51 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.760 H:M:S, 40.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/19-11:13:33 ... thread 0: (1000000,6000000) ops and (47855.5,163408.6) ops/second in (20.896248,36.717778) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/4 1.11 GB 81.8 4.7 0.0 4.7 10.3 5.6 0.0 1.8 133.8 293.8 35.79 31.69 99 0.362 4861K 5148 0.0 0.0 L1 6/6 709.58 MB 0.0 4.4 4.3 0.1 4.3 4.2 0.2 1.0 224.3 220.1 19.93 18.50 2 9.967 4539K 82K 0.0 0.0 L2 1/1 54.37 MB 0.0 0.2 0.1 0.1 0.2 0.1 3.6 1.6 202.3 202.2 0.80 0.68 2 0.402 128K 38 0.0 0.0 L3 18/2 1.23 GB 1.0 2.3 1.9 0.4 2.3 1.9 1.9 1.2 153.2 152.9 15.19 10.61 14 1.085 1991K 866 0.0 0.0 L4 167/7 9.79 GB 1.0 1.7 1.5 0.2 1.7 1.5 1.7 1.1 124.1 123.8 14.36 8.22 17 0.845 1789K 4484 0.0 0.0 L5 1080/0 88.77 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1279/20 101.64 GB 0.0 13.2 7.8 5.4 18.7 13.3 10.4 3.3 157.2 222.6 86.08 69.70 134 0.642 13M 93K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.2 7.8 5.4 18.7 13.3 10.4 3.3 157.2 222.6 86.08 69.70 134 0.642 13M 93K 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 13.2 7.8 5.4 13.1 7.7 0.0 0.0 197.7 196.2 68.44 55.47 52 1.316 13M 93K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 325.1 17.63 14.23 82 0.215 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): 36.9 total, 36.7 interval Flush(GB): cumulative 5.598, interval 5.598 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: 18.71 GB write, 519.02 MB/s write, 13.21 GB read, 366.43 MB/s read, 86.1 seconds Interval compaction: 18.71 GB write, 521.91 MB/s write, 13.21 GB read, 368.46 MB/s read, 86.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 40, interval: 51 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2390056 Average: 2.5536 StdDev: 21.07 Min: 0 Median: 1.3295 Max: 10531 Percentiles: P50: 1.33 P75: 1.74 P99: 6.78 P99.9: 169.60 P99.99: 346.58 ------------------------------------------------------ [ 0, 1 ] 715314 29.929% 29.929% ###### ( 1, 2 ] 1455935 60.916% 90.845% ############ ( 2, 3 ] 106521 4.457% 95.302% # ( 3, 4 ] 51913 2.172% 97.474% ( 4, 6 ] 33682 1.409% 98.883% ( 6, 10 ] 14383 0.602% 99.485% ( 10, 15 ] 1651 0.069% 99.554% ( 15, 22 ] 489 0.020% 99.575% ( 22, 34 ] 40 0.002% 99.576% ( 34, 51 ] 33 0.001% 99.578% ( 51, 76 ] 3450 0.144% 99.722% ( 76, 110 ] 973 0.041% 99.763% ( 110, 170 ] 3304 0.138% 99.901% ( 170, 250 ] 1762 0.074% 99.975% ( 250, 380 ] 494 0.021% 99.995% ( 380, 580 ] 216 0.009% 100.004% ( 580, 870 ] 73 0.003% 100.007% ( 870, 1300 ] 38 0.002% 100.009% ( 1300, 1900 ] 10 0.000% 100.009% ( 1900, 2900 ] 18 0.001% 100.010% ( 2900, 4400 ] 20 0.001% 100.011% ( 4400, 6600 ] 6 0.000% 100.011% ( 6600, 9900 ] 1 0.000% 100.011% ( 9900, 14000 ] 1 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 861377 Average: 6.7024 StdDev: 125.19 Min: 1 Median: 1.9010 Max: 18639 Percentiles: P50: 1.90 P75: 3.09 P99: 8.67 P99.9: 13.23 P99.99: 14.35 ------------------------------------------------------ [ 0, 1 ] 32658 3.791% 3.791% # ( 1, 2 ] 441773 51.287% 55.078% ########## ( 2, 3 ] 162553 18.871% 73.950% #### ( 3, 4 ] 102774 11.931% 85.881% ## ( 4, 6 ] 101969 11.838% 97.719% ## ( 6, 10 ] 16556 1.922% 99.641% ( 10, 15 ] 3462 0.402% 100.043% ( 15, 22 ] 374 0.043% 100.086% ( 22, 34 ] 43 0.005% 100.091% ( 34, 51 ] 34 0.004% 100.095% ( 51, 76 ] 37 0.004% 100.099% ( 76, 110 ] 11 0.001% 100.101% ( 110, 170 ] 62 0.007% 100.108% ( 170, 250 ] 73 0.008% 100.116% ( 250, 380 ] 137 0.016% 100.132% ( 380, 580 ] 219 0.025% 100.158% ( 580, 870 ] 230 0.027% 100.184% ( 870, 1300 ] 147 0.017% 100.201% ( 1300, 1900 ] 127 0.015% 100.216% ( 1900, 2900 ] 187 0.022% 100.238% ( 2900, 4400 ] 310 0.036% 100.274% ( 4400, 6600 ] 96 0.011% 100.285% ( 6600, 9900 ] 52 0.006% 100.291% ( 9900, 14000 ] 6 0.001% 100.292% ( 14000, 22000 ] 5 0.001% 100.292% ** Level 2 read latency histogram (micros): Count: 31999 Average: 4.7085 StdDev: 96.06 Min: 1 Median: 1.1929 Max: 8332 Percentiles: P50: 1.19 P75: 1.63 P99: 3.73 P99.9: 749.19 P99.99: 4370.01 ------------------------------------------------------ [ 0, 1 ] 12504 39.076% 39.076% ######## ( 1, 2 ] 18120 56.627% 95.703% ########### ( 2, 3 ] 876 2.738% 98.441% # ( 3, 4 ] 246 0.769% 99.209% ( 4, 6 ] 108 0.338% 99.547% ( 6, 10 ] 49 0.153% 99.700% ( 10, 15 ] 14 0.044% 99.744% ( 15, 22 ] 2 0.006% 99.750% ( 51, 76 ] 2 0.006% 99.756% ( 76, 110 ] 2 0.006% 99.762% ( 110, 170 ] 2 0.006% 99.769% ( 170, 250 ] 10 0.031% 99.800% ( 250, 380 ] 13 0.041% 99.841% ( 380, 580 ] 12 0.038% 99.878% ( 580, 870 ] 12 0.038% 99.916% ( 870, 1300 ] 6 0.019% 99.934% ( 1300, 1900 ] 3 0.009% 99.944% ( 1900, 2900 ] 5 0.016% 99.959% ( 2900, 4400 ] 10 0.031% 99.991% ( 4400, 6600 ] 2 0.006% 99.997% ( 6600, 9900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 350681 Average: 13.3971 StdDev: 192.88 Min: 0 Median: 1.8788 Max: 37748 Percentiles: P50: 1.88 P75: 3.02 P99: 12.59 P99.9: 1462.82 P99.99: 2910.54 ------------------------------------------------------ [ 0, 1 ] 15685 4.473% 4.473% # ( 1, 2 ] 181671 51.805% 56.278% ########## ( 2, 3 ] 64907 18.509% 74.787% #### ( 3, 4 ] 41176 11.742% 86.528% ## ( 4, 6 ] 37585 10.718% 97.246% ## ( 6, 10 ] 5590 1.594% 98.840% ( 10, 15 ] 1081 0.308% 99.149% ( 15, 22 ] 162 0.046% 99.195% ( 22, 34 ] 26 0.007% 99.202% ( 34, 51 ] 3 0.001% 99.203% ( 51, 76 ] 5 0.001% 99.204% ( 76, 110 ] 28 0.008% 99.212% ( 110, 170 ] 96 0.027% 99.240% ( 170, 250 ] 226 0.064% 99.304% ( 250, 380 ] 455 0.130% 99.434% ( 380, 580 ] 669 0.191% 99.625% ( 580, 870 ] 581 0.166% 99.790% ( 870, 1300 ] 339 0.097% 99.887% ( 1300, 1900 ] 167 0.048% 99.935% ( 1900, 2900 ] 192 0.055% 99.989% ( 2900, 4400 ] 275 0.078% 100.068% ( 4400, 6600 ] 69 0.020% 100.088% ( 6600, 9900 ] 23 0.007% 100.094% ( 9900, 14000 ] 5 0.001% 100.096% ( 14000, 22000 ] 2 0.001% 100.096% ( 22000, 33000 ] 2 0.001% 100.097% ( 33000, 50000 ] 1 0.000% 100.097% ** Level 4 read latency histogram (micros): Count: 25389 Average: 7.7395 StdDev: 109.26 Min: 1 Median: 1.9525 Max: 5413 Percentiles: P50: 1.95 P75: 3.24 P99: 9.55 P99.9: 1540.73 P99.99: 3643.52 ------------------------------------------------------ [ 0, 1 ] 740 2.915% 2.915% # ( 1, 2 ] 12551 49.435% 52.349% ########## ( 2, 3 ] 5010 19.733% 72.082% #### ( 3, 4 ] 3151 12.411% 84.493% ## ( 4, 6 ] 3275 12.899% 97.393% ### ( 6, 10 ] 460 1.812% 99.204% ( 10, 15 ] 88 0.347% 99.551% ( 15, 22 ] 15 0.059% 99.610% ( 22, 34 ] 5 0.020% 99.630% ( 34, 51 ] 2 0.008% 99.638% ( 76, 110 ] 2 0.008% 99.646% ( 110, 170 ] 6 0.024% 99.669% ( 170, 250 ] 21 0.083% 99.752% ( 250, 380 ] 2 0.008% 99.760% ( 380, 580 ] 7 0.028% 99.787% ( 580, 870 ] 13 0.051% 99.839% ( 870, 1300 ] 12 0.047% 99.886% ( 1300, 1900 ] 9 0.035% 99.921% ( 1900, 2900 ] 13 0.051% 99.972% ( 2900, 4400 ] 9 0.035% 100.008% ( 4400, 6600 ] 3 0.012% 100.020% ** Level 5 read latency histogram (micros): Count: 180 Average: 1195.9111 StdDev: 1131.23 Min: 68 Median: 725.0000 Max: 5831 Percentiles: P50: 725.00 P75: 1642.86 P99: 4620.00 P99.9: 5831.00 P99.99: 5831.00 ------------------------------------------------------ ( 51, 76 ] 3 1.667% 1.667% ( 76, 110 ] 1 0.556% 2.222% ( 110, 170 ] 1 0.556% 2.778% ( 170, 250 ] 9 5.000% 7.778% # ( 250, 380 ] 24 13.333% 21.111% ### ( 380, 580 ] 36 20.000% 41.111% #### ( 580, 870 ] 32 17.778% 58.889% #### ( 870, 1300 ] 17 9.444% 68.333% ## ( 1300, 1900 ] 21 11.667% 80.000% ## ( 1900, 2900 ] 17 9.444% 89.444% ## ( 2900, 4400 ] 17 9.444% 98.889% ## ( 4400, 6600 ] 2 1.111% 100.000% ** DB Stats ** Uptime(secs): 36.9 total, 20.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 159.93 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.423 H:M:S, 55.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 47.10 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:17.564 H:M:S, 84.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/19-11:13:37 ... thread 0: (1000000,7000000) ops and (283196.2,173917.8) ops/second in (3.531121,40.248899) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/12 2.09 GB 37.8 5.2 0.0 5.2 11.8 6.6 0.0 1.8 129.8 293.1 41.25 36.43 114 0.362 5436K 5789 0.0 0.0 L1 0/0 0.00 KB 0.0 4.4 4.3 0.1 4.3 4.2 0.2 1.0 224.3 220.1 19.93 18.50 2 9.967 4539K 82K 0.0 0.0 L2 1/0 70.59 MB 0.7 0.9 0.8 0.1 0.9 0.8 3.6 1.1 174.7 174.2 5.31 4.12 3 1.768 184K 38 0.0 0.0 L3 15/0 999.38 MB 1.0 2.6 2.2 0.4 2.6 2.1 2.3 1.2 152.7 152.4 17.22 11.98 19 0.906 2298K 1223 0.0 0.0 L4 163/0 9.73 GB 1.0 2.9 2.4 0.5 2.9 2.4 1.8 1.2 136.3 136.0 21.86 13.59 27 0.810 3007K 7228 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1285/12 102.62 GB 0.0 16.0 9.6 6.4 22.5 16.1 11.8 3.4 155.0 217.8 105.57 84.62 165 0.640 15M 96K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.0 9.6 6.4 22.5 16.1 11.8 3.4 155.0 217.8 105.57 84.62 165 0.640 15M 96K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.0 9.6 6.4 15.9 9.5 0.0 0.0 193.1 191.9 84.71 67.76 70 1.210 15M 96K 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 323.2 20.86 16.85 95 0.220 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 40.5 total, 40.3 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.46 GB write, 568.49 MB/s write, 15.98 GB read, 404.45 MB/s read, 105.6 seconds Interval compaction: 22.46 GB write, 571.37 MB/s write, 15.98 GB read, 406.50 MB/s read, 105.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 53, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 53, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2662843 Average: 2.5903 StdDev: 23.25 Min: 0 Median: 1.3498 Max: 10531 Percentiles: P50: 1.35 P75: 1.76 P99: 6.66 P99.9: 167.52 P99.99: 368.20 ------------------------------------------------------ [ 0, 1 ] 759600 28.526% 28.526% ###### ( 1, 2 ] 1634563 61.384% 89.910% ############ ( 2, 3 ] 133142 5.000% 94.910% # ( 3, 4 ] 63484 2.384% 97.294% ( 4, 6 ] 42692 1.603% 98.897% ( 6, 10 ] 16465 0.618% 99.516% ( 10, 15 ] 2043 0.077% 99.592% ( 15, 22 ] 519 0.019% 99.612% ( 22, 34 ] 43 0.002% 99.613% ( 34, 51 ] 36 0.001% 99.615% ( 51, 76 ] 3450 0.130% 99.744% ( 76, 110 ] 974 0.037% 99.781% ( 110, 170 ] 3307 0.124% 99.905% ( 170, 250 ] 1776 0.067% 99.972% ( 250, 380 ] 532 0.020% 99.992% ( 380, 580 ] 258 0.010% 100.002% ( 580, 870 ] 114 0.004% 100.006% ( 870, 1300 ] 58 0.002% 100.008% ( 1300, 1900 ] 19 0.001% 100.009% ( 1900, 2900 ] 43 0.002% 100.010% ( 2900, 4400 ] 29 0.001% 100.011% ( 4400, 6600 ] 7 0.000% 100.012% ( 6600, 9900 ] 1 0.000% 100.012% ( 9900, 14000 ] 1 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 944761 Average: 6.3804 StdDev: 119.67 Min: 1 Median: 1.8737 Max: 18639 Percentiles: P50: 1.87 P75: 3.00 P99: 8.70 P99.9: 13.43 P99.99: 14.56 ------------------------------------------------------ [ 0, 1 ] 38422 4.067% 4.067% # ( 1, 2 ] 496672 52.571% 56.638% ########### ( 2, 3 ] 174160 18.434% 75.072% #### ( 3, 4 ] 107735 11.403% 86.476% ## ( 4, 6 ] 105977 11.217% 97.693% ## ( 6, 10 ] 18259 1.933% 99.626% ( 10, 15 ] 3772 0.399% 100.025% ( 15, 22 ] 393 0.042% 100.067% ( 22, 34 ] 45 0.005% 100.071% ( 34, 51 ] 34 0.004% 100.075% ( 51, 76 ] 44 0.005% 100.080% ( 76, 110 ] 23 0.002% 100.082% ( 110, 170 ] 78 0.008% 100.090% ( 170, 250 ] 95 0.010% 100.100% ( 250, 380 ] 165 0.017% 100.118% ( 380, 580 ] 247 0.026% 100.144% ( 580, 870 ] 239 0.025% 100.169% ( 870, 1300 ] 152 0.016% 100.185% ( 1300, 1900 ] 128 0.014% 100.199% ( 1900, 2900 ] 188 0.020% 100.219% ( 2900, 4400 ] 310 0.033% 100.252% ( 4400, 6600 ] 96 0.010% 100.262% ( 6600, 9900 ] 52 0.006% 100.267% ( 9900, 14000 ] 6 0.001% 100.268% ( 14000, 22000 ] 5 0.001% 100.268% ** Level 2 read latency histogram (micros): Count: 206388 Average: 5.2670 StdDev: 82.56 Min: 1 Median: 1.7766 Max: 8332 Percentiles: P50: 1.78 P75: 2.77 P99: 8.64 P99.9: 14.19 P99.99: 21.05 ------------------------------------------------------ [ 0, 1 ] 17029 8.251% 8.251% ## ( 1, 2 ] 110945 53.756% 62.007% ########### ( 2, 3 ] 34691 16.809% 78.815% ### ( 3, 4 ] 20022 9.701% 88.516% ## ( 4, 6 ] 19270 9.337% 97.853% ## ( 6, 10 ] 3584 1.737% 99.590% ( 10, 15 ] 765 0.371% 99.960% ( 15, 22 ] 71 0.034% 99.995% ( 22, 34 ] 5 0.002% 99.997% ( 34, 51 ] 7 0.003% 100.000% ( 51, 76 ] 14 0.007% 100.007% ( 76, 110 ] 10 0.005% 100.012% ( 110, 170 ] 17 0.008% 100.020% ( 170, 250 ] 38 0.018% 100.039% ( 250, 380 ] 64 0.031% 100.070% ( 380, 580 ] 80 0.039% 100.109% ( 580, 870 ] 63 0.031% 100.139% ( 870, 1300 ] 39 0.019% 100.158% ( 1300, 1900 ] 32 0.016% 100.173% ( 1900, 2900 ] 35 0.017% 100.190% ( 2900, 4400 ] 46 0.022% 100.213% ( 4400, 6600 ] 12 0.006% 100.219% ( 6600, 9900 ] 2 0.001% 100.219% ** Level 3 read latency histogram (micros): Count: 409130 Average: 14.3400 StdDev: 193.25 Min: 0 Median: 1.8662 Max: 37748 Percentiles: P50: 1.87 P75: 2.98 P99: 14.65 P99.9: 1638.13 P99.99: 2997.32 ------------------------------------------------------ [ 0, 1 ] 18061 4.414% 4.414% # ( 1, 2 ] 215320 52.629% 57.043% ########### ( 2, 3 ] 74685 18.255% 75.298% #### ( 3, 4 ] 46800 11.439% 86.737% ## ( 4, 6 ] 42400 10.363% 97.100% ## ( 6, 10 ] 6578 1.608% 98.708% ( 10, 15 ] 1285 0.314% 99.022% ( 15, 22 ] 183 0.045% 99.067% ( 22, 34 ] 32 0.008% 99.075% ( 34, 51 ] 3 0.001% 99.075% ( 51, 76 ] 13 0.003% 99.079% ( 76, 110 ] 41 0.010% 99.089% ( 110, 170 ] 156 0.038% 99.127% ( 170, 250 ] 317 0.077% 99.204% ( 250, 380 ] 586 0.143% 99.347% ( 380, 580 ] 860 0.210% 99.558% ( 580, 870 ] 791 0.193% 99.751% ( 870, 1300 ] 478 0.117% 99.868% ( 1300, 1900 ] 234 0.057% 99.925% ( 1900, 2900 ] 245 0.060% 99.985% ( 2900, 4400 ] 325 0.079% 100.064% ( 4400, 6600 ] 89 0.022% 100.086% ( 6600, 9900 ] 29 0.007% 100.093% ( 9900, 14000 ] 5 0.001% 100.094% ( 14000, 22000 ] 2 0.000% 100.095% ( 22000, 33000 ] 2 0.000% 100.095% ( 33000, 50000 ] 1 0.000% 100.096% ** Level 4 read latency histogram (micros): Count: 61070 Average: 5.5206 StdDev: 74.59 Min: 1 Median: 1.7490 Max: 5413 Percentiles: P50: 1.75 P75: 2.64 P99: 9.52 P99.9: 701.04 P99.99: 3183.95 ------------------------------------------------------ [ 0, 1 ] 3791 6.208% 6.208% # ( 1, 2 ] 35706 58.467% 64.675% ############ ( 2, 3 ] 9857 16.140% 80.815% ### ( 3, 4 ] 5156 8.443% 89.258% ## ( 4, 6 ] 4998 8.184% 97.442% ## ( 6, 10 ] 1082 1.772% 99.214% ( 10, 15 ] 191 0.313% 99.527% ( 15, 22 ] 20 0.033% 99.560% ( 22, 34 ] 5 0.008% 99.568% ( 34, 51 ] 2 0.003% 99.571% ( 51, 76 ] 15 0.025% 99.596% ( 76, 110 ] 16 0.026% 99.622% ( 110, 170 ] 24 0.039% 99.661% ( 170, 250 ] 75 0.123% 99.784% ( 250, 380 ] 34 0.056% 99.840% ( 380, 580 ] 29 0.047% 99.887% ( 580, 870 ] 19 0.031% 99.918% ( 870, 1300 ] 18 0.029% 99.948% ( 1300, 1900 ] 10 0.016% 99.964% ( 1900, 2900 ] 14 0.023% 99.987% ( 2900, 4400 ] 10 0.016% 100.003% ( 4400, 6600 ] 3 0.005% 100.008% ** Level 5 read latency histogram (micros): Count: 240 Average: 1064.7583 StdDev: 1061.10 Min: 54 Median: 627.0270 Max: 5831 Percentiles: P50: 627.03 P75: 1460.00 P99: 4366.67 P99.9: 5831.00 P99.99: 5831.00 ------------------------------------------------------ ( 51, 76 ] 6 2.500% 2.500% # ( 76, 110 ] 2 0.833% 3.333% ( 110, 170 ] 3 1.250% 4.583% ( 170, 250 ] 21 8.750% 13.333% ## ( 250, 380 ] 34 14.167% 27.500% ### ( 380, 580 ] 48 20.000% 47.500% #### ( 580, 870 ] 37 15.417% 62.917% ### ( 870, 1300 ] 21 8.750% 71.667% ## ( 1300, 1900 ] 30 12.500% 84.167% ### ( 1900, 2900 ] 18 7.500% 91.667% ## ( 2900, 4400 ] 18 7.500% 99.167% ## ( 4400, 6600 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 40.5 total, 3.5 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 170.30 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:21.233 H:M:S, 52.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 278.72 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.810 H:M:S, 22.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-11:13:40 ... thread 0: (1000000,8000000) ops and (279828.7,182554.6) ops/second in (3.573615,43.822514) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/12 3.13 GB 151.0 6.3 0.0 6.3 14.0 7.6 0.0 1.8 133.5 294.0 48.61 43.38 134 0.363 6588K 7033 0.0 0.0 L1 0/0 0.00 KB 0.0 4.4 4.3 0.1 4.3 4.2 0.2 1.0 224.3 220.1 19.93 18.50 2 9.967 4539K 82K 0.0 0.0 L2 1/0 70.59 MB 0.7 0.9 0.8 0.1 0.9 0.8 3.6 1.1 174.7 174.2 5.31 4.12 3 1.768 184K 38 0.0 0.0 L3 15/0 999.38 MB 1.0 2.6 2.2 0.4 2.6 2.1 2.3 1.2 152.7 152.4 17.22 11.98 19 0.906 2298K 1223 0.0 0.0 L4 163/0 9.73 GB 1.0 2.9 2.4 0.5 2.9 2.4 1.8 1.2 136.3 136.0 21.86 13.59 27 0.810 3007K 7228 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1289/12 103.66 GB 0.0 17.1 9.6 7.5 24.6 17.1 11.8 3.2 154.9 223.2 112.93 91.57 185 0.610 16M 98K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.1 9.6 7.5 24.6 17.1 11.8 3.2 154.9 223.2 112.93 91.57 185 0.610 16M 98K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.1 9.6 7.5 17.0 9.5 0.0 0.0 196.6 195.4 88.98 71.95 74 1.202 16M 98K 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 326.2 23.95 19.62 111 0.216 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): 44.0 total, 43.8 interval Flush(GB): cumulative 7.628, interval 7.628 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.61 GB write, 572.40 MB/s write, 17.09 GB read, 397.37 MB/s read, 112.9 seconds Interval compaction: 24.61 GB write, 575.06 MB/s write, 17.09 GB read, 399.22 MB/s read, 112.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 0, 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: 3170432 Average: 2.5352 StdDev: 21.44 Min: 0 Median: 1.3777 Max: 10531 Percentiles: P50: 1.38 P75: 1.78 P99: 6.48 P99.9: 154.73 P99.99: 293.72 ------------------------------------------------------ [ 0, 1 ] 838460 26.446% 26.446% ##### ( 1, 2 ] 1976859 62.353% 88.799% ############ ( 2, 3 ] 182864 5.768% 94.567% # ( 3, 4 ] 82763 2.610% 97.177% # ( 4, 6 ] 55312 1.745% 98.922% ( 6, 10 ] 20624 0.651% 99.573% ( 10, 15 ] 2745 0.087% 99.659% ( 15, 22 ] 560 0.018% 99.677% ( 22, 34 ] 45 0.001% 99.678% ( 34, 51 ] 39 0.001% 99.680% ( 51, 76 ] 3494 0.110% 99.790% ( 76, 110 ] 996 0.031% 99.821% ( 110, 170 ] 3358 0.106% 99.927% ( 170, 250 ] 1814 0.057% 99.984% ( 250, 380 ] 550 0.017% 100.002% ( 380, 580 ] 274 0.009% 100.010% ( 580, 870 ] 123 0.004% 100.014% ( 870, 1300 ] 62 0.002% 100.016% ( 1300, 1900 ] 20 0.001% 100.017% ( 1900, 2900 ] 43 0.001% 100.018% ( 2900, 4400 ] 29 0.001% 100.019% ( 4400, 6600 ] 7 0.000% 100.019% ( 6600, 9900 ] 1 0.000% 100.019% ( 9900, 14000 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 944761 Average: 6.3804 StdDev: 119.67 Min: 1 Median: 1.8737 Max: 18639 Percentiles: P50: 1.87 P75: 3.00 P99: 8.70 P99.9: 13.43 P99.99: 14.56 ------------------------------------------------------ [ 0, 1 ] 38422 4.067% 4.067% # ( 1, 2 ] 496672 52.571% 56.638% ########### ( 2, 3 ] 174160 18.434% 75.072% #### ( 3, 4 ] 107735 11.403% 86.476% ## ( 4, 6 ] 105977 11.217% 97.693% ## ( 6, 10 ] 18259 1.933% 99.626% ( 10, 15 ] 3772 0.399% 100.025% ( 15, 22 ] 393 0.042% 100.067% ( 22, 34 ] 45 0.005% 100.071% ( 34, 51 ] 34 0.004% 100.075% ( 51, 76 ] 44 0.005% 100.080% ( 76, 110 ] 23 0.002% 100.082% ( 110, 170 ] 78 0.008% 100.090% ( 170, 250 ] 95 0.010% 100.100% ( 250, 380 ] 165 0.017% 100.118% ( 380, 580 ] 247 0.026% 100.144% ( 580, 870 ] 239 0.025% 100.169% ( 870, 1300 ] 152 0.016% 100.185% ( 1300, 1900 ] 128 0.014% 100.199% ( 1900, 2900 ] 188 0.020% 100.219% ( 2900, 4400 ] 310 0.033% 100.252% ( 4400, 6600 ] 96 0.010% 100.262% ( 6600, 9900 ] 52 0.006% 100.267% ( 9900, 14000 ] 6 0.001% 100.268% ( 14000, 22000 ] 5 0.001% 100.268% ** Level 2 read latency histogram (micros): Count: 206388 Average: 5.2670 StdDev: 82.56 Min: 1 Median: 1.7766 Max: 8332 Percentiles: P50: 1.78 P75: 2.77 P99: 8.64 P99.9: 14.19 P99.99: 21.05 ------------------------------------------------------ [ 0, 1 ] 17029 8.251% 8.251% ## ( 1, 2 ] 110945 53.756% 62.007% ########### ( 2, 3 ] 34691 16.809% 78.815% ### ( 3, 4 ] 20022 9.701% 88.516% ## ( 4, 6 ] 19270 9.337% 97.853% ## ( 6, 10 ] 3584 1.737% 99.590% ( 10, 15 ] 765 0.371% 99.960% ( 15, 22 ] 71 0.034% 99.995% ( 22, 34 ] 5 0.002% 99.997% ( 34, 51 ] 7 0.003% 100.000% ( 51, 76 ] 14 0.007% 100.007% ( 76, 110 ] 10 0.005% 100.012% ( 110, 170 ] 17 0.008% 100.020% ( 170, 250 ] 38 0.018% 100.039% ( 250, 380 ] 64 0.031% 100.070% ( 380, 580 ] 80 0.039% 100.109% ( 580, 870 ] 63 0.031% 100.139% ( 870, 1300 ] 39 0.019% 100.158% ( 1300, 1900 ] 32 0.016% 100.173% ( 1900, 2900 ] 35 0.017% 100.190% ( 2900, 4400 ] 46 0.022% 100.213% ( 4400, 6600 ] 12 0.006% 100.219% ( 6600, 9900 ] 2 0.001% 100.219% ** Level 3 read latency histogram (micros): Count: 409130 Average: 14.3400 StdDev: 193.25 Min: 0 Median: 1.8662 Max: 37748 Percentiles: P50: 1.87 P75: 2.98 P99: 14.65 P99.9: 1638.13 P99.99: 2997.32 ------------------------------------------------------ [ 0, 1 ] 18061 4.414% 4.414% # ( 1, 2 ] 215320 52.629% 57.043% ########### ( 2, 3 ] 74685 18.255% 75.298% #### ( 3, 4 ] 46800 11.439% 86.737% ## ( 4, 6 ] 42400 10.363% 97.100% ## ( 6, 10 ] 6578 1.608% 98.708% ( 10, 15 ] 1285 0.314% 99.022% ( 15, 22 ] 183 0.045% 99.067% ( 22, 34 ] 32 0.008% 99.075% ( 34, 51 ] 3 0.001% 99.075% ( 51, 76 ] 13 0.003% 99.079% ( 76, 110 ] 41 0.010% 99.089% ( 110, 170 ] 156 0.038% 99.127% ( 170, 250 ] 317 0.077% 99.204% ( 250, 380 ] 586 0.143% 99.347% ( 380, 580 ] 860 0.210% 99.558% ( 580, 870 ] 791 0.193% 99.751% ( 870, 1300 ] 478 0.117% 99.868% ( 1300, 1900 ] 234 0.057% 99.925% ( 1900, 2900 ] 245 0.060% 99.985% ( 2900, 4400 ] 325 0.079% 100.064% ( 4400, 6600 ] 89 0.022% 100.086% ( 6600, 9900 ] 29 0.007% 100.093% ( 9900, 14000 ] 5 0.001% 100.094% ( 14000, 22000 ] 2 0.000% 100.095% ( 22000, 33000 ] 2 0.000% 100.095% ( 33000, 50000 ] 1 0.000% 100.096% ** Level 4 read latency histogram (micros): Count: 61070 Average: 5.5206 StdDev: 74.59 Min: 1 Median: 1.7490 Max: 5413 Percentiles: P50: 1.75 P75: 2.64 P99: 9.52 P99.9: 701.04 P99.99: 3183.95 ------------------------------------------------------ [ 0, 1 ] 3791 6.208% 6.208% # ( 1, 2 ] 35706 58.467% 64.675% ############ ( 2, 3 ] 9857 16.140% 80.815% ### ( 3, 4 ] 5156 8.443% 89.258% ## ( 4, 6 ] 4998 8.184% 97.442% ## ( 6, 10 ] 1082 1.772% 99.214% ( 10, 15 ] 191 0.313% 99.527% ( 15, 22 ] 20 0.033% 99.560% ( 22, 34 ] 5 0.008% 99.568% ( 34, 51 ] 2 0.003% 99.571% ( 51, 76 ] 15 0.025% 99.596% ( 76, 110 ] 16 0.026% 99.622% ( 110, 170 ] 24 0.039% 99.661% ( 170, 250 ] 75 0.123% 99.784% ( 250, 380 ] 34 0.056% 99.840% ( 380, 580 ] 29 0.047% 99.887% ( 580, 870 ] 19 0.031% 99.918% ( 870, 1300 ] 18 0.029% 99.948% ( 1300, 1900 ] 10 0.016% 99.964% ( 1900, 2900 ] 14 0.023% 99.987% ( 2900, 4400 ] 10 0.016% 100.003% ( 4400, 6600 ] 3 0.005% 100.008% ** Level 5 read latency histogram (micros): Count: 240 Average: 1064.7583 StdDev: 1061.10 Min: 54 Median: 627.0270 Max: 5831 Percentiles: P50: 627.03 P75: 1460.00 P99: 4366.67 P99.9: 5831.00 P99.99: 5831.00 ------------------------------------------------------ ( 51, 76 ] 6 2.500% 2.500% # ( 76, 110 ] 2 0.833% 3.333% ( 110, 170 ] 3 1.250% 4.583% ( 170, 250 ] 21 8.750% 13.333% ## ( 250, 380 ] 34 14.167% 27.500% ### ( 380, 580 ] 48 20.000% 47.500% #### ( 580, 870 ] 37 15.417% 62.917% ### ( 870, 1300 ] 21 8.750% 71.667% ## ( 1300, 1900 ] 30 12.500% 84.167% ### ( 1900, 2900 ] 18 7.500% 91.667% ## ( 2900, 4400 ] 18 7.500% 99.167% ## ( 4400, 6600 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 44.0 total, 3.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 178.83 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.051 H:M:S, 50.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 275.41 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.819 H:M:S, 22.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-11:13:43 ... thread 0: (1000000,9000000) ops and (332740.9,192193.3) ops/second in (3.005341,46.827855) 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/14 2.64 GB 44.1 6.8 0.0 6.8 15.4 8.5 0.0 1.8 131.7 296.5 53.10 47.57 150 0.354 7100K 7522 0.0 0.0 L1 12/12 1.40 GB 0.0 5.8 5.7 0.1 5.7 5.6 0.2 1.0 224.4 221.0 26.37 24.57 3 8.790 6009K 91K 0.0 0.0 L2 1/0 70.59 MB 0.7 0.9 0.8 0.1 0.9 0.8 3.6 1.1 174.7 174.2 5.31 4.12 3 1.768 184K 38 0.0 0.0 L3 15/0 999.38 MB 1.0 2.6 2.2 0.4 2.6 2.1 2.3 1.2 152.7 152.4 17.22 11.98 19 0.906 2298K 1223 0.0 0.0 L4 163/0 9.73 GB 1.0 2.9 2.4 0.5 2.9 2.4 1.8 1.2 136.3 136.0 21.86 13.59 27 0.810 3007K 7228 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/26 104.58 GB 0.0 19.0 11.0 8.0 27.4 19.5 11.8 3.2 157.0 226.8 123.86 101.83 202 0.613 18M 107K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.0 11.0 8.0 27.4 19.5 11.8 3.2 157.0 226.8 123.86 101.83 202 0.613 18M 107K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.0 11.0 8.0 18.9 10.9 0.0 0.0 200.0 198.8 97.24 79.81 77 1.263 18M 107K 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 329.0 26.61 22.02 125 0.213 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 47.0 total, 46.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: 27.43 GB write, 597.20 MB/s write, 18.99 GB read, 413.48 MB/s read, 123.9 seconds Interval compaction: 27.43 GB write, 599.80 MB/s write, 18.99 GB read, 415.28 MB/s read, 123.9 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: 58, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 58, interval: 74 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3429114 Average: 2.5113 StdDev: 20.78 Min: 0 Median: 1.3831 Max: 10531 Percentiles: P50: 1.38 P75: 1.78 P99: 6.27 P99.9: 151.61 P99.99: 286.03 ------------------------------------------------------ [ 0, 1 ] 890533 25.970% 25.970% ##### ( 1, 2 ] 2151062 62.729% 88.699% ############# ( 2, 3 ] 202793 5.914% 94.613% # ( 3, 4 ] 89941 2.623% 97.236% # ( 4, 6 ] 59008 1.721% 98.957% ( 6, 10 ] 21793 0.636% 99.592% ( 10, 15 ] 2977 0.087% 99.679% ( 15, 22 ] 575 0.017% 99.696% ( 22, 34 ] 45 0.001% 99.697% ( 34, 51 ] 39 0.001% 99.698% ( 51, 76 ] 3534 0.103% 99.801% ( 76, 110 ] 1015 0.030% 99.831% ( 110, 170 ] 3420 0.100% 99.931% ( 170, 250 ] 1879 0.055% 99.985% ( 250, 380 ] 574 0.017% 100.002% ( 380, 580 ] 291 0.008% 100.011% ( 580, 870 ] 129 0.004% 100.014% ( 870, 1300 ] 67 0.002% 100.016% ( 1300, 1900 ] 22 0.001% 100.017% ( 1900, 2900 ] 43 0.001% 100.018% ( 2900, 4400 ] 29 0.001% 100.019% ( 4400, 6600 ] 7 0.000% 100.019% ( 6600, 9900 ] 1 0.000% 100.019% ( 9900, 14000 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 1002212 Average: 6.1728 StdDev: 116.27 Min: 0 Median: 1.8434 Max: 18639 Percentiles: P50: 1.84 P75: 2.94 P99: 8.70 P99.9: 13.60 P99.99: 14.77 ------------------------------------------------------ [ 0, 1 ] 50516 5.040% 5.040% # ( 1, 2 ] 534251 53.307% 58.348% ########### ( 2, 3 ] 178425 17.803% 76.151% #### ( 3, 4 ] 109235 10.899% 87.050% ## ( 4, 6 ] 106817 10.658% 97.708% ## ( 6, 10 ] 19207 1.916% 99.625% ( 10, 15 ] 3838 0.383% 100.008% ( 15, 22 ] 397 0.040% 100.047% ( 22, 34 ] 46 0.005% 100.052% ( 34, 51 ] 34 0.003% 100.055% ( 51, 76 ] 66 0.007% 100.062% ( 76, 110 ] 45 0.004% 100.066% ( 110, 170 ] 114 0.011% 100.078% ( 170, 250 ] 121 0.012% 100.090% ( 250, 380 ] 183 0.018% 100.108% ( 380, 580 ] 264 0.026% 100.134% ( 580, 870 ] 249 0.025% 100.159% ( 870, 1300 ] 155 0.015% 100.175% ( 1300, 1900 ] 128 0.013% 100.187% ( 1900, 2900 ] 189 0.019% 100.206% ( 2900, 4400 ] 310 0.031% 100.237% ( 4400, 6600 ] 96 0.010% 100.247% ( 6600, 9900 ] 52 0.005% 100.252% ( 9900, 14000 ] 6 0.001% 100.253% ( 14000, 22000 ] 5 0.000% 100.253% ** Level 2 read latency histogram (micros): Count: 206388 Average: 5.2670 StdDev: 82.56 Min: 1 Median: 1.7766 Max: 8332 Percentiles: P50: 1.78 P75: 2.77 P99: 8.64 P99.9: 14.19 P99.99: 21.05 ------------------------------------------------------ [ 0, 1 ] 17029 8.251% 8.251% ## ( 1, 2 ] 110945 53.756% 62.007% ########### ( 2, 3 ] 34691 16.809% 78.815% ### ( 3, 4 ] 20022 9.701% 88.516% ## ( 4, 6 ] 19270 9.337% 97.853% ## ( 6, 10 ] 3584 1.737% 99.590% ( 10, 15 ] 765 0.371% 99.960% ( 15, 22 ] 71 0.034% 99.995% ( 22, 34 ] 5 0.002% 99.997% ( 34, 51 ] 7 0.003% 100.000% ( 51, 76 ] 14 0.007% 100.007% ( 76, 110 ] 10 0.005% 100.012% ( 110, 170 ] 17 0.008% 100.020% ( 170, 250 ] 38 0.018% 100.039% ( 250, 380 ] 64 0.031% 100.070% ( 380, 580 ] 80 0.039% 100.109% ( 580, 870 ] 63 0.031% 100.139% ( 870, 1300 ] 39 0.019% 100.158% ( 1300, 1900 ] 32 0.016% 100.173% ( 1900, 2900 ] 35 0.017% 100.190% ( 2900, 4400 ] 46 0.022% 100.213% ( 4400, 6600 ] 12 0.006% 100.219% ( 6600, 9900 ] 2 0.001% 100.219% ** Level 3 read latency histogram (micros): Count: 409130 Average: 14.3400 StdDev: 193.25 Min: 0 Median: 1.8662 Max: 37748 Percentiles: P50: 1.87 P75: 2.98 P99: 14.65 P99.9: 1638.13 P99.99: 2997.32 ------------------------------------------------------ [ 0, 1 ] 18061 4.414% 4.414% # ( 1, 2 ] 215320 52.629% 57.043% ########### ( 2, 3 ] 74685 18.255% 75.298% #### ( 3, 4 ] 46800 11.439% 86.737% ## ( 4, 6 ] 42400 10.363% 97.100% ## ( 6, 10 ] 6578 1.608% 98.708% ( 10, 15 ] 1285 0.314% 99.022% ( 15, 22 ] 183 0.045% 99.067% ( 22, 34 ] 32 0.008% 99.075% ( 34, 51 ] 3 0.001% 99.075% ( 51, 76 ] 13 0.003% 99.079% ( 76, 110 ] 41 0.010% 99.089% ( 110, 170 ] 156 0.038% 99.127% ( 170, 250 ] 317 0.077% 99.204% ( 250, 380 ] 586 0.143% 99.347% ( 380, 580 ] 860 0.210% 99.558% ( 580, 870 ] 791 0.193% 99.751% ( 870, 1300 ] 478 0.117% 99.868% ( 1300, 1900 ] 234 0.057% 99.925% ( 1900, 2900 ] 245 0.060% 99.985% ( 2900, 4400 ] 325 0.079% 100.064% ( 4400, 6600 ] 89 0.022% 100.086% ( 6600, 9900 ] 29 0.007% 100.093% ( 9900, 14000 ] 5 0.001% 100.094% ( 14000, 22000 ] 2 0.000% 100.095% ( 22000, 33000 ] 2 0.000% 100.095% ( 33000, 50000 ] 1 0.000% 100.096% ** Level 4 read latency histogram (micros): Count: 61070 Average: 5.5206 StdDev: 74.59 Min: 1 Median: 1.7490 Max: 5413 Percentiles: P50: 1.75 P75: 2.64 P99: 9.52 P99.9: 701.04 P99.99: 3183.95 ------------------------------------------------------ [ 0, 1 ] 3791 6.208% 6.208% # ( 1, 2 ] 35706 58.467% 64.675% ############ ( 2, 3 ] 9857 16.140% 80.815% ### ( 3, 4 ] 5156 8.443% 89.258% ## ( 4, 6 ] 4998 8.184% 97.442% ## ( 6, 10 ] 1082 1.772% 99.214% ( 10, 15 ] 191 0.313% 99.527% ( 15, 22 ] 20 0.033% 99.560% ( 22, 34 ] 5 0.008% 99.568% ( 34, 51 ] 2 0.003% 99.571% ( 51, 76 ] 15 0.025% 99.596% ( 76, 110 ] 16 0.026% 99.622% ( 110, 170 ] 24 0.039% 99.661% ( 170, 250 ] 75 0.123% 99.784% ( 250, 380 ] 34 0.056% 99.840% ( 380, 580 ] 29 0.047% 99.887% ( 580, 870 ] 19 0.031% 99.918% ( 870, 1300 ] 18 0.029% 99.948% ( 1300, 1900 ] 10 0.016% 99.964% ( 1900, 2900 ] 14 0.023% 99.987% ( 2900, 4400 ] 10 0.016% 100.003% ( 4400, 6600 ] 3 0.005% 100.008% ** Level 5 read latency histogram (micros): Count: 240 Average: 1064.7583 StdDev: 1061.10 Min: 54 Median: 627.0270 Max: 5831 Percentiles: P50: 627.03 P75: 1460.00 P99: 4366.67 P99.9: 5831.00 P99.99: 5831.00 ------------------------------------------------------ ( 51, 76 ] 6 2.500% 2.500% # ( 76, 110 ] 2 0.833% 3.333% ( 110, 170 ] 3 1.250% 4.583% ( 170, 250 ] 21 8.750% 13.333% ## ( 250, 380 ] 34 14.167% 27.500% ### ( 380, 580 ] 48 20.000% 47.500% #### ( 580, 870 ] 37 15.417% 62.917% ### ( 870, 1300 ] 21 8.750% 71.667% ## ( 1300, 1900 ] 30 12.500% 84.167% ### ( 1900, 2900 ] 18 7.500% 91.667% ## ( 2900, 4400 ] 18 7.500% 99.167% ## ( 4400, 6600 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 47.0 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 188.33 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:22.412 H:M:S, 47.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.48 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.360 H:M:S, 12.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-11:13:48 ... thread 0: (1000000,10000000) ops and (199774.6,192925.4) ops/second in (5.005641,51.833496) 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 20/14 3.69 GB 157.3 8.1 0.0 8.1 17.7 9.6 0.0 1.8 136.2 296.9 61.08 55.15 172 0.355 8443K 8856 0.0 0.0 L1 12/12 1.40 GB 0.0 5.8 5.7 0.1 5.7 5.6 0.2 1.0 224.4 221.0 26.37 24.57 3 8.790 6009K 91K 0.0 0.0 L2 1/0 70.59 MB 0.7 0.9 0.8 0.1 0.9 0.8 3.6 1.1 174.7 174.2 5.31 4.12 3 1.768 184K 38 0.0 0.0 L3 15/0 999.38 MB 1.0 2.6 2.2 0.4 2.6 2.1 2.3 1.2 152.7 152.4 17.22 11.98 19 0.906 2298K 1223 0.0 0.0 L4 163/0 9.73 GB 1.0 2.9 2.4 0.5 2.9 2.4 1.8 1.2 136.3 136.0 21.86 13.59 27 0.810 3007K 7228 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1303/26 105.62 GB 0.0 20.3 11.0 9.3 29.8 20.5 11.8 3.1 157.5 231.2 131.83 109.41 224 0.589 19M 108K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.3 11.0 9.3 29.8 20.5 11.8 3.1 157.5 231.2 131.83 109.41 224 0.589 19M 108K 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 11.0 9.3 20.2 10.9 0.0 0.0 203.3 202.2 102.16 84.65 82 1.246 19M 108K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.6 9.6 0.0 0.0 0.0 331.2 29.67 24.76 142 0.209 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 9.597, interval 9.597 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.77 GB write, 585.73 MB/s write, 20.28 GB read, 399.12 MB/s read, 131.8 seconds Interval compaction: 29.77 GB write, 588.04 MB/s write, 20.28 GB read, 400.69 MB/s read, 131.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 25, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 25, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 58, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 58, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3921013 Average: 2.4796 StdDev: 19.65 Min: 0 Median: 1.3950 Max: 10531 Percentiles: P50: 1.39 P75: 1.79 P99: 6.02 P99.9: 144.45 P99.99: 258.39 ------------------------------------------------------ [ 0, 1 ] 980492 25.006% 25.006% ##### ( 1, 2 ] 2481179 63.279% 88.285% ############# ( 2, 3 ] 244505 6.236% 94.521% # ( 3, 4 ] 106799 2.724% 97.245% # ( 4, 6 ] 68710 1.752% 98.997% ( 6, 10 ] 24589 0.627% 99.624% ( 10, 15 ] 3440 0.088% 99.712% ( 15, 22 ] 603 0.015% 99.727% ( 22, 34 ] 46 0.001% 99.728% ( 34, 51 ] 41 0.001% 99.729% ( 51, 76 ] 3607 0.092% 99.821% ( 76, 110 ] 1052 0.027% 99.848% ( 110, 170 ] 3542 0.090% 99.939% ( 170, 250 ] 1981 0.051% 99.989% ( 250, 380 ] 618 0.016% 100.005% ( 380, 580 ] 329 0.008% 100.013% ( 580, 870 ] 141 0.004% 100.017% ( 870, 1300 ] 69 0.002% 100.019% ( 1300, 1900 ] 24 0.001% 100.019% ( 1900, 2900 ] 43 0.001% 100.020% ( 2900, 4400 ] 29 0.001% 100.021% ( 4400, 6600 ] 7 0.000% 100.021% ( 6600, 9900 ] 1 0.000% 100.021% ( 9900, 14000 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1124791 Average: 5.7705 StdDev: 109.81 Min: 0 Median: 1.7962 Max: 18639 Percentiles: P50: 1.80 P75: 2.82 P99: 8.66 P99.9: 13.83 P99.99: 16.50 ------------------------------------------------------ [ 0, 1 ] 71892 6.392% 6.392% # ( 1, 2 ] 616044 54.770% 61.161% ########### ( 2, 3 ] 189196 16.821% 77.982% ### ( 3, 4 ] 112931 10.040% 88.022% ## ( 4, 6 ] 109354 9.722% 97.744% ## ( 6, 10 ] 21227 1.887% 99.631% ( 10, 15 ] 3947 0.351% 99.982% ( 15, 22 ] 412 0.037% 100.019% ( 22, 34 ] 50 0.004% 100.023% ( 34, 51 ] 35 0.003% 100.026% ( 51, 76 ] 150 0.013% 100.040% ( 76, 110 ] 86 0.008% 100.047% ( 110, 170 ] 168 0.015% 100.062% ( 170, 250 ] 153 0.014% 100.076% ( 250, 380 ] 214 0.019% 100.095% ( 380, 580 ] 276 0.025% 100.119% ( 580, 870 ] 249 0.022% 100.142% ( 870, 1300 ] 157 0.014% 100.156% ( 1300, 1900 ] 129 0.011% 100.167% ( 1900, 2900 ] 189 0.017% 100.184% ( 2900, 4400 ] 310 0.028% 100.211% ( 4400, 6600 ] 96 0.009% 100.220% ( 6600, 9900 ] 52 0.005% 100.225% ( 9900, 14000 ] 6 0.001% 100.225% ( 14000, 22000 ] 5 0.000% 100.226% ** Level 2 read latency histogram (micros): Count: 206388 Average: 5.2670 StdDev: 82.56 Min: 1 Median: 1.7766 Max: 8332 Percentiles: P50: 1.78 P75: 2.77 P99: 8.64 P99.9: 14.19 P99.99: 21.05 ------------------------------------------------------ [ 0, 1 ] 17029 8.251% 8.251% ## ( 1, 2 ] 110945 53.756% 62.007% ########### ( 2, 3 ] 34691 16.809% 78.815% ### ( 3, 4 ] 20022 9.701% 88.516% ## ( 4, 6 ] 19270 9.337% 97.853% ## ( 6, 10 ] 3584 1.737% 99.590% ( 10, 15 ] 765 0.371% 99.960% ( 15, 22 ] 71 0.034% 99.995% ( 22, 34 ] 5 0.002% 99.997% ( 34, 51 ] 7 0.003% 100.000% ( 51, 76 ] 14 0.007% 100.007% ( 76, 110 ] 10 0.005% 100.012% ( 110, 170 ] 17 0.008% 100.020% ( 170, 250 ] 38 0.018% 100.039% ( 250, 380 ] 64 0.031% 100.070% ( 380, 580 ] 80 0.039% 100.109% ( 580, 870 ] 63 0.031% 100.139% ( 870, 1300 ] 39 0.019% 100.158% ( 1300, 1900 ] 32 0.016% 100.173% ( 1900, 2900 ] 35 0.017% 100.190% ( 2900, 4400 ] 46 0.022% 100.213% ( 4400, 6600 ] 12 0.006% 100.219% ( 6600, 9900 ] 2 0.001% 100.219% ** Level 3 read latency histogram (micros): Count: 409130 Average: 14.3400 StdDev: 193.25 Min: 0 Median: 1.8662 Max: 37748 Percentiles: P50: 1.87 P75: 2.98 P99: 14.65 P99.9: 1638.13 P99.99: 2997.32 ------------------------------------------------------ [ 0, 1 ] 18061 4.414% 4.414% # ( 1, 2 ] 215320 52.629% 57.043% ########### ( 2, 3 ] 74685 18.255% 75.298% #### ( 3, 4 ] 46800 11.439% 86.737% ## ( 4, 6 ] 42400 10.363% 97.100% ## ( 6, 10 ] 6578 1.608% 98.708% ( 10, 15 ] 1285 0.314% 99.022% ( 15, 22 ] 183 0.045% 99.067% ( 22, 34 ] 32 0.008% 99.075% ( 34, 51 ] 3 0.001% 99.075% ( 51, 76 ] 13 0.003% 99.079% ( 76, 110 ] 41 0.010% 99.089% ( 110, 170 ] 156 0.038% 99.127% ( 170, 250 ] 317 0.077% 99.204% ( 250, 380 ] 586 0.143% 99.347% ( 380, 580 ] 860 0.210% 99.558% ( 580, 870 ] 791 0.193% 99.751% ( 870, 1300 ] 478 0.117% 99.868% ( 1300, 1900 ] 234 0.057% 99.925% ( 1900, 2900 ] 245 0.060% 99.985% ( 2900, 4400 ] 325 0.079% 100.064% ( 4400, 6600 ] 89 0.022% 100.086% ( 6600, 9900 ] 29 0.007% 100.093% ( 9900, 14000 ] 5 0.001% 100.094% ( 14000, 22000 ] 2 0.000% 100.095% ( 22000, 33000 ] 2 0.000% 100.095% ( 33000, 50000 ] 1 0.000% 100.096% ** Level 4 read latency histogram (micros): Count: 61070 Average: 5.5206 StdDev: 74.59 Min: 1 Median: 1.7490 Max: 5413 Percentiles: P50: 1.75 P75: 2.64 P99: 9.52 P99.9: 701.04 P99.99: 3183.95 ------------------------------------------------------ [ 0, 1 ] 3791 6.208% 6.208% # ( 1, 2 ] 35706 58.467% 64.675% ############ ( 2, 3 ] 9857 16.140% 80.815% ### ( 3, 4 ] 5156 8.443% 89.258% ## ( 4, 6 ] 4998 8.184% 97.442% ## ( 6, 10 ] 1082 1.772% 99.214% ( 10, 15 ] 191 0.313% 99.527% ( 15, 22 ] 20 0.033% 99.560% ( 22, 34 ] 5 0.008% 99.568% ( 34, 51 ] 2 0.003% 99.571% ( 51, 76 ] 15 0.025% 99.596% ( 76, 110 ] 16 0.026% 99.622% ( 110, 170 ] 24 0.039% 99.661% ( 170, 250 ] 75 0.123% 99.784% ( 250, 380 ] 34 0.056% 99.840% ( 380, 580 ] 29 0.047% 99.887% ( 580, 870 ] 19 0.031% 99.918% ( 870, 1300 ] 18 0.029% 99.948% ( 1300, 1900 ] 10 0.016% 99.964% ( 1900, 2900 ] 14 0.023% 99.987% ( 2900, 4400 ] 10 0.016% 100.003% ( 4400, 6600 ] 3 0.005% 100.008% ** Level 5 read latency histogram (micros): Count: 240 Average: 1064.7583 StdDev: 1061.10 Min: 54 Median: 627.0270 Max: 5831 Percentiles: P50: 627.03 P75: 1460.00 P99: 4366.67 P99.9: 5831.00 P99.99: 5831.00 ------------------------------------------------------ ( 51, 76 ] 6 2.500% 2.500% # ( 76, 110 ] 2 0.833% 3.333% ( 110, 170 ] 3 1.250% 4.583% ( 170, 250 ] 21 8.750% 13.333% ## ( 250, 380 ] 34 14.167% 27.500% ### ( 380, 580 ] 48 20.000% 47.500% #### ( 580, 870 ] 37 15.417% 62.917% ### ( 870, 1300 ] 21 8.750% 71.667% ## ( 1300, 1900 ] 30 12.500% 84.167% ### ( 1900, 2900 ] 18 7.500% 91.667% ## ( 2900, 4400 ] 18 7.500% 99.167% ## ( 4400, 6600 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 52.0 total, 5.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 189.12 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.609 H:M:S, 47.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 196.57 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.197 H:M:S, 43.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 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.964 micros/op 167662 ops/sec 60.007 seconds 10060999 operations; 162.5 MB/s Microseconds per write: Count: 10060999 Average: 5.9643 StdDev: 411.58 Min: 0 Median: 1.7511 Max: 807164 Percentiles: P50: 1.75 P75: 2.74 P99: 9.09 P99.9: 1178.88 P99.99: 2739.12 ------------------------------------------------------ [ 0, 1 ] 1285969 12.782% 12.782% ### ( 1, 2 ] 4985666 49.554% 62.336% ########## ( 2, 3 ] 1714171 17.038% 79.374% ### ( 3, 4 ] 1370514 13.622% 92.996% ### ( 4, 6 ] 518727 5.156% 98.152% # ( 6, 10 ] 110483 1.098% 99.250% ( 10, 15 ] 33685 0.335% 99.585% ( 15, 22 ] 8734 0.087% 99.672% ( 22, 34 ] 1830 0.018% 99.690% ( 34, 51 ] 198 0.002% 99.692% ( 51, 76 ] 22 0.000% 99.692% ( 76, 110 ] 7388 0.073% 99.765% ( 110, 170 ] 2410 0.024% 99.789% ( 170, 250 ] 273 0.003% 99.792% ( 250, 380 ] 154 0.002% 99.794% ( 380, 580 ] 23 0.000% 99.794% ( 580, 870 ] 21 0.000% 99.794% ( 870, 1300 ] 14854 0.148% 99.942% ( 1300, 1900 ] 30 0.000% 99.942% ( 1900, 2900 ] 5769 0.057% 99.999% ( 2900, 4400 ] 44 0.000% 100.000% ( 4400, 6600 ] 12 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 22000, 33000 ] 4 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 3 0.000% 100.000% ( 170000, 250000 ] 9 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 172122 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 : 10060999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10382950968 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 : 490 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32202762 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 : 27208874907 rocksdb.compact.write.bytes COUNT : 27046624973 rocksdb.flush.write.bytes COUNT : 10371081091 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 : 58 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 : 266 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 : 10287350784 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3908608 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 : 27304206001 rocksdb.non.last.level.read.count COUNT : 6595159 rocksdb.block.checksum.compute.count COUNT : 6594237 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.405420 P95 : 3.883948 P99 : 7.522474 P100 : 807161.000000 COUNT : 10060999 SUM : 55273280 rocksdb.compaction.times.micros P50 : 982051.282051 P95 : 2700000.000000 P99 : 15280000.000000 P100 : 18705443.000000 COUNT : 84 SUM : 109237272 rocksdb.compaction.times.cpu_micros P50 : 818571.428571 P95 : 1853333.333333 P99 : 15280000.000000 P100 : 17303121.000000 COUNT : 84 SUM : 91297674 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 : 693.281250 P95 : 1184.437500 P99 : 11068.500000 P100 : 11639.000000 COUNT : 143 SUM : 127912 rocksdb.compaction.outfile.sync.micros P50 : 985.462963 P95 : 30305.000000 P99 : 49847.000000 P100 : 86348.000000 COUNT : 309 SUM : 1670474 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 106.923810 P95 : 1270.437500 P99 : 4612.666667 P100 : 6096.000000 COUNT : 271 SUM : 90649 rocksdb.table.open.io.micros P50 : 1092.678571 P95 : 7458.000000 P99 : 11027.500000 P100 : 27120.000000 COUNT : 490 SUM : 973228 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.519576 P95 : 7.269508 P99 : 10.745071 P100 : 37768.000000 COUNT : 6592950 SUM : 39959607 rocksdb.read.block.get.micros P50 : 401.518987 P95 : 3221.428571 P99 : 5536.666667 P100 : 26971.000000 COUNT : 980 SUM : 767024 rocksdb.write.raw.block.micros P50 : 0.513387 P95 : 0.975436 P99 : 2.720918 P100 : 44496.000000 COUNT : 9062431 SUM : 18555681 rocksdb.numfiles.in.singlecompaction P50 : 3.202532 P95 : 4.720000 P99 : 16.960000 P100 : 22.000000 COUNT : 144 SUM : 494 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.562805 P95 : 1198.811356 P99 : 2581.150566 P100 : 806970.000000 COUNT : 185479 SUM : 32219885 rocksdb.sst.read.micros P50 : 1.505742 P95 : 4.304450 P99 : 8.360456 P100 : 37748.000000 COUNT : 6595534 SUM : 26695320 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 : 10060999 SUM : 10382950968 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 : 203707.865169 P95 : 361366.666667 P99 : 735300.000000 P100 : 947756.000000 COUNT : 143 SUM : 29856040 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 : 311 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