Module mz_sql::session::vars::upsert_rocksdb

Tuning for RocksDB used by UPSERT sources that takes effect on restart.

Statics

• UPSERT_ROCKSDB_AUTO_SPILL_THRESHOLD_BYTES
  The upsert in memory state size threshold after which it will spill to disk. The default is 85 MiB = 89128960 bytes
• UPSERT_ROCKSDB_AUTO_SPILL_TO_DISK
  Controls whether automatic spill to disk should be turned on when using DISK.
• UPSERT_ROCKSDB_BATCH_SIZE
• UPSERT_ROCKSDB_BOTTOMMOST_COMPRESSION_TYPE
• UPSERT_ROCKSDB_COMPACTION_STYLE
• UPSERT_ROCKSDB_COMPRESSION_TYPE
• UPSERT_ROCKSDB_LEVEL_COMPACTION_DYNAMIC_LEVEL_BYTES
• UPSERT_ROCKSDB_OPTIMIZE_COMPACTION_MEMTABLE_BUDGET
• UPSERT_ROCKSDB_PARALLELISM
• UPSERT_ROCKSDB_POINT_LOOKUP_BLOCK_CACHE_SIZE_MB
• UPSERT_ROCKSDB_RETRY_DURATION
• UPSERT_ROCKSDB_SHRINK_ALLOCATED_BUFFERS_BY_RATIO
  The number of times by which allocated buffers will be shrinked in upsert rocksdb. If value is 0, then no shrinking will occur.
• UPSERT_ROCKSDB_STATS_LOG_INTERVAL_SECONDS
• UPSERT_ROCKSDB_STATS_PERSIST_INTERVAL_SECONDS
• UPSERT_ROCKSDB_UNIVERSAL_COMPACTION_RATIO
• UPSERT_ROCKSDB_WRITE_BUFFER_MANAGER_ALLOW_STALL
• UPSERT_ROCKSDB_WRITE_BUFFER_MANAGER_CLUSTER_MEMORY_FRACTION
  Only used if upsert_rocksdb_write_buffer_manager_memory_bytes is also set and write buffer manager is enabled
• UPSERT_ROCKSDB_WRITE_BUFFER_MANAGER_MEMORY_BYTES
  upsert_rocksdb_write_buffer_manager_memory_bytes needs to be set for write buffer manager to be used.