mysql 4核_4 核 8G ECS MYSQL 求助配置

explicit_defaults_for_timestamp

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

slow_query_log=on

slow_query_log_file = /var/log/mysql_slow.log

long_query_time = 2

#performance

max_allowed_packet = 32M

max_heap_table_size = 128M

sort_buffer_size = 16M

join_buffer_size = 16M

thread_cache_size = 16

query_cache_size = 128M

query_cache_limit = 4M

ft_min_word_len = 8

thread_stack = 512K

tmp_table_size = 128M

#MyISAM

read_buffer_size = 8M

read_rnd_buffer_size = 64M

myisam_sort_buffer_size = 256M

skip-federated

当前配置文档。 基本完全不懂 都是从网上一点一点看来了 求助

业务量还可以，想最大利用

目前没读写分离