[mysqld]
datadir=/opt/data
socket=/opt/data/mysql.sock
port=3306
log-bin=/opt/binlogs/bin.log

user=mysql
default-storage-engine=InnoDB
old_passwords=2
lower_case_table_names=1
binlog_format=row
expire_logs_days=3

relay-log=mysqld-relay-bin
relay-log-index=mysqld-relay-bin
skip-name-resolve

server_id=1
tmpdir=/opt/binlogs/tmp
innodb_file_per_table
event_scheduler=ON
local_infile=ON
performance_schema=ON
transaction_isolation=READ-COMMITTED

sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

#long_query_time=2
#slow-query-log=1
ssl-ca=/etc/mysql/ca-crt.pem
ssl-cert=/etc/mysql/server-crt.pem
ssl-key=/etc/mysql/server-key.pem
max_connections=100
back_log = 50

table_open_cache = 8192

show_compatibility_56=ON

max_allowed_packet = 1G
binlog_cache_size = 100M
max_heap_table_size = 512M
sort_buffer_size = 32M
join_buffer_size = 32M
query_cache_type=0
query_cache_size = 0
query_cache_limit = 4M

tmp_table_size = 512M

# Set it up according to the environment performance
innodb_buffer_pool_size=14G

innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 64M
innodb_log_file_size=1GB
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 300
innodb_monitor_enable = all
innodb_log_compressed_pages=on
innodb_flush_method=O_DIRECT
innodb_buffer_pool_instances=4
innodb_write_io_threads=8
innodb_stats_on_metadata=0
innodb_page_cleaners=4

binlog_stmt_cache_size = 100M
innodb_sort_buffer_size=32M
log-output=FILE

innodb_change_buffer_max_size=50
innodb_concurrency_tickets=5000000

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

[client]
socket=/opt/data/mysql.sock
ssl-ca=/etc/mysql/ca-crt.pem
ssl-cert=/etc/mysql/server-crt.pem
ssl-key=/etc/mysql/server-key.pem