[2024-11-19 02:54:39.230018] Starting SPDK v25.01-pre git sha1 d47eb51c9 / DPDK 22.11.4 initialization... [2024-11-19 02:54:39.230283] [ 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_pid192657 ] Set seed to 1731981279223326 because --seed was 0 EAL: No free 2048 kB hugepages reported on node 1 [2024-11-19 02:54:39.343049] app.c: 919:spdk_app_start: *NOTICE*: Total cores available: 1 [2024-11-19 02:54:39.364409] app.c: 612:app_setup_trace: *NOTICE*: Tracepoint Group Mask 0x80 specified. [2024-11-19 02:54:39.364450] app.c: 613:app_setup_trace: *NOTICE*: Use 'spdk_trace -s rocksdb -p 192657' to capture a snapshot of events at runtime. [2024-11-19 02:54:39.364461] app.c: 618:app_setup_trace: *NOTICE*: 'spdk_trace' without parameters will also work if this is the only [2024-11-19 02:54:39.364472] app.c: 619:app_setup_trace: *NOTICE*: SPDK application currently running. [2024-11-19 02:54:39.364480] app.c: 620:app_setup_trace: *NOTICE*: Or copy /dev/shm/rocksdb_trace.pid192657 for offline analysis/debug. [2024-11-19 02:54:39.365037] reactor.c:1005:reactor_run: *NOTICE*: Reactor started on core 0 RocksDB: version 8.1.1 Date: Tue Nov 19 02:54:43 2024 CPU: 96 * Intel(R) Xeon(R) Gold 6252 CPU @ 2.10GHz CPUCache: 36608 KB 2024/11/19-02:54:52 ... thread 0: (1000000,1000000) ops and (109971.7,109971.7) ops/second in (9.093248,9.093248) 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/12 1.95 GB 50.4 0.3 0.0 0.3 1.2 0.9 0.0 1.4 34.2 130.0 9.21 3.78 11 0.837 319K 393 0.0 0.0 L1 8/8 970.12 MB 0.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 L3 22/5 1.38 GB 0.9 2.6 1.4 1.2 2.6 1.4 0.0 1.9 106.5 105.4 25.32 12.79 8 3.165 610K 0 0.0 0.0 L4 181/11 10.25 GB 1.0 5.1 3.5 1.6 5.0 3.4 0.0 1.5 111.4 110.2 46.78 24.80 33 1.418 2639K 1318 0.0 0.0 L5 1120/0 92.03 GB 0.9 0.0 0.0 0.0 0.0 0.0 2.6 0.0 0.0 0.0 0.00 0.00 0 0.000 0 0 0.0 0.0 Sum 1346/36 106.56 GB 0.0 8.0 4.8 3.2 8.8 5.6 2.7 10.2 101.1 110.9 81.30 41.36 52 1.564 3569K 1711 0.0 0.0 Int 0/0 0.00 KB 0.0 8.0 4.8 3.2 8.8 5.6 2.7 10.2 101.1 110.9 81.30 41.36 52 1.564 3569K 1711 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 8.0 4.8 3.2 7.9 4.8 0.0 0.0 110.9 109.8 74.14 38.92 42 1.765 3569K 1711 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 123.1 7.16 2.45 10 0.716 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 9.3 total, 9.1 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: 8.81 GB write, 969.30 MB/s write, 8.03 GB read, 883.66 MB/s read, 81.3 seconds Interval compaction: 8.81 GB write, 991.75 MB/s write, 8.03 GB read, 904.12 MB/s read, 81.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: 22, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 10, total-stops: 22, interval: 31 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 382491 Average: 15.5978 StdDev: 207.43 Min: 1 Median: 1.8909 Max: 49118 Percentiles: P50: 1.89 P75: 2.89 P99: 14.14 P99.9: 2574.20 P99.99: 4086.67 ------------------------------------------------------ [ 0, 1 ] 13700 3.582% 3.582% # ( 1, 2 ] 199292 52.104% 55.685% ########## ( 2, 3 ] 83286 21.775% 77.460% #### ( 3, 4 ] 37155 9.714% 87.174% ## ( 4, 6 ] 35373 9.248% 96.422% ## ( 6, 10 ] 8646 2.260% 98.683% ( 10, 15 ] 1466 0.383% 99.066% ( 15, 22 ] 186 0.049% 99.114% ( 22, 34 ] 20 0.005% 99.120% ( 34, 51 ] 6 0.002% 99.121% ( 51, 76 ] 18 0.005% 99.126% ( 76, 110 ] 3 0.001% 99.127% ( 110, 170 ] 25 0.007% 99.133% ( 170, 250 ] 88 0.023% 99.156% ( 250, 380 ] 209 0.055% 99.211% ( 380, 580 ] 470 0.123% 99.334% ( 580, 870 ] 724 0.189% 99.523% ( 870, 1300 ] 726 0.190% 99.713% ( 1300, 1900 ] 491 0.128% 99.841% ( 1900, 2900 ] 333 0.087% 99.928% ( 2900, 4400 ] 298 0.078% 100.006% ( 4400, 6600 ] 81 0.021% 100.027% ( 6600, 9900 ] 9 0.002% 100.030% ( 9900, 14000 ] 2 0.001% 100.030% ( 14000, 22000 ] 2 0.001% 100.031% ( 22000, 33000 ] 2 0.001% 100.031% ( 33000, 50000 ] 2 0.001% 100.032% ** Level 1 read latency histogram (micros): Count: 158 Average: 1510.5570 StdDev: 1349.92 Min: 145 Median: 1050.3226 Max: 6580 Percentiles: P50: 1050.32 P75: 1860.87 P99: 6165.50 P99.9: 6556.55 P99.99: 6580.00 ------------------------------------------------------ ( 110, 170 ] 1 0.633% 0.633% ( 170, 250 ] 1 0.633% 1.266% ( 250, 380 ] 13 8.228% 9.494% ## ( 380, 580 ] 17 10.759% 20.253% ## ( 580, 870 ] 34 21.519% 41.772% #### ( 870, 1300 ] 31 19.620% 61.392% #### ( 1300, 1900 ] 23 14.557% 75.949% ### ( 1900, 2900 ] 13 8.228% 84.177% ## ( 2900, 4400 ] 17 10.759% 94.937% ## ( 4400, 6600 ] 8 5.063% 100.000% # ** Level 2 read latency histogram (micros): Count: 196194 Average: 12.0673 StdDev: 155.25 Min: 1 Median: 1.9732 Max: 10092 Percentiles: P50: 1.97 P75: 2.98 P99: 11.79 P99.9: 2298.38 P99.99: 4123.21 ------------------------------------------------------ [ 0, 1 ] 4194 2.138% 2.138% ( 1, 2 ] 96491 49.181% 51.319% ########## ( 2, 3 ] 47257 24.087% 75.406% ##### ( 3, 4 ] 20404 10.400% 85.806% ## ( 4, 6 ] 20079 10.234% 96.040% ## ( 6, 10 ] 5432 2.769% 98.809% # ( 10, 15 ] 1048 0.534% 99.343% ( 15, 22 ] 126 0.064% 99.407% ( 22, 34 ] 17 0.009% 99.416% ( 34, 51 ] 12 0.006% 99.422% ( 51, 76 ] 10 0.005% 99.427% ( 76, 110 ] 4 0.002% 99.429% ( 110, 170 ] 14 0.007% 99.436% ( 170, 250 ] 36 0.018% 99.455% ( 250, 380 ] 64 0.033% 99.487% ( 380, 580 ] 145 0.074% 99.561% ( 580, 870 ] 203 0.103% 99.665% ( 870, 1300 ] 247 0.126% 99.791% ( 1300, 1900 ] 167 0.085% 99.876% ( 1900, 2900 ] 120 0.061% 99.937% ( 2900, 4400 ] 128 0.065% 100.002% ( 4400, 6600 ] 42 0.021% 100.023% ( 6600, 9900 ] 6 0.003% 100.027% ( 9900, 14000 ] 2 0.001% 100.028% ** Level 3 read latency histogram (micros): Count: 1101211 Average: 11.5044 StdDev: 174.15 Min: 1 Median: 1.9781 Max: 53745 Percentiles: P50: 1.98 P75: 2.97 P99: 9.67 P99.9: 763.59 P99.99: 1115.89 ------------------------------------------------------ [ 0, 1 ] 20597 1.870% 1.870% ( 1, 2 ] 541897 49.209% 51.080% ########## ( 2, 3 ] 270511 24.565% 75.644% ##### ( 3, 4 ] 118634 10.773% 86.417% ## ( 4, 6 ] 113676 10.323% 96.740% ## ( 6, 10 ] 27094 2.460% 99.201% ( 10, 15 ] 4946 0.449% 99.650% ( 15, 22 ] 661 0.060% 99.710% ( 22, 34 ] 79 0.007% 99.717% ( 34, 51 ] 58 0.005% 99.722% ( 51, 76 ] 83 0.008% 99.730% ( 76, 110 ] 45 0.004% 99.734% ( 110, 170 ] 65 0.006% 99.740% ( 170, 250 ] 151 0.014% 99.754% ( 250, 380 ] 346 0.031% 99.785% ( 380, 580 ] 647 0.059% 99.844% ( 580, 870 ] 979 0.089% 99.933% ( 870, 1300 ] 1105 0.100% 100.033% ( 1300, 1900 ] 787 0.071% 100.104% ( 1900, 2900 ] 759 0.069% 100.173% ( 2900, 4400 ] 723 0.066% 100.239% ( 4400, 6600 ] 168 0.015% 100.254% ( 6600, 9900 ] 40 0.004% 100.258% ( 9900, 14000 ] 4 0.000% 100.258% ( 14000, 22000 ] 5 0.000% 100.259% ( 22000, 33000 ] 6 0.001% 100.259% ( 50000, 75000 ] 1 0.000% 100.259% ** Level 4 read latency histogram (micros): Count: 474663 Average: 21.6300 StdDev: 234.33 Min: 1 Median: 1.9631 Max: 25988 Percentiles: P50: 1.96 P75: 2.97 P99: 397.47 P99.9: 2677.78 P99.99: 3585.19 ------------------------------------------------------ [ 0, 1 ] 8953 1.886% 1.886% ( 1, 2 ] 237125 49.956% 51.843% ########## ( 2, 3 ] 113372 23.885% 75.727% ##### ( 3, 4 ] 49849 10.502% 86.229% ## ( 4, 6 ] 45978 9.686% 95.916% ## ( 6, 10 ] 11765 2.479% 98.394% ( 10, 15 ] 1870 0.394% 98.788% ( 15, 22 ] 255 0.054% 98.842% ( 22, 34 ] 39 0.008% 98.850% ( 34, 51 ] 36 0.008% 98.858% ( 51, 76 ] 52 0.011% 98.869% ( 76, 110 ] 19 0.004% 98.873% ( 110, 170 ] 50 0.011% 98.883% ( 170, 250 ] 177 0.037% 98.921% ( 250, 380 ] 314 0.066% 98.987% ( 380, 580 ] 714 0.150% 99.137% ( 580, 870 ] 1062 0.224% 99.361% ( 870, 1300 ] 1207 0.254% 99.615% ( 1300, 1900 ] 817 0.172% 99.787% ( 1900, 2900 ] 687 0.145% 99.932% ( 2900, 4400 ] 601 0.127% 100.059% ( 4400, 6600 ] 164 0.035% 100.093% ( 6600, 9900 ] 39 0.008% 100.102% ( 9900, 14000 ] 4 0.001% 100.102% ( 14000, 22000 ] 4 0.001% 100.103% ( 22000, 33000 ] 4 0.001% 100.104% ** Level 5 read latency histogram (micros): Count: 15770 Average: 1631.2456 StdDev: 1649.51 Min: 100 Median: 1110.4623 Max: 60107 Percentiles: P50: 1110.46 P75: 2152.06 P99: 6526.37 P99.9: 10908.60 P99.99: 40191.00 ------------------------------------------------------ ( 76, 110 ] 5 0.032% 0.032% ( 110, 170 ] 89 0.564% 0.596% ( 170, 250 ] 253 1.604% 2.200% ( 250, 380 ] 796 5.048% 7.248% # ( 380, 580 ] 1936 12.276% 19.524% ## ( 580, 870 ] 3040 19.277% 38.802% #### ( 870, 1300 ] 3158 20.025% 58.827% #### ( 1300, 1900 ] 2122 13.456% 72.283% ### ( 1900, 2900 ] 1700 10.780% 83.063% ## ( 2900, 4400 ] 1800 11.414% 94.477% ## ( 4400, 6600 ] 738 4.680% 99.157% # ( 6600, 9900 ] 116 0.736% 99.892% ( 9900, 14000 ] 5 0.032% 99.924% ( 14000, 22000 ] 7 0.044% 99.968% ( 22000, 33000 ] 3 0.019% 99.987% ( 33000, 50000 ] 1 0.006% 99.994% ( 50000, 75000 ] 2 0.013% 100.006% ** DB Stats ** Uptime(secs): 9.3 total, 9.1 interval Cumulative writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 0.96 GB, 105.76 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:4.962 H:M:S, 53.3 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 108.20 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.962 H:M:S, 54.5 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 6 num-running-flushes: 1 2024/11/19-02:54:56 ... thread 0: (1000000,2000000) ops and (272961.4,156779.5) ops/second in (3.663522,12.756770) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 19/12 2.93 GB 163.6 1.5 0.0 1.5 3.3 1.8 0.0 1.8 84.7 190.5 17.85 11.40 31 0.576 1535K 1808 0.0 0.0 L1 8/8 970.12 MB 0.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 L3 17/0 912.13 MB 0.9 2.6 1.4 1.2 2.6 1.4 0.0 1.9 106.5 105.4 25.32 12.79 8 3.165 610K 0 0.0 0.0 L4 176/0 9.74 GB 1.0 6.1 4.0 2.2 6.0 3.9 0.0 1.5 117.6 116.2 53.22 29.54 37 1.438 2927K 1318 0.0 0.0 L5 1132/0 93.01 GB 1.0 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 1352/20 107.52 GB 0.0 10.2 5.3 4.9 12.0 7.1 3.6 6.5 108.6 127.1 96.39 53.73 76 1.268 5073K 3126 0.0 0.0 Int 0/0 0.00 KB 0.0 10.2 5.3 4.9 12.0 7.1 3.6 6.5 108.6 127.1 96.39 53.73 76 1.268 5073K 3126 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 10.2 5.3 4.9 10.1 5.2 0.0 0.0 122.2 121.0 85.66 48.31 50 1.713 5073K 3126 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 176.1 10.73 5.42 26 0.413 0 0 0.0 0.0 Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0 Uptime(secs): 13.0 total, 12.8 interval Flush(GB): cumulative 1.846, interval 1.846 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.97 GB write, 944.75 MB/s write, 10.22 GB read, 807.12 MB/s read, 96.4 seconds Interval compaction: 11.97 GB write, 960.35 MB/s write, 10.22 GB read, 820.44 MB/s read, 96.4 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 1, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 1, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 11, total-stops: 22, interval: 32 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 675962 Average: 16.3767 StdDev: 165.98 Min: 1 Median: 1.7182 Max: 49118 Percentiles: P50: 1.72 P75: 2.59 P99: 304.56 P99.9: 1698.58 P99.99: 3024.16 ------------------------------------------------------ [ 0, 1 ] 73989 10.946% 10.946% ## ( 1, 2 ] 367563 54.376% 65.322% ########### ( 2, 3 ] 111420 16.483% 81.805% ### ( 3, 4 ] 47326 7.001% 88.806% # ( 4, 6 ] 41779 6.181% 94.987% # ( 6, 10 ] 10029 1.484% 96.471% ( 10, 15 ] 1765 0.261% 96.732% ( 15, 22 ] 230 0.034% 96.766% ( 22, 34 ] 26 0.004% 96.770% ( 34, 51 ] 12 0.002% 96.772% ( 51, 76 ] 19 0.003% 96.774% ( 76, 110 ] 1770 0.262% 97.036% ( 110, 170 ] 8042 1.190% 98.226% ( 170, 250 ] 4373 0.647% 98.873% ( 250, 380 ] 2050 0.303% 99.176% ( 380, 580 ] 2138 0.316% 99.492% ( 580, 870 ] 1447 0.214% 99.706% ( 870, 1300 ] 945 0.140% 99.846% ( 1300, 1900 ] 548 0.081% 99.927% ( 1900, 2900 ] 398 0.059% 99.986% ( 2900, 4400 ] 319 0.047% 100.033% ( 4400, 6600 ] 83 0.012% 100.046% ( 6600, 9900 ] 9 0.001% 100.047% ( 9900, 14000 ] 2 0.000% 100.047% ( 14000, 22000 ] 2 0.000% 100.048% ( 22000, 33000 ] 2 0.000% 100.048% ( 33000, 50000 ] 2 0.000% 100.048% ** Level 1 read latency histogram (micros): Count: 655 Average: 541.9267 StdDev: 874.42 Min: 82 Median: 220.2752 Max: 6580 Percentiles: P50: 220.28 P75: 565.00 P99: 4798.75 P99.9: 6419.88 P99.99: 6580.00 ------------------------------------------------------ ( 76, 110 ] 50 7.634% 7.634% ## ( 110, 170 ] 209 31.908% 39.542% ###### ( 170, 250 ] 109 16.641% 56.183% ### ( 250, 380 ] 77 11.756% 67.939% ## ( 380, 580 ] 50 7.634% 75.573% ## ( 580, 870 ] 63 9.618% 85.191% ## ( 870, 1300 ] 35 5.344% 90.534% # ( 1300, 1900 ] 23 3.511% 94.046% # ( 1900, 2900 ] 14 2.137% 96.183% ( 2900, 4400 ] 17 2.595% 98.779% # ( 4400, 6600 ] 8 1.221% 100.000% ** Level 2 read latency histogram (micros): Count: 196194 Average: 12.0673 StdDev: 155.25 Min: 1 Median: 1.9732 Max: 10092 Percentiles: P50: 1.97 P75: 2.98 P99: 11.79 P99.9: 2298.38 P99.99: 4123.21 ------------------------------------------------------ [ 0, 1 ] 4194 2.138% 2.138% ( 1, 2 ] 96491 49.181% 51.319% ########## ( 2, 3 ] 47257 24.087% 75.406% ##### ( 3, 4 ] 20404 10.400% 85.806% ## ( 4, 6 ] 20079 10.234% 96.040% ## ( 6, 10 ] 5432 2.769% 98.809% # ( 10, 15 ] 1048 0.534% 99.343% ( 15, 22 ] 126 0.064% 99.407% ( 22, 34 ] 17 0.009% 99.416% ( 34, 51 ] 12 0.006% 99.422% ( 51, 76 ] 10 0.005% 99.427% ( 76, 110 ] 4 0.002% 99.429% ( 110, 170 ] 14 0.007% 99.436% ( 170, 250 ] 36 0.018% 99.455% ( 250, 380 ] 64 0.033% 99.487% ( 380, 580 ] 145 0.074% 99.561% ( 580, 870 ] 203 0.103% 99.665% ( 870, 1300 ] 247 0.126% 99.791% ( 1300, 1900 ] 167 0.085% 99.876% ( 1900, 2900 ] 120 0.061% 99.937% ( 2900, 4400 ] 128 0.065% 100.002% ( 4400, 6600 ] 42 0.021% 100.023% ( 6600, 9900 ] 6 0.003% 100.027% ( 9900, 14000 ] 2 0.001% 100.028% ** Level 3 read latency histogram (micros): Count: 1170496 Average: 11.1364 StdDev: 169.23 Min: 1 Median: 1.9659 Max: 53745 Percentiles: P50: 1.97 P75: 2.96 P99: 9.70 P99.9: 745.24 P99.99: 1107.63 ------------------------------------------------------ [ 0, 1 ] 23323 1.993% 1.993% ( 1, 2 ] 581750 49.701% 51.694% ########## ( 2, 3 ] 285605 24.400% 76.094% ##### ( 3, 4 ] 123889 10.584% 86.678% ## ( 4, 6 ] 118047 10.085% 96.764% ## ( 6, 10 ] 28310 2.419% 99.182% ( 10, 15 ] 5085 0.434% 99.617% ( 15, 22 ] 682 0.058% 99.675% ( 22, 34 ] 82 0.007% 99.682% ( 34, 51 ] 58 0.005% 99.687% ( 51, 76 ] 86 0.007% 99.694% ( 76, 110 ] 95 0.008% 99.702% ( 110, 170 ] 310 0.026% 99.729% ( 170, 250 ] 299 0.026% 99.754% ( 250, 380 ] 411 0.035% 99.789% ( 380, 580 ] 718 0.061% 99.851% ( 580, 870 ] 1010 0.086% 99.937% ( 870, 1300 ] 1120 0.096% 100.033% ( 1300, 1900 ] 792 0.068% 100.100% ( 1900, 2900 ] 763 0.065% 100.166% ( 2900, 4400 ] 725 0.062% 100.228% ( 4400, 6600 ] 168 0.014% 100.242% ( 6600, 9900 ] 40 0.003% 100.245% ( 9900, 14000 ] 4 0.000% 100.246% ( 14000, 22000 ] 5 0.000% 100.246% ( 22000, 33000 ] 6 0.001% 100.247% ( 50000, 75000 ] 1 0.000% 100.247% ** Level 4 read latency histogram (micros): Count: 567406 Average: 21.0342 StdDev: 217.18 Min: 1 Median: 1.9486 Max: 25988 Percentiles: P50: 1.95 P75: 2.95 P99: 374.95 P99.9: 2456.08 P99.99: 3388.27 ------------------------------------------------------ [ 0, 1 ] 11345 1.999% 1.999% ( 1, 2 ] 287113 50.601% 52.600% ########## ( 2, 3 ] 133340 23.500% 76.100% ##### ( 3, 4 ] 56798 10.010% 86.110% ## ( 4, 6 ] 51883 9.144% 95.254% ## ( 6, 10 ] 13448 2.370% 97.624% ( 10, 15 ] 2052 0.362% 97.986% ( 15, 22 ] 286 0.050% 98.037% ( 22, 34 ] 42 0.007% 98.044% ( 34, 51 ] 41 0.007% 98.051% ( 51, 76 ] 55 0.010% 98.061% ( 76, 110 ] 574 0.101% 98.162% ( 110, 170 ] 2428 0.428% 98.590% ( 170, 250 ] 1484 0.262% 98.851% ( 250, 380 ] 877 0.155% 99.006% ( 380, 580 ] 1216 0.214% 99.220% ( 580, 870 ] 1336 0.235% 99.456% ( 870, 1300 ] 1293 0.228% 99.684% ( 1300, 1900 ] 835 0.147% 99.831% ( 1900, 2900 ] 706 0.124% 99.955% ( 2900, 4400 ] 606 0.107% 100.062% ( 4400, 6600 ] 165 0.029% 100.091% ( 6600, 9900 ] 39 0.007% 100.098% ( 9900, 14000 ] 4 0.001% 100.099% ( 14000, 22000 ] 4 0.001% 100.099% ( 22000, 33000 ] 4 0.001% 100.100% ** Level 5 read latency histogram (micros): Count: 53669 Average: 648.2359 StdDev: 1114.91 Min: 77 Median: 227.8907 Max: 60107 Percentiles: P50: 227.89 P75: 666.66 P99: 5387.64 P99.9: 8771.49 P99.99: 18152.11 ------------------------------------------------------ ( 76, 110 ] 3528 6.574% 6.574% # ( 110, 170 ] 16953 31.588% 38.162% ###### ( 170, 250 ] 8780 16.360% 54.521% ### ( 250, 380 ] 4554 8.485% 63.007% ## ( 380, 580 ] 5116 9.533% 72.539% ## ( 580, 870 ] 4420 8.236% 80.775% ## ( 870, 1300 ] 3545 6.605% 87.380% # ( 1300, 1900 ] 2241 4.176% 91.556% # ( 1900, 2900 ] 1816 3.384% 94.939% # ( 2900, 4400 ] 1848 3.443% 98.383% # ( 4400, 6600 ] 738 1.375% 99.758% ( 6600, 9900 ] 116 0.216% 99.974% ( 9900, 14000 ] 5 0.009% 99.983% ( 14000, 22000 ] 7 0.013% 99.996% ( 22000, 33000 ] 3 0.006% 100.002% ( 33000, 50000 ] 1 0.002% 100.004% ( 50000, 75000 ] 2 0.004% 100.007% ** DB Stats ** Uptime(secs): 13.0 total, 3.7 interval Cumulative writes: 0 writes, 2000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 1.92 GB, 151.77 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:5.028 H:M:S, 38.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 268.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.066 H:M:S, 1.8 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-02:55:04 ... thread 0: (1000000,3000000) ops and (117943.0,141273.3) ops/second in (8.478670,21.235440) seconds ** Compaction Stats [default] ** Level Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ L0 17/12 3.85 GB 257.3 3.8 0.0 3.8 6.5 2.8 0.0 2.4 129.1 224.1 29.75 22.80 51 0.583 3900K 10K 0.0 0.0 L1 8/8 970.12 MB 0.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 L3 17/0 912.13 MB 0.9 2.6 1.4 1.2 2.6 1.4 0.0 1.9 106.5 105.4 25.32 12.79 8 3.165 610K 0 0.0 0.0 L4 176/0 9.74 GB 1.0 6.1 4.0 2.2 6.0 3.9 0.0 1.5 117.6 116.2 53.22 29.54 37 1.438 2927K 1318 0.0 0.0 L5 1132/0 93.01 GB 1.0 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 1350/20 108.44 GB 0.0 12.5 5.3 7.2 15.2 8.0 3.6 5.5 118.2 143.3 108.29 65.13 96 1.128 7438K 11K 0.0 0.0 Int 0/0 0.00 KB 0.0 12.5 5.3 7.2 15.2 8.0 3.6 5.5 118.2 143.3 108.29 65.13 96 1.128 7438K 11K 0.0 0.0 ** Compaction Stats [default] ** Priority Files Size Score Read(GB) Rn(GB) Rnp1(GB) Write(GB) Wnew(GB) Moved(GB) W-Amp Rd(MB/s) Wr(MB/s) Comp(sec) CompMergeCPU(sec) Comp(cnt) Avg(sec) KeyIn KeyDrop Rblob(GB) Wblob(GB) --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Low 0/0 0.00 KB 0.0 12.5 5.3 7.2 12.4 5.2 0.0 0.0 135.4 134.2 94.48 57.02 55 1.718 7438K 11K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 2.8 2.8 0.0 0.0 0.0 205.4 13.80 8.12 41 0.337 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): 21.4 total, 21.2 interval Flush(GB): cumulative 2.768, interval 2.768 AddFile(GB): cumulative 0.000, interval 0.000 AddFile(Total Files): cumulative 0, interval 0 AddFile(L0 Files): cumulative 0, interval 0 AddFile(Keys): cumulative 0, interval 0 Cumulative compaction: 15.16 GB write, 723.57 MB/s write, 12.50 GB read, 596.67 MB/s read, 108.3 seconds Interval compaction: 15.16 GB write, 730.74 MB/s write, 12.50 GB read, 602.59 MB/s read, 108.3 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 11, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 11, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 10, pending-compaction-bytes-stops: 0, total-delays: 21, total-stops: 22, interval: 42 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 1294638 Average: 15.2949 StdDev: 126.44 Min: 0 Median: 1.5940 Max: 49118 Percentiles: P50: 1.59 P75: 2.22 P99: 249.91 P99.9: 1041.98 P99.99: 1901.29 ------------------------------------------------------ [ 0, 1 ] 226348 17.483% 17.483% ### ( 1, 2 ] 708747 54.745% 72.228% ########### ( 2, 3 ] 163050 12.594% 84.823% ### ( 3, 4 ] 65628 5.069% 89.892% # ( 4, 6 ] 54289 4.193% 94.085% # ( 6, 10 ] 11979 0.925% 95.010% ( 10, 15 ] 2142 0.165% 95.176% ( 15, 22 ] 294 0.023% 95.199% ( 22, 34 ] 30 0.002% 95.201% ( 34, 51 ] 15 0.001% 95.202% ( 51, 76 ] 45 0.003% 95.206% ( 76, 110 ] 7439 0.575% 95.780% ( 110, 170 ] 29289 2.262% 98.042% ( 170, 250 ] 12410 0.959% 99.001% ( 250, 380 ] 4851 0.375% 99.376% ( 380, 580 ] 4307 0.333% 99.708% ( 580, 870 ] 2078 0.161% 99.869% ( 870, 1300 ] 1006 0.078% 99.947% ( 1300, 1900 ] 561 0.043% 99.990% ( 1900, 2900 ] 415 0.032% 100.022% ( 2900, 4400 ] 329 0.025% 100.047% ( 4400, 6600 ] 83 0.006% 100.054% ( 6600, 9900 ] 10 0.001% 100.055% ( 9900, 14000 ] 2 0.000% 100.055% ( 14000, 22000 ] 2 0.000% 100.055% ( 22000, 33000 ] 2 0.000% 100.055% ( 33000, 50000 ] 2 0.000% 100.055% ** Level 1 read latency histogram (micros): Count: 113391 Average: 10.0747 StdDev: 81.69 Min: 1 Median: 3.6106 Max: 6580 Percentiles: P50: 3.61 P75: 4.82 P99: 157.27 P99.9: 823.21 P99.99: 4017.14 ------------------------------------------------------ [ 0, 1 ] 151 0.133% 0.133% ( 1, 2 ] 4154 3.663% 3.797% # ( 2, 3 ] 26841 23.671% 27.468% ##### ( 3, 4 ] 41844 36.902% 64.370% ####### ( 4, 6 ] 29541 26.052% 90.423% ##### ( 6, 10 ] 6089 5.370% 95.792% # ( 10, 15 ] 1824 1.609% 97.401% ( 15, 22 ] 580 0.512% 97.913% ( 22, 34 ] 43 0.038% 97.950% ( 34, 51 ] 3 0.003% 97.953% ( 76, 110 ] 296 0.261% 98.214% ( 110, 170 ] 1131 0.997% 99.212% ( 170, 250 ] 422 0.372% 99.584% ( 250, 380 ] 169 0.149% 99.733% ( 380, 580 ] 120 0.106% 99.839% ( 580, 870 ] 83 0.073% 99.912% ( 870, 1300 ] 38 0.034% 99.945% ( 1300, 1900 ] 24 0.021% 99.966% ( 1900, 2900 ] 14 0.012% 99.979% ( 2900, 4400 ] 17 0.015% 99.994% ( 4400, 6600 ] 8 0.007% 100.001% ** Level 2 read latency histogram (micros): Count: 196194 Average: 12.0673 StdDev: 155.25 Min: 1 Median: 1.9732 Max: 10092 Percentiles: P50: 1.97 P75: 2.98 P99: 11.79 P99.9: 2298.38 P99.99: 4123.21 ------------------------------------------------------ [ 0, 1 ] 4194 2.138% 2.138% ( 1, 2 ] 96491 49.181% 51.319% ########## ( 2, 3 ] 47257 24.087% 75.406% ##### ( 3, 4 ] 20404 10.400% 85.806% ## ( 4, 6 ] 20079 10.234% 96.040% ## ( 6, 10 ] 5432 2.769% 98.809% # ( 10, 15 ] 1048 0.534% 99.343% ( 15, 22 ] 126 0.064% 99.407% ( 22, 34 ] 17 0.009% 99.416% ( 34, 51 ] 12 0.006% 99.422% ( 51, 76 ] 10 0.005% 99.427% ( 76, 110 ] 4 0.002% 99.429% ( 110, 170 ] 14 0.007% 99.436% ( 170, 250 ] 36 0.018% 99.455% ( 250, 380 ] 64 0.033% 99.487% ( 380, 580 ] 145 0.074% 99.561% ( 580, 870 ] 203 0.103% 99.665% ( 870, 1300 ] 247 0.126% 99.791% ( 1300, 1900 ] 167 0.085% 99.876% ( 1900, 2900 ] 120 0.061% 99.937% ( 2900, 4400 ] 128 0.065% 100.002% ( 4400, 6600 ] 42 0.021% 100.023% ( 6600, 9900 ] 6 0.003% 100.027% ( 9900, 14000 ] 2 0.001% 100.028% ** Level 3 read latency histogram (micros): Count: 1172101 Average: 11.3638 StdDev: 169.30 Min: 1 Median: 1.9673 Max: 53745 Percentiles: P50: 1.97 P75: 2.96 P99: 9.92 P99.9: 748.25 P99.99: 1108.13 ------------------------------------------------------ [ 0, 1 ] 23323 1.990% 1.990% ( 1, 2 ] 581751 49.633% 51.623% ########## ( 2, 3 ] 285605 24.367% 75.990% ##### ( 3, 4 ] 123895 10.570% 86.560% ## ( 4, 6 ] 118052 10.072% 96.632% ## ( 6, 10 ] 28311 2.415% 99.048% ( 10, 15 ] 5085 0.434% 99.481% ( 15, 22 ] 682 0.058% 99.540% ( 22, 34 ] 82 0.007% 99.547% ( 34, 51 ] 58 0.005% 99.551% ( 51, 76 ] 86 0.007% 99.559% ( 76, 110 ] 314 0.027% 99.586% ( 110, 170 ] 1197 0.102% 99.688% ( 170, 250 ] 599 0.051% 99.739% ( 250, 380 ] 511 0.044% 99.782% ( 380, 580 ] 778 0.066% 99.849% ( 580, 870 ] 1034 0.088% 99.937% ( 870, 1300 ] 1121 0.096% 100.033% ( 1300, 1900 ] 792 0.068% 100.100% ( 1900, 2900 ] 763 0.065% 100.165% ( 2900, 4400 ] 726 0.062% 100.227% ( 4400, 6600 ] 168 0.014% 100.242% ( 6600, 9900 ] 40 0.003% 100.245% ( 9900, 14000 ] 4 0.000% 100.245% ( 14000, 22000 ] 5 0.000% 100.246% ( 22000, 33000 ] 6 0.001% 100.246% ( 50000, 75000 ] 1 0.000% 100.246% ** Level 4 read latency histogram (micros): Count: 585527 Average: 25.5423 StdDev: 216.30 Min: 1 Median: 1.9801 Max: 25988 Percentiles: P50: 1.98 P75: 3.13 P99: 463.12 P99.9: 2432.40 P99.99: 3383.78 ------------------------------------------------------ [ 0, 1 ] 11345 1.938% 1.938% ( 1, 2 ] 287126 49.037% 50.975% ########## ( 2, 3 ] 133402 22.783% 73.758% ##### ( 3, 4 ] 57359 9.796% 83.554% ## ( 4, 6 ] 52584 8.981% 92.535% ## ( 6, 10 ] 13535 2.312% 94.846% ( 10, 15 ] 2075 0.354% 95.201% ( 15, 22 ] 289 0.049% 95.250% ( 22, 34 ] 42 0.007% 95.257% ( 34, 51 ] 41 0.007% 95.264% ( 51, 76 ] 55 0.009% 95.274% ( 76, 110 ] 2963 0.506% 95.780% ( 110, 170 ] 11496 1.963% 97.743% ( 170, 250 ] 4510 0.770% 98.513% ( 250, 380 ] 2014 0.344% 98.857% ( 380, 580 ] 2011 0.343% 99.201% ( 580, 870 ] 1559 0.266% 99.467% ( 870, 1300 ] 1320 0.225% 99.692% ( 1300, 1900 ] 838 0.143% 99.836% ( 1900, 2900 ] 709 0.121% 99.957% ( 2900, 4400 ] 606 0.103% 100.060% ( 4400, 6600 ] 165 0.028% 100.088% ( 6600, 9900 ] 39 0.007% 100.095% ( 9900, 14000 ] 4 0.001% 100.096% ( 14000, 22000 ] 4 0.001% 100.096% ( 22000, 33000 ] 4 0.001% 100.097% ** Level 5 read latency histogram (micros): Count: 163900 Average: 334.1638 StdDev: 681.64 Min: 73 Median: 158.7991 Max: 60107 Percentiles: P50: 158.80 P75: 243.04 P99: 3772.77 P99.9: 6490.00 P99.99: 9746.66 ------------------------------------------------------ ( 51, 76 ] 2 0.001% 0.001% ( 76, 110 ] 19699 12.019% 12.020% ## ( 110, 170 ] 76538 46.698% 58.718% ######### ( 170, 250 ] 29231 17.835% 76.553% #### ( 250, 380 ] 11492 7.012% 83.564% # ( 380, 580 ] 10402 6.347% 89.911% # ( 580, 870 ] 5942 3.625% 93.536% # ( 870, 1300 ] 3759 2.293% 95.830% ( 1300, 1900 ] 2275 1.388% 97.218% ( 1900, 2900 ] 1845 1.126% 98.344% ( 2900, 4400 ] 1851 1.129% 99.473% ( 4400, 6600 ] 738 0.450% 99.923% ( 6600, 9900 ] 116 0.071% 99.994% ( 9900, 14000 ] 5 0.003% 99.997% ( 14000, 22000 ] 7 0.004% 100.001% ( 22000, 33000 ] 3 0.002% 100.003% ( 33000, 50000 ] 1 0.001% 100.004% ( 50000, 75000 ] 2 0.001% 100.005% ** DB Stats ** Uptime(secs): 21.4 total, 8.5 interval Cumulative writes: 0 writes, 3000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 2.88 GB, 137.66 MB/s Cumulative WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Cumulative stall: 00:00:9.607 H:M:S, 44.8 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 116.08 MB/s Interval WAL: 0 writes, 0 syncs, 0.00 writes per sync, written: 0.00 GB, 0.00 MB/s Interval stall: 00:00:4.580 H:M:S, 54.0 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 2 num-running-flushes: 1 2024/11/19-02:55:41 ... thread 0: (1000000,4000000) ops and (27320.1,69158.0) ops/second in (36.603111,57.838551) 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 3.80 GB 12.6 6.0 0.0 6.0 9.8 3.8 0.0 2.6 145.8 238.7 41.88 34.39 73 0.574 6202K 17K 0.0 0.0 L1 23/23 2.02 GB 0.0 2.0 1.1 0.9 2.0 1.1 0.0 1.9 70.9 70.4 29.40 14.66 1 29.397 2117K 16K 0.0 0.0 L3 17/0 912.13 MB 0.9 2.6 1.4 1.2 2.6 1.4 0.0 1.9 106.5 105.4 25.32 12.79 8 3.165 610K 0 0.0 0.0 L4 176/0 9.74 GB 1.0 6.1 4.0 2.2 6.0 3.9 0.0 1.5 117.6 116.2 53.22 29.54 37 1.438 2927K 1318 0.0 0.0 L5 1132/0 93.01 GB 1.0 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 1358/31 109.46 GB 0.0 16.7 6.4 10.3 20.4 10.1 3.6 5.4 114.5 139.6 149.82 91.39 119 1.259 11M 35K 0.0 0.0 Int 0/0 0.00 KB 0.0 16.7 6.4 10.3 20.4 10.1 3.6 5.4 114.5 139.6 149.82 91.39 119 1.259 11M 35K 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 16.7 6.4 10.3 16.6 6.3 0.0 0.0 129.5 128.5 132.43 80.11 61 2.171 11M 35K 0.0 0.0 High 0/0 0.00 KB 0.0 0.0 0.0 0.0 3.8 3.8 0.0 0.0 0.0 224.6 17.39 11.28 58 0.300 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): 58.1 total, 57.8 interval Flush(GB): cumulative 3.814, interval 3.814 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: 20.43 GB write, 360.34 MB/s write, 16.75 GB read, 295.42 MB/s read, 149.8 seconds Interval compaction: 20.43 GB write, 361.66 MB/s write, 16.75 GB read, 296.49 MB/s read, 149.8 seconds Write Stall (count): cf-l0-file-count-limit-delays-with-ongoing-compaction: 20, cf-l0-file-count-limit-stops-with-ongoing-compaction: 0, l0-file-count-limit-delays: 20, l0-file-count-limit-stops: 0, memtable-limit-delays: 0, memtable-limit-stops: 22, pending-compaction-bytes-delays: 18, pending-compaction-bytes-stops: 0, total-delays: 38, total-stops: 22, interval: 59 total count ** File Read Latency Histogram By Level [default] ** ** Level 0 read latency histogram (micros): Count: 2183997 Average: 23.8026 StdDev: 109.93 Min: 0 Median: 1.6723 Max: 49118 Percentiles: P50: 1.67 P75: 2.92 P99: 246.93 P99.9: 816.43 P99.99: 1639.17 ------------------------------------------------------ [ 0, 1 ] 392492 17.971% 17.971% #### ( 1, 2 ] 1040445 47.639% 65.611% ########## ( 2, 3 ] 222924 10.207% 75.818% ## ( 3, 4 ] 149705 6.855% 82.673% # ( 4, 6 ] 88797 4.066% 86.738% # ( 6, 10 ] 16905 0.774% 87.512% ( 10, 15 ] 3590 0.164% 87.677% ( 15, 22 ] 412 0.019% 87.696% ( 22, 34 ] 43 0.002% 87.698% ( 34, 51 ] 16 0.001% 87.698% ( 51, 76 ] 63 0.003% 87.701% ( 76, 110 ] 51955 2.379% 90.080% ( 110, 170 ] 161122 7.377% 97.458% # ( 170, 250 ] 35032 1.604% 99.062% ( 250, 380 ] 8974 0.411% 99.472% ( 380, 580 ] 6946 0.318% 99.790% ( 580, 870 ] 2934 0.134% 99.925% ( 870, 1300 ] 1098 0.050% 99.975% ( 1300, 1900 ] 576 0.026% 100.001% ( 1900, 2900 ] 533 0.024% 100.026% ( 2900, 4400 ] 368 0.017% 100.043% ( 4400, 6600 ] 83 0.004% 100.047% ( 6600, 9900 ] 11 0.001% 100.047% ( 9900, 14000 ] 2 0.000% 100.047% ( 14000, 22000 ] 2 0.000% 100.047% ( 22000, 33000 ] 2 0.000% 100.047% ( 33000, 50000 ] 2 0.000% 100.047% ** Level 1 read latency histogram (micros): Count: 326404 Average: 11.8877 StdDev: 58.02 Min: 1 Median: 3.6826 Max: 6580 Percentiles: P50: 3.68 P75: 4.99 P99: 165.84 P99.9: 532.82 P99.99: 2086.64 ------------------------------------------------------ [ 0, 1 ] 272 0.083% 0.083% ( 1, 2 ] 9885 3.028% 3.112% # ( 2, 3 ] 73193 22.424% 25.536% #### ( 3, 4 ] 116984 35.840% 61.376% ####### ( 4, 6 ] 90267 27.655% 89.031% ###### ( 6, 10 ] 14318 4.387% 93.418% # ( 10, 15 ] 4734 1.450% 94.868% ( 15, 22 ] 1830 0.561% 95.429% ( 22, 34 ] 107 0.033% 95.461% ( 34, 51 ] 5 0.002% 95.463% ( 76, 110 ] 2843 0.871% 96.334% ( 110, 170 ] 9350 2.865% 99.199% # ( 170, 250 ] 1714 0.525% 99.724% ( 250, 380 ] 367 0.112% 99.836% ( 380, 580 ] 273 0.084% 99.920% ( 580, 870 ] 140 0.043% 99.963% ( 870, 1300 ] 56 0.017% 99.980% ( 1300, 1900 ] 30 0.009% 99.989% ( 1900, 2900 ] 18 0.006% 99.994% ( 2900, 4400 ] 17 0.005% 100.000% ( 4400, 6600 ] 8 0.002% 100.002% ** Level 2 read latency histogram (micros): Count: 196194 Average: 12.0673 StdDev: 155.25 Min: 1 Median: 1.9732 Max: 10092 Percentiles: P50: 1.97 P75: 2.98 P99: 11.79 P99.9: 2298.38 P99.99: 4123.21 ------------------------------------------------------ [ 0, 1 ] 4194 2.138% 2.138% ( 1, 2 ] 96491 49.181% 51.319% ########## ( 2, 3 ] 47257 24.087% 75.406% ##### ( 3, 4 ] 20404 10.400% 85.806% ## ( 4, 6 ] 20079 10.234% 96.040% ## ( 6, 10 ] 5432 2.769% 98.809% # ( 10, 15 ] 1048 0.534% 99.343% ( 15, 22 ] 126 0.064% 99.407% ( 22, 34 ] 17 0.009% 99.416% ( 34, 51 ] 12 0.006% 99.422% ( 51, 76 ] 10 0.005% 99.427% ( 76, 110 ] 4 0.002% 99.429% ( 110, 170 ] 14 0.007% 99.436% ( 170, 250 ] 36 0.018% 99.455% ( 250, 380 ] 64 0.033% 99.487% ( 380, 580 ] 145 0.074% 99.561% ( 580, 870 ] 203 0.103% 99.665% ( 870, 1300 ] 247 0.126% 99.791% ( 1300, 1900 ] 167 0.085% 99.876% ( 1900, 2900 ] 120 0.061% 99.937% ( 2900, 4400 ] 128 0.065% 100.002% ( 4400, 6600 ] 42 0.021% 100.023% ( 6600, 9900 ] 6 0.003% 100.027% ( 9900, 14000 ] 2 0.001% 100.028% ** Level 3 read latency histogram (micros): Count: 1181097 Average: 12.3958 StdDev: 169.16 Min: 1 Median: 1.9750 Max: 53745 Percentiles: P50: 1.98 P75: 2.98 P99: 112.18 P99.9: 752.03 P99.99: 1108.97 ------------------------------------------------------ [ 0, 1 ] 23323 1.975% 1.975% ( 1, 2 ] 581751 49.255% 51.230% ########## ( 2, 3 ] 285605 24.181% 75.411% ##### ( 3, 4 ] 123895 10.490% 85.901% ## ( 4, 6 ] 118052 9.995% 95.896% ## ( 6, 10 ] 28311 2.397% 98.293% ( 10, 15 ] 5085 0.431% 98.724% ( 15, 22 ] 682 0.058% 98.781% ( 22, 34 ] 82 0.007% 98.788% ( 34, 51 ] 58 0.005% 98.793% ( 51, 76 ] 86 0.007% 98.801% ( 76, 110 ] 2099 0.178% 98.978% ( 110, 170 ] 7087 0.600% 99.578% ( 170, 250 ] 1616 0.137% 99.715% ( 250, 380 ] 669 0.057% 99.772% ( 380, 580 ] 879 0.074% 99.846% ( 580, 870 ] 1072 0.091% 99.937% ( 870, 1300 ] 1128 0.096% 100.032% ( 1300, 1900 ] 792 0.067% 100.099% ( 1900, 2900 ] 763 0.065% 100.164% ( 2900, 4400 ] 726 0.061% 100.226% ( 4400, 6600 ] 168 0.014% 100.240% ( 6600, 9900 ] 40 0.003% 100.243% ( 9900, 14000 ] 4 0.000% 100.244% ( 14000, 22000 ] 5 0.000% 100.244% ( 22000, 33000 ] 6 0.001% 100.244% ( 50000, 75000 ] 1 0.000% 100.245% ** Level 4 read latency histogram (micros): Count: 686951 Average: 43.2536 StdDev: 205.97 Min: 1 Median: 2.3373 Max: 25988 Percentiles: P50: 2.34 P75: 4.98 P99: 470.04 P99.9: 2303.65 P99.99: 3358.68 ------------------------------------------------------ [ 0, 1 ] 11345 1.652% 1.652% ( 1, 2 ] 287129 41.798% 43.449% ######## ( 2, 3 ] 133407 19.420% 62.869% #### ( 3, 4 ] 57420 8.359% 71.228% ## ( 4, 6 ] 52638 7.663% 78.890% ## ( 6, 10 ] 13542 1.971% 80.862% ( 10, 15 ] 2076 0.302% 81.164% ( 15, 22 ] 289 0.042% 81.206% ( 22, 34 ] 42 0.006% 81.212% ( 34, 51 ] 41 0.006% 81.218% ( 51, 76 ] 55 0.008% 81.226% ( 76, 110 ] 24157 3.517% 84.743% # ( 110, 170 ] 77487 11.280% 96.023% ## ( 170, 250 ] 15165 2.208% 98.230% ( 250, 380 ] 3834 0.558% 98.788% ( 380, 580 ] 3233 0.471% 99.259% ( 580, 870 ] 1899 0.276% 99.535% ( 870, 1300 ] 1365 0.199% 99.734% ( 1300, 1900 ] 848 0.123% 99.857% ( 1900, 2900 ] 726 0.106% 99.963% ( 2900, 4400 ] 606 0.088% 100.051% ( 4400, 6600 ] 165 0.024% 100.075% ( 6600, 9900 ] 39 0.006% 100.081% ( 9900, 14000 ] 4 0.001% 100.082% ( 14000, 22000 ] 4 0.001% 100.082% ( 22000, 33000 ] 4 0.001% 100.083% ** Level 5 read latency histogram (micros): Count: 776501 Average: 185.1380 StdDev: 329.07 Min: 73 Median: 139.8566 Max: 60107 Percentiles: P50: 139.86 P75: 164.41 P99: 1221.36 P99.9: 4648.91 P99.99: 7861.68 ------------------------------------------------------ ( 51, 76 ] 3 0.000% 0.000% ( 76, 110 ] 152225 19.604% 19.604% #### ( 110, 170 ] 474312 61.083% 80.688% ############ ( 170, 250 ] 90452 11.649% 92.336% ## ( 250, 380 ] 22586 2.909% 95.245% # ( 380, 580 ] 17794 2.292% 97.537% ( 580, 870 ] 8053 1.037% 98.574% ( 870, 1300 ] 4052 0.522% 99.095% ( 1300, 1900 ] 2343 0.302% 99.397% ( 1900, 2900 ] 1952 0.251% 99.649% ( 2900, 4400 ] 1869 0.241% 99.889% ( 4400, 6600 ] 738 0.095% 99.984% ( 6600, 9900 ] 116 0.015% 99.999% ( 9900, 14000 ] 5 0.001% 100.000% ( 14000, 22000 ] 7 0.001% 100.001% ( 22000, 33000 ] 3 0.000% 100.001% ( 33000, 50000 ] 1 0.000% 100.001% ( 50000, 75000 ] 2 0.000% 100.002% ** DB Stats ** Uptime(secs): 58.1 total, 36.6 interval Cumulative writes: 0 writes, 4000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 3.84 GB, 67.81 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:41.186 H:M:S, 70.9 percent Interval writes: 0 writes, 1000K keys, 0 commit groups, 0.0 writes per commit group, ingest: 984.19 MB, 26.89 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:31.578 H:M:S, 86.3 percent Write Stall (count): write-buffer-manager-limit-stops: 0, num-running-compactions: 1 num-running-flushes: 0 using bdev Nvme0n1 Initializing RocksDB Options from the specified file Initializing RocksDB Options from command-line flags Integrated BlobDB: blob cache disabled Keys: 16 bytes each (+ 0 bytes user-defined timestamp) Values: 1000 bytes each (1000 bytes after compression) Entries: 100000000 Prefix: 0 bytes Keys per prefix: 0 RawSize: 96893.3 MB (estimated) FileSize: 96893.3 MB (estimated) Write rate: 0 bytes/second Read rate: 0 ops/second Compression: NoCompression Compression sampling rate: 0 Memtablerep: SkipListFactory Perf Level: 1 ------------------------------------------------ DB path: [/mnt/rocksdb] readwhilewriting : 240.032 micros/op 16644 ops/sec 60.138 seconds 1000996 operations; 16.1 MB/s (250999 of 250999 found) Microseconds per read: Count: 1000996 Average: 240.0347 StdDev: 674.81 Min: 4 Median: 182.8175 Max: 66452 Percentiles: P50: 182.82 P75: 233.16 P99: 1051.43 P99.9: 11137.77 P99.99: 29245.28 ------------------------------------------------------ ( 3, 4 ] 3 0.000% 0.000% ( 4, 6 ] 34 0.003% 0.004% ( 6, 10 ] 270 0.027% 0.031% ( 10, 15 ] 119 0.012% 0.043% ( 15, 22 ] 498 0.050% 0.092% ( 22, 34 ] 16978 1.696% 1.788% ( 34, 51 ] 4039 0.403% 2.192% ( 51, 76 ] 462 0.046% 2.238% ( 76, 110 ] 407 0.041% 2.279% ( 110, 170 ] 413974 41.356% 43.635% ######## ( 170, 250 ] 397669 39.727% 83.362% ######## ( 250, 380 ] 98618 9.852% 93.214% ## ( 380, 580 ] 40460 4.042% 97.256% # ( 580, 870 ] 15083 1.507% 98.763% ( 870, 1300 ] 5622 0.562% 99.325% ( 1300, 1900 ] 2218 0.222% 99.546% ( 1900, 2900 ] 1536 0.153% 99.700% ( 2900, 4400 ] 1263 0.126% 99.826% ( 4400, 6600 ] 394 0.039% 99.865% ( 6600, 9900 ] 220 0.022% 99.887% ( 9900, 14000 ] 424 0.042% 99.930% ( 14000, 22000 ] 487 0.049% 99.978% ( 22000, 33000 ] 179 0.018% 99.996% ( 33000, 50000 ] 31 0.003% 99.999% ( 50000, 75000 ] 8 0.001% 100.000% STATISTICS: rocksdb.block.cache.miss COUNT : 0 rocksdb.block.cache.hit COUNT : 0 rocksdb.block.cache.add COUNT : 0 rocksdb.block.cache.add.failures COUNT : 0 rocksdb.block.cache.index.miss COUNT : 0 rocksdb.block.cache.index.hit COUNT : 0 rocksdb.block.cache.index.add COUNT : 0 rocksdb.block.cache.index.bytes.insert COUNT : 0 rocksdb.block.cache.filter.miss COUNT : 0 rocksdb.block.cache.filter.hit COUNT : 0 rocksdb.block.cache.filter.add COUNT : 0 rocksdb.block.cache.filter.bytes.insert COUNT : 0 rocksdb.block.cache.data.miss COUNT : 0 rocksdb.block.cache.data.hit COUNT : 0 rocksdb.block.cache.data.add COUNT : 0 rocksdb.block.cache.data.bytes.insert COUNT : 0 rocksdb.block.cache.bytes.read COUNT : 0 rocksdb.block.cache.bytes.write COUNT : 0 rocksdb.bloom.filter.useful COUNT : 13840869 rocksdb.bloom.filter.full.positive COUNT : 1135438 rocksdb.bloom.filter.full.true.positive COUNT : 1000589 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 : 407 rocksdb.memtable.miss COUNT : 1000589 rocksdb.l0.hit COUNT : 38029 rocksdb.l1.hit COUNT : 16476 rocksdb.l2andup.hit COUNT : 946084 rocksdb.compaction.key.drop.new COUNT : 159540 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 : 4007653 rocksdb.number.keys.read COUNT : 1000996 rocksdb.number.keys.updated COUNT : 0 rocksdb.bytes.written COUNT : 4135897896 rocksdb.bytes.read COUNT : 1000996000 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 : 1569 rocksdb.no.file.errors COUNT : 0 rocksdb.stall.micros COUNT : 43392354 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 : 19128602196 rocksdb.compact.write.bytes COUNT : 18959770029 rocksdb.flush.write.bytes COUNT : 4095617838 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 : 37 rocksdb.number.superversion_acquires COUNT : 780 rocksdb.number.superversion_releases COUNT : 745 rocksdb.number.superversion_cleanups COUNT : 193 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 : 211 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 : 4062496768 rocksdb.memtable.garbage.bytes.at.flush COUNT : 1499136 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 : 23094988520 rocksdb.non.last.level.read.count COUNT : 5436261 rocksdb.block.checksum.compute.count COUNT : 5777157 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 : 181.005538 P95 : 466.726661 P99 : 1050.045904 P100 : 66452.000000 COUNT : 1000996 SUM : 239085970 rocksdb.db.write.micros P50 : 1.623859 P95 : 5.543682 P99 : 14.962727 P100 : 762540.000000 COUNT : 4007653 SUM : 54546122 rocksdb.compaction.times.micros P50 : 1452777.777778 P95 : 4996666.666667 P99 : 26290000.000000 P100 : 29396734.000000 COUNT : 61 SUM : 132428529 rocksdb.compaction.times.cpu_micros P50 : 958421.052632 P95 : 2850000.000000 P99 : 14656533.000000 P100 : 14656533.000000 COUNT : 61 SUM : 80106643 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 : 761.250000 P95 : 132000.000000 P99 : 203600.000000 P100 : 232992.000000 COUNT : 58 SUM : 877985 rocksdb.compaction.outfile.sync.micros P50 : 42916.666667 P95 : 264300.000000 P99 : 367260.000000 P100 : 468814.000000 COUNT : 198 SUM : 15213992 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 : 195.454545 P95 : 3987.500000 P99 : 7705.500000 P100 : 8796.000000 COUNT : 133 SUM : 120869 rocksdb.table.open.io.micros P50 : 9307.031250 P95 : 19903.139013 P99 : 24370.500000 P100 : 31011.000000 COUNT : 1569 SUM : 14718141 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.960780 P95 : 14.061754 P99 : 192.347906 P100 : 53750.000000 COUNT : 4631462 SUM : 74607655 rocksdb.read.block.get.micros P50 : 142.107787 P95 : 337.715235 P99 : 958.375166 P100 : 60111.000000 COUNT : 1144180 SUM : 198768294 rocksdb.write.raw.block.micros P50 : 0.560469 P95 : 1.687344 P99 : 4.475434 P100 : 79452.000000 COUNT : 5584071 SUM : 16074242 rocksdb.numfiles.in.singlecompaction P50 : 3.016667 P95 : 5.416667 P99 : 25.000000 P100 : 31.000000 COUNT : 75 SUM : 288 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.577513 P95 : 1211.750640 P99 : 2552.231027 P100 : 762358.000000 COUNT : 234706 SUM : 43420628 rocksdb.sst.read.micros P50 : 2.354023 P95 : 168.463420 P99 : 457.970293 P100 : 60107.000000 COUNT : 5436406 SUM : 255247675 rocksdb.num.subcompactions.scheduled P50 : 0.000000 P95 : 0.000000 P99 : 0.000000 P100 : 0.000000 COUNT : 0 SUM : 0 rocksdb.bytes.per.read P50 : 1000.000000 P95 : 1000.000000 P99 : 1000.000000 P100 : 1000.000000 COUNT : 1000996 SUM : 1000996000 rocksdb.bytes.per.write P50 : 1032.000000 P95 : 1032.000000 P99 : 1032.000000 P100 : 1032.000000 COUNT : 4007653 SUM : 4135897896 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 : 220434.782609 P95 : 807800.000000 P99 : 1063034.000000 P100 : 1063034.000000 COUNT : 58 SUM : 17390700 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 : 215 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