win环境下mysql 5.7.15 x64变量默认值

最新推荐文章于 2023-09-08 16:37:57 发布

原创最新推荐文章于 2023-09-08 16:37:57 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

windows 同时被 2 个专栏收录

52 篇文章

订阅专栏

mysql

40 篇文章

订阅专栏

my.ini为默认值，如下：

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = d:/wamp/mysql/
datadir = d:/wamp/mysql/data
port = 3306
#server_id = 1

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

导出的变量值为：

Variable_name

Value

auto_increment_increment

auto_increment_offset

autocommit

automatic_sp_privileges

avoid_temporal_upgrade

OFF

back_log

basedir

d:\wamp\mysql\

big_tables

OFF

bind_address

binlog_cache_size

32768

binlog_checksum

CRC32

binlog_direct_non_transactional_updates

OFF

binlog_error_action

ABORT_SERVER

binlog_format

ROW

binlog_group_commit_sync_delay

binlog_group_commit_sync_no_delay_count

binlog_gtid_simple_recovery

binlog_max_flush_queue_time

binlog_order_commits

binlog_row_image

FULL

binlog_rows_query_log_events

OFF

binlog_stmt_cache_size

32768

block_encryption_mode

aes-128-ecb

bulk_insert_buffer_size

8388608

character_set_client

utf8

character_set_connection

utf8

character_set_database

utf8

character_set_filesystem

binary

character_set_results

utf8

character_set_server

latin1

character_set_system

utf8

character_sets_dir

d:\wamp\mysql\share\charsets\

check_proxy_users

OFF

collation_connection

utf8_general_ci

collation_database

utf8_general_ci

collation_server

latin1_swedish_ci

completion_type

NO_CHAIN

concurrent_insert

AUTO

connect_timeout

core_file

OFF

datadir

d:\wamp\mysql\data\

date_format

%Y-%m-%d

datetime_format

%Y-%m-%d %H:%i:%s

default_authentication_plugin

mysql_native_password

default_password_lifetime

default_storage_engine

InnoDB

default_tmp_storage_engine

InnoDB

default_week_format

delay_key_write

delayed_insert_limit

100

delayed_insert_timeout

300

delayed_queue_size

1000

disabled_storage_engines

disconnect_on_expired_password

div_precision_increment

end_markers_in_json

OFF

enforce_gtid_consistency

OFF

eq_range_index_dive_limit

200

error_count

event_scheduler

OFF

expire_logs_days

explicit_defaults_for_timestamp

OFF

external_user

flush

OFF

flush_time

foreign_key_checks

ft_boolean_syntax

+ -><()~*:""&|

ft_max_word_len

ft_min_word_len

ft_query_expansion_limit

ft_stopword_file

(built-in)

general_log

OFF

general_log_file

d:\wamp\mysql\data\DESKTOP-FFRU10B.log

group_concat_max_len

1024

gtid_executed_compression_period

1000

gtid_mode

OFF

gtid_next

AUTOMATIC

gtid_owned

gtid_purged

have_compress

YES

have_crypt

have_dynamic_loading

YES

have_geometry

YES

have_openssl

DISABLED

have_profiling

YES

have_query_cache

YES

have_rtree_keys

YES

have_ssl

DISABLED

have_statement_timeout

YES

have_symlink

YES

host_cache_size

279

hostname

DESKTOP-FFRU10B

identity

ignore_builtin_innodb

OFF

ignore_db_dirs

init_connect

init_file

init_slave

innodb_adaptive_flushing

innodb_adaptive_flushing_lwm

innodb_adaptive_hash_index

innodb_adaptive_hash_index_parts

innodb_adaptive_max_sleep_delay

150000

innodb_api_bk_commit_interval

innodb_api_disable_rowlock

OFF

innodb_api_enable_binlog

OFF

innodb_api_enable_mdl

OFF

innodb_api_trx_level

innodb_autoextend_increment

innodb_autoinc_lock_mode

innodb_buffer_pool_chunk_size

134217728

innodb_buffer_pool_dump_at_shutdown

innodb_buffer_pool_dump_now

OFF

innodb_buffer_pool_dump_pct

innodb_buffer_pool_filename

ib_buffer_pool

innodb_buffer_pool_instances

