[2024-11-29 13:46:33.572871] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-11-29 13:46:33.573133] [ 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_pid1358743 ] Set seed to 1732884393566265 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-29 13:46:33.681083] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-29 13:46:33.717156] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-29 13:46:33.717202] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1358743' to capture a snapshot of events at runtime. [2024-11-29 13:46:33.717215] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1358743 for offline analysis/debug. [2024-11-29 13:46:33.717242] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Nov 29 13:46:37 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/29-13:46:40 ... thread 0: (1000000,1000000) ops and (333349.7,333349.7) ops/second in (2.999853,2.999853) 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.99 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 347.3 2.54 2.29 12 0.212 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.1 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 9/0 741.20 MB 0.7 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1181/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.8 1.4 93.2 310.7 4.05 3.75 14 0.290 383K 195 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.7 1.4 93.2 310.7 4.05 3.75 14 0.290 383K 195 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 249.5 249.3 1.51 1.46 2 0.757 383K 195 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 347.3 2.54 2.29 12 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 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, 389.35 MB/s write, 0.37 GB read, 116.81 MB/s read, 4.1 seconds Interval compaction: 1.23 GB write, 419.63 MB/s write, 0.37 GB read, 125.90 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 113629 Average: 1.8265 StdDev: 11.08 Min: 0 Median: 1.2202 Max: 2306 Percentiles: P50: 1.22 P75: 1.66 P99: 3.87 P99.9: 9.46 P99.99: 266.56 ------------------------------------------------------ [ 0, 1 ] 42474 37.380% 37.380% ####### ( 1, 2 ] 65116 57.306% 94.685% ########### ( 2, 3 ] 3695 3.252% 97.937% # ( 3, 4 ] 1394 1.227% 99.164% ( 4, 6 ] 652 0.574% 99.738% ( 6, 10 ] 214 0.188% 99.926% ( 10, 15 ] 42 0.037% 99.963% ( 15, 22 ] 17 0.015% 99.978% ( 22, 34 ] 1 0.001% 99.979% ( 34, 51 ] 1 0.001% 99.980% ( 110, 170 ] 6 0.005% 99.985% ( 170, 250 ] 6 0.005% 99.990% ( 250, 380 ] 5 0.004% 99.995% ( 380, 580 ] 1 0.001% 99.996% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 3 0.003% 99.999% ( 1900, 2900 ] 2 0.002% 100.001% ** Level 2 read latency histogram (micros): Count: 62430 Average: 2.0255 StdDev: 19.18 Min: 1 Median: 1.2745 Max: 2411 Percentiles: P50: 1.27 P75: 1.69 P99: 4.65 P99.9: 9.75 P99.99: 852.38 ------------------------------------------------------ [ 0, 1 ] 20904 33.484% 33.484% ####### ( 1, 2 ] 37566 60.173% 93.657% ############ ( 2, 3 ] 2096 3.357% 97.014% # ( 3, 4 ] 1067 1.709% 98.723% ( 4, 6 ] 535 0.857% 99.580% ( 6, 10 ] 214 0.343% 99.923% ( 10, 15 ] 26 0.042% 99.965% ( 15, 22 ] 4 0.006% 99.971% ( 22, 34 ] 1 0.002% 99.973% ( 34, 51 ] 1 0.002% 99.974% ( 51, 76 ] 2 0.003% 99.978% ( 110, 170 ] 2 0.003% 99.981% ( 250, 380 ] 1 0.002% 99.982% ( 380, 580 ] 2 0.003% 99.986% ( 580, 870 ] 4 0.006% 99.992% ( 870, 1300 ] 1 0.002% 99.994% ( 1300, 1900 ] 3 0.005% 99.998% ( 1900, 2900 ] 2 0.003% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1748.6000 StdDev: 1582.53 Min: 213 Median: 977.5000 Max: 6291 Percentiles: P50: 977.50 P75: 2775.00 P99: 6291.00 P99.9: 6291.00 P99.99: 6291.00 ------------------------------------------------------ ( 170, 250 ] 1 1.818% 1.818% ( 250, 380 ] 4 7.273% 9.091% # ( 380, 580 ] 8 14.545% 23.636% ### ( 580, 870 ] 12 21.818% 45.455% #### ( 870, 1300 ] 10 18.182% 63.636% #### ( 1300, 1900 ] 1 1.818% 65.455% ( 1900, 2900 ] 6 10.909% 76.364% ## ( 2900, 4400 ] 9 16.364% 92.727% ### ( 4400, 6600 ] 4 7.273% 100.000% # ** Level 4 read latency histogram (micros): Count: 15 Average: 1988.9333 StdDev: 1330.65 Min: 520 Median: 1750.0000 Max: 5400 Percentiles: P50: 1750.00 P75: 2712.50 P99: 5400.00 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 1 6.667% 13.333% # ( 870, 1300 ] 4 26.667% 40.000% ##### ( 1300, 1900 ] 2 13.333% 53.333% ### ( 1900, 2900 ] 4 26.667% 80.000% ##### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 572.3000 StdDev: 757.56 Min: 77 Median: 150.0000 Max: 2514 Percentiles: P50: 150.00 P75: 580.00 P99: 2514.00 P99.9: 2514.00 P99.99: 2514.00 ------------------------------------------------------ ( 76, 110 ] 6 30.000% 30.000% ###### ( 110, 170 ] 6 30.000% 60.000% ###### ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 304.18 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.421 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, 327.77 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.421 H:M:S, 14.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-13:46:43 ... thread 0: (1000000,2000000) ops and (353983.2,343356.7) ops/second in (2.824993,5.824846) 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.17 GB 62.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 76.4 322.5 7.42 6.82 28 0.265 575K 594 0.0 0.0 L1 1/0 2.79 MB 0.3 0.4 0.4 0.0 0.4 0.4 0.2 1.0 245.2 244.8 1.54 1.50 1 1.542 383K 608 0.0 0.0 L2 2/0 54.65 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 42/0 998.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 204.0 203.8 3.91 3.43 3 1.302 809K 810 0.0 0.0 L4 144/0 9.53 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 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 1248/8 97.92 GB 0.0 2.1 1.1 1.0 3.9 2.9 2.1 2.2 147.4 274.3 14.38 13.20 34 0.423 2152K 2207 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.1 1.0 3.9 2.9 2.0 2.2 147.4 274.3 14.38 13.20 34 0.423 2152K 2207 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.1 1.1 1.0 2.1 1.1 0.0 0.0 230.4 230.2 9.20 8.57 8 1.150 2152K 2207 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 352.5 5.18 4.62 26 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): 6.1 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.85 GB write, 650.85 MB/s write, 2.07 GB read, 349.77 MB/s read, 14.4 seconds Interval compaction: 3.85 GB write, 676.93 MB/s write, 2.07 GB read, 363.79 MB/s read, 14.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 386102 Average: 2.1080 StdDev: 10.87 Min: 0 Median: 1.4223 Max: 3404 Percentiles: P50: 1.42 P75: 1.82 P99: 5.66 P99.9: 10.40 P99.99: 18.08 ------------------------------------------------------ [ 0, 1 ] 91488 23.695% 23.695% ##### ( 1, 2 ] 240472 62.282% 85.977% ############ ( 2, 3 ] 29098 7.536% 93.514% ## ( 3, 4 ] 13703 3.549% 97.063% # ( 4, 6 ] 8998 2.330% 99.393% ( 6, 10 ] 1928 0.499% 99.893% ( 10, 15 ] 357 0.092% 99.985% ( 15, 22 ] 44 0.011% 99.996% ( 22, 34 ] 11 0.003% 99.999% ( 34, 51 ] 3 0.001% 100.000% ( 51, 76 ] 2 0.001% 100.001% ( 110, 170 ] 8 0.002% 100.003% ( 170, 250 ] 18 0.005% 100.007% ( 250, 380 ] 11 0.003% 100.010% ( 380, 580 ] 3 0.001% 100.011% ( 580, 870 ] 3 0.001% 100.012% ( 870, 1300 ] 7 0.002% 100.013% ( 1300, 1900 ] 2 0.001% 100.014% ( 1900, 2900 ] 2 0.001% 100.015% ( 2900, 4400 ] 2 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 81671 Average: 2.4346 StdDev: 6.13 Min: 1 Median: 1.6280 Max: 1115 Percentiles: P50: 1.63 P75: 2.07 P99: 6.00 P99.9: 12.25 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 7711 9.442% 9.442% ## ( 1, 2 ] 52745 64.582% 74.024% ############# ( 2, 3 ] 11937 14.616% 88.640% ### ( 3, 4 ] 4627 5.665% 94.305% # ( 4, 6 ] 3839 4.701% 99.006% # ( 6, 10 ] 670 0.820% 99.826% ( 10, 15 ] 134 0.164% 99.990% ( 15, 22 ] 10 0.012% 100.002% ( 22, 34 ] 3 0.004% 100.006% ( 34, 51 ] 2 0.002% 100.009% ( 110, 170 ] 1 0.001% 100.010% ( 170, 250 ] 1 0.001% 100.011% ( 250, 380 ] 2 0.002% 100.013% ( 380, 580 ] 2 0.002% 100.016% ( 870, 1300 ] 2 0.002% 100.018% ** Level 2 read latency histogram (micros): Count: 95459 Average: 2.0842 StdDev: 15.52 Min: 1 Median: 1.3676 Max: 2411 Percentiles: P50: 1.37 P75: 1.77 P99: 5.42 P99.9: 9.89 P99.99: 612.92 ------------------------------------------------------ [ 0, 1 ] 25812 27.040% 27.040% ##### ( 1, 2 ] 59627 62.463% 89.503% ############ ( 2, 3 ] 5158 5.403% 94.907% # ( 3, 4 ] 2755 2.886% 97.793% # ( 4, 6 ] 1622 1.699% 99.492% ( 6, 10 ] 401 0.420% 99.912% ( 10, 15 ] 59 0.062% 99.974% ( 15, 22 ] 5 0.005% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 34, 51 ] 1 0.001% 99.982% ( 51, 76 ] 2 0.002% 99.984% ( 110, 170 ] 2 0.002% 99.986% ( 250, 380 ] 1 0.001% 99.987% ( 380, 580 ] 2 0.002% 99.990% ( 580, 870 ] 4 0.004% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57522 Average: 4.1426 StdDev: 73.10 Min: 0 Median: 1.6222 Max: 6291 Percentiles: P50: 1.62 P75: 2.05 P99: 7.00 P99.9: 241.65 P99.99: 3274.63 ------------------------------------------------------ [ 0, 1 ] 5793 10.071% 10.071% ## ( 1, 2 ] 36915 64.175% 74.246% ############# ( 2, 3 ] 8152 14.172% 88.418% ### ( 3, 4 ] 3259 5.666% 94.084% # ( 4, 6 ] 2710 4.711% 98.795% # ( 6, 10 ] 472 0.821% 99.616% ( 10, 15 ] 112 0.195% 99.811% ( 15, 22 ] 13 0.023% 99.833% ( 22, 34 ] 26 0.045% 99.878% ( 34, 51 ] 5 0.009% 99.887% ( 76, 110 ] 1 0.002% 99.889% ( 110, 170 ] 2 0.003% 99.892% ( 170, 250 ] 5 0.009% 99.901% ( 250, 380 ] 8 0.014% 99.915% ( 380, 580 ] 11 0.019% 99.934% ( 580, 870 ] 12 0.021% 99.955% ( 870, 1300 ] 11 0.019% 99.974% ( 1300, 1900 ] 1 0.002% 99.976% ( 1900, 2900 ] 6 0.010% 99.986% ( 2900, 4400 ] 9 0.016% 100.002% ( 4400, 6600 ] 4 0.007% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 1988.9333 StdDev: 1330.65 Min: 520 Median: 1750.0000 Max: 5400 Percentiles: P50: 1750.00 P75: 2712.50 P99: 5400.00 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 1 6.667% 13.333% # ( 870, 1300 ] 4 26.667% 40.000% ##### ( 1300, 1900 ] 2 13.333% 53.333% ### ( 1900, 2900 ] 4 26.667% 80.000% ##### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 594.0750 StdDev: 823.13 Min: 77 Median: 158.0000 Max: 3851 Percentiles: P50: 158.00 P75: 725.00 P99: 3800.00 P99.9: 3851.00 P99.99: 3851.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 1 2.500% 57.500% # ( 380, 580 ] 6 15.000% 72.500% ### ( 580, 870 ] 2 5.000% 77.500% # ( 870, 1300 ] 3 7.500% 85.000% ## ( 1300, 1900 ] 2 5.000% 90.000% # ( 1900, 2900 ] 3 7.500% 97.500% ## ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.79 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.623 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 348.39 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.201 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-13:46:46 ... thread 0: (1000000,3000000) ops and (336614.5,341079.5) ops/second in (2.970757,8.795603) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/13 2.15 GB 0.0 1.7 0.0 1.7 4.4 2.8 0.0 1.6 118.3 315.3 14.38 13.41 46 0.313 1727K 1861 0.0 0.0 L1 1/1 2.79 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 245.2 244.8 1.54 1.50 1 1.542 383K 608 0.0 0.0 L2 2/0 54.65 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 42/0 998.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 204.0 203.8 3.91 3.43 3 1.302 809K 810 0.0 0.0 L4 144/0 9.53 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 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/14 98.90 GB 0.0 3.2 1.1 2.1 5.9 3.9 2.1 2.1 152.5 285.1 21.34 19.79 52 0.410 3303K 3474 0.0 0.0 Int 0/0 0.00 KB 0.0 3.2 1.1 2.1 5.9 3.9 2.0 2.1 152.5 285.1 21.34 19.79 52 0.410 3303K 3474 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.2 1.1 2.1 3.2 1.1 0.0 0.0 242.5 242.2 13.42 12.71 12 1.118 3303K 3474 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 357.9 7.92 7.08 40 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.0 total, 8.8 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.94 GB write, 673.77 MB/s write, 3.18 GB read, 360.27 MB/s read, 21.3 seconds Interval compaction: 5.94 GB write, 691.66 MB/s write, 3.18 GB read, 369.84 MB/s read, 21.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 630022 Average: 2.0303 StdDev: 11.14 Min: 0 Median: 1.3768 Max: 3686 Percentiles: P50: 1.38 P75: 1.78 P99: 5.45 P99.9: 10.44 P99.99: 19.82 ------------------------------------------------------ [ 0, 1 ] 167948 26.657% 26.657% ##### ( 1, 2 ] 390258 61.944% 88.601% ############ ( 2, 3 ] 39710 6.303% 94.904% # ( 3, 4 ] 17843 2.832% 97.736% # ( 4, 6 ] 10984 1.743% 99.480% ( 6, 10 ] 2601 0.413% 99.892% ( 10, 15 ] 564 0.090% 99.982% ( 15, 22 ] 77 0.012% 99.994% ( 22, 34 ] 14 0.002% 99.996% ( 34, 51 ] 3 0.000% 99.997% ( 51, 76 ] 6 0.001% 99.998% ( 110, 170 ] 14 0.002% 100.000% ( 170, 250 ] 26 0.004% 100.004% ( 250, 380 ] 17 0.003% 100.007% ( 380, 580 ] 6 0.001% 100.008% ( 580, 870 ] 9 0.001% 100.009% ( 870, 1300 ] 12 0.002% 100.011% ( 1300, 1900 ] 2 0.000% 100.011% ( 1900, 2900 ] 2 0.000% 100.012% ( 2900, 4400 ] 4 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 81672 Average: 2.4347 StdDev: 6.13 Min: 1 Median: 1.6280 Max: 1115 Percentiles: P50: 1.63 P75: 2.07 P99: 6.00 P99.9: 12.25 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 7711 9.441% 9.441% ## ( 1, 2 ] 52745 64.581% 74.023% ############# ( 2, 3 ] 11937 14.616% 88.639% ### ( 3, 4 ] 4628 5.667% 94.305% # ( 4, 6 ] 3839 4.701% 99.006% # ( 6, 10 ] 670 0.820% 99.826% ( 10, 15 ] 134 0.164% 99.990% ( 15, 22 ] 10 0.012% 100.002% ( 22, 34 ] 3 0.004% 100.006% ( 34, 51 ] 2 0.002% 100.009% ( 110, 170 ] 1 0.001% 100.010% ( 170, 250 ] 1 0.001% 100.011% ( 250, 380 ] 2 0.002% 100.013% ( 380, 580 ] 2 0.002% 100.016% ( 870, 1300 ] 2 0.002% 100.018% ** Level 2 read latency histogram (micros): Count: 95459 Average: 2.0842 StdDev: 15.52 Min: 1 Median: 1.3676 Max: 2411 Percentiles: P50: 1.37 P75: 1.77 P99: 5.42 P99.9: 9.89 P99.99: 612.92 ------------------------------------------------------ [ 0, 1 ] 25812 27.040% 27.040% ##### ( 1, 2 ] 59627 62.463% 89.503% ############ ( 2, 3 ] 5158 5.403% 94.907% # ( 3, 4 ] 2755 2.886% 97.793% # ( 4, 6 ] 1622 1.699% 99.492% ( 6, 10 ] 401 0.420% 99.912% ( 10, 15 ] 59 0.062% 99.974% ( 15, 22 ] 5 0.005% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 34, 51 ] 1 0.001% 99.982% ( 51, 76 ] 2 0.002% 99.984% ( 110, 170 ] 2 0.002% 99.986% ( 250, 380 ] 1 0.001% 99.987% ( 380, 580 ] 2 0.002% 99.990% ( 580, 870 ] 4 0.004% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57522 Average: 4.1426 StdDev: 73.10 Min: 0 Median: 1.6222 Max: 6291 Percentiles: P50: 1.62 P75: 2.05 P99: 7.00 P99.9: 241.65 P99.99: 3274.63 ------------------------------------------------------ [ 0, 1 ] 5793 10.071% 10.071% ## ( 1, 2 ] 36915 64.175% 74.246% ############# ( 2, 3 ] 8152 14.172% 88.418% ### ( 3, 4 ] 3259 5.666% 94.084% # ( 4, 6 ] 2710 4.711% 98.795% # ( 6, 10 ] 472 0.821% 99.616% ( 10, 15 ] 112 0.195% 99.811% ( 15, 22 ] 13 0.023% 99.833% ( 22, 34 ] 26 0.045% 99.878% ( 34, 51 ] 5 0.009% 99.887% ( 76, 110 ] 1 0.002% 99.889% ( 110, 170 ] 2 0.003% 99.892% ( 170, 250 ] 5 0.009% 99.901% ( 250, 380 ] 8 0.014% 99.915% ( 380, 580 ] 11 0.019% 99.934% ( 580, 870 ] 12 0.021% 99.955% ( 870, 1300 ] 11 0.019% 99.974% ( 1300, 1900 ] 1 0.002% 99.976% ( 1900, 2900 ] 6 0.010% 99.986% ( 2900, 4400 ] 9 0.016% 100.002% ( 4400, 6600 ] 4 0.007% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 1988.9333 StdDev: 1330.65 Min: 520 Median: 1750.0000 Max: 5400 Percentiles: P50: 1750.00 P75: 2712.50 P99: 5400.00 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 1 6.667% 13.333% # ( 870, 1300 ] 4 26.667% 40.000% ##### ( 1300, 1900 ] 2 13.333% 53.333% ### ( 1900, 2900 ] 4 26.667% 80.000% ##### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 594.0750 StdDev: 823.13 Min: 77 Median: 158.0000 Max: 3851 Percentiles: P50: 158.00 P75: 725.00 P99: 3800.00 P99.9: 3851.00 P99.99: 3851.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 1 2.500% 57.500% # ( 380, 580 ] 6 15.000% 72.500% ### ( 580, 870 ] 2 5.000% 77.500% # ( 870, 1300 ] 3 7.500% 85.000% ## ( 1300, 1900 ] 2 5.000% 90.000% # ( 1900, 2900 ] 3 7.500% 97.500% ## ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 9.0 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 326.93 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.014 H:M:S, 11.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.29 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.392 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-13:46:49 ... thread 0: (1000000,4000000) ops and (321136.8,335865.2) ops/second in (3.113938,11.909541) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 3.13 GB 100.7 2.5 0.0 2.5 6.2 3.7 0.0 1.7 124.0 313.0 20.32 18.97 63 0.322 2558K 2752 0.0 0.0 L1 1/1 2.79 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 245.2 244.8 1.54 1.50 1 1.542 383K 608 0.0 0.0 L2 2/0 54.65 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 42/0 998.60 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 204.0 203.8 3.91 3.43 3 1.302 809K 810 0.0 0.0 L4 144/0 9.53 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 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 1255/14 99.88 GB 0.0 4.0 1.1 2.9 7.7 4.9 2.1 2.1 149.3 290.0 27.28 25.35 69 0.395 4135K 4365 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.1 2.9 7.7 4.9 2.0 2.1 149.3 290.0 27.28 25.35 69 0.395 4135K 4365 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.0 1.1 2.9 4.0 1.1 0.0 0.0 247.1 246.8 16.48 15.71 15 1.099 4135K 4365 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 356.0 10.80 9.64 54 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.73 GB write, 651.37 MB/s write, 3.98 GB read, 335.33 MB/s read, 27.3 seconds Interval compaction: 7.73 GB write, 664.13 MB/s write, 3.98 GB read, 341.91 MB/s read, 27.3 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: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 1, total-stops: 15, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1062262 Average: 2.0969 StdDev: 12.51 Min: 0 Median: 1.4242 Max: 6394 Percentiles: P50: 1.42 P75: 1.81 P99: 5.47 P99.9: 9.94 P99.99: 14.86 ------------------------------------------------------ [ 0, 1 ] 240027 22.596% 22.596% ##### ( 1, 2 ] 686179 64.596% 87.192% ############# ( 2, 3 ] 77647 7.310% 94.501% # ( 3, 4 ] 33437 3.148% 97.649% # ( 4, 6 ] 19570 1.842% 99.491% ( 6, 10 ] 4408 0.415% 99.906% ( 10, 15 ] 917 0.086% 99.993% ( 15, 22 ] 103 0.010% 100.002% ( 22, 34 ] 18 0.002% 100.004% ( 34, 51 ] 5 0.000% 100.005% ( 51, 76 ] 8 0.001% 100.005% ( 76, 110 ] 24 0.002% 100.008% ( 110, 170 ] 39 0.004% 100.011% ( 170, 250 ] 45 0.004% 100.016% ( 250, 380 ] 32 0.003% 100.019% ( 380, 580 ] 15 0.001% 100.020% ( 580, 870 ] 16 0.002% 100.021% ( 870, 1300 ] 16 0.002% 100.023% ( 1300, 1900 ] 2 0.000% 100.023% ( 1900, 2900 ] 5 0.000% 100.024% ( 2900, 4400 ] 5 0.000% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 81672 Average: 2.4347 StdDev: 6.13 Min: 1 Median: 1.6280 Max: 1115 Percentiles: P50: 1.63 P75: 2.07 P99: 6.00 P99.9: 12.25 P99.99: 14.99 ------------------------------------------------------ [ 0, 1 ] 7711 9.441% 9.441% ## ( 1, 2 ] 52745 64.581% 74.023% ############# ( 2, 3 ] 11937 14.616% 88.639% ### ( 3, 4 ] 4628 5.667% 94.305% # ( 4, 6 ] 3839 4.701% 99.006% # ( 6, 10 ] 670 0.820% 99.826% ( 10, 15 ] 134 0.164% 99.990% ( 15, 22 ] 10 0.012% 100.002% ( 22, 34 ] 3 0.004% 100.006% ( 34, 51 ] 2 0.002% 100.009% ( 110, 170 ] 1 0.001% 100.010% ( 170, 250 ] 1 0.001% 100.011% ( 250, 380 ] 2 0.002% 100.013% ( 380, 580 ] 2 0.002% 100.016% ( 870, 1300 ] 2 0.002% 100.018% ** Level 2 read latency histogram (micros): Count: 95459 Average: 2.0842 StdDev: 15.52 Min: 1 Median: 1.3676 Max: 2411 Percentiles: P50: 1.37 P75: 1.77 P99: 5.42 P99.9: 9.89 P99.99: 612.92 ------------------------------------------------------ [ 0, 1 ] 25812 27.040% 27.040% ##### ( 1, 2 ] 59627 62.463% 89.503% ############ ( 2, 3 ] 5158 5.403% 94.907% # ( 3, 4 ] 2755 2.886% 97.793% # ( 4, 6 ] 1622 1.699% 99.492% ( 6, 10 ] 401 0.420% 99.912% ( 10, 15 ] 59 0.062% 99.974% ( 15, 22 ] 5 0.005% 99.979% ( 22, 34 ] 2 0.002% 99.981% ( 34, 51 ] 1 0.001% 99.982% ( 51, 76 ] 2 0.002% 99.984% ( 110, 170 ] 2 0.002% 99.986% ( 250, 380 ] 1 0.001% 99.987% ( 380, 580 ] 2 0.002% 99.990% ( 580, 870 ] 4 0.004% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 57522 Average: 4.1426 StdDev: 73.10 Min: 0 Median: 1.6222 Max: 6291 Percentiles: P50: 1.62 P75: 2.05 P99: 7.00 P99.9: 241.65 P99.99: 3274.63 ------------------------------------------------------ [ 0, 1 ] 5793 10.071% 10.071% ## ( 1, 2 ] 36915 64.175% 74.246% ############# ( 2, 3 ] 8152 14.172% 88.418% ### ( 3, 4 ] 3259 5.666% 94.084% # ( 4, 6 ] 2710 4.711% 98.795% # ( 6, 10 ] 472 0.821% 99.616% ( 10, 15 ] 112 0.195% 99.811% ( 15, 22 ] 13 0.023% 99.833% ( 22, 34 ] 26 0.045% 99.878% ( 34, 51 ] 5 0.009% 99.887% ( 76, 110 ] 1 0.002% 99.889% ( 110, 170 ] 2 0.003% 99.892% ( 170, 250 ] 5 0.009% 99.901% ( 250, 380 ] 8 0.014% 99.915% ( 380, 580 ] 11 0.019% 99.934% ( 580, 870 ] 12 0.021% 99.955% ( 870, 1300 ] 11 0.019% 99.974% ( 1300, 1900 ] 1 0.002% 99.976% ( 1900, 2900 ] 6 0.010% 99.986% ( 2900, 4400 ] 9 0.016% 100.002% ( 4400, 6600 ] 4 0.007% 100.009% ** Level 4 read latency histogram (micros): Count: 15 Average: 1988.9333 StdDev: 1330.65 Min: 520 Median: 1750.0000 Max: 5400 Percentiles: P50: 1750.00 P75: 2712.50 P99: 5400.00 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 1 6.667% 13.333% # ( 870, 1300 ] 4 26.667% 40.000% ##### ( 1300, 1900 ] 2 13.333% 53.333% ### ( 1900, 2900 ] 4 26.667% 80.000% ##### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 594.0750 StdDev: 823.13 Min: 77 Median: 158.0000 Max: 3851 Percentiles: P50: 158.00 P75: 725.00 P99: 3800.00 P99.9: 3851.00 P99.99: 3851.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 1 2.500% 57.500% # ( 380, 580 ] 6 15.000% 72.500% ### ( 580, 870 ] 2 5.000% 77.500% # ( 870, 1300 ] 3 7.500% 85.000% ## ( 1300, 1900 ] 2 5.000% 90.000% # ( 1900, 2900 ] 3 7.500% 97.500% ## ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 324.14 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.465 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 316.06 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.450 H:M:S, 14.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-13:46:54 ... thread 0: (1000000,5000000) ops and (197766.3,294706.8) ops/second in (5.056472,16.966013) 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/7 2.15 GB 69.2 3.5 0.0 3.5 8.2 4.7 0.0 1.7 133.2 310.6 26.96 25.22 81 0.333 3646K 3888 0.0 0.0 L1 4/0 390.92 MB 39.1 2.3 2.3 0.0 2.3 2.3 0.2 1.0 232.0 230.2 10.05 9.69 2 5.024 2367K 17K 0.0 0.0 L2 7/5 698.54 MB 2.6 0.4 0.2 0.2 0.4 0.2 1.9 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 49/33 1.86 GB 1.0 0.8 0.6 0.2 0.8 0.6 1.0 1.4 204.0 203.8 3.91 3.43 3 1.302 809K 810 0.0 0.0 L4 144/0 9.53 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.19 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 1263/45 100.79 GB 0.0 6.9 3.0 3.9 11.6 7.7 4.5 2.5 167.3 279.5 42.43 39.80 88 0.482 7206K 22K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.9 3.0 3.9 11.6 7.7 4.4 2.5 167.3 279.5 42.43 39.80 88 0.482 7206K 22K 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.9 3.0 3.9 6.9 3.0 0.0 0.0 245.2 244.4 28.94 27.78 20 1.447 7206K 22K 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 354.9 13.49 12.02 68 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): 17.2 total, 17.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.58 GB write, 689.59 MB/s write, 6.93 GB read, 412.60 MB/s read, 42.4 seconds Interval compaction: 11.58 GB write, 699.07 MB/s write, 6.93 GB read, 418.28 MB/s read, 42.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 7, total-stops: 16, interval: 23 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1606831 Average: 2.1408 StdDev: 12.34 Min: 0 Median: 1.4250 Max: 6394 Percentiles: P50: 1.42 P75: 1.81 P99: 5.59 P99.9: 11.10 P99.99: 109.31 ------------------------------------------------------ [ 0, 1 ] 357540 22.251% 22.251% #### ( 1, 2 ] 1049186 65.295% 87.547% ############# ( 2, 3 ] 113864 7.086% 94.633% # ( 3, 4 ] 48701 3.031% 97.664% # ( 4, 6 ] 27048 1.683% 99.347% ( 6, 10 ] 8584 0.534% 99.881% ( 10, 15 ] 1373 0.085% 99.967% ( 15, 22 ] 152 0.009% 99.976% ( 22, 34 ] 26 0.002% 99.978% ( 34, 51 ] 11 0.001% 99.978% ( 51, 76 ] 10 0.001% 99.979% ( 76, 110 ] 181 0.011% 99.990% ( 110, 170 ] 202 0.013% 100.003% ( 170, 250 ] 124 0.008% 100.011% ( 250, 380 ] 66 0.004% 100.015% ( 380, 580 ] 56 0.003% 100.018% ( 580, 870 ] 41 0.003% 100.021% ( 870, 1300 ] 20 0.001% 100.022% ( 1300, 1900 ] 4 0.000% 100.022% ( 1900, 2900 ] 8 0.000% 100.023% ( 2900, 4400 ] 7 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 106690 Average: 3.2406 StdDev: 28.21 Min: 0 Median: 1.6748 Max: 3329 Percentiles: P50: 1.67 P75: 2.30 P99: 7.21 P99.9: 114.47 P99.99: 481.84 ------------------------------------------------------ [ 0, 1 ] 8564 8.027% 8.027% ## ( 1, 2 ] 66364 62.203% 70.230% ############ ( 2, 3 ] 17185 16.107% 86.337% ### ( 3, 4 ] 6977 6.540% 92.877% # ( 4, 6 ] 6218 5.828% 98.705% # ( 6, 10 ] 1042 0.977% 99.681% ( 10, 15 ] 199 0.187% 99.868% ( 15, 22 ] 15 0.014% 99.882% ( 22, 34 ] 4 0.004% 99.886% ( 34, 51 ] 2 0.002% 99.888% ( 76, 110 ] 12 0.011% 99.899% ( 110, 170 ] 31 0.029% 99.928% ( 170, 250 ] 33 0.031% 99.959% ( 250, 380 ] 16 0.015% 99.974% ( 380, 580 ] 36 0.034% 100.007% ( 580, 870 ] 14 0.013% 100.021% ( 870, 1300 ] 12 0.011% 100.032% ( 1300, 1900 ] 7 0.007% 100.038% ( 1900, 2900 ] 5 0.005% 100.043% ( 2900, 4400 ] 1 0.001% 100.044% ** Level 2 read latency histogram (micros): Count: 95476 Average: 2.2668 StdDev: 23.24 Min: 1 Median: 1.3677 Max: 2713 Percentiles: P50: 1.37 P75: 1.77 P99: 5.44 P99.9: 10.47 P99.99: 1354.29 ------------------------------------------------------ [ 0, 1 ] 25812 27.035% 27.035% ##### ( 1, 2 ] 59627 62.452% 89.487% ############ ( 2, 3 ] 5158 5.402% 94.890% # ( 3, 4 ] 2755 2.886% 97.775% # ( 4, 6 ] 1622 1.699% 99.474% ( 6, 10 ] 401 0.420% 99.894% ( 10, 15 ] 59 0.062% 99.956% ( 15, 22 ] 5 0.005% 99.961% ( 22, 34 ] 2 0.002% 99.963% ( 34, 51 ] 1 0.001% 99.964% ( 51, 76 ] 2 0.002% 99.966% ( 110, 170 ] 4 0.004% 99.971% ( 250, 380 ] 1 0.001% 99.972% ( 380, 580 ] 8 0.008% 99.980% ( 580, 870 ] 6 0.006% 99.986% ( 870, 1300 ] 3 0.003% 99.990% ( 1300, 1900 ] 5 0.005% 99.995% ( 1900, 2900 ] 5 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 74666 Average: 6.5907 StdDev: 85.90 Min: 0 Median: 1.6772 Max: 6291 Percentiles: P50: 1.68 P75: 2.35 P99: 10.57 P99.9: 771.67 P99.99: 2357.97 ------------------------------------------------------ [ 0, 1 ] 6656 8.914% 8.914% ## ( 1, 2 ] 45302 60.673% 69.587% ############ ( 2, 3 ] 11440 15.322% 84.909% ### ( 3, 4 ] 5228 7.002% 91.911% # ( 4, 6 ] 4255 5.699% 97.609% # ( 6, 10 ] 1013 1.357% 98.966% ( 10, 15 ] 231 0.309% 99.275% ( 15, 22 ] 38 0.051% 99.326% ( 22, 34 ] 30 0.040% 99.367% ( 34, 51 ] 5 0.007% 99.373% ( 76, 110 ] 20 0.027% 99.400% ( 110, 170 ] 99 0.133% 99.533% ( 170, 250 ] 83 0.111% 99.644% ( 250, 380 ] 62 0.083% 99.727% ( 380, 580 ] 92 0.123% 99.850% ( 580, 870 ] 58 0.078% 99.928% ( 870, 1300 ] 27 0.036% 99.964% ( 1300, 1900 ] 10 0.013% 99.977% ( 1900, 2900 ] 23 0.031% 100.008% ( 2900, 4400 ] 13 0.017% 100.025% ( 4400, 6600 ] 4 0.005% 100.031% ** Level 4 read latency histogram (micros): Count: 15 Average: 1988.9333 StdDev: 1330.65 Min: 520 Median: 1750.0000 Max: 5400 Percentiles: P50: 1750.00 P75: 2712.50 P99: 5400.00 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ ( 380, 580 ] 1 6.667% 6.667% # ( 580, 870 ] 1 6.667% 13.333% # ( 870, 1300 ] 4 26.667% 40.000% ##### ( 1300, 1900 ] 2 13.333% 53.333% ### ( 1900, 2900 ] 4 26.667% 80.000% ##### ( 2900, 4400 ] 2 13.333% 93.333% ### ( 4400, 6600 ] 1 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 594.0750 StdDev: 823.13 Min: 77 Median: 158.0000 Max: 3851 Percentiles: P50: 158.00 P75: 725.00 P99: 3800.00 P99.9: 3851.00 P99.99: 3851.00 ------------------------------------------------------ ( 76, 110 ] 12 30.000% 30.000% ###### ( 110, 170 ] 10 25.000% 55.000% ##### ( 170, 250 ] 1 2.500% 57.500% # ( 380, 580 ] 6 15.000% 72.500% ### ( 580, 870 ] 2 5.000% 77.500% # ( 870, 1300 ] 3 7.500% 85.000% ## ( 1300, 1900 ] 2 5.000% 90.000% # ( 1900, 2900 ] 3 7.500% 97.500% ## ( 2900, 4400 ] 1 2.500% 100.000% # ** DB Stats ** Uptime(secs): 17.2 total, 5.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 286.07 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.793 H:M:S, 22.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 194.64 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.328 H:M:S, 46.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/29-13:46:58 ... thread 0: (1000000,6000000) ops and (260403.4,288375.5) ops/second in (3.840196,20.806209) 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/11 3.13 GB 144.7 4.1 0.0 4.1 9.8 5.7 0.0 1.7 127.7 303.0 33.04 30.35 96 0.344 4285K 4612 0.0 0.0 L1 4/0 390.92 MB 39.1 2.3 2.3 0.0 2.3 2.3 0.2 1.0 232.0 230.2 10.05 9.69 2 5.024 2367K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.9 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 16/0 993.80 MB 1.0 2.3 1.1 1.1 2.3 1.1 1.1 2.0 191.5 191.1 12.08 9.89 9 1.342 2322K 4266 0.0 0.0 L4 165/0 9.74 GB 1.0 0.6 0.5 0.1 0.6 0.5 1.7 1.2 163.2 162.7 3.68 2.74 5 0.736 609K 2057 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 1267/11 101.77 GB 0.0 9.6 4.0 5.6 15.2 9.7 7.0 2.7 163.1 258.6 60.36 54.14 114 0.529 9969K 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.6 4.0 5.6 15.2 9.7 6.9 2.7 163.1 258.6 60.36 54.14 114 0.529 9969K 28K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.6 4.0 5.6 9.6 4.0 0.0 0.0 227.5 226.8 43.26 39.40 33 1.311 9969K 28K 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 339.0 17.10 14.73 81 0.211 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 21.0 total, 20.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: 15.24 GB write, 741.82 MB/s write, 9.61 GB read, 467.81 MB/s read, 60.4 seconds Interval compaction: 15.24 GB write, 750.14 MB/s write, 9.61 GB read, 473.06 MB/s read, 60.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 7, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 7, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 35, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 7, total-stops: 35, interval: 42 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2057321 Average: 2.3143 StdDev: 15.55 Min: 0 Median: 1.4777 Max: 6394 Percentiles: P50: 1.48 P75: 1.87 P99: 5.88 P99.9: 12.24 P99.99: 129.05 ------------------------------------------------------ [ 0, 1 ] 396292 19.263% 19.263% #### ( 1, 2 ] 1323653 64.339% 83.601% ############# ( 2, 3 ] 180340 8.766% 92.367% ## ( 3, 4 ] 83013 4.035% 96.402% # ( 4, 6 ] 56718 2.757% 99.159% # ( 6, 10 ] 14209 0.691% 99.850% ( 10, 15 ] 2321 0.113% 99.962% ( 15, 22 ] 230 0.011% 99.974% ( 22, 34 ] 28 0.001% 99.975% ( 34, 51 ] 14 0.001% 99.976% ( 51, 76 ] 13 0.001% 99.976% ( 76, 110 ] 191 0.009% 99.985% ( 110, 170 ] 300 0.015% 100.000% ( 170, 250 ] 180 0.009% 100.009% ( 250, 380 ] 127 0.006% 100.015% ( 380, 580 ] 116 0.006% 100.021% ( 580, 870 ] 79 0.004% 100.024% ( 870, 1300 ] 34 0.002% 100.026% ( 1300, 1900 ] 13 0.001% 100.027% ( 1900, 2900 ] 17 0.001% 100.028% ( 2900, 4400 ] 17 0.001% 100.028% ( 4400, 6600 ] 1 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 291654 Average: 3.3199 StdDev: 26.83 Min: 0 Median: 1.8031 Max: 4476 Percentiles: P50: 1.80 P75: 2.71 P99: 8.46 P99.9: 14.68 P99.99: 189.75 ------------------------------------------------------ [ 0, 1 ] 13926 4.775% 4.775% # ( 1, 2 ] 164245 56.315% 61.090% ########### ( 2, 3 ] 56836 19.487% 80.577% #### ( 3, 4 ] 25218 8.647% 89.224% ## ( 4, 6 ] 25594 8.775% 97.999% ## ( 6, 10 ] 4749 1.628% 99.628% ( 10, 15 ] 849 0.291% 99.919% ( 15, 22 ] 102 0.035% 99.954% ( 22, 34 ] 9 0.003% 99.957% ( 34, 51 ] 2 0.001% 99.957% ( 51, 76 ] 1 0.000% 99.958% ( 76, 110 ] 26 0.009% 99.967% ( 110, 170 ] 55 0.019% 99.986% ( 170, 250 ] 52 0.018% 100.003% ( 250, 380 ] 38 0.013% 100.016% ( 380, 580 ] 65 0.022% 100.039% ( 580, 870 ] 31 0.011% 100.049% ( 870, 1300 ] 26 0.009% 100.058% ( 1300, 1900 ] 17 0.006% 100.064% ( 1900, 2900 ] 6 0.002% 100.066% ( 2900, 4400 ] 4 0.001% 100.068% ( 4400, 6600 ] 1 0.000% 100.068% ** Level 2 read latency histogram (micros): Count: 124173 Average: 2.8611 StdDev: 30.90 Min: 1 Median: 1.4354 Max: 4589 Percentiles: P50: 1.44 P75: 1.83 P99: 6.49 P99.9: 208.26 P99.99: 1521.37 ------------------------------------------------------ [ 0, 1 ] 28251 22.751% 22.751% ##### ( 1, 2 ] 77712 62.584% 85.335% ############# ( 2, 3 ] 8932 7.193% 92.528% # ( 3, 4 ] 4816 3.878% 96.407% # ( 4, 6 ] 3098 2.495% 98.902% ( 6, 10 ] 992 0.799% 99.700% ( 10, 15 ] 145 0.117% 99.817% ( 15, 22 ] 12 0.010% 99.827% ( 22, 34 ] 2 0.002% 99.828% ( 34, 51 ] 1 0.001% 99.829% ( 51, 76 ] 9 0.007% 99.837% ( 76, 110 ] 24 0.019% 99.856% ( 110, 170 ] 40 0.032% 99.888% ( 170, 250 ] 31 0.025% 99.913% ( 250, 380 ] 24 0.019% 99.932% ( 380, 580 ] 36 0.029% 99.961% ( 580, 870 ] 23 0.019% 99.980% ( 870, 1300 ] 10 0.008% 99.988% ( 1300, 1900 ] 7 0.006% 99.994% ( 1900, 2900 ] 6 0.005% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 356156 Average: 7.4240 StdDev: 75.07 Min: 0 Median: 1.7704 Max: 6291 Percentiles: P50: 1.77 P75: 2.70 P99: 13.44 P99.9: 724.58 P99.99: 1064.73 ------------------------------------------------------ [ 0, 1 ] 22860 6.419% 6.419% # ( 1, 2 ] 201487 56.573% 62.991% ########### ( 2, 3 ] 61227 17.191% 80.182% ### ( 3, 4 ] 31744 8.913% 89.095% ## ( 4, 6 ] 27710 7.780% 96.876% ## ( 6, 10 ] 6744 1.894% 98.769% ( 10, 15 ] 1197 0.336% 99.105% ( 15, 22 ] 153 0.043% 99.148% ( 22, 34 ] 42 0.012% 99.160% ( 34, 51 ] 8 0.002% 99.162% ( 51, 76 ] 5 0.001% 99.164% ( 76, 110 ] 188 0.053% 99.216% ( 110, 170 ] 467 0.131% 99.347% ( 170, 250 ] 533 0.150% 99.497% ( 250, 380 ] 532 0.149% 99.647% ( 380, 580 ] 676 0.190% 99.836% ( 580, 870 ] 455 0.128% 99.964% ( 870, 1300 ] 204 0.057% 100.021% ( 1300, 1900 ] 73 0.020% 100.042% ( 1900, 2900 ] 84 0.024% 100.065% ( 2900, 4400 ] 39 0.011% 100.076% ( 4400, 6600 ] 7 0.002% 100.078% ** Level 4 read latency histogram (micros): Count: 125 Average: 314.7920 StdDev: 818.03 Min: 1 Median: 2.6111 Max: 5400 Percentiles: P50: 2.61 P75: 141.15 P99: 4212.50 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ [ 0, 1 ] 17 13.600% 13.600% ### ( 1, 2 ] 40 32.000% 45.600% ###### ( 2, 3 ] 9 7.200% 52.800% # ( 3, 4 ] 2 1.600% 54.400% ( 4, 6 ] 3 2.400% 56.800% ( 6, 10 ] 7 5.600% 62.400% # ( 10, 15 ] 2 1.600% 64.000% ( 22, 34 ] 5 4.000% 68.000% # ( 51, 76 ] 2 1.600% 69.600% ( 110, 170 ] 13 10.400% 80.000% ## ( 250, 380 ] 4 3.200% 83.200% # ( 380, 580 ] 2 1.600% 84.800% ( 580, 870 ] 3 2.400% 87.200% ( 870, 1300 ] 6 4.800% 92.000% # ( 1300, 1900 ] 2 1.600% 93.600% ( 1900, 2900 ] 5 4.000% 97.600% # ( 2900, 4400 ] 2 1.600% 99.200% ( 4400, 6600 ] 1 0.800% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 906.0500 StdDev: 1030.08 Min: 77 Median: 456.1905 Max: 4350 Percentiles: P50: 456.19 P75: 1300.00 P99: 4142.86 P99.9: 4350.00 P99.99: 4350.00 ------------------------------------------------------ ( 76, 110 ] 12 10.000% 10.000% ## ( 110, 170 ] 21 17.500% 27.500% #### ( 170, 250 ] 8 6.667% 34.167% # ( 250, 380 ] 11 9.167% 43.333% ## ( 380, 580 ] 21 17.500% 60.833% #### ( 580, 870 ] 10 8.333% 69.167% ## ( 870, 1300 ] 7 5.833% 75.000% # ( 1300, 1900 ] 9 7.500% 82.500% ## ( 1900, 2900 ] 14 11.667% 94.167% ## ( 2900, 4400 ] 7 5.833% 100.000% # ** DB Stats ** Uptime(secs): 21.0 total, 3.8 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 280.64 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.849 H:M:S, 23.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 256.29 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.056 H:M:S, 27.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-13:47:01 ... thread 0: (1000000,7000000) ops and (315287.9,291935.3) ops/second in (3.171704,23.977913) 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/16 4.05 GB 18.9 6.1 0.0 6.1 12.7 6.6 0.0 1.9 142.8 296.9 43.66 40.37 112 0.390 6331K 14K 0.0 0.0 L1 4/4 390.92 MB 0.0 2.3 2.3 0.0 2.3 2.3 0.2 1.0 232.0 230.2 10.05 9.69 2 5.024 2367K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.9 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 16/0 993.80 MB 1.0 2.3 1.1 1.1 2.3 1.1 1.1 2.0 191.5 191.1 12.08 9.89 9 1.342 2322K 4266 0.0 0.0 L4 165/0 9.74 GB 1.0 0.6 0.5 0.1 0.6 0.5 1.7 1.2 163.2 162.7 3.68 2.74 5 0.736 609K 2057 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 1268/20 102.68 GB 0.0 11.6 4.0 7.5 18.1 10.6 7.0 2.8 167.1 261.5 70.98 64.15 130 0.546 12M 39K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.6 4.0 7.5 18.1 10.6 6.9 2.8 167.1 261.5 70.98 64.15 130 0.546 12M 39K 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 11.6 4.0 7.5 11.5 4.0 0.0 0.0 231.3 230.5 51.27 47.09 36 1.424 12M 39K 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 342.0 19.71 17.06 94 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 24.2 total, 24.0 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 18.12 GB write, 766.44 MB/s write, 11.58 GB read, 489.73 MB/s read, 71.0 seconds Interval compaction: 18.12 GB write, 773.91 MB/s write, 11.58 GB read, 494.49 MB/s read, 71.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 9, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 9, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 9, total-stops: 38, interval: 47 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2374811 Average: 2.3206 StdDev: 16.14 Min: 0 Median: 1.4716 Max: 6394 Percentiles: P50: 1.47 P75: 1.86 P99: 5.90 P99.9: 12.47 P99.99: 149.66 ------------------------------------------------------ [ 0, 1 ] 462269 19.466% 19.466% #### ( 1, 2 ] 1537620 64.747% 84.213% ############# ( 2, 3 ] 202012 8.506% 92.719% ## ( 3, 4 ] 91412 3.849% 96.568% # ( 4, 6 ] 60906 2.565% 99.133% # ( 6, 10 ] 16912 0.712% 99.845% ( 10, 15 ] 2647 0.111% 99.957% ( 15, 22 ] 266 0.011% 99.968% ( 22, 34 ] 32 0.001% 99.969% ( 34, 51 ] 14 0.001% 99.970% ( 51, 76 ] 15 0.001% 99.970% ( 76, 110 ] 219 0.009% 99.979% ( 110, 170 ] 382 0.016% 99.996% ( 170, 250 ] 238 0.010% 100.006% ( 250, 380 ] 172 0.007% 100.013% ( 380, 580 ] 142 0.006% 100.019% ( 580, 870 ] 111 0.005% 100.023% ( 870, 1300 ] 43 0.002% 100.025% ( 1300, 1900 ] 17 0.001% 100.026% ( 1900, 2900 ] 19 0.001% 100.027% ( 2900, 4400 ] 19 0.001% 100.028% ( 4400, 6600 ] 2 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 291655 Average: 3.3212 StdDev: 26.84 Min: 0 Median: 1.8031 Max: 4476 Percentiles: P50: 1.80 P75: 2.71 P99: 8.46 P99.9: 14.68 P99.99: 191.28 ------------------------------------------------------ [ 0, 1 ] 13926 4.775% 4.775% # ( 1, 2 ] 164245 56.315% 61.090% ########### ( 2, 3 ] 56836 19.487% 80.577% #### ( 3, 4 ] 25218 8.647% 89.224% ## ( 4, 6 ] 25594 8.775% 97.999% ## ( 6, 10 ] 4749 1.628% 99.627% ( 10, 15 ] 849 0.291% 99.918% ( 15, 22 ] 102 0.035% 99.953% ( 22, 34 ] 9 0.003% 99.956% ( 34, 51 ] 2 0.001% 99.957% ( 51, 76 ] 1 0.000% 99.957% ( 76, 110 ] 26 0.009% 99.966% ( 110, 170 ] 55 0.019% 99.985% ( 170, 250 ] 52 0.018% 100.003% ( 250, 380 ] 39 0.013% 100.016% ( 380, 580 ] 65 0.022% 100.039% ( 580, 870 ] 31 0.011% 100.049% ( 870, 1300 ] 26 0.009% 100.058% ( 1300, 1900 ] 17 0.006% 100.064% ( 1900, 2900 ] 6 0.002% 100.066% ( 2900, 4400 ] 4 0.001% 100.068% ( 4400, 6600 ] 1 0.000% 100.068% ** Level 2 read latency histogram (micros): Count: 124173 Average: 2.8611 StdDev: 30.90 Min: 1 Median: 1.4354 Max: 4589 Percentiles: P50: 1.44 P75: 1.83 P99: 6.49 P99.9: 208.26 P99.99: 1521.37 ------------------------------------------------------ [ 0, 1 ] 28251 22.751% 22.751% ##### ( 1, 2 ] 77712 62.584% 85.335% ############# ( 2, 3 ] 8932 7.193% 92.528% # ( 3, 4 ] 4816 3.878% 96.407% # ( 4, 6 ] 3098 2.495% 98.902% ( 6, 10 ] 992 0.799% 99.700% ( 10, 15 ] 145 0.117% 99.817% ( 15, 22 ] 12 0.010% 99.827% ( 22, 34 ] 2 0.002% 99.828% ( 34, 51 ] 1 0.001% 99.829% ( 51, 76 ] 9 0.007% 99.837% ( 76, 110 ] 24 0.019% 99.856% ( 110, 170 ] 40 0.032% 99.888% ( 170, 250 ] 31 0.025% 99.913% ( 250, 380 ] 24 0.019% 99.932% ( 380, 580 ] 36 0.029% 99.961% ( 580, 870 ] 23 0.019% 99.980% ( 870, 1300 ] 10 0.008% 99.988% ( 1300, 1900 ] 7 0.006% 99.994% ( 1900, 2900 ] 6 0.005% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 356156 Average: 7.4240 StdDev: 75.07 Min: 0 Median: 1.7704 Max: 6291 Percentiles: P50: 1.77 P75: 2.70 P99: 13.44 P99.9: 724.58 P99.99: 1064.73 ------------------------------------------------------ [ 0, 1 ] 22860 6.419% 6.419% # ( 1, 2 ] 201487 56.573% 62.991% ########### ( 2, 3 ] 61227 17.191% 80.182% ### ( 3, 4 ] 31744 8.913% 89.095% ## ( 4, 6 ] 27710 7.780% 96.876% ## ( 6, 10 ] 6744 1.894% 98.769% ( 10, 15 ] 1197 0.336% 99.105% ( 15, 22 ] 153 0.043% 99.148% ( 22, 34 ] 42 0.012% 99.160% ( 34, 51 ] 8 0.002% 99.162% ( 51, 76 ] 5 0.001% 99.164% ( 76, 110 ] 188 0.053% 99.216% ( 110, 170 ] 467 0.131% 99.347% ( 170, 250 ] 533 0.150% 99.497% ( 250, 380 ] 532 0.149% 99.647% ( 380, 580 ] 676 0.190% 99.836% ( 580, 870 ] 455 0.128% 99.964% ( 870, 1300 ] 204 0.057% 100.021% ( 1300, 1900 ] 73 0.020% 100.042% ( 1900, 2900 ] 84 0.024% 100.065% ( 2900, 4400 ] 39 0.011% 100.076% ( 4400, 6600 ] 7 0.002% 100.078% ** Level 4 read latency histogram (micros): Count: 125 Average: 314.7920 StdDev: 818.03 Min: 1 Median: 2.6111 Max: 5400 Percentiles: P50: 2.61 P75: 141.15 P99: 4212.50 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ [ 0, 1 ] 17 13.600% 13.600% ### ( 1, 2 ] 40 32.000% 45.600% ###### ( 2, 3 ] 9 7.200% 52.800% # ( 3, 4 ] 2 1.600% 54.400% ( 4, 6 ] 3 2.400% 56.800% ( 6, 10 ] 7 5.600% 62.400% # ( 10, 15 ] 2 1.600% 64.000% ( 22, 34 ] 5 4.000% 68.000% # ( 51, 76 ] 2 1.600% 69.600% ( 110, 170 ] 13 10.400% 80.000% ## ( 250, 380 ] 4 3.200% 83.200% # ( 380, 580 ] 2 1.600% 84.800% ( 580, 870 ] 3 2.400% 87.200% ( 870, 1300 ] 6 4.800% 92.000% # ( 1300, 1900 ] 2 1.600% 93.600% ( 1900, 2900 ] 5 4.000% 97.600% # ( 2900, 4400 ] 2 1.600% 99.200% ( 4400, 6600 ] 1 0.800% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 906.0500 StdDev: 1030.08 Min: 77 Median: 456.1905 Max: 4350 Percentiles: P50: 456.19 P75: 1300.00 P99: 4142.86 P99.9: 4350.00 P99.99: 4350.00 ------------------------------------------------------ ( 76, 110 ] 12 10.000% 10.000% ## ( 110, 170 ] 21 17.500% 27.500% #### ( 170, 250 ] 8 6.667% 34.167% # ( 250, 380 ] 11 9.167% 43.333% ## ( 380, 580 ] 21 17.500% 60.833% #### ( 580, 870 ] 10 8.333% 69.167% ## ( 870, 1300 ] 7 5.833% 75.000% # ( 1300, 1900 ] 9 7.500% 82.500% ## ( 1900, 2900 ] 14 11.667% 94.167% ## ( 2900, 4400 ] 7 5.833% 100.000% # ** DB Stats ** Uptime(secs): 24.2 total, 3.2 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 284.52 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.448 H:M:S, 22.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.30 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.599 H:M:S, 18.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-13:47:10 ... thread 0: (1000000,8000000) ops and (114462.0,244540.4) ops/second in (8.736522,32.714435) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/12 5.09 GB 156.9 8.4 0.0 8.4 16.0 7.6 0.0 2.1 154.9 294.8 55.70 51.89 135 0.413 8760K 20K 0.0 0.0 L1 4/4 390.92 MB 0.0 2.3 2.3 0.0 2.3 2.3 0.2 1.0 232.0 230.2 10.05 9.69 2 5.024 2367K 17K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.9 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 16/0 993.80 MB 1.0 2.3 1.1 1.1 2.3 1.1 1.1 2.0 191.5 191.1 12.08 9.89 9 1.342 2322K 4266 0.0 0.0 L4 165/0 9.74 GB 1.0 0.6 0.5 0.1 0.6 0.5 1.7 1.2 163.2 162.7 3.68 2.74 5 0.736 609K 2057 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 1266/16 103.72 GB 0.0 13.9 4.0 9.9 21.5 11.6 7.0 2.8 171.7 265.2 83.01 75.67 153 0.543 14M 45K 0.0 0.0 Int 0/0 0.00 KB 0.0 13.9 4.0 9.9 21.5 11.6 6.9 2.8 171.7 265.2 83.01 75.67 153 0.543 14M 45K 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.9 4.0 9.9 13.9 4.0 0.0 0.0 236.7 236.0 60.20 55.85 42 1.433 14M 45K 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 342.4 22.82 19.83 111 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 32.9 total, 32.7 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.50 GB write, 668.17 MB/s write, 13.92 GB read, 432.50 MB/s read, 83.0 seconds Interval compaction: 21.50 GB write, 672.94 MB/s write, 13.92 GB read, 435.59 MB/s read, 83.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 38, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 38, interval: 58 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3436954 Average: 2.3212 StdDev: 14.95 Min: 0 Median: 1.4719 Max: 6394 Percentiles: P50: 1.47 P75: 1.85 P99: 5.92 P99.9: 13.28 P99.99: 156.10 ------------------------------------------------------ [ 0, 1 ] 649020 18.884% 18.884% #### ( 1, 2 ] 2266154 65.935% 84.819% ############# ( 2, 3 ] 287892 8.376% 93.195% ## ( 3, 4 ] 124849 3.633% 96.827% # ( 4, 6 ] 77609 2.258% 99.086% ( 6, 10 ] 25708 0.748% 99.834% ( 10, 15 ] 3486 0.101% 99.935% ( 15, 22 ] 392 0.011% 99.946% ( 22, 34 ] 42 0.001% 99.948% ( 34, 51 ] 15 0.000% 99.948% ( 51, 76 ] 31 0.001% 99.949% ( 76, 110 ] 717 0.021% 99.970% ( 110, 170 ] 905 0.026% 99.996% ( 170, 250 ] 367 0.011% 100.007% ( 250, 380 ] 257 0.007% 100.014% ( 380, 580 ] 210 0.006% 100.020% ( 580, 870 ] 147 0.004% 100.025% ( 870, 1300 ] 49 0.001% 100.026% ( 1300, 1900 ] 22 0.001% 100.027% ( 1900, 2900 ] 23 0.001% 100.027% ( 2900, 4400 ] 23 0.001% 100.028% ( 4400, 6600 ] 2 0.000% 100.028% ** Level 1 read latency histogram (micros): Count: 291655 Average: 3.3212 StdDev: 26.84 Min: 0 Median: 1.8031 Max: 4476 Percentiles: P50: 1.80 P75: 2.71 P99: 8.46 P99.9: 14.68 P99.99: 191.28 ------------------------------------------------------ [ 0, 1 ] 13926 4.775% 4.775% # ( 1, 2 ] 164245 56.315% 61.090% ########### ( 2, 3 ] 56836 19.487% 80.577% #### ( 3, 4 ] 25218 8.647% 89.224% ## ( 4, 6 ] 25594 8.775% 97.999% ## ( 6, 10 ] 4749 1.628% 99.627% ( 10, 15 ] 849 0.291% 99.918% ( 15, 22 ] 102 0.035% 99.953% ( 22, 34 ] 9 0.003% 99.956% ( 34, 51 ] 2 0.001% 99.957% ( 51, 76 ] 1 0.000% 99.957% ( 76, 110 ] 26 0.009% 99.966% ( 110, 170 ] 55 0.019% 99.985% ( 170, 250 ] 52 0.018% 100.003% ( 250, 380 ] 39 0.013% 100.016% ( 380, 580 ] 65 0.022% 100.039% ( 580, 870 ] 31 0.011% 100.049% ( 870, 1300 ] 26 0.009% 100.058% ( 1300, 1900 ] 17 0.006% 100.064% ( 1900, 2900 ] 6 0.002% 100.066% ( 2900, 4400 ] 4 0.001% 100.068% ( 4400, 6600 ] 1 0.000% 100.068% ** Level 2 read latency histogram (micros): Count: 124173 Average: 2.8611 StdDev: 30.90 Min: 1 Median: 1.4354 Max: 4589 Percentiles: P50: 1.44 P75: 1.83 P99: 6.49 P99.9: 208.26 P99.99: 1521.37 ------------------------------------------------------ [ 0, 1 ] 28251 22.751% 22.751% ##### ( 1, 2 ] 77712 62.584% 85.335% ############# ( 2, 3 ] 8932 7.193% 92.528% # ( 3, 4 ] 4816 3.878% 96.407% # ( 4, 6 ] 3098 2.495% 98.902% ( 6, 10 ] 992 0.799% 99.700% ( 10, 15 ] 145 0.117% 99.817% ( 15, 22 ] 12 0.010% 99.827% ( 22, 34 ] 2 0.002% 99.828% ( 34, 51 ] 1 0.001% 99.829% ( 51, 76 ] 9 0.007% 99.837% ( 76, 110 ] 24 0.019% 99.856% ( 110, 170 ] 40 0.032% 99.888% ( 170, 250 ] 31 0.025% 99.913% ( 250, 380 ] 24 0.019% 99.932% ( 380, 580 ] 36 0.029% 99.961% ( 580, 870 ] 23 0.019% 99.980% ( 870, 1300 ] 10 0.008% 99.988% ( 1300, 1900 ] 7 0.006% 99.994% ( 1900, 2900 ] 6 0.005% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 356156 Average: 7.4240 StdDev: 75.07 Min: 0 Median: 1.7704 Max: 6291 Percentiles: P50: 1.77 P75: 2.70 P99: 13.44 P99.9: 724.58 P99.99: 1064.73 ------------------------------------------------------ [ 0, 1 ] 22860 6.419% 6.419% # ( 1, 2 ] 201487 56.573% 62.991% ########### ( 2, 3 ] 61227 17.191% 80.182% ### ( 3, 4 ] 31744 8.913% 89.095% ## ( 4, 6 ] 27710 7.780% 96.876% ## ( 6, 10 ] 6744 1.894% 98.769% ( 10, 15 ] 1197 0.336% 99.105% ( 15, 22 ] 153 0.043% 99.148% ( 22, 34 ] 42 0.012% 99.160% ( 34, 51 ] 8 0.002% 99.162% ( 51, 76 ] 5 0.001% 99.164% ( 76, 110 ] 188 0.053% 99.216% ( 110, 170 ] 467 0.131% 99.347% ( 170, 250 ] 533 0.150% 99.497% ( 250, 380 ] 532 0.149% 99.647% ( 380, 580 ] 676 0.190% 99.836% ( 580, 870 ] 455 0.128% 99.964% ( 870, 1300 ] 204 0.057% 100.021% ( 1300, 1900 ] 73 0.020% 100.042% ( 1900, 2900 ] 84 0.024% 100.065% ( 2900, 4400 ] 39 0.011% 100.076% ( 4400, 6600 ] 7 0.002% 100.078% ** Level 4 read latency histogram (micros): Count: 125 Average: 314.7920 StdDev: 818.03 Min: 1 Median: 2.6111 Max: 5400 Percentiles: P50: 2.61 P75: 141.15 P99: 4212.50 P99.9: 5400.00 P99.99: 5400.00 ------------------------------------------------------ [ 0, 1 ] 17 13.600% 13.600% ### ( 1, 2 ] 40 32.000% 45.600% ###### ( 2, 3 ] 9 7.200% 52.800% # ( 3, 4 ] 2 1.600% 54.400% ( 4, 6 ] 3 2.400% 56.800% ( 6, 10 ] 7 5.600% 62.400% # ( 10, 15 ] 2 1.600% 64.000% ( 22, 34 ] 5 4.000% 68.000% # ( 51, 76 ] 2 1.600% 69.600% ( 110, 170 ] 13 10.400% 80.000% ## ( 250, 380 ] 4 3.200% 83.200% # ( 380, 580 ] 2 1.600% 84.800% ( 580, 870 ] 3 2.400% 87.200% ( 870, 1300 ] 6 4.800% 92.000% # ( 1300, 1900 ] 2 1.600% 93.600% ( 1900, 2900 ] 5 4.000% 97.600% # ( 2900, 4400 ] 2 1.600% 99.200% ( 4400, 6600 ] 1 0.800% 100.000% ** Level 5 read latency histogram (micros): Count: 120 Average: 906.0500 StdDev: 1030.08 Min: 77 Median: 456.1905 Max: 4350 Percentiles: P50: 456.19 P75: 1300.00 P99: 4142.86 P99.9: 4350.00 P99.99: 4350.00 ------------------------------------------------------ ( 76, 110 ] 12 10.000% 10.000% ## ( 110, 170 ] 21 17.500% 27.500% #### ( 170, 250 ] 8 6.667% 34.167% # ( 250, 380 ] 11 9.167% 43.333% ## ( 380, 580 ] 21 17.500% 60.833% #### ( 580, 870 ] 10 8.333% 69.167% ## ( 870, 1300 ] 7 5.833% 75.000% # ( 1300, 1900 ] 9 7.500% 82.500% ## ( 1900, 2900 ] 14 11.667% 94.167% ## ( 2900, 4400 ] 7 5.833% 100.000% # ** DB Stats ** Uptime(secs): 33.0 total, 8.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 238.95 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:11.472 H:M:S, 34.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 112.65 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:6.024 H:M:S, 69.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-13:47:23 ... thread 0: (1000000,9000000) ops and (75814.7,196059.3) ops/second in (13.190051,45.904486) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/9 2.45 GB 25.2 8.9 0.0 8.9 17.4 8.5 0.0 2.0 147.8 289.1 61.80 56.28 150 0.412 9272K 21K 0.0 0.0 L1 15/15 1.53 GB 0.0 6.2 5.8 0.4 6.1 5.7 0.2 1.1 226.6 223.5 28.08 26.52 3 9.362 6461K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.3 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 17/1 1.09 GB 1.0 4.6 2.6 2.0 4.6 2.6 1.9 1.7 168.5 167.2 27.88 20.82 16 1.743 4745K 35K 0.0 0.0 L4 168/3 9.65 GB 1.0 3.1 2.7 0.4 3.1 2.7 1.7 1.2 135.8 135.1 23.40 14.69 34 0.688 3167K 13K 0.0 0.0 L5 1092/0 89.81 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 1304/28 104.53 GB 0.0 23.2 11.3 11.9 31.6 19.7 12.5 3.7 166.4 226.7 142.68 119.76 205 0.696 24M 155K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.2 11.3 11.9 31.6 19.7 12.4 3.7 166.4 226.7 142.68 119.76 205 0.696 24M 155K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.2 11.3 11.9 23.0 11.2 0.0 0.0 205.2 203.9 115.71 97.43 81 1.428 24M 155K 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 324.6 26.97 22.34 124 0.218 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 46.1 total, 45.9 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: 31.59 GB write, 701.03 MB/s write, 23.19 GB read, 514.70 MB/s read, 142.7 seconds Interval compaction: 31.59 GB write, 704.59 MB/s write, 23.19 GB read, 517.32 MB/s read, 142.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 54, pending-compaction-bytes-delays: 18, pending-compaction-bytes-stops: 0, total-delays: 41, total-stops: 54, interval: 95 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4147303 Average: 2.6348 StdDev: 26.20 Min: 0 Median: 1.4824 Max: 11804 Percentiles: P50: 1.48 P75: 1.87 P99: 6.94 P99.9: 104.33 P99.99: 271.44 ------------------------------------------------------ [ 0, 1 ] 770471 18.578% 18.578% #### ( 1, 2 ] 2701358 65.135% 83.713% ############# ( 2, 3 ] 360883 8.702% 92.415% ## ( 3, 4 ] 155558 3.751% 96.165% # ( 4, 6 ] 108794 2.623% 98.789% # ( 6, 10 ] 37331 0.900% 99.689% ( 10, 15 ] 5368 0.129% 99.818% ( 15, 22 ] 672 0.016% 99.834% ( 22, 34 ] 65 0.002% 99.836% ( 34, 51 ] 20 0.000% 99.836% ( 51, 76 ] 214 0.005% 99.842% ( 76, 110 ] 2910 0.070% 99.912% ( 110, 170 ] 2488 0.060% 99.972% ( 170, 250 ] 676 0.016% 99.988% ( 250, 380 ] 505 0.012% 100.000% ( 380, 580 ] 434 0.010% 100.011% ( 580, 870 ] 270 0.007% 100.017% ( 870, 1300 ] 125 0.003% 100.020% ( 1300, 1900 ] 74 0.002% 100.022% ( 1900, 2900 ] 64 0.002% 100.024% ( 2900, 4400 ] 83 0.002% 100.026% ( 4400, 6600 ] 17 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ( 9900, 14000 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1009252 Average: 4.1384 StdDev: 45.20 Min: 0 Median: 1.8028 Max: 7593 Percentiles: P50: 1.80 P75: 2.83 P99: 9.26 P99.9: 17.70 P99.99: 101.44 ------------------------------------------------------ [ 0, 1 ] 75098 7.441% 7.441% # ( 1, 2 ] 535015 53.011% 60.452% ########### ( 2, 3 ] 177289 17.566% 78.018% #### ( 3, 4 ] 92464 9.162% 87.180% ## ( 4, 6 ] 100029 9.911% 97.091% ## ( 6, 10 ] 23667 2.345% 99.436% ( 10, 15 ] 4469 0.443% 99.879% ( 15, 22 ] 549 0.054% 99.933% ( 22, 34 ] 54 0.005% 99.939% ( 34, 51 ] 7 0.001% 99.939% ( 51, 76 ] 136 0.013% 99.953% ( 76, 110 ] 500 0.050% 100.002% ( 110, 170 ] 455 0.045% 100.048% ( 170, 250 ] 226 0.022% 100.070% ( 250, 380 ] 292 0.029% 100.099% ( 380, 580 ] 371 0.037% 100.136% ( 580, 870 ] 315 0.031% 100.167% ( 870, 1300 ] 190 0.019% 100.186% ( 1300, 1900 ] 76 0.008% 100.193% ( 1900, 2900 ] 56 0.006% 100.199% ( 2900, 4400 ] 53 0.005% 100.204% ( 4400, 6600 ] 14 0.001% 100.205% ( 6600, 9900 ] 2 0.000% 100.206% ** Level 2 read latency histogram (micros): Count: 124173 Average: 2.8611 StdDev: 30.90 Min: 1 Median: 1.4354 Max: 4589 Percentiles: P50: 1.44 P75: 1.83 P99: 6.49 P99.9: 208.26 P99.99: 1521.37 ------------------------------------------------------ [ 0, 1 ] 28251 22.751% 22.751% ##### ( 1, 2 ] 77712 62.584% 85.335% ############# ( 2, 3 ] 8932 7.193% 92.528% # ( 3, 4 ] 4816 3.878% 96.407% # ( 4, 6 ] 3098 2.495% 98.902% ( 6, 10 ] 992 0.799% 99.700% ( 10, 15 ] 145 0.117% 99.817% ( 15, 22 ] 12 0.010% 99.827% ( 22, 34 ] 2 0.002% 99.828% ( 34, 51 ] 1 0.001% 99.829% ( 51, 76 ] 9 0.007% 99.837% ( 76, 110 ] 24 0.019% 99.856% ( 110, 170 ] 40 0.032% 99.888% ( 170, 250 ] 31 0.025% 99.913% ( 250, 380 ] 24 0.019% 99.932% ( 380, 580 ] 36 0.029% 99.961% ( 580, 870 ] 23 0.019% 99.980% ( 870, 1300 ] 10 0.008% 99.988% ( 1300, 1900 ] 7 0.006% 99.994% ( 1900, 2900 ] 6 0.005% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 998015 Average: 7.1129 StdDev: 90.63 Min: 0 Median: 1.9084 Max: 8538 Percentiles: P50: 1.91 P75: 2.99 P99: 9.64 P99.9: 335.21 P99.99: 488.48 ------------------------------------------------------ [ 0, 1 ] 35436 3.551% 3.551% # ( 1, 2 ] 510291 51.131% 54.681% ########## ( 2, 3 ] 205447 20.586% 75.267% #### ( 3, 4 ] 107332 10.755% 86.021% ## ( 4, 6 ] 110757 11.098% 97.119% ## ( 6, 10 ] 20628 2.067% 99.186% ( 10, 15 ] 4408 0.442% 99.628% ( 15, 22 ] 493 0.049% 99.677% ( 22, 34 ] 72 0.007% 99.684% ( 34, 51 ] 22 0.002% 99.686% ( 51, 76 ] 17 0.002% 99.688% ( 76, 110 ] 231 0.023% 99.711% ( 110, 170 ] 586 0.059% 99.770% ( 170, 250 ] 713 0.071% 99.841% ( 250, 380 ] 891 0.089% 99.931% ( 380, 580 ] 1090 0.109% 100.040% ( 580, 870 ] 848 0.085% 100.125% ( 870, 1300 ] 482 0.048% 100.173% ( 1300, 1900 ] 205 0.021% 100.194% ( 1900, 2900 ] 224 0.022% 100.216% ( 2900, 4400 ] 252 0.025% 100.241% ( 4400, 6600 ] 40 0.004% 100.245% ( 6600, 9900 ] 14 0.001% 100.247% ** Level 4 read latency histogram (micros): Count: 48781 Average: 18.8215 StdDev: 198.47 Min: 1 Median: 1.8213 Max: 7299 Percentiles: P50: 1.82 P75: 2.83 P99: 384.34 P99.9: 3420.76 P99.99: 4711.21 ------------------------------------------------------ [ 0, 1 ] 2266 4.645% 4.645% # ( 1, 2 ] 26939 55.224% 59.870% ########### ( 2, 3 ] 8916 18.278% 78.147% #### ( 3, 4 ] 4334 8.885% 87.032% ## ( 4, 6 ] 4149 8.505% 95.537% ## ( 6, 10 ] 1008 2.066% 97.604% ( 10, 15 ] 326 0.668% 98.272% ( 15, 22 ] 30 0.061% 98.333% ( 22, 34 ] 17 0.035% 98.368% ( 51, 76 ] 3 0.006% 98.374% ( 76, 110 ] 12 0.025% 98.399% ( 110, 170 ] 109 0.223% 98.622% ( 170, 250 ] 81 0.166% 98.788% ( 250, 380 ] 100 0.205% 98.993% ( 380, 580 ] 147 0.301% 99.295% ( 580, 870 ] 116 0.238% 99.533% ( 870, 1300 ] 79 0.162% 99.695% ( 1300, 1900 ] 35 0.072% 99.766% ( 1900, 2900 ] 43 0.088% 99.854% ( 2900, 4400 ] 64 0.131% 99.986% ( 4400, 6600 ] 15 0.031% 100.016% ( 6600, 9900 ] 3 0.006% 100.023% ** Level 5 read latency histogram (micros): Count: 260 Average: 1323.4462 StdDev: 1388.05 Min: 77 Median: 690.0000 Max: 6457 Percentiles: P50: 690.00 P75: 2100.00 P99: 6123.33 P99.9: 6457.00 P99.99: 6457.00 ------------------------------------------------------ ( 76, 110 ] 13 5.000% 5.000% # ( 110, 170 ] 25 9.615% 14.615% ## ( 170, 250 ] 21 8.077% 22.692% ## ( 250, 380 ] 25 9.615% 32.308% ## ( 380, 580 ] 35 13.462% 45.769% ### ( 580, 870 ] 29 11.154% 56.923% ## ( 870, 1300 ] 21 8.077% 65.000% ## ( 1300, 1900 ] 20 7.692% 72.692% ## ( 1900, 2900 ] 30 11.538% 84.231% ## ( 2900, 4400 ] 29 11.154% 95.385% ## ( 4400, 6600 ] 12 4.615% 100.000% # ** DB Stats ** Uptime(secs): 46.1 total, 13.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 191.97 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:21.629 H:M:S, 46.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 74.62 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:10.158 H:M:S, 77.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/29-13:47:26 ... thread 0: (1000000,10000000) ops and (328269.0,204286.9) ops/second in (3.046282,48.950768) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/9 3.38 GB 125.9 9.7 0.0 9.7 19.2 9.5 0.0 2.0 147.1 290.2 67.64 61.73 166 0.407 10M 22K 0.0 0.0 L1 15/15 1.53 GB 0.0 6.2 5.8 0.4 6.1 5.7 0.2 1.1 226.6 223.5 28.08 26.52 3 9.362 6461K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.3 2.0 249.5 249.3 1.51 1.46 2 0.757 383K 195 0.0 0.0 L3 16/0 983.25 MB 1.0 4.6 2.6 2.0 4.6 2.6 1.9 1.7 168.5 167.2 27.88 20.82 16 1.743 4745K 35K 0.0 0.0 L4 166/0 9.46 GB 1.0 3.3 2.8 0.6 3.3 2.8 1.7 1.2 138.2 137.4 24.78 15.78 35 0.708 3417K 16K 0.0 0.0 L5 1096/0 90.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1309/24 105.45 GB 0.0 24.2 11.4 12.8 33.5 20.7 12.8 3.5 165.5 229.2 149.90 126.30 222 0.675 25M 160K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.2 11.4 12.8 33.5 20.7 12.7 3.5 165.5 229.2 149.90 126.30 222 0.675 25M 160K 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 24.2 11.4 12.8 24.1 11.3 0.0 0.0 206.5 205.1 120.19 101.51 85 1.414 25M 160K 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 326.5 29.71 24.79 137 0.217 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.2 total, 49.0 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: 33.55 GB write, 698.38 MB/s write, 24.23 GB read, 504.48 MB/s read, 149.9 seconds Interval compaction: 33.55 GB write, 701.72 MB/s write, 24.23 GB read, 506.88 MB/s read, 149.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 23, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 23, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 59, pending-compaction-bytes-delays: 18, pending-compaction-bytes-stops: 0, total-delays: 41, total-stops: 59, interval: 100 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4466400 Average: 2.6037 StdDev: 25.34 Min: 0 Median: 1.4832 Max: 11804 Percentiles: P50: 1.48 P75: 1.87 P99: 6.89 P99.9: 100.47 P99.99: 251.86 ------------------------------------------------------ [ 0, 1 ] 822427 18.414% 18.414% #### ( 1, 2 ] 2919777 65.372% 83.786% ############# ( 2, 3 ] 390555 8.744% 92.530% ## ( 3, 4 ] 165648 3.709% 96.239% # ( 4, 6 ] 114406 2.561% 98.800% # ( 6, 10 ] 40285 0.902% 99.702% ( 10, 15 ] 5726 0.128% 99.830% ( 15, 22 ] 695 0.016% 99.846% ( 22, 34 ] 71 0.002% 99.848% ( 34, 51 ] 23 0.001% 99.848% ( 51, 76 ] 217 0.005% 99.853% ( 76, 110 ] 2923 0.065% 99.918% ( 110, 170 ] 2495 0.056% 99.974% ( 170, 250 ] 698 0.016% 99.990% ( 250, 380 ] 515 0.012% 100.001% ( 380, 580 ] 446 0.010% 100.011% ( 580, 870 ] 274 0.006% 100.017% ( 870, 1300 ] 125 0.003% 100.020% ( 1300, 1900 ] 77 0.002% 100.022% ( 1900, 2900 ] 65 0.001% 100.023% ( 2900, 4400 ] 83 0.002% 100.025% ( 4400, 6600 ] 17 0.000% 100.026% ( 6600, 9900 ] 1 0.000% 100.026% ( 9900, 14000 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1040844 Average: 4.0943 StdDev: 44.55 Min: 0 Median: 1.7897 Max: 7593 Percentiles: P50: 1.79 P75: 2.80 P99: 9.24 P99.9: 18.93 P99.99: 105.23 ------------------------------------------------------ [ 0, 1 ] 81203 7.802% 7.802% ## ( 1, 2 ] 556172 53.435% 61.236% ########### ( 2, 3 ] 179760 17.271% 78.507% ### ( 3, 4 ] 93210 8.955% 87.462% ## ( 4, 6 ] 100478 9.654% 97.116% ## ( 6, 10 ] 24181 2.323% 99.439% ( 10, 15 ] 4490 0.431% 99.870% ( 15, 22 ] 550 0.053% 99.923% ( 22, 34 ] 54 0.005% 99.928% ( 34, 51 ] 7 0.001% 99.929% ( 51, 76 ] 138 0.013% 99.942% ( 76, 110 ] 578 0.056% 99.998% ( 110, 170 ] 480 0.046% 100.044% ( 170, 250 ] 232 0.022% 100.066% ( 250, 380 ] 301 0.029% 100.095% ( 380, 580 ] 377 0.036% 100.131% ( 580, 870 ] 317 0.030% 100.162% ( 870, 1300 ] 190 0.018% 100.180% ( 1300, 1900 ] 76 0.007% 100.187% ( 1900, 2900 ] 56 0.005% 100.193% ( 2900, 4400 ] 53 0.005% 100.198% ( 4400, 6600 ] 14 0.001% 100.199% ( 6600, 9900 ] 2 0.000% 100.199% ** Level 2 read latency histogram (micros): Count: 124173 Average: 2.8611 StdDev: 30.90 Min: 1 Median: 1.4354 Max: 4589 Percentiles: P50: 1.44 P75: 1.83 P99: 6.49 P99.9: 208.26 P99.99: 1521.37 ------------------------------------------------------ [ 0, 1 ] 28251 22.751% 22.751% ##### ( 1, 2 ] 77712 62.584% 85.335% ############# ( 2, 3 ] 8932 7.193% 92.528% # ( 3, 4 ] 4816 3.878% 96.407% # ( 4, 6 ] 3098 2.495% 98.902% ( 6, 10 ] 992 0.799% 99.700% ( 10, 15 ] 145 0.117% 99.817% ( 15, 22 ] 12 0.010% 99.827% ( 22, 34 ] 2 0.002% 99.828% ( 34, 51 ] 1 0.001% 99.829% ( 51, 76 ] 9 0.007% 99.837% ( 76, 110 ] 24 0.019% 99.856% ( 110, 170 ] 40 0.032% 99.888% ( 170, 250 ] 31 0.025% 99.913% ( 250, 380 ] 24 0.019% 99.932% ( 380, 580 ] 36 0.029% 99.961% ( 580, 870 ] 23 0.019% 99.980% ( 870, 1300 ] 10 0.008% 99.988% ( 1300, 1900 ] 7 0.006% 99.994% ( 1900, 2900 ] 6 0.005% 99.998% ( 2900, 4400 ] 1 0.001% 99.999% ( 4400, 6600 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 998015 Average: 7.1129 StdDev: 90.63 Min: 0 Median: 1.9084 Max: 8538 Percentiles: P50: 1.91 P75: 2.99 P99: 9.64 P99.9: 335.21 P99.99: 488.48 ------------------------------------------------------ [ 0, 1 ] 35436 3.551% 3.551% # ( 1, 2 ] 510291 51.131% 54.681% ########## ( 2, 3 ] 205447 20.586% 75.267% #### ( 3, 4 ] 107332 10.755% 86.021% ## ( 4, 6 ] 110757 11.098% 97.119% ## ( 6, 10 ] 20628 2.067% 99.186% ( 10, 15 ] 4408 0.442% 99.628% ( 15, 22 ] 493 0.049% 99.677% ( 22, 34 ] 72 0.007% 99.684% ( 34, 51 ] 22 0.002% 99.686% ( 51, 76 ] 17 0.002% 99.688% ( 76, 110 ] 231 0.023% 99.711% ( 110, 170 ] 586 0.059% 99.770% ( 170, 250 ] 713 0.071% 99.841% ( 250, 380 ] 891 0.089% 99.931% ( 380, 580 ] 1090 0.109% 100.040% ( 580, 870 ] 848 0.085% 100.125% ( 870, 1300 ] 482 0.048% 100.173% ( 1300, 1900 ] 205 0.021% 100.194% ( 1900, 2900 ] 224 0.022% 100.216% ( 2900, 4400 ] 252 0.025% 100.241% ( 4400, 6600 ] 40 0.004% 100.245% ( 6600, 9900 ] 14 0.001% 100.247% ** Level 4 read latency histogram (micros): Count: 53406 Average: 17.4571 StdDev: 189.78 Min: 1 Median: 1.8048 Max: 7299 Percentiles: P50: 1.80 P75: 2.78 P99: 328.44 P99.9: 3312.36 P99.99: 4643.38 ------------------------------------------------------ [ 0, 1 ] 2443 4.574% 4.574% # ( 1, 2 ] 30144 56.443% 61.017% ########### ( 2, 3 ] 9616 18.005% 79.023% #### ( 3, 4 ] 4583 8.581% 87.604% ## ( 4, 6 ] 4340 8.126% 95.731% ## ( 6, 10 ] 1085 2.032% 97.762% ( 10, 15 ] 344 0.644% 98.407% ( 15, 22 ] 30 0.056% 98.463% ( 22, 34 ] 17 0.032% 98.495% ( 51, 76 ] 3 0.006% 98.500% ( 76, 110 ] 12 0.022% 98.523% ( 110, 170 ] 109 0.204% 98.727% ( 170, 250 ] 85 0.159% 98.886% ( 250, 380 ] 101 0.189% 99.075% ( 380, 580 ] 149 0.279% 99.354% ( 580, 870 ] 117 0.219% 99.573% ( 870, 1300 ] 79 0.148% 99.721% ( 1300, 1900 ] 35 0.066% 99.787% ( 1900, 2900 ] 43 0.081% 99.867% ( 2900, 4400 ] 64 0.120% 99.987% ( 4400, 6600 ] 15 0.028% 100.015% ( 6600, 9900 ] 3 0.006% 100.021% ** Level 5 read latency histogram (micros): Count: 280 Average: 1295.3179 StdDev: 1379.59 Min: 77 Median: 660.0000 Max: 6457 Percentiles: P50: 660.00 P75: 2029.03 P99: 6126.15 P99.9: 6457.00 P99.99: 6457.00 ------------------------------------------------------ ( 76, 110 ] 16 5.714% 5.714% # ( 110, 170 ] 27 9.643% 15.357% ## ( 170, 250 ] 24 8.571% 23.929% ## ( 250, 380 ] 28 10.000% 33.929% ## ( 380, 580 ] 37 13.214% 47.143% ### ( 580, 870 ] 29 10.357% 57.500% ## ( 870, 1300 ] 23 8.214% 65.714% ## ( 1300, 1900 ] 22 7.857% 73.571% ## ( 1900, 2900 ] 31 11.071% 84.643% ## ( 2900, 4400 ] 30 10.714% 95.357% ## ( 4400, 6600 ] 13 4.643% 100.000% # ** DB Stats ** Uptime(secs): 49.2 total, 3.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 200.09 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:22.079 H:M:S, 44.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 323.08 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.450 H:M:S, 14.8 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.473 micros/op 182701 ops/sec 60.021 seconds 10965999 operations; 177.0 MB/s Microseconds per write: Count: 10965999 Average: 5.4734 StdDev: 374.30 Min: 0 Median: 1.7337 Max: 758121 Percentiles: P50: 1.73 P75: 2.71 P99: 7.85 P99.9: 1112.36 P99.99: 2648.37 ------------------------------------------------------ [ 0, 1 ] 1489902 13.587% 13.587% ### ( 1, 2 ] 5442539 49.631% 63.218% ########## ( 2, 3 ] 1810672 16.512% 79.729% ### ( 3, 4 ] 1513347 13.800% 93.530% ### ( 4, 6 ] 558557 5.094% 98.623% # ( 6, 10 ] 89115 0.813% 99.436% ( 10, 15 ] 20910 0.191% 99.627% ( 15, 22 ] 7376 0.067% 99.694% ( 22, 34 ] 1831 0.017% 99.710% ( 34, 51 ] 213 0.002% 99.712% ( 51, 76 ] 36 0.000% 99.713% ( 76, 110 ] 7636 0.070% 99.782% ( 110, 170 ] 3081 0.028% 99.810% ( 170, 250 ] 349 0.003% 99.814% ( 250, 380 ] 82 0.001% 99.814% ( 380, 580 ] 27 0.000% 99.815% ( 580, 870 ] 22 0.000% 99.815% ( 870, 1300 ] 16568 0.151% 99.966% ( 1300, 1900 ] 71 0.001% 99.967% ( 1900, 2900 ] 3432 0.031% 99.998% ( 2900, 4400 ] 157 0.001% 99.999% ( 4400, 6600 ] 37 0.000% 100.000% ( 6600, 9900 ] 12 0.000% 100.000% ( 9900, 14000 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 170000, 250000 ] 15 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 247098 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 : 10965999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11316910968 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 : 618 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30429392 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 : 34325143461 rocksdb.compact.write.bytes COUNT : 34064024431 rocksdb.flush.write.bytes COUNT : 11295782937 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 : 63 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 : 351 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 : 11204699136 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4347904 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 : 34436120466 rocksdb.non.last.level.read.count COUNT : 8316602 rocksdb.block.checksum.compute.count COUNT : 8315429 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.367003 P95 : 3.830157 P99 : 5.992993 P100 : 758119.000000 COUNT : 10965999 SUM : 54934927 rocksdb.compaction.times.micros P50 : 957142.857143 P95 : 3320000.000000 P99 : 17680000.000000 P100 : 18036162.000000 COUNT : 108 SUM : 158227300 rocksdb.compaction.times.cpu_micros P50 : 837692.307692 P95 : 3320000.000000 P99 : 16828064.000000 P100 : 16828064.000000 COUNT : 108 SUM : 132448028 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 : 703.250000 P95 : 1288.782609 P99 : 9471.000000 P100 : 90815.000000 COUNT : 152 SUM : 232370 rocksdb.compaction.outfile.sync.micros P50 : 1414.285714 P95 : 118400.000000 P99 : 204514.285714 P100 : 238741.000000 COUNT : 398 SUM : 8255177 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 107.481481 P95 : 1375.000000 P99 : 2614.285714 P100 : 4953.000000 COUNT : 300 SUM : 85968 rocksdb.table.open.io.micros P50 : 1472.222222 P95 : 7931.000000 P99 : 12442.000000 P100 : 21360.000000 COUNT : 618 SUM : 1309372 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.654858 P95 : 8.120423 P99 : 11.864566 P100 : 74034.000000 COUNT : 8314016 SUM : 49613756 rocksdb.read.block.get.micros P50 : 435.263158 P95 : 3621.739130 P99 : 5554.153846 P100 : 6576.000000 COUNT : 1236 SUM : 1082580 rocksdb.write.raw.block.micros P50 : 0.512907 P95 : 0.974523 P99 : 2.988641 P100 : 16113.000000 COUNT : 10989029 SUM : 21893518 rocksdb.numfiles.in.singlecompaction P50 : 3.061728 P95 : 5.428571 P99 : 19.200000 P100 : 28.000000 COUNT : 180 SUM : 643 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.556523 P95 : 1135.388191 P99 : 2371.852069 P100 : 757930.000000 COUNT : 200140 SUM : 30442255 rocksdb.sst.read.micros P50 : 1.595082 P95 : 4.913399 P99 : 8.765730 P100 : 11804.000000 COUNT : 8317367 SUM : 32333875 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 : 10965999 SUM : 11316910968 rocksdb.bytes.per.multiget P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.compressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.decompressed P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.compression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.decompression.times.nanos P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.read.num.merge_operands P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.key.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.value.size P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.multiget.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.seek.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.next.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.prev.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.write.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.read.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.blob.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.compression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.blobdb.decompression.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.flush.micros P50 : 210000.000000 P95 : 369600.000000 P99 : 709200.000000 P100 : 888361.000000 COUNT : 152 SUM : 32818945 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 : 389 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