I am using Spring with Hibernate and at the moment am using the following datasource configuration. I am looking for suggestions as to what I might want to change or add to achieve maximum performance in a production environment. I know there are many other factors that would affect such tuning decisions, but I was hoping for some advice on how to set up a good general initial configuration that would best handle a heavy load of light queries.
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.mysql.jdbc.Driver" />
<property name="url" value="jdbc:mysql://localhost:3306/mysqldb?autoReconnect=true" />
<property name="username" value="me" />
<property name="password" value="mypass" />
<property name="initialSize" value="10" />
<property name="maxActive" value="100" />
<property name="maxIdle" value="-1" />
<property name="maxWait" value="-1" />
</bean>
Login
FAQ
Search
