Mysql/etc/my.cnf

[Client]port=3306socket =/tmp/mysql.sockdefault-character-set=utf8[mysqld]# 1 General configport=3306socket =/tmp/ Mysql.sockdatadir =/u02/mysqlbinlog_cache_size = 1mdefault-storage-engine = Innodbevent_scheduler = 1federatedjoin_ Buffer_size = 16mlocal-infile=1#log-slow-queries=/u02/mysql/aslowquery.loglong_query_time = 10slow_query_loglower_ Case_table_names=1max_heap_table_size = 256mmax_length_for_sort_data = 2048open-files-limit = 16384#mem 16G-32G 1 64g-512g 2query_cache_size = 32mquery_cache_type= 1skip-name-resolve#table_cache=1024thread_cache=1024thread_cache _size = 1024thread_stack = 256ktmp_table_size = 512msort_buffer_size = 32mlarge-pages=1# 2 Network Configback_log = 1000ma X_connect_errors = 500max_connections = 10000max_user_connections=10000max_delayed_threads = 200max_prepared_stmt_ Count = 65528max_allowed_packet = 256mnet_read_timeout = 36000net_write_timeout = 36000wait_timeout = 43200# 3 MyISAM conf Ig#myisam Insert Select,insert values,load data infile perf 16G 1,32G 2 64g-512g 4bulk_insert_buffer_size = 128mconcurrent_insert=2#use MyISAM fulltext Onlyft_min_word_len = 4#60% Mem 1/3,o Ther 2/3 innodb_buffer_pool_sizekey_buffer_size = 512m#low-priority-updates=1max_write_lock_count=1myisam_max_sort _file_size = 1gmyisam_recovermyisam_repair_threads = 1#myisam perf 16G 1 32g-512g 2myisam_sort_buffer_size = 256Mread_buf Fer_size = 32mread_rnd_buffer_size = 32mskip-external-locking# 4 InnoDB configinnodb_file_per_tableinnodb_additional_ Mem_pool_size = 16m#60% Mem 2/3, other 1/3 myisam key_buffer_sizeinnodb_buffer_pool_size = 256minnodb_data_file_path = ibd Ata1:1000m:autoextendinnodb_flush_log_at_trx_commit = 0innodb_lock_wait_timeout = 120innodb_log_buffer_size = 8minnodb_log_file_size = 256minnodb_log_files_in_group = 3innodb_max_dirty_pages_pct = 90innodb_read_io_threads = 8innodb_thread_concurrency = 16innodb_write_io_threads = 8innodb_data_home_dir =/u02/mysqlinnodb_log_group_home_dir =/u02/mysqlinnodb_old_blocks_time=1000#only FIO Diskinnodb_fluSh_method = o_direct# 5 Replication configexpire_logs_days = 7#log-slave-updatesslave-skip-errors = allslave_net_ Timeout = 36000server-id = 105240replicate_wild_do_table=wms.%replicate_wild_ignore_table=mysql.%log-bin= Mysql-binlog-slave-updates[mysql]no-auto-rehash[mysqldump]quickmax_allowed_packet = 128M[myisamchk]key_buffer = 4096msort_buffer_size = 512mread_buffer = 8mwrite_buffer = 8m[mysqlhotcopy]interactive-timeout[mysqld_safe]  Malloc-lib=tcmalloc

Mysql/etc/my.cnf