win环境下mysql5.6.14的所有变量的默认值_MySQL
bitsCN.com
win环境下mysql5.6.14的所有变量的默认值
在windows mysql5.6.14 x64版本下my.ini如下：
[mysqld]port = 3306socket = /tmp/mysql.sockbasedir=D:/wamp/mysqldatadir=D:/wamp/data5/tmpdir=D:/wamp/tmp/character-set-server=utf8wait_timeout=60interactive_timeout=30skip-name-resolvebind-address=0.0.0.0thread_concurrency =4default-storage-engine = Innodbslow-query-log=1long_query_time = 0.01slow-query-log-file=slow.logserver-id = 1sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 通过工具查看的mysql的所有变量如下：init_file old_passwords 0port 3306protocol_version 10server_id 1version 5.6.14-logversion_comment MySQL Community Server (GPL)version_compile_machine x86_64version_compile_os Win64concurrent_insert AUTOhave_compress YEShave_crypt NOhave_openssl DISABLEDhave_query_cache YEShave_symlink YESlarge_files_support ONlocal_infile ONlow_priority_updates OFFlower_case_table_names 1named_pipe OFFnew OFFread_only OFFskip_networking OFFbasedir D:/wamp/mysqldatadir D:/wamp/data5/innodb_data_file_path ibdata1:12M:autoextendinnodb_log_group_home_dir ./log_error D:/wamp/data5/webtest.erropen_files_limit 7048pid_file D:/wamp/data5/webtest.pidtmpdir D:/wamp/tmp/innodb_log_buffer_size 8Minnodb_log_file_size 48Minnodb_log_files_in_group 2innodb_log_group_home_dir ./log_bin OFFlog_error D:/wamp/data5/webtest.errlog_slave_updates OFFlog_warnings 1max_binlog_cache_size 17592186044416Mmax_binlog_size 1024Mmax_relay_log_size 0delay_key_write ONdelayed_insert_limit 100delayed_insert_timeout 300delayed_queue_size 1000flush OFFflush_time 0long_query_time 2.000000low_priority_updates OFFmax_delayed_threads 20max_join_size 17592186044416Mmax_seeks_for_key 4095.99999904632Mmax_sort_length 1024max_write_lock_count 4294967295query_alloc_block_size 8192query_prealloc_size 8192range_alloc_block_size 4096slow_launch_time 2thread_cache_size 9expire_logs_days 0max_error_count 64max_length_for_sort_data 1024preload_buffer_size 32Krelay_log_purge ONsecure_auth ONshared_memory OFFshared_memory_base_name MYSQLstorage_engine InnoDBback_log 80connect_timeout 10interactive_timeout 30max_connect_errors 100max_connections 151max_user_connections 0wait_timeout 60connect_timeout 10max_allowed_packet 4194304named_pipe OFFnet_read_timeout 30net_retry_count 10net_write_timeout 60skip_networking OFFslave_net_timeout 3600wait_timeout 60skip_networking OFFskip_show_database OFFinit_connect init_slave log_warnings 1lower_case_table_names 1max_sort_length 1024skip_external_locking ONsql_mode STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTIONtransaction_alloc_block_size 8192transaction_prealloc_size 4096tx_isolation REPEATABLE-READcharacter_set_client utf8character_set_connection utf8character_set_database utf8character_set_results utf8character_set_server utf8character_set_system utf8collation_connection utf8_general_cicollation_database utf8_general_cicollation_server utf8_general_cidate_format %Y-%m-%ddatetime_format %Y-%m-%d %H:%i:%sdefault_week_format 0time_format %H:%i:%sft_boolean_syntax + -><()~*:""&|ft_max_word_len 84ft_min_word_len 4ft_query_expansion_limit 20ft_stopword_file (built-in)max_heap_table_size 16Mmax_tmp_tables 32thread_stack 256Ktmp_table_size 16Mbulk_insert_buffer_size 8Minnodb_additional_mem_pool_size 8Minnodb_buffer_pool_size 128Minnodb_log_buffer_size 8Mjoin_buffer_size 256Kkey_buffer_size 8Mmyisam_sort_buffer_size 8Mnet_buffer_length 16Kread_buffer_size 128Kread_rnd_buffer_size 256Ksort_buffer_size 256Kbinlog_cache_size 32Kkey_cache_age_threshold 300key_cache_block_size 1024key_cache_pision_limit 100query_cache_limit 1Mquery_cache_min_res_unit 4Kquery_cache_size 1Mquery_cache_type OFFinnodb_additional_mem_pool_size 8Minnodb_buffer_pool_size 128Minnodb_data_file_path ibdata1:12M:autoextendinnodb_fast_shutdown 1innodb_file_per_table ONinnodb_flush_log_at_trx_commit 1innodb_flush_method innodb_force_recovery 0innodb_lock_wait_timeout 50innodb_log_buffer_size 8Minnodb_log_file_size 48Minnodb_log_files_in_group 2innodb_log_group_home_dir ./innodb_max_dirty_pages_pct 75innodb_mirrored_log_groups 1innodb_open_files 2000innodb_thread_concurrency 0myisam_max_sort_file_size 2047Mmyisam_recover_options OFFmyisam_repair_threads 1auto_increment_increment 1auto_increment_offset 1autocommit ONautomatic_sp_privileges ONbig_tables OFFbind_address 0.0.0.0binlog_checksum CRC32binlog_direct_non_transactional_OFFbinlog_format STATEMENTbinlog_max_flush_queue_time 0binlog_order_commits ONbinlog_row_image FULLbinlog_rows_query_log_events OFFbinlog_stmt_cache_size 32Kcharacter_set_filesystem binarycharacter_sets_dir D:/wamp/mysql/share/charsets/completion_type NO_CHAINcore_file OFFdefault_storage_engine InnoDBdefault_tmp_storage_engine InnoDBdisconnect_on_expired_password ONp_precision_increment 4end_markers_in_json OFFenforce_gtid_consistency OFFeq_range_index_pe_limit 10event_scheduler OFFexplicit_defaults_for_timestamp OFFforeign_key_checks ONgeneral_log OFFgeneral_log_file D:/wamp/data5/webtest.loggroup_concat_max_len 1024gtid_executed gtid_mode OFFgtid_owned gtid_purged have_dynamic_loading YEShave_geometry YEShave_profiling YEShave_rtree_keys YEShave_ssl DISABLEDhost_cache_size 279hostname webtestignore_builtin_innodb OFFignore_db_dirs innodb_adaptive_flushing ONinnodb_adaptive_flushing_lwm 10innodb_adaptive_hash_index ONinnodb_adaptive_max_sleep_delay 150000innodb_api_bk_commit_interval 5innodb_api_disable_rowlock OFFinnodb_api_enable_binlog OFFinnodb_api_enable_mdl OFFinnodb_api_trx_level 0innodb_autoextend_increment 64innodb_autoinc_lock_mode 1innodb_buffer_pool_dump_at_shutdOFFinnodb_buffer_pool_dump_now OFFinnodb_buffer_pool_filename ib_buffer_poolinnodb_buffer_pool_instances 8innodb_buffer_pool_load_abort OFFinnodb_buffer_pool_load_at_startOFFinnodb_buffer_pool_load_now OFFinnodb_change_buffer_max_size 25innodb_change_buffering allinnodb_checksum_algorithm innodbinnodb_checksums ONinnodb_cmp_per_index_enabled OFFinnodb_commit_concurrency 0innodb_compression_failure_thres5innodb_compression_level 6innodb_compression_pad_pct_max 50innodb_concurrency_tickets 5000innodb_data_home_dir innodb_disable_sort_file_cache OFFinnodb_doublewrite ONinnodb_file_format Antelopeinnodb_file_format_check ONinnodb_file_format_max Antelopeinnodb_flush_log_at_timeout 1innodb_flush_neighbors 1innodb_flushing_avg_loops 30innodb_force_load_corrupted OFFinnodb_ft_aux_table innodb_ft_cache_size 8000000innodb_ft_enable_diag_print OFFinnodb_ft_enable_stopword ONinnodb_ft_max_token_size 84innodb_ft_min_token_size 3innodb_ft_num_word_optimize 2000innodb_ft_result_cache_limit 2000000000innodb_ft_server_stopword_table innodb_ft_sort_pll_degree 2innodb_ft_total_cache_size 640000000innodb_ft_user_stopword_table innodb_io_capacity 200innodb_io_capacity_max 2000innodb_large_prefix OFFinnodb_locks_unsafe_for_binlog OFFinnodb_log_compressed_pages ONinnodb_lru_scan_depth 1024innodb_max_dirty_pages_pct_lwm 0innodb_max_purge_lag 0innodb_max_purge_lag_delay 0innodb_monitor_disable innodb_monitor_enable innodb_monitor_reset innodb_monitor_reset_all innodb_old_blocks_pct 37innodb_old_blocks_time 1000innodb_online_alter_log_max_size128Minnodb_optimize_fulltext_only OFFinnodb_page_size 16Kinnodb_print_all_deadlocks OFFinnodb_purge_batch_size 300innodb_purge_threads 1innodb_random_read_ahead OFFinnodb_read_ahead_threshold 56innodb_read_io_threads 4innodb_read_only OFFinnodb_replication_delay 0innodb_rollback_on_timeout OFFinnodb_rollback_segments 128innodb_sort_buffer_size 1Minnodb_spin_wait_delay 6innodb_stats_auto_recalc ONinnodb_stats_method nulls_equalinnodb_stats_on_metadata OFFinnodb_stats_persistent ONinnodb_stats_persistent_sample_p20innodb_stats_sample_pages 8innodb_stats_transient_sample_pa8innodb_strict_mode OFFinnodb_support_xa ONinnodb_sync_array_size 1innodb_sync_spin_loops 30innodb_table_locks ONinnodb_thread_sleep_delay 10000innodb_undo_directory .innodb_undo_logs 128innodb_undo_tablespaces 0innodb_use_native_aio ONinnodb_use_sys_malloc ONinnodb_version 5.6.14innodb_write_io_threads 4keep_files_on_create OFFlarge_page_size 0large_pages OFFlc_messages en_USlc_messages_dir D:/wamp/mysql/share/lc_time_names en_USlicense GPLlock_wait_timeout 31536000log_bin_basename log_bin_index log_bin_trust_function_creators OFFlog_bin_use_v1_row_events OFFlog_output FILElog_queries_not_using_indexes OFFlog_slow_admin_statements OFFlog_slow_slave_statements OFFlog_throttle_queries_not_using_i0lower_case_file_system ONmaster_info_repository FILEmaster_verify_checksum OFFmax_binlog_stmt_cache_size 18446744073709547520max_insert_delayed_threads 20max_prepared_stmt_count 16382max_sp_recursion_depth 0metadata_locks_cache_size 1024metadata_locks_hash_instances 8min_examined_row_limit 0multi_range_count 256myisam_data_pointer_size 6myisam_mmap_size 18446744073709551615myisam_stats_method nulls_unequalmyisam_use_mmap OFFold OFFold_alter_table OFFoptimizer_prune_level 1optimizer_search_depth 62optimizer_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,batchedoptimizer_trace enabled=off,one_line=offoptimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=onoptimizer_trace_limit 1optimizer_trace_max_mem_size 16Koptimizer_trace_offset -1performance_schema ONperformance_schema_accounts_size100performance_schema_digests_size 10000performance_schema_events_stages10000performance_schema_events_stages10performance_schema_events_statem10000performance_schema_events_statem10performance_schema_events_waits_10000performance_schema_events_waits_10performance_schema_hosts_size 100performance_schema_max_cond_clas80performance_schema_max_cond_inst3504performance_schema_max_file_clas50performance_schema_max_file_hand32768performance_schema_max_file_inst7693performance_schema_max_mutex_cla200performance_schema_max_mutex_ins15906performance_schema_max_rwlock_cl30performance_schema_max_rwlock_in9102performance_schema_max_socket_cl10performance_schema_max_socket_in322performance_schema_max_stage_cla150performance_schema_max_statement168performance_schema_max_table_han4000performance_schema_max_table_ins12500performance_schema_max_thread_cl50performance_schema_max_thread_in402performance_schema_session_conne512performance_schema_setup_actors_100performance_schema_setup_objects100performance_schema_users_size 100plugin_dir D:/wamp/mysql/lib/plugin/profiling OFFprofiling_history_size 15query_cache_wlock_invalidate OFFrelay_log relay_log_basename relay_log_index relay_log_info_file relay-log.inforelay_log_info_repository FILErelay_log_recovery OFFrelay_log_space_limit 0report_host report_password report_port 3306report_user rpl_stop_slave_timeout 31536000secure_file_priv server_id_bits 32server_uuid 2ab70a0e-a1c4-11e2-9c60-60eb69d711caskip_name_resolve ONslave_allow_batching OFFslave_checkpoint_group 512slave_checkpoint_period 300slave_compressed_protocol OFFslave_exec_mode STRICTslave_load_tmpdir D:/wamp/tmp/slave_max_allowed_packet 1073741824slave_parallel_workers 0slave_pending_jobs_size_max 16777216slave_rows_search_algorithms TABLE_SCAN,INDEX_SCANslave_skip_errors OFFslave_sql_verify_checksum ONslave_transaction_retries 10slave_type_conversions slow_query_log ONslow_query_log_file slow.logsocket /tmp/mysql.socksql_auto_is_null OFFsql_big_selects ONsql_buffer_result OFFsql_log_bin ONsql_log_off OFFsql_notes ONsql_quote_show_create ONsql_safe_updates OFFsql_select_limit 18446744073709551615sql_slave_skip_counter 0sql_warnings OFFssl_ca ssl_capath ssl_cert ssl_cipher ssl_crl ssl_crlpath ssl_key stored_program_cache 256sync_binlog 0sync_frm ONsync_master_info 10000sync_relay_log 10000sync_relay_log_info 10000system_time_zone table_definition_cache 1400table_open_cache 2000table_open_cache_instances 1thread_concurrency 4thread_handling one-thread-per-connectiontime_zone SYSTEMtimed_mutexes OFFtx_read_only OFFunique_checks ONupdatable_views_with_limit YES
bitsCN.com
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Java uses the isLetterOrDigit() function of the Character class to determine whether a character is a letter or number
Jul 24, 2023 pm 02:45 PM
Java uses the isLetterOrDigit() function of the Character class to determine whether a character is a letter or number. In Java programming, we often need to perform some operations and judgments on characters. One of the common needs is to determine whether a character is a letter or a number. Java provides the isLetterOrDigit() function of the Character class to help us implement this function. The Character class is a wrapper class used to operate and judge characters.
Use java's Character.isDefined() function to determine whether a character is a defined character
Jul 25, 2023 am 10:33 AM
Use Java's Character.isDefined() function to determine whether a character is a defined character. In Java programming, sometimes you need to determine whether a character is a defined character. For convenience, Java provides the isDefined() function of the Character class, which can help us quickly determine whether a character is a defined character. This article explains how to use this function and provides some code examples. Character class represents a single character in Java
Java documentation interpretation: Detailed explanation of the isAlphabetic() method of the Character class
Nov 04, 2023 am 10:05 AM
Interpretation of Java documentation: Detailed explanation of the isAlphabetic() method of the Character class 1. Overview In the Java Character class, the isAlphabetic() method is used to determine whether a given character is an alphabetic character. It returns a boolean value, true indicating that the given character is an alphabetic character, false indicating that the given character is not an alphabetic character. This article will provide a detailed analysis of the use and principle of this method, and provide code examples to help readers better understand
Use java's Character.isLetterOrDigit() function to determine whether a character is a letter or number
Jul 25, 2023 pm 04:22 PM
Use Java's Character.isLetterOrDigit() function to determine whether a character is a letter or number. In Java, we often need to determine whether a character is a letter or number. In order to simplify this process, Java provides a built-in function Character.isLetterOrDigit(), which can help us quickly complete this judgment. The Character.isLetterOrDigit() function accepts a character as a parameter
Use java's Character.isUpperCase() function to determine whether a character is an uppercase letter
Jul 25, 2023 pm 11:45 PM
Use java's Character.isUpperCase() function to determine whether a character is an uppercase letter. In Java programming, sometimes we need to determine whether a character is an uppercase letter. Fortunately, Java provides a very convenient way to achieve this function, which is to use the isUpperCase() function of the Character class. This article will introduce how to use this function to make judgments and illustrate it with code examples. First, we need to understand Chara
Java documentation interpretation: Detailed explanation of the isLowerCase() method of the Character class
Nov 03, 2023 am 10:36 AM
Java documentation interpretation: Detailed explanation of the isLowerCase() method of the Character class. The Character class in Java provides many methods to handle character operations. The isLowerCase() method is used to determine whether a character is a lowercase letter. The specific use and application scenarios of this method will be explained in detail in this article. 1. The function and usage of isLowerCase() method The isLowerCase() method of Character class
Use java's Character.isWhitespace() function to determine whether a character is a space
Jul 24, 2023 pm 10:16 PM
Use Java's Character.isWhitespace() function to determine whether a character is a space. In daily programming, we often encounter situations where we need to determine whether a character is a space. Java provides a very convenient method: Character.isWhitespace(). This method can determine whether a character is a space character in Unicode, not just ASCII space characters. Here’s how to use Chara
Use java's Character.isWhitespace() function to determine whether a character is a whitespace character
Jul 24, 2023 pm 01:25 PM
Use Java's Character.isWhitespace() function to determine whether a character is a whitespace character. In Java programming, you often encounter situations where you need to determine whether a character is a whitespace character. Whitespace characters refer to characters that are invisible and not printed on the screen, such as spaces, tabs, newlines, etc. Java provides the isWhitespace() function in the Character class to determine whether a character is a whitespace character. isWhitespace() function is C
