如果默认安装的MYSQL不修改配置是正常的
max_connections = 300
table_open_cache = 256
query_cache_size = 64M
tmp_table_size = 32M
thread_cache_size = 128
binlog_cache_size = 32K
thread_stack = 256K
read_buffer_size = 128K
query_cache_type = 1
max_heap_table_size = 32M
key_buffer_size = 128M
expire_logs_days = 10
一旦通过性能调整调整保存过配置信息
#skip-locking
max_connections = 200
table_open_cache = 192
query_cache_size = 128
tmp_table_size = 384
thread_cache_size = 96
binlog_cache_size = 64
thread_stack = 256
read_buffer_size = 768
query_cache_type = 1
max_heap_table_size = 32
key_buffer_size = 256
expire_logs_days = 10
缺少相应的参数
BUG 请修复
也请调整过性能的 检查下 |