[2024-07-13 15:23:57.255412] Starting SPDK v24.09-pre git sha1 719d03c6a / DPDK 24.07.0-rc2 initialization... [2024-07-13 15:23:57.255537] [ 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_pid3353908 ] Set seed to 1720877037252962 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-07-13 15:23:57.312842] pci_dpdk.c: 37:dpdk_pci_init: *NOTICE*: In-development DPDK 24.07.0-rc2 is used. There is no support for it in SPDK. Enabled only for validation. [2024-07-13 15:23:57.354409] app.c: 908:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-07-13 15:23:57.395778] app.c: 603:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-07-13 15:23:57.395827] app.c: 604:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 3353908' to capture a snapshot of events at runtime. [2024-07-13 15:23:57.395841] app.c: 609:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-07-13 15:23:57.395849] app.c: 610:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-07-13 15:23:57.395859] app.c: 611:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid3353908 for offline analysis/debug. [2024-07-13 15:23:57.395947] reactor.c: 941:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Sat Jul 13 15:24:01 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/07/13-15:24:04 ... thread 0: (1000000,1000000) ops and (335978.6,335978.6) ops/second in (2.976380,2.976380) 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 6/4 440.97 MB 18.9 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 347.0 2.54 2.30 12 0.212 0 0 0.0 0.0 L1 3/0 249.81 MB 25.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 257.4 257.2 0.98 0.95 1 0.979 255K 221 0.0 0.0 L2 3/2 190.88 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 10/0 804.21 MB 0.8 0.0 0.0 0.0 0.0 0.0 0.1 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 GB 0.9 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1182/6 97.00 GB 0.0 0.4 0.4 0.1 1.3 1.2 0.4 1.5 103.7 309.5 4.29 3.98 15 0.286 451K 293 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.4 0.1 1.3 1.2 0.2 1.5 103.7 309.5 4.29 3.98 15 0.286 451K 293 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 0.4 0.4 0.1 0.4 0.4 0.0 0.0 254.9 254.8 1.74 1.68 3 0.581 451K 293 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 347.0 2.54 2.30 12 0.212 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 3.2 total, 3.0 interval Flush(GB): cumulative 0.861, interval 0.861 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 1.30 GB write, 415.20 MB/s write, 0.43 GB read, 139.17 MB/s read, 4.3 seconds Interval compaction: 1.30 GB write, 445.30 MB/s write, 0.43 GB read, 149.26 MB/s read, 4.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: 4, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 4, interval: 4 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 155592 Average: 1.9625 StdDev: 17.72 Min: 1 Median: 1.2949 Max: 3558 Percentiles: P50: 1.29 P75: 1.72 P99: 4.99 P99.9: 9.42 P99.99: 17.07 ------------------------------------------------------ [ 0, 1 ] 50987 32.770% 32.770% ####### ( 1, 2 ] 90910 58.428% 91.198% ############ ( 2, 3 ] 7686 4.940% 96.138% # ( 3, 4 ] 3508 2.255% 98.393% ( 4, 6 ] 1917 1.232% 99.625% ( 6, 10 ] 503 0.323% 99.948% ( 10, 15 ] 63 0.040% 99.988% ( 15, 22 ] 15 0.010% 99.998% ( 22, 34 ] 3 0.002% 100.000% ( 34, 51 ] 4 0.003% 100.003% ( 51, 76 ] 1 0.001% 100.003% ( 110, 170 ] 8 0.005% 100.008% ( 170, 250 ] 3 0.002% 100.010% ( 250, 380 ] 4 0.003% 100.013% ( 380, 580 ] 1 0.001% 100.013% ( 580, 870 ] 2 0.001% 100.015% ( 870, 1300 ] 2 0.001% 100.016% ( 2900, 4400 ] 4 0.003% 100.019% ** Level 1 read latency histogram (micros): Count: 520 Average: 7.3135 StdDev: 36.60 Min: 1 Median: 3.0373 Max: 606 Percentiles: P50: 3.04 P75: 4.02 P99: 33.20 P99.9: 606.00 P99.99: 606.00 ------------------------------------------------------ [ 0, 1 ] 5 0.962% 0.962% ( 1, 2 ] 53 10.192% 11.154% ## ( 2, 3 ] 197 37.885% 49.038% ######## ( 3, 4 ] 134 25.769% 74.808% ##### ( 4, 6 ] 85 16.346% 91.154% ### ( 6, 10 ] 35 6.731% 97.885% # ( 10, 15 ] 2 0.385% 98.269% ( 15, 22 ] 1 0.192% 98.462% ( 22, 34 ] 3 0.577% 99.038% ( 110, 170 ] 1 0.192% 99.231% ( 170, 250 ] 1 0.192% 99.423% ( 250, 380 ] 1 0.192% 99.615% ( 380, 580 ] 1 0.192% 99.808% ( 580, 870 ] 1 0.192% 100.000% ** Level 2 read latency histogram (micros): Count: 41949 Average: 2.3931 StdDev: 11.37 Min: 0 Median: 1.5374 Max: 1116 Percentiles: P50: 1.54 P75: 1.91 P99: 6.19 P99.9: 13.55 P99.99: 367.33 ------------------------------------------------------ [ 0, 1 ] 5783 13.786% 13.786% ### ( 1, 2 ] 28269 67.389% 81.175% ############# ( 2, 3 ] 4248 10.127% 91.301% ## ( 3, 4 ] 1903 4.536% 95.838% # ( 4, 6 ] 1310 3.123% 98.961% # ( 6, 10 ] 350 0.834% 99.795% ( 10, 15 ] 62 0.148% 99.943% ( 15, 22 ] 11 0.026% 99.969% ( 51, 76 ] 3 0.007% 99.976% ( 110, 170 ] 1 0.002% 99.979% ( 170, 250 ] 3 0.007% 99.986% ( 250, 380 ] 2 0.005% 99.990% ( 380, 580 ] 2 0.005% 99.995% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 4 0.010% 100.007% ** Level 3 read latency histogram (micros): Count: 40 Average: 1504.5750 StdDev: 1156.34 Min: 122 Median: 870.0000 Max: 4186 Percentiles: P50: 870.00 P75: 2471.43 P99: 4186.00 P99.9: 4186.00 P99.99: 4186.00 ------------------------------------------------------ ( 110, 170 ] 2 5.000% 5.000% # ( 250, 380 ] 4 10.000% 15.000% ## ( 380, 580 ] 4 10.000% 25.000% ## ( 580, 870 ] 10 25.000% 50.000% ##### ( 870, 1300 ] 3 7.500% 57.500% ## ( 1300, 1900 ] 3 7.500% 65.000% ## ( 1900, 2900 ] 7 17.500% 82.500% #### ( 2900, 4400 ] 7 17.500% 100.000% #### ** Level 4 read latency histogram (micros): Count: 30 Average: 1678.5333 StdDev: 1284.88 Min: 93 Median: 1300.0000 Max: 4333 Percentiles: P50: 1300.00 P75: 2733.33 P99: 4333.00 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ ( 76, 110 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 3 10.000% 20.000% ## ( 580, 870 ] 6 20.000% 40.000% #### ( 870, 1300 ] 3 10.000% 50.000% ## ( 1300, 1900 ] 5 16.667% 66.667% ### ( 1900, 2900 ] 3 10.000% 76.667% ## ( 2900, 4400 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 3.2 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 308.11 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.428 H:M:S, 13.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 330.37 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.428 H:M:S, 14.4 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-15:24:07 ... thread 0: (1000000,2000000) ops and (360121.7,347631.5) ops/second in (2.776839,5.753219) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 14/13 1.35 GB 25.2 0.5 0.0 0.5 2.3 1.8 0.0 1.3 71.7 331.7 7.03 6.45 28 0.251 511K 499 0.0 0.0 L1 3/3 249.81 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.2 1.0 257.4 257.2 0.98 0.95 1 0.979 255K 221 0.0 0.0 L2 1/0 3.50 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 19/0 991.59 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 228.2 228.2 0.82 0.75 1 0.821 190K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1197/16 97.92 GB 0.0 1.1 0.6 0.6 2.9 2.3 0.4 1.6 118.4 308.8 9.59 8.89 32 0.300 1153K 792 0.0 0.0 Int 0/0 0.00 KB 0.0 1.1 0.6 0.6 2.9 2.3 0.2 1.6 118.4 308.8 9.59 8.89 32 0.300 1153K 792 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 1.1 0.6 0.6 1.1 0.6 0.0 0.0 256.1 255.9 4.43 4.26 6 0.739 1153K 792 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 354.4 5.16 4.62 26 0.198 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.0 total, 5.8 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: 2.89 GB write, 496.09 MB/s write, 1.11 GB read, 190.25 MB/s read, 9.6 seconds Interval compaction: 2.89 GB write, 514.70 MB/s write, 1.11 GB read, 197.38 MB/s read, 9.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: 7, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 7, interval: 7 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 401633 Average: 2.0148 StdDev: 13.67 Min: 1 Median: 1.3787 Max: 3558 Percentiles: P50: 1.38 P75: 1.77 P99: 4.90 P99.9: 9.65 P99.99: 14.39 ------------------------------------------------------ [ 0, 1 ] 103691 25.817% 25.817% ##### ( 1, 2 ] 256440 63.849% 89.667% ############# ( 2, 3 ] 25685 6.395% 96.062% # ( 3, 4 ] 9803 2.441% 98.503% ( 4, 6 ] 4432 1.103% 99.606% ( 6, 10 ] 1297 0.323% 99.929% ( 10, 15 ] 281 0.070% 99.999% ( 15, 22 ] 28 0.007% 100.006% ( 22, 34 ] 5 0.001% 100.007% ( 34, 51 ] 4 0.001% 100.008% ( 51, 76 ] 3 0.001% 100.009% ( 110, 170 ] 15 0.004% 100.013% ( 170, 250 ] 10 0.002% 100.015% ( 250, 380 ] 10 0.002% 100.018% ( 380, 580 ] 2 0.000% 100.018% ( 580, 870 ] 6 0.001% 100.020% ( 870, 1300 ] 5 0.001% 100.021% ( 1300, 1900 ] 2 0.000% 100.021% ( 1900, 2900 ] 1 0.000% 100.022% ( 2900, 4400 ] 5 0.001% 100.023% ** Level 1 read latency histogram (micros): Count: 46738 Average: 2.0199 StdDev: 3.98 Min: 1 Median: 1.4305 Max: 606 Percentiles: P50: 1.43 P75: 1.80 P99: 4.98 P99.9: 10.17 P99.99: 129.57 ------------------------------------------------------ [ 0, 1 ] 9914 21.212% 21.212% #### ( 1, 2 ] 31255 66.873% 88.085% ############# ( 2, 3 ] 3595 7.692% 95.776% ## ( 3, 4 ] 1261 2.698% 98.474% # ( 4, 6 ] 503 1.076% 99.551% ( 6, 10 ] 162 0.347% 99.897% ( 10, 15 ] 37 0.079% 99.976% ( 15, 22 ] 3 0.006% 99.983% ( 22, 34 ] 3 0.006% 99.989% ( 110, 170 ] 1 0.002% 99.991% ( 170, 250 ] 1 0.002% 99.994% ( 250, 380 ] 1 0.002% 99.996% ( 380, 580 ] 1 0.002% 99.998% ( 580, 870 ] 1 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47985 Average: 2.3658 StdDev: 10.63 Min: 0 Median: 1.5405 Max: 1116 Percentiles: P50: 1.54 P75: 1.91 P99: 5.97 P99.9: 13.10 P99.99: 328.10 ------------------------------------------------------ [ 0, 1 ] 6472 13.488% 13.488% ### ( 1, 2 ] 32413 67.548% 81.036% ############## ( 2, 3 ] 5146 10.724% 91.760% ## ( 3, 4 ] 2056 4.285% 96.045% # ( 4, 6 ] 1442 3.005% 99.050% # ( 6, 10 ] 369 0.769% 99.819% ( 10, 15 ] 63 0.131% 99.950% ( 15, 22 ] 11 0.023% 99.973% ( 51, 76 ] 3 0.006% 99.979% ( 110, 170 ] 1 0.002% 99.981% ( 170, 250 ] 3 0.006% 99.987% ( 250, 380 ] 2 0.004% 99.992% ( 380, 580 ] 2 0.004% 99.996% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 4 0.008% 100.006% ** Level 3 read latency histogram (micros): Count: 85 Average: 724.2235 StdDev: 1085.34 Min: 1 Median: 120.0000 Max: 4186 Percentiles: P50: 120.00 P75: 837.05 P99: 4186.00 P99.9: 4186.00 P99.99: 4186.00 ------------------------------------------------------ [ 0, 1 ] 16 18.824% 18.824% #### ( 1, 2 ] 17 20.000% 38.824% #### ( 2, 3 ] 1 1.176% 40.000% ( 4, 6 ] 5 5.882% 45.882% # ( 6, 10 ] 2 2.353% 48.235% ( 22, 34 ] 1 1.176% 49.412% ( 110, 170 ] 3 3.529% 52.941% # ( 250, 380 ] 4 4.706% 57.647% # ( 380, 580 ] 5 5.882% 63.529% # ( 580, 870 ] 11 12.941% 76.471% ### ( 870, 1300 ] 3 3.529% 80.000% # ( 1300, 1900 ] 3 3.529% 83.529% # ( 1900, 2900 ] 7 8.235% 91.765% ## ( 2900, 4400 ] 7 8.235% 100.000% ## ** Level 4 read latency histogram (micros): Count: 30 Average: 1678.5333 StdDev: 1284.88 Min: 93 Median: 1300.0000 Max: 4333 Percentiles: P50: 1300.00 P75: 2733.33 P99: 4333.00 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ ( 76, 110 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 3 10.000% 20.000% ## ( 580, 870 ] 6 20.000% 40.000% #### ( 870, 1300 ] 3 10.000% 50.000% ## ( 1300, 1900 ] 5 16.667% 66.667% ### ( 1900, 2900 ] 3 10.000% 76.667% ## ( 2900, 4400 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 6.0 total, 2.8 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 329.65 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.638 H:M:S, 10.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 354.43 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.210 H:M:S, 7.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/13-15:24:10 ... thread 0: (1000000,3000000) ops and (336933.0,343990.6) ops/second in (2.967949,8.721168) 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 1.72 GB 6.3 1.0 0.0 1.0 3.8 2.7 0.0 1.4 91.0 326.4 11.77 10.88 43 0.274 1087K 1113 0.0 0.0 L1 8/8 813.77 MB 0.0 1.0 0.8 0.2 1.0 0.8 0.2 1.3 241.3 240.6 4.43 4.31 2 2.214 1084K 2864 0.0 0.0 L2 1/0 3.50 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 19/0 991.59 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 228.2 228.2 0.82 0.75 1 0.821 190K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1204/23 98.84 GB 0.0 2.5 1.1 1.4 5.2 3.8 0.4 1.9 141.7 297.3 17.78 16.68 48 0.371 2558K 4049 0.0 0.0 Int 0/0 0.00 KB 0.0 2.5 1.1 1.4 5.2 3.8 0.2 1.9 141.7 297.3 17.78 16.68 48 0.371 2558K 4049 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.5 1.1 1.4 2.5 1.1 0.0 0.0 251.5 251.1 10.02 9.72 9 1.113 2558K 4049 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.7 2.7 0.0 0.0 0.0 356.9 7.77 6.96 39 0.199 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 8.9 total, 8.7 interval Flush(GB): cumulative 2.707, interval 2.707 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 5.16 GB write, 591.48 MB/s write, 2.46 GB read, 281.85 MB/s read, 17.8 seconds Interval compaction: 5.16 GB write, 606.12 MB/s write, 2.46 GB read, 288.83 MB/s read, 17.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: 9, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 9, interval: 9 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 699065 Average: 2.0808 StdDev: 11.75 Min: 1 Median: 1.4331 Max: 3558 Percentiles: P50: 1.43 P75: 1.81 P99: 5.21 P99.9: 9.79 P99.99: 14.00 ------------------------------------------------------ [ 0, 1 ] 150238 21.491% 21.491% #### ( 1, 2 ] 460160 65.825% 87.316% ############# ( 2, 3 ] 55262 7.905% 95.221% ## ( 3, 4 ] 20388 2.916% 98.138% # ( 4, 6 ] 9973 1.427% 99.565% ( 6, 10 ] 2478 0.354% 99.919% ( 10, 15 ] 622 0.089% 100.008% ( 15, 22 ] 48 0.007% 100.015% ( 22, 34 ] 14 0.002% 100.017% ( 34, 51 ] 7 0.001% 100.018% ( 51, 76 ] 8 0.001% 100.019% ( 110, 170 ] 19 0.003% 100.022% ( 170, 250 ] 17 0.002% 100.024% ( 250, 380 ] 16 0.002% 100.026% ( 380, 580 ] 4 0.001% 100.027% ( 580, 870 ] 12 0.002% 100.029% ( 870, 1300 ] 7 0.001% 100.030% ( 1300, 1900 ] 3 0.000% 100.030% ( 1900, 2900 ] 3 0.000% 100.031% ( 2900, 4400 ] 5 0.001% 100.031% ** Level 1 read latency histogram (micros): Count: 113741 Average: 2.0857 StdDev: 7.32 Min: 0 Median: 1.4428 Max: 1009 Percentiles: P50: 1.44 P75: 1.82 P99: 5.10 P99.9: 9.82 P99.99: 344.27 ------------------------------------------------------ [ 0, 1 ] 23098 20.308% 20.308% #### ( 1, 2 ] 76267 67.053% 87.361% ############# ( 2, 3 ] 9209 8.096% 95.457% ## ( 3, 4 ] 3214 2.826% 98.283% # ( 4, 6 ] 1477 1.299% 99.582% ( 6, 10 ] 379 0.333% 99.915% ( 10, 15 ] 66 0.058% 99.973% ( 15, 22 ] 6 0.005% 99.978% ( 22, 34 ] 4 0.004% 99.982% ( 34, 51 ] 1 0.001% 99.982% ( 51, 76 ] 1 0.001% 99.983% ( 110, 170 ] 2 0.002% 99.985% ( 170, 250 ] 2 0.002% 99.987% ( 250, 380 ] 5 0.004% 99.991% ( 380, 580 ] 3 0.003% 99.994% ( 580, 870 ] 4 0.004% 99.997% ( 870, 1300 ] 3 0.003% 100.000% ** Level 2 read latency histogram (micros): Count: 47985 Average: 2.3658 StdDev: 10.63 Min: 0 Median: 1.5405 Max: 1116 Percentiles: P50: 1.54 P75: 1.91 P99: 5.97 P99.9: 13.10 P99.99: 328.10 ------------------------------------------------------ [ 0, 1 ] 6472 13.488% 13.488% ### ( 1, 2 ] 32413 67.548% 81.036% ############## ( 2, 3 ] 5146 10.724% 91.760% ## ( 3, 4 ] 2056 4.285% 96.045% # ( 4, 6 ] 1442 3.005% 99.050% # ( 6, 10 ] 369 0.769% 99.819% ( 10, 15 ] 63 0.131% 99.950% ( 15, 22 ] 11 0.023% 99.973% ( 51, 76 ] 3 0.006% 99.979% ( 110, 170 ] 1 0.002% 99.981% ( 170, 250 ] 3 0.006% 99.987% ( 250, 380 ] 2 0.004% 99.992% ( 380, 580 ] 2 0.004% 99.996% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 4 0.008% 100.006% ** Level 3 read latency histogram (micros): Count: 85 Average: 724.2235 StdDev: 1085.34 Min: 1 Median: 120.0000 Max: 4186 Percentiles: P50: 120.00 P75: 837.05 P99: 4186.00 P99.9: 4186.00 P99.99: 4186.00 ------------------------------------------------------ [ 0, 1 ] 16 18.824% 18.824% #### ( 1, 2 ] 17 20.000% 38.824% #### ( 2, 3 ] 1 1.176% 40.000% ( 4, 6 ] 5 5.882% 45.882% # ( 6, 10 ] 2 2.353% 48.235% ( 22, 34 ] 1 1.176% 49.412% ( 110, 170 ] 3 3.529% 52.941% # ( 250, 380 ] 4 4.706% 57.647% # ( 380, 580 ] 5 5.882% 63.529% # ( 580, 870 ] 11 12.941% 76.471% ### ( 870, 1300 ] 3 3.529% 80.000% # ( 1300, 1900 ] 3 3.529% 83.529% # ( 1900, 2900 ] 7 8.235% 91.765% ## ( 2900, 4400 ] 7 8.235% 100.000% ## ** Level 4 read latency histogram (micros): Count: 30 Average: 1678.5333 StdDev: 1284.88 Min: 93 Median: 1300.0000 Max: 4333 Percentiles: P50: 1300.00 P75: 2733.33 P99: 4333.00 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ ( 76, 110 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 3 10.000% 20.000% ## ( 580, 870 ] 6 20.000% 40.000% #### ( 870, 1300 ] 3 10.000% 50.000% ## ( 1300, 1900 ] 5 16.667% 66.667% ### ( 1900, 2900 ] 3 10.000% 76.667% ## ( 2900, 4400 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 8.9 total, 3.0 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.30 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.996 H:M:S, 11.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 331.61 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.358 H:M:S, 12.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/13-15:24:13 ... thread 0: (1000000,4000000) ops and (329575.3,340269.8) ops/second in (3.034208,11.755376) 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 2.70 GB 132.2 2.2 0.0 2.2 5.8 3.7 0.0 1.6 117.2 317.9 18.82 17.54 61 0.308 2238K 2366 0.0 0.0 L1 8/8 813.77 MB 0.0 1.0 0.8 0.2 1.0 0.8 0.2 1.3 241.3 240.6 4.43 4.31 2 2.214 1084K 2864 0.0 0.0 L2 1/0 3.50 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 19/0 991.59 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 228.2 228.2 0.82 0.75 1 0.821 190K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1206/19 99.82 GB 0.0 3.6 1.1 2.5 7.3 4.8 0.4 2.0 147.1 299.1 24.83 23.33 66 0.376 3709K 5302 0.0 0.0 Int 0/0 0.00 KB 0.0 3.6 1.1 2.5 7.3 4.8 0.2 2.0 147.1 299.1 24.83 23.33 66 0.376 3709K 5302 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 3.6 1.1 2.5 3.6 1.1 0.0 0.0 257.2 256.8 14.21 13.83 13 1.093 3709K 5302 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.7 3.7 0.0 0.0 0.0 355.8 10.62 9.50 53 0.200 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 12.0 total, 11.8 interval Flush(GB): cumulative 3.691, interval 3.691 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 7.25 GB write, 620.37 MB/s write, 3.57 GB read, 305.14 MB/s read, 24.8 seconds Interval compaction: 7.25 GB write, 631.76 MB/s write, 3.57 GB read, 310.74 MB/s read, 24.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: 13, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 13, interval: 13 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1038310 Average: 2.1185 StdDev: 11.57 Min: 0 Median: 1.4569 Max: 3558 Percentiles: P50: 1.46 P75: 1.83 P99: 5.29 P99.9: 9.83 P99.99: 13.99 ------------------------------------------------------ [ 0, 1 ] 201614 19.418% 19.418% #### ( 1, 2 ] 694941 66.930% 86.348% ############# ( 2, 3 ] 89279 8.598% 94.946% ## ( 3, 4 ] 31991 3.081% 98.027% # ( 4, 6 ] 15610 1.503% 99.530% ( 6, 10 ] 4013 0.386% 99.917% ( 10, 15 ] 953 0.092% 100.009% ( 15, 22 ] 65 0.006% 100.015% ( 22, 34 ] 17 0.002% 100.017% ( 34, 51 ] 12 0.001% 100.018% ( 51, 76 ] 11 0.001% 100.019% ( 76, 110 ] 9 0.001% 100.020% ( 110, 170 ] 26 0.003% 100.022% ( 170, 250 ] 21 0.002% 100.024% ( 250, 380 ] 21 0.002% 100.026% ( 380, 580 ] 7 0.001% 100.027% ( 580, 870 ] 18 0.002% 100.029% ( 870, 1300 ] 14 0.001% 100.030% ( 1300, 1900 ] 6 0.001% 100.031% ( 1900, 2900 ] 5 0.000% 100.031% ( 2900, 4400 ] 6 0.001% 100.032% ** Level 1 read latency histogram (micros): Count: 189633 Average: 2.1294 StdDev: 6.54 Min: 0 Median: 1.4778 Max: 1123 Percentiles: P50: 1.48 P75: 1.84 P99: 5.29 P99.9: 9.73 P99.99: 234.29 ------------------------------------------------------ [ 0, 1 ] 32518 17.148% 17.148% ### ( 1, 2 ] 130379 68.753% 85.901% ############## ( 2, 3 ] 17197 9.069% 94.970% ## ( 3, 4 ] 5895 3.109% 98.078% # ( 4, 6 ] 2707 1.427% 99.506% ( 6, 10 ] 801 0.422% 99.928% ( 10, 15 ] 84 0.044% 99.973% ( 15, 22 ] 9 0.005% 99.977% ( 22, 34 ] 4 0.002% 99.979% ( 34, 51 ] 1 0.001% 99.980% ( 51, 76 ] 1 0.001% 99.980% ( 76, 110 ] 3 0.002% 99.982% ( 110, 170 ] 7 0.004% 99.986% ( 170, 250 ] 10 0.005% 99.991% ( 250, 380 ] 5 0.003% 99.994% ( 380, 580 ] 4 0.002% 99.996% ( 580, 870 ] 4 0.002% 99.998% ( 870, 1300 ] 4 0.002% 100.000% ** Level 2 read latency histogram (micros): Count: 47985 Average: 2.3658 StdDev: 10.63 Min: 0 Median: 1.5405 Max: 1116 Percentiles: P50: 1.54 P75: 1.91 P99: 5.97 P99.9: 13.10 P99.99: 328.10 ------------------------------------------------------ [ 0, 1 ] 6472 13.488% 13.488% ### ( 1, 2 ] 32413 67.548% 81.036% ############## ( 2, 3 ] 5146 10.724% 91.760% ## ( 3, 4 ] 2056 4.285% 96.045% # ( 4, 6 ] 1442 3.005% 99.050% # ( 6, 10 ] 369 0.769% 99.819% ( 10, 15 ] 63 0.131% 99.950% ( 15, 22 ] 11 0.023% 99.973% ( 51, 76 ] 3 0.006% 99.979% ( 110, 170 ] 1 0.002% 99.981% ( 170, 250 ] 3 0.006% 99.987% ( 250, 380 ] 2 0.004% 99.992% ( 380, 580 ] 2 0.004% 99.996% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 4 0.008% 100.006% ** Level 3 read latency histogram (micros): Count: 85 Average: 724.2235 StdDev: 1085.34 Min: 1 Median: 120.0000 Max: 4186 Percentiles: P50: 120.00 P75: 837.05 P99: 4186.00 P99.9: 4186.00 P99.99: 4186.00 ------------------------------------------------------ [ 0, 1 ] 16 18.824% 18.824% #### ( 1, 2 ] 17 20.000% 38.824% #### ( 2, 3 ] 1 1.176% 40.000% ( 4, 6 ] 5 5.882% 45.882% # ( 6, 10 ] 2 2.353% 48.235% ( 22, 34 ] 1 1.176% 49.412% ( 110, 170 ] 3 3.529% 52.941% # ( 250, 380 ] 4 4.706% 57.647% # ( 380, 580 ] 5 5.882% 63.529% # ( 580, 870 ] 11 12.941% 76.471% ### ( 870, 1300 ] 3 3.529% 80.000% # ( 1300, 1900 ] 3 3.529% 83.529% # ( 1900, 2900 ] 7 8.235% 91.765% ## ( 2900, 4400 ] 7 8.235% 100.000% ## ** Level 4 read latency histogram (micros): Count: 30 Average: 1678.5333 StdDev: 1284.88 Min: 93 Median: 1300.0000 Max: 4333 Percentiles: P50: 1300.00 P75: 2733.33 P99: 4333.00 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ ( 76, 110 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 3 10.000% 20.000% ## ( 580, 870 ] 6 20.000% 40.000% #### ( 870, 1300 ] 3 10.000% 50.000% ## ( 1300, 1900 ] 5 16.667% 66.667% ### ( 1900, 2900 ] 3 10.000% 76.667% ## ( 2900, 4400 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 12.0 total, 3.0 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 328.80 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:1.398 H:M:S, 11.7 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 324.36 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.402 H:M:S, 13.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/07/13-15:24:17 ... thread 0: (1000000,5000000) ops and (245678.3,315941.0) ops/second in (4.070363,15.825739) 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/11 2.58 GB 18.9 3.2 0.0 3.2 7.9 4.7 0.0 1.7 128.2 315.3 25.56 23.90 80 0.320 3326K 3478 0.0 0.0 L1 16/16 1.89 GB 0.0 2.9 1.9 1.0 2.9 1.9 0.2 1.5 236.1 234.7 12.77 12.39 3 4.257 3061K 17K 0.0 0.0 L2 1/0 3.50 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.1 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 19/0 991.59 MB 1.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 228.2 228.2 0.82 0.75 1 0.821 190K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1210/27 100.79 GB 0.0 6.5 2.2 4.3 11.2 6.9 0.4 2.4 167.1 286.5 39.92 37.78 86 0.464 6773K 21K 0.0 0.0 Int 0/0 0.00 KB 0.0 6.5 2.2 4.3 11.2 6.9 0.2 2.4 167.1 286.5 39.92 37.78 86 0.464 6773K 21K 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.5 2.2 4.3 6.5 2.2 0.0 0.0 252.2 251.4 26.45 25.75 18 1.470 6773K 21K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 4.7 4.7 0.0 0.0 0.0 355.6 13.46 12.03 68 0.198 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): 16.0 total, 15.8 interval Flush(GB): cumulative 4.676, interval 4.676 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 11.17 GB write, 712.89 MB/s write, 6.51 GB read, 415.82 MB/s read, 39.9 seconds Interval compaction: 11.17 GB write, 722.62 MB/s write, 6.51 GB read, 421.50 MB/s read, 39.9 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 5, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 5, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 15, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 5, total-stops: 15, interval: 20 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1392769 Average: 2.1897 StdDev: 12.79 Min: 0 Median: 1.4611 Max: 3558 Percentiles: P50: 1.46 P75: 1.83 P99: 5.39 P99.9: 10.30 P99.99: 21.90 ------------------------------------------------------ [ 0, 1 ] 263758 18.938% 18.938% #### ( 1, 2 ] 938302 67.370% 86.307% ############# ( 2, 3 ] 119063 8.549% 94.856% ## ( 3, 4 ] 43188 3.101% 97.957% # ( 4, 6 ] 20931 1.503% 99.460% ( 6, 10 ] 6060 0.435% 99.895% ( 10, 15 ] 1242 0.089% 99.984% ( 15, 22 ] 87 0.006% 99.990% ( 22, 34 ] 17 0.001% 99.991% ( 34, 51 ] 14 0.001% 99.992% ( 51, 76 ] 13 0.001% 99.993% ( 76, 110 ] 94 0.007% 100.000% ( 110, 170 ] 164 0.012% 100.012% ( 170, 250 ] 85 0.006% 100.018% ( 250, 380 ] 70 0.005% 100.023% ( 380, 580 ] 50 0.004% 100.026% ( 580, 870 ] 40 0.003% 100.029% ( 870, 1300 ] 19 0.001% 100.031% ( 1300, 1900 ] 12 0.001% 100.032% ( 1900, 2900 ] 8 0.001% 100.032% ( 2900, 4400 ] 8 0.001% 100.033% ** Level 1 read latency histogram (micros): Count: 285403 Average: 2.3295 StdDev: 11.08 Min: 0 Median: 1.4762 Max: 1640 Percentiles: P50: 1.48 P75: 1.84 P99: 5.83 P99.9: 82.39 P99.99: 569.38 ------------------------------------------------------ [ 0, 1 ] 49995 17.517% 17.517% #### ( 1, 2 ] 194672 68.210% 85.727% ############## ( 2, 3 ] 24947 8.741% 94.468% ## ( 3, 4 ] 8927 3.128% 97.596% # ( 4, 6 ] 4382 1.535% 99.131% ( 6, 10 ] 1988 0.697% 99.828% ( 10, 15 ] 139 0.049% 99.876% ( 15, 22 ] 17 0.006% 99.882% ( 22, 34 ] 5 0.002% 99.884% ( 34, 51 ] 1 0.000% 99.884% ( 51, 76 ] 23 0.008% 99.892% ( 76, 110 ] 115 0.040% 99.933% ( 110, 170 ] 71 0.025% 99.958% ( 170, 250 ] 38 0.013% 99.971% ( 250, 380 ] 27 0.009% 99.980% ( 380, 580 ] 29 0.010% 99.991% ( 580, 870 ] 15 0.005% 99.996% ( 870, 1300 ] 10 0.004% 99.999% ( 1300, 1900 ] 2 0.001% 100.000% ** Level 2 read latency histogram (micros): Count: 47985 Average: 2.3658 StdDev: 10.63 Min: 0 Median: 1.5405 Max: 1116 Percentiles: P50: 1.54 P75: 1.91 P99: 5.97 P99.9: 13.10 P99.99: 328.10 ------------------------------------------------------ [ 0, 1 ] 6472 13.488% 13.488% ### ( 1, 2 ] 32413 67.548% 81.036% ############## ( 2, 3 ] 5146 10.724% 91.760% ## ( 3, 4 ] 2056 4.285% 96.045% # ( 4, 6 ] 1442 3.005% 99.050% # ( 6, 10 ] 369 0.769% 99.819% ( 10, 15 ] 63 0.131% 99.950% ( 15, 22 ] 11 0.023% 99.973% ( 51, 76 ] 3 0.006% 99.979% ( 110, 170 ] 1 0.002% 99.981% ( 170, 250 ] 3 0.006% 99.987% ( 250, 380 ] 2 0.004% 99.992% ( 380, 580 ] 2 0.004% 99.996% ( 580, 870 ] 1 0.002% 99.998% ( 870, 1300 ] 4 0.008% 100.006% ** Level 3 read latency histogram (micros): Count: 85 Average: 724.2235 StdDev: 1085.34 Min: 1 Median: 120.0000 Max: 4186 Percentiles: P50: 120.00 P75: 837.05 P99: 4186.00 P99.9: 4186.00 P99.99: 4186.00 ------------------------------------------------------ [ 0, 1 ] 16 18.824% 18.824% #### ( 1, 2 ] 17 20.000% 38.824% #### ( 2, 3 ] 1 1.176% 40.000% ( 4, 6 ] 5 5.882% 45.882% # ( 6, 10 ] 2 2.353% 48.235% ( 22, 34 ] 1 1.176% 49.412% ( 110, 170 ] 3 3.529% 52.941% # ( 250, 380 ] 4 4.706% 57.647% # ( 380, 580 ] 5 5.882% 63.529% # ( 580, 870 ] 11 12.941% 76.471% ### ( 870, 1300 ] 3 3.529% 80.000% # ( 1300, 1900 ] 3 3.529% 83.529% # ( 1900, 2900 ] 7 8.235% 91.765% ## ( 2900, 4400 ] 7 8.235% 100.000% ## ** Level 4 read latency histogram (micros): Count: 30 Average: 1678.5333 StdDev: 1284.88 Min: 93 Median: 1300.0000 Max: 4333 Percentiles: P50: 1300.00 P75: 2733.33 P99: 4333.00 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ ( 76, 110 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 3 10.000% 20.000% ## ( 580, 870 ] 6 20.000% 40.000% #### ( 870, 1300 ] 3 10.000% 50.000% ## ( 1300, 1900 ] 5 16.667% 66.667% ### ( 1900, 2900 ] 3 10.000% 76.667% ## ( 2900, 4400 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 16.0 total, 4.1 interval Cumulative writes: 0 writes, 5000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 4.81 GB, 306.72 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:2.802 H:M:S, 17.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 241.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:1.403 H:M:S, 34.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/07/13-15:24:36 ... thread 0: (1000000,6000000) ops and (51222.7,169739.2) ops/second in (19.522611,35.348350) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 3/3 1.16 GB 0.0 5.3 0.0 5.3 10.9 5.7 0.0 1.9 149.9 310.0 36.14 34.06 100 0.361 5499K 9019 0.0 0.0 L1 6/6 704.83 MB 0.0 7.2 4.3 2.9 7.1 4.2 0.2 1.7 226.9 224.0 32.63 30.50 4 8.156 7516K 93K 0.0 0.0 L2 29/10 3.52 GB 24.5 0.2 0.1 0.1 0.2 0.1 3.6 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 19/12 991.59 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 228.2 228.2 0.82 0.75 1 0.821 190K 0 0.0 0.0 L4 116/0 9.54 GB 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 L5 1044/0 85.82 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 1217/31 101.70 GB 0.0 12.9 4.6 8.3 18.4 10.2 3.9 3.3 187.6 268.5 70.35 66.05 107 0.657 13M 102K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.9 4.6 8.3 18.4 10.2 3.8 3.3 187.6 268.5 70.35 66.05 107 0.657 13M 102K 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.9 4.6 8.3 12.8 4.5 0.0 0.0 244.2 242.3 54.04 51.50 24 2.252 13M 102K 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 355.4 16.31 14.55 83 0.196 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 35.6 total, 35.4 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: 18.45 GB write, 531.15 MB/s write, 12.89 GB read, 371.09 MB/s read, 70.3 seconds Interval compaction: 18.45 GB write, 534.40 MB/s write, 12.89 GB read, 373.35 MB/s read, 70.3 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: 16, pending-compaction-bytes-delays: 8, pending-compaction-bytes-stops: 0, total-delays: 16, total-stops: 16, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2546613 Average: 2.5670 StdDev: 15.34 Min: 0 Median: 1.4387 Max: 3558 Percentiles: P50: 1.44 P75: 1.81 P99: 5.78 P99.9: 136.86 P99.99: 282.68 ------------------------------------------------------ [ 0, 1 ] 530278 20.823% 20.823% #### ( 1, 2 ] 1693676 66.507% 87.330% ############# ( 2, 3 ] 192653 7.565% 94.895% ## ( 3, 4 ] 71036 2.789% 97.684% # ( 4, 6 ] 37622 1.477% 99.162% ( 6, 10 ] 10674 0.419% 99.581% ( 10, 15 ] 2101 0.083% 99.663% ( 15, 22 ] 324 0.013% 99.676% ( 22, 34 ] 28 0.001% 99.677% ( 34, 51 ] 21 0.001% 99.678% ( 51, 76 ] 100 0.004% 99.682% ( 76, 110 ] 4231 0.166% 99.848% ( 110, 170 ] 2956 0.116% 99.964% ( 170, 250 ] 551 0.022% 99.986% ( 250, 380 ] 431 0.017% 100.003% ( 380, 580 ] 368 0.014% 100.017% ( 580, 870 ] 144 0.006% 100.023% ( 870, 1300 ] 45 0.002% 100.025% ( 1300, 1900 ] 17 0.001% 100.025% ( 1900, 2900 ] 17 0.001% 100.026% ( 2900, 4400 ] 10 0.000% 100.026% ** Level 1 read latency histogram (micros): Count: 784222 Average: 2.5910 StdDev: 16.32 Min: 0 Median: 1.4070 Max: 4305 Percentiles: P50: 1.41 P75: 1.80 P99: 6.96 P99.9: 147.31 P99.99: 593.35 ------------------------------------------------------ [ 0, 1 ] 187417 23.898% 23.898% ##### ( 1, 2 ] 502880 64.125% 88.023% ############# ( 2, 3 ] 52382 6.679% 94.703% # ( 3, 4 ] 19139 2.441% 97.143% ( 4, 6 ] 13259 1.691% 98.834% ( 6, 10 ] 5423 0.692% 99.525% ( 10, 15 ] 494 0.063% 99.588% ( 15, 22 ] 140 0.018% 99.606% ( 22, 34 ] 8 0.001% 99.607% ( 34, 51 ] 3 0.000% 99.608% ( 51, 76 ] 143 0.018% 99.626% ( 76, 110 ] 1577 0.201% 99.827% ( 110, 170 ] 921 0.117% 99.944% ( 170, 250 ] 146 0.019% 99.963% ( 250, 380 ] 87 0.011% 99.974% ( 380, 580 ] 122 0.016% 99.990% ( 580, 870 ] 56 0.007% 99.997% ( 870, 1300 ] 26 0.003% 100.000% ( 1300, 1900 ] 8 0.001% 100.001% ( 1900, 2900 ] 1 0.000% 100.001% ( 2900, 4400 ] 4 0.001% 100.002% ** Level 2 read latency histogram (micros): Count: 48033 Average: 2.7707 StdDev: 18.11 Min: 0 Median: 1.5413 Max: 1116 Percentiles: P50: 1.54 P75: 1.91 P99: 6.26 P99.9: 193.74 P99.99: 811.89 ------------------------------------------------------ [ 0, 1 ] 6472 13.474% 13.474% ### ( 1, 2 ] 32413 67.481% 80.955% ############# ( 2, 3 ] 5146 10.713% 91.668% ## ( 3, 4 ] 2056 4.280% 95.949% # ( 4, 6 ] 1442 3.002% 98.951% # ( 6, 10 ] 369 0.768% 99.719% ( 10, 15 ] 63 0.131% 99.850% ( 15, 22 ] 11 0.023% 99.873% ( 51, 76 ] 3 0.006% 99.879% ( 76, 110 ] 1 0.002% 99.881% ( 110, 170 ] 6 0.012% 99.894% ( 170, 250 ] 10 0.021% 99.915% ( 250, 380 ] 14 0.029% 99.944% ( 380, 580 ] 15 0.031% 99.975% ( 580, 870 ] 9 0.019% 99.994% ( 870, 1300 ] 6 0.012% 100.006% ** Level 3 read latency histogram (micros): Count: 12892 Average: 13.3545 StdDev: 121.42 Min: 1 Median: 1.7184 Max: 4186 Percentiles: P50: 1.72 P75: 2.47 P99: 321.44 P99.9: 1810.80 P99.99: 3695.17 ------------------------------------------------------ [ 0, 1 ] 745 5.779% 5.779% # ( 1, 2 ] 7936 61.558% 67.336% ############ ( 2, 3 ] 2086 16.181% 83.517% ### ( 3, 4 ] 916 7.105% 90.622% # ( 4, 6 ] 659 5.112% 95.734% # ( 6, 10 ] 271 2.102% 97.836% ( 10, 15 ] 33 0.256% 98.092% ( 15, 22 ] 8 0.062% 98.154% ( 22, 34 ] 1 0.008% 98.162% ( 76, 110 ] 8 0.062% 98.224% ( 110, 170 ] 44 0.341% 98.565% ( 170, 250 ] 34 0.264% 98.829% ( 250, 380 ] 42 0.326% 99.155% ( 380, 580 ] 32 0.248% 99.403% ( 580, 870 ] 47 0.365% 99.767% ( 870, 1300 ] 13 0.101% 99.868% ( 1300, 1900 ] 6 0.047% 99.915% ( 1900, 2900 ] 7 0.054% 99.969% ( 2900, 4400 ] 7 0.054% 100.023% ** Level 4 read latency histogram (micros): Count: 30 Average: 1678.5333 StdDev: 1284.88 Min: 93 Median: 1300.0000 Max: 4333 Percentiles: P50: 1300.00 P75: 2733.33 P99: 4333.00 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ ( 76, 110 ] 1 3.333% 3.333% # ( 170, 250 ] 1 3.333% 6.667% # ( 250, 380 ] 1 3.333% 10.000% # ( 380, 580 ] 3 10.000% 20.000% ## ( 580, 870 ] 6 20.000% 40.000% #### ( 870, 1300 ] 3 10.000% 50.000% ## ( 1300, 1900 ] 5 16.667% 66.667% ### ( 1900, 2900 ] 3 10.000% 76.667% ## ( 2900, 4400 ] 7 23.333% 100.000% ##### ** DB Stats ** Uptime(secs): 35.6 total, 19.5 interval Cumulative writes: 0 writes, 6000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 5.77 GB, 166.03 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.070 H:M:S, 53.6 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 50.41 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:16.268 H:M:S, 83.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 4 num-running-flushes: 1 2024/07/13-15:24:43 ... thread 0: (1000000,7000000) ops and (148033.7,166256.7) ops/second in (6.755217,42.103567) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 9/7 2.09 GB 62.9 5.9 0.0 5.9 12.5 6.6 0.0 1.9 139.3 294.4 43.41 39.09 114 0.381 6139K 9812 0.0 0.0 L1 6/6 704.83 MB 0.0 7.2 4.3 2.9 7.1 4.2 0.2 1.7 226.9 224.0 32.63 30.50 4 8.156 7516K 93K 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 3.6 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 17/0 849.42 MB 0.8 5.1 3.5 1.6 5.0 3.4 0.4 1.5 155.3 155.0 33.35 22.99 21 1.588 4668K 5580 0.0 0.0 L4 157/4 9.87 GB 1.0 0.2 0.2 0.0 0.2 0.2 3.5 1.0 217.6 217.6 0.75 0.71 2 0.376 166K 0 0.0 0.0 L5 1084/0 89.14 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.3 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1273/17 102.61 GB 0.0 18.5 8.0 10.5 25.0 14.5 10.9 3.8 171.2 230.9 110.90 94.02 143 0.776 18M 108K 0.0 0.0 Int 0/0 0.00 KB 0.0 18.5 8.0 10.5 25.0 14.5 10.8 3.8 171.2 230.9 110.90 94.02 143 0.776 18M 108K 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.5 8.0 10.5 18.4 7.9 0.0 0.0 210.7 209.5 90.08 76.94 48 1.877 18M 108K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 6.6 6.6 0.0 0.0 0.0 323.8 20.82 17.08 95 0.219 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 42.3 total, 42.1 interval Flush(GB): cumulative 6.583, interval 6.583 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 25.01 GB write, 605.13 MB/s write, 18.54 GB read, 448.53 MB/s read, 110.9 seconds Interval compaction: 25.01 GB write, 608.24 MB/s write, 18.54 GB read, 450.83 MB/s read, 110.9 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: 39, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 39, interval: 60 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2974653 Average: 2.9179 StdDev: 32.91 Min: 0 Median: 1.4937 Max: 7597 Percentiles: P50: 1.49 P75: 1.88 P99: 6.70 P99.9: 138.90 P99.99: 392.00 ------------------------------------------------------ [ 0, 1 ] 540109 18.157% 18.157% #### ( 1, 2 ] 1918691 64.501% 82.658% ############# ( 2, 3 ] 296677 9.973% 92.632% ## ( 3, 4 ] 108257 3.639% 96.271% # ( 4, 6 ] 77655 2.611% 98.882% # ( 6, 10 ] 20052 0.674% 99.556% ( 10, 15 ] 3812 0.128% 99.684% ( 15, 22 ] 558 0.019% 99.703% ( 22, 34 ] 46 0.002% 99.704% ( 34, 51 ] 28 0.001% 99.705% ( 51, 76 ] 105 0.004% 99.709% ( 76, 110 ] 4245 0.143% 99.851% ( 110, 170 ] 2999 0.101% 99.952% ( 170, 250 ] 595 0.020% 99.972% ( 250, 380 ] 500 0.017% 99.989% ( 380, 580 ] 459 0.015% 100.005% ( 580, 870 ] 217 0.007% 100.012% ( 870, 1300 ] 124 0.004% 100.016% ( 1300, 1900 ] 62 0.002% 100.018% ( 1900, 2900 ] 86 0.003% 100.021% ( 2900, 4400 ] 94 0.003% 100.024% ( 4400, 6600 ] 27 0.001% 100.025% ( 6600, 9900 ] 3 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1656279 Average: 6.0898 StdDev: 98.26 Min: 0 Median: 1.6626 Max: 9616 Percentiles: P50: 1.66 P75: 2.36 P99: 9.06 P99.9: 233.98 P99.99: 799.75 ------------------------------------------------------ [ 0, 1 ] 198481 11.984% 11.984% ## ( 1, 2 ] 950216 57.371% 69.354% ########### ( 2, 3 ] 260373 15.720% 85.074% ### ( 3, 4 ] 112948 6.819% 91.894% # ( 4, 6 ] 97523 5.888% 97.782% # ( 6, 10 ] 26336 1.590% 99.372% ( 10, 15 ] 4722 0.285% 99.657% ( 15, 22 ] 756 0.046% 99.703% ( 22, 34 ] 43 0.003% 99.705% ( 34, 51 ] 24 0.001% 99.707% ( 51, 76 ] 151 0.009% 99.716% ( 76, 110 ] 1667 0.101% 99.817% ( 110, 170 ] 1082 0.065% 99.882% ( 170, 250 ] 376 0.023% 99.905% ( 250, 380 ] 448 0.027% 99.932% ( 380, 580 ] 565 0.034% 99.966% ( 580, 870 ] 531 0.032% 99.998% ( 870, 1300 ] 407 0.025% 100.022% ( 1300, 1900 ] 277 0.017% 100.039% ( 1900, 2900 ] 469 0.028% 100.067% ( 2900, 4400 ] 596 0.036% 100.103% ( 4400, 6600 ] 112 0.007% 100.110% ( 6600, 9900 ] 21 0.001% 100.111% ** Level 2 read latency histogram (micros): Count: 77139 Average: 4.7899 StdDev: 79.60 Min: 0 Median: 1.5992 Max: 7277 Percentiles: P50: 1.60 P75: 1.98 P99: 8.52 P99.9: 522.88 P99.99: 3864.32 ------------------------------------------------------ [ 0, 1 ] 8242 10.685% 10.685% ## ( 1, 2 ] 50610 65.609% 76.293% ############# ( 2, 3 ] 10023 12.993% 89.287% ### ( 3, 4 ] 3987 5.169% 94.455% # ( 4, 6 ] 2906 3.767% 98.223% # ( 6, 10 ] 950 1.232% 99.454% ( 10, 15 ] 129 0.167% 99.621% ( 15, 22 ] 21 0.027% 99.649% ( 22, 34 ] 3 0.004% 99.653% ( 34, 51 ] 1 0.001% 99.654% ( 51, 76 ] 4 0.005% 99.659% ( 76, 110 ] 51 0.066% 99.725% ( 110, 170 ] 41 0.053% 99.778% ( 170, 250 ] 36 0.047% 99.825% ( 250, 380 ] 30 0.039% 99.864% ( 380, 580 ] 39 0.051% 99.914% ( 580, 870 ] 17 0.022% 99.936% ( 870, 1300 ] 15 0.019% 99.956% ( 1300, 1900 ] 8 0.010% 99.966% ( 1900, 2900 ] 8 0.010% 99.977% ( 2900, 4400 ] 16 0.021% 99.997% ( 4400, 6600 ] 2 0.003% 100.000% ( 6600, 9900 ] 3 0.004% 100.004% ** Level 3 read latency histogram (micros): Count: 429697 Average: 4.4613 StdDev: 55.95 Min: 0 Median: 1.8455 Max: 8426 Percentiles: P50: 1.85 P75: 2.76 P99: 9.01 P99.9: 232.75 P99.99: 614.32 ------------------------------------------------------ [ 0, 1 ] 11773 2.740% 2.740% # ( 1, 2 ] 240175 55.894% 58.634% ########### ( 2, 3 ] 92441 21.513% 80.147% #### ( 3, 4 ] 41488 9.655% 89.802% ## ( 4, 6 ] 33643 7.829% 97.632% ## ( 6, 10 ] 7820 1.820% 99.451% ( 10, 15 ] 1298 0.302% 99.754% ( 15, 22 ] 167 0.039% 99.792% ( 22, 34 ] 8 0.002% 99.794% ( 34, 51 ] 6 0.001% 99.796% ( 51, 76 ] 5 0.001% 99.797% ( 76, 110 ] 57 0.013% 99.810% ( 110, 170 ] 231 0.054% 99.864% ( 170, 250 ] 198 0.046% 99.910% ( 250, 380 ] 164 0.038% 99.948% ( 380, 580 ] 165 0.038% 99.987% ( 580, 870 ] 127 0.030% 100.016% ( 870, 1300 ] 81 0.019% 100.035% ( 1300, 1900 ] 42 0.010% 100.045% ( 1900, 2900 ] 46 0.011% 100.055% ( 2900, 4400 ] 26 0.006% 100.061% ( 4400, 6600 ] 12 0.003% 100.064% ( 6600, 9900 ] 2 0.000% 100.065% ** Level 4 read latency histogram (micros): Count: 50 Average: 1051.7600 StdDev: 1263.72 Min: 1 Median: 580.0000 Max: 4333 Percentiles: P50: 580.00 P75: 1600.00 P99: 4292.86 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ [ 0, 1 ] 2 4.000% 4.000% # ( 1, 2 ] 6 12.000% 16.000% ## ( 2, 3 ] 3 6.000% 22.000% # ( 3, 4 ] 1 2.000% 24.000% ( 10, 15 ] 1 2.000% 26.000% ( 15, 22 ] 1 2.000% 28.000% ( 76, 110 ] 2 4.000% 32.000% # ( 170, 250 ] 3 6.000% 38.000% # ( 250, 380 ] 1 2.000% 40.000% ( 380, 580 ] 5 10.000% 50.000% ## ( 580, 870 ] 7 14.000% 64.000% ### ( 870, 1300 ] 3 6.000% 70.000% # ( 1300, 1900 ] 5 10.000% 80.000% ## ( 1900, 2900 ] 3 6.000% 86.000% # ( 2900, 4400 ] 7 14.000% 100.000% ### ** Level 5 read latency histogram (micros): Count: 200 Average: 1694.9750 StdDev: 1646.07 Min: 95 Median: 992.8571 Max: 7945 Percentiles: P50: 992.86 P75: 2594.44 P99: 7945.00 P99.9: 7945.00 P99.99: 7945.00 ------------------------------------------------------ ( 76, 110 ] 5 2.500% 2.500% # ( 110, 170 ] 7 3.500% 6.000% # ( 170, 250 ] 9 4.500% 10.500% # ( 250, 380 ] 21 10.500% 21.000% ## ( 380, 580 ] 32 16.000% 37.000% ### ( 580, 870 ] 22 11.000% 48.000% ## ( 870, 1300 ] 14 7.000% 55.000% # ( 1300, 1900 ] 15 7.500% 62.500% ## ( 1900, 2900 ] 36 18.000% 80.500% #### ( 2900, 4400 ] 24 12.000% 92.500% ## ( 4400, 6600 ] 11 5.500% 98.000% # ( 6600, 9900 ] 4 2.000% 100.000% ** DB Stats ** Uptime(secs): 42.3 total, 6.8 interval Cumulative writes: 0 writes, 7000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 6.73 GB, 162.79 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:22.902 H:M:S, 54.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 145.69 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.833 H:M:S, 56.7 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/07/13-15:24:46 ... thread 0: (1000000,8000000) ops and (331777.2,177314.2) ops/second in (3.014071,45.117638) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 11/4 1.91 GB 163.6 6.8 0.0 6.8 14.3 7.6 0.0 1.9 139.8 295.9 49.56 44.89 131 0.378 7034K 10K 0.0 0.0 L1 14/0 1.29 GB 131.8 9.1 5.5 3.6 9.0 5.4 0.2 1.6 218.9 216.4 42.48 38.83 5 8.495 8726K 93K 0.0 0.0 L2 5/4 355.08 MB 0.7 0.2 0.1 0.1 0.2 0.1 4.1 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 20/6 1.04 GB 0.6 5.1 3.5 1.6 5.0 3.4 0.6 1.5 155.3 155.0 33.35 22.99 21 1.588 4668K 5580 0.0 0.0 L4 153/0 9.56 GB 1.0 0.2 0.2 0.0 0.2 0.2 3.5 1.0 217.6 217.6 0.75 0.71 2 0.376 166K 0 0.0 0.0 L5 1088/0 89.45 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1291/14 103.58 GB 0.0 21.3 9.2 12.0 28.7 16.7 12.0 3.8 171.5 231.6 126.90 108.15 161 0.788 20M 109K 0.0 0.0 Int 0/0 0.00 KB 0.0 21.3 9.2 12.0 28.7 16.7 11.9 3.8 171.5 231.6 126.90 108.15 161 0.788 20M 109K 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.3 9.2 12.0 21.1 9.1 0.0 0.0 210.7 209.5 103.27 88.55 52 1.986 20M 109K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 7.6 7.6 0.0 0.0 0.0 327.8 23.64 19.61 109 0.217 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): 45.3 total, 45.1 interval Flush(GB): cumulative 7.567, interval 7.567 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.70 GB write, 648.17 MB/s write, 21.25 GB read, 479.99 MB/s read, 126.9 seconds Interval compaction: 28.70 GB write, 651.27 MB/s write, 21.25 GB read, 482.29 MB/s read, 126.9 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: 42, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 42, interval: 63 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3254896 Average: 2.8628 StdDev: 31.61 Min: 0 Median: 1.4984 Max: 7597 Percentiles: P50: 1.50 P75: 1.88 P99: 6.48 P99.9: 132.75 P99.99: 368.59 ------------------------------------------------------ [ 0, 1 ] 578577 17.776% 17.776% #### ( 1, 2 ] 2104637 64.661% 82.436% ############# ( 2, 3 ] 332709 10.222% 92.658% ## ( 3, 4 ] 118830 3.651% 96.309% # ( 4, 6 ] 84987 2.611% 98.920% # ( 6, 10 ] 21619 0.664% 99.584% ( 10, 15 ] 4128 0.127% 99.711% ( 15, 22 ] 583 0.018% 99.729% ( 22, 34 ] 50 0.002% 99.730% ( 34, 51 ] 29 0.001% 99.731% ( 51, 76 ] 108 0.003% 99.735% ( 76, 110 ] 4245 0.130% 99.865% ( 110, 170 ] 3004 0.092% 99.957% ( 170, 250 ] 602 0.018% 99.976% ( 250, 380 ] 507 0.016% 99.991% ( 380, 580 ] 460 0.014% 100.005% ( 580, 870 ] 221 0.007% 100.012% ( 870, 1300 ] 128 0.004% 100.016% ( 1300, 1900 ] 65 0.002% 100.018% ( 1900, 2900 ] 89 0.003% 100.021% ( 2900, 4400 ] 94 0.003% 100.024% ( 4400, 6600 ] 27 0.001% 100.025% ( 6600, 9900 ] 3 0.000% 100.025% ** Level 1 read latency histogram (micros): Count: 1791447 Average: 5.9134 StdDev: 94.82 Min: 0 Median: 1.6607 Max: 9616 Percentiles: P50: 1.66 P75: 2.34 P99: 9.07 P99.9: 250.14 P99.99: 814.04 ------------------------------------------------------ [ 0, 1 ] 209265 11.681% 11.681% ## ( 1, 2 ] 1038954 57.995% 69.677% ############ ( 2, 3 ] 283243 15.811% 85.487% ### ( 3, 4 ] 117925 6.583% 92.070% # ( 4, 6 ] 102022 5.695% 97.765% # ( 6, 10 ] 28828 1.609% 99.374% ( 10, 15 ] 4918 0.275% 99.649% ( 15, 22 ] 786 0.044% 99.693% ( 22, 34 ] 44 0.002% 99.695% ( 34, 51 ] 24 0.001% 99.696% ( 51, 76 ] 158 0.009% 99.705% ( 76, 110 ] 1777 0.099% 99.804% ( 110, 170 ] 1240 0.069% 99.874% ( 170, 250 ] 472 0.026% 99.900% ( 250, 380 ] 518 0.029% 99.929% ( 380, 580 ] 630 0.035% 99.964% ( 580, 870 ] 576 0.032% 99.996% ( 870, 1300 ] 438 0.024% 100.021% ( 1300, 1900 ] 287 0.016% 100.037% ( 1900, 2900 ] 470 0.026% 100.063% ( 2900, 4400 ] 596 0.033% 100.096% ( 4400, 6600 ] 112 0.006% 100.102% ( 6600, 9900 ] 21 0.001% 100.104% ** Level 2 read latency histogram (micros): Count: 77139 Average: 4.7899 StdDev: 79.60 Min: 0 Median: 1.5992 Max: 7277 Percentiles: P50: 1.60 P75: 1.98 P99: 8.52 P99.9: 522.88 P99.99: 3864.32 ------------------------------------------------------ [ 0, 1 ] 8242 10.685% 10.685% ## ( 1, 2 ] 50610 65.609% 76.293% ############# ( 2, 3 ] 10023 12.993% 89.287% ### ( 3, 4 ] 3987 5.169% 94.455% # ( 4, 6 ] 2906 3.767% 98.223% # ( 6, 10 ] 950 1.232% 99.454% ( 10, 15 ] 129 0.167% 99.621% ( 15, 22 ] 21 0.027% 99.649% ( 22, 34 ] 3 0.004% 99.653% ( 34, 51 ] 1 0.001% 99.654% ( 51, 76 ] 4 0.005% 99.659% ( 76, 110 ] 51 0.066% 99.725% ( 110, 170 ] 41 0.053% 99.778% ( 170, 250 ] 36 0.047% 99.825% ( 250, 380 ] 30 0.039% 99.864% ( 380, 580 ] 39 0.051% 99.914% ( 580, 870 ] 17 0.022% 99.936% ( 870, 1300 ] 15 0.019% 99.956% ( 1300, 1900 ] 8 0.010% 99.966% ( 1900, 2900 ] 8 0.010% 99.977% ( 2900, 4400 ] 16 0.021% 99.997% ( 4400, 6600 ] 2 0.003% 100.000% ( 6600, 9900 ] 3 0.004% 100.004% ** Level 3 read latency histogram (micros): Count: 429843 Average: 4.5205 StdDev: 56.26 Min: 0 Median: 1.8458 Max: 8426 Percentiles: P50: 1.85 P75: 2.76 P99: 9.05 P99.9: 248.20 P99.99: 636.73 ------------------------------------------------------ [ 0, 1 ] 11773 2.739% 2.739% # ( 1, 2 ] 240175 55.875% 58.614% ########### ( 2, 3 ] 92441 21.506% 80.120% #### ( 3, 4 ] 41494 9.653% 89.773% ## ( 4, 6 ] 33688 7.837% 97.610% ## ( 6, 10 ] 7844 1.825% 99.435% ( 10, 15 ] 1303 0.303% 99.738% ( 15, 22 ] 169 0.039% 99.778% ( 22, 34 ] 8 0.002% 99.779% ( 34, 51 ] 6 0.001% 99.781% ( 51, 76 ] 5 0.001% 99.782% ( 76, 110 ] 59 0.014% 99.796% ( 110, 170 ] 238 0.055% 99.851% ( 170, 250 ] 215 0.050% 99.901% ( 250, 380 ] 175 0.041% 99.942% ( 380, 580 ] 181 0.042% 99.984% ( 580, 870 ] 133 0.031% 100.015% ( 870, 1300 ] 84 0.020% 100.034% ( 1300, 1900 ] 44 0.010% 100.045% ( 1900, 2900 ] 46 0.011% 100.055% ( 2900, 4400 ] 26 0.006% 100.061% ( 4400, 6600 ] 12 0.003% 100.064% ( 6600, 9900 ] 2 0.000% 100.065% ** Level 4 read latency histogram (micros): Count: 50 Average: 1051.7600 StdDev: 1263.72 Min: 1 Median: 580.0000 Max: 4333 Percentiles: P50: 580.00 P75: 1600.00 P99: 4292.86 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ [ 0, 1 ] 2 4.000% 4.000% # ( 1, 2 ] 6 12.000% 16.000% ## ( 2, 3 ] 3 6.000% 22.000% # ( 3, 4 ] 1 2.000% 24.000% ( 10, 15 ] 1 2.000% 26.000% ( 15, 22 ] 1 2.000% 28.000% ( 76, 110 ] 2 4.000% 32.000% # ( 170, 250 ] 3 6.000% 38.000% # ( 250, 380 ] 1 2.000% 40.000% ( 380, 580 ] 5 10.000% 50.000% ## ( 580, 870 ] 7 14.000% 64.000% ### ( 870, 1300 ] 3 6.000% 70.000% # ( 1300, 1900 ] 5 10.000% 80.000% ## ( 1900, 2900 ] 3 6.000% 86.000% # ( 2900, 4400 ] 7 14.000% 100.000% ### ** Level 5 read latency histogram (micros): Count: 220 Average: 1608.1636 StdDev: 1617.44 Min: 74 Median: 858.4000 Max: 7945 Percentiles: P50: 858.40 P75: 2505.26 P99: 7945.00 P99.9: 7945.00 P99.99: 7945.00 ------------------------------------------------------ ( 51, 76 ] 1 0.455% 0.455% ( 76, 110 ] 11 5.000% 5.455% # ( 110, 170 ] 7 3.182% 8.636% # ( 170, 250 ] 11 5.000% 13.636% # ( 250, 380 ] 24 10.909% 24.545% ## ( 380, 580 ] 32 14.545% 39.091% ### ( 580, 870 ] 25 11.364% 50.455% ## ( 870, 1300 ] 15 6.818% 57.273% # ( 1300, 1900 ] 16 7.273% 64.545% # ( 1900, 2900 ] 38 17.273% 81.818% ### ( 2900, 4400 ] 25 11.364% 93.182% ## ( 4400, 6600 ] 11 5.000% 98.182% # ( 6600, 9900 ] 4 1.818% 100.000% ** DB Stats ** Uptime(secs): 45.3 total, 3.0 interval Cumulative writes: 0 writes, 8000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 7.69 GB, 173.67 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:23.294 H:M:S, 51.4 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 326.53 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.391 H:M:S, 13.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/07/13-15:24:49 ... thread 0: (1000000,9000000) ops and (315637.0,186390.1) ops/second in (3.168196,48.285834) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 15/15 2.83 GB 0.0 7.6 0.0 7.6 16.1 8.5 0.0 1.9 140.0 295.6 55.80 50.63 147 0.380 7930K 11K 0.0 0.0 L1 14/14 1.29 GB 0.0 9.1 5.5 3.6 9.0 5.4 0.2 1.6 218.9 216.4 42.48 38.83 5 8.495 8726K 93K 0.0 0.0 L2 1/0 70.80 MB 0.7 0.2 0.1 0.1 0.2 0.1 4.1 1.5 251.8 251.7 0.76 0.73 2 0.382 195K 72 0.0 0.0 L3 18/0 962.29 MB 1.0 5.7 3.7 2.0 5.7 3.7 0.6 1.5 158.8 158.4 37.04 26.25 25 1.481 5382K 10K 0.0 0.0 L4 154/0 9.62 GB 1.0 0.3 0.2 0.0 0.3 0.2 3.8 1.0 214.2 214.0 1.20 1.11 3 0.400 261K 164 0.0 0.0 L5 1092/0 89.75 GB 0.9 0.0 0.0 0.0 0.0 0.0 3.9 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1294/29 104.50 GB 0.0 22.9 9.6 13.3 31.3 17.9 12.6 3.7 170.7 233.1 137.28 117.56 182 0.754 22M 116K 0.0 0.0 Int 0/0 0.00 KB 0.0 22.9 9.6 13.3 31.3 17.9 12.5 3.7 170.7 233.1 137.28 117.56 182 0.754 22M 116K 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 9.6 13.3 22.8 9.4 0.0 0.0 211.5 210.3 110.82 95.54 60 1.847 22M 116K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 8.5 8.5 0.0 0.0 0.0 328.6 26.45 22.02 122 0.217 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): 48.5 total, 48.3 interval Flush(GB): cumulative 8.490, interval 8.490 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 31.25 GB write, 659.78 MB/s write, 22.89 GB read, 483.24 MB/s read, 137.3 seconds Interval compaction: 31.25 GB write, 662.73 MB/s write, 22.89 GB read, 485.40 MB/s read, 137.3 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: 47, pending-compaction-bytes-delays: 13, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 47, interval: 68 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 3502381 Average: 2.8244 StdDev: 30.69 Min: 0 Median: 1.4969 Max: 7597 Percentiles: P50: 1.50 P75: 1.88 P99: 6.35 P99.9: 129.22 P99.99: 359.60 ------------------------------------------------------ [ 0, 1 ] 628041 17.932% 17.932% #### ( 1, 2 ] 2260474 64.541% 82.473% ############# ( 2, 3 ] 356523 10.179% 92.652% ## ( 3, 4 ] 128440 3.667% 96.320% # ( 4, 6 ] 91901 2.624% 98.944% # ( 6, 10 ] 22859 0.653% 99.596% ( 10, 15 ] 4501 0.129% 99.725% ( 15, 22 ] 617 0.018% 99.742% ( 22, 34 ] 53 0.002% 99.744% ( 34, 51 ] 32 0.001% 99.745% ( 51, 76 ] 114 0.003% 99.748% ( 76, 110 ] 4340 0.124% 99.872% ( 110, 170 ] 3070 0.088% 99.960% ( 170, 250 ] 624 0.018% 99.977% ( 250, 380 ] 524 0.015% 99.992% ( 380, 580 ] 467 0.013% 100.006% ( 580, 870 ] 226 0.006% 100.012% ( 870, 1300 ] 133 0.004% 100.016% ( 1300, 1900 ] 66 0.002% 100.018% ( 1900, 2900 ] 92 0.003% 100.020% ( 2900, 4400 ] 95 0.003% 100.023% ( 4400, 6600 ] 27 0.001% 100.024% ( 6600, 9900 ] 3 0.000% 100.024% ** Level 1 read latency histogram (micros): Count: 1891224 Average: 5.7997 StdDev: 92.48 Min: 0 Median: 1.6732 Max: 9616 Percentiles: P50: 1.67 P75: 2.38 P99: 9.09 P99.9: 236.99 P99.99: 779.76 ------------------------------------------------------ [ 0, 1 ] 210926 11.153% 11.153% ## ( 1, 2 ] 1091307 57.704% 68.857% ############ ( 2, 3 ] 307353 16.252% 85.108% ### ( 3, 4 ] 127384 6.736% 91.844% # ( 4, 6 ] 111023 5.870% 97.714% # ( 6, 10 ] 31478 1.664% 99.379% ( 10, 15 ] 5374 0.284% 99.663% ( 15, 22 ] 831 0.044% 99.707% ( 22, 34 ] 44 0.002% 99.709% ( 34, 51 ] 26 0.001% 99.710% ( 51, 76 ] 158 0.008% 99.719% ( 76, 110 ] 1778 0.094% 99.813% ( 110, 170 ] 1248 0.066% 99.879% ( 170, 250 ] 481 0.025% 99.904% ( 250, 380 ] 544 0.029% 99.933% ( 380, 580 ] 659 0.035% 99.968% ( 580, 870 ] 611 0.032% 100.000% ( 870, 1300 ] 464 0.025% 100.025% ( 1300, 1900 ] 288 0.015% 100.040% ( 1900, 2900 ] 472 0.025% 100.065% ( 2900, 4400 ] 596 0.032% 100.096% ( 4400, 6600 ] 112 0.006% 100.102% ( 6600, 9900 ] 21 0.001% 100.103% ** Level 2 read latency histogram (micros): Count: 77139 Average: 4.7899 StdDev: 79.60 Min: 0 Median: 1.5992 Max: 7277 Percentiles: P50: 1.60 P75: 1.98 P99: 8.52 P99.9: 522.88 P99.99: 3864.32 ------------------------------------------------------ [ 0, 1 ] 8242 10.685% 10.685% ## ( 1, 2 ] 50610 65.609% 76.293% ############# ( 2, 3 ] 10023 12.993% 89.287% ### ( 3, 4 ] 3987 5.169% 94.455% # ( 4, 6 ] 2906 3.767% 98.223% # ( 6, 10 ] 950 1.232% 99.454% ( 10, 15 ] 129 0.167% 99.621% ( 15, 22 ] 21 0.027% 99.649% ( 22, 34 ] 3 0.004% 99.653% ( 34, 51 ] 1 0.001% 99.654% ( 51, 76 ] 4 0.005% 99.659% ( 76, 110 ] 51 0.066% 99.725% ( 110, 170 ] 41 0.053% 99.778% ( 170, 250 ] 36 0.047% 99.825% ( 250, 380 ] 30 0.039% 99.864% ( 380, 580 ] 39 0.051% 99.914% ( 580, 870 ] 17 0.022% 99.936% ( 870, 1300 ] 15 0.019% 99.956% ( 1300, 1900 ] 8 0.010% 99.966% ( 1900, 2900 ] 8 0.010% 99.977% ( 2900, 4400 ] 16 0.021% 99.997% ( 4400, 6600 ] 2 0.003% 100.000% ( 6600, 9900 ] 3 0.004% 100.004% ** Level 3 read latency histogram (micros): Count: 526933 Average: 4.2717 StdDev: 51.33 Min: 0 Median: 1.8454 Max: 8426 Percentiles: P50: 1.85 P75: 2.75 P99: 8.98 P99.9: 216.96 P99.99: 571.13 ------------------------------------------------------ [ 0, 1 ] 14673 2.785% 2.785% # ( 1, 2 ] 294292 55.850% 58.635% ########### ( 2, 3 ] 114552 21.739% 80.374% #### ( 3, 4 ] 49768 9.445% 89.819% ## ( 4, 6 ] 41480 7.872% 97.691% ## ( 6, 10 ] 9262 1.758% 99.449% ( 10, 15 ] 1617 0.307% 99.755% ( 15, 22 ] 219 0.042% 99.797% ( 22, 34 ] 11 0.002% 99.799% ( 34, 51 ] 6 0.001% 99.800% ( 51, 76 ] 7 0.001% 99.801% ( 76, 110 ] 88 0.017% 99.818% ( 110, 170 ] 289 0.055% 99.873% ( 170, 250 ] 242 0.046% 99.919% ( 250, 380 ] 187 0.035% 99.954% ( 380, 580 ] 196 0.037% 99.992% ( 580, 870 ] 137 0.026% 100.018% ( 870, 1300 ] 88 0.017% 100.034% ( 1300, 1900 ] 46 0.009% 100.043% ( 1900, 2900 ] 48 0.009% 100.052% ( 2900, 4400 ] 26 0.005% 100.057% ( 4400, 6600 ] 12 0.002% 100.059% ( 6600, 9900 ] 2 0.000% 100.060% ** Level 4 read latency histogram (micros): Count: 60 Average: 889.6833 StdDev: 1209.93 Min: 1 Median: 380.0000 Max: 4333 Percentiles: P50: 380.00 P75: 1300.00 P99: 4271.43 P99.9: 4333.00 P99.99: 4333.00 ------------------------------------------------------ [ 0, 1 ] 4 6.667% 6.667% # ( 1, 2 ] 10 16.667% 23.333% ### ( 2, 3 ] 3 5.000% 28.333% # ( 3, 4 ] 1 1.667% 30.000% ( 10, 15 ] 1 1.667% 31.667% ( 15, 22 ] 1 1.667% 33.333% ( 76, 110 ] 3 5.000% 38.333% # ( 170, 250 ] 5 8.333% 46.667% ## ( 250, 380 ] 2 3.333% 50.000% # ( 380, 580 ] 5 8.333% 58.333% ## ( 580, 870 ] 7 11.667% 70.000% ## ( 870, 1300 ] 3 5.000% 75.000% # ( 1300, 1900 ] 5 8.333% 83.333% ## ( 1900, 2900 ] 3 5.000% 88.333% # ( 2900, 4400 ] 7 11.667% 100.000% ## ** Level 5 read latency histogram (micros): Count: 240 Average: 1526.5875 StdDev: 1588.96 Min: 74 Median: 794.8148 Max: 7945 Percentiles: P50: 794.81 P75: 2425.00 P99: 7920.00 P99.9: 7945.00 P99.99: 7945.00 ------------------------------------------------------ ( 51, 76 ] 1 0.417% 0.417% ( 76, 110 ] 13 5.417% 5.833% # ( 110, 170 ] 15 6.250% 12.083% # ( 170, 250 ] 12 5.000% 17.083% # ( 250, 380 ] 26 10.833% 27.917% ## ( 380, 580 ] 33 13.750% 41.667% ### ( 580, 870 ] 27 11.250% 52.917% ## ( 870, 1300 ] 16 6.667% 59.583% # ( 1300, 1900 ] 16 6.667% 66.250% # ( 1900, 2900 ] 40 16.667% 82.917% ### ( 2900, 4400 ] 26 10.833% 93.750% ## ( 4400, 6600 ] 11 4.583% 98.333% # ( 6600, 9900 ] 4 1.667% 100.000% ** DB Stats ** Uptime(secs): 48.5 total, 3.2 interval Cumulative writes: 0 writes, 9000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 8.65 GB, 182.62 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:23.788 H:M:S, 49.0 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 310.65 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.494 H:M:S, 15.6 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] overwrite : 6.006 micros/op 166503 ops/sec 60.047 seconds 9997999 operations; 161.3 MB/s Microseconds per write: Count: 9997999 Average: 6.0059 StdDev: 360.29 Min: 0 Median: 1.7440 Max: 646010 Percentiles: P50: 1.74 P75: 2.71 P99: 8.91 P99.9: 1185.97 P99.99: 2749.68 ------------------------------------------------------ [ 0, 1 ] 1293949 12.942% 12.942% ### ( 1, 2 ] 4979949 49.809% 62.752% ########## ( 2, 3 ] 1723553 17.239% 79.991% ### ( 3, 4 ] 1341495 13.418% 93.408% ### ( 4, 6 ] 485034 4.851% 98.259% # ( 6, 10 ] 101856 1.019% 99.278% ( 10, 15 ] 31621 0.316% 99.594% ( 15, 22 ] 7938 0.079% 99.674% ( 22, 34 ] 1738 0.017% 99.691% ( 34, 51 ] 185 0.002% 99.693% ( 51, 76 ] 20 0.000% 99.693% ( 76, 110 ] 7324 0.073% 99.767% ( 110, 170 ] 2406 0.024% 99.791% ( 170, 250 ] 264 0.003% 99.793% ( 250, 380 ] 105 0.001% 99.794% ( 380, 580 ] 24 0.000% 99.795% ( 580, 870 ] 21 0.000% 99.795% ( 870, 1300 ] 14315 0.143% 99.938% ( 1300, 1900 ] 54 0.001% 99.939% ( 1900, 2900 ] 6059 0.061% 99.999% ( 2900, 4400 ] 49 0.000% 100.000% ( 4400, 6600 ] 14 0.000% 100.000% ( 6600, 9900 ] 2 0.000% 100.000% ( 9900, 14000 ] 1 0.000% 100.000% ( 14000, 22000 ] 1 0.000% 100.000% ( 22000, 33000 ] 2 0.000% 100.000% ( 110000, 170000 ] 1 0.000% 100.000% ( 170000, 250000 ] 16 0.000% 100.000% ( 250000, 380000 ] 2 0.000% 100.000% ( 570000, 860000 ] 1 0.000% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 0 rocksdb.bloom.filter.full.positive COUNT : 0 rocksdb.bloom.filter.full.true.positive COUNT : 0 rocksdb.persistent.cache.hit COUNT : 0 rocksdb.persistent.cache.miss COUNT : 0 rocksdb.sim.block.cache.hit COUNT : 0 rocksdb.sim.block.cache.miss COUNT : 0 rocksdb.memtable.hit COUNT : 0 rocksdb.memtable.miss COUNT : 0 rocksdb.l0.hit COUNT : 0 rocksdb.l1.hit COUNT : 0 rocksdb.l2andup.hit COUNT : 0 rocksdb.compaction.key.drop.new COUNT : 177940 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 : 9997999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 10317934968 rocksdb.bytes.read COUNT : 0 rocksdb.number.db.seek COUNT : 0 rocksdb.number.db.next COUNT : 0 rocksdb.number.db.prev COUNT : 0 rocksdb.number.db.seek.found COUNT : 0 rocksdb.number.db.next.found COUNT : 0 rocksdb.number.db.prev.found COUNT : 0 rocksdb.db.iter.bytes.read COUNT : 0 rocksdb.no.file.opens COUNT : 480 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 32836748 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 : 28827529038 rocksdb.compact.write.bytes COUNT : 28657083733 rocksdb.flush.write.bytes COUNT : 10304943343 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 : 58 rocksdb.number.superversion_acquires COUNT : 0 rocksdb.number.superversion_releases COUNT : 0 rocksdb.number.superversion_cleanups COUNT : 0 rocksdb.number.block.compressed COUNT : 0 rocksdb.number.block.decompressed COUNT : 0 rocksdb.number.block.not_compressed COUNT : 0 rocksdb.merge.operation.time.nanos COUNT : 0 rocksdb.filter.operation.time.nanos COUNT : 0 rocksdb.row.cache.hit COUNT : 0 rocksdb.row.cache.miss COUNT : 0 rocksdb.read.amp.estimate.useful.bytes COUNT : 0 rocksdb.read.amp.total.read.bytes COUNT : 0 rocksdb.number.rate_limiter.drains COUNT : 0 rocksdb.number.iter.skip COUNT : 0 rocksdb.blobdb.num.put COUNT : 0 rocksdb.blobdb.num.write COUNT : 0 rocksdb.blobdb.num.get COUNT : 0 rocksdb.blobdb.num.multiget COUNT : 0 rocksdb.blobdb.num.seek COUNT : 0 rocksdb.blobdb.num.next COUNT : 0 rocksdb.blobdb.num.prev COUNT : 0 rocksdb.blobdb.num.keys.written COUNT : 0 rocksdb.blobdb.num.keys.read COUNT : 0 rocksdb.blobdb.bytes.written COUNT : 0 rocksdb.blobdb.bytes.read COUNT : 0 rocksdb.blobdb.write.inlined COUNT : 0 rocksdb.blobdb.write.inlined.ttl COUNT : 0 rocksdb.blobdb.write.blob COUNT : 0 rocksdb.blobdb.write.blob.ttl COUNT : 0 rocksdb.blobdb.blob.file.bytes.written COUNT : 0 rocksdb.blobdb.blob.file.bytes.read COUNT : 0 rocksdb.blobdb.blob.file.synced COUNT : 0 rocksdb.blobdb.blob.index.expired.count COUNT : 0 rocksdb.blobdb.blob.index.expired.size COUNT : 0 rocksdb.blobdb.blob.index.evicted.count COUNT : 0 rocksdb.blobdb.blob.index.evicted.size COUNT : 0 rocksdb.blobdb.gc.num.files COUNT : 0 rocksdb.blobdb.gc.num.new.files COUNT : 0 rocksdb.blobdb.gc.failures COUNT : 0 rocksdb.blobdb.gc.num.keys.relocated COUNT : 0 rocksdb.blobdb.gc.bytes.relocated COUNT : 0 rocksdb.blobdb.fifo.num.files.evicted COUNT : 0 rocksdb.blobdb.fifo.num.keys.evicted COUNT : 0 rocksdb.blobdb.fifo.bytes.evicted COUNT : 0 rocksdb.txn.overhead.mutex.prepare COUNT : 0 rocksdb.txn.overhead.mutex.old.commit.map COUNT : 0 rocksdb.txn.overhead.duplicate.key COUNT : 0 rocksdb.txn.overhead.mutex.snapshot COUNT : 0 rocksdb.txn.get.tryagain COUNT : 0 rocksdb.number.multiget.keys.found COUNT : 0 rocksdb.num.iterator.created COUNT : 0 rocksdb.num.iterator.deleted COUNT : 0 rocksdb.block.cache.compression.dict.miss COUNT : 0 rocksdb.block.cache.compression.dict.hit COUNT : 0 rocksdb.block.cache.compression.dict.add COUNT : 0 rocksdb.block.cache.compression.dict.bytes.insert COUNT : 0 rocksdb.block.cache.add.redundant COUNT : 0 rocksdb.block.cache.index.add.redundant COUNT : 0 rocksdb.block.cache.filter.add.redundant COUNT : 0 rocksdb.block.cache.data.add.redundant COUNT : 0 rocksdb.block.cache.compression.dict.add.redundant COUNT : 0 rocksdb.files.marked.trash COUNT : 0 rocksdb.files.deleted.immediately COUNT : 273 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 : 10221847552 rocksdb.memtable.garbage.bytes.at.flush COUNT : 3959808 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 : 28922287569 rocksdb.non.last.level.read.count COUNT : 6986713 rocksdb.block.checksum.compute.count COUNT : 6985811 rocksdb.multiget.coroutine.count COUNT : 0 rocksdb.blobdb.cache.miss COUNT : 0 rocksdb.blobdb.cache.hit COUNT : 0 rocksdb.blobdb.cache.add COUNT : 0 rocksdb.blobdb.cache.add.failures COUNT : 0 rocksdb.blobdb.cache.bytes.read COUNT : 0 rocksdb.blobdb.cache.bytes.write COUNT : 0 rocksdb.read.async.micros COUNT : 0 rocksdb.async.read.error.count COUNT : 0 rocksdb.secondary.cache.filter.hits COUNT : 0 rocksdb.secondary.cache.index.hits COUNT : 0 rocksdb.secondary.cache.data.hits COUNT : 0 rocksdb.table.open.prefetch.tail.miss COUNT : 0 rocksdb.table.open.prefetch.tail.hit COUNT : 0 rocksdb.db.get.micros P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.db.write.micros P50 : 1.382172 P95 : 3.833763 P99 : 7.316666 P100 : 645997.000000 COUNT : 9997999 SUM : 55315835 rocksdb.compaction.times.micros P50 : 1153103.448276 P95 : 4244000.000000 P99 : 16880000.000000 P100 : 19855443.000000 COUNT : 64 SUM : 114797879 rocksdb.compaction.times.cpu_micros P50 : 980000.000000 P95 : 4230000.000000 P99 : 16880000.000000 P100 : 18111703.000000 COUNT : 64 SUM : 99430899 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 : 708.139535 P95 : 2000.000000 P99 : 28820.000000 P100 : 45148.000000 COUNT : 138 SUM : 203052 rocksdb.compaction.outfile.sync.micros P50 : 943.630137 P95 : 32931.250000 P99 : 80975.000000 P100 : 80975.000000 COUNT : 301 SUM : 1684970 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 : 105.663265 P95 : 952.416667 P99 : 2776.666667 P100 : 4143.000000 COUNT : 237 SUM : 57532 rocksdb.table.open.io.micros P50 : 1602.857143 P95 : 9240.000000 P99 : 13538.750000 P100 : 15957.000000 COUNT : 480 SUM : 1144364 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.567742 P95 : 7.038791 P99 : 10.135348 P100 : 16535.000000 COUNT : 6984556 SUM : 39839054 rocksdb.read.block.get.micros P50 : 522.553191 P95 : 3650.000000 P99 : 5915.555556 P100 : 9293.000000 COUNT : 960 SUM : 913244 rocksdb.write.raw.block.micros P50 : 0.511541 P95 : 0.971927 P99 : 2.692068 P100 : 13261.000000 COUNT : 9436531 SUM : 18207983 rocksdb.numfiles.in.singlecompaction P50 : 3.346667 P95 : 5.966667 P99 : 26.680000 P100 : 27.000000 COUNT : 122 SUM : 489 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.561121 P95 : 1201.059796 P99 : 2598.654545 P100 : 645775.000000 COUNT : 188814 SUM : 32852161 rocksdb.sst.read.micros P50 : 1.547230 P95 : 4.129162 P99 : 7.951430 P100 : 9616.000000 COUNT : 6987078 SUM : 26015054 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 9997999 SUM : 10317934968 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 : 210412.371134 P95 : 372200.000000 P99 : 659900.000000 P100 : 824991.000000 COUNT : 138 SUM : 29712408 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 : 296 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