[2024-10-13 07:47:00.186985] Starting SPDK v25.01-pre git sha1 bbce7a874 / DPDK 24.11.0-rc0 initialization... [2024-10-13 07:47:00.187136] [ 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_pid3059921 ] Set seed to 1728798420183480 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-10-13 07:47:00.347573] pci_dpdk.c: 37:dpdk_pci_init: *NOTICE*: In-development DPDK 24.11.0-rc0 is used. There is no support for it in SPDK. Enabled only for validation. [2024-10-13 07:47:00.389642] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-10-13 07:47:00.413017] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-10-13 07:47:00.413057] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3059921' to capture a snapshot of events at runtime. [2024-10-13 07:47:00.413070] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-10-13 07:47:00.413079] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-10-13 07:47:00.413089] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3059921 for offline analysis/debug. [2024-10-13 07:47:00.413651] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sun Oct 13 07:47:04 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/10/13-07:47:12 ... thread 0: (1000000,1000000) ops and (132583.4,132583.4) ops/second in (7.542422,7.542422) 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/8 818.85 MB 12.6 0.0 0.0 0.0 0.8 0.8 0.0 1.0 0.0 122.3 6.70 2.41 9 0.744 0 0 0.0 0.0 L1 3/3 211.73 MB 0.0 0.4 0.3 0.1 0.4 0.3 0.0 1.2 107.8 107.7 3.85 1.93 1 3.853 421K 514 0.0 0.0 L2 4/0 257.94 MB 2.6 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 L3 50/9 3.53 GB 2.7 2.9 1.7 1.1 2.8 1.7 0.0 1.7 96.1 95.1 30.47 13.95 18 1.693 1654K 473 0.0 0.0 L4 190/17 11.71 GB 1.1 2.6 2.2 0.4 2.6 2.2 0.1 1.2 102.8 102.5 25.73 12.29 22 1.170 796K 357 0.0 0.0 L5 1088/0 89.45 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 1344/37 105.94 GB 0.0 5.8 4.3 1.6 6.6 5.0 0.3 8.3 89.7 101.4 66.76 30.57 50 1.335 2873K 1344 0.0 0.0 Int 0/0 0.00 KB 0.0 5.8 4.3 1.6 6.6 5.0 0.3 8.3 89.7 101.4 66.76 30.57 50 1.335 2873K 1344 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.8 4.3 1.6 5.8 4.2 0.0 0.0 99.7 99.1 60.06 28.17 41 1.465 2873K 1344 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 122.3 6.70 2.41 9 0.744 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): 7.8 total, 7.5 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: 6.61 GB write, 873.55 MB/s write, 5.85 GB read, 772.79 MB/s read, 66.8 seconds Interval compaction: 6.61 GB write, 897.42 MB/s write, 5.85 GB read, 793.91 MB/s read, 66.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: 36, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 36, interval: 36 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 238126 Average: 10.7504 StdDev: 138.19 Min: 1 Median: 1.8910 Max: 14225 Percentiles: P50: 1.89 P75: 2.87 P99: 10.70 P99.9: 2130.44 P99.99: 4345.53 ------------------------------------------------------ [ 0, 1 ] 7998 3.359% 3.359% # ( 1, 2 ] 124650 52.346% 55.705% ########## ( 2, 3 ] 52664 22.116% 77.821% #### ( 3, 4 ] 22376 9.397% 87.218% ## ( 4, 6 ] 22961 9.642% 96.860% ## ( 6, 10 ] 4969 2.087% 98.947% ( 10, 15 ] 926 0.389% 99.336% ( 15, 22 ] 119 0.050% 99.386% ( 22, 34 ] 18 0.008% 99.393% ( 34, 51 ] 10 0.004% 99.397% ( 51, 76 ] 8 0.003% 99.401% ( 76, 110 ] 6 0.003% 99.403% ( 110, 170 ] 23 0.010% 99.413% ( 170, 250 ] 53 0.022% 99.435% ( 250, 380 ] 119 0.050% 99.485% ( 380, 580 ] 212 0.089% 99.574% ( 580, 870 ] 309 0.130% 99.704% ( 870, 1300 ] 274 0.115% 99.819% ( 1300, 1900 ] 161 0.068% 99.887% ( 1900, 2900 ] 147 0.062% 99.948% ( 2900, 4400 ] 105 0.044% 99.992% ( 4400, 6600 ] 37 0.016% 100.008% ( 6600, 9900 ] 5 0.002% 100.010% ( 14000, 22000 ] 1 0.000% 100.010% ** Level 1 read latency histogram (micros): Count: 53591 Average: 15.9551 StdDev: 190.10 Min: 1 Median: 2.0381 Max: 7409 Percentiles: P50: 2.04 P75: 3.17 P99: 14.04 P99.9: 3553.81 P99.99: 6143.33 ------------------------------------------------------ [ 0, 1 ] 1316 2.456% 2.456% ( 1, 2 ] 24986 46.624% 49.079% ######### ( 2, 3 ] 12937 24.140% 73.219% ##### ( 3, 4 ] 5783 10.791% 84.010% ## ( 4, 6 ] 6240 11.644% 95.654% ## ( 6, 10 ] 1538 2.870% 98.524% # ( 10, 15 ] 317 0.592% 99.116% ( 15, 22 ] 54 0.101% 99.216% ( 22, 34 ] 4 0.007% 99.224% ( 34, 51 ] 3 0.006% 99.229% ( 51, 76 ] 3 0.006% 99.235% ( 76, 110 ] 1 0.002% 99.237% ( 110, 170 ] 5 0.009% 99.246% ( 170, 250 ] 8 0.015% 99.261% ( 250, 380 ] 11 0.021% 99.282% ( 380, 580 ] 50 0.093% 99.375% ( 580, 870 ] 82 0.153% 99.528% ( 870, 1300 ] 65 0.121% 99.649% ( 1300, 1900 ] 68 0.127% 99.776% ( 1900, 2900 ] 43 0.080% 99.856% ( 2900, 4400 ] 56 0.104% 99.961% ( 4400, 6600 ] 21 0.039% 100.000% ( 6600, 9900 ] 1 0.002% 100.002% ** Level 2 read latency histogram (micros): Count: 382528 Average: 15.3552 StdDev: 188.62 Min: 1 Median: 2.0393 Max: 12391 Percentiles: P50: 2.04 P75: 3.13 P99: 13.29 P99.9: 1998.84 P99.99: 2943.08 ------------------------------------------------------ [ 0, 1 ] 9649 2.522% 2.522% # ( 1, 2 ] 177919 46.511% 49.034% ######### ( 2, 3 ] 93940 24.558% 73.591% ##### ( 3, 4 ] 41357 10.811% 84.403% ## ( 4, 6 ] 42653 11.150% 95.553% ## ( 6, 10 ] 11470 2.998% 98.552% # ( 10, 15 ] 2608 0.682% 99.234% ( 15, 22 ] 353 0.092% 99.326% ( 22, 34 ] 92 0.024% 99.350% ( 34, 51 ] 35 0.009% 99.359% ( 51, 76 ] 26 0.007% 99.366% ( 76, 110 ] 19 0.005% 99.371% ( 110, 170 ] 63 0.016% 99.387% ( 170, 250 ] 141 0.037% 99.424% ( 250, 380 ] 227 0.059% 99.483% ( 380, 580 ] 386 0.101% 99.584% ( 580, 870 ] 469 0.123% 99.707% ( 870, 1300 ] 410 0.107% 99.814% ( 1300, 1900 ] 292 0.076% 99.890% ( 1900, 2900 ] 369 0.096% 99.987% ( 2900, 4400 ] 409 0.107% 100.094% ( 4400, 6600 ] 140 0.037% 100.130% ( 6600, 9900 ] 18 0.005% 100.135% ( 9900, 14000 ] 2 0.001% 100.136% ** Level 3 read latency histogram (micros): Count: 954215 Average: 13.6603 StdDev: 170.35 Min: 1 Median: 1.9950 Max: 13410 Percentiles: P50: 1.99 P75: 2.98 P99: 10.07 P99.9: 1149.42 P99.99: 1611.93 ------------------------------------------------------ [ 0, 1 ] 14891 1.561% 1.561% ( 1, 2 ] 464551 48.684% 50.245% ########## ( 2, 3 ] 241122 25.269% 75.514% ##### ( 3, 4 ] 101308 10.617% 86.131% ## ( 4, 6 ] 99575 10.435% 96.566% ## ( 6, 10 ] 23163 2.427% 98.993% ( 10, 15 ] 4652 0.488% 99.481% ( 15, 22 ] 575 0.060% 99.541% ( 22, 34 ] 66 0.007% 99.548% ( 34, 51 ] 54 0.006% 99.554% ( 51, 76 ] 58 0.006% 99.560% ( 76, 110 ] 32 0.003% 99.563% ( 110, 170 ] 59 0.006% 99.569% ( 170, 250 ] 176 0.018% 99.588% ( 250, 380 ] 359 0.038% 99.625% ( 380, 580 ] 743 0.078% 99.703% ( 580, 870 ] 1136 0.119% 99.822% ( 870, 1300 ] 1140 0.119% 99.942% ( 1300, 1900 ] 884 0.093% 100.034% ( 1900, 2900 ] 814 0.085% 100.120% ( 2900, 4400 ] 841 0.088% 100.208% ( 4400, 6600 ] 218 0.023% 100.231% ( 6600, 9900 ] 39 0.004% 100.235% ( 9900, 14000 ] 6 0.001% 100.235% ** Level 4 read latency histogram (micros): Count: 172115 Average: 41.5325 StdDev: 313.46 Min: 1 Median: 1.9711 Max: 10585 Percentiles: P50: 1.97 P75: 2.98 P99: 1232.69 P99.9: 4034.94 P99.99: 5038.94 ------------------------------------------------------ [ 0, 1 ] 2688 1.562% 1.562% ( 1, 2 ] 85851 49.880% 51.442% ########## ( 2, 3 ] 41573 24.154% 75.596% ##### ( 3, 4 ] 17784 10.333% 85.929% ## ( 4, 6 ] 15751 9.151% 95.080% ## ( 6, 10 ] 3312 1.924% 97.004% ( 10, 15 ] 595 0.346% 97.350% ( 15, 22 ] 57 0.033% 97.383% ( 22, 34 ] 7 0.004% 97.387% ( 34, 51 ] 14 0.008% 97.395% ( 51, 76 ] 9 0.005% 97.401% ( 76, 110 ] 17 0.010% 97.410% ( 110, 170 ] 50 0.029% 97.440% ( 170, 250 ] 121 0.070% 97.510% ( 250, 380 ] 274 0.159% 97.669% ( 380, 580 ] 581 0.338% 98.007% ( 580, 870 ] 892 0.518% 98.525% ( 870, 1300 ] 972 0.565% 99.090% ( 1300, 1900 ] 602 0.350% 99.439% ( 1900, 2900 ] 437 0.254% 99.693% ( 2900, 4400 ] 473 0.275% 99.968% ( 4400, 6600 ] 137 0.080% 100.048% ( 6600, 9900 ] 27 0.016% 100.063% ( 9900, 14000 ] 3 0.002% 100.065% ** Level 5 read latency histogram (micros): Count: 12853 Average: 1700.2048 StdDev: 1517.42 Min: 85 Median: 1141.9090 Max: 12782 Percentiles: P50: 1141.91 P75: 2397.13 P99: 7365.04 P99.9: 9860.03 P99.99: 12782.00 ------------------------------------------------------ ( 76, 110 ] 27 0.210% 0.210% ( 110, 170 ] 92 0.716% 0.926% ( 170, 250 ] 308 2.396% 3.322% ( 250, 380 ] 778 6.053% 9.375% # ( 380, 580 ] 1488 11.577% 20.952% ## ( 580, 870 ] 2281 17.747% 38.699% #### ( 870, 1300 ] 2297 17.871% 56.570% #### ( 1300, 1900 ] 1633 12.705% 69.276% ### ( 1900, 2900 ] 1480 11.515% 80.790% ## ( 2900, 4400 ] 1636 12.729% 93.519% ### ( 4400, 6600 ] 669 5.205% 98.724% # ( 6600, 9900 ] 153 1.190% 99.914% ( 9900, 14000 ] 11 0.086% 100.000% ** DB Stats ** Uptime(secs): 7.8 total, 7.5 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 126.98 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.517 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, 130.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:3.517 H:M:S, 46.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 10 num-running-flushes: 1 2024/10/13-07:47:17 ... thread 0: (1000000,2000000) ops and (177174.1,151669.3) ops/second in (5.644166,13.186588) 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/8 1.41 GB 31.5 0.7 0.0 0.7 2.5 1.8 0.0 1.4 42.1 152.9 16.47 8.06 24 0.686 703K 921 0.0 0.0 L1 3/3 256.19 MB 0.0 1.0 0.7 0.3 1.0 0.7 0.0 1.4 111.3 111.1 9.03 4.69 2 4.514 1020K 1871 0.0 0.0 L2 2/1 160.11 MB 0.3 0.0 0.0 0.0 0.0 0.0 0.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 24/8 1.57 GB 0.9 4.0 2.0 2.0 4.0 2.0 0.1 1.9 107.9 107.1 37.94 19.43 23 1.649 2474K 2232 0.0 0.0 L4 166/12 9.78 GB 0.9 6.6 4.3 2.3 6.5 4.2 0.4 1.5 113.2 112.0 59.43 31.11 45 1.321 2569K 357 0.0 0.0 L5 1140/0 93.69 GB 1.0 0.0 0.0 0.0 0.0 0.0 4.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1347/32 106.86 GB 0.0 12.2 7.0 5.2 13.9 8.7 5.3 7.8 101.9 115.9 122.87 63.28 94 1.307 6768K 5381 0.0 0.0 Int 0/0 0.00 KB 0.0 12.2 7.0 5.2 13.9 8.7 5.3 7.8 101.9 115.9 122.87 63.28 94 1.307 6768K 5381 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 12.2 7.0 5.2 12.1 6.9 0.0 0.0 113.4 112.4 110.44 58.05 72 1.534 6768K 5381 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 146.9 12.44 5.23 22 0.565 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): 13.4 total, 13.2 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: 13.90 GB write, 1063.01 MB/s write, 12.23 GB read, 934.65 MB/s read, 122.9 seconds Interval compaction: 13.90 GB write, 1079.63 MB/s write, 12.23 GB read, 949.26 MB/s read, 122.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 56, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 56, interval: 56 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 478766 Average: 10.3458 StdDev: 129.31 Min: 1 Median: 1.8601 Max: 14225 Percentiles: P50: 1.86 P75: 2.81 P99: 10.19 P99.9: 1836.09 P99.99: 4117.22 ------------------------------------------------------ [ 0, 1 ] 18261 3.814% 3.814% # ( 1, 2 ] 257076 53.696% 57.510% ########### ( 2, 3 ] 103528 21.624% 79.134% #### ( 3, 4 ] 42871 8.954% 88.088% ## ( 4, 6 ] 43303 9.045% 97.133% ## ( 6, 10 ] 8881 1.855% 98.988% ( 10, 15 ] 1570 0.328% 99.316% ( 15, 22 ] 185 0.039% 99.354% ( 22, 34 ] 20 0.004% 99.359% ( 34, 51 ] 17 0.004% 99.362% ( 51, 76 ] 18 0.004% 99.366% ( 76, 110 ] 14 0.003% 99.369% ( 110, 170 ] 54 0.011% 99.380% ( 170, 250 ] 127 0.027% 99.407% ( 250, 380 ] 284 0.059% 99.466% ( 380, 580 ] 511 0.107% 99.573% ( 580, 870 ] 686 0.143% 99.716% ( 870, 1300 ] 598 0.125% 99.841% ( 1300, 1900 ] 317 0.066% 99.907% ( 1900, 2900 ] 247 0.052% 99.959% ( 2900, 4400 ] 185 0.039% 99.997% ( 4400, 6600 ] 62 0.013% 100.010% ( 6600, 9900 ] 6 0.001% 100.011% ( 9900, 14000 ] 1 0.000% 100.012% ( 14000, 22000 ] 1 0.000% 100.012% ** Level 1 read latency histogram (micros): Count: 187643 Average: 12.8863 StdDev: 151.67 Min: 1 Median: 1.9777 Max: 7409 Percentiles: P50: 1.98 P75: 2.95 P99: 13.64 P99.9: 2359.78 P99.99: 4364.25 ------------------------------------------------------ [ 0, 1 ] 3368 1.795% 1.795% ( 1, 2 ] 92515 49.304% 51.099% ########## ( 2, 3 ] 47124 25.114% 76.212% ##### ( 3, 4 ] 18427 9.820% 86.033% ## ( 4, 6 ] 19062 10.159% 96.191% ## ( 6, 10 ] 4676 2.492% 98.683% ( 10, 15 ] 817 0.435% 99.119% ( 15, 22 ] 103 0.055% 99.173% ( 22, 34 ] 8 0.004% 99.178% ( 34, 51 ] 16 0.009% 99.186% ( 51, 76 ] 18 0.010% 99.196% ( 76, 110 ] 3 0.002% 99.197% ( 110, 170 ] 38 0.020% 99.218% ( 170, 250 ] 74 0.039% 99.257% ( 250, 380 ] 130 0.069% 99.326% ( 380, 580 ] 259 0.138% 99.464% ( 580, 870 ] 335 0.179% 99.643% ( 870, 1300 ] 270 0.144% 99.787% ( 1300, 1900 ] 166 0.088% 99.875% ( 1900, 2900 ] 103 0.055% 99.930% ( 2900, 4400 ] 116 0.062% 99.992% ( 4400, 6600 ] 40 0.021% 100.013% ( 6600, 9900 ] 2 0.001% 100.014% ** Level 2 read latency histogram (micros): Count: 396441 Average: 15.1381 StdDev: 187.03 Min: 1 Median: 2.0388 Max: 12391 Percentiles: P50: 2.04 P75: 3.13 P99: 13.25 P99.9: 1984.61 P99.99: 2955.91 ------------------------------------------------------ [ 0, 1 ] 9858 2.487% 2.487% ( 1, 2 ] 184578 46.559% 49.045% ######### ( 2, 3 ] 97440 24.579% 73.624% ##### ( 3, 4 ] 42825 10.802% 84.426% ## ( 4, 6 ] 44220 11.154% 95.581% ## ( 6, 10 ] 11833 2.985% 98.565% # ( 10, 15 ] 2654 0.669% 99.235% ( 15, 22 ] 363 0.092% 99.327% ( 22, 34 ] 93 0.023% 99.350% ( 34, 51 ] 38 0.010% 99.360% ( 51, 76 ] 26 0.007% 99.366% ( 76, 110 ] 19 0.005% 99.371% ( 110, 170 ] 67 0.017% 99.388% ( 170, 250 ] 147 0.037% 99.425% ( 250, 380 ] 239 0.060% 99.485% ( 380, 580 ] 405 0.102% 99.587% ( 580, 870 ] 488 0.123% 99.710% ( 870, 1300 ] 423 0.107% 99.817% ( 1300, 1900 ] 297 0.075% 99.892% ( 1900, 2900 ] 373 0.094% 99.986% ( 2900, 4400 ] 412 0.104% 100.090% ( 4400, 6600 ] 141 0.036% 100.126% ( 6600, 9900 ] 18 0.005% 100.130% ( 9900, 14000 ] 3 0.001% 100.131% ** Level 3 read latency histogram (micros): Count: 1614492 Average: 11.3001 StdDev: 146.41 Min: 1 Median: 1.9739 Max: 13410 Percentiles: P50: 1.97 P75: 2.95 P99: 9.84 P99.9: 959.05 P99.99: 1353.33 ------------------------------------------------------ [ 0, 1 ] 24013 1.487% 1.487% ( 1, 2 ] 804197 49.811% 51.298% ########## ( 2, 3 ] 403596 24.998% 76.297% ##### ( 3, 4 ] 165317 10.240% 86.536% ## ( 4, 6 ] 162932 10.092% 96.628% ## ( 6, 10 ] 39868 2.469% 99.098% ( 10, 15 ] 7033 0.436% 99.533% ( 15, 22 ] 830 0.051% 99.585% ( 22, 34 ] 88 0.005% 99.590% ( 34, 51 ] 93 0.006% 99.596% ( 51, 76 ] 116 0.007% 99.603% ( 76, 110 ] 54 0.003% 99.606% ( 110, 170 ] 157 0.010% 99.616% ( 170, 250 ] 419 0.026% 99.642% ( 250, 380 ] 714 0.044% 99.686% ( 380, 580 ] 1277 0.079% 99.765% ( 580, 870 ] 1822 0.113% 99.878% ( 870, 1300 ] 1707 0.106% 99.984% ( 1300, 1900 ] 1120 0.069% 100.053% ( 1900, 2900 ] 1011 0.063% 100.116% ( 2900, 4400 ] 1016 0.063% 100.179% ( 4400, 6600 ] 265 0.016% 100.195% ( 6600, 9900 ] 43 0.003% 100.198% ( 9900, 14000 ] 10 0.001% 100.199% ** Level 4 read latency histogram (micros): Count: 655884 Average: 22.5870 StdDev: 216.87 Min: 1 Median: 1.9743 Max: 15358 Percentiles: P50: 1.97 P75: 2.98 P99: 546.94 P99.9: 2439.24 P99.99: 3264.88 ------------------------------------------------------ [ 0, 1 ] 10077 1.536% 1.536% ( 1, 2 ] 326259 49.743% 51.280% ########## ( 2, 3 ] 159493 24.317% 75.597% ##### ( 3, 4 ] 66748 10.177% 85.774% ## ( 4, 6 ] 65132 9.930% 95.704% ## ( 6, 10 ] 16003 2.440% 98.144% ( 10, 15 ] 2595 0.396% 98.540% ( 15, 22 ] 270 0.041% 98.581% ( 22, 34 ] 18 0.003% 98.584% ( 34, 51 ] 53 0.008% 98.592% ( 51, 76 ] 72 0.011% 98.603% ( 76, 110 ] 41 0.006% 98.609% ( 110, 170 ] 169 0.026% 98.635% ( 170, 250 ] 389 0.059% 98.694% ( 250, 380 ] 781 0.119% 98.813% ( 380, 580 ] 1469 0.224% 99.037% ( 580, 870 ] 2137 0.326% 99.363% ( 870, 1300 ] 1948 0.297% 99.660% ( 1300, 1900 ] 1120 0.171% 99.831% ( 1900, 2900 ] 844 0.129% 99.959% ( 2900, 4400 ] 828 0.126% 100.086% ( 4400, 6600 ] 240 0.037% 100.122% ( 6600, 9900 ] 36 0.005% 100.128% ( 9900, 14000 ] 6 0.001% 100.129% ( 14000, 22000 ] 1 0.000% 100.129% ** Level 5 read latency histogram (micros): Count: 29908 Average: 1305.1065 StdDev: 1284.69 Min: 80 Median: 842.5326 Max: 18528 Percentiles: P50: 842.53 P75: 1604.57 P99: 6322.64 P99.9: 9613.97 P99.99: 13416.98 ------------------------------------------------------ ( 76, 110 ] 87 0.291% 0.291% ( 110, 170 ] 527 1.762% 2.053% ( 170, 250 ] 1331 4.450% 6.503% # ( 250, 380 ] 2649 8.857% 15.360% ## ( 380, 580 ] 4673 15.625% 30.985% ### ( 580, 870 ] 6282 21.004% 51.989% #### ( 870, 1300 ] 5315 17.771% 69.761% #### ( 1300, 1900 ] 3087 10.322% 80.082% ## ( 1900, 2900 ] 2426 8.112% 88.194% ## ( 2900, 4400 ] 2455 8.209% 96.402% ## ( 4400, 6600 ] 889 2.972% 99.375% # ( 6600, 9900 ] 172 0.575% 99.950% ( 9900, 14000 ] 14 0.047% 99.997% ( 14000, 22000 ] 2 0.007% 100.003% ** DB Stats ** Uptime(secs): 13.4 total, 5.6 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 146.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:5.258 H:M:S, 39.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 174.38 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:1.741 H:M:S, 30.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 8 num-running-flushes: 1 2024/10/13-07:47:22 ... thread 0: (1000000,3000000) ops and (219230.9,169033.2) ops/second in (4.561400,17.747988) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 10/4 1.54 GB 132.2 1.7 0.0 1.7 4.5 2.8 0.0 1.6 70.1 182.6 25.18 15.08 42 0.599 1790K 2016 0.0 0.0 L1 8/0 708.48 MB 70.8 2.1 1.6 0.5 2.1 1.5 0.0 1.3 140.1 139.6 15.29 9.89 3 5.097 2175K 6812 0.0 0.0 L2 5/4 454.83 MB 1.3 0.0 0.0 0.0 0.0 0.0 0.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L3 17/8 955.03 MB 0.5 4.5 2.2 2.3 4.5 2.1 0.1 2.1 112.4 111.6 41.00 21.80 24 1.709 2604K 2232 0.0 0.0 L4 169/0 9.52 GB 1.0 8.8 5.0 3.7 8.7 4.9 0.4 1.7 119.9 118.4 74.95 41.45 57 1.315 3977K 6238 0.0 0.0 L5 1152/0 94.67 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.2 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1361/16 107.80 GB 0.0 17.1 8.8 8.3 19.7 11.4 6.7 7.1 111.9 129.0 156.43 88.23 126 1.241 10M 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 17.1 8.8 8.3 19.7 11.4 6.7 7.1 111.9 129.0 156.43 88.23 126 1.241 10M 17K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 17.1 8.8 8.3 16.9 8.6 0.0 0.0 125.1 124.0 139.87 80.21 90 1.554 10M 17K 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 171.2 16.56 8.02 36 0.460 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 18.0 total, 17.7 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: 19.71 GB write, 1123.92 MB/s write, 17.09 GB read, 974.78 MB/s read, 156.4 seconds Interval compaction: 19.71 GB write, 1136.97 MB/s write, 17.09 GB read, 986.10 MB/s read, 156.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: 64, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 64, interval: 64 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 870819 Average: 8.5613 StdDev: 107.10 Min: 1 Median: 1.7628 Max: 14225 Percentiles: P50: 1.76 P75: 2.59 P99: 10.93 P99.9: 1184.06 P99.99: 2611.87 ------------------------------------------------------ [ 0, 1 ] 56522 6.491% 6.491% # ( 1, 2 ] 496675 57.035% 63.526% ########### ( 2, 3 ] 169003 19.407% 82.933% #### ( 3, 4 ] 64867 7.449% 90.382% # ( 4, 6 ] 61170 7.024% 97.407% # ( 6, 10 ] 13470 1.547% 98.954% ( 10, 15 ] 2179 0.250% 99.204% ( 15, 22 ] 260 0.030% 99.234% ( 22, 34 ] 25 0.003% 99.237% ( 34, 51 ] 23 0.003% 99.239% ( 51, 76 ] 22 0.003% 99.242% ( 76, 110 ] 273 0.031% 99.273% ( 110, 170 ] 1060 0.122% 99.395% ( 170, 250 ] 915 0.105% 99.500% ( 250, 380 ] 882 0.101% 99.601% ( 380, 580 ] 1003 0.115% 99.716% ( 580, 870 ] 1021 0.117% 99.834% ( 870, 1300 ] 793 0.091% 99.925% ( 1300, 1900 ] 377 0.043% 99.968% ( 1900, 2900 ] 271 0.031% 99.999% ( 2900, 4400 ] 232 0.027% 100.026% ( 4400, 6600 ] 69 0.008% 100.034% ( 6600, 9900 ] 9 0.001% 100.035% ( 9900, 14000 ] 2 0.000% 100.035% ( 14000, 22000 ] 1 0.000% 100.035% ** Level 1 read latency histogram (micros): Count: 286194 Average: 10.8934 StdDev: 134.89 Min: 1 Median: 1.9387 Max: 14314 Percentiles: P50: 1.94 P75: 2.89 P99: 12.49 P99.9: 1713.28 P99.99: 3802.13 ------------------------------------------------------ [ 0, 1 ] 5469 1.911% 1.911% ( 1, 2 ] 146616 51.230% 53.141% ########## ( 2, 3 ] 70189 24.525% 77.665% ##### ( 3, 4 ] 26508 9.262% 86.928% ## ( 4, 6 ] 27025 9.443% 96.371% ## ( 6, 10 ] 6986 2.441% 98.812% ( 10, 15 ] 1083 0.378% 99.190% ( 15, 22 ] 134 0.047% 99.237% ( 22, 34 ] 10 0.003% 99.240% ( 34, 51 ] 19 0.007% 99.247% ( 51, 76 ] 21 0.007% 99.254% ( 76, 110 ] 30 0.010% 99.265% ( 110, 170 ] 138 0.048% 99.313% ( 170, 250 ] 182 0.064% 99.377% ( 250, 380 ] 247 0.086% 99.463% ( 380, 580 ] 383 0.134% 99.597% ( 580, 870 ] 420 0.147% 99.744% ( 870, 1300 ] 321 0.112% 99.856% ( 1300, 1900 ] 187 0.065% 99.921% ( 1900, 2900 ] 123 0.043% 99.964% ( 2900, 4400 ] 127 0.044% 100.008% ( 4400, 6600 ] 47 0.016% 100.025% ( 6600, 9900 ] 3 0.001% 100.026% ( 14000, 22000 ] 1 0.000% 100.026% ** Level 2 read latency histogram (micros): Count: 396441 Average: 15.1381 StdDev: 187.03 Min: 1 Median: 2.0388 Max: 12391 Percentiles: P50: 2.04 P75: 3.13 P99: 13.25 P99.9: 1984.61 P99.99: 2955.91 ------------------------------------------------------ [ 0, 1 ] 9858 2.487% 2.487% ( 1, 2 ] 184578 46.559% 49.045% ######### ( 2, 3 ] 97440 24.579% 73.624% ##### ( 3, 4 ] 42825 10.802% 84.426% ## ( 4, 6 ] 44220 11.154% 95.581% ## ( 6, 10 ] 11833 2.985% 98.565% # ( 10, 15 ] 2654 0.669% 99.235% ( 15, 22 ] 363 0.092% 99.327% ( 22, 34 ] 93 0.023% 99.350% ( 34, 51 ] 38 0.010% 99.360% ( 51, 76 ] 26 0.007% 99.366% ( 76, 110 ] 19 0.005% 99.371% ( 110, 170 ] 67 0.017% 99.388% ( 170, 250 ] 147 0.037% 99.425% ( 250, 380 ] 239 0.060% 99.485% ( 380, 580 ] 405 0.102% 99.587% ( 580, 870 ] 488 0.123% 99.710% ( 870, 1300 ] 423 0.107% 99.817% ( 1300, 1900 ] 297 0.075% 99.892% ( 1900, 2900 ] 373 0.094% 99.986% ( 2900, 4400 ] 412 0.104% 100.090% ( 4400, 6600 ] 141 0.036% 100.126% ( 6600, 9900 ] 18 0.005% 100.130% ( 9900, 14000 ] 3 0.001% 100.131% ** Level 3 read latency histogram (micros): Count: 1805100 Average: 10.8615 StdDev: 141.58 Min: 1 Median: 1.9673 Max: 13410 Percentiles: P50: 1.97 P75: 2.94 P99: 9.83 P99.9: 943.15 P99.99: 1362.71 ------------------------------------------------------ [ 0, 1 ] 27245 1.509% 1.509% ( 1, 2 ] 904851 50.127% 51.637% ########## ( 2, 3 ] 449516 24.903% 76.539% ##### ( 3, 4 ] 183263 10.153% 86.692% ## ( 4, 6 ] 180596 10.005% 96.697% ## ( 6, 10 ] 43385 2.403% 99.100% ( 10, 15 ] 7574 0.420% 99.520% ( 15, 22 ] 884 0.049% 99.569% ( 22, 34 ] 93 0.005% 99.574% ( 34, 51 ] 100 0.006% 99.579% ( 51, 76 ] 128 0.007% 99.586% ( 76, 110 ] 114 0.006% 99.593% ( 110, 170 ] 330 0.018% 99.611% ( 170, 250 ] 598 0.033% 99.644% ( 250, 380 ] 882 0.049% 99.693% ( 380, 580 ] 1461 0.081% 99.774% ( 580, 870 ] 1968 0.109% 99.883% ( 870, 1300 ] 1810 0.100% 99.983% ( 1300, 1900 ] 1172 0.065% 100.048% ( 1900, 2900 ] 1051 0.058% 100.106% ( 2900, 4400 ] 1059 0.059% 100.165% ( 4400, 6600 ] 278 0.015% 100.180% ( 6600, 9900 ] 44 0.002% 100.183% ( 9900, 14000 ] 10 0.001% 100.183% ** Level 4 read latency histogram (micros): Count: 977003 Average: 20.4922 StdDev: 201.86 Min: 1 Median: 1.9646 Max: 15358 Percentiles: P50: 1.96 P75: 2.96 P99: 426.75 P99.9: 2162.85 P99.99: 3050.14 ------------------------------------------------------ [ 0, 1 ] 14816 1.516% 1.516% ( 1, 2 ] 491074 50.263% 51.780% ########## ( 2, 3 ] 237199 24.278% 76.058% ##### ( 3, 4 ] 96535 9.881% 85.939% ## ( 4, 6 ] 94105 9.632% 95.571% ## ( 6, 10 ] 23636 2.419% 97.990% ( 10, 15 ] 3819 0.391% 98.381% ( 15, 22 ] 409 0.042% 98.423% ( 22, 34 ] 25 0.003% 98.425% ( 34, 51 ] 64 0.007% 98.432% ( 51, 76 ] 90 0.009% 98.441% ( 76, 110 ] 339 0.035% 98.476% ( 110, 170 ] 1380 0.141% 98.617% ( 170, 250 ] 1416 0.145% 98.762% ( 250, 380 ] 1743 0.178% 98.940% ( 380, 580 ] 2494 0.255% 99.196% ( 580, 870 ] 2908 0.298% 99.493% ( 870, 1300 ] 2396 0.245% 99.738% ( 1300, 1900 ] 1302 0.133% 99.872% ( 1900, 2900 ] 1050 0.107% 99.979% ( 2900, 4400 ] 1052 0.108% 100.087% ( 4400, 6600 ] 311 0.032% 100.119% ( 6600, 9900 ] 54 0.006% 100.124% ( 9900, 14000 ] 9 0.001% 100.125% ( 14000, 22000 ] 1 0.000% 100.125% ** Level 5 read latency histogram (micros): Count: 58782 Average: 881.0680 StdDev: 1095.08 Min: 76 Median: 514.7959 Max: 18600 Percentiles: P50: 514.80 P75: 1024.16 P99: 5721.77 P99.9: 9150.65 P99.99: 13157.10 ------------------------------------------------------ ( 51, 76 ] 3 0.005% 0.005% ( 76, 110 ] 1878 3.195% 3.200% # ( 110, 170 ] 7302 12.422% 15.622% ## ( 170, 250 ] 6773 11.522% 27.144% ## ( 250, 380 ] 7260 12.351% 39.495% ## ( 380, 580 ] 9162 15.586% 55.081% ### ( 580, 870 ] 9277 15.782% 70.864% ### ( 870, 1300 ] 6782 11.538% 82.401% ## ( 1300, 1900 ] 3602 6.128% 88.529% # ( 1900, 2900 ] 2797 4.758% 93.287% # ( 2900, 4400 ] 2776 4.723% 98.010% # ( 4400, 6600 ] 969 1.648% 99.658% ( 6600, 9900 ] 184 0.313% 99.971% ( 9900, 14000 ] 14 0.024% 99.995% ( 14000, 22000 ] 5 0.009% 100.003% ** DB Stats ** Uptime(secs): 18.0 total, 4.6 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 164.43 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.990 H:M:S, 33.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 215.76 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.732 H:M:S, 16.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 5 num-running-flushes: 1 2024/10/13-07:47:26 ... thread 0: (1000000,4000000) ops and (247247.0,183549.2) ops/second in (4.044539,21.792527) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 16/15 2.52 GB 12.6 2.5 0.0 2.5 6.2 3.7 0.0 1.7 78.2 197.4 32.22 20.94 60 0.537 2558K 2718 0.0 0.0 L1 8/8 708.48 MB 0.0 2.1 1.6 0.5 2.1 1.5 0.0 1.3 140.1 139.6 15.29 9.89 3 5.097 2175K 6812 0.0 0.0 L3 19/0 926.72 MB 0.9 5.5 2.6 2.9 5.5 2.6 0.1 2.1 122.1 121.2 46.42 26.60 29 1.601 3677K 8020 0.0 0.0 L4 173/0 9.64 GB 1.0 10.3 5.5 4.8 10.1 5.4 0.4 1.8 125.3 123.6 83.84 48.26 63 1.331 5143K 7250 0.0 0.0 L5 1156/0 94.98 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1372/23 108.74 GB 0.0 20.3 9.7 10.7 23.9 13.2 6.0 6.4 117.2 137.7 177.76 105.70 155 1.147 13M 24K 0.0 0.0 Int 0/0 0.00 KB 0.0 20.3 9.7 10.7 23.9 13.2 6.0 6.4 117.2 137.7 177.76 105.70 155 1.147 13M 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 20.3 9.7 10.7 20.2 9.5 0.0 0.0 132.4 131.2 157.33 94.85 104 1.513 13M 24K 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 188.0 20.44 10.85 51 0.401 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): 22.0 total, 21.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: 23.90 GB write, 1112.61 MB/s write, 20.34 GB read, 946.81 MB/s read, 177.8 seconds Interval compaction: 23.90 GB write, 1123.14 MB/s write, 20.34 GB read, 955.76 MB/s read, 177.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: 67, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 67, interval: 67 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1069077 Average: 9.4573 StdDev: 105.55 Min: 1 Median: 1.7638 Max: 16483 Percentiles: P50: 1.76 P75: 2.60 P99: 147.47 P99.9: 1155.57 P99.99: 2615.04 ------------------------------------------------------ [ 0, 1 ] 69648 6.515% 6.515% # ( 1, 2 ] 608641 56.931% 63.446% ########### ( 2, 3 ] 205448 19.217% 82.664% #### ( 3, 4 ] 79608 7.446% 90.110% # ( 4, 6 ] 73858 6.909% 97.019% # ( 6, 10 ] 15044 1.407% 98.426% ( 10, 15 ] 2585 0.242% 98.668% ( 15, 22 ] 308 0.029% 98.696% ( 22, 34 ] 32 0.003% 98.699% ( 34, 51 ] 35 0.003% 98.703% ( 51, 76 ] 26 0.002% 98.705% ( 76, 110 ] 902 0.084% 98.789% ( 110, 170 ] 3605 0.337% 99.127% ( 170, 250 ] 2590 0.242% 99.369% ( 250, 380 ] 1837 0.172% 99.541% ( 380, 580 ] 1795 0.168% 99.709% ( 580, 870 ] 1420 0.133% 99.841% ( 870, 1300 ] 944 0.088% 99.930% ( 1300, 1900 ] 422 0.039% 99.969% ( 1900, 2900 ] 312 0.029% 99.998% ( 2900, 4400 ] 258 0.024% 100.023% ( 4400, 6600 ] 72 0.007% 100.029% ( 6600, 9900 ] 10 0.001% 100.030% ( 9900, 14000 ] 3 0.000% 100.030% ( 14000, 22000 ] 2 0.000% 100.031% ** Level 1 read latency histogram (micros): Count: 383948 Average: 9.3353 StdDev: 119.00 Min: 1 Median: 1.9158 Max: 14314 Percentiles: P50: 1.92 P75: 2.84 P99: 11.22 P99.9: 1321.92 P99.99: 3279.01 ------------------------------------------------------ [ 0, 1 ] 7300 1.901% 1.901% ( 1, 2 ] 201664 52.524% 54.425% ########### ( 2, 3 ] 94123 24.515% 78.940% ##### ( 3, 4 ] 33869 8.821% 87.761% ## ( 4, 6 ] 33717 8.782% 96.543% ## ( 6, 10 ] 9104 2.371% 98.914% ( 10, 15 ] 1355 0.353% 99.267% ( 15, 22 ] 156 0.041% 99.307% ( 22, 34 ] 11 0.003% 99.310% ( 34, 51 ] 21 0.005% 99.316% ( 51, 76 ] 21 0.005% 99.321% ( 76, 110 ] 68 0.018% 99.339% ( 110, 170 ] 281 0.073% 99.412% ( 170, 250 ] 290 0.076% 99.487% ( 250, 380 ] 318 0.083% 99.570% ( 380, 580 ] 451 0.117% 99.688% ( 580, 870 ] 469 0.122% 99.810% ( 870, 1300 ] 339 0.088% 99.898% ( 1300, 1900 ] 193 0.050% 99.948% ( 1900, 2900 ] 126 0.033% 99.981% ( 2900, 4400 ] 133 0.035% 100.016% ( 4400, 6600 ] 47 0.012% 100.028% ( 6600, 9900 ] 4 0.001% 100.029% ( 14000, 22000 ] 1 0.000% 100.029% ** Level 2 read latency histogram (micros): Count: 396441 Average: 15.1381 StdDev: 187.03 Min: 1 Median: 2.0388 Max: 12391 Percentiles: P50: 2.04 P75: 3.13 P99: 13.25 P99.9: 1984.61 P99.99: 2955.91 ------------------------------------------------------ [ 0, 1 ] 9858 2.487% 2.487% ( 1, 2 ] 184578 46.559% 49.045% ######### ( 2, 3 ] 97440 24.579% 73.624% ##### ( 3, 4 ] 42825 10.802% 84.426% ## ( 4, 6 ] 44220 11.154% 95.581% ## ( 6, 10 ] 11833 2.985% 98.565% # ( 10, 15 ] 2654 0.669% 99.235% ( 15, 22 ] 363 0.092% 99.327% ( 22, 34 ] 93 0.023% 99.350% ( 34, 51 ] 38 0.010% 99.360% ( 51, 76 ] 26 0.007% 99.366% ( 76, 110 ] 19 0.005% 99.371% ( 110, 170 ] 67 0.017% 99.388% ( 170, 250 ] 147 0.037% 99.425% ( 250, 380 ] 239 0.060% 99.485% ( 380, 580 ] 405 0.102% 99.587% ( 580, 870 ] 488 0.123% 99.710% ( 870, 1300 ] 423 0.107% 99.817% ( 1300, 1900 ] 297 0.075% 99.892% ( 1900, 2900 ] 373 0.094% 99.986% ( 2900, 4400 ] 412 0.104% 100.090% ( 4400, 6600 ] 141 0.036% 100.126% ( 6600, 9900 ] 18 0.005% 100.130% ( 9900, 14000 ] 3 0.001% 100.131% ** Level 3 read latency histogram (micros): Count: 2110839 Average: 9.9923 StdDev: 132.71 Min: 1 Median: 1.9462 Max: 13410 Percentiles: P50: 1.95 P75: 2.90 P99: 9.75 P99.9: 863.79 P99.99: 1294.26 ------------------------------------------------------ [ 0, 1 ] 35818 1.697% 1.697% ( 1, 2 ] 1077524 51.047% 52.744% ########## ( 2, 3 ] 519682 24.620% 77.364% ##### ( 3, 4 ] 207871 9.848% 87.212% ## ( 4, 6 ] 203161 9.625% 96.836% ## ( 6, 10 ] 48745 2.309% 99.145% ( 10, 15 ] 8232 0.390% 99.535% ( 15, 22 ] 948 0.045% 99.580% ( 22, 34 ] 110 0.005% 99.586% ( 34, 51 ] 122 0.006% 99.591% ( 51, 76 ] 141 0.007% 99.598% ( 76, 110 ] 160 0.008% 99.606% ( 110, 170 ] 601 0.028% 99.634% ( 170, 250 ] 813 0.039% 99.673% ( 250, 380 ] 1071 0.051% 99.723% ( 380, 580 ] 1680 0.080% 99.803% ( 580, 870 ] 2094 0.099% 99.902% ( 870, 1300 ] 1880 0.089% 99.991% ( 1300, 1900 ] 1194 0.057% 100.048% ( 1900, 2900 ] 1083 0.051% 100.099% ( 2900, 4400 ] 1085 0.051% 100.150% ( 4400, 6600 ] 284 0.013% 100.164% ( 6600, 9900 ] 45 0.002% 100.166% ( 9900, 14000 ] 10 0.000% 100.167% ** Level 4 read latency histogram (micros): Count: 1205199 Average: 19.4262 StdDev: 190.12 Min: 0 Median: 1.9507 Max: 15358 Percentiles: P50: 1.95 P75: 2.94 P99: 387.37 P99.9: 1933.45 P99.99: 2868.52 ------------------------------------------------------ [ 0, 1 ] 21867 1.814% 1.814% ( 1, 2 ] 610869 50.686% 52.501% ########## ( 2, 3 ] 288208 23.914% 76.414% ##### ( 3, 4 ] 116187 9.640% 86.055% ## ( 4, 6 ] 113043 9.380% 95.434% ## ( 6, 10 ] 28772 2.387% 97.822% ( 10, 15 ] 4447 0.369% 98.191% ( 15, 22 ] 483 0.040% 98.231% ( 22, 34 ] 32 0.003% 98.233% ( 34, 51 ] 122 0.010% 98.244% ( 51, 76 ] 132 0.011% 98.254% ( 76, 110 ] 707 0.059% 98.313% ( 110, 170 ] 2904 0.241% 98.554% ( 170, 250 ] 2592 0.215% 98.769% ( 250, 380 ] 2660 0.221% 98.990% ( 380, 580 ] 3311 0.275% 99.265% ( 580, 870 ] 3522 0.292% 99.557% ( 870, 1300 ] 2680 0.222% 99.779% ( 1300, 1900 ] 1417 0.118% 99.897% ( 1900, 2900 ] 1160 0.096% 99.993% ( 2900, 4400 ] 1146 0.095% 100.088% ( 4400, 6600 ] 325 0.027% 100.115% ( 6600, 9900 ] 56 0.005% 100.120% ( 9900, 14000 ] 10 0.001% 100.121% ( 14000, 22000 ] 1 0.000% 100.121% ** Level 5 read latency histogram (micros): Count: 88021 Average: 715.5625 StdDev: 967.90 Min: 76 Median: 384.7472 Max: 18600 Percentiles: P50: 384.74 P75: 801.30 P99: 5121.15 P99.9: 8659.93 P99.99: 12140.73 ------------------------------------------------------ ( 51, 76 ] 3 0.003% 0.003% ( 76, 110 ] 3737 4.246% 4.249% # ( 110, 170 ] 15544 17.659% 21.908% #### ( 170, 250 ] 12764 14.501% 36.409% ### ( 250, 380 ] 11649 13.234% 49.644% ### ( 380, 580 ] 13250 15.053% 64.697% ### ( 580, 870 ] 11885 13.502% 78.200% ### ( 870, 1300 ] 7933 9.013% 87.212% ## ( 1300, 1900 ] 3915 4.448% 91.660% # ( 1900, 2900 ] 3147 3.575% 95.235% # ( 2900, 4400 ] 2986 3.392% 98.628% # ( 4400, 6600 ] 1003 1.140% 99.767% ( 6600, 9900 ] 189 0.215% 99.982% ( 9900, 14000 ] 15 0.017% 99.999% ( 14000, 22000 ] 6 0.007% 100.006% ** DB Stats ** Uptime(secs): 22.0 total, 4.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 178.94 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.230 H:M:S, 28.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 243.34 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.240 H:M:S, 5.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/10/13-07:47:32 ... thread 0: (1000000,5000000) ops and (165120.5,179541.5) ops/second in (6.056185,27.848712) 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/17 3.50 GB 0.0 3.7 0.0 3.7 8.4 4.7 0.0 1.8 93.8 214.1 40.30 28.50 81 0.498 3837K 3934 0.0 0.0 L1 8/8 708.48 MB 0.0 2.1 1.6 0.5 2.1 1.5 0.0 1.3 140.1 139.6 15.29 9.89 3 5.097 2175K 6812 0.0 0.0 L3 19/0 926.72 MB 0.9 5.5 2.6 2.9 5.5 2.6 0.1 2.1 122.1 121.2 46.42 26.60 29 1.601 3677K 8020 0.0 0.0 L4 173/0 9.64 GB 1.0 10.3 5.5 4.8 10.1 5.4 0.4 1.8 125.3 123.6 83.84 48.26 63 1.331 5143K 7250 0.0 0.0 L5 1156/0 94.98 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1373/25 109.73 GB 0.0 21.6 9.7 11.9 26.1 14.2 6.0 5.5 118.9 143.9 185.84 113.26 176 1.056 14M 26K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.6 9.7 11.9 26.1 14.2 6.0 5.5 118.9 143.9 185.84 113.26 176 1.056 14M 26K 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.6 9.7 11.9 21.4 9.5 0.0 0.0 136.2 135.0 162.21 99.66 109 1.488 14M 26K 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 205.3 23.63 13.61 67 0.353 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 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.12 GB write, 953.24 MB/s write, 21.57 GB read, 787.34 MB/s read, 185.8 seconds Interval compaction: 26.12 GB write, 960.30 MB/s write, 21.57 GB read, 793.17 MB/s read, 185.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 10, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 10, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 67, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 67, interval: 77 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1444724 Average: 12.2224 StdDev: 97.31 Min: 0 Median: 1.6900 Max: 16483 Percentiles: P50: 1.69 P75: 2.49 P99: 219.95 P99.9: 903.26 P99.99: 1825.73 ------------------------------------------------------ [ 0, 1 ] 168139 11.638% 11.638% ## ( 1, 2 ] 803203 55.596% 67.234% ########### ( 2, 3 ] 230643 15.965% 83.198% ### ( 3, 4 ] 90802 6.285% 89.483% # ( 4, 6 ] 79615 5.511% 94.994% # ( 6, 10 ] 16204 1.122% 96.116% ( 10, 15 ] 2996 0.207% 96.323% ( 15, 22 ] 367 0.025% 96.348% ( 22, 34 ] 37 0.003% 96.351% ( 34, 51 ] 37 0.003% 96.354% ( 51, 76 ] 32 0.002% 96.356% ( 76, 110 ] 6713 0.465% 96.820% ( 110, 170 ] 25344 1.754% 98.575% ( 170, 250 ] 9841 0.681% 99.256% ( 250, 380 ] 3981 0.276% 99.531% ( 380, 580 ] 3439 0.238% 99.769% ( 580, 870 ] 1809 0.125% 99.895% ( 870, 1300 ] 999 0.069% 99.964% ( 1300, 1900 ] 432 0.030% 99.994% ( 1900, 2900 ] 332 0.023% 100.017% ( 2900, 4400 ] 272 0.019% 100.036% ( 4400, 6600 ] 72 0.005% 100.040% ( 6600, 9900 ] 10 0.001% 100.041% ( 9900, 14000 ] 3 0.000% 100.041% ( 14000, 22000 ] 2 0.000% 100.042% ** Level 1 read latency histogram (micros): Count: 385404 Average: 9.9544 StdDev: 119.37 Min: 1 Median: 1.9194 Max: 14314 Percentiles: P50: 1.92 P75: 2.85 P99: 97.43 P99.9: 1317.40 P99.99: 3277.36 ------------------------------------------------------ [ 0, 1 ] 7300 1.894% 1.894% ( 1, 2 ] 201664 52.325% 54.219% ########## ( 2, 3 ] 94123 24.422% 78.641% ##### ( 3, 4 ] 33869 8.788% 87.429% ## ( 4, 6 ] 33717 8.748% 96.178% ## ( 6, 10 ] 9104 2.362% 98.540% ( 10, 15 ] 1355 0.352% 98.892% ( 15, 22 ] 156 0.040% 98.932% ( 22, 34 ] 11 0.003% 98.935% ( 34, 51 ] 21 0.005% 98.940% ( 51, 76 ] 22 0.006% 98.946% ( 76, 110 ] 330 0.086% 99.032% ( 110, 170 ] 1037 0.269% 99.301% ( 170, 250 ] 567 0.147% 99.448% ( 250, 380 ] 394 0.102% 99.550% ( 380, 580 ] 519 0.135% 99.685% ( 580, 870 ] 481 0.125% 99.810% ( 870, 1300 ] 343 0.089% 99.899% ( 1300, 1900 ] 193 0.050% 99.949% ( 1900, 2900 ] 126 0.033% 99.981% ( 2900, 4400 ] 133 0.035% 100.016% ( 4400, 6600 ] 47 0.012% 100.028% ( 6600, 9900 ] 4 0.001% 100.029% ( 14000, 22000 ] 1 0.000% 100.029% ** Level 2 read latency histogram (micros): Count: 396441 Average: 15.1381 StdDev: 187.03 Min: 1 Median: 2.0388 Max: 12391 Percentiles: P50: 2.04 P75: 3.13 P99: 13.25 P99.9: 1984.61 P99.99: 2955.91 ------------------------------------------------------ [ 0, 1 ] 9858 2.487% 2.487% ( 1, 2 ] 184578 46.559% 49.045% ######### ( 2, 3 ] 97440 24.579% 73.624% ##### ( 3, 4 ] 42825 10.802% 84.426% ## ( 4, 6 ] 44220 11.154% 95.581% ## ( 6, 10 ] 11833 2.985% 98.565% # ( 10, 15 ] 2654 0.669% 99.235% ( 15, 22 ] 363 0.092% 99.327% ( 22, 34 ] 93 0.023% 99.350% ( 34, 51 ] 38 0.010% 99.360% ( 51, 76 ] 26 0.007% 99.366% ( 76, 110 ] 19 0.005% 99.371% ( 110, 170 ] 67 0.017% 99.388% ( 170, 250 ] 147 0.037% 99.425% ( 250, 380 ] 239 0.060% 99.485% ( 380, 580 ] 405 0.102% 99.587% ( 580, 870 ] 488 0.123% 99.710% ( 870, 1300 ] 423 0.107% 99.817% ( 1300, 1900 ] 297 0.075% 99.892% ( 1900, 2900 ] 373 0.094% 99.986% ( 2900, 4400 ] 412 0.104% 100.090% ( 4400, 6600 ] 141 0.036% 100.126% ( 6600, 9900 ] 18 0.005% 100.130% ( 9900, 14000 ] 3 0.001% 100.131% ** Level 3 read latency histogram (micros): Count: 2112691 Average: 10.1116 StdDev: 132.76 Min: 1 Median: 1.9471 Max: 13410 Percentiles: P50: 1.95 P75: 2.91 P99: 9.88 P99.9: 863.72 P99.99: 1294.45 ------------------------------------------------------ [ 0, 1 ] 35818 1.695% 1.695% ( 1, 2 ] 1077560 51.004% 52.700% ########## ( 2, 3 ] 519761 24.602% 77.301% ##### ( 3, 4 ] 207934 9.842% 87.144% ## ( 4, 6 ] 203235 9.620% 96.763% ## ( 6, 10 ] 48748 2.307% 99.071% ( 10, 15 ] 8235 0.390% 99.460% ( 15, 22 ] 948 0.045% 99.505% ( 22, 34 ] 110 0.005% 99.510% ( 34, 51 ] 122 0.006% 99.516% ( 51, 76 ] 141 0.007% 99.523% ( 76, 110 ] 421 0.020% 99.543% ( 110, 170 ] 1498 0.071% 99.614% ( 170, 250 ] 1109 0.052% 99.666% ( 250, 380 ] 1142 0.054% 99.720% ( 380, 580 ] 1731 0.082% 99.802% ( 580, 870 ] 2111 0.100% 99.902% ( 870, 1300 ] 1880 0.089% 99.991% ( 1300, 1900 ] 1194 0.057% 100.048% ( 1900, 2900 ] 1084 0.051% 100.099% ( 2900, 4400 ] 1085 0.051% 100.150% ( 4400, 6600 ] 284 0.013% 100.164% ( 6600, 9900 ] 45 0.002% 100.166% ( 9900, 14000 ] 10 0.000% 100.166% ** Level 4 read latency histogram (micros): Count: 1221155 Average: 21.1923 StdDev: 190.05 Min: 0 Median: 1.9634 Max: 15358 Percentiles: P50: 1.96 P75: 2.98 P99: 416.21 P99.9: 1925.64 P99.99: 2869.83 ------------------------------------------------------ [ 0, 1 ] 21867 1.791% 1.791% ( 1, 2 ] 611071 50.040% 51.831% ########## ( 2, 3 ] 288665 23.639% 75.470% ##### ( 3, 4 ] 116604 9.549% 85.018% ## ( 4, 6 ] 113478 9.293% 94.311% ## ( 6, 10 ] 28835 2.361% 96.672% ( 10, 15 ] 4462 0.365% 97.038% ( 15, 22 ] 488 0.040% 97.078% ( 22, 34 ] 32 0.003% 97.080% ( 34, 51 ] 122 0.010% 97.090% ( 51, 76 ] 137 0.011% 97.102% ( 76, 110 ] 3222 0.264% 97.365% ( 110, 170 ] 10931 0.895% 98.261% ( 170, 250 ] 4963 0.406% 98.667% ( 250, 380 ] 3366 0.276% 98.943% ( 380, 580 ] 3869 0.317% 99.259% ( 580, 870 ] 3672 0.301% 99.560% ( 870, 1300 ] 2698 0.221% 99.781% ( 1300, 1900 ] 1422 0.116% 99.898% ( 1900, 2900 ] 1164 0.095% 99.993% ( 2900, 4400 ] 1150 0.094% 100.087% ( 4400, 6600 ] 325 0.027% 100.114% ( 6600, 9900 ] 56 0.005% 100.118% ( 9900, 14000 ] 10 0.001% 100.119% ( 14000, 22000 ] 1 0.000% 100.119% ** Level 5 read latency histogram (micros): Count: 173180 Average: 448.3679 StdDev: 746.28 Min: 74 Median: 185.4566 Max: 18600 Percentiles: P50: 185.46 P75: 446.48 P99: 4136.42 P99.9: 7103.21 P99.99: 9824.61 ------------------------------------------------------ ( 51, 76 ] 10 0.006% 0.006% ( 76, 110 ] 18476 10.669% 10.674% ## ( 110, 170 ] 62893 36.317% 46.991% ####### ( 170, 250 ] 26971 15.574% 62.565% ### ( 250, 380 ] 15972 9.223% 71.788% ## ( 380, 580 ] 16735 9.663% 81.451% ## ( 580, 870 ] 12756 7.366% 88.817% # ( 870, 1300 ] 8042 4.644% 93.461% # ( 1300, 1900 ] 3936 2.273% 95.733% ( 1900, 2900 ] 3186 1.840% 97.573% ( 2900, 4400 ] 2998 1.731% 99.304% ( 4400, 6600 ] 1003 0.579% 99.883% ( 6600, 9900 ] 189 0.109% 99.992% ( 9900, 14000 ] 15 0.009% 100.001% ( 14000, 22000 ] 6 0.003% 100.005% ** DB Stats ** Uptime(secs): 28.1 total, 6.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 175.39 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:8.658 H:M:S, 30.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 162.51 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.428 H:M:S, 40.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/10/13-07:47:40 ... thread 0: (1000000,6000000) ops and (122553.1,166627.6) ops/second in (8.159728,36.008440) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 18/11 4.42 GB 232.1 5.8 0.0 5.8 11.4 5.6 0.0 2.0 115.4 228.2 51.29 38.99 100 0.513 6011K 12K 0.0 0.0 L1 8/8 708.48 MB 0.0 2.1 1.6 0.5 2.1 1.5 0.0 1.3 140.1 139.6 15.29 9.89 3 5.097 2175K 6812 0.0 0.0 L3 19/0 926.72 MB 0.9 5.5 2.6 2.9 5.5 2.6 0.1 2.1 122.1 121.2 46.42 26.60 29 1.601 3677K 8020 0.0 0.0 L4 173/0 9.64 GB 1.0 10.3 5.5 4.8 10.1 5.4 0.4 1.8 125.3 123.6 83.84 48.26 63 1.331 5143K 7250 0.0 0.0 L5 1156/0 94.98 GB 1.0 0.0 0.0 0.0 0.0 0.0 5.5 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1374/19 110.64 GB 0.0 23.7 9.7 14.0 29.1 15.1 6.0 5.1 123.1 151.5 196.84 123.75 195 1.009 17M 34K 0.0 0.0 Int 0/0 0.00 KB 0.0 23.7 9.7 14.0 29.1 15.1 6.0 5.1 123.1 151.5 196.84 123.75 195 1.009 17M 34K 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 9.7 14.0 23.5 9.5 0.0 0.0 142.3 141.1 170.30 107.64 113 1.507 17M 34K 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 218.4 26.54 16.11 82 0.324 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 36.2 total, 36.0 interval Flush(GB): cumulative 5.660, interval 5.660 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 29.12 GB write, 823.43 MB/s write, 23.66 GB read, 669.06 MB/s read, 196.8 seconds Interval compaction: 29.12 GB write, 828.14 MB/s write, 23.66 GB read, 672.89 MB/s read, 196.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 17, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 17, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 67, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 17, total-stops: 67, interval: 84 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2057728 Average: 14.1917 StdDev: 89.11 Min: 0 Median: 1.6158 Max: 16483 Percentiles: P50: 1.62 P75: 2.29 P99: 235.15 P99.9: 774.70 P99.99: 1278.96 ------------------------------------------------------ [ 0, 1 ] 331787 16.124% 16.124% ### ( 1, 2 ] 1132044 55.014% 71.138% ########### ( 2, 3 ] 269709 13.107% 84.245% ### ( 3, 4 ] 103935 5.051% 89.296% # ( 4, 6 ] 86872 4.222% 93.518% # ( 6, 10 ] 17380 0.845% 94.363% ( 10, 15 ] 3365 0.164% 94.526% ( 15, 22 ] 415 0.020% 94.546% ( 22, 34 ] 43 0.002% 94.548% ( 34, 51 ] 38 0.002% 94.550% ( 51, 76 ] 40 0.002% 94.552% ( 76, 110 ] 16051 0.780% 95.332% ( 110, 170 ] 58459 2.841% 98.173% # ( 170, 250 ] 20891 1.015% 99.188% ( 250, 380 ] 7098 0.345% 99.533% ( 380, 580 ] 5896 0.287% 99.820% ( 580, 870 ] 2455 0.119% 99.939% ( 870, 1300 ] 1099 0.053% 99.993% ( 1300, 1900 ] 444 0.022% 100.014% ( 1900, 2900 ] 366 0.018% 100.032% ( 2900, 4400 ] 291 0.014% 100.046% ( 4400, 6600 ] 73 0.004% 100.050% ( 6600, 9900 ] 10 0.000% 100.050% ( 9900, 14000 ] 3 0.000% 100.050% ( 14000, 22000 ] 2 0.000% 100.050% ** Level 1 read latency histogram (micros): Count: 387242 Average: 10.7051 StdDev: 119.78 Min: 1 Median: 1.9239 Max: 14314 Percentiles: P50: 1.92 P75: 2.87 P99: 150.08 P99.9: 1311.68 P99.99: 3275.29 ------------------------------------------------------ [ 0, 1 ] 7300 1.885% 1.885% ( 1, 2 ] 201664 52.077% 53.962% ########## ( 2, 3 ] 94123 24.306% 78.268% ##### ( 3, 4 ] 33869 8.746% 87.014% ## ( 4, 6 ] 33717 8.707% 95.721% ## ( 6, 10 ] 9104 2.351% 98.072% ( 10, 15 ] 1355 0.350% 98.422% ( 15, 22 ] 156 0.040% 98.462% ( 22, 34 ] 11 0.003% 98.465% ( 34, 51 ] 21 0.005% 98.471% ( 51, 76 ] 22 0.006% 98.476% ( 76, 110 ] 634 0.164% 98.640% ( 110, 170 ] 2086 0.539% 99.179% ( 170, 250 ] 879 0.227% 99.406% ( 250, 380 ] 488 0.126% 99.532% ( 380, 580 ] 576 0.149% 99.681% ( 580, 870 ] 498 0.129% 99.809% ( 870, 1300 ] 348 0.090% 99.899% ( 1300, 1900 ] 193 0.050% 99.949% ( 1900, 2900 ] 126 0.033% 99.981% ( 2900, 4400 ] 133 0.034% 100.016% ( 4400, 6600 ] 47 0.012% 100.028% ( 6600, 9900 ] 4 0.001% 100.029% ( 14000, 22000 ] 1 0.000% 100.029% ** Level 2 read latency histogram (micros): Count: 396441 Average: 15.1381 StdDev: 187.03 Min: 1 Median: 2.0388 Max: 12391 Percentiles: P50: 2.04 P75: 3.13 P99: 13.25 P99.9: 1984.61 P99.99: 2955.91 ------------------------------------------------------ [ 0, 1 ] 9858 2.487% 2.487% ( 1, 2 ] 184578 46.559% 49.045% ######### ( 2, 3 ] 97440 24.579% 73.624% ##### ( 3, 4 ] 42825 10.802% 84.426% ## ( 4, 6 ] 44220 11.154% 95.581% ## ( 6, 10 ] 11833 2.985% 98.565% # ( 10, 15 ] 2654 0.669% 99.235% ( 15, 22 ] 363 0.092% 99.327% ( 22, 34 ] 93 0.023% 99.350% ( 34, 51 ] 38 0.010% 99.360% ( 51, 76 ] 26 0.007% 99.366% ( 76, 110 ] 19 0.005% 99.371% ( 110, 170 ] 67 0.017% 99.388% ( 170, 250 ] 147 0.037% 99.425% ( 250, 380 ] 239 0.060% 99.485% ( 380, 580 ] 405 0.102% 99.587% ( 580, 870 ] 488 0.123% 99.710% ( 870, 1300 ] 423 0.107% 99.817% ( 1300, 1900 ] 297 0.075% 99.892% ( 1900, 2900 ] 373 0.094% 99.986% ( 2900, 4400 ] 412 0.104% 100.090% ( 4400, 6600 ] 141 0.036% 100.126% ( 6600, 9900 ] 18 0.005% 100.130% ( 9900, 14000 ] 3 0.001% 100.131% ** Level 3 read latency histogram (micros): Count: 2115165 Average: 10.3096 StdDev: 132.90 Min: 1 Median: 1.9482 Max: 13410 Percentiles: P50: 1.95 P75: 2.91 P99: 10.58 P99.9: 864.43 P99.99: 1295.09 ------------------------------------------------------ [ 0, 1 ] 35818 1.693% 1.693% ( 1, 2 ] 1077560 50.944% 52.638% ########## ( 2, 3 ] 519761 24.573% 77.211% ##### ( 3, 4 ] 207934 9.831% 87.042% ## ( 4, 6 ] 203235 9.608% 96.650% ## ( 6, 10 ] 48748 2.305% 98.955% ( 10, 15 ] 8235 0.389% 99.344% ( 15, 22 ] 948 0.045% 99.389% ( 22, 34 ] 110 0.005% 99.394% ( 34, 51 ] 122 0.006% 99.400% ( 51, 76 ] 141 0.007% 99.407% ( 76, 110 ] 776 0.037% 99.443% ( 110, 170 ] 2876 0.136% 99.579% ( 170, 250 ] 1551 0.073% 99.653% ( 250, 380 ] 1300 0.061% 99.714% ( 380, 580 ] 1834 0.087% 99.801% ( 580, 870 ] 2142 0.101% 99.902% ( 870, 1300 ] 1884 0.089% 99.991% ( 1300, 1900 ] 1194 0.056% 100.047% ( 1900, 2900 ] 1085 0.051% 100.099% ( 2900, 4400 ] 1087 0.051% 100.150% ( 4400, 6600 ] 284 0.013% 100.164% ( 6600, 9900 ] 45 0.002% 100.166% ( 9900, 14000 ] 10 0.000% 100.166% ** Level 4 read latency histogram (micros): Count: 1241752 Average: 23.5239 StdDev: 189.95 Min: 0 Median: 1.9800 Max: 15358 Percentiles: P50: 1.98 P75: 3.08 P99: 444.97 P99.9: 1913.90 P99.99: 2869.91 ------------------------------------------------------ [ 0, 1 ] 21867 1.761% 1.761% ( 1, 2 ] 611205 49.221% 50.982% ########## ( 2, 3 ] 288962 23.271% 74.253% ##### ( 3, 4 ] 117102 9.430% 83.683% ## ( 4, 6 ] 114007 9.181% 92.864% ## ( 6, 10 ] 28879 2.326% 95.190% ( 10, 15 ] 4483 0.361% 95.551% ( 15, 22 ] 490 0.039% 95.590% ( 22, 34 ] 33 0.003% 95.593% ( 34, 51 ] 122 0.010% 95.603% ( 51, 76 ] 138 0.011% 95.614% ( 76, 110 ] 6232 0.502% 96.116% ( 110, 170 ] 21487 1.730% 97.846% ( 170, 250 ] 8406 0.677% 98.523% ( 250, 380 ] 4404 0.355% 98.878% ( 380, 580 ] 4671 0.376% 99.254% ( 580, 870 ] 3843 0.309% 99.563% ( 870, 1300 ] 2729 0.220% 99.783% ( 1300, 1900 ] 1434 0.115% 99.899% ( 1900, 2900 ] 1169 0.094% 99.993% ( 2900, 4400 ] 1152 0.093% 100.086% ( 4400, 6600 ] 325 0.026% 100.112% ( 6600, 9900 ] 56 0.005% 100.116% ( 9900, 14000 ] 10 0.001% 100.117% ( 14000, 22000 ] 1 0.000% 100.117% ** Level 5 read latency histogram (micros): Count: 283679 Average: 341.4269 StdDev: 602.26 Min: 74 Median: 161.0436 Max: 18600 Percentiles: P50: 161.04 P75: 284.03 P99: 3582.51 P99.9: 6405.49 P99.99: 9509.45 ------------------------------------------------------ ( 51, 76 ] 20 0.007% 0.007% ( 76, 110 ] 35830 12.630% 12.638% ### ( 110, 170 ] 124587 43.918% 56.556% ######### ( 170, 250 ] 46614 16.432% 72.988% ### ( 250, 380 ] 21805 7.687% 80.674% ## ( 380, 580 ] 21299 7.508% 88.182% ## ( 580, 870 ] 13952 4.918% 93.101% # ( 870, 1300 ] 8193 2.888% 95.989% # ( 1300, 1900 ] 3969 1.399% 97.388% ( 1900, 2900 ] 3205 1.130% 98.518% ( 2900, 4400 ] 3007 1.060% 99.578% ( 4400, 6600 ] 1003 0.354% 99.931% ( 6600, 9900 ] 189 0.067% 99.998% ( 9900, 14000 ] 15 0.005% 100.003% ( 14000, 22000 ] 6 0.002% 100.005% ** DB Stats ** Uptime(secs): 36.2 total, 8.2 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 163.05 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:13.136 H:M:S, 36.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 120.62 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.478 H:M:S, 54.9 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 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] readwhilewriting : 283.911 micros/op 14074 ops/sec 60.179 seconds 846996 operations; 13.6 MB/s (208999 of 208999 found) Microseconds per read: Count: 846996 Average: 283.9134 StdDev: 795.21 Min: 2 Median: 185.2755 Max: 74826 Percentiles: P50: 185.28 P75: 247.87 P99: 1842.79 P99.9: 12515.93 P99.99: 31108.70 ------------------------------------------------------ ( 1, 2 ] 3 0.000% 0.000% ( 2, 3 ] 31 0.004% 0.004% ( 3, 4 ] 51 0.006% 0.010% ( 4, 6 ] 79 0.009% 0.019% ( 6, 10 ] 511 0.060% 0.080% ( 10, 15 ] 3455 0.408% 0.488% ( 15, 22 ] 3253 0.384% 0.872% ( 22, 34 ] 7539 0.890% 1.762% ( 34, 51 ] 3171 0.374% 2.136% ( 51, 76 ] 404 0.048% 2.184% ( 76, 110 ] 17422 2.057% 4.241% ( 110, 170 ] 335907 39.659% 43.899% ######## ( 170, 250 ] 270614 31.950% 75.849% ###### ( 250, 380 ] 106019 12.517% 88.366% ### ( 380, 580 ] 49846 5.885% 94.251% # ( 580, 870 ] 24191 2.856% 97.107% # ( 870, 1300 ] 11638 1.374% 98.481% ( 1300, 1900 ] 4855 0.573% 99.055% ( 1900, 2900 ] 3264 0.385% 99.440% ( 2900, 4400 ] 2525 0.298% 99.738% ( 4400, 6600 ] 778 0.092% 99.830% ( 6600, 9900 ] 348 0.041% 99.871% ( 9900, 14000 ] 384 0.045% 99.916% ( 14000, 22000 ] 461 0.054% 99.971% ( 22000, 33000 ] 196 0.023% 99.994% ( 33000, 50000 ] 41 0.005% 99.999% ( 50000, 75000 ] 10 0.001% 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 : 15412562 rocksdb.bloom.filter.full.positive COUNT : 996600 rocksdb.bloom.filter.full.true.positive COUNT : 846561 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 : 435 rocksdb.memtable.miss COUNT : 846561 rocksdb.l0.hit COUNT : 35698 rocksdb.l1.hit COUNT : 5620 rocksdb.l2andup.hit COUNT : 805243 rocksdb.compaction.key.drop.new COUNT : 222261 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 : 6594586 rocksdb.number.keys.read COUNT : 846996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 6805612752 rocksdb.bytes.read COUNT : 846996000 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 : 1754 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 34400312 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 : 28262605292 rocksdb.compact.write.bytes COUNT : 28032685577 rocksdb.flush.write.bytes COUNT : 6803894663 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 : 21 rocksdb.number.superversion_acquires COUNT : 1346 rocksdb.number.superversion_releases COUNT : 1295 rocksdb.number.superversion_cleanups COUNT : 335 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 : 309 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 : 6749046784 rocksdb.memtable.garbage.bytes.at.flush COUNT : 2641920 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 : 32453980292 rocksdb.non.last.level.read.count COUNT : 7699499 rocksdb.block.checksum.compute.count COUNT : 7853060 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 : 183.725264 P95 : 654.602374 P99 : 1842.260223 P100 : 74824.000000 COUNT : 846996 SUM : 239657102 rocksdb.db.write.micros P50 : 1.560354 P95 : 4.437907 P99 : 8.925946 P100 : 798863.000000 COUNT : 6594586 SUM : 51211189 rocksdb.compaction.times.micros P50 : 1308333.333333 P95 : 2970000.000000 P99 : 5642000.000000 P100 : 6261721.000000 COUNT : 117 SUM : 177157817 rocksdb.compaction.times.cpu_micros P50 : 829326.923077 P95 : 1950000.000000 P99 : 5207149.000000 P100 : 5207149.000000 COUNT : 117 SUM : 114398966 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 : 833.750000 P95 : 81125.000000 P99 : 259100.000000 P100 : 326183.000000 COUNT : 93 SUM : 1171647 rocksdb.compaction.outfile.sync.micros P50 : 13772.222222 P95 : 225466.666667 P99 : 436240.000000 P100 : 537003.000000 COUNT : 352 SUM : 17850441 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 : 216.153846 P95 : 2808.823529 P99 : 5639.333333 P100 : 7802.000000 COUNT : 231 SUM : 158093 rocksdb.table.open.io.micros P50 : 8116.009281 P95 : 20612.698413 P99 : 28615.000000 P100 : 32450.000000 COUNT : 1754 SUM : 14990842 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.894544 P95 : 9.887025 P99 : 179.279888 P100 : 16487.000000 COUNT : 6844329 SUM : 99878322 rocksdb.read.block.get.micros P50 : 143.327140 P95 : 532.453831 P99 : 1708.498270 P100 : 18604.000000 COUNT : 1006984 SUM : 206524837 rocksdb.write.raw.block.micros P50 : 0.526977 P95 : 1.037606 P99 : 3.538980 P100 : 19897.000000 COUNT : 8437628 SUM : 24437027 rocksdb.numfiles.in.singlecompaction P50 : 2.785714 P95 : 5.500000 P99 : 9.400000 P100 : 19.000000 COUNT : 145 SUM : 490 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.565253 P95 : 1184.133043 P99 : 2518.996123 P100 : 798668.000000 COUNT : 188930 SUM : 34417822 rocksdb.sst.read.micros P50 : 1.946384 P95 : 162.287016 P99 : 511.812722 P100 : 18600.000000 COUNT : 7699538 SUM : 287959789 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 : 846996 SUM : 846996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 6594586 SUM : 6805612752 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 : 227230.769231 P95 : 822300.000000 P99 : 1063075.000000 P100 : 1063075.000000 COUNT : 93 SUM : 28832236 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 : 382 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