innodb_buffer_pool_load_abort

OFF

innodb_buffer_pool_load_at_startup

innodb_buffer_pool_load_now

OFF

innodb_buffer_pool_size

134217728

innodb_change_buffer_max_size

innodb_change_buffering

all

innodb_checksum_algorithm

crc32

innodb_checksums

innodb_cmp_per_index_enabled

OFF

innodb_commit_concurrency

innodb_compression_failure_threshold_pct

innodb_compression_level

innodb_compression_pad_pct_max

innodb_concurrency_tickets

5000

innodb_data_file_path

ibdata1:12M:autoextend

innodb_data_home_dir

innodb_deadlock_detect

innodb_default_row_format

dynamic

innodb_disable_sort_file_cache

OFF

innodb_doublewrite

innodb_fast_shutdown

innodb_file_format

Barracuda

innodb_file_format_check

innodb_file_format_max

Barracuda

innodb_file_per_table

innodb_fill_factor

100

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

OFF

innodb_force_recovery

innodb_ft_aux_table

innodb_ft_cache_size

8000000

innodb_ft_enable_diag_print

OFF

innodb_ft_enable_stopword

innodb_ft_max_token_size

innodb_ft_min_token_size

innodb_ft_num_word_optimize

2000

innodb_ft_result_cache_limit

2000000000

innodb_ft_server_stopword_table

innodb_ft_sort_pll_degree

innodb_ft_total_cache_size

640000000

innodb_ft_user_stopword_table

innodb_io_capacity

200

innodb_io_capacity_max

2000

innodb_large_prefix

innodb_lock_wait_timeout

innodb_locks_unsafe_for_binlog

OFF

innodb_log_buffer_size

16777216

innodb_log_checksums

innodb_log_compressed_pages

innodb_log_file_size

50331648

innodb_log_files_in_group

innodb_log_group_home_dir

innodb_log_write_ahead_size

8192

innodb_lru_scan_depth

1024

innodb_max_dirty_pages_pct

75.000000

innodb_max_dirty_pages_pct_lwm

0.000000

innodb_max_purge_lag

innodb_max_purge_lag_delay

innodb_max_undo_log_size

1073741824

innodb_monitor_disable

innodb_monitor_enable

innodb_monitor_reset

innodb_monitor_reset_all

innodb_old_blocks_pct

innodb_old_blocks_time

1000

innodb_online_alter_log_max_size

134217728

innodb_open_files

2000

innodb_optimize_fulltext_only

OFF

innodb_page_cleaners

innodb_page_size

16384

innodb_print_all_deadlocks

OFF

innodb_purge_batch_size

300

innodb_purge_rseg_truncate_frequency

128

innodb_purge_threads

innodb_random_read_ahead

OFF

innodb_read_ahead_threshold

innodb_read_io_threads

innodb_read_only

OFF

innodb_replication_delay

innodb_rollback_on_timeout

OFF

innodb_rollback_segments

128

innodb_sort_buffer_size

1048576

innodb_spin_wait_delay

innodb_stats_auto_recalc

innodb_stats_method

nulls_equal

innodb_stats_on_metadata

OFF

innodb_stats_persistent

innodb_stats_persistent_sample_pages

innodb_stats_sample_pages

innodb_stats_transient_sample_pages

innodb_status_output

OFF

innodb_status_output_locks

OFF

innodb_strict_mode

innodb_support_xa

innodb_sync_array_size

innodb_sync_spin_loops

innodb_table_locks

innodb_temp_data_file_path

ibtmp1:12M:autoextend

innodb_thread_concurrency

innodb_thread_sleep_delay

10000

innodb_tmpdir

innodb_undo_directory

innodb_undo_log_truncate

OFF

innodb_undo_logs

128

innodb_undo_tablespaces

innodb_use_native_aio

innodb_version

5.7.15

innodb_write_io_threads

insert_id

interactive_timeout

28800

internal_tmp_disk_storage_engine

InnoDB

join_buffer_size

262144

keep_files_on_create

OFF

key_buffer_size

8388608

key_cache_age_threshold

300

key_cache_block_size

1024

key_cache_division_limit

100

large_files_support

large_page_size

large_pages

OFF

last_insert_id

lc_messages

en_US

