thread pool and database connection pool

最新推荐文章于 2025-08-09 18:20:04 发布

iteye_12827

最新推荐文章于 2025-08-09 18:20:04 发布

阅读量92

点赞数

文章标签：数据库

本文通过测试结果展示了不同数据库连接管理策略的性能表现。单线程单连接方式性能最差，而采用连接池技术可以显著提升效率，仅消耗最佳情况下的25%时间。文中还介绍了几种开源的JDBC连接池方案，并提供了MySQL配置和连接管理的相关链接。

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

The test result shows the “one main thread, one connection per NE/per sql” performs worst, and “thread pool, shared one connection” improves, but a little. And with database conection pool, it improves amazingly, it only use about 25% time of the worst case.

Some notes about the database connection pool.

1) open source software for JDBC connection pool
http://baike.baidu.com/view/84055.htm
note: apache DBCP do not use
suggest c3p0.

2) mysql show configurations
http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_max_connections
for example: SHOW VARIABLES;
max_connections default value is 100.

3) mysql show connections
http://dev.mysql.com/doc/refman/5.5/en/show-processlist.html
for example: show processlist;

4) mysql kill connection
http://dev.mysql.com/doc/refman/5.5/en/kill.html
for example: kill 19024

here are some links from net,

1) http://hi.baidu.com/tlw_ray/blog/item/c9c3052d81cc1636359bf7e7.html
2) http://abaper.blogbus.com/logs/109435878.html
3) http://jolbox.com/ bonecp