# /etc/mysql/conf.d/opti.cnf
#OPTIMIZE
key_buffer_size = 128M
skip-name-resolve=1
performance_schema = ON

innodb_log_file_size=256M
innodb_buffer_pool_size=2048M
innodb_buffer_pool_instances=2

max_connections  = 500
tmp_table_size=64M
max_heap_table_size=64M

query_cache_type = 1
query_cache_size = 64M
query_cache_limit=8M

wait_timeout=90
interactive_timeout=90