Quick onboard
Deployment
Data Modeling
Connecting
Migration
Query
Operations and Maintenance
Common Maintenance
Partition
Backup and Restore
Expansion
Mirroring
Resource Management
Security
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool guide
Data type
Storage Engine
Executor
Stream
DR (Disaster Recovery)
Configuration
Index
Extension
SQL Reference
Domino v2 provides a rich set of GUC parameters to finely control component behavior.
| Parameter | Description |
|---|---|
mx_stream_default_version |
Default version. Set to 2 to create v2 streams by default. |
mx_stream_internal_modify |
Used internally by stream processing. Controls whether data can be written to stream tables. |
mx_stream_debug_snapshot |
Enables printing of debug information for historical snapshots. |
mx_stream_wal_keep_size |
Maximum retention size for Domino v1/v2 XLog. Exceeding this value disables the stream (v1) or decoder (v2). |
mx_stream_enable_segment_set_launch |
Whether to start stream processing only on nodes within the segment_set. |
mx_enable_stream |
Global toggle for Domino v1. |
mx_stream_set_do_not_stream |
Prevents changes generated by REFRESH STREAM from participating in downstream stream computations. |
mx_max_number_streams |
Maximum number of streams allowed in Domino v1. |
mx_stream_worker_launch_timeout |
Wait time before restarting a failed Domino v1 stream processing process. Default is 1 minute. |
mx_stream_gc_period |
Interval for checking and handling leaked stream progress or slots in Domino v1. Default is 5 minutes; set to 0 to disable. |
mx_stream_base_backup_timeout |
Timeout for basebackup to wait for stream processing to catch up to startptr. Basebackup is aborted if this duration is exceeded. |
mx_stream_message_level |
Log level for Domino v1. |
logical_decoding_work_mem |
Controls memory used by logical decoding to cache uncommitted transactions. When exceeded, the largest transaction is spilled until total memory falls below this value. Unit is KB. Default is 65536 (64 MB). |
| Parameter | Description |
|---|---|
mxstream.debug_tuple_decoding |
Enables debug logging for v1 decoding. |
mxstream.enable_sharescan |
Enables sharescan for v1. |
mxstream.debug_plan |
Enables printing of plan explain information when creating a stream in v1. |
mxstream.debug_plan_costs / mxstream.debug_plan_verbose |
Controls what information is included in the plan explain output when creating a stream in v1. |
mxstream.skip_decode |
Prevents current session writes from participating in stream computation. Applies to both v1 and v2. |
mxstream.scan_xlog_size_limit |
Controls how much XLog is decoded per stream computation cycle in v1. |
mxstream.scan_tuples_limit |
Controls how many tuples are scanned per stream computation cycle in v1. |
mxstream.skip_valid_xlog |
Skips CRC checks on irrelevant records during v1 stream decoding. |
| Parameter | Description |
|---|---|
domino.debug / domino.debug2 |
Enables/disables debug logging. |
domino.decode_interval |
Controls decoder interval. Only effective when decode delay is below this value; otherwise, decoding proceeds as fast as possible. |
domino.enabled |
Global toggle for Domino v2. Controls whether the Domino ticker and scheduler processes are started. Default is off in version 6.3.X. Requires restart to take effect. |
domino.max_number_decoders |
Maximum number of decoders for v2. Each database uses one decoder; this limits the number of supported databases. |
domino.max_workers |
Controls the number of Domino v2 workers. Workers are shared across databases that have stream tables. |
domino.max_streams |
Maximum number of streams for Domino v2. Default is 1024. This setting controls shared memory allocation and is not a recommendation to create 1024 streams. |
domino.job_retry_timeout_ms |
Retry interval after a stream fails. Default is 60 seconds. |
domino.scan_limit |
Number of ticks to scan at once. Valid values: -1 (no limit), 1 (one tick). |
domino.scan_interval |
Minimum interval between two stream scans. Only takes effect when stream latency is less than decode_interval + scan_interval. |
domino.ticker_interval_mb / domino.ticker_interval_ms |
Interval for ticker to create ticks, based on time elapsed or XLog growth. |
domino.tlog_keep_size (MB) |
Number of TLogs retained for stream processing. If stream progress lags behind decoding and retained TLogs exceed this value, TLog retention stops and the stream fails with "could not open tlog file ...". |
domino.worker_timeout_ms |
Automatic restart interval for stream processing processes. |
domino.streaming_leaf |
Experimental feature Controls whether output from the last-layer stream is decoded. Default is off. Can be enabled to address performance bottlenecks. Not recommended during stream creation, as enabling it while creating an upstream stream may cause missing data when downstream streams are added. |