MySQL崩潰錯誤：Out of memory (Needed 1073741816 bytes)

大多數人認為MySQL的最大記憶體占用大小的公式是這樣的：

Maximum MySQL Memory Usage = innodb_buffer_pool_size + key_buffer_size + (read_buffer_size + sort_buffer_size) X max_connections

但是我更傾向于這種：

Maximum MySQL Memory Usage = innodb_buffer_pool_size + key_buffer_size + ((read_buffer_size + read_rnd_buffer_size + sort_buffer_size + join_buffer_size) X max_connections)

這些變量導入公式後的總和不要超過實體記憶體的80%：

sort_buffer_size

read_buffer_size

read_rnd_buffer_size

join_buffer_size

max_connections

原文：http://dba.stackexchange.com/questions/1927/why-does-mysql-say-im-out-of-memory