2024-11-23 20:29:31 , Up: 1-06:15:17   .rocksdb/LOG

IntProps
num-immutable-mem-table0
num-immutable-mem-table-flushed0
mem-table-flush-pending0
num-running-flushes0
compaction-pending0
num-running-compactions0
background-errors0
cur-size-active-mem-table462.001 MiB
cur-size-all-mem-tables462.001 MiB
size-all-mem-tables462.001 MiB
num-entries-active-mem-table1285492
num-entries-imm-mem-tables0
num-deletes-active-mem-table53770
num-deletes-imm-mem-tables0
estimate-num-keys520429545
estimate-table-readers-mem29.518 GiB
is-file-deletions-enabled1
num-snapshots5
oldest-snapshot-time1732364971
oldest-snapshot-sequence4245312237
num-live-versions1
current-super-version-number26340
estimate-live-data-size23.409 GiB
min-log-number-to-keep279192
min-obsolete-sst-number-to-keep-1
total-sst-files-size29.518 GiB
live-sst-files-size29.518 GiB
base-level1
estimate-pending-compaction-bytes0
actual-delayed-write-rate0
is-write-stopped0
block-cache-capacity4.000 GiB
block-cache-usage88
block-cache-pinned-usage88
rocksdb
cfstats
no
file
histogram
** Compaction Stats [default] ** Run   0 , Wait   0 , MemTable  462.001 MiB **    compact   flush   flushall
Level    Files      Size      RawKV      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      0/0       0.00 KB    0.00 KB    0.0       0.0      0.0       0.0      322.1     322.1       0.0   1.0      0.0   1772.0      186.15            163.56        645    0.289       0      0         0.0         0.0
  L1      0/0       0.00 KB    0.00 KB    0.0     322.4    322.4       0.0      142.1     142.1       0.0   0.4    933.1    411.2      353.82            586.72        646    0.548    926M   234M         0.0         0.0
  L2      0/0       0.00 KB    0.00 KB    0.0     142.1    142.1       0.0      127.9     127.9       0.0   0.9     53.0     47.7     2745.84            949.83      10602    0.259    691M    12K         0.0         0.0
  L3     64/0       2.46 GB    7.42 GB    1.0    1736.0    127.9    1608.1     1622.3      14.1       0.0  12.7     14.3     13.4   124158.16          44745.77      11496   10.800     27G   288M         0.0         0.0
  L4    472/0      15.81 GB   52.19 GB    1.0      31.6     12.4      19.2       28.1       8.9       1.7   2.3     12.4     11.0     2607.93           1135.00       1198    2.177    948M    68M         0.0         0.0
  L5    371/0      10.72 GB   28.74 GB    0.1       8.4      8.3       0.1        7.9       7.8       2.9   1.0     17.0     15.9      508.34            144.61        265    1.918    122M      0         0.0         0.0
  L6     21/0     545.65 MB    1.43 GB    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
 Sum    928/0      29.52 GB   89.78 GB    0.0    2240.6    613.1    1627.5     2250.4     622.9       4.6   7.0     17.6     17.7   130560.24          47725.50      24852    5.254     30G   591M         0.0         0.0
 Int      0/0       0.00 KB    0.00 KB    0.0    2240.6    613.1    1627.5     2250.4     622.9       4.6   7.0     17.6     17.7   130560.24          47725.50      24852    5.254     30G   591M         0.0         0.0

** Compaction Stats [default] **
Priority Files      Size      RawKV      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.00 KB    0.0    2240.6    613.1    1627.5     1928.3     300.7       0.0   0.0     17.6     15.1   130374.09          47561.94      24207    5.386     30G   591M         0.0         0.0
High      0/0       0.00 KB    0.00 KB    0.0       0.0      0.0       0.0      322.1     322.1       0.0   0.0      0.0   1772.0      186.15            163.56        645    0.289       0      0         0.0         0.0

Blob file count: 0, total size: 0.0 GB, garbage size: 0.0 GB, space amp: 0.0
                                                  noint=0  noint=0&sst=1  noint=0&sst=2  noint=0&nozero=1  noint=0&nozero=1&sst=1  noint=0&nozero=1&sst=2
