[client]
port                    = 3306
socket                  = /var/run/mysqld/mysqld.sock
default-character-set   = utf8

[mysqld]
user                    = mysql
pid-file                = /var/run/mysqld/mysqld.pid
socket                  = /var/run/mysqld/mysqld.sock
port                    = 3306
basedir                 = /usr
datadir                 = /var/lib/mysql
#tmpdir                  = /tmp
tmpdir                  = /run/shm/mysql
default_storage_engine  = InnoDB
lc_messages_dir         = /usr/share/mysql
lc_messages             = en_US
character_set_server    = utf8
collation_server        = utf8_general_ci
skip-external-locking
skip-name-resolve
connect_timeout         = 60
#join_buffer_size        = 1M
#join_buffer_size        = 128M
join_buffer_size        = 256M
key_buffer              = 2M
#key_buffer_size         = 509M
key_buffer_size         = 256M
log_warnings            = 2
max_allowed_packet      = 32M
max_connect_errors      = 30
#max_connections         = 75
#max_user_connections    = 75
max_connections         = 40
max_user_connections    = 40
myisam_sort_buffer_size = 1024K
#query_cache_limit       = 128K
query_cache_limit       = 2M
#query_cache_size        = 64M
query_cache_size        = 768M 
#query_cache_size        = 1024M 
query_cache_min_res_unit = 1K
query_cache_type        = 1
read_buffer_size        = 8M
read_rnd_buffer_size    = 4M
#sort_buffer_size        = 128K
sort_buffer_size        = 512K
#bulk_insert_buffer_size = 128K
bulk_insert_buffer_size = 256K
#table_open_cache        = 64
table_open_cache        = 6144
#table_definition_cache  = 512
table_definition_cache  = 6144
#table_cache             = 128
table_cache             = 20480
thread_stack            = 256K
thread_cache_size       = 128
thread_concurrency      = 8
wait_timeout            = 3600
#wait_timeout            = 120
#tmp_table_size          = 64M
tmp_table_size          = 2048M
#max_heap_table_size     = 128M
max_heap_table_size     = 4096M
low_priority_updates    = 1
concurrent_insert       = 2
#max_tmp_tables          = 16384
max_tmp_tables          = 32768
server-id               = 8
myisam-recover          = BACKUP
#log_bin                 = /var/log/mysql/mariadb-bin
#log_bin_index           = /var/log/mysql/mariadb-bin.index
#expire_logs_days        = 1
#max_binlog_size         = 100M
open_files_limit        = 196608
slow_query_log          = 1
long_query_time         = 5
slow_query_log_file     = /var/log/mysql/sql-slow-query.log
#log_queries_not_using_indexes
log_queries_not_using_indexes


# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
sql_mode                = NO_ENGINE_SUBSTITUTION
# you can't just change log file size, requires special procedure
#innodb_log_file_size   = 50M
#innodb_buffer_pool_size = 509M
innodb_buffer_pool_size = 1536M
innodb_log_buffer_size  = 4M
innodb_file_per_table   = 1
innodb_open_files       = 256
innodb_io_capacity      = 512
innodb_flush_method     = O_DIRECT
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency = 8
#innodb_lazy_drop_table  = 1
innodb_lock_wait_timeout = 120


[mysqld_safe]
socket                  = /var/run/mysqld/mysqld.sock
nice                    = 0
open_files_limit        = 196608
syslog

[mysqldump]
quick
max_allowed_packet      = 32M
quote-names

[mysql]
no-auto-rehash

[myisamchk]
key_buffer              = 1M
sort_buffer_size        = 64K
read_buffer             = 4M
write_buffer            = 4M

[isamchk]
key_buffer              = 1M
sort_buffer_size        = 64K
read_buffer             = 4M
write_buffer            = 4M

[mysqlhotcopy]
interactive-timeout

!includedir /etc/mysql/conf.d/