Percona mysql配置文件

为什么80%的码农都做不了架构师？>>>   

最近在折腾Percona，顺便记录一下my.cnf的配置

[client]

port            = 3306
socket          = /wls/zabbix-mysql/my3306/run/mysql.3306.sock
loose-default-character-set = utf8

[mysqld]

port            = 3306
socket          = /wls/zabbix-mysql/my3306/run/mysql.3306.sock
server-id              = 146330617 
character-set-server   = utf8
default-storage-engine = InnoDB
userstat = 1
innodb_old_blocks_time = 1000
innodb_stats_on_metadata = off
log_slow_verbosity     = microtime,innodb
federated
skip-slave-start
skip-name-resolve
skip-external-locking
log-slave-updates
slave-skip-error        = 1062,1146
slave_net_timeout       = 60
back_log                = 500
max_allowed_packet      = 1073741824
#table_cache             = 8192
max_connections         = 6000
max_connect_errors      = 800
key_buffer              = 64M
sort_buffer_size        = 4M
read_buffer_size        = 2M
read_rnd_buffer_size    = 8M
join_buffer_size        = 2M
tmp_table_size          = 512M
max_heap_table_size     = 512M
binlog_cache_size       = 8M
myisam_sort_buffer_size = 64M
thread_cache_size       = 64
query_cache_type        = 0
slow_query_log          = 1
slow_query_log_file     = /wls/zabbix-mysql/my3306/log/mysql-slow.log
long_query_time         = 1
log-error               = /wls/zabbix-mysql/my3306/log/mysql-error.log
log-bin                 = /wls/zabbix-mysql/my3306/log/mysql-bin
relay_log               = mysql-relay-bin
binlog_format           = ROW
tmpdir                  = /wls/zabbix-mysql/my3306/tmp
thread_concurrency      = 16
secure_auth        = 1
local-infile       = 0
event_scheduler    = OFF
innodb_file_per_table    = 1
innodb_file_format       = barracuda
innodb_file_format_check = barracuda
innodb_open_files        = 4096
datadir                         = /wls/zabbix-mysql/my3306/data/
innodb_data_home_dir            = /wls/zabbix-mysql/my3306/data/
innodb_data_file_path           = ibdata1:1000M;ibdata2:1000M;ibdata3:1000M;ibdata4:100M:autoextend
innodb_log_group_home_dir       = /wls/zabbix-mysql/my3306/data/
innodb_table_locks              = 0
innodb_buffer_pool_size         = 2G
innodb_additional_mem_pool_size = 4M
innodb_log_file_size            = 128M
innodb_log_files_in_group       = 2
innodb_log_buffer_size          = 16M
innodb_flush_method             = O_DIRECT
innodb_flush_log_at_trx_commit  = 0
innodb_max_dirty_pages_pct      = 60      
innodb_write_io_threads         = 16        
innodb_read_io_threads          = 8          
innodb_adaptive_flushing        = 0        
innodb_io_capacity              = 200          
innodb_flush_neighbors          = 0
innodb_thread_concurrency       = 0        

[mysqldump]

quick
max_allowed_packet = 16M

[mysql]

no-auto-rehash

[isamchk]

key_buffer       = 256M
sort_buffer_size = 256M
read_buffer      = 2M
write_buffer     = 2M

[myisamchk]

key_buffer       = 256M
sort_buffer_size = 256M
read_buffer      = 2M
write_buffer     = 2M

[mysqlhotcopy]

interactive-timeout

转载于:https://my.oschina.net/guol/blog/413590