# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[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
#
# 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

######charset#######
character_set_server = utf8
init_connect='SET NAMES utf8'
lower_case_table_names = 1
sql_mode=NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
explicit_defaults_for_timestamp=false

###########FULLTEXT##########
ngram_token_size=2
ft_min_word_len =5
innodb_ft_min_token_size=5

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
#datadir=/newdisk/mysql
#socket=/newdisk/mysql/mysql.sock

secure-file-priv=""

skip-name-resolve
max_allowed_packet=64M
port=3308
#base_setting
transaction_isolation=READ-COMMITTED
skip_name_resolve
skip_host_cache

#query_cache_limit=0
#query_cache_size=0

# connection #
interactive_timeout = 1800
wait_timeout = 1800
lock_wait_timeout = 1800
skip_name_resolve = 1
max_connections = 512
max_connect_errors = 1000000


#tpcc_test_begin
#innodb_fast_shutdown=0
#innodb_force_recovery = 4
max_connections=3000
#tpch data size 10GB
innodb_buffer_pool_size=32GB
innodb_flush_log_at_trx_commit = 1
sync_binlog=1
innodb_support_xa=1
#tpcc_test_end

#session
read_buffer_size=16M
read_rnd_buffer_size=32M
sort_buffer_size=32M
tmp_table_size=64M
join_buffer_size=128M
thread_cache_size=64

#innodb_setting
innodb_io_capacity=1000
innodb_io_capacity_max=2000
innodb_lru_scan_depth=124
innodb_flush_method=O_DIRECT
innodb_undo_logs=128
innodb_log_file_size=500M
innodb_log_buffer_size=100M
innodb_sort_buffer_size=32M
innodb_write_io_threads=16
innodb_read_io_threads=16
innodb_page_cleaners=8

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid