小内存VPS的MYSQL优化配置

mysql 5.7 yum 安装配置

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'

# 选择0（LOW），1（MEDIUM），2（STRONG）其中一种，选择2需要提供密码字典文件
validate_password_policy=0

query_cache_limit = 256K
query_cache_size = 4M
max_allowed_packet = 1M
max_connections = 16
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 64K
#skip-bdb
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 8M
sort_buffer_size = 8M

[myisamchk]
key_buffer = 8M
sort_buffer_size = 8M

[mysqlhotcopy]
wait_timeout=100
interactive_timeout=100
max_connections = 16384

show global variables like 'wait_timeout';

set global wait_timeout=100;