正确的mysql5.6.24中my.ini配置文件
来源:互联网 发布:edius6软件下载 编辑:程序博客网 时间:2024/06/11 09:51
正确的mysql5.6.24中my.ini配置文件,拿过去修改成你对应的版本号和对应的路径就可以用了,下载的mysql如果启动不了,基本上都是配置文件的问题。
my.ini
[client]
#password =1234
# pipe
# socket=mysql
port=3306
default-character-set=gbk
[mysql]
port=3306
default-character-set=gbk
[mysqld]
port=3306
basedir="E:\mysql-5.6.24-winx64"
datadir="E:\mysql-5.6.24-winx64\data"
character-set-server=gbk
default-storage-engine=INNODB
# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
# Enable Windows Authentication
# plugin-load=authentication_windows.dll
# General and Slow logging.
log-output=NONE
general-log=0
general_log_file="WANGZHANGJIE.log"
slow-query-log=0
slow_query_log_file="WANGZHANGJIE-slow.log"
long_query_time=10
# Binary Logging.
# log-bin
# Error Logging.
log-error="WANGZHANGJIE.err"
max_connections=100
query_cache_size=0
table_open_cache=2000
tmp_table_size=20M
thread_cache_size=9
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=39M
key_buffer_size=8M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#*** INNODB Specific options ***
# innodb_data_home_dir=0.0
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=97M
innodb_log_file_size=48M
innodb_thread_concurrency=9
# The increment size (in MB) for extending the size of an auto-extend InnoDB system tablespace file when it becomes full.
innodb_autoextend_increment=64M
innodb_buffer_pool_instances=8
# Determines the number of threads that can enter InnoDB concurrently.
innodb_concurrency_tickets=5000
# Specifies how long in milliseconds (ms) a block inserted into the old sublist must stay there after its first access before
# it can be moved to the new sublist.
innodb_old_blocks_time=1000
# It specifies the maximum number of .ibd files that MySQL can keep open at one time. The minimum value is 10.
innodb_open_files=300
# When this variable is enabled, InnoDB updates statistics during metadata statements.
innodb_stats_on_metadata=0
# When innodb_file_per_table is enabled (the default in 5.6.6 and higher), InnoDB stores the data and indexes for each newly created table
# in a separate .ibd file, rather than in the system tablespace.
innodb_file_per_table=1
# Use the following list of values: 0 for crc32, 1 for strict_crc32, 2 for innodb, 3 for strict_innodb, 4 for none, 5 for strict_none.
innodb_checksum_algorithm=0
back_log=70
flush_time=0
join_buffer_size=256K
max_allowed_packet=4M
max_connect_errors=100
open_files_limit=4110
query_cache_type=0
sort_buffer_size=256K
table_definition_cache=1400
binlog_row_event_max_size=8K
sync_master_info=10000
sync_relay_log=10000
sync_relay_log_info=10000
- 正确的mysql5.6.24中my.ini配置文件
- MySQL5.5 配置文件 my.ini
- MySql5.6 的配置文件路径(For windows - my.ini)
- MySQL5.5 配置文件 my.ini 1067错误
- mysql5.6 my.ini配置文件修改无效
- MySQL5.5绿色版安装my.ini配置文件
- MySQL5.5 配置文件 my.ini 1067错误
- windows下mysql5.6.x的日志正确配置方法(my.ini)
- Mysql5.6的my.ini的位置
- MySQL5.5 的my.ini位置
- mysql5.5更换配置文件my.ini后无法登录
- mysql5.7安装版my.ini配置文件路径
- Windows下MySQL5.6查找my.ini配置文件
- (mysql5.0)my.ini
- mysql配置文件my.ini的分析
- mysql的配置文件my.ini修改问题
- windows7、windows8中mysql5.7的配置my.ini文件在哪
- my.ini配置文件
- 小甲鱼PE详解之IMAGE_NT_HEADERS结构定义即各个属性的作用(PE详解02)
- n个字符串按照字典序排列
- 句柄与指针的区别与联系
- 小火山的宝藏收益
- 使用Heritrix进行主题抓取
- 正确的mysql5.6.24中my.ini配置文件
- 【NOIP2013】火柴排队
- 华为OJ——删除字符串中出现次数最少的字符
- 自定义View——Path的基本用法
- kali 更新源,亲测好用
- 如何查询数据库中表的字段名?
- Cnskype完备的统一沟通能力
- Android手机号码正则表达式
- java守护线程的理解