mysql中my.ini的参数配置

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[client]
default-character-set = utf8mb4

[mysql]

#客户端的默认字符集

default-character-set = utf8mb4

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.

#服务器端的端口号

port = 3306

#mysql数据库服务器的安装目录

basedir = D:\mysql\mysql-5.6.17-winx64

#mysql数据库数据文件的目录

datadir = D:\mysql\mysql-5.6.17-winx64\data

character-set-client-handshake = FALSE

#mysql软件端的字符集

character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect = 'SET NAMES utf8mb4'

#MYSQL软件的存储引擎

default-storage_engine = INNODB

# server_id = .....


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are 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
#mysql软件的sql模式

sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS

#mysql软件的最大连接数

max_connections=100

#mysql软件的查询缓存

query_cache_size=0

#mysql软件的内存中可以存储临时表的最大值

tmp_table_size=9M

#mysql软件中可以保留的客户端连接线程

thread_cache_size=8

#mysql软件中重建索引时允许的最大临时文件的大小

myisam_max_sort_file_size=100G

#mysql软件中重建索引时允许的最大缓存的大小

myisam_sort_buffer_size=17M

#mysql软件中最大关键字缓存的大小

key_buffer_size=10M

#mysql软件全扫描MyISAM表时的缓存大小

read_buffer_size=64K

#mysql软件可以插入排序好数据的缓存大小

read_rnd_buffer_size=256K

#mysql软件用户排序时缓存大小

sort_buffer_size=256K

#INNODB存储引擎的参数设置

#附加内存池大小

innodb_additional_mem_pool_size=2M

#提交日志的时机

innodb_flush_log_at_trx_commit=1

#存储日志数据的缓存区的大小

innodb_log_buffer_size=1M

#缓存池中的缓存区的大小

innodb_buffer_pool_size=17M

#日志文件的大小

innodb_log_file_size=10M

#允许线程的最大数

innodb_thread_concurrency = 8