php监控mysql数据库连接池

<?php
try {
    $pdo = new PDO('mysql:host=localhost;dbname=test', 'username', 'password');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 获取当前连接数
    $numConnections = $pdo->getAttribute(PDO::ATTR_CONNECTION_STATUS);
    echo "Current connections: " . $numConnections . "\n";

    // 监控连接池状态
    $poolStatus = $pdo->getAttribute(PDO::ATTR_POOL_STATUS);
    print_r($poolStatus);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

<?php
use Swoole\Database\PDOConfig;
use Swoole\Database\PDOPool;

$pool = new PDOPool((new PDOConfig)
    ->withHost('localhost')
    ->withPort(3306)
    ->withDbName('test')
    ->withCharset('utf8mb4')
    ->withUsername('username')
    ->withPassword('password'), 10);

$pool->on('create', function ($pool, $connection) {
    echo "Create connection\n";
});

$pool->on('close', function ($pool, $connection) {
    echo "Close connection\n";
});

$pool->get(function ($connection) {
    $result = $connection->query('SELECT * FROM table');
    var_dump($result->fetchAll());
});
?>