@GetMapping("/orders")
public List<Order> listOrders() {
    return orderDao.findAll(); 
}

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

spring:
  datasource:
    hikari:
      maximum-pool-size: ${CPU核心數(shù)*2} # 動(dòng)態(tài)調(diào)整
      minimum-idle: 5
      connection-timeout: 3000 # 3秒超時(shí)
      max-lifetime: 1800000 # 30分鐘
      idle-timeout: 600000 # 10分鐘空閑釋放

java -jar -Xms4g -Xmx4g 
-XX:NewRatio=1 
-XX:+UseG1GC 
-XX:MaxGCPauseMillis=200 
-XX:InitiatingHeapOccupancyPercent=35
-XX:+AlwaysPreTouch

@SpringBootApplication(exclude = {
    DataSourceAutoConfiguration.class,
    SecurityAutoConfiguration.class
})
public class Application {
    public static void main(String[] args) {
        SpringApplication.run(Application.class, args);
    }
}

server:
  compression:
    enabled: true
    mime-types: text/html,text/xml,text/plain,text/css,text/javascript,application/json
    min-response-size: 1024

@GetMapping("/products")
public PageResult<Product> list(
    @RequestParam @Max(value=100, message="頁(yè)大小不能超過(guò)100") int pageSize,
    @RequestParam @Min(1) int pageNum) {
    //...
}

@Async("taskExecutor")
public CompletableFuture<List<Order>> asyncProcess() {
    return CompletableFuture.completedFuture(heavyProcess());
}

@Bean("taskExecutor")
public Executor taskExecutor() {
    ThreadPoolTaskExecutor executor = new ThreadPoolTaskExecutor();
    executor.setCorePoolSize(5);
    executor.setMaxPoolSize(10);
    executor.setQueueCapacity(500);
    return executor;
}

@Cacheable(cacheNames = "products", key = "#id", 
           cacheManager = "caffeineCacheManager")
public Product getDetail(Long id) {
    return productDao.getById(id);
}

@Transactional
public void batchInsert(List<Product> products) {
    jdbcTemplate.batchUpdate(
        "INSERT INTO product(name,price) VALUES(?,?)",
        products,
        500, // 每批數(shù)量
        (ps, product) -> {
            ps.setString(1, product.getName());
            ps.setBigDecimal(2, product.getPrice());
        });
}

-- 商品表結(jié)構(gòu)
CREATE TABLE products (
    id BIGINT PRIMARY KEY,
    name VARCHAR(200),
    category VARCHAR(50),
    price DECIMAL(10,2),
    create_time DATETIME
);

-- 低效查詢
SELECT * FROM products 
WHERE category = '手機(jī)' 
AND price > 5000 
ORDER BY create_time DESC;

ALTER TABLE products 
ADD INDEX idx_category_price_create 
(category, price, create_time);

SELECT id, category, price, create_time 
FROM products 
WHERE category = '手機(jī)' 
AND price > 5000 
ORDER BY create_time DESC;

SELECT * FROM products 
WHERE DATE(create_time) = '2023-01-01';

SELECT * FROM products 
WHERE create_time BETWEEN '2023-01-01 00:00:00' 
AND '2023-01-01 23:59:59';

SELECT 
    index_name,
    rows_read,
    rows_selected 
FROM 
    sys.schema_index_statistics 
WHERE 
    table_name = 'products';

EXPLAIN FORMAT=JSON 
SELECT ...;

@Bean("customPool")
public Executor customThreadPool() {
    return new ThreadPoolExecutor(
        10, // 核心線程
        50, // 最大線程
        60, TimeUnit.SECONDS,
        new LinkedBlockingQueue<>(1000),
        new CustomThreadFactory(),
        new ThreadPoolExecutor.CallerRunsPolicy());
}

// 使用Sentinel實(shí)現(xiàn)接口限流
@SentinelResource(value = "orderQuery", 
                  blockHandler = "handleBlock",
                  fallback = "handleFallback")
@GetMapping("/orders/{id}")
public Order getOrder(@PathVariable Long id) {
    return orderService.getById(id);
}

// 限流處理
public Order handleBlock(Long id, BlockException ex) {
    throw new RuntimeException("服務(wù)繁忙，請(qǐng)稍后重試");
}

// 降級(jí)處理
public Order handleFallback(Long id, Throwable t) {
    return Order.getDefaultOrder();
}

# SpringBoot配置
management:
  endpoints:
    web:
      exposure:
        include: "*"
  metrics:
    export:
      prometheus:
        enabled: true