[2024-07-26 18:12:42.465521] Starting SPDK v24.09-pre git sha1 704257090 / DPDK 24.07.0-rc3 initialization... [2024-07-26 18:12:42.465667] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid873436 ] Set seed to 1722010362462192 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-26 18:12:42.526415] pci_dpdk.c: 37:dpdk_pci_init: *NOTICE*: In-development DPDK 24.07.0-rc3 is used. There is no support for it in SPDK. Enabled only for validation. [2024-07-26 18:12:42.562555] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-26 18:12:42.604253] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-26 18:12:42.604300] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 873436' to capture a snapshot of events at runtime. [2024-07-26 18:12:42.604315] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-26 18:12:42.604324] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-26 18:12:42.604334] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid873436 for offline analysis/debug. [2024-07-26 18:12:42.604420] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 26 18:12:46 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/26-18:12:49 ... thread 0: (1000000,1000000) ops and (361181.4,361181.4) ops/second in (2.768692,2.768692) 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.04 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 354.0 2.31 2.08 12 0.193 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 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 12/0 993.37 MB 1.0 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.60 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.57 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1180/8 96.94 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.5 99.1 313.8 3.81 3.54 14 0.272 383K 201 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 99.1 313.8 3.81 3.54 14 0.272 383K 201 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 251.8 251.7 1.50 1.45 2 0.750 383K 201 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 354.0 2.31 2.08 12 0.193 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, 401.34 MB/s write, 0.37 GB read, 126.75 MB/s read, 3.8 seconds Interval compaction: 1.17 GB write, 431.99 MB/s write, 0.37 GB read, 136.43 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: 101014 Average: 1.8854 StdDev: 17.46 Min: 1 Median: 1.2286 Max: 3757 Percentiles: P50: 1.23 P75: 1.66 P99: 3.96 P99.9: 9.60 P99.99: 297.10 ------------------------------------------------------ [ 0, 1 ] 37263 36.889% 36.889% ####### ( 1, 2 ] 57935 57.353% 94.242% ########### ( 2, 3 ] 3460 3.425% 97.668% # ( 3, 4 ] 1408 1.394% 99.062% ( 4, 6 ] 615 0.609% 99.670% ( 6, 10 ] 258 0.255% 99.926% ( 10, 15 ] 33 0.033% 99.958% ( 15, 22 ] 16 0.016% 99.974% ( 34, 51 ] 1 0.001% 99.975% ( 51, 76 ] 1 0.001% 99.976% ( 110, 170 ] 9 0.009% 99.985% ( 170, 250 ] 2 0.002% 99.987% ( 250, 380 ] 8 0.008% 99.995% ( 870, 1300 ] 1 0.001% 99.996% ( 1300, 1900 ] 1 0.001% 99.997% ( 1900, 2900 ] 1 0.001% 99.998% ( 2900, 4400 ] 2 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 50836 Average: 1.9824 StdDev: 21.37 Min: 0 Median: 1.2611 Max: 4040 Percentiles: P50: 1.26 P75: 1.68 P99: 4.32 P99.9: 9.82 P99.99: 571.64 ------------------------------------------------------ [ 0, 1 ] 17562 34.546% 34.546% ####### ( 1, 2 ] 30090 59.190% 93.737% ############ ( 2, 3 ] 1821 3.582% 97.319% # ( 3, 4 ] 797 1.568% 98.887% ( 4, 6 ] 369 0.726% 99.612% ( 6, 10 ] 154 0.303% 99.915% ( 10, 15 ] 26 0.051% 99.967% ( 15, 22 ] 4 0.008% 99.974% ( 22, 34 ] 2 0.004% 99.978% ( 34, 51 ] 1 0.002% 99.980% ( 170, 250 ] 1 0.002% 99.982% ( 250, 380 ] 3 0.006% 99.988% ( 380, 580 ] 2 0.004% 99.992% ( 580, 870 ] 2 0.004% 99.996% ( 870, 1300 ] 1 0.002% 99.998% ( 1900, 2900 ] 1 0.002% 100.000% ( 2900, 4400 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 55 Average: 1609.5636 StdDev: 1181.64 Min: 264 Median: 1192.5000 Max: 5263 Percentiles: P50: 1192.50 P75: 2611.54 P99: 5263.00 P99.9: 5263.00 P99.99: 5263.00 ------------------------------------------------------ ( 250, 380 ] 7 12.727% 12.727% ### ( 380, 580 ] 5 9.091% 21.818% ## ( 580, 870 ] 11 20.000% 41.818% #### ( 870, 1300 ] 6 10.909% 52.727% ## ( 1300, 1900 ] 3 5.455% 58.182% # ( 1900, 2900 ] 13 23.636% 81.818% ##### ( 2900, 4400 ] 9 16.364% 98.182% ### ( 4400, 6600 ] 1 1.818% 100.000% ** Level 4 read latency histogram (micros): Count: 20 Average: 1928.7000 StdDev: 1249.73 Min: 557 Median: 1600.0000 Max: 5302 Percentiles: P50: 1600.00 P75: 2700.00 P99: 5302.00 P99.9: 5302.00 P99.99: 5302.00 ------------------------------------------------------ ( 380, 580 ] 1 5.000% 5.000% # ( 580, 870 ] 3 15.000% 20.000% ### ( 870, 1300 ] 5 25.000% 45.000% ##### ( 1300, 1900 ] 2 10.000% 55.000% ## ( 1900, 2900 ] 5 25.000% 80.000% ##### ( 2900, 4400 ] 3 15.000% 95.000% ### ( 4400, 6600 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 330.03 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.215 H:M:S, 7.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 355.15 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.215 H:M:S, 7.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-18:12:52 ... thread 0: (1000000,2000000) ops and (326202.5,342802.0) ops/second in (3.065580,5.834272) 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 12.6 0.6 0.0 0.6 2.3 1.8 0.0 1.3 77.5 326.9 7.32 6.69 28 0.261 575K 633 0.0 0.0 L1 1/1 3.83 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 239.4 239.0 1.58 1.53 1 1.579 383K 603 0.0 0.0 L2 2/1 53.63 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.4 2.0 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 18/8 1.00 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 238.0 238.0 1.05 0.98 1 1.048 253K 0 0.0 0.0 L4 170/0 9.45 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 145.7 145.7 1.54 1.13 1 1.540 227K 0 0.0 0.0 L5 1048/0 86.25 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1250/19 97.92 GB 0.0 1.8 1.0 0.7 3.5 2.8 2.1 2.0 138.3 278.9 12.99 11.78 33 0.394 1824K 1437 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.5 2.8 2.0 2.0 138.3 278.9 12.99 11.78 33 0.394 1824K 1437 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 230.3 230.1 7.80 7.18 7 1.114 1824K 1437 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 352.2 5.19 4.59 26 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.54 GB write, 598.94 MB/s write, 1.75 GB read, 297.09 MB/s read, 13.0 seconds Interval compaction: 3.54 GB write, 620.66 MB/s write, 1.75 GB read, 307.86 MB/s read, 13.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 390981 Average: 2.2193 StdDev: 12.35 Min: 1 Median: 1.4994 Max: 3810 Percentiles: P50: 1.50 P75: 1.88 P99: 5.72 P99.9: 11.22 P99.99: 20.69 ------------------------------------------------------ [ 0, 1 ] 67900 17.367% 17.367% ### ( 1, 2 ] 255473 65.342% 82.708% ############# ( 2, 3 ] 40005 10.232% 92.940% ## ( 3, 4 ] 15122 3.868% 96.808% # ( 4, 6 ] 9940 2.542% 99.350% # ( 6, 10 ] 2053 0.525% 99.875% ( 10, 15 ] 407 0.104% 99.979% ( 15, 22 ] 54 0.014% 99.993% ( 22, 34 ] 11 0.003% 99.996% ( 34, 51 ] 9 0.002% 99.998% ( 51, 76 ] 5 0.001% 99.999% ( 110, 170 ] 16 0.004% 100.004% ( 170, 250 ] 8 0.002% 100.006% ( 250, 380 ] 14 0.004% 100.009% ( 380, 580 ] 1 0.000% 100.009% ( 580, 870 ] 7 0.002% 100.011% ( 870, 1300 ] 4 0.001% 100.012% ( 1300, 1900 ] 1 0.000% 100.013% ( 1900, 2900 ] 2 0.001% 100.013% ( 2900, 4400 ] 3 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 26 Average: 144.8462 StdDev: 284.24 Min: 1 Median: 1.8000 Max: 1215 Percentiles: P50: 1.80 P75: 210.00 P99: 1188.20 P99.9: 1215.00 P99.99: 1215.00 ------------------------------------------------------ [ 0, 1 ] 5 19.231% 19.231% #### ( 1, 2 ] 10 38.462% 57.692% ######## ( 2, 3 ] 1 3.846% 61.538% # ( 3, 4 ] 1 3.846% 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 ] 3 11.538% 88.462% ## ( 380, 580 ] 1 3.846% 92.308% # ( 580, 870 ] 1 3.846% 96.154% # ( 870, 1300 ] 1 3.846% 100.000% # ** Level 2 read latency histogram (micros): Count: 95775 Average: 2.0911 StdDev: 15.71 Min: 0 Median: 1.4030 Max: 4040 Percentiles: P50: 1.40 P75: 1.80 P99: 5.35 P99.9: 10.94 P99.99: 311.64 ------------------------------------------------------ [ 0, 1 ] 23321 24.350% 24.350% ##### ( 1, 2 ] 60963 63.652% 88.002% ############# ( 2, 3 ] 6727 7.024% 95.026% # ( 3, 4 ] 2782 2.905% 97.931% # ( 4, 6 ] 1516 1.583% 99.513% ( 6, 10 ] 357 0.373% 99.886% ( 10, 15 ] 70 0.073% 99.959% ( 15, 22 ] 13 0.014% 99.973% ( 22, 34 ] 7 0.007% 99.980% ( 34, 51 ] 5 0.005% 99.985% ( 51, 76 ] 1 0.001% 99.986% ( 110, 170 ] 1 0.001% 99.987% ( 170, 250 ] 1 0.001% 99.989% ( 250, 380 ] 3 0.003% 99.992% ( 380, 580 ] 2 0.002% 99.994% ( 580, 870 ] 3 0.003% 99.997% ( 870, 1300 ] 1 0.001% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 168951 Average: 3.5810 StdDev: 39.46 Min: 0 Median: 1.6965 Max: 5263 Percentiles: P50: 1.70 P75: 2.30 P99: 8.83 P99.9: 180.97 P99.99: 561.45 ------------------------------------------------------ [ 0, 1 ] 10593 6.270% 6.270% # ( 1, 2 ] 106078 62.786% 69.056% ############# ( 2, 3 ] 32991 19.527% 88.583% #### ( 3, 4 ] 8347 4.940% 93.524% # ( 4, 6 ] 7349 4.350% 97.873% # ( 6, 10 ] 2687 1.590% 99.464% ( 10, 15 ] 403 0.239% 99.702% ( 15, 22 ] 72 0.043% 99.745% ( 22, 34 ] 25 0.015% 99.760% ( 34, 51 ] 3 0.002% 99.761% ( 51, 76 ] 11 0.007% 99.768% ( 76, 110 ] 62 0.037% 99.805% ( 110, 170 ] 152 0.090% 99.895% ( 170, 250 ] 66 0.039% 99.934% ( 250, 380 ] 57 0.034% 99.967% ( 380, 580 ] 42 0.025% 99.992% ( 580, 870 ] 25 0.015% 100.007% ( 870, 1300 ] 11 0.007% 100.014% ( 1300, 1900 ] 4 0.002% 100.016% ( 1900, 2900 ] 15 0.009% 100.025% ( 2900, 4400 ] 9 0.005% 100.030% ( 4400, 6600 ] 1 0.001% 100.031% ** Level 4 read latency histogram (micros): Count: 310 Average: 132.6548 StdDev: 570.42 Min: 1 Median: 1.7344 Max: 5302 Percentiles: P50: 1.73 P75: 7.80 P99: 3350.00 P99.9: 5302.00 P99.99: 5302.00 ------------------------------------------------------ [ 0, 1 ] 61 19.677% 19.677% #### ( 1, 2 ] 128 41.290% 60.968% ######## ( 2, 3 ] 33 10.645% 71.613% ## ( 3, 4 ] 3 0.968% 72.581% ( 4, 6 ] 3 0.968% 73.548% ( 6, 10 ] 10 3.226% 76.774% # ( 10, 15 ] 44 14.194% 90.968% ### ( 15, 22 ] 3 0.968% 91.935% ( 76, 110 ] 1 0.323% 92.258% ( 110, 170 ] 2 0.645% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 1 0.323% 93.548% ( 580, 870 ] 4 1.290% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 2 0.645% 97.097% ( 1900, 2900 ] 5 1.613% 98.710% ( 2900, 4400 ] 3 0.968% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 806.7500 StdDev: 893.54 Min: 88 Median: 380.0000 Max: 3113 Percentiles: P50: 380.00 P75: 1156.67 P99: 3113.00 P99.9: 3113.00 P99.99: 3113.00 ------------------------------------------------------ ( 76, 110 ] 6 15.000% 15.000% ### ( 110, 170 ] 6 15.000% 30.000% ### ( 170, 250 ] 6 15.000% 45.000% ### ( 250, 380 ] 2 5.000% 50.000% # ( 380, 580 ] 4 10.000% 60.000% ## ( 580, 870 ] 2 5.000% 65.000% # ( 870, 1300 ] 6 15.000% 80.000% ### ( 1300, 1900 ] 2 5.000% 85.000% # ( 1900, 2900 ] 3 7.500% 92.500% ## ( 2900, 4400 ] 3 7.500% 100.000% ## ** DB Stats ** Uptime(secs): 6.0 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 325.48 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.619 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.04 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.404 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/26-18:12:55 ... thread 0: (1000000,3000000) ops and (321147.2,335266.4) ops/second in (3.113837,8.948109) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.35 GB 81.8 1.4 0.0 1.4 4.1 2.8 0.0 1.5 104.0 316.7 13.32 12.29 45 0.296 1407K 1519 0.0 0.0 L1 4/0 304.32 MB 30.4 1.2 1.2 0.0 1.2 1.2 0.2 1.0 236.6 236.0 5.07 4.92 2 2.536 1218K 3165 0.0 0.0 L2 4/3 515.09 MB 1.3 0.4 0.2 0.2 0.4 0.2 0.9 2.0 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 11/3 562.54 MB 0.2 1.0 0.3 0.7 1.0 0.3 0.4 3.3 226.0 225.6 4.45 4.15 3 1.484 1022K 1757 0.0 0.0 L4 170/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 145.7 145.7 1.54 1.13 1 1.540 227K 0 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/14 98.90 GB 0.0 4.1 1.9 2.2 6.9 4.6 3.4 2.5 162.0 271.3 25.89 23.93 53 0.488 4259K 6642 0.0 0.0 Int 0/0 0.00 KB 0.0 4.1 1.9 2.2 6.9 4.6 3.3 2.5 162.0 271.3 25.89 23.93 53 0.488 4259K 6642 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.1 1.9 2.2 4.1 1.9 0.0 0.0 235.3 234.9 17.83 16.79 13 1.371 4259K 6642 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.8 8.06 7.14 40 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.2 total, 8.9 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.86 GB write, 766.57 MB/s write, 4.10 GB read, 457.87 MB/s read, 25.9 seconds Interval compaction: 6.86 GB write, 784.69 MB/s write, 4.10 GB read, 468.70 MB/s read, 25.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 776474 Average: 2.2556 StdDev: 12.39 Min: 1 Median: 1.5311 Max: 5721 Percentiles: P50: 1.53 P75: 1.90 P99: 5.72 P99.9: 10.98 P99.99: 14.69 ------------------------------------------------------ [ 0, 1 ] 110715 14.259% 14.259% ### ( 1, 2 ] 522548 67.298% 81.556% ############# ( 2, 3 ] 85567 11.020% 92.576% ## ( 3, 4 ] 31801 4.096% 96.672% # ( 4, 6 ] 20998 2.704% 99.376% # ( 6, 10 ] 3887 0.501% 99.877% ( 10, 15 ] 941 0.121% 99.998% ( 15, 22 ] 81 0.010% 100.008% ( 22, 34 ] 14 0.002% 100.010% ( 34, 51 ] 12 0.002% 100.012% ( 51, 76 ] 6 0.001% 100.012% ( 110, 170 ] 21 0.003% 100.015% ( 170, 250 ] 13 0.002% 100.017% ( 250, 380 ] 23 0.003% 100.020% ( 380, 580 ] 4 0.001% 100.020% ( 580, 870 ] 11 0.001% 100.022% ( 870, 1300 ] 7 0.001% 100.023% ( 1300, 1900 ] 3 0.000% 100.023% ( 1900, 2900 ] 3 0.000% 100.023% ( 2900, 4400 ] 4 0.001% 100.024% ( 4400, 6600 ] 1 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 84006 Average: 3.2636 StdDev: 21.29 Min: 1 Median: 1.7231 Max: 2540 Percentiles: P50: 1.72 P75: 2.41 P99: 8.14 P99.9: 109.99 P99.99: 198.12 ------------------------------------------------------ [ 0, 1 ] 3586 4.269% 4.269% # ( 1, 2 ] 53129 63.244% 67.513% ############# ( 2, 3 ] 15227 18.126% 85.639% #### ( 3, 4 ] 5767 6.865% 92.504% # ( 4, 6 ] 4908 5.842% 98.347% # ( 6, 10 ] 1030 1.226% 99.573% ( 10, 15 ] 203 0.242% 99.814% ( 15, 22 ] 34 0.040% 99.855% ( 22, 34 ] 3 0.004% 99.858% ( 51, 76 ] 3 0.004% 99.862% ( 76, 110 ] 33 0.039% 99.901% ( 110, 170 ] 64 0.076% 99.977% ( 170, 250 ] 33 0.039% 100.017% ( 250, 380 ] 25 0.030% 100.046% ( 380, 580 ] 28 0.033% 100.080% ( 580, 870 ] 9 0.011% 100.090% ( 870, 1300 ] 7 0.008% 100.099% ( 1300, 1900 ] 1 0.001% 100.100% ( 1900, 2900 ] 2 0.002% 100.102% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 207324 Average: 3.5262 StdDev: 36.81 Min: 0 Median: 1.6888 Max: 5263 Percentiles: P50: 1.69 P75: 2.28 P99: 8.78 P99.9: 200.27 P99.99: 618.68 ------------------------------------------------------ [ 0, 1 ] 12925 6.234% 6.234% # ( 1, 2 ] 131732 63.539% 69.773% ############# ( 2, 3 ] 39075 18.847% 88.621% #### ( 3, 4 ] 10433 5.032% 93.653% # ( 4, 6 ] 8794 4.242% 97.895% # ( 6, 10 ] 3298 1.591% 99.485% ( 10, 15 ] 445 0.215% 99.700% ( 15, 22 ] 76 0.037% 99.737% ( 22, 34 ] 27 0.013% 99.750% ( 34, 51 ] 3 0.001% 99.751% ( 51, 76 ] 12 0.006% 99.757% ( 76, 110 ] 73 0.035% 99.792% ( 110, 170 ] 190 0.092% 99.884% ( 170, 250 ] 89 0.043% 99.927% ( 250, 380 ] 74 0.036% 99.962% ( 380, 580 ] 53 0.026% 99.988% ( 580, 870 ] 32 0.015% 100.003% ( 870, 1300 ] 15 0.007% 100.011% ( 1300, 1900 ] 4 0.002% 100.013% ( 1900, 2900 ] 16 0.008% 100.020% ( 2900, 4400 ] 9 0.004% 100.025% ( 4400, 6600 ] 1 0.000% 100.025% ** Level 4 read latency histogram (micros): Count: 310 Average: 132.6548 StdDev: 570.42 Min: 1 Median: 1.7344 Max: 5302 Percentiles: P50: 1.73 P75: 7.80 P99: 3350.00 P99.9: 5302.00 P99.99: 5302.00 ------------------------------------------------------ [ 0, 1 ] 61 19.677% 19.677% #### ( 1, 2 ] 128 41.290% 60.968% ######## ( 2, 3 ] 33 10.645% 71.613% ## ( 3, 4 ] 3 0.968% 72.581% ( 4, 6 ] 3 0.968% 73.548% ( 6, 10 ] 10 3.226% 76.774% # ( 10, 15 ] 44 14.194% 90.968% ### ( 15, 22 ] 3 0.968% 91.935% ( 76, 110 ] 1 0.323% 92.258% ( 110, 170 ] 2 0.645% 92.903% ( 250, 380 ] 1 0.323% 93.226% ( 380, 580 ] 1 0.323% 93.548% ( 580, 870 ] 4 1.290% 94.839% ( 870, 1300 ] 5 1.613% 96.452% ( 1300, 1900 ] 2 0.645% 97.097% ( 1900, 2900 ] 5 1.613% 98.710% ( 2900, 4400 ] 3 0.968% 99.677% ( 4400, 6600 ] 1 0.323% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 826.0500 StdDev: 931.55 Min: 88 Median: 347.5000 Max: 3325 Percentiles: P50: 347.50 P75: 1192.50 P99: 3325.00 P99.9: 3325.00 P99.99: 3325.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 4 6.667% 51.667% # ( 380, 580 ] 5 8.333% 60.000% ## ( 580, 870 ] 3 5.000% 65.000% # ( 870, 1300 ] 8 13.333% 78.333% ### ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 5 8.333% 91.667% ## ( 2900, 4400 ] 5 8.333% 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, 322.28 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.074 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 316.06 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.456 H:M:S, 14.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/26-18:12:58 ... thread 0: (1000000,4000000) ops and (327146.9,333198.9) ops/second in (3.056731,12.004840) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/12 2.27 GB 37.8 2.2 0.0 2.2 5.8 3.7 0.0 1.6 115.0 312.0 19.17 17.79 61 0.314 2238K 2375 0.0 0.0 L1 4/4 304.32 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 236.6 236.0 5.07 4.92 2 2.536 1218K 3165 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 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 22/0 985.54 MB 1.0 1.9 0.8 1.1 1.9 0.8 0.4 2.4 225.2 224.8 8.70 8.18 6 1.449 1988K 3738 0.0 0.0 L4 171/0 9.73 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.8 1.0 152.4 152.4 1.91 1.43 2 0.953 295K 131 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1264/16 99.82 GB 0.0 5.9 2.4 3.5 9.6 6.1 3.4 2.6 165.9 269.7 36.35 33.77 73 0.498 6124K 9610 0.0 0.0 Int 0/0 0.00 KB 0.0 5.9 2.4 3.5 9.6 6.1 3.3 2.6 165.9 269.7 36.35 33.77 73 0.498 6124K 9610 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.4 3.5 5.9 2.4 0.0 0.0 235.6 235.2 25.60 24.23 20 1.280 6124K 9610 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 351.6 10.75 9.54 53 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 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, 802.22 MB/s write, 5.89 GB read, 493.67 MB/s read, 36.3 seconds Interval compaction: 9.57 GB write, 816.36 MB/s write, 5.89 GB read, 502.37 MB/s read, 36.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 14, interval: 14 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1093772 Average: 2.2885 StdDev: 11.38 Min: 1 Median: 1.5448 Max: 5721 Percentiles: P50: 1.54 P75: 1.91 P99: 5.76 P99.9: 11.59 P99.99: 14.98 ------------------------------------------------------ [ 0, 1 ] 143105 13.084% 13.084% ### ( 1, 2 ] 741159 67.762% 80.845% ############## ( 2, 3 ] 125710 11.493% 92.339% ## ( 3, 4 ] 45892 4.196% 96.534% # ( 4, 6 ] 30687 2.806% 99.340% # ( 6, 10 ] 5662 0.518% 99.858% ( 10, 15 ] 1454 0.133% 99.991% ( 15, 22 ] 118 0.011% 100.001% ( 22, 34 ] 15 0.001% 100.003% ( 34, 51 ] 15 0.001% 100.004% ( 51, 76 ] 7 0.001% 100.005% ( 76, 110 ] 29 0.003% 100.007% ( 110, 170 ] 49 0.004% 100.012% ( 170, 250 ] 32 0.003% 100.015% ( 250, 380 ] 37 0.003% 100.018% ( 380, 580 ] 10 0.001% 100.019% ( 580, 870 ] 19 0.002% 100.021% ( 870, 1300 ] 13 0.001% 100.022% ( 1300, 1900 ] 7 0.001% 100.023% ( 1900, 2900 ] 3 0.000% 100.023% ( 2900, 4400 ] 4 0.000% 100.023% ( 4400, 6600 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 226331 Average: 2.7438 StdDev: 13.08 Min: 1 Median: 1.6769 Max: 2540 Percentiles: P50: 1.68 P75: 2.23 P99: 7.53 P99.9: 14.24 P99.99: 126.28 ------------------------------------------------------ [ 0, 1 ] 12419 5.487% 5.487% # ( 1, 2 ] 148833 65.759% 71.246% ############# ( 2, 3 ] 37344 16.500% 87.746% ### ( 3, 4 ] 13297 5.875% 93.621% # ( 4, 6 ] 11189 4.944% 98.564% # ( 6, 10 ] 2576 1.138% 99.703% ( 10, 15 ] 527 0.233% 99.935% ( 15, 22 ] 64 0.028% 99.964% ( 22, 34 ] 5 0.002% 99.966% ( 51, 76 ] 4 0.002% 99.968% ( 76, 110 ] 33 0.015% 99.982% ( 110, 170 ] 64 0.028% 100.011% ( 170, 250 ] 33 0.015% 100.025% ( 250, 380 ] 26 0.011% 100.037% ( 380, 580 ] 29 0.013% 100.049% ( 580, 870 ] 9 0.004% 100.053% ( 870, 1300 ] 7 0.003% 100.057% ( 1300, 1900 ] 1 0.000% 100.057% ( 1900, 2900 ] 2 0.001% 100.058% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 250332 Average: 3.3750 StdDev: 33.82 Min: 0 Median: 1.6811 Max: 5263 Percentiles: P50: 1.68 P75: 2.25 P99: 8.53 P99.9: 178.98 P99.99: 633.17 ------------------------------------------------------ [ 0, 1 ] 16375 6.541% 6.541% # ( 1, 2 ] 159729 63.807% 70.348% ############# ( 2, 3 ] 45908 18.339% 88.687% #### ( 3, 4 ] 12950 5.173% 93.860% # ( 4, 6 ] 10576 4.225% 98.085% # ( 6, 10 ] 3627 1.449% 99.534% ( 10, 15 ] 500 0.200% 99.734% ( 15, 22 ] 84 0.034% 99.767% ( 22, 34 ] 30 0.012% 99.779% ( 34, 51 ] 3 0.001% 99.780% ( 51, 76 ] 13 0.005% 99.785% ( 76, 110 ] 74 0.030% 99.815% ( 110, 170 ] 202 0.081% 99.896% ( 170, 250 ] 95 0.038% 99.934% ( 250, 380 ] 77 0.031% 99.964% ( 380, 580 ] 57 0.023% 99.987% ( 580, 870 ] 38 0.015% 100.002% ( 870, 1300 ] 16 0.006% 100.009% ( 1300, 1900 ] 4 0.002% 100.010% ( 1900, 2900 ] 16 0.006% 100.017% ( 2900, 4400 ] 9 0.004% 100.020% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 4 read latency histogram (micros): Count: 3232 Average: 27.5687 StdDev: 190.91 Min: 1 Median: 1.7087 Max: 5302 Percentiles: P50: 1.71 P75: 2.62 P99: 558.91 P99.9: 3284.00 P99.99: 5302.00 ------------------------------------------------------ [ 0, 1 ] 322 9.963% 9.963% ## ( 1, 2 ] 1826 56.498% 66.460% ########### ( 2, 3 ] 448 13.861% 80.322% ### ( 3, 4 ] 201 6.219% 86.541% # ( 4, 6 ] 98 3.032% 89.573% # ( 6, 10 ] 58 1.795% 91.368% ( 10, 15 ] 53 1.640% 93.007% ( 15, 22 ] 4 0.124% 93.131% ( 51, 76 ] 3 0.093% 93.224% ( 76, 110 ] 66 2.042% 95.266% ( 110, 170 ] 60 1.856% 97.123% ( 170, 250 ] 24 0.743% 97.865% ( 250, 380 ] 17 0.526% 98.391% ( 380, 580 ] 22 0.681% 99.072% ( 580, 870 ] 13 0.402% 99.474% ( 870, 1300 ] 6 0.186% 99.660% ( 1300, 1900 ] 2 0.062% 99.722% ( 1900, 2900 ] 5 0.155% 99.876% ( 2900, 4400 ] 3 0.093% 99.969% ( 4400, 6600 ] 1 0.031% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 826.0500 StdDev: 931.55 Min: 88 Median: 347.5000 Max: 3325 Percentiles: P50: 347.50 P75: 1192.50 P99: 3325.00 P99.9: 3325.00 P99.99: 3325.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 4 6.667% 51.667% # ( 380, 580 ] 5 8.333% 60.000% ## ( 580, 870 ] 3 5.000% 65.000% # ( 870, 1300 ] 8 13.333% 78.333% ### ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 5 8.333% 91.667% ## ( 2900, 4400 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 12.2 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.20 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.484 H:M:S, 12.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.98 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.410 H:M:S, 13.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-18:13:02 ... thread 0: (1000000,5000000) ops and (272451.4,318974.8) ops/second in (3.670380,15.675220) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/12 3.38 GB 151.0 3.3 0.0 3.3 8.1 4.8 0.0 1.7 125.2 309.3 26.67 24.87 80 0.333 3390K 3592 0.0 0.0 L1 4/4 304.32 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 236.6 236.0 5.07 4.92 2 2.536 1218K 3165 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 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 22/0 985.54 MB 1.0 1.9 0.8 1.1 1.9 0.8 0.4 2.4 225.2 224.8 8.70 8.18 6 1.449 1988K 3738 0.0 0.0 L4 171/0 9.73 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.8 1.0 152.4 152.4 1.91 1.43 2 0.953 295K 131 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1267/16 100.92 GB 0.0 7.0 2.4 4.6 11.8 7.2 3.4 2.5 163.4 275.2 43.85 40.85 92 0.477 7276K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.0 2.4 4.6 11.8 7.2 3.3 2.5 163.4 275.2 43.85 40.85 92 0.477 7276K 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.4 4.6 7.0 2.4 0.0 0.0 240.4 240.0 29.81 28.38 24 1.242 7276K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.8 4.8 0.0 0.0 0.0 350.1 14.04 12.47 68 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.9 total, 15.7 interval Flush(GB): cumulative 4.799, interval 4.799 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.79 GB write, 759.55 MB/s write, 7.00 GB read, 450.99 MB/s read, 43.8 seconds Interval compaction: 11.79 GB write, 769.80 MB/s write, 7.00 GB read, 457.08 MB/s read, 43.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 19, interval: 21 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1549077 Average: 2.2895 StdDev: 12.40 Min: 1 Median: 1.5349 Max: 5721 Percentiles: P50: 1.53 P75: 1.90 P99: 5.77 P99.9: 11.72 P99.99: 18.00 ------------------------------------------------------ [ 0, 1 ] 209060 13.496% 13.496% ### ( 1, 2 ] 1057198 68.247% 81.743% ############## ( 2, 3 ] 171631 11.080% 92.822% ## ( 3, 4 ] 60636 3.914% 96.737% # ( 4, 6 ] 39662 2.560% 99.297% # ( 6, 10 ] 8653 0.559% 99.856% ( 10, 15 ] 2013 0.130% 99.986% ( 15, 22 ] 168 0.011% 99.996% ( 22, 34 ] 23 0.001% 99.998% ( 34, 51 ] 19 0.001% 99.999% ( 51, 76 ] 8 0.001% 100.000% ( 76, 110 ] 76 0.005% 100.005% ( 110, 170 ] 116 0.007% 100.012% ( 170, 250 ] 62 0.004% 100.016% ( 250, 380 ] 56 0.004% 100.020% ( 380, 580 ] 21 0.001% 100.021% ( 580, 870 ] 32 0.002% 100.023% ( 870, 1300 ] 19 0.001% 100.024% ( 1300, 1900 ] 9 0.001% 100.025% ( 1900, 2900 ] 5 0.000% 100.025% ( 2900, 4400 ] 9 0.001% 100.026% ( 4400, 6600 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 254705 Average: 2.7257 StdDev: 12.98 Min: 1 Median: 1.6592 Max: 2540 Percentiles: P50: 1.66 P75: 2.15 P99: 7.60 P99.9: 14.64 P99.99: 145.21 ------------------------------------------------------ [ 0, 1 ] 16157 6.343% 6.343% # ( 1, 2 ] 168679 66.225% 72.569% ############# ( 2, 3 ] 40185 15.777% 88.346% ### ( 3, 4 ] 14194 5.573% 93.918% # ( 4, 6 ] 11763 4.618% 98.537% # ( 6, 10 ] 2950 1.158% 99.695% ( 10, 15 ] 563 0.221% 99.916% ( 15, 22 ] 69 0.027% 99.943% ( 22, 34 ] 5 0.002% 99.945% ( 51, 76 ] 4 0.002% 99.947% ( 76, 110 ] 63 0.025% 99.971% ( 110, 170 ] 81 0.032% 100.003% ( 170, 250 ] 37 0.015% 100.018% ( 250, 380 ] 32 0.013% 100.030% ( 380, 580 ] 33 0.013% 100.043% ( 580, 870 ] 9 0.004% 100.047% ( 870, 1300 ] 9 0.004% 100.050% ( 1300, 1900 ] 1 0.000% 100.051% ( 1900, 2900 ] 2 0.001% 100.051% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 250332 Average: 3.3750 StdDev: 33.82 Min: 0 Median: 1.6811 Max: 5263 Percentiles: P50: 1.68 P75: 2.25 P99: 8.53 P99.9: 178.98 P99.99: 633.17 ------------------------------------------------------ [ 0, 1 ] 16375 6.541% 6.541% # ( 1, 2 ] 159729 63.807% 70.348% ############# ( 2, 3 ] 45908 18.339% 88.687% #### ( 3, 4 ] 12950 5.173% 93.860% # ( 4, 6 ] 10576 4.225% 98.085% # ( 6, 10 ] 3627 1.449% 99.534% ( 10, 15 ] 500 0.200% 99.734% ( 15, 22 ] 84 0.034% 99.767% ( 22, 34 ] 30 0.012% 99.779% ( 34, 51 ] 3 0.001% 99.780% ( 51, 76 ] 13 0.005% 99.785% ( 76, 110 ] 74 0.030% 99.815% ( 110, 170 ] 202 0.081% 99.896% ( 170, 250 ] 95 0.038% 99.934% ( 250, 380 ] 77 0.031% 99.964% ( 380, 580 ] 57 0.023% 99.987% ( 580, 870 ] 38 0.015% 100.002% ( 870, 1300 ] 16 0.006% 100.009% ( 1300, 1900 ] 4 0.002% 100.010% ( 1900, 2900 ] 16 0.006% 100.017% ( 2900, 4400 ] 9 0.004% 100.020% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 4 read latency histogram (micros): Count: 3232 Average: 27.5687 StdDev: 190.91 Min: 1 Median: 1.7087 Max: 5302 Percentiles: P50: 1.71 P75: 2.62 P99: 558.91 P99.9: 3284.00 P99.99: 5302.00 ------------------------------------------------------ [ 0, 1 ] 322 9.963% 9.963% ## ( 1, 2 ] 1826 56.498% 66.460% ########### ( 2, 3 ] 448 13.861% 80.322% ### ( 3, 4 ] 201 6.219% 86.541% # ( 4, 6 ] 98 3.032% 89.573% # ( 6, 10 ] 58 1.795% 91.368% ( 10, 15 ] 53 1.640% 93.007% ( 15, 22 ] 4 0.124% 93.131% ( 51, 76 ] 3 0.093% 93.224% ( 76, 110 ] 66 2.042% 95.266% ( 110, 170 ] 60 1.856% 97.123% ( 170, 250 ] 24 0.743% 97.865% ( 250, 380 ] 17 0.526% 98.391% ( 380, 580 ] 22 0.681% 99.072% ( 580, 870 ] 13 0.402% 99.474% ( 870, 1300 ] 6 0.186% 99.660% ( 1300, 1900 ] 2 0.062% 99.722% ( 1900, 2900 ] 5 0.155% 99.876% ( 2900, 4400 ] 3 0.093% 99.969% ( 4400, 6600 ] 1 0.031% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 826.0500 StdDev: 931.55 Min: 88 Median: 347.5000 Max: 3325 Percentiles: P50: 347.50 P75: 1192.50 P99: 3325.00 P99.9: 3325.00 P99.99: 3325.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 4 6.667% 51.667% # ( 380, 580 ] 5 8.333% 60.000% ## ( 580, 870 ] 3 5.000% 65.000% # ( 870, 1300 ] 8 13.333% 78.333% ### ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 5 8.333% 91.667% ## ( 2900, 4400 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 15.9 total, 3.7 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 309.71 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.512 H:M:S, 15.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 268.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:1.028 H:M:S, 28.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 0 2024/07/26-18:13:06 ... thread 0: (1000000,6000000) ops and (253090.5,305711.0) ops/second in (3.951156,19.626376) 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 2.64 GB 25.2 3.8 0.0 3.8 9.5 5.7 0.0 1.7 125.1 310.5 31.23 29.11 95 0.329 3965K 4206 0.0 0.0 L1 15/15 1.88 GB 0.0 3.1 2.8 0.3 3.0 2.7 0.2 1.1 236.1 234.6 13.30 12.88 3 4.435 3189K 19K 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 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 22/0 985.54 MB 1.0 1.9 0.8 1.1 1.9 0.8 0.4 2.4 225.2 224.8 8.70 8.18 6 1.449 1988K 3738 0.0 0.0 L4 171/0 9.73 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.8 1.0 152.4 152.4 1.91 1.43 2 0.953 295K 131 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1277/29 101.77 GB 0.0 9.4 4.0 5.4 15.1 9.7 3.4 2.7 170.8 272.6 56.64 53.06 108 0.524 9822K 28K 0.0 0.0 Int 0/0 0.00 KB 0.0 9.4 4.0 5.4 15.1 9.7 3.3 2.7 170.8 272.6 56.64 53.06 108 0.524 9822K 28K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 9.4 4.0 5.4 9.4 4.0 0.0 0.0 241.0 240.3 40.14 38.39 27 1.487 9822K 28K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 351.2 16.50 14.67 81 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.8 total, 19.6 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.08 GB write, 778.25 MB/s write, 9.45 GB read, 487.57 MB/s read, 56.6 seconds Interval compaction: 15.08 GB write, 786.64 MB/s write, 9.45 GB read, 492.83 MB/s read, 56.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 6, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 6, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 6, total-stops: 21, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1881815 Average: 2.2849 StdDev: 12.93 Min: 1 Median: 1.5203 Max: 5721 Percentiles: P50: 1.52 P75: 1.89 P99: 5.75 P99.9: 12.03 P99.99: 91.92 ------------------------------------------------------ [ 0, 1 ] 271633 14.435% 14.435% ### ( 1, 2 ] 1286222 68.350% 82.785% ############## ( 2, 3 ] 196541 10.444% 93.229% ## ( 3, 4 ] 69533 3.695% 96.924% # ( 4, 6 ] 44678 2.374% 99.298% ( 6, 10 ] 10401 0.553% 99.851% ( 10, 15 ] 2284 0.121% 99.972% ( 15, 22 ] 214 0.011% 99.984% ( 22, 34 ] 25 0.001% 99.985% ( 34, 51 ] 21 0.001% 99.986% ( 51, 76 ] 8 0.000% 99.986% ( 76, 110 ] 147 0.008% 99.994% ( 110, 170 ] 222 0.012% 100.006% ( 170, 250 ] 99 0.005% 100.011% ( 250, 380 ] 85 0.005% 100.016% ( 380, 580 ] 47 0.002% 100.018% ( 580, 870 ] 45 0.002% 100.021% ( 870, 1300 ] 20 0.001% 100.022% ( 1300, 1900 ] 13 0.001% 100.022% ( 1900, 2900 ] 5 0.000% 100.023% ( 2900, 4400 ] 11 0.001% 100.023% ( 4400, 6600 ] 2 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 338985 Average: 2.8288 StdDev: 17.54 Min: 0 Median: 1.6070 Max: 2843 Percentiles: P50: 1.61 P75: 1.98 P99: 7.85 P99.9: 101.46 P99.99: 287.95 ------------------------------------------------------ [ 0, 1 ] 33144 9.777% 9.777% ## ( 1, 2 ] 224635 66.267% 76.044% ############# ( 2, 3 ] 46297 13.658% 89.702% ### ( 3, 4 ] 16418 4.843% 94.545% # ( 4, 6 ] 13293 3.921% 98.467% # ( 6, 10 ] 3906 1.152% 99.619% ( 10, 15 ] 704 0.208% 99.827% ( 15, 22 ] 88 0.026% 99.853% ( 22, 34 ] 6 0.002% 99.854% ( 34, 51 ] 1 0.000% 99.855% ( 51, 76 ] 20 0.006% 99.860% ( 76, 110 ] 179 0.053% 99.913% ( 110, 170 ] 170 0.050% 99.963% ( 170, 250 ] 72 0.021% 99.985% ( 250, 380 ] 62 0.018% 100.003% ( 380, 580 ] 71 0.021% 100.024% ( 580, 870 ] 21 0.006% 100.030% ( 870, 1300 ] 17 0.005% 100.035% ( 1300, 1900 ] 8 0.002% 100.037% ( 1900, 2900 ] 4 0.001% 100.039% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 250332 Average: 3.3750 StdDev: 33.82 Min: 0 Median: 1.6811 Max: 5263 Percentiles: P50: 1.68 P75: 2.25 P99: 8.53 P99.9: 178.98 P99.99: 633.17 ------------------------------------------------------ [ 0, 1 ] 16375 6.541% 6.541% # ( 1, 2 ] 159729 63.807% 70.348% ############# ( 2, 3 ] 45908 18.339% 88.687% #### ( 3, 4 ] 12950 5.173% 93.860% # ( 4, 6 ] 10576 4.225% 98.085% # ( 6, 10 ] 3627 1.449% 99.534% ( 10, 15 ] 500 0.200% 99.734% ( 15, 22 ] 84 0.034% 99.767% ( 22, 34 ] 30 0.012% 99.779% ( 34, 51 ] 3 0.001% 99.780% ( 51, 76 ] 13 0.005% 99.785% ( 76, 110 ] 74 0.030% 99.815% ( 110, 170 ] 202 0.081% 99.896% ( 170, 250 ] 95 0.038% 99.934% ( 250, 380 ] 77 0.031% 99.964% ( 380, 580 ] 57 0.023% 99.987% ( 580, 870 ] 38 0.015% 100.002% ( 870, 1300 ] 16 0.006% 100.009% ( 1300, 1900 ] 4 0.002% 100.010% ( 1900, 2900 ] 16 0.006% 100.017% ( 2900, 4400 ] 9 0.004% 100.020% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 4 read latency histogram (micros): Count: 3232 Average: 27.5687 StdDev: 190.91 Min: 1 Median: 1.7087 Max: 5302 Percentiles: P50: 1.71 P75: 2.62 P99: 558.91 P99.9: 3284.00 P99.99: 5302.00 ------------------------------------------------------ [ 0, 1 ] 322 9.963% 9.963% ## ( 1, 2 ] 1826 56.498% 66.460% ########### ( 2, 3 ] 448 13.861% 80.322% ### ( 3, 4 ] 201 6.219% 86.541% # ( 4, 6 ] 98 3.032% 89.573% # ( 6, 10 ] 58 1.795% 91.368% ( 10, 15 ] 53 1.640% 93.007% ( 15, 22 ] 4 0.124% 93.131% ( 51, 76 ] 3 0.093% 93.224% ( 76, 110 ] 66 2.042% 95.266% ( 110, 170 ] 60 1.856% 97.123% ( 170, 250 ] 24 0.743% 97.865% ( 250, 380 ] 17 0.526% 98.391% ( 380, 580 ] 22 0.681% 99.072% ( 580, 870 ] 13 0.402% 99.474% ( 870, 1300 ] 6 0.186% 99.660% ( 1300, 1900 ] 2 0.062% 99.722% ( 1900, 2900 ] 5 0.155% 99.876% ( 2900, 4400 ] 3 0.093% 99.969% ( 4400, 6600 ] 1 0.031% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 826.0500 StdDev: 931.55 Min: 88 Median: 347.5000 Max: 3325 Percentiles: P50: 347.50 P75: 1192.50 P99: 3325.00 P99.9: 3325.00 P99.99: 3325.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 4 6.667% 51.667% # ( 380, 580 ] 5 8.333% 60.000% ## ( 580, 870 ] 3 5.000% 65.000% # ( 870, 1300 ] 8 13.333% 78.333% ### ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 5 8.333% 91.667% ## ( 2900, 4400 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 19.8 total, 4.0 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 297.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:3.799 H:M:S, 19.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 249.10 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.287 H:M:S, 32.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-18:13:10 ... thread 0: (1000000,7000000) ops and (270007.7,300043.2) ops/second in (3.703598,23.329974) 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/10 3.63 GB 151.1 5.1 0.0 5.1 11.7 6.6 0.0 1.8 133.5 307.0 39.17 36.61 116 0.338 5309K 5543 0.0 0.0 L1 15/15 1.88 GB 0.0 3.1 2.8 0.3 3.0 2.7 0.2 1.1 236.1 234.6 13.30 12.88 3 4.435 3189K 19K 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 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 22/0 985.54 MB 1.0 1.9 0.8 1.1 1.9 0.8 0.4 2.4 225.2 224.8 8.70 8.18 6 1.449 1988K 3738 0.0 0.0 L4 171/0 9.73 GB 1.0 0.3 0.3 0.0 0.3 0.3 0.8 1.0 152.4 152.4 1.91 1.43 2 0.953 295K 131 0.0 0.0 L5 1052/0 86.55 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1278/25 102.75 GB 0.0 10.7 4.0 6.7 17.4 10.6 3.4 2.6 170.3 275.2 64.58 60.55 129 0.501 11M 29K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.7 4.0 6.7 17.4 10.6 3.3 2.6 170.3 275.2 64.58 60.55 129 0.501 11M 29K 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 10.7 4.0 6.7 10.7 4.0 0.0 0.0 243.3 242.6 45.19 43.33 32 1.412 11M 29K 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 351.0 19.39 17.22 97 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.5 total, 23.3 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.35 GB write, 754.77 MB/s write, 10.74 GB read, 467.07 MB/s read, 64.6 seconds Interval compaction: 17.35 GB write, 761.62 MB/s write, 10.74 GB read, 471.30 MB/s read, 64.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 21, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 13, total-stops: 21, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2282709 Average: 2.2777 StdDev: 12.43 Min: 1 Median: 1.5191 Max: 5721 Percentiles: P50: 1.52 P75: 1.88 P99: 5.74 P99.9: 12.01 P99.99: 81.33 ------------------------------------------------------ [ 0, 1 ] 329310 14.426% 14.426% ### ( 1, 2 ] 1564335 68.530% 82.956% ############## ( 2, 3 ] 237210 10.392% 93.348% ## ( 3, 4 ] 83074 3.639% 96.987% # ( 4, 6 ] 52724 2.310% 99.297% ( 6, 10 ] 12626 0.553% 99.850% ( 10, 15 ] 2856 0.125% 99.975% ( 15, 22 ] 257 0.011% 99.986% ( 22, 34 ] 30 0.001% 99.987% ( 34, 51 ] 23 0.001% 99.988% ( 51, 76 ] 11 0.000% 99.989% ( 76, 110 ] 164 0.007% 99.996% ( 110, 170 ] 270 0.012% 100.008% ( 170, 250 ] 109 0.005% 100.013% ( 250, 380 ] 98 0.004% 100.017% ( 380, 580 ] 59 0.003% 100.020% ( 580, 870 ] 54 0.002% 100.022% ( 870, 1300 ] 26 0.001% 100.023% ( 1300, 1900 ] 17 0.001% 100.024% ( 1900, 2900 ] 7 0.000% 100.024% ( 2900, 4400 ] 11 0.000% 100.025% ( 4400, 6600 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 431212 Average: 2.7469 StdDev: 15.96 Min: 0 Median: 1.5920 Max: 2843 Percentiles: P50: 1.59 P75: 1.96 P99: 7.91 P99.9: 99.95 P99.99: 299.92 ------------------------------------------------------ [ 0, 1 ] 44377 10.291% 10.291% ## ( 1, 2 ] 289239 67.076% 77.367% ############# ( 2, 3 ] 56002 12.987% 90.354% ### ( 3, 4 ] 19307 4.477% 94.832% # ( 4, 6 ] 15460 3.585% 98.417% # ( 6, 10 ] 5259 1.220% 99.636% ( 10, 15 ] 830 0.192% 99.829% ( 15, 22 ] 109 0.025% 99.854% ( 22, 34 ] 7 0.002% 99.856% ( 34, 51 ] 1 0.000% 99.856% ( 51, 76 ] 21 0.005% 99.861% ( 76, 110 ] 241 0.056% 99.917% ( 110, 170 ] 211 0.049% 99.966% ( 170, 250 ] 79 0.018% 99.984% ( 250, 380 ] 70 0.016% 100.000% ( 380, 580 ] 78 0.018% 100.018% ( 580, 870 ] 24 0.006% 100.024% ( 870, 1300 ] 17 0.004% 100.028% ( 1300, 1900 ] 8 0.002% 100.030% ( 1900, 2900 ] 4 0.001% 100.031% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 250332 Average: 3.3750 StdDev: 33.82 Min: 0 Median: 1.6811 Max: 5263 Percentiles: P50: 1.68 P75: 2.25 P99: 8.53 P99.9: 178.98 P99.99: 633.17 ------------------------------------------------------ [ 0, 1 ] 16375 6.541% 6.541% # ( 1, 2 ] 159729 63.807% 70.348% ############# ( 2, 3 ] 45908 18.339% 88.687% #### ( 3, 4 ] 12950 5.173% 93.860% # ( 4, 6 ] 10576 4.225% 98.085% # ( 6, 10 ] 3627 1.449% 99.534% ( 10, 15 ] 500 0.200% 99.734% ( 15, 22 ] 84 0.034% 99.767% ( 22, 34 ] 30 0.012% 99.779% ( 34, 51 ] 3 0.001% 99.780% ( 51, 76 ] 13 0.005% 99.785% ( 76, 110 ] 74 0.030% 99.815% ( 110, 170 ] 202 0.081% 99.896% ( 170, 250 ] 95 0.038% 99.934% ( 250, 380 ] 77 0.031% 99.964% ( 380, 580 ] 57 0.023% 99.987% ( 580, 870 ] 38 0.015% 100.002% ( 870, 1300 ] 16 0.006% 100.009% ( 1300, 1900 ] 4 0.002% 100.010% ( 1900, 2900 ] 16 0.006% 100.017% ( 2900, 4400 ] 9 0.004% 100.020% ( 4400, 6600 ] 1 0.000% 100.021% ** Level 4 read latency histogram (micros): Count: 3232 Average: 27.5687 StdDev: 190.91 Min: 1 Median: 1.7087 Max: 5302 Percentiles: P50: 1.71 P75: 2.62 P99: 558.91 P99.9: 3284.00 P99.99: 5302.00 ------------------------------------------------------ [ 0, 1 ] 322 9.963% 9.963% ## ( 1, 2 ] 1826 56.498% 66.460% ########### ( 2, 3 ] 448 13.861% 80.322% ### ( 3, 4 ] 201 6.219% 86.541% # ( 4, 6 ] 98 3.032% 89.573% # ( 6, 10 ] 58 1.795% 91.368% ( 10, 15 ] 53 1.640% 93.007% ( 15, 22 ] 4 0.124% 93.131% ( 51, 76 ] 3 0.093% 93.224% ( 76, 110 ] 66 2.042% 95.266% ( 110, 170 ] 60 1.856% 97.123% ( 170, 250 ] 24 0.743% 97.865% ( 250, 380 ] 17 0.526% 98.391% ( 380, 580 ] 22 0.681% 99.072% ( 580, 870 ] 13 0.402% 99.474% ( 870, 1300 ] 6 0.186% 99.660% ( 1300, 1900 ] 2 0.062% 99.722% ( 1900, 2900 ] 5 0.155% 99.876% ( 2900, 4400 ] 3 0.093% 99.969% ( 4400, 6600 ] 1 0.031% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 826.0500 StdDev: 931.55 Min: 88 Median: 347.5000 Max: 3325 Percentiles: P50: 347.50 P75: 1192.50 P99: 3325.00 P99.9: 3325.00 P99.99: 3325.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 4 6.667% 51.667% # ( 380, 580 ] 5 8.333% 60.000% ## ( 580, 870 ] 3 5.000% 65.000% # ( 870, 1300 ] 8 13.333% 78.333% ### ( 1300, 1900 ] 3 5.000% 83.333% # ( 1900, 2900 ] 5 8.333% 91.667% ## ( 2900, 4400 ] 5 8.333% 100.000% ## ** DB Stats ** Uptime(secs): 23.5 total, 3.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 292.62 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.810 H:M:S, 20.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 265.74 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.011 H:M:S, 27.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/26-18:13:28 ... thread 0: (1000000,8000000) ops and (54037.3,191224.2) ops/second in (18.505737,41.835711) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 2.39 GB 25.2 6.9 0.0 6.9 14.4 7.6 0.0 1.9 143.1 300.0 49.31 45.69 133 0.371 7163K 13K 0.0 0.0 L1 20/20 1.89 GB 0.0 7.1 4.9 2.2 7.0 4.8 0.2 1.4 230.4 227.6 31.55 29.99 4 7.886 7379K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.0 2.0 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 18/0 989.60 MB 1.0 4.4 2.7 1.7 4.4 2.7 0.6 1.6 160.3 159.3 28.33 19.98 18 1.574 4612K 27K 0.0 0.0 L4 175/0 9.74 GB 1.0 2.4 2.3 0.1 2.4 2.3 0.8 1.0 150.5 150.1 16.61 11.42 30 0.554 2486K 3102 0.0 0.0 L5 1076/0 88.58 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1300/28 103.57 GB 0.0 21.2 10.1 11.1 28.7 17.6 7.7 3.8 170.8 230.6 127.29 108.54 187 0.681 22M 130K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.2 10.1 11.1 28.7 17.6 7.6 3.8 170.8 230.6 127.29 108.54 187 0.681 22M 130K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.2 10.1 11.1 21.1 10.0 0.0 0.0 207.5 206.3 104.76 88.87 76 1.378 22M 130K 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 343.9 22.53 19.67 111 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 42.0 total, 41.8 interval Flush(GB): cumulative 7.567, interval 7.567 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 28.67 GB write, 698.13 MB/s write, 21.23 GB read, 517.00 MB/s read, 127.3 seconds Interval compaction: 28.67 GB write, 701.66 MB/s write, 21.23 GB read, 519.62 MB/s read, 127.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 23, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 53, total-stops: 23, interval: 76 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3424111 Average: 2.6697 StdDev: 26.61 Min: 1 Median: 1.5144 Max: 10755 Percentiles: P50: 1.51 P75: 1.89 P99: 6.23 P99.9: 113.01 P99.99: 311.11 ------------------------------------------------------ [ 0, 1 ] 527574 15.408% 15.408% ### ( 1, 2 ] 2302523 67.244% 82.652% ############# ( 2, 3 ] 346632 10.123% 92.775% ## ( 3, 4 ] 122551 3.579% 96.354% # ( 4, 6 ] 89189 2.605% 98.959% # ( 6, 10 ] 24444 0.714% 99.673% ( 10, 15 ] 4760 0.139% 99.812% ( 15, 22 ] 665 0.019% 99.831% ( 22, 34 ] 48 0.001% 99.833% ( 34, 51 ] 31 0.001% 99.834% ( 51, 76 ] 93 0.003% 99.836% ( 76, 110 ] 2064 0.060% 99.897% ( 110, 170 ] 2292 0.067% 99.964% ( 170, 250 ] 686 0.020% 99.984% ( 250, 380 ] 465 0.014% 99.997% ( 380, 580 ] 363 0.011% 100.008% ( 580, 870 ] 192 0.006% 100.013% ( 870, 1300 ] 99 0.003% 100.016% ( 1300, 1900 ] 46 0.001% 100.018% ( 1900, 2900 ] 48 0.001% 100.019% ( 2900, 4400 ] 60 0.002% 100.021% ( 4400, 6600 ] 25 0.001% 100.022% ( 6600, 9900 ] 1 0.000% 100.022% ( 9900, 14000 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 1285005 Average: 4.7971 StdDev: 74.38 Min: 0 Median: 1.6614 Max: 10001 Percentiles: P50: 1.66 P75: 2.36 P99: 8.92 P99.9: 120.01 P99.99: 368.52 ------------------------------------------------------ [ 0, 1 ] 146403 11.393% 11.393% ## ( 1, 2 ] 750075 58.371% 69.765% ############ ( 2, 3 ] 187596 14.599% 84.363% ### ( 3, 4 ] 85001 6.615% 90.978% # ( 4, 6 ] 86522 6.733% 97.711% # ( 6, 10 ] 22647 1.762% 99.474% ( 10, 15 ] 3841 0.299% 99.773% ( 15, 22 ] 566 0.044% 99.817% ( 22, 34 ] 36 0.003% 99.820% ( 34, 51 ] 7 0.001% 99.820% ( 51, 76 ] 100 0.008% 99.828% ( 76, 110 ] 808 0.063% 99.891% ( 110, 170 ] 707 0.055% 99.946% ( 170, 250 ] 263 0.020% 99.966% ( 250, 380 ] 334 0.026% 99.992% ( 380, 580 ] 456 0.035% 100.028% ( 580, 870 ] 442 0.034% 100.062% ( 870, 1300 ] 330 0.026% 100.088% ( 1300, 1900 ] 150 0.012% 100.100% ( 1900, 2900 ] 157 0.012% 100.112% ( 2900, 4400 ] 185 0.014% 100.126% ( 4400, 6600 ] 65 0.005% 100.131% ( 6600, 9900 ] 15 0.001% 100.132% ( 9900, 14000 ] 1 0.000% 100.132% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 939155 Average: 4.1082 StdDev: 49.92 Min: 0 Median: 1.9156 Max: 7967 Percentiles: P50: 1.92 P75: 2.94 P99: 8.52 P99.9: 13.54 P99.99: 15.83 ------------------------------------------------------ [ 0, 1 ] 23134 2.463% 2.463% ( 1, 2 ] 487576 51.916% 54.380% ########## ( 2, 3 ] 206433 21.981% 76.360% #### ( 3, 4 ] 98889 10.530% 86.890% ## ( 4, 6 ] 102630 10.928% 97.818% ## ( 6, 10 ] 17604 1.874% 99.692% ( 10, 15 ] 2755 0.293% 99.986% ( 15, 22 ] 338 0.036% 100.022% ( 22, 34 ] 41 0.004% 100.026% ( 34, 51 ] 12 0.001% 100.027% ( 51, 76 ] 39 0.004% 100.032% ( 76, 110 ] 105 0.011% 100.043% ( 110, 170 ] 288 0.031% 100.073% ( 170, 250 ] 240 0.026% 100.099% ( 250, 380 ] 264 0.028% 100.127% ( 380, 580 ] 221 0.024% 100.151% ( 580, 870 ] 195 0.021% 100.171% ( 870, 1300 ] 123 0.013% 100.184% ( 1300, 1900 ] 51 0.005% 100.190% ( 1900, 2900 ] 49 0.005% 100.195% ( 2900, 4400 ] 82 0.009% 100.204% ( 4400, 6600 ] 13 0.001% 100.205% ( 6600, 9900 ] 3 0.000% 100.206% ** Level 4 read latency histogram (micros): Count: 31356 Average: 65.7399 StdDev: 342.41 Min: 1 Median: 1.9658 Max: 8272 Percentiles: P50: 1.97 P75: 3.25 P99: 1603.26 P99.9: 4231.35 P99.99: 6461.20 ------------------------------------------------------ [ 0, 1 ] 906 2.889% 2.889% # ( 1, 2 ] 15295 48.779% 51.668% ########## ( 2, 3 ] 6400 20.411% 72.079% #### ( 3, 4 ] 3722 11.870% 83.949% ## ( 4, 6 ] 2064 6.582% 90.531% # ( 6, 10 ] 716 2.283% 92.815% ( 10, 15 ] 126 0.402% 93.217% ( 15, 22 ] 15 0.048% 93.264% ( 22, 34 ] 10 0.032% 93.296% ( 34, 51 ] 2 0.006% 93.303% ( 51, 76 ] 15 0.048% 93.351% ( 76, 110 ] 78 0.249% 93.599% ( 110, 170 ] 106 0.338% 93.937% ( 170, 250 ] 145 0.462% 94.400% ( 250, 380 ] 189 0.603% 95.003% ( 380, 580 ] 391 1.247% 96.250% ( 580, 870 ] 449 1.432% 97.681% ( 870, 1300 ] 326 1.040% 98.721% ( 1300, 1900 ] 173 0.552% 99.273% ( 1900, 2900 ] 107 0.341% 99.614% ( 2900, 4400 ] 101 0.322% 99.936% ( 4400, 6600 ] 18 0.057% 99.994% ( 6600, 9900 ] 6 0.019% 100.013% ** Level 5 read latency histogram (micros): Count: 180 Average: 1296.6278 StdDev: 1405.96 Min: 79 Median: 743.1250 Max: 8700 Percentiles: P50: 743.12 P75: 2108.33 P99: 6160.00 P99.9: 8700.00 P99.99: 8700.00 ------------------------------------------------------ ( 76, 110 ] 11 6.111% 6.111% # ( 110, 170 ] 20 11.111% 17.222% ## ( 170, 250 ] 17 9.444% 26.667% ## ( 250, 380 ] 17 9.444% 36.111% ## ( 380, 580 ] 16 8.889% 45.000% ## ( 580, 870 ] 16 8.889% 53.889% ## ( 870, 1300 ] 22 12.222% 66.111% ## ( 1300, 1900 ] 11 6.111% 72.222% # ( 1900, 2900 ] 24 13.333% 85.556% ### ( 2900, 4400 ] 21 11.667% 97.222% ## ( 4400, 6600 ] 4 2.222% 99.444% ( 6600, 9900 ] 1 0.556% 100.000% ** DB Stats ** Uptime(secs): 42.0 total, 18.5 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 187.25 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.209 H:M:S, 48.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 53.18 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:15.399 H:M:S, 83.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-18:13:31 ... thread 0: (1000000,9000000) ops and (329239.0,200566.0) ops/second in (3.037307,44.873018) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/8 3.31 GB 113.3 8.0 0.0 8.0 16.5 8.5 0.0 1.9 145.5 299.8 56.27 52.28 150 0.375 8314K 14K 0.0 0.0 L1 20/20 1.89 GB 0.0 7.1 4.9 2.2 7.0 4.8 0.2 1.4 230.4 227.6 31.55 29.99 4 7.886 7379K 85K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.0 2.0 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 18/0 989.60 MB 1.0 4.4 2.7 1.7 4.4 2.7 0.6 1.6 160.3 159.3 28.33 19.98 18 1.574 4612K 27K 0.0 0.0 L4 175/0 9.74 GB 1.0 2.4 2.3 0.1 2.4 2.3 0.8 1.0 150.5 150.1 16.61 11.42 30 0.554 2486K 3102 0.0 0.0 L5 1076/0 88.58 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1301/28 104.50 GB 0.0 22.3 10.1 12.2 30.7 18.5 7.7 3.6 170.4 234.1 134.26 115.13 204 0.658 23M 131K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.3 10.1 12.2 30.7 18.5 7.6 3.6 170.4 234.1 134.26 115.13 204 0.658 23M 131K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.3 10.1 12.2 22.2 10.0 0.0 0.0 209.8 208.6 109.02 93.05 80 1.363 23M 131K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 344.5 25.24 22.07 124 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 45.1 total, 44.9 interval Flush(GB): cumulative 8.490, interval 8.490 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: 30.70 GB write, 697.18 MB/s write, 22.34 GB read, 507.33 MB/s read, 134.3 seconds Interval compaction: 30.70 GB write, 700.47 MB/s write, 22.34 GB read, 509.72 MB/s read, 134.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 36, pending-compaction-bytes-stops: 0, total-delays: 53, total-stops: 27, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3752515 Average: 2.6335 StdDev: 25.62 Min: 1 Median: 1.5166 Max: 10755 Percentiles: P50: 1.52 P75: 1.89 P99: 6.10 P99.9: 105.28 P99.99: 278.36 ------------------------------------------------------ [ 0, 1 ] 569275 15.170% 15.170% ### ( 1, 2 ] 2529945 67.420% 82.590% ############# ( 2, 3 ] 384180 10.238% 92.828% ## ( 3, 4 ] 133973 3.570% 96.399% # ( 4, 6 ] 96920 2.583% 98.981% # ( 6, 10 ] 26614 0.709% 99.691% ( 10, 15 ] 5196 0.138% 99.829% ( 15, 22 ] 700 0.019% 99.848% ( 22, 34 ] 52 0.001% 99.849% ( 34, 51 ] 34 0.001% 99.850% ( 51, 76 ] 96 0.003% 99.853% ( 76, 110 ] 2065 0.055% 99.908% ( 110, 170 ] 2299 0.061% 99.969% ( 170, 250 ] 689 0.018% 99.987% ( 250, 380 ] 471 0.013% 100.000% ( 380, 580 ] 363 0.010% 100.010% ( 580, 870 ] 207 0.006% 100.015% ( 870, 1300 ] 101 0.003% 100.018% ( 1300, 1900 ] 46 0.001% 100.019% ( 1900, 2900 ] 49 0.001% 100.020% ( 2900, 4400 ] 60 0.002% 100.022% ( 4400, 6600 ] 26 0.001% 100.023% ( 6600, 9900 ] 1 0.000% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1373542 Average: 4.6678 StdDev: 72.06 Min: 0 Median: 1.6549 Max: 10001 Percentiles: P50: 1.65 P75: 2.32 P99: 8.90 P99.9: 121.83 P99.99: 373.61 ------------------------------------------------------ [ 0, 1 ] 155182 11.298% 11.298% ## ( 1, 2 ] 811741 59.098% 70.396% ############ ( 2, 3 ] 198684 14.465% 84.861% ### ( 3, 4 ] 87912 6.400% 91.262% # ( 4, 6 ] 88830 6.467% 97.729% # ( 6, 10 ] 24066 1.752% 99.481% ( 10, 15 ] 3934 0.286% 99.768% ( 15, 22 ] 574 0.042% 99.809% ( 22, 34 ] 38 0.003% 99.812% ( 34, 51 ] 9 0.001% 99.813% ( 51, 76 ] 131 0.010% 99.822% ( 76, 110 ] 918 0.067% 99.889% ( 110, 170 ] 758 0.055% 99.944% ( 170, 250 ] 292 0.021% 99.966% ( 250, 380 ] 353 0.026% 99.991% ( 380, 580 ] 469 0.034% 100.025% ( 580, 870 ] 446 0.032% 100.058% ( 870, 1300 ] 333 0.024% 100.082% ( 1300, 1900 ] 150 0.011% 100.093% ( 1900, 2900 ] 157 0.011% 100.104% ( 2900, 4400 ] 186 0.014% 100.118% ( 4400, 6600 ] 65 0.005% 100.123% ( 6600, 9900 ] 15 0.001% 100.124% ( 9900, 14000 ] 1 0.000% 100.124% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 939155 Average: 4.1082 StdDev: 49.92 Min: 0 Median: 1.9156 Max: 7967 Percentiles: P50: 1.92 P75: 2.94 P99: 8.52 P99.9: 13.54 P99.99: 15.83 ------------------------------------------------------ [ 0, 1 ] 23134 2.463% 2.463% ( 1, 2 ] 487576 51.916% 54.380% ########## ( 2, 3 ] 206433 21.981% 76.360% #### ( 3, 4 ] 98889 10.530% 86.890% ## ( 4, 6 ] 102630 10.928% 97.818% ## ( 6, 10 ] 17604 1.874% 99.692% ( 10, 15 ] 2755 0.293% 99.986% ( 15, 22 ] 338 0.036% 100.022% ( 22, 34 ] 41 0.004% 100.026% ( 34, 51 ] 12 0.001% 100.027% ( 51, 76 ] 39 0.004% 100.032% ( 76, 110 ] 105 0.011% 100.043% ( 110, 170 ] 288 0.031% 100.073% ( 170, 250 ] 240 0.026% 100.099% ( 250, 380 ] 264 0.028% 100.127% ( 380, 580 ] 221 0.024% 100.151% ( 580, 870 ] 195 0.021% 100.171% ( 870, 1300 ] 123 0.013% 100.184% ( 1300, 1900 ] 51 0.005% 100.190% ( 1900, 2900 ] 49 0.005% 100.195% ( 2900, 4400 ] 82 0.009% 100.204% ( 4400, 6600 ] 13 0.001% 100.205% ( 6600, 9900 ] 3 0.000% 100.206% ** Level 4 read latency histogram (micros): Count: 31356 Average: 65.7399 StdDev: 342.41 Min: 1 Median: 1.9658 Max: 8272 Percentiles: P50: 1.97 P75: 3.25 P99: 1603.26 P99.9: 4231.35 P99.99: 6461.20 ------------------------------------------------------ [ 0, 1 ] 906 2.889% 2.889% # ( 1, 2 ] 15295 48.779% 51.668% ########## ( 2, 3 ] 6400 20.411% 72.079% #### ( 3, 4 ] 3722 11.870% 83.949% ## ( 4, 6 ] 2064 6.582% 90.531% # ( 6, 10 ] 716 2.283% 92.815% ( 10, 15 ] 126 0.402% 93.217% ( 15, 22 ] 15 0.048% 93.264% ( 22, 34 ] 10 0.032% 93.296% ( 34, 51 ] 2 0.006% 93.303% ( 51, 76 ] 15 0.048% 93.351% ( 76, 110 ] 78 0.249% 93.599% ( 110, 170 ] 106 0.338% 93.937% ( 170, 250 ] 145 0.462% 94.400% ( 250, 380 ] 189 0.603% 95.003% ( 380, 580 ] 391 1.247% 96.250% ( 580, 870 ] 449 1.432% 97.681% ( 870, 1300 ] 326 1.040% 98.721% ( 1300, 1900 ] 173 0.552% 99.273% ( 1900, 2900 ] 107 0.341% 99.614% ( 2900, 4400 ] 101 0.322% 99.936% ( 4400, 6600 ] 18 0.057% 99.994% ( 6600, 9900 ] 6 0.019% 100.013% ** Level 5 read latency histogram (micros): Count: 180 Average: 1296.6278 StdDev: 1405.96 Min: 79 Median: 743.1250 Max: 8700 Percentiles: P50: 743.12 P75: 2108.33 P99: 6160.00 P99.9: 8700.00 P99.99: 8700.00 ------------------------------------------------------ ( 76, 110 ] 11 6.111% 6.111% # ( 110, 170 ] 20 11.111% 17.222% ## ( 170, 250 ] 17 9.444% 26.667% ## ( 250, 380 ] 17 9.444% 36.111% ## ( 380, 580 ] 16 8.889% 45.000% ## ( 580, 870 ] 16 8.889% 53.889% ## ( 870, 1300 ] 22 12.222% 66.111% ## ( 1300, 1900 ] 11 6.111% 72.222% # ( 1900, 2900 ] 24 13.333% 85.556% ### ( 2900, 4400 ] 21 11.667% 97.222% ## ( 4400, 6600 ] 4 2.222% 99.444% ( 6600, 9900 ] 1 0.556% 100.000% ** DB Stats ** Uptime(secs): 45.1 total, 3.0 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 196.46 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.651 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, 324.03 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.442 H:M:S, 14.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/26-18:13:46 ... thread 0: (1000000,10000000) ops and (69260.3,168601.9) ops/second in (14.438294,59.311312) 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/8 2.39 GB 0.0 10.5 0.0 10.5 19.9 9.4 0.0 2.1 153.6 292.4 69.71 64.41 168 0.415 10M 26K 0.0 0.0 L1 15/15 1.79 GB 0.0 10.9 6.8 4.1 10.8 6.7 0.2 1.6 222.7 220.1 50.04 46.03 5 10.007 9353K 85K 0.0 0.0 L2 1/1 128.78 MB 0.0 0.4 0.2 0.2 0.4 0.2 5.0 2.0 251.8 251.7 1.50 1.45 2 0.750 383K 201 0.0 0.0 L3 27/7 1.52 GB 1.0 6.5 4.1 2.5 6.5 4.0 1.0 1.6 151.3 150.3 44.28 29.82 27 1.640 6628K 41K 0.0 0.0 L4 176/12 9.99 GB 1.0 4.2 3.6 0.7 4.2 3.5 0.9 1.2 152.7 152.0 28.27 19.74 43 0.658 4292K 9718 0.0 0.0 L5 1088/0 89.57 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 1315/43 105.39 GB 0.0 32.5 14.6 17.8 41.7 23.9 11.1 4.4 171.5 220.5 193.80 161.45 245 0.791 31M 163K 0.0 0.0 Int 0/0 0.00 KB 0.0 32.5 14.6 17.8 41.7 23.9 11.0 4.4 171.5 220.5 193.80 161.45 245 0.791 31M 163K 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 32.5 14.6 17.8 32.2 14.4 0.0 0.0 201.0 199.6 165.43 136.79 107 1.546 31M 163K 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 342.0 28.37 24.66 138 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 59.5 total, 59.3 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 41.72 GB write, 717.76 MB/s write, 32.47 GB read, 558.53 MB/s read, 193.8 seconds Interval compaction: 41.72 GB write, 720.32 MB/s write, 32.47 GB read, 560.52 MB/s read, 193.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 32, pending-compaction-bytes-delays: 63, pending-compaction-bytes-stops: 0, total-delays: 80, total-stops: 32, interval: 112 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4730775 Average: 2.9035 StdDev: 28.88 Min: 1 Median: 1.5267 Max: 10755 Percentiles: P50: 1.53 P75: 1.90 P99: 7.35 P99.9: 147.82 P99.99: 407.07 ------------------------------------------------------ [ 0, 1 ] 701407 14.826% 14.826% ### ( 1, 2 ] 3159463 66.785% 81.612% ############# ( 2, 3 ] 497905 10.525% 92.137% ## ( 3, 4 ] 177485 3.752% 95.888% # ( 4, 6 ] 134039 2.833% 98.722% # ( 6, 10 ] 39030 0.825% 99.547% ( 10, 15 ] 6904 0.146% 99.693% ( 15, 22 ] 911 0.019% 99.712% ( 22, 34 ] 63 0.001% 99.713% ( 34, 51 ] 39 0.001% 99.714% ( 51, 76 ] 123 0.003% 99.717% ( 76, 110 ] 5366 0.113% 99.830% ( 110, 170 ] 5253 0.111% 99.941% ( 170, 250 ] 1324 0.028% 99.969% ( 250, 380 ] 895 0.019% 99.988% ( 380, 580 ] 716 0.015% 100.003% ( 580, 870 ] 370 0.008% 100.011% ( 870, 1300 ] 178 0.004% 100.015% ( 1300, 1900 ] 72 0.002% 100.016% ( 1900, 2900 ] 75 0.002% 100.018% ( 2900, 4400 ] 95 0.002% 100.020% ( 4400, 6600 ] 37 0.001% 100.021% ( 6600, 9900 ] 3 0.000% 100.021% ( 9900, 14000 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 2187242 Average: 4.8598 StdDev: 71.45 Min: 0 Median: 1.6814 Max: 11408 Percentiles: P50: 1.68 P75: 2.41 P99: 9.17 P99.9: 159.09 P99.99: 457.82 ------------------------------------------------------ [ 0, 1 ] 215610 9.858% 9.858% ## ( 1, 2 ] 1288624 58.915% 68.773% ############ ( 2, 3 ] 333919 15.267% 84.040% ### ( 3, 4 ] 147045 6.723% 90.763% # ( 4, 6 ] 146610 6.703% 97.466% # ( 6, 10 ] 42385 1.938% 99.403% ( 10, 15 ] 6558 0.300% 99.703% ( 15, 22 ] 942 0.043% 99.746% ( 22, 34 ] 63 0.003% 99.749% ( 34, 51 ] 15 0.001% 99.750% ( 51, 76 ] 192 0.009% 99.759% ( 76, 110 ] 1751 0.080% 99.839% ( 110, 170 ] 1640 0.075% 99.914% ( 170, 250 ] 610 0.028% 99.942% ( 250, 380 ] 728 0.033% 99.975% ( 380, 580 ] 854 0.039% 100.014% ( 580, 870 ] 797 0.036% 100.050% ( 870, 1300 ] 586 0.027% 100.077% ( 1300, 1900 ] 258 0.012% 100.089% ( 1900, 2900 ] 269 0.012% 100.101% ( 2900, 4400 ] 298 0.014% 100.115% ( 4400, 6600 ] 92 0.004% 100.119% ( 6600, 9900 ] 20 0.001% 100.120% ( 9900, 14000 ] 2 0.000% 100.120% ** Level 2 read latency histogram (micros): Count: 124229 Average: 2.2502 StdDev: 14.62 Min: 0 Median: 1.4601 Max: 4040 Percentiles: P50: 1.46 P75: 1.85 P99: 5.92 P99.9: 14.33 P99.99: 353.57 ------------------------------------------------------ [ 0, 1 ] 25028 20.147% 20.147% #### ( 1, 2 ] 80611 64.889% 85.036% ############# ( 2, 3 ] 10683 8.599% 93.635% ## ( 3, 4 ] 4218 3.395% 97.030% # ( 4, 6 ] 2547 2.050% 99.081% ( 6, 10 ] 926 0.745% 99.826% ( 10, 15 ] 106 0.085% 99.911% ( 15, 22 ] 15 0.012% 99.924% ( 22, 34 ] 7 0.006% 99.929% ( 34, 51 ] 5 0.004% 99.933% ( 51, 76 ] 6 0.005% 99.938% ( 76, 110 ] 23 0.019% 99.957% ( 110, 170 ] 31 0.025% 99.981% ( 170, 250 ] 5 0.004% 99.986% ( 250, 380 ] 7 0.006% 99.991% ( 380, 580 ] 3 0.002% 99.994% ( 580, 870 ] 4 0.003% 99.997% ( 870, 1300 ] 2 0.002% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1470072 Average: 4.4531 StdDev: 56.40 Min: 0 Median: 1.9457 Max: 7967 Percentiles: P50: 1.95 P75: 2.99 P99: 8.71 P99.9: 13.85 P99.99: 17.70 ------------------------------------------------------ [ 0, 1 ] 28598 1.945% 1.945% ( 1, 2 ] 746971 50.812% 52.757% ########## ( 2, 3 ] 330885 22.508% 75.265% ##### ( 3, 4 ] 160598 10.924% 86.190% ## ( 4, 6 ] 168411 11.456% 97.646% ## ( 6, 10 ] 29411 2.001% 99.646% ( 10, 15 ] 4839 0.329% 99.976% ( 15, 22 ] 550 0.037% 100.013% ( 22, 34 ] 60 0.004% 100.017% ( 34, 51 ] 16 0.001% 100.018% ( 51, 76 ] 73 0.005% 100.023% ( 76, 110 ] 141 0.010% 100.033% ( 110, 170 ] 356 0.024% 100.057% ( 170, 250 ] 327 0.022% 100.079% ( 250, 380 ] 406 0.028% 100.107% ( 380, 580 ] 436 0.030% 100.136% ( 580, 870 ] 376 0.026% 100.162% ( 870, 1300 ] 278 0.019% 100.181% ( 1300, 1900 ] 132 0.009% 100.190% ( 1900, 2900 ] 102 0.007% 100.197% ( 2900, 4400 ] 151 0.010% 100.207% ( 4400, 6600 ] 33 0.002% 100.209% ( 6600, 9900 ] 4 0.000% 100.210% ** Level 4 read latency histogram (micros): Count: 175275 Average: 28.2108 StdDev: 216.88 Min: 1 Median: 2.0250 Max: 8272 Percentiles: P50: 2.02 P75: 3.26 P99: 808.94 P99.9: 2806.63 P99.99: 3781.98 ------------------------------------------------------ [ 0, 1 ] 2758 1.574% 1.574% ( 1, 2 ] 83893 47.864% 49.437% ########## ( 2, 3 ] 39488 22.529% 71.966% ##### ( 3, 4 ] 20075 11.453% 83.420% ## ( 4, 6 ] 18577 10.599% 94.019% ## ( 6, 10 ] 4990 2.847% 96.865% # ( 10, 15 ] 882 0.503% 97.369% ( 15, 22 ] 128 0.073% 97.442% ( 22, 34 ] 19 0.011% 97.453% ( 34, 51 ] 7 0.004% 97.457% ( 51, 76 ] 27 0.015% 97.472% ( 76, 110 ] 100 0.057% 97.529% ( 110, 170 ] 205 0.117% 97.646% ( 170, 250 ] 323 0.184% 97.830% ( 250, 380 ] 456 0.260% 98.090% ( 380, 580 ] 819 0.467% 98.558% ( 580, 870 ] 982 0.560% 99.118% ( 870, 1300 ] 721 0.411% 99.529% ( 1300, 1900 ] 414 0.236% 99.766% ( 1900, 2900 ] 260 0.148% 99.914% ( 2900, 4400 ] 227 0.130% 100.043% ( 4400, 6600 ] 39 0.022% 100.066% ( 6600, 9900 ] 9 0.005% 100.071% ** Level 5 read latency histogram (micros): Count: 257 Average: 1443.6576 StdDev: 1466.13 Min: 79 Median: 877.4138 Max: 8700 Percentiles: P50: 877.41 P75: 2365.28 P99: 6254.60 P99.9: 8700.00 P99.99: 8700.00 ------------------------------------------------------ ( 76, 110 ] 11 4.280% 4.280% # ( 110, 170 ] 22 8.560% 12.840% ## ( 170, 250 ] 23 8.949% 21.790% ## ( 250, 380 ] 27 10.506% 32.296% ## ( 380, 580 ] 26 10.117% 42.412% ## ( 580, 870 ] 19 7.393% 49.805% # ( 870, 1300 ] 29 11.284% 61.089% ## ( 1300, 1900 ] 19 7.393% 68.482% # ( 1900, 2900 ] 36 14.008% 82.490% ### ( 2900, 4400 ] 34 13.230% 95.720% ### ( 4400, 6600 ] 10 3.891% 99.611% # ( 6600, 9900 ] 1 0.389% 100.000% ** DB Stats ** Uptime(secs): 59.5 total, 14.4 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 165.34 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:32.197 H:M:S, 54.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 68.17 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:11.546 H:M:S, 80.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 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.936 micros/op 168474 ops/sec 60.003 seconds 10108999 operations; 163.2 MB/s Microseconds per write: Count: 10108999 Average: 5.9356 StdDev: 290.52 Min: 1 Median: 1.7495 Max: 358930 Percentiles: P50: 1.75 P75: 2.72 P99: 8.70 P99.9: 1160.75 P99.99: 2712.79 ------------------------------------------------------ [ 0, 1 ] 1295795 12.818% 12.818% ### ( 1, 2 ] 5014811 49.607% 62.426% ########## ( 2, 3 ] 1768555 17.495% 79.920% ### ( 3, 4 ] 1365750 13.510% 93.431% ### ( 4, 6 ] 494140 4.888% 98.319% # ( 6, 10 ] 101955 1.009% 99.327% ( 10, 15 ] 25885 0.256% 99.583% ( 15, 22 ] 7133 0.071% 99.654% ( 22, 34 ] 1728 0.017% 99.671% ( 34, 51 ] 181 0.002% 99.673% ( 51, 76 ] 26 0.000% 99.673% ( 76, 110 ] 7301 0.072% 99.745% ( 110, 170 ] 2560 0.025% 99.771% ( 170, 250 ] 296 0.003% 99.774% ( 250, 380 ] 107 0.001% 99.775% ( 380, 580 ] 26 0.000% 99.775% ( 580, 870 ] 21 0.000% 99.775% ( 870, 1300 ] 18664 0.185% 99.960% ( 1300, 1900 ] 124 0.001% 99.961% ( 1900, 2900 ] 3605 0.036% 99.997% ( 2900, 4400 ] 233 0.002% 99.999% ( 4400, 6600 ] 65 0.001% 100.000% ( 6600, 9900 ] 12 0.000% 100.000% ( 9900, 14000 ] 4 0.000% 100.000% ( 14000, 22000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 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 : 229950 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 : 10108999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10432486968 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 : 627 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32555523 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 : 36679450328 rocksdb.compact.write.bytes COUNT : 36440687904 rocksdb.flush.write.bytes COUNT : 10305054140 rocksdb.compact.read.marked.bytes COUNT : 0 rocksdb.compact.read.periodic.bytes COUNT : 0 rocksdb.compact.read.ttl.bytes COUNT : 0 rocksdb.compact.write.marked.bytes COUNT : 0 rocksdb.compact.write.periodic.bytes COUNT : 0 rocksdb.compact.write.ttl.bytes COUNT : 0 rocksdb.number.direct.load.table.properties COUNT : 68 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 326 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 : 10221916160 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3924992 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 : 36782057040 rocksdb.non.last.level.read.count COUNT : 8886270 rocksdb.block.checksum.compute.count COUNT : 8885084 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.386601 P95 : 3.830768 P99 : 7.089661 P100 : 358924.000000 COUNT : 10108999 SUM : 55196073 rocksdb.compaction.times.micros P50 : 983103.448276 P95 : 3996666.666667 P99 : 17480000.000000 P100 : 18490068.000000 COUNT : 113 SUM : 169454441 rocksdb.compaction.times.cpu_micros P50 : 885319.148936 P95 : 3390000.000000 P99 : 17110467.000000 P100 : 17110467.000000 COUNT : 113 SUM : 139341185 rocksdb.subcompaction.setup.times.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.table.sync.micros P50 : 694.294118 P95 : 1166.968750 P99 : 3815.000000 P100 : 8450.000000 COUNT : 139 SUM : 104526 rocksdb.compaction.outfile.sync.micros P50 : 1166.793478 P95 : 145318.181818 P99 : 286937.000000 P100 : 286937.000000 COUNT : 421 SUM : 9357612 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 : 112.608696 P95 : 830.125000 P99 : 2990.000000 P100 : 3710.000000 COUNT : 282 SUM : 70671 rocksdb.table.open.io.micros P50 : 1574.789916 P95 : 8023.888889 P99 : 13889.300000 P100 : 19364.000000 COUNT : 627 SUM : 1426707 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.663271 P95 : 8.039959 P99 : 11.619704 P100 : 11779.000000 COUNT : 8883478 SUM : 55477287 rocksdb.read.block.get.micros P50 : 537.024793 P95 : 3493.478261 P99 : 5379.578947 P100 : 11019.000000 COUNT : 1254 SUM : 1147309 rocksdb.write.raw.block.micros P50 : 0.513169 P95 : 0.975021 P99 : 2.846798 P100 : 13100.000000 COUNT : 11337515 SUM : 21324086 rocksdb.numfiles.in.singlecompaction P50 : 2.921053 P95 : 5.350000 P99 : 24.460000 P100 : 25.000000 COUNT : 159 SUM : 567 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.555544 P95 : 1129.905763 P99 : 2354.169916 P100 : 358693.000000 COUNT : 228253 SUM : 32577226 rocksdb.sst.read.micros P50 : 1.634269 P95 : 4.898108 P99 : 8.818151 P100 : 11408.000000 COUNT : 8886750 SUM : 37582291 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 : 10108999 SUM : 10432486968 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 : 212000.000000 P95 : 352973.684211 P99 : 481966.666667 P100 : 548003.000000 COUNT : 139 SUM : 28915880 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 : 405 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