[2024-11-20 20:16:04.246107] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-20 20:16:04.246252] [ 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_pid3810717 ] Set seed to 1732130164242592 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-20 20:16:04.356661] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-20 20:16:04.553042] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-20 20:16:04.553088] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3810717' to capture a snapshot of events at runtime. [2024-11-20 20:16:04.553098] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3810717 for offline analysis/debug. [2024-11-20 20:16:04.553126] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Nov 20 20:16:13 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/20-20:16:15 ... thread 0: (1000000,1000000) ops and (363307.7,363307.7) ops/second in (2.752488,2.752488) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.02 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 355.5 2.30 2.07 12 0.192 0 0 0.0 0.0 L2 3/2 251.71 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 11/0 930.30 MB 0.9 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.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 1179/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.4 314.8 3.80 3.52 14 0.272 383K 216 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.5 99.4 314.8 3.80 3.52 14 0.272 383K 216 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 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 355.5 2.30 2.07 12 0.192 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): 2.9 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 407.81 MB/s write, 0.37 GB read, 128.79 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 434.52 MB/s write, 0.37 GB read, 137.22 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 99571 Average: 1.9590 StdDev: 18.53 Min: 1 Median: 1.2721 Max: 3840 Percentiles: P50: 1.27 P75: 1.68 P99: 4.00 P99.9: 10.35 P99.99: 501.72 ------------------------------------------------------ [ 0, 1 ] 33339 33.483% 33.483% ####### ( 1, 2 ] 60443 60.703% 94.186% ############ ( 2, 3 ] 3458 3.473% 97.659% # ( 3, 4 ] 1338 1.344% 99.003% ( 4, 6 ] 657 0.660% 99.663% ( 6, 10 ] 232 0.233% 99.896% ( 10, 15 ] 64 0.064% 99.960% ( 15, 22 ] 12 0.012% 99.972% ( 34, 51 ] 1 0.001% 99.973% ( 51, 76 ] 3 0.003% 99.976% ( 110, 170 ] 6 0.006% 99.982% ( 170, 250 ] 2 0.002% 99.984% ( 250, 380 ] 3 0.003% 99.987% ( 380, 580 ] 5 0.005% 99.992% ( 580, 870 ] 1 0.001% 99.993% ( 870, 1300 ] 2 0.002% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 48700 Average: 2.6395 StdDev: 70.23 Min: 1 Median: 1.2974 Max: 9834 Percentiles: P50: 1.30 P75: 1.71 P99: 5.24 P99.9: 11.43 P99.99: 1726.00 ------------------------------------------------------ [ 0, 1 ] 15547 31.924% 31.924% ###### ( 1, 2 ] 29604 60.789% 92.713% ############ ( 2, 3 ] 1825 3.747% 96.460% # ( 3, 4 ] 923 1.895% 98.355% ( 4, 6 ] 506 1.039% 99.394% ( 6, 10 ] 236 0.485% 99.879% ( 10, 15 ] 36 0.074% 99.953% ( 15, 22 ] 5 0.010% 99.963% ( 51, 76 ] 1 0.002% 99.965% ( 76, 110 ] 1 0.002% 99.967% ( 250, 380 ] 3 0.006% 99.973% ( 380, 580 ] 3 0.006% 99.979% ( 580, 870 ] 2 0.004% 99.984% ( 870, 1300 ] 1 0.002% 99.986% ( 1300, 1900 ] 3 0.006% 99.992% ( 4400, 6600 ] 1 0.002% 99.994% ( 6600, 9900 ] 3 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 45 Average: 3669.3111 StdDev: 3409.72 Min: 167 Median: 1600.0000 Max: 11121 Percentiles: P50: 1600.00 P75: 6847.50 P99: 11121.00 P99.9: 11121.00 P99.99: 11121.00 ------------------------------------------------------ ( 110, 170 ] 1 2.222% 2.222% ( 170, 250 ] 1 2.222% 4.444% ( 250, 380 ] 1 2.222% 6.667% ( 380, 580 ] 6 13.333% 20.000% ### ( 580, 870 ] 1 2.222% 22.222% ( 870, 1300 ] 11 24.444% 46.667% ##### ( 1300, 1900 ] 3 6.667% 53.333% # ( 1900, 2900 ] 1 2.222% 55.556% ( 2900, 4400 ] 3 6.667% 62.222% # ( 4400, 6600 ] 5 11.111% 73.333% ## ( 6600, 9900 ] 10 22.222% 95.556% #### ( 9900, 14000 ] 2 4.444% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 3134.1600 StdDev: 3592.83 Min: 160 Median: 1450.0000 Max: 11818 Percentiles: P50: 1450.00 P75: 4306.25 P99: 11818.00 P99.9: 11818.00 P99.99: 11818.00 ------------------------------------------------------ ( 110, 170 ] 2 8.000% 8.000% ## ( 170, 250 ] 2 8.000% 16.000% ## ( 250, 380 ] 2 8.000% 24.000% ## ( 380, 580 ] 3 12.000% 36.000% ## ( 580, 870 ] 2 8.000% 44.000% ## ( 870, 1300 ] 1 4.000% 48.000% # ( 1300, 1900 ] 2 8.000% 56.000% ## ( 1900, 2900 ] 1 4.000% 60.000% # ( 2900, 4400 ] 4 16.000% 76.000% ### ( 4400, 6600 ] 2 8.000% 84.000% ## ( 6600, 9900 ] 1 4.000% 88.000% # ( 9900, 14000 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 2.9 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 335.39 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.214 H:M:S, 7.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 357.27 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.214 H:M:S, 7.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-20:16:18 ... thread 0: (1000000,2000000) ops and (326710.0,344038.3) ops/second in (3.060818,5.813306) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/6 1.17 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 98.8 319.1 8.29 7.66 29 0.286 831K 803 0.0 0.0 L1 1/1 3.62 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 234.2 233.8 1.61 1.56 1 1.614 383K 597 0.0 0.0 L2 2/1 54.95 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 21/11 1.25 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.5 1.0 233.5 233.5 1.07 1.01 1 1.068 253K 0 0.0 0.0 L4 170/0 9.45 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 149.1 149.2 1.50 1.11 1 1.504 227K 0 0.0 0.0 L5 1044/0 86.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1246/19 97.92 GB 0.0 2.0 1.0 1.0 3.8 2.8 1.5 2.1 146.6 277.2 13.97 12.79 34 0.411 2080K 1616 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 1.0 1.0 3.8 2.8 1.4 2.1 146.6 277.2 13.97 12.79 34 0.411 2080K 1616 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.0 1.0 1.0 2.0 1.0 0.0 0.0 231.7 231.6 8.84 8.22 8 1.105 2080K 1616 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 355.9 5.13 4.57 26 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.78 GB write, 646.15 MB/s write, 2.00 GB read, 341.70 MB/s read, 14.0 seconds Interval compaction: 3.78 GB write, 666.19 MB/s write, 2.00 GB read, 352.30 MB/s read, 14.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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 385185 Average: 2.2705 StdDev: 11.20 Min: 0 Median: 1.5202 Max: 3840 Percentiles: P50: 1.52 P75: 1.91 P99: 5.78 P99.9: 10.18 P99.99: 14.95 ------------------------------------------------------ [ 0, 1 ] 63690 16.535% 16.535% ### ( 1, 2 ] 247810 64.335% 80.870% ############# ( 2, 3 ] 42676 11.079% 91.950% ## ( 3, 4 ] 15608 4.052% 96.002% # ( 4, 6 ] 12975 3.369% 99.370% # ( 6, 10 ] 2029 0.527% 99.897% ( 10, 15 ] 363 0.094% 99.991% ( 15, 22 ] 43 0.011% 100.002% ( 22, 34 ] 3 0.001% 100.003% ( 34, 51 ] 5 0.001% 100.004% ( 51, 76 ] 4 0.001% 100.005% ( 110, 170 ] 8 0.002% 100.008% ( 170, 250 ] 13 0.003% 100.011% ( 250, 380 ] 6 0.002% 100.012% ( 380, 580 ] 12 0.003% 100.016% ( 580, 870 ] 9 0.002% 100.018% ( 870, 1300 ] 5 0.001% 100.019% ( 1300, 1900 ] 3 0.001% 100.020% ( 1900, 2900 ] 2 0.001% 100.021% ( 2900, 4400 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 26 Average: 173.9615 StdDev: 337.85 Min: 1 Median: 1.7500 Max: 1367 Percentiles: P50: 1.75 P75: 230.00 P99: 1367.00 P99.9: 1367.00 P99.99: 1367.00 ------------------------------------------------------ [ 0, 1 ] 4 15.385% 15.385% ### ( 1, 2 ] 12 46.154% 61.538% ######### ( 2, 3 ] 1 3.846% 65.385% # ( 4, 6 ] 1 3.846% 69.231% # ( 170, 250 ] 2 7.692% 76.923% ## ( 250, 380 ] 2 7.692% 84.615% ## ( 380, 580 ] 1 3.846% 88.462% # ( 580, 870 ] 1 3.846% 92.308% # ( 870, 1300 ] 1 3.846% 96.154% # ( 1300, 1900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95626 Average: 2.4325 StdDev: 50.12 Min: 1 Median: 1.4250 Max: 9834 Percentiles: P50: 1.42 P75: 1.82 P99: 5.65 P99.9: 9.97 P99.99: 643.42 ------------------------------------------------------ [ 0, 1 ] 22094 23.105% 23.105% ##### ( 1, 2 ] 60518 63.286% 86.391% ############# ( 2, 3 ] 7242 7.573% 93.964% ## ( 3, 4 ] 2983 3.119% 97.083% # ( 4, 6 ] 2219 2.320% 99.404% ( 6, 10 ] 478 0.500% 99.904% ( 10, 15 ] 65 0.068% 99.972% ( 15, 22 ] 9 0.009% 99.981% ( 51, 76 ] 1 0.001% 99.982% ( 76, 110 ] 1 0.001% 99.983% ( 250, 380 ] 3 0.003% 99.986% ( 380, 580 ] 3 0.003% 99.990% ( 580, 870 ] 2 0.002% 99.992% ( 870, 1300 ] 1 0.001% 99.993% ( 1300, 1900 ] 3 0.003% 99.996% ( 4400, 6600 ] 1 0.001% 99.997% ( 6600, 9900 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 180248 Average: 3.9732 StdDev: 80.90 Min: 1 Median: 1.6508 Max: 11121 Percentiles: P50: 1.65 P75: 2.21 P99: 8.99 P99.9: 163.92 P99.99: 553.22 ------------------------------------------------------ [ 0, 1 ] 17186 9.535% 9.535% ## ( 1, 2 ] 112068 62.174% 71.709% ############ ( 2, 3 ] 28447 15.782% 87.491% ### ( 3, 4 ] 9312 5.166% 92.657% # ( 4, 6 ] 9205 5.107% 97.764% # ( 6, 10 ] 2976 1.651% 99.415% ( 10, 15 ] 567 0.315% 99.730% ( 15, 22 ] 57 0.032% 99.761% ( 22, 34 ] 6 0.003% 99.765% ( 34, 51 ] 3 0.002% 99.766% ( 51, 76 ] 1 0.001% 99.767% ( 76, 110 ] 69 0.038% 99.805% ( 110, 170 ] 190 0.105% 99.911% ( 170, 250 ] 63 0.035% 99.946% ( 250, 380 ] 41 0.023% 99.968% ( 380, 580 ] 45 0.025% 99.993% ( 580, 870 ] 25 0.014% 100.007% ( 870, 1300 ] 14 0.008% 100.015% ( 1300, 1900 ] 8 0.004% 100.019% ( 1900, 2900 ] 2 0.001% 100.021% ( 2900, 4400 ] 3 0.002% 100.022% ( 4400, 6600 ] 5 0.003% 100.025% ( 6600, 9900 ] 10 0.006% 100.031% ( 9900, 14000 ] 2 0.001% 100.032% ** Level 4 read latency histogram (micros): Count: 315 Average: 254.6286 StdDev: 1319.23 Min: 1 Median: 1.8164 Max: 11818 Percentiles: P50: 1.82 P75: 5.25 P99: 9405.00 P99.9: 11818.00 P99.99: 11818.00 ------------------------------------------------------ [ 0, 1 ] 53 16.825% 16.825% ### ( 1, 2 ] 128 40.635% 57.460% ######## ( 2, 3 ] 47 14.921% 72.381% ### ( 3, 4 ] 2 0.635% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 2 0.635% 76.825% ( 10, 15 ] 44 13.968% 90.794% ### ( 15, 22 ] 2 0.635% 91.429% ( 110, 170 ] 2 0.635% 92.063% ( 170, 250 ] 3 0.952% 93.016% ( 250, 380 ] 2 0.635% 93.651% ( 380, 580 ] 4 1.270% 94.921% ( 580, 870 ] 2 0.635% 95.556% ( 870, 1300 ] 1 0.317% 95.873% ( 1300, 1900 ] 2 0.635% 96.508% ( 1900, 2900 ] 1 0.317% 96.825% ( 2900, 4400 ] 4 1.270% 98.095% ( 4400, 6600 ] 2 0.635% 98.730% ( 6600, 9900 ] 1 0.317% 99.048% ( 9900, 14000 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 864.2500 StdDev: 1061.19 Min: 85 Median: 250.0000 Max: 3372 Percentiles: P50: 250.00 P75: 1156.67 P99: 3372.00 P99.9: 3372.00 P99.99: 3372.00 ------------------------------------------------------ ( 76, 110 ] 3 15.000% 15.000% ### ( 110, 170 ] 4 20.000% 35.000% #### ( 170, 250 ] 3 15.000% 50.000% ### ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 1 5.000% 60.000% # ( 580, 870 ] 1 5.000% 65.000% # ( 870, 1300 ] 3 15.000% 80.000% ### ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 1 5.000% 90.000% # ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 328.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:0.600 H:M:S, 10.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.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:0.386 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-20:16:21 ... thread 0: (1000000,3000000) ops and (326510.8,337990.4) ops/second in (3.062686,8.875992) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/10 2.15 GB 81.8 1.3 0.0 1.3 4.1 2.8 0.0 1.5 101.4 318.5 13.05 12.07 45 0.290 1343K 1330 0.0 0.0 L1 1/1 3.62 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 234.2 233.8 1.61 1.56 1 1.614 383K 597 0.0 0.0 L2 1/0 52.62 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 17/0 761.40 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.5 4.7 240.4 239.9 4.92 4.56 2 2.459 1200K 2374 0.0 0.0 L4 174/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 149.1 149.2 1.50 1.11 1 1.504 227K 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 1257/11 98.90 GB 0.0 3.4 1.0 2.4 6.2 3.8 2.3 2.2 154.3 279.7 22.58 20.75 51 0.443 3539K 4517 0.0 0.0 Int 0/0 0.00 KB 0.0 3.4 1.0 2.4 6.2 3.8 2.2 2.2 154.3 279.7 22.58 20.75 51 0.443 3539K 4517 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.4 1.0 2.4 3.4 1.0 0.0 0.0 238.5 238.2 14.61 13.66 11 1.328 3539K 4517 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 355.7 7.97 7.09 40 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.17 GB write, 697.24 MB/s write, 3.40 GB read, 384.78 MB/s read, 22.6 seconds Interval compaction: 6.17 GB write, 711.41 MB/s write, 3.40 GB read, 392.59 MB/s read, 22.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: 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: 737828 Average: 2.2962 StdDev: 10.25 Min: 0 Median: 1.5473 Max: 3840 Percentiles: P50: 1.55 P75: 1.93 P99: 5.75 P99.9: 9.83 P99.99: 14.72 ------------------------------------------------------ [ 0, 1 ] 101808 13.798% 13.798% ### ( 1, 2 ] 488015 66.142% 79.940% ############# ( 2, 3 ] 89375 12.113% 92.054% ## ( 3, 4 ] 29505 3.999% 96.053% # ( 4, 6 ] 24873 3.371% 99.424% # ( 6, 10 ] 3668 0.497% 99.921% ( 10, 15 ] 542 0.073% 99.994% ( 15, 22 ] 72 0.010% 100.004% ( 22, 34 ] 12 0.002% 100.006% ( 34, 51 ] 8 0.001% 100.007% ( 51, 76 ] 7 0.001% 100.008% ( 76, 110 ] 19 0.003% 100.010% ( 110, 170 ] 21 0.003% 100.013% ( 170, 250 ] 29 0.004% 100.017% ( 250, 380 ] 12 0.002% 100.019% ( 380, 580 ] 17 0.002% 100.021% ( 580, 870 ] 15 0.002% 100.023% ( 870, 1300 ] 9 0.001% 100.024% ( 1300, 1900 ] 6 0.001% 100.025% ( 1900, 2900 ] 4 0.001% 100.026% ( 2900, 4400 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 26 Average: 173.9615 StdDev: 337.85 Min: 1 Median: 1.7500 Max: 1367 Percentiles: P50: 1.75 P75: 230.00 P99: 1367.00 P99.9: 1367.00 P99.99: 1367.00 ------------------------------------------------------ [ 0, 1 ] 4 15.385% 15.385% ### ( 1, 2 ] 12 46.154% 61.538% ######### ( 2, 3 ] 1 3.846% 65.385% # ( 4, 6 ] 1 3.846% 69.231% # ( 170, 250 ] 2 7.692% 76.923% ## ( 250, 380 ] 2 7.692% 84.615% ## ( 380, 580 ] 1 3.846% 88.462% # ( 580, 870 ] 1 3.846% 92.308% # ( 870, 1300 ] 1 3.846% 96.154% # ( 1300, 1900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 140199 Average: 2.7223 StdDev: 42.57 Min: 1 Median: 1.4883 Max: 9834 Percentiles: P50: 1.49 P75: 1.88 P99: 6.96 P99.9: 136.28 P99.99: 740.47 ------------------------------------------------------ [ 0, 1 ] 26455 18.870% 18.870% #### ( 1, 2 ] 89378 63.751% 82.620% ############# ( 2, 3 ] 13584 9.689% 92.310% ## ( 3, 4 ] 4958 3.536% 95.846% # ( 4, 6 ] 4120 2.939% 98.785% # ( 6, 10 ] 1263 0.901% 99.685% ( 10, 15 ] 202 0.144% 99.830% ( 15, 22 ] 28 0.020% 99.849% ( 22, 34 ] 4 0.003% 99.852% ( 34, 51 ] 3 0.002% 99.854% ( 51, 76 ] 1 0.001% 99.855% ( 76, 110 ] 19 0.014% 99.869% ( 110, 170 ] 100 0.071% 99.940% ( 170, 250 ] 27 0.019% 99.959% ( 250, 380 ] 17 0.012% 99.971% ( 380, 580 ] 21 0.015% 99.986% ( 580, 870 ] 9 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.997% ( 4400, 6600 ] 1 0.001% 99.998% ( 6600, 9900 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 248931 Average: 3.7334 StdDev: 69.41 Min: 1 Median: 1.6349 Max: 11121 Percentiles: P50: 1.63 P75: 2.13 P99: 8.99 P99.9: 168.72 P99.99: 574.59 ------------------------------------------------------ [ 0, 1 ] 24698 9.922% 9.922% ## ( 1, 2 ] 157141 63.126% 73.048% ############# ( 2, 3 ] 37204 14.946% 87.993% ### ( 3, 4 ] 12381 4.974% 92.967% # ( 4, 6 ] 11891 4.777% 97.744% # ( 6, 10 ] 4177 1.678% 99.422% ( 10, 15 ] 711 0.286% 99.708% ( 15, 22 ] 65 0.026% 99.734% ( 22, 34 ] 7 0.003% 99.736% ( 34, 51 ] 4 0.002% 99.738% ( 51, 76 ] 3 0.001% 99.739% ( 76, 110 ] 128 0.051% 99.791% ( 110, 170 ] 278 0.112% 99.902% ( 170, 250 ] 89 0.036% 99.938% ( 250, 380 ] 61 0.025% 99.963% ( 380, 580 ] 70 0.028% 99.991% ( 580, 870 ] 32 0.013% 100.004% ( 870, 1300 ] 17 0.007% 100.010% ( 1300, 1900 ] 9 0.004% 100.014% ( 1900, 2900 ] 2 0.001% 100.015% ( 2900, 4400 ] 3 0.001% 100.016% ( 4400, 6600 ] 5 0.002% 100.018% ( 6600, 9900 ] 10 0.004% 100.022% ( 9900, 14000 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 315 Average: 254.6286 StdDev: 1319.23 Min: 1 Median: 1.8164 Max: 11818 Percentiles: P50: 1.82 P75: 5.25 P99: 9405.00 P99.9: 11818.00 P99.99: 11818.00 ------------------------------------------------------ [ 0, 1 ] 53 16.825% 16.825% ### ( 1, 2 ] 128 40.635% 57.460% ######## ( 2, 3 ] 47 14.921% 72.381% ### ( 3, 4 ] 2 0.635% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 2 0.635% 76.825% ( 10, 15 ] 44 13.968% 90.794% ### ( 15, 22 ] 2 0.635% 91.429% ( 110, 170 ] 2 0.635% 92.063% ( 170, 250 ] 3 0.952% 93.016% ( 250, 380 ] 2 0.635% 93.651% ( 380, 580 ] 4 1.270% 94.921% ( 580, 870 ] 2 0.635% 95.556% ( 870, 1300 ] 1 0.317% 95.873% ( 1300, 1900 ] 2 0.635% 96.508% ( 1900, 2900 ] 1 0.317% 96.825% ( 2900, 4400 ] 4 1.270% 98.095% ( 4400, 6600 ] 2 0.635% 98.730% ( 6600, 9900 ] 1 0.317% 99.048% ( 9900, 14000 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 961.8250 StdDev: 1213.11 Min: 85 Median: 250.0000 Max: 4118 Percentiles: P50: 250.00 P75: 1214.00 P99: 4118.00 P99.9: 4118.00 P99.99: 4118.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 10 25.000% 37.500% ##### ( 170, 250 ] 5 12.500% 50.000% ### ( 250, 380 ] 3 7.500% 57.500% ## ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 2 5.000% 65.000% # ( 870, 1300 ] 5 12.500% 77.500% ### ( 1300, 1900 ] 1 2.500% 80.000% # ( 1900, 2900 ] 3 7.500% 87.500% ## ( 2900, 4400 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 325.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:1.003 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.35 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.402 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-20:16:24 ... thread 0: (1000000,4000000) ops and (333252.5,336793.3) ops/second in (3.000728,11.876720) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 2.09 GB 12.6 2.4 0.0 2.4 6.1 3.8 0.0 1.6 122.0 312.6 20.14 18.77 63 0.320 2494K 2541 0.0 0.0 L1 9/9 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 231.2 230.3 6.28 6.08 2 3.139 1474K 5185 0.0 0.0 L2 1/0 52.62 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 17/0 761.40 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.5 4.7 240.4 239.9 4.92 4.56 2 2.459 1200K 2374 0.0 0.0 L4 174/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 149.1 149.2 1.50 1.11 1 1.504 227K 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/19 99.88 GB 0.0 5.6 2.1 3.5 9.3 5.8 2.3 2.5 165.8 277.4 34.34 31.97 70 0.491 5780K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.1 3.5 9.3 5.8 2.2 2.5 165.8 277.4 34.34 31.97 70 0.491 5780K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 2.1 3.5 5.5 2.1 0.0 0.0 241.5 241.1 23.57 22.40 16 1.473 5780K 10K 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 356.7 10.77 9.57 54 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.30 GB write, 789.89 MB/s write, 5.56 GB read, 472.10 MB/s read, 34.3 seconds Interval compaction: 9.30 GB write, 801.89 MB/s write, 5.56 GB read, 479.27 MB/s read, 34.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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1062155 Average: 2.2824 StdDev: 10.78 Min: 0 Median: 1.5288 Max: 4126 Percentiles: P50: 1.53 P75: 1.90 P99: 5.72 P99.9: 9.86 P99.99: 17.68 ------------------------------------------------------ [ 0, 1 ] 157182 14.798% 14.798% ### ( 1, 2 ] 707086 66.571% 81.369% ############# ( 2, 3 ] 120425 11.338% 92.707% ## ( 3, 4 ] 39190 3.690% 96.397% # ( 4, 6 ] 32131 3.025% 99.422% # ( 6, 10 ] 5257 0.495% 99.917% ( 10, 15 ] 743 0.070% 99.987% ( 15, 22 ] 91 0.009% 99.995% ( 22, 34 ] 16 0.002% 99.997% ( 34, 51 ] 11 0.001% 99.998% ( 51, 76 ] 9 0.001% 99.999% ( 76, 110 ] 78 0.007% 100.006% ( 110, 170 ] 60 0.006% 100.012% ( 170, 250 ] 62 0.006% 100.018% ( 250, 380 ] 26 0.002% 100.020% ( 380, 580 ] 33 0.003% 100.023% ( 580, 870 ] 27 0.003% 100.026% ( 870, 1300 ] 12 0.001% 100.027% ( 1300, 1900 ] 9 0.001% 100.028% ( 1900, 2900 ] 5 0.000% 100.028% ( 2900, 4400 ] 2 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 5006 Average: 10.5841 StdDev: 74.55 Min: 1 Median: 1.3552 Max: 1821 Percentiles: P50: 1.36 P75: 1.76 P99: 241.53 P99.9: 1399.30 P99.99: 1821.00 ------------------------------------------------------ [ 0, 1 ] 1406 28.086% 28.086% ###### ( 1, 2 ] 3090 61.726% 89.812% ############ ( 2, 3 ] 166 3.316% 93.128% # ( 3, 4 ] 71 1.418% 94.547% ( 4, 6 ] 39 0.779% 95.326% ( 6, 10 ] 76 1.518% 96.844% ( 10, 15 ] 6 0.120% 96.964% ( 76, 110 ] 36 0.719% 97.683% ( 110, 170 ] 41 0.819% 98.502% ( 170, 250 ] 29 0.579% 99.081% ( 250, 380 ] 21 0.419% 99.501% ( 380, 580 ] 12 0.240% 99.740% ( 580, 870 ] 5 0.100% 99.840% ( 870, 1300 ] 3 0.060% 99.900% ( 1300, 1900 ] 6 0.120% 100.020% ** Level 2 read latency histogram (micros): Count: 140199 Average: 2.7223 StdDev: 42.57 Min: 1 Median: 1.4883 Max: 9834 Percentiles: P50: 1.49 P75: 1.88 P99: 6.96 P99.9: 136.28 P99.99: 740.47 ------------------------------------------------------ [ 0, 1 ] 26455 18.870% 18.870% #### ( 1, 2 ] 89378 63.751% 82.620% ############# ( 2, 3 ] 13584 9.689% 92.310% ## ( 3, 4 ] 4958 3.536% 95.846% # ( 4, 6 ] 4120 2.939% 98.785% # ( 6, 10 ] 1263 0.901% 99.685% ( 10, 15 ] 202 0.144% 99.830% ( 15, 22 ] 28 0.020% 99.849% ( 22, 34 ] 4 0.003% 99.852% ( 34, 51 ] 3 0.002% 99.854% ( 51, 76 ] 1 0.001% 99.855% ( 76, 110 ] 19 0.014% 99.869% ( 110, 170 ] 100 0.071% 99.940% ( 170, 250 ] 27 0.019% 99.959% ( 250, 380 ] 17 0.012% 99.971% ( 380, 580 ] 21 0.015% 99.986% ( 580, 870 ] 9 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.997% ( 4400, 6600 ] 1 0.001% 99.998% ( 6600, 9900 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 248931 Average: 3.7334 StdDev: 69.41 Min: 1 Median: 1.6349 Max: 11121 Percentiles: P50: 1.63 P75: 2.13 P99: 8.99 P99.9: 168.72 P99.99: 574.59 ------------------------------------------------------ [ 0, 1 ] 24698 9.922% 9.922% ## ( 1, 2 ] 157141 63.126% 73.048% ############# ( 2, 3 ] 37204 14.946% 87.993% ### ( 3, 4 ] 12381 4.974% 92.967% # ( 4, 6 ] 11891 4.777% 97.744% # ( 6, 10 ] 4177 1.678% 99.422% ( 10, 15 ] 711 0.286% 99.708% ( 15, 22 ] 65 0.026% 99.734% ( 22, 34 ] 7 0.003% 99.736% ( 34, 51 ] 4 0.002% 99.738% ( 51, 76 ] 3 0.001% 99.739% ( 76, 110 ] 128 0.051% 99.791% ( 110, 170 ] 278 0.112% 99.902% ( 170, 250 ] 89 0.036% 99.938% ( 250, 380 ] 61 0.025% 99.963% ( 380, 580 ] 70 0.028% 99.991% ( 580, 870 ] 32 0.013% 100.004% ( 870, 1300 ] 17 0.007% 100.010% ( 1300, 1900 ] 9 0.004% 100.014% ( 1900, 2900 ] 2 0.001% 100.015% ( 2900, 4400 ] 3 0.001% 100.016% ( 4400, 6600 ] 5 0.002% 100.018% ( 6600, 9900 ] 10 0.004% 100.022% ( 9900, 14000 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 315 Average: 254.6286 StdDev: 1319.23 Min: 1 Median: 1.8164 Max: 11818 Percentiles: P50: 1.82 P75: 5.25 P99: 9405.00 P99.9: 11818.00 P99.99: 11818.00 ------------------------------------------------------ [ 0, 1 ] 53 16.825% 16.825% ### ( 1, 2 ] 128 40.635% 57.460% ######## ( 2, 3 ] 47 14.921% 72.381% ### ( 3, 4 ] 2 0.635% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 2 0.635% 76.825% ( 10, 15 ] 44 13.968% 90.794% ### ( 15, 22 ] 2 0.635% 91.429% ( 110, 170 ] 2 0.635% 92.063% ( 170, 250 ] 3 0.952% 93.016% ( 250, 380 ] 2 0.635% 93.651% ( 380, 580 ] 4 1.270% 94.921% ( 580, 870 ] 2 0.635% 95.556% ( 870, 1300 ] 1 0.317% 95.873% ( 1300, 1900 ] 2 0.635% 96.508% ( 1900, 2900 ] 1 0.317% 96.825% ( 2900, 4400 ] 4 1.270% 98.095% ( 4400, 6600 ] 2 0.635% 98.730% ( 6600, 9900 ] 1 0.317% 99.048% ( 9900, 14000 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 961.8250 StdDev: 1213.11 Min: 85 Median: 250.0000 Max: 4118 Percentiles: P50: 250.00 P75: 1214.00 P99: 4118.00 P99.9: 4118.00 P99.99: 4118.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 10 25.000% 37.500% ##### ( 170, 250 ] 5 12.500% 50.000% ### ( 250, 380 ] 3 7.500% 57.500% ## ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 2 5.000% 65.000% # ( 870, 1300 ] 5 12.500% 77.500% ### ( 1300, 1900 ] 1 2.500% 80.000% # ( 1900, 2900 ] 3 7.500% 87.500% ## ( 2900, 4400 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 326.46 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.400 H:M:S, 11.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.97 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.398 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/20-20:16:27 ... thread 0: (1000000,5000000) ops and (330264.6,335467.0) ops/second in (3.027875,14.904595) 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 3.01 GB 75.5 3.0 0.0 3.0 7.6 4.7 0.0 1.6 121.3 313.1 24.93 23.23 78 0.320 3070K 3122 0.0 0.0 L1 9/9 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 231.2 230.3 6.28 6.08 2 3.139 1474K 5185 0.0 0.0 L2 1/0 52.62 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 17/0 761.40 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.5 4.7 240.4 239.9 4.92 4.56 2 2.459 1200K 2374 0.0 0.0 L4 174/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 149.1 149.2 1.50 1.11 1 1.504 227K 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 1268/23 100.80 GB 0.0 6.1 2.1 4.0 10.8 6.7 2.3 2.3 160.0 282.0 39.13 36.43 85 0.460 6356K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.1 2.1 4.0 10.8 6.7 2.2 2.3 160.0 282.0 39.13 36.43 85 0.460 6356K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.1 2.1 4.0 6.1 2.1 0.0 0.0 243.8 243.4 25.68 24.47 18 1.426 6356K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 355.8 13.46 11.96 67 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): 15.1 total, 14.9 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: 10.78 GB write, 731.53 MB/s write, 6.11 GB read, 414.93 MB/s read, 39.1 seconds Interval compaction: 10.78 GB write, 740.38 MB/s write, 6.11 GB read, 419.95 MB/s read, 39.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 16, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1367496 Average: 2.2783 StdDev: 10.54 Min: 0 Median: 1.5258 Max: 4126 Percentiles: P50: 1.53 P75: 1.90 P99: 5.70 P99.9: 9.90 P99.99: 26.14 ------------------------------------------------------ [ 0, 1 ] 200256 14.644% 14.644% ### ( 1, 2 ] 919582 67.246% 81.890% ############# ( 2, 3 ] 152720 11.168% 93.058% ## ( 3, 4 ] 48115 3.518% 96.576% # ( 4, 6 ] 39000 2.852% 99.428% # ( 6, 10 ] 6624 0.484% 99.912% ( 10, 15 ] 952 0.070% 99.982% ( 15, 22 ] 104 0.008% 99.990% ( 22, 34 ] 21 0.002% 99.991% ( 34, 51 ] 13 0.001% 99.992% ( 51, 76 ] 9 0.001% 99.993% ( 76, 110 ] 123 0.009% 100.002% ( 110, 170 ] 106 0.008% 100.009% ( 170, 250 ] 82 0.006% 100.015% ( 250, 380 ] 36 0.003% 100.018% ( 380, 580 ] 47 0.003% 100.021% ( 580, 870 ] 36 0.003% 100.024% ( 870, 1300 ] 17 0.001% 100.025% ( 1300, 1900 ] 11 0.001% 100.026% ( 1900, 2900 ] 6 0.000% 100.027% ( 2900, 4400 ] 2 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 65394 Average: 3.1218 StdDev: 26.87 Min: 1 Median: 1.5201 Max: 3801 Percentiles: P50: 1.52 P75: 1.89 P99: 8.85 P99.9: 239.21 P99.99: 1346.06 ------------------------------------------------------ [ 0, 1 ] 9444 14.442% 14.442% ### ( 1, 2 ] 44710 68.370% 82.812% ############## ( 2, 3 ] 6693 10.235% 93.047% ## ( 3, 4 ] 1720 2.630% 95.677% # ( 4, 6 ] 1421 2.173% 97.850% ( 6, 10 ] 1054 1.612% 99.462% ( 10, 15 ] 127 0.194% 99.656% ( 15, 22 ] 7 0.011% 99.667% ( 51, 76 ] 1 0.002% 99.668% ( 76, 110 ] 61 0.093% 99.761% ( 110, 170 ] 56 0.086% 99.847% ( 170, 250 ] 40 0.061% 99.908% ( 250, 380 ] 25 0.038% 99.946% ( 380, 580 ] 15 0.023% 99.969% ( 580, 870 ] 10 0.015% 99.985% ( 870, 1300 ] 3 0.005% 99.989% ( 1300, 1900 ] 6 0.009% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 140199 Average: 2.7223 StdDev: 42.57 Min: 1 Median: 1.4883 Max: 9834 Percentiles: P50: 1.49 P75: 1.88 P99: 6.96 P99.9: 136.28 P99.99: 740.47 ------------------------------------------------------ [ 0, 1 ] 26455 18.870% 18.870% #### ( 1, 2 ] 89378 63.751% 82.620% ############# ( 2, 3 ] 13584 9.689% 92.310% ## ( 3, 4 ] 4958 3.536% 95.846% # ( 4, 6 ] 4120 2.939% 98.785% # ( 6, 10 ] 1263 0.901% 99.685% ( 10, 15 ] 202 0.144% 99.830% ( 15, 22 ] 28 0.020% 99.849% ( 22, 34 ] 4 0.003% 99.852% ( 34, 51 ] 3 0.002% 99.854% ( 51, 76 ] 1 0.001% 99.855% ( 76, 110 ] 19 0.014% 99.869% ( 110, 170 ] 100 0.071% 99.940% ( 170, 250 ] 27 0.019% 99.959% ( 250, 380 ] 17 0.012% 99.971% ( 380, 580 ] 21 0.015% 99.986% ( 580, 870 ] 9 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.997% ( 4400, 6600 ] 1 0.001% 99.998% ( 6600, 9900 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 248931 Average: 3.7334 StdDev: 69.41 Min: 1 Median: 1.6349 Max: 11121 Percentiles: P50: 1.63 P75: 2.13 P99: 8.99 P99.9: 168.72 P99.99: 574.59 ------------------------------------------------------ [ 0, 1 ] 24698 9.922% 9.922% ## ( 1, 2 ] 157141 63.126% 73.048% ############# ( 2, 3 ] 37204 14.946% 87.993% ### ( 3, 4 ] 12381 4.974% 92.967% # ( 4, 6 ] 11891 4.777% 97.744% # ( 6, 10 ] 4177 1.678% 99.422% ( 10, 15 ] 711 0.286% 99.708% ( 15, 22 ] 65 0.026% 99.734% ( 22, 34 ] 7 0.003% 99.736% ( 34, 51 ] 4 0.002% 99.738% ( 51, 76 ] 3 0.001% 99.739% ( 76, 110 ] 128 0.051% 99.791% ( 110, 170 ] 278 0.112% 99.902% ( 170, 250 ] 89 0.036% 99.938% ( 250, 380 ] 61 0.025% 99.963% ( 380, 580 ] 70 0.028% 99.991% ( 580, 870 ] 32 0.013% 100.004% ( 870, 1300 ] 17 0.007% 100.010% ( 1300, 1900 ] 9 0.004% 100.014% ( 1900, 2900 ] 2 0.001% 100.015% ( 2900, 4400 ] 3 0.001% 100.016% ( 4400, 6600 ] 5 0.002% 100.018% ( 6600, 9900 ] 10 0.004% 100.022% ( 9900, 14000 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 315 Average: 254.6286 StdDev: 1319.23 Min: 1 Median: 1.8164 Max: 11818 Percentiles: P50: 1.82 P75: 5.25 P99: 9405.00 P99.9: 11818.00 P99.99: 11818.00 ------------------------------------------------------ [ 0, 1 ] 53 16.825% 16.825% ### ( 1, 2 ] 128 40.635% 57.460% ######## ( 2, 3 ] 47 14.921% 72.381% ### ( 3, 4 ] 2 0.635% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 2 0.635% 76.825% ( 10, 15 ] 44 13.968% 90.794% ### ( 15, 22 ] 2 0.635% 91.429% ( 110, 170 ] 2 0.635% 92.063% ( 170, 250 ] 3 0.952% 93.016% ( 250, 380 ] 2 0.635% 93.651% ( 380, 580 ] 4 1.270% 94.921% ( 580, 870 ] 2 0.635% 95.556% ( 870, 1300 ] 1 0.317% 95.873% ( 1300, 1900 ] 2 0.635% 96.508% ( 1900, 2900 ] 1 0.317% 96.825% ( 2900, 4400 ] 4 1.270% 98.095% ( 4400, 6600 ] 2 0.635% 98.730% ( 6600, 9900 ] 1 0.317% 99.048% ( 9900, 14000 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 961.8250 StdDev: 1213.11 Min: 85 Median: 250.0000 Max: 4118 Percentiles: P50: 250.00 P75: 1214.00 P99: 4118.00 P99.9: 4118.00 P99.99: 4118.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 10 25.000% 37.500% ##### ( 170, 250 ] 5 12.500% 50.000% ### ( 250, 380 ] 3 7.500% 57.500% ## ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 2 5.000% 65.000% # ( 870, 1300 ] 5 12.500% 77.500% ### ( 1300, 1900 ] 1 2.500% 80.000% # ( 1900, 2900 ] 3 7.500% 87.500% ## ( 2900, 4400 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 15.1 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 326.18 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.827 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.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:0.427 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-20:16:36 ... thread 0: (1000000,6000000) ops and (112421.9,252104.5) ops/second in (8.895064,23.799659) 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 21/15 4.06 GB 107.0 4.2 0.0 4.2 10.0 5.7 0.0 1.7 132.0 309.8 32.93 30.79 100 0.329 4413K 4484 0.0 0.0 L1 9/9 1.04 GB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 231.2 230.3 6.28 6.08 2 3.139 1474K 5185 0.0 0.0 L2 1/0 52.62 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 17/0 761.40 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.5 4.7 240.4 239.9 4.92 4.56 2 2.459 1200K 2374 0.0 0.0 L4 174/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 149.1 149.2 1.50 1.11 1 1.504 227K 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 1270/24 101.85 GB 0.0 7.4 2.1 5.3 13.1 7.8 2.3 2.3 160.9 284.9 47.13 43.99 107 0.440 7699K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.4 2.1 5.3 13.1 7.8 2.2 2.3 160.9 284.9 47.13 43.99 107 0.440 7699K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.4 2.1 5.3 7.4 2.1 0.0 0.0 247.4 246.9 30.65 29.36 23 1.333 7699K 12K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 355.7 16.47 14.63 84 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.0 total, 23.8 interval Flush(GB): cumulative 5.721, interval 5.721 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.11 GB write, 559.95 MB/s write, 7.41 GB read, 316.19 MB/s read, 47.1 seconds Interval compaction: 13.11 GB write, 564.20 MB/s write, 7.41 GB read, 318.58 MB/s read, 47.1 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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 16, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2249817 Average: 2.4046 StdDev: 11.65 Min: 0 Median: 1.5148 Max: 4126 Percentiles: P50: 1.51 P75: 1.88 P99: 5.86 P99.9: 77.93 P99.99: 161.44 ------------------------------------------------------ [ 0, 1 ] 337154 14.986% 14.986% ### ( 1, 2 ] 1530224 68.015% 83.001% ############## ( 2, 3 ] 232617 10.339% 93.341% ## ( 3, 4 ] 74254 3.300% 96.641% # ( 4, 6 ] 57074 2.537% 99.178% # ( 6, 10 ] 14341 0.637% 99.815% ( 10, 15 ] 1615 0.072% 99.887% ( 15, 22 ] 167 0.007% 99.895% ( 22, 34 ] 29 0.001% 99.896% ( 34, 51 ] 17 0.001% 99.897% ( 51, 76 ] 13 0.001% 99.897% ( 76, 110 ] 1133 0.050% 99.948% ( 110, 170 ] 1115 0.050% 99.997% ( 170, 250 ] 292 0.013% 100.010% ( 250, 380 ] 169 0.008% 100.018% ( 380, 580 ] 145 0.006% 100.024% ( 580, 870 ] 78 0.003% 100.028% ( 870, 1300 ] 34 0.002% 100.029% ( 1300, 1900 ] 16 0.001% 100.030% ( 1900, 2900 ] 9 0.000% 100.030% ( 2900, 4400 ] 3 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 236468 Average: 2.8317 StdDev: 17.49 Min: 1 Median: 1.5174 Max: 3801 Percentiles: P50: 1.52 P75: 1.88 P99: 8.63 P99.9: 169.25 P99.99: 729.27 ------------------------------------------------------ [ 0, 1 ] 33510 14.171% 14.171% ### ( 1, 2 ] 163741 69.244% 83.416% ############## ( 2, 3 ] 22764 9.627% 93.042% ## ( 3, 4 ] 6467 2.735% 95.777% # ( 4, 6 ] 5109 2.161% 97.938% ( 6, 10 ] 3819 1.615% 99.553% ( 10, 15 ] 285 0.121% 99.673% ( 15, 22 ] 16 0.007% 99.680% ( 22, 34 ] 5 0.002% 99.682% ( 51, 76 ] 1 0.000% 99.682% ( 76, 110 ] 240 0.101% 99.784% ( 110, 170 ] 278 0.118% 99.901% ( 170, 250 ] 106 0.045% 99.946% ( 250, 380 ] 54 0.023% 99.969% ( 380, 580 ] 37 0.016% 99.985% ( 580, 870 ] 24 0.010% 99.995% ( 870, 1300 ] 5 0.002% 99.997% ( 1300, 1900 ] 6 0.003% 100.000% ( 2900, 4400 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 140199 Average: 2.7223 StdDev: 42.57 Min: 1 Median: 1.4883 Max: 9834 Percentiles: P50: 1.49 P75: 1.88 P99: 6.96 P99.9: 136.28 P99.99: 740.47 ------------------------------------------------------ [ 0, 1 ] 26455 18.870% 18.870% #### ( 1, 2 ] 89378 63.751% 82.620% ############# ( 2, 3 ] 13584 9.689% 92.310% ## ( 3, 4 ] 4958 3.536% 95.846% # ( 4, 6 ] 4120 2.939% 98.785% # ( 6, 10 ] 1263 0.901% 99.685% ( 10, 15 ] 202 0.144% 99.830% ( 15, 22 ] 28 0.020% 99.849% ( 22, 34 ] 4 0.003% 99.852% ( 34, 51 ] 3 0.002% 99.854% ( 51, 76 ] 1 0.001% 99.855% ( 76, 110 ] 19 0.014% 99.869% ( 110, 170 ] 100 0.071% 99.940% ( 170, 250 ] 27 0.019% 99.959% ( 250, 380 ] 17 0.012% 99.971% ( 380, 580 ] 21 0.015% 99.986% ( 580, 870 ] 9 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.997% ( 4400, 6600 ] 1 0.001% 99.998% ( 6600, 9900 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 248931 Average: 3.7334 StdDev: 69.41 Min: 1 Median: 1.6349 Max: 11121 Percentiles: P50: 1.63 P75: 2.13 P99: 8.99 P99.9: 168.72 P99.99: 574.59 ------------------------------------------------------ [ 0, 1 ] 24698 9.922% 9.922% ## ( 1, 2 ] 157141 63.126% 73.048% ############# ( 2, 3 ] 37204 14.946% 87.993% ### ( 3, 4 ] 12381 4.974% 92.967% # ( 4, 6 ] 11891 4.777% 97.744% # ( 6, 10 ] 4177 1.678% 99.422% ( 10, 15 ] 711 0.286% 99.708% ( 15, 22 ] 65 0.026% 99.734% ( 22, 34 ] 7 0.003% 99.736% ( 34, 51 ] 4 0.002% 99.738% ( 51, 76 ] 3 0.001% 99.739% ( 76, 110 ] 128 0.051% 99.791% ( 110, 170 ] 278 0.112% 99.902% ( 170, 250 ] 89 0.036% 99.938% ( 250, 380 ] 61 0.025% 99.963% ( 380, 580 ] 70 0.028% 99.991% ( 580, 870 ] 32 0.013% 100.004% ( 870, 1300 ] 17 0.007% 100.010% ( 1300, 1900 ] 9 0.004% 100.014% ( 1900, 2900 ] 2 0.001% 100.015% ( 2900, 4400 ] 3 0.001% 100.016% ( 4400, 6600 ] 5 0.002% 100.018% ( 6600, 9900 ] 10 0.004% 100.022% ( 9900, 14000 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 315 Average: 254.6286 StdDev: 1319.23 Min: 1 Median: 1.8164 Max: 11818 Percentiles: P50: 1.82 P75: 5.25 P99: 9405.00 P99.9: 11818.00 P99.99: 11818.00 ------------------------------------------------------ [ 0, 1 ] 53 16.825% 16.825% ### ( 1, 2 ] 128 40.635% 57.460% ######## ( 2, 3 ] 47 14.921% 72.381% ### ( 3, 4 ] 2 0.635% 73.016% ( 4, 6 ] 10 3.175% 76.190% # ( 6, 10 ] 2 0.635% 76.825% ( 10, 15 ] 44 13.968% 90.794% ### ( 15, 22 ] 2 0.635% 91.429% ( 110, 170 ] 2 0.635% 92.063% ( 170, 250 ] 3 0.952% 93.016% ( 250, 380 ] 2 0.635% 93.651% ( 380, 580 ] 4 1.270% 94.921% ( 580, 870 ] 2 0.635% 95.556% ( 870, 1300 ] 1 0.317% 95.873% ( 1300, 1900 ] 2 0.635% 96.508% ( 1900, 2900 ] 1 0.317% 96.825% ( 2900, 4400 ] 4 1.270% 98.095% ( 4400, 6600 ] 2 0.635% 98.730% ( 6600, 9900 ] 1 0.317% 99.048% ( 9900, 14000 ] 3 0.952% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 961.8250 StdDev: 1213.11 Min: 85 Median: 250.0000 Max: 4118 Percentiles: P50: 250.00 P75: 1214.00 P99: 4118.00 P99.9: 4118.00 P99.99: 4118.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 10 25.000% 37.500% ##### ( 170, 250 ] 5 12.500% 50.000% ### ( 250, 380 ] 3 7.500% 57.500% ## ( 380, 580 ] 1 2.500% 60.000% # ( 580, 870 ] 2 5.000% 65.000% # ( 870, 1300 ] 5 12.500% 77.500% ### ( 1300, 1900 ] 1 2.500% 80.000% # ( 1900, 2900 ] 3 7.500% 87.500% ## ( 2900, 4400 ] 5 12.500% 100.000% ### ** DB Stats ** Uptime(secs): 24.0 total, 8.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 246.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.769 H:M:S, 32.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 110.63 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.942 H:M:S, 66.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/11/20-20:16:44 ... thread 0: (1000000,7000000) ops and (134578.4,224141.5) ops/second in (7.430615,31.230274) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/9 3.01 GB 44.1 6.0 0.0 6.0 12.7 6.6 0.0 1.9 144.5 303.4 42.73 40.00 118 0.362 6267K 9750 0.0 0.0 L1 17/17 1.97 GB 0.0 4.4 3.4 1.0 4.4 3.3 0.2 1.3 224.4 222.1 20.21 19.32 3 6.736 4604K 45K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.4 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 27/5 1.23 GB 1.0 2.6 1.3 1.3 2.6 1.3 0.5 2.0 225.9 225.3 11.67 10.82 7 1.667 2677K 6514 0.0 0.0 L4 176/5 9.53 GB 1.0 0.4 0.4 0.0 0.4 0.4 0.9 1.0 168.2 168.1 2.38 1.90 4 0.595 406K 392 0.0 0.0 L5 1056/0 86.98 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/36 102.72 GB 0.0 13.8 5.2 8.5 20.4 11.8 4.4 3.1 179.9 265.8 78.49 73.49 134 0.586 14M 62K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.8 5.2 8.5 20.4 11.8 4.3 3.1 179.9 265.8 78.49 73.49 134 0.586 14M 62K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.8 5.2 8.5 13.7 5.2 0.0 0.0 238.2 237.1 59.29 56.44 36 1.647 14M 62K 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 354.3 19.20 17.04 98 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.4 total, 31.2 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: 20.37 GB write, 664.15 MB/s write, 13.79 GB read, 449.55 MB/s read, 78.5 seconds Interval compaction: 20.37 GB write, 667.98 MB/s write, 13.79 GB read, 452.15 MB/s read, 78.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 16, pending-compaction-bytes-stops: 0, total-delays: 31, total-stops: 17, interval: 48 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2761732 Average: 2.4294 StdDev: 12.12 Min: 0 Median: 1.5252 Max: 4126 Percentiles: P50: 1.53 P75: 1.89 P99: 5.94 P99.9: 53.11 P99.99: 165.45 ------------------------------------------------------ [ 0, 1 ] 395615 14.325% 14.325% ### ( 1, 2 ] 1876118 67.933% 82.258% ############## ( 2, 3 ] 298597 10.812% 93.069% ## ( 3, 4 ] 92475 3.348% 96.418% # ( 4, 6 ] 73351 2.656% 99.074% # ( 6, 10 ] 20482 0.742% 99.816% ( 10, 15 ] 2060 0.075% 99.890% ( 15, 22 ] 215 0.008% 99.898% ( 22, 34 ] 34 0.001% 99.899% ( 34, 51 ] 23 0.001% 99.900% ( 51, 76 ] 15 0.001% 99.901% ( 76, 110 ] 1276 0.046% 99.947% ( 110, 170 ] 1294 0.047% 99.994% ( 170, 250 ] 354 0.013% 100.006% ( 250, 380 ] 212 0.008% 100.014% ( 380, 580 ] 192 0.007% 100.021% ( 580, 870 ] 103 0.004% 100.025% ( 870, 1300 ] 44 0.002% 100.026% ( 1300, 1900 ] 23 0.001% 100.027% ( 1900, 2900 ] 11 0.000% 100.028% ( 2900, 4400 ] 5 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 610794 Average: 2.9170 StdDev: 18.52 Min: 0 Median: 1.5690 Max: 3801 Percentiles: P50: 1.57 P75: 1.94 P99: 8.74 P99.9: 164.02 P99.99: 566.35 ------------------------------------------------------ [ 0, 1 ] 69293 11.345% 11.345% ## ( 1, 2 ] 414972 67.940% 79.285% ############## ( 2, 3 ] 73148 11.976% 91.260% ## ( 3, 4 ] 21809 3.571% 94.831% # ( 4, 6 ] 18303 2.997% 97.828% # ( 6, 10 ] 10473 1.715% 99.542% ( 10, 15 ] 1112 0.182% 99.724% ( 15, 22 ] 110 0.018% 99.742% ( 22, 34 ] 10 0.002% 99.744% ( 34, 51 ] 6 0.001% 99.745% ( 51, 76 ] 1 0.000% 99.745% ( 76, 110 ] 442 0.072% 99.817% ( 110, 170 ] 560 0.092% 99.909% ( 170, 250 ] 221 0.036% 99.945% ( 250, 380 ] 149 0.024% 99.970% ( 380, 580 ] 133 0.022% 99.991% ( 580, 870 ] 57 0.009% 100.001% ( 870, 1300 ] 23 0.004% 100.005% ( 1300, 1900 ] 14 0.002% 100.007% ( 1900, 2900 ] 5 0.001% 100.008% ( 2900, 4400 ] 3 0.000% 100.008% ** Level 2 read latency histogram (micros): Count: 140199 Average: 2.7223 StdDev: 42.57 Min: 1 Median: 1.4883 Max: 9834 Percentiles: P50: 1.49 P75: 1.88 P99: 6.96 P99.9: 136.28 P99.99: 740.47 ------------------------------------------------------ [ 0, 1 ] 26455 18.870% 18.870% #### ( 1, 2 ] 89378 63.751% 82.620% ############# ( 2, 3 ] 13584 9.689% 92.310% ## ( 3, 4 ] 4958 3.536% 95.846% # ( 4, 6 ] 4120 2.939% 98.785% # ( 6, 10 ] 1263 0.901% 99.685% ( 10, 15 ] 202 0.144% 99.830% ( 15, 22 ] 28 0.020% 99.849% ( 22, 34 ] 4 0.003% 99.852% ( 34, 51 ] 3 0.002% 99.854% ( 51, 76 ] 1 0.001% 99.855% ( 76, 110 ] 19 0.014% 99.869% ( 110, 170 ] 100 0.071% 99.940% ( 170, 250 ] 27 0.019% 99.959% ( 250, 380 ] 17 0.012% 99.971% ( 380, 580 ] 21 0.015% 99.986% ( 580, 870 ] 9 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.997% ( 4400, 6600 ] 1 0.001% 99.998% ( 6600, 9900 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 356490 Average: 3.7153 StdDev: 59.03 Min: 1 Median: 1.6691 Max: 11121 Percentiles: P50: 1.67 P75: 2.27 P99: 8.90 P99.9: 198.85 P99.99: 505.55 ------------------------------------------------------ [ 0, 1 ] 29483 8.270% 8.270% ## ( 1, 2 ] 222321 62.364% 70.634% ############ ( 2, 3 ] 58357 16.370% 87.004% ### ( 3, 4 ] 19830 5.563% 92.567% # ( 4, 6 ] 19056 5.345% 97.912% # ( 6, 10 ] 5340 1.498% 99.410% ( 10, 15 ] 900 0.252% 99.663% ( 15, 22 ] 94 0.026% 99.689% ( 22, 34 ] 10 0.003% 99.692% ( 34, 51 ] 4 0.001% 99.693% ( 51, 76 ] 3 0.001% 99.694% ( 76, 110 ] 231 0.065% 99.758% ( 110, 170 ] 436 0.122% 99.881% ( 170, 250 ] 190 0.053% 99.934% ( 250, 380 ] 119 0.033% 99.967% ( 380, 580 ] 128 0.036% 100.003% ( 580, 870 ] 49 0.014% 100.017% ( 870, 1300 ] 25 0.007% 100.024% ( 1300, 1900 ] 9 0.003% 100.027% ( 1900, 2900 ] 2 0.001% 100.027% ( 2900, 4400 ] 3 0.001% 100.028% ( 4400, 6600 ] 5 0.001% 100.029% ( 6600, 9900 ] 10 0.003% 100.032% ( 9900, 14000 ] 2 0.001% 100.033% ** Level 4 read latency histogram (micros): Count: 3677 Average: 61.8928 StdDev: 410.86 Min: 1 Median: 1.8437 Max: 11818 Percentiles: P50: 1.84 P75: 3.39 P99: 731.05 P99.9: 7665.90 P99.99: 11818.00 ------------------------------------------------------ [ 0, 1 ] 254 6.908% 6.908% # ( 1, 2 ] 1878 51.074% 57.982% ########## ( 2, 3 ] 527 14.332% 72.314% ### ( 3, 4 ] 255 6.935% 79.249% # ( 4, 6 ] 123 3.345% 82.595% # ( 6, 10 ] 55 1.496% 84.090% ( 10, 15 ] 59 1.605% 85.695% ( 15, 22 ] 2 0.054% 85.749% ( 76, 110 ] 33 0.897% 86.647% ( 110, 170 ] 155 4.215% 90.862% # ( 170, 250 ] 118 3.209% 94.071% # ( 250, 380 ] 93 2.529% 96.600% # ( 380, 580 ] 71 1.931% 98.531% ( 580, 870 ] 35 0.952% 99.483% ( 870, 1300 ] 5 0.136% 99.619% ( 1300, 1900 ] 3 0.082% 99.701% ( 1900, 2900 ] 1 0.027% 99.728% ( 2900, 4400 ] 5 0.136% 99.864% ( 4400, 6600 ] 2 0.054% 99.918% ( 6600, 9900 ] 1 0.027% 99.946% ( 9900, 14000 ] 3 0.082% 100.027% ** Level 5 read latency histogram (micros): Count: 80 Average: 881.3250 StdDev: 1080.25 Min: 85 Median: 268.5714 Max: 4118 Percentiles: P50: 268.57 P75: 1246.25 P99: 4118.00 P99.9: 4118.00 P99.99: 4118.00 ------------------------------------------------------ ( 76, 110 ] 6 7.500% 7.500% ## ( 110, 170 ] 21 26.250% 33.750% ##### ( 170, 250 ] 12 15.000% 48.750% ### ( 250, 380 ] 7 8.750% 57.500% ## ( 380, 580 ] 1 1.250% 58.750% ( 580, 870 ] 6 7.500% 66.250% ## ( 870, 1300 ] 8 10.000% 76.250% ## ( 1300, 1900 ] 5 6.250% 82.500% # ( 1900, 2900 ] 7 8.750% 91.250% ## ( 2900, 4400 ] 7 8.750% 100.000% ## ** DB Stats ** Uptime(secs): 31.4 total, 7.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 219.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:12.319 H:M:S, 39.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 132.47 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.550 H:M:S, 61.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/20-20:16:47 ... thread 0: (1000000,8000000) ops and (312229.7,232335.0) ops/second in (3.202770,34.433044) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/13 3.93 GB 107.0 6.5 0.0 6.5 14.1 7.6 0.0 1.9 140.8 304.0 47.42 44.26 133 0.357 6779K 10K 0.0 0.0 L1 17/17 1.97 GB 0.0 4.4 3.4 1.0 4.4 3.3 0.2 1.3 224.4 222.1 20.21 19.32 3 6.736 4604K 45K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.4 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 22/0 996.77 MB 1.0 2.6 1.3 1.3 2.6 1.3 0.5 2.0 225.9 225.3 11.67 10.82 7 1.667 2677K 6514 0.0 0.0 L4 176/0 9.48 GB 1.0 0.7 0.6 0.0 0.7 0.6 0.9 1.0 175.2 175.0 3.90 3.22 9 0.433 694K 1092 0.0 0.0 L5 1060/0 87.29 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/30 103.64 GB 0.0 14.6 5.5 9.1 22.1 13.0 4.7 2.9 176.0 266.8 84.69 79.07 154 0.550 15M 63K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.6 5.5 9.1 22.1 13.0 4.6 2.9 176.0 266.8 84.69 79.07 154 0.550 15M 63K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.6 5.5 9.1 14.5 5.4 0.0 0.0 237.7 236.7 62.71 59.62 43 1.458 15M 63K 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 352.4 21.99 19.45 111 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.6 total, 34.4 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: 22.06 GB write, 652.71 MB/s write, 14.56 GB read, 430.70 MB/s read, 84.7 seconds Interval compaction: 22.06 GB write, 656.12 MB/s write, 14.56 GB read, 432.96 MB/s read, 84.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 16, pending-compaction-bytes-stops: 0, total-delays: 32, total-stops: 21, interval: 53 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2998834 Average: 2.4378 StdDev: 12.82 Min: 0 Median: 1.5253 Max: 4126 Percentiles: P50: 1.53 P75: 1.89 P99: 5.95 P99.9: 37.66 P99.99: 168.79 ------------------------------------------------------ [ 0, 1 ] 428844 14.300% 14.300% ### ( 1, 2 ] 2038197 67.966% 82.267% ############## ( 2, 3 ] 325658 10.859% 93.126% ## ( 3, 4 ] 99367 3.314% 96.440% # ( 4, 6 ] 78820 2.628% 99.068% # ( 6, 10 ] 22365 0.746% 99.814% ( 10, 15 ] 2307 0.077% 99.891% ( 15, 22 ] 236 0.008% 99.899% ( 22, 34 ] 37 0.001% 99.900% ( 34, 51 ] 24 0.001% 99.901% ( 51, 76 ] 16 0.001% 99.901% ( 76, 110 ] 1313 0.044% 99.945% ( 110, 170 ] 1379 0.046% 99.991% ( 170, 250 ] 400 0.013% 100.004% ( 250, 380 ] 251 0.008% 100.013% ( 380, 580 ] 219 0.007% 100.020% ( 580, 870 ] 117 0.004% 100.024% ( 870, 1300 ] 48 0.002% 100.025% ( 1300, 1900 ] 28 0.001% 100.026% ( 1900, 2900 ] 13 0.000% 100.027% ( 2900, 4400 ] 8 0.000% 100.027% ** Level 1 read latency histogram (micros): Count: 705741 Average: 2.9374 StdDev: 21.34 Min: 0 Median: 1.5649 Max: 3801 Percentiles: P50: 1.56 P75: 1.93 P99: 8.71 P99.9: 162.59 P99.99: 627.24 ------------------------------------------------------ [ 0, 1 ] 82282 11.659% 11.659% ## ( 1, 2 ] 479039 67.877% 79.536% ############## ( 2, 3 ] 83902 11.888% 91.425% ## ( 3, 4 ] 24493 3.471% 94.895% # ( 4, 6 ] 20775 2.944% 97.839% # ( 6, 10 ] 12089 1.713% 99.552% ( 10, 15 ] 1268 0.180% 99.732% ( 15, 22 ] 122 0.017% 99.749% ( 22, 34 ] 12 0.002% 99.751% ( 34, 51 ] 7 0.001% 99.752% ( 51, 76 ] 1 0.000% 99.752% ( 76, 110 ] 522 0.074% 99.826% ( 110, 170 ] 597 0.085% 99.910% ( 170, 250 ] 237 0.034% 99.944% ( 250, 380 ] 166 0.024% 99.968% ( 380, 580 ] 148 0.021% 99.989% ( 580, 870 ] 64 0.009% 99.998% ( 870, 1300 ] 27 0.004% 100.001% ( 1300, 1900 ] 17 0.002% 100.004% ( 1900, 2900 ] 20 0.003% 100.007% ( 2900, 4400 ] 3 0.000% 100.007% ** Level 2 read latency histogram (micros): Count: 140199 Average: 2.7223 StdDev: 42.57 Min: 1 Median: 1.4883 Max: 9834 Percentiles: P50: 1.49 P75: 1.88 P99: 6.96 P99.9: 136.28 P99.99: 740.47 ------------------------------------------------------ [ 0, 1 ] 26455 18.870% 18.870% #### ( 1, 2 ] 89378 63.751% 82.620% ############# ( 2, 3 ] 13584 9.689% 92.310% ## ( 3, 4 ] 4958 3.536% 95.846% # ( 4, 6 ] 4120 2.939% 98.785% # ( 6, 10 ] 1263 0.901% 99.685% ( 10, 15 ] 202 0.144% 99.830% ( 15, 22 ] 28 0.020% 99.849% ( 22, 34 ] 4 0.003% 99.852% ( 34, 51 ] 3 0.002% 99.854% ( 51, 76 ] 1 0.001% 99.855% ( 76, 110 ] 19 0.014% 99.869% ( 110, 170 ] 100 0.071% 99.940% ( 170, 250 ] 27 0.019% 99.959% ( 250, 380 ] 17 0.012% 99.971% ( 380, 580 ] 21 0.015% 99.986% ( 580, 870 ] 9 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.997% ( 4400, 6600 ] 1 0.001% 99.998% ( 6600, 9900 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 418790 Average: 3.6141 StdDev: 55.02 Min: 1 Median: 1.7051 Max: 11121 Percentiles: P50: 1.71 P75: 2.40 P99: 8.63 P99.9: 153.52 P99.99: 323.33 ------------------------------------------------------ [ 0, 1 ] 30405 7.260% 7.260% # ( 1, 2 ] 253838 60.612% 67.872% ############ ( 2, 3 ] 74481 17.785% 85.657% #### ( 3, 4 ] 26018 6.213% 91.870% # ( 4, 6 ] 25864 6.176% 98.046% # ( 6, 10 ] 6082 1.452% 99.498% ( 10, 15 ] 1000 0.239% 99.737% ( 15, 22 ] 116 0.028% 99.765% ( 22, 34 ] 11 0.003% 99.767% ( 34, 51 ] 4 0.001% 99.768% ( 51, 76 ] 4 0.001% 99.769% ( 76, 110 ] 232 0.055% 99.824% ( 110, 170 ] 436 0.104% 99.929% ( 170, 250 ] 190 0.045% 99.974% ( 250, 380 ] 119 0.028% 100.002% ( 380, 580 ] 130 0.031% 100.033% ( 580, 870 ] 49 0.012% 100.045% ( 870, 1300 ] 25 0.006% 100.051% ( 1300, 1900 ] 9 0.002% 100.053% ( 1900, 2900 ] 4 0.001% 100.054% ( 2900, 4400 ] 4 0.001% 100.055% ( 4400, 6600 ] 5 0.001% 100.056% ( 6600, 9900 ] 10 0.002% 100.059% ( 9900, 14000 ] 2 0.000% 100.059% ** Level 4 read latency histogram (micros): Count: 8277 Average: 31.9175 StdDev: 283.20 Min: 1 Median: 1.8527 Max: 11818 Percentiles: P50: 1.85 P75: 2.95 P99: 539.04 P99.9: 3830.75 P99.99: 11818.00 ------------------------------------------------------ [ 0, 1 ] 443 5.352% 5.352% # ( 1, 2 ] 4334 52.362% 57.714% ########## ( 2, 3 ] 1511 18.255% 75.970% #### ( 3, 4 ] 747 9.025% 84.995% ## ( 4, 6 ] 445 5.376% 90.371% # ( 6, 10 ] 152 1.836% 92.207% ( 10, 15 ] 85 1.027% 93.234% ( 15, 22 ] 4 0.048% 93.283% ( 76, 110 ] 34 0.411% 93.693% ( 110, 170 ] 156 1.885% 95.578% ( 170, 250 ] 125 1.510% 97.088% ( 250, 380 ] 97 1.172% 98.260% ( 380, 580 ] 77 0.930% 99.191% ( 580, 870 ] 40 0.483% 99.674% ( 870, 1300 ] 8 0.097% 99.770% ( 1300, 1900 ] 3 0.036% 99.807% ( 1900, 2900 ] 4 0.048% 99.855% ( 2900, 4400 ] 6 0.072% 99.928% ( 4400, 6600 ] 2 0.024% 99.952% ( 6600, 9900 ] 1 0.012% 99.964% ( 9900, 14000 ] 3 0.036% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 872.4900 StdDev: 1094.08 Min: 85 Median: 264.4444 Max: 4118 Percentiles: P50: 264.44 P75: 1204.44 P99: 4118.00 P99.9: 4118.00 P99.99: 4118.00 ------------------------------------------------------ ( 76, 110 ] 10 10.000% 10.000% ## ( 110, 170 ] 25 25.000% 35.000% ##### ( 170, 250 ] 14 14.000% 49.000% ### ( 250, 380 ] 9 9.000% 58.000% ## ( 380, 580 ] 2 2.000% 60.000% ( 580, 870 ] 8 8.000% 68.000% ## ( 870, 1300 ] 9 9.000% 77.000% ## ( 1300, 1900 ] 6 6.000% 83.000% # ( 1900, 2900 ] 8 8.000% 91.000% ## ( 2900, 4400 ] 9 9.000% 100.000% ## ** DB Stats ** Uptime(secs): 34.6 total, 3.2 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 227.46 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:12.915 H:M:S, 37.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 307.30 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.597 H:M:S, 18.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/20-20:17:08 ... thread 0: (1000000,9000000) ops and (47039.6,161603.9) ops/second in (21.258687,55.691731) 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 2.26 GB 44.1 8.9 0.0 8.9 17.4 8.5 0.0 2.0 146.9 286.5 62.15 56.46 151 0.412 9272K 22K 0.0 0.0 L1 9/9 1.08 GB 0.0 9.0 6.0 3.0 8.8 5.8 0.2 1.5 215.2 212.3 42.68 39.52 4 10.670 8854K 45K 0.0 0.0 L2 13/12 1.63 GB 1.3 0.4 0.2 0.2 0.4 0.2 4.8 2.0 252.3 252.1 1.50 1.45 2 0.749 383K 216 0.0 0.0 L3 24/4 1.35 GB 1.0 5.5 3.0 2.5 5.5 3.0 0.5 1.8 184.2 183.2 30.59 24.60 17 1.799 5722K 29K 0.0 0.0 L4 173/3 9.47 GB 1.0 2.1 2.0 0.1 2.1 2.0 0.9 1.0 152.6 152.2 13.94 10.11 24 0.581 2131K 3143 0.0 0.0 L5 1076/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 1303/33 104.45 GB 0.0 25.8 11.2 14.7 34.1 19.5 9.5 4.0 175.4 231.8 150.85 132.14 198 0.762 26M 100K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.8 11.2 14.7 34.1 19.5 9.3 4.0 175.4 231.8 150.85 132.14 198 0.762 26M 100K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.8 11.2 14.7 25.7 11.0 0.0 0.0 211.2 209.8 125.25 110.13 73 1.716 26M 100K 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 339.6 25.60 22.01 125 0.205 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): 55.9 total, 55.7 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: 34.15 GB write, 625.81 MB/s write, 25.84 GB read, 473.51 MB/s read, 150.9 seconds Interval compaction: 34.15 GB write, 627.84 MB/s write, 25.84 GB read, 475.04 MB/s read, 150.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 44, pending-compaction-bytes-stops: 0, total-delays: 62, total-stops: 23, interval: 85 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4262427 Average: 3.2575 StdDev: 31.68 Min: 0 Median: 1.5579 Max: 19654 Percentiles: P50: 1.56 P75: 1.94 P99: 8.62 P99.9: 167.82 P99.99: 431.90 ------------------------------------------------------ [ 0, 1 ] 579368 13.592% 13.592% ### ( 1, 2 ] 2781689 65.261% 78.853% ############# ( 2, 3 ] 515600 12.096% 90.950% ## ( 3, 4 ] 164258 3.854% 94.803% # ( 4, 6 ] 149399 3.505% 98.308% # ( 6, 10 ] 44939 1.054% 99.362% ( 10, 15 ] 5999 0.141% 99.503% ( 15, 22 ] 863 0.020% 99.523% ( 22, 34 ] 60 0.001% 99.525% ( 34, 51 ] 34 0.001% 99.526% ( 51, 76 ] 170 0.004% 99.530% ( 76, 110 ] 5701 0.134% 99.663% ( 110, 170 ] 10466 0.246% 99.909% ( 170, 250 ] 1972 0.046% 99.955% ( 250, 380 ] 1224 0.029% 99.984% ( 380, 580 ] 1001 0.023% 100.007% ( 580, 870 ] 425 0.010% 100.017% ( 870, 1300 ] 126 0.003% 100.020% ( 1300, 1900 ] 63 0.001% 100.022% ( 1900, 2900 ] 53 0.001% 100.023% ( 2900, 4400 ] 54 0.001% 100.024% ( 4400, 6600 ] 10 0.000% 100.025% ( 6600, 9900 ] 14 0.000% 100.025% ( 9900, 14000 ] 1 0.000% 100.025% ( 14000, 22000 ] 3 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1845547 Average: 4.1435 StdDev: 54.91 Min: 0 Median: 1.6815 Max: 18975 Percentiles: P50: 1.68 P75: 2.38 P99: 9.48 P99.9: 231.26 P99.99: 627.71 ------------------------------------------------------ [ 0, 1 ] 175058 9.485% 9.485% ## ( 1, 2 ] 1097200 59.451% 68.937% ############ ( 2, 3 ] 293986 15.929% 84.866% ### ( 3, 4 ] 113935 6.174% 91.040% # ( 4, 6 ] 113675 6.159% 97.199% # ( 6, 10 ] 38155 2.067% 99.266% ( 10, 15 ] 6744 0.365% 99.632% ( 15, 22 ] 821 0.044% 99.676% ( 22, 34 ] 67 0.004% 99.680% ( 34, 51 ] 11 0.001% 99.681% ( 51, 76 ] 20 0.001% 99.682% ( 76, 110 ] 1393 0.075% 99.757% ( 110, 170 ] 2069 0.112% 99.869% ( 170, 250 ] 741 0.040% 99.909% ( 250, 380 ] 701 0.038% 99.947% ( 380, 580 ] 693 0.038% 99.985% ( 580, 870 ] 568 0.031% 100.016% ( 870, 1300 ] 327 0.018% 100.033% ( 1300, 1900 ] 136 0.007% 100.041% ( 1900, 2900 ] 108 0.006% 100.047% ( 2900, 4400 ] 80 0.004% 100.051% ( 4400, 6600 ] 28 0.002% 100.053% ( 6600, 9900 ] 18 0.001% 100.053% ( 14000, 22000 ] 3 0.000% 100.054% ** Level 2 read latency histogram (micros): Count: 140199 Average: 2.7223 StdDev: 42.57 Min: 1 Median: 1.4883 Max: 9834 Percentiles: P50: 1.49 P75: 1.88 P99: 6.96 P99.9: 136.28 P99.99: 740.47 ------------------------------------------------------ [ 0, 1 ] 26455 18.870% 18.870% #### ( 1, 2 ] 89378 63.751% 82.620% ############# ( 2, 3 ] 13584 9.689% 92.310% ## ( 3, 4 ] 4958 3.536% 95.846% # ( 4, 6 ] 4120 2.939% 98.785% # ( 6, 10 ] 1263 0.901% 99.685% ( 10, 15 ] 202 0.144% 99.830% ( 15, 22 ] 28 0.020% 99.849% ( 22, 34 ] 4 0.003% 99.852% ( 34, 51 ] 3 0.002% 99.854% ( 51, 76 ] 1 0.001% 99.855% ( 76, 110 ] 19 0.014% 99.869% ( 110, 170 ] 100 0.071% 99.940% ( 170, 250 ] 27 0.019% 99.959% ( 250, 380 ] 17 0.012% 99.971% ( 380, 580 ] 21 0.015% 99.986% ( 580, 870 ] 9 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.997% ( 4400, 6600 ] 1 0.001% 99.998% ( 6600, 9900 ] 3 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1064563 Average: 4.9241 StdDev: 75.40 Min: 1 Median: 1.8980 Max: 17600 Percentiles: P50: 1.90 P75: 2.89 P99: 9.10 P99.9: 155.08 P99.99: 429.02 ------------------------------------------------------ [ 0, 1 ] 39167 3.679% 3.679% # ( 1, 2 ] 549104 51.580% 55.259% ########## ( 2, 3 ] 237333 22.294% 77.553% #### ( 3, 4 ] 100327 9.424% 86.978% ## ( 4, 6 ] 111988 10.520% 97.497% ## ( 6, 10 ] 20670 1.942% 99.439% ( 10, 15 ] 3813 0.358% 99.797% ( 15, 22 ] 388 0.036% 99.833% ( 22, 34 ] 34 0.003% 99.837% ( 34, 51 ] 12 0.001% 99.838% ( 51, 76 ] 24 0.002% 99.840% ( 76, 110 ] 251 0.024% 99.864% ( 110, 170 ] 517 0.049% 99.912% ( 170, 250 ] 330 0.031% 99.943% ( 250, 380 ] 377 0.035% 99.979% ( 380, 580 ] 500 0.047% 100.026% ( 580, 870 ] 406 0.038% 100.064% ( 870, 1300 ] 245 0.023% 100.087% ( 1300, 1900 ] 98 0.009% 100.096% ( 1900, 2900 ] 89 0.008% 100.104% ( 2900, 4400 ] 86 0.008% 100.112% ( 4400, 6600 ] 38 0.004% 100.116% ( 6600, 9900 ] 25 0.002% 100.118% ( 9900, 14000 ] 3 0.000% 100.119% ( 14000, 22000 ] 2 0.000% 100.119% ** Level 4 read latency histogram (micros): Count: 24863 Average: 56.5324 StdDev: 331.64 Min: 1 Median: 2.0523 Max: 15037 Percentiles: P50: 2.05 P75: 3.40 P99: 1177.63 P99.9: 4274.03 P99.99: 9632.53 ------------------------------------------------------ [ 0, 1 ] 796 3.202% 3.202% # ( 1, 2 ] 11353 45.662% 48.864% ######### ( 2, 3 ] 5398 21.711% 70.575% #### ( 3, 4 ] 2771 11.145% 81.720% ## ( 4, 6 ] 1970 7.923% 89.643% ## ( 6, 10 ] 468 1.882% 91.526% ( 10, 15 ] 210 0.845% 92.370% ( 15, 22 ] 8 0.032% 92.402% ( 22, 34 ] 2 0.008% 92.410% ( 34, 51 ] 1 0.004% 92.414% ( 76, 110 ] 38 0.153% 92.567% ( 110, 170 ] 252 1.014% 93.581% ( 170, 250 ] 256 1.030% 94.610% ( 250, 380 ] 282 1.134% 95.745% ( 380, 580 ] 343 1.380% 97.124% ( 580, 870 ] 325 1.307% 98.431% ( 870, 1300 ] 199 0.800% 99.232% ( 1300, 1900 ] 73 0.294% 99.525% ( 1900, 2900 ] 52 0.209% 99.735% ( 2900, 4400 ] 46 0.185% 99.920% ( 4400, 6600 ] 13 0.052% 99.972% ( 6600, 9900 ] 6 0.024% 99.996% ( 9900, 14000 ] 3 0.012% 100.008% ( 14000, 22000 ] 1 0.004% 100.012% ** Level 5 read latency histogram (micros): Count: 180 Average: 1093.4222 StdDev: 1245.28 Min: 85 Median: 480.0000 Max: 5361 Percentiles: P50: 480.00 P75: 1660.00 P99: 4620.00 P99.9: 5361.00 P99.99: 5361.00 ------------------------------------------------------ ( 76, 110 ] 13 7.222% 7.222% # ( 110, 170 ] 29 16.111% 23.333% ### ( 170, 250 ] 23 12.778% 36.111% ### ( 250, 380 ] 20 11.111% 47.222% ## ( 380, 580 ] 10 5.556% 52.778% # ( 580, 870 ] 16 8.889% 61.667% ## ( 870, 1300 ] 18 10.000% 71.667% ## ( 1300, 1900 ] 10 5.556% 77.222% # ( 1900, 2900 ] 18 10.000% 87.222% ## ( 2900, 4400 ] 21 11.667% 98.889% ## ( 4400, 6600 ] 2 1.111% 100.000% ** DB Stats ** Uptime(secs): 55.9 total, 21.3 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 158.53 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:31.096 H:M:S, 55.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 46.30 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:18.181 H:M:S, 85.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 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.288 micros/op 159030 ops/sec 60.001 seconds 9541999 operations; 154.1 MB/s Microseconds per write: Count: 9541999 Average: 6.2881 StdDev: 320.71 Min: 0 Median: 1.7400 Max: 523463 Percentiles: P50: 1.74 P75: 2.78 P99: 9.19 P99.9: 1189.45 P99.99: 2718.85 ------------------------------------------------------ [ 0, 1 ] 1314600 13.777% 13.777% ### ( 1, 2 ] 4670644 48.948% 62.725% ########## ( 2, 3 ] 1508361 15.808% 78.533% ### ( 3, 4 ] 1323160 13.867% 92.400% ### ( 4, 6 ] 542303 5.683% 98.083% # ( 6, 10 ] 109843 1.151% 99.234% ( 10, 15 ] 30531 0.320% 99.554% ( 15, 22 ] 7585 0.079% 99.633% ( 22, 34 ] 1464 0.015% 99.649% ( 34, 51 ] 229 0.002% 99.651% ( 51, 76 ] 27 0.000% 99.652% ( 76, 110 ] 6788 0.071% 99.723% ( 110, 170 ] 2493 0.026% 99.749% ( 170, 250 ] 279 0.003% 99.752% ( 250, 380 ] 125 0.001% 99.753% ( 380, 580 ] 28 0.000% 99.753% ( 580, 870 ] 20 0.000% 99.754% ( 870, 1300 ] 18814 0.197% 99.951% ( 1300, 1900 ] 84 0.001% 99.952% ( 1900, 2900 ] 4478 0.047% 99.999% ( 2900, 4400 ] 86 0.001% 99.999% ( 4400, 6600 ] 32 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 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 : 205338 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 : 9541999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9847342968 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 : 565 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 33841079 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 : 34418127144 rocksdb.compact.write.bytes COUNT : 34211570254 rocksdb.flush.write.bytes COUNT : 9710443638 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 : 65 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 : 221 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 : 9632145408 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3745792 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 : 34516692695 rocksdb.non.last.level.read.count COUNT : 8340742 rocksdb.block.checksum.compute.count COUNT : 8339677 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.389211 P95 : 3.924718 P99 : 7.781511 P100 : 523459.000000 COUNT : 9541999 SUM : 55566374 rocksdb.compaction.times.micros P50 : 958709.677419 P95 : 5730000.000000 P99 : 22470474.000000 P100 : 22470474.000000 COUNT : 94 SUM : 149772412 rocksdb.compaction.times.cpu_micros P50 : 890909.090909 P95 : 4630000.000000 P99 : 14480000.000000 P100 : 20192877.000000 COUNT : 94 SUM : 128178393 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 : 721.547619 P95 : 2100.000000 P99 : 13344.000000 P100 : 82173.000000 COUNT : 132 SUM : 209210 rocksdb.compaction.outfile.sync.micros P50 : 1004.375000 P95 : 97925.000000 P99 : 228400.000000 P100 : 300814.000000 COUNT : 389 SUM : 5202194 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 : 108.963415 P95 : 1025.277778 P99 : 2350.000000 P100 : 4427.000000 COUNT : 255 SUM : 64866 rocksdb.table.open.io.micros P50 : 1507.216495 P95 : 10207.500000 P99 : 20282.352941 P100 : 24424.000000 COUNT : 565 SUM : 1491980 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.723265 P95 : 8.289234 P99 : 12.894015 P100 : 19660.000000 COUNT : 8338199 SUM : 52876016 rocksdb.read.block.get.micros P50 : 526.405229 P95 : 3931.250000 P99 : 8310.000000 P100 : 11939.000000 COUNT : 1130 SUM : 1201658 rocksdb.write.raw.block.micros P50 : 0.514086 P95 : 0.976764 P99 : 2.856832 P100 : 27869.000000 COUNT : 10645228 SUM : 21492985 rocksdb.numfiles.in.singlecompaction P50 : 3.018182 P95 : 7.840000 P99 : 19.620000 P100 : 26.000000 COUNT : 134 SUM : 495 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.558247 P95 : 1148.195100 P99 : 2423.275978 P100 : 523278.000000 COUNT : 226434 SUM : 33859380 rocksdb.sst.read.micros P50 : 1.656542 P95 : 5.039015 P99 : 9.307425 P100 : 19654.000000 COUNT : 8341169 SUM : 36126119 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 : 9541999 SUM : 9847342968 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 : 212105.263158 P95 : 374800.000000 P99 : 557840.000000 P100 : 691397.000000 COUNT : 132 SUM : 28113294 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 : 358 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