was killed: out of swap space

Antspirit

出现这个问题很奇怪，我内存是12G，swap是24G，swap不可能用完吧？就跑这几个服务，结果一下子全挂了。求原因。。


Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 976 (mysqld), uid 88, was killed: out of swap space
Mar  1 11:02:05 localhost pid 5686 (vim), uid 1002, was killed: out of swap space
Mar  1 11:02:05 localhost pid 5686 (vim), uid 1002, was killed: out of swap space
Mar  1 11:02:06 localhost pid 834 (snmpd), uid 0, was killed: out of swap space
Mar  1 11:02:06 localhost pid 834 (snmpd), uid 0, was killed: out of swap space

猴马大叶

使用vmstat /df等工具查下 swap的使用率先.

猴马大叶

然后檢查 my.cnf里這個參數
query_cache_size=OOXXM