[mysqld]
innodb_buffer_pool_size      = 3276M
innodb_random_read_ahead     = ON
innodb_flush_method          = O_DIRECT
innodb_log_file_size         = 512M
innodb_buffer_pool_instances = 4

# Enable the slow query log to see queries with especially long duration
#slow_query_log[={0|1}]
#slow_query_log_file     = /var/log/mysql/mariadb-slow.log
#log_slow_rate_limit     = 1000
#log_slow_verbosity      = query_plan

max_connections         = 180
#key_buffer_size         = 2048M
key_buffer_size = 256M
table_open_cache        = 8192
read_buffer_size        = 768K
sort_buffer_size        = 1532K
join_buffer_size        = 1532K
query_cache_limit       = 2048K
query_cache_size        = 64M
tmp_table_size          = 256M
max_heap_table_size     = 256M

performance_schema      = ON

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION