[2024-12-13 08:36:08.459312] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-13 08:36:08.459587] [ 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_pid1203421 ] Set seed to 1734075368452505 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-13 08:36:08.558808] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-13 08:36:08.600523] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-13 08:36:08.600567] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1203421' to capture a snapshot of events at runtime. [2024-12-13 08:36:08.600578] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-13 08:36:08.600605] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-13 08:36:08.600613] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1203421 for offline analysis/debug. [2024-12-13 08:36:08.600704] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 13 08:36:12 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/13-08:36:15 ... thread 0: (1000000,1000000) ops and (337417.9,337417.9) ops/second in (2.963684,2.963684) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.98 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 353.7 2.49 2.25 12 0.208 0 0 0.0 0.0 L2 3/2 251.75 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 8/0 678.31 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.72 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 1036/0 85.75 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 1172/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 1.0 1.4 94.6 315.2 4.00 3.71 14 0.285 383K 186 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.4 94.6 315.2 4.00 3.71 14 0.285 383K 186 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 353.7 2.49 2.25 12 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 401.78 MB/s write, 0.37 GB read, 120.54 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 424.85 MB/s write, 0.37 GB read, 127.46 MB/s read, 4.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 111417 Average: 1.8933 StdDev: 15.98 Min: 0 Median: 1.2318 Max: 3352 Percentiles: P50: 1.23 P75: 1.67 P99: 4.00 P99.9: 9.79 P99.99: 333.59 ------------------------------------------------------ [ 0, 1 ] 41030 36.826% 36.826% ####### ( 1, 2 ] 63333 56.843% 93.669% ########### ( 2, 3 ] 4472 4.014% 97.683% # ( 3, 4 ] 1469 1.318% 99.001% ( 4, 6 ] 797 0.715% 99.716% ( 6, 10 ] 219 0.197% 99.913% ( 10, 15 ] 58 0.052% 99.965% ( 15, 22 ] 16 0.014% 99.979% ( 34, 51 ] 1 0.001% 99.980% ( 51, 76 ] 1 0.001% 99.981% ( 110, 170 ] 9 0.008% 99.989% ( 250, 380 ] 6 0.005% 99.995% ( 380, 580 ] 1 0.001% 99.996% ( 870, 1300 ] 4 0.004% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ( 1900, 2900 ] 2 0.002% 100.002% ( 2900, 4400 ] 1 0.001% 100.003% ** Level 1 read latency histogram (micros): Count: 5 Average: 1279.2000 StdDev: 1236.56 Min: 73 Median: 530.0000 Max: 3190 Percentiles: P50: 530.00 P75: 2650.00 P99: 3190.00 P99.9: 3190.00 P99.99: 3190.00 ------------------------------------------------------ ( 51, 76 ] 1 20.000% 20.000% #### ( 380, 580 ] 2 40.000% 60.000% ######## ( 1900, 2900 ] 1 20.000% 80.000% #### ( 2900, 4400 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 62165 Average: 1.8469 StdDev: 5.96 Min: 0 Median: 1.2750 Max: 985 Percentiles: P50: 1.28 P75: 1.70 P99: 4.67 P99.9: 9.50 P99.99: 70.59 ------------------------------------------------------ [ 0, 1 ] 20986 33.759% 33.759% ####### ( 1, 2 ] 36712 59.056% 92.814% ############ ( 2, 3 ] 2578 4.147% 96.961% # ( 3, 4 ] 1076 1.731% 98.692% ( 4, 6 ] 574 0.923% 99.616% ( 6, 10 ] 203 0.327% 99.942% ( 10, 15 ] 26 0.042% 99.984% ( 15, 22 ] 2 0.003% 99.987% ( 22, 34 ] 1 0.002% 99.989% ( 34, 51 ] 1 0.002% 99.990% ( 51, 76 ] 1 0.002% 99.992% ( 250, 380 ] 2 0.003% 99.995% ( 380, 580 ] 2 0.003% 99.998% ( 580, 870 ] 1 0.002% 100.000% ( 870, 1300 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1517.8909 StdDev: 1159.62 Min: 56 Median: 1186.1765 Max: 5085 Percentiles: P50: 1186.18 P75: 2181.25 P99: 5085.00 P99.9: 5085.00 P99.99: 5085.00 ------------------------------------------------------ ( 51, 76 ] 2 3.636% 3.636% # ( 110, 170 ] 3 5.455% 9.091% # ( 170, 250 ] 4 7.273% 16.364% # ( 380, 580 ] 1 1.818% 18.182% ( 580, 870 ] 5 9.091% 27.273% ## ( 870, 1300 ] 17 30.909% 58.182% ###### ( 1300, 1900 ] 7 12.727% 70.909% ### ( 1900, 2900 ] 8 14.545% 85.455% ### ( 2900, 4400 ] 7 12.727% 98.182% ### ( 4400, 6600 ] 1 1.818% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1667.3500 StdDev: 1119.63 Min: 365 Median: 1300.0000 Max: 4152 Percentiles: P50: 1300.00 P75: 1800.00 P99: 4152.00 P99.9: 4152.00 P99.99: 4152.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 1 5.000% 20.000% # ( 870, 1300 ] 6 30.000% 50.000% ###### ( 1300, 1900 ] 6 30.000% 80.000% ###### ( 2900, 4400 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 432.7500 StdDev: 531.40 Min: 77 Median: 140.0000 Max: 2078 Percentiles: P50: 140.00 P75: 725.00 P99: 2078.00 P99.9: 2078.00 P99.99: 2078.00 ------------------------------------------------------ ( 76, 110 ] 8 40.000% 40.000% ######## ( 110, 170 ] 4 20.000% 60.000% #### ( 250, 380 ] 1 5.000% 65.000% # ( 380, 580 ] 1 5.000% 70.000% # ( 580, 870 ] 2 10.000% 80.000% ## ( 870, 1300 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 313.90 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.396 H:M:S, 12.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.83 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.396 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-08:36:18 ... thread 0: (1000000,2000000) ops and (351377.5,344256.2) ops/second in (2.845942,5.809626) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.17 GB 62.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 77.8 328.6 7.28 6.72 28 0.260 575K 592 0.0 0.0 L1 1/0 2.61 MB 0.3 0.4 0.4 0.0 0.4 0.4 0.2 1.0 229.8 229.4 1.64 1.59 1 1.645 383K 590 0.0 0.0 L2 2/0 55.50 MB 0.6 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 45/0 973.06 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 207.1 206.9 3.84 3.40 3 1.280 807K 840 0.0 0.0 L4 140/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1239/8 97.92 GB 0.0 2.1 1.1 1.0 3.9 2.9 2.2 2.2 148.4 276.3 14.27 13.16 34 0.420 2151K 2208 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.1 1.0 3.9 2.9 2.1 2.2 148.4 276.3 14.27 13.16 34 0.420 2151K 2208 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.1 1.1 1.0 2.1 1.1 0.0 0.0 231.4 231.1 9.16 8.57 8 1.144 2151K 2208 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 357.0 5.12 4.59 26 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): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.85 GB write, 659.27 MB/s write, 2.07 GB read, 354.20 MB/s read, 14.3 seconds Interval compaction: 3.85 GB write, 678.58 MB/s write, 2.07 GB read, 364.58 MB/s read, 14.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 394082 Average: 2.1656 StdDev: 11.59 Min: 0 Median: 1.4650 Max: 3352 Percentiles: P50: 1.47 P75: 1.86 P99: 5.63 P99.9: 10.92 P99.99: 19.20 ------------------------------------------------------ [ 0, 1 ] 80478 20.422% 20.422% #### ( 1, 2 ] 250652 63.604% 84.026% ############# ( 2, 3 ] 37749 9.579% 93.605% ## ( 3, 4 ] 13886 3.524% 97.128% # ( 4, 6 ] 9045 2.295% 99.423% ( 6, 10 ] 1805 0.458% 99.881% ( 10, 15 ] 401 0.102% 99.983% ( 15, 22 ] 46 0.012% 99.995% ( 22, 34 ] 5 0.001% 99.996% ( 34, 51 ] 3 0.001% 99.997% ( 51, 76 ] 3 0.001% 99.998% ( 110, 170 ] 15 0.004% 100.002% ( 170, 250 ] 9 0.002% 100.004% ( 250, 380 ] 11 0.003% 100.007% ( 380, 580 ] 3 0.001% 100.007% ( 580, 870 ] 2 0.001% 100.008% ( 870, 1300 ] 6 0.002% 100.009% ( 1300, 1900 ] 6 0.002% 100.011% ( 1900, 2900 ] 2 0.001% 100.011% ( 2900, 4400 ] 2 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 81472 Average: 2.5508 StdDev: 16.04 Min: 1 Median: 1.6597 Max: 3190 Percentiles: P50: 1.66 P75: 2.16 P99: 5.97 P99.9: 11.62 P99.99: 14.70 ------------------------------------------------------ [ 0, 1 ] 5718 7.018% 7.018% # ( 1, 2 ] 53080 65.151% 72.170% ############# ( 2, 3 ] 13983 17.163% 89.333% ### ( 3, 4 ] 4300 5.278% 94.610% # ( 4, 6 ] 3631 4.457% 99.067% # ( 6, 10 ] 640 0.786% 99.853% ( 10, 15 ] 119 0.146% 99.999% ( 15, 22 ] 8 0.010% 100.009% ( 22, 34 ] 2 0.002% 100.011% ( 34, 51 ] 1 0.001% 100.012% ( 51, 76 ] 1 0.001% 100.014% ( 110, 170 ] 1 0.001% 100.015% ( 170, 250 ] 2 0.002% 100.017% ( 250, 380 ] 1 0.001% 100.018% ( 380, 580 ] 3 0.004% 100.022% ( 580, 870 ] 1 0.001% 100.023% ( 870, 1300 ] 1 0.001% 100.025% ( 1300, 1900 ] 1 0.001% 100.026% ( 1900, 2900 ] 1 0.001% 100.027% ( 2900, 4400 ] 1 0.001% 100.028% ** Level 2 read latency histogram (micros): Count: 95470 Average: 1.9954 StdDev: 4.85 Min: 0 Median: 1.3917 Max: 985 Percentiles: P50: 1.39 P75: 1.80 P99: 5.44 P99.9: 9.64 P99.99: 20.72 ------------------------------------------------------ [ 0, 1 ] 24574 25.740% 25.740% ##### ( 1, 2 ] 59129 61.935% 87.675% ############ ( 2, 3 ] 6886 7.213% 94.887% # ( 3, 4 ] 2646 2.772% 97.659% # ( 4, 6 ] 1776 1.860% 99.519% ( 6, 10 ] 400 0.419% 99.938% ( 10, 15 ] 47 0.049% 99.987% ( 15, 22 ] 3 0.003% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 2 0.002% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57385 Average: 3.9781 StdDev: 59.61 Min: 0 Median: 1.6593 Max: 5085 Percentiles: P50: 1.66 P75: 2.18 P99: 6.76 P99.9: 191.53 P99.99: 3170.32 ------------------------------------------------------ [ 0, 1 ] 4314 7.518% 7.518% ## ( 1, 2 ] 36975 64.433% 71.951% ############# ( 2, 3 ] 9990 17.409% 89.360% ### ( 3, 4 ] 2991 5.212% 94.572% # ( 4, 6 ] 2458 4.283% 98.855% # ( 6, 10 ] 437 0.762% 99.617% ( 10, 15 ] 88 0.153% 99.770% ( 15, 22 ] 13 0.023% 99.793% ( 22, 34 ] 35 0.061% 99.854% ( 34, 51 ] 13 0.023% 99.876% ( 51, 76 ] 3 0.005% 99.882% ( 110, 170 ] 9 0.016% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 2 0.003% 99.920% ( 580, 870 ] 6 0.010% 99.930% ( 870, 1300 ] 17 0.030% 99.960% ( 1300, 1900 ] 8 0.014% 99.974% ( 1900, 2900 ] 8 0.014% 99.988% ( 2900, 4400 ] 7 0.012% 100.000% ( 4400, 6600 ] 1 0.002% 100.002% ** Level 4 read latency histogram (micros): Count: 20 Average: 1667.3500 StdDev: 1119.63 Min: 365 Median: 1300.0000 Max: 4152 Percentiles: P50: 1300.00 P75: 1800.00 P99: 4152.00 P99.9: 4152.00 P99.99: 4152.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 1 5.000% 20.000% # ( 870, 1300 ] 6 30.000% 50.000% ###### ( 1300, 1900 ] 6 30.000% 80.000% ###### ( 2900, 4400 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 558.3750 StdDev: 745.13 Min: 77 Median: 152.8571 Max: 3199 Percentiles: P50: 152.86 P75: 870.00 P99: 3199.00 P99.9: 3199.00 P99.99: 3199.00 ------------------------------------------------------ ( 76, 110 ] 15 37.500% 37.500% ######## ( 110, 170 ] 7 17.500% 55.000% #### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 2 5.000% 67.500% # ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 6 15.000% 90.000% ### ( 1300, 1900 ] 1 2.500% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 329.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.590 H:M:S, 9.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 345.82 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.194 H:M:S, 6.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-08:36:21 ... thread 0: (1000000,3000000) ops and (333481.2,340588.0) ops/second in (2.998670,8.808296) 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/11 2.15 GB 56.7 1.4 0.0 1.4 4.1 2.8 0.0 1.5 105.8 322.0 13.10 12.17 45 0.291 1407K 1467 0.0 0.0 L1 1/1 2.61 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 229.8 229.4 1.64 1.59 1 1.645 383K 590 0.0 0.0 L2 2/0 55.50 MB 0.6 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 45/0 973.06 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 207.1 206.9 3.84 3.40 3 1.280 807K 840 0.0 0.0 L4 140/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1244/12 98.90 GB 0.0 2.9 1.1 1.8 5.6 3.9 2.2 2.0 146.2 287.1 20.09 18.61 51 0.394 2982K 3083 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.1 1.8 5.6 3.9 2.1 2.0 146.2 287.1 20.09 18.61 51 0.394 2982K 3083 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.1 1.8 2.9 1.1 0.0 0.0 241.2 240.9 12.18 11.53 11 1.107 2982K 3083 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 358.2 7.91 7.08 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.0 total, 8.8 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.63 GB write, 642.46 MB/s write, 2.87 GB read, 327.12 MB/s read, 20.1 seconds Interval compaction: 5.63 GB write, 654.87 MB/s write, 2.87 GB read, 333.44 MB/s read, 20.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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 699363 Average: 2.1080 StdDev: 11.26 Min: 0 Median: 1.4438 Max: 3931 Percentiles: P50: 1.44 P75: 1.83 P99: 5.40 P99.9: 9.90 P99.99: 14.97 ------------------------------------------------------ [ 0, 1 ] 149217 21.336% 21.336% #### ( 1, 2 ] 451697 64.587% 85.923% ############# ( 2, 3 ] 61600 8.808% 94.731% ## ( 3, 4 ] 21194 3.030% 97.762% # ( 4, 6 ] 12372 1.769% 99.531% ( 6, 10 ] 2649 0.379% 99.909% ( 10, 15 ] 569 0.081% 99.991% ( 15, 22 ] 56 0.008% 99.999% ( 22, 34 ] 9 0.001% 100.000% ( 34, 51 ] 3 0.000% 100.000% ( 51, 76 ] 5 0.001% 100.001% ( 110, 170 ] 18 0.003% 100.004% ( 170, 250 ] 16 0.002% 100.006% ( 250, 380 ] 19 0.003% 100.009% ( 380, 580 ] 6 0.001% 100.010% ( 580, 870 ] 7 0.001% 100.011% ( 870, 1300 ] 9 0.001% 100.012% ( 1300, 1900 ] 9 0.001% 100.013% ( 1900, 2900 ] 3 0.000% 100.014% ( 2900, 4400 ] 3 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 81473 Average: 2.5508 StdDev: 16.04 Min: 1 Median: 1.6597 Max: 3190 Percentiles: P50: 1.66 P75: 2.16 P99: 5.97 P99.9: 11.62 P99.99: 14.70 ------------------------------------------------------ [ 0, 1 ] 5718 7.018% 7.018% # ( 1, 2 ] 53081 65.152% 72.170% ############# ( 2, 3 ] 13983 17.163% 89.333% ### ( 3, 4 ] 4300 5.278% 94.610% # ( 4, 6 ] 3631 4.457% 99.067% # ( 6, 10 ] 640 0.786% 99.853% ( 10, 15 ] 119 0.146% 99.999% ( 15, 22 ] 8 0.010% 100.009% ( 22, 34 ] 2 0.002% 100.011% ( 34, 51 ] 1 0.001% 100.012% ( 51, 76 ] 1 0.001% 100.014% ( 110, 170 ] 1 0.001% 100.015% ( 170, 250 ] 2 0.002% 100.017% ( 250, 380 ] 1 0.001% 100.018% ( 380, 580 ] 3 0.004% 100.022% ( 580, 870 ] 1 0.001% 100.023% ( 870, 1300 ] 1 0.001% 100.025% ( 1300, 1900 ] 1 0.001% 100.026% ( 1900, 2900 ] 1 0.001% 100.027% ( 2900, 4400 ] 1 0.001% 100.028% ** Level 2 read latency histogram (micros): Count: 95470 Average: 1.9954 StdDev: 4.85 Min: 0 Median: 1.3917 Max: 985 Percentiles: P50: 1.39 P75: 1.80 P99: 5.44 P99.9: 9.64 P99.99: 20.72 ------------------------------------------------------ [ 0, 1 ] 24574 25.740% 25.740% ##### ( 1, 2 ] 59129 61.935% 87.675% ############ ( 2, 3 ] 6886 7.213% 94.887% # ( 3, 4 ] 2646 2.772% 97.659% # ( 4, 6 ] 1776 1.860% 99.519% ( 6, 10 ] 400 0.419% 99.938% ( 10, 15 ] 47 0.049% 99.987% ( 15, 22 ] 3 0.003% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 2 0.002% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57385 Average: 3.9781 StdDev: 59.61 Min: 0 Median: 1.6593 Max: 5085 Percentiles: P50: 1.66 P75: 2.18 P99: 6.76 P99.9: 191.53 P99.99: 3170.32 ------------------------------------------------------ [ 0, 1 ] 4314 7.518% 7.518% ## ( 1, 2 ] 36975 64.433% 71.951% ############# ( 2, 3 ] 9990 17.409% 89.360% ### ( 3, 4 ] 2991 5.212% 94.572% # ( 4, 6 ] 2458 4.283% 98.855% # ( 6, 10 ] 437 0.762% 99.617% ( 10, 15 ] 88 0.153% 99.770% ( 15, 22 ] 13 0.023% 99.793% ( 22, 34 ] 35 0.061% 99.854% ( 34, 51 ] 13 0.023% 99.876% ( 51, 76 ] 3 0.005% 99.882% ( 110, 170 ] 9 0.016% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 2 0.003% 99.920% ( 580, 870 ] 6 0.010% 99.930% ( 870, 1300 ] 17 0.030% 99.960% ( 1300, 1900 ] 8 0.014% 99.974% ( 1900, 2900 ] 8 0.014% 99.988% ( 2900, 4400 ] 7 0.012% 100.000% ( 4400, 6600 ] 1 0.002% 100.002% ** Level 4 read latency histogram (micros): Count: 20 Average: 1667.3500 StdDev: 1119.63 Min: 365 Median: 1300.0000 Max: 4152 Percentiles: P50: 1300.00 P75: 1800.00 P99: 4152.00 P99.9: 4152.00 P99.99: 4152.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 1 5.000% 20.000% # ( 870, 1300 ] 6 30.000% 50.000% ###### ( 1300, 1900 ] 6 30.000% 80.000% ###### ( 2900, 4400 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 558.3750 StdDev: 745.13 Min: 77 Median: 152.8571 Max: 3199 Percentiles: P50: 152.86 P75: 870.00 P99: 3199.00 P99.9: 3199.00 P99.99: 3199.00 ------------------------------------------------------ ( 76, 110 ] 15 37.500% 37.500% ######## ( 110, 170 ] 7 17.500% 55.000% #### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 2 5.000% 67.500% # ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 6 15.000% 90.000% ### ( 1300, 1900 ] 1 2.500% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 328.79 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.960 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.371 H:M:S, 12.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-08:36:24 ... thread 0: (1000000,4000000) ops and (323828.3,336237.5) ops/second in (3.088056,11.896352) 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/11 3.07 GB 151.0 2.5 0.0 2.5 6.2 3.8 0.0 1.7 124.3 313.7 20.27 18.94 63 0.322 2558K 2641 0.0 0.0 L1 1/1 2.61 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 229.8 229.4 1.64 1.59 1 1.645 383K 590 0.0 0.0 L2 2/0 55.50 MB 0.6 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 45/0 973.06 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 207.1 206.9 3.84 3.40 3 1.280 807K 840 0.0 0.0 L4 140/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1245/12 99.82 GB 0.0 4.0 1.1 2.9 7.7 4.9 2.2 2.1 149.3 290.1 27.26 25.38 69 0.395 4134K 4257 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.1 2.9 7.7 4.9 2.1 2.1 149.3 290.1 27.26 25.38 69 0.395 4134K 4257 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.0 1.1 2.9 4.0 1.1 0.0 0.0 246.8 246.5 16.50 15.75 15 1.100 4134K 4257 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 357.0 10.76 9.63 54 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): 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: 7.72 GB write, 655.45 MB/s write, 3.98 GB read, 337.38 MB/s read, 27.3 seconds Interval compaction: 7.72 GB write, 664.82 MB/s write, 3.98 GB read, 342.21 MB/s read, 27.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 10, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1131964 Average: 2.1695 StdDev: 10.39 Min: 0 Median: 1.4800 Max: 3931 Percentiles: P50: 1.48 P75: 1.86 P99: 5.53 P99.9: 9.95 P99.99: 14.76 ------------------------------------------------------ [ 0, 1 ] 208918 18.456% 18.456% #### ( 1, 2 ] 743911 65.719% 84.175% ############# ( 2, 3 ] 113263 10.006% 94.181% ## ( 3, 4 ] 37696 3.330% 97.511% # ( 4, 6 ] 22019 1.945% 99.456% ( 6, 10 ] 5092 0.450% 99.906% ( 10, 15 ] 1003 0.089% 99.995% ( 15, 22 ] 96 0.008% 100.003% ( 22, 34 ] 12 0.001% 100.004% ( 34, 51 ] 7 0.001% 100.005% ( 51, 76 ] 9 0.001% 100.005% ( 76, 110 ] 8 0.001% 100.006% ( 110, 170 ] 90 0.008% 100.014% ( 170, 250 ] 33 0.003% 100.017% ( 250, 380 ] 34 0.003% 100.020% ( 380, 580 ] 15 0.001% 100.021% ( 580, 870 ] 18 0.002% 100.023% ( 870, 1300 ] 13 0.001% 100.024% ( 1300, 1900 ] 12 0.001% 100.025% ( 1900, 2900 ] 3 0.000% 100.025% ( 2900, 4400 ] 4 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 81473 Average: 2.5508 StdDev: 16.04 Min: 1 Median: 1.6597 Max: 3190 Percentiles: P50: 1.66 P75: 2.16 P99: 5.97 P99.9: 11.62 P99.99: 14.70 ------------------------------------------------------ [ 0, 1 ] 5718 7.018% 7.018% # ( 1, 2 ] 53081 65.152% 72.170% ############# ( 2, 3 ] 13983 17.163% 89.333% ### ( 3, 4 ] 4300 5.278% 94.610% # ( 4, 6 ] 3631 4.457% 99.067% # ( 6, 10 ] 640 0.786% 99.853% ( 10, 15 ] 119 0.146% 99.999% ( 15, 22 ] 8 0.010% 100.009% ( 22, 34 ] 2 0.002% 100.011% ( 34, 51 ] 1 0.001% 100.012% ( 51, 76 ] 1 0.001% 100.014% ( 110, 170 ] 1 0.001% 100.015% ( 170, 250 ] 2 0.002% 100.017% ( 250, 380 ] 1 0.001% 100.018% ( 380, 580 ] 3 0.004% 100.022% ( 580, 870 ] 1 0.001% 100.023% ( 870, 1300 ] 1 0.001% 100.025% ( 1300, 1900 ] 1 0.001% 100.026% ( 1900, 2900 ] 1 0.001% 100.027% ( 2900, 4400 ] 1 0.001% 100.028% ** Level 2 read latency histogram (micros): Count: 95470 Average: 1.9954 StdDev: 4.85 Min: 0 Median: 1.3917 Max: 985 Percentiles: P50: 1.39 P75: 1.80 P99: 5.44 P99.9: 9.64 P99.99: 20.72 ------------------------------------------------------ [ 0, 1 ] 24574 25.740% 25.740% ##### ( 1, 2 ] 59129 61.935% 87.675% ############ ( 2, 3 ] 6886 7.213% 94.887% # ( 3, 4 ] 2646 2.772% 97.659% # ( 4, 6 ] 1776 1.860% 99.519% ( 6, 10 ] 400 0.419% 99.938% ( 10, 15 ] 47 0.049% 99.987% ( 15, 22 ] 3 0.003% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 2 0.002% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57385 Average: 3.9781 StdDev: 59.61 Min: 0 Median: 1.6593 Max: 5085 Percentiles: P50: 1.66 P75: 2.18 P99: 6.76 P99.9: 191.53 P99.99: 3170.32 ------------------------------------------------------ [ 0, 1 ] 4314 7.518% 7.518% ## ( 1, 2 ] 36975 64.433% 71.951% ############# ( 2, 3 ] 9990 17.409% 89.360% ### ( 3, 4 ] 2991 5.212% 94.572% # ( 4, 6 ] 2458 4.283% 98.855% # ( 6, 10 ] 437 0.762% 99.617% ( 10, 15 ] 88 0.153% 99.770% ( 15, 22 ] 13 0.023% 99.793% ( 22, 34 ] 35 0.061% 99.854% ( 34, 51 ] 13 0.023% 99.876% ( 51, 76 ] 3 0.005% 99.882% ( 110, 170 ] 9 0.016% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 2 0.003% 99.920% ( 580, 870 ] 6 0.010% 99.930% ( 870, 1300 ] 17 0.030% 99.960% ( 1300, 1900 ] 8 0.014% 99.974% ( 1900, 2900 ] 8 0.014% 99.988% ( 2900, 4400 ] 7 0.012% 100.000% ( 4400, 6600 ] 1 0.002% 100.002% ** Level 4 read latency histogram (micros): Count: 20 Average: 1667.3500 StdDev: 1119.63 Min: 365 Median: 1300.0000 Max: 4152 Percentiles: P50: 1300.00 P75: 1800.00 P99: 4152.00 P99.9: 4152.00 P99.99: 4152.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 1 5.000% 20.000% # ( 870, 1300 ] 6 30.000% 50.000% ###### ( 1300, 1900 ] 6 30.000% 80.000% ###### ( 2900, 4400 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 558.3750 StdDev: 745.13 Min: 77 Median: 152.8571 Max: 3199 Percentiles: P50: 152.86 P75: 870.00 P99: 3199.00 P99.9: 3199.00 P99.99: 3199.00 ------------------------------------------------------ ( 76, 110 ] 15 37.500% 37.500% ######## ( 110, 170 ] 7 17.500% 55.000% #### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 2 5.000% 67.500% # ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 6 15.000% 90.000% ### ( 1300, 1900 ] 1 2.500% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 326.21 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.387 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.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:0.427 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-08:36:27 ... thread 0: (1000000,5000000) ops and (331037.5,335184.5) ops/second in (3.020806,14.917158) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/15 2.77 GB 18.9 3.0 0.0 3.0 7.7 4.7 0.0 1.6 123.5 314.9 25.00 23.36 78 0.320 3134K 3235 0.0 0.0 L1 12/12 1.29 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 230.0 228.9 7.40 7.13 2 3.701 1728K 7801 0.0 0.0 L2 2/0 55.50 MB 0.6 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 45/0 973.06 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 207.1 206.9 3.84 3.40 3 1.280 807K 840 0.0 0.0 L4 140/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1257/27 100.80 GB 0.0 5.8 2.4 3.4 10.5 7.1 2.2 2.2 158.0 284.5 37.74 35.34 85 0.444 6054K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 2.4 3.4 10.5 7.1 2.1 2.2 158.0 284.5 37.74 35.34 85 0.444 6054K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.8 2.4 3.4 5.8 2.4 0.0 0.0 244.9 244.4 24.35 23.35 18 1.353 6054K 12K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 357.5 13.39 11.99 67 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.1 total, 14.9 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.49 GB write, 711.66 MB/s write, 5.82 GB read, 395.18 MB/s read, 37.7 seconds Interval compaction: 10.49 GB write, 719.78 MB/s write, 5.82 GB read, 399.69 MB/s read, 37.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 13, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1384212 Average: 2.1802 StdDev: 11.29 Min: 0 Median: 1.4650 Max: 3931 Percentiles: P50: 1.47 P75: 1.85 P99: 5.49 P99.9: 10.52 P99.99: 107.57 ------------------------------------------------------ [ 0, 1 ] 270751 19.560% 19.560% #### ( 1, 2 ] 906058 65.457% 85.017% ############# ( 2, 3 ] 131889 9.528% 94.545% ## ( 3, 4 ] 43355 3.132% 97.677% # ( 4, 6 ] 24668 1.782% 99.459% ( 6, 10 ] 5988 0.433% 99.891% ( 10, 15 ] 1145 0.083% 99.974% ( 15, 22 ] 111 0.008% 99.982% ( 22, 34 ] 15 0.001% 99.983% ( 34, 51 ] 11 0.001% 99.984% ( 51, 76 ] 13 0.001% 99.985% ( 76, 110 ] 76 0.005% 99.990% ( 110, 170 ] 208 0.015% 100.005% ( 170, 250 ] 72 0.005% 100.011% ( 250, 380 ] 62 0.004% 100.015% ( 380, 580 ] 39 0.003% 100.018% ( 580, 870 ] 26 0.002% 100.020% ( 870, 1300 ] 21 0.002% 100.021% ( 1300, 1900 ] 12 0.001% 100.022% ( 1900, 2900 ] 5 0.000% 100.023% ( 2900, 4400 ] 6 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 113388 Average: 2.7358 StdDev: 21.94 Min: 0 Median: 1.5885 Max: 3190 Percentiles: P50: 1.59 P75: 1.98 P99: 6.78 P99.9: 93.43 P99.99: 326.61 ------------------------------------------------------ [ 0, 1 ] 13564 11.962% 11.962% ## ( 1, 2 ] 73283 64.630% 76.593% ############# ( 2, 3 ] 16204 14.291% 90.884% ### ( 3, 4 ] 4942 4.358% 95.242% # ( 4, 6 ] 4065 3.585% 98.827% # ( 6, 10 ] 1010 0.891% 99.718% ( 10, 15 ] 166 0.146% 99.864% ( 15, 22 ] 13 0.011% 99.876% ( 22, 34 ] 2 0.002% 99.877% ( 34, 51 ] 1 0.001% 99.878% ( 51, 76 ] 1 0.001% 99.879% ( 76, 110 ] 48 0.042% 99.922% ( 110, 170 ] 62 0.055% 99.976% ( 170, 250 ] 9 0.008% 99.984% ( 250, 380 ] 13 0.011% 99.996% ( 380, 580 ] 11 0.010% 100.005% ( 580, 870 ] 5 0.004% 100.010% ( 870, 1300 ] 3 0.003% 100.012% ( 1300, 1900 ] 7 0.006% 100.019% ( 1900, 2900 ] 1 0.001% 100.019% ( 2900, 4400 ] 2 0.002% 100.021% ** Level 2 read latency histogram (micros): Count: 95470 Average: 1.9954 StdDev: 4.85 Min: 0 Median: 1.3917 Max: 985 Percentiles: P50: 1.39 P75: 1.80 P99: 5.44 P99.9: 9.64 P99.99: 20.72 ------------------------------------------------------ [ 0, 1 ] 24574 25.740% 25.740% ##### ( 1, 2 ] 59129 61.935% 87.675% ############ ( 2, 3 ] 6886 7.213% 94.887% # ( 3, 4 ] 2646 2.772% 97.659% # ( 4, 6 ] 1776 1.860% 99.519% ( 6, 10 ] 400 0.419% 99.938% ( 10, 15 ] 47 0.049% 99.987% ( 15, 22 ] 3 0.003% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 2 0.002% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57385 Average: 3.9781 StdDev: 59.61 Min: 0 Median: 1.6593 Max: 5085 Percentiles: P50: 1.66 P75: 2.18 P99: 6.76 P99.9: 191.53 P99.99: 3170.32 ------------------------------------------------------ [ 0, 1 ] 4314 7.518% 7.518% ## ( 1, 2 ] 36975 64.433% 71.951% ############# ( 2, 3 ] 9990 17.409% 89.360% ### ( 3, 4 ] 2991 5.212% 94.572% # ( 4, 6 ] 2458 4.283% 98.855% # ( 6, 10 ] 437 0.762% 99.617% ( 10, 15 ] 88 0.153% 99.770% ( 15, 22 ] 13 0.023% 99.793% ( 22, 34 ] 35 0.061% 99.854% ( 34, 51 ] 13 0.023% 99.876% ( 51, 76 ] 3 0.005% 99.882% ( 110, 170 ] 9 0.016% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 2 0.003% 99.920% ( 580, 870 ] 6 0.010% 99.930% ( 870, 1300 ] 17 0.030% 99.960% ( 1300, 1900 ] 8 0.014% 99.974% ( 1900, 2900 ] 8 0.014% 99.988% ( 2900, 4400 ] 7 0.012% 100.000% ( 4400, 6600 ] 1 0.002% 100.002% ** Level 4 read latency histogram (micros): Count: 20 Average: 1667.3500 StdDev: 1119.63 Min: 365 Median: 1300.0000 Max: 4152 Percentiles: P50: 1300.00 P75: 1800.00 P99: 4152.00 P99.9: 4152.00 P99.99: 4152.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 1 5.000% 20.000% # ( 870, 1300 ] 6 30.000% 50.000% ###### ( 1300, 1900 ] 6 30.000% 80.000% ###### ( 2900, 4400 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 558.3750 StdDev: 745.13 Min: 77 Median: 152.8571 Max: 3199 Percentiles: P50: 152.86 P75: 870.00 P99: 3199.00 P99.9: 3199.00 P99.99: 3199.00 ------------------------------------------------------ ( 76, 110 ] 15 37.500% 37.500% ######## ( 110, 170 ] 7 17.500% 55.000% #### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 2 5.000% 67.500% # ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 6 15.000% 90.000% ### ( 1300, 1900 ] 1 2.500% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.1 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 326.13 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.796 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.80 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.409 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-08:36:31 ... thread 0: (1000000,6000000) ops and (231189.4,311807.9) ops/second in (4.325457,19.242615) 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/11 3.75 GB 151.0 4.3 0.0 4.3 10.0 5.7 0.0 1.8 134.3 310.7 32.83 30.75 99 0.332 4477K 4630 0.0 0.0 L1 12/12 1.29 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 230.0 228.9 7.40 7.13 2 3.701 1728K 7801 0.0 0.0 L2 2/0 55.50 MB 0.6 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 45/0 973.06 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 207.1 206.9 3.84 3.40 3 1.280 807K 840 0.0 0.0 L4 140/0 9.62 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/23 101.78 GB 0.0 7.1 2.4 4.7 12.8 8.0 2.2 2.3 159.9 286.7 45.58 42.74 106 0.430 7397K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.1 2.4 4.7 12.8 8.0 2.1 2.3 159.9 286.7 45.58 42.74 106 0.430 7397K 13K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.1 2.4 4.7 7.1 2.4 0.0 0.0 248.8 248.3 29.28 28.18 23 1.273 7397K 13K 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 355.6 16.30 14.56 83 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.4 total, 19.2 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.76 GB write, 673.09 MB/s write, 7.11 GB read, 375.28 MB/s read, 45.6 seconds Interval compaction: 12.76 GB write, 679.05 MB/s write, 7.11 GB read, 378.60 MB/s read, 45.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 13, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1829002 Average: 2.1920 StdDev: 11.44 Min: 0 Median: 1.4734 Max: 4507 Percentiles: P50: 1.47 P75: 1.85 P99: 5.51 P99.9: 10.38 P99.99: 86.98 ------------------------------------------------------ [ 0, 1 ] 343088 18.758% 18.758% #### ( 1, 2 ] 1207003 65.992% 84.751% ############# ( 2, 3 ] 177757 9.719% 94.469% ## ( 3, 4 ] 58140 3.179% 97.648% # ( 4, 6 ] 32689 1.787% 99.435% ( 6, 10 ] 8381 0.458% 99.894% ( 10, 15 ] 1514 0.083% 99.976% ( 15, 22 ] 152 0.008% 99.985% ( 22, 34 ] 20 0.001% 99.986% ( 34, 51 ] 12 0.001% 99.987% ( 51, 76 ] 15 0.001% 99.987% ( 76, 110 ] 149 0.008% 99.996% ( 110, 170 ] 247 0.014% 100.009% ( 170, 250 ] 97 0.005% 100.014% ( 250, 380 ] 78 0.004% 100.019% ( 380, 580 ] 47 0.003% 100.021% ( 580, 870 ] 38 0.002% 100.023% ( 870, 1300 ] 28 0.002% 100.025% ( 1300, 1900 ] 16 0.001% 100.026% ( 1900, 2900 ] 5 0.000% 100.026% ( 2900, 4400 ] 7 0.000% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 203631 Average: 2.6351 StdDev: 17.68 Min: 0 Median: 1.5525 Max: 3190 Percentiles: P50: 1.55 P75: 1.93 P99: 7.47 P99.9: 106.47 P99.99: 369.41 ------------------------------------------------------ [ 0, 1 ] 27919 13.711% 13.711% ### ( 1, 2 ] 133750 65.683% 79.393% ############# ( 2, 3 ] 25612 12.578% 91.971% ### ( 3, 4 ] 7639 3.751% 95.722% # ( 4, 6 ] 5856 2.876% 98.598% # ( 6, 10 ] 2231 1.096% 99.694% ( 10, 15 ] 269 0.132% 99.826% ( 15, 22 ] 21 0.010% 99.836% ( 22, 34 ] 2 0.001% 99.837% ( 34, 51 ] 1 0.000% 99.837% ( 51, 76 ] 2 0.001% 99.838% ( 76, 110 ] 141 0.069% 99.908% ( 110, 170 ] 116 0.057% 99.965% ( 170, 250 ] 26 0.013% 99.977% ( 250, 380 ] 29 0.014% 99.992% ( 380, 580 ] 19 0.009% 100.001% ( 580, 870 ] 8 0.004% 100.005% ( 870, 1300 ] 4 0.002% 100.007% ( 1300, 1900 ] 7 0.003% 100.010% ( 1900, 2900 ] 1 0.000% 100.011% ( 2900, 4400 ] 2 0.001% 100.012% ** Level 2 read latency histogram (micros): Count: 95470 Average: 1.9954 StdDev: 4.85 Min: 0 Median: 1.3917 Max: 985 Percentiles: P50: 1.39 P75: 1.80 P99: 5.44 P99.9: 9.64 P99.99: 20.72 ------------------------------------------------------ [ 0, 1 ] 24574 25.740% 25.740% ##### ( 1, 2 ] 59129 61.935% 87.675% ############ ( 2, 3 ] 6886 7.213% 94.887% # ( 3, 4 ] 2646 2.772% 97.659% # ( 4, 6 ] 1776 1.860% 99.519% ( 6, 10 ] 400 0.419% 99.938% ( 10, 15 ] 47 0.049% 99.987% ( 15, 22 ] 3 0.003% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 2 0.002% 99.998% ( 580, 870 ] 1 0.001% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57385 Average: 3.9781 StdDev: 59.61 Min: 0 Median: 1.6593 Max: 5085 Percentiles: P50: 1.66 P75: 2.18 P99: 6.76 P99.9: 191.53 P99.99: 3170.32 ------------------------------------------------------ [ 0, 1 ] 4314 7.518% 7.518% ## ( 1, 2 ] 36975 64.433% 71.951% ############# ( 2, 3 ] 9990 17.409% 89.360% ### ( 3, 4 ] 2991 5.212% 94.572% # ( 4, 6 ] 2458 4.283% 98.855% # ( 6, 10 ] 437 0.762% 99.617% ( 10, 15 ] 88 0.153% 99.770% ( 15, 22 ] 13 0.023% 99.793% ( 22, 34 ] 35 0.061% 99.854% ( 34, 51 ] 13 0.023% 99.876% ( 51, 76 ] 3 0.005% 99.882% ( 110, 170 ] 9 0.016% 99.897% ( 170, 250 ] 6 0.010% 99.908% ( 250, 380 ] 5 0.009% 99.916% ( 380, 580 ] 2 0.003% 99.920% ( 580, 870 ] 6 0.010% 99.930% ( 870, 1300 ] 17 0.030% 99.960% ( 1300, 1900 ] 8 0.014% 99.974% ( 1900, 2900 ] 8 0.014% 99.988% ( 2900, 4400 ] 7 0.012% 100.000% ( 4400, 6600 ] 1 0.002% 100.002% ** Level 4 read latency histogram (micros): Count: 20 Average: 1667.3500 StdDev: 1119.63 Min: 365 Median: 1300.0000 Max: 4152 Percentiles: P50: 1300.00 P75: 1800.00 P99: 4152.00 P99.9: 4152.00 P99.99: 4152.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 580, 870 ] 1 5.000% 20.000% # ( 870, 1300 ] 6 30.000% 50.000% ###### ( 1300, 1900 ] 6 30.000% 80.000% ###### ( 2900, 4400 ] 4 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 558.3750 StdDev: 745.13 Min: 77 Median: 152.8571 Max: 3199 Percentiles: P50: 152.86 P75: 870.00 P99: 3199.00 P99.9: 3199.00 P99.99: 3199.00 ------------------------------------------------------ ( 76, 110 ] 15 37.500% 37.500% ######## ( 110, 170 ] 7 17.500% 55.000% #### ( 170, 250 ] 1 2.500% 57.500% # ( 250, 380 ] 2 5.000% 62.500% # ( 380, 580 ] 2 5.000% 67.500% # ( 580, 870 ] 3 7.500% 75.000% ## ( 870, 1300 ] 6 15.000% 90.000% ### ( 1300, 1900 ] 1 2.500% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 19.4 total, 4.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 304.16 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.372 H:M:S, 17.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 227.54 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.576 H:M:S, 36.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-08:36:45 ... thread 0: (1000000,7000000) ops and (72412.6,211785.1) ops/second in (13.809754,33.052369) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/7 2.39 GB 25.2 6.1 0.0 6.1 12.7 6.6 0.0 1.9 141.7 294.6 44.01 40.11 115 0.383 6331K 12K 0.0 0.0 L1 13/13 1.49 GB 0.0 5.2 3.9 1.3 5.2 3.9 0.2 1.3 225.6 222.9 23.70 22.34 3 7.902 5430K 63K 0.0 0.0 L2 1/1 1.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 24/8 1.64 GB 1.0 1.5 1.1 0.4 1.5 1.1 1.6 1.4 162.7 162.5 9.49 6.87 8 1.186 1525K 910 0.0 0.0 L4 158/0 9.70 GB 1.0 1.2 1.0 0.2 1.2 1.0 1.0 1.2 128.4 127.8 9.90 5.84 9 1.100 1260K 4997 0.0 0.0 L5 1056/0 87.42 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/29 102.64 GB 0.0 14.4 6.2 8.2 20.9 12.7 7.4 3.2 166.8 241.9 88.60 76.62 137 0.647 14M 82K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.4 6.2 8.2 20.9 12.7 7.3 3.2 166.8 241.9 88.60 76.62 137 0.647 14M 82K 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 14.4 6.2 8.2 14.3 6.1 0.0 0.0 215.8 214.5 68.48 59.57 41 1.670 14M 82K 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 335.0 20.12 17.05 96 0.210 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): 33.2 total, 33.1 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.93 GB write, 645.07 MB/s write, 14.43 GB read, 444.75 MB/s read, 88.6 seconds Interval compaction: 20.93 GB write, 648.39 MB/s write, 14.43 GB read, 447.04 MB/s read, 88.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 30, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 30, interval: 50 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2880464 Average: 2.6855 StdDev: 24.52 Min: 0 Median: 1.4938 Max: 10482 Percentiles: P50: 1.49 P75: 1.88 P99: 6.32 P99.9: 133.82 P99.99: 291.26 ------------------------------------------------------ [ 0, 1 ] 516552 17.933% 17.933% #### ( 1, 2 ] 1870593 64.941% 82.874% ############# ( 2, 3 ] 296408 10.290% 93.164% ## ( 3, 4 ] 100059 3.474% 96.638% # ( 4, 6 ] 66494 2.308% 98.946% ( 6, 10 ] 19746 0.686% 99.632% ( 10, 15 ] 3219 0.112% 99.743% ( 15, 22 ] 302 0.010% 99.754% ( 22, 34 ] 30 0.001% 99.755% ( 34, 51 ] 17 0.001% 99.755% ( 51, 76 ] 65 0.002% 99.758% ( 76, 110 ] 2932 0.102% 99.860% ( 110, 170 ] 2944 0.102% 99.962% ( 170, 250 ] 670 0.023% 99.985% ( 250, 380 ] 463 0.016% 100.001% ( 380, 580 ] 321 0.011% 100.012% ( 580, 870 ] 162 0.006% 100.018% ( 870, 1300 ] 64 0.002% 100.020% ( 1300, 1900 ] 30 0.001% 100.021% ( 1900, 2900 ] 30 0.001% 100.022% ( 2900, 4400 ] 40 0.001% 100.024% ( 4400, 6600 ] 16 0.001% 100.024% ( 6600, 9900 ] 1 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 755696 Average: 4.1867 StdDev: 57.57 Min: 0 Median: 1.6814 Max: 7423 Percentiles: P50: 1.68 P75: 2.39 P99: 8.82 P99.9: 119.83 P99.99: 304.41 ------------------------------------------------------ [ 0, 1 ] 81479 10.782% 10.782% ## ( 1, 2 ] 434930 57.554% 68.336% ############ ( 2, 3 ] 128347 16.984% 85.319% ### ( 3, 4 ] 48542 6.423% 91.743% # ( 4, 6 ] 45977 6.084% 97.827% # ( 6, 10 ] 12576 1.664% 99.491% ( 10, 15 ] 2094 0.277% 99.768% ( 15, 22 ] 258 0.034% 99.802% ( 22, 34 ] 16 0.002% 99.805% ( 34, 51 ] 12 0.002% 99.806% ( 51, 76 ] 26 0.003% 99.810% ( 76, 110 ] 587 0.078% 99.887% ( 110, 170 ] 588 0.078% 99.965% ( 170, 250 ] 129 0.017% 99.982% ( 250, 380 ] 142 0.019% 100.001% ( 380, 580 ] 218 0.029% 100.030% ( 580, 870 ] 176 0.023% 100.053% ( 870, 1300 ] 161 0.021% 100.074% ( 1300, 1900 ] 70 0.009% 100.084% ( 1900, 2900 ] 68 0.009% 100.093% ( 2900, 4400 ] 86 0.011% 100.104% ( 4400, 6600 ] 14 0.002% 100.106% ( 6600, 9900 ] 3 0.000% 100.106% ** Level 2 read latency histogram (micros): Count: 95822 Average: 3.1823 StdDev: 59.14 Min: 0 Median: 1.3941 Max: 6483 Percentiles: P50: 1.39 P75: 1.80 P99: 5.52 P99.9: 12.89 P99.99: 3577.22 ------------------------------------------------------ [ 0, 1 ] 24575 25.647% 25.647% ##### ( 1, 2 ] 59209 61.791% 87.437% ############ ( 2, 3 ] 7029 7.335% 94.773% # ( 3, 4 ] 2687 2.804% 97.577% # ( 4, 6 ] 1790 1.868% 99.445% ( 6, 10 ] 409 0.427% 99.872% ( 10, 15 ] 47 0.049% 99.921% ( 15, 22 ] 3 0.003% 99.924% ( 22, 34 ] 1 0.001% 99.925% ( 34, 51 ] 1 0.001% 99.926% ( 51, 76 ] 1 0.001% 99.927% ( 110, 170 ] 1 0.001% 99.928% ( 170, 250 ] 3 0.003% 99.931% ( 250, 380 ] 5 0.005% 99.936% ( 380, 580 ] 7 0.007% 99.944% ( 580, 870 ] 13 0.014% 99.957% ( 870, 1300 ] 11 0.011% 99.969% ( 1300, 1900 ] 4 0.004% 99.973% ( 1900, 2900 ] 11 0.011% 99.984% ( 2900, 4400 ] 12 0.013% 99.997% ( 4400, 6600 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 353749 Average: 11.7440 StdDev: 142.05 Min: 0 Median: 1.8591 Max: 8769 Percentiles: P50: 1.86 P75: 2.81 P99: 13.15 P99.9: 1274.66 P99.99: 2340.57 ------------------------------------------------------ [ 0, 1 ] 12537 3.544% 3.544% # ( 1, 2 ] 191285 54.074% 57.618% ########### ( 2, 3 ] 75928 21.464% 79.081% #### ( 3, 4 ] 33823 9.561% 88.643% ## ( 4, 6 ] 29135 8.236% 96.879% ## ( 6, 10 ] 6774 1.915% 98.794% ( 10, 15 ] 1159 0.328% 99.121% ( 15, 22 ] 186 0.053% 99.174% ( 22, 34 ] 53 0.015% 99.189% ( 34, 51 ] 17 0.005% 99.194% ( 51, 76 ] 9 0.003% 99.196% ( 76, 110 ] 65 0.018% 99.215% ( 110, 170 ] 194 0.055% 99.270% ( 170, 250 ] 264 0.075% 99.344% ( 250, 380 ] 397 0.112% 99.456% ( 380, 580 ] 575 0.163% 99.619% ( 580, 870 ] 600 0.170% 99.789% ( 870, 1300 ] 420 0.119% 99.907% ( 1300, 1900 ] 213 0.060% 99.967% ( 1900, 2900 ] 183 0.052% 100.019% ( 2900, 4400 ] 197 0.056% 100.075% ( 4400, 6600 ] 51 0.014% 100.089% ( 6600, 9900 ] 14 0.004% 100.093% ** Level 4 read latency histogram (micros): Count: 12205 Average: 8.7286 StdDev: 110.55 Min: 0 Median: 2.0238 Max: 4514 Percentiles: P50: 2.02 P75: 3.00 P99: 10.71 P99.9: 1707.70 P99.99: 4333.85 ------------------------------------------------------ [ 0, 1 ] 98 0.803% 0.803% ( 1, 2 ] 5930 48.587% 49.390% ########## ( 2, 3 ] 3130 25.645% 75.035% ##### ( 3, 4 ] 1371 11.233% 86.268% ## ( 4, 6 ] 1392 11.405% 97.673% ## ( 6, 10 ] 155 1.270% 98.943% ( 10, 15 ] 49 0.401% 99.345% ( 15, 22 ] 11 0.090% 99.435% ( 34, 51 ] 1 0.008% 99.443% ( 76, 110 ] 2 0.016% 99.459% ( 110, 170 ] 4 0.033% 99.492% ( 170, 250 ] 15 0.123% 99.615% ( 250, 380 ] 6 0.049% 99.664% ( 380, 580 ] 5 0.041% 99.705% ( 580, 870 ] 4 0.033% 99.738% ( 870, 1300 ] 13 0.107% 99.844% ( 1300, 1900 ] 10 0.082% 99.926% ( 1900, 2900 ] 3 0.025% 99.951% ( 2900, 4400 ] 5 0.041% 99.992% ( 4400, 6600 ] 1 0.008% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 1073.2417 StdDev: 1151.44 Min: 77 Median: 598.1250 Max: 5071 Percentiles: P50: 598.12 P75: 1525.00 P99: 5071.00 P99.9: 5071.00 P99.99: 5071.00 ------------------------------------------------------ ( 76, 110 ] 18 15.000% 15.000% ### ( 110, 170 ] 10 8.333% 23.333% ## ( 170, 250 ] 5 4.167% 27.500% # ( 250, 380 ] 7 5.833% 33.333% # ( 380, 580 ] 19 15.833% 49.167% ### ( 580, 870 ] 16 13.333% 62.500% ### ( 870, 1300 ] 12 10.000% 72.500% ## ( 1300, 1900 ] 8 6.667% 79.167% # ( 1900, 2900 ] 13 10.833% 90.000% ## ( 2900, 4400 ] 10 8.333% 98.333% ## ( 4400, 6600 ] 2 1.667% 100.000% ** DB Stats ** Uptime(secs): 33.2 total, 13.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 207.36 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:14.277 H:M:S, 43.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 71.27 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:10.904 H:M:S, 79.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-08:36:48 ... thread 0: (1000000,8000000) ops and (326355.4,221505.3) ops/second in (3.064144,36.116513) 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/11 3.37 GB 100.7 7.0 0.0 7.0 14.5 7.6 0.0 1.9 141.5 295.4 50.28 46.01 132 0.381 7226K 13K 0.0 0.0 L1 13/13 1.49 GB 0.0 5.2 3.9 1.3 5.2 3.9 0.2 1.3 225.6 222.9 23.70 22.34 3 7.902 5430K 63K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 16/0 999.82 MB 1.0 2.2 1.1 1.1 2.2 1.1 1.6 1.9 167.1 166.8 13.31 9.61 9 1.479 2216K 2668 0.0 0.0 L4 161/0 9.68 GB 1.0 1.2 1.0 0.2 1.2 1.0 1.7 1.2 128.4 127.8 9.90 5.84 9 1.100 1260K 4997 0.0 0.0 L5 1064/0 88.09 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1269/24 103.62 GB 0.0 16.0 6.2 9.7 23.4 13.7 8.7 3.1 165.5 243.1 98.70 85.26 155 0.637 16M 85K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.0 6.2 9.7 23.4 13.7 8.6 3.1 165.5 243.1 98.70 85.26 155 0.637 16M 85K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.0 6.2 9.7 15.9 6.1 0.0 0.0 216.0 214.8 75.66 65.59 45 1.681 16M 85K 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 336.3 23.04 19.66 110 0.209 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 36.3 total, 36.1 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 23.44 GB write, 661.34 MB/s write, 15.96 GB read, 450.24 MB/s read, 98.7 seconds Interval compaction: 23.44 GB write, 664.46 MB/s write, 15.96 GB read, 452.36 MB/s read, 98.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 38, interval: 58 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3237235 Average: 2.6420 StdDev: 23.33 Min: 0 Median: 1.5023 Max: 10482 Percentiles: P50: 1.50 P75: 1.89 P99: 6.21 P99.9: 124.82 P99.99: 253.40 ------------------------------------------------------ [ 0, 1 ] 559050 17.269% 17.269% ### ( 1, 2 ] 2109387 65.160% 82.430% ############# ( 2, 3 ] 346320 10.698% 93.128% ## ( 3, 4 ] 113210 3.497% 96.625% # ( 4, 6 ] 75700 2.338% 98.963% ( 6, 10 ] 22785 0.704% 99.667% ( 10, 15 ] 3435 0.106% 99.773% ( 15, 22 ] 331 0.010% 99.783% ( 22, 34 ] 33 0.001% 99.784% ( 34, 51 ] 18 0.001% 99.785% ( 51, 76 ] 69 0.002% 99.787% ( 76, 110 ] 2932 0.091% 99.878% ( 110, 170 ] 2950 0.091% 99.969% ( 170, 250 ] 680 0.021% 99.990% ( 250, 380 ] 470 0.015% 100.004% ( 380, 580 ] 323 0.010% 100.014% ( 580, 870 ] 166 0.005% 100.019% ( 870, 1300 ] 67 0.002% 100.021% ( 1300, 1900 ] 30 0.001% 100.022% ( 1900, 2900 ] 31 0.001% 100.023% ( 2900, 4400 ] 42 0.001% 100.025% ( 4400, 6600 ] 16 0.000% 100.025% ( 6600, 9900 ] 1 0.000% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 811729 Average: 4.0994 StdDev: 55.70 Min: 0 Median: 1.6757 Max: 7423 Percentiles: P50: 1.68 P75: 2.36 P99: 8.79 P99.9: 124.79 P99.99: 323.09 ------------------------------------------------------ [ 0, 1 ] 86618 10.671% 10.671% ## ( 1, 2 ] 472501 58.209% 68.880% ############ ( 2, 3 ] 136388 16.802% 85.682% ### ( 3, 4 ] 50980 6.280% 91.963% # ( 4, 6 ] 47669 5.873% 97.835% # ( 6, 10 ] 13540 1.668% 99.503% ( 10, 15 ] 2137 0.263% 99.766% ( 15, 22 ] 263 0.032% 99.799% ( 22, 34 ] 16 0.002% 99.801% ( 34, 51 ] 12 0.001% 99.802% ( 51, 76 ] 28 0.003% 99.806% ( 76, 110 ] 605 0.075% 99.880% ( 110, 170 ] 650 0.080% 99.960% ( 170, 250 ] 152 0.019% 99.979% ( 250, 380 ] 158 0.019% 99.999% ( 380, 580 ] 226 0.028% 100.026% ( 580, 870 ] 186 0.023% 100.049% ( 870, 1300 ] 161 0.020% 100.069% ( 1300, 1900 ] 71 0.009% 100.078% ( 1900, 2900 ] 68 0.008% 100.086% ( 2900, 4400 ] 86 0.011% 100.097% ( 4400, 6600 ] 14 0.002% 100.099% ( 6600, 9900 ] 3 0.000% 100.099% ** Level 2 read latency histogram (micros): Count: 95910 Average: 3.2916 StdDev: 59.66 Min: 0 Median: 1.3947 Max: 6483 Percentiles: P50: 1.39 P75: 1.80 P99: 5.56 P99.9: 127.91 P99.99: 3576.12 ------------------------------------------------------ [ 0, 1 ] 24575 25.623% 25.623% ##### ( 1, 2 ] 59238 61.764% 87.387% ############ ( 2, 3 ] 7055 7.356% 94.743% # ( 3, 4 ] 2689 2.804% 97.547% # ( 4, 6 ] 1792 1.868% 99.415% ( 6, 10 ] 410 0.427% 99.843% ( 10, 15 ] 47 0.049% 99.892% ( 15, 22 ] 3 0.003% 99.895% ( 22, 34 ] 1 0.001% 99.896% ( 34, 51 ] 1 0.001% 99.897% ( 51, 76 ] 1 0.001% 99.898% ( 110, 170 ] 7 0.007% 99.905% ( 170, 250 ] 10 0.010% 99.916% ( 250, 380 ] 11 0.011% 99.927% ( 380, 580 ] 11 0.011% 99.938% ( 580, 870 ] 15 0.016% 99.954% ( 870, 1300 ] 14 0.015% 99.969% ( 1300, 1900 ] 4 0.004% 99.973% ( 1900, 2900 ] 11 0.011% 99.984% ( 2900, 4400 ] 12 0.013% 99.997% ( 4400, 6600 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 360922 Average: 11.5964 StdDev: 140.74 Min: 0 Median: 1.8546 Max: 8769 Percentiles: P50: 1.85 P75: 2.80 P99: 12.98 P99.9: 1268.49 P99.99: 2336.65 ------------------------------------------------------ [ 0, 1 ] 13031 3.610% 3.610% # ( 1, 2 ] 195917 54.282% 57.893% ########### ( 2, 3 ] 77094 21.360% 79.253% #### ( 3, 4 ] 34210 9.479% 88.732% ## ( 4, 6 ] 29454 8.161% 96.892% ## ( 6, 10 ] 6912 1.915% 98.807% ( 10, 15 ] 1166 0.323% 99.131% ( 15, 22 ] 187 0.052% 99.182% ( 22, 34 ] 53 0.015% 99.197% ( 34, 51 ] 17 0.005% 99.202% ( 51, 76 ] 9 0.002% 99.204% ( 76, 110 ] 65 0.018% 99.222% ( 110, 170 ] 198 0.055% 99.277% ( 170, 250 ] 273 0.076% 99.353% ( 250, 380 ] 399 0.111% 99.463% ( 380, 580 ] 579 0.160% 99.624% ( 580, 870 ] 606 0.168% 99.792% ( 870, 1300 ] 422 0.117% 99.909% ( 1300, 1900 ] 214 0.059% 99.968% ( 1900, 2900 ] 183 0.051% 100.019% ( 2900, 4400 ] 197 0.055% 100.073% ( 4400, 6600 ] 51 0.014% 100.087% ( 6600, 9900 ] 14 0.004% 100.091% ** Level 4 read latency histogram (micros): Count: 12205 Average: 8.7286 StdDev: 110.55 Min: 0 Median: 2.0238 Max: 4514 Percentiles: P50: 2.02 P75: 3.00 P99: 10.71 P99.9: 1707.70 P99.99: 4333.85 ------------------------------------------------------ [ 0, 1 ] 98 0.803% 0.803% ( 1, 2 ] 5930 48.587% 49.390% ########## ( 2, 3 ] 3130 25.645% 75.035% ##### ( 3, 4 ] 1371 11.233% 86.268% ## ( 4, 6 ] 1392 11.405% 97.673% ## ( 6, 10 ] 155 1.270% 98.943% ( 10, 15 ] 49 0.401% 99.345% ( 15, 22 ] 11 0.090% 99.435% ( 34, 51 ] 1 0.008% 99.443% ( 76, 110 ] 2 0.016% 99.459% ( 110, 170 ] 4 0.033% 99.492% ( 170, 250 ] 15 0.123% 99.615% ( 250, 380 ] 6 0.049% 99.664% ( 380, 580 ] 5 0.041% 99.705% ( 580, 870 ] 4 0.033% 99.738% ( 870, 1300 ] 13 0.107% 99.844% ( 1300, 1900 ] 10 0.082% 99.926% ( 1900, 2900 ] 3 0.025% 99.951% ( 2900, 4400 ] 5 0.041% 99.992% ( 4400, 6600 ] 1 0.008% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 1037.1437 StdDev: 1177.57 Min: 77 Median: 537.8947 Max: 5071 Percentiles: P50: 537.89 P75: 1500.00 P99: 5071.00 P99.9: 5071.00 P99.99: 5071.00 ------------------------------------------------------ ( 76, 110 ] 24 15.000% 15.000% ### ( 110, 170 ] 21 13.125% 28.125% ### ( 170, 250 ] 9 5.625% 33.750% # ( 250, 380 ] 11 6.875% 40.625% # ( 380, 580 ] 19 11.875% 52.500% ## ( 580, 870 ] 19 11.875% 64.375% ## ( 870, 1300 ] 13 8.125% 72.500% ## ( 1300, 1900 ] 12 7.500% 80.000% ## ( 1900, 2900 ] 16 10.000% 90.000% ## ( 2900, 4400 ] 12 7.500% 97.500% ## ( 4400, 6600 ] 4 2.500% 100.000% # ** DB Stats ** Uptime(secs): 36.3 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 216.97 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:14.725 H:M:S, 40.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.19 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.449 H:M:S, 14.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-08:36:57 ... thread 0: (1000000,9000000) ops and (118425.4,201971.9) ops/second in (8.444132,44.560645) 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/9 4.42 GB 132.1 8.4 0.0 8.4 17.0 8.6 0.0 2.0 145.8 295.6 58.77 54.08 151 0.389 8698K 15K 0.0 0.0 L1 13/13 1.49 GB 0.0 5.2 3.9 1.3 5.2 3.9 0.2 1.3 225.6 222.9 23.70 22.34 3 7.902 5430K 63K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 16/0 999.82 MB 1.0 2.2 1.1 1.1 2.2 1.1 1.6 1.9 167.1 166.8 13.31 9.61 9 1.479 2216K 2668 0.0 0.0 L4 161/0 9.68 GB 1.0 1.2 1.0 0.2 1.2 1.0 1.7 1.2 128.4 127.8 9.90 5.84 9 1.100 1260K 4997 0.0 0.0 L5 1064/0 88.09 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/22 104.66 GB 0.0 17.4 6.2 11.1 25.9 14.8 8.7 3.0 165.9 247.4 107.19 93.33 174 0.616 17M 86K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.4 6.2 11.1 25.9 14.8 8.6 3.0 165.9 247.4 107.19 93.33 174 0.616 17M 86K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.4 6.2 11.1 17.3 6.1 0.0 0.0 219.4 218.2 81.09 70.92 50 1.622 17M 86K 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 338.0 26.10 22.41 124 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 44.7 total, 44.6 interval Flush(GB): cumulative 8.613, interval 8.613 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: 25.90 GB write, 592.79 MB/s write, 17.37 GB read, 397.64 MB/s read, 107.2 seconds Interval compaction: 25.90 GB write, 595.06 MB/s write, 17.37 GB read, 399.16 MB/s read, 107.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 43, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 24, total-stops: 43, interval: 67 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3966319 Average: 2.6967 StdDev: 22.37 Min: 0 Median: 1.5033 Max: 10482 Percentiles: P50: 1.50 P75: 1.88 P99: 6.43 P99.9: 136.63 P99.99: 299.17 ------------------------------------------------------ [ 0, 1 ] 673609 16.983% 16.983% ### ( 1, 2 ] 2602030 65.603% 82.586% ############# ( 2, 3 ] 421369 10.624% 93.210% ## ( 3, 4 ] 137502 3.467% 96.677% # ( 4, 6 ] 89198 2.249% 98.926% ( 6, 10 ] 27595 0.696% 99.621% ( 10, 15 ] 3938 0.099% 99.721% ( 15, 22 ] 536 0.014% 99.734% ( 22, 34 ] 39 0.001% 99.735% ( 34, 51 ] 19 0.000% 99.736% ( 51, 76 ] 82 0.002% 99.738% ( 76, 110 ] 4519 0.114% 99.852% ( 110, 170 ] 4320 0.109% 99.961% ( 170, 250 ] 917 0.023% 99.984% ( 250, 380 ] 662 0.017% 100.000% ( 380, 580 ] 472 0.012% 100.012% ( 580, 870 ] 230 0.006% 100.018% ( 870, 1300 ] 82 0.002% 100.020% ( 1300, 1900 ] 34 0.001% 100.021% ( 1900, 2900 ] 39 0.001% 100.022% ( 2900, 4400 ] 43 0.001% 100.023% ( 4400, 6600 ] 16 0.000% 100.023% ( 6600, 9900 ] 1 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1126766 Average: 3.7410 StdDev: 47.69 Min: 0 Median: 1.6343 Max: 7423 Percentiles: P50: 1.63 P75: 2.18 P99: 8.77 P99.9: 139.22 P99.99: 360.51 ------------------------------------------------------ [ 0, 1 ] 127542 11.319% 11.319% ## ( 1, 2 ] 687112 60.981% 72.300% ############ ( 2, 3 ] 171588 15.228% 87.529% ### ( 3, 4 ] 62030 5.505% 93.034% # ( 4, 6 ] 54644 4.850% 97.883% # ( 6, 10 ] 18183 1.614% 99.497% ( 10, 15 ] 2424 0.215% 99.712% ( 15, 22 ] 341 0.030% 99.742% ( 22, 34 ] 21 0.002% 99.744% ( 34, 51 ] 12 0.001% 99.745% ( 51, 76 ] 55 0.005% 99.750% ( 76, 110 ] 1133 0.101% 99.851% ( 110, 170 ] 1138 0.101% 99.952% ( 170, 250 ] 245 0.022% 99.974% ( 250, 380 ] 218 0.019% 99.993% ( 380, 580 ] 273 0.024% 100.017% ( 580, 870 ] 203 0.018% 100.035% ( 870, 1300 ] 165 0.015% 100.050% ( 1300, 1900 ] 71 0.006% 100.056% ( 1900, 2900 ] 68 0.006% 100.062% ( 2900, 4400 ] 86 0.008% 100.070% ( 4400, 6600 ] 14 0.001% 100.071% ( 6600, 9900 ] 3 0.000% 100.071% ** Level 2 read latency histogram (micros): Count: 95910 Average: 3.2916 StdDev: 59.66 Min: 0 Median: 1.3947 Max: 6483 Percentiles: P50: 1.39 P75: 1.80 P99: 5.56 P99.9: 127.91 P99.99: 3576.12 ------------------------------------------------------ [ 0, 1 ] 24575 25.623% 25.623% ##### ( 1, 2 ] 59238 61.764% 87.387% ############ ( 2, 3 ] 7055 7.356% 94.743% # ( 3, 4 ] 2689 2.804% 97.547% # ( 4, 6 ] 1792 1.868% 99.415% ( 6, 10 ] 410 0.427% 99.843% ( 10, 15 ] 47 0.049% 99.892% ( 15, 22 ] 3 0.003% 99.895% ( 22, 34 ] 1 0.001% 99.896% ( 34, 51 ] 1 0.001% 99.897% ( 51, 76 ] 1 0.001% 99.898% ( 110, 170 ] 7 0.007% 99.905% ( 170, 250 ] 10 0.010% 99.916% ( 250, 380 ] 11 0.011% 99.927% ( 380, 580 ] 11 0.011% 99.938% ( 580, 870 ] 15 0.016% 99.954% ( 870, 1300 ] 14 0.015% 99.969% ( 1300, 1900 ] 4 0.004% 99.973% ( 1900, 2900 ] 11 0.011% 99.984% ( 2900, 4400 ] 12 0.013% 99.997% ( 4400, 6600 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 360922 Average: 11.5964 StdDev: 140.74 Min: 0 Median: 1.8546 Max: 8769 Percentiles: P50: 1.85 P75: 2.80 P99: 12.98 P99.9: 1268.49 P99.99: 2336.65 ------------------------------------------------------ [ 0, 1 ] 13031 3.610% 3.610% # ( 1, 2 ] 195917 54.282% 57.893% ########### ( 2, 3 ] 77094 21.360% 79.253% #### ( 3, 4 ] 34210 9.479% 88.732% ## ( 4, 6 ] 29454 8.161% 96.892% ## ( 6, 10 ] 6912 1.915% 98.807% ( 10, 15 ] 1166 0.323% 99.131% ( 15, 22 ] 187 0.052% 99.182% ( 22, 34 ] 53 0.015% 99.197% ( 34, 51 ] 17 0.005% 99.202% ( 51, 76 ] 9 0.002% 99.204% ( 76, 110 ] 65 0.018% 99.222% ( 110, 170 ] 198 0.055% 99.277% ( 170, 250 ] 273 0.076% 99.353% ( 250, 380 ] 399 0.111% 99.463% ( 380, 580 ] 579 0.160% 99.624% ( 580, 870 ] 606 0.168% 99.792% ( 870, 1300 ] 422 0.117% 99.909% ( 1300, 1900 ] 214 0.059% 99.968% ( 1900, 2900 ] 183 0.051% 100.019% ( 2900, 4400 ] 197 0.055% 100.073% ( 4400, 6600 ] 51 0.014% 100.087% ( 6600, 9900 ] 14 0.004% 100.091% ** Level 4 read latency histogram (micros): Count: 12205 Average: 8.7286 StdDev: 110.55 Min: 0 Median: 2.0238 Max: 4514 Percentiles: P50: 2.02 P75: 3.00 P99: 10.71 P99.9: 1707.70 P99.99: 4333.85 ------------------------------------------------------ [ 0, 1 ] 98 0.803% 0.803% ( 1, 2 ] 5930 48.587% 49.390% ########## ( 2, 3 ] 3130 25.645% 75.035% ##### ( 3, 4 ] 1371 11.233% 86.268% ## ( 4, 6 ] 1392 11.405% 97.673% ## ( 6, 10 ] 155 1.270% 98.943% ( 10, 15 ] 49 0.401% 99.345% ( 15, 22 ] 11 0.090% 99.435% ( 34, 51 ] 1 0.008% 99.443% ( 76, 110 ] 2 0.016% 99.459% ( 110, 170 ] 4 0.033% 99.492% ( 170, 250 ] 15 0.123% 99.615% ( 250, 380 ] 6 0.049% 99.664% ( 380, 580 ] 5 0.041% 99.705% ( 580, 870 ] 4 0.033% 99.738% ( 870, 1300 ] 13 0.107% 99.844% ( 1300, 1900 ] 10 0.082% 99.926% ( 1900, 2900 ] 3 0.025% 99.951% ( 2900, 4400 ] 5 0.041% 99.992% ( 4400, 6600 ] 1 0.008% 100.000% ** Level 5 read latency histogram (micros): Count: 160 Average: 1037.1437 StdDev: 1177.57 Min: 77 Median: 537.8947 Max: 5071 Percentiles: P50: 537.89 P75: 1500.00 P99: 5071.00 P99.9: 5071.00 P99.99: 5071.00 ------------------------------------------------------ ( 76, 110 ] 24 15.000% 15.000% ### ( 110, 170 ] 21 13.125% 28.125% ### ( 170, 250 ] 9 5.625% 33.750% # ( 250, 380 ] 11 6.875% 40.625% # ( 380, 580 ] 19 11.875% 52.500% ## ( 580, 870 ] 19 11.875% 64.375% ## ( 870, 1300 ] 13 8.125% 72.500% ## ( 1300, 1900 ] 12 7.500% 80.000% ## ( 1900, 2900 ] 16 10.000% 90.000% ## ( 2900, 4400 ] 12 7.500% 97.500% ## ( 4400, 6600 ] 4 2.500% 100.000% # ** DB Stats ** Uptime(secs): 44.7 total, 8.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 198.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.537 H:M:S, 45.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 116.55 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.812 H:M:S, 68.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/12/13-08:37:04 ... thread 0: (1000000,10000000) ops and (136769.5,192781.4) ops/second in (7.311570,51.872215) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/6 3.43 GB 88.1 10.2 0.0 10.2 19.7 9.5 0.0 2.1 150.0 288.8 69.72 63.59 166 0.420 10M 23K 0.0 0.0 L1 12/11 1.24 GB 0.0 8.6 5.8 2.8 8.5 5.7 0.2 1.5 219.3 216.7 39.93 36.91 4 9.984 7863K 63K 0.0 0.0 L2 1/0 66.84 MB 0.7 0.4 0.2 0.2 0.4 0.2 4.6 2.0 251.4 251.3 1.50 1.46 2 0.752 383K 186 0.0 0.0 L3 21/0 898.21 MB 0.9 3.4 1.6 1.8 3.4 1.6 3.1 2.1 156.4 155.6 22.18 15.28 16 1.386 3482K 17K 0.0 0.0 L4 154/0 9.41 GB 1.0 3.9 3.1 0.9 3.9 3.0 1.7 1.3 140.2 139.5 28.67 18.51 30 0.956 4041K 17K 0.0 0.0 L5 1092/0 90.43 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1292/17 105.45 GB 0.0 26.4 10.6 15.9 35.8 19.9 14.7 3.8 167.1 226.0 162.01 135.74 218 0.743 26M 122K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.4 10.6 15.9 35.8 19.9 14.6 3.8 167.1 226.0 162.01 135.74 218 0.743 26M 122K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 26.4 10.6 15.9 26.3 10.4 0.0 0.0 203.7 202.5 132.92 111.06 82 1.621 26M 122K 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 333.5 29.09 24.68 136 0.214 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 52.0 total, 51.9 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 35.76 GB write, 703.58 MB/s write, 26.44 GB read, 520.32 MB/s read, 162.0 seconds Interval compaction: 35.76 GB write, 705.88 MB/s write, 26.44 GB read, 522.03 MB/s read, 162.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 51, pending-compaction-bytes-delays: 35, pending-compaction-bytes-stops: 0, total-delays: 49, total-stops: 51, interval: 100 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4477652 Average: 2.8868 StdDev: 25.61 Min: 0 Median: 1.5223 Max: 10482 Percentiles: P50: 1.52 P75: 1.91 P99: 7.18 P99.9: 148.85 P99.99: 379.74 ------------------------------------------------------ [ 0, 1 ] 722049 16.126% 16.126% ### ( 1, 2 ] 2904103 64.858% 80.983% ############# ( 2, 3 ] 509212 11.372% 92.356% ## ( 3, 4 ] 168839 3.771% 96.126% # ( 4, 6 ] 118048 2.636% 98.763% # ( 6, 10 ] 35913 0.802% 99.565% ( 10, 15 ] 4868 0.109% 99.673% ( 15, 22 ] 633 0.014% 99.688% ( 22, 34 ] 47 0.001% 99.689% ( 34, 51 ] 24 0.001% 99.689% ( 51, 76 ] 94 0.002% 99.691% ( 76, 110 ] 5771 0.129% 99.820% ( 110, 170 ] 5520 0.123% 99.943% ( 170, 250 ] 1189 0.027% 99.970% ( 250, 380 ] 897 0.020% 99.990% ( 380, 580 ] 684 0.015% 100.005% ( 580, 870 ] 395 0.009% 100.014% ( 870, 1300 ] 176 0.004% 100.018% ( 1300, 1900 ] 73 0.002% 100.020% ( 1900, 2900 ] 70 0.002% 100.021% ( 2900, 4400 ] 64 0.001% 100.023% ( 4400, 6600 ] 20 0.000% 100.023% ( 6600, 9900 ] 1 0.000% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1713891 Average: 4.5814 StdDev: 57.86 Min: 0 Median: 1.7336 Max: 8091 Percentiles: P50: 1.73 P75: 2.55 P99: 9.10 P99.9: 143.36 P99.99: 363.53 ------------------------------------------------------ [ 0, 1 ] 139981 8.167% 8.167% ## ( 1, 2 ] 977389 57.027% 65.195% ########### ( 2, 3 ] 307947 17.968% 83.163% #### ( 3, 4 ] 125989 7.351% 90.514% # ( 4, 6 ] 118606 6.920% 97.434% # ( 6, 10 ] 34677 2.023% 99.457% ( 10, 15 ] 4591 0.268% 99.725% ( 15, 22 ] 616 0.036% 99.761% ( 22, 34 ] 42 0.002% 99.764% ( 34, 51 ] 21 0.001% 99.765% ( 51, 76 ] 90 0.005% 99.770% ( 76, 110 ] 1427 0.083% 99.853% ( 110, 170 ] 1441 0.084% 99.937% ( 170, 250 ] 452 0.026% 99.964% ( 250, 380 ] 516 0.030% 99.994% ( 380, 580 ] 698 0.041% 100.035% ( 580, 870 ] 621 0.036% 100.071% ( 870, 1300 ] 493 0.029% 100.100% ( 1300, 1900 ] 215 0.013% 100.112% ( 1900, 2900 ] 147 0.009% 100.121% ( 2900, 4400 ] 184 0.011% 100.131% ( 4400, 6600 ] 30 0.002% 100.133% ( 6600, 9900 ] 4 0.000% 100.133% ** Level 2 read latency histogram (micros): Count: 95910 Average: 3.2916 StdDev: 59.66 Min: 0 Median: 1.3947 Max: 6483 Percentiles: P50: 1.39 P75: 1.80 P99: 5.56 P99.9: 127.91 P99.99: 3576.12 ------------------------------------------------------ [ 0, 1 ] 24575 25.623% 25.623% ##### ( 1, 2 ] 59238 61.764% 87.387% ############ ( 2, 3 ] 7055 7.356% 94.743% # ( 3, 4 ] 2689 2.804% 97.547% # ( 4, 6 ] 1792 1.868% 99.415% ( 6, 10 ] 410 0.427% 99.843% ( 10, 15 ] 47 0.049% 99.892% ( 15, 22 ] 3 0.003% 99.895% ( 22, 34 ] 1 0.001% 99.896% ( 34, 51 ] 1 0.001% 99.897% ( 51, 76 ] 1 0.001% 99.898% ( 110, 170 ] 7 0.007% 99.905% ( 170, 250 ] 10 0.010% 99.916% ( 250, 380 ] 11 0.011% 99.927% ( 380, 580 ] 11 0.011% 99.938% ( 580, 870 ] 15 0.016% 99.954% ( 870, 1300 ] 14 0.015% 99.969% ( 1300, 1900 ] 4 0.004% 99.973% ( 1900, 2900 ] 11 0.011% 99.984% ( 2900, 4400 ] 12 0.013% 99.997% ( 4400, 6600 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 731030 Average: 9.5567 StdDev: 117.92 Min: 0 Median: 1.9289 Max: 8769 Percentiles: P50: 1.93 P75: 2.94 P99: 9.84 P99.9: 870.59 P99.99: 1267.93 ------------------------------------------------------ [ 0, 1 ] 17604 2.408% 2.408% ( 1, 2 ] 374528 51.233% 53.641% ########## ( 2, 3 ] 165977 22.705% 76.346% ##### ( 3, 4 ] 79338 10.853% 87.198% ## ( 4, 6 ] 72658 9.939% 97.138% ## ( 6, 10 ] 14164 1.938% 99.075% ( 10, 15 ] 2144 0.293% 99.368% ( 15, 22 ] 315 0.043% 99.412% ( 22, 34 ] 70 0.010% 99.421% ( 34, 51 ] 26 0.004% 99.425% ( 51, 76 ] 27 0.004% 99.428% ( 76, 110 ] 83 0.011% 99.440% ( 110, 170 ] 281 0.038% 99.478% ( 170, 250 ] 424 0.058% 99.536% ( 250, 380 ] 647 0.089% 99.625% ( 380, 580 ] 954 0.131% 99.755% ( 580, 870 ] 1058 0.145% 99.900% ( 870, 1300 ] 712 0.097% 99.997% ( 1300, 1900 ] 347 0.047% 100.045% ( 1900, 2900 ] 254 0.035% 100.079% ( 2900, 4400 ] 276 0.038% 100.117% ( 4400, 6600 ] 70 0.010% 100.127% ( 6600, 9900 ] 16 0.002% 100.129% ** Level 4 read latency histogram (micros): Count: 110722 Average: 10.6738 StdDev: 118.42 Min: 0 Median: 1.9746 Max: 7562 Percentiles: P50: 1.97 P75: 3.00 P99: 13.02 P99.9: 1502.22 P99.99: 3191.99 ------------------------------------------------------ [ 0, 1 ] 978 0.883% 0.883% ( 1, 2 ] 55801 50.397% 51.281% ########## ( 2, 3 ] 26299 23.752% 75.033% ##### ( 3, 4 ] 12767 11.531% 86.564% ## ( 4, 6 ] 11437 10.329% 96.893% ## ( 6, 10 ] 2161 1.952% 98.845% ( 10, 15 ] 284 0.256% 99.101% ( 15, 22 ] 31 0.028% 99.129% ( 22, 34 ] 8 0.007% 99.137% ( 34, 51 ] 4 0.004% 99.140% ( 51, 76 ] 15 0.014% 99.154% ( 76, 110 ] 21 0.019% 99.173% ( 110, 170 ] 56 0.051% 99.223% ( 170, 250 ] 112 0.101% 99.324% ( 250, 380 ] 123 0.111% 99.436% ( 380, 580 ] 166 0.150% 99.585% ( 580, 870 ] 184 0.166% 99.752% ( 870, 1300 ] 139 0.126% 99.877% ( 1300, 1900 ] 75 0.068% 99.945% ( 1900, 2900 ] 40 0.036% 99.981% ( 2900, 4400 ] 51 0.046% 100.027% ( 4400, 6600 ] 6 0.005% 100.033% ( 6600, 9900 ] 1 0.001% 100.033% ** Level 5 read latency histogram (micros): Count: 300 Average: 1145.6500 StdDev: 1221.53 Min: 77 Median: 639.3182 Max: 5603 Percentiles: P50: 639.32 P75: 1785.71 P99: 5500.00 P99.9: 5603.00 P99.99: 5603.00 ------------------------------------------------------ ( 76, 110 ] 33 11.000% 11.000% ## ( 110, 170 ] 35 11.667% 22.667% ## ( 170, 250 ] 18 6.000% 28.667% # ( 250, 380 ] 22 7.333% 36.000% # ( 380, 580 ] 33 11.000% 47.000% ## ( 580, 870 ] 44 14.667% 61.667% ### ( 870, 1300 ] 23 7.667% 69.333% ## ( 1300, 1900 ] 21 7.000% 76.333% # ( 1900, 2900 ] 34 11.333% 87.667% ## ( 2900, 4400 ] 31 10.333% 98.000% ## ( 4400, 6600 ] 6 2.000% 100.000% ** DB Stats ** Uptime(secs): 52.0 total, 7.3 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 189.11 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:25.047 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, 134.61 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:4.510 H:M:S, 61.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.624 micros/op 177815 ops/sec 60.006 seconds 10669999 operations; 172.3 MB/s Microseconds per write: Count: 10669999 Average: 5.6238 StdDev: 366.67 Min: 0 Median: 1.7374 Max: 729894 Percentiles: P50: 1.74 P75: 2.74 P99: 8.52 P99.9: 1128.37 P99.99: 2658.19 ------------------------------------------------------ [ 0, 1 ] 1428214 13.385% 13.385% ### ( 1, 2 ] 5298183 49.655% 63.040% ########## ( 2, 3 ] 1721500 16.134% 79.174% ### ( 3, 4 ] 1474204 13.816% 92.991% ### ( 4, 6 ] 580397 5.440% 98.430% # ( 6, 10 ] 96378 0.903% 99.333% ( 10, 15 ] 29317 0.275% 99.608% ( 15, 22 ] 8468 0.079% 99.688% ( 22, 34 ] 1621 0.015% 99.703% ( 34, 51 ] 174 0.002% 99.704% ( 51, 76 ] 22 0.000% 99.705% ( 76, 110 ] 7383 0.069% 99.774% ( 110, 170 ] 3023 0.028% 99.802% ( 170, 250 ] 282 0.003% 99.805% ( 250, 380 ] 130 0.001% 99.806% ( 380, 580 ] 19 0.000% 99.806% ( 580, 870 ] 15 0.000% 99.806% ( 870, 1300 ] 16641 0.156% 99.962% ( 1300, 1900 ] 67 0.001% 99.963% ( 1900, 2900 ] 3817 0.036% 99.999% ( 2900, 4400 ] 89 0.001% 99.999% ( 4400, 6600 ] 22 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 17 0.000% 100.000% ( 250000, 380000 ] 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 : 209204 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 : 10669999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11011438968 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 : 549 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31080046 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 : 33638631869 rocksdb.compact.write.bytes COUNT : 33434886940 rocksdb.flush.write.bytes COUNT : 10965568553 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 68 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 246 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 : 10877174784 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4238336 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 : 33744774089 rocksdb.non.last.level.read.count COUNT : 8153666 rocksdb.block.checksum.compute.count COUNT : 8152636 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.386949 P95 : 3.875746 P99 : 6.844282 P100 : 729892.000000 COUNT : 10669999 SUM : 55125185 rocksdb.compaction.times.micros P50 : 1091025.641026 P95 : 4850000.000000 P99 : 16302114.000000 P100 : 16302114.000000 COUNT : 85 SUM : 136164579 rocksdb.compaction.times.cpu_micros P50 : 922195.121951 P95 : 4850000.000000 P99 : 15208016.000000 P100 : 15208016.000000 COUNT : 85 SUM : 114248513 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 : 685.454545 P95 : 1249.181818 P99 : 126200.000000 P100 : 147691.000000 COUNT : 146 SUM : 514612 rocksdb.compaction.outfile.sync.micros P50 : 1073.831169 P95 : 110642.857143 P99 : 178600.000000 P100 : 187210.000000 COUNT : 357 SUM : 6534128 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 : 100.933333 P95 : 1456.000000 P99 : 3290.000000 P100 : 7153.000000 COUNT : 274 SUM : 79731 rocksdb.table.open.io.micros P50 : 1501.176471 P95 : 7572.931034 P99 : 10931.833333 P100 : 15523.000000 COUNT : 549 SUM : 1182509 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.640243 P95 : 7.501383 P99 : 10.806194 P100 : 11544.000000 COUNT : 8151231 SUM : 48822482 rocksdb.read.block.get.micros P50 : 484.672897 P95 : 3464.843750 P99 : 4989.600000 P100 : 5907.000000 COUNT : 1098 SUM : 959898 rocksdb.write.raw.block.micros P50 : 0.512256 P95 : 0.973287 P99 : 2.836107 P100 : 12911.000000 COUNT : 10755574 SUM : 20103977 rocksdb.numfiles.in.singlecompaction P50 : 3.250000 P95 : 5.450000 P99 : 20.145000 P100 : 23.000000 COUNT : 153 SUM : 570 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.556322 P95 : 1138.861703 P99 : 2398.921543 P100 : 729701.000000 COUNT : 204861 SUM : 31094316 rocksdb.sst.read.micros P50 : 1.595861 P95 : 4.447827 P99 : 8.497200 P100 : 10482.000000 COUNT : 8154102 SUM : 32386789 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 : 10669999 SUM : 11011438968 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 : 212666.666667 P95 : 358550.000000 P99 : 540866.666667 P100 : 895177.000000 COUNT : 146 SUM : 31250776 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 : 344 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