perf(config): 调整数据库连接池和线程池配置以提升性能

Administrator

23 hours ago 1106f4c44727646193b2a481f6306a5315721c33

perf(config): 调整数据库连接池和线程池配置以提升性能

- 将HikariCP最大连接池大小从15增加到50
- 将HikariCP最小空闲连接数从5增加到10
- 将MVC异步任务执行器核心线程数从10增加到20
- 将MVC异步任务执行器最大线程数从50增加到100
- 将MVC异步任务执行器队列容量从300增加到500
- 将异步任务执行器核心线程数从5增加到10
- 将异步任务执行器最大线程数从20增加到50
- 将异步任务执行器队列容量从200增加到300

 src/main/java/cc/mrbird/febs/common/configure/FebsConfigure.java

@@ -38,9 +38,9 @@
    @Bean("mvcTaskExecutor")
    public ThreadPoolTaskExecutor mvcTaskExecutor() {
        ThreadPoolTaskExecutor executor = new ThreadPoolTaskExecutor();
        executor.setCorePoolSize(10);
        executor.setMaxPoolSize(50);
        executor.setQueueCapacity(300);
        executor.setCorePoolSize(20);
        executor.setMaxPoolSize(100);
        executor.setQueueCapacity(500);
        executor.setThreadNamePrefix("mvc-async-");
        executor.setWaitForTasksToCompleteOnShutdown(true);
        executor.setAwaitTerminationSeconds(60);
@@ -52,9 +52,9 @@
    @Bean(FebsConstant.ASYNC_POOL)
    public ThreadPoolTaskExecutor asyncThreadPoolTaskExecutor(){
        ThreadPoolTaskExecutor executor = new ThreadPoolTaskExecutor();
        executor.setCorePoolSize(5);
        executor.setMaxPoolSize(20);
        executor.setQueueCapacity(200);
        executor.setCorePoolSize(10);
        executor.setMaxPoolSize(50);
        executor.setQueueCapacity(300);
        executor.setKeepAliveSeconds(30);
        executor.setThreadNamePrefix("Febs-Async-Thread");
        executor.setWaitForTasksToCompleteOnShutdown(true);

 src/main/resources/application-dev.yml

@@ -6,8 +6,8 @@
      hikari:
        connection-timeout: 30000
        max-lifetime: 1800000
        max-pool-size: 15
        min-idle: 5
        max-pool-size: 50
        min-idle: 10
        connection-test-query: select 1
        pool-name: FebsHikariCP
      # 配置默认数据源

 src/main/resources/application-prod.yml

@@ -6,8 +6,8 @@
      hikari:
        connection-timeout: 30000
        max-lifetime: 1800000
        max-pool-size: 15
        min-idle: 5
        max-pool-size: 50
        min-idle: 10
        connection-test-query: select 1
        pool-name: FebsHikariCP
      # 配置默认数据源

 src/main/resources/application-test.yml

@@ -6,8 +6,8 @@
      hikari:
        connection-timeout: 30000
        max-lifetime: 1800000
        max-pool-size: 15
        min-idle: 5
        max-pool-size: 50
        min-idle: 10
        connection-test-query: select 1
        pool-name: FebsHikariCP
      # 配置默认数据源