[client]
port = 3306
default-character-set = utf8
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/smart.sock
user = mysql
server-id=171
#####################Standard Configuration########################
#Hugepage
#large-pages
skip-name-resolve
external-locking = FALSE
pid-file = /database/smart/data/smart.pid
datadir = /database/smart/data/
log-bin=/database/smart/binlog/smart_bin
#delete binlog before 30 day
expire_logs_days =30
max_binlog_cache_size = 256M
max_binlog_size = 1G
binlog_cache_size = 64M
relay-log-index = /database/smart/relaylog/smart-relay-bin.index
relay-log-info-file = /database/smart/relaylog/smart-relay-bin
relay-log = /database/smart/relaylog/smart-relay-log.info
innodb_log_file_size = 200M
innodb_log_files_in_group=3
innodb_log_buffer_size = 128M
#tablespace
innodb_file_per_table
# first write log buffer ,secend write log file
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout =50
innodb_thread_concurrency=8
innodb_read_io_threads=30
innodb_write_io_threads=30
#event
event_scheduler = 1
#no lower and no upper
lower_case_table_names=1
#group_concat
group_concat_max_len=1M
# binary logging format - mixed recommended
binlog_format=mixed
init_connect='SET AUTOCOMMIT=0'
connect_timeout=600
wait_timeout=120
interactive_timeout=120
ft_min_word_len=1
default-storage-engine=INNODB
max_connections = 10000
max_connect_errors = 50000
max_user_connections=5000
max_allowed_packet=1024M
init-connect="SET NAMES utf8"
character-set-server =utf8
# apply to application
auto_increment_offset=1
auto_increment_increment=2
#slow_log
#must be restart
#log_slow_queries=1
log_output=table
long_query_time = 5
slow_query_log=1
#general_log_file=on
#log-queries-not-using-indexes
#####################Others Configuration########################
net_buffer_length = 8K
read_rnd_buffer_size = 8M
# cache
back_log = 512
key_buffer_size =256M
thread_stack = 256K
table_cache = 1024
sort_buffer_size = 128M
read_buffer_size = 4M
join_buffer_size = 8M
#record_buffer = 32M
myisam_sort_buffer_size = 128M
thread_cache = 32
thread_cache_size = 128
query_cache_size =256M
query_cache_type = 1
tmp_table_size = 20M
max_heap_table_size = 64M
thread_concurrency = 8
innodb_buffer_pool_size=2000M
binlog-do-db=smart
binlog-ignore-db=mysql
replicate-do-db=smart
replicate-ignore-db=mysql
replicate-do-db=test
binlog-do-db=test
log-slave-updates
slave-skip-errors=all
[mysqldump]
quick
max_allowed_packet = 512M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
port = 3306
default-character-set = utf8
# The MySQL server
[mysqld]
port = 3306
socket = /tmp/smart.sock
user = mysql
server-id=171
#####################Standard Configuration########################
#Hugepage
#large-pages
skip-name-resolve
external-locking = FALSE
pid-file = /database/smart/data/smart.pid
datadir = /database/smart/data/
log-bin=/database/smart/binlog/smart_bin
#delete binlog before 30 day
expire_logs_days =30
max_binlog_cache_size = 256M
max_binlog_size = 1G
binlog_cache_size = 64M
relay-log-index = /database/smart/relaylog/smart-relay-bin.index
relay-log-info-file = /database/smart/relaylog/smart-relay-bin
relay-log = /database/smart/relaylog/smart-relay-log.info
innodb_log_file_size = 200M
innodb_log_files_in_group=3
innodb_log_buffer_size = 128M
#tablespace
innodb_file_per_table
# first write log buffer ,secend write log file
innodb_flush_log_at_trx_commit = 2
innodb_lock_wait_timeout =50
innodb_thread_concurrency=8
innodb_read_io_threads=30
innodb_write_io_threads=30
#event
event_scheduler = 1
#no lower and no upper
lower_case_table_names=1
#group_concat
group_concat_max_len=1M
# binary logging format - mixed recommended
binlog_format=mixed
init_connect='SET AUTOCOMMIT=0'
connect_timeout=600
wait_timeout=120
interactive_timeout=120
ft_min_word_len=1
default-storage-engine=INNODB
max_connections = 10000
max_connect_errors = 50000
max_user_connections=5000
max_allowed_packet=1024M
init-connect="SET NAMES utf8"
character-set-server =utf8
# apply to application
auto_increment_offset=1
auto_increment_increment=2
#slow_log
#must be restart
#log_slow_queries=1
log_output=table
long_query_time = 5
slow_query_log=1
#general_log_file=on
#log-queries-not-using-indexes
#####################Others Configuration########################
net_buffer_length = 8K
read_rnd_buffer_size = 8M
# cache
back_log = 512
key_buffer_size =256M
thread_stack = 256K
table_cache = 1024
sort_buffer_size = 128M
read_buffer_size = 4M
join_buffer_size = 8M
#record_buffer = 32M
myisam_sort_buffer_size = 128M
thread_cache = 32
thread_cache_size = 128
query_cache_size =256M
query_cache_type = 1
tmp_table_size = 20M
max_heap_table_size = 64M
thread_concurrency = 8
innodb_buffer_pool_size=2000M
binlog-do-db=smart
binlog-ignore-db=mysql
replicate-do-db=smart
replicate-ignore-db=mysql
replicate-do-db=test
binlog-do-db=test
log-slave-updates
slave-skip-errors=all
[mysqldump]
quick
max_allowed_packet = 512M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M