Shulou(Shulou.com)05/31 Report--

This article will explain in detail what the mysql5.7.21 parameters are, and the content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Auto_increment_increment: indicates the amount of each increment in the self-growing field. The default value is 1, and the value range is 1. 65535

Auto_increment_offset: indicates that since the growth field starts from that number, its value range is 1.. 65535

Autocommit: auto submit

Automatic_sp_privileges: controls whether server automatically assigns execute and alter permissions to the user who created the routine. Default is 1, automatic weighting

Avoid_temporal_upgrade: its purpose is to allow us to choose whether or not to force the upgrade of the table structure

Back_log: indicates how many requests can be stored in the stack within a short period of time before MySQL temporarily stops answering new requests

Path of basedir:mysql installation

Big_tables: make large result sets by saving all temporary sets to a file. This option prevents most "table full" errors, but also slows down queries on in-memory tables.

The bind_address:MySQL service listens for only a single network socket for TCP/IP connections. This socket binds a single address. However, a single address may be mapped to multiple network interfaces.

Binlog_cache_size: the memory allocated for each session, the cache used to store binary logs during a transaction

Binlog_checksum: CRC32 or none, set to none to be compatible with lower versions

Binlog_direct_non_transactional_updates: enable him so that operations on non-transactional tables will record binlog in any case. For non-transactional engine tables, go directly to the log instead of 2pc commit.

Binlog_error_action: when mysql cannot write binlog, an exception is reported. By default, ignore error does not report an error.

Binlog_format: specifies the log format of binlog, which supports statement,row,mixed format

Binlog_group_commit_sync_delay: indicates how long it takes to wait for binlog to submit before synchronizing to disk. Default is 0, and there is no delay. Setting delay allows multiple transactions to commit at one time, improving the concurrency and efficiency of binlog group commits, and improving the throughput of slave. Global dynamic variable, unit subtle, default 0, range: 0cm 1000000 (1 second).

Binlog_group_commit_sync_no_delay_count: indicates the maximum number of transactions waiting for delayed commit. If the time for the above parameter is not up, but the number of transactions has arrived, it will be synchronized directly to disk.

If binlog_group_commit_sync_delay:binlog_group_commit_sync_no_delay_count is not enabled, this parameter will not be enabled. Global dynamic variable, number of units, default 0, range: 0mm 1000000

Binlog_gtid_simple_recovery:MySQL5.7.7 is followed by the default on, which controls how mysql iterates to use the binlog file when searching for GTIDs when mysql starts or restarts. When this parameter is true, mysql-server only needs to open the oldest and newest two binlog files, and the values of the gtid_purged parameter and the gtid_executed parameter can be calculated according to the Previous_gtids_log_event or Gtid_log_event in these files. This ensures that when mysql-server restarts or cleans up binlog, only 2 binlog files need to be opened. When this parameter is set to off, all binlog starting with the latest file is checked during mysql recovery in order to initialize gtid_executed. And in order to initialize gtid_purged, all binlog must be checked. This may take a very long time, it is recommended to turn it on.

Binlog_max_flush_queue_time: the timeout in subtle units used to fetch transactions from the flush queue, mainly to prevent concurrent transactions from being too high, causing the RT of some transactions to rise

Binlog_order_commits: when set to 0, transactions may be committed in a different order than binlog

Binlog_row_image:FULL records the changes of each line, while minimal records only the affected lines.

Binlog_rows_query_log_events writes the original operation sql record to the event

Binlog_stmt_cache_size non-transaction statement cache size

Block_encryption_mode default aes-128-ecb, block encryption mode

Bulk_insert_buffer_size improves the efficiency of data insertion. This parameter sets the cache size of bulk insert. The default is 8m.

Character set used by character_set_client client

Character set setting type for character_set_connection connection database

The character set used by a library in the character_set_database database

Character_set_filesystem

The database used when the character_set_results database is returned to the client

The character set specified when the character_set_server server is installed

