[2024-11-29 11:16:58.709947] Starting SPDK v25.01-pre git sha1 35cd3e84d / DPDK 22.11.4 initialization... [2024-11-29 11:16:58.710062] [ 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_pid473816 ] Set seed to 1732875418707395 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-29 11:16:58.804584] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-29 11:16:58.828589] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-29 11:16:58.828633] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 473816' to capture a snapshot of events at runtime. [2024-11-29 11:16:58.828645] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-29 11:16:58.828671] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-29 11:16:58.828679] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid473816 for offline analysis/debug. [2024-11-29 11:16:58.829239] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Nov 29 11:17:03 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/29-11:17:05 ... thread 0: (1000000,1000000) ops and (356309.2,356309.2) ops/second in (2.806551,2.806551) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/9 630.04 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 348.8 2.35 2.11 12 0.196 0 0 0.0 0.0 L2 3/2 236.96 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 250.5 250.3 1.39 1.35 2 0.695 353K 192 0.0 0.0 L3 8/0 629.94 MB 0.6 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 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/11 96.94 GB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 93.2 312.2 3.74 3.46 14 0.267 353K 192 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 93.2 312.2 3.74 3.46 14 0.267 353K 192 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.3 0.2 0.2 0.3 0.2 0.0 0.0 250.5 250.3 1.39 1.35 2 0.695 353K 192 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 348.8 2.35 2.11 12 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): 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.14 GB write, 389.58 MB/s write, 0.34 GB read, 116.27 MB/s read, 3.7 seconds Interval compaction: 1.14 GB write, 415.64 MB/s write, 0.34 GB read, 124.05 MB/s read, 3.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: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 122211 Average: 2.0448 StdDev: 14.74 Min: 0 Median: 1.3458 Max: 2789 Percentiles: P50: 1.35 P75: 1.77 P99: 5.49 P99.9: 11.41 P99.99: 33.56 ------------------------------------------------------ [ 0, 1 ] 36131 29.564% 29.564% ###### ( 1, 2 ] 72228 59.101% 88.666% ############ ( 2, 3 ] 7969 6.521% 95.186% # ( 3, 4 ] 3115 2.549% 97.735% # ( 4, 6 ] 2077 1.700% 99.435% ( 6, 10 ] 537 0.439% 99.874% ( 10, 15 ] 120 0.098% 99.972% ( 15, 22 ] 18 0.015% 99.987% ( 22, 34 ] 6 0.005% 99.992% ( 34, 51 ] 2 0.002% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 110, 170 ] 8 0.007% 100.001% ( 170, 250 ] 4 0.003% 100.004% ( 250, 380 ] 5 0.004% 100.008% ( 580, 870 ] 2 0.002% 100.010% ( 1300, 1900 ] 2 0.002% 100.011% ( 1900, 2900 ] 3 0.002% 100.014% ** Level 1 read latency histogram (micros): Count: 12250 Average: 2.8738 StdDev: 32.96 Min: 1 Median: 1.2763 Max: 2430 Percentiles: P50: 1.28 P75: 1.74 P99: 9.07 P99.9: 214.00 P99.99: 2287.50 ------------------------------------------------------ [ 0, 1 ] 4308 35.167% 35.167% ####### ( 1, 2 ] 6575 53.673% 88.841% ########### ( 2, 3 ] 865 7.061% 95.902% # ( 3, 4 ] 120 0.980% 96.882% ( 4, 6 ] 169 1.380% 98.261% ( 6, 10 ] 118 0.963% 99.224% ( 10, 15 ] 19 0.155% 99.380% ( 15, 22 ] 6 0.049% 99.429% ( 34, 51 ] 24 0.196% 99.624% ( 51, 76 ] 24 0.196% 99.820% ( 76, 110 ] 5 0.041% 99.861% ( 110, 170 ] 2 0.016% 99.878% ( 170, 250 ] 5 0.041% 99.918% ( 250, 380 ] 2 0.016% 99.935% ( 380, 580 ] 6 0.049% 99.984% ( 1900, 2900 ] 2 0.016% 100.000% ** Level 2 read latency histogram (micros): Count: 58159 Average: 2.0044 StdDev: 5.04 Min: 0 Median: 1.3699 Max: 854 Percentiles: P50: 1.37 P75: 1.78 P99: 5.61 P99.9: 10.42 P99.99: 217.36 ------------------------------------------------------ [ 0, 1 ] 16120 27.717% 27.717% ###### ( 1, 2 ] 35034 60.238% 87.955% ############ ( 2, 3 ] 3856 6.630% 94.586% # ( 3, 4 ] 1629 2.801% 97.386% # ( 4, 6 ] 1165 2.003% 99.390% ( 6, 10 ] 294 0.506% 99.895% ( 10, 15 ] 46 0.079% 99.974% ( 15, 22 ] 2 0.003% 99.978% ( 22, 34 ] 2 0.003% 99.981% ( 51, 76 ] 2 0.003% 99.985% ( 110, 170 ] 3 0.005% 99.990% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 3 0.005% 99.998% ( 380, 580 ] 1 0.002% 100.000% ( 580, 870 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 40 Average: 1846.3250 StdDev: 1636.93 Min: 348 Median: 797.5000 Max: 5370 Percentiles: P50: 797.50 P75: 3328.57 P99: 5370.00 P99.9: 5370.00 P99.99: 5370.00 ------------------------------------------------------ ( 250, 380 ] 2 5.000% 5.000% # ( 380, 580 ] 12 30.000% 35.000% ###### ( 580, 870 ] 8 20.000% 55.000% #### ( 870, 1300 ] 1 2.500% 57.500% # ( 1300, 1900 ] 1 2.500% 60.000% # ( 1900, 2900 ] 4 10.000% 70.000% ## ( 2900, 4400 ] 7 17.500% 87.500% #### ( 4400, 6600 ] 5 12.500% 100.000% ### ** Level 4 read latency histogram (micros): Count: 35 Average: 1850.6286 StdDev: 1584.91 Min: 211 Median: 1246.2500 Max: 6234 Percentiles: P50: 1246.25 P75: 2712.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ ( 170, 250 ] 1 2.857% 2.857% # ( 250, 380 ] 1 2.857% 5.714% # ( 380, 580 ] 5 14.286% 20.000% ### ( 580, 870 ] 7 20.000% 40.000% #### ( 870, 1300 ] 4 11.429% 51.429% ## ( 1300, 1900 ] 5 14.286% 65.714% ### ( 1900, 2900 ] 4 11.429% 77.143% ## ( 2900, 4400 ] 5 14.286% 91.429% ### ( 4400, 6600 ] 3 8.571% 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, 328.49 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.199 H:M:S, 6.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.37 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.199 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/29-11:17:08 ... thread 0: (1000000,2000000) ops and (327974.2,341555.1) ops/second in (3.049020,5.855571) 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/7 1.29 GB 18.9 0.8 0.0 0.8 2.6 1.8 0.0 1.4 98.3 317.6 8.33 7.74 29 0.287 831K 844 0.0 0.0 L1 1/1 2.17 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.0 239.7 1.31 1.27 1 1.313 319K 381 0.0 0.0 L2 1/0 49.42 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 250.5 250.3 1.39 1.35 2 0.695 353K 192 0.0 0.0 L3 40/0 973.06 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 198.1 197.9 3.47 3.01 3 1.157 698K 654 0.0 0.0 L4 136/0 9.75 GB 1.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 L5 1044/0 85.88 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 1232/8 97.92 GB 0.0 2.1 1.0 1.1 3.9 2.8 0.7 2.2 149.6 275.4 14.50 13.38 35 0.414 2203K 2071 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.0 1.1 3.9 2.8 0.6 2.2 149.6 275.4 14.50 13.38 35 0.414 2203K 2071 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.1 1.0 1.1 2.1 1.0 0.0 0.0 233.7 233.4 9.29 8.70 9 1.032 2203K 2071 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 350.2 5.22 4.68 26 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): 6.0 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.90 GB write, 660.84 MB/s write, 2.12 GB read, 358.97 MB/s read, 14.5 seconds Interval compaction: 3.90 GB write, 682.04 MB/s write, 2.12 GB read, 370.49 MB/s read, 14.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 373463 Average: 2.1287 StdDev: 13.02 Min: 0 Median: 1.4291 Max: 3146 Percentiles: P50: 1.43 P75: 1.83 P99: 5.61 P99.9: 11.34 P99.99: 20.44 ------------------------------------------------------ [ 0, 1 ] 86089 23.052% 23.052% ##### ( 1, 2 ] 234527 62.798% 85.849% ############# ( 2, 3 ] 31156 8.342% 94.192% ## ( 3, 4 ] 11750 3.146% 97.338% # ( 4, 6 ] 7699 2.062% 99.400% ( 6, 10 ] 1757 0.470% 99.870% ( 10, 15 ] 415 0.111% 99.981% ( 15, 22 ] 42 0.011% 99.993% ( 22, 34 ] 10 0.003% 99.995% ( 34, 51 ] 4 0.001% 99.996% ( 51, 76 ] 3 0.001% 99.997% ( 110, 170 ] 13 0.003% 100.001% ( 170, 250 ] 11 0.003% 100.003% ( 250, 380 ] 13 0.003% 100.007% ( 380, 580 ] 2 0.001% 100.007% ( 580, 870 ] 6 0.002% 100.009% ( 870, 1300 ] 3 0.001% 100.010% ( 1300, 1900 ] 3 0.001% 100.011% ( 1900, 2900 ] 5 0.001% 100.012% ( 2900, 4400 ] 2 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 91574 Average: 2.4247 StdDev: 12.67 Min: 1 Median: 1.5761 Max: 2430 Percentiles: P50: 1.58 P75: 1.96 P99: 5.99 P99.9: 14.67 P99.99: 247.48 ------------------------------------------------------ [ 0, 1 ] 11408 12.458% 12.458% ## ( 1, 2 ] 59678 65.169% 77.627% ############# ( 2, 3 ] 12910 14.098% 91.725% ### ( 3, 4 ] 3782 4.130% 95.855% # ( 4, 6 ] 2896 3.162% 99.017% # ( 6, 10 ] 689 0.752% 99.770% ( 10, 15 ] 128 0.140% 99.909% ( 15, 22 ] 12 0.013% 99.922% ( 34, 51 ] 25 0.027% 99.950% ( 51, 76 ] 25 0.027% 99.977% ( 76, 110 ] 5 0.005% 99.983% ( 110, 170 ] 2 0.002% 99.985% ( 170, 250 ] 5 0.005% 99.990% ( 250, 380 ] 6 0.007% 99.997% ( 380, 580 ] 6 0.007% 100.003% ( 580, 870 ] 2 0.002% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75863 Average: 2.0985 StdDev: 4.45 Min: 0 Median: 1.4412 Max: 854 Percentiles: P50: 1.44 P75: 1.85 P99: 5.77 P99.9: 11.01 P99.99: 158.27 ------------------------------------------------------ [ 0, 1 ] 17348 22.868% 22.868% ##### ( 1, 2 ] 46658 61.503% 84.371% ############ ( 2, 3 ] 6870 9.056% 93.426% ## ( 3, 4 ] 2500 3.295% 96.722% # ( 4, 6 ] 1957 2.580% 99.301% # ( 6, 10 ] 439 0.579% 99.880% ( 10, 15 ] 75 0.099% 99.979% ( 15, 22 ] 2 0.003% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 51, 76 ] 2 0.003% 99.987% ( 110, 170 ] 3 0.004% 99.991% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 3 0.004% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47958 Average: 3.9759 StdDev: 71.80 Min: 0 Median: 1.5925 Max: 5370 Percentiles: P50: 1.59 P75: 1.97 P99: 6.36 P99.9: 277.09 P99.99: 4489.85 ------------------------------------------------------ [ 0, 1 ] 5112 10.659% 10.659% ## ( 1, 2 ] 31845 66.402% 77.061% ############# ( 2, 3 ] 6797 14.173% 91.234% ### ( 3, 4 ] 2139 4.460% 95.694% # ( 4, 6 ] 1554 3.240% 98.934% # ( 6, 10 ] 352 0.734% 99.668% ( 10, 15 ] 55 0.115% 99.783% ( 15, 22 ] 9 0.019% 99.802% ( 22, 34 ] 38 0.079% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 5 0.010% 99.896% ( 170, 250 ] 1 0.002% 99.898% ( 250, 380 ] 5 0.010% 99.908% ( 380, 580 ] 13 0.027% 99.935% ( 580, 870 ] 12 0.025% 99.960% ( 870, 1300 ] 2 0.004% 99.965% ( 1300, 1900 ] 1 0.002% 99.967% ( 1900, 2900 ] 4 0.008% 99.975% ( 2900, 4400 ] 7 0.015% 99.990% ( 4400, 6600 ] 5 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1850.6286 StdDev: 1584.91 Min: 211 Median: 1246.2500 Max: 6234 Percentiles: P50: 1246.25 P75: 2712.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ ( 170, 250 ] 1 2.857% 2.857% # ( 250, 380 ] 1 2.857% 5.714% # ( 380, 580 ] 5 14.286% 20.000% ### ( 580, 870 ] 7 20.000% 40.000% #### ( 870, 1300 ] 4 11.429% 51.429% ## ( 1300, 1900 ] 5 14.286% 65.714% ### ( 1900, 2900 ] 4 11.429% 77.143% ## ( 2900, 4400 ] 5 14.286% 91.429% ### ( 4400, 6600 ] 3 8.571% 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, 325.61 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.622 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.79 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.423 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-11:17:11 ... thread 0: (1000000,3000000) ops and (330834.5,337905.2) ops/second in (3.022659,8.878230) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/11 2.27 GB 88.1 1.6 0.0 1.6 4.4 2.8 0.0 1.6 115.2 314.4 14.22 13.29 46 0.309 1663K 1719 0.0 0.0 L1 1/1 2.17 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.0 239.7 1.31 1.27 1 1.313 319K 381 0.0 0.0 L2 1/0 49.42 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 250.5 250.3 1.39 1.35 2 0.695 353K 192 0.0 0.0 L3 40/0 973.06 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 198.1 197.9 3.47 3.01 3 1.157 698K 654 0.0 0.0 L4 136/0 9.75 GB 1.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 L5 1044/0 85.88 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 1237/12 98.90 GB 0.0 2.9 1.0 1.9 5.7 3.7 0.7 2.1 146.5 285.4 20.40 18.92 52 0.392 3034K 2946 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.0 1.9 5.7 3.7 0.6 2.1 146.5 285.4 20.40 18.92 52 0.392 3034K 2946 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.9 1.0 1.9 2.9 1.0 0.0 0.0 241.0 240.8 12.40 11.75 12 1.033 3034K 2946 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 354.6 7.99 7.17 40 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.68 GB write, 641.92 MB/s write, 2.92 GB read, 329.62 MB/s read, 20.4 seconds Interval compaction: 5.68 GB write, 655.50 MB/s write, 2.92 GB read, 336.60 MB/s read, 20.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: 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: 775715 Average: 2.1443 StdDev: 10.33 Min: 0 Median: 1.4700 Max: 3146 Percentiles: P50: 1.47 P75: 1.85 P99: 5.53 P99.9: 9.94 P99.99: 14.28 ------------------------------------------------------ [ 0, 1 ] 149138 19.226% 19.226% #### ( 1, 2 ] 507887 65.473% 84.699% ############# ( 2, 3 ] 73271 9.446% 94.145% ## ( 3, 4 ] 25987 3.350% 97.495% # ( 4, 6 ] 15301 1.973% 99.467% ( 6, 10 ] 3410 0.440% 99.907% ( 10, 15 ] 752 0.097% 100.004% ( 15, 22 ] 81 0.010% 100.014% ( 22, 34 ] 14 0.002% 100.016% ( 34, 51 ] 6 0.001% 100.017% ( 51, 76 ] 7 0.001% 100.018% ( 110, 170 ] 18 0.002% 100.020% ( 170, 250 ] 20 0.003% 100.023% ( 250, 380 ] 20 0.003% 100.025% ( 380, 580 ] 5 0.001% 100.026% ( 580, 870 ] 10 0.001% 100.027% ( 870, 1300 ] 8 0.001% 100.028% ( 1300, 1900 ] 3 0.000% 100.029% ( 1900, 2900 ] 7 0.001% 100.030% ( 2900, 4400 ] 2 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 91574 Average: 2.4247 StdDev: 12.67 Min: 1 Median: 1.5761 Max: 2430 Percentiles: P50: 1.58 P75: 1.96 P99: 5.99 P99.9: 14.67 P99.99: 247.48 ------------------------------------------------------ [ 0, 1 ] 11408 12.458% 12.458% ## ( 1, 2 ] 59678 65.169% 77.627% ############# ( 2, 3 ] 12910 14.098% 91.725% ### ( 3, 4 ] 3782 4.130% 95.855% # ( 4, 6 ] 2896 3.162% 99.017% # ( 6, 10 ] 689 0.752% 99.770% ( 10, 15 ] 128 0.140% 99.909% ( 15, 22 ] 12 0.013% 99.922% ( 34, 51 ] 25 0.027% 99.950% ( 51, 76 ] 25 0.027% 99.977% ( 76, 110 ] 5 0.005% 99.983% ( 110, 170 ] 2 0.002% 99.985% ( 170, 250 ] 5 0.005% 99.990% ( 250, 380 ] 6 0.007% 99.997% ( 380, 580 ] 6 0.007% 100.003% ( 580, 870 ] 2 0.002% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75863 Average: 2.0985 StdDev: 4.45 Min: 0 Median: 1.4412 Max: 854 Percentiles: P50: 1.44 P75: 1.85 P99: 5.77 P99.9: 11.01 P99.99: 158.27 ------------------------------------------------------ [ 0, 1 ] 17348 22.868% 22.868% ##### ( 1, 2 ] 46658 61.503% 84.371% ############ ( 2, 3 ] 6870 9.056% 93.426% ## ( 3, 4 ] 2500 3.295% 96.722% # ( 4, 6 ] 1957 2.580% 99.301% # ( 6, 10 ] 439 0.579% 99.880% ( 10, 15 ] 75 0.099% 99.979% ( 15, 22 ] 2 0.003% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 51, 76 ] 2 0.003% 99.987% ( 110, 170 ] 3 0.004% 99.991% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 3 0.004% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47958 Average: 3.9759 StdDev: 71.80 Min: 0 Median: 1.5925 Max: 5370 Percentiles: P50: 1.59 P75: 1.97 P99: 6.36 P99.9: 277.09 P99.99: 4489.85 ------------------------------------------------------ [ 0, 1 ] 5112 10.659% 10.659% ## ( 1, 2 ] 31845 66.402% 77.061% ############# ( 2, 3 ] 6797 14.173% 91.234% ### ( 3, 4 ] 2139 4.460% 95.694% # ( 4, 6 ] 1554 3.240% 98.934% # ( 6, 10 ] 352 0.734% 99.668% ( 10, 15 ] 55 0.115% 99.783% ( 15, 22 ] 9 0.019% 99.802% ( 22, 34 ] 38 0.079% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 5 0.010% 99.896% ( 170, 250 ] 1 0.002% 99.898% ( 250, 380 ] 5 0.010% 99.908% ( 380, 580 ] 13 0.027% 99.935% ( 580, 870 ] 12 0.025% 99.960% ( 870, 1300 ] 2 0.004% 99.965% ( 1300, 1900 ] 1 0.002% 99.967% ( 1900, 2900 ] 4 0.008% 99.975% ( 2900, 4400 ] 7 0.015% 99.990% ( 4400, 6600 ] 5 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1850.6286 StdDev: 1584.91 Min: 211 Median: 1246.2500 Max: 6234 Percentiles: P50: 1246.25 P75: 2712.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ ( 170, 250 ] 1 2.857% 2.857% # ( 250, 380 ] 1 2.857% 5.714% # ( 380, 580 ] 5 14.286% 20.000% ### ( 580, 870 ] 7 20.000% 40.000% #### ( 870, 1300 ] 4 11.429% 51.429% ## ( 1300, 1900 ] 5 14.286% 65.714% ### ( 1900, 2900 ] 4 11.429% 77.143% ## ( 2900, 4400 ] 5 14.286% 91.429% ### ( 4400, 6600 ] 3 8.571% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 325.61 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.016 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.60 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.394 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-11:17:14 ... thread 0: (1000000,4000000) ops and (336941.6,337663.8) ops/second in (2.967873,11.846103) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/4 2.09 GB 182.5 2.5 0.0 2.5 6.1 3.7 0.0 1.7 125.0 312.4 20.16 18.88 62 0.325 2558K 2671 0.0 0.0 L1 11/0 1.10 GB 113.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 233.3 232.3 6.22 6.04 2 3.109 1472K 5714 0.0 0.0 L2 1/0 49.42 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 250.5 250.3 1.39 1.35 2 0.695 353K 192 0.0 0.0 L3 40/0 973.06 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 198.1 197.9 3.47 3.01 3 1.157 698K 654 0.0 0.0 L4 136/0 9.75 GB 1.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 L5 1044/0 85.88 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 1244/4 99.82 GB 0.0 4.9 2.1 2.8 8.6 5.8 0.7 2.3 160.3 281.0 31.24 29.28 69 0.453 5083K 9231 0.0 0.0 Int 0/0 0.00 KB 0.0 4.9 2.1 2.8 8.6 5.8 0.6 2.3 160.3 281.0 31.24 29.28 69 0.453 5083K 9231 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.9 2.1 2.8 4.9 2.1 0.0 0.0 242.9 242.4 20.61 19.76 16 1.288 5083K 9231 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 355.6 10.63 9.52 53 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): 12.0 total, 11.8 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.57 GB write, 729.19 MB/s write, 4.89 GB read, 415.94 MB/s read, 31.2 seconds Interval compaction: 8.57 GB write, 740.76 MB/s write, 4.89 GB read, 422.54 MB/s read, 31.2 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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1091675 Average: 2.1250 StdDev: 11.74 Min: 0 Median: 1.4579 Max: 4391 Percentiles: P50: 1.46 P75: 1.84 P99: 5.41 P99.9: 9.87 P99.99: 14.23 ------------------------------------------------------ [ 0, 1 ] 217850 19.956% 19.956% #### ( 1, 2 ] 716316 65.616% 85.572% ############# ( 2, 3 ] 98531 9.026% 94.597% ## ( 3, 4 ] 34519 3.162% 97.759% # ( 4, 6 ] 19242 1.763% 99.522% ( 6, 10 ] 4259 0.390% 99.912% ( 10, 15 ] 1003 0.092% 100.004% ( 15, 22 ] 106 0.010% 100.014% ( 22, 34 ] 15 0.001% 100.015% ( 34, 51 ] 6 0.001% 100.016% ( 51, 76 ] 11 0.001% 100.017% ( 110, 170 ] 24 0.002% 100.019% ( 170, 250 ] 23 0.002% 100.021% ( 250, 380 ] 25 0.002% 100.023% ( 380, 580 ] 8 0.001% 100.024% ( 580, 870 ] 14 0.001% 100.025% ( 870, 1300 ] 10 0.001% 100.026% ( 1300, 1900 ] 7 0.001% 100.027% ( 1900, 2900 ] 10 0.001% 100.028% ( 2900, 4400 ] 4 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 92178 Average: 2.5650 StdDev: 17.24 Min: 0 Median: 1.5750 Max: 2430 Percentiles: P50: 1.57 P75: 1.96 P99: 6.00 P99.9: 21.90 P99.99: 509.70 ------------------------------------------------------ [ 0, 1 ] 11547 12.527% 12.527% ### ( 1, 2 ] 60074 65.172% 77.699% ############# ( 2, 3 ] 12939 14.037% 91.736% ### ( 3, 4 ] 3792 4.114% 95.849% # ( 4, 6 ] 2904 3.150% 99.000% # ( 6, 10 ] 690 0.749% 99.748% ( 10, 15 ] 128 0.139% 99.887% ( 15, 22 ] 12 0.013% 99.900% ( 22, 34 ] 1 0.001% 99.901% ( 34, 51 ] 25 0.027% 99.928% ( 51, 76 ] 25 0.027% 99.956% ( 76, 110 ] 5 0.005% 99.961% ( 110, 170 ] 3 0.003% 99.964% ( 170, 250 ] 6 0.007% 99.971% ( 250, 380 ] 10 0.011% 99.982% ( 380, 580 ] 12 0.013% 99.995% ( 580, 870 ] 6 0.007% 100.001% ( 1300, 1900 ] 4 0.004% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75863 Average: 2.0985 StdDev: 4.45 Min: 0 Median: 1.4412 Max: 854 Percentiles: P50: 1.44 P75: 1.85 P99: 5.77 P99.9: 11.01 P99.99: 158.27 ------------------------------------------------------ [ 0, 1 ] 17348 22.868% 22.868% ##### ( 1, 2 ] 46658 61.503% 84.371% ############ ( 2, 3 ] 6870 9.056% 93.426% ## ( 3, 4 ] 2500 3.295% 96.722% # ( 4, 6 ] 1957 2.580% 99.301% # ( 6, 10 ] 439 0.579% 99.880% ( 10, 15 ] 75 0.099% 99.979% ( 15, 22 ] 2 0.003% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 51, 76 ] 2 0.003% 99.987% ( 110, 170 ] 3 0.004% 99.991% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 3 0.004% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47958 Average: 3.9759 StdDev: 71.80 Min: 0 Median: 1.5925 Max: 5370 Percentiles: P50: 1.59 P75: 1.97 P99: 6.36 P99.9: 277.09 P99.99: 4489.85 ------------------------------------------------------ [ 0, 1 ] 5112 10.659% 10.659% ## ( 1, 2 ] 31845 66.402% 77.061% ############# ( 2, 3 ] 6797 14.173% 91.234% ### ( 3, 4 ] 2139 4.460% 95.694% # ( 4, 6 ] 1554 3.240% 98.934% # ( 6, 10 ] 352 0.734% 99.668% ( 10, 15 ] 55 0.115% 99.783% ( 15, 22 ] 9 0.019% 99.802% ( 22, 34 ] 38 0.079% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 5 0.010% 99.896% ( 170, 250 ] 1 0.002% 99.898% ( 250, 380 ] 5 0.010% 99.908% ( 380, 580 ] 13 0.027% 99.935% ( 580, 870 ] 12 0.025% 99.960% ( 870, 1300 ] 2 0.004% 99.965% ( 1300, 1900 ] 1 0.002% 99.967% ( 1900, 2900 ] 4 0.008% 99.975% ( 2900, 4400 ] 7 0.015% 99.990% ( 4400, 6600 ] 5 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1850.6286 StdDev: 1584.91 Min: 211 Median: 1246.2500 Max: 6234 Percentiles: P50: 1246.25 P75: 2712.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ ( 170, 250 ] 1 2.857% 2.857% # ( 250, 380 ] 1 2.857% 5.714% # ( 380, 580 ] 5 14.286% 20.000% ### ( 580, 870 ] 7 20.000% 40.000% #### ( 870, 1300 ] 4 11.429% 51.429% ## ( 1300, 1900 ] 5 14.286% 65.714% ### ( 1900, 2900 ] 4 11.429% 77.143% ## ( 2900, 4400 ] 5 14.286% 91.429% ### ( 4400, 6600 ] 3 8.571% 100.000% ## ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 327.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.387 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.371 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-11:17:17 ... thread 0: (1000000,5000000) ops and (336165.3,337363.0) ops/second in (2.974727,14.820830) 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 14/4 3.07 GB 283.2 3.6 0.0 3.6 8.2 4.7 0.0 1.8 134.6 310.9 27.14 25.50 80 0.339 3709K 3924 0.0 0.0 L1 11/0 1.10 GB 113.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 233.3 232.3 6.22 6.04 2 3.109 1472K 5714 0.0 0.0 L2 1/0 49.42 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 250.5 250.3 1.39 1.35 2 0.695 353K 192 0.0 0.0 L3 40/0 973.06 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 198.1 197.9 3.47 3.01 3 1.157 698K 654 0.0 0.0 L4 136/0 9.75 GB 1.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 L5 1044/0 85.88 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 1246/4 100.80 GB 0.0 6.0 2.1 3.9 10.7 6.8 0.7 2.3 160.7 285.6 38.22 35.90 87 0.439 6234K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.0 2.1 3.9 10.7 6.8 0.6 2.3 160.7 285.6 38.22 35.90 87 0.439 6234K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.0 2.1 3.9 6.0 2.1 0.0 0.0 247.3 246.9 24.83 23.91 20 1.241 6234K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 357.6 13.39 11.99 67 0.200 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.0 total, 14.8 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: 10.66 GB write, 727.29 MB/s write, 6.00 GB read, 409.06 MB/s read, 38.2 seconds Interval compaction: 10.66 GB write, 736.51 MB/s write, 6.00 GB read, 414.24 MB/s read, 38.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1352898 Average: 2.0877 StdDev: 11.82 Min: 0 Median: 1.4326 Max: 4391 Percentiles: P50: 1.43 P75: 1.82 P99: 5.30 P99.9: 9.87 P99.99: 14.43 ------------------------------------------------------ [ 0, 1 ] 296915 21.947% 21.947% #### ( 1, 2 ] 877243 64.842% 86.788% ############# ( 2, 3 ] 112219 8.295% 95.083% ## ( 3, 4 ] 39212 2.898% 97.981% # ( 4, 6 ] 21276 1.573% 99.554% ( 6, 10 ] 4842 0.358% 99.912% ( 10, 15 ] 1194 0.088% 100.000% ( 15, 22 ] 139 0.010% 100.010% ( 22, 34 ] 16 0.001% 100.012% ( 34, 51 ] 9 0.001% 100.012% ( 51, 76 ] 11 0.001% 100.013% ( 110, 170 ] 29 0.002% 100.015% ( 170, 250 ] 31 0.002% 100.018% ( 250, 380 ] 30 0.002% 100.020% ( 380, 580 ] 10 0.001% 100.021% ( 580, 870 ] 22 0.002% 100.022% ( 870, 1300 ] 14 0.001% 100.023% ( 1300, 1900 ] 8 0.001% 100.024% ( 1900, 2900 ] 11 0.001% 100.025% ( 2900, 4400 ] 6 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 92178 Average: 2.5650 StdDev: 17.24 Min: 0 Median: 1.5750 Max: 2430 Percentiles: P50: 1.57 P75: 1.96 P99: 6.00 P99.9: 21.90 P99.99: 509.70 ------------------------------------------------------ [ 0, 1 ] 11547 12.527% 12.527% ### ( 1, 2 ] 60074 65.172% 77.699% ############# ( 2, 3 ] 12939 14.037% 91.736% ### ( 3, 4 ] 3792 4.114% 95.849% # ( 4, 6 ] 2904 3.150% 99.000% # ( 6, 10 ] 690 0.749% 99.748% ( 10, 15 ] 128 0.139% 99.887% ( 15, 22 ] 12 0.013% 99.900% ( 22, 34 ] 1 0.001% 99.901% ( 34, 51 ] 25 0.027% 99.928% ( 51, 76 ] 25 0.027% 99.956% ( 76, 110 ] 5 0.005% 99.961% ( 110, 170 ] 3 0.003% 99.964% ( 170, 250 ] 6 0.007% 99.971% ( 250, 380 ] 10 0.011% 99.982% ( 380, 580 ] 12 0.013% 99.995% ( 580, 870 ] 6 0.007% 100.001% ( 1300, 1900 ] 4 0.004% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75863 Average: 2.0985 StdDev: 4.45 Min: 0 Median: 1.4412 Max: 854 Percentiles: P50: 1.44 P75: 1.85 P99: 5.77 P99.9: 11.01 P99.99: 158.27 ------------------------------------------------------ [ 0, 1 ] 17348 22.868% 22.868% ##### ( 1, 2 ] 46658 61.503% 84.371% ############ ( 2, 3 ] 6870 9.056% 93.426% ## ( 3, 4 ] 2500 3.295% 96.722% # ( 4, 6 ] 1957 2.580% 99.301% # ( 6, 10 ] 439 0.579% 99.880% ( 10, 15 ] 75 0.099% 99.979% ( 15, 22 ] 2 0.003% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 51, 76 ] 2 0.003% 99.987% ( 110, 170 ] 3 0.004% 99.991% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 3 0.004% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47958 Average: 3.9759 StdDev: 71.80 Min: 0 Median: 1.5925 Max: 5370 Percentiles: P50: 1.59 P75: 1.97 P99: 6.36 P99.9: 277.09 P99.99: 4489.85 ------------------------------------------------------ [ 0, 1 ] 5112 10.659% 10.659% ## ( 1, 2 ] 31845 66.402% 77.061% ############# ( 2, 3 ] 6797 14.173% 91.234% ### ( 3, 4 ] 2139 4.460% 95.694% # ( 4, 6 ] 1554 3.240% 98.934% # ( 6, 10 ] 352 0.734% 99.668% ( 10, 15 ] 55 0.115% 99.783% ( 15, 22 ] 9 0.019% 99.802% ( 22, 34 ] 38 0.079% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 5 0.010% 99.896% ( 170, 250 ] 1 0.002% 99.898% ( 250, 380 ] 5 0.010% 99.908% ( 380, 580 ] 13 0.027% 99.935% ( 580, 870 ] 12 0.025% 99.960% ( 870, 1300 ] 2 0.004% 99.965% ( 1300, 1900 ] 1 0.002% 99.967% ( 1900, 2900 ] 4 0.008% 99.975% ( 2900, 4400 ] 7 0.015% 99.990% ( 4400, 6600 ] 5 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1850.6286 StdDev: 1584.91 Min: 211 Median: 1246.2500 Max: 6234 Percentiles: P50: 1246.25 P75: 2712.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ ( 170, 250 ] 1 2.857% 2.857% # ( 250, 380 ] 1 2.857% 5.714% # ( 380, 580 ] 5 14.286% 20.000% ### ( 580, 870 ] 7 20.000% 40.000% #### ( 870, 1300 ] 4 11.429% 51.429% ## ( 1300, 1900 ] 5 14.286% 65.714% ### ( 1900, 2900 ] 4 11.429% 77.143% ## ( 2900, 4400 ] 5 14.286% 91.429% ### ( 4400, 6600 ] 3 8.571% 100.000% ## ** DB Stats ** Uptime(secs): 15.0 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 327.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.779 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, 330.85 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.392 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-11:17:21 ... thread 0: (1000000,6000000) ops and (302703.0,331045.5) ops/second in (3.303568,18.124398) 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 17/17 4.06 GB 0.0 4.7 0.0 4.7 10.3 5.7 0.0 1.8 140.1 309.5 34.18 32.14 99 0.345 4861K 5126 0.0 0.0 L1 11/11 1.10 GB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 233.3 232.3 6.22 6.04 2 3.109 1472K 5714 0.0 0.0 L2 1/0 49.42 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 250.5 250.3 1.39 1.35 2 0.695 353K 192 0.0 0.0 L3 40/0 973.06 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 198.1 197.9 3.47 3.01 3 1.157 698K 654 0.0 0.0 L4 136/0 9.75 GB 1.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 L5 1044/0 85.88 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 1249/28 101.78 GB 0.0 7.1 2.1 5.0 12.8 7.7 0.7 2.3 160.7 288.5 45.26 42.54 106 0.427 7385K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.1 2.1 5.0 12.8 7.7 0.6 2.3 160.7 288.5 45.26 42.54 106 0.427 7385K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.1 2.1 5.0 7.1 2.1 0.0 0.0 250.1 249.7 29.08 28.08 24 1.212 7385K 11K 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 358.3 16.17 14.46 82 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.3 total, 18.1 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: 12.75 GB write, 712.99 MB/s write, 7.10 GB read, 397.19 MB/s read, 45.3 seconds Interval compaction: 12.75 GB write, 720.38 MB/s write, 7.10 GB read, 401.30 MB/s read, 45.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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 15, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1631004 Average: 2.0786 StdDev: 12.94 Min: 0 Median: 1.4133 Max: 4391 Percentiles: P50: 1.41 P75: 1.80 P99: 5.18 P99.9: 9.90 P99.99: 16.22 ------------------------------------------------------ [ 0, 1 ] 382084 23.426% 23.426% ##### ( 1, 2 ] 1048732 64.300% 87.726% ############# ( 2, 3 ] 125689 7.706% 95.432% ## ( 3, 4 ] 44522 2.730% 98.162% # ( 4, 6 ] 23205 1.423% 99.585% ( 6, 10 ] 5273 0.323% 99.908% ( 10, 15 ] 1307 0.080% 99.988% ( 15, 22 ] 166 0.010% 99.998% ( 22, 34 ] 18 0.001% 100.000% ( 34, 51 ] 12 0.001% 100.000% ( 51, 76 ] 11 0.001% 100.001% ( 76, 110 ] 62 0.004% 100.005% ( 110, 170 ] 103 0.006% 100.011% ( 170, 250 ] 52 0.003% 100.014% ( 250, 380 ] 42 0.003% 100.017% ( 380, 580 ] 21 0.001% 100.018% ( 580, 870 ] 30 0.002% 100.020% ( 870, 1300 ] 16 0.001% 100.021% ( 1300, 1900 ] 10 0.001% 100.022% ( 1900, 2900 ] 12 0.001% 100.022% ( 2900, 4400 ] 11 0.001% 100.023% ** Level 1 read latency histogram (micros): Count: 92326 Average: 2.6810 StdDev: 18.10 Min: 0 Median: 1.5762 Max: 2430 Percentiles: P50: 1.58 P75: 1.96 P99: 6.39 P99.9: 93.24 P99.99: 533.82 ------------------------------------------------------ [ 0, 1 ] 11547 12.507% 12.507% ### ( 1, 2 ] 60074 65.067% 77.574% ############# ( 2, 3 ] 12940 14.016% 91.590% ### ( 3, 4 ] 3853 4.173% 95.763% # ( 4, 6 ] 2922 3.165% 98.928% # ( 6, 10 ] 691 0.748% 99.676% ( 10, 15 ] 130 0.141% 99.817% ( 15, 22 ] 13 0.014% 99.831% ( 22, 34 ] 1 0.001% 99.832% ( 34, 51 ] 25 0.027% 99.859% ( 51, 76 ] 25 0.027% 99.886% ( 76, 110 ] 25 0.027% 99.913% ( 110, 170 ] 33 0.036% 99.949% ( 170, 250 ] 13 0.014% 99.963% ( 250, 380 ] 14 0.015% 99.978% ( 380, 580 ] 14 0.015% 99.994% ( 580, 870 ] 6 0.006% 100.000% ( 870, 1300 ] 1 0.001% 100.001% ( 1300, 1900 ] 4 0.004% 100.005% ( 1900, 2900 ] 2 0.002% 100.008% ** Level 2 read latency histogram (micros): Count: 75863 Average: 2.0985 StdDev: 4.45 Min: 0 Median: 1.4412 Max: 854 Percentiles: P50: 1.44 P75: 1.85 P99: 5.77 P99.9: 11.01 P99.99: 158.27 ------------------------------------------------------ [ 0, 1 ] 17348 22.868% 22.868% ##### ( 1, 2 ] 46658 61.503% 84.371% ############ ( 2, 3 ] 6870 9.056% 93.426% ## ( 3, 4 ] 2500 3.295% 96.722% # ( 4, 6 ] 1957 2.580% 99.301% # ( 6, 10 ] 439 0.579% 99.880% ( 10, 15 ] 75 0.099% 99.979% ( 15, 22 ] 2 0.003% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 51, 76 ] 2 0.003% 99.987% ( 110, 170 ] 3 0.004% 99.991% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 3 0.004% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 580, 870 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47958 Average: 3.9759 StdDev: 71.80 Min: 0 Median: 1.5925 Max: 5370 Percentiles: P50: 1.59 P75: 1.97 P99: 6.36 P99.9: 277.09 P99.99: 4489.85 ------------------------------------------------------ [ 0, 1 ] 5112 10.659% 10.659% ## ( 1, 2 ] 31845 66.402% 77.061% ############# ( 2, 3 ] 6797 14.173% 91.234% ### ( 3, 4 ] 2139 4.460% 95.694% # ( 4, 6 ] 1554 3.240% 98.934% # ( 6, 10 ] 352 0.734% 99.668% ( 10, 15 ] 55 0.115% 99.783% ( 15, 22 ] 9 0.019% 99.802% ( 22, 34 ] 38 0.079% 99.881% ( 34, 51 ] 2 0.004% 99.885% ( 110, 170 ] 5 0.010% 99.896% ( 170, 250 ] 1 0.002% 99.898% ( 250, 380 ] 5 0.010% 99.908% ( 380, 580 ] 13 0.027% 99.935% ( 580, 870 ] 12 0.025% 99.960% ( 870, 1300 ] 2 0.004% 99.965% ( 1300, 1900 ] 1 0.002% 99.967% ( 1900, 2900 ] 4 0.008% 99.975% ( 2900, 4400 ] 7 0.015% 99.990% ( 4400, 6600 ] 5 0.010% 100.000% ** Level 4 read latency histogram (micros): Count: 35 Average: 1850.6286 StdDev: 1584.91 Min: 211 Median: 1246.2500 Max: 6234 Percentiles: P50: 1246.25 P75: 2712.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ ( 170, 250 ] 1 2.857% 2.857% # ( 250, 380 ] 1 2.857% 5.714% # ( 380, 580 ] 5 14.286% 20.000% ### ( 580, 870 ] 7 20.000% 40.000% #### ( 870, 1300 ] 4 11.429% 51.429% ## ( 1300, 1900 ] 5 14.286% 65.714% ### ( 1900, 2900 ] 4 11.429% 77.143% ## ( 2900, 4400 ] 5 14.286% 91.429% ### ( 4400, 6600 ] 3 8.571% 100.000% ## ** DB Stats ** Uptime(secs): 18.3 total, 3.3 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 322.44 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.489 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 297.92 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.710 H:M:S, 21.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-11:17:52 ... thread 0: (1000000,7000000) ops and (32244.9,142458.6) ops/second in (31.012672,49.137070) 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 7/4 566.95 MB 25.2 4.7 0.0 4.7 11.3 6.6 0.0 1.7 121.9 293.5 39.27 34.75 111 0.354 4861K 5126 0.0 0.0 L1 4/0 235.79 MB 23.6 7.1 5.8 1.3 7.0 5.7 0.2 1.2 204.0 200.3 35.87 31.32 5 7.174 7393K 135K 0.0 0.0 L2 12/9 1.30 GB 3.2 0.4 0.2 0.2 0.4 0.2 5.5 1.6 239.6 239.5 1.69 1.59 3 0.563 411K 192 0.0 0.0 L3 36/21 3.08 GB 0.8 4.0 2.8 1.1 4.0 2.8 1.6 1.4 131.3 130.9 30.91 18.75 22 1.405 3556K 3577 0.0 0.0 L4 146/0 9.50 GB 1.0 0.1 0.1 0.0 0.1 0.1 1.8 1.0 221.4 221.4 0.39 0.37 1 0.389 87K 0 0.0 0.0 L5 1068/0 87.91 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1273/34 102.57 GB 0.0 16.3 9.0 7.3 22.7 15.4 11.1 3.4 154.0 215.0 108.13 86.79 142 0.761 16M 144K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.3 9.0 7.3 22.7 15.4 11.0 3.4 154.0 215.0 108.13 86.79 142 0.761 16M 144K 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.3 9.0 7.3 16.1 8.9 0.0 0.0 191.8 190.0 86.86 69.71 48 1.810 16M 144K 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 317.0 21.26 17.07 94 0.226 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): 49.3 total, 49.1 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.70 GB write, 471.23 MB/s write, 16.27 GB read, 337.68 MB/s read, 108.1 seconds Interval compaction: 22.70 GB write, 473.03 MB/s write, 16.27 GB read, 338.97 MB/s read, 108.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 53, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 53, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2860297 Average: 3.0514 StdDev: 24.06 Min: 0 Median: 1.3762 Max: 5930 Percentiles: P50: 1.38 P75: 1.79 P99: 8.07 P99.9: 165.49 P99.99: 497.08 ------------------------------------------------------ [ 0, 1 ] 773936 27.058% 27.058% ##### ( 1, 2 ] 1744132 60.977% 88.035% ############ ( 2, 3 ] 179213 6.266% 94.301% # ( 3, 4 ] 76582 2.677% 96.978% # ( 4, 6 ] 52453 1.834% 98.812% ( 6, 10 ] 10373 0.363% 99.175% ( 10, 15 ] 3119 0.109% 99.284% ( 15, 22 ] 715 0.025% 99.309% ( 22, 34 ] 31 0.001% 99.310% ( 34, 51 ] 14 0.000% 99.310% ( 51, 76 ] 95 0.003% 99.314% ( 76, 110 ] 10442 0.365% 99.679% ( 110, 170 ] 6848 0.239% 99.918% ( 170, 250 ] 915 0.032% 99.950% ( 250, 380 ] 774 0.027% 99.977% ( 380, 580 ] 632 0.022% 99.999% ( 580, 870 ] 237 0.008% 100.007% ( 870, 1300 ] 51 0.002% 100.009% ( 1300, 1900 ] 31 0.001% 100.010% ( 1900, 2900 ] 32 0.001% 100.011% ( 2900, 4400 ] 55 0.002% 100.013% ( 4400, 6600 ] 3 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 1309269 Average: 6.6105 StdDev: 111.44 Min: 0 Median: 1.7778 Max: 13509 Percentiles: P50: 1.78 P75: 2.73 P99: 9.18 P99.9: 124.51 P99.99: 248.85 ------------------------------------------------------ [ 0, 1 ] 133747 10.215% 10.215% ## ( 1, 2 ] 669704 51.151% 61.366% ########## ( 2, 3 ] 245863 18.779% 80.145% #### ( 3, 4 ] 117304 8.960% 89.105% ## ( 4, 6 ] 111650 8.528% 97.632% ## ( 6, 10 ] 22544 1.722% 99.354% ( 10, 15 ] 4468 0.341% 99.695% ( 15, 22 ] 668 0.051% 99.746% ( 22, 34 ] 44 0.003% 99.750% ( 34, 51 ] 52 0.004% 99.754% ( 51, 76 ] 87 0.007% 99.760% ( 76, 110 ] 1539 0.118% 99.878% ( 110, 170 ] 1198 0.092% 99.969% ( 170, 250 ] 274 0.021% 99.990% ( 250, 380 ] 367 0.028% 100.018% ( 380, 580 ] 450 0.034% 100.053% ( 580, 870 ] 398 0.030% 100.083% ( 870, 1300 ] 331 0.025% 100.108% ( 1300, 1900 ] 211 0.016% 100.124% ( 1900, 2900 ] 330 0.025% 100.150% ( 2900, 4400 ] 454 0.035% 100.184% ( 4400, 6600 ] 121 0.009% 100.194% ( 6600, 9900 ] 51 0.004% 100.198% ( 9900, 14000 ] 6 0.000% 100.198% ** Level 2 read latency histogram (micros): Count: 79406 Average: 3.5856 StdDev: 59.85 Min: 0 Median: 1.4628 Max: 8043 Percentiles: P50: 1.46 P75: 1.87 P99: 5.92 P99.9: 407.31 P99.99: 3453.55 ------------------------------------------------------ [ 0, 1 ] 17386 21.895% 21.895% #### ( 1, 2 ] 48217 60.722% 82.617% ############ ( 2, 3 ] 7864 9.904% 92.521% ## ( 3, 4 ] 2874 3.619% 96.140% # ( 4, 6 ] 2362 2.975% 99.115% # ( 6, 10 ] 493 0.621% 99.736% ( 10, 15 ] 85 0.107% 99.843% ( 15, 22 ] 3 0.004% 99.846% ( 22, 34 ] 2 0.003% 99.849% ( 51, 76 ] 2 0.003% 99.851% ( 76, 110 ] 3 0.004% 99.855% ( 110, 170 ] 9 0.011% 99.867% ( 170, 250 ] 14 0.018% 99.884% ( 250, 380 ] 10 0.013% 99.897% ( 380, 580 ] 19 0.024% 99.921% ( 580, 870 ] 29 0.037% 99.957% ( 870, 1300 ] 10 0.013% 99.970% ( 1300, 1900 ] 7 0.009% 99.979% ( 1900, 2900 ] 5 0.006% 99.985% ( 2900, 4400 ] 11 0.014% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 431680 Average: 10.3420 StdDev: 132.85 Min: 0 Median: 1.9255 Max: 7862 Percentiles: P50: 1.93 P75: 2.92 P99: 9.94 P99.9: 1163.86 P99.99: 2137.98 ------------------------------------------------------ [ 0, 1 ] 9503 2.201% 2.201% ( 1, 2 ] 222958 51.649% 53.850% ########## ( 2, 3 ] 99454 23.039% 76.889% ##### ( 3, 4 ] 46701 10.818% 87.708% ## ( 4, 6 ] 41105 9.522% 97.230% ## ( 6, 10 ] 7765 1.799% 99.028% ( 10, 15 ] 1513 0.350% 99.379% ( 15, 22 ] 162 0.038% 99.416% ( 22, 34 ] 51 0.012% 99.428% ( 34, 51 ] 16 0.004% 99.432% ( 51, 76 ] 10 0.002% 99.434% ( 76, 110 ] 45 0.010% 99.445% ( 110, 170 ] 201 0.047% 99.491% ( 170, 250 ] 258 0.060% 99.551% ( 250, 380 ] 291 0.067% 99.618% ( 380, 580 ] 455 0.105% 99.724% ( 580, 870 ] 503 0.117% 99.840% ( 870, 1300 ] 378 0.088% 99.928% ( 1300, 1900 ] 216 0.050% 99.978% ( 1900, 2900 ] 222 0.051% 100.029% ( 2900, 4400 ] 249 0.058% 100.087% ( 4400, 6600 ] 50 0.012% 100.099% ( 6600, 9900 ] 10 0.002% 100.101% ** Level 4 read latency histogram (micros): Count: 45 Average: 1473.8667 StdDev: 1571.28 Min: 1 Median: 849.2857 Max: 6234 Percentiles: P50: 849.29 P75: 2087.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ [ 0, 1 ] 1 2.222% 2.222% ( 1, 2 ] 4 8.889% 11.111% ## ( 2, 3 ] 1 2.222% 13.333% ( 22, 34 ] 1 2.222% 15.556% ( 170, 250 ] 2 4.444% 20.000% # ( 250, 380 ] 2 4.444% 24.444% # ( 380, 580 ] 5 11.111% 35.556% ## ( 580, 870 ] 7 15.556% 51.111% ### ( 870, 1300 ] 5 11.111% 62.222% ## ( 1300, 1900 ] 5 11.111% 73.333% ## ( 1900, 2900 ] 4 8.889% 82.222% ## ( 2900, 4400 ] 5 11.111% 93.333% ## ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 120 Average: 1689.7250 StdDev: 1811.51 Min: 82 Median: 797.5000 Max: 6575 Percentiles: P50: 797.50 P75: 2800.00 P99: 6411.43 P99.9: 6575.00 P99.99: 6575.00 ------------------------------------------------------ ( 76, 110 ] 3 2.500% 2.500% # ( 110, 170 ] 4 3.333% 5.833% # ( 170, 250 ] 13 10.833% 16.667% ## ( 250, 380 ] 17 14.167% 30.833% ### ( 380, 580 ] 14 11.667% 42.500% ## ( 580, 870 ] 12 10.000% 52.500% ## ( 870, 1300 ] 13 10.833% 63.333% ## ( 1300, 1900 ] 5 4.167% 67.500% # ( 1900, 2900 ] 10 8.333% 75.833% ## ( 2900, 4400 ] 15 12.500% 88.333% ### ( 4400, 6600 ] 14 11.667% 100.000% ## ** DB Stats ** Uptime(secs): 49.3 total, 31.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 139.67 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:30.242 H:M:S, 61.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 31.74 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.753 H:M:S, 89.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/11/29-11:17:55 ... thread 0: (1000000,8000000) ops and (287768.2,152056.3) ops/second in (3.475019,52.612089) 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.54 GB 75.5 5.6 0.0 5.6 13.2 7.6 0.0 1.7 124.1 291.6 46.20 41.09 127 0.364 5820K 6233 0.0 0.0 L1 4/4 235.79 MB 0.0 7.1 5.8 1.3 7.0 5.7 0.2 1.2 204.0 200.3 35.87 31.32 5 7.174 7393K 135K 0.0 0.0 L2 2/1 122.65 MB 0.7 0.4 0.2 0.2 0.4 0.2 5.5 1.6 239.6 239.5 1.69 1.59 3 0.563 411K 192 0.0 0.0 L3 26/12 2.37 GB 0.9 6.1 4.0 2.1 6.1 4.0 1.6 1.5 143.2 142.8 43.76 28.74 26 1.683 4620K 4796 0.0 0.0 L4 149/0 9.42 GB 1.0 0.1 0.1 0.0 0.1 0.1 3.7 1.0 221.4 221.4 0.39 0.37 1 0.389 87K 0 0.0 0.0 L5 1092/0 89.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1284/25 103.55 GB 0.0 19.3 10.2 9.2 26.8 17.6 14.9 3.5 154.9 214.2 127.91 103.11 162 0.790 18M 146K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.3 10.2 9.2 26.8 17.6 14.9 3.5 154.9 214.2 127.91 103.11 162 0.790 18M 146K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.3 10.2 9.2 19.2 10.0 0.0 0.0 191.3 189.7 103.56 83.41 55 1.883 18M 146K 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 318.2 24.35 19.70 107 0.228 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): 52.8 total, 52.6 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 26.75 GB write, 518.85 MB/s write, 19.34 GB read, 375.16 MB/s read, 127.9 seconds Interval compaction: 26.75 GB write, 520.71 MB/s write, 19.34 GB read, 376.50 MB/s read, 127.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 58, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 58, interval: 69 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3189775 Average: 3.0431 StdDev: 23.64 Min: 0 Median: 1.4161 Max: 5930 Percentiles: P50: 1.42 P75: 1.83 P99: 7.94 P99.9: 162.44 P99.99: 453.45 ------------------------------------------------------ [ 0, 1 ] 787605 24.692% 24.692% ##### ( 1, 2 ] 1940142 60.824% 85.515% ############ ( 2, 3 ] 243193 7.624% 93.139% ## ( 3, 4 ] 103921 3.258% 96.397% # ( 4, 6 ] 76063 2.385% 98.782% ( 6, 10 ] 14343 0.450% 99.232% ( 10, 15 ] 3919 0.123% 99.355% ( 15, 22 ] 785 0.025% 99.379% ( 22, 34 ] 39 0.001% 99.380% ( 34, 51 ] 17 0.001% 99.381% ( 51, 76 ] 97 0.003% 99.384% ( 76, 110 ] 10449 0.328% 99.712% ( 110, 170 ] 6880 0.216% 99.927% ( 170, 250 ] 947 0.030% 99.957% ( 250, 380 ] 815 0.026% 99.982% ( 380, 580 ] 659 0.021% 100.003% ( 580, 870 ] 260 0.008% 100.011% ( 870, 1300 ] 67 0.002% 100.013% ( 1300, 1900 ] 38 0.001% 100.015% ( 1900, 2900 ] 40 0.001% 100.016% ( 2900, 4400 ] 57 0.002% 100.018% ( 4400, 6600 ] 3 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 1654606 Average: 6.0184 StdDev: 100.00 Min: 0 Median: 1.7975 Max: 13509 Percentiles: P50: 1.80 P75: 2.73 P99: 9.20 P99.9: 127.59 P99.99: 269.75 ------------------------------------------------------ [ 0, 1 ] 139069 8.405% 8.405% ## ( 1, 2 ] 863020 52.159% 60.564% ########## ( 2, 3 ] 325199 19.654% 80.218% #### ( 3, 4 ] 147147 8.893% 89.111% ## ( 4, 6 ] 138742 8.385% 97.496% ## ( 6, 10 ] 31080 1.878% 99.375% ( 10, 15 ] 5695 0.344% 99.719% ( 15, 22 ] 789 0.048% 99.766% ( 22, 34 ] 49 0.003% 99.769% ( 34, 51 ] 55 0.003% 99.773% ( 51, 76 ] 89 0.005% 99.778% ( 76, 110 ] 1611 0.097% 99.875% ( 110, 170 ] 1386 0.084% 99.959% ( 170, 250 ] 431 0.026% 99.985% ( 250, 380 ] 517 0.031% 100.016% ( 380, 580 ] 588 0.036% 100.052% ( 580, 870 ] 484 0.029% 100.081% ( 870, 1300 ] 362 0.022% 100.103% ( 1300, 1900 ] 218 0.013% 100.116% ( 1900, 2900 ] 344 0.021% 100.137% ( 2900, 4400 ] 458 0.028% 100.165% ( 4400, 6600 ] 121 0.007% 100.172% ( 6600, 9900 ] 51 0.003% 100.175% ( 9900, 14000 ] 6 0.000% 100.176% ** Level 2 read latency histogram (micros): Count: 98099 Average: 3.8078 StdDev: 55.98 Min: 0 Median: 1.5338 Max: 8043 Percentiles: P50: 1.53 P75: 1.95 P99: 7.30 P99.9: 508.10 P99.99: 3198.65 ------------------------------------------------------ [ 0, 1 ] 17700 18.043% 18.043% #### ( 1, 2 ] 58732 59.870% 77.913% ############ ( 2, 3 ] 12173 12.409% 90.322% ## ( 3, 4 ] 4381 4.466% 94.788% # ( 4, 6 ] 3830 3.904% 98.692% # ( 6, 10 ] 932 0.950% 99.642% ( 10, 15 ] 135 0.138% 99.780% ( 15, 22 ] 8 0.008% 99.788% ( 22, 34 ] 2 0.002% 99.790% ( 34, 51 ] 1 0.001% 99.791% ( 51, 76 ] 2 0.002% 99.793% ( 76, 110 ] 4 0.004% 99.797% ( 110, 170 ] 20 0.020% 99.818% ( 170, 250 ] 36 0.037% 99.854% ( 250, 380 ] 18 0.018% 99.873% ( 380, 580 ] 42 0.043% 99.915% ( 580, 870 ] 41 0.042% 99.957% ( 870, 1300 ] 16 0.016% 99.973% ( 1300, 1900 ] 9 0.009% 99.983% ( 1900, 2900 ] 5 0.005% 99.988% ( 2900, 4400 ] 11 0.011% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 566529 Average: 9.0430 StdDev: 118.27 Min: 0 Median: 1.9071 Max: 7862 Percentiles: P50: 1.91 P75: 2.88 P99: 9.80 P99.9: 1044.53 P99.99: 2049.78 ------------------------------------------------------ [ 0, 1 ] 11136 1.966% 1.966% ( 1, 2 ] 300010 52.956% 54.921% ########### ( 2, 3 ] 129776 22.907% 77.829% ##### ( 3, 4 ] 58375 10.304% 88.133% ## ( 4, 6 ] 51369 9.067% 97.200% ## ( 6, 10 ] 10739 1.896% 99.096% ( 10, 15 ] 1841 0.325% 99.421% ( 15, 22 ] 183 0.032% 99.453% ( 22, 34 ] 55 0.010% 99.463% ( 34, 51 ] 19 0.003% 99.466% ( 51, 76 ] 12 0.002% 99.468% ( 76, 110 ] 94 0.017% 99.485% ( 110, 170 ] 314 0.055% 99.540% ( 170, 250 ] 349 0.062% 99.602% ( 250, 380 ] 391 0.069% 99.671% ( 380, 580 ] 550 0.097% 99.768% ( 580, 870 ] 579 0.102% 99.870% ( 870, 1300 ] 420 0.074% 99.944% ( 1300, 1900 ] 225 0.040% 99.984% ( 1900, 2900 ] 236 0.042% 100.025% ( 2900, 4400 ] 256 0.045% 100.071% ( 4400, 6600 ] 50 0.009% 100.079% ( 6600, 9900 ] 10 0.002% 100.081% ** Level 4 read latency histogram (micros): Count: 45 Average: 1473.8667 StdDev: 1571.28 Min: 1 Median: 849.2857 Max: 6234 Percentiles: P50: 849.29 P75: 2087.50 P99: 6234.00 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ [ 0, 1 ] 1 2.222% 2.222% ( 1, 2 ] 4 8.889% 11.111% ## ( 2, 3 ] 1 2.222% 13.333% ( 22, 34 ] 1 2.222% 15.556% ( 170, 250 ] 2 4.444% 20.000% # ( 250, 380 ] 2 4.444% 24.444% # ( 380, 580 ] 5 11.111% 35.556% ## ( 580, 870 ] 7 15.556% 51.111% ### ( 870, 1300 ] 5 11.111% 62.222% ## ( 1300, 1900 ] 5 11.111% 73.333% ## ( 1900, 2900 ] 4 8.889% 82.222% ## ( 2900, 4400 ] 5 11.111% 93.333% ## ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 240 Average: 1437.0458 StdDev: 1544.34 Min: 78 Median: 785.4167 Max: 6575 Percentiles: P50: 785.42 P75: 2246.15 P99: 6270.00 P99.9: 6567.00 P99.99: 6575.00 ------------------------------------------------------ ( 76, 110 ] 11 4.583% 4.583% # ( 110, 170 ] 17 7.083% 11.667% # ( 170, 250 ] 24 10.000% 21.667% ## ( 250, 380 ] 29 12.083% 33.750% ## ( 380, 580 ] 22 9.167% 42.917% ## ( 580, 870 ] 24 10.000% 52.917% ## ( 870, 1300 ] 30 12.500% 65.417% ### ( 1300, 1900 ] 14 5.833% 71.250% # ( 1900, 2900 ] 26 10.833% 82.083% ## ( 2900, 4400 ] 27 11.250% 93.333% ## ( 4400, 6600 ] 16 6.667% 100.000% # ** DB Stats ** Uptime(secs): 52.8 total, 3.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 149.12 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:30.973 H:M:S, 58.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 283.22 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.732 H:M:S, 21.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/29-11:17:59 ... thread 0: (1000000,9000000) ops and (282434.7,160277.2) ops/second in (3.540641,56.152730) 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/7 1.91 GB 75.5 6.4 0.0 6.4 14.9 8.5 0.0 1.8 124.1 288.7 52.78 46.78 143 0.369 6652K 7056 0.0 0.0 L1 10/10 799.92 MB 0.0 7.9 6.4 1.5 7.8 6.3 0.2 1.2 204.2 200.7 39.77 34.95 6 6.629 8208K 137K 0.0 0.0 L2 1/0 66.04 MB 0.7 0.4 0.2 0.2 0.4 0.2 5.5 1.6 239.6 239.5 1.69 1.59 3 0.563 411K 192 0.0 0.0 L3 25/9 1.72 GB 1.0 7.7 4.1 3.6 7.7 4.1 1.6 1.9 151.5 151.1 51.92 35.94 27 1.923 6248K 7882 0.0 0.0 L4 158/9 10.11 GB 1.0 0.7 0.6 0.1 0.7 0.6 3.9 1.1 129.5 128.9 5.54 3.37 8 0.692 728K 2929 0.0 0.0 L5 1092/0 89.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1297/35 104.46 GB 0.0 23.1 11.4 11.7 31.4 19.7 15.1 3.7 156.0 212.2 151.70 122.63 187 0.811 22M 155K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.1 11.4 11.7 31.4 19.7 15.0 3.7 156.0 212.2 151.70 122.63 187 0.811 22M 155K 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 23.1 11.4 11.7 22.9 11.2 0.0 0.0 190.6 189.2 124.16 100.45 67 1.853 22M 155K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 315.6 27.54 22.18 120 0.230 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): 56.3 total, 56.2 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.43 GB write, 571.26 MB/s write, 23.11 GB read, 419.98 MB/s read, 151.7 seconds Interval compaction: 31.43 GB write, 573.17 MB/s write, 23.11 GB read, 421.39 MB/s read, 151.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 67, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 67, interval: 78 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3467255 Average: 3.0278 StdDev: 24.02 Min: 0 Median: 1.4387 Max: 5930 Percentiles: P50: 1.44 P75: 1.85 P99: 7.75 P99.9: 159.67 P99.99: 421.15 ------------------------------------------------------ [ 0, 1 ] 806406 23.258% 23.258% ##### ( 1, 2 ] 2113494 60.956% 84.214% ############ ( 2, 3 ] 290094 8.367% 92.580% ## ( 3, 4 ] 122834 3.543% 96.123% # ( 4, 6 ] 92276 2.661% 98.784% # ( 6, 10 ] 17067 0.492% 99.277% ( 10, 15 ] 4451 0.128% 99.405% ( 15, 22 ] 819 0.024% 99.429% ( 22, 34 ] 41 0.001% 99.430% ( 34, 51 ] 20 0.001% 99.430% ( 51, 76 ] 100 0.003% 99.433% ( 76, 110 ] 10462 0.302% 99.735% ( 110, 170 ] 6915 0.199% 99.934% ( 170, 250 ] 966 0.028% 99.962% ( 250, 380 ] 826 0.024% 99.986% ( 380, 580 ] 672 0.019% 100.005% ( 580, 870 ] 271 0.008% 100.013% ( 870, 1300 ] 76 0.002% 100.015% ( 1300, 1900 ] 39 0.001% 100.017% ( 1900, 2900 ] 48 0.001% 100.018% ( 2900, 4400 ] 66 0.002% 100.020% ( 4400, 6600 ] 5 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1858458 Average: 5.7202 StdDev: 94.96 Min: 0 Median: 1.7784 Max: 13509 Percentiles: P50: 1.78 P75: 2.68 P99: 9.15 P99.9: 132.42 P99.99: 293.07 ------------------------------------------------------ [ 0, 1 ] 153124 8.239% 8.239% ## ( 1, 2 ] 997110 53.653% 61.892% ########### ( 2, 3 ] 358302 19.280% 81.171% #### ( 3, 4 ] 157097 8.453% 89.624% ## ( 4, 6 ] 146815 7.900% 97.524% ## ( 6, 10 ] 34817 1.873% 99.398% ( 10, 15 ] 6047 0.325% 99.723% ( 15, 22 ] 826 0.044% 99.768% ( 22, 34 ] 51 0.003% 99.770% ( 34, 51 ] 57 0.003% 99.773% ( 51, 76 ] 95 0.005% 99.778% ( 76, 110 ] 1679 0.090% 99.869% ( 110, 170 ] 1551 0.083% 99.952% ( 170, 250 ] 505 0.027% 99.979% ( 250, 380 ] 592 0.032% 100.011% ( 380, 580 ] 626 0.034% 100.045% ( 580, 870 ] 519 0.028% 100.073% ( 870, 1300 ] 373 0.020% 100.093% ( 1300, 1900 ] 227 0.012% 100.105% ( 1900, 2900 ] 345 0.019% 100.124% ( 2900, 4400 ] 469 0.025% 100.149% ( 4400, 6600 ] 121 0.007% 100.156% ( 6600, 9900 ] 51 0.003% 100.158% ( 9900, 14000 ] 6 0.000% 100.159% ** Level 2 read latency histogram (micros): Count: 102788 Average: 3.7436 StdDev: 54.69 Min: 0 Median: 1.5396 Max: 8043 Percentiles: P50: 1.54 P75: 1.96 P99: 7.32 P99.9: 485.77 P99.99: 3134.71 ------------------------------------------------------ [ 0, 1 ] 18067 17.577% 17.577% #### ( 1, 2 ] 61765 60.090% 77.667% ############ ( 2, 3 ] 13024 12.671% 90.337% ### ( 3, 4 ] 4584 4.460% 94.797% # ( 4, 6 ] 3991 3.883% 98.680% # ( 6, 10 ] 999 0.972% 99.652% ( 10, 15 ] 142 0.138% 99.790% ( 15, 22 ] 8 0.008% 99.798% ( 22, 34 ] 2 0.002% 99.800% ( 34, 51 ] 1 0.001% 99.801% ( 51, 76 ] 2 0.002% 99.803% ( 76, 110 ] 4 0.004% 99.806% ( 110, 170 ] 20 0.019% 99.826% ( 170, 250 ] 36 0.035% 99.861% ( 250, 380 ] 18 0.018% 99.878% ( 380, 580 ] 42 0.041% 99.919% ( 580, 870 ] 41 0.040% 99.959% ( 870, 1300 ] 16 0.016% 99.975% ( 1300, 1900 ] 9 0.009% 99.983% ( 1900, 2900 ] 5 0.005% 99.988% ( 2900, 4400 ] 11 0.011% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 794366 Average: 10.1676 StdDev: 130.79 Min: 0 Median: 1.9541 Max: 9552 Percentiles: P50: 1.95 P75: 2.95 P99: 10.14 P99.9: 897.67 P99.99: 1440.11 ------------------------------------------------------ [ 0, 1 ] 12648 1.592% 1.592% ( 1, 2 ] 403031 50.736% 52.328% ########## ( 2, 3 ] 190531 23.985% 76.314% ##### ( 3, 4 ] 85358 10.745% 87.059% ## ( 4, 6 ] 78326 9.860% 96.919% ## ( 6, 10 ] 16441 2.070% 98.989% ( 10, 15 ] 3245 0.409% 99.398% ( 15, 22 ] 339 0.043% 99.440% ( 22, 34 ] 70 0.009% 99.449% ( 34, 51 ] 26 0.003% 99.452% ( 51, 76 ] 16 0.002% 99.454% ( 76, 110 ] 111 0.014% 99.468% ( 110, 170 ] 398 0.050% 99.518% ( 170, 250 ] 505 0.064% 99.582% ( 250, 380 ] 639 0.080% 99.662% ( 380, 580 ] 899 0.113% 99.776% ( 580, 870 ] 946 0.119% 99.895% ( 870, 1300 ] 678 0.085% 99.980% ( 1300, 1900 ] 345 0.043% 100.023% ( 1900, 2900 ] 359 0.045% 100.069% ( 2900, 4400 ] 444 0.056% 100.125% ( 4400, 6600 ] 97 0.012% 100.137% ( 6600, 9900 ] 19 0.002% 100.139% ** Level 4 read latency histogram (micros): Count: 115 Average: 803.6522 StdDev: 1332.41 Min: 1 Median: 174.4444 Max: 6234 Percentiles: P50: 174.44 P75: 1031.25 P99: 5967.50 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ [ 0, 1 ] 11 9.565% 9.565% ## ( 1, 2 ] 26 22.609% 32.174% ##### ( 2, 3 ] 5 4.348% 36.522% # ( 3, 4 ] 6 5.217% 41.739% # ( 10, 15 ] 1 0.870% 42.609% ( 22, 34 ] 1 0.870% 43.478% ( 76, 110 ] 4 3.478% 46.957% # ( 110, 170 ] 3 2.609% 49.565% # ( 170, 250 ] 9 7.826% 57.391% ## ( 250, 380 ] 2 1.739% 59.130% ( 380, 580 ] 8 6.957% 66.087% # ( 580, 870 ] 8 6.957% 73.043% # ( 870, 1300 ] 6 5.217% 78.261% # ( 1300, 1900 ] 8 6.957% 85.217% # ( 1900, 2900 ] 7 6.087% 91.304% # ( 2900, 4400 ] 6 5.217% 96.522% # ( 4400, 6600 ] 4 3.478% 100.000% # ** Level 5 read latency histogram (micros): Count: 240 Average: 1437.0458 StdDev: 1544.34 Min: 78 Median: 785.4167 Max: 6575 Percentiles: P50: 785.42 P75: 2246.15 P99: 6270.00 P99.9: 6567.00 P99.99: 6575.00 ------------------------------------------------------ ( 76, 110 ] 11 4.583% 4.583% # ( 110, 170 ] 17 7.083% 11.667% # ( 170, 250 ] 24 10.000% 21.667% ## ( 250, 380 ] 29 12.083% 33.750% ## ( 380, 580 ] 22 9.167% 42.917% ## ( 580, 870 ] 24 10.000% 52.917% ## ( 870, 1300 ] 30 12.500% 65.417% ### ( 1300, 1900 ] 14 5.833% 71.250% # ( 1900, 2900 ] 26 10.833% 82.083% ## ( 2900, 4400 ] 27 11.250% 93.333% ## ( 4400, 6600 ] 16 6.667% 100.000% # ** DB Stats ** Uptime(secs): 56.3 total, 3.5 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 157.21 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:31.745 H:M:S, 56.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 277.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.772 H:M:S, 21.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/29-11:18:02 ... thread 0: (1000000,10000000) ops and (280737.5,167462.7) ops/second in (3.562046,59.714776) 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/11 2.95 GB 157.3 7.0 0.0 7.0 16.5 9.5 0.0 1.7 122.7 289.3 58.55 51.88 159 0.368 7291K 7880 0.0 0.0 L1 10/10 799.92 MB 0.0 7.9 6.4 1.5 7.8 6.3 0.2 1.2 204.2 200.7 39.77 34.95 6 6.629 8208K 137K 0.0 0.0 L2 1/0 66.04 MB 0.7 0.4 0.2 0.2 0.4 0.2 5.5 1.6 239.6 239.5 1.69 1.59 3 0.563 411K 192 0.0 0.0 L3 15/0 989.70 MB 1.0 7.7 4.1 3.6 7.7 4.1 1.6 1.9 151.5 151.1 51.92 35.94 27 1.923 6248K 7882 0.0 0.0 L4 152/0 9.57 GB 1.0 1.5 1.4 0.1 1.5 1.4 3.9 1.1 128.8 128.2 11.90 7.14 17 0.700 1555K 6860 0.0 0.0 L5 1108/0 91.17 GB 0.9 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1305/21 105.50 GB 0.0 24.5 12.1 12.4 33.9 21.5 16.4 3.6 153.3 211.8 163.83 131.50 212 0.773 23M 160K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.5 12.1 12.4 33.9 21.5 16.4 3.6 153.3 211.8 163.83 131.50 212 0.773 23M 160K 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 24.5 12.1 12.4 24.3 11.9 0.0 0.0 188.9 187.6 132.92 106.59 78 1.704 23M 160K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 315.9 30.91 24.91 134 0.231 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): 59.9 total, 59.7 interval Flush(GB): cumulative 9.536, interval 9.536 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: 33.88 GB write, 579.21 MB/s write, 24.52 GB read, 419.13 MB/s read, 163.8 seconds Interval compaction: 33.88 GB write, 581.03 MB/s write, 24.52 GB read, 420.45 MB/s read, 163.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 80, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 80, interval: 91 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3809290 Average: 2.9922 StdDev: 24.38 Min: 0 Median: 1.4481 Max: 5930 Percentiles: P50: 1.45 P75: 1.85 P99: 7.47 P99.9: 157.28 P99.99: 404.13 ------------------------------------------------------ [ 0, 1 ] 854842 22.441% 22.441% #### ( 1, 2 ] 2343005 61.508% 83.949% ############ ( 2, 3 ] 329168 8.641% 92.590% ## ( 3, 4 ] 136205 3.576% 96.165% # ( 4, 6 ] 100753 2.645% 98.810% # ( 6, 10 ] 19698 0.517% 99.327% ( 10, 15 ] 4787 0.126% 99.453% ( 15, 22 ] 863 0.023% 99.476% ( 22, 34 ] 45 0.001% 99.477% ( 34, 51 ] 21 0.001% 99.478% ( 51, 76 ] 101 0.003% 99.480% ( 76, 110 ] 10485 0.275% 99.755% ( 110, 170 ] 6989 0.183% 99.939% ( 170, 250 ] 1003 0.026% 99.965% ( 250, 380 ] 859 0.023% 99.988% ( 380, 580 ] 705 0.019% 100.006% ( 580, 870 ] 307 0.008% 100.014% ( 870, 1300 ] 89 0.002% 100.017% ( 1300, 1900 ] 47 0.001% 100.018% ( 1900, 2900 ] 54 0.001% 100.019% ( 2900, 4400 ] 74 0.002% 100.021% ( 4400, 6600 ] 7 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1927529 Average: 5.6158 StdDev: 93.27 Min: 0 Median: 1.7696 Max: 13509 Percentiles: P50: 1.77 P75: 2.66 P99: 9.14 P99.9: 133.31 P99.99: 298.13 ------------------------------------------------------ [ 0, 1 ] 161750 8.392% 8.392% ## ( 1, 2 ] 1042116 54.065% 62.456% ########### ( 2, 3 ] 367335 19.057% 81.514% #### ( 3, 4 ] 159860 8.294% 89.807% ## ( 4, 6 ] 149057 7.733% 97.540% ## ( 6, 10 ] 35883 1.862% 99.402% ( 10, 15 ] 6163 0.320% 99.722% ( 15, 22 ] 845 0.044% 99.766% ( 22, 34 ] 51 0.003% 99.768% ( 34, 51 ] 57 0.003% 99.771% ( 51, 76 ] 97 0.005% 99.776% ( 76, 110 ] 1755 0.091% 99.867% ( 110, 170 ] 1628 0.084% 99.952% ( 170, 250 ] 516 0.027% 99.978% ( 250, 380 ] 603 0.031% 100.010% ( 380, 580 ] 641 0.033% 100.043% ( 580, 870 ] 526 0.027% 100.070% ( 870, 1300 ] 374 0.019% 100.090% ( 1300, 1900 ] 227 0.012% 100.101% ( 1900, 2900 ] 345 0.018% 100.119% ( 2900, 4400 ] 469 0.024% 100.144% ( 4400, 6600 ] 121 0.006% 100.150% ( 6600, 9900 ] 51 0.003% 100.153% ( 9900, 14000 ] 6 0.000% 100.153% ** Level 2 read latency histogram (micros): Count: 102788 Average: 3.7436 StdDev: 54.69 Min: 0 Median: 1.5396 Max: 8043 Percentiles: P50: 1.54 P75: 1.96 P99: 7.32 P99.9: 485.77 P99.99: 3134.71 ------------------------------------------------------ [ 0, 1 ] 18067 17.577% 17.577% #### ( 1, 2 ] 61765 60.090% 77.667% ############ ( 2, 3 ] 13024 12.671% 90.337% ### ( 3, 4 ] 4584 4.460% 94.797% # ( 4, 6 ] 3991 3.883% 98.680% # ( 6, 10 ] 999 0.972% 99.652% ( 10, 15 ] 142 0.138% 99.790% ( 15, 22 ] 8 0.008% 99.798% ( 22, 34 ] 2 0.002% 99.800% ( 34, 51 ] 1 0.001% 99.801% ( 51, 76 ] 2 0.002% 99.803% ( 76, 110 ] 4 0.004% 99.806% ( 110, 170 ] 20 0.019% 99.826% ( 170, 250 ] 36 0.035% 99.861% ( 250, 380 ] 18 0.018% 99.878% ( 380, 580 ] 42 0.041% 99.919% ( 580, 870 ] 41 0.040% 99.959% ( 870, 1300 ] 16 0.016% 99.975% ( 1300, 1900 ] 9 0.009% 99.983% ( 1900, 2900 ] 5 0.005% 99.988% ( 2900, 4400 ] 11 0.011% 99.999% ( 6600, 9900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 931148 Average: 9.7380 StdDev: 127.93 Min: 0 Median: 1.9583 Max: 9552 Percentiles: P50: 1.96 P75: 2.95 P99: 9.87 P99.9: 775.41 P99.99: 1171.76 ------------------------------------------------------ [ 0, 1 ] 14428 1.549% 1.549% ( 1, 2 ] 470790 50.560% 52.110% ########## ( 2, 3 ] 224672 24.128% 76.238% ##### ( 3, 4 ] 100256 10.767% 87.005% ## ( 4, 6 ] 92584 9.943% 96.948% ## ( 6, 10 ] 19754 2.121% 99.070% ( 10, 15 ] 3916 0.421% 99.490% ( 15, 22 ] 392 0.042% 99.532% ( 22, 34 ] 75 0.008% 99.540% ( 34, 51 ] 26 0.003% 99.543% ( 51, 76 ] 16 0.002% 99.545% ( 76, 110 ] 112 0.012% 99.557% ( 110, 170 ] 405 0.043% 99.600% ( 170, 250 ] 517 0.056% 99.656% ( 250, 380 ] 652 0.070% 99.726% ( 380, 580 ] 946 0.102% 99.827% ( 580, 870 ] 1003 0.108% 99.935% ( 870, 1300 ] 728 0.078% 100.013% ( 1300, 1900 ] 373 0.040% 100.053% ( 1900, 2900 ] 408 0.044% 100.097% ( 2900, 4400 ] 511 0.055% 100.152% ( 4400, 6600 ] 107 0.011% 100.164% ( 6600, 9900 ] 20 0.002% 100.166% ** Level 4 read latency histogram (micros): Count: 205 Average: 549.3171 StdDev: 1088.83 Min: 1 Median: 11.2500 Max: 6234 Percentiles: P50: 11.25 P75: 573.75 P99: 5472.50 P99.9: 6234.00 P99.99: 6234.00 ------------------------------------------------------ [ 0, 1 ] 24 11.707% 11.707% ## ( 1, 2 ] 52 25.366% 37.073% ##### ( 2, 3 ] 15 7.317% 44.390% # ( 3, 4 ] 11 5.366% 49.756% # ( 10, 15 ] 2 0.976% 50.732% ( 15, 22 ] 1 0.488% 51.220% ( 22, 34 ] 1 0.488% 51.707% ( 76, 110 ] 11 5.366% 57.073% # ( 110, 170 ] 5 2.439% 59.512% ( 170, 250 ] 18 8.780% 68.293% ## ( 250, 380 ] 6 2.927% 71.220% # ( 380, 580 ] 8 3.902% 75.122% # ( 580, 870 ] 10 4.878% 80.000% # ( 870, 1300 ] 11 5.366% 85.366% # ( 1300, 1900 ] 12 5.854% 91.220% # ( 1900, 2900 ] 7 3.415% 94.634% # ( 2900, 4400 ] 7 3.415% 98.049% # ( 4400, 6600 ] 4 1.951% 100.000% ** Level 5 read latency histogram (micros): Count: 320 Average: 1442.9875 StdDev: 1572.13 Min: 77 Median: 781.3889 Max: 8365 Percentiles: P50: 781.39 P75: 2214.29 P99: 6444.71 P99.9: 8365.00 P99.99: 8365.00 ------------------------------------------------------ ( 76, 110 ] 21 6.562% 6.562% # ( 110, 170 ] 21 6.562% 13.125% # ( 170, 250 ] 26 8.125% 21.250% ## ( 250, 380 ] 40 12.500% 33.750% ### ( 380, 580 ] 27 8.438% 42.188% ## ( 580, 870 ] 36 11.250% 53.438% ## ( 870, 1300 ] 37 11.562% 65.000% ## ( 1300, 1900 ] 21 6.562% 71.562% # ( 1900, 2900 ] 35 10.938% 82.500% ## ( 2900, 4400 ] 37 11.562% 94.062% ## ( 4400, 6600 ] 17 5.312% 99.375% # ( 6600, 9900 ] 2 0.625% 100.000% ** DB Stats ** Uptime(secs): 59.9 total, 3.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 164.29 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.616 H:M:S, 54.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 276.30 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.871 H:M:S, 24.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.935 micros/op 168493 ops/sec 60.002 seconds 10109999 operations; 163.3 MB/s Microseconds per write: Count: 10109999 Average: 5.9350 StdDev: 513.49 Min: 0 Median: 1.7376 Max: 797240 Percentiles: P50: 1.74 P75: 2.75 P99: 6.81 P99.9: 1234.42 P99.99: 2797.61 ------------------------------------------------------ [ 0, 1 ] 1349511 13.348% 13.348% ### ( 1, 2 ] 5023644 49.690% 63.038% ########## ( 2, 3 ] 1611705 15.942% 78.980% ### ( 3, 4 ] 1439806 14.241% 93.221% ### ( 4, 6 ] 570115 5.639% 98.860% # ( 6, 10 ] 70108 0.693% 99.554% ( 10, 15 ] 12168 0.120% 99.674% ( 15, 22 ] 5448 0.054% 99.728% ( 22, 34 ] 1361 0.013% 99.742% ( 34, 51 ] 188 0.002% 99.743% ( 51, 76 ] 34 0.000% 99.744% ( 76, 110 ] 7085 0.070% 99.814% ( 110, 170 ] 2813 0.028% 99.842% ( 170, 250 ] 331 0.003% 99.845% ( 250, 380 ] 58 0.001% 99.845% ( 380, 580 ] 25 0.000% 99.846% ( 580, 870 ] 27 0.000% 99.846% ( 870, 1300 ] 6445 0.064% 99.910% ( 1300, 1900 ] 7 0.000% 99.910% ( 1900, 2900 ] 9034 0.089% 99.999% ( 2900, 4400 ] 44 0.000% 100.000% ( 4400, 6600 ] 9 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 3 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 186486 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 : 10109999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10433518968 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 : 531 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32615988 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 : 28121500791 rocksdb.compact.write.bytes COUNT : 27932416021 rocksdb.flush.write.bytes COUNT : 10304828504 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 : 75 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 : 266 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 : 10221846528 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4057088 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 : 28225548318 rocksdb.non.last.level.read.count COUNT : 6813952 rocksdb.block.checksum.compute.count COUNT : 6812965 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.375940 P95 : 3.851479 P99 : 5.882208 P100 : 797238.000000 COUNT : 10109999 SUM : 55383745 rocksdb.compaction.times.micros P50 : 1125200.000000 P95 : 4355000.000000 P99 : 24310000.000000 P100 : 25808610.000000 COUNT : 79 SUM : 133835879 rocksdb.compaction.times.cpu_micros P50 : 926969.696970 P95 : 4355000.000000 P99 : 22646711.000000 P100 : 22646711.000000 COUNT : 79 SUM : 107484812 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 : 707.098765 P95 : 3087.500000 P99 : 66250.000000 P100 : 178949.000000 COUNT : 135 SUM : 366863 rocksdb.compaction.outfile.sync.micros P50 : 1116.533333 P95 : 100666.666667 P99 : 159476.923077 P100 : 170262.000000 COUNT : 328 SUM : 4729680 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 : 116.585366 P95 : 1484.285714 P99 : 2805.000000 P100 : 4580.000000 COUNT : 257 SUM : 79637 rocksdb.table.open.io.micros P50 : 1783.333333 P95 : 9224.531250 P99 : 13442.882353 P100 : 19344.000000 COUNT : 531 SUM : 1416874 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.646243 P95 : 8.051499 P99 : 12.752242 P100 : 15196.000000 COUNT : 6811573 SUM : 46397298 rocksdb.read.block.get.micros P50 : 586.744186 P95 : 4064.583333 P99 : 6213.625000 P100 : 8421.000000 COUNT : 1062 SUM : 1159806 rocksdb.write.raw.block.micros P50 : 0.515002 P95 : 0.978504 P99 : 2.885065 P100 : 19510.000000 COUNT : 9269141 SUM : 19753350 rocksdb.numfiles.in.singlecompaction P50 : 3.284884 P95 : 6.680000 P99 : 18.990000 P100 : 28.000000 COUNT : 143 SUM : 545 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.575492 P95 : 2248.531042 P99 : 2772.455654 P100 : 797033.000000 COUNT : 118145 SUM : 32623063 rocksdb.sst.read.micros P50 : 1.597395 P95 : 4.793490 P99 : 9.161492 P100 : 13509.000000 COUNT : 6814388 SUM : 32458884 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 : 10109999 SUM : 10433518968 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 : 213181.818182 P95 : 486875.000000 P99 : 936532.000000 P100 : 936532.000000 COUNT : 135 SUM : 31084819 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 : 322 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