2024-11-23 19:47:32 , Up: 1-05:33:18   .rocksdb/LOG

IntProps
num-immutable-mem-table-flushed1
compaction-pending1
num-running-compactions4
cur-size-active-mem-table22.251 MiB
cur-size-all-mem-tables22.251 MiB
size-all-mem-tables534.000 MiB
num-entries-active-mem-table58378
num-deletes-active-mem-table2300
estimate-num-keys514000484
estimate-table-readers-mem29.500 GiB
is-file-deletions-enabled1
num-snapshots4
oldest-snapshot-time1732362452
oldest-snapshot-sequence4225299309
num-live-versions5
current-super-version-number25840
estimate-live-data-size23.257 GiB
min-log-number-to-keep277743
min-obsolete-sst-number-to-keep277878
total-sst-files-size29.688 GiB
live-sst-files-size29.518 GiB
base-level1
block-cache-capacity4.000 GiB
block-cache-usage88
block-cache-pinned-usage88
rocksdb
cfstats
no
file
histogram
** Compaction Stats [default] ** Run   4 , Wait   1 , MemTable   22.251 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      315.8     315.8       0.0   1.0      0.0   1778.1      181.90            159.78        632    0.288       0      0         0.0         0.0
  L1      3/0      19.95 MB   19.67 MB    0.0     316.1    316.1       0.0      139.5     139.5       0.0   0.4    933.4    411.8      346.84            575.43        633    0.548    908M   230M         0.0         0.0
  L2      9/4     161.51 MB  178.47 MB    0.1     139.5    139.5       0.0      125.5     125.5       0.0   0.9     53.1     47.8     2689.79            931.74      10398    0.259    678M    12K         0.0         0.0
  L3     66/28      2.44 GB    7.40 GB    0.5    1700.1    125.4    1574.7     1588.6      13.9       0.0  12.7     14.3     13.4   121676.23          43842.69      11286   10.781     27G   282M         0.0         0.0
  L4    468/0      15.81 GB   52.18 GB    1.0      30.7     12.2      18.5       27.2       8.7       1.7   2.2     12.5     11.1     2515.64           1094.20       1168    2.154    917M    66M         0.0         0.0
  L5    365/0      10.56 GB   28.07 GB    0.1       8.4      8.3       0.1        7.9       7.8       2.8   1.0     17.0     15.9      507.52            144.41        263    1.930    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    932/32     29.52 GB   89.27 GB    0.0    2194.8    601.4    1593.4     2204.6     611.2       4.5   7.0     17.6     17.6   127917.92          46748.25      24380    5.247     29G   579M         0.0         0.0
 Int      0/0       0.00 KB    0.00 KB    0.0    2194.8    601.4    1593.4     2204.6     611.2       4.5   7.0     17.6     17.6   127917.92          46748.25      24380    5.247     29G   579M         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    2194.8    601.4    1593.4     1888.7     295.3       0.0   0.0     17.6     15.1   127736.02          46588.47      23748    5.379     29G   579M         0.0         0.0
High      0/0       0.00 KB    0.00 KB    0.0       0.0      0.0       0.0      315.8     315.8       0.0   0.0      0.0   1778.1      181.90            159.78        632    0.288       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): 106398.4 total, 106398.4 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 315.846, interval 315.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:    2.152907 TB write,   21.22 MB/s write,    2.143383 TB read,   21.12 MB/s read, 127917.9 seconds
Interval   compaction: 2204.576936 GB write,   21.22 MB/s write, 2194.824371 GB read,   21.12 MB/s read, 127917.9 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: 7093 last_copies: 1 last_secs: 5.5e-05 secs_since: 6
Block cache entry stats(count,size,portion): Misc(1,0.00 KB,0%)
rocksdb
dbstats
** DB Stats **
Uptime(secs): 106398.4 total, 190.1 interval
Cumulative writes: 88M writes, 951M keys, 88M commit groups, 1.0 writes per commit group, ingest: 603.01 GB, 5.80 MB/s
Cumulative WAL: 88M writes, 0 syncs, 88312911.00 writes per sync, written: 304.31 GB, 2.93 MB/s
Cumulative stall: 00:00:0.000 H:M:S, 0.0 percent
Interval writes: 144K writes, 1542K keys, 144K commit groups, 1.0 writes per commit group, ingest: 1006.53 MB, 5.29 MB/s
Interval WAL: 144K writes, 0 syncs, 144795.00 writes per sync, written: 0.50 GB, 2.67 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# 25842, file count = 932, total size = 29.518 GiB, avg size = 0.032 GiB      per_level=0   per_level=1   per_level=2

