[2024-11-18 01:55:38.198723] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-11-18 01:55:38.198870] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid693558 ] Set seed to 1731891338195213 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-18 01:55:38.289442] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-18 01:55:38.329258] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-18 01:55:38.329306] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 693558' to capture a snapshot of events at runtime. [2024-11-18 01:55:38.329318] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid693558 for offline analysis/debug. [2024-11-18 01:55:38.329347] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Nov 18 01:55:42 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/18-01:55:45 ... thread 0: (1000000,1000000) ops and (357042.2,357042.2) ops/second in (2.800789,2.800789) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.01 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 356.3 2.30 2.10 12 0.192 0 0 0.0 0.0 L2 3/2 251.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 9/0 741.30 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.94 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.5 99.7 315.8 3.79 3.54 14 0.271 383K 209 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.4 1.5 99.7 315.8 3.79 3.54 14 0.271 383K 209 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 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 356.3 2.30 2.10 12 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 400.73 MB/s write, 0.37 GB read, 126.56 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 427.06 MB/s write, 0.37 GB read, 134.87 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 103612 Average: 1.8564 StdDev: 17.57 Min: 1 Median: 1.2055 Max: 3586 Percentiles: P50: 1.21 P75: 1.65 P99: 3.76 P99.9: 9.53 P99.99: 277.68 ------------------------------------------------------ [ 0, 1 ] 39711 38.327% 38.327% ######## ( 1, 2 ] 58861 56.809% 95.136% ########### ( 2, 3 ] 3131 3.022% 98.158% # ( 3, 4 ] 1144 1.104% 99.262% ( 4, 6 ] 514 0.496% 99.758% ( 6, 10 ] 168 0.162% 99.920% ( 10, 15 ] 46 0.044% 99.964% ( 15, 22 ] 11 0.011% 99.975% ( 22, 34 ] 1 0.001% 99.976% ( 34, 51 ] 1 0.001% 99.977% ( 51, 76 ] 2 0.002% 99.979% ( 110, 170 ] 7 0.007% 99.986% ( 170, 250 ] 5 0.005% 99.990% ( 250, 380 ] 3 0.003% 99.993% ( 580, 870 ] 5 0.005% 99.998% ( 1900, 2900 ] 3 0.003% 100.001% ( 2900, 4400 ] 1 0.001% 100.002% ** Level 2 read latency histogram (micros): Count: 51301 Average: 2.0566 StdDev: 19.96 Min: 1 Median: 1.2512 Max: 2361 Percentiles: P50: 1.25 P75: 1.69 P99: 5.10 P99.9: 10.47 P99.99: 1244.06 ------------------------------------------------------ [ 0, 1 ] 18246 35.567% 35.567% ####### ( 1, 2 ] 29472 57.449% 93.016% ########### ( 2, 3 ] 1879 3.663% 96.678% # ( 3, 4 ] 896 1.747% 98.425% ( 4, 6 ] 540 1.053% 99.478% ( 6, 10 ] 215 0.419% 99.897% ( 10, 15 ] 29 0.057% 99.953% ( 15, 22 ] 3 0.006% 99.959% ( 22, 34 ] 6 0.012% 99.971% ( 76, 110 ] 1 0.002% 99.973% ( 170, 250 ] 1 0.002% 99.975% ( 250, 380 ] 4 0.008% 99.982% ( 380, 580 ] 2 0.004% 99.986% ( 580, 870 ] 2 0.004% 99.990% ( 870, 1300 ] 1 0.002% 99.992% ( 1300, 1900 ] 3 0.006% 99.998% ( 1900, 2900 ] 2 0.004% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1524.6545 StdDev: 1275.42 Min: 165 Median: 900.7143 Max: 5260 Percentiles: P50: 900.71 P75: 2372.22 P99: 5260.00 P99.9: 5260.00 P99.99: 5260.00 ------------------------------------------------------ ( 110, 170 ] 1 1.818% 1.818% ( 250, 380 ] 4 7.273% 9.091% # ( 380, 580 ] 8 14.545% 23.636% ### ( 580, 870 ] 14 25.455% 49.091% ##### ( 870, 1300 ] 7 12.727% 61.818% ### ( 1300, 1900 ] 3 5.455% 67.273% # ( 1900, 2900 ] 9 16.364% 83.636% ### ( 2900, 4400 ] 7 12.727% 96.364% ### ( 4400, 6600 ] 2 3.636% 100.000% # ** Level 4 read latency histogram (micros): Count: 15 Average: 1856.4000 StdDev: 1234.49 Min: 462 Median: 1450.0000 Max: 4156 Percentiles: P50: 1450.00 P75: 2650.00 P99: 4156.00 P99.9: 4156.00 P99.99: 4156.00 ------------------------------------------------------ ( 380, 580 ] 2 13.333% 13.333% ### ( 580, 870 ] 2 13.333% 26.667% ### ( 870, 1300 ] 3 20.000% 46.667% #### ( 1300, 1900 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 20 Average: 519.6000 StdDev: 658.77 Min: 75 Median: 152.8571 Max: 2281 Percentiles: P50: 152.86 P75: 580.00 P99: 2281.00 P99.9: 2281.00 P99.99: 2281.00 ------------------------------------------------------ ( 51, 76 ] 1 5.000% 5.000% # ( 76, 110 ] 4 20.000% 25.000% #### ( 110, 170 ] 7 35.000% 60.000% ####### ( 250, 380 ] 1 5.000% 65.000% # ( 380, 580 ] 2 10.000% 75.000% ## ( 580, 870 ] 1 5.000% 80.000% # ( 1300, 1900 ] 3 15.000% 95.000% ### ( 1900, 2900 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 329.55 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.198 H:M:S, 6.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.12 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.198 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-01:55:48 ... thread 0: (1000000,2000000) ops and (322225.4,338741.5) ops/second in (3.103418,5.904207) 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/6 1.17 GB 12.6 0.8 0.0 0.8 2.6 1.8 0.0 1.4 99.1 320.1 8.26 7.68 29 0.285 831K 852 0.0 0.0 L1 1/1 2.86 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 240.4 240.0 1.57 1.52 1 1.572 383K 619 0.0 0.0 L2 2/0 54.87 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 42/0 996.37 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 203.6 203.4 3.91 3.48 3 1.304 809K 883 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1245/7 97.92 GB 0.0 2.3 1.1 1.2 4.1 2.9 2.1 2.3 155.6 275.3 15.24 14.12 35 0.435 2408K 2563 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 1.1 1.2 4.1 2.9 1.7 2.3 155.6 275.3 15.24 14.12 35 0.435 2408K 2563 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.3 1.1 1.2 2.3 1.1 0.0 0.0 235.2 234.9 10.08 9.49 9 1.120 2408K 2563 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 354.3 5.16 4.63 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.10 GB write, 689.02 MB/s write, 2.32 GB read, 389.46 MB/s read, 15.2 seconds Interval compaction: 4.10 GB write, 710.50 MB/s write, 2.32 GB read, 401.60 MB/s read, 15.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 388212 Average: 2.1165 StdDev: 13.00 Min: 1 Median: 1.4258 Max: 4702 Percentiles: P50: 1.43 P75: 1.83 P99: 5.62 P99.9: 11.26 P99.99: 19.59 ------------------------------------------------------ [ 0, 1 ] 90793 23.387% 23.387% ##### ( 1, 2 ] 242658 62.507% 85.894% ############# ( 2, 3 ] 29610 7.627% 93.521% ## ( 3, 4 ] 14050 3.619% 97.140% # ( 4, 6 ] 8905 2.294% 99.434% ( 6, 10 ] 1701 0.438% 99.872% ( 10, 15 ] 429 0.111% 99.983% ( 15, 22 ] 43 0.011% 99.994% ( 22, 34 ] 9 0.002% 99.996% ( 34, 51 ] 3 0.001% 99.997% ( 51, 76 ] 2 0.001% 99.998% ( 110, 170 ] 12 0.003% 100.001% ( 170, 250 ] 14 0.004% 100.004% ( 250, 380 ] 10 0.003% 100.007% ( 380, 580 ] 6 0.002% 100.009% ( 580, 870 ] 8 0.002% 100.011% ( 870, 1300 ] 2 0.001% 100.011% ( 1900, 2900 ] 4 0.001% 100.012% ( 2900, 4400 ] 1 0.000% 100.012% ( 4400, 6600 ] 1 0.000% 100.013% ** Level 1 read latency histogram (micros): Count: 81604 Average: 2.4583 StdDev: 5.82 Min: 0 Median: 1.6297 Max: 1214 Percentiles: P50: 1.63 P75: 2.09 P99: 6.70 P99.9: 13.42 P99.99: 18.74 ------------------------------------------------------ [ 0, 1 ] 7804 9.563% 9.563% ## ( 1, 2 ] 52400 64.213% 73.776% ############# ( 2, 3 ] 11408 13.980% 87.756% ### ( 3, 4 ] 4823 5.910% 93.666% # ( 4, 6 ] 4226 5.179% 98.844% # ( 6, 10 ] 730 0.895% 99.739% ( 10, 15 ] 192 0.235% 99.974% ( 15, 22 ] 24 0.029% 100.004% ( 22, 34 ] 4 0.005% 100.009% ( 34, 51 ] 2 0.002% 100.011% ( 110, 170 ] 1 0.001% 100.012% ( 170, 250 ] 2 0.002% 100.015% ( 250, 380 ] 2 0.002% 100.017% ( 380, 580 ] 1 0.001% 100.018% ( 580, 870 ] 1 0.001% 100.020% ( 870, 1300 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 95445 Average: 2.1328 StdDev: 14.65 Min: 1 Median: 1.3946 Max: 2361 Percentiles: P50: 1.39 P75: 1.80 P99: 5.64 P99.9: 10.62 P99.99: 425.55 ------------------------------------------------------ [ 0, 1 ] 24657 25.834% 25.834% ##### ( 1, 2 ] 58457 61.247% 87.081% ############ ( 2, 3 ] 6435 6.742% 93.823% # ( 3, 4 ] 3287 3.444% 97.266% # ( 4, 6 ] 2015 2.111% 99.378% ( 6, 10 ] 489 0.512% 99.890% ( 10, 15 ] 77 0.081% 99.971% ( 15, 22 ] 6 0.006% 99.977% ( 22, 34 ] 6 0.006% 99.983% ( 76, 110 ] 1 0.001% 99.984% ( 170, 250 ] 1 0.001% 99.985% ( 250, 380 ] 4 0.004% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57583 Average: 3.9718 StdDev: 61.92 Min: 0 Median: 1.6235 Max: 5260 Percentiles: P50: 1.62 P75: 2.08 P99: 7.79 P99.9: 138.34 P99.99: 2149.08 ------------------------------------------------------ [ 0, 1 ] 5949 10.331% 10.331% ## ( 1, 2 ] 36634 63.619% 73.951% ############# ( 2, 3 ] 8007 13.905% 87.856% ### ( 3, 4 ] 3331 5.785% 93.640% # ( 4, 6 ] 2844 4.939% 98.579% # ( 6, 10 ] 541 0.940% 99.519% ( 10, 15 ] 142 0.247% 99.766% ( 15, 22 ] 25 0.043% 99.809% ( 22, 34 ] 37 0.064% 99.873% ( 34, 51 ] 14 0.024% 99.898% ( 110, 170 ] 3 0.005% 99.903% ( 170, 250 ] 5 0.009% 99.911% ( 250, 380 ] 7 0.012% 99.924% ( 380, 580 ] 11 0.019% 99.943% ( 580, 870 ] 14 0.024% 99.967% ( 870, 1300 ] 7 0.012% 99.979% ( 1300, 1900 ] 4 0.007% 99.986% ( 1900, 2900 ] 9 0.016% 100.002% ( 2900, 4400 ] 7 0.012% 100.014% ( 4400, 6600 ] 2 0.003% 100.017% ** Level 4 read latency histogram (micros): Count: 15 Average: 1856.4000 StdDev: 1234.49 Min: 462 Median: 1450.0000 Max: 4156 Percentiles: P50: 1450.00 P75: 2650.00 P99: 4156.00 P99.9: 4156.00 P99.99: 4156.00 ------------------------------------------------------ ( 380, 580 ] 2 13.333% 13.333% ### ( 580, 870 ] 2 13.333% 26.667% ### ( 870, 1300 ] 3 20.000% 46.667% #### ( 1300, 1900 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 649.5250 StdDev: 840.85 Min: 75 Median: 165.7143 Max: 3060 Percentiles: P50: 165.71 P75: 870.00 P99: 3060.00 P99.9: 3060.00 P99.99: 3060.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 6 15.000% 17.500% ### ( 110, 170 ] 14 35.000% 52.500% ####### ( 170, 250 ] 1 2.500% 55.000% # ( 250, 380 ] 3 7.500% 62.500% ## ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 2 5.000% 80.000% # ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 3 7.500% 97.500% ## ( 2900, 4400 ] 1 2.500% 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, 323.22 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.597 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, 317.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.399 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/18-01:55:51 ... thread 0: (1000000,3000000) ops and (319934.3,332231.5) ops/second in (3.125642,9.029849) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/10 2.15 GB 81.8 1.6 0.0 1.6 4.4 2.8 0.0 1.6 115.7 315.9 14.15 13.22 46 0.308 1663K 1716 0.0 0.0 L1 1/1 2.86 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 240.4 240.0 1.57 1.52 1 1.572 383K 619 0.0 0.0 L2 2/0 54.87 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 42/0 996.37 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 203.6 203.4 3.91 3.48 3 1.304 809K 883 0.0 0.0 L4 144/0 9.47 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/11 98.90 GB 0.0 3.1 1.1 2.0 5.9 3.9 2.1 2.1 151.0 285.0 21.13 19.66 52 0.406 3239K 3427 0.0 0.0 Int 0/0 0.00 KB 0.0 3.1 1.1 2.0 5.9 3.9 1.7 2.1 151.0 285.0 21.13 19.66 52 0.406 3239K 3427 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.1 1.1 2.0 3.1 1.1 0.0 0.0 243.4 243.1 13.11 12.46 12 1.093 3239K 3427 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 353.6 8.02 7.20 40 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.88 GB write, 653.46 MB/s write, 3.12 GB read, 346.23 MB/s read, 21.1 seconds Interval compaction: 5.88 GB write, 666.78 MB/s write, 3.12 GB read, 353.29 MB/s read, 21.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 798135 Average: 2.1208 StdDev: 10.99 Min: 1 Median: 1.4530 Max: 4702 Percentiles: P50: 1.45 P75: 1.84 P99: 5.54 P99.9: 10.58 P99.99: 14.54 ------------------------------------------------------ [ 0, 1 ] 162762 20.393% 20.393% #### ( 1, 2 ] 521647 65.358% 85.751% ############# ( 2, 3 ] 65075 8.153% 93.904% ## ( 3, 4 ] 28266 3.542% 97.446% # ( 4, 6 ] 16131 2.021% 99.467% ( 6, 10 ] 3352 0.420% 99.887% ( 10, 15 ] 906 0.114% 100.001% ( 15, 22 ] 81 0.010% 100.011% ( 22, 34 ] 12 0.002% 100.012% ( 34, 51 ] 5 0.001% 100.013% ( 51, 76 ] 5 0.001% 100.013% ( 110, 170 ] 14 0.002% 100.015% ( 170, 250 ] 24 0.003% 100.018% ( 250, 380 ] 17 0.002% 100.020% ( 380, 580 ] 8 0.001% 100.021% ( 580, 870 ] 14 0.002% 100.023% ( 870, 1300 ] 6 0.001% 100.024% ( 1300, 1900 ] 1 0.000% 100.024% ( 1900, 2900 ] 4 0.001% 100.024% ( 2900, 4400 ] 3 0.000% 100.025% ( 4400, 6600 ] 1 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 81604 Average: 2.4583 StdDev: 5.82 Min: 0 Median: 1.6297 Max: 1214 Percentiles: P50: 1.63 P75: 2.09 P99: 6.70 P99.9: 13.42 P99.99: 18.74 ------------------------------------------------------ [ 0, 1 ] 7804 9.563% 9.563% ## ( 1, 2 ] 52400 64.213% 73.776% ############# ( 2, 3 ] 11408 13.980% 87.756% ### ( 3, 4 ] 4823 5.910% 93.666% # ( 4, 6 ] 4226 5.179% 98.844% # ( 6, 10 ] 730 0.895% 99.739% ( 10, 15 ] 192 0.235% 99.974% ( 15, 22 ] 24 0.029% 100.004% ( 22, 34 ] 4 0.005% 100.009% ( 34, 51 ] 2 0.002% 100.011% ( 110, 170 ] 1 0.001% 100.012% ( 170, 250 ] 2 0.002% 100.015% ( 250, 380 ] 2 0.002% 100.017% ( 380, 580 ] 1 0.001% 100.018% ( 580, 870 ] 1 0.001% 100.020% ( 870, 1300 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 95445 Average: 2.1328 StdDev: 14.65 Min: 1 Median: 1.3946 Max: 2361 Percentiles: P50: 1.39 P75: 1.80 P99: 5.64 P99.9: 10.62 P99.99: 425.55 ------------------------------------------------------ [ 0, 1 ] 24657 25.834% 25.834% ##### ( 1, 2 ] 58457 61.247% 87.081% ############ ( 2, 3 ] 6435 6.742% 93.823% # ( 3, 4 ] 3287 3.444% 97.266% # ( 4, 6 ] 2015 2.111% 99.378% ( 6, 10 ] 489 0.512% 99.890% ( 10, 15 ] 77 0.081% 99.971% ( 15, 22 ] 6 0.006% 99.977% ( 22, 34 ] 6 0.006% 99.983% ( 76, 110 ] 1 0.001% 99.984% ( 170, 250 ] 1 0.001% 99.985% ( 250, 380 ] 4 0.004% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57583 Average: 3.9718 StdDev: 61.92 Min: 0 Median: 1.6235 Max: 5260 Percentiles: P50: 1.62 P75: 2.08 P99: 7.79 P99.9: 138.34 P99.99: 2149.08 ------------------------------------------------------ [ 0, 1 ] 5949 10.331% 10.331% ## ( 1, 2 ] 36634 63.619% 73.951% ############# ( 2, 3 ] 8007 13.905% 87.856% ### ( 3, 4 ] 3331 5.785% 93.640% # ( 4, 6 ] 2844 4.939% 98.579% # ( 6, 10 ] 541 0.940% 99.519% ( 10, 15 ] 142 0.247% 99.766% ( 15, 22 ] 25 0.043% 99.809% ( 22, 34 ] 37 0.064% 99.873% ( 34, 51 ] 14 0.024% 99.898% ( 110, 170 ] 3 0.005% 99.903% ( 170, 250 ] 5 0.009% 99.911% ( 250, 380 ] 7 0.012% 99.924% ( 380, 580 ] 11 0.019% 99.943% ( 580, 870 ] 14 0.024% 99.967% ( 870, 1300 ] 7 0.012% 99.979% ( 1300, 1900 ] 4 0.007% 99.986% ( 1900, 2900 ] 9 0.016% 100.002% ( 2900, 4400 ] 7 0.012% 100.014% ( 4400, 6600 ] 2 0.003% 100.017% ** Level 4 read latency histogram (micros): Count: 15 Average: 1856.4000 StdDev: 1234.49 Min: 462 Median: 1450.0000 Max: 4156 Percentiles: P50: 1450.00 P75: 2650.00 P99: 4156.00 P99.9: 4156.00 P99.99: 4156.00 ------------------------------------------------------ ( 380, 580 ] 2 13.333% 13.333% ### ( 580, 870 ] 2 13.333% 26.667% ### ( 870, 1300 ] 3 20.000% 46.667% #### ( 1300, 1900 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 40 Average: 649.5250 StdDev: 840.85 Min: 75 Median: 165.7143 Max: 3060 Percentiles: P50: 165.71 P75: 870.00 P99: 3060.00 P99.9: 3060.00 P99.99: 3060.00 ------------------------------------------------------ ( 51, 76 ] 1 2.500% 2.500% # ( 76, 110 ] 6 15.000% 17.500% ### ( 110, 170 ] 14 35.000% 52.500% ####### ( 170, 250 ] 1 2.500% 55.000% # ( 250, 380 ] 3 7.500% 62.500% ## ( 380, 580 ] 3 7.500% 70.000% ## ( 580, 870 ] 2 5.000% 75.000% # ( 870, 1300 ] 2 5.000% 80.000% # ( 1300, 1900 ] 4 10.000% 90.000% ## ( 1900, 2900 ] 3 7.500% 97.500% ## ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 320.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:1.031 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.88 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.434 H:M:S, 13.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-01:55:54 ... thread 0: (1000000,4000000) ops and (355408.2,337737.6) ops/second in (2.813666,11.843515) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 2.03 GB 12.6 2.4 0.0 2.4 6.1 3.7 0.0 1.6 123.6 313.7 19.87 18.59 63 0.315 2494K 2573 0.0 0.0 L1 5/5 552.99 MB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 240.1 239.2 6.04 5.89 2 3.021 1473K 5247 0.0 0.0 L2 2/0 54.87 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 16/0 902.89 MB 0.9 0.8 0.6 0.2 0.8 0.6 0.6 1.4 203.6 203.4 3.91 3.48 3 1.304 809K 883 0.0 0.0 L4 170/0 9.76 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1052/0 86.55 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/15 99.82 GB 0.0 5.0 2.2 2.8 8.6 5.8 4.0 2.3 162.3 282.7 31.32 29.41 70 0.447 5160K 8912 0.0 0.0 Int 0/0 0.00 KB 0.0 5.0 2.2 2.8 8.6 5.8 3.6 2.3 162.3 282.7 31.32 29.41 70 0.447 5160K 8912 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.0 2.2 2.8 5.0 2.1 0.0 0.0 245.3 244.8 20.72 19.92 16 1.295 5160K 8912 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 356.7 10.60 9.49 54 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.0 total, 11.8 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 8.65 GB write, 735.98 MB/s write, 4.96 GB read, 422.52 MB/s read, 31.3 seconds Interval compaction: 8.65 GB write, 747.41 MB/s write, 4.96 GB read, 429.09 MB/s read, 31.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1081553 Average: 2.0988 StdDev: 10.57 Min: 1 Median: 1.4407 Max: 4702 Percentiles: P50: 1.44 P75: 1.82 P99: 5.48 P99.9: 10.30 P99.99: 14.47 ------------------------------------------------------ [ 0, 1 ] 230079 21.273% 21.273% #### ( 1, 2 ] 704994 65.183% 86.457% ############# ( 2, 3 ] 84063 7.772% 94.229% ## ( 3, 4 ] 36384 3.364% 97.593% # ( 4, 6 ] 20587 1.903% 99.496% ( 6, 10 ] 4295 0.397% 99.894% ( 10, 15 ] 1167 0.108% 100.001% ( 15, 22 ] 112 0.010% 100.012% ( 22, 34 ] 12 0.001% 100.013% ( 34, 51 ] 8 0.001% 100.014% ( 51, 76 ] 7 0.001% 100.014% ( 76, 110 ] 1 0.000% 100.014% ( 110, 170 ] 20 0.002% 100.016% ( 170, 250 ] 33 0.003% 100.019% ( 250, 380 ] 24 0.002% 100.022% ( 380, 580 ] 9 0.001% 100.022% ( 580, 870 ] 18 0.002% 100.024% ( 870, 1300 ] 10 0.001% 100.025% ( 1300, 1900 ] 3 0.000% 100.025% ( 1900, 2900 ] 6 0.001% 100.026% ( 2900, 4400 ] 3 0.000% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 82374 Average: 2.6236 StdDev: 14.87 Min: 0 Median: 1.6290 Max: 2082 Percentiles: P50: 1.63 P75: 2.08 P99: 6.78 P99.9: 13.87 P99.99: 132.88 ------------------------------------------------------ [ 0, 1 ] 7909 9.601% 9.601% ## ( 1, 2 ] 52904 64.224% 73.825% ############# ( 2, 3 ] 11488 13.946% 87.772% ### ( 3, 4 ] 4866 5.907% 93.679% # ( 4, 6 ] 4240 5.147% 98.826% # ( 6, 10 ] 736 0.893% 99.720% ( 10, 15 ] 192 0.233% 99.953% ( 15, 22 ] 24 0.029% 99.982% ( 22, 34 ] 4 0.005% 99.987% ( 34, 51 ] 2 0.002% 99.989% ( 110, 170 ] 2 0.002% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 6 0.007% 100.001% ( 380, 580 ] 6 0.007% 100.008% ( 580, 870 ] 2 0.002% 100.011% ( 870, 1300 ] 5 0.006% 100.017% ( 1300, 1900 ] 2 0.002% 100.019% ( 1900, 2900 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 95445 Average: 2.1328 StdDev: 14.65 Min: 1 Median: 1.3946 Max: 2361 Percentiles: P50: 1.39 P75: 1.80 P99: 5.64 P99.9: 10.62 P99.99: 425.55 ------------------------------------------------------ [ 0, 1 ] 24657 25.834% 25.834% ##### ( 1, 2 ] 58457 61.247% 87.081% ############ ( 2, 3 ] 6435 6.742% 93.823% # ( 3, 4 ] 3287 3.444% 97.266% # ( 4, 6 ] 2015 2.111% 99.378% ( 6, 10 ] 489 0.512% 99.890% ( 10, 15 ] 77 0.081% 99.971% ( 15, 22 ] 6 0.006% 99.977% ( 22, 34 ] 6 0.006% 99.983% ( 76, 110 ] 1 0.001% 99.984% ( 170, 250 ] 1 0.001% 99.985% ( 250, 380 ] 4 0.004% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57583 Average: 3.9718 StdDev: 61.92 Min: 0 Median: 1.6235 Max: 5260 Percentiles: P50: 1.62 P75: 2.08 P99: 7.79 P99.9: 138.34 P99.99: 2149.08 ------------------------------------------------------ [ 0, 1 ] 5949 10.331% 10.331% ## ( 1, 2 ] 36634 63.619% 73.951% ############# ( 2, 3 ] 8007 13.905% 87.856% ### ( 3, 4 ] 3331 5.785% 93.640% # ( 4, 6 ] 2844 4.939% 98.579% # ( 6, 10 ] 541 0.940% 99.519% ( 10, 15 ] 142 0.247% 99.766% ( 15, 22 ] 25 0.043% 99.809% ( 22, 34 ] 37 0.064% 99.873% ( 34, 51 ] 14 0.024% 99.898% ( 110, 170 ] 3 0.005% 99.903% ( 170, 250 ] 5 0.009% 99.911% ( 250, 380 ] 7 0.012% 99.924% ( 380, 580 ] 11 0.019% 99.943% ( 580, 870 ] 14 0.024% 99.967% ( 870, 1300 ] 7 0.012% 99.979% ( 1300, 1900 ] 4 0.007% 99.986% ( 1900, 2900 ] 9 0.016% 100.002% ( 2900, 4400 ] 7 0.012% 100.014% ( 4400, 6600 ] 2 0.003% 100.017% ** Level 4 read latency histogram (micros): Count: 15 Average: 1856.4000 StdDev: 1234.49 Min: 462 Median: 1450.0000 Max: 4156 Percentiles: P50: 1450.00 P75: 2650.00 P99: 4156.00 P99.9: 4156.00 P99.99: 4156.00 ------------------------------------------------------ ( 380, 580 ] 2 13.333% 13.333% ### ( 580, 870 ] 2 13.333% 26.667% ### ( 870, 1300 ] 3 20.000% 46.667% #### ( 1300, 1900 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 60 Average: 704.9833 StdDev: 887.24 Min: 75 Median: 250.0000 Max: 3330 Percentiles: P50: 250.00 P75: 1013.33 P99: 3330.00 P99.9: 3330.00 P99.99: 3330.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 18 30.000% 48.333% ###### ( 170, 250 ] 1 1.667% 50.000% ( 250, 380 ] 5 8.333% 58.333% ## ( 380, 580 ] 7 11.667% 70.000% ## ( 580, 870 ] 2 3.333% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 6 10.000% 88.333% ## ( 1900, 2900 ] 5 8.333% 96.667% ## ( 2900, 4400 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 12.0 total, 2.8 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 327.27 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.225 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 349.79 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.194 H:M:S, 6.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/18-01:55:57 ... thread 0: (1000000,5000000) ops and (308043.3,331349.4) ops/second in (3.246297,15.089812) 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/14 3.01 GB 88.1 3.2 0.0 3.2 7.9 4.7 0.0 1.7 126.5 313.6 25.90 24.26 82 0.316 3326K 3401 0.0 0.0 L1 5/5 552.99 MB 0.0 1.4 1.4 0.0 1.4 1.4 0.2 1.0 240.1 239.2 6.04 5.89 2 3.021 1473K 5247 0.0 0.0 L2 2/0 54.87 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.9 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 16/0 902.89 MB 0.9 0.8 0.6 0.2 0.8 0.6 0.6 1.4 203.6 203.4 3.91 3.48 3 1.304 809K 883 0.0 0.0 L4 170/0 9.76 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1052/0 86.55 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/19 100.80 GB 0.0 5.8 2.2 3.6 10.5 6.9 4.0 2.2 158.0 287.6 37.35 35.07 89 0.420 5992K 9740 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 2.2 3.6 10.5 6.9 3.6 2.2 158.0 287.6 37.35 35.07 89 0.420 5992K 9740 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.8 2.2 3.6 5.8 2.1 0.0 0.0 248.2 247.8 23.78 22.93 19 1.251 5992K 9740 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 357.5 13.57 12.14 70 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): 15.3 total, 15.1 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.49 GB write, 703.24 MB/s write, 5.76 GB read, 386.34 MB/s read, 37.3 seconds Interval compaction: 10.49 GB write, 711.81 MB/s write, 5.76 GB read, 391.05 MB/s read, 37.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 15, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1515471 Average: 2.1197 StdDev: 9.94 Min: 1 Median: 1.4547 Max: 4702 Percentiles: P50: 1.45 P75: 1.83 P99: 5.49 P99.9: 10.00 P99.99: 14.30 ------------------------------------------------------ [ 0, 1 ] 302761 19.978% 19.978% #### ( 1, 2 ] 1000628 66.028% 86.006% ############# ( 2, 3 ] 123100 8.123% 94.128% ## ( 3, 4 ] 51841 3.421% 97.549% # ( 4, 6 ] 29446 1.943% 99.492% ( 6, 10 ] 6188 0.408% 99.901% ( 10, 15 ] 1577 0.104% 100.005% ( 15, 22 ] 135 0.009% 100.014% ( 22, 34 ] 13 0.001% 100.014% ( 34, 51 ] 11 0.001% 100.015% ( 51, 76 ] 13 0.001% 100.016% ( 76, 110 ] 25 0.002% 100.018% ( 110, 170 ] 50 0.003% 100.021% ( 170, 250 ] 57 0.004% 100.025% ( 250, 380 ] 34 0.002% 100.027% ( 380, 580 ] 17 0.001% 100.028% ( 580, 870 ] 27 0.002% 100.030% ( 870, 1300 ] 13 0.001% 100.031% ( 1300, 1900 ] 5 0.000% 100.031% ( 1900, 2900 ] 6 0.000% 100.031% ( 2900, 4400 ] 4 0.000% 100.032% ( 4400, 6600 ] 1 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 82374 Average: 2.6236 StdDev: 14.87 Min: 0 Median: 1.6290 Max: 2082 Percentiles: P50: 1.63 P75: 2.08 P99: 6.78 P99.9: 13.87 P99.99: 132.88 ------------------------------------------------------ [ 0, 1 ] 7909 9.601% 9.601% ## ( 1, 2 ] 52904 64.224% 73.825% ############# ( 2, 3 ] 11488 13.946% 87.772% ### ( 3, 4 ] 4866 5.907% 93.679% # ( 4, 6 ] 4240 5.147% 98.826% # ( 6, 10 ] 736 0.893% 99.720% ( 10, 15 ] 192 0.233% 99.953% ( 15, 22 ] 24 0.029% 99.982% ( 22, 34 ] 4 0.005% 99.987% ( 34, 51 ] 2 0.002% 99.989% ( 110, 170 ] 2 0.002% 99.992% ( 170, 250 ] 2 0.002% 99.994% ( 250, 380 ] 6 0.007% 100.001% ( 380, 580 ] 6 0.007% 100.008% ( 580, 870 ] 2 0.002% 100.011% ( 870, 1300 ] 5 0.006% 100.017% ( 1300, 1900 ] 2 0.002% 100.019% ( 1900, 2900 ] 1 0.001% 100.021% ** Level 2 read latency histogram (micros): Count: 95445 Average: 2.1328 StdDev: 14.65 Min: 1 Median: 1.3946 Max: 2361 Percentiles: P50: 1.39 P75: 1.80 P99: 5.64 P99.9: 10.62 P99.99: 425.55 ------------------------------------------------------ [ 0, 1 ] 24657 25.834% 25.834% ##### ( 1, 2 ] 58457 61.247% 87.081% ############ ( 2, 3 ] 6435 6.742% 93.823% # ( 3, 4 ] 3287 3.444% 97.266% # ( 4, 6 ] 2015 2.111% 99.378% ( 6, 10 ] 489 0.512% 99.890% ( 10, 15 ] 77 0.081% 99.971% ( 15, 22 ] 6 0.006% 99.977% ( 22, 34 ] 6 0.006% 99.983% ( 76, 110 ] 1 0.001% 99.984% ( 170, 250 ] 1 0.001% 99.985% ( 250, 380 ] 4 0.004% 99.990% ( 380, 580 ] 2 0.002% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57583 Average: 3.9718 StdDev: 61.92 Min: 0 Median: 1.6235 Max: 5260 Percentiles: P50: 1.62 P75: 2.08 P99: 7.79 P99.9: 138.34 P99.99: 2149.08 ------------------------------------------------------ [ 0, 1 ] 5949 10.331% 10.331% ## ( 1, 2 ] 36634 63.619% 73.951% ############# ( 2, 3 ] 8007 13.905% 87.856% ### ( 3, 4 ] 3331 5.785% 93.640% # ( 4, 6 ] 2844 4.939% 98.579% # ( 6, 10 ] 541 0.940% 99.519% ( 10, 15 ] 142 0.247% 99.766% ( 15, 22 ] 25 0.043% 99.809% ( 22, 34 ] 37 0.064% 99.873% ( 34, 51 ] 14 0.024% 99.898% ( 110, 170 ] 3 0.005% 99.903% ( 170, 250 ] 5 0.009% 99.911% ( 250, 380 ] 7 0.012% 99.924% ( 380, 580 ] 11 0.019% 99.943% ( 580, 870 ] 14 0.024% 99.967% ( 870, 1300 ] 7 0.012% 99.979% ( 1300, 1900 ] 4 0.007% 99.986% ( 1900, 2900 ] 9 0.016% 100.002% ( 2900, 4400 ] 7 0.012% 100.014% ( 4400, 6600 ] 2 0.003% 100.017% ** Level 4 read latency histogram (micros): Count: 15 Average: 1856.4000 StdDev: 1234.49 Min: 462 Median: 1450.0000 Max: 4156 Percentiles: P50: 1450.00 P75: 2650.00 P99: 4156.00 P99.9: 4156.00 P99.99: 4156.00 ------------------------------------------------------ ( 380, 580 ] 2 13.333% 13.333% ### ( 580, 870 ] 2 13.333% 26.667% ### ( 870, 1300 ] 3 20.000% 46.667% #### ( 1300, 1900 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 60 Average: 704.9833 StdDev: 887.24 Min: 75 Median: 250.0000 Max: 3330 Percentiles: P50: 250.00 P75: 1013.33 P99: 3330.00 P99.9: 3330.00 P99.99: 3330.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 18 30.000% 48.333% ###### ( 170, 250 ] 1 1.667% 50.000% ( 250, 380 ] 5 8.333% 58.333% ## ( 380, 580 ] 7 11.667% 70.000% ## ( 580, 870 ] 2 3.333% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 6 10.000% 88.333% ## ( 1900, 2900 ] 5 8.333% 96.667% ## ( 2900, 4400 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 15.3 total, 3.2 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 322.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.762 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 303.18 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.537 H:M:S, 16.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-01:56:05 ... thread 0: (1000000,6000000) ops and (130034.2,263387.8) ops/second in (7.690284,22.780096) 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.03 GB 75.5 4.2 0.0 4.2 9.8 5.6 0.0 1.7 133.2 311.3 32.16 30.18 100 0.322 4349K 4381 0.0 0.0 L1 5/0 440.88 MB 44.1 3.9 3.3 0.5 3.8 3.3 0.2 1.2 233.2 231.2 16.96 16.45 3 5.654 4016K 33K 0.0 0.0 L2 10/6 1.06 GB 5.2 0.4 0.2 0.2 0.4 0.2 2.9 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 24/17 1.86 GB 0.9 0.8 0.6 0.2 0.8 0.6 1.6 1.4 203.6 203.4 3.91 3.48 3 1.304 809K 883 0.0 0.0 L4 170/3 9.76 GB 1.0 0.0 0.0 0.0 0.0 0.0 1.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1052/0 86.55 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 1272/32 101.70 GB 0.0 9.2 4.1 5.1 14.8 9.6 7.0 2.6 172.6 277.0 54.53 51.55 108 0.505 9558K 38K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.2 4.1 5.1 14.8 9.6 6.5 2.6 172.6 277.0 54.53 51.55 108 0.505 9558K 38K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.2 4.1 5.1 9.2 4.0 0.0 0.0 244.6 243.6 38.48 37.19 24 1.603 9558K 38K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 357.3 16.05 14.36 84 0.191 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.0 total, 22.8 interval Flush(GB): cumulative 5.599, interval 5.599 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.75 GB write, 657.81 MB/s write, 9.19 GB read, 409.90 MB/s read, 54.5 seconds Interval compaction: 14.75 GB write, 663.13 MB/s write, 9.19 GB read, 413.21 MB/s read, 54.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 15, interval: 29 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2259728 Average: 2.1585 StdDev: 10.12 Min: 1 Median: 1.4550 Max: 4702 Percentiles: P50: 1.46 P75: 1.83 P99: 5.63 P99.9: 11.08 P99.99: 28.02 ------------------------------------------------------ [ 0, 1 ] 445488 19.714% 19.714% #### ( 1, 2 ] 1503984 66.556% 86.270% ############# ( 2, 3 ] 179106 7.926% 94.196% ## ( 3, 4 ] 74599 3.301% 97.497% # ( 4, 6 ] 41647 1.843% 99.340% ( 6, 10 ] 12141 0.537% 99.878% ( 10, 15 ] 2334 0.103% 99.981% ( 15, 22 ] 196 0.009% 99.990% ( 22, 34 ] 16 0.001% 99.990% ( 34, 51 ] 12 0.001% 99.991% ( 51, 76 ] 15 0.001% 99.992% ( 76, 110 ] 190 0.008% 100.000% ( 110, 170 ] 297 0.013% 100.013% ( 170, 250 ] 123 0.005% 100.019% ( 250, 380 ] 86 0.004% 100.022% ( 380, 580 ] 52 0.002% 100.025% ( 580, 870 ] 54 0.002% 100.027% ( 870, 1300 ] 20 0.001% 100.028% ( 1300, 1900 ] 8 0.000% 100.028% ( 1900, 2900 ] 8 0.000% 100.029% ( 2900, 4400 ] 6 0.000% 100.029% ( 4400, 6600 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 290072 Average: 4.9101 StdDev: 76.79 Min: 0 Median: 1.6049 Max: 8148 Percentiles: P50: 1.60 P75: 2.01 P99: 9.01 P99.9: 298.93 P99.99: 753.98 ------------------------------------------------------ [ 0, 1 ] 34490 11.890% 11.890% ## ( 1, 2 ] 182743 62.999% 74.889% ############# ( 2, 3 ] 36289 12.510% 87.400% ### ( 3, 4 ] 15779 5.440% 92.839% # ( 4, 6 ] 14289 4.926% 97.765% # ( 6, 10 ] 4756 1.640% 99.405% ( 10, 15 ] 804 0.277% 99.682% ( 15, 22 ] 104 0.036% 99.718% ( 22, 34 ] 14 0.005% 99.723% ( 34, 51 ] 6 0.002% 99.725% ( 51, 76 ] 23 0.008% 99.733% ( 76, 110 ] 160 0.055% 99.788% ( 110, 170 ] 133 0.046% 99.834% ( 170, 250 ] 144 0.050% 99.883% ( 250, 380 ] 130 0.045% 99.928% ( 380, 580 ] 123 0.042% 99.971% ( 580, 870 ] 95 0.033% 100.003% ( 870, 1300 ] 61 0.021% 100.024% ( 1300, 1900 ] 31 0.011% 100.035% ( 1900, 2900 ] 44 0.015% 100.050% ( 2900, 4400 ] 52 0.018% 100.068% ( 4400, 6600 ] 15 0.005% 100.073% ( 6600, 9900 ] 3 0.001% 100.074% ** Level 2 read latency histogram (micros): Count: 95721 Average: 2.3453 StdDev: 17.60 Min: 1 Median: 1.3965 Max: 2361 Percentiles: P50: 1.40 P75: 1.81 P99: 5.72 P99.9: 14.76 P99.99: 846.30 ------------------------------------------------------ [ 0, 1 ] 24657 25.759% 25.759% ##### ( 1, 2 ] 58516 61.132% 86.891% ############ ( 2, 3 ] 6545 6.838% 93.729% # ( 3, 4 ] 3303 3.451% 97.179% # ( 4, 6 ] 2032 2.123% 99.302% ( 6, 10 ] 497 0.519% 99.821% ( 10, 15 ] 79 0.083% 99.904% ( 15, 22 ] 6 0.006% 99.910% ( 22, 34 ] 6 0.006% 99.916% ( 76, 110 ] 1 0.001% 99.917% ( 110, 170 ] 15 0.016% 99.933% ( 170, 250 ] 15 0.016% 99.949% ( 250, 380 ] 26 0.027% 99.976% ( 380, 580 ] 7 0.007% 99.983% ( 580, 870 ] 7 0.007% 99.991% ( 870, 1300 ] 4 0.004% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 72663 Average: 8.4225 StdDev: 123.83 Min: 0 Median: 1.6799 Max: 7994 Percentiles: P50: 1.68 P75: 2.37 P99: 10.22 P99.9: 1711.23 P99.99: 4118.19 ------------------------------------------------------ [ 0, 1 ] 6487 8.928% 8.928% ## ( 1, 2 ] 43894 60.408% 69.335% ############ ( 2, 3 ] 11180 15.386% 84.721% ### ( 3, 4 ] 4939 6.797% 91.518% # ( 4, 6 ] 4431 6.098% 97.616% # ( 6, 10 ] 993 1.367% 98.983% ( 10, 15 ] 279 0.384% 99.367% ( 15, 22 ] 50 0.069% 99.436% ( 22, 34 ] 38 0.052% 99.488% ( 34, 51 ] 14 0.019% 99.507% ( 51, 76 ] 3 0.004% 99.511% ( 76, 110 ] 5 0.007% 99.518% ( 110, 170 ] 17 0.023% 99.542% ( 170, 250 ] 39 0.054% 99.595% ( 250, 380 ] 52 0.072% 99.667% ( 380, 580 ] 79 0.109% 99.776% ( 580, 870 ] 44 0.061% 99.836% ( 870, 1300 ] 34 0.047% 99.883% ( 1300, 1900 ] 18 0.025% 99.908% ( 1900, 2900 ] 24 0.033% 99.941% ( 2900, 4400 ] 44 0.061% 100.001% ( 4400, 6600 ] 8 0.011% 100.012% ( 6600, 9900 ] 1 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 15 Average: 1856.4000 StdDev: 1234.49 Min: 462 Median: 1450.0000 Max: 4156 Percentiles: P50: 1450.00 P75: 2650.00 P99: 4156.00 P99.9: 4156.00 P99.99: 4156.00 ------------------------------------------------------ ( 380, 580 ] 2 13.333% 13.333% ### ( 580, 870 ] 2 13.333% 26.667% ### ( 870, 1300 ] 3 20.000% 46.667% #### ( 1300, 1900 ] 2 13.333% 60.000% ### ( 1900, 2900 ] 3 20.000% 80.000% #### ( 2900, 4400 ] 3 20.000% 100.000% #### ** Level 5 read latency histogram (micros): Count: 60 Average: 704.9833 StdDev: 887.24 Min: 75 Median: 250.0000 Max: 3330 Percentiles: P50: 250.00 P75: 1013.33 P99: 3330.00 P99.9: 3330.00 P99.99: 3330.00 ------------------------------------------------------ ( 51, 76 ] 1 1.667% 1.667% ( 76, 110 ] 10 16.667% 18.333% ### ( 110, 170 ] 18 30.000% 48.333% ###### ( 170, 250 ] 1 1.667% 50.000% ( 250, 380 ] 5 8.333% 58.333% ## ( 380, 580 ] 7 11.667% 70.000% ## ( 580, 870 ] 2 3.333% 73.333% # ( 870, 1300 ] 3 5.000% 78.333% # ( 1300, 1900 ] 6 10.000% 88.333% ## ( 1900, 2900 ] 5 8.333% 96.667% ## ( 2900, 4400 ] 2 3.333% 100.000% # ** DB Stats ** Uptime(secs): 23.0 total, 7.7 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 257.13 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.509 H:M:S, 28.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 127.98 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.747 H:M:S, 61.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/11/18-01:56:11 ... thread 0: (1000000,7000000) ops and (177574.1,246378.7) ops/second in (5.631453,28.411549) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 3.00 GB 44.0 6.1 0.0 6.1 12.7 6.6 0.0 1.9 134.6 279.8 46.33 40.30 115 0.403 6331K 12K 0.0 0.0 L1 5/5 440.88 MB 0.0 3.9 3.3 0.5 3.8 3.3 0.2 1.2 233.2 231.2 16.96 16.45 3 5.654 4016K 33K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.9 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 14/0 995.31 MB 1.0 3.2 1.6 1.6 3.2 1.6 1.6 2.0 145.7 145.2 22.30 14.78 13 1.716 3301K 12K 0.0 0.0 L4 179/0 9.72 GB 1.0 2.1 1.7 0.4 2.1 1.7 1.4 1.2 137.7 137.0 15.43 9.91 34 0.454 2079K 8943 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1286/15 102.65 GB 0.0 15.6 6.8 8.7 22.1 13.3 9.1 3.4 155.5 220.6 102.52 82.89 167 0.614 16M 66K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.6 6.8 8.7 22.1 13.3 8.7 3.4 155.5 220.6 102.52 82.89 167 0.614 16M 66K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.6 6.8 8.7 15.5 6.8 0.0 0.0 196.6 195.7 81.11 65.79 71 1.142 16M 66K 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 314.8 21.41 17.10 96 0.223 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.6 total, 28.4 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.08 GB write, 790.80 MB/s write, 15.57 GB read, 557.54 MB/s read, 102.5 seconds Interval compaction: 22.08 GB write, 795.93 MB/s write, 15.57 GB read, 561.15 MB/s read, 102.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 54, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 54, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2683507 Average: 2.4772 StdDev: 26.87 Min: 1 Median: 1.4949 Max: 8569 Percentiles: P50: 1.49 P75: 1.88 P99: 5.96 P99.9: 12.94 P99.99: 129.94 ------------------------------------------------------ [ 0, 1 ] 477595 17.797% 17.797% #### ( 1, 2 ] 1746224 65.072% 82.870% ############# ( 2, 3 ] 250662 9.341% 92.211% ## ( 3, 4 ] 108040 4.026% 96.237% # ( 4, 6 ] 75686 2.820% 99.057% # ( 6, 10 ] 20304 0.757% 99.814% ( 10, 15 ] 3934 0.147% 99.960% ( 15, 22 ] 398 0.015% 99.975% ( 22, 34 ] 34 0.001% 99.977% ( 34, 51 ] 14 0.001% 99.977% ( 51, 76 ] 20 0.001% 99.978% ( 76, 110 ] 219 0.008% 99.986% ( 110, 170 ] 330 0.012% 99.998% ( 170, 250 ] 165 0.006% 100.004% ( 250, 380 ] 143 0.005% 100.010% ( 380, 580 ] 151 0.006% 100.015% ( 580, 870 ] 165 0.006% 100.022% ( 870, 1300 ] 89 0.003% 100.025% ( 1300, 1900 ] 50 0.002% 100.027% ( 1900, 2900 ] 43 0.002% 100.028% ( 2900, 4400 ] 44 0.002% 100.030% ( 4400, 6600 ] 13 0.000% 100.030% ( 6600, 9900 ] 7 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 692246 Average: 6.1599 StdDev: 105.54 Min: 0 Median: 1.7751 Max: 10760 Percentiles: P50: 1.78 P75: 2.72 P99: 9.54 P99.9: 131.71 P99.99: 565.92 ------------------------------------------------------ [ 0, 1 ] 46544 6.724% 6.724% # ( 1, 2 ] 386508 55.834% 62.558% ########### ( 2, 3 ] 119336 17.239% 79.796% ### ( 3, 4 ] 58279 8.419% 88.215% ## ( 4, 6 ] 60431 8.730% 96.945% ## ( 6, 10 ] 16060 2.320% 99.265% ( 10, 15 ] 3625 0.524% 99.789% ( 15, 22 ] 476 0.069% 99.857% ( 22, 34 ] 43 0.006% 99.864% ( 34, 51 ] 11 0.002% 99.865% ( 51, 76 ] 27 0.004% 99.869% ( 76, 110 ] 162 0.023% 99.893% ( 110, 170 ] 143 0.021% 99.913% ( 170, 250 ] 160 0.023% 99.936% ( 250, 380 ] 184 0.027% 99.963% ( 380, 580 ] 202 0.029% 99.992% ( 580, 870 ] 205 0.030% 100.022% ( 870, 1300 ] 142 0.021% 100.042% ( 1300, 1900 ] 90 0.013% 100.055% ( 1900, 2900 ] 170 0.025% 100.080% ( 2900, 4400 ] 197 0.028% 100.108% ( 4400, 6600 ] 75 0.011% 100.119% ( 6600, 9900 ] 24 0.003% 100.122% ( 9900, 14000 ] 2 0.000% 100.123% ** Level 2 read latency histogram (micros): Count: 124201 Average: 4.7166 StdDev: 79.57 Min: 1 Median: 1.5118 Max: 6312 Percentiles: P50: 1.51 P75: 1.94 P99: 8.38 P99.9: 654.39 P99.99: 4176.95 ------------------------------------------------------ [ 0, 1 ] 25253 20.332% 20.332% #### ( 1, 2 ] 72001 57.971% 78.304% ############ ( 2, 3 ] 13158 10.594% 88.898% ## ( 3, 4 ] 6380 5.137% 94.035% # ( 4, 6 ] 5311 4.276% 98.311% # ( 6, 10 ] 1441 1.160% 99.471% ( 10, 15 ] 330 0.266% 99.737% ( 15, 22 ] 37 0.030% 99.767% ( 22, 34 ] 7 0.006% 99.772% ( 76, 110 ] 1 0.001% 99.773% ( 110, 170 ] 19 0.015% 99.788% ( 170, 250 ] 23 0.019% 99.807% ( 250, 380 ] 52 0.042% 99.849% ( 380, 580 ] 52 0.042% 99.891% ( 580, 870 ] 46 0.037% 99.928% ( 870, 1300 ] 23 0.019% 99.946% ( 1300, 1900 ] 19 0.015% 99.961% ( 1900, 2900 ] 16 0.013% 99.974% ( 2900, 4400 ] 23 0.019% 99.993% ( 4400, 6600 ] 9 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 716423 Average: 7.6444 StdDev: 98.11 Min: 0 Median: 1.9049 Max: 9140 Percentiles: P50: 1.90 P75: 2.98 P99: 9.50 P99.9: 435.08 P99.99: 623.87 ------------------------------------------------------ [ 0, 1 ] 25395 3.545% 3.545% # ( 1, 2 ] 367780 51.336% 54.880% ########## ( 2, 3 ] 147678 20.613% 75.494% #### ( 3, 4 ] 77821 10.862% 86.356% ## ( 4, 6 ] 78168 10.911% 97.267% ## ( 6, 10 ] 14177 1.979% 99.246% ( 10, 15 ] 3079 0.430% 99.675% ( 15, 22 ] 356 0.050% 99.725% ( 22, 34 ] 64 0.009% 99.734% ( 34, 51 ] 28 0.004% 99.738% ( 51, 76 ] 11 0.002% 99.740% ( 76, 110 ] 36 0.005% 99.745% ( 110, 170 ] 193 0.027% 99.772% ( 170, 250 ] 275 0.038% 99.810% ( 250, 380 ] 444 0.062% 99.872% ( 380, 580 ] 732 0.102% 99.974% ( 580, 870 ] 756 0.106% 100.080% ( 870, 1300 ] 548 0.076% 100.156% ( 1300, 1900 ] 191 0.027% 100.183% ( 1900, 2900 ] 155 0.022% 100.204% ( 2900, 4400 ] 220 0.031% 100.235% ( 4400, 6600 ] 40 0.006% 100.241% ( 6600, 9900 ] 8 0.001% 100.242% ** Level 4 read latency histogram (micros): Count: 360 Average: 242.6167 StdDev: 728.97 Min: 0 Median: 2.5833 Max: 7885 Percentiles: P50: 2.58 P75: 123.85 P99: 3620.00 P99.9: 7885.00 P99.99: 7885.00 ------------------------------------------------------ [ 0, 1 ] 43 11.944% 11.944% ## ( 1, 2 ] 102 28.333% 40.278% ###### ( 2, 3 ] 60 16.667% 56.944% ### ( 3, 4 ] 28 7.778% 64.722% ## ( 4, 6 ] 14 3.889% 68.611% # ( 6, 10 ] 9 2.500% 71.111% # ( 10, 15 ] 6 1.667% 72.778% ( 15, 22 ] 3 0.833% 73.611% ( 22, 34 ] 2 0.556% 74.167% ( 110, 170 ] 13 3.611% 77.778% # ( 170, 250 ] 23 6.389% 84.167% # ( 250, 380 ] 5 1.389% 85.556% ( 380, 580 ] 10 2.778% 88.333% # ( 580, 870 ] 10 2.778% 91.111% # ( 870, 1300 ] 13 3.611% 94.722% # ( 1300, 1900 ] 7 1.944% 96.667% ( 1900, 2900 ] 6 1.667% 98.333% ( 2900, 4400 ] 5 1.389% 99.722% ( 6600, 9900 ] 1 0.278% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1298.1556 StdDev: 1635.58 Min: 75 Median: 597.0588 Max: 8573 Percentiles: P50: 597.06 P75: 1860.00 P99: 8415.00 P99.9: 8573.00 P99.99: 8573.00 ------------------------------------------------------ ( 51, 76 ] 1 0.556% 0.556% ( 76, 110 ] 14 7.778% 8.333% ## ( 110, 170 ] 28 15.556% 23.889% ### ( 170, 250 ] 11 6.111% 30.000% # ( 250, 380 ] 15 8.333% 38.333% ## ( 380, 580 ] 20 11.111% 49.444% ## ( 580, 870 ] 17 9.444% 58.889% ## ( 870, 1300 ] 15 8.333% 67.222% ## ( 1300, 1900 ] 15 8.333% 75.556% ## ( 1900, 2900 ] 20 11.111% 86.667% ## ( 2900, 4400 ] 14 7.778% 94.444% ## ( 4400, 6600 ] 6 3.333% 97.778% # ( 6600, 9900 ] 4 2.222% 100.000% ** DB Stats ** Uptime(secs): 28.6 total, 5.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 240.91 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.069 H:M:S, 31.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 174.77 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.560 H:M:S, 45.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-01:56:14 ... thread 0: (1000000,8000000) ops and (325872.9,254127.7) ops/second in (3.068681,31.480230) 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/10 3.99 GB 144.7 6.9 0.0 6.9 14.4 7.6 0.0 1.9 134.9 282.8 52.31 45.91 132 0.396 7163K 13K 0.0 0.0 L1 5/5 440.88 MB 0.0 3.9 3.3 0.5 3.8 3.3 0.2 1.2 233.2 231.2 16.96 16.45 3 5.654 4016K 33K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.9 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 14/0 995.31 MB 1.0 3.2 1.6 1.6 3.2 1.6 1.6 2.0 145.7 145.2 22.30 14.78 13 1.716 3301K 12K 0.0 0.0 L4 179/0 9.72 GB 1.0 2.1 1.7 0.4 2.1 1.7 1.4 1.2 137.7 137.0 15.43 9.91 34 0.454 2079K 8943 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1291/15 103.63 GB 0.0 16.4 6.8 9.5 23.9 14.3 9.1 3.2 154.5 225.3 108.49 88.50 184 0.590 16M 67K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.4 6.8 9.5 23.9 14.3 8.7 3.2 154.5 225.3 108.49 88.50 184 0.590 16M 67K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 16.4 6.8 9.5 16.3 6.8 0.0 0.0 199.1 198.3 84.18 68.81 74 1.138 16M 67K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 318.8 24.31 19.69 110 0.221 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 31.7 total, 31.5 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 23.87 GB write, 771.84 MB/s write, 16.37 GB read, 529.37 MB/s read, 108.5 seconds Interval compaction: 23.87 GB write, 776.35 MB/s write, 16.37 GB read, 532.47 MB/s read, 108.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 58, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 14, total-stops: 58, interval: 72 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3077178 Average: 2.4523 StdDev: 25.29 Min: 1 Median: 1.4991 Max: 8569 Percentiles: P50: 1.50 P75: 1.88 P99: 5.97 P99.9: 12.72 P99.99: 110.89 ------------------------------------------------------ [ 0, 1 ] 534601 17.373% 17.373% ### ( 1, 2 ] 2011615 65.372% 82.745% ############# ( 2, 3 ] 294640 9.575% 92.320% ## ( 3, 4 ] 122131 3.969% 96.289% # ( 4, 6 ] 84712 2.753% 99.042% # ( 6, 10 ] 24009 0.780% 99.822% ( 10, 15 ] 4406 0.143% 99.965% ( 15, 22 ] 440 0.014% 99.980% ( 22, 34 ] 36 0.001% 99.981% ( 34, 51 ] 16 0.001% 99.981% ( 51, 76 ] 22 0.001% 99.982% ( 76, 110 ] 238 0.008% 99.990% ( 110, 170 ] 357 0.012% 100.001% ( 170, 250 ] 191 0.006% 100.008% ( 250, 380 ] 156 0.005% 100.013% ( 380, 580 ] 163 0.005% 100.018% ( 580, 870 ] 174 0.006% 100.024% ( 870, 1300 ] 96 0.003% 100.027% ( 1300, 1900 ] 51 0.002% 100.028% ( 1900, 2900 ] 43 0.001% 100.030% ( 2900, 4400 ] 45 0.001% 100.031% ( 4400, 6600 ] 13 0.000% 100.032% ( 6600, 9900 ] 7 0.000% 100.032% ** Level 1 read latency histogram (micros): Count: 692246 Average: 6.1599 StdDev: 105.54 Min: 0 Median: 1.7751 Max: 10760 Percentiles: P50: 1.78 P75: 2.72 P99: 9.54 P99.9: 131.71 P99.99: 565.92 ------------------------------------------------------ [ 0, 1 ] 46544 6.724% 6.724% # ( 1, 2 ] 386508 55.834% 62.558% ########### ( 2, 3 ] 119336 17.239% 79.796% ### ( 3, 4 ] 58279 8.419% 88.215% ## ( 4, 6 ] 60431 8.730% 96.945% ## ( 6, 10 ] 16060 2.320% 99.265% ( 10, 15 ] 3625 0.524% 99.789% ( 15, 22 ] 476 0.069% 99.857% ( 22, 34 ] 43 0.006% 99.864% ( 34, 51 ] 11 0.002% 99.865% ( 51, 76 ] 27 0.004% 99.869% ( 76, 110 ] 162 0.023% 99.893% ( 110, 170 ] 143 0.021% 99.913% ( 170, 250 ] 160 0.023% 99.936% ( 250, 380 ] 184 0.027% 99.963% ( 380, 580 ] 202 0.029% 99.992% ( 580, 870 ] 205 0.030% 100.022% ( 870, 1300 ] 142 0.021% 100.042% ( 1300, 1900 ] 90 0.013% 100.055% ( 1900, 2900 ] 170 0.025% 100.080% ( 2900, 4400 ] 197 0.028% 100.108% ( 4400, 6600 ] 75 0.011% 100.119% ( 6600, 9900 ] 24 0.003% 100.122% ( 9900, 14000 ] 2 0.000% 100.123% ** Level 2 read latency histogram (micros): Count: 124201 Average: 4.7166 StdDev: 79.57 Min: 1 Median: 1.5118 Max: 6312 Percentiles: P50: 1.51 P75: 1.94 P99: 8.38 P99.9: 654.39 P99.99: 4176.95 ------------------------------------------------------ [ 0, 1 ] 25253 20.332% 20.332% #### ( 1, 2 ] 72001 57.971% 78.304% ############ ( 2, 3 ] 13158 10.594% 88.898% ## ( 3, 4 ] 6380 5.137% 94.035% # ( 4, 6 ] 5311 4.276% 98.311% # ( 6, 10 ] 1441 1.160% 99.471% ( 10, 15 ] 330 0.266% 99.737% ( 15, 22 ] 37 0.030% 99.767% ( 22, 34 ] 7 0.006% 99.772% ( 76, 110 ] 1 0.001% 99.773% ( 110, 170 ] 19 0.015% 99.788% ( 170, 250 ] 23 0.019% 99.807% ( 250, 380 ] 52 0.042% 99.849% ( 380, 580 ] 52 0.042% 99.891% ( 580, 870 ] 46 0.037% 99.928% ( 870, 1300 ] 23 0.019% 99.946% ( 1300, 1900 ] 19 0.015% 99.961% ( 1900, 2900 ] 16 0.013% 99.974% ( 2900, 4400 ] 23 0.019% 99.993% ( 4400, 6600 ] 9 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 716423 Average: 7.6444 StdDev: 98.11 Min: 0 Median: 1.9049 Max: 9140 Percentiles: P50: 1.90 P75: 2.98 P99: 9.50 P99.9: 435.08 P99.99: 623.87 ------------------------------------------------------ [ 0, 1 ] 25395 3.545% 3.545% # ( 1, 2 ] 367780 51.336% 54.880% ########## ( 2, 3 ] 147678 20.613% 75.494% #### ( 3, 4 ] 77821 10.862% 86.356% ## ( 4, 6 ] 78168 10.911% 97.267% ## ( 6, 10 ] 14177 1.979% 99.246% ( 10, 15 ] 3079 0.430% 99.675% ( 15, 22 ] 356 0.050% 99.725% ( 22, 34 ] 64 0.009% 99.734% ( 34, 51 ] 28 0.004% 99.738% ( 51, 76 ] 11 0.002% 99.740% ( 76, 110 ] 36 0.005% 99.745% ( 110, 170 ] 193 0.027% 99.772% ( 170, 250 ] 275 0.038% 99.810% ( 250, 380 ] 444 0.062% 99.872% ( 380, 580 ] 732 0.102% 99.974% ( 580, 870 ] 756 0.106% 100.080% ( 870, 1300 ] 548 0.076% 100.156% ( 1300, 1900 ] 191 0.027% 100.183% ( 1900, 2900 ] 155 0.022% 100.204% ( 2900, 4400 ] 220 0.031% 100.235% ( 4400, 6600 ] 40 0.006% 100.241% ( 6600, 9900 ] 8 0.001% 100.242% ** Level 4 read latency histogram (micros): Count: 360 Average: 242.6167 StdDev: 728.97 Min: 0 Median: 2.5833 Max: 7885 Percentiles: P50: 2.58 P75: 123.85 P99: 3620.00 P99.9: 7885.00 P99.99: 7885.00 ------------------------------------------------------ [ 0, 1 ] 43 11.944% 11.944% ## ( 1, 2 ] 102 28.333% 40.278% ###### ( 2, 3 ] 60 16.667% 56.944% ### ( 3, 4 ] 28 7.778% 64.722% ## ( 4, 6 ] 14 3.889% 68.611% # ( 6, 10 ] 9 2.500% 71.111% # ( 10, 15 ] 6 1.667% 72.778% ( 15, 22 ] 3 0.833% 73.611% ( 22, 34 ] 2 0.556% 74.167% ( 110, 170 ] 13 3.611% 77.778% # ( 170, 250 ] 23 6.389% 84.167% # ( 250, 380 ] 5 1.389% 85.556% ( 380, 580 ] 10 2.778% 88.333% # ( 580, 870 ] 10 2.778% 91.111% # ( 870, 1300 ] 13 3.611% 94.722% # ( 1300, 1900 ] 7 1.944% 96.667% ( 1900, 2900 ] 6 1.667% 98.333% ( 2900, 4400 ] 5 1.389% 99.722% ( 6600, 9900 ] 1 0.278% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1298.1556 StdDev: 1635.58 Min: 75 Median: 597.0588 Max: 8573 Percentiles: P50: 597.06 P75: 1860.00 P99: 8415.00 P99.9: 8573.00 P99.99: 8573.00 ------------------------------------------------------ ( 51, 76 ] 1 0.556% 0.556% ( 76, 110 ] 14 7.778% 8.333% ## ( 110, 170 ] 28 15.556% 23.889% ### ( 170, 250 ] 11 6.111% 30.000% # ( 250, 380 ] 15 8.333% 38.333% ## ( 380, 580 ] 20 11.111% 49.444% ## ( 580, 870 ] 17 9.444% 58.889% ## ( 870, 1300 ] 15 8.333% 67.222% ## ( 1300, 1900 ] 15 8.333% 75.556% ## ( 1900, 2900 ] 20 11.111% 86.667% ## ( 2900, 4400 ] 14 7.778% 94.444% ## ( 4400, 6600 ] 6 3.333% 97.778% # ( 6600, 9900 ] 4 2.222% 100.000% ** DB Stats ** Uptime(secs): 31.7 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 248.64 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.479 H:M:S, 29.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.72 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.410 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/18-01:56:18 ... thread 0: (1000000,9000000) ops and (252783.1,253977.6) ops/second in (3.955961,35.436191) 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/6 4.97 GB 276.9 8.0 0.0 8.0 16.5 8.5 0.0 1.9 137.9 285.1 59.39 52.62 150 0.396 8314K 14K 0.0 0.0 L1 5/5 440.88 MB 0.0 3.9 3.3 0.5 3.8 3.3 0.2 1.2 233.2 231.2 16.96 16.45 3 5.654 4016K 33K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.9 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 14/0 995.31 MB 1.0 3.2 1.6 1.6 3.2 1.6 1.6 2.0 145.7 145.2 22.30 14.78 13 1.716 3301K 12K 0.0 0.0 L4 179/0 9.72 GB 1.0 2.1 1.7 0.4 2.1 1.7 1.4 1.2 137.7 137.0 15.43 9.91 34 0.454 2079K 8943 0.0 0.0 L5 1076/0 88.52 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1293/11 104.62 GB 0.0 17.5 6.8 10.6 26.0 15.3 9.1 3.0 154.9 230.0 115.57 95.21 202 0.572 18M 68K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.5 6.8 10.6 26.0 15.3 8.7 3.0 154.9 230.0 115.57 95.21 202 0.572 18M 68K 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 17.5 6.8 10.6 17.4 6.8 0.0 0.0 202.4 201.5 88.44 73.00 78 1.134 18M 68K 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 322.8 27.13 22.21 124 0.219 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 35.6 total, 35.4 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: 25.96 GB write, 746.21 MB/s write, 17.48 GB read, 502.42 MB/s read, 115.6 seconds Interval compaction: 25.96 GB write, 750.09 MB/s write, 17.48 GB read, 505.03 MB/s read, 115.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 19, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 19, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 60, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 19, total-stops: 60, interval: 79 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3532860 Average: 2.4254 StdDev: 23.86 Min: 1 Median: 1.5012 Max: 8569 Percentiles: P50: 1.50 P75: 1.88 P99: 5.97 P99.9: 12.49 P99.99: 87.17 ------------------------------------------------------ [ 0, 1 ] 604170 17.101% 17.101% ### ( 1, 2 ] 2318919 65.639% 82.740% ############# ( 2, 3 ] 341889 9.677% 92.417% ## ( 3, 4 ] 138732 3.927% 96.344% # ( 4, 6 ] 95014 2.689% 99.034% # ( 6, 10 ] 28122 0.796% 99.830% ( 10, 15 ] 4988 0.141% 99.971% ( 15, 22 ] 499 0.014% 99.985% ( 22, 34 ] 40 0.001% 99.986% ( 34, 51 ] 18 0.001% 99.987% ( 51, 76 ] 28 0.001% 99.988% ( 76, 110 ] 267 0.008% 99.995% ( 110, 170 ] 386 0.011% 100.006% ( 170, 250 ] 211 0.006% 100.012% ( 250, 380 ] 169 0.005% 100.017% ( 380, 580 ] 174 0.005% 100.022% ( 580, 870 ] 179 0.005% 100.027% ( 870, 1300 ] 100 0.003% 100.030% ( 1300, 1900 ] 52 0.001% 100.031% ( 1900, 2900 ] 43 0.001% 100.032% ( 2900, 4400 ] 46 0.001% 100.034% ( 4400, 6600 ] 14 0.000% 100.034% ( 6600, 9900 ] 7 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 727470 Average: 5.9897 StdDev: 102.99 Min: 0 Median: 1.7562 Max: 10760 Percentiles: P50: 1.76 P75: 2.67 P99: 9.52 P99.9: 139.02 P99.99: 566.65 ------------------------------------------------------ [ 0, 1 ] 53615 7.370% 7.370% # ( 1, 2 ] 410096 56.373% 63.743% ########### ( 2, 3 ] 121769 16.739% 80.482% ### ( 3, 4 ] 59151 8.131% 88.613% ## ( 4, 6 ] 60973 8.382% 96.994% ## ( 6, 10 ] 16587 2.280% 99.274% ( 10, 15 ] 3678 0.506% 99.780% ( 15, 22 ] 487 0.067% 99.847% ( 22, 34 ] 44 0.006% 99.853% ( 34, 51 ] 11 0.002% 99.854% ( 51, 76 ] 30 0.004% 99.859% ( 76, 110 ] 215 0.030% 99.888% ( 110, 170 ] 181 0.025% 99.913% ( 170, 250 ] 172 0.024% 99.937% ( 250, 380 ] 197 0.027% 99.964% ( 380, 580 ] 206 0.028% 99.992% ( 580, 870 ] 209 0.029% 100.021% ( 870, 1300 ] 142 0.020% 100.040% ( 1300, 1900 ] 90 0.012% 100.053% ( 1900, 2900 ] 170 0.023% 100.076% ( 2900, 4400 ] 197 0.027% 100.103% ( 4400, 6600 ] 75 0.010% 100.113% ( 6600, 9900 ] 24 0.003% 100.117% ( 9900, 14000 ] 2 0.000% 100.117% ** Level 2 read latency histogram (micros): Count: 124201 Average: 4.7166 StdDev: 79.57 Min: 1 Median: 1.5118 Max: 6312 Percentiles: P50: 1.51 P75: 1.94 P99: 8.38 P99.9: 654.39 P99.99: 4176.95 ------------------------------------------------------ [ 0, 1 ] 25253 20.332% 20.332% #### ( 1, 2 ] 72001 57.971% 78.304% ############ ( 2, 3 ] 13158 10.594% 88.898% ## ( 3, 4 ] 6380 5.137% 94.035% # ( 4, 6 ] 5311 4.276% 98.311% # ( 6, 10 ] 1441 1.160% 99.471% ( 10, 15 ] 330 0.266% 99.737% ( 15, 22 ] 37 0.030% 99.767% ( 22, 34 ] 7 0.006% 99.772% ( 76, 110 ] 1 0.001% 99.773% ( 110, 170 ] 19 0.015% 99.788% ( 170, 250 ] 23 0.019% 99.807% ( 250, 380 ] 52 0.042% 99.849% ( 380, 580 ] 52 0.042% 99.891% ( 580, 870 ] 46 0.037% 99.928% ( 870, 1300 ] 23 0.019% 99.946% ( 1300, 1900 ] 19 0.015% 99.961% ( 1900, 2900 ] 16 0.013% 99.974% ( 2900, 4400 ] 23 0.019% 99.993% ( 4400, 6600 ] 9 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 716423 Average: 7.6444 StdDev: 98.11 Min: 0 Median: 1.9049 Max: 9140 Percentiles: P50: 1.90 P75: 2.98 P99: 9.50 P99.9: 435.08 P99.99: 623.87 ------------------------------------------------------ [ 0, 1 ] 25395 3.545% 3.545% # ( 1, 2 ] 367780 51.336% 54.880% ########## ( 2, 3 ] 147678 20.613% 75.494% #### ( 3, 4 ] 77821 10.862% 86.356% ## ( 4, 6 ] 78168 10.911% 97.267% ## ( 6, 10 ] 14177 1.979% 99.246% ( 10, 15 ] 3079 0.430% 99.675% ( 15, 22 ] 356 0.050% 99.725% ( 22, 34 ] 64 0.009% 99.734% ( 34, 51 ] 28 0.004% 99.738% ( 51, 76 ] 11 0.002% 99.740% ( 76, 110 ] 36 0.005% 99.745% ( 110, 170 ] 193 0.027% 99.772% ( 170, 250 ] 275 0.038% 99.810% ( 250, 380 ] 444 0.062% 99.872% ( 380, 580 ] 732 0.102% 99.974% ( 580, 870 ] 756 0.106% 100.080% ( 870, 1300 ] 548 0.076% 100.156% ( 1300, 1900 ] 191 0.027% 100.183% ( 1900, 2900 ] 155 0.022% 100.204% ( 2900, 4400 ] 220 0.031% 100.235% ( 4400, 6600 ] 40 0.006% 100.241% ( 6600, 9900 ] 8 0.001% 100.242% ** Level 4 read latency histogram (micros): Count: 360 Average: 242.6167 StdDev: 728.97 Min: 0 Median: 2.5833 Max: 7885 Percentiles: P50: 2.58 P75: 123.85 P99: 3620.00 P99.9: 7885.00 P99.99: 7885.00 ------------------------------------------------------ [ 0, 1 ] 43 11.944% 11.944% ## ( 1, 2 ] 102 28.333% 40.278% ###### ( 2, 3 ] 60 16.667% 56.944% ### ( 3, 4 ] 28 7.778% 64.722% ## ( 4, 6 ] 14 3.889% 68.611% # ( 6, 10 ] 9 2.500% 71.111% # ( 10, 15 ] 6 1.667% 72.778% ( 15, 22 ] 3 0.833% 73.611% ( 22, 34 ] 2 0.556% 74.167% ( 110, 170 ] 13 3.611% 77.778% # ( 170, 250 ] 23 6.389% 84.167% # ( 250, 380 ] 5 1.389% 85.556% ( 380, 580 ] 10 2.778% 88.333% # ( 580, 870 ] 10 2.778% 91.111% # ( 870, 1300 ] 13 3.611% 94.722% # ( 1300, 1900 ] 7 1.944% 96.667% ( 1900, 2900 ] 6 1.667% 98.333% ( 2900, 4400 ] 5 1.389% 99.722% ( 6600, 9900 ] 1 0.278% 100.000% ** Level 5 read latency histogram (micros): Count: 180 Average: 1298.1556 StdDev: 1635.58 Min: 75 Median: 597.0588 Max: 8573 Percentiles: P50: 597.06 P75: 1860.00 P99: 8415.00 P99.9: 8573.00 P99.99: 8573.00 ------------------------------------------------------ ( 51, 76 ] 1 0.556% 0.556% ( 76, 110 ] 14 7.778% 8.333% ## ( 110, 170 ] 28 15.556% 23.889% ### ( 170, 250 ] 11 6.111% 30.000% # ( 250, 380 ] 15 8.333% 38.333% ## ( 380, 580 ] 20 11.111% 49.444% ## ( 580, 870 ] 17 9.444% 58.889% ## ( 870, 1300 ] 15 8.333% 67.222% ## ( 1300, 1900 ] 15 8.333% 75.556% ## ( 1900, 2900 ] 20 11.111% 86.667% ## ( 2900, 4400 ] 14 7.778% 94.444% ## ( 4400, 6600 ] 6 3.333% 97.778% # ( 6600, 9900 ] 4 2.222% 100.000% ** DB Stats ** Uptime(secs): 35.6 total, 4.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 248.66 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:10.788 H:M:S, 30.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 248.78 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.309 H:M:S, 33.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/18-01:56:23 ... thread 0: (1000000,10000000) ops and (170113.7,242045.1) ops/second in (5.878423,41.314614) 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/16 3.62 GB 12.6 9.2 0.0 9.2 18.6 9.5 0.0 2.0 138.5 281.4 67.76 59.69 167 0.406 9529K 16K 0.0 0.0 L1 17/17 1.82 GB 0.0 6.6 5.6 1.0 6.5 5.5 0.2 1.2 225.6 223.5 29.78 28.25 4 7.445 6821K 61K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.8 2.0 253.4 253.2 1.49 1.44 2 0.746 383K 209 0.0 0.0 L3 14/0 948.54 MB 0.9 3.2 1.6 1.6 3.2 1.6 2.4 2.0 145.7 145.2 22.30 14.78 13 1.716 3301K 12K 0.0 0.0 L4 165/0 9.62 GB 1.0 3.8 2.6 1.2 3.8 2.6 1.4 1.5 141.2 140.2 27.91 18.22 42 0.665 3923K 26K 0.0 0.0 L5 1088/0 89.51 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1302/33 105.49 GB 0.0 23.1 10.0 13.1 32.5 19.4 11.8 3.4 158.6 222.8 149.24 122.38 228 0.655 23M 117K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.1 10.0 13.1 32.5 19.4 11.4 3.4 158.6 222.8 149.24 122.38 228 0.655 23M 117K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.1 10.0 13.1 23.0 9.9 0.0 0.0 199.4 198.4 118.73 97.67 90 1.319 23M 117K 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 318.0 30.51 24.71 138 0.221 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 41.5 total, 41.3 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 32.47 GB write, 801.27 MB/s write, 23.12 GB read, 570.40 MB/s read, 149.2 seconds Interval compaction: 32.47 GB write, 804.84 MB/s write, 23.12 GB read, 572.94 MB/s read, 149.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 66, pending-compaction-bytes-delays: 7, pending-compaction-bytes-stops: 0, total-delays: 30, total-stops: 66, interval: 96 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4017055 Average: 2.4774 StdDev: 23.77 Min: 1 Median: 1.5085 Max: 8569 Percentiles: P50: 1.51 P75: 1.89 P99: 6.00 P99.9: 12.92 P99.99: 138.13 ------------------------------------------------------ [ 0, 1 ] 672957 16.752% 16.752% ### ( 1, 2 ] 2626620 65.387% 82.139% ############# ( 2, 3 ] 397157 9.887% 92.026% ## ( 3, 4 ] 164610 4.098% 96.124% # ( 4, 6 ] 115611 2.878% 99.002% # ( 6, 10 ] 32783 0.816% 99.818% ( 10, 15 ] 5649 0.141% 99.958% ( 15, 22 ] 638 0.016% 99.974% ( 22, 34 ] 43 0.001% 99.975% ( 34, 51 ] 19 0.000% 99.976% ( 51, 76 ] 30 0.001% 99.977% ( 76, 110 ] 300 0.007% 99.984% ( 110, 170 ] 504 0.013% 99.997% ( 170, 250 ] 343 0.009% 100.005% ( 250, 380 ] 252 0.006% 100.011% ( 380, 580 ] 280 0.007% 100.018% ( 580, 870 ] 260 0.006% 100.025% ( 870, 1300 ] 134 0.003% 100.028% ( 1300, 1900 ] 66 0.002% 100.030% ( 1900, 2900 ] 52 0.001% 100.031% ( 2900, 4400 ] 50 0.001% 100.032% ( 4400, 6600 ] 14 0.000% 100.033% ( 6600, 9900 ] 7 0.000% 100.033% ** Level 1 read latency histogram (micros): Count: 1026077 Average: 6.0543 StdDev: 103.14 Min: 0 Median: 1.7623 Max: 10760 Percentiles: P50: 1.76 P75: 2.68 P99: 9.55 P99.9: 175.35 P99.99: 641.85 ------------------------------------------------------ [ 0, 1 ] 72106 7.027% 7.027% # ( 1, 2 ] 578417 56.372% 63.399% ########### ( 2, 3 ] 174853 17.041% 80.440% ### ( 3, 4 ] 82903 8.080% 88.520% ## ( 4, 6 ] 86144 8.395% 96.915% ## ( 6, 10 ] 24096 2.348% 99.263% ( 10, 15 ] 5150 0.502% 99.765% ( 15, 22 ] 703 0.069% 99.834% ( 22, 34 ] 52 0.005% 99.839% ( 34, 51 ] 14 0.001% 99.840% ( 51, 76 ] 37 0.004% 99.844% ( 76, 110 ] 283 0.028% 99.871% ( 110, 170 ] 277 0.027% 99.898% ( 170, 250 ] 238 0.023% 99.922% ( 250, 380 ] 308 0.030% 99.952% ( 380, 580 ] 326 0.032% 99.983% ( 580, 870 ] 316 0.031% 100.014% ( 870, 1300 ] 220 0.021% 100.036% ( 1300, 1900 ] 128 0.012% 100.048% ( 1900, 2900 ] 240 0.023% 100.072% ( 2900, 4400 ] 276 0.027% 100.098% ( 4400, 6600 ] 105 0.010% 100.109% ( 6600, 9900 ] 34 0.003% 100.112% ( 9900, 14000 ] 2 0.000% 100.112% ** Level 2 read latency histogram (micros): Count: 124201 Average: 4.7166 StdDev: 79.57 Min: 1 Median: 1.5118 Max: 6312 Percentiles: P50: 1.51 P75: 1.94 P99: 8.38 P99.9: 654.39 P99.99: 4176.95 ------------------------------------------------------ [ 0, 1 ] 25253 20.332% 20.332% #### ( 1, 2 ] 72001 57.971% 78.304% ############ ( 2, 3 ] 13158 10.594% 88.898% ## ( 3, 4 ] 6380 5.137% 94.035% # ( 4, 6 ] 5311 4.276% 98.311% # ( 6, 10 ] 1441 1.160% 99.471% ( 10, 15 ] 330 0.266% 99.737% ( 15, 22 ] 37 0.030% 99.767% ( 22, 34 ] 7 0.006% 99.772% ( 76, 110 ] 1 0.001% 99.773% ( 110, 170 ] 19 0.015% 99.788% ( 170, 250 ] 23 0.019% 99.807% ( 250, 380 ] 52 0.042% 99.849% ( 380, 580 ] 52 0.042% 99.891% ( 580, 870 ] 46 0.037% 99.928% ( 870, 1300 ] 23 0.019% 99.946% ( 1300, 1900 ] 19 0.015% 99.961% ( 1900, 2900 ] 16 0.013% 99.974% ( 2900, 4400 ] 23 0.019% 99.993% ( 4400, 6600 ] 9 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 757969 Average: 8.4677 StdDev: 105.26 Min: 0 Median: 1.9058 Max: 9140 Percentiles: P50: 1.91 P75: 2.98 P99: 9.75 P99.9: 555.06 P99.99: 754.68 ------------------------------------------------------ [ 0, 1 ] 27247 3.595% 3.595% # ( 1, 2 ] 388330 51.233% 54.828% ########## ( 2, 3 ] 155905 20.569% 75.396% #### ( 3, 4 ] 82457 10.879% 86.275% ## ( 4, 6 ] 82031 10.822% 97.098% ## ( 6, 10 ] 15371 2.028% 99.126% ( 10, 15 ] 3337 0.440% 99.566% ( 15, 22 ] 404 0.053% 99.619% ( 22, 34 ] 66 0.009% 99.628% ( 34, 51 ] 30 0.004% 99.632% ( 51, 76 ] 11 0.001% 99.633% ( 76, 110 ] 41 0.005% 99.639% ( 110, 170 ] 231 0.030% 99.669% ( 170, 250 ] 367 0.048% 99.718% ( 250, 380 ] 590 0.078% 99.795% ( 380, 580 ] 906 0.120% 99.915% ( 580, 870 ] 945 0.125% 100.040% ( 870, 1300 ] 670 0.088% 100.128% ( 1300, 1900 ] 244 0.032% 100.160% ( 1900, 2900 ] 209 0.028% 100.188% ( 2900, 4400 ] 261 0.034% 100.222% ( 4400, 6600 ] 48 0.006% 100.229% ( 6600, 9900 ] 9 0.001% 100.230% ** Level 4 read latency histogram (micros): Count: 197266 Average: 10.0133 StdDev: 121.06 Min: 0 Median: 1.7958 Max: 7885 Percentiles: P50: 1.80 P75: 2.74 P99: 14.40 P99.9: 1041.84 P99.99: 1836.92 ------------------------------------------------------ [ 0, 1 ] 8981 4.553% 4.553% # ( 1, 2 ] 112650 57.106% 61.658% ########### ( 2, 3 ] 35549 18.021% 79.679% #### ( 3, 4 ] 16403 8.315% 87.994% ## ( 4, 6 ] 16260 8.243% 96.237% ## ( 6, 10 ] 4641 2.353% 98.590% ( 10, 15 ] 920 0.466% 99.056% ( 15, 22 ] 126 0.064% 99.120% ( 22, 34 ] 10 0.005% 99.125% ( 34, 51 ] 1 0.001% 99.126% ( 51, 76 ] 3 0.002% 99.127% ( 76, 110 ] 147 0.075% 99.202% ( 110, 170 ] 272 0.138% 99.339% ( 170, 250 ] 235 0.119% 99.459% ( 250, 380 ] 246 0.125% 99.583% ( 380, 580 ] 300 0.152% 99.735% ( 580, 870 ] 256 0.130% 99.865% ( 870, 1300 ] 172 0.087% 99.952% ( 1300, 1900 ] 83 0.042% 99.994% ( 1900, 2900 ] 86 0.044% 100.038% ( 2900, 4400 ] 81 0.041% 100.079% ( 4400, 6600 ] 19 0.010% 100.089% ( 6600, 9900 ] 5 0.003% 100.091% ** Level 5 read latency histogram (micros): Count: 240 Average: 1201.0458 StdDev: 1527.66 Min: 75 Median: 538.6207 Max: 8573 Percentiles: P50: 538.62 P75: 1728.57 P99: 7920.00 P99.9: 8573.00 P99.99: 8573.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 24 10.000% 10.417% ## ( 110, 170 ] 38 15.833% 26.250% ### ( 170, 250 ] 17 7.083% 33.333% # ( 250, 380 ] 17 7.083% 40.417% # ( 380, 580 ] 29 12.083% 52.500% ## ( 580, 870 ] 22 9.167% 61.667% ## ( 870, 1300 ] 17 7.083% 68.750% # ( 1300, 1900 ] 21 8.750% 77.500% ## ( 1900, 2900 ] 24 10.000% 87.500% ## ( 2900, 4400 ] 19 7.917% 95.417% ## ( 4400, 6600 ] 7 2.917% 98.333% # ( 6600, 9900 ] 4 1.667% 100.000% ** DB Stats ** Uptime(secs): 41.5 total, 5.9 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 237.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.879 H:M:S, 33.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 167.42 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:3.091 H:M:S, 52.6 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.743 micros/op 174112 ops/sec 60.019 seconds 10449999 operations; 168.7 MB/s Microseconds per write: Count: 10449999 Average: 5.7434 StdDev: 453.03 Min: 1 Median: 1.7565 Max: 800837 Percentiles: P50: 1.76 P75: 2.80 P99: 8.73 P99.9: 1146.20 P99.99: 2741.75 ------------------------------------------------------ [ 0, 1 ] 1263399 12.090% 12.090% ## ( 1, 2 ] 5236553 50.111% 62.201% ########## ( 2, 3 ] 1675163 16.030% 78.231% ### ( 3, 4 ] 1487496 14.234% 92.465% ### ( 4, 6 ] 610025 5.838% 98.303% # ( 6, 10 ] 106647 1.021% 99.323% ( 10, 15 ] 31159 0.298% 99.621% ( 15, 22 ] 8331 0.080% 99.701% ( 22, 34 ] 2047 0.020% 99.721% ( 34, 51 ] 268 0.003% 99.723% ( 51, 76 ] 70 0.001% 99.724% ( 76, 110 ] 7192 0.069% 99.793% ( 110, 170 ] 3000 0.029% 99.822% ( 170, 250 ] 301 0.003% 99.824% ( 250, 380 ] 137 0.001% 99.826% ( 380, 580 ] 24 0.000% 99.826% ( 580, 870 ] 15 0.000% 99.826% ( 870, 1300 ] 12022 0.115% 99.941% ( 1300, 1900 ] 36 0.000% 99.941% ( 1900, 2900 ] 6022 0.058% 99.999% ( 2900, 4400 ] 55 0.001% 100.000% ( 4400, 6600 ] 2 0.000% 100.000% ( 6600, 9900 ] 8 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 11 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 3 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 215035 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 : 10449999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10784398968 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 : 532 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30921678 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 : 31148117534 rocksdb.compact.write.bytes COUNT : 30948156298 rocksdb.flush.write.bytes COUNT : 10767514279 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 : 55 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 : 293 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 : 10680577024 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4037632 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 : 31245416997 rocksdb.non.last.level.read.count COUNT : 7550600 rocksdb.block.checksum.compute.count COUNT : 7549591 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.406273 P95 : 3.906432 P99 : 7.023211 P100 : 800834.000000 COUNT : 10449999 SUM : 55027991 rocksdb.compaction.times.micros P50 : 1002580.645161 P95 : 3320000.000000 P99 : 12026000.000000 P100 : 12818886.000000 COUNT : 94 SUM : 124960128 rocksdb.compaction.times.cpu_micros P50 : 922631.578947 P95 : 3320000.000000 P99 : 11795685.000000 P100 : 11795685.000000 COUNT : 94 SUM : 103818470 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 : 693.928571 P95 : 3950.000000 P99 : 63500.000000 P100 : 371371.000000 COUNT : 146 SUM : 596904 rocksdb.compaction.outfile.sync.micros P50 : 1087.905405 P95 : 88650.000000 P99 : 166950.000000 P100 : 601573.000000 COUNT : 361 SUM : 5331954 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 : 105.142857 P95 : 845.142857 P99 : 3755.000000 P100 : 7467.000000 COUNT : 272 SUM : 74960 rocksdb.table.open.io.micros P50 : 1249.411765 P95 : 7711.578947 P99 : 13854.222222 P100 : 19847.000000 COUNT : 532 SUM : 1079163 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.592823 P95 : 7.629940 P99 : 11.454399 P100 : 10769.000000 COUNT : 7547978 SUM : 45114512 rocksdb.read.block.get.micros P50 : 375.617978 P95 : 3372.340426 P99 : 6028.000000 P100 : 15172.000000 COUNT : 1064 SUM : 897622 rocksdb.write.raw.block.micros P50 : 0.513077 P95 : 0.974847 P99 : 2.883225 P100 : 18026.000000 COUNT : 10102891 SUM : 20533157 rocksdb.numfiles.in.singlecompaction P50 : 3.262821 P95 : 6.680000 P99 : 13.925000 P100 : 29.000000 COUNT : 143 SUM : 542 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.561118 P95 : 1218.281053 P99 : 2627.141429 P100 : 800641.000000 COUNT : 166697 SUM : 30936110 rocksdb.sst.read.micros P50 : 1.555780 P95 : 4.505113 P99 : 8.514898 P100 : 10760.000000 COUNT : 7550653 SUM : 29709369 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 : 10449999 SUM : 10784398968 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 : 210000.000000 P95 : 444600.000000 P99 : 815533.333333 P100 : 991443.000000 COUNT : 146 SUM : 32121616 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 : 350 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