mysql.ini

[client]
socket				= /tmp/mysql.sock

[mysqld]
bind_address			= 127.0.0.1
socket				= /tmp/mysql.sock

query_cache_type		= 1
query_cache_size		= 128M #256M #09/12/2015
query_cache_min_res_unit	= 1k
query_cache_limit		= 32M

table_open_cache		= 64 #3000 #09/12/2015
table_definition_cache		= 256 #16384 #09/12/2015

wait_timeout			= 180 #300 #29/12/2015
interactive_timeout		= 180 #300 #29/12/2015

max_connections			= 450 #500 #09/12/2015
# Memopria usata = max_connections*(sort_buffer_size+join_buffer_size+read_buffer_size)

sort_buffer_size		= 1M #32K #09/12/2015
join_buffer_size		= 8M #12M #29/12/2015
read_buffer_size		= 8M #12M #29/12/2015

innodb_buffer_pool_size		= 1G #64M #09/12/2015
innodb_buffer_pool_instances	= 1 #09/12/2015
tmp_table_size			= 128M # 320M #09/12/2015
max_heap_table_size		= 128M # 320M #09/12/2015
key_buffer_size			= 1500M # 1200M #09/12/2015
open_files_limit		= 30000

slow_query_log			= 1	# 0 = disattiva 1 = attiva
long_query_time			= 1	# In secondi
#log_queries_not_using_indexes	= TRUE


explicit_defaults_for_timestamp

tmpdir				= /tmp

thread_cache_size		= 34

ft_min_word_len			= 3

datadir				= /home/mysql
default_storage_engine		= MYISAM

max_allowed_packet		= 128M #16M #05/10/2015
max_connect_errors		= 10

log-bin
expire_logs_days		= 5
innodb_data_file_path		= ibdata1:100M:autoextend
innodb_data_home_dir		= /home/mysql/
innodb_write_io_threads		= 8
innodb_read_io_threads		= 8
innodb_thread_concurrency	= 8
transaction_isolation		= REPEATABLE-READ

[mysqldump]
quick
max_allowed_packet		= 128M #16M 05/10/2015
socket				= /tmp/mysql.sock

[mysqlhotcopy]
interactive_timeout		= 8000
socket				= /tmp/mysql.sock

[mysql]
no_auto_rehash
socket				= /tmp/mysql.sock

[mysqld-safe]
socket				= /tmp/mysql.sock