DSAS鐃緒申発鐃峻わ申鐃緒申鐃緒申:DB鐃緒申鐃緒申鐃出醐申鐃緒申Linux鐃緒申鐃遵ー鐃祝ングわ申佑鐃緒申鐃� 鐃緒申鐃緒申鐃所オ鐃緒申鐃出￥申鐃緒申鐃淳ッワ申鐃緒申

2006年09鐃緒申14鐃緒申

DB鐃緒申鐃緒申鐃出醐申鐃緒申Linux鐃緒申鐃遵ー鐃祝ングわ申佑鐃緒申鐃� 鐃緒申鐃緒申鐃所オ鐃緒申鐃出￥申鐃緒申鐃淳ッワ申鐃緒申

C鐃叔プワ申鐃緒申鐃緒申鐃緒申颪い討鐃緒申鐃緒申鐃緒申未離鐃緒申鐃緒申鐃緒申櫃鐃緒申鐃緒申鐃緒申覆辰鐃緒申箸鐃緒申鐃緒申鐃緒申鐃緒申 malloc鐃緒申箸鐃緒申隼廚鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申虜櫃砲鐃緒申鐃緒申鐃粛わ申NULL鐃緒申鐃宿わ申鐃緒申鐃緒申判鐃叔わ申鐃銃ワ申鐃初ー鐃緒申鐃緒申鐃緒申鐃緒申鐃出わ申鐃夙思わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申Linux 鐃塾ワ申鐃緒申鐃緒申鐃緒申鐃緒申屮鐃緒申鐃緒申謄鐃祝は「ワ申鐃所・鐃緒申鐃緒申鐃出￥申鐃緒申鐃淳ット」とわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃所、鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申鐃緒申鐃緒申幣鐃緒申鐃塾逸申鐃緒申鐃楯でわ申鐃銃わ申鐃殉わ申鐃殉わ申鐃緒申

鐃庶し鐃祝以駕申鐃塾よう鐃淑器申単鐃淑ワ申鐃緒申鐃緒申 (alloctest.c) 鐃緒申颪い討澆泙鐃緒申鐃�



#include <stdio.h>

#include <stdlib.h>



int main()

{

  int i;

  char *p;

  for(i=0;i<65536;i++){

    p = (char *)malloc(65536);

    if(0 == (long)p){

      break;

    }

  }

  printf("SIZE=%dMB\n",i*65536/1024/1024);

  return(0);

}

swapoff 鐃緒申鐃緒申鐃緒申鐃緒申 1G 鐃塾マワ申鐃緒申任鐃緒申鐃緒申孫圓鐃緒申鐃夙わ申鐃緒申粉鐃緒申鐃緒申砲覆鐃殉わ申鐃緒申



$ gcc -o alloctest alloctest.c

$ ./alloctest

SIZE=3052MB

鐃緒申鐃淑みわ申 free 鐃塾件申未呂鐃緒申鐃淑器申鐃緒申鐃叔わ申鐃緒申



$ free -m

             total       used       free     shared    buffers     cached

Mem:           938        728        209          0        191        118

-/+ buffers/cache:        418        519

Swap:            0          0          0

鐃淑わ申鐃� 1G 鐃塾マワ申鐃緒申覆里鐃� 3G 鐃緒申鐃緒申琉鐃緒申鐃緒申櫃鐃緒申襪鰹申箸鐃緒申任鐃緒申討鐃緒申泙鐃緒申泙鐃緒申鐃緒申鐃�
Linux 鐃塾駕申鐃循ワ申鐃所シ鐃緒申鐃銃ワ申任蓮鐃緒申廛鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申櫃鐃緒申鐃楯にはわ申鐃緒申鐃緒申鐃藷あわ申茲�申妨鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申鐃緒申董鐃緒申尊櫃縫鐃緒申鐃緒申鐃緒申鐃緒申鐃夙�申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑�申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃てわ申鐃殉わ申鐃緒申鐃緒申鐃緒申蓮鐃緒申鐃叔逸申里鐃緒申瓩わ申辰僂鐃緒申鐃緒申鐃緒申鐃緒申櫃鐃緒申討鐃緒申鐃緒申鐃緒申票尊櫃呂鐃緒申鐃淑に使わ申覆鐃緒申廛鐃緒申鐃緒申鐃緒申廚鐃淑ｏ申鐃銃逸申鐃緒申討鐃緒申鐃夙わ申鐃淑どに￥申鐃熟￥申鐃宿ワ申鐃緒申鐃緒申鐃所ソ鐃緒申鐃緒申鐃緒申有鐃緒申鐃緒申鐃術わ申鐃暑た鐃緒申鐃粛ワ申譴随申鐃緒申箸澆箸鐃緒申鐃緒申泙鐃緒申鐃�

