Grails3默认数据库连接池为
tomcat-jdbc pool
,性能较druid
、HikariCP
差太多,所以想换成其他连接池
- 由于默认使用的是
tomcat-jdbc
连接池,需要去掉依赖
// runtime "com.h2database:h2"
// runtime "org.apache.tomcat:tomcat-jdbc"
// 添加阿里巴巴druid连接池
compile group: 'com.alibaba', name: 'druid', version: '1.1.18'
compile 'mysql:mysql-connector-java:5.1.40'
grails-app/conf/applicaiton.yml
配置也要注释掉默认的连接池
dataSource:
# pooled: true
jmxExport: true
driverClassName: com.mysql.jdbc.Driver
username: root
password: root
dialect: org.hibernate.dialect.MySQL5InnoDBDialect
url: jdbc:mysql://localhost:3306/g3?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=false
# 为了兼容grails,让Hibernate自动建表,所以在dataSource下增加连接池相关的配置
druid:
minIdle: 1
maxActive: 40
maxWait: 60000
initialSize: 20
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
removeAbandoned: true
filters: stat,wall,slf4j
validationQuery: select 'x'
useGlobalDataSourceStat: