[mysqld]

ignore_builtin_innodb
plugin-load=innodb=ha_innodb_plugin.so;innodb_trx=ha_innodb_plugin.so;innodb_locks=ha_innodb_plugin.so;innodb_lock_waits=ha_innodb_plugin.so;innodb_cmp=ha_innodb_plugin.so;innodb_cmp_reset=ha_innodb_plugin.so;innodb_cmpmem=ha_innodb_plugin.so;innodb_cmpmem_reset=ha_innodb_plugin.so

datadir = /data/mysql
character-set-server = utf8
socket = /var/run/mysqld/mysqld.sock

max_connect_errors = 100000

log-queries-not-using-indexes

log-bin = mysql-bin
server-id = 10

max_allowed_packet = 100M

key_buffer_size = 16G
myisam_block_size = 4K

open_files_limit = 4K
thread_cache = 100
table_open_cache = 2K
table_definition_cache = 2K

sort_buffer_size = 100K
thread_stack = 256K

query_cache_size = 8G

innodb_open_files = 1K
innodb_buffer_pool_size = 16G
innodb_log_buffer_size = 8M
innodb_log_file_size = 512M
innodb_thread_concurrency = 8
innodb_adaptive_hash_index = off

transaction-isolation = READ-COMMITTED

innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 2
sync_binlog = 1
binlog_format = row
expire_logs_days = 10

innodb_file_per_table

net_read_timeout                = 5
net_write_timeout               = 5

skip_name_resolve

max_heap_table_size = 512M
tmp_table_size = 512M