[mysqld]

######################################################
######		General settings		###### 
######################################################

tmpdir			= /var/lib/tmpfs
#max_allowed_packet      = 64M
log_slow_queries        = /var/log/mysql/mysql-slow.log
long_query_time 	= 1

innodb_file_per_table
skip-name-resolve
bind-address=0.0.0.0


######################################################
###### 			Performance 		######
######################################################
thread_stack            = 256K
thread_cache_size       = 2048
thread_concurrency     	= 8

max_connections       	= 400 
open-files-limit        = 65535
table_open_cache     	= 32768
query_cache_limit       = 1M
query_cache_size        = 256M

key_buffer_size		= 64M
innodb_buffer_pool_size	= 12G
innodb-use-sys-malloc	= 0

#delay_key_write         = ALL
#innodb_doublewrite      = OFF

long_query_time         = 10
log-slow-queries        = /var/log/mysql/mysql-slow.log

ssl-ca                  = /etc/mysql/ssl/ca-cert.pem
ssl-cert                = /etc/mysql/ssl/server-cert.pem
ssl-key                 = /etc/mysql/ssl/server-key.pem