[mysql]
port                            = 3306
socket                          = /var/lib/mysql/mysql.sock

[mysqld]
disable-log-bin=1
default-authentication-plugin=mysql_native_password
# Required Settings
basedir                         = /usr/
bind_address                    = *
datadir                         = /var/lib/mysql/
max_allowed_packet              = 1G
max_connect_errors              = 1000000
port                            = 3306
skip_external_locking
socket                          = /var/lib/mysql/mysql.sock
tmpdir                          = /tmp
user                            = mysql
performance_schema              = 0
sql_mode                        = ""

wait_timeout = 60
interactive_timeout = 60

# InnoDB Settings
default_storage_engine          = InnoDB
innodb_buffer_pool_instances    = 8
innodb_buffer_pool_size         = 8G
innodb_file_per_table           = 1
innodb_flush_method             = O_DIRECT
innodb_log_buffer_size          = 16M
innodb_log_files_in_group       = 2
innodb_stats_on_metadata        = 0
innodb_log_file_size            = 2G

#innodb_thread_concurrency      = 15
innodb_read_io_threads          = 4
innodb_write_io_threads         = 4

# MyISAM Settings
# query_cache_limit               = 4M
# query_cache_size                = 128M
# query_cache_type                = 1


low_priority_updates            = 1
concurrent_insert               = 2

# Connection Settings
max_connections                 = 500

# Buffer Settings
join_buffer_size                = 64M
read_buffer_size                = 32M
read_rnd_buffer_size            = 64M
sort_buffer_size                = 64M
open_files_limit=40000

# Search Settings
ft_min_word_len                 = 4

# Logging
log_error                       = /var/lib/mysql/mysql_error.log
long_query_time                 = 3
slow_query_log                  = 1
slow_query_log_file             = /var/lib/mysql/mysql_slow.log
mysqlx=0