[2024-11-29 00:36:54.649934] Starting SPDK v24.09.1-pre git sha1 b18e1bd62 / DPDK 23.11.0 initialization... [2024-11-29 00:36:54.650033] [ 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_pid1091597 ] Set seed to 1732837014647545 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-29 00:36:54.750110] app.c: 917:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-29 00:36:54.791445] app.c: 610:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-29 00:36:54.791498] app.c: 611:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1091597' to capture a snapshot of events at runtime. [2024-11-29 00:36:54.791508] app.c: 616:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-29 00:36:54.791535] app.c: 617:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-29 00:36:54.791543] app.c: 618:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1091597 for offline analysis/debug. [2024-11-29 00:36:54.791633] reactor.c: 990:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Nov 29 00:36:59 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/29-00:37:01 ... thread 0: (1000000,1000000) ops and (353528.9,353528.9) ops/second in (2.828623,2.828623) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/9 630.02 MB 6.3 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 346.9 2.36 2.11 12 0.197 0 0 0.0 0.0 L2 3/2 236.94 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.0 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 8/0 692.92 MB 0.7 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 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.88 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 1181/11 96.94 GB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 91.9 307.9 3.79 3.49 14 0.271 353K 164 0.0 0.0 Int 0/0 0.00 KB 0.0 0.3 0.2 0.2 1.1 1.0 0.0 1.4 91.9 307.9 3.79 3.49 14 0.271 353K 164 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.3 0.2 0.2 0.3 0.2 0.0 0.0 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.8 0.8 0.0 0.0 0.0 346.9 2.36 2.11 12 0.197 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.0 total, 2.8 interval Flush(GB): cumulative 0.800, interval 0.800 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.14 GB write, 388.92 MB/s write, 0.34 GB read, 116.05 MB/s read, 3.8 seconds Interval compaction: 1.14 GB write, 412.39 MB/s write, 0.34 GB read, 123.06 MB/s read, 3.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 1, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 1, interval: 1 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 122032 Average: 2.0129 StdDev: 15.16 Min: 1 Median: 1.3311 Max: 4197 Percentiles: P50: 1.33 P75: 1.75 P99: 5.34 P99.9: 9.99 P99.99: 40.77 ------------------------------------------------------ [ 0, 1 ] 37151 30.444% 30.444% ###### ( 1, 2 ] 72079 59.066% 89.509% ############ ( 2, 3 ] 7126 5.839% 95.349% # ( 3, 4 ] 3151 2.582% 97.931% # ( 4, 6 ] 1949 1.597% 99.528% ( 6, 10 ] 456 0.374% 99.902% ( 10, 15 ] 88 0.072% 99.974% ( 15, 22 ] 14 0.011% 99.985% ( 22, 34 ] 6 0.005% 99.990% ( 34, 51 ] 2 0.002% 99.992% ( 51, 76 ] 1 0.001% 99.993% ( 76, 110 ] 1 0.001% 99.993% ( 110, 170 ] 7 0.006% 99.999% ( 170, 250 ] 4 0.003% 100.002% ( 250, 380 ] 4 0.003% 100.006% ( 380, 580 ] 2 0.002% 100.007% ( 580, 870 ] 3 0.002% 100.010% ( 870, 1300 ] 1 0.001% 100.011% ( 1300, 1900 ] 1 0.001% 100.011% ( 1900, 2900 ] 1 0.001% 100.012% ( 2900, 4400 ] 1 0.001% 100.013% ** Level 1 read latency histogram (micros): Count: 12237 Average: 2.6734 StdDev: 19.06 Min: 1 Median: 1.2911 Max: 1554 Percentiles: P50: 1.29 P75: 1.75 P99: 9.62 P99.9: 180.17 P99.99: 837.56 ------------------------------------------------------ [ 0, 1 ] 4161 34.003% 34.003% ####### ( 1, 2 ] 6725 54.956% 88.960% ########### ( 2, 3 ] 837 6.840% 95.800% # ( 3, 4 ] 132 1.079% 96.878% ( 4, 6 ] 151 1.234% 98.112% ( 6, 10 ] 120 0.981% 99.093% ( 10, 15 ] 24 0.196% 99.289% ( 15, 22 ] 3 0.025% 99.314% ( 22, 34 ] 1 0.008% 99.322% ( 34, 51 ] 43 0.351% 99.673% ( 51, 76 ] 17 0.139% 99.812% ( 76, 110 ] 5 0.041% 99.853% ( 110, 170 ] 5 0.041% 99.894% ( 170, 250 ] 6 0.049% 99.943% ( 250, 380 ] 2 0.016% 99.959% ( 380, 580 ] 2 0.016% 99.975% ( 580, 870 ] 2 0.016% 99.992% ( 1300, 1900 ] 1 0.008% 100.000% ** Level 2 read latency histogram (micros): Count: 59203 Average: 1.9939 StdDev: 6.82 Min: 0 Median: 1.3699 Max: 1413 Percentiles: P50: 1.37 P75: 1.78 P99: 5.38 P99.9: 9.94 P99.99: 252.59 ------------------------------------------------------ [ 0, 1 ] 16143 27.267% 27.267% ##### ( 1, 2 ] 36388 61.463% 88.730% ############ ( 2, 3 ] 3852 6.506% 95.237% # ( 3, 4 ] 1505 2.542% 97.779% # ( 4, 6 ] 1052 1.777% 99.556% ( 6, 10 ] 209 0.353% 99.909% ( 10, 15 ] 36 0.061% 99.970% ( 15, 22 ] 6 0.010% 99.980% ( 22, 34 ] 2 0.003% 99.983% ( 34, 51 ] 1 0.002% 99.985% ( 51, 76 ] 1 0.002% 99.986% ( 110, 170 ] 2 0.003% 99.990% ( 170, 250 ] 2 0.003% 99.993% ( 250, 380 ] 4 0.007% 100.000% ( 380, 580 ] 1 0.002% 100.002% ( 1300, 1900 ] 1 0.002% 100.003% ** Level 3 read latency histogram (micros): Count: 40 Average: 1476.7500 StdDev: 1196.70 Min: 129 Median: 831.3333 Max: 5161 Percentiles: P50: 831.33 P75: 2328.57 P99: 5161.00 P99.9: 5161.00 P99.99: 5161.00 ------------------------------------------------------ ( 110, 170 ] 2 5.000% 5.000% # ( 170, 250 ] 1 2.500% 7.500% # ( 250, 380 ] 1 2.500% 10.000% # ( 380, 580 ] 3 7.500% 17.500% ## ( 580, 870 ] 15 37.500% 55.000% ######## ( 870, 1300 ] 3 7.500% 62.500% ## ( 1300, 1900 ] 2 5.000% 67.500% # ( 1900, 2900 ] 7 17.500% 85.000% #### ( 2900, 4400 ] 5 12.500% 97.500% ### ( 4400, 6600 ] 1 2.500% 100.000% # ** Level 4 read latency histogram (micros): Count: 35 Average: 1792.2857 StdDev: 1523.56 Min: 307 Median: 1350.0000 Max: 6861 Percentiles: P50: 1350.00 P75: 2364.29 P99: 6861.00 P99.9: 6861.00 P99.99: 6861.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 4 11.429% 17.143% ## ( 580, 870 ] 5 14.286% 31.429% ### ( 870, 1300 ] 6 17.143% 48.571% ### ( 1300, 1900 ] 6 17.143% 65.714% ### ( 1900, 2900 ] 7 20.000% 85.714% #### ( 2900, 4400 ] 3 8.571% 94.286% ## ( 4400, 6600 ] 1 2.857% 97.143% # ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 3.0 total, 2.8 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 327.95 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.230 H:M:S, 7.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 347.65 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.230 H:M:S, 8.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/29-00:37:04 ... thread 0: (1000000,2000000) ops and (330086.8,341405.9) ops/second in (3.029506,5.858129) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/10 1.29 GB 0.0 0.8 0.0 0.8 2.6 1.8 0.0 1.4 98.5 318.3 8.31 7.68 29 0.287 831K 870 0.0 0.0 L1 1/1 2.33 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.3 240.0 1.31 1.27 1 1.311 319K 415 0.0 0.0 L2 1/0 49.47 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 32/0 971.26 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 203.2 203.0 3.38 2.97 3 1.127 697K 601 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1232/11 97.92 GB 0.0 2.1 1.0 1.1 3.9 2.8 0.8 2.2 150.3 276.8 14.43 13.30 35 0.412 2202K 2050 0.0 0.0 Int 0/0 0.00 KB 0.0 2.1 1.0 1.1 3.9 2.8 0.7 2.2 150.3 276.8 14.43 13.30 35 0.412 2202K 2050 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 2.1 1.0 1.1 2.1 1.0 0.0 0.0 234.7 234.4 9.24 8.68 9 1.027 2202K 2050 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 1.8 1.8 0.0 0.0 0.0 352.2 5.19 4.61 26 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 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.90 GB write, 662.36 MB/s write, 2.12 GB read, 359.76 MB/s read, 14.4 seconds Interval compaction: 3.90 GB write, 681.66 MB/s write, 2.12 GB read, 370.24 MB/s read, 14.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 5, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 5, interval: 5 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 377416 Average: 2.1278 StdDev: 12.54 Min: 1 Median: 1.4361 Max: 4197 Percentiles: P50: 1.44 P75: 1.83 P99: 5.57 P99.9: 10.15 P99.99: 19.24 ------------------------------------------------------ [ 0, 1 ] 84896 22.494% 22.494% #### ( 1, 2 ] 238066 63.078% 85.572% ############# ( 2, 3 ] 31991 8.476% 94.048% ## ( 3, 4 ] 12616 3.343% 97.391% # ( 4, 6 ] 7727 2.047% 99.438% ( 6, 10 ] 1734 0.459% 99.898% ( 10, 15 ] 322 0.085% 99.983% ( 15, 22 ] 45 0.012% 99.995% ( 22, 34 ] 13 0.003% 99.998% ( 34, 51 ] 5 0.001% 100.000% ( 51, 76 ] 1 0.000% 100.000% ( 76, 110 ] 1 0.000% 100.000% ( 110, 170 ] 10 0.003% 100.003% ( 170, 250 ] 16 0.004% 100.007% ( 250, 380 ] 11 0.003% 100.010% ( 380, 580 ] 3 0.001% 100.011% ( 580, 870 ] 5 0.001% 100.012% ( 870, 1300 ] 6 0.002% 100.014% ( 1300, 1900 ] 1 0.000% 100.014% ( 1900, 2900 ] 5 0.001% 100.015% ( 2900, 4400 ] 1 0.000% 100.016% ** Level 1 read latency histogram (micros): Count: 91495 Average: 2.4138 StdDev: 7.74 Min: 1 Median: 1.5945 Max: 1554 Percentiles: P50: 1.59 P75: 1.98 P99: 5.93 P99.9: 18.75 P99.99: 181.34 ------------------------------------------------------ [ 0, 1 ] 10467 11.440% 11.440% ## ( 1, 2 ] 59340 64.856% 76.296% ############# ( 2, 3 ] 13989 15.289% 91.585% ### ( 3, 4 ] 3986 4.357% 95.942% # ( 4, 6 ] 2903 3.173% 99.115% # ( 6, 10 ] 586 0.640% 99.755% ( 10, 15 ] 125 0.137% 99.892% ( 15, 22 ] 14 0.015% 99.907% ( 22, 34 ] 2 0.002% 99.909% ( 34, 51 ] 45 0.049% 99.958% ( 51, 76 ] 18 0.020% 99.978% ( 76, 110 ] 5 0.005% 99.984% ( 110, 170 ] 5 0.005% 99.989% ( 170, 250 ] 6 0.007% 99.996% ( 250, 380 ] 5 0.005% 100.001% ( 380, 580 ] 4 0.004% 100.005% ( 580, 870 ] 3 0.003% 100.009% ( 1300, 1900 ] 1 0.001% 100.010% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47927 Average: 3.6606 StdDev: 55.24 Min: 0 Median: 1.6156 Max: 5161 Percentiles: P50: 1.62 P75: 1.99 P99: 6.12 P99.9: 32.87 P99.99: 2072.47 ------------------------------------------------------ [ 0, 1 ] 4430 9.243% 9.243% ## ( 1, 2 ] 31733 66.211% 75.454% ############# ( 2, 3 ] 7414 15.469% 90.924% ### ( 3, 4 ] 2260 4.716% 95.639% # ( 4, 6 ] 1601 3.340% 98.980% # ( 6, 10 ] 320 0.668% 99.647% ( 10, 15 ] 71 0.148% 99.796% ( 15, 22 ] 22 0.046% 99.841% ( 22, 34 ] 31 0.065% 99.906% ( 110, 170 ] 5 0.010% 99.917% ( 170, 250 ] 3 0.006% 99.923% ( 250, 380 ] 3 0.006% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 15 0.031% 99.975% ( 870, 1300 ] 4 0.008% 99.983% ( 1300, 1900 ] 2 0.004% 99.987% ( 1900, 2900 ] 7 0.015% 100.002% ( 2900, 4400 ] 5 0.010% 100.013% ( 4400, 6600 ] 1 0.002% 100.015% ** Level 4 read latency histogram (micros): Count: 35 Average: 1792.2857 StdDev: 1523.56 Min: 307 Median: 1350.0000 Max: 6861 Percentiles: P50: 1350.00 P75: 2364.29 P99: 6861.00 P99.9: 6861.00 P99.99: 6861.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 4 11.429% 17.143% ## ( 580, 870 ] 5 14.286% 31.429% ### ( 870, 1300 ] 6 17.143% 48.571% ### ( 1300, 1900 ] 6 17.143% 65.714% ### ( 1900, 2900 ] 7 20.000% 85.714% #### ( 2900, 4400 ] 3 8.571% 94.286% ## ( 4400, 6600 ] 1 2.857% 97.143% # ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 6.0 total, 3.0 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 326.41 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.619 H:M:S, 10.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.87 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.389 H:M:S, 12.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-00:37:07 ... thread 0: (1000000,3000000) ops and (326487.1,336283.8) ops/second in (3.062908,8.921037) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/10 2.21 GB 94.4 1.6 0.0 1.6 4.3 2.7 0.0 1.6 116.7 314.2 14.03 13.07 45 0.312 1663K 1697 0.0 0.0 L1 1/1 2.33 MB 0.0 0.3 0.3 0.0 0.3 0.3 0.2 1.0 240.3 240.0 1.31 1.27 1 1.311 319K 415 0.0 0.0 L2 1/0 49.47 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 32/0 971.26 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 203.2 203.0 3.38 2.97 3 1.127 697K 601 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1236/11 98.84 GB 0.0 2.9 1.0 1.9 5.6 3.7 0.8 2.1 148.3 285.7 20.15 18.69 51 0.395 3034K 2877 0.0 0.0 Int 0/0 0.00 KB 0.0 2.9 1.0 1.9 5.6 3.7 0.7 2.1 148.3 285.7 20.15 18.69 51 0.395 3034K 2877 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 2.9 1.0 1.9 2.9 1.0 0.0 0.0 244.0 243.7 12.25 11.63 12 1.021 3034K 2877 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 350.8 7.90 7.06 39 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): 9.1 total, 8.9 interval Flush(GB): cumulative 2.707, interval 2.707 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: 5.62 GB write, 633.13 MB/s write, 2.92 GB read, 328.64 MB/s read, 20.2 seconds Interval compaction: 5.62 GB write, 645.25 MB/s write, 2.92 GB read, 334.93 MB/s read, 20.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 780108 Average: 2.1372 StdDev: 10.02 Min: 1 Median: 1.4736 Max: 4197 Percentiles: P50: 1.47 P75: 1.85 P99: 5.43 P99.9: 9.77 P99.99: 14.14 ------------------------------------------------------ [ 0, 1 ] 145957 18.710% 18.710% #### ( 1, 2 ] 515413 66.069% 84.779% ############# ( 2, 3 ] 74810 9.590% 94.369% ## ( 3, 4 ] 25843 3.313% 97.682% # ( 4, 6 ] 14432 1.850% 99.532% ( 6, 10 ] 3050 0.391% 99.923% ( 10, 15 ] 636 0.082% 100.004% ( 15, 22 ] 58 0.007% 100.012% ( 22, 34 ] 15 0.002% 100.014% ( 34, 51 ] 5 0.001% 100.014% ( 51, 76 ] 4 0.001% 100.015% ( 76, 110 ] 1 0.000% 100.015% ( 110, 170 ] 14 0.002% 100.017% ( 170, 250 ] 24 0.003% 100.020% ( 250, 380 ] 15 0.002% 100.022% ( 380, 580 ] 6 0.001% 100.022% ( 580, 870 ] 11 0.001% 100.024% ( 870, 1300 ] 9 0.001% 100.025% ( 1300, 1900 ] 5 0.001% 100.026% ( 1900, 2900 ] 5 0.001% 100.026% ( 2900, 4400 ] 1 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 91495 Average: 2.4138 StdDev: 7.74 Min: 1 Median: 1.5945 Max: 1554 Percentiles: P50: 1.59 P75: 1.98 P99: 5.93 P99.9: 18.75 P99.99: 181.34 ------------------------------------------------------ [ 0, 1 ] 10467 11.440% 11.440% ## ( 1, 2 ] 59340 64.856% 76.296% ############# ( 2, 3 ] 13989 15.289% 91.585% ### ( 3, 4 ] 3986 4.357% 95.942% # ( 4, 6 ] 2903 3.173% 99.115% # ( 6, 10 ] 586 0.640% 99.755% ( 10, 15 ] 125 0.137% 99.892% ( 15, 22 ] 14 0.015% 99.907% ( 22, 34 ] 2 0.002% 99.909% ( 34, 51 ] 45 0.049% 99.958% ( 51, 76 ] 18 0.020% 99.978% ( 76, 110 ] 5 0.005% 99.984% ( 110, 170 ] 5 0.005% 99.989% ( 170, 250 ] 6 0.007% 99.996% ( 250, 380 ] 5 0.005% 100.001% ( 380, 580 ] 4 0.004% 100.005% ( 580, 870 ] 3 0.003% 100.009% ( 1300, 1900 ] 1 0.001% 100.010% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47927 Average: 3.6606 StdDev: 55.24 Min: 0 Median: 1.6156 Max: 5161 Percentiles: P50: 1.62 P75: 1.99 P99: 6.12 P99.9: 32.87 P99.99: 2072.47 ------------------------------------------------------ [ 0, 1 ] 4430 9.243% 9.243% ## ( 1, 2 ] 31733 66.211% 75.454% ############# ( 2, 3 ] 7414 15.469% 90.924% ### ( 3, 4 ] 2260 4.716% 95.639% # ( 4, 6 ] 1601 3.340% 98.980% # ( 6, 10 ] 320 0.668% 99.647% ( 10, 15 ] 71 0.148% 99.796% ( 15, 22 ] 22 0.046% 99.841% ( 22, 34 ] 31 0.065% 99.906% ( 110, 170 ] 5 0.010% 99.917% ( 170, 250 ] 3 0.006% 99.923% ( 250, 380 ] 3 0.006% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 15 0.031% 99.975% ( 870, 1300 ] 4 0.008% 99.983% ( 1300, 1900 ] 2 0.004% 99.987% ( 1900, 2900 ] 7 0.015% 100.002% ( 2900, 4400 ] 5 0.010% 100.013% ( 4400, 6600 ] 1 0.002% 100.015% ** Level 4 read latency histogram (micros): Count: 35 Average: 1792.2857 StdDev: 1523.56 Min: 307 Median: 1350.0000 Max: 6861 Percentiles: P50: 1350.00 P75: 2364.29 P99: 6861.00 P99.9: 6861.00 P99.99: 6861.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 4 11.429% 17.143% ## ( 580, 870 ] 5 14.286% 31.429% ### ( 870, 1300 ] 6 17.143% 48.571% ### ( 1300, 1900 ] 6 17.143% 65.714% ### ( 1900, 2900 ] 7 20.000% 85.714% #### ( 2900, 4400 ] 3 8.571% 94.286% ## ( 4400, 6600 ] 1 2.857% 97.143% # ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 9.1 total, 3.1 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 324.70 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.049 H:M:S, 11.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 321.33 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.430 H:M:S, 14.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-00:37:10 ... thread 0: (1000000,4000000) ops and (336350.6,336300.5) ops/second in (2.973088,11.894125) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 13/10 2.15 GB 18.9 2.4 0.0 2.4 6.1 3.7 0.0 1.6 123.6 313.7 19.87 18.56 62 0.321 2494K 2588 0.0 0.0 L1 10/10 1.04 GB 0.0 1.4 1.4 0.0 1.3 1.3 0.2 1.0 238.4 237.5 5.82 5.67 2 2.909 1408K 4975 0.0 0.0 L2 1/0 49.47 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 32/0 971.26 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 203.2 203.0 3.38 2.97 3 1.127 697K 601 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1244/20 99.82 GB 0.0 4.8 2.0 2.7 8.4 5.7 0.8 2.3 160.0 283.6 30.50 28.58 69 0.442 4954K 8328 0.0 0.0 Int 0/0 0.00 KB 0.0 4.8 2.0 2.7 8.4 5.7 0.7 2.3 160.0 283.6 30.50 28.58 69 0.442 4954K 8328 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.8 2.0 2.7 4.8 2.0 0.0 0.0 246.4 246.0 19.80 19.02 16 1.238 4954K 8328 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 353.2 10.70 9.56 53 0.202 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.1 total, 11.9 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: 8.45 GB write, 716.93 MB/s write, 4.77 GB read, 404.41 MB/s read, 30.5 seconds Interval compaction: 8.45 GB write, 727.22 MB/s write, 4.77 GB read, 410.21 MB/s read, 30.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 11, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 11, interval: 11 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1041020 Average: 2.1030 StdDev: 10.36 Min: 1 Median: 1.4522 Max: 4197 Percentiles: P50: 1.45 P75: 1.83 P99: 5.30 P99.9: 9.78 P99.99: 14.33 ------------------------------------------------------ [ 0, 1 ] 210816 20.251% 20.251% #### ( 1, 2 ] 684883 65.790% 86.041% ############# ( 2, 3 ] 92426 8.878% 94.919% ## ( 3, 4 ] 31521 3.028% 97.947% # ( 4, 6 ] 16928 1.626% 99.573% ( 6, 10 ] 3601 0.346% 99.919% ( 10, 15 ] 856 0.082% 100.001% ( 15, 22 ] 75 0.007% 100.008% ( 22, 34 ] 16 0.002% 100.010% ( 34, 51 ] 6 0.001% 100.010% ( 51, 76 ] 4 0.000% 100.011% ( 76, 110 ] 1 0.000% 100.011% ( 110, 170 ] 19 0.002% 100.013% ( 170, 250 ] 33 0.003% 100.016% ( 250, 380 ] 22 0.002% 100.018% ( 380, 580 ] 6 0.001% 100.019% ( 580, 870 ] 15 0.001% 100.020% ( 870, 1300 ] 13 0.001% 100.021% ( 1300, 1900 ] 6 0.001% 100.022% ( 1900, 2900 ] 8 0.001% 100.023% ( 2900, 4400 ] 2 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 101703 Average: 2.5647 StdDev: 16.34 Min: 0 Median: 1.5621 Max: 3263 Percentiles: P50: 1.56 P75: 1.95 P99: 5.94 P99.9: 67.18 P99.99: 378.42 ------------------------------------------------------ [ 0, 1 ] 14189 13.951% 13.951% ### ( 1, 2 ] 65225 64.133% 78.084% ############# ( 2, 3 ] 14271 14.032% 92.116% ### ( 3, 4 ] 4146 4.077% 96.193% # ( 4, 6 ] 2937 2.888% 99.081% # ( 6, 10 ] 621 0.611% 99.691% ( 10, 15 ] 136 0.134% 99.825% ( 15, 22 ] 16 0.016% 99.841% ( 22, 34 ] 3 0.003% 99.844% ( 34, 51 ] 45 0.044% 99.888% ( 51, 76 ] 19 0.019% 99.907% ( 76, 110 ] 26 0.026% 99.932% ( 110, 170 ] 32 0.031% 99.964% ( 170, 250 ] 13 0.013% 99.976% ( 250, 380 ] 14 0.014% 99.990% ( 380, 580 ] 6 0.006% 99.996% ( 580, 870 ] 5 0.005% 100.001% ( 870, 1300 ] 5 0.005% 100.006% ( 1300, 1900 ] 2 0.002% 100.008% ( 2900, 4400 ] 1 0.001% 100.009% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47927 Average: 3.6606 StdDev: 55.24 Min: 0 Median: 1.6156 Max: 5161 Percentiles: P50: 1.62 P75: 1.99 P99: 6.12 P99.9: 32.87 P99.99: 2072.47 ------------------------------------------------------ [ 0, 1 ] 4430 9.243% 9.243% ## ( 1, 2 ] 31733 66.211% 75.454% ############# ( 2, 3 ] 7414 15.469% 90.924% ### ( 3, 4 ] 2260 4.716% 95.639% # ( 4, 6 ] 1601 3.340% 98.980% # ( 6, 10 ] 320 0.668% 99.647% ( 10, 15 ] 71 0.148% 99.796% ( 15, 22 ] 22 0.046% 99.841% ( 22, 34 ] 31 0.065% 99.906% ( 110, 170 ] 5 0.010% 99.917% ( 170, 250 ] 3 0.006% 99.923% ( 250, 380 ] 3 0.006% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 15 0.031% 99.975% ( 870, 1300 ] 4 0.008% 99.983% ( 1300, 1900 ] 2 0.004% 99.987% ( 1900, 2900 ] 7 0.015% 100.002% ( 2900, 4400 ] 5 0.010% 100.013% ( 4400, 6600 ] 1 0.002% 100.015% ** Level 4 read latency histogram (micros): Count: 35 Average: 1792.2857 StdDev: 1523.56 Min: 307 Median: 1350.0000 Max: 6861 Percentiles: P50: 1350.00 P75: 2364.29 P99: 6861.00 P99.9: 6861.00 P99.99: 6861.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 4 11.429% 17.143% ## ( 580, 870 ] 5 14.286% 31.429% ### ( 870, 1300 ] 6 17.143% 48.571% ### ( 1300, 1900 ] 6 17.143% 65.714% ### ( 1900, 2900 ] 7 20.000% 85.714% #### ( 2900, 4400 ] 3 8.571% 94.286% ## ( 4400, 6600 ] 1 2.857% 97.143% # ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 12.1 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 326.26 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.438 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, 331.03 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.389 H:M:S, 13.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-00:37:14 ... thread 0: (1000000,5000000) ops and (275022.9,321953.6) ops/second in (3.636061,15.530186) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/14 3.20 GB 100.7 3.2 0.0 3.2 7.9 4.7 0.0 1.7 126.6 314.0 25.87 24.20 80 0.323 3326K 3471 0.0 0.0 L1 10/10 1.04 GB 0.0 1.4 1.4 0.0 1.3 1.3 0.2 1.0 238.4 237.5 5.82 5.67 2 2.909 1408K 4975 0.0 0.0 L2 1/0 49.47 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 32/0 971.26 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 203.2 203.0 3.38 2.97 3 1.127 697K 601 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1250/24 100.86 GB 0.0 5.6 2.0 3.5 10.3 6.8 0.8 2.2 156.1 288.8 36.50 34.23 87 0.420 5786K 9211 0.0 0.0 Int 0/0 0.00 KB 0.0 5.6 2.0 3.5 10.3 6.8 0.7 2.2 156.1 288.8 36.50 34.23 87 0.420 5786K 9211 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.6 2.0 3.5 5.6 2.0 0.0 0.0 249.3 248.9 22.86 22.03 19 1.203 5786K 9211 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 355.6 13.64 12.20 68 0.201 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 15.7 total, 15.5 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: 10.29 GB write, 671.21 MB/s write, 5.57 GB read, 362.92 MB/s read, 36.5 seconds Interval compaction: 10.29 GB write, 678.59 MB/s write, 5.57 GB read, 366.91 MB/s read, 36.5 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 2, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 2, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 2, total-stops: 14, interval: 16 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1428866 Average: 2.1538 StdDev: 11.24 Min: 0 Median: 1.4679 Max: 4197 Percentiles: P50: 1.47 P75: 1.84 P99: 5.34 P99.9: 9.95 P99.99: 14.98 ------------------------------------------------------ [ 0, 1 ] 269848 18.885% 18.885% #### ( 1, 2 ] 950099 66.493% 85.379% ############# ( 2, 3 ] 134790 9.433% 94.812% ## ( 3, 4 ] 44201 3.093% 97.905% # ( 4, 6 ] 23324 1.632% 99.538% ( 6, 10 ] 5246 0.367% 99.905% ( 10, 15 ] 1220 0.085% 99.990% ( 15, 22 ] 93 0.007% 99.997% ( 22, 34 ] 24 0.002% 99.999% ( 34, 51 ] 11 0.001% 99.999% ( 51, 76 ] 5 0.000% 100.000% ( 76, 110 ] 28 0.002% 100.002% ( 110, 170 ] 122 0.009% 100.010% ( 170, 250 ] 72 0.005% 100.015% ( 250, 380 ] 53 0.004% 100.019% ( 380, 580 ] 26 0.002% 100.021% ( 580, 870 ] 25 0.002% 100.022% ( 870, 1300 ] 19 0.001% 100.024% ( 1300, 1900 ] 7 0.000% 100.024% ( 1900, 2900 ] 8 0.001% 100.025% ( 2900, 4400 ] 6 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 173068 Average: 2.5480 StdDev: 13.93 Min: 0 Median: 1.5564 Max: 3263 Percentiles: P50: 1.56 P75: 1.94 P99: 7.19 P99.9: 95.40 P99.99: 469.24 ------------------------------------------------------ [ 0, 1 ] 23180 13.394% 13.394% ### ( 1, 2 ] 113871 65.796% 79.189% ############# ( 2, 3 ] 23046 13.316% 92.505% ### ( 3, 4 ] 6357 3.673% 96.178% # ( 4, 6 ] 4381 2.531% 98.710% # ( 6, 10 ] 1689 0.976% 99.686% ( 10, 15 ] 227 0.131% 99.817% ( 15, 22 ] 27 0.016% 99.832% ( 22, 34 ] 3 0.002% 99.834% ( 34, 51 ] 45 0.026% 99.860% ( 51, 76 ] 25 0.014% 99.875% ( 76, 110 ] 77 0.044% 99.919% ( 110, 170 ] 73 0.042% 99.961% ( 170, 250 ] 25 0.014% 99.976% ( 250, 380 ] 18 0.010% 99.986% ( 380, 580 ] 15 0.009% 99.995% ( 580, 870 ] 9 0.005% 100.000% ( 870, 1300 ] 6 0.003% 100.003% ( 1300, 1900 ] 2 0.001% 100.005% ( 2900, 4400 ] 1 0.001% 100.005% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47927 Average: 3.6606 StdDev: 55.24 Min: 0 Median: 1.6156 Max: 5161 Percentiles: P50: 1.62 P75: 1.99 P99: 6.12 P99.9: 32.87 P99.99: 2072.47 ------------------------------------------------------ [ 0, 1 ] 4430 9.243% 9.243% ## ( 1, 2 ] 31733 66.211% 75.454% ############# ( 2, 3 ] 7414 15.469% 90.924% ### ( 3, 4 ] 2260 4.716% 95.639% # ( 4, 6 ] 1601 3.340% 98.980% # ( 6, 10 ] 320 0.668% 99.647% ( 10, 15 ] 71 0.148% 99.796% ( 15, 22 ] 22 0.046% 99.841% ( 22, 34 ] 31 0.065% 99.906% ( 110, 170 ] 5 0.010% 99.917% ( 170, 250 ] 3 0.006% 99.923% ( 250, 380 ] 3 0.006% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 15 0.031% 99.975% ( 870, 1300 ] 4 0.008% 99.983% ( 1300, 1900 ] 2 0.004% 99.987% ( 1900, 2900 ] 7 0.015% 100.002% ( 2900, 4400 ] 5 0.010% 100.013% ( 4400, 6600 ] 1 0.002% 100.015% ** Level 4 read latency histogram (micros): Count: 35 Average: 1792.2857 StdDev: 1523.56 Min: 307 Median: 1350.0000 Max: 6861 Percentiles: P50: 1350.00 P75: 2364.29 P99: 6861.00 P99.9: 6861.00 P99.99: 6861.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 4 11.429% 17.143% ## ( 580, 870 ] 5 14.286% 31.429% ### ( 870, 1300 ] 6 17.143% 48.571% ### ( 1300, 1900 ] 6 17.143% 65.714% ### ( 1900, 2900 ] 7 20.000% 85.714% #### ( 2900, 4400 ] 3 8.571% 94.286% ## ( 4400, 6600 ] 1 2.857% 97.143% # ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 15.7 total, 3.6 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 313.38 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.412 H:M:S, 15.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 270.67 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.974 H:M:S, 26.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-00:37:22 ... thread 0: (1000000,6000000) ops and (132439.5,259956.3) ops/second in (7.550616,23.080802) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/10 4.12 GB 220.1 5.0 0.0 5.0 10.6 5.7 0.0 1.9 144.4 308.2 35.33 33.27 100 0.353 5180K 6866 0.0 0.0 L1 10/10 1.04 GB 0.0 1.4 1.4 0.0 1.3 1.3 0.2 1.0 238.4 237.5 5.82 5.67 2 2.909 1408K 4975 0.0 0.0 L2 1/0 49.47 MB 0.5 0.3 0.2 0.2 0.3 0.2 0.4 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 32/0 971.26 MB 1.0 0.7 0.5 0.2 0.7 0.5 0.0 1.4 203.2 203.0 3.38 2.97 3 1.127 697K 601 0.0 0.0 L4 144/0 9.75 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.88 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 1250/20 101.78 GB 0.0 7.3 2.0 5.3 13.0 7.7 0.8 2.3 163.7 289.5 45.96 43.30 107 0.430 7640K 12K 0.0 0.0 Int 0/0 0.00 KB 0.0 7.3 2.0 5.3 13.0 7.7 0.7 2.3 163.7 289.5 45.96 43.30 107 0.430 7640K 12K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 7.3 2.0 5.3 7.3 2.0 0.0 0.0 254.1 253.6 29.62 28.70 24 1.234 7640K 12K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 5.7 5.7 0.0 0.0 0.0 354.6 16.35 14.60 83 0.197 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.3 total, 23.1 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 13.00 GB write, 572.29 MB/s write, 7.35 GB read, 323.61 MB/s read, 46.0 seconds Interval compaction: 13.00 GB write, 576.53 MB/s write, 7.35 GB read, 326.01 MB/s read, 46.0 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: 14, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 14, interval: 25 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2129880 Average: 2.1761 StdDev: 11.04 Min: 0 Median: 1.4675 Max: 4197 Percentiles: P50: 1.47 P75: 1.84 P99: 5.42 P99.9: 10.82 P99.99: 113.10 ------------------------------------------------------ [ 0, 1 ] 397528 18.664% 18.664% #### ( 1, 2 ] 1427535 67.024% 85.689% ############# ( 2, 3 ] 196547 9.228% 94.917% ## ( 3, 4 ] 63531 2.983% 97.899% # ( 4, 6 ] 32922 1.546% 99.445% ( 6, 10 ] 9398 0.441% 99.886% ( 10, 15 ] 1763 0.083% 99.969% ( 15, 22 ] 152 0.007% 99.976% ( 22, 34 ] 32 0.002% 99.978% ( 34, 51 ] 15 0.001% 99.979% ( 51, 76 ] 8 0.000% 99.979% ( 76, 110 ] 220 0.010% 99.989% ( 110, 170 ] 310 0.015% 100.004% ( 170, 250 ] 134 0.006% 100.010% ( 250, 380 ] 87 0.004% 100.014% ( 380, 580 ] 63 0.003% 100.017% ( 580, 870 ] 44 0.002% 100.019% ( 870, 1300 ] 27 0.001% 100.020% ( 1300, 1900 ] 9 0.000% 100.021% ( 1900, 2900 ] 13 0.001% 100.022% ( 2900, 4400 ] 7 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 322778 Average: 2.4951 StdDev: 11.77 Min: 0 Median: 1.5286 Max: 3263 Percentiles: P50: 1.53 P75: 1.90 P99: 7.48 P99.9: 103.28 P99.99: 444.61 ------------------------------------------------------ [ 0, 1 ] 47373 14.677% 14.677% ### ( 1, 2 ] 215674 66.818% 81.495% ############# ( 2, 3 ] 37833 11.721% 93.216% ## ( 3, 4 ] 10307 3.193% 96.409% # ( 4, 6 ] 7066 2.189% 98.598% ( 6, 10 ] 3511 1.088% 99.686% ( 10, 15 ] 352 0.109% 99.795% ( 15, 22 ] 49 0.015% 99.810% ( 22, 34 ] 5 0.002% 99.812% ( 34, 51 ] 45 0.014% 99.826% ( 51, 76 ] 34 0.011% 99.836% ( 76, 110 ] 257 0.080% 99.916% ( 110, 170 ] 138 0.043% 99.958% ( 170, 250 ] 50 0.015% 99.974% ( 250, 380 ] 43 0.013% 99.987% ( 380, 580 ] 27 0.008% 99.996% ( 580, 870 ] 13 0.004% 100.000% ( 870, 1300 ] 7 0.002% 100.002% ( 1300, 1900 ] 2 0.001% 100.002% ( 2900, 4400 ] 1 0.000% 100.003% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 47927 Average: 3.6606 StdDev: 55.24 Min: 0 Median: 1.6156 Max: 5161 Percentiles: P50: 1.62 P75: 1.99 P99: 6.12 P99.9: 32.87 P99.99: 2072.47 ------------------------------------------------------ [ 0, 1 ] 4430 9.243% 9.243% ## ( 1, 2 ] 31733 66.211% 75.454% ############# ( 2, 3 ] 7414 15.469% 90.924% ### ( 3, 4 ] 2260 4.716% 95.639% # ( 4, 6 ] 1601 3.340% 98.980% # ( 6, 10 ] 320 0.668% 99.647% ( 10, 15 ] 71 0.148% 99.796% ( 15, 22 ] 22 0.046% 99.841% ( 22, 34 ] 31 0.065% 99.906% ( 110, 170 ] 5 0.010% 99.917% ( 170, 250 ] 3 0.006% 99.923% ( 250, 380 ] 3 0.006% 99.929% ( 380, 580 ] 7 0.015% 99.944% ( 580, 870 ] 15 0.031% 99.975% ( 870, 1300 ] 4 0.008% 99.983% ( 1300, 1900 ] 2 0.004% 99.987% ( 1900, 2900 ] 7 0.015% 100.002% ( 2900, 4400 ] 5 0.010% 100.013% ( 4400, 6600 ] 1 0.002% 100.015% ** Level 4 read latency histogram (micros): Count: 35 Average: 1792.2857 StdDev: 1523.56 Min: 307 Median: 1350.0000 Max: 6861 Percentiles: P50: 1350.00 P75: 2364.29 P99: 6861.00 P99.9: 6861.00 P99.99: 6861.00 ------------------------------------------------------ ( 250, 380 ] 2 5.714% 5.714% # ( 380, 580 ] 4 11.429% 17.143% ## ( 580, 870 ] 5 14.286% 31.429% ### ( 870, 1300 ] 6 17.143% 48.571% ### ( 1300, 1900 ] 6 17.143% 65.714% ### ( 1900, 2900 ] 7 20.000% 85.714% #### ( 2900, 4400 ] 3 8.571% 94.286% ## ( 4400, 6600 ] 1 2.857% 97.143% # ( 6600, 9900 ] 1 2.857% 100.000% # ** DB Stats ** Uptime(secs): 23.3 total, 7.6 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 253.95 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.086 H:M:S, 30.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 130.35 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:4.673 H:M:S, 61.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/29-00:37:26 ... thread 0: (1000000,7000000) ops and (207441.3,250883.1) ops/second in (4.820641,27.901443) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/16 3.07 GB 25.2 5.5 0.0 5.5 12.0 6.6 0.0 1.8 140.5 309.3 39.89 37.50 116 0.344 5692K 7319 0.0 0.0 L1 17/17 1.96 GB 0.0 4.4 3.3 1.0 4.3 3.3 0.2 1.3 229.0 226.6 19.52 18.82 3 6.506 4538K 45K 0.0 0.0 L2 1/0 49.47 MB 0.5 0.3 0.2 0.2 0.3 0.2 1.4 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 14/0 951.06 MB 1.0 0.7 0.5 0.2 0.7 0.5 1.0 1.4 203.2 203.0 3.38 2.97 3 1.127 697K 601 0.0 0.0 L4 167/0 9.48 GB 1.0 0.3 0.2 0.0 0.3 0.2 1.0 1.1 187.8 187.3 1.38 1.19 2 0.690 263K 667 0.0 0.0 L5 1060/0 87.17 GB 0.9 0.0 0.0 0.0 0.0 0.0 1.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1276/33 102.67 GB 0.0 11.1 4.2 6.9 17.6 10.8 4.9 2.7 173.3 275.2 65.60 61.85 126 0.521 11M 53K 0.0 0.0 Int 0/0 0.00 KB 0.0 11.1 4.2 6.9 17.6 10.8 4.8 2.7 173.3 275.2 65.60 61.85 126 0.521 11M 53K 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 11.1 4.2 6.9 11.1 4.2 0.0 0.0 244.1 243.0 46.57 44.87 29 1.606 11M 53K 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 354.2 19.03 16.98 97 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 28.1 total, 27.9 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 17.63 GB write, 643.16 MB/s write, 11.10 GB read, 405.00 MB/s read, 65.6 seconds Interval compaction: 17.63 GB write, 647.10 MB/s write, 11.10 GB read, 407.47 MB/s read, 65.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 17, pending-compaction-bytes-delays: 3, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 17, interval: 33 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2546504 Average: 2.2485 StdDev: 12.61 Min: 0 Median: 1.4697 Max: 4197 Percentiles: P50: 1.47 P75: 1.84 P99: 5.53 P99.9: 12.44 P99.99: 164.98 ------------------------------------------------------ [ 0, 1 ] 471921 18.532% 18.532% #### ( 1, 2 ] 1705929 66.991% 85.523% ############# ( 2, 3 ] 236490 9.287% 94.810% ## ( 3, 4 ] 75824 2.978% 97.788% # ( 4, 6 ] 40368 1.585% 99.373% ( 6, 10 ] 12413 0.487% 99.860% ( 10, 15 ] 2085 0.082% 99.942% ( 15, 22 ] 190 0.007% 99.950% ( 22, 34 ] 32 0.001% 99.951% ( 34, 51 ] 18 0.001% 99.952% ( 51, 76 ] 18 0.001% 99.952% ( 76, 110 ] 422 0.017% 99.969% ( 110, 170 ] 593 0.023% 99.992% ( 170, 250 ] 265 0.010% 100.003% ( 250, 380 ] 183 0.007% 100.010% ( 380, 580 ] 146 0.006% 100.015% ( 580, 870 ] 86 0.003% 100.019% ( 870, 1300 ] 40 0.002% 100.020% ( 1300, 1900 ] 13 0.001% 100.021% ( 1900, 2900 ] 18 0.001% 100.022% ( 2900, 4400 ] 10 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 396051 Average: 2.5547 StdDev: 14.11 Min: 0 Median: 1.5210 Max: 3263 Percentiles: P50: 1.52 P75: 1.90 P99: 7.28 P99.9: 106.37 P99.99: 651.48 ------------------------------------------------------ [ 0, 1 ] 61642 15.564% 15.564% ### ( 1, 2 ] 261766 66.094% 81.658% ############# ( 2, 3 ] 45812 11.567% 93.225% ## ( 3, 4 ] 12756 3.221% 96.446% # ( 4, 6 ] 8854 2.236% 98.682% ( 6, 10 ] 3954 0.998% 99.680% ( 10, 15 ] 415 0.105% 99.785% ( 15, 22 ] 61 0.015% 99.800% ( 22, 34 ] 6 0.002% 99.802% ( 34, 51 ] 46 0.012% 99.813% ( 51, 76 ] 50 0.013% 99.826% ( 76, 110 ] 328 0.083% 99.909% ( 110, 170 ] 158 0.040% 99.949% ( 170, 250 ] 60 0.015% 99.964% ( 250, 380 ] 56 0.014% 99.978% ( 380, 580 ] 40 0.010% 99.988% ( 580, 870 ] 30 0.008% 99.996% ( 870, 1300 ] 20 0.005% 100.001% ( 1300, 1900 ] 5 0.001% 100.002% ( 2900, 4400 ] 1 0.000% 100.002% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 81026 Average: 3.9050 StdDev: 46.91 Min: 0 Median: 1.6580 Max: 5161 Percentiles: P50: 1.66 P75: 2.17 P99: 8.76 P99.9: 293.25 P99.99: 1181.47 ------------------------------------------------------ [ 0, 1 ] 6226 7.684% 7.684% ## ( 1, 2 ] 52106 64.308% 71.992% ############# ( 2, 3 ] 14332 17.688% 89.680% #### ( 3, 4 ] 3924 4.843% 94.523% # ( 4, 6 ] 2985 3.684% 98.207% # ( 6, 10 ] 930 1.148% 99.355% ( 10, 15 ] 156 0.193% 99.547% ( 15, 22 ] 38 0.047% 99.594% ( 22, 34 ] 32 0.039% 99.633% ( 51, 76 ] 2 0.002% 99.636% ( 76, 110 ] 51 0.063% 99.699% ( 110, 170 ] 96 0.118% 99.817% ( 170, 250 ] 54 0.067% 99.884% ( 250, 380 ] 39 0.048% 99.932% ( 380, 580 ] 21 0.026% 99.958% ( 580, 870 ] 23 0.028% 99.986% ( 870, 1300 ] 4 0.005% 99.991% ( 1300, 1900 ] 3 0.004% 99.995% ( 1900, 2900 ] 8 0.010% 100.005% ( 2900, 4400 ] 6 0.007% 100.012% ( 4400, 6600 ] 1 0.001% 100.014% ** Level 4 read latency histogram (micros): Count: 125 Average: 520.0640 StdDev: 1133.29 Min: 1 Median: 4.2000 Max: 6861 Percentiles: P50: 4.20 P75: 505.00 P99: 6050.00 P99.9: 6861.00 P99.99: 6861.00 ------------------------------------------------------ [ 0, 1 ] 30 24.000% 24.000% ##### ( 1, 2 ] 21 16.800% 40.800% ### ( 2, 3 ] 8 6.400% 47.200% # ( 3, 4 ] 3 2.400% 49.600% ( 4, 6 ] 5 4.000% 53.600% # ( 6, 10 ] 4 3.200% 56.800% # ( 10, 15 ] 10 8.000% 64.800% ## ( 15, 22 ] 2 1.600% 66.400% ( 110, 170 ] 2 1.600% 68.000% ( 170, 250 ] 2 1.600% 69.600% ( 250, 380 ] 3 2.400% 72.000% ( 380, 580 ] 6 4.800% 76.800% # ( 580, 870 ] 5 4.000% 80.800% # ( 870, 1300 ] 6 4.800% 85.600% # ( 1300, 1900 ] 6 4.800% 90.400% # ( 1900, 2900 ] 7 5.600% 96.000% # ( 2900, 4400 ] 3 2.400% 98.400% ( 4400, 6600 ] 1 0.800% 99.200% ( 6600, 9900 ] 1 0.800% 100.000% ** Level 5 read latency histogram (micros): Count: 80 Average: 834.8875 StdDev: 935.69 Min: 87 Median: 420.0000 Max: 3749 Percentiles: P50: 420.00 P75: 1300.00 P99: 3749.00 P99.9: 3749.00 P99.99: 3749.00 ------------------------------------------------------ ( 76, 110 ] 11 13.750% 13.750% ### ( 110, 170 ] 15 18.750% 32.500% #### ( 170, 250 ] 4 5.000% 37.500% # ( 250, 380 ] 8 10.000% 47.500% ## ( 380, 580 ] 10 12.500% 60.000% ### ( 580, 870 ] 10 12.500% 72.500% ### ( 870, 1300 ] 2 2.500% 75.000% # ( 1300, 1900 ] 7 8.750% 83.750% ## ( 1900, 2900 ] 10 12.500% 96.250% ### ( 2900, 4400 ] 3 3.750% 100.000% # ** DB Stats ** Uptime(secs): 28.1 total, 4.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 245.40 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:9.168 H:M:S, 32.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 204.16 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:2.082 H:M:S, 43.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/29-00:37:48 ... thread 0: (1000000,8000000) ops and (46187.9,161446.1) ops/second in (21.650698,49.552141) 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/7 1.84 GB 18.9 7.4 0.0 7.4 15.1 7.6 0.0 2.0 143.9 291.0 52.98 47.69 133 0.398 7738K 13K 0.0 0.0 L1 8/8 911.58 MB 0.0 8.6 5.6 3.0 8.5 5.5 0.2 1.5 225.5 222.6 39.05 36.98 4 9.763 8470K 45K 0.0 0.0 L2 2/1 193.89 MB 1.0 0.3 0.2 0.2 0.3 0.2 4.6 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 22/7 1.84 GB 1.0 1.8 1.0 0.8 1.8 0.9 3.7 1.8 138.7 137.5 13.12 8.15 8 1.639 1847K 16K 0.0 0.0 L4 169/19 10.02 GB 1.0 2.7 2.4 0.3 2.7 2.4 1.0 1.1 127.1 126.6 21.84 12.76 26 0.840 2796K 10K 0.0 0.0 L5 1080/0 88.83 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1290/42 103.61 GB 0.0 20.9 9.2 11.7 28.3 16.6 12.5 3.7 166.4 226.0 128.41 106.96 173 0.742 21M 86K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.9 9.2 11.7 28.3 16.6 12.4 3.7 166.4 226.0 128.41 106.96 173 0.742 21M 86K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.9 9.2 11.7 20.7 9.0 0.0 0.0 206.1 204.6 103.68 87.08 63 1.646 21M 86K 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 315.8 24.74 19.88 110 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): 49.7 total, 49.6 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: 28.35 GB write, 583.73 MB/s write, 20.87 GB read, 429.81 MB/s read, 128.4 seconds Interval compaction: 28.35 GB write, 585.74 MB/s write, 20.87 GB read, 431.29 MB/s read, 128.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 45, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 45, interval: 71 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3646886 Average: 2.7726 StdDev: 38.24 Min: 0 Median: 1.4829 Max: 10823 Percentiles: P50: 1.48 P75: 1.87 P99: 5.92 P99.9: 109.26 P99.99: 419.77 ------------------------------------------------------ [ 0, 1 ] 671711 18.419% 18.419% #### ( 1, 2 ] 2384877 65.395% 83.814% ############# ( 2, 3 ] 355867 9.758% 93.572% ## ( 3, 4 ] 120644 3.308% 96.880% # ( 4, 6 ] 80651 2.212% 99.091% ( 6, 10 ] 22406 0.614% 99.706% ( 10, 15 ] 3965 0.109% 99.814% ( 15, 22 ] 535 0.015% 99.829% ( 22, 34 ] 51 0.001% 99.831% ( 34, 51 ] 26 0.001% 99.831% ( 51, 76 ] 46 0.001% 99.833% ( 76, 110 ] 2515 0.069% 99.902% ( 110, 170 ] 2135 0.059% 99.960% ( 170, 250 ] 545 0.015% 99.975% ( 250, 380 ] 461 0.013% 99.988% ( 380, 580 ] 434 0.012% 100.000% ( 580, 870 ] 244 0.007% 100.006% ( 870, 1300 ] 145 0.004% 100.010% ( 1300, 1900 ] 86 0.002% 100.013% ( 1900, 2900 ] 88 0.002% 100.015% ( 2900, 4400 ] 121 0.003% 100.018% ( 4400, 6600 ] 39 0.001% 100.019% ( 6600, 9900 ] 19 0.001% 100.020% ( 9900, 14000 ] 3 0.000% 100.020% ** Level 1 read latency histogram (micros): Count: 1709163 Average: 5.3150 StdDev: 91.05 Min: 0 Median: 1.6631 Max: 11407 Percentiles: P50: 1.66 P75: 2.39 P99: 8.87 P99.9: 107.51 P99.99: 245.29 ------------------------------------------------------ [ 0, 1 ] 221823 12.978% 12.978% ### ( 1, 2 ] 954178 55.827% 68.806% ########### ( 2, 3 ] 272466 15.941% 84.747% ### ( 3, 4 ] 113429 6.637% 91.384% # ( 4, 6 ] 109483 6.406% 97.789% # ( 6, 10 ] 28798 1.685% 99.474% ( 10, 15 ] 4732 0.277% 99.751% ( 15, 22 ] 763 0.045% 99.796% ( 22, 34 ] 39 0.002% 99.798% ( 34, 51 ] 59 0.003% 99.801% ( 51, 76 ] 137 0.008% 99.809% ( 76, 110 ] 1669 0.098% 99.907% ( 110, 170 ] 1098 0.064% 99.971% ( 170, 250 ] 338 0.020% 99.991% ( 250, 380 ] 371 0.022% 100.013% ( 380, 580 ] 422 0.025% 100.038% ( 580, 870 ] 514 0.030% 100.068% ( 870, 1300 ] 372 0.022% 100.089% ( 1300, 1900 ] 201 0.012% 100.101% ( 1900, 2900 ] 261 0.015% 100.116% ( 2900, 4400 ] 426 0.025% 100.141% ( 4400, 6600 ] 120 0.007% 100.148% ( 6600, 9900 ] 35 0.002% 100.150% ( 9900, 14000 ] 4 0.000% 100.151% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 422714 Average: 9.4389 StdDev: 123.55 Min: 0 Median: 1.9321 Max: 9467 Percentiles: P50: 1.93 P75: 2.90 P99: 9.26 P99.9: 701.10 P99.99: 969.68 ------------------------------------------------------ [ 0, 1 ] 9617 2.275% 2.275% ( 1, 2 ] 216442 51.203% 53.478% ########## ( 2, 3 ] 101078 23.912% 77.390% ##### ( 3, 4 ] 45876 10.853% 88.242% ## ( 4, 6 ] 40273 9.527% 97.770% ## ( 6, 10 ] 6386 1.511% 99.280% ( 10, 15 ] 1225 0.290% 99.570% ( 15, 22 ] 134 0.032% 99.602% ( 22, 34 ] 44 0.010% 99.612% ( 34, 51 ] 5 0.001% 99.613% ( 51, 76 ] 3 0.001% 99.614% ( 76, 110 ] 68 0.016% 99.630% ( 110, 170 ] 134 0.032% 99.662% ( 170, 250 ] 155 0.037% 99.699% ( 250, 380 ] 238 0.056% 99.755% ( 380, 580 ] 407 0.096% 99.851% ( 580, 870 ] 494 0.117% 99.968% ( 870, 1300 ] 400 0.095% 100.063% ( 1300, 1900 ] 202 0.048% 100.110% ( 1900, 2900 ] 176 0.042% 100.152% ( 2900, 4400 ] 180 0.043% 100.195% ( 4400, 6600 ] 47 0.011% 100.206% ( 6600, 9900 ] 11 0.003% 100.208% ** Level 4 read latency histogram (micros): Count: 50505 Average: 21.1758 StdDev: 197.98 Min: 1 Median: 2.0271 Max: 6861 Percentiles: P50: 2.03 P75: 3.06 P99: 537.18 P99.9: 2843.47 P99.99: 4065.26 ------------------------------------------------------ [ 0, 1 ] 672 1.331% 1.331% ( 1, 2 ] 24239 47.993% 49.324% ########## ( 2, 3 ] 12616 24.980% 74.304% ##### ( 3, 4 ] 5888 11.658% 85.962% ## ( 4, 6 ] 5133 10.163% 96.125% ## ( 6, 10 ] 862 1.707% 97.832% ( 10, 15 ] 199 0.394% 98.226% ( 15, 22 ] 20 0.040% 98.266% ( 22, 34 ] 5 0.010% 98.275% ( 34, 51 ] 2 0.004% 98.279% ( 51, 76 ] 4 0.008% 98.287% ( 76, 110 ] 25 0.050% 98.337% ( 110, 170 ] 30 0.059% 98.396% ( 170, 250 ] 93 0.184% 98.580% ( 250, 380 ] 109 0.216% 98.796% ( 380, 580 ] 131 0.259% 99.056% ( 580, 870 ] 171 0.339% 99.394% ( 870, 1300 ] 133 0.263% 99.657% ( 1300, 1900 ] 64 0.127% 99.784% ( 1900, 2900 ] 62 0.123% 99.907% ( 2900, 4400 ] 54 0.107% 100.014% ( 4400, 6600 ] 17 0.034% 100.048% ( 6600, 9900 ] 1 0.002% 100.050% ** Level 5 read latency histogram (micros): Count: 180 Average: 1596.4556 StdDev: 1648.42 Min: 87 Median: 825.3846 Max: 7873 Percentiles: P50: 825.38 P75: 2490.91 P99: 7873.00 P99.9: 7873.00 P99.99: 7873.00 ------------------------------------------------------ ( 76, 110 ] 11 6.111% 6.111% # ( 110, 170 ] 15 8.333% 14.444% ## ( 170, 250 ] 5 2.778% 17.222% # ( 250, 380 ] 11 6.111% 23.333% # ( 380, 580 ] 26 14.444% 37.778% ### ( 580, 870 ] 26 14.444% 52.222% ### ( 870, 1300 ] 13 7.222% 59.444% # ( 1300, 1900 ] 15 8.333% 67.778% ## ( 1900, 2900 ] 22 12.222% 80.000% ## ( 2900, 4400 ] 20 11.111% 91.111% ## ( 4400, 6600 ] 13 7.222% 98.333% # ( 6600, 9900 ] 3 1.667% 100.000% ** DB Stats ** Uptime(secs): 49.7 total, 21.7 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 158.34 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.195 H:M:S, 54.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 45.46 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:18.027 H:M:S, 83.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 9 num-running-flushes: 1 2024/11/29-00:37:51 ... thread 0: (1000000,9000000) ops and (308316.1,170468.9) ops/second in (3.243425,52.795566) 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/7 2.70 GB 113.3 8.4 0.0 8.4 16.9 8.5 0.0 2.0 143.2 287.2 60.25 53.89 148 0.407 8761K 15K 0.0 0.0 L1 8/8 911.58 MB 0.0 8.6 5.6 3.0 8.5 5.5 0.2 1.5 225.5 222.6 39.05 36.98 4 9.763 8470K 45K 0.0 0.0 L2 1/0 96.72 MB 1.0 0.3 0.2 0.2 0.3 0.2 4.6 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 15/0 893.53 MB 0.9 2.0 1.1 0.9 2.0 1.0 3.7 1.9 137.9 136.6 14.84 9.19 9 1.648 2077K 19K 0.0 0.0 L4 157/0 9.41 GB 1.0 4.3 3.5 0.8 4.3 3.5 1.0 1.2 129.3 128.8 34.17 20.29 35 0.976 4455K 15K 0.0 0.0 L5 1100/0 90.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1293/15 104.46 GB 0.0 23.7 10.3 13.4 32.0 18.7 14.1 3.8 161.9 218.9 149.73 121.73 198 0.756 24M 95K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.7 10.3 13.4 32.0 18.7 14.1 3.8 161.9 218.9 149.73 121.73 198 0.756 24M 95K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 23.7 10.3 13.4 23.5 10.2 0.0 0.0 198.4 197.0 122.22 99.62 76 1.608 24M 95K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 316.0 27.51 22.11 122 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): 53.0 total, 52.8 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 32.00 GB write, 618.73 MB/s write, 23.68 GB read, 457.77 MB/s read, 149.7 seconds Interval compaction: 32.00 GB write, 620.73 MB/s write, 23.68 GB read, 459.25 MB/s read, 149.7 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 54, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 54, interval: 80 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4008888 Average: 2.8010 StdDev: 38.29 Min: 0 Median: 1.5010 Max: 10823 Percentiles: P50: 1.50 P75: 1.89 P99: 5.97 P99.9: 104.91 P99.99: 378.43 ------------------------------------------------------ [ 0, 1 ] 697657 17.403% 17.403% ### ( 1, 2 ] 2608450 65.067% 82.469% ############# ( 2, 3 ] 426468 10.638% 93.107% ## ( 3, 4 ] 140108 3.495% 96.602% # ( 4, 6 ] 97485 2.432% 99.034% ( 6, 10 ] 27131 0.677% 99.711% ( 10, 15 ] 4690 0.117% 99.828% ( 15, 22 ] 610 0.015% 99.843% ( 22, 34 ] 55 0.001% 99.844% ( 34, 51 ] 29 0.001% 99.845% ( 51, 76 ] 47 0.001% 99.846% ( 76, 110 ] 2529 0.063% 99.909% ( 110, 170 ] 2170 0.054% 99.964% ( 170, 250 ] 577 0.014% 99.978% ( 250, 380 ] 488 0.012% 99.990% ( 380, 580 ] 457 0.011% 100.002% ( 580, 870 ] 269 0.007% 100.008% ( 870, 1300 ] 167 0.004% 100.012% ( 1300, 1900 ] 97 0.002% 100.015% ( 1900, 2900 ] 106 0.003% 100.018% ( 2900, 4400 ] 137 0.003% 100.021% ( 4400, 6600 ] 44 0.001% 100.022% ( 6600, 9900 ] 19 0.000% 100.023% ( 9900, 14000 ] 3 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1799147 Average: 5.3174 StdDev: 90.71 Min: 0 Median: 1.6698 Max: 11407 Percentiles: P50: 1.67 P75: 2.40 P99: 8.90 P99.9: 108.51 P99.99: 273.76 ------------------------------------------------------ [ 0, 1 ] 225934 12.558% 12.558% ### ( 1, 2 ] 1005675 55.897% 68.455% ########### ( 2, 3 ] 292059 16.233% 84.688% ### ( 3, 4 ] 119707 6.654% 91.342% # ( 4, 6 ] 115409 6.415% 97.757% # ( 6, 10 ] 30879 1.716% 99.473% ( 10, 15 ] 5038 0.280% 99.753% ( 15, 22 ] 793 0.044% 99.797% ( 22, 34 ] 41 0.002% 99.799% ( 34, 51 ] 61 0.003% 99.803% ( 51, 76 ] 137 0.008% 99.810% ( 76, 110 ] 1689 0.094% 99.904% ( 110, 170 ] 1133 0.063% 99.967% ( 170, 250 ] 343 0.019% 99.986% ( 250, 380 ] 378 0.021% 100.007% ( 380, 580 ] 438 0.024% 100.032% ( 580, 870 ] 546 0.030% 100.062% ( 870, 1300 ] 397 0.022% 100.084% ( 1300, 1900 ] 215 0.012% 100.096% ( 1900, 2900 ] 283 0.016% 100.112% ( 2900, 4400 ] 443 0.025% 100.136% ( 4400, 6600 ] 127 0.007% 100.143% ( 6600, 9900 ] 36 0.002% 100.145% ( 9900, 14000 ] 4 0.000% 100.146% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 476231 Average: 9.1758 StdDev: 121.00 Min: 0 Median: 1.9276 Max: 9467 Percentiles: P50: 1.93 P75: 2.89 P99: 9.21 P99.9: 716.70 P99.99: 1016.36 ------------------------------------------------------ [ 0, 1 ] 10404 2.185% 2.185% ( 1, 2 ] 245490 51.549% 53.733% ########## ( 2, 3 ] 113868 23.910% 77.643% ##### ( 3, 4 ] 51226 10.757% 88.400% ## ( 4, 6 ] 44816 9.411% 97.811% ## ( 6, 10 ] 7061 1.483% 99.293% ( 10, 15 ] 1360 0.286% 99.579% ( 15, 22 ] 146 0.031% 99.609% ( 22, 34 ] 45 0.009% 99.619% ( 34, 51 ] 5 0.001% 99.620% ( 51, 76 ] 3 0.001% 99.621% ( 76, 110 ] 71 0.015% 99.635% ( 110, 170 ] 150 0.031% 99.667% ( 170, 250 ] 169 0.035% 99.702% ( 250, 380 ] 257 0.054% 99.756% ( 380, 580 ] 433 0.091% 99.847% ( 580, 870 ] 532 0.112% 99.959% ( 870, 1300 ] 433 0.091% 100.050% ( 1300, 1900 ] 219 0.046% 100.096% ( 1900, 2900 ] 198 0.042% 100.138% ( 2900, 4400 ] 190 0.040% 100.177% ( 4400, 6600 ] 52 0.011% 100.188% ( 6600, 9900 ] 12 0.003% 100.191% ** Level 4 read latency histogram (micros): Count: 136127 Average: 12.4418 StdDev: 144.40 Min: 1 Median: 1.9638 Max: 6861 Percentiles: P50: 1.96 P75: 2.93 P99: 13.41 P99.9: 1519.15 P99.99: 2643.04 ------------------------------------------------------ [ 0, 1 ] 1379 1.013% 1.013% ( 1, 2 ] 69189 50.827% 51.840% ########## ( 2, 3 ] 33756 24.797% 76.637% ##### ( 3, 4 ] 14365 10.553% 87.190% ## ( 4, 6 ] 13062 9.595% 96.785% ## ( 6, 10 ] 2651 1.947% 98.733% ( 10, 15 ] 533 0.392% 99.124% ( 15, 22 ] 48 0.035% 99.160% ( 22, 34 ] 7 0.005% 99.165% ( 34, 51 ] 4 0.003% 99.168% ( 51, 76 ] 6 0.004% 99.172% ( 76, 110 ] 37 0.027% 99.199% ( 110, 170 ] 62 0.046% 99.245% ( 170, 250 ] 140 0.103% 99.348% ( 250, 380 ] 139 0.102% 99.450% ( 380, 580 ] 172 0.126% 99.576% ( 580, 870 ] 223 0.164% 99.740% ( 870, 1300 ] 185 0.136% 99.876% ( 1300, 1900 ] 90 0.066% 99.942% ( 1900, 2900 ] 88 0.065% 100.007% ( 2900, 4400 ] 84 0.062% 100.068% ( 4400, 6600 ] 23 0.017% 100.085% ( 6600, 9900 ] 1 0.001% 100.086% ** Level 5 read latency histogram (micros): Count: 280 Average: 1483.5321 StdDev: 1569.46 Min: 86 Median: 768.1081 Max: 7873 Percentiles: P50: 768.11 P75: 2357.14 P99: 7590.00 P99.9: 7873.00 P99.99: 7873.00 ------------------------------------------------------ ( 76, 110 ] 13 4.643% 4.643% # ( 110, 170 ] 33 11.786% 16.429% ## ( 170, 250 ] 14 5.000% 21.429% # ( 250, 380 ] 22 7.857% 29.286% ## ( 380, 580 ] 34 12.143% 41.429% ## ( 580, 870 ] 37 13.214% 54.643% ### ( 870, 1300 ] 19 6.786% 61.429% # ( 1300, 1900 ] 22 7.857% 69.286% ## ( 1900, 2900 ] 35 12.500% 81.786% ### ( 2900, 4400 ] 31 11.071% 92.857% ## ( 4400, 6600 ] 16 5.714% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 53.0 total, 3.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 167.23 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:27.734 H:M:S, 52.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 303.44 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.538 H:M:S, 16.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/29-00:37:54 ... thread 0: (1000000,10000000) ops and (329330.6,179108.7) ops/second in (3.036462,55.832028) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/11 3.68 GB 188.7 9.3 0.0 9.3 18.7 9.5 0.0 2.0 143.2 289.0 66.43 59.71 165 0.403 9656K 16K 0.0 0.0 L1 8/8 911.58 MB 0.0 8.6 5.6 3.0 8.5 5.5 0.2 1.5 225.5 222.6 39.05 36.98 4 9.763 8470K 45K 0.0 0.0 L2 1/0 96.72 MB 1.0 0.3 0.2 0.2 0.3 0.2 4.6 1.8 243.7 243.6 1.43 1.38 2 0.714 353K 164 0.0 0.0 L3 15/0 893.53 MB 0.9 2.0 1.1 0.9 2.0 1.0 3.7 1.9 137.9 136.6 14.84 9.19 9 1.648 2077K 19K 0.0 0.0 L4 157/0 9.41 GB 1.0 4.3 3.5 0.8 4.3 3.5 1.0 1.2 129.3 128.8 34.17 20.29 35 0.976 4455K 15K 0.0 0.0 L5 1100/0 90.49 GB 0.9 0.0 0.0 0.0 0.0 0.0 4.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1298/19 105.45 GB 0.0 24.5 10.3 14.2 33.8 19.6 14.1 3.6 161.2 222.3 155.91 127.55 215 0.725 25M 96K 0.0 0.0 Int 0/0 0.00 KB 0.0 24.5 10.3 14.2 33.8 19.6 14.1 3.6 161.2 222.3 155.91 127.55 215 0.725 25M 96K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 24.5 10.3 14.2 24.4 10.2 0.0 0.0 200.1 198.8 125.56 102.90 79 1.589 25M 96K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 9.5 9.5 0.0 0.0 0.0 319.7 30.35 24.65 136 0.223 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 56.0 total, 55.8 interval Flush(GB): cumulative 9.474, interval 9.474 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 33.85 GB write, 618.91 MB/s write, 24.54 GB read, 448.70 MB/s read, 155.9 seconds Interval compaction: 33.85 GB write, 620.80 MB/s write, 24.54 GB read, 450.07 MB/s read, 155.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 13, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 13, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 59, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 26, total-stops: 59, interval: 85 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 4291347 Average: 2.7642 StdDev: 37.06 Min: 0 Median: 1.5042 Max: 10823 Percentiles: P50: 1.50 P75: 1.89 P99: 5.95 P99.9: 100.65 P99.99: 356.85 ------------------------------------------------------ [ 0, 1 ] 733481 17.092% 17.092% ### ( 1, 2 ] 2800659 65.263% 82.355% ############# ( 2, 3 ] 462492 10.777% 93.132% ## ( 3, 4 ] 150682 3.511% 96.644% # ( 4, 6 ] 103820 2.419% 99.063% ( 6, 10 ] 28467 0.663% 99.726% ( 10, 15 ] 4863 0.113% 99.840% ( 15, 22 ] 623 0.015% 99.854% ( 22, 34 ] 56 0.001% 99.855% ( 34, 51 ] 30 0.001% 99.856% ( 51, 76 ] 50 0.001% 99.857% ( 76, 110 ] 2529 0.059% 99.916% ( 110, 170 ] 2174 0.051% 99.967% ( 170, 250 ] 586 0.014% 99.981% ( 250, 380 ] 495 0.012% 99.992% ( 380, 580 ] 460 0.011% 100.003% ( 580, 870 ] 271 0.006% 100.009% ( 870, 1300 ] 175 0.004% 100.013% ( 1300, 1900 ] 98 0.002% 100.015% ( 1900, 2900 ] 106 0.002% 100.018% ( 2900, 4400 ] 137 0.003% 100.021% ( 4400, 6600 ] 44 0.001% 100.022% ( 6600, 9900 ] 19 0.000% 100.023% ( 9900, 14000 ] 3 0.000% 100.023% ** Level 1 read latency histogram (micros): Count: 1936868 Average: 5.1339 StdDev: 87.48 Min: 0 Median: 1.6652 Max: 11407 Percentiles: P50: 1.67 P75: 2.37 P99: 8.86 P99.9: 109.18 P99.99: 283.99 ------------------------------------------------------ [ 0, 1 ] 236399 12.205% 12.205% ## ( 1, 2 ] 1100473 56.817% 69.022% ########### ( 2, 3 ] 313325 16.177% 85.199% ### ( 3, 4 ] 124810 6.444% 91.643% # ( 4, 6 ] 118747 6.131% 97.774% # ( 6, 10 ] 33166 1.712% 99.486% ( 10, 15 ] 5159 0.266% 99.753% ( 15, 22 ] 802 0.041% 99.794% ( 22, 34 ] 42 0.002% 99.796% ( 34, 51 ] 61 0.003% 99.799% ( 51, 76 ] 138 0.007% 99.807% ( 76, 110 ] 1855 0.096% 99.902% ( 110, 170 ] 1223 0.063% 99.966% ( 170, 250 ] 371 0.019% 99.985% ( 250, 380 ] 399 0.021% 100.005% ( 380, 580 ] 457 0.024% 100.029% ( 580, 870 ] 551 0.028% 100.057% ( 870, 1300 ] 401 0.021% 100.078% ( 1300, 1900 ] 215 0.011% 100.089% ( 1900, 2900 ] 283 0.015% 100.104% ( 2900, 4400 ] 443 0.023% 100.127% ( 4400, 6600 ] 127 0.007% 100.133% ( 6600, 9900 ] 36 0.002% 100.135% ( 9900, 14000 ] 4 0.000% 100.135% ** Level 2 read latency histogram (micros): Count: 75832 Average: 2.0772 StdDev: 6.04 Min: 0 Median: 1.4341 Max: 1413 Percentiles: P50: 1.43 P75: 1.83 P99: 5.56 P99.9: 9.88 P99.99: 186.67 ------------------------------------------------------ [ 0, 1 ] 17320 22.840% 22.840% ##### ( 1, 2 ] 47441 62.561% 85.401% ############# ( 2, 3 ] 6562 8.653% 94.054% ## ( 3, 4 ] 2411 3.179% 97.233% # ( 4, 6 ] 1713 2.259% 99.492% ( 6, 10 ] 319 0.421% 99.913% ( 10, 15 ] 45 0.059% 99.972% ( 15, 22 ] 7 0.009% 99.982% ( 22, 34 ] 2 0.003% 99.984% ( 34, 51 ] 1 0.001% 99.985% ( 51, 76 ] 1 0.001% 99.987% ( 110, 170 ] 2 0.003% 99.989% ( 170, 250 ] 2 0.003% 99.992% ( 250, 380 ] 4 0.005% 99.997% ( 380, 580 ] 1 0.001% 99.999% ( 1300, 1900 ] 1 0.001% 100.000% ** Level 3 read latency histogram (micros): Count: 476231 Average: 9.1758 StdDev: 121.00 Min: 0 Median: 1.9276 Max: 9467 Percentiles: P50: 1.93 P75: 2.89 P99: 9.21 P99.9: 716.70 P99.99: 1016.36 ------------------------------------------------------ [ 0, 1 ] 10404 2.185% 2.185% ( 1, 2 ] 245490 51.549% 53.733% ########## ( 2, 3 ] 113868 23.910% 77.643% ##### ( 3, 4 ] 51226 10.757% 88.400% ## ( 4, 6 ] 44816 9.411% 97.811% ## ( 6, 10 ] 7061 1.483% 99.293% ( 10, 15 ] 1360 0.286% 99.579% ( 15, 22 ] 146 0.031% 99.609% ( 22, 34 ] 45 0.009% 99.619% ( 34, 51 ] 5 0.001% 99.620% ( 51, 76 ] 3 0.001% 99.621% ( 76, 110 ] 71 0.015% 99.635% ( 110, 170 ] 150 0.031% 99.667% ( 170, 250 ] 169 0.035% 99.702% ( 250, 380 ] 257 0.054% 99.756% ( 380, 580 ] 433 0.091% 99.847% ( 580, 870 ] 532 0.112% 99.959% ( 870, 1300 ] 433 0.091% 100.050% ( 1300, 1900 ] 219 0.046% 100.096% ( 1900, 2900 ] 198 0.042% 100.138% ( 2900, 4400 ] 190 0.040% 100.177% ( 4400, 6600 ] 52 0.011% 100.188% ( 6600, 9900 ] 12 0.003% 100.191% ** Level 4 read latency histogram (micros): Count: 136127 Average: 12.4418 StdDev: 144.40 Min: 1 Median: 1.9638 Max: 6861 Percentiles: P50: 1.96 P75: 2.93 P99: 13.41 P99.9: 1519.15 P99.99: 2643.04 ------------------------------------------------------ [ 0, 1 ] 1379 1.013% 1.013% ( 1, 2 ] 69189 50.827% 51.840% ########## ( 2, 3 ] 33756 24.797% 76.637% ##### ( 3, 4 ] 14365 10.553% 87.190% ## ( 4, 6 ] 13062 9.595% 96.785% ## ( 6, 10 ] 2651 1.947% 98.733% ( 10, 15 ] 533 0.392% 99.124% ( 15, 22 ] 48 0.035% 99.160% ( 22, 34 ] 7 0.005% 99.165% ( 34, 51 ] 4 0.003% 99.168% ( 51, 76 ] 6 0.004% 99.172% ( 76, 110 ] 37 0.027% 99.199% ( 110, 170 ] 62 0.046% 99.245% ( 170, 250 ] 140 0.103% 99.348% ( 250, 380 ] 139 0.102% 99.450% ( 380, 580 ] 172 0.126% 99.576% ( 580, 870 ] 223 0.164% 99.740% ( 870, 1300 ] 185 0.136% 99.876% ( 1300, 1900 ] 90 0.066% 99.942% ( 1900, 2900 ] 88 0.065% 100.007% ( 2900, 4400 ] 84 0.062% 100.068% ( 4400, 6600 ] 23 0.017% 100.085% ( 6600, 9900 ] 1 0.001% 100.086% ** Level 5 read latency histogram (micros): Count: 280 Average: 1483.5321 StdDev: 1569.46 Min: 86 Median: 768.1081 Max: 7873 Percentiles: P50: 768.11 P75: 2357.14 P99: 7590.00 P99.9: 7873.00 P99.99: 7873.00 ------------------------------------------------------ ( 76, 110 ] 13 4.643% 4.643% # ( 110, 170 ] 33 11.786% 16.429% ## ( 170, 250 ] 14 5.000% 21.429% # ( 250, 380 ] 22 7.857% 29.286% ## ( 380, 580 ] 34 12.143% 41.429% ## ( 580, 870 ] 37 13.214% 54.643% ### ( 870, 1300 ] 19 6.786% 61.429% # ( 1300, 1900 ] 22 7.857% 69.286% ## ( 1900, 2900 ] 35 12.500% 81.786% ### ( 2900, 4400 ] 31 11.071% 92.857% ## ( 4400, 6600 ] 16 5.714% 98.571% # ( 6600, 9900 ] 4 1.429% 100.000% ** DB Stats ** Uptime(secs): 56.0 total, 3.0 interval Cumulative writes: 0 writes, 10M keys, 0 commit groups, 0.0 writes per commit group, ingest: 9.61 GB, 175.73 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:28.152 H:M:S, 50.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.13 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.418 H:M:S, 13.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 5.630 micros/op 177608 ops/sec 60.070 seconds 10668999 operations; 172.1 MB/s Microseconds per write: Count: 10668999 Average: 5.6304 StdDev: 504.28 Min: 0 Median: 1.7378 Max: 897370 Percentiles: P50: 1.74 P75: 2.74 P99: 9.44 P99.9: 1111.19 P99.99: 2686.69 ------------------------------------------------------ [ 0, 1 ] 1438201 13.480% 13.480% ### ( 1, 2 ] 5281244 49.501% 62.981% ########## ( 2, 3 ] 1722505 16.145% 79.126% ### ( 3, 4 ] 1446843 13.561% 92.687% ### ( 4, 6 ] 560218 5.251% 97.938% # ( 6, 10 ] 131855 1.236% 99.174% ( 10, 15 ] 46941 0.440% 99.614% ( 15, 22 ] 10048 0.094% 99.708% ( 22, 34 ] 1809 0.017% 99.725% ( 34, 51 ] 246 0.002% 99.727% ( 51, 76 ] 30 0.000% 99.728% ( 76, 110 ] 7586 0.071% 99.799% ( 110, 170 ] 2714 0.025% 99.824% ( 170, 250 ] 291 0.003% 99.827% ( 250, 380 ] 200 0.002% 99.829% ( 380, 580 ] 17 0.000% 99.829% ( 580, 870 ] 21 0.000% 99.829% ( 870, 1300 ] 13480 0.126% 99.955% ( 1300, 1900 ] 36 0.000% 99.956% ( 1900, 2900 ] 4636 0.043% 99.999% ( 2900, 4400 ] 39 0.000% 100.000% ( 4400, 6600 ] 6 0.000% 100.000% ( 6600, 9900 ] 5 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 33000, 50000 ] 1 0.000% 100.000% ( 75000, 110000 ] 2 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 570000, 860000 ] 2 0.000% 100.000% ( 860000, 1200000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 193072 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 : 10668999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 11010406968 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 : 545 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 30561413 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 : 30068219571 rocksdb.compact.write.bytes COUNT : 29867147491 rocksdb.flush.write.bytes COUNT : 10965254994 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 : 67 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 326 rocksdb.error.handler.bg.errro.count COUNT : 0 rocksdb.error.handler.bg.io.errro.count COUNT : 0 rocksdb.error.handler.bg.retryable.io.errro.count COUNT : 0 rocksdb.error.handler.autoresume.count COUNT : 0 rocksdb.error.handler.autoresume.retry.total.count COUNT : 0 rocksdb.error.handler.autoresume.success.count COUNT : 0 rocksdb.memtable.payload.bytes.at.flush COUNT : 10876981248 rocksdb.memtable.garbage.bytes.at.flush COUNT : 4353024 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 : 30170725831 rocksdb.non.last.level.read.count COUNT : 7283557 rocksdb.block.checksum.compute.count COUNT : 7282534 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.375412 P95 : 3.920074 P99 : 7.969057 P100 : 897362.000000 COUNT : 10668999 SUM : 55028798 rocksdb.compaction.times.micros P50 : 1105555.555556 P95 : 5235000.000000 P99 : 15360000.000000 P100 : 19533877.000000 COUNT : 83 SUM : 141031409 rocksdb.compaction.times.cpu_micros P50 : 932250.000000 P95 : 4195000.000000 P99 : 15360000.000000 P100 : 18164313.000000 COUNT : 83 SUM : 115756045 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 : 656.867470 P95 : 3950.000000 P99 : 213200.000000 P100 : 333321.000000 COUNT : 146 SUM : 799036 rocksdb.compaction.outfile.sync.micros P50 : 1045.909091 P95 : 172666.666667 P99 : 267479.000000 P100 : 267479.000000 COUNT : 332 SUM : 7696392 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 : 99.880952 P95 : 1750.000000 P99 : 5426.666667 P100 : 6706.000000 COUNT : 260 SUM : 90756 rocksdb.table.open.io.micros P50 : 1701.351351 P95 : 8446.428571 P99 : 14880.000000 P100 : 24238.000000 COUNT : 545 SUM : 1304599 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.627685 P95 : 7.238228 P99 : 9.972126 P100 : 11414.000000 COUNT : 7280832 SUM : 44201775 rocksdb.read.block.get.micros P50 : 516.936937 P95 : 3637.068966 P99 : 6032.631579 P100 : 8039.000000 COUNT : 1090 SUM : 1033905 rocksdb.write.raw.block.micros P50 : 0.512033 P95 : 0.972863 P99 : 2.807254 P100 : 15573.000000 COUNT : 9888978 SUM : 19845407 rocksdb.numfiles.in.singlecompaction P50 : 3.283951 P95 : 5.533333 P99 : 29.920000 P100 : 41.000000 COUNT : 134 SUM : 548 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.561767 P95 : 1184.395639 P99 : 2548.145423 P100 : 897149.000000 COUNT : 165792 SUM : 30580370 rocksdb.sst.read.micros P50 : 1.569077 P95 : 4.228849 P99 : 7.834216 P100 : 11407.000000 COUNT : 7283557 SUM : 29425649 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 : 10668999 SUM : 11010406968 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 : 210000.000000 P95 : 377833.333333 P99 : 951800.000000 P100 : 1045572.000000 COUNT : 146 SUM : 32494588 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 : 328 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