鐭俊涓枔浠舵牳蹇冨湪浜庝腑闁撳堡锛屾妸寰�(f霉)闆滅殑搴曞堡鎿嶄綔杞�(zhu菐n)鎻涚偤绨″柈銆佹柟渚跨殑鏁�(sh霉)鎿�(j霉)搴搷浣�銆傝粺浠惰ō(sh猫)瑷堢偤寰炲鎴剁殑鏁�(sh霉)鎿�(j霉)搴嚜鍕曞畾鏅傛彁鍙栨暩(sh霉)鎿�(j霉)鐧�(f膩)閫併€備腑闁撲欢闇€瑕佸拰鐢ㄦ埗鐨勬噳(y墨ng)鐢ㄧ▼搴忓叡浜娇鐢ㄦ暩(sh霉)鎿�(j霉)搴�锛岄€欏氨瑕佹眰涓枔浠惰í鍟忔暩(sh霉)鎿�(j霉)搴棦瑕佸揩锛屽張涓嶈兘褰遍熆鏁�(sh霉)鎿�(j霉)搴殑鎬ц兘銆傛暩(sh霉)鎿�(j霉)搴€ｆ帴姹犳槸蹇呬笉鍙皯鐨勩€�

鏁�(sh霉)鎿�(j霉)搴€ｆ帴姹犲氨鏄竴鍊嬫睜瀛�锛岄噷闈㈡斁钁楁暩(sh霉)鎿�(j霉)搴€ｆ帴锛屾噳(y墨ng)鐢ㄦ湇鍕�(w霉)闇€瑕佺殑鏅傚€欏氨鍘绘睜瀛愰噷闈㈡嬁锛岀敤瀹屼箣鍚庢閭勭郸姹犲瓙銆傛暩(sh霉)鎿�(j霉)搴€ｆ帴姹犺矤璨�(z茅)鍒嗛厤銆佺鐞�銆侀噵鏀炬暩(sh霉)鎿�(j霉)搴€ｆ帴锛屽畠鍏佽ū鎳�(y墨ng)鐢ㄦ湇鍕�(w霉)閲嶅京(f霉)浣跨敤鏁�(sh霉)鎿�(j霉)搴€ｆ帴锛岃€岄潪閲嶆柊寤虹珛銆傛暩(sh霉)鎿�(j霉)搴殑閫ｆ帴鍓�(chu脿ng)寤哄拰闂�(gu膩n)闁夐€ｆ帴鍧囩敱閫ｆ帴姹犱締瀵︾従(xi脿n)銆傛噳(y墨ng)鐢ㄨí鍟忔檪锛岄鍏堟煡鐪嬮€ｆ帴姹犱腑鏄惁鏈夌┖闁戦€ｆ帴锛屽鏋滃瓨鍦ㄧ┖闁戦€ｆ帴锛屽墖灏囬€ｆ帴鍒嗛厤绲﹀鎴朵娇鐢紱濡傛灉娌掓湁绌洪枒閫ｆ帴锛屽墖鏌ョ湅鐣�(d膩ng)鍓嶆墍闁嬬殑閫ｆ帴鏁�(sh霉)鏄惁宸茬稉(j墨ng)閬斿埌鏈€澶ч€ｆ帴鏁�(sh霉)锛屽鏋滄矑閬斿埌灏遍噸鏂板壍(chu脿ng)寤轰竴鍊嬮€ｆ帴绲﹁珛姹傜殑瀹㈡埗锛涘鏋滈仈鍒板氨鎸夎ō(sh猫)瀹氱殑鏈€澶х瓑寰呮檪闁撻€茶绛夊緟锛屽鏋滆秴鍑烘渶澶х瓑寰呮檪闁擄紝鍓囨媼鍑虹暟甯哥郸瀹㈡埗銆� 鐣�(d膩ng)瀹㈡埗閲嬫斁鏁�(sh霉)鎿�(j霉)搴€ｆ帴鏅傦紝鍏堝垽鏂疯┎閫ｆ帴鐨勫紩鐢ㄦ鏁�(sh霉)鏄惁瓒呴亷浜嗚(gu墨)瀹氬€�锛屽鏋滆秴閬庡氨寰為€ｆ帴姹犱腑鍒櫎瑭查€ｆ帴锛屽惁鍓囦繚鐣欑瓑寰呭啀娆′娇鐢�銆�

