# for advice The change settings
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# * * * Don't EDIT this FILE. It ' s a template which'll be copied to the
# * * * default location during install, and would be replaced if you
# * * * * Upgrade to a newer version of MySQL.
[Mysqld]
# Remove Leading # and set to the amount of RAM for the most important data
# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
# Uncomment the following if you is using InnoDB tables
#innodb数据库数据文件目录
Innodb_data_home_dir=d:/java/mysql5.6.20win32/innodbdata
#:max:2000m #数据文件名称及大小
Innodb_data_file_path=ibdata2:100m:autoextend
Innodb_log_group_home_dir=d:/java/mysql5.6.20win32/innodbdata
# you can set: _buffer_pool_size up to 50-80%
# of RAM But beware of setting memory usage too high
#缓冲池的大小, the 50%-80% that are generally set as the primary storage
Innodb_buffer_pool_size = 20M
# Set: _log_file_size to% of buffer pool size
#日志文件的大小, generally set to 25% of the main deposit
Innodb_log_file_size = 200M
Innodb_log_buffer_size = 8M
#事务
Innodb_flush_log_at_trx_commit = 1
#秒
Innodb_lock_wait_timeout = 50
# Remove Leading # to turn on a very important data integrity option:logging
# Changes to the binary log between backups.
# Log_bin
# These is commonly set, remove the # and set as required.
# Basedir = ...
# DataDir = ...
# port = .....
# server_id = ...
# Remove Leading # To set options mainly useful for reporting servers.
# The server defaults is 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
#绑定IPv4和3306端口
Bind-address = 0.0.0.0
Port = 3306
# set up the MySQL installation directory
Basedir=d:/java/mysql5.6.20win32
# Set up a storage directory for MySQL database data
Datadir=d:/java/mysql5.6.20win32/data
# Maximum number of connections allowed
max_connections=200
Default-storage-engine=innodb
Innodb_flush_method=normal
MySQL InnoDB INI