[2024-12-07 18:28:42.288161] Starting SPDK v25.01-pre git sha1 a2f5e1c2d / DPDK 24.03.0 initialization... [2024-12-07 18:28:42.288451] [ 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_pid1459556 ] Set seed to 1733592522281471 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-07 18:28:42.414579] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-07 18:28:42.520025] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-07 18:28:42.520068] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1459556' to capture a snapshot of events at runtime. [2024-12-07 18:28:42.520078] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-07 18:28:42.520089] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-07 18:28:42.520096] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1459556 for offline analysis/debug. [2024-12-07 18:28:42.521534] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Dec 7 18:28:50 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/07-18:28:53 ... thread 0: (1000000,1000000) ops and (360601.8,360601.8) ops/second in (2.773142,2.773142) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 503.97 MB 18.9 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 354.4 2.31 2.07 12 0.193 0 0 0.0 0.0 L1 3/3 251.78 MB 0.0 0.2 0.2 0.1 0.2 0.2 0.1 1.3 252.4 252.2 1.00 0.97 1 0.998 255K 172 0.0 0.0 L2 1/0 48.85 MB 0.5 0.1 0.1 0.0 0.1 0.1 0.0 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 17/0 818.40 MB 0.8 0.1 0.1 0.0 0.1 0.1 0.0 1.0 217.2 217.2 0.29 0.24 1 0.288 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1189/8 96.94 GB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 104.6 305.8 4.07 3.72 15 0.271 432K 204 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.2 1.1 0.1 1.5 104.6 305.8 4.07 3.72 15 0.271 432K 204 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.3 0.1 0.4 0.3 0.0 0.0 242.0 241.9 1.76 1.65 3 0.586 432K 204 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.4 2.31 2.07 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.22 GB write, 415.44 MB/s write, 0.42 GB read, 142.13 MB/s read, 4.1 seconds Interval compaction: 1.22 GB write, 448.43 MB/s write, 0.42 GB read, 153.42 MB/s read, 4.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 98116 Average: 1.9225 StdDev: 22.88 Min: 0 Median: 1.2174 Max: 3540 Percentiles: P50: 1.22 P75: 1.64 P99: 3.63 P99.9: 9.13 P99.99: 467.54 ------------------------------------------------------ [ 0, 1 ] 36405 37.104% 37.104% ####### ( 1, 2 ] 58202 59.320% 96.424% ############ ( 2, 3 ] 1892 1.928% 98.352% ( 3, 4 ] 1017 1.037% 99.388% ( 4, 6 ] 370 0.377% 99.766% ( 6, 10 ] 170 0.173% 99.939% ( 10, 15 ] 20 0.020% 99.959% ( 15, 22 ] 15 0.015% 99.975% ( 22, 34 ] 1 0.001% 99.976% ( 51, 76 ] 1 0.001% 99.977% ( 110, 170 ] 5 0.005% 99.982% ( 170, 250 ] 4 0.004% 99.986% ( 250, 380 ] 3 0.003% 99.989% ( 380, 580 ] 5 0.005% 99.994% ( 870, 1300 ] 1 0.001% 99.995% ( 1300, 1900 ] 1 0.001% 99.996% ( 1900, 2900 ] 2 0.002% 99.998% ( 2900, 4400 ] 3 0.003% 100.001% ** Level 1 read latency histogram (micros): Count: 14462 Average: 1.8716 StdDev: 10.55 Min: 1 Median: 1.2440 Max: 953 Percentiles: P50: 1.24 P75: 1.65 P99: 3.47 P99.9: 7.90 P99.99: 740.60 ------------------------------------------------------ [ 0, 1 ] 5069 35.050% 35.050% ####### ( 1, 2 ] 8860 61.264% 96.314% ############ ( 2, 3 ] 315 2.178% 98.493% ( 3, 4 ] 156 1.079% 99.571% ( 4, 6 ] 39 0.270% 99.841% ( 6, 10 ] 18 0.124% 99.965% ( 10, 15 ] 1 0.007% 99.972% ( 250, 380 ] 1 0.007% 99.979% ( 380, 580 ] 1 0.007% 99.986% ( 580, 870 ] 1 0.007% 99.993% ( 870, 1300 ] 1 0.007% 100.000% ** Level 2 read latency histogram (micros): Count: 28148 Average: 2.3013 StdDev: 18.52 Min: 0 Median: 1.2344 Max: 1525 Percentiles: P50: 1.23 P75: 1.66 P99: 5.91 P99.9: 137.78 P99.99: 949.64 ------------------------------------------------------ [ 0, 1 ] 10226 36.329% 36.329% ####### ( 1, 2 ] 16418 58.327% 94.657% ############ ( 2, 3 ] 777 2.760% 97.417% # ( 3, 4 ] 286 1.016% 98.433% ( 4, 6 ] 167 0.593% 99.027% ( 6, 10 ] 162 0.576% 99.602% ( 10, 15 ] 28 0.099% 99.702% ( 15, 22 ] 10 0.036% 99.737% ( 22, 34 ] 1 0.004% 99.741% ( 34, 51 ] 1 0.004% 99.744% ( 51, 76 ] 34 0.121% 99.865% ( 76, 110 ] 8 0.028% 99.893% ( 110, 170 ] 4 0.014% 99.908% ( 170, 250 ] 8 0.028% 99.936% ( 250, 380 ] 9 0.032% 99.968% ( 380, 580 ] 4 0.014% 99.982% ( 580, 870 ] 2 0.007% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 85 Average: 1582.9294 StdDev: 2142.68 Min: 1 Median: 417.5000 Max: 8836 Percentiles: P50: 417.50 P75: 2864.29 P99: 8836.00 P99.9: 8836.00 P99.99: 8836.00 ------------------------------------------------------ [ 0, 1 ] 20 23.529% 23.529% ##### ( 1, 2 ] 17 20.000% 43.529% #### ( 2, 3 ] 1 1.176% 44.706% ( 170, 250 ] 1 1.176% 45.882% ( 250, 380 ] 2 2.353% 48.235% ( 380, 580 ] 8 9.412% 57.647% ## ( 580, 870 ] 1 1.176% 58.824% ( 870, 1300 ] 2 2.353% 61.176% ( 1300, 1900 ] 5 5.882% 67.059% # ( 1900, 2900 ] 7 8.235% 75.294% ## ( 2900, 4400 ] 11 12.941% 88.235% ### ( 4400, 6600 ] 7 8.235% 96.471% ## ( 6600, 9900 ] 3 3.529% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 3880.7333 StdDev: 1868.65 Min: 668 Median: 3275.0000 Max: 8293 Percentiles: P50: 3275.00 P75: 4871.43 P99: 8293.00 P99.9: 8293.00 P99.99: 8293.00 ------------------------------------------------------ ( 580, 870 ] 1 3.333% 3.333% # ( 1300, 1900 ] 1 3.333% 6.667% # ( 1900, 2900 ] 11 36.667% 43.333% ####### ( 2900, 4400 ] 8 26.667% 70.000% ##### ( 4400, 6600 ] 7 23.333% 93.333% ##### ( 6600, 9900 ] 2 6.667% 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, 328.51 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.174 H:M:S, 5.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 354.57 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.174 H:M:S, 6.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-18:28:56 ... thread 0: (1000000,2000000) ops and (325311.5,342048.8) ops/second in (3.073977,5.847119) 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/7 1.17 GB 6.3 0.7 0.0 0.7 2.5 1.8 0.0 1.4 94.1 321.3 8.04 7.42 29 0.277 767K 793 0.0 0.0 L1 2/2 50.44 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 244.0 243.6 3.36 3.26 2 1.678 831K 1368 0.0 0.0 L2 5/4 563.91 MB 1.3 0.1 0.1 0.0 0.1 0.1 0.5 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 17/10 818.40 MB 0.0 0.1 0.1 0.0 0.1 0.1 0.0 1.0 217.2 217.2 0.29 0.24 1 0.288 63K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1192/23 97.92 GB 0.0 1.7 0.6 1.1 3.5 2.4 0.6 2.0 143.9 294.0 12.15 11.36 33 0.368 1775K 2193 0.0 0.0 Int 0/0 0.00 KB 0.0 1.7 0.6 1.1 3.5 2.4 0.6 2.0 143.9 294.0 12.15 11.36 33 0.368 1775K 2193 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.7 0.6 1.1 1.7 0.6 0.0 0.0 249.3 249.0 7.01 6.79 7 1.002 1775K 2193 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 355.6 5.14 4.58 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.8 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.49 GB write, 588.69 MB/s write, 1.71 GB read, 288.08 MB/s read, 12.2 seconds Interval compaction: 3.49 GB write, 610.87 MB/s write, 1.71 GB read, 298.94 MB/s read, 12.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 358535 Average: 2.1769 StdDev: 15.16 Min: 0 Median: 1.4655 Max: 3540 Percentiles: P50: 1.47 P75: 1.85 P99: 5.46 P99.9: 9.83 P99.99: 23.97 ------------------------------------------------------ [ 0, 1 ] 70390 19.633% 19.633% #### ( 1, 2 ] 233902 65.238% 84.871% ############# ( 2, 3 ] 35079 9.784% 94.655% ## ( 3, 4 ] 11063 3.086% 97.741% # ( 4, 6 ] 6203 1.730% 99.471% ( 6, 10 ] 1609 0.449% 99.919% ( 10, 15 ] 214 0.060% 99.979% ( 15, 22 ] 38 0.011% 99.990% ( 22, 34 ] 7 0.002% 99.992% ( 34, 51 ] 4 0.001% 99.993% ( 51, 76 ] 4 0.001% 99.994% ( 110, 170 ] 10 0.003% 99.997% ( 170, 250 ] 11 0.003% 100.000% ( 250, 380 ] 7 0.002% 100.002% ( 380, 580 ] 11 0.003% 100.005% ( 580, 870 ] 4 0.001% 100.006% ( 870, 1300 ] 6 0.002% 100.008% ( 1300, 1900 ] 2 0.001% 100.008% ( 1900, 2900 ] 3 0.001% 100.009% ( 2900, 4400 ] 4 0.001% 100.010% ** Level 1 read latency histogram (micros): Count: 112536 Average: 2.2945 StdDev: 8.96 Min: 1 Median: 1.5660 Max: 1447 Percentiles: P50: 1.57 P75: 1.94 P99: 5.63 P99.9: 9.85 P99.99: 295.41 ------------------------------------------------------ [ 0, 1 ] 14083 12.514% 12.514% ### ( 1, 2 ] 74532 66.229% 78.744% ############# ( 2, 3 ] 16206 14.401% 93.144% ### ( 3, 4 ] 4256 3.782% 96.926% # ( 4, 6 ] 2856 2.538% 99.464% # ( 6, 10 ] 510 0.453% 99.917% ( 10, 15 ] 69 0.061% 99.979% ( 15, 22 ] 6 0.005% 99.984% ( 22, 34 ] 1 0.001% 99.985% ( 34, 51 ] 1 0.001% 99.986% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.002% 99.988% ( 250, 380 ] 5 0.004% 99.993% ( 380, 580 ] 2 0.002% 99.995% ( 580, 870 ] 2 0.002% 99.996% ( 870, 1300 ] 1 0.001% 99.997% ( 1300, 1900 ] 3 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 28193 Average: 2.3020 StdDev: 18.50 Min: 0 Median: 1.2355 Max: 1525 Percentiles: P50: 1.24 P75: 1.66 P99: 5.92 P99.9: 137.11 P99.99: 947.70 ------------------------------------------------------ [ 0, 1 ] 10226 36.271% 36.271% ####### ( 1, 2 ] 16438 58.305% 94.577% ############ ( 2, 3 ] 800 2.838% 97.414% # ( 3, 4 ] 287 1.018% 98.432% ( 4, 6 ] 167 0.592% 99.025% ( 6, 10 ] 163 0.578% 99.603% ( 10, 15 ] 28 0.099% 99.702% ( 15, 22 ] 10 0.035% 99.738% ( 22, 34 ] 1 0.004% 99.741% ( 34, 51 ] 1 0.004% 99.745% ( 51, 76 ] 34 0.121% 99.865% ( 76, 110 ] 8 0.028% 99.894% ( 110, 170 ] 4 0.014% 99.908% ( 170, 250 ] 8 0.028% 99.936% ( 250, 380 ] 9 0.032% 99.968% ( 380, 580 ] 4 0.014% 99.982% ( 580, 870 ] 2 0.007% 99.989% ( 870, 1300 ] 1 0.004% 99.993% ( 1300, 1900 ] 2 0.007% 100.000% ** Level 3 read latency histogram (micros): Count: 70799 Average: 5.2571 StdDev: 93.82 Min: 1 Median: 1.6891 Max: 8836 Percentiles: P50: 1.69 P75: 2.29 P99: 9.37 P99.9: 397.30 P99.99: 3707.29 ------------------------------------------------------ [ 0, 1 ] 4461 6.301% 6.301% # ( 1, 2 ] 44900 63.419% 69.720% ############# ( 2, 3 ] 12954 18.297% 88.017% #### ( 3, 4 ] 4029 5.691% 93.708% # ( 4, 6 ] 2636 3.723% 97.431% # ( 6, 10 ] 1321 1.866% 99.297% ( 10, 15 ] 155 0.219% 99.516% ( 15, 22 ] 22 0.031% 99.547% ( 22, 34 ] 1 0.001% 99.548% ( 76, 110 ] 56 0.079% 99.627% ( 110, 170 ] 107 0.151% 99.778% ( 170, 250 ] 46 0.065% 99.843% ( 250, 380 ] 38 0.054% 99.897% ( 380, 580 ] 37 0.052% 99.949% ( 580, 870 ] 7 0.010% 99.959% ( 870, 1300 ] 4 0.006% 99.965% ( 1300, 1900 ] 6 0.008% 99.973% ( 1900, 2900 ] 7 0.010% 99.983% ( 2900, 4400 ] 11 0.016% 99.999% ( 4400, 6600 ] 7 0.010% 100.008% ( 6600, 9900 ] 3 0.004% 100.013% ** Level 4 read latency histogram (micros): Count: 30 Average: 3880.7333 StdDev: 1868.65 Min: 668 Median: 3275.0000 Max: 8293 Percentiles: P50: 3275.00 P75: 4871.43 P99: 8293.00 P99.9: 8293.00 P99.99: 8293.00 ------------------------------------------------------ ( 580, 870 ] 1 3.333% 3.333% # ( 1300, 1900 ] 1 3.333% 6.667% # ( 1900, 2900 ] 11 36.667% 43.333% ####### ( 2900, 4400 ] 8 26.667% 70.000% ##### ( 4400, 6600 ] 7 23.333% 93.333% ##### ( 6600, 9900 ] 2 6.667% 100.000% # ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 324.29 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.569 H:M:S, 9.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.17 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.396 H:M:S, 12.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/07-18:28:59 ... thread 0: (1000000,3000000) ops and (317867.8,333589.8) ops/second in (3.145962,8.993081) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/11 2.15 GB 81.8 1.3 0.0 1.3 4.1 2.8 0.0 1.5 100.5 315.7 13.17 12.15 45 0.293 1343K 1419 0.0 0.0 L1 2/2 50.44 MB 0.0 0.8 0.5 0.3 0.8 0.5 0.1 1.6 244.0 243.6 3.36 3.26 2 1.678 831K 1368 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 24/0 991.71 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 215.4 215.3 6.79 6.06 4 1.698 1463K 746 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1242/13 98.90 GB 0.0 3.6 1.2 2.5 6.4 3.9 1.3 2.3 156.2 275.2 23.79 21.93 52 0.457 3750K 3565 0.0 0.0 Int 0/0 0.00 KB 0.0 3.6 1.2 2.5 6.4 3.9 1.3 2.3 156.2 275.2 23.79 21.93 52 0.457 3750K 3565 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 3.6 1.2 2.5 3.6 1.2 0.0 0.0 236.2 235.9 15.74 14.78 12 1.311 3750K 3565 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 352.1 8.05 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, 9.0 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 6.39 GB write, 710.44 MB/s write, 3.63 GB read, 403.25 MB/s read, 23.8 seconds Interval compaction: 6.39 GB write, 727.85 MB/s write, 3.63 GB read, 413.13 MB/s read, 23.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: 10, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 10, interval: 10 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 741904 Average: 2.3889 StdDev: 13.71 Min: 0 Median: 1.5867 Max: 3794 Percentiles: P50: 1.59 P75: 1.98 P99: 5.83 P99.9: 10.69 P99.99: 18.61 ------------------------------------------------------ [ 0, 1 ] 91919 12.390% 12.390% ## ( 1, 2 ] 475558 64.100% 76.489% ############# ( 2, 3 ] 111221 14.991% 91.481% ### ( 3, 4 ] 33668 4.538% 96.019% # ( 4, 6 ] 24146 3.255% 99.273% # ( 6, 10 ] 4551 0.613% 99.887% ( 10, 15 ] 723 0.097% 99.984% ( 15, 22 ] 87 0.012% 99.996% ( 22, 34 ] 11 0.001% 99.997% ( 34, 51 ] 6 0.001% 99.998% ( 51, 76 ] 7 0.001% 99.999% ( 76, 110 ] 20 0.003% 100.002% ( 110, 170 ] 39 0.005% 100.007% ( 170, 250 ] 32 0.004% 100.011% ( 250, 380 ] 19 0.003% 100.014% ( 380, 580 ] 22 0.003% 100.017% ( 580, 870 ] 8 0.001% 100.018% ( 870, 1300 ] 14 0.002% 100.020% ( 1300, 1900 ] 4 0.001% 100.020% ( 1900, 2900 ] 5 0.001% 100.021% ( 2900, 4400 ] 6 0.001% 100.022% ** Level 1 read latency histogram (micros): Count: 194736 Average: 2.4342 StdDev: 6.85 Min: 1 Median: 1.6595 Max: 1447 Percentiles: P50: 1.66 P75: 2.18 P99: 5.87 P99.9: 10.76 P99.99: 21.80 ------------------------------------------------------ [ 0, 1 ] 15884 8.157% 8.157% ## ( 1, 2 ] 123552 63.446% 71.603% ############# ( 2, 3 ] 35950 18.461% 90.063% #### ( 3, 4 ] 9871 5.069% 95.132% # ( 4, 6 ] 8059 4.138% 99.271% # ( 6, 10 ] 1197 0.615% 99.885% ( 10, 15 ] 187 0.096% 99.982% ( 15, 22 ] 17 0.009% 99.990% ( 22, 34 ] 1 0.001% 99.991% ( 34, 51 ] 2 0.001% 99.992% ( 51, 76 ] 1 0.001% 99.992% ( 110, 170 ] 2 0.001% 99.993% ( 250, 380 ] 5 0.003% 99.996% ( 380, 580 ] 2 0.001% 99.997% ( 580, 870 ] 2 0.001% 99.998% ( 870, 1300 ] 1 0.001% 99.998% ( 1300, 1900 ] 3 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 212904 Average: 4.0172 StdDev: 56.26 Min: 0 Median: 1.7408 Max: 8836 Percentiles: P50: 1.74 P75: 2.45 P99: 9.17 P99.9: 261.39 P99.99: 1217.93 ------------------------------------------------------ [ 0, 1 ] 10265 4.821% 4.821% # ( 1, 2 ] 129845 60.988% 65.809% ############ ( 2, 3 ] 43461 20.413% 86.222% #### ( 3, 4 ] 13320 6.256% 92.479% # ( 4, 6 ] 10636 4.996% 97.474% # ( 6, 10 ] 4103 1.927% 99.402% ( 10, 15 ] 421 0.198% 99.599% ( 15, 22 ] 74 0.035% 99.634% ( 22, 34 ] 33 0.015% 99.650% ( 34, 51 ] 4 0.002% 99.651% ( 51, 76 ] 5 0.002% 99.654% ( 76, 110 ] 134 0.063% 99.717% ( 110, 170 ] 250 0.117% 99.834% ( 170, 250 ] 133 0.062% 99.897% ( 250, 380 ] 81 0.038% 99.935% ( 380, 580 ] 75 0.035% 99.970% ( 580, 870 ] 33 0.015% 99.985% ( 870, 1300 ] 12 0.006% 99.991% ( 1300, 1900 ] 10 0.005% 99.996% ( 1900, 2900 ] 7 0.003% 99.999% ( 2900, 4400 ] 11 0.005% 100.004% ( 4400, 6600 ] 7 0.003% 100.008% ( 6600, 9900 ] 3 0.001% 100.009% ** Level 4 read latency histogram (micros): Count: 30 Average: 3880.7333 StdDev: 1868.65 Min: 668 Median: 3275.0000 Max: 8293 Percentiles: P50: 3275.00 P75: 4871.43 P99: 8293.00 P99.9: 8293.00 P99.99: 8293.00 ------------------------------------------------------ ( 580, 870 ] 1 3.333% 3.333% # ( 1300, 1900 ] 1 3.333% 6.667% # ( 1900, 2900 ] 11 36.667% 43.333% ####### ( 2900, 4400 ] 8 26.667% 70.000% ##### ( 4400, 6600 ] 7 23.333% 93.333% ##### ( 6600, 9900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 851.1500 StdDev: 991.24 Min: 127 Median: 250.0000 Max: 3576 Percentiles: P50: 250.00 P75: 1300.00 P99: 3576.00 P99.9: 3576.00 P99.99: 3576.00 ------------------------------------------------------ ( 110, 170 ] 6 30.000% 30.000% ###### ( 170, 250 ] 4 20.000% 50.000% #### ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 2 10.000% 65.000% ## ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 9.2 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 320.38 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.981 H:M:S, 10.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 312.84 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.411 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-18:29:03 ... thread 0: (1000000,4000000) ops and (326528.9,331796.1) ops/second in (3.062516,12.055597) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/4 2.03 GB 176.2 2.3 0.0 2.3 6.1 3.7 0.0 1.6 119.3 310.7 20.06 18.66 63 0.318 2430K 2527 0.0 0.0 L1 10/0 1.15 GB 117.7 2.0 1.6 0.4 1.9 1.6 0.1 1.2 231.7 230.8 8.64 8.37 3 2.881 2033K 7320 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 24/0 991.71 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 215.4 215.3 6.79 6.06 4 1.698 1463K 746 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1245/4 99.88 GB 0.0 5.8 2.3 3.6 9.6 6.0 1.3 2.6 166.0 272.5 35.97 33.53 71 0.507 6039K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 2.3 3.6 9.6 6.0 1.3 2.6 166.0 272.5 35.97 33.53 71 0.507 6039K 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 5.8 2.3 3.6 5.8 2.3 0.0 0.0 238.0 237.5 25.09 23.88 17 1.476 6039K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 353.1 10.88 9.65 54 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.3 total, 12.1 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.57 GB write, 798.35 MB/s write, 5.83 GB read, 486.29 MB/s read, 36.0 seconds Interval compaction: 9.57 GB write, 812.94 MB/s write, 5.83 GB read, 495.17 MB/s read, 36.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: 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: 1056666 Average: 2.3462 StdDev: 13.79 Min: 0 Median: 1.5572 Max: 3794 Percentiles: P50: 1.56 P75: 1.94 P99: 5.80 P99.9: 10.65 P99.99: 70.05 ------------------------------------------------------ [ 0, 1 ] 143038 13.537% 13.537% ### ( 1, 2 ] 691480 65.440% 78.977% ############# ( 2, 3 ] 144176 13.644% 92.621% ### ( 3, 4 ] 41694 3.946% 96.567% # ( 4, 6 ] 28533 2.700% 99.267% # ( 6, 10 ] 6570 0.622% 99.889% ( 10, 15 ] 908 0.086% 99.975% ( 15, 22 ] 130 0.012% 99.987% ( 22, 34 ] 18 0.002% 99.989% ( 34, 51 ] 8 0.001% 99.989% ( 51, 76 ] 7 0.001% 99.990% ( 76, 110 ] 27 0.003% 99.993% ( 110, 170 ] 75 0.007% 100.000% ( 170, 250 ] 58 0.005% 100.005% ( 250, 380 ] 32 0.003% 100.008% ( 380, 580 ] 37 0.004% 100.012% ( 580, 870 ] 18 0.002% 100.014% ( 870, 1300 ] 19 0.002% 100.015% ( 1300, 1900 ] 6 0.001% 100.016% ( 1900, 2900 ] 8 0.001% 100.017% ( 2900, 4400 ] 8 0.001% 100.017% ** Level 1 read latency histogram (micros): Count: 207591 Average: 2.6171 StdDev: 13.43 Min: 1 Median: 1.6546 Max: 2104 Percentiles: P50: 1.65 P75: 2.16 P99: 5.93 P99.9: 14.48 P99.99: 534.01 ------------------------------------------------------ [ 0, 1 ] 17136 8.255% 8.255% ## ( 1, 2 ] 132380 63.770% 72.024% ############# ( 2, 3 ] 37732 18.176% 90.200% #### ( 3, 4 ] 10272 4.948% 95.149% # ( 4, 6 ] 8286 3.992% 99.140% # ( 6, 10 ] 1392 0.671% 99.811% ( 10, 15 ] 207 0.100% 99.910% ( 15, 22 ] 21 0.010% 99.921% ( 22, 34 ] 1 0.000% 99.921% ( 34, 51 ] 2 0.001% 99.922% ( 51, 76 ] 1 0.000% 99.922% ( 76, 110 ] 9 0.004% 99.927% ( 110, 170 ] 89 0.043% 99.970% ( 170, 250 ] 18 0.009% 99.978% ( 250, 380 ] 15 0.007% 99.986% ( 380, 580 ] 12 0.006% 99.991% ( 580, 870 ] 2 0.001% 99.992% ( 870, 1300 ] 8 0.004% 99.996% ( 1300, 1900 ] 6 0.003% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 212904 Average: 4.0172 StdDev: 56.26 Min: 0 Median: 1.7408 Max: 8836 Percentiles: P50: 1.74 P75: 2.45 P99: 9.17 P99.9: 261.39 P99.99: 1217.93 ------------------------------------------------------ [ 0, 1 ] 10265 4.821% 4.821% # ( 1, 2 ] 129845 60.988% 65.809% ############ ( 2, 3 ] 43461 20.413% 86.222% #### ( 3, 4 ] 13320 6.256% 92.479% # ( 4, 6 ] 10636 4.996% 97.474% # ( 6, 10 ] 4103 1.927% 99.402% ( 10, 15 ] 421 0.198% 99.599% ( 15, 22 ] 74 0.035% 99.634% ( 22, 34 ] 33 0.015% 99.650% ( 34, 51 ] 4 0.002% 99.651% ( 51, 76 ] 5 0.002% 99.654% ( 76, 110 ] 134 0.063% 99.717% ( 110, 170 ] 250 0.117% 99.834% ( 170, 250 ] 133 0.062% 99.897% ( 250, 380 ] 81 0.038% 99.935% ( 380, 580 ] 75 0.035% 99.970% ( 580, 870 ] 33 0.015% 99.985% ( 870, 1300 ] 12 0.006% 99.991% ( 1300, 1900 ] 10 0.005% 99.996% ( 1900, 2900 ] 7 0.003% 99.999% ( 2900, 4400 ] 11 0.005% 100.004% ( 4400, 6600 ] 7 0.003% 100.008% ( 6600, 9900 ] 3 0.001% 100.009% ** Level 4 read latency histogram (micros): Count: 30 Average: 3880.7333 StdDev: 1868.65 Min: 668 Median: 3275.0000 Max: 8293 Percentiles: P50: 3275.00 P75: 4871.43 P99: 8293.00 P99.9: 8293.00 P99.99: 8293.00 ------------------------------------------------------ ( 580, 870 ] 1 3.333% 3.333% # ( 1300, 1900 ] 1 3.333% 6.667% # ( 1900, 2900 ] 11 36.667% 43.333% ####### ( 2900, 4400 ] 8 26.667% 70.000% ##### ( 4400, 6600 ] 7 23.333% 93.333% ##### ( 6600, 9900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 851.1500 StdDev: 991.24 Min: 127 Median: 250.0000 Max: 3576 Percentiles: P50: 250.00 P75: 1300.00 P99: 3576.00 P99.9: 3576.00 P99.99: 3576.00 ------------------------------------------------------ ( 110, 170 ] 6 30.000% 30.000% ###### ( 170, 250 ] 4 20.000% 50.000% #### ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 2 10.000% 65.000% ## ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 12.3 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 320.63 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.386 H:M:S, 11.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.37 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.405 H:M:S, 13.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-18:29:05 ... thread 0: (1000000,5000000) ops and (355803.0,336334.8) ops/second in (2.810544,14.866141) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/8 2.95 GB 245.4 2.9 0.0 2.9 7.6 4.7 0.0 1.6 119.6 312.7 24.77 23.06 79 0.313 3006K 3165 0.0 0.0 L1 10/0 1.15 GB 117.7 2.0 1.6 0.4 1.9 1.6 0.1 1.2 231.7 230.8 8.64 8.37 3 2.881 2033K 7320 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 24/0 991.71 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 215.4 215.3 6.79 6.06 4 1.698 1463K 746 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1253/8 100.80 GB 0.0 6.4 2.3 4.1 11.0 6.9 1.3 2.4 160.7 278.1 40.67 37.93 87 0.468 6615K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.4 2.3 4.1 11.0 6.9 1.3 2.4 160.7 278.1 40.67 37.93 87 0.468 6615K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.4 2.3 4.1 6.4 2.3 0.0 0.0 240.2 239.7 27.22 25.97 19 1.433 6615K 11K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 355.9 13.45 11.96 68 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.1 total, 14.9 interval Flush(GB): cumulative 4.675, interval 4.675 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.05 GB write, 749.80 MB/s write, 6.38 GB read, 433.28 MB/s read, 40.7 seconds Interval compaction: 11.05 GB write, 760.92 MB/s write, 6.38 GB read, 439.70 MB/s read, 40.7 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: 16, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 16, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1304083 Average: 2.2804 StdDev: 12.93 Min: 0 Median: 1.5269 Max: 3794 Percentiles: P50: 1.53 P75: 1.91 P99: 5.71 P99.9: 10.31 P99.99: 49.00 ------------------------------------------------------ [ 0, 1 ] 201670 15.465% 15.465% ### ( 1, 2 ] 854702 65.540% 81.005% ############# ( 2, 3 ] 161305 12.369% 93.374% ## ( 3, 4 ] 46721 3.583% 96.957% # ( 4, 6 ] 31112 2.386% 99.343% ( 6, 10 ] 7206 0.553% 99.895% ( 10, 15 ] 1058 0.081% 99.976% ( 15, 22 ] 148 0.011% 99.988% ( 22, 34 ] 22 0.002% 99.989% ( 34, 51 ] 12 0.001% 99.990% ( 51, 76 ] 11 0.001% 99.991% ( 76, 110 ] 27 0.002% 99.993% ( 110, 170 ] 79 0.006% 99.999% ( 170, 250 ] 66 0.005% 100.004% ( 250, 380 ] 36 0.003% 100.007% ( 380, 580 ] 44 0.003% 100.010% ( 580, 870 ] 21 0.002% 100.012% ( 870, 1300 ] 21 0.002% 100.014% ( 1300, 1900 ] 9 0.001% 100.014% ( 1900, 2900 ] 9 0.001% 100.015% ( 2900, 4400 ] 8 0.001% 100.016% ** Level 1 read latency histogram (micros): Count: 207591 Average: 2.6171 StdDev: 13.43 Min: 1 Median: 1.6546 Max: 2104 Percentiles: P50: 1.65 P75: 2.16 P99: 5.93 P99.9: 14.48 P99.99: 534.01 ------------------------------------------------------ [ 0, 1 ] 17136 8.255% 8.255% ## ( 1, 2 ] 132380 63.770% 72.024% ############# ( 2, 3 ] 37732 18.176% 90.200% #### ( 3, 4 ] 10272 4.948% 95.149% # ( 4, 6 ] 8286 3.992% 99.140% # ( 6, 10 ] 1392 0.671% 99.811% ( 10, 15 ] 207 0.100% 99.910% ( 15, 22 ] 21 0.010% 99.921% ( 22, 34 ] 1 0.000% 99.921% ( 34, 51 ] 2 0.001% 99.922% ( 51, 76 ] 1 0.000% 99.922% ( 76, 110 ] 9 0.004% 99.927% ( 110, 170 ] 89 0.043% 99.970% ( 170, 250 ] 18 0.009% 99.978% ( 250, 380 ] 15 0.007% 99.986% ( 380, 580 ] 12 0.006% 99.991% ( 580, 870 ] 2 0.001% 99.992% ( 870, 1300 ] 8 0.004% 99.996% ( 1300, 1900 ] 6 0.003% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 212904 Average: 4.0172 StdDev: 56.26 Min: 0 Median: 1.7408 Max: 8836 Percentiles: P50: 1.74 P75: 2.45 P99: 9.17 P99.9: 261.39 P99.99: 1217.93 ------------------------------------------------------ [ 0, 1 ] 10265 4.821% 4.821% # ( 1, 2 ] 129845 60.988% 65.809% ############ ( 2, 3 ] 43461 20.413% 86.222% #### ( 3, 4 ] 13320 6.256% 92.479% # ( 4, 6 ] 10636 4.996% 97.474% # ( 6, 10 ] 4103 1.927% 99.402% ( 10, 15 ] 421 0.198% 99.599% ( 15, 22 ] 74 0.035% 99.634% ( 22, 34 ] 33 0.015% 99.650% ( 34, 51 ] 4 0.002% 99.651% ( 51, 76 ] 5 0.002% 99.654% ( 76, 110 ] 134 0.063% 99.717% ( 110, 170 ] 250 0.117% 99.834% ( 170, 250 ] 133 0.062% 99.897% ( 250, 380 ] 81 0.038% 99.935% ( 380, 580 ] 75 0.035% 99.970% ( 580, 870 ] 33 0.015% 99.985% ( 870, 1300 ] 12 0.006% 99.991% ( 1300, 1900 ] 10 0.005% 99.996% ( 1900, 2900 ] 7 0.003% 99.999% ( 2900, 4400 ] 11 0.005% 100.004% ( 4400, 6600 ] 7 0.003% 100.008% ( 6600, 9900 ] 3 0.001% 100.009% ** Level 4 read latency histogram (micros): Count: 30 Average: 3880.7333 StdDev: 1868.65 Min: 668 Median: 3275.0000 Max: 8293 Percentiles: P50: 3275.00 P75: 4871.43 P99: 8293.00 P99.9: 8293.00 P99.99: 8293.00 ------------------------------------------------------ ( 580, 870 ] 1 3.333% 3.333% # ( 1300, 1900 ] 1 3.333% 6.667% # ( 1900, 2900 ] 11 36.667% 43.333% ####### ( 2900, 4400 ] 8 26.667% 70.000% ##### ( 4400, 6600 ] 7 23.333% 93.333% ##### ( 6600, 9900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 851.1500 StdDev: 991.24 Min: 127 Median: 250.0000 Max: 3576 Percentiles: P50: 250.00 P75: 1300.00 P99: 3576.00 P99.9: 3576.00 P99.99: 3576.00 ------------------------------------------------------ ( 110, 170 ] 6 30.000% 30.000% ###### ( 170, 250 ] 4 20.000% 50.000% #### ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 2 10.000% 65.000% ## ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.1 total, 2.8 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 326.13 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.565 H:M:S, 10.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 350.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:0.179 H:M:S, 6.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-18:29:09 ... thread 0: (1000000,6000000) ops and (285004.1,326533.1) ops/second in (3.508721,18.374862) 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/17 3.93 GB 6.3 4.3 0.0 4.3 10.0 5.7 0.0 1.8 133.3 308.2 33.09 30.97 98 0.338 4477K 4790 0.0 0.0 L1 10/10 1.15 GB 0.0 2.0 1.6 0.4 1.9 1.6 0.1 1.2 231.7 230.8 8.64 8.37 3 2.881 2033K 7320 0.0 0.0 L2 0/0 0.00 KB 0.0 0.1 0.1 0.0 0.1 0.1 0.5 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 24/0 991.71 MB 1.0 1.4 0.6 0.8 1.4 0.6 0.0 2.3 215.4 215.3 6.79 6.06 4 1.698 1463K 746 0.0 0.0 L4 152/0 9.61 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/27 101.78 GB 0.0 7.8 2.3 5.5 13.4 7.9 1.3 2.4 163.0 281.0 49.00 45.84 106 0.462 8086K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.8 2.3 5.5 13.4 7.9 1.3 2.4 163.0 281.0 49.00 45.84 106 0.462 8086K 12K 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.8 2.3 5.5 7.8 2.3 0.0 0.0 244.2 243.8 32.70 31.36 24 1.362 8086K 12K 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 355.5 16.30 14.48 82 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): 18.6 total, 18.4 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.45 GB write, 740.35 MB/s write, 7.80 GB read, 429.44 MB/s read, 49.0 seconds Interval compaction: 13.45 GB write, 749.23 MB/s write, 7.80 GB read, 434.60 MB/s read, 49.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 4, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 4, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 18, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 4, total-stops: 18, interval: 22 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1575493 Average: 2.2611 StdDev: 13.03 Min: 0 Median: 1.4974 Max: 3794 Percentiles: P50: 1.50 P75: 1.88 P99: 5.65 P99.9: 11.44 P99.99: 152.99 ------------------------------------------------------ [ 0, 1 ] 274932 17.451% 17.451% ### ( 1, 2 ] 1031026 65.441% 82.892% ############# ( 2, 3 ] 174848 11.098% 93.990% ## ( 3, 4 ] 51319 3.257% 97.247% # ( 4, 6 ] 33438 2.122% 99.370% ( 6, 10 ] 7995 0.507% 99.877% ( 10, 15 ] 1252 0.079% 99.957% ( 15, 22 ] 181 0.011% 99.968% ( 22, 34 ] 24 0.002% 99.970% ( 34, 51 ] 13 0.001% 99.970% ( 51, 76 ] 12 0.001% 99.971% ( 76, 110 ] 146 0.009% 99.981% ( 110, 170 ] 210 0.013% 99.994% ( 170, 250 ] 107 0.007% 100.001% ( 250, 380 ] 51 0.003% 100.004% ( 380, 580 ] 71 0.005% 100.008% ( 580, 870 ] 33 0.002% 100.010% ( 870, 1300 ] 28 0.002% 100.012% ( 1300, 1900 ] 13 0.001% 100.013% ( 1900, 2900 ] 10 0.001% 100.014% ( 2900, 4400 ] 9 0.001% 100.014% ** Level 1 read latency histogram (micros): Count: 210004 Average: 2.6536 StdDev: 13.69 Min: 1 Median: 1.6510 Max: 2104 Percentiles: P50: 1.65 P75: 2.15 P99: 5.95 P99.9: 90.57 P99.99: 542.49 ------------------------------------------------------ [ 0, 1 ] 17814 8.483% 8.483% ## ( 1, 2 ] 133937 63.778% 72.261% ############# ( 2, 3 ] 37769 17.985% 90.246% #### ( 3, 4 ] 10299 4.904% 95.150% # ( 4, 6 ] 8308 3.956% 99.106% # ( 6, 10 ] 1419 0.676% 99.782% ( 10, 15 ] 207 0.099% 99.880% ( 15, 22 ] 22 0.010% 99.891% ( 22, 34 ] 1 0.000% 99.891% ( 34, 51 ] 2 0.001% 99.892% ( 51, 76 ] 1 0.000% 99.893% ( 76, 110 ] 35 0.017% 99.910% ( 110, 170 ] 112 0.053% 99.963% ( 170, 250 ] 28 0.013% 99.976% ( 250, 380 ] 16 0.008% 99.984% ( 380, 580 ] 16 0.008% 99.991% ( 580, 870 ] 2 0.001% 99.992% ( 870, 1300 ] 8 0.004% 99.996% ( 1300, 1900 ] 6 0.003% 99.999% ( 1900, 2900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 212904 Average: 4.0172 StdDev: 56.26 Min: 0 Median: 1.7408 Max: 8836 Percentiles: P50: 1.74 P75: 2.45 P99: 9.17 P99.9: 261.39 P99.99: 1217.93 ------------------------------------------------------ [ 0, 1 ] 10265 4.821% 4.821% # ( 1, 2 ] 129845 60.988% 65.809% ############ ( 2, 3 ] 43461 20.413% 86.222% #### ( 3, 4 ] 13320 6.256% 92.479% # ( 4, 6 ] 10636 4.996% 97.474% # ( 6, 10 ] 4103 1.927% 99.402% ( 10, 15 ] 421 0.198% 99.599% ( 15, 22 ] 74 0.035% 99.634% ( 22, 34 ] 33 0.015% 99.650% ( 34, 51 ] 4 0.002% 99.651% ( 51, 76 ] 5 0.002% 99.654% ( 76, 110 ] 134 0.063% 99.717% ( 110, 170 ] 250 0.117% 99.834% ( 170, 250 ] 133 0.062% 99.897% ( 250, 380 ] 81 0.038% 99.935% ( 380, 580 ] 75 0.035% 99.970% ( 580, 870 ] 33 0.015% 99.985% ( 870, 1300 ] 12 0.006% 99.991% ( 1300, 1900 ] 10 0.005% 99.996% ( 1900, 2900 ] 7 0.003% 99.999% ( 2900, 4400 ] 11 0.005% 100.004% ( 4400, 6600 ] 7 0.003% 100.008% ( 6600, 9900 ] 3 0.001% 100.009% ** Level 4 read latency histogram (micros): Count: 30 Average: 3880.7333 StdDev: 1868.65 Min: 668 Median: 3275.0000 Max: 8293 Percentiles: P50: 3275.00 P75: 4871.43 P99: 8293.00 P99.9: 8293.00 P99.99: 8293.00 ------------------------------------------------------ ( 580, 870 ] 1 3.333% 3.333% # ( 1300, 1900 ] 1 3.333% 6.667% # ( 1900, 2900 ] 11 36.667% 43.333% ####### ( 2900, 4400 ] 8 26.667% 70.000% ##### ( 4400, 6600 ] 7 23.333% 93.333% ##### ( 6600, 9900 ] 2 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 20 Average: 851.1500 StdDev: 991.24 Min: 127 Median: 250.0000 Max: 3576 Percentiles: P50: 250.00 P75: 1300.00 P99: 3576.00 P99.9: 3576.00 P99.99: 3576.00 ------------------------------------------------------ ( 110, 170 ] 6 30.000% 30.000% ###### ( 170, 250 ] 4 20.000% 50.000% #### ( 250, 380 ] 1 5.000% 55.000% # ( 380, 580 ] 2 10.000% 65.000% ## ( 580, 870 ] 1 5.000% 70.000% # ( 870, 1300 ] 1 5.000% 75.000% # ( 1300, 1900 ] 2 10.000% 85.000% ## ( 1900, 2900 ] 2 10.000% 95.000% ## ( 2900, 4400 ] 1 5.000% 100.000% # ** DB Stats ** Uptime(secs): 18.6 total, 3.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 317.52 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.414 H:M:S, 13.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 280.50 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.849 H:M:S, 24.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/07-18:29:36 ... thread 0: (1000000,7000000) ops and (36474.7,152868.1) ops/second in (27.416254,45.791116) 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/9 1.05 GB 0.0 4.8 0.0 4.8 11.4 6.6 0.0 1.7 123.5 294.3 39.80 35.61 114 0.349 4989K 5269 0.0 0.0 L1 8/8 554.56 MB 0.0 7.0 5.5 1.5 6.9 5.3 0.1 1.3 218.3 214.3 32.73 29.70 4 8.182 7254K 129K 0.0 0.0 L2 8/8 1019.54 MB 0.0 0.1 0.1 0.0 0.1 0.1 4.9 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 20/7 1.77 GB 0.9 1.8 1.0 0.9 1.8 1.0 3.0 1.9 185.3 185.0 10.15 8.03 8 1.268 1486K 746 0.0 0.0 L4 158/18 9.83 GB 1.0 1.8 1.5 0.3 1.7 1.5 1.4 1.2 109.5 108.9 16.43 8.49 12 1.369 1826K 9168 0.0 0.0 L5 1076/0 88.46 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1279/50 102.64 GB 0.0 15.5 8.0 7.5 22.0 14.5 12.1 3.3 159.2 226.0 99.57 82.27 139 0.716 15M 144K 0.0 0.0 Int 0/0 0.00 KB 0.0 15.5 8.0 7.5 22.0 14.5 12.1 3.3 159.2 226.0 99.57 82.27 139 0.716 15M 144K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 15.5 8.0 7.5 15.3 7.9 0.0 0.0 202.1 200.2 78.43 64.98 43 1.824 15M 144K 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 321.8 21.14 17.28 96 0.220 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 46.0 total, 45.8 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: 21.98 GB write, 489.08 MB/s write, 15.48 GB read, 344.41 MB/s read, 99.6 seconds Interval compaction: 21.98 GB write, 491.43 MB/s write, 15.48 GB read, 346.07 MB/s read, 99.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 41, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 41, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2814571 Average: 3.0762 StdDev: 24.55 Min: 0 Median: 1.4565 Max: 6586 Percentiles: P50: 1.46 P75: 1.84 P99: 8.01 P99.9: 165.33 P99.99: 560.70 ------------------------------------------------------ [ 0, 1 ] 574037 20.395% 20.395% #### ( 1, 2 ] 1825445 64.857% 85.252% ############# ( 2, 3 ] 240520 8.546% 93.798% ## ( 3, 4 ] 78645 2.794% 96.592% # ( 4, 6 ] 59500 2.114% 98.706% ( 6, 10 ] 16463 0.585% 99.291% ( 10, 15 ] 2394 0.085% 99.376% ( 15, 22 ] 648 0.023% 99.399% ( 22, 34 ] 44 0.002% 99.400% ( 34, 51 ] 17 0.001% 99.401% ( 51, 76 ] 33 0.001% 99.402% ( 76, 110 ] 8547 0.304% 99.706% ( 110, 170 ] 5927 0.211% 99.916% ( 170, 250 ] 863 0.031% 99.947% ( 250, 380 ] 652 0.023% 99.970% ( 380, 580 ] 616 0.022% 99.992% ( 580, 870 ] 233 0.008% 100.000% ( 870, 1300 ] 103 0.004% 100.004% ( 1300, 1900 ] 54 0.002% 100.006% ( 1900, 2900 ] 43 0.002% 100.008% ( 2900, 4400 ] 37 0.001% 100.009% ( 4400, 6600 ] 7 0.000% 100.009% ** Level 1 read latency histogram (micros): Count: 1191030 Average: 6.6189 StdDev: 106.27 Min: 0 Median: 1.7829 Max: 14935 Percentiles: P50: 1.78 P75: 2.66 P99: 9.19 P99.9: 146.28 P99.99: 469.83 ------------------------------------------------------ [ 0, 1 ] 116005 9.740% 9.740% ## ( 1, 2 ] 612509 51.427% 61.167% ########## ( 2, 3 ] 248515 20.866% 82.032% #### ( 3, 4 ] 91778 7.706% 89.738% ## ( 4, 6 ] 93622 7.861% 97.599% ## ( 6, 10 ] 20920 1.756% 99.355% ( 10, 15 ] 3956 0.332% 99.687% ( 15, 22 ] 633 0.053% 99.740% ( 22, 34 ] 48 0.004% 99.744% ( 34, 51 ] 25 0.002% 99.747% ( 51, 76 ] 29 0.002% 99.749% ( 76, 110 ] 1226 0.103% 99.852% ( 110, 170 ] 951 0.080% 99.932% ( 170, 250 ] 210 0.018% 99.949% ( 250, 380 ] 304 0.026% 99.975% ( 380, 580 ] 405 0.034% 100.009% ( 580, 870 ] 487 0.041% 100.050% ( 870, 1300 ] 431 0.036% 100.086% ( 1300, 1900 ] 258 0.022% 100.108% ( 1900, 2900 ] 314 0.026% 100.134% ( 2900, 4400 ] 401 0.034% 100.168% ( 4400, 6600 ] 90 0.008% 100.175% ( 6600, 9900 ] 38 0.003% 100.178% ( 9900, 14000 ] 1 0.000% 100.179% ( 14000, 22000 ] 1 0.000% 100.179% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 339614 Average: 10.0411 StdDev: 125.41 Min: 0 Median: 1.8244 Max: 21032 Percentiles: P50: 1.82 P75: 2.67 P99: 14.06 P99.9: 1526.26 P99.99: 3540.27 ------------------------------------------------------ [ 0, 1 ] 12578 3.704% 3.704% # ( 1, 2 ] 190717 56.157% 59.861% ########### ( 2, 3 ] 76238 22.448% 82.309% #### ( 3, 4 ] 27612 8.130% 90.439% ## ( 4, 6 ] 21449 6.316% 96.755% # ( 6, 10 ] 6877 2.025% 98.780% ( 10, 15 ] 920 0.271% 99.051% ( 15, 22 ] 134 0.039% 99.090% ( 22, 34 ] 34 0.010% 99.100% ( 34, 51 ] 8 0.002% 99.103% ( 51, 76 ] 8 0.002% 99.105% ( 76, 110 ] 165 0.049% 99.154% ( 110, 170 ] 442 0.130% 99.284% ( 170, 250 ] 348 0.102% 99.386% ( 250, 380 ] 373 0.110% 99.496% ( 380, 580 ] 470 0.138% 99.635% ( 580, 870 ] 498 0.147% 99.781% ( 870, 1300 ] 334 0.098% 99.880% ( 1300, 1900 ] 184 0.054% 99.934% ( 1900, 2900 ] 130 0.038% 99.972% ( 2900, 4400 ] 143 0.042% 100.014% ( 4400, 6600 ] 24 0.007% 100.021% ( 6600, 9900 ] 7 0.002% 100.023% ( 9900, 14000 ] 1 0.000% 100.024% ( 14000, 22000 ] 1 0.000% 100.024% ** Level 4 read latency histogram (micros): Count: 50477 Average: 6.8870 StdDev: 126.45 Min: 1 Median: 2.2412 Max: 8839 Percentiles: P50: 2.24 P75: 3.16 P99: 8.84 P99.9: 44.72 P99.99: 1537.14 ------------------------------------------------------ [ 0, 1 ] 239 0.473% 0.473% ( 1, 2 ] 21308 42.213% 42.687% ######## ( 2, 3 ] 15305 30.321% 73.008% ###### ( 3, 4 ] 6158 12.200% 85.207% ## ( 4, 6 ] 6370 12.620% 97.827% ### ( 6, 10 ] 833 1.650% 99.477% ( 10, 15 ] 188 0.372% 99.849% ( 15, 22 ] 21 0.042% 99.891% ( 22, 34 ] 2 0.004% 99.895% ( 34, 51 ] 4 0.008% 99.903% ( 51, 76 ] 1 0.002% 99.905% ( 76, 110 ] 2 0.004% 99.909% ( 110, 170 ] 4 0.008% 99.917% ( 170, 250 ] 17 0.034% 99.950% ( 250, 380 ] 4 0.008% 99.958% ( 380, 580 ] 4 0.008% 99.966% ( 580, 870 ] 2 0.004% 99.970% ( 870, 1300 ] 6 0.012% 99.982% ( 1300, 1900 ] 10 0.020% 100.002% ( 1900, 2900 ] 15 0.030% 100.032% ( 2900, 4400 ] 12 0.024% 100.055% ( 4400, 6600 ] 10 0.020% 100.075% ( 6600, 9900 ] 3 0.006% 100.081% ** Level 5 read latency histogram (micros): Count: 160 Average: 1902.7375 StdDev: 1822.43 Min: 107 Median: 1068.4615 Max: 8539 Percentiles: P50: 1068.46 P75: 3130.77 P99: 8539.00 P99.9: 8539.00 P99.99: 8539.00 ------------------------------------------------------ ( 76, 110 ] 1 0.625% 0.625% ( 110, 170 ] 8 5.000% 5.625% # ( 170, 250 ] 7 4.375% 10.000% # ( 250, 380 ] 7 4.375% 14.375% # ( 380, 580 ] 22 13.750% 28.125% ### ( 580, 870 ] 29 18.125% 46.250% #### ( 870, 1300 ] 13 8.125% 54.375% ## ( 1300, 1900 ] 13 8.125% 62.500% ## ( 1900, 2900 ] 16 10.000% 72.500% ## ( 2900, 4400 ] 26 16.250% 88.750% ### ( 4400, 6600 ] 14 8.750% 97.500% ## ( 6600, 9900 ] 4 2.500% 100.000% # ** DB Stats ** Uptime(secs): 46.0 total, 27.4 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 149.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:26.488 H:M:S, 57.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 35.90 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:24.074 H:M:S, 87.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 9 num-running-flushes: 1 2024/12/07-18:29:39 ... thread 0: (1000000,8000000) ops and (309765.7,163200.8) ops/second in (3.228246,49.019362) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/9 1.97 GB 107.0 5.7 0.0 5.7 13.3 7.6 0.0 1.8 125.9 292.2 46.54 41.70 130 0.358 5948K 6460 0.0 0.0 L1 8/8 554.56 MB 0.0 7.0 5.5 1.5 6.9 5.3 0.1 1.3 218.3 214.3 32.73 29.70 4 8.182 7254K 129K 0.0 0.0 L2 8/8 1019.54 MB 0.0 0.1 0.1 0.0 0.1 0.1 4.9 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 14/1 1.01 GB 0.9 1.8 1.0 0.9 1.8 1.0 3.0 1.9 185.3 185.0 10.15 8.03 8 1.268 1486K 746 0.0 0.0 L4 152/0 9.59 GB 1.0 2.8 2.3 0.6 2.8 2.2 1.4 1.2 117.0 116.4 24.61 13.56 18 1.367 2924K 14K 0.0 0.0 L5 1088/0 89.45 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1283/26 103.55 GB 0.0 17.5 8.8 8.7 24.9 16.2 13.1 3.3 156.1 222.4 114.50 93.42 161 0.711 17M 150K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.5 8.8 8.7 24.9 16.2 13.1 3.3 156.1 222.4 114.50 93.42 161 0.711 17M 150K 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 17.5 8.8 8.7 17.3 8.6 0.0 0.0 197.7 196.0 90.42 73.73 52 1.739 17M 150K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 321.9 24.07 19.69 109 0.221 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 49.2 total, 49.0 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: 24.87 GB write, 517.22 MB/s write, 17.45 GB read, 362.97 MB/s read, 114.5 seconds Interval compaction: 24.87 GB write, 519.55 MB/s write, 17.45 GB read, 364.61 MB/s read, 114.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 45, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 45, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3115967 Average: 3.0524 StdDev: 24.04 Min: 0 Median: 1.4853 Max: 6586 Percentiles: P50: 1.49 P75: 1.87 P99: 7.89 P99.9: 162.12 P99.99: 529.73 ------------------------------------------------------ [ 0, 1 ] 585830 18.801% 18.801% #### ( 1, 2 ] 2003106 64.285% 83.086% ############# ( 2, 3 ] 308233 9.892% 92.978% ## ( 3, 4 ] 99369 3.189% 96.167% # ( 4, 6 ] 78692 2.525% 98.693% # ( 6, 10 ] 20233 0.649% 99.342% ( 10, 15 ] 2850 0.091% 99.433% ( 15, 22 ] 702 0.023% 99.456% ( 22, 34 ] 55 0.002% 99.458% ( 34, 51 ] 19 0.001% 99.458% ( 51, 76 ] 36 0.001% 99.459% ( 76, 110 ] 8557 0.275% 99.734% ( 110, 170 ] 5951 0.191% 99.925% ( 170, 250 ] 889 0.029% 99.954% ( 250, 380 ] 661 0.021% 99.975% ( 380, 580 ] 631 0.020% 99.995% ( 580, 870 ] 243 0.008% 100.003% ( 870, 1300 ] 108 0.003% 100.006% ( 1300, 1900 ] 59 0.002% 100.008% ( 1900, 2900 ] 47 0.002% 100.010% ( 2900, 4400 ] 41 0.001% 100.011% ( 4400, 6600 ] 7 0.000% 100.011% ** Level 1 read latency histogram (micros): Count: 1509945 Average: 6.1102 StdDev: 97.84 Min: 0 Median: 1.8002 Max: 14935 Percentiles: P50: 1.80 P75: 2.66 P99: 9.14 P99.9: 149.95 P99.99: 477.41 ------------------------------------------------------ [ 0, 1 ] 121574 8.052% 8.052% ## ( 1, 2 ] 791592 52.425% 60.477% ########## ( 2, 3 ] 332428 22.016% 82.493% #### ( 3, 4 ] 113087 7.489% 89.982% # ( 4, 6 ] 114333 7.572% 97.554% ## ( 6, 10 ] 27828 1.843% 99.397% ( 10, 15 ] 4647 0.308% 99.705% ( 15, 22 ] 700 0.046% 99.751% ( 22, 34 ] 54 0.004% 99.755% ( 34, 51 ] 28 0.002% 99.757% ( 51, 76 ] 31 0.002% 99.759% ( 76, 110 ] 1363 0.090% 99.849% ( 110, 170 ] 1158 0.077% 99.926% ( 170, 250 ] 319 0.021% 99.947% ( 250, 380 ] 409 0.027% 99.974% ( 380, 580 ] 501 0.033% 100.007% ( 580, 870 ] 548 0.036% 100.043% ( 870, 1300 ] 455 0.030% 100.074% ( 1300, 1900 ] 282 0.019% 100.092% ( 1900, 2900 ] 340 0.023% 100.115% ( 2900, 4400 ] 429 0.028% 100.143% ( 4400, 6600 ] 101 0.007% 100.150% ( 6600, 9900 ] 39 0.003% 100.152% ( 9900, 14000 ] 1 0.000% 100.152% ( 14000, 22000 ] 1 0.000% 100.153% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 372408 Average: 9.9824 StdDev: 126.16 Min: 0 Median: 1.8263 Max: 21032 Percentiles: P50: 1.83 P75: 2.67 P99: 13.40 P99.9: 1562.78 P99.99: 3610.24 ------------------------------------------------------ [ 0, 1 ] 13421 3.604% 3.604% # ( 1, 2 ] 209112 56.151% 59.755% ########### ( 2, 3 ] 84325 22.643% 82.398% ##### ( 3, 4 ] 30114 8.086% 90.485% ## ( 4, 6 ] 23480 6.305% 96.790% # ( 6, 10 ] 7558 2.029% 98.819% ( 10, 15 ] 992 0.266% 99.085% ( 15, 22 ] 140 0.038% 99.123% ( 22, 34 ] 34 0.009% 99.132% ( 34, 51 ] 8 0.002% 99.134% ( 51, 76 ] 8 0.002% 99.136% ( 76, 110 ] 170 0.046% 99.182% ( 110, 170 ] 461 0.124% 99.306% ( 170, 250 ] 362 0.097% 99.403% ( 250, 380 ] 395 0.106% 99.509% ( 380, 580 ] 503 0.135% 99.644% ( 580, 870 ] 517 0.139% 99.783% ( 870, 1300 ] 348 0.093% 99.876% ( 1300, 1900 ] 200 0.054% 99.930% ( 1900, 2900 ] 147 0.039% 99.970% ( 2900, 4400 ] 160 0.043% 100.013% ( 4400, 6600 ] 29 0.008% 100.020% ( 6600, 9900 ] 8 0.002% 100.023% ( 9900, 14000 ] 1 0.000% 100.023% ( 14000, 22000 ] 1 0.000% 100.023% ** Level 4 read latency histogram (micros): Count: 63355 Average: 6.8039 StdDev: 117.03 Min: 1 Median: 2.1663 Max: 8839 Percentiles: P50: 2.17 P75: 3.00 P99: 8.92 P99.9: 316.26 P99.99: 1812.42 ------------------------------------------------------ [ 0, 1 ] 382 0.603% 0.603% ( 1, 2 ] 28122 44.388% 44.991% ######### ( 2, 3 ] 19088 30.129% 75.120% ###### ( 3, 4 ] 7102 11.210% 86.329% ## ( 4, 6 ] 7339 11.584% 97.913% ## ( 6, 10 ] 943 1.488% 99.402% ( 10, 15 ] 201 0.317% 99.719% ( 15, 22 ] 25 0.039% 99.759% ( 22, 34 ] 2 0.003% 99.762% ( 34, 51 ] 4 0.006% 99.768% ( 51, 76 ] 1 0.002% 99.770% ( 76, 110 ] 5 0.008% 99.777% ( 110, 170 ] 24 0.038% 99.815% ( 170, 250 ] 46 0.073% 99.888% ( 250, 380 ] 15 0.024% 99.912% ( 380, 580 ] 20 0.032% 99.943% ( 580, 870 ] 7 0.011% 99.954% ( 870, 1300 ] 9 0.014% 99.968% ( 1300, 1900 ] 16 0.025% 99.994% ( 1900, 2900 ] 18 0.028% 100.022% ( 2900, 4400 ] 14 0.022% 100.044% ( 4400, 6600 ] 10 0.016% 100.060% ( 6600, 9900 ] 3 0.005% 100.065% ** Level 5 read latency histogram (micros): Count: 220 Average: 1765.5545 StdDev: 1739.74 Min: 94 Median: 941.6667 Max: 8539 Percentiles: P50: 941.67 P75: 2860.00 P99: 8448.00 P99.9: 8539.00 P99.99: 8539.00 ------------------------------------------------------ ( 76, 110 ] 4 1.818% 1.818% ( 110, 170 ] 14 6.364% 8.182% # ( 170, 250 ] 12 5.455% 13.636% # ( 250, 380 ] 11 5.000% 18.636% # ( 380, 580 ] 29 13.182% 31.818% ### ( 580, 870 ] 37 16.818% 48.636% ### ( 870, 1300 ] 18 8.182% 56.818% ## ( 1300, 1900 ] 16 7.273% 64.091% # ( 1900, 2900 ] 25 11.364% 75.455% ## ( 2900, 4400 ] 35 15.909% 91.364% ### ( 4400, 6600 ] 14 6.364% 97.727% # ( 6600, 9900 ] 5 2.273% 100.000% ** DB Stats ** Uptime(secs): 49.2 total, 3.2 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 159.89 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:26.947 H:M:S, 54.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 304.87 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.460 H:M:S, 14.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/07-18:29:43 ... thread 0: (1000000,9000000) ops and (317487.5,172515.9) ops/second in (3.149730,52.169092) 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.21 GB 37.8 6.2 0.0 6.2 14.7 8.5 0.0 1.7 124.1 293.4 51.29 46.05 145 0.354 6460K 6924 0.0 0.0 L1 12/12 1007.91 MB 0.0 8.2 6.1 2.0 8.1 6.0 0.1 1.3 209.6 206.3 40.03 35.38 5 8.005 7957K 129K 0.0 0.0 L2 1/0 53.66 MB 0.5 0.1 0.1 0.0 0.1 0.1 5.1 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 16/0 980.54 MB 1.0 3.5 2.1 1.4 3.5 2.1 3.0 1.6 182.6 182.0 19.68 15.64 12 1.640 2191K 3480 0.0 0.0 L4 157/0 9.52 GB 1.0 2.9 2.4 0.6 2.9 2.3 2.6 1.2 118.9 118.3 25.16 14.05 19 1.324 3038K 14K 0.0 0.0 L5 1104/0 90.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1305/24 104.46 GB 0.0 20.9 10.7 10.2 29.3 19.0 15.7 3.4 157.0 219.4 136.63 111.57 182 0.751 19M 154K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.9 10.7 10.2 29.3 19.0 15.7 3.4 157.0 219.4 136.63 111.57 182 0.751 19M 154K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.9 10.7 10.2 20.8 10.5 0.0 0.0 195.4 193.9 109.79 89.47 60 1.830 19M 154K 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 323.9 26.84 22.10 122 0.220 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): 52.4 total, 52.2 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: 29.27 GB write, 572.15 MB/s write, 20.95 GB read, 409.45 MB/s read, 136.6 seconds Interval compaction: 29.27 GB write, 574.57 MB/s write, 20.95 GB read, 411.18 MB/s read, 136.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 14, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 14, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 50, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 50, interval: 65 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3403004 Average: 3.0149 StdDev: 23.65 Min: 0 Median: 1.4977 Max: 6586 Percentiles: P50: 1.50 P75: 1.89 P99: 7.64 P99.9: 159.90 P99.99: 522.29 ------------------------------------------------------ [ 0, 1 ] 611359 17.965% 17.965% #### ( 1, 2 ] 2190463 64.369% 82.334% ############# ( 2, 3 ] 358496 10.535% 92.868% ## ( 3, 4 ] 111110 3.265% 96.134% # ( 4, 6 ] 88427 2.598% 98.732% # ( 6, 10 ] 22212 0.653% 99.385% ( 10, 15 ] 3135 0.092% 99.477% ( 15, 22 ] 739 0.022% 99.499% ( 22, 34 ] 64 0.002% 99.500% ( 34, 51 ] 23 0.001% 99.501% ( 51, 76 ] 38 0.001% 99.502% ( 76, 110 ] 8569 0.252% 99.754% ( 110, 170 ] 5972 0.175% 99.930% ( 170, 250 ] 917 0.027% 99.957% ( 250, 380 ] 674 0.020% 99.976% ( 380, 580 ] 656 0.019% 99.996% ( 580, 870 ] 261 0.008% 100.003% ( 870, 1300 ] 124 0.004% 100.007% ( 1300, 1900 ] 65 0.002% 100.009% ( 1900, 2900 ] 50 0.001% 100.010% ( 2900, 4400 ] 43 0.001% 100.012% ( 4400, 6600 ] 7 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 1691435 Average: 5.8806 StdDev: 92.95 Min: 0 Median: 1.8016 Max: 14935 Percentiles: P50: 1.80 P75: 2.65 P99: 9.11 P99.9: 156.02 P99.99: 477.95 ------------------------------------------------------ [ 0, 1 ] 125696 7.431% 7.431% # ( 1, 2 ] 898277 53.107% 60.539% ########### ( 2, 3 ] 377441 22.315% 82.854% #### ( 3, 4 ] 124607 7.367% 90.220% # ( 4, 6 ] 123966 7.329% 97.550% # ( 6, 10 ] 31577 1.867% 99.416% ( 10, 15 ] 4891 0.289% 99.706% ( 15, 22 ] 738 0.044% 99.749% ( 22, 34 ] 59 0.003% 99.753% ( 34, 51 ] 34 0.002% 99.755% ( 51, 76 ] 32 0.002% 99.757% ( 76, 110 ] 1433 0.085% 99.841% ( 110, 170 ] 1294 0.077% 99.918% ( 170, 250 ] 413 0.024% 99.942% ( 250, 380 ] 514 0.030% 99.973% ( 380, 580 ] 600 0.035% 100.008% ( 580, 870 ] 622 0.037% 100.045% ( 870, 1300 ] 489 0.029% 100.074% ( 1300, 1900 ] 295 0.017% 100.091% ( 1900, 2900 ] 341 0.020% 100.111% ( 2900, 4400 ] 430 0.025% 100.137% ( 4400, 6600 ] 101 0.006% 100.143% ( 6600, 9900 ] 39 0.002% 100.145% ( 9900, 14000 ] 1 0.000% 100.145% ( 14000, 22000 ] 1 0.000% 100.145% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 401502 Average: 9.5608 StdDev: 121.96 Min: 0 Median: 1.8183 Max: 21032 Percentiles: P50: 1.82 P75: 2.65 P99: 12.67 P99.9: 1484.72 P99.99: 3588.04 ------------------------------------------------------ [ 0, 1 ] 14355 3.575% 3.575% # ( 1, 2 ] 227777 56.731% 60.307% ########### ( 2, 3 ] 90763 22.606% 82.912% ##### ( 3, 4 ] 31555 7.859% 90.772% ## ( 4, 6 ] 24718 6.156% 96.928% # ( 6, 10 ] 7777 1.937% 98.865% ( 10, 15 ] 1015 0.253% 99.118% ( 15, 22 ] 142 0.035% 99.153% ( 22, 34 ] 36 0.009% 99.162% ( 34, 51 ] 8 0.002% 99.164% ( 51, 76 ] 8 0.002% 99.166% ( 76, 110 ] 193 0.048% 99.214% ( 110, 170 ] 486 0.121% 99.335% ( 170, 250 ] 393 0.098% 99.433% ( 250, 380 ] 410 0.102% 99.535% ( 380, 580 ] 517 0.129% 99.664% ( 580, 870 ] 528 0.132% 99.796% ( 870, 1300 ] 357 0.089% 99.884% ( 1300, 1900 ] 203 0.051% 99.935% ( 1900, 2900 ] 147 0.037% 99.972% ( 2900, 4400 ] 161 0.040% 100.012% ( 4400, 6600 ] 29 0.007% 100.019% ( 6600, 9900 ] 8 0.002% 100.021% ( 9900, 14000 ] 1 0.000% 100.021% ( 14000, 22000 ] 1 0.000% 100.021% ** Level 4 read latency histogram (micros): Count: 63776 Average: 7.0657 StdDev: 117.14 Min: 1 Median: 2.1630 Max: 8839 Percentiles: P50: 2.16 P75: 3.00 P99: 9.20 P99.9: 412.49 P99.99: 1810.84 ------------------------------------------------------ [ 0, 1 ] 407 0.638% 0.638% ( 1, 2 ] 28362 44.471% 45.109% ######### ( 2, 3 ] 19137 30.007% 75.116% ###### ( 3, 4 ] 7124 11.170% 86.286% ## ( 4, 6 ] 7346 11.518% 97.805% ## ( 6, 10 ] 952 1.493% 99.298% ( 10, 15 ] 202 0.317% 99.614% ( 15, 22 ] 25 0.039% 99.653% ( 22, 34 ] 2 0.003% 99.657% ( 34, 51 ] 4 0.006% 99.663% ( 51, 76 ] 1 0.002% 99.664% ( 76, 110 ] 6 0.009% 99.674% ( 110, 170 ] 48 0.075% 99.749% ( 170, 250 ] 66 0.103% 99.853% ( 250, 380 ] 26 0.041% 99.893% ( 380, 580 ] 26 0.041% 99.934% ( 580, 870 ] 12 0.019% 99.953% ( 870, 1300 ] 10 0.016% 99.969% ( 1300, 1900 ] 16 0.025% 99.994% ( 1900, 2900 ] 18 0.028% 100.022% ( 2900, 4400 ] 14 0.022% 100.044% ( 4400, 6600 ] 10 0.016% 100.060% ( 6600, 9900 ] 3 0.005% 100.064% ** Level 5 read latency histogram (micros): Count: 300 Average: 1524.0967 StdDev: 1625.80 Min: 81 Median: 789.7872 Max: 8539 Percentiles: P50: 789.79 P75: 2471.43 P99: 7920.00 P99.9: 8539.00 P99.99: 8539.00 ------------------------------------------------------ ( 76, 110 ] 15 5.000% 5.000% # ( 110, 170 ] 24 8.000% 13.000% ## ( 170, 250 ] 23 7.667% 20.667% ## ( 250, 380 ] 20 6.667% 27.333% # ( 380, 580 ] 34 11.333% 38.667% ## ( 580, 870 ] 47 15.667% 54.333% ### ( 870, 1300 ] 24 8.000% 62.333% ## ( 1300, 1900 ] 22 7.333% 69.667% # ( 1900, 2900 ] 28 9.333% 79.000% ## ( 2900, 4400 ] 44 14.667% 93.667% ### ( 4400, 6600 ] 14 4.667% 98.333% # ( 6600, 9900 ] 5 1.667% 100.000% ** DB Stats ** Uptime(secs): 52.4 total, 3.1 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 169.07 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.348 H:M:S, 52.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 312.47 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.400 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/12/07-18:29:46 ... thread 0: (1000000,10000000) ops and (269464.6,178954.4) ops/second in (3.711062,55.880154) 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.26 GB 151.0 7.3 0.0 7.3 16.8 9.5 0.0 1.8 127.8 294.1 58.67 53.03 164 0.358 7611K 8192 0.0 0.0 L1 12/12 1007.91 MB 0.0 8.2 6.1 2.0 8.1 6.0 0.1 1.3 209.6 206.3 40.03 35.38 5 8.005 7957K 129K 0.0 0.0 L2 1/0 53.66 MB 0.5 0.1 0.1 0.0 0.1 0.1 5.1 1.8 235.4 235.3 0.47 0.44 1 0.473 113K 32 0.0 0.0 L3 16/0 980.54 MB 1.0 3.5 2.1 1.4 3.5 2.1 3.0 1.6 182.6 182.0 19.68 15.64 12 1.640 2191K 3480 0.0 0.0 L4 157/0 9.52 GB 1.0 2.9 2.4 0.6 2.9 2.3 2.6 1.2 118.9 118.3 25.16 14.05 19 1.324 3038K 14K 0.0 0.0 L5 1104/0 90.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1308/24 105.51 GB 0.0 22.1 10.7 11.4 31.4 20.1 15.7 3.3 156.8 223.5 144.01 118.54 201 0.716 20M 155K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.1 10.7 11.4 31.4 20.1 15.7 3.3 156.8 223.5 144.01 118.54 201 0.716 20M 155K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.1 10.7 11.4 21.9 10.5 0.0 0.0 197.9 196.4 114.11 93.71 64 1.783 20M 155K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 326.6 29.90 24.83 137 0.218 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 56.1 total, 55.9 interval Flush(GB): cumulative 9.536, interval 9.536 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.43 GB write, 573.58 MB/s write, 22.06 GB read, 402.57 MB/s read, 144.0 seconds Interval compaction: 31.43 GB write, 575.84 MB/s write, 22.06 GB read, 404.16 MB/s read, 144.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 16, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 16, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 53, pending-compaction-bytes-delays: 1, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 53, interval: 70 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3834170 Average: 2.9461 StdDev: 22.55 Min: 0 Median: 1.5079 Max: 6586 Percentiles: P50: 1.51 P75: 1.89 P99: 7.30 P99.9: 155.40 P99.99: 475.82 ------------------------------------------------------ [ 0, 1 ] 657298 17.143% 17.143% ### ( 1, 2 ] 2480314 64.690% 81.833% ############# ( 2, 3 ] 424749 11.078% 92.911% ## ( 3, 4 ] 125905 3.284% 96.195% # ( 4, 6 ] 99358 2.591% 98.786% # ( 6, 10 ] 25150 0.656% 99.442% ( 10, 15 ] 3456 0.090% 99.532% ( 15, 22 ] 764 0.020% 99.552% ( 22, 34 ] 66 0.002% 99.554% ( 34, 51 ] 25 0.001% 99.554% ( 51, 76 ] 44 0.001% 99.556% ( 76, 110 ] 8640 0.225% 99.781% ( 110, 170 ] 6035 0.157% 99.938% ( 170, 250 ] 954 0.025% 99.963% ( 250, 380 ] 698 0.018% 99.981% ( 380, 580 ] 690 0.018% 99.999% ( 580, 870 ] 269 0.007% 100.006% ( 870, 1300 ] 132 0.003% 100.010% ( 1300, 1900 ] 68 0.002% 100.012% ( 1900, 2900 ] 51 0.001% 100.013% ( 2900, 4400 ] 44 0.001% 100.014% ( 4400, 6600 ] 7 0.000% 100.014% ** Level 1 read latency histogram (micros): Count: 1749771 Average: 5.7997 StdDev: 91.46 Min: 0 Median: 1.7943 Max: 14935 Percentiles: P50: 1.79 P75: 2.63 P99: 9.11 P99.9: 159.78 P99.99: 483.50 ------------------------------------------------------ [ 0, 1 ] 130936 7.483% 7.483% # ( 1, 2 ] 936563 53.525% 61.008% ########### ( 2, 3 ] 387323 22.136% 83.144% #### ( 3, 4 ] 126484 7.229% 90.372% # ( 4, 6 ] 125672 7.182% 97.554% # ( 6, 10 ] 32501 1.857% 99.412% ( 10, 15 ] 4981 0.285% 99.696% ( 15, 22 ] 749 0.043% 99.739% ( 22, 34 ] 59 0.003% 99.743% ( 34, 51 ] 34 0.002% 99.745% ( 51, 76 ] 33 0.002% 99.746% ( 76, 110 ] 1504 0.086% 99.832% ( 110, 170 ] 1425 0.081% 99.914% ( 170, 250 ] 464 0.027% 99.940% ( 250, 380 ] 542 0.031% 99.971% ( 380, 580 ] 630 0.036% 100.007% ( 580, 870 ] 629 0.036% 100.043% ( 870, 1300 ] 489 0.028% 100.071% ( 1300, 1900 ] 296 0.017% 100.088% ( 1900, 2900 ] 341 0.019% 100.108% ( 2900, 4400 ] 430 0.025% 100.132% ( 4400, 6600 ] 101 0.006% 100.138% ( 6600, 9900 ] 39 0.002% 100.140% ( 9900, 14000 ] 1 0.000% 100.140% ( 14000, 22000 ] 1 0.000% 100.140% ** Level 2 read latency histogram (micros): Count: 40553 Average: 2.4374 StdDev: 16.13 Min: 0 Median: 1.3934 Max: 1525 Percentiles: P50: 1.39 P75: 1.81 P99: 7.63 P99.9: 89.02 P99.99: 716.98 ------------------------------------------------------ [ 0, 1 ] 10774 26.568% 26.568% ##### ( 1, 2 ] 24154 59.562% 86.129% ############ ( 2, 3 ] 3277 8.081% 94.210% ## ( 3, 4 ] 997 2.459% 96.669% ( 4, 6 ] 774 1.909% 98.577% ( 6, 10 ] 420 1.036% 99.613% ( 10, 15 ] 60 0.148% 99.761% ( 15, 22 ] 17 0.042% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 1 0.002% 99.808% ( 51, 76 ] 34 0.084% 99.892% ( 76, 110 ] 9 0.022% 99.914% ( 110, 170 ] 5 0.012% 99.926% ( 170, 250 ] 9 0.022% 99.948% ( 250, 380 ] 9 0.022% 99.970% ( 380, 580 ] 7 0.017% 99.988% ( 580, 870 ] 2 0.005% 99.993% ( 870, 1300 ] 1 0.002% 99.995% ( 1300, 1900 ] 2 0.005% 100.000% ** Level 3 read latency histogram (micros): Count: 401502 Average: 9.5608 StdDev: 121.96 Min: 0 Median: 1.8183 Max: 21032 Percentiles: P50: 1.82 P75: 2.65 P99: 12.67 P99.9: 1484.72 P99.99: 3588.04 ------------------------------------------------------ [ 0, 1 ] 14355 3.575% 3.575% # ( 1, 2 ] 227777 56.731% 60.307% ########### ( 2, 3 ] 90763 22.606% 82.912% ##### ( 3, 4 ] 31555 7.859% 90.772% ## ( 4, 6 ] 24718 6.156% 96.928% # ( 6, 10 ] 7777 1.937% 98.865% ( 10, 15 ] 1015 0.253% 99.118% ( 15, 22 ] 142 0.035% 99.153% ( 22, 34 ] 36 0.009% 99.162% ( 34, 51 ] 8 0.002% 99.164% ( 51, 76 ] 8 0.002% 99.166% ( 76, 110 ] 193 0.048% 99.214% ( 110, 170 ] 486 0.121% 99.335% ( 170, 250 ] 393 0.098% 99.433% ( 250, 380 ] 410 0.102% 99.535% ( 380, 580 ] 517 0.129% 99.664% ( 580, 870 ] 528 0.132% 99.796% ( 870, 1300 ] 357 0.089% 99.884% ( 1300, 1900 ] 203 0.051% 99.935% ( 1900, 2900 ] 147 0.037% 99.972% ( 2900, 4400 ] 161 0.040% 100.012% ( 4400, 6600 ] 29 0.007% 100.019% ( 6600, 9900 ] 8 0.002% 100.021% ( 9900, 14000 ] 1 0.000% 100.021% ( 14000, 22000 ] 1 0.000% 100.021% ** Level 4 read latency histogram (micros): Count: 63776 Average: 7.0657 StdDev: 117.14 Min: 1 Median: 2.1630 Max: 8839 Percentiles: P50: 2.16 P75: 3.00 P99: 9.20 P99.9: 412.49 P99.99: 1810.84 ------------------------------------------------------ [ 0, 1 ] 407 0.638% 0.638% ( 1, 2 ] 28362 44.471% 45.109% ######### ( 2, 3 ] 19137 30.007% 75.116% ###### ( 3, 4 ] 7124 11.170% 86.286% ## ( 4, 6 ] 7346 11.518% 97.805% ## ( 6, 10 ] 952 1.493% 99.298% ( 10, 15 ] 202 0.317% 99.614% ( 15, 22 ] 25 0.039% 99.653% ( 22, 34 ] 2 0.003% 99.657% ( 34, 51 ] 4 0.006% 99.663% ( 51, 76 ] 1 0.002% 99.664% ( 76, 110 ] 6 0.009% 99.674% ( 110, 170 ] 48 0.075% 99.749% ( 170, 250 ] 66 0.103% 99.853% ( 250, 380 ] 26 0.041% 99.893% ( 380, 580 ] 26 0.041% 99.934% ( 580, 870 ] 12 0.019% 99.953% ( 870, 1300 ] 10 0.016% 99.969% ( 1300, 1900 ] 16 0.025% 99.994% ( 1900, 2900 ] 18 0.028% 100.022% ( 2900, 4400 ] 14 0.022% 100.044% ( 4400, 6600 ] 10 0.016% 100.060% ( 6600, 9900 ] 3 0.005% 100.064% ** Level 5 read latency histogram (micros): Count: 300 Average: 1524.0967 StdDev: 1625.80 Min: 81 Median: 789.7872 Max: 8539 Percentiles: P50: 789.79 P75: 2471.43 P99: 7920.00 P99.9: 8539.00 P99.99: 8539.00 ------------------------------------------------------ ( 76, 110 ] 15 5.000% 5.000% # ( 110, 170 ] 24 8.000% 13.000% ## ( 170, 250 ] 23 7.667% 20.667% ## ( 250, 380 ] 20 6.667% 27.333% # ( 380, 580 ] 34 11.333% 38.667% ## ( 580, 870 ] 47 15.667% 54.333% ### ( 870, 1300 ] 24 8.000% 62.333% ## ( 1300, 1900 ] 22 7.333% 69.667% # ( 1900, 2900 ] 28 9.333% 79.000% ## ( 2900, 4400 ] 44 14.667% 93.667% ### ( 4400, 6600 ] 14 4.667% 98.333% # ( 6600, 9900 ] 5 1.667% 100.000% ** DB Stats ** Uptime(secs): 56.1 total, 3.7 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 175.43 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:28.350 H:M:S, 50.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 265.20 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.002 H:M:S, 27.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.607 micros/op 178348 ops/sec 60.101 seconds 10718999 operations; 172.8 MB/s Microseconds per write: Count: 10718999 Average: 5.6070 StdDev: 429.61 Min: 0 Median: 1.7732 Max: 884869 Percentiles: P50: 1.77 P75: 2.80 P99: 8.01 P99.9: 1148.17 P99.99: 2763.69 ------------------------------------------------------ [ 0, 1 ] 1172656 10.940% 10.940% ## ( 1, 2 ] 5415096 50.519% 61.459% ########## ( 2, 3 ] 1825522 17.031% 78.489% ### ( 3, 4 ] 1546205 14.425% 92.914% ### ( 4, 6 ] 604958 5.644% 98.558% # ( 6, 10 ] 94488 0.882% 99.440% ( 10, 15 ] 24196 0.226% 99.665% ( 15, 22 ] 6878 0.064% 99.729% ( 22, 34 ] 1340 0.013% 99.742% ( 34, 51 ] 182 0.002% 99.744% ( 51, 76 ] 24 0.000% 99.744% ( 76, 110 ] 7907 0.074% 99.818% ( 110, 170 ] 2607 0.024% 99.842% ( 170, 250 ] 284 0.003% 99.845% ( 250, 380 ] 75 0.001% 99.845% ( 380, 580 ] 12 0.000% 99.845% ( 580, 870 ] 13 0.000% 99.846% ( 870, 1300 ] 9023 0.084% 99.930% ( 1300, 1900 ] 18 0.000% 99.930% ( 1900, 2900 ] 7460 0.070% 99.999% ( 2900, 4400 ] 28 0.000% 100.000% ( 4400, 6600 ] 4 0.000% 100.000% ( 14000, 22000 ] 2 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 194272 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 : 10718999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11062006968 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 : 518 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30549329 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 : 27103568787 rocksdb.compact.write.bytes COUNT : 26911168347 rocksdb.flush.write.bytes COUNT : 11031483820 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 : 70 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 : 261 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 : 10942636032 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4354048 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 : 27209013308 rocksdb.non.last.level.read.count COUNT : 6568729 rocksdb.block.checksum.compute.count COUNT : 6567763 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.419050 P95 : 3.866570 P99 : 5.992228 P100 : 884867.000000 COUNT : 10718999 SUM : 54925402 rocksdb.compaction.times.micros P50 : 1170689.655172 P95 : 5730000.000000 P99 : 24086322.000000 P100 : 24086322.000000 COUNT : 67 SUM : 116961349 rocksdb.compaction.times.cpu_micros P50 : 938928.571429 P95 : 4776666.666667 P99 : 16640000.000000 P100 : 21330601.000000 COUNT : 67 SUM : 96516198 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 : 710.170455 P95 : 1289.815789 P99 : 45835.000000 P100 : 67693.000000 COUNT : 149 SUM : 264388 rocksdb.compaction.outfile.sync.micros P50 : 944.533333 P95 : 122500.000000 P99 : 208666.666667 P100 : 228638.000000 COUNT : 310 SUM : 5136610 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 : 98.869048 P95 : 1270.437500 P99 : 3645.000000 P100 : 25637.000000 COUNT : 251 SUM : 88869 rocksdb.table.open.io.micros P50 : 1564.000000 P95 : 10562.307692 P99 : 20043.076923 P100 : 27596.000000 COUNT : 518 SUM : 1417178 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.657492 P95 : 7.476267 P99 : 11.541843 P100 : 21035.000000 COUNT : 6566541 SUM : 40488957 rocksdb.read.block.get.micros P50 : 510.136986 P95 : 4107.894737 P99 : 7270.153846 P100 : 8973.000000 COUNT : 1036 SUM : 1110722 rocksdb.write.raw.block.micros P50 : 0.512806 P95 : 0.974331 P99 : 2.818718 P100 : 19148.000000 COUNT : 9190415 SUM : 18998684 rocksdb.numfiles.in.singlecompaction P50 : 3.376404 P95 : 7.650000 P99 : 21.055000 P100 : 27.000000 COUNT : 127 SUM : 536 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.568447 P95 : 1981.204722 P99 : 2718.816743 P100 : 884688.000000 COUNT : 137454 SUM : 30560810 rocksdb.sst.read.micros P50 : 1.598712 P95 : 4.395294 P99 : 8.620436 P100 : 21032.000000 COUNT : 6569307 SUM : 27493080 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 : 10718999 SUM : 11062006968 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 : 211111.111111 P95 : 368218.750000 P99 : 788950.000000 P100 : 1014745.000000 COUNT : 149 SUM : 32036378 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 : 309 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