t00_all_tunables.expected

(name='aa_count_upd', description='Also consider updates towards the count of operations.', type='BOOLEAN', value='OFF', read_only='N')
(name='aa_llmeta_save_freq', description='Persist change counters per table on every Nth iteration (called every CHK_AA_TIME seconds).', type='INTEGER', value='1', read_only='N')
(name='aa_min_percent', description='Percent change above which we kick off analyze.', type='INTEGER', value='20', read_only='N')
(name='aa_min_percent_jitter', description='Additional jitter factor for determining percent change.', type='INTEGER', value='300', read_only='N')
(name='aa_request_mode', description='Mark table in comdb2_auto_analyze_tables instead of performing auto-analyze ourselves', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_during_downgrade_if_scs_dont_stop', description='Abort if scs don't stop within 60 secondsafter starting a downgrade (default OFF)', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_invalid_query_info_key', description='Abort in thread-teardown for invalid query_info_key', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_on_dangling_string_refs', description='Abort-on-exit on dangling stringrefs.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_on_in_use_rqid', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='abort_on_invalid_context', description='abort_on_invalid_context', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_on_replicant_log_write', description='Abort if replicant is writing to logs', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_on_ufid_mismatch', description='Abort in dbreg-open on ufid mismatch. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_on_unfound_txn', description='Abort if we cannot find a txn for a thread.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='abort_ufid_open', description='Abort ufid_open when applying a transaction', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_zero_lsn_memp_put', description='Abort on memp_fput pages with zero headers', type='BOOLEAN', value='OFF', read_only='N')
(name='abort_zero_lsn_writes', description='Abort on writing pages with zero headers', type='BOOLEAN', value='OFF', read_only='N')
(name='accept_on_child_nets', description='listen on separate port for osql net', type='BOOLEAN', value='OFF', read_only='N')
(name='accept_osql_mismatch', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='ack_on_replag_threshold', description='', type='INTEGER', value='0', read_only='N')
(name='ack_trace', description='Every second, produce trace for ack messages. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='add_record_interval', description='Add a record every seconds while there are incoherent_wait replicants.', type='INTEGER', value='1', read_only='N')
(name='additional_deferms', description='Wait-fudge to ensure that a replicant has gone incoherent.', type='INTEGER', value='0', read_only='N')
(name='admin_mode', description='Fail non-admin client requests (Default: False)', type='BOOLEAN', value='OFF', read_only='N')
(name='all_incoherent', description='Master pretends nodes are incoherent.', type='BOOLEAN', value='OFF', read_only='N')
(name='allow_anon_id_for_spmux', description='Allow anonymous identities over connections routed from the secure pmux port', type='INTEGER', value='0', read_only='N')
(name='allow_broken_datetimes', description='Allow broken datetimes', type='BOOLEAN', value='ON', read_only='N')
(name='allow_coordinator', description='Set of dbname/tiers which can act as coordinator for this participant.  (Default: none)', type='STRING', value=NULL, read_only='Y')
(name='allow_key_typechange', description='allow_key_typechange', type='BOOLEAN', value='OFF', read_only='N')
(name='allow_lua_print', description='Enable to allow stored procedures to print trace on DB's stdout. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='allow_mismatched_tag_size', description='Allow variants in padding in static tag struct sizes', type='BOOLEAN', value='OFF', read_only='N')
(name='allow_negative_column_size', description='Allow negative column size in csc2 schema. Added mostly for backwards compatibility. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='allow_offline_upgrades', description='Allow machines marked offline to become master.', type='BOOLEAN', value='OFF', read_only='N')
(name='allow_parallel_rep_on_pagesplit', description='allow parallel rep on pgsplit', type='BOOLEAN', value='ON', read_only='N')
(name='allow_parallel_rep_on_prefix', description='allow parallel rep on bam_prefix', type='BOOLEAN', value='ON', read_only='N')
(name='allow_portmux_route', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='allow_unauthenticated_tag_access', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='allow_user_schema', description='Enable to allow per-user schemas. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='already_aborted_trace', description='Print trace when dd_abort skips an 'already-aborted' locker', type='BOOLEAN', value='OFF', read_only='N')
(name='alternate_verify_fail', description='alternate_verify_fail', type='BOOLEAN', value='OFF', read_only='N')
(name='altersc_delay_usec', description='Extra microseconds to sleep each converted record during alter schema change, if latency on master increases', type='INTEGER', value='0', read_only='N')
(name='altersc_latency', description='Enable tracking master queue latency and delay alter schema changes if too high', type='BOOLEAN', value='ON', read_only='N')
(name='altersc_latency_inc', description='How many msec to add to altersc_queue_latency if altersc_latency_thr still reached', type='INTEGER', value='1000', read_only='N')
(name='altersc_latency_thr', description='Threahoold for alter schema change impact on queue time, as msec/sec increase', type='INTEGER', value='5', read_only='N')
(name='altersc_sampling_sec', description='Sample average of master queue time every this many seconds', type='INTEGER', value='5', read_only='N')
(name='always_reload_analyze', description='Reload analyze data on every query. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='always_request_log_req', description='Always request the next log record on replicant if there is a gap (default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='analyze_comp_threads', description='Number of thread to use when generating samples for computing index statistics. (Default: 10)', type='INTEGER', value='10', read_only='Y')
(name='analyze_comp_threshold', description='Index file size above which we'll do sampling, rather than scan the entire index. (Default: 104857600)', type='INTEGER', value='104857600', read_only='Y')
(name='analyze_empty_tables', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='analyze_tbl_threads', description='Number of threads to go through generated samples when generating index statistics. (Default: 5)', type='INTEGER', value='5', read_only='Y')
(name='apply_queue_memory', description='Current memory usage of apply-queue.  (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='apprec_track_lsn_ranges', description='During recovery track lsn ranges', type='BOOLEAN', value='ON', read_only='N')
(name='appsockpool.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='appsockpool.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='appsockpool.linger', description='Thread linger time (in seconds).', type='INTEGER', value='10', read_only='N')
(name='appsockpool.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='500', read_only='N')
(name='appsockpool.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='appsockpool.maxq', description='Maximum size of queue.', type='INTEGER', value='0', read_only='N')
(name='appsockpool.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='appsockpool.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='0', read_only='N')
(name='appsockpool.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='1', read_only='N')
(name='appsockpool.stacksz', description='Thread stack size.', type='INTEGER', value='***', read_only='N')
(name='appsockslimit', description='Start warning on this many connections to the database.', type='INTEGER', value='500', read_only='N')
(name='archive_on_init', description='Archive files with database extensions in the database directory at the time of init. (Default: ON)', type='BOOLEAN', value='ON', read_only='Y')
(name='asof_thread_drain_limit', description='How many entries at maximum should the BEGIN TRANSACTION AS OF thread drain per run.', type='INTEGER', value='0', read_only='N')
(name='asof_thread_poll_interval_ms', description='For how long should the BEGIN TRANSACTION AS OF thread sleep after draining its work queue.', type='INTEGER', value='500', read_only='N')
(name='authentication_cache_ageout', description='Max age of authentication cache (Default: 900 seconds)', type='INTEGER', value='900', read_only='N')
(name='authorization_cache_ageout', description='Max age of authorization cache (Default: 600 seconds)', type='INTEGER', value='600', read_only='N')
(name='authz_cache', description='Enable per query caching of authorized tables.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='autoanalyze', description='Set to enable auto-analyze.', type='BOOLEAN', value='OFF', read_only='N')
(name='autodeadlockdetect', description='When enabled, deadlock detection will run on every lock conflict. When disabled, it'll run periodically (every DEADLOCKDETECTMS ms).', type='BOOLEAN', value='ON', read_only='N')
(name='bad_lrl_fatal', description='Unrecognised lrl options are fatal errors', type='BOOLEAN', value='OFF', read_only='N')
(name='badwrite_intvl', description='', type='INTEGER', value='0', read_only='Y')
(name='bbenv', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='bdb_handle_reset_delay', description='Force a 5-second delay in bdb_handle_reset between closing and opening', type='BOOLEAN', value='OFF', read_only='N')
(name='bdblock_debug', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='bdboslog', description='', type='INTEGER', value='0', read_only='Y')
(name='berkdb_iomap', description='enable berkdb writing memptrickle status to a mapped file', type='BOOLEAN', value='ON', read_only='N')
(name='blob_mem_mb', description='Blob allocator: Sets the max memory limit to allow for blob values (in MB). (Default: 0)', type='INTEGER', value='-1', read_only='Y')
(name='blobmem_sz_thresh_kb', description='Sets the threshold (in KB) above which blobs are allocated by the blob allocator. (Default: 0)', type='INTEGER', value='-1', read_only='Y')
(name='blobstripe', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='blocking_latches', description='Block on latch rather than deadlock', type='BOOLEAN', value='OFF', read_only='N')
(name='blocking_physrep', description='Physical replicant blocks on select. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='broadcast_check_rmtpol', description='Check rmtpol before sending triggers', type='BOOLEAN', value='ON', read_only='N')
(name='broken_max_rec_sz', description='', type='INTEGER', value='0', read_only='Y')
(name='broken_num_parser', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='btpf_cu_gap', description='How close a cursor should be (pages) to the prefaulted limit before prefaulting again', type='INTEGER', value='5', read_only='N')
(name='btpf_enabled', description='Enables index pages read ahead', type='BOOLEAN', value='OFF', read_only='N')
(name='btpf_min_th', description='Preload pages only if the tree has heigth less than this parameter', type='INTEGER', value='1', read_only='N')
(name='btpf_pg_gap', description='Min. number of records to the page limit before read ahead', type='INTEGER', value='0', read_only='N')
(name='btpf_wndw_inc', description='Increment factor for the number of pages read ahead', type='INTEGER', value='1', read_only='N')
(name='btpf_wndw_max', description='Maximum number of pages read ahead', type='INTEGER', value='1000', read_only='N')
(name='btpf_wndw_min', description='Minimum number of pages read ahead', type='INTEGER', value='100', read_only='N')
(name='buffers_per_context', description='', type='INTEGER', value='255', read_only='Y')
(name='bulk_import_validation_werror', description='Treat bulk import input validation warnings as errors. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='bulk_sql_mode', description='Enable reading data in bulk when performing a scan (alternative is single-stepping a cursor).', type='BOOLEAN', value='ON', read_only='N')
(name='bulk_sql_rowlocks', description='', type='BOOLEAN', value='ON', read_only='N')
(name='bulk_sql_threshold', description='', type='INTEGER', value='2', read_only='N')
(name='cache_flush_interval', description='Save bufferpool once every this many seconds.  (Default: 30)', type='INTEGER', value='30', read_only='N')
(name='cache_lc', description='Collect logs into LSN_COLLECTIONs as they come in', type='BOOLEAN', value='OFF', read_only='N')
(name='cache_lc_check', description='Check LC cache system on every transaction', type='BOOLEAN', value='OFF', read_only='N')
(name='cache_lc_debug', description='Lots of verbose messages out of LC cache system', type='BOOLEAN', value='OFF', read_only='N')
(name='cache_lc_max', description='Keep this many transactions around in LC cache', type='INTEGER', value='16', read_only='N')
(name='cache_lc_memlimit', description='Limit total memory used by LC cache (0 = unlimited).', type='INTEGER', value='2097152', read_only='N')
(name='cache_lc_memlimit_tran', description='Limit per transaction memory used by LC cache', type='INTEGER', value='1048576', read_only='N')
(name='cache_lc_trace_evictions', description='Print a message at the point of eviction', type='BOOLEAN', value='OFF', read_only='N')
(name='cache_lc_trace_misses', description='Print a message on cache miss', type='BOOLEAN', value='OFF', read_only='N')
(name='cached_output_buffer_max_bytes', description='Maximum size in bytes of the output buffer of an appsock thread.  (Default: 8 MiB)', type='INTEGER', value='8388608', read_only='N')
(name='cachekb', description='', type='INTEGER', value='65536', read_only='Y')
(name='cachekbmax', description='', type='INTEGER', value='0', read_only='Y')
(name='cachekbmin', description='', type='INTEGER', value='65536', read_only='Y')
(name='cachesegsize', description='', type='INTEGER', value='1024', read_only='N')
(name='cachesize', description='', type='INTEGER', value='65536', read_only='N')
(name='catchup_on_commit', description='Replicant to INCOHERENT_WAIT rather than INCOHERENT on commit if within CATCHUP_WINDOW.', type='BOOLEAN', value='OFF', read_only='N')
(name='catchup_window', description='Start waiting in waitforseqnum if replicant is within this many bytes of master.', type='INTEGER', value='40000000', read_only='N')
(name='cause_random_blkseq_replays', description='Cause random blkseq replays from replicant', type='BOOLEAN', value='OFF', read_only='N')
(name='cdb2api_policy_override', description='Use this policy override with cdb2api. (Default: none)', type='STRING', value=NULL, read_only='N')
(name='check_applied_lsns', description='Check transaction that its LSNs have been applied', type='BOOLEAN', value='OFF', read_only='N')
(name='check_applied_lsns_debug', description='Lots of verbose trace for debugging applied LSNs.', type='BOOLEAN', value='OFF', read_only='N')
(name='check_applied_lsns_fatal', description='Abort if check_applied_lsns fails', type='BOOLEAN', value='OFF', read_only='N')
(name='check_constraint_feature', description='Enables support for CHECK CONSTRAINTs (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='check_for_hung_checkpoint_thread', description='check_for_hung_checkpoint_thread', type='BOOLEAN', value='OFF', read_only='N')
(name='check_locker_locks', description='Sanity check locks at end of transaction.', type='BOOLEAN', value='OFF', read_only='N')
(name='check_multiple_lockers', description='check_multiple_lockers', type='BOOLEAN', value='ON', read_only='N')
(name='check_page_in_recovery', description='verify that a page has or hasn't gotten corrupt', type='BOOLEAN', value='OFF', read_only='N')
(name='check_sparse_files', description='When allocating a page, check that we aren't creating a sparse file', type='BOOLEAN', value='OFF', read_only='N')
(name='check_sql_source', description='Check sql source', type='BOOLEAN', value='OFF', read_only='N')
(name='check_sqlite_numeric_types', description='Report if our numeric conversion disagrees with SQLite's', type='BOOLEAN', value='ON', read_only='N')
(name='check_wrong_db', description='Return error if connecting to wrong database', type='BOOLEAN', value='ON', read_only='N')
(name='check_zero_lsn_writes', description='Warn on writing pages with zero LSNs', type='BOOLEAN', value='ON', read_only='N')
(name='checkctags', description='', type='ENUM', value='FULL', read_only='Y')
(name='checkpointrand', description='Stagger scheduled checkpoints by this random amount within this many seconds (to prevent multiple databases from checkpointing at the same time).', type='INTEGER', value='30', read_only='N')
(name='checkpointtime', description='Write a checkpoint at this interval.', type='INTEGER', value='60', read_only='N')
(name='checkpointtimepoll', description='Poll a random amount of time lesser than this before writing a checkpoint (attempting to prevent multiple databases from checkpointing at the same exact time).', type='INTEGER', value='100', read_only='N')
(name='checksums', description='Checksum data pages. Turning this off is highly discouraged.', type='BOOLEAN', value='ON', read_only='N')
(name='chk_aa_time', description='Check whether we should start analyze this often.', type='INTEGER', value='180', read_only='N')
(name='chkpoint_alarm_time', description='Warn if checkpoints are taking more than this many seconds. (Default: 60 secs)', type='INTEGER', value='60', read_only='Y')
(name='clean_exit_on_sigterm', description='Attempt to do orderly shutdown on SIGTERM.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='coherency_lease', description='A coherency lease grants a replicant the right to be coherent for this many ms.', type='INTEGER', value='500', read_only='N')
(name='coherency_lease_udp', description='Use udp to issue leases.', type='BOOLEAN', value='ON', read_only='N')
(name='collect_before_locking', description='Collect a transaction from the log before acquiring locks.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='commit_delay_on_copy_ms', description='Set automatic delay-ms for commit-delay on copy.  (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='commit_delay_timeout_seconds', description='Set timeout for commit-delay on copy.  (Default: 10)', type='INTEGER', value='10', read_only='N')
(name='commit_map_debug', description='Produce debug output in commit lsn map', type='BOOLEAN', value='OFF', read_only='N')
(name='commitdelay', description='Add a delay after every commit. This is occasionally useful to throttle the transaction rate.', type='INTEGER', value='0', read_only='N')
(name='commitdelaybehindthresh', description='Call for election again and ask the master to delay commits if we are further than this far behind on startup.', type='INTEGER', value='1048576', read_only='N')
(name='commitdelaymax', description='Introduce a delay after each transaction before returning control to the application. Occasionally useful to allow replicants to catch up on startup with a very busy system.', type='INTEGER', value='0', read_only='N')
(name='compress_page_compact_log', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='comptxn_inherit_locks', description='Compensating transactions inherit pagelocks', type='BOOLEAN', value='ON', read_only='N')
(name='connect_remote_rte', description='Connect to remote nodes using rte. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='consolidate_dbreg_ranges', description='Combine adjacent dbreg ranges for same file', type='BOOLEAN', value='ON', read_only='N')
(name='convert_record_sleep', description='Force a 5-second delay in each convert_record() call', type='BOOLEAN', value='OFF', read_only='N')
(name='convflush', description='', type='INTEGER', value='100', read_only='Y')
(name='coordinator_block_until_durable', description='Coordinator blocks until its commit is durable.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='coordinator_sync_on_commit', description='Coordinator syncs log and waits on commit.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='coordinator_wait_propagate', description='Coordinator waits for participants to propagate.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='core_on_sparse_file', description='Generate a core if we catch berkeley creating a sparse file', type='BOOLEAN', value='OFF', read_only='N')
(name='crc32c', description='Use crc32c (alternate faster implementation of CRC32, different checksums) for page checksums. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='create_dba_user', description='Automatically create 'dba' user if it does not exist already (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='create_default_consumer_atomically', description='Create default consumers atomically (default on)', type='BOOLEAN', value='ON', read_only='N')
(name='create_default_user', description='Automatically create 'default' user when authentication is enabled. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='createdbs', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='cron_idle_secs', description='Set the default sleep time before the cron scheduler checks again the queue for events', type='INTEGER', value='30', read_only='N')
(name='cron_logical_idle_secs', description='Set the default sleep time before the logical cron scheduler checks again the queue for events', type='INTEGER', value='1', read_only='N')
(name='crypto', description='', type='STRING', value=NULL, read_only='Y')
(name='ctrace_dbdir', description='If set, debug trace files will go to the data directory instead of `$COMDB2_ROOT/var/log/cdb2/). (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='ctrace_gzip', description='', type='INTEGER', value='0', read_only='Y')
(name='ctrace_nlogs', description='When rolling trace files, keep this many. The older files will have incrementing number suffixes (.1, .2, etc.). (Default: 7)', type='INTEGER', value='7', read_only='Y')
(name='ctrace_rollat', description='Roll database debug trace file ($COMDB2_ROOT/var/log/cdb2/$dbname.trc.c) at specified size. Set to 0 (default) to never roll.', type='INTEGER', value='0', read_only='Y')
(name='cursor_deadlock', description='cursor_deadlock', type='BOOLEAN', value='OFF', read_only='N')
(name='db_lock_lsn_step', description='Stepup for preallocated db_lock_lsns', type='INTEGER', value='1024', read_only='N')
(name='dbreg_errors_fatal', description='dbreg errors fatal', type='BOOLEAN', value='OFF', read_only='N')
(name='ddl_cascade_drop', description='On DROP, also drop the dependent keys/constraints. (Default: 1)', type='BOOLEAN', value='ON', read_only='Y')
(name='deadlk_priority_bump_on_fstblk', description='', type='INTEGER', value='5', read_only='N')
(name='deadlkoff', description='Disables 'report_deadlock_verbose'', type='BOOLEAN', value='OFF', read_only='N')
(name='deadlkon', description='Same as 'report_deadlock_verbose'', type='BOOLEAN', value='ON', read_only='N')
(name='deadlock_least_writes_ever', description='If AUTODEADLOCKDETECT is off, prefer transaction with least write as deadlock victim.', type='BOOLEAN', value='ON', read_only='N')
(name='deadlock_most_writes', description='If AUTODEADLOCKDETECT is off, prefer transaction with most writes as deadlock victim.', type='BOOLEAN', value='OFF', read_only='N')
(name='deadlock_policy_override', description='', type='INTEGER', value='-1', read_only='Y')
(name='deadlock_rep_retry_max', description='', type='INTEGER', value='2147483647', read_only='Y')
(name='deadlock_writers_with_least_writes', description='If AUTODEADLOCKDETECT is off, prefer transaction with least write as deadlock victim.', type='BOOLEAN', value='ON', read_only='N')
(name='deadlock_youngest_ever', description='If AUTODEADLOCKDETECT is off, prefer youngest transaction as deadlock victim.', type='BOOLEAN', value='OFF', read_only='N')
(name='deadlockdetectms', description='When automatic deadlock detection is disabled, run the deadlock detector this often.', type='INTEGER', value='100', read_only='N')
(name='debug.autoanalyze', description='debug autoanalyze operations', type='BOOLEAN', value='OFF', read_only='N')
(name='debug.osql_random_restart', description='randomly restart osql operations', type='BOOLEAN', value='OFF', read_only='N')
(name='debug.toblock_random_deadlock_trans', description='return deadlock for a fraction of txns', type='BOOLEAN', value='OFF', read_only='N')
(name='debug.toblock_random_verify_error', description='return verify error for a fraction of txns', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_addrem_dbregs', description='Generate debug records for addrems', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_all_prepare_abort', description='Prepare and abort all transactions. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_all_prepare_commit', description='Prepare all transactions. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_all_prepare_leak', description='Prepare and leak all transactions. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_bdb_lock_stack', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_deadlock_replicant_percent', description='Percent of replicant events getting deadlocks', type='INTEGER', value='0', read_only='N')
(name='debug_enospc_chance', description='DEBUG %% random ENOSPC on writes', type='INTEGER', value='0', read_only='N')
(name='debug_lock_get_list_copy_compare', description='Compare the lock-list against original after lock-get-list.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_log_deletion', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_mpalloc_size', description='Alarm on suspicious allocation requests', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_queuedb', description='Enable debug-trace for queuedb.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_random_prepare', description='Prepare randomly. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_sqlthd_failures', description='Force sqlthd failures in unusual places', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_temp_tables', description='Debug temp tables', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_timepart_cron', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='debug_timepart_sqlite', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='debugberkdbcursor', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='debugthreads', description='If set to 'on' enables trace on thread events. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='default_analyze_percent', description='Controls analyze coverage.', type='INTEGER', value='20', read_only='N')
(name='default_function_feature', description='Enables support for SQL function as default value in column definitions (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='delay_after_saveop_done', description='', type='INTEGER', value='0', read_only='N')
(name='delay_after_saveop_usedb', description='', type='INTEGER', value='0', read_only='N')
(name='delay_file_open', description='', type='INTEGER', value='0', read_only='N')
(name='delay_sql_lock_release', description='Delay release locks in cursor move if bdb lock desired but client sends rows back', type='BOOLEAN', value='ON', read_only='N')
(name='delay_writes_in_record_c', description='', type='INTEGER', value='0', read_only='N')
(name='delayed_oldfile_cleanup', description='If set, don't delete unused data/index files in the critical path of schema change; schedule them for deletion later.', type='BOOLEAN', value='ON', read_only='N')
(name='delete_old_file_debug', description='Spew debug info about deleting old files.', type='BOOLEAN', value='OFF', read_only='N')
(name='dflt_livesc', description='Use live schema change by default', type='BOOLEAN', value='ON', read_only='N')
(name='dflt_plansc', description='Use planned schema change by default', type='BOOLEAN', value='ON', read_only='N')
(name='dir', description='Database directory. (Default: $COMDB2_ROOT/var/cdb2/$DBNAME)', type='STRING', value='***', read_only='Y')
(name='direct_count', description='skip cursor layer for simple count stmts', type='BOOLEAN', value='ON', read_only='N')
(name='directio', description='Bypass filesystem cache for page I/O.', type='BOOLEAN', value='***', read_only='N')
(name='disable_blob_check', description='return immediately in check_blob_buffers', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_cache_internal_nodes', description='Disables 'enable_cache_internal_nodes'. B-tree leaf nodes are treated same as internal nodes.', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_caching_stmt_with_fdb', description='Don't cache query plans for statements with foreign table references.', type='BOOLEAN', value='ON', read_only='N')
(name='disable_cnonce_blkseq', description='Don't use cnonce for blkseq (for testing)', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_connection_refresh', description='disable_connection_refresh', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_datetime_ms_us_sc', description='Disables 'enable_datetime_ms_us_sc'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_datetime_promotion', description='Disables 'enable_datetime_promotion'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_datetime_truncation', description='Disables 'enable_datetime_truncation'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_etc_services_lookup', description='When on, disables using /etc/services first to discover database ports', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_exit_on_thread_error', description='don't exit on thread errors', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_inplace_blob_optimization', description='Disables 'enable_inplace_blob_optimization'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_inplace_blobs', description='Disables 'enable_inplace_blobs'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_legacy_queues', description='Disable legacy queues and route messages through comdb2 queue buddy. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='disable_lowpri_snapisol', description='Disables 'enable_lowpri_snapisol'', type='BOOLEAN', value='ON', read_only='Y')
(name='disable_new_si_overhead', description='return immediately in several new snapisol functions', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_osql_blob_optimization', description='Disables 'enable_osql_blob_optimization'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_overflow_page_trace', description='Disables 'enable_overflow_page_trace'', type='BOOLEAN', value='ON', read_only='N')
(name='disable_page_compact', description='Sets 'page_compact_thresh_ff' to 0.', type='BOOLEAN', value='ON', read_only='Y')
(name='disable_page_compact_backward_scan', description='Disables 'enable_page_compact_backward_scan'', type='BOOLEAN', value='ON', read_only='Y')
(name='disable_page_latches', description='Disables 'page_latches'', type='BOOLEAN', value='ON', read_only='Y')
(name='disable_pageorder_recsz_check', description='If set, allow page-order table scans even for larger record sizes where they don't necessarily lead to improvement.', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_pageorder_recsz_chk', description='If set, allow page-order table scans even for larger record sizes where they don't necessarily lead to improvement.', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_partial_indexes', description='Disables 'enable_partial_indexes'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_pgorder_min_nexts', description='Don't disable page order table scans for tables less than this many pages.', type='INTEGER', value='1000', read_only='N')
(name='disable_pgorder_threshold', description='Disable page order table scans if skipping this percentage of pages on a scan.', type='INTEGER', value='60', read_only='N')
(name='disable_prefault_udp', description='Disables 'enable_prefault_udp'', type='BOOLEAN', value='ON', read_only='N')
(name='disable_replicant_latches', description='Disables 'replicant_latches'', type='BOOLEAN', value='ON', read_only='Y')
(name='disable_rowlock_locking', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_rowlocks', description='Follow rowlocks codepath but don't lock', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_rowlocks_logging', description='Don't add logical logging for rowlocks', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_seekscan_optimization', description='Disables SEEKSCAN optimization', type='BOOLEAN', value='ON', read_only='N')
(name='disable_selectv_range_check', description='Disables 'enable_selectv_range_check'', type='BOOLEAN', value='ON', read_only='N')
(name='disable_selectvonly_tran_nop', description='Disable verifying rows selected via SELECTV if there's no other action done by the same transaction.', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_server_sockpool', description='Don't get connections to other databases from sockpool.', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_skip_rows', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_sql_table_replacement', description='Disables SQL table replacement', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_stable_for_ipu', description='For inplace update tables, disable stable find-next cursors', type='BOOLEAN', value='ON', read_only='N')
(name='disable_tagged_api', description='Disables 'enable_tagged_api'', type='BOOLEAN', value='ON', read_only='N')
(name='disable_tagged_api_writes', description='Disables tag api writes', type='BOOLEAN', value='ON', read_only='N')
(name='disable_temptable_pool', description='Sets 'temptable_limit' to 0.', type='BOOLEAN', value='OFF', read_only='Y')
(name='disable_tpsc_tblvers', description='Disable table version checks for time partition schema changes', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_update_shadows', description='stub out update shadows code', type='BOOLEAN', value='OFF', read_only='N')
(name='disable_update_stripe_change', description='Enable to move records between stripes on an update.', type='BOOLEAN', value='ON', read_only='N')
(name='disable_upgrade_ahead', description='Sets 'enable_upgrade_ahead' to 0.', type='BOOLEAN', value='ON', read_only='Y')
(name='disable_writer_penalty_deadlock', description='If set, won't shrink max #writers on deadlock.', type='BOOLEAN', value='OFF', read_only='N')
(name='disallow_portmux_route', description='Disables 'allow_portmux_route'', type='BOOLEAN', value='OFF', read_only='Y')
(name='disttxn_async_messages', description='Send disttxn messages asynchronously.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='disttxn_handle_cache', description='Enable the disttxn handle-cache.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='disttxn_handle_linger_time', description='Time that unused handles persist.  (Default: 60s)', type='INTEGER', value='60', read_only='N')
(name='disttxn_random_retry_poll', description='Poll up to this many ms on dist-retry.  (Default: 500)', type='INTEGER', value='500', read_only='N')
(name='dohast_disable', description='Disable generating AST for queries. This disables distributed mode as well.', type='BOOLEAN', value='OFF', read_only='N')
(name='dohast_verbose', description='Print debug information when creating AST for statements', type='BOOLEAN', value='OFF', read_only='N')
(name='dohsql_disable', description='Disable running queries in distributed mode', type='BOOLEAN', value='OFF', read_only='N')
(name='dohsql_full_queue_poll_msec', description='Poll milliseconds while waiting for coordinator to consume from queue.', type='INTEGER', value='10', read_only='N')
(name='dohsql_joins', description='Enable to support joins in parallel sql execution (default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='dohsql_max_queued_kb_highwm', description='Maximum shard queue size, in KB; shard sqlite will pause once queued bytes limit is reached.', type='INTEGER', value='10000', read_only='N')
(name='dohsql_max_threads', description='Maximum number of parallel threads, otherwise run sequential.', type='INTEGER', value='8', read_only='N')
(name='dohsql_pool_thread_slack', description='Forbid parallel sql coordinators from running on this many sql engines (if 0, defaults to 24).', type='INTEGER', value='24', read_only='N')
(name='dohsql_sc_max_threads', description='If the partition has more shards than this, we run one shard at a time.', type='INTEGER', value='8', read_only='N')
(name='dohsql_verbose', description='Run distributed queries in verbose/debug mode', type='BOOLEAN', value='OFF', read_only='N')
(name='dont_abort_on_in_use_rqid', description='Disable 'abort_on_in_use_rqid'', type='BOOLEAN', value='OFF', read_only='Y')
(name='dont_block_delete_files_thread', description='Ignore files that would block delete-files thread.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='dont_forbid_ulonglong', description='Disables 'forbid_ulonglong'', type='BOOLEAN', value='OFF', read_only='N')
(name='dont_init_queue_with_persistent_sequence', description='Disables 'init_queue_with_persistent_sequence'', type='BOOLEAN', value='ON', read_only='Y')
(name='dont_init_with_inplace_updates', description='Disables 'init_with_inplace_updates'', type='BOOLEAN', value='OFF', read_only='Y')
(name='dont_init_with_instant_schema_change', description='Disables 'instant_schema_change'', type='BOOLEAN', value='OFF', read_only='Y')
(name='dont_init_with_ondisk_header', description='Disables 'init_with_ondisk_header'', type='BOOLEAN', value='OFF', read_only='Y')
(name='dont_init_with_queue_persistent_sequence', description='Disables 'dont_init_with_queue_ondisk_header'', type='BOOLEAN', value='ON', read_only='Y')
(name='dont_optimize_repdb_truncate', description='Disable 'optimize_repdb_truncate'', type='BOOLEAN', value='OFF', read_only='Y')
(name='dont_prefix_foreign_keys', description='Disables 'prefix_foreign_keys'', type='BOOLEAN', value='OFF', read_only='Y')
(name='dont_report_deadlock', description='', type='BOOLEAN', value='ON', read_only='N')
(name='dont_sort_nulls_with_header', description='Disables 'sort_nulls_with_header'', type='BOOLEAN', value='OFF', read_only='Y')
(name='dont_superset_foreign_keys', description='Disables 'superset_foreign_keys'', type='BOOLEAN', value='OFF', read_only='Y')
(name='downgrade_on_seqnum_gen_mismatch', description='', type='BOOLEAN', value='ON', read_only='N')
(name='downgrade_penalty', description='Prevent upgrades for at least this many ms after a downgrade.', type='INTEGER', value='10000', read_only='N')
(name='driver_ulimit', description='Memory limit for comdb2 driver to set (a value of 0 indicates that the comdb2 process was not started by comdb2 driver.', type='INT64', value='0', read_only='Y')
(name='dtastripe', description='', type='INTEGER', value='8', read_only='Y')
(name='dump_after_byteswap', description='dump page after byteswap', type='BOOLEAN', value='OFF', read_only='N')
(name='dump_blkseq', description='Dump all blkseq inserts and replays', type='BOOLEAN', value='OFF', read_only='N')
(name='dump_cache_max_pages', description='Maximum number of pages that will dump into a pagelist.  Setting to 0 means that there is no limit.  (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='dump_history_on_too_many_verify_errors', description='Dump osql history and client info on too many verify errors (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='dump_locks_on_repwait', description='Dump locks on repwaits', type='BOOLEAN', value='OFF', read_only='N')
(name='dump_page_on_byteswap_error', description='fsnap a malformed page from byteswap', type='BOOLEAN', value='OFF', read_only='N')
(name='dump_pool_on_full', description='dump_pool_on_full', type='BOOLEAN', value='ON', read_only='N')
(name='dumpthreadonexit', description='If set to 'on' dump resources held by a thread on exit. (Default: off)', type='BOOLEAN', value='ON', read_only='Y')
(name='dumptxn_at_commit', description='Print the logs for a txn at commit', type='BOOLEAN', value='OFF', read_only='N')
(name='durable_calc_trace', description='Print all lsns for calculate_durable_lsn', type='BOOLEAN', value='OFF', read_only='N')
(name='durable_lsn_request_waitms', description='', type='INTEGER', value='1000', read_only='N')
(name='durable_lsns', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='durable_maxwait_ms', description='Maximum time a replicant will spend waiting for an LSN to become durable.', type='INTEGER', value='4000', read_only='N')
(name='durable_replay_test', description='Enables periodic durable failures in blkseq replay', type='BOOLEAN', value='OFF', read_only='N')
(name='durable_wait_seqnum_test', description='Enables periodic durable failures in wait-for-seqnum', type='BOOLEAN', value='OFF', read_only='N')
(name='dynamic_max_incoherent_percent', description='Percentage of sanctioned nodes dynamic incoherent-slow will allow to be incoherent-slow.  (Default: 40)', type='INTEGER', value='40', read_only='N')
(name='dynamic_max_incoherent_slow', description='Calculate max incoherent-slow nodes dynamically.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='early', description='When set, replicants will ack a transaction as soon as they acquire locks - note that replication must succeed at that point, and reads on that node will either see the records or block. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='early_verify', description='Give early verify errors for updates in SQLite layer', type='BOOLEAN', value='ON', read_only='N')
(name='elect_disable_netsplit_patch', description='When false, on a net split, the side with the master keeps it instead of downgrading. New masters still can't be elected without a quorum.', type='BOOLEAN', value='ON', read_only='N')
(name='elect_highest_committed_gen', description='Bias election by the highest generation in the logfile', type='BOOLEAN', value='ON', read_only='N')
(name='elect_on_mismatched_master', description='', type='BOOLEAN', value='ON', read_only='N')
(name='elect_priority_bias', description='Bias this node's election priority by this amount.  (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='electtimebase', description='Master election timeout base value.', type='INTEGER', value='50', read_only='N')
(name='emptystrnum', description='Empty strings don't convert to numbers', type='BOOLEAN', value='ON', read_only='N')
(name='enable_2pc', description='Enable 2pc fdb transactions.  (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='enable_berkdb_retry_deadlock_bias', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='enable_cache_internal_nodes', description='B-tree internal nodes have a higher cache priority. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_datetime_ms_us_sc', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_datetime_promotion', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_datetime_truncation', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_incoherent_delaymore', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_inplace_blob_optimization', description='Enables inplace blob updates (blobs are updated in place in their b-tree when possible, not deleted/added) Note: This changes the data-format. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_inplace_blobs', description='Do not update the rowid of a blob entry on an update. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_internal_sql_stmt_caching', description='Enable caching of query plans for internal sql statements (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_lowpri_snapisol', description='Give lower priority to locks acquired when updating snapshot state. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='enable_osql_blob_optimization', description='Replicant tracks which columns are modified in a transaction to allow blob updates to be ommitted if possible. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_osql_logging', description='Log every osql packet and operation', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_osql_longreq_logging', description='Log untruncated osql strings', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_overflow_page_trace', description='If set, warn when a page order table scan encounters an overflow page. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_page_compact_backward_scan', description='', type='INTEGER', value='1', read_only='Y')
(name='enable_pageorder_recsz_check', description='Disables 'disable_pageorder_recsz_chk'', type='BOOLEAN', value='ON', read_only='N')
(name='enable_partial_indexes', description='If set, allows partial index definitions in table schema. (Default: off)', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_prefault_udp', description='Send lossy prefault requests to replicants. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_selectv_range_check', description='If set, SELECTV will send ranges for verification, not every touched record. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_seqnum_generations', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_serial_isolation', description='Enable to allow SERIALIZABLE level transactions to run against the database. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='enable_snapshot_isolation', description='Enable to allow SNAPSHOT level transactions to run against the database. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='enable_sp_strict_assignments', description='', type='INTEGER', value='0', read_only='Y')
(name='enable_sparse_lockerid_map', description='If set, allocates a sparse map of lockers for deadlock resolution. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='enable_sql_stmt_caching', description='Enable caching of query plans. If followed by "all" will cache all queries, including those without parameters. (Default: on)', type='ENUM', value='ALL', read_only='Y')
(name='enable_tagged_api', description='Enables tagged api requests. (Default: on)', type='BOOLEAN', value='OFF', read_only='N')
(name='enable_temptable_clean_exit', description='On exit, clean up temptables (they are deleted on next startup regardless).', type='BOOLEAN', value='ON', read_only='N')
(name='enable_upgrade_ahead', description='Occasionally update read records to the newest schema version (saves some processing when reading them later). (Default: off)', type='INTEGER', value='0', read_only='Y')
(name='enablecursorser', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='endianize_locklist', description='Endianize locklist before writing to txnlog.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='epochms_repts', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='erroff', description='Disables 'erron'', type='BOOLEAN', value='OFF', read_only='Y')
(name='erron', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='eventlog_fullhintsql', description='Log full sql statement in the event log for hint abbreviated sql. (Default : on)', type='BOOLEAN', value='ON', read_only='N')
(name='eventlog_nkeep', description='Keep this many eventlog files (Default: 2)', type='INTEGER', value='0', read_only='N')
(name='exclusive_blockop_qconsume', description='Enables serialization of blockops and queue consumes. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='exit_on_internal_failure', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='exitalarmsec', description='', type='INTEGER', value='10', read_only='Y')
(name='extended_sql_debug_trace', description='Print extended trace for durable sql debugging', type='BOOLEAN', value='OFF', read_only='N')
(name='externalauth', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='externalauth_connect', description='Check for externalauth only once on connect', type='BOOLEAN', value='OFF', read_only='N')
(name='externalauth_warn', description='Warn instead of returning error in case of missing authdata', type='BOOLEAN', value='OFF', read_only='N')
(name='fake_sc_replication_timeout', description='Fake a replication timeout on finalize schemachange. ', type='BOOLEAN', value='OFF', read_only='N')
(name='fdb_default_version', description='Override the default fdb version', type='INTEGER', value='9', read_only='N')
(name='fdb_io_error_retries', description='Number of retries for io error remsql', type='INTEGER', value='16', read_only='N')
(name='fdb_io_error_retries_phase_1', description='Number of immediate retries; capped by fdb_io_error_retries', type='INTEGER', value='6', read_only='N')
(name='fdb_io_error_retries_phase_2_poll', description='Poll initial value for slow retries in phase 2; doubled for each retry', type='INTEGER', value='100', read_only='N')
(name='fdb_remsql_cdb2api', description='Switch the standalone remote sql queries to cdb2api', type='BOOLEAN', value='ON', read_only='N')
(name='fdb_socket_timeout_ms', description='Timeout ms for fdb communications.  (Default: 10000)', type='INTEGER', value='0', read_only='N')
(name='fdb_sqlstats_cache_lock_waittime_nsec', description='', type='INTEGER', value='1000', read_only='N')
(name='fdb_version_emulate_precdbapi', description='Testing setting: cdb2api will refuse to parse remsql SET, emulating a pre-cdb2api remsql implementation', type='INTEGER', value='0', read_only='N')
(name='fdbdebg', description='', type='INTEGER', value='0', read_only='N')
(name='fdbtrackhints', description='', type='INTEGER', value='0', read_only='Y')
(name='file_copier', description='Tool used to copy files between nodes. Keys must be setup between machines. (Default: scp)', type='STRING', value='scp', read_only='Y')
(name='file_permissions', description='Default filesystem permissions for database files. (Default: 0660)', type='STRING', value='0660', read_only='N')
(name='fingerprint_queries', description='Compute fingerprint for SQL queries', type='BOOLEAN', value='ON', read_only='N')
(name='fix_cstr', description='Fix validation of cstrings', type='BOOLEAN', value='ON', read_only='N')
(name='fix_pinref', description='fix_pinref', type='BOOLEAN', value='ON', read_only='N')
(name='flush_check_active_peer', description='Check if still have active connection when trying to flush', type='BOOLEAN', value='ON', read_only='N')
(name='flush_on_prepare', description='Flush master log on prepare. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='flush_replicant_on_prepare', description='Flush replicant log on prepare. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='flush_scan_dbs_first', description='Don't hold bufpool mutex while opening files for flush', type='BOOLEAN', value='OFF', read_only='N')
(name='forbid_remote_admin', description='Forbid non-local admin requests.  (Default: on)', type='BOOLEAN', value='OFF', read_only='N')
(name='forbid_remote_repopnewlrl', description='Forbid repopnewlrl requests from remote machines.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='forbid_ulonglong', description='Disallow u_longlong. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='force_directio', description='Force directio on all file opens if set on environment (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='force_highslot', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='force_old_cursors', description='Replicant will use old cursors', type='BOOLEAN', value='OFF', read_only='N')
(name='force_writesql', description='Force admin mode to for write sql.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='foreign_db_allow_cross_class', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='foreign_db_auth_enabled', description='Redirect extern auth data to remote server. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='foreign_db_push_redirect', description='Redirect fdb query to run via client instead of on server. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='foreign_db_push_remote', description='Fdb proxy more for reads (OFF turns off writes as well). (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='foreign_db_push_remote_writes', description='Fdb proxy mode for writes (ON turns on reads as well). (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='foreign_db_resolve_local', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='foreign_metadb', description='Forces metadb for fdb queries to the one specified (Default:NULL)', type='STRING', value=NULL, read_only='N')
(name='foreign_metadb_class', description='Forces metadb for fdb queries to class specified (Default:NULL)', type='STRING', value=NULL, read_only='N')
(name='foreign_metadb_config', description='Cdb2api config file for fdb metadb; superceded by foreign_metadb (Default:NULL)', type='RAW', value=NULL, read_only='N')
(name='fstblk_minq', description='', type='INTEGER', value='262144', read_only='N')
(name='fstdump_buffer_length', description='Size of the per-thread fstdump buffer.', type='INTEGER', value='262144', read_only='N')
(name='fstdump_longreq', description='Long request threshold for fstdump reads.', type='INTEGER', value='5000', read_only='N')
(name='fstdump_maxthreads', description='Maximum number of fstdump threads. (0 for single-threaded, 16 for maximum database thrashing)', type='INTEGER', value='0', read_only='N')
(name='fstdump_thread_stacksz', description='Size of the fstdump thread stack.', type='INTEGER', value='262144', read_only='N')
(name='fullrecovery', description='Attempt to run database recovery from the beginning of available logs. (Default : off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='gather_rowlocks_on_replicant', description='Replicant will gather rowlocks', type='BOOLEAN', value='ON', read_only='N')
(name='gbl_class_machs_refresh', description='Requery-time for class-machine lookup.  (Default: 300s)', type='INTEGER', value='300', read_only='N')
(name='gbl_exit_on_pthread_create_fail', description='If set, database will exit if thread pools aren't able to create threads. (Default: 1)', type='INTEGER', value='1', read_only='Y')
(name='genid48_warn_threshold', description='Print a warning when there are only as few genids remaining.', type='INTEGER', value='500000000', read_only='N')
(name='genid_comp_threshold', description='Try to compress rowids if the record data is smaller than this size.', type='INTEGER', value='60', read_only='N')
(name='genidplusplus', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='genids', description='', type='BOOLEAN', value='ON', read_only='N')
(name='genshard_verbose', description='Enable verbose logging for generic sharding logic', type='BOOLEAN', value='OFF', read_only='N')
(name='gofast', description='', type='BOOLEAN', value='ON', read_only='N')
(name='goslow', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='group_concat_memory_limit', description='Restrict GROUP_CONCAT from using more than this amount of memory; 0 implies SQLITE_MAX_LENGTH, the limit imposed by sqlite. (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='heartbeat_check_time', description='Raise an error if no heartbeat for this amount of time (in secs). (Default: 5 secs)', type='INTEGER', value='5', read_only='Y')
(name='hide_non_durable_rcode', description='Hide non-durable rcode from clients.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='hostile_takeover_retries', description='Attempt to take over mastership if the master machine is marked offline, and the current machine is online.', type='INTEGER', value='0', read_only='N')
(name='hostname', description='', type='STRING', value='***', read_only='Y')
(name='i_am_master', description='', type='BOOLEAN', value='***', read_only='N')
(name='iam_dbname', description='override dbname for IAM', type='STRING', value=NULL, read_only='Y')
(name='iam_usermetric_verbosity', description='IAM user metric verbosity [Default: 0 (off)]', type='INTEGER', value='0', read_only='N')
(name='ignore_bad_table', description='Allow a database with a corrupt table to come up, without that table.', type='BOOLEAN', value='OFF', read_only='N')
(name='ignore_datetime_cast_failures', description='ignore_datetime_cast_failures', type='BOOLEAN', value='OFF', read_only='N')
(name='ignore_extra_blobs', description='ignore_extra_blobs', type='BOOLEAN', value='OFF', read_only='N')
(name='ilock_step', description='Stepup for preallocated ilock-latches', type='INTEGER', value='2048', read_only='N')
(name='incoherent_alarm_time', description='', type='INTEGER', value='120', read_only='Y')
(name='incoherent_clnt_wait', description='Delay incoherent reject if without master (Default: 10sec)', type='INTEGER', value='10', read_only='N')
(name='incoherent_msg_freq', description='', type='INTEGER', value='3600', read_only='Y')
(name='incoherent_nodes', description='incoherent_nodes', type='BOOLEAN', value='ON', read_only='N')
(name='incoherent_slow_inactive_timeout', description='Periodically reset slow-nodes to incoherent.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='index_priority_boost', description='Treat index pages as higher priority in the buffer pool.', type='BOOLEAN', value='ON', read_only='N')
(name='indexrebuild_save_every_n', description='Save schema change state to every n-th row for index only rebuilds.', type='INTEGER', value='1', read_only='N')
(name='inflatelog', description='', type='INTEGER', value='0', read_only='Y')
(name='init_with_bthash', description='', type='INTEGER', value='0', read_only='Y')
(name='init_with_compr', description='', type='ENUM', value='crle', read_only='Y')
(name='init_with_compr_blobs', description='', type='ENUM', value='lz4', read_only='Y')
(name='init_with_genid48', description='Enables Genid48 for the database. (Default: on)', type='INTEGER', value='1', read_only='Y')
(name='init_with_inplace_updates', description='Initialize tables with inplace-update support. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='init_with_instant_schema_change', description='Same as 'instant_schema_change'', type='BOOLEAN', value='ON', read_only='Y')
(name='init_with_ondisk_header', description='Initialize tables with on-disk header. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='init_with_queue_compr', description='', type='ENUM', value='lz4', read_only='Y')
(name='init_with_queue_ondisk_header', description='Initialize queues with on-disk header. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='init_with_queue_persistent_sequence', description='Initialize queues with persistent sequence numbers. (Default: on)', type='BOOLEAN', value='OFF', read_only='Y')
(name='init_with_rowlocks', description='Enables row-locks for the database. (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='init_with_rowlocks_master_only', description='Enables row-locks for the database (master-only). (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='init_with_time_based_genids', description='Enables time-based GENIDs', type='BOOLEAN', value='OFF', read_only='Y')
(name='inline_mtraps', description='inline_mtraps', type='BOOLEAN', value='OFF', read_only='N')
(name='inmem_repdb_memory', description='Current memory usage of in-memory repdb.  (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='instant_schema_change', description='When possible (eg: when just adding fields) schema change will not rebuild the underlying tables. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='iomap_enabled', description='Map file that tells comdb2ar to pause while we fsync', type='BOOLEAN', value='ON', read_only='N')
(name='ioqueue', description='Maximum depth of the I/O prefaulting queue. (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='iothreads', description='Number of threads to use for I/O prefaulting. (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='keep_referenced_files', description='Don't remove any files that may still be referenced by the logs.', type='BOOLEAN', value='ON', read_only='N')
(name='key_updates', description='Update non-dupe keys instead of delete/add', type='BOOLEAN', value='ON', read_only='N')
(name='keycompr', description='Enable index compression (applies to newly allocated index pages, rebuild table to force for all pages.', type='BOOLEAN', value='ON', read_only='Y')
(name='large_str_idx_find', description='Allow index search using out-of-range strings or bytearrays', type='BOOLEAN', value='ON', read_only='N')
(name='largepages', description='Enables large pages. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='latch_max_poll', description='Poll latch this many times before returning deadlock', type='INTEGER', value='5', read_only='N')
(name='latch_max_wait', description='Block at most this many microseconds before returning deadlock', type='INTEGER', value='5000', read_only='N')
(name='latch_poll_us', description='Poll latch this many microseconds before retrying', type='INTEGER', value='1000', read_only='N')
(name='latch_timed_mutex', description='Use a timed mutex', type='BOOLEAN', value='ON', read_only='N')
(name='lclpooledbufs', description='', type='INTEGER', value='32', read_only='Y')
(name='lease_renew_interval', description='How often we renew leases.', type='INTEGER', value='200', read_only='N')
(name='leasebase_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='legacy_verbose', description='Log all legacy (opcode+old sql) requests (default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='libevent_rte_only', description='Prevent listening on TCP socket. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='lightweight_rename', description='Replaces the ondisk file rename with an aliasing at llmeta level', type='BOOLEAN', value='OFF', read_only='N')
(name='little_endian_btrees', description='Enabling this sets byte ordering for pages to little endian.', type='BOOLEAN', value='ON', read_only='N')
(name='lk_hash', description='', type='INTEGER', value='32', read_only='Y')
(name='lk_part', description='', type='INTEGER', value='73', read_only='Y')
(name='lkr_hash', description='', type='INTEGER', value='16', read_only='Y')
(name='lkr_part', description='', type='INTEGER', value='23', read_only='Y')
(name='llmeta', description='', type='BOOLEAN', value='ON', read_only='N')
(name='llmeta_deadlock_poll', description='Max poll for llmeta on deadlock.  (Default: 0ms)', type='INTEGER', value='0', read_only='N')
(name='llmeta_pagesize', description='Init-option for llmeta and metadb pagesizes.  (Default: 4096)', type='INTEGER', value='0', read_only='Y')
(name='load_cache_max_pages', description='Maximum number of pages that will load into cache.  Setting to 0 means that there is no limit.  (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='load_cache_threads', description='Number of threads loading pages to cache.  (Default: 8)', type='INTEGER', value='8', read_only='N')
(name='loadcache.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='loadcache.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='loadcache.linger', description='Thread linger time (in seconds).', type='INTEGER', value='10', read_only='N')
(name='loadcache.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='500', read_only='N')
(name='loadcache.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='loadcache.maxq', description='Maximum size of queue.', type='INTEGER', value='0', read_only='N')
(name='loadcache.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='loadcache.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='8', read_only='N')
(name='loadcache.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='0', read_only='N')
(name='loadcache.stacksz', description='Thread stack size.', type='INTEGER', value='1048576', read_only='N')
(name='lock_conflict_trace', description='Dump count of lock conflicts every second. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='lock_dba_user', description='When enabled, 'dba' user cannot be removed and its access permissions cannot be modified. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='lock_timing', description='Berkeley DB will keep stats on time spent waiting for locks', type='BOOLEAN', value='ON', read_only='N')
(name='lockerid_node_step', description='Stepup for preallocated lids', type='INTEGER', value='128', read_only='N')
(name='locks_check_waiters', description='Light a flag if a lockid has waiters', type='BOOLEAN', value='ON', read_only='N')
(name='log_applied_lsns', description='Log applied LSNs to log', type='BOOLEAN', value='OFF', read_only='N')
(name='log_cursor_cache', description='Cache log cursors', type='BOOLEAN', value='OFF', read_only='N')
(name='log_debug_ctrace_threshold', description='Limit trace about log file deletion to this many events.', type='INTEGER', value='20', read_only='N')
(name='log_delete_age', description='Log deletion policy', type='INTEGER', value='0', read_only='Y')
(name='log_delete_low_headroom_breaktime', description='Try to delete logs this many times if the filesystem is getting full before giving up.', type='INTEGER', value='10', read_only='N')
(name='log_fstsnd_triggers', description='Log all fstsnd triggers to file', type='BOOLEAN', value='OFF', read_only='N')
(name='logdelete_run_interval', description='', type='INTEGER', value='30', read_only='N')
(name='logdeleteage', description='', type='INTEGER', value='0', read_only='N')
(name='logdeletelowfilenum', description='Set the lowest deleteable log file number.', type='INTEGER', value='-1', read_only='N')
(name='logfiledelta', description='Treat LSN differences less than this as 'close enough' for the purpose of determining if a new node is in sync.', type='INTEGER', value='4096', read_only='N')
(name='logfilesize', description='Attempt to keep each log file around this size.', type='INTEGER', value='41943040', read_only='N')
(name='loghist', description='', type='INTEGER', value='0', read_only='Y')
(name='loghist_verbose', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='logical_live_sc', description='Enables online schema change with logical redo. (Default: OFF)', type='BOOLEAN', value='OFF', read_only='N')
(name='logmemsize', description='Use this much memory for a log file in-memory buffer.', type='INTEGER', value='10485760', read_only='N')
(name='logmsg.epochms', description='Show epochms in log-messages.  (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='logmsg.level', description='All messages below this level will not be logged.', type='ENUM', value='DEBUG', read_only='N')
(name='logmsg.notimestamp', description='Disables 'syslog.timestamp'.', type='BOOLEAN', value='OFF', read_only='N')
(name='logmsg.syslog', description='Log messages to syslog.', type='BOOLEAN', value='OFF', read_only='N')
(name='logmsg.timestamp', description='Stamp all messages with timestamp.', type='BOOLEAN', value='ON', read_only='N')
(name='logs_on_panic', description='logs_on_panic', type='BOOLEAN', value='ON', read_only='N')
(name='logsegments', description='Changing this can create multiple logfile segments. Multiple segments can allow the log to be written while other segments are being flushed.', type='INTEGER', value='1', read_only='N')
(name='long_req_threshold', description='Sets the threshold time in ms after which requests are reported as running a long time. (Default: 2000 ms)', type='INTEGER', value='2000', read_only='N')
(name='longreq_log_freq_sec', description='Log information about long running statements at this frequency (Default: 60sec)', type='INTEGER', value='60', read_only='N')
(name='lowdiskthreshold', description='Sets the low headroom threshold (percent of filesystem full) above which Comdb2 will start removing logs against set policy.', type='INTEGER', value='95', read_only='N')
(name='lsnerr_logflush', description='Flush log on lsn error', type='BOOLEAN', value='ON', read_only='N')
(name='lsnerr_pgdump', description='Dump page on LSN errors', type='BOOLEAN', value='ON', read_only='N')
(name='lsnerr_pgdump_all', description='Dump page on LSN errors on all nodes', type='BOOLEAN', value='OFF', read_only='N')
(name='machine_class', description='override for the machine class from this db perspective.', type='STRING', value=NULL, read_only='Y')
(name='make_slow_replicants_incoherent', description='Make slow replicants incoherent.', type='BOOLEAN', value='OFF', read_only='N')
(name='mask_internal_tunables', description='When enabled, comdb2_tunables system table would not list INTERNAL tunables (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='master_lease', description='', type='INTEGER', value='500', read_only='N')
(name='master_lease_renew_interval', description='', type='INTEGER', value='200', read_only='N')
(name='master_lease_set_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='master_reject_requests', description='Master will reject SQL requests - they'll be routed to a replicant. The master can serve SQL requests, but it's better to avoid it for better workload balancing.', type='BOOLEAN', value='OFF', read_only='N')
(name='master_reject_sql_ignore_sanc', description='If MASTER_REJECT_REQUESTS is set, reject if no other connected nodes are available.', type='BOOLEAN', value='OFF', read_only='N')
(name='master_retry_poll_ms', description='Have a node wait this long after a master swing before retrying a transaction. (Default: 100ms)', type='INTEGER', value='100', read_only='Y')
(name='master_swing_osql_verbose', description='Produce verbose trace for SQL handlers detecting a master change. (Default: off)', type='BOOLEAN', value='ON', read_only='Y')
(name='master_swing_osql_verbose_off', description='Disables 'master_swing_osql_verbose'', type='BOOLEAN', value='OFF', read_only='N')
(name='master_swing_sock_restart_sleep', description='For testing: sleep in osql_sock_restart when master swings', type='INTEGER', value='0', read_only='Y')
(name='max_authorization_cache', description='Max cache size of authorized identities (Default: 2000)', type='INTEGER', value='2000', read_only='Y')
(name='max_cascaded_rows_per_txn', description='Set the max cascaded rows updated per transaction.', type='INTEGER', value='0', read_only='N')
(name='max_clientstats', description='Max number of client stats stored in comdb2_clientstats. (Default: 10000)', type='INTEGER', value='10000', read_only='N')
(name='max_identity_cache', description='Max cache size of externalauth identities (Default: 500)', type='INTEGER', value='500', read_only='Y')
(name='max_incoherent_nodes', description='', type='INTEGER', value='1', read_only='Y')
(name='max_incoherent_slow', description='Sets maximum number of incoherent-slow nodes.  (Default: 3)', type='INTEGER', value='3', read_only='N')
(name='max_latch', description='Size of latch array', type='INTEGER', value='200000', read_only='N')
(name='max_latch_lockerid', description='Size of latch lockerid array', type='INTEGER', value='10000', read_only='N')
(name='max_lua_instructions', description='Maximum lua opcodes to execute before we assume the stored procedure is looping and kill it. (Default: 10000)', type='INTEGER', value='10000', read_only='N')
(name='max_num_compact_pages_per_txn', description='', type='INTEGER', value='-1', read_only='N')
(name='max_password_cache_size', description='Password cache size, set to <=0 to turn off caching (Default: 100)', type='INTEGER', value='100', read_only='N')
(name='max_plan_query_plans', description='Maximum number of plans to be placed into the query plan hash for each fingerprint (Default: 20)', type='INTEGER', value='20', read_only='N')
(name='max_query_fingerprints', description='Maximum number of queries to be placed into the fingerprint hash (Default: 1000)', type='INTEGER', value='1000', read_only='N')
(name='max_query_sample_queries', description='Maximum number of queries to be placed into the sample queries hash (Default: 1000)', type='INTEGER', value='1000', read_only='N')
(name='max_rowlocks_reposition', description='Release a physical cursor an re-establish.', type='INTEGER', value='10', read_only='N')
(name='max_sql_idle_time', description='Warn when an SQL connection remains idle for this long.', type='INTEGER', value='3600', read_only='N')
(name='max_sqlcache_hints', description='Maximum number of "hinted" query plans to keep (global). (Default: 100)', type='INTEGER', value='100', read_only='Y')
(name='max_sqlcache_per_thread', description='Maximum number of plans to cache per sql thread (statement cache is per-thread). (Default: 10)', type='INTEGER', value='10', read_only='Y')
(name='max_time_per_txn_ms', description='Set the max time allowed for transaction to finish', type='INTEGER', value='0', read_only='N')
(name='max_trigger_threads', description='Maximum number of trigger threads allowed', type='INTEGER', value='1000', read_only='N')
(name='max_vlog_lsns', description='Apply up to this many replication record trying to maintain a snapshot transaction.', type='INTEGER', value='10000000', read_only='N')
(name='max_wr_logbytes_per_txn', description='Set the maximum number of log-bytes written per transaction.', type='INT64', value='0', read_only='N')
(name='max_wr_rows_per_txn', description='Set the max written rows per transaction.', type='INTEGER', value='0', read_only='N')
(name='maxappsockslimit', description='Start dropping new connections on this many connections to the database.', type='INTEGER', value='1400', read_only='N')
(name='maxblockops', description='', type='INTEGER', value='25000', read_only='Y')
(name='maxcolumns', description='Raise the maximum permitted number of columns per table. There is a hard limit of 1024. (Default: 255)', type='INTEGER', value='255', read_only='Y')
(name='maxcontextskips', description='', type='INTEGER', value='10000', read_only='Y')
(name='maxlockers', description='Initial size of the lockers table (there is no current maximum).', type='INTEGER', value='256', read_only='N')
(name='maxlockobjects', description='', type='INTEGER', value='1024', read_only='N')
(name='maxlocks', description='', type='INTEGER', value='1024', read_only='N')
(name='maxosqltransfer', description='Maximum number of record modifications allowed per transaction. (Default: 50000)', type='INTEGER', value='50000', read_only='N')
(name='maxq', description='Maximum queue depth for write requests. (Default: 192)', type='INTEGER', value='192', read_only='N')
(name='maxretries', description='Maximum number of times a transactions will be retried on a deadlock. (Default: 500)', type='INTEGER', value='500', read_only='N')
(name='maxsockcached', description='After this many connections, start requesting that further connections are no longer pooled.', type='INTEGER', value='500', read_only='N')
(name='maxt', description='', type='INTEGER', value='48', read_only='N')
(name='maxtxn', description='Maximum concurrent transactions.', type='INTEGER', value='128', read_only='N')
(name='maxwt', description='Maximum number of threads processing write requests. (Default: 8)', type='INTEGER', value='8', read_only='N')
(name='memnice', description='', type='INTEGER', value='1', read_only='Y')
(name='memp_dump_cache_threshold', description='Don't flush the cache until this percentage of pages have changed.  (Default: 20)', type='INTEGER', value='20', read_only='N')
(name='memp_pg_timing', description='Berkeley DB will keep stats on time spent in __memp_pg', type='BOOLEAN', value='ON', read_only='N')
(name='memp_timing', description='Berkeley DB will keep stats on time spent in __memp_fget', type='BOOLEAN', value='OFF', read_only='N')
(name='mempget_timeout', description='', type='INTEGER', value='60', read_only='Y')
(name='memptrickle.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='memptrickle.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='memptrickle.linger', description='Thread linger time (in seconds).', type='INTEGER', value='10', read_only='N')
(name='memptrickle.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='30000', read_only='N')
(name='memptrickle.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='memptrickle.maxq', description='Maximum size of queue.', type='INTEGER', value='8000', read_only='N')
(name='memptrickle.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='memptrickle.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='4', read_only='N')
(name='memptrickle.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='1', read_only='N')
(name='memptrickle.stacksz', description='Thread stack size.', type='INTEGER', value='1048576', read_only='N')
(name='memptricklemsecs', description='Pause for this many ms between runs of the cache flusher.', type='INTEGER', value='1000', read_only='N')
(name='memptricklepercent', description='Try to keep at least this percentage of the buffer pool clean. Write pages periodically until that's achieved.', type='INTEGER', value='99', read_only='N')
(name='mempv_debug', description='Produce debug output in versioned memory pool', type='BOOLEAN', value='OFF', read_only='N')
(name='mempv_max_cache_entries', description='Maximum number of cache entries in versioned memory pool', type='INTEGER', value='50', read_only='N')
(name='memstat_autoreport_freq', description='Dump memory usage to trace files at this frequency (in secs). (Default: 180 secs)', type='INTEGER', value='300', read_only='Y')
(name='merge_table_enabled', description='Allow syntax create/alter table ... merge ...', type='BOOLEAN', value='ON', read_only='N')
(name='mifid2_datetime_range', description='Extend datetime range to meet mifid2 requirements', type='BOOLEAN', value='ON', read_only='N')
(name='min_aa_ops', description='Start analyze after this many operations.', type='INTEGER', value='100000', read_only='N')
(name='min_aa_time', description='Don't re-run auto-analyze if already ran within this many seconds.', type='INTEGER', value='7200', read_only='N')
(name='min_keep_logs', description='', type='INTEGER', value='5', read_only='N')
(name='min_keep_logs_age', description='Keep logs that are at least this old (0: do not keep logs based on time).', type='INTEGER', value='0', read_only='N')
(name='min_keep_logs_age_hwm', description='', type='INTEGER', value='0', read_only='N')
(name='morecolumns', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='move_deadlock_max_attempt', description='', type='INTEGER', value='500', read_only='N')
(name='msgwaittime', description='Network timeout for pushnext & queue changes.  (Default: 10000)', type='INTEGER', value='10000', read_only='N')
(name='multitable_ddl', description='Enables single schema change object ddl implementation (default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='natural_types', description='Same as 'nosurprise'', type='BOOLEAN', value='OFF', read_only='Y')
(name='net_inorder_logputs', description='Attempt to order messages to ensure they go out in LSN order.', type='BOOLEAN', value='OFF', read_only='N')
(name='net_send_gblcontext', description='Enable net_send for USER_TYPE_GBLCONTEXT.', type='BOOLEAN', value='OFF', read_only='N')
(name='net_somaxconn', description='listen() backlog setting.  (Default: 0, implies system default)', type='INTEGER', value='0', read_only='Y')
(name='net_verbose', description='net_verbose', type='BOOLEAN', value='OFF', read_only='N')
(name='netconndumptime', description='Dump connection statistics to ctrace this often.', type='INTEGER', value='3158070', read_only='N')
(name='new_indexes', description='Let replicants send indexes values to master', type='BOOLEAN', value='OFF', read_only='N')
(name='new_leader_duration', description='Time new query waits for replicanted-recovery (Default: 3sec)', type='INTEGER', value='3', read_only='N')
(name='new_master_dummy_add_delay', description='Force a transaction after this delay, after becoming master.', type='INTEGER', value='5', read_only='N')
(name='newqdelmode', description='Enables new queue deletion mode.', type='BOOLEAN', value='ON', read_only='N')
(name='no_ack_trace', description='Disables 'ack_trace'', type='BOOLEAN', value='ON', read_only='Y')
(name='no_compress_page_compact_log', description='Disables 'compress_page_compact_log'', type='BOOLEAN', value='OFF', read_only='Y')
(name='no_epochms_repts', description='Disables 'epochms_repts'', type='BOOLEAN', value='ON', read_only='Y')
(name='no_exit_on_internal_failure', description='Disables 'exit_on_internal_failure'', type='BOOLEAN', value='OFF', read_only='Y')
(name='no_lock_conflict_trace', description='Disables 'lock_conflict_trace'', type='BOOLEAN', value='ON', read_only='N')
(name='no_null_blob_fix', description='Disables 'null_blob_fix'', type='BOOLEAN', value='OFF', read_only='Y')
(name='no_rep_process_txn_trace', description='Disables 'rep_process_txn_trace'', type='BOOLEAN', value='ON', read_only='Y')
(name='no_round_robin_stripes', description='Disables 'round_robin_stripes'', type='BOOLEAN', value='ON', read_only='Y')
(name='no_sc_inco_chk', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='no_static_tag_blob_fix', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='no_timeouts_on_release_locks', description='Disable client-timeouts if we're releasing locks', type='BOOLEAN', value='ON', read_only='N')
(name='no_update_delete_limit', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='noblobstripe', description='Disables 'blobstripe'', type='BOOLEAN', value='OFF', read_only='Y')
(name='nochecksums', description='Disables 'checksums'', type='BOOLEAN', value='OFF', read_only='N')
(name='nocrc32c', description='Disables 'crc32c'', type='BOOLEAN', value='OFF', read_only='Y')
(name='nodeid', description='', type='INTEGER', value='0', read_only='Y')
(name='noearly', description='Disables 'early'', type='BOOLEAN', value='OFF', read_only='Y')
(name='nokeycompr', description='Disables 'keycompr'', type='BOOLEAN', value='OFF', read_only='Y')
(name='nomaster_alert_seconds', description='Replicants will alarm if there's no master for this many seconds.', type='INTEGER', value='60', read_only='N')
(name='nonames', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='norcache', description='Disables 'rcache'', type='BOOLEAN', value='ON', read_only='Y')
(name='noreallearly', description='Disables 'reallearly'', type='BOOLEAN', value='ON', read_only='Y')
(name='norepdebug', description='Disables 'repdebug'', type='BOOLEAN', value='OFF', read_only='Y')
(name='nosurprise', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='notimeout', description='Turns off SQL timeouts. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='noudp', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='nowatch', description='Disable watchdog. Watchdog aborts the database if basic things like creating threads, allocating memory, etc. doesn't work. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='nudge_replication_when_idle', description='If we haven't seen any replication events in a while, request some (default: 100)', type='INTEGER', value='100', read_only='N')
(name='null_blob_fix', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='nullfkey', description='Do not enforce foreign key constraints for null keys. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='num_contexts', description='', type='INTEGER', value='16', read_only='Y')
(name='num_record_converts', description='During schema changes, pack this many records into a transaction. (Default: 100)', type='INTEGER', value='100', read_only='Y')
(name='num_write_retries', description='number of times to retry writes on ENOSPC', type='INTEGER', value='128', read_only='N')
(name='numberkdbcaches', description='Split the cache into this many segments.', type='INTEGER', value='0', read_only='N')
(name='numtimesbehind', description='', type='INTEGER', value='1000000000', read_only='N')
(name='oldrangexlim', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='on_del_set_null_feature', description='Enables support for ON DELETE SET NULL foreign key constraint action (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='on_pthread_create_error', description='on_pthread_create_error', type='BOOLEAN', value='ON', read_only='N')
(name='one_pass_delete', description='', type='BOOLEAN', value='ON', read_only='N')
(name='only_match_on_commit', description='Only rep_verify_match on commit records', type='BOOLEAN', value='ON', read_only='N')
(name='optimize_repdb_truncate', description='Enables use of optimized repdb truncate code. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='orderedrrns', description='', type='BOOLEAN', value='ON', read_only='N')
(name='osql_bkoff_netsend', description='', type='INTEGER', value='100', read_only='Y')
(name='osql_bkoff_netsend_lmt', description='', type='INTEGER', value='300000', read_only='Y')
(name='osql_force_local', description='osql_force_local', type='BOOLEAN', value='OFF', read_only='N')
(name='osql_odh_blob', description='Send ODH'd blobs to master. (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='osql_simulate_send_error', description='osql_simulate_send_error', type='BOOLEAN', value='OFF', read_only='N')
(name='osql_verbose_clear', description='osql_verbose_clear', type='BOOLEAN', value='OFF', read_only='N')
(name='osql_verbose_history_replay', description='osql_verbose_history_replay', type='BOOLEAN', value='OFF', read_only='N')
(name='osql_verify_ext_chk', description='For block transaction mode only - after this many verify errors, check if transaction is non-commitable (see default isolation level). (Default: on)', type='INTEGER', value='1', read_only='Y')
(name='osql_verify_retry_max', description='Retry a transaction on a verify error this many times (see optimistic concurrency control). (Default: 499)', type='INTEGER', value='499', read_only='N')
(name='osqlpfaultpool.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='osqlpfaultpool.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='osqlpfaultpool.linger', description='Thread linger time (in seconds).', type='INTEGER', value='10', read_only='N')
(name='osqlpfaultpool.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='10000', read_only='N')
(name='osqlpfaultpool.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='osqlpfaultpool.maxq', description='Maximum size of queue.', type='INTEGER', value='1000', read_only='N')
(name='osqlpfaultpool.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='osqlpfaultpool.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='0', read_only='N')
(name='osqlpfaultpool.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='0', read_only='N')
(name='osqlpfaultpool.stacksz', description='Thread stack size.', type='INTEGER', value='1048576', read_only='N')
(name='osqlprefaultthreads', description='If set, send prefaulting hints to nodes. (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='osync', description='Enables O_SYNC on data files (reads still go through FS cache) if directio isn't set.', type='BOOLEAN', value='OFF', read_only='N')
(name='override_cachekb', description='', type='INTEGER', value='0', read_only='Y')
(name='page_compact_indexes', description='Enables page compaction for indexes.', type='BOOLEAN', value='OFF', read_only='N')
(name='page_compact_latency_ms', description='', type='INTEGER', value='0', read_only='Y')
(name='page_compact_target_ff', description='', type='DOUBLE', value='0.693', read_only='N')
(name='page_compact_thresh_ff', description='', type='DOUBLE', value='0', read_only='Y')
(name='page_compact_udp', description='Enables sending of page compact requests over UDP.', type='BOOLEAN', value='OFF', read_only='N')
(name='page_extent_size', description='If set, allocate pages in blocks of this many (extents).', type='INTEGER', value='0', read_only='N')
(name='page_latches', description='If set, in rowlocks mode, will acquire fast latches on pages instead of full locks. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='page_order_tablescan', description='Scan tables in order of pages, not in order of rowids (faster for non-sparse tables).', type='BOOLEAN', value='OFF', read_only='N')
(name='pagedeadlock_maxpoll', description='If retrying on deadlock (see pagedeadlock_retries), poll up to this many ms on each retry.', type='INTEGER', value='5', read_only='N')
(name='pagedeadlock_retries', description='On a page deadlock, retry the page operation up to this many times.', type='INTEGER', value='500', read_only='N')
(name='pageordertablescan', description='Perform table scans in page order and not row order. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='pagesizeblob', description='', type='INTEGER', value='65536', read_only='N')
(name='pagesizedta', description='', type='INTEGER', value='4096', read_only='N')
(name='pagesizeix', description='', type='INTEGER', value='4096', read_only='N')
(name='panicfulldiag', description='Enables full diagnostic on a panic.', type='BOOLEAN', value='OFF', read_only='N')
(name='paniclogsnap', description='', type='BOOLEAN', value='ON', read_only='N')
(name='parallel_count', description='When 'direct_count' is on, enable thread-per-stripe', type='BOOLEAN', value='OFF', read_only='N')
(name='parallel_recovery', description='', type='INTEGER', value='0', read_only='Y')
(name='parallel_sync', description='Run checkpoint/memptrickle code with parallel writes', type='BOOLEAN', value='ON', read_only='N')
(name='participantid_bits', description='Number of bits allocated for the participant stripe ID (remaining bits are used for the update ID).', type='INTEGER', value='0', read_only='N')
(name='partition_sc_reorder', description='If the schema change is serialized for a partition, run current shard last', type='BOOLEAN', value='ON', read_only='N')
(name='partitioned_table_enabled', description='Allow syntax create/alter table ... partitioned by ...', type='BOOLEAN', value='ON', read_only='N')
(name='pause_moveto', description='pause_moveto', type='BOOLEAN', value='OFF', read_only='N')
(name='pbkdf2_iterations', description='Number of iterations of PBKDF2 algorithm for password hashing.', type='INTEGER', value='4096', read_only='N')
(name='penaltyincpercent', description='', type='INTEGER', value='20', read_only='Y')
(name='perfect_ckp', description='', type='INTEGER', value='0', read_only='Y')
(name='perform_full_clean_exit', description='Perform full clean exit on exit signal.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='permit_small_sequences', description='Allow int32 and int16 length sequences.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='pflt_toblock_lcl', description='Prefault toblock operations locally', type='BOOLEAN', value='ON', read_only='N')
(name='pflt_toblock_rep', description='Prefault toblock operations on replicants', type='BOOLEAN', value='ON', read_only='N')
(name='pfltverbose', description='Verbose errors in prefaulting code', type='BOOLEAN', value='ON', read_only='N')
(name='pgcomp_dbg_ctrace', description='Enable debugging ctrace for page compaction (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='pgcomp_dbg_stdout', description='Enable debugging stdout trace for page compaction (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='pgcomp_dryrun', description='Dry-run page compaction (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='pgcompactpool.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='pgcompactpool.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='pgcompactpool.linger', description='Thread linger time (in seconds).', type='INTEGER', value='10', read_only='N')
(name='pgcompactpool.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='10000', read_only='N')
(name='pgcompactpool.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='pgcompactpool.maxq', description='Maximum size of queue.', type='INTEGER', value='1000', read_only='N')
(name='pgcompactpool.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='pgcompactpool.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='1', read_only='N')
(name='pgcompactpool.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='1', read_only='N')
(name='pgcompactpool.stacksz', description='Thread stack size.', type='INTEGER', value='1048576', read_only='N')
(name='physical_ack_interval', description='For logical transactions, have the slave send an 'ack' after this many physical operations.', type='INTEGER', value='0', read_only='N')
(name='physical_commit_interval', description='Force a physical commit after this many physical operations.', type='INTEGER', value='512', read_only='N')
(name='physrep_check_minlog_freq_sec', description='Check the minimum log number to keep this often. (Default: 10)', type='INTEGER', value='10', read_only='N')
(name='physrep_debug', description='Print extended physrep trace. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='physrep_exit_on_invalid_logstream', description='Exit physreps on invalid logstream.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='physrep_fanout', description='Maximum number of physical replicants that a node can service (Default: 8)', type='INTEGER', value='8', read_only='N')
(name='physrep_hung_replicant_check_freq_sec', description='Check for hung physical replicant this often. (Default: 10)', type='INTEGER', value='10', read_only='N')
(name='physrep_hung_replicant_threshold', description='Report if the physical replicant has been inactive for this duration. (Default: 60)', type='INTEGER', value='60', read_only='N')
(name='physrep_i_am_metadb', description='I am physical replication metadb (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='physrep_ignore_queues', description='Don't replicate queues.', type='BOOLEAN', value='ON', read_only='Y')
(name='physrep_keepalive_freq_sec', description='Periodically send lsn to source node after this interval. (Default: 10)', type='INTEGER', value='10', read_only='N')
(name='physrep_keepalive_v2', description='Use version 2 of keepalive which includes first lsn. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='physrep_max_candidates', description='Maximum number of candidates that should be returned to a new physical replicant during registration. (Default: 6)', type='INTEGER', value='6', read_only='N')
(name='physrep_max_pending_replicants', description='There can be no more than this many physical replicants in pending state. (Default: 10)', type='INTEGER', value='10', read_only='N')
(name='physrep_max_rollback', description='Maximum logs physrep can rollback. (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='physrep_metadb_host', description='List of physical replication metadb cluster hosts.', type='STRING', value=NULL, read_only='Y')
(name='physrep_metadb_name', description='Physical replication metadb cluster name.', type='STRING', value=NULL, read_only='Y')
(name='physrep_reconnect_interval', description='Reconnect interval for physical replicants (Default: 600)', type='INTEGER', value='600', read_only='N')
(name='physrep_reconnect_penalty', description='Physrep wait seconds before retry to the same node. (Default: 5)', type='INTEGER', value='0', read_only='N')
(name='physrep_repl_host', description='Current physrep host.', type='STRING', value=NULL, read_only='Y')
(name='physrep_repl_name', description='Current physrep parent.', type='STRING', value=NULL, read_only='Y')
(name='physrep_revconn_check_interval', description='Physrep recheck revconn interval.  (Default: 60)', type='INTEGER', value='60', read_only='N')
(name='physrep_shuffle_host_list', description='Shuffle the host list returned by register_replicant() before connecting to the hosts. (Default: OFF)', type='BOOLEAN', value='OFF', read_only='N')
(name='physrep_source_dbname', description='Physical replication source cluster dbname.', type='STRING', value=NULL, read_only='Y')
(name='physrep_source_dbnum', description='Physical replication source cluster db number.', type='INTEGER', value='0', read_only='Y')
(name='physrep_source_host', description='List of physical replication source cluster hosts.', type='STRING', value=NULL, read_only='Y')
(name='physrep_update_registry_interval', description='Physrep update-registry interval. (Default: 60)', type='INTEGER', value='60', read_only='N')
(name='plannedsc', description='Use planned schema change by default', type='BOOLEAN', value='ON', read_only='N')
(name='planner_effort', description='Planner effort (try harder) levels. (Default: 1)', type='INTEGER', value='1', read_only='N')
(name='planner_show_scanstats', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='planner_warn_on_discrepancy', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='plugindir', description='Default directory to look for shared object files.', type='STRING', value=NULL, read_only='Y')
(name='poll_on_lock_desired', description='poll_on_lock_desired', type='BOOLEAN', value='ON', read_only='N')
(name='portmux_bind_path', description='', type='STRING', value='/tmp/portmux.socket', read_only='Y')
(name='portmux_port', description='', type='INTEGER', value='5105', read_only='Y')
(name='preallocate_max', description='Pre-allocation size', type='INTEGER', value='268435456', read_only='N')
(name='preallocate_on_writes', description='Pre-allocate on writes', type='BOOLEAN', value='OFF', read_only='N')
(name='prefaulthelper_blockops', description='', type='INTEGER', value='1', read_only='Y')
(name='prefaulthelper_sqlreadahead', description='', type='INTEGER', value='1', read_only='Y')
(name='prefaulthelperthreads', description='Max number of prefault helper threads. (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='prefix_foreign_keys', description='Allow foreign key to be a prefix of your key', type='BOOLEAN', value='ON', read_only='N')
(name='print_blockp_stats', description='print thread-count in block processor', type='BOOLEAN', value='OFF', read_only='N')
(name='print_deadlock_cycles', description='Print every Nth deadlock cycle, set to 0 to turn off. (Default: 100)', type='INTEGER', value='100', read_only='N')
(name='print_flush_log_msg', description='Produce trace when flushing log files.', type='BOOLEAN', value='OFF', read_only='N')
(name='print_syntax_err', description='Trace all SQL with syntax errors. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='private_blkseq', description='Keep a private blkseq', type='BOOLEAN', value='ON', read_only='N')
(name='private_blkseq_cachesz', description='Cache size of the blkseq table.', type='INTEGER', value='4194304', read_only='N')
(name='private_blkseq_close_warn_time', description='Warn when it takes longer than this many MS to roll a blkseq table.', type='BOOLEAN', value='ON', read_only='N')
(name='private_blkseq_enabled', description='Sets whether dupe detection is enabled.', type='BOOLEAN', value='ON', read_only='N')
(name='private_blkseq_maxage', description='Maximum time in seconds to let 'old' transactions live.', type='INTEGER', value='600', read_only='N')
(name='private_blkseq_maxtraverse', description='', type='INTEGER', value='4', read_only='N')
(name='private_blkseq_stripes', description='Number of stripes for the blkseq table.', type='INTEGER', value='8', read_only='N')
(name='protobuf_connectmsg', description='Use protobuf in net library for the connect message. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='qscanmode', description='Enables queue scan mode optimisation.', type='BOOLEAN', value='OFF', read_only='N')
(name='query_plan_percentage', description='Alarm if the average cost per row of current query plan is n percent above the cost for different query plan. (Default: 50)', type='DOUBLE', value='50', read_only='N')
(name='query_plans', description='Keep track of query plans and their costs for each query', type='BOOLEAN', value='ON', read_only='N')
(name='queue_nonodh_scan_limit', description='For comdb2_queues, stop queue scan at this depth (Default: 10000)', type='INTEGER', value='10000', read_only='N')
(name='queuedb_file_interval', description='Check on this interval each queuedb against its configured maximum file size. (Default: 60000ms)', type='INTEGER', value='60000', read_only='Y')
(name='queuedb_file_threshold', description='Maximum queuedb file size (in MB) before enqueueing to the alternate file.  (Default: 0)', type='INTEGER', value='0', read_only='Y')
(name='queuedb_genid_filename', description='Use genid in queuedb filenames.  (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='queuedb_timeout_sec', description='Unassign Lua consumer/trigger if no heartbeat received for this time', type='INTEGER', value='10', read_only='N')
(name='rand_udp_fails', description='Rate of drop of UDP packets (for testing).', type='INTEGER', value='0', read_only='N')
(name='random_lock_release_interval', description='', type='INTEGER', value='0', read_only='Y')
(name='random_rowlocks', description='Grab random, guaranteed non-conflicting rowlocks', type='BOOLEAN', value='OFF', read_only='N')
(name='rangextlim', description='', type='INTEGER', value='16', read_only='Y')
(name='rcache', description='Keep a lookaside cache of root pages for B-trees. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='rcache_count', description='Number of entries in root page cache.', type='INTEGER', value='257', read_only='N')
(name='rcache_pgsz', description='Size of pages in root page cache.', type='INTEGER', value='4096', read_only='N')
(name='reallearly', description='Acknowledge as soon as a commit record is seen by the replicant (before it's applied). This effectively makes replication asynchronous, so reads may not see the effects of a committed transaction yet. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='receive_coherency_lease_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='receive_start_lsn_request_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='recover_deadlock_newmode', description='recover_deadlock_newmode', type='BOOLEAN', value='ON', read_only='N')
(name='recovery_ckp', description='Emit a non-matchable ckp during recovery.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='recovery_pages', description='Disabled if set to 0. Othersize, number of pages to write in addition to writing datapages. This works around corner recovery cases on questionable filesystems.', type='INTEGER', value='0', read_only='N')
(name='recovery_processor_poll_interval_us', description='Recovery processor wakes this often to check workers', type='INTEGER', value='1000', read_only='N')
(name='recovery_processors.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='recovery_processors.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='recovery_processors.linger', description='Thread linger time (in seconds).', type='INTEGER', value='30', read_only='N')
(name='recovery_processors.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='500', read_only='N')
(name='recovery_processors.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='recovery_processors.maxq', description='Maximum size of queue.', type='INTEGER', value='0', read_only='N')
(name='recovery_processors.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='recovery_processors.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='4', read_only='N')
(name='recovery_processors.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='0', read_only='N')
(name='recovery_processors.stacksz', description='Thread stack size.', type='INTEGER', value='1048576', read_only='N')
(name='recovery_verify', description='After recovery, run a full pass to make sure everything is applied', type='BOOLEAN', value='OFF', read_only='N')
(name='recovery_verify_fatal', description='Abort if recovery_verify is set, and fails.', type='BOOLEAN', value='OFF', read_only='N')
(name='recovery_workers.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='recovery_workers.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='recovery_workers.linger', description='Thread linger time (in seconds).', type='INTEGER', value='30', read_only='N')
(name='recovery_workers.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='500', read_only='N')
(name='recovery_workers.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='recovery_workers.maxq', description='Maximum size of queue.', type='INTEGER', value='8000', read_only='N')
(name='recovery_workers.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='recovery_workers.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='16', read_only='N')
(name='recovery_workers.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='0', read_only='N')
(name='recovery_workers.stacksz', description='Thread stack size.', type='INTEGER', value='1048576', read_only='N')
(name='reject_osql_mismatch', description='(Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='reject_writes_on_rtcpu', description='reject_writes_on_rtcpu', type='BOOLEAN', value='ON', read_only='N')
(name='release_locks_trace', description='Print trace if we release locks', type='BOOLEAN', value='OFF', read_only='N')
(name='remove_commitdelay_on_coherent_cluster', description='Stop delaying commits when all the nodes in the cluster are coherent.', type='BOOLEAN', value='ON', read_only='N')
(name='reorder_idx_writes', description='reorder_idx_writes', type='BOOLEAN', value='OFF', read_only='N')
(name='reorder_socksql_no_deadlock', description='Reorder sock sql to have no deadlocks ', type='BOOLEAN', value='OFF', read_only='N')
(name='rep_db_pagesize', description='Page size for BerkeleyDB's replication cache db.', type='INTEGER', value='0', read_only='N')
(name='rep_debug_delay', description='Set an artificial replication delay (used for debugging).', type='INTEGER', value='0', read_only='N')
(name='rep_delay', description='rep_delay', type='BOOLEAN', value='OFF', read_only='N')
(name='rep_longreq', description='Warn if replication events are taking this long to process.', type='INTEGER', value='1', read_only='N')
(name='rep_lsn_chaining', description='If set, will force transactions on replicant to always release locks in LSN order.', type='BOOLEAN', value='OFF', read_only='N')
(name='rep_memsize', description='Maximum size for a local copy of log records for transaction processors on replicants. Larger transactions will read from the log directly.', type='INTEGER', value='524288', read_only='N')
(name='rep_printlock', description='Print locks in rep commit', type='BOOLEAN', value='OFF', read_only='N')
(name='rep_process_pstack_time', description='pstack the server if rep_process runs longer than time specified in secs. To disable set to 0 (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='rep_process_txn_trace', description='If set, report processing time on replicant for all transactions. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='rep_process_warn_time', description='Print trace if rep_process runs longer than time specified in secs (Default: 10s)', type='INTEGER', value='10', read_only='N')
(name='rep_processors', description='Try to apply this many transactions in parallel in the replication stream.', type='INTEGER', value='4', read_only='N')
(name='rep_processors_rowlocks', description='Rowlocks touches 1 file/txn; it's handled by the processor thread.', type='INTEGER', value='0', read_only='N')
(name='rep_skip_phase_3', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='rep_skip_recovery', description='Skip recovery if truncate won't unwind a transaction.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='rep_verify_limit_enabled', description='Enable aborting replicant if it doesn't make sufficient progress while rolling back logs to sync up to master.', type='BOOLEAN', value='ON', read_only='N')
(name='rep_verify_max_time', description='Maximum amount of time we allow a replicant to roll back its logs in an attempt to sync up to the master.', type='INTEGER', value='300', read_only='N')
(name='rep_verify_min_progress', description='Abort replicant if it doesn't make this much progress while rolling back logs to sync up to master.', type='INTEGER', value='10485760', read_only='N')
(name='rep_workers', description='Size of worker pool for applying page changes on behalf of transactions. (only has effect when REP_PROCESSORS is set)', type='INTEGER', value='16', read_only='N')
(name='repalwayswait', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='repchecksum', description='Enable to perform additional checksumming of replication stream. Note: Log records in replication stream already have checksums. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='repdebug', description='Enables replication debug messages.', type='BOOLEAN', value='ON', read_only='Y')
(name='repl_wait', description='Replication wait system enabled for queues', type='BOOLEAN', value='ON', read_only='N')
(name='replicant_latches', description='Also acquire latches on replicants. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='replicant_latency', description='Replicant drops log records.', type='BOOLEAN', value='OFF', read_only='N')
(name='replicant_retry_on_not_durable', description='Replicant retries non-durable writes.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='replicate_local', description='When enabled, record all database events to a comdb2_oplog table. This can be used to set clusters/instances that are fed data from a database cluster. Alternate ways of doing this are being planned, so enabling this option should not be needed in the near future. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='replicate_local_concurrent', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='replicate_rowlocks', description='Replicate rowlocks', type='BOOLEAN', value='ON', read_only='N')
(name='replimit', description='Replication messages will be limited to this size.', type='INTEGER', value='104857600', read_only='N')
(name='repmethodmaxsleep', description='Delay commits by at most this much if forced to delay by incoherent nodes.', type='INTEGER', value='300', read_only='N')
(name='report_deadlock_verbose', description='If set, dump the current thread's stack for every deadlock. (Default: off)', type='BOOLEAN', value='ON', read_only='N')
(name='report_decimal_conversion', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='reproduce_ckp_bug', description='Allow full-recovery ckp-gen to exceed cluster generation.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='repsleep', description='Add a delay on replicants before completing processing a log record.', type='INTEGER', value='0', read_only='N')
(name='reptimeout', description='Replication timeout', type='INTEGER', value='20', read_only='N')
(name='reptimeout_lag', description='Used in replication. Once a node has received our update, we will wait REPTIMEOUT_LAG% of the time that took for all other nodes.', type='INTEGER', value='50', read_only='N')
(name='reptimeout_maxms', description='We should wait this long for one node to acknowledge replication. If after this time we have failed to replicate anywhere then the entire cluster is incoherent!', type='INTEGER', value='300000', read_only='N')
(name='reptimeout_minms', description='Wait at least this many ms for replication to complete on other nodes, before marking them incoherent.', type='INTEGER', value='10000', read_only='N')
(name='repverifyrecs', description='Verify every berkeley log record received', type='BOOLEAN', value='OFF', read_only='N')
(name='reqldiffstat', description='', type='INTEGER', value='60', read_only='Y')
(name='reqltruncate', description='', type='INTEGER', value='0', read_only='Y')
(name='request_durable_lsn_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='requeue_on_tran_dispatch', description='Requeue transactional statement if not enough threads', type='BOOLEAN', value='ON', read_only='N')
(name='reset_deadlock_race', description='reset_deadlock_race', type='BOOLEAN', value='OFF', read_only='N')
(name='retrieve_gen_from_ckp', description='Retrieve generation from ckp records.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='retry', description='', type='INTEGER', value='10', read_only='Y')
(name='return_long_column_names', description='Enables returning of long column names. (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='revsql_force_rte', description='Force reverse sql connections to use rte. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='rl_retry_on_deadlock', description='retry micro commit on deadlock', type='BOOLEAN', value='ON', read_only='N')
(name='rllist_step', description='Reallocate rowlock lists in steps of this size.', type='INTEGER', value='10', read_only='N')
(name='round_robin_stripes', description='Alternate to which table stripe new records are written. The default is to keep stripe affinity by writer. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='rowlocks_commit_on_waiters', description='Don't commit a physical transaction unless there are lock waiters', type='BOOLEAN', value='ON', read_only='N')
(name='rowlocks_deadlock_trace', description='Prints deadlock trace in phys.c', type='BOOLEAN', value='OFF', read_only='N')
(name='rowlocks_micro_commit', description='Commit on every btree operation.', type='BOOLEAN', value='ON', read_only='N')
(name='rowlocks_pagelock_optimization', description='Upgrade rowlocks to pagelocks if possible on cursor traversals.', type='BOOLEAN', value='ON', read_only='N')
(name='sample_queries', description='Sample queries and query plans to table comdb2_sample_queries. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='sbuftimeout', description='', type='INTEGER', value='0', read_only='Y')
(name='sc_async', description='Run transactional schema changes asynchronously.', type='BOOLEAN', value='ON', read_only='N')
(name='sc_async_maxthreads', description='Max number of threads for asynchronous schema changes.', type='INTEGER', value='5', read_only='N')
(name='sc_check_lockwaits_sec', description='Frequency of checking lockwaits during schemachange (in seconds).', type='INTEGER', value='1', read_only='N')
(name='sc_current_version', description='Current schema-change version (Default: SC_VERSION)', type='INTEGER', value='4', read_only='N')
(name='sc_decrease_thrds_on_deadlock', description='Decrease number of schema change threads on deadlock - way to have schema change backoff.', type='BOOLEAN', value='ON', read_only='N')
(name='sc_del_unused_files_threshold', description='', type='INTEGER', value='30000', read_only='Y')
(name='sc_delay_verify_error', description='', type='INTEGER', value='100', read_only='N')
(name='sc_detached', description='Run schema changes in detached mode--just return seed to client.', type='BOOLEAN', value='OFF', read_only='N')
(name='sc_force_delay', description='Force schemachange to delay after every record inserted - to have sc backoff.', type='BOOLEAN', value='OFF', read_only='N')
(name='sc_hist_keep', description='Number of items to keep in llmeta for comdb2_sc_history sys table.', type='INTEGER', value='20', read_only='N')
(name='sc_history_max_rows', description='Max number of rows returned in comdb2_sc_history (Default: 1000)', type='INTEGER', value='1000', read_only='N')
(name='sc_is_at_end', description='Schema-change has converted all records.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='sc_logical_save_lsn_every_n', description='Save schema change redo lsn to llmeta every n-th transactions.', type='INTEGER', value='10', read_only='N')
(name='sc_no_rebuild_thr_sleep', description='Sleep this many microsec when conversion threads count is at max.', type='INTEGER', value='10', read_only='N')
(name='sc_pause_redo', description='Pauses the newsc asychronous redo-thread for testing.', type='BOOLEAN', value='OFF', read_only='N')
(name='sc_protobuf', description='Enable protobuf schema change object (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='sc_restart_sec', description='Delay restarting schema change for this many seconds after startup/new master election.', type='INTEGER', value='0', read_only='N')
(name='sc_resume_autocommit', description='Always resume autocommit schemachange if possible.', type='BOOLEAN', value='ON', read_only='N')
(name='sc_resume_watchdog_timer', description='sc_resuming_watchdog timer', type='INTEGER', value='60', read_only='N')
(name='sc_status_max_rows', description='Max number of rows returned in comdb2_sc_status (Default: 1000)', type='INTEGER', value='1000', read_only='N')
(name='sc_use_num_threads', description='Start up to this many threads for parallel rebuilding during schema change. 0 means use one per dtastripe. Setting is capped at dtastripe.', type='INTEGER', value='0', read_only='N')
(name='sc_via_ddl_only', description='If set, we don't do checks needed for comdb2sc.', type='BOOLEAN', value='OFF', read_only='N')
(name='scatterkeys', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='scconvert_finish_delay', description='Delay returning from convert_record when a stripe finishes. This would create a scenario where scgenids are on the right of any new genids to reproduce a vutf8 schema change bug. ', type='BOOLEAN', value='OFF', read_only='N')
(name='schemachange_perms', description='Check if schema change allowed from source machines', type='BOOLEAN', value='ON', read_only='N')
(name='scpushlogs', description='Push to next log after a schema changes', type='BOOLEAN', value='ON', read_only='N')
(name='scwaittime', description='Network timeout for schema changes.  (Default: 1000)', type='INTEGER', value='1000', read_only='N')
(name='seekscan_maxsteps', description='Overrides the max number of steps for a seekscan optimization', type='INTEGER', value='-1', read_only='N')
(name='seqnum_wait_interval', description='Wake up to check the state of the world this often while waiting for replication ACKs.', type='INTEGER', value='500', read_only='N')
(name='sequence_feature', description='Enables support for SEQUENCES in column definitions (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='serialize_reads_like_writes', description='Send read-only multi-statement schedules to the master.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='set_abort_flag_in_locker', description='', type='BOOLEAN', value='ON', read_only='N')
(name='set_repinfo_master_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='set_snapshot_impl', description='Changes the default snapshot implementation *without enabling snapshot* (default 'modsnap')', type='ENUM', value='MODSNAP', read_only='Y')
(name='sgio_enabled', description='Do scatter gather I/O', type='BOOLEAN', value='OFF', read_only='N')
(name='sgio_max', description='Max scatter gather I/O to do at one time', type='INTEGER', value='10485760', read_only='N')
(name='shadows_nonblocking', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='shalloc_timing', description='Berkeley DB will keep stats on time spent in shallocs and shalloc_frees', type='BOOLEAN', value='ON', read_only='N')
(name='show_cost_in_longreq', description='Show query cost in the database long requests log.', type='BOOLEAN', value='ON', read_only='N')
(name='simulate_find_deadlock', description='simulate_find_deadlock', type='BOOLEAN', value='OFF', read_only='N')
(name='simulate_find_deadlock_retry', description='simulate_find_deadlock_retry', type='BOOLEAN', value='OFF', read_only='N')
(name='simulate_rowlock_deadlock', description='', type='INTEGER', value='0', read_only='N')
(name='simulate_verify_error', description='simulate_verify_error', type='BOOLEAN', value='OFF', read_only='N')
(name='singlemeta', description='', type='INTEGER', value='1', read_only='Y')
(name='skip_cget_in_db_put', description='Don't perform a cget when we do a cput', type='BOOLEAN', value='OFF', read_only='N')
(name='skip_clear_queue_extents', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='skip_duplicate_seqnums', description='skip_duplicate_seqnums', type='BOOLEAN', value='ON', read_only='N')
(name='skip_skipables_on_verify', description='skip_skipables_on_verify', type='BOOLEAN', value='ON', read_only='N')
(name='skip_sync_if_direct', description='Don't fsync files if directio enabled', type='BOOLEAN', value='ON', read_only='N')
(name='skip_table_schema_check', description='skip_table_schema_check', type='BOOLEAN', value='OFF', read_only='N')
(name='skipdelaybase', description='Delay commits by at least this much if forced to delay by incoherent nodes.', type='INTEGER', value='100', read_only='N')
(name='slow_rep_log_get_loop', description='Add latency to the master's log-get loop for testing.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='slow_rep_process_txn_freq', description='', type='INTEGER', value='0', read_only='N')
(name='slow_rep_process_txn_maxms', description='', type='INTEGER', value='0', read_only='N')
(name='slow_rep_process_txn_minms', description='', type='INTEGER', value='0', read_only='N')
(name='slowfget', description='', type='INTEGER', value='0', read_only='Y')
(name='slowread', description='', type='INTEGER', value='0', read_only='Y')
(name='slowrep_inactive_timeout', description='If a 'slow' replicant hasn't responded in this long, mark him incoherent.', type='INTEGER', value='5000', read_only='N')
(name='slowrep_incoherent_factor', description='Make replicants incoherent that are this many times worse than the second worst replicant. This is the threshold for WARN_SLOW_REPLICANTS and MAKE_SLOW_REPLICANTS_INCOHERENT.', type='INTEGER', value='2', read_only='N')
(name='slowrep_incoherent_mintime', description='Ignore replicantion events faster than this.', type='INTEGER', value='2', read_only='N')
(name='slowwrite', description='', type='INTEGER', value='0', read_only='Y')
(name='snapisol', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='snapshot_serial_verify_retry', description='Automatic retries on verify errors for clients that haven't read results.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='sockbplog', description='Enable sending transactions over socket instead of net', type='BOOLEAN', value='OFF', read_only='Y')
(name='sockbplog_sockpool', description='Enable sockpool when for sockbplog feature', type='BOOLEAN', value='OFF', read_only='Y')
(name='sort_nulls_with_header', description='Using record headers in key sorting. (Default: on)', type='BOOLEAN', value='ON', read_only='Y')
(name='sosql_ddl_max_commit_wait_sec', description='Wait for the master to commit a DDL transaction for up to this long.', type='INTEGER', value='259200', read_only='N')
(name='sosql_max_commit_wait_sec', description='Wait for the master to commit a transaction for up to this long.', type='INTEGER', value='600', read_only='N')
(name='sosql_max_deadlock_recovered', description='On replicants, maximum deadlock recovered count allowed.', type='INTEGER', value='100', read_only='N')
(name='sosql_poke_freq_sec', description='On replicants, check this often for transaction status.', type='INTEGER', value='5', read_only='N')
(name='sosql_poke_timeout_sec', description='On replicants, when checking on master for transaction status, retry the check after this many seconds.', type='INTEGER', value='60', read_only='N')
(name='spfile', description='', type='STRING', value=NULL, read_only='Y')
(name='sql_close_sbuf', description='sql_close_sbuf', type='BOOLEAN', value='OFF', read_only='N')
(name='sql_optimize_shadows', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='sql_queueing_critical_trace', description='Produce trace when SQL request queue is this deep.', type='INTEGER', value='100', read_only='N')
(name='sql_queueing_disable_trace', description='Disable trace when SQL requests are starting to queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='sql_recover_time', description='Number of msec before checking if SQL has waiters. 0 will disable. (Default: 10ms)', type='INTEGER', value='10', read_only='N')
(name='sql_release_locks_in_update_shadows', description='Release sql locks in update_shadows on lockwait', type='BOOLEAN', value='ON', read_only='N')
(name='sql_release_locks_on_emit_row_lockwait', description='Release sql locks when we are about to emit a row', type='BOOLEAN', value='OFF', read_only='N')
(name='sql_release_locks_on_si_lockwait', description='Release sql locks from si if the rep thread is waiting', type='BOOLEAN', value='ON', read_only='N')
(name='sql_release_locks_on_slow_reader', description='Release sql locks if a tcp write to the client blocks', type='BOOLEAN', value='ON', read_only='N')
(name='sql_time_threshold', description='Sets the threshold time in ms after which queries are reported as running a long time. (Default: 5000 ms)', type='INTEGER', value='5000', read_only='N')
(name='sql_tranlevel_default', description='Sets the default SQL transaction level for the database.', type='ENUM', value='BLOCKSOCK', read_only='Y')
(name='sqlbulksz', description='For index/data scans, the database will retrieve data in bulk instead of singlestepping a cursor. This sets the buffer size for the bulk retrieval.', type='INTEGER', value='2097152', read_only='N')
(name='sqlenginepool.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='ON', read_only='N')
(name='sqlenginepool.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='sqlenginepool.linger', description='Thread linger time (in seconds).', type='INTEGER', value='30', read_only='N')
(name='sqlenginepool.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='500', read_only='N')
(name='sqlenginepool.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='300000', read_only='N')
(name='sqlenginepool.maxq', description='Maximum size of queue.', type='INTEGER', value='0', read_only='N')
(name='sqlenginepool.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='500', read_only='N')
(name='sqlenginepool.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='48', read_only='N')
(name='sqlenginepool.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='4', read_only='N')
(name='sqlenginepool.stacksz', description='Thread stack size.', type='INTEGER', value='4194304', read_only='N')
(name='sqlite3openserial', description='Serialise calls to sqlite3_open to prevent excess CPU', type='BOOLEAN', value='OFF', read_only='N')
(name='sqlite_makerecord_for_comdb2', description='Enable MakeRecord optimization which converts Mem to comdb2 row data directly', type='BOOLEAN', value='ON', read_only='N')
(name='sqlite_sorter_tempdir_reqfree', description='Refuse to create a sorter for queries if less than this percent of disk space is available (and return an error to the application).', type='INTEGER', value='6', read_only='N')
(name='sqlite_use_temptable_for_rowset', description='Use temptable instead of sqlite's binary search tree, for recording rowids (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='sqlreadahead', description='', type='INTEGER', value='0', read_only='Y')
(name='sqlreadaheadthresh', description='', type='INTEGER', value='0', read_only='Y')
(name='sqlsortermem', description='Maximum amount of memory to be allocated to the sqlite sorter. (Default: 314572800)', type='INTEGER', value='314572800', read_only='N')
(name='sqlsortermult', description='', type='INTEGER', value='1', read_only='N')
(name='sqlsorterpenalty', description='Sets the sorter penalty for query planner to prefer plans without explicit sort (Default: 5)', type='INTEGER', value='5', read_only='N')
(name='stable_rootpages_test', description='Delay sql processing to allow a schema change to finish', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_at_lock_gen_increment', description='Stores stack-id when lock's generation increments.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_at_lock_get', description='Stores stack-id for every lock-get.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_at_lock_handle', description='Stores stack-id for every lock-handle.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_at_page_read', description='Stores stack-id for every page-read.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_at_page_write', description='Stores stack-id for every page-write.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_at_write_lock', description='Stores stack-id for every write-lock.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_disable', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_enable', description='', type='BOOLEAN', value='ON', read_only='N')
(name='stack_on_deadlock', description='stack_on_deadlock', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_string_refs', description='Acquire a cheapstack for every string-ref.  (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='stack_warn_threshold', description='', type='INTEGER', value='50', read_only='Y')
(name='start_recovery_at_dbregs', description='Start recovery at dbregs', type='BOOLEAN', value='ON', read_only='N')
(name='startup_sync_attempts', description='', type='INTEGER', value='5', read_only='N')
(name='stat4_extra_samples', description='', type='INTEGER', value='0', read_only='N')
(name='stat4_samples_multiplier', description='', type='INTEGER', value='0', read_only='N')
(name='static_tag_blob_fix', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='superset_foreign_keys', description='Allow foreign key to be a superset of your key', type='BOOLEAN', value='ON', read_only='N')
(name='support_datetime_in_triggers', description='Enable support for datetime/interval types in triggers', type='BOOLEAN', value='ON', read_only='N')
(name='support_datetimes', description='support_datetimes', type='BOOLEAN', value='ON', read_only='N')
(name='support_sock_luxref', description='support proxy socket request with a set luxref', type='BOOLEAN', value='ON', read_only='N')
(name='surprise', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='survive_n_master_swings', description='Have a node retry applying a transaction against a new master this many times before giving up. (Default: 600)', type='INTEGER', value='600', read_only='Y')
(name='sync_standalone', description='Force a log-sync at commit for standalone instances', type='BOOLEAN', value='OFF', read_only='N')
(name='synctransactions', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='tablescan_cache_utilization', description='Attempt to keep no more than this percentage of the buffer pool for table scans.', type='INTEGER', value='20', read_only='N')
(name='temptable_cachesz', description='Cache size for temporary tables. Temp tables do not share the database's main buffer pool.', type='INTEGER', value='262144', read_only='N')
(name='temptable_limit', description='Set the maximum number of temporary tables the database can create. (Default: 8192)', type='INTEGER', value='8192', read_only='Y')
(name='temptable_mem_threshold', description='If in-memory temp tables contain more than this many entries, spill them to disk.', type='INTEGER', value='512', read_only='N')
(name='temptable_recreate_size', description='Sets temptable re-create size threshold.  (Default: 1048576).', type='INTEGER', value='1048576', read_only='N')
(name='test_auth_time', description='Check auth in watchdog this often', type='INTEGER', value='60', read_only='N')
(name='test_blkseq_replay', description='Test blkseq replay codepath (for debugging only)', type='BOOLEAN', value='OFF', read_only='N')
(name='test_blob_race', description='', type='INTEGER', value='0', read_only='Y')
(name='test_curtran_change', description='Test change-curtran codepath (for debugging only)', type='BOOLEAN', value='OFF', read_only='N')
(name='test_ddl_backout_blkseq', description='Force a blkseq error in toblock.', type='BOOLEAN', value='OFF', read_only='N')
(name='test_ddl_backout_deadlock', description='Force a deadlock in toblock.', type='BOOLEAN', value='OFF', read_only='N')
(name='test_ddl_backout_nomaster', description='Force a NOMASTER error in toblock.', type='BOOLEAN', value='OFF', read_only='N')
(name='test_delay_analyze_commit', description='Delay analyze commit', type='BOOLEAN', value='OFF', read_only='N')
(name='test_io_time', description='Check I/O in watchdog this often', type='INTEGER', value='10', read_only='N')
(name='test_sc_resume_race', description='Test race between schemachange resume and blockprocessor', type='BOOLEAN', value='OFF', read_only='Y')
(name='test_scindex_deadlock', description='Test index on expressions schema change deadlock', type='BOOLEAN', value='OFF', read_only='Y')
(name='test_sql_time', description='Check SQL in watchdog this often', type='INTEGER', value='0', read_only='N')
(name='test_sync_osql_cancel', description='Force a delay in osql_sess_rcvop test synchronous osql cancel', type='BOOLEAN', value='OFF', read_only='N')
(name='test_tunable_int64_limit', description='', type='INT64', value='9223372036854775807', read_only='N')
(name='test_tunable_int64_signed_limit', description='', type='INT64', value='9223372036854775807', read_only='N')
(name='test_tunable_int_limit', description='', type='INTEGER', value='2147483647', read_only='N')
(name='test_tunable_int_signed_limit', description='', type='INTEGER', value='2147483647', read_only='N')
(name='test_tunable_nozero', description='', type='INTEGER', value='1', read_only='N')
(name='thread_stats', description='Berkeley DB will keep stats on what its threads are doing', type='BOOLEAN', value='ON', read_only='N')
(name='throttle_txn_chunks_msec', description='Wait that many milliseconds before starting a new chunk  (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='throttlesqloverlog', description='On a full queue of SQL requests, dump the current thread pool this often (in secs). (Default: 5sec)', type='INTEGER', value='5', read_only='Y')
(name='timeout_fdb_trans_sync', description='Timeout for retrieving a foreign table transaction', type='INTEGER', value='4000', read_only='N')
(name='timeout_server_sockpool', description='Timeout for getting a connection to another database from sockpool.', type='INTEGER', value='10', read_only='N')
(name='timepart_abort_on_preperror', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='timepart_no_rollout', description='Prevent new rollouts for time partitions.', type='BOOLEAN', value='OFF', read_only='N')
(name='timepartitions', description='', type='STRING', value=NULL, read_only='Y')
(name='timeseries_metrics', description='Keep time series data for some metrics', type='BOOLEAN', value='ON', read_only='N')
(name='timeseries_metrics_maxage', description='Time to keep metrics in memory (seconds)', type='INTEGER', value='30', read_only='N')
(name='timeseries_metrics_maxpoints', description='Maximum data points to keep in memory for various metrics', type='INTEGER', value='10000', read_only='N')
(name='toomanyskipped', description='Call for election again and delay commits if more than this many nodes are incoherent.', type='INTEGER', value='2', read_only='N')
(name='track_berk_locks', description='', type='INTEGER', value='0', read_only='Y')
(name='track_curtran_locks', description='Print curtran lockinfo', type='BOOLEAN', value='OFF', read_only='N')
(name='track_queue_time', description='Track time sql requests spend on queue', type='BOOLEAN', value='ON', read_only='N')
(name='track_replication_times', description='Track how long each replicant takes to ack all transactions.', type='BOOLEAN', value='ON', read_only='N')
(name='track_replication_times_max_lsns', description='Track replication times for up to this many transactions.', type='INTEGER', value='50', read_only='N')
(name='tracked_locklist_init', description='Initial allocation count for tracked locks', type='INTEGER', value='10', read_only='N')
(name='tranlog_default_timeout', description='Default timeout for tranlog queries.  (Default: 30)', type='INTEGER', value='30', read_only='N')
(name='tranlog_incoherent_timeout', description='Timeout in seconds for incoherent tranlog. (Default: 10)', type='INTEGER', value='10', read_only='N')
(name='tranlog_maxpoll', description='Tranlog timeout in seconds for blocking poll. (Default: 60)', type='INTEGER', value='60', read_only='N')
(name='transaction_grace_period', description='Time to wait for connections with pending transactions to go away on exit. (Default: 60)', type='INTEGER', value='60', read_only='N')
(name='transactional_drop_plus_rename', description='Allow dropping a table and then renaming a table to have the same name as the dropped table in a transaction (default on)', type='BOOLEAN', value='ON', read_only='N')
(name='transient_page_reallocation', description='Orphaned pages are maintained locally', type='BOOLEAN', value='OFF', read_only='N')
(name='typessql', description='Use typessql to attempt to buffer results until all columns are non-null. (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='typessql_records_max', description='The maximum number of records for typessql to buffer and find non-null types before giving up. (Default: 1000)', type='INTEGER', value='1000', read_only='N')
(name='udp', description='', type='BOOLEAN', value='ON', read_only='N')
(name='udp_average_over_epochs', description='Average over these many TCP epochs.', type='INTEGER', value='4', read_only='N')
(name='udp_drop_delta_threshold', description='Warn if delta of dropped packets exceeds this threshold.', type='INTEGER', value='10', read_only='N')
(name='udp_drop_warn_percent', description='Warn only if percentage of dropped packets exceeds this.', type='INTEGER', value='10', read_only='N')
(name='udp_drop_warn_time', description='Print no more than one warning per UDP_DROP_WARN_TIME seconds.', type='INTEGER', value='300', read_only='N')
(name='udppfaultpool.dump_on_full', description='Dump status on full queue.', type='BOOLEAN', value='OFF', read_only='N')
(name='udppfaultpool.exit_on_error', description='Exit on pthread error.', type='BOOLEAN', value='ON', read_only='N')
(name='udppfaultpool.linger', description='Thread linger time (in seconds).', type='INTEGER', value='10', read_only='N')
(name='udppfaultpool.longwait', description='Long wait alarm threshold (in milliseconds).', type='INTEGER', value='10000', read_only='N')
(name='udppfaultpool.maxagems', description='Maximum age for in-queue time (in milliseconds).', type='INTEGER', value='0', read_only='N')
(name='udppfaultpool.maxq', description='Maximum size of queue.', type='INTEGER', value='1000', read_only='N')
(name='udppfaultpool.maxqover', description='Maximum client forced queued items above maxq.', type='INTEGER', value='0', read_only='N')
(name='udppfaultpool.maxt', description='Maximum number of threads in the pool.', type='INTEGER', value='8', read_only='N')
(name='udppfaultpool.mint', description='Minimum number of threads in the pool.', type='INTEGER', value='0', read_only='N')
(name='udppfaultpool.stacksz', description='Thread stack size.', type='INTEGER', value='1048576', read_only='N')
(name='unlimited_datetime_range', description='unlimited_datetime_range', type='BOOLEAN', value='OFF', read_only='N')
(name='unnatural_types', description='Same as 'surprise'', type='BOOLEAN', value='ON', read_only='Y')
(name='upd_null_cstr_return_conv_err', description='', type='INTEGER', value='0', read_only='Y')
(name='update_delete_limit', description='', type='BOOLEAN', value='ON', read_only='Y')
(name='update_shadows_interval', description='Set to higher than 0 to update snaphots on every Nth operation. (Default: 0, update on for every operation)', type='INTEGER', value='0', read_only='N')
(name='update_startlsn_printstep', description='Print steps walked in update_startlsn code', type='BOOLEAN', value='OFF', read_only='N')
(name='updategenids', description='Enable use of update genid scheme. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='use_blackout_list', description='use_blackout_list', type='BOOLEAN', value='ON', read_only='N')
(name='use_blkseq', description='Enable blkseq', type='BOOLEAN', value='ON', read_only='N')
(name='use_fastseed_for_comdb2_seqno', description='Use fastseed instead of context for comdb2_seqno unique values', type='BOOLEAN', value='OFF', read_only='N')
(name='use_live_schema_change', description='', type='INTEGER', value='1', read_only='Y')
(name='use_node_priority', description='Sets node priority for the db. (Default: off)', type='BOOLEAN', value='OFF', read_only='Y')
(name='use_nondedicated_network', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='use_planned_schema_change', description='Only change entities that need to change on a schema change. Disable to always rebuild all data files and indices for the changing table. (Default: 1)', type='INTEGER', value='1', read_only='Y')
(name='use_recovery_start_for_log_deletion', description='', type='BOOLEAN', value='ON', read_only='N')
(name='use_vtag_ondisk_vermap', description='Use vtag_to_ondisk_vermap conversion function from vtag_to_ondisk.', type='BOOLEAN', value='ON', read_only='N')
(name='usenames', description='', type='BOOLEAN', value='OFF', read_only='Y')
(name='utxnid_log', description='Generate utxnid logs. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='verbose_cursor_deadlocks', description='verbose_cursor_deadlocks', type='BOOLEAN', value='OFF', read_only='N')
(name='verbose_deadlocks', description='verbose_deadlocks', type='BOOLEAN', value='OFF', read_only='N')
(name='verbose_deadlocks_log', description='verbose_deadlocks_log', type='BOOLEAN', value='OFF', read_only='N')
(name='verbose_fix_pinref', description='verbose_fix_pinref', type='BOOLEAN', value='ON', read_only='N')
(name='verbose_net', description='Net prints lots of messages', type='BOOLEAN', value='OFF', read_only='N')
(name='verbose_normalized_queries', description='For new fingerprints, show normalized queries.', type='BOOLEAN', value='OFF', read_only='N')
(name='verbose_sbuf', description='verbose_sbuf', type='BOOLEAN', value='ON', read_only='N')
(name='verbose_toblock_backouts', description='print verbose toblock backout trace', type='BOOLEAN', value='OFF', read_only='N')
(name='verbose_waiter_flag', description='Print trace setting the waiter flag in lock code', type='BOOLEAN', value='OFF', read_only='N')
(name='verify_all_pools', description='verify objects are returned to the correct pools', type='BOOLEAN', value='OFF', read_only='N')
(name='verify_dbreg', description='Periodically check if dbreg entries are correct', type='BOOLEAN', value='OFF', read_only='N')
(name='verify_default_function', description='Verify default function at schema-change.  (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='verify_directio', description='Run expensive checks on directio calls', type='BOOLEAN', value='OFF', read_only='N')
(name='verify_master_lease_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='verify_pool_maxt', description='Max Number of verify threads in the thrd pool.', type='INTEGER', value='8', read_only='N')
(name='verify_thread_stacksz', description='Size of the verify thread stack.', type='INTEGER', value='2097152', read_only='N')
(name='verifycheckpoints', description='Highly paranoid checkpoint validity checks', type='BOOLEAN', value='OFF', read_only='N')
(name='verifylsn', description='Verify if LSN written before writing page', type='BOOLEAN', value='OFF', read_only='N')
(name='version_spfile', description='', type='STRING', value=NULL, read_only='Y')
(name='view_feature', description='Enables support for VIEWs (Default: ON)', type='BOOLEAN', value='ON', read_only='N')
(name='views_dft_preempt_roll_secs', description='Amount of seconds to run phase 1 of time partition rollout before phase 2', type='INTEGER', value='1800', read_only='N')
(name='views_dft_roll_delete_lag_secs', description='Amount of seconds to run phase 3 of time partition rollout after phase 2', type='INTEGER', value='5', read_only='N')
(name='wait_for_prepare_seqnum', description='Wait-for-seqnum for prepare records. (Default: on)', type='BOOLEAN', value='ON', read_only='N')
(name='wait_for_seqnum_trace', description='', type='BOOLEAN', value='OFF', read_only='N')
(name='wal_osync', description='Open WAL files using the O_SYNC flag (Default: off)', type='BOOLEAN', value='OFF', read_only='N')
(name='warn_cstr', description='Warn on validation of cstrings', type='BOOLEAN', value='ON', read_only='N')
(name='warn_nondbreg_records', description='warn on non-dbreg records before checkpoint', type='BOOLEAN', value='OFF', read_only='N')
(name='warn_on_replicant_log_write', description='Warn if replicant is writing to logs', type='BOOLEAN', value='ON', read_only='N')
(name='warn_slow_replicants', description='Warn if any replicant's average response times over the last 10 seconds are significantly worse than the second worst replicant's.', type='BOOLEAN', value='ON', read_only='N')
(name='warn_wr_logbytes_per_txn', description='Set warning threshold for log-bytes written in a transaction.  (Default: 0)', type='INT64', value='536870912', read_only='N')
(name='watchthreshold', description='Panic if node has been unhealthy (unresponsive, out of resources, etc.) for more than this many seconds. The default value is 60.', type='INTEGER', value='60', read_only='N')
(name='written_rows_warn', description='Set warning threshold for rows written in a transaction.  (Default: 0)', type='INTEGER', value='0', read_only='N')
(name='zliblevel', description='If zlib compression is enabled, this determines the compression level.', type='INTEGER', value='6', read_only='N')
(name='ztrace', description='', type='BOOLEAN', value='OFF', read_only='N')