自己的站点托管在Tencent Cloud 入门低配1H1G,安装的mysql 5.6 默认是Innodb,Mysql官方要求2G内存起,这就尴尬了,与此同时Wordpress官方也开始推荐5.6版本,也许默认大家都是大内存机器吧!
这次主要改了三点
1、Swap
之前默认也是1G,我把它调到2G
2、Mysql配置修改
performance_schema_max_table_instances = 200
table_definition_cache = 200
skip-external-locking
key_buffer_size = 8M
max_allowed_packet = 100G
table_open_cache = 32
sort_buffer_size = 256K
net_buffer_length = 4K
read_buffer_size = 128K
read_rnd_buffer_size = 256K
myisam_sort_buffer_size = 4M
thread_cache_size = 4
query_cache_size = 4M
tmp_table_size = 8M
3、PHP配置