lc_messages_dir

d:\wamp\mysql\share\

lc_time_names

en_US

license

GPL

local_infile

lock_wait_timeout

31536000

log_bin

OFF

log_bin_basename

log_bin_index

log_bin_trust_function_creators

OFF

log_bin_use_v1_row_events

OFF

log_builtin_as_identified_by_password

OFF

log_error

d:\wamp\mysql\data\DESKTOP-FFRU10B.err

log_error_verbosity

log_output

FILE

log_queries_not_using_indexes

OFF

log_slave_updates

OFF

log_slow_admin_statements

OFF

log_slow_slave_statements

OFF

log_statements_unsafe_for_binlog

log_syslog

log_syslog_tag

log_throttle_queries_not_using_indexes

log_timestamps

UTC

log_warnings

long_query_time

10.000000

low_priority_updates

OFF

lower_case_file_system

lower_case_table_names

master_info_repository

FILE

master_verify_checksum

OFF

max_allowed_packet

4194304

max_binlog_cache_size

18446744073709547520

max_binlog_size

1073741824

max_binlog_stmt_cache_size

18446744073709547520

max_connect_errors

100

max_connections

151

max_delayed_threads

max_digest_length

1024

max_error_count

max_execution_time

max_heap_table_size

16777216

max_insert_delayed_threads

max_join_size

18446744073709551615

max_length_for_sort_data

1024

max_points_in_geometry

65536

max_prepared_stmt_count

16382

max_relay_log_size

max_seeks_for_key

4294967295

max_sort_length

1024

max_sp_recursion_depth

max_tmp_tables

max_user_connections

max_write_lock_count

4294967295

metadata_locks_cache_size

1024

metadata_locks_hash_instances

min_examined_row_limit

multi_range_count

256

myisam_data_pointer_size

myisam_max_sort_file_size

2146435072

myisam_mmap_size

18446744073709551615

myisam_recover_options

OFF

myisam_repair_threads

myisam_sort_buffer_size

8388608

myisam_stats_method

nulls_unequal

myisam_use_mmap

OFF

mysql_native_password_proxy_users

OFF

named_pipe

OFF

net_buffer_length

16384

net_read_timeout

net_retry_count

net_write_timeout

new

OFF

ngram_token_size

offline_mode

OFF

old

OFF

old_alter_table

OFF

old_passwords

open_files_limit

7048

optimizer_prune_level

optimizer_search_depth

optimizer_switch

index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on

optimizer_trace

enabled=off,one_line=off

optimizer_trace_features

greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on

optimizer_trace_limit

optimizer_trace_max_mem_size

16384

optimizer_trace_offset

-1

parser_max_mem_size

18446744073709551615

performance_schema

performance_schema_accounts_size

-1

performance_schema_digests_size

10000

performance_schema_events_stages_history_long_size

10000

performance_schema_events_stages_history_size

performance_schema_events_statements_history_long_size

10000

performance_schema_events_statements_history_size

performance_schema_events_transactions_history_long_size

10000

performance_schema_events_transactions_history_size

performance_schema_events_waits_history_long_size

10000

performance_schema_events_waits_history_size

performance_schema_hosts_size

-1

performance_schema_max_cond_classes

performance_schema_max_cond_instances

-1

performance_schema_max_digest_length

1024

performance_schema_max_file_classes

performance_schema_max_file_handles

32768

performance_schema_max_file_instances

-1

performance_schema_max_index_stat

-1

performance_schema_max_memory_classes

320

performance_schema_max_metadata_locks

-1

performance_schema_max_mutex_classes

200

performance_schema_max_mutex_instances

-1

performance_schema_max_prepared_statements_instances

-1

performance_schema_max_program_instances

-1

performance_schema_max_rwlock_classes

performance_schema_max_rwlock_instances

-1

performance_schema_max_socket_classes

performance_schema_max_socket_instances

-1

performance_schema_max_sql_text_length

1024

performance_schema_max_stage_classes

150

performance_schema_max_statement_classes

193

performance_schema_max_statement_stack

performance_schema_max_table_handles

-1

performance_schema_max_table_instances

-1

performance_schema_max_table_lock_stat

-1

performance_schema_max_thread_classes

performance_schema_max_thread_instances

