mysql优化配置
bind-address=172.27.136.21datadir=/data1/mysqldata/data
default-character-set=latin1
innodb_additional_mem_pool_size=20M
innodb_buffer_pool_size=3000M
innodb_data_file_path=ibdata1:10G;ibdata2:10G;ibdata3:10G;ibdata4:10G;ibdata5:10G;ibdata6:10G:autoextend
innodb_data_home_dir=/data1/mysqldata/innodb/data
innodb_file_io_threads=4
innodb_flush_log_at_trx_commit=0
innodb_lock_wait_timeout=50
innodb_log_buffer_size=32M
innodb_log_file_size=256M
innodb_log_files_in_group=4
innodb_log_group_home_dir=/data1/mysqldata/innodb/log
innodb_thread_concurrency=8
interactive_timeout=86400
key_buffer=64M
log_bin=/data/mysqllog/binlog/binlog.bin
log_slow_queries=/data/mysqllog/slow-query.log
long_query_time=1
max_allowed_packet=4M
max_binlog_size=20M
myisam_sort_buffer_size=64M
port=3306
query_cache_size=32M
read_buffer_size=2M
relay-log=/data1/mysqldata/relay-log/relay-log.bin
replicate-ignore-db=mysql
replicate-wild-ignore-table=mysql.%
server-id=1
skip-external-locking
skip-locking
socket=/data1/mysqldata/mysql.sock
sort_buffer_size=2M
table_cache=5120
thread_cache=8
thread_concurrency=8
wait_timeout=86400
页:
[1]