ENTRYPOINT ["java", \
  "-XX:+UseG1GC", \
  "-XX:MaxRAMPercentage=75.0", \
  "-XX:InitialRAMPercentage=50.0", \
  "-XX:+UseStringDeduplication", \
  "-Xlog:gc*:file=/app/logs/gc.log:time,uptime,level,tags", \
  "-jar", "app.jar"]

// Execução bem-sucedida

java -XX:+UseZGC \
     -XX:MaxRAMPercentage=75.0 \
     -XX:+ZGenerational \
     -Xlog:gc*:file=gc.log \
     -jar app.jar

// Comando executado com sucesso

spring:
  datasource:
    hikari:
      maximum-pool-size: 20
      minimum-idle: 20
      connection-timeout: 3000
      idle-timeout: 600000
      max-lifetime: 1800000
      leak-detection-threshold: 60000
      pool-name: OrderFlowHikariCP

A configuração entrou em vigor.

# Habilitar detecção de vazamento (aviso no log se conexão mantida > 60s)
spring:
  datasource:
    hikari:
      leak-detection-threshold: 60000

WARN  - Connection leak detection triggered for {conn-12345}
  Stack trace of the call site that acquired the connection:
    at com.orderflow.service.OrderService.getOrder(OrderService.java:45)
    ...

// RUIM: problema N+1
// 1 SQL para buscar 100 pedidos + 100 SQLs para buscar items de cada pedido = 101 SQLs!
List<Order> orders = orderRepository.findAll();
for (Order order : orders) {
    order.getItems().size();  // Dispara carregamento lazy para cada pedido
}

// Execução bem-sucedida

// BOM: Query única com JOIN FETCH
@Query("SELECT DISTINCT o FROM Order o JOIN FETCH o.items i JOIN FETCH i.product WHERE o.status = :status")
List<Order> findByStatusWithItems(@Param("status") String status);

// Execução bem-sucedida

@Entity
@NamedEntityGraph(
    name = "Order.withItemsAndProduct",
    attributeNodes = {
        @NamedAttributeNode("items"),
        @NamedAttributeNode(value = "items", subgraph = "item-product")
    },
    subgraphs = {
        @NamedSubgraph(name = "item-product", attributeNodes = @NamedAttributeNode("product"))
    }
)
public class Order { /* ... */ }

// Uso no Repository
@EntityGraph(value = "Order.withItemsAndProduct", type = EntityGraphType.LOAD)
List<Order> findByStatus(String status);

// Execução bem-sucedida

-- Índice para consultas por status de pedido
CREATE INDEX idx_order_status ON orders(status);

-- Índice composto para padrão de consulta comum
CREATE INDEX idx_order_status_created ON orders(status, created_at DESC);

-- Índice para busca de produtos
CREATE INDEX idx_product_name ON products(name);

-- Índice para lookup de produto nos items de pedido
CREATE INDEX idx_order_item_product ON order_items(product_id);

CREATE TABLE

-- Configuração do log de queries lentas do MySQL
SET GLOBAL slow_query_log = ON;
SET GLOBAL long_query_time = 1;  -- Log queries > 1 segundo
SET GLOBAL log_queries_not_using_indexes = ON;

-- Analisar plano de execução da query
EXPLAIN SELECT o.*, i.*
FROM orders o
JOIN order_items i ON o.id = i.order_id
WHERE o.status = 'PENDING'
  AND o.created_at > '2024-01-01'
ORDER BY o.created_at DESC
LIMIT 20;

CREATE TABLE

# application-prod.yml (otimizado)
spring:
  datasource:
    hikari:
      maximum-pool-size: 20
      minimum-idle: 20
      connection-timeout: 3000
      leak-detection-threshold: 60000
  jpa:
    hibernate:
      ddl-auto: validate
    show-sql: false
    properties:
      hibernate:
        default_batch_fetch_size: 100
        jdbc:
          batch_size: 50
        order_inserts: true
        order_updates: true

# Parâmetros JVM (Docker ENTRYPOINT)
java -XX:+UseG1GC \
     -XX:MaxRAMPercentage=75.0 \
     -XX:InitialRAMPercentage=50.0 \
     -XX:+UseStringDeduplication \
     -XX:MaxGCPauseMillis=100 \
     -Xlog:gc*:file=/app/logs/gc.log:time,uptime,level,tags \
     -jar app.jar

// OrderRepository otimizado com EntityGraph e busca em lote
public interface OrderRepository extends JpaRepository<Order, Long> {

    @EntityGraph(value = "Order.withItemsAndProduct", type = EntityGraphType.LOAD)
    @Query("SELECT o FROM Order o WHERE o.status = :status ORDER BY o.createdAt DESC")
    Page<Order> findByStatusPaged(@Param("status") String status, Pageable pageable);

    @EntityGraph(value = "Order.withItemsAndProduct", type = EntityGraphType.LOAD)
    Optional<Order> findById(Long id);
}

// Configuração de batch size do Hibernate elimina N+1 para coleções
// application.yml: hibernate.default_batch_fetch_size=100