c3po连接mysql带端口号_利用C3PO配置数据库连接池出现的问题

最新推荐文章于 2023-07-07 16:04:37 发布

小6加油

最新推荐文章于 2023-07-07 16:04:37 发布

阅读量401

点赞数

文章标签： c3po连接mysql带端口号

本文链接：https://blog.csdn.net/weixin_34708601/article/details/113679418

版权

在使用C3PO配置MySQL数据源时，遇到日志中不断显示资源检查过期的问题，这可能影响性能。日志显示资源检查周期为2469毫秒，资源未过期，但最终导致资源被移除。博客内容涉及C3PO连接池的资源管理及可能存在的配置问题。

摘要由CSDN通过智能技术生成

我利用C3P0配置mysql数据源时候，在日志中不停的出现如下日志，好像在不停的检查过期。这样不停的增加我想肯定会影响性能。日志如下

引用

11462296 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@9c939 [managed: 1, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@b7cee4)

11464765 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:15:43 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11464765 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 2469 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11467265 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:15:45 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11467265 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 4969 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11469765 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:15:48 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11469765 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 7469 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11472265 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:15:50 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11472265 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 9969 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11474843 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:15:53 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11474843 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 12547 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11477343 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:15:55 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11477343 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 15047 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11479859 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:15:58 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11479859 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 17563 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11482359 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:00 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11482359 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - EXPIRED resource: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f ---> age: 20063 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11482359 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Removing expired resource: com.mchange.v2.c3p0.impl.NewPooledConnection@150152f [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11482359 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@9c939 [managed: 0, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@b7cee4)

11482375 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@9c939 [managed: 1, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@b7cee4)

11484859 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:03 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11484859 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 2484 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11487359 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:05 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11487359 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 4984 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11489859 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:08 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11489859 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 7484 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11492375 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:10 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11492375 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 10000 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11494890 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:13 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11494890 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 12515 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11497406 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:15 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11497406 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 15031 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11499906 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:18 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11499906 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 17531 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11502406 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:20 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11502406 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - EXPIRED resource: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db ---> age: 20031 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11502406 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Removing expired resource: com.mchange.v2.c3p0.impl.NewPooledConnection@17368db [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11502406 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@9c939 [managed: 0, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@b7cee4)

11502687 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@9c939 [managed: 1, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@b7cee4)

11504921 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:23 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11504921 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 2234 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11507421 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:25 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11507421 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 4734 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11509937 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:28 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11509937 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 7250 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11512437 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:30 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11512437 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 9750 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11514937 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:33 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11514937 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 12250 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11517437 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:35 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11517437 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 14750 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11519937 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:38 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11519937 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 17250 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11522453 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:40 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11522453 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - resource age is okay: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 19766 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11524968 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Checking for expired resources - Mon May 26 19:16:43 CST 2008 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11524968 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - EXPIRED resource: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b ---> age: 22281 max: 20000 [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11524968 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - Removing expired resource: com.mchange.v2.c3p0.impl.NewPooledConnection@106c17b [com.mchange.v2.resourcepool.BasicResourcePool@9c939]

11524968 [Timer-0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@9c939 [managed: 0, unused: 0, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@b7cee4)

11524968 [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] DEBUG com.mchange.v2.resourcepool.BasicResourcePool - trace com.mchange.v2.resourcepool.BasicResourcePool@9c939 [managed: 1, unused: 1, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@b7cee4)

我用的是Struts2.0+spring+hibernate+Mysql5.0。

我的数据库连接池的配置。