Ensure `max_connections` Is Capacity-Planned and Monitored

낮음레벨 1수동 검토tdsql

설명

max_connections must be sized from instance capacity, per-connection memory, application pool limits, administrative reserve, and measured peak concurrency, and monitored with current and rejected connections.

점검 방법

감사 방식: 수동 검토

이 권장 사항은 자동으로 점검할 수 없습니다. --include-manual 옵션을 전달하면 스캔 결과에 이 지침과 함께 표시됩니다.

SHOW GLOBAL VARIABLES LIKE 'max_connections'; SHOW GLOBAL STATUS LIKE 'Max_used_connections'; SHOW GLOBAL STATUS LIKE 'Threads_connected'; SHOW GLOBAL STATUS LIKE 'Connection_errors_max_connections'; Review a representative peak period and confirm an approved capacity calculation, coordinated application/Gateway pool totals, an administrative reserve, and alerts for utilization and rejected connections.

조치 방법

조치 방식: 가이드 또는 인프라 패치

Calculate the approved limit from workload and memory evidence, coordinate application pool limits, and persist it through a TDSQL custom parameter template. Do not apply a generic value such as 2048 without capacity testing.

속성

운영 체제: 모두
태그: tdsqlavailability
참고 자료: CIS Tencent TDSQL 10.3.22 Benchmark v1.0.0 - 9.5 Ensure `max_connections` Is Capacity-Planned and Monitored