> ## Documentation Index
> Fetch the complete documentation index at: https://cockroachlabs.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Cluster Setting Scopes with Cluster Virtualization enabled

export const InternalLink = ({version, path = "", children, ...props}) => {
  let detectedVersion = version || "stable";
  if (typeof window !== 'undefined' && !version) {
    const match = window.location.pathname.match(/\/docs\/([^/]+)/);
    if (match) {
      detectedVersion = match[1];
    }
  }
  const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
  return <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

<Note>
  **This feature is in <InternalLink path="cockroachdb-feature-availability">preview</InternalLink>** and subject to change. To share feedback and/or issues, contact [Support](https://support.cockroachlabs.com).
</Note>

Refer to the <InternalLink path="cluster-virtualization-overview#known-limitations">Cluster Virtualization Overview</InternalLink> for further detail.
When <InternalLink path="cluster-virtualization-overview">cluster virtualization</InternalLink> is enabled, each cluster setting has a scope, which may be a virtual cluster or the system virtual cluster. This page categorizes each public cluster setting by scope. For descriptions and details about each public cluster setting, refer to <InternalLink path="cluster-settings">Cluster Settings</InternalLink>.

* When a cluster setting is scoped to a virtual cluster, it affects only a virtual cluster and not the system virtual cluster. To configure a cluster setting that is scoped to a virtual cluster, you must have the `admin` role on it, and you must connect to it before configuring the setting. The majority of cluster settings are scoped to a virtual cluster and are visible only when connected to it.
* When a cluster setting is scoped to the system virtual cluster, it affects the entire CockroachDB cluster. To configure a cluster setting that is scoped to the system virtual cluster, you must have the `admin` role on the system virtual cluster, and you must connect to the system virtual cluster before configuring the setting. For example, the cluster setting `admission.disk_bandwidth_tokens.elastic.enabled` is scoped to the system virtual cluster.
* When a cluster setting is system-visible, it can be set only from the system virtual cluster but can be queried from any virtual cluster. For example, a virtual cluster can query a system-visible cluster setting's value, such as `storage.max_sync_duration`, to help adapt to the CockroachDB cluster's configuration.

## Cluster settings scoped to a virtual cluster

* `admission.epoch_lifo.enabled`
* `admission.epoch_lifo.epoch_closing_delta_duration`
* `admission.epoch_lifo.epoch_duration`
* `admission.epoch_lifo.queue_delay_threshold_to_switch_to_lifo`
* `admission.sql_kv_response.enabled`
* `admission.sql_sql_response.enabled`
* `bulkio.backup.deprecated_full_backup_with_subdir.enabled`
* `bulkio.backup.file_size`
* `bulkio.backup.read_timeout`
* `bulkio.backup.read_with_priority_after`
* `changefeed.aggregator.flush_jitter`
* `changefeed.backfill.concurrent_scan_requests`
* `changefeed.backfill.scan_request_size`
* `changefeed.batch_reduction_retry.enabled`
* `changefeed.default_range_distribution_strategy`
* `changefeed.event_consumer_worker_queue_size`
* `changefeed.event_consumer_workers`
* `changefeed.fast_gzip.enabled`
* `changefeed.frontier_highwater_lag_checkpoint_threshold`
* `changefeed.memory.per_changefeed_limit`
* `changefeed.min_highwater_advance`
* `changefeed.node_throttle_config`
* `changefeed.protect_timestamp_interval`
* `changefeed.protect_timestamp.max_age`
* `changefeed.schema_feed.read_with_priority_after`
* `changefeed.sink_io_workers`
* `cloudstorage.azure.concurrent_upload_buffers`
* `cloudstorage.http.custom_ca`
* `cloudstorage.timeout`
* `cluster.auto_upgrade.enabled`
* `cluster.preserve_downgrade_option`
* `diagnostics.forced_sql_stat_reset.interval`
* `diagnostics.reporting.enabled`
* `diagnostics.reporting.interval`
* `external.graphite.endpoint`
* `external.graphite.interval`
* `feature.backup.enabled`
* `feature.changefeed.enabled`
* `feature.export.enabled`
* `feature.import.enabled`
* `feature.restore.enabled`
* `feature.schema_change.enabled`
* `feature.stats.enabled`
* `jobs.retention_time`
* `kv.dist_sender.circuit_breaker.cancellation.enabled`
* `kv.dist_sender.circuit_breaker.cancellation.write_grace_period`
* `kv.dist_sender.circuit_breaker.probe.interval`
* `kv.dist_sender.circuit_breaker.probe.threshold`
* `kv.dist_sender.circuit_breaker.probe.timeout`
* `kv.dist_sender.circuit_breakers.mode`
* `kv.rangefeed.client.stream_startup_rate`
* `kv.rangefeed.range_stuck_threshold`
* `kv.transaction.max_intents_bytes`
* `kv.transaction.max_refresh_spans_bytes`
* `kv.transaction.reject_over_max_intents_budget.enabled`
* `kv.transaction.write_pipelining.enabled`
* `kv.transaction.write_pipelining.locking_reads.enabled`
* `kv.transaction.write_pipelining.max_batch_size`
* `kv.transaction.write_pipelining.ranged_writes.enabled`
* `schedules.backup.gc_protection.enabled`
* `security.ocsp.mode`
* `security.ocsp.timeout`
* `server.auth_log.sql_connections.enabled`
* `server.auth_log.sql_sessions.enabled`
* `server.authentication_cache.enabled`
* `server.child_metrics.enabled`
* `server.client_cert_expiration_cache.capacity`
* `server.clock.forward_jump_check.enabled`
* `server.clock.persist_upper_bound_interval`
* `server.eventlog.enabled`
* `server.eventlog.ttl`
* `server.host_based_authentication.configuration`
* `server.hot_ranges_request.node.timeout`
* `server.hsts.enabled`
* `server.http.base_path`
* `server.identity_map.configuration`
* `server.log_gc.max_deletions_per_cycle`
* `server.log_gc.period`
* `server.max_connections_per_gateway`
* `server.max_open_transactions_per_gateway`
* `server.oidc_authentication.autologin.enabled`
* `server.oidc_authentication.button_text`
* `server.oidc_authentication.claim_json_key`
* `server.oidc_authentication.client_id`
* `server.oidc_authentication.client_secret`
* `server.oidc_authentication.enabled`
* `server.oidc_authentication.principal_regex`
* `server.oidc_authentication.provider_url`
* `server.oidc_authentication.redirect_url`
* `server.oidc_authentication.scopes`
* `server.redact_sensitive_settings.enabled`
* `server.shutdown.connections.timeout`
* `server.shutdown.initial_wait`
* `server.shutdown.jobs.timeout`
* `server.shutdown.transactions.timeout`
* `server.sql_tcp_keep_alive.count`
* `server.sql_tcp_keep_alive.interval`
* `server.time_until_store_dead`
* `server.user_login.cert_password_method.auto_scram_promotion.enabled`
* `server.user_login.downgrade_scram_stored_passwords_to_bcrypt.enabled`
* `server.user_login.min_password_length`
* `server.user_login.password_encryption`
* `server.user_login.password_hashes.default_cost.crdb_bcrypt`
* `server.user_login.password_hashes.default_cost.scram_sha_256`
* `server.user_login.rehash_scram_stored_passwords_on_cost_change.enabled`
* `server.user_login.timeout`
* `server.user_login.upgrade_bcrypt_stored_passwords_to_scram.enabled`
* `server.web_session.purge.ttl`
* `server.web_session.timeout`
* `sql.auth.change_own_password.enabled`
* `sql.auth.public_schema_create_privilege.enabled`
* `sql.auth.resolve_membership_single_scan.enabled`
* `sql.closed_session_cache.capacity`
* `sql.closed_session_cache.time_to_live`
* `sql.contention.event_store.capacity`
* `sql.contention.event_store.duration_threshold`
* `sql.contention.record_serialization_conflicts.enabled`
* `sql.contention.txn_id_cache.max_size`
* `sql.cross_db_fks.enabled`
* `sql.cross_db_sequence_owners.enabled`
* `sql.cross_db_sequence_references.enabled`
* `sql.cross_db_views.enabled`
* `sql.defaults.cost_scans_with_default_col_size.enabled`
* `sql.defaults.datestyle`
* `sql.defaults.default_hash_sharded_index_bucket_count`
* `sql.defaults.default_int_size`
* `sql.defaults.disallow_full_table_scans.enabled`
* `sql.defaults.distsql`
* `sql.defaults.experimental_alter_column_type.enabled`
* `sql.defaults.experimental_distsql_planning`
* `sql.defaults.experimental_enable_unique_without_index_constraints.enabled`
* `sql.defaults.experimental_implicit_column_partitioning.enabled`
* `sql.defaults.experimental_temporary_tables.enabled`
* `sql.defaults.foreign_key_cascades_limit`
* `sql.defaults.idle_in_session_timeout`
* `sql.defaults.idle_in_transaction_session_timeout`
* `sql.defaults.implicit_select_for_update.enabled`
* `sql.defaults.insert_fast_path.enabled`
* `sql.defaults.intervalstyle`
* `sql.defaults.large_full_scan_rows`
* `sql.defaults.locality_optimized_partitioned_index_scan.enabled`
* `sql.defaults.lock_timeout`
* `sql.defaults.on_update_rehome_row.enabled`
* `sql.defaults.optimizer_use_histograms.enabled`
* `sql.defaults.optimizer_use_multicol_stats.enabled`
* `sql.defaults.override_alter_primary_region_in_super_region.enabled`
* `sql.defaults.override_multi_region_zone_config.enabled`
* `sql.defaults.prefer_lookup_joins_for_fks.enabled`
* `sql.defaults.primary_region`
* `sql.defaults.reorder_joins_limit`
* `sql.defaults.require_explicit_primary_keys.enabled`
* `sql.defaults.results_buffer.size`
* `sql.defaults.serial_normalization`
* `sql.defaults.statement_timeout`
* `sql.defaults.stub_catalog_tables.enabled`
* `sql.defaults.super_regions.enabled`
* `sql.defaults.transaction_rows_read_err`
* `sql.defaults.transaction_rows_read_log`
* `sql.defaults.transaction_rows_written_err`
* `sql.defaults.transaction_rows_written_log`
* `sql.defaults.use_declarative_schema_changer`
* `sql.defaults.vectorize`
* `sql.defaults.zigzag_join.enabled`
* `sql.distsql.temp_storage.workmem`
* `sql.guardrails.max_row_size_err`
* `sql.guardrails.max_row_size_log`
* `sql.hash_sharded_range_pre_split.max`
* `sql.index_recommendation.drop_unused_duration`
* `sql.insights.anomaly_detection.enabled`
* `sql.insights.anomaly_detection.latency_threshold`
* `sql.insights.anomaly_detection.memory_limit`
* `sql.insights.execution_insights_capacity`
* `sql.insights.high_retry_count.threshold`
* `sql.insights.latency_threshold`
* `sql.log.all_statements.enabled`
* `sql.log.slow_query.experimental_full_table_scans.enabled`
* `sql.log.slow_query.internal_queries.enabled`
* `sql.log.slow_query.latency_threshold`
* `sql.log.user_audit`
* `sql.log.user_audit.reduced_config.enabled`
* `sql.metrics.index_usage_stats.enabled`
* `sql.metrics.max_mem_reported_stmt_fingerprints`
* `sql.metrics.max_mem_reported_txn_fingerprints`
* `sql.metrics.max_mem_stmt_fingerprints`
* `sql.metrics.max_mem_txn_fingerprints`
* `sql.metrics.statement_details.dump_to_logs.enabled`
* `sql.metrics.statement_details.enabled`
* `sql.metrics.statement_details.gateway_node.enabled`
* `sql.metrics.statement_details.index_recommendation_collection.enabled`
* `sql.metrics.statement_details.max_mem_reported_idx_recommendations`
* `sql.metrics.statement_details.plan_collection.enabled`
* `sql.metrics.statement_details.plan_collection.period`
* `sql.metrics.statement_details.threshold`
* `sql.metrics.transaction_details.enabled`
* `sql.multiple_modifications_of_table.enabled`
* `sql.multiregion.drop_primary_region.enabled`
* `sql.notices.enabled`
* `sql.optimizer.uniqueness_checks_for_gen_random_uuid.enabled`
* `sql.spatial.experimental_box2d_comparison_operators.enabled`
* `sql.stats.activity.persisted_rows.max`
* `sql.stats.automatic_collection.enabled`
* `sql.stats.automatic_collection.fraction_stale_rows`
* `sql.stats.automatic_collection.min_stale_rows`
* `sql.stats.cleanup.recurrence`
* `sql.stats.flush.enabled`
* `sql.stats.flush.interval`
* `sql.stats.forecasts.enabled`
* `sql.stats.forecasts.max_decrease`
* `sql.stats.forecasts.min_goodness_of_fit`
* `sql.stats.forecasts.min_observations`
* `sql.stats.histogram_buckets.count`
* `sql.stats.histogram_collection.enabled`
* `sql.stats.histogram_samples.count`
* `sql.stats.multi_column_collection.enabled`
* `sql.stats.non_default_columns.min_retention_period`
* `sql.stats.persisted_rows.max`
* `sql.stats.post_events.enabled`
* `sql.stats.response.max`
* `sql.stats.response.show_internal.enabled`
* `sql.stats.system_tables_autostats.enabled`
* `sql.stats.system_tables.enabled`
* `sql.stats.virtual_computed_columns.enabled`
* `sql.telemetry.query_sampling.enabled`
* `sql.telemetry.query_sampling.internal.enabled`
* `sql.telemetry.query_sampling.max_event_frequency`
* `sql.telemetry.query_sampling.mode`
* `sql.telemetry.transaction_sampling.max_event_frequency`
* `sql.telemetry.transaction_sampling.statement_events_per_transaction.max`
* `sql.temp_object_cleaner.cleanup_interval`
* `sql.temp_object_cleaner.wait_interval`
* `sql.trace.stmt.enable_threshold`
* `sql.trace.txn.enable_threshold`
* `sql.ttl.changefeed_replication.disabled`
* `sql.ttl.default_delete_batch_size`
* `sql.ttl.default_delete_rate_limit`
* `sql.ttl.default_select_batch_size`
* `sql.ttl.default_select_rate_limit`
* `sql.ttl.job.enabled`
* `sql.txn_fingerprint_id_cache.capacity`
* `sql.txn.read_committed_isolation.enabled`
* `storage.max_sync_duration.fatal.enabled`
* `storage.value_blocks.enabled`
* `trace.debug_http_endpoint.enabled`
* `trace.opentelemetry.collector`
* `trace.snapshot.rate`
* `trace.span_registry.enabled`
* `trace.zipkin.collector`
* `ui.display_timezone`
* `version`

## Cluster settings scoped to the system virtual cluster

* `admission.disk_bandwidth_tokens.elastic.enabled`
* `admission.kv.enabled`
* `kv.allocator.lease_rebalance_threshold`
* `kv.allocator.load_based_lease_rebalancing.enabled`
* `kv.allocator.load_based_rebalancing`
* `kv.allocator.load_based_rebalancing_interval`
* `kv.allocator.load_based_rebalancing.objective`
* `kv.allocator.qps_rebalance_threshold`
* `kv.allocator.range_rebalance_threshold`
* `kv.allocator.store_cpu_rebalance_threshold`
* `kv.bulk_io_write.max_rate`
* `kv.bulk_sst.max_allowed_overage`
* `kv.lease_transfer_read_summary.global_budget`
* `kv.lease_transfer_read_summary.local_budget`
* `kv.log_range_and_node_events.enabled`
* `kv.range_split.by_load.enabled`
* `kv.range_split.load_cpu_threshold`
* `kv.range_split.load_qps_threshold`
* `kv.replica_circuit_breaker.slow_replication_threshold`
* `kv.replica_stats.addsst_request_size_factor`
* `kv.replication_reports.interval`
* `kv.snapshot_rebalance.max_rate`
* `kv.snapshot_receiver.excise.enabled`
* `kvadmission.store.provisioned_bandwidth`
* `physical_replication.consumer.minimum_flush_interval`
* `server.consistency_check.max_rate`
* `server.rangelog.ttl`
* `server.shutdown.lease_transfer_iteration.timeout`
* `spanconfig.bounds.enabled`
* `spanconfig.range_coalescing.application.enabled`
* `spanconfig.range_coalescing.system.enabled`
* `storage.experimental.eventually_file_only_snapshots.enabled`
* `storage.ingest_split.enabled`
* `storage.wal_failover.unhealthy_op_threshold`
* `timeseries.storage.enabled`

## System-visible cluster settings

* `cluster.organization`
* `diagnostics.active_query_dumps.enabled`
* `diagnostics.memory_monitoring_dumps.enabled`
* `enterprise.license`
* `kv.bulk_sst.target_size`
* `kv.closed_timestamp.follower_reads.enabled`
* `kv.closed_timestamp.lead_for_global_reads_override`
* `kv.closed_timestamp.side_transport_interval`
* `kv.closed_timestamp.target_duration`
* `kv.protectedts.reconciliation.interval`
* `kv.rangefeed.closed_timestamp_refresh_interval`
* `kv.rangefeed.enabled`
* `security.client_cert.subject_required.enabled`
* `sql.schema.telemetry.recurrence`
* `storage.max_sync_duration`
* `storage.sstable.compression_algorithm`
* `timeseries.storage.resolution_10s.ttl`
* `timeseries.storage.resolution_30m.ttl`

## See also

* <InternalLink path="cluster-virtualization-overview">Cluster Virtualization Overview</InternalLink>
* <InternalLink path="cluster-virtualization-setting-scopes">Cluster Metric Scopes with Cluster Virtualization Enabled</InternalLink>
* <InternalLink path="physical-cluster-replication-overview">Physical Cluster Replication</InternalLink>