[mysql]
socket = /var/run/mysql/mysql.sock
[mysqld]
user = mysql
bind-address = 0.0.0.0
port = 3306
basedir = /usr/local/mysql
pid-file = /var/run/mysql/mysql.pid
socket = /var/run/mysql/mysql.sock
datadir = /var/data/mysql
tmpdir = /tmp
# Log Path
#lc-messages-dir = /var/log/mysql
#lc_messages = en_US
log-error = /var/log/mysql/error.log
explicit_defaults_for_timestamp
skip-name-resolve
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links = 0
max_allowed_packet = 16M
max_connect_errors = 1000000
thread_stack = 192K
thread_cache_size = 50
max_connections = 500
#max_heap_table_size = 2G
#tmp_table_size = 2G
table_open_cache = 16384
table_definition_cache = 16384
open_files_limit = 65536
#key_buffer_size = 512M
query_cache_type = 0
#default_storage_engine = TokuDB
#default_tmp_storage_engine = TokuDB
# Innodb Settings
innodb_buffer_pool_size = 12G
innodb_buffer_pool_instances = 8
innodb_buffer_pool_dump_at_shutdown = 1
innodb_buffer_pool_load_at_startup = 1
innodb_flush_method = O_DIRECT
innodb_log_files_in_group = 2
innodb_log_file_size = 4G
innodb_flush_log_at_trx_commit = 0
innodb_change_buffering = all
# innodb_additional_mem_pool_size = 32M
innodb_file_per_table = 1
innodb_read_io_threads = 16
innodb_write_io_threads = 16
innodb_io_capacity = 50000
#innodb_log_buffer_size = 16M
innodb_thread_concurrency = 0
#innodb_lock_wait_timeout = 120
innodb_open_files = 65536
innodb_autoinc_lock_mode = 1
#innodb_log_write_ahead_size = 4096
innodb_flush_neighbors = 0
#tokudb_loader_memory_size = 10G
#tokudb_directio = 1
#tokudb_cache_size = 25G
#tokudb_commit_sync = OFF
#tokudb_fsync_log_period = 1000
#tokudb_analyze_in_background = ON
#tokudb_analyze_mode = TOKUDB_ANALYZE_RECOUNT_ROWS
# BINARY LOGGING #
#log-bin = /var/data/mysql/mysql-bin
#sync-binlog = 1
#expire-logs-days = 14
# Slow Query Log
#slow_query_log_file = /var/log/mysql/slow-query.log
slow_query_log = 0
long_query_time = 3
沒有留言:
張貼留言