鐃緒申鐃緒申任蓮鐃緒申尊櫃縫鐃緒申鐃緒申鐃渋㍼申鐃緒申鐃緒申鐃緒申鐃緒申鐃宿わ申鐃淑ってわ申鐃殉わ申鐃塾でわ申鐃順う鐃緒申鐃緒申
鐃緒申鐃緒申鐃緒申鐃出場す鐃緒申里鐃粛㌣常申福鐃�OOM Killer鐃竣とわ申鐃緒申鐃緒申鐃夙みでわ申鐃緒申
Linux 鐃緒申鐃渋際にワ申鐃緒申鐃緒申足鐃祝陥わ申函鐃緒申箸鐃緒申襯�申襯器申螢削申鐃叔わ申鐃緒申鐃縦わ申鐃塾プワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃薯し￥申鐃緒申鐃緒申鮠ー鐃緒申 kill 鐃緒申鐃銃わ申鐃殉わ申鐃殉わ申鐃緒申kill 鐃緒申鐃緒申鐃竣ワ申鐃緒申鐃緒申鐃熟￥申鐃緒申分鐃緒申鐃緒申鐃緒申鐃緒申箸鐃緒申鐃緒申里鐃緒申鐃緒申里鐃粛鰹申鐃緒申鐃緒申鐃殉わ申鐃緒申

鐃縦まり、malloc 鐃塾件申未鮓�謄鐃緒申鐃緒申鐃渋㍼申離鐃緒申蕁種申鐃緒申鐃緒申鬚靴討鐃緒申鐃緒申箸鐃緒申討癲�申尊櫃砲鐃緒申僚鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃熟なわ申鐃塾でわ申鐃緒申Linux 鐃緒申鐃銃逸申鐃緒申討鐃緒申鐃緒申鐃緒申討離廛鐃緒申鐃緒申鐃緒申蓮鐃緒申鐃緒申鐃緒申謄爐�申鐃緒申鐃緒申鐃渋㍼申砲覆辰討鐃緒申討盖わ申砲鐃緒申鐃緒申鐃銃逸申遒件申弔鼎鐃緒申討鐃緒申泙鐃緒申鐃緒申鐃緒申鐃塾�申任鐃� OOM Killer 鐃緒申鐃緒申鐃獣わ申鐃夙プワ申鐃緒申鐃緒申鐃緒申鐃緒申澆鐃緒申討鐃緒申鐃緒け鐃叔わ申鐃緒申

鐃緒申鐃夙常申鐃祝わ申辰討魯僖侫鐃緒申鐃緒申泪鐃緒申未砲鐃緒申鐃緒申鐃� OOM Killer 鐃緒申有鐃緒申鐃淑誌申鐃盾あ鐃緒申泙鐃緒申里如鐃宿�申鐃緒申鐃緒申發鰹申了鐃緒申箸澆鐃緒申鐃緒申鐃緒申箸呂鐃緒申鐃緒申泙鐃緒申鵑�鐃緒申鐃緒申鐃緒申鐃�MySQL 鐃緒申 PostgreSQL 鐃淑どわ申 DB鐃緒申鐃緒申鐃出でわ申鐃塾居申鐃緒申鐃緒申動鐃緒申鐃銃わ申鐃緒申鐃塾は嬉しわ申鐃緒申鐃夙ではわ申鐃緒申泙鐃緒申鵝�鐃緒申鐃緒申鐃渋㍼申鐃緒申鐃緒申鐃緒申廼鐃緒申鐃重�申縫廛鐃緒申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃緒申襪�申蕕わ申覆蕁� DB鐃緒申鐃緒申鐃出種申鐃夙でワ申鐃緒申鐃緒申足鐃薯検出わ申鐃銃ワ申鐃初ー鐃緒申鐃緒申鐃薯しわ申鐃循わ申鐃緒申鐃緒申鐃緒申鐃叔はなわ申鐃叔わ申鐃順う鐃緒申鐃緒申

鐃緒申鐃緒申鐃粛ワ申2.6鐃叔は￥申鐃淑駕申鐃塾ワ申鐃殉ワ申匹任鐃緒申鐃銃逸申鐃緒申鐃緒申鐃醇す鐃暑こ鐃夙わ申鐃叔わ申鐃緒申茲�申砲覆辰討鐃緒申泙鐃緒申鐃�



# sysctl -w vm.overcommit_ratio=99

# sysctl -w vm.overcommit_memory=2

/proc/sys/vm/overcommit_ratio鐃緒申鐃叔鰹申鐃楯でわ申鐃緒申物鐃緒申鐃緒申鐃緒申粒鐃緒申鐃緒申鐃所し鐃殉わ申鐃緒申
/proc/sys/vm/overcommit_memory 鐃緒申 2鐃祝わ申鐃緒申肇鐃緒申螢�申鐃緒申弌鐃緒申鐃緒申潺奪箸鐃緒申鐃緒申鐃淑わ申鐃淑わ申泙鐃緒申鐃�

