[mysql使用内存统计表达式
//每个连接(线程)使用的内存数量(这些配置的总和) ) ) )。
per_connection_memory=
read _ buffer _ size//memoryforsequentialtablescans
read _ rnd _ buffer _ size//memoryforbufferingreads
sort _ buffer _ size//memoryforinmemsorts
thread _ stack//perconnectionmemory
join _ buffer _ size//memoryforinmemtablejoins
//每台服务器(固定)使用的内存数) ) ) ) ) )。
per_server_memory=
tmp _ table _ size//memoryforalltemptables
max _ heap _ table _ size//maxsizeofsingletemptable
key _ buffer _ size//memoryallocatedforindexblocks
innodb _ buffer _ pool _ size//maincacheforinnodbdata
innodb _ additional _ mem _ pool _ size//innodbrecordstructurecache
innodb _ log _ buffer _ size//logfilewritebuffer
query _ cache _ size//compiledstatementcache
//MySQL1一个使用内存的总和
max _ memory=(per _ connection _ memory * max _ connections ) per_server_memory