[2024-12-05 13:48:05.281684] Starting SPDK v25.01-pre git sha1 8d3947977 / DPDK 23.11.0 initialization... [2024-12-05 13:48:05.281948] [ 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_pid554924 ] Set seed to 1733402885275060 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-05 13:48:05.411257] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-05 13:48:05.432529] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-05 13:48:05.432574] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 554924' to capture a snapshot of events at runtime. [2024-12-05 13:48:05.432584] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-05 13:48:05.432611] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-05 13:48:05.432620] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid554924 for offline analysis/debug. [2024-12-05 13:48:05.433158] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Dec 5 13:48:09 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/05-13:48:12 ... thread 0: (1000000,1000000) ops and (356413.5,356413.5) ops/second in (2.805730,2.805730) 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 567.02 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 351.5 2.33 2.12 12 0.194 0 0 0.0 0.0 L2 3/2 251.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 L3 9/0 741.32 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.54 GB 1.0 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 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.5 98.2 311.0 3.85 3.59 14 0.275 383K 195 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.5 98.2 311.0 3.85 3.59 14 0.275 383K 195 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 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 351.5 2.33 2.12 12 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 396.90 MB/s write, 0.37 GB read, 125.34 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 426.31 MB/s write, 0.37 GB read, 134.63 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 100413 Average: 1.8736 StdDev: 16.95 Min: 0 Median: 1.2070 Max: 2924 Percentiles: P50: 1.21 P75: 1.66 P99: 3.96 P99.9: 9.87 P99.99: 292.44 ------------------------------------------------------ [ 0, 1 ] 38682 38.523% 38.523% ######## ( 1, 2 ] 55666 55.437% 93.960% ########### ( 2, 3 ] 3729 3.714% 97.674% # ( 3, 4 ] 1388 1.382% 99.056% ( 4, 6 ] 607 0.605% 99.660% ( 6, 10 ] 250 0.249% 99.909% ( 10, 15 ] 53 0.053% 99.962% ( 15, 22 ] 12 0.012% 99.974% ( 22, 34 ] 1 0.001% 99.975% ( 34, 51 ] 2 0.002% 99.977% ( 110, 170 ] 8 0.008% 99.985% ( 170, 250 ] 4 0.004% 99.989% ( 250, 380 ] 6 0.006% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 2 0.002% 100.001% ** Level 2 read latency histogram (micros): Count: 49178 Average: 2.1462 StdDev: 25.07 Min: 0 Median: 1.2577 Max: 3332 Percentiles: P50: 1.26 P75: 1.69 P99: 5.01 P99.9: 9.86 P99.99: 1221.07 ------------------------------------------------------ [ 0, 1 ] 17318 35.215% 35.215% ####### ( 1, 2 ] 28221 57.385% 92.600% ########### ( 2, 3 ] 2036 4.140% 96.740% # ( 3, 4 ] 858 1.745% 98.485% ( 4, 6 ] 502 1.021% 99.506% ( 6, 10 ] 202 0.411% 99.917% ( 10, 15 ] 20 0.041% 99.957% ( 15, 22 ] 4 0.008% 99.965% ( 22, 34 ] 2 0.004% 99.969% ( 110, 170 ] 1 0.002% 99.972% ( 250, 380 ] 4 0.008% 99.980% ( 580, 870 ] 2 0.004% 99.984% ( 870, 1300 ] 5 0.010% 99.994% ( 1300, 1900 ] 2 0.004% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ( 2900, 4400 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1511.0000 StdDev: 1335.65 Min: 66 Median: 1020.5000 Max: 5074 Percentiles: P50: 1020.50 P75: 2431.25 P99: 5074.00 P99.9: 5074.00 P99.99: 5074.00 ------------------------------------------------------ ( 51, 76 ] 1 1.818% 1.818% ( 110, 170 ] 5 9.091% 10.909% ## ( 170, 250 ] 2 3.636% 14.545% # ( 250, 380 ] 6 10.909% 25.455% ## ( 380, 580 ] 1 1.818% 27.273% ( 580, 870 ] 9 16.364% 43.636% ### ( 870, 1300 ] 10 18.182% 61.818% #### ( 1300, 1900 ] 3 5.455% 67.273% # ( 1900, 2900 ] 8 14.545% 81.818% ### ( 2900, 4400 ] 8 14.545% 96.364% ### ( 4400, 6600 ] 2 3.636% 100.000% # ** Level 4 read latency histogram (micros): Count: 15 Average: 1914.4667 StdDev: 1669.25 Min: 174 Median: 1192.5000 Max: 5124 Percentiles: P50: 1192.50 P75: 3368.75 P99: 5124.00 P99.9: 5124.00 P99.99: 5124.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 1 6.667% 20.000% # ( 380, 580 ] 1 6.667% 26.667% # ( 580, 870 ] 2 13.333% 40.000% ### ( 870, 1300 ] 2 13.333% 53.333% ### ( 1300, 1900 ] 1 6.667% 60.000% # ( 1900, 2900 ] 1 6.667% 66.667% # ( 2900, 4400 ] 4 26.667% 93.333% ##### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 506.1500 StdDev: 701.72 Min: 74 Median: 130.0000 Max: 2822 Percentiles: P50: 130.00 P75: 580.00 P99: 2700.00 P99.9: 2822.00 P99.99: 2822.00 ------------------------------------------------------ ( 51, 76 ] 2 10.000% 10.000% ## ( 76, 110 ] 7 35.000% 45.000% ####### ( 110, 170 ] 3 15.000% 60.000% ### ( 250, 380 ] 1 5.000% 65.000% # ( 380, 580 ] 2 10.000% 75.000% ## ( 870, 1300 ] 3 15.000% 90.000% ### ( 1300, 1900 ] 1 5.000% 95.000% # ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 326.40 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.216 H:M:S, 7.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.50 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.216 H:M:S, 7.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-13:48:15 ... thread 0: (1000000,2000000) ops and (326416.5,340756.1) ops/second in (3.063571,5.869301) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/7 1.17 GB 6.3 0.8 0.0 0.8 2.6 1.8 0.0 1.4 98.1 316.7 8.35 7.76 29 0.288 831K 850 0.0 0.0 L1 1/1 2.87 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.8 238.4 1.58 1.54 1 1.583 383K 596 0.0 0.0 L2 2/0 54.76 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 L3 42/0 997.78 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 202.4 202.2 3.93 3.50 3 1.311 808K 836 0.0 0.0 L4 144/0 9.53 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 1048/0 86.19 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/8 97.92 GB 0.0 2.3 1.1 1.2 4.1 2.9 2.1 2.3 154.1 272.7 15.39 14.26 35 0.440 2407K 2477 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 1.1 1.2 4.1 2.9 2.1 2.3 154.1 272.7 15.39 14.26 35 0.440 2407K 2477 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.3 1.1 1.2 2.3 1.1 0.0 0.0 231.6 231.3 10.24 9.64 9 1.138 2407K 2477 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 354.9 5.15 4.62 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.10 GB write, 690.21 MB/s write, 2.32 GB read, 390.09 MB/s read, 15.4 seconds Interval compaction: 4.10 GB write, 714.66 MB/s write, 2.32 GB read, 403.91 MB/s read, 15.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 382948 Average: 2.2190 StdDev: 15.37 Min: 0 Median: 1.4703 Max: 3399 Percentiles: P50: 1.47 P75: 1.87 P99: 5.74 P99.9: 11.42 P99.99: 17.45 ------------------------------------------------------ [ 0, 1 ] 79340 20.718% 20.718% #### ( 1, 2 ] 238443 62.265% 82.983% ############ ( 2, 3 ] 37675 9.838% 92.821% ## ( 3, 4 ] 14864 3.881% 96.703% # ( 4, 6 ] 10086 2.634% 99.337% # ( 6, 10 ] 2030 0.530% 99.867% ( 10, 15 ] 451 0.118% 99.985% ( 15, 22 ] 62 0.016% 100.001% ( 22, 34 ] 3 0.001% 100.002% ( 34, 51 ] 8 0.002% 100.004% ( 51, 76 ] 3 0.001% 100.004% ( 110, 170 ] 16 0.004% 100.009% ( 170, 250 ] 7 0.002% 100.010% ( 250, 380 ] 9 0.002% 100.013% ( 380, 580 ] 6 0.002% 100.014% ( 580, 870 ] 5 0.001% 100.016% ( 870, 1300 ] 4 0.001% 100.017% ( 1300, 1900 ] 2 0.001% 100.017% ( 1900, 2900 ] 4 0.001% 100.018% ( 2900, 4400 ] 5 0.001% 100.020% ** Level 1 read latency histogram (micros): Count: 81680 Average: 2.5125 StdDev: 8.00 Min: 1 Median: 1.6761 Max: 1992 Percentiles: P50: 1.68 P75: 2.25 P99: 6.41 P99.9: 12.77 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 5553 6.798% 6.798% # ( 1, 2 ] 52191 63.897% 70.695% ############# ( 2, 3 ] 14264 17.463% 88.159% ### ( 3, 4 ] 4857 5.946% 94.105% # ( 4, 6 ] 3925 4.805% 98.910% # ( 6, 10 ] 717 0.878% 99.788% ( 10, 15 ] 165 0.202% 99.990% ( 15, 22 ] 14 0.017% 100.007% ( 22, 34 ] 2 0.002% 100.010% ( 51, 76 ] 2 0.002% 100.012% ( 110, 170 ] 1 0.001% 100.013% ( 170, 250 ] 1 0.001% 100.015% ( 250, 380 ] 2 0.002% 100.017% ( 380, 580 ] 2 0.002% 100.020% ( 580, 870 ] 1 0.001% 100.021% ( 1900, 2900 ] 1 0.001% 100.022% ** Level 2 read latency histogram (micros): Count: 95403 Average: 2.1681 StdDev: 18.02 Min: 0 Median: 1.4077 Max: 3332 Percentiles: P50: 1.41 P75: 1.81 P99: 5.49 P99.9: 9.87 P99.99: 791.66 ------------------------------------------------------ [ 0, 1 ] 23268 24.389% 24.389% ##### ( 1, 2 ] 59932 62.820% 87.209% ############# ( 2, 3 ] 7047 7.387% 94.596% # ( 3, 4 ] 2877 3.016% 97.611% # ( 4, 6 ] 1773 1.858% 99.470% ( 6, 10 ] 424 0.444% 99.914% ( 10, 15 ] 57 0.060% 99.974% ( 15, 22 ] 7 0.007% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 110, 170 ] 1 0.001% 99.984% ( 250, 380 ] 4 0.004% 99.988% ( 580, 870 ] 2 0.002% 99.991% ( 870, 1300 ] 5 0.005% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57445 Average: 4.0336 StdDev: 63.09 Min: 0 Median: 1.6807 Max: 5074 Percentiles: P50: 1.68 P75: 2.27 P99: 7.29 P99.9: 176.34 P99.99: 2947.91 ------------------------------------------------------ [ 0, 1 ] 4000 6.963% 6.963% # ( 1, 2 ] 36319 63.224% 70.187% ############# ( 2, 3 ] 10189 17.737% 87.924% #### ( 3, 4 ] 3451 6.007% 93.932% # ( 4, 6 ] 2752 4.791% 98.722% # ( 6, 10 ] 494 0.860% 99.582% ( 10, 15 ] 124 0.216% 99.798% ( 15, 22 ] 22 0.038% 99.836% ( 22, 34 ] 20 0.035% 99.871% ( 34, 51 ] 7 0.012% 99.883% ( 51, 76 ] 2 0.003% 99.887% ( 110, 170 ] 7 0.012% 99.899% ( 170, 250 ] 7 0.012% 99.911% ( 250, 380 ] 8 0.014% 99.925% ( 380, 580 ] 4 0.007% 99.932% ( 580, 870 ] 11 0.019% 99.951% ( 870, 1300 ] 10 0.017% 99.969% ( 1300, 1900 ] 4 0.007% 99.976% ( 1900, 2900 ] 8 0.014% 99.990% ( 2900, 4400 ] 8 0.014% 100.003% ( 4400, 6600 ] 2 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 15 Average: 1914.4667 StdDev: 1669.25 Min: 174 Median: 1192.5000 Max: 5124 Percentiles: P50: 1192.50 P75: 3368.75 P99: 5124.00 P99.9: 5124.00 P99.99: 5124.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 1 6.667% 20.000% # ( 380, 580 ] 1 6.667% 26.667% # ( 580, 870 ] 2 13.333% 40.000% ### ( 870, 1300 ] 2 13.333% 53.333% ### ( 1300, 1900 ] 1 6.667% 60.000% # ( 1900, 2900 ] 1 6.667% 66.667% # ( 2900, 4400 ] 4 26.667% 93.333% ##### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 586.2500 StdDev: 777.00 Min: 74 Median: 153.6364 Max: 2875 Percentiles: P50: 153.64 P75: 870.00 P99: 2820.00 P99.9: 2875.00 P99.99: 2875.00 ------------------------------------------------------ ( 51, 76 ] 2 5.000% 5.000% # ( 76, 110 ] 10 25.000% 30.000% ##### ( 110, 170 ] 11 27.500% 57.500% ###### ( 170, 250 ] 1 2.500% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 4 10.000% 85.000% ## ( 1300, 1900 ] 1 2.500% 87.500% # ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 323.81 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.589 H:M:S, 9.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.25 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.373 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-13:48:18 ... thread 0: (1000000,3000000) ops and (327763.1,336312.1) ops/second in (3.050984,8.920285) 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 75.5 1.3 0.0 1.3 4.1 2.8 0.0 1.5 101.3 318.2 13.06 12.14 45 0.290 1343K 1385 0.0 0.0 L1 1/1 2.87 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.8 238.4 1.58 1.54 1 1.583 383K 596 0.0 0.0 L2 2/0 54.76 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 L3 42/0 997.78 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 202.4 202.2 3.93 3.50 3 1.311 808K 836 0.0 0.0 L4 144/0 9.53 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 1048/0 86.19 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 1253/12 98.90 GB 0.0 2.8 1.1 1.7 5.6 3.9 2.1 2.0 143.1 283.9 20.10 18.64 51 0.394 2919K 3012 0.0 0.0 Int 0/0 0.00 KB 0.0 2.8 1.1 1.7 5.6 3.9 2.1 2.0 143.1 283.9 20.10 18.64 51 0.394 2919K 3012 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.8 1.1 1.7 2.8 1.1 0.0 0.0 237.2 237.0 12.12 11.49 11 1.102 2919K 3012 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 355.3 7.98 7.16 40 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): 9.1 total, 8.9 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.57 GB write, 625.09 MB/s write, 2.81 GB read, 314.93 MB/s read, 20.1 seconds Interval compaction: 5.57 GB write, 639.67 MB/s write, 2.81 GB read, 322.27 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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 728582 Average: 2.1579 StdDev: 13.24 Min: 0 Median: 1.4655 Max: 3998 Percentiles: P50: 1.47 P75: 1.85 P99: 5.55 P99.9: 10.26 P99.99: 14.65 ------------------------------------------------------ [ 0, 1 ] 143483 19.693% 19.693% #### ( 1, 2 ] 474299 65.099% 84.792% ############# ( 2, 3 ] 67918 9.322% 94.114% ## ( 3, 4 ] 24263 3.330% 97.444% # ( 4, 6 ] 14655 2.011% 99.456% ( 6, 10 ] 3197 0.439% 99.895% ( 10, 15 ] 747 0.103% 99.997% ( 15, 22 ] 85 0.012% 100.009% ( 22, 34 ] 7 0.001% 100.010% ( 34, 51 ] 12 0.002% 100.012% ( 51, 76 ] 4 0.001% 100.012% ( 110, 170 ] 20 0.003% 100.015% ( 170, 250 ] 14 0.002% 100.017% ( 250, 380 ] 15 0.002% 100.019% ( 380, 580 ] 10 0.001% 100.020% ( 580, 870 ] 10 0.001% 100.022% ( 870, 1300 ] 6 0.001% 100.022% ( 1300, 1900 ] 3 0.000% 100.023% ( 1900, 2900 ] 5 0.001% 100.023% ( 2900, 4400 ] 7 0.001% 100.024% ** Level 1 read latency histogram (micros): Count: 81680 Average: 2.5125 StdDev: 8.00 Min: 1 Median: 1.6761 Max: 1992 Percentiles: P50: 1.68 P75: 2.25 P99: 6.41 P99.9: 12.77 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 5553 6.798% 6.798% # ( 1, 2 ] 52191 63.897% 70.695% ############# ( 2, 3 ] 14264 17.463% 88.159% ### ( 3, 4 ] 4857 5.946% 94.105% # ( 4, 6 ] 3925 4.805% 98.910% # ( 6, 10 ] 717 0.878% 99.788% ( 10, 15 ] 165 0.202% 99.990% ( 15, 22 ] 14 0.017% 100.007% ( 22, 34 ] 2 0.002% 100.010% ( 51, 76 ] 2 0.002% 100.012% ( 110, 170 ] 1 0.001% 100.013% ( 170, 250 ] 1 0.001% 100.015% ( 250, 380 ] 2 0.002% 100.017% ( 380, 580 ] 2 0.002% 100.020% ( 580, 870 ] 1 0.001% 100.021% ( 1900, 2900 ] 1 0.001% 100.022% ** Level 2 read latency histogram (micros): Count: 95403 Average: 2.1681 StdDev: 18.02 Min: 0 Median: 1.4077 Max: 3332 Percentiles: P50: 1.41 P75: 1.81 P99: 5.49 P99.9: 9.87 P99.99: 791.66 ------------------------------------------------------ [ 0, 1 ] 23268 24.389% 24.389% ##### ( 1, 2 ] 59932 62.820% 87.209% ############# ( 2, 3 ] 7047 7.387% 94.596% # ( 3, 4 ] 2877 3.016% 97.611% # ( 4, 6 ] 1773 1.858% 99.470% ( 6, 10 ] 424 0.444% 99.914% ( 10, 15 ] 57 0.060% 99.974% ( 15, 22 ] 7 0.007% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 110, 170 ] 1 0.001% 99.984% ( 250, 380 ] 4 0.004% 99.988% ( 580, 870 ] 2 0.002% 99.991% ( 870, 1300 ] 5 0.005% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57445 Average: 4.0336 StdDev: 63.09 Min: 0 Median: 1.6807 Max: 5074 Percentiles: P50: 1.68 P75: 2.27 P99: 7.29 P99.9: 176.34 P99.99: 2947.91 ------------------------------------------------------ [ 0, 1 ] 4000 6.963% 6.963% # ( 1, 2 ] 36319 63.224% 70.187% ############# ( 2, 3 ] 10189 17.737% 87.924% #### ( 3, 4 ] 3451 6.007% 93.932% # ( 4, 6 ] 2752 4.791% 98.722% # ( 6, 10 ] 494 0.860% 99.582% ( 10, 15 ] 124 0.216% 99.798% ( 15, 22 ] 22 0.038% 99.836% ( 22, 34 ] 20 0.035% 99.871% ( 34, 51 ] 7 0.012% 99.883% ( 51, 76 ] 2 0.003% 99.887% ( 110, 170 ] 7 0.012% 99.899% ( 170, 250 ] 7 0.012% 99.911% ( 250, 380 ] 8 0.014% 99.925% ( 380, 580 ] 4 0.007% 99.932% ( 580, 870 ] 11 0.019% 99.951% ( 870, 1300 ] 10 0.017% 99.969% ( 1300, 1900 ] 4 0.007% 99.976% ( 1900, 2900 ] 8 0.014% 99.990% ( 2900, 4400 ] 8 0.014% 100.003% ( 4400, 6600 ] 2 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 15 Average: 1914.4667 StdDev: 1669.25 Min: 174 Median: 1192.5000 Max: 5124 Percentiles: P50: 1192.50 P75: 3368.75 P99: 5124.00 P99.9: 5124.00 P99.99: 5124.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 1 6.667% 20.000% # ( 380, 580 ] 1 6.667% 26.667% # ( 580, 870 ] 2 13.333% 40.000% ### ( 870, 1300 ] 2 13.333% 53.333% ### ( 1300, 1900 ] 1 6.667% 60.000% # ( 1900, 2900 ] 1 6.667% 66.667% # ( 2900, 4400 ] 4 26.667% 93.333% ##### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 586.2500 StdDev: 777.00 Min: 74 Median: 153.6364 Max: 2875 Percentiles: P50: 153.64 P75: 870.00 P99: 2820.00 P99.9: 2875.00 P99.99: 2875.00 ------------------------------------------------------ ( 51, 76 ] 2 5.000% 5.000% # ( 76, 110 ] 10 25.000% 30.000% ##### ( 110, 170 ] 11 27.500% 57.500% ###### ( 170, 250 ] 1 2.500% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 4 10.000% 85.000% ## ( 1300, 1900 ] 1 2.500% 87.500% # ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 323.40 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.993 H:M:S, 10.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.59 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.404 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/05-13:48:21 ... thread 0: (1000000,4000000) ops and (325436.3,333525.6) ops/second in (3.072798,11.993083) 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/4 2.03 GB 176.2 2.4 0.0 2.4 6.1 3.7 0.0 1.6 121.6 311.6 20.21 18.88 63 0.321 2494K 2637 0.0 0.0 L1 10/0 1.10 GB 113.0 1.5 1.5 0.0 1.5 1.5 0.2 1.0 236.3 235.3 6.41 6.24 2 3.204 1537K 5903 0.0 0.0 L2 2/0 54.76 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 L3 42/0 997.78 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 202.4 202.2 3.93 3.50 3 1.311 808K 836 0.0 0.0 L4 144/0 9.53 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 1048/0 86.19 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/4 99.88 GB 0.0 5.0 2.2 2.8 8.8 6.0 2.1 2.3 160.4 280.0 32.07 30.09 70 0.458 5224K 9571 0.0 0.0 Int 0/0 0.00 KB 0.0 5.0 2.2 2.8 8.8 6.0 2.1 2.3 160.4 280.0 32.07 30.09 70 0.458 5224K 9571 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.0 2.2 2.8 5.0 2.2 0.0 0.0 241.9 241.5 21.27 20.43 16 1.329 5224K 9571 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 355.8 10.80 9.66 54 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): 12.2 total, 12.0 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.77 GB write, 735.75 MB/s write, 5.02 GB read, 421.64 MB/s read, 32.1 seconds Interval compaction: 8.77 GB write, 748.51 MB/s write, 5.02 GB read, 428.96 MB/s read, 32.1 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 14, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1073085 Average: 2.1523 StdDev: 11.66 Min: 0 Median: 1.4666 Max: 3998 Percentiles: P50: 1.47 P75: 1.85 P99: 5.50 P99.9: 9.98 P99.99: 14.52 ------------------------------------------------------ [ 0, 1 ] 209767 19.548% 19.548% #### ( 1, 2 ] 700402 65.270% 84.818% ############# ( 2, 3 ] 101483 9.457% 94.275% ## ( 3, 4 ] 35130 3.274% 97.549% # ( 4, 6 ] 20756 1.934% 99.483% ( 6, 10 ] 4499 0.419% 99.902% ( 10, 15 ] 1042 0.097% 99.999% ( 15, 22 ] 122 0.011% 100.011% ( 22, 34 ] 14 0.001% 100.012% ( 34, 51 ] 15 0.001% 100.014% ( 51, 76 ] 8 0.001% 100.014% ( 76, 110 ] 4 0.000% 100.015% ( 110, 170 ] 51 0.005% 100.019% ( 170, 250 ] 34 0.003% 100.023% ( 250, 380 ] 26 0.002% 100.025% ( 380, 580 ] 18 0.002% 100.027% ( 580, 870 ] 16 0.001% 100.028% ( 870, 1300 ] 13 0.001% 100.029% ( 1300, 1900 ] 3 0.000% 100.030% ( 1900, 2900 ] 6 0.001% 100.030% ( 2900, 4400 ] 7 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 82457 Average: 2.6694 StdDev: 14.98 Min: 1 Median: 1.6743 Max: 1992 Percentiles: P50: 1.67 P75: 2.24 P99: 6.49 P99.9: 13.35 P99.99: 162.63 ------------------------------------------------------ [ 0, 1 ] 5689 6.899% 6.899% # ( 1, 2 ] 52709 63.923% 70.822% ############# ( 2, 3 ] 14337 17.387% 88.210% ### ( 3, 4 ] 4877 5.915% 94.124% # ( 4, 6 ] 3933 4.770% 98.894% # ( 6, 10 ] 719 0.872% 99.766% ( 10, 15 ] 165 0.200% 99.966% ( 15, 22 ] 14 0.017% 99.983% ( 22, 34 ] 2 0.002% 99.985% ( 51, 76 ] 2 0.002% 99.988% ( 110, 170 ] 2 0.002% 99.990% ( 170, 250 ] 3 0.004% 99.994% ( 250, 380 ] 7 0.008% 100.002% ( 380, 580 ] 6 0.007% 100.010% ( 580, 870 ] 3 0.004% 100.013% ( 870, 1300 ] 3 0.004% 100.017% ( 1300, 1900 ] 3 0.004% 100.021% ( 1900, 2900 ] 1 0.001% 100.022% ** Level 2 read latency histogram (micros): Count: 95403 Average: 2.1681 StdDev: 18.02 Min: 0 Median: 1.4077 Max: 3332 Percentiles: P50: 1.41 P75: 1.81 P99: 5.49 P99.9: 9.87 P99.99: 791.66 ------------------------------------------------------ [ 0, 1 ] 23268 24.389% 24.389% ##### ( 1, 2 ] 59932 62.820% 87.209% ############# ( 2, 3 ] 7047 7.387% 94.596% # ( 3, 4 ] 2877 3.016% 97.611% # ( 4, 6 ] 1773 1.858% 99.470% ( 6, 10 ] 424 0.444% 99.914% ( 10, 15 ] 57 0.060% 99.974% ( 15, 22 ] 7 0.007% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 110, 170 ] 1 0.001% 99.984% ( 250, 380 ] 4 0.004% 99.988% ( 580, 870 ] 2 0.002% 99.991% ( 870, 1300 ] 5 0.005% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57445 Average: 4.0336 StdDev: 63.09 Min: 0 Median: 1.6807 Max: 5074 Percentiles: P50: 1.68 P75: 2.27 P99: 7.29 P99.9: 176.34 P99.99: 2947.91 ------------------------------------------------------ [ 0, 1 ] 4000 6.963% 6.963% # ( 1, 2 ] 36319 63.224% 70.187% ############# ( 2, 3 ] 10189 17.737% 87.924% #### ( 3, 4 ] 3451 6.007% 93.932% # ( 4, 6 ] 2752 4.791% 98.722% # ( 6, 10 ] 494 0.860% 99.582% ( 10, 15 ] 124 0.216% 99.798% ( 15, 22 ] 22 0.038% 99.836% ( 22, 34 ] 20 0.035% 99.871% ( 34, 51 ] 7 0.012% 99.883% ( 51, 76 ] 2 0.003% 99.887% ( 110, 170 ] 7 0.012% 99.899% ( 170, 250 ] 7 0.012% 99.911% ( 250, 380 ] 8 0.014% 99.925% ( 380, 580 ] 4 0.007% 99.932% ( 580, 870 ] 11 0.019% 99.951% ( 870, 1300 ] 10 0.017% 99.969% ( 1300, 1900 ] 4 0.007% 99.976% ( 1900, 2900 ] 8 0.014% 99.990% ( 2900, 4400 ] 8 0.014% 100.003% ( 4400, 6600 ] 2 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 15 Average: 1914.4667 StdDev: 1669.25 Min: 174 Median: 1192.5000 Max: 5124 Percentiles: P50: 1192.50 P75: 3368.75 P99: 5124.00 P99.9: 5124.00 P99.99: 5124.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 1 6.667% 20.000% # ( 380, 580 ] 1 6.667% 26.667% # ( 580, 870 ] 2 13.333% 40.000% ### ( 870, 1300 ] 2 13.333% 53.333% ### ( 1300, 1900 ] 1 6.667% 60.000% # ( 1900, 2900 ] 1 6.667% 66.667% # ( 2900, 4400 ] 4 26.667% 93.333% ##### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 586.2500 StdDev: 777.00 Min: 74 Median: 153.6364 Max: 2875 Percentiles: P50: 153.64 P75: 870.00 P99: 2820.00 P99.9: 2875.00 P99.99: 2875.00 ------------------------------------------------------ ( 51, 76 ] 2 5.000% 5.000% # ( 76, 110 ] 10 25.000% 30.000% ##### ( 110, 170 ] 11 27.500% 57.500% ###### ( 170, 250 ] 1 2.500% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 4 10.000% 85.000% ## ( 1300, 1900 ] 1 2.500% 87.500% # ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 12.2 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.62 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.419 H:M:S, 11.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.29 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.426 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-13:48:24 ... thread 0: (1000000,5000000) ops and (357443.7,338049.7) ops/second in (2.797643,14.790726) 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/8 2.95 GB 245.4 3.0 0.0 3.0 7.6 4.7 0.0 1.6 121.5 313.8 24.88 23.26 79 0.315 3070K 3268 0.0 0.0 L1 10/0 1.10 GB 113.0 1.5 1.5 0.0 1.5 1.5 0.2 1.0 236.3 235.3 6.41 6.24 2 3.204 1537K 5903 0.0 0.0 L2 2/0 54.76 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 L3 42/0 997.78 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 202.4 202.2 3.93 3.50 3 1.311 808K 836 0.0 0.0 L4 144/0 9.53 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 1048/0 86.19 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 1265/8 100.80 GB 0.0 5.6 2.2 3.4 10.2 6.9 2.1 2.2 155.5 285.5 36.74 34.47 86 0.427 5799K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.2 3.4 10.2 6.9 2.1 2.2 155.5 285.5 36.74 34.47 86 0.427 5799K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 2.2 3.4 5.6 2.2 0.0 0.0 244.4 243.9 23.37 22.50 18 1.299 5799K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 358.1 13.37 11.97 68 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.0 total, 14.8 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.24 GB write, 699.28 MB/s write, 5.58 GB read, 380.80 MB/s read, 36.7 seconds Interval compaction: 10.24 GB write, 709.11 MB/s write, 5.58 GB read, 386.16 MB/s read, 36.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: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 18, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1320796 Average: 2.1105 StdDev: 11.62 Min: 0 Median: 1.4425 Max: 3998 Percentiles: P50: 1.44 P75: 1.83 P99: 5.40 P99.9: 9.94 P99.99: 14.58 ------------------------------------------------------ [ 0, 1 ] 282605 21.397% 21.397% #### ( 1, 2 ] 853730 64.638% 86.034% ############# ( 2, 3 ] 115128 8.717% 94.751% ## ( 3, 4 ] 40079 3.034% 97.785% # ( 4, 6 ] 22899 1.734% 99.519% ( 6, 10 ] 5118 0.387% 99.906% ( 10, 15 ] 1208 0.091% 99.998% ( 15, 22 ] 139 0.011% 100.008% ( 22, 34 ] 16 0.001% 100.010% ( 34, 51 ] 20 0.002% 100.011% ( 51, 76 ] 9 0.001% 100.012% ( 76, 110 ] 4 0.000% 100.012% ( 110, 170 ] 60 0.005% 100.017% ( 170, 250 ] 37 0.003% 100.019% ( 250, 380 ] 34 0.003% 100.022% ( 380, 580 ] 23 0.002% 100.024% ( 580, 870 ] 18 0.001% 100.025% ( 870, 1300 ] 14 0.001% 100.026% ( 1300, 1900 ] 4 0.000% 100.026% ( 1900, 2900 ] 8 0.001% 100.027% ( 2900, 4400 ] 8 0.001% 100.028% ** Level 1 read latency histogram (micros): Count: 82457 Average: 2.6694 StdDev: 14.98 Min: 1 Median: 1.6743 Max: 1992 Percentiles: P50: 1.67 P75: 2.24 P99: 6.49 P99.9: 13.35 P99.99: 162.63 ------------------------------------------------------ [ 0, 1 ] 5689 6.899% 6.899% # ( 1, 2 ] 52709 63.923% 70.822% ############# ( 2, 3 ] 14337 17.387% 88.210% ### ( 3, 4 ] 4877 5.915% 94.124% # ( 4, 6 ] 3933 4.770% 98.894% # ( 6, 10 ] 719 0.872% 99.766% ( 10, 15 ] 165 0.200% 99.966% ( 15, 22 ] 14 0.017% 99.983% ( 22, 34 ] 2 0.002% 99.985% ( 51, 76 ] 2 0.002% 99.988% ( 110, 170 ] 2 0.002% 99.990% ( 170, 250 ] 3 0.004% 99.994% ( 250, 380 ] 7 0.008% 100.002% ( 380, 580 ] 6 0.007% 100.010% ( 580, 870 ] 3 0.004% 100.013% ( 870, 1300 ] 3 0.004% 100.017% ( 1300, 1900 ] 3 0.004% 100.021% ( 1900, 2900 ] 1 0.001% 100.022% ** Level 2 read latency histogram (micros): Count: 95403 Average: 2.1681 StdDev: 18.02 Min: 0 Median: 1.4077 Max: 3332 Percentiles: P50: 1.41 P75: 1.81 P99: 5.49 P99.9: 9.87 P99.99: 791.66 ------------------------------------------------------ [ 0, 1 ] 23268 24.389% 24.389% ##### ( 1, 2 ] 59932 62.820% 87.209% ############# ( 2, 3 ] 7047 7.387% 94.596% # ( 3, 4 ] 2877 3.016% 97.611% # ( 4, 6 ] 1773 1.858% 99.470% ( 6, 10 ] 424 0.444% 99.914% ( 10, 15 ] 57 0.060% 99.974% ( 15, 22 ] 7 0.007% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 110, 170 ] 1 0.001% 99.984% ( 250, 380 ] 4 0.004% 99.988% ( 580, 870 ] 2 0.002% 99.991% ( 870, 1300 ] 5 0.005% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57445 Average: 4.0336 StdDev: 63.09 Min: 0 Median: 1.6807 Max: 5074 Percentiles: P50: 1.68 P75: 2.27 P99: 7.29 P99.9: 176.34 P99.99: 2947.91 ------------------------------------------------------ [ 0, 1 ] 4000 6.963% 6.963% # ( 1, 2 ] 36319 63.224% 70.187% ############# ( 2, 3 ] 10189 17.737% 87.924% #### ( 3, 4 ] 3451 6.007% 93.932% # ( 4, 6 ] 2752 4.791% 98.722% # ( 6, 10 ] 494 0.860% 99.582% ( 10, 15 ] 124 0.216% 99.798% ( 15, 22 ] 22 0.038% 99.836% ( 22, 34 ] 20 0.035% 99.871% ( 34, 51 ] 7 0.012% 99.883% ( 51, 76 ] 2 0.003% 99.887% ( 110, 170 ] 7 0.012% 99.899% ( 170, 250 ] 7 0.012% 99.911% ( 250, 380 ] 8 0.014% 99.925% ( 380, 580 ] 4 0.007% 99.932% ( 580, 870 ] 11 0.019% 99.951% ( 870, 1300 ] 10 0.017% 99.969% ( 1300, 1900 ] 4 0.007% 99.976% ( 1900, 2900 ] 8 0.014% 99.990% ( 2900, 4400 ] 8 0.014% 100.003% ( 4400, 6600 ] 2 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 15 Average: 1914.4667 StdDev: 1669.25 Min: 174 Median: 1192.5000 Max: 5124 Percentiles: P50: 1192.50 P75: 3368.75 P99: 5124.00 P99.9: 5124.00 P99.99: 5124.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 1 6.667% 20.000% # ( 380, 580 ] 1 6.667% 26.667% # ( 580, 870 ] 2 13.333% 40.000% ### ( 870, 1300 ] 2 13.333% 53.333% ### ( 1300, 1900 ] 1 6.667% 60.000% # ( 1900, 2900 ] 1 6.667% 66.667% # ( 2900, 4400 ] 4 26.667% 93.333% ##### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 586.2500 StdDev: 777.00 Min: 74 Median: 153.6364 Max: 2875 Percentiles: P50: 153.64 P75: 870.00 P99: 2820.00 P99.9: 2875.00 P99.99: 2875.00 ------------------------------------------------------ ( 51, 76 ] 2 5.000% 5.000% # ( 76, 110 ] 10 25.000% 30.000% ##### ( 110, 170 ] 11 27.500% 57.500% ###### ( 170, 250 ] 1 2.500% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 4 10.000% 85.000% ## ( 1300, 1900 ] 1 2.500% 87.500% # ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 15.0 total, 2.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 328.06 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.603 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, 351.79 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.183 H:M:S, 6.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-13:48:28 ... thread 0: (1000000,6000000) ops and (250161.2,319350.2) ops/second in (3.997423,18.788149) 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/16 3.93 GB 31.5 4.3 0.0 4.3 10.0 5.7 0.0 1.8 134.0 310.0 32.90 30.88 98 0.336 4477K 4716 0.0 0.0 L1 10/10 1.10 GB 0.0 1.5 1.5 0.0 1.5 1.5 0.2 1.0 236.3 235.3 6.41 6.24 2 3.204 1537K 5903 0.0 0.0 L2 2/0 54.76 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 L3 42/0 997.78 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 202.4 202.2 3.93 3.50 3 1.311 808K 836 0.0 0.0 L4 144/0 9.53 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 1048/0 86.19 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 1264/26 101.78 GB 0.0 6.9 2.2 4.7 12.6 7.9 2.1 2.2 158.6 287.8 44.76 42.09 105 0.426 7207K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 2.2 4.7 12.6 7.9 2.1 2.2 158.6 287.8 44.76 42.09 105 0.426 7207K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.9 2.2 4.7 6.9 2.2 0.0 0.0 248.1 247.7 28.61 27.62 23 1.244 7207K 11K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 358.8 16.15 14.47 82 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): 19.0 total, 18.8 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.58 GB write, 678.07 MB/s write, 6.93 GB read, 373.63 MB/s read, 44.8 seconds Interval compaction: 12.58 GB write, 685.57 MB/s write, 6.93 GB read, 377.77 MB/s read, 44.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 20, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1640287 Average: 2.1179 StdDev: 12.66 Min: 0 Median: 1.4280 Max: 3998 Percentiles: P50: 1.43 P75: 1.82 P99: 5.35 P99.9: 10.73 P99.99: 21.68 ------------------------------------------------------ [ 0, 1 ] 367761 22.421% 22.421% #### ( 1, 2 ] 1057069 64.444% 86.865% ############# ( 2, 3 ] 134462 8.197% 95.062% ## ( 3, 4 ] 47188 2.877% 97.939% # ( 4, 6 ] 25770 1.571% 99.510% ( 6, 10 ] 6174 0.376% 99.886% ( 10, 15 ] 1535 0.094% 99.980% ( 15, 22 ] 173 0.011% 99.991% ( 22, 34 ] 16 0.001% 99.992% ( 34, 51 ] 24 0.001% 99.993% ( 51, 76 ] 10 0.001% 99.994% ( 76, 110 ] 86 0.005% 99.999% ( 110, 170 ] 198 0.012% 100.011% ( 170, 250 ] 64 0.004% 100.015% ( 250, 380 ] 55 0.003% 100.018% ( 380, 580 ] 36 0.002% 100.020% ( 580, 870 ] 27 0.002% 100.022% ( 870, 1300 ] 19 0.001% 100.023% ( 1300, 1900 ] 7 0.000% 100.024% ( 1900, 2900 ] 11 0.001% 100.024% ( 2900, 4400 ] 12 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 104818 Average: 2.6326 StdDev: 14.08 Min: 1 Median: 1.6213 Max: 1992 Percentiles: P50: 1.62 P75: 2.05 P99: 7.01 P99.9: 14.71 P99.99: 269.74 ------------------------------------------------------ [ 0, 1 ] 10681 10.190% 10.190% ## ( 1, 2 ] 67161 64.074% 74.264% ############# ( 2, 3 ] 15872 15.142% 89.406% ### ( 3, 4 ] 5549 5.294% 94.700% # ( 4, 6 ] 4252 4.057% 98.757% # ( 6, 10 ] 1007 0.961% 99.718% ( 10, 15 ] 203 0.194% 99.911% ( 15, 22 ] 15 0.014% 99.926% ( 22, 34 ] 2 0.002% 99.927% ( 51, 76 ] 2 0.002% 99.929% ( 76, 110 ] 22 0.021% 99.950% ( 110, 170 ] 34 0.032% 99.983% ( 170, 250 ] 6 0.006% 99.989% ( 250, 380 ] 10 0.010% 99.998% ( 380, 580 ] 9 0.009% 100.007% ( 580, 870 ] 4 0.004% 100.010% ( 870, 1300 ] 3 0.003% 100.013% ( 1300, 1900 ] 3 0.003% 100.016% ( 1900, 2900 ] 1 0.001% 100.017% ** Level 2 read latency histogram (micros): Count: 95403 Average: 2.1681 StdDev: 18.02 Min: 0 Median: 1.4077 Max: 3332 Percentiles: P50: 1.41 P75: 1.81 P99: 5.49 P99.9: 9.87 P99.99: 791.66 ------------------------------------------------------ [ 0, 1 ] 23268 24.389% 24.389% ##### ( 1, 2 ] 59932 62.820% 87.209% ############# ( 2, 3 ] 7047 7.387% 94.596% # ( 3, 4 ] 2877 3.016% 97.611% # ( 4, 6 ] 1773 1.858% 99.470% ( 6, 10 ] 424 0.444% 99.914% ( 10, 15 ] 57 0.060% 99.974% ( 15, 22 ] 7 0.007% 99.981% ( 22, 34 ] 2 0.002% 99.983% ( 110, 170 ] 1 0.001% 99.984% ( 250, 380 ] 4 0.004% 99.988% ( 580, 870 ] 2 0.002% 99.991% ( 870, 1300 ] 5 0.005% 99.996% ( 1300, 1900 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57445 Average: 4.0336 StdDev: 63.09 Min: 0 Median: 1.6807 Max: 5074 Percentiles: P50: 1.68 P75: 2.27 P99: 7.29 P99.9: 176.34 P99.99: 2947.91 ------------------------------------------------------ [ 0, 1 ] 4000 6.963% 6.963% # ( 1, 2 ] 36319 63.224% 70.187% ############# ( 2, 3 ] 10189 17.737% 87.924% #### ( 3, 4 ] 3451 6.007% 93.932% # ( 4, 6 ] 2752 4.791% 98.722% # ( 6, 10 ] 494 0.860% 99.582% ( 10, 15 ] 124 0.216% 99.798% ( 15, 22 ] 22 0.038% 99.836% ( 22, 34 ] 20 0.035% 99.871% ( 34, 51 ] 7 0.012% 99.883% ( 51, 76 ] 2 0.003% 99.887% ( 110, 170 ] 7 0.012% 99.899% ( 170, 250 ] 7 0.012% 99.911% ( 250, 380 ] 8 0.014% 99.925% ( 380, 580 ] 4 0.007% 99.932% ( 580, 870 ] 11 0.019% 99.951% ( 870, 1300 ] 10 0.017% 99.969% ( 1300, 1900 ] 4 0.007% 99.976% ( 1900, 2900 ] 8 0.014% 99.990% ( 2900, 4400 ] 8 0.014% 100.003% ( 4400, 6600 ] 2 0.003% 100.007% ** Level 4 read latency histogram (micros): Count: 15 Average: 1914.4667 StdDev: 1669.25 Min: 174 Median: 1192.5000 Max: 5124 Percentiles: P50: 1192.50 P75: 3368.75 P99: 5124.00 P99.9: 5124.00 P99.99: 5124.00 ------------------------------------------------------ ( 170, 250 ] 2 13.333% 13.333% ### ( 250, 380 ] 1 6.667% 20.000% # ( 380, 580 ] 1 6.667% 26.667% # ( 580, 870 ] 2 13.333% 40.000% ### ( 870, 1300 ] 2 13.333% 53.333% ### ( 1300, 1900 ] 1 6.667% 60.000% # ( 1900, 2900 ] 1 6.667% 66.667% # ( 2900, 4400 ] 4 26.667% 93.333% ##### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 586.2500 StdDev: 777.00 Min: 74 Median: 153.6364 Max: 2875 Percentiles: P50: 153.64 P75: 870.00 P99: 2820.00 P99.9: 2875.00 P99.99: 2875.00 ------------------------------------------------------ ( 51, 76 ] 2 5.000% 5.000% # ( 76, 110 ] 10 25.000% 30.000% ##### ( 110, 170 ] 11 27.500% 57.500% ###### ( 170, 250 ] 1 2.500% 60.000% # ( 250, 380 ] 1 2.500% 62.500% # ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 4 10.000% 85.000% ## ( 1300, 1900 ] 1 2.500% 87.500% # ( 1900, 2900 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 19.0 total, 4.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 310.83 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.914 H:M:S, 15.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 246.21 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.311 H:M:S, 32.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-13:48:55 ... thread 0: (1000000,7000000) ops and (37650.9,154362.0) ops/second in (26.559808,45.347957) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/4 1.23 GB 88.1 4.8 0.0 4.8 11.4 6.6 0.0 1.7 120.5 285.7 40.77 35.50 112 0.364 4989K 5213 0.0 0.0 L1 6/5 703.33 MB 5.9 6.2 5.1 1.1 6.1 5.0 0.2 1.2 213.4 209.6 29.79 26.89 3 9.929 6455K 113K 0.0 0.0 L2 2/2 54.76 MB 0.0 0.4 0.2 0.2 0.4 0.2 4.4 2.0 249.0 248.9 1.52 1.47 2 0.759 383K 195 0.0 0.0 L3 31/15 2.43 GB 1.1 2.8 2.1 0.7 2.8 2.1 2.5 1.3 147.2 146.9 19.24 12.91 16 1.203 1904K 3162 0.0 0.0 L4 186/20 11.70 GB 1.1 1.9 1.7 0.2 1.9 1.6 1.4 1.1 117.7 117.1 16.26 8.92 16 1.016 1903K 6665 0.0 0.0 L5 1052/0 86.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1285/46 102.59 GB 0.0 16.0 9.1 7.0 22.5 15.5 9.5 3.4 152.4 213.8 107.58 85.69 149 0.722 15M 128K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.0 9.1 7.0 22.5 15.5 9.5 3.4 152.4 213.8 107.58 85.69 149 0.722 15M 128K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.0 9.1 7.0 15.9 8.9 0.0 0.0 190.5 188.9 86.08 68.58 55 1.565 15M 128K 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 313.6 21.49 17.11 94 0.229 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.6 total, 45.3 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.46 GB write, 504.87 MB/s write, 16.01 GB read, 359.87 MB/s read, 107.6 seconds Interval compaction: 22.46 GB write, 507.18 MB/s write, 16.01 GB read, 361.52 MB/s read, 107.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 54, pending-compaction-bytes-delays: 2, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 54, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2702549 Average: 2.9985 StdDev: 26.32 Min: 0 Median: 1.3971 Max: 7159 Percentiles: P50: 1.40 P75: 1.80 P99: 7.40 P99.9: 162.36 P99.99: 495.72 ------------------------------------------------------ [ 0, 1 ] 689926 25.529% 25.529% ##### ( 1, 2 ] 1665346 61.621% 87.150% ############ ( 2, 3 ] 186305 6.894% 94.044% # ( 3, 4 ] 76916 2.846% 96.890% # ( 4, 6 ] 52988 1.961% 98.850% ( 6, 10 ] 11552 0.427% 99.278% ( 10, 15 ] 3256 0.120% 99.398% ( 15, 22 ] 560 0.021% 99.419% ( 22, 34 ] 28 0.001% 99.420% ( 34, 51 ] 32 0.001% 99.421% ( 51, 76 ] 77 0.003% 99.424% ( 76, 110 ] 7895 0.292% 99.716% ( 110, 170 ] 5690 0.211% 99.927% ( 170, 250 ] 757 0.028% 99.955% ( 250, 380 ] 592 0.022% 99.977% ( 380, 580 ] 620 0.023% 100.000% ( 580, 870 ] 256 0.009% 100.009% ( 870, 1300 ] 59 0.002% 100.011% ( 1300, 1900 ] 27 0.001% 100.012% ( 1900, 2900 ] 44 0.002% 100.014% ( 2900, 4400 ] 58 0.002% 100.016% ( 4400, 6600 ] 8 0.000% 100.016% ( 6600, 9900 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 1194362 Average: 6.6807 StdDev: 111.25 Min: 1 Median: 1.8272 Max: 18704 Percentiles: P50: 1.83 P75: 2.82 P99: 9.12 P99.9: 86.51 P99.99: 112.59 ------------------------------------------------------ [ 0, 1 ] 116552 9.759% 9.759% ## ( 1, 2 ] 581052 48.650% 58.408% ########## ( 2, 3 ] 240813 20.162% 78.571% #### ( 3, 4 ] 112889 9.452% 88.022% ## ( 4, 6 ] 114435 9.581% 97.604% ## ( 6, 10 ] 21350 1.788% 99.391% ( 10, 15 ] 4879 0.409% 99.800% ( 15, 22 ] 628 0.053% 99.852% ( 22, 34 ] 46 0.004% 99.856% ( 34, 51 ] 17 0.001% 99.858% ( 51, 76 ] 45 0.004% 99.861% ( 76, 110 ] 1500 0.126% 99.987% ( 110, 170 ] 892 0.075% 100.062% ( 170, 250 ] 156 0.013% 100.075% ( 250, 380 ] 224 0.019% 100.093% ( 380, 580 ] 308 0.026% 100.119% ( 580, 870 ] 438 0.037% 100.156% ( 870, 1300 ] 322 0.027% 100.183% ( 1300, 1900 ] 221 0.019% 100.201% ( 1900, 2900 ] 352 0.029% 100.231% ( 2900, 4400 ] 397 0.033% 100.264% ( 4400, 6600 ] 104 0.009% 100.273% ( 6600, 9900 ] 44 0.004% 100.276% ( 9900, 14000 ] 6 0.001% 100.277% ( 14000, 22000 ] 1 0.000% 100.277% ** Level 2 read latency histogram (micros): Count: 95763 Average: 4.4461 StdDev: 88.26 Min: 0 Median: 1.4104 Max: 8315 Percentiles: P50: 1.41 P75: 1.81 P99: 5.65 P99.9: 605.62 P99.99: 4206.78 ------------------------------------------------------ [ 0, 1 ] 23268 24.297% 24.297% ##### ( 1, 2 ] 59973 62.626% 86.924% ############# ( 2, 3 ] 7162 7.479% 94.403% # ( 3, 4 ] 2920 3.049% 97.452% # ( 4, 6 ] 1801 1.881% 99.333% ( 6, 10 ] 433 0.452% 99.785% ( 10, 15 ] 58 0.061% 99.845% ( 15, 22 ] 7 0.007% 99.853% ( 22, 34 ] 2 0.002% 99.855% ( 110, 170 ] 4 0.004% 99.859% ( 170, 250 ] 5 0.005% 99.864% ( 250, 380 ] 17 0.018% 99.882% ( 380, 580 ] 16 0.017% 99.899% ( 580, 870 ] 14 0.015% 99.913% ( 870, 1300 ] 22 0.023% 99.936% ( 1300, 1900 ] 12 0.013% 99.949% ( 1900, 2900 ] 22 0.023% 99.972% ( 2900, 4400 ] 20 0.021% 99.993% ( 4400, 6600 ] 4 0.004% 99.997% ( 6600, 9900 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 574010 Average: 13.4802 StdDev: 172.54 Min: 0 Median: 1.9981 Max: 12484 Percentiles: P50: 2.00 P75: 3.06 P99: 10.30 P99.9: 940.60 P99.99: 1312.56 ------------------------------------------------------ [ 0, 1 ] 10718 1.867% 1.867% ( 1, 2 ] 276816 48.225% 50.092% ########## ( 2, 3 ] 139103 24.234% 74.326% ##### ( 3, 4 ] 66319 11.554% 85.879% ## ( 4, 6 ] 62978 10.972% 96.851% ## ( 6, 10 ] 12178 2.122% 98.972% ( 10, 15 ] 2627 0.458% 99.430% ( 15, 22 ] 318 0.055% 99.486% ( 22, 34 ] 38 0.007% 99.492% ( 34, 51 ] 21 0.004% 99.496% ( 51, 76 ] 8 0.001% 99.497% ( 76, 110 ] 15 0.003% 99.500% ( 110, 170 ] 132 0.023% 99.523% ( 170, 250 ] 211 0.037% 99.560% ( 250, 380 ] 419 0.073% 99.633% ( 380, 580 ] 673 0.117% 99.750% ( 580, 870 ] 762 0.133% 99.883% ( 870, 1300 ] 609 0.106% 99.989% ( 1300, 1900 ] 363 0.063% 100.052% ( 1900, 2900 ] 406 0.071% 100.123% ( 2900, 4400 ] 495 0.086% 100.209% ( 4400, 6600 ] 141 0.025% 100.233% ( 6600, 9900 ] 36 0.006% 100.240% ( 9900, 14000 ] 2 0.000% 100.240% ** Level 4 read latency histogram (micros): Count: 18822 Average: 8.5688 StdDev: 126.21 Min: 1 Median: 2.1296 Max: 6001 Percentiles: P50: 2.13 P75: 3.13 P99: 9.85 P99.9: 1708.90 P99.99: 4464.79 ------------------------------------------------------ [ 0, 1 ] 157 0.834% 0.834% ( 1, 2 ] 8599 45.686% 46.520% ######### ( 2, 3 ] 5062 26.894% 73.414% ##### ( 3, 4 ] 2234 11.869% 85.283% ## ( 4, 6 ] 2285 12.140% 97.423% ## ( 6, 10 ] 309 1.642% 99.065% ( 10, 15 ] 80 0.425% 99.490% ( 15, 22 ] 7 0.037% 99.527% ( 22, 34 ] 3 0.016% 99.543% ( 34, 51 ] 3 0.016% 99.559% ( 51, 76 ] 1 0.005% 99.564% ( 76, 110 ] 5 0.027% 99.591% ( 110, 170 ] 6 0.032% 99.623% ( 170, 250 ] 26 0.138% 99.761% ( 250, 380 ] 2 0.011% 99.772% ( 380, 580 ] 2 0.011% 99.782% ( 580, 870 ] 5 0.027% 99.809% ( 870, 1300 ] 10 0.053% 99.862% ( 1300, 1900 ] 12 0.064% 99.926% ( 1900, 2900 ] 4 0.021% 99.947% ( 2900, 4400 ] 9 0.048% 99.995% ( 4400, 6600 ] 4 0.021% 100.016% ** Level 5 read latency histogram (micros): Count: 62 Average: 1157.9839 StdDev: 1437.70 Min: 74 Median: 500.0000 Max: 5575 Percentiles: P50: 500.00 P75: 1971.43 P99: 5575.00 P99.9: 5575.00 P99.99: 5575.00 ------------------------------------------------------ ( 51, 76 ] 2 3.226% 3.226% # ( 76, 110 ] 10 16.129% 19.355% ### ( 110, 170 ] 11 17.742% 37.097% #### ( 170, 250 ] 1 1.613% 38.710% ( 250, 380 ] 4 6.452% 45.161% # ( 380, 580 ] 5 8.065% 53.226% ## ( 580, 870 ] 5 8.065% 61.290% ## ( 870, 1300 ] 7 11.290% 72.581% ## ( 1300, 1900 ] 1 1.613% 74.194% ( 1900, 2900 ] 7 11.290% 85.484% ## ( 2900, 4400 ] 6 9.677% 95.161% ## ( 4400, 6600 ] 3 4.839% 100.000% # ** DB Stats ** Uptime(secs): 45.6 total, 26.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 151.22 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.774 H:M:S, 56.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 37.06 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:22.860 H:M:S, 86.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/05-13:48:59 ... thread 0: (1000000,8000000) ops and (232411.8,161125.7) ops/second in (4.302708,49.650665) 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/10 2.21 GB 62.9 5.8 0.0 5.8 13.3 7.6 0.0 1.8 120.3 277.6 49.22 42.07 128 0.385 6012K 6501 0.0 0.0 L1 1/1 59.42 MB 0.0 6.2 5.1 1.1 6.1 5.0 0.2 1.2 213.4 209.6 29.79 26.89 3 9.929 6455K 113K 0.0 0.0 L2 2/0 83.15 MB 0.8 1.0 0.8 0.2 1.0 0.8 4.4 1.3 161.2 160.8 6.66 4.72 3 2.221 437K 195 0.0 0.0 L3 14/0 906.97 MB 0.9 3.8 2.4 1.4 3.8 2.4 2.8 1.6 137.8 137.5 28.37 17.65 21 1.351 2999K 5981 0.0 0.0 L4 158/0 9.52 GB 1.0 3.7 3.0 0.8 3.7 3.0 2.2 1.2 120.9 120.4 31.71 17.90 29 1.093 3823K 12K 0.0 0.0 L5 1104/0 90.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1291/11 103.56 GB 0.0 20.6 11.3 9.3 28.0 18.7 14.9 3.7 144.7 196.9 145.76 109.23 184 0.792 19M 138K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.6 11.3 9.3 28.0 18.7 14.9 3.7 144.7 196.9 145.76 109.23 184 0.792 19M 138K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.6 11.3 9.3 20.5 11.2 0.0 0.0 175.5 174.3 120.21 89.45 77 1.561 19M 138K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 303.3 25.54 19.78 107 0.239 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): 49.9 total, 49.7 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.02 GB write, 575.55 MB/s write, 20.60 GB read, 423.14 MB/s read, 145.8 seconds Interval compaction: 28.02 GB write, 577.96 MB/s write, 20.60 GB read, 424.91 MB/s read, 145.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 79, pending-compaction-bytes-delays: 2, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 79, interval: 90 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3080894 Average: 3.0463 StdDev: 28.35 Min: 0 Median: 1.4309 Max: 7159 Percentiles: P50: 1.43 P75: 1.84 P99: 7.48 P99.9: 159.17 P99.99: 478.47 ------------------------------------------------------ [ 0, 1 ] 719923 23.367% 23.367% ##### ( 1, 2 ] 1904369 61.812% 85.180% ############ ( 2, 3 ] 248702 8.072% 93.252% ## ( 3, 4 ] 99630 3.234% 96.486% # ( 4, 6 ] 71369 2.317% 98.802% ( 6, 10 ] 16482 0.535% 99.337% ( 10, 15 ] 3976 0.129% 99.466% ( 15, 22 ] 631 0.020% 99.487% ( 22, 34 ] 34 0.001% 99.488% ( 34, 51 ] 32 0.001% 99.489% ( 51, 76 ] 79 0.003% 99.491% ( 76, 110 ] 7900 0.256% 99.748% ( 110, 170 ] 5720 0.186% 99.934% ( 170, 250 ] 779 0.025% 99.959% ( 250, 380 ] 633 0.021% 99.979% ( 380, 580 ] 666 0.022% 100.001% ( 580, 870 ] 337 0.011% 100.012% ( 870, 1300 ] 141 0.005% 100.017% ( 1300, 1900 ] 60 0.002% 100.018% ( 1900, 2900 ] 65 0.002% 100.021% ( 2900, 4400 ] 72 0.002% 100.023% ( 4400, 6600 ] 8 0.000% 100.023% ( 6600, 9900 ] 2 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1399818 Average: 6.9288 StdDev: 111.80 Min: 1 Median: 1.8520 Max: 18704 Percentiles: P50: 1.85 P75: 2.85 P99: 9.26 P99.9: 93.61 P99.99: 145.59 ------------------------------------------------------ [ 0, 1 ] 119343 8.526% 8.526% ## ( 1, 2 ] 681426 48.680% 57.205% ########## ( 2, 3 ] 293329 20.955% 78.160% #### ( 3, 4 ] 134004 9.573% 87.733% ## ( 4, 6 ] 135524 9.682% 97.415% ## ( 6, 10 ] 27204 1.943% 99.358% ( 10, 15 ] 5914 0.422% 99.780% ( 15, 22 ] 769 0.055% 99.835% ( 22, 34 ] 55 0.004% 99.839% ( 34, 51 ] 23 0.002% 99.841% ( 51, 76 ] 48 0.003% 99.844% ( 76, 110 ] 1504 0.107% 99.952% ( 110, 170 ] 902 0.064% 100.016% ( 170, 250 ] 175 0.013% 100.029% ( 250, 380 ] 269 0.019% 100.048% ( 380, 580 ] 408 0.029% 100.077% ( 580, 870 ] 597 0.043% 100.120% ( 870, 1300 ] 443 0.032% 100.151% ( 1300, 1900 ] 301 0.022% 100.173% ( 1900, 2900 ] 455 0.033% 100.205% ( 2900, 4400 ] 489 0.035% 100.240% ( 4400, 6600 ] 122 0.009% 100.249% ( 6600, 9900 ] 46 0.003% 100.252% ( 9900, 14000 ] 6 0.000% 100.253% ( 14000, 22000 ] 1 0.000% 100.253% ** Level 2 read latency histogram (micros): Count: 278514 Average: 8.4720 StdDev: 123.31 Min: 0 Median: 1.7859 Max: 8315 Percentiles: P50: 1.79 P75: 2.68 P99: 9.22 P99.9: 596.41 P99.99: 1015.34 ------------------------------------------------------ [ 0, 1 ] 24816 8.910% 8.910% ## ( 1, 2 ] 145620 52.285% 61.195% ########## ( 2, 3 ] 56292 20.212% 81.406% #### ( 3, 4 ] 22605 8.116% 89.523% ## ( 4, 6 ] 22195 7.969% 97.492% ## ( 6, 10 ] 5217 1.873% 99.365% ( 10, 15 ] 1008 0.362% 99.727% ( 15, 22 ] 144 0.052% 99.778% ( 22, 34 ] 11 0.004% 99.782% ( 34, 51 ] 4 0.001% 99.784% ( 51, 76 ] 2 0.001% 99.785% ( 76, 110 ] 2 0.001% 99.785% ( 110, 170 ] 20 0.007% 99.792% ( 170, 250 ] 35 0.013% 99.805% ( 250, 380 ] 86 0.031% 99.836% ( 380, 580 ] 167 0.060% 99.896% ( 580, 870 ] 203 0.073% 99.969% ( 870, 1300 ] 175 0.063% 100.032% ( 1300, 1900 ] 120 0.043% 100.075% ( 1900, 2900 ] 132 0.047% 100.122% ( 2900, 4400 ] 126 0.045% 100.167% ( 4400, 6600 ] 35 0.013% 100.180% ( 6600, 9900 ] 7 0.003% 100.182% ** Level 3 read latency histogram (micros): Count: 681027 Average: 14.8743 StdDev: 179.14 Min: 0 Median: 2.0028 Max: 12484 Percentiles: P50: 2.00 P75: 3.06 P99: 11.59 P99.9: 1172.10 P99.99: 1674.75 ------------------------------------------------------ [ 0, 1 ] 12589 1.849% 1.849% ( 1, 2 ] 327456 48.083% 49.931% ########## ( 2, 3 ] 165713 24.333% 74.264% ##### ( 3, 4 ] 78290 11.496% 85.760% ## ( 4, 6 ] 74052 10.874% 96.633% ## ( 6, 10 ] 15113 2.219% 98.853% ( 10, 15 ] 3153 0.463% 99.316% ( 15, 22 ] 396 0.058% 99.374% ( 22, 34 ] 46 0.007% 99.380% ( 34, 51 ] 22 0.003% 99.384% ( 51, 76 ] 13 0.002% 99.386% ( 76, 110 ] 20 0.003% 99.389% ( 110, 170 ] 148 0.022% 99.410% ( 170, 250 ] 253 0.037% 99.447% ( 250, 380 ] 520 0.076% 99.524% ( 380, 580 ] 899 0.132% 99.656% ( 580, 870 ] 1037 0.152% 99.808% ( 870, 1300 ] 891 0.131% 99.939% ( 1300, 1900 ] 557 0.082% 100.021% ( 1900, 2900 ] 574 0.084% 100.105% ( 2900, 4400 ] 667 0.098% 100.203% ( 4400, 6600 ] 166 0.024% 100.227% ( 6600, 9900 ] 38 0.006% 100.233% ( 9900, 14000 ] 2 0.000% 100.233% ** Level 4 read latency histogram (micros): Count: 93934 Average: 9.9794 StdDev: 125.91 Min: 0 Median: 1.9495 Max: 7052 Percentiles: P50: 1.95 P75: 2.89 P99: 10.20 P99.9: 1576.21 P99.99: 2891.26 ------------------------------------------------------ [ 0, 1 ] 1240 1.320% 1.320% ( 1, 2 ] 48159 51.269% 52.589% ########## ( 2, 3 ] 23614 25.139% 77.728% ##### ( 3, 4 ] 9043 9.627% 87.355% ## ( 4, 6 ] 9038 9.622% 96.977% ## ( 6, 10 ] 1887 2.009% 98.985% ( 10, 15 ] 346 0.368% 99.354% ( 15, 22 ] 35 0.037% 99.391% ( 22, 34 ] 8 0.009% 99.400% ( 34, 51 ] 5 0.005% 99.405% ( 51, 76 ] 1 0.001% 99.406% ( 76, 110 ] 18 0.019% 99.425% ( 110, 170 ] 48 0.051% 99.476% ( 170, 250 ] 87 0.093% 99.569% ( 250, 380 ] 37 0.039% 99.608% ( 380, 580 ] 62 0.066% 99.674% ( 580, 870 ] 87 0.093% 99.767% ( 870, 1300 ] 91 0.097% 99.864% ( 1300, 1900 ] 74 0.079% 99.943% ( 1900, 2900 ] 45 0.048% 99.990% ( 2900, 4400 ] 43 0.046% 100.036% ( 4400, 6600 ] 11 0.012% 100.048% ( 6600, 9900 ] 1 0.001% 100.049% ** Level 5 read latency histogram (micros): Count: 320 Average: 1592.6688 StdDev: 1573.86 Min: 74 Median: 953.6111 Max: 7093 Percentiles: P50: 953.61 P75: 2566.67 P99: 6576.84 P99.9: 7093.00 P99.99: 7093.00 ------------------------------------------------------ ( 51, 76 ] 2 0.625% 0.625% ( 76, 110 ] 17 5.312% 5.938% # ( 110, 170 ] 21 6.562% 12.500% # ( 170, 250 ] 12 3.750% 16.250% # ( 250, 380 ] 22 6.875% 23.125% # ( 380, 580 ] 36 11.250% 34.375% ## ( 580, 870 ] 43 13.438% 47.812% ### ( 870, 1300 ] 36 11.250% 59.062% ## ( 1300, 1900 ] 25 7.812% 66.875% ## ( 1900, 2900 ] 39 12.188% 79.062% ## ( 2900, 4400 ] 45 14.062% 93.125% ### ( 4400, 6600 ] 19 5.938% 99.062% # ( 6600, 9900 ] 3 0.938% 100.000% ** DB Stats ** Uptime(secs): 49.9 total, 4.3 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 157.91 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.241 H:M:S, 54.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 228.74 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.467 H:M:S, 34.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/05-13:49:02 ... thread 0: (1000000,9000000) ops and (323170.5,170632.3) ops/second in (3.094342,52.745007) 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/4 1.91 GB 163.6 6.6 0.0 6.6 15.1 8.5 0.0 1.8 122.0 280.4 55.24 47.71 145 0.381 6844K 7397 0.0 0.0 L1 13/0 1.34 GB 137.3 7.6 6.4 1.2 7.4 6.3 0.2 1.2 213.6 210.2 36.23 32.87 4 9.058 7797K 113K 0.0 0.0 L2 2/0 83.15 MB 0.8 1.0 0.8 0.2 1.0 0.8 4.4 1.3 161.2 160.8 6.66 4.72 3 2.221 437K 195 0.0 0.0 L3 14/0 906.97 MB 0.9 3.8 2.4 1.4 3.8 2.4 2.8 1.6 137.8 137.5 28.37 17.65 21 1.351 2999K 5981 0.0 0.0 L4 158/0 9.52 GB 1.0 3.7 3.0 0.8 3.7 3.0 2.2 1.2 120.9 120.4 31.71 17.90 29 1.093 3823K 12K 0.0 0.0 L5 1104/0 90.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1302/4 104.53 GB 0.0 22.8 12.6 10.1 31.1 21.0 14.9 3.6 147.2 201.6 158.22 120.84 202 0.783 21M 139K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.8 12.6 10.1 31.1 21.0 14.9 3.6 147.2 201.6 158.22 120.84 202 0.783 21M 139K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.8 12.6 10.1 22.6 12.5 0.0 0.0 179.5 178.3 129.81 98.51 81 1.603 21M 139K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 308.2 28.41 22.33 121 0.235 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): 53.0 total, 52.7 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.15 GB write, 602.32 MB/s write, 22.75 GB read, 439.96 MB/s read, 158.2 seconds Interval compaction: 31.15 GB write, 604.70 MB/s write, 22.75 GB read, 441.69 MB/s read, 158.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 83, pending-compaction-bytes-delays: 2, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 83, interval: 94 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3450308 Average: 2.9631 StdDev: 27.00 Min: 0 Median: 1.4399 Max: 7159 Percentiles: P50: 1.44 P75: 1.84 P99: 7.17 P99.9: 154.35 P99.99: 424.86 ------------------------------------------------------ [ 0, 1 ] 777158 22.524% 22.524% ##### ( 1, 2 ] 2154981 62.458% 84.982% ############ ( 2, 3 ] 287188 8.324% 93.305% ## ( 3, 4 ] 112230 3.253% 96.558% # ( 4, 6 ] 78596 2.278% 98.836% ( 6, 10 ] 19328 0.560% 99.396% ( 10, 15 ] 4334 0.126% 99.522% ( 15, 22 ] 660 0.019% 99.541% ( 22, 34 ] 39 0.001% 99.542% ( 34, 51 ] 35 0.001% 99.543% ( 51, 76 ] 82 0.002% 99.546% ( 76, 110 ] 7956 0.231% 99.776% ( 110, 170 ] 5779 0.167% 99.944% ( 170, 250 ] 796 0.023% 99.967% ( 250, 380 ] 649 0.019% 99.986% ( 380, 580 ] 682 0.020% 100.005% ( 580, 870 ] 346 0.010% 100.015% ( 870, 1300 ] 143 0.004% 100.020% ( 1300, 1900 ] 63 0.002% 100.021% ( 1900, 2900 ] 67 0.002% 100.023% ( 2900, 4400 ] 73 0.002% 100.025% ( 4400, 6600 ] 8 0.000% 100.026% ( 6600, 9900 ] 2 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1414971 Average: 6.9006 StdDev: 111.28 Min: 1 Median: 1.8478 Max: 18704 Percentiles: P50: 1.85 P75: 2.84 P99: 9.27 P99.9: 94.99 P99.99: 148.95 ------------------------------------------------------ [ 0, 1 ] 121177 8.564% 8.564% ## ( 1, 2 ] 691549 48.874% 57.438% ########## ( 2, 3 ] 295440 20.880% 78.317% #### ( 3, 4 ] 134447 9.502% 87.819% ## ( 4, 6 ] 135813 9.598% 97.417% ## ( 6, 10 ] 27435 1.939% 99.356% ( 10, 15 ] 5937 0.420% 99.776% ( 15, 22 ] 773 0.055% 99.830% ( 22, 34 ] 55 0.004% 99.834% ( 34, 51 ] 23 0.002% 99.836% ( 51, 76 ] 53 0.004% 99.840% ( 76, 110 ] 1529 0.108% 99.948% ( 110, 170 ] 922 0.065% 100.013% ( 170, 250 ] 184 0.013% 100.026% ( 250, 380 ] 281 0.020% 100.046% ( 380, 580 ] 418 0.030% 100.075% ( 580, 870 ] 601 0.042% 100.118% ( 870, 1300 ] 447 0.032% 100.149% ( 1300, 1900 ] 307 0.022% 100.171% ( 1900, 2900 ] 455 0.032% 100.203% ( 2900, 4400 ] 489 0.035% 100.238% ( 4400, 6600 ] 122 0.009% 100.246% ( 6600, 9900 ] 46 0.003% 100.250% ( 9900, 14000 ] 6 0.000% 100.250% ( 14000, 22000 ] 1 0.000% 100.250% ** Level 2 read latency histogram (micros): Count: 278514 Average: 8.4720 StdDev: 123.31 Min: 0 Median: 1.7859 Max: 8315 Percentiles: P50: 1.79 P75: 2.68 P99: 9.22 P99.9: 596.41 P99.99: 1015.34 ------------------------------------------------------ [ 0, 1 ] 24816 8.910% 8.910% ## ( 1, 2 ] 145620 52.285% 61.195% ########## ( 2, 3 ] 56292 20.212% 81.406% #### ( 3, 4 ] 22605 8.116% 89.523% ## ( 4, 6 ] 22195 7.969% 97.492% ## ( 6, 10 ] 5217 1.873% 99.365% ( 10, 15 ] 1008 0.362% 99.727% ( 15, 22 ] 144 0.052% 99.778% ( 22, 34 ] 11 0.004% 99.782% ( 34, 51 ] 4 0.001% 99.784% ( 51, 76 ] 2 0.001% 99.785% ( 76, 110 ] 2 0.001% 99.785% ( 110, 170 ] 20 0.007% 99.792% ( 170, 250 ] 35 0.013% 99.805% ( 250, 380 ] 86 0.031% 99.836% ( 380, 580 ] 167 0.060% 99.896% ( 580, 870 ] 203 0.073% 99.969% ( 870, 1300 ] 175 0.063% 100.032% ( 1300, 1900 ] 120 0.043% 100.075% ( 1900, 2900 ] 132 0.047% 100.122% ( 2900, 4400 ] 126 0.045% 100.167% ( 4400, 6600 ] 35 0.013% 100.180% ( 6600, 9900 ] 7 0.003% 100.182% ** Level 3 read latency histogram (micros): Count: 681027 Average: 14.8743 StdDev: 179.14 Min: 0 Median: 2.0028 Max: 12484 Percentiles: P50: 2.00 P75: 3.06 P99: 11.59 P99.9: 1172.10 P99.99: 1674.75 ------------------------------------------------------ [ 0, 1 ] 12589 1.849% 1.849% ( 1, 2 ] 327456 48.083% 49.931% ########## ( 2, 3 ] 165713 24.333% 74.264% ##### ( 3, 4 ] 78290 11.496% 85.760% ## ( 4, 6 ] 74052 10.874% 96.633% ## ( 6, 10 ] 15113 2.219% 98.853% ( 10, 15 ] 3153 0.463% 99.316% ( 15, 22 ] 396 0.058% 99.374% ( 22, 34 ] 46 0.007% 99.380% ( 34, 51 ] 22 0.003% 99.384% ( 51, 76 ] 13 0.002% 99.386% ( 76, 110 ] 20 0.003% 99.389% ( 110, 170 ] 148 0.022% 99.410% ( 170, 250 ] 253 0.037% 99.447% ( 250, 380 ] 520 0.076% 99.524% ( 380, 580 ] 899 0.132% 99.656% ( 580, 870 ] 1037 0.152% 99.808% ( 870, 1300 ] 891 0.131% 99.939% ( 1300, 1900 ] 557 0.082% 100.021% ( 1900, 2900 ] 574 0.084% 100.105% ( 2900, 4400 ] 667 0.098% 100.203% ( 4400, 6600 ] 166 0.024% 100.227% ( 6600, 9900 ] 38 0.006% 100.233% ( 9900, 14000 ] 2 0.000% 100.233% ** Level 4 read latency histogram (micros): Count: 93934 Average: 9.9794 StdDev: 125.91 Min: 0 Median: 1.9495 Max: 7052 Percentiles: P50: 1.95 P75: 2.89 P99: 10.20 P99.9: 1576.21 P99.99: 2891.26 ------------------------------------------------------ [ 0, 1 ] 1240 1.320% 1.320% ( 1, 2 ] 48159 51.269% 52.589% ########## ( 2, 3 ] 23614 25.139% 77.728% ##### ( 3, 4 ] 9043 9.627% 87.355% ## ( 4, 6 ] 9038 9.622% 96.977% ## ( 6, 10 ] 1887 2.009% 98.985% ( 10, 15 ] 346 0.368% 99.354% ( 15, 22 ] 35 0.037% 99.391% ( 22, 34 ] 8 0.009% 99.400% ( 34, 51 ] 5 0.005% 99.405% ( 51, 76 ] 1 0.001% 99.406% ( 76, 110 ] 18 0.019% 99.425% ( 110, 170 ] 48 0.051% 99.476% ( 170, 250 ] 87 0.093% 99.569% ( 250, 380 ] 37 0.039% 99.608% ( 380, 580 ] 62 0.066% 99.674% ( 580, 870 ] 87 0.093% 99.767% ( 870, 1300 ] 91 0.097% 99.864% ( 1300, 1900 ] 74 0.079% 99.943% ( 1900, 2900 ] 45 0.048% 99.990% ( 2900, 4400 ] 43 0.046% 100.036% ( 4400, 6600 ] 11 0.012% 100.048% ( 6600, 9900 ] 1 0.001% 100.049% ** Level 5 read latency histogram (micros): Count: 320 Average: 1592.6688 StdDev: 1573.86 Min: 74 Median: 953.6111 Max: 7093 Percentiles: P50: 953.61 P75: 2566.67 P99: 6576.84 P99.9: 7093.00 P99.99: 7093.00 ------------------------------------------------------ ( 51, 76 ] 2 0.625% 0.625% ( 76, 110 ] 17 5.312% 5.938% # ( 110, 170 ] 21 6.562% 12.500% # ( 170, 250 ] 12 3.750% 16.250% # ( 250, 380 ] 22 6.875% 23.125% # ( 380, 580 ] 36 11.250% 34.375% ## ( 580, 870 ] 43 13.438% 47.812% ### ( 870, 1300 ] 36 11.250% 59.062% ## ( 1300, 1900 ] 25 7.812% 66.875% ## ( 1900, 2900 ] 39 12.188% 79.062% ## ( 2900, 4400 ] 45 14.062% 93.125% ### ( 4400, 6600 ] 19 5.938% 99.062% # ( 6600, 9900 ] 3 0.938% 100.000% ** DB Stats ** Uptime(secs): 53.0 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 167.27 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.674 H:M:S, 52.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.07 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.433 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/05-13:49:05 ... thread 0: (1000000,10000000) ops and (326586.4,179189.0) ops/second in (3.061977,55.806984) 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.83 GB 25.2 7.1 0.0 7.1 16.6 9.5 0.0 1.8 121.8 283.3 60.00 52.16 160 0.375 7419K 7998 0.0 0.0 L1 13/13 1.34 GB 0.0 7.6 6.4 1.2 7.4 6.3 0.2 1.2 213.6 210.2 36.23 32.87 4 9.058 7797K 113K 0.0 0.0 L2 2/0 83.15 MB 0.8 1.0 0.8 0.2 1.0 0.8 4.4 1.3 161.2 160.8 6.66 4.72 3 2.221 437K 195 0.0 0.0 L3 14/0 906.97 MB 0.9 3.8 2.4 1.4 3.8 2.4 2.8 1.6 137.8 137.5 28.37 17.65 21 1.351 2999K 5981 0.0 0.0 L4 158/0 9.52 GB 1.0 3.7 3.0 0.8 3.7 3.0 2.2 1.2 120.9 120.4 31.71 17.90 29 1.093 3823K 12K 0.0 0.0 L5 1104/0 90.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1309/28 105.46 GB 0.0 23.3 12.6 10.7 32.6 21.9 14.9 3.4 146.4 205.0 162.98 125.30 217 0.751 22M 140K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.3 12.6 10.7 32.6 21.9 14.9 3.4 146.4 205.0 162.98 125.30 217 0.751 22M 140K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.3 12.6 10.7 23.1 12.5 0.0 0.0 180.9 179.7 131.91 100.58 83 1.589 22M 140K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 312.3 31.06 24.71 134 0.232 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): 56.0 total, 55.8 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: 32.62 GB write, 596.38 MB/s write, 23.31 GB read, 426.03 MB/s read, 163.0 seconds Interval compaction: 32.62 GB write, 598.60 MB/s write, 23.31 GB read, 427.62 MB/s read, 163.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 88, pending-compaction-bytes-delays: 2, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 88, interval: 99 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3700269 Average: 2.9038 StdDev: 26.20 Min: 0 Median: 1.4379 Max: 7159 Percentiles: P50: 1.44 P75: 1.84 P99: 6.85 P99.9: 151.78 P99.99: 406.99 ------------------------------------------------------ [ 0, 1 ] 836189 22.598% 22.598% ##### ( 1, 2 ] 2315700 62.582% 85.180% ############# ( 2, 3 ] 307307 8.305% 93.485% ## ( 3, 4 ] 118320 3.198% 96.683% # ( 4, 6 ] 81477 2.202% 98.885% ( 6, 10 ] 20110 0.543% 99.428% ( 10, 15 ] 4567 0.123% 99.551% ( 15, 22 ] 687 0.019% 99.570% ( 22, 34 ] 39 0.001% 99.571% ( 34, 51 ] 37 0.001% 99.572% ( 51, 76 ] 84 0.002% 99.574% ( 76, 110 ] 8002 0.216% 99.791% ( 110, 170 ] 5816 0.157% 99.948% ( 170, 250 ] 813 0.022% 99.970% ( 250, 380 ] 658 0.018% 99.987% ( 380, 580 ] 689 0.019% 100.006% ( 580, 870 ] 349 0.009% 100.016% ( 870, 1300 ] 145 0.004% 100.019% ( 1300, 1900 ] 68 0.002% 100.021% ( 1900, 2900 ] 67 0.002% 100.023% ( 2900, 4400 ] 73 0.002% 100.025% ( 4400, 6600 ] 8 0.000% 100.025% ( 6600, 9900 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1446665 Average: 6.8027 StdDev: 110.06 Min: 1 Median: 1.8371 Max: 18704 Percentiles: P50: 1.84 P75: 2.82 P99: 9.25 P99.9: 95.57 P99.99: 150.39 ------------------------------------------------------ [ 0, 1 ] 127300 8.800% 8.800% ## ( 1, 2 ] 712002 49.217% 58.016% ########## ( 2, 3 ] 298665 20.645% 78.661% #### ( 3, 4 ] 135243 9.349% 88.010% ## ( 4, 6 ] 136368 9.426% 97.436% ## ( 6, 10 ] 27873 1.927% 99.363% ( 10, 15 ] 5972 0.413% 99.776% ( 15, 22 ] 778 0.054% 99.830% ( 22, 34 ] 55 0.004% 99.833% ( 34, 51 ] 23 0.002% 99.835% ( 51, 76 ] 53 0.004% 99.839% ( 76, 110 ] 1540 0.106% 99.945% ( 110, 170 ] 963 0.067% 100.012% ( 170, 250 ] 189 0.013% 100.025% ( 250, 380 ] 285 0.020% 100.045% ( 380, 580 ] 420 0.029% 100.074% ( 580, 870 ] 602 0.042% 100.115% ( 870, 1300 ] 447 0.031% 100.146% ( 1300, 1900 ] 307 0.021% 100.167% ( 1900, 2900 ] 455 0.031% 100.199% ( 2900, 4400 ] 489 0.034% 100.233% ( 4400, 6600 ] 122 0.008% 100.241% ( 6600, 9900 ] 46 0.003% 100.244% ( 9900, 14000 ] 6 0.000% 100.245% ( 14000, 22000 ] 1 0.000% 100.245% ** Level 2 read latency histogram (micros): Count: 278514 Average: 8.4720 StdDev: 123.31 Min: 0 Median: 1.7859 Max: 8315 Percentiles: P50: 1.79 P75: 2.68 P99: 9.22 P99.9: 596.41 P99.99: 1015.34 ------------------------------------------------------ [ 0, 1 ] 24816 8.910% 8.910% ## ( 1, 2 ] 145620 52.285% 61.195% ########## ( 2, 3 ] 56292 20.212% 81.406% #### ( 3, 4 ] 22605 8.116% 89.523% ## ( 4, 6 ] 22195 7.969% 97.492% ## ( 6, 10 ] 5217 1.873% 99.365% ( 10, 15 ] 1008 0.362% 99.727% ( 15, 22 ] 144 0.052% 99.778% ( 22, 34 ] 11 0.004% 99.782% ( 34, 51 ] 4 0.001% 99.784% ( 51, 76 ] 2 0.001% 99.785% ( 76, 110 ] 2 0.001% 99.785% ( 110, 170 ] 20 0.007% 99.792% ( 170, 250 ] 35 0.013% 99.805% ( 250, 380 ] 86 0.031% 99.836% ( 380, 580 ] 167 0.060% 99.896% ( 580, 870 ] 203 0.073% 99.969% ( 870, 1300 ] 175 0.063% 100.032% ( 1300, 1900 ] 120 0.043% 100.075% ( 1900, 2900 ] 132 0.047% 100.122% ( 2900, 4400 ] 126 0.045% 100.167% ( 4400, 6600 ] 35 0.013% 100.180% ( 6600, 9900 ] 7 0.003% 100.182% ** Level 3 read latency histogram (micros): Count: 681027 Average: 14.8743 StdDev: 179.14 Min: 0 Median: 2.0028 Max: 12484 Percentiles: P50: 2.00 P75: 3.06 P99: 11.59 P99.9: 1172.10 P99.99: 1674.75 ------------------------------------------------------ [ 0, 1 ] 12589 1.849% 1.849% ( 1, 2 ] 327456 48.083% 49.931% ########## ( 2, 3 ] 165713 24.333% 74.264% ##### ( 3, 4 ] 78290 11.496% 85.760% ## ( 4, 6 ] 74052 10.874% 96.633% ## ( 6, 10 ] 15113 2.219% 98.853% ( 10, 15 ] 3153 0.463% 99.316% ( 15, 22 ] 396 0.058% 99.374% ( 22, 34 ] 46 0.007% 99.380% ( 34, 51 ] 22 0.003% 99.384% ( 51, 76 ] 13 0.002% 99.386% ( 76, 110 ] 20 0.003% 99.389% ( 110, 170 ] 148 0.022% 99.410% ( 170, 250 ] 253 0.037% 99.447% ( 250, 380 ] 520 0.076% 99.524% ( 380, 580 ] 899 0.132% 99.656% ( 580, 870 ] 1037 0.152% 99.808% ( 870, 1300 ] 891 0.131% 99.939% ( 1300, 1900 ] 557 0.082% 100.021% ( 1900, 2900 ] 574 0.084% 100.105% ( 2900, 4400 ] 667 0.098% 100.203% ( 4400, 6600 ] 166 0.024% 100.227% ( 6600, 9900 ] 38 0.006% 100.233% ( 9900, 14000 ] 2 0.000% 100.233% ** Level 4 read latency histogram (micros): Count: 93934 Average: 9.9794 StdDev: 125.91 Min: 0 Median: 1.9495 Max: 7052 Percentiles: P50: 1.95 P75: 2.89 P99: 10.20 P99.9: 1576.21 P99.99: 2891.26 ------------------------------------------------------ [ 0, 1 ] 1240 1.320% 1.320% ( 1, 2 ] 48159 51.269% 52.589% ########## ( 2, 3 ] 23614 25.139% 77.728% ##### ( 3, 4 ] 9043 9.627% 87.355% ## ( 4, 6 ] 9038 9.622% 96.977% ## ( 6, 10 ] 1887 2.009% 98.985% ( 10, 15 ] 346 0.368% 99.354% ( 15, 22 ] 35 0.037% 99.391% ( 22, 34 ] 8 0.009% 99.400% ( 34, 51 ] 5 0.005% 99.405% ( 51, 76 ] 1 0.001% 99.406% ( 76, 110 ] 18 0.019% 99.425% ( 110, 170 ] 48 0.051% 99.476% ( 170, 250 ] 87 0.093% 99.569% ( 250, 380 ] 37 0.039% 99.608% ( 380, 580 ] 62 0.066% 99.674% ( 580, 870 ] 87 0.093% 99.767% ( 870, 1300 ] 91 0.097% 99.864% ( 1300, 1900 ] 74 0.079% 99.943% ( 1900, 2900 ] 45 0.048% 99.990% ( 2900, 4400 ] 43 0.046% 100.036% ( 4400, 6600 ] 11 0.012% 100.048% ( 6600, 9900 ] 1 0.001% 100.049% ** Level 5 read latency histogram (micros): Count: 320 Average: 1592.6688 StdDev: 1573.86 Min: 74 Median: 953.6111 Max: 7093 Percentiles: P50: 953.61 P75: 2566.67 P99: 6576.84 P99.9: 7093.00 P99.99: 7093.00 ------------------------------------------------------ ( 51, 76 ] 2 0.625% 0.625% ( 76, 110 ] 17 5.312% 5.938% # ( 110, 170 ] 21 6.562% 12.500% # ( 170, 250 ] 12 3.750% 16.250% # ( 250, 380 ] 22 6.875% 23.125% # ( 380, 580 ] 36 11.250% 34.375% ## ( 580, 870 ] 43 13.438% 47.812% ### ( 870, 1300 ] 36 11.250% 59.062% ## ( 1300, 1900 ] 25 7.812% 66.875% ## ( 1900, 2900 ] 39 12.188% 79.062% ## ( 2900, 4400 ] 45 14.062% 93.125% ### ( 4400, 6600 ] 19 5.938% 99.062% # ( 6600, 9900 ] 3 0.938% 100.000% ** DB Stats ** Uptime(secs): 56.0 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 175.70 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:28.086 H:M:S, 50.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.42 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.411 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.504 micros/op 181682 ops/sec 60.066 seconds 10912999 operations; 176.0 MB/s Microseconds per write: Count: 10912999 Average: 5.5041 StdDev: 522.18 Min: 1 Median: 1.7422 Max: 789557 Percentiles: P50: 1.74 P75: 2.76 P99: 9.02 P99.9: 1082.32 P99.99: 2741.85 ------------------------------------------------------ [ 0, 1 ] 1372400 12.576% 12.576% ### ( 1, 2 ] 5502821 50.424% 63.000% ########## ( 2, 3 ] 1719909 15.760% 78.760% ### ( 3, 4 ] 1515302 13.885% 92.646% ### ( 4, 6 ] 603262 5.528% 98.174% # ( 6, 10 ] 119322 1.093% 99.267% ( 10, 15 ] 40920 0.375% 99.642% ( 15, 22 ] 10193 0.093% 99.735% ( 22, 34 ] 2230 0.020% 99.756% ( 34, 51 ] 280 0.003% 99.758% ( 51, 76 ] 46 0.000% 99.759% ( 76, 110 ] 7493 0.069% 99.828% ( 110, 170 ] 3036 0.028% 99.855% ( 170, 250 ] 333 0.003% 99.858% ( 250, 380 ] 168 0.002% 99.860% ( 380, 580 ] 31 0.000% 99.860% ( 580, 870 ] 22 0.000% 99.860% ( 870, 1300 ] 8745 0.080% 99.941% ( 1300, 1900 ] 22 0.000% 99.941% ( 1900, 2900 ] 6382 0.058% 99.999% ( 2900, 4400 ] 34 0.000% 100.000% ( 4400, 6600 ] 8 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 3 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 4 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 : 180936 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 : 10912999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11262214968 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 : 544 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 29827339 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 : 27852763742 rocksdb.compact.write.bytes COUNT : 27668238067 rocksdb.flush.write.bytes COUNT : 11229625268 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 : 71 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 : 306 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 : 11139144704 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4378624 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 : 27961294668 rocksdb.non.last.level.read.count COUNT : 6748741 rocksdb.block.checksum.compute.count COUNT : 6747724 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.405042 P95 : 3.913307 P99 : 7.443085 P100 : 789555.000000 COUNT : 10912999 SUM : 55033156 rocksdb.compaction.times.micros P50 : 1107714.285714 P95 : 4776666.666667 P99 : 23379657.000000 P100 : 23379657.000000 COUNT : 87 SUM : 136260073 rocksdb.compaction.times.cpu_micros P50 : 884285.714286 P95 : 3355000.000000 P99 : 15040000.000000 P100 : 20650334.000000 COUNT : 87 SUM : 104823308 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 : 687.865854 P95 : 4062.500000 P99 : 41670.000000 P100 : 101575.000000 COUNT : 149 SUM : 293113 rocksdb.compaction.outfile.sync.micros P50 : 1198.642857 P95 : 87031.250000 P99 : 214000.000000 P100 : 268069.000000 COUNT : 325 SUM : 5396287 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 106.830508 P95 : 2475.000000 P99 : 4240.625000 P100 : 6041.000000 COUNT : 285 SUM : 130810 rocksdb.table.open.io.micros P50 : 1724.719101 P95 : 10056.190476 P99 : 15782.857143 P100 : 20305.000000 COUNT : 544 SUM : 1469051 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.682683 P95 : 8.098997 P99 : 12.623181 P100 : 18710.000000 COUNT : 6746435 SUM : 50111657 rocksdb.read.block.get.micros P50 : 506.732673 P95 : 3945.945946 P99 : 6059.428571 P100 : 12176.000000 COUNT : 1088 SUM : 1135788 rocksdb.write.raw.block.micros P50 : 0.515076 P95 : 0.978645 P99 : 2.934051 P100 : 19979.000000 COUNT : 9421633 SUM : 20959636 rocksdb.numfiles.in.singlecompaction P50 : 3.172619 P95 : 4.166667 P99 : 24.700000 P100 : 26.000000 COUNT : 155 SUM : 555 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.566776 P95 : 1296.941217 P99 : 2702.444235 P100 : 789359.000000 COUNT : 129464 SUM : 29842432 rocksdb.sst.read.micros P50 : 1.585083 P95 : 4.723820 P99 : 8.987998 P100 : 18704.000000 COUNT : 6749266 SUM : 35921084 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 : 10912999 SUM : 11262214968 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 : 208695.652174 P95 : 476900.000000 P99 : 946700.000000 P100 : 950993.000000 COUNT : 149 SUM : 34024786 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 : 328 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