濡傛灉涓嶄娇鐢ㄦ暩(sh霉)鎿�(j霉)搴€ｆ帴姹�锛岄€茶涓€娆℃煡瑭�锛岃閫茶寰堝娆＄恫(w菐ng)绲�(lu貌)浜や簰锛屽彲浠ョ湅鍒帮紝閫欐ǎ鐨勭己榛炴槸锛�

1. 缍�(w菐ng)绲�(lu貌)IO澶�

2. 闊挎噳(y墨ng)鏅傞枔闀�锛屽皫(d菐o)鑷碤PS闄嶄綆

3. 闋荤箒鍓�(chu脿ng)寤洪€ｆ帴鍜岄棞(gu膩n)闁夐€ｆ帴锛屾氮璨绘暩(sh霉)鎿�(j霉)搴硣婧�锛屽奖闊挎湇鍕�(w霉)鍣ㄦ€ц兘

浣跨敤閫ｆ帴姹犵殑濂借檿锛�

1. 娓涘皯缍�(w菐ng)绲�(lu貌)闁嬮姺

2. 鎻愬崌鏁�(sh霉)鎿�(j霉)搴€ц兘

閲戠瑳鐭俊涓枔浠跺皪閫ｆ帴姹犳湁2鍊嬭姹傦細涓€瑕佸揩锛屼簩瑕佺┅(w臎n)銆傜洰鍓�锛屾祦琛岀殑Java鏁�(sh霉)鎿�(j霉)搴€ｆ帴姹犳湁dbcp锛宒ruid锛孒ikariCP锛宼omcat-jdbc锛宑3p0銆傚湪灏嶆墍鏈夋祦琛岀殑閫ｆ帴姹犻€茶閫愪竴姣旇純涔嬪悗锛屽柈寰炴€ц兘瑙掑害鐪�锛屾€ц兘寰為珮鍒颁綆鍒嗗垾鏄細HikariCP锛宒ruid锛宼omcat-jdbc锛宒bcp锛宑3p0 銆�

闂�(gu膩n)浜嶩ikariCP鍜宒ruid鐨勬€ц兘灏嶆瘮锛屽湪github/HikariCP涓婃湁閬庤◣璜栵紝绲�(ji茅)鏋滄槸HikariCP鎬ц兘涓婂劒(y艒u)浜巇ruid锛屽悆鐡滃湴鍧€锛歨ttps://github.com/brettwooldridge/HikariCP/issues/232

HikariCP 鑴⿴鑰屽嚭锛岀鍚堥噾绗涚煭淇′腑闁撲欢鐭俊瑕佹眰鏃㈣蹇�锛屽張瑕佺┅(w臎n)鐨勮姹�銆傜煭淇″緸鎻愬彇鍒扮櫦(f膩)閫侊紝鍦ㄦ暩(sh霉)鎿�(j霉)搴€欏€嬬挵(hu谩n)绡€(ji茅)锛屾妸鏅傞枔澹撶府鍒版绉掑収(n猫i)锛屽彧鏈夌煭淇＄櫦(f膩)閫佺殑姣忓€嬬挵(hu谩n)绡€(ji茅)閮芥Θ骞�锛屾墠鑳戒繚璀夋渶绲傜煭淇＄櫦(f膩)閫佺鍒�銆�

鍚勭ó瑭曟脯灏嶆瘮锛屼篃瑾槑HikariCP鏄洰鍓嶆渶蹇殑Java鏁�(sh霉)鎿�(j霉)搴€ｆ帴姹狅紝spring boot 2.x宸茬稉(j墨ng)浣跨敤HikariCP浣滅偤榛樿獚鐨勬暩(sh霉)鎿�(j霉)搴€ｆ帴姹�锛岃冻瑕嬪叾鍎�(y艒u)绉€?锛熷仦顚僡閲忥細浠ｇ⒓楂旂⿳鏇存槸灏戠殑鍙啇锛�130kb銆備唬纰奸噺瓒婂皯锛屼竴鑸剰鍛宠憲鍩�(zh铆)琛屾晥鐜囪秺楂�銆佺櫦(f膩)鐢焍ug鐨勫彲鑳芥€ц秺浣�銆傜啊鍠剰鍛宠憲鍙潬锛屽ソ缍锛屽吋瀹规€уソ銆�

鏁�(sh霉)鎿�(j霉)搴€ｆ帴姹狅紝鍦�20骞翠互鍓嶅氨鏈夈€傜稉(j墨ng)閬�20骞寸殑閫插寲锛屽凡缍�(j墨ng)闈炲父鐘€鍒�銆傛棩鏈汉绱犱締浠ュ伐鍖犵簿绁炶憲绋�锛屼竴鍊嬩汉涓€杓╁瓙灏卞仛濂戒竴浠朵簨銆侶ikariCP鏄棩鏈汉鍦╞oneCP鍩虹(ch菙)涓�锛屾妸鍎�(y艒u)鍖栧仛鍒颁簡妤佃嚧锛氱偤浠€涔堥€欎箞瑾憿?

1. 鍎�(y艒u)鍖栧苟绮剧啊瀛楃瘈(ji茅)纰�锛屽劒(y艒u)鍖栦唬纰�锛岀洿鍒扮法璀悗鐨勫瓧绡€(ji茅)纰兼渶灏�锛岄€欐ǎ锛孋PU绶╁瓨鍙互鍔犺級鏇村鐨勭▼搴忎唬纰�銆備娇鐢↗ava瀛楃瘈(ji茅)纰间慨鏀归搴獼avassist渚嗙敓鎴愬鎵樺鐝�(xi脿n)鍕曟厠(t脿i)浠ｇ悊锛孞DK Proxy鐢熸垚鐨勫瓧绡€(ji茅)纰兼洿灏戙€備緥濡侶ikariCP鐨凷tatement proxy鍙湁100琛屼唬纰�锛屽彧鏈塀oneCP鐨勫崄鍒嗕箣涓€锛屽皪绶ㄨ鍣ㄤ笉婊挎剰锛屽氨宸噸瀵玧ava绶ㄨ鍣ㄤ簡銆�

2. 瀹氱京闆嗗悎椤炲瀷锛圕oncurrentBag锛夛細鎻愰珮骞剁櫦(f膩)璁€瀵殑鏁堢巼銆�

3. 鑷畾缇╂暩(sh霉)绲勯鍨嬶紙FastStatementList锛変唬鏇緼rrayList锛氶伩鍏嶆瘡娆et()瑾�(di脿o)鐢ㄩ兘瑕侀€茶range check锛岄伩鍏嶈(di脿o)鐢╮emove()鏅傜殑寰為牠鍒板熬鐨勬巸鎻�銆�

4. 鍏朵粬閲濆皪BoneCP缂洪櫡鐨勫劒(y艒u)鍖�锛屾瘮濡傚皪浜庤€楁檪瓒呴亷涓€鍊婥PU鏅傞枔鐗囩殑鍎�(y艒u)鍖栥€�

鍏夐€�锛屾瘡绉�30钀叕閲�銆傛矑鏈夋瘮鍏夐€熸洿蹇殑浜�銆侶ikariCP 锛屽氨鏄厜閫�銆�

鏈憲geek绮剧锛屽湪鍙潬鎬ф柟闈�锛岀辜绾�(x霉)鐮旂┒銆傚皪浜庢暩(sh霉)鎿�(j霉)搴€ｆ帴涓柗鐨勬儏娉�锛岄€氶亷娓│getConnection()锛屽悇绋瓹P鐨勪笉鐩稿悓铏曠悊鏂规硶濡備笅锛�

