[2024-12-06 21:39:02.369479] Starting SPDK v25.01-pre git sha1 0354bb8e8 / DPDK 24.03.0 initialization... [2024-12-06 21:39:02.369744] [ 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_pid1574147 ] Set seed to 1733517542362714 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-06 21:39:02.493217] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-06 21:39:02.602994] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-06 21:39:02.603038] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1574147' to capture a snapshot of events at runtime. [2024-12-06 21:39:02.603049] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-06 21:39:02.603060] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-06 21:39:02.603067] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1574147 for offline analysis/debug. [2024-12-06 21:39:02.604432] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 6 21:39:11 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/06-21:39:14 ... thread 0: (1000000,1000000) ops and (339593.2,339593.2) ops/second in (2.944700,2.944700) 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/5 566.98 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 354.3 2.49 2.24 12 0.207 0 0 0.0 0.0 L1 3/3 251.75 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 251.6 251.4 1.00 0.97 1 1.002 255K 209 0.0 0.0 L2 1/0 49.01 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 17/0 881.35 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.5 198.5 0.31 0.27 1 0.315 63K 0 0.0 0.0 L4 112/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/8 97.00 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 99.7 306.2 4.27 3.91 15 0.285 432K 233 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 99.7 306.2 4.27 3.91 15 0.285 432K 233 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 239.2 239.1 1.78 1.66 3 0.594 432K 233 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 354.3 2.49 2.24 12 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 2.9 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.28 GB write, 412.85 MB/s write, 0.42 GB read, 134.46 MB/s read, 4.3 seconds Interval compaction: 1.28 GB write, 443.80 MB/s write, 0.42 GB read, 144.55 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 102368 Average: 1.9149 StdDev: 20.29 Min: 1 Median: 1.2262 Max: 3554 Percentiles: P50: 1.23 P75: 1.64 P99: 3.66 P99.9: 9.63 P99.99: 456.32 ------------------------------------------------------ [ 0, 1 ] 37301 36.438% 36.438% ####### ( 1, 2 ] 61362 59.943% 96.381% ############ ( 2, 3 ] 2076 2.028% 98.409% ( 3, 4 ] 924 0.903% 99.311% ( 4, 6 ] 404 0.395% 99.706% ( 6, 10 ] 219 0.214% 99.920% ( 10, 15 ] 42 0.041% 99.961% ( 15, 22 ] 13 0.013% 99.974% ( 34, 51 ] 1 0.001% 99.975% ( 51, 76 ] 2 0.002% 99.977% ( 110, 170 ] 7 0.007% 99.983% ( 170, 250 ] 2 0.002% 99.985% ( 250, 380 ] 4 0.004% 99.989% ( 380, 580 ] 2 0.002% 99.991% ( 870, 1300 ] 3 0.003% 99.994% ( 1300, 1900 ] 2 0.002% 99.996% ( 1900, 2900 ] 2 0.002% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 1 read latency histogram (micros): Count: 17813 Average: 1.8638 StdDev: 10.07 Min: 1 Median: 1.2501 Max: 909 Percentiles: P50: 1.25 P75: 1.65 P99: 3.52 P99.9: 9.91 P99.99: 643.42 ------------------------------------------------------ [ 0, 1 ] 6151 34.531% 34.531% ####### ( 1, 2 ] 11019 61.859% 96.390% ############ ( 2, 3 ] 381 2.139% 98.529% ( 3, 4 ] 160 0.898% 99.427% ( 4, 6 ] 50 0.281% 99.708% ( 6, 10 ] 35 0.196% 99.905% ( 10, 15 ] 10 0.056% 99.961% ( 15, 22 ] 3 0.017% 99.978% ( 380, 580 ] 2 0.011% 99.989% ( 580, 870 ] 1 0.006% 99.994% ( 870, 1300 ] 1 0.006% 100.000% ** Level 2 read latency histogram (micros): Count: 28173 Average: 2.4640 StdDev: 19.65 Min: 1 Median: 1.2116 Max: 1416 Percentiles: P50: 1.21 P75: 1.65 P99: 6.74 P99.9: 245.53 P99.99: 948.56 ------------------------------------------------------ [ 0, 1 ] 10719 38.047% 38.047% ######## ( 1, 2 ] 15916 56.494% 94.541% ########### ( 2, 3 ] 610 2.165% 96.706% ( 3, 4 ] 310 1.100% 97.806% ( 4, 6 ] 299 1.061% 98.868% ( 6, 10 ] 201 0.713% 99.581% ( 10, 15 ] 34 0.121% 99.702% ( 15, 22 ] 9 0.032% 99.734% ( 22, 34 ] 1 0.004% 99.737% ( 34, 51 ] 1 0.004% 99.741% ( 51, 76 ] 18 0.064% 99.805% ( 76, 110 ] 3 0.011% 99.815% ( 110, 170 ] 4 0.014% 99.830% ( 170, 250 ] 21 0.075% 99.904% ( 250, 380 ] 16 0.057% 99.961% ( 380, 580 ] 5 0.018% 99.979% ( 580, 870 ] 3 0.011% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 85 Average: 1905.1529 StdDev: 3033.63 Min: 0 Median: 480.0000 Max: 10768 Percentiles: P50: 480.00 P75: 2150.00 P99: 10768.00 P99.9: 10768.00 P99.99: 10768.00 ------------------------------------------------------ [ 0, 1 ] 24 28.235% 28.235% ###### ( 1, 2 ] 11 12.941% 41.176% ### ( 2, 3 ] 1 1.176% 42.353% ( 4, 6 ] 1 1.176% 43.529% ( 10, 15 ] 1 1.176% 44.706% ( 170, 250 ] 2 2.353% 47.059% ( 380, 580 ] 5 5.882% 52.941% # ( 580, 870 ] 2 2.353% 55.294% ( 870, 1300 ] 6 7.059% 62.353% # ( 1300, 1900 ] 9 10.588% 72.941% ## ( 1900, 2900 ] 7 8.235% 81.176% ## ( 2900, 4400 ] 3 3.529% 84.706% # ( 4400, 6600 ] 3 3.529% 88.235% # ( 6600, 9900 ] 7 8.235% 96.471% ## ( 9900, 14000 ] 3 3.529% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 2989.4333 StdDev: 3304.85 Min: 98 Median: 1780.0000 Max: 11434 Percentiles: P50: 1780.00 P75: 3650.00 P99: 11434.00 P99.9: 11434.00 P99.99: 11434.00 ------------------------------------------------------ ( 76, 110 ] 2 6.667% 6.667% # ( 110, 170 ] 2 6.667% 13.333% # ( 170, 250 ] 1 3.333% 16.667% # ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 3 10.000% 36.667% ## ( 1300, 1900 ] 5 16.667% 53.333% ### ( 1900, 2900 ] 5 16.667% 70.000% ### ( 2900, 4400 ] 3 10.000% 80.000% ## ( 4400, 6600 ] 1 3.333% 83.333% # ( 6600, 9900 ] 2 6.667% 90.000% # ( 9900, 14000 ] 3 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 310.71 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.371 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 333.93 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.371 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-21:39:16 ... thread 0: (1000000,2000000) ops and (350545.1,344982.2) ops/second in (2.852700,5.797400) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.17 GB 62.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 77.4 326.6 7.33 6.73 28 0.262 575K 603 0.0 0.0 L1 2/0 50.43 MB 5.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 239.6 239.2 3.42 3.32 2 1.708 831K 1386 0.0 0.0 L2 5/4 564.08 MB 1.3 0.1 0.1 0.0 0.1 0.1 0.5 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 17/10 881.35 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 198.5 198.5 0.31 0.27 1 0.315 63K 0 0.0 0.0 L4 112/0 9.66 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.63 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1187/22 97.92 GB 0.0 1.5 0.6 0.9 3.3 2.4 0.6 1.9 135.4 293.7 11.52 10.75 32 0.360 1583K 2013 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.9 3.3 2.4 0.6 1.9 135.4 293.7 11.52 10.75 32 0.360 1583K 2013 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.6 0.9 1.5 0.6 0.0 0.0 245.5 245.2 6.35 6.14 6 1.059 1583K 2013 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 353.4 5.17 4.61 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.31 GB write, 562.20 MB/s write, 1.52 GB read, 259.07 MB/s read, 11.5 seconds Interval compaction: 3.31 GB write, 583.62 MB/s write, 1.52 GB read, 268.94 MB/s read, 11.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 387284 Average: 2.2368 StdDev: 12.98 Min: 1 Median: 1.5032 Max: 3554 Percentiles: P50: 1.50 P75: 1.89 P99: 5.72 P99.9: 10.16 P99.99: 14.83 ------------------------------------------------------ [ 0, 1 ] 68075 17.578% 17.578% #### ( 1, 2 ] 249546 64.435% 82.012% ############# ( 2, 3 ] 44568 11.508% 93.520% ## ( 3, 4 ] 12643 3.265% 96.785% # ( 4, 6 ] 9955 2.570% 99.355% # ( 6, 10 ] 2100 0.542% 99.897% ( 10, 15 ] 373 0.096% 99.994% ( 15, 22 ] 47 0.012% 100.006% ( 22, 34 ] 5 0.001% 100.007% ( 34, 51 ] 10 0.003% 100.010% ( 51, 76 ] 7 0.002% 100.012% ( 110, 170 ] 10 0.003% 100.014% ( 170, 250 ] 12 0.003% 100.017% ( 250, 380 ] 6 0.002% 100.019% ( 380, 580 ] 8 0.002% 100.021% ( 580, 870 ] 4 0.001% 100.022% ( 870, 1300 ] 6 0.002% 100.023% ( 1300, 1900 ] 5 0.001% 100.025% ( 1900, 2900 ] 3 0.001% 100.026% ( 2900, 4400 ] 2 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 107354 Average: 2.4315 StdDev: 10.46 Min: 1 Median: 1.6316 Max: 1752 Percentiles: P50: 1.63 P75: 2.12 P99: 5.90 P99.9: 12.77 P99.99: 390.58 ------------------------------------------------------ [ 0, 1 ] 11612 10.817% 10.817% ## ( 1, 2 ] 66605 62.042% 72.859% ############ ( 2, 3 ] 19908 18.544% 91.403% #### ( 3, 4 ] 4319 4.023% 95.426% # ( 4, 6 ] 4034 3.758% 99.184% # ( 6, 10 ] 670 0.624% 99.808% ( 10, 15 ] 178 0.166% 99.974% ( 15, 22 ] 12 0.011% 99.985% ( 22, 34 ] 2 0.002% 99.987% ( 110, 170 ] 1 0.001% 99.988% ( 250, 380 ] 2 0.002% 99.990% ( 380, 580 ] 5 0.005% 99.994% ( 580, 870 ] 1 0.001% 99.995% ( 870, 1300 ] 2 0.002% 99.997% ( 1300, 1900 ] 3 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 28209 Average: 2.4652 StdDev: 19.63 Min: 1 Median: 1.2125 Max: 1416 Percentiles: P50: 1.21 P75: 1.66 P99: 6.77 P99.9: 245.39 P99.99: 947.01 ------------------------------------------------------ [ 0, 1 ] 10719 37.999% 37.999% ######## ( 1, 2 ] 15929 56.468% 94.466% ########### ( 2, 3 ] 629 2.230% 96.696% ( 3, 4 ] 311 1.102% 97.799% ( 4, 6 ] 300 1.063% 98.862% ( 6, 10 ] 201 0.713% 99.575% ( 10, 15 ] 35 0.124% 99.699% ( 15, 22 ] 10 0.035% 99.734% ( 22, 34 ] 1 0.004% 99.738% ( 34, 51 ] 1 0.004% 99.741% ( 51, 76 ] 18 0.064% 99.805% ( 76, 110 ] 3 0.011% 99.816% ( 110, 170 ] 4 0.014% 99.830% ( 170, 250 ] 21 0.074% 99.904% ( 250, 380 ] 16 0.057% 99.961% ( 380, 580 ] 5 0.018% 99.979% ( 580, 870 ] 3 0.011% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 63352 Average: 5.8576 StdDev: 132.01 Min: 0 Median: 1.7311 Max: 10768 Percentiles: P50: 1.73 P75: 2.43 P99: 9.60 P99.9: 401.18 P99.99: 3732.40 ------------------------------------------------------ [ 0, 1 ] 3195 5.043% 5.043% # ( 1, 2 ] 38955 61.490% 66.533% ############ ( 2, 3 ] 12476 19.693% 86.226% #### ( 3, 4 ] 3524 5.563% 91.789% # ( 4, 6 ] 3490 5.509% 97.298% # ( 6, 10 ] 1198 1.891% 99.189% ( 10, 15 ] 227 0.358% 99.547% ( 15, 22 ] 25 0.039% 99.586% ( 22, 34 ] 2 0.003% 99.590% ( 34, 51 ] 3 0.005% 99.594% ( 51, 76 ] 1 0.002% 99.596% ( 76, 110 ] 58 0.092% 99.687% ( 110, 170 ] 83 0.131% 99.818% ( 170, 250 ] 26 0.041% 99.860% ( 250, 380 ] 24 0.038% 99.897% ( 380, 580 ] 25 0.039% 99.937% ( 580, 870 ] 10 0.016% 99.953% ( 870, 1300 ] 7 0.011% 99.964% ( 1300, 1900 ] 9 0.014% 99.978% ( 1900, 2900 ] 7 0.011% 99.989% ( 2900, 4400 ] 3 0.005% 99.994% ( 4400, 6600 ] 3 0.005% 99.998% ( 6600, 9900 ] 7 0.011% 100.009% ( 9900, 14000 ] 3 0.005% 100.014% ** Level 4 read latency histogram (micros): Count: 30 Average: 2989.4333 StdDev: 3304.85 Min: 98 Median: 1780.0000 Max: 11434 Percentiles: P50: 1780.00 P75: 3650.00 P99: 11434.00 P99.9: 11434.00 P99.99: 11434.00 ------------------------------------------------------ ( 76, 110 ] 2 6.667% 6.667% # ( 110, 170 ] 2 6.667% 13.333% # ( 170, 250 ] 1 3.333% 16.667% # ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 3 10.000% 36.667% ## ( 1300, 1900 ] 5 16.667% 53.333% ### ( 1900, 2900 ] 5 16.667% 70.000% ### ( 2900, 4400 ] 3 10.000% 80.000% ## ( 4400, 6600 ] 1 3.333% 83.333% # ( 6600, 9900 ] 2 6.667% 90.000% # ( 9900, 14000 ] 3 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.0 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 326.96 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.594 H:M:S, 9.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 345.01 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.224 H:M:S, 7.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/12/06-21:39:20 ... thread 0: (1000000,3000000) ops and (301067.9,328986.7) ops/second in (3.321510,9.118910) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/11 2.15 GB 56.7 1.4 0.0 1.4 4.1 2.8 0.0 1.5 102.9 313.2 13.47 12.45 44 0.306 1407K 1421 0.0 0.0 L1 2/2 50.43 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 239.6 239.2 3.42 3.32 2 1.708 831K 1386 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 25/4 1.03 GB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 208.7 208.6 7.29 6.50 4 1.823 1527K 794 0.0 0.0 L4 148/0 9.74 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1234/17 98.90 GB 0.0 3.7 1.2 2.6 6.5 3.9 1.3 2.4 155.7 270.6 24.65 22.70 51 0.483 3878K 3625 0.0 0.0 Int 0/0 0.00 KB 0.0 3.7 1.2 2.6 6.5 3.9 1.3 2.4 155.7 270.6 24.65 22.70 51 0.483 3878K 3625 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.7 1.2 2.6 3.7 1.2 0.0 0.0 232.1 231.8 16.54 15.52 12 1.378 3878K 3625 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 349.7 8.11 7.18 39 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.51 GB write, 713.97 MB/s write, 3.75 GB read, 410.92 MB/s read, 24.6 seconds Interval compaction: 6.51 GB write, 731.27 MB/s write, 3.75 GB read, 420.87 MB/s read, 24.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 702719 Average: 2.4248 StdDev: 12.59 Min: 1 Median: 1.5996 Max: 3554 Percentiles: P50: 1.60 P75: 1.99 P99: 5.87 P99.9: 11.56 P99.99: 18.70 ------------------------------------------------------ [ 0, 1 ] 84047 11.960% 11.960% ## ( 1, 2 ] 445817 63.442% 75.402% ############# ( 2, 3 ] 111082 15.807% 91.209% ### ( 3, 4 ] 30339 4.317% 95.527% # ( 4, 6 ] 26044 3.706% 99.233% # ( 6, 10 ] 4424 0.630% 99.863% ( 10, 15 ] 846 0.120% 99.983% ( 15, 22 ] 96 0.014% 99.997% ( 22, 34 ] 9 0.001% 99.998% ( 34, 51 ] 11 0.002% 99.999% ( 51, 76 ] 10 0.001% 100.001% ( 76, 110 ] 37 0.005% 100.006% ( 110, 170 ] 46 0.007% 100.013% ( 170, 250 ] 34 0.005% 100.018% ( 250, 380 ] 22 0.003% 100.021% ( 380, 580 ] 19 0.003% 100.023% ( 580, 870 ] 8 0.001% 100.024% ( 870, 1300 ] 17 0.002% 100.027% ( 1300, 1900 ] 11 0.002% 100.028% ( 1900, 2900 ] 3 0.000% 100.029% ( 2900, 4400 ] 3 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 194728 Average: 2.5478 StdDev: 7.81 Min: 1 Median: 1.7313 Max: 1752 Percentiles: P50: 1.73 P75: 2.40 P99: 5.98 P99.9: 12.84 P99.99: 23.27 ------------------------------------------------------ [ 0, 1 ] 13074 6.714% 6.714% # ( 1, 2 ] 115257 59.189% 65.903% ############ ( 2, 3 ] 44652 22.930% 88.833% ##### ( 3, 4 ] 9939 5.104% 93.937% # ( 4, 6 ] 9949 5.109% 99.046% # ( 6, 10 ] 1467 0.753% 99.800% ( 10, 15 ] 344 0.177% 99.976% ( 15, 22 ] 26 0.013% 99.990% ( 22, 34 ] 5 0.003% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.993% ( 250, 380 ] 2 0.001% 99.994% ( 380, 580 ] 5 0.003% 99.997% ( 580, 870 ] 1 0.001% 99.997% ( 870, 1300 ] 2 0.001% 99.998% ( 1300, 1900 ] 3 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 256533 Average: 4.0569 StdDev: 67.80 Min: 0 Median: 1.7387 Max: 10768 Percentiles: P50: 1.74 P75: 2.44 P99: 9.13 P99.9: 280.89 P99.99: 829.80 ------------------------------------------------------ [ 0, 1 ] 13079 5.098% 5.098% # ( 1, 2 ] 155929 60.783% 65.882% ############ ( 2, 3 ] 52681 20.536% 86.417% #### ( 3, 4 ] 14340 5.590% 92.007% # ( 4, 6 ] 14203 5.537% 97.544% # ( 6, 10 ] 4767 1.858% 99.402% ( 10, 15 ] 560 0.218% 99.620% ( 15, 22 ] 78 0.030% 99.651% ( 22, 34 ] 13 0.005% 99.656% ( 34, 51 ] 14 0.005% 99.661% ( 51, 76 ] 14 0.005% 99.667% ( 76, 110 ] 106 0.041% 99.708% ( 110, 170 ] 312 0.122% 99.830% ( 170, 250 ] 151 0.059% 99.889% ( 250, 380 ] 124 0.048% 99.937% ( 380, 580 ] 95 0.037% 99.974% ( 580, 870 ] 48 0.019% 99.993% ( 870, 1300 ] 21 0.008% 100.001% ( 1300, 1900 ] 12 0.005% 100.005% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 3 0.001% 100.011% ( 6600, 9900 ] 7 0.003% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 30 Average: 2989.4333 StdDev: 3304.85 Min: 98 Median: 1780.0000 Max: 11434 Percentiles: P50: 1780.00 P75: 3650.00 P99: 11434.00 P99.9: 11434.00 P99.99: 11434.00 ------------------------------------------------------ ( 76, 110 ] 2 6.667% 6.667% # ( 110, 170 ] 2 6.667% 13.333% # ( 170, 250 ] 1 3.333% 16.667% # ( 580, 870 ] 3 10.000% 26.667% ## ( 870, 1300 ] 3 10.000% 36.667% ## ( 1300, 1900 ] 5 16.667% 53.333% ### ( 1900, 2900 ] 5 16.667% 70.000% ### ( 2900, 4400 ] 3 10.000% 80.000% ## ( 4400, 6600 ] 1 3.333% 83.333% # ( 6600, 9900 ] 2 6.667% 90.000% # ( 9900, 14000 ] 3 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 907.6500 StdDev: 917.72 Min: 87 Median: 347.5000 Max: 2840 Percentiles: P50: 347.50 P75: 1600.00 P99: 2833.33 P99.9: 2840.00 P99.99: 2840.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 6 30.000% 35.000% ###### ( 250, 380 ] 4 20.000% 55.000% #### ( 580, 870 ] 1 5.000% 60.000% # ( 870, 1300 ] 1 5.000% 65.000% # ( 1300, 1900 ] 4 20.000% 85.000% #### ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 9.3 total, 3.3 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 316.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.241 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 296.31 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.647 H:M:S, 19.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/06-21:39:23 ... thread 0: (1000000,4000000) ops and (309497.7,323887.9) ops/second in (3.231042,12.349952) 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/7 3.20 GB 188.8 2.4 0.0 2.4 6.2 3.8 0.0 1.6 118.7 307.2 20.70 19.27 63 0.329 2494K 2496 0.0 0.0 L1 2/2 50.43 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 239.6 239.2 3.42 3.32 2 1.708 831K 1386 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 21/0 892.37 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 208.7 208.6 7.29 6.50 4 1.823 1527K 794 0.0 0.0 L4 160/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 188.3 188.3 0.84 0.73 1 0.841 130K 0 0.0 0.0 L5 1048/0 86.31 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 1249/9 99.95 GB 0.0 4.9 1.3 3.6 8.8 5.1 1.7 2.3 154.9 274.1 32.72 30.25 71 0.461 5097K 4700 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 1.3 3.6 8.8 5.1 1.7 2.3 154.9 274.1 32.72 30.25 71 0.461 5097K 4700 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 1.3 3.6 4.9 1.3 0.0 0.0 235.0 234.7 21.57 20.36 17 1.269 5097K 4700 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 350.3 11.15 9.89 54 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.6 total, 12.4 interval Flush(GB): cumulative 3.814, interval 3.814 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.76 GB write, 713.35 MB/s write, 4.95 GB read, 403.10 MB/s read, 32.7 seconds Interval compaction: 8.76 GB write, 726.11 MB/s write, 4.95 GB read, 410.31 MB/s read, 32.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 17, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1105332 Average: 2.4299 StdDev: 13.51 Min: 1 Median: 1.5925 Max: 4375 Percentiles: P50: 1.59 P75: 1.98 P99: 5.93 P99.9: 11.73 P99.99: 20.51 ------------------------------------------------------ [ 0, 1 ] 129622 11.727% 11.727% ## ( 1, 2 ] 714018 64.598% 76.325% ############# ( 2, 3 ] 171606 15.525% 91.850% ### ( 3, 4 ] 43388 3.925% 95.775% # ( 4, 6 ] 36897 3.338% 99.113% # ( 6, 10 ] 8227 0.744% 99.858% ( 10, 15 ] 1359 0.123% 99.981% ( 15, 22 ] 134 0.012% 99.993% ( 22, 34 ] 13 0.001% 99.994% ( 34, 51 ] 12 0.001% 99.995% ( 51, 76 ] 12 0.001% 99.996% ( 76, 110 ] 75 0.007% 100.003% ( 110, 170 ] 132 0.012% 100.015% ( 170, 250 ] 66 0.006% 100.021% ( 250, 380 ] 43 0.004% 100.025% ( 380, 580 ] 46 0.004% 100.029% ( 580, 870 ] 20 0.002% 100.031% ( 870, 1300 ] 22 0.002% 100.033% ( 1300, 1900 ] 12 0.001% 100.034% ( 1900, 2900 ] 3 0.000% 100.034% ( 2900, 4400 ] 8 0.001% 100.035% ** Level 1 read latency histogram (micros): Count: 195680 Average: 2.6214 StdDev: 9.21 Min: 1 Median: 1.7304 Max: 1752 Percentiles: P50: 1.73 P75: 2.40 P99: 5.99 P99.9: 13.77 P99.99: 414.74 ------------------------------------------------------ [ 0, 1 ] 13261 6.777% 6.777% # ( 1, 2 ] 115803 59.180% 65.957% ############ ( 2, 3 ] 44772 22.880% 88.837% ##### ( 3, 4 ] 9947 5.083% 93.920% # ( 4, 6 ] 9966 5.093% 99.013% # ( 6, 10 ] 1476 0.754% 99.767% ( 10, 15 ] 344 0.176% 99.943% ( 15, 22 ] 28 0.014% 99.958% ( 22, 34 ] 5 0.003% 99.960% ( 34, 51 ] 1 0.001% 99.961% ( 76, 110 ] 4 0.002% 99.963% ( 110, 170 ] 27 0.014% 99.976% ( 170, 250 ] 15 0.008% 99.984% ( 250, 380 ] 9 0.005% 99.989% ( 380, 580 ] 14 0.007% 99.996% ( 580, 870 ] 3 0.002% 99.997% ( 870, 1300 ] 2 0.001% 99.998% ( 1300, 1900 ] 3 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 268118 Average: 3.9889 StdDev: 66.32 Min: 0 Median: 1.7384 Max: 10768 Percentiles: P50: 1.74 P75: 2.44 P99: 9.06 P99.9: 268.75 P99.99: 822.80 ------------------------------------------------------ [ 0, 1 ] 13448 5.016% 5.016% # ( 1, 2 ] 163333 60.918% 65.934% ############ ( 2, 3 ] 55304 20.627% 86.561% #### ( 3, 4 ] 14905 5.559% 92.120% # ( 4, 6 ] 14768 5.508% 97.628% # ( 6, 10 ] 4814 1.795% 99.423% ( 10, 15 ] 570 0.213% 99.636% ( 15, 22 ] 80 0.030% 99.666% ( 22, 34 ] 13 0.005% 99.671% ( 34, 51 ] 14 0.005% 99.676% ( 51, 76 ] 14 0.005% 99.681% ( 76, 110 ] 106 0.040% 99.721% ( 110, 170 ] 312 0.116% 99.837% ( 170, 250 ] 151 0.056% 99.893% ( 250, 380 ] 124 0.046% 99.940% ( 380, 580 ] 95 0.035% 99.975% ( 580, 870 ] 48 0.018% 99.993% ( 870, 1300 ] 21 0.008% 100.001% ( 1300, 1900 ] 12 0.004% 100.005% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 3 0.001% 100.010% ( 6600, 9900 ] 7 0.003% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 110 Average: 820.0545 StdDev: 2177.98 Min: 0 Median: 7.3333 Max: 11434 Percentiles: P50: 7.33 P75: 125.00 P99: 11434.00 P99.9: 11434.00 P99.99: 11434.00 ------------------------------------------------------ [ 0, 1 ] 19 17.273% 17.273% ### ( 1, 2 ] 25 22.727% 40.000% ##### ( 2, 3 ] 3 2.727% 42.727% # ( 3, 4 ] 1 0.909% 43.636% ( 4, 6 ] 3 2.727% 46.364% # ( 6, 10 ] 12 10.909% 57.273% ## ( 10, 15 ] 4 3.636% 60.909% # ( 15, 22 ] 9 8.182% 69.091% ## ( 22, 34 ] 4 3.636% 72.727% # ( 76, 110 ] 2 1.818% 74.545% ( 110, 170 ] 2 1.818% 76.364% ( 170, 250 ] 1 0.909% 77.273% ( 580, 870 ] 3 2.727% 80.000% # ( 870, 1300 ] 3 2.727% 82.727% # ( 1300, 1900 ] 5 4.545% 87.273% # ( 1900, 2900 ] 5 4.545% 91.818% # ( 2900, 4400 ] 3 2.727% 94.545% # ( 4400, 6600 ] 1 0.909% 95.455% ( 6600, 9900 ] 2 1.818% 97.273% ( 9900, 14000 ] 3 2.727% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 880.0500 StdDev: 938.85 Min: 86 Median: 336.6667 Max: 3496 Percentiles: P50: 336.67 P75: 1500.00 P99: 3496.00 P99.9: 3496.00 P99.99: 3496.00 ------------------------------------------------------ ( 76, 110 ] 7 17.500% 17.500% #### ( 110, 170 ] 7 17.500% 35.000% #### ( 250, 380 ] 9 22.500% 57.500% ##### ( 580, 870 ] 2 5.000% 62.500% # ( 870, 1300 ] 3 7.500% 70.000% ## ( 1300, 1900 ] 6 15.000% 85.000% ### ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.6 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 313.11 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.856 H:M:S, 14.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 304.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.615 H:M:S, 19.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/06-21:39:26 ... thread 0: (1000000,5000000) ops and (332819.8,325635.7) ops/second in (3.004629,15.354581) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/14 2.70 GB 6.3 3.1 0.0 3.1 7.8 4.7 0.0 1.7 123.6 307.6 26.00 24.26 79 0.329 3262K 3221 0.0 0.0 L1 14/14 1.39 GB 0.0 2.2 1.8 0.4 2.2 1.8 0.1 1.2 227.6 226.6 9.90 9.55 3 3.300 2288K 10K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 21/0 892.37 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 208.7 208.6 7.29 6.50 4 1.823 1527K 794 0.0 0.0 L4 160/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 188.3 188.3 0.84 0.73 1 0.841 130K 0 0.0 0.0 L5 1048/0 86.31 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/28 100.80 GB 0.0 7.1 2.7 4.4 11.7 7.3 1.7 2.5 163.1 270.4 44.50 41.47 88 0.506 7321K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.1 2.7 4.4 11.7 7.3 1.7 2.5 163.1 270.4 44.50 41.47 88 0.506 7321K 14K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.1 2.7 4.4 7.1 2.7 0.0 0.0 234.9 234.4 30.90 29.39 21 1.471 7321K 14K 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 352.0 13.60 12.08 67 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.6 total, 15.4 interval Flush(GB): cumulative 4.675, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.75 GB write, 772.41 MB/s write, 7.09 GB read, 466.01 MB/s read, 44.5 seconds Interval compaction: 11.75 GB write, 783.52 MB/s write, 7.09 GB read, 472.71 MB/s read, 44.5 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: 1328303 Average: 2.3775 StdDev: 13.86 Min: 1 Median: 1.5548 Max: 4542 Percentiles: P50: 1.55 P75: 1.94 P99: 5.87 P99.9: 11.94 P99.99: 97.12 ------------------------------------------------------ [ 0, 1 ] 187153 14.090% 14.090% ### ( 1, 2 ] 859700 64.722% 78.811% ############# ( 2, 3 ] 184269 13.873% 92.684% ### ( 3, 4 ] 47180 3.552% 96.236% # ( 4, 6 ] 39181 2.950% 99.185% # ( 6, 10 ] 8935 0.673% 99.858% ( 10, 15 ] 1437 0.108% 99.966% ( 15, 22 ] 156 0.012% 99.978% ( 22, 34 ] 15 0.001% 99.979% ( 34, 51 ] 15 0.001% 99.980% ( 51, 76 ] 14 0.001% 99.981% ( 76, 110 ] 187 0.014% 99.995% ( 110, 170 ] 186 0.014% 100.009% ( 170, 250 ] 87 0.007% 100.016% ( 250, 380 ] 52 0.004% 100.020% ( 380, 580 ] 59 0.004% 100.024% ( 580, 870 ] 28 0.002% 100.026% ( 870, 1300 ] 26 0.002% 100.028% ( 1300, 1900 ] 12 0.001% 100.029% ( 1900, 2900 ] 4 0.000% 100.030% ( 2900, 4400 ] 9 0.001% 100.030% ( 4400, 6600 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 208594 Average: 2.8070 StdDev: 15.09 Min: 0 Median: 1.7133 Max: 2118 Percentiles: P50: 1.71 P75: 2.36 P99: 6.45 P99.9: 99.30 P99.99: 729.08 ------------------------------------------------------ [ 0, 1 ] 15674 7.514% 7.514% ## ( 1, 2 ] 124248 59.565% 67.079% ############ ( 2, 3 ] 45982 22.044% 89.122% #### ( 3, 4 ] 10229 4.904% 94.026% # ( 4, 6 ] 10191 4.886% 98.912% # ( 6, 10 ] 1637 0.785% 99.697% ( 10, 15 ] 358 0.172% 99.868% ( 15, 22 ] 33 0.016% 99.884% ( 22, 34 ] 5 0.002% 99.886% ( 34, 51 ] 1 0.000% 99.887% ( 76, 110 ] 40 0.019% 99.906% ( 110, 170 ] 80 0.038% 99.944% ( 170, 250 ] 44 0.021% 99.965% ( 250, 380 ] 18 0.009% 99.974% ( 380, 580 ] 28 0.013% 99.988% ( 580, 870 ] 10 0.005% 99.992% ( 870, 1300 ] 9 0.004% 99.997% ( 1300, 1900 ] 5 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 268118 Average: 3.9889 StdDev: 66.32 Min: 0 Median: 1.7384 Max: 10768 Percentiles: P50: 1.74 P75: 2.44 P99: 9.06 P99.9: 268.75 P99.99: 822.80 ------------------------------------------------------ [ 0, 1 ] 13448 5.016% 5.016% # ( 1, 2 ] 163333 60.918% 65.934% ############ ( 2, 3 ] 55304 20.627% 86.561% #### ( 3, 4 ] 14905 5.559% 92.120% # ( 4, 6 ] 14768 5.508% 97.628% # ( 6, 10 ] 4814 1.795% 99.423% ( 10, 15 ] 570 0.213% 99.636% ( 15, 22 ] 80 0.030% 99.666% ( 22, 34 ] 13 0.005% 99.671% ( 34, 51 ] 14 0.005% 99.676% ( 51, 76 ] 14 0.005% 99.681% ( 76, 110 ] 106 0.040% 99.721% ( 110, 170 ] 312 0.116% 99.837% ( 170, 250 ] 151 0.056% 99.893% ( 250, 380 ] 124 0.046% 99.940% ( 380, 580 ] 95 0.035% 99.975% ( 580, 870 ] 48 0.018% 99.993% ( 870, 1300 ] 21 0.008% 100.001% ( 1300, 1900 ] 12 0.004% 100.005% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 3 0.001% 100.010% ( 6600, 9900 ] 7 0.003% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 110 Average: 820.0545 StdDev: 2177.98 Min: 0 Median: 7.3333 Max: 11434 Percentiles: P50: 7.33 P75: 125.00 P99: 11434.00 P99.9: 11434.00 P99.99: 11434.00 ------------------------------------------------------ [ 0, 1 ] 19 17.273% 17.273% ### ( 1, 2 ] 25 22.727% 40.000% ##### ( 2, 3 ] 3 2.727% 42.727% # ( 3, 4 ] 1 0.909% 43.636% ( 4, 6 ] 3 2.727% 46.364% # ( 6, 10 ] 12 10.909% 57.273% ## ( 10, 15 ] 4 3.636% 60.909% # ( 15, 22 ] 9 8.182% 69.091% ## ( 22, 34 ] 4 3.636% 72.727% # ( 76, 110 ] 2 1.818% 74.545% ( 110, 170 ] 2 1.818% 76.364% ( 170, 250 ] 1 0.909% 77.273% ( 580, 870 ] 3 2.727% 80.000% # ( 870, 1300 ] 3 2.727% 82.727% # ( 1300, 1900 ] 5 4.545% 87.273% # ( 1900, 2900 ] 5 4.545% 91.818% # ( 2900, 4400 ] 3 2.727% 94.545% # ( 4400, 6600 ] 1 0.909% 95.455% ( 6600, 9900 ] 2 1.818% 97.273% ( 9900, 14000 ] 3 2.727% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 880.0500 StdDev: 938.85 Min: 86 Median: 336.6667 Max: 3496 Percentiles: P50: 336.67 P75: 1500.00 P99: 3496.00 P99.9: 3496.00 P99.99: 3496.00 ------------------------------------------------------ ( 76, 110 ] 7 17.500% 17.500% #### ( 110, 170 ] 7 17.500% 35.000% #### ( 250, 380 ] 9 22.500% 57.500% ##### ( 580, 870 ] 2 5.000% 62.500% # ( 870, 1300 ] 3 7.500% 70.000% ## ( 1300, 1900 ] 6 15.000% 85.000% ### ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 15.6 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 315.90 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.302 H:M:S, 14.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.58 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.446 H:M:S, 14.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-21:39:32 ... thread 0: (1000000,6000000) ops and (153763.4,274498.1) ops/second in (6.503497,21.858078) 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/18 3.69 GB 0.0 4.2 0.0 4.2 9.8 5.7 0.0 1.7 130.0 305.8 32.94 30.84 98 0.336 4349K 4394 0.0 0.0 L1 14/14 1.39 GB 0.0 2.2 1.8 0.4 2.2 1.8 0.1 1.2 227.6 226.6 9.90 9.55 3 3.300 2288K 10K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 21/0 892.37 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 208.7 208.6 7.29 6.50 4 1.823 1527K 794 0.0 0.0 L4 160/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 188.3 188.3 0.84 0.73 1 0.841 130K 0 0.0 0.0 L5 1048/0 86.31 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 1261/32 101.78 GB 0.0 8.1 2.7 5.5 13.8 8.3 1.7 2.4 161.9 274.3 51.44 48.05 107 0.481 8409K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.1 2.7 5.5 13.8 8.3 1.7 2.4 161.9 274.3 51.44 48.05 107 0.481 8409K 15K 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 8.1 2.7 5.5 8.1 2.7 0.0 0.0 238.2 237.8 34.96 33.40 25 1.399 8409K 15K 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 351.7 16.48 14.65 82 0.201 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): 22.1 total, 21.9 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: 13.78 GB write, 639.01 MB/s write, 8.13 GB read, 377.26 MB/s read, 51.4 seconds Interval compaction: 13.78 GB write, 645.46 MB/s write, 8.13 GB read, 381.07 MB/s read, 51.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 22, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1857191 Average: 2.3255 StdDev: 12.85 Min: 1 Median: 1.5385 Max: 4542 Percentiles: P50: 1.54 P75: 1.92 P99: 5.80 P99.9: 11.46 P99.99: 98.08 ------------------------------------------------------ [ 0, 1 ] 268724 14.469% 14.469% ### ( 1, 2 ] 1225337 65.978% 80.447% ############# ( 2, 3 ] 241272 12.991% 93.439% ### ( 3, 4 ] 60603 3.263% 96.702% # ( 4, 6 ] 47414 2.553% 99.255% # ( 6, 10 ] 11464 0.617% 99.872% ( 10, 15 ] 1784 0.096% 99.968% ( 15, 22 ] 203 0.011% 99.979% ( 22, 34 ] 21 0.001% 99.980% ( 34, 51 ] 17 0.001% 99.981% ( 51, 76 ] 15 0.001% 99.982% ( 76, 110 ] 233 0.013% 99.994% ( 110, 170 ] 246 0.013% 100.008% ( 170, 250 ] 109 0.006% 100.014% ( 250, 380 ] 71 0.004% 100.017% ( 380, 580 ] 78 0.004% 100.022% ( 580, 870 ] 41 0.002% 100.024% ( 870, 1300 ] 32 0.002% 100.025% ( 1300, 1900 ] 12 0.001% 100.026% ( 1900, 2900 ] 5 0.000% 100.026% ( 2900, 4400 ] 11 0.001% 100.027% ( 4400, 6600 ] 1 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 332536 Average: 2.6644 StdDev: 12.92 Min: 0 Median: 1.6247 Max: 2118 Percentiles: P50: 1.62 P75: 2.09 P99: 7.28 P99.9: 108.66 P99.99: 556.37 ------------------------------------------------------ [ 0, 1 ] 36187 10.882% 10.882% ## ( 1, 2 ] 208246 62.624% 73.506% ############# ( 2, 3 ] 58390 17.559% 91.065% #### ( 3, 4 ] 12965 3.899% 94.964% # ( 4, 6 ] 12342 3.711% 98.675% # ( 6, 10 ] 3387 1.019% 99.694% ( 10, 15 ] 475 0.143% 99.836% ( 15, 22 ] 43 0.013% 99.849% ( 22, 34 ] 6 0.002% 99.851% ( 34, 51 ] 3 0.001% 99.852% ( 76, 110 ] 166 0.050% 99.902% ( 110, 170 ] 162 0.049% 99.951% ( 170, 250 ] 69 0.021% 99.971% ( 250, 380 ] 30 0.009% 99.980% ( 380, 580 ] 36 0.011% 99.991% ( 580, 870 ] 13 0.004% 99.995% ( 870, 1300 ] 9 0.003% 99.998% ( 1300, 1900 ] 5 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 268118 Average: 3.9889 StdDev: 66.32 Min: 0 Median: 1.7384 Max: 10768 Percentiles: P50: 1.74 P75: 2.44 P99: 9.06 P99.9: 268.75 P99.99: 822.80 ------------------------------------------------------ [ 0, 1 ] 13448 5.016% 5.016% # ( 1, 2 ] 163333 60.918% 65.934% ############ ( 2, 3 ] 55304 20.627% 86.561% #### ( 3, 4 ] 14905 5.559% 92.120% # ( 4, 6 ] 14768 5.508% 97.628% # ( 6, 10 ] 4814 1.795% 99.423% ( 10, 15 ] 570 0.213% 99.636% ( 15, 22 ] 80 0.030% 99.666% ( 22, 34 ] 13 0.005% 99.671% ( 34, 51 ] 14 0.005% 99.676% ( 51, 76 ] 14 0.005% 99.681% ( 76, 110 ] 106 0.040% 99.721% ( 110, 170 ] 312 0.116% 99.837% ( 170, 250 ] 151 0.056% 99.893% ( 250, 380 ] 124 0.046% 99.940% ( 380, 580 ] 95 0.035% 99.975% ( 580, 870 ] 48 0.018% 99.993% ( 870, 1300 ] 21 0.008% 100.001% ( 1300, 1900 ] 12 0.004% 100.005% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 3 0.001% 100.010% ( 6600, 9900 ] 7 0.003% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 110 Average: 820.0545 StdDev: 2177.98 Min: 0 Median: 7.3333 Max: 11434 Percentiles: P50: 7.33 P75: 125.00 P99: 11434.00 P99.9: 11434.00 P99.99: 11434.00 ------------------------------------------------------ [ 0, 1 ] 19 17.273% 17.273% ### ( 1, 2 ] 25 22.727% 40.000% ##### ( 2, 3 ] 3 2.727% 42.727% # ( 3, 4 ] 1 0.909% 43.636% ( 4, 6 ] 3 2.727% 46.364% # ( 6, 10 ] 12 10.909% 57.273% ## ( 10, 15 ] 4 3.636% 60.909% # ( 15, 22 ] 9 8.182% 69.091% ## ( 22, 34 ] 4 3.636% 72.727% # ( 76, 110 ] 2 1.818% 74.545% ( 110, 170 ] 2 1.818% 76.364% ( 170, 250 ] 1 0.909% 77.273% ( 580, 870 ] 3 2.727% 80.000% # ( 870, 1300 ] 3 2.727% 82.727% # ( 1300, 1900 ] 5 4.545% 87.273% # ( 1900, 2900 ] 5 4.545% 91.818% # ( 2900, 4400 ] 3 2.727% 94.545% # ( 4400, 6600 ] 1 0.909% 95.455% ( 6600, 9900 ] 2 1.818% 97.273% ( 9900, 14000 ] 3 2.727% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 880.0500 StdDev: 938.85 Min: 86 Median: 336.6667 Max: 3496 Percentiles: P50: 336.67 P75: 1500.00 P99: 3496.00 P99.9: 3496.00 P99.99: 3496.00 ------------------------------------------------------ ( 76, 110 ] 7 17.500% 17.500% #### ( 110, 170 ] 7 17.500% 35.000% #### ( 250, 380 ] 9 22.500% 57.500% ##### ( 580, 870 ] 2 5.000% 62.500% # ( 870, 1300 ] 3 7.500% 70.000% ## ( 1300, 1900 ] 6 15.000% 85.000% ### ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 22.1 total, 6.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 267.43 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.036 H:M:S, 27.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 151.33 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.735 H:M:S, 57.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/06-21:39:45 ... thread 0: (1000000,7000000) ops and (81775.0,205358.4) ops/second in (12.228676,34.086754) 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/14 4.66 GB 207.0 6.8 0.0 6.8 13.4 6.6 0.0 2.0 149.3 295.7 46.40 43.44 119 0.390 7034K 11K 0.0 0.0 L1 14/14 1.39 GB 0.0 2.2 1.8 0.4 2.2 1.8 0.1 1.2 227.6 226.6 9.90 9.55 3 3.300 2288K 10K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 21/0 892.37 MB 0.9 1.5 0.6 0.9 1.5 0.6 0.0 2.4 208.7 208.6 7.29 6.50 4 1.823 1527K 794 0.0 0.0 L4 160/0 9.52 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.4 1.0 188.3 188.3 0.84 0.73 1 0.841 130K 0 0.0 0.0 L5 1048/0 86.31 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 1262/28 102.76 GB 0.0 10.7 2.7 8.0 17.3 9.3 1.7 2.6 169.1 273.5 64.90 60.65 128 0.507 11M 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.7 2.7 8.0 17.3 9.3 1.7 2.6 169.1 273.5 64.90 60.65 128 0.507 11M 22K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.7 2.7 8.0 10.7 2.6 0.0 0.0 241.4 240.9 45.46 43.37 30 1.515 11M 22K 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 349.8 19.45 17.28 98 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): 34.3 total, 34.1 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.34 GB write, 517.48 MB/s write, 10.72 GB read, 319.86 MB/s read, 64.9 seconds Interval compaction: 17.34 GB write, 520.83 MB/s write, 10.72 GB read, 321.93 MB/s read, 64.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 22, total-stops: 22, interval: 44 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2924158 Average: 2.7576 StdDev: 16.19 Min: 0 Median: 1.5344 Max: 4542 Percentiles: P50: 1.53 P75: 1.91 P99: 6.77 P99.9: 150.65 P99.99: 313.40 ------------------------------------------------------ [ 0, 1 ] 421780 14.424% 14.424% ### ( 1, 2 ] 1946742 66.574% 80.998% ############# ( 2, 3 ] 365861 12.512% 93.510% ### ( 3, 4 ] 89568 3.063% 96.573% # ( 4, 6 ] 66758 2.283% 98.856% ( 6, 10 ] 21863 0.748% 99.604% ( 10, 15 ] 2615 0.089% 99.693% ( 15, 22 ] 325 0.011% 99.704% ( 22, 34 ] 26 0.001% 99.705% ( 34, 51 ] 22 0.001% 99.706% ( 51, 76 ] 60 0.002% 99.708% ( 76, 110 ] 2758 0.094% 99.802% ( 110, 170 ] 4215 0.144% 99.946% ( 170, 250 ] 999 0.034% 99.981% ( 250, 380 ] 561 0.019% 100.000% ( 380, 580 ] 450 0.015% 100.015% ( 580, 870 ] 189 0.006% 100.022% ( 870, 1300 ] 53 0.002% 100.023% ( 1300, 1900 ] 16 0.001% 100.024% ( 1900, 2900 ] 16 0.001% 100.025% ( 2900, 4400 ] 13 0.000% 100.025% ( 4400, 6600 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 547087 Average: 2.7750 StdDev: 13.20 Min: 0 Median: 1.5981 Max: 2677 Percentiles: P50: 1.60 P75: 1.99 P99: 8.05 P99.9: 147.37 P99.99: 535.12 ------------------------------------------------------ [ 0, 1 ] 62650 11.452% 11.452% ## ( 1, 2 ] 352581 64.447% 75.899% ############# ( 2, 3 ] 88002 16.086% 91.984% ### ( 3, 4 ] 18308 3.346% 95.331% # ( 4, 6 ] 16761 3.064% 98.394% # ( 6, 10 ] 6460 1.181% 99.575% ( 10, 15 ] 697 0.127% 99.702% ( 15, 22 ] 73 0.013% 99.716% ( 22, 34 ] 8 0.001% 99.717% ( 34, 51 ] 4 0.001% 99.718% ( 76, 110 ] 654 0.120% 99.838% ( 110, 170 ] 549 0.100% 99.938% ( 170, 250 ] 155 0.028% 99.966% ( 250, 380 ] 76 0.014% 99.980% ( 380, 580 ] 70 0.013% 99.993% ( 580, 870 ] 19 0.003% 99.996% ( 870, 1300 ] 12 0.002% 99.999% ( 1300, 1900 ] 5 0.001% 99.999% ( 1900, 2900 ] 3 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 268118 Average: 3.9889 StdDev: 66.32 Min: 0 Median: 1.7384 Max: 10768 Percentiles: P50: 1.74 P75: 2.44 P99: 9.06 P99.9: 268.75 P99.99: 822.80 ------------------------------------------------------ [ 0, 1 ] 13448 5.016% 5.016% # ( 1, 2 ] 163333 60.918% 65.934% ############ ( 2, 3 ] 55304 20.627% 86.561% #### ( 3, 4 ] 14905 5.559% 92.120% # ( 4, 6 ] 14768 5.508% 97.628% # ( 6, 10 ] 4814 1.795% 99.423% ( 10, 15 ] 570 0.213% 99.636% ( 15, 22 ] 80 0.030% 99.666% ( 22, 34 ] 13 0.005% 99.671% ( 34, 51 ] 14 0.005% 99.676% ( 51, 76 ] 14 0.005% 99.681% ( 76, 110 ] 106 0.040% 99.721% ( 110, 170 ] 312 0.116% 99.837% ( 170, 250 ] 151 0.056% 99.893% ( 250, 380 ] 124 0.046% 99.940% ( 380, 580 ] 95 0.035% 99.975% ( 580, 870 ] 48 0.018% 99.993% ( 870, 1300 ] 21 0.008% 100.001% ( 1300, 1900 ] 12 0.004% 100.005% ( 1900, 2900 ] 7 0.003% 100.008% ( 2900, 4400 ] 3 0.001% 100.009% ( 4400, 6600 ] 3 0.001% 100.010% ( 6600, 9900 ] 7 0.003% 100.013% ( 9900, 14000 ] 3 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 110 Average: 820.0545 StdDev: 2177.98 Min: 0 Median: 7.3333 Max: 11434 Percentiles: P50: 7.33 P75: 125.00 P99: 11434.00 P99.9: 11434.00 P99.99: 11434.00 ------------------------------------------------------ [ 0, 1 ] 19 17.273% 17.273% ### ( 1, 2 ] 25 22.727% 40.000% ##### ( 2, 3 ] 3 2.727% 42.727% # ( 3, 4 ] 1 0.909% 43.636% ( 4, 6 ] 3 2.727% 46.364% # ( 6, 10 ] 12 10.909% 57.273% ## ( 10, 15 ] 4 3.636% 60.909% # ( 15, 22 ] 9 8.182% 69.091% ## ( 22, 34 ] 4 3.636% 72.727% # ( 76, 110 ] 2 1.818% 74.545% ( 110, 170 ] 2 1.818% 76.364% ( 170, 250 ] 1 0.909% 77.273% ( 580, 870 ] 3 2.727% 80.000% # ( 870, 1300 ] 3 2.727% 82.727% # ( 1300, 1900 ] 5 4.545% 87.273% # ( 1900, 2900 ] 5 4.545% 91.818% # ( 2900, 4400 ] 3 2.727% 94.545% # ( 4400, 6600 ] 1 0.909% 95.455% ( 6600, 9900 ] 2 1.818% 97.273% ( 9900, 14000 ] 3 2.727% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 880.0500 StdDev: 938.85 Min: 86 Median: 336.6667 Max: 3496 Percentiles: P50: 336.67 P75: 1500.00 P99: 3496.00 P99.9: 3496.00 P99.99: 3496.00 ------------------------------------------------------ ( 76, 110 ] 7 17.500% 17.500% #### ( 110, 170 ] 7 17.500% 35.000% #### ( 250, 380 ] 9 22.500% 57.500% ##### ( 580, 870 ] 2 5.000% 62.500% # ( 870, 1300 ] 3 7.500% 70.000% ## ( 1300, 1900 ] 6 15.000% 85.000% ### ( 1900, 2900 ] 5 12.500% 97.500% ### ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 34.3 total, 12.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 200.80 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.225 H:M:S, 44.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 80.48 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:9.189 H:M:S, 75.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-21:39:50 ... thread 0: (1000000,8000000) ops and (182159.9,202140.5) ops/second in (5.489682,39.576436) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 2.94 GB 56.7 7.3 0.0 7.3 14.9 7.6 0.0 2.0 141.9 288.3 52.84 48.11 133 0.397 7610K 12K 0.0 0.0 L1 16/16 1.45 GB 0.0 6.2 4.5 1.7 6.2 4.4 0.1 1.4 215.1 212.2 29.70 27.75 4 7.424 6485K 84K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.0 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 14/1 926.44 MB 0.9 1.5 0.6 0.9 1.5 0.6 2.5 2.4 208.7 208.6 7.29 6.50 4 1.823 1527K 794 0.0 0.0 L4 165/10 10.33 GB 1.0 2.3 1.8 0.5 2.3 1.8 1.2 1.3 123.1 122.6 18.84 11.08 14 1.346 2295K 9070 0.0 0.0 L5 1068/0 87.97 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/35 103.60 GB 0.0 17.4 7.0 10.5 24.9 14.4 9.2 3.3 163.4 233.4 109.14 93.88 156 0.700 18M 106K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.4 7.0 10.5 24.9 14.4 9.2 3.3 163.4 233.4 109.14 93.88 156 0.700 18M 106K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.4 7.0 10.5 17.3 6.8 0.0 0.0 208.6 207.3 85.50 74.08 46 1.859 18M 106K 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 327.8 23.64 19.80 110 0.215 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.8 total, 39.6 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.88 GB write, 640.10 MB/s write, 17.42 GB read, 448.14 MB/s read, 109.1 seconds Interval compaction: 24.88 GB write, 643.67 MB/s write, 17.42 GB read, 450.64 MB/s read, 109.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 43, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 28, total-stops: 43, interval: 71 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3306996 Average: 2.8406 StdDev: 21.29 Min: 0 Median: 1.5546 Max: 6269 Percentiles: P50: 1.55 P75: 1.94 P99: 7.10 P99.9: 148.76 P99.99: 333.10 ------------------------------------------------------ [ 0, 1 ] 448775 13.570% 13.570% ### ( 1, 2 ] 2172143 65.683% 79.254% ############# ( 2, 3 ] 445547 13.473% 92.727% ### ( 3, 4 ] 110575 3.344% 96.070% # ( 4, 6 ] 89166 2.696% 98.767% # ( 6, 10 ] 28051 0.848% 99.615% ( 10, 15 ] 3321 0.100% 99.715% ( 15, 22 ] 391 0.012% 99.727% ( 22, 34 ] 35 0.001% 99.728% ( 34, 51 ] 23 0.001% 99.729% ( 51, 76 ] 61 0.002% 99.731% ( 76, 110 ] 2802 0.085% 99.815% ( 110, 170 ] 4336 0.131% 99.946% ( 170, 250 ] 1052 0.032% 99.978% ( 250, 380 ] 609 0.018% 99.997% ( 380, 580 ] 510 0.015% 100.012% ( 580, 870 ] 244 0.007% 100.020% ( 870, 1300 ] 92 0.003% 100.022% ( 1300, 1900 ] 47 0.001% 100.024% ( 1900, 2900 ] 27 0.001% 100.025% ( 2900, 4400 ] 37 0.001% 100.026% ( 4400, 6600 ] 8 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 992363 Average: 4.4335 StdDev: 63.01 Min: 0 Median: 1.7780 Max: 8382 Percentiles: P50: 1.78 P75: 2.57 P99: 9.01 P99.9: 110.33 P99.99: 240.04 ------------------------------------------------------ [ 0, 1 ] 68177 6.870% 6.870% # ( 1, 2 ] 550111 55.434% 62.305% ########### ( 2, 3 ] 221008 22.271% 84.576% #### ( 3, 4 ] 62687 6.317% 90.892% # ( 4, 6 ] 66395 6.691% 97.583% # ( 6, 10 ] 18695 1.884% 99.467% ( 10, 15 ] 3189 0.321% 99.788% ( 15, 22 ] 359 0.036% 99.824% ( 22, 34 ] 39 0.004% 99.828% ( 34, 51 ] 10 0.001% 99.829% ( 51, 76 ] 6 0.001% 99.830% ( 76, 110 ] 691 0.070% 99.900% ( 110, 170 ] 663 0.067% 99.966% ( 170, 250 ] 267 0.027% 99.993% ( 250, 380 ] 223 0.022% 100.016% ( 380, 580 ] 288 0.029% 100.045% ( 580, 870 ] 220 0.022% 100.067% ( 870, 1300 ] 150 0.015% 100.082% ( 1300, 1900 ] 90 0.009% 100.091% ( 1900, 2900 ] 131 0.013% 100.104% ( 2900, 4400 ] 122 0.012% 100.117% ( 4400, 6600 ] 19 0.002% 100.119% ( 6600, 9900 ] 10 0.001% 100.120% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 352061 Average: 8.9957 StdDev: 111.88 Min: 0 Median: 1.7941 Max: 10768 Percentiles: P50: 1.79 P75: 2.60 P99: 13.30 P99.9: 1200.47 P99.99: 2860.69 ------------------------------------------------------ [ 0, 1 ] 14915 4.236% 4.236% # ( 1, 2 ] 202879 57.626% 61.863% ############ ( 2, 3 ] 77026 21.879% 83.741% #### ( 3, 4 ] 24548 6.973% 90.714% # ( 4, 6 ] 21337 6.061% 96.774% # ( 6, 10 ] 7154 2.032% 98.806% ( 10, 15 ] 1031 0.293% 99.099% ( 15, 22 ] 155 0.044% 99.143% ( 22, 34 ] 21 0.006% 99.149% ( 34, 51 ] 16 0.005% 99.154% ( 51, 76 ] 15 0.004% 99.158% ( 76, 110 ] 120 0.034% 99.192% ( 110, 170 ] 424 0.120% 99.313% ( 170, 250 ] 374 0.106% 99.419% ( 250, 380 ] 461 0.131% 99.550% ( 380, 580 ] 550 0.156% 99.706% ( 580, 870 ] 447 0.127% 99.833% ( 870, 1300 ] 307 0.087% 99.920% ( 1300, 1900 ] 143 0.041% 99.961% ( 1900, 2900 ] 107 0.030% 99.991% ( 2900, 4400 ] 104 0.030% 100.021% ( 4400, 6600 ] 18 0.005% 100.026% ( 6600, 9900 ] 8 0.002% 100.028% ( 9900, 14000 ] 3 0.001% 100.029% ** Level 4 read latency histogram (micros): Count: 44135 Average: 7.8032 StdDev: 133.89 Min: 0 Median: 2.0624 Max: 11434 Percentiles: P50: 2.06 P75: 2.91 P99: 9.33 P99.9: 980.10 P99.99: 1941.89 ------------------------------------------------------ [ 0, 1 ] 351 0.795% 0.795% ( 1, 2 ] 20904 47.364% 48.159% ######### ( 2, 3 ] 13021 29.503% 77.662% ###### ( 3, 4 ] 4453 10.089% 87.751% ## ( 4, 6 ] 4430 10.037% 97.789% ## ( 6, 10 ] 643 1.457% 99.245% ( 10, 15 ] 144 0.326% 99.572% ( 15, 22 ] 25 0.057% 99.628% ( 22, 34 ] 8 0.018% 99.647% ( 34, 51 ] 1 0.002% 99.649% ( 76, 110 ] 9 0.020% 99.669% ( 110, 170 ] 10 0.023% 99.692% ( 170, 250 ] 30 0.068% 99.760% ( 250, 380 ] 11 0.025% 99.785% ( 380, 580 ] 21 0.048% 99.832% ( 580, 870 ] 25 0.057% 99.889% ( 870, 1300 ] 19 0.043% 99.932% ( 1300, 1900 ] 25 0.057% 99.989% ( 1900, 2900 ] 14 0.032% 100.020% ( 2900, 4400 ] 9 0.020% 100.041% ( 4400, 6600 ] 1 0.002% 100.043% ( 6600, 9900 ] 2 0.005% 100.048% ( 9900, 14000 ] 3 0.007% 100.054% ** Level 5 read latency histogram (micros): Count: 140 Average: 1146.3286 StdDev: 1248.56 Min: 84 Median: 533.8462 Max: 4965 Percentiles: P50: 533.85 P75: 1787.50 P99: 4965.00 P99.9: 4965.00 P99.99: 4965.00 ------------------------------------------------------ ( 76, 110 ] 11 7.857% 7.857% ## ( 110, 170 ] 19 13.571% 21.429% ### ( 170, 250 ] 12 8.571% 30.000% ## ( 250, 380 ] 18 12.857% 42.857% ### ( 380, 580 ] 13 9.286% 52.143% ## ( 580, 870 ] 10 7.143% 59.286% # ( 870, 1300 ] 9 6.429% 65.714% # ( 1300, 1900 ] 16 11.429% 77.143% ## ( 1900, 2900 ] 17 12.143% 89.286% ## ( 2900, 4400 ] 11 7.857% 97.143% ## ( 4400, 6600 ] 4 2.857% 100.000% # ** DB Stats ** Uptime(secs): 39.8 total, 5.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 197.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:17.896 H:M:S, 45.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 179.28 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.671 H:M:S, 48.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/06-21:39:53 ... thread 0: (1000000,9000000) ops and (328682.6,211174.0) ops/second in (3.042449,42.618885) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/4 3.87 GB 176.3 8.1 0.0 8.1 16.5 8.5 0.0 1.9 141.0 289.3 58.52 53.41 149 0.393 8377K 13K 0.0 0.0 L1 16/16 1.45 GB 0.0 6.2 4.5 1.7 6.2 4.4 0.1 1.4 215.1 212.2 29.70 27.75 4 7.424 6485K 84K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 3.0 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 13/0 909.23 MB 0.9 1.5 0.6 0.9 1.5 0.6 2.5 2.4 208.7 208.6 7.29 6.50 4 1.823 1527K 794 0.0 0.0 L4 157/0 9.67 GB 1.0 3.1 1.8 1.3 3.1 1.8 1.2 1.7 131.7 131.0 23.97 14.83 15 1.598 2505K 9070 0.0 0.0 L5 1074/0 88.65 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1275/20 104.51 GB 0.0 19.0 7.0 12.0 27.3 15.3 9.9 3.2 162.0 233.5 119.94 102.92 173 0.693 19M 107K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.0 7.0 12.0 27.3 15.3 9.9 3.2 162.0 233.5 119.94 102.92 173 0.693 19M 107K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.0 7.0 12.0 18.9 6.9 0.0 0.0 207.7 206.5 93.52 80.67 50 1.870 19M 107K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 329.0 26.43 22.26 123 0.215 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 42.8 total, 42.6 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.35 GB write, 653.72 MB/s write, 18.97 GB read, 453.48 MB/s read, 119.9 seconds Interval compaction: 27.35 GB write, 657.11 MB/s write, 18.97 GB read, 455.83 MB/s read, 119.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 24, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 24, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 28, total-stops: 46, interval: 74 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3636454 Average: 2.7948 StdDev: 20.61 Min: 0 Median: 1.5577 Max: 6269 Percentiles: P50: 1.56 P75: 1.94 P99: 7.01 P99.9: 143.43 P99.99: 312.42 ------------------------------------------------------ [ 0, 1 ] 483695 13.301% 13.301% ### ( 1, 2 ] 2393132 65.809% 79.111% ############# ( 2, 3 ] 496831 13.663% 92.773% ### ( 3, 4 ] 121019 3.328% 96.101% # ( 4, 6 ] 97472 2.680% 98.782% # ( 6, 10 ] 31300 0.861% 99.642% ( 10, 15 ] 3618 0.099% 99.742% ( 15, 22 ] 407 0.011% 99.753% ( 22, 34 ] 36 0.001% 99.754% ( 34, 51 ] 25 0.001% 99.755% ( 51, 76 ] 61 0.002% 99.756% ( 76, 110 ] 2802 0.077% 99.833% ( 110, 170 ] 4342 0.119% 99.953% ( 170, 250 ] 1057 0.029% 99.982% ( 250, 380 ] 611 0.017% 99.999% ( 380, 580 ] 516 0.014% 100.013% ( 580, 870 ] 248 0.007% 100.020% ( 870, 1300 ] 99 0.003% 100.022% ( 1300, 1900 ] 48 0.001% 100.024% ( 1900, 2900 ] 27 0.001% 100.025% ( 2900, 4400 ] 39 0.001% 100.026% ( 4400, 6600 ] 8 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 992363 Average: 4.4335 StdDev: 63.01 Min: 0 Median: 1.7780 Max: 8382 Percentiles: P50: 1.78 P75: 2.57 P99: 9.01 P99.9: 110.33 P99.99: 240.04 ------------------------------------------------------ [ 0, 1 ] 68177 6.870% 6.870% # ( 1, 2 ] 550111 55.434% 62.305% ########### ( 2, 3 ] 221008 22.271% 84.576% #### ( 3, 4 ] 62687 6.317% 90.892% # ( 4, 6 ] 66395 6.691% 97.583% # ( 6, 10 ] 18695 1.884% 99.467% ( 10, 15 ] 3189 0.321% 99.788% ( 15, 22 ] 359 0.036% 99.824% ( 22, 34 ] 39 0.004% 99.828% ( 34, 51 ] 10 0.001% 99.829% ( 51, 76 ] 6 0.001% 99.830% ( 76, 110 ] 691 0.070% 99.900% ( 110, 170 ] 663 0.067% 99.966% ( 170, 250 ] 267 0.027% 99.993% ( 250, 380 ] 223 0.022% 100.016% ( 380, 580 ] 288 0.029% 100.045% ( 580, 870 ] 220 0.022% 100.067% ( 870, 1300 ] 150 0.015% 100.082% ( 1300, 1900 ] 90 0.009% 100.091% ( 1900, 2900 ] 131 0.013% 100.104% ( 2900, 4400 ] 122 0.012% 100.117% ( 4400, 6600 ] 19 0.002% 100.119% ( 6600, 9900 ] 10 0.001% 100.120% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 352328 Average: 8.9910 StdDev: 111.84 Min: 0 Median: 1.7943 Max: 10768 Percentiles: P50: 1.79 P75: 2.60 P99: 13.29 P99.9: 1200.09 P99.99: 2860.44 ------------------------------------------------------ [ 0, 1 ] 14917 4.234% 4.234% # ( 1, 2 ] 202998 57.616% 61.850% ############ ( 2, 3 ] 77137 21.894% 83.744% #### ( 3, 4 ] 24563 6.972% 90.715% # ( 4, 6 ] 21352 6.060% 96.775% # ( 6, 10 ] 7159 2.032% 98.807% ( 10, 15 ] 1031 0.293% 99.100% ( 15, 22 ] 155 0.044% 99.144% ( 22, 34 ] 21 0.006% 99.150% ( 34, 51 ] 16 0.005% 99.154% ( 51, 76 ] 15 0.004% 99.159% ( 76, 110 ] 120 0.034% 99.193% ( 110, 170 ] 424 0.120% 99.313% ( 170, 250 ] 374 0.106% 99.419% ( 250, 380 ] 461 0.131% 99.550% ( 380, 580 ] 550 0.156% 99.706% ( 580, 870 ] 447 0.127% 99.833% ( 870, 1300 ] 307 0.087% 99.920% ( 1300, 1900 ] 143 0.041% 99.961% ( 1900, 2900 ] 107 0.030% 99.991% ( 2900, 4400 ] 104 0.030% 100.021% ( 4400, 6600 ] 18 0.005% 100.026% ( 6600, 9900 ] 8 0.002% 100.028% ( 9900, 14000 ] 3 0.001% 100.029% ** Level 4 read latency histogram (micros): Count: 44175 Average: 8.1657 StdDev: 135.47 Min: 0 Median: 2.0627 Max: 11434 Percentiles: P50: 2.06 P75: 2.91 P99: 9.46 P99.9: 1101.13 P99.99: 2005.50 ------------------------------------------------------ [ 0, 1 ] 356 0.806% 0.806% ( 1, 2 ] 20915 47.346% 48.152% ######### ( 2, 3 ] 13023 29.480% 77.632% ###### ( 3, 4 ] 4453 10.080% 87.713% ## ( 4, 6 ] 4430 10.028% 97.741% ## ( 6, 10 ] 643 1.456% 99.196% ( 10, 15 ] 144 0.326% 99.522% ( 15, 22 ] 25 0.057% 99.579% ( 22, 34 ] 8 0.018% 99.597% ( 34, 51 ] 1 0.002% 99.599% ( 76, 110 ] 9 0.020% 99.620% ( 110, 170 ] 13 0.029% 99.649% ( 170, 250 ] 32 0.072% 99.722% ( 250, 380 ] 13 0.029% 99.751% ( 380, 580 ] 27 0.061% 99.812% ( 580, 870 ] 27 0.061% 99.873% ( 870, 1300 ] 22 0.050% 99.923% ( 1300, 1900 ] 28 0.063% 99.986% ( 1900, 2900 ] 15 0.034% 100.020% ( 2900, 4400 ] 9 0.020% 100.041% ( 4400, 6600 ] 1 0.002% 100.043% ( 6600, 9900 ] 2 0.005% 100.048% ( 9900, 14000 ] 3 0.007% 100.054% ** Level 5 read latency histogram (micros): Count: 140 Average: 1146.3286 StdDev: 1248.56 Min: 84 Median: 533.8462 Max: 4965 Percentiles: P50: 533.85 P75: 1787.50 P99: 4965.00 P99.9: 4965.00 P99.99: 4965.00 ------------------------------------------------------ ( 76, 110 ] 11 7.857% 7.857% ## ( 110, 170 ] 19 13.571% 21.429% ### ( 170, 250 ] 12 8.571% 30.000% ## ( 250, 380 ] 18 12.857% 42.857% ### ( 380, 580 ] 13 9.286% 52.143% ## ( 580, 870 ] 10 7.143% 59.286% # ( 870, 1300 ] 9 6.429% 65.714% # ( 1300, 1900 ] 16 11.429% 77.143% ## ( 1900, 2900 ] 17 12.143% 89.286% ## ( 2900, 4400 ] 11 7.857% 97.143% ## ( 4400, 6600 ] 4 2.857% 100.000% # ** DB Stats ** Uptime(secs): 42.8 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 206.75 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:18.348 H:M:S, 42.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.49 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.453 H:M:S, 14.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-21:40:08 ... thread 0: (1000000,10000000) ops and (68128.7,174529.2) ops/second in (14.678104,57.296989) 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/11 2.70 GB 0.0 10.3 0.0 10.3 19.7 9.5 0.0 2.1 148.2 284.6 70.97 64.81 167 0.425 10M 22K 0.0 0.0 L1 20/20 2.18 GB 0.0 9.8 6.6 3.2 9.7 6.5 0.1 1.5 211.0 208.2 47.70 43.93 5 9.541 8715K 84K 0.0 0.0 L2 1/0 69.79 MB 0.7 0.1 0.1 0.0 0.1 0.1 4.4 1.8 240.0 240.0 0.46 0.43 1 0.464 113K 24 0.0 0.0 L3 20/0 986.85 MB 1.0 2.7 1.0 1.6 2.6 1.0 3.4 2.6 174.3 173.2 15.58 12.08 10 1.558 2740K 18K 0.0 0.0 L4 154/0 9.45 GB 1.0 4.8 3.0 1.7 4.7 3.0 1.2 1.6 136.1 135.4 35.81 23.34 30 1.194 4238K 16K 0.0 0.0 L5 1090/0 90.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/31 105.42 GB 0.0 27.6 10.7 16.9 36.9 20.0 13.6 3.9 165.9 221.6 170.53 144.58 213 0.801 26M 141K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.6 10.7 16.9 36.9 20.0 13.6 3.9 165.9 221.6 170.53 144.58 213 0.801 26M 141K 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 27.6 10.7 16.9 27.4 10.5 0.0 0.0 200.3 198.9 141.18 119.72 76 1.858 26M 141K 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 330.5 29.35 24.86 137 0.214 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 57.5 total, 57.3 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: 36.90 GB write, 656.96 MB/s write, 27.62 GB read, 491.73 MB/s read, 170.5 seconds Interval compaction: 36.90 GB write, 659.49 MB/s write, 27.62 GB read, 493.63 MB/s read, 170.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 26, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 26, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 49, pending-compaction-bytes-delays: 30, pending-compaction-bytes-stops: 0, total-delays: 56, total-stops: 49, interval: 105 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4565739 Average: 3.0403 StdDev: 25.88 Min: 0 Median: 1.5646 Max: 11975 Percentiles: P50: 1.56 P75: 1.95 P99: 7.73 P99.9: 161.04 P99.99: 424.54 ------------------------------------------------------ [ 0, 1 ] 595356 13.040% 13.040% ### ( 1, 2 ] 2989024 65.466% 78.506% ############# ( 2, 3 ] 630339 13.806% 92.312% ### ( 3, 4 ] 157575 3.451% 95.763% # ( 4, 6 ] 129459 2.835% 98.599% # ( 6, 10 ] 42423 0.929% 99.528% ( 10, 15 ] 4969 0.109% 99.637% ( 15, 22 ] 684 0.015% 99.652% ( 22, 34 ] 46 0.001% 99.653% ( 34, 51 ] 27 0.001% 99.653% ( 51, 76 ] 67 0.001% 99.655% ( 76, 110 ] 4602 0.101% 99.755% ( 110, 170 ] 7764 0.170% 99.925% ( 170, 250 ] 1713 0.038% 99.963% ( 250, 380 ] 1046 0.023% 99.986% ( 380, 580 ] 855 0.019% 100.005% ( 580, 870 ] 456 0.010% 100.015% ( 870, 1300 ] 191 0.004% 100.019% ( 1300, 1900 ] 90 0.002% 100.021% ( 1900, 2900 ] 45 0.001% 100.022% ( 2900, 4400 ] 65 0.001% 100.023% ( 4400, 6600 ] 16 0.000% 100.024% ( 6600, 9900 ] 3 0.000% 100.024% ( 9900, 14000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1702218 Average: 4.2516 StdDev: 52.55 Min: 0 Median: 1.7708 Max: 8382 Percentiles: P50: 1.77 P75: 2.58 P99: 9.14 P99.9: 120.08 P99.99: 200.28 ------------------------------------------------------ [ 0, 1 ] 120198 7.061% 7.061% # ( 1, 2 ] 948271 55.708% 62.769% ########### ( 2, 3 ] 361864 21.258% 84.028% #### ( 3, 4 ] 109838 6.453% 90.480% # ( 4, 6 ] 116996 6.873% 97.353% # ( 6, 10 ] 35761 2.101% 99.454% ( 10, 15 ] 5233 0.307% 99.762% ( 15, 22 ] 675 0.040% 99.801% ( 22, 34 ] 58 0.003% 99.805% ( 34, 51 ] 13 0.001% 99.805% ( 51, 76 ] 32 0.002% 99.807% ( 76, 110 ] 1311 0.077% 99.884% ( 110, 170 ] 1582 0.093% 99.977% ( 170, 250 ] 570 0.033% 100.011% ( 250, 380 ] 550 0.032% 100.043% ( 380, 580 ] 586 0.034% 100.078% ( 580, 870 ] 444 0.026% 100.104% ( 870, 1300 ] 269 0.016% 100.119% ( 1300, 1900 ] 155 0.009% 100.129% ( 1900, 2900 ] 152 0.009% 100.137% ( 2900, 4400 ] 127 0.007% 100.145% ( 4400, 6600 ] 20 0.001% 100.146% ( 6600, 9900 ] 10 0.001% 100.147% ** Level 2 read latency histogram (micros): Count: 40620 Average: 2.5266 StdDev: 18.15 Min: 1 Median: 1.3408 Max: 1416 Percentiles: P50: 1.34 P75: 1.76 P99: 7.56 P99.9: 225.93 P99.99: 866.40 ------------------------------------------------------ [ 0, 1 ] 12122 29.842% 29.842% ###### ( 1, 2 ] 24027 59.151% 88.993% ############ ( 2, 3 ] 2450 6.032% 95.025% # ( 3, 4 ] 761 1.873% 96.898% ( 4, 6 ] 685 1.686% 98.584% ( 6, 10 ] 432 1.064% 99.648% ( 10, 15 ] 47 0.116% 99.764% ( 15, 22 ] 12 0.030% 99.793% ( 22, 34 ] 1 0.002% 99.796% ( 34, 51 ] 1 0.002% 99.798% ( 51, 76 ] 18 0.044% 99.842% ( 76, 110 ] 3 0.007% 99.850% ( 110, 170 ] 5 0.012% 99.862% ( 170, 250 ] 22 0.054% 99.916% ( 250, 380 ] 17 0.042% 99.958% ( 380, 580 ] 8 0.020% 99.978% ( 580, 870 ] 5 0.012% 99.990% ( 870, 1300 ] 2 0.005% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 650455 Average: 7.2441 StdDev: 95.37 Min: 0 Median: 1.9649 Max: 13737 Percentiles: P50: 1.96 P75: 2.91 P99: 9.59 P99.9: 515.79 P99.99: 768.07 ------------------------------------------------------ [ 0, 1 ] 16356 2.515% 2.515% # ( 1, 2 ] 320113 49.214% 51.728% ########## ( 2, 3 ] 166417 25.585% 77.313% ##### ( 3, 4 ] 63125 9.705% 87.018% ## ( 4, 6 ] 65804 10.117% 97.134% ## ( 6, 10 ] 13519 2.078% 99.213% ( 10, 15 ] 2161 0.332% 99.545% ( 15, 22 ] 260 0.040% 99.585% ( 22, 34 ] 25 0.004% 99.589% ( 34, 51 ] 19 0.003% 99.592% ( 51, 76 ] 41 0.006% 99.598% ( 76, 110 ] 129 0.020% 99.618% ( 110, 170 ] 446 0.069% 99.686% ( 170, 250 ] 412 0.063% 99.750% ( 250, 380 ] 524 0.081% 99.830% ( 380, 580 ] 668 0.103% 99.933% ( 580, 870 ] 572 0.088% 100.021% ( 870, 1300 ] 415 0.064% 100.085% ( 1300, 1900 ] 184 0.028% 100.113% ( 1900, 2900 ] 133 0.020% 100.133% ( 2900, 4400 ] 122 0.019% 100.152% ( 4400, 6600 ] 30 0.005% 100.157% ( 6600, 9900 ] 11 0.002% 100.159% ( 9900, 14000 ] 5 0.001% 100.159% ** Level 4 read latency histogram (micros): Count: 147095 Average: 13.9594 StdDev: 188.17 Min: 0 Median: 2.2675 Max: 15659 Percentiles: P50: 2.27 P75: 3.31 P99: 14.98 P99.9: 1630.89 P99.99: 3139.43 ------------------------------------------------------ [ 0, 1 ] 1058 0.719% 0.719% ( 1, 2 ] 60940 41.429% 42.148% ######## ( 2, 3 ] 43168 29.347% 71.495% ###### ( 3, 4 ] 16763 11.396% 82.891% ## ( 4, 6 ] 18952 12.884% 95.776% ### ( 6, 10 ] 3911 2.659% 98.434% # ( 10, 15 ] 836 0.568% 99.003% ( 15, 22 ] 83 0.056% 99.059% ( 22, 34 ] 14 0.010% 99.069% ( 34, 51 ] 3 0.002% 99.071% ( 51, 76 ] 19 0.013% 99.084% ( 76, 110 ] 26 0.018% 99.101% ( 110, 170 ] 84 0.057% 99.158% ( 170, 250 ] 160 0.109% 99.267% ( 250, 380 ] 181 0.123% 99.390% ( 380, 580 ] 267 0.182% 99.572% ( 580, 870 ] 238 0.162% 99.734% ( 870, 1300 ] 187 0.127% 99.861% ( 1300, 1900 ] 105 0.071% 99.932% ( 1900, 2900 ] 73 0.050% 99.982% ( 2900, 4400 ] 77 0.052% 100.034% ( 4400, 6600 ] 25 0.017% 100.051% ( 6600, 9900 ] 21 0.014% 100.065% ( 9900, 14000 ] 7 0.005% 100.070% ( 14000, 22000 ] 1 0.001% 100.071% ** Level 5 read latency histogram (micros): Count: 220 Average: 1256.8409 StdDev: 1359.41 Min: 84 Median: 660.5556 Max: 6749 Percentiles: P50: 660.56 P75: 1872.73 P99: 6270.00 P99.9: 6749.00 P99.99: 6749.00 ------------------------------------------------------ ( 76, 110 ] 17 7.727% 7.727% ## ( 110, 170 ] 27 12.273% 20.000% ## ( 170, 250 ] 14 6.364% 26.364% # ( 250, 380 ] 25 11.364% 37.727% ## ( 380, 580 ] 22 10.000% 47.727% ## ( 580, 870 ] 18 8.182% 55.909% ## ( 870, 1300 ] 21 9.545% 65.455% ## ( 1300, 1900 ] 22 10.000% 75.455% ## ( 1900, 2900 ] 23 10.455% 85.909% ## ( 2900, 4400 ] 22 10.000% 95.909% ## ( 4400, 6600 ] 8 3.636% 99.545% # ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 57.5 total, 14.7 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 171.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:30.029 H:M:S, 52.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 67.05 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:11.680 H:M:S, 79.6 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.834 micros/op 171394 ops/sec 60.048 seconds 10291999 operations; 166.1 MB/s Microseconds per write: Count: 10291999 Average: 5.8345 StdDev: 403.80 Min: 0 Median: 1.7192 Max: 871394 Percentiles: P50: 1.72 P75: 2.71 P99: 9.61 P99.9: 1144.74 P99.99: 2670.13 ------------------------------------------------------ [ 0, 1 ] 1498000 14.555% 14.555% ### ( 1, 2 ] 5072038 49.281% 63.836% ########## ( 2, 3 ] 1608784 15.631% 79.468% ### ( 3, 4 ] 1376865 13.378% 92.846% ### ( 4, 6 ] 512613 4.981% 97.826% # ( 6, 10 ] 133800 1.300% 99.127% ( 10, 15 ] 45523 0.442% 99.569% ( 15, 22 ] 10735 0.104% 99.673% ( 22, 34 ] 1644 0.016% 99.689% ( 34, 51 ] 211 0.002% 99.691% ( 51, 76 ] 14 0.000% 99.691% ( 76, 110 ] 7588 0.074% 99.765% ( 110, 170 ] 2417 0.023% 99.789% ( 170, 250 ] 258 0.003% 99.791% ( 250, 380 ] 175 0.002% 99.793% ( 380, 580 ] 27 0.000% 99.793% ( 580, 870 ] 15 0.000% 99.793% ( 870, 1300 ] 17216 0.167% 99.960% ( 1300, 1900 ] 61 0.001% 99.961% ( 1900, 2900 ] 3877 0.038% 99.999% ( 2900, 4400 ] 84 0.001% 99.999% ( 4400, 6600 ] 23 0.000% 100.000% ( 6600, 9900 ] 3 0.000% 100.000% ( 14000, 22000 ] 5 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 208052 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 : 10291999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10621342968 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 : 552 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31931554 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 : 31408955109 rocksdb.compact.write.bytes COUNT : 31191455707 rocksdb.flush.write.bytes COUNT : 10569220118 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 : 64 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 : 292 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 : 10484009984 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4081664 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 : 30645757619 rocksdb.non.last.level.read.count COUNT : 7399940 rocksdb.block.checksum.compute.count COUNT : 7606920 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.365041 P95 : 3.916345 P99 : 8.268255 P100 : 871391.000000 COUNT : 10291999 SUM : 55310939 rocksdb.compaction.times.micros P50 : 1117575.757576 P95 : 5106666.666667 P99 : 18880000.000000 P100 : 19796096.000000 COUNT : 78 SUM : 143084956 rocksdb.compaction.times.cpu_micros P50 : 945000.000000 P95 : 4410000.000000 P99 : 18200580.000000 P100 : 18200580.000000 COUNT : 78 SUM : 121598254 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 : 710.967742 P95 : 1239.800000 P99 : 9207.000000 P100 : 393453.000000 COUNT : 142 SUM : 510309 rocksdb.compaction.outfile.sync.micros P50 : 1008.024691 P95 : 138666.666667 P99 : 245680.000000 P100 : 305955.000000 COUNT : 354 SUM : 6747934 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 : 101.311111 P95 : 652.500000 P99 : 1264.166667 P100 : 2577.000000 COUNT : 250 SUM : 44492 rocksdb.table.open.io.micros P50 : 1600.000000 P95 : 8448.000000 P99 : 18603.076923 P100 : 21792.000000 COUNT : 552 SUM : 1378394 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.715001 P95 : 7.820908 P99 : 11.552413 P100 : 16420.000000 COUNT : 7605293 SUM : 45580105 rocksdb.read.block.get.micros P50 : 555.806452 P95 : 3866.666667 P99 : 8418.666667 P100 : 11589.000000 COUNT : 1104 SUM : 1140523 rocksdb.write.raw.block.micros P50 : 0.513361 P95 : 0.975386 P99 : 2.947129 P100 : 13461.000000 COUNT : 10113927 SUM : 19866987 rocksdb.numfiles.in.singlecompaction P50 : 3.363636 P95 : 7.866667 P99 : 26.080000 P100 : 28.000000 COUNT : 132 SUM : 560 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.557756 P95 : 1142.921372 P99 : 2396.243865 P100 : 871206.000000 COUNT : 206304 SUM : 31951718 rocksdb.sst.read.micros P50 : 1.642654 P95 : 4.666188 P99 : 8.780521 P100 : 15659.000000 COUNT : 7400146 SUM : 29006536 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 : 10291999 SUM : 10621342968 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 : 213018.867925 P95 : 371062.500000 P99 : 554040.000000 P100 : 988371.000000 COUNT : 142 SUM : 30427778 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 : 349 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