[2024-12-06 09:47:03.225994] Starting SPDK v25.01-pre git sha1 a5e6ecf28 / DPDK 22.11.4 initialization... [2024-12-06 09:47:03.226275] [ 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_pid193806 ] Set seed to 1733474823219312 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-12-06 09:47:03.327105] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-12-06 09:47:03.350365] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-12-06 09:47:03.350408] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 193806' to capture a snapshot of events at runtime. [2024-12-06 09:47:03.350419] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-12-06 09:47:03.350430] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-12-06 09:47:03.350439] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid193806 for offline analysis/debug. [2024-12-06 09:47:03.351007] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Fri Dec 6 09:47:07 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/12/06-09:47:15 ... thread 0: (1000000,1000000) ops and (126775.2,126775.2) ops/second in (7.887975,7.887975) 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 7/4 881.28 MB 25.2 0.4 0.0 0.4 1.2 0.9 0.0 1.4 39.3 131.1 9.60 4.12 11 0.873 383K 534 0.0 0.0 L1 2/2 200.80 MB 0.0 0.6 0.4 0.2 0.6 0.4 0.0 1.6 109.9 109.6 5.93 3.02 1 5.935 662K 1536 0.0 0.0 L2 5/3 497.58 MB 1.8 0.0 0.0 0.0 0.0 0.0 0.4 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 34/20 2.77 GB 1.3 2.4 1.7 0.7 2.3 1.6 0.1 1.4 101.1 100.3 23.82 11.29 14 1.702 1469K 100 0.0 0.0 L4 190/16 12.42 GB 1.2 3.5 2.6 0.9 3.5 2.6 0.0 1.3 105.3 104.9 33.92 16.72 26 1.305 1481K 142 0.0 0.0 L5 1080/0 88.83 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 1318/45 105.56 GB 0.0 6.8 4.7 2.2 7.7 5.5 0.6 8.9 95.7 107.2 73.29 35.14 52 1.409 3997K 2312 0.0 0.0 Int 0/0 0.00 KB 0.0 6.8 4.7 2.2 7.7 5.5 0.6 8.9 95.7 107.2 73.29 35.14 52 1.409 3997K 2312 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 6.8 4.7 2.2 6.8 4.6 0.0 0.0 106.2 105.7 66.03 32.54 42 1.572 3997K 2312 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 0.9 0.9 0.0 0.0 0.0 121.6 7.25 2.60 10 0.725 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): 8.1 total, 7.9 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.67 GB write, 970.46 MB/s write, 6.85 GB read, 865.92 MB/s read, 73.3 seconds Interval compaction: 7.67 GB write, 996.05 MB/s write, 6.85 GB read, 888.76 MB/s read, 73.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 27, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 27, interval: 27 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 236101 Average: 11.3122 StdDev: 155.03 Min: 1 Median: 1.8777 Max: 34666 Percentiles: P50: 1.88 P75: 2.88 P99: 10.71 P99.9: 2228.47 P99.99: 4287.69 ------------------------------------------------------ [ 0, 1 ] 9465 4.009% 4.009% # ( 1, 2 ] 123717 52.400% 56.409% ########## ( 2, 3 ] 49906 21.138% 77.546% #### ( 3, 4 ] 23332 9.882% 87.429% ## ( 4, 6 ] 22051 9.340% 96.768% ## ( 6, 10 ] 5147 2.180% 98.948% ( 10, 15 ] 874 0.370% 99.319% ( 15, 22 ] 99 0.042% 99.360% ( 22, 34 ] 17 0.007% 99.368% ( 34, 51 ] 9 0.004% 99.371% ( 51, 76 ] 11 0.005% 99.376% ( 76, 110 ] 4 0.002% 99.378% ( 110, 170 ] 28 0.012% 99.390% ( 170, 250 ] 56 0.024% 99.413% ( 250, 380 ] 104 0.044% 99.457% ( 380, 580 ] 209 0.089% 99.546% ( 580, 870 ] 286 0.121% 99.667% ( 870, 1300 ] 282 0.119% 99.787% ( 1300, 1900 ] 218 0.092% 99.879% ( 1900, 2900 ] 158 0.067% 99.946% ( 2900, 4400 ] 115 0.049% 99.994% ( 4400, 6600 ] 30 0.013% 100.007% ( 6600, 9900 ] 4 0.002% 100.009% ( 33000, 50000 ] 1 0.000% 100.009% ** Level 1 read latency histogram (micros): Count: 127590 Average: 15.2770 StdDev: 174.86 Min: 1 Median: 2.0076 Max: 8269 Percentiles: P50: 2.01 P75: 3.08 P99: 13.50 P99.9: 3230.35 P99.99: 5518.94 ------------------------------------------------------ [ 0, 1 ] 2184 1.712% 1.712% ( 1, 2 ] 61376 48.104% 49.816% ########## ( 2, 3 ] 30970 24.273% 74.089% ##### ( 3, 4 ] 13932 10.919% 85.008% ## ( 4, 6 ] 13915 10.906% 95.914% ## ( 6, 10 ] 3488 2.734% 98.648% # ( 10, 15 ] 642 0.503% 99.151% ( 15, 22 ] 84 0.066% 99.217% ( 22, 34 ] 13 0.010% 99.227% ( 34, 51 ] 8 0.006% 99.233% ( 51, 76 ] 9 0.007% 99.241% ( 76, 110 ] 4 0.003% 99.244% ( 110, 170 ] 9 0.007% 99.251% ( 170, 250 ] 13 0.010% 99.261% ( 250, 380 ] 38 0.030% 99.291% ( 380, 580 ] 89 0.070% 99.360% ( 580, 870 ] 168 0.132% 99.492% ( 870, 1300 ] 206 0.161% 99.654% ( 1300, 1900 ] 155 0.121% 99.775% ( 1900, 2900 ] 131 0.103% 99.878% ( 2900, 4400 ] 129 0.101% 99.979% ( 4400, 6600 ] 28 0.022% 100.001% ( 6600, 9900 ] 3 0.002% 100.003% ** Level 2 read latency histogram (micros): Count: 316184 Average: 13.6182 StdDev: 157.00 Min: 1 Median: 1.9959 Max: 7388 Percentiles: P50: 2.00 P75: 3.08 P99: 13.22 P99.9: 1543.16 P99.99: 2152.81 ------------------------------------------------------ [ 0, 1 ] 9068 2.868% 2.868% # ( 1, 2 ] 149645 47.328% 50.196% ######### ( 2, 3 ] 75770 23.964% 74.160% ##### ( 3, 4 ] 34363 10.868% 85.028% ## ( 4, 6 ] 33226 10.508% 95.537% ## ( 6, 10 ] 9662 3.056% 98.593% # ( 10, 15 ] 1999 0.632% 99.225% ( 15, 22 ] 303 0.096% 99.321% ( 22, 34 ] 70 0.022% 99.343% ( 34, 51 ] 36 0.011% 99.354% ( 51, 76 ] 25 0.008% 99.362% ( 76, 110 ] 24 0.008% 99.370% ( 110, 170 ] 51 0.016% 99.386% ( 170, 250 ] 86 0.027% 99.413% ( 250, 380 ] 199 0.063% 99.476% ( 380, 580 ] 319 0.101% 99.577% ( 580, 870 ] 425 0.134% 99.711% ( 870, 1300 ] 457 0.145% 99.856% ( 1300, 1900 ] 345 0.109% 99.965% ( 1900, 2900 ] 314 0.099% 100.064% ( 2900, 4400 ] 206 0.065% 100.129% ( 4400, 6600 ] 54 0.017% 100.146% ( 6600, 9900 ] 8 0.003% 100.149% ** Level 3 read latency histogram (micros): Count: 928971 Average: 12.9600 StdDev: 162.05 Min: 1 Median: 1.9796 Max: 26526 Percentiles: P50: 1.98 P75: 2.99 P99: 9.90 P99.9: 1069.93 P99.99: 1413.63 ------------------------------------------------------ [ 0, 1 ] 17227 1.854% 1.854% ( 1, 2 ] 456592 49.150% 51.005% ########## ( 2, 3 ] 224511 24.168% 75.172% ##### ( 3, 4 ] 101083 10.881% 86.054% ## ( 4, 6 ] 97702 10.517% 96.571% ## ( 6, 10 ] 23121 2.489% 99.060% ( 10, 15 ] 4225 0.455% 99.515% ( 15, 22 ] 555 0.060% 99.574% ( 22, 34 ] 53 0.006% 99.580% ( 34, 51 ] 43 0.005% 99.585% ( 51, 76 ] 62 0.007% 99.591% ( 76, 110 ] 26 0.003% 99.594% ( 110, 170 ] 54 0.006% 99.600% ( 170, 250 ] 141 0.015% 99.615% ( 250, 380 ] 296 0.032% 99.647% ( 380, 580 ] 661 0.071% 99.718% ( 580, 870 ] 1122 0.121% 99.839% ( 870, 1300 ] 1226 0.132% 99.971% ( 1300, 1900 ] 951 0.102% 100.073% ( 1900, 2900 ] 802 0.086% 100.160% ( 2900, 4400 ] 655 0.071% 100.230% ( 4400, 6600 ] 155 0.017% 100.247% ( 6600, 9900 ] 21 0.002% 100.249% ( 9900, 14000 ] 1 0.000% 100.249% ( 14000, 22000 ] 2 0.000% 100.249% ( 22000, 33000 ] 2 0.000% 100.250% ** Level 4 read latency histogram (micros): Count: 276386 Average: 30.8259 StdDev: 284.06 Min: 1 Median: 1.9450 Max: 22093 Percentiles: P50: 1.94 P75: 2.96 P99: 888.70 P99.9: 3279.55 P99.99: 3980.91 ------------------------------------------------------ [ 0, 1 ] 5850 2.117% 2.117% ( 1, 2 ] 140049 50.672% 52.788% ########## ( 2, 3 ] 64015 23.161% 75.950% ##### ( 3, 4 ] 28662 10.370% 86.320% ## ( 4, 6 ] 25020 9.053% 95.372% ## ( 6, 10 ] 6598 2.387% 97.760% ( 10, 15 ] 1141 0.413% 98.172% ( 15, 22 ] 122 0.044% 98.217% ( 22, 34 ] 20 0.007% 98.224% ( 34, 51 ] 29 0.010% 98.234% ( 51, 76 ] 22 0.008% 98.242% ( 76, 110 ] 14 0.005% 98.247% ( 110, 170 ] 40 0.014% 98.262% ( 170, 250 ] 139 0.050% 98.312% ( 250, 380 ] 270 0.098% 98.410% ( 380, 580 ] 601 0.217% 98.627% ( 580, 870 ] 984 0.356% 98.983% ( 870, 1300 ] 1061 0.384% 99.367% ( 1300, 1900 ] 776 0.281% 99.648% ( 1900, 2900 ] 562 0.203% 99.851% ( 2900, 4400 ] 532 0.192% 100.044% ( 4400, 6600 ] 117 0.042% 100.086% ( 6600, 9900 ] 25 0.009% 100.095% ( 9900, 14000 ] 6 0.002% 100.097% ( 14000, 22000 ] 10 0.004% 100.101% ( 22000, 33000 ] 1 0.000% 100.101% ** Level 5 read latency histogram (micros): Count: 14403 Average: 1582.8623 StdDev: 1412.72 Min: 79 Median: 1107.0646 Max: 35806 Percentiles: P50: 1107.06 P75: 2124.74 P99: 6389.45 P99.9: 9602.07 P99.99: 35806.00 ------------------------------------------------------ ( 76, 110 ] 17 0.118% 0.118% ( 110, 170 ] 96 0.667% 0.785% ( 170, 250 ] 297 2.062% 2.847% ( 250, 380 ] 769 5.339% 8.186% # ( 380, 580 ] 1734 12.039% 20.225% ## ( 580, 870 ] 2693 18.697% 38.922% #### ( 870, 1300 ] 2894 20.093% 59.015% #### ( 1300, 1900 ] 1933 13.421% 72.436% ### ( 1900, 2900 ] 1643 11.407% 83.844% ## ( 2900, 4400 ] 1663 11.546% 95.390% ## ( 4400, 6600 ] 575 3.992% 99.382% # ( 6600, 9900 ] 82 0.569% 99.951% ( 9900, 14000 ] 4 0.028% 99.979% ( 14000, 22000 ] 1 0.007% 99.986% ( 33000, 50000 ] 2 0.014% 100.000% ** DB Stats ** Uptime(secs): 8.1 total, 7.9 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 121.53 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:3.932 H:M:S, 48.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 124.72 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:3.932 H:M:S, 49.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/06-09:47:22 ... thread 0: (1000000,2000000) ops and (150169.5,137484.3) ops/second in (6.659141,14.547116) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 8/5 1.17 GB 25.2 1.0 0.0 1.0 2.8 1.8 0.0 1.6 53.7 145.2 19.95 9.71 24 0.831 1087K 1433 0.0 0.0 L1 3/3 146.65 MB 0.0 1.4 1.0 0.4 1.4 1.0 0.0 1.4 119.4 119.1 12.41 6.81 2 6.207 1505K 4044 0.0 0.0 L2 1/0 128.77 MB 1.3 0.0 0.0 0.0 0.0 0.0 1.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 31/8 1.78 GB 1.2 5.1 2.7 2.4 5.0 2.7 0.1 1.9 114.1 113.4 45.39 24.33 25 1.816 3628K 5997 0.0 0.0 L4 166/20 9.74 GB 0.9 7.3 4.3 3.0 7.2 4.2 0.4 1.7 115.8 114.5 64.56 34.54 43 1.501 3030K 142 0.0 0.0 L5 1136/0 93.44 GB 1.0 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 1345/36 106.40 GB 0.0 14.8 8.0 6.8 16.5 9.7 6.2 9.3 106.8 118.8 142.31 75.39 94 1.514 9250K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 14.8 8.0 6.8 16.5 9.7 6.2 9.3 106.8 118.8 142.31 75.39 94 1.514 9250K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 14.8 8.0 6.8 14.7 7.9 0.0 0.0 118.2 117.3 128.64 70.05 73 1.762 9250K 11K 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 133.6 13.68 5.34 21 0.651 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): 14.8 total, 14.5 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: 16.52 GB write, 1146.08 MB/s write, 14.85 GB read, 1030.42 MB/s read, 142.3 seconds Interval compaction: 16.52 GB write, 1162.47 MB/s write, 14.85 GB read, 1045.16 MB/s read, 142.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 57, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 57, interval: 57 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 597500 Average: 10.1513 StdDev: 138.15 Min: 1 Median: 1.8851 Max: 34666 Percentiles: P50: 1.89 P75: 2.87 P99: 9.88 P99.9: 1759.29 P99.99: 3826.56 ------------------------------------------------------ [ 0, 1 ] 21661 3.625% 3.625% # ( 1, 2 ] 313062 52.395% 56.021% ########## ( 2, 3 ] 130501 21.841% 77.862% #### ( 3, 4 ] 58377 9.770% 87.632% ## ( 4, 6 ] 55700 9.322% 96.954% ## ( 6, 10 ] 12607 2.110% 99.064% ( 10, 15 ] 1929 0.323% 99.387% ( 15, 22 ] 215 0.036% 99.423% ( 22, 34 ] 25 0.004% 99.427% ( 34, 51 ] 13 0.002% 99.429% ( 51, 76 ] 21 0.004% 99.433% ( 76, 110 ] 7 0.001% 99.434% ( 110, 170 ] 51 0.009% 99.443% ( 170, 250 ] 120 0.020% 99.463% ( 250, 380 ] 251 0.042% 99.505% ( 380, 580 ] 570 0.095% 99.600% ( 580, 870 ] 766 0.128% 99.728% ( 870, 1300 ] 705 0.118% 99.846% ( 1300, 1900 ] 420 0.070% 99.916% ( 1900, 2900 ] 291 0.049% 99.965% ( 2900, 4400 ] 240 0.040% 100.005% ( 4400, 6600 ] 66 0.011% 100.016% ( 6600, 9900 ] 12 0.002% 100.018% ( 22000, 33000 ] 1 0.000% 100.019% ( 33000, 50000 ] 1 0.000% 100.019% ** Level 1 read latency histogram (micros): Count: 371824 Average: 11.4389 StdDev: 147.23 Min: 1 Median: 1.9849 Max: 19883 Percentiles: P50: 1.98 P75: 2.98 P99: 10.67 P99.9: 1775.57 P99.99: 3189.54 ------------------------------------------------------ [ 0, 1 ] 5654 1.521% 1.521% ( 1, 2 ] 183015 49.221% 50.741% ########## ( 2, 3 ] 92215 24.801% 75.542% ##### ( 3, 4 ] 39197 10.542% 86.084% ## ( 4, 6 ] 38624 10.388% 96.472% ## ( 6, 10 ] 9185 2.470% 98.942% ( 10, 15 ] 1617 0.435% 99.377% ( 15, 22 ] 204 0.055% 99.432% ( 22, 34 ] 21 0.006% 99.437% ( 34, 51 ] 28 0.008% 99.445% ( 51, 76 ] 44 0.012% 99.457% ( 76, 110 ] 9 0.002% 99.459% ( 110, 170 ] 28 0.008% 99.467% ( 170, 250 ] 67 0.018% 99.485% ( 250, 380 ] 169 0.045% 99.530% ( 380, 580 ] 281 0.076% 99.606% ( 580, 870 ] 442 0.119% 99.725% ( 870, 1300 ] 435 0.117% 99.842% ( 1300, 1900 ] 274 0.074% 99.915% ( 1900, 2900 ] 234 0.063% 99.978% ( 2900, 4400 ] 227 0.061% 100.039% ( 4400, 6600 ] 58 0.016% 100.055% ( 6600, 9900 ] 8 0.002% 100.057% ( 14000, 22000 ] 1 0.000% 100.057% ** Level 2 read latency histogram (micros): Count: 377996 Average: 12.7478 StdDev: 151.87 Min: 1 Median: 1.9911 Max: 7388 Percentiles: P50: 1.99 P75: 3.06 P99: 12.54 P99.9: 1562.61 P99.99: 2298.84 ------------------------------------------------------ [ 0, 1 ] 10019 2.651% 2.651% # ( 1, 2 ] 180584 47.774% 50.425% ########## ( 2, 3 ] 90252 23.876% 74.301% ##### ( 3, 4 ] 41023 10.853% 85.154% ## ( 4, 6 ] 39775 10.523% 95.676% ## ( 6, 10 ] 11418 3.021% 98.697% # ( 10, 15 ] 2257 0.597% 99.294% ( 15, 22 ] 336 0.089% 99.383% ( 22, 34 ] 73 0.019% 99.402% ( 34, 51 ] 41 0.011% 99.413% ( 51, 76 ] 31 0.008% 99.421% ( 76, 110 ] 25 0.007% 99.428% ( 110, 170 ] 53 0.014% 99.442% ( 170, 250 ] 92 0.024% 99.466% ( 250, 380 ] 205 0.054% 99.521% ( 380, 580 ] 331 0.088% 99.608% ( 580, 870 ] 456 0.121% 99.729% ( 870, 1300 ] 489 0.129% 99.858% ( 1300, 1900 ] 361 0.096% 99.954% ( 1900, 2900 ] 344 0.091% 100.045% ( 2900, 4400 ] 241 0.064% 100.108% ( 4400, 6600 ] 61 0.016% 100.125% ( 6600, 9900 ] 8 0.002% 100.127% ** Level 3 read latency histogram (micros): Count: 1663051 Average: 11.5173 StdDev: 149.32 Min: 1 Median: 1.9707 Max: 26526 Percentiles: P50: 1.97 P75: 2.98 P99: 9.78 P99.9: 998.37 P99.99: 1381.04 ------------------------------------------------------ [ 0, 1 ] 29086 1.749% 1.749% ( 1, 2 ] 826622 49.705% 51.454% ########## ( 2, 3 ] 399748 24.037% 75.491% ##### ( 3, 4 ] 178936 10.760% 86.251% ## ( 4, 6 ] 172974 10.401% 96.652% ## ( 6, 10 ] 41311 2.484% 99.136% ( 10, 15 ] 7029 0.423% 99.558% ( 15, 22 ] 883 0.053% 99.611% ( 22, 34 ] 81 0.005% 99.616% ( 34, 51 ] 92 0.006% 99.622% ( 51, 76 ] 145 0.009% 99.631% ( 76, 110 ] 41 0.002% 99.633% ( 110, 170 ] 87 0.005% 99.638% ( 170, 250 ] 251 0.015% 99.653% ( 250, 380 ] 521 0.031% 99.685% ( 380, 580 ] 1153 0.069% 99.754% ( 580, 870 ] 1869 0.112% 99.866% ( 870, 1300 ] 1879 0.113% 99.979% ( 1300, 1900 ] 1323 0.080% 100.059% ( 1900, 2900 ] 1143 0.069% 100.128% ( 2900, 4400 ] 1036 0.062% 100.190% ( 4400, 6600 ] 258 0.016% 100.205% ( 6600, 9900 ] 36 0.002% 100.208% ( 9900, 14000 ] 3 0.000% 100.208% ( 14000, 22000 ] 2 0.000% 100.208% ( 22000, 33000 ] 2 0.000% 100.208% ** Level 4 read latency histogram (micros): Count: 788330 Average: 21.8014 StdDev: 221.87 Min: 1 Median: 1.9482 Max: 22093 Percentiles: P50: 1.95 P75: 2.97 P99: 515.60 P99.9: 2491.71 P99.99: 3368.91 ------------------------------------------------------ [ 0, 1 ] 15622 1.982% 1.982% ( 1, 2 ] 399232 50.643% 52.624% ########## ( 2, 3 ] 182037 23.091% 75.716% ##### ( 3, 4 ] 81613 10.353% 86.069% ## ( 4, 6 ] 76371 9.688% 95.756% ## ( 6, 10 ] 19860 2.519% 98.275% # ( 10, 15 ] 2943 0.373% 98.649% ( 15, 22 ] 322 0.041% 98.690% ( 22, 34 ] 31 0.004% 98.694% ( 34, 51 ] 78 0.010% 98.703% ( 51, 76 ] 85 0.011% 98.714% ( 76, 110 ] 29 0.004% 98.718% ( 110, 170 ] 103 0.013% 98.731% ( 170, 250 ] 351 0.045% 98.776% ( 250, 380 ] 713 0.090% 98.866% ( 380, 580 ] 1560 0.198% 99.064% ( 580, 870 ] 2367 0.300% 99.364% ( 870, 1300 ] 2245 0.285% 99.649% ( 1300, 1900 ] 1386 0.176% 99.825% ( 1900, 2900 ] 1005 0.127% 99.952% ( 2900, 4400 ] 957 0.121% 100.074% ( 4400, 6600 ] 239 0.030% 100.104% ( 6600, 9900 ] 40 0.005% 100.109% ( 9900, 14000 ] 8 0.001% 100.110% ( 14000, 22000 ] 12 0.002% 100.112% ( 22000, 33000 ] 1 0.000% 100.112% ** Level 5 read latency histogram (micros): Count: 31560 Average: 1361.5587 StdDev: 1270.70 Min: 79 Median: 932.1140 Max: 35806 Percentiles: P50: 932.11 P75: 1675.80 P99: 6151.88 P99.9: 9441.54 P99.99: 21750.40 ------------------------------------------------------ ( 76, 110 ] 43 0.136% 0.136% ( 110, 170 ] 263 0.833% 0.970% ( 170, 250 ] 736 2.332% 3.302% ( 250, 380 ] 2099 6.651% 9.952% # ( 380, 580 ] 4710 14.924% 24.876% ### ( 580, 870 ] 6984 22.129% 47.006% #### ( 870, 1300 ] 6542 20.729% 67.734% #### ( 1300, 1900 ] 3661 11.600% 79.335% ## ( 1900, 2900 ] 2713 8.596% 87.931% ## ( 2900, 4400 ] 2760 8.745% 96.676% ## ( 4400, 6600 ] 921 2.918% 99.594% # ( 6600, 9900 ] 112 0.355% 99.949% ( 9900, 14000 ] 8 0.025% 99.975% ( 14000, 22000 ] 5 0.016% 99.990% ( 22000, 33000 ] 1 0.003% 99.994% ( 33000, 50000 ] 2 0.006% 100.000% ** DB Stats ** Uptime(secs): 14.8 total, 6.7 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 133.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:6.694 H:M:S, 45.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 147.80 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.762 H:M:S, 41.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/12/06-09:47:26 ... thread 0: (1000000,3000000) ops and (212173.9,155761.4) ops/second in (4.713114,19.260230) 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/9 2.15 GB 100.7 1.9 0.0 1.9 4.7 2.8 0.0 1.7 68.6 168.1 28.46 16.11 42 0.678 1982K 2411 0.0 0.0 L1 3/3 146.65 MB 0.0 1.4 1.0 0.4 1.4 1.0 0.0 1.4 119.4 119.1 12.41 6.81 2 6.207 1505K 4044 0.0 0.0 L3 21/1 1022.52 MB 0.9 5.2 2.8 2.4 5.2 2.8 0.1 1.8 115.3 114.7 46.08 24.95 26 1.772 3766K 6082 0.0 0.0 L4 167/6 9.93 GB 1.0 9.9 5.2 4.7 9.7 5.1 0.4 1.9 121.5 119.8 83.31 46.82 55 1.515 4824K 5472 0.0 0.0 L5 1144/0 94.11 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1349/19 107.33 GB 0.0 18.4 9.1 9.4 21.0 11.6 5.8 7.6 110.8 126.4 170.26 94.69 125 1.362 12M 18K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.4 9.1 9.4 21.0 11.6 5.8 7.6 110.8 126.4 170.26 94.69 125 1.362 12M 18K 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 18.4 9.1 9.4 18.3 8.9 0.0 0.0 124.3 123.1 151.85 86.46 89 1.706 12M 18K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 154.0 18.41 8.23 36 0.511 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 19.5 total, 19.3 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 21.02 GB write, 1105.75 MB/s write, 18.43 GB read, 969.25 MB/s read, 170.3 seconds Interval compaction: 21.02 GB write, 1117.70 MB/s write, 18.43 GB read, 979.72 MB/s read, 170.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 63, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 63, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1036984 Average: 8.7196 StdDev: 117.36 Min: 0 Median: 1.8369 Max: 34666 Percentiles: P50: 1.84 P75: 2.77 P99: 9.93 P99.9: 1209.09 P99.99: 2562.92 ------------------------------------------------------ [ 0, 1 ] 47293 4.561% 4.561% # ( 1, 2 ] 563059 54.298% 58.858% ########### ( 2, 3 ] 217107 20.936% 79.795% #### ( 3, 4 ] 93893 9.054% 88.849% ## ( 4, 6 ] 86757 8.366% 97.215% ## ( 6, 10 ] 18852 1.818% 99.033% ( 10, 15 ] 3095 0.298% 99.332% ( 15, 22 ] 346 0.033% 99.365% ( 22, 34 ] 36 0.003% 99.369% ( 34, 51 ] 30 0.003% 99.372% ( 51, 76 ] 46 0.004% 99.376% ( 76, 110 ] 91 0.009% 99.385% ( 110, 170 ] 648 0.062% 99.447% ( 170, 250 ] 756 0.073% 99.520% ( 250, 380 ] 819 0.079% 99.599% ( 380, 580 ] 1166 0.112% 99.712% ( 580, 870 ] 1222 0.118% 99.830% ( 870, 1300 ] 927 0.089% 99.919% ( 1300, 1900 ] 496 0.048% 99.967% ( 1900, 2900 ] 364 0.035% 100.002% ( 2900, 4400 ] 284 0.027% 100.029% ( 4400, 6600 ] 77 0.007% 100.037% ( 6600, 9900 ] 19 0.002% 100.038% ( 9900, 14000 ] 2 0.000% 100.039% ( 22000, 33000 ] 1 0.000% 100.039% ( 33000, 50000 ] 1 0.000% 100.039% ** Level 1 read latency histogram (micros): Count: 437131 Average: 10.5986 StdDev: 139.97 Min: 1 Median: 1.9670 Max: 19883 Percentiles: P50: 1.97 P75: 2.95 P99: 10.36 P99.9: 1684.66 P99.99: 3235.84 ------------------------------------------------------ [ 0, 1 ] 7052 1.613% 1.613% ( 1, 2 ] 218738 50.039% 51.653% ########## ( 2, 3 ] 107343 24.556% 76.209% ##### ( 3, 4 ] 44976 10.289% 86.498% ## ( 4, 6 ] 43633 9.982% 96.480% ## ( 6, 10 ] 10882 2.489% 98.969% ( 10, 15 ] 1862 0.426% 99.395% ( 15, 22 ] 242 0.055% 99.450% ( 22, 34 ] 24 0.005% 99.456% ( 34, 51 ] 32 0.007% 99.463% ( 51, 76 ] 46 0.011% 99.474% ( 76, 110 ] 17 0.004% 99.478% ( 110, 170 ] 78 0.018% 99.495% ( 170, 250 ] 114 0.026% 99.521% ( 250, 380 ] 229 0.052% 99.574% ( 380, 580 ] 325 0.074% 99.648% ( 580, 870 ] 470 0.108% 99.756% ( 870, 1300 ] 452 0.103% 99.859% ( 1300, 1900 ] 279 0.064% 99.923% ( 1900, 2900 ] 240 0.055% 99.978% ( 2900, 4400 ] 238 0.054% 100.032% ( 4400, 6600 ] 60 0.014% 100.046% ( 6600, 9900 ] 11 0.003% 100.048% ( 14000, 22000 ] 1 0.000% 100.049% ** Level 2 read latency histogram (micros): Count: 377996 Average: 12.7478 StdDev: 151.87 Min: 1 Median: 1.9911 Max: 7388 Percentiles: P50: 1.99 P75: 3.06 P99: 12.54 P99.9: 1562.61 P99.99: 2298.84 ------------------------------------------------------ [ 0, 1 ] 10019 2.651% 2.651% # ( 1, 2 ] 180584 47.774% 50.425% ########## ( 2, 3 ] 90252 23.876% 74.301% ##### ( 3, 4 ] 41023 10.853% 85.154% ## ( 4, 6 ] 39775 10.523% 95.676% ## ( 6, 10 ] 11418 3.021% 98.697% # ( 10, 15 ] 2257 0.597% 99.294% ( 15, 22 ] 336 0.089% 99.383% ( 22, 34 ] 73 0.019% 99.402% ( 34, 51 ] 41 0.011% 99.413% ( 51, 76 ] 31 0.008% 99.421% ( 76, 110 ] 25 0.007% 99.428% ( 110, 170 ] 53 0.014% 99.442% ( 170, 250 ] 92 0.024% 99.466% ( 250, 380 ] 205 0.054% 99.521% ( 380, 580 ] 331 0.088% 99.608% ( 580, 870 ] 456 0.121% 99.729% ( 870, 1300 ] 489 0.129% 99.858% ( 1300, 1900 ] 361 0.096% 99.954% ( 1900, 2900 ] 344 0.091% 100.045% ( 2900, 4400 ] 241 0.064% 100.108% ( 4400, 6600 ] 61 0.016% 100.125% ( 6600, 9900 ] 8 0.002% 100.127% ** Level 3 read latency histogram (micros): Count: 1880500 Average: 10.8491 StdDev: 143.23 Min: 1 Median: 1.9682 Max: 26526 Percentiles: P50: 1.97 P75: 2.97 P99: 9.75 P99.9: 945.44 P99.99: 1343.18 ------------------------------------------------------ [ 0, 1 ] 33350 1.773% 1.773% ( 1, 2 ] 936698 49.811% 51.585% ########## ( 2, 3 ] 453053 24.092% 75.677% ##### ( 3, 4 ] 200961 10.687% 86.363% ## ( 4, 6 ] 194813 10.360% 96.723% ## ( 6, 10 ] 45689 2.430% 99.153% ( 10, 15 ] 7828 0.416% 99.569% ( 15, 22 ] 975 0.052% 99.621% ( 22, 34 ] 88 0.005% 99.625% ( 34, 51 ] 107 0.006% 99.631% ( 51, 76 ] 174 0.009% 99.640% ( 76, 110 ] 58 0.003% 99.643% ( 110, 170 ] 186 0.010% 99.653% ( 170, 250 ] 381 0.020% 99.674% ( 250, 380 ] 638 0.034% 99.707% ( 380, 580 ] 1295 0.069% 99.776% ( 580, 870 ] 1986 0.106% 99.882% ( 870, 1300 ] 1935 0.103% 99.985% ( 1300, 1900 ] 1347 0.072% 100.056% ( 1900, 2900 ] 1172 0.062% 100.119% ( 2900, 4400 ] 1072 0.057% 100.176% ( 4400, 6600 ] 265 0.014% 100.190% ( 6600, 9900 ] 41 0.002% 100.192% ( 9900, 14000 ] 4 0.000% 100.192% ( 14000, 22000 ] 2 0.000% 100.192% ( 22000, 33000 ] 2 0.000% 100.193% ** Level 4 read latency histogram (micros): Count: 1268659 Average: 19.0629 StdDev: 207.40 Min: 0 Median: 1.9528 Max: 36182 Percentiles: P50: 1.95 P75: 2.96 P99: 327.01 P99.9: 2033.03 P99.99: 2945.36 ------------------------------------------------------ [ 0, 1 ] 22399 1.766% 1.766% ( 1, 2 ] 642257 50.625% 52.390% ########## ( 2, 3 ] 299223 23.586% 75.976% ##### ( 3, 4 ] 128979 10.167% 86.143% ## ( 4, 6 ] 121766 9.598% 95.741% ## ( 6, 10 ] 32115 2.531% 98.272% # ( 10, 15 ] 5100 0.402% 98.674% ( 15, 22 ] 550 0.043% 98.718% ( 22, 34 ] 50 0.004% 98.721% ( 34, 51 ] 113 0.009% 98.730% ( 51, 76 ] 132 0.010% 98.741% ( 76, 110 ] 193 0.015% 98.756% ( 110, 170 ] 832 0.066% 98.822% ( 170, 250 ] 1286 0.101% 98.923% ( 250, 380 ] 1650 0.130% 99.053% ( 380, 580 ] 2666 0.210% 99.263% ( 580, 870 ] 3351 0.264% 99.527% ( 870, 1300 ] 2864 0.226% 99.753% ( 1300, 1900 ] 1695 0.134% 99.887% ( 1900, 2900 ] 1273 0.100% 99.987% ( 2900, 4400 ] 1261 0.099% 100.086% ( 4400, 6600 ] 342 0.027% 100.113% ( 6600, 9900 ] 72 0.006% 100.119% ( 9900, 14000 ] 13 0.001% 100.120% ( 14000, 22000 ] 16 0.001% 100.121% ( 22000, 33000 ] 1 0.000% 100.121% ( 33000, 50000 ] 1 0.000% 100.121% ** Level 5 read latency histogram (micros): Count: 54044 Average: 1044.8706 StdDev: 1190.11 Min: 78 Median: 679.7725 Max: 36217 Percentiles: P50: 679.77 P75: 1221.94 P99: 5793.11 P99.9: 9184.74 P99.99: 20595.60 ------------------------------------------------------ ( 76, 110 ] 675 1.249% 1.249% ( 110, 170 ] 3674 6.798% 8.047% # ( 170, 250 ] 4564 8.445% 16.492% ## ( 250, 380 ] 5774 10.684% 27.176% ## ( 380, 580 ] 8812 16.305% 43.481% ### ( 580, 870 ] 10240 18.948% 62.429% #### ( 870, 1300 ] 8301 15.360% 77.788% ### ( 1300, 1900 ] 4347 8.043% 85.832% ## ( 1900, 2900 ] 3260 6.032% 91.864% # ( 2900, 4400 ] 3198 5.917% 97.781% # ( 4400, 6600 ] 1040 1.924% 99.706% ( 6600, 9900 ] 134 0.248% 99.954% ( 9900, 14000 ] 13 0.024% 99.978% ( 14000, 22000 ] 8 0.015% 99.993% ( 22000, 33000 ] 3 0.006% 99.998% ( 33000, 50000 ] 4 0.007% 100.006% ** DB Stats ** Uptime(secs): 19.5 total, 4.7 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 151.64 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:7.547 H:M:S, 38.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 208.82 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.852 H:M:S, 18.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/12/06-09:47:30 ... thread 0: (1000000,4000000) ops and (285906.6,175763.3) ops/second in (3.497646,22.757876) 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/4 2.21 GB 201.4 2.9 0.0 2.9 6.6 3.7 0.0 1.8 83.1 190.9 35.62 22.75 62 0.574 3006K 3370 0.0 0.0 L1 12/0 1.06 GB 108.6 2.5 1.9 0.6 2.5 1.9 0.0 1.3 134.2 133.8 19.17 12.10 3 6.389 2612K 8548 0.0 0.0 L3 20/0 926.32 MB 0.9 5.2 2.8 2.4 5.2 2.8 0.1 1.8 115.3 114.7 46.08 24.95 26 1.772 3766K 6082 0.0 0.0 L4 165/0 9.71 GB 1.0 10.3 5.3 5.0 10.2 5.2 0.4 1.9 123.3 121.6 85.69 48.89 56 1.530 5217K 5472 0.0 0.0 L5 1148/0 94.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1358/4 108.30 GB 0.0 20.9 10.1 10.8 24.5 13.6 6.1 6.5 114.8 134.4 186.55 108.68 147 1.269 14M 23K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.9 10.1 10.8 24.5 13.6 6.1 6.5 114.8 134.4 186.55 108.68 147 1.269 14M 23K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 20.9 10.1 10.8 20.7 9.9 0.0 0.0 129.9 128.8 164.88 97.64 95 1.736 14M 23K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 177.3 21.67 11.05 52 0.417 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.0 total, 22.8 interval Flush(GB): cumulative 3.753, interval 3.753 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 24.48 GB write, 1091.58 MB/s write, 20.91 GB read, 932.47 MB/s read, 186.6 seconds Interval compaction: 24.48 GB write, 1101.56 MB/s write, 20.91 GB read, 940.99 MB/s read, 186.6 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: 63, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 63, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1302616 Average: 8.0534 StdDev: 106.10 Min: 0 Median: 1.7370 Max: 34666 Percentiles: P50: 1.74 P75: 2.58 P99: 11.77 P99.9: 1065.30 P99.99: 2309.97 ------------------------------------------------------ [ 0, 1 ] 124386 9.549% 9.549% ## ( 1, 2 ] 714944 54.885% 64.434% ########### ( 2, 3 ] 236256 18.137% 82.571% #### ( 3, 4 ] 101311 7.778% 90.349% ## ( 4, 6 ] 91704 7.040% 97.389% # ( 6, 10 ] 19811 1.521% 98.910% ( 10, 15 ] 3322 0.255% 99.165% ( 15, 22 ] 390 0.030% 99.195% ( 22, 34 ] 42 0.003% 99.198% ( 34, 51 ] 30 0.002% 99.200% ( 51, 76 ] 48 0.004% 99.204% ( 76, 110 ] 352 0.027% 99.231% ( 110, 170 ] 2247 0.172% 99.403% ( 170, 250 ] 1847 0.142% 99.545% ( 250, 380 ] 1311 0.101% 99.646% ( 380, 580 ] 1522 0.117% 99.763% ( 580, 870 ] 1358 0.104% 99.867% ( 870, 1300 ] 952 0.073% 99.940% ( 1300, 1900 ] 499 0.038% 99.978% ( 1900, 2900 ] 375 0.029% 100.007% ( 2900, 4400 ] 285 0.022% 100.029% ( 4400, 6600 ] 77 0.006% 100.035% ( 6600, 9900 ] 19 0.001% 100.036% ( 9900, 14000 ] 2 0.000% 100.036% ( 22000, 33000 ] 1 0.000% 100.036% ( 33000, 50000 ] 1 0.000% 100.037% ** Level 1 read latency histogram (micros): Count: 440218 Average: 10.8488 StdDev: 139.88 Min: 1 Median: 1.9728 Max: 19883 Percentiles: P50: 1.97 P75: 2.97 P99: 12.03 P99.9: 1682.51 P99.99: 3233.90 ------------------------------------------------------ [ 0, 1 ] 7066 1.605% 1.605% ( 1, 2 ] 219001 49.748% 51.353% ########## ( 2, 3 ] 107693 24.464% 75.817% ##### ( 3, 4 ] 45724 10.387% 86.204% ## ( 4, 6 ] 44498 10.108% 96.312% ## ( 6, 10 ] 11060 2.512% 98.824% # ( 10, 15 ] 1902 0.432% 99.256% ( 15, 22 ] 259 0.059% 99.315% ( 22, 34 ] 25 0.006% 99.321% ( 34, 51 ] 32 0.007% 99.328% ( 51, 76 ] 47 0.011% 99.339% ( 76, 110 ] 106 0.024% 99.363% ( 110, 170 ] 360 0.082% 99.445% ( 170, 250 ] 232 0.053% 99.497% ( 250, 380 ] 285 0.065% 99.562% ( 380, 580 ] 367 0.083% 99.645% ( 580, 870 ] 481 0.109% 99.755% ( 870, 1300 ] 460 0.104% 99.859% ( 1300, 1900 ] 282 0.064% 99.923% ( 1900, 2900 ] 241 0.055% 99.978% ( 2900, 4400 ] 238 0.054% 100.032% ( 4400, 6600 ] 60 0.014% 100.046% ( 6600, 9900 ] 11 0.002% 100.048% ( 14000, 22000 ] 1 0.000% 100.048% ** Level 2 read latency histogram (micros): Count: 377996 Average: 12.7478 StdDev: 151.87 Min: 1 Median: 1.9911 Max: 7388 Percentiles: P50: 1.99 P75: 3.06 P99: 12.54 P99.9: 1562.61 P99.99: 2298.84 ------------------------------------------------------ [ 0, 1 ] 10019 2.651% 2.651% # ( 1, 2 ] 180584 47.774% 50.425% ########## ( 2, 3 ] 90252 23.876% 74.301% ##### ( 3, 4 ] 41023 10.853% 85.154% ## ( 4, 6 ] 39775 10.523% 95.676% ## ( 6, 10 ] 11418 3.021% 98.697% # ( 10, 15 ] 2257 0.597% 99.294% ( 15, 22 ] 336 0.089% 99.383% ( 22, 34 ] 73 0.019% 99.402% ( 34, 51 ] 41 0.011% 99.413% ( 51, 76 ] 31 0.008% 99.421% ( 76, 110 ] 25 0.007% 99.428% ( 110, 170 ] 53 0.014% 99.442% ( 170, 250 ] 92 0.024% 99.466% ( 250, 380 ] 205 0.054% 99.521% ( 380, 580 ] 331 0.088% 99.608% ( 580, 870 ] 456 0.121% 99.729% ( 870, 1300 ] 489 0.129% 99.858% ( 1300, 1900 ] 361 0.096% 99.954% ( 1900, 2900 ] 344 0.091% 100.045% ( 2900, 4400 ] 241 0.064% 100.108% ( 4400, 6600 ] 61 0.016% 100.125% ( 6600, 9900 ] 8 0.002% 100.127% ** Level 3 read latency histogram (micros): Count: 1891147 Average: 10.9069 StdDev: 142.96 Min: 1 Median: 1.9665 Max: 26526 Percentiles: P50: 1.97 P75: 2.97 P99: 9.82 P99.9: 944.81 P99.99: 1343.57 ------------------------------------------------------ [ 0, 1 ] 34089 1.803% 1.803% ( 1, 2 ] 943091 49.869% 51.671% ########## ( 2, 3 ] 454758 24.047% 75.718% ##### ( 3, 4 ] 201332 10.646% 86.364% ## ( 4, 6 ] 195115 10.317% 96.681% ## ( 6, 10 ] 45873 2.426% 99.107% ( 10, 15 ] 7835 0.414% 99.521% ( 15, 22 ] 976 0.052% 99.573% ( 22, 34 ] 88 0.005% 99.578% ( 34, 51 ] 107 0.006% 99.583% ( 51, 76 ] 174 0.009% 99.592% ( 76, 110 ] 178 0.009% 99.602% ( 110, 170 ] 627 0.033% 99.635% ( 170, 250 ] 570 0.030% 99.665% ( 250, 380 ] 727 0.038% 99.704% ( 380, 580 ] 1362 0.072% 99.776% ( 580, 870 ] 2016 0.107% 99.882% ( 870, 1300 ] 1942 0.103% 99.985% ( 1300, 1900 ] 1348 0.071% 100.056% ( 1900, 2900 ] 1173 0.062% 100.118% ( 2900, 4400 ] 1072 0.057% 100.175% ( 4400, 6600 ] 265 0.014% 100.189% ( 6600, 9900 ] 41 0.002% 100.191% ( 9900, 14000 ] 4 0.000% 100.191% ( 14000, 22000 ] 2 0.000% 100.191% ( 22000, 33000 ] 2 0.000% 100.191% ** Level 4 read latency histogram (micros): Count: 1285245 Average: 20.0263 StdDev: 206.90 Min: 0 Median: 1.9560 Max: 36182 Percentiles: P50: 1.96 P75: 2.97 P99: 376.52 P99.9: 2025.49 P99.99: 2943.39 ------------------------------------------------------ [ 0, 1 ] 23175 1.803% 1.803% ( 1, 2 ] 647959 50.415% 52.218% ########## ( 2, 3 ] 300738 23.399% 75.618% ##### ( 3, 4 ] 129460 10.073% 85.690% ## ( 4, 6 ] 122249 9.512% 95.202% ## ( 6, 10 ] 32288 2.512% 97.714% # ( 10, 15 ] 5124 0.399% 98.113% ( 15, 22 ] 553 0.043% 98.156% ( 22, 34 ] 50 0.004% 98.160% ( 34, 51 ] 113 0.009% 98.169% ( 51, 76 ] 133 0.010% 98.179% ( 76, 110 ] 1198 0.093% 98.272% ( 110, 170 ] 4361 0.339% 98.612% ( 170, 250 ] 2722 0.212% 98.823% ( 250, 380 ] 2332 0.181% 99.005% ( 380, 580 ] 3204 0.249% 99.254% ( 580, 870 ] 3548 0.276% 99.530% ( 870, 1300 ] 2893 0.225% 99.755% ( 1300, 1900 ] 1699 0.132% 99.887% ( 1900, 2900 ] 1281 0.100% 99.987% ( 2900, 4400 ] 1261 0.098% 100.085% ( 4400, 6600 ] 342 0.027% 100.112% ( 6600, 9900 ] 72 0.006% 100.117% ( 9900, 14000 ] 13 0.001% 100.118% ( 14000, 22000 ] 16 0.001% 100.120% ( 22000, 33000 ] 1 0.000% 100.120% ( 33000, 50000 ] 1 0.000% 100.120% ** Level 5 read latency histogram (micros): Count: 96916 Average: 672.2813 StdDev: 987.13 Min: 78 Median: 314.0362 Max: 36217 Percentiles: P50: 314.04 P75: 774.45 P99: 4888.32 P99.9: 8153.56 P99.99: 17308.40 ------------------------------------------------------ ( 76, 110 ] 6597 6.807% 6.807% # ( 110, 170 ] 24097 24.864% 31.671% ##### ( 170, 250 ] 13080 13.496% 45.167% ### ( 250, 380 ] 9509 9.812% 54.979% ## ( 380, 580 ] 11887 12.265% 67.244% ## ( 580, 870 ] 11211 11.568% 78.812% ## ( 870, 1300 ] 8489 8.759% 87.571% ## ( 1300, 1900 ] 4362 4.501% 92.071% # ( 1900, 2900 ] 3285 3.390% 95.461% # ( 2900, 4400 ] 3199 3.301% 98.762% # ( 4400, 6600 ] 1040 1.073% 99.835% ( 6600, 9900 ] 134 0.138% 99.973% ( 9900, 14000 ] 13 0.013% 99.987% ( 14000, 22000 ] 8 0.008% 99.995% ( 22000, 33000 ] 3 0.003% 99.998% ( 33000, 50000 ] 4 0.004% 100.002% ** DB Stats ** Uptime(secs): 23.0 total, 3.5 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 171.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:7.547 H:M:S, 32.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 281.39 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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-09:47:33 ... thread 0: (1000000,5000000) ops and (291943.9,190962.2) ops/second in (3.425316,26.183192) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/4 3.20 GB 302.1 3.9 0.0 3.9 8.6 4.7 0.0 1.8 93.0 206.6 42.66 29.30 82 0.520 4029K 4308 0.0 0.0 L1 12/0 1.06 GB 108.6 2.5 1.9 0.6 2.5 1.9 0.0 1.3 134.2 133.8 19.17 12.10 3 6.389 2612K 8548 0.0 0.0 L3 20/0 926.32 MB 0.9 5.2 2.8 2.4 5.2 2.8 0.1 1.8 115.3 114.7 46.08 24.95 26 1.772 3766K 6082 0.0 0.0 L4 165/0 9.71 GB 1.0 10.3 5.3 5.0 10.2 5.2 0.4 1.9 123.3 121.6 85.69 48.89 56 1.530 5217K 5472 0.0 0.0 L5 1148/0 94.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1362/4 109.28 GB 0.0 21.9 10.1 11.8 26.5 14.6 6.1 5.6 115.8 139.9 193.60 115.23 167 1.159 15M 24K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.9 10.1 11.8 26.5 14.6 6.1 5.6 115.8 139.9 193.60 115.23 167 1.159 15M 24K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 21.9 10.1 11.8 21.7 9.9 0.0 0.0 132.9 131.8 168.76 101.44 99 1.705 15M 24K 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 195.3 24.84 13.79 68 0.365 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): 26.4 total, 26.2 interval Flush(GB): cumulative 4.737, interval 4.737 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 26.45 GB write, 1026.26 MB/s write, 21.90 GB read, 849.65 MB/s read, 193.6 seconds Interval compaction: 26.45 GB write, 1034.42 MB/s write, 21.90 GB read, 856.40 MB/s read, 193.6 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: 63, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 63, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1561670 Average: 7.4147 StdDev: 97.59 Min: 0 Median: 1.6716 Max: 34666 Percentiles: P50: 1.67 P75: 2.42 P99: 12.32 P99.9: 934.31 P99.99: 2113.28 ------------------------------------------------------ [ 0, 1 ] 202791 12.986% 12.986% ### ( 1, 2 ] 860725 55.116% 68.101% ########### ( 2, 3 ] 254429 16.292% 84.393% ### ( 3, 4 ] 108627 6.956% 91.349% # ( 4, 6 ] 96954 6.208% 97.557% # ( 6, 10 ] 20829 1.334% 98.891% ( 10, 15 ] 3669 0.235% 99.126% ( 15, 22 ] 424 0.027% 99.153% ( 22, 34 ] 44 0.003% 99.156% ( 34, 51 ] 32 0.002% 99.158% ( 51, 76 ] 49 0.003% 99.161% ( 76, 110 ] 612 0.039% 99.201% ( 110, 170 ] 3509 0.225% 99.425% ( 170, 250 ] 2565 0.164% 99.589% ( 250, 380 ] 1573 0.101% 99.690% ( 380, 580 ] 1708 0.109% 99.800% ( 580, 870 ] 1425 0.091% 99.891% ( 870, 1300 ] 965 0.062% 99.953% ( 1300, 1900 ] 504 0.032% 99.985% ( 1900, 2900 ] 379 0.024% 100.009% ( 2900, 4400 ] 286 0.018% 100.027% ( 4400, 6600 ] 77 0.005% 100.032% ( 6600, 9900 ] 19 0.001% 100.034% ( 9900, 14000 ] 2 0.000% 100.034% ( 22000, 33000 ] 1 0.000% 100.034% ( 33000, 50000 ] 1 0.000% 100.034% ** Level 1 read latency histogram (micros): Count: 441306 Average: 11.1639 StdDev: 140.01 Min: 1 Median: 1.9753 Max: 19883 Percentiles: P50: 1.98 P75: 2.97 P99: 14.06 P99.9: 1680.20 P99.99: 3233.21 ------------------------------------------------------ [ 0, 1 ] 7066 1.601% 1.601% ( 1, 2 ] 219003 49.626% 51.227% ########## ( 2, 3 ] 107707 24.406% 75.634% ##### ( 3, 4 ] 45824 10.384% 86.017% ## ( 4, 6 ] 44656 10.119% 96.136% ## ( 6, 10 ] 11086 2.512% 98.649% # ( 10, 15 ] 1910 0.433% 99.081% ( 15, 22 ] 259 0.059% 99.140% ( 22, 34 ] 25 0.006% 99.146% ( 34, 51 ] 32 0.007% 99.153% ( 51, 76 ] 47 0.011% 99.164% ( 76, 110 ] 218 0.049% 99.213% ( 110, 170 ] 778 0.176% 99.389% ( 170, 250 ] 354 0.080% 99.470% ( 250, 380 ] 345 0.078% 99.548% ( 380, 580 ] 417 0.094% 99.642% ( 580, 870 ] 498 0.113% 99.755% ( 870, 1300 ] 461 0.104% 99.860% ( 1300, 1900 ] 282 0.064% 99.923% ( 1900, 2900 ] 241 0.055% 99.978% ( 2900, 4400 ] 238 0.054% 100.032% ( 4400, 6600 ] 60 0.014% 100.046% ( 6600, 9900 ] 11 0.002% 100.048% ( 14000, 22000 ] 1 0.000% 100.048% ** Level 2 read latency histogram (micros): Count: 377996 Average: 12.7478 StdDev: 151.87 Min: 1 Median: 1.9911 Max: 7388 Percentiles: P50: 1.99 P75: 3.06 P99: 12.54 P99.9: 1562.61 P99.99: 2298.84 ------------------------------------------------------ [ 0, 1 ] 10019 2.651% 2.651% # ( 1, 2 ] 180584 47.774% 50.425% ########## ( 2, 3 ] 90252 23.876% 74.301% ##### ( 3, 4 ] 41023 10.853% 85.154% ## ( 4, 6 ] 39775 10.523% 95.676% ## ( 6, 10 ] 11418 3.021% 98.697% # ( 10, 15 ] 2257 0.597% 99.294% ( 15, 22 ] 336 0.089% 99.383% ( 22, 34 ] 73 0.019% 99.402% ( 34, 51 ] 41 0.011% 99.413% ( 51, 76 ] 31 0.008% 99.421% ( 76, 110 ] 25 0.007% 99.428% ( 110, 170 ] 53 0.014% 99.442% ( 170, 250 ] 92 0.024% 99.466% ( 250, 380 ] 205 0.054% 99.521% ( 380, 580 ] 331 0.088% 99.608% ( 580, 870 ] 456 0.121% 99.729% ( 870, 1300 ] 489 0.129% 99.858% ( 1300, 1900 ] 361 0.096% 99.954% ( 1900, 2900 ] 344 0.091% 100.045% ( 2900, 4400 ] 241 0.064% 100.108% ( 4400, 6600 ] 61 0.016% 100.125% ( 6600, 9900 ] 8 0.002% 100.127% ** Level 3 read latency histogram (micros): Count: 1892183 Average: 11.0076 StdDev: 143.06 Min: 1 Median: 1.9670 Max: 26526 Percentiles: P50: 1.97 P75: 2.97 P99: 9.91 P99.9: 945.46 P99.99: 1345.27 ------------------------------------------------------ [ 0, 1 ] 34089 1.802% 1.802% ( 1, 2 ] 943091 49.841% 51.643% ########## ( 2, 3 ] 454762 24.034% 75.677% ##### ( 3, 4 ] 201340 10.641% 86.317% ## ( 4, 6 ] 195122 10.312% 96.629% ## ( 6, 10 ] 45873 2.424% 99.054% ( 10, 15 ] 7835 0.414% 99.468% ( 15, 22 ] 976 0.052% 99.519% ( 22, 34 ] 88 0.005% 99.524% ( 34, 51 ] 107 0.006% 99.530% ( 51, 76 ] 174 0.009% 99.539% ( 76, 110 ] 318 0.017% 99.556% ( 110, 170 ] 1152 0.061% 99.617% ( 170, 250 ] 758 0.040% 99.657% ( 250, 380 ] 799 0.042% 99.699% ( 380, 580 ] 1432 0.076% 99.774% ( 580, 870 ] 2034 0.107% 99.882% ( 870, 1300 ] 1942 0.103% 99.985% ( 1300, 1900 ] 1349 0.071% 100.056% ( 1900, 2900 ] 1174 0.062% 100.118% ( 2900, 4400 ] 1074 0.057% 100.175% ( 4400, 6600 ] 265 0.014% 100.189% ( 6600, 9900 ] 41 0.002% 100.191% ( 9900, 14000 ] 4 0.000% 100.191% ( 14000, 22000 ] 2 0.000% 100.191% ( 22000, 33000 ] 2 0.000% 100.191% ** Level 4 read latency histogram (micros): Count: 1293256 Average: 21.0490 StdDev: 206.99 Min: 0 Median: 1.9622 Max: 36182 Percentiles: P50: 1.96 P75: 2.99 P99: 409.12 P99.9: 2022.66 P99.99: 2942.44 ------------------------------------------------------ [ 0, 1 ] 23175 1.792% 1.792% ( 1, 2 ] 647961 50.103% 51.895% ########## ( 2, 3 ] 300763 23.256% 75.151% ##### ( 3, 4 ] 129614 10.022% 85.174% ## ( 4, 6 ] 122447 9.468% 94.642% ## ( 6, 10 ] 32304 2.498% 97.140% ( 10, 15 ] 5130 0.397% 97.536% ( 15, 22 ] 557 0.043% 97.579% ( 22, 34 ] 50 0.004% 97.583% ( 34, 51 ] 113 0.009% 97.592% ( 51, 76 ] 134 0.010% 97.602% ( 76, 110 ] 2327 0.180% 97.782% ( 110, 170 ] 8166 0.631% 98.414% ( 170, 250 ] 4162 0.322% 98.736% ( 250, 380 ] 2882 0.223% 98.958% ( 380, 580 ] 3698 0.286% 99.244% ( 580, 870 ] 3702 0.286% 99.531% ( 870, 1300 ] 2913 0.225% 99.756% ( 1300, 1900 ] 1707 0.132% 99.888% ( 1900, 2900 ] 1286 0.099% 99.987% ( 2900, 4400 ] 1261 0.098% 100.085% ( 4400, 6600 ] 342 0.026% 100.111% ( 6600, 9900 ] 72 0.006% 100.117% ( 9900, 14000 ] 13 0.001% 100.118% ( 14000, 22000 ] 16 0.001% 100.119% ( 22000, 33000 ] 1 0.000% 100.119% ( 33000, 50000 ] 1 0.000% 100.119% ** Level 5 read latency histogram (micros): Count: 140215 Average: 523.6523 StdDev: 853.65 Min: 76 Median: 211.7055 Max: 36217 Percentiles: P50: 211.71 P75: 546.61 P99: 4305.27 P99.9: 7087.24 P99.99: 13677.83 ------------------------------------------------------ ( 51, 76 ] 1 0.001% 0.001% ( 76, 110 ] 13394 9.552% 9.553% ## ( 110, 170 ] 45623 32.538% 42.091% ####### ( 170, 250 ] 21272 15.171% 57.262% ### ( 250, 380 ] 12693 9.053% 66.315% ## ( 380, 580 ] 14619 10.426% 76.741% ## ( 580, 870 ] 11935 8.512% 85.253% ## ( 870, 1300 ] 8583 6.121% 91.374% # ( 1300, 1900 ] 4389 3.130% 94.504% # ( 1900, 2900 ] 3305 2.357% 96.861% ( 2900, 4400 ] 3201 2.283% 99.144% ( 4400, 6600 ] 1040 0.742% 99.886% ( 6600, 9900 ] 134 0.096% 99.981% ( 9900, 14000 ] 13 0.009% 99.991% ( 14000, 22000 ] 8 0.006% 99.996% ( 22000, 33000 ] 3 0.002% 99.999% ( 33000, 50000 ] 4 0.003% 100.001% ** DB Stats ** Uptime(secs): 26.4 total, 3.4 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 186.45 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.547 H:M:S, 28.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 287.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.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/12/06-09:47:49 ... thread 0: (1000000,6000000) ops and (63139.0,142784.9) ops/second in (15.838061,42.021253) 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 21/17 4.18 GB 44.1 4.9 0.0 4.9 10.6 5.7 0.0 1.8 100.1 217.9 49.70 35.86 102 0.487 5053K 5281 0.0 0.0 L1 12/12 1.06 GB 0.0 2.5 1.9 0.6 2.5 1.9 0.0 1.3 134.2 133.8 19.17 12.10 3 6.389 2612K 8548 0.0 0.0 L3 20/0 926.32 MB 0.9 5.2 2.8 2.4 5.2 2.8 0.1 1.8 115.3 114.7 46.08 24.95 26 1.772 3766K 6082 0.0 0.0 L4 165/0 9.71 GB 1.0 10.3 5.3 5.0 10.2 5.2 0.4 1.9 123.3 121.6 85.69 48.89 56 1.530 5217K 5472 0.0 0.0 L5 1148/0 94.41 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1366/29 110.27 GB 0.0 22.9 10.1 12.8 28.4 15.6 6.1 5.0 116.8 145.0 200.63 121.80 187 1.073 16M 25K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.9 10.1 12.8 28.4 15.6 6.1 5.0 116.8 145.0 200.63 121.80 187 1.073 16M 25K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 22.9 10.1 12.8 22.7 9.9 0.0 0.0 135.7 134.6 172.62 105.22 103 1.676 16M 25K 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 209.1 28.02 16.57 84 0.334 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 42.2 total, 42.0 interval Flush(GB): cumulative 5.721, interval 5.721 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.42 GB write, 689.09 MB/s write, 22.88 GB read, 554.86 MB/s read, 200.6 seconds Interval compaction: 28.42 GB write, 692.50 MB/s write, 22.88 GB read, 557.61 MB/s read, 200.6 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 8, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 8, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 63, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 8, total-stops: 63, interval: 71 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2003166 Average: 11.3230 StdDev: 92.05 Min: 0 Median: 1.7316 Max: 34666 Percentiles: P50: 1.73 P75: 2.77 P99: 168.40 P99.9: 803.69 P99.99: 1797.53 ------------------------------------------------------ [ 0, 1 ] 273926 13.675% 13.675% ### ( 1, 2 ] 994547 49.649% 63.323% ########## ( 2, 3 ] 304967 15.224% 78.548% ### ( 3, 4 ] 188840 9.427% 87.975% ## ( 4, 6 ] 128483 6.414% 94.389% # ( 6, 10 ] 25945 1.295% 95.684% ( 10, 15 ] 4849 0.242% 95.926% ( 15, 22 ] 546 0.027% 95.953% ( 22, 34 ] 47 0.002% 95.956% ( 34, 51 ] 34 0.002% 95.957% ( 51, 76 ] 51 0.003% 95.960% ( 76, 110 ] 14721 0.735% 96.695% ( 110, 170 ] 47442 2.368% 99.063% ( 170, 250 ] 10113 0.505% 99.568% ( 250, 380 ] 2840 0.142% 99.710% ( 380, 580 ] 2553 0.127% 99.837% ( 580, 870 ] 1632 0.081% 99.919% ( 870, 1300 ] 996 0.050% 99.968% ( 1300, 1900 ] 523 0.026% 99.994% ( 1900, 2900 ] 402 0.020% 100.015% ( 2900, 4400 ] 310 0.015% 100.030% ( 4400, 6600 ] 77 0.004% 100.034% ( 6600, 9900 ] 20 0.001% 100.035% ( 9900, 14000 ] 2 0.000% 100.035% ( 22000, 33000 ] 1 0.000% 100.035% ( 33000, 50000 ] 1 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 482059 Average: 12.4811 StdDev: 135.09 Min: 1 Median: 2.1298 Max: 19883 Percentiles: P50: 2.13 P75: 3.38 P99: 154.42 P99.9: 1593.54 P99.99: 3201.22 ------------------------------------------------------ [ 0, 1 ] 7096 1.472% 1.472% ( 1, 2 ] 219370 45.507% 46.979% ######### ( 2, 3 ] 112187 23.272% 70.251% ##### ( 3, 4 ] 59531 12.349% 82.601% ## ( 4, 6 ] 58439 12.123% 94.723% ## ( 6, 10 ] 12260 2.543% 97.267% # ( 10, 15 ] 2360 0.490% 97.756% ( 15, 22 ] 610 0.127% 97.883% ( 22, 34 ] 38 0.008% 97.891% ( 34, 51 ] 32 0.007% 97.897% ( 51, 76 ] 47 0.010% 97.907% ( 76, 110 ] 1633 0.339% 98.246% ( 110, 170 ] 4910 1.019% 99.264% ( 170, 250 ] 983 0.204% 99.468% ( 250, 380 ] 465 0.096% 99.565% ( 380, 580 ] 494 0.102% 99.667% ( 580, 870 ] 519 0.108% 99.775% ( 870, 1300 ] 464 0.096% 99.871% ( 1300, 1900 ] 284 0.059% 99.930% ( 1900, 2900 ] 241 0.050% 99.980% ( 2900, 4400 ] 238 0.049% 100.029% ( 4400, 6600 ] 60 0.012% 100.042% ( 6600, 9900 ] 11 0.002% 100.044% ( 14000, 22000 ] 1 0.000% 100.044% ** Level 2 read latency histogram (micros): Count: 377996 Average: 12.7478 StdDev: 151.87 Min: 1 Median: 1.9911 Max: 7388 Percentiles: P50: 1.99 P75: 3.06 P99: 12.54 P99.9: 1562.61 P99.99: 2298.84 ------------------------------------------------------ [ 0, 1 ] 10019 2.651% 2.651% # ( 1, 2 ] 180584 47.774% 50.425% ########## ( 2, 3 ] 90252 23.876% 74.301% ##### ( 3, 4 ] 41023 10.853% 85.154% ## ( 4, 6 ] 39775 10.523% 95.676% ## ( 6, 10 ] 11418 3.021% 98.697% # ( 10, 15 ] 2257 0.597% 99.294% ( 15, 22 ] 336 0.089% 99.383% ( 22, 34 ] 73 0.019% 99.402% ( 34, 51 ] 41 0.011% 99.413% ( 51, 76 ] 31 0.008% 99.421% ( 76, 110 ] 25 0.007% 99.428% ( 110, 170 ] 53 0.014% 99.442% ( 170, 250 ] 92 0.024% 99.466% ( 250, 380 ] 205 0.054% 99.521% ( 380, 580 ] 331 0.088% 99.608% ( 580, 870 ] 456 0.121% 99.729% ( 870, 1300 ] 489 0.129% 99.858% ( 1300, 1900 ] 361 0.096% 99.954% ( 1900, 2900 ] 344 0.091% 100.045% ( 2900, 4400 ] 241 0.064% 100.108% ( 4400, 6600 ] 61 0.016% 100.125% ( 6600, 9900 ] 8 0.002% 100.127% ** Level 3 read latency histogram (micros): Count: 1898075 Average: 11.4309 StdDev: 143.10 Min: 1 Median: 1.9702 Max: 26526 Percentiles: P50: 1.97 P75: 2.98 P99: 13.07 P99.9: 945.01 P99.99: 1346.27 ------------------------------------------------------ [ 0, 1 ] 34089 1.796% 1.796% ( 1, 2 ] 943091 49.687% 51.483% ########## ( 2, 3 ] 454762 23.959% 75.442% ##### ( 3, 4 ] 201340 10.608% 86.049% ## ( 4, 6 ] 195122 10.280% 96.329% ## ( 6, 10 ] 45873 2.417% 98.746% ( 10, 15 ] 7835 0.413% 99.159% ( 15, 22 ] 976 0.051% 99.210% ( 22, 34 ] 88 0.005% 99.215% ( 34, 51 ] 107 0.006% 99.221% ( 51, 76 ] 174 0.009% 99.230% ( 76, 110 ] 1585 0.084% 99.313% ( 110, 170 ] 4904 0.258% 99.572% ( 170, 250 ] 1391 0.073% 99.645% ( 250, 380 ] 920 0.048% 99.693% ( 380, 580 ] 1532 0.081% 99.774% ( 580, 870 ] 2049 0.108% 99.882% ( 870, 1300 ] 1943 0.102% 99.985% ( 1300, 1900 ] 1351 0.071% 100.056% ( 1900, 2900 ] 1175 0.062% 100.118% ( 2900, 4400 ] 1074 0.057% 100.174% ( 4400, 6600 ] 265 0.014% 100.188% ( 6600, 9900 ] 41 0.002% 100.190% ( 9900, 14000 ] 4 0.000% 100.191% ( 14000, 22000 ] 2 0.000% 100.191% ( 22000, 33000 ] 2 0.000% 100.191% ** Level 4 read latency histogram (micros): Count: 1340534 Average: 25.4409 StdDev: 205.15 Min: 0 Median: 1.9987 Max: 36182 Percentiles: P50: 2.00 P75: 3.26 P99: 425.02 P99.9: 1993.87 P99.99: 2940.25 ------------------------------------------------------ [ 0, 1 ] 23175 1.729% 1.729% ( 1, 2 ] 647963 48.336% 50.065% ########## ( 2, 3 ] 300775 22.437% 72.502% #### ( 3, 4 ] 129772 9.681% 82.183% ## ( 4, 6 ] 122647 9.149% 91.332% ## ( 6, 10 ] 32319 2.411% 93.743% ( 10, 15 ] 5137 0.383% 94.126% ( 15, 22 ] 558 0.042% 94.167% ( 22, 34 ] 50 0.004% 94.171% ( 34, 51 ] 113 0.008% 94.180% ( 51, 76 ] 134 0.010% 94.190% ( 76, 110 ] 12946 0.966% 95.155% ( 110, 170 ] 37906 2.828% 97.983% # ( 170, 250 ] 8786 0.655% 98.638% ( 250, 380 ] 3851 0.287% 98.926% ( 380, 580 ] 4428 0.330% 99.256% ( 580, 870 ] 3862 0.288% 99.544% ( 870, 1300 ] 2938 0.219% 99.763% ( 1300, 1900 ] 1712 0.128% 99.891% ( 1900, 2900 ] 1294 0.097% 99.987% ( 2900, 4400 ] 1265 0.094% 100.082% ( 4400, 6600 ] 342 0.026% 100.107% ( 6600, 9900 ] 72 0.005% 100.113% ( 9900, 14000 ] 13 0.001% 100.114% ( 14000, 22000 ] 16 0.001% 100.115% ( 22000, 33000 ] 1 0.000% 100.115% ( 33000, 50000 ] 1 0.000% 100.115% ** Level 5 read latency histogram (micros): Count: 389229 Average: 282.1690 StdDev: 547.13 Min: 76 Median: 146.6298 Max: 36217 Percentiles: P50: 146.63 P75: 201.53 P99: 3141.77 P99.9: 6110.86 P99.99: 9532.50 ------------------------------------------------------ ( 51, 76 ] 1 0.000% 0.000% ( 76, 110 ] 70309 18.064% 18.064% #### ( 110, 170 ] 203613 52.312% 70.376% ########## ( 170, 250 ] 45671 11.734% 82.110% ## ( 250, 380 ] 17568 4.514% 86.623% # ( 380, 580 ] 18387 4.724% 91.347% # ( 580, 870 ] 12791 3.286% 94.633% # ( 870, 1300 ] 8696 2.234% 96.867% ( 1300, 1900 ] 4427 1.137% 98.005% ( 1900, 2900 ] 3357 0.862% 98.867% ( 2900, 4400 ] 3212 0.825% 99.692% ( 4400, 6600 ] 1040 0.267% 99.960% ( 6600, 9900 ] 134 0.034% 99.994% ( 9900, 14000 ] 13 0.003% 99.997% ( 14000, 22000 ] 8 0.002% 99.999% ( 22000, 33000 ] 3 0.001% 100.000% ( 33000, 50000 ] 4 0.001% 100.001% ** DB Stats ** Uptime(secs): 42.2 total, 15.8 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 139.82 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:19.459 H:M:S, 46.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 62.14 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:11.912 H:M:S, 75.2 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 284.137 micros/op 14061 ops/sec 60.163 seconds 845996 operations; 13.6 MB/s (210999 of 210999 found) Microseconds per read: Count: 845996 Average: 284.1418 StdDev: 777.32 Min: 3 Median: 193.5506 Max: 76968 Percentiles: P50: 193.55 P75: 241.51 P99: 1970.37 P99.9: 12717.21 P99.99: 29574.32 ------------------------------------------------------ ( 2, 3 ] 1 0.000% 0.000% ( 3, 4 ] 3 0.000% 0.000% ( 4, 6 ] 31 0.004% 0.004% ( 6, 10 ] 230 0.027% 0.031% ( 10, 15 ] 149 0.018% 0.049% ( 15, 22 ] 433 0.051% 0.100% ( 22, 34 ] 14004 1.655% 1.755% ( 34, 51 ] 5513 0.652% 2.407% ( 51, 76 ] 781 0.092% 2.499% ( 76, 110 ] 373 0.044% 2.544% ( 110, 170 ] 297628 35.181% 37.724% ####### ( 170, 250 ] 352779 41.700% 79.424% ######## ( 250, 380 ] 90696 10.721% 90.145% ## ( 380, 580 ] 39278 4.643% 94.788% # ( 580, 870 ] 19262 2.277% 97.064% ( 870, 1300 ] 10920 1.291% 98.355% ( 1300, 1900 ] 5215 0.616% 98.972% ( 1900, 2900 ] 3411 0.403% 99.375% ( 2900, 4400 ] 2840 0.336% 99.711% ( 4400, 6600 ] 973 0.115% 99.826% ( 6600, 9900 ] 294 0.035% 99.860% ( 9900, 14000 ] 489 0.058% 99.918% ( 14000, 22000 ] 512 0.061% 99.979% ( 22000, 33000 ] 140 0.017% 99.995% ( 33000, 50000 ] 28 0.003% 99.998% ( 50000, 75000 ] 12 0.001% 100.000% ( 75000, 110000 ] 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 : 17644735 rocksdb.bloom.filter.full.positive COUNT : 1017348 rocksdb.bloom.filter.full.true.positive COUNT : 845577 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 : 419 rocksdb.memtable.miss COUNT : 845577 rocksdb.l0.hit COUNT : 32326 rocksdb.l1.hit COUNT : 8393 rocksdb.l2andup.hit COUNT : 804858 rocksdb.compaction.key.drop.new COUNT : 226069 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 : 6174676 rocksdb.number.keys.read COUNT : 845996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6372265632 rocksdb.bytes.read COUNT : 845996000 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 : 1723 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 36446565 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 : 26372385620 rocksdb.compact.write.bytes COUNT : 26141274257 rocksdb.flush.write.bytes COUNT : 6341479542 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 : 23 rocksdb.number.superversion_acquires COUNT : 1224 rocksdb.number.superversion_releases COUNT : 1186 rocksdb.number.superversion_cleanups COUNT : 309 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 : 349 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 : 6290317312 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2421760 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 : 30461626575 rocksdb.non.last.level.read.count COUNT : 7219471 rocksdb.block.checksum.compute.count COUNT : 7417746 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 : 192.346854 P95 : 605.276935 P99 : 1967.873090 P100 : 76965.000000 COUNT : 845996 SUM : 239433959 rocksdb.db.write.micros P50 : 1.538103 P95 : 4.342768 P99 : 8.890352 P100 : 911384.000000 COUNT : 6174676 SUM : 52075987 rocksdb.compaction.times.micros P50 : 1375000.000000 P95 : 2890000.000000 P99 : 6470666.666667 P100 : 6753709.000000 COUNT : 104 SUM : 173611974 rocksdb.compaction.times.cpu_micros P50 : 937714.285714 P95 : 2300000.000000 P99 : 4281333.333333 P100 : 5288948.000000 COUNT : 104 SUM : 106190919 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 : 826.891892 P95 : 149000.000000 P99 : 400528.000000 P100 : 400528.000000 COUNT : 87 SUM : 1722000 rocksdb.compaction.outfile.sync.micros P50 : 20720.000000 P95 : 237428.571429 P99 : 414200.000000 P100 : 596554.000000 COUNT : 346 SUM : 21031813 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 : 371.875000 P95 : 3891.071429 P99 : 6517.500000 P100 : 9006.000000 COUNT : 215 SUM : 219177 rocksdb.table.open.io.micros P50 : 8526.136364 P95 : 18973.469388 P99 : 21786.530612 P100 : 47352.000000 COUNT : 1723 SUM : 14563554 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 : 4.121103 P95 : 9.781724 P99 : 157.568859 P100 : 36204.000000 COUNT : 6387274 SUM : 86942688 rocksdb.read.block.get.micros P50 : 139.447406 P95 : 501.222150 P99 : 1773.066130 P100 : 36221.000000 COUNT : 1028769 SUM : 199548762 rocksdb.write.raw.block.micros P50 : 0.538149 P95 : 1.412937 P99 : 3.944173 P100 : 44056.000000 COUNT : 7867634 SUM : 24331021 rocksdb.numfiles.in.singlecompaction P50 : 2.944444 P95 : 5.877778 P99 : 13.450000 P100 : 29.000000 COUNT : 131 SUM : 473 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.592682 P95 : 2214.041768 P99 : 2764.377524 P100 : 911211.000000 COUNT : 119244 SUM : 36461659 rocksdb.sst.read.micros P50 : 2.167905 P95 : 157.303194 P99 : 511.824594 P100 : 36217.000000 COUNT : 7219540 SUM : 266266011 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 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 845996 SUM : 845996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 6174676 SUM : 6372265632 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 : 228000.000000 P95 : 953500.000000 P99 : 1139739.000000 P100 : 1139739.000000 COUNT : 87 SUM : 28650604 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 : 360 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