[2024-07-22 15:44:46.248480] Starting SPDK v24.01.1-pre git sha1 4b94202c6 / DPDK 23.11.0 initialization... [2024-07-22 15:44:46.248581] [ 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_pid431187 ] Set seed to 1721655886246155 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-22 15:44:46.347969] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-22 15:44:46.387521] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-22 15:44:46.387570] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 431187' to capture a snapshot of events at runtime. [2024-07-22 15:44:46.387583] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid431187 for offline analysis/debug. [2024-07-22 15:44:46.387610] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Jul 22 15:44:50 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/22-15:44:53 ... thread 0: (1000000,1000000) ops and (338434.2,338434.2) ops/second in (2.954784,2.954784) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.98 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 354.1 2.49 2.26 12 0.208 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 12/0 993.33 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.4 94.7 315.5 3.99 3.71 14 0.285 383K 196 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 94.7 315.5 3.99 3.71 14 0.285 383K 196 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 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 354.1 2.49 2.26 12 0.208 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.1 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 402.30 MB/s write, 0.37 GB read, 120.70 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 426.12 MB/s write, 0.37 GB read, 127.84 MB/s read, 4.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 113058 Average: 1.8984 StdDev: 19.43 Min: 1 Median: 1.2158 Max: 4470 Percentiles: P50: 1.22 P75: 1.66 P99: 3.98 P99.9: 9.85 P99.99: 308.37 ------------------------------------------------------ [ 0, 1 ] 42898 37.943% 37.943% ######## ( 1, 2 ] 63168 55.872% 93.816% ########### ( 2, 3 ] 4295 3.799% 97.614% # ( 3, 4 ] 1604 1.419% 99.033% ( 4, 6 ] 700 0.619% 99.652% ( 6, 10 ] 291 0.257% 99.910% ( 10, 15 ] 55 0.049% 99.958% ( 15, 22 ] 16 0.014% 99.973% ( 22, 34 ] 2 0.002% 99.974% ( 34, 51 ] 2 0.002% 99.976% ( 51, 76 ] 2 0.002% 99.978% ( 76, 110 ] 1 0.001% 99.979% ( 110, 170 ] 9 0.008% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 6 0.005% 99.993% ( 380, 580 ] 1 0.001% 99.994% ( 580, 870 ] 2 0.002% 99.996% ( 1300, 1900 ] 1 0.001% 99.996% ( 1900, 2900 ] 2 0.002% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 1 read latency histogram (micros): Count: 5 Average: 841.4000 StdDev: 886.66 Min: 102 Median: 210.0000 Max: 2281 Percentiles: P50: 210.00 P75: 1750.00 P99: 2281.00 P99.9: 2281.00 P99.99: 2281.00 ------------------------------------------------------ ( 76, 110 ] 1 20.000% 20.000% #### ( 110, 170 ] 1 20.000% 40.000% #### ( 170, 250 ] 1 20.000% 60.000% #### ( 1300, 1900 ] 1 20.000% 80.000% #### ( 1900, 2900 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 59031 Average: 1.8604 StdDev: 9.08 Min: 1 Median: 1.2439 Max: 1658 Percentiles: P50: 1.24 P75: 1.69 P99: 4.92 P99.9: 9.77 P99.99: 297.53 ------------------------------------------------------ [ 0, 1 ] 21386 36.228% 36.228% ####### ( 1, 2 ] 33338 56.475% 92.704% ########### ( 2, 3 ] 2355 3.989% 96.693% # ( 3, 4 ] 1102 1.867% 98.560% ( 4, 6 ] 563 0.954% 99.514% ( 6, 10 ] 242 0.410% 99.924% ( 10, 15 ] 30 0.051% 99.975% ( 15, 22 ] 5 0.008% 99.983% ( 22, 34 ] 2 0.003% 99.986% ( 51, 76 ] 1 0.002% 99.988% ( 250, 380 ] 3 0.005% 99.993% ( 380, 580 ] 1 0.002% 99.995% ( 580, 870 ] 1 0.002% 99.997% ( 870, 1300 ] 1 0.002% 99.998% ( 1300, 1900 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 55 Average: 1290.6000 StdDev: 955.38 Min: 55 Median: 1192.5000 Max: 4418 Percentiles: P50: 1192.50 P75: 1925.00 P99: 4418.00 P99.9: 4418.00 P99.99: 4418.00 ------------------------------------------------------ ( 51, 76 ] 1 1.818% 1.818% ( 110, 170 ] 4 7.273% 9.091% # ( 170, 250 ] 3 5.455% 14.545% # ( 250, 380 ] 2 3.636% 18.182% # ( 380, 580 ] 5 9.091% 27.273% ## ( 580, 870 ] 8 14.545% 41.818% ### ( 870, 1300 ] 6 10.909% 52.727% ## ( 1300, 1900 ] 12 21.818% 74.545% #### ( 1900, 2900 ] 10 18.182% 92.727% #### ( 2900, 4400 ] 3 5.455% 98.182% # ( 4400, 6600 ] 1 1.818% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1687.2500 StdDev: 724.80 Min: 529 Median: 1566.6667 Max: 3510 Percentiles: P50: 1566.67 P75: 1900.00 P99: 3510.00 P99.9: 3510.00 P99.99: 3510.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 2 10.000% 15.000% ## ( 870, 1300 ] 3 15.000% 30.000% ### ( 1300, 1900 ] 9 45.000% 75.000% ######### ( 1900, 2900 ] 4 20.000% 95.000% #### ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 314.30 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.408 H:M:S, 13.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 332.85 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.408 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/22-15:44:56 ... thread 0: (1000000,2000000) ops and (332971.4,335680.6) ops/second in (3.003261,5.958045) 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/8 1.23 GB 69.2 0.6 0.0 0.6 2.4 1.8 0.0 1.3 75.8 328.2 7.48 6.88 28 0.267 575K 620 0.0 0.0 L1 1/0 3.94 MB 0.4 0.4 0.4 0.0 0.4 0.4 0.2 1.0 247.0 246.6 1.53 1.49 1 1.530 383K 637 0.0 0.0 L2 2/1 54.27 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 18/8 1.00 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 224.8 224.8 1.11 1.04 1 1.109 253K 0 0.0 0.0 L4 170/0 9.45 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 147.3 147.4 1.52 1.10 1 1.521 227K 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/17 97.98 GB 0.0 1.8 1.0 0.7 3.6 2.9 2.2 1.9 136.6 280.3 13.14 11.97 33 0.398 1823K 1453 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.6 2.9 2.1 1.9 136.6 280.3 13.14 11.97 33 0.398 1823K 1453 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 1.0 0.7 1.8 1.0 0.0 0.0 229.0 228.8 7.84 7.22 7 1.120 1823K 1453 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 356.4 5.30 4.74 26 0.204 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, 6.0 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.60 GB write, 600.64 MB/s write, 1.75 GB read, 292.81 MB/s read, 13.1 seconds Interval compaction: 3.60 GB write, 618.29 MB/s write, 1.75 GB read, 301.41 MB/s read, 13.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 410292 Average: 2.1504 StdDev: 12.67 Min: 1 Median: 1.4452 Max: 4470 Percentiles: P50: 1.45 P75: 1.84 P99: 5.63 P99.9: 9.82 P99.99: 14.85 ------------------------------------------------------ [ 0, 1 ] 90494 22.056% 22.056% #### ( 1, 2 ] 257537 62.769% 84.825% ############# ( 2, 3 ] 33145 8.078% 92.904% ## ( 3, 4 ] 16557 4.035% 96.939% # ( 4, 6 ] 10400 2.535% 99.474% # ( 6, 10 ] 1833 0.447% 99.921% ( 10, 15 ] 295 0.072% 99.992% ( 15, 22 ] 40 0.010% 100.002% ( 22, 34 ] 4 0.001% 100.003% ( 34, 51 ] 4 0.001% 100.004% ( 51, 76 ] 3 0.001% 100.005% ( 76, 110 ] 1 0.000% 100.005% ( 110, 170 ] 13 0.003% 100.008% ( 170, 250 ] 9 0.002% 100.010% ( 250, 380 ] 11 0.003% 100.013% ( 380, 580 ] 4 0.001% 100.014% ( 580, 870 ] 9 0.002% 100.016% ( 870, 1300 ] 2 0.000% 100.017% ( 1300, 1900 ] 2 0.000% 100.017% ( 1900, 2900 ] 4 0.001% 100.018% ( 2900, 4400 ] 1 0.000% 100.019% ( 4400, 6600 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 30 Average: 282.7000 StdDev: 543.23 Min: 1 Median: 1.9091 Max: 2281 Percentiles: P50: 1.91 P75: 282.50 P99: 2281.00 P99.9: 2281.00 P99.99: 2281.00 ------------------------------------------------------ [ 0, 1 ] 5 16.667% 16.667% ### ( 1, 2 ] 11 36.667% 53.333% ####### ( 6, 10 ] 1 3.333% 56.667% # ( 76, 110 ] 1 3.333% 60.000% # ( 110, 170 ] 2 6.667% 66.667% # ( 170, 250 ] 2 6.667% 73.333% # ( 250, 380 ] 2 6.667% 80.000% # ( 380, 580 ] 2 6.667% 86.667% # ( 580, 870 ] 1 3.333% 90.000% # ( 1300, 1900 ] 2 6.667% 96.667% # ( 1900, 2900 ] 1 3.333% 100.000% # ** Level 2 read latency histogram (micros): Count: 95787 Average: 1.9717 StdDev: 7.16 Min: 1 Median: 1.3530 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.70 P99.99: 27.69 ------------------------------------------------------ [ 0, 1 ] 27704 28.923% 28.923% ###### ( 1, 2 ] 57191 59.706% 88.629% ############ ( 2, 3 ] 5835 6.092% 94.721% # ( 3, 4 ] 2908 3.036% 97.756% # ( 4, 6 ] 1657 1.730% 99.486% ( 6, 10 ] 428 0.447% 99.933% ( 10, 15 ] 46 0.048% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 181777 Average: 3.3968 StdDev: 32.03 Min: 1 Median: 1.6184 Max: 4418 Percentiles: P50: 1.62 P75: 2.05 P99: 8.77 P99.9: 196.55 P99.99: 536.69 ------------------------------------------------------ [ 0, 1 ] 19533 10.746% 10.746% ## ( 1, 2 ] 115390 63.479% 74.224% ############# ( 2, 3 ] 26218 14.423% 88.648% ### ( 3, 4 ] 9590 5.276% 93.923% # ( 4, 6 ] 7368 4.053% 97.977% # ( 6, 10 ] 2685 1.477% 99.454% ( 10, 15 ] 466 0.256% 99.710% ( 15, 22 ] 73 0.040% 99.750% ( 22, 34 ] 18 0.010% 99.760% ( 34, 51 ] 2 0.001% 99.761% ( 51, 76 ] 5 0.003% 99.764% ( 76, 110 ] 56 0.031% 99.795% ( 110, 170 ] 165 0.091% 99.886% ( 170, 250 ] 79 0.043% 99.929% ( 250, 380 ] 74 0.041% 99.970% ( 380, 580 ] 47 0.026% 99.996% ( 580, 870 ] 33 0.018% 100.014% ( 870, 1300 ] 14 0.008% 100.021% ( 1300, 1900 ] 13 0.007% 100.029% ( 1900, 2900 ] 10 0.006% 100.034% ( 2900, 4400 ] 3 0.002% 100.036% ( 4400, 6600 ] 1 0.001% 100.036% ** Level 4 read latency histogram (micros): Count: 310 Average: 115.8032 StdDev: 453.29 Min: 1 Median: 1.6614 Max: 3510 Percentiles: P50: 1.66 P75: 5.83 P99: 2375.00 P99.9: 3510.00 P99.99: 3510.00 ------------------------------------------------------ [ 0, 1 ] 71 22.903% 22.903% ##### ( 1, 2 ] 127 40.968% 63.871% ######## ( 2, 3 ] 24 7.742% 71.613% ## ( 3, 4 ] 5 1.613% 73.226% ( 4, 6 ] 6 1.935% 75.161% ( 6, 10 ] 8 2.581% 77.742% # ( 10, 15 ] 42 13.548% 91.290% ### ( 15, 22 ] 3 0.968% 92.258% ( 22, 34 ] 1 0.323% 92.581% ( 170, 250 ] 1 0.323% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 2 0.645% 94.516% ( 870, 1300 ] 3 0.968% 95.484% ( 1300, 1900 ] 9 2.903% 98.387% # ( 1900, 2900 ] 4 1.290% 99.677% ( 2900, 4400 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 759.5250 StdDev: 1035.08 Min: 77 Median: 210.0000 Max: 4354 Percentiles: P50: 210.00 P75: 1156.67 P99: 4200.00 P99.9: 4354.00 P99.99: 4354.00 ------------------------------------------------------ ( 76, 110 ] 6 15.000% 15.000% ### ( 110, 170 ] 12 30.000% 45.000% ###### ( 170, 250 ] 4 10.000% 55.000% ## ( 250, 380 ] 3 7.500% 62.500% ## ( 380, 580 ] 1 2.500% 65.000% # ( 580, 870 ] 2 5.000% 70.000% # ( 870, 1300 ] 3 7.500% 77.500% ## ( 1300, 1900 ] 5 12.500% 90.000% ### ( 1900, 2900 ] 1 2.500% 92.500% # ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 6.1 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 320.86 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.777 H:M:S, 12.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.70 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.369 H:M:S, 12.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/22-15:44:59 ... thread 0: (1000000,3000000) ops and (362163.7,344067.2) ops/second in (2.761182,8.719227) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/12 2.09 GB 44.1 1.4 0.0 1.4 4.1 2.7 0.0 1.5 109.7 319.5 13.20 12.27 44 0.300 1471K 1550 0.0 0.0 L1 1/1 3.94 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 247.0 246.6 1.53 1.49 1 1.530 383K 637 0.0 0.0 L2 1/0 51.78 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 12/0 510.79 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 229.1 228.7 4.06 3.79 2 2.030 944K 1747 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.3 147.4 1.52 1.10 1 1.521 227K 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 1251/13 98.84 GB 0.0 3.3 1.0 2.3 6.0 3.7 3.0 2.2 154.0 280.8 21.82 20.10 50 0.436 3410K 4130 0.0 0.0 Int 0/0 0.00 KB 0.0 3.3 1.0 2.3 6.0 3.7 2.9 2.2 154.0 280.8 21.82 20.10 50 0.436 3410K 4130 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.3 1.0 2.3 3.3 1.0 0.0 0.0 238.6 238.3 14.08 13.19 11 1.280 3410K 4130 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 358.3 7.74 6.91 39 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): 8.9 total, 8.7 interval Flush(GB): cumulative 2.707, interval 2.707 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.98 GB write, 688.73 MB/s write, 3.28 GB read, 377.60 MB/s read, 21.8 seconds Interval compaction: 5.98 GB write, 702.55 MB/s write, 3.28 GB read, 385.18 MB/s read, 21.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 696056 Average: 2.1235 StdDev: 11.46 Min: 0 Median: 1.4429 Max: 4470 Percentiles: P50: 1.44 P75: 1.83 P99: 5.53 P99.9: 9.62 P99.99: 14.34 ------------------------------------------------------ [ 0, 1 ] 149680 21.504% 21.504% #### ( 1, 2 ] 447879 64.345% 85.849% ############# ( 2, 3 ] 53640 7.706% 93.556% ## ( 3, 4 ] 25968 3.731% 97.286% # ( 4, 6 ] 15630 2.246% 99.532% ( 6, 10 ] 2831 0.407% 99.939% ( 10, 15 ] 414 0.059% 99.998% ( 15, 22 ] 65 0.009% 100.007% ( 22, 34 ] 5 0.001% 100.008% ( 34, 51 ] 7 0.001% 100.009% ( 51, 76 ] 5 0.001% 100.010% ( 76, 110 ] 2 0.000% 100.010% ( 110, 170 ] 21 0.003% 100.013% ( 170, 250 ] 16 0.002% 100.015% ( 250, 380 ] 15 0.002% 100.018% ( 380, 580 ] 7 0.001% 100.019% ( 580, 870 ] 13 0.002% 100.020% ( 870, 1300 ] 7 0.001% 100.021% ( 1300, 1900 ] 3 0.000% 100.022% ( 1900, 2900 ] 5 0.001% 100.023% ( 2900, 4400 ] 2 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 28328 Average: 2.8019 StdDev: 22.35 Min: 1 Median: 1.4640 Max: 2281 Percentiles: P50: 1.46 P75: 1.83 P99: 8.54 P99.9: 160.73 P99.99: 1350.16 ------------------------------------------------------ [ 0, 1 ] 5184 18.300% 18.300% #### ( 1, 2 ] 19353 68.318% 86.617% ############## ( 2, 3 ] 1924 6.792% 93.409% # ( 3, 4 ] 870 3.071% 96.481% # ( 4, 6 ] 416 1.469% 97.949% ( 6, 10 ] 469 1.656% 99.605% ( 10, 15 ] 29 0.102% 99.707% ( 15, 22 ] 2 0.007% 99.714% ( 51, 76 ] 1 0.004% 99.718% ( 76, 110 ] 28 0.099% 99.816% ( 110, 170 ] 28 0.099% 99.915% ( 170, 250 ] 4 0.014% 99.929% ( 250, 380 ] 8 0.028% 99.958% ( 380, 580 ] 7 0.025% 99.982% ( 580, 870 ] 2 0.007% 99.989% ( 1300, 1900 ] 2 0.007% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200850 Average: 3.3858 StdDev: 31.53 Min: 0 Median: 1.6048 Max: 4418 Percentiles: P50: 1.60 P75: 2.00 P99: 8.78 P99.9: 207.89 P99.99: 571.98 ------------------------------------------------------ [ 0, 1 ] 22692 11.298% 11.298% ## ( 1, 2 ] 128523 63.990% 75.288% ############# ( 2, 3 ] 27656 13.769% 89.057% ### ( 3, 4 ] 10204 5.080% 94.137% # ( 4, 6 ] 7679 3.823% 97.961% # ( 6, 10 ] 3002 1.495% 99.455% ( 10, 15 ] 486 0.242% 99.697% ( 15, 22 ] 73 0.036% 99.734% ( 22, 34 ] 19 0.009% 99.743% ( 34, 51 ] 2 0.001% 99.744% ( 51, 76 ] 5 0.002% 99.747% ( 76, 110 ] 84 0.042% 99.788% ( 110, 170 ] 182 0.091% 99.879% ( 170, 250 ] 89 0.044% 99.923% ( 250, 380 ] 84 0.042% 99.965% ( 380, 580 ] 52 0.026% 99.991% ( 580, 870 ] 37 0.018% 100.009% ( 870, 1300 ] 17 0.008% 100.018% ( 1300, 1900 ] 16 0.008% 100.026% ( 1900, 2900 ] 10 0.005% 100.031% ( 2900, 4400 ] 3 0.001% 100.032% ( 4400, 6600 ] 1 0.000% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 115.8032 StdDev: 453.29 Min: 1 Median: 1.6614 Max: 3510 Percentiles: P50: 1.66 P75: 5.83 P99: 2375.00 P99.9: 3510.00 P99.99: 3510.00 ------------------------------------------------------ [ 0, 1 ] 71 22.903% 22.903% ##### ( 1, 2 ] 127 40.968% 63.871% ######## ( 2, 3 ] 24 7.742% 71.613% ## ( 3, 4 ] 5 1.613% 73.226% ( 4, 6 ] 6 1.935% 75.161% ( 6, 10 ] 8 2.581% 77.742% # ( 10, 15 ] 42 13.548% 91.290% ### ( 15, 22 ] 3 0.968% 92.258% ( 22, 34 ] 1 0.323% 92.581% ( 170, 250 ] 1 0.323% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 2 0.645% 94.516% ( 870, 1300 ] 3 0.968% 95.484% ( 1300, 1900 ] 9 2.903% 98.387% # ( 1900, 2900 ] 4 1.290% 99.677% ( 2900, 4400 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 813.9000 StdDev: 1020.83 Min: 77 Median: 302.0000 Max: 4354 Percentiles: P50: 302.00 P75: 1156.67 P99: 4250.00 P99.9: 4354.00 P99.99: 4354.00 ------------------------------------------------------ ( 76, 110 ] 6 10.000% 10.000% ## ( 110, 170 ] 17 28.333% 38.333% ###### ( 170, 250 ] 5 8.333% 46.667% ## ( 250, 380 ] 5 8.333% 55.000% ## ( 380, 580 ] 3 5.000% 60.000% # ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 7 11.667% 88.333% ## ( 1900, 2900 ] 1 1.667% 90.000% ( 2900, 4400 ] 6 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 8.9 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 331.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:0.980 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 356.44 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.203 H:M:S, 7.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/22-15:45:02 ... thread 0: (1000000,4000000) ops and (299806.9,331820.6) ops/second in (3.335480,12.054707) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/12 3.20 GB 151.0 2.5 0.0 2.5 6.3 3.8 0.0 1.6 124.0 316.1 20.32 18.99 63 0.323 2558K 2670 0.0 0.0 L1 1/1 3.94 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 247.0 246.6 1.53 1.49 1 1.530 383K 637 0.0 0.0 L2 1/0 51.78 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 12/0 510.79 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 229.1 228.7 4.06 3.79 2 2.030 944K 1747 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.3 147.4 1.52 1.10 1 1.521 227K 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 1254/13 99.95 GB 0.0 4.3 1.0 3.3 8.1 4.8 3.0 2.1 153.1 287.9 28.93 26.82 69 0.419 4498K 5250 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.0 3.3 8.1 4.8 2.9 2.1 153.1 287.9 28.93 26.82 69 0.419 4498K 5250 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.3 1.0 3.3 4.3 1.0 0.0 0.0 245.6 245.3 18.04 17.08 15 1.203 4498K 5250 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 358.6 10.89 9.74 54 0.202 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.2 total, 12.1 interval Flush(GB): cumulative 3.814, interval 3.814 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.14 GB write, 681.08 MB/s write, 4.33 GB read, 362.19 MB/s read, 28.9 seconds Interval compaction: 8.14 GB write, 690.97 MB/s write, 4.33 GB read, 367.45 MB/s read, 28.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 13, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1132899 Average: 2.1466 StdDev: 11.11 Min: 0 Median: 1.4494 Max: 4470 Percentiles: P50: 1.45 P75: 1.83 P99: 5.51 P99.9: 9.69 P99.99: 15.36 ------------------------------------------------------ [ 0, 1 ] 231290 20.416% 20.416% #### ( 1, 2 ] 745742 65.826% 86.242% ############# ( 2, 3 ] 86452 7.631% 93.873% ## ( 3, 4 ] 40479 3.573% 97.446% # ( 4, 6 ] 23244 2.052% 99.498% ( 6, 10 ] 4938 0.436% 99.933% ( 10, 15 ] 636 0.056% 99.990% ( 15, 22 ] 92 0.008% 99.998% ( 22, 34 ] 15 0.001% 99.999% ( 34, 51 ] 11 0.001% 100.000% ( 51, 76 ] 6 0.001% 100.001% ( 76, 110 ] 70 0.006% 100.007% ( 110, 170 ] 86 0.008% 100.014% ( 170, 250 ] 43 0.004% 100.018% ( 250, 380 ] 42 0.004% 100.022% ( 380, 580 ] 25 0.002% 100.024% ( 580, 870 ] 22 0.002% 100.026% ( 870, 1300 ] 14 0.001% 100.027% ( 1300, 1900 ] 4 0.000% 100.028% ( 1900, 2900 ] 5 0.000% 100.028% ( 2900, 4400 ] 4 0.000% 100.028% ( 4400, 6600 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 28328 Average: 2.8019 StdDev: 22.35 Min: 1 Median: 1.4640 Max: 2281 Percentiles: P50: 1.46 P75: 1.83 P99: 8.54 P99.9: 160.73 P99.99: 1350.16 ------------------------------------------------------ [ 0, 1 ] 5184 18.300% 18.300% #### ( 1, 2 ] 19353 68.318% 86.617% ############## ( 2, 3 ] 1924 6.792% 93.409% # ( 3, 4 ] 870 3.071% 96.481% # ( 4, 6 ] 416 1.469% 97.949% ( 6, 10 ] 469 1.656% 99.605% ( 10, 15 ] 29 0.102% 99.707% ( 15, 22 ] 2 0.007% 99.714% ( 51, 76 ] 1 0.004% 99.718% ( 76, 110 ] 28 0.099% 99.816% ( 110, 170 ] 28 0.099% 99.915% ( 170, 250 ] 4 0.014% 99.929% ( 250, 380 ] 8 0.028% 99.958% ( 380, 580 ] 7 0.025% 99.982% ( 580, 870 ] 2 0.007% 99.989% ( 1300, 1900 ] 2 0.007% 99.996% ( 1900, 2900 ] 1 0.004% 100.000% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200850 Average: 3.3858 StdDev: 31.53 Min: 0 Median: 1.6048 Max: 4418 Percentiles: P50: 1.60 P75: 2.00 P99: 8.78 P99.9: 207.89 P99.99: 571.98 ------------------------------------------------------ [ 0, 1 ] 22692 11.298% 11.298% ## ( 1, 2 ] 128523 63.990% 75.288% ############# ( 2, 3 ] 27656 13.769% 89.057% ### ( 3, 4 ] 10204 5.080% 94.137% # ( 4, 6 ] 7679 3.823% 97.961% # ( 6, 10 ] 3002 1.495% 99.455% ( 10, 15 ] 486 0.242% 99.697% ( 15, 22 ] 73 0.036% 99.734% ( 22, 34 ] 19 0.009% 99.743% ( 34, 51 ] 2 0.001% 99.744% ( 51, 76 ] 5 0.002% 99.747% ( 76, 110 ] 84 0.042% 99.788% ( 110, 170 ] 182 0.091% 99.879% ( 170, 250 ] 89 0.044% 99.923% ( 250, 380 ] 84 0.042% 99.965% ( 380, 580 ] 52 0.026% 99.991% ( 580, 870 ] 37 0.018% 100.009% ( 870, 1300 ] 17 0.008% 100.018% ( 1300, 1900 ] 16 0.008% 100.026% ( 1900, 2900 ] 10 0.005% 100.031% ( 2900, 4400 ] 3 0.001% 100.032% ( 4400, 6600 ] 1 0.000% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 115.8032 StdDev: 453.29 Min: 1 Median: 1.6614 Max: 3510 Percentiles: P50: 1.66 P75: 5.83 P99: 2375.00 P99.9: 3510.00 P99.99: 3510.00 ------------------------------------------------------ [ 0, 1 ] 71 22.903% 22.903% ##### ( 1, 2 ] 127 40.968% 63.871% ######## ( 2, 3 ] 24 7.742% 71.613% ## ( 3, 4 ] 5 1.613% 73.226% ( 4, 6 ] 6 1.935% 75.161% ( 6, 10 ] 8 2.581% 77.742% # ( 10, 15 ] 42 13.548% 91.290% ### ( 15, 22 ] 3 0.968% 92.258% ( 22, 34 ] 1 0.323% 92.581% ( 170, 250 ] 1 0.323% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 2 0.645% 94.516% ( 870, 1300 ] 3 0.968% 95.484% ( 1300, 1900 ] 9 2.903% 98.387% # ( 1900, 2900 ] 4 1.290% 99.677% ( 2900, 4400 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 813.9000 StdDev: 1020.83 Min: 77 Median: 302.0000 Max: 4354 Percentiles: P50: 302.00 P75: 1156.67 P99: 4250.00 P99.9: 4354.00 P99.99: 4354.00 ------------------------------------------------------ ( 76, 110 ] 6 10.000% 10.000% ## ( 110, 170 ] 17 28.333% 38.333% ###### ( 170, 250 ] 5 8.333% 46.667% ## ( 250, 380 ] 5 8.333% 55.000% ## ( 380, 580 ] 3 5.000% 60.000% # ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 7 11.667% 88.333% ## ( 1900, 2900 ] 1 1.667% 90.000% ( 2900, 4400 ] 6 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 12.2 total, 3.3 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 321.86 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.692 H:M:S, 13.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 295.07 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.712 H:M:S, 21.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/07/22-15:45:05 ... thread 0: (1000000,5000000) ops and (341574.6,333726.6) ops/second in (2.927618,14.982325) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/4 2.64 GB 239.1 3.3 0.0 3.3 7.9 4.7 0.0 1.7 129.6 315.3 25.76 24.14 79 0.326 3390K 3527 0.0 0.0 L1 13/0 1.41 GB 144.2 1.8 1.8 0.0 1.8 1.8 0.2 1.0 237.1 235.8 7.72 7.47 2 3.858 1857K 9618 0.0 0.0 L2 1/0 51.78 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 12/0 510.79 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 229.1 228.7 4.06 3.79 2 2.030 944K 1747 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.3 147.4 1.52 1.10 1 1.521 227K 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 1262/4 100.80 GB 0.0 6.5 2.4 4.1 11.2 7.1 3.0 2.4 165.2 282.8 40.56 37.95 86 0.472 6803K 15K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.4 4.1 11.2 7.1 2.9 2.4 165.2 282.8 40.56 37.95 86 0.472 6803K 15K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.5 2.4 4.1 6.5 2.4 0.0 0.0 245.7 245.2 27.27 26.06 19 1.435 6803K 15K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 360.1 13.30 11.90 67 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): 15.2 total, 15.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.20 GB write, 756.84 MB/s write, 6.54 GB read, 442.02 MB/s read, 40.6 seconds Interval compaction: 11.20 GB write, 765.68 MB/s write, 6.54 GB read, 447.19 MB/s read, 40.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 3, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 3, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 3, total-stops: 15, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1394207 Average: 2.1176 StdDev: 11.32 Min: 0 Median: 1.4267 Max: 4470 Percentiles: P50: 1.43 P75: 1.81 P99: 5.46 P99.9: 9.73 P99.99: 19.22 ------------------------------------------------------ [ 0, 1 ] 309792 22.220% 22.220% #### ( 1, 2 ] 907685 65.104% 87.324% ############# ( 2, 3 ] 98192 7.043% 94.367% # ( 3, 4 ] 45646 3.274% 97.641% # ( 4, 6 ] 25888 1.857% 99.498% ( 6, 10 ] 6008 0.431% 99.929% ( 10, 15 ] 792 0.057% 99.985% ( 15, 22 ] 107 0.008% 99.993% ( 22, 34 ] 19 0.001% 99.994% ( 34, 51 ] 13 0.001% 99.995% ( 51, 76 ] 6 0.000% 99.996% ( 76, 110 ] 85 0.006% 100.002% ( 110, 170 ] 123 0.009% 100.011% ( 170, 250 ] 57 0.004% 100.015% ( 250, 380 ] 53 0.004% 100.019% ( 380, 580 ] 37 0.003% 100.021% ( 580, 870 ] 28 0.002% 100.023% ( 870, 1300 ] 19 0.001% 100.025% ( 1300, 1900 ] 5 0.000% 100.025% ( 1900, 2900 ] 7 0.001% 100.025% ( 2900, 4400 ] 5 0.000% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 29393 Average: 3.8882 StdDev: 38.96 Min: 1 Median: 1.4665 Max: 2810 Percentiles: P50: 1.47 P75: 1.83 P99: 9.26 P99.9: 475.63 P99.99: 1806.07 ------------------------------------------------------ [ 0, 1 ] 5356 18.222% 18.222% #### ( 1, 2 ] 20022 68.118% 86.340% ############## ( 2, 3 ] 1995 6.787% 93.128% # ( 3, 4 ] 901 3.065% 96.193% # ( 4, 6 ] 431 1.466% 97.659% ( 6, 10 ] 484 1.647% 99.306% ( 10, 15 ] 29 0.099% 99.405% ( 15, 22 ] 2 0.007% 99.411% ( 51, 76 ] 2 0.007% 99.418% ( 76, 110 ] 63 0.214% 99.633% ( 110, 170 ] 40 0.136% 99.769% ( 170, 250 ] 10 0.034% 99.803% ( 250, 380 ] 20 0.068% 99.871% ( 380, 580 ] 18 0.061% 99.932% ( 580, 870 ] 7 0.024% 99.956% ( 870, 1300 ] 5 0.017% 99.973% ( 1300, 1900 ] 6 0.020% 99.993% ( 1900, 2900 ] 2 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200850 Average: 3.3858 StdDev: 31.53 Min: 0 Median: 1.6048 Max: 4418 Percentiles: P50: 1.60 P75: 2.00 P99: 8.78 P99.9: 207.89 P99.99: 571.98 ------------------------------------------------------ [ 0, 1 ] 22692 11.298% 11.298% ## ( 1, 2 ] 128523 63.990% 75.288% ############# ( 2, 3 ] 27656 13.769% 89.057% ### ( 3, 4 ] 10204 5.080% 94.137% # ( 4, 6 ] 7679 3.823% 97.961% # ( 6, 10 ] 3002 1.495% 99.455% ( 10, 15 ] 486 0.242% 99.697% ( 15, 22 ] 73 0.036% 99.734% ( 22, 34 ] 19 0.009% 99.743% ( 34, 51 ] 2 0.001% 99.744% ( 51, 76 ] 5 0.002% 99.747% ( 76, 110 ] 84 0.042% 99.788% ( 110, 170 ] 182 0.091% 99.879% ( 170, 250 ] 89 0.044% 99.923% ( 250, 380 ] 84 0.042% 99.965% ( 380, 580 ] 52 0.026% 99.991% ( 580, 870 ] 37 0.018% 100.009% ( 870, 1300 ] 17 0.008% 100.018% ( 1300, 1900 ] 16 0.008% 100.026% ( 1900, 2900 ] 10 0.005% 100.031% ( 2900, 4400 ] 3 0.001% 100.032% ( 4400, 6600 ] 1 0.000% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 115.8032 StdDev: 453.29 Min: 1 Median: 1.6614 Max: 3510 Percentiles: P50: 1.66 P75: 5.83 P99: 2375.00 P99.9: 3510.00 P99.99: 3510.00 ------------------------------------------------------ [ 0, 1 ] 71 22.903% 22.903% ##### ( 1, 2 ] 127 40.968% 63.871% ######## ( 2, 3 ] 24 7.742% 71.613% ## ( 3, 4 ] 5 1.613% 73.226% ( 4, 6 ] 6 1.935% 75.161% ( 6, 10 ] 8 2.581% 77.742% # ( 10, 15 ] 42 13.548% 91.290% ### ( 15, 22 ] 3 0.968% 92.258% ( 22, 34 ] 1 0.323% 92.581% ( 170, 250 ] 1 0.323% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 2 0.645% 94.516% ( 870, 1300 ] 3 0.968% 95.484% ( 1300, 1900 ] 9 2.903% 98.387% # ( 1900, 2900 ] 4 1.290% 99.677% ( 2900, 4400 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 813.9000 StdDev: 1020.83 Min: 77 Median: 302.0000 Max: 4354 Percentiles: P50: 302.00 P75: 1156.67 P99: 4250.00 P99.9: 4354.00 P99.99: 4354.00 ------------------------------------------------------ ( 76, 110 ] 6 10.000% 10.000% ## ( 110, 170 ] 17 28.333% 38.333% ###### ( 170, 250 ] 5 8.333% 46.667% ## ( 250, 380 ] 5 8.333% 55.000% ## ( 380, 580 ] 3 5.000% 60.000% # ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 7 11.667% 88.333% ## ( 1900, 2900 ] 1 1.667% 90.000% ( 2900, 4400 ] 6 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 15.2 total, 2.9 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 324.62 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.076 H:M:S, 13.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 336.17 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.384 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/22-15:45:09 ... thread 0: (1000000,6000000) ops and (259066.8,318431.9) ops/second in (3.860008,18.842333) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/15 3.63 GB 50.4 4.1 0.0 4.1 9.8 5.7 0.0 1.7 132.8 315.0 31.78 29.83 96 0.331 4285K 4543 0.0 0.0 L1 13/13 1.41 GB 0.0 1.8 1.8 0.0 1.8 1.8 0.2 1.0 237.1 235.8 7.72 7.47 2 3.858 1857K 9618 0.0 0.0 L2 1/0 51.78 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 12/0 510.79 MB 0.5 0.9 0.2 0.7 0.9 0.2 0.4 3.7 229.1 228.7 4.06 3.79 2 2.030 944K 1747 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.3 147.4 1.52 1.10 1 1.521 227K 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 1267/28 101.78 GB 0.0 7.4 2.4 5.0 13.0 8.1 3.0 2.3 162.8 286.8 46.58 43.64 103 0.452 7699K 16K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.4 2.4 5.0 13.0 8.1 2.9 2.3 162.8 286.8 46.58 43.64 103 0.452 7699K 16K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.4 2.4 5.0 7.4 2.4 0.0 0.0 248.4 247.9 30.52 29.26 22 1.387 7699K 16K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 360.9 16.06 14.38 81 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): 19.0 total, 18.8 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.05 GB write, 702.55 MB/s write, 7.40 GB read, 398.69 MB/s read, 46.6 seconds Interval compaction: 13.05 GB write, 709.08 MB/s write, 7.40 GB read, 402.39 MB/s read, 46.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 18, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1695562 Average: 2.1098 StdDev: 11.16 Min: 0 Median: 1.4146 Max: 4470 Percentiles: P50: 1.41 P75: 1.80 P99: 5.41 P99.9: 9.82 P99.99: 99.36 ------------------------------------------------------ [ 0, 1 ] 390760 23.046% 23.046% ##### ( 1, 2 ] 1102422 65.018% 88.064% ############# ( 2, 3 ] 112754 6.650% 94.714% # ( 3, 4 ] 52430 3.092% 97.806% # ( 4, 6 ] 28745 1.695% 99.502% ( 6, 10 ] 7068 0.417% 99.918% ( 10, 15 ] 935 0.055% 99.974% ( 15, 22 ] 122 0.007% 99.981% ( 22, 34 ] 22 0.001% 99.982% ( 34, 51 ] 14 0.001% 99.983% ( 51, 76 ] 6 0.000% 99.983% ( 76, 110 ] 168 0.010% 99.993% ( 110, 170 ] 226 0.013% 100.006% ( 170, 250 ] 80 0.005% 100.011% ( 250, 380 ] 75 0.004% 100.016% ( 380, 580 ] 51 0.003% 100.019% ( 580, 870 ] 35 0.002% 100.021% ( 870, 1300 ] 25 0.001% 100.022% ( 1300, 1900 ] 8 0.000% 100.023% ( 1900, 2900 ] 8 0.000% 100.023% ( 2900, 4400 ] 5 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 73100 Average: 3.0255 StdDev: 26.23 Min: 1 Median: 1.4111 Max: 2810 Percentiles: P50: 1.41 P75: 1.79 P99: 8.86 P99.9: 246.33 P99.99: 1369.00 ------------------------------------------------------ [ 0, 1 ] 16865 23.071% 23.071% ##### ( 1, 2 ] 47887 65.509% 88.580% ############# ( 2, 3 ] 3969 5.430% 94.010% # ( 3, 4 ] 1941 2.655% 96.665% # ( 4, 6 ] 901 1.233% 97.897% ( 6, 10 ] 1129 1.544% 99.442% ( 10, 15 ] 94 0.129% 99.570% ( 15, 22 ] 11 0.015% 99.585% ( 22, 34 ] 1 0.001% 99.587% ( 34, 51 ] 1 0.001% 99.588% ( 51, 76 ] 10 0.014% 99.602% ( 76, 110 ] 111 0.152% 99.754% ( 110, 170 ] 84 0.115% 99.869% ( 170, 250 ] 24 0.033% 99.902% ( 250, 380 ] 24 0.033% 99.934% ( 380, 580 ] 24 0.033% 99.967% ( 580, 870 ] 10 0.014% 99.981% ( 870, 1300 ] 6 0.008% 99.989% ( 1300, 1900 ] 6 0.008% 99.997% ( 1900, 2900 ] 2 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 200850 Average: 3.3858 StdDev: 31.53 Min: 0 Median: 1.6048 Max: 4418 Percentiles: P50: 1.60 P75: 2.00 P99: 8.78 P99.9: 207.89 P99.99: 571.98 ------------------------------------------------------ [ 0, 1 ] 22692 11.298% 11.298% ## ( 1, 2 ] 128523 63.990% 75.288% ############# ( 2, 3 ] 27656 13.769% 89.057% ### ( 3, 4 ] 10204 5.080% 94.137% # ( 4, 6 ] 7679 3.823% 97.961% # ( 6, 10 ] 3002 1.495% 99.455% ( 10, 15 ] 486 0.242% 99.697% ( 15, 22 ] 73 0.036% 99.734% ( 22, 34 ] 19 0.009% 99.743% ( 34, 51 ] 2 0.001% 99.744% ( 51, 76 ] 5 0.002% 99.747% ( 76, 110 ] 84 0.042% 99.788% ( 110, 170 ] 182 0.091% 99.879% ( 170, 250 ] 89 0.044% 99.923% ( 250, 380 ] 84 0.042% 99.965% ( 380, 580 ] 52 0.026% 99.991% ( 580, 870 ] 37 0.018% 100.009% ( 870, 1300 ] 17 0.008% 100.018% ( 1300, 1900 ] 16 0.008% 100.026% ( 1900, 2900 ] 10 0.005% 100.031% ( 2900, 4400 ] 3 0.001% 100.032% ( 4400, 6600 ] 1 0.000% 100.033% ** Level 4 read latency histogram (micros): Count: 310 Average: 115.8032 StdDev: 453.29 Min: 1 Median: 1.6614 Max: 3510 Percentiles: P50: 1.66 P75: 5.83 P99: 2375.00 P99.9: 3510.00 P99.99: 3510.00 ------------------------------------------------------ [ 0, 1 ] 71 22.903% 22.903% ##### ( 1, 2 ] 127 40.968% 63.871% ######## ( 2, 3 ] 24 7.742% 71.613% ## ( 3, 4 ] 5 1.613% 73.226% ( 4, 6 ] 6 1.935% 75.161% ( 6, 10 ] 8 2.581% 77.742% # ( 10, 15 ] 42 13.548% 91.290% ### ( 15, 22 ] 3 0.968% 92.258% ( 22, 34 ] 1 0.323% 92.581% ( 170, 250 ] 1 0.323% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 2 0.645% 94.516% ( 870, 1300 ] 3 0.968% 95.484% ( 1300, 1900 ] 9 2.903% 98.387% # ( 1900, 2900 ] 4 1.290% 99.677% ( 2900, 4400 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 813.9000 StdDev: 1020.83 Min: 77 Median: 302.0000 Max: 4354 Percentiles: P50: 302.00 P75: 1156.67 P99: 4250.00 P99.9: 4354.00 P99.99: 4354.00 ------------------------------------------------------ ( 76, 110 ] 6 10.000% 10.000% ## ( 110, 170 ] 17 28.333% 38.333% ###### ( 170, 250 ] 5 8.333% 46.667% ## ( 250, 380 ] 5 8.333% 55.000% ## ( 380, 580 ] 3 5.000% 60.000% # ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 7 11.667% 88.333% ## ( 1900, 2900 ] 1 1.667% 90.000% ( 2900, 4400 ] 6 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 19.0 total, 3.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 310.49 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.357 H:M:S, 17.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 254.97 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.281 H:M:S, 33.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/22-15:45:30 ... thread 0: (1000000,7000000) ops and (48527.9,177444.1) ops/second in (20.606720,39.449053) 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 7/6 1.47 GB 12.6 5.9 0.0 5.9 12.5 6.6 0.0 1.9 144.4 306.7 41.86 39.13 115 0.364 6139K 9778 0.0 0.0 L1 8/8 950.65 MB 0.0 6.3 4.9 1.4 6.2 4.8 0.2 1.3 222.5 218.9 29.13 27.12 3 9.711 6581K 105K 0.0 0.0 L2 28/18 3.52 GB 12.9 0.4 0.2 0.2 0.4 0.2 4.1 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 11/3 562.45 MB 0.2 1.0 0.3 0.7 1.0 0.3 0.4 3.3 215.3 214.9 4.68 4.16 3 1.559 1022K 1861 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.3 147.4 1.52 1.10 1 1.521 227K 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 1276/35 102.67 GB 0.0 13.8 5.6 8.2 20.3 12.1 6.5 3.1 179.7 264.6 78.69 72.96 124 0.635 14M 117K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.8 5.6 8.2 20.3 12.1 6.4 3.1 179.7 264.6 78.69 72.96 124 0.635 14M 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 13.8 5.6 8.2 13.7 5.5 0.0 0.0 237.2 235.2 59.61 55.93 28 2.129 14M 117K 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 356.6 19.08 17.02 96 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 39.6 total, 39.5 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 20.34 GB write, 525.51 MB/s write, 13.81 GB read, 356.77 MB/s read, 78.7 seconds Interval compaction: 20.34 GB write, 527.84 MB/s write, 13.81 GB read, 358.36 MB/s read, 78.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 3, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 19, interval: 35 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2986599 Average: 2.6364 StdDev: 15.82 Min: 0 Median: 1.4082 Max: 4470 Percentiles: P50: 1.41 P75: 1.80 P99: 6.75 P99.9: 153.85 P99.99: 356.55 ------------------------------------------------------ [ 0, 1 ] 713555 23.892% 23.892% ##### ( 1, 2 ] 1910427 63.967% 87.859% ############# ( 2, 3 ] 186087 6.231% 94.089% # ( 3, 4 ] 89566 2.999% 97.088% # ( 4, 6 ] 53314 1.785% 98.873% ( 6, 10 ] 20092 0.673% 99.546% ( 10, 15 ] 2477 0.083% 99.629% ( 15, 22 ] 571 0.019% 99.648% ( 22, 34 ] 43 0.001% 99.650% ( 34, 51 ] 30 0.001% 99.651% ( 51, 76 ] 62 0.002% 99.653% ( 76, 110 ] 4301 0.144% 99.797% ( 110, 170 ] 4226 0.141% 99.938% ( 170, 250 ] 993 0.033% 99.971% ( 250, 380 ] 680 0.023% 99.994% ( 380, 580 ] 498 0.017% 100.011% ( 580, 870 ] 213 0.007% 100.018% ( 870, 1300 ] 58 0.002% 100.020% ( 1300, 1900 ] 19 0.001% 100.021% ( 1900, 2900 ] 14 0.000% 100.021% ( 2900, 4400 ] 10 0.000% 100.021% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 642511 Average: 3.2420 StdDev: 23.71 Min: 1 Median: 1.4897 Max: 3166 Percentiles: P50: 1.49 P75: 1.91 P99: 9.10 P99.9: 174.75 P99.99: 409.85 ------------------------------------------------------ [ 0, 1 ] 132468 20.617% 20.617% #### ( 1, 2 ] 385532 60.004% 80.621% ############ ( 2, 3 ] 57528 8.954% 89.575% ## ( 3, 4 ] 30214 4.702% 94.277% # ( 4, 6 ] 22784 3.546% 97.823% # ( 6, 10 ] 9767 1.520% 99.344% ( 10, 15 ] 1456 0.227% 99.570% ( 15, 22 ] 245 0.038% 99.608% ( 22, 34 ] 18 0.003% 99.611% ( 34, 51 ] 3 0.000% 99.612% ( 51, 76 ] 58 0.009% 99.621% ( 76, 110 ] 857 0.133% 99.754% ( 110, 170 ] 923 0.144% 99.898% ( 170, 250 ] 278 0.043% 99.941% ( 250, 380 ] 286 0.045% 99.985% ( 380, 580 ] 206 0.032% 100.017% ( 580, 870 ] 133 0.021% 100.038% ( 870, 1300 ] 59 0.009% 100.047% ( 1300, 1900 ] 23 0.004% 100.051% ( 1900, 2900 ] 6 0.001% 100.052% ( 2900, 4400 ] 4 0.001% 100.052% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 207273 Average: 4.2565 StdDev: 40.85 Min: 0 Median: 1.6087 Max: 4418 Percentiles: P50: 1.61 P75: 2.01 P99: 9.40 P99.9: 438.09 P99.99: 872.79 ------------------------------------------------------ [ 0, 1 ] 23338 11.260% 11.260% ## ( 1, 2 ] 131917 63.644% 74.904% ############# ( 2, 3 ] 28502 13.751% 88.655% ### ( 3, 4 ] 10779 5.200% 93.855% # ( 4, 6 ] 8000 3.860% 97.715% # ( 6, 10 ] 3130 1.510% 99.225% ( 10, 15 ] 538 0.260% 99.484% ( 15, 22 ] 82 0.040% 99.524% ( 22, 34 ] 21 0.010% 99.534% ( 34, 51 ] 2 0.001% 99.535% ( 51, 76 ] 5 0.002% 99.537% ( 76, 110 ] 141 0.068% 99.605% ( 110, 170 ] 252 0.122% 99.727% ( 170, 250 ] 163 0.079% 99.806% ( 250, 380 ] 160 0.077% 99.883% ( 380, 580 ] 123 0.059% 99.942% ( 580, 870 ] 99 0.048% 99.990% ( 870, 1300 ] 42 0.020% 100.010% ( 1300, 1900 ] 28 0.014% 100.024% ( 1900, 2900 ] 11 0.005% 100.029% ( 2900, 4400 ] 5 0.002% 100.031% ( 4400, 6600 ] 1 0.000% 100.032% ** Level 4 read latency histogram (micros): Count: 310 Average: 115.8032 StdDev: 453.29 Min: 1 Median: 1.6614 Max: 3510 Percentiles: P50: 1.66 P75: 5.83 P99: 2375.00 P99.9: 3510.00 P99.99: 3510.00 ------------------------------------------------------ [ 0, 1 ] 71 22.903% 22.903% ##### ( 1, 2 ] 127 40.968% 63.871% ######## ( 2, 3 ] 24 7.742% 71.613% ## ( 3, 4 ] 5 1.613% 73.226% ( 4, 6 ] 6 1.935% 75.161% ( 6, 10 ] 8 2.581% 77.742% # ( 10, 15 ] 42 13.548% 91.290% ### ( 15, 22 ] 3 0.968% 92.258% ( 22, 34 ] 1 0.323% 92.581% ( 170, 250 ] 1 0.323% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 2 0.645% 93.871% ( 580, 870 ] 2 0.645% 94.516% ( 870, 1300 ] 3 0.968% 95.484% ( 1300, 1900 ] 9 2.903% 98.387% # ( 1900, 2900 ] 4 1.290% 99.677% ( 2900, 4400 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 813.9000 StdDev: 1020.83 Min: 77 Median: 302.0000 Max: 4354 Percentiles: P50: 302.00 P75: 1156.67 P99: 4250.00 P99.9: 4354.00 P99.99: 4354.00 ------------------------------------------------------ ( 76, 110 ] 6 10.000% 10.000% ## ( 110, 170 ] 17 28.333% 38.333% ###### ( 170, 250 ] 5 8.333% 46.667% ## ( 250, 380 ] 5 8.333% 55.000% ## ( 380, 580 ] 3 5.000% 60.000% # ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 3 5.000% 76.667% # ( 1300, 1900 ] 7 11.667% 88.333% ## ( 1900, 2900 ] 1 1.667% 90.000% ( 2900, 4400 ] 6 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 39.6 total, 20.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 173.86 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.799 H:M:S, 52.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 47.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:17.442 H:M:S, 84.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/22-15:45:36 ... thread 0: (1000000,8000000) ops and (145395.5,172686.0) ops/second in (6.877794,46.326847) 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/5 2.45 GB 107.0 6.8 0.0 6.8 14.4 7.6 0.0 1.9 136.3 288.3 51.31 45.77 130 0.395 7098K 10K 0.0 0.0 L1 8/8 950.65 MB 0.0 6.3 4.9 1.4 6.2 4.8 0.2 1.3 222.5 218.9 29.13 27.12 3 9.711 6581K 105K 0.0 0.0 L2 3/3 386.35 MB 0.0 0.4 0.2 0.2 0.4 0.2 4.1 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 31/12 1.94 GB 1.1 4.6 3.4 1.1 4.5 3.4 0.4 1.3 192.1 191.5 24.26 20.73 8 3.032 4210K 9878 0.0 0.0 L4 182/5 10.40 GB 1.1 2.0 1.9 0.1 2.0 1.9 0.8 1.0 111.2 111.0 18.53 10.55 24 0.772 2046K 2148 0.0 0.0 L5 1064/0 87.54 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1297/33 103.63 GB 0.0 20.1 10.5 9.6 27.6 18.0 7.5 3.6 164.9 226.5 124.74 105.62 167 0.747 20M 128K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.1 10.5 9.6 27.6 18.0 7.4 3.6 164.9 226.5 124.74 105.62 167 0.747 20M 128K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.1 10.5 9.6 20.0 10.3 0.0 0.0 204.3 202.9 100.70 85.77 59 1.707 20M 128K 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 325.0 24.03 19.85 108 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): 46.5 total, 46.3 interval Flush(GB): cumulative 7.628, interval 7.628 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 27.59 GB write, 607.46 MB/s write, 20.09 GB read, 442.39 MB/s read, 124.7 seconds Interval compaction: 27.59 GB write, 609.76 MB/s write, 20.09 GB read, 444.07 MB/s read, 124.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 37, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 37, interval: 58 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3361795 Average: 2.8804 StdDev: 39.70 Min: 0 Median: 1.4464 Max: 18309 Percentiles: P50: 1.45 P75: 1.84 P99: 7.38 P99.9: 154.88 P99.99: 437.56 ------------------------------------------------------ [ 0, 1 ] 731897 21.771% 21.771% #### ( 1, 2 ] 2125682 63.231% 85.002% ############# ( 2, 3 ] 252513 7.511% 92.513% ## ( 3, 4 ] 122581 3.646% 96.159% # ( 4, 6 ] 86121 2.562% 98.721% # ( 6, 10 ] 27269 0.811% 99.532% ( 10, 15 ] 3962 0.118% 99.650% ( 15, 22 ] 752 0.022% 99.672% ( 22, 34 ] 56 0.002% 99.674% ( 34, 51 ] 38 0.001% 99.675% ( 51, 76 ] 62 0.002% 99.677% ( 76, 110 ] 4316 0.128% 99.805% ( 110, 170 ] 4257 0.127% 99.932% ( 170, 250 ] 1037 0.031% 99.963% ( 250, 380 ] 744 0.022% 99.985% ( 380, 580 ] 597 0.018% 100.003% ( 580, 870 ] 309 0.009% 100.012% ( 870, 1300 ] 139 0.004% 100.016% ( 1300, 1900 ] 63 0.002% 100.018% ( 1900, 2900 ] 31 0.001% 100.019% ( 2900, 4400 ] 36 0.001% 100.020% ( 4400, 6600 ] 17 0.001% 100.020% ( 6600, 9900 ] 7 0.000% 100.021% ( 9900, 14000 ] 5 0.000% 100.021% ( 14000, 22000 ] 9 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1506309 Average: 5.2445 StdDev: 108.79 Min: 1 Median: 1.6574 Max: 26019 Percentiles: P50: 1.66 P75: 2.34 P99: 9.44 P99.9: 204.57 P99.99: 520.98 ------------------------------------------------------ [ 0, 1 ] 163555 10.858% 10.858% ## ( 1, 2 ] 896823 59.538% 70.396% ############ ( 2, 3 ] 205827 13.664% 84.060% ### ( 3, 4 ] 108644 7.213% 91.273% # ( 4, 6 ] 91281 6.060% 97.333% # ( 6, 10 ] 29235 1.941% 99.273% ( 10, 15 ] 6078 0.404% 99.677% ( 15, 22 ] 753 0.050% 99.727% ( 22, 34 ] 50 0.003% 99.730% ( 34, 51 ] 17 0.001% 99.731% ( 51, 76 ] 66 0.004% 99.736% ( 76, 110 ] 1037 0.069% 99.805% ( 110, 170 ] 1196 0.079% 99.884% ( 170, 250 ] 557 0.037% 99.921% ( 250, 380 ] 627 0.042% 99.963% ( 380, 580 ] 585 0.039% 100.001% ( 580, 870 ] 517 0.034% 100.036% ( 870, 1300 ] 304 0.020% 100.056% ( 1300, 1900 ] 161 0.011% 100.067% ( 1900, 2900 ] 176 0.012% 100.078% ( 2900, 4400 ] 204 0.014% 100.092% ( 4400, 6600 ] 59 0.004% 100.096% ( 6600, 9900 ] 39 0.003% 100.098% ( 9900, 14000 ] 11 0.001% 100.099% ( 14000, 22000 ] 25 0.002% 100.101% ( 22000, 33000 ] 2 0.000% 100.101% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 771639 Average: 8.7949 StdDev: 164.91 Min: 0 Median: 1.8123 Max: 45115 Percentiles: P50: 1.81 P75: 2.79 P99: 9.84 P99.9: 541.78 P99.99: 907.64 ------------------------------------------------------ [ 0, 1 ] 38666 5.011% 5.011% # ( 1, 2 ] 427346 55.382% 60.392% ########### ( 2, 3 ] 142423 18.457% 78.850% #### ( 3, 4 ] 71173 9.224% 88.073% ## ( 4, 6 ] 69796 9.045% 97.118% ## ( 6, 10 ] 15117 1.959% 99.078% ( 10, 15 ] 4132 0.535% 99.613% ( 15, 22 ] 532 0.069% 99.682% ( 22, 34 ] 56 0.007% 99.689% ( 34, 51 ] 19 0.002% 99.692% ( 51, 76 ] 11 0.001% 99.693% ( 76, 110 ] 149 0.019% 99.712% ( 110, 170 ] 304 0.039% 99.752% ( 170, 250 ] 324 0.042% 99.794% ( 250, 380 ] 423 0.055% 99.849% ( 380, 580 ] 490 0.064% 99.912% ( 580, 870 ] 566 0.073% 99.985% ( 870, 1300 ] 398 0.052% 100.037% ( 1300, 1900 ] 306 0.040% 100.077% ( 1900, 2900 ] 305 0.040% 100.116% ( 2900, 4400 ] 316 0.041% 100.157% ( 4400, 6600 ] 63 0.008% 100.165% ( 6600, 9900 ] 31 0.004% 100.169% ( 9900, 14000 ] 12 0.002% 100.171% ( 14000, 22000 ] 8 0.001% 100.172% ( 22000, 33000 ] 4 0.001% 100.172% ( 33000, 50000 ] 2 0.000% 100.173% ** Level 4 read latency histogram (micros): Count: 25359 Average: 107.1754 StdDev: 735.34 Min: 1 Median: 1.9067 Max: 31864 Percentiles: P50: 1.91 P75: 3.21 P99: 2518.61 P99.9: 9442.08 P99.99: 19642.73 ------------------------------------------------------ [ 0, 1 ] 1277 5.036% 5.036% # ( 1, 2 ] 12576 49.592% 54.628% ########## ( 2, 3 ] 4623 18.230% 72.858% #### ( 3, 4 ] 2600 10.253% 83.111% ## ( 4, 6 ] 1708 6.735% 89.846% # ( 6, 10 ] 507 1.999% 91.845% ( 10, 15 ] 188 0.741% 92.586% ( 15, 22 ] 27 0.106% 92.693% ( 22, 34 ] 8 0.032% 92.724% ( 34, 51 ] 2 0.008% 92.732% ( 51, 76 ] 16 0.063% 92.795% ( 76, 110 ] 9 0.035% 92.831% ( 110, 170 ] 46 0.181% 93.012% ( 170, 250 ] 115 0.453% 93.466% ( 250, 380 ] 137 0.540% 94.006% ( 380, 580 ] 314 1.238% 95.244% ( 580, 870 ] 370 1.459% 96.703% ( 870, 1300 ] 305 1.203% 97.906% ( 1300, 1900 ] 184 0.726% 98.632% ( 1900, 2900 ] 151 0.595% 99.227% ( 2900, 4400 ] 136 0.536% 99.763% ( 4400, 6600 ] 20 0.079% 99.842% ( 6600, 9900 ] 17 0.067% 99.909% ( 9900, 14000 ] 12 0.047% 99.957% ( 14000, 22000 ] 12 0.047% 100.004% ( 22000, 33000 ] 4 0.016% 100.020% ** Level 5 read latency histogram (micros): Count: 120 Average: 1035.3667 StdDev: 1274.01 Min: 77 Median: 470.9091 Max: 5960 Percentiles: P50: 470.91 P75: 1300.00 P99: 5280.00 P99.9: 5960.00 P99.99: 5960.00 ------------------------------------------------------ ( 76, 110 ] 12 10.000% 10.000% ## ( 110, 170 ] 22 18.333% 28.333% #### ( 170, 250 ] 8 6.667% 35.000% # ( 250, 380 ] 13 10.833% 45.833% ## ( 380, 580 ] 11 9.167% 55.000% ## ( 580, 870 ] 13 10.833% 65.833% ## ( 870, 1300 ] 11 9.167% 75.000% ## ( 1300, 1900 ] 8 6.667% 81.667% # ( 1900, 2900 ] 5 4.167% 85.833% # ( 2900, 4400 ] 15 12.500% 98.333% ### ( 4400, 6600 ] 2 1.667% 100.000% ** DB Stats ** Uptime(secs): 46.5 total, 6.9 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 169.31 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.802 H:M:S, 53.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 143.10 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.003 H:M:S, 58.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/07/22-15:45:41 ... thread 0: (1000000,9000000) ops and (239498.2,178209.9) ops/second in (4.175396,50.502243) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/8 2.34 GB 176.2 7.5 0.0 7.5 16.0 8.5 0.0 1.9 132.2 282.7 58.12 50.92 144 0.404 7802K 11K 0.0 0.0 L1 12/0 1.25 GB 128.3 8.3 6.0 2.3 8.2 5.8 0.2 1.4 211.0 208.1 40.27 36.09 4 10.068 7663K 105K 0.0 0.0 L2 4/2 240.80 MB 1.2 0.4 0.2 0.2 0.4 0.2 4.8 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 24/5 1.36 GB 1.0 5.9 4.1 1.9 5.9 4.0 0.7 1.5 180.2 179.6 33.57 27.01 14 2.398 5620K 13K 0.0 0.0 L4 174/1 9.48 GB 1.0 3.5 3.3 0.2 3.5 3.3 0.9 1.0 118.4 118.1 30.32 17.64 43 0.705 3546K 3335 0.0 0.0 L5 1092/0 89.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1320/16 104.54 GB 0.0 25.6 13.5 12.0 34.0 21.9 10.8 4.0 159.9 212.5 163.79 133.11 207 0.791 25M 133K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.6 13.5 12.0 34.0 21.9 10.7 4.0 159.9 212.5 163.79 133.11 207 0.791 25M 133K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.6 13.5 12.0 25.4 13.4 0.0 0.0 192.6 191.5 136.00 110.80 87 1.563 25M 133K 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 315.1 27.79 22.31 120 0.232 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 50.7 total, 50.5 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: 33.98 GB write, 686.68 MB/s write, 25.58 GB read, 516.94 MB/s read, 163.8 seconds Interval compaction: 33.98 GB write, 689.06 MB/s write, 25.58 GB read, 518.73 MB/s read, 163.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 53, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 53, interval: 74 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3642280 Average: 2.9267 StdDev: 39.88 Min: 0 Median: 1.4637 Max: 18309 Percentiles: P50: 1.46 P75: 1.86 P99: 7.45 P99.9: 154.15 P99.99: 478.68 ------------------------------------------------------ [ 0, 1 ] 757805 20.806% 20.806% #### ( 1, 2 ] 2293223 62.961% 83.767% ############# ( 2, 3 ] 292476 8.030% 91.797% ## ( 3, 4 ] 144993 3.981% 95.778% # ( 4, 6 ] 106206 2.916% 98.694% # ( 6, 10 ] 30801 0.846% 99.539% ( 10, 15 ] 4669 0.128% 99.668% ( 15, 22 ] 823 0.023% 99.690% ( 22, 34 ] 68 0.002% 99.692% ( 34, 51 ] 43 0.001% 99.693% ( 51, 76 ] 63 0.002% 99.695% ( 76, 110 ] 4319 0.119% 99.814% ( 110, 170 ] 4280 0.118% 99.931% ( 170, 250 ] 1055 0.029% 99.960% ( 250, 380 ] 776 0.021% 99.981% ( 380, 580 ] 642 0.018% 99.999% ( 580, 870 ] 363 0.010% 100.009% ( 870, 1300 ] 178 0.005% 100.014% ( 1300, 1900 ] 84 0.002% 100.016% ( 1900, 2900 ] 53 0.001% 100.018% ( 2900, 4400 ] 49 0.001% 100.019% ( 4400, 6600 ] 20 0.001% 100.019% ( 6600, 9900 ] 7 0.000% 100.020% ( 9900, 14000 ] 5 0.000% 100.020% ( 14000, 22000 ] 9 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1726962 Average: 5.4690 StdDev: 107.98 Min: 1 Median: 1.6726 Max: 26019 Percentiles: P50: 1.67 P75: 2.39 P99: 9.52 P99.9: 270.89 P99.99: 652.97 ------------------------------------------------------ [ 0, 1 ] 173196 10.029% 10.029% ## ( 1, 2 ] 1026249 59.425% 69.454% ############ ( 2, 3 ] 244427 14.154% 83.608% ### ( 3, 4 ] 127317 7.372% 90.980% # ( 4, 6 ] 108498 6.283% 97.263% # ( 6, 10 ] 34092 1.974% 99.237% ( 10, 15 ] 7211 0.418% 99.654% ( 15, 22 ] 906 0.052% 99.707% ( 22, 34 ] 61 0.004% 99.710% ( 34, 51 ] 25 0.001% 99.712% ( 51, 76 ] 68 0.004% 99.716% ( 76, 110 ] 1132 0.066% 99.781% ( 110, 170 ] 1282 0.074% 99.855% ( 170, 250 ] 648 0.038% 99.893% ( 250, 380 ] 772 0.045% 99.938% ( 380, 580 ] 741 0.043% 99.980% ( 580, 870 ] 657 0.038% 100.019% ( 870, 1300 ] 397 0.023% 100.042% ( 1300, 1900 ] 219 0.013% 100.054% ( 1900, 2900 ] 230 0.013% 100.068% ( 2900, 4400 ] 273 0.016% 100.083% ( 4400, 6600 ] 71 0.004% 100.087% ( 6600, 9900 ] 45 0.003% 100.090% ( 9900, 14000 ] 11 0.001% 100.091% ( 14000, 22000 ] 25 0.001% 100.092% ( 22000, 33000 ] 2 0.000% 100.092% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1304146 Average: 7.9875 StdDev: 142.66 Min: 0 Median: 1.8265 Max: 45115 Percentiles: P50: 1.83 P75: 2.82 P99: 9.65 P99.9: 418.25 P99.99: 773.87 ------------------------------------------------------ [ 0, 1 ] 52876 4.054% 4.054% # ( 1, 2 ] 725007 55.592% 59.647% ########### ( 2, 3 ] 242843 18.621% 78.268% #### ( 3, 4 ] 124486 9.545% 87.813% ## ( 4, 6 ] 121929 9.349% 97.163% ## ( 6, 10 ] 26243 2.012% 99.175% ( 10, 15 ] 6814 0.522% 99.697% ( 15, 22 ] 832 0.064% 99.761% ( 22, 34 ] 86 0.007% 99.768% ( 34, 51 ] 32 0.002% 99.770% ( 51, 76 ] 14 0.001% 99.771% ( 76, 110 ] 175 0.013% 99.785% ( 110, 170 ] 365 0.028% 99.813% ( 170, 250 ] 416 0.032% 99.844% ( 250, 380 ] 581 0.045% 99.889% ( 380, 580 ] 747 0.057% 99.946% ( 580, 870 ] 852 0.065% 100.012% ( 870, 1300 ] 589 0.045% 100.057% ( 1300, 1900 ] 459 0.035% 100.092% ( 1900, 2900 ] 457 0.035% 100.127% ( 2900, 4400 ] 496 0.038% 100.165% ( 4400, 6600 ] 105 0.008% 100.173% ( 6600, 9900 ] 38 0.003% 100.176% ( 9900, 14000 ] 12 0.001% 100.177% ( 14000, 22000 ] 9 0.001% 100.178% ( 22000, 33000 ] 4 0.000% 100.178% ( 33000, 50000 ] 2 0.000% 100.178% ** Level 4 read latency histogram (micros): Count: 42653 Average: 86.6394 StdDev: 602.29 Min: 1 Median: 1.9013 Max: 31864 Percentiles: P50: 1.90 P75: 3.16 P99: 2015.62 P99.9: 6489.80 P99.99: 17823.13 ------------------------------------------------------ [ 0, 1 ] 2057 4.823% 4.823% # ( 1, 2 ] 21380 50.125% 54.948% ########## ( 2, 3 ] 7868 18.447% 73.395% #### ( 3, 4 ] 4358 10.217% 83.612% ## ( 4, 6 ] 2859 6.703% 90.315% # ( 6, 10 ] 871 2.042% 92.357% ( 10, 15 ] 289 0.678% 93.034% ( 15, 22 ] 37 0.087% 93.121% ( 22, 34 ] 10 0.023% 93.145% ( 34, 51 ] 7 0.016% 93.161% ( 51, 76 ] 29 0.068% 93.229% ( 76, 110 ] 51 0.120% 93.349% ( 110, 170 ] 126 0.295% 93.644% ( 170, 250 ] 221 0.518% 94.162% ( 250, 380 ] 231 0.542% 94.704% ( 380, 580 ] 502 1.177% 95.881% ( 580, 870 ] 590 1.383% 97.264% ( 870, 1300 ] 440 1.032% 98.296% ( 1300, 1900 ] 277 0.649% 98.945% ( 1900, 2900 ] 203 0.476% 99.421% ( 2900, 4400 ] 173 0.406% 99.827% ( 4400, 6600 ] 33 0.077% 99.904% ( 6600, 9900 ] 19 0.045% 99.948% ( 9900, 14000 ] 12 0.028% 99.977% ( 14000, 22000 ] 12 0.028% 100.005% ( 22000, 33000 ] 4 0.009% 100.014% ** Level 5 read latency histogram (micros): Count: 260 Average: 1324.3077 StdDev: 1617.64 Min: 77 Median: 694.4737 Max: 11317 Percentiles: P50: 694.47 P75: 1787.50 P99: 8140.00 P99.9: 11317.00 P99.99: 11317.00 ------------------------------------------------------ ( 76, 110 ] 15 5.769% 5.769% # ( 110, 170 ] 33 12.692% 18.462% ### ( 170, 250 ] 13 5.000% 23.462% # ( 250, 380 ] 26 10.000% 33.462% ## ( 380, 580 ] 28 10.769% 44.231% ## ( 580, 870 ] 38 14.615% 58.846% ### ( 870, 1300 ] 29 11.154% 70.000% ## ( 1300, 1900 ] 16 6.154% 76.154% # ( 1900, 2900 ] 19 7.308% 83.462% # ( 2900, 4400 ] 31 11.923% 95.385% ## ( 4400, 6600 ] 8 3.077% 98.462% # ( 6600, 9900 ] 3 1.154% 99.615% ( 9900, 14000 ] 1 0.385% 100.000% ** DB Stats ** Uptime(secs): 50.7 total, 4.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 174.78 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:26.226 H:M:S, 51.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 235.71 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.423 H:M:S, 34.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/22-15:45:44 ... thread 0: (1000000,10000000) ops and (319649.6,186460.5) ops/second in (3.128426,53.630669) 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/8 3.26 GB 276.9 8.4 0.0 8.4 17.9 9.5 0.0 1.9 133.5 283.5 64.62 56.92 160 0.404 8761K 12K 0.0 0.0 L1 12/0 1.25 GB 128.3 8.3 6.0 2.3 8.2 5.8 0.2 1.4 211.0 208.1 40.27 36.09 4 10.068 7663K 105K 0.0 0.0 L2 1/0 59.87 MB 0.6 0.4 0.2 0.2 0.4 0.2 4.8 2.0 251.7 251.5 1.50 1.45 2 0.751 383K 196 0.0 0.0 L3 19/0 941.47 MB 0.9 6.5 4.2 2.3 6.5 4.2 0.7 1.5 181.2 180.6 36.78 29.77 17 2.164 6245K 15K 0.0 0.0 L4 174/0 9.47 GB 1.0 4.2 4.0 0.3 4.2 3.9 0.9 1.1 126.7 126.4 34.20 20.92 51 0.671 4269K 4671 0.0 0.0 L5 1100/0 90.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1324/8 105.45 GB 0.0 27.8 14.3 13.5 37.2 23.6 11.4 3.9 160.7 214.5 177.38 145.14 234 0.758 27M 138K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.8 14.3 13.5 37.2 23.6 11.3 3.9 160.7 214.5 177.38 145.14 234 0.758 27M 138K 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 27.8 14.3 13.5 27.7 14.2 0.0 0.0 194.2 193.1 146.78 120.43 101 1.453 27M 138K 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 317.1 30.60 24.71 133 0.230 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 53.8 total, 53.6 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: 37.15 GB write, 707.05 MB/s write, 27.84 GB read, 529.73 MB/s read, 177.4 seconds Interval compaction: 37.15 GB write, 709.36 MB/s write, 27.84 GB read, 531.46 MB/s read, 177.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 63, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 63, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3887237 Average: 2.8805 StdDev: 38.70 Min: 0 Median: 1.4641 Max: 18309 Percentiles: P50: 1.46 P75: 1.86 P99: 7.26 P99.9: 150.83 P99.99: 469.35 ------------------------------------------------------ [ 0, 1 ] 805894 20.732% 20.732% #### ( 1, 2 ] 2451382 63.062% 83.794% ############# ( 2, 3 ] 312473 8.038% 91.833% ## ( 3, 4 ] 154982 3.987% 95.819% # ( 4, 6 ] 113602 2.922% 98.742% # ( 6, 10 ] 31746 0.817% 99.559% ( 10, 15 ] 5010 0.129% 99.687% ( 15, 22 ] 845 0.022% 99.709% ( 22, 34 ] 70 0.002% 99.711% ( 34, 51 ] 47 0.001% 99.712% ( 51, 76 ] 64 0.002% 99.714% ( 76, 110 ] 4319 0.111% 99.825% ( 110, 170 ] 4286 0.110% 99.935% ( 170, 250 ] 1061 0.027% 99.963% ( 250, 380 ] 781 0.020% 99.983% ( 380, 580 ] 643 0.017% 99.999% ( 580, 870 ] 367 0.009% 100.009% ( 870, 1300 ] 182 0.005% 100.013% ( 1300, 1900 ] 87 0.002% 100.016% ( 1900, 2900 ] 56 0.001% 100.017% ( 2900, 4400 ] 49 0.001% 100.018% ( 4400, 6600 ] 20 0.001% 100.019% ( 6600, 9900 ] 7 0.000% 100.019% ( 9900, 14000 ] 5 0.000% 100.019% ( 14000, 22000 ] 9 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 1751290 Average: 5.4357 StdDev: 107.24 Min: 1 Median: 1.6724 Max: 26019 Percentiles: P50: 1.67 P75: 2.39 P99: 9.51 P99.9: 268.86 P99.99: 653.43 ------------------------------------------------------ [ 0, 1 ] 174551 9.967% 9.967% ## ( 1, 2 ] 1042656 59.536% 69.503% ############ ( 2, 3 ] 247695 14.144% 83.647% ### ( 3, 4 ] 128756 7.352% 90.999% # ( 4, 6 ] 109742 6.266% 97.265% # ( 6, 10 ] 34573 1.974% 99.240% ( 10, 15 ] 7274 0.415% 99.655% ( 15, 22 ] 910 0.052% 99.707% ( 22, 34 ] 61 0.003% 99.710% ( 34, 51 ] 26 0.001% 99.712% ( 51, 76 ] 68 0.004% 99.716% ( 76, 110 ] 1156 0.066% 99.782% ( 110, 170 ] 1302 0.074% 99.856% ( 170, 250 ] 656 0.037% 99.894% ( 250, 380 ] 777 0.044% 99.938% ( 380, 580 ] 745 0.043% 99.980% ( 580, 870 ] 659 0.038% 100.018% ( 870, 1300 ] 399 0.023% 100.041% ( 1300, 1900 ] 219 0.013% 100.053% ( 1900, 2900 ] 230 0.013% 100.067% ( 2900, 4400 ] 273 0.016% 100.082% ( 4400, 6600 ] 71 0.004% 100.086% ( 6600, 9900 ] 45 0.003% 100.089% ( 9900, 14000 ] 11 0.001% 100.089% ( 14000, 22000 ] 25 0.001% 100.091% ( 22000, 33000 ] 2 0.000% 100.091% ** Level 2 read latency histogram (micros): Count: 95908 Average: 1.9725 StdDev: 7.15 Min: 1 Median: 1.3536 Max: 1658 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.71 P99.99: 27.64 ------------------------------------------------------ [ 0, 1 ] 27704 28.886% 28.886% ###### ( 1, 2 ] 57261 59.704% 88.590% ############ ( 2, 3 ] 5878 6.129% 94.719% # ( 3, 4 ] 2912 3.036% 97.755% # ( 4, 6 ] 1659 1.730% 99.485% ( 6, 10 ] 429 0.447% 99.932% ( 10, 15 ] 47 0.049% 99.981% ( 15, 22 ] 7 0.007% 99.989% ( 22, 34 ] 3 0.003% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 250, 380 ] 3 0.003% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 1 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1505157 Average: 7.3909 StdDev: 133.42 Min: 0 Median: 1.8137 Max: 45115 Percentiles: P50: 1.81 P75: 2.79 P99: 9.53 P99.9: 343.23 P99.99: 703.29 ------------------------------------------------------ [ 0, 1 ] 61812 4.107% 4.107% # ( 1, 2 ] 848887 56.399% 60.505% ########### ( 2, 3 ] 276823 18.392% 78.897% #### ( 3, 4 ] 140629 9.343% 88.240% ## ( 4, 6 ] 136148 9.045% 97.285% ## ( 6, 10 ] 29272 1.945% 99.230% ( 10, 15 ] 7466 0.496% 99.726% ( 15, 22 ] 892 0.059% 99.786% ( 22, 34 ] 88 0.006% 99.791% ( 34, 51 ] 33 0.002% 99.794% ( 51, 76 ] 14 0.001% 99.795% ( 76, 110 ] 226 0.015% 99.810% ( 110, 170 ] 440 0.029% 99.839% ( 170, 250 ] 460 0.031% 99.869% ( 250, 380 ] 644 0.043% 99.912% ( 380, 580 ] 792 0.053% 99.965% ( 580, 870 ] 895 0.059% 100.024% ( 870, 1300 ] 612 0.041% 100.065% ( 1300, 1900 ] 464 0.031% 100.096% ( 1900, 2900 ] 467 0.031% 100.127% ( 2900, 4400 ] 503 0.033% 100.160% ( 4400, 6600 ] 106 0.007% 100.167% ( 6600, 9900 ] 38 0.003% 100.170% ( 9900, 14000 ] 12 0.001% 100.170% ( 14000, 22000 ] 9 0.001% 100.171% ( 22000, 33000 ] 4 0.000% 100.171% ( 33000, 50000 ] 2 0.000% 100.171% ** Level 4 read latency histogram (micros): Count: 72793 Average: 54.5138 StdDev: 464.33 Min: 1 Median: 1.8010 Max: 31864 Percentiles: P50: 1.80 P75: 2.82 P99: 1296.29 P99.9: 4333.20 P99.99: 11854.57 ------------------------------------------------------ [ 0, 1 ] 4016 5.517% 5.517% # ( 1, 2 ] 40423 55.531% 61.048% ########### ( 2, 3 ] 12320 16.925% 77.973% ### ( 3, 4 ] 6388 8.776% 86.749% ## ( 4, 6 ] 4401 6.046% 92.795% # ( 6, 10 ] 1222 1.679% 94.473% ( 10, 15 ] 376 0.517% 94.990% ( 15, 22 ] 51 0.070% 95.060% ( 22, 34 ] 15 0.021% 95.081% ( 34, 51 ] 7 0.010% 95.090% ( 51, 76 ] 29 0.040% 95.130% ( 76, 110 ] 173 0.238% 95.368% ( 110, 170 ] 295 0.405% 95.773% ( 170, 250 ] 330 0.453% 96.226% ( 250, 380 ] 331 0.455% 96.681% ( 380, 580 ] 585 0.804% 97.485% ( 580, 870 ] 651 0.894% 98.379% ( 870, 1300 ] 456 0.626% 99.005% ( 1300, 1900 ] 280 0.385% 99.390% ( 1900, 2900 ] 204 0.280% 99.670% ( 2900, 4400 ] 175 0.240% 99.911% ( 4400, 6600 ] 33 0.045% 99.956% ( 6600, 9900 ] 19 0.026% 99.982% ( 9900, 14000 ] 12 0.016% 99.999% ( 14000, 22000 ] 12 0.016% 100.015% ( 22000, 33000 ] 4 0.005% 100.021% ** Level 5 read latency histogram (micros): Count: 300 Average: 1235.1367 StdDev: 1551.09 Min: 75 Median: 632.0513 Max: 11317 Percentiles: P50: 632.05 P75: 1630.00 P99: 7700.00 P99.9: 11317.00 P99.99: 11317.00 ------------------------------------------------------ ( 51, 76 ] 1 0.333% 0.333% ( 76, 110 ] 24 8.000% 8.333% ## ( 110, 170 ] 37 12.333% 20.667% ## ( 170, 250 ] 17 5.667% 26.333% # ( 250, 380 ] 32 10.667% 37.000% ## ( 380, 580 ] 32 10.667% 47.667% ## ( 580, 870 ] 39 13.000% 60.667% ### ( 870, 1300 ] 32 10.667% 71.333% ## ( 1300, 1900 ] 20 6.667% 78.000% # ( 1900, 2900 ] 22 7.333% 85.333% # ( 2900, 4400 ] 32 10.667% 96.000% ## ( 4400, 6600 ] 8 2.667% 98.667% # ( 6600, 9900 ] 3 1.000% 99.667% ( 9900, 14000 ] 1 0.333% 100.000% ** DB Stats ** Uptime(secs): 53.8 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 182.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:26.682 H:M:S, 49.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.60 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.456 H:M:S, 14.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.666 micros/op 176488 ops/sec 60.032 seconds 10594999 operations; 171.0 MB/s Microseconds per write: Count: 10594999 Average: 5.6661 StdDev: 467.33 Min: 0 Median: 1.7328 Max: 719905 Percentiles: P50: 1.73 P75: 2.68 P99: 8.82 P99.9: 1113.20 P99.99: 2660.12 ------------------------------------------------------ [ 0, 1 ] 1453506 13.719% 13.719% ### ( 1, 2 ] 5245606 49.510% 63.229% ########## ( 2, 3 ] 1825180 17.227% 80.456% ### ( 3, 4 ] 1397065 13.186% 93.642% ### ( 4, 6 ] 490732 4.632% 98.274% # ( 6, 10 ] 109140 1.030% 99.304% ( 10, 15 ] 33760 0.319% 99.622% ( 15, 22 ] 8123 0.077% 99.699% ( 22, 34 ] 1969 0.019% 99.718% ( 34, 51 ] 222 0.002% 99.720% ( 51, 76 ] 29 0.000% 99.720% ( 76, 110 ] 7594 0.072% 99.792% ( 110, 170 ] 2664 0.025% 99.817% ( 170, 250 ] 319 0.003% 99.820% ( 250, 380 ] 146 0.001% 99.821% ( 380, 580 ] 25 0.000% 99.821% ( 580, 870 ] 24 0.000% 99.822% ( 870, 1300 ] 14675 0.139% 99.960% ( 1300, 1900 ] 25 0.000% 99.960% ( 1900, 2900 ] 4125 0.039% 99.999% ( 2900, 4400 ] 31 0.000% 100.000% ( 4400, 6600 ] 4 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 17 0.000% 100.000% ( 250000, 380000 ] 6 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 183034 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 : 10594999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10934038968 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 592 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31318553 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 : 32151380839 rocksdb.compact.write.bytes COUNT : 31965681832 rocksdb.flush.write.bytes COUNT : 10899219223 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 : 68 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 : 357 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 : 10811547648 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4380672 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 : 32256663646 rocksdb.non.last.level.read.count COUNT : 7789797 rocksdb.block.checksum.compute.count COUNT : 7788681 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.381924 P95 : 3.825356 P99 : 7.153885 P100 : 719903.000000 COUNT : 10594999 SUM : 55157107 rocksdb.compaction.times.micros P50 : 882666.666667 P95 : 4230000.000000 P99 : 13832000.000000 P100 : 21416597.000000 COUNT : 104 SUM : 149843736 rocksdb.compaction.times.cpu_micros P50 : 642500.000000 P95 : 3460000.000000 P99 : 9668000.000000 P100 : 19651350.000000 COUNT : 104 SUM : 123424018 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 : 694.242424 P95 : 4250.000000 P99 : 42860.000000 P100 : 76904.000000 COUNT : 142 SUM : 265216 rocksdb.compaction.outfile.sync.micros P50 : 1022.980769 P95 : 43483.333333 P99 : 69250.000000 P100 : 100732.000000 COUNT : 384 SUM : 2655257 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 : 99.800000 P95 : 1822.857143 P99 : 3510.000000 P100 : 6471.000000 COUNT : 278 SUM : 88752 rocksdb.table.open.io.micros P50 : 1570.329670 P95 : 7285.384615 P99 : 12004.666667 P100 : 18568.000000 COUNT : 592 SUM : 1278944 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.593279 P95 : 7.882080 P99 : 12.464209 P100 : 45120.000000 COUNT : 7786913 SUM : 53136193 rocksdb.read.block.get.micros P50 : 477.142857 P95 : 3387.500000 P99 : 5162.666667 P100 : 11408.000000 COUNT : 1184 SUM : 1045352 rocksdb.write.raw.block.micros P50 : 0.513557 P95 : 0.975759 P99 : 2.821504 P100 : 44920.000000 COUNT : 10381789 SUM : 22363619 rocksdb.numfiles.in.singlecompaction P50 : 3.016667 P95 : 5.933333 P99 : 25.360000 P100 : 28.000000 COUNT : 144 SUM : 513 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.563259 P95 : 1174.840123 P99 : 2498.690998 P100 : 719717.000000 COUNT : 168438 SUM : 31335022 rocksdb.sst.read.micros P50 : 1.565002 P95 : 4.730158 P99 : 8.981391 P100 : 45115.000000 COUNT : 7789898 SUM : 37444540 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 : 10594999 SUM : 10934038968 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 : 212790.697674 P95 : 504555.555556 P99 : 819400.000000 P100 : 872097.000000 COUNT : 142 SUM : 32469328 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 : 360 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