160629, DBCP, C3P0, Proxool, BONECP Open source connection pool comparison

	Brief introduction	Usage evaluation	Project Home
DBCP	DBCP is a database connection pool that relies on the Jakarta Commons-pool object pooling mechanism. DBCP can be used directly in the application	You can set the maximum and minimum connections, the connection wait time, and so on, the basic function, the stability of the continuous operation of this connection pool is still possible, but the speed is slightly slower, under the pressure of large concurrency decreased, but also does not provide connection pool monitoring	Http://homepages.nildram. co.uk/~slink/java/dbpool/
C3p0	C3P0 is an open source JDBC connection pool, which is published in the Lib directory with Hibernate, including statement objects that implement the connection and datasources pools of JDBC3 and JDBC2 extension specification descriptions.	The connection pool can set the maximum and minimum connection, the connection wait time and so on, the basic function has, the connection pool's continuous operation stability is quite good, under the large concurrency quantity pressure stability also has the certain assurance, also does not provide the connection pool monitoring.	Http://sourceforge.net/projects/c3p0
Proxool	This is a Java SQL driver driver that provides a connection pooling package for other types of drivers that you choose. Can be ported to existing code very simply. Fully configurable. Fast, mature and robust. You can transparently increase the connection pooling capability for your existing JDBC driver.	Connection pooling can set maximum and minimum connections, connection waiting time, and so on, basic functions are, the stability of the continuous operation of the connection pool has some problems, there is an advantage--connection pool monitoring	http://proxool.sourceforge.net/
Bonecp	BONECP is a fast, open source database connection pool. Help you manage your data connections to give your application faster access to the database. 25 times times faster than the C3P0/DBCP connection pool	A new data connection technology, known for its high efficiency, fast speed, connection pool can set maximum and minimum connection, connection waiting time, etc., basic functions have	Http://jolbox.com/about.html

	Parameter description
DBCP	DataSource: DataSource to connect (usually we don't define in Server.xml) Defaultautocommit: The default value is true for transactions that are autocommit Defaultreadonly: The default value is false for database read only Driverclassname: The JDBC Driver Class used to connect to the database, Maxactive: Maximum number of objects that can be fetched from the object pool, 0 means no limit, default is 8 Maxidle: Maximum number of waiting connections, set 0 to No limit (the maximum number of objects in the object pool) Minidle: Minimum number of objects in the object pool Maxwait: Maximum wait seconds, in MS, over time will throw error message Password: Password used to log in to the database URL: The URL of the connection database Username: Account number used to log into the database Validationquery: Verify that the connection is successful and that the SQL SELECT directive returns at least one row Removeabandoned: Is self-interrupting, default is False Removeabandonedtimeout: The removeabandoned must be true after a few seconds of self-interruption Logabandoned: If an interrupt event is logged, the default is False Minevictableidletimemillis: Greater than 0, the connection idle time is judged, or 0, the idle connection is not verified; default 30 minutes Timebetweenevictionrunsmillis: Failure Check thread run interval, if less than equals 0, does not start check thread, Default-1 Testonborrow: Whether to validate when an object is obtained, check if the object is valid, default to False Testonreturn: Whether to validate when returning an object, check if the object is valid, default to False Testwhileidle: Whether to validate when idle, check if the object is valid, default to False InitialSize: Number of initialization threads
C3p0	Acquireincrement: c3p0 The number of connections fetched at a time when the connection in the connection pool is exhausted. Default:3 Acquireretryattempts: Defines the number of repeated attempts to obtain a new connection from the database after a failure. Default:30 Acquireretrydelay: Interval in two connections, per millisecond. default:1000 Autocommitonclose: All uncommitted operations are rolled back by default when the connection is closed. Defaul T:false AUTOMATICTESTTABLE:C3P0 will build an empty table named Test and test it with its own query statement. If this parameter is defined, then the attribute preferredtestquery will be ignored. You cannot do anything on this test sheet, it will be used only for C3P0 testing. Default:null Breakafteracquirefailure: Getting a connection failure will cause any thread that waits for the connection pool to get the connection to throw an exception. However, the data source is still valid and continues to try to get the connection the next time you call Getconnection (). If set to True, the data source will declare broken and permanently shut down after attempting to acquire a connection failure. Default:false Checkouttimeout: When the connection pool is exhausted, the client calls getconnection () to wait for a new connection, and then throws SqlException after the timeout, and waits indefinitely if set to 0. Unit milliseconds. default:0 Connectiontesterclassname: Test the connection by implementing a class of Connectiontester or Queryconnectiont ester. The class name needs to be set to the full path. Default:com.mchange.v2.c3p0.impl.Def Aultconnectiontester Factoryclasslocation: Specifies the path of the C3P0 libraries, which is not required if (usually it is) local, and defaults to NULL for Default:null Idleconnectiontestperiod: Checks for idle connections in all connection pools every 60 seconds. Defaul t:0 Initialpoolsize: Gets three connections during initialization, and the value should be between Minpoolsize and Maxpoolsize. Default:3 MaxIdleTime: Maximum idle time, unused in 60 seconds, the connection is discarded. If 0, it will never be discarded. default:0 Maxpoolsize: The maximum number of connections that are kept in the connection pool. Default:15 MAXSTATEMENTS:JDBC standard parameter to control the number of PREPAREDST atements loaded within the data source. However, because the pre-cached statements belong to a single connection instead of the entire connection pool. So setting this parameter takes into account a variety of factors. If both maxstatements and maxstatementsperconnection are 0, the cache is closed. default:0 Maxstatementsperconnection:maxstatementsperconnection defines the maximum number of cache statements that a single connection in a connection pool has. default:0 NUMHELPERTHREADS:C3P0 are asynchronous operations, and slow JDBC operations are done by helping the process. Extending these operations can effectively improve performance by implementing multiple operations at the same time through multithreading. Default:3 Overridedefaultuser: When the user calls getconnection (), the root user becomes the user to get the connection. Used primarily when connection pooling is connected to a non-c3p0 data source. Default:null Overridedefaultpassword: A parameter that corresponds to the Overridedefaultuser parameter. Default:null Password: password. Default:null User: Username. Default:null Preferredtestquery: Defines test statements that are executed by all connection tests. This one significantly improves the test speed in the case of connection testing. Note: The test table must exist at the time of the initial data source. Default:null Propertycycle: The user waits up to 300 seconds before modifying the system configuration parameters to execute. Defaul t:300 Testconnectiononcheckout: Please use it only when you need it because of high performance consumption. If set to true then the validity of each connection submission is officer. We recommend using methods such as Idleconnectio ntestperiod or automatictesttable to improve the performance of your connectivity tests. Default:false Testconnectiononcheckin: If set to true then the validity of the officer connection is obtained while the connection is made. Default:false
Proxool	Acquireincrement: c3p0 The number of connections fetched at a time when the connection in the connection pool is exhausted. Default:3 Fatal-sql-exception: It is a comma-delimited piece of information. When an SQL exception occurs, his exception information is compared to this fragment of information. If present in the fragment, the exception will be considered a fatal error (Fatal SQL exception). In this case, the database connection will be discarded. No matter what happens, this exception will be re-thrown to provide to the consumer. It is best for users to configure a different exception to throw. Fatal-sql-exception-wrapper-class: As mentioned above, you'd better configure a different exception to re-throw. With this attribute, the user can wrap the SqlException and make him another exception. This exception or inheritance The SqlException or inherited word Runtimeexception.proxool comes with 2 implementations: ' Org.logicalcobwebs.proxool. Fatalsqlexception ' and ' Org.logicalcobweb s.proxool. Fatalruntimeexception '. The latter is more appropriate. House-keeping-sleep-time:house keeper retains the maximum amount of time a thread is asleep, house keeper's job is to check the status of each connection and determine whether it needs to be destroyed or created. House-keeping-test-sql: If an idle database connection is found. House keeper will be tested with this statement. This statement is best executed very quickly. If there is no definition, the test process will be ignored. Injectable-connection-interface: Allows the Proxool to implement the Connection object method being proxied. Injectable-statement-interface: Allows Proxool to implement the statement object method being proxied. Injectable-prepared-statement-interface: Allows Proxool to implement Prepareds Tatement object methods that are proxied. Injectable-callable-statement-interface: Allows Proxool to implement Callablestat Ement object methods that are proxied. JMX: If the property is true, a message bean is registered to the JMS service, the message Bean object name: "Proxool:type=pool, name=<alias>". The default value is False. Jmx-agent-id: A comma-delimited list of JMX proxies, such as connection pools registered with Mbeanserverfactory. Fi ndmbeanserver (String agentid). This property is valid only if the "JMX" property is set to "true". All registered JMX servers use this property to be indeterminate Jndi-name: Name of the data source Maximum-active-time: If housekeeper detects that the active time of a thread is greater than this number. It will kill this thread. So confirm the bandwidth of your server. Then set a suitable value. The default is 5 minutes. Maximum-connection-count: Maximum number of database connections. Maximum-connection-lifetime: The maximum lifespan of a thread. Minimum-connection-count: Minimum number of database connections Overload-without-refusal-lifetime: This can help us determine the status of the connection pool. If we have rejected a connection at this setpoint (MS), then it is considered overloaded. The default is 60 seconds. Prototype-count: The number of connections available in the connection pool. If the connection in the current connection pool is less than this number. The new connection will be established (assuming no more than the maximum available number). For example, we have 3 active connections 2 available connections, and our prototype-count is 4, Then the database connection pool will attempt to establish an additional 2 connections. This is different from Minimum-connection-count. Minimum-connect Ion-count also calculates the connection of the activity. Prototype-count is the number of spare connections. Recently-started-threshold: This can help us determine the state of the connection pool, whether the number of connections is few or more or overloaded. As long as at least one connection has started in this value (in milliseconds), or there are some redundant connections available, we assume that the connection pool is open. Default is 60 seconds Simultaneous-build-throttle: This is the maximum number of connections we can make at one time. That is the new connection request, but there is no connection available. Because a connection can use multiple threads to establish a connection between a limited amount of time to bring in a usable link, we need some way to confirm that some threads are not responding immediately to the connection request, which is 10 by default. Statistics: Connection pool usage statistics. Parameter "10s,1m,1d" Statistics-log-level: Log statistics trace type. Parameter "ERROR" or "INFO" Test-before-use: If True, the connection will be served before each connection is tested, and if one connection fails, it is discarded, the other connection will be processed, and if all connections fail, a new connection will be established. Otherwise, a SqlException exception will be thrown. Test-after-use: If True, the connection will be serviced after each connection has been tested, returning it to the connection pool and discarded if the connection fails. Trace: If true, then each executed SQL statement will be logged at the execution time (DEBUG level). You can also register a connectionlistener (see Proxoolfacade) to get this information
Bonecp	Acquireincrement: c3p0 The number of connections fetched at a time when the connection in the connection pool is exhausted. Default:3 Driveclass: Database Driver Jdbcurl: Response-driven Jdbcurl Username: User name of the database Password: password for the database Idleconnectiontestperiod: Check the interval of the connection in the database connection pool, the unit is the default value: 240, if you want to cancel set to 0 Idlemaxage: The maximum surviving time of unused links in the connection pool, in units of minutes, default: 60, if you want to live forever set to 0 Maxconnectionsperpartition: Maximum number of connections per partition Minconnectionsperpartition: Minimum number of connections per partition Partitioncount: Number of partitions, default value 2, minimum 1, recommended 3-4, depending on application Acquireincrement: Each time to get a database connection when you want to get a few, the default value: 2 Statementscachesize: Cache prepared statements size, default value: 0 Releasehelperthreads: Each partition releases the number of link attendant processes, the default value: 3, unless you do a lot of work during a database connection, or excessive assistant processes can affect your performance

Performance comparison:

	DBCP	C3p0	Proxool	Bonecp
Simulating 5 threads Looping 10 concurrent accesses to a database	Spents 1181ms	Spents 860ms	Spents 1563ms	Spents 31ms
Simulating 10 threads Looping 10 concurrent accesses to a database	Spents 1188ms	Spents 953ms	Spents 1625ms	Spents 63ms
Simulating 30 threads Looping 10 concurrent accesses to a database	Spents 1250ms	Spents 1047ms	Spents 1657ms	Spents 156ms
Simulating 50 threads looping 10 concurrent accesses to a database	Spents 1406ms	Spents 1343ms	Spents 1843ms	Spents 172ms
Simulating 100 threads Looping 10 concurrent accesses to a database	Spents 1641ms	Spents 2703ms	Spents 2031ms	Spents 532ms
Simulating 200 threads Looping 10 concurrent accesses to a database	Spents 2093ms	Spents 4891ms	Spents 2406ms	Spents 936ms
Simulating 500 threads Looping 10 concurrent accesses to a database	Spents 3219ms	Spents 11703ms	Spents 3343ms	Spents 1922ms
Simulating 800 threads Looping 10 concurrent accesses to a database	Spents 4688ms	Spents 12063ms	Spents 4141ms	Spents 2859ms
Simulating 1000 threads Looping 10 concurrent accesses to a database	Spents 5187ms	Spents 12563ms	Spents 4703m	Spents 3610ms
Simulating 3,000 threads looping 10 concurrent accesses to a database	Spents 14094ms	Spents 16297ms	Spents 11344ms	Spents 11391ms
Simulating 5,000 threads Looping 10 concurrent accesses to a database	Spents 23610ms	Spents 22032ms	Spents 20125ms	Spents 17125ms

160629, DBCP, C3P0, Proxool, BONECP Open source connection pool comparison