mysql连接池如何配置_PHP中配置mysql连接池的实现步骤

$dsn = 'mysql:host=localhost;dbname=testdb';
$username = 'root';
$password = 'password';
<p>try {
$pdo = new PDO($dsn, $username, $password, [
PDO::ATTR_PERSISTENT => true,
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);
} catch (PDOException $e) {
die("连接失败: " . $e->getMessage());
}</p>

<pre class="brush:php;toolbar:false;">use Swoole\Coroutine\MySQL;
use Swoole\Coroutine\Channel;
<p>class MysqlPool {
private $pool;</p><pre class="brush:php;toolbar:false;"><code>public function __construct($size = 10) {
    $this->pool = new Channel($size);
    for ($i = 0; $i < $size; $i++) {
        $mysql = new MySQL();
        $res = $mysql->connect([
            'host' => '127.0.0.1',
            'user' => 'root',
            'password' => 'password',
            'database' => 'testdb'
        ]);
        if ($res) {
            $this->pool->push($mysql);
        }
    }
}

public function get(): MySQL {
    return $this->pool->pop();
}

public function put(MySQL $mysql) {
    $this->pool->push($mysql);
}

$result = $mysql->query('SELECT * FROM users LIMIT 1');
var_dump($result);

$pool->put($mysql); // 归还连接