[2024-12-14 17:59:58.044076] Starting SPDK v24.01.1-pre git sha1 c13c99a5e / DPDK 23.11.0 initialization... [2024-12-14 17:59:58.044227] [ 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_pid953884 ] Set seed to 1734195598040611 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-14 17:59:58.146017] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-14 17:59:58.184247] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-14 17:59:58.184294] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 953884' to capture a snapshot of events at runtime. [2024-12-14 17:59:58.184306] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid953884 for offline analysis/debug. [2024-12-14 17:59:58.184330] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 14 18:00:02 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/14-18:00:05 ... thread 0: (1000000,1000000) ops and (358953.3,358953.3) ops/second in (2.785878,2.785878) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 567.01 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 351.9 2.33 2.09 12 0.194 0 0 0.0 0.0 L2 3/2 251.76 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.1 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 10/0 804.37 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.75 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 1182/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 98.5 311.8 3.84 3.56 14 0.274 383K 203 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.1 1.5 98.5 311.8 3.84 3.56 14 0.274 383K 203 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 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 351.9 2.33 2.09 12 0.194 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.17 GB write, 397.86 MB/s write, 0.37 GB read, 125.65 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 429.21 MB/s write, 0.37 GB read, 135.56 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 100299 Average: 1.8448 StdDev: 18.09 Min: 0 Median: 1.1856 Max: 3205 Percentiles: P50: 1.19 P75: 1.63 P99: 3.77 P99.9: 8.63 P99.99: 275.22 ------------------------------------------------------ [ 0, 1 ] 39782 39.663% 39.663% ######## ( 1, 2 ] 55873 55.706% 95.370% ########### ( 2, 3 ] 2834 2.826% 98.195% # ( 3, 4 ] 1052 1.049% 99.244% ( 4, 6 ] 558 0.556% 99.801% ( 6, 10 ] 153 0.153% 99.953% ( 10, 15 ] 14 0.014% 99.967% ( 15, 22 ] 3 0.003% 99.970% ( 22, 34 ] 4 0.004% 99.974% ( 34, 51 ] 2 0.002% 99.976% ( 51, 76 ] 1 0.001% 99.977% ( 110, 170 ] 8 0.008% 99.985% ( 170, 250 ] 5 0.005% 99.990% ( 250, 380 ] 5 0.005% 99.995% ( 580, 870 ] 2 0.002% 99.997% ( 1300, 1900 ] 1 0.001% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 2 0.002% 100.001% ** Level 2 read latency histogram (micros): Count: 48083 Average: 2.1047 StdDev: 26.98 Min: 0 Median: 1.2285 Max: 4121 Percentiles: P50: 1.23 P75: 1.67 P99: 5.08 P99.9: 10.00 P99.99: 1338.34 ------------------------------------------------------ [ 0, 1 ] 17861 37.146% 37.146% ####### ( 1, 2 ] 27046 56.249% 93.395% ########### ( 2, 3 ] 1578 3.282% 96.677% # ( 3, 4 ] 829 1.724% 98.401% ( 4, 6 ] 536 1.115% 99.515% ( 6, 10 ] 185 0.385% 99.900% ( 10, 15 ] 19 0.040% 99.940% ( 15, 22 ] 8 0.017% 99.956% ( 22, 34 ] 3 0.006% 99.963% ( 51, 76 ] 2 0.004% 99.967% ( 110, 170 ] 2 0.004% 99.971% ( 170, 250 ] 1 0.002% 99.973% ( 250, 380 ] 4 0.008% 99.981% ( 380, 580 ] 1 0.002% 99.983% ( 580, 870 ] 2 0.004% 99.988% ( 870, 1300 ] 1 0.002% 99.990% ( 1300, 1900 ] 3 0.006% 99.996% ( 1900, 2900 ] 1 0.002% 99.998% ( 2900, 4400 ] 1 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 40 Average: 1597.3500 StdDev: 1094.46 Min: 182 Median: 1300.0000 Max: 3826 Percentiles: P50: 1300.00 P75: 2483.33 P99: 3826.00 P99.9: 3826.00 P99.99: 3826.00 ------------------------------------------------------ ( 170, 250 ] 2 5.000% 5.000% # ( 250, 380 ] 2 5.000% 10.000% # ( 380, 580 ] 5 12.500% 22.500% ### ( 580, 870 ] 6 15.000% 37.500% ### ( 870, 1300 ] 5 12.500% 50.000% ### ( 1300, 1900 ] 3 7.500% 57.500% ## ( 1900, 2900 ] 12 30.000% 87.500% ###### ( 2900, 4400 ] 5 12.500% 100.000% ### ** Level 4 read latency histogram (micros): Count: 30 Average: 1726.2333 StdDev: 1129.33 Min: 280 Median: 1500.0000 Max: 4857 Percentiles: P50: 1500.00 P75: 2511.11 P99: 4857.00 P99.9: 4857.00 P99.99: 4857.00 ------------------------------------------------------ ( 250, 380 ] 1 3.333% 3.333% # ( 380, 580 ] 3 10.000% 13.333% ## ( 580, 870 ] 4 13.333% 26.667% ### ( 870, 1300 ] 6 20.000% 46.667% #### ( 1300, 1900 ] 3 10.000% 56.667% ## ( 1900, 2900 ] 9 30.000% 86.667% ###### ( 2900, 4400 ] 3 10.000% 96.667% ## ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 327.18 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.213 H:M:S, 7.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 352.92 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.213 H:M:S, 7.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-18:00:08 ... thread 0: (1000000,2000000) ops and (319256.9,337943.3) ops/second in (3.132274,5.918152) 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.17 GB 18.9 0.6 0.0 0.6 2.3 1.8 0.0 1.3 76.1 321.3 7.45 6.84 28 0.266 575K 603 0.0 0.0 L1 1/1 3.13 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 237.2 236.8 1.59 1.54 1 1.593 383K 579 0.0 0.0 L2 2/1 54.38 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 20/10 1.12 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 222.9 222.9 1.12 1.05 1 1.120 253K 0 0.0 0.0 L4 170/0 9.45 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 157.1 157.2 1.43 1.04 1 1.431 228K 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/21 97.92 GB 0.0 1.8 1.0 0.7 3.5 2.8 1.5 2.0 137.2 276.5 13.10 11.93 33 0.397 1825K 1385 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.5 2.8 1.4 2.0 137.2 276.5 13.10 11.93 33 0.397 1825K 1385 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 1.0 0.7 1.8 1.0 0.0 0.0 228.8 228.6 7.86 7.26 7 1.123 1825K 1385 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 348.2 5.25 4.68 26 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.54 GB write, 590.05 MB/s write, 1.76 GB read, 292.75 MB/s read, 13.1 seconds Interval compaction: 3.54 GB write, 611.95 MB/s write, 1.76 GB read, 303.62 MB/s read, 13.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 385038 Average: 2.1537 StdDev: 11.73 Min: 0 Median: 1.4542 Max: 3205 Percentiles: P50: 1.45 P75: 1.85 P99: 5.57 P99.9: 9.52 P99.99: 14.56 ------------------------------------------------------ [ 0, 1 ] 82249 21.361% 21.361% #### ( 1, 2 ] 242794 63.057% 84.418% ############# ( 2, 3 ] 33010 8.573% 92.992% ## ( 3, 4 ] 15394 3.998% 96.990% # ( 4, 6 ] 9845 2.557% 99.547% # ( 6, 10 ] 1546 0.402% 99.948% ( 10, 15 ] 177 0.046% 99.994% ( 15, 22 ] 17 0.004% 99.998% ( 22, 34 ] 10 0.003% 100.001% ( 34, 51 ] 4 0.001% 100.002% ( 51, 76 ] 4 0.001% 100.003% ( 110, 170 ] 12 0.003% 100.006% ( 170, 250 ] 13 0.003% 100.010% ( 250, 380 ] 11 0.003% 100.012% ( 380, 580 ] 3 0.001% 100.013% ( 580, 870 ] 6 0.002% 100.015% ( 870, 1300 ] 3 0.001% 100.016% ( 1300, 1900 ] 3 0.001% 100.016% ( 1900, 2900 ] 3 0.001% 100.017% ( 2900, 4400 ] 2 0.001% 100.018% ** Level 1 read latency histogram (micros): Count: 26 Average: 171.6923 StdDev: 318.06 Min: 1 Median: 1.6364 Max: 1268 Percentiles: P50: 1.64 P75: 210.00 P99: 1188.20 P99.9: 1268.00 P99.99: 1268.00 ------------------------------------------------------ [ 0, 1 ] 6 23.077% 23.077% ##### ( 1, 2 ] 11 42.308% 65.385% ######## ( 4, 6 ] 1 3.846% 69.231% # ( 110, 170 ] 1 3.846% 73.077% # ( 170, 250 ] 1 3.846% 76.923% # ( 250, 380 ] 1 3.846% 80.769% # ( 380, 580 ] 1 3.846% 84.615% # ( 580, 870 ] 3 11.538% 96.154% ## ( 870, 1300 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95724 Average: 2.1238 StdDev: 19.14 Min: 0 Median: 1.3734 Max: 4121 Percentiles: P50: 1.37 P75: 1.78 P99: 5.53 P99.9: 10.34 P99.99: 361.40 ------------------------------------------------------ [ 0, 1 ] 26116 27.283% 27.283% ##### ( 1, 2 ] 58239 60.841% 88.123% ############ ( 2, 3 ] 5875 6.137% 94.261% # ( 3, 4 ] 3042 3.178% 97.438% # ( 4, 6 ] 1948 2.035% 99.473% ( 6, 10 ] 404 0.422% 99.896% ( 10, 15 ] 63 0.066% 99.961% ( 15, 22 ] 16 0.017% 99.978% ( 22, 34 ] 3 0.003% 99.981% ( 51, 76 ] 2 0.002% 99.983% ( 110, 170 ] 2 0.002% 99.985% ( 170, 250 ] 1 0.001% 99.986% ( 250, 380 ] 4 0.004% 99.991% ( 380, 580 ] 1 0.001% 99.992% ( 580, 870 ] 2 0.002% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 3 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 179693 Average: 3.2677 StdDev: 33.77 Min: 1 Median: 1.5949 Max: 4123 Percentiles: P50: 1.59 P75: 2.00 P99: 8.83 P99.9: 156.58 P99.99: 474.90 ------------------------------------------------------ [ 0, 1 ] 23815 13.253% 13.253% ### ( 1, 2 ] 111002 61.773% 75.026% ############ ( 2, 3 ] 23552 13.107% 88.133% ### ( 3, 4 ] 9738 5.419% 93.552% # ( 4, 6 ] 7884 4.387% 97.940% # ( 6, 10 ] 2696 1.500% 99.440% ( 10, 15 ] 469 0.261% 99.701% ( 15, 22 ] 94 0.052% 99.753% ( 22, 34 ] 31 0.017% 99.771% ( 34, 51 ] 9 0.005% 99.776% ( 51, 76 ] 1 0.001% 99.776% ( 76, 110 ] 81 0.045% 99.821% ( 110, 170 ] 182 0.101% 99.923% ( 170, 250 ] 65 0.036% 99.959% ( 250, 380 ] 38 0.021% 99.980% ( 380, 580 ] 38 0.021% 100.001% ( 580, 870 ] 21 0.012% 100.013% ( 870, 1300 ] 9 0.005% 100.018% ( 1300, 1900 ] 7 0.004% 100.022% ( 1900, 2900 ] 12 0.007% 100.028% ( 2900, 4400 ] 6 0.003% 100.032% ** Level 4 read latency histogram (micros): Count: 320 Average: 166.9250 StdDev: 609.43 Min: 0 Median: 1.5567 Max: 4857 Percentiles: P50: 1.56 P75: 7.05 P99: 3300.00 P99.9: 4857.00 P99.99: 4857.00 ------------------------------------------------------ [ 0, 1 ] 106 33.125% 33.125% ####### ( 1, 2 ] 97 30.312% 63.438% ###### ( 2, 3 ] 22 6.875% 70.312% # ( 3, 4 ] 2 0.625% 70.938% ( 4, 6 ] 3 0.938% 71.875% ( 6, 10 ] 38 11.875% 83.750% ## ( 10, 15 ] 17 5.312% 89.062% # ( 76, 110 ] 1 0.312% 89.375% ( 110, 170 ] 3 0.938% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 250, 380 ] 1 0.312% 90.938% ( 380, 580 ] 3 0.938% 91.875% ( 580, 870 ] 4 1.250% 93.125% ( 870, 1300 ] 6 1.875% 95.000% ( 1300, 1900 ] 3 0.938% 95.938% ( 1900, 2900 ] 9 2.812% 98.750% # ( 2900, 4400 ] 3 0.938% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 729.8500 StdDev: 718.91 Min: 143 Median: 380.0000 Max: 2569 Percentiles: P50: 380.00 P75: 1085.00 P99: 2569.00 P99.9: 2569.00 P99.99: 2569.00 ------------------------------------------------------ ( 110, 170 ] 2 10.000% 10.000% ## ( 170, 250 ] 5 25.000% 35.000% ##### ( 250, 380 ] 3 15.000% 50.000% ### ( 380, 580 ] 2 10.000% 60.000% ## ( 580, 870 ] 2 10.000% 70.000% ## ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 320.56 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.673 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.20 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.461 H:M:S, 14.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/14-18:00:11 ... thread 0: (1000000,3000000) ops and (326812.0,334149.6) ops/second in (3.059863,8.978015) 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/4 1.41 GB 113.3 1.4 0.0 1.4 4.1 2.8 0.0 1.5 103.2 314.2 13.43 12.44 45 0.298 1407K 1476 0.0 0.0 L1 3/0 242.77 MB 24.3 1.1 1.1 0.0 1.1 1.1 0.2 1.0 236.6 236.0 4.80 4.66 2 2.401 1153K 2683 0.0 0.0 L2 4/3 513.50 MB 1.3 0.4 0.2 0.2 0.4 0.2 0.9 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 19/2 945.79 MB 0.8 1.1 0.3 0.8 1.1 0.3 0.4 3.7 226.5 226.1 5.00 4.58 3 1.668 1151K 2172 0.0 0.0 L4 174/0 9.70 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 157.1 157.2 1.43 1.04 1 1.431 228K 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1259/9 98.90 GB 0.0 4.2 1.8 2.4 6.9 4.6 2.2 2.5 162.7 270.7 26.18 24.19 53 0.494 4324K 6534 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 1.8 2.4 6.9 4.6 2.1 2.5 162.7 270.7 26.18 24.19 53 0.494 4324K 6534 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.2 1.8 2.4 4.2 1.8 0.0 0.0 235.2 234.9 18.10 17.00 13 1.393 4324K 6534 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 351.1 8.07 7.19 40 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.92 GB write, 770.30 MB/s write, 4.16 GB read, 462.89 MB/s read, 26.2 seconds Interval compaction: 6.92 GB write, 789.15 MB/s write, 4.16 GB read, 474.22 MB/s read, 26.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 746791 Average: 2.2106 StdDev: 11.30 Min: 0 Median: 1.4957 Max: 3571 Percentiles: P50: 1.50 P75: 1.88 P99: 5.64 P99.9: 9.46 P99.99: 13.76 ------------------------------------------------------ [ 0, 1 ] 134454 18.004% 18.004% #### ( 1, 2 ] 482032 64.547% 82.551% ############# ( 2, 3 ] 71258 9.542% 92.093% ## ( 3, 4 ] 33479 4.483% 96.576% # ( 4, 6 ] 22087 2.958% 99.534% # ( 6, 10 ] 3163 0.424% 99.957% ( 10, 15 ] 325 0.044% 100.001% ( 15, 22 ] 47 0.006% 100.007% ( 22, 34 ] 14 0.002% 100.009% ( 34, 51 ] 7 0.001% 100.010% ( 51, 76 ] 8 0.001% 100.011% ( 110, 170 ] 16 0.002% 100.013% ( 170, 250 ] 22 0.003% 100.016% ( 250, 380 ] 17 0.002% 100.018% ( 380, 580 ] 4 0.001% 100.019% ( 580, 870 ] 9 0.001% 100.020% ( 870, 1300 ] 7 0.001% 100.021% ( 1300, 1900 ] 7 0.001% 100.022% ( 1900, 2900 ] 4 0.001% 100.023% ( 2900, 4400 ] 4 0.001% 100.023% ** Level 1 read latency histogram (micros): Count: 81982 Average: 3.4286 StdDev: 22.17 Min: 1 Median: 1.6919 Max: 1743 Percentiles: P50: 1.69 P75: 2.40 P99: 8.50 P99.9: 155.33 P99.99: 293.84 ------------------------------------------------------ [ 0, 1 ] 6393 7.798% 7.798% ## ( 1, 2 ] 50003 60.993% 68.791% ############ ( 2, 3 ] 12631 15.407% 84.198% ### ( 3, 4 ] 6123 7.469% 91.666% # ( 4, 6 ] 5288 6.450% 98.117% # ( 6, 10 ] 1160 1.415% 99.532% ( 10, 15 ] 219 0.267% 99.799% ( 15, 22 ] 38 0.046% 99.845% ( 22, 34 ] 7 0.009% 99.854% ( 34, 51 ] 1 0.001% 99.855% ( 76, 110 ] 1 0.001% 99.856% ( 110, 170 ] 49 0.060% 99.916% ( 170, 250 ] 50 0.061% 99.977% ( 250, 380 ] 35 0.043% 100.020% ( 380, 580 ] 33 0.040% 100.060% ( 580, 870 ] 23 0.028% 100.088% ( 870, 1300 ] 8 0.010% 100.098% ( 1300, 1900 ] 3 0.004% 100.101% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 239414 Average: 3.2993 StdDev: 30.90 Min: 0 Median: 1.5927 Max: 4123 Percentiles: P50: 1.59 P75: 1.99 P99: 8.93 P99.9: 183.74 P99.99: 545.88 ------------------------------------------------------ [ 0, 1 ] 31407 13.118% 13.118% ### ( 1, 2 ] 148971 62.223% 75.341% ############ ( 2, 3 ] 30309 12.660% 88.001% ### ( 3, 4 ] 13303 5.556% 93.558% # ( 4, 6 ] 10313 4.308% 97.865% # ( 6, 10 ] 3705 1.548% 99.413% ( 10, 15 ] 599 0.250% 99.663% ( 15, 22 ] 112 0.047% 99.710% ( 22, 34 ] 31 0.013% 99.723% ( 34, 51 ] 11 0.005% 99.727% ( 51, 76 ] 1 0.000% 99.728% ( 76, 110 ] 99 0.041% 99.769% ( 110, 170 ] 294 0.123% 99.892% ( 170, 250 ] 114 0.048% 99.939% ( 250, 380 ] 63 0.026% 99.966% ( 380, 580 ] 70 0.029% 99.995% ( 580, 870 ] 31 0.013% 100.008% ( 870, 1300 ] 13 0.005% 100.013% ( 1300, 1900 ] 7 0.003% 100.016% ( 1900, 2900 ] 12 0.005% 100.021% ( 2900, 4400 ] 6 0.003% 100.024% ** Level 4 read latency histogram (micros): Count: 320 Average: 166.9250 StdDev: 609.43 Min: 0 Median: 1.5567 Max: 4857 Percentiles: P50: 1.56 P75: 7.05 P99: 3300.00 P99.9: 4857.00 P99.99: 4857.00 ------------------------------------------------------ [ 0, 1 ] 106 33.125% 33.125% ####### ( 1, 2 ] 97 30.312% 63.438% ###### ( 2, 3 ] 22 6.875% 70.312% # ( 3, 4 ] 2 0.625% 70.938% ( 4, 6 ] 3 0.938% 71.875% ( 6, 10 ] 38 11.875% 83.750% ## ( 10, 15 ] 17 5.312% 89.062% # ( 76, 110 ] 1 0.312% 89.375% ( 110, 170 ] 3 0.938% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 250, 380 ] 1 0.312% 90.938% ( 380, 580 ] 3 0.938% 91.875% ( 580, 870 ] 4 1.250% 93.125% ( 870, 1300 ] 6 1.875% 95.000% ( 1300, 1900 ] 3 0.938% 95.938% ( 1900, 2900 ] 9 2.812% 98.750% # ( 2900, 4400 ] 3 0.938% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 729.8500 StdDev: 718.91 Min: 143 Median: 380.0000 Max: 2569 Percentiles: P50: 380.00 P75: 1085.00 P99: 2569.00 P99.9: 2569.00 P99.99: 2569.00 ------------------------------------------------------ ( 110, 170 ] 2 10.000% 10.000% ## ( 170, 250 ] 5 25.000% 35.000% ##### ( 250, 380 ] 3 15.000% 50.000% ### ( 380, 580 ] 2 10.000% 60.000% ## ( 580, 870 ] 2 10.000% 70.000% ## ( 870, 1300 ] 2 10.000% 80.000% ## ( 1300, 1900 ] 1 5.000% 85.000% # ( 1900, 2900 ] 3 15.000% 100.000% ### ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 320.92 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.060 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.65 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.387 H:M:S, 12.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/14-18:00:14 ... thread 0: (1000000,4000000) ops and (330050.1,333115.2) ops/second in (3.029843,12.007858) 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/8 2.34 GB 182.5 2.2 0.0 2.2 5.9 3.7 0.0 1.6 116.8 311.2 19.42 18.10 61 0.318 2302K 2463 0.0 0.0 L1 3/0 242.77 MB 24.3 1.1 1.1 0.0 1.1 1.1 0.2 1.0 236.6 236.0 4.80 4.66 2 2.401 1153K 2683 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 24/0 942.15 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.4 2.5 224.2 223.7 9.01 8.38 6 1.502 2052K 4139 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 157.1 157.2 1.43 1.04 1 1.431 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/8 99.82 GB 0.0 5.9 2.3 3.6 9.6 6.0 3.3 2.6 166.6 270.8 36.18 33.64 72 0.503 6121K 9488 0.0 0.0 Int 0/0 0.00 KB 0.0 5.9 2.3 3.6 9.6 6.0 3.2 2.6 166.6 270.8 36.18 33.64 72 0.503 6121K 9488 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.9 2.3 3.6 5.9 2.3 0.0 0.0 236.7 236.3 25.47 24.10 19 1.341 6121K 9488 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 352.9 10.71 9.54 53 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.2 total, 12.0 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.57 GB write, 801.18 MB/s write, 5.89 GB read, 492.91 MB/s read, 36.2 seconds Interval compaction: 9.57 GB write, 815.84 MB/s write, 5.89 GB read, 501.93 MB/s read, 36.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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 996774 Average: 2.1896 StdDev: 11.74 Min: 0 Median: 1.4802 Max: 3571 Percentiles: P50: 1.48 P75: 1.87 P99: 5.61 P99.9: 9.47 P99.99: 14.25 ------------------------------------------------------ [ 0, 1 ] 191285 19.190% 19.190% #### ( 1, 2 ] 639567 64.164% 83.354% ############# ( 2, 3 ] 90209 9.050% 92.404% ## ( 3, 4 ] 42996 4.314% 96.718% # ( 4, 6 ] 28185 2.828% 99.545% # ( 6, 10 ] 4077 0.409% 99.954% ( 10, 15 ] 423 0.042% 99.997% ( 15, 22 ] 80 0.008% 100.005% ( 22, 34 ] 15 0.002% 100.006% ( 34, 51 ] 9 0.001% 100.007% ( 51, 76 ] 9 0.001% 100.008% ( 110, 170 ] 23 0.002% 100.010% ( 170, 250 ] 26 0.003% 100.013% ( 250, 380 ] 21 0.002% 100.015% ( 380, 580 ] 9 0.001% 100.016% ( 580, 870 ] 13 0.001% 100.017% ( 870, 1300 ] 10 0.001% 100.018% ( 1300, 1900 ] 8 0.001% 100.019% ( 1900, 2900 ] 7 0.001% 100.020% ( 2900, 4400 ] 5 0.001% 100.020% ** Level 1 read latency histogram (micros): Count: 225960 Average: 2.7945 StdDev: 14.01 Min: 1 Median: 1.6319 Max: 1743 Percentiles: P50: 1.63 P75: 2.08 P99: 7.48 P99.9: 14.86 P99.99: 220.84 ------------------------------------------------------ [ 0, 1 ] 20397 9.027% 9.027% ## ( 1, 2 ] 146511 64.839% 73.866% ############# ( 2, 3 ] 31057 13.744% 87.611% ### ( 3, 4 ] 13700 6.063% 93.674% # ( 4, 6 ] 11081 4.904% 98.578% # ( 6, 10 ] 2582 1.143% 99.720% ( 10, 15 ] 418 0.185% 99.905% ( 15, 22 ] 58 0.026% 99.931% ( 22, 34 ] 7 0.003% 99.934% ( 34, 51 ] 2 0.001% 99.935% ( 51, 76 ] 1 0.000% 99.935% ( 76, 110 ] 21 0.009% 99.945% ( 110, 170 ] 63 0.028% 99.973% ( 170, 250 ] 62 0.027% 100.000% ( 250, 380 ] 43 0.019% 100.019% ( 380, 580 ] 42 0.019% 100.038% ( 580, 870 ] 25 0.011% 100.049% ( 870, 1300 ] 8 0.004% 100.052% ( 1300, 1900 ] 3 0.001% 100.054% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 252778 Average: 3.3024 StdDev: 30.28 Min: 0 Median: 1.6027 Max: 4123 Percentiles: P50: 1.60 P75: 2.03 P99: 8.92 P99.9: 186.54 P99.99: 549.52 ------------------------------------------------------ [ 0, 1 ] 31911 12.624% 12.624% ### ( 1, 2 ] 156770 62.019% 74.643% ############ ( 2, 3 ] 32804 12.977% 87.620% ### ( 3, 4 ] 14458 5.720% 93.340% # ( 4, 6 ] 11487 4.544% 97.884% # ( 6, 10 ] 3869 1.531% 99.415% ( 10, 15 ] 631 0.250% 99.665% ( 15, 22 ] 120 0.047% 99.712% ( 22, 34 ] 32 0.013% 99.725% ( 34, 51 ] 12 0.005% 99.729% ( 51, 76 ] 1 0.000% 99.730% ( 76, 110 ] 100 0.040% 99.769% ( 110, 170 ] 305 0.121% 99.890% ( 170, 250 ] 122 0.048% 99.938% ( 250, 380 ] 68 0.027% 99.965% ( 380, 580 ] 74 0.029% 99.994% ( 580, 870 ] 32 0.013% 100.007% ( 870, 1300 ] 14 0.006% 100.013% ( 1300, 1900 ] 7 0.003% 100.015% ( 1900, 2900 ] 12 0.005% 100.020% ( 2900, 4400 ] 6 0.002% 100.023% ** Level 4 read latency histogram (micros): Count: 320 Average: 166.9250 StdDev: 609.43 Min: 0 Median: 1.5567 Max: 4857 Percentiles: P50: 1.56 P75: 7.05 P99: 3300.00 P99.9: 4857.00 P99.99: 4857.00 ------------------------------------------------------ [ 0, 1 ] 106 33.125% 33.125% ####### ( 1, 2 ] 97 30.312% 63.438% ###### ( 2, 3 ] 22 6.875% 70.312% # ( 3, 4 ] 2 0.625% 70.938% ( 4, 6 ] 3 0.938% 71.875% ( 6, 10 ] 38 11.875% 83.750% ## ( 10, 15 ] 17 5.312% 89.062% # ( 76, 110 ] 1 0.312% 89.375% ( 110, 170 ] 3 0.938% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 250, 380 ] 1 0.312% 90.938% ( 380, 580 ] 3 0.938% 91.875% ( 580, 870 ] 4 1.250% 93.125% ( 870, 1300 ] 6 1.875% 95.000% ( 1300, 1900 ] 3 0.938% 95.938% ( 1900, 2900 ] 9 2.812% 98.750% # ( 2900, 4400 ] 3 0.938% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 758.2667 StdDev: 810.08 Min: 77 Median: 380.0000 Max: 3015 Percentiles: P50: 380.00 P75: 1042.00 P99: 3015.00 P99.9: 3015.00 P99.99: 3015.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 8 13.333% 21.667% ### ( 170, 250 ] 10 16.667% 38.333% ### ( 250, 380 ] 7 11.667% 50.000% ## ( 380, 580 ] 6 10.000% 60.000% ## ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 5 8.333% 80.000% ## ( 1300, 1900 ] 1 1.667% 81.667% ( 1900, 2900 ] 10 16.667% 98.333% ### ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.2 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 321.89 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.460 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.83 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.400 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/14-18:00:17 ... thread 0: (1000000,5000000) ops and (332677.8,333027.6) ops/second in (3.005911,15.013769) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/14 3.32 GB 18.9 3.3 0.0 3.3 8.0 4.7 0.0 1.7 128.6 309.3 26.46 24.77 79 0.335 3454K 3673 0.0 0.0 L1 3/3 242.77 MB 0.0 1.1 1.1 0.0 1.1 1.1 0.2 1.0 236.6 236.0 4.80 4.66 2 2.401 1153K 2683 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 24/0 942.15 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.4 2.5 224.2 223.7 9.01 8.38 6 1.502 2052K 4139 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 157.1 157.2 1.43 1.04 1 1.431 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1274/17 100.80 GB 0.0 7.0 2.3 4.7 11.7 7.0 3.3 2.5 165.7 276.2 43.22 40.31 90 0.480 7272K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 2.3 4.7 11.7 7.0 3.2 2.5 165.7 276.2 43.22 40.31 90 0.480 7272K 10K 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.3 4.7 7.0 2.3 0.0 0.0 241.0 240.6 29.72 28.26 23 1.292 7272K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 354.6 13.50 12.04 67 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.2 total, 15.0 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.66 GB write, 783.61 MB/s write, 6.99 GB read, 470.09 MB/s read, 43.2 seconds Interval compaction: 11.66 GB write, 795.08 MB/s write, 6.99 GB read, 476.97 MB/s read, 43.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: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 17, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1243029 Average: 2.1749 StdDev: 12.96 Min: 0 Median: 1.4451 Max: 3571 Percentiles: P50: 1.45 P75: 1.84 P99: 5.54 P99.9: 9.69 P99.99: 111.03 ------------------------------------------------------ [ 0, 1 ] 268989 21.640% 21.640% #### ( 1, 2 ] 791968 63.713% 85.353% ############# ( 2, 3 ] 99317 7.990% 93.342% ## ( 3, 4 ] 47246 3.801% 97.143% # ( 4, 6 ] 29997 2.413% 99.557% ( 6, 10 ] 4630 0.372% 99.929% ( 10, 15 ] 501 0.040% 99.969% ( 15, 22 ] 99 0.008% 99.977% ( 22, 34 ] 17 0.001% 99.979% ( 34, 51 ] 10 0.001% 99.979% ( 51, 76 ] 16 0.001% 99.981% ( 76, 110 ] 113 0.009% 99.990% ( 110, 170 ] 157 0.013% 100.002% ( 170, 250 ] 55 0.004% 100.007% ( 250, 380 ] 35 0.003% 100.010% ( 380, 580 ] 27 0.002% 100.012% ( 580, 870 ] 22 0.002% 100.014% ( 870, 1300 ] 16 0.001% 100.015% ( 1300, 1900 ] 9 0.001% 100.016% ( 1900, 2900 ] 10 0.001% 100.016% ( 2900, 4400 ] 8 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 225961 Average: 2.7962 StdDev: 14.03 Min: 1 Median: 1.6319 Max: 1743 Percentiles: P50: 1.63 P75: 2.08 P99: 7.48 P99.9: 14.87 P99.99: 222.13 ------------------------------------------------------ [ 0, 1 ] 20397 9.027% 9.027% ## ( 1, 2 ] 146511 64.839% 73.866% ############# ( 2, 3 ] 31057 13.744% 87.610% ### ( 3, 4 ] 13700 6.063% 93.673% # ( 4, 6 ] 11081 4.904% 98.577% # ( 6, 10 ] 2582 1.143% 99.720% ( 10, 15 ] 418 0.185% 99.905% ( 15, 22 ] 58 0.026% 99.931% ( 22, 34 ] 7 0.003% 99.934% ( 34, 51 ] 2 0.001% 99.935% ( 51, 76 ] 1 0.000% 99.935% ( 76, 110 ] 21 0.009% 99.944% ( 110, 170 ] 63 0.028% 99.972% ( 170, 250 ] 62 0.027% 100.000% ( 250, 380 ] 44 0.019% 100.019% ( 380, 580 ] 42 0.019% 100.038% ( 580, 870 ] 25 0.011% 100.049% ( 870, 1300 ] 8 0.004% 100.052% ( 1300, 1900 ] 3 0.001% 100.054% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 252778 Average: 3.3024 StdDev: 30.28 Min: 0 Median: 1.6027 Max: 4123 Percentiles: P50: 1.60 P75: 2.03 P99: 8.92 P99.9: 186.54 P99.99: 549.52 ------------------------------------------------------ [ 0, 1 ] 31911 12.624% 12.624% ### ( 1, 2 ] 156770 62.019% 74.643% ############ ( 2, 3 ] 32804 12.977% 87.620% ### ( 3, 4 ] 14458 5.720% 93.340% # ( 4, 6 ] 11487 4.544% 97.884% # ( 6, 10 ] 3869 1.531% 99.415% ( 10, 15 ] 631 0.250% 99.665% ( 15, 22 ] 120 0.047% 99.712% ( 22, 34 ] 32 0.013% 99.725% ( 34, 51 ] 12 0.005% 99.729% ( 51, 76 ] 1 0.000% 99.730% ( 76, 110 ] 100 0.040% 99.769% ( 110, 170 ] 305 0.121% 99.890% ( 170, 250 ] 122 0.048% 99.938% ( 250, 380 ] 68 0.027% 99.965% ( 380, 580 ] 74 0.029% 99.994% ( 580, 870 ] 32 0.013% 100.007% ( 870, 1300 ] 14 0.006% 100.013% ( 1300, 1900 ] 7 0.003% 100.015% ( 1900, 2900 ] 12 0.005% 100.020% ( 2900, 4400 ] 6 0.002% 100.023% ** Level 4 read latency histogram (micros): Count: 320 Average: 166.9250 StdDev: 609.43 Min: 0 Median: 1.5567 Max: 4857 Percentiles: P50: 1.56 P75: 7.05 P99: 3300.00 P99.9: 4857.00 P99.99: 4857.00 ------------------------------------------------------ [ 0, 1 ] 106 33.125% 33.125% ####### ( 1, 2 ] 97 30.312% 63.438% ###### ( 2, 3 ] 22 6.875% 70.312% # ( 3, 4 ] 2 0.625% 70.938% ( 4, 6 ] 3 0.938% 71.875% ( 6, 10 ] 38 11.875% 83.750% ## ( 10, 15 ] 17 5.312% 89.062% # ( 76, 110 ] 1 0.312% 89.375% ( 110, 170 ] 3 0.938% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 250, 380 ] 1 0.312% 90.938% ( 380, 580 ] 3 0.938% 91.875% ( 580, 870 ] 4 1.250% 93.125% ( 870, 1300 ] 6 1.875% 95.000% ( 1300, 1900 ] 3 0.938% 95.938% ( 1900, 2900 ] 9 2.812% 98.750% # ( 2900, 4400 ] 3 0.938% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 758.2667 StdDev: 810.08 Min: 77 Median: 380.0000 Max: 3015 Percentiles: P50: 380.00 P75: 1042.00 P99: 3015.00 P99.9: 3015.00 P99.99: 3015.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 8 13.333% 21.667% ### ( 170, 250 ] 10 16.667% 38.333% ### ( 250, 380 ] 7 11.667% 50.000% ## ( 380, 580 ] 6 10.000% 60.000% ## ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 5 8.333% 80.000% ## ( 1300, 1900 ] 1 1.667% 81.667% ( 1900, 2900 ] 10 16.667% 98.333% ### ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.2 total, 3.0 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 322.98 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.882 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, 327.42 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.423 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/14-18:00:25 ... thread 0: (1000000,6000000) ops and (118490.8,255828.1) ops/second in (8.439475,23.453244) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 4.36 GB 125.6 5.2 0.0 5.2 10.9 5.7 0.0 1.9 146.1 305.8 36.64 34.54 100 0.366 5436K 7734 0.0 0.0 L1 3/3 242.77 MB 0.0 1.1 1.1 0.0 1.1 1.1 0.2 1.0 236.6 236.0 4.80 4.66 2 2.401 1153K 2683 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.9 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 24/0 942.15 MB 0.9 2.0 0.8 1.2 2.0 0.8 0.4 2.5 224.2 223.7 9.01 8.38 6 1.502 2052K 4139 0.0 0.0 L4 174/0 9.59 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 157.1 157.2 1.43 1.04 1 1.431 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1275/17 101.84 GB 0.0 8.9 2.3 6.6 14.6 8.0 3.3 2.6 170.7 280.1 53.40 50.08 111 0.481 9254K 14K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.9 2.3 6.6 14.6 8.0 3.2 2.6 170.7 280.1 53.40 50.08 111 0.481 9254K 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 8.9 2.3 6.6 8.9 2.3 0.0 0.0 247.1 246.7 36.89 35.33 28 1.317 9254K 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 354.9 16.51 14.75 83 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.7 total, 23.5 interval Flush(GB): cumulative 5.721, interval 5.721 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.61 GB write, 631.79 MB/s write, 8.90 GB read, 384.97 MB/s read, 53.4 seconds Interval compaction: 14.61 GB write, 637.71 MB/s write, 8.90 GB read, 388.57 MB/s read, 53.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 19, interval: 29 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2227889 Average: 2.1394 StdDev: 10.85 Min: 0 Median: 1.4364 Max: 3571 Percentiles: P50: 1.44 P75: 1.82 P99: 5.51 P99.9: 9.97 P99.99: 112.31 ------------------------------------------------------ [ 0, 1 ] 476827 21.403% 21.403% #### ( 1, 2 ] 1459911 65.529% 86.932% ############# ( 2, 3 ] 161937 7.269% 94.200% # ( 3, 4 ] 75123 3.372% 97.572% # ( 4, 6 ] 42030 1.887% 99.459% ( 6, 10 ] 9897 0.444% 99.903% ( 10, 15 ] 1118 0.050% 99.953% ( 15, 22 ] 369 0.017% 99.970% ( 22, 34 ] 26 0.001% 99.971% ( 34, 51 ] 13 0.001% 99.971% ( 51, 76 ] 25 0.001% 99.972% ( 76, 110 ] 379 0.017% 99.989% ( 110, 170 ] 317 0.014% 100.004% ( 170, 250 ] 104 0.005% 100.008% ( 250, 380 ] 64 0.003% 100.011% ( 380, 580 ] 49 0.002% 100.013% ( 580, 870 ] 38 0.002% 100.015% ( 870, 1300 ] 22 0.001% 100.016% ( 1300, 1900 ] 13 0.001% 100.017% ( 1900, 2900 ] 11 0.000% 100.017% ( 2900, 4400 ] 9 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 225961 Average: 2.7962 StdDev: 14.03 Min: 1 Median: 1.6319 Max: 1743 Percentiles: P50: 1.63 P75: 2.08 P99: 7.48 P99.9: 14.87 P99.99: 222.13 ------------------------------------------------------ [ 0, 1 ] 20397 9.027% 9.027% ## ( 1, 2 ] 146511 64.839% 73.866% ############# ( 2, 3 ] 31057 13.744% 87.610% ### ( 3, 4 ] 13700 6.063% 93.673% # ( 4, 6 ] 11081 4.904% 98.577% # ( 6, 10 ] 2582 1.143% 99.720% ( 10, 15 ] 418 0.185% 99.905% ( 15, 22 ] 58 0.026% 99.931% ( 22, 34 ] 7 0.003% 99.934% ( 34, 51 ] 2 0.001% 99.935% ( 51, 76 ] 1 0.000% 99.935% ( 76, 110 ] 21 0.009% 99.944% ( 110, 170 ] 63 0.028% 99.972% ( 170, 250 ] 62 0.027% 100.000% ( 250, 380 ] 44 0.019% 100.019% ( 380, 580 ] 42 0.019% 100.038% ( 580, 870 ] 25 0.011% 100.049% ( 870, 1300 ] 8 0.004% 100.052% ( 1300, 1900 ] 3 0.001% 100.054% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 252778 Average: 3.3024 StdDev: 30.28 Min: 0 Median: 1.6027 Max: 4123 Percentiles: P50: 1.60 P75: 2.03 P99: 8.92 P99.9: 186.54 P99.99: 549.52 ------------------------------------------------------ [ 0, 1 ] 31911 12.624% 12.624% ### ( 1, 2 ] 156770 62.019% 74.643% ############ ( 2, 3 ] 32804 12.977% 87.620% ### ( 3, 4 ] 14458 5.720% 93.340% # ( 4, 6 ] 11487 4.544% 97.884% # ( 6, 10 ] 3869 1.531% 99.415% ( 10, 15 ] 631 0.250% 99.665% ( 15, 22 ] 120 0.047% 99.712% ( 22, 34 ] 32 0.013% 99.725% ( 34, 51 ] 12 0.005% 99.729% ( 51, 76 ] 1 0.000% 99.730% ( 76, 110 ] 100 0.040% 99.769% ( 110, 170 ] 305 0.121% 99.890% ( 170, 250 ] 122 0.048% 99.938% ( 250, 380 ] 68 0.027% 99.965% ( 380, 580 ] 74 0.029% 99.994% ( 580, 870 ] 32 0.013% 100.007% ( 870, 1300 ] 14 0.006% 100.013% ( 1300, 1900 ] 7 0.003% 100.015% ( 1900, 2900 ] 12 0.005% 100.020% ( 2900, 4400 ] 6 0.002% 100.023% ** Level 4 read latency histogram (micros): Count: 320 Average: 166.9250 StdDev: 609.43 Min: 0 Median: 1.5567 Max: 4857 Percentiles: P50: 1.56 P75: 7.05 P99: 3300.00 P99.9: 4857.00 P99.99: 4857.00 ------------------------------------------------------ [ 0, 1 ] 106 33.125% 33.125% ####### ( 1, 2 ] 97 30.312% 63.438% ###### ( 2, 3 ] 22 6.875% 70.312% # ( 3, 4 ] 2 0.625% 70.938% ( 4, 6 ] 3 0.938% 71.875% ( 6, 10 ] 38 11.875% 83.750% ## ( 10, 15 ] 17 5.312% 89.062% # ( 76, 110 ] 1 0.312% 89.375% ( 110, 170 ] 3 0.938% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 250, 380 ] 1 0.312% 90.938% ( 380, 580 ] 3 0.938% 91.875% ( 580, 870 ] 4 1.250% 93.125% ( 870, 1300 ] 6 1.875% 95.000% ( 1300, 1900 ] 3 0.938% 95.938% ( 1900, 2900 ] 9 2.812% 98.750% # ( 2900, 4400 ] 3 0.938% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 758.2667 StdDev: 810.08 Min: 77 Median: 380.0000 Max: 3015 Percentiles: P50: 380.00 P75: 1042.00 P99: 3015.00 P99.9: 3015.00 P99.99: 3015.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 8 13.333% 21.667% ### ( 170, 250 ] 10 16.667% 38.333% ### ( 250, 380 ] 7 11.667% 50.000% ## ( 380, 580 ] 6 10.000% 60.000% ## ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 5 8.333% 80.000% ## ( 1300, 1900 ] 1 1.667% 81.667% ( 1900, 2900 ] 10 16.667% 98.333% ### ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 23.7 total, 8.4 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 249.42 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:7.656 H:M:S, 32.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 116.62 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.774 H:M:S, 68.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/14-18:00:34 ... thread 0: (1000000,7000000) ops and (110880.0,215570.3) ops/second in (9.018759,32.472003) 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/5 2.08 GB 25.2 6.5 0.0 6.5 13.1 6.6 0.0 2.0 147.1 295.5 45.37 41.83 116 0.391 6778K 10K 0.0 0.0 L1 19/19 1.76 GB 0.0 4.5 4.2 0.2 4.4 4.2 0.2 1.0 221.0 218.1 20.76 19.36 3 6.922 4659K 58K 0.0 0.0 L2 8/8 840.49 MB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 33/11 1.62 GB 1.0 3.1 1.5 1.6 3.1 1.5 0.4 2.0 164.1 163.4 19.51 13.89 14 1.393 3250K 13K 0.0 0.0 L4 175/1 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 157.1 157.2 1.43 1.04 1 1.431 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1299/44 102.64 GB 0.0 14.7 6.2 8.5 21.2 12.7 4.9 3.2 170.1 245.3 88.58 77.58 136 0.651 15M 82K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.7 6.2 8.5 21.2 12.7 4.8 3.2 170.1 245.3 88.58 77.58 136 0.651 15M 82K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.7 6.2 8.5 14.6 6.1 0.0 0.0 219.4 218.2 68.67 60.53 40 1.717 15M 82K 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 338.5 19.91 17.06 96 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): 32.7 total, 32.5 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.22 GB write, 664.52 MB/s write, 14.72 GB read, 460.89 MB/s read, 88.6 seconds Interval compaction: 21.22 GB write, 669.02 MB/s write, 14.72 GB read, 464.01 MB/s read, 88.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 23, interval: 39 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2916584 Average: 2.6331 StdDev: 22.75 Min: 0 Median: 1.4414 Max: 6957 Percentiles: P50: 1.44 P75: 1.82 P99: 6.01 P99.9: 142.51 P99.99: 351.81 ------------------------------------------------------ [ 0, 1 ] 617860 21.184% 21.184% #### ( 1, 2 ] 1903990 65.282% 86.466% ############# ( 2, 3 ] 211071 7.237% 93.703% # ( 3, 4 ] 98575 3.380% 97.083% # ( 4, 6 ] 55859 1.915% 98.998% ( 6, 10 ] 18166 0.623% 99.621% ( 10, 15 ] 2131 0.073% 99.694% ( 15, 22 ] 709 0.024% 99.718% ( 22, 34 ] 44 0.002% 99.720% ( 34, 51 ] 15 0.001% 99.720% ( 51, 76 ] 67 0.002% 99.722% ( 76, 110 ] 3395 0.116% 99.839% ( 110, 170 ] 3297 0.113% 99.952% ( 170, 250 ] 740 0.025% 99.977% ( 250, 380 ] 478 0.016% 99.994% ( 380, 580 ] 367 0.013% 100.006% ( 580, 870 ] 162 0.006% 100.012% ( 870, 1300 ] 76 0.003% 100.014% ( 1300, 1900 ] 37 0.001% 100.016% ( 1900, 2900 ] 33 0.001% 100.017% ( 2900, 4400 ] 34 0.001% 100.018% ( 4400, 6600 ] 13 0.000% 100.018% ( 6600, 9900 ] 1 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 577084 Average: 5.4003 StdDev: 78.40 Min: 0 Median: 1.7475 Max: 10454 Percentiles: P50: 1.75 P75: 2.66 P99: 9.30 P99.9: 163.32 P99.99: 376.60 ------------------------------------------------------ [ 0, 1 ] 42677 7.395% 7.395% # ( 1, 2 ] 328911 56.995% 64.391% ########### ( 2, 3 ] 93342 16.175% 80.565% ### ( 3, 4 ] 48183 8.349% 88.915% ## ( 4, 6 ] 48527 8.409% 97.324% ## ( 6, 10 ] 11725 2.032% 99.356% ( 10, 15 ] 2291 0.397% 99.753% ( 15, 22 ] 284 0.049% 99.802% ( 22, 34 ] 32 0.006% 99.807% ( 34, 51 ] 5 0.001% 99.808% ( 51, 76 ] 7 0.001% 99.809% ( 76, 110 ] 244 0.042% 99.852% ( 110, 170 ] 315 0.055% 99.906% ( 170, 250 ] 197 0.034% 99.940% ( 250, 380 ] 295 0.051% 99.992% ( 380, 580 ] 286 0.050% 100.041% ( 580, 870 ] 252 0.044% 100.085% ( 870, 1300 ] 149 0.026% 100.111% ( 1300, 1900 ] 68 0.012% 100.122% ( 1900, 2900 ] 81 0.014% 100.136% ( 2900, 4400 ] 120 0.021% 100.157% ( 4400, 6600 ] 26 0.005% 100.162% ( 6600, 9900 ] 3 0.001% 100.162% ( 9900, 14000 ] 1 0.000% 100.162% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 442405 Average: 4.6900 StdDev: 63.83 Min: 0 Median: 1.7280 Max: 7717 Percentiles: P50: 1.73 P75: 2.60 P99: 9.44 P99.9: 339.54 P99.99: 668.15 ------------------------------------------------------ [ 0, 1 ] 38081 8.608% 8.608% ## ( 1, 2 ] 251536 56.857% 65.464% ########### ( 2, 3 ] 70562 15.950% 81.414% ### ( 3, 4 ] 35882 8.111% 89.525% ## ( 4, 6 ] 34444 7.786% 97.310% ## ( 6, 10 ] 8699 1.966% 99.276% ( 10, 15 ] 1671 0.378% 99.654% ( 15, 22 ] 236 0.053% 99.708% ( 22, 34 ] 44 0.010% 99.717% ( 34, 51 ] 16 0.004% 99.721% ( 51, 76 ] 2 0.000% 99.722% ( 76, 110 ] 104 0.024% 99.745% ( 110, 170 ] 342 0.077% 99.822% ( 170, 250 ] 190 0.043% 99.865% ( 250, 380 ] 223 0.050% 99.916% ( 380, 580 ] 278 0.063% 99.979% ( 580, 870 ] 167 0.038% 100.016% ( 870, 1300 ] 93 0.021% 100.037% ( 1300, 1900 ] 23 0.005% 100.042% ( 1900, 2900 ] 27 0.006% 100.049% ( 2900, 4400 ] 49 0.011% 100.060% ( 4400, 6600 ] 16 0.004% 100.063% ( 6600, 9900 ] 4 0.001% 100.064% ** Level 4 read latency histogram (micros): Count: 674 Average: 279.5875 StdDev: 899.64 Min: 0 Median: 1.8606 Max: 7877 Percentiles: P50: 1.86 P75: 5.61 P99: 4344.50 P99.9: 7877.00 P99.99: 7877.00 ------------------------------------------------------ [ 0, 1 ] 121 17.953% 17.953% #### ( 1, 2 ] 251 37.240% 55.193% ####### ( 2, 3 ] 70 10.386% 65.579% ## ( 3, 4 ] 45 6.677% 72.255% # ( 4, 6 ] 23 3.412% 75.668% # ( 6, 10 ] 45 6.677% 82.344% # ( 10, 15 ] 20 2.967% 85.312% # ( 76, 110 ] 1 0.148% 85.460% ( 110, 170 ] 4 0.593% 86.053% ( 170, 250 ] 1 0.148% 86.202% ( 250, 380 ] 5 0.742% 86.944% ( 380, 580 ] 11 1.632% 88.576% ( 580, 870 ] 13 1.929% 90.504% ( 870, 1300 ] 13 1.929% 92.433% ( 1300, 1900 ] 12 1.780% 94.214% ( 1900, 2900 ] 13 1.929% 96.142% ( 2900, 4400 ] 20 2.967% 99.110% # ( 4400, 6600 ] 4 0.593% 99.703% ( 6600, 9900 ] 2 0.297% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 758.2667 StdDev: 810.08 Min: 77 Median: 380.0000 Max: 3015 Percentiles: P50: 380.00 P75: 1042.00 P99: 3015.00 P99.9: 3015.00 P99.99: 3015.00 ------------------------------------------------------ ( 76, 110 ] 5 8.333% 8.333% ## ( 110, 170 ] 8 13.333% 21.667% ### ( 170, 250 ] 10 16.667% 38.333% ### ( 250, 380 ] 7 11.667% 50.000% ## ( 380, 580 ] 6 10.000% 60.000% ## ( 580, 870 ] 7 11.667% 71.667% ## ( 870, 1300 ] 5 8.333% 80.000% ## ( 1300, 1900 ] 1 1.667% 81.667% ( 1900, 2900 ] 10 16.667% 98.333% ### ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 32.7 total, 9.0 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 210.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.839 H:M:S, 42.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 109.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:6.183 H:M:S, 68.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/12/14-18:00:39 ... thread 0: (1000000,8000000) ops and (213508.5,215310.4) ops/second in (4.683655,37.155658) 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/13 3.13 GB 69.2 7.2 0.0 7.2 14.8 7.6 0.0 1.9 140.1 288.5 52.59 47.37 131 0.401 7482K 11K 0.0 0.0 L1 19/19 1.76 GB 0.0 4.5 4.2 0.2 4.4 4.2 0.2 1.0 221.0 218.1 20.76 19.36 3 6.922 4659K 58K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 22/0 969.51 MB 1.0 4.5 2.4 2.2 4.5 2.3 0.4 1.9 155.5 154.8 29.95 20.60 20 1.498 4731K 22K 0.0 0.0 L4 182/0 9.74 GB 1.0 1.8 1.7 0.1 1.8 1.7 0.8 1.0 137.1 136.9 13.38 8.50 24 0.557 1835K 2688 0.0 0.0 L5 1072/0 88.09 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1310/32 103.67 GB 0.0 18.4 8.5 9.9 25.9 16.0 6.3 3.4 159.3 224.6 118.19 97.29 180 0.657 19M 96K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.4 8.5 9.9 25.9 16.0 6.2 3.4 159.3 224.6 118.19 97.29 180 0.657 19M 96K 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 18.4 8.5 9.9 18.3 8.4 0.0 0.0 200.5 199.5 93.90 77.32 71 1.323 19M 96K 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 321.6 24.29 19.98 109 0.223 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 37.4 total, 37.2 interval Flush(GB): cumulative 7.629, interval 7.629 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.92 GB write, 710.10 MB/s write, 18.39 GB read, 503.73 MB/s read, 118.2 seconds Interval compaction: 25.92 GB write, 714.30 MB/s write, 18.39 GB read, 506.70 MB/s read, 118.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 46, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 46, interval: 62 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3362839 Average: 2.7341 StdDev: 29.67 Min: 0 Median: 1.4633 Max: 9614 Percentiles: P50: 1.46 P75: 1.85 P99: 6.42 P99.9: 137.45 P99.99: 361.03 ------------------------------------------------------ [ 0, 1 ] 671577 19.971% 19.971% #### ( 1, 2 ] 2179545 64.813% 84.783% ############# ( 2, 3 ] 267117 7.943% 92.726% ## ( 3, 4 ] 126885 3.773% 96.500% # ( 4, 6 ] 81600 2.427% 98.926% ( 6, 10 ] 23902 0.711% 99.637% ( 10, 15 ] 2983 0.089% 99.726% ( 15, 22 ] 780 0.023% 99.749% ( 22, 34 ] 48 0.001% 99.750% ( 34, 51 ] 18 0.001% 99.751% ( 51, 76 ] 76 0.002% 99.753% ( 76, 110 ] 3416 0.102% 99.855% ( 110, 170 ] 3353 0.100% 99.954% ( 170, 250 ] 767 0.023% 99.977% ( 250, 380 ] 516 0.015% 99.992% ( 380, 580 ] 404 0.012% 100.004% ( 580, 870 ] 195 0.006% 100.010% ( 870, 1300 ] 109 0.003% 100.013% ( 1300, 1900 ] 54 0.002% 100.015% ( 1900, 2900 ] 59 0.002% 100.017% ( 2900, 4400 ] 69 0.002% 100.019% ( 4400, 6600 ] 28 0.001% 100.020% ( 6600, 9900 ] 6 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 716478 Average: 6.1761 StdDev: 104.41 Min: 0 Median: 1.7678 Max: 11452 Percentiles: P50: 1.77 P75: 2.71 P99: 9.38 P99.9: 159.17 P99.99: 431.59 ------------------------------------------------------ [ 0, 1 ] 49021 6.842% 6.842% # ( 1, 2 ] 402752 56.213% 63.055% ########### ( 2, 3 ] 119932 16.739% 79.794% ### ( 3, 4 ] 61766 8.621% 88.415% ## ( 4, 6 ] 62991 8.792% 97.206% ## ( 6, 10 ] 15204 2.122% 99.328% ( 10, 15 ] 3130 0.437% 99.765% ( 15, 22 ] 373 0.052% 99.817% ( 22, 34 ] 32 0.004% 99.822% ( 34, 51 ] 5 0.001% 99.822% ( 51, 76 ] 7 0.001% 99.823% ( 76, 110 ] 275 0.038% 99.862% ( 110, 170 ] 335 0.047% 99.909% ( 170, 250 ] 204 0.028% 99.937% ( 250, 380 ] 304 0.042% 99.979% ( 380, 580 ] 296 0.041% 100.021% ( 580, 870 ] 264 0.037% 100.058% ( 870, 1300 ] 155 0.022% 100.079% ( 1300, 1900 ] 81 0.011% 100.091% ( 1900, 2900 ] 121 0.017% 100.107% ( 2900, 4400 ] 224 0.031% 100.139% ( 4400, 6600 ] 59 0.008% 100.147% ( 6600, 9900 ] 29 0.004% 100.151% ( 9900, 14000 ] 3 0.000% 100.151% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 899053 Average: 4.1335 StdDev: 53.96 Min: 0 Median: 1.8419 Max: 7717 Percentiles: P50: 1.84 P75: 2.89 P99: 8.70 P99.9: 14.58 P99.99: 113.46 ------------------------------------------------------ [ 0, 1 ] 48466 5.391% 5.391% # ( 1, 2 ] 476400 52.989% 58.380% ########### ( 2, 3 ] 168135 18.701% 77.081% #### ( 3, 4 ] 91870 10.219% 87.300% ## ( 4, 6 ] 93901 10.444% 97.744% ## ( 6, 10 ] 16703 1.858% 99.602% ( 10, 15 ] 2926 0.325% 99.927% ( 15, 22 ] 353 0.039% 99.967% ( 22, 34 ] 56 0.006% 99.973% ( 34, 51 ] 18 0.002% 99.975% ( 51, 76 ] 7 0.001% 99.976% ( 76, 110 ] 108 0.012% 99.988% ( 110, 170 ] 348 0.039% 100.026% ( 170, 250 ] 226 0.025% 100.052% ( 250, 380 ] 234 0.026% 100.078% ( 380, 580 ] 301 0.033% 100.111% ( 580, 870 ] 198 0.022% 100.133% ( 870, 1300 ] 120 0.013% 100.146% ( 1300, 1900 ] 29 0.003% 100.150% ( 1900, 2900 ] 42 0.005% 100.154% ( 2900, 4400 ] 87 0.010% 100.164% ( 4400, 6600 ] 20 0.002% 100.166% ( 6600, 9900 ] 4 0.000% 100.167% ** Level 4 read latency histogram (micros): Count: 23257 Average: 79.6810 StdDev: 403.60 Min: 0 Median: 2.0325 Max: 7877 Percentiles: P50: 2.03 P75: 3.43 P99: 1932.67 P99.9: 5249.53 P99.99: 7045.04 ------------------------------------------------------ [ 0, 1 ] 958 4.119% 4.119% # ( 1, 2 ] 10517 45.221% 49.340% ######### ( 2, 3 ] 4730 20.338% 69.678% #### ( 3, 4 ] 2882 12.392% 82.070% ## ( 4, 6 ] 1905 8.191% 90.261% ## ( 6, 10 ] 513 2.206% 92.467% ( 10, 15 ] 175 0.752% 93.219% ( 15, 22 ] 16 0.069% 93.288% ( 22, 34 ] 2 0.009% 93.297% ( 34, 51 ] 3 0.013% 93.310% ( 76, 110 ] 8 0.034% 93.344% ( 110, 170 ] 43 0.185% 93.529% ( 170, 250 ] 96 0.413% 93.942% ( 250, 380 ] 142 0.611% 94.552% ( 380, 580 ] 235 1.010% 95.563% ( 580, 870 ] 330 1.419% 96.982% ( 870, 1300 ] 301 1.294% 98.276% ( 1300, 1900 ] 165 0.709% 98.985% ( 1900, 2900 ] 105 0.451% 99.437% ( 2900, 4400 ] 95 0.408% 99.845% ( 4400, 6600 ] 33 0.142% 99.987% ( 6600, 9900 ] 5 0.021% 100.009% ** Level 5 read latency histogram (micros): Count: 140 Average: 1246.9857 StdDev: 1416.50 Min: 77 Median: 628.3333 Max: 7799 Percentiles: P50: 628.33 P75: 1900.00 P99: 7590.00 P99.9: 7799.00 P99.99: 7799.00 ------------------------------------------------------ ( 76, 110 ] 5 3.571% 3.571% # ( 110, 170 ] 9 6.429% 10.000% # ( 170, 250 ] 16 11.429% 21.429% ## ( 250, 380 ] 19 13.571% 35.000% ### ( 380, 580 ] 18 12.857% 47.857% ### ( 580, 870 ] 18 12.857% 60.714% ### ( 870, 1300 ] 9 6.429% 67.143% # ( 1300, 1900 ] 11 7.857% 75.000% ## ( 1900, 2900 ] 17 12.143% 87.143% ## ( 2900, 4400 ] 15 10.714% 97.857% ## ( 4400, 6600 ] 1 0.714% 98.571% ( 6600, 9900 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 37.4 total, 4.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 210.64 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:15.634 H:M:S, 41.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 210.08 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.795 H:M:S, 38.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/14-18:00:47 ... thread 0: (1000000,9000000) ops and (123131.2,198776.1) ops/second in (8.121416,45.277074) 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/5 4.11 GB 232.8 8.6 0.0 8.6 17.2 8.6 0.0 2.0 144.6 289.0 60.98 55.37 150 0.407 8953K 13K 0.0 0.0 L1 19/19 1.76 GB 0.0 4.5 4.2 0.2 4.4 4.2 0.2 1.0 221.0 218.1 20.76 19.36 3 6.922 4659K 58K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 22/0 969.51 MB 1.0 4.5 2.4 2.2 4.5 2.3 0.4 1.9 155.5 154.8 29.95 20.60 20 1.498 4731K 22K 0.0 0.0 L4 182/0 9.74 GB 1.0 1.8 1.7 0.1 1.8 1.7 0.8 1.0 137.1 136.9 13.38 8.50 24 0.557 1835K 2688 0.0 0.0 L5 1072/0 88.09 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1309/24 104.65 GB 0.0 19.8 8.5 11.3 28.3 17.0 6.3 3.3 160.2 229.1 126.59 105.29 199 0.636 20M 97K 0.0 0.0 Int 0/0 0.00 KB 0.0 19.8 8.5 11.3 28.3 17.0 6.2 3.3 160.2 229.1 126.59 105.29 199 0.636 20M 97K 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.8 8.5 11.3 19.7 8.4 0.0 0.0 204.0 203.0 99.42 82.74 76 1.308 20M 97K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 324.6 27.17 22.55 123 0.221 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.5 total, 45.3 interval Flush(GB): cumulative 8.613, interval 8.613 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: 28.32 GB write, 637.31 MB/s write, 19.80 GB read, 445.66 MB/s read, 126.6 seconds Interval compaction: 28.32 GB write, 640.40 MB/s write, 19.80 GB read, 447.82 MB/s read, 126.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 4, pending-compaction-bytes-stops: 0, total-delays: 20, total-stops: 50, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3827118 Average: 2.6657 StdDev: 28.02 Min: 0 Median: 1.4606 Max: 9614 Percentiles: P50: 1.46 P75: 1.85 P99: 6.15 P99.9: 129.57 P99.99: 330.01 ------------------------------------------------------ [ 0, 1 ] 768768 20.087% 20.087% #### ( 1, 2 ] 2485585 64.947% 85.034% ############# ( 2, 3 ] 300993 7.865% 92.899% ## ( 3, 4 ] 141909 3.708% 96.607% # ( 4, 6 ] 90628 2.368% 98.975% ( 6, 10 ] 26605 0.695% 99.670% ( 10, 15 ] 3222 0.084% 99.754% ( 15, 22 ] 843 0.022% 99.776% ( 22, 34 ] 49 0.001% 99.777% ( 34, 51 ] 19 0.000% 99.778% ( 51, 76 ] 77 0.002% 99.780% ( 76, 110 ] 3473 0.091% 99.871% ( 110, 170 ] 3437 0.090% 99.961% ( 170, 250 ] 799 0.021% 99.981% ( 250, 380 ] 535 0.014% 99.995% ( 380, 580 ] 422 0.011% 100.006% ( 580, 870 ] 208 0.005% 100.012% ( 870, 1300 ] 118 0.003% 100.015% ( 1300, 1900 ] 57 0.001% 100.016% ( 1900, 2900 ] 60 0.002% 100.018% ( 2900, 4400 ] 70 0.002% 100.020% ( 4400, 6600 ] 28 0.001% 100.021% ( 6600, 9900 ] 6 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1035264 Average: 4.9810 StdDev: 87.11 Min: 0 Median: 1.6263 Max: 11452 Percentiles: P50: 1.63 P75: 2.27 P99: 9.09 P99.9: 146.51 P99.99: 437.78 ------------------------------------------------------ [ 0, 1 ] 144841 13.991% 13.991% ### ( 1, 2 ] 595200 57.493% 71.483% ########### ( 2, 3 ] 134533 12.995% 84.478% ### ( 3, 4 ] 68108 6.579% 91.057% # ( 4, 6 ] 67221 6.493% 97.550% # ( 6, 10 ] 19428 1.877% 99.427% ( 10, 15 ] 3375 0.326% 99.753% ( 15, 22 ] 478 0.046% 99.799% ( 22, 34 ] 35 0.003% 99.802% ( 34, 51 ] 5 0.000% 99.803% ( 51, 76 ] 36 0.003% 99.806% ( 76, 110 ] 588 0.057% 99.863% ( 110, 170 ] 629 0.061% 99.924% ( 170, 250 ] 255 0.025% 99.949% ( 250, 380 ] 336 0.032% 99.981% ( 380, 580 ] 327 0.032% 100.013% ( 580, 870 ] 277 0.027% 100.039% ( 870, 1300 ] 159 0.015% 100.055% ( 1300, 1900 ] 81 0.008% 100.063% ( 1900, 2900 ] 123 0.012% 100.074% ( 2900, 4400 ] 224 0.022% 100.096% ( 4400, 6600 ] 59 0.006% 100.102% ( 6600, 9900 ] 29 0.003% 100.105% ( 9900, 14000 ] 3 0.000% 100.105% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 899053 Average: 4.1335 StdDev: 53.96 Min: 0 Median: 1.8419 Max: 7717 Percentiles: P50: 1.84 P75: 2.89 P99: 8.70 P99.9: 14.58 P99.99: 113.46 ------------------------------------------------------ [ 0, 1 ] 48466 5.391% 5.391% # ( 1, 2 ] 476400 52.989% 58.380% ########### ( 2, 3 ] 168135 18.701% 77.081% #### ( 3, 4 ] 91870 10.219% 87.300% ## ( 4, 6 ] 93901 10.444% 97.744% ## ( 6, 10 ] 16703 1.858% 99.602% ( 10, 15 ] 2926 0.325% 99.927% ( 15, 22 ] 353 0.039% 99.967% ( 22, 34 ] 56 0.006% 99.973% ( 34, 51 ] 18 0.002% 99.975% ( 51, 76 ] 7 0.001% 99.976% ( 76, 110 ] 108 0.012% 99.988% ( 110, 170 ] 348 0.039% 100.026% ( 170, 250 ] 226 0.025% 100.052% ( 250, 380 ] 234 0.026% 100.078% ( 380, 580 ] 301 0.033% 100.111% ( 580, 870 ] 198 0.022% 100.133% ( 870, 1300 ] 120 0.013% 100.146% ( 1300, 1900 ] 29 0.003% 100.150% ( 1900, 2900 ] 42 0.005% 100.154% ( 2900, 4400 ] 87 0.010% 100.164% ( 4400, 6600 ] 20 0.002% 100.166% ( 6600, 9900 ] 4 0.000% 100.167% ** Level 4 read latency histogram (micros): Count: 23257 Average: 79.6810 StdDev: 403.60 Min: 0 Median: 2.0325 Max: 7877 Percentiles: P50: 2.03 P75: 3.43 P99: 1932.67 P99.9: 5249.53 P99.99: 7045.04 ------------------------------------------------------ [ 0, 1 ] 958 4.119% 4.119% # ( 1, 2 ] 10517 45.221% 49.340% ######### ( 2, 3 ] 4730 20.338% 69.678% #### ( 3, 4 ] 2882 12.392% 82.070% ## ( 4, 6 ] 1905 8.191% 90.261% ## ( 6, 10 ] 513 2.206% 92.467% ( 10, 15 ] 175 0.752% 93.219% ( 15, 22 ] 16 0.069% 93.288% ( 22, 34 ] 2 0.009% 93.297% ( 34, 51 ] 3 0.013% 93.310% ( 76, 110 ] 8 0.034% 93.344% ( 110, 170 ] 43 0.185% 93.529% ( 170, 250 ] 96 0.413% 93.942% ( 250, 380 ] 142 0.611% 94.552% ( 380, 580 ] 235 1.010% 95.563% ( 580, 870 ] 330 1.419% 96.982% ( 870, 1300 ] 301 1.294% 98.276% ( 1300, 1900 ] 165 0.709% 98.985% ( 1900, 2900 ] 105 0.451% 99.437% ( 2900, 4400 ] 95 0.408% 99.845% ( 4400, 6600 ] 33 0.142% 99.987% ( 6600, 9900 ] 5 0.021% 100.009% ** Level 5 read latency histogram (micros): Count: 140 Average: 1246.9857 StdDev: 1416.50 Min: 77 Median: 628.3333 Max: 7799 Percentiles: P50: 628.33 P75: 1900.00 P99: 7590.00 P99.9: 7799.00 P99.99: 7799.00 ------------------------------------------------------ ( 76, 110 ] 5 3.571% 3.571% # ( 110, 170 ] 9 6.429% 10.000% # ( 170, 250 ] 16 11.429% 21.429% ## ( 250, 380 ] 19 13.571% 35.000% ### ( 380, 580 ] 18 12.857% 47.857% ### ( 580, 870 ] 18 12.857% 60.714% ### ( 870, 1300 ] 9 6.429% 67.143% # ( 1300, 1900 ] 11 7.857% 75.000% ## ( 1900, 2900 ] 17 12.143% 87.143% ## ( 2900, 4400 ] 15 10.714% 97.857% ## ( 4400, 6600 ] 1 0.714% 98.571% ( 6600, 9900 ] 2 1.429% 100.000% ** DB Stats ** Uptime(secs): 45.5 total, 8.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 194.67 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:20.858 H:M:S, 45.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 121.19 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:5.224 H:M:S, 64.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 2024/12/14-18:00:56 ... thread 0: (1000000,10000000) ops and (116642.9,185700.2) ops/second in (8.573175,53.850249) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/14 3.13 GB 56.7 8.9 0.0 8.9 18.4 9.5 0.0 1.9 140.8 290.1 64.88 58.87 163 0.398 9273K 13K 0.0 0.0 L1 17/17 2.12 GB 0.0 8.1 6.1 2.0 8.0 6.0 0.2 1.3 215.1 212.4 38.45 34.75 4 9.611 7008K 58K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.9 2.0 250.1 250.0 1.51 1.47 2 0.755 383K 203 0.0 0.0 L3 21/0 954.79 MB 1.0 6.7 3.5 3.2 6.6 3.4 0.7 1.9 158.2 157.3 43.24 30.62 32 1.351 6948K 38K 0.0 0.0 L4 175/0 9.50 GB 1.0 3.6 3.1 0.5 3.6 3.1 0.8 1.2 148.8 148.3 24.93 17.16 41 0.608 3639K 6740 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1323/31 105.44 GB 0.0 27.7 12.9 14.8 37.0 22.2 9.7 3.9 163.8 218.9 173.00 142.87 242 0.715 27M 117K 0.0 0.0 Int 0/0 0.00 KB 0.0 27.7 12.9 14.8 37.0 22.2 9.6 3.9 163.8 218.9 173.00 142.87 242 0.715 27M 117K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 27.7 12.9 14.8 27.5 12.7 0.0 0.0 197.9 196.7 143.16 118.01 107 1.338 27M 117K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 325.0 29.85 24.86 135 0.221 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 54.1 total, 53.9 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: 36.98 GB write, 700.25 MB/s write, 27.67 GB read, 523.98 MB/s read, 173.0 seconds Interval compaction: 36.98 GB write, 703.11 MB/s write, 27.67 GB read, 526.11 MB/s read, 173.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 55, pending-compaction-bytes-delays: 32, pending-compaction-bytes-stops: 0, total-delays: 48, total-stops: 55, interval: 103 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4290985 Average: 2.8235 StdDev: 30.89 Min: 0 Median: 1.4780 Max: 11033 Percentiles: P50: 1.48 P75: 1.87 P99: 6.74 P99.9: 139.85 P99.99: 463.41 ------------------------------------------------------ [ 0, 1 ] 823756 19.197% 19.197% #### ( 1, 2 ] 2765365 64.446% 83.643% ############# ( 2, 3 ] 361794 8.431% 92.075% ## ( 3, 4 ] 172140 4.012% 96.086% # ( 4, 6 ] 118768 2.768% 98.854% # ( 6, 10 ] 33924 0.791% 99.645% ( 10, 15 ] 4112 0.096% 99.741% ( 15, 22 ] 925 0.022% 99.762% ( 22, 34 ] 56 0.001% 99.764% ( 34, 51 ] 22 0.001% 99.764% ( 51, 76 ] 96 0.002% 99.766% ( 76, 110 ] 3772 0.088% 99.854% ( 110, 170 ] 3950 0.092% 99.946% ( 170, 250 ] 940 0.022% 99.968% ( 250, 380 ] 680 0.016% 99.984% ( 380, 580 ] 616 0.014% 99.998% ( 580, 870 ] 404 0.009% 100.008% ( 870, 1300 ] 243 0.006% 100.013% ( 1300, 1900 ] 111 0.003% 100.016% ( 1900, 2900 ] 76 0.002% 100.018% ( 2900, 4400 ] 95 0.002% 100.020% ( 4400, 6600 ] 32 0.001% 100.021% ( 6600, 9900 ] 6 0.000% 100.021% ( 9900, 14000 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 1435689 Average: 5.1170 StdDev: 83.71 Min: 0 Median: 1.6503 Max: 11457 Percentiles: P50: 1.65 P75: 2.41 P99: 9.27 P99.9: 163.07 P99.99: 501.25 ------------------------------------------------------ [ 0, 1 ] 198348 13.816% 13.816% ### ( 1, 2 ] 798905 55.646% 69.462% ########### ( 2, 3 ] 193833 13.501% 82.963% ### ( 3, 4 ] 103083 7.180% 90.143% # ( 4, 6 ] 103582 7.215% 97.358% # ( 6, 10 ] 28858 2.010% 99.368% ( 10, 15 ] 4839 0.337% 99.705% ( 15, 22 ] 662 0.046% 99.751% ( 22, 34 ] 48 0.003% 99.754% ( 34, 51 ] 18 0.001% 99.755% ( 51, 76 ] 87 0.006% 99.761% ( 76, 110 ] 1027 0.072% 99.833% ( 110, 170 ] 1089 0.076% 99.909% ( 170, 250 ] 373 0.026% 99.935% ( 250, 380 ] 460 0.032% 99.967% ( 380, 580 ] 550 0.038% 100.005% ( 580, 870 ] 498 0.035% 100.040% ( 870, 1300 ] 285 0.020% 100.060% ( 1300, 1900 ] 143 0.010% 100.070% ( 1900, 2900 ] 180 0.013% 100.082% ( 2900, 4400 ] 291 0.020% 100.102% ( 4400, 6600 ] 76 0.005% 100.108% ( 6600, 9900 ] 29 0.002% 100.110% ( 9900, 14000 ] 4 0.000% 100.110% ** Level 2 read latency histogram (micros): Count: 124237 Average: 2.4456 StdDev: 20.98 Min: 0 Median: 1.4245 Max: 4121 Percentiles: P50: 1.42 P75: 1.83 P99: 5.99 P99.9: 124.24 P99.99: 745.89 ------------------------------------------------------ [ 0, 1 ] 29690 23.898% 23.898% ##### ( 1, 2 ] 76401 61.496% 85.394% ############ ( 2, 3 ] 9146 7.362% 92.756% # ( 3, 4 ] 4688 3.773% 96.529% # ( 4, 6 ] 3089 2.486% 99.016% ( 6, 10 ] 935 0.753% 99.768% ( 10, 15 ] 113 0.091% 99.859% ( 15, 22 ] 21 0.017% 99.876% ( 22, 34 ] 3 0.002% 99.878% ( 51, 76 ] 2 0.002% 99.880% ( 76, 110 ] 11 0.009% 99.889% ( 110, 170 ] 58 0.047% 99.936% ( 170, 250 ] 33 0.027% 99.962% ( 250, 380 ] 20 0.016% 99.978% ( 380, 580 ] 10 0.008% 99.986% ( 580, 870 ] 8 0.006% 99.993% ( 870, 1300 ] 3 0.002% 99.995% ( 1300, 1900 ] 3 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 3 read latency histogram (micros): Count: 1529689 Average: 4.3668 StdDev: 55.22 Min: 0 Median: 1.8699 Max: 11324 Percentiles: P50: 1.87 P75: 2.94 P99: 8.74 P99.9: 14.32 P99.99: 58.15 ------------------------------------------------------ [ 0, 1 ] 66313 4.335% 4.335% # ( 1, 2 ] 802981 52.493% 56.828% ########## ( 2, 3 ] 294338 19.242% 76.070% #### ( 3, 4 ] 161803 10.578% 86.647% ## ( 4, 6 ] 168591 11.021% 97.669% ## ( 6, 10 ] 29694 1.941% 99.610% ( 10, 15 ] 5135 0.336% 99.945% ( 15, 22 ] 555 0.036% 99.982% ( 22, 34 ] 75 0.005% 99.987% ( 34, 51 ] 31 0.002% 99.989% ( 51, 76 ] 70 0.005% 99.993% ( 76, 110 ] 125 0.008% 100.001% ( 110, 170 ] 419 0.027% 100.029% ( 170, 250 ] 326 0.021% 100.050% ( 250, 380 ] 423 0.028% 100.078% ( 380, 580 ] 522 0.034% 100.112% ( 580, 870 ] 514 0.034% 100.146% ( 870, 1300 ] 309 0.020% 100.166% ( 1300, 1900 ] 108 0.007% 100.173% ( 1900, 2900 ] 83 0.005% 100.178% ( 2900, 4400 ] 143 0.009% 100.188% ( 4400, 6600 ] 33 0.002% 100.190% ( 6600, 9900 ] 4 0.000% 100.190% ( 9900, 14000 ] 1 0.000% 100.190% ** Level 4 read latency histogram (micros): Count: 131683 Average: 30.5160 StdDev: 237.44 Min: 0 Median: 1.8996 Max: 12314 Percentiles: P50: 1.90 P75: 3.09 P99: 831.39 P99.9: 3484.22 P99.99: 5151.31 ------------------------------------------------------ [ 0, 1 ] 5523 4.194% 4.194% # ( 1, 2 ] 67051 50.918% 55.113% ########## ( 2, 3 ] 24969 18.961% 74.074% #### ( 3, 4 ] 14116 10.720% 84.794% ## ( 4, 6 ] 12007 9.118% 93.912% ## ( 6, 10 ] 3139 2.384% 96.296% ( 10, 15 ] 661 0.502% 96.798% ( 15, 22 ] 62 0.047% 96.845% ( 22, 34 ] 13 0.010% 96.855% ( 34, 51 ] 7 0.005% 96.860% ( 51, 76 ] 12 0.009% 96.869% ( 76, 110 ] 115 0.087% 96.956% ( 110, 170 ] 323 0.245% 97.202% ( 170, 250 ] 418 0.317% 97.519% ( 250, 380 ] 509 0.387% 97.906% ( 380, 580 ] 739 0.561% 98.467% ( 580, 870 ] 810 0.615% 99.082% ( 870, 1300 ] 576 0.437% 99.519% ( 1300, 1900 ] 270 0.205% 99.724% ( 1900, 2900 ] 169 0.128% 99.853% ( 2900, 4400 ] 160 0.122% 99.974% ( 4400, 6600 ] 61 0.046% 100.021% ( 6600, 9900 ] 9 0.007% 100.027% ( 9900, 14000 ] 3 0.002% 100.030% ** Level 5 read latency histogram (micros): Count: 240 Average: 1274.3042 StdDev: 1438.55 Min: 77 Median: 590.7407 Max: 7799 Percentiles: P50: 590.74 P75: 2066.67 P99: 6380.00 P99.9: 7799.00 P99.99: 7799.00 ------------------------------------------------------ ( 76, 110 ] 9 3.750% 3.750% # ( 110, 170 ] 23 9.583% 13.333% ## ( 170, 250 ] 27 11.250% 24.583% ## ( 250, 380 ] 29 12.083% 36.667% ## ( 380, 580 ] 31 12.917% 49.583% ### ( 580, 870 ] 27 11.250% 60.833% ## ( 870, 1300 ] 14 5.833% 66.667% # ( 1300, 1900 ] 15 6.250% 72.917% # ( 1900, 2900 ] 30 12.500% 85.417% ### ( 2900, 4400 ] 29 12.083% 97.500% ## ( 4400, 6600 ] 4 1.667% 99.167% ( 6600, 9900 ] 2 0.833% 100.000% ** DB Stats ** Uptime(secs): 54.1 total, 8.6 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 182.01 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.511 H:M:S, 49.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 114.81 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:5.653 H:M:S, 65.9 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.689 micros/op 175769 ops/sec 60.050 seconds 10554999 operations; 170.3 MB/s Microseconds per write: Count: 10554999 Average: 5.6893 StdDev: 506.45 Min: 0 Median: 1.7357 Max: 1031193 Percentiles: P50: 1.74 P75: 2.74 P99: 8.43 P99.9: 1120.66 P99.99: 2635.19 ------------------------------------------------------ [ 0, 1 ] 1443047 13.672% 13.672% ### ( 1, 2 ] 5211838 49.378% 63.050% ########## ( 2, 3 ] 1711407 16.214% 79.264% ### ( 3, 4 ] 1455587 13.790% 93.054% ### ( 4, 6 ] 569334 5.394% 98.448% # ( 6, 10 ] 95856 0.908% 99.356% ( 10, 15 ] 26413 0.250% 99.607% ( 15, 22 ] 8161 0.077% 99.684% ( 22, 34 ] 2035 0.019% 99.703% ( 34, 51 ] 230 0.002% 99.705% ( 51, 76 ] 36 0.000% 99.706% ( 76, 110 ] 7043 0.067% 99.773% ( 110, 170 ] 3188 0.030% 99.803% ( 170, 250 ] 331 0.003% 99.806% ( 250, 380 ] 119 0.001% 99.807% ( 380, 580 ] 25 0.000% 99.807% ( 580, 870 ] 17 0.000% 99.807% ( 870, 1300 ] 16772 0.159% 99.966% ( 1300, 1900 ] 85 0.001% 99.967% ( 1900, 2900 ] 3291 0.031% 99.998% ( 2900, 4400 ] 128 0.001% 99.999% ( 4400, 6600 ] 21 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 4 0.000% 100.000% ( 22000, 33000 ] 4 0.000% 100.000% ( 170000, 250000 ] 17 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 212605 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 : 10554999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10892758968 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 : 596 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 31219116 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 : 34391570821 rocksdb.compact.write.bytes COUNT : 34181194536 rocksdb.flush.write.bytes COUNT : 10833404929 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 : 58 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 : 278 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 : 10746108928 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4216832 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 : 34489972288 rocksdb.non.last.level.read.count COUNT : 8335119 rocksdb.block.checksum.compute.count COUNT : 8333985 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.385105 P95 : 3.869352 P99 : 6.739615 P100 : 1031192.000000 COUNT : 10554999 SUM : 55212301 rocksdb.compaction.times.micros P50 : 982558.139535 P95 : 3057500.000000 P99 : 17560000.000000 P100 : 17680775.000000 COUNT : 111 SUM : 147457511 rocksdb.compaction.times.cpu_micros P50 : 864358.974359 P95 : 3057500.000000 P99 : 15391570.000000 P100 : 15391570.000000 COUNT : 111 SUM : 122248893 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 : 712.151899 P95 : 1420.000000 P99 : 12196.000000 P100 : 331171.000000 COUNT : 144 SUM : 453374 rocksdb.compaction.outfile.sync.micros P50 : 1075.046296 P95 : 127250.000000 P99 : 233120.000000 P100 : 274688.000000 COUNT : 411 SUM : 6995254 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 : 102.415385 P95 : 693.928571 P99 : 3331.250000 P100 : 4028.000000 COUNT : 285 SUM : 64891 rocksdb.table.open.io.micros P50 : 1238.571429 P95 : 7530.000000 P99 : 12254.571429 P100 : 13021.000000 COUNT : 596 SUM : 1145446 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.621928 P95 : 7.828974 P99 : 10.995820 P100 : 12317.000000 COUNT : 8332594 SUM : 49815671 rocksdb.read.block.get.micros P50 : 392.587413 P95 : 3137.735849 P99 : 4921.230769 P100 : 9250.000000 COUNT : 1192 SUM : 931112 rocksdb.write.raw.block.micros P50 : 0.513526 P95 : 0.975699 P99 : 2.893826 P100 : 15707.000000 COUNT : 10904366 SUM : 21740841 rocksdb.numfiles.in.singlecompaction P50 : 2.833333 P95 : 5.250000 P99 : 25.000000 P100 : 27.000000 COUNT : 150 SUM : 529 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.557173 P95 : 1135.225609 P99 : 2333.078810 P100 : 1031018.000000 COUNT : 197773 SUM : 31233760 rocksdb.sst.read.micros P50 : 1.572905 P95 : 4.727158 P99 : 8.429686 P100 : 12314.000000 COUNT : 8335892 SUM : 32690932 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 : 10554999 SUM : 10892758968 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 : 213076.923077 P95 : 359200.000000 P99 : 955200.000000 P100 : 1098967.000000 COUNT : 144 SUM : 31699041 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 : 387 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