db_size
This is the total size threshold the database engine tries to enforce for the .pack files in the database subdirectory. When the total size exceeds this value, the system will force vacuuming to free up space occupied by unused space in pack files. Performance will constantly be degraded when the database is exceeding the maximum because the system will is forced to vacuum all files in order to eliminate vacuumed files in the middle of a sequence of .pack files.
- Note
- This value should be at least
pack_file_size
bytes less than the space allocated for the database storage. The database can continue to grow larger thandb_size
but will constantly be vacuuming in an attempt to see if free space in the database can be found.
- Default Value
- If the
db_size
option is not defined, the default value of21474836480
is used.
- Example
-
db_size=21474836480
- Database Configuration Options
This option key is associated with the RDM_DB handle (or RDM_CPP::Db for C++) and can be set using one of the following functions:
- SQLSetConnectAttr()
- rdm_dbSetOption()
- rdm_dbSetOptions()
- RDM_CPP::Db::SetOption()
- RDM_CPP::Db::SetOptions()
- See also
- vacuuming