Proxool 配置

公司项目中采用了开源的数据库连接池Proxool，今天有空研究一下。

Proxool的官方网址是http://proxool.sourceforge.net/

//Proxool配置文件

//配置文件属性官方网址http://proxool.sourceforge.net/properties.html，这里有更全的介绍。

 

proxool.driver = com.mysql.jdbc.Driver

// prototype-count is the number of spare connections it strives to keep over and above the ones that are currently active. Default is 0

//即最少保持的连接数
proxool.prototypeCount = 10
proxool.maximumConnectionCount = 1000
proxool.minimumConnectionCount = 2

//If the housekeeper comes across a thread that has been active for longer than this then it will kill it.  Default is 5 minutes.

//1000个小时啊，好像给的这个数太大了吧！
proxool.maximumActiveTime = 3600000

//select now() 这个只是那来的，找了好久也没有找到，路过的高手看见的指点一下。
proxool.houseKeepingTestSql = select now()

//If true then each SQL call gets logged (DEBUG level) along with the execution time.

//You can also get this information by registering a ConnectionListener (see ProxoolFacade). Default is false.
proxool.trace = false

//Either false (quiet) or true (loud). Default is false.不明白这个属性是干什么了
proxool.verbose = false
proxool.default.driverUrl = jdbc:mysql://localhost:3306/database?autoReconnect=true&useUnicode=true&characterEncoding=utf8
proxool.default.user = root
proxool.default.password = root
proxool.default.alias = proxool_default
//这几行实干什么了，不明白
proxool.crawler.driverUrl = jdbc:mysql://localhost:3306/database?autoReconnect=true&useUnicode=true&characterEncoding=utf8
proxool.crawler.user = root
proxool.crawler.password = root
proxool.crawler.alias = proxool_crawler