was killed: out of swap space

Antspirit

出現(xiàn)這個(gè)問題很奇怪，我內(nèi)存是12G，swap是24G，swap不可能用完吧？就跑這幾個(gè)服務(wù)，結(jié)果一下子全掛了。求原因。。


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里這個(gè)參數(shù)
query_cache_size=OOXXM