[2024-12-01 22:42:05.645976] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-01 22:42:05.646237] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid950611 ] Set seed to 1733089325639326 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-01 22:42:05.754629] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-01 22:42:05.790871] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-01 22:42:05.790915] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 950611' to capture a snapshot of events at runtime. [2024-12-01 22:42:05.790928] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid950611 for offline analysis/debug. [2024-12-01 22:42:05.790970] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Dec 1 22:42:10 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/01-22:42:12 ... thread 0: (1000000,1000000) ops and (355553.0,355553.0) ops/second in (2.812520,2.812520) 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/8 504.01 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 353.9 2.31 2.09 12 0.193 0 0 0.0 0.0 L1 3/3 188.89 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 260.5 260.4 0.73 0.70 1 0.725 191K 68 0.0 0.0 L2 2/1 125.94 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 8/0 741.47 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1181/12 96.94 GB 0.0 0.3 0.2 0.1 1.1 1.0 1.0 1.4 88.0 316.7 3.58 3.30 14 0.256 319K 112 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.8 1.4 88.0 316.7 3.58 3.30 14 0.256 319K 112 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.3 0.2 0.1 0.3 0.2 0.0 0.0 248.8 248.7 1.27 1.21 2 0.633 319K 112 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 353.9 2.31 2.09 12 0.193 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.11 GB write, 375.46 MB/s write, 0.31 GB read, 104.30 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 402.92 MB/s write, 0.31 GB read, 111.93 MB/s read, 3.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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 119309 Average: 1.8732 StdDev: 18.99 Min: 0 Median: 1.1837 Max: 4019 Percentiles: P50: 1.18 P75: 1.64 P99: 4.19 P99.9: 9.83 P99.99: 251.80 ------------------------------------------------------ [ 0, 1 ] 47719 39.996% 39.996% ######## ( 1, 2 ] 64972 54.457% 94.453% ########### ( 2, 3 ] 3736 3.131% 97.584% # ( 3, 4 ] 1611 1.350% 98.935% ( 4, 6 ] 855 0.717% 99.651% ( 6, 10 ] 312 0.262% 99.913% ( 10, 15 ] 69 0.058% 99.971% ( 15, 22 ] 8 0.007% 99.977% ( 22, 34 ] 1 0.001% 99.978% ( 34, 51 ] 3 0.003% 99.981% ( 51, 76 ] 2 0.002% 99.982% ( 110, 170 ] 5 0.004% 99.987% ( 170, 250 ] 6 0.005% 99.992% ( 250, 380 ] 5 0.004% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 2 0.002% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 2 0.002% 100.001% ( 1900, 2900 ] 1 0.001% 100.002% ( 2900, 4400 ] 2 0.002% 100.003% ** Level 1 read latency histogram (micros): Count: 23414 Average: 1.8093 StdDev: 6.53 Min: 1 Median: 1.2218 Max: 788 Percentiles: P50: 1.22 P75: 1.67 P99: 4.10 P99.9: 9.54 P99.99: 445.86 ------------------------------------------------------ [ 0, 1 ] 8782 37.507% 37.507% ######## ( 1, 2 ] 13187 56.321% 93.828% ########### ( 2, 3 ] 885 3.780% 97.608% # ( 3, 4 ] 316 1.350% 98.958% ( 4, 6 ] 194 0.829% 99.786% ( 6, 10 ] 30 0.128% 99.915% ( 10, 15 ] 12 0.051% 99.966% ( 15, 22 ] 3 0.013% 99.979% ( 34, 51 ] 1 0.004% 99.983% ( 170, 250 ] 1 0.004% 99.987% ( 380, 580 ] 2 0.009% 99.996% ( 580, 870 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 8724 Average: 4.1561 StdDev: 66.94 Min: 0 Median: 1.5083 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 6.39 P99.9: 332.94 P99.99: 3091.40 ------------------------------------------------------ [ 0, 1 ] 1626 18.638% 18.638% #### ( 1, 2 ] 5383 61.703% 80.342% ############ ( 2, 3 ] 786 9.010% 89.351% ## ( 3, 4 ] 509 5.834% 95.186% # ( 4, 6 ] 326 3.737% 98.923% # ( 6, 10 ] 70 0.802% 99.725% ( 10, 15 ] 10 0.115% 99.840% ( 15, 22 ] 1 0.011% 99.851% ( 22, 34 ] 1 0.011% 99.862% ( 110, 170 ] 2 0.023% 99.885% ( 250, 380 ] 2 0.023% 99.908% ( 580, 870 ] 1 0.011% 99.920% ( 870, 1300 ] 1 0.011% 99.931% ( 1300, 1900 ] 2 0.023% 99.954% ( 1900, 2900 ] 3 0.034% 99.989% ( 2900, 4400 ] 1 0.011% 100.000% ** Level 3 read latency histogram (micros): Count: 50 Average: 1528.8800 StdDev: 1193.31 Min: 70 Median: 1156.6667 Max: 4421 Percentiles: P50: 1156.67 P75: 2150.00 P99: 4421.00 P99.9: 4421.00 P99.99: 4421.00 ------------------------------------------------------ ( 51, 76 ] 1 2.000% 2.000% ( 76, 110 ] 1 2.000% 4.000% ( 110, 170 ] 1 2.000% 6.000% ( 170, 250 ] 3 6.000% 12.000% # ( 250, 380 ] 1 2.000% 14.000% ( 380, 580 ] 2 4.000% 18.000% # ( 580, 870 ] 12 24.000% 42.000% ##### ( 870, 1300 ] 6 12.000% 54.000% ## ( 1300, 1900 ] 9 18.000% 72.000% #### ( 1900, 2900 ] 6 12.000% 84.000% ## ( 2900, 4400 ] 7 14.000% 98.000% ### ( 4400, 6600 ] 1 2.000% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1762.1000 StdDev: 1258.16 Min: 542 Median: 1471.4286 Max: 4905 Percentiles: P50: 1471.43 P75: 1900.00 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 6 30.000% 35.000% ###### ( 870, 1300 ] 1 5.000% 40.000% # ( 1300, 1900 ] 7 35.000% 75.000% ####### ( 1900, 2900 ] 2 10.000% 85.000% ## ( 2900, 4400 ] 1 5.000% 90.000% # ( 4400, 6600 ] 2 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 388.2500 StdDev: 467.49 Min: 73 Median: 156.6667 Max: 1997 Percentiles: P50: 156.67 P75: 580.00 P99: 1997.00 P99.9: 1997.00 P99.99: 1997.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 2 10.000% 15.000% ## ( 110, 170 ] 9 45.000% 60.000% ######### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 3 15.000% 90.000% ### ( 870, 1300 ] 1 5.000% 95.000% # ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 325.89 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.192 H:M:S, 6.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.64 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.192 H:M:S, 6.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/01-22:42:15 ... thread 0: (1000000,2000000) ops and (329294.2,341920.2) ops/second in (3.036798,5.849318) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/4 1.23 GB 94.4 0.8 0.0 0.8 2.6 1.8 0.0 1.4 99.5 321.3 8.23 7.65 29 0.284 831K 915 0.0 0.0 L1 1/0 3.26 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.4 251.3 251.0 2.51 2.43 2 1.253 639K 822 0.0 0.0 L2 5/3 437.78 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 16/1 866.46 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.2 1.0 219.7 219.7 0.57 0.51 1 0.569 126K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1191/8 97.92 GB 0.0 1.7 0.6 1.0 3.4 2.4 1.4 1.9 143.5 297.5 11.85 11.11 33 0.359 1725K 1781 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.6 1.0 3.4 2.4 1.2 1.9 143.5 297.5 11.85 11.11 33 0.359 1725K 1781 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.7 0.6 1.0 1.7 0.6 0.0 0.0 252.5 252.2 6.73 6.51 7 0.962 1725K 1781 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 357.0 5.12 4.60 26 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.44 GB write, 582.00 MB/s write, 1.66 GB read, 280.66 MB/s read, 11.8 seconds Interval compaction: 3.44 GB write, 602.47 MB/s write, 1.66 GB read, 290.53 MB/s read, 11.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 385890 Average: 2.0152 StdDev: 14.67 Min: 0 Median: 1.3457 Max: 4019 Percentiles: P50: 1.35 P75: 1.76 P99: 5.31 P99.9: 9.71 P99.99: 19.69 ------------------------------------------------------ [ 0, 1 ] 112345 29.113% 29.113% ###### ( 1, 2 ] 233140 60.416% 89.529% ############ ( 2, 3 ] 22137 5.737% 95.266% # ( 3, 4 ] 10393 2.693% 97.959% # ( 4, 6 ] 6148 1.593% 99.552% ( 6, 10 ] 1447 0.375% 99.927% ( 10, 15 ] 230 0.060% 99.987% ( 15, 22 ] 20 0.005% 99.992% ( 22, 34 ] 4 0.001% 99.993% ( 34, 51 ] 5 0.001% 99.995% ( 51, 76 ] 5 0.001% 99.996% ( 110, 170 ] 8 0.002% 99.998% ( 170, 250 ] 16 0.004% 100.002% ( 250, 380 ] 9 0.002% 100.004% ( 380, 580 ] 3 0.001% 100.005% ( 580, 870 ] 9 0.002% 100.008% ( 870, 1300 ] 4 0.001% 100.009% ( 1300, 1900 ] 4 0.001% 100.010% ( 1900, 2900 ] 2 0.001% 100.010% ( 2900, 4400 ] 4 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 103335 Average: 2.1544 StdDev: 8.83 Min: 1 Median: 1.4682 Max: 1744 Percentiles: P50: 1.47 P75: 1.86 P99: 5.60 P99.9: 11.33 P99.99: 236.66 ------------------------------------------------------ [ 0, 1 ] 20536 19.873% 19.873% #### ( 1, 2 ] 66488 64.342% 84.215% ############# ( 2, 3 ] 9669 9.357% 93.572% ## ( 3, 4 ] 3611 3.494% 97.067% # ( 4, 6 ] 2492 2.412% 99.478% ( 6, 10 ] 408 0.395% 99.873% ( 10, 15 ] 104 0.101% 99.974% ( 15, 22 ] 11 0.011% 99.985% ( 22, 34 ] 2 0.002% 99.986% ( 34, 51 ] 1 0.001% 99.987% ( 110, 170 ] 1 0.001% 99.988% ( 170, 250 ] 2 0.002% 99.990% ( 250, 380 ] 3 0.003% 99.993% ( 380, 580 ] 3 0.003% 99.996% ( 580, 870 ] 1 0.001% 99.997% ( 870, 1300 ] 1 0.001% 99.998% ( 1300, 1900 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 15958 Average: 7.0603 StdDev: 108.90 Min: 1 Median: 1.5282 Max: 4421 Percentiles: P50: 1.53 P75: 1.91 P99: 5.96 P99.9: 1782.52 P99.99: 4272.33 ------------------------------------------------------ [ 0, 1 ] 2456 15.390% 15.390% ### ( 1, 2 ] 10457 65.528% 80.919% ############# ( 2, 3 ] 1818 11.392% 92.311% ## ( 3, 4 ] 644 4.036% 96.347% # ( 4, 6 ] 431 2.701% 99.047% # ( 6, 10 ] 82 0.514% 99.561% ( 10, 15 ] 15 0.094% 99.655% ( 15, 22 ] 1 0.006% 99.662% ( 22, 34 ] 2 0.013% 99.674% ( 51, 76 ] 1 0.006% 99.680% ( 76, 110 ] 1 0.006% 99.687% ( 110, 170 ] 1 0.006% 99.693% ( 170, 250 ] 3 0.019% 99.712% ( 250, 380 ] 1 0.006% 99.718% ( 380, 580 ] 3 0.019% 99.737% ( 580, 870 ] 12 0.075% 99.812% ( 870, 1300 ] 6 0.038% 99.850% ( 1300, 1900 ] 10 0.063% 99.912% ( 1900, 2900 ] 6 0.038% 99.950% ( 2900, 4400 ] 7 0.044% 99.994% ( 4400, 6600 ] 1 0.006% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1762.1000 StdDev: 1258.16 Min: 542 Median: 1471.4286 Max: 4905 Percentiles: P50: 1471.43 P75: 1900.00 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 6 30.000% 35.000% ###### ( 870, 1300 ] 1 5.000% 40.000% # ( 1300, 1900 ] 7 35.000% 75.000% ####### ( 1900, 2900 ] 2 10.000% 85.000% ## ( 2900, 4400 ] 1 5.000% 90.000% # ( 4400, 6600 ] 2 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 388.2500 StdDev: 467.49 Min: 73 Median: 156.6667 Max: 1997 Percentiles: P50: 156.67 P75: 580.00 P99: 1997.00 P99.9: 1997.00 P99.99: 1997.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 2 10.000% 15.000% ## ( 110, 170 ] 9 45.000% 60.000% ######### ( 250, 380 ] 2 10.000% 70.000% ## ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 3 15.000% 90.000% ### ( 870, 1300 ] 1 5.000% 95.000% # ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.99 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.572 H:M:S, 9.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.09 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.379 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/01-22:42:18 ... thread 0: (1000000,3000000) ops and (329778.1,337774.7) ops/second in (3.032342,8.881660) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/4 2.21 GB 195.1 1.9 0.0 1.9 4.7 2.8 0.0 1.7 128.0 313.7 15.25 14.29 47 0.325 1982K 2158 0.0 0.0 L1 1/0 3.26 MB 0.3 0.6 0.4 0.2 0.6 0.4 0.1 1.4 251.3 251.0 2.51 2.43 2 1.253 639K 822 0.0 0.0 L2 2/0 51.49 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 41/0 972.05 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.2 1.2 197.0 196.8 3.17 2.72 2 1.583 633K 512 0.0 0.0 L4 144/0 9.56 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1247/4 98.90 GB 0.0 3.3 1.0 2.3 6.0 3.8 2.0 2.2 155.2 287.1 21.47 19.95 52 0.413 3383K 3536 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 1.0 2.3 6.0 3.8 1.8 2.2 155.2 287.1 21.47 19.95 52 0.413 3383K 3536 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.3 1.0 2.3 3.3 1.0 0.0 0.0 245.9 245.7 13.55 12.84 12 1.129 3383K 3536 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 358.1 7.92 7.11 40 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.02 GB write, 678.15 MB/s write, 3.25 GB read, 366.65 MB/s read, 21.5 seconds Interval compaction: 6.02 GB write, 693.86 MB/s write, 3.25 GB read, 375.14 MB/s read, 21.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 648451 Average: 1.9893 StdDev: 12.26 Min: 0 Median: 1.3436 Max: 4019 Percentiles: P50: 1.34 P75: 1.76 P99: 5.22 P99.9: 9.62 P99.99: 19.78 ------------------------------------------------------ [ 0, 1 ] 189071 29.157% 29.157% ###### ( 1, 2 ] 393377 60.664% 89.821% ############ ( 2, 3 ] 36285 5.596% 95.417% # ( 3, 4 ] 17266 2.663% 98.080% # ( 4, 6 ] 9771 1.507% 99.587% ( 6, 10 ] 2249 0.347% 99.933% ( 10, 15 ] 332 0.051% 99.985% ( 15, 22 ] 53 0.008% 99.993% ( 22, 34 ] 8 0.001% 99.994% ( 34, 51 ] 7 0.001% 99.995% ( 51, 76 ] 5 0.001% 99.996% ( 110, 170 ] 15 0.002% 99.998% ( 170, 250 ] 21 0.003% 100.001% ( 250, 380 ] 19 0.003% 100.004% ( 380, 580 ] 3 0.000% 100.005% ( 580, 870 ] 16 0.002% 100.007% ( 870, 1300 ] 10 0.002% 100.009% ( 1300, 1900 ] 5 0.001% 100.010% ( 1900, 2900 ] 2 0.000% 100.010% ( 2900, 4400 ] 4 0.001% 100.010% ** Level 1 read latency histogram (micros): Count: 146064 Average: 2.1768 StdDev: 7.44 Min: 1 Median: 1.4985 Max: 1744 Percentiles: P50: 1.50 P75: 1.88 P99: 5.63 P99.9: 10.76 P99.99: 30.36 ------------------------------------------------------ [ 0, 1 ] 25416 17.401% 17.401% ### ( 1, 2 ] 95513 65.391% 82.792% ############# ( 2, 3 ] 15111 10.345% 93.137% ## ( 3, 4 ] 5396 3.694% 96.832% # ( 4, 6 ] 3891 2.664% 99.495% # ( 6, 10 ] 570 0.390% 99.886% ( 10, 15 ] 138 0.094% 99.980% ( 15, 22 ] 13 0.009% 99.989% ( 22, 34 ] 2 0.001% 99.990% ( 34, 51 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 3 0.002% 99.995% ( 380, 580 ] 3 0.002% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28883 Average: 5.0334 StdDev: 81.15 Min: 0 Median: 1.5401 Max: 4421 Percentiles: P50: 1.54 P75: 1.92 P99: 5.99 P99.9: 950.05 P99.99: 3995.36 ------------------------------------------------------ [ 0, 1 ] 4152 14.375% 14.375% ### ( 1, 2 ] 19050 65.956% 80.331% ############# ( 2, 3 ] 3395 11.754% 92.085% ## ( 3, 4 ] 1183 4.096% 96.181% # ( 4, 6 ] 820 2.839% 99.020% # ( 6, 10 ] 134 0.464% 99.484% ( 10, 15 ] 24 0.083% 99.567% ( 15, 22 ] 4 0.014% 99.581% ( 22, 34 ] 37 0.128% 99.709% ( 34, 51 ] 19 0.066% 99.775% ( 51, 76 ] 2 0.007% 99.782% ( 76, 110 ] 2 0.007% 99.789% ( 110, 170 ] 8 0.028% 99.817% ( 170, 250 ] 4 0.014% 99.830% ( 250, 380 ] 2 0.007% 99.837% ( 380, 580 ] 5 0.017% 99.855% ( 580, 870 ] 12 0.042% 99.896% ( 870, 1300 ] 6 0.021% 99.917% ( 1300, 1900 ] 10 0.035% 99.952% ( 1900, 2900 ] 6 0.021% 99.972% ( 2900, 4400 ] 7 0.024% 99.997% ( 4400, 6600 ] 1 0.003% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1762.1000 StdDev: 1258.16 Min: 542 Median: 1471.4286 Max: 4905 Percentiles: P50: 1471.43 P75: 1900.00 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 6 30.000% 35.000% ###### ( 870, 1300 ] 1 5.000% 40.000% # ( 1300, 1900 ] 7 35.000% 75.000% ####### ( 1900, 2900 ] 2 10.000% 85.000% ## ( 2900, 4400 ] 1 5.000% 90.000% # ( 4400, 6600 ] 2 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 527.3500 StdDev: 661.56 Min: 73 Median: 223.3333 Max: 2951 Percentiles: P50: 223.33 P75: 652.50 P99: 2951.00 P99.9: 2951.00 P99.99: 2951.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 5 12.500% 15.000% ### ( 110, 170 ] 12 30.000% 45.000% ###### ( 170, 250 ] 3 7.500% 52.500% ## ( 250, 380 ] 4 10.000% 62.500% ## ( 380, 580 ] 4 10.000% 72.500% ## ( 580, 870 ] 4 10.000% 82.500% ## ( 870, 1300 ] 2 5.000% 87.500% # ( 1300, 1900 ] 2 5.000% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.85 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.960 H:M:S, 10.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.56 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.389 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/01-22:42:21 ... thread 0: (1000000,4000000) ops and (356661.4,342306.3) ops/second in (2.803780,11.685440) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/13 3.13 GB 18.9 2.7 0.0 2.7 6.4 3.7 0.0 1.7 133.0 314.3 20.84 19.55 64 0.326 2814K 3022 0.0 0.0 L1 1/1 3.26 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 251.3 251.0 2.51 2.43 2 1.253 639K 822 0.0 0.0 L2 2/0 51.49 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 41/0 972.05 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.2 1.2 197.0 196.8 3.17 2.72 2 1.583 633K 512 0.0 0.0 L4 144/0 9.56 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/14 99.82 GB 0.0 4.1 1.0 3.1 7.7 4.7 2.0 2.1 153.5 293.1 27.05 25.21 69 0.392 4215K 4400 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.0 3.1 7.7 4.7 1.8 2.1 153.5 293.1 27.05 25.21 69 0.392 4215K 4400 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.1 1.0 3.1 4.0 1.0 0.0 0.0 250.2 249.9 16.59 15.82 15 1.106 4215K 4400 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 361.5 10.46 9.39 54 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 11.9 total, 11.7 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.74 GB write, 666.52 MB/s write, 4.05 GB read, 349.07 MB/s read, 27.0 seconds Interval compaction: 7.74 GB write, 678.25 MB/s write, 4.05 GB read, 355.22 MB/s read, 27.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 12, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 12, interval: 12 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 880770 Average: 1.9826 StdDev: 12.14 Min: 0 Median: 1.3277 Max: 4019 Percentiles: P50: 1.33 P75: 1.74 P99: 5.11 P99.9: 9.75 P99.99: 118.64 ------------------------------------------------------ [ 0, 1 ] 265548 30.150% 30.150% ###### ( 1, 2 ] 533604 60.584% 90.733% ############ ( 2, 3 ] 45114 5.122% 95.855% # ( 3, 4 ] 21275 2.416% 98.271% ( 4, 6 ] 11546 1.311% 99.582% ( 6, 10 ] 2986 0.339% 99.921% ( 10, 15 ] 442 0.050% 99.971% ( 15, 22 ] 69 0.008% 99.979% ( 22, 34 ] 8 0.001% 99.980% ( 34, 51 ] 8 0.001% 99.981% ( 51, 76 ] 8 0.001% 99.982% ( 76, 110 ] 65 0.007% 99.989% ( 110, 170 ] 62 0.007% 99.996% ( 170, 250 ] 40 0.005% 100.001% ( 250, 380 ] 32 0.004% 100.004% ( 380, 580 ] 8 0.001% 100.005% ( 580, 870 ] 22 0.002% 100.008% ( 870, 1300 ] 13 0.001% 100.009% ( 1300, 1900 ] 8 0.001% 100.010% ( 1900, 2900 ] 3 0.000% 100.010% ( 2900, 4400 ] 5 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 146065 Average: 2.1768 StdDev: 7.44 Min: 1 Median: 1.4985 Max: 1744 Percentiles: P50: 1.50 P75: 1.88 P99: 5.63 P99.9: 10.76 P99.99: 30.36 ------------------------------------------------------ [ 0, 1 ] 25416 17.400% 17.400% ### ( 1, 2 ] 95513 65.391% 82.791% ############# ( 2, 3 ] 15112 10.346% 93.137% ## ( 3, 4 ] 5396 3.694% 96.832% # ( 4, 6 ] 3891 2.664% 99.495% # ( 6, 10 ] 570 0.390% 99.886% ( 10, 15 ] 138 0.094% 99.980% ( 15, 22 ] 13 0.009% 99.989% ( 22, 34 ] 2 0.001% 99.990% ( 34, 51 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 3 0.002% 99.995% ( 380, 580 ] 3 0.002% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28883 Average: 5.0334 StdDev: 81.15 Min: 0 Median: 1.5401 Max: 4421 Percentiles: P50: 1.54 P75: 1.92 P99: 5.99 P99.9: 950.05 P99.99: 3995.36 ------------------------------------------------------ [ 0, 1 ] 4152 14.375% 14.375% ### ( 1, 2 ] 19050 65.956% 80.331% ############# ( 2, 3 ] 3395 11.754% 92.085% ## ( 3, 4 ] 1183 4.096% 96.181% # ( 4, 6 ] 820 2.839% 99.020% # ( 6, 10 ] 134 0.464% 99.484% ( 10, 15 ] 24 0.083% 99.567% ( 15, 22 ] 4 0.014% 99.581% ( 22, 34 ] 37 0.128% 99.709% ( 34, 51 ] 19 0.066% 99.775% ( 51, 76 ] 2 0.007% 99.782% ( 76, 110 ] 2 0.007% 99.789% ( 110, 170 ] 8 0.028% 99.817% ( 170, 250 ] 4 0.014% 99.830% ( 250, 380 ] 2 0.007% 99.837% ( 380, 580 ] 5 0.017% 99.855% ( 580, 870 ] 12 0.042% 99.896% ( 870, 1300 ] 6 0.021% 99.917% ( 1300, 1900 ] 10 0.035% 99.952% ( 1900, 2900 ] 6 0.021% 99.972% ( 2900, 4400 ] 7 0.024% 99.997% ( 4400, 6600 ] 1 0.003% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1762.1000 StdDev: 1258.16 Min: 542 Median: 1471.4286 Max: 4905 Percentiles: P50: 1471.43 P75: 1900.00 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 6 30.000% 35.000% ###### ( 870, 1300 ] 1 5.000% 40.000% # ( 1300, 1900 ] 7 35.000% 75.000% ####### ( 1900, 2900 ] 2 10.000% 85.000% ## ( 2900, 4400 ] 1 5.000% 90.000% # ( 4400, 6600 ] 2 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 527.3500 StdDev: 661.56 Min: 73 Median: 223.3333 Max: 2951 Percentiles: P50: 223.33 P75: 652.50 P99: 2951.00 P99.9: 2951.00 P99.99: 2951.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 5 12.500% 15.000% ### ( 110, 170 ] 12 30.000% 45.000% ###### ( 170, 250 ] 3 7.500% 52.500% ## ( 250, 380 ] 4 10.000% 62.500% ## ( 380, 580 ] 4 10.000% 72.500% ## ( 580, 870 ] 4 10.000% 82.500% ## ( 870, 1300 ] 2 5.000% 87.500% # ( 1300, 1900 ] 2 5.000% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 11.9 total, 2.8 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 331.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.149 H:M:S, 9.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.02 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.189 H:M:S, 6.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/01-22:42:27 ... thread 0: (1000000,5000000) ops and (187286.2,293688.2) ops/second in (5.339421,17.024861) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/13 4.12 GB 119.6 3.8 0.0 3.8 8.4 4.7 0.0 1.8 139.0 312.1 27.64 25.97 83 0.333 3901K 4068 0.0 0.0 L1 1/1 3.26 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 251.3 251.0 2.51 2.43 2 1.253 639K 822 0.0 0.0 L2 2/0 51.49 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 41/0 972.05 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.2 1.2 197.0 196.8 3.17 2.72 2 1.583 633K 512 0.0 0.0 L4 144/0 9.56 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/14 100.81 GB 0.0 5.1 1.0 4.1 9.8 5.7 2.0 2.1 154.3 295.5 33.85 31.64 88 0.385 5302K 5446 0.0 0.0 Int 0/0 0.00 KB 0.0 5.1 1.0 4.1 9.8 5.7 1.8 2.1 154.3 295.5 33.85 31.64 88 0.385 5302K 5446 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.1 1.0 4.1 5.1 1.0 0.0 0.0 254.2 253.9 20.55 19.71 19 1.081 5302K 5446 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 359.9 13.30 11.93 69 0.193 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): 17.2 total, 17.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.77 GB write, 580.57 MB/s write, 5.10 GB read, 303.06 MB/s read, 33.9 seconds Interval compaction: 9.77 GB write, 587.59 MB/s write, 5.10 GB read, 306.72 MB/s read, 33.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 7, total-stops: 14, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1470534 Average: 2.0244 StdDev: 12.25 Min: 0 Median: 1.3654 Max: 6571 Percentiles: P50: 1.37 P75: 1.76 P99: 5.23 P99.9: 9.81 P99.99: 100.94 ------------------------------------------------------ [ 0, 1 ] 396522 26.964% 26.964% ##### ( 1, 2 ] 926995 63.038% 90.002% ############# ( 2, 3 ] 82795 5.630% 95.633% # ( 3, 4 ] 37607 2.557% 98.190% # ( 4, 6 ] 19359 1.316% 99.507% ( 6, 10 ] 6070 0.413% 99.919% ( 10, 15 ] 802 0.055% 99.974% ( 15, 22 ] 117 0.008% 99.982% ( 22, 34 ] 10 0.001% 99.983% ( 34, 51 ] 11 0.001% 99.983% ( 51, 76 ] 9 0.001% 99.984% ( 76, 110 ] 124 0.008% 99.992% ( 110, 170 ] 120 0.008% 100.000% ( 170, 250 ] 71 0.005% 100.005% ( 250, 380 ] 48 0.003% 100.009% ( 380, 580 ] 28 0.002% 100.010% ( 580, 870 ] 37 0.003% 100.013% ( 870, 1300 ] 15 0.001% 100.014% ( 1300, 1900 ] 11 0.001% 100.015% ( 1900, 2900 ] 5 0.000% 100.015% ( 2900, 4400 ] 6 0.000% 100.016% ( 4400, 6600 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 146065 Average: 2.1768 StdDev: 7.44 Min: 1 Median: 1.4985 Max: 1744 Percentiles: P50: 1.50 P75: 1.88 P99: 5.63 P99.9: 10.76 P99.99: 30.36 ------------------------------------------------------ [ 0, 1 ] 25416 17.400% 17.400% ### ( 1, 2 ] 95513 65.391% 82.791% ############# ( 2, 3 ] 15112 10.346% 93.137% ## ( 3, 4 ] 5396 3.694% 96.832% # ( 4, 6 ] 3891 2.664% 99.495% # ( 6, 10 ] 570 0.390% 99.886% ( 10, 15 ] 138 0.094% 99.980% ( 15, 22 ] 13 0.009% 99.989% ( 22, 34 ] 2 0.001% 99.990% ( 34, 51 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 3 0.002% 99.995% ( 380, 580 ] 3 0.002% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28883 Average: 5.0334 StdDev: 81.15 Min: 0 Median: 1.5401 Max: 4421 Percentiles: P50: 1.54 P75: 1.92 P99: 5.99 P99.9: 950.05 P99.99: 3995.36 ------------------------------------------------------ [ 0, 1 ] 4152 14.375% 14.375% ### ( 1, 2 ] 19050 65.956% 80.331% ############# ( 2, 3 ] 3395 11.754% 92.085% ## ( 3, 4 ] 1183 4.096% 96.181% # ( 4, 6 ] 820 2.839% 99.020% # ( 6, 10 ] 134 0.464% 99.484% ( 10, 15 ] 24 0.083% 99.567% ( 15, 22 ] 4 0.014% 99.581% ( 22, 34 ] 37 0.128% 99.709% ( 34, 51 ] 19 0.066% 99.775% ( 51, 76 ] 2 0.007% 99.782% ( 76, 110 ] 2 0.007% 99.789% ( 110, 170 ] 8 0.028% 99.817% ( 170, 250 ] 4 0.014% 99.830% ( 250, 380 ] 2 0.007% 99.837% ( 380, 580 ] 5 0.017% 99.855% ( 580, 870 ] 12 0.042% 99.896% ( 870, 1300 ] 6 0.021% 99.917% ( 1300, 1900 ] 10 0.035% 99.952% ( 1900, 2900 ] 6 0.021% 99.972% ( 2900, 4400 ] 7 0.024% 99.997% ( 4400, 6600 ] 1 0.003% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1762.1000 StdDev: 1258.16 Min: 542 Median: 1471.4286 Max: 4905 Percentiles: P50: 1471.43 P75: 1900.00 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 6 30.000% 35.000% ###### ( 870, 1300 ] 1 5.000% 40.000% # ( 1300, 1900 ] 7 35.000% 75.000% ####### ( 1900, 2900 ] 2 10.000% 85.000% ## ( 2900, 4400 ] 1 5.000% 90.000% # ( 4400, 6600 ] 2 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 40 Average: 527.3500 StdDev: 661.56 Min: 73 Median: 223.3333 Max: 2951 Percentiles: P50: 223.33 P75: 652.50 P99: 2951.00 P99.9: 2951.00 P99.99: 2951.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 5 12.500% 15.000% ### ( 110, 170 ] 12 30.000% 45.000% ###### ( 170, 250 ] 3 7.500% 52.500% ## ( 250, 380 ] 4 10.000% 62.500% ## ( 380, 580 ] 4 10.000% 72.500% ## ( 580, 870 ] 4 10.000% 82.500% ## ( 870, 1300 ] 2 5.000% 87.500% # ( 1300, 1900 ] 2 5.000% 92.500% # ( 1900, 2900 ] 2 5.000% 97.500% # ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 17.2 total, 5.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 285.57 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.710 H:M:S, 21.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 184.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:2.561 H:M:S, 48.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/01-22:42:36 ... thread 0: (1000000,6000000) ops and (109246.5,229195.9) ops/second in (9.153615,26.178476) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/9 2.08 GB 6.3 5.5 0.0 5.5 11.1 5.6 0.0 2.0 151.2 303.8 37.49 35.06 100 0.375 5755K 11K 0.0 0.0 L1 13/13 1.40 GB 0.0 3.6 3.4 0.2 3.5 3.3 0.1 1.0 230.5 227.7 15.85 15.03 3 5.285 3710K 43K 0.0 0.0 L2 2/0 51.49 MB 0.5 0.1 0.1 0.1 0.1 0.1 2.0 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 15/0 974.94 MB 1.0 0.8 0.6 0.1 0.8 0.6 1.6 1.2 193.9 193.7 3.97 3.38 3 1.324 764K 512 0.0 0.0 L4 164/0 9.71 GB 1.0 0.7 0.6 0.1 0.7 0.6 1.5 1.2 176.9 176.1 4.04 3.19 5 0.807 725K 3007 0.0 0.0 L5 1064/0 87.48 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/22 101.68 GB 0.0 10.7 4.7 6.0 16.2 10.2 7.1 2.9 176.6 268.3 61.89 57.19 112 0.553 11M 58K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.7 4.7 6.0 16.2 10.2 7.0 2.9 176.6 268.3 61.89 57.19 112 0.553 11M 58K 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 4.7 6.0 10.6 4.6 0.0 0.0 239.2 237.9 45.70 42.82 29 1.576 11M 58K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 354.0 16.19 14.36 83 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 26.4 total, 26.2 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 16.22 GB write, 629.35 MB/s write, 10.68 GB read, 414.33 MB/s read, 61.9 seconds Interval compaction: 16.22 GB write, 634.29 MB/s write, 10.68 GB read, 417.58 MB/s read, 61.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 19, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2461520 Average: 2.3671 StdDev: 15.41 Min: 0 Median: 1.4063 Max: 8045 Percentiles: P50: 1.41 P75: 1.80 P99: 5.97 P99.9: 116.80 P99.99: 239.17 ------------------------------------------------------ [ 0, 1 ] 588476 23.907% 23.907% ##### ( 1, 2 ] 1580846 64.222% 88.129% ############# ( 2, 3 ] 158613 6.444% 94.573% # ( 3, 4 ] 70451 2.862% 97.435% # ( 4, 6 ] 39174 1.591% 99.027% ( 6, 10 ] 17273 0.702% 99.728% ( 10, 15 ] 1664 0.068% 99.796% ( 15, 22 ] 244 0.010% 99.806% ( 22, 34 ] 12 0.000% 99.806% ( 34, 51 ] 11 0.000% 99.807% ( 51, 76 ] 45 0.002% 99.809% ( 76, 110 ] 2020 0.082% 99.891% ( 110, 170 ] 2051 0.083% 99.974% ( 170, 250 ] 459 0.019% 99.993% ( 250, 380 ] 302 0.012% 100.005% ( 380, 580 ] 175 0.007% 100.012% ( 580, 870 ] 113 0.005% 100.017% ( 870, 1300 ] 35 0.001% 100.018% ( 1300, 1900 ] 16 0.001% 100.019% ( 1900, 2900 ] 11 0.000% 100.019% ( 2900, 4400 ] 11 0.000% 100.020% ( 4400, 6600 ] 1 0.000% 100.020% ( 6600, 9900 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 309588 Average: 3.0196 StdDev: 25.63 Min: 0 Median: 1.6658 Max: 4373 Percentiles: P50: 1.67 P75: 2.33 P99: 7.25 P99.9: 13.12 P99.99: 15.57 ------------------------------------------------------ [ 0, 1 ] 31294 10.108% 10.108% ## ( 1, 2 ] 185480 59.912% 70.020% ############ ( 2, 3 ] 47381 15.305% 85.325% ### ( 3, 4 ] 21870 7.064% 92.389% # ( 4, 6 ] 19403 6.267% 98.656% # ( 6, 10 ] 3397 1.097% 99.754% ( 10, 15 ] 727 0.235% 99.988% ( 15, 22 ] 62 0.020% 100.008% ( 22, 34 ] 10 0.003% 100.012% ( 34, 51 ] 4 0.001% 100.013% ( 51, 76 ] 2 0.001% 100.014% ( 76, 110 ] 40 0.013% 100.026% ( 110, 170 ] 61 0.020% 100.046% ( 170, 250 ] 34 0.011% 100.057% ( 250, 380 ] 52 0.017% 100.074% ( 380, 580 ] 49 0.016% 100.090% ( 580, 870 ] 42 0.014% 100.103% ( 870, 1300 ] 22 0.007% 100.110% ( 1300, 1900 ] 14 0.005% 100.115% ( 1900, 2900 ] 5 0.002% 100.117% ( 2900, 4400 ] 7 0.002% 100.119% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 83810 Average: 10.0031 StdDev: 102.58 Min: 0 Median: 1.6614 Max: 4421 Percentiles: P50: 1.66 P75: 2.30 P99: 182.19 P99.9: 1209.02 P99.99: 2746.26 ------------------------------------------------------ [ 0, 1 ] 8281 9.881% 9.881% ## ( 1, 2 ] 50836 60.656% 70.537% ############ ( 2, 3 ] 12505 14.921% 85.458% ### ( 3, 4 ] 6027 7.191% 92.649% # ( 4, 6 ] 3857 4.602% 97.251% # ( 6, 10 ] 1010 1.205% 98.456% ( 10, 15 ] 207 0.247% 98.703% ( 15, 22 ] 24 0.029% 98.732% ( 22, 34 ] 41 0.049% 98.781% ( 34, 51 ] 20 0.024% 98.804% ( 51, 76 ] 3 0.004% 98.808% ( 76, 110 ] 24 0.029% 98.837% ( 110, 170 ] 111 0.132% 98.969% ( 170, 250 ] 170 0.203% 99.172% ( 250, 380 ] 169 0.202% 99.374% ( 380, 580 ] 230 0.274% 99.648% ( 580, 870 ] 156 0.186% 99.834% ( 870, 1300 ] 70 0.084% 99.918% ( 1300, 1900 ] 31 0.037% 99.955% ( 1900, 2900 ] 35 0.042% 99.996% ( 2900, 4400 ] 30 0.036% 100.032% ( 4400, 6600 ] 1 0.001% 100.033% ** Level 4 read latency histogram (micros): Count: 105 Average: 451.6762 StdDev: 888.66 Min: 1 Median: 3.7000 Max: 4905 Percentiles: P50: 3.70 P75: 567.50 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ [ 0, 1 ] 9 8.571% 8.571% ## ( 1, 2 ] 32 30.476% 39.048% ###### ( 2, 3 ] 8 7.619% 46.667% ## ( 3, 4 ] 5 4.762% 51.429% # ( 4, 6 ] 1 0.952% 52.381% ( 15, 22 ] 1 0.952% 53.333% ( 22, 34 ] 1 0.952% 54.286% ( 76, 110 ] 1 0.952% 55.238% ( 110, 170 ] 5 4.762% 60.000% # ( 170, 250 ] 9 8.571% 68.571% ## ( 250, 380 ] 3 2.857% 71.429% # ( 380, 580 ] 4 3.810% 75.238% # ( 580, 870 ] 10 9.524% 84.762% ## ( 870, 1300 ] 3 2.857% 87.619% # ( 1300, 1900 ] 7 6.667% 94.286% # ( 1900, 2900 ] 3 2.857% 97.143% # ( 2900, 4400 ] 1 0.952% 98.095% ( 4400, 6600 ] 2 1.905% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 848.0750 StdDev: 1019.29 Min: 73 Median: 393.3333 Max: 4786 Percentiles: P50: 393.33 P75: 1171.00 P99: 4357.14 P99.9: 4786.00 P99.99: 4786.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 12 10.000% 10.833% ## ( 110, 170 ] 21 17.500% 28.333% #### ( 170, 250 ] 13 10.833% 39.167% ## ( 250, 380 ] 12 10.000% 49.167% ## ( 380, 580 ] 15 12.500% 61.667% ### ( 580, 870 ] 9 7.500% 69.167% ## ( 870, 1300 ] 10 8.333% 77.500% ## ( 1300, 1900 ] 10 8.333% 85.833% ## ( 1900, 2900 ] 9 7.500% 93.333% ## ( 2900, 4400 ] 7 5.833% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 26.4 total, 9.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 223.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:9.856 H:M:S, 37.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 107.52 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.146 H:M:S, 67.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/01-22:42:39 ... thread 0: (1000000,7000000) ops and (324274.5,239215.8) ops/second in (3.083807,29.262283) 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/9 3.07 GB 107.0 6.4 0.0 6.4 13.0 6.6 0.0 2.0 150.0 304.0 43.68 40.89 117 0.373 6651K 12K 0.0 0.0 L1 13/13 1.40 GB 0.0 3.6 3.4 0.2 3.5 3.3 0.1 1.0 230.5 227.7 15.85 15.03 3 5.285 3710K 43K 0.0 0.0 L2 2/0 51.49 MB 0.5 0.1 0.1 0.1 0.1 0.1 2.0 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 15/0 974.94 MB 1.0 0.8 0.6 0.1 0.8 0.6 1.6 1.2 193.9 193.7 3.97 3.38 3 1.324 764K 512 0.0 0.0 L4 164/0 9.71 GB 1.0 0.7 0.6 0.1 0.7 0.6 1.5 1.2 176.9 176.1 4.04 3.19 5 0.807 725K 3007 0.0 0.0 L5 1064/0 87.48 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1273/22 102.66 GB 0.0 11.5 4.7 6.9 18.1 11.2 7.1 2.7 173.5 271.6 68.08 63.02 129 0.528 11M 59K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.5 4.7 6.9 18.1 11.2 7.0 2.7 173.5 271.6 68.08 63.02 129 0.528 11M 59K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 11.5 4.7 6.9 11.5 4.6 0.0 0.0 241.0 239.8 49.02 46.09 32 1.532 11M 59K 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 353.5 19.07 16.93 97 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 29.5 total, 29.3 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.06 GB write, 627.58 MB/s write, 11.54 GB read, 400.90 MB/s read, 68.1 seconds Interval compaction: 18.06 GB write, 632.00 MB/s write, 11.54 GB read, 403.72 MB/s read, 68.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 22, interval: 35 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2865417 Average: 2.3565 StdDev: 14.62 Min: 0 Median: 1.4248 Max: 8045 Percentiles: P50: 1.42 P75: 1.81 P99: 5.95 P99.9: 106.18 P99.99: 214.17 ------------------------------------------------------ [ 0, 1 ] 645527 22.528% 22.528% ##### ( 1, 2 ] 1853201 64.675% 87.203% ############# ( 2, 3 ] 203704 7.109% 94.312% # ( 3, 4 ] 86133 3.006% 97.318% # ( 4, 6 ] 49451 1.726% 99.044% ( 6, 10 ] 20400 0.712% 99.756% ( 10, 15 ] 1993 0.070% 99.825% ( 15, 22 ] 269 0.009% 99.835% ( 22, 34 ] 15 0.001% 99.835% ( 34, 51 ] 11 0.000% 99.836% ( 51, 76 ] 50 0.002% 99.837% ( 76, 110 ] 2026 0.071% 99.908% ( 110, 170 ] 2082 0.073% 99.981% ( 170, 250 ] 488 0.017% 99.998% ( 250, 380 ] 325 0.011% 100.009% ( 380, 580 ] 194 0.007% 100.016% ( 580, 870 ] 123 0.004% 100.020% ( 870, 1300 ] 41 0.001% 100.021% ( 1300, 1900 ] 17 0.001% 100.022% ( 1900, 2900 ] 12 0.000% 100.023% ( 2900, 4400 ] 11 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ( 6600, 9900 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 333504 Average: 2.9880 StdDev: 24.86 Min: 0 Median: 1.6530 Max: 4373 Percentiles: P50: 1.65 P75: 2.27 P99: 7.35 P99.9: 13.41 P99.99: 27.07 ------------------------------------------------------ [ 0, 1 ] 34635 10.385% 10.385% ## ( 1, 2 ] 202314 60.663% 71.048% ############ ( 2, 3 ] 49454 14.829% 85.877% ### ( 3, 4 ] 22608 6.779% 92.656% # ( 4, 6 ] 19879 5.961% 98.617% # ( 6, 10 ] 3778 1.133% 99.749% ( 10, 15 ] 736 0.221% 99.970% ( 15, 22 ] 62 0.019% 99.989% ( 22, 34 ] 11 0.003% 99.992% ( 34, 51 ] 4 0.001% 99.993% ( 51, 76 ] 2 0.001% 99.994% ( 76, 110 ] 76 0.023% 100.016% ( 110, 170 ] 78 0.023% 100.040% ( 170, 250 ] 38 0.011% 100.051% ( 250, 380 ] 53 0.016% 100.067% ( 380, 580 ] 52 0.016% 100.083% ( 580, 870 ] 44 0.013% 100.096% ( 870, 1300 ] 22 0.007% 100.103% ( 1300, 1900 ] 14 0.004% 100.107% ( 1900, 2900 ] 5 0.001% 100.108% ( 2900, 4400 ] 7 0.002% 100.110% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 83810 Average: 10.0031 StdDev: 102.58 Min: 0 Median: 1.6614 Max: 4421 Percentiles: P50: 1.66 P75: 2.30 P99: 182.19 P99.9: 1209.02 P99.99: 2746.26 ------------------------------------------------------ [ 0, 1 ] 8281 9.881% 9.881% ## ( 1, 2 ] 50836 60.656% 70.537% ############ ( 2, 3 ] 12505 14.921% 85.458% ### ( 3, 4 ] 6027 7.191% 92.649% # ( 4, 6 ] 3857 4.602% 97.251% # ( 6, 10 ] 1010 1.205% 98.456% ( 10, 15 ] 207 0.247% 98.703% ( 15, 22 ] 24 0.029% 98.732% ( 22, 34 ] 41 0.049% 98.781% ( 34, 51 ] 20 0.024% 98.804% ( 51, 76 ] 3 0.004% 98.808% ( 76, 110 ] 24 0.029% 98.837% ( 110, 170 ] 111 0.132% 98.969% ( 170, 250 ] 170 0.203% 99.172% ( 250, 380 ] 169 0.202% 99.374% ( 380, 580 ] 230 0.274% 99.648% ( 580, 870 ] 156 0.186% 99.834% ( 870, 1300 ] 70 0.084% 99.918% ( 1300, 1900 ] 31 0.037% 99.955% ( 1900, 2900 ] 35 0.042% 99.996% ( 2900, 4400 ] 30 0.036% 100.032% ( 4400, 6600 ] 1 0.001% 100.033% ** Level 4 read latency histogram (micros): Count: 105 Average: 451.6762 StdDev: 888.66 Min: 1 Median: 3.7000 Max: 4905 Percentiles: P50: 3.70 P75: 567.50 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ [ 0, 1 ] 9 8.571% 8.571% ## ( 1, 2 ] 32 30.476% 39.048% ###### ( 2, 3 ] 8 7.619% 46.667% ## ( 3, 4 ] 5 4.762% 51.429% # ( 4, 6 ] 1 0.952% 52.381% ( 15, 22 ] 1 0.952% 53.333% ( 22, 34 ] 1 0.952% 54.286% ( 76, 110 ] 1 0.952% 55.238% ( 110, 170 ] 5 4.762% 60.000% # ( 170, 250 ] 9 8.571% 68.571% ## ( 250, 380 ] 3 2.857% 71.429% # ( 380, 580 ] 4 3.810% 75.238% # ( 580, 870 ] 10 9.524% 84.762% ## ( 870, 1300 ] 3 2.857% 87.619% # ( 1300, 1900 ] 7 6.667% 94.286% # ( 1900, 2900 ] 3 2.857% 97.143% # ( 2900, 4400 ] 1 0.952% 98.095% ( 4400, 6600 ] 2 1.905% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 848.0750 StdDev: 1019.29 Min: 73 Median: 393.3333 Max: 4786 Percentiles: P50: 393.33 P75: 1171.00 P99: 4357.14 P99.9: 4786.00 P99.99: 4786.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 12 10.000% 10.833% ## ( 110, 170 ] 21 17.500% 28.333% #### ( 170, 250 ] 13 10.833% 39.167% ## ( 250, 380 ] 12 10.000% 49.167% ## ( 380, 580 ] 15 12.500% 61.667% ### ( 580, 870 ] 9 7.500% 69.167% ## ( 870, 1300 ] 10 8.333% 77.500% ## ( 1300, 1900 ] 10 8.333% 85.833% ## ( 1900, 2900 ] 9 7.500% 93.333% ## ( 2900, 4400 ] 7 5.833% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 29.5 total, 3.1 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 233.78 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:10.291 H:M:S, 34.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.15 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.435 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/01-22:42:49 ... thread 0: (1000000,8000000) ops and (94022.7,200511.2) ops/second in (10.635732,39.898015) 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/9 2.34 GB 18.9 7.5 0.0 7.5 15.1 7.6 0.0 2.0 148.6 298.2 51.70 47.64 134 0.386 7802K 13K 0.0 0.0 L1 15/15 1.70 GB 0.0 6.7 5.1 1.6 6.6 5.0 0.1 1.3 233.5 230.9 29.31 27.99 4 7.328 6539K 43K 0.0 0.0 L2 1/0 75.19 MB 0.8 0.1 0.1 0.1 0.1 0.1 3.4 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 38/9 2.30 GB 1.6 2.1 1.2 1.0 2.1 1.2 2.4 1.8 141.5 140.5 15.52 9.93 11 1.411 2212K 15K 0.0 0.0 L4 164/13 9.71 GB 1.0 0.7 0.6 0.1 0.7 0.6 1.5 1.2 176.9 176.1 4.04 3.19 5 0.807 725K 3007 0.0 0.0 L5 1064/0 87.48 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1293/46 103.60 GB 0.0 17.2 6.9 10.2 24.6 14.4 9.3 3.3 173.7 249.3 101.11 89.27 155 0.652 17M 75K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.2 6.9 10.2 24.6 14.4 9.2 3.3 173.7 249.3 101.11 89.27 155 0.652 17M 75K 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.2 6.9 10.2 17.0 6.8 0.0 0.0 224.5 223.1 78.25 69.75 45 1.739 17M 75K 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 339.0 22.85 19.52 110 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): 40.1 total, 39.9 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.61 GB write, 628.46 MB/s write, 17.15 GB read, 437.98 MB/s read, 101.1 seconds Interval compaction: 24.61 GB write, 631.71 MB/s write, 17.15 GB read, 440.24 MB/s read, 101.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 32, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 23, total-stops: 32, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3353918 Average: 2.5102 StdDev: 24.49 Min: 0 Median: 1.4320 Max: 8045 Percentiles: P50: 1.43 P75: 1.82 P99: 5.98 P99.9: 107.84 P99.99: 296.23 ------------------------------------------------------ [ 0, 1 ] 739947 22.062% 22.062% #### ( 1, 2 ] 2168906 64.668% 86.730% ############# ( 2, 3 ] 244416 7.287% 94.017% # ( 3, 4 ] 104238 3.108% 97.125% # ( 4, 6 ] 63512 1.894% 99.019% ( 6, 10 ] 24703 0.737% 99.756% ( 10, 15 ] 2461 0.073% 99.829% ( 15, 22 ] 331 0.010% 99.839% ( 22, 34 ] 21 0.001% 99.840% ( 34, 51 ] 12 0.000% 99.840% ( 51, 76 ] 53 0.002% 99.841% ( 76, 110 ] 2097 0.063% 99.904% ( 110, 170 ] 2201 0.066% 99.970% ( 170, 250 ] 542 0.016% 99.986% ( 250, 380 ] 401 0.012% 99.998% ( 380, 580 ] 296 0.009% 100.007% ( 580, 870 ] 259 0.008% 100.014% ( 870, 1300 ] 120 0.004% 100.018% ( 1300, 1900 ] 67 0.002% 100.020% ( 1900, 2900 ] 29 0.001% 100.021% ( 2900, 4400 ] 52 0.002% 100.022% ( 4400, 6600 ] 15 0.000% 100.023% ( 6600, 9900 ] 2 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1032381 Average: 4.0009 StdDev: 63.55 Min: 0 Median: 1.6024 Max: 11757 Percentiles: P50: 1.60 P75: 2.20 P99: 8.53 P99.9: 14.95 P99.99: 106.25 ------------------------------------------------------ [ 0, 1 ] 165790 16.059% 16.059% ### ( 1, 2 ] 581683 56.344% 72.403% ########### ( 2, 3 ] 132097 12.795% 85.198% ### ( 3, 4 ] 66276 6.420% 91.618% # ( 4, 6 ] 65162 6.312% 97.930% # ( 6, 10 ] 17466 1.692% 99.622% ( 10, 15 ] 2903 0.281% 99.903% ( 15, 22 ] 357 0.035% 99.937% ( 22, 34 ] 36 0.003% 99.941% ( 34, 51 ] 23 0.002% 99.943% ( 51, 76 ] 64 0.006% 99.949% ( 76, 110 ] 473 0.046% 99.995% ( 110, 170 ] 405 0.039% 100.034% ( 170, 250 ] 203 0.020% 100.054% ( 250, 380 ] 273 0.026% 100.080% ( 380, 580 ] 270 0.026% 100.107% ( 580, 870 ] 246 0.024% 100.130% ( 870, 1300 ] 136 0.013% 100.144% ( 1300, 1900 ] 83 0.008% 100.152% ( 1900, 2900 ] 81 0.008% 100.159% ( 2900, 4400 ] 88 0.009% 100.168% ( 4400, 6600 ] 38 0.004% 100.172% ( 6600, 9900 ] 14 0.001% 100.173% ( 9900, 14000 ] 1 0.000% 100.173% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 172237 Average: 13.6276 StdDev: 140.45 Min: 0 Median: 1.7772 Max: 8270 Percentiles: P50: 1.78 P75: 2.72 P99: 235.47 P99.9: 1243.69 P99.99: 1934.33 ------------------------------------------------------ [ 0, 1 ] 12029 6.984% 6.984% # ( 1, 2 ] 95326 55.346% 62.330% ########### ( 2, 3 ] 30127 17.492% 79.821% ### ( 3, 4 ] 15888 9.224% 89.046% ## ( 4, 6 ] 13240 7.687% 96.733% ## ( 6, 10 ] 2766 1.606% 98.339% ( 10, 15 ] 567 0.329% 98.668% ( 15, 22 ] 89 0.052% 98.720% ( 22, 34 ] 50 0.029% 98.749% ( 34, 51 ] 24 0.014% 98.763% ( 51, 76 ] 5 0.003% 98.766% ( 76, 110 ] 38 0.022% 98.788% ( 110, 170 ] 156 0.091% 98.878% ( 170, 250 ] 261 0.152% 99.030% ( 250, 380 ] 329 0.191% 99.221% ( 380, 580 ] 497 0.289% 99.509% ( 580, 870 ] 423 0.246% 99.755% ( 870, 1300 ] 292 0.170% 99.925% ( 1300, 1900 ] 113 0.066% 99.990% ( 1900, 2900 ] 110 0.064% 100.054% ( 2900, 4400 ] 87 0.051% 100.105% ( 4400, 6600 ] 16 0.009% 100.114% ( 6600, 9900 ] 5 0.003% 100.117% ** Level 4 read latency histogram (micros): Count: 105 Average: 451.6762 StdDev: 888.66 Min: 1 Median: 3.7000 Max: 4905 Percentiles: P50: 3.70 P75: 567.50 P99: 4905.00 P99.9: 4905.00 P99.99: 4905.00 ------------------------------------------------------ [ 0, 1 ] 9 8.571% 8.571% ## ( 1, 2 ] 32 30.476% 39.048% ###### ( 2, 3 ] 8 7.619% 46.667% ## ( 3, 4 ] 5 4.762% 51.429% # ( 4, 6 ] 1 0.952% 52.381% ( 15, 22 ] 1 0.952% 53.333% ( 22, 34 ] 1 0.952% 54.286% ( 76, 110 ] 1 0.952% 55.238% ( 110, 170 ] 5 4.762% 60.000% # ( 170, 250 ] 9 8.571% 68.571% ## ( 250, 380 ] 3 2.857% 71.429% # ( 380, 580 ] 4 3.810% 75.238% # ( 580, 870 ] 10 9.524% 84.762% ## ( 870, 1300 ] 3 2.857% 87.619% # ( 1300, 1900 ] 7 6.667% 94.286% # ( 1900, 2900 ] 3 2.857% 97.143% # ( 2900, 4400 ] 1 0.952% 98.095% ( 4400, 6600 ] 2 1.905% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 848.0750 StdDev: 1019.29 Min: 73 Median: 393.3333 Max: 4786 Percentiles: P50: 393.33 P75: 1171.00 P99: 4357.14 P99.9: 4786.00 P99.99: 4786.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 12 10.000% 10.833% ## ( 110, 170 ] 21 17.500% 28.333% #### ( 170, 250 ] 13 10.833% 39.167% ## ( 250, 380 ] 12 10.000% 49.167% ## ( 380, 580 ] 15 12.500% 61.667% ### ( 580, 870 ] 9 7.500% 69.167% ## ( 870, 1300 ] 10 8.333% 77.500% ## ( 1300, 1900 ] 10 8.333% 85.833% ## ( 1900, 2900 ] 9 7.500% 93.333% ## ( 2900, 4400 ] 7 5.833% 99.167% # ( 4400, 6600 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 40.1 total, 10.6 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 196.32 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.835 H:M:S, 44.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 92.54 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:7.544 H:M:S, 70.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/01-22:42:53 ... thread 0: (1000000,9000000) ops and (275726.0,206778.6) ops/second in (3.626789,43.524804) 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/13 3.26 GB 81.8 8.1 0.0 8.1 16.6 8.5 0.0 2.0 144.6 295.6 57.49 52.43 149 0.386 8442K 14K 0.0 0.0 L1 15/15 1.70 GB 0.0 6.7 5.1 1.6 6.6 5.0 0.1 1.3 233.5 230.9 29.31 27.99 4 7.328 6539K 43K 0.0 0.0 L2 1/0 75.19 MB 0.8 0.1 0.1 0.1 0.1 0.1 3.4 2.0 233.2 233.1 0.54 0.52 1 0.540 127K 44 0.0 0.0 L3 20/0 996.72 MB 1.0 2.1 1.2 1.0 2.1 1.2 2.4 1.8 141.5 140.5 15.52 9.93 11 1.411 2212K 15K 0.0 0.0 L4 163/0 9.74 GB 1.0 2.3 1.9 0.4 2.3 1.9 1.5 1.2 142.1 141.4 16.54 10.71 22 0.752 2386K 10K 0.0 0.0 L5 1080/0 88.77 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1297/28 104.51 GB 0.0 19.4 8.3 11.1 27.7 16.6 10.6 3.3 166.1 237.9 119.40 101.58 187 0.639 19M 84K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.4 8.3 11.1 27.7 16.6 10.5 3.3 166.1 237.9 119.40 101.58 187 0.639 19M 84K 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.4 8.3 11.1 19.3 8.1 0.0 0.0 212.9 211.6 93.16 79.62 64 1.456 19M 84K 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 331.4 26.24 21.96 123 0.213 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 43.7 total, 43.5 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.74 GB write, 649.56 MB/s write, 19.37 GB read, 453.47 MB/s read, 119.4 seconds Interval compaction: 27.74 GB write, 652.64 MB/s write, 19.37 GB read, 455.61 MB/s read, 119.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 27, total-stops: 46, interval: 73 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3765219 Average: 2.5254 StdDev: 24.94 Min: 0 Median: 1.4474 Max: 14332 Percentiles: P50: 1.45 P75: 1.83 P99: 6.13 P99.9: 104.38 P99.99: 270.73 ------------------------------------------------------ [ 0, 1 ] 793869 21.084% 21.084% #### ( 1, 2 ] 2433336 64.627% 85.711% ############# ( 2, 3 ] 291451 7.741% 93.452% ## ( 3, 4 ] 126721 3.366% 96.817% # ( 4, 6 ] 81213 2.157% 98.974% ( 6, 10 ] 29519 0.784% 99.758% ( 10, 15 ] 3037 0.081% 99.839% ( 15, 22 ] 397 0.011% 99.849% ( 22, 34 ] 28 0.001% 99.850% ( 34, 51 ] 19 0.001% 99.851% ( 51, 76 ] 55 0.001% 99.852% ( 76, 110 ] 2169 0.058% 99.910% ( 110, 170 ] 2349 0.062% 99.972% ( 170, 250 ] 611 0.016% 99.988% ( 250, 380 ] 442 0.012% 100.000% ( 380, 580 ] 337 0.009% 100.009% ( 580, 870 ] 281 0.007% 100.016% ( 870, 1300 ] 125 0.003% 100.020% ( 1300, 1900 ] 68 0.002% 100.021% ( 1900, 2900 ] 35 0.001% 100.022% ( 2900, 4400 ] 54 0.001% 100.024% ( 4400, 6600 ] 16 0.000% 100.024% ( 6600, 9900 ] 2 0.000% 100.024% ( 14000, 22000 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1079963 Average: 4.3461 StdDev: 84.33 Min: 0 Median: 1.6169 Max: 25230 Percentiles: P50: 1.62 P75: 2.27 P99: 8.66 P99.9: 16.17 P99.99: 115.48 ------------------------------------------------------ [ 0, 1 ] 166997 15.463% 15.463% ### ( 1, 2 ] 604650 55.988% 71.451% ########### ( 2, 3 ] 142519 13.197% 84.648% ### ( 3, 4 ] 71514 6.622% 91.270% # ( 4, 6 ] 70879 6.563% 97.833% # ( 6, 10 ] 18954 1.755% 99.588% ( 10, 15 ] 3304 0.306% 99.894% ( 15, 22 ] 395 0.037% 99.930% ( 22, 34 ] 41 0.004% 99.934% ( 34, 51 ] 27 0.003% 99.937% ( 51, 76 ] 65 0.006% 99.943% ( 76, 110 ] 473 0.044% 99.987% ( 110, 170 ] 405 0.038% 100.024% ( 170, 250 ] 206 0.019% 100.043% ( 250, 380 ] 276 0.026% 100.069% ( 380, 580 ] 279 0.026% 100.095% ( 580, 870 ] 254 0.024% 100.118% ( 870, 1300 ] 140 0.013% 100.131% ( 1300, 1900 ] 90 0.008% 100.139% ( 1900, 2900 ] 95 0.009% 100.148% ( 2900, 4400 ] 108 0.010% 100.158% ( 4400, 6600 ] 50 0.005% 100.163% ( 6600, 9900 ] 28 0.003% 100.165% ( 9900, 14000 ] 6 0.001% 100.166% ( 22000, 33000 ] 2 0.000% 100.166% ** Level 2 read latency histogram (micros): Count: 31747 Average: 2.7294 StdDev: 35.11 Min: 0 Median: 1.5129 Max: 3532 Percentiles: P50: 1.51 P75: 1.91 P99: 5.88 P99.9: 11.01 P99.99: 2175.10 ------------------------------------------------------ [ 0, 1 ] 5731 18.052% 18.052% #### ( 1, 2 ] 19776 62.293% 80.345% ############ ( 2, 3 ] 3047 9.598% 89.942% ## ( 3, 4 ] 1783 5.616% 95.559% # ( 4, 6 ] 1160 3.654% 99.213% # ( 6, 10 ] 214 0.674% 99.887% ( 10, 15 ] 21 0.066% 99.953% ( 15, 22 ] 1 0.003% 99.956% ( 22, 34 ] 2 0.006% 99.962% ( 110, 170 ] 2 0.006% 99.969% ( 250, 380 ] 2 0.006% 99.975% ( 580, 870 ] 1 0.003% 99.978% ( 870, 1300 ] 1 0.003% 99.981% ( 1300, 1900 ] 2 0.006% 99.987% ( 1900, 2900 ] 3 0.009% 99.997% ( 2900, 4400 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 425812 Average: 8.8154 StdDev: 108.27 Min: 0 Median: 1.8528 Max: 12146 Percentiles: P50: 1.85 P75: 2.90 P99: 9.72 P99.9: 656.19 P99.99: 860.11 ------------------------------------------------------ [ 0, 1 ] 20071 4.714% 4.714% # ( 1, 2 ] 226115 53.102% 57.816% ########### ( 2, 3 ] 81394 19.115% 76.931% #### ( 3, 4 ] 45048 10.579% 87.510% ## ( 4, 6 ] 42339 9.943% 97.453% ## ( 6, 10 ] 7075 1.662% 99.115% ( 10, 15 ] 1344 0.316% 99.430% ( 15, 22 ] 195 0.046% 99.476% ( 22, 34 ] 59 0.014% 99.490% ( 34, 51 ] 31 0.007% 99.497% ( 51, 76 ] 8 0.002% 99.499% ( 76, 110 ] 46 0.011% 99.510% ( 110, 170 ] 184 0.043% 99.553% ( 170, 250 ] 317 0.074% 99.628% ( 250, 380 ] 399 0.094% 99.721% ( 380, 580 ] 618 0.145% 99.866% ( 580, 870 ] 545 0.128% 99.994% ( 870, 1300 ] 375 0.088% 100.082% ( 1300, 1900 ] 155 0.036% 100.119% ( 1900, 2900 ] 150 0.035% 100.154% ( 2900, 4400 ] 139 0.033% 100.187% ( 4400, 6600 ] 23 0.005% 100.192% ( 6600, 9900 ] 5 0.001% 100.193% ( 9900, 14000 ] 1 0.000% 100.194% ** Level 4 read latency histogram (micros): Count: 25092 Average: 18.7506 StdDev: 215.43 Min: 1 Median: 1.9232 Max: 9393 Percentiles: P50: 1.92 P75: 3.06 P99: 278.10 P99.9: 3561.56 P99.99: 6047.98 ------------------------------------------------------ [ 0, 1 ] 595 2.371% 2.371% ( 1, 2 ] 12945 51.590% 53.961% ########## ( 2, 3 ] 5129 20.441% 74.402% #### ( 3, 4 ] 2609 10.398% 84.800% ## ( 4, 6 ] 2789 11.115% 95.915% ## ( 6, 10 ] 528 2.104% 98.019% ( 10, 15 ] 135 0.538% 98.557% ( 15, 22 ] 15 0.060% 98.617% ( 22, 34 ] 5 0.020% 98.637% ( 34, 51 ] 2 0.008% 98.645% ( 51, 76 ] 4 0.016% 98.661% ( 76, 110 ] 9 0.036% 98.697% ( 110, 170 ] 22 0.088% 98.784% ( 170, 250 ] 45 0.179% 98.964% ( 250, 380 ] 42 0.167% 99.131% ( 380, 580 ] 48 0.191% 99.322% ( 580, 870 ] 54 0.215% 99.538% ( 870, 1300 ] 29 0.116% 99.653% ( 1300, 1900 ] 27 0.108% 99.761% ( 1900, 2900 ] 23 0.092% 99.853% ( 2900, 4400 ] 27 0.108% 99.960% ( 4400, 6600 ] 10 0.040% 100.000% ( 6600, 9900 ] 4 0.016% 100.016% ** Level 5 read latency histogram (micros): Count: 200 Average: 971.8400 StdDev: 1097.29 Min: 73 Median: 500.0000 Max: 5552 Percentiles: P50: 500.00 P75: 1409.09 P99: 5133.33 P99.9: 5552.00 P99.99: 5552.00 ------------------------------------------------------ ( 51, 76 ] 1 0.500% 0.500% ( 76, 110 ] 19 9.500% 10.000% ## ( 110, 170 ] 26 13.000% 23.000% ### ( 170, 250 ] 18 9.000% 32.000% ## ( 250, 380 ] 21 10.500% 42.500% ## ( 380, 580 ] 25 12.500% 55.000% ### ( 580, 870 ] 20 10.000% 65.000% ## ( 870, 1300 ] 16 8.000% 73.000% ## ( 1300, 1900 ] 22 11.000% 84.000% ## ( 1900, 2900 ] 16 8.000% 92.000% ## ( 2900, 4400 ] 13 6.500% 98.500% # ( 4400, 6600 ] 3 1.500% 100.000% ** DB Stats ** Uptime(secs): 43.7 total, 3.6 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 202.54 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:18.652 H:M:S, 42.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 271.37 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.816 H:M:S, 22.5 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 : 6.171 micros/op 162050 ops/sec 60.006 seconds 9723999 operations; 157.0 MB/s Microseconds per write: Count: 9723999 Average: 6.1706 StdDev: 483.47 Min: 1 Median: 1.7632 Max: 815287 Percentiles: P50: 1.76 P75: 2.80 P99: 9.81 P99.9: 1160.16 P99.99: 2672.86 ------------------------------------------------------ [ 0, 1 ] 1152620 11.853% 11.853% ## ( 1, 2 ] 4860480 49.984% 61.838% ########## ( 2, 3 ] 1594420 16.397% 78.234% ### ( 3, 4 ] 1347395 13.856% 92.091% ### ( 4, 6 ] 545105 5.606% 97.697% # ( 6, 10 ] 133231 1.370% 99.067% ( 10, 15 ] 47088 0.484% 99.551% ( 15, 22 ] 9903 0.102% 99.653% ( 22, 34 ] 2032 0.021% 99.674% ( 34, 51 ] 266 0.003% 99.676% ( 51, 76 ] 34 0.000% 99.677% ( 76, 110 ] 6566 0.068% 99.744% ( 110, 170 ] 2806 0.029% 99.773% ( 170, 250 ] 322 0.003% 99.777% ( 250, 380 ] 225 0.002% 99.779% ( 380, 580 ] 13 0.000% 99.779% ( 580, 870 ] 15 0.000% 99.779% ( 870, 1300 ] 17419 0.179% 99.958% ( 1300, 1900 ] 40 0.000% 99.959% ( 1900, 2900 ] 3942 0.041% 99.999% ( 2900, 4400 ] 40 0.000% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 6 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 4 0.000% 100.000% ( 170000, 250000 ] 11 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 206210 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 : 9723999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10035166968 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 : 522 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32554467 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 : 29503444801 rocksdb.compact.write.bytes COUNT : 29285044520 rocksdb.flush.write.bytes COUNT : 9842621876 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 : 48 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 : 290 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 : 9763271680 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3800064 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 : 29596349743 rocksdb.non.last.level.read.count COUNT : 7148217 rocksdb.block.checksum.compute.count COUNT : 7147221 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.412402 P95 : 3.957208 P99 : 8.442434 P100 : 815283.000000 COUNT : 9723999 SUM : 55232718 rocksdb.compaction.times.micros P50 : 1062162.162162 P95 : 2750000.000000 P99 : 15120000.000000 P100 : 18440170.000000 COUNT : 86 SUM : 138854487 rocksdb.compaction.times.cpu_micros P50 : 860000.000000 P95 : 2600000.000000 P99 : 15120000.000000 P100 : 16334373.000000 COUNT : 86 SUM : 112442679 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 : 698.289474 P95 : 7920.000000 P99 : 224400.000000 P100 : 337174.000000 COUNT : 132 SUM : 736515 rocksdb.compaction.outfile.sync.micros P50 : 1052.750000 P95 : 161150.000000 P99 : 247163.636364 P100 : 695141.000000 COUNT : 339 SUM : 9342323 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 : 104.879518 P95 : 1590.000000 P99 : 3135.000000 P100 : 4005.000000 COUNT : 253 SUM : 81769 rocksdb.table.open.io.micros P50 : 1411.340206 P95 : 7246.800000 P99 : 10433.000000 P100 : 12756.000000 COUNT : 522 SUM : 1036685 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.572860 P95 : 7.646779 P99 : 11.341671 P100 : 25241.000000 COUNT : 7145898 SUM : 44978889 rocksdb.read.block.get.micros P50 : 471.338583 P95 : 2864.516129 P99 : 5183.200000 P100 : 9412.000000 COUNT : 1044 SUM : 847891 rocksdb.write.raw.block.micros P50 : 0.512892 P95 : 0.974495 P99 : 2.841006 P100 : 35555.000000 COUNT : 9490722 SUM : 19778927 rocksdb.numfiles.in.singlecompaction P50 : 3.204545 P95 : 4.200000 P99 : 20.040000 P100 : 24.000000 COUNT : 156 SUM : 574 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.566973 P95 : 1173.562138 P99 : 2445.842038 P100 : 815084.000000 COUNT : 182157 SUM : 32575090 rocksdb.sst.read.micros P50 : 1.528260 P95 : 4.551385 P99 : 8.524593 P100 : 25230.000000 COUNT : 7148647 SUM : 30313992 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 : 9723999 SUM : 10035166968 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 : 207590.361446 P95 : 471200.000000 P99 : 972068.000000 P100 : 972068.000000 COUNT : 132 SUM : 29693647 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 : 323 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