Parameter | Description |
---|---|
barrier_interval_ms | The time interval of the periodic barriers. Since v2.5.0, this setting can also be configured per-database for finer control over latency and resource usage. See CREATE DATABASE for details. |
checkpoint_frequency | Specify the number of barriers for which a checkpoint will be created. The value must be a positive integer. Since v2.5.0, this setting can also be configured per-database to better accommodate diverse workloads. See CREATE DATABASE for details. |
sstable_size_mb | The target size of SSTable. |
parallel_compact_size_mb | This parameter, together with max_sub_compaction , controls the concurrency of individual tasks.
parallel_compact_size_mb , and the total number of sub-tasks cannot exceed max_sub_compaction . |
block_size_kb | The size of each block in bytes in SSTable. |
bloom_false_positive | False positive rate of bloom filter in SSTable. |
state_store | The state store URL. |
data_directory | The remote directory for storing data and metadata objects. |
backup_storage_url | The URL of the remote storage for backups. |
backup_storage_directory | The directory of the remote storage for backups. |
telemetry_enabled | Whether to enable telemetry or not. For more information, see Telemetry. |
max_concurrent_creating_streaming_jobs | The maximum number of streaming jobs that can be created concurrently. That is, the maximum of materialized views, indexes, tables, sinks, or sources that can be created concurrently. |
pause_on_next_bootstrap | This parameter is used for debugging and maintenance purposes. Setting it to true will pause all data sources, such as connectors and DMLs, when the cluster restarts. This parameter will then be reset to its default value (false). To resume data ingestion, simply run risectl meta resume or restart the cluster again. |
enable_tracing | Whether to enable distributed tracing. This parameter is used to toggle the opentelemetry tracing during runtime. Its default value is false. |
time_travel_retention_ms | The data retention period for time travel. Defaults to 0, which disables time travel. To enable this feature, set it to a a non-zero value. |
per_database_isolation | Enables per-database failure isolation, so that failures such as streaming job errors or worker crashes in one database do not affect other databases. Defaults to true . For more details of database isolation, see Workload isolation and interaction. |
SHOW PARAMETERS
command to view the system parameters, along with their current values.
The Mutable
column indicates whether the parameter can be altered using the ALTER SYSTEM SET command after the system is running. t
means it can be altered using the ALTER SYSTEM SET
command while f
means it cannot be altered using the command.
ALTER SYSTEM SET
command in psql
.
The full syntax of the ALTER SYSTEM SET
statement is:
state_store
and data_directory
need to be initialized before starting a cluster.
To configure parameter settings in the CLI of the meta node, navigate to the directory where RisingWave is installed and run the following command:
data_directory
:
meta-node --data_directory "hummock_001"