[2024-07-26 15:22:52.011253] Starting SPDK v24.05.1-pre git sha1 241d0f3c9 / DPDK 23.11.0 initialization... [2024-07-26 15:22:52.011389] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid19530 ] Set seed to 1722000172007888 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-26 15:22:52.111271] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-26 15:22:52.150616] app.c: 604:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-26 15:22:52.150661] app.c: 605:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 19530' to capture a snapshot of events at runtime. [2024-07-26 15:22:52.150671] app.c: 610:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-26 15:22:52.150681] app.c: 611:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-26 15:22:52.150688] app.c: 612:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid19530 for offline analysis/debug. [2024-07-26 15:22:52.150771] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 26 15:22:56 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/26-15:22:59 ... thread 0: (1000000,1000000) ops and (340724.6,340724.6) ops/second in (2.934922,2.934922) 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 629.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 355.4 2.48 2.24 12 0.207 0 0 0.0 0.0 L2 3/2 251.72 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 11/0 930.12 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 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 1183/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 95.1 316.9 3.97 3.69 14 0.284 383K 219 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.4 95.1 316.9 3.97 3.69 14 0.284 383K 219 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 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 355.4 2.48 2.24 12 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 2.9 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 397.18 MB/s write, 0.37 GB read, 119.17 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 428.94 MB/s write, 0.37 GB read, 128.69 MB/s read, 4.0 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: 113172 Average: 1.8800 StdDev: 16.69 Min: 1 Median: 1.2277 Max: 3372 Percentiles: P50: 1.23 P75: 1.67 P99: 3.94 P99.9: 8.67 P99.99: 293.75 ------------------------------------------------------ [ 0, 1 ] 42136 37.232% 37.232% ####### ( 1, 2 ] 63456 56.070% 93.302% ########### ( 2, 3 ] 5126 4.529% 97.832% # ( 3, 4 ] 1409 1.245% 99.077% ( 4, 6 ] 807 0.713% 99.790% ( 6, 10 ] 187 0.165% 99.955% ( 10, 15 ] 21 0.019% 99.973% ( 15, 22 ] 2 0.002% 99.975% ( 34, 51 ] 1 0.001% 99.976% ( 51, 76 ] 3 0.003% 99.979% ( 110, 170 ] 7 0.006% 99.985% ( 170, 250 ] 4 0.004% 99.989% ( 250, 380 ] 5 0.004% 99.993% ( 380, 580 ] 1 0.001% 99.994% ( 580, 870 ] 3 0.003% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 62549 Average: 2.0704 StdDev: 22.24 Min: 0 Median: 1.2897 Max: 4299 Percentiles: P50: 1.29 P75: 1.72 P99: 5.16 P99.9: 10.63 P99.99: 688.02 ------------------------------------------------------ [ 0, 1 ] 20668 33.043% 33.043% ####### ( 1, 2 ] 36613 58.535% 91.578% ############ ( 2, 3 ] 3070 4.908% 96.486% # ( 3, 4 ] 1160 1.855% 98.341% ( 4, 6 ] 711 1.137% 99.477% ( 6, 10 ] 260 0.416% 99.893% ( 10, 15 ] 43 0.069% 99.962% ( 15, 22 ] 4 0.006% 99.968% ( 22, 34 ] 3 0.005% 99.973% ( 34, 51 ] 2 0.003% 99.976% ( 170, 250 ] 2 0.003% 99.979% ( 250, 380 ] 4 0.006% 99.986% ( 380, 580 ] 3 0.005% 99.990% ( 580, 870 ] 2 0.003% 99.994% ( 1300, 1900 ] 3 0.005% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ( 2900, 4400 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 45 Average: 1385.6889 StdDev: 1042.54 Min: 59 Median: 1146.4286 Max: 4605 Percentiles: P50: 1146.43 P75: 1983.33 P99: 4605.00 P99.9: 4605.00 P99.99: 4605.00 ------------------------------------------------------ ( 51, 76 ] 2 4.444% 4.444% # ( 76, 110 ] 1 2.222% 6.667% ( 250, 380 ] 3 6.667% 13.333% # ( 380, 580 ] 7 15.556% 28.889% ### ( 580, 870 ] 5 11.111% 40.000% ## ( 870, 1300 ] 7 15.556% 55.556% ### ( 1300, 1900 ] 8 17.778% 73.333% #### ( 1900, 2900 ] 9 20.000% 93.333% #### ( 2900, 4400 ] 2 4.444% 97.778% # ( 4400, 6600 ] 1 2.222% 100.000% ** Level 4 read latency histogram (micros): Count: 25 Average: 1502.5600 StdDev: 1065.99 Min: 211 Median: 1146.4286 Max: 4159 Percentiles: P50: 1146.43 P75: 1862.50 P99: 4159.00 P99.9: 4159.00 P99.99: 4159.00 ------------------------------------------------------ ( 170, 250 ] 3 12.000% 12.000% ## ( 380, 580 ] 1 4.000% 16.000% # ( 580, 870 ] 4 16.000% 32.000% ### ( 870, 1300 ] 7 28.000% 60.000% ###### ( 1300, 1900 ] 4 16.000% 76.000% ### ( 1900, 2900 ] 2 8.000% 84.000% ## ( 2900, 4400 ] 4 16.000% 100.000% ### ** DB Stats ** Uptime(secs): 3.2 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 310.32 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.416 H:M:S, 13.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.06 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.416 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-15:23:02 ... thread 0: (1000000,2000000) ops and (352169.1,346352.3) ops/second in (2.839545,5.774467) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/7 1.17 GB 6.3 0.8 0.0 0.8 2.6 1.8 0.0 1.4 99.6 321.7 8.22 7.60 29 0.284 831K 881 0.0 0.0 L1 1/1 3.54 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 241.6 241.2 1.56 1.52 1 1.564 383K 644 0.0 0.0 L2 2/1 54.20 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 21/11 1.25 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 230.4 230.4 1.08 1.02 1 1.082 253K 0 0.0 0.0 L4 174/0 9.69 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 156.4 156.4 1.44 1.05 1 1.436 228K 0 0.0 0.0 L5 1044/0 85.75 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 1250/20 97.92 GB 0.0 2.0 1.0 1.0 3.8 2.8 1.1 2.1 148.5 280.8 13.80 12.64 34 0.406 2080K 1744 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 1.0 1.0 3.8 2.8 1.0 2.1 148.5 280.8 13.80 12.64 34 0.406 2080K 1744 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.0 1.0 1.0 2.0 1.0 0.0 0.0 235.4 235.2 8.70 8.12 8 1.088 2080K 1744 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 358.7 5.09 4.53 26 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.78 GB write, 644.48 MB/s write, 2.00 GB read, 340.84 MB/s read, 13.8 seconds Interval compaction: 3.78 GB write, 670.68 MB/s write, 2.00 GB read, 354.70 MB/s read, 13.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 382739 Average: 2.2251 StdDev: 12.40 Min: 1 Median: 1.4991 Max: 3372 Percentiles: P50: 1.50 P75: 1.90 P99: 5.66 P99.9: 9.96 P99.99: 14.98 ------------------------------------------------------ [ 0, 1 ] 71005 18.552% 18.552% #### ( 1, 2 ] 241140 63.004% 81.556% ############# ( 2, 3 ] 43180 11.282% 92.837% ## ( 3, 4 ] 14868 3.885% 96.722% # ( 4, 6 ] 10482 2.739% 99.461% # ( 6, 10 ] 1699 0.444% 99.905% ( 10, 15 ] 329 0.086% 99.991% ( 15, 22 ] 27 0.007% 99.998% ( 22, 34 ] 3 0.001% 99.998% ( 34, 51 ] 2 0.001% 99.999% ( 51, 76 ] 5 0.001% 100.000% ( 110, 170 ] 12 0.003% 100.003% ( 170, 250 ] 13 0.003% 100.007% ( 250, 380 ] 10 0.003% 100.009% ( 380, 580 ] 4 0.001% 100.010% ( 580, 870 ] 8 0.002% 100.013% ( 870, 1300 ] 2 0.001% 100.013% ( 1300, 1900 ] 3 0.001% 100.014% ( 1900, 2900 ] 4 0.001% 100.015% ( 2900, 4400 ] 2 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 26 Average: 183.8846 StdDev: 350.45 Min: 1 Median: 1.9000 Max: 1380 Percentiles: P50: 1.90 P75: 210.00 P99: 1380.00 P99.9: 1380.00 P99.99: 1380.00 ------------------------------------------------------ [ 0, 1 ] 4 15.385% 15.385% ### ( 1, 2 ] 10 38.462% 53.846% ######## ( 2, 3 ] 3 11.538% 65.385% ## ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 250, 380 ] 2 7.692% 84.615% ## ( 580, 870 ] 2 7.692% 92.308% ## ( 870, 1300 ] 1 3.846% 96.154% # ( 1300, 1900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95609 Average: 2.1588 StdDev: 18.00 Min: 0 Median: 1.4103 Max: 4299 Percentiles: P50: 1.41 P75: 1.82 P99: 5.59 P99.9: 11.67 P99.99: 409.27 ------------------------------------------------------ [ 0, 1 ] 23644 24.730% 24.730% ##### ( 1, 2 ] 58891 61.596% 86.326% ############ ( 2, 3 ] 7706 8.060% 94.385% ## ( 3, 4 ] 2832 2.962% 97.348% # ( 4, 6 ] 1983 2.074% 99.422% ( 6, 10 ] 425 0.445% 99.866% ( 10, 15 ] 97 0.101% 99.968% ( 15, 22 ] 8 0.008% 99.976% ( 22, 34 ] 4 0.004% 99.980% ( 34, 51 ] 2 0.002% 99.982% ( 76, 110 ] 1 0.001% 99.983% ( 170, 250 ] 2 0.002% 99.985% ( 250, 380 ] 4 0.004% 99.990% ( 380, 580 ] 3 0.003% 99.993% ( 580, 870 ] 2 0.002% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 179540 Average: 3.3174 StdDev: 31.19 Min: 1 Median: 1.6566 Max: 4605 Percentiles: P50: 1.66 P75: 2.22 P99: 8.93 P99.9: 151.62 P99.99: 439.09 ------------------------------------------------------ [ 0, 1 ] 16618 9.256% 9.256% ## ( 1, 2 ] 111414 62.055% 71.311% ############ ( 2, 3 ] 29928 16.669% 87.980% ### ( 3, 4 ] 9805 5.461% 93.442% # ( 4, 6 ] 7942 4.424% 97.865% # ( 6, 10 ] 2783 1.550% 99.415% ( 10, 15 ] 517 0.288% 99.703% ( 15, 22 ] 99 0.055% 99.758% ( 22, 34 ] 23 0.013% 99.771% ( 34, 51 ] 9 0.005% 99.776% ( 51, 76 ] 4 0.002% 99.778% ( 76, 110 ] 105 0.058% 99.837% ( 110, 170 ] 165 0.092% 99.929% ( 170, 250 ] 63 0.035% 99.964% ( 250, 380 ] 38 0.021% 99.985% ( 380, 580 ] 34 0.019% 100.004% ( 580, 870 ] 23 0.013% 100.017% ( 870, 1300 ] 10 0.006% 100.022% ( 1300, 1900 ] 13 0.007% 100.030% ( 1900, 2900 ] 9 0.005% 100.035% ( 2900, 4400 ] 2 0.001% 100.036% ( 4400, 6600 ] 1 0.001% 100.036% ** Level 4 read latency histogram (micros): Count: 315 Average: 122.1937 StdDev: 504.44 Min: 0 Median: 1.4598 Max: 4159 Percentiles: P50: 1.46 P75: 6.02 P99: 3218.75 P99.9: 4159.00 P99.99: 4159.00 ------------------------------------------------------ [ 0, 1 ] 106 33.651% 33.651% ####### ( 1, 2 ] 112 35.556% 69.206% ####### ( 2, 3 ] 12 3.810% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 4 1.270% 74.921% ( 6, 10 ] 43 13.651% 88.571% ### ( 10, 15 ] 11 3.492% 92.063% # ( 170, 250 ] 3 0.952% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 4 1.270% 100.000% ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 327.46 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.616 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 346.60 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.199 H:M:S, 7.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-15:23:05 ... thread 0: (1000000,3000000) ops and (329540.9,340561.1) ops/second in (3.034525,8.808992) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 2.15 GB 75.5 1.3 0.0 1.3 4.1 2.8 0.0 1.5 102.1 320.6 12.96 11.99 45 0.288 1343K 1382 0.0 0.0 L1 1/1 3.54 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 241.6 241.2 1.56 1.52 1 1.564 383K 644 0.0 0.0 L2 1/0 51.74 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 17/0 761.70 MB 0.8 1.2 0.2 0.9 1.2 0.2 0.4 4.7 243.4 242.9 4.86 4.50 2 2.428 1200K 2498 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 156.4 156.4 1.44 1.05 1 1.436 228K 0 0.0 0.0 L5 1052/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1261/12 98.90 GB 0.0 3.4 1.0 2.4 6.2 3.8 2.2 2.2 156.2 283.0 22.31 20.51 51 0.438 3539K 4743 0.0 0.0 Int 0/0 0.00 KB 0.0 3.4 1.0 2.4 6.2 3.8 2.1 2.2 156.2 283.0 22.31 20.51 51 0.438 3539K 4743 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.4 1.0 2.4 3.4 1.0 0.0 0.0 241.8 241.5 14.41 13.49 11 1.310 3539K 4743 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 358.8 7.90 7.02 40 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): 9.0 total, 8.8 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.17 GB write, 698.20 MB/s write, 3.40 GB read, 385.32 MB/s read, 22.3 seconds Interval compaction: 6.17 GB write, 716.80 MB/s write, 3.40 GB read, 395.59 MB/s read, 22.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 722507 Average: 2.2417 StdDev: 10.25 Min: 1 Median: 1.5269 Max: 3372 Percentiles: P50: 1.53 P75: 1.91 P99: 5.62 P99.9: 9.88 P99.99: 14.77 ------------------------------------------------------ [ 0, 1 ] 112501 15.571% 15.571% ### ( 1, 2 ] 472070 65.338% 80.909% ############# ( 2, 3 ] 87150 12.062% 92.971% ## ( 3, 4 ] 28235 3.908% 96.879% # ( 4, 6 ] 18950 2.623% 99.502% # ( 6, 10 ] 2970 0.411% 99.913% ( 10, 15 ] 586 0.081% 99.994% ( 15, 22 ] 39 0.005% 99.999% ( 22, 34 ] 6 0.001% 100.000% ( 34, 51 ] 3 0.000% 100.000% ( 51, 76 ] 5 0.001% 100.001% ( 76, 110 ] 26 0.004% 100.005% ( 110, 170 ] 24 0.003% 100.008% ( 170, 250 ] 29 0.004% 100.012% ( 250, 380 ] 18 0.002% 100.015% ( 380, 580 ] 9 0.001% 100.016% ( 580, 870 ] 14 0.002% 100.018% ( 870, 1300 ] 4 0.001% 100.018% ( 1300, 1900 ] 4 0.001% 100.019% ( 1900, 2900 ] 5 0.001% 100.020% ( 2900, 4400 ] 2 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 26 Average: 183.8846 StdDev: 350.45 Min: 1 Median: 1.9000 Max: 1380 Percentiles: P50: 1.90 P75: 210.00 P99: 1380.00 P99.9: 1380.00 P99.99: 1380.00 ------------------------------------------------------ [ 0, 1 ] 4 15.385% 15.385% ### ( 1, 2 ] 10 38.462% 53.846% ######## ( 2, 3 ] 3 11.538% 65.385% ## ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 250, 380 ] 2 7.692% 84.615% ## ( 580, 870 ] 2 7.692% 92.308% ## ( 870, 1300 ] 1 3.846% 96.154% # ( 1300, 1900 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 265007 Average: 3.1963 StdDev: 27.26 Min: 1 Median: 1.6260 Max: 4605 Percentiles: P50: 1.63 P75: 2.09 P99: 8.83 P99.9: 162.24 P99.99: 527.91 ------------------------------------------------------ [ 0, 1 ] 27464 10.363% 10.363% ## ( 1, 2 ] 167788 63.315% 73.678% ############# ( 2, 3 ] 40068 15.120% 88.798% ### ( 3, 4 ] 13485 5.089% 93.886% # ( 4, 6 ] 10513 3.967% 97.853% # ( 6, 10 ] 4295 1.621% 99.474% ( 10, 15 ] 612 0.231% 99.705% ( 15, 22 ] 103 0.039% 99.744% ( 22, 34 ] 24 0.009% 99.753% ( 34, 51 ] 10 0.004% 99.757% ( 51, 76 ] 4 0.002% 99.758% ( 76, 110 ] 147 0.055% 99.814% ( 110, 170 ] 263 0.099% 99.913% ( 170, 250 ] 104 0.039% 99.952% ( 250, 380 ] 65 0.025% 99.977% ( 380, 580 ] 48 0.018% 99.995% ( 580, 870 ] 39 0.015% 100.009% ( 870, 1300 ] 13 0.005% 100.014% ( 1300, 1900 ] 14 0.005% 100.020% ( 1900, 2900 ] 9 0.003% 100.023% ( 2900, 4400 ] 2 0.001% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 4 read latency histogram (micros): Count: 315 Average: 122.1937 StdDev: 504.44 Min: 0 Median: 1.4598 Max: 4159 Percentiles: P50: 1.46 P75: 6.02 P99: 3218.75 P99.9: 4159.00 P99.99: 4159.00 ------------------------------------------------------ [ 0, 1 ] 106 33.651% 33.651% ####### ( 1, 2 ] 112 35.556% 69.206% ####### ( 2, 3 ] 12 3.810% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 4 1.270% 74.921% ( 6, 10 ] 43 13.651% 88.571% ### ( 10, 15 ] 11 3.492% 92.063% # ( 170, 250 ] 3 0.952% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 4 1.270% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 774.3500 StdDev: 941.36 Min: 81 Median: 302.0000 Max: 2854 Percentiles: P50: 302.00 P75: 1013.33 P99: 2850.00 P99.9: 2854.00 P99.99: 2854.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 8 20.000% 32.500% #### ( 170, 250 ] 5 12.500% 45.000% ### ( 250, 380 ] 5 12.500% 57.500% ### ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 1 2.500% 72.500% # ( 870, 1300 ] 3 7.500% 80.000% ## ( 1900, 2900 ] 8 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 326.41 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.030 H:M:S, 11.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.33 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.414 H:M:S, 13.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-15:23:08 ... thread 0: (1000000,4000000) ops and (325691.9,336718.0) ops/second in (3.070386,11.879378) 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/9 1.97 GB 31.5 2.2 0.0 2.2 5.8 3.7 0.0 1.6 116.4 315.9 18.94 17.58 61 0.310 2238K 2411 0.0 0.0 L1 6/6 615.91 MB 0.0 1.5 1.5 0.0 1.5 1.5 0.2 1.0 236.0 235.0 6.42 6.21 2 3.209 1537K 6023 0.0 0.0 L2 3/2 386.32 MB 1.3 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 19/1 941.63 MB 0.8 1.4 0.4 1.0 1.4 0.4 0.4 3.4 226.9 226.5 6.40 5.78 4 1.599 1474K 3067 0.0 0.0 L4 174/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 156.4 156.4 1.44 1.05 1 1.436 228K 0 0.0 0.0 L5 1052/0 86.37 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1267/18 99.82 GB 0.0 5.6 2.3 3.3 9.3 6.0 2.7 2.5 166.5 275.1 34.68 32.07 70 0.495 5862K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.3 3.3 9.3 6.0 2.6 2.5 166.5 275.1 34.68 32.07 70 0.495 5862K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 2.3 3.3 5.6 2.3 0.0 0.0 239.3 238.8 24.13 22.71 17 1.419 5862K 11K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 358.1 10.55 9.36 53 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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: 9.32 GB write, 787.52 MB/s write, 5.64 GB read, 476.53 MB/s read, 34.7 seconds Interval compaction: 9.32 GB write, 803.08 MB/s write, 5.64 GB read, 485.95 MB/s read, 34.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 14, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1049106 Average: 2.3067 StdDev: 10.99 Min: 1 Median: 1.5388 Max: 3890 Percentiles: P50: 1.54 P75: 1.92 P99: 5.71 P99.9: 10.40 P99.99: 91.25 ------------------------------------------------------ [ 0, 1 ] 152010 14.489% 14.489% ### ( 1, 2 ] 691445 65.908% 80.398% ############# ( 2, 3 ] 129357 12.330% 92.728% ## ( 3, 4 ] 41880 3.992% 96.720% # ( 4, 6 ] 28047 2.673% 99.393% # ( 6, 10 ] 5247 0.500% 99.893% ( 10, 15 ] 901 0.086% 99.979% ( 15, 22 ] 60 0.006% 99.985% ( 22, 34 ] 9 0.001% 99.986% ( 34, 51 ] 5 0.000% 99.986% ( 51, 76 ] 7 0.001% 99.987% ( 76, 110 ] 76 0.007% 99.994% ( 110, 170 ] 82 0.008% 100.002% ( 170, 250 ] 79 0.008% 100.009% ( 250, 380 ] 48 0.005% 100.014% ( 380, 580 ] 41 0.004% 100.018% ( 580, 870 ] 29 0.003% 100.021% ( 870, 1300 ] 8 0.001% 100.021% ( 1300, 1900 ] 7 0.001% 100.022% ( 1900, 2900 ] 6 0.001% 100.023% ( 2900, 4400 ] 3 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 143419 Average: 3.4017 StdDev: 22.82 Min: 1 Median: 1.7059 Max: 3080 Percentiles: P50: 1.71 P75: 2.37 P99: 8.93 P99.9: 147.59 P99.99: 292.51 ------------------------------------------------------ [ 0, 1 ] 9419 6.567% 6.567% # ( 1, 2 ] 88238 61.525% 68.092% ############ ( 2, 3 ] 26756 18.656% 86.748% #### ( 3, 4 ] 8660 6.038% 92.786% # ( 4, 6 ] 7131 4.972% 97.758% # ( 6, 10 ] 2436 1.699% 99.457% ( 10, 15 ] 430 0.300% 99.757% ( 15, 22 ] 59 0.041% 99.798% ( 22, 34 ] 7 0.005% 99.803% ( 34, 51 ] 1 0.001% 99.803% ( 76, 110 ] 55 0.038% 99.842% ( 110, 170 ] 135 0.094% 99.936% ( 170, 250 ] 61 0.043% 99.978% ( 250, 380 ] 54 0.038% 100.016% ( 380, 580 ] 50 0.035% 100.051% ( 580, 870 ] 31 0.022% 100.073% ( 870, 1300 ] 12 0.008% 100.081% ( 1300, 1900 ] 4 0.003% 100.084% ( 1900, 2900 ] 1 0.001% 100.084% ( 2900, 4400 ] 1 0.001% 100.085% ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271322 Average: 3.6834 StdDev: 31.03 Min: 1 Median: 1.6323 Max: 4605 Percentiles: P50: 1.63 P75: 2.12 P99: 9.29 P99.9: 298.58 P99.99: 708.36 ------------------------------------------------------ [ 0, 1 ] 27681 10.202% 10.202% ## ( 1, 2 ] 170774 62.941% 73.144% ############# ( 2, 3 ] 41666 15.357% 88.500% ### ( 3, 4 ] 13980 5.153% 93.653% # ( 4, 6 ] 10861 4.003% 97.656% # ( 6, 10 ] 4428 1.632% 99.288% ( 10, 15 ] 675 0.249% 99.537% ( 15, 22 ] 113 0.042% 99.578% ( 22, 34 ] 29 0.011% 99.589% ( 34, 51 ] 10 0.004% 99.593% ( 51, 76 ] 4 0.001% 99.594% ( 76, 110 ] 214 0.079% 99.673% ( 110, 170 ] 369 0.136% 99.809% ( 170, 250 ] 191 0.070% 99.879% ( 250, 380 ] 149 0.055% 99.934% ( 380, 580 ] 119 0.044% 99.978% ( 580, 870 ] 72 0.027% 100.005% ( 870, 1300 ] 23 0.008% 100.013% ( 1300, 1900 ] 15 0.006% 100.019% ( 1900, 2900 ] 10 0.004% 100.022% ( 2900, 4400 ] 2 0.001% 100.023% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 4 read latency histogram (micros): Count: 315 Average: 122.1937 StdDev: 504.44 Min: 0 Median: 1.4598 Max: 4159 Percentiles: P50: 1.46 P75: 6.02 P99: 3218.75 P99.9: 4159.00 P99.99: 4159.00 ------------------------------------------------------ [ 0, 1 ] 106 33.651% 33.651% ####### ( 1, 2 ] 112 35.556% 69.206% ####### ( 2, 3 ] 12 3.810% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 4 1.270% 74.921% ( 6, 10 ] 43 13.651% 88.571% ### ( 10, 15 ] 11 3.492% 92.063% # ( 170, 250 ] 3 0.952% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 4 1.270% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 774.3500 StdDev: 941.36 Min: 81 Median: 302.0000 Max: 2854 Percentiles: P50: 302.00 P75: 1013.33 P99: 2850.00 P99.9: 2854.00 P99.99: 2854.00 ------------------------------------------------------ ( 76, 110 ] 5 12.500% 12.500% ### ( 110, 170 ] 8 20.000% 32.500% #### ( 170, 250 ] 5 12.500% 45.000% ### ( 250, 380 ] 5 12.500% 57.500% ### ( 380, 580 ] 5 12.500% 70.000% ### ( 580, 870 ] 1 2.500% 72.500% # ( 870, 1300 ] 3 7.500% 80.000% ## ( 1900, 2900 ] 8 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 12.1 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 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:1.504 H:M:S, 12.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.54 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.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-15:23:11 ... thread 0: (1000000,5000000) ops and (315585.2,332268.0) ops/second in (3.168716,15.048094) 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/13 2.95 GB 107.0 3.0 0.0 3.0 7.6 4.7 0.0 1.6 121.6 314.1 24.86 23.15 79 0.315 3070K 3240 0.0 0.0 L1 6/6 615.91 MB 0.0 1.5 1.5 0.0 1.5 1.5 0.2 1.0 236.0 235.0 6.42 6.21 2 3.209 1537K 6023 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 22/0 911.44 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.4 2.5 225.1 224.6 9.19 8.39 6 1.532 2101K 4586 0.0 0.0 L4 177/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 156.4 156.4 1.44 1.05 1 1.436 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1280/19 100.80 GB 0.0 7.0 2.7 4.4 11.7 7.3 3.5 2.5 166.1 276.1 43.40 40.25 90 0.482 7321K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 2.7 4.4 11.7 7.3 3.4 2.5 166.1 276.1 43.40 40.25 90 0.482 7321K 14K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.0 2.7 4.4 7.0 2.7 0.0 0.0 239.8 239.3 30.06 28.41 22 1.366 7321K 14K 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 359.0 13.34 11.84 68 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.3 total, 15.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.70 GB write, 784.01 MB/s write, 7.04 GB read, 471.70 MB/s read, 43.4 seconds Interval compaction: 11.70 GB write, 796.24 MB/s write, 7.04 GB read, 479.06 MB/s read, 43.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 16, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1466244 Average: 2.3413 StdDev: 11.22 Min: 1 Median: 1.5553 Max: 3890 Percentiles: P50: 1.56 P75: 1.93 P99: 5.76 P99.9: 10.55 P99.99: 22.41 ------------------------------------------------------ [ 0, 1 ] 196087 13.373% 13.373% ### ( 1, 2 ] 967138 65.960% 79.334% ############# ( 2, 3 ] 191596 13.067% 92.401% ### ( 3, 4 ] 60158 4.103% 96.504% # ( 4, 6 ] 41563 2.835% 99.338% # ( 6, 10 ] 8086 0.551% 99.890% ( 10, 15 ] 1379 0.094% 99.984% ( 15, 22 ] 92 0.006% 99.990% ( 22, 34 ] 11 0.001% 99.991% ( 34, 51 ] 7 0.000% 99.991% ( 51, 76 ] 9 0.001% 99.992% ( 76, 110 ] 137 0.009% 100.001% ( 110, 170 ] 125 0.009% 100.010% ( 170, 250 ] 100 0.007% 100.017% ( 250, 380 ] 65 0.004% 100.021% ( 380, 580 ] 58 0.004% 100.025% ( 580, 870 ] 36 0.002% 100.027% ( 870, 1300 ] 15 0.001% 100.029% ( 1300, 1900 ] 9 0.001% 100.029% ( 1900, 2900 ] 11 0.001% 100.030% ( 2900, 4400 ] 4 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 204124 Average: 3.2332 StdDev: 19.91 Min: 1 Median: 1.6922 Max: 3080 Percentiles: P50: 1.69 P75: 2.31 P99: 8.89 P99.9: 147.32 P99.99: 311.05 ------------------------------------------------------ [ 0, 1 ] 13344 6.537% 6.537% # ( 1, 2 ] 128167 62.789% 69.326% ############# ( 2, 3 ] 37034 18.143% 87.469% #### ( 3, 4 ] 11607 5.686% 93.155% # ( 4, 6 ] 9408 4.609% 97.764% # ( 6, 10 ] 3491 1.710% 99.474% ( 10, 15 ] 580 0.284% 99.758% ( 15, 22 ] 75 0.037% 99.795% ( 22, 34 ] 7 0.003% 99.799% ( 34, 51 ] 1 0.000% 99.799% ( 76, 110 ] 79 0.039% 99.838% ( 110, 170 ] 204 0.100% 99.938% ( 170, 250 ] 77 0.038% 99.976% ( 250, 380 ] 63 0.031% 100.006% ( 380, 580 ] 56 0.027% 100.034% ( 580, 870 ] 34 0.017% 100.050% ( 870, 1300 ] 12 0.006% 100.056% ( 1300, 1900 ] 4 0.002% 100.058% ( 1900, 2900 ] 1 0.000% 100.059% ( 2900, 4400 ] 1 0.000% 100.059% ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 297297 Average: 3.6004 StdDev: 29.77 Min: 1 Median: 1.6385 Max: 4605 Percentiles: P50: 1.64 P75: 2.14 P99: 9.16 P99.9: 283.10 P99.99: 700.25 ------------------------------------------------------ [ 0, 1 ] 29001 9.755% 9.755% ## ( 1, 2 ] 187374 63.026% 72.781% ############# ( 2, 3 ] 46569 15.664% 88.445% ### ( 3, 4 ] 15517 5.219% 93.664% # ( 4, 6 ] 12201 4.104% 97.768% # ( 6, 10 ] 4634 1.559% 99.327% ( 10, 15 ] 714 0.240% 99.567% ( 15, 22 ] 118 0.040% 99.607% ( 22, 34 ] 29 0.010% 99.617% ( 34, 51 ] 10 0.003% 99.620% ( 51, 76 ] 4 0.001% 99.621% ( 76, 110 ] 214 0.072% 99.693% ( 110, 170 ] 379 0.127% 99.821% ( 170, 250 ] 197 0.066% 99.887% ( 250, 380 ] 152 0.051% 99.938% ( 380, 580 ] 124 0.042% 99.980% ( 580, 870 ] 73 0.025% 100.004% ( 870, 1300 ] 23 0.008% 100.012% ( 1300, 1900 ] 15 0.005% 100.017% ( 1900, 2900 ] 10 0.003% 100.021% ( 2900, 4400 ] 2 0.001% 100.021% ( 4400, 6600 ] 1 0.000% 100.022% ** Level 4 read latency histogram (micros): Count: 315 Average: 122.1937 StdDev: 504.44 Min: 0 Median: 1.4598 Max: 4159 Percentiles: P50: 1.46 P75: 6.02 P99: 3218.75 P99.9: 4159.00 P99.99: 4159.00 ------------------------------------------------------ [ 0, 1 ] 106 33.651% 33.651% ####### ( 1, 2 ] 112 35.556% 69.206% ####### ( 2, 3 ] 12 3.810% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 4 1.270% 74.921% ( 6, 10 ] 43 13.651% 88.571% ### ( 10, 15 ] 11 3.492% 92.063% # ( 170, 250 ] 3 0.952% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 4 1.270% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 831.7000 StdDev: 1036.12 Min: 81 Median: 315.0000 Max: 4014 Percentiles: P50: 315.00 P75: 1013.33 P99: 4014.00 P99.9: 4014.00 P99.99: 4014.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 13 21.667% 30.000% #### ( 170, 250 ] 9 15.000% 45.000% ### ( 250, 380 ] 6 10.000% 55.000% ## ( 380, 580 ] 7 11.667% 66.667% ## ( 580, 870 ] 4 6.667% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 2 3.333% 81.667% # ( 1900, 2900 ] 8 13.333% 95.000% ### ( 2900, 4400 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.3 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 321.95 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.082 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.60 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.578 H:M:S, 18.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-15:23:18 ... thread 0: (1000000,6000000) ops and (145061.7,273451.8) ops/second in (6.893618,21.941712) 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/10 2.21 GB 69.2 3.9 0.0 3.9 9.5 5.6 0.0 1.7 128.1 310.1 31.47 29.20 98 0.321 4093K 4205 0.0 0.0 L1 4/0 490.23 MB 49.0 3.7 3.1 0.6 3.7 3.1 0.2 1.2 232.0 230.2 16.51 15.91 3 5.503 3888K 29K 0.0 0.0 L2 16/11 1.76 GB 3.8 0.4 0.2 0.2 0.4 0.2 2.7 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 22/15 911.44 MB 0.1 2.0 0.8 1.2 2.0 0.8 0.4 2.5 225.1 224.6 9.19 8.39 6 1.532 2101K 4586 0.0 0.0 L4 177/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 156.4 156.4 1.44 1.05 1 1.436 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1288/36 101.70 GB 0.0 10.3 4.3 5.9 15.8 9.9 5.3 2.8 175.3 270.0 60.10 56.00 110 0.546 10M 38K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.3 4.3 5.9 15.8 9.9 5.1 2.8 175.3 270.0 60.10 56.00 110 0.546 10M 38K 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 10.3 4.3 5.9 10.2 4.3 0.0 0.0 240.1 239.2 43.87 41.77 27 1.625 10M 38K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 353.3 16.23 14.23 83 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 22.2 total, 21.9 interval Flush(GB): cumulative 5.599, interval 5.599 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.85 GB write, 731.65 MB/s write, 10.29 GB read, 474.93 MB/s read, 60.1 seconds Interval compaction: 15.85 GB write, 739.48 MB/s write, 10.29 GB read, 480.01 MB/s read, 60.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 17, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2114731 Average: 2.3331 StdDev: 11.81 Min: 1 Median: 1.5405 Max: 4182 Percentiles: P50: 1.54 P75: 1.92 P99: 5.81 P99.9: 11.48 P99.99: 102.97 ------------------------------------------------------ [ 0, 1 ] 299925 14.183% 14.183% ### ( 1, 2 ] 1401396 66.268% 80.451% ############# ( 2, 3 ] 260635 12.325% 92.776% ## ( 3, 4 ] 82092 3.882% 96.658% # ( 4, 6 ] 54715 2.587% 99.245% # ( 6, 10 ] 13252 0.627% 99.872% ( 10, 15 ] 2038 0.096% 99.968% ( 15, 22 ] 178 0.008% 99.976% ( 22, 34 ] 17 0.001% 99.977% ( 34, 51 ] 13 0.001% 99.978% ( 51, 76 ] 11 0.001% 99.978% ( 76, 110 ] 312 0.015% 99.993% ( 110, 170 ] 243 0.011% 100.005% ( 170, 250 ] 156 0.007% 100.012% ( 250, 380 ] 103 0.005% 100.017% ( 380, 580 ] 97 0.005% 100.021% ( 580, 870 ] 52 0.002% 100.024% ( 870, 1300 ] 20 0.001% 100.025% ( 1300, 1900 ] 11 0.001% 100.025% ( 1900, 2900 ] 15 0.001% 100.026% ( 2900, 4400 ] 7 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 432400 Average: 3.7790 StdDev: 47.85 Min: 1 Median: 1.6696 Max: 11749 Percentiles: P50: 1.67 P75: 2.27 P99: 8.89 P99.9: 173.57 P99.99: 525.85 ------------------------------------------------------ [ 0, 1 ] 37023 8.562% 8.562% ## ( 1, 2 ] 267597 61.886% 70.449% ############ ( 2, 3 ] 72174 16.691% 87.140% ### ( 3, 4 ] 24693 5.711% 92.851% # ( 4, 6 ] 21271 4.919% 97.770% # ( 6, 10 ] 7374 1.705% 99.475% ( 10, 15 ] 1079 0.250% 99.725% ( 15, 22 ] 153 0.035% 99.760% ( 22, 34 ] 14 0.003% 99.764% ( 34, 51 ] 4 0.001% 99.765% ( 76, 110 ] 251 0.058% 99.823% ( 110, 170 ] 330 0.076% 99.899% ( 170, 250 ] 148 0.034% 99.933% ( 250, 380 ] 134 0.031% 99.964% ( 380, 580 ] 156 0.036% 100.000% ( 580, 870 ] 113 0.026% 100.026% ( 870, 1300 ] 52 0.012% 100.038% ( 1300, 1900 ] 26 0.006% 100.044% ( 1900, 2900 ] 19 0.004% 100.049% ( 2900, 4400 ] 26 0.006% 100.055% ( 4400, 6600 ] 4 0.001% 100.056% ( 9900, 14000 ] 2 0.000% 100.056% ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 358409 Average: 4.7643 StdDev: 59.55 Min: 1 Median: 1.6894 Max: 12721 Percentiles: P50: 1.69 P75: 2.36 P99: 9.58 P99.9: 419.17 P99.99: 830.86 ------------------------------------------------------ [ 0, 1 ] 29810 8.317% 8.317% ## ( 1, 2 ] 216700 60.462% 68.779% ############ ( 2, 3 ] 61540 17.170% 85.949% ### ( 3, 4 ] 22107 6.168% 92.117% # ( 4, 6 ] 19088 5.326% 97.443% # ( 6, 10 ] 6235 1.740% 99.183% ( 10, 15 ] 1107 0.309% 99.492% ( 15, 22 ] 174 0.049% 99.540% ( 22, 34 ] 33 0.009% 99.549% ( 34, 51 ] 14 0.004% 99.553% ( 51, 76 ] 8 0.002% 99.556% ( 76, 110 ] 221 0.062% 99.617% ( 110, 170 ] 425 0.119% 99.736% ( 170, 250 ] 295 0.082% 99.818% ( 250, 380 ] 246 0.069% 99.887% ( 380, 580 ] 243 0.068% 99.955% ( 580, 870 ] 147 0.041% 99.996% ( 870, 1300 ] 70 0.020% 100.015% ( 1300, 1900 ] 37 0.010% 100.025% ( 1900, 2900 ] 36 0.010% 100.035% ( 2900, 4400 ] 25 0.007% 100.042% ( 4400, 6600 ] 11 0.003% 100.045% ( 9900, 14000 ] 1 0.000% 100.046% ** Level 4 read latency histogram (micros): Count: 315 Average: 122.1937 StdDev: 504.44 Min: 0 Median: 1.4598 Max: 4159 Percentiles: P50: 1.46 P75: 6.02 P99: 3218.75 P99.9: 4159.00 P99.99: 4159.00 ------------------------------------------------------ [ 0, 1 ] 106 33.651% 33.651% ####### ( 1, 2 ] 112 35.556% 69.206% ####### ( 2, 3 ] 12 3.810% 73.016% # ( 3, 4 ] 2 0.635% 73.651% ( 4, 6 ] 4 1.270% 74.921% ( 6, 10 ] 43 13.651% 88.571% ### ( 10, 15 ] 11 3.492% 92.063% # ( 170, 250 ] 3 0.952% 93.016% ( 380, 580 ] 1 0.317% 93.333% ( 580, 870 ] 4 1.270% 94.603% ( 870, 1300 ] 7 2.222% 96.825% ( 1300, 1900 ] 4 1.270% 98.095% ( 1900, 2900 ] 2 0.635% 98.730% ( 2900, 4400 ] 4 1.270% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 831.7000 StdDev: 1036.12 Min: 81 Median: 315.0000 Max: 4014 Percentiles: P50: 315.00 P75: 1013.33 P99: 4014.00 P99.9: 4014.00 P99.99: 4014.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 13 21.667% 30.000% #### ( 170, 250 ] 9 15.000% 45.000% ### ( 250, 380 ] 6 10.000% 55.000% ## ( 380, 580 ] 7 11.667% 66.667% ## ( 580, 870 ] 4 6.667% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 2 3.333% 81.667% # ( 1900, 2900 ] 8 13.333% 95.000% ### ( 2900, 4400 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 22.2 total, 6.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 266.26 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.285 H:M:S, 28.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 142.77 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:4.203 H:M:S, 61.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/07/26-15:23:22 ... thread 0: (1000000,7000000) ops and (219684.5,264213.8) ops/second in (4.551983,26.493695) 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/13 3.19 GB 6.3 5.8 0.0 5.8 12.4 6.6 0.0 1.9 135.9 288.6 44.04 39.33 113 0.390 6075K 12K 0.0 0.0 L1 4/4 490.23 MB 0.0 3.7 3.1 0.6 3.7 3.1 0.2 1.2 232.0 230.2 16.51 15.91 3 5.503 3888K 29K 0.0 0.0 L2 7/6 901.44 MB 1.3 0.4 0.2 0.2 0.4 0.2 2.7 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 26/1 1.09 GB 1.0 4.9 2.4 2.5 4.9 2.4 0.4 2.0 184.7 183.9 27.14 21.78 16 1.696 5090K 20K 0.0 0.0 L4 181/0 9.67 GB 1.0 0.9 0.9 0.1 0.9 0.9 0.9 1.1 141.0 140.7 6.82 4.46 15 0.455 964K 1428 0.0 0.0 L5 1064/0 87.35 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/24 102.66 GB 0.0 15.8 6.6 9.1 22.3 13.2 5.9 3.4 168.4 237.9 96.01 82.93 149 0.644 16M 63K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.8 6.6 9.1 22.3 13.2 5.8 3.4 168.4 237.9 96.01 82.93 149 0.644 16M 63K 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.8 6.6 9.1 15.7 6.6 0.0 0.0 214.0 213.2 75.53 66.05 54 1.399 16M 63K 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 329.1 20.48 16.88 95 0.216 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): 26.7 total, 26.5 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.31 GB write, 854.51 MB/s write, 15.79 GB read, 604.74 MB/s read, 96.0 seconds Interval compaction: 22.31 GB write, 862.08 MB/s write, 15.79 GB read, 610.09 MB/s read, 96.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 36, interval: 50 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2463889 Average: 2.5205 StdDev: 18.67 Min: 1 Median: 1.5717 Max: 9082 Percentiles: P50: 1.57 P75: 1.96 P99: 5.96 P99.9: 13.09 P99.99: 167.41 ------------------------------------------------------ [ 0, 1 ] 318584 12.930% 12.930% ### ( 1, 2 ] 1597540 64.838% 77.768% ############# ( 2, 3 ] 329593 13.377% 91.145% ### ( 3, 4 ] 112222 4.555% 95.700% # ( 4, 6 ] 82841 3.362% 99.062% # ( 6, 10 ] 18808 0.763% 99.825% ( 10, 15 ] 2975 0.121% 99.946% ( 15, 22 ] 272 0.011% 99.957% ( 22, 34 ] 24 0.001% 99.958% ( 34, 51 ] 14 0.001% 99.959% ( 51, 76 ] 14 0.001% 99.959% ( 76, 110 ] 394 0.016% 99.975% ( 110, 170 ] 380 0.015% 99.991% ( 170, 250 ] 238 0.010% 100.000% ( 250, 380 ] 167 0.007% 100.007% ( 380, 580 ] 184 0.007% 100.015% ( 580, 870 ] 120 0.005% 100.020% ( 870, 1300 ] 57 0.002% 100.022% ( 1300, 1900 ] 32 0.001% 100.023% ( 1900, 2900 ] 31 0.001% 100.024% ( 2900, 4400 ] 21 0.001% 100.025% ( 4400, 6600 ] 1 0.000% 100.025% ( 6600, 9900 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 806525 Average: 4.5254 StdDev: 70.86 Min: 1 Median: 1.7711 Max: 14487 Percentiles: P50: 1.77 P75: 2.61 P99: 9.31 P99.9: 161.27 P99.99: 497.53 ------------------------------------------------------ [ 0, 1 ] 49943 6.192% 6.192% # ( 1, 2 ] 458185 56.810% 63.002% ########### ( 2, 3 ] 157531 19.532% 82.534% #### ( 3, 4 ] 59717 7.404% 89.938% # ( 4, 6 ] 59010 7.317% 97.255% # ( 6, 10 ] 16993 2.107% 99.362% ( 10, 15 ] 3219 0.399% 99.761% ( 15, 22 ] 388 0.048% 99.809% ( 22, 34 ] 30 0.004% 99.813% ( 34, 51 ] 8 0.001% 99.814% ( 51, 76 ] 7 0.001% 99.815% ( 76, 110 ] 326 0.040% 99.855% ( 110, 170 ] 423 0.052% 99.908% ( 170, 250 ] 244 0.030% 99.938% ( 250, 380 ] 237 0.029% 99.967% ( 380, 580 ] 312 0.039% 100.006% ( 580, 870 ] 227 0.028% 100.034% ( 870, 1300 ] 116 0.014% 100.048% ( 1300, 1900 ] 65 0.008% 100.057% ( 1900, 2900 ] 60 0.007% 100.064% ( 2900, 4400 ] 87 0.011% 100.075% ( 4400, 6600 ] 25 0.003% 100.078% ( 6600, 9900 ] 14 0.002% 100.080% ( 9900, 14000 ] 3 0.000% 100.080% ( 14000, 22000 ] 1 0.000% 100.080% ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 758802 Average: 4.7309 StdDev: 61.96 Min: 1 Median: 1.8530 Max: 17242 Percentiles: P50: 1.85 P75: 2.80 P99: 9.19 P99.9: 166.08 P99.99: 364.94 ------------------------------------------------------ [ 0, 1 ] 33691 4.440% 4.440% # ( 1, 2 ] 405299 53.413% 57.853% ########### ( 2, 3 ] 163341 21.526% 79.379% #### ( 3, 4 ] 69178 9.117% 88.496% ## ( 4, 6 ] 68302 9.001% 97.497% ## ( 6, 10 ] 14318 1.887% 99.384% ( 10, 15 ] 2813 0.371% 99.755% ( 15, 22 ] 340 0.045% 99.800% ( 22, 34 ] 42 0.006% 99.805% ( 34, 51 ] 21 0.003% 99.808% ( 51, 76 ] 11 0.001% 99.809% ( 76, 110 ] 232 0.031% 99.840% ( 110, 170 ] 487 0.064% 99.904% ( 170, 250 ] 362 0.048% 99.952% ( 250, 380 ] 327 0.043% 99.995% ( 380, 580 ] 386 0.051% 100.046% ( 580, 870 ] 282 0.037% 100.083% ( 870, 1300 ] 160 0.021% 100.104% ( 1300, 1900 ] 73 0.010% 100.114% ( 1900, 2900 ] 71 0.009% 100.123% ( 2900, 4400 ] 71 0.009% 100.132% ( 4400, 6600 ] 18 0.002% 100.135% ( 6600, 9900 ] 2 0.000% 100.135% ( 9900, 14000 ] 1 0.000% 100.135% ( 14000, 22000 ] 1 0.000% 100.135% ** Level 4 read latency histogram (micros): Count: 14075 Average: 65.3277 StdDev: 344.55 Min: 0 Median: 2.0222 Max: 8216 Percentiles: P50: 2.02 P75: 3.29 P99: 1528.26 P99.9: 4194.26 P99.99: 7651.05 ------------------------------------------------------ [ 0, 1 ] 354 2.515% 2.515% # ( 1, 2 ] 6615 46.998% 49.513% ######### ( 2, 3 ] 3091 21.961% 71.474% #### ( 3, 4 ] 1696 12.050% 83.524% ## ( 4, 6 ] 942 6.693% 90.217% # ( 6, 10 ] 316 2.245% 92.462% ( 10, 15 ] 99 0.703% 93.165% ( 15, 22 ] 7 0.050% 93.215% ( 22, 34 ] 1 0.007% 93.222% ( 34, 51 ] 1 0.007% 93.229% ( 76, 110 ] 8 0.057% 93.286% ( 110, 170 ] 52 0.369% 93.655% ( 170, 250 ] 75 0.533% 94.188% ( 250, 380 ] 119 0.845% 95.034% ( 380, 580 ] 184 1.307% 96.341% ( 580, 870 ] 203 1.442% 97.783% ( 870, 1300 ] 145 1.030% 98.813% ( 1300, 1900 ] 69 0.490% 99.304% ( 1900, 2900 ] 52 0.369% 99.673% ( 2900, 4400 ] 37 0.263% 99.936% ( 4400, 6600 ] 6 0.043% 99.979% ( 6600, 9900 ] 5 0.036% 100.014% ** Level 5 read latency histogram (micros): Count: 100 Average: 933.8900 StdDev: 1107.27 Min: 81 Median: 380.0000 Max: 4126 Percentiles: P50: 380.00 P75: 1300.00 P99: 4126.00 P99.9: 4126.00 P99.99: 4126.00 ------------------------------------------------------ ( 76, 110 ] 8 8.000% 8.000% ## ( 110, 170 ] 17 17.000% 25.000% ### ( 170, 250 ] 15 15.000% 40.000% ### ( 250, 380 ] 10 10.000% 50.000% ## ( 380, 580 ] 13 13.000% 63.000% ### ( 580, 870 ] 6 6.000% 69.000% # ( 870, 1300 ] 6 6.000% 75.000% # ( 1300, 1900 ] 5 5.000% 80.000% # ( 1900, 2900 ] 12 12.000% 92.000% ## ( 2900, 4400 ] 8 8.000% 100.000% ## ** DB Stats ** Uptime(secs): 26.7 total, 4.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 257.73 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:7.977 H:M:S, 29.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 216.21 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.692 H:M:S, 37.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/26-15:23:26 ... thread 0: (1000000,8000000) ops and (255473.9,263088.8) ops/second in (3.914294,30.407989) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 4.17 GB 107.0 6.8 0.0 6.8 14.3 7.6 0.0 1.9 135.1 286.0 51.27 45.51 129 0.397 7035K 13K 0.0 0.0 L1 4/4 490.23 MB 0.0 3.7 3.1 0.6 3.7 3.1 0.2 1.2 232.0 230.2 16.51 15.91 3 5.503 3888K 29K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.7 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 25/0 991.40 MB 1.0 5.1 2.6 2.6 5.1 2.5 0.4 2.0 184.5 183.8 28.49 22.82 17 1.676 5337K 20K 0.0 0.0 L4 189/0 9.68 GB 1.0 2.0 1.9 0.1 2.0 1.9 0.9 1.1 137.3 137.0 15.04 9.57 36 0.418 2015K 1805 0.0 0.0 L5 1076/0 88.34 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1312/17 103.64 GB 0.0 18.0 7.8 10.3 25.5 15.3 6.8 3.4 163.6 231.7 112.80 95.26 187 0.603 18M 65K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.0 7.8 10.3 25.5 15.3 6.7 3.4 163.6 231.7 112.80 95.26 187 0.603 18M 65K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 18.0 7.8 10.3 18.0 7.7 0.0 0.0 207.6 206.9 88.88 75.81 79 1.125 18M 65K 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 324.1 23.91 19.45 108 0.221 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 30.6 total, 30.4 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: 25.52 GB write, 852.91 MB/s write, 18.02 GB read, 602.29 MB/s read, 112.8 seconds Interval compaction: 25.52 GB write, 859.49 MB/s write, 18.02 GB read, 606.94 MB/s read, 112.8 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: 47, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 47, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2935430 Average: 2.5754 StdDev: 21.80 Min: 1 Median: 1.5895 Max: 11302 Percentiles: P50: 1.59 P75: 1.98 P99: 6.07 P99.9: 13.13 P99.99: 153.39 ------------------------------------------------------ [ 0, 1 ] 354691 12.083% 12.083% ## ( 1, 2 ] 1887943 64.316% 76.399% ############# ( 2, 3 ] 413891 14.100% 90.499% ### ( 3, 4 ] 141039 4.805% 95.303% # ( 4, 6 ] 108057 3.681% 98.985% # ( 6, 10 ] 24431 0.832% 99.817% ( 10, 15 ] 3899 0.133% 99.950% ( 15, 22 ] 344 0.012% 99.961% ( 22, 34 ] 34 0.001% 99.962% ( 34, 51 ] 15 0.001% 99.963% ( 51, 76 ] 15 0.001% 99.964% ( 76, 110 ] 453 0.015% 99.979% ( 110, 170 ] 450 0.015% 99.994% ( 170, 250 ] 278 0.009% 100.004% ( 250, 380 ] 196 0.007% 100.010% ( 380, 580 ] 208 0.007% 100.018% ( 580, 870 ] 135 0.005% 100.022% ( 870, 1300 ] 68 0.002% 100.024% ( 1300, 1900 ] 39 0.001% 100.026% ( 1900, 2900 ] 38 0.001% 100.027% ( 2900, 4400 ] 33 0.001% 100.028% ( 4400, 6600 ] 5 0.000% 100.028% ( 6600, 9900 ] 1 0.000% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 839227 Average: 4.5309 StdDev: 70.55 Min: 1 Median: 1.7648 Max: 14487 Percentiles: P50: 1.76 P75: 2.60 P99: 9.30 P99.9: 166.74 P99.99: 527.29 ------------------------------------------------------ [ 0, 1 ] 52419 6.246% 6.246% # ( 1, 2 ] 480126 57.211% 63.457% ########### ( 2, 3 ] 162351 19.345% 82.802% #### ( 3, 4 ] 61327 7.308% 90.109% # ( 4, 6 ] 60116 7.163% 97.273% # ( 6, 10 ] 17577 2.094% 99.367% ( 10, 15 ] 3303 0.394% 99.761% ( 15, 22 ] 393 0.047% 99.808% ( 22, 34 ] 31 0.004% 99.811% ( 34, 51 ] 8 0.001% 99.812% ( 51, 76 ] 7 0.001% 99.813% ( 76, 110 ] 326 0.039% 99.852% ( 110, 170 ] 427 0.051% 99.903% ( 170, 250 ] 246 0.029% 99.932% ( 250, 380 ] 246 0.029% 99.961% ( 380, 580 ] 326 0.039% 100.000% ( 580, 870 ] 245 0.029% 100.029% ( 870, 1300 ] 128 0.015% 100.045% ( 1300, 1900 ] 72 0.009% 100.053% ( 1900, 2900 ] 67 0.008% 100.061% ( 2900, 4400 ] 88 0.010% 100.072% ( 4400, 6600 ] 26 0.003% 100.075% ( 6600, 9900 ] 14 0.002% 100.076% ( 9900, 14000 ] 3 0.000% 100.077% ( 14000, 22000 ] 1 0.000% 100.077% ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1045862 Average: 4.8150 StdDev: 64.89 Min: 1 Median: 1.8961 Max: 17242 Percentiles: P50: 1.90 P75: 2.87 P99: 9.02 P99.9: 92.59 P99.99: 231.16 ------------------------------------------------------ [ 0, 1 ] 37222 3.559% 3.559% # ( 1, 2 ] 542011 51.824% 55.383% ########## ( 2, 3 ] 236924 22.653% 78.037% ##### ( 3, 4 ] 101987 9.751% 87.788% ## ( 4, 6 ] 102270 9.779% 97.567% ## ( 6, 10 ] 19853 1.898% 99.465% ( 10, 15 ] 3889 0.372% 99.837% ( 15, 22 ] 456 0.044% 99.880% ( 22, 34 ] 49 0.005% 99.885% ( 34, 51 ] 24 0.002% 99.887% ( 51, 76 ] 14 0.001% 99.889% ( 76, 110 ] 240 0.023% 99.912% ( 110, 170 ] 521 0.050% 99.962% ( 170, 250 ] 389 0.037% 99.999% ( 250, 380 ] 376 0.036% 100.035% ( 380, 580 ] 484 0.046% 100.081% ( 580, 870 ] 378 0.036% 100.117% ( 870, 1300 ] 218 0.021% 100.138% ( 1300, 1900 ] 104 0.010% 100.148% ( 1900, 2900 ] 96 0.009% 100.157% ( 2900, 4400 ] 128 0.012% 100.169% ( 4400, 6600 ] 29 0.003% 100.172% ( 6600, 9900 ] 4 0.000% 100.172% ( 9900, 14000 ] 1 0.000% 100.173% ( 14000, 22000 ] 1 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 34853 Average: 62.4634 StdDev: 339.10 Min: 0 Median: 2.0118 Max: 15130 Percentiles: P50: 2.01 P75: 3.28 P99: 1375.81 P99.9: 4240.01 P99.99: 6812.31 ------------------------------------------------------ [ 0, 1 ] 906 2.599% 2.599% # ( 1, 2 ] 16430 47.141% 49.740% ######### ( 2, 3 ] 7656 21.967% 71.707% #### ( 3, 4 ] 4173 11.973% 83.680% ## ( 4, 6 ] 2398 6.880% 90.560% # ( 6, 10 ] 700 2.008% 92.569% ( 10, 15 ] 225 0.646% 93.214% ( 15, 22 ] 20 0.057% 93.272% ( 22, 34 ] 5 0.014% 93.286% ( 34, 51 ] 1 0.003% 93.289% ( 76, 110 ] 19 0.055% 93.343% ( 110, 170 ] 119 0.341% 93.685% ( 170, 250 ] 191 0.548% 94.233% ( 250, 380 ] 328 0.941% 95.174% ( 380, 580 ] 455 1.305% 96.479% ( 580, 870 ] 502 1.440% 97.920% ( 870, 1300 ] 356 1.021% 98.941% ( 1300, 1900 ] 162 0.465% 99.406% ( 1900, 2900 ] 98 0.281% 99.687% ( 2900, 4400 ] 83 0.238% 99.925% ( 4400, 6600 ] 22 0.063% 99.989% ( 6600, 9900 ] 8 0.023% 100.011% ( 14000, 22000 ] 1 0.003% 100.014% ** Level 5 read latency histogram (micros): Count: 160 Average: 1150.3500 StdDev: 1222.17 Min: 81 Median: 541.9048 Max: 5404 Percentiles: P50: 541.90 P75: 1807.69 P99: 4840.00 P99.9: 5404.00 P99.99: 5404.00 ------------------------------------------------------ ( 76, 110 ] 11 6.875% 6.875% # ( 110, 170 ] 21 13.125% 20.000% ### ( 170, 250 ] 17 10.625% 30.625% ## ( 250, 380 ] 14 8.750% 39.375% ## ( 380, 580 ] 21 13.125% 52.500% ### ( 580, 870 ] 10 6.250% 58.750% # ( 870, 1300 ] 15 9.375% 68.125% ## ( 1300, 1900 ] 13 8.125% 76.250% ## ( 1900, 2900 ] 20 12.500% 88.750% ### ( 2900, 4400 ] 16 10.000% 98.750% ## ( 4400, 6600 ] 2 1.250% 100.000% ** DB Stats ** Uptime(secs): 30.6 total, 3.9 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 256.93 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:9.135 H:M:S, 29.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 251.43 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.158 H:M:S, 29.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-15:23:31 ... thread 0: (1000000,9000000) ops and (198907.7,253983.0) ops/second in (5.027458,35.435447) 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/15 5.16 GB 100.7 8.0 0.0 8.0 16.5 8.5 0.0 1.9 139.0 287.3 58.93 52.73 150 0.393 8314K 14K 0.0 0.0 L1 4/4 490.23 MB 0.0 3.7 3.1 0.6 3.7 3.1 0.2 1.2 232.0 230.2 16.51 15.91 3 5.503 3888K 29K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.7 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 25/0 991.40 MB 1.0 5.1 2.6 2.6 5.1 2.5 0.4 2.0 184.5 183.8 28.49 22.82 17 1.676 5337K 20K 0.0 0.0 L4 189/0 9.68 GB 1.0 2.0 1.9 0.1 2.0 1.9 0.9 1.1 137.3 137.0 15.04 9.57 36 0.418 2015K 1805 0.0 0.0 L5 1076/0 88.34 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1313/19 104.62 GB 0.0 19.3 7.8 11.5 27.7 16.2 6.8 3.2 163.7 235.8 120.46 102.48 208 0.579 19M 66K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.3 7.8 11.5 27.7 16.2 6.7 3.2 163.7 235.8 120.46 102.48 208 0.579 19M 66K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.3 7.8 11.5 19.2 7.7 0.0 0.0 210.7 209.9 93.59 80.42 84 1.114 19M 66K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 325.9 26.87 22.06 124 0.217 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): 35.7 total, 35.4 interval Flush(GB): cumulative 8.552, interval 8.552 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.74 GB write, 796.25 MB/s write, 19.25 GB read, 552.73 MB/s read, 120.5 seconds Interval compaction: 27.74 GB write, 801.52 MB/s write, 19.25 GB read, 556.39 MB/s read, 120.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 26, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 26, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 47, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 47, interval: 73 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3535132 Average: 2.5199 StdDev: 20.11 Min: 1 Median: 1.5772 Max: 11302 Percentiles: P50: 1.58 P75: 1.96 P99: 6.09 P99.9: 12.95 P99.99: 138.78 ------------------------------------------------------ [ 0, 1 ] 445278 12.596% 12.596% ### ( 1, 2 ] 2290853 64.802% 77.398% ############# ( 2, 3 ] 484657 13.710% 91.108% ### ( 3, 4 ] 159645 4.516% 95.624% # ( 4, 6 ] 118658 3.357% 98.980% # ( 6, 10 ] 29804 0.843% 99.824% ( 10, 15 ] 4583 0.130% 99.953% ( 15, 22 ] 399 0.011% 99.964% ( 22, 34 ] 34 0.001% 99.965% ( 34, 51 ] 17 0.000% 99.966% ( 51, 76 ] 20 0.001% 99.967% ( 76, 110 ] 585 0.017% 99.983% ( 110, 170 ] 516 0.015% 99.998% ( 170, 250 ] 307 0.009% 100.006% ( 250, 380 ] 208 0.006% 100.012% ( 380, 580 ] 220 0.006% 100.018% ( 580, 870 ] 148 0.004% 100.023% ( 870, 1300 ] 74 0.002% 100.025% ( 1300, 1900 ] 41 0.001% 100.026% ( 1900, 2900 ] 39 0.001% 100.027% ( 2900, 4400 ] 33 0.001% 100.028% ( 4400, 6600 ] 5 0.000% 100.028% ( 6600, 9900 ] 1 0.000% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 839227 Average: 4.5309 StdDev: 70.55 Min: 1 Median: 1.7648 Max: 14487 Percentiles: P50: 1.76 P75: 2.60 P99: 9.30 P99.9: 166.74 P99.99: 527.29 ------------------------------------------------------ [ 0, 1 ] 52419 6.246% 6.246% # ( 1, 2 ] 480126 57.211% 63.457% ########### ( 2, 3 ] 162351 19.345% 82.802% #### ( 3, 4 ] 61327 7.308% 90.109% # ( 4, 6 ] 60116 7.163% 97.273% # ( 6, 10 ] 17577 2.094% 99.367% ( 10, 15 ] 3303 0.394% 99.761% ( 15, 22 ] 393 0.047% 99.808% ( 22, 34 ] 31 0.004% 99.811% ( 34, 51 ] 8 0.001% 99.812% ( 51, 76 ] 7 0.001% 99.813% ( 76, 110 ] 326 0.039% 99.852% ( 110, 170 ] 427 0.051% 99.903% ( 170, 250 ] 246 0.029% 99.932% ( 250, 380 ] 246 0.029% 99.961% ( 380, 580 ] 326 0.039% 100.000% ( 580, 870 ] 245 0.029% 100.029% ( 870, 1300 ] 128 0.015% 100.045% ( 1300, 1900 ] 72 0.009% 100.053% ( 1900, 2900 ] 67 0.008% 100.061% ( 2900, 4400 ] 88 0.010% 100.072% ( 4400, 6600 ] 26 0.003% 100.075% ( 6600, 9900 ] 14 0.002% 100.076% ( 9900, 14000 ] 3 0.000% 100.077% ( 14000, 22000 ] 1 0.000% 100.077% ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1045862 Average: 4.8150 StdDev: 64.89 Min: 1 Median: 1.8961 Max: 17242 Percentiles: P50: 1.90 P75: 2.87 P99: 9.02 P99.9: 92.59 P99.99: 231.16 ------------------------------------------------------ [ 0, 1 ] 37222 3.559% 3.559% # ( 1, 2 ] 542011 51.824% 55.383% ########## ( 2, 3 ] 236924 22.653% 78.037% ##### ( 3, 4 ] 101987 9.751% 87.788% ## ( 4, 6 ] 102270 9.779% 97.567% ## ( 6, 10 ] 19853 1.898% 99.465% ( 10, 15 ] 3889 0.372% 99.837% ( 15, 22 ] 456 0.044% 99.880% ( 22, 34 ] 49 0.005% 99.885% ( 34, 51 ] 24 0.002% 99.887% ( 51, 76 ] 14 0.001% 99.889% ( 76, 110 ] 240 0.023% 99.912% ( 110, 170 ] 521 0.050% 99.962% ( 170, 250 ] 389 0.037% 99.999% ( 250, 380 ] 376 0.036% 100.035% ( 380, 580 ] 484 0.046% 100.081% ( 580, 870 ] 378 0.036% 100.117% ( 870, 1300 ] 218 0.021% 100.138% ( 1300, 1900 ] 104 0.010% 100.148% ( 1900, 2900 ] 96 0.009% 100.157% ( 2900, 4400 ] 128 0.012% 100.169% ( 4400, 6600 ] 29 0.003% 100.172% ( 6600, 9900 ] 4 0.000% 100.172% ( 9900, 14000 ] 1 0.000% 100.173% ( 14000, 22000 ] 1 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 34853 Average: 62.4634 StdDev: 339.10 Min: 0 Median: 2.0118 Max: 15130 Percentiles: P50: 2.01 P75: 3.28 P99: 1375.81 P99.9: 4240.01 P99.99: 6812.31 ------------------------------------------------------ [ 0, 1 ] 906 2.599% 2.599% # ( 1, 2 ] 16430 47.141% 49.740% ######### ( 2, 3 ] 7656 21.967% 71.707% #### ( 3, 4 ] 4173 11.973% 83.680% ## ( 4, 6 ] 2398 6.880% 90.560% # ( 6, 10 ] 700 2.008% 92.569% ( 10, 15 ] 225 0.646% 93.214% ( 15, 22 ] 20 0.057% 93.272% ( 22, 34 ] 5 0.014% 93.286% ( 34, 51 ] 1 0.003% 93.289% ( 76, 110 ] 19 0.055% 93.343% ( 110, 170 ] 119 0.341% 93.685% ( 170, 250 ] 191 0.548% 94.233% ( 250, 380 ] 328 0.941% 95.174% ( 380, 580 ] 455 1.305% 96.479% ( 580, 870 ] 502 1.440% 97.920% ( 870, 1300 ] 356 1.021% 98.941% ( 1300, 1900 ] 162 0.465% 99.406% ( 1900, 2900 ] 98 0.281% 99.687% ( 2900, 4400 ] 83 0.238% 99.925% ( 4400, 6600 ] 22 0.063% 99.989% ( 6600, 9900 ] 8 0.023% 100.011% ( 14000, 22000 ] 1 0.003% 100.014% ** Level 5 read latency histogram (micros): Count: 160 Average: 1150.3500 StdDev: 1222.17 Min: 81 Median: 541.9048 Max: 5404 Percentiles: P50: 541.90 P75: 1807.69 P99: 4840.00 P99.9: 5404.00 P99.99: 5404.00 ------------------------------------------------------ ( 76, 110 ] 11 6.875% 6.875% # ( 110, 170 ] 21 13.125% 20.000% ### ( 170, 250 ] 17 10.625% 30.625% ## ( 250, 380 ] 14 8.750% 39.375% ## ( 380, 580 ] 21 13.125% 52.500% ### ( 580, 870 ] 10 6.250% 58.750% # ( 870, 1300 ] 15 9.375% 68.125% ## ( 1300, 1900 ] 13 8.125% 76.250% ## ( 1900, 2900 ] 20 12.500% 88.750% ### ( 2900, 4400 ] 16 10.000% 98.750% ## ( 4400, 6600 ] 2 1.250% 100.000% ** DB Stats ** Uptime(secs): 35.7 total, 5.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 248.31 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:11.488 H:M:S, 32.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 195.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.353 H:M:S, 46.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-15:23:42 ... thread 0: (1000000,10000000) ops and (96152.5,218171.1) ops/second in (10.400142,45.835589) 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/10 3.19 GB 37.8 9.8 0.0 9.8 19.2 9.5 0.0 2.0 145.4 285.8 68.90 61.88 167 0.413 10M 22K 0.0 0.0 L1 20/20 2.31 GB 0.0 7.1 6.0 1.1 7.0 5.9 0.2 1.2 222.5 220.1 32.68 30.75 4 8.171 7383K 78K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.7 2.0 253.1 253.0 1.49 1.45 2 0.746 383K 219 0.0 0.0 L3 19/0 996.05 MB 1.0 6.1 3.2 2.9 6.1 3.2 0.8 1.9 185.7 184.9 33.64 27.24 22 1.529 6343K 27K 0.0 0.0 L4 194/0 9.69 GB 1.0 3.1 2.9 0.2 3.1 2.9 0.9 1.1 140.1 139.7 22.44 14.56 53 0.423 3062K 2865 0.0 0.0 L5 1088/0 89.32 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1334/30 105.48 GB 0.0 26.4 12.3 14.2 35.8 21.6 9.2 3.8 170.0 230.1 159.15 135.88 248 0.642 27M 131K 0.0 0.0 Int 0/0 0.00 KB 0.0 26.4 12.3 14.2 35.8 21.6 9.1 3.8 170.0 230.1 159.15 135.88 248 0.642 27M 131K 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 26.4 12.3 14.2 26.3 12.1 0.0 0.0 208.8 207.8 129.54 111.38 110 1.178 27M 131K 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 327.6 29.61 24.50 138 0.215 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 46.1 total, 45.8 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: 35.76 GB write, 794.79 MB/s write, 26.42 GB read, 587.17 MB/s read, 159.2 seconds Interval compaction: 35.76 GB write, 798.86 MB/s write, 26.42 GB read, 590.17 MB/s read, 159.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 28, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 28, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 49, pending-compaction-bytes-delays: 24, pending-compaction-bytes-stops: 0, total-delays: 52, total-stops: 49, interval: 101 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4418463 Average: 2.7418 StdDev: 21.16 Min: 1 Median: 1.5750 Max: 11302 Percentiles: P50: 1.57 P75: 1.96 P99: 7.19 P99.9: 114.64 P99.99: 283.07 ------------------------------------------------------ [ 0, 1 ] 567140 12.836% 12.836% ### ( 1, 2 ] 2856054 64.639% 77.475% ############# ( 2, 3 ] 599083 13.559% 91.033% ### ( 3, 4 ] 193742 4.385% 95.418% # ( 4, 6 ] 145548 3.294% 98.712% # ( 6, 10 ] 42566 0.963% 99.676% ( 10, 15 ] 6237 0.141% 99.817% ( 15, 22 ] 597 0.014% 99.830% ( 22, 34 ] 51 0.001% 99.832% ( 34, 51 ] 23 0.001% 99.832% ( 51, 76 ] 42 0.001% 99.833% ( 76, 110 ] 2719 0.062% 99.895% ( 110, 170 ] 3149 0.071% 99.966% ( 170, 250 ] 902 0.020% 99.986% ( 250, 380 ] 665 0.015% 100.001% ( 380, 580 ] 536 0.012% 100.013% ( 580, 870 ] 298 0.007% 100.020% ( 870, 1300 ] 114 0.003% 100.023% ( 1300, 1900 ] 61 0.001% 100.024% ( 1900, 2900 ] 51 0.001% 100.025% ( 2900, 4400 ] 41 0.001% 100.026% ( 4400, 6600 ] 5 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ( 9900, 14000 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1126788 Average: 4.3981 StdDev: 63.45 Min: 1 Median: 1.7507 Max: 14487 Percentiles: P50: 1.75 P75: 2.56 P99: 9.35 P99.9: 173.69 P99.99: 507.81 ------------------------------------------------------ [ 0, 1 ] 74212 6.586% 6.586% # ( 1, 2 ] 651633 57.831% 64.417% ############ ( 2, 3 ] 211150 18.739% 83.156% #### ( 3, 4 ] 81739 7.254% 90.410% # ( 4, 6 ] 76933 6.828% 97.238% # ( 6, 10 ] 23695 2.103% 99.341% ( 10, 15 ] 4298 0.381% 99.722% ( 15, 22 ] 575 0.051% 99.773% ( 22, 34 ] 38 0.003% 99.777% ( 34, 51 ] 10 0.001% 99.778% ( 51, 76 ] 21 0.002% 99.780% ( 76, 110 ] 563 0.050% 99.830% ( 110, 170 ] 777 0.069% 99.898% ( 170, 250 ] 373 0.033% 99.932% ( 250, 380 ] 365 0.032% 99.964% ( 380, 580 ] 459 0.041% 100.005% ( 580, 870 ] 345 0.031% 100.035% ( 870, 1300 ] 187 0.017% 100.052% ( 1300, 1900 ] 96 0.009% 100.060% ( 1900, 2900 ] 76 0.007% 100.067% ( 2900, 4400 ] 92 0.008% 100.075% ( 4400, 6600 ] 28 0.002% 100.078% ( 6600, 9900 ] 14 0.001% 100.079% ( 9900, 14000 ] 3 0.000% 100.079% ( 14000, 22000 ] 1 0.000% 100.079% ** Level 2 read latency histogram (micros): Count: 124149 Average: 2.5364 StdDev: 19.15 Min: 0 Median: 1.4584 Max: 4299 Percentiles: P50: 1.46 P75: 1.86 P99: 6.28 P99.9: 133.17 P99.99: 687.10 ------------------------------------------------------ [ 0, 1 ] 26682 21.492% 21.492% #### ( 1, 2 ] 77203 62.186% 83.678% ############ ( 2, 3 ] 11888 9.576% 93.253% ## ( 3, 4 ] 4133 3.329% 96.582% # ( 4, 6 ] 2937 2.366% 98.948% ( 6, 10 ] 918 0.739% 99.687% ( 10, 15 ] 146 0.118% 99.805% ( 15, 22 ] 10 0.008% 99.813% ( 22, 34 ] 4 0.003% 99.816% ( 34, 51 ] 2 0.002% 99.818% ( 51, 76 ] 2 0.002% 99.820% ( 76, 110 ] 79 0.064% 99.883% ( 110, 170 ] 54 0.043% 99.927% ( 170, 250 ] 36 0.029% 99.956% ( 250, 380 ] 17 0.014% 99.969% ( 380, 580 ] 23 0.019% 99.988% ( 580, 870 ] 7 0.006% 99.994% ( 870, 1300 ] 3 0.002% 99.996% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1387702 Average: 5.1500 StdDev: 66.78 Min: 1 Median: 1.9167 Max: 17242 Percentiles: P50: 1.92 P75: 2.90 P99: 9.19 P99.9: 93.41 P99.99: 236.82 ------------------------------------------------------ [ 0, 1 ] 42550 3.066% 3.066% # ( 1, 2 ] 710502 51.200% 54.266% ########## ( 2, 3 ] 318464 22.949% 77.215% ##### ( 3, 4 ] 139250 10.035% 87.250% ## ( 4, 6 ] 140510 10.125% 97.375% ## ( 6, 10 ] 28268 2.037% 99.412% ( 10, 15 ] 5812 0.419% 99.831% ( 15, 22 ] 696 0.050% 99.881% ( 22, 34 ] 69 0.005% 99.886% ( 34, 51 ] 25 0.002% 99.888% ( 51, 76 ] 28 0.002% 99.890% ( 76, 110 ] 274 0.020% 99.910% ( 110, 170 ] 655 0.047% 99.957% ( 170, 250 ] 551 0.040% 99.997% ( 250, 380 ] 613 0.044% 100.041% ( 380, 580 ] 753 0.054% 100.095% ( 580, 870 ] 644 0.046% 100.141% ( 870, 1300 ] 391 0.028% 100.170% ( 1300, 1900 ] 175 0.013% 100.182% ( 1900, 2900 ] 152 0.011% 100.193% ( 2900, 4400 ] 174 0.013% 100.206% ( 4400, 6600 ] 38 0.003% 100.208% ( 6600, 9900 ] 5 0.000% 100.209% ( 9900, 14000 ] 1 0.000% 100.209% ( 14000, 22000 ] 1 0.000% 100.209% ** Level 4 read latency histogram (micros): Count: 52674 Average: 58.7147 StdDev: 313.22 Min: 0 Median: 1.9997 Max: 15130 Percentiles: P50: 2.00 P75: 3.27 P99: 1289.49 P99.9: 3980.08 P99.99: 5900.45 ------------------------------------------------------ [ 0, 1 ] 1354 2.571% 2.571% # ( 1, 2 ] 24990 47.443% 50.013% ######### ( 2, 3 ] 11495 21.823% 71.836% #### ( 3, 4 ] 6220 11.808% 83.645% ## ( 4, 6 ] 3649 6.928% 90.572% # ( 6, 10 ] 1080 2.050% 92.623% ( 10, 15 ] 319 0.606% 93.228% ( 15, 22 ] 29 0.055% 93.283% ( 22, 34 ] 6 0.011% 93.295% ( 34, 51 ] 1 0.002% 93.297% ( 51, 76 ] 3 0.006% 93.302% ( 76, 110 ] 56 0.106% 93.409% ( 110, 170 ] 214 0.406% 93.815% ( 170, 250 ] 303 0.575% 94.390% ( 250, 380 ] 498 0.945% 95.335% ( 380, 580 ] 677 1.285% 96.621% ( 580, 870 ] 745 1.414% 98.035% ( 870, 1300 ] 521 0.989% 99.024% ( 1300, 1900 ] 251 0.477% 99.501% ( 1900, 2900 ] 134 0.254% 99.755% ( 2900, 4400 ] 106 0.201% 99.956% ( 4400, 6600 ] 26 0.049% 100.006% ( 6600, 9900 ] 8 0.015% 100.021% ( 14000, 22000 ] 1 0.002% 100.023% ** Level 5 read latency histogram (micros): Count: 220 Average: 1165.6045 StdDev: 1222.40 Min: 81 Median: 555.7576 Max: 5404 Percentiles: P50: 555.76 P75: 1860.00 P99: 4387.50 P99.9: 5404.00 P99.99: 5404.00 ------------------------------------------------------ ( 76, 110 ] 15 6.818% 6.818% # ( 110, 170 ] 24 10.909% 17.727% ## ( 170, 250 ] 21 9.545% 27.273% ## ( 250, 380 ] 21 9.545% 36.818% ## ( 380, 580 ] 33 15.000% 51.818% ### ( 580, 870 ] 18 8.182% 60.000% ## ( 870, 1300 ] 19 8.636% 68.636% ## ( 1300, 1900 ] 15 6.818% 75.455% # ( 1900, 2900 ] 28 12.727% 88.182% ### ( 2900, 4400 ] 24 10.909% 99.091% ## ( 4400, 6600 ] 2 0.909% 100.000% ** DB Stats ** Uptime(secs): 46.1 total, 10.4 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 213.62 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:19.083 H:M:S, 41.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 94.63 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:7.595 H:M:S, 73.0 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.856 micros/op 170773 ops/sec 60.127 seconds 10267999 operations; 165.5 MB/s Microseconds per write: Count: 10267999 Average: 5.8557 StdDev: 400.81 Min: 0 Median: 1.7332 Max: 736466 Percentiles: P50: 1.73 P75: 2.68 P99: 7.55 P99.9: 1176.39 P99.99: 2745.74 ------------------------------------------------------ [ 0, 1 ] 1434902 13.975% 13.975% ### ( 1, 2 ] 5044969 49.133% 63.107% ########## ( 2, 3 ] 1805036 17.579% 80.687% #### ( 3, 4 ] 1368780 13.331% 94.017% ### ( 4, 6 ] 482750 4.702% 98.719% # ( 6, 10 ] 74571 0.726% 99.445% ( 10, 15 ] 17622 0.172% 99.617% ( 15, 22 ] 6342 0.062% 99.678% ( 22, 34 ] 2097 0.020% 99.699% ( 34, 51 ] 186 0.002% 99.701% ( 51, 76 ] 22 0.000% 99.701% ( 76, 110 ] 7248 0.071% 99.771% ( 110, 170 ] 2808 0.027% 99.799% ( 170, 250 ] 273 0.003% 99.801% ( 250, 380 ] 79 0.001% 99.802% ( 380, 580 ] 36 0.000% 99.803% ( 580, 870 ] 23 0.000% 99.803% ( 870, 1300 ] 14016 0.137% 99.939% ( 1300, 1900 ] 65 0.001% 99.940% ( 1900, 2900 ] 6086 0.059% 99.999% ( 2900, 4400 ] 49 0.000% 100.000% ( 4400, 6600 ] 8 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 380000, 570000 ] 2 0.000% 100.000% ( 570000, 860000 ] 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 : 206330 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 : 10267999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10596574968 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 : 590 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32593488 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 : 33332476234 rocksdb.compact.write.bytes COUNT : 33140524138 rocksdb.flush.write.bytes COUNT : 10569381654 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 : 53 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 : 310 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 : 10483994624 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3910656 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 : 33426171614 rocksdb.non.last.level.read.count COUNT : 8079797 rocksdb.block.checksum.compute.count COUNT : 8078670 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.374500 P95 : 3.779867 P99 : 5.940243 P100 : 736465.000000 COUNT : 10267999 SUM : 55442127 rocksdb.compaction.times.micros P50 : 869714.285714 P95 : 4520000.000000 P99 : 13496000.000000 P100 : 16173450.000000 COUNT : 112 SUM : 131678177 rocksdb.compaction.times.cpu_micros P50 : 686000.000000 P95 : 3880000.000000 P99 : 9404000.000000 P100 : 14836462.000000 COUNT : 112 SUM : 113468353 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 : 709.065934 P95 : 1855.000000 P99 : 28270.000000 P100 : 60679.000000 COUNT : 143 SUM : 234513 rocksdb.compaction.outfile.sync.micros P50 : 1036.039604 P95 : 40727.272727 P99 : 72500.000000 P100 : 253421.000000 COUNT : 420 SUM : 3007124 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 103.036145 P95 : 934.500000 P99 : 1960.000000 P100 : 2736.000000 COUNT : 282 SUM : 65743 rocksdb.table.open.io.micros P50 : 1140.740741 P95 : 6668.750000 P99 : 10036.666667 P100 : 15204.000000 COUNT : 590 SUM : 1073706 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.650353 P95 : 7.795058 P99 : 11.845330 P100 : 17247.000000 COUNT : 8076961 SUM : 46942301 rocksdb.read.block.get.micros P50 : 335.462963 P95 : 2855.882353 P99 : 4444.000000 P100 : 10161.000000 COUNT : 1180 SUM : 876294 rocksdb.write.raw.block.micros P50 : 0.513022 P95 : 0.974741 P99 : 2.829139 P100 : 19898.000000 COUNT : 10586339 SUM : 20733956 rocksdb.numfiles.in.singlecompaction P50 : 2.550000 P95 : 5.875000 P99 : 14.250000 P100 : 26.000000 COUNT : 145 SUM : 498 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.556349 P95 : 1182.158947 P99 : 2577.973219 P100 : 736246.000000 COUNT : 199894 SUM : 32604113 rocksdb.sst.read.micros P50 : 1.616952 P95 : 4.685889 P99 : 8.687749 P100 : 17242.000000 COUNT : 8079981 SUM : 30560222 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 : 10267999 SUM : 10596574968 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 : 209139.784946 P95 : 371694.444444 P99 : 797650.000000 P100 : 891009.000000 COUNT : 143 SUM : 30687012 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 : 383 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