基于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





















本文出自 “漫漫长路” 博客,谢绝转载!

基于innodB 引擎优化的my.cnf,古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。