Swoole里在onWorkerStart 里创建mysql连接,怎么保持长连接不断连

Question

$db   = new swoole_mysql;
$serv = new swoole_http_server("127.0.0.1", 9501);

$serv->on('WorkerStart', function(swoole_server $server) {
    global $db;
    $db->connect($db->server, function($db, $r) {
        if ($r === false) {
            var_dump($db->connect_errno, $db->connect_error);
            die;
        }
    });
});
$serv->on('Request', function($request, $response) {
        global $db;
        $db->query($sql, function(swoole_mysql $db, $r) {
        ........
        });
}

过一段时间,mysql连接就close了,怎么才能永远不close?

---

解决了,加了定时器发送心跳

Answer 1

断线重连或者心跳机制都行

Answer 2

MySQL的连接池、异步、断线重连，官方文档
https://wiki.swoole.com/wiki/...