mysql 5.6.10能用的参数(验证)(一)

2014-11-24 16:33:03 · 作者: · 浏览: 0
mysql 5.6.10能用的参数(验证)
my.ini文件
总起来有两处必须变动
取消table_cache及log-slow-queries=slow.log必须变更为slow-query-log-file=slow.log
[mysqld]
port = 3306 可用
basedir=D:/wamp/mysql 可用
datadir=D:/wamp/mysql/data/ 可用
tmpdir=D:/wamp/tmp/ 可用
character-set-server=utf8 改为character-set-server 好像没什么影响
table_cache=2048 取消了该处 ,如果加上就会无法启动
wait_timeout=30 可用
interactive_timeout=30可用
skip-name-resolve可用
bind-address=0.0.0.0可用
innodb_file_per_table=1可用
innodb_open_files=2048可用
back_log = 500可用
max_connections = 1000可用
max_connect_errors = 100可用
table_open_cache = 2048可用
max_allowed_packet = 32M可用
binlog_cache_size = 1M可用
max_heap_table_size = 256M可用
read_buffer_size = 16M可用
read_rnd_buffer_size = 16M可用
sort_buffer_size = 16M可用
join_buffer_size = 32M可用
thread_cache_size = 64可用
thread_concurrency =4可用
query_cache_size = 256M可用
query_cache_limit = 8M可用
ft_min_word_len = 4可用
#memlock
default-storage-engine = Innodb可用
thread_stack = 192K可用
transaction_isolation = REPEATABLE-READ可用
tmp_table_size = 256M可用
max_tmp_tables=512可用
# Enable binary logging. This is required for acting as a MASTER in a
# replication configuration. You also need the binary log if you need
# the ability to do point in time recovery from your latest backup.
#log-bin=mysql-bin
# binary logging format - mixed recommended
#binlog_format=mixed
# If you're using replication with chained slaves (A->B->C), you need to
# enable this option on server B. It enables logging of updates done by
# the slave thread into the slave's binary log.
#log_slave_updates
# Enable the full query log. Every query (even ones with incorrect
# syntax) that the server receives will be logged. This is useful for
# debugging, it is usually disabled in production use.
#log
# Print warnings to the error log file. If you have any problem with
# MySQL you should enable logging of warnings and examine the error log
# for possible explanations.
#log_warnings
# Log slow queries. Slow queries are queries which take more than the
# amount of time defined in "long_query_time" or which do not use
# indexes well, if log_short_format is not enabled. It is normally good idea
# to have this turned on if you frequently add new queries to the
# system.
slow-query-log=1可用
# All queries taking more than this amount of time (in seconds) will be
# trated as slow. Do not use "1" as a value here, as this will result in
# even very fast queries being logged from time to time (as MySQL
# currently measures time with second accuracy only).
long_query_time = 5可用
slow-query-log-file=slow.log 更改
#log-queries-not-using-indexes
# *** Replication related settings
# Unique server identification number between 1 and 2^32-1. This value
# is required for both master and slave hosts. It defaults to 1 if
# "master-host" is not set, but will MySQL will not function as a master
# if it is omitted.
server-id = 1可用
# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully