Java中数据库连接池HikariCP和Druid的技术对比与性能分析

# application.yml
spring:
  datasource:
    type: com.zaxxer.hikari.hikaridatasource
    hikari:
      pool-name: hikaripool
      minimum-idle: 5
      maximum-pool-size: 20
      connection-timeout: 30000
      idle-timeout: 600000
      max-lifetime: 1800000
      leak-detection-threshold: 60000

// java配置
@configuration
public class hikariconfig {
    
    @bean
    @primary
    public datasource hikaridatasource() {
        hikariconfig config = new hikariconfig();
        config.setjdbcurl("jdbc:mysql://localhost:3306/testdb");
        config.setusername("user");
        config.setpassword("password");
        config.setdriverclassname("com.mysql.cj.jdbc.driver");
        
        // 性能优化配置
        config.setminimumidle(5);
        config.setmaximumpoolsize(20);
        config.setconnectiontimeout(30000);
        config.setidletimeout(600000);
        config.setmaxlifetime(1800000);
        config.setleakdetectionthreshold(60000);
        
        return new hikaridatasource(config);
    }
}

# application.yml
spring:
  datasource:
    type: com.alibaba.druid.pool.druiddatasource
    druid:
      initial-size: 5
      min-idle: 5
      max-active: 20
      max-wait: 60000
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      validation-query: select 1
      test-while-idle: true
      test-on-borrow: false
      test-on-return: false
      pool-prepared-statements: true
      max-pool-prepared-statement-per-connection-size: 20
      # 监控配置
      web-stat-filter:
        enabled: true
        url-pattern: /*
        exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"
      stat-view-servlet:
        enabled: true
        url-pattern: /druid/*
        login-username: admin
        login-password: admin

// java配置
@configuration
public class druidconfig {
    
    @bean
    @configurationproperties(prefix = "spring.datasource.druid")
    public datasource druiddatasource() {
        druiddatasource datasource = new druiddatasource();
        
        // 基本配置
        datasource.seturl("jdbc:mysql://localhost:3306/testdb");
        datasource.setusername("user");
        datasource.setpassword("password");
        datasource.setdriverclassname("com.mysql.cj.jdbc.driver");
        
        // 连接池配置
        datasource.setinitialsize(5);
        datasource.setminidle(5);
        datasource.setmaxactive(20);
        datasource.setmaxwait(60000);
        
        // 监控配置
        datasource.settimebetweenevictionrunsmillis(60000);
        datasource.setminevictableidletimemillis(300000);
        datasource.setvalidationquery("select 1");
        datasource.settestwhileidle(true);
        datasource.settestonborrow(false);
        datasource.settestonreturn(false);
        
        // 配置监控统计拦截的filters
        try {
            datasource.setfilters("stat,wall,log4j2");
        } catch (sqlexception e) {
            throw new runtimeexception("druid configuration initialization filter error", e);
        }
        
        return datasource;
    }
}

// 性能测试代码示例
@benchmarkmode(mode.throughput)
@outputtimeunit(timeunit.seconds)
@state(scope.benchmark)
public class connectionpoolbenchmark {
    
    private datasource hikaridatasource;
    private datasource druiddatasource;
    
    @setup
    public void setup() {
        // 初始化连接池配置
        hikaridatasource = createhikaridatasource();
        druiddatasource = createdruiddatasource();
    }
    
    @benchmark
    @threads(50)
    public void testhikariconnectionacquisition() throws sqlexception {
        try (connection conn = hikaridatasource.getconnection()) {
            // 模拟数据库操作
            performdatabaseoperation(conn);
        }
    }
    
    @benchmark
    @threads(50)
    public void testdruidconnectionacquisition() throws sqlexception {
        try (connection conn = druiddatasource.getconnection()) {
            // 模拟数据库操作
            performdatabaseoperation(conn);
        }
    }
}

// 推荐配置
@configuration
public class hikarioptimalconfig {
    
    @bean
    public datasource optimizedhikaridatasource() {
        hikariconfig config = new hikariconfig();
        
        // 基础配置
        config.setjdbcurl("jdbc:mysql://localhost:3306/db");
        config.setusername("user");
        config.setpassword("password");
        
        // 性能优化配置
        config.setminimumidle(10);  // 根据业务负载调整
        config.setmaximumpoolsize(50); // cpu核心数 * 2
        config.setconnectiontimeout(20000); // 20秒
        config.setidletimeout(300000); // 5分钟
        config.setmaxlifetime(1200000); // 20分钟
        config.setleakdetectionthreshold(60000); // 1分钟
        
        // 连接测试
        config.setconnectiontestquery("select 1");
        
        return new hikaridatasource(config);
    }
}

// 推荐配置
@configuration
public class druidoptimalconfig {
    
    @bean
    public datasource optimizeddruiddatasource() {
        druiddatasource datasource = new druiddatasource();
        
        // 基础配置
        datasource.seturl("jdbc:mysql://localhost:3306/db");
        datasource.setusername("user");
        datasource.setpassword("password");
        
        // 连接池配置
        datasource.setinitialsize(10);
        datasource.setminidle(10);
        datasource.setmaxactive(50);
        datasource.setmaxwait(60000);
        
        // 健康检查
        datasource.setvalidationquery("select 1");
        datasource.settestwhileidle(true);
        datasource.settestonborrow(false);
        datasource.settestonreturn(false);
        
        // 监控配置
        datasource.settimebetweenevictionrunsmillis(60000);
        datasource.setminevictableidletimemillis(300000);
        
        // 启用监控
        try {
            datasource.setfilters("stat,wall,slf4j");
        } catch (sqlexception e) {
            throw new runtimeexception(e);
        }
        
        return datasource;
    }
}