[mysqld]
# Set up UTF8 as the default encoding
default_character_set=utf8
default_collation=utf8_bin
port=6033

#mysql installation directory
basedir=/opt/third-party/mysql/product/current

# Data directory
datadir=/opt/third-party/mysql/product/current/data
socket=/opt/third-party/mysql/product/current/tmp/mysql.sock
tmpdir=/opt/third-party/mysql/product/current/tmp

# Mysqld PID file location
pid-file=/opt/third-party/mysql/product/current/tmp/mysqld.pid

# Default user to run mysqld
user=laxino

#define default storage-engine
default-storage-engine=innodb
default-table-type=innodb

#always use transational mode
init_connect='SET autocommit=1'

#select geneal query log and slow query log output method
log_output=FILE

#enable general log
general-log=0
general_log_file=/opt/third-party/mysql/product/current/log/genlog/genlog.log

#enable error log
log-error=/opt/third-party/mysql/product/current/log/errlog/errlog.err

#when the query more than 10 minutes, it will log into the slow log
#long_query_time=600
#enable slow query log
#log_slow_queries=/opt/third-party/mysql/product/current/log/slowlog/slowlog.log
slow_query_log=1
slow_query_log_file=/opt/third-party/mysql/product/current/log/slowlog/slowlog.log
long_query_time=1

#enable binary log
log-bin-index=/opt/third-party/mysql/product/current/log/binarylog/binlog-idx
log-bin=/opt/third-party/mysql/product/current/log/binarylog/binlog
max_binlog_size=20M
#max_binlog_cache_size=
binlog_cache_size=2097152
binlog-format= STATEMENT


#skip-locking
max_connections=1000
#record_buffer=1M
#sort_buffer=1M

#Thread Cache
thread_cache_size=256

#Table Cache
table_open_cache=1024

#Query Cache
query_cache_type = 1
query_cache_size = 50M
query_cache_limit = 80M

max_allowed_packet = 10485760
connect_timeout =  180

#innodb DB settings
##innodb data path
innodb_data_home_dir=/opt/third-party/mysql/product/current/data
#innodb_data_file_path=ibdata0001:500M;ibdata0002:500M;ibdata0003:500M:autoextend:max:4096M
#innodb_data_file_path=ibdata0001:500M;ibdata0002:500M;ibdata0003:1060M;ibdata0004:10240M;ibdata0005:10240M;ibdata0006:10240M;ibdata0007:10240M;ibdata0008:10240M;ibdata0009:10240M;ibdata0010:10240M;ibdata0011:10240M;ibdata0012:10240M;ibdata0013:10240M;ibdata0014:10240M;ibdata0015:10240M;ibdata0016:10240M;ibdata0017:10240M;ibdata0018:10240M;ibdata0019:10240M;ibdata0020:10240M;ibdata0021:10240M;ibdata0022:10240M;ibdata0023:10240M;ibdata0024:10240M;ibdata0025:10240M;ibdata0026:10240M;ibdata0027:10240M;ibdata0028:10240M:autoextend
innodb_data_file_path=ibdata0001:500M;ibdata0002:500M;ibdata0003:1060M;ibdata0004:10240M;ibdata0005:10240M;ibdata0006:10240M;ibdata0007:10240M;ibdata0008:10240M;ibdata0009:10240M;ibdata0010:10240M;ibdata0011:10240M;ibdata0012:10240M;ibdata0013:10240M;ibdata0014:10240M;ibdata0015:10240M;ibdata0016:10240M;ibdata0017:10240M;ibdata0018:10240M;ibdata0019:10240M;ibdata0020:10240M;ibdata0021:10240M;ibdata0022:10240M;ibdata0023:10240M;ibdata0024:10240M;ibdata0025:10240M;ibdata0026:10240M;ibdata0027:10240M;ibdata0028:10240M;ibdata0029:10240M;ibdata0030:10240M;ibdata0031:10240M;ibdata0032:10240M;ibdata0033:10240M;ibdata0034:10240M;ibdata0035:10240M;ibdata0036:10240M;ibdata0037:10240M;ibdata0038:10240M;ibdata0039:10240M;ibdata0040:10240M
#innodb_data_file_path=ibdata0001:500M;ibdata0002:500M;ibdata0003:500M:autoextend:max:1900M
#innodb_autoextend_increment=10M


##innodb log settings
innodb_log_group_home_dir=/opt/third-party/mysql/product/current/log/innodblog
#innodb_log_arch_dir=/opt/third-party/mysql/product/current/log/innodblog

##Set buffer pool size to 50-80% of your computer's memory
#innodb_buffer_pool_size=512M
innodb_buffer_pool_size=1024M
innodb_additional_mem_pool_size=20M

##Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=100M
innodb_log_files_in_group=3
innodb_log_buffer_size=20M

#innodb_flush_log_at_trx_commit=1
innodb_flush_log_at_trx_commit=2


#By default (normal startup without forced recovery)
innodb_force_recovery=0

log_warnings = 2

[client]
# Set up UTF8 as the default encoding
default-character-set=utf8
socket=/opt/third-party/mysql/product/current/tmp/mysql.sock

[mysqld_safe]
user=laxino
pid-file=/opt/third-party/mysql/product/current/tmp/mysqld.pid

[xtrabackup]
target_dir = /mnt/db-backups