tpe_app#password = your_passwordport = 3306socket = /usr/local/mysql/tmp/mysql.sock
[mysqld]innodb_file_per_tableskip-external-lockingskip-name-resolvebig_tableslocal-infile = 0port = 3306socket = /usr/local/mysql/tmp/mysql.socktmpdir = /usr/local/mysql/tmp/character-set-server = utf8max_allowed_packet = 16Mtable_cache = 512tmp_table_size = 512Mmax_heap_table_size = 512Mmax_connections = 1024wait_timeout = 28800 #200interactive_timeout = 28800 #300thread_cache = 300thread_concurrency = 8table_cache = 512net_read_timeout = 30 #( default 30 )net_write_timeout = 30 #( default 30 )net_retry_count = 10 #( default 10 )connect_timeout = 10 #( default 10 )key_buffer_size = 64Mgroup_concat_max_len = 9999
#-------------------------------------------------------------query_cache_type = 0query_cache_limit = 8MBquery_cache_min_res_unit = 4KBquery_cache_size = 256M#-------------------------------------------------------------
# --- thread_buffers ----------------
sort_buffer_size = 4Mbulk_insert_buffer_size = 4Mmyisam_sort_buffer_size = 32Mread_buffer_size = 2Mread_rnd_buffer_size = 512Kjoin_buffer_size = 16M
#skip-networking#skip-slave-start
#-------------- slow query -------------------------------------------------
long_query_time = 2#slow_query_log_file = /var/log/mysql/slow-queries.loglog_slow_queries=/var/log/mysql/slow-queries.log#log-queries-not-using-indexes
#--------------------- log bin -------------------------------------------server-id = 10011log-bin=/usr/local/mysqllog/tpeapp-binlog-bin-trust-function-creators=1max_binlog_cache_size = 500Mmax_binlog_size = 100Msync_binlog = 0#expire_logs_days = 30log-slave-updatesbinlog_format=mixed--- max_relay_log_size = 100Mbinlog-row-event-max-size = 1024binlog_direct_non_transactional_updates = 1
##-------------------- slave start -----------------------------------
master-host = 192.168.100.12master-user = tpireplmaster-password = lJY8rtY1jqodQmaster-port = 3306master-connect-retry = 30master-retry-count = 10low_priority_updates = 1report-host = 10011#slave-skip-errors = 1022slave_transaction_retries = 10slave-net-timeout = 30
read_only#log-slave-update#replicate-ignore-db = mysql#replicate-wild-ignore-table=PIXOS_DB.TB_TEMP_%
# ---- relay-logrelay-log = /usr/local/mysqllog/tpeapp-relay-binrelay-log-index =/usr/local/mysqllog/tpeapp-relay-bin.indexmax-relay-log-size = 100Mrelay-log-space-limit = 100Mrelay-log-purge = 1
##-------------------- slave end -----------------------------------
#------------------- innodb ----------------------------------------------
default-storage-engine = innodbinnodb_data_home_dir =innodb_data_file_path=/usr/local/mysqldata/ibdata1:2000M;/usr/local/mysqldata/ibdata2:2000M:autoextendinnodb_log_group_home_dir = /usr/local/mysqldatainnodb_buffer_pool_size=1048Minnodb_additional_mem_pool_size=64Minnodb_log_files_in_group = 2innodb_log_file_size=250Minnodb_log_buffer_size=8Minnodb_flush_log_at_trx_commit=2innodb_lock_wait_timeout=50innodb_checksums=0innodb_support_xa=0innodb_doublewrite=0innodb_thread_concurrency = 100innodb_concurrency_tickets = 1000innodb_locks_unsafe_for_binlog=1transaction-isolation = REPEATABLE-READ##innodb_force_recovery = 1
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
关于TWT使用指南社区专家合作厂商入驻社区企业招聘投诉建议版权与免责声明联系我们 © 2024talkwithtrend — talk with trend,talk with technologist京ICP备09031017号-30
添加新评论0 条评论