[2024-11-07 00:23:01.684801] Starting SPDK v25.01-pre git sha1 d1c46ed8e / DPDK 24.11.0-rc1 initialization... [2024-11-07 00:23:01.684898] [ 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_pid4145182 ] Set seed to 1730935381682384 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-07 00:23:01.842715] pci_dpdk.c: 37:dpdk_pci_init: *NOTICE*: In-development DPDK 24.11.0-rc1 is used. There is no support for it in SPDK. Enabled only for validation. [2024-11-07 00:23:01.910450] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-07 00:23:01.933882] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-07 00:23:01.933920] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 4145182' to capture a snapshot of events at runtime. [2024-11-07 00:23:01.933933] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-07 00:23:01.933942] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-07 00:23:01.933952] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid4145182 for offline analysis/debug. [2024-11-07 00:23:01.934506] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Thu Nov 7 00:23:06 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/07-00:23:08 ... thread 0: (1000000,1000000) ops and (364053.2,364053.2) ops/second in (2.746851,2.746851) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/8 504.02 MB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 357.9 2.29 2.07 12 0.191 0 0 0.0 0.0 L1 3/3 188.87 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 246.6 246.5 0.77 0.74 1 0.766 191K 75 0.0 0.0 L2 2/1 125.95 MB 0.0 0.1 0.1 0.1 0.1 0.1 0.1 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 11/0 867.17 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 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.69 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 1184/12 96.94 GB 0.0 0.3 0.2 0.1 1.1 1.0 0.3 1.4 87.4 314.8 3.60 3.33 14 0.257 319K 123 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.1 1.1 1.0 0.3 1.4 87.4 314.8 3.60 3.33 14 0.257 319K 123 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.3 0.2 0.1 0.3 0.2 0.0 0.0 239.8 239.7 1.31 1.26 2 0.657 319K 123 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 357.9 2.29 2.07 12 0.191 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 2.9 total, 2.7 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.11 GB write, 389.75 MB/s write, 0.31 GB read, 108.27 MB/s read, 3.6 seconds Interval compaction: 1.11 GB write, 412.58 MB/s write, 0.31 GB read, 114.61 MB/s read, 3.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 113917 Average: 1.8554 StdDev: 13.77 Min: 1 Median: 1.2004 Max: 2819 Percentiles: P50: 1.20 P75: 1.66 P99: 4.41 P99.9: 9.86 P99.99: 166.64 ------------------------------------------------------ [ 0, 1 ] 44461 39.029% 39.029% ######## ( 1, 2 ] 62350 54.733% 93.762% ########### ( 2, 3 ] 4115 3.612% 97.374% # ( 3, 4 ] 1669 1.465% 98.840% ( 4, 6 ] 888 0.780% 99.619% ( 6, 10 ] 333 0.292% 99.911% ( 10, 15 ] 60 0.053% 99.964% ( 15, 22 ] 17 0.015% 99.979% ( 22, 34 ] 3 0.003% 99.982% ( 34, 51 ] 2 0.002% 99.983% ( 51, 76 ] 2 0.002% 99.985% ( 110, 170 ] 7 0.006% 99.991% ( 170, 250 ] 3 0.003% 99.994% ( 250, 380 ] 6 0.005% 99.999% ( 380, 580 ] 1 0.001% 100.000% ( 580, 870 ] 3 0.003% 100.003% ( 1300, 1900 ] 1 0.001% 100.004% ( 1900, 2900 ] 3 0.003% 100.006% ** Level 1 read latency histogram (micros): Count: 20489 Average: 1.8985 StdDev: 17.21 Min: 0 Median: 1.2312 Max: 2408 Percentiles: P50: 1.23 P75: 1.67 P99: 4.06 P99.9: 9.59 P99.99: 373.64 ------------------------------------------------------ [ 0, 1 ] 7543 36.815% 36.815% ####### ( 1, 2 ] 11687 57.040% 93.855% ########### ( 2, 3 ] 793 3.870% 97.726% # ( 3, 4 ] 257 1.254% 98.980% ( 4, 6 ] 141 0.688% 99.668% ( 6, 10 ] 53 0.259% 99.927% ( 10, 15 ] 9 0.044% 99.971% ( 15, 22 ] 1 0.005% 99.976% ( 22, 34 ] 1 0.005% 99.980% ( 170, 250 ] 1 0.005% 99.985% ( 250, 380 ] 1 0.005% 99.990% ( 380, 580 ] 1 0.005% 99.995% ( 1900, 2900 ] 1 0.005% 100.000% ** Level 2 read latency histogram (micros): Count: 5573 Average: 4.4479 StdDev: 48.25 Min: 1 Median: 1.7712 Max: 2074 Percentiles: P50: 1.77 P75: 2.61 P99: 9.43 P99.9: 717.94 P99.99: 2074.00 ------------------------------------------------------ [ 0, 1 ] 378 6.783% 6.783% # ( 1, 2 ] 3123 56.038% 62.821% ########### ( 2, 3 ] 1120 20.097% 82.918% #### ( 3, 4 ] 405 7.267% 90.185% # ( 4, 6 ] 386 6.926% 97.111% # ( 6, 10 ] 124 2.225% 99.336% ( 10, 15 ] 17 0.305% 99.641% ( 15, 22 ] 8 0.144% 99.785% ( 51, 76 ] 2 0.036% 99.821% ( 110, 170 ] 1 0.018% 99.839% ( 170, 250 ] 1 0.018% 99.856% ( 250, 380 ] 1 0.018% 99.874% ( 380, 580 ] 1 0.018% 99.892% ( 580, 870 ] 3 0.054% 99.946% ( 1300, 1900 ] 3 0.054% 100.000% ( 1900, 2900 ] 1 0.018% 100.018% ** Level 3 read latency histogram (micros): Count: 45 Average: 1438.4000 StdDev: 1076.53 Min: 154 Median: 1120.8333 Max: 3993 Percentiles: P50: 1120.83 P75: 2150.00 P99: 3993.00 P99.9: 3993.00 P99.99: 3993.00 ------------------------------------------------------ ( 110, 170 ] 2 4.444% 4.444% # ( 250, 380 ] 5 11.111% 15.556% ## ( 380, 580 ] 5 11.111% 26.667% ## ( 580, 870 ] 7 15.556% 42.222% ### ( 870, 1300 ] 6 13.333% 55.556% ### ( 1300, 1900 ] 7 15.556% 71.111% ### ( 1900, 2900 ] 7 15.556% 86.667% ### ( 2900, 4400 ] 6 13.333% 100.000% ### ** Level 4 read latency histogram (micros): Count: 25 Average: 1548.4000 StdDev: 1308.38 Min: 180 Median: 1146.4286 Max: 4680 Percentiles: P50: 1146.43 P75: 1750.00 P99: 4680.00 P99.9: 4680.00 P99.99: 4680.00 ------------------------------------------------------ ( 170, 250 ] 2 8.000% 8.000% ## ( 250, 380 ] 2 8.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 3 12.000% 32.000% ## ( 870, 1300 ] 7 28.000% 60.000% ###### ( 1300, 1900 ] 5 20.000% 80.000% #### ( 1900, 2900 ] 1 4.000% 84.000% # ( 2900, 4400 ] 2 8.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 2.9 total, 2.7 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 338.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:0.211 H:M:S, 7.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 358.01 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.211 H:M:S, 7.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/07-00:23:11 ... thread 0: (1000000,2000000) ops and (328374.9,345294.9) ops/second in (3.045300,5.792151) 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/8 1.23 GB 69.2 0.6 0.0 0.6 2.3 1.8 0.0 1.3 77.6 327.7 7.30 6.74 28 0.261 575K 603 0.0 0.0 L1 1/0 3.81 MB 0.4 0.6 0.4 0.2 0.6 0.4 0.1 1.4 240.3 240.0 2.62 2.54 2 1.310 639K 861 0.0 0.0 L2 5/3 437.35 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 19/1 992.03 MB 0.9 0.1 0.1 0.0 0.1 0.1 0.1 1.0 207.4 207.4 0.60 0.55 1 0.602 126K 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.69 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 1197/12 97.92 GB 0.0 1.4 0.6 0.8 3.2 2.4 0.7 1.8 130.7 295.6 11.07 10.35 32 0.346 1469K 1512 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 0.6 0.8 3.2 2.4 0.7 1.8 130.7 295.6 11.07 10.35 32 0.346 1469K 1512 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.4 0.6 0.8 1.4 0.6 0.0 0.0 245.7 245.4 5.89 5.70 6 0.982 1469K 1512 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 352.7 5.18 4.65 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.20 GB write, 549.69 MB/s write, 1.41 GB read, 243.13 MB/s read, 11.1 seconds Interval compaction: 3.20 GB write, 564.96 MB/s write, 1.41 GB read, 249.89 MB/s read, 11.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 394953 Average: 2.0740 StdDev: 9.79 Min: 0 Median: 1.4223 Max: 2819 Percentiles: P50: 1.42 P75: 1.82 P99: 5.39 P99.9: 9.86 P99.99: 19.15 ------------------------------------------------------ [ 0, 1 ] 91345 23.128% 23.128% ##### ( 1, 2 ] 251340 63.638% 86.766% ############# ( 2, 3 ] 31835 8.060% 94.826% ## ( 3, 4 ] 11952 3.026% 97.853% # ( 4, 6 ] 6542 1.656% 99.509% ( 6, 10 ] 1600 0.405% 99.914% ( 10, 15 ] 278 0.070% 99.985% ( 15, 22 ] 38 0.010% 99.994% ( 22, 34 ] 12 0.003% 99.997% ( 34, 51 ] 3 0.001% 99.998% ( 51, 76 ] 4 0.001% 99.999% ( 110, 170 ] 15 0.004% 100.003% ( 170, 250 ] 9 0.002% 100.005% ( 250, 380 ] 14 0.004% 100.009% ( 380, 580 ] 4 0.001% 100.010% ( 580, 870 ] 5 0.001% 100.011% ( 870, 1300 ] 5 0.001% 100.012% ( 1300, 1900 ] 1 0.000% 100.012% ( 1900, 2900 ] 4 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 118519 Average: 2.2275 StdDev: 9.57 Min: 0 Median: 1.5317 Max: 2408 Percentiles: P50: 1.53 P75: 1.91 P99: 5.58 P99.9: 11.35 P99.99: 118.89 ------------------------------------------------------ [ 0, 1 ] 17326 14.619% 14.619% ### ( 1, 2 ] 78867 66.544% 81.163% ############# ( 2, 3 ] 14874 12.550% 93.712% ### ( 3, 4 ] 4252 3.588% 97.300% # ( 4, 6 ] 2546 2.148% 99.448% ( 6, 10 ] 503 0.424% 99.873% ( 10, 15 ] 120 0.101% 99.974% ( 15, 22 ] 13 0.011% 99.985% ( 22, 34 ] 3 0.003% 99.987% ( 34, 51 ] 1 0.001% 99.988% ( 51, 76 ] 1 0.001% 99.989% ( 76, 110 ] 1 0.001% 99.990% ( 110, 170 ] 1 0.001% 99.991% ( 170, 250 ] 2 0.002% 99.992% ( 250, 380 ] 4 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31714 Average: 2.7103 StdDev: 20.27 Min: 1 Median: 1.6347 Max: 2074 Percentiles: P50: 1.63 P75: 2.08 P99: 6.88 P99.9: 13.84 P99.99: 1465.72 ------------------------------------------------------ [ 0, 1 ] 2729 8.605% 8.605% ## ( 1, 2 ] 20685 65.224% 73.829% ############# ( 2, 3 ] 4571 14.413% 88.242% ### ( 3, 4 ] 1905 6.007% 94.249% # ( 4, 6 ] 1435 4.525% 98.773% # ( 6, 10 ] 325 1.025% 99.798% ( 10, 15 ] 42 0.132% 99.931% ( 15, 22 ] 9 0.028% 99.959% ( 51, 76 ] 2 0.006% 99.965% ( 110, 170 ] 1 0.003% 99.968% ( 170, 250 ] 1 0.003% 99.972% ( 250, 380 ] 1 0.003% 99.975% ( 380, 580 ] 1 0.003% 99.978% ( 580, 870 ] 3 0.009% 99.987% ( 1300, 1900 ] 3 0.009% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 20255 Average: 5.4776 StdDev: 84.71 Min: 1 Median: 1.5776 Max: 3993 Percentiles: P50: 1.58 P75: 1.95 P99: 5.78 P99.9: 1281.73 P99.99: 3893.62 ------------------------------------------------------ [ 0, 1 ] 2264 11.177% 11.177% ## ( 1, 2 ] 13614 67.213% 78.391% ############# ( 2, 3 ] 2940 14.515% 92.905% ### ( 3, 4 ] 817 4.034% 96.939% # ( 4, 6 ] 468 2.311% 99.250% ( 6, 10 ] 76 0.375% 99.625% ( 10, 15 ] 20 0.099% 99.724% ( 15, 22 ] 7 0.035% 99.758% ( 51, 76 ] 1 0.005% 99.763% ( 110, 170 ] 3 0.015% 99.778% ( 250, 380 ] 6 0.030% 99.807% ( 380, 580 ] 5 0.025% 99.832% ( 580, 870 ] 8 0.039% 99.872% ( 870, 1300 ] 6 0.030% 99.901% ( 1300, 1900 ] 7 0.035% 99.936% ( 1900, 2900 ] 7 0.035% 99.970% ( 2900, 4400 ] 6 0.030% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1548.4000 StdDev: 1308.38 Min: 180 Median: 1146.4286 Max: 4680 Percentiles: P50: 1146.43 P75: 1750.00 P99: 4680.00 P99.9: 4680.00 P99.99: 4680.00 ------------------------------------------------------ ( 170, 250 ] 2 8.000% 8.000% ## ( 250, 380 ] 2 8.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 3 12.000% 32.000% ## ( 870, 1300 ] 7 28.000% 60.000% ###### ( 1300, 1900 ] 5 20.000% 80.000% #### ( 1900, 2900 ] 1 4.000% 84.000% # ( 2900, 4400 ] 2 8.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 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, 330.57 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.595 H:M:S, 10.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.19 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.384 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/07-00:23:14 ... thread 0: (1000000,3000000) ops and (335158.2,341848.5) ops/second in (2.983666,8.775817) 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/8 2.21 GB 169.9 1.7 0.0 1.7 4.4 2.8 0.0 1.6 117.8 314.0 14.44 13.48 46 0.314 1727K 1845 0.0 0.0 L1 1/0 3.81 MB 0.4 0.6 0.4 0.2 0.6 0.4 0.1 1.4 240.3 240.0 2.62 2.54 2 1.310 639K 861 0.0 0.0 L2 2/0 51.06 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 32/0 990.97 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 190.5 190.4 3.27 2.84 2 1.636 632K 533 0.0 0.0 L4 156/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/8 98.90 GB 0.0 3.0 1.0 2.0 5.8 3.8 1.5 2.1 147.5 283.1 20.88 19.38 51 0.409 3127K 3287 0.0 0.0 Int 0/0 0.00 KB 0.0 3.0 1.0 2.0 5.8 3.8 1.5 2.1 147.5 283.1 20.88 19.38 51 0.409 3127K 3287 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.0 1.0 2.0 3.0 1.0 0.0 0.0 238.1 237.9 12.93 12.26 11 1.176 3127K 3287 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 356.8 7.94 7.12 40 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.8 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.77 GB write, 661.40 MB/s write, 3.01 GB read, 344.61 MB/s read, 20.9 seconds Interval compaction: 5.77 GB write, 673.53 MB/s write, 3.01 GB read, 350.93 MB/s read, 20.9 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: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 631315 Average: 2.0210 StdDev: 10.73 Min: 0 Median: 1.3858 Max: 3577 Percentiles: P50: 1.39 P75: 1.78 P99: 5.14 P99.9: 9.84 P99.99: 19.65 ------------------------------------------------------ [ 0, 1 ] 162279 25.705% 25.705% ##### ( 1, 2 ] 397590 62.978% 88.683% ############# ( 2, 3 ] 44070 6.981% 95.664% # ( 3, 4 ] 16269 2.577% 98.241% # ( 4, 6 ] 8382 1.328% 99.568% ( 6, 10 ] 2183 0.346% 99.914% ( 10, 15 ] 443 0.070% 99.984% ( 15, 22 ] 57 0.009% 99.993% ( 22, 34 ] 13 0.002% 99.995% ( 34, 51 ] 5 0.001% 99.996% ( 51, 76 ] 5 0.001% 99.997% ( 110, 170 ] 22 0.003% 100.000% ( 170, 250 ] 14 0.002% 100.003% ( 250, 380 ] 22 0.003% 100.006% ( 380, 580 ] 7 0.001% 100.007% ( 580, 870 ] 11 0.002% 100.009% ( 870, 1300 ] 7 0.001% 100.010% ( 1300, 1900 ] 4 0.001% 100.011% ( 1900, 2900 ] 4 0.001% 100.011% ( 2900, 4400 ] 2 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 146061 Average: 2.2117 StdDev: 8.63 Min: 0 Median: 1.5326 Max: 2408 Percentiles: P50: 1.53 P75: 1.90 P99: 5.54 P99.9: 11.12 P99.99: 55.92 ------------------------------------------------------ [ 0, 1 ] 20505 14.039% 14.039% ### ( 1, 2 ] 98621 67.520% 81.559% ############## ( 2, 3 ] 18097 12.390% 93.949% ## ( 3, 4 ] 5108 3.497% 97.446% # ( 4, 6 ] 2941 2.014% 99.460% ( 6, 10 ] 610 0.418% 99.877% ( 10, 15 ] 147 0.101% 99.978% ( 15, 22 ] 13 0.009% 99.987% ( 22, 34 ] 3 0.002% 99.989% ( 34, 51 ] 1 0.001% 99.990% ( 51, 76 ] 2 0.001% 99.991% ( 76, 110 ] 1 0.001% 99.992% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.994% ( 250, 380 ] 4 0.003% 99.997% ( 380, 580 ] 1 0.001% 99.997% ( 870, 1300 ] 2 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31714 Average: 2.7103 StdDev: 20.27 Min: 1 Median: 1.6347 Max: 2074 Percentiles: P50: 1.63 P75: 2.08 P99: 6.88 P99.9: 13.84 P99.99: 1465.72 ------------------------------------------------------ [ 0, 1 ] 2729 8.605% 8.605% ## ( 1, 2 ] 20685 65.224% 73.829% ############# ( 2, 3 ] 4571 14.413% 88.242% ### ( 3, 4 ] 1905 6.007% 94.249% # ( 4, 6 ] 1435 4.525% 98.773% # ( 6, 10 ] 325 1.025% 99.798% ( 10, 15 ] 42 0.132% 99.931% ( 15, 22 ] 9 0.028% 99.959% ( 51, 76 ] 2 0.006% 99.965% ( 110, 170 ] 1 0.003% 99.968% ( 170, 250 ] 1 0.003% 99.972% ( 250, 380 ] 1 0.003% 99.975% ( 380, 580 ] 1 0.003% 99.978% ( 580, 870 ] 3 0.009% 99.987% ( 1300, 1900 ] 3 0.009% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28852 Average: 4.6031 StdDev: 71.09 Min: 1 Median: 1.5668 Max: 3993 Percentiles: P50: 1.57 P75: 1.94 P99: 5.96 P99.9: 766.62 P99.99: 3678.70 ------------------------------------------------------ [ 0, 1 ] 3340 11.576% 11.576% ## ( 1, 2 ] 19559 67.791% 79.367% ############## ( 2, 3 ] 3982 13.801% 93.169% ### ( 3, 4 ] 1089 3.774% 96.943% # ( 4, 6 ] 606 2.100% 99.043% ( 6, 10 ] 116 0.402% 99.445% ( 10, 15 ] 39 0.135% 99.581% ( 15, 22 ] 8 0.028% 99.608% ( 22, 34 ] 32 0.111% 99.719% ( 34, 51 ] 23 0.080% 99.799% ( 51, 76 ] 2 0.007% 99.806% ( 76, 110 ] 2 0.007% 99.813% ( 110, 170 ] 6 0.021% 99.834% ( 170, 250 ] 2 0.007% 99.841% ( 250, 380 ] 6 0.021% 99.861% ( 380, 580 ] 6 0.021% 99.882% ( 580, 870 ] 8 0.028% 99.910% ( 870, 1300 ] 6 0.021% 99.931% ( 1300, 1900 ] 7 0.024% 99.955% ( 1900, 2900 ] 7 0.024% 99.979% ( 2900, 4400 ] 6 0.021% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1548.4000 StdDev: 1308.38 Min: 180 Median: 1146.4286 Max: 4680 Percentiles: P50: 1146.43 P75: 1750.00 P99: 4680.00 P99.9: 4680.00 P99.99: 4680.00 ------------------------------------------------------ ( 170, 250 ] 2 8.000% 8.000% ## ( 250, 380 ] 2 8.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 3 12.000% 32.000% ## ( 870, 1300 ] 7 28.000% 60.000% ###### ( 1300, 1900 ] 5 20.000% 80.000% #### ( 1900, 2900 ] 1 4.000% 84.000% # ( 2900, 4400 ] 2 8.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 858.6500 StdDev: 1179.86 Min: 91 Median: 161.4286 Max: 4228 Percentiles: P50: 161.43 P75: 1300.00 P99: 4100.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 76, 110 ] 4 20.000% 20.000% #### ( 110, 170 ] 7 35.000% 55.000% ####### ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.33 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.999 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, 329.86 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.404 H:M:S, 13.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/07-00:23:17 ... thread 0: (1000000,4000000) ops and (340038.9,341394.3) ops/second in (2.940840,11.716657) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/4 3.13 GB 289.5 2.8 0.0 2.8 6.5 3.7 0.0 1.7 133.3 310.9 21.26 19.96 63 0.338 2878K 3125 0.0 0.0 L1 1/0 3.81 MB 0.4 0.6 0.4 0.2 0.6 0.4 0.1 1.4 240.3 240.0 2.62 2.54 2 1.310 639K 861 0.0 0.0 L2 2/0 51.06 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 32/0 990.97 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 190.5 190.4 3.27 2.84 2 1.636 632K 533 0.0 0.0 L4 156/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1254/4 99.82 GB 0.0 4.1 1.0 3.1 7.8 4.7 1.5 2.1 152.1 288.4 27.70 25.86 68 0.407 4278K 4567 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.0 3.1 7.8 4.7 1.5 2.1 152.1 288.4 27.70 25.86 68 0.407 4278K 4567 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.1 1.0 3.1 4.1 1.0 0.0 0.0 245.4 245.1 17.17 16.43 15 1.145 4278K 4567 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 358.9 10.53 9.43 53 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 11.9 total, 11.7 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.80 GB write, 672.55 MB/s write, 4.12 GB read, 354.76 MB/s read, 27.7 seconds Interval compaction: 7.80 GB write, 681.79 MB/s write, 4.12 GB read, 359.63 MB/s read, 27.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 886797 Average: 1.9981 StdDev: 11.54 Min: 0 Median: 1.3709 Max: 3577 Percentiles: P50: 1.37 P75: 1.77 P99: 4.97 P99.9: 9.85 P99.99: 18.82 ------------------------------------------------------ [ 0, 1 ] 236299 26.646% 26.646% ##### ( 1, 2 ] 558432 62.972% 89.618% ############# ( 2, 3 ] 56996 6.427% 96.045% # ( 3, 4 ] 21243 2.395% 98.441% ( 4, 6 ] 10263 1.157% 99.598% ( 6, 10 ] 2783 0.314% 99.912% ( 10, 15 ] 648 0.073% 99.985% ( 15, 22 ] 83 0.009% 99.994% ( 22, 34 ] 14 0.002% 99.996% ( 34, 51 ] 6 0.001% 99.997% ( 51, 76 ] 6 0.001% 99.997% ( 76, 110 ] 1 0.000% 99.997% ( 110, 170 ] 28 0.003% 100.001% ( 170, 250 ] 20 0.002% 100.003% ( 250, 380 ] 30 0.003% 100.006% ( 380, 580 ] 10 0.001% 100.007% ( 580, 870 ] 14 0.002% 100.009% ( 870, 1300 ] 11 0.001% 100.010% ( 1300, 1900 ] 4 0.000% 100.011% ( 1900, 2900 ] 4 0.000% 100.011% ( 2900, 4400 ] 6 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 146061 Average: 2.2117 StdDev: 8.63 Min: 0 Median: 1.5326 Max: 2408 Percentiles: P50: 1.53 P75: 1.90 P99: 5.54 P99.9: 11.12 P99.99: 55.92 ------------------------------------------------------ [ 0, 1 ] 20505 14.039% 14.039% ### ( 1, 2 ] 98621 67.520% 81.559% ############## ( 2, 3 ] 18097 12.390% 93.949% ## ( 3, 4 ] 5108 3.497% 97.446% # ( 4, 6 ] 2941 2.014% 99.460% ( 6, 10 ] 610 0.418% 99.877% ( 10, 15 ] 147 0.101% 99.978% ( 15, 22 ] 13 0.009% 99.987% ( 22, 34 ] 3 0.002% 99.989% ( 34, 51 ] 1 0.001% 99.990% ( 51, 76 ] 2 0.001% 99.991% ( 76, 110 ] 1 0.001% 99.992% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.994% ( 250, 380 ] 4 0.003% 99.997% ( 380, 580 ] 1 0.001% 99.997% ( 870, 1300 ] 2 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31714 Average: 2.7103 StdDev: 20.27 Min: 1 Median: 1.6347 Max: 2074 Percentiles: P50: 1.63 P75: 2.08 P99: 6.88 P99.9: 13.84 P99.99: 1465.72 ------------------------------------------------------ [ 0, 1 ] 2729 8.605% 8.605% ## ( 1, 2 ] 20685 65.224% 73.829% ############# ( 2, 3 ] 4571 14.413% 88.242% ### ( 3, 4 ] 1905 6.007% 94.249% # ( 4, 6 ] 1435 4.525% 98.773% # ( 6, 10 ] 325 1.025% 99.798% ( 10, 15 ] 42 0.132% 99.931% ( 15, 22 ] 9 0.028% 99.959% ( 51, 76 ] 2 0.006% 99.965% ( 110, 170 ] 1 0.003% 99.968% ( 170, 250 ] 1 0.003% 99.972% ( 250, 380 ] 1 0.003% 99.975% ( 380, 580 ] 1 0.003% 99.978% ( 580, 870 ] 3 0.009% 99.987% ( 1300, 1900 ] 3 0.009% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28852 Average: 4.6031 StdDev: 71.09 Min: 1 Median: 1.5668 Max: 3993 Percentiles: P50: 1.57 P75: 1.94 P99: 5.96 P99.9: 766.62 P99.99: 3678.70 ------------------------------------------------------ [ 0, 1 ] 3340 11.576% 11.576% ## ( 1, 2 ] 19559 67.791% 79.367% ############## ( 2, 3 ] 3982 13.801% 93.169% ### ( 3, 4 ] 1089 3.774% 96.943% # ( 4, 6 ] 606 2.100% 99.043% ( 6, 10 ] 116 0.402% 99.445% ( 10, 15 ] 39 0.135% 99.581% ( 15, 22 ] 8 0.028% 99.608% ( 22, 34 ] 32 0.111% 99.719% ( 34, 51 ] 23 0.080% 99.799% ( 51, 76 ] 2 0.007% 99.806% ( 76, 110 ] 2 0.007% 99.813% ( 110, 170 ] 6 0.021% 99.834% ( 170, 250 ] 2 0.007% 99.841% ( 250, 380 ] 6 0.021% 99.861% ( 380, 580 ] 6 0.021% 99.882% ( 580, 870 ] 8 0.028% 99.910% ( 870, 1300 ] 6 0.021% 99.931% ( 1300, 1900 ] 7 0.024% 99.955% ( 1900, 2900 ] 7 0.024% 99.979% ( 2900, 4400 ] 6 0.021% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1548.4000 StdDev: 1308.38 Min: 180 Median: 1146.4286 Max: 4680 Percentiles: P50: 1146.43 P75: 1750.00 P99: 4680.00 P99.9: 4680.00 P99.99: 4680.00 ------------------------------------------------------ ( 170, 250 ] 2 8.000% 8.000% ## ( 250, 380 ] 2 8.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 3 12.000% 32.000% ## ( 870, 1300 ] 7 28.000% 60.000% ###### ( 1300, 1900 ] 5 20.000% 80.000% #### ( 1900, 2900 ] 1 4.000% 84.000% # ( 2900, 4400 ] 2 8.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 858.6500 StdDev: 1179.86 Min: 91 Median: 161.4286 Max: 4228 Percentiles: P50: 161.43 P75: 1300.00 P99: 4100.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 76, 110 ] 4 20.000% 20.000% #### ( 110, 170 ] 7 35.000% 55.000% ####### ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 11.9 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 331.40 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.352 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 334.66 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.353 H:M:S, 12.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/07-00:23:21 ... thread 0: (1000000,5000000) ops and (302942.5,332942.4) ops/second in (3.300956,15.017613) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/17 4.12 GB 6.3 3.9 0.0 3.9 8.5 4.7 0.0 1.8 140.4 309.6 28.27 26.61 82 0.345 4029K 4341 0.0 0.0 L1 1/1 3.81 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 240.3 240.0 2.62 2.54 2 1.310 639K 861 0.0 0.0 L2 2/0 51.06 MB 0.5 0.1 0.1 0.1 0.1 0.1 0.5 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 32/0 990.97 MB 1.0 0.6 0.5 0.1 0.6 0.5 0.1 1.2 190.5 190.4 3.27 2.84 2 1.636 632K 533 0.0 0.0 L4 156/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1257/18 100.81 GB 0.0 5.2 1.0 4.2 9.9 5.7 1.5 2.1 154.1 291.9 34.71 32.51 87 0.399 5430K 5783 0.0 0.0 Int 0/0 0.00 KB 0.0 5.2 1.0 4.2 9.9 5.7 1.5 2.1 154.1 291.9 34.71 32.51 87 0.399 5430K 5783 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.2 1.0 4.2 5.2 1.0 0.0 0.0 249.6 249.3 21.42 20.61 19 1.128 5430K 5783 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 360.5 13.28 11.91 68 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.2 total, 15.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.89 GB write, 667.32 MB/s write, 5.22 GB read, 352.31 MB/s read, 34.7 seconds Interval compaction: 9.89 GB write, 674.47 MB/s write, 5.22 GB read, 356.09 MB/s read, 34.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 14, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1168699 Average: 2.0013 StdDev: 10.80 Min: 0 Median: 1.3592 Max: 3577 Percentiles: P50: 1.36 P75: 1.76 P99: 4.82 P99.9: 10.40 P99.99: 137.20 ------------------------------------------------------ [ 0, 1 ] 319994 27.380% 27.380% ##### ( 1, 2 ] 735925 62.970% 90.350% ############# ( 2, 3 ] 70090 5.997% 96.347% # ( 3, 4 ] 26042 2.228% 98.576% ( 4, 6 ] 12053 1.031% 99.607% ( 6, 10 ] 3364 0.288% 99.895% ( 10, 15 ] 799 0.068% 99.963% ( 15, 22 ] 105 0.009% 99.972% ( 22, 34 ] 17 0.001% 99.973% ( 34, 51 ] 9 0.001% 99.974% ( 51, 76 ] 15 0.001% 99.976% ( 76, 110 ] 113 0.010% 99.985% ( 110, 170 ] 126 0.011% 99.996% ( 170, 250 ] 49 0.004% 100.000% ( 250, 380 ] 44 0.004% 100.004% ( 380, 580 ] 29 0.002% 100.006% ( 580, 870 ] 27 0.002% 100.009% ( 870, 1300 ] 13 0.001% 100.010% ( 1300, 1900 ] 4 0.000% 100.010% ( 1900, 2900 ] 4 0.000% 100.011% ( 2900, 4400 ] 6 0.001% 100.011% ** Level 1 read latency histogram (micros): Count: 146062 Average: 2.2149 StdDev: 8.71 Min: 0 Median: 1.5326 Max: 2408 Percentiles: P50: 1.53 P75: 1.90 P99: 5.54 P99.9: 11.15 P99.99: 68.42 ------------------------------------------------------ [ 0, 1 ] 20505 14.039% 14.039% ### ( 1, 2 ] 98621 67.520% 81.559% ############## ( 2, 3 ] 18097 12.390% 93.948% ## ( 3, 4 ] 5108 3.497% 97.446% # ( 4, 6 ] 2941 2.014% 99.459% ( 6, 10 ] 610 0.418% 99.877% ( 10, 15 ] 147 0.101% 99.977% ( 15, 22 ] 13 0.009% 99.986% ( 22, 34 ] 3 0.002% 99.988% ( 34, 51 ] 1 0.001% 99.989% ( 51, 76 ] 2 0.001% 99.990% ( 76, 110 ] 1 0.001% 99.991% ( 110, 170 ] 1 0.001% 99.992% ( 170, 250 ] 2 0.001% 99.993% ( 250, 380 ] 4 0.003% 99.996% ( 380, 580 ] 2 0.001% 99.997% ( 870, 1300 ] 2 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 31714 Average: 2.7103 StdDev: 20.27 Min: 1 Median: 1.6347 Max: 2074 Percentiles: P50: 1.63 P75: 2.08 P99: 6.88 P99.9: 13.84 P99.99: 1465.72 ------------------------------------------------------ [ 0, 1 ] 2729 8.605% 8.605% ## ( 1, 2 ] 20685 65.224% 73.829% ############# ( 2, 3 ] 4571 14.413% 88.242% ### ( 3, 4 ] 1905 6.007% 94.249% # ( 4, 6 ] 1435 4.525% 98.773% # ( 6, 10 ] 325 1.025% 99.798% ( 10, 15 ] 42 0.132% 99.931% ( 15, 22 ] 9 0.028% 99.959% ( 51, 76 ] 2 0.006% 99.965% ( 110, 170 ] 1 0.003% 99.968% ( 170, 250 ] 1 0.003% 99.972% ( 250, 380 ] 1 0.003% 99.975% ( 380, 580 ] 1 0.003% 99.978% ( 580, 870 ] 3 0.009% 99.987% ( 1300, 1900 ] 3 0.009% 99.997% ( 1900, 2900 ] 1 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 28852 Average: 4.6031 StdDev: 71.09 Min: 1 Median: 1.5668 Max: 3993 Percentiles: P50: 1.57 P75: 1.94 P99: 5.96 P99.9: 766.62 P99.99: 3678.70 ------------------------------------------------------ [ 0, 1 ] 3340 11.576% 11.576% ## ( 1, 2 ] 19559 67.791% 79.367% ############## ( 2, 3 ] 3982 13.801% 93.169% ### ( 3, 4 ] 1089 3.774% 96.943% # ( 4, 6 ] 606 2.100% 99.043% ( 6, 10 ] 116 0.402% 99.445% ( 10, 15 ] 39 0.135% 99.581% ( 15, 22 ] 8 0.028% 99.608% ( 22, 34 ] 32 0.111% 99.719% ( 34, 51 ] 23 0.080% 99.799% ( 51, 76 ] 2 0.007% 99.806% ( 76, 110 ] 2 0.007% 99.813% ( 110, 170 ] 6 0.021% 99.834% ( 170, 250 ] 2 0.007% 99.841% ( 250, 380 ] 6 0.021% 99.861% ( 380, 580 ] 6 0.021% 99.882% ( 580, 870 ] 8 0.028% 99.910% ( 870, 1300 ] 6 0.021% 99.931% ( 1300, 1900 ] 7 0.024% 99.955% ( 1900, 2900 ] 7 0.024% 99.979% ( 2900, 4400 ] 6 0.021% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1548.4000 StdDev: 1308.38 Min: 180 Median: 1146.4286 Max: 4680 Percentiles: P50: 1146.43 P75: 1750.00 P99: 4680.00 P99.9: 4680.00 P99.99: 4680.00 ------------------------------------------------------ ( 170, 250 ] 2 8.000% 8.000% ## ( 250, 380 ] 2 8.000% 16.000% ## ( 380, 580 ] 1 4.000% 20.000% # ( 580, 870 ] 3 12.000% 32.000% ## ( 870, 1300 ] 7 28.000% 60.000% ###### ( 1300, 1900 ] 5 20.000% 80.000% #### ( 1900, 2900 ] 1 4.000% 84.000% # ( 2900, 4400 ] 2 8.000% 92.000% ## ( 4400, 6600 ] 2 8.000% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 858.6500 StdDev: 1179.86 Min: 91 Median: 161.4286 Max: 4228 Percentiles: P50: 161.43 P75: 1300.00 P99: 4100.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 76, 110 ] 4 20.000% 20.000% #### ( 110, 170 ] 7 35.000% 55.000% ####### ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.2 total, 3.3 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 324.17 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.023 H:M:S, 13.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 298.16 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.671 H:M:S, 20.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/07-00:23:42 ... thread 0: (1000000,6000000) ops and (46100.9,163447.0) ops/second in (21.691540,36.709153) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/8 1007.41 MB 0.0 4.4 0.0 4.4 10.0 5.6 0.0 1.8 129.1 294.4 34.65 31.05 97 0.357 4541K 4830 0.0 0.0 L1 6/6 501.06 MB 0.0 4.7 4.5 0.2 4.6 4.4 0.1 1.0 226.3 222.4 21.16 19.50 3 7.052 4860K 82K 0.0 0.0 L2 1/1 1.10 MB 0.0 0.1 0.1 0.1 0.1 0.1 4.0 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 33/18 2.69 GB 1.1 1.4 1.1 0.3 1.4 1.1 3.0 1.2 137.3 137.0 10.53 6.89 8 1.316 1022K 586 0.0 0.0 L4 185/22 11.41 GB 1.1 1.7 1.4 0.2 1.7 1.4 0.8 1.2 106.1 105.7 16.23 8.25 13 1.249 1696K 6072 0.0 0.0 L5 1048/0 86.06 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1281/55 101.64 GB 0.0 12.3 7.1 5.1 17.8 12.6 8.2 3.2 151.0 218.8 83.12 66.20 122 0.681 12M 94K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.3 7.1 5.1 17.8 12.6 8.2 3.2 151.0 218.8 83.12 66.20 122 0.681 12M 94K 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 12.3 7.1 5.1 12.2 7.0 0.0 0.0 192.1 190.6 65.35 51.73 41 1.594 12M 94K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 322.6 17.77 14.47 81 0.219 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): 36.9 total, 36.7 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.76 GB write, 493.30 MB/s write, 12.26 GB read, 340.50 MB/s read, 83.1 seconds Interval compaction: 17.76 GB write, 495.46 MB/s write, 12.26 GB read, 341.99 MB/s read, 83.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 31, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 31, interval: 42 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2462679 Average: 2.6772 StdDev: 36.60 Min: 0 Median: 1.3433 Max: 40787 Percentiles: P50: 1.34 P75: 1.75 P99: 5.89 P99.9: 152.87 P99.99: 543.34 ------------------------------------------------------ [ 0, 1 ] 713467 28.971% 28.971% ###### ( 1, 2 ] 1508380 61.250% 90.221% ############ ( 2, 3 ] 126412 5.133% 95.354% # ( 3, 4 ] 53737 2.182% 97.536% ( 4, 6 ] 38157 1.549% 99.085% ( 6, 10 ] 8987 0.365% 99.450% ( 10, 15 ] 2353 0.096% 99.546% ( 15, 22 ] 607 0.025% 99.570% ( 22, 34 ] 24 0.001% 99.571% ( 34, 51 ] 14 0.001% 99.572% ( 51, 76 ] 769 0.031% 99.603% ( 76, 110 ] 4788 0.194% 99.798% ( 110, 170 ] 3530 0.143% 99.941% ( 170, 250 ] 512 0.021% 99.962% ( 250, 380 ] 397 0.016% 99.978% ( 380, 580 ] 367 0.015% 99.993% ( 580, 870 ] 173 0.007% 100.000% ( 870, 1300 ] 71 0.003% 100.003% ( 1300, 1900 ] 35 0.001% 100.004% ( 1900, 2900 ] 43 0.002% 100.006% ( 2900, 4400 ] 44 0.002% 100.008% ( 4400, 6600 ] 9 0.000% 100.008% ( 6600, 9900 ] 2 0.000% 100.008% ( 33000, 50000 ] 1 0.000% 100.008% ** Level 1 read latency histogram (micros): Count: 654818 Average: 7.2259 StdDev: 133.51 Min: 0 Median: 1.8709 Max: 43908 Percentiles: P50: 1.87 P75: 2.81 P99: 8.74 P99.9: 14.32 P99.99: 21.04 ------------------------------------------------------ [ 0, 1 ] 27628 4.219% 4.219% # ( 1, 2 ] 344229 52.569% 56.788% ########### ( 2, 3 ] 146404 22.358% 79.146% #### ( 3, 4 ] 61874 9.449% 88.595% ## ( 4, 6 ] 59696 9.116% 97.711% ## ( 6, 10 ] 12310 1.880% 99.591% ( 10, 15 ] 2345 0.358% 99.949% ( 15, 22 ] 311 0.047% 99.997% ( 22, 34 ] 42 0.006% 100.003% ( 34, 51 ] 15 0.002% 100.005% ( 51, 76 ] 33 0.005% 100.011% ( 76, 110 ] 61 0.009% 100.020% ( 110, 170 ] 61 0.009% 100.029% ( 170, 250 ] 71 0.011% 100.040% ( 250, 380 ] 177 0.027% 100.067% ( 380, 580 ] 262 0.040% 100.107% ( 580, 870 ] 253 0.039% 100.146% ( 870, 1300 ] 227 0.035% 100.180% ( 1300, 1900 ] 157 0.024% 100.204% ( 1900, 2900 ] 208 0.032% 100.236% ( 2900, 4400 ] 229 0.035% 100.271% ( 4400, 6600 ] 66 0.010% 100.281% ( 6600, 9900 ] 33 0.005% 100.286% ( 9900, 14000 ] 4 0.001% 100.287% ( 14000, 22000 ] 3 0.000% 100.287% ( 33000, 50000 ] 1 0.000% 100.287% ** Level 2 read latency histogram (micros): Count: 31847 Average: 5.2793 StdDev: 88.07 Min: 1 Median: 1.6374 Max: 6924 Percentiles: P50: 1.64 P75: 2.10 P99: 7.68 P99.9: 915.07 P99.99: 4353.82 ------------------------------------------------------ [ 0, 1 ] 2729 8.569% 8.569% ## ( 1, 2 ] 20699 64.995% 73.564% ############# ( 2, 3 ] 4601 14.447% 88.011% ### ( 3, 4 ] 1917 6.019% 94.031% # ( 4, 6 ] 1445 4.537% 98.568% # ( 6, 10 ] 327 1.027% 99.595% ( 10, 15 ] 42 0.132% 99.727% ( 15, 22 ] 10 0.031% 99.758% ( 51, 76 ] 2 0.006% 99.764% ( 110, 170 ] 3 0.009% 99.774% ( 170, 250 ] 4 0.013% 99.786% ( 250, 380 ] 10 0.031% 99.818% ( 380, 580 ] 17 0.053% 99.871% ( 580, 870 ] 8 0.025% 99.896% ( 870, 1300 ] 11 0.035% 99.931% ( 1300, 1900 ] 7 0.022% 99.953% ( 1900, 2900 ] 6 0.019% 99.972% ( 2900, 4400 ] 6 0.019% 99.991% ( 4400, 6600 ] 1 0.003% 99.994% ( 6600, 9900 ] 2 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 306791 Average: 19.5638 StdDev: 247.23 Min: 1 Median: 1.9060 Max: 45452 Percentiles: P50: 1.91 P75: 2.91 P99: 313.39 P99.9: 2156.57 P99.99: 3009.67 ------------------------------------------------------ [ 0, 1 ] 9286 3.027% 3.027% # ( 1, 2 ] 159056 51.845% 54.872% ########## ( 2, 3 ] 68067 22.187% 77.059% #### ( 3, 4 ] 31596 10.299% 87.358% ## ( 4, 6 ] 27212 8.870% 96.227% ## ( 6, 10 ] 6466 2.108% 98.335% ( 10, 15 ] 1167 0.380% 98.715% ( 15, 22 ] 174 0.057% 98.772% ( 22, 34 ] 53 0.017% 98.789% ( 34, 51 ] 39 0.013% 98.802% ( 51, 76 ] 7 0.002% 98.804% ( 76, 110 ] 26 0.008% 98.813% ( 110, 170 ] 123 0.040% 98.853% ( 170, 250 ] 220 0.072% 98.925% ( 250, 380 ] 476 0.155% 99.080% ( 380, 580 ] 727 0.237% 99.317% ( 580, 870 ] 853 0.278% 99.595% ( 870, 1300 ] 546 0.178% 99.773% ( 1300, 1900 ] 305 0.099% 99.872% ( 1900, 2900 ] 336 0.110% 99.982% ( 2900, 4400 ] 360 0.117% 100.099% ( 4400, 6600 ] 75 0.024% 100.124% ( 6600, 9900 ] 21 0.007% 100.130% ( 9900, 14000 ] 2 0.001% 100.131% ( 14000, 22000 ] 8 0.003% 100.134% ( 22000, 33000 ] 4 0.001% 100.135% ( 33000, 50000 ] 1 0.000% 100.135% ** Level 4 read latency histogram (micros): Count: 40098 Average: 5.3516 StdDev: 72.18 Min: 1 Median: 2.0778 Max: 4886 Percentiles: P50: 2.08 P75: 2.99 P99: 9.97 P99.9: 4886.00 P99.99: 4886.00 ------------------------------------------------------ [ 0, 1 ] 326 0.813% 0.813% ( 1, 2 ] 18864 47.045% 47.858% ######### ( 2, 3 ] 11035 27.520% 75.378% ###### ( 3, 4 ] 4469 11.145% 86.523% ## ( 4, 6 ] 4324 10.784% 97.307% ## ( 6, 10 ] 684 1.706% 99.012% ( 10, 15 ] 196 0.489% 99.501% ( 15, 22 ] 23 0.057% 99.559% ( 22, 34 ] 6 0.015% 99.574% ( 34, 51 ] 3 0.007% 99.581% ( 51, 76 ] 1 0.002% 99.584% ( 76, 110 ] 3 0.007% 99.591% ( 110, 170 ] 11 0.027% 99.618% ( 170, 250 ] 19 0.047% 99.666% ( 250, 380 ] 9 0.022% 99.688% ( 380, 580 ] 6 0.015% 99.703% ( 580, 870 ] 7 0.017% 99.721% ( 870, 1300 ] 15 0.037% 99.758% ( 1300, 1900 ] 12 0.030% 99.788% ( 1900, 2900 ] 6 0.015% 99.803% ( 2900, 4400 ] 5 0.012% 99.815% ( 4400, 6600 ] 3 0.007% 99.823% ** Level 5 read latency histogram (micros): Count: 20 Average: 858.6500 StdDev: 1179.86 Min: 91 Median: 161.4286 Max: 4228 Percentiles: P50: 161.43 P75: 1300.00 P99: 4100.00 P99.9: 4228.00 P99.99: 4228.00 ------------------------------------------------------ ( 76, 110 ] 4 20.000% 20.000% #### ( 110, 170 ] 7 35.000% 55.000% ####### ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 1 5.000% 65.000% # ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 1 5.000% 80.000% # ( 1900, 2900 ] 3 15.000% 95.000% ### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 36.9 total, 21.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 160.15 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:20.392 H:M:S, 55.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 45.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:18.369 H:M:S, 84.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/11/07-00:23:46 ... thread 0: (1000000,7000000) ops and (247556.9,171784.9) ops/second in (4.039476,40.748629) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/4 1.35 GB 107.0 5.3 0.0 5.3 11.9 6.6 0.0 1.8 127.3 285.6 42.55 37.32 113 0.377 5500K 5984 0.0 0.0 L1 7/0 648.99 MB 64.9 5.8 5.1 0.7 5.7 5.0 0.1 1.1 209.8 206.7 28.20 24.59 4 7.051 5499K 82K 0.0 0.0 L2 5/4 298.08 MB 0.6 0.1 0.1 0.1 0.1 0.1 4.4 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 17/4 1.11 GB 0.6 2.3 1.1 1.1 2.3 1.1 3.2 2.0 141.3 141.1 16.38 10.56 9 1.819 1904K 1700 0.0 0.0 L4 155/0 9.53 GB 1.0 3.0 2.3 0.7 3.0 2.3 1.6 1.3 112.0 111.6 27.70 14.80 21 1.319 3098K 11K 0.0 0.0 L5 1092/0 89.69 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/12 102.61 GB 0.0 16.5 8.6 7.8 23.0 15.1 13.3 3.5 146.3 203.8 115.37 87.79 148 0.780 16M 101K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.5 8.6 7.8 23.0 15.1 13.3 3.5 146.3 203.8 115.37 87.79 148 0.780 16M 101K 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.5 8.6 7.8 16.4 8.5 0.0 0.0 180.1 178.9 93.73 70.72 54 1.736 16M 101K 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 311.5 21.64 17.06 94 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): 40.9 total, 40.7 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.96 GB write, 574.62 MB/s write, 16.48 GB read, 412.57 MB/s read, 115.4 seconds Interval compaction: 22.96 GB write, 576.89 MB/s write, 16.48 GB read, 414.20 MB/s read, 115.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 43, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 43, interval: 54 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2738291 Average: 2.7367 StdDev: 36.76 Min: 0 Median: 1.3781 Max: 40787 Percentiles: P50: 1.38 P75: 1.79 P99: 5.99 P99.9: 150.89 P99.99: 545.32 ------------------------------------------------------ [ 0, 1 ] 736299 26.889% 26.889% ##### ( 1, 2 ] 1673885 61.129% 88.018% ############ ( 2, 3 ] 174690 6.380% 94.397% # ( 3, 4 ] 72075 2.632% 97.029% # ( 4, 6 ] 54274 1.982% 99.012% ( 6, 10 ] 12552 0.458% 99.470% ( 10, 15 ] 3072 0.112% 99.582% ( 15, 22 ] 678 0.025% 99.607% ( 22, 34 ] 26 0.001% 99.608% ( 34, 51 ] 16 0.001% 99.608% ( 51, 76 ] 769 0.028% 99.636% ( 76, 110 ] 4793 0.175% 99.811% ( 110, 170 ] 3558 0.130% 99.941% ( 170, 250 ] 554 0.020% 99.962% ( 250, 380 ] 430 0.016% 99.977% ( 380, 580 ] 420 0.015% 99.993% ( 580, 870 ] 206 0.008% 100.000% ( 870, 1300 ] 102 0.004% 100.004% ( 1300, 1900 ] 50 0.002% 100.006% ( 1900, 2900 ] 56 0.002% 100.008% ( 2900, 4400 ] 51 0.002% 100.010% ( 4400, 6600 ] 13 0.000% 100.010% ( 6600, 9900 ] 2 0.000% 100.010% ( 33000, 50000 ] 1 0.000% 100.010% ** Level 1 read latency histogram (micros): Count: 989100 Average: 7.2472 StdDev: 126.26 Min: 0 Median: 1.8773 Max: 43908 Percentiles: P50: 1.88 P75: 2.81 P99: 9.11 P99.9: 21.67 P99.99: 285.60 ------------------------------------------------------ [ 0, 1 ] 36765 3.717% 3.717% # ( 1, 2 ] 521835 52.759% 56.476% ########### ( 2, 3 ] 226829 22.933% 79.408% ##### ( 3, 4 ] 89862 9.085% 88.494% ## ( 4, 6 ] 87617 8.858% 97.352% ## ( 6, 10 ] 20962 2.119% 99.471% ( 10, 15 ] 3767 0.381% 99.852% ( 15, 22 ] 497 0.050% 99.902% ( 22, 34 ] 53 0.005% 99.908% ( 34, 51 ] 25 0.003% 99.910% ( 51, 76 ] 57 0.006% 99.916% ( 76, 110 ] 162 0.016% 99.932% ( 110, 170 ] 255 0.026% 99.958% ( 170, 250 ] 225 0.023% 99.981% ( 250, 380 ] 329 0.033% 100.014% ( 380, 580 ] 439 0.044% 100.059% ( 580, 870 ] 458 0.046% 100.105% ( 870, 1300 ] 337 0.034% 100.139% ( 1300, 1900 ] 226 0.023% 100.162% ( 1900, 2900 ] 312 0.032% 100.193% ( 2900, 4400 ] 341 0.034% 100.228% ( 4400, 6600 ] 105 0.011% 100.238% ( 6600, 9900 ] 42 0.004% 100.243% ( 9900, 14000 ] 4 0.000% 100.243% ( 14000, 22000 ] 3 0.000% 100.243% ( 33000, 50000 ] 1 0.000% 100.243% ** Level 2 read latency histogram (micros): Count: 60238 Average: 5.3093 StdDev: 78.17 Min: 1 Median: 1.6565 Max: 6924 Percentiles: P50: 1.66 P75: 2.19 P99: 8.91 P99.9: 794.62 P99.99: 4020.54 ------------------------------------------------------ [ 0, 1 ] 4665 7.744% 7.744% ## ( 1, 2 ] 38771 64.363% 72.107% ############# ( 2, 3 ] 9362 15.542% 87.649% ### ( 3, 4 ] 3651 6.061% 93.710% # ( 4, 6 ] 2528 4.197% 97.907% # ( 6, 10 ] 905 1.502% 99.409% ( 10, 15 ] 87 0.144% 99.553% ( 15, 22 ] 13 0.022% 99.575% ( 22, 34 ] 1 0.002% 99.577% ( 51, 76 ] 2 0.003% 99.580% ( 76, 110 ] 15 0.025% 99.605% ( 110, 170 ] 64 0.106% 99.711% ( 170, 250 ] 30 0.050% 99.761% ( 250, 380 ] 31 0.051% 99.812% ( 380, 580 ] 35 0.058% 99.871% ( 580, 870 ] 24 0.040% 99.910% ( 870, 1300 ] 21 0.035% 99.945% ( 1300, 1900 ] 10 0.017% 99.962% ( 1900, 2900 ] 11 0.018% 99.980% ( 2900, 4400 ] 8 0.013% 99.993% ( 4400, 6600 ] 2 0.003% 99.997% ( 6600, 9900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 441226 Average: 17.6043 StdDev: 224.42 Min: 1 Median: 1.9027 Max: 45452 Percentiles: P50: 1.90 P75: 2.90 P99: 159.57 P99.9: 2038.62 P99.99: 2999.82 ------------------------------------------------------ [ 0, 1 ] 13056 2.959% 2.959% # ( 1, 2 ] 229924 52.110% 55.069% ########## ( 2, 3 ] 97687 22.140% 77.209% #### ( 3, 4 ] 44819 10.158% 87.367% ## ( 4, 6 ] 39212 8.887% 96.254% ## ( 6, 10 ] 9870 2.237% 98.491% ( 10, 15 ] 1743 0.395% 98.886% ( 15, 22 ] 240 0.054% 98.940% ( 22, 34 ] 57 0.013% 98.953% ( 34, 51 ] 40 0.009% 98.962% ( 51, 76 ] 9 0.002% 98.964% ( 76, 110 ] 32 0.007% 98.972% ( 110, 170 ] 151 0.034% 99.006% ( 170, 250 ] 262 0.059% 99.065% ( 250, 380 ] 558 0.126% 99.192% ( 380, 580 ] 898 0.204% 99.395% ( 580, 870 ] 1043 0.236% 99.632% ( 870, 1300 ] 715 0.162% 99.794% ( 1300, 1900 ] 410 0.093% 99.887% ( 1900, 2900 ] 424 0.096% 99.983% ( 2900, 4400 ] 479 0.109% 100.091% ( 4400, 6600 ] 99 0.022% 100.114% ( 6600, 9900 ] 27 0.006% 100.120% ( 9900, 14000 ] 2 0.000% 100.120% ( 14000, 22000 ] 8 0.002% 100.122% ( 22000, 33000 ] 4 0.001% 100.123% ( 33000, 50000 ] 1 0.000% 100.123% ** Level 4 read latency histogram (micros): Count: 84670 Average: 8.6010 StdDev: 100.51 Min: 1 Median: 2.0318 Max: 6164 Percentiles: P50: 2.03 P75: 2.97 P99: 12.54 P99.9: 3608.13 P99.99: 6164.00 ------------------------------------------------------ [ 0, 1 ] 864 1.020% 1.020% ( 1, 2 ] 40757 48.136% 49.157% ########## ( 2, 3 ] 22449 26.514% 75.670% ##### ( 3, 4 ] 8963 10.586% 86.256% ## ( 4, 6 ] 8752 10.337% 96.593% ## ( 6, 10 ] 1850 2.185% 98.778% ( 10, 15 ] 371 0.438% 99.216% ( 15, 22 ] 42 0.050% 99.265% ( 22, 34 ] 7 0.008% 99.274% ( 34, 51 ] 4 0.005% 99.278% ( 51, 76 ] 3 0.004% 99.282% ( 76, 110 ] 9 0.011% 99.293% ( 110, 170 ] 34 0.040% 99.333% ( 170, 250 ] 73 0.086% 99.419% ( 250, 380 ] 57 0.067% 99.486% ( 380, 580 ] 89 0.105% 99.591% ( 580, 870 ] 99 0.117% 99.708% ( 870, 1300 ] 83 0.098% 99.806% ( 1300, 1900 ] 39 0.046% 99.852% ( 1900, 2900 ] 29 0.034% 99.887% ( 2900, 4400 ] 24 0.028% 99.915% ( 4400, 6600 ] 4 0.005% 99.920% ** Level 5 read latency histogram (micros): Count: 240 Average: 1509.0083 StdDev: 1570.41 Min: 81 Median: 853.8889 Max: 7263 Percentiles: P50: 853.89 P75: 2492.59 P99: 6537.14 P99.9: 7263.00 P99.99: 7263.00 ------------------------------------------------------ ( 76, 110 ] 16 6.667% 6.667% # ( 110, 170 ] 25 10.417% 17.083% ## ( 170, 250 ] 11 4.583% 21.667% # ( 250, 380 ] 33 13.750% 35.417% ### ( 380, 580 ] 18 7.500% 42.917% ## ( 580, 870 ] 18 7.500% 50.417% ## ( 870, 1300 ] 24 10.000% 60.417% ## ( 1300, 1900 ] 19 7.917% 68.333% ## ( 1900, 2900 ] 27 11.250% 79.583% ## ( 2900, 4400 ] 33 13.750% 93.333% ### ( 4400, 6600 ] 14 5.833% 99.167% # ( 6600, 9900 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 40.9 total, 4.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 168.40 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:21.746 H:M:S, 53.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 243.64 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.354 H:M:S, 33.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/11/07-00:23:50 ... thread 0: (1000000,8000000) ops and (294596.8,181228.8) ops/second in (3.394470,44.143099) 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.34 GB 207.6 6.2 0.0 6.2 13.8 7.6 0.0 1.8 128.7 285.3 49.44 43.59 129 0.383 6460K 7079 0.0 0.0 L1 7/0 648.99 MB 64.9 5.8 5.1 0.7 5.7 5.0 0.1 1.1 209.8 206.7 28.20 24.59 4 7.051 5499K 82K 0.0 0.0 L2 1/0 59.52 MB 0.6 0.1 0.1 0.1 0.1 0.1 4.4 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 19/0 971.89 MB 1.0 3.0 1.4 1.6 3.0 1.4 3.2 2.2 150.4 150.0 20.40 14.06 13 1.569 2670K 4984 0.0 0.0 L4 155/0 9.61 GB 1.0 3.5 2.7 0.8 3.5 2.7 1.6 1.3 117.9 117.4 30.48 17.01 27 1.129 3577K 12K 0.0 0.0 L5 1096/0 90.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/4 103.59 GB 0.0 18.6 9.3 9.4 26.1 16.7 13.7 3.4 147.7 206.8 129.07 99.76 174 0.742 18M 107K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.6 9.3 9.4 26.1 16.7 13.7 3.4 147.7 206.8 129.07 99.76 174 0.742 18M 107K 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 18.6 9.3 9.4 18.5 9.1 0.0 0.0 182.8 181.6 104.32 80.11 67 1.557 18M 107K 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 313.2 24.74 19.65 107 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): 44.3 total, 44.1 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.07 GB write, 602.56 MB/s write, 18.62 GB read, 430.33 MB/s read, 129.1 seconds Interval compaction: 26.07 GB write, 604.76 MB/s write, 18.62 GB read, 431.90 MB/s read, 129.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 51, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 51, interval: 62 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2995959 Average: 2.6925 StdDev: 35.27 Min: 0 Median: 1.3882 Max: 40787 Percentiles: P50: 1.39 P75: 1.80 P99: 5.96 P99.9: 146.52 P99.99: 523.32 ------------------------------------------------------ [ 0, 1 ] 786379 26.248% 26.248% ##### ( 1, 2 ] 1833171 61.188% 87.436% ############ ( 2, 3 ] 201675 6.732% 94.168% # ( 3, 4 ] 83489 2.787% 96.954% # ( 4, 6 ] 62676 2.092% 99.046% ( 6, 10 ] 13682 0.457% 99.503% ( 10, 15 ] 3384 0.113% 99.616% ( 15, 22 ] 720 0.024% 99.640% ( 22, 34 ] 35 0.001% 99.641% ( 34, 51 ] 18 0.001% 99.642% ( 51, 76 ] 773 0.026% 99.668% ( 76, 110 ] 4793 0.160% 99.828% ( 110, 170 ] 3564 0.119% 99.947% ( 170, 250 ] 561 0.019% 99.965% ( 250, 380 ] 438 0.015% 99.980% ( 380, 580 ] 422 0.014% 99.994% ( 580, 870 ] 207 0.007% 100.001% ( 870, 1300 ] 106 0.004% 100.004% ( 1300, 1900 ] 53 0.002% 100.006% ( 1900, 2900 ] 57 0.002% 100.008% ( 2900, 4400 ] 52 0.002% 100.010% ( 4400, 6600 ] 13 0.000% 100.010% ( 6600, 9900 ] 2 0.000% 100.010% ( 33000, 50000 ] 1 0.000% 100.010% ** Level 1 read latency histogram (micros): Count: 1151762 Average: 6.6852 StdDev: 117.17 Min: 0 Median: 1.8802 Max: 43908 Percentiles: P50: 1.88 P75: 2.80 P99: 9.04 P99.9: 15.26 P99.99: 154.63 ------------------------------------------------------ [ 0, 1 ] 38883 3.376% 3.376% # ( 1, 2 ] 610095 52.971% 56.347% ########### ( 2, 3 ] 266904 23.174% 79.520% ##### ( 3, 4 ] 104432 9.067% 88.587% ## ( 4, 6 ] 100986 8.768% 97.355% ## ( 6, 10 ] 24914 2.163% 99.518% ( 10, 15 ] 4376 0.380% 99.898% ( 15, 22 ] 549 0.048% 99.946% ( 22, 34 ] 54 0.005% 99.951% ( 34, 51 ] 25 0.002% 99.953% ( 51, 76 ] 57 0.005% 99.958% ( 76, 110 ] 168 0.015% 99.972% ( 110, 170 ] 274 0.024% 99.996% ( 170, 250 ] 255 0.022% 100.018% ( 250, 380 ] 370 0.032% 100.050% ( 380, 580 ] 472 0.041% 100.091% ( 580, 870 ] 483 0.042% 100.133% ( 870, 1300 ] 346 0.030% 100.163% ( 1300, 1900 ] 227 0.020% 100.183% ( 1900, 2900 ] 313 0.027% 100.210% ( 2900, 4400 ] 341 0.030% 100.240% ( 4400, 6600 ] 105 0.009% 100.249% ( 6600, 9900 ] 42 0.004% 100.253% ( 9900, 14000 ] 4 0.000% 100.253% ( 14000, 22000 ] 3 0.000% 100.253% ( 33000, 50000 ] 1 0.000% 100.253% ** Level 2 read latency histogram (micros): Count: 60238 Average: 5.3093 StdDev: 78.17 Min: 1 Median: 1.6565 Max: 6924 Percentiles: P50: 1.66 P75: 2.19 P99: 8.91 P99.9: 794.62 P99.99: 4020.54 ------------------------------------------------------ [ 0, 1 ] 4665 7.744% 7.744% ## ( 1, 2 ] 38771 64.363% 72.107% ############# ( 2, 3 ] 9362 15.542% 87.649% ### ( 3, 4 ] 3651 6.061% 93.710% # ( 4, 6 ] 2528 4.197% 97.907% # ( 6, 10 ] 905 1.502% 99.409% ( 10, 15 ] 87 0.144% 99.553% ( 15, 22 ] 13 0.022% 99.575% ( 22, 34 ] 1 0.002% 99.577% ( 51, 76 ] 2 0.003% 99.580% ( 76, 110 ] 15 0.025% 99.605% ( 110, 170 ] 64 0.106% 99.711% ( 170, 250 ] 30 0.050% 99.761% ( 250, 380 ] 31 0.051% 99.812% ( 380, 580 ] 35 0.058% 99.871% ( 580, 870 ] 24 0.040% 99.910% ( 870, 1300 ] 21 0.035% 99.945% ( 1300, 1900 ] 10 0.017% 99.962% ( 1900, 2900 ] 11 0.018% 99.980% ( 2900, 4400 ] 8 0.013% 99.993% ( 4400, 6600 ] 2 0.003% 99.997% ( 6600, 9900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 550158 Average: 14.9781 StdDev: 202.61 Min: 1 Median: 1.8912 Max: 45452 Percentiles: P50: 1.89 P75: 2.86 P99: 13.91 P99.9: 1433.10 P99.99: 2303.23 ------------------------------------------------------ [ 0, 1 ] 15914 2.893% 2.893% # ( 1, 2 ] 290813 52.860% 55.753% ########### ( 2, 3 ] 123787 22.500% 78.253% ##### ( 3, 4 ] 54103 9.834% 88.087% ## ( 4, 6 ] 47402 8.616% 96.703% ## ( 6, 10 ] 11081 2.014% 98.717% ( 10, 15 ] 1989 0.362% 99.079% ( 15, 22 ] 261 0.047% 99.126% ( 22, 34 ] 59 0.011% 99.137% ( 34, 51 ] 42 0.008% 99.144% ( 51, 76 ] 10 0.002% 99.146% ( 76, 110 ] 67 0.012% 99.158% ( 110, 170 ] 259 0.047% 99.206% ( 170, 250 ] 351 0.064% 99.269% ( 250, 380 ] 623 0.113% 99.383% ( 380, 580 ] 956 0.174% 99.556% ( 580, 870 ] 1071 0.195% 99.751% ( 870, 1300 ] 728 0.132% 99.883% ( 1300, 1900 ] 414 0.075% 99.959% ( 1900, 2900 ] 429 0.078% 100.037% ( 2900, 4400 ] 486 0.088% 100.125% ( 4400, 6600 ] 100 0.018% 100.143% ( 6600, 9900 ] 28 0.005% 100.148% ( 9900, 14000 ] 3 0.001% 100.149% ( 14000, 22000 ] 8 0.001% 100.150% ( 22000, 33000 ] 4 0.001% 100.151% ( 33000, 50000 ] 1 0.000% 100.151% ** Level 4 read latency histogram (micros): Count: 99443 Average: 9.0170 StdDev: 109.38 Min: 1 Median: 2.0517 Max: 11205 Percentiles: P50: 2.05 P75: 2.98 P99: 14.05 P99.9: 3135.71 P99.99: 11205.00 ------------------------------------------------------ [ 0, 1 ] 1005 1.011% 1.011% ( 1, 2 ] 47339 47.604% 48.615% ########## ( 2, 3 ] 26661 26.810% 75.425% ##### ( 3, 4 ] 10448 10.507% 85.932% ## ( 4, 6 ] 10375 10.433% 96.365% ## ( 6, 10 ] 2253 2.266% 98.630% ( 10, 15 ] 454 0.457% 99.087% ( 15, 22 ] 51 0.051% 99.138% ( 22, 34 ] 8 0.008% 99.146% ( 34, 51 ] 4 0.004% 99.150% ( 51, 76 ] 5 0.005% 99.155% ( 76, 110 ] 65 0.065% 99.221% ( 110, 170 ] 78 0.078% 99.299% ( 170, 250 ] 109 0.110% 99.409% ( 250, 380 ] 81 0.081% 99.490% ( 380, 580 ] 118 0.119% 99.609% ( 580, 870 ] 117 0.118% 99.726% ( 870, 1300 ] 89 0.089% 99.816% ( 1300, 1900 ] 41 0.041% 99.857% ( 1900, 2900 ] 38 0.038% 99.895% ( 2900, 4400 ] 29 0.029% 99.925% ( 4400, 6600 ] 6 0.006% 99.931% ( 9900, 14000 ] 1 0.001% 99.932% ** Level 5 read latency histogram (micros): Count: 260 Average: 1438.5692 StdDev: 1537.80 Min: 81 Median: 783.0000 Max: 7263 Percentiles: P50: 783.00 P75: 2328.57 P99: 6505.71 P99.9: 7263.00 P99.99: 7263.00 ------------------------------------------------------ ( 76, 110 ] 16 6.154% 6.154% # ( 110, 170 ] 34 13.077% 19.231% ### ( 170, 250 ] 12 4.615% 23.846% # ( 250, 380 ] 34 13.077% 36.923% ### ( 380, 580 ] 20 7.692% 44.615% ## ( 580, 870 ] 20 7.692% 52.308% ## ( 870, 1300 ] 26 10.000% 62.308% ## ( 1300, 1900 ] 21 8.077% 70.385% ## ( 1900, 2900 ] 28 10.769% 81.154% ## ( 2900, 4400 ] 33 12.692% 93.846% ### ( 4400, 6600 ] 14 5.385% 99.231% # ( 6600, 9900 ] 2 0.769% 100.000% ** DB Stats ** Uptime(secs): 44.3 total, 3.4 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 177.71 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:22.445 H:M:S, 50.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 289.95 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.699 H:M:S, 20.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/07-00:23:53 ... thread 0: (1000000,9000000) ops and (335129.3,190973.2) ops/second in (2.983923,47.127022) 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/4 3.32 GB 314.6 7.1 0.0 7.1 15.6 8.5 0.0 1.8 130.5 288.1 55.51 49.33 146 0.380 7355K 8038 0.0 0.0 L1 7/0 648.99 MB 64.9 5.8 5.1 0.7 5.7 5.0 0.1 1.1 209.8 206.7 28.20 24.59 4 7.051 5499K 82K 0.0 0.0 L2 1/0 59.52 MB 0.6 0.1 0.1 0.1 0.1 0.1 4.4 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 19/0 971.89 MB 1.0 3.0 1.4 1.6 3.0 1.4 3.2 2.2 150.4 150.0 20.40 14.06 13 1.569 2670K 4984 0.0 0.0 L4 155/0 9.61 GB 1.0 3.5 2.7 0.8 3.5 2.7 1.6 1.3 117.9 117.4 30.48 17.01 27 1.129 3577K 12K 0.0 0.0 L5 1096/0 90.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/4 104.57 GB 0.0 19.5 9.3 10.2 27.9 17.7 13.7 3.3 147.6 211.5 135.14 105.51 191 0.708 19M 108K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.5 9.3 10.2 27.9 17.7 13.7 3.3 147.6 211.5 135.14 105.51 191 0.708 19M 108K 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.5 9.3 10.2 19.4 9.1 0.0 0.0 185.3 184.2 107.63 83.35 70 1.538 19M 108K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 318.3 27.51 22.16 121 0.227 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): 47.3 total, 47.1 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.92 GB write, 604.48 MB/s write, 19.48 GB read, 421.83 MB/s read, 135.1 seconds Interval compaction: 27.92 GB write, 606.55 MB/s write, 19.48 GB read, 423.27 MB/s read, 135.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 55, interval: 66 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3252350 Average: 2.6315 StdDev: 34.01 Min: 0 Median: 1.3833 Max: 40787 Percentiles: P50: 1.38 P75: 1.79 P99: 5.90 P99.9: 142.15 P99.99: 502.06 ------------------------------------------------------ [ 0, 1 ] 861842 26.499% 26.499% ##### ( 1, 2 ] 1994288 61.318% 87.817% ############ ( 2, 3 ] 214243 6.587% 94.405% # ( 3, 4 ] 88359 2.717% 97.122% # ( 4, 6 ] 64426 1.981% 99.102% ( 6, 10 ] 14119 0.434% 99.537% ( 10, 15 ] 3538 0.109% 99.645% ( 15, 22 ] 743 0.023% 99.668% ( 22, 34 ] 38 0.001% 99.669% ( 34, 51 ] 20 0.001% 99.670% ( 51, 76 ] 774 0.024% 99.694% ( 76, 110 ] 4793 0.147% 99.841% ( 110, 170 ] 3573 0.110% 99.951% ( 170, 250 ] 565 0.017% 99.968% ( 250, 380 ] 445 0.014% 99.982% ( 380, 580 ] 424 0.013% 99.995% ( 580, 870 ] 213 0.007% 100.002% ( 870, 1300 ] 108 0.003% 100.005% ( 1300, 1900 ] 53 0.002% 100.007% ( 1900, 2900 ] 61 0.002% 100.008% ( 2900, 4400 ] 52 0.002% 100.010% ( 4400, 6600 ] 13 0.000% 100.010% ( 6600, 9900 ] 2 0.000% 100.011% ( 33000, 50000 ] 1 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 1151762 Average: 6.6852 StdDev: 117.17 Min: 0 Median: 1.8802 Max: 43908 Percentiles: P50: 1.88 P75: 2.80 P99: 9.04 P99.9: 15.26 P99.99: 154.63 ------------------------------------------------------ [ 0, 1 ] 38883 3.376% 3.376% # ( 1, 2 ] 610095 52.971% 56.347% ########### ( 2, 3 ] 266904 23.174% 79.520% ##### ( 3, 4 ] 104432 9.067% 88.587% ## ( 4, 6 ] 100986 8.768% 97.355% ## ( 6, 10 ] 24914 2.163% 99.518% ( 10, 15 ] 4376 0.380% 99.898% ( 15, 22 ] 549 0.048% 99.946% ( 22, 34 ] 54 0.005% 99.951% ( 34, 51 ] 25 0.002% 99.953% ( 51, 76 ] 57 0.005% 99.958% ( 76, 110 ] 168 0.015% 99.972% ( 110, 170 ] 274 0.024% 99.996% ( 170, 250 ] 255 0.022% 100.018% ( 250, 380 ] 370 0.032% 100.050% ( 380, 580 ] 472 0.041% 100.091% ( 580, 870 ] 483 0.042% 100.133% ( 870, 1300 ] 346 0.030% 100.163% ( 1300, 1900 ] 227 0.020% 100.183% ( 1900, 2900 ] 313 0.027% 100.210% ( 2900, 4400 ] 341 0.030% 100.240% ( 4400, 6600 ] 105 0.009% 100.249% ( 6600, 9900 ] 42 0.004% 100.253% ( 9900, 14000 ] 4 0.000% 100.253% ( 14000, 22000 ] 3 0.000% 100.253% ( 33000, 50000 ] 1 0.000% 100.253% ** Level 2 read latency histogram (micros): Count: 60238 Average: 5.3093 StdDev: 78.17 Min: 1 Median: 1.6565 Max: 6924 Percentiles: P50: 1.66 P75: 2.19 P99: 8.91 P99.9: 794.62 P99.99: 4020.54 ------------------------------------------------------ [ 0, 1 ] 4665 7.744% 7.744% ## ( 1, 2 ] 38771 64.363% 72.107% ############# ( 2, 3 ] 9362 15.542% 87.649% ### ( 3, 4 ] 3651 6.061% 93.710% # ( 4, 6 ] 2528 4.197% 97.907% # ( 6, 10 ] 905 1.502% 99.409% ( 10, 15 ] 87 0.144% 99.553% ( 15, 22 ] 13 0.022% 99.575% ( 22, 34 ] 1 0.002% 99.577% ( 51, 76 ] 2 0.003% 99.580% ( 76, 110 ] 15 0.025% 99.605% ( 110, 170 ] 64 0.106% 99.711% ( 170, 250 ] 30 0.050% 99.761% ( 250, 380 ] 31 0.051% 99.812% ( 380, 580 ] 35 0.058% 99.871% ( 580, 870 ] 24 0.040% 99.910% ( 870, 1300 ] 21 0.035% 99.945% ( 1300, 1900 ] 10 0.017% 99.962% ( 1900, 2900 ] 11 0.018% 99.980% ( 2900, 4400 ] 8 0.013% 99.993% ( 4400, 6600 ] 2 0.003% 99.997% ( 6600, 9900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 550158 Average: 14.9781 StdDev: 202.61 Min: 1 Median: 1.8912 Max: 45452 Percentiles: P50: 1.89 P75: 2.86 P99: 13.91 P99.9: 1433.10 P99.99: 2303.23 ------------------------------------------------------ [ 0, 1 ] 15914 2.893% 2.893% # ( 1, 2 ] 290813 52.860% 55.753% ########### ( 2, 3 ] 123787 22.500% 78.253% ##### ( 3, 4 ] 54103 9.834% 88.087% ## ( 4, 6 ] 47402 8.616% 96.703% ## ( 6, 10 ] 11081 2.014% 98.717% ( 10, 15 ] 1989 0.362% 99.079% ( 15, 22 ] 261 0.047% 99.126% ( 22, 34 ] 59 0.011% 99.137% ( 34, 51 ] 42 0.008% 99.144% ( 51, 76 ] 10 0.002% 99.146% ( 76, 110 ] 67 0.012% 99.158% ( 110, 170 ] 259 0.047% 99.206% ( 170, 250 ] 351 0.064% 99.269% ( 250, 380 ] 623 0.113% 99.383% ( 380, 580 ] 956 0.174% 99.556% ( 580, 870 ] 1071 0.195% 99.751% ( 870, 1300 ] 728 0.132% 99.883% ( 1300, 1900 ] 414 0.075% 99.959% ( 1900, 2900 ] 429 0.078% 100.037% ( 2900, 4400 ] 486 0.088% 100.125% ( 4400, 6600 ] 100 0.018% 100.143% ( 6600, 9900 ] 28 0.005% 100.148% ( 9900, 14000 ] 3 0.001% 100.149% ( 14000, 22000 ] 8 0.001% 100.150% ( 22000, 33000 ] 4 0.001% 100.151% ( 33000, 50000 ] 1 0.000% 100.151% ** Level 4 read latency histogram (micros): Count: 99443 Average: 9.0170 StdDev: 109.38 Min: 1 Median: 2.0517 Max: 11205 Percentiles: P50: 2.05 P75: 2.98 P99: 14.05 P99.9: 3135.71 P99.99: 11205.00 ------------------------------------------------------ [ 0, 1 ] 1005 1.011% 1.011% ( 1, 2 ] 47339 47.604% 48.615% ########## ( 2, 3 ] 26661 26.810% 75.425% ##### ( 3, 4 ] 10448 10.507% 85.932% ## ( 4, 6 ] 10375 10.433% 96.365% ## ( 6, 10 ] 2253 2.266% 98.630% ( 10, 15 ] 454 0.457% 99.087% ( 15, 22 ] 51 0.051% 99.138% ( 22, 34 ] 8 0.008% 99.146% ( 34, 51 ] 4 0.004% 99.150% ( 51, 76 ] 5 0.005% 99.155% ( 76, 110 ] 65 0.065% 99.221% ( 110, 170 ] 78 0.078% 99.299% ( 170, 250 ] 109 0.110% 99.409% ( 250, 380 ] 81 0.081% 99.490% ( 380, 580 ] 118 0.119% 99.609% ( 580, 870 ] 117 0.118% 99.726% ( 870, 1300 ] 89 0.089% 99.816% ( 1300, 1900 ] 41 0.041% 99.857% ( 1900, 2900 ] 38 0.038% 99.895% ( 2900, 4400 ] 29 0.029% 99.925% ( 4400, 6600 ] 6 0.006% 99.931% ( 9900, 14000 ] 1 0.001% 99.932% ** Level 5 read latency histogram (micros): Count: 260 Average: 1438.5692 StdDev: 1537.80 Min: 81 Median: 783.0000 Max: 7263 Percentiles: P50: 783.00 P75: 2328.57 P99: 6505.71 P99.9: 7263.00 P99.99: 7263.00 ------------------------------------------------------ ( 76, 110 ] 16 6.154% 6.154% # ( 110, 170 ] 34 13.077% 19.231% ### ( 170, 250 ] 12 4.615% 23.846% # ( 250, 380 ] 34 13.077% 36.923% ### ( 380, 580 ] 20 7.692% 44.615% ## ( 580, 870 ] 20 7.692% 52.308% ## ( 870, 1300 ] 26 10.000% 62.308% ## ( 1300, 1900 ] 21 8.077% 70.385% ## ( 1900, 2900 ] 28 10.769% 81.154% ## ( 2900, 4400 ] 33 12.692% 93.846% ### ( 4400, 6600 ] 14 5.385% 99.231% # ( 6600, 9900 ] 2 0.769% 100.000% ** DB Stats ** Uptime(secs): 47.3 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 187.31 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:22.851 H:M:S, 48.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.83 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.406 H:M:S, 13.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/07-00:23:57 ... thread 0: (1000000,10000000) ops and (246630.3,195382.4) ops/second in (4.054652,51.181674) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 21/20 4.36 GB 25.2 8.1 0.0 8.1 17.7 9.6 0.0 1.8 132.9 289.9 62.56 55.98 166 0.377 8443K 9129 0.0 0.0 L1 7/7 648.99 MB 0.0 5.8 5.1 0.7 5.7 5.0 0.1 1.1 209.8 206.7 28.20 24.59 4 7.051 5499K 82K 0.0 0.0 L2 1/0 59.52 MB 0.6 0.1 0.1 0.1 0.1 0.1 4.4 2.0 230.2 230.1 0.55 0.52 1 0.547 127K 48 0.0 0.0 L3 19/0 971.89 MB 1.0 3.0 1.4 1.6 3.0 1.4 3.2 2.2 150.4 150.0 20.40 14.06 13 1.569 2670K 4984 0.0 0.0 L4 155/0 9.61 GB 1.0 3.5 2.7 0.8 3.5 2.7 1.6 1.3 117.9 117.4 30.48 17.01 27 1.129 3577K 12K 0.0 0.0 L5 1096/0 90.00 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1299/27 105.62 GB 0.0 20.5 9.3 11.3 30.0 18.7 13.7 3.1 147.8 216.1 142.19 112.16 211 0.674 20M 109K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.5 9.3 11.3 30.0 18.7 13.7 3.1 147.8 216.1 142.19 112.16 211 0.674 20M 109K 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 20.5 9.3 11.3 20.4 9.1 0.0 0.0 188.2 187.1 111.69 87.34 74 1.509 20M 109K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.6 9.6 0.0 0.0 0.0 322.2 30.50 24.82 137 0.223 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): 51.3 total, 51.2 interval Flush(GB): cumulative 9.597, interval 9.597 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: 30.01 GB write, 598.44 MB/s write, 20.53 GB read, 409.37 MB/s read, 142.2 seconds Interval compaction: 30.01 GB write, 600.32 MB/s write, 20.53 GB read, 410.66 MB/s read, 142.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 56, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 56, interval: 74 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3598467 Average: 2.5869 StdDev: 32.68 Min: 0 Median: 1.3829 Max: 40787 Percentiles: P50: 1.38 P75: 1.79 P99: 5.85 P99.9: 138.76 P99.99: 474.16 ------------------------------------------------------ [ 0, 1 ] 950569 26.416% 26.416% ##### ( 1, 2 ] 2216202 61.587% 88.003% ############ ( 2, 3 ] 237393 6.597% 94.600% # ( 3, 4 ] 95908 2.665% 97.266% # ( 4, 6 ] 67638 1.880% 99.145% ( 6, 10 ] 15096 0.420% 99.565% ( 10, 15 ] 3725 0.104% 99.668% ( 15, 22 ] 778 0.022% 99.690% ( 22, 34 ] 43 0.001% 99.691% ( 34, 51 ] 21 0.001% 99.692% ( 51, 76 ] 775 0.022% 99.713% ( 76, 110 ] 4923 0.137% 99.850% ( 110, 170 ] 3758 0.104% 99.954% ( 170, 250 ] 607 0.017% 99.971% ( 250, 380 ] 468 0.013% 99.984% ( 380, 580 ] 440 0.012% 99.997% ( 580, 870 ] 225 0.006% 100.003% ( 870, 1300 ] 110 0.003% 100.006% ( 1300, 1900 ] 54 0.002% 100.007% ( 1900, 2900 ] 64 0.002% 100.009% ( 2900, 4400 ] 54 0.002% 100.011% ( 4400, 6600 ] 14 0.000% 100.011% ( 6600, 9900 ] 2 0.000% 100.011% ( 33000, 50000 ] 1 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 1151763 Average: 6.6855 StdDev: 117.17 Min: 0 Median: 1.8802 Max: 43908 Percentiles: P50: 1.88 P75: 2.80 P99: 9.04 P99.9: 15.27 P99.99: 154.85 ------------------------------------------------------ [ 0, 1 ] 38883 3.376% 3.376% # ( 1, 2 ] 610095 52.971% 56.346% ########### ( 2, 3 ] 266904 23.174% 79.520% ##### ( 3, 4 ] 104432 9.067% 88.587% ## ( 4, 6 ] 100986 8.768% 97.355% ## ( 6, 10 ] 24914 2.163% 99.518% ( 10, 15 ] 4376 0.380% 99.898% ( 15, 22 ] 549 0.048% 99.946% ( 22, 34 ] 54 0.005% 99.951% ( 34, 51 ] 25 0.002% 99.953% ( 51, 76 ] 57 0.005% 99.958% ( 76, 110 ] 168 0.015% 99.972% ( 110, 170 ] 274 0.024% 99.996% ( 170, 250 ] 255 0.022% 100.018% ( 250, 380 ] 371 0.032% 100.050% ( 380, 580 ] 472 0.041% 100.091% ( 580, 870 ] 483 0.042% 100.133% ( 870, 1300 ] 346 0.030% 100.163% ( 1300, 1900 ] 227 0.020% 100.183% ( 1900, 2900 ] 313 0.027% 100.210% ( 2900, 4400 ] 341 0.030% 100.240% ( 4400, 6600 ] 105 0.009% 100.249% ( 6600, 9900 ] 42 0.004% 100.253% ( 9900, 14000 ] 4 0.000% 100.253% ( 14000, 22000 ] 3 0.000% 100.253% ( 33000, 50000 ] 1 0.000% 100.253% ** Level 2 read latency histogram (micros): Count: 60238 Average: 5.3093 StdDev: 78.17 Min: 1 Median: 1.6565 Max: 6924 Percentiles: P50: 1.66 P75: 2.19 P99: 8.91 P99.9: 794.62 P99.99: 4020.54 ------------------------------------------------------ [ 0, 1 ] 4665 7.744% 7.744% ## ( 1, 2 ] 38771 64.363% 72.107% ############# ( 2, 3 ] 9362 15.542% 87.649% ### ( 3, 4 ] 3651 6.061% 93.710% # ( 4, 6 ] 2528 4.197% 97.907% # ( 6, 10 ] 905 1.502% 99.409% ( 10, 15 ] 87 0.144% 99.553% ( 15, 22 ] 13 0.022% 99.575% ( 22, 34 ] 1 0.002% 99.577% ( 51, 76 ] 2 0.003% 99.580% ( 76, 110 ] 15 0.025% 99.605% ( 110, 170 ] 64 0.106% 99.711% ( 170, 250 ] 30 0.050% 99.761% ( 250, 380 ] 31 0.051% 99.812% ( 380, 580 ] 35 0.058% 99.871% ( 580, 870 ] 24 0.040% 99.910% ( 870, 1300 ] 21 0.035% 99.945% ( 1300, 1900 ] 10 0.017% 99.962% ( 1900, 2900 ] 11 0.018% 99.980% ( 2900, 4400 ] 8 0.013% 99.993% ( 4400, 6600 ] 2 0.003% 99.997% ( 6600, 9900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 550158 Average: 14.9781 StdDev: 202.61 Min: 1 Median: 1.8912 Max: 45452 Percentiles: P50: 1.89 P75: 2.86 P99: 13.91 P99.9: 1433.10 P99.99: 2303.23 ------------------------------------------------------ [ 0, 1 ] 15914 2.893% 2.893% # ( 1, 2 ] 290813 52.860% 55.753% ########### ( 2, 3 ] 123787 22.500% 78.253% ##### ( 3, 4 ] 54103 9.834% 88.087% ## ( 4, 6 ] 47402 8.616% 96.703% ## ( 6, 10 ] 11081 2.014% 98.717% ( 10, 15 ] 1989 0.362% 99.079% ( 15, 22 ] 261 0.047% 99.126% ( 22, 34 ] 59 0.011% 99.137% ( 34, 51 ] 42 0.008% 99.144% ( 51, 76 ] 10 0.002% 99.146% ( 76, 110 ] 67 0.012% 99.158% ( 110, 170 ] 259 0.047% 99.206% ( 170, 250 ] 351 0.064% 99.269% ( 250, 380 ] 623 0.113% 99.383% ( 380, 580 ] 956 0.174% 99.556% ( 580, 870 ] 1071 0.195% 99.751% ( 870, 1300 ] 728 0.132% 99.883% ( 1300, 1900 ] 414 0.075% 99.959% ( 1900, 2900 ] 429 0.078% 100.037% ( 2900, 4400 ] 486 0.088% 100.125% ( 4400, 6600 ] 100 0.018% 100.143% ( 6600, 9900 ] 28 0.005% 100.148% ( 9900, 14000 ] 3 0.001% 100.149% ( 14000, 22000 ] 8 0.001% 100.150% ( 22000, 33000 ] 4 0.001% 100.151% ( 33000, 50000 ] 1 0.000% 100.151% ** Level 4 read latency histogram (micros): Count: 99443 Average: 9.0170 StdDev: 109.38 Min: 1 Median: 2.0517 Max: 11205 Percentiles: P50: 2.05 P75: 2.98 P99: 14.05 P99.9: 3135.71 P99.99: 11205.00 ------------------------------------------------------ [ 0, 1 ] 1005 1.011% 1.011% ( 1, 2 ] 47339 47.604% 48.615% ########## ( 2, 3 ] 26661 26.810% 75.425% ##### ( 3, 4 ] 10448 10.507% 85.932% ## ( 4, 6 ] 10375 10.433% 96.365% ## ( 6, 10 ] 2253 2.266% 98.630% ( 10, 15 ] 454 0.457% 99.087% ( 15, 22 ] 51 0.051% 99.138% ( 22, 34 ] 8 0.008% 99.146% ( 34, 51 ] 4 0.004% 99.150% ( 51, 76 ] 5 0.005% 99.155% ( 76, 110 ] 65 0.065% 99.221% ( 110, 170 ] 78 0.078% 99.299% ( 170, 250 ] 109 0.110% 99.409% ( 250, 380 ] 81 0.081% 99.490% ( 380, 580 ] 118 0.119% 99.609% ( 580, 870 ] 117 0.118% 99.726% ( 870, 1300 ] 89 0.089% 99.816% ( 1300, 1900 ] 41 0.041% 99.857% ( 1900, 2900 ] 38 0.038% 99.895% ( 2900, 4400 ] 29 0.029% 99.925% ( 4400, 6600 ] 6 0.006% 99.931% ( 9900, 14000 ] 1 0.001% 99.932% ** Level 5 read latency histogram (micros): Count: 260 Average: 1438.5692 StdDev: 1537.80 Min: 81 Median: 783.0000 Max: 7263 Percentiles: P50: 783.00 P75: 2328.57 P99: 6505.71 P99.9: 7263.00 P99.99: 7263.00 ------------------------------------------------------ ( 76, 110 ] 16 6.154% 6.154% # ( 110, 170 ] 34 13.077% 19.231% ### ( 170, 250 ] 12 4.615% 23.846% # ( 250, 380 ] 34 13.077% 36.923% ### ( 380, 580 ] 20 7.692% 44.615% ## ( 580, 870 ] 20 7.692% 52.308% ## ( 870, 1300 ] 26 10.000% 62.308% ## ( 1300, 1900 ] 21 8.077% 70.385% ## ( 1900, 2900 ] 28 10.769% 81.154% ## ( 2900, 4400 ] 33 12.692% 93.846% ### ( 4400, 6600 ] 14 5.385% 99.231% # ( 6600, 9900 ] 2 0.769% 100.000% ** DB Stats ** Uptime(secs): 51.3 total, 4.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 191.68 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:24.272 H:M:S, 47.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 242.67 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.421 H:M:S, 35.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.865 micros/op 170504 ops/sec 60.028 seconds 10234999 operations; 165.2 MB/s Microseconds per write: Count: 10234999 Average: 5.8649 StdDev: 514.89 Min: 0 Median: 1.7167 Max: 856485 Percentiles: P50: 1.72 P75: 2.70 P99: 9.21 P99.9: 1163.15 P99.99: 2744.95 ------------------------------------------------------ [ 0, 1 ] 1455135 14.217% 14.217% ### ( 1, 2 ] 5110028 49.927% 64.144% ########## ( 2, 3 ] 1580195 15.439% 79.583% ### ( 3, 4 ] 1384896 13.531% 93.114% ### ( 4, 6 ] 508086 4.964% 98.079% # ( 6, 10 ] 117650 1.149% 99.228% ( 10, 15 ] 38347 0.375% 99.603% ( 15, 22 ] 9815 0.096% 99.699% ( 22, 34 ] 1602 0.016% 99.714% ( 34, 51 ] 199 0.002% 99.716% ( 51, 76 ] 22 0.000% 99.716% ( 76, 110 ] 7165 0.070% 99.786% ( 110, 170 ] 2740 0.027% 99.813% ( 170, 250 ] 298 0.003% 99.816% ( 250, 380 ] 154 0.002% 99.818% ( 380, 580 ] 22 0.000% 99.818% ( 580, 870 ] 15 0.000% 99.818% ( 870, 1300 ] 12314 0.120% 99.938% ( 1300, 1900 ] 20 0.000% 99.938% ( 1900, 2900 ] 6240 0.061% 99.999% ( 2900, 4400 ] 20 0.000% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 570000, 860000 ] 3 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 : 168858 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 : 10234999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10562518968 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 : 497 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32194963 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 : 25020009924 rocksdb.compact.write.bytes COUNT : 24857163552 rocksdb.flush.write.bytes COUNT : 10503116589 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 : 61 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 : 294 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 : 10418496512 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4105216 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 : 25118167029 rocksdb.non.last.level.read.count COUNT : 6064093 rocksdb.block.checksum.compute.count COUNT : 6063160 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.356324 P95 : 3.881854 P99 : 7.713898 P100 : 856483.000000 COUNT : 10234999 SUM : 55302169 rocksdb.compaction.times.micros P50 : 1112424.242424 P95 : 2150000.000000 P99 : 16000000.000000 P100 : 18535237.000000 COUNT : 75 SUM : 112642959 rocksdb.compaction.times.cpu_micros P50 : 913428.571429 P95 : 2150000.000000 P99 : 16000000.000000 P100 : 16955160.000000 COUNT : 75 SUM : 88283879 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 : 654.459459 P95 : 1900.000000 P99 : 289000.000000 P100 : 301260.000000 COUNT : 140 SUM : 696309 rocksdb.compaction.outfile.sync.micros P50 : 1055.681818 P95 : 115812.500000 P99 : 162162.500000 P100 : 191652.000000 COUNT : 309 SUM : 5813954 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 : 106.076923 P95 : 1487.500000 P99 : 3443.750000 P100 : 4350.000000 COUNT : 255 SUM : 76825 rocksdb.table.open.io.micros P50 : 1250.089286 P95 : 8572.500000 P99 : 13378.692308 P100 : 16394.000000 COUNT : 497 SUM : 1063035 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.549465 P95 : 7.298274 P99 : 11.010657 P100 : 45458.000000 COUNT : 6061681 SUM : 40240516 rocksdb.read.block.get.micros P50 : 364.833333 P95 : 3543.269231 P99 : 5701.882353 P100 : 7333.000000 COUNT : 994 SUM : 832264 rocksdb.write.raw.block.micros P50 : 0.513379 P95 : 0.975420 P99 : 2.874545 P100 : 50341.000000 COUNT : 8563900 SUM : 18108600 rocksdb.numfiles.in.singlecompaction P50 : 3.352273 P95 : 5.680000 P99 : 19.480000 P100 : 23.000000 COUNT : 136 SUM : 519 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.571277 P95 : 1257.602314 P99 : 2664.694074 P100 : 856290.000000 COUNT : 149525 SUM : 32215084 rocksdb.sst.read.micros P50 : 1.510144 P95 : 4.210646 P99 : 8.166979 P100 : 45452.000000 COUNT : 6064191 SUM : 28061789 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 : 10234999 SUM : 10562518968 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 : 211318.681319 P95 : 380000.000000 P99 : 1017751.000000 P100 : 1017751.000000 COUNT : 140 SUM : 31026070 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 : 301 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