[mysqld]
datadir=/home/mysql/data
user=mysql
old_passwords=1
socket=/var/lib/mysql/mysql.sock
innodb_data_home_dir=/home/mysql/innodb_data
innodb_data_file_path = ibdata1:2000M:autoextend
innodb_log_group_home_dir=/home/mysql/logs
innodb_additional_mem_pool_size=32M
#innodb_flush_log_at_trx_commit=120000
innodb_flush_log_at_trx_commit=0
max_connections=256
table_cache=4096
thread_cache=16
thread_cache_size=16
innodb_file_per_table = true

log-slow-queries=/tmp/mysql-slow.log
log-long-format
long_query_time = 6

# Set the Innodb buffer pool size to n GB
# = this value is in bytes (80% of total memory)
innodb-buffer-pool-size = 16G
# Turn off the check-sum of pages read from disk
innodb-checksums = false
# Let any number of threads commit concurrently
#innodb-commit-concurrency = 0
innodb-commit-concurrency = 8
# Turn off the double write function
innodb-doublewrite = false
# Use direct io
innodb-flush-method = O_DIRECT
#innodb-flush-method = O_DSYNC - TBT
# Use a large buffer for the transaction log (you may want to go over 8M, and go even larger)
innodb-log-buffer-size = 16M
#innodb-log-buffer-size = 1G
#innodb-log-buffer-size = 64M
# Set the log file size to one half the buffer pool above
innodb-log-file-size = 1G
#innodb_log_buffer_size = 8M -TBT alap
#innodb_log_file_size = 128M - TBT alap

#key_buffer = 1000M

# Turn off XA support as its not needed in this test
innodb-support-xa = false
# Set the number of concurrent threads to unlimited
innodb-thread-concurrency = 8
# Turn on large page memory support
large-pages = true
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid