Re: Configuring sql.DB for Better Performance
Configuring sql.DB for Better Performance 鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾わ申泙鐃緒申鐃緒申鐃� 鐃緒申鐃粛ワ申鐃緒申鐃緒申鐃竣￥申鐃緒申鐃緒申腓�鐃緒申鐃緒申鐃緒申鐃醇す鐃緒申3鐃縦わ申鐃緒申鐃緒申鐃緒申鐃叔�鐃祝駕申鐃盾さ鐃曙た鐃夙てわ申鐃宿わ申鐃緒申鐃緒申鐃叔わ申鐃緒申
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾居申鐃緒申鐃叔推奨鐃緒申鐃緒申討鐃緒申鐃緒申鐃緒申鐃祝つわ申鐃銃わ申同鐃春わ申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃藷。私が鐃巡奨鐃緒申鐃緒申鐃緒申鐃緒申箸鐃緒申鐃緒申鐃粛鰹申鐃緒申鐃盾し鐃銃わ申鐃緒申鐃緒申鐃緒申鐃夙思わ申鐃殉わ申鐃緒申
Limit ConnMaxLifetime instead of MaxIdleConns
Allowing just 1 idle connection to be retained and reused makes a massive difference to this particular benchmark — it cuts the average runtime by about 8 times and reduces memory usage by about 20 times. Going on to increase the size of the idle connection pool makes the performance even better, although the improvements are less pronounced.
鐃緒申鐃塾￥申 "to this particular benchmark" 鐃夙わ申鐃緒申鐃塾わ申鐃緒申鐃緒申任鐃緒申鐃緒申鐃緒申離戰鐃緒申鐃殉￥申鐃緒申鐃叔は￥申8鐃緒申鐃緒申脳鐃緒申DB鐃祝ワ申鐃緒申鐃緒申鐃緒申蠅佳鰹申鐃緒申討鐃緒申泙鐃緒申鐃�1鐃縦のワ申鐃緒申鐃所が鐃緒申了鐃緒申鐃緒申箸鐃緒申鐃緒申房鐃緒申離鐃緒申鐃緒申鐃緒申鐃所げ鐃緒申里如鐃� DB.SetMaxIdleConns(1) 鐃緒申鐃順き鐃淑醐申鐃縮わ申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃�
鐃緒申鐃塾ベワ申鐃緒申沺鐃緒申鐃緒申鐃銃逸申鐃熟￥申鐃純え鐃緒申DB鐃緒申鐃緒申鐃縮のデ￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申丱奪鐃緒申鐃緒申鐃緒申覆匹鐃緒申鐃緒申討呂泙鐃殉わ申鐃緒申鐃緒申Web 鐃緒申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃淑どにわ申鐃緒申鐃銃はまわ申泙鐃緒申鐃�
1鐃獣間わ申1000鐃藷クワ申鐃緒申鐃渋行わ申鐃暑ア鐃竣リケ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃所し鐃緒申鐃緒申単鐃淑ワ申鐃淳ワ申譟種申鐃緒申鐃書いてみまわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申楼鐃緒申鐃淑�鐃循でワ申鐃緒申鐃緒申淵鐃緒申鐃緒申潺鵐阿納孫圓鐃緒申譟�鐃銃ワ申鐃緒申鐃緒申反鐃緒申鐃緒申鐃渋鰹申砲鐃�10ms鐃緒申鐃緒申鐃緒申箸鐃緒申泙鐃緒申鐃� (鐃緒申鐃塾ワ申鐃淳ワ申譟種申鐃緒申鐃�gist)
MaxOpenConns(20) 鐃塾誌申鐃緒申 MaxIdleConns(4) 鐃緒申 MaxIdleConns(10) 鐃緒申動鐃緒申鐃緒申鐃駿てみまわ申鐃順う鐃緒申鐃緒申鐃緒申鵐犬鐃緒申鐃緒申鐃緒申鐃緒申鐃渋鰹申鐃緒申鐃緒申弔鐃緒申鐃緒申六鐃緒申鐃緒申鐃緒申鐃緒申続鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申鐃緒申続鐃緒申鐃緒申鐃術駕申能鐃祝なわ申里鐃緒申圓辰討鐃緒申鐃緒申鐃瞬の削申鐃緒申鐃粛わ申潺鐃緒申辰鐃宿緒申鐃緒申討鐃緒申泙鐃緒申鐃�
1000鐃緒申離鐃緒申鐃緒申鐃緒申孫圓鐃緒申鐃塾に￥申 MaxIdleConns(4) 鐃緒申鐃緒申 285 鐃緒申鐃緒申続鐃緒申鐃銃わ申鐃殉わ申鐃緒申鐃緒申 MaxIdleConns(10) 鐃緒申鐃夙わ申鐃緒申鐃� 69 鐃緒申泙埜鐃緒申蕕刻申鐃緒申箸鐃緒申任鐃緒申討鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申如鐃緒申鐃駿わ申鐃淳まっわ申鐃緒申發削申辰醗飮鐃緒申鐃渋鰹申鐃緒申鐃緒申鐃渋鰹申鐃緒申鐃緒申鐃緒申討鐃緒申泙辰討鐃緒申泙鐃緒申鐃�
鐃緒申鐃駿わ申 SetMaxIdleConns(100); SetConnMaxLifetime(time.MilliSecond * 300) 鐃塾ワ申鐃淳ワ申譟種申鐃緒申鐃緒申鐃縮を見てわ申鐃緒申鐃緒申鐃緒申鐃緒申
20x4=80 鐃緒申鐃緒申鐃渋鰹申鬚靴討鐃緒申泙鐃緒申鐃� MaxIdleConns(10) 鐃塾とわ申鐃緒申 69 鐃緒申鐃緒申鐃渋随申鐃緒申任鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申動鐃緒申鐃緒か鐃緒申笋刻申鐃緒申鐃緒申襪随申鐃緒申 lifetime 鐃緒申短鐃緒申鐃緒申鐃所し鐃銃わ申鐃暑た鐃緒申任鐃緒申鐃緒申鐃緒申潺鐃曙ー鐃緒申鐃緒申鐃緒申鐃瞬わ申100鐃獣に随申鐃出わ申鐃緒申鐃初、MaxIdleConns(10) 鐃塾常申鐃叔わ申鐃緒申続鐃緒申鐃緒申呂鐃緒申茲� 690 鐃緒申砲覆蝓� SetConnMaxLifetime(time.Second * 30) 鐃塾常申鐃緒申鐃緒申続鐃緒申鐃緒申鐃� 80 鐃緒申砲覆鐃叔わ申鐃順う鐃緒申
鐃緒申鐃塾ワ申鐃緒申佞如鐃緒申鐃緒申鐃渋鰹申鐃緒申鐃緒申鐃塾ワ申鐃緒申鐃淳ングに緒申鐃醇し鐃緒申鐃緒申鐃塾ワ申鐃緒申鐃淳ングでレイ鐃銃ンシわ申鐃緒申鐃俊てわ申鐃殉ってわ申鐃緒申里鐃緒申鐃緒申砲覆襪�鐃盾し鐃緒申泙鐃緒申鵝�わ申鐃緒申魯鐃緒申潺鐃曙ー鐃緒申鐃緒申鵑�器申鐃緒申鐃祝逸申鐃緒申分鐃循になってわ申鐃銃￥申鐃叔緒申鐃緒申鐃緒申討鐃緒申鐃渋鰹申鐃緒申曚鐃銃縁申鐃緒申忘鐃緒申鐃銃わ申鐃殉ってわ申鐃暑か鐃緒申任鐃緒申鐃緒申鐃緒申屬砲鐃獣わ申鐃緒申戮鐃緒申鐃銃逸申鐃緒申襯�鐃竣リケ鐃緒申鐃緒申鐃緒申鐃叔は￥申鐃緒申続鐃緒申鐃緒申鐃緒申襯随申鐃緒申潺鵐阿鐃緒申鐃獣わ申分鐃緒申鐃緒申鐃緒申里如鐃緒申鐃緒申離鐃緒申僖鐃緒申鐃緒申鐃夙�鐃緒申鐃緒申鐃祝わ申鐃緒申鐃熟わ申鐃叔わ申鐃緒申鐃緒申鐃塾ワ申鐃緒申佞蓮鐃�200ms鐃緒申鐃緒申鐃緒申鐃淑鰹申的鐃緒申鐃緒申戮鐃緒申鐃緒申鐃緒申鐃緒申鐃祝￥申鐃緒申離鐃緒申鐃春わ申同鐃緒申1000ms鐃緒申鐃緒申戮鐃緒申鐃緒申鐃緒申辰鐃緒申箸鐃緒申里鐃塾でわ申鐃緒申
SetConnMaxLifetime 鐃緒申箸鐃渋常申鐃緒申鐃粛�
DB.SetConnMaxLifetime() 鐃緒申鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申里六鐃叔わ申鐃緒申鐃緒申鐃緒申API鐃熟ワ申鐃緒申鐃宿ワ申鐃緒申鐃渋鰹申鮓困蕕� SetMaxIdleConns() 鐃緒申鐃緒申鐃宿わ申鐃緒申法鐃叔わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申任呂鐃緒申鐃殉わ申鐃緒申
"Configuring sql.DB for Better Performance" 鐃叔紹介された鐃夙わ申鐃所、 MySQL 鐃叔わ申 wait_timeout 鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃渋鰹申鐃緒申鐃緒申鐃緒申弌鐃緒申鐃緒申鐃緒申擇鐃緒申覿駕申譴�鐃緒申鐃緒申泙鐃緒申鐃緒申泙鐃緒申鐃�OS鐃緒申襦種申鐃緒申鐃緒申鐃縦刻申鐃緒申鐃緒申鐃緒申僂鐃緒申鐃銃わ申鐃淑わ申TCP鐃緒申続鐃緒申鐃緒申鐃叔わ申鐃暑こ鐃夙もあ鐃緒申泙鐃緒申鐃緒申匹離鐃緒申鐃緒申鐃緒申任癲� go-sql-driver/mysql 鐃熟ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申紂�鐃曙ス鐃楯ンスわ申鐃緒申鐃緒申鐃緒申茲�鐃夙わ申鐃銃緒申鐃緒申TCP鐃緒申鐃緒申鐃叔わ申鐃曙た鐃緒申鐃夙わ申鐃塾わ申泙鐃緒申鐃緒申鐃緒申任鐃緒申里鐃緒申鐃塾に駕申鐃緒申鐃獣もか鐃緒申鐃暑か鐃盾し鐃緒申泙鐃緒申鵑掘鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申蠅�鐃渋行わ申鐃曙た鐃緒申鐃宿わ申鐃緒申鐃緒申鐃塾るこ鐃夙わ申任鐃緒申覆鐃緒申里念鐃緒申鐃緒申淵鐃夙ライ鐃緒申任鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃獣わ申鐃緒申鐃緒申鐃緒申覆鐃駿わ申鐃薯けるた鐃緒申砲蓮鐃縦刻申鐃緒申峪箸鐃緒申討鐃緒申覆鐃緒申辰鐃緒申鐃渋鰹申鐃緒申鐃緒申鐃術わ申鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申続鐃緒申箸鐃緒申戮鐃緒申任鐃緒申鐃� SetConnMaxLifetime() 鐃緒申鐃緒申続鐃塾種申命鐃緒申鐃緒申鐃所す鐃緒申API鐃叔わ申鐃緒申鐃緒申鐃緒申命鐃緒申10鐃獣わ申鐃緒申鐃所し鐃銃わ申鐃緒申鐃出￥申10鐃獣使わ申鐃銃わ申鐃淑わ申鐃獣わ申鐃緒申続鐃緒申鐃緒申鐃緒申僂鐃緒申襪鰹申箸發�鐃緒申泙鐃緒申鐃�
鐃緒申続鐃塾種申命鐃緒申鐃緒申鐃所す鐃暑こ鐃夙で￥申他鐃祝わ申鐃緒申弔鐃緒申鐃緒申鐃緒申鐃緒申鐃出処す鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申
- DB鐃緒申鐃緒申鐃出￥申鐃緒申鐃緒申鐃緒申鐃宿バワ申鵐垢鐃緒申鐃銃わ申鐃緒申箸鐃緒申鐃緒申鐃緒申鐃緒申弌鐃緒申鐃緒申鐃緒申鐃緒申鬚靴笋刻申鐃緒申鐃緒申鐃�
- DB鐃緒申鐃緒申鐃出￥申鐃塾フワ申鐃緒申鐃暑オ鐃緒申鐃出￥申鐃薯しやす鐃緒申鐃緒申鐃緒申
- MySQL 鐃叔ワ申鐃緒申薀わ申鐃緒申鐃緒申鐃緒申鐃術刻申鐃緒申鐃緒申鐃夙わ申鐃緒申鐃重わ申鐃緒申鐃緒申鐃銃逸申遒刻申襯鰹申優鐃緒申鐃緒申鐃藷が残わ申続鐃緒申鐃淑わ申鐃処う鐃祝わ申鐃緒申
鐃緒申続鐃塾ワ申鐃緒申鐃宿ワ申鐃緒申屬鐃緒申鐃緒申造鐃緒申鐃�API鐃緒申鐃縮わ申鐃宿加わ申鐃淑わ申鐃獣わ申鐃塾は￥申鐃緒申鐃緒申的鐃淑環駈申鐃祝わ申鐃緒申鐃緒申鐃緒申能鐃舜の影駈申鐃夙￥申 sql.DB 鐃塾種申鐃緒申鐃緒申複鐃緒申鐃緒申鐃緒申天鐃緒申砲鐃緒申鐃緒申鐃緒申鐃縮でわ申鐃緒申
鐃巡奨鐃緒申鐃緒申 sql.DB 鐃緒申鐃緒申鐃緒申
- SetMaxOpenConns() 鐃緒申必鐃緒申鐃緒申鐃所す鐃暑。鐃緒申戮鐃緒申發�鐃淑っわ申DB鐃塾縁申鐃緒申鐃緒申鐃駿わ申鐃淑っわ申鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申続鐃緒申鐃銃わ申鐃緒申縫鐃緒申鐃緒申鐃緒申鐃所げ鐃淑わ申鐃処う鐃祝わ申鐃暑た鐃潤。鐃叔わ申鐃緒申鐃緒申鐃駿試験鐃薯して削申鐃緒申離鐃緒申襦種申廛奪箸鐃夙�鐃緒申鐃緒申鐃緒申鐃緒申鐃渋のワ申鐃粛ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃所す鐃緒申里鐃緒申匹鐃緒申鐃緒申鐃緒申鐃駿試験鐃緒申任鐃緒申覆鐃緒申鐃緒申鐃�
max_connection鐃巡コ鐃緒申鐃緒申鐃緒申鐃初あ鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃粛わ申判鐃叔わ申鐃緒申戮鐃緒申鐃� - SetMaxIdleConns() 鐃緒申 SetMaxOpenConns() 鐃淑常申鐃緒申鐃緒申蠅刻申襦ｏ申鐃緒申鐃緒申疋鐃緒申鐃緒申続鐃塾駕申鐃緒申鐃緒申 SetConnMaxLifetime 鐃緒申任鐃緒申鐃暑。
- SetConnMaxLifetime() 鐃熟削申鐃緒申鐃緒申続鐃緒申 鐃緒申 1鐃緒申 鐃緒申鐃駿わ申鐃緒申鐃所す鐃暑。多鐃緒申鐃塾環駈申鐃緒申1鐃獣わ申1鐃緒申鐃緒申続鐃緒申鐃緒申鐃緒申鐃駿わ申鐃緒申戮鐃緒申鐃緒申鐃祝なわ申覆鐃緒申鐃�1鐃緒申鐃瞬以常申鐃緒申鐃緒申蠅件申鐃緒申鐃緒申鐃緒申魯鐃緒申鐃春ラ／鐃粛ットワー鐃緒申鐃緒申鐃藷ジニワ申鐃祝よく鐃緒申鐃縮わ申鐃暑こ鐃夙￥申
@methane
