[mysqld]
# the following command enables performance capture metrics
performance_schema
 
# following field causes SHOW ENGINER INNODB STATUS to be written to innodb_status file
innodb-status-file=1
port=3306
#bind-address=10.1.1.181
#bind-address=0.0.0.0
datadir=/vol0/opt/mysql
socket=/var/lib/mysql/mysql.sock
#key_buffer_size=2048M
#tmp_table_size=1024M
#table_cache=1024
#innodb_data_file_path=ibdata1:1000M;ibdata2:100M:autoextend
innodb_data_file_path=ibdata1:200M;ibdata2:50M:autoextend
########### use 38G for bufferpool
innodb_buffer_pool_size=40802189312
innodb_additional_mem_pool_size=500M

# previous log file size of 20M
#innodb_log_file_size= 20971520
# new log file size of 500M
innodb_log_file_size=524288000

innodb_log_files_in_group=4

#increased log buffer size from 10,000,000 to 20M   
innodb_log_buffer_size=20971520

# consider changing the following to O_DIRECT
innodb_flush_method=O_DSYNC
#innodb_flush_method=O_DIRECT

innodb_flush_log_at_trx_commit=2
#innodb_flush_log_at_trx_commit=1

innodb_thread_concurrency=16
#default-character-set=utf8
#default-collation=utf8_general_ci
#default-character-set=utf8
#default-collation=utf8_general_ci
interactive_timeout=28800
net_write_timeout=60
wait_timeout=28800
connect_timeout=60
net_read_timeout=60

default-storage-engine=InnoDB
innodb_file_per_table=1

# enabled new INNODB plug in:
#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
#innodb_file_format=barracuda
#innodb_strict_mode=1
innodb_use_sys_malloc=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid