pm = static
pm.max_children = 5
pm.max_requests = 2
posix_getpid(),5 個 PID 循環復用。pm = dynamic
pm.max_children = 100 # 最大並發上限
pm.start_servers = 20 # 啟動預創建
pm.min_spare_servers = 10 # 閒置下限
pm.max_spare_servers = 30 # 閒置上限
; pm.max_requests = 500 # 可選:防洩漏
max_children。min_spare_servers。$conn = new mysqli("192.168.0.170", "user", "pass", "db");
close())。show processlist 見連接數:1→2→3→4→5→4→3... 隨 worker 生命週期波動。$conn = new mysqli("p:192.168.0.170", "user", "pass", "db"); // 注意 p: 前綴
show processlist 見 Command=Sleep 連接堆疊增長。MySQL server has gone away。function getPdo() {
static $pdo = null;
if ($pdo === null) {
$pdo = new PDO("mysql:host=192.168.0.170;dbname=db;charset=utf8mb4", "user", "pass", [
PDO::ATTR_PERSISTENT => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);
}
// 每次使用前心跳檢測
try { $pdo->query("SELECT 1"); }
catch (PDOException $e) { $pdo = null; return getPdo(); }
return $pdo;
}
[mysqld]
max_connections = 100 # 默認 151
測試場景:PHP-FPM max_children=200,MySQL max_connections=100 → 並發 100+ 即報 Too many connections。
max_connections ≥ (PHP-FPM 總 worker 數) × (並發請求中同時持有 DB 連接比例) + 保留量
建議:max_connections = 500-1000,配合連接池(ProxySQL、PHP mysqli 持久連接)複用。
mysql_ping() / SELECT 1 保活並檢測斷連。Threads_connected、Aborted_connects、Max_used_connections。long_query_time=1 + slow_query_log=ON,定期 pt-query-digest 分析。