[client]
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[mysqld_safe]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[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          = /run/shm
lc-messages-dir = /usr/share/mysql
explicit_defaults_for_timestamp
slow_query_log = 0
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 10
log_queries_not_using_indexes = 1


#Mysql Master/Slave config
server-id       = 1
binlog-format   = mixed
log-bin         = mysql-bin
innodb_flush_log_at_trx_commit = 1
sync_binlog     = 1
expire_logs_days        = 5
#Slave on
read-only       = 1

#Custom
max_connections         = 3072
max_user_connections    = 3072
key_buffer_size         = 1024M
thread_cache_size       = 96
query_cache_type        = 0
query_cache_limit       = 2M
query_cache_size        = 192M
tmp_table_size          = 192M
max_heap_table_size     = 192M
sort_buffer_size        = 4M
read_rnd_buffer_size    = 2M
read_buffer_size        = 2M
join_buffer_size        = 32M
innodb_buffer_pool_size = 24576M
innodb_flush_method     = O_DIRECT
net_buffer_length       = 256K
thread_stack            = 256K
delayed_insert_timeout  = 8
connect_timeout         = 8
open_files_limit        = 20480
thread_concurrency      = 12


wait_timeout            = 720
interactive_timeout     = 720
innodb_log_buffer_size  = 128M
innodb_log_file_size    = 256M
innodb_lock_wait_timeout = 120

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address   = 127.0.0.1

log-error       = /var/log/mysql/error.log

# Recommended in standard MySQL setup
#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #configurazione di default di Marco

sql_mode=NO_ENGINE_SUBSTITUTION

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0