锛堟墍鏈塁P閮介厤缃簡璺焎onnectionTimeout椤炰技鐨勫弮鏁�(sh霉)鐐�5绉掗悩锛�

HikariCP锛氱瓑寰�5绉掗悩鍚�锛屽鏋滈€ｆ帴閭勬槸娌掓湁鎭㈠京(f霉)锛屽墖鎷嬪嚭涓€鍊婼QLExceptions 鐣板父锛涘悗绾�(x霉)鐨刧etConnection()涔熸槸涓€妯ｈ檿鐞�锛�

C3P0锛氬畬鍏ㄦ矑鏈夊弽鎳�(y墨ng)锛屾矑鏈夋彁绀猴紝涔熶笉鏈冨湪鈥淐heckoutTimeout鈥濋厤缃殑鏅傞暦瓒呮檪鍚庢湁浠讳綍閫氱煡绲﹁(di脿o)鐢ㄨ€�锛涚劧鍚庣瓑寰�2鍒嗛悩鍚庣祩浜庨啋渚嗕簡锛岃繑鍥炰竴鍊媏rror锛�

Tomcat锛氳繑鍥炰竴鍊媍onnection锛岀劧鍚庘€︹€﹁(di脿o)鐢ㄨ€呭鏋滃埄鐢ㄩ€欏€嬬劇鏁堢殑connection鍩�(zh铆)琛孲QL瑾炲彞鈥︹€︾祼(ji茅)鏋滃彲鎯宠€岀煡锛涘ぇ绱�55绉掍箣鍚庣祩浜庨啋渚嗕簡锛岄€欐檪鍊欑殑getConnection()绲備簬鍙互杩斿洖涓€鍊媏rror锛屼絾娌掓湁绛夊緟鍙冩暩(sh霉)閰嶇疆鐨�5绉掗悩锛岃€屾槸绔嬪嵆杩斿洖error锛�

BoneCP锛氳窡Tomcat鐨勮檿鐞嗘柟娉曚竴妯�锛涗篃鏄ぇ绱�55绉掍箣鍚庢墠閱掍締锛屾湁浜嗘甯哥殑鍙嶆噳(y墨ng)锛屽苟涓旂祩浜庢渻绛夊緟5绉掗悩涔嬪悗杩斿洖error浜�锛�

涔熷氨鏄湪鏁�(sh霉)鎿�(j霉)搴€ｆ帴涓柗鐨勬儏娉佷笅锛孒ikariCP鍦�5绉掑収(n猫i)灏卞彲浠ユ劅鐭ワ紝骞跺湪鏈€鐭檪闁撳収(n猫i)閫氱煡涓婂堡鎳�(y墨ng)鐢�銆傞€欏€嬮熆鎳�(y墨ng)澶犲揩锛屽鍙婃檪銆傚闅涙脯瑭︿腑锛屽氨鏄嫈缍�(w菐ng)绶氾紝绛夊崐鍒嗛悩鍐嶆彃涓�锛岀湅瑾版渶鍏堟仮寰�(f霉)鏁�(sh霉)鎿�(j霉)搴€ｆ帴銆侶ikariCP 鍙堝嫕鍑�銆�

閲戠瑳鐭俊涓枔浠禬EB鐗堥泦鎴愬厜閫熸暩(sh霉)鎿�(j霉)搴€ｆ帴姹狅紝鍦ㄥ悇绋暩(sh霉)鎿�(j霉)搴挵(hu谩n)澧冧笅琛ㄧ従(xi脿n)鐣板父绌�(w臎n)瀹�銆傛湁鐨勫鎴跺湪灞€鍩熺恫(w菐ng)閫ｆ帴闃块噷浜戜富姗熸暩(sh霉)鎿�(j霉)搴洜鐐轰笉鏄庡師鍥�锛岄枔姝囨€ф柗缍�(w菐ng)鐨勬儏娉�锛屼篃娌掓湁褰遍熆鐭俊鐧�(f膩)閫�銆傚娓敮鎸丼QLServer銆丱racle銆丮ySQL锛屾敮鎸亀in鍜宭inux鍚勫€嬬増鏈�銆