Percona mysql配置文件
博客专区 > China_OS 的博客 > 博客详情
Percona mysql配置文件
China_OS 发表于3年前
Percona mysql配置文件
  • 发表于 3年前
  • 阅读 62
  • 收藏 1
  • 点赞 0
  • 评论 0

腾讯云 技术升级10大核心产品年终让利>>>   

最近在折腾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



共有 人打赏支持
粉丝 392
博文 377
码字总数 482277
×
China_OS
如果觉得我的文章对您有用,请随意打赏。您的支持将鼓励我继续创作!
* 金额(元)
¥1 ¥5 ¥10 ¥20 其他金额
打赏人
留言
* 支付类型
微信扫码支付
打赏金额:
已支付成功
打赏金额: