MySQL-查看修改配置参数（GlobalVariables）修改配置参数
1. 采⽤ set GLOBAL 命令，如：set GLOBAL net_write_timeout=120;
2. 在Mysql的配置⽂件中对参数值进⾏修改，之后重启数据库服务即可
查看配置参数
命令：show global variables;
如表所⽰
Variable_name Value
activate_all_roles_on_login OFF
auto_generate_certs ON
auto_increment_increment1
auto_increment_offset1
autocommit ON
automatic_sp_privileges ON
avoid_temporal_upgrade OFF
back_log80
basedir C:\Program Files\MySQL\MySQL Server 8.0\
big_tables OFF
bind_address*
binlog_cache_size32768
binlog_checksum CRC32
binlog_direct_non_transactional_updates OFF
binlog_error_action ABORT_SERVER
binlog_expire_logs_seconds2592000
binlog_format ROW
binlog_group_commit_sync_delay0
binlog_group_commit_sync_no_delay_count0
binlog_gtid_simple_recovery ON
binlog_max_flush_queue_time0
binlog_order_commits ON
binlog_row_image FULL
binlog_row_metadata MINIMAL
binlog_row_value_options
binlog_rows_query_log_events OFF
binlog_stmt_cache_size32768
binlog_transaction_dependency_history_size25000
binlog_transaction_dependency_tracking COMMIT_ORDER
block_encryption_mode aes-128-ecb
bulk_insert_buffer_size8388608
caching_sha2_password_auto_generate_rsa_keys ON
caching_sha2_password_private_key_path private_key.pem
caching_sha2_password_public_key_path public_key.pem
character_set_client utf8mb4
character_set_connection utf8mb4
character_set_database utf8mb4
character_set_filesystem binary
character_set_results utf8mb4
character_set_server utf8mb4
character_set_system utf8
character_sets_dir C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\
check_proxy_users OFF
collation_connection utf8mb4_0900_ai_ci
collation_database utf8mb4_0900_ai_ci
collation_server utf8mb4_0900_ai_ci
completion_type NO_CHAIN
concurrent_insert AUTO
connect_timeout10
core_file OFF
cte_max_recursion_depth1000
datadir D:\ProgramData\MySQL\MySQL Server 8.0\Data\ default_authentication_plugin caching_sha2_password
default_collation_for_utf8mb4utf8mb4_0900_ai_ci
default_password_lifetime0
default_storage_engine InnoDB
default_tmp_storage_engine InnoDB
default_week_format0
delay_key_write ON
delayed_insert_limit100
delayed_insert_timeout300
delayed_queue_size1000
disabled_storage_engines
disconnect_on_expired_password ON
div_precision_increment4
end_markers_in_json OFF
enforce_gtid_consistency OFF
eq_range_index_dive_limit200
event_scheduler ON
expire_logs_days0
explicit_defaults_for_timestamp ON
flush OFF
flush_time0
foreign_key_checks ON
ft_boolean_syntax+ -><()~*:""&|
ft_max_word_len84
ft_min_word_len4
ft_query_expansion_limit20
ft_stopword_file(built-in)
general_log OFF
general_log_file NBSP.log
group_concat_max_len1024
gtid_executed 384632e4-e18f-11e8-a8b6-00163e2e5672:1-198655, 385a0fee-e18f-11e8-a276-00163e10a665:1-34714384
gtid_executed_compression_period1000 gtid_mode OFF gtid_owned
gtid_purged 384632e4-e18f-11e8-a8b6-00163e2e5672:1-198655, 385a0fee-e18f-11e8-a276-00163e10a665:1-34714384
have_compress YES have_dynamic_loading YES have_geometry YES have_openssl YES have_profiling YES have_query_cache NO have_rtree_keys YES have_ssl YES have_statement_timeout YES
have_statement_timeout YES
have_symlink DISABLED
histogram_generation_max_mem_size20000000
host_cache_size279
hostname nbsp
information_schema_stats_expiry86400
init_connect
init_file
init_slave
innodb_adaptive_flushing ON
innodb_adaptive_flushing_lwm10
innodb_adaptive_hash_index ON
innodb_adaptive_hash_index_parts8
innodb_adaptive_max_sleep_delay150000
innodb_api_bk_commit_interval5
innodb_api_disable_rowlock OFF
innodb_api_enable_binlog OFF
innodb_api_enable_mdl OFF
innodb_api_trx_level0
innodb_autoextend_increment64
innodb_autoinc_lock_mode2
innodb_buffer_pool_chunk_size8388608
innodb_buffer_pool_dump_at_shutdown ON
innodb_buffer_pool_dump_now OFF
innodb_buffer_pool_dump_pct25
innodb_buffer_pool_filename ib_buffer_pool
innodb_buffer_pool_instances1
innodb_buffer_pool_load_abort OFF
innodb_buffer_pool_load_at_startup ON
innodb_buffer_pool_load_now OFF
innodb_buffer_pool_size8388608
innodb_change_buffer_max_size25
innodb_change_buffering all
innodb_checksum_algorithm crc32
innodb_cmp_per_index_enabled OFF
innodb_commit_concurrency0
innodb_compression_failure_threshold_pct5
innodb_compression_level6
innodb_compression_pad_pct_max50
innodb_concurrency_tickets5000
innodb_data_file_path ibdata1:12M:autoextend innodb_data_home_dir
innodb_deadlock_detect ON
innodb_dedicated_server OFF
innodb_default_row_format dynamic
innodb_directories
innodb_disable_sort_file_cache OFF
innodb_doublewrite ON
innodb_fast_shutdown1
innodb_file_per_table ON
innodb_fill_factor100
innodb_flush_log_at_timeout1
innodb_flush_log_at_trx_commit1
innodb_flush_method unbuffered
innodb_flush_neighbors0
innodb_flush_sync ON
innodb_flushing_avg_loops30
innodb_force_load_corrupted OFF
innodb_force_recovery0
innodb_ft_aux_table
innodb_ft_cache_size8000000 innodb_ft_enable_diag_print OFF
innodb_ft_enable_stopword ON
innodb_ft_max_token_size84
innodb_ft_min_token_size3
innodb_ft_num_word_optimize2000
innodb_ft_result_cache_limit2000000000 innodb_ft_server_stopword_table
mysql下载配置
innodb_ft_sort_pll_degree2
innodb_ft_total_cache_size640000000 innodb_ft_user_stopword_table
innodb_io_capacity200
innodb_io_capacity_max2000
innodb_lock_wait_timeout50
innodb_log_buffer_size1048576 innodb_log_checksums ON
innodb_log_compressed_pages ON
innodb_log_file_size50331648 innodb_log_files_in_group2
innodb_log_group_home_dir.\
innodb_log_spin_cpu_abs_lwm80
innodb_log_spin_cpu_pct_hwm50
innodb_log_wait_for_flush_spin_hwm400
innodb_log_write_ahead_size8192
innodb_lru_scan_depth1024
innodb_max_dirty_pages_pct90.000000 innodb_max_dirty_pages_pct_lwm10.000000 innodb_max_purge_lag0
innodb_max_purge_lag_delay0
innodb_max_undo_log_size1073741824 innodb_monitor_disable
innodb_monitor_enable
innodb_monitor_reset
innodb_monitor_reset_all
innodb_old_blocks_pct37
innodb_old_blocks_time1000
innodb_online_alter_log_max_size134217728 innodb_open_files300
innodb_optimize_fulltext_only OFF
innodb_page_cleaners1
innodb_page_size16384 innodb_print_all_deadlocks OFF
innodb_print_ddl_logs OFF
innodb_purge_batch_size300
innodb_purge_rseg_truncate_frequency128
innodb_purge_threads4
innodb_random_read_ahead OFF
innodb_read_ahead_threshold56
innodb_read_io_threads4
innodb_read_only OFF
innodb_redo_log_encrypt OFF
innodb_replication_delay0
innodb_rollback_on_timeout OFF
innodb_rollback_segments128
innodb_sort_buffer_size1048576
innodb_spin_wait_delay6
innodb_stats_auto_recalc ON
innodb_stats_include_delete_marked OFF
innodb_stats_method nulls_equal
innodb_stats_on_metadata OFF
innodb_stats_persistent ON
innodb_stats_persistent_sample_pages20
innodb_stats_transient_sample_pages8
innodb_status_output OFF
innodb_status_output_locks OFF
innodb_strict_mode ON
innodb_sync_array_size1
innodb_sync_spin_loops30
innodb_table_locks ON
innodb_temp_data_file_path ibtmp1:12M:autoextend
innodb_thread_concurrency25
innodb_thread_sleep_delay0
innodb_tmpdir
innodb_undo_directory.\
innodb_undo_log_encrypt OFF
innodb_undo_log_truncate ON
innodb_undo_tablespaces2
innodb_use_native_aio ON
innodb_version8.0.12
innodb_write_io_threads4
interactive_timeout28800
internal_tmp_disk_storage_engine InnoDB
internal_tmp_mem_storage_engine TempTable
join_buffer_size262144
keep_files_on_create OFF
key_buffer_size8388608
key_cache_age_threshold300
key_cache_block_size1024
key_cache_division_limit100
keyring_operations ON
large_files_support ON
large_page_size0
large_pages OFF
lc_messages en_US
lc_messages_dir C:\Program Files\MySQL\MySQL Server 8.0\share\
lc_time_names en_US
license GPL
local_infile OFF
lock_wait_timeout31536000
log_bin ON
log_bin_basename D:\ProgramData\MySQL\MySQL Server 8.0\Data\binlog
log_bin_index D:\ProgramData\MySQL\MySQL Server 8.0\Data\binlog.index

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。