基于innodB 引擎优化的my.cnf
[client]
port=3306
socket=/data1/mysqldata/mysql.sock
[mysqld]
max_connections=300
tmpdir=/data1/mysqldata/tmp
lower_case_table_names=1
bind-address=10.20.164.36
datadir=/data1/mysqldata/data
character-set-server=utf8
innodb_additional_mem_pool_size=20M
innodb_buffer_pool_size=32G
innodb_file_per_table
innodb_data_file_path=ibdata1:10G:autoextend
innodb_data_home_dir=/data1/mysqldata/innodb/data
innodb_file_io_threads=4
innodb_flush_log_at_trx_commit=1
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=7231
skip-external-locking
#skip-locking
socket=/data1/mysqldata/mysql.sock
sort_buffer_size=2M
table_cache=2048
thread_cache=8
thread_concurrency=8
wait_timeout=86400
log_slave_updates = 1
[mysql]
default-character-set=utf8
no-auto-rehash
port=3306
socket=/data1/mysqldata/mysql.sock
[mysqldump]
max_allowed_packet=16M
本文出自 “漫漫长路” 博客，谢绝转载！
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
