ITPub博客

首页 > 云计算 > 公有云实践 > mysql的配置文件my.cnf

mysql的配置文件my.cnf

原创 公有云实践 作者:ocpDBAboy 时间:2020-06-13 22:56:12 0 删除 编辑

[client]

port=3306

socket=/u01/svr/run/mysql.sock


[mysql]

#pid_file=/u01/svr/run/mysqld.pid


[mysqld]

autocommit=1

general_log=off

explicit_defaults_for_timestamp=true


# system

basedir=/u01/svr

datadir=/u01/mydata

max_allowed_packet=1g

max_connections=3000

max_user_connections=2800

open_files_limit=65535

#pid_file=/u01/svr/run/mysqld.pid

port=3306

server_id=101

skip_name_resolve=ON

socket=/u01/svr/run/mysql.sock

tmpdir=/u01/tmp


#binlog

log_bin=/u01/logs/binlog/binlog

binlog_cache_size=32768

binlog_format=row

expire_logs_days=7

log_slave_updates=ON

max_binlog_cache_size=2147483648

max_binlog_size=524288000

sync_binlog=100


#logging

log_error=/u01/logs/error.log

slow_query_log_file=/u01/logs/slow.log

log_queries_not_using_indexes=0

slow_query_log=1

log_slave_updates=ON

log_slow_admin_statements=1

long_query_time=1


#relay

relay_log=/u01/logs/relaylog

relay_log_index=/u01/logs/relay.index

relay_log_info_file=/u01/logs/relay-log.info


#slave

slave_load_tmpdir=/u01/tmp

slave_skip_errors=OFF


#innodb

innodb_data_home_dir=/u01/logs/iblog

innodb_log_group_home_dir=/u01/logs/iblog

innodb_adaptive_flushing=ON

innodb_adaptive_hash_index=ON

innodb_autoinc_lock_mode=1

innodb_buffer_pool_instances=8


#default

innodb_change_buffering=inserts

innodb_checksums=ON

innodb_buffer_pool_size= 128M

innodb_data_file_path=ibdata1:32M;ibdata2:16M:autoextend

innodb_doublewrite=ON

innodb_file_format=Barracuda

innodb_file_per_table=ON

innodb_flush_log_at_trx_commit=1

innodb_flush_method=O_DIRECT

innodb_io_capacity=1000

innodb_lock_wait_timeout=10

innodb_log_buffer_size=67108864

innodb_log_file_size=1048576000

innodb_log_files_in_group=4

innodb_max_dirty_pages_pct=60

innodb_open_files=60000

innodb_purge_threads=1

innodb_read_io_threads=4

innodb_stats_on_metadata=OFF

innodb_support_xa=ON

innodb_use_native_aio=OFF

innodb_write_io_threads=10


[mysqld_safe]

datadir=/u01/mydata

------------------end 

good luck! 

2020年6月13日

于北京朝阳常营

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29267792/viewspace-2698189/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论
积极,热爱生活!

注册时间:2014-01-15

  • 博文量
    31
  • 访问量
    105980