[2024-07-12 16:35:21.733933] Starting SPDK v24.01.1-pre git sha1 4b94202c6 / DPDK 22.11.4 initialization... [2024-07-12 16:35:21.734198] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid339726 ] Set seed to 1720794921727506 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-12 16:35:21.834094] app.c: 798:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-12 16:35:21.873024] app.c: 488:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-12 16:35:21.873074] app.c: 489:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 339726' to capture a snapshot of events at runtime. [2024-07-12 16:35:21.873085] app.c: 494:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid339726 for offline analysis/debug. [2024-07-12 16:35:21.873107] reactor.c: 937:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Jul 12 16:35:26 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/12-16:35:28 ... thread 0: (1000000,1000000) ops and (342752.3,342752.3) ops/second in (2.917559,2.917559) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/6 629.97 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 355.1 2.48 2.25 12 0.207 0 0 0.0 0.0 L2 3/2 251.76 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 11/0 930.38 MB 0.9 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1040/0 85.69 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 1179/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.4 94.8 316.0 3.99 3.69 14 0.285 383K 174 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.2 0.2 1.2 1.0 0.2 1.4 94.8 316.0 3.99 3.69 14 0.285 383K 174 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 0.0 0.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 355.1 2.48 2.25 12 0.207 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.1 total, 2.9 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 403.81 MB/s write, 0.37 GB read, 121.15 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 431.54 MB/s write, 0.37 GB read, 129.47 MB/s read, 4.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 110525 Average: 1.8538 StdDev: 13.11 Min: 1 Median: 1.2264 Max: 2943 Percentiles: P50: 1.23 P75: 1.66 P99: 3.95 P99.9: 9.47 P99.99: 300.63 ------------------------------------------------------ [ 0, 1 ] 40931 37.033% 37.033% ####### ( 1, 2 ] 63299 57.271% 94.304% ########### ( 2, 3 ] 3679 3.329% 97.633% # ( 3, 4 ] 1596 1.444% 99.077% ( 4, 6 ] 729 0.660% 99.737% ( 6, 10 ] 209 0.189% 99.926% ( 10, 15 ] 45 0.041% 99.967% ( 15, 22 ] 10 0.009% 99.976% ( 22, 34 ] 2 0.002% 99.977% ( 51, 76 ] 2 0.002% 99.979% ( 110, 170 ] 7 0.006% 99.986% ( 170, 250 ] 4 0.004% 99.989% ( 250, 380 ] 5 0.005% 99.994% ( 380, 580 ] 2 0.002% 99.995% ( 580, 870 ] 1 0.001% 99.996% ( 870, 1300 ] 2 0.002% 99.998% ( 1300, 1900 ] 1 0.001% 99.999% ( 1900, 2900 ] 1 0.001% 100.000% ( 2900, 4400 ] 1 0.001% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 1337.4000 StdDev: 1332.20 Min: 54 Median: 480.0000 Max: 3511 Percentiles: P50: 480.00 P75: 2650.00 P99: 3511.00 P99.9: 3511.00 P99.99: 3511.00 ------------------------------------------------------ ( 51, 76 ] 1 20.000% 20.000% #### ( 250, 380 ] 1 20.000% 40.000% #### ( 380, 580 ] 1 20.000% 60.000% #### ( 1900, 2900 ] 1 20.000% 80.000% #### ( 2900, 4400 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 60220 Average: 1.8525 StdDev: 7.45 Min: 0 Median: 1.2522 Max: 1361 Percentiles: P50: 1.25 P75: 1.69 P99: 4.98 P99.9: 9.80 P99.99: 168.68 ------------------------------------------------------ [ 0, 1 ] 21451 35.621% 35.621% ####### ( 1, 2 ] 34340 57.024% 92.645% ########### ( 2, 3 ] 2301 3.821% 96.466% # ( 3, 4 ] 1194 1.983% 98.449% ( 4, 6 ] 681 1.131% 99.580% ( 6, 10 ] 204 0.339% 99.919% ( 10, 15 ] 34 0.056% 99.975% ( 15, 22 ] 8 0.013% 99.988% ( 34, 51 ] 1 0.002% 99.990% ( 110, 170 ] 1 0.002% 99.992% ( 250, 380 ] 2 0.003% 99.995% ( 380, 580 ] 1 0.002% 99.997% ( 580, 870 ] 2 0.003% 100.000% ( 1300, 1900 ] 1 0.002% 100.002% ** Level 3 read latency histogram (micros): Count: 50 Average: 1412.2600 StdDev: 1182.15 Min: 55 Median: 1085.0000 Max: 5246 Percentiles: P50: 1085.00 P75: 1866.67 P99: 5246.00 P99.9: 5246.00 P99.99: 5246.00 ------------------------------------------------------ ( 51, 76 ] 1 2.000% 2.000% ( 76, 110 ] 1 2.000% 4.000% ( 170, 250 ] 4 8.000% 12.000% ## ( 250, 380 ] 1 2.000% 14.000% ( 380, 580 ] 3 6.000% 20.000% # ( 580, 870 ] 11 22.000% 42.000% #### ( 870, 1300 ] 8 16.000% 58.000% ### ( 1300, 1900 ] 9 18.000% 76.000% #### ( 1900, 2900 ] 7 14.000% 90.000% ### ( 2900, 4400 ] 3 6.000% 96.000% # ( 4400, 6600 ] 2 4.000% 100.000% # ** Level 4 read latency histogram (micros): Count: 25 Average: 1598.4400 StdDev: 1654.05 Min: 104 Median: 1085.0000 Max: 6254 Percentiles: P50: 1085.00 P75: 1750.00 P99: 6254.00 P99.9: 6254.00 P99.99: 6254.00 ------------------------------------------------------ ( 76, 110 ] 1 4.000% 4.000% # ( 110, 170 ] 3 12.000% 16.000% ## ( 250, 380 ] 2 8.000% 24.000% ## ( 580, 870 ] 4 16.000% 40.000% ### ( 870, 1300 ] 5 20.000% 60.000% #### ( 1300, 1900 ] 5 20.000% 80.000% #### ( 1900, 2900 ] 1 4.000% 84.000% # ( 2900, 4400 ] 1 4.000% 88.000% # ( 4400, 6600 ] 3 12.000% 100.000% ## ** DB Stats ** Uptime(secs): 3.1 total, 2.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 315.48 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.402 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.06 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.402 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-16:35:32 ... thread 0: (1000000,2000000) ops and (331397.5,336979.3) ops/second in (3.017524,5.935083) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/9 1.23 GB 18.9 0.6 0.0 0.6 2.4 1.8 0.0 1.3 76.2 330.1 7.44 6.85 28 0.266 575K 594 0.0 0.0 L1 1/1 3.60 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 238.0 237.6 1.59 1.54 1 1.588 383K 558 0.0 0.0 L2 2/1 54.85 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 21/11 1.25 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 233.6 233.6 1.07 1.00 1 1.067 253K 0 0.0 0.0 L4 173/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 149.7 149.7 1.50 1.11 1 1.499 227K 0 0.0 0.0 L5 1040/0 85.69 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 1248/22 97.98 GB 0.0 1.8 1.0 0.7 3.6 2.9 1.2 1.9 137.2 281.3 13.10 11.95 33 0.397 1824K 1326 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.6 2.9 1.1 1.9 137.2 281.3 13.10 11.95 33 0.397 1824K 1326 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 1.0 0.7 1.8 1.0 0.0 0.0 231.0 230.9 7.78 7.18 7 1.111 1824K 1326 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.1 5.32 4.77 26 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.846, interval 1.846 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.60 GB write, 600.47 MB/s write, 1.75 GB read, 292.75 MB/s read, 13.1 seconds Interval compaction: 3.60 GB write, 620.74 MB/s write, 1.75 GB read, 302.64 MB/s read, 13.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 413108 Average: 2.1791 StdDev: 9.82 Min: 1 Median: 1.4702 Max: 2943 Percentiles: P50: 1.47 P75: 1.87 P99: 5.73 P99.9: 9.99 P99.99: 14.89 ------------------------------------------------------ [ 0, 1 ] 83900 20.309% 20.309% #### ( 1, 2 ] 260850 63.143% 83.453% ############# ( 2, 3 ] 36210 8.765% 92.218% ## ( 3, 4 ] 17332 4.196% 96.414% # ( 4, 6 ] 12374 2.995% 99.409% # ( 6, 10 ] 2034 0.492% 99.901% ( 10, 15 ] 376 0.091% 99.992% ( 15, 22 ] 33 0.008% 100.000% ( 22, 34 ] 6 0.001% 100.002% ( 34, 51 ] 2 0.000% 100.002% ( 51, 76 ] 6 0.001% 100.004% ( 110, 170 ] 17 0.004% 100.008% ( 170, 250 ] 7 0.002% 100.009% ( 250, 380 ] 10 0.002% 100.012% ( 380, 580 ] 5 0.001% 100.013% ( 580, 870 ] 6 0.001% 100.015% ( 870, 1300 ] 5 0.001% 100.016% ( 1300, 1900 ] 2 0.000% 100.016% ( 1900, 2900 ] 3 0.001% 100.017% ( 2900, 4400 ] 1 0.000% 100.017% ** Level 1 read latency histogram (micros): Count: 31 Average: 343.4516 StdDev: 752.07 Min: 1 Median: 2.2500 Max: 3511 Percentiles: P50: 2.25 P75: 290.62 P99: 3511.00 P99.9: 3511.00 P99.99: 3511.00 ------------------------------------------------------ [ 0, 1 ] 8 25.806% 25.806% ##### ( 1, 2 ] 7 22.581% 48.387% ##### ( 2, 3 ] 2 6.452% 54.839% # ( 4, 6 ] 1 3.226% 58.065% # ( 51, 76 ] 1 3.226% 61.290% # ( 110, 170 ] 1 3.226% 64.516% # ( 170, 250 ] 2 6.452% 70.968% # ( 250, 380 ] 4 12.903% 83.871% ### ( 380, 580 ] 1 3.226% 87.097% # ( 870, 1300 ] 1 3.226% 90.323% # ( 1300, 1900 ] 1 3.226% 93.548% # ( 1900, 2900 ] 1 3.226% 96.774% # ( 2900, 4400 ] 1 3.226% 100.000% # ** Level 2 read latency histogram (micros): Count: 95637 Average: 1.9578 StdDev: 5.94 Min: 0 Median: 1.3488 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.43 P99.9: 9.84 P99.99: 21.64 ------------------------------------------------------ [ 0, 1 ] 27856 29.127% 29.127% ###### ( 1, 2 ] 57235 59.846% 88.973% ############ ( 2, 3 ] 5439 5.687% 94.660% # ( 3, 4 ] 2887 3.019% 97.679% # ( 4, 6 ] 1768 1.849% 99.527% ( 6, 10 ] 371 0.388% 99.915% ( 10, 15 ] 61 0.064% 99.979% ( 15, 22 ] 11 0.012% 99.991% ( 22, 34 ] 1 0.001% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 110, 170 ] 1 0.001% 99.994% ( 250, 380 ] 2 0.002% 99.996% ( 380, 580 ] 1 0.001% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 186826 Average: 3.4331 StdDev: 34.06 Min: 1 Median: 1.6293 Max: 5246 Percentiles: P50: 1.63 P75: 2.18 P99: 9.17 P99.9: 170.19 P99.99: 560.07 ------------------------------------------------------ [ 0, 1 ] 22754 12.179% 12.179% ## ( 1, 2 ] 112290 60.104% 72.283% ############ ( 2, 3 ] 27693 14.823% 87.106% ### ( 3, 4 ] 10229 5.475% 92.581% # ( 4, 6 ] 9472 5.070% 97.651% # ( 6, 10 ] 3184 1.704% 99.356% ( 10, 15 ] 599 0.321% 99.676% ( 15, 22 ] 85 0.045% 99.722% ( 22, 34 ] 33 0.018% 99.739% ( 34, 51 ] 6 0.003% 99.743% ( 51, 76 ] 5 0.003% 99.745% ( 76, 110 ] 88 0.047% 99.792% ( 110, 170 ] 202 0.108% 99.900% ( 170, 250 ] 74 0.040% 99.940% ( 250, 380 ] 52 0.028% 99.968% ( 380, 580 ] 47 0.025% 99.993% ( 580, 870 ] 36 0.019% 100.012% ( 870, 1300 ] 17 0.009% 100.021% ( 1300, 1900 ] 10 0.005% 100.027% ( 1900, 2900 ] 8 0.004% 100.031% ( 2900, 4400 ] 3 0.002% 100.033% ( 4400, 6600 ] 2 0.001% 100.034% ** Level 4 read latency histogram (micros): Count: 310 Average: 137.4516 StdDev: 639.77 Min: 1 Median: 1.7719 Max: 6254 Percentiles: P50: 1.77 P75: 8.00 P99: 4250.00 P99.9: 6254.00 P99.99: 6254.00 ------------------------------------------------------ [ 0, 1 ] 67 21.613% 21.613% #### ( 1, 2 ] 114 36.774% 58.387% ####### ( 2, 3 ] 33 10.645% 69.032% ## ( 3, 4 ] 7 2.258% 71.290% ( 4, 6 ] 7 2.258% 73.548% ( 6, 10 ] 9 2.903% 76.452% # ( 10, 15 ] 37 11.935% 88.387% ## ( 15, 22 ] 4 1.290% 89.677% ( 51, 76 ] 1 0.323% 90.000% ( 76, 110 ] 1 0.323% 90.323% ( 110, 170 ] 6 1.935% 92.258% ( 170, 250 ] 1 0.323% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 1 0.323% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 5 1.613% 96.774% ( 1300, 1900 ] 5 1.613% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 2900, 4400 ] 1 0.323% 99.032% ( 4400, 6600 ] 3 0.968% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 320.73 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.795 H:M:S, 12.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.15 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.393 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/12-16:35:35 ... thread 0: (1000000,3000000) ops and (332382.1,335432.8) ops/second in (3.008586,8.943669) 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 10/4 1.35 GB 107.0 1.4 0.0 1.4 4.1 2.8 0.0 1.5 104.4 317.8 13.28 12.32 44 0.302 1407K 1482 0.0 0.0 L1 4/0 304.18 MB 30.4 1.2 1.2 0.0 1.2 1.2 0.2 1.0 236.3 235.7 5.08 4.94 2 2.538 1218K 3056 0.0 0.0 L2 4/3 515.09 MB 1.3 0.4 0.2 0.2 0.4 0.2 1.0 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 16/3 813.95 MB 0.5 1.2 0.3 0.9 1.2 0.3 0.4 4.1 228.3 227.9 5.52 4.96 3 1.839 1279K 2508 0.0 0.0 L4 173/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 149.7 149.7 1.50 1.11 1 1.499 227K 0 0.0 0.0 L5 1048/0 86.31 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1255/10 98.90 GB 0.0 4.3 1.9 2.5 7.1 4.6 2.8 2.6 165.5 270.7 26.87 24.77 52 0.517 4516K 7220 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.9 2.5 7.1 4.6 2.7 2.6 165.5 270.7 26.87 24.77 52 0.517 4516K 7220 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.3 1.9 2.5 4.3 1.9 0.0 0.0 235.7 235.3 18.87 17.62 13 1.451 4516K 7220 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 354.2 8.00 7.15 39 0.205 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.1 total, 8.9 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.10 GB write, 795.48 MB/s write, 4.34 GB read, 486.33 MB/s read, 26.9 seconds Interval compaction: 7.10 GB write, 813.30 MB/s write, 4.34 GB read, 497.23 MB/s read, 26.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 749947 Average: 2.2371 StdDev: 9.65 Min: 1 Median: 1.5094 Max: 3405 Percentiles: P50: 1.51 P75: 1.90 P99: 5.77 P99.9: 10.48 P99.99: 14.64 ------------------------------------------------------ [ 0, 1 ] 128073 17.078% 17.078% ### ( 1, 2 ] 484719 64.634% 81.711% ############# ( 2, 3 ] 72894 9.720% 91.431% ## ( 3, 4 ] 34775 4.637% 96.068% # ( 4, 6 ] 24902 3.321% 99.389% # ( 6, 10 ] 3758 0.501% 99.890% ( 10, 15 ] 812 0.108% 99.998% ( 15, 22 ] 63 0.008% 100.007% ( 22, 34 ] 12 0.002% 100.008% ( 34, 51 ] 2 0.000% 100.008% ( 51, 76 ] 9 0.001% 100.010% ( 110, 170 ] 22 0.003% 100.013% ( 170, 250 ] 13 0.002% 100.014% ( 250, 380 ] 16 0.002% 100.016% ( 380, 580 ] 6 0.001% 100.017% ( 580, 870 ] 11 0.001% 100.019% ( 870, 1300 ] 10 0.001% 100.020% ( 1300, 1900 ] 3 0.000% 100.020% ( 1900, 2900 ] 5 0.001% 100.021% ( 2900, 4400 ] 2 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 118632 Average: 3.4105 StdDev: 25.89 Min: 0 Median: 1.6999 Max: 3511 Percentiles: P50: 1.70 P75: 2.43 P99: 9.09 P99.9: 139.42 P99.99: 236.16 ------------------------------------------------------ [ 0, 1 ] 9339 7.872% 7.872% ## ( 1, 2 ] 71411 60.195% 68.068% ############ ( 2, 3 ] 19037 16.047% 84.115% ### ( 3, 4 ] 8524 7.185% 91.300% # ( 4, 6 ] 7616 6.420% 97.720% # ( 6, 10 ] 1965 1.656% 99.376% ( 10, 15 ] 480 0.405% 99.781% ( 15, 22 ] 47 0.040% 99.820% ( 22, 34 ] 3 0.003% 99.823% ( 34, 51 ] 3 0.003% 99.826% ( 51, 76 ] 2 0.002% 99.827% ( 76, 110 ] 29 0.024% 99.852% ( 110, 170 ] 117 0.099% 99.950% ( 170, 250 ] 57 0.048% 99.998% ( 250, 380 ] 40 0.034% 100.032% ( 380, 580 ] 29 0.024% 100.056% ( 580, 870 ] 20 0.017% 100.073% ( 870, 1300 ] 8 0.007% 100.080% ( 1300, 1900 ] 5 0.004% 100.084% ( 1900, 2900 ] 2 0.002% 100.086% ( 2900, 4400 ] 2 0.002% 100.088% ** Level 2 read latency histogram (micros): Count: 95915 Average: 1.9773 StdDev: 6.63 Min: 0 Median: 1.3504 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.89 P99.99: 202.68 ------------------------------------------------------ [ 0, 1 ] 27857 29.043% 29.043% ###### ( 1, 2 ] 57369 59.812% 88.856% ############ ( 2, 3 ] 5550 5.786% 94.642% # ( 3, 4 ] 2903 3.027% 97.669% # ( 4, 6 ] 1777 1.853% 99.521% ( 6, 10 ] 373 0.389% 99.910% ( 10, 15 ] 62 0.065% 99.975% ( 15, 22 ] 11 0.011% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 34, 51 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 271340 Average: 3.8115 StdDev: 33.89 Min: 0 Median: 1.6128 Max: 5246 Percentiles: P50: 1.61 P75: 2.10 P99: 9.50 P99.9: 335.80 P99.99: 786.68 ------------------------------------------------------ [ 0, 1 ] 34321 12.649% 12.649% ### ( 1, 2 ] 165387 60.952% 73.601% ############ ( 2, 3 ] 37272 13.736% 87.337% ### ( 3, 4 ] 14680 5.410% 92.747% # ( 4, 6 ] 12811 4.721% 97.468% # ( 6, 10 ] 4745 1.749% 99.217% ( 10, 15 ] 811 0.299% 99.516% ( 15, 22 ] 105 0.039% 99.555% ( 22, 34 ] 38 0.014% 99.569% ( 34, 51 ] 6 0.002% 99.571% ( 51, 76 ] 6 0.002% 99.573% ( 76, 110 ] 187 0.069% 99.642% ( 110, 170 ] 403 0.149% 99.791% ( 170, 250 ] 197 0.073% 99.863% ( 250, 380 ] 151 0.056% 99.919% ( 380, 580 ] 133 0.049% 99.968% ( 580, 870 ] 84 0.031% 99.999% ( 870, 1300 ] 37 0.014% 100.013% ( 1300, 1900 ] 15 0.006% 100.018% ( 1900, 2900 ] 8 0.003% 100.021% ( 2900, 4400 ] 3 0.001% 100.022% ( 4400, 6600 ] 2 0.001% 100.023% ** Level 4 read latency histogram (micros): Count: 310 Average: 137.4516 StdDev: 639.77 Min: 1 Median: 1.7719 Max: 6254 Percentiles: P50: 1.77 P75: 8.00 P99: 4250.00 P99.9: 6254.00 P99.99: 6254.00 ------------------------------------------------------ [ 0, 1 ] 67 21.613% 21.613% #### ( 1, 2 ] 114 36.774% 58.387% ####### ( 2, 3 ] 33 10.645% 69.032% ## ( 3, 4 ] 7 2.258% 71.290% ( 4, 6 ] 7 2.258% 73.548% ( 6, 10 ] 9 2.903% 76.452% # ( 10, 15 ] 37 11.935% 88.387% ## ( 15, 22 ] 4 1.290% 89.677% ( 51, 76 ] 1 0.323% 90.000% ( 76, 110 ] 1 0.323% 90.323% ( 110, 170 ] 6 1.935% 92.258% ( 170, 250 ] 1 0.323% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 1 0.323% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 5 1.613% 96.774% ( 1300, 1900 ] 5 1.613% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 2900, 4400 ] 1 0.323% 99.032% ( 4400, 6600 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 40 Average: 636.4000 StdDev: 705.57 Min: 88 Median: 250.0000 Max: 2321 Percentiles: P50: 250.00 P75: 977.50 P99: 2321.00 P99.9: 2321.00 P99.99: 2321.00 ------------------------------------------------------ ( 76, 110 ] 7 17.500% 17.500% #### ( 110, 170 ] 10 25.000% 42.500% ##### ( 170, 250 ] 3 7.500% 50.000% ## ( 250, 380 ] 3 7.500% 57.500% ## ( 380, 580 ] 4 10.000% 67.500% ## ( 580, 870 ] 2 5.000% 72.500% # ( 870, 1300 ] 4 10.000% 82.500% ## ( 1300, 1900 ] 3 7.500% 90.000% ## ( 1900, 2900 ] 4 10.000% 100.000% ## ** DB Stats ** Uptime(secs): 9.1 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 322.83 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.203 H:M:S, 13.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 327.13 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.409 H:M:S, 13.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/12-16:35:38 ... thread 0: (1000000,4000000) ops and (326217.1,333080.4) ops/second in (3.065443,12.009112) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/13 2.27 GB 25.2 2.2 0.0 2.2 5.8 3.7 0.0 1.6 115.7 313.9 19.06 17.74 60 0.318 2238K 2351 0.0 0.0 L1 4/4 304.18 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 236.3 235.7 5.08 4.94 2 2.538 1218K 3056 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 22/0 911.75 MB 0.9 2.2 0.8 1.4 2.2 0.8 0.4 2.7 225.7 225.2 9.80 9.01 6 1.633 2245K 4518 0.0 0.0 L4 176/0 9.68 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 149.7 149.7 1.50 1.11 1 1.499 227K 0 0.0 0.0 L5 1052/0 86.68 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1268/17 99.82 GB 0.0 6.1 2.4 3.7 9.8 6.1 3.6 2.6 168.4 270.4 36.93 34.24 71 0.520 6314K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.1 2.4 3.7 9.8 6.1 3.5 2.6 168.4 270.4 36.93 34.24 71 0.520 6314K 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 6.1 2.4 3.7 6.1 2.4 0.0 0.0 237.0 236.6 26.24 24.70 19 1.381 6314K 10K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 353.4 10.70 9.54 52 0.206 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.2 total, 12.0 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 9.75 GB write, 817.92 MB/s write, 6.07 GB read, 509.24 MB/s read, 36.9 seconds Interval compaction: 9.75 GB write, 831.57 MB/s write, 6.07 GB read, 517.73 MB/s read, 36.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 17, interval: 17 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1041625 Average: 2.2626 StdDev: 10.50 Min: 1 Median: 1.5089 Max: 3405 Percentiles: P50: 1.51 P75: 1.89 P99: 5.76 P99.9: 10.59 P99.99: 19.35 ------------------------------------------------------ [ 0, 1 ] 174886 16.790% 16.790% ### ( 1, 2 ] 679734 65.257% 82.047% ############# ( 2, 3 ] 99963 9.597% 91.644% ## ( 3, 4 ] 47122 4.524% 96.168% # ( 4, 6 ] 33546 3.221% 99.388% # ( 6, 10 ] 5215 0.501% 99.889% ( 10, 15 ] 1008 0.097% 99.986% ( 15, 22 ] 77 0.007% 99.993% ( 22, 34 ] 13 0.001% 99.994% ( 34, 51 ] 2 0.000% 99.994% ( 51, 76 ] 12 0.001% 99.995% ( 76, 110 ] 56 0.005% 100.001% ( 110, 170 ] 58 0.006% 100.006% ( 170, 250 ] 31 0.003% 100.009% ( 250, 380 ] 33 0.003% 100.013% ( 380, 580 ] 16 0.002% 100.014% ( 580, 870 ] 26 0.002% 100.017% ( 870, 1300 ] 17 0.002% 100.018% ( 1300, 1900 ] 5 0.000% 100.019% ( 1900, 2900 ] 7 0.001% 100.019% ( 2900, 4400 ] 3 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 254618 Average: 2.9305 StdDev: 18.66 Min: 0 Median: 1.6454 Max: 3511 Percentiles: P50: 1.65 P75: 2.18 P99: 8.38 P99.9: 26.15 P99.99: 202.62 ------------------------------------------------------ [ 0, 1 ] 22947 9.012% 9.012% ## ( 1, 2 ] 161711 63.511% 72.524% ############# ( 2, 3 ] 35855 14.082% 86.605% ### ( 3, 4 ] 15979 6.276% 92.881% # ( 4, 6 ] 13446 5.281% 98.162% # ( 6, 10 ] 3579 1.406% 99.568% ( 10, 15 ] 767 0.301% 99.869% ( 15, 22 ] 78 0.031% 99.899% ( 22, 34 ] 4 0.002% 99.901% ( 34, 51 ] 3 0.001% 99.902% ( 51, 76 ] 2 0.001% 99.903% ( 76, 110 ] 59 0.023% 99.926% ( 110, 170 ] 134 0.053% 99.979% ( 170, 250 ] 70 0.027% 100.006% ( 250, 380 ] 49 0.019% 100.026% ( 380, 580 ] 36 0.014% 100.040% ( 580, 870 ] 23 0.009% 100.049% ( 870, 1300 ] 11 0.004% 100.053% ( 1300, 1900 ] 5 0.002% 100.055% ( 1900, 2900 ] 2 0.001% 100.056% ( 2900, 4400 ] 2 0.001% 100.057% ** Level 2 read latency histogram (micros): Count: 95915 Average: 1.9773 StdDev: 6.63 Min: 0 Median: 1.3504 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.89 P99.99: 202.68 ------------------------------------------------------ [ 0, 1 ] 27857 29.043% 29.043% ###### ( 1, 2 ] 57369 59.812% 88.856% ############ ( 2, 3 ] 5550 5.786% 94.642% # ( 3, 4 ] 2903 3.027% 97.669% # ( 4, 6 ] 1777 1.853% 99.521% ( 6, 10 ] 373 0.389% 99.910% ( 10, 15 ] 62 0.065% 99.975% ( 15, 22 ] 11 0.011% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 34, 51 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 300672 Average: 3.6894 StdDev: 32.45 Min: 0 Median: 1.6032 Max: 5246 Percentiles: P50: 1.60 P75: 2.04 P99: 9.36 P99.9: 322.40 P99.99: 783.11 ------------------------------------------------------ [ 0, 1 ] 38779 12.897% 12.897% ### ( 1, 2 ] 184934 61.507% 74.404% ############ ( 2, 3 ] 40419 13.443% 87.847% ### ( 3, 4 ] 15799 5.255% 93.102% # ( 4, 6 ] 13581 4.517% 97.619% # ( 6, 10 ] 4943 1.644% 99.263% ( 10, 15 ] 859 0.286% 99.548% ( 15, 22 ] 114 0.038% 99.586% ( 22, 34 ] 39 0.013% 99.599% ( 34, 51 ] 6 0.002% 99.601% ( 51, 76 ] 6 0.002% 99.603% ( 76, 110 ] 188 0.063% 99.666% ( 110, 170 ] 415 0.138% 99.804% ( 170, 250 ] 203 0.068% 99.871% ( 250, 380 ] 155 0.052% 99.923% ( 380, 580 ] 141 0.047% 99.970% ( 580, 870 ] 87 0.029% 99.999% ( 870, 1300 ] 38 0.013% 100.011% ( 1300, 1900 ] 15 0.005% 100.016% ( 1900, 2900 ] 8 0.003% 100.019% ( 2900, 4400 ] 3 0.001% 100.020% ( 4400, 6600 ] 2 0.001% 100.021% ** Level 4 read latency histogram (micros): Count: 310 Average: 137.4516 StdDev: 639.77 Min: 1 Median: 1.7719 Max: 6254 Percentiles: P50: 1.77 P75: 8.00 P99: 4250.00 P99.9: 6254.00 P99.99: 6254.00 ------------------------------------------------------ [ 0, 1 ] 67 21.613% 21.613% #### ( 1, 2 ] 114 36.774% 58.387% ####### ( 2, 3 ] 33 10.645% 69.032% ## ( 3, 4 ] 7 2.258% 71.290% ( 4, 6 ] 7 2.258% 73.548% ( 6, 10 ] 9 2.903% 76.452% # ( 10, 15 ] 37 11.935% 88.387% ## ( 15, 22 ] 4 1.290% 89.677% ( 51, 76 ] 1 0.323% 90.000% ( 76, 110 ] 1 0.323% 90.323% ( 110, 170 ] 6 1.935% 92.258% ( 170, 250 ] 1 0.323% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 1 0.323% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 5 1.613% 96.774% ( 1300, 1900 ] 5 1.613% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 2900, 4400 ] 1 0.323% 99.032% ( 4400, 6600 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 697.4333 StdDev: 807.48 Min: 88 Median: 250.0000 Max: 3178 Percentiles: P50: 250.00 P75: 977.50 P99: 3178.00 P99.9: 3178.00 P99.99: 3178.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 16 26.667% 43.333% ##### ( 170, 250 ] 4 6.667% 50.000% # ( 250, 380 ] 3 5.000% 55.000% # ( 380, 580 ] 5 8.333% 63.333% ## ( 580, 870 ] 6 10.000% 73.333% ## ( 870, 1300 ] 4 6.667% 80.000% # ( 1300, 1900 ] 5 8.333% 88.333% ## ( 1900, 2900 ] 6 10.000% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 12.2 total, 3.1 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 322.39 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.666 H:M:S, 13.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.06 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.462 H:M:S, 15.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-16:35:41 ... thread 0: (1000000,5000000) ops and (293401.2,324308.6) ops/second in (3.408302,15.417414) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/13 3.32 GB 138.4 3.3 0.0 3.3 8.0 4.7 0.0 1.7 127.2 311.9 26.25 24.52 80 0.328 3390K 3543 0.0 0.0 L1 4/4 304.18 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 236.3 235.7 5.08 4.94 2 2.538 1218K 3056 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 1.0 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 22/0 911.75 MB 0.9 2.2 0.8 1.4 2.2 0.8 0.4 2.7 225.7 225.2 9.80 9.01 6 1.633 2245K 4518 0.0 0.0 L4 176/0 9.68 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 149.7 149.7 1.50 1.11 1 1.499 227K 0 0.0 0.0 L5 1052/0 86.68 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1272/17 100.86 GB 0.0 7.2 2.4 4.8 11.9 7.1 3.6 2.5 166.6 276.3 44.12 41.02 91 0.485 7465K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.2 2.4 4.8 11.9 7.1 3.5 2.5 166.6 276.3 44.12 41.02 91 0.485 7465K 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 7.2 2.4 4.8 7.2 2.4 0.0 0.0 241.8 241.4 30.41 28.80 23 1.322 7465K 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 353.6 13.72 12.22 68 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.6 total, 15.4 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.91 GB write, 780.52 MB/s write, 7.18 GB read, 470.71 MB/s read, 44.1 seconds Interval compaction: 11.91 GB write, 790.67 MB/s write, 7.18 GB read, 476.83 MB/s read, 44.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 19, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 19, interval: 24 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1522545 Average: 2.2443 StdDev: 9.96 Min: 1 Median: 1.5002 Max: 3405 Percentiles: P50: 1.50 P75: 1.88 P99: 5.76 P99.9: 10.30 P99.99: 16.75 ------------------------------------------------------ [ 0, 1 ] 258085 16.951% 16.951% ### ( 1, 2 ] 1005874 66.065% 83.016% ############# ( 2, 3 ] 139902 9.189% 92.205% ## ( 3, 4 ] 64736 4.252% 96.457% # ( 4, 6 ] 44086 2.896% 99.352% # ( 6, 10 ] 8255 0.542% 99.894% ( 10, 15 ] 1428 0.094% 99.988% ( 15, 22 ] 111 0.007% 99.996% ( 22, 34 ] 17 0.001% 99.997% ( 34, 51 ] 5 0.000% 99.997% ( 51, 76 ] 14 0.001% 99.998% ( 76, 110 ] 105 0.007% 100.005% ( 110, 170 ] 109 0.007% 100.012% ( 170, 250 ] 57 0.004% 100.016% ( 250, 380 ] 49 0.003% 100.019% ( 380, 580 ] 26 0.002% 100.021% ( 580, 870 ] 36 0.002% 100.023% ( 870, 1300 ] 24 0.002% 100.025% ( 1300, 1900 ] 8 0.001% 100.025% ( 1900, 2900 ] 10 0.001% 100.026% ( 2900, 4400 ] 3 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 260626 Average: 2.9574 StdDev: 18.78 Min: 0 Median: 1.6422 Max: 3511 Percentiles: P50: 1.64 P75: 2.16 P99: 8.44 P99.9: 95.52 P99.99: 216.87 ------------------------------------------------------ [ 0, 1 ] 23783 9.125% 9.125% ## ( 1, 2 ] 165877 63.646% 72.771% ############# ( 2, 3 ] 36357 13.950% 86.721% ### ( 3, 4 ] 16178 6.207% 92.928% # ( 4, 6 ] 13588 5.214% 98.142% # ( 6, 10 ] 3673 1.409% 99.551% ( 10, 15 ] 773 0.297% 99.848% ( 15, 22 ] 78 0.030% 99.878% ( 22, 34 ] 4 0.002% 99.879% ( 34, 51 ] 3 0.001% 99.880% ( 51, 76 ] 2 0.001% 99.881% ( 76, 110 ] 86 0.033% 99.914% ( 110, 170 ] 154 0.059% 99.973% ( 170, 250 ] 75 0.029% 100.002% ( 250, 380 ] 52 0.020% 100.022% ( 380, 580 ] 42 0.016% 100.038% ( 580, 870 ] 25 0.010% 100.048% ( 870, 1300 ] 11 0.004% 100.052% ( 1300, 1900 ] 5 0.002% 100.054% ( 1900, 2900 ] 2 0.001% 100.054% ( 2900, 4400 ] 2 0.001% 100.055% ** Level 2 read latency histogram (micros): Count: 95915 Average: 1.9773 StdDev: 6.63 Min: 0 Median: 1.3504 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.89 P99.99: 202.68 ------------------------------------------------------ [ 0, 1 ] 27857 29.043% 29.043% ###### ( 1, 2 ] 57369 59.812% 88.856% ############ ( 2, 3 ] 5550 5.786% 94.642% # ( 3, 4 ] 2903 3.027% 97.669% # ( 4, 6 ] 1777 1.853% 99.521% ( 6, 10 ] 373 0.389% 99.910% ( 10, 15 ] 62 0.065% 99.975% ( 15, 22 ] 11 0.011% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 34, 51 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 300672 Average: 3.6894 StdDev: 32.45 Min: 0 Median: 1.6032 Max: 5246 Percentiles: P50: 1.60 P75: 2.04 P99: 9.36 P99.9: 322.40 P99.99: 783.11 ------------------------------------------------------ [ 0, 1 ] 38779 12.897% 12.897% ### ( 1, 2 ] 184934 61.507% 74.404% ############ ( 2, 3 ] 40419 13.443% 87.847% ### ( 3, 4 ] 15799 5.255% 93.102% # ( 4, 6 ] 13581 4.517% 97.619% # ( 6, 10 ] 4943 1.644% 99.263% ( 10, 15 ] 859 0.286% 99.548% ( 15, 22 ] 114 0.038% 99.586% ( 22, 34 ] 39 0.013% 99.599% ( 34, 51 ] 6 0.002% 99.601% ( 51, 76 ] 6 0.002% 99.603% ( 76, 110 ] 188 0.063% 99.666% ( 110, 170 ] 415 0.138% 99.804% ( 170, 250 ] 203 0.068% 99.871% ( 250, 380 ] 155 0.052% 99.923% ( 380, 580 ] 141 0.047% 99.970% ( 580, 870 ] 87 0.029% 99.999% ( 870, 1300 ] 38 0.013% 100.011% ( 1300, 1900 ] 15 0.005% 100.016% ( 1900, 2900 ] 8 0.003% 100.019% ( 2900, 4400 ] 3 0.001% 100.020% ( 4400, 6600 ] 2 0.001% 100.021% ** Level 4 read latency histogram (micros): Count: 310 Average: 137.4516 StdDev: 639.77 Min: 1 Median: 1.7719 Max: 6254 Percentiles: P50: 1.77 P75: 8.00 P99: 4250.00 P99.9: 6254.00 P99.99: 6254.00 ------------------------------------------------------ [ 0, 1 ] 67 21.613% 21.613% #### ( 1, 2 ] 114 36.774% 58.387% ####### ( 2, 3 ] 33 10.645% 69.032% ## ( 3, 4 ] 7 2.258% 71.290% ( 4, 6 ] 7 2.258% 73.548% ( 6, 10 ] 9 2.903% 76.452% # ( 10, 15 ] 37 11.935% 88.387% ## ( 15, 22 ] 4 1.290% 89.677% ( 51, 76 ] 1 0.323% 90.000% ( 76, 110 ] 1 0.323% 90.323% ( 110, 170 ] 6 1.935% 92.258% ( 170, 250 ] 1 0.323% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 1 0.323% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 5 1.613% 96.774% ( 1300, 1900 ] 5 1.613% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 2900, 4400 ] 1 0.323% 99.032% ( 4400, 6600 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 697.4333 StdDev: 807.48 Min: 88 Median: 250.0000 Max: 3178 Percentiles: P50: 250.00 P75: 977.50 P99: 3178.00 P99.9: 3178.00 P99.99: 3178.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 16 26.667% 43.333% ##### ( 170, 250 ] 4 6.667% 50.000% # ( 250, 380 ] 3 5.000% 55.000% # ( 380, 580 ] 5 8.333% 63.333% ## ( 580, 870 ] 6 10.000% 73.333% ## ( 870, 1300 ] 4 6.667% 80.000% # ( 1300, 1900 ] 5 8.333% 88.333% ## ( 1900, 2900 ] 6 10.000% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 15.6 total, 3.4 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 315.05 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.436 H:M:S, 15.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 288.76 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.770 H:M:S, 22.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-16:35:46 ... thread 0: (1000000,6000000) ops and (193458.1,291453.3) ops/second in (5.169077,20.586491) 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/10 2.46 GB 88.1 4.0 0.0 4.0 9.6 5.6 0.0 1.7 128.3 307.7 31.93 29.54 96 0.333 4157K 4297 0.0 0.0 L1 5/0 576.80 MB 57.7 3.2 2.9 0.3 3.2 2.9 0.2 1.1 231.8 230.2 14.09 13.60 3 4.696 3316K 22K 0.0 0.0 L2 10/5 1.26 GB 6.4 0.4 0.2 0.2 0.4 0.2 2.5 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 26/10 1.07 GB 0.6 2.5 1.0 1.5 2.5 1.0 0.4 2.5 214.4 213.9 11.78 10.48 8 1.473 2565K 5623 0.0 0.0 L4 176/0 9.68 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.9 1.0 149.7 149.7 1.50 1.11 1 1.499 227K 0 0.0 0.0 L5 1052/0 86.68 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1282/25 101.70 GB 0.0 10.2 4.3 6.0 15.8 9.8 5.0 2.8 172.5 266.3 60.80 56.18 110 0.553 10M 32K 0.0 0.0 Int 0/0 0.00 KB 0.0 10.2 4.3 6.0 15.8 9.8 4.9 2.8 172.5 266.3 60.80 56.18 110 0.553 10M 32K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 10.2 4.3 6.0 10.2 4.2 0.0 0.0 237.4 236.6 44.19 41.66 29 1.524 10M 32K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.6 5.6 0.0 0.0 0.0 345.0 16.62 14.52 81 0.205 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): 20.8 total, 20.6 interval Flush(GB): cumulative 5.598, interval 5.598 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.81 GB write, 778.74 MB/s write, 10.24 GB read, 504.58 MB/s read, 60.8 seconds Interval compaction: 15.81 GB write, 786.33 MB/s write, 10.24 GB read, 509.49 MB/s read, 60.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 22, interval: 34 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1991561 Average: 2.2913 StdDev: 12.87 Min: 1 Median: 1.4985 Max: 4139 Percentiles: P50: 1.50 P75: 1.88 P99: 5.85 P99.9: 11.40 P99.99: 90.99 ------------------------------------------------------ [ 0, 1 ] 343893 17.268% 17.268% ### ( 1, 2 ] 1307614 65.658% 82.925% ############# ( 2, 3 ] 180026 9.039% 91.965% ## ( 3, 4 ] 84602 4.248% 96.213% # ( 4, 6 ] 60164 3.021% 99.234% # ( 6, 10 ] 12675 0.636% 99.870% ( 10, 15 ] 2128 0.107% 99.977% ( 15, 22 ] 147 0.007% 99.984% ( 22, 34 ] 18 0.001% 99.985% ( 34, 51 ] 10 0.001% 99.986% ( 51, 76 ] 15 0.001% 99.986% ( 76, 110 ] 163 0.008% 99.995% ( 110, 170 ] 192 0.010% 100.004% ( 170, 250 ] 87 0.004% 100.009% ( 250, 380 ] 80 0.004% 100.013% ( 380, 580 ] 56 0.003% 100.016% ( 580, 870 ] 58 0.003% 100.018% ( 870, 1300 ] 44 0.002% 100.021% ( 1300, 1900 ] 15 0.001% 100.021% ( 1900, 2900 ] 14 0.001% 100.022% ( 2900, 4400 ] 10 0.001% 100.023% ** Level 1 read latency histogram (micros): Count: 499288 Average: 3.5117 StdDev: 42.71 Min: 0 Median: 1.6910 Max: 7499 Percentiles: P50: 1.69 P75: 2.44 P99: 8.84 P99.9: 21.87 P99.99: 186.66 ------------------------------------------------------ [ 0, 1 ] 42949 8.602% 8.602% ## ( 1, 2 ] 299131 59.912% 68.514% ############ ( 2, 3 ] 74147 14.851% 83.364% ### ( 3, 4 ] 35991 7.208% 90.573% # ( 4, 6 ] 35810 7.172% 97.745% # ( 6, 10 ] 8838 1.770% 99.515% ( 10, 15 ] 1753 0.351% 99.866% ( 15, 22 ] 173 0.035% 99.901% ( 22, 34 ] 6 0.001% 99.902% ( 34, 51 ] 4 0.001% 99.903% ( 51, 76 ] 7 0.001% 99.904% ( 76, 110 ] 155 0.031% 99.935% ( 110, 170 ] 247 0.049% 99.985% ( 170, 250 ] 130 0.026% 100.011% ( 250, 380 ] 103 0.021% 100.031% ( 380, 580 ] 84 0.017% 100.048% ( 580, 870 ] 58 0.012% 100.060% ( 870, 1300 ] 32 0.006% 100.066% ( 1300, 1900 ] 20 0.004% 100.070% ( 1900, 2900 ] 29 0.006% 100.076% ( 2900, 4400 ] 28 0.006% 100.082% ( 4400, 6600 ] 5 0.001% 100.083% ( 6600, 9900 ] 2 0.000% 100.083% ** Level 2 read latency histogram (micros): Count: 95915 Average: 1.9773 StdDev: 6.63 Min: 0 Median: 1.3504 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.89 P99.99: 202.68 ------------------------------------------------------ [ 0, 1 ] 27857 29.043% 29.043% ###### ( 1, 2 ] 57369 59.812% 88.856% ############ ( 2, 3 ] 5550 5.786% 94.642% # ( 3, 4 ] 2903 3.027% 97.669% # ( 4, 6 ] 1777 1.853% 99.521% ( 6, 10 ] 373 0.389% 99.910% ( 10, 15 ] 62 0.065% 99.975% ( 15, 22 ] 11 0.011% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 34, 51 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 431473 Average: 4.8753 StdDev: 58.25 Min: 0 Median: 1.6956 Max: 7370 Percentiles: P50: 1.70 P75: 2.48 P99: 9.87 P99.9: 369.96 P99.99: 675.55 ------------------------------------------------------ [ 0, 1 ] 42708 9.898% 9.898% ## ( 1, 2 ] 248759 57.653% 67.552% ############ ( 2, 3 ] 66893 15.503% 83.055% ### ( 3, 4 ] 29768 6.899% 89.954% # ( 4, 6 ] 30241 7.009% 96.963% # ( 6, 10 ] 9088 2.106% 99.069% ( 10, 15 ] 1976 0.458% 99.527% ( 15, 22 ] 229 0.053% 99.580% ( 22, 34 ] 50 0.012% 99.592% ( 34, 51 ] 6 0.001% 99.593% ( 51, 76 ] 7 0.002% 99.595% ( 76, 110 ] 196 0.045% 99.640% ( 110, 170 ] 487 0.113% 99.753% ( 170, 250 ] 343 0.079% 99.833% ( 250, 380 ] 317 0.073% 99.906% ( 380, 580 ] 294 0.068% 99.974% ( 580, 870 ] 212 0.049% 100.023% ( 870, 1300 ] 81 0.019% 100.042% ( 1300, 1900 ] 40 0.009% 100.051% ( 1900, 2900 ] 42 0.010% 100.061% ( 2900, 4400 ] 38 0.009% 100.070% ( 4400, 6600 ] 10 0.002% 100.072% ( 6600, 9900 ] 1 0.000% 100.073% ** Level 4 read latency histogram (micros): Count: 310 Average: 137.4516 StdDev: 639.77 Min: 1 Median: 1.7719 Max: 6254 Percentiles: P50: 1.77 P75: 8.00 P99: 4250.00 P99.9: 6254.00 P99.99: 6254.00 ------------------------------------------------------ [ 0, 1 ] 67 21.613% 21.613% #### ( 1, 2 ] 114 36.774% 58.387% ####### ( 2, 3 ] 33 10.645% 69.032% ## ( 3, 4 ] 7 2.258% 71.290% ( 4, 6 ] 7 2.258% 73.548% ( 6, 10 ] 9 2.903% 76.452% # ( 10, 15 ] 37 11.935% 88.387% ## ( 15, 22 ] 4 1.290% 89.677% ( 51, 76 ] 1 0.323% 90.000% ( 76, 110 ] 1 0.323% 90.323% ( 110, 170 ] 6 1.935% 92.258% ( 170, 250 ] 1 0.323% 92.581% ( 250, 380 ] 3 0.968% 93.548% ( 380, 580 ] 1 0.323% 93.871% ( 580, 870 ] 4 1.290% 95.161% ( 870, 1300 ] 5 1.613% 96.774% ( 1300, 1900 ] 5 1.613% 98.387% ( 1900, 2900 ] 1 0.323% 98.710% ( 2900, 4400 ] 1 0.323% 99.032% ( 4400, 6600 ] 3 0.968% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 697.4333 StdDev: 807.48 Min: 88 Median: 250.0000 Max: 3178 Percentiles: P50: 250.00 P75: 977.50 P99: 3178.00 P99.9: 3178.00 P99.99: 3178.00 ------------------------------------------------------ ( 76, 110 ] 10 16.667% 16.667% ### ( 110, 170 ] 16 26.667% 43.333% ##### ( 170, 250 ] 4 6.667% 50.000% # ( 250, 380 ] 3 5.000% 55.000% # ( 380, 580 ] 5 8.333% 63.333% ## ( 580, 870 ] 6 10.000% 73.333% ## ( 870, 1300 ] 4 6.667% 80.000% # ( 1300, 1900 ] 5 8.333% 88.333% ## ( 1900, 2900 ] 6 10.000% 98.333% ## ( 2900, 4400 ] 1 1.667% 100.000% ** DB Stats ** Uptime(secs): 20.8 total, 5.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 284.06 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:4.714 H:M:S, 22.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 190.40 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.278 H:M:S, 44.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 7 num-running-flushes: 1 2024/07/12-16:35:51 ... thread 0: (1000000,7000000) ops and (212727.8,276818.4) ops/second in (4.700842,25.287333) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/8 3.44 GB 288.8 5.9 0.0 5.9 12.5 6.6 0.0 1.9 133.9 282.8 45.16 39.88 112 0.403 6139K 12K 0.0 0.0 L1 5/0 576.80 MB 57.7 3.2 2.9 0.3 3.2 2.9 0.2 1.1 231.8 230.2 14.09 13.60 3 4.696 3316K 22K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 26/0 997.89 MB 1.0 4.9 2.2 2.7 4.9 2.2 0.4 2.2 185.2 184.5 27.29 22.09 18 1.516 5133K 19K 0.0 0.0 L4 190/0 9.72 GB 1.0 1.7 1.6 0.1 1.7 1.6 0.9 1.1 127.5 127.3 13.41 7.89 31 0.433 1673K 1598 0.0 0.0 L5 1068/0 87.97 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1304/8 102.66 GB 0.0 16.1 6.9 9.2 22.6 13.4 6.3 3.4 162.2 228.1 101.46 84.90 166 0.611 16M 56K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.1 6.9 9.2 22.6 13.4 6.2 3.4 162.2 228.1 101.46 84.90 166 0.611 16M 56K 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 16.1 6.9 9.2 16.0 6.8 0.0 0.0 204.9 204.2 80.30 67.73 72 1.115 16M 56K 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 318.6 21.16 17.17 94 0.225 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): 25.5 total, 25.3 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 22.60 GB write, 907.74 MB/s write, 16.07 GB read, 645.59 MB/s read, 101.5 seconds Interval compaction: 22.60 GB write, 914.93 MB/s write, 16.07 GB read, 650.70 MB/s read, 101.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 47, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 47, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2439841 Average: 2.4949 StdDev: 22.24 Min: 1 Median: 1.5301 Max: 8593 Percentiles: P50: 1.53 P75: 1.92 P99: 6.08 P99.9: 12.79 P99.99: 135.39 ------------------------------------------------------ [ 0, 1 ] 394187 16.156% 16.156% ### ( 1, 2 ] 1557836 63.850% 80.006% ############# ( 2, 3 ] 242284 9.930% 89.936% ## ( 3, 4 ] 122067 5.003% 94.940% # ( 4, 6 ] 98672 4.044% 98.984% # ( 6, 10 ] 20415 0.837% 99.820% ( 10, 15 ] 3480 0.143% 99.963% ( 15, 22 ] 250 0.010% 99.973% ( 22, 34 ] 28 0.001% 99.975% ( 34, 51 ] 17 0.001% 99.975% ( 51, 76 ] 15 0.001% 99.976% ( 76, 110 ] 236 0.010% 99.985% ( 110, 170 ] 260 0.011% 99.996% ( 170, 250 ] 137 0.006% 100.002% ( 250, 380 ] 139 0.006% 100.007% ( 380, 580 ] 111 0.005% 100.012% ( 580, 870 ] 108 0.004% 100.016% ( 870, 1300 ] 72 0.003% 100.019% ( 1300, 1900 ] 31 0.001% 100.021% ( 1900, 2900 ] 34 0.001% 100.022% ( 2900, 4400 ] 40 0.002% 100.024% ( 4400, 6600 ] 3 0.000% 100.024% ( 6600, 9900 ] 2 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 703688 Average: 4.1322 StdDev: 56.23 Min: 0 Median: 1.7566 Max: 7623 Percentiles: P50: 1.76 P75: 2.67 P99: 9.26 P99.9: 21.18 P99.99: 209.64 ------------------------------------------------------ [ 0, 1 ] 48479 6.889% 6.889% # ( 1, 2 ] 400984 56.983% 63.872% ########### ( 2, 3 ] 116522 16.559% 80.431% ### ( 3, 4 ] 57685 8.198% 88.629% ## ( 4, 6 ] 61110 8.684% 97.313% ## ( 6, 10 ] 14551 2.068% 99.381% ( 10, 15 ] 3378 0.480% 99.861% ( 15, 22 ] 312 0.044% 99.905% ( 22, 34 ] 13 0.002% 99.907% ( 34, 51 ] 10 0.001% 99.908% ( 51, 76 ] 13 0.002% 99.910% ( 76, 110 ] 181 0.026% 99.936% ( 110, 170 ] 285 0.041% 99.977% ( 170, 250 ] 191 0.027% 100.004% ( 250, 380 ] 178 0.025% 100.029% ( 380, 580 ] 149 0.021% 100.050% ( 580, 870 ] 138 0.020% 100.070% ( 870, 1300 ] 76 0.011% 100.081% ( 1300, 1900 ] 40 0.006% 100.086% ( 1900, 2900 ] 72 0.010% 100.096% ( 2900, 4400 ] 77 0.011% 100.107% ( 4400, 6600 ] 11 0.002% 100.109% ( 6600, 9900 ] 5 0.001% 100.110% ** Level 2 read latency histogram (micros): Count: 95915 Average: 1.9773 StdDev: 6.63 Min: 0 Median: 1.3504 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.89 P99.99: 202.68 ------------------------------------------------------ [ 0, 1 ] 27857 29.043% 29.043% ###### ( 1, 2 ] 57369 59.812% 88.856% ############ ( 2, 3 ] 5550 5.786% 94.642% # ( 3, 4 ] 2903 3.027% 97.669% # ( 4, 6 ] 1777 1.853% 99.521% ( 6, 10 ] 373 0.389% 99.910% ( 10, 15 ] 62 0.065% 99.975% ( 15, 22 ] 11 0.011% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 34, 51 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 993455 Average: 5.1592 StdDev: 71.34 Min: 0 Median: 1.8364 Max: 8445 Percentiles: P50: 1.84 P75: 2.87 P99: 9.32 P99.9: 215.71 P99.99: 500.91 ------------------------------------------------------ [ 0, 1 ] 55775 5.614% 5.614% # ( 1, 2 ] 527177 53.065% 58.679% ########### ( 2, 3 ] 186614 18.784% 77.464% #### ( 3, 4 ] 95307 9.593% 87.057% ## ( 4, 6 ] 101904 10.258% 97.315% ## ( 6, 10 ] 20192 2.033% 99.347% ( 10, 15 ] 3940 0.397% 99.744% ( 15, 22 ] 442 0.044% 99.788% ( 22, 34 ] 73 0.007% 99.796% ( 34, 51 ] 20 0.002% 99.798% ( 51, 76 ] 13 0.001% 99.799% ( 76, 110 ] 201 0.020% 99.819% ( 110, 170 ] 571 0.057% 99.877% ( 170, 250 ] 407 0.041% 99.918% ( 250, 380 ] 447 0.045% 99.963% ( 380, 580 ] 451 0.045% 100.008% ( 580, 870 ] 402 0.040% 100.048% ( 870, 1300 ] 219 0.022% 100.070% ( 1300, 1900 ] 117 0.012% 100.082% ( 1900, 2900 ] 124 0.012% 100.095% ( 2900, 4400 ] 154 0.016% 100.110% ( 4400, 6600 ] 44 0.004% 100.115% ( 6600, 9900 ] 4 0.000% 100.115% ** Level 4 read latency histogram (micros): Count: 30349 Average: 81.9441 StdDev: 435.83 Min: 1 Median: 1.9367 Max: 11044 Percentiles: P50: 1.94 P75: 3.27 P99: 2161.66 P99.9: 5641.47 P99.99: 8114.22 ------------------------------------------------------ [ 0, 1 ] 1591 5.242% 5.242% # ( 1, 2 ] 14501 47.781% 53.023% ########## ( 2, 3 ] 5746 18.933% 71.956% #### ( 3, 4 ] 3473 11.444% 83.400% ## ( 4, 6 ] 2190 7.216% 90.616% # ( 6, 10 ] 604 1.990% 92.606% ( 10, 15 ] 215 0.708% 93.314% ( 15, 22 ] 18 0.059% 93.374% ( 34, 51 ] 1 0.003% 93.377% ( 51, 76 ] 1 0.003% 93.380% ( 76, 110 ] 15 0.049% 93.430% ( 110, 170 ] 96 0.316% 93.746% ( 170, 250 ] 118 0.389% 94.135% ( 250, 380 ] 166 0.547% 94.682% ( 380, 580 ] 341 1.124% 95.805% ( 580, 870 ] 388 1.278% 97.084% ( 870, 1300 ] 333 1.097% 98.181% ( 1300, 1900 ] 209 0.689% 98.870% ( 1900, 2900 ] 151 0.498% 99.367% ( 2900, 4400 ] 134 0.442% 99.809% ( 4400, 6600 ] 49 0.161% 99.970% ( 6600, 9900 ] 13 0.043% 100.013% ( 9900, 14000 ] 1 0.003% 100.016% ** Level 5 read latency histogram (micros): Count: 140 Average: 1131.9643 StdDev: 1304.99 Min: 86 Median: 542.5000 Max: 7133 Percentiles: P50: 542.50 P75: 1900.00 P99: 6306.67 P99.9: 7133.00 P99.99: 7133.00 ------------------------------------------------------ ( 76, 110 ] 14 10.000% 10.000% ## ( 110, 170 ] 27 19.286% 29.286% #### ( 170, 250 ] 9 6.429% 35.714% # ( 250, 380 ] 7 5.000% 40.714% # ( 380, 580 ] 16 11.429% 52.143% ## ( 580, 870 ] 13 9.286% 61.429% ## ( 870, 1300 ] 9 6.429% 67.857% # ( 1300, 1900 ] 10 7.143% 75.000% # ( 1900, 2900 ] 19 13.571% 88.571% ### ( 2900, 4400 ] 12 8.571% 97.143% ## ( 4400, 6600 ] 3 2.143% 99.286% ( 6600, 9900 ] 1 0.714% 100.000% ** DB Stats ** Uptime(secs): 25.5 total, 4.7 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 270.28 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:6.534 H:M:S, 25.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 209.36 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.820 H:M:S, 38.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/12-16:35:54 ... thread 0: (1000000,8000000) ops and (318691.0,281440.7) ops/second in (3.137836,28.425169) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/4 4.48 GB 433.5 7.1 0.0 7.1 14.7 7.6 0.0 1.9 138.3 285.9 52.83 47.14 130 0.406 7418K 13K 0.0 0.0 L1 5/0 576.80 MB 57.7 3.2 2.9 0.3 3.2 2.9 0.2 1.1 231.8 230.2 14.09 13.60 3 4.696 3316K 22K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 2.5 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 26/0 997.89 MB 1.0 4.9 2.2 2.7 4.9 2.2 0.4 2.2 185.2 184.5 27.29 22.09 18 1.516 5133K 19K 0.0 0.0 L4 190/0 9.72 GB 1.0 1.7 1.6 0.1 1.7 1.6 0.9 1.1 127.5 127.3 13.41 7.89 31 0.433 1673K 1598 0.0 0.0 L5 1068/0 87.97 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1306/4 103.71 GB 0.0 17.3 6.9 10.4 24.9 14.4 6.3 3.3 162.3 233.4 109.12 92.17 184 0.593 17M 57K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.3 6.9 10.4 24.9 14.4 6.2 3.3 162.3 233.4 109.12 92.17 184 0.593 17M 57K 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.3 6.9 10.4 17.2 6.8 0.0 0.0 208.4 207.7 85.02 72.37 76 1.119 17M 57K 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 324.1 24.10 19.79 108 0.223 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.6 total, 28.4 interval Flush(GB): cumulative 7.628, interval 7.628 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, 889.56 MB/s write, 17.30 GB read, 618.81 MB/s read, 109.1 seconds Interval compaction: 24.87 GB write, 895.84 MB/s write, 17.30 GB read, 623.17 MB/s read, 109.1 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 12, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 12, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 52, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 12, total-stops: 52, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2719436 Average: 2.4360 StdDev: 21.29 Min: 1 Median: 1.5094 Max: 8593 Percentiles: P50: 1.51 P75: 1.90 P99: 5.97 P99.9: 12.61 P99.99: 129.71 ------------------------------------------------------ [ 0, 1 ] 476724 17.530% 17.530% #### ( 1, 2 ] 1733570 63.747% 81.278% ############# ( 2, 3 ] 254503 9.359% 90.636% ## ( 3, 4 ] 127653 4.694% 95.330% # ( 4, 6 ] 101332 3.726% 99.057% # ( 6, 10 ] 20991 0.772% 99.829% ( 10, 15 ] 3724 0.137% 99.965% ( 15, 22 ] 274 0.010% 99.976% ( 22, 34 ] 32 0.001% 99.977% ( 34, 51 ] 19 0.001% 99.977% ( 51, 76 ] 19 0.001% 99.978% ( 76, 110 ] 236 0.009% 99.987% ( 110, 170 ] 265 0.010% 99.997% ( 170, 250 ] 144 0.005% 100.002% ( 250, 380 ] 145 0.005% 100.007% ( 380, 580 ] 113 0.004% 100.011% ( 580, 870 ] 115 0.004% 100.016% ( 870, 1300 ] 76 0.003% 100.018% ( 1300, 1900 ] 34 0.001% 100.020% ( 1900, 2900 ] 36 0.001% 100.021% ( 2900, 4400 ] 40 0.001% 100.022% ( 4400, 6600 ] 3 0.000% 100.023% ( 6600, 9900 ] 2 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 703688 Average: 4.1322 StdDev: 56.23 Min: 0 Median: 1.7566 Max: 7623 Percentiles: P50: 1.76 P75: 2.67 P99: 9.26 P99.9: 21.18 P99.99: 209.64 ------------------------------------------------------ [ 0, 1 ] 48479 6.889% 6.889% # ( 1, 2 ] 400984 56.983% 63.872% ########### ( 2, 3 ] 116522 16.559% 80.431% ### ( 3, 4 ] 57685 8.198% 88.629% ## ( 4, 6 ] 61110 8.684% 97.313% ## ( 6, 10 ] 14551 2.068% 99.381% ( 10, 15 ] 3378 0.480% 99.861% ( 15, 22 ] 312 0.044% 99.905% ( 22, 34 ] 13 0.002% 99.907% ( 34, 51 ] 10 0.001% 99.908% ( 51, 76 ] 13 0.002% 99.910% ( 76, 110 ] 181 0.026% 99.936% ( 110, 170 ] 285 0.041% 99.977% ( 170, 250 ] 191 0.027% 100.004% ( 250, 380 ] 178 0.025% 100.029% ( 380, 580 ] 149 0.021% 100.050% ( 580, 870 ] 138 0.020% 100.070% ( 870, 1300 ] 76 0.011% 100.081% ( 1300, 1900 ] 40 0.006% 100.086% ( 1900, 2900 ] 72 0.010% 100.096% ( 2900, 4400 ] 77 0.011% 100.107% ( 4400, 6600 ] 11 0.002% 100.109% ( 6600, 9900 ] 5 0.001% 100.110% ** Level 2 read latency histogram (micros): Count: 95915 Average: 1.9773 StdDev: 6.63 Min: 0 Median: 1.3504 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.89 P99.99: 202.68 ------------------------------------------------------ [ 0, 1 ] 27857 29.043% 29.043% ###### ( 1, 2 ] 57369 59.812% 88.856% ############ ( 2, 3 ] 5550 5.786% 94.642% # ( 3, 4 ] 2903 3.027% 97.669% # ( 4, 6 ] 1777 1.853% 99.521% ( 6, 10 ] 373 0.389% 99.910% ( 10, 15 ] 62 0.065% 99.975% ( 15, 22 ] 11 0.011% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 34, 51 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 993455 Average: 5.1592 StdDev: 71.34 Min: 0 Median: 1.8364 Max: 8445 Percentiles: P50: 1.84 P75: 2.87 P99: 9.32 P99.9: 215.71 P99.99: 500.91 ------------------------------------------------------ [ 0, 1 ] 55775 5.614% 5.614% # ( 1, 2 ] 527177 53.065% 58.679% ########### ( 2, 3 ] 186614 18.784% 77.464% #### ( 3, 4 ] 95307 9.593% 87.057% ## ( 4, 6 ] 101904 10.258% 97.315% ## ( 6, 10 ] 20192 2.033% 99.347% ( 10, 15 ] 3940 0.397% 99.744% ( 15, 22 ] 442 0.044% 99.788% ( 22, 34 ] 73 0.007% 99.796% ( 34, 51 ] 20 0.002% 99.798% ( 51, 76 ] 13 0.001% 99.799% ( 76, 110 ] 201 0.020% 99.819% ( 110, 170 ] 571 0.057% 99.877% ( 170, 250 ] 407 0.041% 99.918% ( 250, 380 ] 447 0.045% 99.963% ( 380, 580 ] 451 0.045% 100.008% ( 580, 870 ] 402 0.040% 100.048% ( 870, 1300 ] 219 0.022% 100.070% ( 1300, 1900 ] 117 0.012% 100.082% ( 1900, 2900 ] 124 0.012% 100.095% ( 2900, 4400 ] 154 0.016% 100.110% ( 4400, 6600 ] 44 0.004% 100.115% ( 6600, 9900 ] 4 0.000% 100.115% ** Level 4 read latency histogram (micros): Count: 30349 Average: 81.9441 StdDev: 435.83 Min: 1 Median: 1.9367 Max: 11044 Percentiles: P50: 1.94 P75: 3.27 P99: 2161.66 P99.9: 5641.47 P99.99: 8114.22 ------------------------------------------------------ [ 0, 1 ] 1591 5.242% 5.242% # ( 1, 2 ] 14501 47.781% 53.023% ########## ( 2, 3 ] 5746 18.933% 71.956% #### ( 3, 4 ] 3473 11.444% 83.400% ## ( 4, 6 ] 2190 7.216% 90.616% # ( 6, 10 ] 604 1.990% 92.606% ( 10, 15 ] 215 0.708% 93.314% ( 15, 22 ] 18 0.059% 93.374% ( 34, 51 ] 1 0.003% 93.377% ( 51, 76 ] 1 0.003% 93.380% ( 76, 110 ] 15 0.049% 93.430% ( 110, 170 ] 96 0.316% 93.746% ( 170, 250 ] 118 0.389% 94.135% ( 250, 380 ] 166 0.547% 94.682% ( 380, 580 ] 341 1.124% 95.805% ( 580, 870 ] 388 1.278% 97.084% ( 870, 1300 ] 333 1.097% 98.181% ( 1300, 1900 ] 209 0.689% 98.870% ( 1900, 2900 ] 151 0.498% 99.367% ( 2900, 4400 ] 134 0.442% 99.809% ( 4400, 6600 ] 49 0.161% 99.970% ( 6600, 9900 ] 13 0.043% 100.013% ( 9900, 14000 ] 1 0.003% 100.016% ** Level 5 read latency histogram (micros): Count: 140 Average: 1131.9643 StdDev: 1304.99 Min: 86 Median: 542.5000 Max: 7133 Percentiles: P50: 542.50 P75: 1900.00 P99: 6306.67 P99.9: 7133.00 P99.99: 7133.00 ------------------------------------------------------ ( 76, 110 ] 14 10.000% 10.000% ## ( 110, 170 ] 27 19.286% 29.286% #### ( 170, 250 ] 9 6.429% 35.714% # ( 250, 380 ] 7 5.000% 40.714% # ( 380, 580 ] 16 11.429% 52.143% ## ( 580, 870 ] 13 9.286% 61.429% ## ( 870, 1300 ] 9 6.429% 67.857% # ( 1300, 1900 ] 10 7.143% 75.000% # ( 1900, 2900 ] 19 13.571% 88.571% ### ( 2900, 4400 ] 12 8.571% 97.143% ## ( 4400, 6600 ] 3 2.143% 99.286% ( 6600, 9900 ] 1 0.714% 100.000% ** DB Stats ** Uptime(secs): 28.6 total, 3.1 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 275.02 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.103 H:M:S, 24.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 313.46 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.570 H:M:S, 18.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/12-16:36:25 ... thread 0: (1000000,9000000) ops and (31785.6,150285.6) ops/second in (31.460805,59.885974) 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 3/3 377.71 MB 0.0 8.2 0.0 8.2 16.7 8.5 0.0 2.0 141.2 288.5 59.33 53.32 148 0.401 8506K 14K 0.0 0.0 L1 0/0 0.00 KB 0.0 8.8 7.9 0.9 8.6 7.8 0.2 1.1 208.2 204.2 43.22 38.54 4 10.804 9135K 172K 0.0 0.0 L2 33/16 3.11 GB 13.3 0.4 0.2 0.2 0.4 0.2 7.9 2.0 251.6 251.4 1.50 1.45 2 0.751 383K 174 0.0 0.0 L3 49/9 3.32 GB 3.2 4.9 2.2 2.7 4.9 2.2 2.8 2.2 185.2 184.5 27.29 22.09 18 1.516 5133K 19K 0.0 0.0 L4 190/0 9.72 GB 1.0 1.7 1.6 0.1 1.7 1.6 0.9 1.1 127.5 127.3 13.41 7.89 31 0.433 1673K 1598 0.0 0.0 L5 1068/0 87.97 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1343/28 104.48 GB 0.0 23.9 11.9 12.0 32.3 20.2 14.1 3.8 169.4 228.4 144.75 123.28 203 0.713 24M 208K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.9 11.9 12.0 32.3 20.2 14.0 3.8 169.4 228.4 144.75 123.28 203 0.713 24M 208K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.9 11.9 12.0 23.7 11.7 0.0 0.0 207.6 205.8 118.09 101.19 81 1.458 24M 208K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.6 8.6 0.0 0.0 0.0 328.4 26.66 22.09 122 0.219 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): 60.1 total, 59.9 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 32.29 GB write, 550.22 MB/s write, 23.94 GB read, 408.00 MB/s read, 144.8 seconds Interval compaction: 32.29 GB write, 552.07 MB/s write, 23.94 GB read, 409.37 MB/s read, 144.8 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: 53, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 24, total-stops: 53, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4253030 Average: 3.1242 StdDev: 23.39 Min: 0 Median: 1.4394 Max: 8593 Percentiles: P50: 1.44 P75: 1.84 P99: 9.00 P99.9: 164.69 P99.99: 476.54 ------------------------------------------------------ [ 0, 1 ] 957141 22.505% 22.505% ##### ( 1, 2 ] 2661370 62.576% 85.081% ############# ( 2, 3 ] 293775 6.907% 91.988% # ( 3, 4 ] 156852 3.688% 95.676% # ( 4, 6 ] 116556 2.741% 98.417% # ( 6, 10 ] 33114 0.779% 99.195% ( 10, 15 ] 5615 0.132% 99.327% ( 15, 22 ] 922 0.022% 99.349% ( 22, 34 ] 58 0.001% 99.350% ( 34, 51 ] 25 0.001% 99.351% ( 51, 76 ] 99 0.002% 99.353% ( 76, 110 ] 14225 0.334% 99.688% ( 110, 170 ] 9903 0.233% 99.921% ( 170, 250 ] 1443 0.034% 99.955% ( 250, 380 ] 1067 0.025% 99.980% ( 380, 580 ] 913 0.021% 100.001% ( 580, 870 ] 344 0.008% 100.009% ( 870, 1300 ] 94 0.002% 100.011% ( 1300, 1900 ] 49 0.001% 100.013% ( 1900, 2900 ] 58 0.001% 100.014% ( 2900, 4400 ] 46 0.001% 100.015% ( 4400, 6600 ] 3 0.000% 100.015% ( 6600, 9900 ] 4 0.000% 100.015% ** Level 1 read latency histogram (micros): Count: 907350 Average: 4.3539 StdDev: 54.93 Min: 0 Median: 1.7024 Max: 8016 Percentiles: P50: 1.70 P75: 2.57 P99: 9.83 P99.9: 145.74 P99.99: 227.76 ------------------------------------------------------ [ 0, 1 ] 100908 11.121% 11.121% ## ( 1, 2 ] 502231 55.351% 66.473% ########### ( 2, 3 ] 134895 14.867% 81.340% ### ( 3, 4 ] 72659 8.008% 89.347% ## ( 4, 6 ] 71006 7.826% 97.173% ## ( 6, 10 ] 17319 1.909% 99.082% ( 10, 15 ] 4043 0.446% 99.527% ( 15, 22 ] 416 0.046% 99.573% ( 22, 34 ] 22 0.002% 99.576% ( 34, 51 ] 13 0.001% 99.577% ( 51, 76 ] 69 0.008% 99.585% ( 76, 110 ] 1954 0.215% 99.800% ( 110, 170 ] 1527 0.168% 99.968% ( 170, 250 ] 276 0.030% 99.999% ( 250, 380 ] 259 0.029% 100.027% ( 380, 580 ] 218 0.024% 100.051% ( 580, 870 ] 192 0.021% 100.072% ( 870, 1300 ] 102 0.011% 100.084% ( 1300, 1900 ] 57 0.006% 100.090% ( 1900, 2900 ] 76 0.008% 100.098% ( 2900, 4400 ] 89 0.010% 100.108% ( 4400, 6600 ] 12 0.001% 100.109% ( 6600, 9900 ] 7 0.001% 100.110% ** Level 2 read latency histogram (micros): Count: 95915 Average: 1.9773 StdDev: 6.63 Min: 0 Median: 1.3504 Max: 1361 Percentiles: P50: 1.35 P75: 1.77 P99: 5.44 P99.9: 9.89 P99.99: 202.68 ------------------------------------------------------ [ 0, 1 ] 27857 29.043% 29.043% ###### ( 1, 2 ] 57369 59.812% 88.856% ############ ( 2, 3 ] 5550 5.786% 94.642% # ( 3, 4 ] 2903 3.027% 97.669% # ( 4, 6 ] 1777 1.853% 99.521% ( 6, 10 ] 373 0.389% 99.910% ( 10, 15 ] 62 0.065% 99.975% ( 15, 22 ] 11 0.011% 99.986% ( 22, 34 ] 1 0.001% 99.987% ( 34, 51 ] 1 0.001% 99.989% ( 110, 170 ] 1 0.001% 99.990% ( 170, 250 ] 1 0.001% 99.991% ( 250, 380 ] 3 0.003% 99.994% ( 380, 580 ] 2 0.002% 99.996% ( 580, 870 ] 3 0.003% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1000243 Average: 5.4527 StdDev: 75.80 Min: 0 Median: 1.8375 Max: 11471 Percentiles: P50: 1.84 P75: 2.87 P99: 9.43 P99.9: 279.07 P99.99: 561.07 ------------------------------------------------------ [ 0, 1 ] 56010 5.600% 5.600% # ( 1, 2 ] 530278 53.015% 58.615% ########### ( 2, 3 ] 187821 18.778% 77.392% #### ( 3, 4 ] 96051 9.603% 86.995% ## ( 4, 6 ] 102616 10.259% 97.254% ## ( 6, 10 ] 20346 2.034% 99.288% ( 10, 15 ] 4008 0.401% 99.689% ( 15, 22 ] 450 0.045% 99.734% ( 22, 34 ] 74 0.007% 99.741% ( 34, 51 ] 20 0.002% 99.743% ( 51, 76 ] 13 0.001% 99.744% ( 76, 110 ] 251 0.025% 99.770% ( 110, 170 ] 704 0.070% 99.840% ( 170, 250 ] 483 0.048% 99.888% ( 250, 380 ] 531 0.053% 99.941% ( 380, 580 ] 539 0.054% 99.995% ( 580, 870 ] 465 0.046% 100.042% ( 870, 1300 ] 251 0.025% 100.067% ( 1300, 1900 ] 128 0.013% 100.080% ( 1900, 2900 ] 133 0.013% 100.093% ( 2900, 4400 ] 165 0.016% 100.109% ( 4400, 6600 ] 47 0.005% 100.114% ( 6600, 9900 ] 7 0.001% 100.115% ( 9900, 14000 ] 1 0.000% 100.115% ** Level 4 read latency histogram (micros): Count: 30349 Average: 81.9441 StdDev: 435.83 Min: 1 Median: 1.9367 Max: 11044 Percentiles: P50: 1.94 P75: 3.27 P99: 2161.66 P99.9: 5641.47 P99.99: 8114.22 ------------------------------------------------------ [ 0, 1 ] 1591 5.242% 5.242% # ( 1, 2 ] 14501 47.781% 53.023% ########## ( 2, 3 ] 5746 18.933% 71.956% #### ( 3, 4 ] 3473 11.444% 83.400% ## ( 4, 6 ] 2190 7.216% 90.616% # ( 6, 10 ] 604 1.990% 92.606% ( 10, 15 ] 215 0.708% 93.314% ( 15, 22 ] 18 0.059% 93.374% ( 34, 51 ] 1 0.003% 93.377% ( 51, 76 ] 1 0.003% 93.380% ( 76, 110 ] 15 0.049% 93.430% ( 110, 170 ] 96 0.316% 93.746% ( 170, 250 ] 118 0.389% 94.135% ( 250, 380 ] 166 0.547% 94.682% ( 380, 580 ] 341 1.124% 95.805% ( 580, 870 ] 388 1.278% 97.084% ( 870, 1300 ] 333 1.097% 98.181% ( 1300, 1900 ] 209 0.689% 98.870% ( 1900, 2900 ] 151 0.498% 99.367% ( 2900, 4400 ] 134 0.442% 99.809% ( 4400, 6600 ] 49 0.161% 99.970% ( 6600, 9900 ] 13 0.043% 100.013% ( 9900, 14000 ] 1 0.003% 100.016% ** Level 5 read latency histogram (micros): Count: 140 Average: 1131.9643 StdDev: 1304.99 Min: 86 Median: 542.5000 Max: 7133 Percentiles: P50: 542.50 P75: 1900.00 P99: 6306.67 P99.9: 7133.00 P99.99: 7133.00 ------------------------------------------------------ ( 76, 110 ] 14 10.000% 10.000% ## ( 110, 170 ] 27 19.286% 29.286% #### ( 170, 250 ] 9 6.429% 35.714% # ( 250, 380 ] 7 5.000% 40.714% # ( 380, 580 ] 16 11.429% 52.143% ## ( 580, 870 ] 13 9.286% 61.429% ## ( 870, 1300 ] 9 6.429% 67.857% # ( 1300, 1900 ] 10 7.143% 75.000% # ( 1900, 2900 ] 19 13.571% 88.571% ### ( 2900, 4400 ] 12 8.571% 97.143% ## ( 4400, 6600 ] 3 2.143% 99.286% ( 6600, 9900 ] 1 0.714% 100.000% ** DB Stats ** Uptime(secs): 60.1 total, 31.5 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 147.41 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:35.353 H:M:S, 58.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 31.28 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:28.250 H:M:S, 89.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.634 micros/op 150728 ops/sec 60.002 seconds 9043999 operations; 146.0 MB/s Microseconds per write: Count: 9043999 Average: 6.6345 StdDev: 393.45 Min: 1 Median: 1.7255 Max: 602230 Percentiles: P50: 1.73 P75: 2.68 P99: 8.92 P99.9: 1910.74 P99.99: 2812.04 ------------------------------------------------------ [ 0, 1 ] 1307922 14.462% 14.462% ### ( 1, 2 ] 4429893 48.982% 63.443% ########## ( 2, 3 ] 1547271 17.108% 80.552% ### ( 3, 4 ] 1183261 13.083% 93.635% ### ( 4, 6 ] 416893 4.610% 98.245% # ( 6, 10 ] 93721 1.036% 99.281% ( 10, 15 ] 26551 0.294% 99.574% ( 15, 22 ] 7253 0.080% 99.655% ( 22, 34 ] 1620 0.018% 99.673% ( 34, 51 ] 209 0.002% 99.675% ( 51, 76 ] 37 0.000% 99.675% ( 76, 110 ] 6514 0.072% 99.747% ( 110, 170 ] 2276 0.025% 99.772% ( 170, 250 ] 279 0.003% 99.776% ( 250, 380 ] 111 0.001% 99.777% ( 380, 580 ] 36 0.000% 99.777% ( 580, 870 ] 21 0.000% 99.777% ( 870, 1300 ] 10967 0.121% 99.899% ( 1300, 1900 ] 23 0.000% 99.899% ( 1900, 2900 ] 9031 0.100% 99.999% ( 2900, 4400 ] 62 0.001% 99.999% ( 4400, 6600 ] 9 0.000% 100.000% ( 6600, 9900 ] 12 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 3 0.000% 100.000% ( 50000, 75000 ] 1 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 250000, 380000 ] 1 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 213519 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 : 9043999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 9333406968 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 : 510 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 35353168 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 : 26136362848 rocksdb.compact.write.bytes COUNT : 25904648480 rocksdb.flush.write.bytes COUNT : 9181798411 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 : 37 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 : 290 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 : 9107909632 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3673088 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 : 26217755086 rocksdb.non.last.level.read.count COUNT : 6332125 rocksdb.block.checksum.compute.count COUNT : 6331142 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.365692 P95 : 3.821392 P99 : 7.417099 P100 : 602228.000000 COUNT : 9043999 SUM : 55828534 rocksdb.compaction.times.micros P50 : 962000.000000 P95 : 3565000.000000 P99 : 24090000.000000 P100 : 29126617.000000 COUNT : 81 SUM : 118089634 rocksdb.compaction.times.cpu_micros P50 : 937272.727273 P95 : 3565000.000000 P99 : 24090000.000000 P100 : 24935758.000000 COUNT : 81 SUM : 101188272 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 : 698.450704 P95 : 1840.000000 P99 : 9537.000000 P100 : 13548.000000 COUNT : 122 SUM : 119282 rocksdb.compaction.outfile.sync.micros P50 : 1046.410256 P95 : 16400.000000 P99 : 53500.000000 P100 : 68320.000000 COUNT : 344 SUM : 1358291 rocksdb.wal.file.sync.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.manifest.file.sync.micros P50 : 107.845070 P95 : 1155.950000 P99 : 3995.000000 P100 : 7265.000000 COUNT : 227 SUM : 70784 rocksdb.table.open.io.micros P50 : 1286.129032 P95 : 6151.851852 P99 : 9673.125000 P100 : 17462.000000 COUNT : 510 SUM : 949603 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.562084 P95 : 7.953079 P99 : 13.210720 P100 : 15716.000000 COUNT : 6329897 SUM : 38822793 rocksdb.read.block.get.micros P50 : 380.000000 P95 : 3062.162162 P99 : 5409.411765 P100 : 7291.000000 COUNT : 1020 SUM : 789943 rocksdb.write.raw.block.micros P50 : 0.514622 P95 : 0.977781 P99 : 2.848933 P100 : 18217.000000 COUNT : 8509376 SUM : 17522634 rocksdb.numfiles.in.singlecompaction P50 : 2.805556 P95 : 4.983333 P99 : 13.975000 P100 : 21.000000 COUNT : 141 SUM : 469 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.575197 P95 : 2051.220189 P99 : 2733.172490 P100 : 602028.000000 COUNT : 153695 SUM : 35366848 rocksdb.sst.read.micros P50 : 1.534048 P95 : 4.747281 P99 : 9.552583 P100 : 11471.000000 COUNT : 6332639 SUM : 25772576 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 : 9043999 SUM : 9333406968 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 : 212051.282051 P95 : 379277.777778 P99 : 742066.666667 P100 : 775385.000000 COUNT : 122 SUM : 26662395 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 : 290 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