[2024-11-17 06:51:40.707711] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-17 06:51:40.707937] [ 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_pid956734 ] Set seed to 1731822700702510 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-17 06:51:40.814760] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-17 06:51:40.851570] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-17 06:51:40.851615] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 956734' to capture a snapshot of events at runtime. [2024-11-17 06:51:40.851627] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid956734 for offline analysis/debug. [2024-11-17 06:51:40.851650] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Nov 17 06:51:45 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/17-06:51:48 ... thread 0: (1000000,1000000) ops and (335911.3,335911.3) ops/second in (2.976976,2.976976) 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/6 629.96 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 347.0 2.54 2.31 12 0.212 0 0 0.0 0.0 L2 3/2 251.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 12/0 993.28 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.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 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 92.8 309.2 4.07 3.79 14 0.291 383K 212 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.4 92.8 309.2 4.07 3.79 14 0.291 383K 212 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 347.0 2.54 2.31 12 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 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.23 GB write, 395.43 MB/s write, 0.37 GB read, 118.64 MB/s read, 4.1 seconds Interval compaction: 1.23 GB write, 422.80 MB/s write, 0.37 GB read, 126.85 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 111340 Average: 1.9128 StdDev: 19.42 Min: 0 Median: 1.2208 Max: 2960 Percentiles: P50: 1.22 P75: 1.66 P99: 3.89 P99.9: 9.83 P99.99: 374.19 ------------------------------------------------------ [ 0, 1 ] 41549 37.317% 37.317% ####### ( 1, 2 ] 63945 57.432% 94.749% ########### ( 2, 3 ] 3605 3.238% 97.987% # ( 3, 4 ] 1276 1.146% 99.133% ( 4, 6 ] 647 0.581% 99.714% ( 6, 10 ] 218 0.196% 99.910% ( 10, 15 ] 60 0.054% 99.964% ( 15, 22 ] 15 0.013% 99.978% ( 22, 34 ] 2 0.002% 99.979% ( 51, 76 ] 1 0.001% 99.980% ( 110, 170 ] 6 0.005% 99.986% ( 170, 250 ] 4 0.004% 99.989% ( 250, 380 ] 3 0.003% 99.992% ( 380, 580 ] 1 0.001% 99.993% ( 580, 870 ] 2 0.002% 99.995% ( 870, 1300 ] 3 0.003% 99.997% ( 1900, 2900 ] 4 0.004% 100.001% ( 2900, 4400 ] 1 0.001% 100.002% ** Level 2 read latency histogram (micros): Count: 61848 Average: 2.0187 StdDev: 17.36 Min: 1 Median: 1.2613 Max: 1921 Percentiles: P50: 1.26 P75: 1.69 P99: 4.96 P99.9: 10.14 P99.99: 843.20 ------------------------------------------------------ [ 0, 1 ] 21576 34.886% 34.886% ####### ( 1, 2 ] 35775 57.843% 92.729% ############ ( 2, 3 ] 2393 3.869% 96.598% # ( 3, 4 ] 1182 1.911% 98.509% ( 4, 6 ] 631 1.020% 99.529% ( 6, 10 ] 228 0.369% 99.898% ( 10, 15 ] 40 0.065% 99.963% ( 15, 22 ] 6 0.010% 99.973% ( 22, 34 ] 1 0.002% 99.974% ( 110, 170 ] 1 0.002% 99.976% ( 250, 380 ] 4 0.006% 99.982% ( 380, 580 ] 3 0.005% 99.987% ( 580, 870 ] 2 0.003% 99.990% ( 870, 1300 ] 1 0.002% 99.992% ( 1300, 1900 ] 4 0.006% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 50 Average: 1331.5400 StdDev: 927.18 Min: 191 Median: 1128.0000 Max: 3491 Percentiles: P50: 1128.00 P75: 2025.00 P99: 3491.00 P99.9: 3491.00 P99.99: 3491.00 ------------------------------------------------------ ( 170, 250 ] 2 4.000% 4.000% # ( 250, 380 ] 5 10.000% 14.000% ## ( 380, 580 ] 10 20.000% 34.000% #### ( 580, 870 ] 5 10.000% 44.000% ## ( 870, 1300 ] 5 10.000% 54.000% ## ( 1300, 1900 ] 9 18.000% 72.000% #### ( 1900, 2900 ] 12 24.000% 96.000% ##### ( 2900, 4400 ] 2 4.000% 100.000% # ** Level 4 read latency histogram (micros): Count: 20 Average: 1550.8000 StdDev: 782.09 Min: 399 Median: 1400.0000 Max: 3289 Percentiles: P50: 1400.00 P75: 1900.00 P99: 3289.00 P99.9: 3289.00 P99.99: 3289.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 3 15.000% 20.000% ### ( 870, 1300 ] 5 25.000% 45.000% ##### ( 1300, 1900 ] 6 30.000% 75.000% ###### ( 1900, 2900 ] 3 15.000% 90.000% ### ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 308.95 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.427 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.29 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.427 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-06:51:51 ... thread 0: (1000000,2000000) ops and (322266.5,328947.5) ops/second in (3.103022,6.079998) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/10 1.23 GB 6.3 0.6 0.0 0.6 2.4 1.8 0.0 1.3 73.9 320.3 7.67 7.08 28 0.274 575K 600 0.0 0.0 L1 1/1 3.80 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 236.3 235.9 1.60 1.55 1 1.600 383K 592 0.0 0.0 L2 2/1 54.95 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 18/8 961.33 MB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 229.7 229.7 1.08 1.02 1 1.084 252K 0 0.0 0.0 L4 170/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 152.2 152.2 1.47 1.11 1 1.474 227K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/20 97.98 GB 0.0 1.8 1.0 0.7 3.6 2.9 2.1 1.9 134.5 275.8 13.36 12.24 33 0.405 1823K 1404 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.6 2.9 2.0 1.9 134.5 275.8 13.36 12.24 33 0.405 1823K 1404 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 1.0 0.7 1.8 1.0 0.0 0.0 226.9 226.7 7.92 7.35 7 1.131 1823K 1404 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 347.2 5.44 4.90 26 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): 6.3 total, 6.1 interval Flush(GB): cumulative 1.846, interval 1.846 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.60 GB write, 585.95 MB/s write, 1.75 GB read, 285.66 MB/s read, 13.4 seconds Interval compaction: 3.60 GB write, 605.81 MB/s write, 1.75 GB read, 295.34 MB/s read, 13.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 387292 Average: 2.1714 StdDev: 14.17 Min: 0 Median: 1.4435 Max: 4069 Percentiles: P50: 1.44 P75: 1.84 P99: 5.69 P99.9: 10.59 P99.99: 17.11 ------------------------------------------------------ [ 0, 1 ] 85622 22.108% 22.108% #### ( 1, 2 ] 243571 62.891% 84.999% ############# ( 2, 3 ] 30989 8.001% 93.000% ## ( 3, 4 ] 15022 3.879% 96.879% # ( 4, 6 ] 9733 2.513% 99.392% # ( 6, 10 ] 1924 0.497% 99.889% ( 10, 15 ] 377 0.097% 99.986% ( 15, 22 ] 54 0.014% 100.000% ( 22, 34 ] 5 0.001% 100.001% ( 34, 51 ] 4 0.001% 100.002% ( 51, 76 ] 2 0.001% 100.003% ( 110, 170 ] 11 0.003% 100.006% ( 170, 250 ] 11 0.003% 100.009% ( 250, 380 ] 8 0.002% 100.011% ( 380, 580 ] 1 0.000% 100.011% ( 580, 870 ] 7 0.002% 100.013% ( 870, 1300 ] 11 0.003% 100.015% ( 1900, 2900 ] 5 0.001% 100.017% ( 2900, 4400 ] 2 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 26 Average: 189.1154 StdDev: 396.14 Min: 1 Median: 2.0000 Max: 1770 Percentiles: P50: 2.00 P75: 210.00 P99: 1744.00 P99.9: 1770.00 P99.99: 1770.00 ------------------------------------------------------ [ 0, 1 ] 7 26.923% 26.923% ##### ( 1, 2 ] 6 23.077% 50.000% ##### ( 2, 3 ] 3 11.538% 61.538% ## ( 3, 4 ] 1 3.846% 65.385% # ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 250, 380 ] 2 7.692% 84.615% ## ( 380, 580 ] 2 7.692% 92.308% ## ( 870, 1300 ] 1 3.846% 96.154% # ( 1300, 1900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95831 Average: 2.0458 StdDev: 13.96 Min: 1 Median: 1.3432 Max: 1921 Percentiles: P50: 1.34 P75: 1.76 P99: 5.32 P99.9: 9.79 P99.99: 474.46 ------------------------------------------------------ [ 0, 1 ] 28045 29.265% 29.265% ###### ( 1, 2 ] 57894 60.413% 89.678% ############ ( 2, 3 ] 5239 5.467% 95.145% # ( 3, 4 ] 2748 2.868% 98.012% # ( 4, 6 ] 1435 1.497% 99.510% ( 6, 10 ] 395 0.412% 99.922% ( 10, 15 ] 50 0.052% 99.974% ( 15, 22 ] 7 0.007% 99.981% ( 22, 34 ] 1 0.001% 99.982% ( 51, 76 ] 1 0.001% 99.983% ( 110, 170 ] 1 0.001% 99.984% ( 250, 380 ] 4 0.004% 99.989% ( 380, 580 ] 3 0.003% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 4 0.004% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 180492 Average: 3.3185 StdDev: 30.16 Min: 1 Median: 1.6400 Max: 3491 Percentiles: P50: 1.64 P75: 2.17 P99: 9.08 P99.9: 161.70 P99.99: 508.96 ------------------------------------------------------ [ 0, 1 ] 18621 10.317% 10.317% ## ( 1, 2 ] 111916 62.006% 72.323% ############ ( 2, 3 ] 28098 15.567% 87.890% ### ( 3, 4 ] 9252 5.126% 93.016% # ( 4, 6 ] 8495 4.707% 97.723% # ( 6, 10 ] 2990 1.657% 99.379% ( 10, 15 ] 565 0.313% 99.693% ( 15, 22 ] 89 0.049% 99.742% ( 22, 34 ] 38 0.021% 99.763% ( 34, 51 ] 6 0.003% 99.766% ( 76, 110 ] 64 0.035% 99.802% ( 110, 170 ] 206 0.114% 99.916% ( 170, 250 ] 57 0.032% 99.947% ( 250, 380 ] 46 0.025% 99.973% ( 380, 580 ] 48 0.027% 99.999% ( 580, 870 ] 19 0.011% 100.010% ( 870, 1300 ] 9 0.005% 100.015% ( 1300, 1900 ] 10 0.006% 100.020% ( 1900, 2900 ] 12 0.007% 100.027% ( 2900, 4400 ] 2 0.001% 100.028% ** Level 4 read latency histogram (micros): Count: 310 Average: 107.7742 StdDev: 428.82 Min: 1 Median: 2.6533 Max: 3289 Percentiles: P50: 2.65 P75: 7.67 P99: 2533.33 P99.9: 3289.00 P99.99: 3289.00 ------------------------------------------------------ [ 0, 1 ] 29 9.355% 9.355% ## ( 1, 2 ] 77 24.839% 34.194% ##### ( 2, 3 ] 75 24.194% 58.387% ##### ( 3, 4 ] 36 11.613% 70.000% ## ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 6 1.935% 76.129% ( 10, 15 ] 14 4.516% 80.645% # ( 15, 22 ] 30 9.677% 90.323% ## ( 22, 34 ] 7 2.258% 92.581% ( 170, 250 ] 2 0.645% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 3 0.968% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 6 1.935% 98.387% ( 1900, 2900 ] 3 0.968% 99.355% ( 2900, 4400 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 722.3750 StdDev: 760.48 Min: 97 Median: 354.0000 Max: 2576 Percentiles: P50: 354.00 P75: 1085.00 P99: 2576.00 P99.9: 2576.00 P99.99: 2576.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 5 12.500% 22.500% ### ( 170, 250 ] 7 17.500% 40.000% #### ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 2 5.000% 77.500% # ( 1300, 1900 ] 5 12.500% 90.000% ### ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 313.00 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.871 H:M:S, 13.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 317.17 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.443 H:M:S, 14.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-06:51:54 ... thread 0: (1000000,3000000) ops and (326543.7,328142.3) ops/second in (3.062377,9.142375) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.29 GB 107.0 1.4 0.0 1.4 4.2 2.8 0.0 1.5 105.3 311.1 13.77 12.82 44 0.313 1471K 1589 0.0 0.0 L1 5/0 452.61 MB 45.3 1.2 1.2 0.0 1.2 1.2 0.2 1.0 232.8 232.1 5.43 5.28 2 2.713 1282K 3702 0.0 0.0 L2 5/5 481.49 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 15/9 962.35 MB 0.7 0.8 0.2 0.6 0.8 0.2 0.4 3.4 223.7 223.3 3.88 3.63 2 1.938 880K 1642 0.0 0.0 L4 170/0 9.51 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 152.2 152.2 1.47 1.11 1 1.474 227K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/18 98.90 GB 0.0 4.1 1.9 2.2 6.8 4.6 2.5 2.5 160.4 268.8 26.07 24.32 51 0.511 4245K 7145 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.9 2.2 6.8 4.6 2.4 2.5 160.4 268.8 26.07 24.32 51 0.511 4245K 7145 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.1 1.9 2.2 4.1 1.9 0.0 0.0 233.2 232.8 17.93 17.03 12 1.494 4245K 7145 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 348.1 8.14 7.29 39 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): 9.4 total, 9.1 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.84 GB write, 749.52 MB/s write, 4.08 GB read, 447.15 MB/s read, 26.1 seconds Interval compaction: 6.84 GB write, 766.42 MB/s write, 4.08 GB read, 457.24 MB/s read, 26.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: 796891 Average: 2.1975 StdDev: 11.99 Min: 0 Median: 1.4847 Max: 4069 Percentiles: P50: 1.48 P75: 1.87 P99: 5.66 P99.9: 9.88 P99.99: 14.05 ------------------------------------------------------ [ 0, 1 ] 146758 18.416% 18.416% #### ( 1, 2 ] 519247 65.159% 83.575% ############# ( 2, 3 ] 71502 8.973% 92.548% ## ( 3, 4 ] 33362 4.187% 96.735% # ( 4, 6 ] 21718 2.725% 99.460% # ( 6, 10 ] 3621 0.454% 99.914% ( 10, 15 ] 747 0.094% 100.008% ( 15, 22 ] 90 0.011% 100.019% ( 22, 34 ] 6 0.001% 100.020% ( 34, 51 ] 6 0.001% 100.021% ( 51, 76 ] 4 0.001% 100.021% ( 110, 170 ] 15 0.002% 100.023% ( 170, 250 ] 19 0.002% 100.026% ( 250, 380 ] 11 0.001% 100.027% ( 380, 580 ] 5 0.001% 100.028% ( 580, 870 ] 10 0.001% 100.029% ( 870, 1300 ] 18 0.002% 100.031% ( 1900, 2900 ] 6 0.001% 100.032% ( 2900, 4400 ] 4 0.001% 100.032% ** Level 1 read latency histogram (micros): Count: 51646 Average: 3.5495 StdDev: 27.23 Min: 0 Median: 1.7648 Max: 2878 Percentiles: P50: 1.76 P75: 2.65 P99: 9.26 P99.9: 88.91 P99.99: 190.46 ------------------------------------------------------ [ 0, 1 ] 2900 5.615% 5.615% # ( 1, 2 ] 29972 58.034% 63.649% ############ ( 2, 3 ] 9062 17.546% 81.195% #### ( 3, 4 ] 4265 8.258% 89.453% ## ( 4, 6 ] 4054 7.850% 97.303% ## ( 6, 10 ] 1078 2.087% 99.390% ( 10, 15 ] 217 0.420% 99.810% ( 15, 22 ] 35 0.068% 99.878% ( 22, 34 ] 4 0.008% 99.886% ( 76, 110 ] 22 0.043% 99.928% ( 110, 170 ] 29 0.056% 99.985% ( 170, 250 ] 15 0.029% 100.014% ( 250, 380 ] 15 0.029% 100.043% ( 380, 580 ] 16 0.031% 100.074% ( 580, 870 ] 11 0.021% 100.095% ( 870, 1300 ] 4 0.008% 100.103% ( 1300, 1900 ] 3 0.006% 100.108% ( 1900, 2900 ] 2 0.004% 100.112% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 190574 Average: 3.3030 StdDev: 29.85 Min: 1 Median: 1.6375 Max: 3491 Percentiles: P50: 1.64 P75: 2.16 P99: 9.05 P99.9: 161.68 P99.99: 525.93 ------------------------------------------------------ [ 0, 1 ] 19750 10.363% 10.363% ## ( 1, 2 ] 118491 62.176% 72.539% ############ ( 2, 3 ] 29305 15.377% 87.917% ### ( 3, 4 ] 9887 5.188% 93.105% # ( 4, 6 ] 8849 4.643% 97.748% # ( 6, 10 ] 3129 1.642% 99.390% ( 10, 15 ] 594 0.312% 99.701% ( 15, 22 ] 92 0.048% 99.750% ( 22, 34 ] 38 0.020% 99.770% ( 34, 51 ] 6 0.003% 99.773% ( 51, 76 ] 1 0.001% 99.773% ( 76, 110 ] 64 0.034% 99.807% ( 110, 170 ] 206 0.108% 99.915% ( 170, 250 ] 57 0.030% 99.945% ( 250, 380 ] 48 0.025% 99.970% ( 380, 580 ] 52 0.027% 99.997% ( 580, 870 ] 19 0.010% 100.007% ( 870, 1300 ] 13 0.007% 100.014% ( 1300, 1900 ] 10 0.005% 100.019% ( 1900, 2900 ] 12 0.006% 100.026% ( 2900, 4400 ] 2 0.001% 100.027% ** Level 4 read latency histogram (micros): Count: 310 Average: 107.7742 StdDev: 428.82 Min: 1 Median: 2.6533 Max: 3289 Percentiles: P50: 2.65 P75: 7.67 P99: 2533.33 P99.9: 3289.00 P99.99: 3289.00 ------------------------------------------------------ [ 0, 1 ] 29 9.355% 9.355% ## ( 1, 2 ] 77 24.839% 34.194% ##### ( 2, 3 ] 75 24.194% 58.387% ##### ( 3, 4 ] 36 11.613% 70.000% ## ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 6 1.935% 76.129% ( 10, 15 ] 14 4.516% 80.645% # ( 15, 22 ] 30 9.677% 90.323% ## ( 22, 34 ] 7 2.258% 92.581% ( 170, 250 ] 2 0.645% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 3 0.968% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 6 1.935% 98.387% ( 1900, 2900 ] 3 0.968% 99.355% ( 2900, 4400 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 722.3750 StdDev: 760.48 Min: 97 Median: 354.0000 Max: 2576 Percentiles: P50: 354.00 P75: 1085.00 P99: 2576.00 P99.9: 2576.00 P99.99: 2576.00 ------------------------------------------------------ ( 76, 110 ] 4 10.000% 10.000% ## ( 110, 170 ] 5 12.500% 22.500% ### ( 170, 250 ] 7 17.500% 40.000% #### ( 250, 380 ] 5 12.500% 52.500% ### ( 380, 580 ] 4 10.000% 62.500% ## ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 2 5.000% 77.500% # ( 1300, 1900 ] 5 12.500% 90.000% ### ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.4 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 315.75 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.285 H:M:S, 13.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.38 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.415 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/17-06:51:57 ... thread 0: (1000000,4000000) ops and (323645.8,327006.5) ops/second in (3.089798,12.232173) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/12 2.27 GB 56.6 2.2 0.0 2.2 6.0 3.8 0.0 1.6 114.0 307.0 19.89 18.55 61 0.326 2302K 2418 0.0 0.0 L1 5/5 452.61 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 232.8 232.1 5.43 5.28 2 2.713 1282K 3702 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 20/0 954.50 MB 1.0 1.5 0.7 0.8 1.5 0.7 0.4 2.1 218.2 217.7 7.18 6.75 5 1.435 1590K 3394 0.0 0.0 L4 170/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 152.2 152.2 1.47 1.11 1 1.474 227K 0 0.0 0.0 L5 1052/0 86.62 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1261/17 99.88 GB 0.0 5.6 2.3 3.2 9.3 6.1 3.3 2.5 160.5 268.5 35.50 33.17 71 0.500 5786K 9726 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.3 3.2 9.3 6.1 3.2 2.5 160.5 268.5 35.50 33.17 71 0.500 5786K 9726 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 2.3 3.2 5.6 2.3 0.0 0.0 233.1 232.7 24.44 23.30 18 1.358 5786K 9726 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 347.5 11.06 9.88 53 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): 12.4 total, 12.2 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.31 GB write, 766.17 MB/s write, 5.57 GB read, 458.09 MB/s read, 35.5 seconds Interval compaction: 9.31 GB write, 779.08 MB/s write, 5.57 GB read, 465.81 MB/s read, 35.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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1117495 Average: 2.2080 StdDev: 11.71 Min: 0 Median: 1.4916 Max: 4069 Percentiles: P50: 1.49 P75: 1.87 P99: 5.65 P99.9: 9.87 P99.99: 14.13 ------------------------------------------------------ [ 0, 1 ] 197122 17.640% 17.640% #### ( 1, 2 ] 735640 65.829% 83.469% ############# ( 2, 3 ] 102464 9.169% 92.638% ## ( 3, 4 ] 46527 4.164% 96.802% # ( 4, 6 ] 29739 2.661% 99.463% # ( 6, 10 ] 5057 0.453% 99.915% ( 10, 15 ] 1010 0.090% 100.006% ( 15, 22 ] 114 0.010% 100.016% ( 22, 34 ] 10 0.001% 100.017% ( 34, 51 ] 7 0.001% 100.017% ( 51, 76 ] 5 0.000% 100.018% ( 76, 110 ] 24 0.002% 100.020% ( 110, 170 ] 26 0.002% 100.022% ( 170, 250 ] 24 0.002% 100.025% ( 250, 380 ] 21 0.002% 100.026% ( 380, 580 ] 7 0.001% 100.027% ( 580, 870 ] 18 0.002% 100.029% ( 870, 1300 ] 24 0.002% 100.031% ( 1300, 1900 ] 2 0.000% 100.031% ( 1900, 2900 ] 8 0.001% 100.032% ( 2900, 4400 ] 5 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 171939 Average: 2.6517 StdDev: 14.96 Min: 0 Median: 1.6197 Max: 2878 Percentiles: P50: 1.62 P75: 2.02 P99: 7.67 P99.9: 14.04 P99.99: 111.61 ------------------------------------------------------ [ 0, 1 ] 16680 9.701% 9.701% ## ( 1, 2 ] 111807 65.027% 74.728% ############# ( 2, 3 ] 23204 13.495% 88.224% ### ( 3, 4 ] 9732 5.660% 93.884% # ( 4, 6 ] 7922 4.607% 98.491% # ( 6, 10 ] 2095 1.218% 99.710% ( 10, 15 ] 405 0.236% 99.945% ( 15, 22 ] 50 0.029% 99.974% ( 22, 34 ] 4 0.002% 99.977% ( 76, 110 ] 22 0.013% 99.990% ( 110, 170 ] 30 0.017% 100.007% ( 170, 250 ] 15 0.009% 100.016% ( 250, 380 ] 15 0.009% 100.024% ( 380, 580 ] 16 0.009% 100.034% ( 580, 870 ] 11 0.006% 100.040% ( 870, 1300 ] 4 0.002% 100.042% ( 1300, 1900 ] 3 0.002% 100.044% ( 1900, 2900 ] 2 0.001% 100.045% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 191327 Average: 3.3493 StdDev: 30.37 Min: 1 Median: 1.6374 Max: 3491 Percentiles: P50: 1.64 P75: 2.16 P99: 9.09 P99.9: 168.45 P99.99: 545.54 ------------------------------------------------------ [ 0, 1 ] 19853 10.376% 10.376% ## ( 1, 2 ] 118933 62.162% 72.539% ############ ( 2, 3 ] 29390 15.361% 87.900% ### ( 3, 4 ] 9941 5.196% 93.096% # ( 4, 6 ] 8871 4.637% 97.732% # ( 6, 10 ] 3140 1.641% 99.373% ( 10, 15 ] 600 0.314% 99.687% ( 15, 22 ] 92 0.048% 99.735% ( 22, 34 ] 42 0.022% 99.757% ( 34, 51 ] 6 0.003% 99.760% ( 51, 76 ] 2 0.001% 99.761% ( 76, 110 ] 65 0.034% 99.795% ( 110, 170 ] 206 0.108% 99.903% ( 170, 250 ] 71 0.037% 99.940% ( 250, 380 ] 52 0.027% 99.967% ( 380, 580 ] 53 0.028% 99.995% ( 580, 870 ] 21 0.011% 100.006% ( 870, 1300 ] 15 0.008% 100.014% ( 1300, 1900 ] 11 0.006% 100.019% ( 1900, 2900 ] 12 0.006% 100.026% ( 2900, 4400 ] 2 0.001% 100.027% ** Level 4 read latency histogram (micros): Count: 310 Average: 107.7742 StdDev: 428.82 Min: 1 Median: 2.6533 Max: 3289 Percentiles: P50: 2.65 P75: 7.67 P99: 2533.33 P99.9: 3289.00 P99.99: 3289.00 ------------------------------------------------------ [ 0, 1 ] 29 9.355% 9.355% ## ( 1, 2 ] 77 24.839% 34.194% ##### ( 2, 3 ] 75 24.194% 58.387% ##### ( 3, 4 ] 36 11.613% 70.000% ## ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 6 1.935% 76.129% ( 10, 15 ] 14 4.516% 80.645% # ( 15, 22 ] 30 9.677% 90.323% ## ( 22, 34 ] 7 2.258% 92.581% ( 170, 250 ] 2 0.645% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 3 0.968% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 6 1.935% 98.387% ( 1900, 2900 ] 3 0.968% 99.355% ( 2900, 4400 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 752.0333 StdDev: 841.89 Min: 87 Median: 347.5000 Max: 3741 Percentiles: P50: 347.50 P75: 1156.67 P99: 3500.00 P99.9: 3741.00 P99.99: 3741.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 11 18.333% 26.667% #### ( 170, 250 ] 8 13.333% 40.000% ### ( 250, 380 ] 8 13.333% 53.333% ### ( 380, 580 ] 6 10.000% 63.333% ## ( 580, 870 ] 5 8.333% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 8 13.333% 90.000% ### ( 1900, 2900 ] 5 8.333% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.4 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 316.44 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.730 H:M:S, 13.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.53 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.444 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-06:52:00 ... thread 0: (1000000,5000000) ops and (329149.1,327432.8) ops/second in (3.038137,15.270310) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/12 3.20 GB 151.0 3.1 0.0 3.1 7.7 4.7 0.0 1.7 121.2 305.3 25.99 24.29 77 0.338 3198K 3399 0.0 0.0 L1 5/5 452.61 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 232.8 232.1 5.43 5.28 2 2.713 1282K 3702 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 20/0 954.50 MB 1.0 1.5 0.7 0.8 1.5 0.7 0.4 2.1 218.2 217.7 7.18 6.75 5 1.435 1590K 3394 0.0 0.0 L4 170/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 152.2 152.2 1.47 1.11 1 1.474 227K 0 0.0 0.0 L5 1052/0 86.62 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1265/17 100.80 GB 0.0 6.4 2.3 4.1 11.1 7.0 3.3 2.4 158.2 273.0 41.60 38.91 87 0.478 6682K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.4 2.3 4.1 11.1 7.0 3.2 2.4 158.2 273.0 41.60 38.91 87 0.478 6682K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.4 2.3 4.1 6.4 2.3 0.0 0.0 236.5 236.1 27.83 26.62 21 1.325 6682K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 347.7 13.77 12.29 66 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): 15.5 total, 15.3 interval Flush(GB): cumulative 4.675, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.09 GB write, 733.74 MB/s write, 6.43 GB read, 425.15 MB/s read, 41.6 seconds Interval compaction: 11.09 GB write, 743.65 MB/s write, 6.43 GB read, 430.89 MB/s read, 41.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 18, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1473272 Average: 2.2394 StdDev: 11.98 Min: 0 Median: 1.4910 Max: 4069 Percentiles: P50: 1.49 P75: 1.87 P99: 5.68 P99.9: 9.98 P99.99: 14.74 ------------------------------------------------------ [ 0, 1 ] 257885 17.504% 17.504% #### ( 1, 2 ] 975092 66.185% 83.690% ############# ( 2, 3 ] 134321 9.117% 92.807% ## ( 3, 4 ] 59556 4.042% 96.849% # ( 4, 6 ] 37709 2.560% 99.409% # ( 6, 10 ] 7282 0.494% 99.903% ( 10, 15 ] 1351 0.092% 99.995% ( 15, 22 ] 149 0.010% 100.005% ( 22, 34 ] 13 0.001% 100.006% ( 34, 51 ] 8 0.001% 100.006% ( 51, 76 ] 6 0.000% 100.007% ( 76, 110 ] 50 0.003% 100.010% ( 110, 170 ] 127 0.009% 100.019% ( 170, 250 ] 77 0.005% 100.024% ( 250, 380 ] 47 0.003% 100.027% ( 380, 580 ] 31 0.002% 100.029% ( 580, 870 ] 32 0.002% 100.031% ( 870, 1300 ] 33 0.002% 100.034% ( 1300, 1900 ] 9 0.001% 100.034% ( 1900, 2900 ] 10 0.001% 100.035% ( 2900, 4400 ] 5 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 228023 Average: 2.6578 StdDev: 16.05 Min: 0 Median: 1.5990 Max: 3847 Percentiles: P50: 1.60 P75: 1.98 P99: 7.94 P99.9: 15.46 P99.99: 165.70 ------------------------------------------------------ [ 0, 1 ] 23983 10.518% 10.518% ## ( 1, 2 ] 150294 65.912% 76.430% ############# ( 2, 3 ] 28843 12.649% 89.079% ### ( 3, 4 ] 11815 5.181% 94.260% # ( 4, 6 ] 9329 4.091% 98.351% # ( 6, 10 ] 3056 1.340% 99.692% ( 10, 15 ] 471 0.207% 99.898% ( 15, 22 ] 60 0.026% 99.925% ( 22, 34 ] 4 0.002% 99.926% ( 51, 76 ] 1 0.000% 99.927% ( 76, 110 ] 95 0.042% 99.968% ( 110, 170 ] 53 0.023% 99.992% ( 170, 250 ] 27 0.012% 100.004% ( 250, 380 ] 21 0.009% 100.013% ( 380, 580 ] 25 0.011% 100.024% ( 580, 870 ] 14 0.006% 100.030% ( 870, 1300 ] 4 0.002% 100.032% ( 1300, 1900 ] 3 0.001% 100.033% ( 1900, 2900 ] 2 0.001% 100.034% ( 2900, 4400 ] 1 0.000% 100.034% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 191327 Average: 3.3493 StdDev: 30.37 Min: 1 Median: 1.6374 Max: 3491 Percentiles: P50: 1.64 P75: 2.16 P99: 9.09 P99.9: 168.45 P99.99: 545.54 ------------------------------------------------------ [ 0, 1 ] 19853 10.376% 10.376% ## ( 1, 2 ] 118933 62.162% 72.539% ############ ( 2, 3 ] 29390 15.361% 87.900% ### ( 3, 4 ] 9941 5.196% 93.096% # ( 4, 6 ] 8871 4.637% 97.732% # ( 6, 10 ] 3140 1.641% 99.373% ( 10, 15 ] 600 0.314% 99.687% ( 15, 22 ] 92 0.048% 99.735% ( 22, 34 ] 42 0.022% 99.757% ( 34, 51 ] 6 0.003% 99.760% ( 51, 76 ] 2 0.001% 99.761% ( 76, 110 ] 65 0.034% 99.795% ( 110, 170 ] 206 0.108% 99.903% ( 170, 250 ] 71 0.037% 99.940% ( 250, 380 ] 52 0.027% 99.967% ( 380, 580 ] 53 0.028% 99.995% ( 580, 870 ] 21 0.011% 100.006% ( 870, 1300 ] 15 0.008% 100.014% ( 1300, 1900 ] 11 0.006% 100.019% ( 1900, 2900 ] 12 0.006% 100.026% ( 2900, 4400 ] 2 0.001% 100.027% ** Level 4 read latency histogram (micros): Count: 310 Average: 107.7742 StdDev: 428.82 Min: 1 Median: 2.6533 Max: 3289 Percentiles: P50: 2.65 P75: 7.67 P99: 2533.33 P99.9: 3289.00 P99.99: 3289.00 ------------------------------------------------------ [ 0, 1 ] 29 9.355% 9.355% ## ( 1, 2 ] 77 24.839% 34.194% ##### ( 2, 3 ] 75 24.194% 58.387% ##### ( 3, 4 ] 36 11.613% 70.000% ## ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 6 1.935% 76.129% ( 10, 15 ] 14 4.516% 80.645% # ( 15, 22 ] 30 9.677% 90.323% ## ( 22, 34 ] 7 2.258% 92.581% ( 170, 250 ] 2 0.645% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 3 0.968% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 6 1.935% 98.387% ( 1900, 2900 ] 3 0.968% 99.355% ( 2900, 4400 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 752.0333 StdDev: 841.89 Min: 87 Median: 347.5000 Max: 3741 Percentiles: P50: 347.50 P75: 1156.67 P99: 3500.00 P99.9: 3741.00 P99.99: 3741.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 11 18.333% 26.667% #### ( 170, 250 ] 8 13.333% 40.000% ### ( 250, 380 ] 8 13.333% 53.333% ### ( 380, 580 ] 6 10.000% 63.333% ## ( 580, 870 ] 5 8.333% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 8 13.333% 90.000% ### ( 1900, 2900 ] 5 8.333% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.5 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 317.91 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.140 H:M:S, 13.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.94 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.410 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-06:52:04 ... thread 0: (1000000,6000000) ops and (251286.2,311691.0) ops/second in (3.979526,19.249836) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/15 2.70 GB 0.0 3.9 0.0 3.9 9.5 5.6 0.0 1.7 125.6 304.1 32.10 30.04 94 0.341 4093K 4363 0.0 0.0 L1 17/17 1.84 GB 0.0 3.1 2.6 0.4 3.1 2.6 0.2 1.2 225.9 224.5 14.00 13.50 3 4.668 3212K 19K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 20/0 954.50 MB 1.0 1.5 0.7 0.8 1.5 0.7 0.4 2.1 218.2 217.7 7.18 6.75 5 1.435 1590K 3394 0.0 0.0 L4 170/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 152.2 152.2 1.47 1.11 1 1.474 227K 0 0.0 0.0 L5 1052/0 86.62 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/32 101.71 GB 0.0 9.1 3.8 5.4 14.7 9.3 3.3 2.6 166.4 267.7 56.28 52.87 105 0.536 9507K 27K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.1 3.8 5.4 14.7 9.3 3.2 2.6 166.4 267.7 56.28 52.87 105 0.536 9507K 27K 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 9.1 3.8 5.4 9.1 3.7 0.0 0.0 235.3 234.6 39.80 38.15 25 1.592 9507K 27K 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 347.7 16.49 14.72 80 0.206 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): 19.5 total, 19.3 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: 14.71 GB write, 774.36 MB/s write, 9.14 GB read, 481.18 MB/s read, 56.3 seconds Interval compaction: 14.71 GB write, 782.65 MB/s write, 9.14 GB read, 486.33 MB/s read, 56.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 7, total-stops: 19, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1807723 Average: 2.2394 StdDev: 12.23 Min: 0 Median: 1.4795 Max: 4069 Percentiles: P50: 1.48 P75: 1.86 P99: 5.69 P99.9: 10.44 P99.99: 21.51 ------------------------------------------------------ [ 0, 1 ] 331200 18.321% 18.321% #### ( 1, 2 ] 1194264 66.065% 84.386% ############# ( 2, 3 ] 158631 8.775% 93.161% ## ( 3, 4 ] 68949 3.814% 96.975% # ( 4, 6 ] 43272 2.394% 99.369% ( 6, 10 ] 9458 0.523% 99.892% ( 10, 15 ] 1613 0.089% 99.981% ( 15, 22 ] 169 0.009% 99.991% ( 22, 34 ] 19 0.001% 99.992% ( 34, 51 ] 10 0.001% 99.992% ( 51, 76 ] 12 0.001% 99.993% ( 76, 110 ] 193 0.011% 100.004% ( 110, 170 ] 212 0.012% 100.015% ( 170, 250 ] 106 0.006% 100.021% ( 250, 380 ] 69 0.004% 100.025% ( 380, 580 ] 54 0.003% 100.028% ( 580, 870 ] 48 0.003% 100.031% ( 870, 1300 ] 37 0.002% 100.033% ( 1300, 1900 ] 11 0.001% 100.033% ( 1900, 2900 ] 12 0.001% 100.034% ( 2900, 4400 ] 7 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 302148 Average: 2.7734 StdDev: 19.21 Min: 0 Median: 1.5620 Max: 4221 Percentiles: P50: 1.56 P75: 1.94 P99: 8.13 P99.9: 114.56 P99.99: 376.78 ------------------------------------------------------ [ 0, 1 ] 39208 12.976% 12.976% ### ( 1, 2 ] 199046 65.877% 78.853% ############# ( 2, 3 ] 34312 11.356% 90.209% ## ( 3, 4 ] 13796 4.566% 94.775% # ( 4, 6 ] 10547 3.491% 98.266% # ( 6, 10 ] 4170 1.380% 99.646% ( 10, 15 ] 538 0.178% 99.824% ( 15, 22 ] 65 0.022% 99.846% ( 22, 34 ] 5 0.002% 99.847% ( 34, 51 ] 1 0.000% 99.848% ( 51, 76 ] 1 0.000% 99.848% ( 76, 110 ] 144 0.048% 99.896% ( 110, 170 ] 169 0.056% 99.952% ( 170, 250 ] 68 0.023% 99.974% ( 250, 380 ] 49 0.016% 99.990% ( 380, 580 ] 58 0.019% 100.010% ( 580, 870 ] 28 0.009% 100.019% ( 870, 1300 ] 12 0.004% 100.023% ( 1300, 1900 ] 5 0.002% 100.024% ( 1900, 2900 ] 2 0.001% 100.025% ( 2900, 4400 ] 2 0.001% 100.026% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 191327 Average: 3.3493 StdDev: 30.37 Min: 1 Median: 1.6374 Max: 3491 Percentiles: P50: 1.64 P75: 2.16 P99: 9.09 P99.9: 168.45 P99.99: 545.54 ------------------------------------------------------ [ 0, 1 ] 19853 10.376% 10.376% ## ( 1, 2 ] 118933 62.162% 72.539% ############ ( 2, 3 ] 29390 15.361% 87.900% ### ( 3, 4 ] 9941 5.196% 93.096% # ( 4, 6 ] 8871 4.637% 97.732% # ( 6, 10 ] 3140 1.641% 99.373% ( 10, 15 ] 600 0.314% 99.687% ( 15, 22 ] 92 0.048% 99.735% ( 22, 34 ] 42 0.022% 99.757% ( 34, 51 ] 6 0.003% 99.760% ( 51, 76 ] 2 0.001% 99.761% ( 76, 110 ] 65 0.034% 99.795% ( 110, 170 ] 206 0.108% 99.903% ( 170, 250 ] 71 0.037% 99.940% ( 250, 380 ] 52 0.027% 99.967% ( 380, 580 ] 53 0.028% 99.995% ( 580, 870 ] 21 0.011% 100.006% ( 870, 1300 ] 15 0.008% 100.014% ( 1300, 1900 ] 11 0.006% 100.019% ( 1900, 2900 ] 12 0.006% 100.026% ( 2900, 4400 ] 2 0.001% 100.027% ** Level 4 read latency histogram (micros): Count: 310 Average: 107.7742 StdDev: 428.82 Min: 1 Median: 2.6533 Max: 3289 Percentiles: P50: 2.65 P75: 7.67 P99: 2533.33 P99.9: 3289.00 P99.99: 3289.00 ------------------------------------------------------ [ 0, 1 ] 29 9.355% 9.355% ## ( 1, 2 ] 77 24.839% 34.194% ##### ( 2, 3 ] 75 24.194% 58.387% ##### ( 3, 4 ] 36 11.613% 70.000% ## ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 6 1.935% 76.129% ( 10, 15 ] 14 4.516% 80.645% # ( 15, 22 ] 30 9.677% 90.323% ## ( 22, 34 ] 7 2.258% 92.581% ( 170, 250 ] 2 0.645% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 3 0.968% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 6 1.935% 98.387% ( 1900, 2900 ] 3 0.968% 99.355% ( 2900, 4400 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 752.0333 StdDev: 841.89 Min: 87 Median: 347.5000 Max: 3741 Percentiles: P50: 347.50 P75: 1156.67 P99: 3500.00 P99.9: 3741.00 P99.99: 3741.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 11 18.333% 26.667% #### ( 170, 250 ] 8 13.333% 40.000% ### ( 250, 380 ] 8 13.333% 53.333% ### ( 380, 580 ] 6 10.000% 63.333% ## ( 580, 870 ] 5 8.333% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 8 13.333% 90.000% ### ( 1900, 2900 ] 5 8.333% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 19.5 total, 4.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 303.47 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:3.470 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, 247.31 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.331 H:M:S, 33.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-06:52:08 ... thread 0: (1000000,7000000) ops and (216639.3,293306.7) ops/second in (4.615967,23.865803) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 3.75 GB 132.2 5.0 0.0 5.0 11.6 6.6 0.0 1.7 130.0 303.3 39.24 36.81 113 0.347 5180K 5451 0.0 0.0 L1 17/17 1.84 GB 0.0 3.1 2.6 0.4 3.1 2.6 0.2 1.2 225.9 224.5 14.00 13.50 3 4.668 3212K 19K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.8 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 20/0 954.50 MB 1.0 1.5 0.7 0.8 1.5 0.7 0.4 2.1 218.2 217.7 7.18 6.75 5 1.435 1590K 3394 0.0 0.0 L4 170/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 152.2 152.2 1.47 1.11 1 1.474 227K 0 0.0 0.0 L5 1052/0 86.62 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1277/28 102.75 GB 0.0 10.2 3.8 6.4 16.8 10.4 3.3 2.5 164.5 271.3 63.42 59.65 124 0.511 10M 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.2 3.8 6.4 16.8 10.4 3.2 2.5 164.5 271.3 63.42 59.65 124 0.511 10M 28K 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 10.2 3.8 6.4 10.2 3.7 0.0 0.0 237.7 237.0 43.90 42.18 29 1.514 10M 28K 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 348.5 19.52 17.46 95 0.206 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): 24.1 total, 23.9 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.80 GB write, 714.80 MB/s write, 10.19 GB read, 433.40 MB/s read, 63.4 seconds Interval compaction: 16.80 GB write, 720.98 MB/s write, 10.19 GB read, 437.15 MB/s read, 63.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 21, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2238044 Average: 2.2225 StdDev: 11.90 Min: 0 Median: 1.4736 Max: 4069 Percentiles: P50: 1.47 P75: 1.85 P99: 5.67 P99.9: 10.39 P99.99: 37.88 ------------------------------------------------------ [ 0, 1 ] 415525 18.566% 18.566% #### ( 1, 2 ] 1485311 66.366% 84.933% ############# ( 2, 3 ] 191710 8.566% 93.499% ## ( 3, 4 ] 81237 3.630% 97.129% # ( 4, 6 ] 50108 2.239% 99.368% ( 6, 10 ] 11762 0.526% 99.893% ( 10, 15 ] 1953 0.087% 99.980% ( 15, 22 ] 190 0.008% 99.989% ( 22, 34 ] 21 0.001% 99.990% ( 34, 51 ] 14 0.001% 99.990% ( 51, 76 ] 16 0.001% 99.991% ( 76, 110 ] 212 0.009% 100.001% ( 110, 170 ] 268 0.012% 100.013% ( 170, 250 ] 129 0.006% 100.018% ( 250, 380 ] 89 0.004% 100.022% ( 380, 580 ] 66 0.003% 100.025% ( 580, 870 ] 59 0.003% 100.028% ( 870, 1300 ] 42 0.002% 100.030% ( 1300, 1900 ] 14 0.001% 100.030% ( 1900, 2900 ] 16 0.001% 100.031% ( 2900, 4400 ] 7 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 397640 Average: 2.7203 StdDev: 17.69 Min: 0 Median: 1.5411 Max: 4221 Percentiles: P50: 1.54 P75: 1.92 P99: 8.20 P99.9: 124.21 P99.99: 397.57 ------------------------------------------------------ [ 0, 1 ] 56120 14.113% 14.113% ### ( 1, 2 ] 263703 66.317% 80.430% ############# ( 2, 3 ] 42042 10.573% 91.003% ## ( 3, 4 ] 16402 4.125% 95.128% # ( 4, 6 ] 12278 3.088% 98.216% # ( 6, 10 ] 5673 1.427% 99.642% ( 10, 15 ] 629 0.158% 99.801% ( 15, 22 ] 70 0.018% 99.818% ( 22, 34 ] 5 0.001% 99.819% ( 34, 51 ] 2 0.001% 99.820% ( 51, 76 ] 8 0.002% 99.822% ( 76, 110 ] 249 0.063% 99.885% ( 110, 170 ] 259 0.065% 99.950% ( 170, 250 ] 89 0.022% 99.972% ( 250, 380 ] 65 0.016% 99.988% ( 380, 580 ] 71 0.018% 100.006% ( 580, 870 ] 30 0.008% 100.014% ( 870, 1300 ] 12 0.003% 100.017% ( 1300, 1900 ] 7 0.002% 100.019% ( 1900, 2900 ] 2 0.001% 100.019% ( 2900, 4400 ] 2 0.001% 100.020% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 191327 Average: 3.3493 StdDev: 30.37 Min: 1 Median: 1.6374 Max: 3491 Percentiles: P50: 1.64 P75: 2.16 P99: 9.09 P99.9: 168.45 P99.99: 545.54 ------------------------------------------------------ [ 0, 1 ] 19853 10.376% 10.376% ## ( 1, 2 ] 118933 62.162% 72.539% ############ ( 2, 3 ] 29390 15.361% 87.900% ### ( 3, 4 ] 9941 5.196% 93.096% # ( 4, 6 ] 8871 4.637% 97.732% # ( 6, 10 ] 3140 1.641% 99.373% ( 10, 15 ] 600 0.314% 99.687% ( 15, 22 ] 92 0.048% 99.735% ( 22, 34 ] 42 0.022% 99.757% ( 34, 51 ] 6 0.003% 99.760% ( 51, 76 ] 2 0.001% 99.761% ( 76, 110 ] 65 0.034% 99.795% ( 110, 170 ] 206 0.108% 99.903% ( 170, 250 ] 71 0.037% 99.940% ( 250, 380 ] 52 0.027% 99.967% ( 380, 580 ] 53 0.028% 99.995% ( 580, 870 ] 21 0.011% 100.006% ( 870, 1300 ] 15 0.008% 100.014% ( 1300, 1900 ] 11 0.006% 100.019% ( 1900, 2900 ] 12 0.006% 100.026% ( 2900, 4400 ] 2 0.001% 100.027% ** Level 4 read latency histogram (micros): Count: 310 Average: 107.7742 StdDev: 428.82 Min: 1 Median: 2.6533 Max: 3289 Percentiles: P50: 2.65 P75: 7.67 P99: 2533.33 P99.9: 3289.00 P99.99: 3289.00 ------------------------------------------------------ [ 0, 1 ] 29 9.355% 9.355% ## ( 1, 2 ] 77 24.839% 34.194% ##### ( 2, 3 ] 75 24.194% 58.387% ##### ( 3, 4 ] 36 11.613% 70.000% ## ( 4, 6 ] 13 4.194% 74.194% # ( 6, 10 ] 6 1.935% 76.129% ( 10, 15 ] 14 4.516% 80.645% # ( 15, 22 ] 30 9.677% 90.323% ## ( 22, 34 ] 7 2.258% 92.581% ( 170, 250 ] 2 0.645% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 3 0.968% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 6 1.935% 98.387% ( 1900, 2900 ] 3 0.968% 99.355% ( 2900, 4400 ] 2 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 752.0333 StdDev: 841.89 Min: 87 Median: 347.5000 Max: 3741 Percentiles: P50: 347.50 P75: 1156.67 P99: 3500.00 P99.9: 3741.00 P99.99: 3741.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 11 18.333% 26.667% #### ( 170, 250 ] 8 13.333% 40.000% ### ( 250, 380 ] 8 13.333% 53.333% ### ( 380, 580 ] 6 10.000% 63.333% ## ( 580, 870 ] 5 8.333% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 8 13.333% 90.000% ### ( 1900, 2900 ] 5 8.333% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 24.1 total, 4.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 286.17 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:5.412 H:M:S, 22.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 213.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.942 H:M:S, 42.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-06:52:29 ... thread 0: (1000000,8000000) ops and (48130.2,179200.3) ops/second in (20.776990,44.642793) 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/7 2.20 GB 18.9 6.9 0.0 6.9 14.4 7.6 0.0 1.9 140.1 293.6 50.37 46.75 130 0.387 7162K 14K 0.0 0.0 L1 15/15 1.51 GB 0.0 7.4 5.1 2.3 7.3 5.0 0.2 1.4 219.4 216.6 34.48 32.52 4 8.621 7682K 96K 0.0 0.0 L2 6/5 772.69 MB 1.3 0.4 0.2 0.2 0.4 0.2 3.6 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 18/1 1.10 GB 1.0 4.1 2.7 1.4 4.1 2.6 0.4 1.5 141.2 140.3 29.67 19.21 17 1.745 4256K 28K 0.0 0.0 L4 173/0 9.71 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.8 1.0 149.6 149.3 14.18 9.93 24 0.591 2119K 2856 0.0 0.0 L5 1072/0 88.28 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/28 103.56 GB 0.0 20.8 9.9 10.9 28.2 17.4 7.7 3.7 163.6 222.0 130.24 109.88 177 0.736 21M 142K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.8 9.9 10.9 28.2 17.4 7.6 3.7 163.6 222.0 130.24 109.88 177 0.736 21M 142K 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.8 9.9 10.9 20.7 9.8 0.0 0.0 198.0 196.7 107.62 89.96 68 1.583 21M 142K 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 342.5 22.62 19.92 109 0.208 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.9 total, 44.6 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.24 GB write, 644.64 MB/s write, 20.81 GB read, 475.10 MB/s read, 130.2 seconds Interval compaction: 28.24 GB write, 647.62 MB/s write, 20.81 GB read, 477.30 MB/s read, 130.2 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: 25, pending-compaction-bytes-delays: 33, pending-compaction-bytes-stops: 0, total-delays: 49, total-stops: 25, interval: 74 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3424466 Average: 2.8219 StdDev: 28.93 Min: 0 Median: 1.4815 Max: 7878 Percentiles: P50: 1.48 P75: 1.87 P99: 7.24 P99.9: 141.29 P99.99: 334.35 ------------------------------------------------------ [ 0, 1 ] 645959 18.863% 18.863% #### ( 1, 2 ] 2214433 64.665% 83.528% ############# ( 2, 3 ] 300207 8.767% 92.295% ## ( 3, 4 ] 127818 3.732% 96.027% # ( 4, 6 ] 92849 2.711% 98.738% # ( 6, 10 ] 28836 0.842% 99.581% ( 10, 15 ] 4611 0.135% 99.715% ( 15, 22 ] 625 0.018% 99.733% ( 22, 34 ] 52 0.002% 99.735% ( 34, 51 ] 23 0.001% 99.736% ( 51, 76 ] 55 0.002% 99.737% ( 76, 110 ] 3615 0.106% 99.843% ( 110, 170 ] 3760 0.110% 99.953% ( 170, 250 ] 890 0.026% 99.979% ( 250, 380 ] 605 0.018% 99.996% ( 380, 580 ] 443 0.013% 100.009% ( 580, 870 ] 253 0.007% 100.017% ( 870, 1300 ] 112 0.003% 100.020% ( 1300, 1900 ] 49 0.001% 100.021% ( 1900, 2900 ] 60 0.002% 100.023% ( 2900, 4400 ] 89 0.003% 100.026% ( 4400, 6600 ] 18 0.001% 100.026% ( 6600, 9900 ] 4 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1418064 Average: 5.2044 StdDev: 83.66 Min: 0 Median: 1.6523 Max: 12123 Percentiles: P50: 1.65 P75: 2.39 P99: 9.45 P99.9: 168.45 P99.99: 535.06 ------------------------------------------------------ [ 0, 1 ] 182335 12.858% 12.858% ### ( 1, 2 ] 807420 56.938% 69.796% ########### ( 2, 3 ] 188881 13.320% 83.116% ### ( 3, 4 ] 97039 6.843% 89.959% # ( 4, 6 ] 101793 7.178% 97.137% # ( 6, 10 ] 30604 2.158% 99.295% ( 10, 15 ] 5765 0.407% 99.702% ( 15, 22 ] 710 0.050% 99.752% ( 22, 34 ] 58 0.004% 99.756% ( 34, 51 ] 31 0.002% 99.758% ( 51, 76 ] 97 0.007% 99.765% ( 76, 110 ] 933 0.066% 99.831% ( 110, 170 ] 1007 0.071% 99.902% ( 170, 250 ] 389 0.027% 99.929% ( 250, 380 ] 434 0.031% 99.960% ( 380, 580 ] 551 0.039% 99.999% ( 580, 870 ] 445 0.031% 100.030% ( 870, 1300 ] 327 0.023% 100.053% ( 1300, 1900 ] 177 0.012% 100.066% ( 1900, 2900 ] 192 0.014% 100.079% ( 2900, 4400 ] 293 0.021% 100.100% ( 4400, 6600 ] 84 0.006% 100.106% ( 6600, 9900 ] 24 0.002% 100.108% ( 9900, 14000 ] 2 0.000% 100.108% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 804126 Average: 4.1132 StdDev: 44.24 Min: 1 Median: 1.8960 Max: 9508 Percentiles: P50: 1.90 P75: 3.02 P99: 9.04 P99.9: 14.60 P99.99: 51.88 ------------------------------------------------------ [ 0, 1 ] 34446 4.284% 4.284% # ( 1, 2 ] 410278 51.022% 55.305% ########## ( 2, 3 ] 157013 19.526% 74.831% #### ( 3, 4 ] 86433 10.749% 85.580% ## ( 4, 6 ] 94804 11.790% 97.370% ## ( 6, 10 ] 17253 2.146% 99.515% ( 10, 15 ] 3366 0.419% 99.934% ( 15, 22 ] 374 0.047% 99.980% ( 22, 34 ] 61 0.008% 99.988% ( 34, 51 ] 16 0.002% 99.990% ( 51, 76 ] 45 0.006% 99.995% ( 76, 110 ] 83 0.010% 100.006% ( 110, 170 ] 267 0.033% 100.039% ( 170, 250 ] 214 0.027% 100.066% ( 250, 380 ] 235 0.029% 100.095% ( 380, 580 ] 257 0.032% 100.127% ( 580, 870 ] 184 0.023% 100.150% ( 870, 1300 ] 137 0.017% 100.167% ( 1300, 1900 ] 54 0.007% 100.173% ( 1900, 2900 ] 49 0.006% 100.179% ( 2900, 4400 ] 48 0.006% 100.185% ( 4400, 6600 ] 3 0.000% 100.186% ( 6600, 9900 ] 1 0.000% 100.186% ** Level 4 read latency histogram (micros): Count: 23383 Average: 72.5392 StdDev: 369.25 Min: 1 Median: 2.0531 Max: 6511 Percentiles: P50: 2.05 P75: 3.45 P99: 1733.85 P99.9: 4366.28 P99.99: 6110.66 ------------------------------------------------------ [ 0, 1 ] 861 3.682% 3.682% # ( 1, 2 ] 10577 45.234% 48.916% ######### ( 2, 3 ] 4778 20.434% 69.350% #### ( 3, 4 ] 2922 12.496% 81.846% ## ( 4, 6 ] 1958 8.374% 90.219% ## ( 6, 10 ] 511 2.185% 92.405% ( 10, 15 ] 150 0.641% 93.046% ( 15, 22 ] 47 0.201% 93.247% ( 22, 34 ] 15 0.064% 93.311% ( 34, 51 ] 1 0.004% 93.316% ( 51, 76 ] 9 0.038% 93.354% ( 76, 110 ] 12 0.051% 93.405% ( 110, 170 ] 37 0.158% 93.564% ( 170, 250 ] 96 0.411% 93.974% ( 250, 380 ] 163 0.697% 94.671% ( 380, 580 ] 298 1.274% 95.946% ( 580, 870 ] 353 1.510% 97.455% ( 870, 1300 ] 265 1.133% 98.589% ( 1300, 1900 ] 133 0.569% 99.158% ( 1900, 2900 ] 70 0.299% 99.457% ( 2900, 4400 ] 106 0.453% 99.910% ( 4400, 6600 ] 24 0.103% 100.013% ** Level 5 read latency histogram (micros): Count: 160 Average: 1158.4437 StdDev: 1249.70 Min: 87 Median: 580.0000 Max: 5330 Percentiles: P50: 580.00 P75: 1740.00 P99: 5330.00 P99.9: 5330.00 P99.99: 5330.00 ------------------------------------------------------ ( 76, 110 ] 5 3.125% 3.125% # ( 110, 170 ] 21 13.125% 16.250% ### ( 170, 250 ] 20 12.500% 28.750% ### ( 250, 380 ] 13 8.125% 36.875% ## ( 380, 580 ] 21 13.125% 50.000% ### ( 580, 870 ] 16 10.000% 60.000% ## ( 870, 1300 ] 13 8.125% 68.125% ## ( 1300, 1900 ] 15 9.375% 77.500% ## ( 1900, 2900 ] 16 10.000% 87.500% ## ( 2900, 4400 ] 17 10.625% 98.125% ## ( 4400, 6600 ] 3 1.875% 100.000% ** DB Stats ** Uptime(secs): 44.9 total, 20.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 175.55 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.960 H:M:S, 51.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 47.37 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.548 H:M:S, 84.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-06:52:33 ... thread 0: (1000000,9000000) ops and (268683.4,186086.3) ops/second in (3.721853,48.364646) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/3 3.19 GB 151.1 8.1 0.0 8.1 16.6 8.5 0.0 1.9 140.5 289.4 58.72 54.13 147 0.399 8377K 16K 0.0 0.0 L1 15/15 1.51 GB 0.0 7.4 5.1 2.3 7.3 5.0 0.2 1.4 219.4 216.6 34.48 32.52 4 8.621 7682K 96K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.6 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 16/0 917.31 MB 0.9 5.1 3.4 1.7 5.1 3.4 0.4 1.5 146.6 145.8 35.59 23.77 19 1.873 4776K 28K 0.0 0.0 L4 171/0 9.68 GB 1.0 3.1 2.9 0.2 3.1 2.9 0.9 1.1 148.4 148.1 21.47 15.00 36 0.596 3157K 3078 0.0 0.0 L5 1084/0 89.26 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1297/18 104.54 GB 0.0 24.0 11.6 12.4 32.4 20.0 8.7 3.8 162.1 218.8 151.79 126.90 208 0.730 24M 144K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.0 11.6 12.4 32.4 20.0 8.6 3.8 162.1 218.8 151.79 126.90 208 0.730 24M 144K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.0 11.6 12.4 23.9 11.5 0.0 0.0 195.6 194.4 125.78 104.36 86 1.463 24M 144K 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 336.6 26.01 22.55 122 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): 48.6 total, 48.4 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: 32.43 GB write, 683.59 MB/s write, 24.02 GB read, 506.43 MB/s read, 151.8 seconds Interval compaction: 32.43 GB write, 686.50 MB/s write, 24.02 GB read, 508.59 MB/s read, 151.8 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: 40, pending-compaction-bytes-delays: 33, pending-compaction-bytes-stops: 0, total-delays: 49, total-stops: 40, interval: 89 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3806971 Average: 2.8437 StdDev: 30.77 Min: 0 Median: 1.5016 Max: 8016 Percentiles: P50: 1.50 P75: 1.89 P99: 7.32 P99.9: 134.47 P99.99: 306.01 ------------------------------------------------------ [ 0, 1 ] 678304 17.817% 17.817% #### ( 1, 2 ] 2442515 64.159% 81.976% ############# ( 2, 3 ] 360422 9.467% 91.444% ## ( 3, 4 ] 156127 4.101% 95.545% # ( 4, 6 ] 120328 3.161% 98.706% # ( 6, 10 ] 34011 0.893% 99.599% ( 10, 15 ] 5466 0.144% 99.743% ( 15, 22 ] 685 0.018% 99.761% ( 22, 34 ] 59 0.002% 99.762% ( 34, 51 ] 23 0.001% 99.763% ( 51, 76 ] 58 0.002% 99.764% ( 76, 110 ] 3620 0.095% 99.859% ( 110, 170 ] 3791 0.100% 99.959% ( 170, 250 ] 909 0.024% 99.983% ( 250, 380 ] 632 0.017% 99.999% ( 380, 580 ] 458 0.012% 100.011% ( 580, 870 ] 268 0.007% 100.019% ( 870, 1300 ] 120 0.003% 100.022% ( 1300, 1900 ] 53 0.001% 100.023% ( 1900, 2900 ] 63 0.002% 100.025% ( 2900, 4400 ] 103 0.003% 100.027% ( 4400, 6600 ] 23 0.001% 100.028% ( 6600, 9900 ] 10 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 1567510 Average: 5.1107 StdDev: 82.47 Min: 0 Median: 1.6585 Max: 12123 Percentiles: P50: 1.66 P75: 2.40 P99: 9.43 P99.9: 179.95 P99.99: 563.31 ------------------------------------------------------ [ 0, 1 ] 190924 12.180% 12.180% ## ( 1, 2 ] 900266 57.433% 69.613% ########### ( 2, 3 ] 212733 13.571% 83.184% ### ( 3, 4 ] 107632 6.866% 90.051% # ( 4, 6 ] 111408 7.107% 97.158% # ( 6, 10 ] 33699 2.150% 99.308% ( 10, 15 ] 6241 0.398% 99.706% ( 15, 22 ] 753 0.048% 99.754% ( 22, 34 ] 61 0.004% 99.758% ( 34, 51 ] 31 0.002% 99.760% ( 51, 76 ] 98 0.006% 99.766% ( 76, 110 ] 979 0.062% 99.829% ( 110, 170 ] 1063 0.068% 99.897% ( 170, 250 ] 438 0.028% 99.924% ( 250, 380 ] 481 0.031% 99.955% ( 380, 580 ] 596 0.038% 99.993% ( 580, 870 ] 481 0.031% 100.024% ( 870, 1300 ] 340 0.022% 100.046% ( 1300, 1900 ] 184 0.012% 100.057% ( 1900, 2900 ] 200 0.013% 100.070% ( 2900, 4400 ] 311 0.020% 100.090% ( 4400, 6600 ] 88 0.006% 100.096% ( 6600, 9900 ] 26 0.002% 100.097% ( 9900, 14000 ] 3 0.000% 100.097% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1081145 Average: 4.1765 StdDev: 51.64 Min: 1 Median: 1.9068 Max: 11212 Percentiles: P50: 1.91 P75: 3.01 P99: 8.97 P99.9: 14.35 P99.99: 20.71 ------------------------------------------------------ [ 0, 1 ] 39657 3.668% 3.668% # ( 1, 2 ] 552388 51.093% 54.761% ########## ( 2, 3 ] 217975 20.161% 74.922% #### ( 3, 4 ] 115850 10.715% 85.638% ## ( 4, 6 ] 127534 11.796% 97.434% ## ( 6, 10 ] 22764 2.106% 99.540% ( 10, 15 ] 4473 0.414% 99.953% ( 15, 22 ] 485 0.045% 99.998% ( 22, 34 ] 70 0.006% 100.005% ( 34, 51 ] 17 0.002% 100.006% ( 51, 76 ] 47 0.004% 100.011% ( 76, 110 ] 102 0.009% 100.020% ( 110, 170 ] 287 0.027% 100.047% ( 170, 250 ] 247 0.023% 100.069% ( 250, 380 ] 279 0.026% 100.095% ( 380, 580 ] 306 0.028% 100.124% ( 580, 870 ] 241 0.022% 100.146% ( 870, 1300 ] 166 0.015% 100.161% ( 1300, 1900 ] 64 0.006% 100.167% ( 1900, 2900 ] 59 0.005% 100.173% ( 2900, 4400 ] 86 0.008% 100.181% ( 4400, 6600 ] 10 0.001% 100.181% ( 6600, 9900 ] 6 0.001% 100.182% ( 9900, 14000 ] 1 0.000% 100.182% ** Level 4 read latency histogram (micros): Count: 47866 Average: 48.0782 StdDev: 283.87 Min: 1 Median: 1.9989 Max: 6511 Percentiles: P50: 2.00 P75: 3.35 P99: 1193.49 P99.9: 3987.94 P99.99: 5313.68 ------------------------------------------------------ [ 0, 1 ] 1490 3.113% 3.113% # ( 1, 2 ] 22468 46.939% 50.052% ######### ( 2, 3 ] 9927 20.739% 70.791% #### ( 3, 4 ] 5746 12.004% 82.796% ## ( 4, 6 ] 4391 9.174% 91.969% ## ( 6, 10 ] 1064 2.223% 94.192% ( 10, 15 ] 267 0.558% 94.750% ( 15, 22 ] 63 0.132% 94.882% ( 22, 34 ] 17 0.036% 94.917% ( 34, 51 ] 4 0.008% 94.925% ( 51, 76 ] 11 0.023% 94.948% ( 76, 110 ] 39 0.081% 95.030% ( 110, 170 ] 141 0.295% 95.324% ( 170, 250 ] 214 0.447% 95.772% ( 250, 380 ] 279 0.583% 96.354% ( 380, 580 ] 463 0.967% 97.322% ( 580, 870 ] 528 1.103% 98.425% ( 870, 1300 ] 366 0.765% 99.189% ( 1300, 1900 ] 169 0.353% 99.542% ( 1900, 2900 ] 87 0.182% 99.724% ( 2900, 4400 ] 116 0.242% 99.967% ( 4400, 6600 ] 27 0.056% 100.023% ** Level 5 read latency histogram (micros): Count: 220 Average: 1156.6273 StdDev: 1233.44 Min: 76 Median: 592.6087 Max: 5330 Percentiles: P50: 592.61 P75: 1758.82 P99: 5330.00 P99.9: 5330.00 P99.99: 5330.00 ------------------------------------------------------ ( 51, 76 ] 1 0.455% 0.455% ( 76, 110 ] 7 3.182% 3.636% # ( 110, 170 ] 26 11.818% 15.455% ## ( 170, 250 ] 22 10.000% 25.455% ## ( 250, 380 ] 24 10.909% 36.364% ## ( 380, 580 ] 29 13.182% 49.545% ### ( 580, 870 ] 23 10.455% 60.000% ## ( 870, 1300 ] 20 9.091% 69.091% ## ( 1300, 1900 ] 17 7.727% 76.818% ## ( 1900, 2900 ] 24 10.909% 87.727% ## ( 2900, 4400 ] 23 10.455% 98.182% ## ( 4400, 6600 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 48.6 total, 3.7 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 182.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:23.897 H:M:S, 49.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 264.44 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.937 H:M:S, 25.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-06:52:36 ... thread 0: (1000000,10000000) ops and (324805.6,194388.4) ops/second in (3.078765,51.443411) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 4.11 GB 188.8 8.6 0.0 8.6 18.1 9.5 0.0 1.9 138.5 290.5 63.68 58.74 162 0.393 8953K 16K 0.0 0.0 L1 15/15 1.51 GB 0.0 7.4 5.1 2.3 7.3 5.0 0.2 1.4 219.4 216.6 34.48 32.52 4 8.621 7682K 96K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.6 2.0 246.8 246.6 1.53 1.48 2 0.766 383K 212 0.0 0.0 L3 16/0 917.31 MB 0.9 5.1 3.4 1.7 5.1 3.4 0.4 1.5 146.6 145.8 35.59 23.77 19 1.873 4776K 28K 0.0 0.0 L4 171/0 9.68 GB 1.0 3.1 2.9 0.2 3.1 2.9 0.9 1.1 148.4 148.1 21.47 15.00 36 0.596 3157K 3078 0.0 0.0 L5 1084/0 89.26 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1304/26 105.46 GB 0.0 24.6 11.6 12.9 33.9 21.0 8.7 3.6 160.5 221.5 156.75 131.51 223 0.703 24M 144K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.6 11.6 12.9 33.9 21.0 8.6 3.6 160.5 221.5 156.75 131.51 223 0.703 24M 144K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.6 11.6 12.9 24.4 11.5 0.0 0.0 196.6 195.5 127.98 106.50 88 1.454 24M 144K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 337.1 28.78 25.01 135 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): 51.7 total, 51.4 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 33.90 GB write, 672.10 MB/s write, 24.58 GB read, 487.22 MB/s read, 156.8 seconds Interval compaction: 33.90 GB write, 674.80 MB/s write, 24.58 GB read, 489.17 MB/s read, 156.8 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: 44, pending-compaction-bytes-delays: 33, pending-compaction-bytes-stops: 0, total-delays: 49, total-stops: 44, interval: 93 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4058660 Average: 2.8087 StdDev: 30.03 Min: 0 Median: 1.5016 Max: 8016 Percentiles: P50: 1.50 P75: 1.89 P99: 7.19 P99.9: 130.40 P99.99: 294.99 ------------------------------------------------------ [ 0, 1 ] 719112 17.718% 17.718% #### ( 1, 2 ] 2611853 64.353% 82.071% ############# ( 2, 3 ] 385646 9.502% 91.572% ## ( 3, 4 ] 164575 4.055% 95.627% # ( 4, 6 ] 126283 3.111% 98.739% # ( 6, 10 ] 35593 0.877% 99.616% ( 10, 15 ] 5736 0.141% 99.757% ( 15, 22 ] 710 0.017% 99.775% ( 22, 34 ] 60 0.001% 99.776% ( 34, 51 ] 24 0.001% 99.777% ( 51, 76 ] 59 0.001% 99.778% ( 76, 110 ] 3657 0.090% 99.868% ( 110, 170 ] 3806 0.094% 99.962% ( 170, 250 ] 920 0.023% 99.985% ( 250, 380 ] 639 0.016% 100.000% ( 380, 580 ] 467 0.012% 100.012% ( 580, 870 ] 271 0.007% 100.019% ( 870, 1300 ] 123 0.003% 100.022% ( 1300, 1900 ] 56 0.001% 100.023% ( 1900, 2900 ] 65 0.002% 100.025% ( 2900, 4400 ] 106 0.003% 100.027% ( 4400, 6600 ] 23 0.001% 100.028% ( 6600, 9900 ] 10 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 1697353 Average: 4.9185 StdDev: 79.31 Min: 0 Median: 1.6471 Max: 12123 Percentiles: P50: 1.65 P75: 2.33 P99: 9.37 P99.9: 171.62 P99.99: 561.50 ------------------------------------------------------ [ 0, 1 ] 207850 12.246% 12.246% ## ( 1, 2 ] 990234 58.340% 70.585% ############ ( 2, 3 ] 226139 13.323% 83.908% ### ( 3, 4 ] 111508 6.570% 90.478% # ( 4, 6 ] 114410 6.740% 97.218% # ( 6, 10 ] 35907 2.115% 99.334% ( 10, 15 ] 6420 0.378% 99.712% ( 15, 22 ] 768 0.045% 99.757% ( 22, 34 ] 62 0.004% 99.761% ( 34, 51 ] 31 0.002% 99.763% ( 51, 76 ] 105 0.006% 99.769% ( 76, 110 ] 1054 0.062% 99.831% ( 110, 170 ] 1158 0.068% 99.899% ( 170, 250 ] 475 0.028% 99.927% ( 250, 380 ] 496 0.029% 99.957% ( 380, 580 ] 624 0.037% 99.993% ( 580, 870 ] 485 0.029% 100.022% ( 870, 1300 ] 341 0.020% 100.042% ( 1300, 1900 ] 184 0.011% 100.053% ( 1900, 2900 ] 200 0.012% 100.065% ( 2900, 4400 ] 311 0.018% 100.083% ( 4400, 6600 ] 88 0.005% 100.088% ( 6600, 9900 ] 26 0.002% 100.090% ( 9900, 14000 ] 3 0.000% 100.090% ** Level 2 read latency histogram (micros): Count: 124201 Average: 2.3543 StdDev: 15.03 Min: 1 Median: 1.4118 Max: 1921 Percentiles: P50: 1.41 P75: 1.82 P99: 5.99 P99.9: 110.92 P99.99: 695.35 ------------------------------------------------------ [ 0, 1 ] 30437 24.506% 24.506% ##### ( 1, 2 ] 76882 61.901% 86.408% ############ ( 2, 3 ] 8881 7.151% 93.558% # ( 3, 4 ] 4375 3.523% 97.081% # ( 4, 6 ] 2390 1.924% 99.005% ( 6, 10 ] 958 0.771% 99.776% ( 10, 15 ] 118 0.095% 99.871% ( 15, 22 ] 14 0.011% 99.882% ( 22, 34 ] 1 0.001% 99.883% ( 51, 76 ] 1 0.001% 99.884% ( 76, 110 ] 19 0.015% 99.899% ( 110, 170 ] 52 0.042% 99.941% ( 170, 250 ] 22 0.018% 99.959% ( 250, 380 ] 25 0.020% 99.979% ( 380, 580 ] 10 0.008% 99.987% ( 580, 870 ] 9 0.007% 99.994% ( 870, 1300 ] 2 0.002% 99.996% ( 1300, 1900 ] 4 0.003% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1081145 Average: 4.1765 StdDev: 51.64 Min: 1 Median: 1.9068 Max: 11212 Percentiles: P50: 1.91 P75: 3.01 P99: 8.97 P99.9: 14.35 P99.99: 20.71 ------------------------------------------------------ [ 0, 1 ] 39657 3.668% 3.668% # ( 1, 2 ] 552388 51.093% 54.761% ########## ( 2, 3 ] 217975 20.161% 74.922% #### ( 3, 4 ] 115850 10.715% 85.638% ## ( 4, 6 ] 127534 11.796% 97.434% ## ( 6, 10 ] 22764 2.106% 99.540% ( 10, 15 ] 4473 0.414% 99.953% ( 15, 22 ] 485 0.045% 99.998% ( 22, 34 ] 70 0.006% 100.005% ( 34, 51 ] 17 0.002% 100.006% ( 51, 76 ] 47 0.004% 100.011% ( 76, 110 ] 102 0.009% 100.020% ( 110, 170 ] 287 0.027% 100.047% ( 170, 250 ] 247 0.023% 100.069% ( 250, 380 ] 279 0.026% 100.095% ( 380, 580 ] 306 0.028% 100.124% ( 580, 870 ] 241 0.022% 100.146% ( 870, 1300 ] 166 0.015% 100.161% ( 1300, 1900 ] 64 0.006% 100.167% ( 1900, 2900 ] 59 0.005% 100.173% ( 2900, 4400 ] 86 0.008% 100.181% ( 4400, 6600 ] 10 0.001% 100.181% ( 6600, 9900 ] 6 0.001% 100.182% ( 9900, 14000 ] 1 0.000% 100.182% ** Level 4 read latency histogram (micros): Count: 47866 Average: 48.0782 StdDev: 283.87 Min: 1 Median: 1.9989 Max: 6511 Percentiles: P50: 2.00 P75: 3.35 P99: 1193.49 P99.9: 3987.94 P99.99: 5313.68 ------------------------------------------------------ [ 0, 1 ] 1490 3.113% 3.113% # ( 1, 2 ] 22468 46.939% 50.052% ######### ( 2, 3 ] 9927 20.739% 70.791% #### ( 3, 4 ] 5746 12.004% 82.796% ## ( 4, 6 ] 4391 9.174% 91.969% ## ( 6, 10 ] 1064 2.223% 94.192% ( 10, 15 ] 267 0.558% 94.750% ( 15, 22 ] 63 0.132% 94.882% ( 22, 34 ] 17 0.036% 94.917% ( 34, 51 ] 4 0.008% 94.925% ( 51, 76 ] 11 0.023% 94.948% ( 76, 110 ] 39 0.081% 95.030% ( 110, 170 ] 141 0.295% 95.324% ( 170, 250 ] 214 0.447% 95.772% ( 250, 380 ] 279 0.583% 96.354% ( 380, 580 ] 463 0.967% 97.322% ( 580, 870 ] 528 1.103% 98.425% ( 870, 1300 ] 366 0.765% 99.189% ( 1300, 1900 ] 169 0.353% 99.542% ( 1900, 2900 ] 87 0.182% 99.724% ( 2900, 4400 ] 116 0.242% 99.967% ( 4400, 6600 ] 27 0.056% 100.023% ** Level 5 read latency histogram (micros): Count: 220 Average: 1156.6273 StdDev: 1233.44 Min: 76 Median: 592.6087 Max: 5330 Percentiles: P50: 592.61 P75: 1758.82 P99: 5330.00 P99.9: 5330.00 P99.99: 5330.00 ------------------------------------------------------ ( 51, 76 ] 1 0.455% 0.455% ( 76, 110 ] 7 3.182% 3.636% # ( 110, 170 ] 26 11.818% 15.455% ## ( 170, 250 ] 22 10.000% 25.455% ## ( 250, 380 ] 24 10.909% 36.364% ## ( 380, 580 ] 29 13.182% 49.545% ### ( 580, 870 ] 23 10.455% 60.000% ## ( 870, 1300 ] 20 9.091% 69.091% ## ( 1300, 1900 ] 17 7.727% 76.818% ## ( 1900, 2900 ] 24 10.909% 87.727% ## ( 2900, 4400 ] 23 10.455% 98.182% ## ( 4400, 6600 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 51.7 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 190.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:24.360 H:M:S, 47.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.67 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.463 H:M:S, 15.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.901 micros/op 169466 ops/sec 60.124 seconds 10188999 operations; 164.2 MB/s Microseconds per write: Count: 10188999 Average: 5.9009 StdDev: 305.55 Min: 0 Median: 1.7303 Max: 340357 Percentiles: P50: 1.73 P75: 2.75 P99: 9.27 P99.9: 1152.82 P99.99: 2672.23 ------------------------------------------------------ [ 0, 1 ] 1432511 14.059% 14.059% ### ( 1, 2 ] 5014248 49.212% 63.272% ########## ( 2, 3 ] 1601023 15.713% 78.985% ### ( 3, 4 ] 1396009 13.701% 92.686% ### ( 4, 6 ] 546544 5.364% 98.050% # ( 6, 10 ] 118447 1.162% 99.213% ( 10, 15 ] 36231 0.356% 99.568% ( 15, 22 ] 8973 0.088% 99.656% ( 22, 34 ] 1936 0.019% 99.675% ( 34, 51 ] 230 0.002% 99.678% ( 51, 76 ] 21 0.000% 99.678% ( 76, 110 ] 6867 0.067% 99.745% ( 110, 170 ] 2977 0.029% 99.774% ( 170, 250 ] 315 0.003% 99.778% ( 250, 380 ] 172 0.002% 99.779% ( 380, 580 ] 21 0.000% 99.779% ( 580, 870 ] 22 0.000% 99.780% ( 870, 1300 ] 18645 0.183% 99.963% ( 1300, 1900 ] 127 0.001% 99.964% ( 1900, 2900 ] 3446 0.034% 99.998% ( 2900, 4400 ] 152 0.001% 99.999% ( 4400, 6600 ] 43 0.000% 100.000% ( 6600, 9900 ] 14 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 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 : 203590 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 : 10188999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10515046968 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 : 589 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32201351 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 : 32817634692 rocksdb.compact.write.bytes COUNT : 32608468744 rocksdb.flush.write.bytes COUNT : 10502841466 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 60 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 338 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 : 10418413568 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4291584 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 : 32915227395 rocksdb.non.last.level.read.count COUNT : 7950241 rocksdb.block.checksum.compute.count COUNT : 7949123 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.380488 P95 : 3.907074 P99 : 7.888293 P100 : 340355.000000 COUNT : 10188999 SUM : 55419963 rocksdb.compaction.times.micros P50 : 911000.000000 P95 : 4160000.000000 P99 : 17920000.000000 P100 : 20478351.000000 COUNT : 102 SUM : 155255718 rocksdb.compaction.times.cpu_micros P50 : 869714.285714 P95 : 3530000.000000 P99 : 17920000.000000 P100 : 19019906.000000 COUNT : 102 SUM : 129608003 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 : 686.220930 P95 : 1216.150000 P99 : 5742.000000 P100 : 184179.000000 COUNT : 139 SUM : 285087 rocksdb.compaction.outfile.sync.micros P50 : 996.340206 P95 : 149300.000000 P99 : 295716.666667 P100 : 331932.000000 COUNT : 389 SUM : 7104501 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 : 102.015152 P95 : 1251.625000 P99 : 3055.000000 P100 : 3275.000000 COUNT : 269 SUM : 66431 rocksdb.table.open.io.micros P50 : 1397.368421 P95 : 6394.864865 P99 : 9616.500000 P100 : 14509.000000 COUNT : 589 SUM : 1125385 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.646583 P95 : 8.118333 P99 : 12.028875 P100 : 12129.000000 COUNT : 7947386 SUM : 47794709 rocksdb.read.block.get.micros P50 : 453.282443 P95 : 2856.716418 P99 : 4281.875000 P100 : 5404.000000 COUNT : 1178 SUM : 915893 rocksdb.write.raw.block.micros P50 : 0.513881 P95 : 0.976374 P99 : 2.928170 P100 : 15764.000000 COUNT : 10441204 SUM : 19857566 rocksdb.numfiles.in.singlecompaction P50 : 2.950000 P95 : 7.100000 P99 : 29.440000 P100 : 39.000000 COUNT : 138 SUM : 531 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.558091 P95 : 1136.999249 P99 : 2331.133062 P100 : 340180.000000 COUNT : 216604 SUM : 32221045 rocksdb.sst.read.micros P50 : 1.586344 P95 : 4.896724 P99 : 8.858267 P100 : 12123.000000 COUNT : 7950445 SUM : 31087037 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 : 10188999 SUM : 10515046968 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 : 213960.396040 P95 : 360825.000000 P99 : 545300.000000 P100 : 636285.000000 COUNT : 139 SUM : 29684373 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 : 375 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