前言

mysql：5.6.23

f配置文件

[mysqld]port=3306#server-id = 2#log-bin = mysql-bin#log_bin_trust_function_creators = 1#auto-increment-increment = 2#auto-increment-offset = 2#wait_timeout=5back_log = 50innodb_buffer_pool_size = 2Ginnodb_flush_log_at_trx_commit=0innodb_file_per_table=1innodb_thread_concurrency = 16max_connections=1000max_connect_errors = 10wait_timeout=600max_allowed_packet = 16Mskip-name-resolveopen_files_limit=8192table_open_cache = 2048binlog_cache_size = 1Mmax_heap_table_size = 64Mread_rnd_buffer_size = 16Msort_buffer_size = 8Mjoin_buffer_size = 8Mthread_cache_size = 16thread_concurrency = 16query_cache_size = 64Mquery_cache_limit = 2Mcharacter-set-server = utf8mb4tmp_table_size = 64Minnodb_additional_mem_pool_size = 16Mdatadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.socklower_case_table_names=1symbolic-links=0[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidopen-files-limit = 8192

修改后检查是否启效

show variables like "%timeout%";show variables like "wait_timeout";show variables like "max_connections";SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

参考

/zengkefu/p/5652510.html