[mysqld]
user 		= mysql
port		= 3306
socket		= /var/run/mysqld/mysqld.sock
basedir		= /usr/local/mysql
datadir		= /data/mysql
core-file

skip_external_locking
thread_cache_size = 2
thread_concurrency = 8
thread_handling = one-thread-per-connection
log-slow-admin-statements
slow-query-log
log-slow-slave-statements
log-warnings = 2
log-error
timed_mutexes

long_query_time = 60
transaction-isolation = READ-COMMITTED

table_open_cache = 524288
table_definition_cache = 524288
query_cache_size = 128M
max_allowed_packet = 100M
sort_buffer_size = 16M
read_buffer_size = 64M
read_rnd_buffer_size = 8M
join_buffer_size = 16M
bulk_insert_buffer_size = 64M
max_heap_table_size = 1G

key_buffer_size = 24G
myisam_sort_buffer_size = 1G
myisam_use_mmap

innodb_flush_log_at_trx_commit = 2
innodb_file_per_table
innodb_io_capacity = 1000
innodb_flush_method = O_DSYNC
innodb_log_buffer_size = 512M
innodb_read_io_threads = 3
innodb_write_io_threads = 3
innodb-status-file
innodb_buffer_pool_size = 10G
innodb_additional_mem_pool_size = 1G
innodb_log_file_size = 512M

performance_schema
performance_schema_events_waits_history_long_size = 10000

server-id	= 1