[2024-12-14 12:01:31.226020] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 22.11.4 initialization... [2024-12-14 12:01:31.226131] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid1207480 ] Set seed to 1734174091223654 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-14 12:01:31.312277] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-14 12:01:31.353718] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-14 12:01:31.353767] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1207480' to capture a snapshot of events at runtime. [2024-12-14 12:01:31.353778] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-14 12:01:31.353789] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-14 12:01:31.353796] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1207480 for offline analysis/debug. [2024-12-14 12:01:31.353884] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 14 12:01:35 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/14-12:01:38 ... thread 0: (1000000,1000000) ops and (355752.4,355752.4) ops/second in (2.810944,2.810944) 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/8 630.00 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 351.4 2.33 2.09 12 0.194 0 0 0.0 0.0 L1 1/1 63.00 MB 0.0 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 L2 1/0 1.08 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.2 2.0 245.6 245.5 0.51 0.49 1 0.513 127K 39 0.0 0.0 L3 18/0 992.30 MB 1.0 0.1 0.1 0.0 0.1 0.1 0.1 1.0 237.0 237.1 0.53 0.49 1 0.527 126K 0 0.0 0.0 L4 116/0 9.47 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 1044/0 85.82 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 1189/9 96.94 GB 0.0 0.2 0.2 0.1 1.0 1.0 0.5 1.3 74.4 317.4 3.37 3.07 14 0.241 254K 39 0.0 0.0 Int 0/0 0.00 KB 0.0 0.2 0.2 0.1 1.0 1.0 0.4 1.3 74.4 317.4 3.37 3.07 14 0.241 254K 39 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.2 0.2 0.1 0.2 0.2 0.0 0.0 241.3 241.2 1.04 0.98 2 0.520 254K 39 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 351.4 2.33 2.09 12 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.04 GB write, 356.06 MB/s write, 0.25 GB read, 83.50 MB/s read, 3.4 seconds Interval compaction: 1.04 GB write, 380.43 MB/s write, 0.25 GB read, 89.22 MB/s read, 3.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 122971 Average: 1.9042 StdDev: 18.33 Min: 0 Median: 1.2420 Max: 3416 Percentiles: P50: 1.24 P75: 1.68 P99: 4.10 P99.9: 9.07 P99.99: 73.52 ------------------------------------------------------ [ 0, 1 ] 44373 36.084% 36.084% ####### ( 1, 2 ] 70725 57.514% 93.598% ############ ( 2, 3 ] 4699 3.821% 97.419% # ( 3, 4 ] 1903 1.548% 98.966% ( 4, 6 ] 907 0.738% 99.704% ( 6, 10 ] 319 0.259% 99.963% ( 10, 15 ] 23 0.019% 99.982% ( 15, 22 ] 8 0.007% 99.989% ( 22, 34 ] 3 0.002% 99.991% ( 51, 76 ] 3 0.002% 99.993% ( 76, 110 ] 1 0.001% 99.994% ( 110, 170 ] 8 0.007% 100.001% ( 170, 250 ] 5 0.004% 100.005% ( 250, 380 ] 4 0.003% 100.008% ( 870, 1300 ] 2 0.002% 100.010% ( 1300, 1900 ] 2 0.002% 100.011% ( 2900, 4400 ] 3 0.002% 100.014% ** Level 1 read latency histogram (micros): Count: 5 Average: 1522.4000 StdDev: 1057.79 Min: 264 Median: 1192.5000 Max: 3267 Percentiles: P50: 1192.50 P75: 2650.00 P99: 3267.00 P99.9: 3267.00 P99.99: 3267.00 ------------------------------------------------------ ( 250, 380 ] 1 20.000% 20.000% #### ( 870, 1300 ] 2 40.000% 60.000% ######## ( 1900, 2900 ] 1 20.000% 80.000% #### ( 2900, 4400 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 31713 Average: 1.6907 StdDev: 6.28 Min: 1 Median: 1.1656 Max: 1058 Percentiles: P50: 1.17 P75: 1.61 P99: 3.26 P99.9: 7.36 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 12910 40.709% 40.709% ######## ( 1, 2 ] 17792 56.103% 96.812% ########### ( 2, 3 ] 630 1.987% 98.799% ( 3, 4 ] 246 0.776% 99.574% ( 4, 6 ] 90 0.284% 99.858% ( 6, 10 ] 39 0.123% 99.981% ( 10, 15 ] 3 0.009% 99.991% ( 22, 34 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 85 Average: 773.7765 StdDev: 1095.91 Min: 1 Median: 230.0000 Max: 4305 Percentiles: P50: 230.00 P75: 1096.94 P99: 4187.50 P99.9: 4305.00 P99.99: 4305.00 ------------------------------------------------------ [ 0, 1 ] 24 28.235% 28.235% ###### ( 1, 2 ] 8 9.412% 37.647% ## ( 2, 3 ] 3 3.529% 41.176% # ( 4, 6 ] 2 2.353% 43.529% ( 6, 10 ] 1 1.176% 44.706% ( 51, 76 ] 1 1.176% 45.882% ( 76, 110 ] 1 1.176% 47.059% ( 110, 170 ] 1 1.176% 48.235% ( 170, 250 ] 2 2.353% 50.588% ( 250, 380 ] 1 1.176% 51.765% ( 380, 580 ] 7 8.235% 60.000% ## ( 580, 870 ] 8 9.412% 69.412% ## ( 870, 1300 ] 9 10.588% 80.000% ## ( 1300, 1900 ] 3 3.529% 83.529% # ( 1900, 2900 ] 8 9.412% 92.941% ## ( 2900, 4400 ] 6 7.059% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 1718.3667 StdDev: 1162.28 Min: 464 Median: 1420.0000 Max: 4834 Percentiles: P50: 1420.00 P75: 2400.00 P99: 4834.00 P99.9: 4834.00 P99.99: 4834.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 5 16.667% 46.667% ### ( 1300, 1900 ] 5 16.667% 63.333% ### ( 1900, 2900 ] 7 23.333% 86.667% ##### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 327.51 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.201 H:M:S, 6.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.84 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.201 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-12:01:41 ... thread 0: (1000000,2000000) ops and (332381.7,343670.2) ops/second in (3.008589,5.819533) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.35 GB 107.0 0.9 0.0 0.9 2.6 1.8 0.0 1.5 105.1 322.8 8.39 7.80 29 0.289 895K 996 0.0 0.0 L1 1/0 2.71 MB 0.3 0.3 0.2 0.1 0.3 0.2 0.2 1.2 248.4 248.1 1.27 1.23 1 1.268 319K 345 0.0 0.0 L2 2/0 55.45 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 245.6 245.5 0.51 0.49 1 0.513 127K 39 0.0 0.0 L3 35/0 976.34 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 190.5 190.3 2.60 2.20 2 1.299 502K 318 0.0 0.0 L4 156/0 9.74 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1248/4 97.92 GB 0.0 1.8 0.7 1.1 3.6 2.5 1.0 2.0 142.4 285.3 12.77 11.72 33 0.387 1845K 1698 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 0.7 1.1 3.6 2.5 0.9 2.0 142.4 285.3 12.77 11.72 33 0.387 1845K 1698 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 0.7 1.1 1.8 0.7 0.0 0.0 236.2 236.0 7.69 7.18 7 1.099 1845K 1698 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 360.1 5.07 4.54 26 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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.56 GB write, 605.82 MB/s write, 1.78 GB read, 302.30 MB/s read, 12.8 seconds Interval compaction: 3.56 GB write, 625.86 MB/s write, 1.78 GB read, 312.30 MB/s read, 12.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 381206 Average: 2.0258 StdDev: 15.17 Min: 0 Median: 1.3668 Max: 4984 Percentiles: P50: 1.37 P75: 1.77 P99: 5.09 P99.9: 9.63 P99.99: 18.47 ------------------------------------------------------ [ 0, 1 ] 103983 27.277% 27.277% ##### ( 1, 2 ] 236143 61.946% 89.224% ############ ( 2, 3 ] 24906 6.533% 95.757% # ( 3, 4 ] 9695 2.543% 98.300% # ( 4, 6 ] 4875 1.279% 99.579% ( 6, 10 ] 1347 0.353% 99.933% ( 10, 15 ] 206 0.054% 99.987% ( 15, 22 ] 26 0.007% 99.993% ( 22, 34 ] 8 0.002% 99.996% ( 51, 76 ] 8 0.002% 99.998% ( 76, 110 ] 1 0.000% 99.998% ( 110, 170 ] 13 0.003% 100.001% ( 170, 250 ] 13 0.003% 100.005% ( 250, 380 ] 9 0.002% 100.007% ( 580, 870 ] 8 0.002% 100.009% ( 870, 1300 ] 7 0.002% 100.011% ( 1300, 1900 ] 2 0.001% 100.012% ( 1900, 2900 ] 2 0.001% 100.012% ( 2900, 4400 ] 3 0.001% 100.013% ( 4400, 6600 ] 1 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 65403 Average: 2.4295 StdDev: 17.66 Min: 1 Median: 1.5937 Max: 3267 Percentiles: P50: 1.59 P75: 1.96 P99: 5.69 P99.9: 11.03 P99.99: 471.94 ------------------------------------------------------ [ 0, 1 ] 6429 9.830% 9.830% ## ( 1, 2 ] 44250 67.657% 77.487% ############## ( 2, 3 ] 10064 15.388% 92.875% ### ( 3, 4 ] 2565 3.922% 96.797% # ( 4, 6 ] 1702 2.602% 99.399% # ( 6, 10 ] 315 0.482% 99.881% ( 10, 15 ] 61 0.093% 99.974% ( 15, 22 ] 5 0.008% 99.982% ( 22, 34 ] 1 0.002% 99.983% ( 110, 170 ] 1 0.002% 99.985% ( 250, 380 ] 3 0.005% 99.989% ( 380, 580 ] 1 0.002% 99.991% ( 870, 1300 ] 4 0.006% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31713 Average: 1.6907 StdDev: 6.28 Min: 1 Median: 1.1656 Max: 1058 Percentiles: P50: 1.17 P75: 1.61 P99: 3.26 P99.9: 7.36 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 12910 40.709% 40.709% ######## ( 1, 2 ] 17792 56.103% 96.812% ########### ( 2, 3 ] 630 1.987% 98.799% ( 3, 4 ] 246 0.776% 99.574% ( 4, 6 ] 90 0.284% 99.858% ( 6, 10 ] 39 0.123% 99.981% ( 10, 15 ] 3 0.009% 99.991% ( 22, 34 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28931 Average: 4.6306 StdDev: 72.81 Min: 0 Median: 1.5914 Max: 4305 Percentiles: P50: 1.59 P75: 1.97 P99: 5.98 P99.9: 775.56 P99.99: 3676.72 ------------------------------------------------------ [ 0, 1 ] 3240 11.199% 11.199% ## ( 1, 2 ] 18982 65.611% 76.810% ############# ( 2, 3 ] 4495 15.537% 92.347% ### ( 3, 4 ] 1189 4.110% 96.457% # ( 4, 6 ] 745 2.575% 99.032% # ( 6, 10 ] 143 0.494% 99.526% ( 10, 15 ] 30 0.104% 99.630% ( 15, 22 ] 24 0.083% 99.713% ( 22, 34 ] 24 0.083% 99.796% ( 34, 51 ] 4 0.014% 99.810% ( 51, 76 ] 1 0.003% 99.813% ( 76, 110 ] 1 0.003% 99.817% ( 110, 170 ] 4 0.014% 99.831% ( 170, 250 ] 4 0.014% 99.844% ( 250, 380 ] 2 0.007% 99.851% ( 380, 580 ] 8 0.028% 99.879% ( 580, 870 ] 9 0.031% 99.910% ( 870, 1300 ] 9 0.031% 99.941% ( 1300, 1900 ] 3 0.010% 99.952% ( 1900, 2900 ] 8 0.028% 99.979% ( 2900, 4400 ] 6 0.021% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 1718.3667 StdDev: 1162.28 Min: 464 Median: 1420.0000 Max: 4834 Percentiles: P50: 1420.00 P75: 2400.00 P99: 4834.00 P99.9: 4834.00 P99.99: 4834.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 5 16.667% 46.667% ### ( 1300, 1900 ] 5 16.667% 63.333% ### ( 1900, 2900 ] 7 23.333% 86.667% ##### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 327.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.542 H:M:S, 9.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.13 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.342 H:M:S, 11.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-12:01:44 ... thread 0: (1000000,3000000) ops and (335791.9,341003.3) ops/second in (2.978035,8.797568) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/14 2.34 GB 12.6 1.7 0.0 1.7 4.4 2.8 0.0 1.6 119.2 317.7 14.27 13.33 46 0.310 1727K 1813 0.0 0.0 L1 1/1 2.71 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.2 1.2 248.4 248.1 1.27 1.23 1 1.268 319K 345 0.0 0.0 L2 2/0 55.45 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 245.6 245.5 0.51 0.49 1 0.513 127K 39 0.0 0.0 L3 35/0 976.34 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 190.5 190.3 2.60 2.20 2 1.299 502K 318 0.0 0.0 L4 156/0 9.74 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/15 98.90 GB 0.0 2.6 0.7 1.9 5.3 3.4 1.0 1.9 141.4 293.3 18.65 17.25 50 0.373 2677K 2515 0.0 0.0 Int 0/0 0.00 KB 0.0 2.6 0.7 1.9 5.3 3.4 0.9 1.9 141.4 293.3 18.65 17.25 50 0.373 2677K 2515 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.6 0.7 1.9 2.6 0.7 0.0 0.0 243.8 243.5 10.82 10.24 10 1.082 2677K 2515 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 362.0 7.83 7.02 40 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): 9.0 total, 8.8 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.34 GB write, 608.26 MB/s write, 2.58 GB read, 293.26 MB/s read, 18.6 seconds Interval compaction: 5.34 GB write, 621.57 MB/s write, 2.58 GB read, 299.68 MB/s read, 18.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: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 654106 Average: 2.0145 StdDev: 14.07 Min: 0 Median: 1.3688 Max: 4984 Percentiles: P50: 1.37 P75: 1.77 P99: 5.02 P99.9: 9.71 P99.99: 16.24 ------------------------------------------------------ [ 0, 1 ] 176079 26.919% 26.919% ##### ( 1, 2 ] 409348 62.581% 89.500% ############# ( 2, 3 ] 42541 6.504% 96.004% # ( 3, 4 ] 15665 2.395% 98.399% ( 4, 6 ] 7734 1.182% 99.581% ( 6, 10 ] 2248 0.344% 99.925% ( 10, 15 ] 418 0.064% 99.989% ( 15, 22 ] 54 0.008% 99.997% ( 22, 34 ] 9 0.001% 99.998% ( 34, 51 ] 1 0.000% 99.999% ( 51, 76 ] 8 0.001% 100.000% ( 76, 110 ] 1 0.000% 100.000% ( 110, 170 ] 19 0.003% 100.003% ( 170, 250 ] 20 0.003% 100.006% ( 250, 380 ] 15 0.002% 100.008% ( 380, 580 ] 1 0.000% 100.008% ( 580, 870 ] 10 0.002% 100.010% ( 870, 1300 ] 13 0.002% 100.012% ( 1300, 1900 ] 5 0.001% 100.013% ( 1900, 2900 ] 3 0.000% 100.013% ( 2900, 4400 ] 5 0.001% 100.014% ( 4400, 6600 ] 1 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 65404 Average: 2.4295 StdDev: 17.66 Min: 1 Median: 1.5937 Max: 3267 Percentiles: P50: 1.59 P75: 1.96 P99: 5.69 P99.9: 11.03 P99.99: 471.92 ------------------------------------------------------ [ 0, 1 ] 6429 9.830% 9.830% ## ( 1, 2 ] 44251 67.658% 77.488% ############## ( 2, 3 ] 10064 15.387% 92.875% ### ( 3, 4 ] 2565 3.922% 96.797% # ( 4, 6 ] 1702 2.602% 99.399% # ( 6, 10 ] 315 0.482% 99.881% ( 10, 15 ] 61 0.093% 99.974% ( 15, 22 ] 5 0.008% 99.982% ( 22, 34 ] 1 0.002% 99.983% ( 110, 170 ] 1 0.002% 99.985% ( 250, 380 ] 3 0.005% 99.989% ( 380, 580 ] 1 0.002% 99.991% ( 870, 1300 ] 4 0.006% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31713 Average: 1.6907 StdDev: 6.28 Min: 1 Median: 1.1656 Max: 1058 Percentiles: P50: 1.17 P75: 1.61 P99: 3.26 P99.9: 7.36 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 12910 40.709% 40.709% ######## ( 1, 2 ] 17792 56.103% 96.812% ########### ( 2, 3 ] 630 1.987% 98.799% ( 3, 4 ] 246 0.776% 99.574% ( 4, 6 ] 90 0.284% 99.858% ( 6, 10 ] 39 0.123% 99.981% ( 10, 15 ] 3 0.009% 99.991% ( 22, 34 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28931 Average: 4.6306 StdDev: 72.81 Min: 0 Median: 1.5914 Max: 4305 Percentiles: P50: 1.59 P75: 1.97 P99: 5.98 P99.9: 775.56 P99.99: 3676.72 ------------------------------------------------------ [ 0, 1 ] 3240 11.199% 11.199% ## ( 1, 2 ] 18982 65.611% 76.810% ############# ( 2, 3 ] 4495 15.537% 92.347% ### ( 3, 4 ] 1189 4.110% 96.457% # ( 4, 6 ] 745 2.575% 99.032% # ( 6, 10 ] 143 0.494% 99.526% ( 10, 15 ] 30 0.104% 99.630% ( 15, 22 ] 24 0.083% 99.713% ( 22, 34 ] 24 0.083% 99.796% ( 34, 51 ] 4 0.014% 99.810% ( 51, 76 ] 1 0.003% 99.813% ( 76, 110 ] 1 0.003% 99.817% ( 110, 170 ] 4 0.014% 99.831% ( 170, 250 ] 4 0.014% 99.844% ( 250, 380 ] 2 0.007% 99.851% ( 380, 580 ] 8 0.028% 99.879% ( 580, 870 ] 9 0.031% 99.910% ( 870, 1300 ] 9 0.031% 99.941% ( 1300, 1900 ] 3 0.010% 99.952% ( 1900, 2900 ] 8 0.028% 99.979% ( 2900, 4400 ] 6 0.021% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 1718.3667 StdDev: 1162.28 Min: 464 Median: 1420.0000 Max: 4834 Percentiles: P50: 1420.00 P75: 2400.00 P99: 4834.00 P99.9: 4834.00 P99.99: 4834.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 5 16.667% 46.667% ### ( 1300, 1900 ] 5 16.667% 63.333% ### ( 1900, 2900 ] 7 23.333% 86.667% ##### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 328.37 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.906 H:M:S, 10.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.48 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.363 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-12:01:47 ... thread 0: (1000000,4000000) ops and (279898.9,323355.5) ops/second in (3.572718,12.370286) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/10 3.32 GB 138.5 2.7 0.0 2.7 6.5 3.7 0.0 1.7 130.7 311.7 21.21 19.88 65 0.326 2814K 2940 0.0 0.0 L1 1/1 2.71 MB 0.0 0.3 0.2 0.1 0.3 0.2 0.2 1.2 248.4 248.1 1.27 1.23 1 1.268 319K 345 0.0 0.0 L2 2/0 55.45 MB 0.6 0.1 0.1 0.1 0.1 0.1 0.5 2.0 245.6 245.5 0.51 0.49 1 0.513 127K 39 0.0 0.0 L3 35/0 976.34 MB 1.0 0.5 0.4 0.1 0.5 0.4 0.1 1.3 190.5 190.3 2.60 2.20 2 1.299 502K 318 0.0 0.0 L4 156/0 9.74 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/11 99.89 GB 0.0 3.6 0.7 2.9 7.4 4.4 1.0 2.0 144.9 294.9 25.59 23.80 69 0.371 3764K 3642 0.0 0.0 Int 0/0 0.00 KB 0.0 3.6 0.7 2.9 7.4 4.4 0.9 2.0 144.9 294.9 25.59 23.80 69 0.371 3764K 3642 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.6 0.7 2.9 3.6 0.7 0.0 0.0 249.3 249.1 14.87 14.21 14 1.062 3764K 3642 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 358.4 10.72 9.58 55 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.6 total, 12.4 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.37 GB write, 600.68 MB/s write, 3.62 GB read, 295.12 MB/s read, 25.6 seconds Interval compaction: 7.37 GB write, 610.03 MB/s write, 3.62 GB read, 299.71 MB/s read, 25.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 14, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1102575 Average: 2.0816 StdDev: 11.67 Min: 0 Median: 1.4250 Max: 4984 Percentiles: P50: 1.42 P75: 1.81 P99: 5.21 P99.9: 9.77 P99.99: 15.93 ------------------------------------------------------ [ 0, 1 ] 247143 22.415% 22.415% #### ( 1, 2 ] 715678 64.910% 87.325% ############# ( 2, 3 ] 89243 8.094% 95.419% ## ( 3, 4 ] 30038 2.724% 98.143% # ( 4, 6 ] 15647 1.419% 99.562% ( 6, 10 ] 3952 0.358% 99.921% ( 10, 15 ] 753 0.068% 99.989% ( 15, 22 ] 81 0.007% 99.996% ( 22, 34 ] 14 0.001% 99.998% ( 34, 51 ] 2 0.000% 99.998% ( 51, 76 ] 11 0.001% 99.999% ( 76, 110 ] 71 0.006% 100.005% ( 110, 170 ] 53 0.005% 100.010% ( 170, 250 ] 36 0.003% 100.013% ( 250, 380 ] 28 0.003% 100.016% ( 380, 580 ] 10 0.001% 100.017% ( 580, 870 ] 20 0.002% 100.019% ( 870, 1300 ] 19 0.002% 100.020% ( 1300, 1900 ] 5 0.000% 100.021% ( 1900, 2900 ] 4 0.000% 100.021% ( 2900, 4400 ] 5 0.000% 100.022% ( 4400, 6600 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 65404 Average: 2.4295 StdDev: 17.66 Min: 1 Median: 1.5937 Max: 3267 Percentiles: P50: 1.59 P75: 1.96 P99: 5.69 P99.9: 11.03 P99.99: 471.92 ------------------------------------------------------ [ 0, 1 ] 6429 9.830% 9.830% ## ( 1, 2 ] 44251 67.658% 77.488% ############## ( 2, 3 ] 10064 15.387% 92.875% ### ( 3, 4 ] 2565 3.922% 96.797% # ( 4, 6 ] 1702 2.602% 99.399% # ( 6, 10 ] 315 0.482% 99.881% ( 10, 15 ] 61 0.093% 99.974% ( 15, 22 ] 5 0.008% 99.982% ( 22, 34 ] 1 0.002% 99.983% ( 110, 170 ] 1 0.002% 99.985% ( 250, 380 ] 3 0.005% 99.989% ( 380, 580 ] 1 0.002% 99.991% ( 870, 1300 ] 4 0.006% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 31713 Average: 1.6907 StdDev: 6.28 Min: 1 Median: 1.1656 Max: 1058 Percentiles: P50: 1.17 P75: 1.61 P99: 3.26 P99.9: 7.36 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 12910 40.709% 40.709% ######## ( 1, 2 ] 17792 56.103% 96.812% ########### ( 2, 3 ] 630 1.987% 98.799% ( 3, 4 ] 246 0.776% 99.574% ( 4, 6 ] 90 0.284% 99.858% ( 6, 10 ] 39 0.123% 99.981% ( 10, 15 ] 3 0.009% 99.991% ( 22, 34 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28931 Average: 4.6306 StdDev: 72.81 Min: 0 Median: 1.5914 Max: 4305 Percentiles: P50: 1.59 P75: 1.97 P99: 5.98 P99.9: 775.56 P99.99: 3676.72 ------------------------------------------------------ [ 0, 1 ] 3240 11.199% 11.199% ## ( 1, 2 ] 18982 65.611% 76.810% ############# ( 2, 3 ] 4495 15.537% 92.347% ### ( 3, 4 ] 1189 4.110% 96.457% # ( 4, 6 ] 745 2.575% 99.032% # ( 6, 10 ] 143 0.494% 99.526% ( 10, 15 ] 30 0.104% 99.630% ( 15, 22 ] 24 0.083% 99.713% ( 22, 34 ] 24 0.083% 99.796% ( 34, 51 ] 4 0.014% 99.810% ( 51, 76 ] 1 0.003% 99.813% ( 76, 110 ] 1 0.003% 99.817% ( 110, 170 ] 4 0.014% 99.831% ( 170, 250 ] 4 0.014% 99.844% ( 250, 380 ] 2 0.007% 99.851% ( 380, 580 ] 8 0.028% 99.879% ( 580, 870 ] 9 0.031% 99.910% ( 870, 1300 ] 9 0.031% 99.941% ( 1300, 1900 ] 3 0.010% 99.952% ( 1900, 2900 ] 8 0.028% 99.979% ( 2900, 4400 ] 6 0.021% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 1718.3667 StdDev: 1162.28 Min: 464 Median: 1420.0000 Max: 4834 Percentiles: P50: 1420.00 P75: 2400.00 P99: 4834.00 P99.9: 4834.00 P99.99: 4834.00 ------------------------------------------------------ ( 380, 580 ] 4 13.333% 13.333% ### ( 580, 870 ] 5 16.667% 30.000% ### ( 870, 1300 ] 5 16.667% 46.667% ### ( 1300, 1900 ] 5 16.667% 63.333% ### ( 1900, 2900 ] 7 23.333% 86.667% ##### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 12.6 total, 3.6 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 313.33 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.814 H:M:S, 14.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 275.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:0.909 H:M:S, 25.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-12:01:53 ... thread 0: (1000000,5000000) ops and (178017.2,277967.4) ops/second in (5.617436,17.987722) 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 13/8 2.27 GB 119.6 3.4 0.0 3.4 8.1 4.7 0.0 1.7 130.0 306.3 27.14 25.10 82 0.331 3582K 3707 0.0 0.0 L1 5/0 452.95 MB 45.3 2.3 2.2 0.1 2.3 2.2 0.2 1.0 234.9 233.0 9.93 9.63 2 4.964 2367K 18K 0.0 0.0 L2 2/0 55.45 MB 0.6 0.1 0.1 0.1 0.1 0.1 2.0 2.0 245.6 245.5 0.51 0.49 1 0.513 127K 39 0.0 0.0 L3 14/0 913.84 MB 0.9 0.5 0.4 0.1 0.5 0.4 1.6 1.3 190.5 190.3 2.60 2.20 2 1.299 502K 318 0.0 0.0 L4 164/0 9.71 GB 1.0 0.8 0.6 0.2 0.8 0.6 1.2 1.3 167.1 166.5 4.87 3.71 5 0.973 812K 2369 0.0 0.0 L5 1064/0 87.42 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/8 100.79 GB 0.0 7.1 3.3 3.8 11.8 7.9 6.6 2.5 161.9 267.6 45.04 41.13 92 0.490 7392K 24K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.1 3.3 3.8 11.8 7.9 6.5 2.5 161.9 267.6 45.04 41.13 92 0.490 7392K 24K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.1 3.3 3.8 7.1 3.3 0.0 0.0 232.7 231.9 31.34 29.17 23 1.363 7392K 24K 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 349.5 13.70 11.96 69 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): 18.2 total, 18.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.77 GB write, 663.08 MB/s write, 7.12 GB read, 401.17 MB/s read, 45.0 seconds Interval compaction: 11.77 GB write, 670.18 MB/s write, 7.12 GB read, 405.46 MB/s read, 45.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 17, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1733092 Average: 2.1675 StdDev: 11.60 Min: 0 Median: 1.4590 Max: 4984 Percentiles: P50: 1.46 P75: 1.84 P99: 5.58 P99.9: 10.87 P99.99: 77.41 ------------------------------------------------------ [ 0, 1 ] 348904 20.132% 20.132% #### ( 1, 2 ] 1127828 65.076% 85.208% ############# ( 2, 3 ] 155742 8.986% 94.194% ## ( 3, 4 ] 56683 3.271% 97.465% # ( 4, 6 ] 33764 1.948% 99.413% ( 6, 10 ] 8167 0.471% 99.884% ( 10, 15 ] 1562 0.090% 99.974% ( 15, 22 ] 227 0.013% 99.988% ( 22, 34 ] 18 0.001% 99.989% ( 34, 51 ] 5 0.000% 99.989% ( 51, 76 ] 13 0.001% 99.990% ( 76, 110 ] 161 0.009% 99.999% ( 110, 170 ] 167 0.010% 100.009% ( 170, 250 ] 76 0.004% 100.013% ( 250, 380 ] 49 0.003% 100.016% ( 380, 580 ] 33 0.002% 100.018% ( 580, 870 ] 35 0.002% 100.020% ( 870, 1300 ] 29 0.002% 100.021% ( 1300, 1900 ] 5 0.000% 100.022% ( 1900, 2900 ] 11 0.001% 100.022% ( 2900, 4400 ] 6 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 229091 Average: 2.9870 StdDev: 20.43 Min: 0 Median: 1.8325 Max: 5020 Percentiles: P50: 1.83 P75: 2.72 P99: 7.35 P99.9: 11.30 P99.99: 13.83 ------------------------------------------------------ [ 0, 1 ] 9620 4.199% 4.199% # ( 1, 2 ] 126040 55.017% 59.217% ########### ( 2, 3 ] 49921 21.791% 81.008% #### ( 3, 4 ] 20754 9.059% 90.067% ## ( 4, 6 ] 19468 8.498% 98.565% ## ( 6, 10 ] 2953 1.289% 99.854% ( 10, 15 ] 407 0.178% 100.031% ( 15, 22 ] 34 0.015% 100.046% ( 22, 34 ] 5 0.002% 100.048% ( 51, 76 ] 5 0.002% 100.051% ( 76, 110 ] 33 0.014% 100.065% ( 110, 170 ] 29 0.013% 100.078% ( 170, 250 ] 9 0.004% 100.082% ( 250, 380 ] 17 0.007% 100.089% ( 380, 580 ] 9 0.004% 100.093% ( 580, 870 ] 5 0.002% 100.095% ( 870, 1300 ] 15 0.007% 100.102% ( 1300, 1900 ] 1 0.000% 100.102% ( 1900, 2900 ] 3 0.001% 100.103% ( 2900, 4400 ] 2 0.001% 100.104% ( 4400, 6600 ] 1 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 31713 Average: 1.6907 StdDev: 6.28 Min: 1 Median: 1.1656 Max: 1058 Percentiles: P50: 1.17 P75: 1.61 P99: 3.26 P99.9: 7.36 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 12910 40.709% 40.709% ######## ( 1, 2 ] 17792 56.103% 96.812% ########### ( 2, 3 ] 630 1.987% 98.799% ( 3, 4 ] 246 0.776% 99.574% ( 4, 6 ] 90 0.284% 99.858% ( 6, 10 ] 39 0.123% 99.981% ( 10, 15 ] 3 0.009% 99.991% ( 22, 34 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 71879 Average: 13.5086 StdDev: 116.61 Min: 0 Median: 1.7441 Max: 4305 Percentiles: P50: 1.74 P75: 2.57 P99: 321.45 P99.9: 1418.47 P99.99: 2825.86 ------------------------------------------------------ [ 0, 1 ] 4975 6.921% 6.921% # ( 1, 2 ] 41613 57.893% 64.814% ############ ( 2, 3 ] 12918 17.972% 82.786% #### ( 3, 4 ] 5810 8.083% 90.869% ## ( 4, 6 ] 3498 4.867% 95.736% # ( 6, 10 ] 1160 1.614% 97.350% ( 10, 15 ] 189 0.263% 97.613% ( 15, 22 ] 44 0.061% 97.674% ( 22, 34 ] 27 0.038% 97.711% ( 34, 51 ] 4 0.006% 97.717% ( 51, 76 ] 2 0.003% 97.720% ( 76, 110 ] 119 0.166% 97.885% ( 110, 170 ] 381 0.530% 98.415% ( 170, 250 ] 285 0.396% 98.812% ( 250, 380 ] 246 0.342% 99.154% ( 380, 580 ] 294 0.409% 99.563% ( 580, 870 ] 166 0.231% 99.794% ( 870, 1300 ] 70 0.097% 99.891% ( 1300, 1900 ] 31 0.043% 99.935% ( 1900, 2900 ] 43 0.060% 99.994% ( 2900, 4400 ] 31 0.043% 100.038% ** Level 4 read latency histogram (micros): Count: 155 Average: 416.5806 StdDev: 855.37 Min: 0 Median: 11.2500 Max: 4834 Percentiles: P50: 11.25 P75: 387.14 P99: 4125.00 P99.9: 4834.00 P99.99: 4834.00 ------------------------------------------------------ [ 0, 1 ] 32 20.645% 20.645% #### ( 1, 2 ] 30 19.355% 40.000% #### ( 2, 3 ] 10 6.452% 46.452% # ( 3, 4 ] 1 0.645% 47.097% ( 4, 6 ] 3 1.935% 49.032% ( 6, 10 ] 1 0.645% 49.677% ( 10, 15 ] 2 1.290% 50.968% ( 15, 22 ] 1 0.645% 51.613% ( 22, 34 ] 6 3.871% 55.484% # ( 34, 51 ] 3 1.935% 57.419% ( 76, 110 ] 3 1.935% 59.355% ( 110, 170 ] 17 10.968% 70.323% ## ( 170, 250 ] 4 2.581% 72.903% # ( 250, 380 ] 3 1.935% 74.839% ( 380, 580 ] 7 4.516% 79.355% # ( 580, 870 ] 7 4.516% 83.871% # ( 870, 1300 ] 8 5.161% 89.032% # ( 1300, 1900 ] 5 3.226% 92.258% # ( 1900, 2900 ] 8 5.161% 97.419% # ( 2900, 4400 ] 3 1.935% 99.355% ( 4400, 6600 ] 1 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 704.1000 StdDev: 924.23 Min: 76 Median: 218.0000 Max: 4541 Percentiles: P50: 218.00 P75: 870.00 P99: 4400.00 P99.9: 4541.00 P99.99: 4541.00 ------------------------------------------------------ ( 51, 76 ] 1 1.000% 1.000% ( 76, 110 ] 19 19.000% 20.000% #### ( 110, 170 ] 24 24.000% 44.000% ##### ( 170, 250 ] 10 10.000% 54.000% ## ( 250, 380 ] 8 8.000% 62.000% ## ( 380, 580 ] 4 4.000% 66.000% # ( 580, 870 ] 9 9.000% 75.000% ## ( 870, 1300 ] 5 5.000% 80.000% # ( 1300, 1900 ] 7 7.000% 87.000% # ( 1900, 2900 ] 10 10.000% 97.000% ## ( 2900, 4400 ] 2 2.000% 99.000% ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 18.2 total, 5.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 270.65 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:4.669 H:M:S, 25.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 175.20 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.855 H:M:S, 50.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-12:01:56 ... thread 0: (1000000,6000000) ops and (355449.9,288446.9) ops/second in (2.813336,20.801058) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/4 3.19 GB 301.9 5.1 0.0 5.1 10.7 5.6 0.0 1.9 144.2 302.1 36.26 33.81 100 0.363 5308K 7152 0.0 0.0 L1 5/0 452.95 MB 45.3 2.3 2.2 0.1 2.3 2.2 0.2 1.0 234.9 233.0 9.93 9.63 2 4.964 2367K 18K 0.0 0.0 L2 2/0 55.45 MB 0.6 0.1 0.1 0.1 0.1 0.1 2.0 2.0 245.6 245.5 0.51 0.49 1 0.513 127K 39 0.0 0.0 L3 14/0 913.84 MB 0.9 0.5 0.4 0.1 0.5 0.4 1.6 1.3 190.5 190.3 2.60 2.20 2 1.299 502K 318 0.0 0.0 L4 164/0 9.71 GB 1.0 0.8 0.6 0.2 0.8 0.6 1.2 1.3 167.1 166.5 4.87 3.71 5 0.973 812K 2369 0.0 0.0 L5 1064/0 87.42 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/4 101.71 GB 0.0 8.8 3.3 5.5 14.4 8.8 6.6 2.6 166.0 271.3 54.17 49.84 110 0.492 9118K 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.8 3.3 5.5 14.4 8.8 6.5 2.6 166.0 271.3 54.17 49.84 110 0.492 9118K 28K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.8 3.3 5.5 8.8 3.2 0.0 0.0 237.5 236.7 37.87 35.55 27 1.403 9118K 28K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 351.7 16.30 14.29 83 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 21.0 total, 20.8 interval Flush(GB): cumulative 5.599, interval 5.599 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: 14.35 GB write, 700.05 MB/s write, 8.78 GB read, 428.39 MB/s read, 54.2 seconds Interval compaction: 14.35 GB write, 706.53 MB/s write, 8.78 GB read, 432.36 MB/s read, 54.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 21, interval: 30 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1981286 Average: 2.1436 StdDev: 11.86 Min: 0 Median: 1.4450 Max: 4984 Percentiles: P50: 1.44 P75: 1.83 P99: 5.52 P99.9: 10.78 P99.99: 66.84 ------------------------------------------------------ [ 0, 1 ] 419525 21.174% 21.174% #### ( 1, 2 ] 1283449 64.779% 85.953% ############# ( 2, 3 ] 169718 8.566% 94.519% ## ( 3, 4 ] 61451 3.102% 97.621% # ( 4, 6 ] 36063 1.820% 99.441% ( 6, 10 ] 8822 0.445% 99.886% ( 10, 15 ] 1781 0.090% 99.976% ( 15, 22 ] 245 0.012% 99.988% ( 22, 34 ] 20 0.001% 99.989% ( 34, 51 ] 6 0.000% 99.990% ( 51, 76 ] 14 0.001% 99.990% ( 76, 110 ] 161 0.008% 99.998% ( 110, 170 ] 174 0.009% 100.007% ( 170, 250 ] 82 0.004% 100.011% ( 250, 380 ] 55 0.003% 100.014% ( 380, 580 ] 35 0.002% 100.016% ( 580, 870 ] 41 0.002% 100.018% ( 870, 1300 ] 33 0.002% 100.020% ( 1300, 1900 ] 6 0.000% 100.020% ( 1900, 2900 ] 14 0.001% 100.021% ( 2900, 4400 ] 8 0.000% 100.021% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 229091 Average: 2.9870 StdDev: 20.43 Min: 0 Median: 1.8325 Max: 5020 Percentiles: P50: 1.83 P75: 2.72 P99: 7.35 P99.9: 11.30 P99.99: 13.83 ------------------------------------------------------ [ 0, 1 ] 9620 4.199% 4.199% # ( 1, 2 ] 126040 55.017% 59.217% ########### ( 2, 3 ] 49921 21.791% 81.008% #### ( 3, 4 ] 20754 9.059% 90.067% ## ( 4, 6 ] 19468 8.498% 98.565% ## ( 6, 10 ] 2953 1.289% 99.854% ( 10, 15 ] 407 0.178% 100.031% ( 15, 22 ] 34 0.015% 100.046% ( 22, 34 ] 5 0.002% 100.048% ( 51, 76 ] 5 0.002% 100.051% ( 76, 110 ] 33 0.014% 100.065% ( 110, 170 ] 29 0.013% 100.078% ( 170, 250 ] 9 0.004% 100.082% ( 250, 380 ] 17 0.007% 100.089% ( 380, 580 ] 9 0.004% 100.093% ( 580, 870 ] 5 0.002% 100.095% ( 870, 1300 ] 15 0.007% 100.102% ( 1300, 1900 ] 1 0.000% 100.102% ( 1900, 2900 ] 3 0.001% 100.103% ( 2900, 4400 ] 2 0.001% 100.104% ( 4400, 6600 ] 1 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 31713 Average: 1.6907 StdDev: 6.28 Min: 1 Median: 1.1656 Max: 1058 Percentiles: P50: 1.17 P75: 1.61 P99: 3.26 P99.9: 7.36 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 12910 40.709% 40.709% ######## ( 1, 2 ] 17792 56.103% 96.812% ########### ( 2, 3 ] 630 1.987% 98.799% ( 3, 4 ] 246 0.776% 99.574% ( 4, 6 ] 90 0.284% 99.858% ( 6, 10 ] 39 0.123% 99.981% ( 10, 15 ] 3 0.009% 99.991% ( 22, 34 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 71879 Average: 13.5086 StdDev: 116.61 Min: 0 Median: 1.7441 Max: 4305 Percentiles: P50: 1.74 P75: 2.57 P99: 321.45 P99.9: 1418.47 P99.99: 2825.86 ------------------------------------------------------ [ 0, 1 ] 4975 6.921% 6.921% # ( 1, 2 ] 41613 57.893% 64.814% ############ ( 2, 3 ] 12918 17.972% 82.786% #### ( 3, 4 ] 5810 8.083% 90.869% ## ( 4, 6 ] 3498 4.867% 95.736% # ( 6, 10 ] 1160 1.614% 97.350% ( 10, 15 ] 189 0.263% 97.613% ( 15, 22 ] 44 0.061% 97.674% ( 22, 34 ] 27 0.038% 97.711% ( 34, 51 ] 4 0.006% 97.717% ( 51, 76 ] 2 0.003% 97.720% ( 76, 110 ] 119 0.166% 97.885% ( 110, 170 ] 381 0.530% 98.415% ( 170, 250 ] 285 0.396% 98.812% ( 250, 380 ] 246 0.342% 99.154% ( 380, 580 ] 294 0.409% 99.563% ( 580, 870 ] 166 0.231% 99.794% ( 870, 1300 ] 70 0.097% 99.891% ( 1300, 1900 ] 31 0.043% 99.935% ( 1900, 2900 ] 43 0.060% 99.994% ( 2900, 4400 ] 31 0.043% 100.038% ** Level 4 read latency histogram (micros): Count: 155 Average: 416.5806 StdDev: 855.37 Min: 0 Median: 11.2500 Max: 4834 Percentiles: P50: 11.25 P75: 387.14 P99: 4125.00 P99.9: 4834.00 P99.99: 4834.00 ------------------------------------------------------ [ 0, 1 ] 32 20.645% 20.645% #### ( 1, 2 ] 30 19.355% 40.000% #### ( 2, 3 ] 10 6.452% 46.452% # ( 3, 4 ] 1 0.645% 47.097% ( 4, 6 ] 3 1.935% 49.032% ( 6, 10 ] 1 0.645% 49.677% ( 10, 15 ] 2 1.290% 50.968% ( 15, 22 ] 1 0.645% 51.613% ( 22, 34 ] 6 3.871% 55.484% # ( 34, 51 ] 3 1.935% 57.419% ( 76, 110 ] 3 1.935% 59.355% ( 110, 170 ] 17 10.968% 70.323% ## ( 170, 250 ] 4 2.581% 72.903% # ( 250, 380 ] 3 1.935% 74.839% ( 380, 580 ] 7 4.516% 79.355% # ( 580, 870 ] 7 4.516% 83.871% # ( 870, 1300 ] 8 5.161% 89.032% # ( 1300, 1900 ] 5 3.226% 92.258% # ( 1900, 2900 ] 8 5.161% 97.419% # ( 2900, 4400 ] 3 1.935% 99.355% ( 4400, 6600 ] 1 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 704.1000 StdDev: 924.23 Min: 76 Median: 218.0000 Max: 4541 Percentiles: P50: 218.00 P75: 870.00 P99: 4400.00 P99.9: 4541.00 P99.99: 4541.00 ------------------------------------------------------ ( 51, 76 ] 1 1.000% 1.000% ( 76, 110 ] 19 19.000% 20.000% #### ( 110, 170 ] 24 24.000% 44.000% ##### ( 170, 250 ] 10 10.000% 54.000% ## ( 250, 380 ] 8 8.000% 62.000% ## ( 380, 580 ] 4 4.000% 66.000% # ( 580, 870 ] 9 9.000% 75.000% ## ( 870, 1300 ] 5 5.000% 80.000% # ( 1300, 1900 ] 7 7.000% 87.000% # ( 1900, 2900 ] 10 10.000% 97.000% ## ( 2900, 4400 ] 2 2.000% 99.000% ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 21.0 total, 2.8 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 281.26 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:4.863 H:M:S, 23.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.83 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.194 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-12:01:59 ... thread 0: (1000000,7000000) ops and (314903.1,291950.9) ops/second in (3.175580,23.976638) 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/4 4.24 GB 408.8 6.2 0.0 6.2 12.8 6.6 0.0 1.9 145.4 302.3 43.32 40.46 120 0.361 6396K 8287 0.0 0.0 L1 5/0 452.95 MB 45.3 2.3 2.2 0.1 2.3 2.2 0.2 1.0 234.9 233.0 9.93 9.63 2 4.964 2367K 18K 0.0 0.0 L2 2/0 55.45 MB 0.6 0.1 0.1 0.1 0.1 0.1 2.0 2.0 245.6 245.5 0.51 0.49 1 0.513 127K 39 0.0 0.0 L3 14/0 913.84 MB 0.9 0.5 0.4 0.1 0.5 0.4 1.6 1.3 190.5 190.3 2.60 2.20 2 1.299 502K 318 0.0 0.0 L4 164/0 9.71 GB 1.0 0.8 0.6 0.2 0.8 0.6 1.2 1.3 167.1 166.5 4.87 3.71 5 0.973 812K 2369 0.0 0.0 L5 1064/0 87.42 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/4 102.75 GB 0.0 9.8 3.3 6.6 16.4 9.9 6.6 2.5 164.4 275.0 61.22 56.49 130 0.471 10M 29K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.8 3.3 6.6 16.4 9.9 6.5 2.5 164.4 275.0 61.22 56.49 130 0.471 10M 29K 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 9.8 3.3 6.6 9.8 3.2 0.0 0.0 239.8 239.1 41.97 39.56 31 1.354 10M 29K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 353.3 19.26 16.94 99 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.2 total, 24.0 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: 16.44 GB write, 696.65 MB/s write, 9.83 GB read, 416.42 MB/s read, 61.2 seconds Interval compaction: 16.44 GB write, 702.24 MB/s write, 9.83 GB read, 419.77 MB/s read, 61.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 22, interval: 35 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2254476 Average: 2.1196 StdDev: 11.76 Min: 0 Median: 1.4325 Max: 4984 Percentiles: P50: 1.43 P75: 1.82 P99: 5.45 P99.9: 10.61 P99.99: 31.95 ------------------------------------------------------ [ 0, 1 ] 499051 22.136% 22.136% #### ( 1, 2 ] 1452552 64.430% 86.566% ############# ( 2, 3 ] 185633 8.234% 94.800% ## ( 3, 4 ] 66634 2.956% 97.755% # ( 4, 6 ] 38627 1.713% 99.469% ( 6, 10 ] 9485 0.421% 99.889% ( 10, 15 ] 1962 0.087% 99.976% ( 15, 22 ] 285 0.013% 99.989% ( 22, 34 ] 26 0.001% 99.990% ( 34, 51 ] 6 0.000% 99.990% ( 51, 76 ] 16 0.001% 99.991% ( 76, 110 ] 161 0.007% 99.998% ( 110, 170 ] 181 0.008% 100.006% ( 170, 250 ] 88 0.004% 100.010% ( 250, 380 ] 63 0.003% 100.013% ( 380, 580 ] 40 0.002% 100.015% ( 580, 870 ] 47 0.002% 100.017% ( 870, 1300 ] 38 0.002% 100.019% ( 1300, 1900 ] 8 0.000% 100.019% ( 1900, 2900 ] 14 0.001% 100.020% ( 2900, 4400 ] 9 0.000% 100.020% ( 4400, 6600 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 229091 Average: 2.9870 StdDev: 20.43 Min: 0 Median: 1.8325 Max: 5020 Percentiles: P50: 1.83 P75: 2.72 P99: 7.35 P99.9: 11.30 P99.99: 13.83 ------------------------------------------------------ [ 0, 1 ] 9620 4.199% 4.199% # ( 1, 2 ] 126040 55.017% 59.217% ########### ( 2, 3 ] 49921 21.791% 81.008% #### ( 3, 4 ] 20754 9.059% 90.067% ## ( 4, 6 ] 19468 8.498% 98.565% ## ( 6, 10 ] 2953 1.289% 99.854% ( 10, 15 ] 407 0.178% 100.031% ( 15, 22 ] 34 0.015% 100.046% ( 22, 34 ] 5 0.002% 100.048% ( 51, 76 ] 5 0.002% 100.051% ( 76, 110 ] 33 0.014% 100.065% ( 110, 170 ] 29 0.013% 100.078% ( 170, 250 ] 9 0.004% 100.082% ( 250, 380 ] 17 0.007% 100.089% ( 380, 580 ] 9 0.004% 100.093% ( 580, 870 ] 5 0.002% 100.095% ( 870, 1300 ] 15 0.007% 100.102% ( 1300, 1900 ] 1 0.000% 100.102% ( 1900, 2900 ] 3 0.001% 100.103% ( 2900, 4400 ] 2 0.001% 100.104% ( 4400, 6600 ] 1 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 31713 Average: 1.6907 StdDev: 6.28 Min: 1 Median: 1.1656 Max: 1058 Percentiles: P50: 1.17 P75: 1.61 P99: 3.26 P99.9: 7.36 P99.99: 14.71 ------------------------------------------------------ [ 0, 1 ] 12910 40.709% 40.709% ######## ( 1, 2 ] 17792 56.103% 96.812% ########### ( 2, 3 ] 630 1.987% 98.799% ( 3, 4 ] 246 0.776% 99.574% ( 4, 6 ] 90 0.284% 99.858% ( 6, 10 ] 39 0.123% 99.981% ( 10, 15 ] 3 0.009% 99.991% ( 22, 34 ] 1 0.003% 99.994% ( 250, 380 ] 1 0.003% 99.997% ( 870, 1300 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 71879 Average: 13.5086 StdDev: 116.61 Min: 0 Median: 1.7441 Max: 4305 Percentiles: P50: 1.74 P75: 2.57 P99: 321.45 P99.9: 1418.47 P99.99: 2825.86 ------------------------------------------------------ [ 0, 1 ] 4975 6.921% 6.921% # ( 1, 2 ] 41613 57.893% 64.814% ############ ( 2, 3 ] 12918 17.972% 82.786% #### ( 3, 4 ] 5810 8.083% 90.869% ## ( 4, 6 ] 3498 4.867% 95.736% # ( 6, 10 ] 1160 1.614% 97.350% ( 10, 15 ] 189 0.263% 97.613% ( 15, 22 ] 44 0.061% 97.674% ( 22, 34 ] 27 0.038% 97.711% ( 34, 51 ] 4 0.006% 97.717% ( 51, 76 ] 2 0.003% 97.720% ( 76, 110 ] 119 0.166% 97.885% ( 110, 170 ] 381 0.530% 98.415% ( 170, 250 ] 285 0.396% 98.812% ( 250, 380 ] 246 0.342% 99.154% ( 380, 580 ] 294 0.409% 99.563% ( 580, 870 ] 166 0.231% 99.794% ( 870, 1300 ] 70 0.097% 99.891% ( 1300, 1900 ] 31 0.043% 99.935% ( 1900, 2900 ] 43 0.060% 99.994% ( 2900, 4400 ] 31 0.043% 100.038% ** Level 4 read latency histogram (micros): Count: 155 Average: 416.5806 StdDev: 855.37 Min: 0 Median: 11.2500 Max: 4834 Percentiles: P50: 11.25 P75: 387.14 P99: 4125.00 P99.9: 4834.00 P99.99: 4834.00 ------------------------------------------------------ [ 0, 1 ] 32 20.645% 20.645% #### ( 1, 2 ] 30 19.355% 40.000% #### ( 2, 3 ] 10 6.452% 46.452% # ( 3, 4 ] 1 0.645% 47.097% ( 4, 6 ] 3 1.935% 49.032% ( 6, 10 ] 1 0.645% 49.677% ( 10, 15 ] 2 1.290% 50.968% ( 15, 22 ] 1 0.645% 51.613% ( 22, 34 ] 6 3.871% 55.484% # ( 34, 51 ] 3 1.935% 57.419% ( 76, 110 ] 3 1.935% 59.355% ( 110, 170 ] 17 10.968% 70.323% ## ( 170, 250 ] 4 2.581% 72.903% # ( 250, 380 ] 3 1.935% 74.839% ( 380, 580 ] 7 4.516% 79.355% # ( 580, 870 ] 7 4.516% 83.871% # ( 870, 1300 ] 8 5.161% 89.032% # ( 1300, 1900 ] 5 3.226% 92.258% # ( 1900, 2900 ] 8 5.161% 97.419% # ( 2900, 4400 ] 3 1.935% 99.355% ( 4400, 6600 ] 1 0.645% 100.000% ** Level 5 read latency histogram (micros): Count: 100 Average: 704.1000 StdDev: 924.23 Min: 76 Median: 218.0000 Max: 4541 Percentiles: P50: 218.00 P75: 870.00 P99: 4400.00 P99.9: 4541.00 P99.99: 4541.00 ------------------------------------------------------ ( 51, 76 ] 1 1.000% 1.000% ( 76, 110 ] 19 19.000% 20.000% #### ( 110, 170 ] 24 24.000% 44.000% ##### ( 170, 250 ] 10 10.000% 54.000% ## ( 250, 380 ] 8 8.000% 62.000% ## ( 380, 580 ] 4 4.000% 66.000% # ( 580, 870 ] 9 9.000% 75.000% ## ( 870, 1300 ] 5 5.000% 80.000% # ( 1300, 1900 ] 7 7.000% 87.000% # ( 1900, 2900 ] 10 10.000% 97.000% ## ( 2900, 4400 ] 2 2.000% 99.000% ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 24.2 total, 3.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 285.03 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:5.420 H:M:S, 22.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 309.93 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.556 H:M:S, 17.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-12:02:29 ... thread 0: (1000000,8000000) ops and (33189.3,147855.8) ops/second in (30.130149,54.106787) 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 6/0 692.63 MB 69.3 6.9 0.0 6.9 14.5 7.6 0.0 1.9 138.0 290.6 51.13 45.91 137 0.373 7163K 9048 0.0 0.0 L1 9/9 1.10 GB 0.0 7.3 6.8 0.5 7.1 6.6 0.2 1.1 212.0 207.9 35.10 31.69 3 11.699 7554K 141K 0.0 0.0 L2 18/16 2.19 GB 2.6 0.2 0.1 0.1 0.2 0.1 5.7 1.5 169.5 169.3 1.10 0.79 2 0.550 129K 39 0.0 0.0 L3 29/11 2.16 GB 1.2 1.4 0.9 0.5 1.4 0.9 2.7 1.5 137.7 136.7 10.14 6.24 5 2.029 1418K 10K 0.0 0.0 L4 165/5 9.69 GB 1.0 1.2 1.0 0.2 1.2 1.0 1.2 1.2 144.5 143.9 8.62 5.70 9 0.957 1251K 5057 0.0 0.0 L5 1068/0 87.78 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/41 103.60 GB 0.0 16.9 8.7 8.2 24.4 16.2 11.8 3.2 163.3 235.4 106.09 90.34 156 0.680 17M 165K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.9 8.7 8.2 24.4 16.2 11.7 3.2 163.3 235.4 106.09 90.34 156 0.680 17M 165K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.9 8.7 8.2 16.8 8.6 0.0 0.0 211.8 209.7 81.80 70.69 43 1.902 17M 165K 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 321.7 24.28 19.65 113 0.215 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 54.3 total, 54.1 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.38 GB write, 459.81 MB/s write, 16.92 GB read, 319.01 MB/s read, 106.1 seconds Interval compaction: 24.38 GB write, 461.44 MB/s write, 16.92 GB read, 320.15 MB/s read, 106.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 34, pending-compaction-bytes-delays: 3, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 34, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3595124 Average: 2.7697 StdDev: 16.48 Min: 0 Median: 1.3734 Max: 4984 Percentiles: P50: 1.37 P75: 1.78 P99: 6.54 P99.9: 157.53 P99.99: 419.90 ------------------------------------------------------ [ 0, 1 ] 962293 26.767% 26.767% ##### ( 1, 2 ] 2236884 62.220% 88.987% ############ ( 2, 3 ] 214620 5.970% 94.956% # ( 3, 4 ] 89441 2.488% 97.444% ( 4, 6 ] 54186 1.507% 98.951% ( 6, 10 ] 12918 0.359% 99.311% ( 10, 15 ] 3236 0.090% 99.401% ( 15, 22 ] 830 0.023% 99.424% ( 22, 34 ] 39 0.001% 99.425% ( 34, 51 ] 8 0.000% 99.425% ( 51, 76 ] 190 0.005% 99.430% ( 76, 110 ] 11522 0.320% 99.751% ( 110, 170 ] 6768 0.188% 99.939% ( 170, 250 ] 922 0.026% 99.965% ( 250, 380 ] 777 0.022% 99.986% ( 380, 580 ] 654 0.018% 100.005% ( 580, 870 ] 209 0.006% 100.010% ( 870, 1300 ] 51 0.001% 100.012% ( 1300, 1900 ] 14 0.000% 100.012% ( 1900, 2900 ] 24 0.001% 100.013% ( 2900, 4400 ] 14 0.000% 100.013% ( 4400, 6600 ] 1 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 1251316 Average: 6.1950 StdDev: 92.67 Min: 0 Median: 1.8916 Max: 14903 Percentiles: P50: 1.89 P75: 2.90 P99: 9.07 P99.9: 88.92 P99.99: 132.13 ------------------------------------------------------ [ 0, 1 ] 62500 4.995% 4.995% # ( 1, 2 ] 631610 50.476% 55.470% ########## ( 2, 3 ] 272760 21.798% 77.268% #### ( 3, 4 ] 130234 10.408% 87.676% ## ( 4, 6 ] 121592 9.717% 97.393% ## ( 6, 10 ] 26176 2.092% 99.485% ( 10, 15 ] 4149 0.332% 99.817% ( 15, 22 ] 464 0.037% 99.854% ( 22, 34 ] 40 0.003% 99.857% ( 34, 51 ] 10 0.001% 99.858% ( 51, 76 ] 46 0.004% 99.861% ( 76, 110 ] 1278 0.102% 99.963% ( 110, 170 ] 905 0.072% 100.036% ( 170, 250 ] 235 0.019% 100.055% ( 250, 380 ] 361 0.029% 100.083% ( 380, 580 ] 542 0.043% 100.127% ( 580, 870 ] 560 0.045% 100.171% ( 870, 1300 ] 425 0.034% 100.205% ( 1300, 1900 ] 194 0.016% 100.221% ( 1900, 2900 ] 260 0.021% 100.242% ( 2900, 4400 ] 342 0.027% 100.269% ( 4400, 6600 ] 90 0.007% 100.276% ( 6600, 9900 ] 15 0.001% 100.277% ( 14000, 22000 ] 1 0.000% 100.278% ** Level 2 read latency histogram (micros): Count: 31992 Average: 4.4907 StdDev: 88.08 Min: 1 Median: 1.1723 Max: 6779 Percentiles: P50: 1.17 P75: 1.62 P99: 3.64 P99.9: 725.19 P99.99: 4125.10 ------------------------------------------------------ [ 0, 1 ] 12912 40.360% 40.360% ######## ( 1, 2 ] 17901 55.955% 96.315% ########### ( 2, 3 ] 687 2.147% 98.462% ( 3, 4 ] 269 0.841% 99.303% ( 4, 6 ] 106 0.331% 99.634% ( 6, 10 ] 44 0.138% 99.772% ( 10, 15 ] 4 0.013% 99.784% ( 22, 34 ] 1 0.003% 99.787% ( 110, 170 ] 1 0.003% 99.791% ( 170, 250 ] 6 0.019% 99.809% ( 250, 380 ] 11 0.034% 99.844% ( 380, 580 ] 12 0.038% 99.881% ( 580, 870 ] 12 0.038% 99.919% ( 870, 1300 ] 5 0.016% 99.934% ( 1300, 1900 ] 2 0.006% 99.941% ( 1900, 2900 ] 6 0.019% 99.959% ( 2900, 4400 ] 12 0.038% 99.997% ( 6600, 9900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 207034 Average: 10.2176 StdDev: 114.11 Min: 0 Median: 1.9130 Max: 7589 Percentiles: P50: 1.91 P75: 2.92 P99: 31.54 P99.9: 786.46 P99.99: 1112.47 ------------------------------------------------------ [ 0, 1 ] 6689 3.231% 3.231% # ( 1, 2 ] 106056 51.226% 54.457% ########## ( 2, 3 ] 46267 22.348% 76.805% #### ( 3, 4 ] 22250 10.747% 87.552% ## ( 4, 6 ] 19327 9.335% 96.887% ## ( 6, 10 ] 3637 1.757% 98.644% ( 10, 15 ] 619 0.299% 98.943% ( 15, 22 ] 95 0.046% 98.989% ( 22, 34 ] 31 0.015% 99.004% ( 34, 51 ] 5 0.002% 99.006% ( 51, 76 ] 5 0.002% 99.008% ( 76, 110 ] 124 0.060% 99.068% ( 110, 170 ] 396 0.191% 99.260% ( 170, 250 ] 322 0.156% 99.415% ( 250, 380 ] 345 0.167% 99.582% ( 380, 580 ] 435 0.210% 99.792% ( 580, 870 ] 316 0.153% 99.944% ( 870, 1300 ] 169 0.082% 100.026% ( 1300, 1900 ] 84 0.041% 100.067% ( 1900, 2900 ] 74 0.036% 100.102% ( 2900, 4400 ] 77 0.037% 100.140% ( 4400, 6600 ] 15 0.007% 100.147% ( 6600, 9900 ] 3 0.001% 100.148% ** Level 4 read latency histogram (micros): Count: 9336 Average: 18.1715 StdDev: 175.01 Min: 0 Median: 2.0061 Max: 5624 Percentiles: P50: 2.01 P75: 3.20 P99: 439.37 P99.9: 2804.57 P99.99: 5573.04 ------------------------------------------------------ [ 0, 1 ] 176 1.885% 1.885% ( 1, 2 ] 4479 47.976% 49.861% ########## ( 2, 3 ] 2145 22.976% 72.836% ##### ( 3, 4 ] 1011 10.829% 83.665% ## ( 4, 6 ] 1022 10.947% 94.612% ## ( 6, 10 ] 294 3.149% 97.761% # ( 10, 15 ] 46 0.493% 98.254% ( 15, 22 ] 6 0.064% 98.318% ( 22, 34 ] 6 0.064% 98.383% ( 34, 51 ] 4 0.043% 98.425% ( 76, 110 ] 3 0.032% 98.458% ( 110, 170 ] 20 0.214% 98.672% ( 170, 250 ] 15 0.161% 98.832% ( 250, 380 ] 10 0.107% 98.940% ( 380, 580 ] 19 0.204% 99.143% ( 580, 870 ] 27 0.289% 99.432% ( 870, 1300 ] 22 0.236% 99.668% ( 1300, 1900 ] 9 0.096% 99.764% ( 1900, 2900 ] 14 0.150% 99.914% ( 2900, 4400 ] 6 0.064% 99.979% ( 4400, 6600 ] 2 0.021% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 983.2417 StdDev: 1262.96 Min: 76 Median: 336.6667 Max: 7268 Percentiles: P50: 336.67 P75: 1525.00 P99: 6380.00 P99.9: 7268.00 P99.99: 7268.00 ------------------------------------------------------ ( 51, 76 ] 1 0.833% 0.833% ( 76, 110 ] 19 15.833% 16.667% ### ( 110, 170 ] 24 20.000% 36.667% #### ( 170, 250 ] 10 8.333% 45.000% ## ( 250, 380 ] 9 7.500% 52.500% ## ( 380, 580 ] 5 4.167% 56.667% # ( 580, 870 ] 11 9.167% 65.833% ## ( 870, 1300 ] 8 6.667% 72.500% # ( 1300, 1900 ] 8 6.667% 79.167% # ( 1900, 2900 ] 16 13.333% 92.500% ### ( 2900, 4400 ] 6 5.000% 97.500% # ( 4400, 6600 ] 2 1.667% 99.167% ( 6600, 9900 ] 1 0.833% 100.000% ** DB Stats ** Uptime(secs): 54.3 total, 30.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 145.00 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:32.553 H:M:S, 59.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 32.66 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:27.133 H:M:S, 90.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 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.755 micros/op 148033 ops/sec 60.088 seconds 8894999 operations; 143.4 MB/s Microseconds per write: Count: 8894999 Average: 6.7552 StdDev: 691.62 Min: 1 Median: 1.7529 Max: 975145 Percentiles: P50: 1.75 P75: 2.74 P99: 6.17 P99.9: 1985.03 P99.99: 2816.16 ------------------------------------------------------ [ 0, 1 ] 1046922 11.770% 11.770% ## ( 1, 2 ] 4516767 50.779% 62.549% ########## ( 2, 3 ] 1495889 16.817% 79.366% ### ( 3, 4 ] 1262888 14.198% 93.563% ### ( 4, 6 ] 481523 5.413% 98.977% # ( 6, 10 ] 49096 0.552% 99.529% ( 10, 15 ] 9538 0.107% 99.636% ( 15, 22 ] 4348 0.049% 99.685% ( 22, 34 ] 1199 0.013% 99.698% ( 34, 51 ] 164 0.002% 99.700% ( 51, 76 ] 53 0.001% 99.701% ( 76, 110 ] 6187 0.070% 99.770% ( 110, 170 ] 2595 0.029% 99.800% ( 170, 250 ] 241 0.003% 99.802% ( 250, 380 ] 31 0.000% 99.803% ( 380, 580 ] 25 0.000% 99.803% ( 580, 870 ] 31 0.000% 99.803% ( 870, 1300 ] 7774 0.087% 99.891% ( 1300, 1900 ] 14 0.000% 99.891% ( 1900, 2900 ] 9632 0.108% 99.999% ( 2900, 4400 ] 46 0.001% 100.000% ( 4400, 6600 ] 8 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 3 0.000% 100.000% ( 110000, 170000 ] 5 0.000% 100.000% ( 170000, 250000 ] 6 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 4 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 231170 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 : 8894999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9179638968 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 : 528 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 35895866 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 : 28211774415 rocksdb.compact.write.bytes COUNT : 27967959457 rocksdb.flush.write.bytes COUNT : 9050009809 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 : 70 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 : 229 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 : 8976974848 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3424256 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 : 28309302833 rocksdb.non.last.level.read.count COUNT : 6835343 rocksdb.block.checksum.compute.count COUNT : 6834357 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.398594 P95 : 3.810301 P99 : 5.822751 P100 : 975144.000000 COUNT : 8894999 SUM : 55908674 rocksdb.compaction.times.micros P50 : 1060000.000000 P95 : 4183333.333333 P99 : 23100000.000000 P100 : 25169504.000000 COUNT : 90 SUM : 153374749 rocksdb.compaction.times.cpu_micros P50 : 763333.333333 P95 : 3250000.000000 P99 : 22063679.000000 P100 : 22063679.000000 COUNT : 90 SUM : 111870782 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 : 713.552632 P95 : 65833.333333 P99 : 241200.000000 P100 : 273256.000000 COUNT : 122 SUM : 1237747 rocksdb.compaction.outfile.sync.micros P50 : 1475.000000 P95 : 214545.454545 P99 : 344900.000000 P100 : 836945.000000 COUNT : 335 SUM : 15332433 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 : 171.379310 P95 : 2616.666667 P99 : 4759.333333 P100 : 5128.000000 COUNT : 251 SUM : 130182 rocksdb.table.open.io.micros P50 : 1746.511628 P95 : 9595.384615 P99 : 14960.000000 P100 : 18616.000000 COUNT : 528 SUM : 1378694 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.662453 P95 : 8.248007 P99 : 13.272885 P100 : 26185.000000 COUNT : 6833117 SUM : 52825430 rocksdb.read.block.get.micros P50 : 558.494624 P95 : 3854.878049 P99 : 5768.400000 P100 : 7594.000000 COUNT : 1056 SUM : 1093117 rocksdb.write.raw.block.micros P50 : 0.515601 P95 : 0.979643 P99 : 2.886599 P100 : 33005.000000 COUNT : 8968073 SUM : 20636405 rocksdb.numfiles.in.singlecompaction P50 : 3.084416 P95 : 4.833333 P99 : 11.750000 P100 : 23.000000 COUNT : 165 SUM : 549 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.564095 P95 : 2105.437045 P99 : 2743.501561 P100 : 974953.000000 COUNT : 153295 SUM : 35902511 rocksdb.sst.read.micros P50 : 1.611813 P95 : 4.964555 P99 : 9.465430 P100 : 26166.000000 COUNT : 6835976 SUM : 38969772 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 : 8894999 SUM : 9179638968 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 : 207714.285714 P95 : 567625.000000 P99 : 1117040.000000 P100 : 1124352.000000 COUNT : 122 SUM : 29872310 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 : 316 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