鐭俊涓枔浠舵牳蹇冨湪浜庝腑闁撳堡锛屾妸寰╅洔鐨勫簳灞ゆ搷浣滆綁鎻涚偤绨″柈銆佹柟渚跨殑鏁�(sh霉)鎿氬韩鎿嶄綔銆傝粺浠惰ō瑷堢偤寰炲鎴剁殑鏁�(sh霉)鎿氬韩鑷嫊瀹氭檪鎻愬彇鏁�(sh霉)鎿氱櫦(f膩)閫�銆備腑闁撲欢闇€瑕佸拰鐢ㄦ埗鐨勬噳鐢ㄧ▼搴忓叡浜娇鐢ㄦ暩(sh霉)鎿氬韩锛岄€欏氨瑕佹眰涓枔浠惰í鍟忔暩(sh霉)鎿氬韩鏃㈣蹇�锛屽張涓嶈兘褰遍熆鏁�(sh霉)鎿氬韩鐨勬€ц兘銆傛暩(sh霉)鎿氬韩閫ｆ帴姹犳槸蹇呬笉鍙皯鐨�銆�

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

濡傛灉涓嶄娇鐢ㄦ暩(sh霉)鎿氬韩閫ｆ帴姹�锛岄€茶涓€娆℃煡瑭�锛岃閫茶寰堝娆＄恫绲′氦浜�锛屽彲浠ョ湅鍒�锛岄€欐ǎ鐨勭己榛炴槸锛�

1. 缍茬怠IO澶�

2. 闊挎噳鏅傞枔闀�锛屽皫鑷碤PS闄嶄綆

3. 闋荤箒鍓�(chu脿ng)寤洪€ｆ帴鍜岄棞闁夐€ｆ帴锛屾氮璨绘暩(sh霉)鎿氬韩璩囨簮锛屽奖闊挎湇鍕欏櫒鎬ц兘

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

1. 娓涘皯缍茬怠闁嬮姺

2. 鎻愬崌鏁�(sh霉)鎿氬韩鎬ц兘

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

闂滀簬HikariCP鍜宒ruid鐨勬€ц兘灏嶆瘮锛屽湪github/HikariCP涓婃湁閬庤◣璜栵紝绲愭灉鏄疕ikariCP鎬ц兘涓婂劒(y艒u)浜巇ruid锛屽悆鐡滃湴鍧€锛歨ttps://github.com/brettwooldridge/HikariCP/issues/232

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

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

鏁�(sh霉)鎿氬韩閫ｆ帴姹�锛屽湪20骞翠互鍓嶅氨鏈�銆傜稉閬�20骞寸殑閫插寲锛屽凡缍撻潪甯哥妧鍒�銆傛棩鏈汉绱犱締浠ュ伐鍖犵簿绁炶憲绋憋紝涓€鍊嬩汉涓€杓╁瓙灏卞仛濂戒竴浠朵簨銆侶ikariCP鏄棩鏈汉鍦╞oneCP鍩虹涓�锛屾妸鍎�(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()瑾跨敤閮借閫茶range check锛岄伩鍏嶈鐢╮emove()鏅傜殑寰為牠鍒板熬鐨勬巸鎻�銆�

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

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

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

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

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

C3P0锛氬畬鍏ㄦ矑鏈夊弽鎳�锛屾矑鏈夋彁绀�锛屼篃涓嶆渻鍦ㄢ€淐heckoutTimeout鈥濋厤缃殑鏅傞暦瓒呮檪鍚庢湁浠讳綍閫氱煡绲﹁鐢ㄨ€�锛涚劧鍚庣瓑寰�2鍒嗛悩鍚庣祩浜庨啋渚嗕簡锛岃繑鍥炰竴鍊媏rror锛�

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

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

涔熷氨鏄湪鏁�(sh霉)鎿氬韩閫ｆ帴涓柗鐨勬儏娉佷笅锛孒ikariCP鍦�5绉掑収灏卞彲浠ユ劅鐭�锛屽苟鍦ㄦ渶鐭檪闁撳収閫氱煡涓婂堡鎳夌敤銆傞€欏€嬮熆鎳夊蹇紝澶犲強鏅�銆傚闅涙脯瑭︿腑锛屽氨鏄嫈缍茬窔锛岀瓑鍗婂垎閻樺啀鎻掍笂锛岀湅瑾版渶鍏堟仮寰╂暩(sh霉)鎿氬韩閫ｆ帴銆侶ikariCP 鍙堝嫕鍑恒€�

閲戠瑳鐭俊涓枔浠禬EB鐗堥泦鎴愬厜閫熸暩(sh霉)鎿氬韩閫ｆ帴姹�锛屽湪鍚勭ó鏁�(sh霉)鎿氬韩鐠�(hu谩n)澧冧笅琛ㄧ従(xi脿n)鐣板父绌�(w臎n)瀹�銆傛湁鐨勫鎴跺湪灞€鍩熺恫閫ｆ帴闃块噷浜戜富姗熸暩(sh霉)鎿氬韩鍥犵偤涓嶆槑鍘熷洜锛岄枔姝囨€ф柗缍茬殑鎯呮硜锛屼篃娌掓湁褰遍熆鐭俊鐧�(f膩)閫�銆傚娓敮鎸丼QLServer銆丱racle銆丮ySQL锛屾敮鎸亀in鍜宭inux鍚勫€嬬増鏈�銆