[2024-07-23 07:03:48.225772] Starting SPDK v24.09-pre git sha1 f7b31b2b9 / DPDK 22.11.4 initialization... [2024-07-23 07:03:48.225912] [ DPDK EAL parameters: rocksdb --no-shconf -c 0x1 --huge-unlink --no-telemetry --log-level=lib.eal:6 --log-level=lib.cryptodev:5 --log-level=lib.power:5 --log-level=user1:6 --base-virtaddr=0x200000000000 --match-allocations --file-prefix=spdk_pid3891888 ] Set seed to 1721711028222434 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-23 07:03:48.316415] app.c: 909:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-23 07:03:48.358298] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-23 07:03:48.358346] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3891888' to capture a snapshot of events at runtime. [2024-07-23 07:03:48.358359] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-23 07:03:48.358369] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-23 07:03:48.358376] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3891888 for offline analysis/debug. [2024-07-23 07:03:48.358457] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Jul 23 07:03:52 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/23-07:03:55 ... thread 0: (1000000,1000000) ops and (335167.0,335167.0) ops/second in (2.983587,2.983587) 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.98 MB 25.2 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 350.1 2.52 2.29 12 0.210 0 0 0.0 0.0 L2 3/2 251.73 MB 0.0 0.4 0.2 0.2 0.4 0.2 0.2 2.0 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 10/0 867.43 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 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1182/8 97.00 GB 0.0 0.4 0.2 0.2 1.2 1.0 0.3 1.4 94.6 315.3 3.99 3.71 14 0.285 383K 198 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.6 315.3 3.99 3.71 14 0.285 383K 198 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 256.0 255.9 1.48 1.43 2 0.738 383K 198 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 350.1 2.52 2.29 12 0.210 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.23 GB write, 396.63 MB/s write, 0.37 GB read, 118.99 MB/s read, 4.0 seconds Interval compaction: 1.23 GB write, 421.97 MB/s write, 0.37 GB read, 126.60 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: 116027 Average: 1.9135 StdDev: 17.77 Min: 1 Median: 1.2577 Max: 3962 Percentiles: P50: 1.26 P75: 1.68 P99: 3.91 P99.9: 9.80 P99.99: 323.61 ------------------------------------------------------ [ 0, 1 ] 40304 34.737% 34.737% ####### ( 1, 2 ] 68718 59.226% 93.963% ############ ( 2, 3 ] 4595 3.960% 97.923% # ( 3, 4 ] 1370 1.181% 99.104% ( 4, 6 ] 700 0.603% 99.707% ( 6, 10 ] 237 0.204% 99.911% ( 10, 15 ] 65 0.056% 99.967% ( 15, 22 ] 14 0.012% 99.979% ( 22, 34 ] 1 0.001% 99.980% ( 110, 170 ] 8 0.007% 99.987% ( 170, 250 ] 1 0.001% 99.988% ( 250, 380 ] 6 0.005% 99.993% ( 580, 870 ] 3 0.003% 99.996% ( 870, 1300 ] 3 0.003% 99.998% ( 1900, 2900 ] 1 0.001% 99.999% ( 2900, 4400 ] 2 0.002% 100.001% ** Level 1 read latency histogram (micros): Count: 5 Average: 1069.6000 StdDev: 1063.29 Min: 246 Median: 347.5000 Max: 2911 Percentiles: P50: 347.50 P75: 1750.00 P99: 2911.00 P99.9: 2911.00 P99.99: 2911.00 ------------------------------------------------------ ( 170, 250 ] 1 20.000% 20.000% #### ( 250, 380 ] 2 40.000% 60.000% ######## ( 1300, 1900 ] 1 20.000% 80.000% #### ( 2900, 4400 ] 1 20.000% 100.000% #### ** Level 2 read latency histogram (micros): Count: 59843 Average: 1.9077 StdDev: 7.09 Min: 1 Median: 1.3089 Max: 1256 Percentiles: P50: 1.31 P75: 1.72 P99: 5.16 P99.9: 10.13 P99.99: 252.03 ------------------------------------------------------ [ 0, 1 ] 18748 31.329% 31.329% ###### ( 1, 2 ] 36178 60.455% 91.784% ############ ( 2, 3 ] 2771 4.630% 96.414% # ( 3, 4 ] 1119 1.870% 98.284% ( 4, 6 ] 742 1.240% 99.524% ( 6, 10 ] 227 0.379% 99.903% ( 10, 15 ] 44 0.074% 99.977% ( 15, 22 ] 7 0.012% 99.988% ( 22, 34 ] 2 0.003% 99.992% ( 34, 51 ] 1 0.002% 99.993% ( 51, 76 ] 1 0.002% 99.995% ( 250, 380 ] 1 0.002% 99.997% ( 380, 580 ] 2 0.003% 100.000% ( 580, 870 ] 2 0.003% 100.003% ( 870, 1300 ] 1 0.002% 100.005% ** Level 3 read latency histogram (micros): Count: 45 Average: 1457.3111 StdDev: 998.62 Min: 113 Median: 1333.3333 Max: 3829 Percentiles: P50: 1333.33 P75: 2150.00 P99: 3829.00 P99.9: 3829.00 P99.99: 3829.00 ------------------------------------------------------ ( 110, 170 ] 2 4.444% 4.444% # ( 170, 250 ] 3 6.667% 11.111% # ( 250, 380 ] 2 4.444% 15.556% # ( 380, 580 ] 3 6.667% 22.222% # ( 580, 870 ] 6 13.333% 35.556% ### ( 870, 1300 ] 6 13.333% 48.889% ### ( 1300, 1900 ] 9 20.000% 68.889% #### ( 1900, 2900 ] 11 24.444% 93.333% ##### ( 2900, 4400 ] 3 6.667% 100.000% # ** Level 4 read latency histogram (micros): Count: 30 Average: 1504.4333 StdDev: 1077.21 Min: 532 Median: 1156.6667 Max: 4709 Percentiles: P50: 1156.67 P75: 2150.00 P99: 4709.00 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ ( 380, 580 ] 3 10.000% 10.000% ## ( 580, 870 ] 10 33.333% 43.333% ####### ( 870, 1300 ] 3 10.000% 53.333% ## ( 1300, 1900 ] 5 16.667% 70.000% ### ( 1900, 2900 ] 6 20.000% 90.000% #### ( 2900, 4400 ] 2 6.667% 96.667% # ( 4400, 6600 ] 1 3.333% 100.000% # ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 309.88 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.378 H:M:S, 11.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.61 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.378 H:M:S, 12.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-07:03:58 ... thread 0: (1000000,2000000) ops and (343421.2,339243.9) ops/second in (2.911876,5.895463) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/9 1.17 GB 12.6 0.6 0.0 0.6 2.3 1.8 0.0 1.3 76.0 320.6 7.46 6.85 28 0.267 575K 598 0.0 0.0 L1 1/1 3.38 MB 0.0 0.4 0.4 0.0 0.4 0.4 0.2 1.0 240.9 240.5 1.57 1.52 1 1.569 383K 623 0.0 0.0 L2 2/1 54.39 MB 0.5 0.4 0.2 0.2 0.4 0.2 0.5 2.0 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 20/10 1.19 GB 0.3 0.2 0.2 0.0 0.2 0.2 0.4 1.0 227.1 227.1 1.10 1.03 1 1.098 253K 0 0.0 0.0 L4 174/0 9.75 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.0 1.0 147.1 147.2 1.53 1.10 1 1.526 228K 0 0.0 0.0 L5 1044/0 85.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1252/21 97.92 GB 0.0 1.8 1.0 0.7 3.5 2.8 1.2 2.0 136.8 275.8 13.13 11.92 33 0.398 1824K 1419 0.0 0.0 Int 0/0 0.00 KB 0.0 1.8 1.0 0.7 3.5 2.8 1.1 2.0 136.8 275.8 13.13 11.92 33 0.398 1824K 1419 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.8 1.0 0.7 1.8 1.0 0.0 0.0 228.4 228.3 7.87 7.23 7 1.124 1824K 1419 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 346.8 5.27 4.69 26 0.203 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 5.9 interval Flush(GB): cumulative 1.784, interval 1.784 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 3.54 GB write, 595.03 MB/s write, 1.75 GB read, 295.17 MB/s read, 13.1 seconds Interval compaction: 3.54 GB write, 614.27 MB/s write, 1.75 GB read, 304.72 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: 6, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 6, interval: 6 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 395432 Average: 2.2688 StdDev: 11.54 Min: 1 Median: 1.5279 Max: 3962 Percentiles: P50: 1.53 P75: 1.92 P99: 5.79 P99.9: 11.55 P99.99: 14.91 ------------------------------------------------------ [ 0, 1 ] 65059 16.453% 16.453% ### ( 1, 2 ] 251300 63.551% 80.003% ############# ( 2, 3 ] 48560 12.280% 92.284% ## ( 3, 4 ] 15424 3.901% 96.184% # ( 4, 6 ] 12415 3.140% 99.324% # ( 6, 10 ] 2116 0.535% 99.859% ( 10, 15 ] 529 0.134% 99.993% ( 15, 22 ] 61 0.015% 100.008% ( 22, 34 ] 7 0.002% 100.010% ( 34, 51 ] 3 0.001% 100.011% ( 51, 76 ] 2 0.001% 100.011% ( 76, 110 ] 1 0.000% 100.011% ( 110, 170 ] 15 0.004% 100.015% ( 170, 250 ] 8 0.002% 100.017% ( 250, 380 ] 15 0.004% 100.021% ( 380, 580 ] 3 0.001% 100.022% ( 580, 870 ] 6 0.002% 100.023% ( 870, 1300 ] 5 0.001% 100.025% ( 1300, 1900 ] 1 0.000% 100.025% ( 1900, 2900 ] 1 0.000% 100.025% ( 2900, 4400 ] 3 0.001% 100.026% ** Level 1 read latency histogram (micros): Count: 31 Average: 436.1613 StdDev: 857.77 Min: 1 Median: 1.8125 Max: 3388 Percentiles: P50: 1.81 P75: 323.12 P99: 3388.00 P99.9: 3388.00 P99.99: 3388.00 ------------------------------------------------------ [ 0, 1 ] 9 29.032% 29.032% ###### ( 1, 2 ] 8 25.806% 54.839% ##### ( 4, 6 ] 1 3.226% 58.065% # ( 170, 250 ] 3 9.677% 67.742% ## ( 250, 380 ] 4 12.903% 80.645% ### ( 380, 580 ] 1 3.226% 83.871% # ( 1300, 1900 ] 3 9.677% 93.548% ## ( 2900, 4400 ] 2 6.452% 100.000% # ** Level 2 read latency histogram (micros): Count: 95671 Average: 2.0596 StdDev: 5.65 Min: 1 Median: 1.4257 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.88 P99.99: 24.60 ------------------------------------------------------ [ 0, 1 ] 22192 23.196% 23.196% ##### ( 1, 2 ] 60241 62.967% 86.163% ############# ( 2, 3 ] 7786 8.138% 94.301% ## ( 3, 4 ] 2713 2.836% 97.137% # ( 4, 6 ] 2179 2.278% 99.415% ( 6, 10 ] 448 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 181657 Average: 3.3963 StdDev: 31.25 Min: 0 Median: 1.7039 Max: 3829 Percentiles: P50: 1.70 P75: 2.37 P99: 8.89 P99.9: 153.69 P99.99: 384.17 ------------------------------------------------------ [ 0, 1 ] 13079 7.200% 7.200% # ( 1, 2 ] 110459 60.806% 68.006% ############ ( 2, 3 ] 34721 19.113% 87.120% #### ( 3, 4 ] 10261 5.649% 92.768% # ( 4, 6 ] 9163 5.044% 97.812% # ( 6, 10 ] 2987 1.644% 99.457% ( 10, 15 ] 462 0.254% 99.711% ( 15, 22 ] 91 0.050% 99.761% ( 22, 34 ] 27 0.015% 99.776% ( 34, 51 ] 3 0.002% 99.778% ( 51, 76 ] 7 0.004% 99.781% ( 76, 110 ] 86 0.047% 99.829% ( 110, 170 ] 179 0.099% 99.927% ( 170, 250 ] 67 0.037% 99.964% ( 250, 380 ] 47 0.026% 99.990% ( 380, 580 ] 40 0.022% 100.012% ( 580, 870 ] 20 0.011% 100.023% ( 870, 1300 ] 9 0.005% 100.028% ( 1300, 1900 ] 10 0.006% 100.034% ( 1900, 2900 ] 12 0.007% 100.040% ( 2900, 4400 ] 3 0.002% 100.042% ** Level 4 read latency histogram (micros): Count: 320 Average: 145.8750 StdDev: 547.66 Min: 0 Median: 1.8696 Max: 4709 Percentiles: P50: 1.87 P75: 6.67 P99: 2866.67 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 115 35.938% 54.688% ####### ( 2, 3 ] 43 13.438% 68.125% ### ( 3, 4 ] 9 2.812% 70.938% # ( 4, 6 ] 11 3.438% 74.375% # ( 6, 10 ] 12 3.750% 78.125% # ( 10, 15 ] 21 6.562% 84.688% # ( 15, 22 ] 16 5.000% 89.688% # ( 22, 34 ] 1 0.312% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 380, 580 ] 3 0.938% 91.562% ( 580, 870 ] 10 3.125% 94.688% # ( 870, 1300 ] 3 0.938% 95.625% ( 1300, 1900 ] 5 1.562% 97.188% ( 1900, 2900 ] 6 1.875% 99.062% ( 2900, 4400 ] 2 0.625% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** DB Stats ** Uptime(secs): 6.1 total, 2.9 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 323.33 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.619 H:M:S, 10.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 337.99 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.241 H:M:S, 8.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/23-07:04:01 ... thread 0: (1000000,3000000) ops and (328073.5,335436.9) ops/second in (3.048097,8.943560) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/8 1.35 GB 81.8 1.4 0.0 1.4 4.1 2.8 0.0 1.5 102.8 313.1 13.48 12.47 45 0.299 1407K 1433 0.0 0.0 L1 4/0 303.91 MB 30.4 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.9 233.3 5.13 4.99 2 2.564 1218K 3173 0.0 0.0 L2 5/4 567.23 MB 1.3 0.4 0.2 0.2 0.4 0.2 1.0 2.0 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 20/10 956.62 MB 0.6 1.1 0.2 0.8 1.1 0.2 0.4 4.4 240.0 239.5 4.66 4.30 2 2.331 1136K 2284 0.0 0.0 L4 174/0 9.64 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.3 1.0 147.1 147.2 1.53 1.10 1 1.526 228K 0 0.0 0.0 L5 1048/0 86.12 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1262/22 98.90 GB 0.0 4.2 1.8 2.4 7.0 4.6 2.3 2.5 164.0 271.6 26.27 24.29 52 0.505 4373K 7088 0.0 0.0 Int 0/0 0.00 KB 0.0 4.2 1.8 2.4 7.0 4.6 2.2 2.5 164.0 271.6 26.27 24.29 52 0.505 4373K 7088 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 4.2 1.8 2.4 4.2 1.8 0.0 0.0 236.8 236.4 18.19 17.09 12 1.516 4373K 7088 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 350.9 8.08 7.20 40 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.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: 6.97 GB write, 780.97 MB/s write, 4.21 GB read, 471.47 MB/s read, 26.3 seconds Interval compaction: 6.97 GB write, 797.63 MB/s write, 4.21 GB read, 481.52 MB/s read, 26.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 8, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 8, interval: 8 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 773922 Average: 2.2861 StdDev: 8.96 Min: 1 Median: 1.5562 Max: 3962 Percentiles: P50: 1.56 P75: 1.94 P99: 5.76 P99.9: 9.96 P99.99: 14.12 ------------------------------------------------------ [ 0, 1 ] 108874 14.068% 14.068% ### ( 1, 2 ] 499974 64.603% 78.670% ############# ( 2, 3 ] 101768 13.150% 91.820% ### ( 3, 4 ] 33295 4.302% 96.122% # ( 4, 6 ] 25286 3.267% 99.389% # ( 6, 10 ] 3991 0.516% 99.905% ( 10, 15 ] 800 0.103% 100.009% ( 15, 22 ] 104 0.013% 100.022% ( 22, 34 ] 11 0.001% 100.023% ( 34, 51 ] 4 0.001% 100.024% ( 51, 76 ] 8 0.001% 100.025% ( 76, 110 ] 1 0.000% 100.025% ( 110, 170 ] 21 0.003% 100.028% ( 170, 250 ] 15 0.002% 100.030% ( 250, 380 ] 22 0.003% 100.033% ( 380, 580 ] 6 0.001% 100.033% ( 580, 870 ] 13 0.002% 100.035% ( 870, 1300 ] 9 0.001% 100.036% ( 1300, 1900 ] 1 0.000% 100.036% ( 1900, 2900 ] 1 0.000% 100.036% ( 2900, 4400 ] 3 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 30349 Average: 4.9392 StdDev: 44.74 Min: 0 Median: 1.7188 Max: 3473 Percentiles: P50: 1.72 P75: 2.43 P99: 14.39 P99.9: 402.09 P99.99: 1295.00 ------------------------------------------------------ [ 0, 1 ] 1844 6.076% 6.076% # ( 1, 2 ] 18547 61.112% 67.188% ############ ( 2, 3 ] 5478 18.050% 85.238% #### ( 3, 4 ] 1952 6.432% 91.670% # ( 4, 6 ] 1566 5.160% 96.830% # ( 6, 10 ] 615 2.026% 98.857% ( 10, 15 ] 53 0.175% 99.031% ( 15, 22 ] 10 0.033% 99.064% ( 76, 110 ] 86 0.283% 99.348% ( 110, 170 ] 98 0.323% 99.670% ( 170, 250 ] 35 0.115% 99.786% ( 250, 380 ] 35 0.115% 99.901% ( 380, 580 ] 24 0.079% 99.980% ( 580, 870 ] 3 0.010% 99.990% ( 870, 1300 ] 3 0.010% 100.000% ( 1300, 1900 ] 5 0.016% 100.016% ( 2900, 4400 ] 3 0.010% 100.026% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 248976 Average: 3.3444 StdDev: 28.46 Min: 0 Median: 1.6851 Max: 3829 Percentiles: P50: 1.69 P75: 2.30 P99: 8.87 P99.9: 166.51 P99.99: 488.82 ------------------------------------------------------ [ 0, 1 ] 18145 7.288% 7.288% # ( 1, 2 ] 155231 62.348% 69.636% ############ ( 2, 3 ] 44620 17.921% 87.557% #### ( 3, 4 ] 13760 5.527% 93.084% # ( 4, 6 ] 11746 4.718% 97.801% # ( 6, 10 ] 4165 1.673% 99.474% ( 10, 15 ] 550 0.221% 99.695% ( 15, 22 ] 99 0.040% 99.735% ( 22, 34 ] 28 0.011% 99.746% ( 34, 51 ] 4 0.002% 99.748% ( 51, 76 ] 7 0.003% 99.751% ( 76, 110 ] 146 0.059% 99.809% ( 110, 170 ] 240 0.096% 99.906% ( 170, 250 ] 113 0.045% 99.951% ( 250, 380 ] 65 0.026% 99.977% ( 380, 580 ] 59 0.024% 100.001% ( 580, 870 ] 31 0.012% 100.013% ( 870, 1300 ] 15 0.006% 100.019% ( 1300, 1900 ] 12 0.005% 100.024% ( 1900, 2900 ] 12 0.005% 100.029% ( 2900, 4400 ] 3 0.001% 100.030% ** Level 4 read latency histogram (micros): Count: 320 Average: 145.8750 StdDev: 547.66 Min: 0 Median: 1.8696 Max: 4709 Percentiles: P50: 1.87 P75: 6.67 P99: 2866.67 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 115 35.938% 54.688% ####### ( 2, 3 ] 43 13.438% 68.125% ### ( 3, 4 ] 9 2.812% 70.938% # ( 4, 6 ] 11 3.438% 74.375% # ( 6, 10 ] 12 3.750% 78.125% # ( 10, 15 ] 21 6.562% 84.688% # ( 15, 22 ] 16 5.000% 89.688% # ( 22, 34 ] 1 0.312% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 380, 580 ] 3 0.938% 91.562% ( 580, 870 ] 10 3.125% 94.688% # ( 870, 1300 ] 3 0.938% 95.625% ( 1300, 1900 ] 5 1.562% 97.188% ( 1900, 2900 ] 6 1.875% 99.062% ( 2900, 4400 ] 2 0.625% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 20 Average: 841.3000 StdDev: 976.38 Min: 107 Median: 480.0000 Max: 4270 Percentiles: P50: 480.00 P75: 1192.50 P99: 4100.00 P99.9: 4270.00 P99.99: 4270.00 ------------------------------------------------------ ( 76, 110 ] 2 10.000% 10.000% ## ( 110, 170 ] 4 20.000% 30.000% #### ( 170, 250 ] 2 10.000% 40.000% ## ( 250, 380 ] 1 5.000% 45.000% # ( 380, 580 ] 2 10.000% 55.000% ## ( 580, 870 ] 1 5.000% 60.000% # ( 870, 1300 ] 4 20.000% 80.000% #### ( 1300, 1900 ] 2 10.000% 90.000% ## ( 1900, 2900 ] 1 5.000% 95.000% # ( 2900, 4400 ] 1 5.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, 323.18 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.002 H:M:S, 11.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 322.88 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.382 H:M:S, 12.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/07/23-07:04:04 ... thread 0: (1000000,4000000) ops and (324904.9,332740.4) ops/second in (3.077824,12.021384) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/4 2.27 GB 201.4 2.5 0.0 2.5 6.1 3.7 0.0 1.7 122.5 306.1 20.57 19.13 62 0.332 2558K 2691 0.0 0.0 L1 4/0 303.91 MB 30.4 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.9 233.3 5.13 4.99 2 2.564 1218K 3173 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 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 23/0 911.86 MB 0.9 2.1 0.8 1.3 2.1 0.8 0.4 2.6 224.0 223.6 9.58 8.79 6 1.597 2180K 4372 0.0 0.0 L4 176/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.1 147.2 1.53 1.10 1 1.526 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1271/4 99.82 GB 0.0 6.3 2.4 3.9 10.0 6.1 3.5 2.7 169.0 267.4 38.28 35.44 73 0.524 6568K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.3 2.4 3.9 10.0 6.1 3.4 2.7 169.0 267.4 38.28 35.44 73 0.524 6568K 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.3 2.4 3.9 6.3 2.4 0.0 0.0 235.4 235.0 27.48 25.84 20 1.374 6568K 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 349.9 10.80 9.60 53 0.204 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.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: 10.00 GB write, 838.25 MB/s write, 6.32 GB read, 529.65 MB/s read, 38.3 seconds Interval compaction: 10.00 GB write, 851.55 MB/s write, 6.32 GB read, 538.06 MB/s read, 38.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1031165 Average: 2.3103 StdDev: 9.15 Min: 1 Median: 1.5662 Max: 3962 Percentiles: P50: 1.57 P75: 1.95 P99: 5.80 P99.9: 10.65 P99.99: 14.49 ------------------------------------------------------ [ 0, 1 ] 137954 13.378% 13.378% ### ( 1, 2 ] 666998 64.684% 78.062% ############# ( 2, 3 ] 137859 13.369% 91.432% ### ( 3, 4 ] 46081 4.469% 95.900% # ( 4, 6 ] 35515 3.444% 99.345% # ( 6, 10 ] 5570 0.540% 99.885% ( 10, 15 ] 1208 0.117% 100.002% ( 15, 22 ] 146 0.014% 100.016% ( 22, 34 ] 14 0.001% 100.017% ( 34, 51 ] 6 0.001% 100.018% ( 51, 76 ] 9 0.001% 100.019% ( 76, 110 ] 1 0.000% 100.019% ( 110, 170 ] 25 0.002% 100.021% ( 170, 250 ] 20 0.002% 100.023% ( 250, 380 ] 30 0.003% 100.026% ( 380, 580 ] 10 0.001% 100.027% ( 580, 870 ] 18 0.002% 100.029% ( 870, 1300 ] 14 0.001% 100.030% ( 1300, 1900 ] 3 0.000% 100.031% ( 1900, 2900 ] 1 0.000% 100.031% ( 2900, 4400 ] 4 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 254643 Average: 3.0642 StdDev: 18.45 Min: 0 Median: 1.7109 Max: 3473 Percentiles: P50: 1.71 P75: 2.37 P99: 8.62 P99.9: 109.47 P99.99: 243.37 ------------------------------------------------------ [ 0, 1 ] 13459 5.285% 5.285% # ( 1, 2 ] 160159 62.896% 68.181% ############# ( 2, 3 ] 47406 18.617% 86.798% #### ( 3, 4 ] 15177 5.960% 92.758% # ( 4, 6 ] 13042 5.122% 97.879% # ( 6, 10 ] 4359 1.712% 99.591% ( 10, 15 ] 537 0.211% 99.802% ( 15, 22 ] 80 0.031% 99.833% ( 22, 34 ] 1 0.000% 99.834% ( 34, 51 ] 2 0.001% 99.835% ( 51, 76 ] 1 0.000% 99.835% ( 76, 110 ] 168 0.066% 99.901% ( 110, 170 ] 155 0.061% 99.962% ( 170, 250 ] 78 0.031% 99.993% ( 250, 380 ] 60 0.024% 100.016% ( 380, 580 ] 55 0.022% 100.038% ( 580, 870 ] 12 0.005% 100.042% ( 870, 1300 ] 10 0.004% 100.046% ( 1300, 1900 ] 6 0.002% 100.049% ( 2900, 4400 ] 3 0.001% 100.050% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 284328 Average: 3.7189 StdDev: 31.43 Min: 0 Median: 1.6854 Max: 3829 Percentiles: P50: 1.69 P75: 2.30 P99: 9.13 P99.9: 256.30 P99.99: 691.66 ------------------------------------------------------ [ 0, 1 ] 20654 7.264% 7.264% # ( 1, 2 ] 177284 62.352% 69.616% ############ ( 2, 3 ] 50983 17.931% 87.547% #### ( 3, 4 ] 15659 5.507% 93.055% # ( 4, 6 ] 13356 4.697% 97.752% # ( 6, 10 ] 4529 1.593% 99.345% ( 10, 15 ] 609 0.214% 99.559% ( 15, 22 ] 109 0.038% 99.597% ( 22, 34 ] 30 0.011% 99.608% ( 34, 51 ] 4 0.001% 99.609% ( 51, 76 ] 7 0.002% 99.612% ( 76, 110 ] 237 0.083% 99.695% ( 110, 170 ] 376 0.132% 99.827% ( 170, 250 ] 201 0.071% 99.898% ( 250, 380 ] 117 0.041% 99.939% ( 380, 580 ] 118 0.042% 99.981% ( 580, 870 ] 69 0.024% 100.005% ( 870, 1300 ] 28 0.010% 100.015% ( 1300, 1900 ] 16 0.006% 100.020% ( 1900, 2900 ] 13 0.005% 100.025% ( 2900, 4400 ] 4 0.001% 100.026% ** Level 4 read latency histogram (micros): Count: 320 Average: 145.8750 StdDev: 547.66 Min: 0 Median: 1.8696 Max: 4709 Percentiles: P50: 1.87 P75: 6.67 P99: 2866.67 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 115 35.938% 54.688% ####### ( 2, 3 ] 43 13.438% 68.125% ### ( 3, 4 ] 9 2.812% 70.938% # ( 4, 6 ] 11 3.438% 74.375% # ( 6, 10 ] 12 3.750% 78.125% # ( 10, 15 ] 21 6.562% 84.688% # ( 15, 22 ] 16 5.000% 89.688% # ( 22, 34 ] 1 0.312% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 380, 580 ] 3 0.938% 91.562% ( 580, 870 ] 10 3.125% 94.688% # ( 870, 1300 ] 3 0.938% 95.625% ( 1300, 1900 ] 5 1.562% 97.188% ( 1900, 2900 ] 6 1.875% 99.062% ( 2900, 4400 ] 2 0.625% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 827.3667 StdDev: 1035.20 Min: 93 Median: 328.0000 Max: 4270 Percentiles: P50: 328.00 P75: 1115.71 P99: 4100.00 P99.9: 4270.00 P99.99: 4270.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 5 8.333% 53.333% ## ( 380, 580 ] 5 8.333% 61.667% ## ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 7 11.667% 80.000% ## ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 3 5.000% 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.32 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.412 H:M:S, 11.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 319.77 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.410 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-07:04:07 ... thread 0: (1000000,5000000) ops and (319483.2,330001.7) ops/second in (3.130055,15.151439) 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 56.7 3.3 0.0 3.3 8.0 4.7 0.0 1.7 125.9 308.6 26.52 24.72 80 0.332 3390K 3611 0.0 0.0 L1 4/4 303.91 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.9 233.3 5.13 4.99 2 2.564 1218K 3173 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 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 23/0 911.86 MB 0.9 2.1 0.8 1.3 2.1 0.8 0.4 2.6 224.0 223.6 9.58 8.79 6 1.597 2180K 4372 0.0 0.0 L4 176/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.1 147.2 1.53 1.10 1 1.526 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1277/17 100.86 GB 0.0 7.1 2.4 4.7 11.8 7.1 3.5 2.5 164.7 274.1 44.24 41.03 91 0.486 7400K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.1 2.4 4.7 11.8 7.1 3.4 2.5 164.7 274.1 44.24 41.03 91 0.486 7400K 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.1 2.4 4.7 7.1 2.4 0.0 0.0 239.1 238.7 30.48 28.78 23 1.325 7400K 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 352.5 13.76 12.24 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.3 total, 15.2 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.84 GB write, 790.36 MB/s write, 7.12 GB read, 474.98 MB/s read, 44.2 seconds Interval compaction: 11.84 GB write, 800.30 MB/s write, 7.12 GB read, 480.96 MB/s read, 44.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, 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: 1, total-stops: 17, interval: 18 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1314102 Average: 2.2942 StdDev: 11.02 Min: 0 Median: 1.5328 Max: 4086 Percentiles: P50: 1.53 P75: 1.92 P99: 5.74 P99.9: 11.26 P99.99: 21.11 ------------------------------------------------------ [ 0, 1 ] 202847 15.436% 15.436% ### ( 1, 2 ] 852553 64.877% 80.313% ############# ( 2, 3 ] 159701 12.153% 92.466% ## ( 3, 4 ] 52443 3.991% 96.457% # ( 4, 6 ] 38333 2.917% 99.374% # ( 6, 10 ] 6563 0.499% 99.874% ( 10, 15 ] 1384 0.105% 99.979% ( 15, 22 ] 169 0.013% 99.992% ( 22, 34 ] 16 0.001% 99.993% ( 34, 51 ] 6 0.000% 99.993% ( 51, 76 ] 13 0.001% 99.994% ( 76, 110 ] 110 0.008% 100.003% ( 110, 170 ] 143 0.011% 100.014% ( 170, 250 ] 53 0.004% 100.018% ( 250, 380 ] 52 0.004% 100.022% ( 380, 580 ] 31 0.002% 100.024% ( 580, 870 ] 26 0.002% 100.026% ( 870, 1300 ] 21 0.002% 100.028% ( 1300, 1900 ] 5 0.000% 100.028% ( 1900, 2900 ] 4 0.000% 100.028% ( 2900, 4400 ] 6 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 254644 Average: 3.0649 StdDev: 18.46 Min: 0 Median: 1.7109 Max: 3473 Percentiles: P50: 1.71 P75: 2.37 P99: 8.62 P99.9: 109.67 P99.99: 243.45 ------------------------------------------------------ [ 0, 1 ] 13459 5.285% 5.285% # ( 1, 2 ] 160159 62.895% 68.181% ############# ( 2, 3 ] 47406 18.617% 86.797% #### ( 3, 4 ] 15177 5.960% 92.757% # ( 4, 6 ] 13042 5.122% 97.879% # ( 6, 10 ] 4359 1.712% 99.591% ( 10, 15 ] 537 0.211% 99.802% ( 15, 22 ] 80 0.031% 99.833% ( 22, 34 ] 1 0.000% 99.833% ( 34, 51 ] 2 0.001% 99.834% ( 51, 76 ] 1 0.000% 99.835% ( 76, 110 ] 168 0.066% 99.901% ( 110, 170 ] 155 0.061% 99.962% ( 170, 250 ] 79 0.031% 99.993% ( 250, 380 ] 60 0.024% 100.016% ( 380, 580 ] 55 0.022% 100.038% ( 580, 870 ] 12 0.005% 100.042% ( 870, 1300 ] 10 0.004% 100.046% ( 1300, 1900 ] 6 0.002% 100.049% ( 2900, 4400 ] 3 0.001% 100.050% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 284328 Average: 3.7189 StdDev: 31.43 Min: 0 Median: 1.6854 Max: 3829 Percentiles: P50: 1.69 P75: 2.30 P99: 9.13 P99.9: 256.30 P99.99: 691.66 ------------------------------------------------------ [ 0, 1 ] 20654 7.264% 7.264% # ( 1, 2 ] 177284 62.352% 69.616% ############ ( 2, 3 ] 50983 17.931% 87.547% #### ( 3, 4 ] 15659 5.507% 93.055% # ( 4, 6 ] 13356 4.697% 97.752% # ( 6, 10 ] 4529 1.593% 99.345% ( 10, 15 ] 609 0.214% 99.559% ( 15, 22 ] 109 0.038% 99.597% ( 22, 34 ] 30 0.011% 99.608% ( 34, 51 ] 4 0.001% 99.609% ( 51, 76 ] 7 0.002% 99.612% ( 76, 110 ] 237 0.083% 99.695% ( 110, 170 ] 376 0.132% 99.827% ( 170, 250 ] 201 0.071% 99.898% ( 250, 380 ] 117 0.041% 99.939% ( 380, 580 ] 118 0.042% 99.981% ( 580, 870 ] 69 0.024% 100.005% ( 870, 1300 ] 28 0.010% 100.015% ( 1300, 1900 ] 16 0.006% 100.020% ( 1900, 2900 ] 13 0.005% 100.025% ( 2900, 4400 ] 4 0.001% 100.026% ** Level 4 read latency histogram (micros): Count: 320 Average: 145.8750 StdDev: 547.66 Min: 0 Median: 1.8696 Max: 4709 Percentiles: P50: 1.87 P75: 6.67 P99: 2866.67 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 115 35.938% 54.688% ####### ( 2, 3 ] 43 13.438% 68.125% ### ( 3, 4 ] 9 2.812% 70.938% # ( 4, 6 ] 11 3.438% 74.375% # ( 6, 10 ] 12 3.750% 78.125% # ( 10, 15 ] 21 6.562% 84.688% # ( 15, 22 ] 16 5.000% 89.688% # ( 22, 34 ] 1 0.312% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 380, 580 ] 3 0.938% 91.562% ( 580, 870 ] 10 3.125% 94.688% # ( 870, 1300 ] 3 0.938% 95.625% ( 1300, 1900 ] 5 1.562% 97.188% ( 1900, 2900 ] 6 1.875% 99.062% ( 2900, 4400 ] 2 0.625% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 827.3667 StdDev: 1035.20 Min: 93 Median: 328.0000 Max: 4270 Percentiles: P50: 328.00 P75: 1115.71 P99: 4100.00 P99.9: 4270.00 P99.99: 4270.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 5 8.333% 53.333% ## ( 380, 580 ] 5 8.333% 61.667% ## ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 7 11.667% 80.000% ## ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 15.3 total, 3.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 320.71 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.962 H:M:S, 12.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 314.43 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.551 H:M:S, 17.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-07:04:15 ... thread 0: (1000000,6000000) ops and (127076.2,260634.6) ops/second in (7.869296,23.020735) 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 4.24 GB 150.9 4.9 0.0 4.9 10.6 5.7 0.0 1.9 141.8 304.7 35.54 33.32 100 0.355 5116K 6229 0.0 0.0 L1 4/4 303.91 MB 0.0 1.2 1.2 0.0 1.2 1.2 0.2 1.0 233.9 233.3 5.13 4.99 2 2.564 1218K 3173 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 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 23/0 911.86 MB 0.9 2.1 0.8 1.3 2.1 0.8 0.4 2.6 224.0 223.6 9.58 8.79 6 1.597 2180K 4372 0.0 0.0 L4 176/0 9.62 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.8 1.0 147.1 147.2 1.53 1.10 1 1.526 228K 0 0.0 0.0 L5 1056/0 86.74 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1277/17 101.78 GB 0.0 8.8 2.4 6.4 14.4 8.0 3.5 2.5 168.8 277.3 53.26 49.63 111 0.480 9127K 13K 0.0 0.0 Int 0/0 0.00 KB 0.0 8.8 2.4 6.4 14.4 8.0 3.4 2.5 168.8 277.3 53.26 49.63 111 0.480 9127K 13K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 8.8 2.4 6.4 8.8 2.4 0.0 0.0 244.7 244.3 36.73 34.95 28 1.312 9127K 13K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 350.6 16.53 14.68 83 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 23.2 total, 23.0 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 14.42 GB write, 636.27 MB/s write, 8.78 GB read, 387.22 MB/s read, 53.3 seconds Interval compaction: 14.42 GB write, 641.55 MB/s write, 8.78 GB read, 390.43 MB/s read, 53.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, 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: 11, total-stops: 17, interval: 28 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2186353 Average: 2.2380 StdDev: 9.62 Min: 0 Median: 1.5068 Max: 4086 Percentiles: P50: 1.51 P75: 1.88 P99: 5.67 P99.9: 11.49 P99.99: 88.63 ------------------------------------------------------ [ 0, 1 ] 356820 16.320% 16.320% ### ( 1, 2 ] 1452878 66.452% 82.772% ############# ( 2, 3 ] 236610 10.822% 93.595% ## ( 3, 4 ] 76276 3.489% 97.083% # ( 4, 6 ] 50077 2.290% 99.374% ( 6, 10 ] 10900 0.499% 99.872% ( 10, 15 ] 2039 0.093% 99.966% ( 15, 22 ] 387 0.018% 99.983% ( 22, 34 ] 21 0.001% 99.984% ( 34, 51 ] 12 0.001% 99.985% ( 51, 76 ] 21 0.001% 99.986% ( 76, 110 ] 254 0.012% 99.997% ( 110, 170 ] 293 0.013% 100.011% ( 170, 250 ] 100 0.005% 100.015% ( 250, 380 ] 96 0.004% 100.020% ( 380, 580 ] 48 0.002% 100.022% ( 580, 870 ] 43 0.002% 100.024% ( 870, 1300 ] 29 0.001% 100.025% ( 1300, 1900 ] 8 0.000% 100.026% ( 1900, 2900 ] 5 0.000% 100.026% ( 2900, 4400 ] 6 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 279705 Average: 3.0023 StdDev: 17.80 Min: 0 Median: 1.6842 Max: 3473 Percentiles: P50: 1.68 P75: 2.29 P99: 8.56 P99.9: 110.77 P99.99: 246.03 ------------------------------------------------------ [ 0, 1 ] 18956 6.777% 6.777% # ( 1, 2 ] 176700 63.174% 69.951% ############# ( 2, 3 ] 49107 17.557% 87.508% #### ( 3, 4 ] 15724 5.622% 93.129% # ( 4, 6 ] 13491 4.823% 97.952% # ( 6, 10 ] 4583 1.639% 99.591% ( 10, 15 ] 562 0.201% 99.792% ( 15, 22 ] 93 0.033% 99.825% ( 22, 34 ] 1 0.000% 99.826% ( 34, 51 ] 3 0.001% 99.827% ( 51, 76 ] 1 0.000% 99.827% ( 76, 110 ] 202 0.072% 99.899% ( 110, 170 ] 178 0.064% 99.963% ( 170, 250 ] 80 0.029% 99.991% ( 250, 380 ] 61 0.022% 100.013% ( 380, 580 ] 58 0.021% 100.034% ( 580, 870 ] 13 0.005% 100.039% ( 870, 1300 ] 10 0.004% 100.042% ( 1300, 1900 ] 6 0.002% 100.044% ( 2900, 4400 ] 3 0.001% 100.045% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 284328 Average: 3.7189 StdDev: 31.43 Min: 0 Median: 1.6854 Max: 3829 Percentiles: P50: 1.69 P75: 2.30 P99: 9.13 P99.9: 256.30 P99.99: 691.66 ------------------------------------------------------ [ 0, 1 ] 20654 7.264% 7.264% # ( 1, 2 ] 177284 62.352% 69.616% ############ ( 2, 3 ] 50983 17.931% 87.547% #### ( 3, 4 ] 15659 5.507% 93.055% # ( 4, 6 ] 13356 4.697% 97.752% # ( 6, 10 ] 4529 1.593% 99.345% ( 10, 15 ] 609 0.214% 99.559% ( 15, 22 ] 109 0.038% 99.597% ( 22, 34 ] 30 0.011% 99.608% ( 34, 51 ] 4 0.001% 99.609% ( 51, 76 ] 7 0.002% 99.612% ( 76, 110 ] 237 0.083% 99.695% ( 110, 170 ] 376 0.132% 99.827% ( 170, 250 ] 201 0.071% 99.898% ( 250, 380 ] 117 0.041% 99.939% ( 380, 580 ] 118 0.042% 99.981% ( 580, 870 ] 69 0.024% 100.005% ( 870, 1300 ] 28 0.010% 100.015% ( 1300, 1900 ] 16 0.006% 100.020% ( 1900, 2900 ] 13 0.005% 100.025% ( 2900, 4400 ] 4 0.001% 100.026% ** Level 4 read latency histogram (micros): Count: 320 Average: 145.8750 StdDev: 547.66 Min: 0 Median: 1.8696 Max: 4709 Percentiles: P50: 1.87 P75: 6.67 P99: 2866.67 P99.9: 4709.00 P99.99: 4709.00 ------------------------------------------------------ [ 0, 1 ] 60 18.750% 18.750% #### ( 1, 2 ] 115 35.938% 54.688% ####### ( 2, 3 ] 43 13.438% 68.125% ### ( 3, 4 ] 9 2.812% 70.938% # ( 4, 6 ] 11 3.438% 74.375% # ( 6, 10 ] 12 3.750% 78.125% # ( 10, 15 ] 21 6.562% 84.688% # ( 15, 22 ] 16 5.000% 89.688% # ( 22, 34 ] 1 0.312% 90.000% ( 110, 170 ] 1 0.312% 90.312% ( 170, 250 ] 1 0.312% 90.625% ( 380, 580 ] 3 0.938% 91.562% ( 580, 870 ] 10 3.125% 94.688% # ( 870, 1300 ] 3 0.938% 95.625% ( 1300, 1900 ] 5 1.562% 97.188% ( 1900, 2900 ] 6 1.875% 99.062% ( 2900, 4400 ] 2 0.625% 99.688% ( 4400, 6600 ] 1 0.312% 100.000% ** Level 5 read latency histogram (micros): Count: 60 Average: 827.3667 StdDev: 1035.20 Min: 93 Median: 328.0000 Max: 4270 Percentiles: P50: 328.00 P75: 1115.71 P99: 4100.00 P99.9: 4270.00 P99.99: 4270.00 ------------------------------------------------------ ( 76, 110 ] 7 11.667% 11.667% ## ( 110, 170 ] 12 20.000% 31.667% #### ( 170, 250 ] 8 13.333% 45.000% ### ( 250, 380 ] 5 8.333% 53.333% ## ( 380, 580 ] 5 8.333% 61.667% ## ( 580, 870 ] 4 6.667% 68.333% # ( 870, 1300 ] 7 11.667% 80.000% ## ( 1300, 1900 ] 2 3.333% 83.333% # ( 1900, 2900 ] 7 11.667% 95.000% ## ( 2900, 4400 ] 3 5.000% 100.000% # ** DB Stats ** Uptime(secs): 23.2 total, 7.9 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 254.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:7.176 H:M:S, 30.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 125.07 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:5.214 H:M:S, 66.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/23-07:04:25 ... thread 0: (1000000,7000000) ops and (104405.0,214731.7) ops/second in (9.578083,32.598818) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 12/10 2.46 GB 18.9 6.0 0.0 6.0 12.6 6.6 0.0 1.9 134.4 283.8 45.47 40.10 115 0.395 6203K 8949 0.0 0.0 L1 9/9 592.79 MB 0.0 4.2 3.9 0.3 4.2 3.9 0.2 1.1 224.4 221.8 19.32 18.24 3 6.441 4402K 49K 0.0 0.0 L2 3/3 386.34 MB 0.0 0.4 0.2 0.2 0.4 0.2 3.5 2.0 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 35/11 1.67 GB 1.0 5.2 2.9 2.4 5.2 2.8 0.4 1.8 157.1 156.4 34.23 23.73 20 1.711 5460K 24K 0.0 0.0 L4 189/5 10.20 GB 1.0 1.6 1.5 0.1 1.6 1.5 0.8 1.1 125.9 125.6 13.24 7.82 23 0.576 1641K 1409 0.0 0.0 L5 1064/0 87.42 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.7 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1312/38 102.70 GB 0.0 17.4 8.5 8.9 24.0 15.1 6.7 3.6 157.1 216.1 113.73 91.32 163 0.698 18M 84K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.4 8.5 8.9 24.0 15.1 6.5 3.6 157.1 216.1 113.73 91.32 163 0.698 18M 84K 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.4 8.5 8.9 17.4 8.4 0.0 0.0 195.0 194.1 91.62 73.82 67 1.367 18M 84K 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 307.7 22.11 17.50 96 0.230 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 32.8 total, 32.6 interval Flush(GB): cumulative 6.644, interval 6.644 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.01 GB write, 749.67 MB/s write, 17.45 GB read, 544.84 MB/s read, 113.7 seconds Interval compaction: 24.01 GB write, 754.05 MB/s write, 17.45 GB read, 548.03 MB/s read, 113.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 42, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 42, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2833433 Average: 2.8663 StdDev: 34.15 Min: 0 Median: 1.5309 Max: 13028 Percentiles: P50: 1.53 P75: 1.92 P99: 6.31 P99.9: 112.80 P99.99: 392.12 ------------------------------------------------------ [ 0, 1 ] 439950 15.527% 15.527% ### ( 1, 2 ] 1839952 64.937% 80.464% ############# ( 2, 3 ] 328721 11.602% 92.066% ## ( 3, 4 ] 111469 3.934% 96.000% # ( 4, 6 ] 83404 2.944% 98.943% # ( 6, 10 ] 20689 0.730% 99.674% ( 10, 15 ] 3527 0.124% 99.798% ( 15, 22 ] 646 0.023% 99.821% ( 22, 34 ] 32 0.001% 99.822% ( 34, 51 ] 38 0.001% 99.823% ( 51, 76 ] 68 0.002% 99.826% ( 76, 110 ] 2021 0.071% 99.897% ( 110, 170 ] 1791 0.063% 99.960% ( 170, 250 ] 463 0.016% 99.977% ( 250, 380 ] 359 0.013% 99.989% ( 380, 580 ] 341 0.012% 100.001% ( 580, 870 ] 236 0.008% 100.010% ( 870, 1300 ] 179 0.006% 100.016% ( 1300, 1900 ] 84 0.003% 100.019% ( 1900, 2900 ] 72 0.003% 100.021% ( 2900, 4400 ] 84 0.003% 100.024% ( 4400, 6600 ] 20 0.001% 100.025% ( 6600, 9900 ] 6 0.000% 100.025% ( 9900, 14000 ] 2 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 926113 Average: 6.9905 StdDev: 121.29 Min: 0 Median: 1.8847 Max: 15217 Percentiles: P50: 1.88 P75: 2.85 P99: 9.43 P99.9: 199.31 P99.99: 614.41 ------------------------------------------------------ [ 0, 1 ] 32933 3.556% 3.556% # ( 1, 2 ] 486172 52.496% 56.052% ########## ( 2, 3 ] 206272 22.273% 78.325% #### ( 3, 4 ] 83327 8.997% 87.322% ## ( 4, 6 ] 89171 9.629% 96.951% ## ( 6, 10 ] 22129 2.389% 99.340% ( 10, 15 ] 3704 0.400% 99.740% ( 15, 22 ] 463 0.050% 99.790% ( 22, 34 ] 24 0.003% 99.793% ( 34, 51 ] 23 0.002% 99.795% ( 51, 76 ] 13 0.001% 99.797% ( 76, 110 ] 410 0.044% 99.841% ( 110, 170 ] 462 0.050% 99.891% ( 170, 250 ] 229 0.025% 99.916% ( 250, 380 ] 284 0.031% 99.946% ( 380, 580 ] 365 0.039% 99.986% ( 580, 870 ] 332 0.036% 100.022% ( 870, 1300 ] 249 0.027% 100.048% ( 1300, 1900 ] 152 0.016% 100.065% ( 1900, 2900 ] 211 0.023% 100.088% ( 2900, 4400 ] 321 0.035% 100.122% ( 4400, 6600 ] 102 0.011% 100.133% ( 6600, 9900 ] 53 0.006% 100.139% ( 9900, 14000 ] 7 0.001% 100.140% ( 14000, 22000 ] 2 0.000% 100.140% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 998271 Average: 5.4406 StdDev: 81.00 Min: 0 Median: 1.9398 Max: 13946 Percentiles: P50: 1.94 P75: 2.93 P99: 9.21 P99.9: 134.65 P99.99: 335.65 ------------------------------------------------------ [ 0, 1 ] 26161 2.621% 2.621% # ( 1, 2 ] 503285 50.416% 53.036% ########## ( 2, 3 ] 236347 23.676% 76.712% ##### ( 3, 4 ] 99457 9.963% 86.675% ## ( 4, 6 ] 106197 10.638% 97.313% ## ( 6, 10 ] 21019 2.106% 99.418% ( 10, 15 ] 3825 0.383% 99.802% ( 15, 22 ] 454 0.045% 99.847% ( 22, 34 ] 62 0.006% 99.853% ( 34, 51 ] 21 0.002% 99.855% ( 51, 76 ] 14 0.001% 99.857% ( 76, 110 ] 247 0.025% 99.882% ( 110, 170 ] 452 0.045% 99.927% ( 170, 250 ] 393 0.039% 99.966% ( 250, 380 ] 363 0.036% 100.003% ( 380, 580 ] 432 0.043% 100.046% ( 580, 870 ] 368 0.037% 100.083% ( 870, 1300 ] 252 0.025% 100.108% ( 1300, 1900 ] 125 0.013% 100.121% ( 1900, 2900 ] 120 0.012% 100.133% ( 2900, 4400 ] 183 0.018% 100.151% ( 4400, 6600 ] 34 0.003% 100.154% ( 6600, 9900 ] 19 0.002% 100.156% ( 9900, 14000 ] 3 0.000% 100.156% ** Level 4 read latency histogram (micros): Count: 24081 Average: 93.3458 StdDev: 448.05 Min: 0 Median: 2.1304 Max: 9053 Percentiles: P50: 2.13 P75: 3.41 P99: 2408.04 P99.9: 5385.55 P99.99: 6577.55 ------------------------------------------------------ [ 0, 1 ] 438 1.819% 1.819% ( 1, 2 ] 10877 45.168% 46.987% ######### ( 2, 3 ] 5562 23.097% 70.084% ##### ( 3, 4 ] 2907 12.072% 82.156% ## ( 4, 6 ] 1861 7.728% 89.884% ## ( 6, 10 ] 581 2.413% 92.297% ( 10, 15 ] 128 0.532% 92.828% ( 15, 22 ] 36 0.149% 92.978% ( 22, 34 ] 6 0.025% 93.003% ( 34, 51 ] 2 0.008% 93.011% ( 110, 170 ] 18 0.075% 93.086% ( 170, 250 ] 71 0.295% 93.381% ( 250, 380 ] 117 0.486% 93.867% ( 380, 580 ] 240 0.997% 94.863% ( 580, 870 ] 361 1.499% 96.362% ( 870, 1300 ] 329 1.366% 97.728% ( 1300, 1900 ] 231 0.959% 98.688% ( 1900, 2900 ] 148 0.615% 99.302% ( 2900, 4400 ] 126 0.523% 99.826% ( 4400, 6600 ] 40 0.166% 99.992% ( 6600, 9900 ] 5 0.021% 100.012% ** Level 5 read latency histogram (micros): Count: 100 Average: 1105.3100 StdDev: 1198.58 Min: 93 Median: 646.9231 Max: 5529 Percentiles: P50: 646.92 P75: 1750.00 P99: 4400.00 P99.9: 5529.00 P99.99: 5529.00 ------------------------------------------------------ ( 76, 110 ] 7 7.000% 7.000% # ( 110, 170 ] 15 15.000% 22.000% ### ( 170, 250 ] 9 9.000% 31.000% ## ( 250, 380 ] 8 8.000% 39.000% ## ( 380, 580 ] 8 8.000% 47.000% ## ( 580, 870 ] 13 13.000% 60.000% ### ( 870, 1300 ] 12 12.000% 72.000% ## ( 1300, 1900 ] 4 4.000% 76.000% # ( 1900, 2900 ] 14 14.000% 90.000% ### ( 2900, 4400 ] 9 9.000% 99.000% ## ( 4400, 6600 ] 1 1.000% 100.000% ** DB Stats ** Uptime(secs): 32.8 total, 9.6 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 210.10 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.536 H:M:S, 41.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 102.75 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:6.360 H:M:S, 66.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/07/23-07:04:28 ... thread 0: (1000000,8000000) ops and (268255.4,220224.2) ops/second in (3.727791,36.326609) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/10 3.44 GB 132.1 7.0 0.0 7.0 14.6 7.6 0.0 1.9 133.6 279.9 53.29 46.65 131 0.407 7226K 10K 0.0 0.0 L1 9/9 592.79 MB 0.0 4.2 3.9 0.3 4.2 3.9 0.2 1.1 224.4 221.8 19.32 18.24 3 6.441 4402K 49K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.5 2.0 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 23/0 980.64 MB 1.0 6.0 3.2 2.7 5.9 3.2 0.4 1.8 154.3 153.6 39.65 27.12 23 1.724 6214K 28K 0.0 0.0 L4 187/0 9.62 GB 1.0 2.7 2.6 0.1 2.7 2.6 0.8 1.1 130.7 130.4 21.27 13.00 40 0.532 2724K 2181 0.0 0.0 L5 1084/0 89.08 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1319/19 103.67 GB 0.0 20.2 9.9 10.3 27.8 17.5 8.3 3.6 153.5 210.7 135.02 106.44 199 0.678 20M 90K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.2 9.9 10.3 27.8 17.5 8.2 3.6 153.5 210.7 135.02 106.44 199 0.678 20M 90K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.2 9.9 10.3 20.2 9.8 0.0 0.0 189.4 188.6 109.43 86.32 90 1.216 20M 90K 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 305.3 25.58 20.12 109 0.235 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): 36.5 total, 36.3 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: 27.78 GB write, 778.94 MB/s write, 20.24 GB read, 567.64 MB/s read, 135.0 seconds Interval compaction: 27.78 GB write, 783.03 MB/s write, 20.24 GB read, 570.62 MB/s read, 135.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 15, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 15, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 58, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 15, total-stops: 58, interval: 73 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3264924 Average: 2.8818 StdDev: 35.97 Min: 0 Median: 1.5483 Max: 15786 Percentiles: P50: 1.55 P75: 1.94 P99: 6.61 P99.9: 104.63 P99.99: 333.20 ------------------------------------------------------ [ 0, 1 ] 476110 14.583% 14.583% ### ( 1, 2 ] 2108807 64.590% 79.172% ############# ( 2, 3 ] 401093 12.285% 91.457% ## ( 3, 4 ] 136925 4.194% 95.651% # ( 4, 6 ] 105308 3.225% 98.877% # ( 6, 10 ] 26612 0.815% 99.692% ( 10, 15 ] 4211 0.129% 99.821% ( 15, 22 ] 709 0.022% 99.842% ( 22, 34 ] 40 0.001% 99.844% ( 34, 51 ] 40 0.001% 99.845% ( 51, 76 ] 71 0.002% 99.847% ( 76, 110 ] 2063 0.063% 99.910% ( 110, 170 ] 1860 0.057% 99.967% ( 170, 250 ] 501 0.015% 99.982% ( 250, 380 ] 393 0.012% 99.994% ( 380, 580 ] 371 0.011% 100.006% ( 580, 870 ] 266 0.008% 100.014% ( 870, 1300 ] 189 0.006% 100.020% ( 1300, 1900 ] 98 0.003% 100.023% ( 1900, 2900 ] 82 0.003% 100.025% ( 2900, 4400 ] 96 0.003% 100.028% ( 4400, 6600 ] 23 0.001% 100.029% ( 6600, 9900 ] 7 0.000% 100.029% ( 9900, 14000 ] 3 0.000% 100.029% ( 14000, 22000 ] 1 0.000% 100.029% ** Level 1 read latency histogram (micros): Count: 963290 Average: 7.0450 StdDev: 122.72 Min: 0 Median: 1.8878 Max: 15217 Percentiles: P50: 1.89 P75: 2.86 P99: 9.43 P99.9: 216.01 P99.99: 674.44 ------------------------------------------------------ [ 0, 1 ] 33468 3.474% 3.474% # ( 1, 2 ] 504835 52.407% 55.882% ########## ( 2, 3 ] 215279 22.348% 78.230% #### ( 3, 4 ] 87147 9.047% 87.277% ## ( 4, 6 ] 93020 9.656% 96.933% ## ( 6, 10 ] 23188 2.407% 99.340% ( 10, 15 ] 3851 0.400% 99.740% ( 15, 22 ] 474 0.049% 99.789% ( 22, 34 ] 25 0.003% 99.792% ( 34, 51 ] 23 0.002% 99.794% ( 51, 76 ] 13 0.001% 99.796% ( 76, 110 ] 410 0.043% 99.838% ( 110, 170 ] 462 0.048% 99.886% ( 170, 250 ] 229 0.024% 99.910% ( 250, 380 ] 287 0.030% 99.940% ( 380, 580 ] 370 0.038% 99.978% ( 580, 870 ] 346 0.036% 100.014% ( 870, 1300 ] 262 0.027% 100.041% ( 1300, 1900 ] 166 0.017% 100.059% ( 1900, 2900 ] 221 0.023% 100.082% ( 2900, 4400 ] 338 0.035% 100.117% ( 4400, 6600 ] 107 0.011% 100.128% ( 6600, 9900 ] 56 0.006% 100.134% ( 9900, 14000 ] 7 0.001% 100.134% ( 14000, 22000 ] 3 0.000% 100.135% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1264800 Average: 5.1707 StdDev: 75.69 Min: 0 Median: 1.9538 Max: 13946 Percentiles: P50: 1.95 P75: 2.94 P99: 9.08 P99.9: 76.03 P99.99: 237.64 ------------------------------------------------------ [ 0, 1 ] 28322 2.239% 2.239% ( 1, 2 ] 633322 50.073% 52.312% ########## ( 2, 3 ] 303812 24.021% 76.333% ##### ( 3, 4 ] 129012 10.200% 86.533% ## ( 4, 6 ] 137414 10.864% 97.397% ## ( 6, 10 ] 26336 2.082% 99.480% ( 10, 15 ] 4665 0.369% 99.848% ( 15, 22 ] 545 0.043% 99.892% ( 22, 34 ] 67 0.005% 99.897% ( 34, 51 ] 23 0.002% 99.899% ( 51, 76 ] 17 0.001% 99.900% ( 76, 110 ] 253 0.020% 99.920% ( 110, 170 ] 500 0.040% 99.960% ( 170, 250 ] 456 0.036% 99.996% ( 250, 380 ] 432 0.034% 100.030% ( 380, 580 ] 487 0.039% 100.068% ( 580, 870 ] 411 0.032% 100.101% ( 870, 1300 ] 283 0.022% 100.123% ( 1300, 1900 ] 139 0.011% 100.134% ( 1900, 2900 ] 137 0.011% 100.145% ( 2900, 4400 ] 210 0.017% 100.162% ( 4400, 6600 ] 37 0.003% 100.164% ( 6600, 9900 ] 20 0.002% 100.166% ( 9900, 14000 ] 3 0.000% 100.166% ** Level 4 read latency histogram (micros): Count: 39354 Average: 84.8871 StdDev: 441.72 Min: 0 Median: 2.0657 Max: 15280 Percentiles: P50: 2.07 P75: 3.32 P99: 2224.45 P99.9: 5632.19 P99.99: 8271.32 ------------------------------------------------------ [ 0, 1 ] 776 1.972% 1.972% ( 1, 2 ] 18314 46.537% 48.508% ######### ( 2, 3 ] 8936 22.707% 71.215% ##### ( 3, 4 ] 4641 11.793% 83.008% ## ( 4, 6 ] 2919 7.417% 90.425% # ( 6, 10 ] 900 2.287% 92.712% ( 10, 15 ] 193 0.490% 93.203% ( 15, 22 ] 45 0.114% 93.317% ( 22, 34 ] 7 0.018% 93.335% ( 34, 51 ] 2 0.005% 93.340% ( 76, 110 ] 18 0.046% 93.386% ( 110, 170 ] 73 0.185% 93.571% ( 170, 250 ] 166 0.422% 93.993% ( 250, 380 ] 222 0.564% 94.557% ( 380, 580 ] 389 0.988% 95.546% ( 580, 870 ] 511 1.298% 96.844% ( 870, 1300 ] 455 1.156% 98.000% ( 1300, 1900 ] 325 0.826% 98.826% ( 1900, 2900 ] 211 0.536% 99.362% ( 2900, 4400 ] 173 0.440% 99.802% ( 4400, 6600 ] 69 0.175% 99.977% ( 6600, 9900 ] 10 0.025% 100.003% ( 9900, 14000 ] 1 0.003% 100.005% ( 14000, 22000 ] 1 0.003% 100.008% ** Level 5 read latency histogram (micros): Count: 200 Average: 1415.5850 StdDev: 1416.21 Min: 83 Median: 870.0000 Max: 6744 Percentiles: P50: 870.00 P75: 2306.25 P99: 6600.00 P99.9: 6744.00 P99.99: 6744.00 ------------------------------------------------------ ( 76, 110 ] 11 5.500% 5.500% # ( 110, 170 ] 20 10.000% 15.500% ## ( 170, 250 ] 18 9.000% 24.500% ## ( 250, 380 ] 16 8.000% 32.500% ## ( 380, 580 ] 16 8.000% 40.500% ## ( 580, 870 ] 19 9.500% 50.000% ## ( 870, 1300 ] 24 12.000% 62.000% ## ( 1300, 1900 ] 13 6.500% 68.500% # ( 1900, 2900 ] 32 16.000% 84.500% ### ( 2900, 4400 ] 24 12.000% 96.500% ## ( 4400, 6600 ] 5 2.500% 99.000% # ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 36.5 total, 3.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 215.59 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:14.433 H:M:S, 39.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 263.92 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.897 H:M:S, 24.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-07:04:32 ... thread 0: (1000000,9000000) ops and (296053.2,226675.2) ops/second in (3.377771,39.704380) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/10 4.36 GB 226.5 8.1 0.0 8.1 16.6 8.5 0.0 1.9 136.9 282.1 60.26 53.24 149 0.404 8378K 11K 0.0 0.0 L1 9/9 592.79 MB 0.0 4.2 3.9 0.3 4.2 3.9 0.2 1.1 224.4 221.8 19.32 18.24 3 6.441 4402K 49K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.5 2.0 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 23/0 980.64 MB 1.0 6.0 3.2 2.7 5.9 3.2 0.4 1.8 154.3 153.6 39.65 27.12 23 1.724 6214K 28K 0.0 0.0 L4 187/0 9.62 GB 1.0 2.7 2.6 0.1 2.7 2.6 0.8 1.1 130.7 130.4 21.27 13.00 40 0.532 2724K 2181 0.0 0.0 L5 1084/0 89.08 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1321/19 104.59 GB 0.0 21.4 9.9 11.4 29.8 18.4 8.3 3.5 154.0 215.0 141.98 113.03 217 0.654 22M 91K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.4 9.9 11.4 29.8 18.4 8.2 3.5 154.0 215.0 141.98 113.03 217 0.654 22M 91K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.4 9.9 11.4 21.3 9.8 0.0 0.0 192.2 191.4 113.74 90.54 94 1.210 22M 91K 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 310.1 28.24 22.49 123 0.230 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): 39.9 total, 39.7 interval Flush(GB): cumulative 8.551, interval 8.551 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.81 GB write, 765.08 MB/s write, 21.35 GB read, 548.01 MB/s read, 142.0 seconds Interval compaction: 29.81 GB write, 768.75 MB/s write, 21.35 GB read, 550.64 MB/s read, 142.0 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 18, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 18, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 59, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 18, total-stops: 59, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3645490 Average: 2.8156 StdDev: 34.15 Min: 0 Median: 1.5472 Max: 15786 Percentiles: P50: 1.55 P75: 1.93 P99: 6.38 P99.9: 97.56 P99.99: 290.73 ------------------------------------------------------ [ 0, 1 ] 525182 14.406% 14.406% ### ( 1, 2 ] 2371144 65.043% 79.450% ############# ( 2, 3 ] 446913 12.259% 91.709% ## ( 3, 4 ] 150166 4.119% 95.828% # ( 4, 6 ] 112898 3.097% 98.925% # ( 6, 10 ] 28918 0.793% 99.718% ( 10, 15 ] 4392 0.120% 99.839% ( 15, 22 ] 753 0.021% 99.859% ( 22, 34 ] 47 0.001% 99.861% ( 34, 51 ] 44 0.001% 99.862% ( 51, 76 ] 74 0.002% 99.864% ( 76, 110 ] 2071 0.057% 99.921% ( 110, 170 ] 1883 0.052% 99.972% ( 170, 250 ] 512 0.014% 99.986% ( 250, 380 ] 410 0.011% 99.998% ( 380, 580 ] 379 0.010% 100.008% ( 580, 870 ] 270 0.007% 100.016% ( 870, 1300 ] 199 0.005% 100.021% ( 1300, 1900 ] 98 0.003% 100.024% ( 1900, 2900 ] 82 0.002% 100.026% ( 2900, 4400 ] 97 0.003% 100.029% ( 4400, 6600 ] 23 0.001% 100.029% ( 6600, 9900 ] 7 0.000% 100.029% ( 9900, 14000 ] 3 0.000% 100.029% ( 14000, 22000 ] 1 0.000% 100.030% ** Level 1 read latency histogram (micros): Count: 1038938 Average: 6.7477 StdDev: 118.31 Min: 0 Median: 1.8618 Max: 15217 Percentiles: P50: 1.86 P75: 2.81 P99: 9.38 P99.9: 205.36 P99.99: 673.15 ------------------------------------------------------ [ 0, 1 ] 39959 3.846% 3.846% # ( 1, 2 ] 556409 53.556% 57.402% ########### ( 2, 3 ] 226435 21.795% 79.197% #### ( 3, 4 ] 90050 8.668% 87.864% ## ( 4, 6 ] 95104 9.154% 97.018% ## ( 6, 10 ] 24333 2.342% 99.360% ( 10, 15 ] 3884 0.374% 99.734% ( 15, 22 ] 479 0.046% 99.780% ( 22, 34 ] 25 0.002% 99.782% ( 34, 51 ] 23 0.002% 99.785% ( 51, 76 ] 18 0.002% 99.786% ( 76, 110 ] 503 0.048% 99.835% ( 110, 170 ] 567 0.055% 99.889% ( 170, 250 ] 249 0.024% 99.913% ( 250, 380 ] 303 0.029% 99.943% ( 380, 580 ] 381 0.037% 99.979% ( 580, 870 ] 349 0.034% 100.013% ( 870, 1300 ] 262 0.025% 100.038% ( 1300, 1900 ] 167 0.016% 100.054% ( 1900, 2900 ] 223 0.021% 100.076% ( 2900, 4400 ] 339 0.033% 100.108% ( 4400, 6600 ] 107 0.010% 100.118% ( 6600, 9900 ] 56 0.005% 100.124% ( 9900, 14000 ] 7 0.001% 100.125% ( 14000, 22000 ] 3 0.000% 100.125% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1264800 Average: 5.1707 StdDev: 75.69 Min: 0 Median: 1.9538 Max: 13946 Percentiles: P50: 1.95 P75: 2.94 P99: 9.08 P99.9: 76.03 P99.99: 237.64 ------------------------------------------------------ [ 0, 1 ] 28322 2.239% 2.239% ( 1, 2 ] 633322 50.073% 52.312% ########## ( 2, 3 ] 303812 24.021% 76.333% ##### ( 3, 4 ] 129012 10.200% 86.533% ## ( 4, 6 ] 137414 10.864% 97.397% ## ( 6, 10 ] 26336 2.082% 99.480% ( 10, 15 ] 4665 0.369% 99.848% ( 15, 22 ] 545 0.043% 99.892% ( 22, 34 ] 67 0.005% 99.897% ( 34, 51 ] 23 0.002% 99.899% ( 51, 76 ] 17 0.001% 99.900% ( 76, 110 ] 253 0.020% 99.920% ( 110, 170 ] 500 0.040% 99.960% ( 170, 250 ] 456 0.036% 99.996% ( 250, 380 ] 432 0.034% 100.030% ( 380, 580 ] 487 0.039% 100.068% ( 580, 870 ] 411 0.032% 100.101% ( 870, 1300 ] 283 0.022% 100.123% ( 1300, 1900 ] 139 0.011% 100.134% ( 1900, 2900 ] 137 0.011% 100.145% ( 2900, 4400 ] 210 0.017% 100.162% ( 4400, 6600 ] 37 0.003% 100.164% ( 6600, 9900 ] 20 0.002% 100.166% ( 9900, 14000 ] 3 0.000% 100.166% ** Level 4 read latency histogram (micros): Count: 39354 Average: 84.8871 StdDev: 441.72 Min: 0 Median: 2.0657 Max: 15280 Percentiles: P50: 2.07 P75: 3.32 P99: 2224.45 P99.9: 5632.19 P99.99: 8271.32 ------------------------------------------------------ [ 0, 1 ] 776 1.972% 1.972% ( 1, 2 ] 18314 46.537% 48.508% ######### ( 2, 3 ] 8936 22.707% 71.215% ##### ( 3, 4 ] 4641 11.793% 83.008% ## ( 4, 6 ] 2919 7.417% 90.425% # ( 6, 10 ] 900 2.287% 92.712% ( 10, 15 ] 193 0.490% 93.203% ( 15, 22 ] 45 0.114% 93.317% ( 22, 34 ] 7 0.018% 93.335% ( 34, 51 ] 2 0.005% 93.340% ( 76, 110 ] 18 0.046% 93.386% ( 110, 170 ] 73 0.185% 93.571% ( 170, 250 ] 166 0.422% 93.993% ( 250, 380 ] 222 0.564% 94.557% ( 380, 580 ] 389 0.988% 95.546% ( 580, 870 ] 511 1.298% 96.844% ( 870, 1300 ] 455 1.156% 98.000% ( 1300, 1900 ] 325 0.826% 98.826% ( 1900, 2900 ] 211 0.536% 99.362% ( 2900, 4400 ] 173 0.440% 99.802% ( 4400, 6600 ] 69 0.175% 99.977% ( 6600, 9900 ] 10 0.025% 100.003% ( 9900, 14000 ] 1 0.003% 100.005% ( 14000, 22000 ] 1 0.003% 100.008% ** Level 5 read latency histogram (micros): Count: 200 Average: 1415.5850 StdDev: 1416.21 Min: 83 Median: 870.0000 Max: 6744 Percentiles: P50: 870.00 P75: 2306.25 P99: 6600.00 P99.9: 6744.00 P99.99: 6744.00 ------------------------------------------------------ ( 76, 110 ] 11 5.500% 5.500% # ( 110, 170 ] 20 10.000% 15.500% ## ( 170, 250 ] 18 9.000% 24.500% ## ( 250, 380 ] 16 8.000% 32.500% ## ( 380, 580 ] 16 8.000% 40.500% ## ( 580, 870 ] 19 9.500% 50.000% ## ( 870, 1300 ] 24 12.000% 62.000% ## ( 1300, 1900 ] 13 6.500% 68.500% # ( 1900, 2900 ] 32 16.000% 84.500% ### ( 2900, 4400 ] 24 12.000% 96.500% ## ( 4400, 6600 ] 5 2.500% 99.000% # ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 39.9 total, 3.4 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 222.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:15.142 H:M:S, 38.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 291.49 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.709 H:M:S, 21.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/23-07:04:44 ... thread 0: (1000000,10000000) ops and (82269.2,192828.3) ops/second in (12.155216,51.859596) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/12 3.50 GB 69.2 9.1 0.0 9.1 18.7 9.6 0.0 1.9 138.6 284.4 67.28 59.85 169 0.398 9465K 12K 0.0 0.0 L1 27/27 2.46 GB 0.0 6.7 5.8 0.9 6.6 5.8 0.2 1.1 211.1 208.8 32.56 29.27 4 8.141 6379K 49K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.4 0.2 0.2 0.4 0.2 3.5 2.0 256.0 255.9 1.48 1.43 2 0.738 383K 198 0.0 0.0 L3 23/0 980.64 MB 1.0 6.0 3.2 2.7 5.9 3.2 0.4 1.8 154.3 153.6 39.65 27.12 23 1.724 6214K 28K 0.0 0.0 L4 187/0 9.62 GB 1.0 2.7 2.6 0.1 2.7 2.6 0.8 1.1 130.7 130.4 21.27 13.00 40 0.532 2724K 2181 0.0 0.0 L5 1084/0 89.08 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1337/39 105.61 GB 0.0 24.9 11.8 13.1 34.4 21.3 8.3 3.6 157.0 216.8 162.24 130.67 238 0.682 25M 93K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.9 11.8 13.1 34.4 21.3 8.2 3.6 157.0 216.8 162.24 130.67 238 0.682 25M 93K 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 24.9 11.8 13.1 24.8 11.7 0.0 0.0 194.6 193.6 130.93 105.45 99 1.322 25M 93K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.6 9.6 0.0 0.0 0.0 313.8 31.32 25.22 139 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): 52.1 total, 51.9 interval Flush(GB): cumulative 9.597, interval 9.597 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 34.35 GB write, 675.85 MB/s write, 24.88 GB read, 489.41 MB/s read, 162.2 seconds Interval compaction: 34.35 GB write, 678.34 MB/s write, 24.88 GB read, 491.21 MB/s read, 162.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 22, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 22, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 60, pending-compaction-bytes-delays: 5, pending-compaction-bytes-stops: 0, total-delays: 27, total-stops: 60, interval: 87 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4301870 Average: 2.7256 StdDev: 31.84 Min: 0 Median: 1.5247 Max: 15786 Percentiles: P50: 1.52 P75: 1.91 P99: 6.00 P99.9: 94.54 P99.99: 314.01 ------------------------------------------------------ [ 0, 1 ] 681249 15.836% 15.836% ### ( 1, 2 ] 2800769 65.106% 80.942% ############# ( 2, 3 ] 490702 11.407% 92.349% ## ( 3, 4 ] 164192 3.817% 96.165% # ( 4, 6 ] 122060 2.837% 99.003% # ( 6, 10 ] 31222 0.726% 99.729% ( 10, 15 ] 5093 0.118% 99.847% ( 15, 22 ] 911 0.021% 99.868% ( 22, 34 ] 56 0.001% 99.869% ( 34, 51 ] 48 0.001% 99.871% ( 51, 76 ] 76 0.002% 99.872% ( 76, 110 ] 2186 0.051% 99.923% ( 110, 170 ] 2019 0.047% 99.970% ( 170, 250 ] 621 0.014% 99.985% ( 250, 380 ] 483 0.011% 99.996% ( 380, 580 ] 452 0.011% 100.006% ( 580, 870 ] 330 0.008% 100.014% ( 870, 1300 ] 212 0.005% 100.019% ( 1300, 1900 ] 105 0.002% 100.021% ( 1900, 2900 ] 83 0.002% 100.023% ( 2900, 4400 ] 98 0.002% 100.026% ( 4400, 6600 ] 23 0.001% 100.026% ( 6600, 9900 ] 7 0.000% 100.026% ( 9900, 14000 ] 3 0.000% 100.026% ( 14000, 22000 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 1351897 Average: 5.7684 StdDev: 103.96 Min: 0 Median: 1.7305 Max: 15217 Percentiles: P50: 1.73 P75: 2.56 P99: 9.20 P99.9: 173.51 P99.99: 664.67 ------------------------------------------------------ [ 0, 1 ] 128297 9.490% 9.490% ## ( 1, 2 ] 749719 55.457% 64.947% ########### ( 2, 3 ] 242925 17.969% 82.916% #### ( 3, 4 ] 95792 7.086% 90.002% # ( 4, 6 ] 100491 7.433% 97.435% # ( 6, 10 ] 26475 1.958% 99.394% ( 10, 15 ] 4161 0.308% 99.701% ( 15, 22 ] 577 0.043% 99.744% ( 22, 34 ] 31 0.002% 99.746% ( 34, 51 ] 24 0.002% 99.748% ( 51, 76 ] 71 0.005% 99.753% ( 76, 110 ] 996 0.074% 99.827% ( 110, 170 ] 973 0.072% 99.899% ( 170, 250 ] 321 0.024% 99.923% ( 250, 380 ] 363 0.027% 99.950% ( 380, 580 ] 442 0.033% 99.982% ( 580, 870 ] 359 0.027% 100.009% ( 870, 1300 ] 273 0.020% 100.029% ( 1300, 1900 ] 169 0.013% 100.042% ( 1900, 2900 ] 224 0.017% 100.058% ( 2900, 4400 ] 339 0.025% 100.083% ( 4400, 6600 ] 107 0.008% 100.091% ( 6600, 9900 ] 56 0.004% 100.095% ( 9900, 14000 ] 7 0.001% 100.096% ( 14000, 22000 ] 3 0.000% 100.096% ** Level 2 read latency histogram (micros): Count: 95904 Average: 2.0613 StdDev: 5.64 Min: 1 Median: 1.4269 Max: 1256 Percentiles: P50: 1.43 P75: 1.82 P99: 5.64 P99.9: 10.87 P99.99: 24.46 ------------------------------------------------------ [ 0, 1 ] 22194 23.142% 23.142% ##### ( 1, 2 ] 60341 62.918% 86.060% ############# ( 2, 3 ] 7888 8.225% 94.285% ## ( 3, 4 ] 2731 2.848% 97.133% # ( 4, 6 ] 2189 2.282% 99.415% ( 6, 10 ] 449 0.468% 99.883% ( 10, 15 ] 93 0.097% 99.980% ( 15, 22 ] 9 0.009% 99.990% ( 22, 34 ] 2 0.002% 99.992% ( 34, 51 ] 1 0.001% 99.993% ( 51, 76 ] 1 0.001% 99.994% ( 250, 380 ] 1 0.001% 99.995% ( 380, 580 ] 2 0.002% 99.997% ( 580, 870 ] 2 0.002% 99.999% ( 870, 1300 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 1264800 Average: 5.1707 StdDev: 75.69 Min: 0 Median: 1.9538 Max: 13946 Percentiles: P50: 1.95 P75: 2.94 P99: 9.08 P99.9: 76.03 P99.99: 237.64 ------------------------------------------------------ [ 0, 1 ] 28322 2.239% 2.239% ( 1, 2 ] 633322 50.073% 52.312% ########## ( 2, 3 ] 303812 24.021% 76.333% ##### ( 3, 4 ] 129012 10.200% 86.533% ## ( 4, 6 ] 137414 10.864% 97.397% ## ( 6, 10 ] 26336 2.082% 99.480% ( 10, 15 ] 4665 0.369% 99.848% ( 15, 22 ] 545 0.043% 99.892% ( 22, 34 ] 67 0.005% 99.897% ( 34, 51 ] 23 0.002% 99.899% ( 51, 76 ] 17 0.001% 99.900% ( 76, 110 ] 253 0.020% 99.920% ( 110, 170 ] 500 0.040% 99.960% ( 170, 250 ] 456 0.036% 99.996% ( 250, 380 ] 432 0.034% 100.030% ( 380, 580 ] 487 0.039% 100.068% ( 580, 870 ] 411 0.032% 100.101% ( 870, 1300 ] 283 0.022% 100.123% ( 1300, 1900 ] 139 0.011% 100.134% ( 1900, 2900 ] 137 0.011% 100.145% ( 2900, 4400 ] 210 0.017% 100.162% ( 4400, 6600 ] 37 0.003% 100.164% ( 6600, 9900 ] 20 0.002% 100.166% ( 9900, 14000 ] 3 0.000% 100.166% ** Level 4 read latency histogram (micros): Count: 39354 Average: 84.8871 StdDev: 441.72 Min: 0 Median: 2.0657 Max: 15280 Percentiles: P50: 2.07 P75: 3.32 P99: 2224.45 P99.9: 5632.19 P99.99: 8271.32 ------------------------------------------------------ [ 0, 1 ] 776 1.972% 1.972% ( 1, 2 ] 18314 46.537% 48.508% ######### ( 2, 3 ] 8936 22.707% 71.215% ##### ( 3, 4 ] 4641 11.793% 83.008% ## ( 4, 6 ] 2919 7.417% 90.425% # ( 6, 10 ] 900 2.287% 92.712% ( 10, 15 ] 193 0.490% 93.203% ( 15, 22 ] 45 0.114% 93.317% ( 22, 34 ] 7 0.018% 93.335% ( 34, 51 ] 2 0.005% 93.340% ( 76, 110 ] 18 0.046% 93.386% ( 110, 170 ] 73 0.185% 93.571% ( 170, 250 ] 166 0.422% 93.993% ( 250, 380 ] 222 0.564% 94.557% ( 380, 580 ] 389 0.988% 95.546% ( 580, 870 ] 511 1.298% 96.844% ( 870, 1300 ] 455 1.156% 98.000% ( 1300, 1900 ] 325 0.826% 98.826% ( 1900, 2900 ] 211 0.536% 99.362% ( 2900, 4400 ] 173 0.440% 99.802% ( 4400, 6600 ] 69 0.175% 99.977% ( 6600, 9900 ] 10 0.025% 100.003% ( 9900, 14000 ] 1 0.003% 100.005% ( 14000, 22000 ] 1 0.003% 100.008% ** Level 5 read latency histogram (micros): Count: 200 Average: 1415.5850 StdDev: 1416.21 Min: 83 Median: 870.0000 Max: 6744 Percentiles: P50: 870.00 P75: 2306.25 P99: 6600.00 P99.9: 6744.00 P99.99: 6744.00 ------------------------------------------------------ ( 76, 110 ] 11 5.500% 5.500% # ( 110, 170 ] 20 10.000% 15.500% ## ( 170, 250 ] 18 9.000% 24.500% ## ( 250, 380 ] 16 8.000% 32.500% ## ( 380, 580 ] 16 8.000% 40.500% ## ( 580, 870 ] 19 9.500% 50.000% ## ( 870, 1300 ] 24 12.000% 62.000% ## ( 1300, 1900 ] 13 6.500% 68.500% # ( 1900, 2900 ] 32 16.000% 84.500% ### ( 2900, 4400 ] 24 12.000% 96.500% ## ( 4400, 6600 ] 5 2.500% 99.000% # ( 6600, 9900 ] 2 1.000% 100.000% ** DB Stats ** Uptime(secs): 52.1 total, 12.2 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 189.07 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:24.255 H:M:S, 46.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 80.96 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:9.113 H:M:S, 75.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.987 micros/op 167041 ops/sec 60.123 seconds 10042999 operations; 161.9 MB/s Microseconds per write: Count: 10042999 Average: 5.9865 StdDev: 491.13 Min: 1 Median: 1.7539 Max: 760691 Percentiles: P50: 1.75 P75: 2.74 P99: 9.17 P99.9: 1156.95 P99.99: 2713.49 ------------------------------------------------------ [ 0, 1 ] 1251438 12.461% 12.461% ## ( 1, 2 ] 5000637 49.792% 62.253% ########## ( 2, 3 ] 1737322 17.299% 79.552% ### ( 3, 4 ] 1364545 13.587% 93.139% ### ( 4, 6 ] 500939 4.988% 98.127% # ( 6, 10 ] 110543 1.101% 99.228% ( 10, 15 ] 36245 0.361% 99.588% ( 15, 22 ] 8498 0.085% 99.673% ( 22, 34 ] 1882 0.019% 99.692% ( 34, 51 ] 201 0.002% 99.694% ( 51, 76 ] 40 0.000% 99.694% ( 76, 110 ] 7170 0.071% 99.766% ( 110, 170 ] 2656 0.026% 99.792% ( 170, 250 ] 242 0.002% 99.794% ( 250, 380 ] 156 0.002% 99.796% ( 380, 580 ] 24 0.000% 99.796% ( 580, 870 ] 25 0.000% 99.797% ( 870, 1300 ] 15574 0.155% 99.952% ( 1300, 1900 ] 40 0.000% 99.952% ( 1900, 2900 ] 4693 0.047% 99.999% ( 2900, 4400 ] 90 0.001% 100.000% ( 4400, 6600 ] 7 0.000% 100.000% ( 6600, 9900 ] 4 0.000% 100.000% ( 9900, 14000 ] 3 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 2 0.000% 100.000% ( 50000, 75000 ] 2 0.000% 100.000% ( 75000, 110000 ] 1 0.000% 100.000% ( 170000, 250000 ] 14 0.000% 100.000% ( 380000, 570000 ] 1 0.000% 100.000% ( 570000, 860000 ] 3 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 202530 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 : 10042999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10364374968 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 : 549 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32105077 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 : 30934622135 rocksdb.compact.write.bytes COUNT : 30745581102 rocksdb.flush.write.bytes COUNT : 10304891355 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 : 50 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 : 318 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 : 10221840384 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4008960 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 : 31025484985 rocksdb.non.last.level.read.count COUNT : 7498699 rocksdb.block.checksum.compute.count COUNT : 7497651 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.411642 P95 : 3.872132 P99 : 7.582973 P100 : 760683.000000 COUNT : 10042999 SUM : 55371379 rocksdb.compaction.times.micros P50 : 963214.285714 P95 : 3267500.000000 P99 : 14080000.000000 P100 : 14195113.000000 COUNT : 99 SUM : 130925931 rocksdb.compaction.times.cpu_micros P50 : 890512.820513 P95 : 2923333.333333 P99 : 11921000.000000 P100 : 13254992.000000 COUNT : 99 SUM : 105453214 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 : 701.164384 P95 : 2425.000000 P99 : 16188.000000 P100 : 16188.000000 COUNT : 139 SUM : 165732 rocksdb.compaction.outfile.sync.micros P50 : 1080.326087 P95 : 89538.461538 P99 : 150400.000000 P100 : 166766.000000 COUNT : 392 SUM : 4915146 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 : 111.034483 P95 : 1891.000000 P99 : 3836.428571 P100 : 4241.000000 COUNT : 263 SUM : 100757 rocksdb.table.open.io.micros P50 : 1220.064103 P95 : 7558.269231 P99 : 11955.857143 P100 : 19138.000000 COUNT : 549 SUM : 1070728 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.663398 P95 : 7.840924 P99 : 11.157517 P100 : 16792.000000 COUNT : 7496058 SUM : 47564465 rocksdb.read.block.get.micros P50 : 355.570470 P95 : 3098.913043 P99 : 5204.000000 P100 : 9700.000000 COUNT : 1098 SUM : 855707 rocksdb.write.raw.block.micros P50 : 0.513733 P95 : 0.976092 P99 : 2.823397 P100 : 23564.000000 COUNT : 9942225 SUM : 21196401 rocksdb.numfiles.in.singlecompaction P50 : 2.625000 P95 : 4.600000 P99 : 20.040000 P100 : 39.000000 COUNT : 128 SUM : 456 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.565411 P95 : 1186.839709 P99 : 2528.224801 P100 : 760480.000000 COUNT : 175887 SUM : 32120915 rocksdb.sst.read.micros P50 : 1.606248 P95 : 4.691826 P99 : 8.504242 P100 : 15786.000000 COUNT : 7498852 SUM : 31782070 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 : 10042999 SUM : 10364374968 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 : 212800.000000 P95 : 429875.000000 P99 : 944349.000000 P100 : 944349.000000 COUNT : 139 SUM : 31319017 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 : 346 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