[2024-11-17 02:32:31.411503] Starting SPDK v25.01-pre git sha1 83e8405e4 / DPDK 24.03.0 initialization... [2024-11-17 02:32:31.411647] [ 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_pid1692357 ] Set seed to 1731807151407997 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-17 02:32:31.529515] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-17 02:32:31.641528] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-17 02:32:31.641573] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1692357' to capture a snapshot of events at runtime. [2024-11-17 02:32:31.641584] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-17 02:32:31.641595] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-17 02:32:31.641603] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1692357 for offline analysis/debug. [2024-11-17 02:32:31.643061] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Nov 17 02:32:39 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/17-02:32:42 ... thread 0: (1000000,1000000) ops and (337328.7,337328.7) ops/second in (2.964468,2.964468) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 566.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 353.4 2.50 2.23 12 0.208 0 0 0.0 0.0 L1 3/3 251.71 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 253.0 252.8 1.00 0.96 1 0.996 255K 202 0.0 0.0 L2 1/0 48.74 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 17/0 818.38 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 210.5 210.5 0.30 0.24 1 0.297 63K 0 0.0 0.0 L4 116/0 9.54 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/8 97.00 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.2 1.5 99.8 306.5 4.27 3.88 15 0.284 432K 239 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 99.8 306.5 4.27 3.88 15 0.284 432K 239 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 0.0 240.5 240.3 1.77 1.65 3 0.590 432K 239 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 353.4 2.50 2.23 12 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.28 GB write, 410.98 MB/s write, 0.42 GB read, 133.81 MB/s read, 4.3 seconds Interval compaction: 1.28 GB write, 440.78 MB/s write, 0.42 GB read, 143.51 MB/s read, 4.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 104036 Average: 1.9126 StdDev: 18.86 Min: 1 Median: 1.2461 Max: 3317 Percentiles: P50: 1.25 P75: 1.65 P99: 3.71 P99.9: 9.94 P99.99: 419.75 ------------------------------------------------------ [ 0, 1 ] 36251 34.845% 34.845% ####### ( 1, 2 ] 64060 61.575% 96.420% ############ ( 2, 3 ] 1948 1.872% 98.292% ( 3, 4 ] 1043 1.003% 99.294% ( 4, 6 ] 370 0.356% 99.650% ( 6, 10 ] 266 0.256% 99.906% ( 10, 15 ] 60 0.058% 99.963% ( 15, 22 ] 13 0.012% 99.976% ( 22, 34 ] 1 0.001% 99.977% ( 34, 51 ] 1 0.001% 99.978% ( 51, 76 ] 1 0.001% 99.979% ( 110, 170 ] 6 0.006% 99.985% ( 170, 250 ] 4 0.004% 99.988% ( 250, 380 ] 3 0.003% 99.991% ( 380, 580 ] 3 0.003% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 4 0.004% 100.001% ( 2900, 4400 ] 1 0.001% 100.002% ** Level 1 read latency histogram (micros): Count: 31536 Average: 2.2838 StdDev: 17.23 Min: 0 Median: 1.2742 Max: 1433 Percentiles: P50: 1.27 P75: 1.67 P99: 5.59 P99.9: 139.57 P99.99: 991.32 ------------------------------------------------------ [ 0, 1 ] 10316 32.712% 32.712% ####### ( 1, 2 ] 19882 63.045% 95.757% ############# ( 2, 3 ] 593 1.880% 97.638% ( 3, 4 ] 313 0.993% 98.630% ( 4, 6 ] 147 0.466% 99.096% ( 6, 10 ] 167 0.530% 99.626% ( 10, 15 ] 37 0.117% 99.743% ( 15, 22 ] 8 0.025% 99.769% ( 34, 51 ] 1 0.003% 99.772% ( 51, 76 ] 30 0.095% 99.867% ( 76, 110 ] 8 0.025% 99.892% ( 110, 170 ] 5 0.016% 99.908% ( 170, 250 ] 12 0.038% 99.946% ( 250, 380 ] 9 0.029% 99.975% ( 380, 580 ] 3 0.010% 99.984% ( 580, 870 ] 1 0.003% 99.987% ( 870, 1300 ] 3 0.010% 99.997% ( 1300, 1900 ] 1 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 15863 Average: 1.7623 StdDev: 3.81 Min: 1 Median: 1.1839 Max: 408 Percentiles: P50: 1.18 P75: 1.64 P99: 5.05 P99.9: 9.83 P99.99: 203.10 ------------------------------------------------------ [ 0, 1 ] 6319 39.835% 39.835% ######## ( 1, 2 ] 8768 55.273% 95.108% ########### ( 2, 3 ] 283 1.784% 96.892% ( 3, 4 ] 248 1.563% 98.456% ( 4, 6 ] 165 1.040% 99.496% ( 6, 10 ] 67 0.422% 99.918% ( 10, 15 ] 6 0.038% 99.956% ( 15, 22 ] 4 0.025% 99.981% ( 110, 170 ] 1 0.006% 99.987% ( 170, 250 ] 1 0.006% 99.994% ( 380, 580 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 85 Average: 1485.9294 StdDev: 2021.01 Min: 0 Median: 413.3333 Max: 8292 Percentiles: P50: 413.33 P75: 3012.50 P99: 7095.00 P99.9: 8292.00 P99.99: 8292.00 ------------------------------------------------------ [ 0, 1 ] 31 36.471% 36.471% ####### ( 1, 2 ] 5 5.882% 42.353% # ( 2, 3 ] 2 2.353% 44.706% ( 110, 170 ] 3 3.529% 48.235% # ( 170, 250 ] 1 1.176% 49.412% ( 380, 580 ] 3 3.529% 52.941% # ( 580, 870 ] 6 7.059% 60.000% # ( 870, 1300 ] 4 4.706% 64.706% # ( 1300, 1900 ] 5 5.882% 70.588% # ( 1900, 2900 ] 3 3.529% 74.118% # ( 2900, 4400 ] 10 11.765% 85.882% ## ( 4400, 6600 ] 11 12.941% 98.824% ### ( 6600, 9900 ] 1 1.176% 100.000% ** Level 4 read latency histogram (micros): Count: 30 Average: 3668.9000 StdDev: 2168.83 Min: 246 Median: 3800.0000 Max: 8668 Percentiles: P50: 3800.00 P75: 5610.00 P99: 8668.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 1 3.333% 10.000% # ( 1300, 1900 ] 3 10.000% 20.000% ## ( 1900, 2900 ] 6 20.000% 40.000% #### ( 2900, 4400 ] 5 16.667% 56.667% ### ( 4400, 6600 ] 10 33.333% 90.000% ####### ( 6600, 9900 ] 3 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 309.38 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.384 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, 331.73 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.384 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/17-02:32:45 ... thread 0: (1000000,2000000) ops and (323974.7,330516.8) ops/second in (3.086661,6.051129) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.23 GB 69.2 0.6 0.0 0.6 2.4 1.8 0.0 1.3 75.1 325.4 7.55 6.89 28 0.270 575K 631 0.0 0.0 L1 2/0 50.36 MB 5.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 241.7 241.2 3.39 3.28 2 1.694 831K 1409 0.0 0.0 L2 5/4 563.81 MB 1.3 0.1 0.1 0.0 0.1 0.1 0.6 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 17/10 818.38 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 210.5 210.5 0.30 0.24 1 0.297 63K 0 0.0 0.0 L4 116/0 9.54 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 1195/22 97.98 GB 0.0 1.5 0.6 0.9 3.4 2.5 0.7 1.8 133.2 294.3 11.71 10.86 32 0.366 1583K 2077 0.0 0.0 Int 0/0 0.00 KB 0.0 1.5 0.6 0.9 3.4 2.5 0.6 1.8 133.2 294.3 11.71 10.86 32 0.366 1583K 2077 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.5 0.6 0.9 1.5 0.6 0.0 0.0 247.2 246.9 6.31 6.07 6 1.051 1583K 2077 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 349.8 5.40 4.79 26 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.1 interval Flush(GB): cumulative 1.846, interval 1.846 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.37 GB write, 549.97 MB/s write, 1.52 GB read, 248.79 MB/s read, 11.7 seconds Interval compaction: 3.37 GB write, 569.51 MB/s write, 1.52 GB read, 257.63 MB/s read, 11.7 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: 408195 Average: 2.3118 StdDev: 12.51 Min: 0 Median: 1.5554 Max: 3500 Percentiles: P50: 1.56 P75: 1.95 P99: 5.82 P99.9: 11.96 P99.99: 15.76 ------------------------------------------------------ [ 0, 1 ] 61009 14.946% 14.946% ### ( 1, 2 ] 257623 63.113% 78.059% ############# ( 2, 3 ] 60263 14.763% 92.822% ### ( 3, 4 ] 14301 3.503% 96.326% # ( 4, 6 ] 11984 2.936% 99.261% # ( 6, 10 ] 2376 0.582% 99.843% ( 10, 15 ] 591 0.145% 99.988% ( 15, 22 ] 75 0.018% 100.007% ( 22, 34 ] 11 0.003% 100.009% ( 34, 51 ] 3 0.001% 100.010% ( 51, 76 ] 3 0.001% 100.011% ( 76, 110 ] 1 0.000% 100.011% ( 110, 170 ] 10 0.002% 100.013% ( 170, 250 ] 12 0.003% 100.016% ( 250, 380 ] 5 0.001% 100.018% ( 380, 580 ] 8 0.002% 100.020% ( 580, 870 ] 8 0.002% 100.022% ( 870, 1300 ] 5 0.001% 100.023% ( 1300, 1900 ] 1 0.000% 100.023% ( 1900, 2900 ] 5 0.001% 100.024% ( 2900, 4400 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 129553 Average: 2.4992 StdDev: 12.48 Min: 0 Median: 1.6090 Max: 1947 Percentiles: P50: 1.61 P75: 2.04 P99: 5.99 P99.9: 14.71 P99.99: 382.23 ------------------------------------------------------ [ 0, 1 ] 15828 12.217% 12.217% ## ( 1, 2 ] 80374 62.039% 74.257% ############ ( 2, 3 ] 22182 17.122% 91.379% ### ( 3, 4 ] 5030 3.883% 95.261% # ( 4, 6 ] 4879 3.766% 99.027% # ( 6, 10 ] 930 0.718% 99.745% ( 10, 15 ] 213 0.164% 99.910% ( 15, 22 ] 30 0.023% 99.933% ( 22, 34 ] 3 0.002% 99.935% ( 34, 51 ] 1 0.001% 99.936% ( 51, 76 ] 31 0.024% 99.960% ( 76, 110 ] 8 0.006% 99.966% ( 110, 170 ] 6 0.005% 99.971% ( 170, 250 ] 12 0.009% 99.980% ( 250, 380 ] 13 0.010% 99.990% ( 380, 580 ] 4 0.003% 99.993% ( 580, 870 ] 1 0.001% 99.994% ( 870, 1300 ] 4 0.003% 99.997% ( 1300, 1900 ] 3 0.002% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 15911 Average: 1.7697 StdDev: 3.84 Min: 1 Median: 1.1864 Max: 408 Percentiles: P50: 1.19 P75: 1.64 P99: 5.06 P99.9: 9.89 P99.99: 202.71 ------------------------------------------------------ [ 0, 1 ] 6319 39.715% 39.715% ######## ( 1, 2 ] 8780 55.182% 94.897% ########### ( 2, 3 ] 314 1.973% 96.870% ( 3, 4 ] 251 1.578% 98.448% ( 4, 6 ] 166 1.043% 99.491% ( 6, 10 ] 67 0.421% 99.912% ( 10, 15 ] 6 0.038% 99.950% ( 15, 22 ] 4 0.025% 99.975% ( 51, 76 ] 1 0.006% 99.981% ( 110, 170 ] 1 0.006% 99.987% ( 170, 250 ] 1 0.006% 99.994% ( 380, 580 ] 1 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 75294 Average: 5.2376 StdDev: 86.32 Min: 0 Median: 1.7947 Max: 8292 Percentiles: P50: 1.79 P75: 2.58 P99: 9.81 P99.9: 420.64 P99.99: 3870.59 ------------------------------------------------------ [ 0, 1 ] 2978 3.955% 3.955% # ( 1, 2 ] 43624 57.938% 61.893% ############ ( 2, 3 ] 17121 22.739% 84.632% ##### ( 3, 4 ] 4591 6.097% 90.730% # ( 4, 6 ] 4684 6.221% 96.951% # ( 6, 10 ] 1621 2.153% 99.104% ( 10, 15 ] 332 0.441% 99.544% ( 15, 22 ] 38 0.050% 99.595% ( 22, 34 ] 5 0.007% 99.602% ( 51, 76 ] 1 0.001% 99.603% ( 76, 110 ] 33 0.044% 99.647% ( 110, 170 ] 104 0.138% 99.785% ( 170, 250 ] 46 0.061% 99.846% ( 250, 380 ] 35 0.046% 99.892% ( 380, 580 ] 33 0.044% 99.936% ( 580, 870 ] 18 0.024% 99.960% ( 870, 1300 ] 7 0.009% 99.969% ( 1300, 1900 ] 7 0.009% 99.979% ( 1900, 2900 ] 3 0.004% 99.983% ( 2900, 4400 ] 10 0.013% 99.996% ( 4400, 6600 ] 11 0.015% 100.011% ( 6600, 9900 ] 1 0.001% 100.012% ** Level 4 read latency histogram (micros): Count: 30 Average: 3668.9000 StdDev: 2168.83 Min: 246 Median: 3800.0000 Max: 8668 Percentiles: P50: 3800.00 P75: 5610.00 P99: 8668.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 1 3.333% 10.000% # ( 1300, 1900 ] 3 10.000% 20.000% ## ( 1900, 2900 ] 6 20.000% 40.000% #### ( 2900, 4400 ] 5 16.667% 56.667% ### ( 4400, 6600 ] 10 33.333% 90.000% ####### ( 6600, 9900 ] 3 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 314.05 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.831 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 318.86 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.448 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/17-02:32:48 ... thread 0: (1000000,3000000) ops and (347467.5,335980.3) ops/second in (2.877967,8.929096) 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/12 2.09 GB 44.1 1.4 0.0 1.4 4.1 2.7 0.0 1.5 106.7 310.7 13.58 12.53 44 0.309 1471K 1564 0.0 0.0 L1 2/2 50.36 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 241.7 241.2 3.39 3.28 2 1.694 831K 1409 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 24/0 991.53 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 212.0 211.9 6.90 6.12 4 1.724 1462K 774 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1241/14 98.84 GB 0.0 3.8 1.2 2.6 6.5 3.9 1.4 2.4 157.8 271.5 24.34 22.38 51 0.477 3878K 3784 0.0 0.0 Int 0/0 0.00 KB 0.0 3.8 1.2 2.6 6.5 3.9 1.3 2.4 157.8 271.5 24.34 22.38 51 0.477 3878K 3784 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.8 1.2 2.6 3.7 1.2 0.0 0.0 233.6 233.3 16.44 15.40 12 1.370 3878K 3784 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 351.0 7.90 6.98 39 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 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.45 GB write, 722.60 MB/s write, 3.75 GB read, 419.97 MB/s read, 24.3 seconds Interval compaction: 6.45 GB write, 740.01 MB/s write, 3.75 GB read, 430.08 MB/s read, 24.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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 691932 Average: 2.4528 StdDev: 12.30 Min: 0 Median: 1.6332 Max: 3500 Percentiles: P50: 1.63 P75: 2.12 P99: 5.93 P99.9: 12.13 P99.99: 14.81 ------------------------------------------------------ [ 0, 1 ] 74515 10.769% 10.769% ## ( 1, 2 ] 428721 61.960% 72.729% ############ ( 2, 3 ] 128420 18.560% 91.289% #### ( 3, 4 ] 28942 4.183% 95.472% # ( 4, 6 ] 25299 3.656% 99.128% # ( 6, 10 ] 4852 0.701% 99.829% ( 10, 15 ] 1160 0.168% 99.997% ( 15, 22 ] 120 0.017% 100.014% ( 22, 34 ] 20 0.003% 100.017% ( 34, 51 ] 6 0.001% 100.018% ( 51, 76 ] 5 0.001% 100.018% ( 76, 110 ] 3 0.000% 100.019% ( 110, 170 ] 33 0.005% 100.024% ( 170, 250 ] 37 0.005% 100.029% ( 250, 380 ] 11 0.002% 100.031% ( 380, 580 ] 24 0.003% 100.034% ( 580, 870 ] 13 0.002% 100.036% ( 870, 1300 ] 10 0.001% 100.037% ( 1300, 1900 ] 4 0.001% 100.038% ( 1900, 2900 ] 7 0.001% 100.039% ( 2900, 4400 ] 3 0.000% 100.039% ** Level 1 read latency histogram (micros): Count: 206971 Average: 2.5373 StdDev: 9.90 Min: 0 Median: 1.6805 Max: 1947 Percentiles: P50: 1.68 P75: 2.27 P99: 5.98 P99.9: 13.91 P99.99: 303.03 ------------------------------------------------------ [ 0, 1 ] 17727 8.565% 8.565% ## ( 1, 2 ] 126016 60.886% 69.451% ############ ( 2, 3 ] 42493 20.531% 89.982% #### ( 3, 4 ] 9349 4.517% 94.499% # ( 4, 6 ] 9422 4.552% 99.051% # ( 6, 10 ] 1483 0.717% 99.768% ( 10, 15 ] 350 0.169% 99.937% ( 15, 22 ] 43 0.021% 99.957% ( 22, 34 ] 3 0.001% 99.959% ( 34, 51 ] 2 0.001% 99.960% ( 51, 76 ] 31 0.015% 99.975% ( 76, 110 ] 8 0.004% 99.979% ( 110, 170 ] 6 0.003% 99.982% ( 170, 250 ] 12 0.006% 99.987% ( 250, 380 ] 13 0.006% 99.994% ( 380, 580 ] 4 0.002% 99.996% ( 580, 870 ] 1 0.000% 99.996% ( 870, 1300 ] 4 0.002% 99.998% ( 1300, 1900 ] 3 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28241 Average: 2.1686 StdDev: 5.69 Min: 1 Median: 1.4391 Max: 511 Percentiles: P50: 1.44 P75: 1.86 P99: 7.01 P99.9: 12.36 P99.99: 391.73 ------------------------------------------------------ [ 0, 1 ] 6838 24.213% 24.213% ##### ( 1, 2 ] 16586 58.730% 82.943% ############ ( 2, 3 ] 2877 10.187% 93.131% ## ( 3, 4 ] 853 3.020% 96.151% # ( 4, 6 ] 723 2.560% 98.711% # ( 6, 10 ] 323 1.144% 99.855% ( 10, 15 ] 27 0.096% 99.950% ( 15, 22 ] 5 0.018% 99.968% ( 51, 76 ] 1 0.004% 99.972% ( 110, 170 ] 2 0.007% 99.979% ( 170, 250 ] 2 0.007% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 3 0.011% 100.000% ** Level 3 read latency histogram (micros): Count: 212647 Average: 4.0596 StdDev: 53.58 Min: 0 Median: 1.7668 Max: 8292 Percentiles: P50: 1.77 P75: 2.50 P99: 9.36 P99.9: 272.18 P99.99: 845.72 ------------------------------------------------------ [ 0, 1 ] 9621 4.524% 4.524% # ( 1, 2 ] 126105 59.303% 63.827% ############ ( 2, 3 ] 47786 22.472% 86.299% #### ( 3, 4 ] 11756 5.528% 91.827% # ( 4, 6 ] 11621 5.465% 97.292% # ( 6, 10 ] 4317 2.030% 99.322% ( 10, 15 ] 615 0.289% 99.612% ( 15, 22 ] 75 0.035% 99.647% ( 22, 34 ] 32 0.015% 99.662% ( 34, 51 ] 2 0.001% 99.663% ( 51, 76 ] 2 0.001% 99.664% ( 76, 110 ] 73 0.034% 99.698% ( 110, 170 ] 305 0.143% 99.842% ( 170, 250 ] 109 0.051% 99.893% ( 250, 380 ] 90 0.042% 99.935% ( 380, 580 ] 81 0.038% 99.973% ( 580, 870 ] 39 0.018% 99.992% ( 870, 1300 ] 19 0.009% 100.000% ( 1300, 1900 ] 9 0.004% 100.005% ( 1900, 2900 ] 3 0.001% 100.006% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 11 0.005% 100.016% ( 6600, 9900 ] 1 0.000% 100.016% ** Level 4 read latency histogram (micros): Count: 30 Average: 3668.9000 StdDev: 2168.83 Min: 246 Median: 3800.0000 Max: 8668 Percentiles: P50: 3800.00 P75: 5610.00 P99: 8668.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 1 3.333% 10.000% # ( 1300, 1900 ] 3 10.000% 20.000% ## ( 1900, 2900 ] 6 20.000% 40.000% #### ( 2900, 4400 ] 5 16.667% 56.667% ### ( 4400, 6600 ] 10 33.333% 90.000% ####### ( 6600, 9900 ] 3 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 737.8500 StdDev: 826.92 Min: 82 Median: 354.0000 Max: 2962 Percentiles: P50: 354.00 P75: 870.00 P99: 2962.00 P99.9: 2962.00 P99.99: 2962.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 3 15.000% 20.000% ### ( 170, 250 ] 2 10.000% 30.000% ## ( 250, 380 ] 5 25.000% 55.000% ##### ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 2.9 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 322.84 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.078 H:M:S, 11.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 341.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.247 H:M:S, 8.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-02:32:52 ... thread 0: (1000000,4000000) ops and (305848.3,327904.0) ops/second in (3.269595,12.198691) 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/12 3.07 GB 144.7 2.3 0.0 2.3 6.0 3.7 0.0 1.6 116.9 306.2 19.95 18.47 60 0.332 2366K 2549 0.0 0.0 L1 2/2 50.36 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 241.7 241.2 3.39 3.28 2 1.694 831K 1409 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 24/0 991.53 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 212.0 211.9 6.90 6.12 4 1.724 1462K 774 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1245/14 99.82 GB 0.0 4.6 1.2 3.4 8.3 4.9 1.4 2.2 153.8 276.7 30.71 28.32 67 0.458 4773K 4769 0.0 0.0 Int 0/0 0.00 KB 0.0 4.6 1.2 3.4 8.3 4.9 1.3 2.2 153.8 276.7 30.71 28.32 67 0.458 4773K 4769 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.6 1.2 3.4 4.6 1.2 0.0 0.0 237.7 237.5 19.87 18.74 15 1.324 4773K 4769 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 348.6 10.84 9.58 52 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.4 total, 12.2 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.30 GB write, 684.44 MB/s write, 4.61 GB read, 380.40 MB/s read, 30.7 seconds Interval compaction: 8.30 GB write, 696.50 MB/s write, 4.61 GB read, 387.11 MB/s read, 30.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 18, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1126677 Average: 2.4784 StdDev: 12.18 Min: 0 Median: 1.6359 Max: 3500 Percentiles: P50: 1.64 P75: 2.11 P99: 5.97 P99.9: 12.11 P99.99: 14.86 ------------------------------------------------------ [ 0, 1 ] 111282 9.877% 9.877% ## ( 1, 2 ] 710892 63.096% 72.973% ############# ( 2, 3 ] 211951 18.812% 91.785% #### ( 3, 4 ] 43953 3.901% 95.687% # ( 4, 6 ] 37848 3.359% 99.046% # ( 6, 10 ] 8848 0.785% 99.831% ( 10, 15 ] 1844 0.164% 99.995% ( 15, 22 ] 171 0.015% 100.010% ( 22, 34 ] 23 0.002% 100.012% ( 34, 51 ] 6 0.001% 100.013% ( 51, 76 ] 10 0.001% 100.013% ( 76, 110 ] 39 0.003% 100.017% ( 110, 170 ] 115 0.010% 100.027% ( 170, 250 ] 82 0.007% 100.034% ( 250, 380 ] 36 0.003% 100.038% ( 380, 580 ] 47 0.004% 100.042% ( 580, 870 ] 29 0.003% 100.044% ( 870, 1300 ] 22 0.002% 100.046% ( 1300, 1900 ] 7 0.001% 100.047% ( 1900, 2900 ] 9 0.001% 100.048% ( 2900, 4400 ] 4 0.000% 100.048% ** Level 1 read latency histogram (micros): Count: 206971 Average: 2.5373 StdDev: 9.90 Min: 0 Median: 1.6805 Max: 1947 Percentiles: P50: 1.68 P75: 2.27 P99: 5.98 P99.9: 13.91 P99.99: 303.03 ------------------------------------------------------ [ 0, 1 ] 17727 8.565% 8.565% ## ( 1, 2 ] 126016 60.886% 69.451% ############ ( 2, 3 ] 42493 20.531% 89.982% #### ( 3, 4 ] 9349 4.517% 94.499% # ( 4, 6 ] 9422 4.552% 99.051% # ( 6, 10 ] 1483 0.717% 99.768% ( 10, 15 ] 350 0.169% 99.937% ( 15, 22 ] 43 0.021% 99.957% ( 22, 34 ] 3 0.001% 99.959% ( 34, 51 ] 2 0.001% 99.960% ( 51, 76 ] 31 0.015% 99.975% ( 76, 110 ] 8 0.004% 99.979% ( 110, 170 ] 6 0.003% 99.982% ( 170, 250 ] 12 0.006% 99.987% ( 250, 380 ] 13 0.006% 99.994% ( 380, 580 ] 4 0.002% 99.996% ( 580, 870 ] 1 0.000% 99.996% ( 870, 1300 ] 4 0.002% 99.998% ( 1300, 1900 ] 3 0.001% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28241 Average: 2.1686 StdDev: 5.69 Min: 1 Median: 1.4391 Max: 511 Percentiles: P50: 1.44 P75: 1.86 P99: 7.01 P99.9: 12.36 P99.99: 391.73 ------------------------------------------------------ [ 0, 1 ] 6838 24.213% 24.213% ##### ( 1, 2 ] 16586 58.730% 82.943% ############ ( 2, 3 ] 2877 10.187% 93.131% ## ( 3, 4 ] 853 3.020% 96.151% # ( 4, 6 ] 723 2.560% 98.711% # ( 6, 10 ] 323 1.144% 99.855% ( 10, 15 ] 27 0.096% 99.950% ( 15, 22 ] 5 0.018% 99.968% ( 51, 76 ] 1 0.004% 99.972% ( 110, 170 ] 2 0.007% 99.979% ( 170, 250 ] 2 0.007% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 3 0.011% 100.000% ** Level 3 read latency histogram (micros): Count: 212647 Average: 4.0596 StdDev: 53.58 Min: 0 Median: 1.7668 Max: 8292 Percentiles: P50: 1.77 P75: 2.50 P99: 9.36 P99.9: 272.18 P99.99: 845.72 ------------------------------------------------------ [ 0, 1 ] 9621 4.524% 4.524% # ( 1, 2 ] 126105 59.303% 63.827% ############ ( 2, 3 ] 47786 22.472% 86.299% #### ( 3, 4 ] 11756 5.528% 91.827% # ( 4, 6 ] 11621 5.465% 97.292% # ( 6, 10 ] 4317 2.030% 99.322% ( 10, 15 ] 615 0.289% 99.612% ( 15, 22 ] 75 0.035% 99.647% ( 22, 34 ] 32 0.015% 99.662% ( 34, 51 ] 2 0.001% 99.663% ( 51, 76 ] 2 0.001% 99.664% ( 76, 110 ] 73 0.034% 99.698% ( 110, 170 ] 305 0.143% 99.842% ( 170, 250 ] 109 0.051% 99.893% ( 250, 380 ] 90 0.042% 99.935% ( 380, 580 ] 81 0.038% 99.973% ( 580, 870 ] 39 0.018% 99.992% ( 870, 1300 ] 19 0.009% 100.000% ( 1300, 1900 ] 9 0.004% 100.005% ( 1900, 2900 ] 3 0.001% 100.006% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 11 0.005% 100.016% ( 6600, 9900 ] 1 0.000% 100.016% ** Level 4 read latency histogram (micros): Count: 30 Average: 3668.9000 StdDev: 2168.83 Min: 246 Median: 3800.0000 Max: 8668 Percentiles: P50: 3800.00 P75: 5610.00 P99: 8668.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 1 3.333% 10.000% # ( 1300, 1900 ] 3 10.000% 20.000% ## ( 1900, 2900 ] 6 20.000% 40.000% #### ( 2900, 4400 ] 5 16.667% 56.667% ### ( 4400, 6600 ] 10 33.333% 90.000% ####### ( 6600, 9900 ] 3 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 737.8500 StdDev: 826.92 Min: 82 Median: 354.0000 Max: 2962 Percentiles: P50: 354.00 P75: 870.00 P99: 2962.00 P99.9: 2962.00 P99.99: 2962.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 3 15.000% 20.000% ### ( 170, 250 ] 2 10.000% 30.000% ## ( 250, 380 ] 5 25.000% 55.000% ##### ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.4 total, 3.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 317.09 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.753 H:M:S, 14.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 301.01 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.675 H:M:S, 20.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-02:32:55 ... thread 0: (1000000,5000000) ops and (299972.4,321909.2) ops/second in (3.333640,15.532331) 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/14 2.64 GB 31.5 3.0 0.0 3.0 7.7 4.7 0.0 1.6 120.1 306.2 25.70 23.85 77 0.334 3134K 3278 0.0 0.0 L1 14/14 1.45 GB 0.0 2.3 1.9 0.4 2.3 1.9 0.1 1.2 227.3 226.2 10.19 9.82 3 3.397 2352K 11K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 24/0 991.53 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 212.0 211.9 6.90 6.12 4 1.724 1462K 774 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1254/28 100.80 GB 0.0 6.8 2.6 4.2 11.5 7.2 1.4 2.5 161.3 271.5 43.26 40.24 85 0.509 7062K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.8 2.6 4.2 11.5 7.2 1.3 2.5 161.3 271.5 43.26 40.24 85 0.509 7062K 15K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.8 2.6 4.2 6.8 2.6 0.0 0.0 236.0 235.5 29.56 28.11 19 1.556 7062K 15K 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.2 13.71 12.13 66 0.208 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.7 total, 15.5 interval Flush(GB): cumulative 4.675, interval 4.675 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.47 GB write, 745.98 MB/s write, 6.81 GB read, 443.00 MB/s read, 43.3 seconds Interval compaction: 11.47 GB write, 756.31 MB/s write, 6.81 GB read, 449.13 MB/s read, 43.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 20, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 20, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1396601 Average: 2.4554 StdDev: 12.09 Min: 0 Median: 1.6184 Max: 3500 Percentiles: P50: 1.62 P75: 2.03 P99: 5.94 P99.9: 11.99 P99.99: 15.19 ------------------------------------------------------ [ 0, 1 ] 145589 10.425% 10.425% ## ( 1, 2 ] 893771 63.996% 74.421% ############# ( 2, 3 ] 250473 17.934% 92.355% #### ( 3, 4 ] 51134 3.661% 96.016% # ( 4, 6 ] 42908 3.072% 99.089% # ( 6, 10 ] 10507 0.752% 99.841% ( 10, 15 ] 2076 0.149% 99.990% ( 15, 22 ] 199 0.014% 100.004% ( 22, 34 ] 23 0.002% 100.006% ( 34, 51 ] 10 0.001% 100.006% ( 51, 76 ] 13 0.001% 100.007% ( 76, 110 ] 72 0.005% 100.012% ( 110, 170 ] 149 0.011% 100.023% ( 170, 250 ] 113 0.008% 100.031% ( 250, 380 ] 45 0.003% 100.034% ( 380, 580 ] 66 0.005% 100.039% ( 580, 870 ] 43 0.003% 100.042% ( 870, 1300 ] 26 0.002% 100.044% ( 1300, 1900 ] 10 0.001% 100.045% ( 1900, 2900 ] 11 0.001% 100.046% ( 2900, 4400 ] 4 0.000% 100.046% ** Level 1 read latency histogram (micros): Count: 268761 Average: 2.6135 StdDev: 12.26 Min: 0 Median: 1.6407 Max: 1947 Percentiles: P50: 1.64 P75: 2.14 P99: 6.73 P99.9: 78.26 P99.99: 528.32 ------------------------------------------------------ [ 0, 1 ] 27189 10.116% 10.116% ## ( 1, 2 ] 167317 62.255% 72.371% ############ ( 2, 3 ] 49720 18.500% 90.871% #### ( 3, 4 ] 10775 4.009% 94.880% # ( 4, 6 ] 10642 3.960% 98.840% # ( 6, 10 ] 2365 0.880% 99.720% ( 10, 15 ] 392 0.146% 99.866% ( 15, 22 ] 50 0.019% 99.884% ( 22, 34 ] 3 0.001% 99.885% ( 34, 51 ] 2 0.001% 99.886% ( 51, 76 ] 31 0.012% 99.898% ( 76, 110 ] 109 0.041% 99.938% ( 110, 170 ] 78 0.029% 99.967% ( 170, 250 ] 27 0.010% 99.977% ( 250, 380 ] 24 0.009% 99.986% ( 380, 580 ] 15 0.006% 99.992% ( 580, 870 ] 7 0.003% 99.994% ( 870, 1300 ] 9 0.003% 99.998% ( 1300, 1900 ] 6 0.002% 100.000% ( 1900, 2900 ] 1 0.000% 100.000% ** Level 2 read latency histogram (micros): Count: 28241 Average: 2.1686 StdDev: 5.69 Min: 1 Median: 1.4391 Max: 511 Percentiles: P50: 1.44 P75: 1.86 P99: 7.01 P99.9: 12.36 P99.99: 391.73 ------------------------------------------------------ [ 0, 1 ] 6838 24.213% 24.213% ##### ( 1, 2 ] 16586 58.730% 82.943% ############ ( 2, 3 ] 2877 10.187% 93.131% ## ( 3, 4 ] 853 3.020% 96.151% # ( 4, 6 ] 723 2.560% 98.711% # ( 6, 10 ] 323 1.144% 99.855% ( 10, 15 ] 27 0.096% 99.950% ( 15, 22 ] 5 0.018% 99.968% ( 51, 76 ] 1 0.004% 99.972% ( 110, 170 ] 2 0.007% 99.979% ( 170, 250 ] 2 0.007% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 3 0.011% 100.000% ** Level 3 read latency histogram (micros): Count: 212647 Average: 4.0596 StdDev: 53.58 Min: 0 Median: 1.7668 Max: 8292 Percentiles: P50: 1.77 P75: 2.50 P99: 9.36 P99.9: 272.18 P99.99: 845.72 ------------------------------------------------------ [ 0, 1 ] 9621 4.524% 4.524% # ( 1, 2 ] 126105 59.303% 63.827% ############ ( 2, 3 ] 47786 22.472% 86.299% #### ( 3, 4 ] 11756 5.528% 91.827% # ( 4, 6 ] 11621 5.465% 97.292% # ( 6, 10 ] 4317 2.030% 99.322% ( 10, 15 ] 615 0.289% 99.612% ( 15, 22 ] 75 0.035% 99.647% ( 22, 34 ] 32 0.015% 99.662% ( 34, 51 ] 2 0.001% 99.663% ( 51, 76 ] 2 0.001% 99.664% ( 76, 110 ] 73 0.034% 99.698% ( 110, 170 ] 305 0.143% 99.842% ( 170, 250 ] 109 0.051% 99.893% ( 250, 380 ] 90 0.042% 99.935% ( 380, 580 ] 81 0.038% 99.973% ( 580, 870 ] 39 0.018% 99.992% ( 870, 1300 ] 19 0.009% 100.000% ( 1300, 1900 ] 9 0.004% 100.005% ( 1900, 2900 ] 3 0.001% 100.006% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 11 0.005% 100.016% ( 6600, 9900 ] 1 0.000% 100.016% ** Level 4 read latency histogram (micros): Count: 30 Average: 3668.9000 StdDev: 2168.83 Min: 246 Median: 3800.0000 Max: 8668 Percentiles: P50: 3800.00 P75: 5610.00 P99: 8668.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 1 3.333% 10.000% # ( 1300, 1900 ] 3 10.000% 20.000% ## ( 1900, 2900 ] 6 20.000% 40.000% #### ( 2900, 4400 ] 5 16.667% 56.667% ### ( 4400, 6600 ] 10 33.333% 90.000% ####### ( 6600, 9900 ] 3 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 737.8500 StdDev: 826.92 Min: 82 Median: 354.0000 Max: 2962 Percentiles: P50: 354.00 P75: 870.00 P99: 2962.00 P99.9: 2962.00 P99.99: 2962.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 3 15.000% 20.000% ### ( 170, 250 ] 2 10.000% 30.000% ## ( 250, 380 ] 5 25.000% 55.000% ##### ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.7 total, 3.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 312.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:2.510 H:M:S, 15.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 295.23 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.757 H:M:S, 22.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-02:32:59 ... thread 0: (1000000,6000000) ops and (253328.7,308011.8) ops/second in (3.947440,19.479771) 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.63 GB 138.4 4.1 0.0 4.1 9.8 5.7 0.0 1.7 128.3 304.4 32.89 30.65 96 0.343 4285K 4513 0.0 0.0 L1 14/14 1.45 GB 0.0 2.3 1.9 0.4 2.3 1.9 0.1 1.2 227.3 226.2 10.19 9.82 3 3.397 2352K 11K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.6 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 24/0 991.53 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 212.0 211.9 6.90 6.12 4 1.724 1462K 774 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1257/28 101.78 GB 0.0 7.9 2.6 5.3 13.6 8.2 1.4 2.4 160.8 275.3 50.45 47.04 104 0.485 8213K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.9 2.6 5.3 13.6 8.2 1.3 2.4 160.8 275.3 50.45 47.04 104 0.485 8213K 16K 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.9 2.6 5.3 7.9 2.6 0.0 0.0 239.2 238.7 33.91 32.38 23 1.474 8213K 16K 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 350.4 16.54 14.66 81 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.7 total, 19.5 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.56 GB write, 705.15 MB/s write, 7.92 GB read, 411.79 MB/s read, 50.4 seconds Interval compaction: 13.56 GB write, 712.94 MB/s write, 7.92 GB read, 416.33 MB/s read, 50.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, 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: 10, total-stops: 21, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1803992 Average: 2.4553 StdDev: 12.12 Min: 0 Median: 1.6166 Max: 3500 Percentiles: P50: 1.62 P75: 2.01 P99: 5.91 P99.9: 11.88 P99.99: 16.56 ------------------------------------------------------ [ 0, 1 ] 184213 10.211% 10.211% ## ( 1, 2 ] 1164166 64.533% 74.744% ############# ( 2, 3 ] 321527 17.823% 92.567% #### ( 3, 4 ] 64425 3.571% 96.139% # ( 4, 6 ] 53920 2.989% 99.127% # ( 6, 10 ] 12988 0.720% 99.847% ( 10, 15 ] 2521 0.140% 99.987% ( 15, 22 ] 232 0.013% 100.000% ( 22, 34 ] 25 0.001% 100.001% ( 34, 51 ] 10 0.001% 100.002% ( 51, 76 ] 14 0.001% 100.003% ( 76, 110 ] 139 0.008% 100.010% ( 110, 170 ] 225 0.012% 100.023% ( 170, 250 ] 142 0.008% 100.031% ( 250, 380 ] 63 0.003% 100.034% ( 380, 580 ] 94 0.005% 100.039% ( 580, 870 ] 55 0.003% 100.043% ( 870, 1300 ] 34 0.002% 100.044% ( 1300, 1900 ] 14 0.001% 100.045% ( 1900, 2900 ] 12 0.001% 100.046% ( 2900, 4400 ] 6 0.000% 100.046% ** Level 1 read latency histogram (micros): Count: 359026 Average: 2.6527 StdDev: 12.46 Min: 0 Median: 1.6352 Max: 2041 Percentiles: P50: 1.64 P75: 2.11 P99: 7.35 P99.9: 99.01 P99.99: 530.70 ------------------------------------------------------ [ 0, 1 ] 35586 9.912% 9.912% ## ( 1, 2 ] 226589 63.112% 73.024% ############# ( 2, 3 ] 65317 18.193% 91.217% #### ( 3, 4 ] 13504 3.761% 94.978% # ( 4, 6 ] 13154 3.664% 98.642% # ( 6, 10 ] 3818 1.063% 99.705% ( 10, 15 ] 491 0.137% 99.842% ( 15, 22 ] 61 0.017% 99.859% ( 22, 34 ] 3 0.001% 99.860% ( 34, 51 ] 3 0.001% 99.861% ( 51, 76 ] 32 0.009% 99.870% ( 76, 110 ] 161 0.045% 99.914% ( 110, 170 ] 149 0.042% 99.956% ( 170, 250 ] 60 0.017% 99.973% ( 250, 380 ] 41 0.011% 99.984% ( 380, 580 ] 28 0.008% 99.992% ( 580, 870 ] 11 0.003% 99.995% ( 870, 1300 ] 10 0.003% 99.998% ( 1300, 1900 ] 6 0.002% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28241 Average: 2.1686 StdDev: 5.69 Min: 1 Median: 1.4391 Max: 511 Percentiles: P50: 1.44 P75: 1.86 P99: 7.01 P99.9: 12.36 P99.99: 391.73 ------------------------------------------------------ [ 0, 1 ] 6838 24.213% 24.213% ##### ( 1, 2 ] 16586 58.730% 82.943% ############ ( 2, 3 ] 2877 10.187% 93.131% ## ( 3, 4 ] 853 3.020% 96.151% # ( 4, 6 ] 723 2.560% 98.711% # ( 6, 10 ] 323 1.144% 99.855% ( 10, 15 ] 27 0.096% 99.950% ( 15, 22 ] 5 0.018% 99.968% ( 51, 76 ] 1 0.004% 99.972% ( 110, 170 ] 2 0.007% 99.979% ( 170, 250 ] 2 0.007% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 3 0.011% 100.000% ** Level 3 read latency histogram (micros): Count: 212647 Average: 4.0596 StdDev: 53.58 Min: 0 Median: 1.7668 Max: 8292 Percentiles: P50: 1.77 P75: 2.50 P99: 9.36 P99.9: 272.18 P99.99: 845.72 ------------------------------------------------------ [ 0, 1 ] 9621 4.524% 4.524% # ( 1, 2 ] 126105 59.303% 63.827% ############ ( 2, 3 ] 47786 22.472% 86.299% #### ( 3, 4 ] 11756 5.528% 91.827% # ( 4, 6 ] 11621 5.465% 97.292% # ( 6, 10 ] 4317 2.030% 99.322% ( 10, 15 ] 615 0.289% 99.612% ( 15, 22 ] 75 0.035% 99.647% ( 22, 34 ] 32 0.015% 99.662% ( 34, 51 ] 2 0.001% 99.663% ( 51, 76 ] 2 0.001% 99.664% ( 76, 110 ] 73 0.034% 99.698% ( 110, 170 ] 305 0.143% 99.842% ( 170, 250 ] 109 0.051% 99.893% ( 250, 380 ] 90 0.042% 99.935% ( 380, 580 ] 81 0.038% 99.973% ( 580, 870 ] 39 0.018% 99.992% ( 870, 1300 ] 19 0.009% 100.000% ( 1300, 1900 ] 9 0.004% 100.005% ( 1900, 2900 ] 3 0.001% 100.006% ( 2900, 4400 ] 10 0.005% 100.011% ( 4400, 6600 ] 11 0.005% 100.016% ( 6600, 9900 ] 1 0.000% 100.016% ** Level 4 read latency histogram (micros): Count: 30 Average: 3668.9000 StdDev: 2168.83 Min: 246 Median: 3800.0000 Max: 8668 Percentiles: P50: 3800.00 P75: 5610.00 P99: 8668.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 1 3.333% 10.000% # ( 1300, 1900 ] 3 10.000% 20.000% ## ( 1900, 2900 ] 6 20.000% 40.000% #### ( 2900, 4400 ] 5 16.667% 56.667% ### ( 4400, 6600 ] 10 33.333% 90.000% ####### ( 6600, 9900 ] 3 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 737.8500 StdDev: 826.92 Min: 82 Median: 354.0000 Max: 2962 Percentiles: P50: 354.00 P75: 870.00 P99: 2962.00 P99.9: 2962.00 P99.99: 2962.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 3 15.000% 20.000% ### ( 170, 250 ] 2 10.000% 30.000% ## ( 250, 380 ] 5 25.000% 55.000% ##### ( 380, 580 ] 3 15.000% 70.000% ### ( 580, 870 ] 1 5.000% 75.000% # ( 870, 1300 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 19.7 total, 3.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 299.81 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.789 H:M:S, 19.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 249.32 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.280 H:M:S, 32.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/17-02:33:10 ... thread 0: (1000000,7000000) ops and (93681.0,232139.4) ops/second in (10.674523,30.154294) 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 2.58 GB 6.3 6.2 0.0 6.2 12.8 6.6 0.0 1.9 143.6 298.4 43.88 40.97 117 0.375 6395K 10K 0.0 0.0 L1 25/25 2.43 GB 0.0 5.7 3.9 1.8 5.7 3.9 0.1 1.4 222.2 219.8 26.47 25.14 4 6.618 5972K 62K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.6 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 19/5 1.19 GB 0.9 1.4 0.6 0.8 1.4 0.6 1.0 2.3 212.0 211.9 6.90 6.12 4 1.724 1462K 774 0.0 0.0 L4 157/3 9.72 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1056/0 86.80 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1266/41 102.71 GB 0.0 13.4 4.6 8.8 20.0 11.2 4.8 3.0 177.0 263.5 77.72 72.68 126 0.617 13M 73K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.4 4.6 8.8 20.0 11.2 4.8 3.0 177.0 263.5 77.72 72.68 126 0.617 13M 73K 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.4 4.6 8.8 13.4 4.5 0.0 0.0 236.2 235.0 58.22 55.40 29 2.007 13M 73K 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 348.8 19.51 17.27 97 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): 30.4 total, 30.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.00 GB write, 674.43 MB/s write, 13.43 GB read, 452.85 MB/s read, 77.7 seconds Interval compaction: 20.00 GB write, 679.24 MB/s write, 13.43 GB read, 456.08 MB/s read, 77.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 25, total-stops: 21, interval: 46 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2660785 Average: 2.6827 StdDev: 15.01 Min: 0 Median: 1.5966 Max: 3831 Percentiles: P50: 1.60 P75: 1.98 P99: 6.43 P99.9: 108.07 P99.99: 208.13 ------------------------------------------------------ [ 0, 1 ] 289720 10.889% 10.889% ## ( 1, 2 ] 1744415 65.560% 76.449% ############# ( 2, 3 ] 440190 16.544% 92.992% ### ( 3, 4 ] 86546 3.253% 96.245% # ( 4, 6 ] 71082 2.671% 98.916% # ( 6, 10 ] 20870 0.784% 99.701% ( 10, 15 ] 3482 0.131% 99.832% ( 15, 22 ] 334 0.013% 99.844% ( 22, 34 ] 32 0.001% 99.845% ( 34, 51 ] 13 0.000% 99.846% ( 51, 76 ] 15 0.001% 99.846% ( 76, 110 ] 1512 0.057% 99.903% ( 110, 170 ] 2002 0.075% 99.979% ( 170, 250 ] 644 0.024% 100.003% ( 250, 380 ] 386 0.015% 100.017% ( 380, 580 ] 322 0.012% 100.029% ( 580, 870 ] 165 0.006% 100.036% ( 870, 1300 ] 70 0.003% 100.038% ( 1300, 1900 ] 20 0.001% 100.039% ( 1900, 2900 ] 19 0.001% 100.040% ( 2900, 4400 ] 9 0.000% 100.040% ** Level 1 read latency histogram (micros): Count: 608582 Average: 2.7307 StdDev: 15.12 Min: 0 Median: 1.5960 Max: 2474 Percentiles: P50: 1.60 P75: 1.98 P99: 7.72 P99.9: 135.77 P99.99: 634.60 ------------------------------------------------------ [ 0, 1 ] 70396 11.567% 11.567% ## ( 1, 2 ] 392467 64.489% 76.056% ############# ( 2, 3 ] 98035 16.109% 92.165% ### ( 3, 4 ] 19756 3.246% 95.411% # ( 4, 6 ] 18808 3.090% 98.501% # ( 6, 10 ] 7036 1.156% 99.658% ( 10, 15 ] 676 0.111% 99.769% ( 15, 22 ] 90 0.015% 99.783% ( 22, 34 ] 4 0.001% 99.784% ( 34, 51 ] 4 0.001% 99.785% ( 51, 76 ] 35 0.006% 99.790% ( 76, 110 ] 480 0.079% 99.869% ( 110, 170 ] 434 0.071% 99.941% ( 170, 250 ] 136 0.022% 99.963% ( 250, 380 ] 81 0.013% 99.976% ( 380, 580 ] 79 0.013% 99.989% ( 580, 870 ] 22 0.004% 99.993% ( 870, 1300 ] 26 0.004% 99.997% ( 1300, 1900 ] 11 0.002% 99.999% ( 1900, 2900 ] 6 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28241 Average: 2.1686 StdDev: 5.69 Min: 1 Median: 1.4391 Max: 511 Percentiles: P50: 1.44 P75: 1.86 P99: 7.01 P99.9: 12.36 P99.99: 391.73 ------------------------------------------------------ [ 0, 1 ] 6838 24.213% 24.213% ##### ( 1, 2 ] 16586 58.730% 82.943% ############ ( 2, 3 ] 2877 10.187% 93.131% ## ( 3, 4 ] 853 3.020% 96.151% # ( 4, 6 ] 723 2.560% 98.711% # ( 6, 10 ] 323 1.144% 99.855% ( 10, 15 ] 27 0.096% 99.950% ( 15, 22 ] 5 0.018% 99.968% ( 51, 76 ] 1 0.004% 99.972% ( 110, 170 ] 2 0.007% 99.979% ( 170, 250 ] 2 0.007% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 3 0.011% 100.000% ** Level 3 read latency histogram (micros): Count: 225714 Average: 4.4864 StdDev: 54.78 Min: 0 Median: 1.7769 Max: 8292 Percentiles: P50: 1.78 P75: 2.52 P99: 9.70 P99.9: 370.48 P99.99: 1037.01 ------------------------------------------------------ [ 0, 1 ] 10263 4.547% 4.547% # ( 1, 2 ] 132063 58.509% 63.056% ############ ( 2, 3 ] 51494 22.814% 85.870% ##### ( 3, 4 ] 13035 5.775% 91.645% # ( 4, 6 ] 12337 5.466% 97.111% # ( 6, 10 ] 4608 2.042% 99.152% ( 10, 15 ] 684 0.303% 99.455% ( 15, 22 ] 94 0.042% 99.497% ( 22, 34 ] 32 0.014% 99.511% ( 34, 51 ] 2 0.001% 99.512% ( 51, 76 ] 2 0.001% 99.513% ( 76, 110 ] 138 0.061% 99.574% ( 110, 170 ] 414 0.183% 99.757% ( 170, 250 ] 174 0.077% 99.834% ( 250, 380 ] 160 0.071% 99.905% ( 380, 580 ] 125 0.055% 99.961% ( 580, 870 ] 54 0.024% 99.984% ( 870, 1300 ] 32 0.014% 99.999% ( 1300, 1900 ] 15 0.007% 100.005% ( 1900, 2900 ] 4 0.002% 100.007% ( 2900, 4400 ] 11 0.005% 100.012% ( 4400, 6600 ] 11 0.005% 100.017% ( 6600, 9900 ] 1 0.000% 100.017% ** Level 4 read latency histogram (micros): Count: 30 Average: 3668.9000 StdDev: 2168.83 Min: 246 Median: 3800.0000 Max: 8668 Percentiles: P50: 3800.00 P75: 5610.00 P99: 8668.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ ( 170, 250 ] 1 3.333% 3.333% # ( 380, 580 ] 1 3.333% 6.667% # ( 580, 870 ] 1 3.333% 10.000% # ( 1300, 1900 ] 3 10.000% 20.000% ## ( 1900, 2900 ] 6 20.000% 40.000% #### ( 2900, 4400 ] 5 16.667% 56.667% ### ( 4400, 6600 ] 10 33.333% 90.000% ####### ( 6600, 9900 ] 3 10.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 60 Average: 992.8000 StdDev: 1204.20 Min: 82 Median: 380.0000 Max: 5969 Percentiles: P50: 380.00 P75: 1238.57 P99: 5280.00 P99.9: 5969.00 P99.99: 5969.00 ------------------------------------------------------ ( 76, 110 ] 3 5.000% 5.000% # ( 110, 170 ] 5 8.333% 13.333% ## ( 170, 250 ] 12 20.000% 33.333% #### ( 250, 380 ] 10 16.667% 50.000% ### ( 380, 580 ] 4 6.667% 56.667% # ( 580, 870 ] 5 8.333% 65.000% ## ( 870, 1300 ] 7 11.667% 76.667% ## ( 1300, 1900 ] 4 6.667% 83.333% # ( 1900, 2900 ] 2 3.333% 86.667% # ( 2900, 4400 ] 7 11.667% 98.333% ## ( 4400, 6600 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 30.4 total, 10.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 226.84 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:11.443 H:M:S, 37.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 92.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:7.654 H:M:S, 71.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/17-02:33:16 ... thread 0: (1000000,8000000) ops and (148924.7,216983.9) ops/second in (6.714801,36.869095) 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/8 3.62 GB 113.3 7.0 0.0 7.0 14.6 7.7 0.0 1.9 142.2 299.3 50.05 46.74 135 0.371 7227K 11K 0.0 0.0 L1 25/25 2.43 GB 0.0 5.7 3.9 1.8 5.7 3.9 0.1 1.4 222.2 219.8 26.47 25.14 4 6.618 5972K 62K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 1.6 1.8 232.8 232.8 0.48 0.45 1 0.478 112K 37 0.0 0.0 L3 14/0 929.60 MB 0.9 1.4 0.6 0.8 1.4 0.6 1.0 2.3 212.0 211.9 6.90 6.12 4 1.724 1462K 774 0.0 0.0 L4 171/0 9.69 GB 1.0 0.3 0.3 0.0 0.3 0.3 1.2 1.1 178.4 177.9 1.78 1.48 2 0.888 290K 883 0.0 0.0 L5 1060/0 87.11 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1285/33 103.75 GB 0.0 14.5 4.9 9.7 22.2 12.5 5.1 2.9 173.8 264.8 85.67 79.92 146 0.587 15M 75K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.5 4.9 9.7 22.2 12.5 5.1 2.9 173.8 264.8 85.67 79.92 146 0.587 15M 75K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.5 4.9 9.7 14.5 4.8 0.0 0.0 236.1 234.9 63.07 59.90 34 1.855 15M 75K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.7 7.7 0.0 0.0 0.0 348.4 22.60 20.02 112 0.202 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): 37.1 total, 36.9 interval Flush(GB): cumulative 7.690, interval 7.690 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.16 GB write, 611.76 MB/s write, 14.54 GB read, 401.47 MB/s read, 85.7 seconds Interval compaction: 22.16 GB write, 615.33 MB/s write, 14.54 GB read, 403.81 MB/s read, 85.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 24, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 30, total-stops: 24, interval: 54 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3145627 Average: 2.6270 StdDev: 14.40 Min: 0 Median: 1.5931 Max: 3831 Percentiles: P50: 1.59 P75: 1.97 P99: 6.37 P99.9: 97.07 P99.99: 193.52 ------------------------------------------------------ [ 0, 1 ] 345637 10.988% 10.988% ## ( 1, 2 ] 2069114 65.777% 76.765% ############# ( 2, 3 ] 515673 16.393% 93.159% ### ( 3, 4 ] 99505 3.163% 96.322% # ( 4, 6 ] 81917 2.604% 98.926% # ( 6, 10 ] 25097 0.798% 99.724% ( 10, 15 ] 4111 0.131% 99.855% ( 15, 22 ] 408 0.013% 99.868% ( 22, 34 ] 36 0.001% 99.869% ( 34, 51 ] 14 0.000% 99.869% ( 51, 76 ] 16 0.001% 99.870% ( 76, 110 ] 1540 0.049% 99.919% ( 110, 170 ] 2052 0.065% 99.984% ( 170, 250 ] 658 0.021% 100.005% ( 250, 380 ] 396 0.013% 100.017% ( 380, 580 ] 328 0.010% 100.028% ( 580, 870 ] 172 0.005% 100.033% ( 870, 1300 ] 76 0.002% 100.036% ( 1300, 1900 ] 22 0.001% 100.036% ( 1900, 2900 ] 21 0.001% 100.037% ( 2900, 4400 ] 11 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 753168 Average: 2.6374 StdDev: 13.88 Min: 0 Median: 1.5623 Max: 2474 Percentiles: P50: 1.56 P75: 1.95 P99: 7.55 P99.9: 129.23 P99.99: 557.28 ------------------------------------------------------ [ 0, 1 ] 103793 13.781% 13.781% ### ( 1, 2 ] 485152 64.415% 78.196% ############# ( 2, 3 ] 109096 14.485% 92.681% ### ( 3, 4 ] 22672 3.010% 95.691% # ( 4, 6 ] 21796 2.894% 98.585% # ( 6, 10 ] 8093 1.075% 99.659% ( 10, 15 ] 853 0.113% 99.773% ( 15, 22 ] 137 0.018% 99.791% ( 22, 34 ] 5 0.001% 99.791% ( 34, 51 ] 4 0.001% 99.792% ( 51, 76 ] 42 0.006% 99.798% ( 76, 110 ] 603 0.080% 99.878% ( 110, 170 ] 530 0.070% 99.948% ( 170, 250 ] 155 0.021% 99.969% ( 250, 380 ] 90 0.012% 99.980% ( 380, 580 ] 82 0.011% 99.991% ( 580, 870 ] 23 0.003% 99.994% ( 870, 1300 ] 26 0.003% 99.998% ( 1300, 1900 ] 11 0.001% 99.999% ( 1900, 2900 ] 6 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 28241 Average: 2.1686 StdDev: 5.69 Min: 1 Median: 1.4391 Max: 511 Percentiles: P50: 1.44 P75: 1.86 P99: 7.01 P99.9: 12.36 P99.99: 391.73 ------------------------------------------------------ [ 0, 1 ] 6838 24.213% 24.213% ##### ( 1, 2 ] 16586 58.730% 82.943% ############ ( 2, 3 ] 2877 10.187% 93.131% ## ( 3, 4 ] 853 3.020% 96.151% # ( 4, 6 ] 723 2.560% 98.711% # ( 6, 10 ] 323 1.144% 99.855% ( 10, 15 ] 27 0.096% 99.950% ( 15, 22 ] 5 0.018% 99.968% ( 51, 76 ] 1 0.004% 99.972% ( 110, 170 ] 2 0.007% 99.979% ( 170, 250 ] 2 0.007% 99.986% ( 250, 380 ] 1 0.004% 99.989% ( 380, 580 ] 3 0.011% 100.000% ** Level 3 read latency histogram (micros): Count: 260360 Average: 4.3290 StdDev: 51.49 Min: 0 Median: 1.7814 Max: 8292 Percentiles: P50: 1.78 P75: 2.52 P99: 9.60 P99.9: 357.19 P99.99: 960.74 ------------------------------------------------------ [ 0, 1 ] 11384 4.372% 4.372% # ( 1, 2 ] 152036 58.395% 62.767% ############ ( 2, 3 ] 61113 23.472% 86.239% ##### ( 3, 4 ] 14586 5.602% 91.842% # ( 4, 6 ] 13833 5.313% 97.155% # ( 6, 10 ] 5342 2.052% 99.206% ( 10, 15 ] 758 0.291% 99.498% ( 15, 22 ] 102 0.039% 99.537% ( 22, 34 ] 32 0.012% 99.549% ( 34, 51 ] 2 0.001% 99.550% ( 51, 76 ] 2 0.001% 99.551% ( 76, 110 ] 140 0.054% 99.604% ( 110, 170 ] 432 0.166% 99.770% ( 170, 250 ] 195 0.075% 99.845% ( 250, 380 ] 173 0.066% 99.912% ( 380, 580 ] 137 0.053% 99.964% ( 580, 870 ] 60 0.023% 99.987% ( 870, 1300 ] 33 0.013% 100.000% ( 1300, 1900 ] 15 0.006% 100.006% ( 1900, 2900 ] 5 0.002% 100.008% ( 2900, 4400 ] 11 0.004% 100.012% ( 4400, 6600 ] 11 0.004% 100.016% ( 6600, 9900 ] 1 0.000% 100.017% ** Level 4 read latency histogram (micros): Count: 135 Average: 846.9185 StdDev: 1826.06 Min: 1 Median: 3.5000 Max: 8668 Percentiles: P50: 3.50 P75: 266.25 P99: 8415.00 P99.9: 8668.00 P99.99: 8668.00 ------------------------------------------------------ [ 0, 1 ] 30 22.222% 22.222% #### ( 1, 2 ] 33 24.444% 46.667% ##### ( 2, 3 ] 4 2.963% 49.630% # ( 3, 4 ] 1 0.741% 50.370% ( 4, 6 ] 5 3.704% 54.074% # ( 6, 10 ] 6 4.444% 58.519% # ( 22, 34 ] 12 8.889% 67.407% ## ( 34, 51 ] 4 2.963% 70.370% # ( 110, 170 ] 1 0.741% 71.111% ( 170, 250 ] 5 3.704% 74.815% # ( 250, 380 ] 2 1.481% 76.296% ( 380, 580 ] 3 2.222% 78.519% ( 580, 870 ] 1 0.741% 79.259% ( 870, 1300 ] 1 0.741% 80.000% ( 1300, 1900 ] 3 2.222% 82.222% ( 1900, 2900 ] 6 4.444% 86.667% # ( 2900, 4400 ] 5 3.704% 90.370% # ( 4400, 6600 ] 10 7.407% 97.778% # ( 6600, 9900 ] 3 2.222% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 980.7875 StdDev: 1197.76 Min: 82 Median: 380.0000 Max: 5969 Percentiles: P50: 380.00 P75: 1300.00 P99: 5720.00 P99.9: 5969.00 P99.99: 5969.00 ------------------------------------------------------ ( 76, 110 ] 6 7.500% 7.500% ## ( 110, 170 ] 10 12.500% 20.000% ### ( 170, 250 ] 14 17.500% 37.500% #### ( 250, 380 ] 10 12.500% 50.000% ### ( 380, 580 ] 5 6.250% 56.250% # ( 580, 870 ] 8 10.000% 66.250% ## ( 870, 1300 ] 7 8.750% 75.000% ## ( 1300, 1900 ] 7 8.750% 83.750% ## ( 1900, 2900 ] 3 3.750% 87.500% # ( 2900, 4400 ] 8 10.000% 97.500% ## ( 4400, 6600 ] 2 2.500% 100.000% # ** DB Stats ** Uptime(secs): 37.1 total, 6.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 212.30 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.338 H:M:S, 41.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 146.55 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:3.895 H:M:S, 58.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 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.790 micros/op 147284 ops/sec 60.393 seconds 8894999 operations; 142.7 MB/s Microseconds per write: Count: 8894999 Average: 6.7896 StdDev: 594.09 Min: 0 Median: 1.7330 Max: 894414 Percentiles: P50: 1.73 P75: 2.75 P99: 9.96 P99.9: 1213.13 P99.99: 2750.88 ------------------------------------------------------ [ 0, 1 ] 1250811 14.062% 14.062% ### ( 1, 2 ] 4361120 49.029% 63.091% ########## ( 2, 3 ] 1408133 15.831% 78.921% ### ( 3, 4 ] 1190205 13.381% 92.302% ### ( 4, 6 ] 469791 5.282% 97.584% # ( 6, 10 ] 127318 1.431% 99.015% ( 10, 15 ] 45693 0.514% 99.529% ( 15, 22 ] 9253 0.104% 99.633% ( 22, 34 ] 1332 0.015% 99.648% ( 34, 51 ] 223 0.003% 99.650% ( 51, 76 ] 31 0.000% 99.650% ( 76, 110 ] 6336 0.071% 99.722% ( 110, 170 ] 2254 0.025% 99.747% ( 170, 250 ] 234 0.003% 99.750% ( 250, 380 ] 197 0.002% 99.752% ( 380, 580 ] 18 0.000% 99.752% ( 580, 870 ] 14 0.000% 99.752% ( 870, 1300 ] 16468 0.185% 99.937% ( 1300, 1900 ] 31 0.000% 99.938% ( 1900, 2900 ] 5462 0.061% 99.999% ( 2900, 4400 ] 41 0.000% 100.000% ( 4400, 6600 ] 3 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 3 0.000% 100.000% ( 170000, 250000 ] 10 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% ( 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 : 217353 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 : 489 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 35597885 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 : 29777742207 rocksdb.compact.write.bytes COUNT : 29548522608 rocksdb.flush.write.bytes COUNT : 9115650834 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 : 26 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 : 249 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 : 9042424832 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3776512 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 : 29851620736 rocksdb.non.last.level.read.count COUNT : 7215044 rocksdb.block.checksum.compute.count COUNT : 7214092 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.382513 P95 : 3.960810 P99 : 8.747087 P100 : 894411.000000 COUNT : 8894999 SUM : 56205408 rocksdb.compaction.times.micros P50 : 1256000.000000 P95 : 4740000.000000 P99 : 23871976.000000 P100 : 23871976.000000 COUNT : 76 SUM : 146287817 rocksdb.compaction.times.cpu_micros P50 : 884285.714286 P95 : 4740000.000000 P99 : 18960000.000000 P100 : 21482208.000000 COUNT : 76 SUM : 114960484 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 : 689.919355 P95 : 9735.000000 P99 : 301350.000000 P100 : 314419.000000 COUNT : 121 SUM : 718466 rocksdb.compaction.outfile.sync.micros P50 : 962.615385 P95 : 224857.142857 P99 : 415466.666667 P100 : 965132.000000 COUNT : 344 SUM : 10072069 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 : 103.544304 P95 : 3068.750000 P99 : 5705.333333 P100 : 8130.000000 COUNT : 222 SUM : 111278 rocksdb.table.open.io.micros P50 : 1563.855422 P95 : 6765.000000 P99 : 19431.111111 P100 : 22259.000000 COUNT : 489 SUM : 1122132 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.763263 P95 : 8.204508 P99 : 12.889886 P100 : 12289.000000 COUNT : 7212970 SUM : 51719827 rocksdb.read.block.get.micros P50 : 494.285714 P95 : 3789.772727 P99 : 6429.739130 P100 : 8728.000000 COUNT : 978 SUM : 926123 rocksdb.write.raw.block.micros P50 : 0.515199 P95 : 0.978878 P99 : 2.905450 P100 : 17255.000000 COUNT : 9367293 SUM : 20526450 rocksdb.numfiles.in.singlecompaction P50 : 3.240000 P95 : 5.600000 P99 : 26.080000 P100 : 33.000000 COUNT : 132 SUM : 527 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.569039 P95 : 1205.902750 P99 : 2571.900129 P100 : 894229.000000 COUNT : 181816 SUM : 35619469 rocksdb.sst.read.micros P50 : 1.689280 P95 : 4.954503 P99 : 9.352847 P100 : 12285.000000 COUNT : 7215607 SUM : 36791614 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 : 215777.777778 P95 : 503500.000000 P99 : 994300.000000 P100 : 1048162.000000 COUNT : 121 SUM : 28636096 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 : 330 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