Character set used by character_set_system database system

Character_sets_dir: directory where the character set is installed

Check_proxy_users indicates whether to enable the function of proxy user.

Character proofreading rules for collation_connection connection database

Character set proofreading rules used by a library in collation_database database

Character set proofreading rules specified during collation_server server installation

Start a transaction after completion_type:0 or no_chain,1:commit commit, 2 disconnect from the database after commit

Concurrent_insert when concurrent_insert=0, concurrent insertion is not allowed.

When concurrent_insert=1, concurrent inserts are allowed for tables with no holes, and the new data is at the end of the data file (the default).

When concurrent_insert=2, concurrent insertions are allowed at the end of the data file, regardless of whether the table has holes or not. (myisam)

The maximum time a connect_timeout mysql server waits for a client packet before returning an incorrect handshake protocol when the mysql client attempts to establish a connection with the mysql server

Core_file corefile is the file generated when the program crashes under Linux, which can be used to analyze the cause of the program crash, because it contains the stack information when the program crashes.

Datadir data file directory

Date_format date format

Datetime_format time format

Default_authentication_plugin default password authentication plug-in

Default_password_lifetime default password lifetime (days)

Default_storage_engine default storage engine

Default_tmp_storage_engine represents the default storage engine for temporary tables

Default_week_format when calling the WEEK () or YEARWEEK () function without the optional mode argument, it defaults to the schema value set by this variable

Delay_key_write whether the server needs to defer writing to MyISAM tables created with the DELAY_KEY_WRITE option. This variable can be taken from the following 3.

ON (default). At this point, the server operates according to the value of the DELAY_KEY_WRITE option; if the table is created with the DELAY_KEY_WRITE=1 option, the write is delayed; if the table is created with the DELAY_KEY_WRITE=0 option, there is no delay.

OFF . It means that there is no delay in writing keys to the task table, no matter how they are defined.

ALL . It means that there is always a delay in writing keys to the task list, no matter how they are defined.

It is more common to set delay_key_write to ALL when running the replication slave server to improve the performance of MyISAM tables (delaying their key writes regardless of how these tables were originally created).

Delayed_insert_limit refers to the number of rows derived from SELECT statements that the table's deferred row processor inserts before checking for new INSERT DELAYED statements to arrive. If a statement arrives, the insert operation is suspended so that the retrieval operation can be performed.

Delayed_insert_timeout when the processor of the INSERT DELAYED operation inserts the queued rows, it waits for dealyed_insert_timeout seconds to check to see if any new INSERT DELAYED lines arrive. If a row arrives, the insert continues; otherwise, the insert operation is terminated.

Delayed_queue_size each table has the number of rows that can be queued for INSERT DELAYED. When the queue is full, more INSERT DELAYED statements against the table are blocked until the queue has enough space.

Storage engine not supported by disabled_storage_engines

Disconnect_on_expired_password is used to control how the client handles invalid passwords, which is turned on by default

When div_precision_increment uses the operator / a pair of two exact values for division, this variable represents the number of precision digits that need to be increased. For example, when the value of div_precision_increment is 4 or 6, the result of .1 / .7 is .14286 or 0.1428571, respectively. The range of values for this variable is 0: 30, and the default is 4.

End_markers_in_json

Some security restrictions for enforce_gtid_consistency to enable gtid (mind turning on)

Eq_range_index_dive_limit simply states that the value of the option eq_range_index_dive_limit sets the number of conditions in the IN list to go online, and when the value exceeds the set value, the execution plan will be changed from 1 to 2.

Event_scheduler event plan

Expire_logs_days log expiration time

Explicit_defaults_for_timestamp

Whether flush enables synchronization of table data to disk and the interval between automatic synchronization

Whether flush_time enables synchronization of table data to disk and the interval between automatic synchronization

Whether external inspection is enabled for foreign_key_checks

Ft_boolean_syntax indicates that the fields that need to be full-text indexed are segmented by these variables.

