[2024-11-04 15:32:56.712152] Starting SPDK v25.01-pre git sha1 f220d590c / DPDK 24.03.0 initialization... [2024-11-04 15:32:56.712458] [ 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_pid1939619 ] Set seed to 1730730776704939 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-04 15:32:56.863427] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-04 15:32:56.966006] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-04 15:32:56.966060] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 1939619' to capture a snapshot of events at runtime. [2024-11-04 15:32:56.966072] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-04 15:32:56.966103] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-04 15:32:56.966112] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid1939619 for offline analysis/debug. [2024-11-04 15:32:56.967449] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Mon Nov 4 15:32:59 2024 CPU: 72 * Intel(R) Xeon(R) Gold 6140 CPU @ 2.30GHz CPUCache: 25344 KB 2024/11/04-15:33:02 ... thread 0: (1000000,1000000) ops and (335012.8,335012.8) ops/second in (2.984961,2.984961) 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/8 629.19 MB 12.6 0.0 0.0 0.0 0.9 0.9 0.0 1.0 0.0 345.0 2.55 2.38 13 0.196 0 0 0.0 0.0 L1 3/3 188.12 MB 0.0 0.2 0.2 0.0 0.2 0.2 0.1 1.0 254.0 253.5 0.74 0.73 1 0.742 191K 400 0.0 0.0 L2 1/1 100.84 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.0 2.6 239.6 239.2 0.67 0.65 1 0.671 163K 289 0.0 0.0 L3 19/12 1004.53 MB 0.1 0.1 0.1 0.0 0.1 0.1 0.0 1.0 204.9 204.9 0.29 0.27 1 0.291 60K 0 0.0 0.0 L4 120/0 9.47 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 112/0 8.74 GB 0.1 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 265/24 20.09 GB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.1 302.8 4.26 4.03 16 0.266 415K 689 0.0 0.0 Int 0/0 0.00 KB 0.0 0.4 0.3 0.1 1.3 1.2 0.1 1.5 96.1 302.8 4.26 4.03 16 0.266 415K 689 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.3 0.1 0.4 0.3 0.0 0.0 240.0 239.6 1.70 1.65 3 0.568 415K 689 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 345.0 2.55 2.38 13 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): 3.1 total, 3.0 interval Flush(GB): cumulative 0.860, interval 0.860 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.26 GB write, 422.12 MB/s write, 0.40 GB read, 133.92 MB/s read, 4.3 seconds Interval compaction: 1.26 GB write, 431.51 MB/s write, 0.40 GB read, 136.90 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: 2, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 2, interval: 2 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 128345 Average: 2.1232 StdDev: 5.55 Min: 0 Median: 1.4287 Max: 1196 Percentiles: P50: 1.43 P75: 1.84 P99: 5.92 P99.9: 13.10 P99.99: 177.77 ------------------------------------------------------ [ 0, 1 ] 30778 23.981% 23.981% ##### ( 1, 2 ] 77891 60.689% 84.669% ############ ( 2, 3 ] 11036 8.599% 93.268% ## ( 3, 4 ] 4342 3.383% 96.651% # ( 4, 6 ] 3136 2.443% 99.095% ( 6, 10 ] 893 0.696% 99.790% ( 10, 15 ] 232 0.181% 99.971% ( 15, 22 ] 22 0.017% 99.988% ( 22, 34 ] 3 0.002% 99.991% ( 34, 51 ] 1 0.001% 99.991% ( 170, 250 ] 12 0.009% 100.001% ( 250, 380 ] 7 0.005% 100.006% ( 380, 580 ] 6 0.005% 100.011% ( 870, 1300 ] 1 0.001% 100.012% ** Level 1 read latency histogram (micros): Count: 26348 Average: 2.1838 StdDev: 5.54 Min: 1 Median: 1.4821 Max: 699 Percentiles: P50: 1.48 P75: 1.89 P99: 5.83 P99.9: 11.66 P99.99: 224.61 ------------------------------------------------------ [ 0, 1 ] 5315 20.172% 20.172% #### ( 1, 2 ] 16301 61.868% 82.040% ############ ( 2, 3 ] 2735 10.380% 92.421% ## ( 3, 4 ] 1045 3.966% 96.387% # ( 4, 6 ] 753 2.858% 99.245% # ( 6, 10 ] 165 0.626% 99.871% ( 10, 15 ] 29 0.110% 99.981% ( 15, 22 ] 2 0.008% 99.989% ( 22, 34 ] 1 0.004% 99.992% ( 170, 250 ] 2 0.008% 100.000% ( 380, 580 ] 1 0.004% 100.004% ( 580, 870 ] 1 0.004% 100.008% ** Level 2 read latency histogram (micros): Count: 40080 Average: 2.8212 StdDev: 41.05 Min: 0 Median: 1.4714 Max: 5744 Percentiles: P50: 1.47 P75: 1.89 P99: 8.74 P99.9: 109.92 P99.99: 578.40 ------------------------------------------------------ [ 0, 1 ] 8816 21.996% 21.996% #### ( 1, 2 ] 23811 59.409% 81.405% ############ ( 2, 3 ] 3752 9.361% 90.766% ## ( 3, 4 ] 1577 3.935% 94.701% # ( 4, 6 ] 1379 3.441% 98.141% # ( 6, 10 ] 503 1.255% 99.396% ( 10, 15 ] 153 0.382% 99.778% ( 15, 22 ] 13 0.032% 99.810% ( 22, 34 ] 1 0.002% 99.813% ( 34, 51 ] 2 0.005% 99.818% ( 51, 76 ] 1 0.002% 99.820% ( 76, 110 ] 32 0.080% 99.900% ( 110, 170 ] 22 0.055% 99.955% ( 170, 250 ] 9 0.022% 99.978% ( 250, 380 ] 4 0.010% 99.988% ( 380, 580 ] 1 0.002% 99.990% ( 580, 870 ] 1 0.002% 99.993% ( 1300, 1900 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 2 0.005% 100.002% ** Level 3 read latency histogram (micros): Count: 27191 Average: 8.5243 StdDev: 131.75 Min: 1 Median: 1.7677 Max: 6397 Percentiles: P50: 1.77 P75: 2.62 P99: 14.11 P99.9: 2353.87 P99.99: 5745.39 ------------------------------------------------------ [ 0, 1 ] 1152 4.237% 4.237% # ( 1, 2 ] 16210 59.615% 63.852% ############ ( 2, 3 ] 4876 17.932% 81.784% #### ( 3, 4 ] 1890 6.951% 88.735% # ( 4, 6 ] 1906 7.010% 95.745% # ( 6, 10 ] 674 2.479% 98.224% ( 10, 15 ] 258 0.949% 99.173% ( 15, 22 ] 30 0.110% 99.283% ( 22, 34 ] 4 0.015% 99.298% ( 34, 51 ] 17 0.063% 99.360% ( 51, 76 ] 11 0.040% 99.401% ( 76, 110 ] 5 0.018% 99.419% ( 110, 170 ] 68 0.250% 99.669% ( 170, 250 ] 26 0.096% 99.765% ( 250, 380 ] 8 0.029% 99.794% ( 380, 580 ] 5 0.018% 99.812% ( 580, 870 ] 4 0.015% 99.827% ( 870, 1300 ] 9 0.033% 99.860% ( 1300, 1900 ] 5 0.018% 99.879% ( 1900, 2900 ] 15 0.055% 99.934% ( 2900, 4400 ] 12 0.044% 99.978% ( 4400, 6600 ] 7 0.026% 100.004% ** Level 4 read latency histogram (micros): Count: 15 Average: 3416.0000 StdDev: 1121.40 Min: 1756 Median: 3275.0000 Max: 5720 Percentiles: P50: 3275.00 P75: 4212.50 P99: 5720.00 P99.9: 5720.00 P99.99: 5720.00 ------------------------------------------------------ ( 1300, 1900 ] 2 13.333% 13.333% ### ( 1900, 2900 ] 4 26.667% 40.000% ##### ( 2900, 4400 ] 6 40.000% 80.000% ######## ( 4400, 6600 ] 3 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 3.1 total, 3.0 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 322.31 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.212 H:M:S, 6.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 329.39 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.212 H:M:S, 7.1 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 3 num-running-flushes: 1 2024/11/04-15:33:05 ... thread 0: (1000000,2000000) ops and (325611.9,330245.4) ops/second in (3.071141,6.056102) 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/4 1.35 GB 106.5 1.0 0.0 1.0 2.8 1.8 0.0 1.5 107.3 307.9 9.38 8.89 32 0.293 1022K 4855 0.0 0.0 L1 1/0 49.84 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 238.9 237.3 2.63 2.58 2 1.315 638K 3986 0.0 0.0 L2 1/1 100.84 MB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 239.6 239.2 0.67 0.65 1 0.671 163K 289 0.0 0.0 L3 23/12 1.36 GB 0.4 0.5 0.4 0.1 0.5 0.4 0.0 1.2 208.3 207.9 2.63 2.52 4 0.659 557K 1228 0.0 0.0 L4 120/0 9.47 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 112/0 8.74 GB 0.1 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 266/17 21.06 GB 0.0 2.3 0.9 1.4 4.1 2.8 0.4 2.2 153.1 275.6 15.32 14.65 39 0.393 2381K 10K 0.0 0.0 Int 0/0 0.00 KB 0.0 2.3 0.9 1.4 4.1 2.8 0.4 2.2 153.1 275.6 15.32 14.65 39 0.393 2381K 10K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 2.3 0.9 1.4 2.3 0.9 0.0 0.0 235.6 234.6 9.95 9.68 11 0.905 2381K 10K 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 351.6 5.37 4.96 28 0.192 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 6.1 total, 6.1 interval Flush(GB): cumulative 1.843, interval 1.843 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: 4.12 GB write, 689.25 MB/s write, 2.29 GB read, 382.84 MB/s read, 15.3 seconds Interval compaction: 4.12 GB write, 696.81 MB/s write, 2.29 GB read, 387.04 MB/s read, 15.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: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 396253 Average: 2.4854 StdDev: 6.37 Min: 0 Median: 1.6430 Max: 1302 Percentiles: P50: 1.64 P75: 2.20 P99: 7.16 P99.9: 13.82 P99.99: 20.77 ------------------------------------------------------ [ 0, 1 ] 43518 10.982% 10.982% ## ( 1, 2 ] 240438 60.678% 71.660% ############ ( 2, 3 ] 66881 16.878% 88.539% ### ( 3, 4 ] 22636 5.713% 94.251% # ( 4, 6 ] 17723 4.473% 98.724% # ( 6, 10 ] 3776 0.953% 99.677% ( 10, 15 ] 1160 0.293% 99.969% ( 15, 22 ] 100 0.025% 99.995% ( 22, 34 ] 17 0.004% 99.999% ( 34, 51 ] 1 0.000% 99.999% ( 51, 76 ] 2 0.001% 100.000% ( 110, 170 ] 11 0.003% 100.003% ( 170, 250 ] 35 0.009% 100.011% ( 250, 380 ] 16 0.004% 100.015% ( 380, 580 ] 17 0.004% 100.020% ( 580, 870 ] 3 0.001% 100.020% ( 870, 1300 ] 5 0.001% 100.022% ( 1300, 1900 ] 1 0.000% 100.022% ** Level 1 read latency histogram (micros): Count: 145842 Average: 2.9621 StdDev: 9.63 Min: 1 Median: 1.7997 Max: 1163 Percentiles: P50: 1.80 P75: 2.60 P99: 9.18 P99.9: 96.76 P99.99: 240.69 ------------------------------------------------------ [ 0, 1 ] 7439 5.101% 5.101% # ( 1, 2 ] 81880 56.143% 61.244% ########### ( 2, 3 ] 33199 22.764% 84.007% ##### ( 3, 4 ] 10175 6.977% 90.984% # ( 4, 6 ] 9727 6.670% 97.654% # ( 6, 10 ] 2473 1.696% 99.349% ( 10, 15 ] 713 0.489% 99.838% ( 15, 22 ] 73 0.050% 99.888% ( 22, 34 ] 8 0.005% 99.894% ( 76, 110 ] 15 0.010% 99.904% ( 110, 170 ] 83 0.057% 99.961% ( 170, 250 ] 48 0.033% 99.994% ( 250, 380 ] 17 0.012% 100.005% ( 380, 580 ] 11 0.008% 100.013% ( 580, 870 ] 4 0.003% 100.016% ( 870, 1300 ] 3 0.002% 100.018% ** Level 2 read latency histogram (micros): Count: 40691 Average: 3.0529 StdDev: 41.30 Min: 0 Median: 1.4822 Max: 5744 Percentiles: P50: 1.48 P75: 1.91 P99: 9.14 P99.9: 166.95 P99.99: 573.09 ------------------------------------------------------ [ 0, 1 ] 8816 21.666% 21.666% #### ( 1, 2 ] 23908 58.755% 80.421% ############ ( 2, 3 ] 4075 10.014% 90.435% ## ( 3, 4 ] 1642 4.035% 94.471% # ( 4, 6 ] 1437 3.531% 98.002% # ( 6, 10 ] 517 1.271% 99.273% ( 10, 15 ] 156 0.383% 99.656% ( 15, 22 ] 13 0.032% 99.688% ( 22, 34 ] 1 0.002% 99.690% ( 34, 51 ] 2 0.005% 99.695% ( 51, 76 ] 1 0.002% 99.698% ( 76, 110 ] 32 0.079% 99.776% ( 110, 170 ] 53 0.130% 99.907% ( 170, 250 ] 21 0.052% 99.958% ( 250, 380 ] 11 0.027% 99.985% ( 380, 580 ] 2 0.005% 99.990% ( 580, 870 ] 1 0.002% 99.993% ( 1300, 1900 ] 1 0.002% 99.995% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 2 0.005% 100.002% ** Level 3 read latency histogram (micros): Count: 245733 Average: 3.6094 StdDev: 44.47 Min: 1 Median: 1.7550 Max: 6397 Percentiles: P50: 1.76 P75: 2.51 P99: 9.70 P99.9: 154.40 P99.99: 604.75 ------------------------------------------------------ [ 0, 1 ] 10946 4.454% 4.454% # ( 1, 2 ] 148239 60.325% 64.780% ############ ( 2, 3 ] 49330 20.075% 84.854% #### ( 3, 4 ] 15921 6.479% 91.333% # ( 4, 6 ] 13796 5.614% 96.947% # ( 6, 10 ] 5460 2.222% 99.169% ( 10, 15 ] 1083 0.441% 99.610% ( 15, 22 ] 91 0.037% 99.647% ( 22, 34 ] 9 0.004% 99.651% ( 34, 51 ] 174 0.071% 99.722% ( 51, 76 ] 105 0.043% 99.764% ( 76, 110 ] 113 0.046% 99.810% ( 110, 170 ] 299 0.122% 99.932% ( 170, 250 ] 101 0.041% 99.973% ( 250, 380 ] 28 0.011% 99.985% ( 380, 580 ] 14 0.006% 99.990% ( 580, 870 ] 5 0.002% 99.992% ( 870, 1300 ] 9 0.004% 99.996% ( 1300, 1900 ] 5 0.002% 99.998% ( 1900, 2900 ] 15 0.006% 100.004% ( 2900, 4400 ] 12 0.005% 100.009% ( 4400, 6600 ] 7 0.003% 100.012% ** Level 4 read latency histogram (micros): Count: 15 Average: 3416.0000 StdDev: 1121.40 Min: 1756 Median: 3275.0000 Max: 5720 Percentiles: P50: 3275.00 P75: 4212.50 P99: 5720.00 P99.9: 5720.00 P99.99: 5720.00 ------------------------------------------------------ ( 1300, 1900 ] 2 13.333% 13.333% ### ( 1900, 2900 ] 4 26.667% 40.000% ##### ( 2900, 4400 ] 6 40.000% 80.000% ######## ( 4400, 6600 ] 3 20.000% 100.000% #### ** DB Stats ** Uptime(secs): 6.1 total, 3.1 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 321.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:0.373 H:M:S, 6.1 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 320.48 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.161 H:M:S, 5.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/04-15:33:08 ... thread 0: (1000000,3000000) ops and (356669.0,338607.3) ops/second in (2.803720,8.859822) 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/4 2.20 GB 200.4 1.8 0.0 1.8 4.5 2.7 0.0 1.7 121.0 303.9 15.08 14.31 49 0.308 1852K 9083 0.0 0.0 L1 1/0 49.84 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 238.9 237.3 2.63 2.58 2 1.315 638K 3986 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 239.6 239.2 0.67 0.65 1 0.671 163K 289 0.0 0.0 L3 18/0 746.20 MB 0.7 1.6 0.5 1.0 1.6 0.5 0.0 2.9 232.7 232.1 6.85 6.57 5 1.370 1619K 4295 0.0 0.0 L4 126/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 214.1 214.1 1.06 1.01 1 1.056 229K 0 0.0 0.0 L5 120/0 9.35 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 279/4 21.91 GB 0.0 4.3 1.2 3.1 7.0 3.9 1.6 2.6 168.7 273.3 26.29 25.12 58 0.453 4503K 17K 0.0 0.0 Int 0/0 0.00 KB 0.0 4.3 1.2 3.1 7.0 3.9 1.6 2.6 168.7 273.3 26.29 25.12 58 0.453 4503K 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 4.3 1.2 3.1 4.3 1.2 0.0 0.0 239.6 238.7 18.50 17.93 16 1.156 4503K 17K 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 355.5 7.79 7.19 42 0.185 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.9 interval Flush(GB): cumulative 2.703, interval 2.703 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.02 GB write, 804.68 MB/s write, 4.33 GB read, 496.66 MB/s read, 26.3 seconds Interval compaction: 7.02 GB write, 810.71 MB/s write, 4.33 GB read, 500.38 MB/s read, 26.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 3, pending-compaction-bytes-delays: 0, pending-compaction-bytes-stops: 0, total-delays: 0, total-stops: 3, interval: 3 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 639585 Average: 2.4063 StdDev: 6.12 Min: 0 Median: 1.6120 Max: 1302 Percentiles: P50: 1.61 P75: 2.04 P99: 6.24 P99.9: 13.41 P99.99: 19.56 ------------------------------------------------------ [ 0, 1 ] 73645 11.514% 11.514% ## ( 1, 2 ] 402212 62.886% 74.401% ############# ( 2, 3 ] 101426 15.858% 90.259% ### ( 3, 4 ] 31948 4.995% 95.254% # ( 4, 6 ] 23656 3.699% 98.953% # ( 6, 10 ] 5006 0.783% 99.735% ( 10, 15 ] 1542 0.241% 99.977% ( 15, 22 ] 132 0.021% 99.997% ( 22, 34 ] 17 0.003% 100.000% ( 34, 51 ] 6 0.001% 100.001% ( 51, 76 ] 5 0.001% 100.002% ( 76, 110 ] 1 0.000% 100.002% ( 110, 170 ] 11 0.002% 100.003% ( 170, 250 ] 49 0.008% 100.011% ( 250, 380 ] 23 0.004% 100.015% ( 380, 580 ] 25 0.004% 100.019% ( 580, 870 ] 5 0.001% 100.019% ( 870, 1300 ] 8 0.001% 100.021% ( 1300, 1900 ] 1 0.000% 100.021% ** Level 1 read latency histogram (micros): Count: 145842 Average: 2.9621 StdDev: 9.63 Min: 1 Median: 1.7997 Max: 1163 Percentiles: P50: 1.80 P75: 2.60 P99: 9.18 P99.9: 96.76 P99.99: 240.69 ------------------------------------------------------ [ 0, 1 ] 7439 5.101% 5.101% # ( 1, 2 ] 81880 56.143% 61.244% ########### ( 2, 3 ] 33199 22.764% 84.007% ##### ( 3, 4 ] 10175 6.977% 90.984% # ( 4, 6 ] 9727 6.670% 97.654% # ( 6, 10 ] 2473 1.696% 99.349% ( 10, 15 ] 713 0.489% 99.838% ( 15, 22 ] 73 0.050% 99.888% ( 22, 34 ] 8 0.005% 99.894% ( 76, 110 ] 15 0.010% 99.904% ( 110, 170 ] 83 0.057% 99.961% ( 170, 250 ] 48 0.033% 99.994% ( 250, 380 ] 17 0.012% 100.005% ( 380, 580 ] 11 0.008% 100.013% ( 580, 870 ] 4 0.003% 100.016% ( 870, 1300 ] 3 0.002% 100.018% ** Level 2 read latency histogram (micros): Count: 65598 Average: 2.7977 StdDev: 32.54 Min: 0 Median: 1.5406 Max: 5744 Percentiles: P50: 1.54 P75: 1.95 P99: 8.66 P99.9: 138.76 P99.99: 373.38 ------------------------------------------------------ [ 0, 1 ] 10894 16.607% 16.607% ### ( 1, 2 ] 40520 61.770% 78.377% ############ ( 2, 3 ] 7959 12.133% 90.510% ## ( 3, 4 ] 2789 4.252% 94.762% # ( 4, 6 ] 2128 3.244% 98.006% # ( 6, 10 ] 981 1.495% 99.502% ( 10, 15 ] 183 0.279% 99.780% ( 15, 22 ] 15 0.023% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 2 0.003% 99.808% ( 51, 76 ] 3 0.005% 99.812% ( 76, 110 ] 32 0.049% 99.861% ( 110, 170 ] 53 0.081% 99.942% ( 170, 250 ] 21 0.032% 99.974% ( 250, 380 ] 11 0.017% 99.991% ( 380, 580 ] 2 0.003% 99.994% ( 580, 870 ] 1 0.002% 99.995% ( 1300, 1900 ] 1 0.002% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 2 0.003% 100.002% ** Level 3 read latency histogram (micros): Count: 323712 Average: 3.4904 StdDev: 39.51 Min: 1 Median: 1.7370 Max: 6397 Percentiles: P50: 1.74 P75: 2.45 P99: 9.53 P99.9: 162.10 P99.99: 705.57 ------------------------------------------------------ [ 0, 1 ] 15573 4.811% 4.811% # ( 1, 2 ] 198495 61.318% 66.129% ############ ( 2, 3 ] 64045 19.785% 85.914% #### ( 3, 4 ] 19595 6.053% 91.967% # ( 4, 6 ] 16504 5.098% 97.065% # ( 6, 10 ] 7088 2.190% 99.255% ( 10, 15 ] 1196 0.369% 99.624% ( 15, 22 ] 106 0.033% 99.657% ( 22, 34 ] 13 0.004% 99.661% ( 34, 51 ] 196 0.061% 99.722% ( 51, 76 ] 113 0.035% 99.757% ( 76, 110 ] 130 0.040% 99.797% ( 110, 170 ] 385 0.119% 99.916% ( 170, 250 ] 154 0.048% 99.963% ( 250, 380 ] 56 0.017% 99.981% ( 380, 580 ] 25 0.008% 99.988% ( 580, 870 ] 13 0.004% 99.992% ( 870, 1300 ] 13 0.004% 99.996% ( 1300, 1900 ] 6 0.002% 99.998% ( 1900, 2900 ] 15 0.005% 100.003% ( 2900, 4400 ] 12 0.004% 100.006% ( 4400, 6600 ] 7 0.002% 100.009% ** Level 4 read latency histogram (micros): Count: 45 Average: 1172.1111 StdDev: 1714.88 Min: 1 Median: 115.0000 Max: 5720 Percentiles: P50: 115.00 P75: 2337.50 P99: 5720.00 P99.9: 5720.00 P99.99: 5720.00 ------------------------------------------------------ [ 0, 1 ] 12 26.667% 26.667% ##### ( 1, 2 ] 5 11.111% 37.778% ## ( 2, 3 ] 1 2.222% 40.000% ( 10, 15 ] 1 2.222% 42.222% ( 15, 22 ] 1 2.222% 44.444% ( 22, 34 ] 1 2.222% 46.667% ( 34, 51 ] 1 2.222% 48.889% ( 110, 170 ] 6 13.333% 62.222% ### ( 170, 250 ] 1 2.222% 64.444% ( 250, 380 ] 1 2.222% 66.667% ( 1300, 1900 ] 2 4.444% 71.111% # ( 1900, 2900 ] 4 8.889% 80.000% ## ( 2900, 4400 ] 6 13.333% 93.333% ### ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 471.1750 StdDev: 512.40 Min: 106 Median: 223.3333 Max: 2247 Percentiles: P50: 223.33 P75: 725.00 P99: 2247.00 P99.9: 2247.00 P99.99: 2247.00 ------------------------------------------------------ ( 76, 110 ] 2 5.000% 5.000% # ( 110, 170 ] 12 30.000% 35.000% ###### ( 170, 250 ] 9 22.500% 57.500% ##### ( 250, 380 ] 3 7.500% 65.000% ## ( 380, 580 ] 3 7.500% 72.500% ## ( 580, 870 ] 2 5.000% 77.500% # ( 870, 1300 ] 6 15.000% 92.500% ### ( 1300, 1900 ] 1 2.500% 95.000% # ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 8.9 total, 2.8 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 330.70 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:0.373 H:M:S, 4.2 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 351.03 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:0.000 H:M:S, 0.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 1 2024/11/04-15:33:11 ... thread 0: (1000000,4000000) ops and (341097.7,339226.5) ops/second in (2.931711,11.791533) 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/4 3.24 GB 306.8 2.8 0.0 2.8 6.6 3.7 0.0 1.8 131.4 304.9 22.03 20.99 69 0.319 2938K 14K 0.0 0.0 L1 1/0 49.84 MB 5.0 0.6 0.4 0.2 0.6 0.4 0.1 1.4 238.9 237.3 2.63 2.58 2 1.315 638K 3986 0.0 0.0 L2 0/0 0.00 KB 0.0 0.2 0.1 0.1 0.2 0.1 0.4 2.6 239.6 239.2 0.67 0.65 1 0.671 163K 289 0.0 0.0 L3 18/0 746.20 MB 0.7 1.6 0.5 1.0 1.6 0.5 0.0 2.9 232.7 232.1 6.85 6.57 5 1.370 1619K 4295 0.0 0.0 L4 126/0 9.58 GB 1.0 0.2 0.2 0.0 0.2 0.2 0.5 1.0 214.1 214.1 1.06 1.01 1 1.056 229K 0 0.0 0.0 L5 120/0 9.35 GB 0.1 0.0 0.0 0.0 0.0 0.0 0.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 283/4 22.95 GB 0.0 5.4 1.2 4.1 9.1 5.0 1.6 2.4 165.6 280.3 33.24 31.79 78 0.426 5589K 23K 0.0 0.0 Int 0/0 0.00 KB 0.0 5.4 1.2 4.1 9.1 5.0 1.6 2.4 165.6 280.3 33.24 31.79 78 0.426 5589K 23K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 5.4 1.2 4.1 5.4 1.2 0.0 0.0 243.3 242.3 22.62 21.97 20 1.131 5589K 23K 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 361.3 10.62 9.83 58 0.183 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): 11.9 total, 11.8 interval Flush(GB): cumulative 3.747, interval 3.747 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: 9.10 GB write, 785.61 MB/s write, 5.37 GB read, 464.04 MB/s read, 33.2 seconds Interval compaction: 9.10 GB write, 790.03 MB/s write, 5.37 GB read, 466.65 MB/s read, 33.2 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 0, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 0, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 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: 899547 Average: 2.3096 StdDev: 6.35 Min: 0 Median: 1.5590 Max: 1592 Percentiles: P50: 1.56 P75: 1.95 P99: 5.96 P99.9: 13.12 P99.99: 19.98 ------------------------------------------------------ [ 0, 1 ] 128176 14.249% 14.249% ### ( 1, 2 ] 575327 63.957% 78.206% ############# ( 2, 3 ] 123131 13.688% 91.894% ### ( 3, 4 ] 37926 4.216% 96.111% # ( 4, 6 ] 26536 2.950% 99.061% # ( 6, 10 ] 6409 0.712% 99.773% ( 10, 15 ] 1829 0.203% 99.976% ( 15, 22 ] 173 0.019% 99.996% ( 22, 34 ] 21 0.002% 99.998% ( 34, 51 ] 9 0.001% 99.999% ( 51, 76 ] 6 0.001% 100.000% ( 76, 110 ] 5 0.001% 100.000% ( 110, 170 ] 11 0.001% 100.001% ( 170, 250 ] 64 0.007% 100.008% ( 250, 380 ] 33 0.004% 100.012% ( 380, 580 ] 32 0.004% 100.016% ( 580, 870 ] 8 0.001% 100.017% ( 870, 1300 ] 12 0.001% 100.018% ( 1300, 1900 ] 2 0.000% 100.018% ** Level 1 read latency histogram (micros): Count: 145842 Average: 2.9621 StdDev: 9.63 Min: 1 Median: 1.7997 Max: 1163 Percentiles: P50: 1.80 P75: 2.60 P99: 9.18 P99.9: 96.76 P99.99: 240.69 ------------------------------------------------------ [ 0, 1 ] 7439 5.101% 5.101% # ( 1, 2 ] 81880 56.143% 61.244% ########### ( 2, 3 ] 33199 22.764% 84.007% ##### ( 3, 4 ] 10175 6.977% 90.984% # ( 4, 6 ] 9727 6.670% 97.654% # ( 6, 10 ] 2473 1.696% 99.349% ( 10, 15 ] 713 0.489% 99.838% ( 15, 22 ] 73 0.050% 99.888% ( 22, 34 ] 8 0.005% 99.894% ( 76, 110 ] 15 0.010% 99.904% ( 110, 170 ] 83 0.057% 99.961% ( 170, 250 ] 48 0.033% 99.994% ( 250, 380 ] 17 0.012% 100.005% ( 380, 580 ] 11 0.008% 100.013% ( 580, 870 ] 4 0.003% 100.016% ( 870, 1300 ] 3 0.002% 100.018% ** Level 2 read latency histogram (micros): Count: 65598 Average: 2.7977 StdDev: 32.54 Min: 0 Median: 1.5406 Max: 5744 Percentiles: P50: 1.54 P75: 1.95 P99: 8.66 P99.9: 138.76 P99.99: 373.38 ------------------------------------------------------ [ 0, 1 ] 10894 16.607% 16.607% ### ( 1, 2 ] 40520 61.770% 78.377% ############ ( 2, 3 ] 7959 12.133% 90.510% ## ( 3, 4 ] 2789 4.252% 94.762% # ( 4, 6 ] 2128 3.244% 98.006% # ( 6, 10 ] 981 1.495% 99.502% ( 10, 15 ] 183 0.279% 99.780% ( 15, 22 ] 15 0.023% 99.803% ( 22, 34 ] 1 0.002% 99.805% ( 34, 51 ] 2 0.003% 99.808% ( 51, 76 ] 3 0.005% 99.812% ( 76, 110 ] 32 0.049% 99.861% ( 110, 170 ] 53 0.081% 99.942% ( 170, 250 ] 21 0.032% 99.974% ( 250, 380 ] 11 0.017% 99.991% ( 380, 580 ] 2 0.003% 99.994% ( 580, 870 ] 1 0.002% 99.995% ( 1300, 1900 ] 1 0.002% 99.997% ( 1900, 2900 ] 1 0.002% 99.998% ( 4400, 6600 ] 2 0.003% 100.002% ** Level 3 read latency histogram (micros): Count: 323712 Average: 3.4904 StdDev: 39.51 Min: 1 Median: 1.7370 Max: 6397 Percentiles: P50: 1.74 P75: 2.45 P99: 9.53 P99.9: 162.10 P99.99: 705.57 ------------------------------------------------------ [ 0, 1 ] 15573 4.811% 4.811% # ( 1, 2 ] 198495 61.318% 66.129% ############ ( 2, 3 ] 64045 19.785% 85.914% #### ( 3, 4 ] 19595 6.053% 91.967% # ( 4, 6 ] 16504 5.098% 97.065% # ( 6, 10 ] 7088 2.190% 99.255% ( 10, 15 ] 1196 0.369% 99.624% ( 15, 22 ] 106 0.033% 99.657% ( 22, 34 ] 13 0.004% 99.661% ( 34, 51 ] 196 0.061% 99.722% ( 51, 76 ] 113 0.035% 99.757% ( 76, 110 ] 130 0.040% 99.797% ( 110, 170 ] 385 0.119% 99.916% ( 170, 250 ] 154 0.048% 99.963% ( 250, 380 ] 56 0.017% 99.981% ( 380, 580 ] 25 0.008% 99.988% ( 580, 870 ] 13 0.004% 99.992% ( 870, 1300 ] 13 0.004% 99.996% ( 1300, 1900 ] 6 0.002% 99.998% ( 1900, 2900 ] 15 0.005% 100.003% ( 2900, 4400 ] 12 0.004% 100.006% ( 4400, 6600 ] 7 0.002% 100.009% ** Level 4 read latency histogram (micros): Count: 45 Average: 1172.1111 StdDev: 1714.88 Min: 1 Median: 115.0000 Max: 5720 Percentiles: P50: 115.00 P75: 2337.50 P99: 5720.00 P99.9: 5720.00 P99.99: 5720.00 ------------------------------------------------------ [ 0, 1 ] 12 26.667% 26.667% ##### ( 1, 2 ] 5 11.111% 37.778% ## ( 2, 3 ] 1 2.222% 40.000% ( 10, 15 ] 1 2.222% 42.222% ( 15, 22 ] 1 2.222% 44.444% ( 22, 34 ] 1 2.222% 46.667% ( 34, 51 ] 1 2.222% 48.889% ( 110, 170 ] 6 13.333% 62.222% ### ( 170, 250 ] 1 2.222% 64.444% ( 250, 380 ] 1 2.222% 66.667% ( 1300, 1900 ] 2 4.444% 71.111% # ( 1900, 2900 ] 4 8.889% 80.000% ## ( 2900, 4400 ] 6 13.333% 93.333% ### ( 4400, 6600 ] 3 6.667% 100.000% # ** Level 5 read latency histogram (micros): Count: 40 Average: 471.1750 StdDev: 512.40 Min: 106 Median: 223.3333 Max: 2247 Percentiles: P50: 223.33 P75: 725.00 P99: 2247.00 P99.9: 2247.00 P99.99: 2247.00 ------------------------------------------------------ ( 76, 110 ] 2 5.000% 5.000% # ( 110, 170 ] 12 30.000% 35.000% ###### ( 170, 250 ] 9 22.500% 57.500% ##### ( 250, 380 ] 3 7.500% 65.000% ## ( 380, 580 ] 3 7.500% 72.500% ## ( 580, 870 ] 2 5.000% 77.500% # ( 870, 1300 ] 6 15.000% 92.500% ### ( 1300, 1900 ] 1 2.500% 95.000% # ( 1900, 2900 ] 2 5.000% 100.000% # ** DB Stats ** Uptime(secs): 11.9 total, 2.9 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 331.93 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.536 H:M:S, 4.5 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 335.66 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.163 H:M:S, 5.6 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: 20000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 19378.7 MB (estimated) FileSize: 19378.7 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 : 4.081 micros/op 245038 ops/sec 20.009 seconds 4902999 operations; 237.4 MB/s Microseconds per write: Count: 4902999 Average: 4.0810 StdDev: 144.72 Min: 0 Median: 1.7482 Max: 203100 Percentiles: P50: 1.75 P75: 3.03 P99: 8.97 P99.9: 167.24 P99.99: 2305.27 ------------------------------------------------------ [ 0, 1 ] 710940 14.500% 14.500% ### ( 1, 2 ] 2326236 47.445% 61.945% ######### ( 2, 3 ] 620733 12.660% 74.606% ### ( 3, 4 ] 678466 13.838% 88.443% ### ( 4, 6 ] 470295 9.592% 98.035% ## ( 6, 10 ] 63768 1.301% 99.336% ( 10, 15 ] 16863 0.344% 99.680% ( 15, 22 ] 4979 0.102% 99.781% ( 22, 34 ] 1212 0.025% 99.806% ( 34, 51 ] 215 0.004% 99.810% ( 51, 76 ] 25 0.001% 99.811% ( 76, 110 ] 3 0.000% 99.811% ( 110, 170 ] 4571 0.093% 99.904% ( 170, 250 ] 320 0.007% 99.911% ( 250, 380 ] 76 0.002% 99.912% ( 380, 580 ] 13 0.000% 99.913% ( 580, 870 ] 3 0.000% 99.913% ( 870, 1300 ] 3457 0.071% 99.983% ( 1300, 1900 ] 3 0.000% 99.983% ( 1900, 2900 ] 816 0.017% 100.000% ( 6600, 9900 ] 1 0.000% 100.000% ( 22000, 33000 ] 1 0.000% 100.000% ( 110000, 170000 ] 2 0.000% 100.000% ( 170000, 250000 ] 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 : 151759 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 : 4902999 rocksdb.number.keys.read COUNT : 0 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 5059894968 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 : 163 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 5967126 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 : 8221201567 rocksdb.compact.write.bytes COUNT : 8070521463 rocksdb.flush.write.bytes COUNT : 5013041984 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 : 15 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 : 98 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 : 4979869696 rocksdb.memtable.garbage.bytes.at.flush COUNT : 8567808 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 : 8263439916 rocksdb.non.last.level.read.count COUNT : 1993549 rocksdb.block.checksum.compute.count COUNT : 1993238 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.399614 P95 : 4.770869 P99 : 7.600667 P100 : 203097.000000 COUNT : 4902999 SUM : 17808939 rocksdb.compaction.times.micros P50 : 1005714.285714 P95 : 1853333.333333 P99 : 3964000.000000 P100 : 4217917.000000 COUNT : 24 SUM : 26475793 rocksdb.compaction.times.cpu_micros P50 : 996000.000000 P95 : 1830000.000000 P99 : 3964000.000000 P100 : 4040763.000000 COUNT : 24 SUM : 25760022 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 : 571.666667 P95 : 1256.173077 P99 : 1337.000000 P100 : 1337.000000 COUNT : 73 SUM : 49796 rocksdb.compaction.outfile.sync.micros P50 : 675.285714 P95 : 1209.038462 P99 : 1322.000000 P100 : 1322.000000 COUNT : 75 SUM : 51055 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 : 78.615385 P95 : 289.000000 P99 : 379.133333 P100 : 382.000000 COUNT : 104 SUM : 10962 rocksdb.table.open.io.micros P50 : 819.652778 P95 : 14755.555556 P99 : 18458.000000 P100 : 18458.000000 COUNT : 163 SUM : 378583 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.592303 P95 : 6.865070 P99 : 10.637515 P100 : 5448.000000 COUNT : 1992836 SUM : 9008791 rocksdb.read.block.get.micros P50 : 369.430894 P95 : 3683.333333 P99 : 6148.000000 P100 : 6842.000000 COUNT : 326 SUM : 252531 rocksdb.write.raw.block.micros P50 : 0.512438 P95 : 0.973633 P99 : 2.953271 P100 : 2714.000000 COUNT : 3169206 SUM : 6068438 rocksdb.numfiles.in.singlecompaction P50 : 3.394737 P95 : 12.250000 P99 : 19.000000 P100 : 19.000000 COUNT : 31 SUM : 137 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.562331 P95 : 1159.295895 P99 : 2426.507353 P100 : 202896.000000 COUNT : 39037 SUM : 5972021 rocksdb.sst.read.micros P50 : 1.540419 P95 : 3.847986 P99 : 7.411512 P100 : 6397.000000 COUNT : 1993711 SUM : 5063734 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 : 4902999 SUM : 5059894968 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 : 175714.285714 P95 : 261375.000000 P99 : 356275.000000 P100 : 362106.000000 COUNT : 73 SUM : 13220645 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 : 98 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