bitsCN.com
win环境下mysql5.5.34x64社区版所有变量的默认值
my.ini文件内容：
[mysqld]port = 3307basedir=D:/wamp2/mysqltmpdir=D:/wamp2/tmp/sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
变量的默认值：
init_file old_passwords OFFport 3307protocol_version 10server_id 0version 5.5.34version_comment MySQL Community Server (GPL)version_compile_machine x86version_compile_os Win64concurrent_insert AUTOhave_compress YEShave_crypt NOhave_innodb YEShave_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:/wamp2/mysqldatadir D:/wamp2/mysql/data/innodb_data_file_path ibdata1:10M:autoextendinnodb_log_group_home_dir ./log_error D:/wamp2/mysql/data/webtest.erropen_files_limit 3009pid_file D:/wamp2/mysql/data/webtest.pidtmpdir D:/wamp2/tmp/innodb_log_buffer_size 8388608innodb_log_file_size 5242880innodb_log_files_in_group 2innodb_log_group_home_dir ./log OFFlog_bin OFFlog_error D:/wamp2/mysql/data/webtest.errlog_slave_updates OFFlog_slow_queries OFFlog_warnings 1max_binlog_cache_size 18446744073709547520max_binlog_size 1073741824max_relay_log_size 0rpl_recovery_rank 0delay_key_write ONdelayed_insert_limit 100delayed_insert_timeout 300delayed_queue_size 1000flush OFFflush_time 1800long_query_time 10.000000low_priority_updates OFFmax_delayed_threads 20max_join_size 18446744073709551615max_seeks_for_key 4294967295max_sort_length 1024max_write_lock_count 4294967295query_alloc_block_size 8192query_prealloc_size 8192range_alloc_block_size 4096slow_launch_time 2thread_cache_size 0expire_logs_days 0max_error_count 64max_length_for_sort_data 1024preload_buffer_size 32768relay_log_purge ONsecure_auth OFFshared_memory OFFshared_memory_base_name MYSQLstorage_engine InnoDBback_log 50connect_timeout 10interactive_timeout 28800max_connect_errors 10max_connections 151max_user_connections 0wait_timeout 28800connect_timeout 10max_allowed_packet 1048576named_pipe OFFnet_read_timeout 30net_retry_count 10net_write_timeout 60skip_networking OFFslave_net_timeout 3600wait_timeout 28800skip_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 latin1character_set_connection latin1character_set_database latin1character_set_results latin1character_set_server latin1character_set_system utf8collation_connection latin1_swedish_cicollation_database latin1_swedish_cicollation_server latin1_swedish_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 16777216max_tmp_tables 32thread_stack 262144tmp_table_size 16777216bulk_insert_buffer_size 8388608innodb_additional_mem_pool_size 8388608innodb_buffer_pool_size 134217728innodb_log_buffer_size 8388608join_buffer_size 131072key_buffer_size 8388608myisam_sort_buffer_size 8388608net_buffer_length 16384read_buffer_size 131072read_rnd_buffer_size 262144sort_buffer_size 2097152binlog_cache_size 32768key_cache_age_threshold 300key_cache_block_size 1024key_cache_pision_limit 100query_cache_limit 1048576query_cache_min_res_unit 4096query_cache_size 0query_cache_type ONhave_innodb YESinnodb_additional_mem_pool_size 8388608innodb_buffer_pool_size 134217728innodb_data_file_path ibdata1:10M:autoextendinnodb_fast_shutdown 1innodb_file_per_table OFFinnodb_flush_log_at_trx_commit 1innodb_flush_method innodb_force_recovery 0innodb_lock_wait_timeout 50innodb_log_buffer_size 8388608innodb_log_file_size 5242880innodb_log_files_in_group 2innodb_log_group_home_dir ./innodb_max_dirty_pages_pct 75innodb_mirrored_log_groups 1innodb_open_files 300innodb_thread_concurrency 0myisam_max_sort_file_size 2146435072myisam_recover_options OFFmyisam_repair_threads 1auto_increment_increment 1auto_increment_offset 1autocommit ONautomatic_sp_privileges ONbig_tables OFFbinlog_direct_non_transactional_OFFbinlog_format STATEMENTbinlog_stmt_cache_size 32768character_set_filesystem binarycharacter_sets_dir D:/wamp2/mysql/share/charsets/completion_type NO_CHAINdefault_storage_engine InnoDBp_precision_increment 4engine_condition_pushdown ONevent_scheduler OFFforeign_key_checks ONgeneral_log OFFgeneral_log_file D:/wamp2/mysql/data/webtest.loggroup_concat_max_len 1024have_csv YEShave_dynamic_loading YEShave_geometry YEShave_ndbcluster NOhave_partitioning YEShave_profiling YEShave_rtree_keys YEShave_ssl DISABLEDhostname webtestignore_builtin_innodb OFFinnodb_adaptive_flushing ONinnodb_adaptive_hash_index ONinnodb_autoextend_increment 8innodb_autoinc_lock_mode 1innodb_buffer_pool_instances 1innodb_change_buffering allinnodb_checksums ONinnodb_commit_concurrency 0innodb_concurrency_tickets 500innodb_data_home_dir innodb_doublewrite ONinnodb_file_format Antelopeinnodb_file_format_check ONinnodb_file_format_max Antelopeinnodb_force_load_corrupted OFFinnodb_io_capacity 200innodb_large_prefix OFFinnodb_locks_unsafe_for_binlog OFFinnodb_max_purge_lag 0innodb_old_blocks_pct 37innodb_old_blocks_time 0innodb_print_all_deadlocks OFFinnodb_purge_batch_size 20innodb_purge_threads 0innodb_random_read_ahead OFFinnodb_read_ahead_threshold 56innodb_read_io_threads 4innodb_replication_delay 0innodb_rollback_on_timeout OFFinnodb_rollback_segments 128innodb_spin_wait_delay 6innodb_stats_method nulls_equalinnodb_stats_on_metadata ONinnodb_stats_sample_pages 8innodb_strict_mode OFFinnodb_support_xa ONinnodb_sync_spin_loops 30innodb_table_locks ONinnodb_thread_sleep_delay 10000innodb_use_native_aio ONinnodb_use_sys_malloc ONinnodb_version 5.5.34innodb_write_io_threads 4keep_files_on_create OFFlarge_page_size 0large_pages OFFlc_messages en_USlc_messages_dir D:/wamp2/mysql/share/lc_time_names en_USlicense GPLlock_wait_timeout 31536000log_bin_trust_function_creators OFFlog_output FILElog_queries_not_using_indexes OFFlower_case_file_system ONmax_binlog_stmt_cache_size 18446744073709547520max_insert_delayed_threads 20max_long_data_size 1048576max_prepared_stmt_count 16382max_sp_recursion_depth 0metadata_locks_cache_size 1024min_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=onperformance_schema OFFperformance_schema_events_waits_10000performance_schema_events_waits_10performance_schema_max_cond_clas80performance_schema_max_cond_inst1000performance_schema_max_file_clas50performance_schema_max_file_hand32768performance_schema_max_file_inst10000performance_schema_max_mutex_cla200performance_schema_max_mutex_ins1000000performance_schema_max_rwlock_cl30performance_schema_max_rwlock_in1000000performance_schema_max_table_han100000performance_schema_max_table_ins50000performance_schema_max_thread_cl50performance_schema_max_thread_in1000plugin_dir D:/wamp2/mysql/lib/plugin/profiling OFFprofiling_history_size 15query_cache_wlock_invalidate OFFrelay_log relay_log_index relay_log_info_file relay-log.inforelay_log_recovery OFFrelay_log_space_limit 0report_host report_password report_port 3307report_user secure_file_priv skip_name_resolve OFFslave_compressed_protocol OFFslave_exec_mode STRICTslave_load_tmpdir D:/wamp2/tmp/slave_max_allowed_packet 1073741824slave_skip_errors OFFslave_transaction_retries 10slave_type_conversions slow_query_log OFFslow_query_log_file D:/wamp2/mysql/data/webtest-slow.logsocket MySQLsql_auto_is_null OFFsql_big_selects ONsql_big_tables OFFsql_buffer_result OFFsql_log_bin ONsql_log_off OFFsql_low_priority_updates OFFsql_max_join_size 18446744073709551615sql_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_key stored_program_cache 256sync_binlog 0sync_frm ONsync_master_info 0sync_relay_log 0sync_relay_log_info 0system_time_zone table_definition_cache 400table_open_cache 400thread_concurrency 10thread_handling one-thread-per-connectiontime_zone SYSTEMtimed_mutexes OFFunique_checks ONupdatable_views_with_limit YES
bitsCN.com
Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
How do you alter a table in MySQL using the ALTER TABLE statement?Mar 19, 2025 pm 03:51 PMThe article discusses using MySQL's ALTER TABLE statement to modify tables, including adding/dropping columns, renaming tables/columns, and changing column data types.
How do I configure SSL/TLS encryption for MySQL connections?Mar 18, 2025 pm 12:01 PMArticle discusses configuring SSL/TLS encryption for MySQL, including certificate generation and verification. Main issue is using self-signed certificates' security implications.[Character count: 159]
How do you handle large datasets in MySQL?Mar 21, 2025 pm 12:15 PMArticle discusses strategies for handling large datasets in MySQL, including partitioning, sharding, indexing, and query optimization.
What are some popular MySQL GUI tools (e.g., MySQL Workbench, phpMyAdmin)?Mar 21, 2025 pm 06:28 PMArticle discusses popular MySQL GUI tools like MySQL Workbench and phpMyAdmin, comparing their features and suitability for beginners and advanced users.[159 characters]
How do you drop a table in MySQL using the DROP TABLE statement?Mar 19, 2025 pm 03:52 PMThe article discusses dropping tables in MySQL using the DROP TABLE statement, emphasizing precautions and risks. It highlights that the action is irreversible without backups, detailing recovery methods and potential production environment hazards.
How do you create indexes on JSON columns?Mar 21, 2025 pm 12:13 PMThe article discusses creating indexes on JSON columns in various databases like PostgreSQL, MySQL, and MongoDB to enhance query performance. It explains the syntax and benefits of indexing specific JSON paths, and lists supported database systems.
How do you represent relationships using foreign keys?Mar 19, 2025 pm 03:48 PMArticle discusses using foreign keys to represent relationships in databases, focusing on best practices, data integrity, and common pitfalls to avoid.
How do I secure MySQL against common vulnerabilities (SQL injection, brute-force attacks)?Mar 18, 2025 pm 12:00 PMArticle discusses securing MySQL against SQL injection and brute-force attacks using prepared statements, input validation, and strong password policies.(159 characters)
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
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
How Long Does It Take To Beat Split Fiction?
4 weeks agoByDDD
R.E.P.O. Save File Location: Where Is It & How to Protect It?
4 weeks agoByDDD
Two Point Museum: All Exhibits And Where To Find Them
1 months agoBy尊渡假赌尊渡假赌尊渡假赌
Hot Tools
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
Atom editor mac version download
The most popular open source editor
Dreamweaver Mac version
Visual web development tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 English version
Recommended: Win version, supports code prompts!