鐃緒申overcommit_ratio 鐃塾デフワ申鐃緒申鐃緒申佑鐃� 50 鐃叔わ申鐃緒申鐃緒申鐃所し鐃淑わ申鐃殉まわ申鐃緒申鐃緒申椒鐃緒申鐃緒申半分鐃殉でわ申鐃緒申鐃緒申鐃楯でわ申鐃淑わ申鐃淑ってわ申鐃殉わ申鐃殉わ申鐃塾でわ申鐃緒申鐃春駕申鐃緒申鐃緒申鐃緒申鐃叔なわ申鐃夙わ申鐃緒申鐃初こ鐃緒申鐃緒申妊鐃緒申鐃緒申鐃渋㍼申鐃緒申任呂鐃緒申鐃殉わ申鐃緒申

鐃緒申鐃塾常申鐃瞬わ申鐃緒申曚匹鐃� alloctest 鐃緒申孫圓鐃緒申討澆泙鐃緒申鐃�



$ ./alloctest

SIZE=428MB

鐃渋際の駈申鐃緒申鐃緒申鐃縮わ申鐃緒申鐃緒申鐃楯でわ申鐃淑わ申鐃淑っわ申鐃処う鐃叔わ申鐃緒申

MySQL鐃塾パフワ申鐃緒申鐃殉ンスワ申鐃遵ー鐃祝ングなどをすわ申櫃砲蓮鐃�overcommit_memory=2 鐃祝わ申鐃銃鰹申鐃楯でわ申鐃緒申鐃緒申螢居申鐃緒申鐃緒申鐃緒申鐃緒申造鐃緒申討鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申蠅�㍼申鐃淑わ申鐃淑っわ申鐃緒申 Out Of Memory 鐃緒申 MySQL 鐃緒申鐃緒申分鐃緒申鐃緒申鐃緒申鐃処う鐃祝なわ申泙鐃緒申里如鐃緒申尊櫃砲匹鐃緒申鐃緒申鐃塾ワ申鐃緒申鐃宿�申廚箸鐃緒申討鐃緒申襪�申鐃緒申錣�申鐃処う鐃祝なわ申泙鐃緒申鐃�
鐃緒申鐃緒申妊丱奪侫鐃緒申鐃緒申鐃緒申鐃緒申覆匹離僖鐃潤ー鐃緒申調鐃緒申鐃緒申鐃銃易になわ申里任呂覆鐃緒申任鐃緒申腓�申鐃緒申鐃�

鐃緒申鐃緒申

/proc/sys/vm/* 鐃祝関わ申鐃緒申文鐃緒申

klab_gijutsu2 at 17:13鐃緒申Comments(2)鐃緒申TrackBack(0)鐃緒申kernel | mysql

鐃夙ワ申奪鐃緒申丱奪鐃�URL

鐃緒申鐃塾居申鐃緒申鐃舜のワ申鐃緒申鐃緒申

2. Posted by imsut 2006年12鐃緒申06鐃緒申 20:41

鐃緒申鐃緒申砲鐃緒申蓮鐃�OOM Killer鐃塾わ申鐃夙は始わ申鐃緒申里鐃殉わ申鐃緒申鐃緒申鐃駿駈申鐃祝なわ申泙鐃緒申鐃�

> MySQL鐃塾パフワ申鐃緒申鐃殉ンスワ申鐃遵ー鐃祝ングなどをすわ申櫃砲蓮鐃�overcommit_ratio=2 鐃祝わ申鐃緒申

鐃緒申overcommit_memory=2鐃祝わ申鐃銃」ではなわ申鐃叔わ申鐃順う鐃緒申? _ratio=2鐃緒申鐃夙￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃夙になりそ鐃緒申鐃叔わ申鐃緒申

3. Posted by Yasui 2006年12鐃緒申06鐃緒申 21:18

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申

imsut鐃緒申鐃藷、わ申鐃緒申摘鐃緒申鐃所が鐃夙わ申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申
鐃緒申文鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申
鐃緒申鐃緒申鐃緒申鐃緒申 ratio=2 鐃祝わ申鐃緒申閥鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申箸砲覆鐃殉わ申鐃緒申(^^;

鐃緒申鐃塾居申鐃緒申鐃祝ワ申鐃緒申鐃夙わ申鐃緒申

名鐃緒申:
鐃潤ー鐃緒申:
URL:
	鐃緒申鐃緒申魑⑱鐃�:	評鐃緒申:	鐃緒申鐃緒申

DSAS鐃緒申発鐃峻わ申鐃緒申鐃緒申

DB鐃緒申鐃緒申鐃出醐申鐃緒申Linux鐃緒申鐃遵ー鐃祝ングわ申佑鐃緒申鐃� 鐃緒申 鐃緒申鐃所オ鐃緒申鐃出￥申鐃緒申鐃淳ッワ申鐃緒申

鐃夙ワ申奪鐃緒申丱奪鐃�URL

鐃緒申鐃塾居申鐃緒申鐃舜のワ申鐃緒申鐃緒申

鐃緒申鐃塾居申鐃緒申鐃祝ワ申鐃緒申鐃夙わ申鐃緒申

DB鐃緒申鐃緒申鐃出醐申鐃緒申Linux鐃緒申鐃遵ー鐃祝ングわ申佑鐃緒申鐃� 鐃緒申鐃緒申鐃所オ鐃緒申鐃出￥申鐃緒申鐃淳ッワ申鐃緒申