mysql配置文件my.cnf

533442

[client]
port = 3306
socket = /usr/local/mysql/mysql.sock
default-character-set = utf8
[mysql]
no-auto-rehash
default-character-set = utf8
[mysqld]
socket = /usr/local/mysql/mysql.sock
character-set-server = utf8
basedir = /usr/local/mysql
max_allowed_packet = 32M
datadir = /data/mysql
explicit_defaults_for_timestamp = true
skip-ssl
#secure-file-priv = /home/book/shell/mytools/practice
lower_case_table_names = 1
back_log = 300
max_connections = 3000
max_connect_errors = 100
table_open_cache = 4096
external-locking = FALSE
max_allowed_packet = 32M
sort_buffer_size = 16M
join_buffer_size = 16M
thread_cache_size = 16
query_cache_size = 128M
ft_min_word_len = 8
thread_stack = 512K
transaction_isolation = REPEATABLE-READ
tmp_table_size = 128M
max_heap_table_size = 128M
#binlog
log-bin = mysql-bin
binlog_format = mixed
server-id = 1
read-only = 0
#binlog-do-db = hello
binlog-ignore-db = mysql
binlog-ignore-db = information_schema
binlog-ignore-db = performance_schema
auto-increment-increment = 10
auto-increment-offset = 1
#####slow query parameters#######
long_query_time = 6
slow_query_log
slow_query_log_file = /data/log/mysql/slow.log
[mysqldump]
quick
max_allowed_packet = 32M
[mysqld_safe]
open-files-limit = 8192
log-error=/data/log/mysql/mysql_3306.err

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES