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

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

濡傛灉涓嶄娇鐢ㄦ暩(sh霉)鎿�(j霉)搴€ｆ帴姹狅紝閫�(j矛n)琛屼竴娆℃煡瑭�锛岃閫�(j矛n)琛屽緢澶氭缍�(w菐ng)绲�(lu貌)浜や簰锛屽彲浠ョ湅鍒�锛岄€欐ǎ鐨勭己榛�(di菐n)鏄細

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

2. 闊挎噳(y墨ng)鏅�(sh铆)闁撻暦锛屽皫(d菐o)鑷碤PS闄嶄綆

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

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

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

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

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

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

HikariCP 鑴⿴鑰屽嚭锛岀鍚堥噾绗涚煭淇′腑闁撲欢鐭俊瑕佹眰鏃㈣蹇�锛屽張瑕佺┅(w臎n)鐨勮姹傘€傜煭淇″緸鎻愬彇鍒扮櫦(f膩)閫�锛屽湪鏁�(sh霉)鎿�(j霉)搴€欏€�(g猫)鐠�(hu谩n)绡€(ji茅)锛屾妸鏅�(sh铆)闁撳绺埌姣鍏�(n猫i)锛屽彧鏈夌煭淇＄櫦(f膩)閫佺殑姣忓€�(g猫)鐠�(hu谩n)绡€(ji茅)閮芥Θ骞�锛屾墠鑳戒繚璀夋渶绲傜煭淇＄櫦(f膩)閫佺鍒�銆�

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

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

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

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

3. 鑷畾缇╂暩(sh霉)绲勯鍨嬶紙FastStatementList锛変唬鏇緼rrayList锛氶伩鍏嶆瘡娆et()瑾�(di脿o)鐢ㄩ兘瑕侀€�(j矛n)琛宺ange check锛岄伩鍏嶈(di脿o)鐢╮emove()鏅�(sh铆)鐨勫緸闋埌灏剧殑鎺冩弿銆�

4. 鍏朵粬閲濆皪(du矛)BoneCP缂洪櫡鐨勫劒(y艒u)鍖�锛屾瘮濡傚皪(du矛)浜庤€楁檪(sh铆)瓒呴亷涓€鍊�(g猫)CPU鏅�(sh铆)闁撶墖鐨勫劒(y艒u)鍖�銆�

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

鏈憲geek绮剧锛屽湪鍙潬鎬ф柟闈紝绻肩簩(x霉)鐮旂┒銆傚皪(du矛)浜庢暩(sh霉)鎿�(j霉)搴€ｆ帴涓柗鐨勬儏娉侊紝閫氶亷娓�(c猫)瑭etConnection()锛屽悇绋瓹P鐨勪笉鐩稿悓铏曠悊鏂规硶濡備笅锛�

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

HikariCP锛氱瓑寰�5绉掗悩鍚庯紝濡傛灉閫ｆ帴閭勬槸娌掓湁鎭㈠京(f霉)锛屽墖鎷嬪嚭涓€鍊�(g猫)SQLExceptions 鐣板父锛涘悗绾�(x霉)鐨刧etConnection()涔熸槸涓€妯ｈ檿鐞�锛�

C3P0锛氬畬鍏ㄦ矑鏈夊弽鎳�(y墨ng)锛屾矑鏈夋彁绀�锛屼篃涓嶆渻(hu矛)鍦ㄢ€淐heckoutTimeout鈥濋厤缃殑鏅�(sh铆)闀疯秴鏅�(sh铆)鍚庢湁浠讳綍閫氱煡绲﹁(di脿o)鐢ㄨ€咃紱鐒跺悗绛夊緟2鍒嗛悩鍚庣祩浜庨啋渚嗕簡锛岃繑鍥炰竴鍊�(g猫)error锛�

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

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

涔熷氨鏄湪鏁�(sh霉)鎿�(j霉)搴€ｆ帴涓柗鐨勬儏娉佷笅锛孒ikariCP鍦�5绉掑収(n猫i)灏卞彲浠ユ劅鐭ワ紝骞跺湪鏈€鐭檪(sh铆)闁撳収(n猫i)閫氱煡涓婂堡鎳�(y墨ng)鐢�銆傞€欏€�(g猫)闊挎噳(y墨ng)澶犲揩锛屽鍙婃檪(sh铆)銆傚(sh铆)闅涙脯(c猫)瑭︿腑锛屽氨鏄嫈缍�(w菐ng)绶�锛岀瓑鍗婂垎閻樺啀鎻掍笂锛岀湅瑾版渶鍏堟仮寰�(f霉)鏁�(sh霉)鎿�(j霉)搴€ｆ帴銆侶ikariCP 鍙堝嫕鍑恒€�

閲戠瑳鐭俊涓枔浠禬EB鐗堥泦鎴愬厜閫熸暩(sh霉)鎿�(j霉)搴€ｆ帴姹�锛屽湪鍚勭ó鏁�(sh霉)鎿�(j霉)搴挵(hu谩n)澧冧笅琛ㄧ従(xi脿n)鐣板父绌�(w臎n)瀹�銆傛湁鐨勫鎴跺湪灞€鍩熺恫(w菐ng)閫ｆ帴闃块噷浜戜富姗�(j墨)鏁�(sh霉)鎿�(j霉)搴洜?y脿n)妞村够楂燁厠?锛岄枔姝囨€ф柗缍�(w菐ng)鐨勬儏娉侊紝涔熸矑鏈夊奖闊跨煭淇＄櫦(f膩)閫�銆傚(sh铆)娓�(c猫)鏀寔SQLServer銆丱racle銆丮ySQL锛屾敮鎸亀in鍜宭inux鍚勫€�(g猫)鐗堟湰銆