The maximum length of ft_max_word_len participle, which generally does not need to be changed.

The minimum length of ft_min_word_len word segmentation, which is generally modified to 1.

Maximum number of matches for full-text search using with query expansion in ft_query_expansion_limitMyISAM engine table

Ft_stopword_file means to filter out unindexed vocabularies, one per line.

Whether full log is enabled by general_log

General_log_file full log file path

There is a limit on the length of the group_concat_max_lengroup_concat connection field, not how many are connected. You can use this variable setting.

Gtid_executed, which is a set of transactions that have been recorded in binary log files

Gtid_executed_compression_period is used to control how many transactions are executed. The table is compressed. The default value is 1000.

Whether gtid_mode is enabled to enable GTID mode

Gtid_owned represents the gtid of the transaction being executed and the corresponding thread ID

Transaction of binlog for which gtid_purged has been deleted, which is a subset of GTID_EXECUTED, which cannot be set since MySQL5.6.9

Whether the have_compress zlib compression library can be used by MySQL servers

Whether the have_crypt crypt () system call can be used by the MySQL server

Have_dynamic_loadingmysqld supports YES when dynamically loading plug-ins, otherwise NO

YES when have_geometry mysqld supports spatial data types, NO otherwise

Have_openssl this is an alias for the have_ssl option

Have_profiling mysqld is YES when supporting statement performance analysis, otherwise it is NO. If the profiling feature is supported, the-- profiling variable is used to control whether the feature is started.

The query cache supported by have_query_cache mysqld is YES, otherwise it is NO.

Have_rtree_keys mysqld supports RTREE index is YES, otherwise it is NO. The RTREE index is used for spatial indexing of MyISAM tables.

YES when have_ssl mysqld supports SSL connections, otherwise NO

Have_statement_timeout

Have_symlink mysqld supports symbolic links as YES, otherwise it is NO. On Unix hosts, this feature is useful for data catalogs and index directories.

Host_cache_size disables the use of internal host cache for faster hostname-to-IP resolution

Hostname Hostnam

Ignore_builtin_innodb

Ignore_db_dirs is used to control whether the db directory under the DATA directory is ignored. Multiple directories are separated by multiple lines.

Init_connect executes the contents of the database before executing the first query after the user logs in to the database

Init_file sometimes we want MySQL to be able to do some database operations at startup, such as adding indexes to cache and so on. Because some configurations fail after a MySQL restart, we can ask MySQL to re-execute some SQL statements with the parameter init_file after the restart.

Init_slave

Innodb_adaptive_flushing

Innodb_adaptive_flushing_lwm

Innodb_adaptive_hash_index

Innodb_adaptive_hash_index_parts

Innodb_adaptive_max_sleep_delay

Innodb_api_bk_commit_interval

Innodb_api_disable_rowlock

Innodb_api_enable_binlog

Innodb_api_enable_mdl

Innodb_api_trx_level

Innodb_autoextend_increment

Innodb_autoinc_lock_mode

Innodb_buffer_pool_chunk_size

Innodb_buffer_pool_dump_at_shutdown

Innodb_buffer_pool_dump_now

Innodb_buffer_pool_dump_pct

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_size

Innodb_change_buffer_max_size

Innodb_change_buffering

Innodb_checksum_algorithm

Innodb_checksums

Innodb_cmp_per_index_enabled

Innodb_commit_concurrency

Innodb_compression_failure_threshold_pct

Innodb_compression_level

Innodb_compression_pad_pct_max

Innodb_concurrency_tickets

Innodb_data_file_path

Innodb_data_home_dir

Innodb_deadlock_detect

Innodb_default_row_format

Innodb_disable_sort_file_cache

Innodb_doublewrite

Innodb_fast_shutdown

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_neighbors

Innodb_flush_sync

Innodb_flushing_avg_loops

Innodb_force_load_corrupted

Innodb_force_recovery

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_io_capacity

Innodb_io_capacity_max

