Spring Boot使用執行緒池處理上萬條資料插入功能

@Configuration
@EnableAsync
public class ExecutorConfig {
    private static final Logger logger = LoggerFactory.getLogger(ExecutorConfig.class);
    @Value("${async.executor.thread.core_pool_size}")    
    private int corePoolSize;   
    
    @Value("${async.executor.thread.max_pool_size}")    
    private int maxPoolSize;   
    
    @Value("${async.executor.thread.queue_capacity}")  
    private int queueCapacity;   
    
    @Value("${async.executor.thread.name.prefix}")  
    private String namePrefix;
    @Bean(name = "asyncServiceExecutor")    
    public Executor asyncServiceExecutor() {   
        logger.info("start asyncServiceExecutor");    
        ThreadPoolTaskExecutor executor = new ThreadPoolTaskExecutor(); 
    
        //設定核心執行緒數       
        executor.setCorePoolSize(corePoolSize);   
    
        //設定最大執行緒數      
        executor.setMaxPoolSize(maxPoolSize);   
    
        //設定佇列大小     
        executor.setQueueCapacity(queueCapacity);    
    
        //設定執行緒池中的執行緒的名稱字首        
        executor.setThreadNamePrefix(namePrefix);
        // rejection-policy：當pool已經達到max size的時候，如何處理新任務        
        // CALLER_RUNS：不在新執行緒中執行任務，而是有呼叫者所在的執行緒來執行  
         
         executor.setRejectedExecutionHandler(new ThreadPoolExecutor.CallerRunsPolicy());     
        //執行初始化      
        executor.initialize();   
        return executor;  
     }
}

# 非同步執行緒設定
# 設定核心執行緒數
async.executor.thread.core_pool_size = 5
# 設定最大執行緒數
async.executor.thread.max_pool_size = 5
# 設定佇列大小
async.executor.thread.queue_capacity = 99999
# 設定執行緒池中的執行緒的名稱字首
async.executor.thread.name.prefix = async-service-

public interface AsyncService {   
    /**     
      * 執行非同步任務     
      * 可以根據需求，自己加引數擬定，我這裡就做個測試演示    
      */   
    void executeAsync();
}

@Service
public class AsyncServiceImpl implements AsyncService {  
    private static final Logger logger = LoggerFactory.getLogger(AsyncServiceImpl.class);
    @Override 
    @Async("asyncServiceExecutor")    
    public void executeAsync() {    
        logger.info("start executeAsync");
        System.out.println("非同步執行緒要做的事情");        
        System.out.println("可以在這裡執行批次插入等耗時的事情");
        logger.info("end executeAsync");   
    }
}

@Autowiredprivate 
AsyncService asyncService;

@GetMapping("/async")
public void async(){  
    asyncService.executeAsync();
}

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor;
import org.springframework.util.concurrent.ListenableFuture;
import java.util.concurrent.Callable;import java.util.concurrent.Future;import java.util.concurrent.ThreadPoolExecutor;
/** 
* @Author: 騰騰 
* @Date: 2022/7/16/0016 22:19 
*/
public class VisiableThreadPoolTaskExecutor extends ThreadPoolTaskExecutor {
    private static final Logger logger = LoggerFactory.getLogger(VisiableThreadPoolTaskExecutor.class);
    private void showThreadPoolInfo(String prefix) {        
        ThreadPoolExecutor threadPoolExecutor = getThreadPoolExecutor();
        if (null == threadPoolExecutor) {    
            return;  
        }
        logger.info("{}, {},taskCount [{}], completedTaskCount [{}], activeCount [{}], queueSize [{}]",                
        this.getThreadNamePrefix(),         
        prefix,           
        threadPoolExecutor.getTaskCount(),     
        threadPoolExecutor.getCompletedTaskCount(),  
        threadPoolExecutor.getActiveCount(),    
        threadPoolExecutor.getQueue().size());
     }
    @Override    
    public void execute(Runnable task) {    
        showThreadPoolInfo("1. do execute");       
        super.execute(task);   
    }
    @Override    
    public void execute(Runnable task, long startTimeout) {      
        showThreadPoolInfo("2. do execute");   
        super.execute(task, startTimeout);  
    }
    @Override  
    public Future<?> submit(Runnable task) {   
        showThreadPoolInfo("1. do submit");    
        return super.submit(task);   
    }
    @Override  
    public <T> Future<T> submit(Callable<T> task) {   
        showThreadPoolInfo("2. do submit");      
        return super.submit(task); 
    }
    @Override    
    public ListenableFuture<?> submitListenable(Runnable task) {    
        showThreadPoolInfo("1. do submitListenable");   
        return super.submitListenable(task);   
    }
    @Override
    public <T> ListenableFuture<T> submitListenable(Callable<T> task) {     
        showThreadPoolInfo("2. do submitListenable");     
        return super.submitListenable(task);  
    }
}

@Bean(name = "asyncServiceExecutor")    
public Executor asyncServiceExecutor() {  
    logger.info("start asyncServiceExecutor");  
    //在這裡修改       
    ThreadPoolTaskExecutor executor = new VisiableThreadPoolTaskExecutor();    
    //設定核心執行緒數     
    executor.setCorePoolSize(corePoolSize);  
    //設定最大執行緒數      
    executor.setMaxPoolSize(maxPoolSize);  
    //設定佇列大小      
    executor.setQueueCapacity(queueCapacity); 
    //設定執行緒池中的執行緒的名稱字首      
    executor.setThreadNamePrefix(namePrefix);
    
    // rejection-policy：當pool已經達到max size的時候，如何處理新任務      
    // CALLER_RUNS：不在新執行緒中執行任務，而是有呼叫者所在的執行緒來執行     
    executor.setRejectedExecutionHandler(new ThreadPoolExecutor.CallerRunsPolicy()); 
    //執行初始化       
    executor.initialize();       
    return executor; 
}