本文共 2580 字,大约阅读时间需要 8 分钟。
[client]port = 3358socket = /export/data/mysql/tmp/mysql.sock[mysqld]port = 3358socket = /export/data/mysql/tmp/mysql.sockdatadir = /export/data/mysql/data#--- GLOBAL ---#character-set-server = utf8lower_case_table_names = 1log-output = FILElog-error = /export/data/mysql/log/error.loggeneral_loggeneral_log_file = /export/data/mysql/log/mysql.logpid-file = /export/data/mysql/data/mysql.pidslow-query-logslow_query_log_file = /export/data/mysql/log/slow.logtmpdir = /export/data/mysql/tmp/long_query_time = 0.1#sync_binlog = 1#--------------#thread_concurrency = 16thread_cache_size = 512table_open_cache = 16384table_definition_cache = 16384sort_buffer_size = 2Mjoin_buffer_size = 2Mread_buffer_size = 4Mread_rnd_buffer_size = 4Mkey_buffer_size = 64Mmyisam_sort_buffer_size = 64Mtmp_table_size = 256Mmax_heap_table_size = 256Mopen_files_limit = 65535#query_cache_size = 2G#--- NETWORK ---#back_log = 1024max_allowed_packet = 16Minteractive_timeout = 300wait_timeout = 300skip-external-lockingmax-connections = 1000skip-name-resolve#--- REPL ---#server-id = 22482log-bin = mysql-binbinlog_format = ROWexpire_logs_days = 7relay-log = relay-logreplicate-ignore-db = testlog_slave_updatesskip-slave-start#--- INNODB ---#default-storage-engine = INNODBinnodb_data_home_dir = /export/data/mysql/datainnodb_data_file_path = ibdata1:10G;ibdata2:10G:autoextendinnodb_autoextend_increment = 500innodb_log_group_home_dir = /export/data/mysql/datainnodb_buffer_pool_size = 48Ginnodb_additional_mem_pool_size = 128Minnodb_log_files_in_group = 3innodb_log_file_size = 512Minnodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 120innodb_flush_method = O_DIRECTinnodb_max_dirty_pages_pct = 75innodb_io_capacity = 1000innodb_thread_concurrency = 32innodb_open_files = 65535[mysqldump]quickmax_allowed_packet = 16M[mysql]auto-rehash# Remove the next comment character if you are not familiar with SQL#safe-updatesdefault-character-set=utf8[myisamchk]key_buffer_size = 128Msort_buffer_size = 128Mread_buffer = 2Mwrite_buffer = 2M[mysqlhotcopy]interactive-timeout
转载于:https://blog.51cto.com/326028/1439551