[client-server]
!includedir /etc/my.cnf.d

[mysqld]
log-error = /var/lib/mysql/amsterdam-01.letscp.com.err
performance-schema = 0
innodb_buffer_pool_size = 20G
#innodb_buffer_pool_size = 134217728
max_allowed_packet = 268435456
open_files_limit=54000
innodb_file_per_table = 1
plugin-load-add = auth_socket.so
unix_socket = OFF

innodb_file_per_table = 1
max_connections = 3500
max_user_connections = 150
innodb_log_file_size = 1280M
sql_mode =
innodb_buffer_pool_instances = 20     # Use 1 instance per 1GB of InnoDB pool size
innodb_stats_on_metadata = 0
table_definition_cache = 12000
query_cache_size = 16M
query_cache_type = 1
query_cache_limit = 16M
max_heap_table_size = 24M
join_buffer_size = 8M
table_open_cache = 1800
thread_cache_size = 256
key_buffer_size = 36M   # UPD
low_priority_updates = 1
concurrent_insert = 2
back_log = 512
thread_stack = 384K
interactive_timeout = 60
wait_timeout = 60