Default configuration Vim/etc/my.cnf.rpmsave
MySQL Ver 14.14 distrib 5.6.30, for linux-glibc2.5 (x86_64) using Editline Wrapper
[Client]port = 3306socket =/tmp/mysql.sockdefault-character-set = utf8mb4[mysql]prompt= "MySQL [\d]>" No-auto-rehash[mysqld]port = 3306socket =/tmp/mysql.sockbasedir =/usr/local/mysql datadir =/data/mysqlpid-file =/data/mysql/mysql.piduser = Mysqlbind-address = 0.0.0.0server-id = 1init-connect = ' SET NAMES utf8mb4 ' Character-set-ser ver = Utf8mb4skip-name-resolve#skip-networkingback_log = 300max_connections = 496max_connect_errors = 6000open_files_ Limit = 65535table_open_cache = 128 max_allowed_packet = 500mbinlog_cache_size = 1mmax_heap_table_size = 8Mtmp_ Table_size = 16mread_buffer_size = 2mread_rnd_buffer_size = 8msort_buffer_size = 8mjoin_buffer_size = 8Mkey_buffer_size = 4mthread_cache_size = 8query_cache_type = 1query_cache_size = 8mquery_cache_limit = 2mft_min_word_len = 4log_bin = mysql- Binbinlog_format = Mixedexpire_logs_days = 7 log_error =/data/mysql/mysql-error.logslow_query_log = 1long_query_ Time = 1slow_query_log_file =/data/mysql/mysql-slow.logperfoRmance_schema = 0explicit_defaults_for_timestamp#lower_case_table_names = 1skip-external-lockingdefault_storage_ Engine = Innodbinnodb_file_per_table = 1innodb_open_files = 500innodb_buffer_pool_size = 64minnodb_write_io_threads = 4innodb_read_io_threads = 4innodb_thread_concurrency = 0innodb_purge_threads = 1innodb_flush_log_at_trx_commit = 2innodb_log_buffer_size = 2minnodb_log_file_size = 32minnodb_log_files_in_group = 3innodb_max_dirty_pages_pct = 90innodb_lock_wait_timeout = 120bulk_insert_buffer_size = 8mmyisam_sort_buffer_size = 8Mmyisam_max_sort_file_size = 10gmyisam_repair_threads = 1interactive_timeout = 28800wait_timeout = 28800[mysqldump]quickmax_allowed_packet = 500M[ Myisamchk]key_buffer_size = 8msort_buffer_size = 8mread_buffer = 4mwrite_buffer = 4M
Centos7 mysql 5.6.30 default configuration file
