Hi all,
I am running a H2 2.1.212 and I wonder why the automatic compact feature does not shrink the database size.
My application is continuously collecting data (around 100 inserts per second). Most of the data is removed once a day. The data is kept in 4300 tables.
The database file size is around 5 GB. When running a manual SHUTDOWN COMPACT it is compacted to 40 MB.
I expected that the automatic compact algorithm of the MV_STORE is able to keep the database smaller than it is. Are there any known circumstances why the compact algorithm does not run or does not give good results?
I already tried to use the latest git code but the results are the same.
Here are some infos from the information_schema.settings table with the relevant parameters:
AUTO_COMPACT_FILL_RATE 90
info.FILL_RATE 19
info.CHUNKS_FILL_RATE 27
info.CHUNKS_FILL_RATE_RW 27
info.FILE_SIZE 4916121600
info.CHUNK_COUNT
490
info.PAGE_COUNT 1594967
info.PAGE_COUNT_LIVE
440730
info.PAGE_SIZE 4096
info.CACHE_MAX_SIZE
16
info.CACHE_SIZE
15
info.CACHE_HIT_RATIO
85
info.TOC_CACHE_HIT_RATIO
99
info.LEAF_RATIO
44
Thanks!
Ulrich