MySQL5.6配置文件
[client] port = 30010 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock nice = 0 [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 30010 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp lc-messages-dir = /usr/share/mysql skip-external-locking skip-name-resolve character-set-server=utf8 innodb_flush_log_at_trx_commit=1 sync_binlog=1 event_scheduler=ON lower_case_table_names=1 innodb_file_format=Barracuda innodb_file_format_check = ON innodb_file_per_table=1 auto-increment-increment = 2 auto-increment-offset = 2 max_connections=5000 max_connect_errors=300 wait_timeout = 172800 innodb_log_file_size=1024M bind-address = 0.0.0.0 key_buffer = 16M max_allowed_packet = 160M thread_stack = 192K thread_cache_size = 8 myisam-recover = BACKUP query_cache_limit = 1M query_cache_size = 16M log_error = /var/log/mysql/error.log server-id = 10710 binlog_format=ROW log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 1000M replicate-wild-ignore-table = information_schema.% replicate-wild-ignore-table = mysql.% replicate-wild-ignore-table = performance_schema.% log_bin_trust_function_creators=1 [mysqldump] quick quote-names max_allowed_packet = 160M [mysql] [isamchk] key_buffer = 16M !includedir /etc/mysql/conf.d/