[2024-07-12 22:29:47.464564] Starting SPDK v24.09-pre git sha1 719d03c6a / DPDK 24.07.0-rc2 initialization... [2024-07-12 22:29:47.464853] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid3972262 ] Set seed to 1720816187458012 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-12 22:29:47.546198] pci_dpdk.c: 37:dpdk_pci_init: *NOTICE*: In-development DPDK 24.07.0-rc2 is used. There is no support for it in SPDK. Enabled only for validation. [2024-07-12 22:29:47.596973] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-12 22:29:47.636254] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-12 22:29:47.636302] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3972262' to capture a snapshot of events at runtime. [2024-07-12 22:29:47.636319] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-12 22:29:47.636333] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-12 22:29:47.636346] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3972262 for offline analysis/debug. [2024-07-12 22:29:47.636465] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 12 22:29:51 2024 CPU: 112 * Intel(R) Xeon(R) Platinum 8180 CPU @ 2.50GHz CPUCache: 39424 KB 2024/07/12-22:29:54 ... thread 0: (1000000,1000000) ops and (350843.3,350843.3) ops/second in (2.850275,2.850275) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 7/4 441.02 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 344.8 2.37 2.16 12 0.198 0 0 0.0 0.0 L1 3/3 188.86 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 270.2 270.0 0.70 0.68 1 0.700 191K 125 0.0 0.0 L2 3/0 188.90 MB 1.9 0.2 0.1 0.1 0.2 0.1 0.2 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 9/0 741.07 MB 0.7 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.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1064/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1202/7 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.5 1.5 99.8 315.9 3.79 3.52 14 0.271 383K 190 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.5 1.5 99.8 315.9 3.79 3.52 14 0.271 383K 190 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 267.3 267.2 1.41 1.36 2 0.707 383K 190 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 344.8 2.37 2.16 12 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.9 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 394.11 MB/s write, 0.37 GB read, 124.47 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 419.51 MB/s write, 0.37 GB read, 132.49 MB/s read, 3.8 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: 115601 Average: 1.6944 StdDev: 6.82 Min: 1 Median: 1.0790 Max: 1024 Percentiles: P50: 1.08 P75: 1.58 P99: 3.41 P99.9: 9.74 P99.99: 424.36 ------------------------------------------------------ [ 0, 1 ] 53217 46.035% 46.035% ######### ( 1, 2 ] 58036 50.204% 96.239% ########## ( 2, 3 ] 2914 2.521% 98.760% # ( 3, 4 ] 677 0.586% 99.345% ( 4, 6 ] 314 0.272% 99.617% ( 6, 10 ] 350 0.303% 99.920% ( 10, 15 ] 59 0.051% 99.971% ( 15, 22 ] 6 0.005% 99.976% ( 22, 34 ] 2 0.002% 99.978% ( 51, 76 ] 2 0.002% 99.979% ( 170, 250 ] 9 0.008% 99.987% ( 250, 380 ] 1 0.001% 99.988% ( 380, 580 ] 11 0.010% 99.997% ( 870, 1300 ] 3 0.003% 100.000% ** Level 1 read latency histogram (micros): Count: 14707 Average: 2.1694 StdDev: 35.63 Min: 1 Median: 1.0884 Max: 3727 Percentiles: P50: 1.09 P75: 1.58 P99: 3.29 P99.9: 12.68 P99.99: 1617.58 ------------------------------------------------------ [ 0, 1 ] 6693 45.509% 45.509% ######### ( 1, 2 ] 7475 50.826% 96.335% ########## ( 2, 3 ] 364 2.475% 98.810% ( 3, 4 ] 95 0.646% 99.456% ( 4, 6 ] 20 0.136% 99.592% ( 6, 10 ] 41 0.279% 99.871% ( 10, 15 ] 8 0.054% 99.925% ( 15, 22 ] 2 0.014% 99.939% ( 170, 250 ] 2 0.014% 99.952% ( 250, 380 ] 2 0.014% 99.966% ( 380, 580 ] 2 0.014% 99.980% ( 870, 1300 ] 1 0.007% 99.986% ( 1300, 1900 ] 1 0.007% 99.993% ( 2900, 4400 ] 1 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 15 Average: 116.2667 StdDev: 221.83 Min: 1 Median: 1.0000 Max: 787 Percentiles: P50: 1.00 P75: 190.00 P99: 787.00 P99.9: 787.00 P99.99: 787.00 ------------------------------------------------------ [ 0, 1 ] 8 53.333% 53.333% ########### ( 1, 2 ] 2 13.333% 66.667% ### ( 2, 3 ] 1 6.667% 73.333% # ( 170, 250 ] 1 6.667% 80.000% # ( 250, 380 ] 1 6.667% 86.667% # ( 380, 580 ] 1 6.667% 93.333% # ( 580, 870 ] 1 6.667% 100.000% # ** Level 3 read latency histogram (micros): Count: 40 Average: 1417.2000 StdDev: 897.15 Min: 131 Median: 1214.0000 Max: 3993 Percentiles: P50: 1214.00 P75: 2100.00 P99: 3993.00 P99.9: 3993.00 P99.99: 3993.00 ------------------------------------------------------ ( 110, 170 ] 1 2.500% 2.500% # ( 250, 380 ] 1 2.500% 5.000% # ( 380, 580 ] 5 12.500% 17.500% ### ( 580, 870 ] 9 22.500% 40.000% ##### ( 870, 1300 ] 5 12.500% 52.500% ### ( 1300, 1900 ] 7 17.500% 70.000% #### ( 1900, 2900 ] 10 25.000% 95.000% ##### ( 2900, 4400 ] 2 5.000% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1412.0000 StdDev: 1034.48 Min: 43 Median: 1269.2857 Max: 3701 Percentiles: P50: 1269.29 P75: 1962.50 P99: 3701.00 P99.9: 3701.00 P99.99: 3701.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 3 8.571% 11.429% ## ( 250, 380 ] 3 8.571% 20.000% ## ( 380, 580 ] 3 8.571% 28.571% ## ( 580, 870 ] 1 2.857% 31.429% # ( 870, 1300 ] 7 20.000% 51.429% #### ( 1300, 1900 ] 8 22.857% 74.286% ##### ( 1900, 2900 ] 4 11.429% 85.714% ## ( 2900, 4400 ] 5 14.286% 100.000% ### ** DB Stats ** Uptime(secs): 3.0 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 324.09 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.232 H:M:S, 7.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 344.92 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.232 H:M:S, 8.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/12-22:29:57 ... thread 0: (1000000,2000000) ops and (325268.4,337572.2) ops/second in (3.074384,5.924659) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/6 1.17 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 99.4 321.0 8.24 7.64 29 0.284 831K 851 0.0 0.0 L1 1/1 10.89 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.2 1.4 256.5 256.1 2.46 2.38 2 1.228 639K 887 0.0 0.0 L2 4/3 301.86 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 18/1 1.03 GB 0.9 0.4 0.3 0.1 0.4 0.3 0.1 1.2 222.8 222.6 1.68 1.56 2 0.839 379K 275 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1064/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1211/11 97.92 GB 0.0 2.0 0.9 1.1 3.7 2.6 0.9 2.1 153.7 293.1 13.09 12.27 34 0.385 2042K 2078 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 0.9 1.1 3.7 2.6 0.9 2.1 153.7 293.1 13.09 12.27 34 0.385 2042K 2078 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.0 0.9 1.1 2.0 0.9 0.0 0.0 254.5 254.2 7.90 7.61 8 0.988 2042K 2078 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 352.5 5.18 4.66 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.75 GB write, 627.79 MB/s write, 1.96 GB read, 329.19 MB/s read, 13.1 seconds Interval compaction: 3.75 GB write, 647.26 MB/s write, 1.96 GB read, 339.40 MB/s read, 13.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 384692 Average: 2.1102 StdDev: 8.43 Min: 1 Median: 1.4199 Max: 2411 Percentiles: P50: 1.42 P75: 1.83 P99: 5.79 P99.9: 11.56 P99.99: 16.97 ------------------------------------------------------ [ 0, 1 ] 94294 24.512% 24.512% ##### ( 1, 2 ] 233536 60.707% 85.219% ############ ( 2, 3 ] 31594 8.213% 93.432% ## ( 3, 4 ] 14282 3.713% 97.144% # ( 4, 6 ] 7964 2.070% 99.214% ( 6, 10 ] 2486 0.646% 99.861% ( 10, 15 ] 484 0.126% 99.986% ( 15, 22 ] 48 0.012% 99.999% ( 22, 34 ] 13 0.003% 100.002% ( 34, 51 ] 2 0.001% 100.003% ( 51, 76 ] 3 0.001% 100.004% ( 110, 170 ] 1 0.000% 100.004% ( 170, 250 ] 21 0.005% 100.009% ( 250, 380 ] 2 0.001% 100.010% ( 380, 580 ] 23 0.006% 100.016% ( 580, 870 ] 3 0.001% 100.017% ( 870, 1300 ] 7 0.002% 100.018% ( 1300, 1900 ] 1 0.000% 100.019% ( 1900, 2900 ] 2 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 145626 Average: 2.2783 StdDev: 12.16 Min: 1 Median: 1.5362 Max: 3727 Percentiles: P50: 1.54 P75: 1.92 P99: 5.76 P99.9: 11.18 P99.99: 17.82 ------------------------------------------------------ [ 0, 1 ] 21496 14.761% 14.761% ### ( 1, 2 ] 95713 65.725% 80.486% ############# ( 2, 3 ] 16517 11.342% 91.828% ## ( 3, 4 ] 7033 4.829% 96.658% # ( 4, 6 ] 3886 2.668% 99.326% # ( 6, 10 ] 797 0.547% 99.874% ( 10, 15 ] 163 0.112% 99.986% ( 15, 22 ] 16 0.011% 99.997% ( 22, 34 ] 1 0.001% 99.997% ( 110, 170 ] 1 0.001% 99.998% ( 170, 250 ] 2 0.001% 99.999% ( 250, 380 ] 2 0.001% 100.001% ( 380, 580 ] 6 0.004% 100.005% ( 580, 870 ] 2 0.001% 100.006% ( 870, 1300 ] 2 0.001% 100.008% ( 1300, 1900 ] 1 0.001% 100.008% ( 2900, 4400 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 47601 Average: 2.2994 StdDev: 4.57 Min: 1 Median: 1.5599 Max: 787 Percentiles: P50: 1.56 P75: 1.94 P99: 6.33 P99.9: 12.31 P99.99: 46.69 ------------------------------------------------------ [ 0, 1 ] 6273 13.178% 13.178% ### ( 1, 2 ] 31306 65.768% 78.946% ############# ( 2, 3 ] 5502 11.559% 90.504% ## ( 3, 4 ] 2462 5.172% 95.677% # ( 4, 6 ] 1546 3.248% 98.924% # ( 6, 10 ] 433 0.910% 99.834% ( 10, 15 ] 68 0.143% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 34, 51 ] 3 0.006% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 42558 Average: 3.6592 StdDev: 51.85 Min: 1 Median: 1.5659 Max: 3993 Percentiles: P50: 1.57 P75: 1.94 P99: 5.88 P99.9: 153.26 P99.99: 2374.42 ------------------------------------------------------ [ 0, 1 ] 5210 12.242% 12.242% ## ( 1, 2 ] 28395 66.721% 78.963% ############# ( 2, 3 ] 5070 11.913% 90.876% ## ( 3, 4 ] 2375 5.581% 96.457% # ( 4, 6 ] 1149 2.700% 99.156% # ( 6, 10 ] 247 0.580% 99.737% ( 10, 15 ] 58 0.136% 99.873% ( 15, 22 ] 7 0.016% 99.890% ( 22, 34 ] 1 0.002% 99.892% ( 34, 51 ] 1 0.002% 99.894% ( 76, 110 ] 1 0.002% 99.897% ( 110, 170 ] 2 0.005% 99.901% ( 250, 380 ] 3 0.007% 99.908% ( 380, 580 ] 7 0.016% 99.925% ( 580, 870 ] 10 0.023% 99.948% ( 870, 1300 ] 6 0.014% 99.962% ( 1300, 1900 ] 7 0.016% 99.979% ( 1900, 2900 ] 10 0.023% 100.002% ( 2900, 4400 ] 2 0.005% 100.007% ** Level 4 read latency histogram (micros): Count: 35 Average: 1412.0000 StdDev: 1034.48 Min: 43 Median: 1269.2857 Max: 3701 Percentiles: P50: 1269.29 P75: 1962.50 P99: 3701.00 P99.9: 3701.00 P99.99: 3701.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 3 8.571% 11.429% ## ( 250, 380 ] 3 8.571% 20.000% ## ( 380, 580 ] 3 8.571% 28.571% ## ( 580, 870 ] 1 2.857% 31.429% # ( 870, 1300 ] 7 20.000% 51.429% #### ( 1300, 1900 ] 8 22.857% 74.286% ##### ( 1900, 2900 ] 4 11.429% 85.714% ## ( 2900, 4400 ] 5 14.286% 100.000% ### ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 322.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.626 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.13 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.393 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-22:30:00 ... thread 0: (1000000,3000000) ops and (329858.6,334961.2) ops/second in (3.031602,8.956261) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/10 2.15 GB 88.1 1.3 0.0 1.3 4.1 2.8 0.0 1.5 103.3 324.6 12.81 11.89 45 0.285 1343K 1367 0.0 0.0 L1 1/1 10.89 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.2 1.4 256.5 256.1 2.46 2.38 2 1.228 639K 887 0.0 0.0 L2 1/0 1.45 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 21/0 962.24 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.3 211.3 211.1 3.80 3.37 3 1.267 815K 829 0.0 0.0 L4 152/0 9.67 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1068/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1259/11 98.90 GB 0.0 2.9 1.2 1.7 5.6 3.9 1.6 2.0 148.9 292.1 19.78 18.33 51 0.388 2990K 3148 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.2 1.7 5.6 3.9 1.6 2.0 148.9 292.1 19.78 18.33 51 0.388 2990K 3148 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.9 1.2 1.7 2.9 1.2 0.0 0.0 248.8 248.5 11.84 11.20 11 1.076 2990K 3148 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 357.1 7.94 7.13 40 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.64 GB write, 631.81 MB/s write, 2.88 GB read, 322.10 MB/s read, 19.8 seconds Interval compaction: 5.64 GB write, 644.78 MB/s write, 2.88 GB read, 328.71 MB/s read, 19.8 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: 761983 Average: 2.1103 StdDev: 7.29 Min: 1 Median: 1.4502 Max: 2411 Percentiles: P50: 1.45 P75: 1.84 P99: 5.62 P99.9: 10.54 P99.99: 14.79 ------------------------------------------------------ [ 0, 1 ] 161503 21.195% 21.195% #### ( 1, 2 ] 487584 63.989% 85.184% ############# ( 2, 3 ] 67785 8.896% 94.080% ## ( 3, 4 ] 26563 3.486% 97.566% # ( 4, 6 ] 13456 1.766% 99.332% ( 6, 10 ] 4242 0.557% 99.888% ( 10, 15 ] 808 0.106% 99.994% ( 15, 22 ] 68 0.009% 100.003% ( 22, 34 ] 18 0.002% 100.006% ( 34, 51 ] 7 0.001% 100.007% ( 51, 76 ] 6 0.001% 100.007% ( 110, 170 ] 1 0.000% 100.008% ( 170, 250 ] 31 0.004% 100.012% ( 250, 380 ] 3 0.000% 100.012% ( 380, 580 ] 36 0.005% 100.017% ( 580, 870 ] 5 0.001% 100.017% ( 870, 1300 ] 12 0.002% 100.019% ( 1300, 1900 ] 2 0.000% 100.019% ( 1900, 2900 ] 2 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 156916 Average: 2.2617 StdDev: 11.71 Min: 1 Median: 1.5317 Max: 3727 Percentiles: P50: 1.53 P75: 1.91 P99: 5.73 P99.9: 10.93 P99.99: 17.32 ------------------------------------------------------ [ 0, 1 ] 23482 14.965% 14.965% ### ( 1, 2 ] 103396 65.893% 80.857% ############# ( 2, 3 ] 17601 11.217% 92.074% ## ( 3, 4 ] 7381 4.704% 96.778% # ( 4, 6 ] 4031 2.569% 99.347% # ( 6, 10 ] 837 0.533% 99.880% ( 10, 15 ] 167 0.106% 99.987% ( 15, 22 ] 16 0.010% 99.997% ( 22, 34 ] 1 0.001% 99.997% ( 110, 170 ] 1 0.001% 99.998% ( 170, 250 ] 2 0.001% 99.999% ( 250, 380 ] 2 0.001% 100.001% ( 380, 580 ] 6 0.004% 100.004% ( 580, 870 ] 2 0.001% 100.006% ( 870, 1300 ] 2 0.001% 100.007% ( 1300, 1900 ] 1 0.001% 100.008% ( 2900, 4400 ] 1 0.001% 100.008% ** Level 2 read latency histogram (micros): Count: 47601 Average: 2.2994 StdDev: 4.57 Min: 1 Median: 1.5599 Max: 787 Percentiles: P50: 1.56 P75: 1.94 P99: 6.33 P99.9: 12.31 P99.99: 46.69 ------------------------------------------------------ [ 0, 1 ] 6273 13.178% 13.178% ### ( 1, 2 ] 31306 65.768% 78.946% ############# ( 2, 3 ] 5502 11.559% 90.504% ## ( 3, 4 ] 2462 5.172% 95.677% # ( 4, 6 ] 1546 3.248% 98.924% # ( 6, 10 ] 433 0.910% 99.834% ( 10, 15 ] 68 0.143% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 34, 51 ] 3 0.006% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47645 Average: 3.5589 StdDev: 49.14 Min: 0 Median: 1.5545 Max: 3993 Percentiles: P50: 1.55 P75: 1.93 P99: 5.97 P99.9: 214.73 P99.99: 2323.55 ------------------------------------------------------ [ 0, 1 ] 6254 13.126% 13.126% ### ( 1, 2 ] 31686 66.504% 79.631% ############# ( 2, 3 ] 5502 11.548% 91.179% ## ( 3, 4 ] 2543 5.337% 96.516% # ( 4, 6 ] 1200 2.519% 99.035% # ( 6, 10 ] 294 0.617% 99.652% ( 10, 15 ] 77 0.162% 99.813% ( 15, 22 ] 10 0.021% 99.834% ( 22, 34 ] 18 0.038% 99.872% ( 34, 51 ] 3 0.006% 99.878% ( 76, 110 ] 1 0.002% 99.880% ( 110, 170 ] 6 0.013% 99.893% ( 170, 250 ] 6 0.013% 99.906% ( 250, 380 ] 6 0.013% 99.918% ( 380, 580 ] 7 0.015% 99.933% ( 580, 870 ] 10 0.021% 99.954% ( 870, 1300 ] 6 0.013% 99.966% ( 1300, 1900 ] 7 0.015% 99.981% ( 1900, 2900 ] 10 0.021% 100.002% ( 2900, 4400 ] 2 0.004% 100.006% ** Level 4 read latency histogram (micros): Count: 35 Average: 1412.0000 StdDev: 1034.48 Min: 43 Median: 1269.2857 Max: 3701 Percentiles: P50: 1269.29 P75: 1962.50 P99: 3701.00 P99.9: 3701.00 P99.99: 3701.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 3 8.571% 11.429% ## ( 250, 380 ] 3 8.571% 20.000% ## ( 380, 580 ] 3 8.571% 28.571% ## ( 580, 870 ] 1 2.857% 31.429% # ( 870, 1300 ] 7 20.000% 51.429% #### ( 1300, 1900 ] 8 22.857% 74.286% ##### ( 1900, 2900 ] 4 11.429% 85.714% ## ( 2900, 4400 ] 5 14.286% 100.000% ### ** Level 5 read latency histogram (micros): Count: 20 Average: 706.0000 StdDev: 563.53 Min: 271 Median: 491.1111 Max: 2375 Percentiles: P50: 491.11 P75: 725.00 P99: 2375.00 P99.9: 2375.00 P99.99: 2375.00 ------------------------------------------------------ ( 250, 380 ] 5 25.000% 25.000% ##### ( 380, 580 ] 9 45.000% 70.000% ######### ( 580, 870 ] 2 10.000% 80.000% ## ( 870, 1300 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 322.94 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.020 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.64 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.394 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-22:30:03 ... thread 0: (1000000,4000000) ops and (337862.6,335681.9) ops/second in (2.959783,11.916044) 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/13 2.09 GB 37.8 2.0 0.0 2.0 5.8 3.8 0.0 1.5 114.2 325.1 18.21 16.97 62 0.294 2110K 2102 0.0 0.0 L1 11/11 1.05 GB 0.0 1.7 1.5 0.2 1.7 1.5 0.2 1.1 245.9 245.0 6.96 6.73 3 2.320 1737K 5650 0.0 0.0 L2 1/0 1.45 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 21/0 962.24 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.3 211.3 211.1 3.80 3.37 3 1.267 815K 829 0.0 0.0 L4 152/0 9.67 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1068/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/24 99.88 GB 0.0 4.7 2.2 2.5 8.4 5.9 1.6 2.2 161.1 290.3 29.68 27.76 69 0.430 4855K 8646 0.0 0.0 Int 0/0 0.00 KB 0.0 4.7 2.2 2.5 8.4 5.9 1.6 2.2 161.1 290.3 29.68 27.76 69 0.430 4855K 8646 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.7 2.2 2.5 4.7 2.2 0.0 0.0 251.0 250.6 19.05 18.20 15 1.270 4855K 8646 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 361.5 10.63 9.56 54 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.41 GB write, 711.89 MB/s write, 4.67 GB read, 395.11 MB/s read, 29.7 seconds Interval compaction: 8.41 GB write, 722.87 MB/s write, 4.67 GB read, 401.21 MB/s read, 29.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1025796 Average: 2.0948 StdDev: 7.31 Min: 0 Median: 1.4442 Max: 2411 Percentiles: P50: 1.44 P75: 1.83 P99: 5.53 P99.9: 10.31 P99.99: 14.80 ------------------------------------------------------ [ 0, 1 ] 219509 21.399% 21.399% #### ( 1, 2 ] 660482 64.387% 85.786% ############# ( 2, 3 ] 88888 8.665% 94.451% ## ( 3, 4 ] 34181 3.332% 97.784% # ( 4, 6 ] 16275 1.587% 99.370% ( 6, 10 ] 5373 0.524% 99.894% ( 10, 15 ] 1028 0.100% 99.994% ( 15, 22 ] 83 0.008% 100.002% ( 22, 34 ] 27 0.003% 100.005% ( 34, 51 ] 7 0.001% 100.006% ( 51, 76 ] 6 0.001% 100.006% ( 110, 170 ] 2 0.000% 100.006% ( 170, 250 ] 43 0.004% 100.011% ( 250, 380 ] 7 0.001% 100.011% ( 380, 580 ] 44 0.004% 100.016% ( 580, 870 ] 10 0.001% 100.016% ( 870, 1300 ] 14 0.001% 100.018% ( 1300, 1900 ] 4 0.000% 100.018% ( 1900, 2900 ] 3 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 206293 Average: 2.2227 StdDev: 11.64 Min: 1 Median: 1.4922 Max: 3727 Percentiles: P50: 1.49 P75: 1.88 P99: 5.64 P99.9: 10.66 P99.99: 201.61 ------------------------------------------------------ [ 0, 1 ] 36993 17.932% 17.932% #### ( 1, 2 ] 134415 65.157% 83.090% ############# ( 2, 3 ] 20689 10.029% 93.119% ## ( 3, 4 ] 8473 4.107% 97.226% # ( 4, 6 ] 4469 2.166% 99.392% ( 6, 10 ] 1023 0.496% 99.888% ( 10, 15 ] 187 0.091% 99.979% ( 15, 22 ] 18 0.009% 99.987% ( 22, 34 ] 1 0.000% 99.988% ( 51, 76 ] 1 0.000% 99.988% ( 110, 170 ] 1 0.000% 99.989% ( 170, 250 ] 6 0.003% 99.992% ( 250, 380 ] 3 0.001% 99.993% ( 380, 580 ] 13 0.006% 100.000% ( 580, 870 ] 8 0.004% 100.003% ( 870, 1300 ] 4 0.002% 100.005% ( 1300, 1900 ] 1 0.000% 100.006% ( 2900, 4400 ] 1 0.000% 100.006% ** Level 2 read latency histogram (micros): Count: 47601 Average: 2.2994 StdDev: 4.57 Min: 1 Median: 1.5599 Max: 787 Percentiles: P50: 1.56 P75: 1.94 P99: 6.33 P99.9: 12.31 P99.99: 46.69 ------------------------------------------------------ [ 0, 1 ] 6273 13.178% 13.178% ### ( 1, 2 ] 31306 65.768% 78.946% ############# ( 2, 3 ] 5502 11.559% 90.504% ## ( 3, 4 ] 2462 5.172% 95.677% # ( 4, 6 ] 1546 3.248% 98.924% # ( 6, 10 ] 433 0.910% 99.834% ( 10, 15 ] 68 0.143% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 34, 51 ] 3 0.006% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47645 Average: 3.5589 StdDev: 49.14 Min: 0 Median: 1.5545 Max: 3993 Percentiles: P50: 1.55 P75: 1.93 P99: 5.97 P99.9: 214.73 P99.99: 2323.55 ------------------------------------------------------ [ 0, 1 ] 6254 13.126% 13.126% ### ( 1, 2 ] 31686 66.504% 79.631% ############# ( 2, 3 ] 5502 11.548% 91.179% ## ( 3, 4 ] 2543 5.337% 96.516% # ( 4, 6 ] 1200 2.519% 99.035% # ( 6, 10 ] 294 0.617% 99.652% ( 10, 15 ] 77 0.162% 99.813% ( 15, 22 ] 10 0.021% 99.834% ( 22, 34 ] 18 0.038% 99.872% ( 34, 51 ] 3 0.006% 99.878% ( 76, 110 ] 1 0.002% 99.880% ( 110, 170 ] 6 0.013% 99.893% ( 170, 250 ] 6 0.013% 99.906% ( 250, 380 ] 6 0.013% 99.918% ( 380, 580 ] 7 0.015% 99.933% ( 580, 870 ] 10 0.021% 99.954% ( 870, 1300 ] 6 0.013% 99.966% ( 1300, 1900 ] 7 0.015% 99.981% ( 1900, 2900 ] 10 0.021% 100.002% ( 2900, 4400 ] 2 0.004% 100.006% ** Level 4 read latency histogram (micros): Count: 35 Average: 1412.0000 StdDev: 1034.48 Min: 43 Median: 1269.2857 Max: 3701 Percentiles: P50: 1269.29 P75: 1962.50 P99: 3701.00 P99.9: 3701.00 P99.99: 3701.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 3 8.571% 11.429% ## ( 250, 380 ] 3 8.571% 20.000% ## ( 380, 580 ] 3 8.571% 28.571% ## ( 580, 870 ] 1 2.857% 31.429% # ( 870, 1300 ] 7 20.000% 51.429% #### ( 1300, 1900 ] 8 22.857% 74.286% ##### ( 1900, 2900 ] 4 11.429% 85.714% ## ( 2900, 4400 ] 5 14.286% 100.000% ### ** Level 5 read latency histogram (micros): Count: 20 Average: 706.0000 StdDev: 563.53 Min: 271 Median: 491.1111 Max: 2375 Percentiles: P50: 491.11 P75: 725.00 P99: 2375.00 P99.9: 2375.00 P99.99: 2375.00 ------------------------------------------------------ ( 250, 380 ] 5 25.000% 25.000% ##### ( 380, 580 ] 9 45.000% 70.000% ######### ( 580, 870 ] 2 10.000% 80.000% ## ( 870, 1300 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 325.28 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.362 H:M:S, 11.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.52 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.342 H:M:S, 11.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-22:30:07 ... thread 0: (1000000,5000000) ops and (288237.4,324983.3) ops/second in (3.469363,15.385407) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/13 3.07 GB 144.8 3.1 0.0 3.1 7.8 4.7 0.0 1.6 127.0 322.3 24.81 23.18 82 0.303 3198K 3164 0.0 0.0 L1 11/11 1.05 GB 0.0 1.7 1.5 0.2 1.7 1.5 0.2 1.1 245.9 245.0 6.96 6.73 3 2.320 1737K 5650 0.0 0.0 L2 1/0 1.45 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 21/0 962.24 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.3 211.3 211.1 3.80 3.37 3 1.267 815K 829 0.0 0.0 L4 152/0 9.67 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1068/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/24 100.86 GB 0.0 5.7 2.2 3.5 10.4 6.9 1.6 2.2 161.3 294.7 36.29 33.97 89 0.408 5942K 9708 0.0 0.0 Int 0/0 0.00 KB 0.0 5.7 2.2 3.5 10.4 6.9 1.6 2.2 161.3 294.7 36.29 33.97 89 0.408 5942K 9708 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.7 2.2 3.5 5.7 2.2 0.0 0.0 255.6 255.1 22.90 21.97 19 1.205 5942K 9708 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 362.4 13.38 12.00 70 0.191 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.6 total, 15.4 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.44 GB write, 686.72 MB/s write, 5.72 GB read, 375.86 MB/s read, 36.3 seconds Interval compaction: 10.44 GB write, 694.92 MB/s write, 5.72 GB read, 380.35 MB/s read, 36.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: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 7, total-stops: 11, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1413583 Average: 2.1438 StdDev: 7.97 Min: 0 Median: 1.4570 Max: 2411 Percentiles: P50: 1.46 P75: 1.84 P99: 5.57 P99.9: 11.06 P99.99: 21.47 ------------------------------------------------------ [ 0, 1 ] 285796 20.218% 20.218% #### ( 1, 2 ] 921235 65.170% 85.388% ############# ( 2, 3 ] 125842 8.902% 94.290% ## ( 3, 4 ] 48988 3.466% 97.756% # ( 4, 6 ] 22439 1.587% 99.343% ( 6, 10 ] 7554 0.534% 99.878% ( 10, 15 ] 1486 0.105% 99.983% ( 15, 22 ] 111 0.008% 99.991% ( 22, 34 ] 40 0.003% 99.993% ( 34, 51 ] 8 0.001% 99.994% ( 51, 76 ] 58 0.004% 99.998% ( 76, 110 ] 25 0.002% 100.000% ( 110, 170 ] 51 0.004% 100.004% ( 170, 250 ] 111 0.008% 100.011% ( 250, 380 ] 46 0.003% 100.015% ( 380, 580 ] 70 0.005% 100.020% ( 580, 870 ] 22 0.002% 100.021% ( 870, 1300 ] 20 0.001% 100.023% ( 1300, 1900 ] 5 0.000% 100.023% ( 1900, 2900 ] 4 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 293973 Average: 2.3687 StdDev: 13.30 Min: 1 Median: 1.4977 Max: 3727 Percentiles: P50: 1.50 P75: 1.88 P99: 5.94 P99.9: 14.31 P99.99: 394.57 ------------------------------------------------------ [ 0, 1 ] 50538 17.191% 17.191% ### ( 1, 2 ] 193787 65.920% 83.111% ############# ( 2, 3 ] 28965 9.853% 92.964% ## ( 3, 4 ] 11773 4.005% 96.969% # ( 4, 6 ] 6150 2.092% 99.061% ( 6, 10 ] 2243 0.763% 99.824% ( 10, 15 ] 259 0.088% 99.912% ( 15, 22 ] 25 0.009% 99.921% ( 22, 34 ] 1 0.000% 99.921% ( 51, 76 ] 41 0.014% 99.935% ( 76, 110 ] 21 0.007% 99.942% ( 110, 170 ] 29 0.010% 99.952% ( 170, 250 ] 59 0.020% 99.972% ( 250, 380 ] 51 0.017% 99.989% ( 380, 580 ] 22 0.007% 99.997% ( 580, 870 ] 11 0.004% 100.001% ( 870, 1300 ] 6 0.002% 100.003% ( 1300, 1900 ] 3 0.001% 100.004% ( 1900, 2900 ] 1 0.000% 100.004% ( 2900, 4400 ] 1 0.000% 100.004% ** Level 2 read latency histogram (micros): Count: 47601 Average: 2.2994 StdDev: 4.57 Min: 1 Median: 1.5599 Max: 787 Percentiles: P50: 1.56 P75: 1.94 P99: 6.33 P99.9: 12.31 P99.99: 46.69 ------------------------------------------------------ [ 0, 1 ] 6273 13.178% 13.178% ### ( 1, 2 ] 31306 65.768% 78.946% ############# ( 2, 3 ] 5502 11.559% 90.504% ## ( 3, 4 ] 2462 5.172% 95.677% # ( 4, 6 ] 1546 3.248% 98.924% # ( 6, 10 ] 433 0.910% 99.834% ( 10, 15 ] 68 0.143% 99.977% ( 15, 22 ] 4 0.008% 99.985% ( 34, 51 ] 3 0.006% 99.992% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 47645 Average: 3.5589 StdDev: 49.14 Min: 0 Median: 1.5545 Max: 3993 Percentiles: P50: 1.55 P75: 1.93 P99: 5.97 P99.9: 214.73 P99.99: 2323.55 ------------------------------------------------------ [ 0, 1 ] 6254 13.126% 13.126% ### ( 1, 2 ] 31686 66.504% 79.631% ############# ( 2, 3 ] 5502 11.548% 91.179% ## ( 3, 4 ] 2543 5.337% 96.516% # ( 4, 6 ] 1200 2.519% 99.035% # ( 6, 10 ] 294 0.617% 99.652% ( 10, 15 ] 77 0.162% 99.813% ( 15, 22 ] 10 0.021% 99.834% ( 22, 34 ] 18 0.038% 99.872% ( 34, 51 ] 3 0.006% 99.878% ( 76, 110 ] 1 0.002% 99.880% ( 110, 170 ] 6 0.013% 99.893% ( 170, 250 ] 6 0.013% 99.906% ( 250, 380 ] 6 0.013% 99.918% ( 380, 580 ] 7 0.015% 99.933% ( 580, 870 ] 10 0.021% 99.954% ( 870, 1300 ] 6 0.013% 99.966% ( 1300, 1900 ] 7 0.015% 99.981% ( 1900, 2900 ] 10 0.021% 100.002% ( 2900, 4400 ] 2 0.004% 100.006% ** Level 4 read latency histogram (micros): Count: 35 Average: 1412.0000 StdDev: 1034.48 Min: 43 Median: 1269.2857 Max: 3701 Percentiles: P50: 1269.29 P75: 1962.50 P99: 3701.00 P99.9: 3701.00 P99.99: 3701.00 ------------------------------------------------------ ( 34, 51 ] 1 2.857% 2.857% # ( 110, 170 ] 3 8.571% 11.429% ## ( 250, 380 ] 3 8.571% 20.000% ## ( 380, 580 ] 3 8.571% 28.571% ## ( 580, 870 ] 1 2.857% 31.429% # ( 870, 1300 ] 7 20.000% 51.429% #### ( 1300, 1900 ] 8 22.857% 74.286% ##### ( 1900, 2900 ] 4 11.429% 85.714% ## ( 2900, 4400 ] 5 14.286% 100.000% ### ** Level 5 read latency histogram (micros): Count: 20 Average: 706.0000 StdDev: 563.53 Min: 271 Median: 491.1111 Max: 2375 Percentiles: P50: 491.11 P75: 725.00 P99: 2375.00 P99.9: 2375.00 P99.99: 2375.00 ------------------------------------------------------ ( 250, 380 ] 5 25.000% 25.000% ##### ( 380, 580 ] 9 45.000% 70.000% ######### ( 580, 870 ] 2 10.000% 80.000% ## ( 870, 1300 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 15.6 total, 3.5 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 316.01 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.201 H:M:S, 14.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 283.68 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.839 H:M:S, 24.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-22:30:15 ... thread 0: (1000000,6000000) ops and (123718.8,255664.6) ops/second in (8.082844,23.468251) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/8 2.57 GB 12.6 5.1 0.0 5.1 10.8 5.6 0.0 1.9 141.1 297.2 37.05 33.16 99 0.374 5308K 11K 0.0 0.0 L1 5/5 437.72 MB 0.0 4.1 2.9 1.2 4.1 2.9 0.2 1.4 240.3 238.5 17.63 16.87 4 4.406 4300K 31K 0.0 0.0 L2 1/1 1.45 MB 0.0 0.2 0.1 0.1 0.2 0.1 2.6 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 24/11 1.79 GB 0.9 1.3 1.0 0.3 1.3 1.0 1.7 1.3 181.4 180.9 7.43 5.72 5 1.486 1338K 2520 0.0 0.0 L4 173/17 10.83 GB 1.0 1.0 0.8 0.3 1.0 0.7 0.8 1.3 123.6 123.0 8.35 4.59 6 1.392 1028K 4136 0.0 0.0 L5 1068/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1280/42 101.75 GB 0.0 11.7 4.7 7.0 17.4 10.4 5.6 3.1 169.0 249.8 71.17 61.02 115 0.619 12M 49K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.7 4.7 7.0 17.4 10.4 5.6 3.1 169.0 249.8 71.17 61.02 115 0.619 12M 49K 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 11.7 4.7 7.0 11.7 4.7 0.0 0.0 221.9 221.0 54.22 46.63 32 1.694 12M 49K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 341.9 16.95 14.39 83 0.204 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): 23.7 total, 23.5 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.36 GB write, 751.48 MB/s write, 11.75 GB read, 508.64 MB/s read, 71.2 seconds Interval compaction: 17.36 GB write, 757.37 MB/s write, 11.75 GB read, 512.62 MB/s read, 71.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 24, interval: 37 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2146062 Average: 2.4682 StdDev: 19.76 Min: 0 Median: 1.4816 Max: 8640 Percentiles: P50: 1.48 P75: 1.87 P99: 5.97 P99.9: 18.24 P99.99: 305.56 ------------------------------------------------------ [ 0, 1 ] 406745 18.953% 18.953% #### ( 1, 2 ] 1383565 64.470% 83.423% ############# ( 2, 3 ] 199695 9.305% 92.728% ## ( 3, 4 ] 85756 3.996% 96.724% # ( 4, 6 ] 49534 2.308% 99.032% ( 6, 10 ] 16001 0.746% 99.778% ( 10, 15 ] 2468 0.115% 99.893% ( 15, 22 ] 330 0.015% 99.908% ( 22, 34 ] 53 0.002% 99.911% ( 34, 51 ] 12 0.001% 99.911% ( 51, 76 ] 406 0.019% 99.930% ( 76, 110 ] 207 0.010% 99.940% ( 110, 170 ] 474 0.022% 99.962% ( 170, 250 ] 487 0.023% 99.985% ( 250, 380 ] 270 0.013% 99.997% ( 380, 580 ] 268 0.012% 100.010% ( 580, 870 ] 141 0.007% 100.016% ( 870, 1300 ] 74 0.003% 100.020% ( 1300, 1900 ] 22 0.001% 100.021% ( 1900, 2900 ] 19 0.001% 100.022% ( 2900, 4400 ] 19 0.001% 100.023% ( 4400, 6600 ] 3 0.000% 100.023% ( 6600, 9900 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 726387 Average: 3.4075 StdDev: 47.56 Min: 1 Median: 1.6415 Max: 7738 Percentiles: P50: 1.64 P75: 2.23 P99: 7.99 P99.9: 55.18 P99.99: 305.91 ------------------------------------------------------ [ 0, 1 ] 81599 11.234% 11.234% ## ( 1, 2 ] 438933 60.427% 71.660% ############ ( 2, 3 ] 104000 14.317% 85.978% ### ( 3, 4 ] 49322 6.790% 92.768% # ( 4, 6 ] 40312 5.550% 98.318% # ( 6, 10 ] 9973 1.373% 99.691% ( 10, 15 ] 1303 0.179% 99.870% ( 15, 22 ] 157 0.022% 99.892% ( 22, 34 ] 18 0.002% 99.894% ( 34, 51 ] 7 0.001% 99.895% ( 51, 76 ] 219 0.030% 99.925% ( 76, 110 ] 91 0.013% 99.938% ( 110, 170 ] 155 0.021% 99.959% ( 170, 250 ] 163 0.022% 99.981% ( 250, 380 ] 145 0.020% 100.001% ( 380, 580 ] 152 0.021% 100.022% ( 580, 870 ] 119 0.016% 100.039% ( 870, 1300 ] 46 0.006% 100.045% ( 1300, 1900 ] 19 0.003% 100.048% ( 1900, 2900 ] 31 0.004% 100.052% ( 2900, 4400 ] 48 0.007% 100.059% ( 4400, 6600 ] 9 0.001% 100.060% ( 6600, 9900 ] 7 0.001% 100.061% ** Level 2 read latency histogram (micros): Count: 47823 Average: 4.7012 StdDev: 90.36 Min: 1 Median: 1.5626 Max: 9034 Percentiles: P50: 1.56 P75: 1.94 P99: 6.93 P99.9: 559.43 P99.99: 4177.21 ------------------------------------------------------ [ 0, 1 ] 6273 13.117% 13.117% ### ( 1, 2 ] 31353 65.561% 78.678% ############# ( 2, 3 ] 5581 11.670% 90.348% ## ( 3, 4 ] 2477 5.180% 95.527% # ( 4, 6 ] 1559 3.260% 98.787% # ( 6, 10 ] 436 0.912% 99.699% ( 10, 15 ] 69 0.144% 99.843% ( 15, 22 ] 4 0.008% 99.852% ( 34, 51 ] 3 0.006% 99.858% ( 110, 170 ] 1 0.002% 99.860% ( 170, 250 ] 6 0.013% 99.872% ( 250, 380 ] 6 0.013% 99.885% ( 380, 580 ] 8 0.017% 99.902% ( 580, 870 ] 8 0.017% 99.918% ( 870, 1300 ] 10 0.021% 99.939% ( 1300, 1900 ] 5 0.010% 99.950% ( 1900, 2900 ] 9 0.019% 99.969% ( 2900, 4400 ] 12 0.025% 99.994% ( 4400, 6600 ] 1 0.002% 99.996% ( 6600, 9900 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 258890 Average: 9.9667 StdDev: 117.10 Min: 0 Median: 1.7905 Max: 8538 Percentiles: P50: 1.79 P75: 2.74 P99: 13.50 P99.9: 1079.60 P99.99: 2054.19 ------------------------------------------------------ [ 0, 1 ] 14142 5.463% 5.463% # ( 1, 2 ] 145854 56.338% 61.801% ########### ( 2, 3 ] 46419 17.930% 79.731% #### ( 3, 4 ] 25095 9.693% 89.424% ## ( 4, 6 ] 18622 7.193% 96.617% # ( 6, 10 ] 5582 2.156% 98.773% ( 10, 15 ] 839 0.324% 99.097% ( 15, 22 ] 86 0.033% 99.131% ( 22, 34 ] 31 0.012% 99.142% ( 34, 51 ] 13 0.005% 99.148% ( 51, 76 ] 31 0.012% 99.159% ( 76, 110 ] 38 0.015% 99.174% ( 110, 170 ] 123 0.048% 99.222% ( 170, 250 ] 238 0.092% 99.314% ( 250, 380 ] 424 0.164% 99.477% ( 380, 580 ] 570 0.220% 99.698% ( 580, 870 ] 412 0.159% 99.857% ( 870, 1300 ] 230 0.089% 99.946% ( 1300, 1900 ] 100 0.039% 99.984% ( 1900, 2900 ] 98 0.038% 100.022% ( 2900, 4400 ] 88 0.034% 100.056% ( 4400, 6600 ] 23 0.009% 100.065% ( 6600, 9900 ] 6 0.002% 100.067% ** Level 4 read latency histogram (micros): Count: 17448 Average: 7.2549 StdDev: 89.33 Min: 1 Median: 1.9537 Max: 3701 Percentiles: P50: 1.95 P75: 2.95 P99: 9.51 P99.9: 1527.60 P99.99: 3701.00 ------------------------------------------------------ [ 0, 1 ] 259 1.484% 1.484% ( 1, 2 ] 8876 50.871% 52.356% ########## ( 2, 3 ] 4138 23.716% 76.072% ##### ( 3, 4 ] 2093 11.996% 88.067% ## ( 4, 6 ] 1705 9.772% 97.839% ## ( 6, 10 ] 231 1.324% 99.163% ( 10, 15 ] 62 0.355% 99.519% ( 15, 22 ] 1 0.006% 99.524% ( 22, 34 ] 1 0.006% 99.530% ( 34, 51 ] 1 0.006% 99.536% ( 110, 170 ] 11 0.063% 99.599% ( 170, 250 ] 16 0.092% 99.691% ( 250, 380 ] 5 0.029% 99.719% ( 380, 580 ] 7 0.040% 99.759% ( 580, 870 ] 6 0.034% 99.794% ( 870, 1300 ] 14 0.080% 99.874% ( 1300, 1900 ] 12 0.069% 99.943% ( 1900, 2900 ] 4 0.023% 99.966% ( 2900, 4400 ] 6 0.034% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 706.0000 StdDev: 563.53 Min: 271 Median: 491.1111 Max: 2375 Percentiles: P50: 491.11 P75: 725.00 P99: 2375.00 P99.9: 2375.00 P99.99: 2375.00 ------------------------------------------------------ ( 250, 380 ] 5 25.000% 25.000% ##### ( 380, 580 ] 9 45.000% 70.000% ######### ( 580, 870 ] 2 10.000% 80.000% ## ( 870, 1300 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 23.7 total, 8.1 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 249.64 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:7.425 H:M:S, 31.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 121.76 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:5.224 H:M:S, 64.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/12-22:30:18 ... thread 0: (1000000,7000000) ops and (343582.9,265365.0) ops/second in (2.910506,26.378757) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/12 3.50 GB 81.8 5.7 0.0 5.7 12.2 6.6 0.0 1.9 138.6 299.5 41.82 37.54 115 0.364 5883K 11K 0.0 0.0 L1 5/5 437.72 MB 0.0 4.1 2.9 1.2 4.1 2.9 0.2 1.4 240.3 238.5 17.63 16.87 4 4.406 4300K 31K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.6 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 14/1 959.85 MB 0.9 2.0 1.0 1.1 2.0 1.0 1.7 2.1 184.4 184.0 11.33 8.62 6 1.889 2092K 3992 0.0 0.0 L4 175/15 10.70 GB 1.0 1.2 0.9 0.3 1.2 0.9 1.5 1.3 131.5 130.9 9.11 5.28 7 1.301 1196K 4225 0.0 0.0 L5 1080/0 87.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1291/33 102.67 GB 0.0 13.2 4.9 8.3 19.7 11.4 7.3 3.0 167.6 250.5 80.60 68.99 133 0.606 13M 51K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.2 4.9 8.3 19.7 11.4 7.3 3.0 167.6 250.5 80.60 68.99 133 0.606 13M 51K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.2 4.9 8.3 13.1 4.8 0.0 0.0 221.3 220.5 61.02 52.32 36 1.695 13M 51K 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 344.2 19.58 16.67 97 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 26.6 total, 26.4 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 19.72 GB write, 760.14 MB/s write, 13.19 GB read, 508.41 MB/s read, 80.6 seconds Interval compaction: 19.72 GB write, 765.43 MB/s write, 13.19 GB read, 511.95 MB/s read, 80.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 27, interval: 40 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2489100 Average: 2.4949 StdDev: 18.66 Min: 0 Median: 1.5105 Max: 8640 Percentiles: P50: 1.51 P75: 1.90 P99: 6.16 P99.9: 14.70 P99.99: 241.77 ------------------------------------------------------ [ 0, 1 ] 427261 17.165% 17.165% ### ( 1, 2 ] 1601065 64.323% 81.488% ############# ( 2, 3 ] 258282 10.377% 91.865% ## ( 3, 4 ] 110106 4.424% 96.288% # ( 4, 6 ] 66682 2.679% 98.967% # ( 6, 10 ] 20286 0.815% 99.782% ( 10, 15 ] 3118 0.125% 99.908% ( 15, 22 ] 380 0.015% 99.923% ( 22, 34 ] 57 0.002% 99.925% ( 34, 51 ] 14 0.001% 99.926% ( 51, 76 ] 417 0.017% 99.942% ( 76, 110 ] 215 0.009% 99.951% ( 110, 170 ] 489 0.020% 99.971% ( 170, 250 ] 534 0.021% 99.992% ( 250, 380 ] 304 0.012% 100.004% ( 380, 580 ] 303 0.012% 100.017% ( 580, 870 ] 148 0.006% 100.023% ( 870, 1300 ] 80 0.003% 100.026% ( 1300, 1900 ] 22 0.001% 100.027% ( 1900, 2900 ] 20 0.001% 100.027% ( 2900, 4400 ] 19 0.001% 100.028% ( 4400, 6600 ] 3 0.000% 100.028% ( 6600, 9900 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 754611 Average: 3.3964 StdDev: 46.73 Min: 1 Median: 1.6450 Max: 7738 Percentiles: P50: 1.65 P75: 2.25 P99: 8.05 P99.9: 59.34 P99.99: 314.62 ------------------------------------------------------ [ 0, 1 ] 82990 10.998% 10.998% ## ( 1, 2 ] 456295 60.468% 71.465% ############ ( 2, 3 ] 108803 14.418% 85.884% ### ( 3, 4 ] 51687 6.849% 92.733% # ( 4, 6 ] 41839 5.544% 98.278% # ( 6, 10 ] 10615 1.407% 99.684% ( 10, 15 ] 1362 0.180% 99.865% ( 15, 22 ] 164 0.022% 99.887% ( 22, 34 ] 19 0.003% 99.889% ( 34, 51 ] 7 0.001% 99.890% ( 51, 76 ] 226 0.030% 99.920% ( 76, 110 ] 103 0.014% 99.934% ( 110, 170 ] 171 0.023% 99.956% ( 170, 250 ] 177 0.023% 99.980% ( 250, 380 ] 156 0.021% 100.000% ( 380, 580 ] 156 0.021% 100.021% ( 580, 870 ] 121 0.016% 100.037% ( 870, 1300 ] 47 0.006% 100.043% ( 1300, 1900 ] 19 0.003% 100.046% ( 1900, 2900 ] 31 0.004% 100.050% ( 2900, 4400 ] 48 0.006% 100.056% ( 4400, 6600 ] 9 0.001% 100.058% ( 6600, 9900 ] 7 0.001% 100.058% ** Level 2 read latency histogram (micros): Count: 47969 Average: 4.8565 StdDev: 90.57 Min: 1 Median: 1.5640 Max: 9034 Percentiles: P50: 1.56 P75: 1.95 P99: 7.15 P99.9: 581.00 P99.99: 4175.39 ------------------------------------------------------ [ 0, 1 ] 6273 13.077% 13.077% ### ( 1, 2 ] 31402 65.463% 78.540% ############# ( 2, 3 ] 5627 11.730% 90.271% ## ( 3, 4 ] 2491 5.193% 95.464% # ( 4, 6 ] 1570 3.273% 98.737% # ( 6, 10 ] 439 0.915% 99.652% ( 10, 15 ] 70 0.146% 99.798% ( 15, 22 ] 4 0.008% 99.806% ( 34, 51 ] 3 0.006% 99.812% ( 110, 170 ] 1 0.002% 99.814% ( 170, 250 ] 10 0.021% 99.835% ( 250, 380 ] 15 0.031% 99.867% ( 380, 580 ] 16 0.033% 99.900% ( 580, 870 ] 9 0.019% 99.919% ( 870, 1300 ] 10 0.021% 99.940% ( 1300, 1900 ] 5 0.010% 99.950% ( 1900, 2900 ] 9 0.019% 99.969% ( 2900, 4400 ] 12 0.025% 99.994% ( 4400, 6600 ] 1 0.002% 99.996% ( 6600, 9900 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 340278 Average: 8.5173 StdDev: 103.08 Min: 0 Median: 1.7780 Max: 8538 Percentiles: P50: 1.78 P75: 2.68 P99: 10.98 P99.9: 894.90 P99.99: 1756.73 ------------------------------------------------------ [ 0, 1 ] 17435 5.124% 5.124% # ( 1, 2 ] 196274 57.680% 62.804% ############ ( 2, 3 ] 60919 17.903% 80.707% #### ( 3, 4 ] 32022 9.411% 90.117% ## ( 4, 6 ] 22826 6.708% 96.826% # ( 6, 10 ] 7202 2.117% 98.942% ( 10, 15 ] 1004 0.295% 99.237% ( 15, 22 ] 97 0.029% 99.266% ( 22, 34 ] 33 0.010% 99.275% ( 34, 51 ] 13 0.004% 99.279% ( 51, 76 ] 39 0.011% 99.291% ( 76, 110 ] 47 0.014% 99.304% ( 110, 170 ] 137 0.040% 99.345% ( 170, 250 ] 298 0.088% 99.432% ( 250, 380 ] 525 0.154% 99.587% ( 380, 580 ] 628 0.185% 99.771% ( 580, 870 ] 425 0.125% 99.896% ( 870, 1300 ] 237 0.070% 99.966% ( 1300, 1900 ] 109 0.032% 99.998% ( 1900, 2900 ] 98 0.029% 100.026% ( 2900, 4400 ] 88 0.026% 100.052% ( 4400, 6600 ] 23 0.007% 100.059% ( 6600, 9900 ] 6 0.002% 100.061% ** Level 4 read latency histogram (micros): Count: 18082 Average: 7.1933 StdDev: 88.00 Min: 1 Median: 1.9400 Max: 3701 Percentiles: P50: 1.94 P75: 2.94 P99: 9.54 P99.9: 1495.90 P99.99: 3701.00 ------------------------------------------------------ [ 0, 1 ] 304 1.681% 1.681% ( 1, 2 ] 9295 51.405% 53.086% ########## ( 2, 3 ] 4230 23.393% 76.479% ##### ( 3, 4 ] 2138 11.824% 88.303% ## ( 4, 6 ] 1722 9.523% 97.827% ## ( 6, 10 ] 240 1.327% 99.154% ( 10, 15 ] 62 0.343% 99.497% ( 15, 22 ] 1 0.006% 99.502% ( 22, 34 ] 2 0.011% 99.513% ( 34, 51 ] 1 0.006% 99.519% ( 110, 170 ] 13 0.072% 99.591% ( 170, 250 ] 17 0.094% 99.685% ( 250, 380 ] 6 0.033% 99.718% ( 380, 580 ] 8 0.044% 99.762% ( 580, 870 ] 7 0.039% 99.801% ( 870, 1300 ] 14 0.077% 99.878% ( 1300, 1900 ] 12 0.066% 99.945% ( 1900, 2900 ] 4 0.022% 99.967% ( 2900, 4400 ] 6 0.033% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 625.4125 StdDev: 542.37 Min: 56 Median: 417.5000 Max: 2375 Percentiles: P50: 417.50 P75: 931.43 P99: 2375.00 P99.9: 2375.00 P99.99: 2375.00 ------------------------------------------------------ ( 51, 76 ] 5 6.250% 6.250% # ( 76, 110 ] 3 3.750% 10.000% # ( 110, 170 ] 4 5.000% 15.000% # ( 170, 250 ] 10 12.500% 27.500% ### ( 250, 380 ] 15 18.750% 46.250% #### ( 380, 580 ] 16 20.000% 66.250% #### ( 580, 870 ] 6 7.500% 73.750% ## ( 870, 1300 ] 7 8.750% 82.500% ## ( 1300, 1900 ] 12 15.000% 97.500% ### ( 1900, 2900 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 26.6 total, 2.9 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 259.34 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:7.627 H:M:S, 28.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 338.14 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.202 H:M:S, 7.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/12-22:30:22 ... thread 0: (1000000,8000000) ops and (222223.7,259078.0) ops/second in (4.499970,30.878727) 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/8 4.54 GB 214.0 7.0 0.0 7.0 14.6 7.6 0.0 1.9 143.6 300.9 49.58 44.86 136 0.365 7227K 13K 0.0 0.0 L1 5/5 437.72 MB 0.0 4.1 2.9 1.2 4.1 2.9 0.2 1.4 240.3 238.5 17.63 16.87 4 4.406 4300K 31K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.6 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 13/0 946.71 MB 0.9 2.0 1.0 1.1 2.0 1.0 1.7 2.1 184.4 184.0 11.33 8.62 6 1.889 2092K 3992 0.0 0.0 L4 162/0 9.70 GB 1.0 2.4 0.9 1.5 2.4 0.9 1.5 2.7 166.6 165.8 14.83 10.40 8 1.853 1785K 4225 0.0 0.0 L5 1088/0 88.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1286/13 103.70 GB 0.0 15.7 4.9 10.8 23.3 12.5 8.3 3.1 171.2 253.5 94.08 81.44 155 0.607 15M 52K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.7 4.9 10.8 23.3 12.5 8.3 3.1 171.2 253.5 94.08 81.44 155 0.607 15M 52K 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 15.7 4.9 10.8 15.7 4.8 0.0 0.0 224.9 224.0 71.60 62.21 42 1.705 15M 52K 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 347.6 22.47 19.23 113 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.1 total, 30.9 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 23.29 GB write, 767.77 MB/s write, 15.72 GB read, 518.33 MB/s read, 94.1 seconds Interval compaction: 23.29 GB write, 772.34 MB/s write, 15.72 GB read, 521.41 MB/s read, 94.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 28, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 28, interval: 51 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3058342 Average: 2.4680 StdDev: 17.21 Min: 0 Median: 1.5172 Max: 8640 Percentiles: P50: 1.52 P75: 1.90 P99: 6.18 P99.9: 14.15 P99.99: 215.48 ------------------------------------------------------ [ 0, 1 ] 504184 16.486% 16.486% ### ( 1, 2 ] 1981937 64.804% 81.290% ############# ( 2, 3 ] 324466 10.609% 91.899% ## ( 3, 4 ] 135430 4.428% 96.327% # ( 4, 6 ] 80610 2.636% 98.963% # ( 6, 10 ] 25469 0.833% 99.796% ( 10, 15 ] 3843 0.126% 99.921% ( 15, 22 ] 454 0.015% 99.936% ( 22, 34 ] 69 0.002% 99.939% ( 34, 51 ] 18 0.001% 99.939% ( 51, 76 ] 438 0.014% 99.953% ( 76, 110 ] 223 0.007% 99.961% ( 110, 170 ] 538 0.018% 99.978% ( 170, 250 ] 630 0.021% 99.999% ( 250, 380 ] 365 0.012% 100.011% ( 380, 580 ] 330 0.011% 100.022% ( 580, 870 ] 161 0.005% 100.027% ( 870, 1300 ] 84 0.003% 100.030% ( 1300, 1900 ] 23 0.001% 100.030% ( 1900, 2900 ] 20 0.001% 100.031% ( 2900, 4400 ] 20 0.001% 100.032% ( 4400, 6600 ] 3 0.000% 100.032% ( 6600, 9900 ] 1 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 754611 Average: 3.3964 StdDev: 46.73 Min: 1 Median: 1.6450 Max: 7738 Percentiles: P50: 1.65 P75: 2.25 P99: 8.05 P99.9: 59.34 P99.99: 314.62 ------------------------------------------------------ [ 0, 1 ] 82990 10.998% 10.998% ## ( 1, 2 ] 456295 60.468% 71.465% ############ ( 2, 3 ] 108803 14.418% 85.884% ### ( 3, 4 ] 51687 6.849% 92.733% # ( 4, 6 ] 41839 5.544% 98.278% # ( 6, 10 ] 10615 1.407% 99.684% ( 10, 15 ] 1362 0.180% 99.865% ( 15, 22 ] 164 0.022% 99.887% ( 22, 34 ] 19 0.003% 99.889% ( 34, 51 ] 7 0.001% 99.890% ( 51, 76 ] 226 0.030% 99.920% ( 76, 110 ] 103 0.014% 99.934% ( 110, 170 ] 171 0.023% 99.956% ( 170, 250 ] 177 0.023% 99.980% ( 250, 380 ] 156 0.021% 100.000% ( 380, 580 ] 156 0.021% 100.021% ( 580, 870 ] 121 0.016% 100.037% ( 870, 1300 ] 47 0.006% 100.043% ( 1300, 1900 ] 19 0.003% 100.046% ( 1900, 2900 ] 31 0.004% 100.050% ( 2900, 4400 ] 48 0.006% 100.056% ( 4400, 6600 ] 9 0.001% 100.058% ( 6600, 9900 ] 7 0.001% 100.058% ** Level 2 read latency histogram (micros): Count: 47969 Average: 4.8565 StdDev: 90.57 Min: 1 Median: 1.5640 Max: 9034 Percentiles: P50: 1.56 P75: 1.95 P99: 7.15 P99.9: 581.00 P99.99: 4175.39 ------------------------------------------------------ [ 0, 1 ] 6273 13.077% 13.077% ### ( 1, 2 ] 31402 65.463% 78.540% ############# ( 2, 3 ] 5627 11.730% 90.271% ## ( 3, 4 ] 2491 5.193% 95.464% # ( 4, 6 ] 1570 3.273% 98.737% # ( 6, 10 ] 439 0.915% 99.652% ( 10, 15 ] 70 0.146% 99.798% ( 15, 22 ] 4 0.008% 99.806% ( 34, 51 ] 3 0.006% 99.812% ( 110, 170 ] 1 0.002% 99.814% ( 170, 250 ] 10 0.021% 99.835% ( 250, 380 ] 15 0.031% 99.867% ( 380, 580 ] 16 0.033% 99.900% ( 580, 870 ] 9 0.019% 99.919% ( 870, 1300 ] 10 0.021% 99.940% ( 1300, 1900 ] 5 0.010% 99.950% ( 1900, 2900 ] 9 0.019% 99.969% ( 2900, 4400 ] 12 0.025% 99.994% ( 4400, 6600 ] 1 0.002% 99.996% ( 6600, 9900 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 340848 Average: 8.5072 StdDev: 102.99 Min: 0 Median: 1.7780 Max: 8538 Percentiles: P50: 1.78 P75: 2.68 P99: 10.95 P99.9: 893.86 P99.99: 1756.41 ------------------------------------------------------ [ 0, 1 ] 17460 5.123% 5.123% # ( 1, 2 ] 196623 57.686% 62.809% ############ ( 2, 3 ] 61051 17.912% 80.720% #### ( 3, 4 ] 32069 9.409% 90.129% ## ( 4, 6 ] 22832 6.699% 96.828% # ( 6, 10 ] 7213 2.116% 98.944% ( 10, 15 ] 1004 0.295% 99.238% ( 15, 22 ] 97 0.028% 99.267% ( 22, 34 ] 33 0.010% 99.277% ( 34, 51 ] 13 0.004% 99.280% ( 51, 76 ] 39 0.011% 99.292% ( 76, 110 ] 47 0.014% 99.306% ( 110, 170 ] 137 0.040% 99.346% ( 170, 250 ] 298 0.087% 99.433% ( 250, 380 ] 525 0.154% 99.587% ( 380, 580 ] 628 0.184% 99.771% ( 580, 870 ] 425 0.125% 99.896% ( 870, 1300 ] 237 0.070% 99.966% ( 1300, 1900 ] 109 0.032% 99.998% ( 1900, 2900 ] 98 0.029% 100.026% ( 2900, 4400 ] 88 0.026% 100.052% ( 4400, 6600 ] 23 0.007% 100.059% ( 6600, 9900 ] 6 0.002% 100.061% ** Level 4 read latency histogram (micros): Count: 18132 Average: 8.0911 StdDev: 92.00 Min: 1 Median: 1.9403 Max: 3701 Percentiles: P50: 1.94 P75: 2.94 P99: 9.96 P99.9: 1551.49 P99.99: 3701.00 ------------------------------------------------------ [ 0, 1 ] 314 1.732% 1.732% ( 1, 2 ] 9308 51.335% 53.066% ########## ( 2, 3 ] 4231 23.334% 76.401% ##### ( 3, 4 ] 2138 11.791% 88.192% ## ( 4, 6 ] 1722 9.497% 97.689% ## ( 6, 10 ] 240 1.324% 99.013% ( 10, 15 ] 62 0.342% 99.355% ( 15, 22 ] 1 0.006% 99.360% ( 22, 34 ] 2 0.011% 99.371% ( 34, 51 ] 1 0.006% 99.377% ( 110, 170 ] 14 0.077% 99.454% ( 170, 250 ] 19 0.105% 99.559% ( 250, 380 ] 7 0.039% 99.597% ( 380, 580 ] 19 0.105% 99.702% ( 580, 870 ] 14 0.077% 99.779% ( 870, 1300 ] 16 0.088% 99.868% ( 1300, 1900 ] 14 0.077% 99.945% ( 1900, 2900 ] 4 0.022% 99.967% ( 2900, 4400 ] 6 0.033% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 625.4125 StdDev: 542.37 Min: 56 Median: 417.5000 Max: 2375 Percentiles: P50: 417.50 P75: 931.43 P99: 2375.00 P99.9: 2375.00 P99.99: 2375.00 ------------------------------------------------------ ( 51, 76 ] 5 6.250% 6.250% # ( 76, 110 ] 3 3.750% 10.000% # ( 110, 170 ] 4 5.000% 15.000% # ( 170, 250 ] 10 12.500% 27.500% ### ( 250, 380 ] 15 18.750% 46.250% #### ( 380, 580 ] 16 20.000% 66.250% #### ( 580, 870 ] 6 7.500% 73.750% ## ( 870, 1300 ] 7 8.750% 82.500% ## ( 1300, 1900 ] 12 15.000% 97.500% ### ( 1900, 2900 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 31.1 total, 4.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 253.45 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.393 H:M:S, 30.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 218.71 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.766 H:M:S, 39.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/12-22:30:32 ... thread 0: (1000000,9000000) ops and (107023.4,223755.5) ops/second in (9.343752,40.222479) 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/13 3.01 GB 25.2 8.5 0.0 8.5 17.0 8.5 0.0 2.0 147.0 294.9 59.11 52.86 153 0.386 8825K 18K 0.0 0.0 L1 13/13 1.34 GB 0.0 7.0 5.3 1.7 7.0 5.3 0.2 1.3 235.7 233.5 30.48 29.06 5 6.095 7293K 64K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.2 0.1 0.1 0.2 0.1 4.1 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 22/2 1.08 GB 1.0 4.5 2.4 2.1 4.4 2.3 1.9 1.9 191.3 190.3 23.93 19.27 14 1.709 4619K 23K 0.0 0.0 L4 159/0 9.44 GB 1.0 3.8 2.1 1.7 3.8 2.1 1.5 1.8 159.7 158.8 24.36 16.74 24 1.015 3208K 11K 0.0 0.0 L5 1105/0 89.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1314/29 104.56 GB 0.0 24.0 9.9 14.0 32.4 18.4 11.4 3.8 177.0 239.3 138.59 118.63 197 0.704 24M 118K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.0 9.9 14.0 32.4 18.4 11.4 3.8 177.0 239.3 138.59 118.63 197 0.704 24M 118K 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 9.9 14.0 23.8 9.8 0.0 0.0 218.1 216.9 112.49 97.01 70 1.607 24M 118K 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 335.5 26.10 21.62 127 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): 40.4 total, 40.2 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.38 GB write, 820.61 MB/s write, 23.96 GB read, 607.12 MB/s read, 138.6 seconds Interval compaction: 32.38 GB write, 824.36 MB/s write, 23.96 GB read, 609.89 MB/s read, 138.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 27, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 27, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 35, total-stops: 37, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3833279 Average: 2.6219 StdDev: 21.47 Min: 0 Median: 1.5305 Max: 10291 Percentiles: P50: 1.53 P75: 1.92 P99: 6.81 P99.9: 51.12 P99.99: 290.95 ------------------------------------------------------ [ 0, 1 ] 610326 15.922% 15.922% ### ( 1, 2 ] 2462360 64.236% 80.158% ############# ( 2, 3 ] 421412 10.994% 91.152% ## ( 3, 4 ] 177239 4.624% 95.775% # ( 4, 6 ] 116325 3.035% 98.810% # ( 6, 10 ] 35821 0.934% 99.744% ( 10, 15 ] 5132 0.134% 99.878% ( 15, 22 ] 704 0.018% 99.897% ( 22, 34 ] 89 0.002% 99.899% ( 34, 51 ] 35 0.001% 99.900% ( 51, 76 ] 803 0.021% 99.921% ( 76, 110 ] 452 0.012% 99.933% ( 110, 170 ] 986 0.026% 99.958% ( 170, 250 ] 1018 0.027% 99.985% ( 250, 380 ] 618 0.016% 100.001% ( 380, 580 ] 541 0.014% 100.015% ( 580, 870 ] 293 0.008% 100.023% ( 870, 1300 ] 135 0.004% 100.026% ( 1300, 1900 ] 45 0.001% 100.028% ( 1900, 2900 ] 46 0.001% 100.029% ( 2900, 4400 ] 37 0.001% 100.030% ( 4400, 6600 ] 5 0.000% 100.030% ( 6600, 9900 ] 2 0.000% 100.030% ( 9900, 14000 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 1418859 Average: 3.7821 StdDev: 53.83 Min: 0 Median: 1.7113 Max: 9101 Percentiles: P50: 1.71 P75: 2.50 P99: 8.53 P99.9: 16.49 P99.99: 179.72 ------------------------------------------------------ [ 0, 1 ] 112359 7.919% 7.919% ## ( 1, 2 ] 839363 59.158% 67.077% ############ ( 2, 3 ] 226955 15.996% 83.072% ### ( 3, 4 ] 115063 8.110% 91.182% ## ( 4, 6 ] 94382 6.652% 97.834% # ( 6, 10 ] 26157 1.844% 99.677% ( 10, 15 ] 3083 0.217% 99.894% ( 15, 22 ] 367 0.026% 99.920% ( 22, 34 ] 44 0.003% 99.923% ( 34, 51 ] 18 0.001% 99.925% ( 51, 76 ] 364 0.026% 99.950% ( 76, 110 ] 153 0.011% 99.961% ( 110, 170 ] 356 0.025% 99.986% ( 170, 250 ] 437 0.031% 100.017% ( 250, 380 ] 490 0.035% 100.052% ( 380, 580 ] 432 0.030% 100.082% ( 580, 870 ] 250 0.018% 100.100% ( 870, 1300 ] 82 0.006% 100.105% ( 1300, 1900 ] 58 0.004% 100.110% ( 1900, 2900 ] 63 0.004% 100.114% ( 2900, 4400 ] 102 0.007% 100.121% ( 4400, 6600 ] 30 0.002% 100.123% ( 6600, 9900 ] 18 0.001% 100.125% ** Level 2 read latency histogram (micros): Count: 47969 Average: 4.8565 StdDev: 90.57 Min: 1 Median: 1.5640 Max: 9034 Percentiles: P50: 1.56 P75: 1.95 P99: 7.15 P99.9: 581.00 P99.99: 4175.39 ------------------------------------------------------ [ 0, 1 ] 6273 13.077% 13.077% ### ( 1, 2 ] 31402 65.463% 78.540% ############# ( 2, 3 ] 5627 11.730% 90.271% ## ( 3, 4 ] 2491 5.193% 95.464% # ( 4, 6 ] 1570 3.273% 98.737% # ( 6, 10 ] 439 0.915% 99.652% ( 10, 15 ] 70 0.146% 99.798% ( 15, 22 ] 4 0.008% 99.806% ( 34, 51 ] 3 0.006% 99.812% ( 110, 170 ] 1 0.002% 99.814% ( 170, 250 ] 10 0.021% 99.835% ( 250, 380 ] 15 0.031% 99.867% ( 380, 580 ] 16 0.033% 99.900% ( 580, 870 ] 9 0.019% 99.919% ( 870, 1300 ] 10 0.021% 99.940% ( 1300, 1900 ] 5 0.010% 99.950% ( 1900, 2900 ] 9 0.019% 99.969% ( 2900, 4400 ] 12 0.025% 99.994% ( 4400, 6600 ] 1 0.002% 99.996% ( 6600, 9900 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 767977 Average: 6.7560 StdDev: 93.68 Min: 0 Median: 1.8640 Max: 15043 Percentiles: P50: 1.86 P75: 2.88 P99: 9.14 P99.9: 497.31 P99.99: 723.06 ------------------------------------------------------ [ 0, 1 ] 27406 3.569% 3.569% # ( 1, 2 ] 412724 53.742% 57.310% ########### ( 2, 3 ] 153992 20.052% 77.362% #### ( 3, 4 ] 85864 11.181% 88.542% ## ( 4, 6 ] 69881 9.099% 97.642% ## ( 6, 10 ] 13293 1.731% 99.373% ( 10, 15 ] 1825 0.238% 99.610% ( 15, 22 ] 176 0.023% 99.633% ( 22, 34 ] 46 0.006% 99.639% ( 34, 51 ] 20 0.003% 99.642% ( 51, 76 ] 57 0.007% 99.649% ( 76, 110 ] 58 0.008% 99.657% ( 110, 170 ] 196 0.026% 99.682% ( 170, 250 ] 401 0.052% 99.735% ( 250, 380 ] 738 0.096% 99.831% ( 380, 580 ] 907 0.118% 99.949% ( 580, 870 ] 641 0.083% 100.032% ( 870, 1300 ] 349 0.045% 100.078% ( 1300, 1900 ] 145 0.019% 100.097% ( 1900, 2900 ] 130 0.017% 100.114% ( 2900, 4400 ] 153 0.020% 100.133% ( 4400, 6600 ] 34 0.004% 100.138% ( 6600, 9900 ] 12 0.002% 100.139% ( 9900, 14000 ] 4 0.001% 100.140% ( 14000, 22000 ] 2 0.000% 100.140% ** Level 4 read latency histogram (micros): Count: 25884 Average: 16.2594 StdDev: 220.57 Min: 1 Median: 1.9754 Max: 16455 Percentiles: P50: 1.98 P75: 3.09 P99: 329.09 P99.9: 2601.23 P99.99: 11587.56 ------------------------------------------------------ [ 0, 1 ] 463 1.789% 1.789% ( 1, 2 ] 12794 49.428% 51.217% ########## ( 2, 3 ] 5882 22.724% 73.941% ##### ( 3, 4 ] 3140 12.131% 86.072% ## ( 4, 6 ] 2688 10.385% 96.457% ## ( 6, 10 ] 441 1.704% 98.161% ( 10, 15 ] 93 0.359% 98.520% ( 15, 22 ] 5 0.019% 98.540% ( 22, 34 ] 5 0.019% 98.559% ( 34, 51 ] 2 0.008% 98.567% ( 51, 76 ] 2 0.008% 98.574% ( 76, 110 ] 9 0.035% 98.609% ( 110, 170 ] 28 0.108% 98.717% ( 170, 250 ] 47 0.182% 98.899% ( 250, 380 ] 43 0.166% 99.065% ( 380, 580 ] 78 0.301% 99.366% ( 580, 870 ] 61 0.236% 99.602% ( 870, 1300 ] 50 0.193% 99.795% ( 1300, 1900 ] 18 0.070% 99.865% ( 1900, 2900 ] 13 0.050% 99.915% ( 2900, 4400 ] 13 0.050% 99.965% ( 4400, 6600 ] 2 0.008% 99.973% ( 6600, 9900 ] 4 0.015% 99.988% ( 9900, 14000 ] 1 0.004% 99.992% ( 14000, 22000 ] 2 0.008% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 683.1812 StdDev: 691.23 Min: 45 Median: 450.9677 Max: 5119 Percentiles: P50: 450.97 P75: 1031.25 P99: 3500.00 P99.9: 5119.00 P99.99: 5119.00 ------------------------------------------------------ ( 34, 51 ] 4 2.500% 2.500% # ( 51, 76 ] 8 5.000% 7.500% # ( 76, 110 ] 7 4.375% 11.875% # ( 110, 170 ] 10 6.250% 18.125% # ( 170, 250 ] 14 8.750% 26.875% ## ( 250, 380 ] 26 16.250% 43.125% ### ( 380, 580 ] 31 19.375% 62.500% #### ( 580, 870 ] 14 8.750% 71.250% ## ( 870, 1300 ] 16 10.000% 81.250% ## ( 1300, 1900 ] 23 14.375% 95.625% ### ( 1900, 2900 ] 5 3.125% 98.750% # ( 2900, 4400 ] 1 0.625% 99.375% ( 4400, 6600 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 40.4 total, 9.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 219.20 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.644 H:M:S, 38.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 105.33 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.251 H:M:S, 66.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/12-22:30:35 ... thread 0: (1000000,10000000) ops and (304321.1,229840.2) ops/second in (3.286003,43.508482) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 20/13 3.99 GB 132.2 9.3 0.0 9.3 18.9 9.5 0.0 2.0 146.8 296.2 65.23 58.56 171 0.381 9720K 19K 0.0 0.0 L1 13/13 1.34 GB 0.0 7.0 5.3 1.7 7.0 5.3 0.2 1.3 235.7 233.5 30.48 29.06 5 6.095 7293K 64K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 4.1 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 20/0 952.64 MB 1.0 4.5 2.4 2.1 4.4 2.3 1.9 1.9 191.3 190.3 23.93 19.27 14 1.709 4619K 23K 0.0 0.0 L4 161/0 9.71 GB 1.0 4.2 2.4 1.8 4.1 2.3 1.5 1.8 162.6 161.8 26.24 18.32 27 0.972 3590K 13K 0.0 0.0 L5 1105/0 89.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.8 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1319/26 105.54 GB 0.0 25.2 10.2 15.0 34.6 19.6 11.4 3.6 175.9 241.7 146.58 125.90 218 0.672 25M 121K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.2 10.2 15.0 34.6 19.6 11.4 3.6 175.9 241.7 146.58 125.90 218 0.672 25M 121K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.2 10.2 15.0 25.1 10.1 0.0 0.0 219.1 218.0 117.69 101.83 76 1.548 25M 121K 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.9 28.90 24.07 142 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 43.7 total, 43.5 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.59 GB write, 810.68 MB/s write, 25.19 GB read, 590.24 MB/s read, 146.6 seconds Interval compaction: 34.59 GB write, 814.10 MB/s write, 25.19 GB read, 592.74 MB/s read, 146.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 30, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 30, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 39, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 38, total-stops: 39, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4298590 Average: 2.5971 StdDev: 20.43 Min: 0 Median: 1.5381 Max: 10291 Percentiles: P50: 1.54 P75: 1.93 P99: 6.82 P99.9: 17.34 P99.99: 245.62 ------------------------------------------------------ [ 0, 1 ] 660406 15.363% 15.363% ### ( 1, 2 ] 2766709 64.363% 79.726% ############# ( 2, 3 ] 486998 11.329% 91.056% ## ( 3, 4 ] 201049 4.677% 95.733% # ( 4, 6 ] 132102 3.073% 98.806% # ( 6, 10 ] 40860 0.951% 99.757% ( 10, 15 ] 5925 0.138% 99.894% ( 15, 22 ] 743 0.017% 99.912% ( 22, 34 ] 97 0.002% 99.914% ( 34, 51 ] 38 0.001% 99.915% ( 51, 76 ] 811 0.019% 99.934% ( 76, 110 ] 454 0.011% 99.944% ( 110, 170 ] 992 0.023% 99.967% ( 170, 250 ] 1039 0.024% 99.991% ( 250, 380 ] 631 0.015% 100.006% ( 380, 580 ] 551 0.013% 100.019% ( 580, 870 ] 296 0.007% 100.026% ( 870, 1300 ] 141 0.003% 100.029% ( 1300, 1900 ] 49 0.001% 100.030% ( 1900, 2900 ] 47 0.001% 100.031% ( 2900, 4400 ] 37 0.001% 100.032% ( 4400, 6600 ] 5 0.000% 100.032% ( 6600, 9900 ] 2 0.000% 100.032% ( 9900, 14000 ] 1 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 1451561 Average: 3.7686 StdDev: 53.29 Min: 0 Median: 1.7117 Max: 9101 Percentiles: P50: 1.71 P75: 2.49 P99: 8.54 P99.9: 17.17 P99.99: 186.75 ------------------------------------------------------ [ 0, 1 ] 113797 7.840% 7.840% ## ( 1, 2 ] 859942 59.243% 67.082% ############ ( 2, 3 ] 232725 16.033% 83.115% ### ( 3, 4 ] 117452 8.091% 91.206% ## ( 4, 6 ] 96047 6.617% 97.823% # ( 6, 10 ] 26882 1.852% 99.675% ( 10, 15 ] 3150 0.217% 99.892% ( 15, 22 ] 369 0.025% 99.918% ( 22, 34 ] 44 0.003% 99.921% ( 34, 51 ] 19 0.001% 99.922% ( 51, 76 ] 377 0.026% 99.948% ( 76, 110 ] 154 0.011% 99.958% ( 110, 170 ] 363 0.025% 99.983% ( 170, 250 ] 453 0.031% 100.015% ( 250, 380 ] 507 0.035% 100.050% ( 380, 580 ] 440 0.030% 100.080% ( 580, 870 ] 251 0.017% 100.097% ( 870, 1300 ] 83 0.006% 100.103% ( 1300, 1900 ] 60 0.004% 100.107% ( 1900, 2900 ] 63 0.004% 100.111% ( 2900, 4400 ] 102 0.007% 100.118% ( 4400, 6600 ] 30 0.002% 100.120% ( 6600, 9900 ] 18 0.001% 100.122% ** Level 2 read latency histogram (micros): Count: 47969 Average: 4.8565 StdDev: 90.57 Min: 1 Median: 1.5640 Max: 9034 Percentiles: P50: 1.56 P75: 1.95 P99: 7.15 P99.9: 581.00 P99.99: 4175.39 ------------------------------------------------------ [ 0, 1 ] 6273 13.077% 13.077% ### ( 1, 2 ] 31402 65.463% 78.540% ############# ( 2, 3 ] 5627 11.730% 90.271% ## ( 3, 4 ] 2491 5.193% 95.464% # ( 4, 6 ] 1570 3.273% 98.737% # ( 6, 10 ] 439 0.915% 99.652% ( 10, 15 ] 70 0.146% 99.798% ( 15, 22 ] 4 0.008% 99.806% ( 34, 51 ] 3 0.006% 99.812% ( 110, 170 ] 1 0.002% 99.814% ( 170, 250 ] 10 0.021% 99.835% ( 250, 380 ] 15 0.031% 99.867% ( 380, 580 ] 16 0.033% 99.900% ( 580, 870 ] 9 0.019% 99.919% ( 870, 1300 ] 10 0.021% 99.940% ( 1300, 1900 ] 5 0.010% 99.950% ( 1900, 2900 ] 9 0.019% 99.969% ( 2900, 4400 ] 12 0.025% 99.994% ( 4400, 6600 ] 1 0.002% 99.996% ( 6600, 9900 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 823656 Average: 6.6580 StdDev: 91.05 Min: 0 Median: 1.8607 Max: 15043 Percentiles: P50: 1.86 P75: 2.87 P99: 9.19 P99.9: 495.17 P99.99: 720.49 ------------------------------------------------------ [ 0, 1 ] 28942 3.514% 3.514% # ( 1, 2 ] 444843 54.008% 57.522% ########### ( 2, 3 ] 165388 20.080% 77.602% #### ( 3, 4 ] 91045 11.054% 88.656% ## ( 4, 6 ] 73851 8.966% 97.622% ## ( 6, 10 ] 14217 1.726% 99.348% ( 10, 15 ] 1994 0.242% 99.590% ( 15, 22 ] 183 0.022% 99.612% ( 22, 34 ] 46 0.006% 99.618% ( 34, 51 ] 21 0.003% 99.620% ( 51, 76 ] 84 0.010% 99.631% ( 76, 110 ] 76 0.009% 99.640% ( 110, 170 ] 238 0.029% 99.669% ( 170, 250 ] 476 0.058% 99.727% ( 250, 380 ] 860 0.104% 99.831% ( 380, 580 ] 987 0.120% 99.951% ( 580, 870 ] 666 0.081% 100.032% ( 870, 1300 ] 357 0.043% 100.075% ( 1300, 1900 ] 151 0.018% 100.093% ( 1900, 2900 ] 134 0.016% 100.110% ( 2900, 4400 ] 153 0.019% 100.128% ( 4400, 6600 ] 34 0.004% 100.132% ( 6600, 9900 ] 12 0.001% 100.134% ( 9900, 14000 ] 4 0.000% 100.134% ( 14000, 22000 ] 2 0.000% 100.135% ** Level 4 read latency histogram (micros): Count: 32959 Average: 14.5881 StdDev: 196.74 Min: 0 Median: 1.9506 Max: 16455 Percentiles: P50: 1.95 P75: 3.01 P99: 275.68 P99.9: 2057.00 P99.99: 9655.88 ------------------------------------------------------ [ 0, 1 ] 648 1.966% 1.966% ( 1, 2 ] 16655 50.532% 52.499% ########## ( 2, 3 ] 7381 22.394% 74.893% #### ( 3, 4 ] 3781 11.472% 86.365% ## ( 4, 6 ] 3246 9.849% 96.213% ## ( 6, 10 ] 603 1.830% 98.043% ( 10, 15 ] 117 0.355% 98.398% ( 15, 22 ] 6 0.018% 98.416% ( 22, 34 ] 7 0.021% 98.437% ( 34, 51 ] 2 0.006% 98.444% ( 51, 76 ] 9 0.027% 98.471% ( 76, 110 ] 14 0.042% 98.513% ( 110, 170 ] 53 0.161% 98.674% ( 170, 250 ] 92 0.279% 98.953% ( 250, 380 ] 78 0.237% 99.190% ( 380, 580 ] 90 0.273% 99.463% ( 580, 870 ] 73 0.221% 99.684% ( 870, 1300 ] 50 0.152% 99.836% ( 1300, 1900 ] 19 0.058% 99.894% ( 1900, 2900 ] 13 0.039% 99.933% ( 2900, 4400 ] 13 0.039% 99.973% ( 4400, 6600 ] 2 0.006% 99.979% ( 6600, 9900 ] 4 0.012% 99.991% ( 9900, 14000 ] 1 0.003% 99.994% ( 14000, 22000 ] 2 0.006% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 683.1812 StdDev: 691.23 Min: 45 Median: 450.9677 Max: 5119 Percentiles: P50: 450.97 P75: 1031.25 P99: 3500.00 P99.9: 5119.00 P99.99: 5119.00 ------------------------------------------------------ ( 34, 51 ] 4 2.500% 2.500% # ( 51, 76 ] 8 5.000% 7.500% # ( 76, 110 ] 7 4.375% 11.875% # ( 110, 170 ] 10 6.250% 18.125% # ( 170, 250 ] 14 8.750% 26.875% ## ( 250, 380 ] 26 16.250% 43.125% ### ( 380, 580 ] 31 19.375% 62.500% #### ( 580, 870 ] 14 8.750% 71.250% ## ( 870, 1300 ] 16 10.000% 81.250% ## ( 1300, 1900 ] 23 14.375% 95.625% ### ( 1900, 2900 ] 5 3.125% 98.750% # ( 2900, 4400 ] 1 0.625% 99.375% ( 4400, 6600 ] 1 0.625% 100.000% ** DB Stats ** Uptime(secs): 43.7 total, 3.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 225.24 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:16.223 H:M:S, 37.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 299.41 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.579 H:M:S, 17.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-22:30:50 ... thread 0: (1000000,11000000) ops and (64479.9,186386.4) ops/second in (15.508709,59.017191) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/14 2.46 GB 18.9 10.1 0.0 10.1 20.5 10.4 0.0 2.0 146.2 297.5 70.66 63.59 188 0.376 10M 19K 0.0 0.0 L1 14/14 1.72 GB 0.0 10.8 7.8 3.0 10.7 7.7 0.2 1.4 232.4 229.8 47.61 44.99 6 7.934 10M 64K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 6.1 1.5 264.6 264.5 0.71 0.69 1 0.714 191K 65 0.0 0.0 L3 19/0 993.11 MB 1.0 7.1 3.9 3.2 7.1 3.8 2.4 1.8 177.5 176.3 40.95 31.10 26 1.575 7351K 46K 0.0 0.0 L4 162/0 9.64 GB 1.0 7.4 4.3 3.1 7.3 4.2 1.5 1.7 164.2 162.4 46.17 32.68 51 0.905 6955K 71K 0.0 0.0 L5 1129/0 91.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1340/28 106.33 GB 0.0 35.6 16.1 19.5 45.8 26.3 15.9 4.4 176.8 227.4 206.10 173.05 272 0.758 35M 202K 0.0 0.0 Int 0/0 0.00 KB 0.0 35.6 16.1 19.5 45.8 26.3 15.9 4.4 176.8 227.4 206.10 173.05 272 0.758 35M 202K 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 35.6 16.1 19.5 35.3 15.8 0.0 0.0 208.8 207.2 174.50 146.62 116 1.504 35M 202K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 10.5 10.5 0.0 0.0 0.0 339.0 31.59 26.42 156 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 59.2 total, 59.0 interval Flush(GB): cumulative 10.459, interval 10.459 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: 45.77 GB write, 791.64 MB/s write, 35.58 GB read, 615.35 MB/s read, 206.1 seconds Interval compaction: 45.77 GB write, 794.11 MB/s write, 35.58 GB read, 617.27 MB/s read, 206.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 35, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 35, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 40, pending-compaction-bytes-delays: 42, pending-compaction-bytes-stops: 0, total-delays: 77, total-stops: 40, interval: 117 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4995443 Average: 2.7052 StdDev: 23.86 Min: 0 Median: 1.5409 Max: 10291 Percentiles: P50: 1.54 P75: 1.93 P99: 7.04 P99.9: 53.98 P99.99: 353.22 ------------------------------------------------------ [ 0, 1 ] 771846 15.451% 15.451% ### ( 1, 2 ] 3190578 63.870% 79.321% ############# ( 2, 3 ] 567382 11.358% 90.679% ## ( 3, 4 ] 238220 4.769% 95.448% # ( 4, 6 ] 164577 3.295% 98.742% # ( 6, 10 ] 49505 0.991% 99.733% ( 10, 15 ] 7209 0.144% 99.877% ( 15, 22 ] 873 0.017% 99.895% ( 22, 34 ] 101 0.002% 99.897% ( 34, 51 ] 44 0.001% 99.898% ( 51, 76 ] 952 0.019% 99.917% ( 76, 110 ] 528 0.011% 99.927% ( 110, 170 ] 1162 0.023% 99.951% ( 170, 250 ] 1256 0.025% 99.976% ( 250, 380 ] 896 0.018% 99.994% ( 380, 580 ] 837 0.017% 100.010% ( 580, 870 ] 484 0.010% 100.020% ( 870, 1300 ] 243 0.005% 100.025% ( 1300, 1900 ] 76 0.002% 100.027% ( 1900, 2900 ] 61 0.001% 100.028% ( 2900, 4400 ] 55 0.001% 100.029% ( 4400, 6600 ] 14 0.000% 100.029% ( 6600, 9900 ] 4 0.000% 100.029% ( 9900, 14000 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 2287803 Average: 3.7890 StdDev: 51.97 Min: 0 Median: 1.6876 Max: 9101 Percentiles: P50: 1.69 P75: 2.49 P99: 8.61 P99.9: 45.15 P99.99: 221.14 ------------------------------------------------------ [ 0, 1 ] 255215 11.155% 11.155% ## ( 1, 2 ] 1292472 56.494% 67.649% ########### ( 2, 3 ] 345464 15.100% 82.750% ### ( 3, 4 ] 183289 8.012% 90.761% ## ( 4, 6 ] 160751 7.026% 97.788% # ( 6, 10 ] 42453 1.856% 99.643% ( 10, 15 ] 5193 0.227% 99.870% ( 15, 22 ] 594 0.026% 99.896% ( 22, 34 ] 56 0.002% 99.899% ( 34, 51 ] 43 0.002% 99.901% ( 51, 76 ] 756 0.033% 99.934% ( 76, 110 ] 283 0.012% 99.946% ( 110, 170 ] 582 0.025% 99.972% ( 170, 250 ] 662 0.029% 100.000% ( 250, 380 ] 749 0.033% 100.033% ( 380, 580 ] 728 0.032% 100.065% ( 580, 870 ] 491 0.021% 100.086% ( 870, 1300 ] 227 0.010% 100.096% ( 1300, 1900 ] 100 0.004% 100.101% ( 1900, 2900 ] 98 0.004% 100.105% ( 2900, 4400 ] 169 0.007% 100.112% ( 4400, 6600 ] 41 0.002% 100.114% ( 6600, 9900 ] 21 0.001% 100.115% ** Level 2 read latency histogram (micros): Count: 47969 Average: 4.8565 StdDev: 90.57 Min: 1 Median: 1.5640 Max: 9034 Percentiles: P50: 1.56 P75: 1.95 P99: 7.15 P99.9: 581.00 P99.99: 4175.39 ------------------------------------------------------ [ 0, 1 ] 6273 13.077% 13.077% ### ( 1, 2 ] 31402 65.463% 78.540% ############# ( 2, 3 ] 5627 11.730% 90.271% ## ( 3, 4 ] 2491 5.193% 95.464% # ( 4, 6 ] 1570 3.273% 98.737% # ( 6, 10 ] 439 0.915% 99.652% ( 10, 15 ] 70 0.146% 99.798% ( 15, 22 ] 4 0.008% 99.806% ( 34, 51 ] 3 0.006% 99.812% ( 110, 170 ] 1 0.002% 99.814% ( 170, 250 ] 10 0.021% 99.835% ( 250, 380 ] 15 0.031% 99.867% ( 380, 580 ] 16 0.033% 99.900% ( 580, 870 ] 9 0.019% 99.919% ( 870, 1300 ] 10 0.021% 99.940% ( 1300, 1900 ] 5 0.010% 99.950% ( 1900, 2900 ] 9 0.019% 99.969% ( 2900, 4400 ] 12 0.025% 99.994% ( 4400, 6600 ] 1 0.002% 99.996% ( 6600, 9900 ] 2 0.004% 100.000% ** Level 3 read latency histogram (micros): Count: 1520576 Average: 5.5240 StdDev: 72.97 Min: 0 Median: 1.9130 Max: 15043 Percentiles: P50: 1.91 P75: 2.99 P99: 8.93 P99.9: 288.08 P99.99: 470.87 ------------------------------------------------------ [ 0, 1 ] 42326 2.784% 2.784% # ( 1, 2 ] 786399 51.717% 54.501% ########## ( 2, 3 ] 314187 20.662% 75.163% #### ( 3, 4 ] 180464 11.868% 87.031% ## ( 4, 6 ] 160895 10.581% 97.612% ## ( 6, 10 ] 28839 1.897% 99.509% ( 10, 15 ] 3949 0.260% 99.769% ( 15, 22 ] 320 0.021% 99.790% ( 22, 34 ] 85 0.006% 99.795% ( 34, 51 ] 41 0.003% 99.798% ( 51, 76 ] 156 0.010% 99.808% ( 76, 110 ] 122 0.008% 99.816% ( 110, 170 ] 331 0.022% 99.838% ( 170, 250 ] 618 0.041% 99.879% ( 250, 380 ] 1104 0.073% 99.951% ( 380, 580 ] 1294 0.085% 100.036% ( 580, 870 ] 898 0.059% 100.095% ( 870, 1300 ] 469 0.031% 100.126% ( 1300, 1900 ] 185 0.012% 100.139% ( 1900, 2900 ] 150 0.010% 100.148% ( 2900, 4400 ] 192 0.013% 100.161% ( 4400, 6600 ] 39 0.003% 100.164% ( 6600, 9900 ] 14 0.001% 100.164% ( 9900, 14000 ] 4 0.000% 100.165% ( 14000, 22000 ] 2 0.000% 100.165% ** Level 4 read latency histogram (micros): Count: 366488 Average: 8.6419 StdDev: 111.47 Min: 0 Median: 1.9370 Max: 16455 Percentiles: P50: 1.94 P75: 3.11 P99: 10.24 P99.9: 807.75 P99.99: 1157.60 ------------------------------------------------------ [ 0, 1 ] 8990 2.453% 2.453% ( 1, 2 ] 185976 50.745% 53.198% ########## ( 2, 3 ] 75081 20.487% 73.685% #### ( 3, 4 ] 42675 11.644% 85.329% ## ( 4, 6 ] 40425 11.030% 96.360% ## ( 6, 10 ] 9617 2.624% 98.984% # ( 10, 15 ] 1241 0.339% 99.322% ( 15, 22 ] 102 0.028% 99.350% ( 22, 34 ] 17 0.005% 99.355% ( 34, 51 ] 7 0.002% 99.357% ( 51, 76 ] 56 0.015% 99.372% ( 76, 110 ] 63 0.017% 99.389% ( 110, 170 ] 114 0.031% 99.420% ( 170, 250 ] 262 0.071% 99.492% ( 250, 380 ] 447 0.122% 99.614% ( 380, 580 ] 615 0.168% 99.782% ( 580, 870 ] 552 0.151% 99.932% ( 870, 1300 ] 316 0.086% 100.019% ( 1300, 1900 ] 96 0.026% 100.045% ( 1900, 2900 ] 58 0.016% 100.061% ( 2900, 4400 ] 89 0.024% 100.085% ( 4400, 6600 ] 22 0.006% 100.091% ( 6600, 9900 ] 11 0.003% 100.094% ( 9900, 14000 ] 2 0.001% 100.094% ( 14000, 22000 ] 2 0.001% 100.095% ** Level 5 read latency histogram (micros): Count: 280 Average: 798.6250 StdDev: 844.75 Min: 45 Median: 499.1489 Max: 5126 Percentiles: P50: 499.15 P75: 1131.07 P99: 4546.67 P99.9: 5126.00 P99.99: 5126.00 ------------------------------------------------------ ( 34, 51 ] 5 1.786% 1.786% ( 51, 76 ] 14 5.000% 6.786% # ( 76, 110 ] 11 3.929% 10.714% # ( 110, 170 ] 13 4.643% 15.357% # ( 170, 250 ] 20 7.143% 22.500% # ( 250, 380 ] 49 17.500% 40.000% #### ( 380, 580 ] 47 16.786% 56.786% ### ( 580, 870 ] 34 12.143% 68.929% ## ( 870, 1300 ] 28 10.000% 78.929% ## ( 1300, 1900 ] 36 12.857% 91.786% ### ( 1900, 2900 ] 14 5.000% 96.786% # ( 2900, 4400 ] 6 2.143% 98.929% ( 4400, 6600 ] 3 1.071% 100.000% ** DB Stats ** Uptime(secs): 59.2 total, 15.5 interval Cumulative writes: 0 writes, 11M keys, 0 commit groups, 0.0 writes per commit group, ingest: 10.57 GB, 182.86 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:28.466 H:M:S, 48.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 63.47 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:12.243 H:M:S, 78.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.302 micros/op 188622 ops/sec 60.051 seconds 11326999 operations; 182.8 MB/s Microseconds per write: Count: 11326999 Average: 5.3016 StdDev: 349.03 Min: 0 Median: 1.6875 Max: 723569 Percentiles: P50: 1.69 P75: 2.87 P99: 8.98 P99.9: 1091.95 P99.99: 2599.12 ------------------------------------------------------ [ 0, 1 ] 1996900 17.630% 17.630% #### ( 1, 2 ] 5333053 47.083% 64.712% ######### ( 2, 3 ] 1337044 11.804% 76.516% ## ( 3, 4 ] 1613573 14.245% 90.762% ### ( 4, 6 ] 840854 7.423% 98.185% # ( 6, 10 ] 123778 1.093% 99.278% ( 10, 15 ] 35269 0.311% 99.589% ( 15, 22 ] 11544 0.102% 99.691% ( 22, 34 ] 3124 0.028% 99.719% ( 34, 51 ] 408 0.004% 99.722% ( 51, 76 ] 63 0.001% 99.723% ( 76, 110 ] 48 0.000% 99.723% ( 110, 170 ] 10719 0.095% 99.818% ( 170, 250 ] 573 0.005% 99.823% ( 250, 380 ] 179 0.002% 99.825% ( 380, 580 ] 37 0.000% 99.825% ( 580, 870 ] 32 0.000% 99.825% ( 870, 1300 ] 16417 0.145% 99.970% ( 1300, 1900 ] 98 0.001% 99.971% ( 1900, 2900 ] 3080 0.027% 99.998% ( 2900, 4400 ] 146 0.001% 99.999% ( 4400, 6600 ] 29 0.000% 100.000% ( 6600, 9900 ] 10 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 11 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 285504 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 : 11326999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11689462968 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 : 687 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 28650052 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 : 39919424439 rocksdb.compact.write.bytes COUNT : 39617727246 rocksdb.flush.write.bytes COUNT : 11626297563 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 : 82 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 : 357 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 : 11532311552 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4265984 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 : 38705601302 rocksdb.non.last.level.read.count COUNT : 9349384 rocksdb.block.checksum.compute.count COUNT : 9668122 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.307060 P95 : 4.362893 P99 : 7.666388 P100 : 723567.000000 COUNT : 11326999 SUM : 55091433 rocksdb.compaction.times.micros P50 : 996944.444444 P95 : 4410000.000000 P99 : 13643000.000000 P100 : 17127642.000000 COUNT : 117 SUM : 175431011 rocksdb.compaction.times.cpu_micros P50 : 871860.465116 P95 : 4410000.000000 P99 : 13643000.000000 P100 : 15926366.000000 COUNT : 117 SUM : 147529627 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 : 695.691489 P95 : 1585.000000 P99 : 30763.333333 P100 : 66173.000000 COUNT : 161 SUM : 262105 rocksdb.compaction.outfile.sync.micros P50 : 1181.184211 P95 : 104673.913043 P99 : 164375.000000 P100 : 335922.000000 COUNT : 450 SUM : 8403971 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 106.542373 P95 : 1343.636364 P99 : 3470.000000 P100 : 6124.000000 COUNT : 324 SUM : 95821 rocksdb.table.open.io.micros P50 : 1284.763780 P95 : 5663.103448 P99 : 10870.333333 P100 : 13704.000000 COUNT : 687 SUM : 1220365 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.630830 P95 : 7.864745 P99 : 10.640189 P100 : 16457.000000 COUNT : 9666720 SUM : 55149145 rocksdb.read.block.get.micros P50 : 482.127660 P95 : 2226.785714 P99 : 4262.631579 P100 : 11504.000000 COUNT : 1374 SUM : 987021 rocksdb.write.raw.block.micros P50 : 0.513307 P95 : 0.975284 P99 : 3.140495 P100 : 19301.000000 COUNT : 12412482 SUM : 23951477 rocksdb.numfiles.in.singlecompaction P50 : 3.187500 P95 : 5.990000 P99 : 20.110000 P100 : 24.000000 COUNT : 181 SUM : 681 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.559069 P95 : 1139.997534 P99 : 2330.301936 P100 : 723378.000000 COUNT : 187487 SUM : 28665111 rocksdb.sst.read.micros P50 : 1.641396 P95 : 4.897649 P99 : 8.393403 P100 : 16455.000000 COUNT : 9350468 SUM : 34601394 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 : 11326999 SUM : 11689462968 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 : 194000.000000 P95 : 349029.411765 P99 : 683100.000000 P100 : 917203.000000 COUNT : 161 SUM : 32632705 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 : 447 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