[mysql 使用内存统计公式]
//每个连接(线程) 使用的内存数量(这些配置加在一起)
per_connection_memory =
read_buffer_size // memory for sequential table scans
+read_rnd_buffer_size// Memory for buffering reads
+sort_buffer_size // Memory for in mem sorts
+thread_stack // Per connection memory
+join_buffer_size // Memory for in mem table joins
//每个服务器(固定)使用的内存数量：(这些配置加在一起)
per_server_memory =
tmp_table_size // memory for all temp tables
+max_heap_table_size// max size of single temp table
+key_buffer_size // memory allocated for index blocks
+innodb_buffer_pool_size// main cache for InnoDB data
+innodb_additional_mem_pool_size// InnoDB record structure cache
+innodb_log_buffer_size // log file write buffer
+query_cache_size // compiled statement cache
//一个mysql使用内存总计
max_memory = (per_connection_memory * max_connections) + per_server_memory
383
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
