The last packet successfully received from the server was XXX seconds ago

最新推荐文章于 2024-05-20 10:01:30 发布

mangmang2012

最新推荐文章于 2024-05-20 10:01:30 发布

阅读量9k

点赞数

分类专栏： mysql 文章标签： server application database overloading performance concurrency

mysql 专栏收录该内容

24 篇文章

订阅专栏

本文介绍如何使用Apache DBCP连接池提高应用性能，并避免数据库空闲超时问题。包括连接池参数设置及验证查询配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Database Connection Pools

Using a connection pool is recommended for improving the performance of your application, and to ensure that your application handles excessive concurrency without overloading your Shared Database configurations (which have a limited number of connections available to the application). CloudBees datasources use the Apache DBCP connection pool implementation, which has a wide set of connection options. The configuration below is a good configuration for a lightly loaded application or an application running in the free app+db tier.

<resource name="jdbc/DATASOURCE_NAME" auth="Container" type="javax.sql.DataSource">
<param name="username" value="USERNAME" />
<param name="password" value="PASSWORD" />
<param name="url" value="JDBC_URL" />

<!-- Connection Pool settings -->
<param name="maxActive" value="5" />
<param name="maxIdle" value="2" />
<param name="maxWait" value="10000" />
<param name="removeAbandoned" value="true" />
<param name="removeAbandonedTimeout" value="60" />
<param name="logAbandoned" value="true" />
</resource>

Avoiding Database Idle Timeouts

MySQL includes a timeout that will close connections that have been idle for long periods of time. For improved Database performance, CloudBees DataSources use the Apache DBCP connection pool to reuse JDBC connections after they are closed by the application. If you use a connection that has been in the pool idle for too long, your application will likely experience the following error: "The last packet successfully received from the server was XXX seconds ago". The connection pool includes a setting the will validate and throw out dead connections when calling javax.sql.DataSource.getConnection(). To use this setting, add the following XML params to your DataSource definition in cloudbees-web.xml.

<param name="validationQuery" value="SELECT 1" />
<param name="testOnBorrow" value="true" />

http://wiki.cloudbees.com/bin/view/RUN/DatabaseGuide