[mysqld]
port = 3306

### Paths
datadir = /var/lib/mysql
innodb_data_home_dir = /var/lib/mysql
innodb_log_group_home_dir = /var/lib/mysql
aria_log_dir_path = /var/lib/mysql
innodb_data_file_path = ibdata1:12M:autoextend
innodb_temp_data_file_path = ibtmp1:12M:autoextend

### General options
character_set_server = utf8mb4
collation_server = utf8mb4_unicode_ci
default_storage_engine = InnoDB
#enforce_storage_engine = InnoDB
innodb_autoinc_lock_mode = 1
innodb_defragment = ON
innodb_compression_algorithm = zlib
#innodb_compression_algorithm = lz4
innodb_compression_default = ON
innodb_file_per_table = ON
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_max_dirty_pages_pct = 5
innodb_buffer_pool_load_at_startup = ON
innodb_buffer_pool_dump_at_shutdown = ON
performance_schema = OFF
symbolic_links = OFF
transaction_isolation = READ-COMMITTED

### Connections
bind_address = 0.0.0.0
back_log = 2048
max_allowed_packet = 32M
max_connect_errors = 10240
max_connections = 1024
max_user_connections = 128
secure_auth = ON
skip_name_resolve = ON

### Threads
innodb_thread_concurrency = 16
thread_cache_size = 64
thread_handling = pool-of-threads
thread_pool_size = 8

### Timeout
wait_timeout = 3600
interactive_timeout = 3600

### Logs
innodb_log_file_size = 128M
innodb_log_checksums = ON
innodb_log_compressed_pages = ON
innodb_log_buffer_size = 16M
log_error = /var/log/mysql/mysql_error.log
log_warnings = 2
long_query_time = 0.500000
slow_query_log_file = /var/log/mysql/mysql_slow.log
slow_query_log = ON

### Binlogs
binlog_format = ROW
expire_logs_days = 7
log_bin = /var/lib/mysql/mysql_bin.log
log_bin_index = /var/lib/mysql/mysql_bin.index
relay_log = /var/lib/mysql/mysql_relay_bin.log
binlog_cache_size = 2M
max_binlog_size = 256M
max_binlog_cache_size = 4G
sync_binlog = 0

### Buffers
aria_sort_buffer_size = 2M
innodb_sort_buffer_size = 2M
myisam_sort_buffer_size = 2M
sort_buffer_size = 2M
join_buffer_size = 256K
key_buffer_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
innodb_buffer_pool_size = 256M

### Caches
query_cache_type = ON
query_cache_limit = 2M
query_cache_size = 32M
key_cache_division_limit = 70
table_definition_cache = 4096
table_open_cache = 2048
max_heap_table_size = 1024M
tmp_table_size = 1024M

### RocksDB
#plugin-load-add = ha_rocksdb.so
#rocksdb_datadir = /var/lib//mysql/_rocksdb

### TokuDB
#plugin-load-add = ha_tokudb.so
#tokudb_dir_per_db = ON
#tokudb_data_dir = /var/lib//mysql/_tokudb
#tokudb_log_dir = /var/lib//mysql

### HandlerSocket
#plugin_maturity = beta
#plugin-load-add = handlersocket.so
#handlersocket_address = 0.0.0.0
#handlersocket_port = 9998
#handlersocket_port_wr = 9999
#handlersocket_threads = 16
#handlersocket_threads_wr = 1
#open_files_limit = 65535

[client]
default_character_set = utf8mb4

[mysql]
default_character_set = utf8mb4

[mysqld_safe]
default_character_set = utf8mb4
collation_server = utf8mb4_unicode_ci
log_error = /var/log/mysql/mysql_error.log

### TokuDB
#malloc-lib=/usr/lib64/libjemalloc.so.1

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer_size = 256M
myisam_sort_buffer_size = 256M
read_buffer_size = 2M