NameFileSize(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
L1300.0194850.0192083045800030.0009550.0185274.9%0.0006810.0185273.5%140.3%100.0%101.4%33.724.0653.1653.1SngFast422374690742252379690469:8000008942252376711471:8000012C8000000A80000A6E422478727412024-11-23 19:47:256.573 MiB6.556 MiB
L2940.1577250.174284863952292900090.0037150.1539922.4%0.0214740.15281012.3%17.3%100.8%90.5%4.626.7191.4189.9FlatZip422374691142252380030474:80000089800000018001CB5A42237477761480:8000012A8000000A0180000BB88003746B422413734812024-11-23 19:47:2617.702 MiB19.830 MiB
L366282.4361617.3952174513013984200900660.2245652.1514099.5%1.1400256.25519215.4%19.7%34.4%32.1%5.327.151.2148.8FlatZip=64
TooZip=2
042252379730471:80000001800000018000000440856879741480:8000012A8000000A0180000BB880036E9D422262126112024-11-23 14:15:5734.654 MiB114.738 MiB
L4468015.81102852.1791622378224151066612004680.74588214.6012694.9%5.93501846.24414411.4%12.6%31.6%29.4%3.426.865.9208.8FlatZip=55
TooZip=413
042237468770469:8000001932737006471480:8000012A8000000A0180000BB88000BF51405390569212024-11-22 13:03:4732.886 MiB114.170 MiB
L5365010.56119128.0748522069755640003650.30801010.0527123.0%5.06777923.00707318.1%6.1%43.7%36.9%1.626.352.2119.4TooZip000468:1DB91EB51E331C47091DB91C8F1C7A1C7A09020B1D321C8F00000601475:800000F080000007800049B680000007012024-11-22 13:01:4029.067 MiB78.763 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
sum9323229.51845589.2688225178225281937911009321.58468827.2091105.5%13.36455775.90426515.0%11.9%35.8%32.3%3.327.756.4157.4FlatZip=128
SngFast=3
TooZip=801
042252380030468:1DB91EB51E331C47091DB91C8F1C7A1C7A09020B1D321C8F00000601480:8000012C8000000A0180000BB8800004BB012024-11-22 13:01:4031.129 MiB98.081 MiB

level = 2, file count = 9, total zip = 0.158 GiB, raw = 0.174 GiB, over prev level: zip = 8.094702, raw = 9.073527

NameFileSize(GiB)EntriesBZipSize(GiB)RawSize(GiB)ZipRatio(Zip/Raw)AvgKeyAvgValueZip
Algo
Smallest
SeqNum
Largest
SeqNum
Co
Pr
Smallest KeyLargest KeyFileTime
ZipRawAllDMRKeyValueK/KTVKeyValueK/KTVKeyValueKTVZipRawZipRawUserKeySeqTUserKeySeqT
277874💡0.0014480.0025306339700010.0002560.00119117.7%0.0014170.00111356.0%18.1%107.0%57.2%4.324.020.218.8FlatZip422374691142252379706474:80000089800000018001CB5A42237477761474:8000012A8000000A800378BA422523635012024-11-23 19:47:26
277876💡0.0129360.01525211375100010.0004810.0124533.7%0.0029660.01228619.4%16.2%101.4%84.8%4.528.0117.5116.0FlatZip4223746929422523788111475:80000089800000018001CB5A8000000142237477791475:80000089800000078001CCD98000000A422440101512024-11-23 19:47:26
277877💡0.0304570.0308203191400010.0001370.0303190.4%0.0005940.0302261.9%23.0%100.3%98.8%4.620.01020.11016.9FlatZip422374691642252379526477:8000000180000C8542243451431477:80000128800005A0422424754612024-11-23 19:47:26
277885💡0.0003890.00226792687292900010.0003880.000000100.0%0.0022670.000000100.0%17.1%inf%17.1%4.526.30.00.0FlatZip422374691242252379716479:8000008980000001008001CB5A42237477777479:8000012A8000000A018000000A80031CFE422522064912024-11-23 19:47:28
sum40.1577250.174284863952292900090.0037150.1539922.4%0.0214740.15281012.3%17.3%100.8%90.5%4.626.7191.4189.9FlatZip422374691142252380030474:80000089800000018001CB5A42237477761480:8000012A8000000A0180000BB88003746B422413734812024-11-23 19:47:26

level = 3, file count = 66, total zip = 2.436 GiB, raw = 7.395 GiB, over prev level: zip = 15.445669, raw = 42.432076

NameFileSize(GiB)EntriesBZipSize(GiB)RawSize(GiB)ZipRatio(Zip/Raw)AvgKeyAvgValueZip
Algo
Smallest
SeqNum
Largest
SeqNum
Co
Pr
Smallest KeyLargest KeyFileTime
ZipRawAllDMRKeyValueK/KTVKeyValueK/KTVKeyValueKTVZipRawZipRawUserKeySeqTUserKeySeqT
2777820.0716570.125000307443200010.0151870.05644621.2%0.0687190.05628155.0%22.1%100.3%57.3%5.324.019.719.7FlatZip378313544242237466687474:8000007C800000018005172839512044861474:800000F08000000680064943398184650012024-11-23 19:44:27
2777830.0062670.01106027638800010.0013670.00489721.8%0.0061780.00488255.9%22.1%100.3%56.6%5.324.019.019.0FlatZip378313545342237468786474:800000F0800000068006494439818482621474:8000012A8000000A800372D5422374512512024-11-23 19:44:30
2778350.0360290.12500092708600010.0045560.03046113.0%0.0241760.10082419.3%18.8%30.2%28.0%5.328.035.3116.8FlatZip4136224572422374657311475:8000008980000001800194E68000000141996796721475:80000089800000038001D15180000007420486100612024-11-23 19:45:32
2778360.0353620.12500092998100010.0045710.02978113.3%0.0242510.10074919.4%18.8%29.6%27.5%5.328.034.4116.3FlatZip4155809461422374628911475:80000089800000038001D1518000000842048610071475:8000008980000006800137AF80000004415735978812024-11-23 19:45:35
2778370.0353750.12500092677100010.0044470.02991612.9%0.0241670.10083319.3%18.4%29.7%27.5%5.228.034.7116.8FlatZip4157359789422374648011475:8000008980000006800137AF8000000541573597891475:80000089800000088001B1518000000B421225523712024-11-23 19:45:38
2777930.0395070.12500112943100010.0006690.0375541.7%0.0024110.1225901.9%27.7%30.6%30.6%5.520.0311.51017.0FlatZip323787727742237442617477:800000018000002335984331521477:8000001780004EC7375481654512024-11-23 19:44:29
2777940.0397720.12500112943400010.0006610.0378261.7%0.0024110.1225901.9%27.4%30.9%30.8%5.520.0313.81017.0FlatZip323786819542237262357477:8000001780004ECC36263367011477:8000002180001F07374798987512024-11-23 19:44:30
2777950.0395040.12500112943300010.0006690.0375511.7%0.0024110.1225901.9%27.7%30.6%30.6%5.520.0311.51017.0FlatZip323787465442237300257477:8000002180001F1138354920191477:8000003780005BEE361575100612024-11-23 19:44:32
2777960.0397680.12500012943500010.0006610.0378221.7%0.0024110.1225901.9%27.4%30.9%30.8%5.520.0313.81017.0FlatZip323786859642237291267477:8000003780005C0132988877481477:800000418000369F420501723412024-11-23 19:44:34
2777970.0395010.12500012943300010.0006690.0375471.7%0.0024110.1225891.9%27.7%30.6%30.6%5.520.0311.51017.0FlatZip323786992342237448297477:80000041800036A341961690511477:80000057800072E7343521008812024-11-23 19:44:36
2777980.0395080.12500012942900010.0006690.0375541.7%0.0024110.1225891.9%27.7%30.6%30.6%5.520.0311.51017.0FlatZip323787217542237372567477:800000578000730735980877351477:8000006D8000D384422149805712024-11-23 19:44:38
2777990.0397600.12500012942900010.0006640.0378111.7%0.0024110.1225901.9%27.5%30.8%30.8%5.520.0313.71017.0FlatZip323788513342237241457477:8000006D8000D3FF33212978221477:8000007C8000B04E400474046612024-11-23 19:44:40
2778000.0398790.12500012942800010.0006610.0379331.7%0.0024110.1225891.9%27.4%30.9%30.9%5.520.0314.71017.0FlatZip323788098742236935107477:8000007C8000B04F38827224711477:8000008580008E1D327296287412024-11-23 19:44:42
2778010.0399170.12500112943000010.0006580.0379741.7%0.0024110.1225901.9%27.3%31.0%30.9%5.520.0315.01017.0FlatZip323786829042237466817477:8000008580008E1E32643008881477:8000008980010352420986961712024-11-23 19:44:44
2778020.0396680.12500112943300010.0006650.0377171.7%0.0024110.1225901.9%27.6%30.8%30.7%5.520.0312.91017.0FlatZip323787412742237466857477:800000898001035342101052081477:8000009A80012683347431457812024-11-23 19:44:45
2778030.0395050.12500012942900010.0006690.0375521.7%0.0024110.1225891.9%27.7%30.6%30.6%5.520.0311.51017.0FlatZip323787387742237293477477:8000009A8001268535026328151477:800000B080016987330771883312024-11-23 19:44:47
2778040.0395110.12500112942900010.0006690.0375571.7%0.0024110.1225901.9%27.7%30.6%30.6%5.520.0311.61017.0FlatZip323787208242237411197477:800000B0800169B035555724731477:800000C780003E24396217504912024-11-23 19:44:49
2778050.0399600.12500012943000010.0006590.0380161.7%0.0024110.1225891.9%27.3%31.0%30.9%5.520.0315.41017.0FlatZip323788839842237302617477:800000C780003E3132675067721477:800000CD80017B78397718332812024-11-23 19:44:51
2778060.0395340.12500012942400010.0006680.0375801.7%0.0024110.1225891.9%27.7%30.7%30.6%5.520.0311.81017.0FlatZip323787136542237397367477:800000CD80017B7940002006201477:800000E380010D83385731780412024-11-23 19:44:53
2778070.0392000.12500112943000010.0004220.0374931.1%0.0024110.1225901.9%17.5%30.6%30.3%3.520.0311.01017.0FlatZip042237450957477:800000E380010DA540787456581477:800000ED80003568012024-11-23 19:44:54
2778090.0393920.12500012942700010.0005030.0376031.3%0.0024110.1225901.9%20.9%30.7%30.5%4.220.0312.01017.0FlatZip042237277607477:800000F080014FE540090865811477:800000FC8000CE2D344404489612024-11-23 19:44:58
2778100.0399520.12500112942500010.0006500.0380161.7%0.0024110.1225901.9%27.0%31.0%30.9%5.420.0315.41017.0FlatZip042237345896477:800000FC8000CE3334360872511477:800001028000AEE2355927910012024-11-23 19:45:00
2778110.0392980.12500012942900010.0004910.0375221.3%0.0024110.1225901.9%20.4%30.6%30.4%4.120.0311.31017.0FlatZip042237356497477:800001028000AEE333235267791477:80000110800019E8012024-11-23 19:45:02
2778120.0391960.12500012942800010.0003450.0375660.9%0.0024110.1225901.9%14.3%30.6%30.3%2.920.0311.71017.0FlatZip042236704217477:80000110800019E901477:8000011680006D7F375533794912024-11-23 19:45:04
2778130.0391290.12500012942800010.0003600.0374841.0%0.0024110.1225891.9%14.9%30.6%30.3%3.020.0311.01017.0FlatZip042237450077477:8000011680006D8439188094141477:8000011D80009461422096222712024-11-23 19:45:05
2778140.0390950.12500012943100010.0003510.0374590.9%0.0024110.1225901.9%14.5%30.6%30.2%2.920.0310.81017.0FlatZip042237449567477:8000011D8000946341446075141477:8000012480002EF7394997032612024-11-23 19:45:07
2778150.0399950.12500012943200010.0006610.0380491.7%0.0024110.1225891.9%27.4%31.0%31.0%5.520.0315.61017.0FlatZip042237468867477:8000012480002EFB37212323081477:8000012A8000B385422323473412024-11-23 19:45:09
2777800.0245010.12500048071084005640010.0245000.000000100.0%0.1250000.000000100.0%19.6%inf%19.6%5.527.90.00.0FlatZip380566986142237468796479:8000007C8000000100800576E240005191317479:8000012A8000000501800000018001F320414213740912024-11-23 19:44:23
sum282.4361617.3952174513013984200900660.2245652.1514099.5%1.1400256.25519215.4%19.7%34.4%32.1%5.327.151.2148.8FlatZip=64
TooZip=2
042252379730471:80000001800000018000000440856879741480:8000012A8000000A0180000BB880036E9D422262126112024-11-23 14:15:57