[2024-07-12 13:20:56.758822] Starting SPDK v24.09-pre git sha1 719d03c6a / DPDK 24.07.0-rc1 initialization... [2024-07-12 13:20:56.758964] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid674817 ] Set seed to 1720783256755597 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-12 13:20:56.835087] pci_dpdk.c: 37:dpdk_pci_init: *NOTICE*: In-development DPDK 24.07.0-rc1 is used. There is no support for it in SPDK. Enabled only for validation. [2024-07-12 13:20:56.923903] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-12 13:20:56.963775] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-12 13:20:56.963819] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 674817' to capture a snapshot of events at runtime. [2024-07-12 13:20:56.963834] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-12 13:20:56.963848] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-12 13:20:56.963861] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid674817 for offline analysis/debug. [2024-07-12 13:20:56.963957] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 12 13:21:01 2024 CPU: 112 * Intel(R) Xeon(R) Platinum 8180 CPU @ 2.50GHz CPUCache: 39424 KB 2024/07/12-13:21:03 ... thread 0: (1000000,1000000) ops and (350766.9,350766.9) ops/second in (2.850896,2.850896) 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 6/4 378.03 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 350.0 2.34 2.13 12 0.195 0 0 0.0 0.0 L1 4/0 251.74 MB 25.2 0.2 0.2 0.0 0.2 0.2 0.2 1.0 250.8 250.6 1.00 0.97 1 1.005 255K 253 0.0 0.0 L2 3/2 188.85 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 256.0 255.9 0.74 0.71 1 0.738 191K 76 0.0 0.0 L3 12/0 993.38 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.63 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 1185/6 96.94 GB 0.0 0.4 0.4 0.1 1.2 1.2 0.4 1.5 108.0 308.5 4.08 3.81 14 0.292 447K 329 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.2 1.2 0.3 1.5 108.0 308.5 4.08 3.81 14 0.292 447K 329 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.4 0.1 0.4 0.4 0.0 0.0 253.0 252.8 1.74 1.68 2 0.871 447K 329 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 350.0 2.34 2.13 12 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.9 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 413.91 MB/s write, 0.43 GB read, 144.90 MB/s read, 4.1 seconds Interval compaction: 1.23 GB write, 441.50 MB/s write, 0.43 GB read, 154.56 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 148147 Average: 1.9252 StdDev: 5.94 Min: 0 Median: 1.2940 Max: 1277 Percentiles: P50: 1.29 P75: 1.74 P99: 5.49 P99.9: 11.38 P99.99: 26.25 ------------------------------------------------------ [ 0, 1 ] 49615 33.490% 33.490% ####### ( 1, 2 ] 83199 56.160% 89.650% ########### ( 2, 3 ] 8426 5.688% 95.338% # ( 3, 4 ] 3976 2.684% 98.022% # ( 4, 6 ] 1950 1.316% 99.338% ( 6, 10 ] 791 0.534% 99.872% ( 10, 15 ] 159 0.107% 99.979% ( 15, 22 ] 15 0.010% 99.989% ( 22, 34 ] 9 0.006% 99.995% ( 34, 51 ] 2 0.001% 99.997% ( 51, 76 ] 1 0.001% 99.997% ( 76, 110 ] 1 0.001% 99.998% ( 170, 250 ] 10 0.007% 100.005% ( 250, 380 ] 6 0.004% 100.009% ( 380, 580 ] 5 0.003% 100.012% ( 580, 870 ] 1 0.001% 100.013% ( 870, 1300 ] 2 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 25 Average: 196.0800 StdDev: 298.32 Min: 1 Median: 2.7500 Max: 976 Percentiles: P50: 2.75 P75: 363.75 P99: 976.00 P99.9: 976.00 P99.99: 976.00 ------------------------------------------------------ [ 0, 1 ] 6 24.000% 24.000% ##### ( 1, 2 ] 5 20.000% 44.000% #### ( 2, 3 ] 2 8.000% 52.000% ## ( 3, 4 ] 1 4.000% 56.000% # ( 15, 22 ] 1 4.000% 60.000% # ( 34, 51 ] 1 4.000% 64.000% # ( 110, 170 ] 1 4.000% 68.000% # ( 250, 380 ] 2 8.000% 76.000% ## ( 380, 580 ] 2 8.000% 84.000% ## ( 580, 870 ] 3 12.000% 96.000% ## ( 870, 1300 ] 1 4.000% 100.000% # ** Level 2 read latency histogram (micros): Count: 33783 Average: 2.3697 StdDev: 17.27 Min: 1 Median: 1.4996 Max: 2161 Percentiles: P50: 1.50 P75: 1.88 P99: 5.98 P99.9: 11.87 P99.99: 554.78 ------------------------------------------------------ [ 0, 1 ] 5725 16.946% 16.946% ### ( 1, 2 ] 22354 66.169% 83.116% ############# ( 2, 3 ] 2875 8.510% 91.626% ## ( 3, 4 ] 1689 5.000% 96.626% # ( 4, 6 ] 813 2.407% 99.032% ( 6, 10 ] 283 0.838% 99.870% ( 10, 15 ] 30 0.089% 99.959% ( 15, 22 ] 3 0.009% 99.967% ( 22, 34 ] 3 0.009% 99.976% ( 170, 250 ] 1 0.003% 99.979% ( 250, 380 ] 2 0.006% 99.985% ( 380, 580 ] 3 0.009% 99.994% ( 580, 870 ] 1 0.003% 99.997% ( 1900, 2900 ] 2 0.006% 100.003% ** Level 3 read latency histogram (micros): Count: 50 Average: 1390.0200 StdDev: 774.79 Min: 66 Median: 1438.4615 Max: 3204 Percentiles: P50: 1438.46 P75: 2108.33 P99: 3204.00 P99.9: 3204.00 P99.99: 3204.00 ------------------------------------------------------ ( 51, 76 ] 1 2.000% 2.000% ( 170, 250 ] 2 4.000% 6.000% # ( 250, 380 ] 3 6.000% 12.000% # ( 380, 580 ] 2 4.000% 16.000% # ( 580, 870 ] 5 10.000% 26.000% ## ( 870, 1300 ] 9 18.000% 44.000% #### ( 1300, 1900 ] 13 26.000% 70.000% ##### ( 1900, 2900 ] 12 24.000% 94.000% ##### ( 2900, 4400 ] 3 6.000% 100.000% # ** Level 4 read latency histogram (micros): Count: 20 Average: 1535.0500 StdDev: 834.42 Min: 304 Median: 1400.0000 Max: 3371 Percentiles: P50: 1400.00 P75: 1900.00 P99: 3371.00 P99.9: 3371.00 P99.99: 3371.00 ------------------------------------------------------ ( 250, 380 ] 1 5.000% 5.000% # ( 380, 580 ] 2 10.000% 15.000% ## ( 870, 1300 ] 6 30.000% 45.000% ###### ( 1300, 1900 ] 6 30.000% 75.000% ###### ( 1900, 2900 ] 3 15.000% 90.000% ### ( 2900, 4400 ] 2 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.0 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 323.39 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.234 H:M:S, 7.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 344.86 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.234 H:M:S, 8.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-13:21:07 ... thread 0: (1000000,2000000) ops and (324777.9,337272.5) ops/second in (3.079027,5.929923) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/4 1007.43 MB 69.2 0.7 0.0 0.7 2.6 1.8 0.0 1.4 94.2 329.5 8.03 7.43 30 0.268 767K 742 0.0 0.0 L1 2/0 139.92 MB 14.0 0.7 0.7 0.0 0.7 0.7 0.2 1.0 244.7 244.3 2.83 2.74 2 1.416 703K 900 0.0 0.0 L2 5/5 382.03 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 17/17 868.88 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 242.6 242.6 0.77 0.72 1 0.771 189K 0 0.0 0.0 L4 173/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 141.0 141.0 1.19 0.85 1 1.194 170K 0 0.0 0.0 L5 1048/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/26 97.98 GB 0.0 2.0 1.1 0.8 3.8 3.0 1.7 2.1 146.9 285.7 13.60 12.49 36 0.378 2028K 1724 0.0 0.0 Int 0/0 0.00 KB 0.0 2.0 1.1 0.8 3.8 3.0 1.6 2.1 146.9 285.7 13.60 12.49 36 0.378 2028K 1724 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.1 0.8 1.9 1.1 0.0 0.0 239.1 238.9 8.35 7.78 9 0.928 2028K 1724 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 360.2 5.25 4.71 27 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.79 GB write, 634.67 MB/s write, 1.95 GB read, 326.26 MB/s read, 13.6 seconds Interval compaction: 3.79 GB write, 655.02 MB/s write, 1.95 GB read, 336.72 MB/s read, 13.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 429463 Average: 2.1787 StdDev: 6.05 Min: 0 Median: 1.4772 Max: 1277 Percentiles: P50: 1.48 P75: 1.88 P99: 5.84 P99.9: 11.34 P99.99: 14.96 ------------------------------------------------------ [ 0, 1 ] 86769 20.204% 20.204% #### ( 1, 2 ] 268172 62.444% 82.648% ############ ( 2, 3 ] 40651 9.466% 92.113% ## ( 3, 4 ] 19733 4.595% 96.708% # ( 4, 6 ] 10682 2.487% 99.195% ( 6, 10 ] 2884 0.672% 99.867% ( 10, 15 ] 533 0.124% 99.991% ( 15, 22 ] 43 0.010% 100.001% ( 22, 34 ] 12 0.003% 100.004% ( 34, 51 ] 7 0.002% 100.005% ( 51, 76 ] 2 0.000% 100.006% ( 76, 110 ] 1 0.000% 100.006% ( 170, 250 ] 23 0.005% 100.011% ( 250, 380 ] 7 0.002% 100.013% ( 380, 580 ] 15 0.003% 100.017% ( 580, 870 ] 11 0.003% 100.019% ( 870, 1300 ] 4 0.001% 100.020% ** Level 1 read latency histogram (micros): Count: 37807 Average: 3.2363 StdDev: 13.96 Min: 1 Median: 1.8411 Max: 976 Percentiles: P50: 1.84 P75: 2.87 P99: 9.28 P99.9: 15.57 P99.99: 35.86 ------------------------------------------------------ [ 0, 1 ] 1351 3.573% 3.573% # ( 1, 2 ] 20869 55.199% 58.772% ########### ( 2, 3 ] 7065 18.687% 77.459% #### ( 3, 4 ] 4186 11.072% 88.531% ## ( 4, 6 ] 3365 8.900% 97.432% ## ( 6, 10 ] 726 1.920% 99.352% ( 10, 15 ] 207 0.548% 99.899% ( 15, 22 ] 27 0.071% 99.971% ( 22, 34 ] 9 0.024% 99.995% ( 34, 51 ] 2 0.005% 100.000% ( 51, 76 ] 6 0.016% 100.016% ( 76, 110 ] 3 0.008% 100.024% ( 110, 170 ] 9 0.024% 100.048% ( 170, 250 ] 5 0.013% 100.061% ( 250, 380 ] 10 0.026% 100.087% ( 380, 580 ] 7 0.019% 100.106% ( 580, 870 ] 5 0.013% 100.119% ( 870, 1300 ] 2 0.005% 100.124% ** Level 2 read latency histogram (micros): Count: 65039 Average: 2.6379 StdDev: 17.73 Min: 1 Median: 1.5589 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.47 P99.9: 64.27 P99.99: 546.58 ------------------------------------------------------ [ 0, 1 ] 9506 14.616% 14.616% ### ( 1, 2 ] 41180 63.316% 77.932% ############# ( 2, 3 ] 7354 11.307% 89.239% ## ( 3, 4 ] 3756 5.775% 95.014% # ( 4, 6 ] 2305 3.544% 98.558% # ( 6, 10 ] 780 1.199% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.915% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 186690 Average: 3.3615 StdDev: 31.20 Min: 0 Median: 1.6690 Max: 3204 Percentiles: P50: 1.67 P75: 2.29 P99: 9.03 P99.9: 188.61 P99.99: 554.70 ------------------------------------------------------ [ 0, 1 ] 16535 8.857% 8.857% ## ( 1, 2 ] 114814 61.500% 70.357% ############ ( 2, 3 ] 30355 16.260% 86.616% ### ( 3, 4 ] 12647 6.774% 93.391% # ( 4, 6 ] 7896 4.229% 97.620% # ( 6, 10 ] 3402 1.822% 99.442% ( 10, 15 ] 449 0.241% 99.683% ( 15, 22 ] 93 0.050% 99.733% ( 22, 34 ] 76 0.041% 99.773% ( 34, 51 ] 8 0.004% 99.778% ( 51, 76 ] 101 0.054% 99.832% ( 76, 110 ] 37 0.020% 99.852% ( 110, 170 ] 71 0.038% 99.890% ( 170, 250 ] 83 0.044% 99.934% ( 250, 380 ] 79 0.042% 99.976% ( 380, 580 ] 29 0.016% 99.992% ( 580, 870 ] 11 0.006% 99.998% ( 870, 1300 ] 9 0.005% 100.003% ( 1300, 1900 ] 19 0.010% 100.013% ( 1900, 2900 ] 14 0.007% 100.020% ( 2900, 4400 ] 4 0.002% 100.022% ** Level 4 read latency histogram (micros): Count: 305 Average: 103.5279 StdDev: 435.28 Min: 1 Median: 1.5310 Max: 3371 Percentiles: P50: 1.53 P75: 3.88 P99: 2550.00 P99.9: 3371.00 P99.99: 3371.00 ------------------------------------------------------ [ 0, 1 ] 84 27.541% 27.541% ###### ( 1, 2 ] 129 42.295% 69.836% ######## ( 2, 3 ] 14 4.590% 74.426% # ( 3, 4 ] 2 0.656% 75.082% ( 4, 6 ] 4 1.311% 76.393% ( 6, 10 ] 48 15.738% 92.131% ### ( 10, 15 ] 4 1.311% 93.443% ( 250, 380 ] 1 0.328% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 870, 1300 ] 6 1.967% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 3 0.984% 99.344% ( 2900, 4400 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 438.3000 StdDev: 436.57 Min: 53 Median: 276.0000 Max: 1403 Percentiles: P50: 276.00 P75: 580.00 P99: 1403.00 P99.9: 1403.00 P99.99: 1403.00 ------------------------------------------------------ ( 51, 76 ] 4 20.000% 20.000% #### ( 76, 110 ] 1 5.000% 25.000% # ( 110, 170 ] 1 5.000% 30.000% # ( 170, 250 ] 3 15.000% 45.000% ### ( 250, 380 ] 5 25.000% 70.000% ##### ( 380, 580 ] 1 5.000% 75.000% # ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 3 15.000% 95.000% ### ( 1300, 1900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 321.51 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.602 H:M:S, 9.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.64 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.368 H:M:S, 11.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/12-13:21:09 ... thread 0: (1000000,3000000) ops and (355752.6,343215.5) ops/second in (2.810942,8.740865) 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 1.91 GB 18.9 1.5 0.0 1.5 4.3 2.8 0.0 1.6 116.0 324.6 13.58 12.64 47 0.289 1599K 1574 0.0 0.0 L1 2/2 139.92 MB 0.0 0.7 0.7 0.0 0.7 0.7 0.2 1.0 244.7 244.3 2.83 2.74 2 1.416 703K 900 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 17/0 731.93 MB 0.7 1.4 0.6 0.8 1.4 0.6 0.3 2.5 230.3 229.7 6.24 5.86 5 1.249 1460K 3858 0.0 0.0 L4 169/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 141.0 141.0 1.19 0.85 1 1.194 170K 0 0.0 0.0 L5 1056/0 86.62 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 1257/12 98.90 GB 0.0 4.0 1.5 2.4 6.7 4.3 2.9 2.4 165.2 280.0 24.62 22.83 57 0.432 4130K 6414 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.5 2.4 6.7 4.3 2.8 2.4 165.2 280.0 24.62 22.83 57 0.432 4130K 6414 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.5 2.4 4.0 1.5 0.0 0.0 241.1 240.8 16.87 15.88 16 1.054 4130K 6414 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 365.4 7.76 6.95 41 0.189 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.7 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.73 GB write, 771.93 MB/s write, 3.97 GB read, 455.31 MB/s read, 24.6 seconds Interval compaction: 6.73 GB write, 788.72 MB/s write, 3.97 GB read, 465.21 MB/s read, 24.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 658755 Average: 2.1530 StdDev: 7.88 Min: 0 Median: 1.4509 Max: 3162 Percentiles: P50: 1.45 P75: 1.85 P99: 5.76 P99.9: 12.02 P99.99: 34.26 ------------------------------------------------------ [ 0, 1 ] 144205 21.891% 21.891% #### ( 1, 2 ] 410686 62.343% 84.233% ############ ( 2, 3 ] 57509 8.730% 92.963% ## ( 3, 4 ] 27380 4.156% 97.120% # ( 4, 6 ] 14090 2.139% 99.258% ( 6, 10 ] 3882 0.589% 99.848% ( 10, 15 ] 854 0.130% 99.977% ( 15, 22 ] 66 0.010% 99.987% ( 22, 34 ] 18 0.003% 99.990% ( 34, 51 ] 8 0.001% 99.991% ( 51, 76 ] 23 0.003% 99.995% ( 76, 110 ] 6 0.001% 99.996% ( 110, 170 ] 21 0.003% 99.999% ( 170, 250 ] 45 0.007% 100.006% ( 250, 380 ] 12 0.002% 100.008% ( 380, 580 ] 28 0.004% 100.012% ( 580, 870 ] 16 0.002% 100.014% ( 870, 1300 ] 9 0.001% 100.016% ( 1300, 1900 ] 1 0.000% 100.016% ( 2900, 4400 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 152164 Average: 2.6398 StdDev: 8.22 Min: 1 Median: 1.6683 Max: 1078 Percentiles: P50: 1.67 P75: 2.28 P99: 7.44 P99.9: 12.92 P99.99: 14.84 ------------------------------------------------------ [ 0, 1 ] 12110 7.959% 7.959% ## ( 1, 2 ] 95723 62.908% 70.866% ############# ( 2, 3 ] 22123 14.539% 85.405% ### ( 3, 4 ] 11998 7.885% 93.290% ## ( 4, 6 ] 8038 5.282% 98.573% # ( 6, 10 ] 1812 1.191% 99.763% ( 10, 15 ] 356 0.234% 99.997% ( 15, 22 ] 32 0.021% 100.018% ( 22, 34 ] 10 0.007% 100.025% ( 34, 51 ] 3 0.002% 100.027% ( 51, 76 ] 9 0.006% 100.033% ( 76, 110 ] 4 0.003% 100.035% ( 110, 170 ] 16 0.011% 100.046% ( 170, 250 ] 17 0.011% 100.057% ( 250, 380 ] 20 0.013% 100.070% ( 380, 580 ] 8 0.005% 100.076% ( 580, 870 ] 5 0.003% 100.079% ( 870, 1300 ] 3 0.002% 100.081% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 191544 Average: 3.4214 StdDev: 31.56 Min: 0 Median: 1.6704 Max: 3204 Percentiles: P50: 1.67 P75: 2.29 P99: 9.05 P99.9: 209.96 P99.99: 649.70 ------------------------------------------------------ [ 0, 1 ] 16877 8.811% 8.811% ## ( 1, 2 ] 117686 61.441% 70.252% ############ ( 2, 3 ] 31217 16.298% 86.549% ### ( 3, 4 ] 13099 6.839% 93.388% # ( 4, 6 ] 8123 4.241% 97.629% # ( 6, 10 ] 3442 1.797% 99.426% ( 10, 15 ] 467 0.244% 99.670% ( 15, 22 ] 97 0.051% 99.720% ( 22, 34 ] 78 0.041% 99.761% ( 34, 51 ] 9 0.005% 99.766% ( 51, 76 ] 101 0.053% 99.818% ( 76, 110 ] 38 0.020% 99.838% ( 110, 170 ] 73 0.038% 99.876% ( 170, 250 ] 91 0.048% 99.924% ( 250, 380 ] 83 0.043% 99.967% ( 380, 580 ] 40 0.021% 99.988% ( 580, 870 ] 16 0.008% 99.996% ( 870, 1300 ] 12 0.006% 100.003% ( 1300, 1900 ] 19 0.010% 100.013% ( 1900, 2900 ] 14 0.007% 100.020% ( 2900, 4400 ] 4 0.002% 100.022% ** Level 4 read latency histogram (micros): Count: 305 Average: 103.5279 StdDev: 435.28 Min: 1 Median: 1.5310 Max: 3371 Percentiles: P50: 1.53 P75: 3.88 P99: 2550.00 P99.9: 3371.00 P99.99: 3371.00 ------------------------------------------------------ [ 0, 1 ] 84 27.541% 27.541% ###### ( 1, 2 ] 129 42.295% 69.836% ######## ( 2, 3 ] 14 4.590% 74.426% # ( 3, 4 ] 2 0.656% 75.082% ( 4, 6 ] 4 1.311% 76.393% ( 6, 10 ] 48 15.738% 92.131% ### ( 10, 15 ] 4 1.311% 93.443% ( 250, 380 ] 1 0.328% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 870, 1300 ] 6 1.967% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 3 0.984% 99.344% ( 2900, 4400 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 535.3167 StdDev: 471.69 Min: 53 Median: 344.5455 Max: 1891 Percentiles: P50: 344.55 P75: 812.00 P99: 1828.00 P99.9: 1891.00 P99.99: 1891.00 ------------------------------------------------------ ( 51, 76 ] 9 15.000% 15.000% ### ( 76, 110 ] 2 3.333% 18.333% # ( 110, 170 ] 3 5.000% 23.333% # ( 170, 250 ] 8 13.333% 36.667% ### ( 250, 380 ] 11 18.333% 55.000% #### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 5 8.333% 76.667% ## ( 870, 1300 ] 9 15.000% 91.667% ### ( 1300, 1900 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 8.9 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.51 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.766 H:M:S, 8.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.13 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.164 H:M:S, 5.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/12-13:21:13 ... thread 0: (1000000,4000000) ops and (315421.0,335817.5) ops/second in (3.170366,11.911231) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/14 2.89 GB 94.4 2.3 0.0 2.3 6.1 3.8 0.0 1.6 123.8 322.5 19.33 18.04 65 0.297 2430K 2397 0.0 0.0 L1 2/2 139.92 MB 0.0 0.7 0.7 0.0 0.7 0.7 0.2 1.0 244.7 244.3 2.83 2.74 2 1.416 703K 900 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.6 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 17/0 731.93 MB 0.7 1.4 0.6 0.8 1.4 0.6 0.3 2.5 230.3 229.7 6.24 5.86 5 1.249 1460K 3858 0.0 0.0 L4 169/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 141.0 141.0 1.19 0.85 1 1.194 170K 0 0.0 0.0 L5 1056/0 86.62 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 1263/16 99.88 GB 0.0 4.8 1.5 3.2 8.5 5.3 2.9 2.3 160.9 287.1 30.37 28.23 75 0.405 4961K 7237 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 1.5 3.2 8.5 5.3 2.8 2.3 160.9 287.1 30.37 28.23 75 0.405 4961K 7237 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.8 1.5 3.2 4.8 1.5 0.0 0.0 246.2 245.8 19.84 18.80 19 1.044 4961K 7237 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 365.0 10.53 9.43 56 0.188 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.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.52 GB write, 720.60 MB/s write, 4.77 GB read, 403.71 MB/s read, 30.4 seconds Interval compaction: 8.52 GB write, 732.11 MB/s write, 4.77 GB read, 410.16 MB/s read, 30.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 13, interval: 15 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1097974 Average: 2.1566 StdDev: 7.01 Min: 0 Median: 1.4669 Max: 3162 Percentiles: P50: 1.47 P75: 1.85 P99: 5.72 P99.9: 11.39 P99.99: 15.15 ------------------------------------------------------ [ 0, 1 ] 217509 19.810% 19.810% #### ( 1, 2 ] 709974 64.662% 84.472% ############# ( 2, 3 ] 97680 8.896% 93.369% ## ( 3, 4 ] 43786 3.988% 97.356% # ( 4, 6 ] 20948 1.908% 99.264% ( 6, 10 ] 6600 0.601% 99.865% ( 10, 15 ] 1367 0.125% 99.990% ( 15, 22 ] 106 0.010% 100.000% ( 22, 34 ] 26 0.002% 100.002% ( 34, 51 ] 14 0.001% 100.003% ( 51, 76 ] 46 0.004% 100.007% ( 76, 110 ] 18 0.002% 100.009% ( 110, 170 ] 34 0.003% 100.012% ( 170, 250 ] 81 0.007% 100.020% ( 250, 380 ] 26 0.002% 100.022% ( 380, 580 ] 39 0.004% 100.026% ( 580, 870 ] 18 0.002% 100.027% ( 870, 1300 ] 15 0.001% 100.029% ( 1300, 1900 ] 1 0.000% 100.029% ( 2900, 4400 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 152164 Average: 2.6398 StdDev: 8.22 Min: 1 Median: 1.6683 Max: 1078 Percentiles: P50: 1.67 P75: 2.28 P99: 7.44 P99.9: 12.92 P99.99: 14.84 ------------------------------------------------------ [ 0, 1 ] 12110 7.959% 7.959% ## ( 1, 2 ] 95723 62.908% 70.866% ############# ( 2, 3 ] 22123 14.539% 85.405% ### ( 3, 4 ] 11998 7.885% 93.290% ## ( 4, 6 ] 8038 5.282% 98.573% # ( 6, 10 ] 1812 1.191% 99.763% ( 10, 15 ] 356 0.234% 99.997% ( 15, 22 ] 32 0.021% 100.018% ( 22, 34 ] 10 0.007% 100.025% ( 34, 51 ] 3 0.002% 100.027% ( 51, 76 ] 9 0.006% 100.033% ( 76, 110 ] 4 0.003% 100.035% ( 110, 170 ] 16 0.011% 100.046% ( 170, 250 ] 17 0.011% 100.057% ( 250, 380 ] 20 0.013% 100.070% ( 380, 580 ] 8 0.005% 100.076% ( 580, 870 ] 5 0.003% 100.079% ( 870, 1300 ] 3 0.002% 100.081% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 191544 Average: 3.4214 StdDev: 31.56 Min: 0 Median: 1.6704 Max: 3204 Percentiles: P50: 1.67 P75: 2.29 P99: 9.05 P99.9: 209.96 P99.99: 649.70 ------------------------------------------------------ [ 0, 1 ] 16877 8.811% 8.811% ## ( 1, 2 ] 117686 61.441% 70.252% ############ ( 2, 3 ] 31217 16.298% 86.549% ### ( 3, 4 ] 13099 6.839% 93.388% # ( 4, 6 ] 8123 4.241% 97.629% # ( 6, 10 ] 3442 1.797% 99.426% ( 10, 15 ] 467 0.244% 99.670% ( 15, 22 ] 97 0.051% 99.720% ( 22, 34 ] 78 0.041% 99.761% ( 34, 51 ] 9 0.005% 99.766% ( 51, 76 ] 101 0.053% 99.818% ( 76, 110 ] 38 0.020% 99.838% ( 110, 170 ] 73 0.038% 99.876% ( 170, 250 ] 91 0.048% 99.924% ( 250, 380 ] 83 0.043% 99.967% ( 380, 580 ] 40 0.021% 99.988% ( 580, 870 ] 16 0.008% 99.996% ( 870, 1300 ] 12 0.006% 100.003% ( 1300, 1900 ] 19 0.010% 100.013% ( 1900, 2900 ] 14 0.007% 100.020% ( 2900, 4400 ] 4 0.002% 100.022% ** Level 4 read latency histogram (micros): Count: 305 Average: 103.5279 StdDev: 435.28 Min: 1 Median: 1.5310 Max: 3371 Percentiles: P50: 1.53 P75: 3.88 P99: 2550.00 P99.9: 3371.00 P99.99: 3371.00 ------------------------------------------------------ [ 0, 1 ] 84 27.541% 27.541% ###### ( 1, 2 ] 129 42.295% 69.836% ######## ( 2, 3 ] 14 4.590% 74.426% # ( 3, 4 ] 2 0.656% 75.082% ( 4, 6 ] 4 1.311% 76.393% ( 6, 10 ] 48 15.738% 92.131% ### ( 10, 15 ] 4 1.311% 93.443% ( 250, 380 ] 1 0.328% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 870, 1300 ] 6 1.967% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 3 0.984% 99.344% ( 2900, 4400 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 535.3167 StdDev: 471.69 Min: 53 Median: 344.5455 Max: 1891 Percentiles: P50: 344.55 P75: 812.00 P99: 1828.00 P99.9: 1891.00 P99.99: 1891.00 ------------------------------------------------------ ( 51, 76 ] 9 15.000% 15.000% ### ( 76, 110 ] 2 3.333% 18.333% # ( 110, 170 ] 3 5.000% 23.333% # ( 170, 250 ] 8 13.333% 36.667% ### ( 250, 380 ] 11 18.333% 55.000% #### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 5 8.333% 76.667% ## ( 870, 1300 ] 9 15.000% 91.667% ### ( 1300, 1900 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 12.1 total, 3.2 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 325.25 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.224 H:M:S, 10.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.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:0.457 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-13:21:18 ... thread 0: (1000000,5000000) ops and (179457.5,285982.6) ops/second in (5.572349,17.483580) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/6 2.09 GB 81.8 3.3 0.0 3.3 8.0 4.7 0.0 1.7 130.5 314.1 26.06 23.86 83 0.314 3454K 3391 0.0 0.0 L1 4/0 212.04 MB 21.2 2.5 2.4 0.1 2.5 2.4 0.2 1.0 242.5 240.8 10.70 10.31 3 3.568 2635K 17K 0.0 0.0 L2 12/12 1.20 GB 0.0 0.2 0.1 0.1 0.2 0.1 2.3 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 26/8 1.15 GB 0.7 2.1 1.0 1.1 2.1 1.0 0.3 2.1 193.7 193.1 10.99 8.86 9 1.221 2162K 7119 0.0 0.0 L4 169/0 9.53 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 141.0 141.0 1.19 0.85 1 1.194 170K 0 0.0 0.0 L5 1056/0 86.62 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 1278/26 100.78 GB 0.0 8.3 3.7 4.6 12.9 8.3 4.5 2.8 170.7 266.4 49.72 44.63 98 0.507 8618K 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.3 3.7 4.6 12.9 8.3 4.4 2.8 170.7 266.4 49.72 44.63 98 0.507 8618K 28K 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 8.3 3.7 4.6 8.3 3.7 0.0 0.0 235.4 234.6 36.05 32.91 28 1.287 8618K 28K 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 350.2 13.67 11.72 70 0.195 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 17.7 total, 17.5 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: 12.94 GB write, 749.43 MB/s write, 8.29 GB read, 480.18 MB/s read, 49.7 seconds Interval compaction: 12.94 GB write, 757.58 MB/s write, 8.29 GB read, 485.41 MB/s read, 49.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 16, interval: 26 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1644921 Average: 2.2159 StdDev: 10.65 Min: 0 Median: 1.4737 Max: 4113 Percentiles: P50: 1.47 P75: 1.86 P99: 5.79 P99.9: 11.47 P99.99: 62.80 ------------------------------------------------------ [ 0, 1 ] 318283 19.349% 19.349% #### ( 1, 2 ] 1064444 64.711% 84.060% ############# ( 2, 3 ] 145972 8.874% 92.934% ## ( 3, 4 ] 67286 4.091% 97.025% # ( 4, 6 ] 36223 2.202% 99.227% ( 6, 10 ] 10560 0.642% 99.869% ( 10, 15 ] 1731 0.105% 99.974% ( 15, 22 ] 150 0.009% 99.983% ( 22, 34 ] 34 0.002% 99.986% ( 34, 51 ] 16 0.001% 99.987% ( 51, 76 ] 124 0.008% 99.994% ( 76, 110 ] 53 0.003% 99.997% ( 110, 170 ] 102 0.006% 100.003% ( 170, 250 ] 170 0.010% 100.014% ( 250, 380 ] 57 0.003% 100.017% ( 380, 580 ] 72 0.004% 100.022% ( 580, 870 ] 30 0.002% 100.023% ( 870, 1300 ] 22 0.001% 100.025% ( 1300, 1900 ] 6 0.000% 100.025% ( 1900, 2900 ] 4 0.000% 100.025% ( 2900, 4400 ] 7 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 462511 Average: 3.7899 StdDev: 52.04 Min: 0 Median: 1.8003 Max: 7110 Percentiles: P50: 1.80 P75: 2.78 P99: 7.96 P99.9: 12.38 P99.99: 14.26 ------------------------------------------------------ [ 0, 1 ] 26088 5.641% 5.641% # ( 1, 2 ] 256374 55.431% 61.071% ########### ( 2, 3 ] 82885 17.921% 78.992% #### ( 3, 4 ] 47123 10.189% 89.181% ## ( 4, 6 ] 41906 9.061% 98.241% ## ( 6, 10 ] 7146 1.545% 99.786% ( 10, 15 ] 1106 0.239% 100.025% ( 15, 22 ] 87 0.019% 100.044% ( 22, 34 ] 20 0.004% 100.048% ( 34, 51 ] 4 0.001% 100.049% ( 51, 76 ] 54 0.012% 100.061% ( 76, 110 ] 20 0.004% 100.065% ( 110, 170 ] 49 0.011% 100.076% ( 170, 250 ] 61 0.013% 100.089% ( 250, 380 ] 81 0.018% 100.107% ( 380, 580 ] 120 0.026% 100.133% ( 580, 870 ] 74 0.016% 100.149% ( 870, 1300 ] 27 0.006% 100.154% ( 1300, 1900 ] 16 0.003% 100.158% ( 1900, 2900 ] 22 0.005% 100.163% ( 2900, 4400 ] 46 0.010% 100.173% ( 4400, 6600 ] 7 0.002% 100.174% ( 6600, 9900 ] 3 0.001% 100.175% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 316278 Average: 4.8678 StdDev: 80.67 Min: 0 Median: 1.7754 Max: 15213 Percentiles: P50: 1.78 P75: 2.67 P99: 9.42 P99.9: 337.57 P99.99: 729.85 ------------------------------------------------------ [ 0, 1 ] 19318 6.108% 6.108% # ( 1, 2 ] 179026 56.604% 62.712% ########### ( 2, 3 ] 57773 18.267% 80.978% #### ( 3, 4 ] 28472 9.002% 89.981% ## ( 4, 6 ] 22793 7.207% 97.187% # ( 6, 10 ] 6708 2.121% 99.308% ( 10, 15 ] 1006 0.318% 99.626% ( 15, 22 ] 140 0.044% 99.671% ( 22, 34 ] 84 0.027% 99.697% ( 34, 51 ] 11 0.003% 99.701% ( 51, 76 ] 109 0.034% 99.735% ( 76, 110 ] 53 0.017% 99.752% ( 110, 170 ] 121 0.038% 99.790% ( 170, 250 ] 181 0.057% 99.847% ( 250, 380 ] 249 0.079% 99.926% ( 380, 580 ] 161 0.051% 99.977% ( 580, 870 ] 82 0.026% 100.003% ( 870, 1300 ] 35 0.011% 100.014% ( 1300, 1900 ] 25 0.008% 100.022% ( 1900, 2900 ] 23 0.007% 100.029% ( 2900, 4400 ] 36 0.011% 100.040% ( 4400, 6600 ] 10 0.003% 100.044% ( 6600, 9900 ] 8 0.003% 100.046% ( 9900, 14000 ] 2 0.001% 100.047% ( 14000, 22000 ] 1 0.000% 100.047% ** Level 4 read latency histogram (micros): Count: 305 Average: 103.5279 StdDev: 435.28 Min: 1 Median: 1.5310 Max: 3371 Percentiles: P50: 1.53 P75: 3.88 P99: 2550.00 P99.9: 3371.00 P99.99: 3371.00 ------------------------------------------------------ [ 0, 1 ] 84 27.541% 27.541% ###### ( 1, 2 ] 129 42.295% 69.836% ######## ( 2, 3 ] 14 4.590% 74.426% # ( 3, 4 ] 2 0.656% 75.082% ( 4, 6 ] 4 1.311% 76.393% ( 6, 10 ] 48 15.738% 92.131% ### ( 10, 15 ] 4 1.311% 93.443% ( 250, 380 ] 1 0.328% 93.770% ( 380, 580 ] 2 0.656% 94.426% ( 870, 1300 ] 6 1.967% 96.393% ( 1300, 1900 ] 6 1.967% 98.361% ( 1900, 2900 ] 3 0.984% 99.344% ( 2900, 4400 ] 2 0.656% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 535.3167 StdDev: 471.69 Min: 53 Median: 344.5455 Max: 1891 Percentiles: P50: 344.55 P75: 812.00 P99: 1828.00 P99.9: 1891.00 P99.99: 1891.00 ------------------------------------------------------ ( 51, 76 ] 9 15.000% 15.000% ### ( 76, 110 ] 2 3.333% 18.333% # ( 110, 170 ] 3 5.000% 23.333% # ( 170, 250 ] 8 13.333% 36.667% ### ( 250, 380 ] 11 18.333% 55.000% #### ( 380, 580 ] 8 13.333% 68.333% ### ( 580, 870 ] 5 8.333% 76.667% ## ( 870, 1300 ] 9 15.000% 91.667% ### ( 1300, 1900 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 17.7 total, 5.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 278.40 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.897 H:M:S, 22.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 176.62 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.673 H:M:S, 48.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 1 2024/07/12-13:21:22 ... thread 0: (1000000,6000000) ops and (240016.1,277136.7) ops/second in (4.166388,21.649968) 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/8 3.07 GB 257.3 5.3 0.0 5.3 10.9 5.6 0.0 1.9 141.4 292.5 38.30 34.00 99 0.387 5499K 11K 0.0 0.0 L1 4/0 212.04 MB 21.2 2.5 2.4 0.1 2.5 2.4 0.2 1.0 242.5 240.8 10.70 10.31 3 3.568 2635K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.3 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 21/0 964.58 MB 1.0 3.7 2.2 1.5 3.7 2.2 0.3 1.7 176.9 176.3 21.57 16.12 15 1.438 3875K 13K 0.0 0.0 L4 181/0 9.57 GB 1.0 1.6 1.5 0.1 1.6 1.5 0.9 1.1 131.7 131.5 12.64 7.48 27 0.468 1627K 1107 0.0 0.0 L5 1072/0 87.97 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1291/8 101.75 GB 0.0 13.4 6.2 7.1 19.0 11.9 5.9 3.4 163.0 231.4 83.99 68.66 146 0.575 13M 44K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.4 6.2 7.1 19.0 11.9 5.8 3.4 163.0 231.4 83.99 68.66 146 0.575 13M 44K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 13.4 6.2 7.1 13.3 6.2 0.0 0.0 205.9 205.3 66.45 54.43 63 1.055 13M 44K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 330.5 17.53 14.23 83 0.211 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): 21.8 total, 21.7 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.98 GB write, 889.81 MB/s write, 13.36 GB read, 626.57 MB/s read, 84.0 seconds Interval compaction: 18.98 GB write, 897.63 MB/s write, 13.36 GB read, 632.08 MB/s read, 84.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 33, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 33, interval: 43 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2101562 Average: 2.3735 StdDev: 20.69 Min: 0 Median: 1.5096 Max: 12715 Percentiles: P50: 1.51 P75: 1.90 P99: 5.97 P99.9: 11.88 P99.99: 56.43 ------------------------------------------------------ [ 0, 1 ] 368175 17.519% 17.519% #### ( 1, 2 ] 1339601 63.743% 81.262% ############# ( 2, 3 ] 209452 9.966% 91.229% ## ( 3, 4 ] 100640 4.789% 96.018% # ( 4, 6 ] 63577 3.025% 99.043% # ( 6, 10 ] 17063 0.812% 99.855% ( 10, 15 ] 2533 0.121% 99.975% ( 15, 22 ] 212 0.010% 99.985% ( 22, 34 ] 50 0.002% 99.988% ( 34, 51 ] 19 0.001% 99.989% ( 51, 76 ] 142 0.007% 99.995% ( 76, 110 ] 61 0.003% 99.998% ( 110, 170 ] 114 0.005% 100.004% ( 170, 250 ] 192 0.009% 100.013% ( 250, 380 ] 92 0.004% 100.017% ( 380, 580 ] 119 0.006% 100.023% ( 580, 870 ] 48 0.002% 100.025% ( 870, 1300 ] 43 0.002% 100.027% ( 1300, 1900 ] 18 0.001% 100.028% ( 1900, 2900 ] 10 0.000% 100.029% ( 2900, 4400 ] 20 0.001% 100.029% ( 4400, 6600 ] 4 0.000% 100.030% ( 6600, 9900 ] 3 0.000% 100.030% ( 9900, 14000 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 610811 Average: 4.6679 StdDev: 73.37 Min: 0 Median: 1.8271 Max: 8396 Percentiles: P50: 1.83 P75: 2.84 P99: 8.42 P99.9: 13.76 P99.99: 29.41 ------------------------------------------------------ [ 0, 1 ] 29482 4.827% 4.827% # ( 1, 2 ] 333621 54.619% 59.446% ########### ( 2, 3 ] 113725 18.619% 78.065% #### ( 3, 4 ] 63773 10.441% 88.505% ## ( 4, 6 ] 57579 9.427% 97.932% ## ( 6, 10 ] 10797 1.768% 99.700% ( 10, 15 ] 1628 0.267% 99.966% ( 15, 22 ] 127 0.021% 99.987% ( 22, 34 ] 29 0.005% 99.992% ( 34, 51 ] 6 0.001% 99.993% ( 51, 76 ] 56 0.009% 100.002% ( 76, 110 ] 20 0.003% 100.005% ( 110, 170 ] 53 0.009% 100.014% ( 170, 250 ] 80 0.013% 100.027% ( 250, 380 ] 128 0.021% 100.048% ( 380, 580 ] 202 0.033% 100.081% ( 580, 870 ] 128 0.021% 100.102% ( 870, 1300 ] 55 0.009% 100.111% ( 1300, 1900 ] 53 0.009% 100.120% ( 1900, 2900 ] 88 0.014% 100.134% ( 2900, 4400 ] 100 0.016% 100.150% ( 4400, 6600 ] 24 0.004% 100.154% ( 6600, 9900 ] 9 0.001% 100.156% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 721492 Average: 4.2491 StdDev: 70.11 Min: 0 Median: 1.8632 Max: 15213 Percentiles: P50: 1.86 P75: 2.88 P99: 8.60 P99.9: 14.73 P99.99: 122.64 ------------------------------------------------------ [ 0, 1 ] 26396 3.659% 3.659% # ( 1, 2 ] 387318 53.683% 57.341% ########### ( 2, 3 ] 145199 20.125% 77.466% #### ( 3, 4 ] 78246 10.845% 88.311% ## ( 4, 6 ] 68713 9.524% 97.835% ## ( 6, 10 ] 12909 1.789% 99.624% ( 10, 15 ] 2104 0.292% 99.916% ( 15, 22 ] 223 0.031% 99.947% ( 22, 34 ] 102 0.014% 99.961% ( 34, 51 ] 14 0.002% 99.963% ( 51, 76 ] 114 0.016% 99.979% ( 76, 110 ] 53 0.007% 99.986% ( 110, 170 ] 137 0.019% 100.005% ( 170, 250 ] 194 0.027% 100.032% ( 250, 380 ] 274 0.038% 100.070% ( 380, 580 ] 186 0.026% 100.096% ( 580, 870 ] 99 0.014% 100.109% ( 870, 1300 ] 45 0.006% 100.116% ( 1300, 1900 ] 35 0.005% 100.120% ( 1900, 2900 ] 35 0.005% 100.125% ( 2900, 4400 ] 81 0.011% 100.137% ( 4400, 6600 ] 16 0.002% 100.139% ( 6600, 9900 ] 11 0.002% 100.140% ( 9900, 14000 ] 6 0.001% 100.141% ( 14000, 22000 ] 1 0.000% 100.141% ** Level 4 read latency histogram (micros): Count: 27450 Average: 79.2360 StdDev: 370.56 Min: 0 Median: 1.9454 Max: 8451 Percentiles: P50: 1.95 P75: 3.29 P99: 1857.14 P99.9: 4308.73 P99.99: 6225.50 ------------------------------------------------------ [ 0, 1 ] 1096 3.993% 3.993% # ( 1, 2 ] 13358 48.663% 52.656% ########## ( 2, 3 ] 5243 19.100% 71.756% #### ( 3, 4 ] 3059 11.144% 82.900% ## ( 4, 6 ] 1590 5.792% 88.692% # ( 6, 10 ] 621 2.262% 90.954% ( 10, 15 ] 82 0.299% 91.253% ( 15, 22 ] 11 0.040% 91.293% ( 22, 34 ] 2 0.007% 91.301% ( 34, 51 ] 9 0.033% 91.333% ( 51, 76 ] 20 0.073% 91.406% ( 76, 110 ] 24 0.087% 91.494% ( 110, 170 ] 101 0.368% 91.862% ( 170, 250 ] 158 0.576% 92.437% ( 250, 380 ] 404 1.472% 93.909% ( 380, 580 ] 503 1.832% 95.741% ( 580, 870 ] 476 1.734% 97.475% ( 870, 1300 ] 308 1.122% 98.597% ( 1300, 1900 ] 119 0.434% 99.031% ( 1900, 2900 ] 139 0.506% 99.537% ( 2900, 4400 ] 106 0.386% 99.923% ( 4400, 6600 ] 22 0.080% 100.004% ( 6600, 9900 ] 3 0.011% 100.015% ** Level 5 read latency histogram (micros): Count: 140 Average: 699.5071 StdDev: 639.51 Min: 49 Median: 443.1579 Max: 3300 Percentiles: P50: 443.16 P75: 1063.50 P99: 3300.00 P99.9: 3300.00 P99.99: 3300.00 ------------------------------------------------------ ( 34, 51 ] 1 0.714% 0.714% ( 51, 76 ] 11 7.857% 8.571% ## ( 76, 110 ] 4 2.857% 11.429% # ( 110, 170 ] 8 5.714% 17.143% # ( 170, 250 ] 14 10.000% 27.143% ## ( 250, 380 ] 26 18.571% 45.714% #### ( 380, 580 ] 19 13.571% 59.286% ### ( 580, 870 ] 13 9.286% 68.571% ## ( 870, 1300 ] 20 14.286% 82.857% ### ( 1300, 1900 ] 16 11.429% 94.286% ## ( 1900, 2900 ] 6 4.286% 98.571% # ( 2900, 4400 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 21.8 total, 4.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 270.35 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:5.024 H:M:S, 23.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 236.22 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.128 H:M:S, 27.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-13:21:25 ... thread 0: (1000000,7000000) ops and (333531.1,283996.5) ops/second in (2.998221,24.648189) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/14 3.99 GB 37.8 6.1 0.0 6.1 12.7 6.6 0.0 1.9 142.3 295.8 43.83 39.22 115 0.381 6331K 12K 0.0 0.0 L1 4/4 212.04 MB 0.0 2.5 2.4 0.1 2.5 2.4 0.2 1.0 242.5 240.8 10.70 10.31 3 3.568 2635K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.3 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 21/0 964.58 MB 1.0 3.7 2.2 1.5 3.7 2.2 0.3 1.7 176.9 176.3 21.57 16.12 15 1.438 3875K 13K 0.0 0.0 L4 181/0 9.57 GB 1.0 1.6 1.5 0.1 1.6 1.5 0.9 1.1 131.7 131.5 12.64 7.48 27 0.468 1627K 1107 0.0 0.0 L5 1072/0 87.97 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1295/18 102.67 GB 0.0 14.2 6.2 7.9 20.7 12.8 5.9 3.1 162.0 236.8 89.52 73.88 162 0.553 14M 44K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.2 6.2 7.9 20.7 12.8 5.8 3.1 162.0 236.8 89.52 73.88 162 0.553 14M 44K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.2 6.2 7.9 14.1 6.2 0.0 0.0 209.0 208.3 69.41 57.33 66 1.052 14M 44K 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 335.3 20.10 16.55 96 0.209 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): 24.8 total, 24.7 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.70 GB write, 853.39 MB/s write, 14.16 GB read, 583.92 MB/s read, 89.5 seconds Interval compaction: 20.70 GB write, 859.97 MB/s write, 14.16 GB read, 588.42 MB/s read, 89.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 37, interval: 47 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2415432 Average: 2.3543 StdDev: 19.63 Min: 0 Median: 1.5002 Max: 12715 Percentiles: P50: 1.50 P75: 1.89 P99: 5.96 P99.9: 12.19 P99.99: 97.18 ------------------------------------------------------ [ 0, 1 ] 434990 18.009% 18.009% #### ( 1, 2 ] 1544861 63.958% 81.967% ############# ( 2, 3 ] 235680 9.757% 91.724% ## ( 3, 4 ] 109438 4.531% 96.255% # ( 4, 6 ] 67689 2.802% 99.057% # ( 6, 10 ] 19122 0.792% 99.849% ( 10, 15 ] 2822 0.117% 99.966% ( 15, 22 ] 247 0.010% 99.976% ( 22, 34 ] 53 0.002% 99.978% ( 34, 51 ] 22 0.001% 99.979% ( 51, 76 ] 217 0.009% 99.988% ( 76, 110 ] 81 0.003% 99.991% ( 110, 170 ] 186 0.008% 99.999% ( 170, 250 ] 281 0.012% 100.011% ( 250, 380 ] 124 0.005% 100.016% ( 380, 580 ] 136 0.006% 100.021% ( 580, 870 ] 51 0.002% 100.024% ( 870, 1300 ] 50 0.002% 100.026% ( 1300, 1900 ] 18 0.001% 100.026% ( 1900, 2900 ] 12 0.000% 100.027% ( 2900, 4400 ] 20 0.001% 100.028% ( 4400, 6600 ] 4 0.000% 100.028% ( 6600, 9900 ] 3 0.000% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 610812 Average: 4.6687 StdDev: 73.38 Min: 0 Median: 1.8271 Max: 8396 Percentiles: P50: 1.83 P75: 2.84 P99: 8.42 P99.9: 13.76 P99.99: 29.83 ------------------------------------------------------ [ 0, 1 ] 29482 4.827% 4.827% # ( 1, 2 ] 333621 54.619% 59.446% ########### ( 2, 3 ] 113725 18.619% 78.065% #### ( 3, 4 ] 63773 10.441% 88.505% ## ( 4, 6 ] 57579 9.427% 97.932% ## ( 6, 10 ] 10797 1.768% 99.700% ( 10, 15 ] 1628 0.267% 99.966% ( 15, 22 ] 127 0.021% 99.987% ( 22, 34 ] 29 0.005% 99.992% ( 34, 51 ] 6 0.001% 99.993% ( 51, 76 ] 56 0.009% 100.002% ( 76, 110 ] 20 0.003% 100.005% ( 110, 170 ] 53 0.009% 100.014% ( 170, 250 ] 80 0.013% 100.027% ( 250, 380 ] 128 0.021% 100.048% ( 380, 580 ] 203 0.033% 100.081% ( 580, 870 ] 128 0.021% 100.102% ( 870, 1300 ] 55 0.009% 100.111% ( 1300, 1900 ] 53 0.009% 100.120% ( 1900, 2900 ] 88 0.014% 100.134% ( 2900, 4400 ] 100 0.016% 100.150% ( 4400, 6600 ] 24 0.004% 100.154% ( 6600, 9900 ] 9 0.001% 100.156% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 721492 Average: 4.2491 StdDev: 70.11 Min: 0 Median: 1.8632 Max: 15213 Percentiles: P50: 1.86 P75: 2.88 P99: 8.60 P99.9: 14.73 P99.99: 122.64 ------------------------------------------------------ [ 0, 1 ] 26396 3.659% 3.659% # ( 1, 2 ] 387318 53.683% 57.341% ########### ( 2, 3 ] 145199 20.125% 77.466% #### ( 3, 4 ] 78246 10.845% 88.311% ## ( 4, 6 ] 68713 9.524% 97.835% ## ( 6, 10 ] 12909 1.789% 99.624% ( 10, 15 ] 2104 0.292% 99.916% ( 15, 22 ] 223 0.031% 99.947% ( 22, 34 ] 102 0.014% 99.961% ( 34, 51 ] 14 0.002% 99.963% ( 51, 76 ] 114 0.016% 99.979% ( 76, 110 ] 53 0.007% 99.986% ( 110, 170 ] 137 0.019% 100.005% ( 170, 250 ] 194 0.027% 100.032% ( 250, 380 ] 274 0.038% 100.070% ( 380, 580 ] 186 0.026% 100.096% ( 580, 870 ] 99 0.014% 100.109% ( 870, 1300 ] 45 0.006% 100.116% ( 1300, 1900 ] 35 0.005% 100.120% ( 1900, 2900 ] 35 0.005% 100.125% ( 2900, 4400 ] 81 0.011% 100.137% ( 4400, 6600 ] 16 0.002% 100.139% ( 6600, 9900 ] 11 0.002% 100.140% ( 9900, 14000 ] 6 0.001% 100.141% ( 14000, 22000 ] 1 0.000% 100.141% ** Level 4 read latency histogram (micros): Count: 27450 Average: 79.2360 StdDev: 370.56 Min: 0 Median: 1.9454 Max: 8451 Percentiles: P50: 1.95 P75: 3.29 P99: 1857.14 P99.9: 4308.73 P99.99: 6225.50 ------------------------------------------------------ [ 0, 1 ] 1096 3.993% 3.993% # ( 1, 2 ] 13358 48.663% 52.656% ########## ( 2, 3 ] 5243 19.100% 71.756% #### ( 3, 4 ] 3059 11.144% 82.900% ## ( 4, 6 ] 1590 5.792% 88.692% # ( 6, 10 ] 621 2.262% 90.954% ( 10, 15 ] 82 0.299% 91.253% ( 15, 22 ] 11 0.040% 91.293% ( 22, 34 ] 2 0.007% 91.301% ( 34, 51 ] 9 0.033% 91.333% ( 51, 76 ] 20 0.073% 91.406% ( 76, 110 ] 24 0.087% 91.494% ( 110, 170 ] 101 0.368% 91.862% ( 170, 250 ] 158 0.576% 92.437% ( 250, 380 ] 404 1.472% 93.909% ( 380, 580 ] 503 1.832% 95.741% ( 580, 870 ] 476 1.734% 97.475% ( 870, 1300 ] 308 1.122% 98.597% ( 1300, 1900 ] 119 0.434% 99.031% ( 1900, 2900 ] 139 0.506% 99.537% ( 2900, 4400 ] 106 0.386% 99.923% ( 4400, 6600 ] 22 0.080% 100.004% ( 6600, 9900 ] 3 0.011% 100.015% ** Level 5 read latency histogram (micros): Count: 140 Average: 699.5071 StdDev: 639.51 Min: 49 Median: 443.1579 Max: 3300 Percentiles: P50: 443.16 P75: 1063.50 P99: 3300.00 P99.9: 3300.00 P99.99: 3300.00 ------------------------------------------------------ ( 34, 51 ] 1 0.714% 0.714% ( 51, 76 ] 11 7.857% 8.571% ## ( 76, 110 ] 4 2.857% 11.429% # ( 110, 170 ] 8 5.714% 17.143% # ( 170, 250 ] 14 10.000% 27.143% ## ( 250, 380 ] 26 18.571% 45.714% #### ( 380, 580 ] 19 13.571% 59.286% ### ( 580, 870 ] 13 9.286% 68.571% ## ( 870, 1300 ] 20 14.286% 82.857% ### ( 1300, 1900 ] 16 11.429% 94.286% ## ( 1900, 2900 ] 6 4.286% 98.571% # ( 2900, 4400 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 24.8 total, 3.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 277.34 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:5.419 H:M:S, 21.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.27 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.395 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-13:21:29 ... thread 0: (1000000,8000000) ops and (239325.5,277521.5) ops/second in (4.178410,28.826599) 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/10 5.03 GB 176.2 7.4 0.0 7.4 15.1 7.6 0.0 2.0 147.1 297.7 51.80 46.77 136 0.381 7738K 14K 0.0 0.0 L1 4/4 212.04 MB 0.0 2.5 2.4 0.1 2.5 2.4 0.2 1.0 242.5 240.8 10.70 10.31 3 3.568 2635K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 2.3 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 21/0 964.58 MB 1.0 3.7 2.2 1.5 3.7 2.2 0.3 1.7 176.9 176.3 21.57 16.12 15 1.438 3875K 13K 0.0 0.0 L4 181/0 9.57 GB 1.0 1.6 1.5 0.1 1.6 1.5 0.9 1.1 131.7 131.5 12.64 7.48 27 0.468 1627K 1107 0.0 0.0 L5 1072/0 87.97 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1296/14 103.72 GB 0.0 15.5 6.2 9.3 23.1 13.8 5.9 3.0 163.0 242.6 97.49 81.43 183 0.533 16M 46K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.5 6.2 9.3 23.1 13.8 5.8 3.0 163.0 242.6 97.49 81.43 183 0.533 16M 46K 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.5 6.2 9.3 15.5 6.2 0.0 0.0 213.5 212.8 74.43 62.25 71 1.048 16M 46K 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 338.8 23.06 19.18 112 0.206 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): 29.0 total, 28.8 interval Flush(GB): cumulative 7.629, interval 7.629 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: 23.10 GB write, 815.12 MB/s write, 15.52 GB read, 547.60 MB/s read, 97.5 seconds Interval compaction: 23.10 GB write, 820.50 MB/s write, 15.52 GB read, 551.21 MB/s read, 97.5 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: 39, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 39, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2982636 Average: 2.3231 StdDev: 17.89 Min: 0 Median: 1.4999 Max: 12715 Percentiles: P50: 1.50 P75: 1.89 P99: 5.92 P99.9: 11.35 P99.99: 63.26 ------------------------------------------------------ [ 0, 1 ] 526287 17.645% 17.645% #### ( 1, 2 ] 1930433 64.722% 82.367% ############# ( 2, 3 ] 289192 9.696% 92.063% ## ( 3, 4 ] 130649 4.380% 96.444% # ( 4, 6 ] 79244 2.657% 99.100% # ( 6, 10 ] 23029 0.772% 99.873% ( 10, 15 ] 3035 0.102% 99.974% ( 15, 22 ] 268 0.009% 99.983% ( 22, 34 ] 60 0.002% 99.985% ( 34, 51 ] 25 0.001% 99.986% ( 51, 76 ] 236 0.008% 99.994% ( 76, 110 ] 88 0.003% 99.997% ( 110, 170 ] 214 0.007% 100.004% ( 170, 250 ] 326 0.011% 100.015% ( 250, 380 ] 141 0.005% 100.020% ( 380, 580 ] 144 0.005% 100.025% ( 580, 870 ] 63 0.002% 100.027% ( 870, 1300 ] 58 0.002% 100.029% ( 1300, 1900 ] 18 0.001% 100.029% ( 1900, 2900 ] 13 0.000% 100.030% ( 2900, 4400 ] 20 0.001% 100.030% ( 4400, 6600 ] 4 0.000% 100.031% ( 6600, 9900 ] 3 0.000% 100.031% ( 9900, 14000 ] 1 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 610812 Average: 4.6687 StdDev: 73.38 Min: 0 Median: 1.8271 Max: 8396 Percentiles: P50: 1.83 P75: 2.84 P99: 8.42 P99.9: 13.76 P99.99: 29.83 ------------------------------------------------------ [ 0, 1 ] 29482 4.827% 4.827% # ( 1, 2 ] 333621 54.619% 59.446% ########### ( 2, 3 ] 113725 18.619% 78.065% #### ( 3, 4 ] 63773 10.441% 88.505% ## ( 4, 6 ] 57579 9.427% 97.932% ## ( 6, 10 ] 10797 1.768% 99.700% ( 10, 15 ] 1628 0.267% 99.966% ( 15, 22 ] 127 0.021% 99.987% ( 22, 34 ] 29 0.005% 99.992% ( 34, 51 ] 6 0.001% 99.993% ( 51, 76 ] 56 0.009% 100.002% ( 76, 110 ] 20 0.003% 100.005% ( 110, 170 ] 53 0.009% 100.014% ( 170, 250 ] 80 0.013% 100.027% ( 250, 380 ] 128 0.021% 100.048% ( 380, 580 ] 203 0.033% 100.081% ( 580, 870 ] 128 0.021% 100.102% ( 870, 1300 ] 55 0.009% 100.111% ( 1300, 1900 ] 53 0.009% 100.120% ( 1900, 2900 ] 88 0.014% 100.134% ( 2900, 4400 ] 100 0.016% 100.150% ( 4400, 6600 ] 24 0.004% 100.154% ( 6600, 9900 ] 9 0.001% 100.156% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 721492 Average: 4.2491 StdDev: 70.11 Min: 0 Median: 1.8632 Max: 15213 Percentiles: P50: 1.86 P75: 2.88 P99: 8.60 P99.9: 14.73 P99.99: 122.64 ------------------------------------------------------ [ 0, 1 ] 26396 3.659% 3.659% # ( 1, 2 ] 387318 53.683% 57.341% ########### ( 2, 3 ] 145199 20.125% 77.466% #### ( 3, 4 ] 78246 10.845% 88.311% ## ( 4, 6 ] 68713 9.524% 97.835% ## ( 6, 10 ] 12909 1.789% 99.624% ( 10, 15 ] 2104 0.292% 99.916% ( 15, 22 ] 223 0.031% 99.947% ( 22, 34 ] 102 0.014% 99.961% ( 34, 51 ] 14 0.002% 99.963% ( 51, 76 ] 114 0.016% 99.979% ( 76, 110 ] 53 0.007% 99.986% ( 110, 170 ] 137 0.019% 100.005% ( 170, 250 ] 194 0.027% 100.032% ( 250, 380 ] 274 0.038% 100.070% ( 380, 580 ] 186 0.026% 100.096% ( 580, 870 ] 99 0.014% 100.109% ( 870, 1300 ] 45 0.006% 100.116% ( 1300, 1900 ] 35 0.005% 100.120% ( 1900, 2900 ] 35 0.005% 100.125% ( 2900, 4400 ] 81 0.011% 100.137% ( 4400, 6600 ] 16 0.002% 100.139% ( 6600, 9900 ] 11 0.002% 100.140% ( 9900, 14000 ] 6 0.001% 100.141% ( 14000, 22000 ] 1 0.000% 100.141% ** Level 4 read latency histogram (micros): Count: 27450 Average: 79.2360 StdDev: 370.56 Min: 0 Median: 1.9454 Max: 8451 Percentiles: P50: 1.95 P75: 3.29 P99: 1857.14 P99.9: 4308.73 P99.99: 6225.50 ------------------------------------------------------ [ 0, 1 ] 1096 3.993% 3.993% # ( 1, 2 ] 13358 48.663% 52.656% ########## ( 2, 3 ] 5243 19.100% 71.756% #### ( 3, 4 ] 3059 11.144% 82.900% ## ( 4, 6 ] 1590 5.792% 88.692% # ( 6, 10 ] 621 2.262% 90.954% ( 10, 15 ] 82 0.299% 91.253% ( 15, 22 ] 11 0.040% 91.293% ( 22, 34 ] 2 0.007% 91.301% ( 34, 51 ] 9 0.033% 91.333% ( 51, 76 ] 20 0.073% 91.406% ( 76, 110 ] 24 0.087% 91.494% ( 110, 170 ] 101 0.368% 91.862% ( 170, 250 ] 158 0.576% 92.437% ( 250, 380 ] 404 1.472% 93.909% ( 380, 580 ] 503 1.832% 95.741% ( 580, 870 ] 476 1.734% 97.475% ( 870, 1300 ] 308 1.122% 98.597% ( 1300, 1900 ] 119 0.434% 99.031% ( 1900, 2900 ] 139 0.506% 99.537% ( 2900, 4400 ] 106 0.386% 99.923% ( 4400, 6600 ] 22 0.080% 100.004% ( 6600, 9900 ] 3 0.011% 100.015% ** Level 5 read latency histogram (micros): Count: 140 Average: 699.5071 StdDev: 639.51 Min: 49 Median: 443.1579 Max: 3300 Percentiles: P50: 443.16 P75: 1063.50 P99: 3300.00 P99.9: 3300.00 P99.99: 3300.00 ------------------------------------------------------ ( 34, 51 ] 1 0.714% 0.714% ( 51, 76 ] 11 7.857% 8.571% ## ( 76, 110 ] 4 2.857% 11.429% # ( 110, 170 ] 8 5.714% 17.143% # ( 170, 250 ] 14 10.000% 27.143% ## ( 250, 380 ] 26 18.571% 45.714% #### ( 380, 580 ] 19 13.571% 59.286% ### ( 580, 870 ] 13 9.286% 68.571% ## ( 870, 1300 ] 20 14.286% 82.857% ### ( 1300, 1900 ] 16 11.429% 94.286% ## ( 1900, 2900 ] 6 4.286% 98.571% # ( 2900, 4400 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 29.0 total, 4.2 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 271.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:6.861 H:M:S, 23.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 235.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:1.441 H:M:S, 34.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/12-13:21:41 ... thread 0: (1000000,9000000) ops and (88912.0,224586.4) ops/second in (11.247072,40.073671) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/8 2.64 GB 18.9 9.0 0.0 9.0 17.5 8.5 0.0 2.0 152.4 297.2 60.34 54.56 154 0.392 9337K 17K 0.0 0.0 L1 25/25 2.21 GB 0.0 6.1 5.7 0.3 6.0 5.6 0.2 1.0 238.5 235.7 25.99 24.97 4 6.498 6293K 71K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.5 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 15/1 1.07 GB 1.0 4.4 2.6 1.8 4.4 2.6 1.1 1.7 176.4 175.5 25.40 19.01 19 1.337 4551K 22K 0.0 0.0 L4 181/4 9.70 GB 1.0 2.9 2.6 0.3 2.9 2.6 0.9 1.1 131.0 130.7 22.82 13.44 43 0.531 2926K 3972 0.0 0.0 L5 1084/0 88.95 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1315/38 104.57 GB 0.0 22.5 11.1 11.5 31.0 19.5 9.0 3.6 170.4 234.2 135.33 112.73 222 0.610 23M 115K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.5 11.1 11.5 31.0 19.5 8.9 3.6 170.4 234.2 135.33 112.73 222 0.610 23M 115K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.5 11.1 11.5 22.4 10.9 0.0 0.0 211.0 209.9 109.28 91.16 96 1.138 23M 115K 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 336.1 26.05 21.56 126 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): 40.3 total, 40.1 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 30.95 GB write, 787.17 MB/s write, 22.52 GB read, 572.67 MB/s read, 135.3 seconds Interval compaction: 30.95 GB write, 790.91 MB/s write, 22.52 GB read, 575.39 MB/s read, 135.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 25, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 25, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 15, pending-compaction-bytes-stops: 0, total-delays: 40, total-stops: 46, interval: 86 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3956253 Average: 2.4183 StdDev: 18.97 Min: 0 Median: 1.4913 Max: 12715 Percentiles: P50: 1.49 P75: 1.88 P99: 5.98 P99.9: 13.79 P99.99: 209.93 ------------------------------------------------------ [ 0, 1 ] 715265 18.079% 18.079% #### ( 1, 2 ] 2570296 64.968% 83.047% ############# ( 2, 3 ] 368527 9.315% 92.362% ## ( 3, 4 ] 163224 4.126% 96.488% # ( 4, 6 ] 100615 2.543% 99.031% # ( 6, 10 ] 31547 0.797% 99.829% ( 10, 15 ] 3722 0.094% 99.923% ( 15, 22 ] 361 0.009% 99.932% ( 22, 34 ] 71 0.002% 99.934% ( 34, 51 ] 40 0.001% 99.935% ( 51, 76 ] 770 0.019% 99.954% ( 76, 110 ] 312 0.008% 99.962% ( 110, 170 ] 733 0.019% 99.981% ( 170, 250 ] 752 0.019% 100.000% ( 250, 380 ] 371 0.009% 100.009% ( 380, 580 ] 351 0.009% 100.018% ( 580, 870 ] 204 0.005% 100.023% ( 870, 1300 ] 113 0.003% 100.026% ( 1300, 1900 ] 30 0.001% 100.027% ( 1900, 2900 ] 22 0.001% 100.027% ( 2900, 4400 ] 30 0.001% 100.028% ( 4400, 6600 ] 4 0.000% 100.028% ( 6600, 9900 ] 3 0.000% 100.028% ( 9900, 14000 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 811067 Average: 4.6635 StdDev: 70.89 Min: 0 Median: 1.7944 Max: 8396 Percentiles: P50: 1.79 P75: 2.79 P99: 8.58 P99.9: 19.26 P99.99: 251.28 ------------------------------------------------------ [ 0, 1 ] 57905 7.139% 7.139% # ( 1, 2 ] 437601 53.954% 61.093% ########### ( 2, 3 ] 142619 17.584% 78.677% #### ( 3, 4 ] 81139 10.004% 88.681% ## ( 4, 6 ] 74442 9.178% 97.859% ## ( 6, 10 ] 14359 1.770% 99.630% ( 10, 15 ] 2074 0.256% 99.886% ( 15, 22 ] 192 0.024% 99.909% ( 22, 34 ] 44 0.005% 99.915% ( 34, 51 ] 24 0.003% 99.918% ( 51, 76 ] 234 0.029% 99.946% ( 76, 110 ] 73 0.009% 99.955% ( 110, 170 ] 144 0.018% 99.973% ( 170, 250 ] 134 0.017% 99.990% ( 250, 380 ] 192 0.024% 100.013% ( 380, 580 ] 327 0.040% 100.054% ( 580, 870 ] 227 0.028% 100.082% ( 870, 1300 ] 99 0.012% 100.094% ( 1300, 1900 ] 73 0.009% 100.103% ( 1900, 2900 ] 103 0.013% 100.116% ( 2900, 4400 ] 121 0.015% 100.131% ( 4400, 6600 ] 30 0.004% 100.134% ( 6600, 9900 ] 10 0.001% 100.136% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1065726 Average: 4.6645 StdDev: 70.74 Min: 0 Median: 1.8954 Max: 15213 Percentiles: P50: 1.90 P75: 2.95 P99: 8.81 P99.9: 14.92 P99.99: 160.95 ------------------------------------------------------ [ 0, 1 ] 33346 3.129% 3.129% # ( 1, 2 ] 557896 52.349% 55.478% ########## ( 2, 3 ] 218586 20.511% 75.988% #### ( 3, 4 ] 120461 11.303% 87.292% ## ( 4, 6 ] 109720 10.295% 97.587% ## ( 6, 10 ] 21454 2.013% 99.600% ( 10, 15 ] 3249 0.305% 99.905% ( 15, 22 ] 342 0.032% 99.937% ( 22, 34 ] 119 0.011% 99.948% ( 34, 51 ] 26 0.002% 99.951% ( 51, 76 ] 153 0.014% 99.965% ( 76, 110 ] 101 0.009% 99.974% ( 110, 170 ] 196 0.018% 99.993% ( 170, 250 ] 296 0.028% 100.021% ( 250, 380 ] 490 0.046% 100.067% ( 380, 580 ] 417 0.039% 100.106% ( 580, 870 ] 282 0.026% 100.132% ( 870, 1300 ] 136 0.013% 100.145% ( 1300, 1900 ] 72 0.007% 100.152% ( 1900, 2900 ] 70 0.007% 100.158% ( 2900, 4400 ] 150 0.014% 100.172% ( 4400, 6600 ] 27 0.003% 100.175% ( 6600, 9900 ] 11 0.001% 100.176% ( 9900, 14000 ] 6 0.001% 100.176% ( 14000, 22000 ] 1 0.000% 100.176% ** Level 4 read latency histogram (micros): Count: 101509 Average: 39.5375 StdDev: 254.83 Min: 0 Median: 1.9035 Max: 8451 Percentiles: P50: 1.90 P75: 3.12 P99: 991.59 P99.9: 3560.43 P99.99: 4339.05 ------------------------------------------------------ [ 0, 1 ] 4315 4.251% 4.251% # ( 1, 2 ] 51398 50.634% 54.885% ########## ( 2, 3 ] 19048 18.765% 73.650% #### ( 3, 4 ] 11188 11.022% 84.671% ## ( 4, 6 ] 8511 8.384% 93.056% ## ( 6, 10 ] 2417 2.381% 95.437% ( 10, 15 ] 299 0.295% 95.731% ( 15, 22 ] 33 0.033% 95.764% ( 22, 34 ] 7 0.007% 95.771% ( 34, 51 ] 11 0.011% 95.782% ( 51, 76 ] 43 0.042% 95.824% ( 76, 110 ] 39 0.038% 95.862% ( 110, 170 ] 146 0.144% 96.006% ( 170, 250 ] 271 0.267% 96.273% ( 250, 380 ] 698 0.688% 96.961% ( 380, 580 ] 998 0.983% 97.944% ( 580, 870 ] 912 0.898% 98.842% ( 870, 1300 ] 569 0.561% 99.403% ( 1300, 1900 ] 219 0.216% 99.619% ( 1900, 2900 ] 209 0.206% 99.825% ( 2900, 4400 ] 176 0.173% 99.998% ( 4400, 6600 ] 45 0.044% 100.042% ( 6600, 9900 ] 5 0.005% 100.047% ** Level 5 read latency histogram (micros): Count: 200 Average: 878.1600 StdDev: 1019.98 Min: 49 Median: 483.7037 Max: 6727 Percentiles: P50: 483.70 P75: 1181.38 P99: 6050.00 P99.9: 6727.00 P99.99: 6727.00 ------------------------------------------------------ ( 34, 51 ] 1 0.500% 0.500% ( 51, 76 ] 13 6.500% 7.000% # ( 76, 110 ] 5 2.500% 9.500% # ( 110, 170 ] 11 5.500% 15.000% # ( 170, 250 ] 17 8.500% 23.500% ## ( 250, 380 ] 39 19.500% 43.000% #### ( 380, 580 ] 27 13.500% 56.500% ### ( 580, 870 ] 16 8.000% 64.500% ## ( 870, 1300 ] 29 14.500% 79.000% ### ( 1300, 1900 ] 21 10.500% 89.500% ## ( 1900, 2900 ] 12 6.000% 95.500% # ( 2900, 4400 ] 4 2.000% 97.500% ( 4400, 6600 ] 4 2.000% 99.500% ( 6600, 9900 ] 1 0.500% 100.000% ** DB Stats ** Uptime(secs): 40.3 total, 11.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 219.98 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:14.928 H:M:S, 37.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 87.51 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:8.067 H:M:S, 71.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-13:21:44 ... thread 0: (1000000,10000000) ops and (331066.2,232049.7) ops/second in (3.020544,43.094215) 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/12 3.62 GB 94.4 9.5 0.0 9.5 19.1 9.5 0.0 2.0 149.7 299.2 65.21 59.09 170 0.384 9912K 17K 0.0 0.0 L1 25/25 2.21 GB 0.0 6.1 5.7 0.3 6.0 5.6 0.2 1.0 238.5 235.7 25.99 24.97 4 6.498 6293K 71K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.5 1.5 249.3 249.1 0.78 0.74 2 0.388 196K 82 0.0 0.0 L3 14/0 963.36 MB 1.0 4.4 2.6 1.8 4.4 2.6 1.1 1.7 176.4 175.5 25.40 19.01 19 1.337 4551K 22K 0.0 0.0 L4 178/0 9.51 GB 1.0 3.2 2.8 0.4 3.2 2.8 0.9 1.1 133.3 132.9 24.29 14.48 44 0.552 3177K 7460 0.0 0.0 L5 1088/0 89.26 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 1323/37 105.55 GB 0.0 23.3 11.2 12.1 32.7 20.6 9.3 3.4 168.5 236.6 141.67 118.29 239 0.593 24M 119K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.3 11.2 12.1 32.7 20.6 9.2 3.4 168.5 236.6 141.67 118.29 239 0.593 24M 119K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.3 11.2 12.1 23.2 11.1 0.0 0.0 211.6 210.5 112.84 94.24 99 1.140 24M 119K 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 338.7 28.83 24.05 140 0.206 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): 43.3 total, 43.1 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 32.73 GB write, 774.24 MB/s write, 23.31 GB read, 551.51 MB/s read, 141.7 seconds Interval compaction: 32.73 GB write, 777.65 MB/s write, 23.31 GB read, 553.94 MB/s read, 141.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 25, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 25, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 48, pending-compaction-bytes-delays: 15, pending-compaction-bytes-stops: 0, total-delays: 40, total-stops: 48, interval: 88 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4322560 Average: 2.4109 StdDev: 18.33 Min: 0 Median: 1.4917 Max: 12715 Percentiles: P50: 1.49 P75: 1.88 P99: 5.98 P99.9: 13.77 P99.99: 204.80 ------------------------------------------------------ [ 0, 1 ] 777430 17.985% 17.985% #### ( 1, 2 ] 2814660 65.116% 83.101% ############# ( 2, 3 ] 404369 9.355% 92.456% ## ( 3, 4 ] 176461 4.082% 96.538% # ( 4, 6 ] 107292 2.482% 99.020% ( 6, 10 ] 34862 0.807% 99.827% ( 10, 15 ] 4195 0.097% 99.924% ( 15, 22 ] 403 0.009% 99.933% ( 22, 34 ] 82 0.002% 99.935% ( 34, 51 ] 40 0.001% 99.936% ( 51, 76 ] 797 0.018% 99.954% ( 76, 110 ] 340 0.008% 99.962% ( 110, 170 ] 826 0.019% 99.981% ( 170, 250 ] 857 0.020% 100.001% ( 250, 380 ] 416 0.010% 100.011% ( 380, 580 ] 378 0.009% 100.020% ( 580, 870 ] 208 0.005% 100.024% ( 870, 1300 ] 119 0.003% 100.027% ( 1300, 1900 ] 31 0.001% 100.028% ( 1900, 2900 ] 22 0.001% 100.028% ( 2900, 4400 ] 30 0.001% 100.029% ( 4400, 6600 ] 4 0.000% 100.029% ( 6600, 9900 ] 3 0.000% 100.029% ( 9900, 14000 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 825470 Average: 4.6327 StdDev: 70.30 Min: 0 Median: 1.7889 Max: 8396 Percentiles: P50: 1.79 P75: 2.78 P99: 8.58 P99.9: 21.04 P99.99: 254.94 ------------------------------------------------------ [ 0, 1 ] 59571 7.217% 7.217% # ( 1, 2 ] 447664 54.231% 61.448% ########### ( 2, 3 ] 144262 17.476% 78.924% ### ( 3, 4 ] 81647 9.891% 88.815% ## ( 4, 6 ] 74669 9.046% 97.861% ## ( 6, 10 ] 14575 1.766% 99.627% ( 10, 15 ] 2090 0.253% 99.880% ( 15, 22 ] 194 0.024% 99.903% ( 22, 34 ] 44 0.005% 99.909% ( 34, 51 ] 24 0.003% 99.912% ( 51, 76 ] 253 0.031% 99.942% ( 76, 110 ] 83 0.010% 99.952% ( 110, 170 ] 158 0.019% 99.971% ( 170, 250 ] 147 0.018% 99.989% ( 250, 380 ] 196 0.024% 100.013% ( 380, 580 ] 329 0.040% 100.053% ( 580, 870 ] 227 0.027% 100.080% ( 870, 1300 ] 99 0.012% 100.092% ( 1300, 1900 ] 74 0.009% 100.101% ( 1900, 2900 ] 103 0.012% 100.114% ( 2900, 4400 ] 121 0.015% 100.128% ( 4400, 6600 ] 30 0.004% 100.132% ( 6600, 9900 ] 10 0.001% 100.133% ** Level 2 read latency histogram (micros): Count: 65096 Average: 2.6384 StdDev: 17.72 Min: 1 Median: 1.5593 Max: 2161 Percentiles: P50: 1.56 P75: 1.95 P99: 7.48 P99.9: 64.17 P99.99: 546.45 ------------------------------------------------------ [ 0, 1 ] 9506 14.603% 14.603% ### ( 1, 2 ] 41200 63.291% 77.894% ############# ( 2, 3 ] 7374 11.328% 89.222% ## ( 3, 4 ] 3764 5.782% 95.004% # ( 4, 6 ] 2313 3.553% 98.558% # ( 6, 10 ] 781 1.200% 99.757% ( 10, 15 ] 72 0.111% 99.868% ( 15, 22 ] 8 0.012% 99.880% ( 22, 34 ] 4 0.006% 99.886% ( 34, 51 ] 1 0.002% 99.888% ( 51, 76 ] 15 0.023% 99.911% ( 76, 110 ] 3 0.005% 99.916% ( 110, 170 ] 13 0.020% 99.935% ( 170, 250 ] 12 0.018% 99.954% ( 250, 380 ] 16 0.025% 99.978% ( 380, 580 ] 9 0.014% 99.992% ( 580, 870 ] 1 0.002% 99.994% ( 1300, 1900 ] 2 0.003% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 1065726 Average: 4.6645 StdDev: 70.74 Min: 0 Median: 1.8954 Max: 15213 Percentiles: P50: 1.90 P75: 2.95 P99: 8.81 P99.9: 14.92 P99.99: 160.95 ------------------------------------------------------ [ 0, 1 ] 33346 3.129% 3.129% # ( 1, 2 ] 557896 52.349% 55.478% ########## ( 2, 3 ] 218586 20.511% 75.988% #### ( 3, 4 ] 120461 11.303% 87.292% ## ( 4, 6 ] 109720 10.295% 97.587% ## ( 6, 10 ] 21454 2.013% 99.600% ( 10, 15 ] 3249 0.305% 99.905% ( 15, 22 ] 342 0.032% 99.937% ( 22, 34 ] 119 0.011% 99.948% ( 34, 51 ] 26 0.002% 99.951% ( 51, 76 ] 153 0.014% 99.965% ( 76, 110 ] 101 0.009% 99.974% ( 110, 170 ] 196 0.018% 99.993% ( 170, 250 ] 296 0.028% 100.021% ( 250, 380 ] 490 0.046% 100.067% ( 380, 580 ] 417 0.039% 100.106% ( 580, 870 ] 282 0.026% 100.132% ( 870, 1300 ] 136 0.013% 100.145% ( 1300, 1900 ] 72 0.007% 100.152% ( 1900, 2900 ] 70 0.007% 100.158% ( 2900, 4400 ] 150 0.014% 100.172% ( 4400, 6600 ] 27 0.003% 100.175% ( 6600, 9900 ] 11 0.001% 100.176% ( 9900, 14000 ] 6 0.001% 100.176% ( 14000, 22000 ] 1 0.000% 100.176% ** Level 4 read latency histogram (micros): Count: 103353 Average: 38.8958 StdDev: 252.61 Min: 0 Median: 1.8957 Max: 8451 Percentiles: P50: 1.90 P75: 3.09 P99: 977.67 P99.9: 3544.72 P99.99: 4337.48 ------------------------------------------------------ [ 0, 1 ] 4515 4.369% 4.369% # ( 1, 2 ] 52655 50.947% 55.315% ########## ( 2, 3 ] 19308 18.682% 73.997% #### ( 3, 4 ] 11243 10.878% 84.875% ## ( 4, 6 ] 8541 8.264% 93.139% ## ( 6, 10 ] 2449 2.370% 95.509% ( 10, 15 ] 300 0.290% 95.799% ( 15, 22 ] 33 0.032% 95.831% ( 22, 34 ] 7 0.007% 95.838% ( 34, 51 ] 11 0.011% 95.848% ( 51, 76 ] 43 0.042% 95.890% ( 76, 110 ] 39 0.038% 95.928% ( 110, 170 ] 146 0.141% 96.069% ( 170, 250 ] 276 0.267% 96.336% ( 250, 380 ] 698 0.675% 97.011% ( 380, 580 ] 1001 0.969% 97.980% ( 580, 870 ] 912 0.882% 98.862% ( 870, 1300 ] 569 0.551% 99.413% ( 1300, 1900 ] 219 0.212% 99.625% ( 1900, 2900 ] 209 0.202% 99.827% ( 2900, 4400 ] 176 0.170% 99.997% ( 4400, 6600 ] 45 0.044% 100.041% ( 6600, 9900 ] 5 0.005% 100.045% ** Level 5 read latency histogram (micros): Count: 220 Average: 835.0591 StdDev: 989.58 Min: 49 Median: 455.8621 Max: 6727 Percentiles: P50: 455.86 P75: 1142.33 P99: 5940.00 P99.9: 6727.00 P99.99: 6727.00 ------------------------------------------------------ ( 34, 51 ] 1 0.455% 0.455% ( 51, 76 ] 15 6.818% 7.273% # ( 76, 110 ] 7 3.182% 10.455% # ( 110, 170 ] 17 7.727% 18.182% ## ( 170, 250 ] 19 8.636% 26.818% ## ( 250, 380 ] 40 18.182% 45.000% #### ( 380, 580 ] 29 13.182% 58.182% ### ( 580, 870 ] 18 8.182% 66.364% ## ( 870, 1300 ] 30 13.636% 80.000% ### ( 1300, 1900 ] 23 10.455% 90.455% ## ( 1900, 2900 ] 12 5.455% 95.909% # ( 2900, 4400 ] 4 1.818% 97.727% ( 4400, 6600 ] 4 1.818% 99.545% ( 6600, 9900 ] 1 0.455% 100.000% ** DB Stats ** Uptime(secs): 43.3 total, 3.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 227.37 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.321 H:M:S, 35.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 325.83 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.393 H:M:S, 13.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.832 micros/op 171452 ops/sec 60.092 seconds 10302999 operations; 166.1 MB/s Microseconds per write: Count: 10302999 Average: 5.8325 StdDev: 359.24 Min: 0 Median: 1.6905 Max: 637404 Percentiles: P50: 1.69 P75: 2.88 P99: 9.37 P99.9: 1155.96 P99.99: 2722.08 ------------------------------------------------------ [ 0, 1 ] 1828667 17.749% 17.749% #### ( 1, 2 ] 4812506 46.710% 64.459% ######### ( 2, 3 ] 1233057 11.968% 76.427% ## ( 3, 4 ] 1463634 14.206% 90.632% ### ( 4, 6 ] 758388 7.361% 97.993% # ( 6, 10 ] 123113 1.195% 99.188% ( 10, 15 ] 37423 0.363% 99.551% ( 15, 22 ] 11185 0.109% 99.660% ( 22, 34 ] 2998 0.029% 99.689% ( 34, 51 ] 572 0.006% 99.695% ( 51, 76 ] 95 0.001% 99.696% ( 76, 110 ] 49 0.000% 99.696% ( 110, 170 ] 9666 0.094% 99.790% ( 170, 250 ] 555 0.005% 99.795% ( 250, 380 ] 232 0.002% 99.798% ( 380, 580 ] 54 0.001% 99.798% ( 580, 870 ] 43 0.000% 99.798% ( 870, 1300 ] 15727 0.153% 99.951% ( 1300, 1900 ] 62 0.001% 99.952% ( 1900, 2900 ] 4796 0.047% 99.998% ( 2900, 4400 ] 118 0.001% 99.999% ( 4400, 6600 ] 19 0.000% 100.000% ( 6600, 9900 ] 11 0.000% 100.000% ( 9900, 14000 ] 6 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 10 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 227385 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 : 10302999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10632694968 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 : 592 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31095452 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 : 32778257124 rocksdb.compact.write.bytes COUNT : 32537167486 rocksdb.flush.write.bytes COUNT : 10503256985 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 : 52 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 : 379 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 : 10418395136 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3888128 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 : 32877397631 rocksdb.non.last.level.read.count COUNT : 7942076 rocksdb.block.checksum.compute.count COUNT : 7940944 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.308487 P95 : 4.413189 P99 : 8.214431 P100 : 637397.000000 COUNT : 10302999 SUM : 55541710 rocksdb.compaction.times.micros P50 : 902500.000000 P95 : 3763333.333333 P99 : 17880000.000000 P100 : 21143290.000000 COUNT : 103 SUM : 139595984 rocksdb.compaction.times.cpu_micros P50 : 692692.307692 P95 : 2850000.000000 P99 : 17880000.000000 P100 : 19062293.000000 COUNT : 103 SUM : 118860384 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 : 696.000000 P95 : 4986.666667 P99 : 18480.000000 P100 : 130465.000000 COUNT : 144 SUM : 283184 rocksdb.compaction.outfile.sync.micros P50 : 1094.662921 P95 : 63750.000000 P99 : 110750.000000 P100 : 137584.000000 COUNT : 395 SUM : 4514481 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 : 107.280000 P95 : 1295.222222 P99 : 3785.000000 P100 : 5583.000000 COUNT : 282 SUM : 84370 rocksdb.table.open.io.micros P50 : 1032.346939 P95 : 5940.000000 P99 : 9612.000000 P100 : 17826.000000 COUNT : 592 SUM : 945187 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.513487 P95 : 7.236852 P99 : 10.153488 P100 : 17168.000000 COUNT : 7939383 SUM : 45739864 rocksdb.read.block.get.micros P50 : 394.851485 P95 : 2163.414634 P99 : 4330.000000 P100 : 12770.000000 COUNT : 1184 SUM : 748975 rocksdb.write.raw.block.micros P50 : 0.512913 P95 : 0.974534 P99 : 3.034727 P100 : 26285.000000 COUNT : 10429925 SUM : 20526220 rocksdb.numfiles.in.singlecompaction P50 : 2.931034 P95 : 4.850000 P99 : 13.900000 P100 : 33.000000 COUNT : 166 SUM : 578 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.560264 P95 : 1169.875477 P99 : 2510.642932 P100 : 637207.000000 COUNT : 192918 SUM : 31111517 rocksdb.sst.read.micros P50 : 1.560494 P95 : 4.453316 P99 : 8.099574 P100 : 15213.000000 COUNT : 7942498 SUM : 29984378 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 : 10302999 SUM : 10632694968 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 : 192028.985507 P95 : 370250.000000 P99 : 720800.000000 P100 : 841428.000000 COUNT : 144 SUM : 30013377 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