mysql内存计算公式
mysql used mem=key_buffer_size+query_cache_size+tmp_table_size+innodb_buffer_pool_size
+innodb_additional_mem_pool_size+innodb_log_buffer_size
+max_connections*(read_buffer_size+read_rnd_buffer_size+sort_buffer_size+join_buffer_size+binlog_cache_size
+thread_stack)
在mysql 中输入如下命令,可自动计算自己的当前配置最大的内存消耗
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
SHOW VARIABLES LIKE 'innodb_additional_mem_pool_size';
SHOW VARIABLES LIKE 'i