|
最近在折腾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 (责任编辑：IT) |