Uptime(secs): 108916.8 total, 108916.8 interval   noint=1  noint=1&sst=1  noint=1&sst=2  noint=1&nozero=1  noint=1&nozero=1&sst=1  noint=1&nozero=1&sst=2
Flush(GB): cumulative 322.125, interval 322.125
AddFile(GB): cumulative 0.000, interval 0.000
AddFile(Total Files): cumulative 0, interval 0
AddFile(L0 Files): cumulative 0, interval 0
AddFile(Keys): cumulative 0, interval 0
Cumulative compaction:    2.197647 TB write,   21.16 MB/s write,    2.188124 TB read,   21.07 MB/s read, 130560.2 seconds
Interval   compaction: 2250.390698 GB write,   21.16 MB/s write, 2240.638548 GB read,   21.07 MB/s read, 130560.2 seconds
Write Stall (count): cf-l0-file-count-limit-with-ongoing-compaction: delays 0, stops 0 | l0-file-count-limit: delays 0, stops 0 | memtable-limit: delays 0, stops 0 | pending-compaction-bytes: delays 0, stops 0 | total: delays 0, stops 0
Block cache LRUCache@0x423b7800#1630268 capacity: 4.00 GB seed: 1080093140 usage: 0.09 KB table_size: 1024 occupancy: 1 collections: 7261 last_copies: 1 last_secs: 4.8e-05 secs_since: 5
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
rocksdb
dbstats
** DB Stats **
Uptime(secs): 108916.8 total, 598.1 interval
Cumulative writes: 90M writes, 971M keys, 90M commit groups, 1.0 writes per commit group, ingest: 615.75 GB, 5.79 MB/s
Cumulative WAL: 90M writes, 0 syncs, 90187657.00 writes per sync, written: 310.74 GB, 2.92 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 436K writes, 4674K keys, 436K commit groups, 1.0 writes per commit group, ingest: 3044.48 MB, 5.09 MB/s
Interval WAL: 436K writes, 0 syncs, 436894.00 writes per sync, written: 1.50 GB, 2.57 MB/s
Interval stall: 00:00:0.000 H:M:S, 0.0 percent
Write Stall (count): write-buffer-manager-limit-stops: delays 0
rocksdb
sstables

all levels summary: version# 26343, file count = 928, total size = 29.518 GiB, avg size = 0.032 GiB      per_level=0   per_level=1   per_level=2

Name♻FileSize(GiB)EntriesBZipSize(GiB)RawSize(GiB)ZipRatio(Zip/Raw)AvgKeyAvgValueZip
Algo		Smallest
SeqNum		Largest
SeqNum		Co
Pr		Smallest KeyLargest KeyFileTimeAvg File
Zip Size		Avg File
Raw Size
ZipRawAllDMRKeyValueK/KTVKeyValueK/KTVKeyValueKTVZipRawZipRawUserKeySeqTUserKeySeqT
L36402.4585287.4175094585124089278100640.2298672.1675379.6%1.1557716.26173815.6%19.9%34.6%32.3%5.427.150.8146.6FlatZip042439638340471:80000001800000018000000440856879741480:8000012A8000000A0180000BB88003A566423700885312024-11-23 14:15:5736.022 MiB118.680 MiB
L4472015.81078052.1940602382319691067512004720.74749014.5993024.9%5.94540446.24865611.4%12.6%31.6%29.4%3.426.865.8208.4FlatZip=55
TooZip=417		042439638160469:8000001932737006471480:8000012A8000000A0180000BB88000BF51405390569212024-11-22 13:03:4732.604 MiB113.235 MiB
L5371010.71586928.7415082120889700003710.31646910.1935483.0%5.19828123.54322818.1%6.1%43.3%36.6%1.626.351.6119.2TooZip000468:1DB91EB51E331C47091DB91C8F1C7A1C7A09020B1D321C8F00000601475:800000F080000008800100E380000002012024-11-22 13:01:4029.009 MiB79.330 MiB
L62100.5328651.42610027000000000210.3015610.23120056.6%1.1995810.22651984.1%25.1%102.1%37.4%12.047.79.29.0TooZip000478:8000000180000001011C471C601D771CAA091C471C601D771CAA091C471C601D771CAA08011C471EFF1E0C1EFF091CAA1E711CAA1D18091C461E330000000004800000DF01480:8000012C8000000A0180000BB8800004BB012024-11-22 13:26:2925.978 MiB69.539 MiB
sum928029.51804289.7791785231721791960293009281.59538627.1915865.5%13.49903876.28014015.0%11.8%35.6%32.1%3.327.755.8156.6FlatZip=119
TooZip=809		042439638340468:1DB91EB51E331C47091DB91C8F1C7A1C7A09020B1D321C8F00000601480:8000012C8000000A0180000BB8800004BB012024-11-22 13:01:4031.253 MiB99.067 MiB

url param per_level is 1 but there is no any compacting sst