启用连接集中器必须将连接池打开?
考虑:不同的技术对连接池是否支持?
Consideration: Does the technology support connection pooling?
对xa事务和连接池的支持。
推荐:请调整连接池的最大值和最小值。
Recommendation: Adjust the maximum and minimum sizes of the connection pool.
连接池与代理的分配和解除分配相关联。
Connection pooling is associated with the allocation and deallocation of agents.
与连接池相关的重要调优选项如表4所示。
The important tunable options associated with connection pools are shown in Table 4.
该参数控制由连接池缓存的最大预编译语句数。
This parameter controls the maximum number of prepared statements cached by a connection pool.
应用程序不必知道JDBC驱动程序和连接池。
Applications are not required to be aware of the either the JDBC Driver or the connection pool.
连接池的工作取决于连接和断开连接。
Connection pooling ACTS upon connections and disconnections.
这个连接器提供连接池,并装载您所指定的驱动。
The connector provides connection pooling and loads the JDBC driver you specify.
unixODBC连接池实现仅在进程内有效。
The unixODBC connection pooling implementation is scoped to a process.
为了减少此类开销,连接池在空闲时会运行该验证。
In order to reduce this overhead, a connection pool can run validation while it is idle.
所以,可能需要提高连接池的平均大小或连接数量。
As a result, you might need to increase the average size of the connection pool or number of connections.
有限的连接池。
众所周知,使用数据库连接池可以获得许多性能优势。
It is common knowledge that you can gain a lot of performance benefits by using database connection pools.
并发性不足和连接池大小不足的一个症状是CPU闲置。
One symptom of insufficient concurrency and insufficient connection pool size is an idle CPU.
数据源提供到基础数据库的连接属性,以及连接池机制。
A data Source provides the connection properties to the underlying database along with connection pooling mechanisms.
因此,应该优化连接池,以便在系统上获得预期的工作量。
Hence, the size of a connection pool should be optimized for the expected workload on the system.
您已经知道可以在服务器中安装资源适配器时设置连接池。
You have already seen that a connection pool can be set up when you install a resource adapter in the server.
新增的语句池和增强的连接池支持离实现这个目标还很远。
The addition of statement pooling and enhanced connection pooling support goes a long way toward achieving this goal.
总的来说,连接池是一个到JMS提供程序的空闲连接池。
In general terms, a connection pool is a pool of free connections to a JMS provider.
最大等待时间:连接池等待连接返回的最大时间。
Max wait time: the maximum time the pool will wait for a connection to be returned.
为连接池大小配置适当的值是一个应用程序服务器调优问题。
Configuring proper values for connection pool sizes is a matter of tuning an application server.
连接池等待时间表示应用程序阻塞时等待连接池连接的时间。
Connection pool wait time represents the amount of time an application is blocked waiting for a connection from the connection pool.
连接数:连接池与数据库建立的实际物理连接的数量。
Connection count: the number of actual physical connections to the database from connections in the pool.
已配置最大连接池大小显示已配置的最大的池的大小。
Configured maximum pool size displays the configured maximum pool size.
图1显示了连接池、会话池、线程池和最大会话属性之间的关系。
Figure 1 shows the relationship between the connection pool, session pool, thread pool and the maximum sessions property.
使用有连接池的JDBC资源的应用程序需要设置连接池的大小。
Applications that make use of connection pooled JDBC resources need to set the size of the connection pool.
实现数据库连接池,重用连接对象,而不是重复地打开和关闭连接。
Implement connection pools to the database and reuse connection objects, rather than repeatedly opening and closing connections.
清单4显示了在应用程序模块中查找创建的数据库连接池所需的代码。
Listing 4 shows the code in the application module needed to lookup the created database connection pool.
应用推荐