[2024-10-16 06:19:42.112640] Starting SPDK v25.01-pre git sha1 5a8c76d99 / DPDK 24.03.0 initialization... [2024-10-16 06:19:42.112757] [ 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_pid3563133 ] Set seed to 1729052382110224 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-10-16 06:19:42.217832] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-10-16 06:19:42.322749] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-10-16 06:19:42.322799] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3563133' to capture a snapshot of events at runtime. [2024-10-16 06:19:42.322809] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-10-16 06:19:42.322835] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-10-16 06:19:42.322843] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3563133 for offline analysis/debug. [2024-10-16 06:19:42.324292] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Wed Oct 16 06:19:50 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/10/16-06:19:53 ... thread 0: (1000000,1000000) ops and (358169.8,358169.8) ops/second in (2.791972,2.791972) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.02 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 355.5 2.30 2.04 12 0.192 0 0 0.0 0.0 L2 3/2 251.76 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 10/0 804.14 MB 0.8 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.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1182/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 98.8 312.7 3.83 3.51 14 0.273 383K 186 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.5 98.8 312.7 3.83 3.51 14 0.273 383K 186 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 355.5 2.30 2.04 12 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 395.12 MB/s write, 0.37 GB read, 124.78 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 428.30 MB/s write, 0.37 GB read, 135.26 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 98535 Average: 2.0099 StdDev: 26.13 Min: 1 Median: 1.2591 Max: 4190 Percentiles: P50: 1.26 P75: 1.68 P99: 3.93 P99.9: 9.28 P99.99: 409.30 ------------------------------------------------------ [ 0, 1 ] 33930 34.434% 34.434% ####### ( 1, 2 ] 59204 60.084% 94.519% ############ ( 2, 3 ] 3274 3.323% 97.841% # ( 3, 4 ] 1228 1.246% 99.088% ( 4, 6 ] 633 0.642% 99.730% ( 6, 10 ] 204 0.207% 99.937% ( 10, 15 ] 24 0.024% 99.961% ( 15, 22 ] 12 0.012% 99.974% ( 22, 34 ] 1 0.001% 99.975% ( 51, 76 ] 1 0.001% 99.976% ( 110, 170 ] 4 0.004% 99.980% ( 170, 250 ] 7 0.007% 99.987% ( 250, 380 ] 3 0.003% 99.990% ( 380, 580 ] 1 0.001% 99.991% ( 580, 870 ] 1 0.001% 99.992% ( 870, 1300 ] 1 0.001% 99.993% ( 1300, 1900 ] 2 0.002% 99.995% ( 1900, 2900 ] 1 0.001% 99.996% ( 2900, 4400 ] 4 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 50271 Average: 2.2301 StdDev: 31.09 Min: 0 Median: 1.3197 Max: 4741 Percentiles: P50: 1.32 P75: 1.72 P99: 5.19 P99.9: 9.90 P99.99: 1154.72 ------------------------------------------------------ [ 0, 1 ] 15202 30.240% 30.240% ###### ( 1, 2 ] 31071 61.807% 92.047% ############ ( 2, 3 ] 2300 4.575% 96.622% # ( 3, 4 ] 825 1.641% 98.263% ( 4, 6 ] 620 1.233% 99.497% ( 6, 10 ] 208 0.414% 99.910% ( 10, 15 ] 24 0.048% 99.958% ( 15, 22 ] 2 0.004% 99.962% ( 51, 76 ] 4 0.008% 99.970% ( 76, 110 ] 1 0.002% 99.972% ( 170, 250 ] 1 0.002% 99.974% ( 250, 380 ] 3 0.006% 99.980% ( 580, 870 ] 1 0.002% 99.982% ( 870, 1300 ] 6 0.012% 99.994% ( 1900, 2900 ] 1 0.002% 99.996% ( 2900, 4400 ] 1 0.002% 99.998% ( 4400, 6600 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 40 Average: 3141.3500 StdDev: 2946.79 Min: 159 Median: 1300.0000 Max: 9186 Percentiles: P50: 1300.00 P75: 5720.00 P99: 9186.00 P99.9: 9186.00 P99.99: 9186.00 ------------------------------------------------------ ( 110, 170 ] 1 2.500% 2.500% # ( 170, 250 ] 1 2.500% 5.000% # ( 380, 580 ] 2 5.000% 10.000% # ( 580, 870 ] 1 2.500% 12.500% # ( 870, 1300 ] 15 37.500% 50.000% ######## ( 1300, 1900 ] 4 10.000% 60.000% ## ( 1900, 2900 ] 2 5.000% 65.000% # ( 2900, 4400 ] 1 2.500% 67.500% # ( 4400, 6600 ] 5 12.500% 80.000% ### ( 6600, 9900 ] 8 20.000% 100.000% #### ** Level 4 read latency histogram (micros): Count: 30 Average: 3705.7000 StdDev: 2864.77 Min: 484 Median: 1900.0000 Max: 8726 Percentiles: P50: 1900.00 P75: 6380.00 P99: 8726.00 P99.9: 8726.00 P99.99: 8726.00 ------------------------------------------------------ ( 380, 580 ] 1 3.333% 3.333% # ( 580, 870 ] 3 10.000% 13.333% ## ( 870, 1300 ] 6 20.000% 33.333% #### ( 1300, 1900 ] 5 16.667% 50.000% ### ( 1900, 2900 ] 1 3.333% 53.333% # ( 2900, 4400 ] 2 6.667% 60.000% # ( 4400, 6600 ] 5 16.667% 76.667% ### ( 6600, 9900 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 324.92 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.209 H:M:S, 6.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.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.209 H:M:S, 7.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/10/16-06:19:56 ... thread 0: (1000000,2000000) ops and (330062.7,343542.3) ops/second in (3.029727,5.821699) 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/11 1.17 GB 18.9 0.2 0.0 0.2 2.0 1.8 0.0 1.1 41.1 339.3 6.13 5.52 27 0.227 255K 269 0.0 0.0 L1 5/5 377.36 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 229.2 228.8 1.65 1.59 1 1.649 383K 607 0.0 0.0 L2 1/0 2.09 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 17/0 829.17 MB 0.8 0.2 0.2 0.0 0.2 0.2 0.1 1.0 222.4 222.4 1.12 1.04 1 1.123 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 153.2 153.2 1.47 1.09 1 1.467 228K 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/16 97.92 GB 0.0 1.4 1.0 0.4 3.2 2.8 0.4 1.8 124.7 278.3 11.89 10.71 32 0.371 1505K 1062 0.0 0.0 Int 0/0 0.00 KB 0.0 1.4 1.0 0.4 3.2 2.8 0.3 1.8 124.7 278.3 11.89 10.71 32 0.371 1505K 1062 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 1.0 0.4 1.4 1.0 0.0 0.0 219.8 219.7 6.74 6.16 6 1.124 1505K 1062 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 355.2 5.14 4.56 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 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.23 GB write, 546.03 MB/s write, 1.45 GB read, 244.66 MB/s read, 11.9 seconds Interval compaction: 3.23 GB write, 568.03 MB/s write, 1.45 GB read, 254.52 MB/s read, 11.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 332359 Average: 2.2248 StdDev: 16.77 Min: 0 Median: 1.4894 Max: 4190 Percentiles: P50: 1.49 P75: 1.87 P99: 5.55 P99.9: 9.87 P99.99: 17.45 ------------------------------------------------------ [ 0, 1 ] 60052 18.068% 18.068% #### ( 1, 2 ] 216831 65.240% 83.308% ############# ( 2, 3 ] 36557 10.999% 94.308% ## ( 3, 4 ] 10083 3.034% 97.341% # ( 4, 6 ] 7091 2.134% 99.475% ( 6, 10 ] 1461 0.440% 99.915% ( 10, 15 ] 242 0.073% 99.987% ( 15, 22 ] 25 0.008% 99.995% ( 22, 34 ] 4 0.001% 99.996% ( 34, 51 ] 2 0.001% 99.997% ( 51, 76 ] 4 0.001% 99.998% ( 110, 170 ] 6 0.002% 100.000% ( 170, 250 ] 16 0.005% 100.005% ( 250, 380 ] 6 0.002% 100.006% ( 380, 580 ] 7 0.002% 100.008% ( 580, 870 ] 5 0.002% 100.010% ( 870, 1300 ] 4 0.001% 100.011% ( 1300, 1900 ] 3 0.001% 100.012% ( 1900, 2900 ] 2 0.001% 100.013% ( 2900, 4400 ] 5 0.002% 100.014% ** Level 1 read latency histogram (micros): Count: 34976 Average: 2.2132 StdDev: 9.70 Min: 0 Median: 1.5001 Max: 1078 Percentiles: P50: 1.50 P75: 1.86 P99: 5.42 P99.9: 11.50 P99.99: 546.83 ------------------------------------------------------ [ 0, 1 ] 5383 15.391% 15.391% ### ( 1, 2 ] 24204 69.202% 84.592% ############## ( 2, 3 ] 3810 10.893% 95.485% ## ( 3, 4 ] 860 2.459% 97.944% ( 4, 6 ] 523 1.495% 99.440% ( 6, 10 ] 153 0.437% 99.877% ( 10, 15 ] 30 0.086% 99.963% ( 15, 22 ] 6 0.017% 99.980% ( 110, 170 ] 1 0.003% 99.983% ( 170, 250 ] 1 0.003% 99.986% ( 380, 580 ] 3 0.009% 99.994% ( 580, 870 ] 1 0.003% 99.997% ( 870, 1300 ] 2 0.006% 100.003% ** Level 2 read latency histogram (micros): Count: 95398 Average: 2.3083 StdDev: 22.58 Min: 0 Median: 1.4845 Max: 4741 Percentiles: P50: 1.48 P75: 1.88 P99: 5.74 P99.9: 11.34 P99.99: 713.46 ------------------------------------------------------ [ 0, 1 ] 18176 19.053% 19.053% #### ( 1, 2 ] 60938 63.878% 82.930% ############# ( 2, 3 ] 10110 10.598% 93.528% ## ( 3, 4 ] 2996 3.141% 96.669% # ( 4, 6 ] 2557 2.680% 99.349% # ( 6, 10 ] 501 0.525% 99.874% ( 10, 15 ] 92 0.096% 99.971% ( 15, 22 ] 9 0.009% 99.980% ( 51, 76 ] 4 0.004% 99.984% ( 76, 110 ] 1 0.001% 99.985% ( 170, 250 ] 1 0.001% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 6 0.006% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57117 Average: 4.5196 StdDev: 114.03 Min: 1 Median: 1.6062 Max: 9186 Percentiles: P50: 1.61 P75: 1.99 P99: 5.99 P99.9: 14.99 P99.99: 7543.92 ------------------------------------------------------ [ 0, 1 ] 6051 10.594% 10.594% ## ( 1, 2 ] 37126 65.000% 75.594% ############# ( 2, 3 ] 10226 17.904% 93.498% #### ( 3, 4 ] 1631 2.856% 96.353% # ( 4, 6 ] 1522 2.665% 99.018% # ( 6, 10 ] 415 0.727% 99.744% ( 10, 15 ] 89 0.156% 99.900% ( 15, 22 ] 11 0.019% 99.919% ( 22, 34 ] 2 0.004% 99.923% ( 110, 170 ] 1 0.002% 99.925% ( 170, 250 ] 1 0.002% 99.926% ( 380, 580 ] 4 0.007% 99.933% ( 580, 870 ] 3 0.005% 99.939% ( 870, 1300 ] 15 0.026% 99.965% ( 1300, 1900 ] 4 0.007% 99.972% ( 1900, 2900 ] 2 0.004% 99.975% ( 2900, 4400 ] 1 0.002% 99.977% ( 4400, 6600 ] 5 0.009% 99.986% ( 6600, 9900 ] 8 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 357.1562 StdDev: 1389.81 Min: 1 Median: 1.7109 Max: 8726 Percentiles: P50: 1.71 P75: 8.00 P99: 8391.43 P99.9: 8726.00 P99.99: 8726.00 ------------------------------------------------------ [ 0, 1 ] 69 21.562% 21.562% #### ( 1, 2 ] 128 40.000% 61.562% ######## ( 2, 3 ] 26 8.125% 69.688% ## ( 4, 6 ] 15 4.688% 74.375% # ( 6, 10 ] 4 1.250% 75.625% ( 10, 15 ] 37 11.562% 87.188% ## ( 15, 22 ] 1 0.312% 87.500% ( 22, 34 ] 1 0.312% 87.812% ( 51, 76 ] 2 0.625% 88.438% ( 110, 170 ] 1 0.312% 88.750% ( 170, 250 ] 4 1.250% 90.000% ( 380, 580 ] 2 0.625% 90.625% ( 580, 870 ] 4 1.250% 91.875% ( 870, 1300 ] 6 1.875% 93.750% ( 1300, 1900 ] 5 1.562% 95.312% ( 1900, 2900 ] 1 0.312% 95.625% ( 2900, 4400 ] 2 0.625% 96.250% ( 4400, 6600 ] 5 1.562% 97.812% ( 6600, 9900 ] 7 2.188% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.88 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.568 H:M:S, 9.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.84 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.359 H:M:S, 11.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/10/16-06:19:59 ... thread 0: (1000000,3000000) ops and (326759.4,337759.7) ops/second in (3.060356,8.882055) 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.48 GB 94.4 1.0 0.0 1.0 3.8 2.8 0.0 1.4 88.7 323.3 12.08 11.11 44 0.275 1087K 1115 0.0 0.0 L1 5/0 550.14 MB 55.0 1.4 1.0 0.4 1.4 1.0 0.2 1.3 231.8 230.9 6.25 6.08 2 3.124 1470K 5249 0.0 0.0 L2 1/0 2.09 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.6 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 13/0 651.33 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 222.4 222.4 1.12 1.04 1 1.123 253K 0 0.0 0.0 L4 182/8 10.43 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 153.2 153.2 1.47 1.09 1 1.467 228K 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1257/16 98.90 GB 0.0 3.3 1.7 1.6 6.1 4.5 2.1 2.2 150.2 276.3 22.44 20.80 50 0.449 3423K 6550 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 1.7 1.6 6.1 4.5 2.0 2.2 150.2 276.3 22.44 20.80 50 0.449 3423K 6550 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.3 1.7 1.6 3.3 1.7 0.0 0.0 233.5 233.0 14.44 13.70 10 1.444 3423K 6550 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 354.4 8.00 7.10 40 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.05 GB write, 679.84 MB/s write, 3.29 GB read, 369.71 MB/s read, 22.4 seconds Interval compaction: 6.05 GB write, 697.80 MB/s write, 3.29 GB read, 379.47 MB/s read, 22.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 664063 Average: 2.2323 StdDev: 12.85 Min: 0 Median: 1.5223 Max: 4190 Percentiles: P50: 1.52 P75: 1.89 P99: 5.55 P99.9: 9.89 P99.99: 14.44 ------------------------------------------------------ [ 0, 1 ] 99328 14.958% 14.958% ### ( 1, 2 ] 445548 67.094% 82.052% ############# ( 2, 3 ] 80507 12.123% 94.175% ## ( 3, 4 ] 21080 3.174% 97.350% # ( 4, 6 ] 14127 2.127% 99.477% ( 6, 10 ] 2891 0.435% 99.912% ( 10, 15 ] 583 0.088% 100.000% ( 15, 22 ] 48 0.007% 100.007% ( 22, 34 ] 6 0.001% 100.008% ( 34, 51 ] 3 0.000% 100.009% ( 51, 76 ] 4 0.001% 100.009% ( 110, 170 ] 8 0.001% 100.011% ( 170, 250 ] 25 0.004% 100.014% ( 250, 380 ] 8 0.001% 100.016% ( 380, 580 ] 14 0.002% 100.018% ( 580, 870 ] 11 0.002% 100.019% ( 870, 1300 ] 10 0.002% 100.021% ( 1300, 1900 ] 5 0.001% 100.022% ( 1900, 2900 ] 2 0.000% 100.022% ( 2900, 4400 ] 5 0.001% 100.023% ** Level 1 read latency histogram (micros): Count: 95873 Average: 2.3617 StdDev: 15.38 Min: 0 Median: 1.5403 Max: 2030 Percentiles: P50: 1.54 P75: 1.90 P99: 5.44 P99.9: 11.52 P99.99: 905.49 ------------------------------------------------------ [ 0, 1 ] 11853 12.363% 12.363% ## ( 1, 2 ] 66780 69.655% 82.018% ############## ( 2, 3 ] 12265 12.793% 94.811% ### ( 3, 4 ] 2738 2.856% 97.667% # ( 4, 6 ] 1781 1.858% 99.524% ( 6, 10 ] 333 0.347% 99.872% ( 10, 15 ] 89 0.093% 99.965% ( 15, 22 ] 6 0.006% 99.971% ( 22, 34 ] 1 0.001% 99.972% ( 51, 76 ] 1 0.001% 99.973% ( 110, 170 ] 2 0.002% 99.975% ( 170, 250 ] 1 0.001% 99.976% ( 380, 580 ] 12 0.013% 99.989% ( 580, 870 ] 1 0.001% 99.990% ( 870, 1300 ] 5 0.005% 99.995% ( 1300, 1900 ] 4 0.004% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 95398 Average: 2.3083 StdDev: 22.58 Min: 0 Median: 1.4845 Max: 4741 Percentiles: P50: 1.48 P75: 1.88 P99: 5.74 P99.9: 11.34 P99.99: 713.46 ------------------------------------------------------ [ 0, 1 ] 18176 19.053% 19.053% #### ( 1, 2 ] 60938 63.878% 82.930% ############# ( 2, 3 ] 10110 10.598% 93.528% ## ( 3, 4 ] 2996 3.141% 96.669% # ( 4, 6 ] 2557 2.680% 99.349% # ( 6, 10 ] 501 0.525% 99.874% ( 10, 15 ] 92 0.096% 99.971% ( 15, 22 ] 9 0.009% 99.980% ( 51, 76 ] 4 0.004% 99.984% ( 76, 110 ] 1 0.001% 99.985% ( 170, 250 ] 1 0.001% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 6 0.006% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57117 Average: 4.5196 StdDev: 114.03 Min: 1 Median: 1.6062 Max: 9186 Percentiles: P50: 1.61 P75: 1.99 P99: 5.99 P99.9: 14.99 P99.99: 7543.92 ------------------------------------------------------ [ 0, 1 ] 6051 10.594% 10.594% ## ( 1, 2 ] 37126 65.000% 75.594% ############# ( 2, 3 ] 10226 17.904% 93.498% #### ( 3, 4 ] 1631 2.856% 96.353% # ( 4, 6 ] 1522 2.665% 99.018% # ( 6, 10 ] 415 0.727% 99.744% ( 10, 15 ] 89 0.156% 99.900% ( 15, 22 ] 11 0.019% 99.919% ( 22, 34 ] 2 0.004% 99.923% ( 110, 170 ] 1 0.002% 99.925% ( 170, 250 ] 1 0.002% 99.926% ( 380, 580 ] 4 0.007% 99.933% ( 580, 870 ] 3 0.005% 99.939% ( 870, 1300 ] 15 0.026% 99.965% ( 1300, 1900 ] 4 0.007% 99.972% ( 1900, 2900 ] 2 0.004% 99.975% ( 2900, 4400 ] 1 0.002% 99.977% ( 4400, 6600 ] 5 0.009% 99.986% ( 6600, 9900 ] 8 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 357.1562 StdDev: 1389.81 Min: 1 Median: 1.7109 Max: 8726 Percentiles: P50: 1.71 P75: 8.00 P99: 8391.43 P99.9: 8726.00 P99.99: 8726.00 ------------------------------------------------------ [ 0, 1 ] 69 21.562% 21.562% #### ( 1, 2 ] 128 40.000% 61.562% ######## ( 2, 3 ] 26 8.125% 69.688% ## ( 4, 6 ] 15 4.688% 74.375% # ( 6, 10 ] 4 1.250% 75.625% ( 10, 15 ] 37 11.562% 87.188% ## ( 15, 22 ] 1 0.312% 87.500% ( 22, 34 ] 1 0.312% 87.812% ( 51, 76 ] 2 0.625% 88.438% ( 110, 170 ] 1 0.312% 88.750% ( 170, 250 ] 4 1.250% 90.000% ( 380, 580 ] 2 0.625% 90.625% ( 580, 870 ] 4 1.250% 91.875% ( 870, 1300 ] 6 1.875% 93.750% ( 1300, 1900 ] 5 1.562% 95.312% ( 1900, 2900 ] 1 0.312% 95.625% ( 2900, 4400 ] 2 0.625% 96.250% ( 4400, 6600 ] 5 1.562% 97.812% ( 6600, 9900 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 13 Average: 769.4615 StdDev: 1047.66 Min: 135 Median: 315.0000 Max: 3525 Percentiles: P50: 315.00 P75: 797.50 P99: 3525.00 P99.9: 3525.00 P99.99: 3525.00 ------------------------------------------------------ ( 110, 170 ] 4 30.769% 30.769% ###### ( 170, 250 ] 2 15.385% 46.154% ### ( 250, 380 ] 1 7.692% 53.846% ## ( 380, 580 ] 2 15.385% 69.231% ### ( 580, 870 ] 1 7.692% 76.923% ## ( 870, 1300 ] 1 7.692% 84.615% ## ( 1900, 2900 ] 1 7.692% 92.308% ## ( 2900, 4400 ] 1 7.692% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 323.78 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.979 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.59 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.411 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/10/16-06:20:02 ... thread 0: (1000000,4000000) ops and (333988.4,336808.9) ops/second in (2.994116,11.876171) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/4 2.40 GB 214.0 2.2 0.0 2.2 5.8 3.7 0.0 1.6 115.9 314.4 19.02 17.69 61 0.312 2238K 2366 0.0 0.0 L1 5/0 550.14 MB 55.0 1.4 1.0 0.4 1.4 1.0 0.2 1.3 231.8 230.9 6.25 6.08 2 3.124 1470K 5249 0.0 0.0 L2 1/0 2.09 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.6 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 13/0 651.33 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 222.4 222.4 1.12 1.04 1 1.123 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 153.2 153.2 1.47 1.09 1 1.467 228K 0 0.0 0.0 L5 1052/0 86.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1258/4 99.82 GB 0.0 4.4 1.7 2.7 8.1 5.4 2.8 2.2 153.3 281.7 29.38 27.37 67 0.439 4574K 7801 0.0 0.0 Int 0/0 0.00 KB 0.0 4.4 1.7 2.7 8.1 5.4 2.7 2.2 153.3 281.7 29.38 27.37 67 0.439 4574K 7801 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.4 1.7 2.7 4.4 1.7 0.0 0.0 240.2 239.8 18.75 17.92 14 1.339 4574K 7801 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 355.5 10.63 9.45 53 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.08 GB write, 683.31 MB/s write, 4.40 GB read, 371.94 MB/s read, 29.4 seconds Interval compaction: 8.08 GB write, 696.81 MB/s write, 4.40 GB read, 379.29 MB/s read, 29.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 919504 Average: 2.1697 StdDev: 12.12 Min: 0 Median: 1.4878 Max: 4190 Percentiles: P50: 1.49 P75: 1.86 P99: 5.42 P99.9: 9.82 P99.99: 14.60 ------------------------------------------------------ [ 0, 1 ] 160402 17.444% 17.444% ### ( 1, 2 ] 613617 66.733% 84.178% ############# ( 2, 3 ] 98347 10.696% 94.874% ## ( 3, 4 ] 26017 2.829% 97.703% # ( 4, 6 ] 16820 1.829% 99.532% ( 6, 10 ] 3540 0.385% 99.917% ( 10, 15 ] 728 0.079% 99.996% ( 15, 22 ] 69 0.008% 100.004% ( 22, 34 ] 7 0.001% 100.005% ( 34, 51 ] 4 0.000% 100.005% ( 51, 76 ] 4 0.000% 100.006% ( 110, 170 ] 10 0.001% 100.007% ( 170, 250 ] 33 0.004% 100.010% ( 250, 380 ] 10 0.001% 100.011% ( 380, 580 ] 23 0.003% 100.014% ( 580, 870 ] 19 0.002% 100.016% ( 870, 1300 ] 13 0.001% 100.017% ( 1300, 1900 ] 5 0.001% 100.018% ( 1900, 2900 ] 3 0.000% 100.018% ( 2900, 4400 ] 6 0.001% 100.019% ** Level 1 read latency histogram (micros): Count: 95873 Average: 2.3617 StdDev: 15.38 Min: 0 Median: 1.5403 Max: 2030 Percentiles: P50: 1.54 P75: 1.90 P99: 5.44 P99.9: 11.52 P99.99: 905.49 ------------------------------------------------------ [ 0, 1 ] 11853 12.363% 12.363% ## ( 1, 2 ] 66780 69.655% 82.018% ############## ( 2, 3 ] 12265 12.793% 94.811% ### ( 3, 4 ] 2738 2.856% 97.667% # ( 4, 6 ] 1781 1.858% 99.524% ( 6, 10 ] 333 0.347% 99.872% ( 10, 15 ] 89 0.093% 99.965% ( 15, 22 ] 6 0.006% 99.971% ( 22, 34 ] 1 0.001% 99.972% ( 51, 76 ] 1 0.001% 99.973% ( 110, 170 ] 2 0.002% 99.975% ( 170, 250 ] 1 0.001% 99.976% ( 380, 580 ] 12 0.013% 99.989% ( 580, 870 ] 1 0.001% 99.990% ( 870, 1300 ] 5 0.005% 99.995% ( 1300, 1900 ] 4 0.004% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 95398 Average: 2.3083 StdDev: 22.58 Min: 0 Median: 1.4845 Max: 4741 Percentiles: P50: 1.48 P75: 1.88 P99: 5.74 P99.9: 11.34 P99.99: 713.46 ------------------------------------------------------ [ 0, 1 ] 18176 19.053% 19.053% #### ( 1, 2 ] 60938 63.878% 82.930% ############# ( 2, 3 ] 10110 10.598% 93.528% ## ( 3, 4 ] 2996 3.141% 96.669% # ( 4, 6 ] 2557 2.680% 99.349% # ( 6, 10 ] 501 0.525% 99.874% ( 10, 15 ] 92 0.096% 99.971% ( 15, 22 ] 9 0.009% 99.980% ( 51, 76 ] 4 0.004% 99.984% ( 76, 110 ] 1 0.001% 99.985% ( 170, 250 ] 1 0.001% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 6 0.006% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57117 Average: 4.5196 StdDev: 114.03 Min: 1 Median: 1.6062 Max: 9186 Percentiles: P50: 1.61 P75: 1.99 P99: 5.99 P99.9: 14.99 P99.99: 7543.92 ------------------------------------------------------ [ 0, 1 ] 6051 10.594% 10.594% ## ( 1, 2 ] 37126 65.000% 75.594% ############# ( 2, 3 ] 10226 17.904% 93.498% #### ( 3, 4 ] 1631 2.856% 96.353% # ( 4, 6 ] 1522 2.665% 99.018% # ( 6, 10 ] 415 0.727% 99.744% ( 10, 15 ] 89 0.156% 99.900% ( 15, 22 ] 11 0.019% 99.919% ( 22, 34 ] 2 0.004% 99.923% ( 110, 170 ] 1 0.002% 99.925% ( 170, 250 ] 1 0.002% 99.926% ( 380, 580 ] 4 0.007% 99.933% ( 580, 870 ] 3 0.005% 99.939% ( 870, 1300 ] 15 0.026% 99.965% ( 1300, 1900 ] 4 0.007% 99.972% ( 1900, 2900 ] 2 0.004% 99.975% ( 2900, 4400 ] 1 0.002% 99.977% ( 4400, 6600 ] 5 0.009% 99.986% ( 6600, 9900 ] 8 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 357.1562 StdDev: 1389.81 Min: 1 Median: 1.7109 Max: 8726 Percentiles: P50: 1.71 P75: 8.00 P99: 8391.43 P99.9: 8726.00 P99.99: 8726.00 ------------------------------------------------------ [ 0, 1 ] 69 21.562% 21.562% #### ( 1, 2 ] 128 40.000% 61.562% ######## ( 2, 3 ] 26 8.125% 69.688% ## ( 4, 6 ] 15 4.688% 74.375% # ( 6, 10 ] 4 1.250% 75.625% ( 10, 15 ] 37 11.562% 87.188% ## ( 15, 22 ] 1 0.312% 87.500% ( 22, 34 ] 1 0.312% 87.812% ( 51, 76 ] 2 0.625% 88.438% ( 110, 170 ] 1 0.312% 88.750% ( 170, 250 ] 4 1.250% 90.000% ( 380, 580 ] 2 0.625% 90.625% ( 580, 870 ] 4 1.250% 91.875% ( 870, 1300 ] 6 1.875% 93.750% ( 1300, 1900 ] 5 1.562% 95.312% ( 1900, 2900 ] 1 0.312% 95.625% ( 2900, 4400 ] 2 0.625% 96.250% ( 4400, 6600 ] 5 1.562% 97.812% ( 6600, 9900 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.3500 StdDev: 1109.74 Min: 86 Median: 413.3333 Max: 4162 Percentiles: P50: 413.33 P75: 1300.00 P99: 4162.00 P99.9: 4162.00 P99.99: 4162.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 10 25.000% 37.500% ##### ( 170, 250 ] 2 5.000% 42.500% # ( 250, 380 ] 2 5.000% 47.500% # ( 380, 580 ] 6 15.000% 62.500% ### ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 2 5.000% 80.000% # ( 1900, 2900 ] 5 12.500% 92.500% ### ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 325.00 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.346 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.71 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.367 H:M:S, 12.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/10/16-06:20:05 ... thread 0: (1000000,5000000) ops and (346699.6,338741.6) ops/second in (2.884341,14.760512) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/8 3.38 GB 295.7 3.0 0.0 3.0 7.7 4.7 0.0 1.6 122.8 313.1 25.14 23.44 79 0.318 3134K 3350 0.0 0.0 L1 5/0 550.14 MB 55.0 1.4 1.0 0.4 1.4 1.0 0.2 1.3 231.8 230.9 6.25 6.08 2 3.124 1470K 5249 0.0 0.0 L2 1/0 2.09 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.6 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 13/0 651.33 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 222.4 222.4 1.12 1.04 1 1.123 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 153.2 153.2 1.47 1.09 1 1.467 228K 0 0.0 0.0 L5 1052/0 86.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/8 100.80 GB 0.0 5.3 1.7 3.6 9.9 6.4 2.8 2.1 151.8 286.4 35.50 33.13 85 0.418 5469K 8785 0.0 0.0 Int 0/0 0.00 KB 0.0 5.3 1.7 3.6 9.9 6.4 2.7 2.1 151.8 286.4 35.50 33.13 85 0.418 5469K 8785 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.3 1.7 3.6 5.3 1.7 0.0 0.0 243.7 243.2 22.11 21.22 17 1.301 5469K 8785 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 357.6 13.39 11.91 68 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.0 total, 14.8 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.93 GB write, 677.83 MB/s write, 5.26 GB read, 359.21 MB/s read, 35.5 seconds Interval compaction: 9.93 GB write, 688.61 MB/s write, 5.26 GB read, 364.92 MB/s read, 35.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 13, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1180844 Average: 2.1424 StdDev: 12.08 Min: 0 Median: 1.4717 Max: 4190 Percentiles: P50: 1.47 P75: 1.85 P99: 5.34 P99.9: 9.79 P99.99: 14.73 ------------------------------------------------------ [ 0, 1 ] 219586 18.596% 18.596% #### ( 1, 2 ] 786197 66.579% 85.175% ############# ( 2, 3 ] 118700 10.052% 95.227% ## ( 3, 4 ] 31196 2.642% 97.869% # ( 4, 6 ] 19956 1.690% 99.559% ( 6, 10 ] 4247 0.360% 99.919% ( 10, 15 ] 893 0.076% 99.994% ( 15, 22 ] 90 0.008% 100.002% ( 22, 34 ] 10 0.001% 100.003% ( 34, 51 ] 5 0.000% 100.003% ( 51, 76 ] 6 0.001% 100.004% ( 110, 170 ] 16 0.001% 100.005% ( 170, 250 ] 40 0.003% 100.008% ( 250, 380 ] 14 0.001% 100.009% ( 380, 580 ] 31 0.003% 100.012% ( 580, 870 ] 21 0.002% 100.014% ( 870, 1300 ] 17 0.001% 100.015% ( 1300, 1900 ] 6 0.001% 100.016% ( 1900, 2900 ] 6 0.001% 100.016% ( 2900, 4400 ] 7 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 95873 Average: 2.3617 StdDev: 15.38 Min: 0 Median: 1.5403 Max: 2030 Percentiles: P50: 1.54 P75: 1.90 P99: 5.44 P99.9: 11.52 P99.99: 905.49 ------------------------------------------------------ [ 0, 1 ] 11853 12.363% 12.363% ## ( 1, 2 ] 66780 69.655% 82.018% ############## ( 2, 3 ] 12265 12.793% 94.811% ### ( 3, 4 ] 2738 2.856% 97.667% # ( 4, 6 ] 1781 1.858% 99.524% ( 6, 10 ] 333 0.347% 99.872% ( 10, 15 ] 89 0.093% 99.965% ( 15, 22 ] 6 0.006% 99.971% ( 22, 34 ] 1 0.001% 99.972% ( 51, 76 ] 1 0.001% 99.973% ( 110, 170 ] 2 0.002% 99.975% ( 170, 250 ] 1 0.001% 99.976% ( 380, 580 ] 12 0.013% 99.989% ( 580, 870 ] 1 0.001% 99.990% ( 870, 1300 ] 5 0.005% 99.995% ( 1300, 1900 ] 4 0.004% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 95398 Average: 2.3083 StdDev: 22.58 Min: 0 Median: 1.4845 Max: 4741 Percentiles: P50: 1.48 P75: 1.88 P99: 5.74 P99.9: 11.34 P99.99: 713.46 ------------------------------------------------------ [ 0, 1 ] 18176 19.053% 19.053% #### ( 1, 2 ] 60938 63.878% 82.930% ############# ( 2, 3 ] 10110 10.598% 93.528% ## ( 3, 4 ] 2996 3.141% 96.669% # ( 4, 6 ] 2557 2.680% 99.349% # ( 6, 10 ] 501 0.525% 99.874% ( 10, 15 ] 92 0.096% 99.971% ( 15, 22 ] 9 0.009% 99.980% ( 51, 76 ] 4 0.004% 99.984% ( 76, 110 ] 1 0.001% 99.985% ( 170, 250 ] 1 0.001% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 6 0.006% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57117 Average: 4.5196 StdDev: 114.03 Min: 1 Median: 1.6062 Max: 9186 Percentiles: P50: 1.61 P75: 1.99 P99: 5.99 P99.9: 14.99 P99.99: 7543.92 ------------------------------------------------------ [ 0, 1 ] 6051 10.594% 10.594% ## ( 1, 2 ] 37126 65.000% 75.594% ############# ( 2, 3 ] 10226 17.904% 93.498% #### ( 3, 4 ] 1631 2.856% 96.353% # ( 4, 6 ] 1522 2.665% 99.018% # ( 6, 10 ] 415 0.727% 99.744% ( 10, 15 ] 89 0.156% 99.900% ( 15, 22 ] 11 0.019% 99.919% ( 22, 34 ] 2 0.004% 99.923% ( 110, 170 ] 1 0.002% 99.925% ( 170, 250 ] 1 0.002% 99.926% ( 380, 580 ] 4 0.007% 99.933% ( 580, 870 ] 3 0.005% 99.939% ( 870, 1300 ] 15 0.026% 99.965% ( 1300, 1900 ] 4 0.007% 99.972% ( 1900, 2900 ] 2 0.004% 99.975% ( 2900, 4400 ] 1 0.002% 99.977% ( 4400, 6600 ] 5 0.009% 99.986% ( 6600, 9900 ] 8 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 357.1562 StdDev: 1389.81 Min: 1 Median: 1.7109 Max: 8726 Percentiles: P50: 1.71 P75: 8.00 P99: 8391.43 P99.9: 8726.00 P99.99: 8726.00 ------------------------------------------------------ [ 0, 1 ] 69 21.562% 21.562% #### ( 1, 2 ] 128 40.000% 61.562% ######## ( 2, 3 ] 26 8.125% 69.688% ## ( 4, 6 ] 15 4.688% 74.375% # ( 6, 10 ] 4 1.250% 75.625% ( 10, 15 ] 37 11.562% 87.188% ## ( 15, 22 ] 1 0.312% 87.500% ( 22, 34 ] 1 0.312% 87.812% ( 51, 76 ] 2 0.625% 88.438% ( 110, 170 ] 1 0.312% 88.750% ( 170, 250 ] 4 1.250% 90.000% ( 380, 580 ] 2 0.625% 90.625% ( 580, 870 ] 4 1.250% 91.875% ( 870, 1300 ] 6 1.875% 93.750% ( 1300, 1900 ] 5 1.562% 95.312% ( 1900, 2900 ] 1 0.312% 95.625% ( 2900, 4400 ] 2 0.625% 96.250% ( 4400, 6600 ] 5 1.562% 97.812% ( 6600, 9900 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.3500 StdDev: 1109.74 Min: 86 Median: 413.3333 Max: 4162 Percentiles: P50: 413.33 P75: 1300.00 P99: 4162.00 P99.9: 4162.00 P99.99: 4162.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 10 25.000% 37.500% ##### ( 170, 250 ] 2 5.000% 42.500% # ( 250, 380 ] 2 5.000% 47.500% # ( 380, 580 ] 6 15.000% 62.500% ### ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 2 5.000% 80.000% # ( 1900, 2900 ] 5 12.500% 92.500% ### ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 15.0 total, 2.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 328.12 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.604 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 341.22 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.258 H:M:S, 8.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/10/16-06:20:09 ... thread 0: (1000000,6000000) ops and (219548.7,310634.4) ops/second in (4.554799,19.315311) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/17 4.36 GB 31.5 4.3 0.0 4.3 10.0 5.7 0.0 1.8 134.1 310.2 32.88 30.79 99 0.332 4477K 4664 0.0 0.0 L1 5/5 550.14 MB 0.0 1.4 1.0 0.4 1.4 1.0 0.2 1.3 231.8 230.9 6.25 6.08 2 3.124 1470K 5249 0.0 0.0 L2 1/0 2.09 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.6 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 13/0 651.33 MB 0.7 0.2 0.2 0.0 0.2 0.2 0.6 1.0 222.4 222.4 1.12 1.04 1 1.123 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.7 1.0 153.2 153.2 1.47 1.09 1 1.467 228K 0 0.0 0.0 L5 1052/0 86.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/22 101.79 GB 0.0 6.6 1.7 4.9 12.2 7.3 2.8 2.2 155.2 288.9 43.24 40.47 105 0.412 6813K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.6 1.7 4.9 12.2 7.3 2.7 2.2 155.2 288.9 43.24 40.47 105 0.412 6813K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.6 1.7 4.9 6.5 1.7 0.0 0.0 248.0 247.6 27.06 26.09 22 1.230 6813K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 358.1 16.18 14.39 83 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): 19.6 total, 19.3 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 12.20 GB write, 639.08 MB/s write, 6.55 GB read, 343.19 MB/s read, 43.2 seconds Interval compaction: 12.20 GB write, 646.84 MB/s write, 6.55 GB read, 347.36 MB/s read, 43.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 15, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1565500 Average: 2.1528 StdDev: 12.73 Min: 0 Median: 1.4568 Max: 4506 Percentiles: P50: 1.46 P75: 1.83 P99: 5.29 P99.9: 10.47 P99.99: 131.90 ------------------------------------------------------ [ 0, 1 ] 305615 19.522% 19.522% #### ( 1, 2 ] 1044494 66.720% 86.241% ############# ( 2, 3 ] 144616 9.238% 95.479% ## ( 3, 4 ] 39648 2.533% 98.012% # ( 4, 6 ] 23937 1.529% 99.541% ( 6, 10 ] 5508 0.352% 99.893% ( 10, 15 ] 1237 0.079% 99.972% ( 15, 22 ] 141 0.009% 99.981% ( 22, 34 ] 14 0.001% 99.981% ( 34, 51 ] 7 0.000% 99.982% ( 51, 76 ] 10 0.001% 99.983% ( 76, 110 ] 46 0.003% 99.985% ( 110, 170 ] 193 0.012% 99.998% ( 170, 250 ] 100 0.006% 100.004% ( 250, 380 ] 35 0.002% 100.006% ( 380, 580 ] 47 0.003% 100.009% ( 580, 870 ] 40 0.003% 100.012% ( 870, 1300 ] 21 0.001% 100.013% ( 1300, 1900 ] 8 0.001% 100.014% ( 1900, 2900 ] 6 0.000% 100.014% ( 2900, 4400 ] 10 0.001% 100.015% ( 4400, 6600 ] 1 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 95874 Average: 2.3636 StdDev: 15.39 Min: 0 Median: 1.5403 Max: 2030 Percentiles: P50: 1.54 P75: 1.90 P99: 5.44 P99.9: 11.58 P99.99: 905.48 ------------------------------------------------------ [ 0, 1 ] 11853 12.363% 12.363% ## ( 1, 2 ] 66780 69.654% 82.017% ############## ( 2, 3 ] 12265 12.793% 94.810% ### ( 3, 4 ] 2738 2.856% 97.666% # ( 4, 6 ] 1781 1.858% 99.523% ( 6, 10 ] 333 0.347% 99.871% ( 10, 15 ] 89 0.093% 99.963% ( 15, 22 ] 6 0.006% 99.970% ( 22, 34 ] 1 0.001% 99.971% ( 51, 76 ] 1 0.001% 99.972% ( 110, 170 ] 2 0.002% 99.974% ( 170, 250 ] 2 0.002% 99.976% ( 380, 580 ] 12 0.013% 99.989% ( 580, 870 ] 1 0.001% 99.990% ( 870, 1300 ] 5 0.005% 99.995% ( 1300, 1900 ] 4 0.004% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 95398 Average: 2.3083 StdDev: 22.58 Min: 0 Median: 1.4845 Max: 4741 Percentiles: P50: 1.48 P75: 1.88 P99: 5.74 P99.9: 11.34 P99.99: 713.46 ------------------------------------------------------ [ 0, 1 ] 18176 19.053% 19.053% #### ( 1, 2 ] 60938 63.878% 82.930% ############# ( 2, 3 ] 10110 10.598% 93.528% ## ( 3, 4 ] 2996 3.141% 96.669% # ( 4, 6 ] 2557 2.680% 99.349% # ( 6, 10 ] 501 0.525% 99.874% ( 10, 15 ] 92 0.096% 99.971% ( 15, 22 ] 9 0.009% 99.980% ( 51, 76 ] 4 0.004% 99.984% ( 76, 110 ] 1 0.001% 99.985% ( 170, 250 ] 1 0.001% 99.986% ( 250, 380 ] 3 0.003% 99.990% ( 580, 870 ] 1 0.001% 99.991% ( 870, 1300 ] 6 0.006% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 57117 Average: 4.5196 StdDev: 114.03 Min: 1 Median: 1.6062 Max: 9186 Percentiles: P50: 1.61 P75: 1.99 P99: 5.99 P99.9: 14.99 P99.99: 7543.92 ------------------------------------------------------ [ 0, 1 ] 6051 10.594% 10.594% ## ( 1, 2 ] 37126 65.000% 75.594% ############# ( 2, 3 ] 10226 17.904% 93.498% #### ( 3, 4 ] 1631 2.856% 96.353% # ( 4, 6 ] 1522 2.665% 99.018% # ( 6, 10 ] 415 0.727% 99.744% ( 10, 15 ] 89 0.156% 99.900% ( 15, 22 ] 11 0.019% 99.919% ( 22, 34 ] 2 0.004% 99.923% ( 110, 170 ] 1 0.002% 99.925% ( 170, 250 ] 1 0.002% 99.926% ( 380, 580 ] 4 0.007% 99.933% ( 580, 870 ] 3 0.005% 99.939% ( 870, 1300 ] 15 0.026% 99.965% ( 1300, 1900 ] 4 0.007% 99.972% ( 1900, 2900 ] 2 0.004% 99.975% ( 2900, 4400 ] 1 0.002% 99.977% ( 4400, 6600 ] 5 0.009% 99.986% ( 6600, 9900 ] 8 0.014% 100.000% ** Level 4 read latency histogram (micros): Count: 320 Average: 357.1562 StdDev: 1389.81 Min: 1 Median: 1.7109 Max: 8726 Percentiles: P50: 1.71 P75: 8.00 P99: 8391.43 P99.9: 8726.00 P99.99: 8726.00 ------------------------------------------------------ [ 0, 1 ] 69 21.562% 21.562% #### ( 1, 2 ] 128 40.000% 61.562% ######## ( 2, 3 ] 26 8.125% 69.688% ## ( 4, 6 ] 15 4.688% 74.375% # ( 6, 10 ] 4 1.250% 75.625% ( 10, 15 ] 37 11.562% 87.188% ## ( 15, 22 ] 1 0.312% 87.500% ( 22, 34 ] 1 0.312% 87.812% ( 51, 76 ] 2 0.625% 88.438% ( 110, 170 ] 1 0.312% 88.750% ( 170, 250 ] 4 1.250% 90.000% ( 380, 580 ] 2 0.625% 90.625% ( 580, 870 ] 4 1.250% 91.875% ( 870, 1300 ] 6 1.875% 93.750% ( 1300, 1900 ] 5 1.562% 95.312% ( 1900, 2900 ] 1 0.312% 95.625% ( 2900, 4400 ] 2 0.625% 96.250% ( 4400, 6600 ] 5 1.562% 97.812% ( 6600, 9900 ] 7 2.188% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 898.3500 StdDev: 1109.74 Min: 86 Median: 413.3333 Max: 4162 Percentiles: P50: 413.33 P75: 1300.00 P99: 4162.00 P99.9: 4162.00 P99.99: 4162.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 10 25.000% 37.500% ##### ( 170, 250 ] 2 5.000% 42.500% # ( 250, 380 ] 2 5.000% 47.500% # ( 380, 580 ] 6 15.000% 62.500% ### ( 580, 870 ] 4 10.000% 72.500% ## ( 870, 1300 ] 1 2.500% 75.000% # ( 1300, 1900 ] 2 5.000% 80.000% # ( 1900, 2900 ] 5 12.500% 92.500% ### ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 19.6 total, 4.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 302.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.457 H:M:S, 17.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 216.08 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.853 H:M:S, 40.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/10/16-06:20:35 ... thread 0: (1000000,7000000) ops and (38624.5,154848.0) ops/second in (25.890317,45.205628) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/9 1.23 GB 18.9 4.6 0.0 4.6 11.1 6.6 0.0 1.7 120.4 294.3 38.73 34.33 112 0.346 4733K 4918 0.0 0.0 L1 6/6 477.18 MB 0.0 6.0 5.1 0.9 5.9 5.0 0.2 1.2 209.1 205.3 29.42 26.49 3 9.806 6246K 110K 0.0 0.0 L2 4/3 515.12 MB 1.3 0.4 0.2 0.2 0.4 0.2 4.6 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 39/10 2.72 GB 2.1 2.5 1.9 0.6 2.5 1.9 2.5 1.3 132.4 131.5 19.30 12.12 7 2.757 2465K 17K 0.0 0.0 L4 167/5 9.88 GB 1.0 1.7 1.6 0.1 1.7 1.6 0.7 1.1 120.9 120.7 14.71 8.49 14 1.051 1718K 0 0.0 0.0 L5 1068/0 87.78 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/33 102.59 GB 0.0 15.2 8.8 6.4 21.6 15.2 10.0 3.3 149.7 213.4 103.69 82.89 138 0.751 15M 133K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.2 8.8 6.4 21.6 15.2 9.9 3.3 149.7 213.4 103.69 82.89 138 0.751 15M 133K 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 15.2 8.8 6.4 15.0 8.6 0.0 0.0 187.9 186.3 82.62 65.92 43 1.921 15M 133K 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 320.0 21.06 16.98 95 0.222 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): 45.4 total, 45.2 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: 21.61 GB write, 486.99 MB/s write, 15.16 GB read, 341.67 MB/s read, 103.7 seconds Interval compaction: 21.61 GB write, 489.52 MB/s write, 15.16 GB read, 343.45 MB/s read, 103.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 39, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 39, interval: 55 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2799505 Average: 3.2092 StdDev: 31.75 Min: 0 Median: 1.4524 Max: 7351 Percentiles: P50: 1.45 P75: 1.84 P99: 8.28 P99.9: 167.23 P99.99: 576.86 ------------------------------------------------------ [ 0, 1 ] 584070 20.863% 20.863% #### ( 1, 2 ] 1802947 64.402% 85.266% ############# ( 2, 3 ] 232302 8.298% 93.564% ## ( 3, 4 ] 79047 2.824% 96.387% # ( 4, 6 ] 63654 2.274% 98.661% ( 6, 10 ] 16682 0.596% 99.257% ( 10, 15 ] 3579 0.128% 99.385% ( 15, 22 ] 728 0.026% 99.411% ( 22, 34 ] 39 0.001% 99.412% ( 34, 51 ] 8 0.000% 99.412% ( 51, 76 ] 20 0.001% 99.413% ( 76, 110 ] 5543 0.198% 99.611% ( 110, 170 ] 8478 0.303% 99.914% ( 170, 250 ] 839 0.030% 99.944% ( 250, 380 ] 666 0.024% 99.968% ( 380, 580 ] 633 0.023% 99.990% ( 580, 870 ] 331 0.012% 100.002% ( 870, 1300 ] 94 0.003% 100.006% ( 1300, 1900 ] 46 0.002% 100.007% ( 1900, 2900 ] 44 0.002% 100.009% ( 2900, 4400 ] 67 0.002% 100.011% ( 4400, 6600 ] 26 0.001% 100.012% ( 6600, 9900 ] 5 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 1100208 Average: 7.8067 StdDev: 121.66 Min: 0 Median: 1.9566 Max: 10060 Percentiles: P50: 1.96 P75: 2.91 P99: 9.58 P99.9: 119.75 P99.99: 177.99 ------------------------------------------------------ [ 0, 1 ] 57746 5.249% 5.249% # ( 1, 2 ] 514682 46.780% 52.029% ######### ( 2, 3 ] 276488 25.131% 77.160% ##### ( 3, 4 ] 98491 8.952% 86.112% ## ( 4, 6 ] 116525 10.591% 96.703% ## ( 6, 10 ] 28234 2.566% 99.269% # ( 10, 15 ] 5263 0.478% 99.747% ( 15, 22 ] 698 0.063% 99.811% ( 22, 34 ] 58 0.005% 99.816% ( 34, 51 ] 27 0.002% 99.819% ( 51, 76 ] 16 0.001% 99.820% ( 76, 110 ] 694 0.063% 99.883% ( 110, 170 ] 1150 0.105% 99.988% ( 170, 250 ] 270 0.025% 100.012% ( 250, 380 ] 361 0.033% 100.045% ( 380, 580 ] 491 0.045% 100.090% ( 580, 870 ] 517 0.047% 100.137% ( 870, 1300 ] 441 0.040% 100.177% ( 1300, 1900 ] 250 0.023% 100.199% ( 1900, 2900 ] 358 0.033% 100.232% ( 2900, 4400 ] 430 0.039% 100.271% ( 4400, 6600 ] 147 0.013% 100.284% ( 6600, 9900 ] 52 0.005% 100.289% ( 9900, 14000 ] 2 0.000% 100.289% ** Level 2 read latency histogram (micros): Count: 124170 Average: 5.5113 StdDev: 103.21 Min: 0 Median: 1.6095 Max: 8084 Percentiles: P50: 1.61 P75: 2.16 P99: 8.54 P99.9: 783.26 P99.99: 5716.60 ------------------------------------------------------ [ 0, 1 ] 18315 14.750% 14.750% ### ( 1, 2 ] 71810 57.832% 72.582% ############ ( 2, 3 ] 19048 15.340% 87.922% ### ( 3, 4 ] 6157 4.959% 92.881% # ( 4, 6 ] 6591 5.308% 98.189% # ( 6, 10 ] 1585 1.276% 99.465% ( 10, 15 ] 316 0.254% 99.720% ( 15, 22 ] 47 0.038% 99.758% ( 34, 51 ] 1 0.001% 99.758% ( 51, 76 ] 4 0.003% 99.762% ( 76, 110 ] 6 0.005% 99.766% ( 110, 170 ] 40 0.032% 99.799% ( 170, 250 ] 34 0.027% 99.826% ( 250, 380 ] 35 0.028% 99.854% ( 380, 580 ] 33 0.027% 99.881% ( 580, 870 ] 34 0.027% 99.908% ( 870, 1300 ] 29 0.023% 99.932% ( 1300, 1900 ] 13 0.010% 99.942% ( 1900, 2900 ] 27 0.022% 99.964% ( 2900, 4400 ] 26 0.021% 99.985% ( 4400, 6600 ] 11 0.009% 99.994% ( 6600, 9900 ] 8 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 195554 Average: 5.8968 StdDev: 104.98 Min: 1 Median: 2.0011 Max: 9186 Percentiles: P50: 2.00 P75: 2.92 P99: 8.55 P99.9: 14.27 P99.99: 271.32 ------------------------------------------------------ [ 0, 1 ] 6500 3.324% 3.324% # ( 1, 2 ] 91220 46.647% 49.971% ######### ( 2, 3 ] 53478 27.347% 77.318% ##### ( 3, 4 ] 17879 9.143% 86.461% ## ( 4, 6 ] 22242 11.374% 97.834% ## ( 6, 10 ] 3580 1.831% 99.665% ( 10, 15 ] 539 0.276% 99.941% ( 15, 22 ] 62 0.032% 99.972% ( 22, 34 ] 8 0.004% 99.976% ( 34, 51 ] 4 0.002% 99.979% ( 76, 110 ] 1 0.001% 99.979% ( 110, 170 ] 7 0.004% 99.983% ( 170, 250 ] 12 0.006% 99.989% ( 250, 380 ] 21 0.011% 99.999% ( 380, 580 ] 21 0.011% 100.010% ( 580, 870 ] 49 0.025% 100.035% ( 870, 1300 ] 62 0.032% 100.067% ( 1300, 1900 ] 34 0.017% 100.084% ( 1900, 2900 ] 28 0.014% 100.099% ( 2900, 4400 ] 40 0.020% 100.119% ( 4400, 6600 ] 20 0.010% 100.129% ( 6600, 9900 ] 11 0.006% 100.135% ** Level 4 read latency histogram (micros): Count: 37599 Average: 51.1765 StdDev: 319.40 Min: 1 Median: 2.3063 Max: 8726 Percentiles: P50: 2.31 P75: 3.52 P99: 1280.15 P99.9: 4331.66 P99.99: 7572.03 ------------------------------------------------------ [ 0, 1 ] 502 1.335% 1.335% ( 1, 2 ] 15193 40.408% 41.743% ######## ( 2, 3 ] 10134 26.953% 68.696% ##### ( 3, 4 ] 4555 12.115% 80.811% ## ( 4, 6 ] 4045 10.758% 91.569% ## ( 6, 10 ] 1117 2.971% 94.540% # ( 10, 15 ] 215 0.572% 95.112% ( 15, 22 ] 37 0.098% 95.210% ( 22, 34 ] 9 0.024% 95.234% ( 34, 51 ] 5 0.013% 95.247% ( 51, 76 ] 4 0.011% 95.258% ( 76, 110 ] 10 0.027% 95.284% ( 110, 170 ] 73 0.194% 95.479% ( 170, 250 ] 150 0.399% 95.878% ( 250, 380 ] 195 0.519% 96.396% ( 380, 580 ] 298 0.793% 97.189% ( 580, 870 ] 393 1.045% 98.234% ( 870, 1300 ] 303 0.806% 99.040% ( 1300, 1900 ] 149 0.396% 99.436% ( 1900, 2900 ] 100 0.266% 99.702% ( 2900, 4400 ] 79 0.210% 99.912% ( 4400, 6600 ] 27 0.072% 99.984% ( 6600, 9900 ] 11 0.029% 100.013% ** Level 5 read latency histogram (micros): Count: 120 Average: 1471.9417 StdDev: 1588.59 Min: 86 Median: 691.5385 Max: 5991 Percentiles: P50: 691.54 P75: 2316.67 P99: 5991.00 P99.9: 5991.00 P99.99: 5991.00 ------------------------------------------------------ ( 76, 110 ] 5 4.167% 4.167% # ( 110, 170 ] 15 12.500% 16.667% ### ( 170, 250 ] 9 7.500% 24.167% ## ( 250, 380 ] 7 5.833% 30.000% # ( 380, 580 ] 19 15.833% 45.833% ### ( 580, 870 ] 13 10.833% 56.667% ## ( 870, 1300 ] 8 6.667% 63.333% # ( 1300, 1900 ] 9 7.500% 70.833% ## ( 1900, 2900 ] 12 10.000% 80.833% ## ( 2900, 4400 ] 15 12.500% 93.333% ### ( 4400, 6600 ] 8 6.667% 100.000% # ** DB Stats ** Uptime(secs): 45.4 total, 25.9 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 151.60 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:25.785 H:M:S, 56.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 38.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:22.328 H:M:S, 86.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/10/16-06:20:40 ... thread 0: (1000000,8000000) ops and (213199.4,160333.3) ops/second in (4.690445,49.896073) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.54 GB 132.1 5.6 0.0 5.6 13.2 7.6 0.0 1.7 118.9 279.6 48.20 41.44 128 0.377 5820K 6343 0.0 0.0 L1 8/0 678.90 MB 67.9 7.1 5.8 1.4 7.0 5.7 0.2 1.2 193.9 190.8 37.76 32.01 4 9.439 6949K 110K 0.0 0.0 L2 3/2 158.27 MB 0.5 0.4 0.2 0.2 0.4 0.2 5.1 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 16/2 1.20 GB 1.0 3.4 2.4 1.0 3.3 2.4 2.8 1.4 133.6 132.7 25.74 16.24 11 2.340 3362K 21K 0.0 0.0 L4 167/0 9.57 GB 1.0 4.2 3.9 0.3 4.2 3.9 0.7 1.1 124.5 124.2 34.48 20.65 44 0.784 4235K 4239 0.0 0.0 L5 1100/0 90.43 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1304/8 103.55 GB 0.0 20.7 12.3 8.4 28.1 19.7 13.5 3.7 143.3 194.7 147.70 111.81 189 0.781 20M 143K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.7 12.3 8.4 28.1 19.7 13.4 3.7 143.3 194.7 147.70 111.81 189 0.781 20M 143K 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.7 12.3 8.4 20.5 12.1 0.0 0.0 173.3 172.0 122.14 92.16 81 1.508 20M 143K 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 303.2 25.55 19.65 108 0.237 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): 50.1 total, 49.9 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: 28.08 GB write, 573.63 MB/s write, 20.67 GB read, 422.15 MB/s read, 147.7 seconds Interval compaction: 28.08 GB write, 576.33 MB/s write, 20.67 GB read, 424.14 MB/s read, 147.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 65, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 65, interval: 81 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3080913 Average: 3.3194 StdDev: 35.93 Min: 0 Median: 1.4846 Max: 7695 Percentiles: P50: 1.48 P75: 1.88 P99: 8.33 P99.9: 167.23 P99.99: 687.08 ------------------------------------------------------ [ 0, 1 ] 593503 19.264% 19.264% #### ( 1, 2 ] 1954045 63.424% 82.688% ############# ( 2, 3 ] 299442 9.719% 92.407% ## ( 3, 4 ] 101364 3.290% 95.697% # ( 4, 6 ] 89452 2.903% 98.601% # ( 6, 10 ] 21135 0.686% 99.287% ( 10, 15 ] 4370 0.142% 99.429% ( 15, 22 ] 793 0.026% 99.454% ( 22, 34 ] 42 0.001% 99.456% ( 34, 51 ] 9 0.000% 99.456% ( 51, 76 ] 24 0.001% 99.457% ( 76, 110 ] 5552 0.180% 99.637% ( 110, 170 ] 8494 0.276% 99.913% ( 170, 250 ] 860 0.028% 99.941% ( 250, 380 ] 693 0.022% 99.963% ( 380, 580 ] 678 0.022% 99.985% ( 580, 870 ] 406 0.013% 99.998% ( 870, 1300 ] 145 0.005% 100.003% ( 1300, 1900 ] 83 0.003% 100.006% ( 1900, 2900 ] 72 0.002% 100.008% ( 2900, 4400 ] 104 0.003% 100.011% ( 4400, 6600 ] 34 0.001% 100.013% ( 6600, 9900 ] 7 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 1405356 Average: 7.7988 StdDev: 120.03 Min: 0 Median: 1.9839 Max: 10060 Percentiles: P50: 1.98 P75: 2.93 P99: 9.68 P99.9: 149.35 P99.99: 368.80 ------------------------------------------------------ [ 0, 1 ] 59968 4.267% 4.267% # ( 1, 2 ] 653220 46.481% 50.748% ######### ( 2, 3 ] 365973 26.041% 76.789% ##### ( 3, 4 ] 126714 9.017% 85.806% ## ( 4, 6 ] 150962 10.742% 96.548% ## ( 6, 10 ] 37442 2.664% 99.212% # ( 10, 15 ] 7078 0.504% 99.715% ( 15, 22 ] 917 0.065% 99.781% ( 22, 34 ] 71 0.005% 99.786% ( 34, 51 ] 37 0.003% 99.788% ( 51, 76 ] 20 0.001% 99.790% ( 76, 110 ] 736 0.052% 99.842% ( 110, 170 ] 1242 0.088% 99.931% ( 170, 250 ] 365 0.026% 99.957% ( 250, 380 ] 517 0.037% 99.993% ( 380, 580 ] 662 0.047% 100.040% ( 580, 870 ] 657 0.047% 100.087% ( 870, 1300 ] 568 0.040% 100.128% ( 1300, 1900 ] 327 0.023% 100.151% ( 1900, 2900 ] 470 0.033% 100.184% ( 2900, 4400 ] 544 0.039% 100.223% ( 4400, 6600 ] 179 0.013% 100.236% ( 6600, 9900 ] 62 0.004% 100.240% ( 9900, 14000 ] 2 0.000% 100.240% ** Level 2 read latency histogram (micros): Count: 124170 Average: 5.5113 StdDev: 103.21 Min: 0 Median: 1.6095 Max: 8084 Percentiles: P50: 1.61 P75: 2.16 P99: 8.54 P99.9: 783.26 P99.99: 5716.60 ------------------------------------------------------ [ 0, 1 ] 18315 14.750% 14.750% ### ( 1, 2 ] 71810 57.832% 72.582% ############ ( 2, 3 ] 19048 15.340% 87.922% ### ( 3, 4 ] 6157 4.959% 92.881% # ( 4, 6 ] 6591 5.308% 98.189% # ( 6, 10 ] 1585 1.276% 99.465% ( 10, 15 ] 316 0.254% 99.720% ( 15, 22 ] 47 0.038% 99.758% ( 34, 51 ] 1 0.001% 99.758% ( 51, 76 ] 4 0.003% 99.762% ( 76, 110 ] 6 0.005% 99.766% ( 110, 170 ] 40 0.032% 99.799% ( 170, 250 ] 34 0.027% 99.826% ( 250, 380 ] 35 0.028% 99.854% ( 380, 580 ] 33 0.027% 99.881% ( 580, 870 ] 34 0.027% 99.908% ( 870, 1300 ] 29 0.023% 99.932% ( 1300, 1900 ] 13 0.010% 99.942% ( 1900, 2900 ] 27 0.022% 99.964% ( 2900, 4400 ] 26 0.021% 99.985% ( 4400, 6600 ] 11 0.009% 99.994% ( 6600, 9900 ] 8 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 820796 Average: 7.0328 StdDev: 115.42 Min: 1 Median: 2.2208 Max: 32494 Percentiles: P50: 2.22 P75: 3.12 P99: 9.30 P99.9: 14.74 P99.99: 206.28 ------------------------------------------------------ [ 0, 1 ] 8763 1.068% 1.068% ( 1, 2 ] 346369 42.199% 43.267% ######## ( 2, 3 ] 250317 30.497% 73.764% ###### ( 3, 4 ] 85476 10.414% 84.177% ## ( 4, 6 ] 105391 12.840% 97.018% ### ( 6, 10 ] 19702 2.400% 99.418% ( 10, 15 ] 4177 0.509% 99.927% ( 15, 22 ] 402 0.049% 99.976% ( 22, 34 ] 32 0.004% 99.980% ( 34, 51 ] 19 0.002% 99.982% ( 51, 76 ] 1 0.000% 99.982% ( 76, 110 ] 3 0.000% 99.982% ( 110, 170 ] 27 0.003% 99.986% ( 170, 250 ] 77 0.009% 99.995% ( 250, 380 ] 168 0.020% 100.016% ( 380, 580 ] 225 0.027% 100.043% ( 580, 870 ] 313 0.038% 100.081% ( 870, 1300 ] 328 0.040% 100.121% ( 1300, 1900 ] 189 0.023% 100.144% ( 1900, 2900 ] 241 0.029% 100.173% ( 2900, 4400 ] 251 0.031% 100.204% ( 4400, 6600 ] 72 0.009% 100.213% ( 6600, 9900 ] 38 0.005% 100.217% ( 22000, 33000 ] 1 0.000% 100.218% ** Level 4 read latency histogram (micros): Count: 66370 Average: 67.7827 StdDev: 401.78 Min: 1 Median: 2.2706 Max: 27633 Percentiles: P50: 2.27 P75: 3.45 P99: 1850.37 P99.9: 5075.14 P99.99: 7766.55 ------------------------------------------------------ [ 0, 1 ] 836 1.260% 1.260% ( 1, 2 ] 27492 41.422% 42.682% ######## ( 2, 3 ] 17949 27.044% 69.726% ##### ( 3, 4 ] 7786 11.731% 81.457% ## ( 4, 6 ] 6469 9.747% 91.204% ## ( 6, 10 ] 1806 2.721% 93.925% # ( 10, 15 ] 370 0.557% 94.482% ( 15, 22 ] 51 0.077% 94.559% ( 22, 34 ] 20 0.030% 94.589% ( 34, 51 ] 8 0.012% 94.601% ( 51, 76 ] 13 0.020% 94.621% ( 76, 110 ] 27 0.041% 94.662% ( 110, 170 ] 145 0.218% 94.880% ( 170, 250 ] 237 0.357% 95.237% ( 250, 380 ] 332 0.500% 95.738% ( 380, 580 ] 533 0.803% 96.541% ( 580, 870 ] 693 1.044% 97.585% ( 870, 1300 ] 621 0.936% 98.520% ( 1300, 1900 ] 347 0.523% 99.043% ( 1900, 2900 ] 277 0.417% 99.461% ( 2900, 4400 ] 268 0.404% 99.864% ( 4400, 6600 ] 77 0.116% 99.980% ( 6600, 9900 ] 18 0.027% 100.008% ( 22000, 33000 ] 1 0.002% 100.009% ** Level 5 read latency histogram (micros): Count: 280 Average: 1579.2179 StdDev: 1638.72 Min: 86 Median: 773.3333 Max: 9145 Percentiles: P50: 773.33 P75: 2533.33 P99: 6420.00 P99.9: 8976.00 P99.99: 9145.00 ------------------------------------------------------ ( 76, 110 ] 7 2.500% 2.500% # ( 110, 170 ] 23 8.214% 10.714% ## ( 170, 250 ] 15 5.357% 16.071% # ( 250, 380 ] 27 9.643% 25.714% ## ( 380, 580 ] 44 15.714% 41.429% ### ( 580, 870 ] 36 12.857% 54.286% ### ( 870, 1300 ] 21 7.500% 61.786% ## ( 1300, 1900 ] 18 6.429% 68.214% # ( 1900, 2900 ] 30 10.714% 78.929% ## ( 2900, 4400 ] 36 12.857% 91.786% ### ( 4400, 6600 ] 22 7.857% 99.643% ## ( 6600, 9900 ] 1 0.357% 100.000% ** DB Stats ** Uptime(secs): 50.1 total, 4.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 157.05 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.673 H:M:S, 55.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 209.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:1.887 H:M:S, 40.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/10/16-06:20:43 ... thread 0: (1000000,9000000) ops and (317176.1,169654.8) ops/second in (3.152823,53.048896) 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/15 2.46 GB 37.8 6.2 0.0 6.2 14.6 8.5 0.0 1.7 118.4 281.6 53.21 46.03 143 0.372 6396K 6933 0.0 0.0 L1 8/8 678.90 MB 0.0 7.1 5.8 1.4 7.0 5.7 0.2 1.2 193.9 190.8 37.76 32.01 4 9.439 6949K 110K 0.0 0.0 L2 1/0 54.11 MB 0.5 0.4 0.2 0.2 0.4 0.2 5.1 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 16/0 887.33 MB 0.9 3.7 2.5 1.2 3.7 2.5 2.8 1.5 137.5 136.7 27.64 17.90 13 2.126 3729K 23K 0.0 0.0 L4 167/0 9.69 GB 1.0 4.8 4.4 0.4 4.8 4.4 0.7 1.1 129.7 129.4 37.70 23.48 48 0.785 4824K 4239 0.0 0.0 L5 1104/0 90.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1313/23 104.47 GB 0.0 22.2 12.8 9.3 30.5 21.2 13.8 3.6 143.8 197.8 157.82 120.89 210 0.752 22M 145K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.2 12.8 9.3 30.5 21.2 13.7 3.6 143.8 197.8 157.82 120.89 210 0.752 22M 145K 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 22.2 12.8 9.3 22.0 12.7 0.0 0.0 175.2 174.0 129.47 98.82 89 1.455 22M 145K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 306.7 28.35 22.07 121 0.234 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): 53.3 total, 53.1 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.49 GB write, 585.95 MB/s write, 22.16 GB read, 425.77 MB/s read, 157.8 seconds Interval compaction: 30.49 GB write, 588.55 MB/s write, 22.16 GB read, 427.65 MB/s read, 157.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 71, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 71, interval: 87 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3425014 Average: 3.2494 StdDev: 34.31 Min: 0 Median: 1.5038 Max: 7695 Percentiles: P50: 1.50 P75: 1.90 P99: 8.06 P99.9: 164.76 P99.99: 598.72 ------------------------------------------------------ [ 0, 1 ] 619222 18.079% 18.079% #### ( 1, 2 ] 2170157 63.362% 81.441% ############# ( 2, 3 ] 367884 10.741% 92.182% ## ( 3, 4 ] 116232 3.394% 95.576% # ( 4, 6 ] 104784 3.059% 98.635% # ( 6, 10 ] 24252 0.708% 99.344% ( 10, 15 ] 4787 0.140% 99.483% ( 15, 22 ] 840 0.025% 99.508% ( 22, 34 ] 48 0.001% 99.509% ( 34, 51 ] 9 0.000% 99.510% ( 51, 76 ] 27 0.001% 99.510% ( 76, 110 ] 5572 0.163% 99.673% ( 110, 170 ] 8521 0.249% 99.922% ( 170, 250 ] 893 0.026% 99.948% ( 250, 380 ] 716 0.021% 99.969% ( 380, 580 ] 702 0.020% 99.989% ( 580, 870 ] 426 0.012% 100.002% ( 870, 1300 ] 158 0.005% 100.006% ( 1300, 1900 ] 88 0.003% 100.009% ( 1900, 2900 ] 73 0.002% 100.011% ( 2900, 4400 ] 104 0.003% 100.014% ( 4400, 6600 ] 34 0.001% 100.015% ( 6600, 9900 ] 7 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 1488310 Average: 7.5478 StdDev: 116.70 Min: 0 Median: 1.9777 Max: 10060 Percentiles: P50: 1.98 P75: 2.92 P99: 9.66 P99.9: 148.24 P99.99: 366.43 ------------------------------------------------------ [ 0, 1 ] 61548 4.135% 4.135% # ( 1, 2 ] 698181 46.911% 51.046% ######### ( 2, 3 ] 388971 26.135% 77.182% ##### ( 3, 4 ] 132205 8.883% 86.064% ## ( 4, 6 ] 156499 10.515% 96.580% ## ( 6, 10 ] 39412 2.648% 99.228% # ( 10, 15 ] 7348 0.494% 99.721% ( 15, 22 ] 948 0.064% 99.785% ( 22, 34 ] 72 0.005% 99.790% ( 34, 51 ] 37 0.002% 99.792% ( 51, 76 ] 20 0.001% 99.794% ( 76, 110 ] 758 0.051% 99.845% ( 110, 170 ] 1291 0.087% 99.931% ( 170, 250 ] 392 0.026% 99.958% ( 250, 380 ] 535 0.036% 99.994% ( 380, 580 ] 681 0.046% 100.040% ( 580, 870 ] 669 0.045% 100.084% ( 870, 1300 ] 569 0.038% 100.123% ( 1300, 1900 ] 329 0.022% 100.145% ( 1900, 2900 ] 470 0.032% 100.176% ( 2900, 4400 ] 544 0.037% 100.213% ( 4400, 6600 ] 179 0.012% 100.225% ( 6600, 9900 ] 62 0.004% 100.229% ( 9900, 14000 ] 2 0.000% 100.229% ** Level 2 read latency histogram (micros): Count: 124170 Average: 5.5113 StdDev: 103.21 Min: 0 Median: 1.6095 Max: 8084 Percentiles: P50: 1.61 P75: 2.16 P99: 8.54 P99.9: 783.26 P99.99: 5716.60 ------------------------------------------------------ [ 0, 1 ] 18315 14.750% 14.750% ### ( 1, 2 ] 71810 57.832% 72.582% ############ ( 2, 3 ] 19048 15.340% 87.922% ### ( 3, 4 ] 6157 4.959% 92.881% # ( 4, 6 ] 6591 5.308% 98.189% # ( 6, 10 ] 1585 1.276% 99.465% ( 10, 15 ] 316 0.254% 99.720% ( 15, 22 ] 47 0.038% 99.758% ( 34, 51 ] 1 0.001% 99.758% ( 51, 76 ] 4 0.003% 99.762% ( 76, 110 ] 6 0.005% 99.766% ( 110, 170 ] 40 0.032% 99.799% ( 170, 250 ] 34 0.027% 99.826% ( 250, 380 ] 35 0.028% 99.854% ( 380, 580 ] 33 0.027% 99.881% ( 580, 870 ] 34 0.027% 99.908% ( 870, 1300 ] 29 0.023% 99.932% ( 1300, 1900 ] 13 0.010% 99.942% ( 1900, 2900 ] 27 0.022% 99.964% ( 2900, 4400 ] 26 0.021% 99.985% ( 4400, 6600 ] 11 0.009% 99.994% ( 6600, 9900 ] 8 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 867436 Average: 6.8150 StdDev: 112.28 Min: 0 Median: 2.2124 Max: 32494 Percentiles: P50: 2.21 P75: 3.09 P99: 9.25 P99.9: 14.68 P99.99: 178.58 ------------------------------------------------------ [ 0, 1 ] 8981 1.035% 1.035% ( 1, 2 ] 368381 42.468% 43.503% ######## ( 2, 3 ] 265284 30.583% 74.086% ###### ( 3, 4 ] 89337 10.299% 84.385% ## ( 4, 6 ] 110220 12.706% 97.091% ### ( 6, 10 ] 20357 2.347% 99.438% ( 10, 15 ] 4283 0.494% 99.932% ( 15, 22 ] 413 0.048% 99.979% ( 22, 34 ] 32 0.004% 99.983% ( 34, 51 ] 19 0.002% 99.985% ( 51, 76 ] 1 0.000% 99.985% ( 76, 110 ] 3 0.000% 99.986% ( 110, 170 ] 30 0.003% 99.989% ( 170, 250 ] 77 0.009% 99.998% ( 250, 380 ] 174 0.020% 100.018% ( 380, 580 ] 226 0.026% 100.044% ( 580, 870 ] 313 0.036% 100.080% ( 870, 1300 ] 328 0.038% 100.118% ( 1300, 1900 ] 189 0.022% 100.140% ( 1900, 2900 ] 241 0.028% 100.168% ( 2900, 4400 ] 251 0.029% 100.196% ( 4400, 6600 ] 72 0.008% 100.205% ( 6600, 9900 ] 38 0.004% 100.209% ( 22000, 33000 ] 1 0.000% 100.209% ** Level 4 read latency histogram (micros): Count: 105416 Average: 45.5515 StdDev: 321.75 Min: 1 Median: 2.1456 Max: 27633 Percentiles: P50: 2.15 P75: 3.14 P99: 1237.98 P99.9: 4181.02 P99.99: 5984.53 ------------------------------------------------------ [ 0, 1 ] 1168 1.108% 1.108% ( 1, 2 ] 47324 44.893% 46.001% ######### ( 2, 3 ] 28962 27.474% 73.475% ##### ( 3, 4 ] 11191 10.616% 84.091% ## ( 4, 6 ] 9262 8.786% 92.877% ## ( 6, 10 ] 2785 2.642% 95.519% # ( 10, 15 ] 506 0.480% 95.999% ( 15, 22 ] 80 0.076% 96.075% ( 22, 34 ] 22 0.021% 96.095% ( 34, 51 ] 9 0.009% 96.104% ( 51, 76 ] 14 0.013% 96.117% ( 76, 110 ] 50 0.047% 96.165% ( 110, 170 ] 259 0.246% 96.410% ( 170, 250 ] 368 0.349% 96.760% ( 250, 380 ] 439 0.416% 97.176% ( 380, 580 ] 625 0.593% 97.769% ( 580, 870 ] 751 0.712% 98.481% ( 870, 1300 ] 639 0.606% 99.087% ( 1300, 1900 ] 349 0.331% 99.418% ( 1900, 2900 ] 277 0.263% 99.681% ( 2900, 4400 ] 270 0.256% 99.937% ( 4400, 6600 ] 77 0.073% 100.010% ( 6600, 9900 ] 18 0.017% 100.028% ( 22000, 33000 ] 1 0.001% 100.028% ** Level 5 read latency histogram (micros): Count: 300 Average: 1544.8900 StdDev: 1629.46 Min: 86 Median: 747.8947 Max: 9145 Percentiles: P50: 747.89 P75: 2480.65 P99: 6408.70 P99.9: 8910.00 P99.99: 9145.00 ------------------------------------------------------ ( 76, 110 ] 8 2.667% 2.667% # ( 110, 170 ] 24 8.000% 10.667% ## ( 170, 250 ] 19 6.333% 17.000% # ( 250, 380 ] 31 10.333% 27.333% ## ( 380, 580 ] 46 15.333% 42.667% ### ( 580, 870 ] 38 12.667% 55.333% ### ( 870, 1300 ] 22 7.333% 62.667% # ( 1300, 1900 ] 19 6.333% 69.000% # ( 1900, 2900 ] 31 10.333% 79.333% ## ( 2900, 4400 ] 38 12.667% 92.000% ### ( 4400, 6600 ] 23 7.667% 99.667% ## ( 6600, 9900 ] 1 0.333% 100.000% ** DB Stats ** Uptime(secs): 53.3 total, 3.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 166.23 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:28.146 H:M:S, 52.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 312.17 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.474 H:M:S, 15.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/10/16-06:20:46 ... thread 0: (1000000,10000000) ops and (323759.3,178133.7) ops/second in (3.088714,56.137610) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/11 3.44 GB 163.6 7.3 0.0 7.3 16.7 9.5 0.0 1.8 122.8 283.0 60.52 52.91 161 0.376 7547K 8148 0.0 0.0 L1 8/8 678.90 MB 0.0 7.1 5.8 1.4 7.0 5.7 0.2 1.2 193.9 190.8 37.76 32.01 4 9.439 6949K 110K 0.0 0.0 L2 1/0 54.11 MB 0.5 0.4 0.2 0.2 0.4 0.2 5.1 2.0 248.2 248.0 1.52 1.47 2 0.761 383K 186 0.0 0.0 L3 16/0 887.33 MB 0.9 3.7 2.5 1.2 3.7 2.5 2.8 1.5 137.5 136.7 27.64 17.90 13 2.126 3729K 23K 0.0 0.0 L4 167/0 9.69 GB 1.0 4.8 4.4 0.4 4.8 4.4 0.7 1.1 129.7 129.4 37.70 23.48 48 0.785 4824K 4239 0.0 0.0 L5 1104/0 90.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1315/19 105.46 GB 0.0 23.3 12.8 10.4 32.6 22.1 13.8 3.4 144.3 202.0 165.13 127.77 228 0.724 23M 146K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.3 12.8 10.4 32.6 22.1 13.7 3.4 144.3 202.0 165.13 127.77 228 0.724 23M 146K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.3 12.8 10.4 23.1 12.7 0.0 0.0 178.0 176.8 133.86 103.12 93 1.439 23M 146K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 310.2 31.27 24.65 135 0.232 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 56.4 total, 56.1 interval Flush(GB): cumulative 9.474, interval 9.474 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: 32.58 GB write, 591.82 MB/s write, 23.26 GB read, 422.56 MB/s read, 165.1 seconds Interval compaction: 32.58 GB write, 594.30 MB/s write, 23.26 GB read, 424.32 MB/s read, 165.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 76, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 76, interval: 93 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3812910 Average: 3.1617 StdDev: 32.63 Min: 0 Median: 1.5134 Max: 7695 Percentiles: P50: 1.51 P75: 1.91 P99: 7.74 P99.9: 161.60 P99.99: 538.64 ------------------------------------------------------ [ 0, 1 ] 658865 17.280% 17.280% ### ( 1, 2 ] 2429891 63.728% 81.008% ############# ( 2, 3 ] 430179 11.282% 92.290% ## ( 3, 4 ] 128560 3.372% 95.662% # ( 4, 6 ] 115444 3.028% 98.689% # ( 6, 10 ] 27157 0.712% 99.402% ( 10, 15 ] 5075 0.133% 99.535% ( 15, 22 ] 867 0.023% 99.558% ( 22, 34 ] 50 0.001% 99.559% ( 34, 51 ] 11 0.000% 99.559% ( 51, 76 ] 29 0.001% 99.560% ( 76, 110 ] 5602 0.147% 99.707% ( 110, 170 ] 8568 0.225% 99.931% ( 170, 250 ] 923 0.024% 99.956% ( 250, 380 ] 741 0.019% 99.975% ( 380, 580 ] 717 0.019% 99.994% ( 580, 870 ] 438 0.011% 100.005% ( 870, 1300 ] 166 0.004% 100.010% ( 1300, 1900 ] 89 0.002% 100.012% ( 1900, 2900 ] 73 0.002% 100.014% ( 2900, 4400 ] 104 0.003% 100.017% ( 4400, 6600 ] 34 0.001% 100.018% ( 6600, 9900 ] 7 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 1503918 Average: 7.5011 StdDev: 116.10 Min: 0 Median: 1.9734 Max: 10060 Percentiles: P50: 1.97 P75: 2.91 P99: 9.65 P99.9: 148.53 P99.99: 366.76 ------------------------------------------------------ [ 0, 1 ] 62703 4.169% 4.169% # ( 1, 2 ] 708122 47.085% 51.254% ######### ( 2, 3 ] 392198 26.078% 77.333% ##### ( 3, 4 ] 132660 8.821% 86.154% ## ( 4, 6 ] 156994 10.439% 96.593% ## ( 6, 10 ] 39657 2.637% 99.230% # ( 10, 15 ] 7372 0.490% 99.720% ( 15, 22 ] 951 0.063% 99.783% ( 22, 34 ] 72 0.005% 99.788% ( 34, 51 ] 37 0.002% 99.790% ( 51, 76 ] 20 0.001% 99.792% ( 76, 110 ] 790 0.053% 99.844% ( 110, 170 ] 1305 0.087% 99.931% ( 170, 250 ] 398 0.026% 99.958% ( 250, 380 ] 544 0.036% 99.994% ( 380, 580 ] 683 0.045% 100.039% ( 580, 870 ] 669 0.044% 100.084% ( 870, 1300 ] 569 0.038% 100.121% ( 1300, 1900 ] 329 0.022% 100.143% ( 1900, 2900 ] 470 0.031% 100.175% ( 2900, 4400 ] 544 0.036% 100.211% ( 4400, 6600 ] 179 0.012% 100.223% ( 6600, 9900 ] 62 0.004% 100.227% ( 9900, 14000 ] 2 0.000% 100.227% ** Level 2 read latency histogram (micros): Count: 124170 Average: 5.5113 StdDev: 103.21 Min: 0 Median: 1.6095 Max: 8084 Percentiles: P50: 1.61 P75: 2.16 P99: 8.54 P99.9: 783.26 P99.99: 5716.60 ------------------------------------------------------ [ 0, 1 ] 18315 14.750% 14.750% ### ( 1, 2 ] 71810 57.832% 72.582% ############ ( 2, 3 ] 19048 15.340% 87.922% ### ( 3, 4 ] 6157 4.959% 92.881% # ( 4, 6 ] 6591 5.308% 98.189% # ( 6, 10 ] 1585 1.276% 99.465% ( 10, 15 ] 316 0.254% 99.720% ( 15, 22 ] 47 0.038% 99.758% ( 34, 51 ] 1 0.001% 99.758% ( 51, 76 ] 4 0.003% 99.762% ( 76, 110 ] 6 0.005% 99.766% ( 110, 170 ] 40 0.032% 99.799% ( 170, 250 ] 34 0.027% 99.826% ( 250, 380 ] 35 0.028% 99.854% ( 380, 580 ] 33 0.027% 99.881% ( 580, 870 ] 34 0.027% 99.908% ( 870, 1300 ] 29 0.023% 99.932% ( 1300, 1900 ] 13 0.010% 99.942% ( 1900, 2900 ] 27 0.022% 99.964% ( 2900, 4400 ] 26 0.021% 99.985% ( 4400, 6600 ] 11 0.009% 99.994% ( 6600, 9900 ] 8 0.006% 100.000% ** Level 3 read latency histogram (micros): Count: 867436 Average: 6.8150 StdDev: 112.28 Min: 0 Median: 2.2124 Max: 32494 Percentiles: P50: 2.21 P75: 3.09 P99: 9.25 P99.9: 14.68 P99.99: 178.58 ------------------------------------------------------ [ 0, 1 ] 8981 1.035% 1.035% ( 1, 2 ] 368381 42.468% 43.503% ######## ( 2, 3 ] 265284 30.583% 74.086% ###### ( 3, 4 ] 89337 10.299% 84.385% ## ( 4, 6 ] 110220 12.706% 97.091% ### ( 6, 10 ] 20357 2.347% 99.438% ( 10, 15 ] 4283 0.494% 99.932% ( 15, 22 ] 413 0.048% 99.979% ( 22, 34 ] 32 0.004% 99.983% ( 34, 51 ] 19 0.002% 99.985% ( 51, 76 ] 1 0.000% 99.985% ( 76, 110 ] 3 0.000% 99.986% ( 110, 170 ] 30 0.003% 99.989% ( 170, 250 ] 77 0.009% 99.998% ( 250, 380 ] 174 0.020% 100.018% ( 380, 580 ] 226 0.026% 100.044% ( 580, 870 ] 313 0.036% 100.080% ( 870, 1300 ] 328 0.038% 100.118% ( 1300, 1900 ] 189 0.022% 100.140% ( 1900, 2900 ] 241 0.028% 100.168% ( 2900, 4400 ] 251 0.029% 100.196% ( 4400, 6600 ] 72 0.008% 100.205% ( 6600, 9900 ] 38 0.004% 100.209% ( 22000, 33000 ] 1 0.000% 100.209% ** Level 4 read latency histogram (micros): Count: 105416 Average: 45.5515 StdDev: 321.75 Min: 1 Median: 2.1456 Max: 27633 Percentiles: P50: 2.15 P75: 3.14 P99: 1237.98 P99.9: 4181.02 P99.99: 5984.53 ------------------------------------------------------ [ 0, 1 ] 1168 1.108% 1.108% ( 1, 2 ] 47324 44.893% 46.001% ######### ( 2, 3 ] 28962 27.474% 73.475% ##### ( 3, 4 ] 11191 10.616% 84.091% ## ( 4, 6 ] 9262 8.786% 92.877% ## ( 6, 10 ] 2785 2.642% 95.519% # ( 10, 15 ] 506 0.480% 95.999% ( 15, 22 ] 80 0.076% 96.075% ( 22, 34 ] 22 0.021% 96.095% ( 34, 51 ] 9 0.009% 96.104% ( 51, 76 ] 14 0.013% 96.117% ( 76, 110 ] 50 0.047% 96.165% ( 110, 170 ] 259 0.246% 96.410% ( 170, 250 ] 368 0.349% 96.760% ( 250, 380 ] 439 0.416% 97.176% ( 380, 580 ] 625 0.593% 97.769% ( 580, 870 ] 751 0.712% 98.481% ( 870, 1300 ] 639 0.606% 99.087% ( 1300, 1900 ] 349 0.331% 99.418% ( 1900, 2900 ] 277 0.263% 99.681% ( 2900, 4400 ] 270 0.256% 99.937% ( 4400, 6600 ] 77 0.073% 100.010% ( 6600, 9900 ] 18 0.017% 100.028% ( 22000, 33000 ] 1 0.001% 100.028% ** Level 5 read latency histogram (micros): Count: 300 Average: 1544.8900 StdDev: 1629.46 Min: 86 Median: 747.8947 Max: 9145 Percentiles: P50: 747.89 P75: 2480.65 P99: 6408.70 P99.9: 8910.00 P99.99: 9145.00 ------------------------------------------------------ ( 76, 110 ] 8 2.667% 2.667% # ( 110, 170 ] 24 8.000% 10.667% ## ( 170, 250 ] 19 6.333% 17.000% # ( 250, 380 ] 31 10.333% 27.333% ## ( 380, 580 ] 46 15.333% 42.667% ### ( 580, 870 ] 38 12.667% 55.333% ### ( 870, 1300 ] 22 7.333% 62.667% # ( 1300, 1900 ] 19 6.333% 69.000% # ( 1900, 2900 ] 31 10.333% 79.333% ## ( 2900, 4400 ] 38 12.667% 92.000% ### ( 4400, 6600 ] 23 7.667% 99.667% ## ( 6600, 9900 ] 1 0.333% 100.000% ** DB Stats ** Uptime(secs): 56.4 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 174.58 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:28.582 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, 318.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:0.436 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.562 micros/op 179797 ops/sec 60.001 seconds 10787999 operations; 174.2 MB/s Microseconds per write: Count: 10787999 Average: 5.5618 StdDev: 531.72 Min: 1 Median: 1.7414 Max: 893203 Percentiles: P50: 1.74 P75: 2.76 P99: 8.63 P99.9: 1097.52 P99.99: 2740.27 ------------------------------------------------------ [ 0, 1 ] 1363259 12.637% 12.637% ### ( 1, 2 ] 5436813 50.397% 63.034% ########## ( 2, 3 ] 1699926 15.758% 78.791% ### ( 3, 4 ] 1516879 14.061% 92.852% ### ( 4, 6 ] 592759 5.495% 98.347% # ( 6, 10 ] 107326 0.995% 99.342% ( 10, 15 ] 34064 0.316% 99.657% ( 15, 22 ] 8444 0.078% 99.736% ( 22, 34 ] 1606 0.015% 99.750% ( 34, 51 ] 191 0.002% 99.752% ( 51, 76 ] 23 0.000% 99.752% ( 76, 110 ] 7492 0.069% 99.822% ( 110, 170 ] 2984 0.028% 99.850% ( 170, 250 ] 290 0.003% 99.852% ( 250, 380 ] 137 0.001% 99.853% ( 380, 580 ] 22 0.000% 99.854% ( 580, 870 ] 25 0.000% 99.854% ( 870, 1300 ] 9395 0.087% 99.941% ( 1300, 1900 ] 15 0.000% 99.941% ( 1900, 2900 ] 6272 0.058% 99.999% ( 2900, 4400 ] 37 0.000% 100.000% ( 4400, 6600 ] 7 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 180241 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 : 10787999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11133214968 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 : 548 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30337769 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 : 28438639854 rocksdb.compact.write.bytes COUNT : 28261716225 rocksdb.flush.write.bytes COUNT : 11031499862 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 70 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 278 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 : 10942676992 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4366336 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 : 28543621311 rocksdb.non.last.level.read.count COUNT : 6891588 rocksdb.block.checksum.compute.count COUNT : 6890562 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.378319 P95 : 3.880115 P99 : 6.780213 P100 : 893194.000000 COUNT : 10787999 SUM : 54826800 rocksdb.compaction.times.micros P50 : 1025526.315789 P95 : 3652500.000000 P99 : 22330000.000000 P100 : 23170284.000000 COUNT : 97 SUM : 138183544 rocksdb.compaction.times.cpu_micros P50 : 808214.285714 P95 : 2437500.000000 P99 : 14240000.000000 P100 : 20403212.000000 COUNT : 97 SUM : 107377283 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 : 708.269231 P95 : 8415.000000 P99 : 69125.000000 P100 : 146913.000000 COUNT : 147 SUM : 443871 rocksdb.compaction.outfile.sync.micros P50 : 1161.785714 P95 : 127700.000000 P99 : 168740.000000 P100 : 195302.000000 COUNT : 342 SUM : 5749238 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 : 134.000000 P95 : 2520.000000 P99 : 4257.500000 P100 : 6159.000000 COUNT : 276 SUM : 124412 rocksdb.table.open.io.micros P50 : 1764.788732 P95 : 10105.000000 P99 : 19610.666667 P100 : 22097.000000 COUNT : 548 SUM : 1600552 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.741725 P95 : 8.318686 P99 : 12.798665 P100 : 32498.000000 COUNT : 6889082 SUM : 50452968 rocksdb.read.block.get.micros P50 : 561.981982 P95 : 4783.829787 P99 : 7639.500000 P100 : 9282.000000 COUNT : 1096 SUM : 1303245 rocksdb.write.raw.block.micros P50 : 0.515226 P95 : 0.978929 P99 : 2.897639 P100 : 39529.000000 COUNT : 9520461 SUM : 21620794 rocksdb.numfiles.in.singlecompaction P50 : 3.102740 P95 : 3.971918 P99 : 14.316667 P100 : 22.000000 COUNT : 141 SUM : 487 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.567718 P95 : 1285.807070 P99 : 2694.305822 P100 : 892986.000000 COUNT : 132000 SUM : 30351023 rocksdb.sst.read.micros P50 : 1.671173 P95 : 5.052383 P99 : 9.285657 P100 : 32494.000000 COUNT : 6891952 SUM : 36492330 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 : 10787999 SUM : 11133214968 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 : 212040.816327 P95 : 518700.000000 P99 : 832740.000000 P100 : 1065885.000000 COUNT : 147 SUM : 33664864 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 : 332 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