Innodb_large_prefix

Innodb_lock_wait_timeout

Innodb_locks_unsafe_for_binlog

Innodb_log_buffer_size

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_dirty_pages_pct

Innodb_max_dirty_pages_pct_lwm

Innodb_max_purge_lag

Innodb_max_purge_lag_delay

Innodb_max_undo_log_size

Innodb_monitor_disable

Innodb_monitor_enable

Innodb_monitor_reset

Innodb_monitor_reset_all

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_print_all_deadlocks

Innodb_purge_batch_size

Innodb_purge_rseg_truncate_frequency

Innodb_purge_threads

Innodb_random_read_ahead

Innodb_read_ahead_threshold

Innodb_read_io_threads

Innodb_read_only

Innodb_replication_delay

Innodb_rollback_on_timeout

Innodb_rollback_segments

Innodb_sort_buffer_size

Innodb_spin_wait_delay

Innodb_stats_auto_recalc

Innodb_stats_include_delete_marked

Innodb_stats_method

Innodb_stats_on_metadata

Innodb_stats_persistent

Innodb_stats_persistent_sample_pages

Innodb_stats_sample_pages

Innodb_stats_transient_sample_pages

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_sleep_delay

Innodb_tmpdir

Innodb_undo_directory

Innodb_undo_log_truncate

Innodb_undo_logs

Innodb_undo_tablespaces

Innodb_use_native_aio

Innodb_version

Innodb_write_io_threads

Interactive_timeout

Internal_tmp_disk_storage_engine

Join_buffer_size

Keep_files_on_create

Key_buffer_size

Key_cache_age_threshold

Key_cache_block_size

Key_cache_division_limit

Large_files_support

Large_page_size

Large_pages

Lc_messages

Lc_messages_dir

Lc_time_names

License

Local_infile

Lock_wait_timeout

Locked_in_memory

Log_bin

Log_bin_basename

Log_bin_index

Log_bin_trust_function_creators

Log_bin_use_v1_row_events

Log_builtin_as_identified_by_password

Log_error

Log_error_verbosity

Log_output

Log_queries_not_using_indexes

Log_slave_updates

Log_slow_admin_statements

Log_slow_slave_statements

Log_statements_unsafe_for_binlog

Log_syslog

Log_syslog_facility

Log_syslog_include_pid

Log_syslog_tag

Log_throttle_queries_not_using_indexes

Log_timestamps

Log_warnings

Long_query_time

Low_priority_updates

Lower_case_file_system

Lower_case_table_names

Maintain_user_list

Master_info_repository

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_execution_time

Max_heap_table_size

Max_insert_delayed_threads

Max_join_size

Max_length_for_sort_data

Max_points_in_geometry

Max_prepared_stmt_count

Max_relay_log_size

Max_seeks_for_key

Max_sort_length

Max_sp_recursion_depth

Max_tmp_tables

Max_user_connections

Max_write_lock_count

Metadata_locks_cache_size

Metadata_locks_hash_instances

Min_examined_row_limit

Multi_range_count

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

Mysql_native_password_proxy_users

Net_buffer_length

Net_read_timeout

Net_retry_count

Net_write_timeout

New

Ngram_token_size

Offline_mode

Old

Old_alter_table

Old_passwords

Open_files_limit

Opt_rds_audit_log_enabled

Opt_rds_enable_show_slave_lag

Opt_rds_last_error_gtid

Optimizer_prune_level

Optimizer_search_depth

Optimizer_switch

Optimizer_trace

Optimizer_trace_features

Optimizer_trace_limit

Optimizer_trace_max_mem_size

Optimizer_trace_offset

Parser_max_mem_size

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_transactions_history_long_size

Performance_schema_events_transactions_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_index_stat

Performance_schema_max_memory_classes

Performance_schema_max_metadata_locks

Performance_schema_max_mutex_classes

Performance_schema_max_mutex_instances

Performance_schema_max_prepared_statements_instances

