win环境下mysql5.5.34x64社区版所有变量的默认值

首页

数据库

mysql教程

win环境下mysql5.5.34x64社区版所有变量的默认值_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 01, 2016 pm 01:28 PM

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

声明

本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn

您什么时候应该使用复合索引与多个单列索引？Apr 11, 2025 am 12:06 AM

在数据库优化中，应根据查询需求选择索引策略：1.当查询涉及多个列且条件顺序固定时，使用复合索引；2.当查询涉及多个列但条件顺序不固定时，使用多个单列索引。复合索引适用于优化多列查询，单列索引则适合单列查询。

如何识别和优化MySQL中的慢速查询？（慢查询日志，performance_schema）Apr 10, 2025 am 09:36 AM

要优化MySQL慢查询，需使用slowquerylog和performance_schema：1.启用slowquerylog并设置阈值，记录慢查询；2.利用performance_schema分析查询执行细节，找出性能瓶颈并优化。

MySQL和SQL：开发人员的基本技能Apr 10, 2025 am 09:30 AM

MySQL和SQL是开发者必备技能。1.MySQL是开源的关系型数据库管理系统，SQL是用于管理和操作数据库的标准语言。2.MySQL通过高效的数据存储和检索功能支持多种存储引擎，SQL通过简单语句完成复杂数据操作。3.使用示例包括基本查询和高级查询，如按条件过滤和排序。4.常见错误包括语法错误和性能问题，可通过检查SQL语句和使用EXPLAIN命令优化。5.性能优化技巧包括使用索引、避免全表扫描、优化JOIN操作和提升代码可读性。

描述MySQL异步主奴隶复制过程。Apr 10, 2025 am 09:30 AM

MySQL异步主从复制通过binlog实现数据同步，提升读性能和高可用性。1)主服务器记录变更到binlog；2)从服务器通过I/O线程读取binlog；3)从服务器的SQL线程应用binlog同步数据。

mysql：简单的概念，用于轻松学习Apr 10, 2025 am 09:29 AM

MySQL是一个开源的关系型数据库管理系统。1）创建数据库和表：使用CREATEDATABASE和CREATETABLE命令。2）基本操作：INSERT、UPDATE、DELETE和SELECT。3）高级操作：JOIN、子查询和事务处理。4）调试技巧：检查语法、数据类型和权限。5）优化建议：使用索引、避免SELECT*和使用事务。

MySQL：数据库的用户友好介绍Apr 10, 2025 am 09:27 AM

MySQL的安装和基本操作包括：1.下载并安装MySQL，设置根用户密码；2.使用SQL命令创建数据库和表，如CREATEDATABASE和CREATETABLE；3.执行CRUD操作，使用INSERT,SELECT,UPDATE,DELETE命令；4.创建索引和存储过程以优化性能和实现复杂逻辑。通过这些步骤，你可以从零开始构建和管理MySQL数据库。

InnoDB缓冲池如何工作，为什么对性能至关重要？Apr 09, 2025 am 12:12 AM

InnoDBBufferPool通过将数据和索引页加载到内存中来提升MySQL数据库的性能。1)数据页加载到BufferPool中，减少磁盘I/O。2)脏页被标记并定期刷新到磁盘。3)LRU算法管理数据页淘汰。4)预读机制提前加载可能需要的数据页。

MySQL：初学者的数据管理易用性Apr 09, 2025 am 12:07 AM

MySQL适合初学者使用，因为它安装简单、功能强大且易于管理数据。1.安装和配置简单，适用于多种操作系统。2.支持基本操作如创建数据库和表、插入、查询、更新和删除数据。3.提供高级功能如JOIN操作和子查询。4.可以通过索引、查询优化和分表分区来提升性能。5.支持备份、恢复和安全措施，确保数据的安全和一致性。

See all articles