万里数据库greatdb全量动态系统变量

原创 Dbb 2024-05-16

197

全量动态系统变量包括MySQL自身的动态系统变量和GreatDB增加的动态系统变量，如下：

其中scope列中的Both代表该系统变量支持Global和Session两种设置方式。

变量归属列中的innodb代表该变量是MySQL自身的系统变量，greatdb代表该变量是在后续新加入的变量。

变量属性列中的暂不能改代表修改该系统变量可能导致集群不可用或者出现异常，因此不要修改该变量的值。

name	type	scope	变量归属	变量属性
activate_all_roles_on_login	Bool	Global	innodb	暂用不到
authentication_policy	Str	Global	innodb	暂不能改
auto_increment_increment	Int	Both	innodb	可动态改
auto_increment_offset	Int	Both	innodb	可动态改
automatic_sp_privileges	Bool	Global	innodb	暂不能改
avoid_temporal_upgrade	Bool	Global	innodb	暂不能改
big_tables	Bool	Both	innodb	暂不能改
binlog_cache_size	Int	Global	innodb	可动态改
binlog_ddl_skip_rewrite	Bool	Both	innodb	可动态改
binlog_direct_non_transactional_updates	Bool	Both	innodb	可动态改
binlog_error_action	Enum	Global	innodb	可动态改
binlog_expire_logs_auto_purge	Bool	Global	innodb	可动态改
binlog_expire_logs_seconds	Int	Global	innodb	可动态改
binlog_format (集群只支持ROW格式)	Enum	Both	innodb	暂不能改
binlog_group_commit_sync_delay	Int	Global	innodb	可动态改
binlog_group_commit_sync_no_delay_count	Int	Global	innodb	可动态改
binlog_max_flush_queue_time	Int	Global	innodb	可动态改
binlog_order_commits	Bool	Global	innodb	可动态改
binlog_row_image (使用binlog server时，必须为full)	Enum	Both	innodb	可动态改
binlog_row_metadata	Enum	Global	innodb	可动态改
binlog_row_value_options	Set	Both	innodb	可动态改
binlog_rows_query_log_events	Bool	Both	innodb	可动态改
binlog_skip_flush_commands	Bool	Global	innodb	可动态改
binlog_stmt_cache_size	Int	Global	innodb	可动态改
binlog_transaction_compression	Bool	Both	innodb	基本不改
binlog_transaction_compression_level_zstd	Int	Both	innodb	基本不改
binlog_transaction_dependency_history_size	Int	Global	innodb	可动态改
binlog_transaction_dependency_tracking	Enum	Global	innodb	可动态改
block_encryption_mode	Enum	Both	innodb	可动态改
buffered_error_log_filename	Str	Global	innodb	可动态改
buffered_error_log_size	Int	Global	innodb	可动态改
bulk_insert_buffer_size	Int	Both	innodb	可动态改
check_proxy_users	Bool	Global	innodb	暂用不到
clone_autotune_concurrency	Bool	Global	innodb	可动态改
clone_block_ddl	Bool	Global	innodb	可动态改
clone_buffer_size	Int	Global	innodb	可动态改
clone_ddl_timeout	Int	Global	innodb	可动态改
clone_delay_after_data_drop	Int	Global	innodb	可动态改
clone_disable_pfs (仅备份节点设置为on)	Bool	Both	greatdb	基本不改
clone_donor_timeout_after_network_failure	Int	Global	innodb	可动态改
clone_enable_compression	Bool	Global	innodb	可动态改
clone_max_concurrency	Int	Global	innodb	可动态改
clone_max_data_bandwidth	Int	Global	innodb	可动态改
clone_max_network_bandwidth	Int	Global	innodb	可动态改
clone_ssl_ca	File name	Global	innodb	可动态改
clone_ssl_cert	File name	Global	innodb	可动态改
clone_ssl_key	File name	Global	innodb	可动态改
clone_valid_donor_list	Str	Global	innodb	可动态改
completion_type	Enum	Both	innodb	可动态改
concurrent_insert 仅限MyISAM表	Enum	Global	innodb	可动态改
(connect_timeout)	Int	Global	innodb	可动态改
connection_memory_chunk_size	Int	Both	innodb	可动态改
connection_memory_limit	Int	Both	innodb	可动态改
cte_max_recursion_depth	Int	Both	innodb	可动态改
dblink_maxreturn_rows	Int	Both	innodb	暂用不到
debug	Str	Both	innodb	暂用不到
debug_sensitive_session_string	Str	Both	innodb	暂用不到
default_password_lifetime	Int	Global	innodb	暂不能改
default_table_encryption	Bool	Both	innodb	暂不能改
default_week_format	Int	Both	innodb	暂不能改
delay_key_write	Enum	Global	innodb	暂不能改
delayed_insert_limit	Int	Global	innodb	暂不能改
delayed_insert_timeout	Int	Global	innodb	暂不能改
delayed_queue_size	Int	Global	innodb	暂不能改
div_precision_increment	Int	Both	innodb	可动态改
end_markers_in_json	Bool	Both	innodb	暂不能改
eq_range_index_dive_limit	Int	Both	innodb	可动态改
event_scheduler	Enum	Global	innodb	基本不改
expand_fast_index_creation	Bool	Both	innodb	可动态改
expire_logs_days	Int	Global	innodb	可动态改
explicit_defaults_for_timestamp	Bool	Both	innodb	暂不能改
flush	Bool	Global	innodb	暂不能改
flush_time	Int	Global	innodb	暂不能改
ft_Bool_syntax	Str	Global	innodb	暂用不到
ft_query_extra_word_chars	Bool	Both	innodb	暂用不到
gdb_add_network_cost	Bool	Both	greatdb	可动态改
gdb_binlog_server_slave_mode	Bool	Both	greatdb	可动态改
gdb_cluster_ddl_metalock	Bool	Both	greatdb	可动态改
gdb_ddl_id	Int	Both	greatdb	暂不能改
gdb_ddl_rollback_mode	Bool	Both	greatdb	可动态改
gdb_ddl_sum	Int	Both	greatdb	暂不能改
gdb_direct_processing	Bool	Both	greatdb	可动态改
gdb_direct_pushdown_time_funcs	Bool	Both	greatdb	可动态改
gdb_enable_xplan	Bool	Both	greatdb	可动态改
gdb_handler_enable_plan	Bool	Both	greatdb	可动态改
gdb_sequence_force_frontend (binlog server节点同步到单机时为on)	Bool	Global	server	可动态改
gdb_strict_create_table	Bool	Both	greatdb	可动态改
gdb_table_dtm_enabled	Bool	Both	greatdb	已删除
gdb_xplan_enable_multi_shards	Bool	Both	greatdb	可动态改
gdb_zone_name	Str	Global	greatdb	暂不能改
general_log	Bool	Global	innodb	可动态改
general_log_file	Str	Global	innodb	可动态改
generated_random_password_length	Int	Both	innodb	可动态改
global_connection_memory_limit	Int	Global	innodb	可动态改
global_connection_memory_tracking	Bool	Both	innodb	可动态改
greatdb_auto_partition_num	Int	Global	greatdb	可动态改
greatdb_backend_table_engine	Str	Both	greatdb	暂不能改
greatdb_change_primary_datanode_delay_threshold	Int	Both	greatdb	可动态改
greatdb_connect_timeout	Int	Global	greatdb	可动态改
greatdb_connection_keepalive_user_timeout	Int	Global	greatdb	可动态改
greatdb_ddl_lock_backend_wait_timeout	Int	Both	greatdb	可动态改
greatdb_deadlock_detection_period	Int	Global	greatdb	可动态改
greatdb_deadlock_detection_record_in_log	Bool	Global	greatdb	可动态改
greatdb_debug_method	Str	Both	greatdb	暂用不到
greatdb_enable_deadlock_detection	Bool	Global	greatdb	可动态改
greatdb_enable_dml_acquire_dtm_readview	Bool	Global	greatdb	可动态改
greatdb_enable_profile	Bool	Both	greatdb	可动态改
greatdb_enable_purge_dtm_xa_log	Bool	Global	greatdb	可动态改
greatdb_exit_state_action	Int	Global	greatdb	可动态改
greatdb_implicit_rollback_error_trx	Bool	Global	greatdb	可动态改
greatdb_inject_sqlnode_info	Bool	Both	greatdb	可动态改
greatdb_is_restore_binlog_applier	Bool	Both	greatdb	可动态改
greatdb_max_connections	Int	Global	greatdb	可动态改
greatdb_new_datanode_clone_threshold	Int	Both	greatdb	可动态改
greatdb_new_sqlnode_clone_threshold	Int	Both	greatdb	可动态改
greatdb_node_time_diff_limit	Int	Global	greatdb	可动态改
greatdb_optimize_direct_delete	Bool	Both	greatdb	可动态改
greatdb_optimize_direct_update	Bool	Both	greatdb	可动态改
greatdb_optimize_multi_recs_update	Bool	Both	greatdb	可动态改
greatdb_parallel_read_threads	Int	Both	greatdb	可动态改
greatdb_physical_migrate_table	Bool	Both	greatdb	可动态改
greatdb_physical_migrate_table_mode	Enum	Both	greatdb	可动态改
greatdb_print_dtm_debug_info	Bool	Global	greatdb	可动态改
greatdb_records_in_range_from_dn	Bool	Both	greatdb	可动态改
greatdb_records_in_range_max_partitions	Int	Both	greatdb	可动态改
greatdb_result_cache_batch_cnt	Int	Global	greatdb	可动态改
greatdb_result_cache_size	Int	Global	greatdb	可动态改
greatdb_rnd_pos_probe	Bool	Global	greatdb	可动态改
greatdb_table_cache_size	Int	Global	greatdb	可动态改
greatdb_table_shard_group	Str	Both	greatdb	可动态改
greatdb_use_normal_transaction	Bool	Both	greatdb	可动态改
greatdb_wait_non_running_xa_trx_before_dtm_start	Bool	Global	greatdb	可动态改
greatdb_xa_recover_interval	Int	Global	greatdb	可动态改
group_concat_max_len	Int	Both	innodb	可动态改
group_replication_consistency	Int	Both	innodb	可动态改
group_replication_force_members	Int	Global	innodb	可动态改
gtid_executed_compression_period	Int	Global	innodb	可动态改
histogram_generation_max_mem_size	Int	Both	innodb	可动态改
host_cache_size	Int	Global	innodb	可动态改
import_tablespace_remove_meta_file_mode	Bool	Both	greatdb	可动态改
information_schema_stats_expiry	Int	Both	innodb	可动态改
init_connect	Str	Global	innodb	可动态改
init_replica	Str	Global	innodb	可动态改
init_slave	Str	Global	innodb	可动态改
innodb_adaptive_flushing	Bool	Global	innodb	可动态改
innodb_adaptive_flushing_lwm	Int	Global	innodb	可动态改
innodb_adaptive_hash_index	Bool	Global	innodb	可动态改
innodb_adaptive_max_sleep_delay	Int	Global	innodb	可动态改
innodb_api_bk_commit_interval	Int	Global	innodb	可动态改
innodb_api_trx_level	Int	Global	innodb	可动态改
innodb_autoextend_increment	Int	Global	innodb	可动态改
innodb_background_drop_list_empty	Bool	Global	innodb	可动态改
innodb_buf_flush_list_now	Int	Global	innodb	可动态改
innodb_buffer_pool_dump_at_shutdown	Bool	Global	innodb	可动态改
innodb_buffer_pool_dump_now	Bool	Global	innodb	可动态改
innodb_buffer_pool_dump_pct	Int	Global	innodb	可动态改
innodb_buffer_pool_evict	Int	Global	innodb	可动态改
innodb_buffer_pool_filename	File name	Global	innodb	可动态改
innodb_buffer_pool_in_core_file	Bool	Global	innodb	可动态改
innodb_buffer_pool_load_abort	Bool	Global	innodb	可动态改
innodb_buffer_pool_load_now	Bool	Global	innodb	可动态改
innodb_change_buffer_max_size	Int	Global	innodb	可动态改
innodb_change_buffering	Enum	Global	innodb	可动态改
innodb_change_buffering_debug	Int	Global	innodb	可动态改
innodb_checkpoint_disabled	Bool	Global	innodb	可动态改
innodb_checksum_algorithm	Enum	Global	innodb	可动态改
innodb_cleaner_lsn_age_factor	Int	Global	innodb	可动态改
innodb_cleaner_max_flush_time	Int	Global	innodb	可动态改
innodb_cleaner_max_lru_time	Int	Global	innodb	可动态改
innodb_cmp_per_index_enabled	Bool	Global	innodb	可动态改
innodb_commit_concurrency	Int	Global	innodb	可动态改
innodb_compress_debug	Enum	Global	innodb	可动态改
innodb_compressed_columns_threshold	Int	Global	innodb	基本不改
innodb_compressed_columns_zip_level	Int	Global	innodb	基本不改
innodb_compression_failure_threshold_pct	Int	Global	innodb	基本不改
innodb_compression_level	Int	Global	innodb	基本不改
innodb_compression_pad_pct_max	Int	Global	innodb	可动态改
innodb_concurrency_tickets	Int	Global	innodb	可动态改
innodb_corrupt_table_action	Int	Global	innodb	可动态改
innodb_ddl_buffer_size	Int	Both	innodb	可动态改
innodb_ddl_log_crash_reset_debug	Bool	Global	innodb	可动态改
innodb_ddl_threads	Int	Both	innodb	可动态改
innodb_deadlock_detect	Bool	Global	innodb	可动态改
innodb_default_encryption_key_id	Int	Both	innodb	可动态改
innodb_default_row_format	Enum	Global	innodb	基本不改
innodb_dict_stats_disabled_debug	Int	Global	innodb	可动态改
innodb_disable_background_merge	Int	Global	innodb	可动态改
innodb_disable_sort_file_cache	Bool	Global	innodb	可动态改
innodb_doublewrite	Enum	Global	innodb	可动态改
innodb_empty_free_list_algorithm	Int	Global	innodb	可动态改
innodb_encryption_rotate_key_age	Int	Global	innodb	可动态改
innodb_encryption_rotation_iops	Int	Global	innodb	可动态改
innodb_encryption_threads	Int	Global	innodb	可动态改
innodb_extend_and_initialize	Bool	Global	innodb	可动态改
innodb_fast_shutdown	Int	Global	innodb	可动态改
innodb_fil_make_page_dirty_debug	Int	Global	innodb	可动态改
innodb_file_per_table	Bool	Global	innodb	可动态改
innodb_fill_factor	Int	Global	innodb	可动态改
innodb_flush_log_at_timeout	Int	Global	innodb	可动态改
innodb_flush_log_at_trx_commit	Enum	Global	innodb	可动态改
innodb_flush_neighbors	Enum	Global	innodb	可动态改
innodb_flush_sync	Bool	Global	innodb	可动态改
innodb_flushing_avg_loops	Int	Global	innodb	可动态改
innodb_force_index_records_in_range	Int	Both	innodb	可动态改
innodb_fsync_threshold	Int	Global	innodb	可动态改
innodb_ft_aux_table	Str	Global	innodb	可动态改
innodb_ft_enable_diag_print	Bool	Global	innodb	可动态改
innodb_ft_enable_stopword	Bool	Both	innodb	可动态改
innodb_ft_ignore_stopwords	Int	Both	innodb	可动态改
innodb_ft_num_word_optimize	Int	Global	innodb	可动态改
innodb_ft_result_cache_limit	Int	Global	innodb	可动态改
innodb_ft_server_stopword_table	Str	Global	innodb	可动态改
innodb_ft_user_stopword_table	Str	Both	innodb	可动态改
innodb_idle_flush_pct	Int	Global	innodb	可动态改
innodb_interpreter	Int	Both	innodb	可动态改
innodb_interpreter_output	Int	Both	innodb	可动态改
innodb_io_capacity	Int	Global	innodb	可动态改
innodb_io_capacity_max	Int	Global	innodb	可动态改
innodb_limit_optimistic_insert_debug	Int	Global	innodb	暂用不到
innodb_lock_wait_timeout	Int	Both	innodb	可动态改
innodb_log_buffer_size	Int	Global	innodb	可动态改
innodb_log_checkpoint_fuzzy_now	Bool	Global	innodb	可动态改
innodb_log_checkpoint_now	Bool	Global	innodb	可动态改
innodb_log_checksums	Bool	Global	innodb	可动态改
innodb_log_compressed_pages	Bool	Global	innodb	可动态改
innodb_log_flush_now	Int	Global	innodb	可动态改
innodb_log_spin_cpu_abs_lwm	Int	Global	innodb	可动态改
innodb_log_spin_cpu_pct_hwm	Int	Global	innodb	可动态改
innodb_log_wait_for_flush_spin_hwm	Int	Global	innodb	可动态改
innodb_log_write_ahead_size	Int	Global	innodb	可动态改
innodb_log_writer_threads	Bool	Global	innodb	可动态改
innodb_lru_scan_depth	Int	Global	innodb	可动态改
innodb_master_thread_disabled_debug	Int	Global	innodb	可动态改
innodb_max_dirty_pages_pct	Float	Global	innodb	可动态改
innodb_max_dirty_pages_pct_lwm	Float	Global	innodb	可动态改
innodb_max_purge_lag	Int	Global	innodb	可动态改
innodb_max_purge_lag_delay	Int	Global	innodb	可动态改
innodb_max_undo_log_size	Int	Global	innodb	可动态改
innodb_merge_threshold_set_all_debug	Int	Global	innodb	暂用不到
innodb_monitor_disable	Str	Global	innodb	可动态改
innodb_monitor_enable	Str	Global	innodb	可动态改
innodb_monitor_reset	Enum	Global	innodb	可动态改
innodb_monitor_reset_all	Enum	Global	innodb	可动态改
innodb_optimize_no_pk_parallel_load	Bool	Both	greatdb	可动态改
innodb_old_blocks_pct	Int	Global	innodb	可动态改
innodb_old_blocks_time	Int	Global	innodb	可动态改
innodb_online_alter_log_max_size	Int	Global	innodb	可动态改
innodb_optimize_fulltext_only	Bool	Global	innodb	可动态改
innodb_page_cleaner_disabled_debug	Int	Global	innodb	暂用不到
innodb_parallel_dblwr_encrypt	Int	Global	innodb	可动态改
innodb_parallel_read_threads	Int	Both	innodb	可动态改
innodb_print_all_deadlocks	Bool	Global	innodb	可动态改
innodb_print_ddl_logs	Bool	Global	innodb	可动态改
innodb_print_lock_wait_timeout_info	Int	Global	innodb	可动态改
innodb_priority_master	Int	Global	innodb	可动态改
innodb_priority_purge	Int	Global	innodb	可动态改
innodb_purge_batch_size	Int	Global	innodb	可动态改
innodb_purge_rseg_truncate_frequency	Int	Global	innodb	可动态改
innodb_purge_run_now	Int	Global	innodb	可动态改
innodb_purge_stop_now	Int	Global	innodb	可动态改
innodb_random_read_ahead	Bool	Global	innodb	可动态改
innodb_read_ahead_threshold	Int	Global	innodb	可动态改
innodb_records_in_range	Int	Both	innodb	可动态改
innodb_redo_log_archive_dirs	Str	Global	innodb	可动态改
innodb_redo_log_encrypt	Bool	Global	innodb	可动态改
innodb_remove_tmp_dup_space_id	Bool	Global	greatdb	可动态改
innodb_replication_delay	Int	Global	innodb	可动态改
innodb_rollback_segments	Int	Global	innodb	可动态改
innodb_saved_page_number_debug	Int	Global	innodb	可动态改
innodb_sched_priority_io	Int	Global	innodb	可动态改
innodb_sched_priority_master	Int	Global	innodb	可动态改
innodb_sched_priority_purge	Int	Global	innodb	可动态改
innodb_sched_priority_pc	Int	Global	innodb	不可动态改
innodb_sched_priority_lru_flush	Int	Global	innodb	不可动态改
innodb_segment_reserve_factor	Float	Global	innodb	可动态改
innodb_semaphore_wait_timeout_debug	Int	Global	innodb	可动态改
innodb_show_locks_held	Int	Global	innodb	可动态改
innodb_spin_wait_delay	Int	Global	innodb	可动态改
innodb_spin_wait_pause_multiplier	Int	Global	innodb	可动态改
innodb_stats_auto_recalc	Bool	Global	innodb	可动态改
innodb_stats_include_delete_marked	Bool	Global	innodb	可动态改
innodb_stats_method	Enum	Global	innodb	可动态改
innodb_stats_on_metadata	Bool	Global	innodb	可动态改
innodb_stats_persistent	Bool	Global	innodb	可动态改
innodb_stats_persistent_sample_pages	Int	Global	innodb	可动态改
innodb_stats_transient_sample_pages	Int	Global	innodb	可动态改
innodb_status_output	Bool	Global	innodb	可动态改
innodb_status_output_locks	Bool	Global	innodb	可动态改
innodb_strict_mode	Bool	Both	innodb	可动态改
innodb_sync_spin_loops	Int	Global	innodb	可动态改
innodb_sys_tablespace_encrypt	Int	Global	innodb	可动态改
innodb_table_locks	Bool	Both	innodb	可动态改
innodb_temp_tablespace_encrypt	Int	Global	innodb	暂用不到
innodb_thread_concurrency	Int	Global	innodb	可动态改
innodb_thread_sleep_delay	Int	Global	innodb	可动态改
innodb_tmpdir	Directory name	Both	innodb	可动态改
innodb_trx_purge_view_update_only_debug	Bool	Global	innodb	暂用不到
innodb_trx_rseg_n_slots_debug	Int	Global	innodb	暂用不到
innodb_undo_log_encrypt	Bool	Global	innodb	可动态改
innodb_undo_log_truncate	Bool	Global	innodb	可动态改
innodb_undo_tablespaces	Int	Global	innodb	可动态改
innodb_use_fdatasync	Bool	Global	innodb	可动态改
interactive_timeout	Int	Both	innodb	可动态改
internal_tmp_mem_storage_engine	Enum	Both	innodb	暂用不到
jemalloc_profiling	Bool	Global	innodb	可动态改
join_buffer_size	Int	Both	innodb	可动态改
keep_files_on_create	Bool	Both	innodb	可动态改
key_buffer_size	Int	Global	innodb	可动态改
key_cache_age_threshold	Int	Global	innodb	可动态改
key_cache_block_size	Int	Global	innodb	可动态改
key_cache_division_limit	Int	Global	innodb	可动态改
kill_idle_transaction	Int	Global	innodb	暂不能改
local_infile	Bool	Global	innodb	可动态改
lock_wait_timeout	Int	Both	innodb	可动态改
log_bin_trust_function_creators	Bool	Global	innodb	暂不能改
log_bin_use_v1_row_events	Bool	Global	innodb	基本不改
log_output	Set	Global	innodb	可动态改
log_queries_not_using_indexes	Bool	Global	innodb	可动态改
log_query_errors	Set	Both	innodb	可动态改
log_raw	Bool	Global	innodb	可动态改
log_slow_admin_statements	Bool	Global	innodb	可动态改
log_slow_extra	Bool	Global	innodb	可动态改
log_slow_filter	Set	Both	innodb	可动态改
log_slow_rate_limit	Int	Both	innodb	可动态改
log_slow_rate_type	Enum	Global	innodb	可动态改
log_slow_replica_statements	Bool	Global	innodb	可动态改
log_slow_slave_statements	Bool	Global	innodb	可动态改
log_slow_sp_statements	Enum	Global	innodb	可动态改
log_slow_verbosity	Set	Both	innodb	可动态改
log_statements_unsafe_for_binlog	Bool	Global	innodb	可动态改
log_throttle_queries_not_using_indexes	Int	Global	innodb	可动态改
log_timestamps	Enum	Global	innodb	暂不能改
long_query_time	Float	Both	innodb	可动态改
low_priority_updates	Bool	Both	innodb	暂不能改
mandatory_roles	Str	Global	innodb	基本不改
master_info_repository	Enum	Global	innodb	可动态改
master_verify_checksum	Bool	Global	innodb	可动态改
max_allowed_packet	Int	Both	innodb	可动态改
max_binlog_cache_size	Int	Global	innodb	可动态改
max_binlog_size	Int	Global	innodb	可动态改
max_binlog_stmt_cache_size	Int	Global	innodb	可动态改
max_connect_errors	Int	Global	innodb	可动态改
max_connections	Int	Global	innodb	可动态改
max_dbmsotpt_count	Int	Both	greatdb	可动态改
max_delayed_threads	Int	Both	innodb	暂不能改
max_error_count	Int	Both	innodb	可动态改
max_execution_time	Int	Both	innodb	可动态改
max_heap_table_size	Int	Both	innodb	暂用不到
max_join_size	Int	Both	innodb	可动态改
max_length_for_sort_data	Int	Both	innodb	可动态改
max_points_in_geometry	Int	Both	innodb	暂用不到
max_prepared_stmt_count	Int	Global	innodb	可动态改
max_relay_log_size	Int	Global	innodb	可动态改
max_seeks_for_key	Int	Both	innodb	可动态改
max_slowlog_files	Int	Global	innodb	可动态改
max_slowlog_size	Int	Global	innodb	可动态改
max_sort_length	Int	Both	innodb	可动态改
max_sp_recursion_depth	Int	Both	innodb	可动态改
max_user_connections	Int	Both	innodb	可动态改
max_write_lock_count	Int	Global	innodb	可动态改
min_examined_row_limit	Int	Both	innodb	可动态改
mpp_enable_explain_allstat	Bool	Both	greatdb	可动态改
myisam_data_pointer_size	Int	Global	myisam	暂用不到
myisam_max_sort_file_size	Int	Global	myisam	暂用不到
myisam_sort_buffer_size	Int	Both	myisam	暂用不到
myisam_stats_method	Enum	Both	myisam	暂用不到
myisam_use_mmap	Int	Global	myisam	暂用不到
mysql_native_password_proxy_users	Bool	Global	innodb	暂用不到
mysqlx_compression_algorithms	Set	Global	innodb	暂不能改
mysqlx_connect_timeout	Int	Global	innodb	可动态改
mysqlx_deflate_default_compression_level	Int	Global	innodb	基本不改
mysqlx_deflate_max_client_compression_level	Int	Global	innodb	基本不改
mysqlx_document_id_unique_prefix	Int	Global	innodb	可动态改
mysqlx_enable_hello_notice	Bool	Global	innodb	暂不能改
mysqlx_idle_worker_thread_timeout	Int	Global	innodb	可动态改
mysqlx_interactive_timeout	Int	Global	innodb	可动态改
mysqlx_lz4_default_compression_level	Int	Global	innodb	基本不改
mysqlx_lz4_max_client_compression_level	Int	Global	innodb	基本不改
mysqlx_max_allowed_packet	Int	Global	innodb	暂不能改
mysqlx_max_connections	Int	Global	innodb	可动态改
mysqlx_min_worker_threads	Int	Global	innodb	可动态改
mysqlx_read_timeout	Int	Both	innodb	暂不能改
mysqlx_wait_timeout	Int	Both	innodb	暂不能改
mysqlx_write_timeout	Int	Both	innodb	暂不能改
mysqlx_zstd_default_compression_level	Int	Global	innodb	基本不改
mysqlx_zstd_max_client_compression_level	Int	Global	innodb	基本不改
net_buffer_length	Int	Both	innodb	可动态改
net_buffer_shrink_interval	Int	Global	innodb	可动态改
net_keep_alive_interval	Int	Global	greatdb	可动态改
net_keep_alive_probes	Int	Global	greatdb	可动态改
net_keep_alive_timeout	Int	Global	greatdb	可动态改
net_keep_alive_user_timeout	Int	Global	greatdb	可动态改
net_read_timeout	Int	Both	innodb	可动态改
net_retry_count	Int	Both	innodb	可动态改
net_write_timeout	Int	Both	innodb	可动态改
new	Bool	Both	innodb	暂用不到
offline_mode	Bool	Global	innodb	暂用不到
old_alter_table	Bool	Both	innodb	基本不改
optimizer_max_subgraph_pairs	Int	Both	innodb	可动态改
optimizer_prune_level	Int	Both	innodb	可动态改
optimizer_search_depth	Int	Both	innodb	可动态改
optimizer_switch	Set	Both	innodb	可动态改
optimizer_trace	Set	Both	innodb	可动态改
optimizer_trace_features	Set	Both	innodb	可动态改
optimizer_trace_limit	Int	Both	innodb	可动态改
optimizer_trace_max_mem_size	Int	Both	innodb	可动态改
optimizer_trace_offset	Int	Both	innodb	可动态改
parser_max_mem_size	Int	Both	innodb	可动态改
partial_revokes	Bool	Global	innodb	暂不能改
password_history	Int	Global	innodb	可动态改
password_require_current	Bool	Global	innodb	可动态改
password_reuse_interval	Int	Global	innodb	可动态改
performance_schema_max_digest_sample_age	Int	Global	innodb	可动态改
performance_schema_show_processlist	Bool	Global	innodb	可动态改
preload_buffer_size	Int	Both	innodb	可动态改
print_identified_with_as_hex	Bool	Both	innodb	可动态改
profiling_history_size	Int	Both	innodb	可动态改
protocol_compression_algorithms	Set	Global	innodb	暂不能改
query_alloc_block_size	Int	Both	innodb	可动态改
query_prealloc_size	Int	Both	innodb	可动态改
range_alloc_block_size	Int	Both	innodb	可动态改
range_optimizer_max_mem_size	Int	Both	innodb	可动态改
read_buffer_size	Int	Both	innodb	可动态改
read_only	Bool	Global	innodb	暂不能改
read_rnd_buffer_size	Int	Both	innodb	可动态改
regexp_stack_limit	Int	Global	innodb	可动态改
regexp_time_limit	Int	Global	innodb	可动态改
relay_log_info_repository	Enum	Global	innodb	可动态改
relay_log_purge	Bool	Global	innodb	可动态改
replica_allow_batching	Bool	Global	innodb	可动态改
replica_checkpoint_group	Int	Global	innodb	可动态改
replica_checkpoint_period	Int	Global	innodb	可动态改
replica_compressed_protocol	Bool	Global	innodb	暂不能改
replica_exec_mode	Enum	Global	innodb	可动态改
replica_max_allowed_packet	Int	Global	innodb	可动态改
replica_net_timeout	Int	Global	innodb	可动态改
replica_pending_jobs_size_max	Int	Global	innodb	可动态改
replica_sql_verify_checksum	Bool	Global	innodb	暂不能改
replica_transaction_retries	Int	Global	innodb	可动态改
replica_type_conversions	Set	Global	innodb	基本不改
replication_optimize_for_static_plugin_config	Bool	Global	innodb	暂不能改
replication_sender_observe_commit_only	Bool	Global	innodb	暂不能改
require_secure_transport	Bool	Global	innodb	暂不能改
rewriter_enabled	Bool	Global	innodb	可动态改
rewriter_verbose	Int	Global	innodb	基本不改
rpl_read_size	Int	Global	innodb	可动态改
rpl_stop_replica_timeout	Int	Global	innodb	可动态改
rpl_stop_slave_timeout	Int	Global	innodb	可动态改
schema_definition_cache	Int	Global	innodb	暂不能改
secondary_engine_cost_threshold	Float	Both	innodb	暂用不到
select_bulk_into_batch	Int	Both	greatdb	可动态改
select_into_buffer_size	Int	Both	innodb	可动态改
select_into_disk_sync	Bool	Both	innodb	可动态改
select_into_disk_sync_delay	Int	Both	innodb	暂不能改
server_id	Int	Global	innodb	暂不能改
server_id_bits	Int	Global	innodb	暂不能改
server_instance_type	Enum	Global	greatdb	可动态改
serveroutput	Bool	Both	greatdb	可动态改
session_track_gtids	Enum	Both	innodb	可动态改
session_track_schema	Bool	Both	innodb	可动态改
session_track_state_change	Bool	Both	innodb	可动态改
session_track_system_variables	Str	Both	innodb	可动态改
session_track_transaction_info	Enum	Both	innodb	可动态改
sha256_password_proxy_users	Bool	Global	innodb	暂不能改
show_create_table_verbosity	Bool	Both	innodb	可动态改
show_dtid_enable_info	Enum	Both	innodb	可动态改
show_gipk_in_create_table_and_information_schema	Bool	Both	innodb	可动态改
show_old_temporals	Bool	Both	innodb	暂不能改
shrink_sql_mode	Set	Both	greatdb	暂不能改
slave_allow_batching	Bool	Global	innodb	可动态改
slave_checkpoint_group	Int	Global	innodb	可动态改
slave_checkpoint_period	Int	Global	innodb	可动态改
slave_compressed_protocol	Bool	Global	innodb	可动态改
slave_exec_mode	Enum	Global	innodb	可动态改
slave_max_allowed_packet	Int	Global	innodb	可动态改
slave_net_timeout	Int	Global	innodb	可动态改
slave_pending_jobs_size_max	Int	Global	innodb	可动态改
slave_rows_search_algorithms	Set	Global	innodb	可动态改
slave_sql_verify_checksum	Bool	Global	innodb	可动态改
slave_transaction_retries	Int	Global	innodb	可动态改
slave_type_conversions	Set	Global	innodb	可动态改
slow_launch_time	Int	Global	innodb	可动态改
slow_query_log	Bool	Global	innodb	可动态改
slow_query_log_always_write_time	Float	Global	innodb	可动态改
slow_query_log_file	Str	Global	innodb	可动态改
slow_query_log_use_global_control	Set	Global	innodb	可动态改
sort_buffer_size	Int	Both	innodb	可动态改
source_verify_checksum	Bool	Global	innodb	可动态改
sql_generate_invisible_primary_key	Bool	Both	innodb	基本不改
sql_mode	Set	Both	innodb	可动态改
sql_require_primary_key	Bool	Both	innodb	可动态改
ssl_fips_mode	Enum	Global	innodb	基本不改
stored_program_cache	Int	Global	innodb	可动态改
stored_program_definition_cache	Int	Global	innodb	可动态改
super_read_only	Bool	Global	innodb	暂用不到
sync_binlog	Int	Global	innodb	可动态改
sync_master_info	Int	Global	innodb	可动态改
sync_relay_log	Int	Global	innodb	可动态改
sync_relay_log_info	Int	Global	innodb	可动态改
sync_source_info	Int	Global	innodb	可动态改
table_definition_cache	Int	Global	innodb	可动态改
table_encryption_privilege_check	Bool	Global	innodb	暂不能改
table_open_cache	Int	Global	innodb	可动态改
tablespace_definition_cache	Int	Global	innodb	可动态改
temptable_max_mmap	Int	Global	innodb	暂用不到
temptable_max_ram	Int	Global	innodb	暂用不到
temptable_use_mmap	Bool	Global	innodb	暂用不到
terminology_use_previous	Enum	Both	innodb	可动态改
tf_sequence_table_max_upper_bound	Int	Global	innodb	基本不改
tf_udt_table_max_rows	Int	Global	greatdb	基本不改
thread_cache_size	Int	Global	innodb	可动态改
thread_pool_high_prio_mode	Enum	Both	innodb	可动态改
thread_pool_high_prio_tickets	Int	Both	innodb	可动态改
thread_pool_idle_timeout	Int	Global	innodb	可动态改
thread_pool_max_threads	Int	Global	innodb	可动态改
thread_pool_oversubscribe	Int	Global	innodb	可动态改
thread_pool_size	Int	Global	innodb	可动态改
thread_pool_stall_limit	Int	Global	innodb	可动态改
thread_statistics	Bool	Global	innodb	可动态改
tmp_table_size	Int	Both	innodb	暂用不到
transaction_alloc_block_size	Int	Both	innodb	可动态改
transaction_prealloc_size	Int	Both	innodb	可动态改
transaction_write_set_extraction	Enum	Both	innodb	可动态改
updatable_views_with_limit	Enum	Both	innodb	可动态改
userstat	Bool	Global	innodb	可动态改
version_suffix	Str	Global	innodb	可动态改
wait_timeout	Int	Both	innodb	可动态改
windowing_use_high_precision	Bool	Both	innodb	暂用不到
xa_detach_on_prepare	Bool	Both	innodb	基本不改
autocommit	Bool	Both	innodb	暂不能改
character_set_client	Str	Both	innodb	暂不能改
character_set_connection	Str	Both	innodb	暂不能改
character_set_database	Str	Both	innodb	暂不能改
character_set_filesystem	Str	Both	innodb	暂不能改
character_set_results	Str	Both	innodb	暂不能改
character_set_server	Str	Both	innodb	暂不能改
collation_connection	Str	Both	innodb	暂不能改
collation_database	Str	Both	innodb	暂不能改
collation_server	Str	Both	innodb	暂不能改
debug_sync	Int	Session	innodb	暂用不到
default_collation_for_utf8mb4	Str	Both	innodb	暂不能改
default_storage_engine	Str	Both	innodb	暂不能改
default_tmp_storage_engine	Str	Both	innodb	暂用不到
foreign_key_checks	Bool	Both	innodb	暂用不到
gdb_parallel_load	Bool	Session	greatdb	可动态改
gdb_parallel_load_chunk_size	Int	Both	greatdb	可动态改
gdb_parallel_load_workers	Int	Both	greatdb	可动态改
gdb_split_outfile	Bool	Session	greatdb	可动态改
gdb_split_outfile_rotate_size	Int	Both	greatdb	可动态改
gdb_split_outfile_wait_transport	Bool	Session	greatdb	可动态改
greatdb_dtm_server_address	Str	Global	greatdb	可动态改
greatdb_migrate_table_parallel_num	Int	Global	greatdb	可动态改
greatdb_sync_autoincrement_interval	Int	Global	greatdb	可动态改
greatdb_upgrade_cluster	Bool	Global	greatdb	可动态改
gtid_next	Int	Session	innodb	暂不能改
gtid_purged	Int	Global	innodb	基本不改
identity	Int	Session	innodb	基本不改
immediate_server_version	Int	Session	innodb	基本不改
insert_id	Int	Session	innodb	暂不能改
keyring_operations	Bool	Global	innodb	暂不能改
last_insert_id	Int	Session	innodb	暂不能改
lc_messages	Str	Both	innodb	可动态改
lc_time_names	Str	Both	innodb	可动态改
max_insert_delayed_threads	Int	Both	innodb	暂不能改
original_commit_timestamp	Int	Session	innodb	暂不能改
original_server_version	Int	Session	innodb	暂不能改
profiling	Bool	Both	innodb	可动态改
pseudo_replica_mode	Bool	Session	innodb	基本不改
pseudo_slave_mode (同pseudo_replica_mode)	Bool	Session	innodb	基本不改
pseudo_thread_id	Int	Session	innodb	基本不改
query_exec_time	Float	Both	innodb	可动态改
rand_seed1	Int	Session	innodb	可动态改
rand_seed2	Int	Session	innodb	可动态改
rbr_exec_mode	Enum	Both	innodb	可动态改
require_row_format	Bool	Session	innodb	暂不能改
resultset_metadata	Enum	Session	innodb	可动态改
show_create_table_skip_secondary_engine	Bool	Session	innodb	可动态改
sql_auto_is_null	Bool	Both	innodb	基本不改
sql_big_selects	Bool	Both	innodb	可动态改
sql_buffer_result	Bool	Both	innodb	可动态改
sql_log_bin	Bool	Session	innodb	暂不能改
sql_log_off	Bool	Both	innodb	可动态改
sql_notes	Bool	Both	innodb	可动态改
sql_quote_show_create	Bool	Both	innodb	可动态改
sql_replica_skip_counter	Int	Global	innodb	可动态改
sql_safe_updates	Bool	Both	innodb	可动态改
sql_select_limit	Int	Both	innodb	可动态改
sql_slave_skip_counter	Int	Global	innodb	暂不能改
sql_warnings	Bool	Both	innodb	可动态改
time_zone	Str	Both	innodb	暂不能改
timestamp	Float	Session	innodb	暂不能改
transaction_allow_batching	Bool	Session	innodb	可动态改
transaction_isolation	Enum	Both	innodb	可动态改
transaction_read_only	Bool	Both	innodb	基本不改
udt_format_result	Enum	Session	greatdb	基本不改
unique_checks	Bool	Both	innodb	暂用不到
use_secondary_engine	Enum	Session	innodb	暂用不到
version_comment	Str	Global	innodb	暂不能改

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

文章被以下合辑收录

万里数据库（共391篇）

北京万里开源软件有限公司

万里数据库greatdb全量动态系统变量

文章被以下合辑收录

评论