Performance_schema_max_program_instances

Performance_schema_max_rwlock_classes

Performance_schema_max_rwlock_instances

Performance_schema_max_socket_classes

Performance_schema_max_socket_instances

Performance_schema_max_sql_text_length

Performance_schema_max_stage_classes

Performance_schema_max_statement_classes

Performance_schema_max_statement_stack

Performance_schema_max_table_handles

Performance_schema_max_table_instances

Performance_schema_max_table_lock_stat

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

Port

Preload_buffer_size

Profiling

Profiling_history_size

Protocol_version

Query_alloc_block_size

Query_cache_limit

Query_cache_min_res_unit

Query_cache_size

Query_cache_type

Query_cache_wlock_invalidate

Query_prealloc_size

Range_alloc_block_size

Range_optimizer_max_mem_size

Rbr_exec_mode

Rds_audit_last_log_row

Rds_audit_log_dir

Rds_audit_log_file

Rds_audit_log_row

Rds_audit_log_version

Rds_audit_max_sql_size

Rds_audit_row_limit

Rds_check_core_file_enabled

Rds_force_myisam_to_innodb

Rds_global_access

Rds_is_dump_thread

Rds_kill_connections

Rds_proxy_user_list

Rds_release_date

Rds_reserved_connections

Rds_result_skip_counter

Rds_set_connection_id_enabled

Rds_trx_changes_idle_timeout

Rds_trx_idle_timeout

Rds_trx_readonly_idle_timeout

Rds_user_with_kill_option

Rds_version

Read_buffer_size

Read_only

Read_rnd_buffer_size

Relay_log

Relay_log_basename

Relay_log_index

Relay_log_info_file

Relay_log_info_repository

Relay_log_purge

Relay_log_recovery

Relay_log_space_limit

Report_host

Report_password

Report_port

Report_user

Require_secure_transport

Rpl_semi_sync_master_enabled

Rpl_semi_sync_master_timeout

Rpl_semi_sync_master_trace_level

Rpl_semi_sync_master_wait_for_slave_count

Rpl_semi_sync_master_wait_no_slave

Rpl_semi_sync_master_wait_point

Rpl_semi_sync_slave_enabled

Rpl_semi_sync_slave_trace_level

Rpl_stop_slave_timeout

Secure_auth

Secure_file_priv

Server_id

Server_id_bits

Server_uuid

Session_track_gtids

Session_track_schema

Session_track_state_change

Session_track_system_variables

Session_track_transaction_info

Sha256_password_proxy_users

Show_compatibility_56

Show_old_temporals

Skip_external_locking

Skip_name_resolve

Skip_networking

Skip_show_database

Slave_allow_batching

Slave_checkpoint_group

Slave_checkpoint_period

Slave_compressed_protocol

Slave_exec_mode

Slave_load_tmpdir

Slave_max_allowed_packet

Slave_net_timeout

Slave_parallel_type

Slave_parallel_workers

Slave_pending_jobs_size_max

Slave_preserve_commit_order

Slave_rows_search_algorithms

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

Sql_auto_is_null

Sql_big_selects

Sql_buffer_result

Sql_log_off

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

Stored_program_cache

Super_read_only

Sync_binlog

Sync_frm

Sync_master_info

Sync_relay_log

Sync_relay_log_info

System_time_zone

Table_definition_cache

Table_open_cache

Table_open_cache_instances

Thread_cache_size

Thread_handling

Thread_stack

Time_format

Time_zone

Tls_version

Tmp_table_size

Tmpdir

Transaction_alloc_block_size

Transaction_isolation

Transaction_prealloc_size

Transaction_read_only

Transaction_write_set_extraction

Tx_isolation

Tx_read_only

Unique_checks

Updatable_views_with_limit

Version

Version_comment

Version_compile_machine

Version_compile_os

Wait_timeout

About what mysql5.7.21 parameters are shared here, I hope the above content can be of some help to you, you can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.