-1

performance_schema_session_connect_attrs_size

512

performance_schema_setup_actors_size

-1

performance_schema_setup_objects_size

-1

performance_schema_users_size

-1

pid_file

d:\wamp\mysql\data\DESKTOP-FFRU10B.pid

plugin_dir

d:\wamp\mysql\lib\plugin\

port

3306

preload_buffer_size

32768

profiling

OFF

profiling_history_size

protocol_version

proxy_user

pseudo_slave_mode

OFF

pseudo_thread_id

query_alloc_block_size

8192

query_cache_limit

1048576

query_cache_min_res_unit

4096

query_cache_size

1048576

query_cache_type

OFF

query_cache_wlock_invalidate

OFF

query_prealloc_size

8192

rand_seed1

rand_seed2

range_alloc_block_size

4096

range_optimizer_max_mem_size

8388608

rbr_exec_mode

STRICT

read_buffer_size

131072

read_only

OFF

read_rnd_buffer_size

262144

relay_log

relay_log_basename

relay_log_index

relay_log_info_file

relay-log.info

relay_log_info_repository

FILE

relay_log_purge

relay_log_recovery

OFF

relay_log_space_limit

report_host

report_password

report_port

3306

report_user

require_secure_transport

OFF

rpl_stop_slave_timeout

31536000

secure_auth

secure_file_priv

server_id

server_id_bits

server_uuid

5e344b6d-8164-11e6-a215-40167e219a3d

session_track_gtids

OFF

session_track_schema

session_track_state_change

OFF

session_track_system_variables

time_zone,autocommit,character_set_client,character_set_results,character_set_connection

session_track_transaction_info

OFF

sha256_password_proxy_users

OFF

shared_memory

OFF

shared_memory_base_name

MYSQL

show_compatibility_56

OFF

show_old_temporals

OFF

skip_external_locking

skip_name_resolve

OFF

skip_networking

OFF

skip_show_database

OFF

slave_allow_batching

OFF

slave_checkpoint_group

512

slave_checkpoint_period

300

slave_compressed_protocol

OFF

slave_exec_mode

STRICT

slave_load_tmpdir

C:\Windows\TEMP

slave_max_allowed_packet

1073741824

slave_net_timeout

slave_parallel_type

DATABASE

slave_parallel_workers

slave_pending_jobs_size_max

16777216

slave_preserve_commit_order

OFF

slave_rows_search_algorithms

TABLE_SCAN,INDEX_SCAN

slave_skip_errors

OFF

slave_sql_verify_checksum

slave_transaction_retries

slave_type_conversions

slow_launch_time

slow_query_log

OFF

slow_query_log_file

d:\wamp\mysql\data\DESKTOP-FFRU10B-slow.log

socket

MySQL

sort_buffer_size

262144

sql_auto_is_null

OFF

sql_big_selects

sql_buffer_result

OFF

sql_log_bin

sql_log_off

OFF

sql_mode

STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

sql_notes

sql_quote_show_create

sql_safe_updates

OFF

sql_select_limit

18446744073709551615

sql_slave_skip_counter

sql_warnings

OFF

ssl_ca

ssl_capath

ssl_cert

ssl_cipher

ssl_crl

ssl_crlpath

ssl_key

stored_program_cache

256

super_read_only

OFF

sync_binlog

sync_frm

sync_master_info

10000

sync_relay_log

10000

sync_relay_log_info

10000

system_time_zone

table_definition_cache

1400

table_open_cache

2000

table_open_cache_instances

thread_cache_size

thread_handling

one-thread-per-connection

thread_stack

262144

time_format

%H:%i:%s

time_zone

SYSTEM

timestamp

1474618044.062102

tls_version

TLSv1,TLSv1.1

tmp_table_size

16777216

tmpdir

C:\Windows\TEMP

transaction_alloc_block_size

8192

transaction_allow_batching

OFF

transaction_prealloc_size

4096

transaction_write_set_extraction

OFF

tx_isolation

REPEATABLE-READ

tx_read_only

OFF

unique_checks

updatable_views_with_limit

YES

version

5.7.15

version_comment

MySQL Community Server (GPL)

version_compile_machine

x86_64

version_compile_os

Win64

wait_timeout

28800

warning_count