[2024-12-13 13:58:05.169043] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 22.11.4 initialization... [2024-12-13 13:58:05.169190] [ 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_pid696050 ] Set seed to 1734094685165549 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-13 13:58:05.259475] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-13 13:58:05.299257] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-13 13:58:05.299307] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 696050' to capture a snapshot of events at runtime. [2024-12-13 13:58:05.299319] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid696050 for offline analysis/debug. [2024-12-13 13:58:05.299348] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 13 13:58:09 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/13-13:58:12 ... thread 0: (1000000,1000000) ops and (333834.9,333834.9) ops/second in (2.995493,2.995493) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 348.1 2.53 2.28 12 0.211 0 0 0.0 0.0 L2 3/2 251.74 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 9/0 741.40 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.0 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.0 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.3 1.4 93.2 310.7 4.05 3.74 14 0.290 383K 200 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 93.2 310.7 4.05 3.74 14 0.290 383K 200 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 248.7 248.5 1.52 1.46 2 0.760 383K 200 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 348.1 2.53 2.28 12 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): 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.63 MB/s write, 0.37 GB read, 116.90 MB/s read, 4.1 seconds Interval compaction: 1.23 GB write, 420.33 MB/s write, 0.37 GB read, 126.11 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: 112915 Average: 1.8662 StdDev: 18.07 Min: 1 Median: 1.2194 Max: 4315 Percentiles: P50: 1.22 P75: 1.66 P99: 3.86 P99.9: 9.06 P99.99: 308.68 ------------------------------------------------------ [ 0, 1 ] 42312 37.472% 37.472% ####### ( 1, 2 ] 64483 57.108% 94.580% ########### ( 2, 3 ] 3822 3.385% 97.965% # ( 3, 4 ] 1355 1.200% 99.165% ( 4, 6 ] 635 0.562% 99.727% ( 6, 10 ] 255 0.226% 99.953% ( 10, 15 ] 18 0.016% 99.969% ( 15, 22 ] 7 0.006% 99.975% ( 34, 51 ] 1 0.001% 99.976% ( 51, 76 ] 2 0.002% 99.978% ( 110, 170 ] 9 0.008% 99.986% ( 170, 250 ] 2 0.002% 99.988% ( 250, 380 ] 6 0.005% 99.993% ( 380, 580 ] 2 0.002% 99.995% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 1 read latency histogram (micros): Count: 5 Average: 677.6000 StdDev: 681.82 Min: 50 Median: 230.0000 Max: 1787 Percentiles: P50: 230.00 P75: 1192.50 P99: 1787.00 P99.9: 1787.00 P99.99: 1787.00 ------------------------------------------------------ ( 34, 51 ] 1 20.000% 20.000% #### ( 170, 250 ] 2 40.000% 60.000% ######## ( 870, 1300 ] 1 20.000% 80.000% #### ( 1300, 1900 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 61939 Average: 1.8457 StdDev: 5.75 Min: 0 Median: 1.2654 Max: 844 Percentiles: P50: 1.27 P75: 1.69 P99: 4.85 P99.9: 9.68 P99.99: 47.70 ------------------------------------------------------ [ 0, 1 ] 21364 34.492% 34.492% ####### ( 1, 2 ] 36188 58.425% 92.917% ############ ( 2, 3 ] 2323 3.750% 96.668% # ( 3, 4 ] 1217 1.965% 98.633% ( 4, 6 ] 536 0.865% 99.498% ( 6, 10 ] 272 0.439% 99.937% ( 10, 15 ] 26 0.042% 99.979% ( 15, 22 ] 7 0.011% 99.990% ( 34, 51 ] 1 0.002% 99.992% ( 250, 380 ] 2 0.003% 99.995% ( 380, 580 ] 1 0.002% 99.997% ( 580, 870 ] 3 0.005% 100.002% ** Level 3 read latency histogram (micros): Count: 40 Average: 1649.0250 StdDev: 1477.65 Min: 192 Median: 1156.6667 Max: 6905 Percentiles: P50: 1156.67 P75: 2300.00 P99: 6905.00 P99.9: 6905.00 P99.99: 6905.00 ------------------------------------------------------ ( 170, 250 ] 2 5.000% 5.000% # ( 250, 380 ] 2 5.000% 10.000% # ( 380, 580 ] 3 7.500% 17.500% ## ( 580, 870 ] 7 17.500% 35.000% #### ( 870, 1300 ] 9 22.500% 57.500% ##### ( 1300, 1900 ] 5 12.500% 70.000% ### ( 1900, 2900 ] 5 12.500% 82.500% ### ( 2900, 4400 ] 5 12.500% 95.000% ### ( 4400, 6600 ] 1 2.500% 97.500% # ( 6600, 9900 ] 1 2.500% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1642.6286 StdDev: 1653.00 Min: 136 Median: 896.8750 Max: 6185 Percentiles: P50: 896.88 P75: 2025.00 P99: 6185.00 P99.9: 6185.00 P99.99: 6185.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 380, 580 ] 7 20.000% 22.857% #### ( 580, 870 ] 9 25.714% 48.571% ##### ( 870, 1300 ] 8 22.857% 71.429% ##### ( 1300, 1900 ] 1 2.857% 74.286% # ( 1900, 2900 ] 2 5.714% 80.000% # ( 2900, 4400 ] 3 8.571% 88.571% ## ( 4400, 6600 ] 4 11.429% 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.40 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.400 H:M:S, 12.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.31 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.400 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-13:58:15 ... thread 0: (1000000,2000000) ops and (327049.2,330407.2) ops/second in (3.057644,6.053137) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/4 1.23 GB 100.7 0.9 0.0 0.9 2.7 1.8 0.0 1.5 100.4 315.4 8.78 8.16 29 0.303 895K 984 0.0 0.0 L1 1/0 2.88 MB 0.3 0.4 0.4 0.0 0.4 0.4 0.2 1.0 234.2 233.8 1.61 1.56 1 1.614 383K 592 0.0 0.0 L2 2/0 53.74 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 39/0 971.98 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.6 201.4 3.96 3.50 3 1.319 809K 811 0.0 0.0 L4 148/0 9.56 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 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1246/4 97.98 GB 0.0 2.4 1.1 1.3 4.2 3.0 1.5 2.3 153.4 272.3 15.87 14.68 35 0.454 2472K 2587 0.0 0.0 Int 0/0 0.00 KB 0.0 2.4 1.1 1.3 4.2 3.0 1.4 2.3 153.4 272.3 15.87 14.68 35 0.454 2472K 2587 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.4 1.1 1.3 2.4 1.1 0.0 0.0 232.1 231.9 10.49 9.86 9 1.166 2472K 2587 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 351.0 5.38 4.82 26 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.3 total, 6.1 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 4.22 GB write, 687.15 MB/s write, 2.38 GB read, 387.15 MB/s read, 15.9 seconds Interval compaction: 4.22 GB write, 713.95 MB/s write, 2.38 GB read, 402.25 MB/s read, 15.9 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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 412715 Average: 2.1190 StdDev: 13.25 Min: 1 Median: 1.4238 Max: 4315 Percentiles: P50: 1.42 P75: 1.82 P99: 5.63 P99.9: 9.82 P99.99: 14.92 ------------------------------------------------------ [ 0, 1 ] 96947 23.490% 23.490% ##### ( 1, 2 ] 258165 62.553% 86.043% ############# ( 2, 3 ] 31452 7.621% 93.664% ## ( 3, 4 ] 14231 3.448% 97.112% # ( 4, 6 ] 9574 2.320% 99.432% ( 6, 10 ] 2027 0.491% 99.923% ( 10, 15 ] 282 0.068% 99.991% ( 15, 22 ] 38 0.009% 100.000% ( 22, 34 ] 4 0.001% 100.001% ( 34, 51 ] 3 0.001% 100.002% ( 51, 76 ] 3 0.001% 100.003% ( 110, 170 ] 10 0.002% 100.005% ( 170, 250 ] 11 0.003% 100.008% ( 250, 380 ] 15 0.004% 100.011% ( 380, 580 ] 5 0.001% 100.013% ( 580, 870 ] 5 0.001% 100.014% ( 870, 1300 ] 4 0.001% 100.015% ( 1300, 1900 ] 4 0.001% 100.016% ( 1900, 2900 ] 1 0.000% 100.016% ( 2900, 4400 ] 4 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 81897 Average: 2.4693 StdDev: 10.01 Min: 0 Median: 1.6209 Max: 1787 Percentiles: P50: 1.62 P75: 2.04 P99: 6.19 P99.9: 12.74 P99.99: 19.45 ------------------------------------------------------ [ 0, 1 ] 8112 9.905% 9.905% ## ( 1, 2 ] 52885 64.575% 74.480% ############# ( 2, 3 ] 11798 14.406% 88.886% ### ( 3, 4 ] 4421 5.398% 94.284% # ( 4, 6 ] 3829 4.675% 98.960% # ( 6, 10 ] 694 0.847% 99.807% ( 10, 15 ] 139 0.170% 99.977% ( 15, 22 ] 17 0.021% 99.998% ( 22, 34 ] 3 0.004% 100.001% ( 34, 51 ] 3 0.004% 100.005% ( 51, 76 ] 2 0.002% 100.007% ( 110, 170 ] 1 0.001% 100.009% ( 170, 250 ] 3 0.004% 100.012% ( 250, 380 ] 3 0.004% 100.016% ( 380, 580 ] 1 0.001% 100.017% ( 870, 1300 ] 3 0.004% 100.021% ( 1300, 1900 ] 1 0.001% 100.022% ** Level 2 read latency histogram (micros): Count: 95433 Average: 1.9691 StdDev: 4.70 Min: 0 Median: 1.3669 Max: 844 Percentiles: P50: 1.37 P75: 1.78 P99: 5.44 P99.9: 9.69 P99.99: 21.58 ------------------------------------------------------ [ 0, 1 ] 26282 27.540% 27.540% ###### ( 1, 2 ] 58420 61.216% 88.755% ############ ( 2, 3 ] 5711 5.984% 94.740% # ( 3, 4 ] 2904 3.043% 97.783% # ( 4, 6 ] 1619 1.696% 99.479% ( 6, 10 ] 435 0.456% 99.935% ( 10, 15 ] 44 0.046% 99.981% ( 15, 22 ] 9 0.009% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 57471 Average: 3.6634 StdDev: 58.81 Min: 0 Median: 1.6188 Max: 6905 Percentiles: P50: 1.62 P75: 2.05 P99: 6.99 P99.9: 53.65 P99.99: 1450.35 ------------------------------------------------------ [ 0, 1 ] 6020 10.475% 10.475% ## ( 1, 2 ] 36708 63.872% 74.347% ############# ( 2, 3 ] 8056 14.018% 88.365% ### ( 3, 4 ] 3255 5.664% 94.028% # ( 4, 6 ] 2739 4.766% 98.794% # ( 6, 10 ] 476 0.828% 99.622% ( 10, 15 ] 105 0.183% 99.805% ( 15, 22 ] 10 0.017% 99.823% ( 22, 34 ] 24 0.042% 99.864% ( 34, 51 ] 20 0.035% 99.899% ( 51, 76 ] 5 0.009% 99.908% ( 76, 110 ] 4 0.007% 99.915% ( 110, 170 ] 4 0.007% 99.922% ( 170, 250 ] 8 0.014% 99.936% ( 250, 380 ] 6 0.010% 99.946% ( 380, 580 ] 5 0.009% 99.955% ( 580, 870 ] 9 0.016% 99.970% ( 870, 1300 ] 10 0.017% 99.988% ( 1300, 1900 ] 5 0.009% 99.997% ( 1900, 2900 ] 5 0.009% 100.005% ( 2900, 4400 ] 5 0.009% 100.014% ( 4400, 6600 ] 1 0.002% 100.016% ( 6600, 9900 ] 1 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 35 Average: 1642.6286 StdDev: 1653.00 Min: 136 Median: 896.8750 Max: 6185 Percentiles: P50: 896.88 P75: 2025.00 P99: 6185.00 P99.9: 6185.00 P99.99: 6185.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 380, 580 ] 7 20.000% 22.857% #### ( 580, 870 ] 9 25.714% 48.571% ##### ( 870, 1300 ] 8 22.857% 71.429% ##### ( 1300, 1900 ] 1 2.857% 74.286% # ( 1900, 2900 ] 2 5.714% 80.000% # ( 2900, 4400 ] 3 8.571% 88.571% ## ( 4400, 6600 ] 4 11.429% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 684.2000 StdDev: 1101.55 Min: 105 Median: 164.0000 Max: 4898 Percentiles: P50: 164.00 P75: 580.00 P99: 4898.00 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 10 50.000% 55.000% ########## ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 6.3 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 312.90 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.771 H:M:S, 12.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.88 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.372 H:M:S, 12.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-13:58:18 ... thread 0: (1000000,3000000) ops and (359787.2,339652.5) ops/second in (2.779421,8.832558) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/11 2.09 GB 50.4 1.4 0.0 1.4 4.1 2.7 0.0 1.5 105.9 317.6 13.09 12.18 44 0.297 1407K 1459 0.0 0.0 L1 1/1 2.88 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 234.2 233.8 1.61 1.56 1 1.614 383K 592 0.0 0.0 L2 2/0 53.74 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 39/0 971.98 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.6 201.4 3.96 3.50 3 1.319 809K 811 0.0 0.0 L4 148/0 9.56 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 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/12 98.84 GB 0.0 2.9 1.1 1.8 5.6 3.8 1.5 2.1 145.7 282.9 20.18 18.70 50 0.404 2984K 3062 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.1 1.8 5.6 3.8 1.4 2.1 145.7 282.9 20.18 18.70 50 0.404 2984K 3062 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.9 1.1 1.8 2.9 1.1 0.0 0.0 238.3 238.0 12.34 11.67 11 1.121 2984K 3062 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 353.6 7.84 7.03 39 0.201 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.1 total, 8.8 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.57 GB write, 629.33 MB/s write, 2.87 GB read, 324.08 MB/s read, 20.2 seconds Interval compaction: 5.57 GB write, 646.16 MB/s write, 2.87 GB read, 332.74 MB/s read, 20.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 681971 Average: 2.0666 StdDev: 11.08 Min: 0 Median: 1.4134 Max: 4315 Percentiles: P50: 1.41 P75: 1.81 P99: 5.45 P99.9: 9.74 P99.99: 14.87 ------------------------------------------------------ [ 0, 1 ] 161114 23.625% 23.625% ##### ( 1, 2 ] 435120 63.803% 87.428% ############# ( 2, 3 ] 49286 7.227% 94.655% # ( 3, 4 ] 20398 2.991% 97.646% # ( 4, 6 ] 12776 1.873% 99.519% ( 6, 10 ] 2775 0.407% 99.926% ( 10, 15 ] 447 0.066% 99.992% ( 15, 22 ] 57 0.008% 100.000% ( 22, 34 ] 5 0.001% 100.001% ( 34, 51 ] 3 0.000% 100.001% ( 51, 76 ] 5 0.001% 100.002% ( 110, 170 ] 16 0.002% 100.005% ( 170, 250 ] 19 0.003% 100.007% ( 250, 380 ] 19 0.003% 100.010% ( 380, 580 ] 8 0.001% 100.011% ( 580, 870 ] 9 0.001% 100.013% ( 870, 1300 ] 8 0.001% 100.014% ( 1300, 1900 ] 5 0.001% 100.015% ( 1900, 2900 ] 1 0.000% 100.015% ( 2900, 4400 ] 4 0.001% 100.015% ** Level 1 read latency histogram (micros): Count: 81898 Average: 2.4693 StdDev: 10.01 Min: 0 Median: 1.6209 Max: 1787 Percentiles: P50: 1.62 P75: 2.04 P99: 6.19 P99.9: 12.74 P99.99: 19.45 ------------------------------------------------------ [ 0, 1 ] 8112 9.905% 9.905% ## ( 1, 2 ] 52885 64.574% 74.479% ############# ( 2, 3 ] 11798 14.406% 88.885% ### ( 3, 4 ] 4422 5.399% 94.284% # ( 4, 6 ] 3829 4.675% 98.960% # ( 6, 10 ] 694 0.847% 99.807% ( 10, 15 ] 139 0.170% 99.977% ( 15, 22 ] 17 0.021% 99.998% ( 22, 34 ] 3 0.004% 100.001% ( 34, 51 ] 3 0.004% 100.005% ( 51, 76 ] 2 0.002% 100.007% ( 110, 170 ] 1 0.001% 100.009% ( 170, 250 ] 3 0.004% 100.012% ( 250, 380 ] 3 0.004% 100.016% ( 380, 580 ] 1 0.001% 100.017% ( 870, 1300 ] 3 0.004% 100.021% ( 1300, 1900 ] 1 0.001% 100.022% ** Level 2 read latency histogram (micros): Count: 95433 Average: 1.9691 StdDev: 4.70 Min: 0 Median: 1.3669 Max: 844 Percentiles: P50: 1.37 P75: 1.78 P99: 5.44 P99.9: 9.69 P99.99: 21.58 ------------------------------------------------------ [ 0, 1 ] 26282 27.540% 27.540% ###### ( 1, 2 ] 58420 61.216% 88.755% ############ ( 2, 3 ] 5711 5.984% 94.740% # ( 3, 4 ] 2904 3.043% 97.783% # ( 4, 6 ] 1619 1.696% 99.479% ( 6, 10 ] 435 0.456% 99.935% ( 10, 15 ] 44 0.046% 99.981% ( 15, 22 ] 9 0.009% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 57471 Average: 3.6634 StdDev: 58.81 Min: 0 Median: 1.6188 Max: 6905 Percentiles: P50: 1.62 P75: 2.05 P99: 6.99 P99.9: 53.65 P99.99: 1450.35 ------------------------------------------------------ [ 0, 1 ] 6020 10.475% 10.475% ## ( 1, 2 ] 36708 63.872% 74.347% ############# ( 2, 3 ] 8056 14.018% 88.365% ### ( 3, 4 ] 3255 5.664% 94.028% # ( 4, 6 ] 2739 4.766% 98.794% # ( 6, 10 ] 476 0.828% 99.622% ( 10, 15 ] 105 0.183% 99.805% ( 15, 22 ] 10 0.017% 99.823% ( 22, 34 ] 24 0.042% 99.864% ( 34, 51 ] 20 0.035% 99.899% ( 51, 76 ] 5 0.009% 99.908% ( 76, 110 ] 4 0.007% 99.915% ( 110, 170 ] 4 0.007% 99.922% ( 170, 250 ] 8 0.014% 99.936% ( 250, 380 ] 6 0.010% 99.946% ( 380, 580 ] 5 0.009% 99.955% ( 580, 870 ] 9 0.016% 99.970% ( 870, 1300 ] 10 0.017% 99.988% ( 1300, 1900 ] 5 0.009% 99.997% ( 1900, 2900 ] 5 0.009% 100.005% ( 2900, 4400 ] 5 0.009% 100.014% ( 4400, 6600 ] 1 0.002% 100.016% ( 6600, 9900 ] 1 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 35 Average: 1642.6286 StdDev: 1653.00 Min: 136 Median: 896.8750 Max: 6185 Percentiles: P50: 896.88 P75: 2025.00 P99: 6185.00 P99.9: 6185.00 P99.99: 6185.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 380, 580 ] 7 20.000% 22.857% #### ( 580, 870 ] 9 25.714% 48.571% ##### ( 870, 1300 ] 8 22.857% 71.429% ##### ( 1300, 1900 ] 1 2.857% 74.286% # ( 1900, 2900 ] 2 5.714% 80.000% # ( 2900, 4400 ] 3 8.571% 88.571% ## ( 4400, 6600 ] 4 11.429% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 684.2000 StdDev: 1101.55 Min: 105 Median: 164.0000 Max: 4898 Percentiles: P50: 164.00 P75: 580.00 P99: 4898.00 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 10 50.000% 55.000% ########## ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 325.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:0.968 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 354.10 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.196 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-13:58:21 ... thread 0: (1000000,4000000) ops and (287125.2,324797.7) ops/second in (3.482801,12.315359) 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.20 GB 157.3 2.5 0.0 2.5 6.3 3.8 0.0 1.6 122.2 311.4 20.63 19.31 63 0.327 2558K 2718 0.0 0.0 L1 1/1 2.88 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 234.2 233.8 1.61 1.56 1 1.614 383K 592 0.0 0.0 L2 2/0 53.74 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 39/0 971.98 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.6 201.4 3.96 3.50 3 1.319 809K 811 0.0 0.0 L4 148/0 9.56 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 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1256/12 99.95 GB 0.0 4.0 1.1 2.9 7.8 4.9 1.5 2.0 147.0 287.7 27.72 25.83 69 0.402 4135K 4321 0.0 0.0 Int 0/0 0.00 KB 0.0 4.0 1.1 2.9 7.8 4.9 1.4 2.0 147.0 287.7 27.72 25.83 69 0.402 4135K 4321 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 244.2 244.0 16.68 15.94 15 1.112 4135K 4321 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 353.8 11.04 9.88 54 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.6 total, 12.3 interval Flush(GB): cumulative 3.814, interval 3.814 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.79 GB write, 635.28 MB/s write, 3.98 GB read, 324.50 MB/s read, 27.7 seconds Interval compaction: 7.79 GB write, 647.46 MB/s write, 3.98 GB read, 330.72 MB/s read, 27.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 11, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1160176 Average: 2.1360 StdDev: 11.62 Min: 0 Median: 1.4531 Max: 4315 Percentiles: P50: 1.45 P75: 1.83 P99: 5.53 P99.9: 9.84 P99.99: 14.56 ------------------------------------------------------ [ 0, 1 ] 235897 20.333% 20.333% #### ( 1, 2 ] 759608 65.474% 85.806% ############# ( 2, 3 ] 97192 8.377% 94.184% ## ( 3, 4 ] 37762 3.255% 97.439% # ( 4, 6 ] 23629 2.037% 99.475% ( 6, 10 ] 5136 0.443% 99.918% ( 10, 15 ] 919 0.079% 99.997% ( 15, 22 ] 93 0.008% 100.005% ( 22, 34 ] 10 0.001% 100.006% ( 34, 51 ] 7 0.001% 100.007% ( 51, 76 ] 8 0.001% 100.007% ( 76, 110 ] 49 0.004% 100.012% ( 110, 170 ] 43 0.004% 100.015% ( 170, 250 ] 41 0.004% 100.019% ( 250, 380 ] 32 0.003% 100.022% ( 380, 580 ] 17 0.001% 100.023% ( 580, 870 ] 19 0.002% 100.025% ( 870, 1300 ] 13 0.001% 100.026% ( 1300, 1900 ] 8 0.001% 100.026% ( 1900, 2900 ] 1 0.000% 100.027% ( 2900, 4400 ] 8 0.001% 100.027% ** Level 1 read latency histogram (micros): Count: 81898 Average: 2.4693 StdDev: 10.01 Min: 0 Median: 1.6209 Max: 1787 Percentiles: P50: 1.62 P75: 2.04 P99: 6.19 P99.9: 12.74 P99.99: 19.45 ------------------------------------------------------ [ 0, 1 ] 8112 9.905% 9.905% ## ( 1, 2 ] 52885 64.574% 74.479% ############# ( 2, 3 ] 11798 14.406% 88.885% ### ( 3, 4 ] 4422 5.399% 94.284% # ( 4, 6 ] 3829 4.675% 98.960% # ( 6, 10 ] 694 0.847% 99.807% ( 10, 15 ] 139 0.170% 99.977% ( 15, 22 ] 17 0.021% 99.998% ( 22, 34 ] 3 0.004% 100.001% ( 34, 51 ] 3 0.004% 100.005% ( 51, 76 ] 2 0.002% 100.007% ( 110, 170 ] 1 0.001% 100.009% ( 170, 250 ] 3 0.004% 100.012% ( 250, 380 ] 3 0.004% 100.016% ( 380, 580 ] 1 0.001% 100.017% ( 870, 1300 ] 3 0.004% 100.021% ( 1300, 1900 ] 1 0.001% 100.022% ** Level 2 read latency histogram (micros): Count: 95433 Average: 1.9691 StdDev: 4.70 Min: 0 Median: 1.3669 Max: 844 Percentiles: P50: 1.37 P75: 1.78 P99: 5.44 P99.9: 9.69 P99.99: 21.58 ------------------------------------------------------ [ 0, 1 ] 26282 27.540% 27.540% ###### ( 1, 2 ] 58420 61.216% 88.755% ############ ( 2, 3 ] 5711 5.984% 94.740% # ( 3, 4 ] 2904 3.043% 97.783% # ( 4, 6 ] 1619 1.696% 99.479% ( 6, 10 ] 435 0.456% 99.935% ( 10, 15 ] 44 0.046% 99.981% ( 15, 22 ] 9 0.009% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 57471 Average: 3.6634 StdDev: 58.81 Min: 0 Median: 1.6188 Max: 6905 Percentiles: P50: 1.62 P75: 2.05 P99: 6.99 P99.9: 53.65 P99.99: 1450.35 ------------------------------------------------------ [ 0, 1 ] 6020 10.475% 10.475% ## ( 1, 2 ] 36708 63.872% 74.347% ############# ( 2, 3 ] 8056 14.018% 88.365% ### ( 3, 4 ] 3255 5.664% 94.028% # ( 4, 6 ] 2739 4.766% 98.794% # ( 6, 10 ] 476 0.828% 99.622% ( 10, 15 ] 105 0.183% 99.805% ( 15, 22 ] 10 0.017% 99.823% ( 22, 34 ] 24 0.042% 99.864% ( 34, 51 ] 20 0.035% 99.899% ( 51, 76 ] 5 0.009% 99.908% ( 76, 110 ] 4 0.007% 99.915% ( 110, 170 ] 4 0.007% 99.922% ( 170, 250 ] 8 0.014% 99.936% ( 250, 380 ] 6 0.010% 99.946% ( 380, 580 ] 5 0.009% 99.955% ( 580, 870 ] 9 0.016% 99.970% ( 870, 1300 ] 10 0.017% 99.988% ( 1300, 1900 ] 5 0.009% 99.997% ( 1900, 2900 ] 5 0.009% 100.005% ( 2900, 4400 ] 5 0.009% 100.014% ( 4400, 6600 ] 1 0.002% 100.016% ( 6600, 9900 ] 1 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 35 Average: 1642.6286 StdDev: 1653.00 Min: 136 Median: 896.8750 Max: 6185 Percentiles: P50: 896.88 P75: 2025.00 P99: 6185.00 P99.9: 6185.00 P99.99: 6185.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 380, 580 ] 7 20.000% 22.857% #### ( 580, 870 ] 9 25.714% 48.571% ##### ( 870, 1300 ] 8 22.857% 71.429% ##### ( 1300, 1900 ] 1 2.857% 74.286% # ( 1900, 2900 ] 2 5.714% 80.000% # ( 2900, 4400 ] 3 8.571% 88.571% ## ( 4400, 6600 ] 4 11.429% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 684.2000 StdDev: 1101.55 Min: 105 Median: 164.0000 Max: 4898 Percentiles: P50: 164.00 P75: 580.00 P99: 4898.00 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 10 50.000% 55.000% ########## ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.6 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 313.61 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.802 H:M:S, 14.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 282.58 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.834 H:M:S, 24.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/12/13-13:58:24 ... thread 0: (1000000,5000000) ops and (338515.2,327451.5) ops/second in (2.954077,15.269436) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/4 2.77 GB 258.0 3.3 0.0 3.3 8.1 4.7 0.0 1.7 128.1 310.6 26.56 24.91 79 0.336 3454K 3678 0.0 0.0 L1 12/0 1.35 GB 137.9 1.7 1.7 0.0 1.7 1.7 0.2 1.0 229.8 228.6 7.68 7.43 2 3.842 1792K 8636 0.0 0.0 L2 2/0 53.74 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 39/0 971.98 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.6 201.4 3.96 3.50 3 1.319 809K 811 0.0 0.0 L4 148/0 9.56 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 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/4 100.86 GB 0.0 6.2 2.5 3.7 10.9 7.2 1.5 2.3 159.7 281.5 39.72 37.30 86 0.462 6440K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.2 2.5 3.7 10.9 7.2 1.4 2.3 159.7 281.5 39.72 37.30 86 0.462 6440K 13K 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.2 2.5 3.7 6.2 2.5 0.0 0.0 243.2 242.7 26.08 25.10 19 1.373 6440K 13K 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 355.7 13.64 12.21 67 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.5 total, 15.3 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 10.92 GB write, 720.95 MB/s write, 6.19 GB read, 409.03 MB/s read, 39.7 seconds Interval compaction: 10.92 GB write, 732.10 MB/s write, 6.19 GB read, 415.36 MB/s read, 39.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 14, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1414405 Average: 2.1219 StdDev: 12.19 Min: 0 Median: 1.4304 Max: 4315 Percentiles: P50: 1.43 P75: 1.82 P99: 5.46 P99.9: 9.92 P99.99: 18.50 ------------------------------------------------------ [ 0, 1 ] 313223 22.145% 22.145% #### ( 1, 2 ] 915363 64.717% 86.862% ############# ( 2, 3 ] 109826 7.765% 94.627% ## ( 3, 4 ] 42975 3.038% 97.666% # ( 4, 6 ] 25851 1.828% 99.493% ( 6, 10 ] 5876 0.415% 99.909% ( 10, 15 ] 1098 0.078% 99.986% ( 15, 22 ] 105 0.007% 99.994% ( 22, 34 ] 10 0.001% 99.994% ( 34, 51 ] 7 0.000% 99.995% ( 51, 76 ] 13 0.001% 99.996% ( 76, 110 ] 89 0.006% 100.002% ( 110, 170 ] 96 0.007% 100.009% ( 170, 250 ] 70 0.005% 100.014% ( 250, 380 ] 50 0.004% 100.017% ( 380, 580 ] 33 0.002% 100.020% ( 580, 870 ] 32 0.002% 100.022% ( 870, 1300 ] 20 0.001% 100.023% ( 1300, 1900 ] 9 0.001% 100.024% ( 1900, 2900 ] 1 0.000% 100.024% ( 2900, 4400 ] 10 0.001% 100.025% ** Level 1 read latency histogram (micros): Count: 82689 Average: 2.8080 StdDev: 18.53 Min: 0 Median: 1.6219 Max: 1787 Percentiles: P50: 1.62 P75: 2.04 P99: 6.69 P99.9: 41.43 P99.99: 461.38 ------------------------------------------------------ [ 0, 1 ] 8214 9.934% 9.934% ## ( 1, 2 ] 53275 64.428% 74.362% ############# ( 2, 3 ] 11952 14.454% 88.816% ### ( 3, 4 ] 4453 5.385% 94.201% # ( 4, 6 ] 3846 4.651% 98.852% # ( 6, 10 ] 703 0.850% 99.702% ( 10, 15 ] 141 0.171% 99.873% ( 15, 22 ] 18 0.022% 99.895% ( 22, 34 ] 3 0.004% 99.898% ( 34, 51 ] 3 0.004% 99.902% ( 51, 76 ] 2 0.002% 99.904% ( 76, 110 ] 22 0.027% 99.931% ( 110, 170 ] 24 0.029% 99.960% ( 170, 250 ] 9 0.011% 99.971% ( 250, 380 ] 8 0.010% 99.981% ( 380, 580 ] 19 0.023% 100.004% ( 580, 870 ] 4 0.005% 100.008% ( 870, 1300 ] 5 0.006% 100.015% ( 1300, 1900 ] 6 0.007% 100.022% ** Level 2 read latency histogram (micros): Count: 95433 Average: 1.9691 StdDev: 4.70 Min: 0 Median: 1.3669 Max: 844 Percentiles: P50: 1.37 P75: 1.78 P99: 5.44 P99.9: 9.69 P99.99: 21.58 ------------------------------------------------------ [ 0, 1 ] 26282 27.540% 27.540% ###### ( 1, 2 ] 58420 61.216% 88.755% ############ ( 2, 3 ] 5711 5.984% 94.740% # ( 3, 4 ] 2904 3.043% 97.783% # ( 4, 6 ] 1619 1.696% 99.479% ( 6, 10 ] 435 0.456% 99.935% ( 10, 15 ] 44 0.046% 99.981% ( 15, 22 ] 9 0.009% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 57471 Average: 3.6634 StdDev: 58.81 Min: 0 Median: 1.6188 Max: 6905 Percentiles: P50: 1.62 P75: 2.05 P99: 6.99 P99.9: 53.65 P99.99: 1450.35 ------------------------------------------------------ [ 0, 1 ] 6020 10.475% 10.475% ## ( 1, 2 ] 36708 63.872% 74.347% ############# ( 2, 3 ] 8056 14.018% 88.365% ### ( 3, 4 ] 3255 5.664% 94.028% # ( 4, 6 ] 2739 4.766% 98.794% # ( 6, 10 ] 476 0.828% 99.622% ( 10, 15 ] 105 0.183% 99.805% ( 15, 22 ] 10 0.017% 99.823% ( 22, 34 ] 24 0.042% 99.864% ( 34, 51 ] 20 0.035% 99.899% ( 51, 76 ] 5 0.009% 99.908% ( 76, 110 ] 4 0.007% 99.915% ( 110, 170 ] 4 0.007% 99.922% ( 170, 250 ] 8 0.014% 99.936% ( 250, 380 ] 6 0.010% 99.946% ( 380, 580 ] 5 0.009% 99.955% ( 580, 870 ] 9 0.016% 99.970% ( 870, 1300 ] 10 0.017% 99.988% ( 1300, 1900 ] 5 0.009% 99.997% ( 1900, 2900 ] 5 0.009% 100.005% ( 2900, 4400 ] 5 0.009% 100.014% ( 4400, 6600 ] 1 0.002% 100.016% ( 6600, 9900 ] 1 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 35 Average: 1642.6286 StdDev: 1653.00 Min: 136 Median: 896.8750 Max: 6185 Percentiles: P50: 896.88 P75: 2025.00 P99: 6185.00 P99.9: 6185.00 P99.99: 6185.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 380, 580 ] 7 20.000% 22.857% #### ( 580, 870 ] 9 25.714% 48.571% ##### ( 870, 1300 ] 8 22.857% 71.429% ##### ( 1300, 1900 ] 1 2.857% 74.286% # ( 1900, 2900 ] 2 5.714% 80.000% # ( 2900, 4400 ] 3 8.571% 88.571% ## ( 4400, 6600 ] 4 11.429% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 684.2000 StdDev: 1101.55 Min: 105 Median: 164.0000 Max: 4898 Percentiles: P50: 164.00 P75: 580.00 P99: 4898.00 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 10 50.000% 55.000% ########## ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.5 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 317.33 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.158 H:M:S, 13.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 333.16 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.356 H:M:S, 12.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/13-13:58:27 ... thread 0: (1000000,6000000) ops and (333790.3,328491.2) ops/second in (2.995893,18.265329) 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/19 3.69 GB 0.0 4.1 0.0 4.1 9.8 5.7 0.0 1.7 130.8 310.3 32.26 30.29 95 0.340 4285K 4533 0.0 0.0 L1 12/12 1.35 GB 0.0 1.7 1.7 0.0 1.7 1.7 0.2 1.0 229.8 228.6 7.68 7.43 2 3.842 1792K 8636 0.0 0.0 L2 2/0 53.74 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 39/0 971.98 MB 1.0 0.8 0.6 0.2 0.8 0.6 0.1 1.4 201.6 201.4 3.96 3.50 3 1.319 809K 811 0.0 0.0 L4 148/0 9.56 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 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/31 101.78 GB 0.0 7.0 2.5 4.5 12.6 8.1 1.5 2.2 157.7 285.0 45.42 42.68 102 0.445 7271K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 2.5 4.5 12.6 8.1 1.4 2.2 157.7 285.0 45.42 42.68 102 0.445 7271K 14K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.0 2.5 4.5 7.0 2.5 0.0 0.0 245.6 245.0 29.17 28.13 22 1.326 7271K 14K 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 356.6 16.25 14.56 80 0.203 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): 18.5 total, 18.3 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: 12.64 GB write, 699.50 MB/s write, 6.99 GB read, 387.07 MB/s read, 45.4 seconds Interval compaction: 12.64 GB write, 708.54 MB/s write, 6.99 GB read, 392.07 MB/s read, 45.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 17, interval: 19 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1627398 Average: 2.1295 StdDev: 13.22 Min: 0 Median: 1.4160 Max: 5702 Percentiles: P50: 1.42 P75: 1.80 P99: 5.42 P99.9: 10.52 P99.99: 106.56 ------------------------------------------------------ [ 0, 1 ] 377976 23.226% 23.226% ##### ( 1, 2 ] 1047481 64.365% 87.591% ############# ( 2, 3 ] 119522 7.344% 94.936% # ( 3, 4 ] 46540 2.860% 97.795% # ( 4, 6 ] 27530 1.692% 99.487% ( 6, 10 ] 6593 0.405% 99.892% ( 10, 15 ] 1240 0.076% 99.968% ( 15, 22 ] 129 0.008% 99.976% ( 22, 34 ] 10 0.001% 99.977% ( 34, 51 ] 7 0.000% 99.977% ( 51, 76 ] 15 0.001% 99.978% ( 76, 110 ] 215 0.013% 99.991% ( 110, 170 ] 218 0.013% 100.005% ( 170, 250 ] 92 0.006% 100.010% ( 250, 380 ] 68 0.004% 100.015% ( 380, 580 ] 47 0.003% 100.018% ( 580, 870 ] 44 0.003% 100.020% ( 870, 1300 ] 25 0.002% 100.022% ( 1300, 1900 ] 14 0.001% 100.023% ( 1900, 2900 ] 2 0.000% 100.023% ( 2900, 4400 ] 10 0.001% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 96935 Average: 2.7753 StdDev: 17.86 Min: 0 Median: 1.5779 Max: 1787 Percentiles: P50: 1.58 P75: 1.97 P99: 7.19 P99.9: 108.66 P99.99: 473.06 ------------------------------------------------------ [ 0, 1 ] 12693 13.094% 13.094% ### ( 1, 2 ] 61902 63.859% 76.954% ############# ( 2, 3 ] 12506 12.901% 89.855% ### ( 3, 4 ] 4629 4.775% 94.630% # ( 4, 6 ] 3964 4.089% 98.720% # ( 6, 10 ] 911 0.940% 99.660% ( 10, 15 ] 160 0.165% 99.825% ( 15, 22 ] 18 0.019% 99.843% ( 22, 34 ] 3 0.003% 99.846% ( 34, 51 ] 3 0.003% 99.849% ( 51, 76 ] 2 0.002% 99.851% ( 76, 110 ] 49 0.051% 99.902% ( 110, 170 ] 44 0.045% 99.947% ( 170, 250 ] 22 0.023% 99.970% ( 250, 380 ] 10 0.010% 99.980% ( 380, 580 ] 20 0.021% 100.001% ( 580, 870 ] 6 0.006% 100.007% ( 870, 1300 ] 5 0.005% 100.012% ( 1300, 1900 ] 6 0.006% 100.019% ** Level 2 read latency histogram (micros): Count: 95433 Average: 1.9691 StdDev: 4.70 Min: 0 Median: 1.3669 Max: 844 Percentiles: P50: 1.37 P75: 1.78 P99: 5.44 P99.9: 9.69 P99.99: 21.58 ------------------------------------------------------ [ 0, 1 ] 26282 27.540% 27.540% ###### ( 1, 2 ] 58420 61.216% 88.755% ############ ( 2, 3 ] 5711 5.984% 94.740% # ( 3, 4 ] 2904 3.043% 97.783% # ( 4, 6 ] 1619 1.696% 99.479% ( 6, 10 ] 435 0.456% 99.935% ( 10, 15 ] 44 0.046% 99.981% ( 15, 22 ] 9 0.009% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 3 0.003% 100.000% ** Level 3 read latency histogram (micros): Count: 57471 Average: 3.6634 StdDev: 58.81 Min: 0 Median: 1.6188 Max: 6905 Percentiles: P50: 1.62 P75: 2.05 P99: 6.99 P99.9: 53.65 P99.99: 1450.35 ------------------------------------------------------ [ 0, 1 ] 6020 10.475% 10.475% ## ( 1, 2 ] 36708 63.872% 74.347% ############# ( 2, 3 ] 8056 14.018% 88.365% ### ( 3, 4 ] 3255 5.664% 94.028% # ( 4, 6 ] 2739 4.766% 98.794% # ( 6, 10 ] 476 0.828% 99.622% ( 10, 15 ] 105 0.183% 99.805% ( 15, 22 ] 10 0.017% 99.823% ( 22, 34 ] 24 0.042% 99.864% ( 34, 51 ] 20 0.035% 99.899% ( 51, 76 ] 5 0.009% 99.908% ( 76, 110 ] 4 0.007% 99.915% ( 110, 170 ] 4 0.007% 99.922% ( 170, 250 ] 8 0.014% 99.936% ( 250, 380 ] 6 0.010% 99.946% ( 380, 580 ] 5 0.009% 99.955% ( 580, 870 ] 9 0.016% 99.970% ( 870, 1300 ] 10 0.017% 99.988% ( 1300, 1900 ] 5 0.009% 99.997% ( 1900, 2900 ] 5 0.009% 100.005% ( 2900, 4400 ] 5 0.009% 100.014% ( 4400, 6600 ] 1 0.002% 100.016% ( 6600, 9900 ] 1 0.002% 100.017% ** Level 4 read latency histogram (micros): Count: 35 Average: 1642.6286 StdDev: 1653.00 Min: 136 Median: 896.8750 Max: 6185 Percentiles: P50: 896.88 P75: 2025.00 P99: 6185.00 P99.9: 6185.00 P99.99: 6185.00 ------------------------------------------------------ ( 110, 170 ] 1 2.857% 2.857% # ( 380, 580 ] 7 20.000% 22.857% #### ( 580, 870 ] 9 25.714% 48.571% ##### ( 870, 1300 ] 8 22.857% 71.429% ##### ( 1300, 1900 ] 1 2.857% 74.286% # ( 1900, 2900 ] 2 5.714% 80.000% # ( 2900, 4400 ] 3 8.571% 88.571% ## ( 4400, 6600 ] 4 11.429% 100.000% ## ** Level 5 read latency histogram (micros): Count: 20 Average: 684.2000 StdDev: 1101.55 Min: 105 Median: 164.0000 Max: 4898 Percentiles: P50: 164.00 P75: 580.00 P99: 4898.00 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 10 50.000% 55.000% ########## ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 18.5 total, 3.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 319.15 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.572 H:M:S, 13.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 328.52 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.413 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/13-13:58:54 ... thread 0: (1000000,7000000) ops and (37040.1,154651.3) ops/second in (26.997775,45.263104) 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/9 1.29 GB 18.9 4.7 0.0 4.7 11.3 6.6 0.0 1.7 119.8 289.9 39.97 35.16 110 0.363 4861K 5161 0.0 0.0 L1 7/7 693.22 MB 0.0 6.5 5.1 1.3 6.3 5.0 0.2 1.2 215.3 211.6 30.68 28.04 3 10.226 6708K 113K 0.0 0.0 L2 1/1 1.88 MB 0.0 0.4 0.2 0.2 0.4 0.2 4.5 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 31/16 2.69 GB 1.2 2.6 2.0 0.6 2.6 2.0 2.6 1.3 140.3 140.0 19.25 12.40 16 1.203 1897K 2423 0.0 0.0 L4 191/41 11.81 GB 1.0 1.8 1.6 0.2 1.8 1.6 1.0 1.1 122.8 122.2 14.91 8.61 17 0.877 1859K 8865 0.0 0.0 L5 1048/0 86.19 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1289/74 102.65 GB 0.0 15.9 8.9 7.0 22.4 15.4 8.7 3.4 153.3 216.1 106.32 85.67 148 0.718 15M 130K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.9 8.9 7.0 22.4 15.4 8.5 3.4 153.3 216.1 106.32 85.67 148 0.718 15M 130K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.9 8.9 7.0 15.8 8.8 0.0 0.0 192.9 191.3 84.53 68.37 55 1.537 15M 130K 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 312.2 21.79 17.29 93 0.234 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): 45.5 total, 45.3 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.43 GB write, 504.87 MB/s write, 15.92 GB read, 358.29 MB/s read, 106.3 seconds Interval compaction: 22.43 GB write, 507.51 MB/s write, 15.92 GB read, 360.16 MB/s read, 106.3 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: 50, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 50, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2853868 Average: 3.0217 StdDev: 32.77 Min: 0 Median: 1.4106 Max: 12743 Percentiles: P50: 1.41 P75: 1.82 P99: 7.82 P99.9: 161.16 P99.99: 517.50 ------------------------------------------------------ [ 0, 1 ] 704156 24.674% 24.674% ##### ( 1, 2 ] 1760464 61.687% 86.361% ############ ( 2, 3 ] 197219 6.911% 93.271% # ( 3, 4 ] 88274 3.093% 96.364% # ( 4, 6 ] 66286 2.323% 98.687% ( 6, 10 ] 19583 0.686% 99.373% ( 10, 15 ] 3345 0.117% 99.490% ( 15, 22 ] 400 0.014% 99.504% ( 22, 34 ] 32 0.001% 99.506% ( 34, 51 ] 20 0.001% 99.506% ( 51, 76 ] 49 0.002% 99.508% ( 76, 110 ] 6858 0.240% 99.748% ( 110, 170 ] 5078 0.178% 99.926% ( 170, 250 ] 776 0.027% 99.953% ( 250, 380 ] 650 0.023% 99.976% ( 380, 580 ] 574 0.020% 99.996% ( 580, 870 ] 271 0.009% 100.006% ( 870, 1300 ] 126 0.004% 100.010% ( 1300, 1900 ] 52 0.002% 100.012% ( 1900, 2900 ] 49 0.002% 100.014% ( 2900, 4400 ] 68 0.002% 100.016% ( 4400, 6600 ] 17 0.001% 100.017% ( 6600, 9900 ] 5 0.000% 100.017% ( 9900, 14000 ] 3 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 1087434 Average: 7.3843 StdDev: 130.63 Min: 0 Median: 1.6905 Max: 27116 Percentiles: P50: 1.69 P75: 2.58 P99: 9.53 P99.9: 159.77 P99.99: 693.90 ------------------------------------------------------ [ 0, 1 ] 151188 13.903% 13.903% ### ( 1, 2 ] 568451 52.275% 66.178% ########## ( 2, 3 ] 166023 15.267% 81.445% ### ( 3, 4 ] 84823 7.800% 89.245% ## ( 4, 6 ] 88799 8.166% 97.411% ## ( 6, 10 ] 19596 1.802% 99.213% ( 10, 15 ] 4469 0.411% 99.624% ( 15, 22 ] 539 0.050% 99.674% ( 22, 34 ] 42 0.004% 99.678% ( 34, 51 ] 19 0.002% 99.680% ( 51, 76 ] 42 0.004% 99.683% ( 76, 110 ] 1604 0.148% 99.831% ( 110, 170 ] 906 0.083% 99.914% ( 170, 250 ] 147 0.014% 99.928% ( 250, 380 ] 212 0.019% 99.947% ( 380, 580 ] 327 0.030% 99.977% ( 580, 870 ] 352 0.032% 100.010% ( 870, 1300 ] 262 0.024% 100.034% ( 1300, 1900 ] 218 0.020% 100.054% ( 1900, 2900 ] 386 0.035% 100.089% ( 2900, 4400 ] 450 0.041% 100.131% ( 4400, 6600 ] 141 0.013% 100.144% ( 6600, 9900 ] 60 0.006% 100.149% ( 9900, 14000 ] 7 0.001% 100.150% ( 14000, 22000 ] 2 0.000% 100.150% ( 22000, 33000 ] 1 0.000% 100.150% ** Level 2 read latency histogram (micros): Count: 95774 Average: 4.1497 StdDev: 82.32 Min: 0 Median: 1.3696 Max: 8276 Percentiles: P50: 1.37 P75: 1.78 P99: 5.60 P99.9: 582.34 P99.99: 4185.36 ------------------------------------------------------ [ 0, 1 ] 26282 27.442% 27.442% ##### ( 1, 2 ] 58462 61.042% 88.483% ############ ( 2, 3 ] 5816 6.073% 94.556% # ( 3, 4 ] 2937 3.067% 97.623% # ( 4, 6 ] 1654 1.727% 99.350% ( 6, 10 ] 442 0.462% 99.811% ( 10, 15 ] 45 0.047% 99.858% ( 15, 22 ] 9 0.009% 99.867% ( 22, 34 ] 1 0.001% 99.868% ( 34, 51 ] 1 0.001% 99.869% ( 110, 170 ] 3 0.003% 99.873% ( 170, 250 ] 1 0.001% 99.874% ( 250, 380 ] 7 0.007% 99.881% ( 380, 580 ] 18 0.019% 99.900% ( 580, 870 ] 28 0.029% 99.929% ( 870, 1300 ] 16 0.017% 99.946% ( 1300, 1900 ] 10 0.010% 99.956% ( 1900, 2900 ] 11 0.011% 99.968% ( 2900, 4400 ] 25 0.026% 99.994% ( 4400, 6600 ] 4 0.004% 99.998% ( 6600, 9900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 615926 Average: 12.4762 StdDev: 162.57 Min: 0 Median: 1.9153 Max: 11094 Percentiles: P50: 1.92 P75: 3.03 P99: 10.68 P99.9: 994.31 P99.99: 1521.50 ------------------------------------------------------ [ 0, 1 ] 23695 3.847% 3.847% # ( 1, 2 ] 310571 50.423% 54.270% ########## ( 2, 3 ] 125795 20.424% 74.694% #### ( 3, 4 ] 68534 11.127% 85.821% ## ( 4, 6 ] 68571 11.133% 96.954% ## ( 6, 10 ] 12229 1.985% 98.940% ( 10, 15 ] 2752 0.447% 99.386% ( 15, 22 ] 307 0.050% 99.436% ( 22, 34 ] 50 0.008% 99.444% ( 34, 51 ] 39 0.006% 99.451% ( 51, 76 ] 17 0.003% 99.454% ( 76, 110 ] 39 0.006% 99.460% ( 110, 170 ] 148 0.024% 99.484% ( 170, 250 ] 290 0.047% 99.531% ( 250, 380 ] 480 0.078% 99.609% ( 380, 580 ] 763 0.124% 99.733% ( 580, 870 ] 865 0.140% 99.873% ( 870, 1300 ] 571 0.093% 99.966% ( 1300, 1900 ] 402 0.065% 100.031% ( 1900, 2900 ] 339 0.055% 100.086% ( 2900, 4400 ] 470 0.076% 100.163% ( 4400, 6600 ] 121 0.020% 100.182% ( 6600, 9900 ] 45 0.007% 100.189% ( 9900, 14000 ] 1 0.000% 100.190% ** Level 4 read latency histogram (micros): Count: 235 Average: 522.5447 StdDev: 1102.73 Min: 1 Median: 5.0000 Max: 6185 Percentiles: P50: 5.00 P75: 525.00 P99: 5566.00 P99.9: 6185.00 P99.99: 6185.00 ------------------------------------------------------ [ 0, 1 ] 21 8.936% 8.936% ## ( 1, 2 ] 53 22.553% 31.489% ##### ( 2, 3 ] 29 12.340% 43.830% ## ( 3, 4 ] 11 4.681% 48.511% # ( 4, 6 ] 7 2.979% 51.489% # ( 6, 10 ] 4 1.702% 53.191% ( 10, 15 ] 4 1.702% 54.894% ( 15, 22 ] 1 0.426% 55.319% ( 22, 34 ] 2 0.851% 56.170% ( 34, 51 ] 1 0.426% 56.596% ( 51, 76 ] 8 3.404% 60.000% # ( 76, 110 ] 3 1.277% 61.277% ( 110, 170 ] 3 1.277% 62.553% ( 170, 250 ] 22 9.362% 71.915% ## ( 380, 580 ] 10 4.255% 76.170% # ( 580, 870 ] 15 6.383% 82.553% # ( 870, 1300 ] 13 5.532% 88.085% # ( 1300, 1900 ] 7 2.979% 91.064% # ( 1900, 2900 ] 7 2.979% 94.043% # ( 2900, 4400 ] 9 3.830% 97.872% # ( 4400, 6600 ] 5 2.128% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 684.2000 StdDev: 1101.55 Min: 105 Median: 164.0000 Max: 4898 Percentiles: P50: 164.00 P75: 580.00 P99: 4898.00 P99.9: 4898.00 P99.99: 4898.00 ------------------------------------------------------ ( 76, 110 ] 1 5.000% 5.000% # ( 110, 170 ] 10 50.000% 55.000% ########## ( 170, 250 ] 1 5.000% 60.000% # ( 380, 580 ] 3 15.000% 75.000% ### ( 580, 870 ] 1 5.000% 80.000% # ( 870, 1300 ] 1 5.000% 85.000% # ( 1300, 1900 ] 1 5.000% 90.000% # ( 1900, 2900 ] 1 5.000% 95.000% # ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 45.5 total, 27.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 151.41 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:26.323 H:M:S, 57.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 36.45 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:23.751 H:M:S, 88.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/13-13:58:58 ... thread 0: (1000000,8000000) ops and (262312.4,163014.6) ops/second in (3.812249,49.075353) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/9 2.21 GB 119.5 5.7 0.0 5.7 13.3 7.6 0.0 1.8 121.0 280.9 48.42 41.98 125 0.387 5948K 6630 0.0 0.0 L1 7/7 693.22 MB 0.0 6.5 5.1 1.3 6.3 5.0 0.2 1.2 215.3 211.6 30.68 28.04 3 10.226 6708K 113K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 4.5 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 14/1 978.78 MB 1.0 3.4 2.0 1.3 3.4 2.0 2.6 1.6 135.2 134.9 25.47 15.64 17 1.498 2652K 4334 0.0 0.0 L4 178/21 10.89 GB 1.0 3.3 2.6 0.7 3.3 2.6 1.7 1.3 119.9 119.3 27.92 16.11 25 1.117 3369K 14K 0.0 0.0 L5 1080/0 88.83 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1293/38 103.56 GB 0.0 19.2 9.9 9.2 26.6 17.4 12.0 3.5 146.5 203.3 134.00 103.22 172 0.779 19M 139K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.2 9.9 9.2 26.6 17.4 11.9 3.5 146.5 203.3 134.00 103.22 172 0.779 19M 139K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 19.2 9.9 9.2 19.0 9.8 0.0 0.0 180.6 179.2 108.73 83.41 67 1.623 19M 139K 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 306.6 25.27 19.81 105 0.241 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.3 total, 49.1 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 26.60 GB write, 552.34 MB/s write, 19.17 GB read, 398.12 MB/s read, 134.0 seconds Interval compaction: 26.60 GB write, 554.99 MB/s write, 19.17 GB read, 400.04 MB/s read, 134.0 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: 69, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 69, interval: 82 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3096343 Average: 3.0989 StdDev: 40.57 Min: 0 Median: 1.4307 Max: 30757 Percentiles: P50: 1.43 P75: 1.84 P99: 7.79 P99.9: 160.64 P99.99: 544.40 ------------------------------------------------------ [ 0, 1 ] 725550 23.432% 23.432% ##### ( 1, 2 ] 1909884 61.682% 85.114% ############ ( 2, 3 ] 233637 7.546% 92.660% ## ( 3, 4 ] 105287 3.400% 96.060% # ( 4, 6 ] 81109 2.620% 98.680% # ( 6, 10 ] 22204 0.717% 99.397% ( 10, 15 ] 3863 0.125% 99.522% ( 15, 22 ] 441 0.014% 99.536% ( 22, 34 ] 36 0.001% 99.537% ( 34, 51 ] 23 0.001% 99.538% ( 51, 76 ] 51 0.002% 99.540% ( 76, 110 ] 6860 0.222% 99.761% ( 110, 170 ] 5098 0.165% 99.926% ( 170, 250 ] 802 0.026% 99.952% ( 250, 380 ] 683 0.022% 99.974% ( 380, 580 ] 616 0.020% 99.994% ( 580, 870 ] 328 0.011% 100.004% ( 870, 1300 ] 169 0.005% 100.010% ( 1300, 1900 ] 74 0.002% 100.012% ( 1900, 2900 ] 70 0.002% 100.014% ( 2900, 4400 ] 85 0.003% 100.017% ( 4400, 6600 ] 21 0.001% 100.018% ( 6600, 9900 ] 7 0.000% 100.018% ( 9900, 14000 ] 5 0.000% 100.018% ( 22000, 33000 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 1416470 Average: 7.4063 StdDev: 130.48 Min: 0 Median: 1.7321 Max: 27116 Percentiles: P50: 1.73 P75: 2.65 P99: 9.61 P99.9: 190.26 P99.99: 743.80 ------------------------------------------------------ [ 0, 1 ] 160227 11.312% 11.312% ## ( 1, 2 ] 748555 52.847% 64.158% ########### ( 2, 3 ] 235183 16.603% 80.762% ### ( 3, 4 ] 113590 8.019% 88.781% ## ( 4, 6 ] 119686 8.450% 97.231% ## ( 6, 10 ] 27740 1.958% 99.189% ( 10, 15 ] 6499 0.459% 99.648% ( 15, 22 ] 752 0.053% 99.701% ( 22, 34 ] 62 0.004% 99.705% ( 34, 51 ] 26 0.002% 99.707% ( 51, 76 ] 51 0.004% 99.711% ( 76, 110 ] 1651 0.117% 99.827% ( 110, 170 ] 971 0.069% 99.896% ( 170, 250 ] 243 0.017% 99.913% ( 250, 380 ] 313 0.022% 99.935% ( 380, 580 ] 481 0.034% 99.969% ( 580, 870 ] 530 0.037% 100.006% ( 870, 1300 ] 387 0.027% 100.034% ( 1300, 1900 ] 292 0.021% 100.054% ( 1900, 2900 ] 501 0.035% 100.090% ( 2900, 4400 ] 571 0.040% 100.130% ( 4400, 6600 ] 165 0.012% 100.142% ( 6600, 9900 ] 65 0.005% 100.146% ( 9900, 14000 ] 13 0.001% 100.147% ( 14000, 22000 ] 7 0.000% 100.148% ( 22000, 33000 ] 1 0.000% 100.148% ** Level 2 read latency histogram (micros): Count: 95911 Average: 4.1486 StdDev: 82.26 Min: 0 Median: 1.3705 Max: 8276 Percentiles: P50: 1.37 P75: 1.78 P99: 5.60 P99.9: 580.92 P99.99: 4184.53 ------------------------------------------------------ [ 0, 1 ] 26283 27.404% 27.404% ##### ( 1, 2 ] 58494 60.988% 88.391% ############ ( 2, 3 ] 5878 6.129% 94.520% # ( 3, 4 ] 2957 3.083% 97.603% # ( 4, 6 ] 1671 1.742% 99.345% ( 6, 10 ] 447 0.466% 99.811% ( 10, 15 ] 45 0.047% 99.858% ( 15, 22 ] 9 0.009% 99.868% ( 22, 34 ] 1 0.001% 99.869% ( 34, 51 ] 1 0.001% 99.870% ( 110, 170 ] 3 0.003% 99.873% ( 170, 250 ] 1 0.001% 99.874% ( 250, 380 ] 7 0.007% 99.881% ( 380, 580 ] 18 0.019% 99.900% ( 580, 870 ] 28 0.029% 99.929% ( 870, 1300 ] 16 0.017% 99.946% ( 1300, 1900 ] 10 0.010% 99.956% ( 1900, 2900 ] 11 0.011% 99.968% ( 2900, 4400 ] 25 0.026% 99.994% ( 4400, 6600 ] 4 0.004% 99.998% ( 6600, 9900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 694846 Average: 13.7522 StdDev: 181.21 Min: 0 Median: 1.9126 Max: 22723 Percentiles: P50: 1.91 P75: 3.01 P99: 11.91 P99.9: 1198.78 P99.99: 1844.42 ------------------------------------------------------ [ 0, 1 ] 26679 3.840% 3.840% # ( 1, 2 ] 351473 50.583% 54.422% ########## ( 2, 3 ] 142002 20.436% 74.859% #### ( 3, 4 ] 76461 11.004% 85.863% ## ( 4, 6 ] 75934 10.928% 96.791% ## ( 6, 10 ] 14123 2.033% 98.824% ( 10, 15 ] 3206 0.461% 99.285% ( 15, 22 ] 370 0.053% 99.338% ( 22, 34 ] 55 0.008% 99.346% ( 34, 51 ] 40 0.006% 99.352% ( 51, 76 ] 19 0.003% 99.355% ( 76, 110 ] 48 0.007% 99.362% ( 110, 170 ] 195 0.028% 99.390% ( 170, 250 ] 343 0.049% 99.439% ( 250, 380 ] 576 0.083% 99.522% ( 380, 580 ] 953 0.137% 99.659% ( 580, 870 ] 1090 0.157% 99.816% ( 870, 1300 ] 764 0.110% 99.926% ( 1300, 1900 ] 491 0.071% 99.997% ( 1900, 2900 ] 431 0.062% 100.059% ( 2900, 4400 ] 598 0.086% 100.145% ( 4400, 6600 ] 143 0.021% 100.165% ( 6600, 9900 ] 50 0.007% 100.172% ( 9900, 14000 ] 5 0.001% 100.173% ( 14000, 22000 ] 7 0.001% 100.174% ( 22000, 33000 ] 1 0.000% 100.174% ** Level 4 read latency histogram (micros): Count: 50285 Average: 11.4867 StdDev: 137.41 Min: 1 Median: 1.9450 Max: 7732 Percentiles: P50: 1.95 P75: 2.99 P99: 13.09 P99.9: 1784.97 P99.99: 3273.47 ------------------------------------------------------ [ 0, 1 ] 862 1.714% 1.714% ( 1, 2 ] 25693 51.095% 52.809% ########## ( 2, 3 ] 11290 22.452% 75.261% #### ( 3, 4 ] 5402 10.743% 86.004% ## ( 4, 6 ] 5544 11.025% 97.029% ## ( 6, 10 ] 823 1.637% 98.666% ( 10, 15 ] 272 0.541% 99.207% ( 15, 22 ] 24 0.048% 99.254% ( 22, 34 ] 5 0.010% 99.264% ( 34, 51 ] 1 0.002% 99.266% ( 51, 76 ] 9 0.018% 99.284% ( 76, 110 ] 3 0.006% 99.290% ( 110, 170 ] 9 0.018% 99.308% ( 170, 250 ] 49 0.097% 99.405% ( 250, 380 ] 30 0.060% 99.465% ( 380, 580 ] 55 0.109% 99.574% ( 580, 870 ] 75 0.149% 99.724% ( 870, 1300 ] 58 0.115% 99.839% ( 1300, 1900 ] 38 0.076% 99.914% ( 1900, 2900 ] 31 0.062% 99.976% ( 2900, 4400 ] 28 0.056% 100.032% ( 4400, 6600 ] 5 0.010% 100.042% ( 6600, 9900 ] 1 0.002% 100.044% ** Level 5 read latency histogram (micros): Count: 180 Average: 1431.1056 StdDev: 1590.83 Min: 91 Median: 692.7778 Max: 7768 Percentiles: P50: 692.78 P75: 2291.30 P99: 7768.00 P99.9: 7768.00 P99.99: 7768.00 ------------------------------------------------------ ( 76, 110 ] 6 3.333% 3.333% # ( 110, 170 ] 26 14.444% 17.778% ### ( 170, 250 ] 10 5.556% 23.333% # ( 250, 380 ] 25 13.889% 37.222% ### ( 380, 580 ] 16 8.889% 46.111% ## ( 580, 870 ] 18 10.000% 56.111% ## ( 870, 1300 ] 11 6.111% 62.222% # ( 1300, 1900 ] 14 7.778% 70.000% ## ( 1900, 2900 ] 23 12.778% 82.778% ### ( 2900, 4400 ] 19 10.556% 93.333% ## ( 4400, 6600 ] 9 5.000% 98.333% # ( 6600, 9900 ] 3 1.667% 100.000% ** DB Stats ** Uptime(secs): 49.3 total, 3.8 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 159.66 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.395 H:M:S, 55.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 258.17 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.072 H:M:S, 28.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-13:59:02 ... thread 0: (1000000,9000000) ops and (273454.6,170673.5) ops/second in (3.656914,52.732267) 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/11 2.46 GB 37.8 6.6 0.0 6.6 15.1 8.5 0.0 1.8 121.8 279.9 55.34 48.09 141 0.392 6844K 7638 0.0 0.0 L1 10/10 949.21 MB 0.0 7.9 5.8 2.0 7.7 5.7 0.2 1.3 202.1 199.1 39.85 34.84 4 9.963 7475K 113K 0.0 0.0 L2 1/0 61.52 MB 0.6 0.4 0.2 0.2 0.4 0.2 5.0 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 21/1 992.99 MB 1.0 4.2 2.3 1.9 4.2 2.3 2.8 1.8 142.2 141.8 30.46 19.77 21 1.450 3556K 9361 0.0 0.0 L4 177/21 10.98 GB 1.0 3.7 3.0 0.7 3.7 3.0 1.7 1.2 125.6 125.0 30.38 18.21 29 1.047 3845K 17K 0.0 0.0 L5 1084/0 89.14 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/43 104.53 GB 0.0 22.8 11.3 11.5 31.2 19.7 13.0 3.6 148.0 202.6 157.55 122.37 197 0.800 22M 148K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.8 11.3 11.5 31.2 19.7 12.9 3.6 148.0 202.6 157.55 122.37 197 0.800 22M 148K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.8 11.3 11.5 22.6 11.1 0.0 0.0 180.9 179.6 128.93 99.93 79 1.632 22M 148K 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 306.0 28.61 22.45 118 0.242 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 53.0 total, 52.7 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.17 GB write, 602.56 MB/s write, 22.77 GB read, 440.27 MB/s read, 157.5 seconds Interval compaction: 31.17 GB write, 605.26 MB/s write, 22.77 GB read, 442.24 MB/s read, 157.5 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: 82, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 82, interval: 95 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3423696 Average: 3.1038 StdDev: 39.79 Min: 0 Median: 1.4569 Max: 30757 Percentiles: P50: 1.46 P75: 1.86 P99: 7.76 P99.9: 158.24 P99.99: 526.14 ------------------------------------------------------ [ 0, 1 ] 749302 21.886% 21.886% #### ( 1, 2 ] 2106643 61.531% 83.417% ############ ( 2, 3 ] 287076 8.385% 91.802% ## ( 3, 4 ] 130048 3.798% 95.600% # ( 4, 6 ] 104900 3.064% 98.664% # ( 6, 10 ] 26060 0.761% 99.426% ( 10, 15 ] 4596 0.134% 99.560% ( 15, 22 ] 498 0.015% 99.574% ( 22, 34 ] 40 0.001% 99.576% ( 34, 51 ] 24 0.001% 99.576% ( 51, 76 ] 55 0.002% 99.578% ( 76, 110 ] 6888 0.201% 99.779% ( 110, 170 ] 5153 0.151% 99.930% ( 170, 250 ] 849 0.025% 99.954% ( 250, 380 ] 736 0.021% 99.976% ( 380, 580 ] 666 0.019% 99.995% ( 580, 870 ] 352 0.010% 100.006% ( 870, 1300 ] 193 0.006% 100.011% ( 1300, 1900 ] 82 0.002% 100.014% ( 1900, 2900 ] 86 0.003% 100.016% ( 2900, 4400 ] 92 0.003% 100.019% ( 4400, 6600 ] 23 0.001% 100.019% ( 6600, 9900 ] 7 0.000% 100.020% ( 9900, 14000 ] 5 0.000% 100.020% ( 22000, 33000 ] 1 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1668362 Average: 7.1179 StdDev: 122.84 Min: 0 Median: 1.7533 Max: 27116 Percentiles: P50: 1.75 P75: 2.69 P99: 9.62 P99.9: 223.98 P99.99: 691.85 ------------------------------------------------------ [ 0, 1 ] 166689 9.991% 9.991% ## ( 1, 2 ] 886050 53.109% 63.100% ########### ( 2, 3 ] 287146 17.211% 80.311% ### ( 3, 4 ] 136771 8.198% 88.509% ## ( 4, 6 ] 143885 8.624% 97.134% ## ( 6, 10 ] 34385 2.061% 99.195% ( 10, 15 ] 7781 0.466% 99.661% ( 15, 22 ] 902 0.054% 99.715% ( 22, 34 ] 75 0.004% 99.720% ( 34, 51 ] 27 0.002% 99.721% ( 51, 76 ] 54 0.003% 99.724% ( 76, 110 ] 1675 0.100% 99.825% ( 110, 170 ] 1033 0.062% 99.887% ( 170, 250 ] 327 0.020% 99.906% ( 250, 380 ] 442 0.026% 99.933% ( 380, 580 ] 677 0.041% 99.973% ( 580, 870 ] 716 0.043% 100.016% ( 870, 1300 ] 523 0.031% 100.048% ( 1300, 1900 ] 346 0.021% 100.068% ( 1900, 2900 ] 527 0.032% 100.100% ( 2900, 4400 ] 581 0.035% 100.135% ( 4400, 6600 ] 168 0.010% 100.145% ( 6600, 9900 ] 66 0.004% 100.149% ( 9900, 14000 ] 15 0.001% 100.150% ( 14000, 22000 ] 7 0.000% 100.150% ( 22000, 33000 ] 1 0.000% 100.150% ** Level 2 read latency histogram (micros): Count: 95911 Average: 4.1486 StdDev: 82.26 Min: 0 Median: 1.3705 Max: 8276 Percentiles: P50: 1.37 P75: 1.78 P99: 5.60 P99.9: 580.92 P99.99: 4184.53 ------------------------------------------------------ [ 0, 1 ] 26283 27.404% 27.404% ##### ( 1, 2 ] 58494 60.988% 88.391% ############ ( 2, 3 ] 5878 6.129% 94.520% # ( 3, 4 ] 2957 3.083% 97.603% # ( 4, 6 ] 1671 1.742% 99.345% ( 6, 10 ] 447 0.466% 99.811% ( 10, 15 ] 45 0.047% 99.858% ( 15, 22 ] 9 0.009% 99.868% ( 22, 34 ] 1 0.001% 99.869% ( 34, 51 ] 1 0.001% 99.870% ( 110, 170 ] 3 0.003% 99.873% ( 170, 250 ] 1 0.001% 99.874% ( 250, 380 ] 7 0.007% 99.881% ( 380, 580 ] 18 0.019% 99.900% ( 580, 870 ] 28 0.029% 99.929% ( 870, 1300 ] 16 0.017% 99.946% ( 1300, 1900 ] 10 0.010% 99.956% ( 1900, 2900 ] 11 0.011% 99.968% ( 2900, 4400 ] 25 0.026% 99.994% ( 4400, 6600 ] 4 0.004% 99.998% ( 6600, 9900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 807739 Average: 12.4353 StdDev: 168.99 Min: 0 Median: 1.9025 Max: 22723 Percentiles: P50: 1.90 P75: 2.98 P99: 10.81 P99.9: 1122.40 P99.99: 1786.27 ------------------------------------------------------ [ 0, 1 ] 29641 3.670% 3.670% # ( 1, 2 ] 414674 51.338% 55.007% ########## ( 2, 3 ] 165158 20.447% 75.454% #### ( 3, 4 ] 87424 10.823% 86.277% ## ( 4, 6 ] 86591 10.720% 96.998% ## ( 6, 10 ] 15621 1.934% 98.932% ( 10, 15 ] 3403 0.421% 99.353% ( 15, 22 ] 382 0.047% 99.400% ( 22, 34 ] 59 0.007% 99.407% ( 34, 51 ] 40 0.005% 99.412% ( 51, 76 ] 21 0.003% 99.415% ( 76, 110 ] 64 0.008% 99.423% ( 110, 170 ] 240 0.030% 99.453% ( 170, 250 ] 402 0.050% 99.502% ( 250, 380 ] 622 0.077% 99.579% ( 380, 580 ] 1009 0.125% 99.704% ( 580, 870 ] 1123 0.139% 99.843% ( 870, 1300 ] 779 0.096% 99.940% ( 1300, 1900 ] 500 0.062% 100.002% ( 1900, 2900 ] 450 0.056% 100.057% ( 2900, 4400 ] 602 0.075% 100.132% ( 4400, 6600 ] 143 0.018% 100.150% ( 6600, 9900 ] 50 0.006% 100.156% ( 9900, 14000 ] 5 0.001% 100.156% ( 14000, 22000 ] 7 0.001% 100.157% ( 22000, 33000 ] 1 0.000% 100.157% ** Level 4 read latency histogram (micros): Count: 57411 Average: 11.6818 StdDev: 131.53 Min: 1 Median: 1.9454 Max: 7732 Percentiles: P50: 1.95 P75: 3.00 P99: 59.03 P99.9: 1678.29 P99.99: 3223.74 ------------------------------------------------------ [ 0, 1 ] 1015 1.768% 1.768% ( 1, 2 ] 29289 51.016% 52.784% ########## ( 2, 3 ] 12800 22.295% 75.080% #### ( 3, 4 ] 6148 10.709% 85.788% ## ( 4, 6 ] 6256 10.897% 96.685% ## ( 6, 10 ] 1002 1.745% 98.431% ( 10, 15 ] 292 0.509% 98.939% ( 15, 22 ] 25 0.044% 98.983% ( 22, 34 ] 6 0.010% 98.993% ( 34, 51 ] 1 0.002% 98.995% ( 51, 76 ] 9 0.016% 99.011% ( 76, 110 ] 21 0.037% 99.047% ( 110, 170 ] 48 0.084% 99.131% ( 170, 250 ] 93 0.162% 99.293% ( 250, 380 ] 71 0.124% 99.416% ( 380, 580 ] 90 0.157% 99.573% ( 580, 870 ] 98 0.171% 99.744% ( 870, 1300 ] 65 0.113% 99.857% ( 1300, 1900 ] 39 0.068% 99.925% ( 1900, 2900 ] 31 0.054% 99.979% ( 2900, 4400 ] 29 0.051% 100.030% ( 4400, 6600 ] 5 0.009% 100.038% ( 6600, 9900 ] 1 0.002% 100.040% ** Level 5 read latency histogram (micros): Count: 200 Average: 1386.1500 StdDev: 1549.78 Min: 91 Median: 667.0000 Max: 7768 Percentiles: P50: 667.00 P75: 2220.00 P99: 7700.00 P99.9: 7768.00 P99.99: 7768.00 ------------------------------------------------------ ( 76, 110 ] 6 3.000% 3.000% # ( 110, 170 ] 28 14.000% 17.000% ### ( 170, 250 ] 13 6.500% 23.500% # ( 250, 380 ] 28 14.000% 37.500% ### ( 380, 580 ] 19 9.500% 47.000% ## ( 580, 870 ] 20 10.000% 57.000% ## ( 870, 1300 ] 13 6.500% 63.500% # ( 1300, 1900 ] 15 7.500% 71.000% ## ( 1900, 2900 ] 25 12.500% 83.500% ### ( 2900, 4400 ] 21 10.500% 94.000% ## ( 4400, 6600 ] 9 4.500% 98.500% # ( 6600, 9900 ] 3 1.500% 100.000% ** DB Stats ** Uptime(secs): 53.0 total, 3.7 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 167.22 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:28.211 H:M:S, 53.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 269.13 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.816 H:M:S, 22.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/13-13:59:05 ... thread 0: (1000000,10000000) ops and (325610.0,179200.5) ops/second in (3.071159,55.803426) 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/11 3.38 GB 132.2 7.4 0.0 7.4 16.8 9.5 0.0 1.8 123.4 281.7 61.24 53.64 157 0.390 7675K 8460 0.0 0.0 L1 10/10 949.21 MB 0.0 7.9 5.8 2.0 7.7 5.7 0.2 1.3 202.1 199.1 39.85 34.84 4 9.963 7475K 113K 0.0 0.0 L2 1/0 61.52 MB 0.6 0.4 0.2 0.2 0.4 0.2 5.0 2.0 248.7 248.5 1.52 1.46 2 0.760 383K 200 0.0 0.0 L3 20/0 966.15 MB 1.0 4.2 2.3 1.9 4.2 2.3 2.8 1.8 142.2 141.8 30.46 19.77 21 1.450 3556K 9361 0.0 0.0 L4 159/0 9.64 GB 1.0 5.2 3.0 2.2 5.2 3.0 1.7 1.7 138.5 137.8 38.72 25.06 30 1.291 4458K 17K 0.0 0.0 L5 1095/0 90.50 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 1302/21 105.44 GB 0.0 25.1 11.3 13.8 34.4 20.6 14.4 3.6 149.5 205.0 171.79 134.77 214 0.803 23M 149K 0.0 0.0 Int 0/0 0.00 KB 0.0 25.1 11.3 13.8 34.4 20.6 14.3 3.6 149.5 205.0 171.79 134.77 214 0.803 23M 149K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 25.1 11.3 13.8 24.9 11.2 0.0 0.0 182.9 181.7 140.45 109.89 83 1.692 23M 149K 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 309.5 31.34 24.88 131 0.239 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): 56.0 total, 55.8 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.39 GB write, 628.45 MB/s write, 25.09 GB read, 458.38 MB/s read, 171.8 seconds Interval compaction: 34.39 GB write, 631.11 MB/s write, 25.09 GB read, 460.32 MB/s read, 171.8 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: 88, pending-compaction-bytes-delays: 6, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 88, interval: 101 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3806876 Average: 3.0300 StdDev: 37.96 Min: 0 Median: 1.4648 Max: 30757 Percentiles: P50: 1.46 P75: 1.87 P99: 7.58 P99.9: 153.00 P99.99: 470.02 ------------------------------------------------------ [ 0, 1 ] 805297 21.154% 21.154% #### ( 1, 2 ] 2362830 62.067% 83.221% ############ ( 2, 3 ] 327631 8.606% 91.827% ## ( 3, 4 ] 145476 3.821% 95.649% # ( 4, 6 ] 115872 3.044% 98.693% # ( 6, 10 ] 29641 0.779% 99.471% ( 10, 15 ] 4986 0.131% 99.602% ( 15, 22 ] 522 0.014% 99.616% ( 22, 34 ] 45 0.001% 99.617% ( 34, 51 ] 25 0.001% 99.618% ( 51, 76 ] 60 0.002% 99.619% ( 76, 110 ] 6955 0.183% 99.802% ( 110, 170 ] 5205 0.137% 99.939% ( 170, 250 ] 886 0.023% 99.962% ( 250, 380 ] 757 0.020% 99.982% ( 380, 580 ] 685 0.018% 100.000% ( 580, 870 ] 362 0.010% 100.009% ( 870, 1300 ] 198 0.005% 100.015% ( 1300, 1900 ] 85 0.002% 100.017% ( 1900, 2900 ] 91 0.002% 100.019% ( 2900, 4400 ] 93 0.002% 100.022% ( 4400, 6600 ] 23 0.001% 100.022% ( 6600, 9900 ] 7 0.000% 100.022% ( 9900, 14000 ] 5 0.000% 100.023% ( 22000, 33000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1668362 Average: 7.1179 StdDev: 122.84 Min: 0 Median: 1.7533 Max: 27116 Percentiles: P50: 1.75 P75: 2.69 P99: 9.62 P99.9: 223.98 P99.99: 691.85 ------------------------------------------------------ [ 0, 1 ] 166689 9.991% 9.991% ## ( 1, 2 ] 886050 53.109% 63.100% ########### ( 2, 3 ] 287146 17.211% 80.311% ### ( 3, 4 ] 136771 8.198% 88.509% ## ( 4, 6 ] 143885 8.624% 97.134% ## ( 6, 10 ] 34385 2.061% 99.195% ( 10, 15 ] 7781 0.466% 99.661% ( 15, 22 ] 902 0.054% 99.715% ( 22, 34 ] 75 0.004% 99.720% ( 34, 51 ] 27 0.002% 99.721% ( 51, 76 ] 54 0.003% 99.724% ( 76, 110 ] 1675 0.100% 99.825% ( 110, 170 ] 1033 0.062% 99.887% ( 170, 250 ] 327 0.020% 99.906% ( 250, 380 ] 442 0.026% 99.933% ( 380, 580 ] 677 0.041% 99.973% ( 580, 870 ] 716 0.043% 100.016% ( 870, 1300 ] 523 0.031% 100.048% ( 1300, 1900 ] 346 0.021% 100.068% ( 1900, 2900 ] 527 0.032% 100.100% ( 2900, 4400 ] 581 0.035% 100.135% ( 4400, 6600 ] 168 0.010% 100.145% ( 6600, 9900 ] 66 0.004% 100.149% ( 9900, 14000 ] 15 0.001% 100.150% ( 14000, 22000 ] 7 0.000% 100.150% ( 22000, 33000 ] 1 0.000% 100.150% ** Level 2 read latency histogram (micros): Count: 95911 Average: 4.1486 StdDev: 82.26 Min: 0 Median: 1.3705 Max: 8276 Percentiles: P50: 1.37 P75: 1.78 P99: 5.60 P99.9: 580.92 P99.99: 4184.53 ------------------------------------------------------ [ 0, 1 ] 26283 27.404% 27.404% ##### ( 1, 2 ] 58494 60.988% 88.391% ############ ( 2, 3 ] 5878 6.129% 94.520% # ( 3, 4 ] 2957 3.083% 97.603% # ( 4, 6 ] 1671 1.742% 99.345% ( 6, 10 ] 447 0.466% 99.811% ( 10, 15 ] 45 0.047% 99.858% ( 15, 22 ] 9 0.009% 99.868% ( 22, 34 ] 1 0.001% 99.869% ( 34, 51 ] 1 0.001% 99.870% ( 110, 170 ] 3 0.003% 99.873% ( 170, 250 ] 1 0.001% 99.874% ( 250, 380 ] 7 0.007% 99.881% ( 380, 580 ] 18 0.019% 99.900% ( 580, 870 ] 28 0.029% 99.929% ( 870, 1300 ] 16 0.017% 99.946% ( 1300, 1900 ] 10 0.010% 99.956% ( 1900, 2900 ] 11 0.011% 99.968% ( 2900, 4400 ] 25 0.026% 99.994% ( 4400, 6600 ] 4 0.004% 99.998% ( 6600, 9900 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 808028 Average: 12.4319 StdDev: 168.95 Min: 0 Median: 1.9025 Max: 22723 Percentiles: P50: 1.90 P75: 2.98 P99: 10.81 P99.9: 1122.24 P99.99: 1786.24 ------------------------------------------------------ [ 0, 1 ] 29642 3.668% 3.668% # ( 1, 2 ] 414810 51.336% 55.005% ########## ( 2, 3 ] 165260 20.452% 75.457% #### ( 3, 4 ] 87436 10.821% 86.278% ## ( 4, 6 ] 86624 10.720% 96.998% ## ( 6, 10 ] 15625 1.934% 98.932% ( 10, 15 ] 3404 0.421% 99.353% ( 15, 22 ] 382 0.047% 99.400% ( 22, 34 ] 59 0.007% 99.408% ( 34, 51 ] 40 0.005% 99.413% ( 51, 76 ] 21 0.003% 99.415% ( 76, 110 ] 64 0.008% 99.423% ( 110, 170 ] 240 0.030% 99.453% ( 170, 250 ] 402 0.050% 99.503% ( 250, 380 ] 622 0.077% 99.580% ( 380, 580 ] 1009 0.125% 99.704% ( 580, 870 ] 1123 0.139% 99.843% ( 870, 1300 ] 779 0.096% 99.940% ( 1300, 1900 ] 500 0.062% 100.002% ( 1900, 2900 ] 450 0.056% 100.057% ( 2900, 4400 ] 602 0.075% 100.132% ( 4400, 6600 ] 143 0.018% 100.150% ( 6600, 9900 ] 50 0.006% 100.156% ( 9900, 14000 ] 5 0.001% 100.156% ( 14000, 22000 ] 7 0.001% 100.157% ( 22000, 33000 ] 1 0.000% 100.157% ** Level 4 read latency histogram (micros): Count: 57481 Average: 12.3984 StdDev: 136.26 Min: 1 Median: 1.9466 Max: 7732 Percentiles: P50: 1.95 P75: 3.00 P99: 132.57 P99.9: 1770.71 P99.99: 3312.59 ------------------------------------------------------ [ 0, 1 ] 1015 1.766% 1.766% ( 1, 2 ] 29290 50.956% 52.722% ########## ( 2, 3 ] 12808 22.282% 75.004% #### ( 3, 4 ] 6153 10.704% 85.708% ## ( 4, 6 ] 6260 10.891% 96.599% ## ( 6, 10 ] 1002 1.743% 98.342% ( 10, 15 ] 292 0.508% 98.850% ( 15, 22 ] 25 0.043% 98.894% ( 22, 34 ] 6 0.010% 98.904% ( 34, 51 ] 1 0.002% 98.906% ( 51, 76 ] 9 0.016% 98.921% ( 76, 110 ] 23 0.040% 98.961% ( 110, 170 ] 59 0.103% 99.064% ( 170, 250 ] 95 0.165% 99.229% ( 250, 380 ] 80 0.139% 99.368% ( 380, 580 ] 94 0.164% 99.532% ( 580, 870 ] 103 0.179% 99.711% ( 870, 1300 ] 74 0.129% 99.840% ( 1300, 1900 ] 44 0.077% 99.916% ( 1900, 2900 ] 34 0.059% 99.976% ( 2900, 4400 ] 30 0.052% 100.028% ( 4400, 6600 ] 6 0.010% 100.038% ( 6600, 9900 ] 1 0.002% 100.040% ** Level 5 read latency histogram (micros): Count: 200 Average: 1386.1500 StdDev: 1549.78 Min: 91 Median: 667.0000 Max: 7768 Percentiles: P50: 667.00 P75: 2220.00 P99: 7700.00 P99.9: 7768.00 P99.99: 7768.00 ------------------------------------------------------ ( 76, 110 ] 6 3.000% 3.000% # ( 110, 170 ] 28 14.000% 17.000% ### ( 170, 250 ] 13 6.500% 23.500% # ( 250, 380 ] 28 14.000% 37.500% ### ( 380, 580 ] 19 9.500% 47.000% ## ( 580, 870 ] 20 10.000% 57.000% ## ( 870, 1300 ] 13 6.500% 63.500% # ( 1300, 1900 ] 15 7.500% 71.000% ## ( 1900, 2900 ] 25 12.500% 83.500% ### ( 2900, 4400 ] 21 10.500% 94.000% ## ( 4400, 6600 ] 9 4.500% 98.500% # ( 6600, 9900 ] 3 1.500% 100.000% ** DB Stats ** Uptime(secs): 56.0 total, 3.1 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 175.62 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:28.659 H:M:S, 51.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.46 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.448 H:M:S, 14.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.576 micros/op 179342 ops/sec 60.086 seconds 10775999 operations; 173.8 MB/s Microseconds per write: Count: 10775999 Average: 5.5759 StdDev: 519.27 Min: 0 Median: 1.7343 Max: 756739 Percentiles: P50: 1.73 P75: 2.72 P99: 7.36 P99.9: 1102.31 P99.99: 2749.07 ------------------------------------------------------ [ 0, 1 ] 1443445 13.395% 13.395% ### ( 1, 2 ] 5371775 49.849% 63.244% ########## ( 2, 3 ] 1759435 16.327% 79.572% ### ( 3, 4 ] 1496033 13.883% 93.455% ### ( 4, 6 ] 570657 5.296% 98.750% # ( 6, 10 ] 79008 0.733% 99.484% ( 10, 15 ] 19820 0.184% 99.668% ( 15, 22 ] 7246 0.067% 99.735% ( 22, 34 ] 1661 0.015% 99.750% ( 34, 51 ] 262 0.002% 99.753% ( 51, 76 ] 55 0.001% 99.753% ( 76, 110 ] 7340 0.068% 99.821% ( 110, 170 ] 3187 0.030% 99.851% ( 170, 250 ] 306 0.003% 99.854% ( 250, 380 ] 74 0.001% 99.854% ( 380, 580 ] 30 0.000% 99.855% ( 580, 870 ] 24 0.000% 99.855% ( 870, 1300 ] 9005 0.084% 99.938% ( 1300, 1900 ] 25 0.000% 99.939% ( 1900, 2900 ] 6517 0.060% 99.999% ( 2900, 4400 ] 56 0.001% 100.000% ( 4400, 6600 ] 5 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 19 0.000% 100.000% ( 250000, 380000 ] 3 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 3 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 : 192810 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 : 10775999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11120830968 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 : 558 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30848609 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 : 30334854597 rocksdb.compact.write.bytes COUNT : 30134780889 rocksdb.flush.write.bytes COUNT : 11097410686 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 : 69 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 : 280 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 : 11008267264 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4580352 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 : 28844593465 rocksdb.non.last.level.read.count COUNT : 6964416 rocksdb.block.checksum.compute.count COUNT : 7347403 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.380901 P95 : 3.832214 P99 : 5.937269 P100 : 756736.000000 COUNT : 10775999 SUM : 55166377 rocksdb.compaction.times.micros P50 : 1160333.333333 P95 : 5015000.000000 P99 : 22993838.000000 P100 : 22993838.000000 COUNT : 87 SUM : 144756265 rocksdb.compaction.times.cpu_micros P50 : 937272.727273 P95 : 3810000.000000 P99 : 15040000.000000 P100 : 20608699.000000 COUNT : 87 SUM : 114113596 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 : 706.235294 P95 : 4250.000000 P99 : 30580.000000 P100 : 143432.000000 COUNT : 144 SUM : 330792 rocksdb.compaction.outfile.sync.micros P50 : 1132.467532 P95 : 79277.777778 P99 : 158150.000000 P100 : 262753.000000 COUNT : 358 SUM : 5189664 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 : 117.297297 P95 : 1916.666667 P99 : 5287.333333 P100 : 18061.000000 COUNT : 279 SUM : 142659 rocksdb.table.open.io.micros P50 : 1700.000000 P95 : 7994.516129 P99 : 12165.250000 P100 : 17878.000000 COUNT : 558 SUM : 1330921 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.625534 P95 : 8.082788 P99 : 12.541621 P100 : 30761.000000 COUNT : 7345946 SUM : 52769128 rocksdb.read.block.get.micros P50 : 509.914530 P95 : 3780.000000 P99 : 6078.769231 P100 : 7948.000000 COUNT : 1116 SUM : 1086734 rocksdb.write.raw.block.micros P50 : 0.514303 P95 : 0.977175 P99 : 2.869698 P100 : 40453.000000 COUNT : 9986311 SUM : 22193987 rocksdb.numfiles.in.singlecompaction P50 : 3.147436 P95 : 5.566667 P99 : 20.145000 P100 : 27.000000 COUNT : 153 SUM : 563 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.562756 P95 : 1278.215438 P99 : 2689.853282 P100 : 756539.000000 COUNT : 139470 SUM : 30857209 rocksdb.sst.read.micros P50 : 1.575303 P95 : 4.839271 P99 : 9.045635 P100 : 30757.000000 COUNT : 6964848 SUM : 36153556 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 : 10775999 SUM : 11120830968 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 : 216666.666667 P95 : 502444.444444 P99 : 936544.000000 P100 : 936544.000000 COUNT : 144 SUM : 33890530 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 : 354 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