×ðÁú¿­Ê±¹ÙÍøµÇ¼

druidÅþÁ¬³Ø²ÎÊýÔõôÉèÖÃ

druid ÅþÁ¬³Ø²ÎÊýÉèÖÃÈçÏ£ºÅþÁ¬³Ø´óС£ºmaxidle=8£¬minidle=0ÅþÁ¬³¬Ê±ºÍÖØÊÔ£ºconnectiontimeout=30000£¬connectionretryattempts=3¸ºÔØƽºâ£ºloadbalancingpolicy=roundrobin£¨Ä¬ÈÏ£©¼à¿Ø£ºusestats=false£¬statsperiod=300000¸ß¼¶²ÎÊý£ºvalidationquery=select 1£¬testwhileidle=false£¬checkconnectionwhileidletim

Druid ÅþÁ¬³Ø²ÎÊýÉèÖÃ

Druid ÅþÁ¬³ØÊÇÒ»¸ö¸ßÐÔÄܵÄÅþÁ¬³Ø£¬ÓÃÓÚÖÎÀíÓëÊý¾Ý¿âµÄÅþÁ¬¡£ÉèÖÃÆä²ÎÊý¹ØÓÚÓÅ»¯Êý¾Ý¿âÐÔÄܺÜÊÇÖ÷Òª¡£ÒÔÏÂÊÇÔõÑùÉèÖà Druid ÅþÁ¬³Ø²ÎÊý£º

1. ÅþÁ¬³Ø¾Þϸ

  • maxIdle£º³ØÖÐÔÊÐíµÄ×î´óÏÐÖÃÅþÁ¬Êý¡£Ä¬ÈÏֵΪ 8¡£
  • minIdle£º³ØÖÐÔÊÐíµÄ×îСÏÐÖÃÅþÁ¬Êý¡£Ä¬ÈÏֵΪ 0¡£

2. ÅþÁ¬³¬Ê±ºÍÖØÊÔ

  • connectionTimeout£ºÅþÁ¬Êý¾Ý¿âµÄ³¬Ê±Ê±¼ä£¨ÒÔºÁÃëΪµ¥Î»£©¡£Ä¬ÈÏֵΪ 30000¡£
  • connectionRetryAttempts£ºÔÚ½¨ÉèÅþÁ¬Ê§°ÜºóÖØÊԵĴÎÊý¡£Ä¬ÈÏֵΪ 3¡£

3. ¸ºÔØƽºâ

  • loadBalancingPolicy£ºÓÃÓÚÔÚ¿ÉÓÃÅþÁ¬Ö®¼ä·ÖÅÉÅÌÎʵĸºÔØƽºâÕ½ÂÔ¡£Ä¬ÈÏֵΪ “RoundRobin”¡£ÆäËûÑ¡Ïî°üÀ¨ “Random”¡¢”Weighted” ºÍ “LeastActive”¡£

4. ¼à¿Ø

  • useStats£ºÊÇ·ñÍøÂçÓйØÅþÁ¬³ØʹÓÃÇéÐεÄͳ¼ÆÐÅÏ¢¡£Ä¬ÈÏֵΪ false¡£
  • statsPeriod£ºÍøÂçͳ¼ÆÐÅÏ¢µÄƵÂÊ£¨ÒÔºÁÃëΪµ¥Î»£©¡£Ä¬ÈÏֵΪ 300000¡£

5. ÆäËû¸ß¼¶²ÎÊý

  • validationQuery£ºÓÃÓÚÑéÖ¤ÅþÁ¬ÊÇ·ñÓÐÓÃµÄ SQL ÅÌÎÊ¡£Ä¬ÈÏֵΪ “SELECT 1″¡£
  • testWhileIdle£ºÊÇ·ñÔÚÅþÁ¬¿ÕÏÐʱ¶ÔÆä¾ÙÐÐÑéÖ¤¡£Ä¬ÈÏֵΪ false¡£
  • checkConnectionWhileIdleTimeout£º²âÊÔ¿ÕÏÐÅþÁ¬³¬Ê±Ê±¼ä£¨ÒÔºÁÃëΪµ¥Î»£©¡£Ä¬ÈÏֵΪ 1800000¡£

ʾÀýÉèÖÃ

Ò»¸öʾÀýµÄ Druid ÅþÁ¬³ØÉèÖÃÈçÏ£º

<property><name>druid.connection-pool.max-idle</name><value>10</value></property><property><name>druid.connection-pool.min-idle</name><value>2</value></property><property><name>druid.connection-pool.connection-timeout</name><value>15000</value></property><property><name>druid.connection-pool.connection-retry-attempts</name><value>2</value></property><property><name>druid.connection-pool.load-balancing-policy</name><value>Weighted</value></property><property><name>druid.connection-pool.use-stats</name><value>true</value></property>

µÇ¼ºó¸´ÖÆ

ÒÔÉϾÍÊÇdruidÅþÁ¬³Ø²ÎÊýÔõôÉèÖõÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í×ðÁú¿­Ê±¹ÙÍøµÇ¼ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ×ðÁú¿­Ê±¹ÙÍøµÇ¼

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎ壬9:30-18:30£¬½ÚãåÈÕÐÝÏ¢

QR code
ÍøÕ¾µØͼ