spring:
  datasource:
    hikari:
      # 最大連接池大?。J(rèn)值）
      maximum-pool-size: 10
      # 最小空閑連接數(shù)（默認(rèn)值）
      minimum-idle: 10
      # 獲取連接超時(shí)時(shí)間（默認(rèn) 30 秒）
      connection-timeout: 30000
      # 空閑連接存活時(shí)間（默認(rèn) 10 分鐘）
      idle-timeout: 600000
      # 連接最大生命周期（默認(rèn) 30 分鐘）
      max-lifetime: 1800000
      # 空閑連接檢查間隔（默認(rèn)禁用）
      keepalive-time: 0
      # 初始化失敗超時(shí)（默認(rèn) 1 秒）
      initialization-fail-timeout: 1000
      # 驗(yàn)證連接超時(shí)（默認(rèn) 5 秒）
      validation-timeout: 5000

maximum-pool-size: 50

spring:
  datasource:
    hikari:
      maximum-pool-size: 100
      minimum-idle: 20
      idle-timeout: 300000
      max-lifetime: 1800000

@Configuration
public class HikariConfig {
    @Bean
    public DataSource dataSource() {
        HikariConfig config = new HikariConfig();
        config.setJdbcUrl("jdbc:mysql://localhost:3306/db");
        config.setUsername("root");
        config.setPassword("password");
        config.setMaximumPoolSize(100);
        config.setMinimumIdle(20);
        config.setConnectionTimeout(5000); // 縮短至 5s
        return new HikariDataSource(config);
    }
}

spring:
  datasource:
    hikari:
      initialization-fail-timeout: 1000
      connection-timeout: 1000
      minimum-idle: 5

spring:
  datasource:
    hikari:
      keepalive-time: 0

@Autowired
private DataSource dataSource;

public void monitor() {
    HikariDataSource hikariDS = (HikariDataSource) dataSource;
    HikariPoolMXBean poolMXBean = hikariDS.getHikariPoolMXBean();
    
    System.out.println("Active Connections: " + poolMXBean.getActiveConnections());
    System.out.println("Idle Connections: " + poolMXBean.getIdleConnections());
    System.out.println("Total Connections: " + poolMXBean.getTotalConnections());
}

spring:
  datasource:
    dynamic:
      primary: master
      strict: true
      datasource:
        master:
          url: jdbc:mysql://master:3306/db
          username: root
          password: root
        slave:
          url: jdbc:mysql://slave:3306/db
          username: root
          password: root
          lazy: true

@DS("slave")
public List<User> queryFromSlave() {
    return userMapper.selectAll();
}

spring:
  datasource:
    hikari:
      maximum-pool-size: 10
      connection-timeout: 30000

spring:
  datasource:
    hikari:
      maximum-pool-size: 200
      minimum-idle: 50
      connection-timeout: 5000
      idle-timeout: 300000
      max-lifetime: 1800000