Maximum MySQL Memory Usage
= innodb_buffer_pool_size +
key_buffer_size +
tmp_table_size +
((read_buffer_size + read_rnd_buffer_size +
sort_buffer_size + join_buffer_size) X max_connections)
最好不要超过RAM的80%
8g内存配置:
innodb_buffer_pool_size = 2g
key_buffer_size = 512M
tmp_table_size = 512M
max_connections = 1000
read_buffer_size = 2M
read_rnd_buffer_size = 2M
sort_buffer_size = 2M
join_buffer_size = 2M