Системные переменные сервера
Contents
- Настройка системных переменных сервера
- Список системных переменных
- aria_block_size
- aria_checkpoint_interval
- aria_checkpoint_log_activity
- aria_encrypt_tables
- aria_force_start_after_recovery_failures
- aria_group_commit
- aria_group_commit_interval
- aria_log_file_size
- aria_log_purge_type
- aria_max_sort_file_size
- aria_page_checksum
- aria_pagecache_age_threshold
- aria_pagecache_buffer_size
- aria_pagecache_division_limit
- aria_pagecache_file_hash_size
- aria_recover
- aria_repair_threads
- aria_sort_buffer_size
- aria_stats_method
- aria_sync_log_dir
- aria_used_for_temp_tables
- auto_increment_increment
- auto_increment_offset
- autocommit
- automatic_sp_privileges
- back_log
- basedir
- big_tables
- binlog_annotate_row_events
- binlog_cache_size
- binlog_checksum
- binlog_commit_wait_count
- binlog_commit_wait_usec
- binlog_direct_non_transactional_updates
- binlog_format
- binlog_optimize_thread_scheduling
- binlog_row_image
- binlog_stmt_cache_size
- bulk_insert_buffer_size
- cassandra_default_thrift_host
- cassandra_failure_retries
- cassandra_insert_batch_size
- cassandra_multiget_batch_size
- cassandra_read_consistency
- cassandra_rnd_batch_size
- cassandra_write_consistency
- character_set_client
- character_set_connection
- character_set_database
- character_set_filesystem
- character_set_results
- character_set_server
- character_set_system
- character_sets_dir
- check_constraint_checks
- collation_connection
- collation_database
- collation_server
- completion_type
- concurrent_insert
- connect_conv_size
- connect_exact_info
- connect_indx_map
- connect_java_wrapper
- connect_json_grp_size
- connect_jvm_path
- connect_timeout
- connect_type_conv
- connect_use_tempfile
- connect_work_size
- connect_xtrace
- cracklib_password_check
- cracklib_password_check_dictionary
- datadir
- date_format
- datetime_format
- deadlock_search_depth_long
- deadlock_search_depth_short
- deadlock_timeout_long
- deadlock_timeout_short
- debug
- debug_no_thread_alarm
- debug_sync
- default_master_connection
- default_regex_flags
- default_storage_engine
- default_table_type
- default_tmp_storage_engine
- default_week_format
- delay_key_write
- delayed_insert_limit
- delayed_insert_timeout
- delayed_queue_size
- div_precision_increment
- encrypt_binlog
- encrypt_tmp_disk_tables
- encrypt_tmp_files
- encryption_algorithm
- enforce_storage_engine
- engine_condition_pushdown
- error_count
- event_scheduler
- expensive_subquery_limit
- expire_logs_days
- explicit_defaults_for_timestamp
- external_user
- extra_max_connections
- extra_port
- feedback
- feedback_http_proxy
- feedback_send_retry_wait
- feedback_send_timeout
- feedback_url
- feedback_user_info
- flush
- flush_time
- foreign_key_checks
- ft_boolean_syntax
- ft_max_word_len
- ft_min_word_len
- ft_query_expansion_limit
- ft_stopword_file
- general_log
- general_log_file
- group_concat_max_len
- gtid_binlog_pos
- gtid_binlog_state
- gtid_current_pos
- gtid_domain_id
- gtid_ignore_duplicates
- gtid_seq_no
- gtid_slave_pos
- gtid_strict_mode
- handlersocket_accept_balance
- handlersocket_address
- handlersocket_backlog
- handlersocket_epoll
- handlersocket_port
- handlersocket_port_wr
- handlersocket_sndbuf
- handlersocket_rcvbuf
- handlersocket_readsize
- handlersocket_threads
- handlersocket_threads_wr
- handlersocket_timeout
- handlersocket_verbose
- handlersocket_wrlock_timeout
- have_compress
- have_crypt
- have_csv
- have_dynamic_loading
- have_geometry
- have_innodb
- have_ndbcluster
- have_openssl
- have_partitioning
- have_profiling
- have_query_cache
- have_rtree_keys
- have_ssl
- have_symlink
- histogram_size
- histogram_type
- host_cache_size
- hostname
- identity
- ignore_builtin_innodb
- ignore_db_dirs
- in_transaction
- init_connect
- init_file
- init_slave
- innodb_adaptive_checkpoint
- innodb_adaptive_flushing
- innodb_adaptive_flushing_lwm
- innodb_adaptive_flushing_method
- innodb_adaptive_hash_index
- innodb_adaptive_hash_index_partitions
- innodb_adaptive_hash_index_parts
- innodb_adaptive_max_sleep_delay
- innodb_additional_mem_pool_size
- innodb_api_bk_commit_interval
- innodb_api_disable_rowlock
- innodb_api_enable_binlog
- innodb_api_enable_mdl
- innodb_api_trx_level
- innodb_auto_lru_dump
- innodb_autoextend_increment
- innodb_autoinc_lock_mode
- innodb_background_scrub_data_check_interval
- innodb_background_scrub_data-compressed
- innodb_background_scrub_data_interval
- innodb_background_scrub_data-uncompressed
- innodb_blocking_buffer_pool_restore
- innodb_buf_dump_status_frequency
- innodb_buffer_pool_chunk_size
- innodb_buffer_pool_dump_at_shutdown
- innodb_buffer_pool_dump_now
- innodb_buffer_pool_evict
- innodb_buffer_pool_filename
- innodb_buffer_pool_instances
- innodb_buffer_pool_load_abort
- innodb_buffer_pool_load_at_startup
- innodb_buffer_pool_load_now
- innodb_buffer_pool_populate
- innodb_buffer_pool_restore_at_startup
- innodb_buffer_pool_shm_checksum
- innodb_buffer_pool_shm_key
- innodb_buffer_pool_size
- innodb_change_buffer_max_size
- innodb_change_buffering
- innodb_change_buffering_debug
- innodb_checkpoint_age_target
- innodb_checksum_algorithm
- innodb_checksums
- innodb_cleaner_lsn_age_factor
- innodb_cmp_per_index_enabled
- innodb_commit_concurrency
- innodb_compression_algorithm
- innodb_compression_default
- innodb_compression_failure_threshold_pct
- innodb_compression_level
- innodb_compression_pad_pct_max
- innodb_concurrency_tickets
- innodb_corrupt_table_action
- innodb_data_file_path
- innodb_data_home_dir
- innodb_default_encryption_key_id
- innodb_default_page_encryption_key
- innodb_default_row_format
- innodb_defragment
- innodb_defragment_fill_factor
- innodb_defragment_fill_factor_n_recs
- innodb_defragment_frequency
- innodb_defragment_n_pages
- innodb_defragment_stats_accuracy
- innodb_dict_size_limit
- innodb_disable_sort_file_cache
- innodb_disallow_writes
- innodb_doublewrite
- innodb_doublewrite_file
- innodb_empty_free_list_algorithm
- innodb_enable_unsafe_group_commit
- innodb_encrypt_log
- innodb_encrypt_tables
- innodb_encryption_rotate_key_age
- innodb_encryption_rotation_iops
- innodb_encryption_threads
- innodb_extra_rsegments
- innodb_extra_undoslots
- innodb_fake_changes
- innodb_fast_checksum
- innodb_fast_shutdown
- innodb_fatal_semaphore_wait_threshold
- innodb_file_format
- innodb_file_format_check
- innodb_file_format_max
- innodb_file_per_table
- innodb_fill_factor
- innodb_flush_log_at_timeout
- innodb_flush_log_at_trx_commit
- innodb_flush_method
- innodb_flush_neighbor_pages
- innodb_flush_neighbors
- innodb_flush_sync
- innodb_flushing_avg_loops
- innodb_force_load_corrupted
- innodb_force_primary_key
- innodb_force_recovery
- innodb_foreground_preflush
- innodb_ft_aux_table
- innodb_ft_cache_size
- innodb_ft_enable_diag_print
- innodb_ft_enable_stopword
- innodb_ft_max_token_size
- innodb_ft_min_token_size
- innodb_ft_num_word_optimize
- innodb_ft_result_cache_limit
- innodb_ft_server_stopword_table
- innodb_ft_sort_pll_degree
- innodb_ft_total_cache_size
- innodb_ft_user_stopword_table
- innodb_ibuf_accel_rate
- innodb_ibuf_active_contract
- innodb_ibuf_max_size
- innodb_idle_flush_pct
- innodb_immediate_scrub_data-uncompressed
- innodb_import_table_from_xtrabackup
- innodb_instrument_semaphores
- innodb_io_capacity
- innodb_io_capacity_max
- innodb_kill_idle_transaction
- innodb_large_prefix
- innodb_lazy_drop_table
- innodb_lock_schedule_algorithm
- innodb_lock_wait_timeout
- innodb_locking_fake_changes
- innodb_locks_unsafe_for_binlog
- innodb_log_arch_dir
- innodb_log_arch_expire_sec
- innodb_log_archive
- innodb_log_block_size
- innodb_log_buffer_size
- innodb_log_checksum_algorithm
- innodb_log_checksums
- innodb_log_compressed_pages
- innodb_log_file_size
- innodb_log_files_in_group
- innodb_log_group_home_dir
- innodb_log_write_ahead_size
- innodb_lru_scan_depth
- innodb_max_bitmap_file_size
- innodb_max_changed_pages
- innodb_max_dirty_pages_pct
- innodb_max_dirty_pages_pct_lwm
- innodb_max_purge_lag
- innodb_max_purge_lag_delay
- innodb_max_undo_log_size
- innodb_merge_sort_block_size
- innodb_mirrored_log_groups
- innodb_monitor_disable
- innodb_monitor_enable
- innodb_monitor_reset
- innodb_monitor_reset_all
- innodb_mtflush_threads
- innodb_numa_interleave
- innodb_old_blocks_pct
- innodb_old_blocks_time
- innodb_online_alter_log_max_size
- innodb_open_files
- innodb_optimize_fulltext_only
- innodb_page_cleaners
- innodb_page_size
- innodb_prefix_index_cluster_optimization
- innodb_print_all_deadlocks
- innodb_purge_batch_size
- innodb_purge_rseg_truncate_frequency
- innodb_purge_threads
- innodb_random_read_ahead
- innodb_read_ahead
- innodb_read_ahead_threshold
- innodb_read_io_threads
- innodb_read_only
- innodb_recovery_stats
- innodb_recovery_update_relay_log
- innodb_replication_delay
- innodb_rollback_on_timeout
- innodb_rollback_segments
- innodb_sched_priority_cleaner
- innodb_scrub_log
- innodb_scrub_log_interval
- innodb_scrub_log_speed
- innodb_show_locks_held
- innodb_show_verbose_locks
- innodb_simulate_comp_failures
- innodb_sort_buffer_size
- innodb_spin_wait_delay
- innodb_stats_auto_recalc
- innodb_stats_auto_update
- innodb_stats_method
- innodb_stats_modified_counter
- innodb_stats_on_metadata
- innodb_stats_persistent
- innodb_stats_persistent_sample_pages
- innodb_stats_sample_pages
- innodb_stats_traditional
- innodb_stats_transient_sample_pages
- innodb_stats_update_need_lock
- innodb_status_output
- innodb_status_output_locks
- innodb_strict_mode
- innodb_support_xa
- innodb_sync_array_size
- innodb_sync_spin_loops
- innodb_table_locks
- innodb_temp_data_file_path
- innodb_thread_concurrency
- innodb_thread_concurrency_timer_based
- innodb_thread_sleep_delay
- innodb_tmpdir
- innodb_track_changed_pages
- innodb_undo_directory
- innodb_undo_log_truncate
- innodb_undo_logs
- innodb_use_atomic_writes
- innodb_use_fallocate
- innodb_use_global_flush_log_at_trx_commit
- innodb_use_native_aio
- innodb_use_purge_thread
- innodb_use_stacktrace
- innodb_use_sys_malloc
- innodb_use_sys_stats_table
- innodb_version
- innodb_write_io_threads
- insert_id
- interactive_timeout
- join_buffer_size
- join_buffer_space_limit
- join_cache_level
- keep_files_on_create
- key_buffer_size
- key_cache_age_threshold
- key_cache_block_size
- key_cache_division_limit
- key_cache_file_hash_size
- key_cache_segments
- language
- large_files_support
- large_page_size
- large_pages
- last_gtid
- last_insert_id
- lc_messages
- lc_messages_dir
- lc_time_names
- license
- local_infile
- lock_wait_timeout
- locked_in_memory
- log
- log_bin
- log_bin_basename
- log_bin_index
- log_bin_trust_function_creators
- log_error
- log_output
- log_queries_not_using_indexes
- log_slave_updates
- log_slow_admin_statements
- log_slow_filter
- log_slow_queries
- log_slow_rate_limit
- log_slow_slave_statements
- log_slow_verbosity
- log_tc_size
- log_warnings
- long_query_time
- low_priority_updates
- lower_case_file_system
- lower_case_table_names
- master_retry_count
- master_verify_checksum
- max_allowed_packet
- max_binlog_cache_size
- max_binlog_size
- max_binlog_stmt_cache_size
- max_connect_errors
- max_connections
- max_delayed_threads
- max_digest_length
- max_error_count
- max_heap_table_size
- max_insert_delayed_threads
- max_join_size
- max_length_for_sort_data
- max_long_data_size
- max_prepared_stmt_count
- max_recursive_iterations
- max_relay_log_size
- max_seeks_for_key
- max_session_mem_used
- max_sort_length
- max_sp_recursion_depth
- max_statement_time
- max_tmp_tables
- max_user_connections
- max_write_lock_count
- metadata_locks_cache_size
- metadata_locks_hash_instances
- min_examined_row_limit
- mroonga_action_on_fulltext_query_error
- mroonga_default_parser
- mroonga_dry_write
- mroonga_enable_optimization
- mroonga_libgroonga_version
- mroonga_log_file
- mroonga_log_level
- mroonga_match_escalation_threshold
- mroonga_vector_column_delimiter
- mroonga_version
- mrr_buffer_size
- multi_range_count
- myisam_block_size
- myisam_data_pointer_size
- myisam_max_sort_file_size
- myisam_mmap_size
- myisam_recover_options
- myisam_repair_threads
- myisam_sort_buffer_size
- myisam_stats_method
- myisam_use_mmap
- mysql56_temporal_format
- named_pipe
- net_buffer_length
- net_read_timeout
- net_retry_count
- net_write_timeout
- old
- old_alter_table
- old_mode
- old_passwords
- open_files_limit
- optimizer_prune_level
- optimizer_search_depth
- optimizer_selectivity_sampling_limit
- optimizer_switch
- optimizer_use_condition_selectivity
- oqgraph_allow_create_integer_latch
- pam_use_cleartext_plugin
- performance_schema
- performance_schema_accounts_size
- performance_schema_digests_size
- performance_schema_events_stages_history_long_size
- performance_schema_events_stages_history_size
- performance_schema_events_statements_history_long_size
- performance_schema_events_statements_history_size
- performance_schema_events_waits_history_long_size
- performance_schema_events_waits_history_size
- performance_schema_hosts_size
- performance_schema_max_cond_classes
- performance_schema_max_cond_instances
- performance_schema_max_digest_length
- performance_schema_max_file_classes
- performance_schema_max_file_handles
- performance_schema_max_file_instances
- performance_schema_max_mutex_classes
- performance_schema_max_mutex_instances
- performance_schema_max_rwlock_classes
- performance_schema_max_rwlock_instances
- performance_schema_max_socket_classes
- performance_schema_max_socket_instances
- performance_schema_max_stage_classes
- performance_schema_max_statement_classes
- performance_schema_max_table_handles
- performance_schema_max_table_instances
- performance_schema_max_thread_classes
- performance_schema_max_thread_instances
- performance_schema_session_connect_attrs_size
- performance_schema_setup_actors_size
- performance_schema_setup_objects_size
- performance_schema_users_size
- pid_file
- plugin_dir
- plugin_maturity
- port
- preload_buffer_size
- profiling
- profiling_history_size
- progress_report_time
- protocol_version
- proxy_user
- pseudo_slave_mode
- pseudo_thread_id
- query_alloc_block_size
- query_cache_limit
- query_cache_min_res_unit
- query_cache_size
- query_cache_strip_comments
- query_cache_type
- query_cache_wlock_invalidate
- query_prealloc_size
- query_response_time_flush
- query_response_time_range_base
- query_response_time_range_exec_time_debug
- query_response_time_stats
- rand_seed1
- rand_seed2
- range_alloc_block_size
- read_binlog_speed_limit
- read_buffer_size
- read_only
- read_rnd_buffer_size
- relay_log
- relay_log_basename
- relay_log_index
- relay_log_info_file
- relay_log_purge
- relay_log_recovery
- relay_log_space_limit
- replicate_annotate_row_events
- replicate_do_db
- replicate_do_table
- replicate_events_marked_for_skip
- replicate_ignore_db
- replicate_ignore_table
- replicate_wild_do_table
- replicate_wild_ignore_table
- report_host
- report_password
- report_port
- report_user
- rowid_merge_buff_size
- rpl_recovery_rank
- safe_show_database
- secure_auth
- secure_file_priv
- rpl_semi_sync_master_enabled
- rpl_semi_sync_master_timeout
- rpl_semi_sync_master_trace_level
- rpl_semi_sync_master_wait_no_slave
- rpl_semi_sync_master_wait_point
- rpl_semi_sync_slave_enabled
- rpl_semi_sync_slave_trace_level
- server_audit_events
- server_audit_excl_users
- server_audit_file_path
- server_audit_file_rotate_now
- server_audit_file_rotate_size
- server_audit_file_rotations
- server_audit_incl_users
- server_audit_loc_info
- server_audit_logging
- server_audit_mode
- server_audit_output_type
- server_audit_query_limit
- server_audit_syslog_facility
- server_audit_syslog_ident
- server_audit_syslog_info
- server_audit_syslog_priority
- server_id
- session_track_schema
- session_track_state_change
- session_track_system_variables
- session_track_transaction_info
- shared_memory
- shared_memory_base_name
- simple_password_check_digits
- simple_password_check_letters_same_case
- simple_password_check_minimal_length
- simple_password_check_other_characters
- skip_external_locking
- skip_name_resolve
- skip_networking
- skip_parallel_replication
- skip_replication
- skip_show_database
- slave_compressed_protocol
- slave_ddl_exec_mode
- slave_domain_parallel_threads
- slave_exec_mode
- slave_load_tmpdir
- slave_max_allowed_packet
- slave_net_timeout
- slave_parallel_max_queued
- slave_parallel_mode
- slave_parallel_threads
- slave_run_triggers_for_rbr
- slave_skip_errors
- slave_sql_verify_checksum
- slave_transaction_retries
- slave_type_conversions
- slow_launch_time
- slow_query_log
- slow_query_log_file
- socket
- sort_buffer_size
- spider_auto_increment_mode
- spider_auto_increment_mode
- spider_auto_increment_mode
- spider_bgs_second_read
- spider_bka_engine
- spider_bka_mode
- spider_block_size
- spider_bulk_access_free
- spider_bulk_size
- spider_bulk_update_mode
- spider_bulk_update_size
- spider_casual_read
- spider_conn_recycle_mode
- spider_conn_recycle_strict
- spider_connect_error_interval
- spider_connect_mutex
- spider_connect_retry_count
- spider_connect_retry_interval
- spider_connect_timeout
- spider_crd_bg_mode
- spider_crd_interval
- spider_crd_mode
- spider_crd_sync
- spider_crd_type
- spider_crd_weight
- spider_delete_all_rows_type
- spider_direct_dup_insert
- spider_direct_order_limit
- spider_dry_access
- spider_error_read_mode
- spider_error_write_mode
- spider_first_read
- spider_force_commit
- spider_general_log
- spider_init_sql_alloc_size
- spider_internal_limit
- spider_internal_offset
- spider_internal_optimize
- spider_internal_optimize_local
- spider_internal_sql_log_off
- spider_internal_unlock
- spider_internal_xa
- spider_internal_xa_id_type
- spider_internal_xa_snapshot
- spider_local_lock_table
- spider_lock_exchange
- spider_log_result_error_with_sql
- spider_log_result_errors
- spider_low_mem_read
- spider_max_order
- spider_multi_split_read
- spider_net_read_timeout
- spider_net_write_timeout
- spider_ping_interval_at_trx_start
- spider_quick_mode
- spider_quick_page_size
- spider_read_only_mode
- spider_remote_access_charset
- spider_remote_autocommit
- spider_remote_default_database
- spider_remote_sql_log_off
- spider_remote_time_zone
- spider_remote_trx_isolation
- spider_reset_sql_alloc
- spider_same_server_link
- spider_second_read
- spider_select_column_mode
- spider_selupd_lock_mode
- spider_semi_split_read
- spider_semi_split_read_limit
- spider_semi_table_lock
- spider_semi_table_lock_connection
- spider_semi_trx
- spider_semi_trx_isolation
- spider_skip_default_condition
- spider_split_read
- spider_sts_bg_mode
- spider_sts_interval
- spider_sts_mode
- spider_sts_sync
- spider_support_xa
- spider_sync_autocommit
- spider_sync_time_zone
- spider_sync_trx_isolation
- spider_table_init_error_interval
- spider_udf_ct_bulk_insert_interval
- spider_udf_ct_bulk_insert_rows
- spider_udf_ds_bulk_insert_rows
- spider_udf_ds_table_loop_mode
- spider_udf_ds_use_real_table
- spider_udf_table_lock_mutex_count
- spider_udf_table_mon_mutex_count
- spider_use_all_conns_snapshot
- spider_use_consistent_snapshot
- spider_use_default_database
- spider_use_flash_logs
- spider_use_handler
- spider_use_pushdown_udf
- spider_use_table_charset
- spider_version
- sql_auto_is_null
- sql_big_selects
- sql_big_tables
- sql_buffer_result
- sql_error_log_filename
- sql_error_log_rate
- sql_error_log_rotate
- sql_error_log_rotations
- sql_error_log_size_limit
- sql_log_bin
- sql_log_off
- sql_log_update
- sql_low_priority_updates
- sql_max_join_size
- sql_mode
- sql_notes
- sql_quote_show_create
- sql_safe_updates
- sql_select_limit
- sql_slave_skip_counter
- sql_warnings
- ssl_ca
- ssl_capath
- ssl_cert
- ssl_cipher
- ssl_crl
- ssl_crlpath
- ssl_key
- storage_engine
- standard_compliant_cte
- stored_program_cache
- strict_password_validation
- sync_binlog
- sync_frm
- sync_master_info
- sync_relay_log
- sync_relay_log_info
- system_time_zone
- table_definition_cache
- table_lock_wait_timeout
- table_open_cache
- table_open_cache_instances
- table_type
- thread_cache_size
- thread_concurrency
- thread_handling
- thread_pool_idle_timeout
- thread_pool_max_threads
- thread_pool_min_threads
- thread_pool_oversubscribe
- thread_pool_prio_kickup_timer
- thread_pool_priority
- thread_pool_size
- thread_pool_stall_limit
- thread_stack
- time_format
- time_zone
- timed_mutexes
- timestamp
- tmp_table_size
- tmpdir
- tokudb_alter_print_error
- tokudb_analyze_time
- tokudb_block_size
- tokudb_bulk_fetch
- tokudb_cache_size
- tokudb_check_jemalloc
- tokudb_checkpoint_lock
- tokudb_checkpoint_on_flush_logs
- tokudb_checkpointing_period
- tokudb_cleaner_iterations
- tokudb_cleaner_period
- tokudb_commit_sync
- tokudb_create_index_online
- tokudb_data_dir
- tokudb_debug
- tokudb_directio
- tokudb_disable_hot_alter
- tokudb_disable_prefetching
- tokudb_disable_slow_alter
- tokudb_empty_scan
- tokudb_fs_reserve_percent
- tokudb_fsync_log_period
- tokudb_hide_default_row_format
- tokudb_killed_time
- tokudb_last_lock_timeout
- tokudb_load_save_space
- tokudb_loader_memory_size
- tokudb_lock_timeout
- tokudb_lock_timeout_debug
- tokudb_log_dir
- tokudb_max_lock_memory
- tokudb_optimize_index_fraction
- tokudb_optimize_index_name
- tokudb_optimize_throttle
- tokudb_pk_insert_mode
- tokudb_prelock_empty
- tokudb_read_block_size
- tokudb_read_buf_size
- tokudb_read_status_frequency
- tokudb_row_format
- tokudb_rpl_check_readonly
- tokudb_rpl_lookup_rows
- tokudb_rpl_lookup_rows_delay
- tokudb_rpl_unique_checks
- tokudb_rpl_unique_checks_delay
- tokudb_support_xa
- tokudb_tmp_dir
- tokudb_version
- tokudb_write_status_frequency
- transaction_alloc_block_size
- transaction_prealloc_size
- tx_isolation
- tx_read_only
- unique_checks
- updatable_views_with_limit
- use_stat_tables
- userstat
- version
- version_comment
- version_compile_machine
- version_compile_os
- version_malloc_library
- version_ssl_library
- wait_timeout
- warning_count
- wsrep_auto_increment_control
- wsrep_causal_reads
- wsrep_certify_nonPK
- wsrep_cluster_address
- wsrep_cluster_name
- wsrep_convert_LOCK_to_trx
- wsrep_data_home_dir
- wsrep_dbug_option
- wsrep_debug
- wsrep_desync
- wsrep_dirty_reads
- wsrep_drupal_282555_workaround
- wsrep_forced_binlog_format
- wsrep_gtid_domain_id
- wsrep_gtid_mode
- wsrep_load_data_splitting
- wsrep_log_conflicts
- wsrep_max_ws_rows
- wsrep_max_ws_size
- wsrep_mysql_replication_bundle
- wsrep_node_address
- wsrep_node_incoming_address
- wsrep_node_name
- wsrep_notify_cmd
- wsrep_on
- wsrep_OSU_method
- wsrep_provider
- wsrep_provider_options
- wsrep_recover
- wsrep_replicate_myisam
- wsrep_restart_slave
- wsrep_retry_autocommit
- wsrep_slave_fk_checks
- wsrep_slave_threads
- wsrep_slave_uk_checks
- wsrep_sst_auth
- wsrep_sst_donor
- wsrep_sst_donor_rejects_queries
- wsrep_sst_method
- wsrep_sst_receive_address
- wsrep_start_position
- wsrep_sync_wait
MariaDB has many system variables that can be changed to suit your needs.
The full list of server variables are listed in the contents on this page, and most are described on this page, but some are described elsewhere:
- Aria System Variables
- CONNECT System Variables
- Galera System Variables
- Global Transaction ID System Variables
- HandlerSocket Plugin System Variables
- XtraDB/InnoDB System Variables
- Mroonga System Variables
- MyISAM System Variables
- Performance Schema System Variables
- Replication and Binary Log System Variables
- Server_Audit System Variables
- Spider System Variables
- SQL_ERROR_LOG Plugin System Variables
- SSL System Variables
- Threadpool System Variables
- TokuDB System Variables
Читайте также полный список системных и статусных опций MariaDB
Most of these can be set with command line options and many of them can be changed at runtime.
There are a few ways to see the full list of server system variables:
- While in the mysql client, run:
SHOW VARIABLES;
- See SHOW VARIABLES for instructions on using this command.
- В командной строке запустите mysqld так:
mysqld --verbose --help
- View the Information Schema GLOBAL_VARIABLES, SESSION_VARIABLES, и SYSTEM_VARIABLES tables.
Настройка системных переменных сервера
Существует несколько способов установки системных переменных:
- Указать их напрямую в командной строке:
shell> ./mysqld_safe --aria_group_commit="hard"
- Указать их в вашем my.cnf файле (читайте настройка MariaDB в my.cnf, чтобы получить больше информации):
aria_group_commit = "hard"
- Указать их через клиент mysql используя SET команду. Данным способом, во время работы сервера, могут быть установлены только динамические переменные. Обратите внимание, что установленные переменные, после перезапуска сервера, не будут сохранены
SET GLOBAL aria_group_commit="hard";
By convention, server variables have usually been specified with an underscore in the configuration files, and a dash on the command line. You can however specify underscores as dashes - they are interchangeable.
Список системных переменных
autocommit
- Описание: If set to 1, the default, all queries are committed immediately. If set to 0, they are only committed upon a COMMIT statement, or rolled back with a ROLLBACK statement. If autocommit is set to 0, and then changed to 1, all open transactions are immediately committed.
- Командная строка:
--autocommit[=#]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
1
automatic_sp_privileges
- Описание: When set to 1, the default, when a stored routine is created, the creator is automatically granted permission to ALTER (which includes dropping) and to EXECUTE the routine. If set to 0, the creator is not automatically granted these privileges.
- Командная строка:
--automatic-sp-privileges
,--skip-automatic-sp-privileges
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
1
back_log
- Описание: Connections take a small amount of time to start, and this setting determines the number of outstanding connection requests MariaDB can have, or the size of the listen queue for incoming TCP/IP requests. Requests beyond this will be refused. Increase if you expect short bursts of connections. Cannot be set higher than the operating system limit (see the Unix listen() man page).
- Командная строка:
--back-log=#
- Область: Глобальный
- Динамический: Нет
- Тип данных: number
- По умолчанию:
50
(before MariaDB 10.0.8) or the lower of150
or the value of max_connections (from MariaDB 10.0.8)
basedir
- Описание: Path to the MariaDB installation directory. Other paths are usually resolved relative to this base directory.
- Командная строка:
--basedir=path
или-b path
- Область: Глобальный
- Динамический: Нет
- Тип данных: directory name
big_tables
- Описание: Old variable, which if set to 1, allows large result sets by saving all temporary sets to disk, avoiding 'table full' errors. No longer needed, as the server now handles this automatically. sql_big_tables is a synonym.
- Командная строка:
--big-tables
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
0
bulk_insert_buffer_size
- Описание: Size in bytes of the per-thread cache tree used to speed up bulk inserts into MyISAM and Aria tables. A value of 0 disables the cache tree.
- Командная строка:
--bulk-insert-buffer-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
8388608
- Диапазон - 32 bit:
0
-4294967295
- Диапазон - 64 bit:
0
-18446744073709547520
character_set_client
- Описание: Determines the character set for queries arriving from the client. It can be set per session by the client, although the server can be configured to ignore client requests with the
--skip-character-set-client-handshake
option. If the client does not request a character set, or requests a character set that the server does not support, the global value will be used. utf16, utf32 and ucs2 cannot be used as client character sets. - Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
utf8
(>= MariaDB 5.5)
character_set_connection
- Описание: Character set used for number to string conversion, as well as for literals that don't have a character set introducer.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
utf8
(>= MariaDB 5.5)
character_set_database
- Описание: Character set used by the default database, and set by the server whenever the default database is changed. If there's no default database, character_set_database contains the same value as character_set_server. This variable is dynamic, but should not be set manually, only by the server.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
latin1
character_set_filesystem
- Описание: The character set for the filesystem. Used for converting file names specified as a string literal from character_set_client to character_set_filesystem before opening the file. By default set to
binary
, so no conversion takes place. This could be useful for statements such as LOAD_FILE() or LOAD DATA INFILE on system where multi-byte file names are use. - Командная строка:
--character-set-filesystem=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
binary
character_set_results
- Описание: Character set used for results and error messages returned to the client.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
utf8
character_set_server
- Описание: Default character set used by the server. See character_set_database for character sets used by the default database. Defaults may be different on some systems, see for example Differences in MariaDB in Debian.
- Командная строка:
--character-set-server
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
latin1
character_set_system
- Описание: Character set used by the server to store identifiers, always set to utf8.
- Область: Глобальный
- Динамический: Нет
- Тип данных:
string
- По умолчанию:
utf8
character_sets_dir
- Описание: Directory where the character sets are installed.
- Командная строка:
--character-sets-dir=path
- Область: Глобальный
- Динамический: Нет
- Тип данных: directory name
check_constraint_checks
- Описание: If set to
0
, will disable constraint checks, for example when loading a table that violates some constraints that you plan to fix later. - Командная строка:
--check-constraint-checks=[0|1]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: boolean
- По умолчанию: ON
- Введено: MariaDB 10.2.1
collation_connection
- Описание: Collation used for the connection character set.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
collation_database
- Описание: Collation used for the default database. Set by the server if the default database changes, if there is no default database the value from the
collation_server
variable is used. This variable is dynamic, but should not be set manually, only by the server. - Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
collation_server
- Описание: Default collation used by the server. This is set to the default collation for a given character set automatically when character_set_server is changed, but it can also be set manually. Defaults may be different on some systems, see for example Differences in MariaDB in Debian.
- Командная строка:
--collation-server=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
latin1_swedish_ci
completion_type
- Описание: The transaction completion type. If set to
NO_CHAIN
or0
(the default), there is no effect on commits and rollbacks. If set toCHAIN
or1
, a COMMIT statement is equivalent to COMMIT AND CHAIN, while a ROLLBACK is equivalent to ROLLBACK AND CHAIN, so a new transaction starts straight away with the same isolation level as transaction that's just finished. If set toRELEASE
or2
, a COMMIT statement is equivalent to COMMIT RELEASE, while a ROLLBACK is equivalent to ROLLBACK RELEASE, so the server will disconnect after the transaction completes. Note that the transaction completion type only applies to explicit commits, not implicit commits. - Командная строка:
--completion-type=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enumerated
(>=MariaDB/MySQL 5.5.3),numeric
(<= MariaDB/MySQL 5.5.2) - По умолчанию:
NO_CHAIN
(>=MariaDB/MySQL 5.5.3),0
(<= MariaDB/MySQL 5.5.2) - Допустимые значения:
0
,1
,2
(Все версии),NO_CHAIN
,CHAIN
,RELEASE
(>=MariaDB/MySQL 5.5.3)
concurrent_insert
- Описание: If set to
AUTO
or1
, the default, MariaDB allows concurrent INSERTs and SELECTs for MyISAM tables with no free blocks in the data. If set toNEVER
or0
, concurrent inserts are disabled. If set toALWAYS
or2
, concurrent inserts are permitted for all MyISAM tables, even those with holes, in which case new rows are added at the end of a table if the table is being used by another thread. If the --skip-new option is used when starting the server, concurrent_insert is set toNEVER
. - Командная строка:
--concurrent-insert[=name]
- Область: Глобальный
- Динамический: Да
- Тип данных:
enumerated
(>=MariaDB/MySQL 5.5.3),numeric
(<= MariaDB/MySQL 5.5.2) - По умолчанию:
AUTO
(>=MariaDB/MySQL 5.5.3),1
(<= MariaDB/MySQL 5.5.2) - Допустимые значения:
0
,1
,2
(All versions),AUTO
,NEVER
,ALWAYS
(>=MariaDB/MySQL 5.5.3) - Documentation: concurrent-inserts
- Notes: Changing the variable only affects new opened tables. Use
FLUSH TABLES
If you want it to affect also cached tables.
connect_timeout
- Описание: Time in seconds that the server waits for a connect packet before returning a 'Bad handshake'. Increasing may help if clients regularly encounter 'Lost connection to MySQL server at 'X', system error: error_number' type-errors
- Командная строка:
--connect-timeout=#
- Область: Глобальный
- Динамический: Да
- Тип данных: numeric
- По умолчанию:
10
datadir
- Описание: Каталог для хранения данных
- Командная строка:
--datadir=path
или-h path
- Область: Глобальный
- Динамический: Нет
- Тип данных: Имя каталога
date_format
- Описание: Не используется
datetime_format
- Описание: Не используется
debug
- Описание: Used in debugging to write to a trace file. MariaDB needs to be configured with -SWITH_DEBUG=1 to enable this option.
- Командная строка:
--debug[=debug_options]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
d:t:i:o,/tmp/mysqld.trace
(Unix) ord:t:i:O,\mysqld.trace
(Windows)
debug_no_thread_alarm
- Описание: Disable system thread alarm calls. Disabling it may be useful in debugging or testing, never do it in production.
- Командная строка:
--debug-no-thead-alarm=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
OFF
- Введено: MariaDB
debug_sync
- Описание: Used in debugging to show the interface to the Debug Sync facility. MariaDB needs to be configured with -DENABLE_DEBUG_SYNC=1 for this variable to be available.
- Область: Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
OFF
orON - current signal signal name
default_regex_flags
- Описание: Introduced to address remaining incompatibilities between PCRE and the old regex library. Accepts a comma-separated list of zero or more of the following values:
Value | Pattern equivalent | Meaning |
DOTALL | (?s) | . matches anything including NL |
DUPNAMES | (?J) | Allow duplicate names for subpatterns |
EXTENDED | (?x) | Ignore white space and # comments |
EXTRA | (?X) | extra features (e.g. error on unknown escape character) |
MULTILINE | (?m) | ^ and $ match newlines within data |
UNGREEDY | (?U) | Invert greediness of quantifiers |
- Командная строка:
--default-regex-flags=value
- Область: Глобальный, Сессия
- Динамический: Да
- По умолчанию: Пустой
- Допустимые значения:
DOTALL
,DUPNAMES
,EXTENDED
,EXTRA
,MULTILINE
,UNGREEDY
- Введено: MariaDB 10.0.11
default_storage_engine
- Описание: The default storage engine. The default storage engine must be enabled at server startup or the server won't start.
- Командная строка:
--default-storage-engine=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: enumeration
- По умолчанию:
InnoDB
(>= MariaDB 5.5),MyISAM
(<MariaDB 5.3) - Введено: MariaDB 5.5 (previously storage_engine)
default_table_type
- Описание: Синоним default_storage_engine. Удален из MariaDB 5.5
- Командная строка:
--default-table-type=name
- Область: Глобальный, Сессия
- Динамический: Да
- Удалено: MariaDB/MySQL 5.5
default_tmp_storage_engine
- Описание: Default storage engine that will be used for tables created with CREATE TEMPORARY TABLE where no engine is specified. For internal temporary tables see aria_used_for_temp_tables). The storage engine used must be active or the server will not start. See default_storage_engine for the default for non-temporary tables. Defaults to NULL, in which case the value from default_storage_engine is used.
- Командная строка:
--default-tmp-storage-engine=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enumeration
- По умолчанию: NULL
- Введено: MariaDB 10.1.0
default_week_format
- Описание: Default mode for the WEEK() function. See that page for details on the different modes
- Командная строка:
--default-week-format=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
- Диапазон:
0
-7
delay_key_write
- Описание: Specifies how MyISAM tables handles CREATE TABLE DELAY_KEY_WRITE. If set to
ON
, the default, any DELAY KEY WRITEs are honored. The key buffer is then flushed only when the table closes, speeding up writes. MyISAM tables should be automatically checked upon startup in this case, and --external locking should not be used, as it can lead to index corruption. If set toOFF
, DELAY KEY WRITEs are ignored, while if set toALL
, all new opened tables are treated as if created with DELAY KEY WRITEs enabled. - Командная строка:
--delay-key-write[=name]
- Область: Глобальный
- Динамический: Да
- Тип данных:
enumeration
- По умолчанию:
ON
- Допустимые значения:
ON
,OFF
,ALL
delayed_insert_limit
- Описание: After this many rows have been inserted with INSERT DELAYED, the handler will check for and execute any waiting SELECT statements.
- Командная строка:
--delayed-insert-limit=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
100
- Диапазон:
1
-4294967295
delayed_insert_timeout
- Описание: Time in seconds that the INSERT DELAYED handler will wait for INSERT's before terminating.
- Командная строка:
--delayed-insert-timeout=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
300
delayed_queue_size
- Описание: Number of rows, per table, that can be queued when performing INSERT DELAYED statements. If the queue becomes full, clients attempting to perform INSERT DELAYED's will wait until the queue has room available again.
- Командная строка:
--delayed-queue-size=#
- Область: Глобальный
- Динамический: Да
- Тип данных: numeric
- По умолчанию:
1000
- Диапазон:
1 - 4294967295
div_precision_increment
- Описание: Number of digits to be returned after the decimal point in division operations. By default
4
, soSELECT 2/15
would return 0.1333. After setting div_precision_increment to6
, for example, the same operation would return 0.133333. - Командная строка:
--div-precision-increment=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
4
- Диапазон:
0
-30
encrypt_tmp_disk_tables
- Описание: Encrypt tmp disk tables (created as part of query execution). See Table and Tablespace Encryption.
- Командная строка:
--encrypt-tmp-disk-tables[={0|1}]
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
- Введено: 10.1.3
encrypt_tmp_files
- Описание: Encrypt temporary files (created for filesort, binary log cache, etc). See Table and Tablespace Encryption.
- Командная строка:
--encrypt-tmp-files[={0|1}]
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
OFF
(>= 10.1.7),ON
(<= 10.1.6) - Введено: 10.1.5
encryption_algorithm
- Описание: Which encryption algorithm to use for table encryption.
aes_cbc
is the recommended one. See Table and Tablespace Encryption. - Командная строка:
--encryption-algorithm=value
- Область: Глобальный
- Динамический: Нет
- Тип данных:
enum
- По умолчанию:
none
- Допустимые значения:
none
,aes_ecb
,aes_cbc
,aes_ctr
- Введено: MariaDB 10.1.3
- Удалено: MariaDB 10.1.4
enforce_storage_engine
- Описание: Force the use of a particular storage engine for new tables. Used to avoid unwanted creation of tables using another engine. For example, setting to InnoDB will prevent any MyISAM tables from being created. If another engine is specified in a CREATE TABLE statement, the outcome depends on whether the
NO_ENGINE_SUBSTITUTION
SQL_MODE has been set or not. If set (the default from MariaDB 10.1.7), the query will fail, while if not set, a warning will be returned and the table created according to the engine specified by this variable. The variable has a session scope, but is only modifiable by a user with the SUPER privilege. - Командная строка: none
- Область: Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
none
- Введено: MariaDB 10.1.4
engine_condition_pushdown
- Описание: Deprecated and to be replaced by optimizer_switch. Specifies whether the engine condition pushdown optimization is enabled.
- Командная строка:
--engine-condition-pushdown
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
(>= MariaDB 5.5,ON
< MySQL 5.5) - Устарел:
MariaDB/MySQL 5.5.3
error_count
- Описание: Read-only variable denoting the number of errors from the most recent statement in the current session that generated errors. See SHOW_ERRORS().
- Область: Сессия
- Динамический: Да
- Тип данных:
numeric
event_scheduler
- Описание: Состояние планировщика задач. Может быть установлен в
ON
илиOFF
, аDISABLED
означает, что его невозможно будет включить во время работы. Установка переменной приведет к запуску установленных задач, если они не были выполнены при запуске - Командная строка:
--event-scheduler[=value]
- Область: Глобальный
- Динамический: Да
- Тип данных:
enumeration
- По умолчанию:
OFF
- Допустимые значения:
ON
(или1
),OFF
(или0
),DISABLED
expensive_subquery_limit
- Описание: Number of rows to be examined for a query to be considered expensive, that is, maximum number of rows a subquery may examine in order to be executed during optimization and used for constant optimization.
- Командная строка:
--expensive-subquery-limit=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
100
- Диапазон: от
0
и выше - Введено: MariaDB 5.5.25
explicit_defaults_for_timestamp
- Описание: This option causes CREATE TABLE to create all TIMESTAMP columns as NULL with the DEFAULT NULL attribute, Without this option, TIMESTAMP columns are NOT NULL and have implicit DEFAULT clauses. The old behavior is deprecated.
- Командная строка:
--explicit-defaults-for-timestamp=[={0|1}]
- Область: Глобальный
- Динамический: Нет
- Тип данных:
bolean
- По умолчанию:
OFF
- Введено: MariaDB 10.1.8
external_user
- Описание: External user name set by the plugin used to authenticate the client.
NULL
if native MariaDB authentication is used. - Область: Сессия
- Динамический: Нет
- Тип данных:
string
- По умолчанию:
NULL
- Введено: MariaDB 5.5
flush
- Описание: Usually, MariaDB writes changes to disk after each SQL statement, and the operating system handles synchronizing (flushing) it to disk. If set to
ON
, the server will synchronize all changes to disk after each statement. - Командная строка:
--flush
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
flush_time
- Описание: Interval in seconds that tables are closed to synchronize (flush) data to disk and free up resources. If set to 0, the default, there is no automatic synchronizing tables and closing of tables. This option should not be necessary on systems with sufficient resources.
- Командная строка:
--flush_time=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
foreign_key_checks
- Описание: If set to 1 (the default) foreign key constraints (including ON UPDATE and ON DELETE behavior) InnoDB tables are checked, while if set to 0, they are not checked.
0
is not recommended for normal use, though it can be useful in situations where you know the data is consistent, but want to reload data in a different order from that that specified by parent/child relationships. Setting this variable to 1 does not retrospectively check for inconsistencies introduced while set to 0. - Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
1
ft_boolean_syntax
- Описание: List of operators supported by an IN BOOLEAN MODE full-text search. If you wish to change, note that each character must be ASCII and non-alphanumeric, the full string must be 14 characters and the first or second character must be a space. Positions 10, 13 and 14 are reserved for future extensions. Also, no duplicates are permitted except for the phrase quoting characters in positions 11 and 12, which may be the same.
- Командная строка:
--ft-boolean-syntax=name
- Область: Глобальный
- Динамический: Да
- Тип данных:
string
- По умолчанию:
+ -><()*:""&|
ft_max_word_len
- Описание: Maximum length for a word to be included in the MyISAM full-text index. If this variable is changed, the full-text index must be rebuilt. The quickest way to do this is by issuing a
REPAIR TABLE table_name QUICK
statement. See innodb_ft_max_token_size for the InnoDB equivalent. - Командная строка:
--ft-max-word-len=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
84
- Minimum Value:
10
ft_min_word_len
- Описание: Minimum length for a word to be included in the MyISAM full-text index. If this variable is changed, the full-text index must be rebuilt. The quickest way to do this is by issuing a
REPAIR TABLE table_name QUICK
statement. See innodb_ft_min_token_size for the InnoDB equivalent. - Командная строка:
--ft-min-word-len=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
4
- Minimum Value:
1
ft_query_expansion_limit
- Описание: For full-text searches, denotes the numer of top matches when using WITH QUERY EXPANSION.
- Командная строка:
--ft-query-expansion-limit=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
20
- Диапазон:
0
-1000
ft_stopword_file
- Описание: File containing a list of stopwords for use in MyISAM full-text searches. Unless an absolute path is specified the file will be looked for in the data directory. The file is not parsed for comments, so all words found become stopwords. By default, a built-in list of words (built from
storage/myisam/ft_static.c file
) is used. Stopwords can be disabled by setting this variable to''
(an empty string). If this variable is changed, the full-text index must be rebuilt. The quickest way to do this is by issuing aREPAIR TABLE table_name QUICK
statement. See innodb_ft_server_stopword_table for the InnoDB equivalent. - Командная строка:
--ft-stopword-file=file_name
- Область: Глобальный
- Динамический: Нет
- Тип данных:
file name
- По умолчанию:
(built-in)
general_log
- Описание: If set to 0, the default unless the --general-log option is used, the general query log is disabled, while if set to 1, the general query log is enabled. See log_output for how log files are written. If that variable is set to
NONE
, no logs will be written even if general_query_log is set to1
. - Командная строка:
--general-log
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
0
general_log_file
- Описание: Name of the general query log file. If this is not specified, the name is taken from the log-basename setting or from your system hostname with
.log
as a suffix. - Командная строка:
--general-log-file=file_name
- Область: Глобальный
- Динамический: Да
- Тип данных:
file name
- По умолчанию:
host_name.log
group_concat_max_len
- Описание: Maximum length in bytes of the returned result for a GROUP_CONCAT() function.
- Командная строка:
--group-concat-max-len=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1048576
(1M) >= MariaDB 10.2.41024
(1K) <= MariaDB 10.2.3
- Диапазон - 32-bit:
4
-4294967295
- Диапазон - 64-bit:
4
-18446744073709547520
have_compress
- Описание: If the zlib compression library is accessible to the server, this will be set to
YES
, otherwise it will beNO
. The COMPRESS() and UNCOMPRESS() functions will only be available if set toYES
. - Область: Глобальный
- Динамический: Нет
have_crypt
- Описание: If the crypt() system call is available this variable will be set to
YES
, otherwise it will be set toNO
. If set toNO
, the ENCRYPT() function cannot be used. - Область: Глобальный
- Динамический: Нет
have_csv
- Описание: If the server supports CSV tables, will be set to
YES
, otherwise will be set toNO
. - Область: Глобальный
- Динамический: Нет
have_dynamic_loading
- Описание: If the server supports dynamic loading of plugins, will be set to
YES
, otherwise will be set toNO
. - Область: Глобальный
- Динамический: Нет
have_geometry
- Описание: If the server supports spatial data types, will be set to
YES
, otherwise will be set toNO
. - Область: Глобальный
- Динамический: Нет
have_ndbcluster
- Описание: If the server supports NDBCluster (currently disabled in MariaDB).
- Область: Глобальный
- Динамический: Нет
have_partitioning
- Описание: If the server supports partitioning, will be set to
YES
, unless the--skip-partition
option is used, in which case will be set toDISABLED
. Will be set toNO
otherwise. Removed inMariaDB 10.0
- SHOW PLUGINS should instead be used. - Область: Глобальный
- Динамический: Нет
- Удалено:
MariaDB 10.0
have_profiling
- Описание: If statement profiling is available, will be set to
YES
, otherwise will be set toNO
. See SHOW PROFILES() and SHOW PROFILE(). - Область: Глобальный
- Динамический: Нет
have_query_cache
- Описание: If the server supports the query cache, will be set to
YES
, otherwise will be set toNO
. - Область: Глобальный
- Динамический: Нет
have_rtree_keys
- Описание: If RTREE indexes (used for spatial indexes in MyISAM tables) are available, will be set to
YES
, otherwise will be set toNO
. - Область: Глобальный
- Динамический: Нет
have_symlink
- Описание: If symbolic link support is enabled, will be set to
YES
, otherwise will be set toNO
. Required for the INDEX DIRECTORY and DATA DIRECTORY table options (see CREATE TABLE) and Windows symlink support. Will be set toDISABLED
if the server is started with the --skip-symbolic-links option. - Область: Глобальный
- Динамический: Нет
histogram_size
- Описание: Number of bytes used for a histogram. If set to 0, no histograms are created by ANALYZE.
- Командная строка:
--histogram-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
- Диапазон:
0
-255
- Введено: MariaDB 10.0.2
histogram_type
- Описание: Specifies the type of histograms created by ANALYZE.
SINGLE_PREC_HB
- single precision height-balanced.DOUBLE_PREC_HB
- double precision height-balanced.
- Командная строка:
--histogram-type=value
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enumeration
- По умолчанию:
SINGLE_PREC_HB
- Допустимые значения:
SINGLE_PREC_HB
,DOUBLE_PREC_HB
- Введено: MariaDB 10.0.2
host_cache_size
- Описание: Number of host names that will be cached to avoid resolving. Setting to
0
disables the cache. Changing the value while the server is running causes an implicit FLUSH HOSTS, clearing the host cache and truncating the performance_schema.host_cache table. - Командная строка:
--host-cache-size=#
. - Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
128
- Диапазон:
0
-65536
- Введено: MariaDB 10.0
hostname
- Описание: Когда сервер запускается, этот параметр заполнится именем хоста сервера
- Область: Глобальный
- Динамический: Нет
- Тип данных:
string
identity
- Описание: Синоним переменной last_insert_id
ignore_db_dirs
- Описание: Comma-delimited list of directories in the data directory that are not considered as database directories. Set from --ignore-db-dir at startup.
- Область: Глобальный
- Динамический: Нет
- Тип данных:
string
- Введено: MariaDB 5.5
in_transaction
- Описание: Сессия-only and read-only variable that is set to
1
if you are in a transaction, and0
if not. - Командная строка: Нет
- Область: Сессия
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
0
- Введено: MariaDB 5.3
init_connect
- Описание: String containing one or more SQL statements, separated by semicolons, that will be executed by the server for each client connecting. If there's a syntax error in the one of the statements, the client will fail to connect. For this reason, the statements are not executed for users with the SUPER privilege, who can then still connect and correct the error. See also init_file.
- Командная строка:
--init-connect=name
- Область: Глобальный
- Динамический: Да
- Тип данных:
string
init_file
- Описание: Name of a file containing SQL statements that will be executed by the server on startup. Each statement should be on a new line. See also init_connect.
- Командная строка:
init-file=file_name
- Область: Глобальный
- Динамический: Нет
- Тип данных:
file name
insert_id
- Описание: Value to be used for the next statement inserting a new AUTO_INCREMENT value.
- Область: Сессия
- Динамический: Да
- Тип данных:
numeric
interactive_timeout
- Описание: Time in seconds that the server waits for an interactive connection (one that connects with the mysql_real_connect() CLIENT_INTERACTIVE option) to become active before closing it. See also wait_timeout.
- Командная строка:
--interactive-timeout=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
28800
- Minimum Value:
1
join_buffer_size
- Описание: Minimum size in bytes of the buffer used for queries that cannot use an index, and instead perform a full table scan. Increase to get faster full joins when adding indexes is not possible, although be aware of memory issues, since joins will always allocate the minimum size. Best left low globally and set high in sessions that require large full joins. In 64-bit platforms, Windows truncates values above 4GB to 4GB with a warning.
- Командная строка:
--join-buffer-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
262144
(256kB) (>=MariaDB 10.1.7),131072
(128kB) (<=MariaDB 10.1.6) - Range (>=MariaDB/MySQL 5.5):
128
-18446744073709547520
- Range (<=MariaDB/MySQL 5.3, Windows):
8228
-18446744073709547520
join_buffer_space_limit
- Описание: Maximum size in bytes of the query buffer, By default 1024*128*10. See Block-based join algorithms.
- Командная строка:
--join-buffer-space-limit=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
2097152
- Диапазон:
2048
-99999999997952
- Введено: MariaDB 5.3
join_cache_level
- Описание: Controls which of the eight block-based algorithms can be used for join operations. See Block-based join algorithms for more information.
- 1 – flat (Block Nested Loop) BNL
- 2 – incremental BNL
- 3 – flat Block Nested Loop Hash (BNLH)
- 4 – incremental BNLH
- 5 – flat Batch Key Access (BKA)
- 6 – incremental BKA
- 7 – flat Batch Key Access Hash (BKAH)
- 8 – incremental BKAH
- Командная строка:
--join-cache-level=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
2
- Диапазон:
0
-8
- Введено: MariaDB 5.3
keep_files_on_create
- Описание: If a MyISAM table is created with no DATA DIRECTORY option, the .MYD file is stored in the database directory. When set to
0
, the default, if MariaDB finds another .MYD file in the database directory it will overwrite it. Setting this variable to1
means that MariaDB will return an error instead, just as it usually does in the same situation outside of the database directory. The same applies for .MYI files and no INDEX DIRECTORY option. - Командная строка:
--keep-files-on-create=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
language
- Описание: Language to use for the server error messages. Either just the language name, or the directory where the error messages are stored. An alternative is to use lc_messages_dir and lc_messages instead. See Setting the language for error messages.
- Командная строка:
--language=name
,-L
- Область: Глобальный
- Динамический: Нет
- Тип данных:
directory name
- По умолчанию:
/usr/local/mysql/share/mysql/english/
large_files_support
- Описание: ON if the server if was compiled with large file support or not, else OFF
- Область: Глобальный
- Динамический: Нет
- Введено: MySQL 3.23.28
large_page_size
- Описание: Indicates the size of memory page if large page support (Linux only) is enabled. The page size is determined from the Hugepagesize setting in
/proc/meminfo
. See large_pages. - Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию: Autosized (смотрите описание)
large_pages
- Описание: Indicates whether large page support (Linux only - called huge pages) is used. This is set with
--large-pages
or disabled with--skip-large-pages
. Large pages are used for the innodb buffer pool and for online DDL (of size 3* innodb_sort_buffer_size (or 6 when encryption is used)). To use large pages, the Linuxsysctl
variablevm.nr_hugepages
multipled by large-page) must be larger than the usage. The ulimit for locked memory must be sufficient to cover the amount used (ulimit -l
and equalivent in /etc/security/limits.conf / or in systemd LimitMEMLOCK). If these operating system controls or insufficient free huge pages are available, the allocation of large pages will fall back to conventional memory allocation and a warning will appear in the logs. - Командная строка:
--large-pages
,--skip-large-pages
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
OFF
last_insert_id
- Описание: Contains the same value as that returned by LAST_INSERT_ID(). Note that setting this variable doen't update the value returned by the underlying function.
- Область: Сессия
- Динамический: Да
- Тип данных:
numeric
lc_messages
- Описание: Locale to use for error messages. This will be converted to a language name and along with lc_messages_dir will produce the location for the error message file. See locales for a list of available locales and their related languages.
- Командная строка:
--lc-messages=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
en_us
- Введено: MariaDB 5.5
lc_messages_dir
- Описание: Directory where the error messages are located. Together with lc_messages will produce the location for the error message file.
- Командная строка:
--lc-messages-dir=path
- Область: Глобальный
- Динамический: Нет
- Тип данных:
directory name
- Введено: MariaDB 5.5
lc_time_names
- Описание: The locale that determines the language used for the date and time functions DAYNAME(), MONTHNAME() and DATE_FORMAT(). Locale names are language and region subtags, for example 'en_ZA' (English - South Africa) or 'es_US: Spanish - United States'. The default is always 'en-US' regardless of the system's locale setting. See server locale for a full list of supported locales.
- Командная строка:
--lc-time-names=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
en_US
- Введено: MySQL 5.1.12
license
- Описание: Лиценция сервера, например
GPL
. - Область: Глобальный
- Динамический: Нет
- Тип данных:
string
local_infile
- Описание: If set to
1
, LOCAL is supported for LOAD DATA INFILE statements. If set to0
, usually for security reasons, attempts to perform a LOAD DATA LOCAL will fail with an error message. - Командная строка:
--local-infile=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
ON
lock_wait_timeout
- Описание: Timeout in seconds for attempts to acquire metadata locks. Statements using metadata locks include FLUSH TABLES WITH READ LOCK, LOCK TABLES, HANDLER and DML and DDL operations on tables, stored procedures and functions, and views. The timeout is separate for each attempt, of which there may be multiple in a single statement.
0
(from MariaDB 10.3.0) means no wait. See WAIT and NOWAIT. - Командная строка:
--lock-wait-timeout=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
86400
(1 день) >= MariaDB 10.2.431536000
(1 год) <= MariaDB 10.2.3
- Диапазон:
0
-31536000
(>= MariaDB 10.3)1
-31536000
(<= MariaDB 10.2)
- Введено: MariaDB 5.5
locked_in_memory
- Описание: Indicates whether --memlock was used to lock mysqld in memory.
- Командная строка:
--memlock
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
OFF
log
- Описание: Устарел и удален в MariaDB 10.0, вместо этого параметра используйте general_log
- Командная строка:
-l [filename]
or--log[=filename]
- Область: Глобальный
- Динамический: Да
- Тип данных:
string
- По умолчанию:
OFF
- Устарел:
MySQL 5.1.29
, заменен на general_log - Удалено:
MariaDB 10.0
log_error
- Описание: Specifies the name of the error log. If --console is specified later in the configuration (Windows only) or this option isn't specified, errors will be logged to stderr. If no name is provided, errors will still be logged to
hostname.err
. - Командная строка:
--log-error[=name]
- Область: Глобальный
- Динамический: Нет
- Тип данных:
file name
- По умолчанию:
(пустая строка)
log_output
- Описание: How the output for the general query log and the slow query log is stored. By default written to file (
FILE
), it can also be stored in the general_log and slow_log tables in the mysql database (TABLE
), or not stored at all (NONE
). More than one option can be chosen at the same time, withNONE
taking precedence if present. Logs will not be written if logging is not enabled. See Writing logs into tables, and the slow_query_log and general_log server system variables. - Командная строка:
--log-output=name
- Область: Глобальный
- Динамический: Да
- Тип данных:
set
- По умолчанию:
FILE
- Допустимые значения:
TABLE
,FILE
илиNONE
log_queries_not_using_indexes
- Описание: Queries that don't use an index, or that perform a full index scan where the index doesn't limit the number of rows, will be logged to the slow query log (regardless of time taken). The slow query log needs to be enabled for this to have an effect.
- Командная строка:
--log-queries-not-using-indexes
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
log_slow_admin_statements
- Описание: Log slow OPTIMIZE, ANALYZE, ALTER and other administrative statements to the slow log if it is open. Before MariaDB 10.1.13, this was only available as a mysqld option, not a server variable.
- Командная строка:
--log-slow-admin-statements
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
ON
(>= MariaDB 10.2.4)OFF
(<= MariaDB 10.2.3)
- Введено: MariaDB 10.1.13 (переменная)
log_slow_filter
- Описание: Comma-delimited string containing one or more settings for filtering what is logged to the slow query log. If a query matches one of the types listed in the filter, and takes longer than long_query_time, it will be logged. Sets log-slow-admin-statements to ON.
admin
log administrative queries (create, optimize, drop etc...)filesort
logs queries that use a filesort.filesort_on_disk
logs queries that perform a a filesort on disk.full_join
logs queries that perform a join without indexes.full_scan
logs queries that perform full table scans.query_cache
log queries that are resolved by the query cache .query_cache_miss
logs queries that are not found in the query cache.tmp_table
logs queries that create an implicit temporary table.tmp_table_on_disk
logs queries that create a temporary table on disk.
- Командная строка:
log-slow-filter=value1[,value2...]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enumeration
- По умолчанию:
admin
,filesort
,filesort_on_disk
,full_join
,full_scan
,query_cache
,query_cache_miss
,tmp_table
,tmp_table_on_disk
- Допустимые значения:
admin
,filesort
,filesort_on_disk
,full_join
,full_scan
,query_cache
,query_cache_miss
,tmp_table
,tmp_table_on_disk
log_slow_queries
- Описание: Deprecated and removed in MariaDB 10.0, use slow_query_log instead.
- Командная строка:
--log-slow-queries[=name]
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
- Устарел: MySQL 5.1.29
- Удалено: MariaDB 10.0/MySQL 5.6.1
log_slow_rate_limit
- Описание: The slow query log will log every this many queries. The default is
1
, or every query, while setting it to20
would log every 20 queries, or five percent. Aims to reduce I/O usage and excessively large slow query logs. See also Slow Query Log Extended Statistics. - Командная строка:
log-slow-rate-limit=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1
- Диапазон: от
1
и выше - Введено: MariaDB 5.1
log_slow_slave_statements
- Описание: Log slow statements executed by slave thread to the slow log if it is open. Before MariaDB 10.1.13, this was only available as a mysqld option, not a server variable.
- Командная строка:
--log-slow-slave-statements
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
ON
(>= MariaDB 10.2.4)OFF
(<= MariaDB 10.2.3)
- Введено: MariaDB 10.1.13 (переменная)
log_slow_verbosity
- Описание: Controls information to be added to the slow query log. Options are added in a comma-delimited string. See also Slow Query Log Extended Statistics.
query_plan
logs query execution plan informationinnodb
logs XtraDB/InnoDB statisticsexplain
prints EXPLAIN output in the slow query log. See EXPLAIN in the Slow Query Log. (added in MariaDB 10.0.5)
- Командная строка:
log-slow-verbosity=value1[,value2...]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enumeration
- По умолчанию:
query_plan
- Допустимые значения:
query_plan
,innodb
,explain
(>= MariaDB 10.0.5) - Введено: MariaDB 5.1
log_tc_size
- Описание: Size in bytes of the transaction coordinator log, defined in multiples of 4096. Always available as a commandline option, but added as a variable in MariaDB 10.1.3
- Командная строка:
log-tc-size=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
24576
- Диапазон:
12288
-18446744073709551615
- Введено: MariaDB 10.1.3 (переменная)
log_warnings
- Описание: If set to
1
, the default, all critical warnings are logged to the error log. Slave servers also log status information, including the binary log and relay log co-ordinates where they start replicating from, reconnects after a disconnect and when the slave switches to a new relay-log. If set to0
, warnings are not logged. If set to a number greater than1
, aborted connections and access-denied errors are also logged. Specifically, the following are logged:- log_warnings >= 1
- Events_scheduler info and warnings
- Access denied errors
- Connections that were forced to be closed or aborted
- System signals
- Wrong usage of
--user
- Failed setrlimit() and mlockall()
- Changed limits
- Wrong values of lower_case_table_names and stack_size
- Wrong values for command line options
- Start log position and some master information when starting slaves
- Slave reconnects
- Killed slaves
- Error reading relay logs
- Before MariaDB 10.0.14: Statements that were unsafe to log as statement-based (when BINLOG_FLAG_UNSAFE_STMT_PRINTED is also set)
- Disabled plugins that one tried to enable or use
- UDF files that didn't include the required init functions.
- log_warnings >= 2
- Table handler errors
- Starting from MariaDB 10.0.14: Statements that were unsafe to log as statement-based (when BINLOG_FLAG_UNSAFE_STMT_PRINTED is also set)
- log_warnings >= 3
- All errors and warnings during MyISAM repair and auto recover.
- log_warnings >= 1
- Командная строка:
-W [level]
or--log-warnings[=level]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
2
(>= MariaDB 10.2.4)1
(<= MariaDB 10.2.3)
- Диапазон:
0
-4294967295
long_query_time
- Описание: If a query takes longer than this many seconds to execute (microseconds can be specified too), the Slow_queries status variable is incremented and, if enabled, the query is logged to the slow query log.
- Командная строка:
--long-query-time=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
10.000000
>= MariaDB 10.1.13,10
<= MariaDB 10.1.12 - Диапазон: с
0
и выше
low_priority_updates
- Описание: If set to 1 (0 is the default), for storage engines that use only table-level locking (Aria, MyISAM, MEMORY and MERGE), all INSERTs, UPDATEs, DELETEs and LOCK TABLE WRITEs will wait until there are no more SELECTs or LOCK TABLE READs pending on the relevant tables. Set this to 1 if reads are prioritized over writes. Previously named sql_low_priority_updates, which is still a synonym.
- Командная строка:
--low-priority-updates
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
0
lower_case_file_system
- Описание: Read-only variable describing whether the file system is case-sensitive. If set to
OFF
, file names are case-sensitive. If set toON
, they are not case-sensitive. - Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
##
lower_case_table_names
- Описание: If set to
0
(the default on Unix-based systems), table names and aliases and database names are compared in a case-sensitive manner. If set to1
(the default on Windows), names are stored in lowercase and not compared in a case-sensitive manner. If set to2
(the default on Mac OS X), names are stored as declared, but compared in lowercase. - Командная строка:
--lower-case-table-names[=#]
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
0
(Unix),1
(Windows),2
(Mac OS X) - Диапазон:
0
-2
max_allowed_packet
- Описание: Maximum size in bytes of a packet or a generated/intermediate string. The packet message buffer is initialized with the value from net_buffer_length, but can grow up to max_allowed_packet bytes. Set as large as the largest BLOB, in multiples of 1024. If this value is changed, it should be changed on the client side as well. See slave_max_allowed_packet for a specific limit for replication purposes.
- Командная строка:
--max-allowed-packet=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
16777216
(16M) >= MariaDB 10.2.44194304
(4M) >= MariaDB 10.1.71048576
(1MB) <= MariaDB 10.1.61073741824
(1GB) (client-side)
- Диапазон:
1024
-1073741824
max_connect_errors
- Описание: Limit to the number of successive failed connects from a host before the host is blocked from making further connections. The count for a host is reset to zero if they successfully connect. To unblock, flush the host cache with a FLUSH HOSTS statement or mysqladmin flush-hosts.
- Командная строка:
--max-connect-errors=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
100
(>= MariaDB 10.0),10
(< MariaDB 10.0)
max_connections
- Описание: The maximum number of simultaneous client connections. See also Handling Too Many Connections. Note that this value affects the number of file descriptors required on the operating system.
- Командная строка:
--max-connections=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
151
- Диапазон:
1
-100000
max_delayed_threads
- Описание: Limits to the number of INSERT DELAYED threads. Once this limit is reached, the insert is handled as if there was no DELAYED attribute. If set to
0
, DELAYED is ignored entirely. The session value can only be set to0
or to the same as the global value. - Командная строка:
--max-delayed-threads=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
20
- Диапазон:
0
-16384
max_digest_length
- Описание: Maximum length considered for computing a statement digest, such as used by the Performance Schema and query rewrite plugins. Statements that differ after this many bytes produce the same digest, and are aggregated for statistics purposes. The variable is allocated per session. Increasing will allow longer statements to be distinguished from each other, but increase memory use, while decreasing will reduce memory use, but more statements may become indistinguishable.
- Командная строка:
--max-digest-length=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1024
- Диапазон:
0
-1048576
- Введено: MariaDB 10.1.5
max_error_count
- Описание: Specifies the maximum number of messages stored for display by SHOW ERRORS and SHOW WARNINGS statements.
- Командная строка:
--max-error-count=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
64
- Диапазон:
0
-65535
max_heap_table_size
- Описание: Maximum size in bytes for user-created MEMORY tables. Setting the variable while the server is active has no effect on existing tables unless they are recreated or altered. The smaller of max_heap_table_size and tmp_table_size also limits internal in-memory tables. When the maximum size is reached, any further attempts to insert data will receive a "table ... is full" error. Temporary tables created with CREATE TEMPORARY will not be converted to Aria, as occurs with internal temporary tables, but will also receive a table full error.
- Командная строка:
--max-heap-table-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
16777216
- Range :
16384
-4294966272
max_insert_delayed_threads
- Описание: Синоним max_delayed_threads.
max_join_size
- Описание: Statements will not be performed if they are likely to need to examine more than this number of rows, row combinations or do more disk seeks. Can prevent poorly-formatted queries from taking server resources. Changing this value to anything other the default will reset sql_big_selects to 0. If sql_big_selects is set again, max_join_size will be ignored. This limit is also ignored if the query result is sitting in the query cache. Previously named sql_max_join_size, which is still a synonym.
- Командная строка:
--max-join-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
18446744073709551615
(>= MariaDB/MySQL 5.5.0),4294967295
(< MariaDB/MySQL 5.5.0) - Диапазон:
1
-18446744073709551615
(>= MariaDB/MySQL 5.5.0),1
-4294967295
(< MariaDB/MySQL 5.5.0)
max_length_for_sort_data
- Описание: Used to decide which algorithm to choose when sorting rows. If the total size of the column data, not including columns that are part of the sort, is less than
max_length_for_sort_data
, then we add these to the sort key. This can speed up the sort as we don't have to re-read the same row again later. Setting the value too high can slow things down as there will be a higher disk activity for doing the sort. - Командная строка:
--max-length-for-sort-data=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1024
- Диапазон:
4
-8388608
max_long_data_size
- Описание: Maximum size for parameter values sent with mysql_stmt_send_long_data(). If not set, will default to the value of max_allowed_packet.
- Командная строка:
--max-long-data-size=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
16777216
(>= MariaDB 10.2.4)4194304
(<= MariaDB 10.2.3, >= MariaDB 10.1.7)1048576
(<= MariaDB 10.1.6)
- Диапазон:
1024
-4294967295
- Введено: MariaDB 5.5
max_prepared_stmt_count
- Описание: Maximum number of prepared statements on the server. Can help prevent certain forms of denial-of-service attacks. If set to
0
, no prepared statements are permitted on the server. - Командная строка:
--max-prepared-stmt-count=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
16382
- Диапазон:
0
-1048576
max_recursive_iterations
- Описание: Maximum number of iterations when executing recursive queries.
- Командная строка:
--max-recursive-iterations=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
4294967295
- Диапазон:
0
-4294967295
- Введено: MariaDB 10.2.2
max_seeks_for_key
- Описание: The optimizer assumes that the number specified here is the most key seeks required when searching with an index, regardless of the actual index cardinality. If this value is set lower than its default and maximum, indexes will tend to be preferred over table scans.
- Командная строка:
--max-seeks-for-key=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
4294967295
- Диапазон:
1
-4294967295
max_session_mem_used
- Описание: Amount of memory a single user session is allowed to allocate. This limits the value of the session variable MEM_USED.
- Командная строка:
--max-session-mem-used=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
9223372036854775807
(8.6GB) - Диапазон:
8192
-18446744073709551615
- Введено: MariaDB 10.1.21
max_sort_length
- Описание: Maximum size in bytes used for sorting data values - anything exceeding this is ignored.
- Командная строка:
--max-sort-length=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1024
- Диапазон:
4
-8388608
max_sp_recursion_depth
- Описание: Permitted number of recursive calls for a stored procedure.
0
, the default, no recursion is permitted. Increasing this value increases the thread stack requirements, so you may need to increase thread_stack as well. This limit doesn't apply to stored functions. - Командная строка:
--max-sp-recursion-depth[=#]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
- Диапазон:
0
-255
max_statement_time
- Описание: Maximum time in seconds that a query can execute before being aborted. This includes all queries, not just SELECT statements, but excludes statements in stored procedures. If set to 0, no limit is applied. See Aborting statements that take longer than a certain time to execute. Useful when combined with SET STATEMENT for limiting the execution times of individual queries.
- Командная строка:
--max-statement-time[=#]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0.000000
>= MariaDB 10.1.13,0
<= MariaDB 10.1.12 - Диапазон: от
0
и выше - Введено: MariaDB 10.1.1
max_tmp_tables
- Описание: Неиспользуется
max_user_connections
- Описание: Maximum simultaneous connections permitted for a user account. If set to
0
, the default, there is no per-user limit. The session value is read-only and takes the global value unless there's a nonzero MAX_USER_CONNECTIONS value for the user. Previously having a minimum value of0
, from MariaDB 5.3, max_user_connections can be set to -1 to stop users from connecting to the server. The global max_user_connections variable does not affect users with the SUPER privilege. - Командная строка:
--max-user-connections=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
- Диапазон:
-1
-4294967295
max_write_lock_count
- Описание: Read lock requests will be permitted for processing after this many write locks. Applies only to storage engines that use table level locks (thr_lock), so no effect with InnoDB/XtraDB or [archive|Archive]].
- Командная строка:
--max-write-lock-count=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
4294967295
- Диапазон:
0-4294967295
metadata_locks_cache_size
- Описание: Size of the metadata locks cache, used for reducing the need to create and destroy synchronization objects. It is particularly helpful on systems where this process is inefficient, such as Windows XP.
- Командная строка:
--metadata-locks-cache-size=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
1024
- Диапазон:
1
-1048576
- Введено: MariaDB 5.5
metadata_locks_hash_instances
- Описание: Number of hashes used by the set of metadata locks. The metadata locks are partitioned into separate hashes in order to reduce contention.
- Командная строка:
--metadata-locks-hash-instances=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
8
- Диапазон:
1
-1024
- Введено: MariaDB 10.0
min_examined_row_limit
- Описание: If a query examines more than this number of rows, it is logged to the slow-query-log. If set to
0
, the default, no row limit is used. - Командная строка:
--min-examined-row-limit=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
- Диапазон:
0-4294967295
mrr_buffer_size
- Описание: Size of buffer to use when using multi-range read with range access. See Multi Range Read optimization for more information.
- Командная строка:
--mrr-buffer-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
262144
- Диапазон:
8192
-2147483648
- Введено: MariaDB 5.3
multi_range_count
- Описание: Устарел в 5.1 и игнорируется в MariaDB 5.3. Вместо этой переменной используйте mrr_buffer_size
- По умолчанию:
256
- Удален:
MariaDB 5.5
mysql56_temporal_format
- Описание: If set, MariaDB uses the MySQL-5.6 low level formats for TIME, DATETIME and TIMESTAMP instead of the MariaDB 5.3+ version.
- Командная строка:
--mysql56-temporal-format
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
ON
- Введено: MariaDB 10.1.2
named_pipe
- Описание: On Windows systems, determines whether connections over named pipes are permitted.
- Командная строка:
--enable-named-pipe
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
OFF
net_buffer_length
- Описание: The starting size, in bytes, for the connection and thread buffers for each client thread. The size can grow to max_allowed_packet. This variable's session value is read-only. Can be set to the expected length of client statements if memory is a limitation.
- Командная строка:
--net-buffer-length=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
16384
- Диапазон:
1024
-1048576
net_read_timeout
- Описание: Time in seconds the server will wait for a client connection to send more data before aborting the read. See also net_write_timeout and slave_net_timeout
- Командная строка:
--net-read-timeout=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
30
- Диапазон:
1
upwards
net_retry_count
- Описание: Permit this many retries before aborting when attempting to read or write on a communication port. On FreeBSD systems should be set higher as threads are sent internal interrupts..
- Командная строка:
--net-retry-count=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
10
- Диапазон:
1
-4294967295
net_write_timeout
- Описание: Time in seconds to wait on writing a block to a connection before aborting the write. See also net_read_timeout and slave_net_timeout.
- Командная строка:
--net-write-timeout=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
60
- Диапазон:
1
upwards
old
- Описание: Disabled by default, enabling it reverts index hints to those used before MySQL 5.1.17. Enabling may lead to replication errors. Being replaced by old_mode. Before MariaDB 5.5, the variable was read-only and global in scope only.
- Командная строка:
--old
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
old_alter_table
- Описание: If set to
1
(0
is default), MariaDB reverts to the non-optimized, pre-MySQL 5.0, method of processing ALTER TABLE statements. - Командная строка:
--old-alter-table
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
old_mode
- Описание: Used for getting MariaDB to emulate behavior from an old version of MySQL or MariaDB. See OLD Mode. Will be used to replace the old variable over time.
- Командная строка:
--old-mode
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
(empty string)
- Введено: MariaDB 5.5.35
- Допустимые значения: See OLD Mode for the full list.
old_passwords
- Описание: If set to
1
(0
is default), MariaDB reverts to the pre-MySQL 4.1 form of password hashing. - Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
open_files_limit
- Описание: The number of file descriptors available to mysqld. Increase if you are getting the
Too many open files
error. If set to 0, then mysqld will reserve max_connections*5 or max_connections + table_open_cache*2 (whichever is larger) number of files. Note that MariaDB cannot set this to exceed the hard limit imposed by the operating system, and you may need to change this. For example, by adding the following lines to/etc/security/limits.conf
mysql soft nofile 65535 mysql hard nofile 65535
rebooting, and then create /etc/systemd/system/mysqld.service.d/filelimit.conf
or /etc/systemd/system/mariadb.service.d/filelimit.conf
(corresponding to the service name).
[service] LimitNOFILE=infinity
- Командная строка:
--open-files-limit=count
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию: Autosized (see description)
- Диапазон:
0
-4294967295
optimizer_prune_level
- Описание: If set to
1
, the default, the optimizer will use heuristics to prune less-promising partial plans from the optimizer search space. If set to0
, heuristics are disabled and an exhaustive search is performed. - Командная строка:
--optimizer-prune-level[=#]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
1
optimizer_search_depth
- Описание: Maximum search depth by the query optimizer. Smaller values lead to less time spent on execution plans, but potentially less optimal results. If set to
0
, MariaDB will automatically choose a reasonable value. Since the better results from more optimal planning usually offset the longer time spent on planning, this is set as high as possible by default. - Командная строка:
--optimizer-search-depth[=#]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
62
- Диапазон:
0
-62
optimizer_selectivity_sampling_limit
- Описание: Controls number of record samples to check condition selectivity
- Командная строка:
optimizer-selectivity-sampling-limit[=#]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
100
- Диапазон:
10
upwards - Введено: MariaDB 10.0
optimizer_switch
- Описание: A series of flags for controlling the query optimizer.
- Командная строка:
--optimizer-switch=value
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- Допустимые значения:
condition_pushdown_for_derived={on|off}
(>=MariaDB 10.2.2)default
- set all optimizations to their default values.derived_merge={on|off}
(>=MariaDB 5.3) - see Derived table merge optimizationderived_with_keys={on|off}
(>=MariaDB 5.3) - see Derived table with key optimizationengine_condition_pushdown={on|off}
(>=MariaDB 5.5, <=MariaDB 10.1.1)exists_to_in={on|off}
(>=MariaDB 10.0) - see EXISTS-to-IN optimizationextended_keys={on|off}
(>= MariaDB 5.5) - see Extended Keysfirstmatch={on|off}
(>=MariaDB 5.3) - see First Match Strategyindex_condition_pushdown={on|off}
(>=MariaDB 5.3) - see Index Condition Pushdownindex_merge={on|off}
index_merge_intersection={on|off}
index_merge_sort_intersection={on|off}
(>=MariaDB 5.3) - more detailsindex_merge_sort_union={on|off}
index_merge_union={on|off}
in_to_exists={on|off}
(>=MariaDB 5.3) - see IN-TO-EXISTS transformationjoin_cache_bka={on|off}
(>=MariaDB 5.3) - see Block-Based Join Algorithmsjoin_cache_hashed={on|off}
(>=MariaDB 5.3) - see Block-Based Join Algorithmsjoin_cache_incremental={on|off}
(>=MariaDB 5.3) - see Block-Based Join Algorithmsloosescan={on|off}
(>=MariaDB 5.3) - see LooseScan strategymaterialization={on|off}
(>=MariaDB 5.3) - Semi-join and non semi-join materialization.mrr={on|off}
(>=MariaDB 5.3) - see Multi Range Read optimizationmrr_cost_based={on|off}
(>=MariaDB 5.3) - see Multi Range Read optimizationmrr_sort_keys={on|off}
(>=MariaDB 5.3) - see Multi Range Read optimizationoptimize_join_buffer_size={on|off}
(>=MariaDB 5.3) - see Block-Based Join Algorithmsorderby_uses_equalities={on|off}
(>= MariaDB 10.1.15, MariaDB 10.2.1) - if not set, the optimizer ignores equality propagation. See MDEV-8989.outer_join_with_cache={on|off}
(>=MariaDB 5.3) - see Block-Based Join Algorithmspartial_match_rowid_merge={on|off}
(>= MariaDB 5.3) - see Non-semi-join subquery optimizationspartial_match_table_scan={on|off}
(>= MariaDB 5.3) - see Non-semi-join subquery optimizationssemijoin={on|off}
(>=MariaDB 5.3) - see Semi-join subquery optimizationssemijoin_with_cache={on|off}
(>=MariaDB 5.3) - see Block-Based Join Algorithmssubquery_cache={on|off}
(>=MariaDB 5.5) - see subquery cache.table_elimination={on|off}
(>=MariaDB 5.3) - see Table Elimination User Interface
optimizer_use_condition_selectivity
- Описание: Controls which statistics can be used by the optimizer when looking for
the best query execution plan.
1
Use selectivity of predicates as in MariaDB 5.5.2
Use selectivity of all range predicates supported by indexes.3
Use selectivity of all range predicates estimated without histogram.4
Use selectivity of all range predicates estimated with histogram.5
Additionally use selectivity of certain non-range predicates calculated on record sample.
- Командная строка:
--optimizer-use-condition-selectivity=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1
- Диапазон:
1
-5
- Введено: MariaDB 10.0
pam_use_cleartext_plugin
- Описание: Use mysql_cleartext_plugin on the client side instead of the dialog plugin. This may be needed for compatibility reasons, but it only supports simple PAM policies that don't require anything besides a password. See PAM Authentication Plugin.
- Командная строка:
<<code>>
--pam-use-cleartext-plugin</code>> - Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
OFF
- Введено: MariaDB 10.1.3 (default)
pid_file
- Описание: Full path of the process ID file.
- Командная строка:
--pid-file=file_name
- Область: Глобальный
- Динамический: Нет
- Тип данных:
file name
plugin_dir
- Описание: Path to the plugin directory. For security reasons, either make sure this directory can only be read by the server, or set secure_file_priv.
- Командная строка:
--plugin-dir=path
- Область: Глобальный
- Динамический: Нет
- Тип данных:
directory name
- По умолчанию:
BASEDIR/lib/plugin
- Введено: MariaDB 5.5
plugin_maturity
- Описание: The lowest acceptable plugin maturity. MariaDB will not load plugins less mature than that.
- Командная строка:
--plugin-maturity=level
- Область: Глобальный
- Динамический: Нет
- Тип данных: enum
- По умолчанию:
unknown
- Допустимые значения:
unknown
,experimental
,alpha
,beta
,gamma
,stable
- Введено: MariaDB 5.2.1
port
- Описание: Порт для прослушивания TCP/IP соединений. Если установлено значение
0
, то тогда будет использоваться порт встроенный по умолчанию (3306), MYSQL_TCP_PORT environment variable, /etc/services - Командная строка:
--port=#
,-P
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
3306
- Диапазон:
0
-65535
preload_buffer_size
- Описание: Size in bytes of the buffer allocated when indexes are preloaded.
- Командная строка:
--preload-buffer-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
32768
- Диапазон:
1024
-1073741824
profiling
- Описание: If set to
1
(0
is default), statement profiling will be enabled. See SHOW PROFILES() and SHOW PROFILE(). - Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
profiling_history_size
- Описание: Number of statements about which profiling information is maintained. If set to
0
, no profiles are stored. See SHOW PROFILES. - Командная строка:
--profiling-history-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
15
- Диапазон:
0
-100
progress_report_time
- Описание: Time in seconds between sending progress reports to the client for time-consuming statements. If set to
0
, progress reporting will be disabled. - Командная строка:
--progress-report-time=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
56
before MariaDB 5.5.39 and MariaDB 10.0.10,5
as of MariaDB 5.5.40 and MariaDB 10.0.11 - Диапазон:
0
-4294967295
- Введено: MariaDB 5.3
protocol_version
- Описание: Client/server protocol version number.
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- Диапазон:
-
proxy_user
- Описание: Set to the proxy user account name if the current client is a proxy, else
NULL
. - Область: Сессия
- Динамический: Нет
- Тип данных:
string
- Введено: MariaDB 5.5.20
pseudo_slave_mode
- Описание: For internal use by the server.
- Область: Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
OFF
- Введено: MariaDB/MySQL 5.5.30
pseudo_thread_id
- Описание: For internal use only.
- Область: Сессия
- Динамический: Да
- Тип данных:
numeric
query_alloc_block_size
- Описание: Size in bytes of the extra blocks allocated during query parsing and execution (after query_prealloc_size is used up).
- Командная строка:
--query-alloc-block-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
16384
(from MariaDB 10.1.2),8192
(before MariaDB 10.1.2) - Диапазон:
1024
-4294967295
query_cache_limit
- Описание: Size in bytes for which results larger than this are not stored in the query cache.
- Командная строка:
--query-cache-limit=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1048576
(1MB) - Диапазон:
0
-4294967295
query_cache_min_res_unit
- Описание: Minimum size in bytes of the blocks allocated for query cache results.
- Командная строка:
--query-cache-min-res-unit=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
4096
(4KB) - Диапазон:
0
-4294967295
query_cache_size
- Описание: Size in bytes available to the query cache. About 40KB is needed for query cache structures, so setting a size lower than this will result in a warning.
0
, the default before MariaDB 10.1.7, effectively disables the query cache. Starting from MariaDB 10.1.7, query_cache_type is automatically set to ON if the server is started with the query_cache_size set to a non-zero (and non-default) value. - Командная строка:
--query-cache-size=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
1M
(>= MariaDB 10.1.7),0
(<= MariaDB 10.1.6) (although frequently given a default value in some setups) - Допустимые значения:
0
upwards in units of 1024.
query_cache_strip_comments
- Описание: If set to
1
(0
is default), the server will strip any comments from the query before searching to see if it exists in the query cache. Multiple space, line feeds, tab and other white space characters will also be removed. - Командная строка:
query-cache-strip-comments
- Область: Сессия (from MariaDB 5.5.20), Global
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
query_cache_type
- Описание: If set to
0
, the query cache is disabled (although a buffer of query_cache_size bytes is still allocated). If set to1
all SELECT queries will be cached unless SQL_NO_CACHE is specified. If set to2
(orDEMAND
), only queries with the SQL CACHE clause will be cached. Note that if the server is started with the query cache disabled, it cannot be enabled at runtime. Starting from MariaDB 10.1.7, query_cache_type is automatically set to ON if the server is started with the query_cache_size set to a non-zero (and non-default) value. - Командная строка:
--query-cache-type=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enumeration
- По умолчанию:
OFF
(>= MariaDB 10.1.7),ON
(<= MariaDB 10.1.6) - Допустимые значения:
0
orOFF
,1
orON
,2
orDEMAND
query_cache_wlock_invalidate
- Описание: If set to
0
, the default, results present in the query cache will be returned even if there's a write lock on the table. If set to1
, the client will first have to wait for the lock to be released. - Командная строка:
--query-cache-wlock-invalidate
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
query_prealloc_size
- Описание: Size in bytes of the persistent buffer for query parsing and execution, allocated on connect and freed on disconnect. Increasing may be useful if complex queries are being run, as this will reduce the need for more memory allocations during query operation. See also query_alloc_block_size.
- Командная строка:
--query-prealloc-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
24576
(from MariaDB 10.1.2)8192
(before MariaDB 10.1.2) - Диапазон:
1024
-4294967295
(from MariaDB 10.1.2),8192
-4294967295
(before MariaDB 10.1.2)
rand_seed1
- Описание: rand_seed1 and rand_seed2 facilitate replication of the RAND() function. The master passes the value of these to the slaves so that the random number generator is seeded in the same way, and generates the same value, on the slave as on the master. The variable value cannot be viewed.
rand_seed2
- Описание: See rand_seed1.
range_alloc_block_size
- Описание: Size in bytes of blocks allocated during range optimization. The unit size in 1024.
- Командная строка:
--range-alloc-block-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
4096
- Range - 32 bit:
4096
-4294967295
read_buffer_size
- Описание: Each thread performing a sequential scan (for MyISAM, Aria and MERGE tables) allocates a buffer of this size in bytes for each table scanned. Increase if you perform many sequential scans. If not in a multiple of 4KB, will be rounded down to the nearest multiple. Also used in ORDER BY's for caching indexes in a temporary file (not temporary table), for caching results of nested queries, for bulk inserts into partitions, and to determine the memory block size of MEMORY tables.
- Командная строка:
--read-buffer-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
131072
- Диапазон:
8200 to 2147479552
read_only
- Описание: When set to
1
(0
is default), no updates are permitted except from users with the SUPER privilege or slave servers updating from a master. Theread_only
variable is useful for slave servers to ensure no updates are accidentally made outside of what are performed on the master. Inserting rows to log tables, updates to temporary tables and OPTIMIZE or ANALYZE TABLE statements are excluded from this limitation. From MariaDB 5.5, if read_only is set to1
, SET PASSWORD is limited only to users with the SUPER privilege. Attempting to set this variable to1
will fail if the current session has table locks or transactions pending, while if other sessions hold table locks, the statement will wait until these locks are released before completing. While the attempt to set read_only is waiting, other requests for table locks or transactions will also wait until read_only has been set. - Командная строка:
--read-only
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
read_rnd_buffer_size
- Описание: Size in bytes of the buffer used when reading rows from a MyISAM table in sorted order after a key sort. Larger values improve ORDER BY performance, although rather increase the size by SESSION where the need arises to avoid excessive memory use.
- Командная строка:
--read-rnd-buffer-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
262144
- Диапазон:
8200
-2147483647
-
-
rowid_merge_buff_size
- Описание: The maximum size in bytes of the memory available to the Rowid-merge strategy. See Non-semi-join subquery optimizations for more information.
- Командная строка:
--rowid-merge-buff-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
8388608
- Диапазон:
0
-2147483647
- Введено: MariaDB 5.3.0
rpl_recovery_rank
- Описание: Неиспользуется
- Удалено:
MariaDB 10.1.2
safe_show_database
- Описание: This variable was removed in MariaDB/MySQL 5.5.3, and has been replaced by the more flexible SHOW DATABASES privilege.
- Командная строка:
--safe-show-database
(until MySQL 4.1.1) - Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- Удалено:
MariaDB/MySQL 5.5.3
secure_auth
- Описание: Connections will be blocked unless clients use the current password format. Prior to MySQL 4.1 passwords used an old, less secure format.. For the mysql client, the
--secure-auth
option blocks connections to servers requiring the old format. The server will also fail to start if the privilege tables are in the old, pre-MySQL 4.1 format. - Командная строка:
--secure-auth
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
ON
(>= MariaDB 10.1.7),OFF
(<= MariaDB 10.1.6)
secure_file_priv
- Описание: LOAD DATA, SELECT ... INTO and LOAD FILE() will only work with files in the specified path. If not set, the default, the statements will work with any files that can be accessed.
- Командная строка:
--secure-file-priv=path
- Область: Глобальный
- Динамический: Нет
- Тип данных:
path name
- По умолчанию: Нетne
session_track_schema
- Описание: Whether to track changes to the default schema within the current session.
- Командная строка:
--session-track-schema={0|1}
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
ON
- Введено: MariaDB 10.2.2
session_track_state_change
- Описание: Whether to track changes to the session state.
- Командная строка:
--session-track-state-change={0|1}
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
- Введено: MariaDB 10.2.2
session_track_system_variables
- Описание: Comma-separated list of session system variables for which to track changes. By default no variables are tracked. For compatibility with MySQL defaults this variable should be set to "autocommit, character_set_client, character_set_connection, character_set_results, time_zone". The
*
character tracks all session variables. - Командная строка:
--session-track-system-variables=value
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию: (empty string)
- Введено: MariaDB 10.2.2
session_track_transaction_info
- Описание: Track changes to the transaction attributes. OFF to disable; STATE to track just transaction state (Is there an active transaction? Does it have any data? etc.); CHARACTERISTICS to track transaction state and report all statements needed to start a transaction with the same characteristics (isolation level, read only/read write,snapshot - but not any work done / data modified within the transaction).
- Командная строка:
--session-track-transaction-info=value
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enum
- По умолчанию:
OFF
- Допустимые значения:
OFF
,STATE
,CHARACTERISTICS
- Введено: MariaDB 10.2.2
shared_memory
- Описание: Windows only, determines whether the server permits shared memory connections. See also shared_memory_base_name.
- Область: Глобальный
- Динамический: Нет
shared_memory_base_name
- Описание: Windows only, specifies the name of the shared memory to use for shared memory connection. Mainly used when running more than one instance on the same physical machine. By default the name is
MYSQL
and is case sensitive. See also shared_memory. - Область: Глобальный
- Динамический: Нет
- Тип данных:
string
- По умолчанию:
MYSQL
skip_external_locking
- Описание: If set, external locking for MyISAM tables is disabled.
- Командная строка:
--skip-external-locking
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
1
skip_name_resolve
- Описание: If set to 1 (0 is the default), only IP addresses are used for connections. Host names are not resolved. All host values in the GRANT tables must be IP addresses (or localhost).
- Командная строка:
--skip-name-resolve
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
0
skip_networking
- Описание: If set to 1, (0 is the default), the server does not listen for TCP/IP connections. All interaction with the server by be through socket files (Unix) or named pipes or shared memory (Windows). It's recommended to use this option if only local clients are permitted to connect to the server. Enabling this option also prevents a server from functioning as a replication client.
- Командная строка:
--skip-networking
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
0
skip_show_database
- Описание: If set to 1, (0 is the default), only users with the SHOW DATABASES privilege can use the SHOW DATABASES statement to see all database names.
- Командная строка:
--skip-show-database
- Область: Глобальный
- Динамический: Нет
- Тип данных:
boolean
- По умолчанию:
0
slow_launch_time
- Описание: Time in seconds. If a thread takes longer than this to launch, the
slow_launch_threads
server status variable is incremented. - Командная строка:
--slow-launch-time=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
2
slow_query_log
- Описание: If set to 0, the default unless the --slow-query-log option is used, the slow query log is disabled, while if set to 1 (both global and session variables), the slow query log is enabled. MariaDB 10.1 added support for session variables.
- Командная строка:
--slow-query-log
- Область: Глобальный, Сессия (MariaDB 10.1)
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
0
- See also: See log_output to see how log files are written. If that variable is set to
NONE
, no logs will be written even if slow_query_log is set to1
.
slow_query_log_file
- Описание: Name of the slow query log file.
- Командная строка:
--slow-query-log-file=file_name
- Область: Глобальный
- Динамический: Да
- Тип данных:
file name
- По умолчанию:
host_name-slow.log
socket
- Описание: On Unix-like systems, this is the name of the socket file used for local client connections, by default
/tmp/mysql.sock
, often changed by the distribution, for example/var/lib/mysql/mysql.sock
. On Windows, this is the name of the named pipe used for local client connections, by defaultMySQL
. On Windows, this is not case-sensitive. - Командная строка:
--socket=name
- Область: Глобальный
- Динамический: Нет
- Тип данных:
file name
- По умолчанию:
/tmp/mysql.sock
(Unix),MySQL
(Windows)
sort_buffer_size
- Описание: Each session performing a sort allocates a buffer with this amount of memory. Not specific to any storage engine. If the status variable sort_merge_passes is too high, you may need to look at improving your query indexes, or increasing this. Consider reducing where there are many small sorts, such as OLTP, and increasing where needed by session. 16k is a suggested minimum.
- Командная строка:
--sort-buffer-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
number
- По умолчанию:
2M (2097152)
(some distributions increase the default)
sql_auto_is_null
- Описание: If set to 1, the query
SELECT * FROM table_name WHERE auto_increment_column IS NULL
will return an auto-increment that has just been successfully inserted, the same as the LAST_INSERT_ID() function. Some ODBC programs make use of this IS NULL comparison. - Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
0 (>= MariaDB/MySQL 5.5.3), 1 (MariaDB/MySQL <= 5.5.2)
sql_big_selects
- Описание: If set to 0, MariaDB will not perform large SELECTs. See max_join_size for details. If max_join_size is set to anything but DEFAULT, sql_big_selects is automatically set to 0. If sql_big_selects is again set, max_join_size will be ignored.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
1
sql_big_tables
- Описание: A synonym for big_tables.
sql_buffer_result
- Описание: If set to 1 (0 is default), results from SELECT statements are always placed into temporary tables. This can help the server when it takes a long time to send the results to the client by allowing the table locks to be freed early.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
0
sql_log_off
- Описание: If set to 1 (0 is the default), no logging to the general query log is done for the client. Only clients with the SUPER privilege can update this variable.
- Область: Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
0
sql_log_update
- Описание: Removed. Use sql_log_bin instead.
- Удалено: MariaDB/MySQL 5.5
sql_low_priority_updates
- Описание: Synonym for low_priority_updates, the preferred name.
sql_max_join_size
- Описание: Synonym for max_join_size, the preferred name.
sql_mode
- Описание: Sets the SQL Mode. Multiple modes can be set, separated by a comma.
- Командная строка:
--sql-mode=value[,value[,value...]]
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
(>= MariaDB 10.2.4)NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
(>= MariaDB 10.1.7)(empty string)
(<= MariaDB 10.1.6)
- Допустимые значения: See SQL Mode for the full list.
sql_notes
- Описание: If set to 1, the default, warning_count is incremented each time a Note warning is encountered. If set to 0, Note warnings are not recorded. mysqldump has outputs to set this variable to 0 so that no unnecessary increments occur when data is reloaded.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
1
sql_quote_show_create
- Описание: If set to 1, the default, the server will quote identifiers for SHOW CREATE DATABASE, SHOW CREATE TABLE and SHOW CREATE VIEW statements. Quoting is disabled if set to 0. Enable to ensure replications works when identifiers require quoting.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
1
sql_safe_updates
- Описание: If set to 1, UPDATE's and DELETE's need either a key in the WHERE clause, or a LIMIT clause, or else they will aborted. Prevents the common mistake of accidentally deleting or updating every row in a table.
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF (0)
sql_select_limit
- Описание: Maximum number of rows that can be returned from a SELECT query. Default is the maximum number of rows permitted per table by the server, usually 232-1 or 264-1. Can be restored to the default value after being changed by assigning it a value of DEFAULT.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
sql_warnings
- Описание: If set to 1, single-row INSERT's will produce a string containing warning information if a warning occurs.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF (0)
storage_engine
- Описание: See default_storage_engine.
- Устарел: MariaDB/MySQL 5.5.3
standard_compliant_cte
- Описание: Allow only standard-compliant common table expressions. Prior to version 10.2.4, this variable was named
standards_compliant_cte
. - Командная строка:
--standard-compliant-cte={0|1}
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
ON
- Введено: MariaDB 10.2.2
stored_program_cache
- Описание: Limit to the number of stored routines held in the stored procedures and stored functions caches. Each time a stored routine is executed, this limit is first checked, and if the number held in the cache exceeds this, that cache is flushed and memory freed.
- Командная строка:
--stored-program-cache=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
256
- Диапазон:
256
-524288
- Введено: MariaDB/MySQL 5.5.21
strict_password_validation
- Описание: When password validation plugins are enabled, reject passwords that cannot be validated (passwords specified as a hash). This excludes direct updates to the privilege tables.
- Командная строка:
--strict-password-validation
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
ON
- Введено: MariaDB 10.1.2
sync_frm
- Описание: If set to 1, the default, each time a non-temporary table is created, its .frm definition file is synced to disk. Fractionally slower, but safer in case of a crash.
- Командная строка:
--sync-frm
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
TRUE
system_time_zone
- Описание: Server system time zone, inherited from the machine setting when the server starts. Usually specified by the TZ environment variable, can also be specified by the
--timezone
option of the mysqld_safe script, or affected by the environment of the account starting the server. Not the same as the time_zone system variable, which is used for client time zones. - Область: Глобальный
- Динамический: Нет
- Тип данных:
string
table_definition_cache
- Описание: Number of table definitions that can be cached. Table definitions are taken from the .frm files, and if there are a large number of tables increasing the cache size can speed up table opening. Unlike the table_open_cache, as the table_definition_cache doesn't use file descriptors, and is much smaller.
- Командная строка:
--table-definition-cache=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
400
- Диапазон:
400
-524288
table_lock_wait_timeout
- Описание: Unused, and removed in MariaDB/MySQL 5.5.3
- Командная строка:
--table-lock-wait-timeout=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
50
- Диапазон:
1
-1073741824
- Удалено:
MariaDB/MySQL 5.5.3
table_open_cache
- Описание: Number of open tables for all threads. See Optimizing table_open_cache for suggestions on optimizing. Increasing table_open_cache increases the number of file descriptors required. Previously called
table_cache
prior to MySQL 5.1.3 - Командная строка:
--table-open-cache=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
2000
(>= MariaDB 10.1.7),400
(<= MariaDB 10.1.6) - Диапазон:
1
-1048576
(1024K) (>= MariaDB 10.1.20),1
-524288
(512K) (<= MariaDB 10.1.19)
table_open_cache_instances
- Описание: From MariaDB 10.2.2, specifies the maximum number of table cache instances. This is different to the MySQL version which specifies the number of table cache instances. The MariaDB implementation is more efficient, and always starts with 1 instance, increasing the number up to the maximum when there's contention. Whenever an instance is activated a note is written to error log, for example Detected table cache mutex contention at instance 1: 25% waits. Additional table cache instance activated. Number of instances after activation: 2. The number of instances does not decrease again. The current default value (8) is expected to handle up to 100 CPU cores - beyond this, the setting should be increased. Until MariaDB 10.0.7, this was an unused MySQL 5.6 compatibility option, as MariaDB achieved similar results in a different way (see MDEV-4702).
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
8
(>= MariaDB 10.2.2),1
(<= MariaDB 10.0.7) - Диапазон:
- Введено: MariaDB 10.2.2 (previously in MariaDB 10.0.4)
- Удалено: MariaDB 10.0.7, reintroduced MariaDB 10.2.2
table_type
- Описание: Removed and replaced by storage_engine in MariaDB/MySQL 5.5.3. Use default_storage_engine instead.
thread_cache_size
- Описание: Number of threads server caches for re-use. If this limit hasn't been reached, when a client disconnects, its threads are put into the cache, and re-used where possible. These are freed after 5 minutes of idle time. Normally this setting has little effect, as the other aspects of the thread implementation are more important, but increasing it can help servers with high volumes of connections per second so that most can use a cached, rather than a new, thread. The cache miss rate can be calculated as the server status variables threads_created/connections. If the thread pool is active,
thread_cache_size
is ignored. From MariaDB 10.2.0, the default is automatically set to the smaller of either 256, or the max_connections size. - Командная строка:
--thread-cache-size=#
- Область: Глобальный
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
0
(<= MariaDB 10.1), Auto (from MariaDB 10.2.0) - Диапазон:
0
-16384
thread_concurrency
- Описание: Allows applications to give the system a hint about the desired number of threads. Specific to Solaris only, invokes thr_setconcurrency().
- Командная строка:
--thread-concurrency=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
10
- Диапазон:
1
-512
thread_stack
- Описание: Stack size for each thread. If set too small, limits recursion depth of stored procedures and complexity of SQL statements the server can handle in memory. Also affects limits in the crash-me test.
- Командная строка:
--thread-stack=#
- Область: Глобальный
- Динамический: Нет
- Тип данных:
numeric
- По умолчанию:
297984
(MariaDB 10.2)296960
(MariaDB 10.2.0)295936
(MariaDB 10.1)294912
(<= MariaDB 10.0)
- Диапазон:
131072
-18446744073709551615
time_format
- Описание: Неиспользуется
time_zone
- Описание: The current time zone, used to initialize the time zone for a client when it connects. Set to
SYSTEM
by default, in which the client uses the system time zone value. - Командная строка:
--default-time-zone=string
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
string
- По умолчанию:
SYSTEM
timed_mutexes
- Описание: Determines whether InnoDB mutexes are timed.
OFF
, the default, disables mutex timing, whileON
enables it. See also SHOW ENGINE for more on mutex statistics. Deprecated in MariaDB 5.5.39, as has no effect anymore. - Командная строка:
--timed-mutexes
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
- Устарел: MariaDB 5.5.39
timestamp
- Описание: Sets the time for the client. This will affect the result returned by the NOW() function, not the SYSDATE() function, unless the server is started with the --sysdate-is-now option, in which case SYSDATE becomes an alias of NOW, and will also be affected. Also used to get the original timestamp when restoring rows from the binary log.
- Область: Сессия
- Динамический: Да
- Допустимые значения:
timestamp_value
(Unix epoch timestamp, not MariaDB timestamp),DEFAULT
tmp_table_size
- Описание: The largest size for temporary tables in memory (not MEMORY tables) although if max_heap_table_size is smaller the lower limit will apply. If a table exceeds the limit, MariaDB converts it to a MyISAM or Aria table. You can see if it's necessary to increase by comparing the status variables
Created_tmp_disk_tables
andCreated_tmp_tables
to see how many temporary tables out of the total created needed to be converted to disk. Often complex GROUP BY queries are responsible for exceeding the limit. Defaults may be different on some systems, see for example Differences in MariaDB in Debian. - Командная строка:
--tmp-table-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
numeric
- По умолчанию:
16777216
(16MB) - Диапазон:
1024
-4294967295
tmpdir
- Описание: Directory for storing temporary tables and files. Can specify a list (separated by semicolons in Windows, and colons in Unix that will then be used in round-robin fashion. This can be used for load balancing across several disks. Note that if the server is a replication slave, and slave_load_tmpdir, which overrides tmpdir for slave replication, is not set, you should not set tmpdir to a directory that is cleared when the machine restarts, or else replication may fail.
- Командная строка:
--tmpdir=path
or-t path
- Область: Глобальный
- Динамический: Нет
- Тип данных: directory name/s
transaction_alloc_block_size
- Описание: Size in bytes to increase the memory pool available to each transaction when the available pool is not large enough. See transaction_prealloc_size.
- Командная строка:
--transaction-alloc-block-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: numeric
- По умолчанию:
8192
- Диапазон:
1024
-4294967295
- Block Size:
1024
transaction_prealloc_size
- Описание: Initial size of a memory pool available to each transaction for various memory allocations. If the memory pool is not large enough for an allocation, it is increased by transaction_alloc_block_size bytes, and truncated back to transaction_prealloc_size bytes when the transaction is completed. If set large enough to contain all statements in a transaction, extra malloc() calls are avoided.
- Командная строка:
--transaction-prealloc-size=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: numeric
- По умолчанию:
4096
- Диапазон:
1024
-4294967295
- Block Size:
1024
tx_isolation
- Описание: The transaction isolation level. See also SET TRANSACTION ISOLATION LEVEL.
- Командная строка:
--transaction-isolation=name
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: enumeration
- По умолчанию:
REPEATABLE-READ
- Допустимые значения:
READ-UNCOMMITTED
,READ-COMMITTED
,REPEATABLE-READ
,SERIALIZABLE
tx_read_only
- Описание: Default transaction access mode. If set to
OFF
, the default, access is read/write. If set toON
, access is read-only. TheSET TRANSACTION
statement can also change the value of this variable. See SET TRANSACTION and START TRANSACTION. - Командная строка:
--transaction-read-only=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: boolean
- По умолчанию:
OFF-READ
- Введено: MariaDB 10.0
unique_checks
- Описание: If set to 1, the default, secondary indexes in InnoDB tables are performed. If set to 0, storage engines can (but are not required to) assume that duplicate keys are not present in input data. Set to 0 to speed up imports of large tables to InnoDB. The storage engine will still issue a duplicate key error if it detects one, even if set to 0.
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: boolean
- По умолчанию:
1
updatable_views_with_limit
- Описание: Determines whether view updates can be made with an UPDATE or DELETE statement with a LIMIT clause if the view does not contain all primary or not null unique key columns from the underlying table.
0
prohibits this, while1
permits it while issuing a warning (the default). - Командная строка:
--updatable-views-with-limit=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: boolean
- По умолчанию:
1
use_stat_tables
- Описание: Controls the use of engine-independent table statistics.
never
The optimizer will not use data from statistics tables.complementary
The optimizer uses data from statistics tables if the same kind of data is not provided by the storage engine.preferably
Prefer the data from statistics tables, if it's not available there, use the data from the storage engine.
- Командная строка:
--use-stat-tables=mode
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных:
enum
- По умолчанию:
never
- Введено: MariaDB 10.0.1
userstat
- Описание: If set to
1
, user statistics will be activated. - Командная строка:
--userstat=1
- Область: Глобальный
- Динамический: Да
- Тип данных:
boolean
- По умолчанию:
OFF
- Введено: MariaDB 5.2.0
version
- Описание: Server version number. It may also include a suffix with configuration or build information.
-debug
indicates debugging support was enabled on the server, and-log
indicates at least one of the binary log, general log or slow query log are enabled, for example10.0.1-MariaDB-mariadb1precise-log
. From MariaDB 10.2.1, this variable can be set at startup in order to fake the server version. - Командная строка:
-V
,--version[=name]
(>= MariaDB 10.2.1),--version
(<= MariaDB 10.2.0) - Область: Глобальный
- Динамический: Нет
- Тип данных: string
version_comment
- Описание: Value of the COMPILATION_COMMENT option specified by CMake when building MariaDB, for example
mariadb.org binary distribution
- Область: Глобальный
- Динамический: Нет
- Тип данных: string
version_compile_machine
- Описание: The machine type or architecture MariaDB was built on, for example
i686
- Область: Глобальный
- Динамический: Нет
- Тип данных: string
version_compile_os
- Описание: Operating system that MariaDB was built on, for example
debian-linux-gnu
- Область: Глобальный
- Динамический: Нет
- Тип данных: string
version_malloc_library
- Командная строка: Нет
- Описание: Version of the used malloc library
- Область: Глобальный
- Динамический: Нет
- Тип данных: string
- Введено: MariaDB 10.0.8
wait_timeout
- Описание: Time in seconds that the server waits for a connection to become active before closing it. The session value is initialized when a thread starts up from either the global value, if the connection is non-interactive, or from the interactive_timeout value, if the connection is interactive.
- Командная строка:
--wait-timeout=#
- Область: Глобальный, Сессия
- Динамический: Да
- Тип данных: numeric
- По умолчанию:
28800
- Диапазон:
1 to 2147483
warning_count
- Описание: Read-only variable indicating the number of warnings, errors and notes resulting from the most recent statement that generated messages. See SHOW WARNINGS for more. Note warnings will only be recorded if sql_notes is true (the default).
- Область: Сессия
- Динамический: Нет
- Тип данных: numeric